DBA Data[Home] [Help]

APPS.FEM_DIM_MEMBER_LOADER_PKG dependencies on FEM_XDIM_DIMENSIONS_VL

Line 7922: FROM fem_xdim_dimensions_vl

7918: ,x_member_id_method_code
7919: ,x_table_handler_name
7920: ,x_composite_dimension_flag --
7921: ,x_structure_id
7922: FROM fem_xdim_dimensions_vl
7923: WHERE dimension_varchar_label = p_dimension_varchar_label;
7924:
7925: IF x_source_b_table = 'FEM_SIMPLE_DIMS_B_T' THEN
7926: x_shared_dimension_flag := 'Y';

Line 13931: FROM Fem_Xdim_Dimensions_VL

13927: BEGIN
13928:
13929: SELECT dimension_active_flag
13930: INTO l_dim_active_flag
13931: FROM Fem_Xdim_Dimensions_VL
13932: WHERE dimension_varchar_label = p_dimension_varchar_label;
13933:
13934: EXCEPTION
13935:

Line 13987: ,FEM_XDIM_DIMENSIONS_VL x

13983: ,x.member_display_code_col
13984: ,x.member_b_table_name
13985: ,x.value_set_required_flag
13986: FROM FEM_COLUMN_REQUIREMNT_VL c
13987: ,FEM_XDIM_DIMENSIONS_VL x
13988: WHERE c.dimension_id = x.dimension_id
13989: AND c.cost_obj_dim_component_flag = 'Y'
13990: ORDER BY 1 )
13991: LOOP

Line 14066: ,FEM_XDIM_DIMENSIONS_VL x

14062: ,x.member_display_code_col
14063: ,x.member_b_table_name
14064: ,x.value_set_required_flag
14065: FROM FEM_COLUMN_REQUIREMNT_VL c
14066: ,FEM_XDIM_DIMENSIONS_VL x
14067: WHERE c.dimension_id = x.dimension_id
14068: AND c.activity_dim_component_flag = 'Y'
14069: ORDER BY 1 )
14070: LOOP

Line 15980: FROM Fem_XDim_Dimensions_VL

15976: BEGIN
15977:
15978: SELECT composite_dimension_flag,id_flex_num
15979: INTO v_composite_dimension_flag,v_structure_id
15980: FROM Fem_XDim_Dimensions_VL
15981: WHERE dimension_varchar_label = p_dimension_varchar_label;
15982:
15983: EXCEPTION
15984:

Line 17033: FROM fem_xdim_dimensions_vl

17029:
17030: BEGIN
17031: SELECT loader_object_def_id, dimension_varchar_label
17032: INTO x_object_definition_id, x_dimension_varchar_label
17033: FROM fem_xdim_dimensions_vl
17034: WHERE dimension_id = p_dimension_id;
17035:
17036: IF x_object_definition_id IS NULL THEN
17037: RAISE e_dim_load_not_enabled;