14: TYPE product_segment_record IS RECORD
15: (column_name fnd_id_flex_segments_vl.application_column_name%TYPE,
16: value_set_id fnd_id_flex_segments_vl.flex_value_set_id%TYPE,
17: validation_type fnd_flex_value_sets.validation_type%TYPE,
18: table_name fnd_flex_validation_tables.application_table_name%TYPE,
19: meaning_column fnd_flex_validation_tables.meaning_column_name%TYPE,
20: id_column fnd_flex_validation_tables.id_column_name%TYPE,
21: value_column fnd_flex_validation_tables.value_column_name%TYPE,
22: where_clause fnd_flex_validation_tables.meaning_column_name%TYPE,
15: (column_name fnd_id_flex_segments_vl.application_column_name%TYPE,
16: value_set_id fnd_id_flex_segments_vl.flex_value_set_id%TYPE,
17: validation_type fnd_flex_value_sets.validation_type%TYPE,
18: table_name fnd_flex_validation_tables.application_table_name%TYPE,
19: meaning_column fnd_flex_validation_tables.meaning_column_name%TYPE,
20: id_column fnd_flex_validation_tables.id_column_name%TYPE,
21: value_column fnd_flex_validation_tables.value_column_name%TYPE,
22: where_clause fnd_flex_validation_tables.meaning_column_name%TYPE,
23: parent_segment_index INTEGER
16: value_set_id fnd_id_flex_segments_vl.flex_value_set_id%TYPE,
17: validation_type fnd_flex_value_sets.validation_type%TYPE,
18: table_name fnd_flex_validation_tables.application_table_name%TYPE,
19: meaning_column fnd_flex_validation_tables.meaning_column_name%TYPE,
20: id_column fnd_flex_validation_tables.id_column_name%TYPE,
21: value_column fnd_flex_validation_tables.value_column_name%TYPE,
22: where_clause fnd_flex_validation_tables.meaning_column_name%TYPE,
23: parent_segment_index INTEGER
24: );
17: validation_type fnd_flex_value_sets.validation_type%TYPE,
18: table_name fnd_flex_validation_tables.application_table_name%TYPE,
19: meaning_column fnd_flex_validation_tables.meaning_column_name%TYPE,
20: id_column fnd_flex_validation_tables.id_column_name%TYPE,
21: value_column fnd_flex_validation_tables.value_column_name%TYPE,
22: where_clause fnd_flex_validation_tables.meaning_column_name%TYPE,
23: parent_segment_index INTEGER
24: );
25:
18: table_name fnd_flex_validation_tables.application_table_name%TYPE,
19: meaning_column fnd_flex_validation_tables.meaning_column_name%TYPE,
20: id_column fnd_flex_validation_tables.id_column_name%TYPE,
21: value_column fnd_flex_validation_tables.value_column_name%TYPE,
22: where_clause fnd_flex_validation_tables.meaning_column_name%TYPE,
23: parent_segment_index INTEGER
24: );
25:
26: TYPE product_segment_table IS
432: p_segment_value IN VARCHAR2,
433: p_parent_segment_value IN VARCHAR2
434: ) RETURN VARCHAR2
435: IS
436: l_id_or_value fnd_flex_validation_tables.id_column_name%TYPE;
437: l_cur cursor_ref_type;
438: l_description fnd_flex_values_vl.description%TYPE;
439: l_description2 fnd_flex_values_vl.description%TYPE;
440: BEGIN