PACKAGE: APPS.HR_FLEX_VALUE_SET_INFO

Source

1 PACKAGE hr_flex_value_set_info
2 /* $Header: hrfvsinf.pkh 115.1 2002/12/11 11:13:40 hjonnala ship $ */
3 AUTHID CURRENT_USER AS
4   --
5   -- Global types
6   --
7   TYPE t_value_set IS RECORD
8     (flex_value_set_id              fnd_flex_value_sets.flex_value_set_id%TYPE
9     ,additional_column1_title       VARCHAR2(2000)
10     ,additional_column1_width       VARCHAR2(2000)
11     ,additional_column2_title       VARCHAR2(2000)
12     ,additional_column2_width       VARCHAR2(2000)
13     ,additional_column3_title       VARCHAR2(2000)
14     ,additional_column3_width       VARCHAR2(2000)
15     ,alphanumeric_allowed_flag      fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE
16     ,flex_value_set_name            fnd_flex_value_sets.flex_value_set_name%TYPE
17     ,format_type                    fnd_flex_value_sets.format_type%TYPE
18     ,identification_sql             VARCHAR2(32767)
19     ,id_column_type                 VARCHAR2(1)
20     ,has_meaning                    BOOLEAN
21     ,longlist_flag                  fnd_flex_value_sets.longlist_flag%TYPE
22     ,maximum_size                   fnd_flex_value_sets.maximum_size%TYPE
23     ,maximum_value                  fnd_flex_value_sets.maximum_value%TYPE
24     ,minimum_value                  fnd_flex_value_sets.minimum_value%TYPE
25     ,number_precision               fnd_flex_value_sets.number_precision%TYPE
26     ,numeric_mode_enabled_flag      fnd_flex_value_sets.numeric_mode_enabled_flag%TYPE
27     ,uppercase_only_flag            fnd_flex_value_sets.uppercase_only_flag%TYPE
28     ,validation_sql                 VARCHAR2(32767)
29     ,validation_type                fnd_flex_value_sets.validation_type%TYPE
30     );
31 --
32 -- -----------------------------------------------------------------------------
33 -- |-------------------------------< value_set >-------------------------------|
34 -- -----------------------------------------------------------------------------
35 -- {Start of Comments}
36 --
37 -- Description
38 --   This function returns a record containing the details of a flexfield value
39 --   set.
40 --
41 -- Prerequisites
42 --   None.
43 --
44 -- In Parameters
45 --   Name                           Reqd Type     Description
46 --   p_flex_value_set_id            Y    number   Flexfield value set identifier
47 --   p_effective_date               Y    date     Effective date
48 --
49 -- Post Success
50 --   A record containg the details of a flexfield value set is returned.
51 --
52 -- Post Failure
53 --   An error is raised.
54 --
55 -- Access Status
56 --   Internal Development Use Only
57 --
58 -- {End of Comments}
59 -- -----------------------------------------------------------------------------
60 FUNCTION value_set
61   (p_flex_value_set_id            IN     fnd_flex_value_sets.flex_value_set_id%TYPE
62   ,p_effective_date               IN     DATE
63   )
64 RETURN t_value_set;
65 --
66 END hr_flex_value_set_info;