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 118: FROM asg_pub

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

Line 122: FROM asg_pub

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

Line 127: l_wrapper_name asg_pub.wrapper_name%type;

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

Line 189: FROM asg_pub

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

Line 193: FROM asg_pub

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

Line 198: l_wrapper_name asg_pub.wrapper_name%type;

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

Line 371: ( SELECT item_id FROM asg_pub_item

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);
373:
374: COMMIT;
375: IF(check_is_log_enabled(g_stmt_level))

Line 566: UPDATE asg_pub

562: PROCEDURE enable_synch
563: IS
564: BEGIN
565:
566: UPDATE asg_pub
567: SET enable_synch = 'Y';
568: COMMIT;
569:
570: END enable_synch;

Line 578: UPDATE asg_pub

574: PROCEDURE enable_pub_synch(p_pub_name IN VARCHAR2)
575: IS
576: BEGIN
577:
578: UPDATE asg_pub
579: SET enable_synch = 'Y'
580: WHERE name = upper(p_pub_name);
581: COMMIT;
582:

Line 590: UPDATE asg_pub

586: PROCEDURE disable_synch
587: IS
588: BEGIN
589:
590: UPDATE asg_pub
591: SET enable_synch = 'N';
592: COMMIT;
593:
594: END disable_synch;

Line 601: UPDATE asg_pub

597: PROCEDURE disable_pub_synch(p_pub_name IN VARCHAR2)
598: IS
599: BEGIN
600:
601: UPDATE asg_pub
602: SET enable_synch = 'N'
603: WHERE name = upper(p_pub_name);
604: COMMIT;
605:

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

629: END IF;
630:
631: -- Check if access table population has been completed for this user
632: l_query_string := 'SELECT count(*) ' ||
633: 'FROM asg_user_pub_resps aup, asg_pub ap ' ||
634: 'WHERE aup.user_name = :1 AND ' ||
635: ' aup.pub_name = ap.name AND ' ||
636: ' aup.synch_disabled = ''Y'' AND ' ||
637: ' ap.name in ' ||

Line 639: ' FROM asg_pub_item api, ' ||

635: ' aup.pub_name = ap.name AND ' ||
636: ' aup.synch_disabled = ''Y'' AND ' ||
637: ' ap.name in ' ||
638: ' (SELECT distinct pub_name ' ||
639: ' FROM asg_pub_item api, ' ||
640: asg_base.G_OLITE_SCHEMA || '.c$pub_list_q cpq ' ||
641: ' where api.name = cpq.name)';
642:
643: EXECUTE IMMEDIATE l_query_string

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

654: -- Check if synchronization is disabled for any of the
655: -- publications the user is subscribed to
656: -- and downloading as part of current synch due to patching
657: l_query_string := 'SELECT count(*) ' ||
658: 'FROM asg_user_pub_resps aup, asg_pub ap ' ||
659: 'WHERE aup.user_name = :1 AND ' ||
660: ' aup.pub_name = ap.name AND ' ||
661: ' ap.enable_synch = ''N'' AND ' ||
662: ' ap.name in ' ||

Line 664: ' FROM asg_pub_item api, ' ||

660: ' aup.pub_name = ap.name AND ' ||
661: ' ap.enable_synch = ''N'' AND ' ||
662: ' ap.name in ' ||
663: ' (SELECT distinct pub_name ' ||
664: ' FROM asg_pub_item api, ' ||
665: asg_base.G_OLITE_SCHEMA || '.c$pub_list_q cpq ' ||
666: ' where api.name = cpq.name)';
667:
668: EXECUTE IMMEDIATE l_query_string

Line 688: FROM asg_user_pub_resps aup, asg_pub_item api

684: PROCEDURE set_complete_refresh(p_pub_item VARCHAR2)
685: IS
686: CURSOR c_all_users(pi_name VARCHAR2) IS
687: SELECT user_name
688: FROM asg_user_pub_resps aup, asg_pub_item api
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(*)

Line 697: FROM asg_user_pub_resps aup, asg_pub_item api

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

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

969: l_dml VARCHAR2(2000);
970: l_ret NUMBER;
971: l_pub_name varchar2(30);
972: CURSOR get_pub(l_device_type varchar2) IS
973: SELECT NAME FROM asg_pub WHERE device_type=l_device_type;
974:
975: PRAGMA AUTONOMOUS_TRANSACTION;
976: BEGIN
977: UPDATE asg_user

Line 1010: FROM asg_user_pub_resps aupr, asg_pub ap

1006: FROM asg_user
1007: WHERE cookie is null;
1008: CURSOR c_user_devices (p_user_name VARCHAR2) IS
1009: SELECT distinct ap.device_type
1010: FROM asg_user_pub_resps aupr, asg_pub ap
1011: WHERE aupr.pub_name = ap.name and
1012: aupr.user_name = p_user_name and
1013: ap.device_type is not null;
1014: l_current_user VARCHAR2(30);

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

1020: l_sql_string VARCHAR2(512);
1021: BEGIN
1022:
1023: -- Update users whose last synch device type is not yet set.
1024: -- Find the device type from asg_user_pub_resps and asg_pub
1025: -- For users with multiple devices query Oracle Lite tables
1026: -- If device type for last synch is not knowable, do not update asg_user
1027: FOR cu in c_users LOOP
1028: l_current_user := cu.user_name;

Line 1101: FROM asg_pub

1097: PROCEDURE set_first_synch(p_clientid in varchar2,p_pub in varchar2)
1098: is
1099: CURSOR c_custom_pub(l_pub_name VARCHAR2) IS
1100: SELECT nvl(custom, 'N')
1101: FROM asg_pub
1102: WHERE name = l_pub_name;
1103: l_custom_pub varchar2(2);
1104: PRAGMA autonomous_transaction;
1105: BEGIN

Line 1416: FROM asg_pub_item

1412: IS
1413: CURSOR c_inq_outq_objects
1414: IS
1415: SELECT base_object_name, inq_name
1416: FROM asg_pub_item
1417: WHERE enabled = 'Y';
1418: l_olite_schema VARCHAR2(30);
1419: l_sql_string VARCHAR2(4096);
1420: BEGIN