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 22: -- asg_user_pub_resps.synch_date

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

Line 30: -- synch_errors column in asg_user

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

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

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

Line 318: DELETE FROM asg_user_pub_resps

314: p_resp_id IN NUMBER,
315: p_app_id IN NUMBER)
316: IS
317: BEGIN
318: DELETE FROM asg_user_pub_resps
319: WHERE user_name = p_user_name AND
320: pub_name = p_pub_name AND
321: responsibility_id = p_resp_id AND
322: app_id = p_app_id;

Line 324: INSERT INTO asg_user_pub_resps (

320: pub_name = p_pub_name AND
321: responsibility_id = p_resp_id AND
322: app_id = p_app_id;
323:
324: INSERT INTO asg_user_pub_resps (
325: USER_NAME,
326: PUB_NAME,
327: SYNCH_DISABLED,
328: RESPONSIBILITY_ID,

Line 360: DELETE FROM asg_user_pub_resps

356: p_pub_name IN VARCHAR2)
357: IS
358: BEGIN
359:
360: DELETE FROM asg_user_pub_resps
361: WHERE user_name = p_user_name AND
362: pub_name = p_pub_name;
363:
364: DELETE FROM asg_purge_sdq

Line 390: DELETE FROM asg_user_pub_resps

386: p_resp_id IN NUMBER)
387: IS
388: BEGIN
389:
390: DELETE FROM asg_user_pub_resps
391: WHERE user_name = p_user_name AND
392: pub_name = p_pub_name AND
393: responsibility_id = p_resp_id;
394:

Line 456: FROM asg_user_pub_resps

452: l_user_name VARCHAR2(30);
453: l_bool_ret BOOLEAN;
454: CURSOR c_user_pubs(p_user_name VARCHAR2) IS
455: SELECT pub_name
456: FROM asg_user_pub_resps
457: WHERE user_name = p_user_name;
458: BEGIN
459: l_user_name := upper(p_user_name);
460:

Line 467: DELETE FROM asg_user_pub_resps

463: FOR cups in c_user_pubs(l_user_name) LOOP
464: delete_access(l_user_name, cups.pub_name);
465: END LOOP;
466:
467: DELETE FROM asg_user_pub_resps
468: WHERE user_name = p_user_name;
469:
470: DELETE FROM ASG_USERS_INQARCHIVE
471: WHERE device_user_name = l_user_name;

Line 470: DELETE FROM ASG_USERS_INQARCHIVE

466:
467: DELETE FROM asg_user_pub_resps
468: WHERE user_name = p_user_name;
469:
470: DELETE FROM ASG_USERS_INQARCHIVE
471: WHERE device_user_name = l_user_name;
472:
473: -- Before drop is called we check to see if there are any
474: -- unprocessed inq transactions. So, at this point all of them

Line 479: DELETE FROM ASG_USERS_INQINFO

475: -- should have been processed.
476: DELETE FROM ASG_DEFERRED_TRANINFO
477: WHERE device_user_name = l_user_name;
478:
479: DELETE FROM ASG_USERS_INQINFO
480: WHERE device_user_name = l_user_name;
481:
482: --12.1
483: DELETE FROM asg_auto_sync_tranids

Line 508: DELETE FROM ASG_USER

504:
505: DELETE FROM asg_sequence_partitions
506: WHERE clientid = p_user_name;
507:
508: DELETE FROM ASG_USER
509: WHERE user_name = l_user_name;
510:
511: COMMIT;
512: IF(check_is_log_enabled(g_stmt_level))

Line 620: FROM asg_user

616: BEGIN
617:
618: -- First, check if the user was created properly
619: SELECT count(*) into l_disabled_user
620: FROM asg_user
621: WHERE user_name = p_user_name AND
622: enabled = 'N';
623:
624: IF l_disabled_user > 0 THEN

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

781: p_pub_name IN VARCHAR2)
782: IS
783: CURSOR C_USER_NAME(p_user_id NUMBER) IS
784: SELECT user_name
785: FROM asg_user
786: WHERE user_id = p_user_id;
787: l_user_name VARCHAR2(30);
788: PRAGMA AUTONOMOUS_TRANSACTION;
789: BEGIN

Line 799: UPDATE asg_user_pub_resps

