15: G_COMPLETE CONSTANT VARCHAR2(30) := 'COMPLETE';
16: -------------------
17: -- GLOBAL VARIABLES
18: -------------------
19: G_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
20: G_appl_id NUMBER := FND_GLOBAL.PROG_APPL_ID;
21: G_program_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
22: G_user_id NUMBER := FND_GLOBAL.USER_ID;
23: G_login_id NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
16: -------------------
17: -- GLOBAL VARIABLES
18: -------------------
19: G_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
20: G_appl_id NUMBER := FND_GLOBAL.PROG_APPL_ID;
21: G_program_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
22: G_user_id NUMBER := FND_GLOBAL.USER_ID;
23: G_login_id NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
24: G_org_id NUMBER := mo_global.get_current_org_id; -- MOAC Changes TO_NUMBER(FND_PROFILE.value('ORG_ID'));
17: -- GLOBAL VARIABLES
18: -------------------
19: G_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
20: G_appl_id NUMBER := FND_GLOBAL.PROG_APPL_ID;
21: G_program_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
22: G_user_id NUMBER := FND_GLOBAL.USER_ID;
23: G_login_id NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
24: G_org_id NUMBER := mo_global.get_current_org_id; -- MOAC Changes TO_NUMBER(FND_PROFILE.value('ORG_ID'));
25:
18: -------------------
19: G_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
20: G_appl_id NUMBER := FND_GLOBAL.PROG_APPL_ID;
21: G_program_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
22: G_user_id NUMBER := FND_GLOBAL.USER_ID;
23: G_login_id NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
24: G_org_id NUMBER := mo_global.get_current_org_id; -- MOAC Changes TO_NUMBER(FND_PROFILE.value('ORG_ID'));
25:
26: ---------------------------
19: G_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
20: G_appl_id NUMBER := FND_GLOBAL.PROG_APPL_ID;
21: G_program_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
22: G_user_id NUMBER := FND_GLOBAL.USER_ID;
23: G_login_id NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
24: G_org_id NUMBER := mo_global.get_current_org_id; -- MOAC Changes TO_NUMBER(FND_PROFILE.value('ORG_ID'));
25:
26: ---------------------------
27: -- PROCEDURES AND FUNCTIONS