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_BASE

Line 159: l_user_id := asg_base.get_user_id(p_user_name);

155: END IF;
156: RAISE_APPLICATION_ERROR(-20989, 'Callback package missing for ' ||
157: 'publication: ' || p_pub_name);
158: END IF;
159: l_user_id := asg_base.get_user_id(p_user_name);
160:
161: BEGIN
162: l_callback_string := 'BEGIN ' || l_wrapper_name ||
163: '.populate_access_records( :1 ); END;';

Line 229: l_user_id := asg_base.get_user_id(p_user_name);

225: END IF;
226: RAISE_APPLICATION_ERROR(-20989, 'Callback package missing for ' ||
227: 'publication: ' || p_pub_name);
228: END IF;
229: l_user_id := asg_base.get_user_id(p_user_name);
230:
231: BEGIN
232: l_callback_string := 'BEGIN ' || l_wrapper_name ||
233: '.delete_access_records(:2); END;';

Line 415: l_start_string := asg_base.get_user_name() ||

411: l_appid NUMBER;
412: l_message VARCHAR2(4000);
413: l_start_string VARCHAR2(64);
414: BEGIN
415: l_start_string := asg_base.get_user_name() ||
416: ',' || asg_base.get_current_tranid() || ': ';
417: IF asg_base.get_user_name() IS NULL THEN
418: l_message := message;
419: ELSE

Line 416: ',' || asg_base.get_current_tranid() || ': ';

412: l_message VARCHAR2(4000);
413: l_start_string VARCHAR2(64);
414: BEGIN
415: l_start_string := asg_base.get_user_name() ||
416: ',' || asg_base.get_current_tranid() || ': ';
417: IF asg_base.get_user_name() IS NULL THEN
418: l_message := message;
419: ELSE
420: l_message := l_start_string || message;

Line 417: IF asg_base.get_user_name() IS NULL THEN

413: l_start_string VARCHAR2(64);
414: BEGIN
415: l_start_string := asg_base.get_user_name() ||
416: ',' || asg_base.get_current_tranid() || ': ';
417: IF asg_base.get_user_name() IS NULL THEN
418: l_message := message;
419: ELSE
420: l_message := l_start_string || message;
421: END IF;

Line 640: asg_base.G_OLITE_SCHEMA || '.c$pub_list_q cpq ' ||

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
644: INTO l_disabled_pubs

Line 665: asg_base.G_OLITE_SCHEMA || '.c$pub_list_q cpq ' ||

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
669: INTO l_disabled_pubs

Line 854: 'FROM ' || asg_base.G_OLITE_SCHEMA || '.groups grp ' ||

850: l_grp_name := upper(p_group_name);
851:
852: -- Get the group id first
853: l_query_string := 'SELECT id ' ||
854: 'FROM ' || asg_base.G_OLITE_SCHEMA || '.groups grp ' ||
855: 'WHERE grp.name = :group_name';
856:
857: EXECUTE IMMEDIATE l_query_string
858: INTO l_grp_id

Line 869: asg_base.G_OLITE_SCHEMA || '.usr_grp ' ||

865: -- Insert into usr_grp all users who do not have access to
866: -- this group
867: l_query_string :=
868: 'INSERT INTO ' ||
869: asg_base.G_OLITE_SCHEMA || '.usr_grp ' ||
870: '(entity_id, entity_type, grp_id) ' ||
871: 'SELECT usr.id, 0, :group_id ' ||
872: 'FROM ' || asg_base.G_OLITE_SCHEMA || '.users usr ' ||
873: 'WHERE usr.id not in ' ||

Line 872: 'FROM ' || asg_base.G_OLITE_SCHEMA || '.users usr ' ||

868: 'INSERT INTO ' ||
869: asg_base.G_OLITE_SCHEMA || '.usr_grp ' ||
870: '(entity_id, entity_type, grp_id) ' ||
871: 'SELECT usr.id, 0, :group_id ' ||
872: 'FROM ' || asg_base.G_OLITE_SCHEMA || '.users usr ' ||
873: 'WHERE usr.id not in ' ||
874: ' (SELECT usr2.id ' ||
875: ' FROM ' || asg_base.G_OLITE_SCHEMA || '.users usr2,' ||
876: asg_base.G_OLITE_SCHEMA || '.usr_grp ugrp ' ||

Line 875: ' FROM ' || asg_base.G_OLITE_SCHEMA || '.users usr2,' ||

871: 'SELECT usr.id, 0, :group_id ' ||
872: 'FROM ' || asg_base.G_OLITE_SCHEMA || '.users usr ' ||
873: 'WHERE usr.id not in ' ||
874: ' (SELECT usr2.id ' ||
875: ' FROM ' || asg_base.G_OLITE_SCHEMA || '.users usr2,' ||
876: asg_base.G_OLITE_SCHEMA || '.usr_grp ugrp ' ||
877: ' WHERE ugrp.grp_id = :group_id AND ' ||
878: ' usr2.id = ugrp.entity_id) AND ' ||
879: ' usr.name in ' ||

Line 876: asg_base.G_OLITE_SCHEMA || '.usr_grp ugrp ' ||

872: 'FROM ' || asg_base.G_OLITE_SCHEMA || '.users usr ' ||
873: 'WHERE usr.id not in ' ||
874: ' (SELECT usr2.id ' ||
875: ' FROM ' || asg_base.G_OLITE_SCHEMA || '.users usr2,' ||
876: asg_base.G_OLITE_SCHEMA || '.usr_grp ugrp ' ||
877: ' WHERE ugrp.grp_id = :group_id AND ' ||
878: ' usr2.id = ugrp.entity_id) AND ' ||
879: ' usr.name in ' ||
880: ' (SELECT user_name ' ||

Line 1052: asg_base.G_OLITE_SCHEMA || '.wtg_sites ws, ' ||

1048: -- ok, multiple devices assigned to this user
1049: IF l_found_device_type = FALSE THEN
1050: l_sql_string := 'SELECT count(ws.os_name) ' ||
1051: 'FROM ' ||
1052: asg_base.G_OLITE_SCHEMA || '.wtg_sites ws, ' ||
1053: asg_base.G_OLITE_SCHEMA || '.users usr, ' ||
1054: asg_base.G_OLITE_SCHEMA || '.c$all_clients cac ' ||
1055: 'where cac.synctime_start is not null ' ||
1056: 'and cac.clientid = usr.name and usr.id = ws.usr_id ' ||

Line 1053: asg_base.G_OLITE_SCHEMA || '.users usr, ' ||

1049: IF l_found_device_type = FALSE THEN
1050: l_sql_string := 'SELECT count(ws.os_name) ' ||
1051: 'FROM ' ||
1052: asg_base.G_OLITE_SCHEMA || '.wtg_sites ws, ' ||
1053: asg_base.G_OLITE_SCHEMA || '.users usr, ' ||
1054: asg_base.G_OLITE_SCHEMA || '.c$all_clients cac ' ||
1055: 'where cac.synctime_start is not null ' ||
1056: 'and cac.clientid = usr.name and usr.id = ws.usr_id ' ||
1057: 'and abs(cac.synctime_start-ws.last_sync) <= 1/24 ' ||

Line 1054: asg_base.G_OLITE_SCHEMA || '.c$all_clients cac ' ||

1050: l_sql_string := 'SELECT count(ws.os_name) ' ||
1051: 'FROM ' ||
1052: asg_base.G_OLITE_SCHEMA || '.wtg_sites ws, ' ||
1053: asg_base.G_OLITE_SCHEMA || '.users usr, ' ||
1054: asg_base.G_OLITE_SCHEMA || '.c$all_clients cac ' ||
1055: 'where cac.synctime_start is not null ' ||
1056: 'and cac.clientid = usr.name and usr.id = ws.usr_id ' ||
1057: 'and abs(cac.synctime_start-ws.last_sync) <= 1/24 ' ||
1058: 'and ws.os_name is not null ' ||

Line 1076: asg_base.G_OLITE_SCHEMA || '.c$all_clients ' ||

1072: -- No device type found from last synch.
1073: -- Find out if the user ever synched
1074: l_sql_string := 'SELECT COUNT(*) ' ||
1075: 'FROM ' ||
1076: asg_base.G_OLITE_SCHEMA || '.c$all_clients ' ||
1077: 'WHERE synctime_start is not null and ' ||
1078: 'clientid = :1';
1079: EXECUTE IMMEDIATE l_sql_string
1080: INTO l_user_synched

Line 1421: l_olite_schema := asg_base.G_OLITE_SCHEMA;

1417: WHERE enabled = 'Y';
1418: l_olite_schema VARCHAR2(30);
1419: l_sql_string VARCHAR2(4096);
1420: BEGIN
1421: l_olite_schema := asg_base.G_OLITE_SCHEMA;
1422:
1423: l_sql_string := 'GRANT SELECT ON ASG_SYSTEM_DIRTY_QUEUE TO '||
1424: l_olite_schema;
1425: grant_db_privilege(l_sql_string);