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