eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FEM_DIMENSION_UTIL_PKG dependencies on FEM_XDIM_DIMENSIONS

Line 271: FROM fem_xdim_dimensions

267: BEGIN
268:
269: SELECT dimension_id
270: INTO v_dimension_id
271: FROM fem_xdim_dimensions
272: WHERE dimension_id = p_dimension_id;
273:
274: RETURN 'Y';
275:

Line 694: FROM fem_xdim_dimensions

690: BEGIN
691:
692: SELECT count(*)
693: INTO v_count
694: FROM fem_xdim_dimensions
695: WHERE dimension_id = p_dimension_id;
696:
697: IF v_count > 0 THEN
698: v_vsr_flag := 'Y';

Line 2243: FROM fem_xdim_dimensions

2239:
2240: BEGIN
2241: SELECT member_id_source_code
2242: INTO v_source_cd
2243: FROM fem_xdim_dimensions
2244: WHERE dimension_id = p_dim_id
2245: AND member_id_method_code = 'FUNCTION';
2246: EXCEPTION
2247: WHEN no_data_found THEN

Line 2321: FROM fem_xdim_dimensions

2317:
2318: BEGIN
2319: SELECT member_id_source_code
2320: INTO v_source_cd
2321: FROM fem_xdim_dimensions
2322: WHERE dimension_id = p_dim_id
2323: AND member_id_method_code = 'FUNCTION';
2324: EXCEPTION
2325: WHEN no_data_found THEN

Line 2449: FROM fem_xdim_dimensions

2445:
2446: BEGIN
2447: SELECT member_id_source_code
2448: INTO v_source_cd
2449: FROM fem_xdim_dimensions
2450: WHERE dimension_id = p_dim_id
2451: AND member_id_method_code = 'FUNCTION';
2452: EXCEPTION
2453: WHEN no_data_found THEN

Line 3039: populate the dimensions metadata (FEM_XDIM_DIMENSIONS) with the

3035: default members for all dimensions that can be defaulted. For each
3036: Value Set Required (VSR) dimension, this version will populate all
3037: dimension value sets (FEM_VALUE_SETS_B) with the newly created
3038: default member. For each non-VSR dimension, this version will
3039: populate the dimensions metadata (FEM_XDIM_DIMENSIONS) with the
3040: default member display code.
3041:
3042: When each member is created, the procedure also creates the
3043: assignments for any required attributes of the dimension.

Line 3075: v_member_b_tab FEM_XDIM_DIMENSIONS.member_b_table_name%TYPE;

3071: v_member_dc VARCHAR2(250);
3072: v_member_name VARCHAR2(150);
3073: v_member_desc VARCHAR2(255);
3074: v_dim_id FEM_DIMENSIONS_B.dimension_id%TYPE;
3075: v_member_b_tab FEM_XDIM_DIMENSIONS.member_b_table_name%TYPE;
3076: v_member_col FEM_XDIM_DIMENSIONS.member_col%TYPE;
3077: v_member_dc_col FEM_XDIM_DIMENSIONS.member_display_code_col%TYPE;
3078: v_member_name_col FEM_XDIM_DIMENSIONS.member_name_col%TYPE;
3079: v_member_desc_col FEM_XDIM_DIMENSIONS.member_description_col%TYPE;

Line 3076: v_member_col FEM_XDIM_DIMENSIONS.member_col%TYPE;

3072: v_member_name VARCHAR2(150);
3073: v_member_desc VARCHAR2(255);
3074: v_dim_id FEM_DIMENSIONS_B.dimension_id%TYPE;
3075: v_member_b_tab FEM_XDIM_DIMENSIONS.member_b_table_name%TYPE;
3076: v_member_col FEM_XDIM_DIMENSIONS.member_col%TYPE;
3077: v_member_dc_col FEM_XDIM_DIMENSIONS.member_display_code_col%TYPE;
3078: v_member_name_col FEM_XDIM_DIMENSIONS.member_name_col%TYPE;
3079: v_member_desc_col FEM_XDIM_DIMENSIONS.member_description_col%TYPE;
3080: v_member_data_type_code FEM_XDIM_DIMENSIONS.member_data_type_code%TYPE;

