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 160: l_user_id := asg_base.get_user_id(p_user_name);

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

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

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

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

430: l_appid NUMBER;
431: l_message VARCHAR2(4000);
432: l_start_string VARCHAR2(64);
433: BEGIN
434: l_start_string := asg_base.get_user_name() ||
435: ',' || asg_base.get_current_tranid() || ': ';
436: IF asg_base.get_user_name() IS NULL THEN
437: l_message := message;
438: ELSE

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

431: l_message VARCHAR2(4000);
432: l_start_string VARCHAR2(64);
433: BEGIN
434: l_start_string := asg_base.get_user_name() ||
435: ',' || asg_base.get_current_tranid() || ': ';
436: IF asg_base.get_user_name() IS NULL THEN
437: l_message := message;
438: ELSE
439: l_message := l_start_string || message;

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

432: l_start_string VARCHAR2(64);
433: BEGIN
434: l_start_string := asg_base.get_user_name() ||
435: ',' || asg_base.get_current_tranid() || ': ';
436: IF asg_base.get_user_name() IS NULL THEN
437: l_message := message;
438: ELSE
439: l_message := l_start_string || message;
440: END IF;

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

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

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

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

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

869: l_grp_name := upper(p_group_name);
870:
871: -- Get the group id first
872: l_query_string := 'SELECT id ' ||
873: 'FROM ' || asg_base.G_OLITE_SCHEMA || '.groups grp ' ||
874: 'WHERE grp.name = :group_name';
875:
876: EXECUTE IMMEDIATE l_query_string
877: INTO l_grp_id

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

884: -- Insert into usr_grp all users who do not have access to
885: -- this group
886: l_query_string :=
887: 'INSERT INTO ' ||
888: asg_base.G_OLITE_SCHEMA || '.usr_grp ' ||
889: '(entity_id, entity_type, grp_id) ' ||
890: 'SELECT usr.id, 0, :group_id ' ||
891: 'FROM ' || asg_base.G_OLITE_SCHEMA || '.users usr ' ||
892: 'WHERE usr.id not in ' ||

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

887: 'INSERT INTO ' ||
888: asg_base.G_OLITE_SCHEMA || '.usr_grp ' ||
889: '(entity_id, entity_type, grp_id) ' ||
890: 'SELECT usr.id, 0, :group_id ' ||
891: 'FROM ' || asg_base.G_OLITE_SCHEMA || '.users usr ' ||
892: 'WHERE usr.id not in ' ||
893: ' (SELECT usr2.id ' ||
894: ' FROM ' || asg_base.G_OLITE_SCHEMA || '.users usr2,' ||
895: asg_base.G_OLITE_SCHEMA || '.usr_grp ugrp ' ||

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

890: 'SELECT usr.id, 0, :group_id ' ||
891: 'FROM ' || asg_base.G_OLITE_SCHEMA || '.users usr ' ||
892: 'WHERE usr.id not in ' ||
893: ' (SELECT usr2.id ' ||
894: ' FROM ' || asg_base.G_OLITE_SCHEMA || '.users usr2,' ||
895: asg_base.G_OLITE_SCHEMA || '.usr_grp ugrp ' ||
896: ' WHERE ugrp.grp_id = :group_id AND ' ||
897: ' usr2.id = ugrp.entity_id) AND ' ||
898: ' usr.name in ' ||

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

891: 'FROM ' || asg_base.G_OLITE_SCHEMA || '.users usr ' ||
892: 'WHERE usr.id not in ' ||
893: ' (SELECT usr2.id ' ||
894: ' FROM ' || asg_base.G_OLITE_SCHEMA || '.users usr2,' ||
895: asg_base.G_OLITE_SCHEMA || '.usr_grp ugrp ' ||
896: ' WHERE ugrp.grp_id = :group_id AND ' ||
897: ' usr2.id = ugrp.entity_id) AND ' ||
898: ' usr.name in ' ||
899: ' (SELECT user_name ' ||

Line 996: from '||asg_base.G_OLITE_SCHEMA||'.c$sync_history where client_id=:1 order by start_time desc) where rownum<2';

