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_HELPER dependencies on ASG_PUB

Line 119: FROM asg_pub

115: p_pub_name IN VARCHAR2)
116: IS
117: CURSOR c_wrapper_name(p_pub_name VARCHAR2) IS
118: SELECT wrapper_name
119: FROM asg_pub
120: WHERE name = p_pub_name;
121: CURSOR c_custom_pub(p_pub_name VARCHAR2) IS
122: SELECT nvl(custom, 'N')
123: FROM asg_pub

Line 123: FROM asg_pub

119: FROM asg_pub
120: WHERE name = p_pub_name;
121: CURSOR c_custom_pub(p_pub_name VARCHAR2) IS
122: SELECT nvl(custom, 'N')
123: FROM asg_pub
124: WHERE name = p_pub_name;
125: l_custom_pub VARCHAR2(1);
126: l_callback_string VARCHAR2(512);
127: l_user_id NUMBER;

Line 128: l_wrapper_name asg_pub.wrapper_name%type;

124: WHERE name = p_pub_name;
125: l_custom_pub VARCHAR2(1);
126: l_callback_string VARCHAR2(512);
127: l_user_id NUMBER;
128: l_wrapper_name asg_pub.wrapper_name%type;
129: BEGIN
130:
131: IF(p_pub_name = 'ALL') THEN
132: return;

Line 190: FROM asg_pub

186: p_pub_name IN VARCHAR2)
187: IS
188: CURSOR c_wrapper_name(p_pub_name VARCHAR2) IS
189: SELECT wrapper_name
190: FROM asg_pub
191: WHERE name = p_pub_name;
192: CURSOR c_custom_pub(p_pub_name VARCHAR2) IS
193: SELECT nvl(custom, 'N')
194: FROM asg_pub

Line 194: FROM asg_pub

190: FROM asg_pub
191: WHERE name = p_pub_name;
192: CURSOR c_custom_pub(p_pub_name VARCHAR2) IS
193: SELECT nvl(custom, 'N')
194: FROM asg_pub
195: WHERE name = p_pub_name;
196: l_custom_pub VARCHAR2(1);
197: l_callback_string VARCHAR2(512);
198: l_user_id NUMBER;

Line 199: l_wrapper_name asg_pub.wrapper_name%type;

195: WHERE name = p_pub_name;
196: l_custom_pub VARCHAR2(1);
197: l_callback_string VARCHAR2(512);
198: l_user_id NUMBER;
199: l_wrapper_name asg_pub.wrapper_name%type;
200: BEGIN
201:
202: IF(p_pub_name = 'ALL') THEN
203: return;

Line 390: ( SELECT item_id FROM asg_pub_item

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);
392:
393: COMMIT;
394: IF(check_is_log_enabled(g_stmt_level))

Line 585: UPDATE asg_pub

581: PROCEDURE enable_synch
582: IS
583: BEGIN
584:
585: UPDATE asg_pub
586: SET enable_synch = 'Y';
587: COMMIT;
588:
589: END enable_synch;

Line 597: UPDATE asg_pub

593: PROCEDURE enable_pub_synch(p_pub_name IN VARCHAR2)
594: IS
595: BEGIN
596:
597: UPDATE asg_pub
598: SET enable_synch = 'Y'
599: WHERE name = upper(p_pub_name);
600: COMMIT;
601:

Line 609: UPDATE asg_pub

605: PROCEDURE disable_synch
606: IS
607: BEGIN
608:
609: UPDATE asg_pub
610: SET enable_synch = 'N';
611: COMMIT;
612:
613: END disable_synch;

Line 620: UPDATE asg_pub

616: PROCEDURE disable_pub_synch(p_pub_name IN VARCHAR2)
617: IS
618: BEGIN
619:
620: UPDATE asg_pub
621: SET enable_synch = 'N'
622: WHERE name = upper(p_pub_name);
623: COMMIT;
624:

Line 652: 'FROM asg_user_pub_resps aup, asg_pub ap ' ||

648: END IF;
649:
650: -- Check if access table population has been completed for this user
651: l_query_string := 'SELECT count(*) ' ||
652: 'FROM asg_user_pub_resps aup, asg_pub ap ' ||
653: 'WHERE aup.user_name = :1 AND ' ||
654: ' aup.pub_name = ap.name AND ' ||
655: ' aup.synch_disabled = ''Y'' AND ' ||
656: ' ap.name in ' ||

