APPS.ASG_HELPER dependencies on ASG_COMPLETE_REFRESH

Line 387: DELETE FROM asg_complete_refresh

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
388: WHERE user_name = p_user_name AND
389: publication_item IN
390: ( SELECT item_id FROM asg_pub_item
391: WHERE pub_name = p_pub_name);

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 521: DELETE FROM 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;
523:
524: DELETE FROM asg_sequence_partitions
525: WHERE clientid = p_user_name;

Line 712: FROM asg_complete_refresh

708: WHERE api.name = upper(pi_name) AND
709: api.pub_name = aup.pub_name;
710: CURSOR c_row_exists(pi_name VARCHAR2) IS
711: SELECT count(*)
712: FROM asg_complete_refresh
713: WHERE publication_item=pi_name;
714: CURSOR c_new_users(pi_name VARCHAR2) IS
715: SELECT user_name
716: FROM asg_user_pub_resps aup, asg_pub_item api

Line 721: FROM asg_complete_refresh

717: WHERE api.name = upper(pi_name) AND
718: aup.pub_name = api.pub_name AND
719: user_name NOT IN
720: ( SELECT user_name
721: FROM asg_complete_refresh
722: WHERE publication_item = pi_name );
723: l_pub_item VARCHAR2(30);
724: l_cnt NUMBER :=0;
725: l_uname c_all_users%ROWTYPE;

Line 741: UPDATE asg_complete_refresh

737: FETCH c_row_exists INTO l_cnt;
738: -- Records exist
739: IF(l_cnt > 0) THEN
740: -- Reset all the records so that they will be completely refreshed
741: UPDATE asg_complete_refresh
742: SET last_update_date=sysdate,synch_completed='N'
743: WHERE publication_item=l_pub_item;
744:
745: OPEN c_new_users(l_pub_item);

Line 749: INSERT INTO asg_complete_refresh(

745: OPEN c_new_users(l_pub_item);
746: LOOP
747: FETCH c_new_users INTO l_recf1;
748: EXIT WHEN c_new_users%NOTFOUND;
749: INSERT INTO asg_complete_refresh(
750: USER_NAME,
751: PUBLICATION_ITEM,
752: SYNCH_COMPLETED,
753: CREATION_DATE,

Line 777: INSERT INTO asg_complete_refresh(

773: OPEN c_all_users(l_pub_item);
774: LOOP
775: FETCH c_all_users INTO l_uname;
776: EXIT WHEN c_all_users%NOTFOUND;
777: INSERT INTO asg_complete_refresh(
778: USER_NAME,
779: PUBLICATION_ITEM,
780: SYNCH_COMPLETED,
781: CREATION_DATE,