APPS.CSM_DEFERRED_TXNS_PKG dependencies on CSM_DEFERRED_TRANSACTIONS_ACC

Line 140: DELETE FROM CSM_DEFERRED_TRANSACTIONS_ACC

136: CSM_UTIL_PKG.LOG('Delete DML received for tracking Id: '||dml_0_rec.tracking_id||' from -'||p_user_name ||' in txn-'||p_tranid,
137: 'CSM_DEFERRED_TXNS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_PROCEDURE);
138:
139: --root is deleted by client so no mark dirty required
140: DELETE FROM CSM_DEFERRED_TRANSACTIONS_ACC
141: WHERE tracking_id = dml_0_rec.tracking_id
142: AND USER_ID=asg_base.get_user_id(p_user_name);
143:
144: --delete children

Line 150: ,P_ACC_TABLE_NAME => 'CSM_DEFERRED_TRANSACTIONS_ACC'

146: WHERE PARENT_ID=dml_0_rec.tracking_id AND CLIENT_ID=p_user_name)
147: LOOP
148: CSM_ACC_PKG.Delete_Acc
149: ( P_PUBLICATION_ITEM_NAMES => CSM_ACC_PKG.t_publication_item_list('CSM_DEFERRED_TRANSACTIONS')
150: ,P_ACC_TABLE_NAME => 'CSM_DEFERRED_TRANSACTIONS_ACC'
151: ,P_PK1_NAME => 'TRACKING_ID'
152: ,P_PK1_NUM_VALUE => rec.tracking_id
153: ,P_USER_ID => asg_base.get_user_id(p_user_name)
154: );

Line 278: ,P_ACC_TABLE_NAME => 'CSM_DEFERRED_TRANSACTIONS_ACC'

274:
275:
276: CSM_ACC_PKG.Delete_Acc
277: ( P_PUBLICATION_ITEM_NAMES => CSM_ACC_PKG.t_publication_item_list('CSM_DEFERRED_TRANSACTIONS')
278: ,P_ACC_TABLE_NAME => 'CSM_DEFERRED_TRANSACTIONS_ACC'
279: ,P_PK1_NAME => 'TRACKING_ID'
280: ,P_PK1_NUM_VALUE => disc_rec.tracking_id
281: ,P_USER_ID => asg_base.get_user_id(disc_rec.client_id)
282: );

Line 313: ,P_ACC_TABLE_NAME => 'CSM_DEFERRED_TRANSACTIONS_ACC'

309: FOR I IN 1..l_track_tab.COUNT
310: LOOP
311: CSM_ACC_PKG.Delete_Acc
312: ( P_PUBLICATION_ITEM_NAMES => CSM_ACC_PKG.t_publication_item_list('CSM_DEFERRED_TRANSACTIONS')
313: ,P_ACC_TABLE_NAME => 'CSM_DEFERRED_TRANSACTIONS_ACC'
314: ,P_PK1_NAME => 'TRACKING_ID'
315: ,P_PK1_NUM_VALUE => l_track_tab(I)
316: ,P_USER_ID => asg_base.get_user_id(l_uname_tab(I))
317: );

Line 392: ,P_ACC_TABLE_NAME => 'CSM_DEFERRED_TRANSACTIONS_ACC'

388: END IF;
389:
390: CSM_ACC_PKG.Delete_Acc
391: ( P_PUBLICATION_ITEM_NAMES => CSM_ACC_PKG.t_publication_item_list('CSM_DEFERRED_TRANSACTIONS')
392: ,P_ACC_TABLE_NAME => 'CSM_DEFERRED_TRANSACTIONS_ACC'
393: ,P_PK1_NAME => 'TRACKING_ID'
394: ,P_PK1_NUM_VALUE => disc_rec.tracking_id
395: ,P_USER_ID => asg_base.get_user_id(disc_rec.client_id)
396: );

Line 453: ,P_ACC_TABLE_NAME => 'CSM_DEFERRED_TRANSACTIONS_ACC'

449: END IF;
450:
451: CSM_ACC_PKG.Delete_Acc
452: ( P_PUBLICATION_ITEM_NAMES => CSM_ACC_PKG.t_publication_item_list('CSM_DEFERRED_TRANSACTIONS')
453: ,P_ACC_TABLE_NAME => 'CSM_DEFERRED_TRANSACTIONS_ACC'
454: ,P_PK1_NAME => 'TRACKING_ID'
455: ,P_PK1_NUM_VALUE => disc_rec.tracking_id
456: ,P_USER_ID => asg_base.get_user_id(disc_rec.client_id)
457: );