Line 658: ' FROM asg_pub_item api, ' ||

654: ' aup.pub_name = ap.name AND ' ||
655: ' aup.synch_disabled = ''Y'' AND ' ||
656: ' ap.name in ' ||
657: ' (SELECT distinct pub_name ' ||
658: ' FROM asg_pub_item api, ' ||
659: asg_base.G_OLITE_SCHEMA || '.c$pub_list_q cpq ' ||
660: ' where api.name = cpq.name)';
661:
662: EXECUTE IMMEDIATE l_query_string

Line 677: 'FROM asg_user_pub_resps aup, asg_pub ap ' ||

673: -- Check if synchronization is disabled for any of the
674: -- publications the user is subscribed to
675: -- and downloading as part of current synch due to patching
676: l_query_string := 'SELECT count(*) ' ||
677: 'FROM asg_user_pub_resps aup, asg_pub ap ' ||
678: 'WHERE aup.user_name = :1 AND ' ||
679: ' aup.pub_name = ap.name AND ' ||
680: ' ap.enable_synch = ''N'' AND ' ||
681: ' ap.name in ' ||

Line 683: ' FROM asg_pub_item api, ' ||

679: ' aup.pub_name = ap.name AND ' ||
680: ' ap.enable_synch = ''N'' AND ' ||
681: ' ap.name in ' ||
682: ' (SELECT distinct pub_name ' ||
683: ' FROM asg_pub_item api, ' ||
684: asg_base.G_OLITE_SCHEMA || '.c$pub_list_q cpq ' ||
685: ' where api.name = cpq.name)';
686:
687: EXECUTE IMMEDIATE l_query_string

Line 707: FROM asg_user_pub_resps aup, asg_pub_item api

703: PROCEDURE set_complete_refresh(p_pub_item VARCHAR2)
704: IS
705: CURSOR c_all_users(pi_name VARCHAR2) IS
706: SELECT user_name
707: FROM asg_user_pub_resps aup, asg_pub_item api
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(*)

Line 716: FROM asg_user_pub_resps aup, asg_pub_item api

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
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

Line 1030: SELECT NAME FROM asg_pub WHERE device_type=l_device_type;

1026: l_dml VARCHAR2(2000);
1027: l_ret NUMBER;
1028: l_pub_name varchar2(30);
1029: CURSOR get_pub(l_device_type varchar2) IS
1030: SELECT NAME FROM asg_pub WHERE device_type=l_device_type;
1031:
1032: PRAGMA AUTONOMOUS_TRANSACTION;
1033: BEGIN
1034: UPDATE asg_user

Line 1073: FROM asg_user_pub_resps aupr, asg_pub ap

1069: FROM asg_user
1070: WHERE cookie is null;
1071: CURSOR c_user_devices (p_user_name VARCHAR2) IS
1072: SELECT distinct ap.device_type
1073: FROM asg_user_pub_resps aupr, asg_pub ap
1074: WHERE aupr.pub_name = ap.name and
1075: aupr.user_name = p_user_name and
1076: ap.device_type is not null;
1077: l_current_user VARCHAR2(100);

Line 1087: -- Find the device type from asg_user_pub_resps and asg_pub

1083: l_sql_string VARCHAR2(512);
1084: BEGIN
1085:
1086: -- Update users whose last synch device type is not yet set.
1087: -- Find the device type from asg_user_pub_resps and asg_pub
1088: -- For users with multiple devices query Oracle Lite tables
1089: -- If device type for last synch is not knowable, do not update asg_user
1090: FOR cu in c_users LOOP
1091: l_current_user := cu.user_name;

Line 1164: FROM asg_pub

1160: PROCEDURE set_first_synch(p_clientid in varchar2,p_pub in varchar2)
1161: is
1162: CURSOR c_custom_pub(l_pub_name VARCHAR2) IS
1163: SELECT nvl(custom, 'N')
1164: FROM asg_pub
1165: WHERE name = l_pub_name;
1166: l_custom_pub varchar2(2);
1167: PRAGMA autonomous_transaction;
1168: BEGIN

Line 1479: FROM asg_pub_item

1475: IS
1476: CURSOR c_inq_outq_objects
1477: IS
1478: SELECT base_object_name, inq_name
1479: FROM asg_pub_item
1480: WHERE enabled = 'Y';
1481: l_olite_schema VARCHAR2(30);
1482: l_sql_string VARCHAR2(4096);
1483: BEGIN