PACKAGE: APPS.FND_VSET

Source

1 PACKAGE fnd_vset AS
2 /* $Header: AFFFVDUS.pls 120.3.12010000.1 2008/07/25 14:14:51 appldev ship $ */
3 
4 
5 /* private */
6 TYPE table_r IS RECORD(
7      table_name             fnd_flex_validation_tables.application_table_name%TYPE,
8      id_column_name         fnd_flex_validation_tables.id_column_name%TYPE,
9      id_column_type         fnd_flex_validation_tables.id_column_type%TYPE,
10      value_column_name      fnd_flex_validation_tables.value_column_name%TYPE,
11      meaning_column_name    fnd_flex_validation_tables.meaning_column_name%TYPE,
12      where_clause           fnd_flex_validation_tables.additional_where_clause%TYPE,
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 
22 
23 /* public */
24 TYPE valueset_dr IS RECORD(
25      format_type                fnd_flex_value_sets.format_type%TYPE,
26      alphanumeric_allowed_flag  fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE,
27      uppercase_only_flag        fnd_flex_value_sets.uppercase_only_flag%TYPE,
28      numeric_mode_flag          fnd_flex_value_sets.numeric_mode_enabled_flag%TYPE,
29      max_size                   fnd_flex_value_sets.maximum_size%TYPE,
30      max_value                  fnd_flex_value_sets.maximum_value%TYPE,
31      min_value                  fnd_flex_value_sets.minimum_value%TYPE,
32      longlist_enabled           BOOLEAN,
33      has_id                     BOOLEAN,
34      has_meaning                BOOLEAN,
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,
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,
49        enabled  IN fnd_flex_values.enabled_flag%TYPE)
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,
59 		       format      OUT nocopy valueset_dr);
60 
61 PROCEDURE get_value_init(valueset     IN valueset_r,
62 			 enabled_only IN  BOOLEAN);
63 
64 PROCEDURE get_value(valueset     IN  valueset_r,
65 		    rowcount     OUT nocopy NUMBER,
66 		    found        OUT nocopy BOOLEAN,
67 		    value        OUT nocopy value_dr);
68 
69 PROCEDURE get_value_end(valueset   IN valueset_r);
70 
71 PROCEDURE test(vsid IN NUMBER);
72 PROCEDURE test_independent;
73 PROCEDURE test_table;
74 
75 PROCEDURE debug(state IN BOOLEAN);
76 
77 
78 END fnd_vset;			/* end package */