APPS.CSM_DEFERRED_TXNS_PKG dependencies on ASG_BASE

Line 142: AND USER_ID=asg_base.get_user_id(p_user_name);

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

Line 153: ,P_USER_ID => asg_base.get_user_id(p_user_name)

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: );
155: END LOOP;
156:
157: DELETE FROM CSM_DEFERRED_NFN_INFO WHERE dml_0_rec.tracking_id IN (TRACKING_ID,PARENT_ID) AND CLIENT_ID=p_user_name;

Line 281: ,P_USER_ID => asg_base.get_user_id(disc_rec.client_id)

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: );
283:
284: l_cnt:=l_cnt+1;
285: l_track_tab(l_cnt):=disc_rec.tracking_id;

Line 316: ,P_USER_ID => asg_base.get_user_id(l_uname_tab(I))

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: );
318:
319: DELETE FROM CSM_DEFERRED_NFN_INFO WHERE TRACKING_ID = l_track_tab(I);
320: END LOOP;

Line 350: l_qry := 'DELETE FROM ' ||asg_base.G_OLITE_SCHEMA ||'.C$INQ '

346: END LOOP;
347:
348:
349: /* not required..done while upload in purge_pub_items
350: l_qry := 'DELETE FROM ' ||asg_base.G_OLITE_SCHEMA ||'.C$INQ '
351: ||' WHERE STORE='''||g_pub_name||''' AND TRANID$$='||p_tranid||' AND CLID$$CS= '''||p_user_name||'''';
352: execute immediate l_qry;
353: */
354:

Line 395: ,P_USER_ID => asg_base.get_user_id(disc_rec.client_id)

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: );
397:
398: END LOOP;
399: END LOOP;

Line 456: ,P_USER_ID => asg_base.get_user_id(disc_rec.client_id)

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: );
458:
459: l_cnt:=l_cnt+1;
460: l_track_tab(l_cnt):=disc_rec.tracking_id;