DBA Data[Home] [Help]

APPS.RCI_COMPL_ENV_CHG_SUMM_PKG dependencies on FND_GLOBAL

Line 18: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

14:
15: -- File scope variables
16: g_global_start_date DATE;
17: g_rci_schema VARCHAR2(30);
18: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
19: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
20:
21: /*** 12.09.2005 npanandi: added below procedure ***/
22: PROCEDURE check_initial_load_setup (

Line 19: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

15: -- File scope variables
16: g_global_start_date DATE;
17: g_rci_schema VARCHAR2(30);
18: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
19: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
20:
21: /*** 12.09.2005 npanandi: added below procedure ***/
22: PROCEDURE check_initial_load_setup (
23: x_global_start_date OUT NOCOPY DATE

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

141:
142: l_significant_process varchar2(1);
143: l_key_control varchar2(1);
144: begin
145: l_user_id := NVL(fnd_global.USER_ID, -1);
146: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
147: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
148: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
149: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);

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

142: l_significant_process varchar2(1);
143: l_key_control varchar2(1);
144: begin
145: l_user_id := NVL(fnd_global.USER_ID, -1);
146: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
147: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
148: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
149: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
150: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);

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

143: l_key_control varchar2(1);
144: begin
145: l_user_id := NVL(fnd_global.USER_ID, -1);
146: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
147: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
148: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
149: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
150: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
151:

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

144: begin
145: l_user_id := NVL(fnd_global.USER_ID, -1);
146: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
147: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
148: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
149: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
150: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
151:
152: ----dbms_output.put_line( '1 **************' );

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

145: l_user_id := NVL(fnd_global.USER_ID, -1);
146: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
147: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
148: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
149: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
150: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
151:
152: ----dbms_output.put_line( '1 **************' );
153:

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

146: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
147: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
148: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
149: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
150: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
151:
152: ----dbms_output.put_line( '1 **************' );
153:
154: l_stmnt_id := 0;

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

384: initial_load(
385: errbuf => errbuf
386: ,retcode => retcode);
387: ***/
388: l_user_id := NVL(fnd_global.USER_ID, -1);
389: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
390: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
391: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
392: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);

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

385: errbuf => errbuf
386: ,retcode => retcode);
387: ***/
388: l_user_id := NVL(fnd_global.USER_ID, -1);
389: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
390: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
391: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
392: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
393: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);

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

386: ,retcode => retcode);
387: ***/
388: l_user_id := NVL(fnd_global.USER_ID, -1);
389: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
390: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
391: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
392: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
393: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
394:

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

387: ***/
388: l_user_id := NVL(fnd_global.USER_ID, -1);
389: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
390: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
391: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
392: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
393: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
394:
395: l_stmnt_id := 10;

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

388: l_user_id := NVL(fnd_global.USER_ID, -1);
389: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
390: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
391: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
392: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
393: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
394:
395: l_stmnt_id := 10;
396: l_proc_name := 'run_incr_load_drm';

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

389: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
390: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
391: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
392: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
393: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
394:
395: l_stmnt_id := 10;
396: l_proc_name := 'run_incr_load_drm';
397: l_last_run_date := get_last_run_date('RCI_COMPL_ENV_CHG_SUMM_F');