APPS.CSM_DEFERRED_TXNS_PKG dependencies on CSM_DEFERRED_TRANSACTIONS_INQ

Line 95: FROM CSM_DEFERRED_TRANSACTIONS_INQ

91: /* Select all inq records */
92: CURSOR c_inq_records( b_user_name VARCHAR2, b_tranid NUMBER)
93: IS
94: SELECT *
95: FROM CSM_DEFERRED_TRANSACTIONS_INQ
96: WHERE tranid$$ = b_tranid
97: AND clid$$cs = b_user_name;
98:
99: CURSOR c_tracking_tree(b_tracking_id number)

Line 108: FROM CSM_DEFERRED_TRANSACTIONS_INQ

104:
105: CURSOR c_reapply_txn(b_tranid NUMBER,b_name VARCHAR2)
106: IS
107: SELECT DISTINCT DEFERRED_TRAN_ID,CLIENT_ID
108: FROM CSM_DEFERRED_TRANSACTIONS_INQ
109: WHERE tranid$$ = b_tranid AND clid$$cs = b_name
110: AND ACTION = 'C';
111:
112: TYPE l_reapply_type IS TABLE OF c_reapply_txn%rowtype index by binary_integer;

Line 132: FOR dml_0_rec IN (SELECT TRACKING_ID,SEQNO$$ FROM CSM_DEFERRED_TRANSACTIONS_INQ inq

128: x_return_status := FND_API.G_RET_STS_SUCCESS;
129:
130: -- Support for deleting tracking records as required by Laptop team
131: /**BEGIN*/
132: FOR dml_0_rec IN (SELECT TRACKING_ID,SEQNO$$ FROM CSM_DEFERRED_TRANSACTIONS_INQ inq
133: WHERE TRANID$$=p_tranid AND CLID$$CS=p_user_name AND dmltype$$='D')
134: LOOP
135:
136: CSM_UTIL_PKG.LOG('Delete DML received for tracking Id: '||dml_0_rec.tracking_id||' from -'||p_user_name ||' in txn-'||p_tranid,

Line 180: FOR clear_rec IN (SELECT TRACKING_ID,SEQNO$$ FROM CSM_DEFERRED_TRANSACTIONS_INQ inq

176: -- PURGE-1 : CLEAR INQ RECORDS WITH NO ACTION
177: -- PURGE-2 : CLEAR INQ RECORDS WITH NO CORRESPONDING RECORDS IN THE BASE TABLE
178: -- PURGE-3 : CLEAR INQ RECORDS WITH REAPPLY ACTION AND THAT ARE NOT ROOT
179: l_cnt:=0;
180: FOR clear_rec IN (SELECT TRACKING_ID,SEQNO$$ FROM CSM_DEFERRED_TRANSACTIONS_INQ inq
181: WHERE TRANID$$=p_tranid AND CLID$$CS=p_user_name
182: AND
183: (
184: (ACTION IS NULL OR ACTION NOT IN ('C','D'))