Line 3077: v_member_dc_col FEM_XDIM_DIMENSIONS.member_display_code_col%TYPE;

3073: v_member_desc VARCHAR2(255);
3074: v_dim_id FEM_DIMENSIONS_B.dimension_id%TYPE;
3075: v_member_b_tab FEM_XDIM_DIMENSIONS.member_b_table_name%TYPE;
3076: v_member_col FEM_XDIM_DIMENSIONS.member_col%TYPE;
3077: v_member_dc_col FEM_XDIM_DIMENSIONS.member_display_code_col%TYPE;
3078: v_member_name_col FEM_XDIM_DIMENSIONS.member_name_col%TYPE;
3079: v_member_desc_col FEM_XDIM_DIMENSIONS.member_description_col%TYPE;
3080: v_member_data_type_code FEM_XDIM_DIMENSIONS.member_data_type_code%TYPE;
3081: v_group_use_code FEM_XDIM_DIMENSIONS.group_use_code%TYPE;

Line 3078: v_member_name_col FEM_XDIM_DIMENSIONS.member_name_col%TYPE;

3074: v_dim_id FEM_DIMENSIONS_B.dimension_id%TYPE;
3075: v_member_b_tab FEM_XDIM_DIMENSIONS.member_b_table_name%TYPE;
3076: v_member_col FEM_XDIM_DIMENSIONS.member_col%TYPE;
3077: v_member_dc_col FEM_XDIM_DIMENSIONS.member_display_code_col%TYPE;
3078: v_member_name_col FEM_XDIM_DIMENSIONS.member_name_col%TYPE;
3079: v_member_desc_col FEM_XDIM_DIMENSIONS.member_description_col%TYPE;
3080: v_member_data_type_code FEM_XDIM_DIMENSIONS.member_data_type_code%TYPE;
3081: v_group_use_code FEM_XDIM_DIMENSIONS.group_use_code%TYPE;
3082: v_attr_tab FEM_XDIM_DIMENSIONS.attribute_table_name%TYPE;

Line 3079: v_member_desc_col FEM_XDIM_DIMENSIONS.member_description_col%TYPE;

3075: v_member_b_tab FEM_XDIM_DIMENSIONS.member_b_table_name%TYPE;
3076: v_member_col FEM_XDIM_DIMENSIONS.member_col%TYPE;
3077: v_member_dc_col FEM_XDIM_DIMENSIONS.member_display_code_col%TYPE;
3078: v_member_name_col FEM_XDIM_DIMENSIONS.member_name_col%TYPE;
3079: v_member_desc_col FEM_XDIM_DIMENSIONS.member_description_col%TYPE;
3080: v_member_data_type_code FEM_XDIM_DIMENSIONS.member_data_type_code%TYPE;
3081: v_group_use_code FEM_XDIM_DIMENSIONS.group_use_code%TYPE;
3082: v_attr_tab FEM_XDIM_DIMENSIONS.attribute_table_name%TYPE;
3083: v_vsr_flag FEM_XDIM_DIMENSIONS.value_set_required_flag%TYPE;

Line 3080: v_member_data_type_code FEM_XDIM_DIMENSIONS.member_data_type_code%TYPE;

3076: v_member_col FEM_XDIM_DIMENSIONS.member_col%TYPE;
3077: v_member_dc_col FEM_XDIM_DIMENSIONS.member_display_code_col%TYPE;
3078: v_member_name_col FEM_XDIM_DIMENSIONS.member_name_col%TYPE;
3079: v_member_desc_col FEM_XDIM_DIMENSIONS.member_description_col%TYPE;
3080: v_member_data_type_code FEM_XDIM_DIMENSIONS.member_data_type_code%TYPE;
3081: v_group_use_code FEM_XDIM_DIMENSIONS.group_use_code%TYPE;
3082: v_attr_tab FEM_XDIM_DIMENSIONS.attribute_table_name%TYPE;
3083: v_vsr_flag FEM_XDIM_DIMENSIONS.value_set_required_flag%TYPE;
3084: v_default_member_dc FEM_XDIM_DIMENSIONS.default_member_display_code%TYPE;

Line 3081: v_group_use_code FEM_XDIM_DIMENSIONS.group_use_code%TYPE;

3077: v_member_dc_col FEM_XDIM_DIMENSIONS.member_display_code_col%TYPE;
3078: v_member_name_col FEM_XDIM_DIMENSIONS.member_name_col%TYPE;
3079: v_member_desc_col FEM_XDIM_DIMENSIONS.member_description_col%TYPE;
3080: v_member_data_type_code FEM_XDIM_DIMENSIONS.member_data_type_code%TYPE;
3081: v_group_use_code FEM_XDIM_DIMENSIONS.group_use_code%TYPE;
3082: v_attr_tab FEM_XDIM_DIMENSIONS.attribute_table_name%TYPE;
3083: v_vsr_flag FEM_XDIM_DIMENSIONS.value_set_required_flag%TYPE;
3084: v_default_member_dc FEM_XDIM_DIMENSIONS.default_member_display_code%TYPE;
3085: v_member_id_method_code FEM_XDIM_DIMENSIONS.member_id_method_code%TYPE;

Line 3082: v_attr_tab FEM_XDIM_DIMENSIONS.attribute_table_name%TYPE;

3078: v_member_name_col FEM_XDIM_DIMENSIONS.member_name_col%TYPE;
3079: v_member_desc_col FEM_XDIM_DIMENSIONS.member_description_col%TYPE;
3080: v_member_data_type_code FEM_XDIM_DIMENSIONS.member_data_type_code%TYPE;
3081: v_group_use_code FEM_XDIM_DIMENSIONS.group_use_code%TYPE;
3082: v_attr_tab FEM_XDIM_DIMENSIONS.attribute_table_name%TYPE;
3083: v_vsr_flag FEM_XDIM_DIMENSIONS.value_set_required_flag%TYPE;
3084: v_default_member_dc FEM_XDIM_DIMENSIONS.default_member_display_code%TYPE;
3085: v_member_id_method_code FEM_XDIM_DIMENSIONS.member_id_method_code%TYPE;
3086: v_default_load_member_id FEM_VALUE_SETS_B.default_load_member_id%TYPE;

Line 3083: v_vsr_flag FEM_XDIM_DIMENSIONS.value_set_required_flag%TYPE;

3079: v_member_desc_col FEM_XDIM_DIMENSIONS.member_description_col%TYPE;
3080: v_member_data_type_code FEM_XDIM_DIMENSIONS.member_data_type_code%TYPE;
3081: v_group_use_code FEM_XDIM_DIMENSIONS.group_use_code%TYPE;
3082: v_attr_tab FEM_XDIM_DIMENSIONS.attribute_table_name%TYPE;
3083: v_vsr_flag FEM_XDIM_DIMENSIONS.value_set_required_flag%TYPE;
3084: v_default_member_dc FEM_XDIM_DIMENSIONS.default_member_display_code%TYPE;
3085: v_member_id_method_code FEM_XDIM_DIMENSIONS.member_id_method_code%TYPE;
3086: v_default_load_member_id FEM_VALUE_SETS_B.default_load_member_id%TYPE;
3087: v_member_pkg VARCHAR2(30);

Line 3084: v_default_member_dc FEM_XDIM_DIMENSIONS.default_member_display_code%TYPE;

