APPS.ASG_HELPER dependencies on ASG_PURGE_SDQ

Line 364: DELETE FROM asg_purge_sdq

360: DELETE FROM asg_user_pub_resps
361: WHERE user_name = p_user_name AND
362: pub_name = p_pub_name;
363:
364: DELETE FROM asg_purge_sdq
365: WHERE user_name = p_user_name AND
366: pub_name = p_pub_name;
367:
368: DELETE FROM asg_complete_refresh

Line 497: --delete from asg_purge_sdq and asg_complete_refresh

493: 'asg_helper',g_err_level);
494: END IF;
495: END;
496:
497: --delete from asg_purge_sdq and asg_complete_refresh
498:
499: DELETE FROM asg_purge_sdq
500: WHERE user_name = l_user_name;
501:

Line 499: DELETE FROM asg_purge_sdq

495: END;
496:
497: --delete from asg_purge_sdq and asg_complete_refresh
498:
499: DELETE FROM asg_purge_sdq
500: WHERE user_name = l_user_name;
501:
502: DELETE FROM asg_complete_refresh
503: WHERE user_name = l_user_name;

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

1117: END IF;
1118:
1119: -- neither ALL nor custom publication..
1120: INSERT INTO
1121: asg_purge_sdq(user_name,pub_name,transaction_id,CREATION_DATE,CREATED_BY,
1122: LAST_UPDATE_DATE,LAST_UPDATED_BY)
1123: values(p_clientid,p_pub,null,sysdate,1,sysdate,1);
1124: commit;
1125:

Line 1128: UPDATE asg_purge_sdq

1124: commit;
1125:
1126: EXCEPTION
1127: WHEN DUP_VAL_ON_INDEX then
1128: UPDATE asg_purge_sdq
1129: SET transaction_id = null,last_update_date = SYSDATE
1130: WHERE user_name = p_clientid AND pub_name = p_pub;
1131: commit;
1132: END set_first_synch;