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_ORG_CERT_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 243: l_user_id := NVL(fnd_global.USER_ID, -1);

239: l_processes_certified_w_issues number := 0 ;
240: l_processes_certified number := 0;
241: l_processes_not_certified number := 0;
242: BEGIN
243: l_user_id := NVL(fnd_global.USER_ID, -1);
244: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
245: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
246: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
247: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);

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

240: l_processes_certified number := 0;
241: l_processes_not_certified number := 0;
242: BEGIN
243: l_user_id := NVL(fnd_global.USER_ID, -1);
244: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
245: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
246: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
247: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
248: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);

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

241: l_processes_not_certified number := 0;
242: BEGIN
243: l_user_id := NVL(fnd_global.USER_ID, -1);
244: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
245: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
246: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
247: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
248: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
249:

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

242: BEGIN
243: l_user_id := NVL(fnd_global.USER_ID, -1);
244: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
245: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
246: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
247: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
248: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
249:
250: ----dbms_output.put_line( '1 **************' );

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

243: l_user_id := NVL(fnd_global.USER_ID, -1);
244: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
245: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
246: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
247: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
248: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
249:
250: ----dbms_output.put_line( '1 **************' );
251:

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

244: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
245: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
246: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
247: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
248: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
249:
250: ----dbms_output.put_line( '1 **************' );
251:
252: l_stmnt_id := 0;

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

506: l_program_application_id NUMBER ;
507: l_request_id NUMBER ;
508:
509: BEGIN
510: l_user_id := NVL(fnd_global.USER_ID, -1);
511: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
512: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
513: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
514: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);

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

507: l_request_id NUMBER ;
508:
509: BEGIN
510: l_user_id := NVL(fnd_global.USER_ID, -1);
511: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
512: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
513: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
514: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
515: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);

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

508:
509: BEGIN
510: l_user_id := NVL(fnd_global.USER_ID, -1);
511: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
512: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
513: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
514: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
515: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
516:

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

509: BEGIN
510: l_user_id := NVL(fnd_global.USER_ID, -1);
511: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
512: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
513: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
514: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
515: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
516:
517: ----dbms_output.put_line( '1 **************' );

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

510: l_user_id := NVL(fnd_global.USER_ID, -1);
511: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
512: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
513: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
514: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
515: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
516:
517: ----dbms_output.put_line( '1 **************' );
518:

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

511: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
512: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
513: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
514: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
515: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
516:
517: ----dbms_output.put_line( '1 **************' );
518:
519: l_stmnt_id := 0;

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

785: l_processes_certified_w_issues number := 0 ;
786: l_processes_certified number := 0;
787: l_processes_not_certified number := 0;
788: BEGIN
789: l_user_id := NVL(fnd_global.USER_ID, -1);
790: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
791: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
792: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
793: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);

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

786: l_processes_certified number := 0;
787: l_processes_not_certified number := 0;
788: BEGIN
789: l_user_id := NVL(fnd_global.USER_ID, -1);
790: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
791: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
792: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
793: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
794: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);

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

787: l_processes_not_certified number := 0;
788: BEGIN
789: l_user_id := NVL(fnd_global.USER_ID, -1);
790: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
791: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
792: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
793: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
794: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
795:

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

788: BEGIN
789: l_user_id := NVL(fnd_global.USER_ID, -1);
790: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
791: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
792: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
793: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
794: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
795:
796: l_stmnt_id := 10;

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

789: l_user_id := NVL(fnd_global.USER_ID, -1);
790: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
791: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
792: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
793: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
794: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
795:
796: l_stmnt_id := 10;
797: l_proc_name := 'run_incr_load_drm';

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

790: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
791: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
792: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
793: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
794: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
795:
796: l_stmnt_id := 10;
797: l_proc_name := 'run_incr_load_drm';
798: l_last_run_date := get_last_run_date('RCI_ORG_CERT_SUMM_F');

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

1027: l_unmitigated_risks number;
1028: l_open_issues number;
1029:
1030: BEGIN
1031: l_user_id := NVL(fnd_global.USER_ID, -1);
1032: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
1033: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
1034: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
1035: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);

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

1028: l_open_issues number;
1029:
1030: BEGIN
1031: l_user_id := NVL(fnd_global.USER_ID, -1);
1032: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
1033: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
1034: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
1035: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
1036: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);

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

1029:
1030: BEGIN
1031: l_user_id := NVL(fnd_global.USER_ID, -1);
1032: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
1033: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
1034: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
1035: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
1036: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
1037:

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

1030: BEGIN
1031: l_user_id := NVL(fnd_global.USER_ID, -1);
1032: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
1033: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
1034: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
1035: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
1036: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
1037:
1038: l_stmnt_id := 10;

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

1031: l_user_id := NVL(fnd_global.USER_ID, -1);
1032: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
1033: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
1034: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
1035: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
1036: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
1037:
1038: l_stmnt_id := 10;
1039: l_proc_name := 'run_incr_load_drm';

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

1032: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
1033: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
1034: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
1035: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
1036: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
1037:
1038: l_stmnt_id := 10;
1039: l_proc_name := 'run_incr_load_drm';
1040: l_last_run_date := get_last_run_date('RCI_ORG_CERT_SUMM_F');