[Home] [Help]
PACKAGE: APPS.XLA_AE_CODE_COMBINATION_PKG
Source
1 PACKAGE xla_ae_code_combination_pkg AS
2 /* $Header: xlajecci.pkh 120.11 2005/03/29 14:47:40 kboussem 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
42 PROCEDURE cache_coa(
43 p_coa_id IN NUMBER
44 )
45 ;
46
47 /*---------------------------------------------------------+
48 | |
49 | Public procedure |
50 | |
51 | cache_coa |
52 | |
53 | caches the accounting flexfield structures, involved in |
54 | the accounting process. It caches only the accounting |
55 | chart of accounts |
56 +---------------------------------------------------------*/
57
58 PROCEDURE cache_coa(
59 p_coa_id IN NUMBER
60 ,p_target_coa IN VARCHAR2
61 )
62 ;
63
64 /*---------------------------------------------------------+
65 | |
66 | Public procedure |
67 | |
68 | cacheGLMapping |
69 | |
70 | caches the GL chart of acounts mappings, i,volved in the |
71 | accounting process. |
72 | |
73 +---------------------------------------------------------*/
74
75 PROCEDURE cacheGLMapping(
76 p_sla_coa_mapping_name IN VARCHAR2
77 , p_sla_coa_mapping_id IN NUMBER
78 , p_dynamic_inserts_flag IN VARCHAR2
79 )
80 ;
81
82
83
84
85 /*-------------------------------------------------------------+
86 | |
87 | Public function |
88 | |
89 | get_flex_segment_value |
90 | |
91 | retrieves the segment value from key flexfield combination |
92 | |
93 +-------------------------------------------------------------*/
94 -- replaces get_flexfield_segment()
95 FUNCTION get_flex_segment_value(
96 p_combination_id IN NUMBER
97 ,p_segment_code IN VARCHAR2
98 ,p_id_flex_code IN VARCHAR2
99 ,p_flex_application_id IN NUMBER
100 ,p_application_short_name IN VARCHAR2
101 ,p_source_code IN VARCHAR2 DEFAULT NULL
102 ,p_source_type_code IN VARCHAR2 DEFAULT NULL
103 ,p_source_application_id IN NUMBER DEFAULT NULL
104 ,p_component_type IN VARCHAR2
105 ,p_component_code IN VARCHAR2
106 ,p_component_type_code IN VARCHAR2
107 ,p_component_appl_id IN INTEGER
108 ,p_amb_context_code IN VARCHAR2
109 ,p_entity_code IN VARCHAR2 DEFAULT NULL
110 ,p_event_class_code IN VARCHAR2 DEFAULT NULL
111 ,p_ae_header_id IN NUMBER DEFAULT NULL
112 )
113 RETURN VARCHAR2
114 ;
115
116 /*-------------------------------------------------------------+
117 | |
118 | Public function |
119 | |
120 | get_flex_segment_desc |
121 | |
122 | retrieves the segment description for a given segment code |
123 | |
124 +--------------------------------------------------------------*/
125
126 --replaces FUNCTION get_flexfield_description()
127 FUNCTION get_flex_segment_desc(
128 p_combination_id IN NUMBER
129 ,p_segment_code IN VARCHAR2
130 ,p_id_flex_code IN VARCHAR2
131 ,p_flex_application_id IN NUMBER
132 ,p_application_short_name IN VARCHAR2
133 ,p_source_code IN VARCHAR2
134 ,p_source_type_code IN VARCHAR2
135 ,p_source_application_id IN NUMBER
136 ,p_component_type IN VARCHAR2
137 ,p_component_code IN VARCHAR2
138 ,p_component_type_code IN VARCHAR2
139 ,p_component_appl_id IN INTEGER
140 ,p_amb_context_code IN VARCHAR2
141 ,p_ae_header_id IN NUMBER
142 )
143 RETURN VARCHAR2
144 ;
145
146 /*-----------------------------------------------------+
147 | |
148 | Public function |
149 | |
150 | get_segment_code |
151 | |
152 | Returns the segment code for a given key flexfield |
153 | attribute. |
154 | |
155 +-----------------------------------------------------*/
156 -- replaces FUNCTION get_segment_qualifier()
157 FUNCTION get_segment_code(
158 p_flex_application_id IN NUMBER
159 , p_application_short_name IN VARCHAR2
160 , p_id_flex_code IN VARCHAR2
161 , p_id_flex_num IN NUMBER
162 , p_segment_qualifier IN VARCHAR2
163 , p_component_type IN VARCHAR2
164 , p_component_code IN VARCHAR2
165 , p_component_type_code IN VARCHAR2
166 , p_component_appl_id IN INTEGER
167 , p_amb_context_code IN VARCHAR2
168 , p_entity_code IN VARCHAR2
169 , p_event_class_code IN VARCHAR2
170 )
171 RETURN VARCHAR2
172 ;
173
174
175 /*---------------------------------------------------------------+
176 | |
177 | Public procedure |
178 | |
179 | refreshCCID |
180 | |
181 | refresh key flexfield combination cache |
182 | |
183 +---------------------------------------------------------------*/
184
185 PROCEDURE refreshCCID
186 ;
187
188 /*---------------------------------------------------------------+
189 | |
190 | Public procedure |
191 | |
192 | refreshCcidCache |
193 | |
194 | refresh the accounts cache |
195 | |
196 +---------------------------------------------------------------*/
197
198 PROCEDURE refreshCcidCache
199 ;
200
201 /*-------------------------------------------------------------+
202 | |
203 | Public function |
204 | |
205 | GetCcid |
206 | |
207 | Call AOL routine to create the new ccid, when the ccid does |
208 | not exist in the gl_code_combinations table. It calls the |
209 | AOL API FND_FLEX_EXT.get_combination_id. |
210 | |
211 +-------------------------------------------------------------*/
212
213 FUNCTION GetCcid(
214 p_segment1 IN VARCHAR2
215 , p_segment2 IN VARCHAR2
216 , p_segment3 IN VARCHAR2
217 , p_segment4 IN VARCHAR2
218 , p_segment5 IN VARCHAR2
219 , p_segment6 IN VARCHAR2
220 , p_segment7 IN VARCHAR2
221 , p_segment8 IN VARCHAR2
222 , p_segment9 IN VARCHAR2
223 , p_segment10 IN VARCHAR2
224 , p_segment11 IN VARCHAR2
225 , p_segment12 IN VARCHAR2
226 , p_segment13 IN VARCHAR2
227 , p_segment14 IN VARCHAR2
228 , p_segment15 IN VARCHAR2
229 , p_segment16 IN VARCHAR2
230 , p_segment17 IN VARCHAR2
231 , p_segment18 IN VARCHAR2
232 , p_segment19 IN VARCHAR2
233 , p_segment20 IN VARCHAR2
234 , p_segment21 IN VARCHAR2
235 , p_segment22 IN VARCHAR2
236 , p_segment23 IN VARCHAR2
237 , p_segment24 IN VARCHAR2
238 , p_segment25 IN VARCHAR2
239 , p_segment26 IN VARCHAR2
240 , p_segment27 IN VARCHAR2
241 , p_segment28 IN VARCHAR2
242 , p_segment29 IN VARCHAR2
243 , p_segment30 IN VARCHAR2
244 , p_chart_of_accounts_id IN NUMBER
245 )
246 RETURN NUMBER
247 ;
248
249
250 /*-----------------------------------------------------------------------+
251 | |
252 | Public function |
253 | |
254 | BuildCcids |
255 | |
256 | builds the new accounting ccids. It returns the number of rows updated |
257 | |
258 +-----------------------------------------------------------------------*/
259 FUNCTION BuildCcids
260 RETURN NUMBER
261 ;
262
263
264 END xla_ae_code_combination_pkg; -- end of package spec