APPS.JTM_HOOK_UTIL_PKG dependencies on ASG_USER

Line 42: - Exists in ASG_USER

38: RETURN BOOLEAN
39: IS
40: /*** cursor to check if user is mobile user resource ***/
41: /* A user is a mobile FS user when:
42: - Exists in ASG_USER
43: - Has a responsibility that is mapped to the publication 'SERVICEL'
44: */
45: --Bug 4924543
46: CURSOR c_asg_user( b_resource_id NUMBER ) IS

Line 46: CURSOR c_asg_user( b_resource_id NUMBER ) IS

42: - Exists in ASG_USER
43: - Has a responsibility that is mapped to the publication 'SERVICEL'
44: */
45: --Bug 4924543
46: CURSOR c_asg_user( b_resource_id NUMBER ) IS
47: SELECT null
48: FROM asg_user au
49: , asg_user_pub_resps aupr
50: WHERE au.user_name = aupr.user_name

Line 48: FROM asg_user au

44: */
45: --Bug 4924543
46: CURSOR c_asg_user( b_resource_id NUMBER ) IS
47: SELECT null
48: FROM asg_user au
49: , asg_user_pub_resps aupr
50: WHERE au.user_name = aupr.user_name
51: AND aupr.pub_name = 'SERVICEL'
52: AND au.enabled = 'Y'

Line 49: , asg_user_pub_resps aupr

45: --Bug 4924543
46: CURSOR c_asg_user( b_resource_id NUMBER ) IS
47: SELECT null
48: FROM asg_user au
49: , asg_user_pub_resps aupr
50: WHERE au.user_name = aupr.user_name
51: AND aupr.pub_name = 'SERVICEL'
52: AND au.enabled = 'Y'
53: AND au.resource_id = b_resource_id;

Line 55: r_asg_user c_asg_user%ROWTYPE;

51: AND aupr.pub_name = 'SERVICEL'
52: AND au.enabled = 'Y'
53: AND au.resource_id = b_resource_id;
54:
55: r_asg_user c_asg_user%ROWTYPE;
56:
57: BEGIN
58: OPEN c_asg_user( p_resource_id );
59: FETCH c_asg_user INTO r_asg_user;

Line 58: OPEN c_asg_user( p_resource_id );

54:
55: r_asg_user c_asg_user%ROWTYPE;
56:
57: BEGIN
58: OPEN c_asg_user( p_resource_id );
59: FETCH c_asg_user INTO r_asg_user;
60: IF c_asg_user%NOTFOUND THEN
61: /*** resource is not a mobile user -> exit ***/
62: CLOSE c_asg_user;

Line 59: FETCH c_asg_user INTO r_asg_user;

55: r_asg_user c_asg_user%ROWTYPE;
56:
57: BEGIN
58: OPEN c_asg_user( p_resource_id );
59: FETCH c_asg_user INTO r_asg_user;
60: IF c_asg_user%NOTFOUND THEN
61: /*** resource is not a mobile user -> exit ***/
62: CLOSE c_asg_user;
63: RETURN FALSE;

Line 60: IF c_asg_user%NOTFOUND THEN

56:
57: BEGIN
58: OPEN c_asg_user( p_resource_id );
59: FETCH c_asg_user INTO r_asg_user;
60: IF c_asg_user%NOTFOUND THEN
61: /*** resource is not a mobile user -> exit ***/
62: CLOSE c_asg_user;
63: RETURN FALSE;
64: END IF;

Line 62: CLOSE c_asg_user;

58: OPEN c_asg_user( p_resource_id );
59: FETCH c_asg_user INTO r_asg_user;
60: IF c_asg_user%NOTFOUND THEN
61: /*** resource is not a mobile user -> exit ***/
62: CLOSE c_asg_user;
63: RETURN FALSE;
64: END IF;
65: CLOSE c_asg_user;
66: RETURN TRUE;

Line 65: CLOSE c_asg_user;

61: /*** resource is not a mobile user -> exit ***/
62: CLOSE c_asg_user;
63: RETURN FALSE;
64: END IF;
65: CLOSE c_asg_user;
66: RETURN TRUE;
67: END isMobileFSresource;
68:
69: /***