APPS.FEM_CHECK_BR_DIS_MBRS_PKG dependencies on FEM_COND_DIM_COMPONENTS

Line 1098: FROM fem_dim_attributes_b a, fem_cond_dim_components c,

1094: --for each object definition id there can be several attributes referenced
1095: --all need to be checked to see if they reference disabled members.
1096: cursor c_attr_dim (p_obj_def_id IN NUMBER, p_param_dim_id IN NUMBER) IS
1097: SELECT a.attribute_dimension_id, d.criteria_sequence
1098: FROM fem_dim_attributes_b a, fem_cond_dim_components c,
1099: fem_cond_dim_cmp_dtl d, fem_xdim_dimensions x
1100: WHERE a.dimension_id = c.dim_id
1101: AND a.attribute_dimension_id = x.dimension_id
1102: AND x.hier_editor_managed_flag = 'Y'

Line 1136: FROM fem_cond_dim_components

1132:
1133: --get the context, dimension id
1134: SELECT dim_comp_type, dim_id
1135: INTO v_context_flag, v_dim_id
1136: FROM fem_cond_dim_components
1137: WHERE cond_dim_cmp_obj_def_id = p_obj_def_id;
1138:
1139: --We dont check for hierarchies. If its a hier, return valid.
1140: IF (v_context_flag = 'H') THEN

Line 1181: ''' FROM FEM_COND_DIM_COMPONENTS

1177: 'INSERT INTO fem_br_disabled_mbrs_gt (object_definition_id,
1178: dimension_id, dimension_member, value_set_id, context_code)
1179: SELECT ' || p_obj_def_id || ',' || v_dim_id || ', value, '
1180: || nvl(to_char(v_value_set_id), 'NULL') || ', ''' || C_CONTEXT ||
1181: ''' FROM FEM_COND_DIM_COMPONENTS
1182: WHERE cond_dim_cmp_obj_def_id = :obj_def_id
1183: AND value IN
1184: (SELECT to_char(' || v_member_column ||
1185: ') FROM ' || v_member_table ||