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_USER

Line 23: -- asg_user_pub_resps.synch_date

19: -- user creation.
20: -- 30-dec-2003 rsripada Added procedures for creating/dropping olite
21: -- synonyms
22: -- 11-nov-2003 ssabesan modified set_synch_errmsg to write into
23: -- asg_user_pub_resps.synch_date
24: -- 22-oct-2003 ssabesan Merge 115.23.1158.15 into mainline
25: -- 01-oct-2003 ssabesan Purge SDQ changes (bug 3170790)
26: -- 12-jun-2003 rsripada Added proc to determine last synch device type
27: -- 10-apr-2003 ssabesan for logging user_setup and synch errors use

Line 31: -- synch_errors column in asg_user

27: -- 10-apr-2003 ssabesan for logging user_setup and synch errors use
28: -- last_wireless_contact_date column.
29: -- 26-mar-2003 rsripada Removed default values in log procedure
30: -- 25-mar-2003 ssabesan Added API for updating user_sertup_errors and
31: -- synch_errors column in asg_user
32: -- 12-feb-2003 ssabesan Added API for updating hwm_tranid in asg_user
33: -- 10-jan-2003 ssabesan Added a wrapper around check_is_log_enabled()
34: -- for use from java program.
35: -- 06-jan-2003 ssabesan PL/SQL API changes. Added method for checking

Line 32: -- 12-feb-2003 ssabesan Added API for updating hwm_tranid in asg_user

28: -- last_wireless_contact_date column.
29: -- 26-mar-2003 rsripada Removed default values in log procedure
30: -- 25-mar-2003 ssabesan Added API for updating user_sertup_errors and
31: -- synch_errors column in asg_user
32: -- 12-feb-2003 ssabesan Added API for updating hwm_tranid in asg_user
33: -- 10-jan-2003 ssabesan Added a wrapper around check_is_log_enabled()
34: -- for use from java program.
35: -- 06-jan-2003 ssabesan PL/SQL API changes. Added method for checking
36: -- whether logging is enabled.

Line 262: FROM asg_user

258: p_next_value IN VARCHAR2)
259: IS
260: CURSOR C_MULTI_PLATFORM(p_user_name varchar2) IS
261: SELECT multi_platform
262: FROM asg_user
263: WHERE user_name = p_user_name;
264: l_multi_platform VARCHAR2(1);
265: l_access_id NUMBER;
266:

Line 337: DELETE FROM asg_user_pub_resps

333: p_resp_id IN NUMBER,
334: p_app_id IN NUMBER)
335: IS
336: BEGIN
337: DELETE FROM asg_user_pub_resps
338: WHERE user_name = p_user_name AND
339: pub_name = p_pub_name AND
340: responsibility_id = p_resp_id AND
341: app_id = p_app_id;

Line 343: INSERT INTO asg_user_pub_resps (

339: pub_name = p_pub_name AND
340: responsibility_id = p_resp_id AND
341: app_id = p_app_id;
342:
343: INSERT INTO asg_user_pub_resps (
344: USER_NAME,
345: PUB_NAME,
346: SYNCH_DISABLED,
347: RESPONSIBILITY_ID,

Line 379: DELETE FROM asg_user_pub_resps

375: p_pub_name IN VARCHAR2)
376: IS
377: BEGIN
378:
379: DELETE FROM asg_user_pub_resps
380: WHERE user_name = p_user_name AND
381: pub_name = p_pub_name;
382:
383: DELETE FROM asg_purge_sdq

Line 409: DELETE FROM asg_user_pub_resps

405: p_resp_id IN NUMBER)
406: IS
407: BEGIN
408:
409: DELETE FROM asg_user_pub_resps
410: WHERE user_name = p_user_name AND
411: pub_name = p_pub_name AND
412: responsibility_id = p_resp_id;
413:

Line 475: FROM asg_user_pub_resps

471: l_user_name VARCHAR2(100);
472: l_bool_ret BOOLEAN;
473: CURSOR c_user_pubs(p_user_name VARCHAR2) IS
474: SELECT pub_name
475: FROM asg_user_pub_resps
476: WHERE user_name = p_user_name;
477: BEGIN
478: l_user_name := upper(p_user_name);
479:

Line 486: DELETE FROM asg_user_pub_resps

482: FOR cups in c_user_pubs(l_user_name) LOOP
483: delete_access(l_user_name, cups.pub_name);
484: END LOOP;
485:
486: DELETE FROM asg_user_pub_resps
487: WHERE user_name = p_user_name;
488:
489: DELETE FROM ASG_USERS_INQARCHIVE
490: WHERE device_user_name = l_user_name;

Line 489: DELETE FROM ASG_USERS_INQARCHIVE

485:
486: DELETE FROM asg_user_pub_resps
487: WHERE user_name = p_user_name;
488:
489: DELETE FROM ASG_USERS_INQARCHIVE
490: WHERE device_user_name = l_user_name;
491:
492: -- Before drop is called we check to see if there are any
493: -- unprocessed inq transactions. So, at this point all of them

Line 498: DELETE FROM ASG_USERS_INQINFO

