APPS.CSM_MTL_ITEM_LOC_EVENT_PKG dependencies on JTM_CON_REQUEST_DATA

Line 31: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;

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

Line 46: FROM jtm_con_request_data

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

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

144: ,P_USER_ID => r_mtl_item_loc_ins_rec.user_id
145: );
146: END LOOP;
147:
148: -- set the program update date in jtm_con_request_data to sysdate
149: UPDATE jtm_con_request_data
150: SET last_run_date = l_run_date
151: WHERE package_name = 'CSM_MTL_ITEM_LOC_EVENT_PKG'
152: AND procedure_name = 'REFRESH_ACC';

Line 149: UPDATE jtm_con_request_data

145: );
146: END LOOP;
147:
148: -- set the program update date in jtm_con_request_data to sysdate
149: UPDATE jtm_con_request_data
150: SET last_run_date = l_run_date
151: WHERE package_name = 'CSM_MTL_ITEM_LOC_EVENT_PKG'
152: AND procedure_name = 'REFRESH_ACC';
153: