APPS.CSM_MTL_ITEM_SUBINV_EVENT_PKG dependencies on JTM_CON_REQUEST_DATA

Line 280: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;

276: PROCEDURE Refresh_acc(p_status OUT NOCOPY VARCHAR2,
277: p_message OUT NOCOPY VARCHAR2)
278: IS
279: PRAGMA AUTONOMOUS_TRANSACTION;
280: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;
281: l_access_id jtm_fnd_lookups_acc.access_id%TYPE;
282: l_all_omfs_palm_resource_list asg_download.user_list;
283: l_valid_omfs_resource_list asg_download.user_list;
284: l_null_palm_omfs_resource_list asg_download.user_list;

Line 295: FROM jtm_con_request_data

291:
292: CURSOR l_last_run_date_csr
293: IS
294: SELECT nvl(last_run_date, (sysdate - 365*50))
295: FROM jtm_con_request_data
296: WHERE package_name = 'CSM_MTL_ITEM_SUBINV_EVENT_PKG'
297: AND procedure_name = 'REFRESH_ACC';
298:
299: --process inserts

Line 415: UPDATE jtm_con_request_data

411: );
412: END LOOP;
413:
414: -- update last_run_date
415: UPDATE jtm_con_request_data
416: SET last_run_date = l_run_date
417: WHERE package_name = 'CSM_MTL_ITEM_SUBINV_EVENT_PKG'
418: AND procedure_name = 'REFRESH_ACC';
419: