APPS.FEM_ADMIN_UTIL_PKG dependencies on FEM_XDIM_DIMENSIONS

Line 382: v_vsr_flag FEM_XDIM_DIMENSIONS.value_set_required_flag%TYPE;

378: v_col_name ALL_TAB_COLUMNS.column_name%TYPE;
379: v_obj_name FND_LOOKUP_VALUES.meaning%TYPE;
380: v_col_prop_cd FEM_TAB_COLUMN_PROP.column_property_code%TYPE;
381: v_msg_name FND_NEW_MESSAGES.message_name%TYPE;
382: v_vsr_flag FEM_XDIM_DIMENSIONS.value_set_required_flag%TYPE;
383: v_count NUMBER;
384: v_vsr_count NUMBER;
385: v_passed_valid VARCHAR2(1);
386: BEGIN

Line 520: ||' FROM fem_tab_columns_b t, fem_xdim_dimensions x'

516: IF v_passed_valid = c_true AND
517: p_col_req_type NOT IN ('FIXED_ANY','ONE_ANY') THEN
518:
519: v_sql := 'SELECT t.column_name, nvl(x.value_set_required_flag,''N'')'
520: ||' FROM fem_tab_columns_b t, fem_xdim_dimensions x'
521: ||' WHERE t.dimension_id = x.dimension_id(+)'
522: ||' AND t.table_name = :1'
523: ||' AND enabled_flag = ''Y'''
524: ||' AND t.column_name NOT IN '

Line 1178: FROM fem_xdim_dimensions_vl

1174: v_surrogate_key_flag := '';
1175: IF col.fem_data_type_code = 'DIMENSION' THEN
1176: SELECT member_b_table_name, member_col, member_display_code_col, dimension_varchar_label
1177: INTO v_dim_mbr_table, v_dim_mbr_col, v_dim_mbr_dc_col, v_dim_label
1178: FROM fem_xdim_dimensions_vl
1179: WHERE dimension_id = col.dimension_id;
1180:
1181: IF v_dim_mbr_col = v_dim_mbr_dc_col THEN
1182: v_surrogate_key_flag := 'N';

Line 2090: FROM fem_xdim_dimensions_vl

2086: -- dimension
2087: FOR col IN c_dimcol (p_tab_name) LOOP
2088: SELECT count(*)
2089: INTO v_count
2090: FROM fem_xdim_dimensions_vl
2091: WHERE dimension_id = col.dimension_id
2092: AND value_set_required_flag = 'Y'
2093: AND dimension_varchar_label not in ('COMPANY','COST_CENTER');
2094: