2168: l_from_date date;
2169: l_to_date date;
2170: l_ret_val boolean;
2171: begin
2172: g_user_id := fnd_global.user_id;
2173: g_login_user_id := fnd_global.login_id;
2174: g_conc_program_id := fnd_global.conc_program_id;
2175: g_conc_login_id := fnd_global.conc_login_id;
2176: g_conc_appl_id := fnd_global.prog_appl_id;
2169: l_to_date date;
2170: l_ret_val boolean;
2171: begin
2172: g_user_id := fnd_global.user_id;
2173: g_login_user_id := fnd_global.login_id;
2174: g_conc_program_id := fnd_global.conc_program_id;
2175: g_conc_login_id := fnd_global.conc_login_id;
2176: g_conc_appl_id := fnd_global.prog_appl_id;
2177: g_conc_request_id := fnd_global.conc_request_id;
2170: l_ret_val boolean;
2171: begin
2172: g_user_id := fnd_global.user_id;
2173: g_login_user_id := fnd_global.login_id;
2174: g_conc_program_id := fnd_global.conc_program_id;
2175: g_conc_login_id := fnd_global.conc_login_id;
2176: g_conc_appl_id := fnd_global.prog_appl_id;
2177: g_conc_request_id := fnd_global.conc_request_id;
2178: select to_date(fnd_profile.value('CS_CSY_LAST_PROGRAM_RUN_DATE'),
2171: begin
2172: g_user_id := fnd_global.user_id;
2173: g_login_user_id := fnd_global.login_id;
2174: g_conc_program_id := fnd_global.conc_program_id;
2175: g_conc_login_id := fnd_global.conc_login_id;
2176: g_conc_appl_id := fnd_global.prog_appl_id;
2177: g_conc_request_id := fnd_global.conc_request_id;
2178: select to_date(fnd_profile.value('CS_CSY_LAST_PROGRAM_RUN_DATE'),
2179: 'YYYYMMDD HH24:MI:SS')
2172: g_user_id := fnd_global.user_id;
2173: g_login_user_id := fnd_global.login_id;
2174: g_conc_program_id := fnd_global.conc_program_id;
2175: g_conc_login_id := fnd_global.conc_login_id;
2176: g_conc_appl_id := fnd_global.prog_appl_id;
2177: g_conc_request_id := fnd_global.conc_request_id;
2178: select to_date(fnd_profile.value('CS_CSY_LAST_PROGRAM_RUN_DATE'),
2179: 'YYYYMMDD HH24:MI:SS')
2180: into l_from_date
2173: g_login_user_id := fnd_global.login_id;
2174: g_conc_program_id := fnd_global.conc_program_id;
2175: g_conc_login_id := fnd_global.conc_login_id;
2176: g_conc_appl_id := fnd_global.prog_appl_id;
2177: g_conc_request_id := fnd_global.conc_request_id;
2178: select to_date(fnd_profile.value('CS_CSY_LAST_PROGRAM_RUN_DATE'),
2179: 'YYYYMMDD HH24:MI:SS')
2180: into l_from_date
2181: from dual;