APPS.FEM_CHECK_BR_DIS_MBRS_PKG dependencies on FEM_COND_DIM_CMP_DTL

Line 1087: v_criteria_seq FEM_COND_DIM_CMP_DTL.CRITERIA_SEQUENCE%TYPE;

1083: v_column_name FEM_XDIM_DIMENSIONS.MEMBER_COL%TYPE;
1084: v_table_name FEM_XDIM_DIMENSIONS.MEMBER_B_TABLE_NAME%TYPE;
1085: v_value_set_id FEM_GLOBAL_VS_COMBO_DEFS.VALUE_SET_ID%TYPE;
1086: v_dim_id FEM_TAB_COLUMNS_B.DIMENSION_ID%TYPE;
1087: v_criteria_seq FEM_COND_DIM_CMP_DTL.CRITERIA_SEQUENCE%TYPE;
1088: v_value_set_flag VARCHAR2(1);
1089: v_context_flag VARCHAR2(1);
1090: v_val_stmt VARCHAR2(100);
1091: v_insert_stmt VARCHAR2(1000);

Line 1099: fem_cond_dim_cmp_dtl d, fem_xdim_dimensions x

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'
1103: AND a.attribute_varchar_label = d.dim_attr_varchar_label

Line 1233: ''' FROM FEM_COND_DIM_CMP_DTL

1229: 'INSERT INTO fem_br_disabled_mbrs_gt (object_definition_id,
1230: dimension_id, dimension_member, value_set_id, context_code)
1231: SELECT ' || p_obj_def_id || ',' || v_dim_id ||
1232: ', dim_attr_value,' || nvl(to_char(v_value_set_id), 'NULL') || ', ''' || C_CONTEXT ||
1233: ''' FROM FEM_COND_DIM_CMP_DTL
1234: WHERE cond_dim_cmp_obj_def_id = :obj_def_id
1235: AND criteria_sequence = :criteria_seq
1236: AND dim_attr_value IN
1237: (SELECT to_char(' || v_member_column ||