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.CSM_UTIL_PKG dependencies on ASG_USER

Line 165: FROM asg_user_pub_resps pubresp

161:
162: CURSOR l_omfs_palm_users_csr
163: IS
164: SELECT usr.USER_ID
165: FROM asg_user_pub_resps pubresp
166: , asg_user usr
167: WHERE usr.enabled = 'Y'
168: AND pubresp.user_name = usr.user_name
169: AND pubresp.pub_name ='SERVICEP';

Line 166: , asg_user usr

162: CURSOR l_omfs_palm_users_csr
163: IS
164: SELECT usr.USER_ID
165: FROM asg_user_pub_resps pubresp
166: , asg_user usr
167: WHERE usr.enabled = 'Y'
168: AND pubresp.user_name = usr.user_name
169: AND pubresp.pub_name ='SERVICEP';
170: --Cursor when data routed to owner profile is set

Line 174: FROM asg_user_pub_resps pubresp

170: --Cursor when data routed to owner profile is set
171: CURSOR l_route_omfs_palm_users_csr
172: IS
173: SELECT usr.USER_ID
174: FROM asg_user_pub_resps pubresp
175: , asg_user usr
176: WHERE usr.enabled = 'Y'
177: AND pubresp.user_name = usr.user_name
178: AND pubresp.pub_name ='SERVICEP'

Line 175: , asg_user usr

171: CURSOR l_route_omfs_palm_users_csr
172: IS
173: SELECT usr.USER_ID
174: FROM asg_user_pub_resps pubresp
175: , asg_user usr
176: WHERE usr.enabled = 'Y'
177: AND pubresp.user_name = usr.user_name
178: AND pubresp.pub_name ='SERVICEP'
179: AND usr.USER_ID = usr.OWNER_ID;

Line 209: FROM asg_user_pub_resps pubresp

205:
206: CURSOR l_omfs_palm_resources_csr
207: IS
208: SELECT usr.resource_id
209: FROM asg_user_pub_resps pubresp
210: , asg_user usr
211: WHERE usr.enabled = 'Y'
212: AND pubresp.user_name = usr.user_name
213: AND pubresp.pub_name = 'SERVICEP';

Line 210: , asg_user usr

206: CURSOR l_omfs_palm_resources_csr
207: IS
208: SELECT usr.resource_id
209: FROM asg_user_pub_resps pubresp
210: , asg_user usr
211: WHERE usr.enabled = 'Y'
212: AND pubresp.user_name = usr.user_name
213: AND pubresp.pub_name = 'SERVICEP';
214:

Line 218: FROM asg_user_pub_resps pubresp

214:
215: CURSOR l_route_omfs_palm_res_csr
216: IS
217: SELECT usr.resource_id
218: FROM asg_user_pub_resps pubresp
219: , asg_user usr
220: WHERE usr.enabled = 'Y'
221: AND pubresp.user_name = usr.user_name
222: AND pubresp.pub_name = 'SERVICEP'

Line 219: , asg_user usr

215: CURSOR l_route_omfs_palm_res_csr
216: IS
217: SELECT usr.resource_id
218: FROM asg_user_pub_resps pubresp
219: , asg_user usr
220: WHERE usr.enabled = 'Y'
221: AND pubresp.user_name = usr.user_name
222: AND pubresp.pub_name = 'SERVICEP'
223: AND usr.USER_ID = usr.OWNER_ID;

Line 280: from asg_user

276: is
277: cursor c_user_id (p_user_name varchar2)
278: is
279: select user_id
280: from asg_user
281: where user_name = p_user_name;
282:
283: l_user_id asg_user.user_id%TYPE;
284:

Line 283: l_user_id asg_user.user_id%TYPE;

279: select user_id
280: from asg_user
281: where user_name = p_user_name;
282:
283: l_user_id asg_user.user_id%TYPE;
284:
285: begin
286:
287: --select user_id into l_user_id

Line 288: --from asg_user

284:
285: begin
286:
287: --select user_id into l_user_id
288: --from asg_user
289: --where user_name = p_user_name;
290:
291: OPEN c_user_id(p_user_name);
292: FETCH c_user_id INTO l_user_id;

Line 305: from asg_user

301: is
302: cursor c_user_id (p_user_name varchar2)
303: is
304: select user_id
305: from asg_user
306: where user_name = p_user_name;
307:
308: l_user_id asg_user.user_id%TYPE;
309:

Line 308: l_user_id asg_user.user_id%TYPE;

304: select user_id
305: from asg_user
306: where user_name = p_user_name;
307:
308: l_user_id asg_user.user_id%TYPE;
309:
310: v_client_timezone varchar2(100);
311: v_server_timezone varchar2(100);
312: l_server_time date;

Line 317: --from asg_user

313:
314: begin
315:
316: --select user_id into l_user_id
317: --from asg_user
318: --where user_name = p_user_name;
319:
320: OPEN c_user_id(p_user_name);
321: FETCH c_user_id INTO l_user_id;

Line 728: FROM asg_user_pub_resps pubresp

