eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.RCI_UNMTG_RISKS_ETL_PKG dependencies on FND_GLOBAL

Line 21: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

17: -- File scope variables
18:
19: g_global_start_date DATE;
20: g_rci_schema VARCHAR2(30);
21: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
22: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
23:
24: -- Common Procedures (for initial and incremental load)
25:

Line 22: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

18:
19: g_global_start_date DATE;
20: g_rci_schema VARCHAR2(30);
21: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
22: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
23:
24: -- Common Procedures (for initial and incremental load)
25:
26: /**

Line 169: l_user_id := NVL(fnd_global.USER_ID, -1);

165: l_program_application_id NUMBER ;
166: l_request_id NUMBER ;
167:
168: BEGIN
169: l_user_id := NVL(fnd_global.USER_ID, -1);
170: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
171: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
172: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
173: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);

Line 170: l_login_id := NVL(fnd_global.LOGIN_ID, -1);

166: l_request_id NUMBER ;
167:
168: BEGIN
169: l_user_id := NVL(fnd_global.USER_ID, -1);
170: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
171: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
172: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
173: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
174: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);

Line 171: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);

167:
168: BEGIN
169: l_user_id := NVL(fnd_global.USER_ID, -1);
170: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
171: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
172: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
173: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
174: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
175:

Line 172: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);

168: BEGIN
169: l_user_id := NVL(fnd_global.USER_ID, -1);
170: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
171: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
172: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
173: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
174: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
175:
176:

Line 173: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);

169: l_user_id := NVL(fnd_global.USER_ID, -1);
170: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
171: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
172: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
173: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
174: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
175:
176:
177: l_stmnt_id := 0;

Line 174: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);

170: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
171: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
172: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
173: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
174: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
175:
176:
177: l_stmnt_id := 0;
178: l_proc_name := 'intitial_load';

Line 348: l_user_id := NVL(fnd_global.USER_ID, -1);

344: l_program_application_id NUMBER ;
345: l_request_id NUMBER ;
346:
347: BEGIN
348: l_user_id := NVL(fnd_global.USER_ID, -1);
349: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
350: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
351: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
352: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);

Line 349: l_login_id := NVL(fnd_global.LOGIN_ID, -1);

345: l_request_id NUMBER ;
346:
347: BEGIN
348: l_user_id := NVL(fnd_global.USER_ID, -1);
349: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
350: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
351: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
352: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
353: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);

Line 350: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);

346:
347: BEGIN
348: l_user_id := NVL(fnd_global.USER_ID, -1);
349: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
350: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
351: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
352: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
353: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
354:

Line 351: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);

347: BEGIN
348: l_user_id := NVL(fnd_global.USER_ID, -1);
349: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
350: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
351: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
352: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
353: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
354:
355:

Line 352: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);

348: l_user_id := NVL(fnd_global.USER_ID, -1);
349: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
350: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
351: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
352: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
353: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
354:
355:
356: l_stmnt_id := 0;

Line 353: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);

349: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
350: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
351: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
352: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
353: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
354:
355:
356: l_stmnt_id := 0;
357: l_proc_name := 'intitial_load';

Line 560: l_user_id := NVL(fnd_global.USER_ID, -1);

556: l_program_login_id NUMBER;
557: l_program_application_id NUMBER;
558: l_request_id NUMBER;
559: BEGIN
560: l_user_id := NVL(fnd_global.USER_ID, -1);
561: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
562: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
563: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
564: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);

Line 561: l_login_id := NVL(fnd_global.LOGIN_ID, -1);

557: l_program_application_id NUMBER;
558: l_request_id NUMBER;
559: BEGIN
560: l_user_id := NVL(fnd_global.USER_ID, -1);
561: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
562: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
563: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
564: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
565: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);

Line 562: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);

558: l_request_id NUMBER;
559: BEGIN
560: l_user_id := NVL(fnd_global.USER_ID, -1);
561: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
562: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
563: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
564: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
565: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
566:

Line 563: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);

559: BEGIN
560: l_user_id := NVL(fnd_global.USER_ID, -1);
561: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
562: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
563: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
564: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
565: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
566:
567: l_stmnt_id := 10;

Line 564: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);

560: l_user_id := NVL(fnd_global.USER_ID, -1);
561: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
562: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
563: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
564: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
565: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
566:
567: l_stmnt_id := 10;
568: l_proc_name := 'run_incr_load_drm';

Line 565: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);

561: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
562: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
563: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
564: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
565: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
566:
567: l_stmnt_id := 10;
568: l_proc_name := 'run_incr_load_drm';
569: l_last_run_date := get_last_run_date('RCI_ORG_CERT_RISKS_F');