APPS.JTM_RS_GROUP_MEMBER_VUHK SQL Statements

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

Line: 5

     Select HOOK_PACKAGE, HOOK_API , EXECUTE_FLAG, PRODUCT_CODE
	 from JTF_HOOKS_DATA
	 Where package_name = 'JTM_RS_GROUP_MEMBERS_PVT' and
	 upper(api_name) = upper(p_api_name) and
	 processing_type = p_processing_type and
         execute_flag = 'Y' and
	 hook_type = 'V';

Line: 81

	update resource group members */

  PROCEDURE  update_group_members_pre
  (P_GROUP_MEMBER_ID             IN   JTF_RS_GROUP_MEMBERS.GROUP_MEMBER_ID%TYPE,
   X_RETURN_STATUS        OUT NOCOPY VARCHAR2
  ) IS
  BEGIN
    x_return_status := fnd_api.g_ret_sts_success;

Line: 89

  END update_group_members_pre;

Line: 93

	update resource group members */

  PROCEDURE  update_group_members_post
  (P_GROUP_MEMBER_ID             IN   JTF_RS_GROUP_MEMBERS.GROUP_MEMBER_ID%TYPE,
   X_RETURN_STATUS        OUT NOCOPY VARCHAR2
  ) IS
  BEGIN
    x_return_status := fnd_api.g_ret_sts_success;

Line: 101

  END update_group_members_post;

Line: 105

	delete resource group members */

  PROCEDURE  delete_group_members_pre
  (P_GROUP_ID             IN   JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
   P_RESOURCE_ID          IN   JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,
   X_RETURN_STATUS        OUT NOCOPY VARCHAR2
  ) IS
    l_enable_flag varchar2(20);

Line: 121

   FOR Csr1 in Get_hook_info('B', 'DELETE_RESOURCE_GROUP_MEMBERS') LOOP

      /* user execute flag */
      l_enable_flag := Csr1.EXECUTE_FLAG;

Line: 155

END delete_group_members_pre;

Line: 159

	delete resource group members */

  PROCEDURE delete_group_members_post
  (P_GROUP_ID             IN   JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
   P_RESOURCE_ID          IN   JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,
   X_RETURN_STATUS        OUT NOCOPY VARCHAR2
  ) IS
  BEGIN
    x_return_status := fnd_api.g_ret_sts_success;

Line: 168

  END delete_group_members_post;