DBA Data[Home] [Help]

APPS.ISC_DEPOT_MTTR_ETL_PKG dependencies on FND_GLOBAL

Line 28: l_user_id constant number := nvl(fnd_global.user_id,-1);

24: l_proc_name constant varchar2(30) := 'initial_load';
25: l_isc_schema varchar2(30);
26: l_err_msg varchar2(200);
27:
28: l_user_id constant number := nvl(fnd_global.user_id,-1);
29: l_login_id constant number := nvl(fnd_global.login_id,-1);
30: l_program_id constant number := nvl(fnd_global.conc_program_id,-1);
31: l_program_login_id constant number := nvl(fnd_global.conc_login_id,-1);
32: l_program_application_id constant number := nvl(fnd_global.prog_appl_id,-1);

Line 29: l_login_id constant number := nvl(fnd_global.login_id,-1);

25: l_isc_schema varchar2(30);
26: l_err_msg varchar2(200);
27:
28: l_user_id constant number := nvl(fnd_global.user_id,-1);
29: l_login_id constant number := nvl(fnd_global.login_id,-1);
30: l_program_id constant number := nvl(fnd_global.conc_program_id,-1);
31: l_program_login_id constant number := nvl(fnd_global.conc_login_id,-1);
32: l_program_application_id constant number := nvl(fnd_global.prog_appl_id,-1);
33: l_request_id constant number := nvl(fnd_global.conc_request_id,-1);

Line 30: l_program_id constant number := nvl(fnd_global.conc_program_id,-1);

26: l_err_msg varchar2(200);
27:
28: l_user_id constant number := nvl(fnd_global.user_id,-1);
29: l_login_id constant number := nvl(fnd_global.login_id,-1);
30: l_program_id constant number := nvl(fnd_global.conc_program_id,-1);
31: l_program_login_id constant number := nvl(fnd_global.conc_login_id,-1);
32: l_program_application_id constant number := nvl(fnd_global.prog_appl_id,-1);
33: l_request_id constant number := nvl(fnd_global.conc_request_id,-1);
34:

Line 31: l_program_login_id constant number := nvl(fnd_global.conc_login_id,-1);

27:
28: l_user_id constant number := nvl(fnd_global.user_id,-1);
29: l_login_id constant number := nvl(fnd_global.login_id,-1);
30: l_program_id constant number := nvl(fnd_global.conc_program_id,-1);
31: l_program_login_id constant number := nvl(fnd_global.conc_login_id,-1);
32: l_program_application_id constant number := nvl(fnd_global.prog_appl_id,-1);
33: l_request_id constant number := nvl(fnd_global.conc_request_id,-1);
34:
35: l_message varchar2(32000);

Line 32: l_program_application_id constant number := nvl(fnd_global.prog_appl_id,-1);

28: l_user_id constant number := nvl(fnd_global.user_id,-1);
29: l_login_id constant number := nvl(fnd_global.login_id,-1);
30: l_program_id constant number := nvl(fnd_global.conc_program_id,-1);
31: l_program_login_id constant number := nvl(fnd_global.conc_login_id,-1);
32: l_program_application_id constant number := nvl(fnd_global.prog_appl_id,-1);
33: l_request_id constant number := nvl(fnd_global.conc_request_id,-1);
34:
35: l_message varchar2(32000);
36: l_exception exception;

Line 33: l_request_id constant number := nvl(fnd_global.conc_request_id,-1);

29: l_login_id constant number := nvl(fnd_global.login_id,-1);
30: l_program_id constant number := nvl(fnd_global.conc_program_id,-1);
31: l_program_login_id constant number := nvl(fnd_global.conc_login_id,-1);
32: l_program_application_id constant number := nvl(fnd_global.prog_appl_id,-1);
33: l_request_id constant number := nvl(fnd_global.conc_request_id,-1);
34:
35: l_message varchar2(32000);
36: l_exception exception;
37: l_temp_rowcount number;

Line 402: l_user_id constant number := nvl(fnd_global.user_id,-1);

398: l_proc_name constant varchar2(30) := 'incr_load';
399: l_last_run_date date;
400: l_err_msg varchar2(200);
401:
402: l_user_id constant number := nvl(fnd_global.user_id,-1);
403: l_login_id constant number := nvl(fnd_global.login_id,-1);
404: l_program_id constant number := nvl(fnd_global.conc_program_id,-1);
405: l_program_login_id constant number := nvl(fnd_global.conc_login_id,-1);
406: l_program_application_id constant number := nvl(fnd_global.prog_appl_id,-1);

Line 403: l_login_id constant number := nvl(fnd_global.login_id,-1);

399: l_last_run_date date;
400: l_err_msg varchar2(200);
401:
402: l_user_id constant number := nvl(fnd_global.user_id,-1);
403: l_login_id constant number := nvl(fnd_global.login_id,-1);
404: l_program_id constant number := nvl(fnd_global.conc_program_id,-1);
405: l_program_login_id constant number := nvl(fnd_global.conc_login_id,-1);
406: l_program_application_id constant number := nvl(fnd_global.prog_appl_id,-1);
407: l_request_id constant number := nvl(fnd_global.conc_request_id,-1);

Line 404: l_program_id constant number := nvl(fnd_global.conc_program_id,-1);

400: l_err_msg varchar2(200);
401:
402: l_user_id constant number := nvl(fnd_global.user_id,-1);
403: l_login_id constant number := nvl(fnd_global.login_id,-1);
404: l_program_id constant number := nvl(fnd_global.conc_program_id,-1);
405: l_program_login_id constant number := nvl(fnd_global.conc_login_id,-1);
406: l_program_application_id constant number := nvl(fnd_global.prog_appl_id,-1);
407: l_request_id constant number := nvl(fnd_global.conc_request_id,-1);
408:

Line 405: l_program_login_id constant number := nvl(fnd_global.conc_login_id,-1);

401:
402: l_user_id constant number := nvl(fnd_global.user_id,-1);
403: l_login_id constant number := nvl(fnd_global.login_id,-1);
404: l_program_id constant number := nvl(fnd_global.conc_program_id,-1);
405: l_program_login_id constant number := nvl(fnd_global.conc_login_id,-1);
406: l_program_application_id constant number := nvl(fnd_global.prog_appl_id,-1);
407: l_request_id constant number := nvl(fnd_global.conc_request_id,-1);
408:
409: l_message varchar2(32000);

Line 406: l_program_application_id constant number := nvl(fnd_global.prog_appl_id,-1);

402: l_user_id constant number := nvl(fnd_global.user_id,-1);
403: l_login_id constant number := nvl(fnd_global.login_id,-1);
404: l_program_id constant number := nvl(fnd_global.conc_program_id,-1);
405: l_program_login_id constant number := nvl(fnd_global.conc_login_id,-1);
406: l_program_application_id constant number := nvl(fnd_global.prog_appl_id,-1);
407: l_request_id constant number := nvl(fnd_global.conc_request_id,-1);
408:
409: l_message varchar2(32000);
410: l_exception exception;

Line 407: l_request_id constant number := nvl(fnd_global.conc_request_id,-1);

403: l_login_id constant number := nvl(fnd_global.login_id,-1);
404: l_program_id constant number := nvl(fnd_global.conc_program_id,-1);
405: l_program_login_id constant number := nvl(fnd_global.conc_login_id,-1);
406: l_program_application_id constant number := nvl(fnd_global.prog_appl_id,-1);
407: l_request_id constant number := nvl(fnd_global.conc_request_id,-1);
408:
409: l_message varchar2(32000);
410: l_exception exception;
411: l_temp_rowcount number;