992: BEGIN
993:
994: l_sql:='select session_id,start_time,DEVICE_TYPE
995: from (select session_id,start_time,DECODE(DEVICE_PLATFORM,''WCE'',''WINCE'',''LAPTOP'') as DEVICE_TYPE
996: from '||asg_base.G_OLITE_SCHEMA||'.c$sync_history where client_id=:1 order by start_time desc) where rownum<2';
997:
998: EXECUTE IMMEDIATE l_sql INTO l_session_id,l_sync_date,l_device_type using p_user_name;
999:
1000: wf_event_t.initialize(l_wf_param);

Line 1002: l_wf_param.AddParameterToList('TRAN_ID',asg_base.get_current_tranid);

998: EXECUTE IMMEDIATE l_sql INTO l_session_id,l_sync_date,l_device_type using p_user_name;
999:
1000: wf_event_t.initialize(l_wf_param);
1001: l_wf_param.AddParameterToList('SESSION_ID',to_char(l_session_id));
1002: l_wf_param.AddParameterToList('TRAN_ID',asg_base.get_current_tranid);
1003: l_wf_param.AddParameterToList('CLIENT_ID',p_user_name);
1004: l_wf_param.AddParameterToList('ERROR_MSG',p_message);
1005: l_wf_param.AddParameterToList('DEVICE_TYPE',l_device_type);
1006: l_wf_param.AddParameterToList('SYNC_DATE',to_char(l_sync_date,'DD-MM-RRRR HH24:MI:SS'));

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

1111: -- ok, multiple devices assigned to this user
1112: IF l_found_device_type = FALSE THEN
1113: l_sql_string := 'SELECT count(ws.os_name) ' ||
1114: 'FROM ' ||
1115: asg_base.G_OLITE_SCHEMA || '.wtg_sites ws, ' ||
1116: asg_base.G_OLITE_SCHEMA || '.users usr, ' ||
1117: asg_base.G_OLITE_SCHEMA || '.c$all_clients cac ' ||
1118: 'where cac.synctime_start is not null ' ||
1119: 'and cac.clientid = usr.name and usr.id = ws.usr_id ' ||

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

1112: IF l_found_device_type = FALSE THEN
1113: l_sql_string := 'SELECT count(ws.os_name) ' ||
1114: 'FROM ' ||
1115: asg_base.G_OLITE_SCHEMA || '.wtg_sites ws, ' ||
1116: asg_base.G_OLITE_SCHEMA || '.users usr, ' ||
1117: asg_base.G_OLITE_SCHEMA || '.c$all_clients cac ' ||
1118: 'where cac.synctime_start is not null ' ||
1119: 'and cac.clientid = usr.name and usr.id = ws.usr_id ' ||
1120: 'and abs(cac.synctime_start-ws.last_sync) <= 1/24 ' ||

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

1113: l_sql_string := 'SELECT count(ws.os_name) ' ||
1114: 'FROM ' ||
1115: asg_base.G_OLITE_SCHEMA || '.wtg_sites ws, ' ||
1116: asg_base.G_OLITE_SCHEMA || '.users usr, ' ||
1117: asg_base.G_OLITE_SCHEMA || '.c$all_clients cac ' ||
1118: 'where cac.synctime_start is not null ' ||
1119: 'and cac.clientid = usr.name and usr.id = ws.usr_id ' ||
1120: 'and abs(cac.synctime_start-ws.last_sync) <= 1/24 ' ||
1121: 'and ws.os_name is not null ' ||

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

1135: -- No device type found from last synch.
1136: -- Find out if the user ever synched
1137: l_sql_string := 'SELECT COUNT(*) ' ||
1138: 'FROM ' ||
1139: asg_base.G_OLITE_SCHEMA || '.c$all_clients ' ||
1140: 'WHERE synctime_start is not null and ' ||
1141: 'clientid = :1';
1142: EXECUTE IMMEDIATE l_sql_string
1143: INTO l_user_synched

Line 1484: l_olite_schema := asg_base.G_OLITE_SCHEMA;

1480: WHERE enabled = 'Y';
1481: l_olite_schema VARCHAR2(30);
1482: l_sql_string VARCHAR2(4096);
1483: BEGIN
1484: l_olite_schema := asg_base.G_OLITE_SCHEMA;
1485:
1486: l_sql_string := 'GRANT SELECT ON ASG_SYSTEM_DIRTY_QUEUE TO '||
1487: l_olite_schema;
1488: grant_db_privilege(l_sql_string);