494: -- should have been processed.
495: DELETE FROM ASG_DEFERRED_TRANINFO
496: WHERE device_user_name = l_user_name;
497:
498: DELETE FROM ASG_USERS_INQINFO
499: WHERE device_user_name = l_user_name;
500:
501: --12.1
502: DELETE FROM asg_auto_sync_tranids

Line 527: DELETE FROM ASG_USER

523:
524: DELETE FROM asg_sequence_partitions
525: WHERE clientid = p_user_name;
526:
527: DELETE FROM ASG_USER
528: WHERE user_name = l_user_name;
529:
530: COMMIT;
531: IF(check_is_log_enabled(g_stmt_level))

Line 639: FROM asg_user

635: BEGIN
636:
637: -- First, check if the user was created properly
638: SELECT count(*) into l_disabled_user
639: FROM asg_user
640: WHERE user_name = p_user_name AND
641: enabled = 'N';
642:
643: IF l_disabled_user > 0 THEN

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 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 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 804: FROM asg_user

800: p_pub_name IN VARCHAR2)
801: IS
802: CURSOR C_USER_NAME(p_user_id NUMBER) IS
803: SELECT user_name
804: FROM asg_user
805: WHERE user_id = p_user_id;
806: l_user_name VARCHAR2(100);
807: PRAGMA AUTONOMOUS_TRANSACTION;
808: BEGIN

Line 818: UPDATE asg_user_pub_resps

814: OPEN C_USER_NAME(p_user_id);
815: FETCH C_USER_NAME into l_user_name;
816: CLOSE C_USER_NAME;
817:
818: UPDATE asg_user_pub_resps
819: SET SYNCH_DISABLED = 'Y'
820: WHERE user_name = l_user_name AND
821: pub_name = p_pub_name;
822: COMMIT;

Line 834: FROM asg_user

830: p_pub_name IN VARCHAR2)
831: IS
832: CURSOR C_USER_NAME(p_user_id NUMBER) IS
833: SELECT user_name
834: FROM asg_user
835: WHERE user_id = p_user_id;
836: l_user_name VARCHAR2(100);
837: PRAGMA AUTONOMOUS_TRANSACTION;
838: BEGIN

Line 848: UPDATE asg_user_pub_resps

844: OPEN C_USER_NAME(p_user_id);
845: FETCH C_USER_NAME into l_user_name;
846: CLOSE C_USER_NAME;
847:
848: UPDATE asg_user_pub_resps
849: SET SYNCH_DISABLED = 'N'
850: WHERE user_name = l_user_name AND
851: pub_name = p_pub_name;
852: COMMIT;

Line 900: ' FROM asg_user)';

896: ' WHERE ugrp.grp_id = :group_id AND ' ||
897: ' usr2.id = ugrp.entity_id) AND ' ||
898: ' usr.name in ' ||
899: ' (SELECT user_name ' ||
900: ' FROM asg_user)';
901:
902: EXECUTE IMMEDIATE l_query_string
903: USING l_grp_id,l_grp_id;
904:

Line 907: --API for updating hwm_tranid column in asg_user table

903: USING l_grp_id,l_grp_id;
904:
905: END set_group_access;
906:
907: --API for updating hwm_tranid column in asg_user table
908: PROCEDURE update_hwm_tranid(p_user_name IN VARCHAR2,p_tranid IN NUMBER)
909: IS
910: BEGIN
911: UPDATE asg_user

Line 911: UPDATE asg_user

907: --API for updating hwm_tranid column in asg_user table
908: PROCEDURE update_hwm_tranid(p_user_name IN VARCHAR2,p_tranid IN NUMBER)
909: IS
910: BEGIN
911: UPDATE asg_user
912: SET hwm_tranid=p_tranid
913: WHERE user_name=UPPER(p_user_name);
914: END update_hwm_tranid;
915:

Line 916: --API for autonomous update of USER_SETUP_ERRORS column in asg_user table

912: SET hwm_tranid=p_tranid
913: WHERE user_name=UPPER(p_user_name);
914: END update_hwm_tranid;
915:
916: --API for autonomous update of USER_SETUP_ERRORS column in asg_user table
917: PROCEDURE update_user_setup_errors(p_user_name IN VARCHAR2,p_mesg IN VARCHAR2)
918: IS
919: PRAGMA AUTONOMOUS_TRANSACTION;
920: BEGIN

Line 921: UPDATE asg_user

917: PROCEDURE update_user_setup_errors(p_user_name IN VARCHAR2,p_mesg IN VARCHAR2)
918: IS
919: PRAGMA AUTONOMOUS_TRANSACTION;
920: BEGIN
921: UPDATE asg_user
922: SET user_setup_errors = p_mesg
923: WHERE user_name = p_user_name;
924: COMMIT;
925: EXCEPTION

Line 930: --API for synching info between asg_user_pub_resps and asg_user tables

926: WHEN OTHERS THEN
927: ROLLBACK;
928: END update_user_setup_errors;
929:
930: --API for synching info between asg_user_pub_resps and asg_user tables
931: --after adding/dropping subscription
932: PROCEDURE update_user_resps(p_user_name IN VARCHAR2)
933: IS
934: l_resp_id NUMBER;

