DBA Data[Home] [Help]

APPS.IBU_DYN_USER_GROUPS_PKG dependencies on JTF_RS_GROUP_MEMBERS_PUB

Line 486: JTF_RS_GROUP_MEMBERS_PUB.delete_resource_group_members

482: Update_Category_SourceId(l_category);
483:
484: /* Delete existing members in the group who should not be part of this user group. Reason : because of change in the user group query */
485: For l_del_mem_rec IN l_del_mem_csr(l_group_id) Loop
486: JTF_RS_GROUP_MEMBERS_PUB.delete_resource_group_members
487: (P_API_VERSION => 1,
488: P_INIT_MSG_LIST =>FND_API.G_FALSE,
489: P_COMMIT =>FND_API.G_FALSE,
490: P_GROUP_ID =>l_upd_rec.group_id ,

Line 499: Status_Log_Message('Return status of JTF_RS_GROUP_MEMBERS_PUB.delete_resource_group_members api ' ||

495: X_RETURN_STATUS => l_return_status,
496: X_MSG_COUNT => l_msg_count,
497: X_MSG_DATA => l_msg_data
498: );
499: Status_Log_Message('Return status of JTF_RS_GROUP_MEMBERS_PUB.delete_resource_group_members api ' ||
500: ' l_mem_id = ' || to_char(l_del_mem_rec.group_member_id) || ' ',
501: l_return_status , l_msg_count , l_msg_data );
502: End Loop;
503:

Line 619: JTF_RS_GROUP_MEMBERS_PUB.create_resource_group_members(P_API_VERSION => 1.0,

615: End Loop;
616:
617: /* create news members in the group who are not part of this user group. Reason : because of change in the user group query */
618: For l_cre_rec IN l_cre_csr(l_group_id) Loop
619: JTF_RS_GROUP_MEMBERS_PUB.create_resource_group_members(P_API_VERSION => 1.0,
620: P_INIT_MSG_LIST => FND_API.G_FALSE,
621: P_COMMIT => FND_API.G_FALSE,
622: P_GROUP_ID => l_group_id,
623: P_GROUP_NUMBER => l_group_number,

Line 632: Status_Log_Message('Return status of JTF_RS_GROUP_MEMBERS_PUB.create_resource_group_members api ' ||

628: X_MSG_DATA => l_msg_data,
629: X_GROUP_MEMBER_ID => l_group_member_id
630: );
631: If (l_return_status <> fnd_api.g_ret_sts_success) Then
632: Status_Log_Message('Return status of JTF_RS_GROUP_MEMBERS_PUB.create_resource_group_members api ' ||
633: ' l_cre_rec.resource_id = ' || to_char(l_cre_rec.resource_id) || ' ',
634: l_return_status , l_msg_count , l_msg_data );
635: End If;
636: End Loop;

Line 1015: jtf_rs_group_members_pub.create_resource_group_members

1011: -- Resource exists by now, so create resource member.
1012:
1013: If l_resource_id <> 0 Then
1014: /* resource already exists and it is active. So, call create group members api */
1015: jtf_rs_group_members_pub.create_resource_group_members
1016: (P_API_VERSION => 1.0,
1017: P_INIT_MSG_LIST => FND_API.G_FALSE,
1018: P_COMMIT => FND_API.G_FALSE,
1019: P_GROUP_ID => l_group_id,

Line 1035: Status_Log_Message('Return status of JTF_RS_GROUP_MEMBERS_PUB.create_resource_group_members api ' ||

1031: Where group_id = l_group_id
1032: and resource_id = l_resource_id
1033: and delete_flag = 'N';
1034: If l_temp_cnt = 0 Then
1035: Status_Log_Message('Return status of JTF_RS_GROUP_MEMBERS_PUB.create_resource_group_members api ' ||
1036: ' l_resource_id = ' || to_char(l_resource_id) || ' ',
1037: l_return_status , l_msg_count , l_msg_data );
1038: End If;
1039: End If;

Line 1198: jtf_rs_group_members_pub.delete_resource_group_members(P_API_VERSION => 1.0,

1194: /* Find category for the SQL_TEXT */
1195: get_category(l_del_rec.sql_text, l_category);
1196:
1197: For l_del_mem_rec IN l_del_mem_csr(l_del_rec.static_group_id) Loop
1198: jtf_rs_group_members_pub.delete_resource_group_members(P_API_VERSION => 1.0,
1199: P_INIT_MSG_LIST => FND_API.G_FALSE,
1200: P_COMMIT => FND_API.G_FALSE,
1201: P_GROUP_ID => l_del_mem_rec.group_id,
1202: P_GROUP_NUMBER => l_del_mem_rec.group_number,

Line 1211: Status_Log_Message('Return status of JTF_RS_GROUP_MEMBERS_PUB.delete_resource_group_members api ' ||

1207: X_MSG_COUNT => l_msg_count,
1208: X_MSG_DATA => l_msg_data
1209: );
1210: If (l_return_status <> fnd_api.g_ret_sts_success) Then
1211: Status_Log_Message('Return status of JTF_RS_GROUP_MEMBERS_PUB.delete_resource_group_members api ' ||
1212: ' l_mem_id = ' || to_char(l_del_mem_rec.group_member_id) || ' ',
1213: l_return_status , l_msg_count , l_msg_data );
1214: End If;
1215: End Loop; -- End of l_del_mem_csr loop