[Home] [Help]
PACKAGE: APPS.XLA_FLEX_PKG
Source
1 PACKAGE xla_flex_pkg AUTHID CURRENT_USER AS
2 /* $Header: xlacmflx.pkh 120.12.12010000.3 2009/06/19 09:33:10 rajose 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 Procedure |
116 | |
117 | get_table_vset_return_col |
118 | |
119 | Get the select column and where column for a table validated valueset |
120 | |
121 +======================================================================*/
122 PROCEDURE get_table_vset_return_col
123 (p_flex_value_set_id IN INTEGER
124 ,p_select_col OUT NOCOPY VARCHAR2
125 ,p_where_col OUT NOCOPY VARCHAR2
126 ,p_type_out OUT NOCOPY INTEGER
127 ) ;
128
129
130
131 /*======================================================================+
132 | |
133 | Public Function |
134 | |
135 | segment_qualifer_is_enabled |
136 | |
137 | Returns true if the segment qualifer is enabled for the coa specified |
138 | |
139 +======================================================================*/
140 FUNCTION segment_qualifier_is_enabled
141 (p_application_id IN INTEGER
142 ,p_flex_code IN VARCHAR2
143 ,p_chart_of_accounts_id IN INTEGER
144 ,p_flexfield_segment_code IN VARCHAR2)
145 RETURN BOOLEAN;
146
147 /*======================================================================+
148 | |
149 | Public Function |
150 | |
151 | id_column_is_null |
152 | |
153 | Returns true if the id column is null |
154 | |
155 +======================================================================*/
156 FUNCTION id_column_is_null
157 (p_flex_value_set_id IN INTEGER)
158 RETURN BOOLEAN;
159
160 /*======================================================================+
161 | |
162 | Public Function |
163 | |
164 | meaning_column_is_null |
165 | |
166 | Returns true if the meaning column is null |
167 | |
168 +======================================================================*/
169 FUNCTION meaning_column_is_null
170 (p_flex_value_set_id IN INTEGER)
171 RETURN BOOLEAN;
172
173 /*======================================================================+
174 | |
175 | Public Function |
176 | |
177 | chk_additional_where_clause |
178 | |
179 | Returns true if the additional where caluse has $FLEX$ |
180 | |
181 +======================================================================*/
182 FUNCTION chk_additional_where_clause
183 (p_flex_value_set_id IN INTEGER)
184 RETURN VARCHAR2;
185
186 /*======================================================================+
187 | |
188 | Public Function |
189 | |
190 | get_qualifier_segment |
191 | |
192 | Returns the segment for the qualifier specified |
193 | |
194 +======================================================================*/
195 FUNCTION get_qualifier_segment
196 (p_application_id IN INTEGER
197 ,p_id_flex_code IN VARCHAR2
198 ,p_id_flex_num IN INTEGER
199 ,p_qualifier_segment IN VARCHAR2)
200 RETURN VARCHAR2;
201
202 /*======================================================================+
203 | |
204 | Public Function |
205 | |
206 | get_segment_qualifier |
207 | |
208 | Returns the qualifier for the segment specified |
209 | |
210 +======================================================================*/
211 FUNCTION get_segment_qualifier
212 (p_application_id IN INTEGER
213 ,p_id_flex_code IN VARCHAR2
214 ,p_id_flex_num IN INTEGER
215 ,p_segment_code IN VARCHAR2)
216 RETURN VARCHAR2;
217
218 /*======================================================================+
219 | |
220 | Public Function |
221 | |
222 | get_segment_valueset |
223 | |
224 | Returns the valuset for the segment specified |
225 | |
226 +======================================================================*/
227 FUNCTION get_segment_valueset
228 (p_application_id IN INTEGER
229 ,p_id_flex_code IN VARCHAR2
230 ,p_id_flex_num IN INTEGER
231 ,p_segment_code IN VARCHAR2)
232 RETURN NUMBER;
233
234 /*======================================================================+
235 | |
236 | Public Function |
237 | |
238 | get_qualifier_name |
239 | |
240 | Returns the name for the flexfield qualifier |
241 | |
242 +======================================================================*/
243 FUNCTION get_qualifier_name
244 (p_application_id IN INTEGER
245 ,p_id_flex_code IN VARCHAR2
246 ,p_qualifier_segment IN VARCHAR2)
247 RETURN VARCHAR2;
248
249 /*======================================================================+
250 | |
251 | Public Function |
252 | |
253 | get_flexfield_structure |
254 | |
255 | Returns the flexfield structure for the key flexfields that support |
256 | single structure |
257 | |
258 +======================================================================*/
259 FUNCTION get_flexfield_structure
260 (p_application_id IN INTEGER
261 ,p_id_flex_code IN VARCHAR2)
262 RETURN NUMBER;
263
264 END xla_flex_pkg;