724: IS
725: CURSOR l_is_palm_resource_csr(p_resource_id IN jtf_rs_resource_extns.resource_id%TYPE)
726: IS--R12 on multiple responsibility
727: SELECT 1
728: FROM asg_user_pub_resps pubresp
729: , asg_user usr
730: WHERE usr.enabled = 'Y'
731: AND pubresp.user_name = usr.user_name
732: AND pubresp.pub_name = 'SERVICEP'

Line 729: , asg_user usr

725: CURSOR l_is_palm_resource_csr(p_resource_id IN jtf_rs_resource_extns.resource_id%TYPE)
726: IS--R12 on multiple responsibility
727: SELECT 1
728: FROM asg_user_pub_resps pubresp
729: , asg_user usr
730: WHERE usr.enabled = 'Y'
731: AND pubresp.user_name = usr.user_name
732: AND pubresp.pub_name = 'SERVICEP'
733: AND usr.resource_id = p_resource_id;

Line 778: FROM asg_user_pub_resps pubresp

774: IS
775: CURSOR l_responsibilities_csr (b_user_id NUMBER)--R12 For multiple responsibility
776: IS
777: SELECT 1
778: FROM asg_user_pub_resps pubresp
779: , asg_user usr
780: WHERE usr.enabled = 'Y'
781: AND pubresp.user_name = usr.user_name
782: AND pubresp.pub_name = 'SERVICEP'

Line 779: , asg_user usr

775: CURSOR l_responsibilities_csr (b_user_id NUMBER)--R12 For multiple responsibility
776: IS
777: SELECT 1
778: FROM asg_user_pub_resps pubresp
779: , asg_user usr
780: WHERE usr.enabled = 'Y'
781: AND pubresp.user_name = usr.user_name
782: AND pubresp.pub_name = 'SERVICEP'
783: AND usr.user_id = b_user_id;

Line 832: FROM asg_user_pub_resps pubresp

828:
829: CURSOR l_tl_omfs_palm_users_csr is
830: --R12 For multiple responsibility
831: select usr.USER_ID
832: FROM asg_user_pub_resps pubresp
833: , asg_user usr
834: WHERE usr.LANGUAGE = p_language
835: AND usr.enabled = 'Y'
836: AND pubresp.user_name = usr.user_name

Line 833: , asg_user usr

829: CURSOR l_tl_omfs_palm_users_csr is
830: --R12 For multiple responsibility
831: select usr.USER_ID
832: FROM asg_user_pub_resps pubresp
833: , asg_user usr
834: WHERE usr.LANGUAGE = p_language
835: AND usr.enabled = 'Y'
836: AND pubresp.user_name = usr.user_name
837: AND pubresp.pub_name ='SERVICEP';

Line 842: FROM asg_user_pub_resps pubresp

838:
839: CURSOR l_route_tl_omfs_palm_users_csr is
840: --R12 For multiple responsibility
841: select usr.USER_ID
842: FROM asg_user_pub_resps pubresp
843: , asg_user usr
844: WHERE usr.LANGUAGE = p_language
845: AND usr.enabled = 'Y'
846: AND pubresp.user_name = usr.user_name

Line 843: , asg_user usr

839: CURSOR l_route_tl_omfs_palm_users_csr is
840: --R12 For multiple responsibility
841: select usr.USER_ID
842: FROM asg_user_pub_resps pubresp
843: , asg_user usr
844: WHERE usr.LANGUAGE = p_language
845: AND usr.enabled = 'Y'
846: AND pubresp.user_name = usr.user_name
847: AND pubresp.pub_name ='SERVICEP'

Line 876: FROM asg_user_pub_resps pubresp

872:
873: CURSOR l_tl_omfs_palm_resources_csr is
874: --R12 For multiple responsibility
875: select usr.RESOURCE_ID
876: FROM asg_user_pub_resps pubresp
877: , asg_user usr
878: WHERE usr.LANGUAGE = p_language
879: AND usr.enabled = 'Y'
880: AND pubresp.user_name = usr.user_name

Line 877: , asg_user usr

873: CURSOR l_tl_omfs_palm_resources_csr is
874: --R12 For multiple responsibility
875: select usr.RESOURCE_ID
876: FROM asg_user_pub_resps pubresp
877: , asg_user usr
878: WHERE usr.LANGUAGE = p_language
879: AND usr.enabled = 'Y'
880: AND pubresp.user_name = usr.user_name
881: AND pubresp.pub_name ='SERVICEP';

Line 886: FROM asg_user_pub_resps pubresp

882:
883: CURSOR l_route_tl_omfs_palm_res_csr is
884: --R12 For multiple responsibility
885: select usr.RESOURCE_ID
886: FROM asg_user_pub_resps pubresp
887: , asg_user usr
888: WHERE usr.LANGUAGE = p_language
889: AND usr.enabled = 'Y'
890: AND pubresp.user_name = usr.user_name

Line 887: , asg_user usr

883: CURSOR l_route_tl_omfs_palm_res_csr is
884: --R12 For multiple responsibility
885: select usr.RESOURCE_ID
886: FROM asg_user_pub_resps pubresp
887: , asg_user usr
888: WHERE usr.LANGUAGE = p_language
889: AND usr.enabled = 'Y'
890: AND pubresp.user_name = usr.user_name
891: AND pubresp.pub_name ='SERVICEP'

