APPS.CSM_MTL_MATERIAL_TXN_ACC_PKG dependencies on JTM_CON_REQUEST_DATA

Line 185: FROM jtm_con_request_data

181: PRAGMA AUTONOMOUS_TRANSACTION;
182:
183: CURSOR l_last_run_date_csr IS
184: SELECT NVL(last_run_date, TO_DATE('1','J'))
185: FROM jtm_con_request_data
186: WHERE package_name = 'CSM_MTL_MATERIAL_TXN_ACC_PKG'
187: AND procedure_name = 'REFRESH_MAT_TXN_ACC';
188:
189: --Delete if either from or to subinv is not assigned to the mobile user any longer

Line 262: l_last_run_date jtm_con_request_data.last_run_date%TYPE;

258: AND NOT EXISTS (SELECT 1 FROM CSM_MTL_MATERIAL_TXN_ACC ACC
259: WHERE B.TRANSACTION_ID = ACC.TRANSACTION_ID
260: AND ACC.USER_ID = cilaa.USER_ID);
261:
262: l_last_run_date jtm_con_request_data.last_run_date%TYPE;
263:
264: TYPE tran_idTab IS TABLE OF MTL_MATERIAL_TRANSACTIONS.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
265:
266: l_user_id_lst ASG_DOWNLOAD.USER_LIST;

Line 380: UPDATE jtm_con_request_data

376: CLOSE l_mat_insert_csr;
377: COMMIT;
378:
379: -- update last_run_date
380: UPDATE jtm_con_request_data
381: SET last_run_date = l_current_date
382: WHERE package_name = 'CSM_MTL_MATERIAL_TXN_ACC_PKG'
383: AND procedure_name = 'REFRESH_MAT_TXN_ACC';
384: