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,