[Home] [Help]
PACKAGE: APPS.XLA_FLEX_PKG
Source
1 PACKAGE xla_flex_pkg AS
2 /* $Header: xlacmflx.pkh 120.12 2005/02/26 02:08:25 weshen ship $ */
3 /*======================================================================+
4 | Copyright (c) 2001-2002 Oracle Corporation |
5 | Redwood Shores, CA, USA |
6 | All rights reserved. |
7 +=======================================================================+
8 | PACKAGE NAME |
9 | xla_flex_pkg |
10 | |
11 | DESCRIPTION |
12 | XLA Flex Package |
13 | |
14 | HISTORY |
15 | 01-May-01 Dimple Shah Created |
16 | |
17 +======================================================================*/
18
19 /*======================================================================+
20 | |
21 | Public Function |
22 | |
23 | get_value_set_name |
24 | |
25 | Get the value set name for the value set id |
26 | |
27 +======================================================================*/
28 FUNCTION get_value_set_name
29 (p_flex_value_set_id IN INTEGER)
30 RETURN VARCHAR2;
31
32
33 /*======================================================================+
34 | |
35 | Public Function |
36 | |
37 | get_chart_of_accounts_name |
38 | |
39 | Get the chart of accounts name for the chart of accounts id |
40 | |
41 +======================================================================*/
42 FUNCTION get_chart_of_accounts_name
43 (p_application_id IN INTEGER
44 ,p_flex_code IN VARCHAR2
45 ,p_chart_of_accounts_id IN INTEGER)
46 RETURN VARCHAR2;
47
48
49 /*======================================================================+
50 | |
51 | Public Function |
52 | |
53 | get_flexfield_segment_name |
54 | |
55 | Get the segment name for the segment code |
56 | |
57 +======================================================================*/
58 FUNCTION get_flexfield_segment_name
59 (p_application_id IN INTEGER
60 ,p_flex_code IN VARCHAR2
61 ,p_chart_of_accounts_id IN INTEGER
62 ,p_flexfield_segment_code IN VARCHAR2)
63 RETURN VARCHAR2;
64
65
66 /*======================================================================+
67 | |
68 | Public Function |
69 | |
70 | get_flex_value_meaning |
71 | |
72 | Get the meaning for the flex value |
73 | |
74 +======================================================================*/
75 FUNCTION get_flex_value_meaning
76 (p_flex_value_set_id IN INTEGER
77 ,p_flex_value IN VARCHAR2)
78 RETURN VARCHAR2;
79
80 /*======================================================================+
81 | |
82 | Public Function |
83 | |
84 | get_flexfield_segment_info |
85 | |
86 | Get the segment info for the segment code |
87 | |
88 +======================================================================*/
89 FUNCTION get_flexfield_segment_info
90 (p_application_id IN INTEGER
91 ,p_flex_code IN VARCHAR2
92 ,p_chart_of_accounts_id IN INTEGER
93 ,p_flexfield_segment_code IN VARCHAR2
94 ,p_flexfield_segment_name IN OUT NOCOPY VARCHAR2
95 ,p_flexfield_segment_num IN OUT NOCOPY INTEGER)
96 RETURN BOOLEAN;
97
98 /*======================================================================+
99 | |
100 | Public Procedure |
101 | |
102 | get_table_vset_select |
103 | |
104 | Get the select for a table validated valueset |
105 | |
106 +======================================================================*/
107 PROCEDURE get_table_vset_select
108 (p_flex_value_set_id IN INTEGER
109 ,p_select OUT NOCOPY VARCHAR2
110 ,p_mapping_code OUT NOCOPY VARCHAR2
111 ,p_success OUT NOCOPY NUMBER);
112
113 /*======================================================================+
114 | |
115 | Public Function |
116 | |
117 | segment_qualifer_is_enabled |
118 | |
119 | Returns true if the segment qualifer is enabled for the coa specified |
120 | |
121 +======================================================================*/
122 FUNCTION segment_qualifier_is_enabled
123 (p_application_id IN INTEGER
124 ,p_flex_code IN VARCHAR2
125 ,p_chart_of_accounts_id IN INTEGER
126 ,p_flexfield_segment_code IN VARCHAR2)
127 RETURN BOOLEAN;
128
129 /*======================================================================+
130 | |
131 | Public Function |
132 | |
133 | id_column_is_null |
134 | |
135 | Returns true if the id column is null |
136 | |
137 +======================================================================*/
138 FUNCTION id_column_is_null
139 (p_flex_value_set_id IN INTEGER)
140 RETURN BOOLEAN;
141
142 /*======================================================================+
143 | |
144 | Public Function |
145 | |
146 | meaning_column_is_null |
147 | |
148 | Returns true if the meaning column is null |
149 | |
150 +======================================================================*/
151 FUNCTION meaning_column_is_null
152 (p_flex_value_set_id IN INTEGER)
153 RETURN BOOLEAN;
154
155 /*======================================================================+
156 | |
157 | Public Function |
158 | |
159 | chk_additional_where_clause |
160 | |
161 | Returns true if the additional where caluse has $FLEX$ |
162 | |
163 +======================================================================*/
164 FUNCTION chk_additional_where_clause
165 (p_flex_value_set_id IN INTEGER)
166 RETURN VARCHAR2;
167
168 /*======================================================================+
169 | |
170 | Public Function |
171 | |
172 | get_qualifier_segment |
173 | |
174 | Returns the segment for the qualifier specified |
175 | |
176 +======================================================================*/
177 FUNCTION get_qualifier_segment
178 (p_application_id IN INTEGER
179 ,p_id_flex_code IN VARCHAR2
180 ,p_id_flex_num IN INTEGER
181 ,p_qualifier_segment IN VARCHAR2)
182 RETURN VARCHAR2;
183
184 /*======================================================================+
185 | |
186 | Public Function |
187 | |
188 | get_segment_qualifier |
189 | |
190 | Returns the qualifier for the segment specified |
191 | |
192 +======================================================================*/
193 FUNCTION get_segment_qualifier
194 (p_application_id IN INTEGER
195 ,p_id_flex_code IN VARCHAR2
196 ,p_id_flex_num IN INTEGER
197 ,p_segment_code IN VARCHAR2)
198 RETURN VARCHAR2;
199
200 /*======================================================================+
201 | |
202 | Public Function |
203 | |
204 | get_segment_valueset |
205 | |
206 | Returns the valuset for the segment specified |
207 | |
208 +======================================================================*/
209 FUNCTION get_segment_valueset
210 (p_application_id IN INTEGER
211 ,p_id_flex_code IN VARCHAR2
212 ,p_id_flex_num IN INTEGER
213 ,p_segment_code IN VARCHAR2)
214 RETURN NUMBER;
215
216 /*======================================================================+
217 | |
218 | Public Function |
219 | |
220 | get_qualifier_name |
221 | |
222 | Returns the name for the flexfield qualifier |
223 | |
224 +======================================================================*/
225 FUNCTION get_qualifier_name
226 (p_application_id IN INTEGER
227 ,p_id_flex_code IN VARCHAR2
228 ,p_qualifier_segment IN VARCHAR2)
229 RETURN VARCHAR2;
230
231 /*======================================================================+
232 | |
233 | Public Function |
234 | |
235 | get_flexfield_structure |
236 | |
237 | Returns the flexfield structure for the key flexfields that support |
238 | single structure |
239 | |
240 +======================================================================*/
241 FUNCTION get_flexfield_structure
242 (p_application_id IN INTEGER
243 ,p_id_flex_code IN VARCHAR2)
244 RETURN NUMBER;
245
246 END xla_flex_pkg;