[Home] [Help]
50: IS
51: l_success VARCHAR2(1);
52: l_error NUMBER;
53: BEGIN
54: fnd_grants_pkg.revoke_grant
55: ( p_api_version => api_version
56: ,p_grant_guid => grant_guid
57: ,x_success => l_success
58: ,x_errorcode => l_error
73: l_grant_guid RAW(16);
74: l_success VARCHAR2(1);
75: l_error NUMBER;
76: BEGIN
77: fnd_grants_pkg.grant_function( p_api_version => api_version
78: , p_menu_name => menu_name
79: , p_instance_type => CALENDAR_INSTANCE_TYPE
80: , p_object_name => CALENDAR_OBJECT
81: , p_instance_pk1_value => p_GranterID
107: l_grant_guid RAW(16);
108: l_success VARCHAR2(1);
109: l_error NUMBER;
110: BEGIN
111: fnd_grants_pkg.grant_function( p_api_version => api_version
112: , p_menu_name => menu_name
113: , p_instance_type => TASK_INSTANCE_TYPE
114: , p_instance_set_id => l_instance_set_id
115: , p_object_name => jtf_task_security_pvt.TASK_OBJECT
172:
173: /** Define a cursor C_CAL to fetch Calendar Read and Full Access for the given p_GranterID **/
174: CURSOR C_CAL IS
175: SELECT fgs.grant_guid, fgs.grantee_key, fmu.menu_name
176: FROM FND_GRANTS fgs, FND_MENUS fmu, FND_OBJECTS fos
177: WHERE fgs.object_id = fos.object_id
178: AND fos.obj_name = CALENDAR_OBJECT
179: AND fgs.menu_id = fmu.menu_id
180: AND fmu.menu_name IN (CALENDAR_READ_PRIVILEGE
189:
190: /** Define a cursor C_CAL to fetch Tasks Read and Full Access for the given p_GranterID **/
191: CURSOR C_TASKS IS
192: SELECT fgs.grant_guid, fgs.grantee_key, fmu.menu_name
193: FROM FND_GRANTS fgs, FND_MENUS fmu, FND_OBJECTS fos
194: WHERE fgs.object_id = fos.object_id
195: AND fos.obj_name = jtf_task_security_pvt.TASK_OBJECT
196: AND fgs.menu_id = fmu.menu_id
197: AND fmu.menu_name IN (jtf_task_security_pvt.READ_PRIVILEGE
314: END IF;
315: END LOOP FULL_ACCESS;
316:
317: /** Get the instance_set_id for instance_name RESOURCE_TASKS_SET **/
318: /** It is required in fnd_grants function **/
319: l_instance_set_id := get_instance_set_id(jtf_task_security_pvt.RESOURCE_TASKS_SET);
320: IF ( l_instance_set_id = -1) THEN
321: fnd_message.set_name('JTF', 'JTF_CAL_INST_SET_ID_NOT_FOUND');
322: fnd_msg_pub.add;
449:
450: l_grant_guid := get_grant_guid(p_resourceId => p_resourceId,
451: p_groupId => p_groupId);
452: IF (l_grant_guid IS NOT NULL) THEN
453: fnd_grants_pkg.revoke_grant
454: (
455: p_api_version => l_api_version,
456: p_grant_guid => l_grant_guid,
457: x_success => l_return_status,
526: ** If not, grant Readonly Access to the requestor first */
527:
528: IF (l_return = false)
529: THEN
530: fnd_grants_pkg.grant_function( p_api_version => 1.0
531: , p_menu_name => l_read_access
532: , p_instance_type => 'INSTANCE'
533: , p_object_name => 'JTF_TASK_RESOURCE'
534: , p_instance_pk1_value => nvl(p_groupId,1)
547:
548: /*****************************************************************************
549: ** Grant Administrator privs to the requestor
550: *****************************************************************************/
551: fnd_grants_pkg.grant_function( p_api_version => 1.0
552: , p_menu_name => p_accesslevel
553: , p_instance_type => 'INSTANCE'
554: , p_object_name => 'JTF_TASK_RESOURCE'
555: , p_instance_pk1_value => nvl(p_groupId,1)
606: IS
607: l_grant_guid RAW(16);
608:
609: /*cursor C is
610: SELECT grant_guid FROM FND_GRANTS
611: WHERE grantee_key = p_resourceId
612: AND instance_pk1_value = p_groupId
613: AND instance_pk2_value = 'RS_GROUP'
614: AND program_name = 'CALENDAR'; */
614: AND program_name = 'CALENDAR'; */
615:
616: cursor C is
617: SELECT fgs.grant_guid
618: FROM FND_GRANTS fgs, FND_MENUS fmu
619: WHERE grantee_key = p_resourceId
620: AND instance_pk1_value = p_groupId
621: AND instance_pk2_value = 'RS_GROUP'
622: AND program_name = 'CALENDAR'
642: IS
643: l_count NUMBER;
644: l_return BOOLEAN;
645: cursor c_Count is
646: SELECT 1 FROM FND_GRANTS
647: WHERE grantee_key = p_resourceId
648: AND instance_pk1_value = p_groupId
649: AND instance_pk2_value = 'RS_GROUP'
650: AND program_name = 'CALENDAR';