[Home] [Help]
46: l_access_count NUMBER;
47:
48: CURSOR c_access_seq IS
49: SELECT ams_act_access_s.NEXTVAL
50: FROM DUAL;
51:
52: CURSOR c_access_count(l_access_id IN NUMBER) IS
53: SELECT COUNT(*)
54: FROM ams_act_access
68: /* if the entry exists ams_act_access table then a message is popped up to run the concurrent program */
69:
70: CURSOR c_group_exists IS
71: SELECT 1
72: FROM DUAL
73: WHERE NOT EXISTS(SELECT 1
74: FROM ams_act_access
75: WHERE ams_act_access.act_access_to_object_id = p_access_rec.act_access_to_object_id
76: AND ams_act_access.arc_act_access_to_object = p_access_rec.arc_act_access_to_object
305: decode(l_access_rec.owner_flag,'Y','Y',nvl(l_access_rec.admin_flag,'N') ),
306: l_access_rec.approver_flag,
307: l_access_rec.owner_flag,
308: 'N'
309: FROM DUAL
310: WHERE NOT EXISTS ( SELECT 1 FROM AMS_ACT_ACCESS WHERE act_access_to_object_id = l_schedule_rec.schedule_id
311: and arc_act_access_to_object = 'CSCH'
312: and user_or_role_id = l_access_rec.user_or_role_id
313: and arc_user_or_role_type = 'USER');
1874: -- Following code is commented by ptendulk on 18Jul2000
1875: --=============================================================================
1876: -- CURSOR c_group_access IS
1877: -- SELECT 1
1878: -- FROM DUAL
1879: -- WHERE EXISTS(
1880: -- SELECT 1
1881: -- FROM ams_act_access A, jtf_rs_group_members_vl B
1882: -- WHERE A.arc_act_access_to_object = p_object_type
1889: -- AND B.resource_id = p_user_or_role_id);
1890:
1891: CURSOR c_group_access(c_grp_id NUMBER) IS
1892: SELECT 1
1893: FROM DUAL
1894: WHERE EXISTS(
1895: SELECT 1
1896: FROM ams_act_access
1897: WHERE arc_act_access_to_object = p_object_type
2406: -- cursor added by julou 29-nov-2001 ref. bug 2117645
2407: /*
2408: CURSOR c_user_exist IS
2409: SELECT 1
2410: FROM DUAL
2411: WHERE EXISTS(SELECT 1
2412: FROM ams_act_access
2413: WHERE act_access_to_object_id = p_access_rec.act_access_to_object_id
2414: AND arc_act_access_to_object = p_access_rec.arc_act_access_to_object