APPS.FEM_MAPPING_PREVIEW_UTIL_PKG dependencies on FEM_ALLOC_BR_DIMENSIONS

Line 1747: v_by_dimension_column FEM_ALLOC_BR_DIMENSIONS.alloc_dim_col_name%TYPE;

1743: v_query_row_limit FEM_ALLOC_PREVIEWS.query_row_limit%TYPE;
1744: v_stat_obj_def_id FEM_OBJECT_DEFINITION_B.object_definition_id%TYPE;
1745: v_stat_cond_obj_def_id FEM_STAT_LOOKUPS.condition_obj_def_id%TYPE;
1746: v_preview_cond_obj_id FEM_ALLOC_PREVIEWS.source_condition_obj_id%TYPE;
1747: v_by_dimension_column FEM_ALLOC_BR_DIMENSIONS.alloc_dim_col_name%TYPE;
1748: v_by_dimension_id FEM_DIMENSIONS_B.dimension_id%TYPE;
1749: v_by_dimension_value VARCHAR2(38); -- max size of number
1750: --
1751: CURSOR c_stat_cols (cv_stat_obj_def_id NUMBER) IS

Line 2028: FROM fem_alloc_br_dimensions

2024: --
2025: CURSOR c_value_cols (cv_map_obj_def_id NUMBER, cv_function_cd VARCHAR2) IS
2026: SELECT alloc_dim_col_name, nvl(to_char(dimension_value),
2027: dimension_value_char) dim_value
2028: FROM fem_alloc_br_dimensions
2029: WHERE object_definition_id = cv_map_obj_def_id
2030: AND function_cd = cv_function_cd
2031: AND alloc_dim_usage_code = 'VALUE';
2032:

Line 2043: FROM fem_alloc_br_dimensions

2039: AND m.table_name = cv_match_fact_table
2040: AND o.column_name = m.column_name
2041: AND o.column_name NOT IN
2042: (SELECT alloc_dim_col_name
2043: FROM fem_alloc_br_dimensions
2044: WHERE object_definition_id = cv_map_obj_def_id
2045: AND function_cd = cv_function_cd
2046: AND alloc_dim_usage_code = 'VALUE');
2047:

Line 2908: -- FEM_ALLOC_BR_DIMENSIONS, FEM_TAB_COLUMNS_B, and FEM_XDIM_DIMENSIONS

2904: -- set all parameters to NULL.
2905: --
2906: -- If mapping rule type is By Dimension and preview group is Source,
2907: -- then get the parameter values from these tables:
2908: -- FEM_ALLOC_BR_DIMENSIONS, FEM_TAB_COLUMNS_B, and FEM_XDIM_DIMENSIONS
2909: --
2910: -------------------------------------------------------------------------------
2911: PROCEDURE GetByDimParams(
2912: p_preview_obj_def_id IN NUMBER,

Line 2945: FROM fem_alloc_br_dimensions abd, fem_tab_columns_b tc,

2941: SELECT abd.alloc_dim_col_name, xd.dimension_id,
2942: decode(xd.member_data_type_code,'NUMBER',abd.dimension_value,
2943: abd.dimension_value_char)
2944: INTO x_by_dimension_column, x_by_dimension_id, x_by_dimension_value
2945: FROM fem_alloc_br_dimensions abd, fem_tab_columns_b tc,
2946: fem_xdim_dimensions xd
2947: WHERE abd.object_definition_id = p_map_obj_def_id
2948: AND abd.function_cd = C_BYDIM_FUNCIONCD
2949: AND tc.table_name = p_fact_table_name