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);
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);
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:
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);
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;
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;
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);
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);
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:
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);
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;
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;