APPS.CSM_MTL_SYSTEM_ITEMS_EVENT_PKG dependencies on JTM_CON_REQUEST_DATA

Line 746: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;

742: PROCEDURE Refresh_mtl_system_items_acc(p_status OUT NOCOPY VARCHAR2,
743: p_message OUT NOCOPY VARCHAR2)
744: IS
745: PRAGMA AUTONOMOUS_TRANSACTION;
746: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;
747: l_all_omfs_user_list asg_download.user_list;
748: l_null_omfs_user_list asg_download.user_list;
749: l_user_id fnd_user.user_id%TYPE;
750: l_user_organization_id mtl_system_items.organization_id%TYPE;

Line 760: FROM jtm_con_request_data

756:
757: CURSOR l_last_run_date_csr
758: IS
759: SELECT NVL(last_run_date, TO_DATE('1','J'))
760: FROM jtm_con_request_data
761: WHERE package_name = 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG'
762: AND procedure_name = 'REFRESH_MTL_SYSTEM_ITEMS_ACC';
763:
764: BEGIN

Line 798: UPDATE jtm_con_request_data

794:
795: END LOOP;
796:
797: -- update last_run_date
798: UPDATE jtm_con_request_data
799: SET last_run_date = l_run_date
800: WHERE package_name = 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG'
801: AND procedure_name = 'REFRESH_MTL_SYSTEM_ITEMS_ACC';
802: