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.

[Home] [Help]

APPS.RCI_CTRL_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: /**

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: l_stmnt_id := 0;

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: l_stmnt_id := 0;
177: l_proc_name := 'intitial_load';

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: l_stmnt_id := 0;
177: l_proc_name := 'intitial_load';
178: check_initial_load_setup(

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

354: l_program_application_id NUMBER ;
355: l_request_id NUMBER ;
356:
357: BEGIN
358: l_user_id := NVL(fnd_global.USER_ID, -1);
359: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
360: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
361: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
362: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);

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

355: l_request_id NUMBER ;
356:
357: BEGIN
358: l_user_id := NVL(fnd_global.USER_ID, -1);
359: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
360: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
361: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
362: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
363: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);

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

356:
357: BEGIN
358: l_user_id := NVL(fnd_global.USER_ID, -1);
359: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
360: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
361: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
362: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
363: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
364:

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

357: BEGIN
358: l_user_id := NVL(fnd_global.USER_ID, -1);
359: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
360: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
361: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
362: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
363: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
364:
365: l_stmnt_id := 0;

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

358: l_user_id := NVL(fnd_global.USER_ID, -1);
359: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
360: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
361: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
362: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
363: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
364:
365: l_stmnt_id := 0;
366: l_proc_name := 'intitial_load';

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

359: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
360: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
361: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
362: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
363: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
364:
365: l_stmnt_id := 0;
366: l_proc_name := 'intitial_load';
367: check_initial_load_setup(

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

568: l_program_login_id NUMBER;
569: l_program_application_id NUMBER;
570: l_request_id NUMBER;
571: BEGIN
572: l_user_id := NVL(fnd_global.USER_ID, -1);
573: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
574: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
575: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
576: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);

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

569: l_program_application_id NUMBER;
570: l_request_id NUMBER;
571: BEGIN
572: l_user_id := NVL(fnd_global.USER_ID, -1);
573: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
574: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
575: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
576: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
577: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);

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

570: l_request_id NUMBER;
571: BEGIN
572: l_user_id := NVL(fnd_global.USER_ID, -1);
573: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
574: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
575: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
576: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
577: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
578:

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

571: BEGIN
572: l_user_id := NVL(fnd_global.USER_ID, -1);
573: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
574: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
575: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
576: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
577: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
578:
579: l_stmnt_id := 10;

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

572: l_user_id := NVL(fnd_global.USER_ID, -1);
573: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
574: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
575: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
576: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
577: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
578:
579: l_stmnt_id := 10;
580: l_proc_name := 'run_incr_load_drm';

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

573: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
574: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
575: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
576: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
577: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
578:
579: l_stmnt_id := 10;
580: l_proc_name := 'run_incr_load_drm';
581: l_last_run_date := get_last_run_date('RCI_ORG_CERT_CTRLS_F');

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

745: l_program_login_id NUMBER;
746: l_program_application_id NUMBER;
747: l_request_id NUMBER;
748: BEGIN
749: l_user_id := NVL(fnd_global.USER_ID, -1);
750: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
751: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
752: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
753: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);

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

746: l_program_application_id NUMBER;
747: l_request_id NUMBER;
748: BEGIN
749: l_user_id := NVL(fnd_global.USER_ID, -1);
750: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
751: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
752: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
753: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
754: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);

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

747: l_request_id NUMBER;
748: BEGIN
749: l_user_id := NVL(fnd_global.USER_ID, -1);
750: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
751: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
752: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
753: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
754: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
755:

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

748: BEGIN
749: l_user_id := NVL(fnd_global.USER_ID, -1);
750: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
751: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
752: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
753: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
754: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
755:
756: l_stmnt_id := 10;

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

749: l_user_id := NVL(fnd_global.USER_ID, -1);
750: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
751: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
752: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
753: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
754: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
755:
756: l_stmnt_id := 10;
757: l_proc_name := 'run_incr_load_drm';

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

750: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
751: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
752: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
753: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
754: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
755:
756: l_stmnt_id := 10;
757: l_proc_name := 'run_incr_load_drm';
758: l_last_run_date := get_last_run_date('RCI_ORG_CERT_CTRLS_F');