APPS.GL_PARENT_SEGMENT_PKG dependencies on FND_FLEX_VALUE_SETS

Line 28: p_fv_type FND_FLEX_VALUE_SETS.validation_type%TYPE;

24: debug_mode IN VARCHAR2) IS
25:
26: p_fv_table FND_FLEX_VALIDATION_TABLES.application_table_name%TYPE;
27: p_fv_col FND_FLEX_VALIDATION_TABLES.value_column_name%TYPE;
28: p_fv_type FND_FLEX_VALUE_SETS.validation_type%TYPE;
29:
30: v_CursorID INTEGER;
31: v_CursorSQL VARCHAR2(300);
32: v_detail_value FND_FLEX_VALUES.flex_value%TYPE;

Line 481: , fnd_flex_value_sets fvs

477: INTO fv_table
478: , fv_col
479: , fv_type
480: FROM fnd_flex_validation_tables fvt
481: , fnd_flex_value_sets fvs
482: WHERE fvs.flex_value_set_id = fv_set_id
483: AND fvt.flex_value_set_id(+) = fvs.flex_value_set_id;
484: EXCEPTION
485: WHEN OTHERS THEN

Line 488: fnd_message.set_token('TABLE', 'FND_FLEX_VALUE_SETS');

484: EXCEPTION
485: WHEN OTHERS THEN
486: fnd_message.set_name('SQLGL', 'MRC_TABLE_ERROR');
487: fnd_message.set_token('MODULE', 'GL_PARENT_SEGMENT_PKG.GET_FV_TABLE');
488: fnd_message.set_token('TABLE', 'FND_FLEX_VALUE_SETS');
489: RAISE_APPLICATION_ERROR(-20210, fnd_message.get||SQLERRM);
490: END;
491:
492: IF g_debug_mode = 'Y' THEN