APPS.CSM_SR_TYPE_MAP_EVENT_PKG dependencies on JTM_CON_REQUEST_DATA

Line 31: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;

27: l_pub_item varchar2(30) := 'CSM_SR_TYPE_MAPPING';
28: l_map_access_list asg_download.access_list;
29: l_all_omfs_resource_list asg_download.user_list;
30: l_null_omfs_resource_list asg_download.user_list;
31: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;
32: l_sr_type_id_tbl incident_type_id_tbl_typ;
33: l_responsibility_id_tbl responsibility_id_tbl_typ;
34: l_user_list asg_download.user_list;
35:

Line 81: FROM jtm_con_request_data

77: --Cursor to get last run dateR12 change
78: CURSOR l_last_run_date_csr
79: IS
80: SELECT nvl(last_run_date, (sysdate - 365*50))
81: FROM jtm_con_request_data
82: WHERE package_name = 'CSM_SR_TYPE_MAP_EVENT_PKG'
83: AND procedure_name = 'REFRESH_ACC';
84:
85: BEGIN

Line 201: UPDATE jtm_con_request_data

197: l_user_list.delete;
198: END IF; -- end of process inserts
199:
200: -- update last_run_date
201: UPDATE jtm_con_request_data
202: SET last_run_date = sysdate
203: WHERE package_name = 'CSM_SR_TYPE_MAP_EVENT_PKG'
204: AND procedure_name= 'REFRESH_ACC';
205: