APPS.ASG_HELPER dependencies on ASG_PURGE_SDQ

Line 383: DELETE FROM asg_purge_sdq

379: DELETE FROM asg_user_pub_resps
380: WHERE user_name = p_user_name AND
381: pub_name = p_pub_name;
382:
383: DELETE FROM asg_purge_sdq
384: WHERE user_name = p_user_name AND
385: pub_name = p_pub_name;
386:
387: DELETE FROM asg_complete_refresh

Line 516: --delete from asg_purge_sdq and asg_complete_refresh

512: 'asg_helper',g_err_level);
513: END IF;
514: END;
515:
516: --delete from asg_purge_sdq and asg_complete_refresh
517:
518: DELETE FROM asg_purge_sdq
519: WHERE user_name = l_user_name;
520:

Line 518: DELETE FROM asg_purge_sdq

514: END;
515:
516: --delete from asg_purge_sdq and asg_complete_refresh
517:
518: DELETE FROM asg_purge_sdq
519: WHERE user_name = l_user_name;
520:
521: DELETE FROM asg_complete_refresh
522: WHERE user_name = l_user_name;

Line 1184: asg_purge_sdq(user_name,pub_name,transaction_id,CREATION_DATE,CREATED_BY,

1180: END IF;
1181:
1182: -- neither ALL nor custom publication..
1183: INSERT INTO
1184: asg_purge_sdq(user_name,pub_name,transaction_id,CREATION_DATE,CREATED_BY,
1185: LAST_UPDATE_DATE,LAST_UPDATED_BY)
1186: values(p_clientid,p_pub,null,sysdate,1,sysdate,1);
1187: commit;
1188:

Line 1191: UPDATE asg_purge_sdq

1187: commit;
1188:
1189: EXCEPTION
1190: WHEN DUP_VAL_ON_INDEX then
1191: UPDATE asg_purge_sdq
1192: SET transaction_id = null,last_update_date = SYSDATE
1193: WHERE user_name = p_clientid AND pub_name = p_pub;
1194: commit;
1195: END set_first_synch;