APPS.FEM_DIM_ATTRIBUTES_UTIL_PKG dependencies on FEM_XDIM_DIMENSIONS

Line 151: FROM fem_dimensions_b B, fem_xdim_dimensions X

147: /* Validate that the Dimension Varchar Label exists */
148: BEGIN
149: SELECT B.dimension_id
150: INTO v_dimension_id
151: FROM fem_dimensions_b B, fem_xdim_dimensions X
152: WHERE B.dimension_varchar_label = p_dimension_varchar_label
153: AND B.dimension_id = X.dimension_id
154: AND X.attribute_table_name IS NOT NULL;
155:

Line 238: FROM fem_xdim_dimensions

234: DECODE(member_data_type_code,'VARCHAR',
235: 'DIM_ATTRIBUTE_VARCHAR_MEMBER',
236: 'NUMBER','DIM_ATTRIBUTE_NUMERIC_MEMBER',null)
237: INTO v_attr_dimension_id, v_attr_value_column_name
238: FROM fem_xdim_dimensions
239: WHERE dimension_id IN (SELECT dimension_id FROM fem_dimensions_b
240: WHERE dimension_varchar_label = p_attr_dimension_varchar_label);
241: EXCEPTION
242: WHEN no_data_found THEN

Line 552: FROM fem_xdim_dimensions

548: INTO v_attr_tab,
549: v_mem_b_tab,
550: v_mem_col,
551: v_vs_req_flg
552: FROM fem_xdim_dimensions
553: WHERE dimension_id = v_dim_id;
554:
555: ------------------------------------------
556: -- Verify that the Dimension is attributed

Line 738: FROM fem_xdim_dimensions

734: member_display_code_col
735: INTO v_mem_b_tab,
736: v_mem_col,
737: v_mem_dc_col
738: FROM fem_xdim_dimensions
739: WHERE dimension_id = v_attr_dim_id;
740:
741: --------------------------------------------------
742: -- Get the Attribute assigned value's Display Code

Line 1045: FROM fem_xdim_dimensions

1041: INTO v_attr_tab,
1042: v_mem_b_tab,
1043: v_mem_col,
1044: v_vs_req_flg
1045: FROM fem_xdim_dimensions
1046: WHERE dimension_id = v_dim_id;
1047:
1048: ------------------------------------------
1049: -- Verify that the Dimension is attributed

Line 1456: FROM fem_xdim_dimensions

1452: -- Verify that the Dimension is attributed
1453: ------------------------------------------
1454: SELECT attribute_table_name
1455: INTO v_attr_tab
1456: FROM fem_xdim_dimensions
1457: WHERE dimension_id = v_dim_id;
1458:
1459: IF (v_attr_tab IS NULL)
1460: THEN

Line 1679: FROM fem_xdim_dimensions

1675: -- Verify that the Dimension is attributed
1676: ------------------------------------------
1677: SELECT attribute_table_name
1678: INTO v_attr_tab
1679: FROM fem_xdim_dimensions
1680: WHERE dimension_id = v_dim_id;
1681:
1682: IF (v_attr_tab IS NULL)
1683: THEN