3080: v_member_data_type_code FEM_XDIM_DIMENSIONS.member_data_type_code%TYPE;
3081: v_group_use_code FEM_XDIM_DIMENSIONS.group_use_code%TYPE;
3082: v_attr_tab FEM_XDIM_DIMENSIONS.attribute_table_name%TYPE;
3083: v_vsr_flag FEM_XDIM_DIMENSIONS.value_set_required_flag%TYPE;
3084: v_default_member_dc FEM_XDIM_DIMENSIONS.default_member_display_code%TYPE;
3085: v_member_id_method_code FEM_XDIM_DIMENSIONS.member_id_method_code%TYPE;
3086: v_default_load_member_id FEM_VALUE_SETS_B.default_load_member_id%TYPE;
3087: v_member_pkg VARCHAR2(30);
3088:

Line 3085: v_member_id_method_code FEM_XDIM_DIMENSIONS.member_id_method_code%TYPE;

3081: v_group_use_code FEM_XDIM_DIMENSIONS.group_use_code%TYPE;
3082: v_attr_tab FEM_XDIM_DIMENSIONS.attribute_table_name%TYPE;
3083: v_vsr_flag FEM_XDIM_DIMENSIONS.value_set_required_flag%TYPE;
3084: v_default_member_dc FEM_XDIM_DIMENSIONS.default_member_display_code%TYPE;
3085: v_member_id_method_code FEM_XDIM_DIMENSIONS.member_id_method_code%TYPE;
3086: v_default_load_member_id FEM_VALUE_SETS_B.default_load_member_id%TYPE;
3087: v_member_pkg VARCHAR2(30);
3088:
3089: -- This cursor retrieves all of the required attributes

Line 3195: FROM fem_xdim_dimensions x, fem_dimensions_b d

3191: v_vsr_flag,
3192: v_member_id_method_code,
3193: v_default_member_dc,
3194: v_member_pkg
3195: FROM fem_xdim_dimensions x, fem_dimensions_b d
3196: WHERE d.dimension_varchar_label = p_dim_label
3197: AND x.read_only_flag = 'N'
3198: AND x.composite_dimension_flag = 'N'
3199: AND x.hier_editor_managed_flag = 'Y'

Line 3526: UPDATE fem_xdim_dimensions

3522: END IF;
3523: END IF;
3524: ELSE
3525: IF v_default_member_dc IS NULL THEN
3526: UPDATE fem_xdim_dimensions
3527: SET default_member_display_code = (v_member_dc),
3528: last_update_date = sysdate,
3529: last_updated_by = c_user_id
3530: WHERE dimension_id = v_dim_id;

Line 3536: p_msg_text => 'Updated FEM_XDIM_DIMENSIONS.default_member_display_code = '

3532: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3533: FEM_ENGINES_PKG.TECH_MESSAGE(
3534: p_severity => FND_LOG.level_statement,
3535: p_module => C_MODULE,
3536: p_msg_text => 'Updated FEM_XDIM_DIMENSIONS.default_member_display_code = '
3537: ||v_member_dc);
3538: END IF;
3539: END IF;
3540: END IF; -- v_vsr_flag = 'Y'

Line 3805: FROM fem_xdim_dimensions x, fem_dimensions_b d

3801: CURSOR c_dims IS
3802: SELECT d.dimension_id,
3803: d.dimension_varchar_label,
3804: x.value_set_required_flag
3805: FROM fem_xdim_dimensions x, fem_dimensions_b d
3806: WHERE x.dimension_id = d.dimension_id
3807: AND x.read_only_flag = 'N'
3808: AND x.composite_dimension_flag = 'N'
3809: AND x.hier_editor_managed_flag = 'Y'

Line 4176: FROM fem_xdim_dimensions

4172: SELECT member_b_table_name,
4173: member_col
4174: INTO v_xdim_tab,
4175: v_xdim_col
4176: FROM fem_xdim_dimensions
4177: WHERE dimension_id = v_xdim_id;
4178:
4179: v_sql_cmd :=
4180: 'SELECT '||v_xdim_col||

Line 4647: FROM fem_xdim_dimensions

