APPS.JTF_CAL_GRANTS_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 12

    select user_name from jtf_rs_resource_extns
    where resource_id = TO_NUMBER(resourceId);

Line: 32

    select instance_set_id from fnd_object_instance_sets
    where instance_set_name = jtf_task_security_pvt.RESOURCE_TASKS_SET;

Line: 133

PROCEDURE UpdateGrants
/*******************************************************************************
** Given:
** - the Granter
** - a list of Read Only Grantees
** - a list of Full Access Grantees
** This API will make sure that the proper grants are create/deleted
*******************************************************************************/
( p_api_version            IN     NUMBER
, p_init_msg_list          IN     VARCHAR2 DEFAULT fnd_api.g_false
, p_commit                 IN     VARCHAR2 DEFAULT fnd_api.g_false
, p_validation_level       IN     NUMBER   DEFAULT fnd_api.g_valid_level_full
, x_return_status          OUT    NOCOPY   VARCHAR2
, x_msg_count              OUT    NOCOPY   NUMBER
, x_msg_data               OUT    NOCOPY   VARCHAR2
, p_GranterID              IN     VARCHAR2
, p_ReadAccess             IN     VARCHAR2
, p_FullAccess             IN     VARCHAR2
)
IS
  l_api_name        CONSTANT VARCHAR2(30)   := 'UpdateGrants';

Line: 175

  SELECT fgs.grant_guid, fgs.grantee_key, fmu.menu_name
  FROM FND_GRANTS fgs, FND_MENUS fmu, FND_OBJECTS fos
  WHERE fgs.object_id = fos.object_id
  AND   fos.obj_name = CALENDAR_OBJECT
  AND   fgs.menu_id = fmu.menu_id
  AND   fmu.menu_name IN (CALENDAR_READ_PRIVILEGE
                         ,CALENDAR_FULL_PRIVILEGE
                         ) -- Calendar Read and Full Access
  AND   instance_pk1_value = p_GranterID
  AND   instance_pk2_value = CALENDAR_RESOURCE_TYPE
  AND   instance_type = CALENDAR_INSTANCE_TYPE
  AND   grantee_type = GRANTEE_TYPE
  AND   program_name = PROGRAM_NAME
  AND   program_tag = 'ACCESS LEVEL';

Line: 192

  SELECT fgs.grant_guid, fgs.grantee_key, fmu.menu_name
  FROM FND_GRANTS fgs, FND_MENUS fmu, FND_OBJECTS fos
  WHERE fgs.object_id = fos.object_id
  AND   fos.obj_name =  jtf_task_security_pvt.TASK_OBJECT
  AND   fgs.menu_id = fmu.menu_id
  AND   fmu.menu_name IN (jtf_task_security_pvt.READ_PRIVILEGE
                         ,jtf_task_security_pvt.FULL_PRIVILEGE
                         ) -- Task Read and Full Access
  AND   instance_type = TASK_INSTANCE_TYPE
  AND   instance_set_id = l_instance_set_id
  AND   parameter1 = p_GranterID
  AND   grantee_type = GRANTEE_TYPE
  AND   program_name = PROGRAM_NAME
  AND   program_tag = 'ACCESS LEVEL';

Line: 426

END UpdateGrants;

Line: 610

      SELECT grant_guid FROM FND_GRANTS
      WHERE grantee_key = p_resourceId
      AND instance_pk1_value = p_groupId
      AND instance_pk2_value = 'RS_GROUP'
      AND program_name = 'CALENDAR'; */

Line: 617

      SELECT fgs.grant_guid
      FROM FND_GRANTS fgs, FND_MENUS fmu
      WHERE grantee_key = p_resourceId
      AND instance_pk1_value = p_groupId
      AND instance_pk2_value = 'RS_GROUP'
      AND program_name = 'CALENDAR'
      AND fgs.menu_id = fmu.menu_id
      AND fmu.menu_name = 'JTF_CAL_ADMIN_ACCESS';

Line: 646

    SELECT 1 FROM FND_GRANTS
    WHERE grantee_key = p_resourceId
    AND instance_pk1_value = p_groupId
    AND instance_pk2_value = 'RS_GROUP'
    AND program_name = 'CALENDAR';