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
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
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'
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;
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;
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;
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;
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;
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;
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: /***