1 PACKAGE hr_id_flex_structure_info
2 /* $Header: hrkfsinf.pkh 115.2 2002/12/11 14:23:59 hjonnala ship $ */
3 AUTHID CURRENT_USER AS
4 --
5 -- Global Types
6 --
7 TYPE t_segment IS RECORD
8 (column_name fnd_id_flex_segments.application_column_name%TYPE
9 ,sequence fnd_id_flex_segments.segment_num%TYPE
10 ,additional_column1_title VARCHAR2(2000)
11 ,additional_column1_width VARCHAR2(2000)
12 ,additional_column2_title VARCHAR2(2000)
13 ,additional_column2_width VARCHAR2(2000)
14 ,additional_column3_title VARCHAR2(2000)
15 ,additional_column3_width VARCHAR2(2000)
16 ,alphanumeric_allowed_flag fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE
17 ,concatenation_description_len fnd_id_flex_segments.concatenation_description_len%TYPE
18 ,default_type fnd_id_flex_segments.default_type%TYPE
19 ,default_value fnd_id_flex_segments.default_value%TYPE
20 ,display_flag fnd_id_flex_segments.display_flag%TYPE
21 ,display_size fnd_id_flex_segments.display_size%TYPE
22 ,enabled_flag fnd_id_flex_segments.enabled_flag%TYPE
23 ,flex_value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE
24 ,flex_value_set_name fnd_flex_value_sets.flex_value_set_name%TYPE
25 ,format_type fnd_flex_value_sets.format_type%TYPE
26 ,form_above_prompt fnd_id_flex_segments_tl.form_above_prompt%TYPE
27 ,form_left_prompt fnd_id_flex_segments_tl.form_left_prompt%TYPE
28 ,identification_sql VARCHAR2(32767)
29 ,id_column_type VARCHAR2(1)
30 ,has_meaning BOOLEAN
31 ,longlist_flag fnd_flex_value_sets.longlist_flag%TYPE
32 ,maximum_description_len fnd_id_flex_segments.maximum_description_len%TYPE
33 ,maximum_size fnd_flex_value_sets.maximum_size%TYPE
34 ,maximum_value fnd_flex_value_sets.maximum_value%TYPE
35 ,minimum_value fnd_flex_value_sets.minimum_value%TYPE
36 ,number_precision fnd_flex_value_sets.number_precision%TYPE
37 ,numeric_mode_enabled_flag fnd_flex_value_sets.numeric_mode_enabled_flag%TYPE
38 ,required_flag fnd_id_flex_segments.required_flag%TYPE
39 ,segment_name fnd_id_flex_segments.segment_name%TYPE
40 ,uppercase_only_flag fnd_flex_value_sets.uppercase_only_flag%TYPE
41 ,validation_sql VARCHAR2(32767)
42 ,validation_type fnd_flex_value_sets.validation_type%TYPE
43 );
44 TYPE t_segments IS TABLE OF t_segment;
45 TYPE t_segments_pst IS TABLE OF t_segment INDEX BY BINARY_INTEGER;
46 --
47 -- -----------------------------------------------------------------------------
48 -- |--------------------------------< segments >-------------------------------|
49 -- -----------------------------------------------------------------------------
50 -- {Start of Comments}
51 --
52 -- Description
53 -- This function returns a table containing the details of columns for a key
54 -- flexfield structure. There will be a row in the returned table structure
55 -- for all columns available for the key flexfield, even though it may not be
56 -- used for the specified structure.
57 --
58 -- Prerequisites
59 -- None.
60 --
61 -- In Parameters
62 -- Name Reqd Type Description
63 -- p_application_id Y number Application identifier
64 -- p_id_flex_code Y varchar2 Key flexfield code
65 -- p_id_flex_num Y number Key flexfield structure number
66 -- p_effective_date Y date Effective date
67 --
68 -- Post Success
69 -- A table containg the columns for the key flexfield structure is returned.
70 --
71 -- Post Failure
72 -- An error is raised.
73 --
74 -- Access Status
75 -- Internal Development Use Only
76 --
77 -- {End of Comments}
78 -- -----------------------------------------------------------------------------
79 FUNCTION segments
80 (p_application_id IN fnd_id_flex_structures.application_id%TYPE
81 ,p_id_flex_code IN fnd_id_flex_structures.id_flex_code%TYPE
82 ,p_id_flex_num IN fnd_id_flex_structures.id_flex_num%TYPE
83 ,p_effective_date IN DATE
84 )
85 RETURN t_segments;
86 -- -----------------------------------------------------------------------------
87 -- |------------------------------< segments_pst >-----------------------------|
88 -- -----------------------------------------------------------------------------
89 -- {Start of Comments}
90 --
91 -- Description
92 -- This function returns a table containing the details of columns for a key
93 -- flexfield structure. There will be a row in the returned table structure
94 -- for all columns available for the key flexfield, even though it may not be
95 -- used for the specified structure.
96 -- A PL/SQL table is returned so it may be correctly retrieved by procedures
97 -- within a Forms Application. Form 6 cannot retrieve nested tables from
98 -- server-sde packages.
99 --
100 -- Prerequisites
101 -- None.
102 --
103 -- In Parameters
104 -- Name Reqd Type Description
105 -- p_application_short_name Y varchar2 Application short name
106 -- p_id_flex_code Y varchar2 Key flexfield code
107 -- p_id_flex_num Y number Key flexfield structure number
108 -- p_effective_date Y date Effective date
109 --
110 -- Post Success
111 -- A table containg the columns for the key flexfield structure is returned.
112 --
113 -- Post Failure
114 -- An error is raised.
115 --
116 -- Access Status
117 -- Internal Development Use Only
118 --
119 -- {End of Comments}
120 -- -----------------------------------------------------------------------------
121 FUNCTION segments_pst
122 (p_application_short_name IN fnd_application.application_short_name%TYPE
123 ,p_id_flex_code IN fnd_id_flex_structures.id_flex_code%TYPE
124 ,p_id_flex_num IN fnd_id_flex_structures.id_flex_num%TYPE
125 ,p_effective_date IN DATE
126 )
127 RETURN t_segments_pst;
128 --
129 END hr_id_flex_structure_info;