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_PROC_DETAIL_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: -- Common Procedures Definitions

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

232: l_program_application_id NUMBER ;
233: l_request_id NUMBER ;
234:
235: BEGIN
236: l_user_id := NVL(fnd_global.USER_ID, -1);
237: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
238: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
239: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
240: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);

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

233: l_request_id NUMBER ;
234:
235: BEGIN
236: l_user_id := NVL(fnd_global.USER_ID, -1);
237: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
238: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
239: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
240: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
241: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);

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

234:
235: BEGIN
236: l_user_id := NVL(fnd_global.USER_ID, -1);
237: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
238: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
239: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
240: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
241: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
242:

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

235: BEGIN
236: l_user_id := NVL(fnd_global.USER_ID, -1);
237: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
238: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
239: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
240: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
241: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
242:
243: ----dbms_output.put_line( '1 **************' );

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

236: l_user_id := NVL(fnd_global.USER_ID, -1);
237: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
238: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
239: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
240: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
241: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
242:
243: ----dbms_output.put_line( '1 **************' );
244:

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

237: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
238: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
239: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
240: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
241: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
242:
243: ----dbms_output.put_line( '1 **************' );
244:
245: l_stmnt_id := 0;

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

429: l_program_application_id NUMBER ;
430: l_request_id NUMBER ;
431:
432: BEGIN
433: l_user_id := NVL(fnd_global.USER_ID, -1);
434: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
435: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
436: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
437: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);

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

430: l_request_id NUMBER ;
431:
432: BEGIN
433: l_user_id := NVL(fnd_global.USER_ID, -1);
434: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
435: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
436: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
437: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
438: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);

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

431:
432: BEGIN
433: l_user_id := NVL(fnd_global.USER_ID, -1);
434: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
435: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
436: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
437: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
438: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
439:

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

432: BEGIN
433: l_user_id := NVL(fnd_global.USER_ID, -1);
434: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
435: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
436: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
437: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
438: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
439:
440: ----dbms_output.put_line( '1 **************' );

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

433: l_user_id := NVL(fnd_global.USER_ID, -1);
434: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
435: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
436: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
437: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
438: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
439:
440: ----dbms_output.put_line( '1 **************' );
441:

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

434: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
435: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
436: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
437: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
438: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
439:
440: ----dbms_output.put_line( '1 **************' );
441:
442: l_stmnt_id := 0;

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

641: l_unmitigated_risks number;
642: l_open_issues number;
643:
644: BEGIN
645: l_user_id := NVL(fnd_global.USER_ID, -1);
646: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
647: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
648: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
649: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);

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

642: l_open_issues number;
643:
644: BEGIN
645: l_user_id := NVL(fnd_global.USER_ID, -1);
646: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
647: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
648: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
649: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
650: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);

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

643:
644: BEGIN
645: l_user_id := NVL(fnd_global.USER_ID, -1);
646: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
647: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
648: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
649: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
650: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
651:

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

644: BEGIN
645: l_user_id := NVL(fnd_global.USER_ID, -1);
646: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
647: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
648: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
649: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
650: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
651:
652: l_stmnt_id := 10;

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

645: l_user_id := NVL(fnd_global.USER_ID, -1);
646: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
647: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
648: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
649: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
650: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
651:
652: l_stmnt_id := 10;
653: l_proc_name := 'run_incr_load_drm';

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

646: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
647: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
648: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
649: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
650: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
651:
652: l_stmnt_id := 10;
653: l_proc_name := 'run_incr_load_drm';
654: l_last_run_date := get_last_run_date('RCI_PROCESS_DETAIL_F');

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

827: l_unmitigated_risks number;
828: l_open_issues number;
829:
830: BEGIN
831: l_user_id := NVL(fnd_global.USER_ID, -1);
832: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
833: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
834: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
835: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);

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

828: l_open_issues number;
829:
830: BEGIN
831: l_user_id := NVL(fnd_global.USER_ID, -1);
832: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
833: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
834: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
835: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
836: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);

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

829:
830: BEGIN
831: l_user_id := NVL(fnd_global.USER_ID, -1);
832: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
833: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
834: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
835: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
836: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
837:

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

830: BEGIN
831: l_user_id := NVL(fnd_global.USER_ID, -1);
832: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
833: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
834: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
835: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
836: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
837:
838: l_stmnt_id := 10;

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

831: l_user_id := NVL(fnd_global.USER_ID, -1);
832: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
833: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
834: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
835: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
836: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
837:
838: l_stmnt_id := 10;
839: l_proc_name := 'run_incr_load_drm';

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

832: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
833: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
834: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
835: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
836: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
837:
838: l_stmnt_id := 10;
839: l_proc_name := 'run_incr_load_drm';
840: l_last_run_date := get_last_run_date('RCI_PROCESS_DETAIL_F');