4643: SELECT member_b_table_name,
4644: member_col
4645: INTO v_xdim_tab,
4646: v_xdim_col
4647: FROM fem_xdim_dimensions
4648: WHERE dimension_id = v_xdim_id;
4649:
4650: v_sql_cmd :=
4651: 'SELECT '||v_xdim_col||

Line 5184: FROM fem_xdim_dimensions

5180: SELECT member_b_table_name,
5181: member_col
5182: INTO v_xdim_tab,
5183: v_xdim_col
5184: FROM fem_xdim_dimensions
5185: WHERE dimension_id = v_xdim_id;
5186:
5187: v_sql_cmd :=
5188: 'SELECT '||v_xdim_col||

Line 5721: FROM fem_xdim_dimensions

5717: SELECT member_b_table_name,
5718: member_col
5719: INTO v_xdim_tab,
5720: v_xdim_col
5721: FROM fem_xdim_dimensions
5722: WHERE dimension_id = v_xdim_id;
5723:
5724: v_sql_cmd :=
5725: 'SELECT '||v_xdim_col||

Line 6315: FROM fem_xdim_dimensions

6311: member_display_code_col
6312: INTO v_attr_member_tab,
6313: v_attr_member_col,
6314: v_attr_member_dc_col
6315: FROM fem_xdim_dimensions
6316: WHERE dimension_id = attr.attribute_dimension_id;
6317:
6318: v_sql_stmt :=
6319: 'SELECT '||v_attr_member_col||

Line 6802: FROM fem_xdim_dimensions

6798: member_display_code_col
6799: INTO v_attr_member_tab,
6800: v_attr_member_col,
6801: v_attr_member_dc_col
6802: FROM fem_xdim_dimensions
6803: WHERE dimension_id = attr.attribute_dimension_id;
6804:
6805: v_sql_stmt :=
6806: 'SELECT '||v_attr_member_col||

Line 7280: FROM fem_xdim_dimensions

7276: SELECT member_b_table_name,
7277: member_col
7278: INTO v_xdim_tab,
7279: v_xdim_col
7280: FROM fem_xdim_dimensions
7281: WHERE dimension_id = v_xdim_id;
7282:
7283: v_sql_cmd :=
7284: 'SELECT '||v_xdim_col||

Line 7776: FROM fem_xdim_dimensions

7772: SELECT member_b_table_name,
7773: member_col
7774: INTO v_xdim_tab,
7775: v_xdim_col
7776: FROM fem_xdim_dimensions
7777: WHERE dimension_id = v_xdim_id;
7778:
7779: v_sql_cmd :=
7780: 'SELECT '||v_xdim_col||

Line 8254: FROM fem_xdim_dimensions

8250: SELECT member_b_table_name,
8251: member_col
8252: INTO v_xdim_tab,
8253: v_xdim_col
8254: FROM fem_xdim_dimensions
8255: WHERE dimension_id = v_xdim_id;
8256:
8257: v_sql_cmd :=
8258: 'SELECT '||v_xdim_col||

Line 8569: FROM fem_xdim_dimensions_vl

8565: -- Cursor to get dimensions that require Value Sets
8566: ---------------------------------------------------
8567: CURSOR c_vs_dim_ids IS
8568: SELECT dimension_id, dimension_varchar_label
8569: FROM fem_xdim_dimensions_vl
8570: WHERE value_set_required_flag = 'Y'
8571: ORDER BY dimension_id;
8572:
8573: BEGIN

Line 8831: FROM fem_xdim_dimensions

8827: v_mem_col,
8828: v_mem_dc_col,
8829: v_vs_req_flg,
8830: v_comp_dim_flg
8831: FROM fem_xdim_dimensions
8832: WHERE dimension_id = v_dim_id;
8833:
8834: ---------------------------------
8835: -- Verify the specified Value Set

Line 9214: (from FEM_XDIM_DIMENSIONS.MEMBER_DATA_TYPE_CODE)

