260: l_run_date date;
261: l_proc_name constant varchar2(30) := 'intitial_load';
262: l_master_org number;
263:
264: l_user_id constant number := nvl(fnd_global.user_id,-1);
265: l_login_id constant number := nvl(fnd_global.login_id,-1);
266: l_program_id constant number := nvl(fnd_global.conc_program_id,-1);
267: l_program_login_id constant number := nvl(fnd_global.conc_login_id,-1);
268: l_program_application_id constant number := nvl(fnd_global.prog_appl_id,-1);
261: l_proc_name constant varchar2(30) := 'intitial_load';
262: l_master_org number;
263:
264: l_user_id constant number := nvl(fnd_global.user_id,-1);
265: l_login_id constant number := nvl(fnd_global.login_id,-1);
266: l_program_id constant number := nvl(fnd_global.conc_program_id,-1);
267: l_program_login_id constant number := nvl(fnd_global.conc_login_id,-1);
268: l_program_application_id constant number := nvl(fnd_global.prog_appl_id,-1);
269: l_request_id constant number := nvl(fnd_global.conc_request_id,-1);
262: l_master_org number;
263:
264: l_user_id constant number := nvl(fnd_global.user_id,-1);
265: l_login_id constant number := nvl(fnd_global.login_id,-1);
266: l_program_id constant number := nvl(fnd_global.conc_program_id,-1);
267: l_program_login_id constant number := nvl(fnd_global.conc_login_id,-1);
268: l_program_application_id constant number := nvl(fnd_global.prog_appl_id,-1);
269: l_request_id constant number := nvl(fnd_global.conc_request_id,-1);
270:
263:
264: l_user_id constant number := nvl(fnd_global.user_id,-1);
265: l_login_id constant number := nvl(fnd_global.login_id,-1);
266: l_program_id constant number := nvl(fnd_global.conc_program_id,-1);
267: l_program_login_id constant number := nvl(fnd_global.conc_login_id,-1);
268: l_program_application_id constant number := nvl(fnd_global.prog_appl_id,-1);
269: l_request_id constant number := nvl(fnd_global.conc_request_id,-1);
270:
271: l_message varchar2(32000);
264: l_user_id constant number := nvl(fnd_global.user_id,-1);
265: l_login_id constant number := nvl(fnd_global.login_id,-1);
266: l_program_id constant number := nvl(fnd_global.conc_program_id,-1);
267: l_program_login_id constant number := nvl(fnd_global.conc_login_id,-1);
268: l_program_application_id constant number := nvl(fnd_global.prog_appl_id,-1);
269: l_request_id constant number := nvl(fnd_global.conc_request_id,-1);
270:
271: l_message varchar2(32000);
272: l_exception exception;
265: l_login_id constant number := nvl(fnd_global.login_id,-1);
266: l_program_id constant number := nvl(fnd_global.conc_program_id,-1);
267: l_program_login_id constant number := nvl(fnd_global.conc_login_id,-1);
268: l_program_application_id constant number := nvl(fnd_global.prog_appl_id,-1);
269: l_request_id constant number := nvl(fnd_global.conc_request_id,-1);
270:
271: l_message varchar2(32000);
272: l_exception exception;
273: l_rowcount number;
496: l_last_run_date date;
497: l_proc_name constant varchar2(30) := 'incr_load';
498: l_master_org number;
499:
500: l_user_id constant number := nvl(fnd_global.user_id,-1);
501: l_login_id constant number := nvl(fnd_global.login_id,-1);
502: l_program_id constant number := nvl(fnd_global.conc_program_id,-1);
503: l_program_login_id constant number := nvl(fnd_global.conc_login_id,-1);
504: l_program_application_id constant number := nvl(fnd_global.prog_appl_id,-1);
497: l_proc_name constant varchar2(30) := 'incr_load';
498: l_master_org number;
499:
500: l_user_id constant number := nvl(fnd_global.user_id,-1);
501: l_login_id constant number := nvl(fnd_global.login_id,-1);
502: l_program_id constant number := nvl(fnd_global.conc_program_id,-1);
503: l_program_login_id constant number := nvl(fnd_global.conc_login_id,-1);
504: l_program_application_id constant number := nvl(fnd_global.prog_appl_id,-1);
505: l_request_id constant number := nvl(fnd_global.conc_request_id,-1);
498: l_master_org number;
499:
500: l_user_id constant number := nvl(fnd_global.user_id,-1);
501: l_login_id constant number := nvl(fnd_global.login_id,-1);
502: l_program_id constant number := nvl(fnd_global.conc_program_id,-1);
503: l_program_login_id constant number := nvl(fnd_global.conc_login_id,-1);
504: l_program_application_id constant number := nvl(fnd_global.prog_appl_id,-1);
505: l_request_id constant number := nvl(fnd_global.conc_request_id,-1);
506:
499:
500: l_user_id constant number := nvl(fnd_global.user_id,-1);
501: l_login_id constant number := nvl(fnd_global.login_id,-1);
502: l_program_id constant number := nvl(fnd_global.conc_program_id,-1);
503: l_program_login_id constant number := nvl(fnd_global.conc_login_id,-1);
504: l_program_application_id constant number := nvl(fnd_global.prog_appl_id,-1);
505: l_request_id constant number := nvl(fnd_global.conc_request_id,-1);
506:
507: l_message varchar2(32000);
500: l_user_id constant number := nvl(fnd_global.user_id,-1);
501: l_login_id constant number := nvl(fnd_global.login_id,-1);
502: l_program_id constant number := nvl(fnd_global.conc_program_id,-1);
503: l_program_login_id constant number := nvl(fnd_global.conc_login_id,-1);
504: l_program_application_id constant number := nvl(fnd_global.prog_appl_id,-1);
505: l_request_id constant number := nvl(fnd_global.conc_request_id,-1);
506:
507: l_message varchar2(32000);
508: l_exception exception;
501: l_login_id constant number := nvl(fnd_global.login_id,-1);
502: l_program_id constant number := nvl(fnd_global.conc_program_id,-1);
503: l_program_login_id constant number := nvl(fnd_global.conc_login_id,-1);
504: l_program_application_id constant number := nvl(fnd_global.prog_appl_id,-1);
505: l_request_id constant number := nvl(fnd_global.conc_request_id,-1);
506:
507: l_message varchar2(32000);
508: l_exception exception;
509: l_rowcount number;