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

173:
174: /** 12.12.2005 npanandi: bug 4862301 fix for keyControl **/
175: l_key_control varchar2(2);
176: BEGIN
177: l_user_id := NVL(fnd_global.USER_ID, -1);
178: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
179: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
180: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
181: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);

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

174: /** 12.12.2005 npanandi: bug 4862301 fix for keyControl **/
175: l_key_control varchar2(2);
176: BEGIN
177: l_user_id := NVL(fnd_global.USER_ID, -1);
178: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
179: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
180: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
181: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
182: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);

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

175: l_key_control varchar2(2);
176: BEGIN
177: l_user_id := NVL(fnd_global.USER_ID, -1);
178: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
179: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
180: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
181: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
182: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
183:

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

176: BEGIN
177: l_user_id := NVL(fnd_global.USER_ID, -1);
178: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
179: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
180: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
181: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
182: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
183:
184: ----dbms_output.put_line( '1 **************' );

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

177: l_user_id := NVL(fnd_global.USER_ID, -1);
178: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
179: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
180: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
181: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
182: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
183:
184: ----dbms_output.put_line( '1 **************' );
185:

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

178: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
179: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
180: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
181: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
182: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
183:
184: ----dbms_output.put_line( '1 **************' );
185:
186: l_stmnt_id := 0;

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

516:
517: /** 12.12.2005 npanandi: bug 4862301 fix for keyControl **/
518: l_key_control varchar2(2);
519: BEGIN
520: l_user_id := NVL(fnd_global.USER_ID, -1);
521: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
522: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
523: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
524: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);

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

517: /** 12.12.2005 npanandi: bug 4862301 fix for keyControl **/
518: l_key_control varchar2(2);
519: BEGIN
520: l_user_id := NVL(fnd_global.USER_ID, -1);
521: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
522: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
523: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
524: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
525: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);

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

518: l_key_control varchar2(2);
519: BEGIN
520: l_user_id := NVL(fnd_global.USER_ID, -1);
521: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
522: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
523: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
524: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
525: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
526:

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

519: BEGIN
520: l_user_id := NVL(fnd_global.USER_ID, -1);
521: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
522: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
523: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
524: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
525: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
526:
527: ----dbms_output.put_line( '1 **************' );

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

520: l_user_id := NVL(fnd_global.USER_ID, -1);
521: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
522: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
523: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
524: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
525: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
526:
527: ----dbms_output.put_line( '1 **************' );
528:

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

521: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
522: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
523: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
524: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
525: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
526:
527: ----dbms_output.put_line( '1 **************' );
528:
529: l_stmnt_id := 0;

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

786:
787: /** 12.12.2005 npanandi: bug 4862301 fix for keyControl **/
788: l_key_control varchar2(2);
789: BEGIN
790: l_user_id := NVL(fnd_global.USER_ID, -1);
791: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
792: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
793: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
794: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);

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

787: /** 12.12.2005 npanandi: bug 4862301 fix for keyControl **/
788: l_key_control varchar2(2);
789: BEGIN
790: l_user_id := NVL(fnd_global.USER_ID, -1);
791: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
792: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
793: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
794: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
795: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);

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

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

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

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

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

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

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

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

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

1042:
1043: /** 12.12.2005 npanandi: bug 4862301 fix for keyControl **/
1044: l_key_control varchar2(2);
1045: BEGIN
1046: l_user_id := NVL(fnd_global.USER_ID, -1);
1047: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
1048: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
1049: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
1050: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);

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

1043: /** 12.12.2005 npanandi: bug 4862301 fix for keyControl **/
1044: l_key_control varchar2(2);
1045: BEGIN
1046: l_user_id := NVL(fnd_global.USER_ID, -1);
1047: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
1048: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
1049: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
1050: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
1051: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);

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

1044: l_key_control varchar2(2);
1045: BEGIN
1046: l_user_id := NVL(fnd_global.USER_ID, -1);
1047: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
1048: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
1049: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
1050: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
1051: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
1052:

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

1045: BEGIN
1046: l_user_id := NVL(fnd_global.USER_ID, -1);
1047: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
1048: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
1049: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
1050: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
1051: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
1052:
1053: l_stmnt_id := 10;

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

1046: l_user_id := NVL(fnd_global.USER_ID, -1);
1047: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
1048: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
1049: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
1050: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
1051: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
1052:
1053: l_stmnt_id := 10;
1054: l_proc_name := 'run_incr_load_drm';

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

1047: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
1048: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
1049: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
1050: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
1051: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
1052:
1053: l_stmnt_id := 10;
1054: l_proc_name := 'run_incr_load_drm';
1055: l_last_run_date := get_last_run_date('RCI_ORG_PROC_DFCY_F');