APPS.CSM_RESCODE_MAPPING_EVENT_PKG dependencies on JTM_CON_REQUEST_DATA

Line 29: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;

25: l_pub_item varchar2(30) := 'CSM_RESCODE_MAPPING';
26: l_map_access_list asg_download.access_list;
27: l_all_omfs_resource_list asg_download.user_list;
28: l_null_omfs_resource_list asg_download.user_list;
29: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;
30: l_resol_map_id_tbl res_map_id_tbl_typ;
31:
32: --Cursor Declarations
33: --Insert Cursor

Line 67: FROM jtm_con_request_data

63: --Cursor to get last run date
64: CURSOR l_last_run_date_csr
65: IS
66: SELECT nvl(last_run_date, (sysdate - 365*50))
67: FROM jtm_con_request_data
68: WHERE package_name = 'CSM_RESCODE_MAPPING_EVENT_PKG'
69: AND procedure_name = 'REFRESH_ACC';
70:
71: BEGIN

Line 183: UPDATE jtm_con_request_data

179: l_map_access_list.delete;
180: END IF; -- end of process inserts
181:
182: -- update last_run_date
183: UPDATE jtm_con_request_data
184: SET last_run_date = sysdate
185: WHERE package_name = 'CSM_RESCODE_MAPPING_EVENT_PKG'
186: AND procedure_name= 'REFRESH_ACC';
187: