APPS.ASG_HELPER dependencies on ASG_COMPLETE_REFRESH

Line 368: DELETE FROM asg_complete_refresh

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
369: WHERE user_name = p_user_name AND
370: publication_item IN
371: ( SELECT item_id FROM asg_pub_item
372: WHERE pub_name = p_pub_name);

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 502: DELETE FROM 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;
504:
505: DELETE FROM asg_sequence_partitions
506: WHERE clientid = p_user_name;

Line 693: FROM asg_complete_refresh

689: WHERE api.name = upper(pi_name) AND
690: api.pub_name = aup.pub_name;
691: CURSOR c_row_exists(pi_name VARCHAR2) IS
692: SELECT count(*)
693: FROM asg_complete_refresh
694: WHERE publication_item=pi_name;
695: CURSOR c_new_users(pi_name VARCHAR2) IS
696: SELECT user_name
697: FROM asg_user_pub_resps aup, asg_pub_item api

Line 702: FROM asg_complete_refresh

698: WHERE api.name = upper(pi_name) AND
699: aup.pub_name = api.pub_name AND
700: user_name NOT IN
701: ( SELECT user_name
702: FROM asg_complete_refresh
703: WHERE publication_item = pi_name );
704: l_pub_item VARCHAR2(30);
705: l_cnt NUMBER :=0;
706: l_uname c_all_users%ROWTYPE;

Line 722: UPDATE asg_complete_refresh

718: FETCH c_row_exists INTO l_cnt;
719: -- Records exist
720: IF(l_cnt > 0) THEN
721: -- Reset all the records so that they will be completely refreshed
722: UPDATE asg_complete_refresh
723: SET last_update_date=sysdate,synch_completed='N'
724: WHERE publication_item=l_pub_item;
725:
726: OPEN c_new_users(l_pub_item);

Line 730: INSERT INTO asg_complete_refresh(

726: OPEN c_new_users(l_pub_item);
727: LOOP
728: FETCH c_new_users INTO l_recf1;
729: EXIT WHEN c_new_users%NOTFOUND;
730: INSERT INTO asg_complete_refresh(
731: USER_NAME,
732: PUBLICATION_ITEM,
733: SYNCH_COMPLETED,
734: CREATION_DATE,

Line 758: INSERT INTO asg_complete_refresh(

754: OPEN c_all_users(l_pub_item);
755: LOOP
756: FETCH c_all_users INTO l_uname;
757: EXIT WHEN c_all_users%NOTFOUND;
758: INSERT INTO asg_complete_refresh(
759: USER_NAME,
760: PUBLICATION_ITEM,
761: SYNCH_COMPLETED,
762: CREATION_DATE,