DBA Data[Home] [Help]

APPS.GL_PARENT_SEGMENT_PKG dependencies on FND_FLEX_VALIDATION_TABLES

Line 26: p_fv_table FND_FLEX_VALIDATION_TABLES.application_table_name%TYPE;

22:
23: PROCEDURE merge_child_ranges(fv_set_id IN NUMBER,
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;

Line 27: p_fv_col FND_FLEX_VALIDATION_TABLES.value_column_name%TYPE;

23: PROCEDURE merge_child_ranges(fv_set_id IN NUMBER,
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);

Line 480: FROM fnd_flex_validation_tables fvt

476: , fvs.validation_type
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