APPS.FEM_DIM_ATTRIBUTES_UTIL_PKG dependencies on FEM_DIMENSIONS_B

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 239: WHERE dimension_id IN (SELECT dimension_id FROM fem_dimensions_b

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
243: RAISE e_invalid_attr_dimension;

Line 534: FROM fem_dimensions_b

530: ---------------------------------
531: BEGIN
532: SELECT dimension_id
533: INTO v_dim_id
534: FROM fem_dimensions_b
535: WHERE dimension_varchar_label = p_dimension_varchar_label;
536: EXCEPTION
537: WHEN no_data_found THEN
538: RAISE e_bad_dim_label;

Line 1027: FROM fem_dimensions_b

1023: ---------------------------------
1024: BEGIN
1025: SELECT dimension_id
1026: INTO v_dim_id
1027: FROM fem_dimensions_b
1028: WHERE dimension_varchar_label = p_dimension_varchar_label;
1029: EXCEPTION
1030: WHEN no_data_found THEN
1031: RAISE e_bad_dim_label;

Line 1444: FROM fem_dimensions_b

1440: ---------------------------------
1441: BEGIN
1442: SELECT dimension_id
1443: INTO v_dim_id
1444: FROM fem_dimensions_b
1445: WHERE dimension_varchar_label = p_dimension_varchar_label;
1446: EXCEPTION
1447: WHEN no_data_found THEN
1448: RAISE e_bad_dim_label;

Line 1667: FROM fem_dimensions_b

1663: ---------------------------------
1664: BEGIN
1665: SELECT dimension_id
1666: INTO v_dim_id
1667: FROM fem_dimensions_b
1668: WHERE dimension_varchar_label = p_dimension_varchar_label;
1669: EXCEPTION
1670: WHEN no_data_found THEN
1671: RAISE e_bad_dim_label;