795: OPEN C_USER_NAME(p_user_id);
796: FETCH C_USER_NAME into l_user_name;
797: CLOSE C_USER_NAME;
798:
799: UPDATE asg_user_pub_resps
800: SET SYNCH_DISABLED = 'Y'
801: WHERE user_name = l_user_name AND
802: pub_name = p_pub_name;
803: COMMIT;

Line 815: FROM asg_user

811: p_pub_name IN VARCHAR2)
812: IS
813: CURSOR C_USER_NAME(p_user_id NUMBER) IS
814: SELECT user_name
815: FROM asg_user
816: WHERE user_id = p_user_id;
817: l_user_name VARCHAR2(30);
818: PRAGMA AUTONOMOUS_TRANSACTION;
819: BEGIN

Line 829: UPDATE asg_user_pub_resps

825: OPEN C_USER_NAME(p_user_id);
826: FETCH C_USER_NAME into l_user_name;
827: CLOSE C_USER_NAME;
828:
829: UPDATE asg_user_pub_resps
830: SET SYNCH_DISABLED = 'N'
831: WHERE user_name = l_user_name AND
832: pub_name = p_pub_name;
833: COMMIT;

Line 881: ' FROM asg_user)';

877: ' WHERE ugrp.grp_id = :group_id AND ' ||
878: ' usr2.id = ugrp.entity_id) AND ' ||
879: ' usr.name in ' ||
880: ' (SELECT user_name ' ||
881: ' FROM asg_user)';
882:
883: EXECUTE IMMEDIATE l_query_string
884: USING l_grp_id,l_grp_id;
885:

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

884: USING l_grp_id,l_grp_id;
885:
886: END set_group_access;
887:
888: --API for updating hwm_tranid column in asg_user table
889: PROCEDURE update_hwm_tranid(p_user_name IN VARCHAR2,p_tranid IN NUMBER)
890: IS
891: BEGIN
892: UPDATE asg_user

Line 892: UPDATE asg_user

888: --API for updating hwm_tranid column in asg_user table
889: PROCEDURE update_hwm_tranid(p_user_name IN VARCHAR2,p_tranid IN NUMBER)
890: IS
891: BEGIN
892: UPDATE asg_user
893: SET hwm_tranid=p_tranid
894: WHERE user_name=UPPER(p_user_name);
895: END update_hwm_tranid;
896:

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

893: SET hwm_tranid=p_tranid
894: WHERE user_name=UPPER(p_user_name);
895: END update_hwm_tranid;
896:
897: --API for autonomous update of USER_SETUP_ERRORS column in asg_user table
898: PROCEDURE update_user_setup_errors(p_user_name IN VARCHAR2,p_mesg IN VARCHAR2)
899: IS
900: PRAGMA AUTONOMOUS_TRANSACTION;
901: BEGIN

Line 902: UPDATE asg_user

898: PROCEDURE update_user_setup_errors(p_user_name IN VARCHAR2,p_mesg IN VARCHAR2)
899: IS
900: PRAGMA AUTONOMOUS_TRANSACTION;
901: BEGIN
902: UPDATE asg_user
903: SET user_setup_errors = p_mesg
904: WHERE user_name = p_user_name;
905: COMMIT;
906: EXCEPTION

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

907: WHEN OTHERS THEN
908: ROLLBACK;
909: END update_user_setup_errors;
910:
911: --API for synching info between asg_user_pub_resps and asg_user tables
912: --after adding/dropping subscription
913: PROCEDURE update_user_resps(p_user_name IN VARCHAR2)
914: IS
915: l_resp_id NUMBER;

Line 921: FROM asg_user_pub_resps

917: BEGIN
918:
919: BEGIN
920: SELECT responsibility_id, app_id INTO l_resp_id, l_app_id
921: FROM asg_user_pub_resps
922: WHERE user_name = p_user_name AND
923: pub_name = 'SERVICEP';
924: EXCEPTION
925: WHEN OTHERS THEN

Line 933: FROM asg_user_pub_resps

