Multi-Org switching

When you want to process multi-org records within your code dynamically then use Fnd_Global.Apps_Initialize. It will switch from one org to another.

procedure APPS_INITIALIZE(user_id in number,
resp_id in number,
resp_appl_id in number);

USER_ID : The USER_ID number
RESP_ID : The ID number of the responsibility
RESP_APPL_ID : The ID number of the application to which the responsibility belongs


Fnd_Global.Apps_Initialize (108, 50529, 222);