[Home] [Help]
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'JTF_CAL_GRANTS';
5:
6: CURSOR C_LOGGEDIN_RESOURCE IS
7: select resource_id, resource_type
8: from cac_cal_resources
9: where user_name = FND_GLOBAL.USER_NAME;
10:
11: CURSOR C_GRANTEE_USER
12: (
13: b_resource_id NUMBER,
14: b_resource_type VARCHAR2
15: ) IS
16: select user_name
17: from cac_cal_resources
18: where resource_id = b_resource_id
19: and resource_type = b_resource_type;
20:
21: CURSOR C_INSTANCE_SET_ID IS
45: fnd_grants_pkg.grant_function
46: ( p_api_version => 1.0
47: , p_menu_name => p_appointment_access
48: , p_instance_type => 'INSTANCE'
49: , p_object_name => 'CAC_CAL_RESOURCES'
50: , p_instance_pk1_value => TO_CHAR(p_resource_id)
51: , p_instance_pk2_value => p_resource_type
52: , p_grantee_type => 'USER'
53: , p_grantee_key => p_grantee
73: fnd_grants_pkg.grant_function
74: ( p_api_version => 1.0
75: , p_menu_name => p_booking_access
76: , p_instance_type => 'INSTANCE'
77: , p_object_name => 'CAC_CAL_RESOURCES'
78: , p_instance_pk1_value => TO_CHAR(p_resource_id)
79: , p_instance_pk2_value => p_resource_type
80: , p_grantee_type => 'USER'
81: , p_grantee_key => p_grantee
101: fnd_grants_pkg.grant_function
102: ( p_api_version => 1.0
103: , p_menu_name => p_task_access
104: , p_instance_type => 'INSTANCE'
105: , p_object_name => 'CAC_CAL_RESOURCES'
106: , p_instance_pk1_value => TO_CHAR(p_resource_id)
107: , p_instance_pk2_value => p_resource_type
108: , p_grantee_type => 'USER'
109: , p_grantee_key => p_grantee
250: FROM FND_GRANTS fgs
251: , FND_MENUS fmu
252: , FND_OBJECTS fos
253: WHERE fgs.object_id = fos.object_id
254: AND fos.obj_name = 'CAC_CAL_RESOURCES'
255: AND fgs.menu_id = fmu.menu_id
256: AND fmu.menu_name IN ( 'JTF_CAL_READ_ACCESS'
257: , 'JTF_CAL_FULL_ACCESS'
258: , 'JTF_TASK_READ_ONLY'