APPS.FEM_CHECK_BR_DIS_MBRS_PKG dependencies on FEM_COND_DATA_CMP_ST_DTL

Line 1306: v_criteria_seq FEM_COND_DATA_CMP_ST_DTL.CRITERIA_SEQUENCE%TYPE;

1302: v_member_column FEM_TAB_COLUMNS_B.COLUMN_NAME%TYPE;
1303: v_column_name FEM_XDIM_DIMENSIONS.MEMBER_COL%TYPE;
1304: v_table_name FEM_XDIM_DIMENSIONS.MEMBER_B_TABLE_NAME%TYPE;
1305: v_sequence FEM_COND_DATA_CMP_STEPS.STEP_SEQUENCE%TYPE;
1306: v_criteria_seq FEM_COND_DATA_CMP_ST_DTL.CRITERIA_SEQUENCE%TYPE;
1307: v_value_set_id FEM_GLOBAL_VS_COMBO_DEFS.VALUE_SET_ID%TYPE;
1308: v_dim_id FEM_TAB_COLUMNS_B.DIMENSION_ID%TYPE;
1309: v_value_set_flag VARCHAR2(1);
1310: v_val_stmt VARCHAR2(100);

Line 1323: fem_cond_data_cmp_st_dtl D, fem_xdim_dimensions X

1319: cursor c_objdef (p_obj_def_id IN NUMBER, p_param_dim_id IN NUMBER) IS
1320: SELECT A.column_name, A.table_name, A.step_sequence, B.dimension_id,
1321: D.criteria_sequence
1322: FROM fem_cond_data_cmp_steps A, fem_tab_columns_b B,
1323: fem_cond_data_cmp_st_dtl D, fem_xdim_dimensions X
1324: WHERE A.column_name = B.column_name
1325: AND A.table_name = B.table_name
1326: AND A.cond_data_cmp_obj_def_id = p_obj_def_id
1327: AND B.dimension_id = X.dimension_id

Line 1387: ''' FROM FEM_COND_DATA_CMP_ST_DTL

1383: 'INSERT INTO fem_br_disabled_mbrs_gt (object_definition_id,
1384: dimension_id, dimension_member, value_set_id, context_code)
1385: SELECT ' || p_obj_def_id || ',' || v_dim_id || ', value, '
1386: || nvl(to_char(v_value_set_id), 'NULL') || ', ''' || C_CONTEXT ||
1387: ''' FROM FEM_COND_DATA_CMP_ST_DTL
1388: WHERE step_sequence = :seq
1389: AND table_name = :tab_name
1390: AND criteria_sequence = :c_seq
1391: AND cond_data_cmp_obj_def_id = :obj_def_id