9210:
9211: Return variables:
9212: x_member_code - Member ID/Code
9213: x_member_data_type - Member ID/Code Data Type
9214: (from FEM_XDIM_DIMENSIONS.MEMBER_DATA_TYPE_CODE)
9215: x_member_display_code - Member Display Code
9216: x_return_status
9217: - FND_API.G_RET_STS_SUCCESS ('S') if default member was found
9218: - FND_API.G_RET_STS_ERROR ('E') if no default member exists

Line 9247: v_member_table FEM_XDIM_DIMENSIONS.member_b_table_name%TYPE;

9243: C_API_NAME CONSTANT VARCHAR2(30) := 'Get_Default_Dim_Member';
9244: e_no_member EXCEPTION;
9245:
9246: v_dim_id FEM_DIMENSIONS_B.dimension_id%TYPE;
9247: v_member_table FEM_XDIM_DIMENSIONS.member_b_table_name%TYPE;
9248: v_member_col FEM_XDIM_DIMENSIONS.member_col%TYPE;
9249: v_member_dc_col FEM_XDIM_DIMENSIONS.member_display_code_col%TYPE;
9250: v_vsr_flag FEM_XDIM_DIMENSIONS.value_set_required_flag%TYPE;
9251: v_default_member_dc FEM_XDIM_DIMENSIONS.default_member_display_code%TYPE;

Line 9248: v_member_col FEM_XDIM_DIMENSIONS.member_col%TYPE;

9244: e_no_member EXCEPTION;
9245:
9246: v_dim_id FEM_DIMENSIONS_B.dimension_id%TYPE;
9247: v_member_table FEM_XDIM_DIMENSIONS.member_b_table_name%TYPE;
9248: v_member_col FEM_XDIM_DIMENSIONS.member_col%TYPE;
9249: v_member_dc_col FEM_XDIM_DIMENSIONS.member_display_code_col%TYPE;
9250: v_vsr_flag FEM_XDIM_DIMENSIONS.value_set_required_flag%TYPE;
9251: v_default_member_dc FEM_XDIM_DIMENSIONS.default_member_display_code%TYPE;
9252: v_vs_id FEM_VALUE_SETS_B.value_set_id%TYPE;

Line 9249: v_member_dc_col FEM_XDIM_DIMENSIONS.member_display_code_col%TYPE;

9245:
9246: v_dim_id FEM_DIMENSIONS_B.dimension_id%TYPE;
9247: v_member_table FEM_XDIM_DIMENSIONS.member_b_table_name%TYPE;
9248: v_member_col FEM_XDIM_DIMENSIONS.member_col%TYPE;
9249: v_member_dc_col FEM_XDIM_DIMENSIONS.member_display_code_col%TYPE;
9250: v_vsr_flag FEM_XDIM_DIMENSIONS.value_set_required_flag%TYPE;
9251: v_default_member_dc FEM_XDIM_DIMENSIONS.default_member_display_code%TYPE;
9252: v_vs_id FEM_VALUE_SETS_B.value_set_id%TYPE;
9253: v_default_member FEM_XDIM_DIMENSIONS.default_member_display_code%TYPE;

Line 9250: v_vsr_flag FEM_XDIM_DIMENSIONS.value_set_required_flag%TYPE;

9246: v_dim_id FEM_DIMENSIONS_B.dimension_id%TYPE;
9247: v_member_table FEM_XDIM_DIMENSIONS.member_b_table_name%TYPE;
9248: v_member_col FEM_XDIM_DIMENSIONS.member_col%TYPE;
9249: v_member_dc_col FEM_XDIM_DIMENSIONS.member_display_code_col%TYPE;
9250: v_vsr_flag FEM_XDIM_DIMENSIONS.value_set_required_flag%TYPE;
9251: v_default_member_dc FEM_XDIM_DIMENSIONS.default_member_display_code%TYPE;
9252: v_vs_id FEM_VALUE_SETS_B.value_set_id%TYPE;
9253: v_default_member FEM_XDIM_DIMENSIONS.default_member_display_code%TYPE;
9254: v_sql VARCHAR2(4000);

Line 9251: v_default_member_dc FEM_XDIM_DIMENSIONS.default_member_display_code%TYPE;

9247: v_member_table FEM_XDIM_DIMENSIONS.member_b_table_name%TYPE;
9248: v_member_col FEM_XDIM_DIMENSIONS.member_col%TYPE;
9249: v_member_dc_col FEM_XDIM_DIMENSIONS.member_display_code_col%TYPE;
9250: v_vsr_flag FEM_XDIM_DIMENSIONS.value_set_required_flag%TYPE;
9251: v_default_member_dc FEM_XDIM_DIMENSIONS.default_member_display_code%TYPE;
9252: v_vs_id FEM_VALUE_SETS_B.value_set_id%TYPE;
9253: v_default_member FEM_XDIM_DIMENSIONS.default_member_display_code%TYPE;
9254: v_sql VARCHAR2(4000);
9255:

Line 9253: v_default_member FEM_XDIM_DIMENSIONS.default_member_display_code%TYPE;

9249: v_member_dc_col FEM_XDIM_DIMENSIONS.member_display_code_col%TYPE;
9250: v_vsr_flag FEM_XDIM_DIMENSIONS.value_set_required_flag%TYPE;
9251: v_default_member_dc FEM_XDIM_DIMENSIONS.default_member_display_code%TYPE;
9252: v_vs_id FEM_VALUE_SETS_B.value_set_id%TYPE;
9253: v_default_member FEM_XDIM_DIMENSIONS.default_member_display_code%TYPE;
9254: v_sql VARCHAR2(4000);
9255:
9256: BEGIN
9257:

Line 9350: FROM fem_xdim_dimensions

9346: v_member_dc_col,
9347: x_member_data_type,
9348: v_vsr_flag,
9349: v_default_member_dc
9350: FROM fem_xdim_dimensions
9351: WHERE dimension_id = v_dim_id;
9352:
9353: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
9354: FEM_ENGINES_PKG.TECH_MESSAGE(

Line 9370: p_msg_text => 'Dimension is not registered in FEM_DIMENSIONS_B or FEM_XDIM_DIMENSIONS');

9366: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
9367: FEM_ENGINES_PKG.TECH_MESSAGE(
9368: p_severity => FND_LOG.level_statement,
9369: p_module => C_MODULE,
9370: p_msg_text => 'Dimension is not registered in FEM_DIMENSIONS_B or FEM_XDIM_DIMENSIONS');
9371: END IF;
9372: RAISE e_unexp;
9373: END;
9374:

Line 9553: (from FEM_XDIM_DIMENSIONS.MEMBER_DATA_TYPE_CODE)

9549:
9550: Return variables:
9551: x_member_code - Member ID/Code
9552: x_member_data_type - Member ID/Code Data Type
9553: (from FEM_XDIM_DIMENSIONS.MEMBER_DATA_TYPE_CODE)
9554: x_member_display_code - Member Display Code
9555: x_return_status
9556: - FND_API.G_RET_STS_SUCCESS ('S') if default member was found
9557: - FND_API.G_RET_STS_ERROR ('E') if no default member exists

Line 9768: FROM fem_xdim_dimensions

9764: INTO v_mem_b_tab,
9765: v_mem_col,
9766: v_mem_dc_col,
9767: v_vs_req_flg
9768: FROM fem_xdim_dimensions
9769: WHERE dimension_id = v_dim_id;
9770:
9771: ---------------------------------
9772: -- Verify the specified Value Set

Line 9891: FROM fem_xdim_dimensions

9887: INTO v_mem_vl_tab,
9888: v_mem_col,
9889: v_mem_name_col,
9890: v_vs_req_flg
9891: FROM fem_xdim_dimensions
9892: WHERE dimension_id = v_dim_id;
9893:
9894: ---------------------------------
9895: -- Verify the specified Value Set