APPS.CSM_MTL_ITEM_SUBINV_EVENT_PKG dependencies on JTM_CON_REQUEST_DATA

Line 286: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;

282: PROCEDURE Refresh_acc(p_status OUT NOCOPY VARCHAR2,
283: p_message OUT NOCOPY VARCHAR2)
284: IS
285: PRAGMA AUTONOMOUS_TRANSACTION;
286: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;
287: l_access_id jtm_fnd_lookups_acc.access_id%TYPE;
288: l_all_omfs_palm_resource_list asg_download.user_list;
289: l_valid_omfs_resource_list asg_download.user_list;
290: l_null_palm_omfs_resource_list asg_download.user_list;

Line 301: FROM jtm_con_request_data

297:
298: CURSOR l_last_run_date_csr
299: IS
300: SELECT nvl(last_run_date, (sysdate - 365*50))
301: FROM jtm_con_request_data
302: WHERE package_name = 'CSM_MTL_ITEM_SUBINV_EVENT_PKG'
303: AND procedure_name = 'REFRESH_ACC';
304:
305: --process inserts

Line 461: UPDATE jtm_con_request_data

457: );
458: END LOOP;
459:
460: -- update last_run_date
461: UPDATE jtm_con_request_data
462: SET last_run_date = l_run_date
463: WHERE package_name = 'CSM_MTL_ITEM_SUBINV_EVENT_PKG'
464: AND procedure_name = 'REFRESH_ACC';
465: