APPS.FEM_DIMENSION_UTIL_PKG dependencies on FEM_VALUE_SETS_B

Line 3037: dimension value sets (FEM_VALUE_SETS_B) with the newly created

3033:
3034: If called with no API-specific parameters, this version generates
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:

Line 3086: v_default_load_member_id FEM_VALUE_SETS_B.default_load_member_id%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
3090: -- of the dimension of the value set

Line 3216: FROM fem_value_sets_b

3212: IF v_vsr_flag = 'Y' THEN
3213: BEGIN
3214: SELECT default_load_member_id
3215: INTO v_default_load_member_id
3216: FROM fem_value_sets_b
3217: WHERE value_set_id = p_vs_id
3218: AND dimension_id = v_dim_id;
3219: EXCEPTION
3220: WHEN no_data_found THEN

Line 3510: UPDATE fem_value_sets_b

3506:
3507: -- Set the default member if none exists
3508: IF v_vsr_flag = 'Y' THEN
3509: IF v_default_load_member_id IS NULL THEN
3510: UPDATE fem_value_sets_b
3511: SET default_load_member_id = to_number(v_member_code),
3512: last_update_date = sysdate,
3513: last_updated_by = c_user_id
3514: WHERE value_set_id = p_vs_id;

Line 3520: p_msg_text => 'Updated FEM_VALUE_SETS_B.default_load_member_id = '

3516: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3517: FEM_ENGINES_PKG.TECH_MESSAGE(
3518: p_severity => FND_LOG.level_statement,
3519: p_module => C_MODULE,
3520: p_msg_text => 'Updated FEM_VALUE_SETS_B.default_load_member_id = '
3521: ||v_member_code);
3522: END IF;
3523: END IF;
3524: ELSE

Line 3689: FROM fem_value_sets_b V, fem_dimensions_b D

3685: SELECT D.dimension_varchar_label,
3686: V.default_load_member_id
3687: INTO v_dim_label,
3688: v_def_load_id
3689: FROM fem_value_sets_b V, fem_dimensions_b D
3690: WHERE V.value_set_id = p_vs_id
3691: AND V.dimension_id = D.dimension_id;
3692: EXCEPTION
3693: WHEN no_data_found THEN

Line 3816: FROM fem_value_sets_b

3812:
3813: -- All value sets given a dimension
3814: CURSOR c_value_sets (p_dim_id NUMBER) IS
3815: SELECT value_set_id
3816: FROM fem_value_sets_b
3817: WHERE dimension_id = p_dim_id
3818: AND default_load_member_id IS NULL;
3819:
3820: BEGIN

Line 8655: FROM fem_value_sets_b

8651: -- We do this by getting the value_set_id that has
8652: -- the display_code = dimension varchar label
8653: SELECT value_set_id
8654: INTO v_vs_id
8655: FROM fem_value_sets_b
8656: WHERE dimension_id = r_vs_dim_id.dimension_id
8657: AND value_set_display_code = r_vs_dim_id.dimension_varchar_label;
8658:
8659: -- RCF 4/20/2005 Obsolete - v_vs_dim_id := r_vs_dim_id.dimension_id;

Line 8856: FROM fem_value_sets_b

8852: THEN
8853: BEGIN
8854: SELECT value_set_id
8855: INTO v_vs_id
8856: FROM fem_value_sets_b
8857: WHERE value_set_display_code = p_member_vs_display_code
8858: AND dimension_id = v_dim_id;
8859: EXCEPTION
8860: WHEN no_data_found THEN

Line 9252: v_vs_id FEM_VALUE_SETS_B.value_set_id%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:
9256: BEGIN

Line 9403: FROM fem_value_sets_b

9399:
9400: BEGIN
9401: SELECT default_load_member_id
9402: INTO v_default_member
9403: FROM fem_value_sets_b
9404: WHERE value_set_id = v_vs_id;
9405:
9406: -- Get the default member display code
9407: IF v_default_member IS NOT NULL THEN

Line 9779: FROM fem_value_sets_b

9775: THEN
9776: BEGIN
9777: SELECT value_set_id
9778: INTO v_vs_id
9779: FROM fem_value_sets_b
9780: WHERE value_set_id = p_dimension_member_vs_id
9781: AND dimension_id = v_dim_id;
9782: EXCEPTION
9783: WHEN no_data_found THEN

Line 9902: FROM fem_value_sets_b

9898: THEN
9899: BEGIN
9900: SELECT value_set_id
9901: INTO v_vs_id
9902: FROM fem_value_sets_b
9903: WHERE value_set_id = p_dimension_member_vs_id
9904: AND dimension_id = v_dim_id;
9905: EXCEPTION
9906: WHEN no_data_found THEN