APPS.ICX_RESP_EXCL_ATTR_PVT dependencies on AK_EXCLUDED_ITEMS

Line 66: from ak_excluded_items

62: -- ************************************
63: -- select responsibility_id
64: select count(*)
65: into l_duplicate
66: from ak_excluded_items
67: where resp_application_id = p_application_id
68: and attribute_code = p_attribute_code
69: and responsibility_id = p_responsibility_id
70: and attribute_application_id = p_attribute_appl_id;

Line 83: INSERT into AK_EXCLUDED_ITEMS

79: fnd_message.set_name('FND','SECURITY-DUPLICATE USER RESP');
80: fnd_msg_pub.Add;
81: raise FND_API.G_EXC_ERROR;
82: else
83: INSERT into AK_EXCLUDED_ITEMS
84: (
85: RESPONSIBILITY_ID ,
86: ATTRIBUTE_APPLICATION_ID,
87: ATTRIBUTE_CODE ,

Line 236: Delete from AK_EXCLUDED_ITEMS

232: -- Initialize API return status to success
233:
234: p_return_status := FND_API.G_RET_STS_SUCCESS;
235:
236: Delete from AK_EXCLUDED_ITEMS
237: where resp_application_id = p_application_id
238: and attribute_code = p_attribute_code
239: and responsibility_id = p_responsibility_id
240: and attribute_application_id = p_attribute_appl_id;