eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ASG_CONS_QPKG dependencies on ASG_COMPLETE_REFRESH

Line 302: asg_helper.log('First synch..deleted all rows from asg_complete_refresh'

298: IF(g_first_synch) THEN
299: set_synch_completed(p_clientid);
300: delete_row(p_clientid);
301: IF(asg_helper.check_is_log_enabled(g_stmt_level)) THEN
302: asg_helper.log('First synch..deleted all rows from asg_complete_refresh'
303: ,'asg_cons_qpkg',g_stmt_level);
304: END IF;
305: ELSE
306: process_compref_table(p_clientid,p_last_tranid);

Line 622: --synch_completed (in asg_complete_refresh) set to 'N' for complete refresh

618: END populate_q_rec_count;
619:
620:
621: --routine that sets PI's in c$pub_list_q that have
622: --synch_completed (in asg_complete_refresh) set to 'N' for complete refresh
623: PROCEDURE set_complete_refresh
624: IS
625: l_user_name VARCHAR2(30);
626: l_qry_string VARCHAR2(1024);

Line 631: ||'SELECT publication_item FROM asg_complete_refresh '

627: BEGIN
628: l_user_name := asg_base.get_user_name;
629: l_qry_string := 'update '||asg_base.G_OLITE_SCHEMA||'.c$pub_list_q '
630: ||'set comp_ref = ''Y'' '||' where name IN ('
631: ||'SELECT publication_item FROM asg_complete_refresh '
632: ||' WHERE synch_completed=''N'' AND user_name = :1 '
633: ||' AND publication_item IN '
634: ||' ( SELECT name FROM '||asg_base.G_OLITE_SCHEMA
635: ||'.c$pub_list_q ))' ;

Line 642: --sets synch_completed flag in asg_complete_refresh to 'Y' for

638: END set_complete_refresh;
639:
640:
641:
642: --sets synch_completed flag in asg_complete_refresh to 'Y' for
643: --a particular pub_item and user_name
644: PROCEDURE set_synch_completed(p_user_name VARCHAR2,p_pub_item VARCHAR2)
645: IS
646: BEGIN

Line 647: UPDATE asg_complete_refresh

643: --a particular pub_item and user_name
644: PROCEDURE set_synch_completed(p_user_name VARCHAR2,p_pub_item VARCHAR2)
645: IS
646: BEGIN
647: UPDATE asg_complete_refresh
648: SET synch_completed='Y' , last_update_date = sysdate
649: WHERE user_name=p_user_name
650: AND publication_item=p_pub_item;
651: END set_synch_completed;

Line 653: --sets synch_completed flag in asg_complete_refresh to 'Y' for

649: WHERE user_name=p_user_name
650: AND publication_item=p_pub_item;
651: END set_synch_completed;
652:
653: --sets synch_completed flag in asg_complete_refresh to 'Y' for
654: --pub_item for a given user_name
655: PROCEDURE set_synch_completed(p_user_name VARCHAR2)
656: IS
657: l_qry_string VARCHAR2(1024);

Line 659: l_qry_string := ' UPDATE asg_complete_refresh SET ' ||

655: PROCEDURE set_synch_completed(p_user_name VARCHAR2)
656: IS
657: l_qry_string VARCHAR2(1024);
658: BEGIN
659: l_qry_string := ' UPDATE asg_complete_refresh SET ' ||
660: ' synch_completed=''Y'',last_update_date=sysdate ' ||
661: ' WHERE user_name= :1 ' ||
662: ' AND ' ||
663: ' publication_item IN ' ||

Line 672: --from asg_complete_refresh

668:
669: END set_synch_completed;
670:
671: --removes the row corresponding to a user_name and pub_item
672: --from asg_complete_refresh
673: PROCEDURE delete_row(p_user_name VARCHAR2,p_pub_item VARCHAR2)
674: IS
675: BEGIN
676: DELETE FROM asg_complete_refresh

Line 676: DELETE FROM asg_complete_refresh

672: --from asg_complete_refresh
673: PROCEDURE delete_row(p_user_name VARCHAR2,p_pub_item VARCHAR2)
674: IS
675: BEGIN
676: DELETE FROM asg_complete_refresh
677: WHERE user_name = p_user_name AND
678: publication_item = p_pub_item;
679: END delete_row;
680:

Line 681: --removes all rows for user_name from asg_complete_refresh

677: WHERE user_name = p_user_name AND
678: publication_item = p_pub_item;
679: END delete_row;
680:
681: --removes all rows for user_name from asg_complete_refresh
682: --for the current publication items with synch_completed='Y'.
683: PROCEDURE delete_row(p_user_name VARCHAR2)
684: IS
685: l_qry_string VARCHAR2(1024);

Line 687: l_qry_string:= ' DELETE FROM asg_complete_refresh '||

683: PROCEDURE delete_row(p_user_name VARCHAR2)
684: IS
685: l_qry_string VARCHAR2(1024);
686: BEGIN
687: l_qry_string:= ' DELETE FROM asg_complete_refresh '||
688: ' WHERE user_name = :1 ' ||
689: ' AND synch_completed = ''Y'' AND '||
690: ' publication_item IN ' ||
691: '(SELECT name FROM '||asg_base.G_OLITE_SCHEMA||

Line 699: --ROUTINE FOR REMOVING RECORDS FROM asg_complete_refresh

695: END delete_row;
696:
697:
698:
699: --ROUTINE FOR REMOVING RECORDS FROM asg_complete_refresh
700: -- if the previous synch was successful
701: PROCEDURE process_compref_table(p_user_name VARCHAR2,p_last_tranid NUMBER)
702: IS
703: l_tranid NUMBER;

Line 719: l_str:= 'UPDATE asg_complete_refresh SET synch_completed=''N'' , '

715: delete_row(p_user_name);
716: ELSE
717: --previous synch was not successful
718: --so set all PI's of the current user to complete_synch
719: l_str:= 'UPDATE asg_complete_refresh SET synch_completed=''N'' , '
720: ||' last_update_date = sysdate WHERE user_name = :1 '
721: ||' AND publication_item in '
722: ||'(SELECT name FROM '||asg_base.G_OLITE_SCHEMA
723: ||'.c$pub_list_q)';