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
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)