DBA Data[Home] [Help]

APPS.OZF_UTILITY_PVT dependencies on AK_ATTRIBUTES_VL

Line 3565: FROM ak_attributes_vl ak

3561: ) RETURN VARCHAR2
3562: IS
3563: CURSOR c_name(cp_attributeCode VARCHAR2, cp_applicationId NUMBER) IS
3564: SELECT ak.attribute_label_long
3565: FROM ak_attributes_vl ak
3566: WHERE ak.attribute_code = upper(cp_attributeCode)
3567: AND ak.attribute_application_id = cp_applicationId;
3568:
3569: l_attributeName AK_ATTRIBUTES_VL.NAME%TYPE;

Line 3569: l_attributeName AK_ATTRIBUTES_VL.NAME%TYPE;

3565: FROM ak_attributes_vl ak
3566: WHERE ak.attribute_code = upper(cp_attributeCode)
3567: AND ak.attribute_application_id = cp_applicationId;
3568:
3569: l_attributeName AK_ATTRIBUTES_VL.NAME%TYPE;
3570: BEGIN
3571: OPEN c_name(cp_attributeCode => p_attributeCode, cp_applicationId => p_applicationId);
3572: FETCH c_name INTO l_attributeName;
3573: IF c_name%NOTFOUND THEN