DBA Data[Home] [Help]

APPS.ICX_USER_SEC_ATTR_PVT dependencies on AK_WEB_USER_SEC_ATTR_VALUES

Line 68: from ak_web_user_sec_attr_values

64: -- ************************************
65: -- select responsibility_id
66: select count(*)
67: into l_duplicate
68: from ak_web_user_sec_attr_values
69: where web_user_id = p_web_user_id
70: and attribute_code = p_attribute_code
71: and attribute_application_id = p_attribute_appl_id
72: and ((varchar2_value = p_varchar2_value)

Line 90: INSERT into AK_WEB_USER_SEC_ATTR_VALUES

86: fnd_message.set_name('FND','SECURITY-DUPLICATE USER RESP');
87: fnd_msg_pub.Add;
88: raise FND_API.G_EXC_ERROR;
89: else
90: INSERT into AK_WEB_USER_SEC_ATTR_VALUES
91: (
92: WEB_USER_ID ,
93: ATTRIBUTE_APPLICATION_ID ,
94: ATTRIBUTE_CODE ,

Line 250: Delete from AK_WEB_USER_SEC_ATTR_VALUES

246: -- Initialize API return status to success
247:
248: p_return_status := FND_API.G_RET_STS_SUCCESS;
249:
250: Delete from AK_WEB_USER_SEC_ATTR_VALUES
251: where web_user_id = p_web_user_id
252: and attribute_code = p_attribute_code
253: and attribute_application_id = p_attribute_appl_id
254: and ((varchar2_value = p_varchar2_value)