[Home] [Help]
PACKAGE: APPS.XLA_AE_CODE_COMBINATION_PKG
Source
1 PACKAGE xla_ae_code_combination_pkg AUTHID CURRENT_USER AS
2 /* $Header: xlajecci.pkh 120.11.12010000.2 2010/03/24 08:05:50 karamakr ship $ */
3 /*===========================================================================+
4 | Copyright (c) 2001-2002 Oracle Corporation |
5 | Redwood Shores, CA, USA |
6 | All rights reserved. |
7 +============================================================================+
8 | PACKAGE NAME |
9 | xla_ae_code_combination_pkg |
10 | |
11 | DESCRIPTION |
12 | |
13 | |
14 | HISTORY |
15 | 25-JUL-2002 K.Boussema Created |
16 | 17-MAR-2003 K.Boussema Made changes for the new bulk approach of the|
17 | accounting engine |
18 | 19-APR-2003 K.Boussema Included Error messages |
19 | 17-JUL-2003 K.Boussema Reviewd the code |
20 | 24-JUL-2003 K.Boussema Updated the error messages |
21 | 26-NOV-2003 K.Boussema Added the cache of GL mapping information |
22 | 28-NOV-2003 K.Boussema Added cache_coa and refreshCcidCache procs |
23 | 18-DEC-2003 K.Boussema Changed to fix bug 3042840,3307761,3268940 |
24 | 3310291 and 3320689 |
25 | 25-MAR-2004 K.Boussema Added the parameter cacheGLMapping to the |
26 | cacheGLMapping procedure |
27 | 14-Mar-2005 K.Boussema Changed for ADR-enhancements. |
28 +===========================================================================*/
29
30
31
32 /*---------------------------------------------------------+
33 | |
34 | Public procedure |
35 | |
36 | cache_coa |
37 | |
38 | caches the accounting flexfield structures, involved in |
39 | the accounting process |
40 +---------------------------------------------------------*/
41 g_error_exists BOOLEAN;
42
43 PROCEDURE get_ccid_errors;
44
45 PROCEDURE cache_coa(
46 p_coa_id IN NUMBER
47 )
48 ;
49
50 /*---------------------------------------------------------+
51 | |
52 | Public procedure |
53 | |
54 | cache_coa |
55 | |
56 | caches the accounting flexfield structures, involved in |
57 | the accounting process. It caches only the accounting |
58 | chart of accounts |
59 +---------------------------------------------------------*/
60
61 PROCEDURE cache_coa(
62 p_coa_id IN NUMBER
63 ,p_target_coa IN VARCHAR2
64 )
65 ;
66
67 /*---------------------------------------------------------+
68 | |
69 | Public procedure |
70 | |
71 | cacheGLMapping |
72 | |
73 | caches the GL chart of acounts mappings, i,volved in the |
74 | accounting process. |
75 | |
76 +---------------------------------------------------------*/
77
78 PROCEDURE cacheGLMapping(
79 p_sla_coa_mapping_name IN VARCHAR2
80 , p_sla_coa_mapping_id IN NUMBER
81 , p_dynamic_inserts_flag IN VARCHAR2
82 )
83 ;
84
85
86
87
88 /*-------------------------------------------------------------+
89 | |
90 | Public function |
91 | |
92 | get_flex_segment_value |
93 | |
94 | retrieves the segment value from key flexfield combination |
95 | |
96 +-------------------------------------------------------------*/
97 -- replaces get_flexfield_segment()
98 FUNCTION get_flex_segment_value(
99 p_combination_id IN NUMBER
100 ,p_segment_code IN VARCHAR2
101 ,p_id_flex_code IN VARCHAR2
102 ,p_flex_application_id IN NUMBER
103 ,p_application_short_name IN VARCHAR2
104 ,p_source_code IN VARCHAR2 DEFAULT NULL
105 ,p_source_type_code IN VARCHAR2 DEFAULT NULL
106 ,p_source_application_id IN NUMBER DEFAULT NULL
107 ,p_component_type IN VARCHAR2
108 ,p_component_code IN VARCHAR2
109 ,p_component_type_code IN VARCHAR2
110 ,p_component_appl_id IN INTEGER
111 ,p_amb_context_code IN VARCHAR2
112 ,p_entity_code IN VARCHAR2 DEFAULT NULL
113 ,p_event_class_code IN VARCHAR2 DEFAULT NULL
114 ,p_ae_header_id IN NUMBER DEFAULT NULL
115 )
116 RETURN VARCHAR2
117 ;
118
119 /*-------------------------------------------------------------+
120 | |
121 | Public function |
122 | |
123 | get_flex_segment_desc |
124 | |
125 | retrieves the segment description for a given segment code |
126 | |
127 +--------------------------------------------------------------*/
128
129 --replaces FUNCTION get_flexfield_description()
130 FUNCTION get_flex_segment_desc(
131 p_combination_id IN NUMBER
132 ,p_segment_code IN VARCHAR2
133 ,p_id_flex_code IN VARCHAR2
134 ,p_flex_application_id IN NUMBER
135 ,p_application_short_name IN VARCHAR2
136 ,p_source_code IN VARCHAR2
137 ,p_source_type_code IN VARCHAR2
138 ,p_source_application_id IN NUMBER
139 ,p_component_type IN VARCHAR2
140 ,p_component_code IN VARCHAR2
141 ,p_component_type_code IN VARCHAR2
142 ,p_component_appl_id IN INTEGER
143 ,p_amb_context_code IN VARCHAR2
144 ,p_ae_header_id IN NUMBER
145 )
146 RETURN VARCHAR2
147 ;
148
149 /*-----------------------------------------------------+
150 | |
151 | Public function |
152 | |
153 | get_segment_code |
154 | |
155 | Returns the segment code for a given key flexfield |
156 | attribute. |
157 | |
158 +-----------------------------------------------------*/
159 -- replaces FUNCTION get_segment_qualifier()
160 FUNCTION get_segment_code(
161 p_flex_application_id IN NUMBER
162 , p_application_short_name IN VARCHAR2
163 , p_id_flex_code IN VARCHAR2
164 , p_id_flex_num IN NUMBER
165 , p_segment_qualifier IN VARCHAR2
166 , p_component_type IN VARCHAR2
167 , p_component_code IN VARCHAR2
168 , p_component_type_code IN VARCHAR2
169 , p_component_appl_id IN INTEGER
170 , p_amb_context_code IN VARCHAR2
171 , p_entity_code IN VARCHAR2
172 , p_event_class_code IN VARCHAR2
173 )
174 RETURN VARCHAR2
175 ;
176
177
178 /*---------------------------------------------------------------+
179 | |
180 | Public procedure |
181 | |
182 | refreshCCID |
183 | |
184 | refresh key flexfield combination cache |
185 | |
186 +---------------------------------------------------------------*/
187
188 PROCEDURE refreshCCID
189 ;
190
191 /*---------------------------------------------------------------+
192 | |
193 | Public procedure |
194 | |
195 | refreshCcidCache |
196 | |
197 | refresh the accounts cache |
198 | |
199 +---------------------------------------------------------------*/
200
201 PROCEDURE refreshCcidCache
202 ;
203
204 /*-------------------------------------------------------------+
205 | |
206 | Public function |
207 | |
208 | GetCcid |
209 | |
210 | Call AOL routine to create the new ccid, when the ccid does |
211 | not exist in the gl_code_combinations table. It calls the |
212 | AOL API FND_FLEX_EXT.get_combination_id. |
213 | |
214 +-------------------------------------------------------------*/
215
216 FUNCTION GetCcid(
217 p_segment1 IN VARCHAR2
218 , p_segment2 IN VARCHAR2
219 , p_segment3 IN VARCHAR2
220 , p_segment4 IN VARCHAR2
221 , p_segment5 IN VARCHAR2
222 , p_segment6 IN VARCHAR2
223 , p_segment7 IN VARCHAR2
224 , p_segment8 IN VARCHAR2
225 , p_segment9 IN VARCHAR2
226 , p_segment10 IN VARCHAR2
227 , p_segment11 IN VARCHAR2
228 , p_segment12 IN VARCHAR2
229 , p_segment13 IN VARCHAR2
230 , p_segment14 IN VARCHAR2
231 , p_segment15 IN VARCHAR2
232 , p_segment16 IN VARCHAR2
233 , p_segment17 IN VARCHAR2
234 , p_segment18 IN VARCHAR2
235 , p_segment19 IN VARCHAR2
236 , p_segment20 IN VARCHAR2
237 , p_segment21 IN VARCHAR2
238 , p_segment22 IN VARCHAR2
239 , p_segment23 IN VARCHAR2
240 , p_segment24 IN VARCHAR2
241 , p_segment25 IN VARCHAR2
242 , p_segment26 IN VARCHAR2
243 , p_segment27 IN VARCHAR2
244 , p_segment28 IN VARCHAR2
245 , p_segment29 IN VARCHAR2
246 , p_segment30 IN VARCHAR2
247 , p_chart_of_accounts_id IN NUMBER
248 )
249 RETURN NUMBER
250 ;
251
252
253 /*-----------------------------------------------------------------------+
254 | |
255 | Public function |
256 | |
257 | BuildCcids |
258 | |
259 | builds the new accounting ccids. It returns the number of rows updated |
260 | |
261 +-----------------------------------------------------------------------*/
262 FUNCTION BuildCcids
263 RETURN NUMBER
264 ;
265
266
267 END xla_ae_code_combination_pkg; -- end of package spec