APPS.CSM_CTR_PROP_READ_EVENT_PKG dependencies on JTM_CON_REQUEST_DATA

Line 206: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;

202: l_access_list asg_download.access_list;
203: l_user_list asg_download.user_list;
204: l_all_omfs_resource_list asg_download.user_list;
205: l_null_omfs_resource_list asg_download.user_list;
206: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;
207: l_counter_prop_value_id_tbl counter_prop_val_tbl_typ;
208:
209: --Cursor Declarations
210: --Insert Cursor

Line 245: FROM jtm_con_request_data

241: --Cursor to get last run date
242: CURSOR l_last_run_date_csr
243: IS
244: SELECT nvl(last_run_date, (sysdate - 365*50))
245: FROM jtm_con_request_data
246: WHERE package_name = 'CSM_CTR_PROP_READ_EVENT_PKG'
247: AND procedure_name = 'REFRESH_ACC';
248:
249: BEGIN

Line 339: UPDATE jtm_con_request_data

335:
336: END IF; -- end of process inserts
337:
338: -- update last_run_date
339: UPDATE jtm_con_request_data
340: SET last_run_date = sysdate
341: WHERE package_name = 'CSM_CTR_PROP_READ_EVENT_PKG'
342: AND procedure_name= 'REFRESH_ACC';
343: