The following lines contain the word 'select', 'insert', 'update' or 'delete':
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';
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;
END update_group_members_pre;
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;
END update_group_members_post;
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);
FOR Csr1 in Get_hook_info('B', 'DELETE_RESOURCE_GROUP_MEMBERS') LOOP
/* user execute flag */
l_enable_flag := Csr1.EXECUTE_FLAG;
END delete_group_members_pre;
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;
END delete_group_members_post;