13: start_date_column_name fnd_flex_validation_tables.start_date_column_name%TYPE,
14: end_date_column_name fnd_flex_validation_tables.end_date_column_name%TYPE);
15:
16: TYPE valueset_r IS RECORD(
17: vsid fnd_flex_values.flex_value_set_id%TYPE,
18: name fnd_flex_value_sets.flex_value_set_name%TYPE,
19: validation_type fnd_flex_value_sets.validation_type%TYPE,
20: table_info table_r);
21:
35: longlist_flag fnd_flex_value_sets.longlist_flag%TYPE);
36:
37:
38: TYPE value_dr IS RECORD(
39: id fnd_flex_values_vl.flex_value%TYPE,
40: value fnd_flex_values_vl.flex_value%TYPE,
41: meaning fnd_flex_values_vl.description%TYPE,
42: start_date_active fnd_flex_values_vl.start_date_active%TYPE,
43: end_date_active fnd_flex_values_vl.end_date_active%TYPE,
36:
37:
38: TYPE value_dr IS RECORD(
39: id fnd_flex_values_vl.flex_value%TYPE,
40: value fnd_flex_values_vl.flex_value%TYPE,
41: meaning fnd_flex_values_vl.description%TYPE,
42: start_date_active fnd_flex_values_vl.start_date_active%TYPE,
43: end_date_active fnd_flex_values_vl.end_date_active%TYPE,
44: parent_flex_value_low fnd_flex_values_vl.parent_flex_value_low%TYPE);
37:
38: TYPE value_dr IS RECORD(
39: id fnd_flex_values_vl.flex_value%TYPE,
40: value fnd_flex_values_vl.flex_value%TYPE,
41: meaning fnd_flex_values_vl.description%TYPE,
42: start_date_active fnd_flex_values_vl.start_date_active%TYPE,
43: end_date_active fnd_flex_values_vl.end_date_active%TYPE,
44: parent_flex_value_low fnd_flex_values_vl.parent_flex_value_low%TYPE);
45:
38: TYPE value_dr IS RECORD(
39: id fnd_flex_values_vl.flex_value%TYPE,
40: value fnd_flex_values_vl.flex_value%TYPE,
41: meaning fnd_flex_values_vl.description%TYPE,
42: start_date_active fnd_flex_values_vl.start_date_active%TYPE,
43: end_date_active fnd_flex_values_vl.end_date_active%TYPE,
44: parent_flex_value_low fnd_flex_values_vl.parent_flex_value_low%TYPE);
45:
46:
39: id fnd_flex_values_vl.flex_value%TYPE,
40: value fnd_flex_values_vl.flex_value%TYPE,
41: meaning fnd_flex_values_vl.description%TYPE,
42: start_date_active fnd_flex_values_vl.start_date_active%TYPE,
43: end_date_active fnd_flex_values_vl.end_date_active%TYPE,
44: parent_flex_value_low fnd_flex_values_vl.parent_flex_value_low%TYPE);
45:
46:
47: CURSOR value_c(
40: value fnd_flex_values_vl.flex_value%TYPE,
41: meaning fnd_flex_values_vl.description%TYPE,
42: start_date_active fnd_flex_values_vl.start_date_active%TYPE,
43: end_date_active fnd_flex_values_vl.end_date_active%TYPE,
44: parent_flex_value_low fnd_flex_values_vl.parent_flex_value_low%TYPE);
45:
46:
47: CURSOR value_c(
48: valueset IN valueset_r,
45:
46:
47: CURSOR value_c(
48: valueset IN valueset_r,
49: enabled IN fnd_flex_values.enabled_flag%TYPE)
50: RETURN value_dr;
51:
52: CURSOR value_d(
53: valueset IN valueset_r,
50: RETURN value_dr;
51:
52: CURSOR value_d(
53: valueset IN valueset_r,
54: enabled IN fnd_flex_values.enabled_flag%TYPE)
55: RETURN value_dr;
56:
57: PROCEDURE get_valueset(valueset_id IN fnd_flex_values.flex_value_set_id%TYPE,
58: valueset OUT nocopy valueset_r,
53: valueset IN valueset_r,
54: enabled IN fnd_flex_values.enabled_flag%TYPE)
55: RETURN value_dr;
56:
57: PROCEDURE get_valueset(valueset_id IN fnd_flex_values.flex_value_set_id%TYPE,
58: valueset OUT nocopy valueset_r,
59: format OUT nocopy valueset_dr);
60:
61: PROCEDURE get_value_init(valueset IN valueset_r,