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_BASE dependencies on ASG_USER

Line 18: -- 28-mar-2003 rsripada Get last synch date from asg_user

14: -- 17-mar-2004 rsripada Modified reset_all_globals
15: -- 27-may-2003 ssabesan Merged the branch line with main line
16: -- 09-may-2003 rsripada Added get_last_synch_date(p_user_id) API
17: -- 31-mar-2003 rsripada Modify init method to pass last_synch_date
18: -- 28-mar-2003 rsripada Get last synch date from asg_user
19: -- 11-feb-2003 rsripada Added get_upload_tranid, set_upload_tranid
20: -- 09-feb-2003 rsripada Modify find_pub_item to always return a value
21: -- 06-jan-2003 ssabesan checking whether logging is enabled before invoking
22: -- the logging procedure.

Line 120: FROM asg_user

116: FUNCTION get_user_name(p_resource_id IN NUMBER)
117: return VARCHAR2 IS
118: CURSOR C_USER_NAME(p_resource_id NUMBER) IS
119: SELECT user_name
120: FROM asg_user
121: WHERE resource_id = p_resource_id;
122: l_user_name asg_user.user_name%type;
123: BEGIN
124:

Line 122: l_user_name asg_user.user_name%type;

118: CURSOR C_USER_NAME(p_resource_id NUMBER) IS
119: SELECT user_name
120: FROM asg_user
121: WHERE resource_id = p_resource_id;
122: l_user_name asg_user.user_name%type;
123: BEGIN
124:
125: OPEN C_USER_NAME(p_resource_id);
126: FETCH C_USER_NAME into l_user_name;

Line 137: FROM asg_user

133: FUNCTION get_resource_id(p_user_name VARCHAR2)
134: return NUMBER IS
135: CURSOR C_RESOURCE(p_user_name varchar2) IS
136: SELECT resource_id
137: FROM asg_user
138: WHERE user_name = p_user_name;
139: l_resource_id number;
140: BEGIN
141:

Line 154: FROM asg_user

150: FUNCTION get_user_id(p_user_name VARCHAR2)
151: return NUMBER IS
152: CURSOR C_USER(p_user_name varchar2) IS
153: SELECT user_id
154: FROM asg_user
155: WHERE user_name = p_user_name;
156: l_user_id number;
157: BEGIN
158:

Line 171: FROM asg_user

167: FUNCTION get_resp_id(p_user_name VARCHAR2)
168: return NUMBER IS
169: CURSOR C_RESP(p_user_name varchar2) IS
170: SELECT responsibility_id
171: FROM asg_user
172: WHERE user_name = p_user_name;
173: l_resp_id number;
174: BEGIN
175:

Line 188: FROM asg_user

184: FUNCTION get_language(p_user_name VARCHAR2)
185: return VARCHAR2 IS
186: CURSOR C_LANGUAGE(p_user_name varchar2) IS
187: SELECT language
188: FROM asg_user
189: WHERE user_name = p_user_name;
190: l_language VARCHAR2(4);
191: BEGIN
192:

Line 205: FROM asg_user

201: FUNCTION get_application_id(p_user_name VARCHAR2)
202: return NUMBER IS
203: CURSOR C_APP(p_user_name varchar2) IS
204: SELECT app_id
205: FROM asg_user
206: WHERE user_name = p_user_name;
207: l_app_id number;
208: BEGIN
209: OPEN C_APP(p_user_name);

Line 223: FROM asg_user

219: l_last_synch_date DATE;
220: BEGIN
221:
222: SELECT last_synch_date_end into l_last_synch_date
223: FROM asg_user
224: WHERE user_name = p_user_name;
225:
226: return l_last_synch_date;
227:

Line 518: FROM asg_user WHERE user_id = p_user_id;

514: RETURN DATE IS
515: l_date DATE;
516: BEGIN
517: SELECT last_synch_date_end INTO l_date
518: FROM asg_user WHERE user_id = p_user_id;
519: RETURN l_date;
520: END get_last_synch_date;
521:
522: /* Allow download of attachment based on size */

Line 623: select current_device from asg_user where user_name = l_user_name;

619: l_curr_dev_type varchar2(30);
620: l_prev_dev_type varchar2(30);
621: l_qry_string varchar2(512);
622: cursor c_get_dev_type(l_user_name varchar2) is
623: select current_device from asg_user where user_name = l_user_name;
624: l_version NUMBER;
625: l_param VARCHAR2(30) := 'VERSION';
626: begin
627: IF (g_olite_version IS NULL) THEN

Line 654: -- update asg_user set current_device = l_curr_dev_type

650:
651: if (l_prev_dev_type is null) then
652: /*First time synch*/
653: -- commented for Deadlock issue
654: -- update asg_user set current_device = l_curr_dev_type
655: -- where user_name = p_user_name;
656: asg_helper.log('First Time Synch.Device type is set only now',
657: 'asg_base',g_stmt_level);
658: elsif(l_prev_dev_type <> l_curr_dev_type ) then

Line 665: -- update asg_user set current_device = l_curr_dev_type

661: ||'set comp_ref = ''Y'' '||' where name IN '
662: ||' ( select item_id from asg_pub_item)' ;
663: execute immediate l_qry_string;
664: -- commented for Deadlock issue
665: -- update asg_user set current_device = l_curr_dev_type
666: -- where user_name = p_user_name;
667: asg_helper.log('Device switch detected. Doing complete refresh',
668: 'asg_base',g_stmt_level);
669: else

Line 687: FROM asg_user

683: l_ret_value VARCHAR2(1) := G_NO;
684: l_cnt NUMBER := 0;
685: BEGIN
686: SELECT count(*) into l_cnt
687: FROM asg_user
688: WHERE user_id = p_user_id AND enabled = 'Y';
689: IF (l_cnt = 1) THEN
690: l_ret_value := G_YES;
691: END IF;

Line 701: FROM asg_user

697: RETURN mobile_user_list_type IS
698: CURSOR c_user_list
699: IS
700: SELECT user_id
701: FROM asg_user
702: WHERE enabled = 'Y';
703: l_user_list mobile_user_list_type;
704: BEGIN
705: IF (p_device_type <> G_ALL_DEVICES AND

Line 730: FROM asg_user

726: p_app_id := NULL;
727: p_resp_id := NULL;
728:
729: SELECT app_id, responsibility_id into p_app_id, p_resp_id
730: FROM asg_user
731: WHERE user_id = p_user_id and enabled = 'Y';
732:
733: END get_user_app_responsibility;
734: