APPS.FEM_SETUP_PKG dependencies on FEM_XDIM_DIMENSIONS

Line 75: fem_xdim_dimensions fxd

71: 'USER_DIM10_ID', DECODE(activity_dim_component_flag,'Y','SEGMENT16','UNKNOWN'),
72: 'UNKNOWN') act_segment_num,
73: vs_member_vl_object_name vs_name
74: FROM fem_column_requiremnt_b fcr,
75: fem_xdim_dimensions fxd
76: WHERE fcr.dimension_id = fxd.dimension_id
77: AND fcr.activity_dim_component_flag = 'Y'
78: ORDER BY act_segment_num; --Bug#4209065
79:

Line 327: fem_xdim_dimensions fxd

323: 'USER_DIM10_ID', DECODE(cost_obj_dim_component_flag,'Y','SEGMENT17','UNKNOWN'),
324: 'UNKNOWN') cost_segment_num,
325: vs_member_vl_object_name vs_name
326: FROM fem_column_requiremnt_b fcr,
327: fem_xdim_dimensions fxd
328: WHERE fcr.dimension_id = fxd.dimension_id
329: AND cost_obj_dim_component_flag = 'Y'
330: ORDER BY cost_segment_num; --Bug#4209065
331:

Line 636: -- Update FEM_XDIM_DIMENSIONS_VL with FLEX_FIELD Information

632: -- End Compile flexfield
633: ------------------------
634:
635: -------------------------------------------------------------
636: -- Update FEM_XDIM_DIMENSIONS_VL with FLEX_FIELD Information
637: -------------------------------------------------------------
638:
639: fem_engines_pkg.tech_message (p_severity => g_log_level_2
640: ,p_module => g_block||'.'||l_api_name

Line 641: ,p_msg_text => 'Updating fem_xdim_dimensions with FF details');

637: -------------------------------------------------------------
638:
639: fem_engines_pkg.tech_message (p_severity => g_log_level_2
640: ,p_module => g_block||'.'||l_api_name
641: ,p_msg_text => 'Updating fem_xdim_dimensions with FF details');
642:
643: IF p_ff_name = 'FEAC' THEN
644: UPDATE fem_xdim_dimensions
645: SET id_flex_num = l_flex_num ,

Line 644: UPDATE fem_xdim_dimensions

640: ,p_module => g_block||'.'||l_api_name
641: ,p_msg_text => 'Updating fem_xdim_dimensions with FF details');
642:
643: IF p_ff_name = 'FEAC' THEN
644: UPDATE fem_xdim_dimensions
645: SET id_flex_num = l_flex_num ,
646: id_flex_structure_code = l_flex_structure_code,
647: id_flex_code= p_ff_name
648: WHERE dimension_id = 10;

Line 650: UPDATE fem_xdim_dimensions

646: id_flex_structure_code = l_flex_structure_code,
647: id_flex_code= p_ff_name
648: WHERE dimension_id = 10;
649: ELSIF p_ff_name = 'FECO' THEN
650: UPDATE fem_xdim_dimensions
651: SET id_flex_num = l_flex_num ,
652: id_flex_structure_code = l_flex_structure_code,
653: id_flex_code= p_ff_name
654: WHERE dimension_id = 11;