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.

[Home] [Help]

APPS.ASG_CONS_QPKG dependencies on ASG_COMPLETE_REFRESH

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

333: IF(g_first_synch) THEN
334: set_synch_completed(p_clientid);
335: delete_row(p_clientid);
336: IF(asg_helper.check_is_log_enabled(g_stmt_level)) THEN
337: asg_helper.log('First synch..deleted all rows from asg_complete_refresh'
338: ,'asg_cons_qpkg',g_stmt_level);
339: END IF;
340: ELSE
341: process_compref_table(p_clientid,p_last_tranid);

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

659: END populate_q_rec_count;
660:
661:
662: --routine that sets PI's in c$pub_list_q that have
663: --synch_completed (in asg_complete_refresh) set to 'N' for complete refresh
664: PROCEDURE set_complete_refresh
665: IS
666: l_user_name VARCHAR2(100);
667: l_qry_string VARCHAR2(1024);

Line 672: ||'SELECT publication_item FROM asg_complete_refresh '

668: BEGIN
669: l_user_name := asg_base.get_user_name;
670: l_qry_string := 'update '||asg_base.G_OLITE_SCHEMA||'.c$pub_list_q '
671: ||'set comp_ref = ''Y'' '||' where name IN ('
672: ||'SELECT publication_item FROM asg_complete_refresh '
673: ||' WHERE synch_completed=''N'' AND user_name = :1 '
674: ||' AND publication_item IN '
675: ||' ( SELECT name FROM '||asg_base.G_OLITE_SCHEMA
676: ||'.c$pub_list_q ))' ;

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

679: END set_complete_refresh;
680:
681:
682:
683: --sets synch_completed flag in asg_complete_refresh to 'Y' for
684: --a particular pub_item and user_name
685: PROCEDURE set_synch_completed(p_user_name VARCHAR2,p_pub_item VARCHAR2)
686: IS
687: BEGIN

Line 688: UPDATE asg_complete_refresh

684: --a particular pub_item and user_name
685: PROCEDURE set_synch_completed(p_user_name VARCHAR2,p_pub_item VARCHAR2)
686: IS
687: BEGIN
688: UPDATE asg_complete_refresh
689: SET synch_completed='Y' , last_update_date = sysdate
690: WHERE user_name=p_user_name
691: AND publication_item=p_pub_item;
692: END set_synch_completed;

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

690: WHERE user_name=p_user_name
691: AND publication_item=p_pub_item;
692: END set_synch_completed;
693:
694: --sets synch_completed flag in asg_complete_refresh to 'Y' for
695: --pub_item for a given user_name
696: PROCEDURE set_synch_completed(p_user_name VARCHAR2)
697: IS
698: l_qry_string VARCHAR2(1024);

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

696: PROCEDURE set_synch_completed(p_user_name VARCHAR2)
697: IS
698: l_qry_string VARCHAR2(1024);
699: BEGIN
700: l_qry_string := ' UPDATE asg_complete_refresh SET ' ||
701: ' synch_completed=''Y'',last_update_date=sysdate ' ||
702: ' WHERE user_name= :1 ' ||
703: ' AND ' ||
704: ' publication_item IN ' ||

Line 713: --from asg_complete_refresh

709:
710: END set_synch_completed;
711:
712: --removes the row corresponding to a user_name and pub_item
713: --from asg_complete_refresh
714: PROCEDURE delete_row(p_user_name VARCHAR2,p_pub_item VARCHAR2)
715: IS
716: BEGIN
717: DELETE FROM asg_complete_refresh

Line 717: DELETE FROM asg_complete_refresh

713: --from asg_complete_refresh
714: PROCEDURE delete_row(p_user_name VARCHAR2,p_pub_item VARCHAR2)
715: IS
716: BEGIN
717: DELETE FROM asg_complete_refresh
718: WHERE user_name = p_user_name AND
719: publication_item = p_pub_item;
720: END delete_row;
721:

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

718: WHERE user_name = p_user_name AND
719: publication_item = p_pub_item;
720: END delete_row;
721:
722: --removes all rows for user_name from asg_complete_refresh
723: --for the current publication items with synch_completed='Y'.
724: PROCEDURE delete_row(p_user_name VARCHAR2)
725: IS
726: l_qry_string VARCHAR2(1024);

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

724: PROCEDURE delete_row(p_user_name VARCHAR2)
725: IS
726: l_qry_string VARCHAR2(1024);
727: BEGIN
728: l_qry_string:= ' DELETE FROM asg_complete_refresh '||
729: ' WHERE user_name = :1 ' ||
730: ' AND synch_completed = ''Y'' AND '||
731: ' publication_item IN ' ||
732: '(SELECT name FROM '||asg_base.G_OLITE_SCHEMA||

Line 740: --ROUTINE FOR REMOVING RECORDS FROM asg_complete_refresh

736: END delete_row;
737:
738:
739:
740: --ROUTINE FOR REMOVING RECORDS FROM asg_complete_refresh
741: -- if the previous synch was successful
742: PROCEDURE process_compref_table(p_user_name VARCHAR2,p_last_tranid NUMBER)
743: IS
744: l_tranid NUMBER;

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

756: delete_row(p_user_name);
757: ELSE
758: --previous synch was not successful
759: --so set all PI's of the current user to complete_synch
760: l_str:= 'UPDATE asg_complete_refresh SET synch_completed=''N'' , '
761: ||' last_update_date = sysdate WHERE user_name = :1 '
762: ||' AND publication_item in '
763: ||'(SELECT name FROM '||asg_base.G_OLITE_SCHEMA
764: ||'.c$pub_list_q)';