DBA Data[Home] [Help]

APPS.OZF_UTILITY_PVT dependencies on AK_ATTRIBUTES_VL

Line 3587: FROM ak_attributes_vl ak

3583: ) RETURN VARCHAR2
3584: IS
3585: CURSOR c_name(cp_attributeCode VARCHAR2, cp_applicationId NUMBER) IS
3586: SELECT ak.attribute_label_long
3587: FROM ak_attributes_vl ak
3588: WHERE ak.attribute_code = upper(cp_attributeCode)
3589: AND ak.attribute_application_id = cp_applicationId;
3590:
3591: l_attributeName AK_ATTRIBUTES_VL.NAME%TYPE;

Line 3591: l_attributeName AK_ATTRIBUTES_VL.NAME%TYPE;

3587: FROM ak_attributes_vl ak
3588: WHERE ak.attribute_code = upper(cp_attributeCode)
3589: AND ak.attribute_application_id = cp_applicationId;
3590:
3591: l_attributeName AK_ATTRIBUTES_VL.NAME%TYPE;
3592: BEGIN
3593: OPEN c_name(cp_attributeCode => p_attributeCode, cp_applicationId => p_applicationId);
3594: FETCH c_name INTO l_attributeName;
3595: IF c_name%NOTFOUND THEN