APPS.FEM_DIS_HIER_PKG dependencies on FEM_DIMENSIONS_VL

Line 300: v_dimension_id FEM_DIMENSIONS_VL.DIMENSION_ID%TYPE;

296: FUNCTION Transformation(
297: p_dimension_varchar_label IN VARCHAR2
298: ) RETURN VARCHAR2 IS
299:
300: v_dimension_id FEM_DIMENSIONS_VL.DIMENSION_ID%TYPE;
301: v_dimension_name FEM_DIMENSIONS_VL.DIMENSION_NAME%TYPE;
302: v_member_b_table_name FEM_XDIM_DIMENSIONS.MEMBER_B_TABLE_NAME%TYPE;
303: v_member_tl_table_name FEM_XDIM_DIMENSIONS.MEMBER_TL_TABLE_NAME%TYPE;
304: v_member_vl_object_name FEM_XDIM_DIMENSIONS.MEMBER_VL_OBJECT_NAME%TYPE;

Line 301: v_dimension_name FEM_DIMENSIONS_VL.DIMENSION_NAME%TYPE;

297: p_dimension_varchar_label IN VARCHAR2
298: ) RETURN VARCHAR2 IS
299:
300: v_dimension_id FEM_DIMENSIONS_VL.DIMENSION_ID%TYPE;
301: v_dimension_name FEM_DIMENSIONS_VL.DIMENSION_NAME%TYPE;
302: v_member_b_table_name FEM_XDIM_DIMENSIONS.MEMBER_B_TABLE_NAME%TYPE;
303: v_member_tl_table_name FEM_XDIM_DIMENSIONS.MEMBER_TL_TABLE_NAME%TYPE;
304: v_member_vl_object_name FEM_XDIM_DIMENSIONS.MEMBER_VL_OBJECT_NAME%TYPE;
305: v_member_col FEM_XDIM_DIMENSIONS.MEMBER_COL%TYPE;

Line 467: FEM_DIMENSIONS_VL V,

463: v_attribute_table_name,
464: v_composite_dimension_flag,
465: v_value_set_required_flag
466: FROM
467: FEM_DIMENSIONS_VL V,
468: FEM_XDIM_DIMENSIONS X
469: WHERE
470: X.DIMENSION_ID = V.DIMENSION_ID AND
471: V.DIMENSION_VARCHAR_LABEL = p_dimension_varchar_label;