929: /* Check SERVICEL if no item exists for SERVICEP */
930: IF (l_resp_id IS NULL) or (l_app_id IS NULL) THEN
931: BEGIN
932: SELECT responsibility_id, app_id INTO l_resp_id, l_app_id
933: FROM asg_user_pub_resps
934: WHERE user_name = p_user_name AND
935: pub_name = 'SERVICEL';
936: EXCEPTION
937: WHEN OTHERS THEN

Line 943: UPDATE asg_user

939: END;
940: END IF;
941:
942: IF (l_resp_id IS NOT NULL) AND (l_app_id IS NOT NULL) THEN
943: UPDATE asg_user
944: SET responsibility_id = l_resp_id, app_id = l_app_id
945: WHERE user_name = p_user_name AND
946: responsibility_id <> l_resp_id AND
947: app_id <> l_app_id;

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

948: COMMIT;
949: END IF;
950: END update_user_resps;
951:
952: --API for updating SYNCH_ERRORS column in asg_user table
953: --not used currently
954: PROCEDURE update_synch_errors(p_user_name IN VARCHAR2,p_mesg IN VARCHAR2)
955: IS
956: BEGIN

Line 957: UPDATE asg_user

953: --not used currently
954: PROCEDURE update_synch_errors(p_user_name IN VARCHAR2,p_mesg IN VARCHAR2)
955: IS
956: BEGIN
957: UPDATE asg_user
958: SET synch_errors = p_mesg,
959: last_wireless_contact_date = sysdate
960: WHERE user_name = p_user_name;
961: END update_synch_errors;

Line 977: UPDATE asg_user

973: SELECT NAME FROM asg_pub WHERE device_type=l_device_type;
974:
975: PRAGMA AUTONOMOUS_TRANSACTION;
976: BEGIN
977: UPDATE asg_user
978: SET synch_errors = p_mesg,
979: cookie = nvl(p_device_type,cookie),
980: hwm_tranid = nvl(p_tranid,hwm_tranid),
981: last_wireless_contact_date = sysdate

Line 983: -- update asg_user_pub_resp.synch_date

979: cookie = nvl(p_device_type,cookie),
980: hwm_tranid = nvl(p_tranid,hwm_tranid),
981: last_wireless_contact_date = sysdate
982: WHERE user_name = p_user_name;
983: -- update asg_user_pub_resp.synch_date
984: OPEN get_pub(p_device_type);
985: LOOP
986: FETCH get_pub INTO l_pub_name;
987: EXIT WHEN get_pub%NOTFOUND;

Line 989: UPDATE asg_user_pub_resps

985: LOOP
986: FETCH get_pub INTO l_pub_name;
987: EXIT WHEN get_pub%NOTFOUND;
988: log('Setting synch time for pub_name: '||l_pub_name,'asg_helper',g_stmt_level);
989: UPDATE asg_user_pub_resps
990: SET synch_date = sysdate
991: WHERE user_name = p_user_name
992: AND pub_name = l_pub_name;
993: END LOOP;

Line 1006: FROM asg_user

1002: PROCEDURE set_last_synch_device_type
1003: IS
1004: CURSOR c_users IS
1005: SELECT user_name
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

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

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;
1029: l_counter := 0;
1030: l_found_device_type := FALSE;

Line 1042: UPDATE asg_user

1038:
1039: -- If only one device type is found for this user
1040: -- Update the device type to the one we found
1041: IF (l_counter = 1) THEN
1042: UPDATE asg_user
1043: SET cookie = l_device_type
1044: WHERE user_name = l_current_user;
1045: l_found_device_type := TRUE;
1046: END IF;

Line 1068: UPDATE asg_user

1064:
1065: -- Users who synched from web-to-go (laptop) are remembered in wtg_sites
1066: -- So, if a record exists in this table, it means user synched from wtg
1067: IF l_device_type_stored > 0 THEN
1068: UPDATE asg_user
1069: SET cookie = 'LAPTOP'
1070: WHERE user_name = l_current_user;
1071: ELSE
1072: -- No device type found from last synch.

Line 1083: UPDATE asg_user

1079: EXECUTE IMMEDIATE l_sql_string
1080: INTO l_user_synched
1081: USING l_current_user;
1082: IF l_user_synched = 1 THEN
1083: UPDATE asg_user
1084: SET cookie = 'PALM'
1085: WHERE user_name = l_current_user;
1086: END IF;
1087: END IF;