DBA Data[Home] [Help]

APPS.CSM_DEFERRED_TXNS_PKG dependencies on CSM_ACC_PKG

Line 148: CSM_ACC_PKG.Delete_Acc

144: --delete children
145: FOR rec IN (SELECT tracking_id FROM CSM_DEFERRED_NFN_INFO
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

Line 149: ( P_PUBLICATION_ITEM_NAMES => CSM_ACC_PKG.t_publication_item_list('CSM_DEFERRED_TRANSACTIONS')

145: FOR rec IN (SELECT tracking_id FROM CSM_DEFERRED_NFN_INFO
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)

Line 276: CSM_ACC_PKG.Delete_Acc

272: disc_rec.OBJECT_NAME,
273: disc_rec.sequence,l_process_status,false);
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

Line 277: ( P_PUBLICATION_ITEM_NAMES => CSM_ACC_PKG.t_publication_item_list('CSM_DEFERRED_TRANSACTIONS')

273: disc_rec.sequence,l_process_status,false);
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)

Line 311: CSM_ACC_PKG.Delete_Acc

307: CLOSE c_tracking_tree;
308:
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)

Line 312: ( P_PUBLICATION_ITEM_NAMES => CSM_ACC_PKG.t_publication_item_list('CSM_DEFERRED_TRANSACTIONS')

308:
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))

Line 390: CSM_ACC_PKG.Delete_Acc

386: disc_rec.error_msg, --IN variable of asg api
387: x_return_status);
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

Line 391: ( P_PUBLICATION_ITEM_NAMES => CSM_ACC_PKG.t_publication_item_list('CSM_DEFERRED_TRANSACTIONS')

387: x_return_status);
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)

Line 451: CSM_ACC_PKG.Delete_Acc

447: disc_rec.error_msg, --IN variable of asg api
448: x_return_status);
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

Line 452: ( P_PUBLICATION_ITEM_NAMES => CSM_ACC_PKG.t_publication_item_list('CSM_DEFERRED_TRANSACTIONS')

448: x_return_status);
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)