APPS.CAC_VIEW_WF_PVT dependencies on FND_GRANTS

Line 259: FROM fnd_grants fgs

255: ** Pick up all the Admins for the given group ID
256: ****************************************************************************/
257: (b_group_id NUMBER)
258: IS SELECT DISTINCT to_number(fgs.grantee_key) ResourceID
259: FROM fnd_grants fgs
260: , fnd_menus fmu
261: , fnd_objects fos
262: WHERE fgs.object_id = fos.object_id -- grants joint to object
263: AND fgs.menu_id = fmu.menu_id -- grants joint to menus

Line 840: fnd_grants_pkg.grant_function( p_api_version => 1.0

836:
837: /*****************************************************************************
838: ** Grant privs to the requestor
839: *****************************************************************************/
840: fnd_grants_pkg.grant_function( p_api_version => 1.0
841: , p_menu_name => l_Response
842: , p_instance_type => 'INSTANCE'
843: , p_object_name => 'JTF_TASK_RESOURCE'
844: , p_instance_pk1_value => to_char(l_GroupID)

Line 862: fnd_grants_pkg.grant_function( p_api_version => 1.0

858: ** If the Access Level is ADMIN, grant the requstor READ Access as well
859: *****************************************************************************/
860: IF (l_Response = 'CAC_VWS_ADMIN_ACCESS')
861: THEN
862: fnd_grants_pkg.grant_function( p_api_version => 1.0
863: , p_menu_name => 'CAC_VWS_READ_ACCESS'
864: , p_instance_type => 'INSTANCE'
865: , p_object_name => 'JTF_TASK_RESOURCE'
866: , p_instance_pk1_value => to_char(l_GroupID)

Line 1343: fnd_grants_pkg.grant_function( p_api_version => 1.0

1339:
1340: /*****************************************************************************
1341: ** Grant Administrator privs to the requestor
1342: *****************************************************************************/
1343: fnd_grants_pkg.grant_function( p_api_version => 1.0
1344: , p_menu_name => 'CAC_VWS_ADMIN_ACCESS'
1345: , p_instance_type => 'INSTANCE'
1346: , p_object_name => 'JTF_TASK_RESOURCE'
1347: , p_instance_pk1_value => to_char(nvl(l_GroupID,1))

Line 1364: fnd_grants_pkg.grant_function( p_api_version => 1.0

1360: /*****************************************************************************
1361: ** Grant Readonly privs to the requestor as well
1362: ** Added by Jane on 04/30/02
1363: *****************************************************************************/
1364: fnd_grants_pkg.grant_function( p_api_version => 1.0
1365: , p_menu_name => 'CAC_VWS_READ_ACCESS'
1366: , p_instance_type => 'INSTANCE'
1367: , p_object_name => 'JTF_TASK_RESOURCE'
1368: , p_instance_pk1_value => to_char(nvl(l_GroupID,1))