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 260: l_last_run_date jtm_con_request_data.last_run_date%TYPE;

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

Line 376: UPDATE jtm_con_request_data

372: CLOSE l_mat_insert_csr;
373: COMMIT;
374:
375: -- update last_run_date
376: UPDATE jtm_con_request_data
377: SET last_run_date = l_current_date
378: WHERE package_name = 'CSM_MTL_MATERIAL_TXN_ACC_PKG'
379: AND procedure_name = 'REFRESH_MAT_TXN_ACC';
380: