APPS.GCS_WEBADI_PKG dependencies on FEM_XDIM_DIMENSIONS

Line 37: FROM fem_xdim_dimensions fxd, fem_dimensions_b fdb

33: fxd.MEMBER_NAME_COL,
34: fdb.dimension_id,
35: fxd.LOADER_OBJECT_DEF_ID
36: BULK COLLECT INTO l_index_dimension_info
37: FROM fem_xdim_dimensions fxd, fem_dimensions_b fdb
38: WHERE fxd.dimension_id = fdb.dimension_id
39: AND fxd.member_col IN
40: ('COMPANY_COST_CENTER_ORG_ID', 'FINANCIAL_ELEM_ID', 'PRODUCT_ID',
41: 'NATURAL_ACCOUNT_ID', 'CHANNEL_ID', 'LINE_ITEM_ID', 'PROJECT_ID',

Line 475: FROM fem_xdim_dimensions fxd

471: INTO l_index_dim_info
472: FROM (SELECT fxd.member_col,
473: fxd.member_name_col,
474: fxd.MEMBER_TL_TABLE_NAME
475: FROM fem_xdim_dimensions fxd
476: WHERE fxd.member_col IN
477: ('COMPANY_COST_CENTER_ORG_ID', 'FINANCIAL_ELEM_ID',
478: 'PRODUCT_ID', 'NATURAL_ACCOUNT_ID', 'CHANNEL_ID',
479: 'LINE_ITEM_ID', 'PROJECT_ID', 'CUSTOMER_ID', 'TASK_ID',

Line 1271: FROM fem_xdim_dimensions fxd, fem_dim_attributes_b fdab

1267: SELECT fdab.attribute_id, fxd.member_display_code_col, fxd.member_b_table_name,
1268: fxd.member_col, fdab.default_assignment, fdab.attribute_varchar_label
1269: BULK COLLECT INTO l_attribute_id_list, l_member_display_code_list, l_member_b_table_list,
1270: l_member_col_list, l_default_assign_list, l_attr_varchar_list
1271: FROM fem_xdim_dimensions fxd, fem_dim_attributes_b fdab
1272: WHERE fxd.dimension_id (+)= fdab.attribute_dimension_id
1273: AND fdab.dimension_id = g_dimension_info(p_dimension_varchar_label).dimension_id
1274: AND fdab.attribute_required_flag = 'Y';
1275:

Line 1396: FROM fem_xdim_dimensions fxd

1392: SELECT fxd.member_tl_table_name ,
1393: fxd.attribute_table_name
1394: INTO l_member_tl_table_name,
1395: l_member_attr_table_name
1396: FROM fem_xdim_dimensions fxd
1397: WHERE fxd.dimension_id = g_dimension_info(p_dimension_varchar_label).dimension_id ;
1398:
1399: FND_MESSAGE.set_name( 'GCS', 'GCS_DM_IMPORT_FEM_LDR_ERR' );
1400: FND_MESSAGE.set_token( 'DIM_B_TABLE' , g_dimension_info(p_dimension_varchar_label).b_table_name );

Line 1815: UPDATE fem_xdim_dimensions fxd

1811: AND foct.object_id = fh.hierarchy_obj_id
1812: AND gso.fch_global_vs_combo_id = fgvcd.global_vs_combo_id
1813: AND fgvcd.dimension_id = fh.dimension_id;
1814:
1815: UPDATE fem_xdim_dimensions fxd
1816: SET default_mvs_hierarchy_obj_id = l_object_id
1817: WHERE dimension_id = l_dimension_id;
1818:
1819: gcs_cons_impact_analysis_pkg.value_set_map_updated( p_dimension_id => l_dimension_id,