41: runtime_property_function fnd_id_flex_segments.runtime_property_function%TYPE,
42: additional_where_clause fnd_id_flex_segments.additional_where_clause%TYPE);
43:
44: TYPE ValueSetInfo IS RECORD
45: (vsid fnd_flex_value_sets.flex_value_set_id%TYPE,
46: parent_vsid fnd_flex_value_sets.parent_flex_value_set_id%TYPE,
47: valsecure fnd_flex_value_sets.security_enabled_flag%TYPE,
48: valtype fnd_flex_value_sets.validation_type%TYPE,
49: vsformat fnd_flex_value_sets.format_type%TYPE,
42: additional_where_clause fnd_id_flex_segments.additional_where_clause%TYPE);
43:
44: TYPE ValueSetInfo IS RECORD
45: (vsid fnd_flex_value_sets.flex_value_set_id%TYPE,
46: parent_vsid fnd_flex_value_sets.parent_flex_value_set_id%TYPE,
47: valsecure fnd_flex_value_sets.security_enabled_flag%TYPE,
48: valtype fnd_flex_value_sets.validation_type%TYPE,
49: vsformat fnd_flex_value_sets.format_type%TYPE,
50: maxsize fnd_flex_value_sets.maximum_size%TYPE,
43:
44: TYPE ValueSetInfo IS RECORD
45: (vsid fnd_flex_value_sets.flex_value_set_id%TYPE,
46: parent_vsid fnd_flex_value_sets.parent_flex_value_set_id%TYPE,
47: valsecure fnd_flex_value_sets.security_enabled_flag%TYPE,
48: valtype fnd_flex_value_sets.validation_type%TYPE,
49: vsformat fnd_flex_value_sets.format_type%TYPE,
50: maxsize fnd_flex_value_sets.maximum_size%TYPE,
51: lettersok fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE,
44: TYPE ValueSetInfo IS RECORD
45: (vsid fnd_flex_value_sets.flex_value_set_id%TYPE,
46: parent_vsid fnd_flex_value_sets.parent_flex_value_set_id%TYPE,
47: valsecure fnd_flex_value_sets.security_enabled_flag%TYPE,
48: valtype fnd_flex_value_sets.validation_type%TYPE,
49: vsformat fnd_flex_value_sets.format_type%TYPE,
50: maxsize fnd_flex_value_sets.maximum_size%TYPE,
51: lettersok fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE,
52: capsonly fnd_flex_value_sets.uppercase_only_flag%TYPE,
45: (vsid fnd_flex_value_sets.flex_value_set_id%TYPE,
46: parent_vsid fnd_flex_value_sets.parent_flex_value_set_id%TYPE,
47: valsecure fnd_flex_value_sets.security_enabled_flag%TYPE,
48: valtype fnd_flex_value_sets.validation_type%TYPE,
49: vsformat fnd_flex_value_sets.format_type%TYPE,
50: maxsize fnd_flex_value_sets.maximum_size%TYPE,
51: lettersok fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE,
52: capsonly fnd_flex_value_sets.uppercase_only_flag%TYPE,
53: zfill fnd_flex_value_sets.numeric_mode_enabled_flag%TYPE,
46: parent_vsid fnd_flex_value_sets.parent_flex_value_set_id%TYPE,
47: valsecure fnd_flex_value_sets.security_enabled_flag%TYPE,
48: valtype fnd_flex_value_sets.validation_type%TYPE,
49: vsformat fnd_flex_value_sets.format_type%TYPE,
50: maxsize fnd_flex_value_sets.maximum_size%TYPE,
51: lettersok fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE,
52: capsonly fnd_flex_value_sets.uppercase_only_flag%TYPE,
53: zfill fnd_flex_value_sets.numeric_mode_enabled_flag%TYPE,
54: precis fnd_flex_value_sets.number_precision%TYPE,
47: valsecure fnd_flex_value_sets.security_enabled_flag%TYPE,
48: valtype fnd_flex_value_sets.validation_type%TYPE,
49: vsformat fnd_flex_value_sets.format_type%TYPE,
50: maxsize fnd_flex_value_sets.maximum_size%TYPE,
51: lettersok fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE,
52: capsonly fnd_flex_value_sets.uppercase_only_flag%TYPE,
53: zfill fnd_flex_value_sets.numeric_mode_enabled_flag%TYPE,
54: precis fnd_flex_value_sets.number_precision%TYPE,
55: minval fnd_flex_value_sets.minimum_value%TYPE,
48: valtype fnd_flex_value_sets.validation_type%TYPE,
49: vsformat fnd_flex_value_sets.format_type%TYPE,
50: maxsize fnd_flex_value_sets.maximum_size%TYPE,
51: lettersok fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE,
52: capsonly fnd_flex_value_sets.uppercase_only_flag%TYPE,
53: zfill fnd_flex_value_sets.numeric_mode_enabled_flag%TYPE,
54: precis fnd_flex_value_sets.number_precision%TYPE,
55: minval fnd_flex_value_sets.minimum_value%TYPE,
56: maxval fnd_flex_value_sets.maximum_value%TYPE,
49: vsformat fnd_flex_value_sets.format_type%TYPE,
50: maxsize fnd_flex_value_sets.maximum_size%TYPE,
51: lettersok fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE,
52: capsonly fnd_flex_value_sets.uppercase_only_flag%TYPE,
53: zfill fnd_flex_value_sets.numeric_mode_enabled_flag%TYPE,
54: precis fnd_flex_value_sets.number_precision%TYPE,
55: minval fnd_flex_value_sets.minimum_value%TYPE,
56: maxval fnd_flex_value_sets.maximum_value%TYPE,
57: vsname fnd_flex_value_sets.flex_value_set_name%TYPE);
50: maxsize fnd_flex_value_sets.maximum_size%TYPE,
51: lettersok fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE,
52: capsonly fnd_flex_value_sets.uppercase_only_flag%TYPE,
53: zfill fnd_flex_value_sets.numeric_mode_enabled_flag%TYPE,
54: precis fnd_flex_value_sets.number_precision%TYPE,
55: minval fnd_flex_value_sets.minimum_value%TYPE,
56: maxval fnd_flex_value_sets.maximum_value%TYPE,
57: vsname fnd_flex_value_sets.flex_value_set_name%TYPE);
58:
51: lettersok fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE,
52: capsonly fnd_flex_value_sets.uppercase_only_flag%TYPE,
53: zfill fnd_flex_value_sets.numeric_mode_enabled_flag%TYPE,
54: precis fnd_flex_value_sets.number_precision%TYPE,
55: minval fnd_flex_value_sets.minimum_value%TYPE,
56: maxval fnd_flex_value_sets.maximum_value%TYPE,
57: vsname fnd_flex_value_sets.flex_value_set_name%TYPE);
58:
59: ------------
52: capsonly fnd_flex_value_sets.uppercase_only_flag%TYPE,
53: zfill fnd_flex_value_sets.numeric_mode_enabled_flag%TYPE,
54: precis fnd_flex_value_sets.number_precision%TYPE,
55: minval fnd_flex_value_sets.minimum_value%TYPE,
56: maxval fnd_flex_value_sets.maximum_value%TYPE,
57: vsname fnd_flex_value_sets.flex_value_set_name%TYPE);
58:
59: ------------
60: -- PRIVATE CONSTANTS
53: zfill fnd_flex_value_sets.numeric_mode_enabled_flag%TYPE,
54: precis fnd_flex_value_sets.number_precision%TYPE,
55: minval fnd_flex_value_sets.minimum_value%TYPE,
56: maxval fnd_flex_value_sets.maximum_value%TYPE,
57: vsname fnd_flex_value_sets.flex_value_set_name%TYPE);
58:
59: ------------
60: -- PRIVATE CONSTANTS
61:
3819: alphanumeric_allowed_flag, uppercase_only_flag,
3820: numeric_mode_enabled_flag, number_precision, minimum_value,
3821: maximum_value, flex_value_set_name
3822: INTO l_vsi
3823: FROM fnd_flex_value_sets
3824: WHERE flex_value_set_id = value_set_id;
3825:
3826: fnd_plsql_cache.generic_cache_new_value
3827: (x_value => g_cache_value,