APPS.CSM_PROBCODE_MAPPING_EVENT_PKG dependencies on JTM_CON_REQUEST_DATA

Line 25: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;

21: l_sqlerrno VARCHAR2(20);
22: l_sqlerrmsg varchar2(2000);
23: l_mark_dirty boolean;
24: g_pub_item varchar2(30) := 'CSM_PROBCODE_MAPPING';
25: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;
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_problem_map_detail_id_tbl problem_map_detail_id_tbl_typ;

Line 69: FROM jtm_con_request_data

65:
66: CURSOR l_last_run_date_csr
67: IS
68: SELECT nvl(last_run_date, (sysdate - 365*50))
69: FROM jtm_con_request_data
70: WHERE package_name = 'CSM_PROBCODE_MAPPING_EVENT_PKG'
71: AND procedure_name = 'REFRESH_PROBCODE_MAPPING_ACC';
72:
73: BEGIN

Line 186: UPDATE jtm_con_request_data

182: l_map_access_list.delete;
183: END IF; -- end of process inserts
184:
185: -- update last_run_date
186: UPDATE jtm_con_request_data
187: SET last_run_date = l_run_date
188: WHERE package_name = 'CSM_PROBCODE_MAPPING_EVENT_PKG'
189: AND procedure_name = 'REFRESH_PROBCODE_MAPPING_ACC';
190: