APPS.CSM_MTL_TXN_REASONS_EVENT_PKG dependencies on CSM_MTL_TXN_REASONS_ACC

Line 38: SELECT csm_mtl_txn_reasons_acc_s.nextval, reason_id

34: l_mark_dirty boolean;
35:
36: CURSOR l_ins_mtl_txn_reasons_csr(p_lastrundate IN date)
37: IS
38: SELECT csm_mtl_txn_reasons_acc_s.nextval, reason_id
39: FROM mtl_transaction_reasons
40: WHERE NVL(disable_date, SYSDATE) >= SYSDATE
41: AND last_update_date >= nvl(p_lastrundate, last_update_date )
42: AND ( reason_id ) NOT IN (

Line 44: FROM csm_mtl_txn_reasons_acc

40: WHERE NVL(disable_date, SYSDATE) >= SYSDATE
41: AND last_update_date >= nvl(p_lastrundate, last_update_date )
42: AND ( reason_id ) NOT IN (
43: SELECT reason_id
44: FROM csm_mtl_txn_reasons_acc
45: );
46:
47: CURSOR l_upd_mtl_txn_reasons_csr( p_lastrundate IN DATE)
48: IS

Line 50: FROM csm_mtl_txn_reasons_acc acc

46:
47: CURSOR l_upd_mtl_txn_reasons_csr( p_lastrundate IN DATE)
48: IS
49: SELECT access_id
50: FROM csm_mtl_txn_reasons_acc acc
51: , mtl_transaction_reasons mtr
52: WHERE mtr.reason_id = acc.reason_id
53: AND NVL(disable_date, SYSDATE) >= SYSDATE
54: AND mtr.last_update_date >= p_lastrundate;

Line 59: FROM csm_mtl_txn_reasons_acc

55:
56: CURSOR l_del_mtl_txn_reasons_csr( p_lastrundate IN DATE)
57: IS
58: SELECT access_id
59: FROM csm_mtl_txn_reasons_acc
60: WHERE reason_id IN
61: (SELECT reason_id
62: FROM mtl_transaction_reasons
63: WHERE last_update_date >= nvl(p_lastrundate, last_update_date)

Line 68: FROM csm_mtl_txn_reasons_acc

64: AND NVL(disable_date, sysdate) < SYSDATE
65: )
66: UNION
67: SELECT access_id
68: FROM csm_mtl_txn_reasons_acc
69: WHERE reason_id NOT IN
70: (SELECT reason_id
71: FROM mtl_transaction_reasons
72: );

Line 81: TYPE access_id_tbl_typ IS TABLE OF csm_mtl_txn_reasons_acc.access_id%TYPE INDEX BY BINARY_INTEGER;

77: FROM jtm_con_request_data
78: WHERE package_name = 'CSM_MTL_TXN_REASONS_EVENT_PKG'
79: AND procedure_name = 'REFRESH_MTL_TXN_REASONS_ACC';
80:
81: TYPE access_id_tbl_typ IS TABLE OF csm_mtl_txn_reasons_acc.access_id%TYPE INDEX BY BINARY_INTEGER;
82: TYPE reason_id_tbl_typ IS TABLE OF mtl_transaction_reasons.reason_id%TYPE INDEX BY BINARY_INTEGER;
83:
84: l_access_id_tbl access_id_tbl_typ;
85: l_reason_id_tbl reason_id_tbl_typ;

Line 129: DELETE FROM csm_mtl_txn_reasons_acc WHERE access_id = l_access_id_tbl(i);

125: END LOOP;
126:
127: -- bulk delete from acc table
128: FORALL i IN 1..l_access_id_tbl.count
129: DELETE FROM csm_mtl_txn_reasons_acc WHERE access_id = l_access_id_tbl(i);
130:
131: l_access_id_tbl.delete;
132: END IF; -- end of process deletes
133:

Line 182: INSERT INTO csm_mtl_txn_reasons_acc (access_id, reason_id, created_by, creation_date, last_updated_by, last_update_date, last_update_login)

178: END LOOP;
179: END LOOP;
180:
181: FORALL i IN 1..l_access_id_tbl.count
182: INSERT INTO csm_mtl_txn_reasons_acc (access_id, reason_id, created_by, creation_date, last_updated_by, last_update_date, last_update_login)
183: VALUES (l_access_id_tbl(i), l_reason_id_tbl(i), fnd_global.user_id, l_run_date, fnd_global.user_id, l_run_date, fnd_global.login_id);
184:
185: l_access_id_tbl.delete;
186: END IF; -- end of process inserts