Line 917: FROM asg_user

913: return VARCHAR2
914: IS
915: CURSOR c_language_csr(p_user_id number) IS
916: SELECT language
917: FROM asg_user
918: WHERE user_id = p_user_id;
919:
920: l_language asg_user.language%TYPE;
921:

Line 920: l_language asg_user.language%TYPE;

916: SELECT language
917: FROM asg_user
918: WHERE user_id = p_user_id;
919:
920: l_language asg_user.language%TYPE;
921:
922: BEGIN
923: OPEN c_language_csr(p_user_id);
924: FETCH c_language_csr INTO l_language;

Line 934: l_user_name asg_user.user_name%TYPE;

930:
931: FUNCTION get_user_name(p_user_id IN number)
932: RETURN varchar2
933: IS
934: l_user_name asg_user.user_name%TYPE;
935:
936: CURSOR l_get_user_name(p_user_id IN number)
937: IS
938: SELECT user_name

Line 939: FROM asg_user

935:
936: CURSOR l_get_user_name(p_user_id IN number)
937: IS
938: SELECT user_name
939: FROM asg_user
940: WHERE user_id = p_user_id;
941:
942: BEGIN
943: OPEN l_get_user_name(p_user_id);

Line 2007: FROM ASG_USER

2003: FUNCTION is_mfs_group(p_group_id NUMBER) RETURN BOOLEAN
2004: IS
2005: CURSOR c_mfs_group(b_group_id NUMBER) IS
2006: SELECT 1
2007: FROM ASG_USER
2008: WHERE GROUP_ID=b_group_id;
2009:
2010: l_mfs_grp NUMBER:=0;
2011: BEGIN

Line 2029: FROM ASG_USER

2025: FUNCTION get_group_owner(p_group_id NUMBER) RETURN NUMBER
2026: IS
2027: CURSOR c_group_owner(b_group_id NUMBER) IS
2028: SELECT USER_ID
2029: FROM ASG_USER
2030: WHERE OWNER_ID=USER_ID
2031: AND GROUP_ID=b_group_id;
2032:
2033: /*

Line 2036: FROM ASG_USER

2032:
2033: /*
2034: CURSOR c_group_owner(b_group_id NUMBER) IS
2035: SELECT USER_ID
2036: FROM ASG_USER
2037: WHERE ROLE_CODE = 'MFS_OWNER'
2038: AND GROUP_ID=b_group_id;*/
2039:
2040: l_grp_owner NUMBER;

Line 2083: FROM ASG_USER

2079: IS
2080: CURSOR c_get_owner(b_user_id NUMBER)
2081: IS
2082: SELECT OWNER_ID
2083: FROM ASG_USER
2084: WHERE USER_ID= p_user_id;
2085:
2086: l_owner_id NUMBER;
2087: BEGIN

Line 2120: /returns True if the asg user name passed is just/being created by mmu/

2116: RETURN l_group_name;
2117:
2118: END get_group_name;
2119:
2120: /*returns True if the asg user name passed is just/being created by mmu*/
2121: FUNCTION is_new_mmu_user(p_user_name IN VARCHAR2) RETURN BOOLEAN
2122: IS
2123: l_exists NUMBER;
2124: BEGIN

Line 2127: from asg_user

2123: l_exists NUMBER;
2124: BEGIN
2125:
2126: select 1 INTO l_exists
2127: from asg_user
2128: where cookie is not null --user has not synch'ed yet
2129: and enabled ='Y'
2130: and user_name = p_user_name;
2131:

Line 2133: from asg_user_pub_resps ar, asg_user au

2129: and enabled ='Y'
2130: and user_name = p_user_name;
2131:
2132: select 1 INTO l_exists
2133: from asg_user_pub_resps ar, asg_user au
2134: where synch_disabled='N' -- is being created by MMU
2135: and ar.pub_name='SERVICEP'
2136: and au.useR_name=ar.user_name
2137: and au.user_name = p_user_name;

Line 2150: SELECT 1 INTO ln FROM ASG_USER

2146: FUNCTION is_html5_user(p_user_name IN VARCHAR2) RETURN BOOLEAN
2147: IS
2148: ln NUMBER;
2149: BEGIN
2150: SELECT 1 INTO ln FROM ASG_USER
2151: WHERE USER_NAME=p_user_name
2152: AND NVL(MULTI_PLATFORM,'N')='Y';
2153: RETURN TRUE;
2154: EXCEPTION WHEN OTHERS THEN

Line 2162: SELECT 1 INTO ln FROM ASG_USER

2158: FUNCTION is_html5_user(p_user_id IN NUMBER) RETURN BOOLEAN
2159: IS
2160: ln NUMBER;
2161: BEGIN
2162: SELECT 1 INTO ln FROM ASG_USER
2163: WHERE USER_ID=p_user_id
2164: AND NVL(MULTI_PLATFORM,'N')='Y';
2165: RETURN TRUE;
2166: EXCEPTION WHEN OTHERS THEN