2126: l_from_date date;
2127: l_to_date date;
2128: l_ret_val boolean;
2129: begin
2130: g_user_id := fnd_global.user_id;
2131: g_login_user_id := fnd_global.login_id;
2132: g_conc_program_id := fnd_global.conc_program_id;
2133: g_conc_login_id := fnd_global.conc_login_id;
2134: g_conc_appl_id := fnd_global.prog_appl_id;
2127: l_to_date date;
2128: l_ret_val boolean;
2129: begin
2130: g_user_id := fnd_global.user_id;
2131: g_login_user_id := fnd_global.login_id;
2132: g_conc_program_id := fnd_global.conc_program_id;
2133: g_conc_login_id := fnd_global.conc_login_id;
2134: g_conc_appl_id := fnd_global.prog_appl_id;
2135: g_conc_request_id := fnd_global.conc_request_id;
2128: l_ret_val boolean;
2129: begin
2130: g_user_id := fnd_global.user_id;
2131: g_login_user_id := fnd_global.login_id;
2132: g_conc_program_id := fnd_global.conc_program_id;
2133: g_conc_login_id := fnd_global.conc_login_id;
2134: g_conc_appl_id := fnd_global.prog_appl_id;
2135: g_conc_request_id := fnd_global.conc_request_id;
2136: select to_date(fnd_profile.value('CS_CSY_LAST_PROGRAM_RUN_DATE'),
2129: begin
2130: g_user_id := fnd_global.user_id;
2131: g_login_user_id := fnd_global.login_id;
2132: g_conc_program_id := fnd_global.conc_program_id;
2133: g_conc_login_id := fnd_global.conc_login_id;
2134: g_conc_appl_id := fnd_global.prog_appl_id;
2135: g_conc_request_id := fnd_global.conc_request_id;
2136: select to_date(fnd_profile.value('CS_CSY_LAST_PROGRAM_RUN_DATE'),
2137: 'YYYYMMDD HH24:MI:SS')
2130: g_user_id := fnd_global.user_id;
2131: g_login_user_id := fnd_global.login_id;
2132: g_conc_program_id := fnd_global.conc_program_id;
2133: g_conc_login_id := fnd_global.conc_login_id;
2134: g_conc_appl_id := fnd_global.prog_appl_id;
2135: g_conc_request_id := fnd_global.conc_request_id;
2136: select to_date(fnd_profile.value('CS_CSY_LAST_PROGRAM_RUN_DATE'),
2137: 'YYYYMMDD HH24:MI:SS')
2138: into l_from_date
2131: g_login_user_id := fnd_global.login_id;
2132: g_conc_program_id := fnd_global.conc_program_id;
2133: g_conc_login_id := fnd_global.conc_login_id;
2134: g_conc_appl_id := fnd_global.prog_appl_id;
2135: g_conc_request_id := fnd_global.conc_request_id;
2136: select to_date(fnd_profile.value('CS_CSY_LAST_PROGRAM_RUN_DATE'),
2137: 'YYYYMMDD HH24:MI:SS')
2138: into l_from_date
2139: from dual;