APPS.CSM_MTL_SEC_LOCATORS_EVENT_PKG dependencies on JTM_CON_REQUEST_DATA

Line 32: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;

28: l_updates_cur CSM_UTIL_PKG.Changed_Records_Cur_Type;
29: l_inserts_cur CSM_UTIL_PKG.Changed_Records_Cur_Type;
30: l_dsql varchar2(2048);
31: l_pub_item VARCHAR2(30) := 'CSM_MTL_SECONDARY_LOCATORS';
32: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;
33: l_access_id jtm_fnd_lookups_acc.access_id%TYPE;
34: l_mark_dirty boolean;
35: l_all_omfs_palm_resource_list asg_download.user_list;
36: l_null_resource_list asg_download.user_list;

Line 47: FROM jtm_con_request_data

43:
44: CURSOR l_last_run_date_csr
45: IS
46: SELECT nvl(last_run_date, (sysdate - 365*50))
47: FROM jtm_con_request_data
48: WHERE package_name = 'CSM_MTL_SEC_LOCATORS_EVENT_PKG'
49: AND procedure_name = 'REFRESH_ACC';
50:
51: -- process inserts

Line 156: -- set the program update date in jtm_con_request_data to sysdate

152: ,P_USER_ID => r_mtl_sec_loc_ins_rec.user_id
153: );
154: END LOOP;
155:
156: -- set the program update date in jtm_con_request_data to sysdate
157: UPDATE jtm_con_request_data
158: SET last_run_date = l_run_date
159: WHERE package_name = 'CSM_MTL_SEC_LOCATORS_EVENT_PKG'
160: AND procedure_name = 'REFRESH_ACC';

Line 157: UPDATE jtm_con_request_data

153: );
154: END LOOP;
155:
156: -- set the program update date in jtm_con_request_data to sysdate
157: UPDATE jtm_con_request_data
158: SET last_run_date = l_run_date
159: WHERE package_name = 'CSM_MTL_SEC_LOCATORS_EVENT_PKG'
160: AND procedure_name = 'REFRESH_ACC';
161: