APPS.CSM_MTL_MATERIAL_TXN_ACC_PKG dependencies on MTL_MATERIAL_TRANSACTIONS

Line 8: g_table_name CONSTANT VARCHAR2(30) := 'MTL_MATERIAL_TRANSACTIONS';

4: /*** Globals ***/
5: g_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_MTL_MATERIAL_TXN_ACC';
6: g_publication_item_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=
7: CSM_ACC_PKG.t_publication_item_list('CSM_MTL_MATERIAL_TXNS');
8: g_table_name CONSTANT VARCHAR2(30) := 'MTL_MATERIAL_TRANSACTIONS';
9: g_tasks_seq_name CONSTANT VARCHAR2(30) := 'CSM_MTL_MATERIAL_TXN_ACC_S';
10: g_pk1_name CONSTANT VARCHAR2(30) := 'TRANSACTION_ID';
11:
12: PROCEDURE Insert_MTL_Mat_Transaction(

Line 196: MTL_MATERIAL_TRANSACTIONS B

192: IS
193: SELECT ACC.user_id
194: , ACC.TRANSACTION_ID
195: FROM CSM_MTL_MATERIAL_TXN_ACC ACC,
196: MTL_MATERIAL_TRANSACTIONS B
197: WHERE B.TRANSACTION_ID = ACC.TRANSACTION_ID
198: AND B.TRANSACTION_ACTION_ID = 2 --Subinventory transfer
199: AND (NOT EXISTS (SELECT 1
200: FROM csm_inv_loc_ass_acc cilaa,

Line 223: MTL_MATERIAL_TRANSACTIONS B

219: CURSOR l_mat_update_csr (b_last_run_date IN DATE) IS
220: SELECT ACC.user_id
221: , ACC.TRANSACTION_ID
222: FROM CSM_MTL_MATERIAL_TXN_ACC ACC,
223: MTL_MATERIAL_TRANSACTIONS B
224: WHERE B.TRANSACTION_ID = ACC.TRANSACTION_ID
225: AND B.last_update_date > b_last_run_date;
226:
227: --Insert if either from OR to subinv are assigned to the mobile user

Line 232: FROM MTL_MATERIAL_TRANSACTIONS B,

228: CURSOR l_mat_insert_csr
229: IS
230: SELECT cilaa.user_id
231: , B.TRANSACTION_ID
232: FROM MTL_MATERIAL_TRANSACTIONS B,
233: csm_inv_loc_ass_acc cilaa,
234: csp_inv_loc_assignments cila_from
235: WHERE cilaa.csp_inv_loc_assignment_id = cila_from.csp_inv_loc_assignment_id
236: AND TRANSACTION_ACTION_ID = 2 --Subinventory transfer

Line 247: FROM MTL_MATERIAL_TRANSACTIONS B,

243: AND B.transaction_date > (sysdate -CSM_PROFILE_PKG.get_task_history_days(cilaa.user_id))
244: UNION ALL
245: SELECT cilaa.user_id
246: , B.TRANSACTION_ID
247: FROM MTL_MATERIAL_TRANSACTIONS B,
248: csm_inv_loc_ass_acc cilaa,
249: csp_inv_loc_assignments cila_to
250: WHERE cilaa.csp_inv_loc_assignment_id = cila_to.csp_inv_loc_assignment_id
251: AND TRANSACTION_ACTION_ID = 2 --Subinventory transfer

Line 262: TYPE tran_idTab IS TABLE OF MTL_MATERIAL_TRANSACTIONS.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;

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;
265: l_tran_id_lst tran_idTab;
266:

Line 405: FROM MTL_MATERIAL_TRANSACTIONS B,

401:
402: --Insert if either from OR to subinv are assigned to the mobile user
403: CURSOR l_mat_insert_csr (b_user_id IN NUMBER) IS
404: SELECT B.TRANSACTION_ID
405: FROM MTL_MATERIAL_TRANSACTIONS B,
406: csm_inv_loc_ass_acc cilaa,
407: csp_inv_loc_assignments cila_from
408: WHERE cilaa.csp_inv_loc_assignment_id = cila_from.csp_inv_loc_assignment_id
409: AND TRANSACTION_ACTION_ID = 2 --Subinventory transfer

Line 419: FROM MTL_MATERIAL_TRANSACTIONS B,

415: AND cilaa.user_id = b_user_id
416: AND B.transaction_date > (sysdate -CSM_PROFILE_PKG.get_task_history_days(cilaa.user_id))
417: UNION ALL
418: SELECT B.TRANSACTION_ID
419: FROM MTL_MATERIAL_TRANSACTIONS B,
420: csm_inv_loc_ass_acc cilaa,
421: csp_inv_loc_assignments cila_to
422: WHERE cilaa.csp_inv_loc_assignment_id = cila_to.csp_inv_loc_assignment_id
423: AND TRANSACTION_ACTION_ID = 2 --Subinventory transfer

Line 432: TYPE Tran_idTab IS TABLE OF MTL_MATERIAL_TRANSACTIONS.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;

428: WHERE B.TRANSACTION_ID = ACC.TRANSACTION_ID)
429: AND cilaa.user_id = b_user_id
430: AND B.transaction_date > (sysdate -CSM_PROFILE_PKG.get_task_history_days(cilaa.user_id));
431:
432: TYPE Tran_idTab IS TABLE OF MTL_MATERIAL_TRANSACTIONS.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
433:
434: l_tran_id_lst Tran_idTab;
435:
436: l_sqlerrno VARCHAR2(20);