Line 940: FROM asg_user_pub_resps

936: BEGIN
937:
938: BEGIN
939: SELECT responsibility_id, app_id INTO l_resp_id, l_app_id
940: FROM asg_user_pub_resps
941: WHERE user_name = p_user_name AND
942: pub_name = 'SERVICEP';
943: EXCEPTION
944: WHEN OTHERS THEN

Line 952: FROM asg_user_pub_resps

948: /* Check SERVICEL if no item exists for SERVICEP */
949: IF (l_resp_id IS NULL) or (l_app_id IS NULL) THEN
950: BEGIN
951: SELECT responsibility_id, app_id INTO l_resp_id, l_app_id
952: FROM asg_user_pub_resps
953: WHERE user_name = p_user_name AND
954: pub_name = 'SERVICEL';
955: EXCEPTION
956: WHEN OTHERS THEN

Line 962: UPDATE asg_user

958: END;
959: END IF;
960:
961: IF (l_resp_id IS NOT NULL) AND (l_app_id IS NOT NULL) THEN
962: UPDATE asg_user
963: SET responsibility_id = l_resp_id, app_id = l_app_id
964: WHERE user_name = p_user_name AND
965: responsibility_id <> l_resp_id AND
966: app_id <> l_app_id;

Line 971: --API for updating SYNCH_ERRORS column in asg_user table

967: COMMIT;
968: END IF;
969: END update_user_resps;
970:
971: --API for updating SYNCH_ERRORS column in asg_user table
972: --not used currently
973: PROCEDURE update_synch_errors(p_user_name IN VARCHAR2,p_mesg IN VARCHAR2)
974: IS
975: BEGIN

Line 976: UPDATE asg_user

972: --not used currently
973: PROCEDURE update_synch_errors(p_user_name IN VARCHAR2,p_mesg IN VARCHAR2)
974: IS
975: BEGIN
976: UPDATE asg_user
977: SET synch_errors = p_mesg,
978: last_wireless_contact_date = sysdate
979: WHERE user_name = p_user_name;
980: END update_synch_errors;

Line 1034: UPDATE asg_user

1030: SELECT NAME FROM asg_pub WHERE device_type=l_device_type;
1031:
1032: PRAGMA AUTONOMOUS_TRANSACTION;
1033: BEGIN
1034: UPDATE asg_user
1035: SET synch_errors = p_mesg,
1036: cookie = nvl(p_device_type,cookie),
1037: hwm_tranid = nvl(p_tranid,hwm_tranid),
1038: last_wireless_contact_date = sysdate

Line 1040: -- update asg_user_pub_resp.synch_date

1036: cookie = nvl(p_device_type,cookie),
1037: hwm_tranid = nvl(p_tranid,hwm_tranid),
1038: last_wireless_contact_date = sysdate
1039: WHERE user_name = p_user_name;
1040: -- update asg_user_pub_resp.synch_date
1041: OPEN get_pub(p_device_type);
1042: LOOP
1043: FETCH get_pub INTO l_pub_name;
1044: EXIT WHEN get_pub%NOTFOUND;

Line 1046: UPDATE asg_user_pub_resps

1042: LOOP
1043: FETCH get_pub INTO l_pub_name;
1044: EXIT WHEN get_pub%NOTFOUND;
1045: log('Setting synch time for pub_name: '||l_pub_name,'asg_helper',g_stmt_level);
1046: UPDATE asg_user_pub_resps
1047: SET synch_date = sysdate
1048: WHERE user_name = p_user_name
1049: AND pub_name = l_pub_name;
1050: END LOOP;

Line 1069: FROM asg_user

1065: PROCEDURE set_last_synch_device_type
1066: IS
1067: CURSOR c_users IS
1068: SELECT user_name
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

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 1089: -- If device type for last synch is not knowable, do not update asg_user

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;
1092: l_counter := 0;
1093: l_found_device_type := FALSE;

Line 1105: UPDATE asg_user

1101:
1102: -- If only one device type is found for this user
1103: -- Update the device type to the one we found
1104: IF (l_counter = 1) THEN
1105: UPDATE asg_user
1106: SET cookie = l_device_type
1107: WHERE user_name = l_current_user;
1108: l_found_device_type := TRUE;
1109: END IF;

Line 1131: UPDATE asg_user

1127:
1128: -- Users who synched from web-to-go (laptop) are remembered in wtg_sites
1129: -- So, if a record exists in this table, it means user synched from wtg
1130: IF l_device_type_stored > 0 THEN
1131: UPDATE asg_user
1132: SET cookie = 'LAPTOP'
1133: WHERE user_name = l_current_user;
1134: ELSE
1135: -- No device type found from last synch.

Line 1146: UPDATE asg_user

1142: EXECUTE IMMEDIATE l_sql_string
1143: INTO l_user_synched
1144: USING l_current_user;
1145: IF l_user_synched = 1 THEN
1146: UPDATE asg_user
1147: SET cookie = 'PALM'
1148: WHERE user_name = l_current_user;
1149: END IF;
1150: END IF;