DBA Data[Home] [Help]

APPS.JTF_RS_GRP_MEMBERSHIP_PUB dependencies on JTF_RS_GROUP_MEMBERS

Line 81: from jtf_rs_group_members

77:
78: cursor check_group_member_exists(l_group_id number, l_resource_id number)
79: is
80: select group_member_id
81: from jtf_rs_group_members
82: where group_id = l_group_id
83: and resource_id = l_resource_id
84: and nvl(delete_flag, 'N') <> 'Y';
85:

Line 325: jtf_rs_group_members_pub.create_resource_group_members

321: into l_group_member_id;
322: if check_group_member_exists%NOTFOUND
323: then
324:
325: jtf_rs_group_members_pub.create_resource_group_members
326: (p_api_version => 1.0
327: ,p_init_msg_list => fnd_api.g_false
328: ,p_commit => fnd_api.g_false
329: ,p_group_id => p_group_id

Line 735: from jtf_rs_group_members

731:
732: cursor get_obj_ver_num(l_group_member_id number)
733: is
734: select object_version_number
735: from jtf_rs_group_members
736: where group_member_id = l_group_member_id;
737:
738: l_object_version_num jtf_rs_role_relations.object_version_number%type;
739:

Line 778: jtf_rs_group_members_pub.delete_resource_group_members

774: fetch get_obj_ver_num
775: into l_object_version_num;
776: close get_obj_ver_num;
777:
778: jtf_rs_group_members_pub.delete_resource_group_members
779: (P_API_VERSION => 1.0,
780: P_INIT_MSG_LIST => fnd_api.g_false,
781: P_COMMIT => fnd_api.g_false,
782: P_GROUP_ID => p_group_id,