APPS.JTF_RS_GROUP_MEMBER_VUHK SQL Statements

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

Line: 98

	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: 106

  END update_group_members_pre;

Line: 110

	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: 118

  END update_group_members_post;

Line: 122

	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_JTM_enable_prof_value varchar2(255);

Line: 135

           ' ''DELETE_GROUP_MEMBERS_PRE'', ' ||
           ' ''JTF_RS_GROUP_MEMBER_VUHK'', ' ||
           ' ''Error:'' || SQLERRM ' || ',' ||
           ' 1,' ||
           ' ''JTM.JTF_RS_GROUP_MEMBER_VUHK.DELETE_GROUP_MEMBERS_PRE''); ' ||

Line: 150

           ' ''DELETE_GROUP_MEMBERS_PRE'', ' ||
           ' ''JTF_RS_GROUP_MEMBER_VUHK'', ' ||
           ' ''The procedure is called.'', ' ||
           ' 4,' ||
           ' ''JTM.JTF_RS_GROUP_MEMBER_VUHK.DELETE_GROUP_MEMBERS_PRE''); ' ||

Line: 167

            ' begin ' || 'JTM_RS_GROUP_MEMBER_VUHK' || '.' || 'delete_group_members_pre' ||
            '(:1,:2,:3); ' ||

Line: 195

END delete_group_members_pre;

Line: 199

	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: 208

  END delete_group_members_post;