[Home] [Help]
PACKAGE: APPS.XLA_AE_LINES_PKG
Source
1 PACKAGE XLA_AE_LINES_PKG AS
2 /* $Header: xlajelns.pkh 120.44.12010000.1 2008/07/29 10:05:44 appldev 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_lines_pkg |
10 | |
11 | DESCRIPTION |
12 | |
13 | |
14 | HISTORY |
15 | 20-NOV-2002 K.Boussema Created |
16 | 10-JAN-2003 K.Boussema Removed gl_sl_link_id column from temp table |
17 | Added 'dbdrv' command |
18 | 11-MAR-2003 K.Boussema Made changes for the new bulk approach of the|
19 | accounting engine |
20 | 03-APR-2003 K.Boussema Included Analytical criteria feature |
21 | 19-APR-2003 K.Boussema Included Error messages |
22 | 06-MAI-2003 K.Boussema Modified to fix bug 2936066(Unbalanced JE) |
23 | 27-MAI-2003 K.Boussema Renamed code_combination_status by |
24 | code_combination_status_flag |
25 | 17-JUL-2003 K.Boussema Reviewd the code |
26 | 24-JUL-2003 K.Boussema Updated the error messages |
27 | 10-SEP-2003 K.Boussema Changed to fix bug3095206:Accounting Reversal|
28 | 13-NOV-2003 K.Boussema Changed to store Accounting and transaction |
29 | coa ids defined in Account Derivation rules |
30 | 05-DEC-2003 K.Boussema Changed the code to fix bug3289875 |
31 | 18-DEC-2003 K.Boussema Changed to fix bug 3042840,3307761,3268940 |
32 | 3310291 and 3320689 |
33 | 05-FEB-2004 S.Singhania Changes based on bug 3419803. Modified the |
34 | structure t_rec_lines to remove the |
35 | attribute representing the column |
36 | TAX_REC_NREC_SUMMARY_DIST_REF. |
37 | 17-FEB-2004 K.Boussema Removed array_accounting_line_name and |
38 | array_accounting_line_owner from t_rec_lines |
39 | 17-MAY-2004 W.Shen change for attribute enhancement project |
40 | add StandardAccountingReversal to spec |
41 | 21-Sep-2004 S.Singhania Made ffg changes for the Bulk Performance: |
42 | - Added new structures and global variables|
43 | - Removed the routines SetAccountingSource,|
44 | accounting_reversal and StandardAccountin|
45 | gReversal |
46 | - Added routines AccountingReversal, |
47 | set_ae_header_id, SetLineAcctAttrs, |
48 | SetAcctReversalAttrs, SetTrxReversalAttrs|
49 | 09-MAR-2005 W.Shen Ledger Currency Project. |
50 | 14-Mar-2005 K.Boussema Changed for ADR-enhancements. |
51 | 28-Mar-2005 A.Wan Changed for Business Flow. 4219869 |
52 | 11-Jul-2005 A.Wan Changed for MPA. 4642811 |
53 | 22-Sep-2005 S.Singhania Bug 4544725. Implemented Business Flows and |
54 | Reversals for Non-Upgraded JEs. |
55 | 18-Oct-2005 V. Kumar Removed code for Analytical Criteria |
56 | 20-Jan-2006 W.Chan 4946123 - BC changes for prior entry |
57 | 09-Feb-2006 V. Kumar 4955764 - Added array_gl_date to t_rec_lines |
58 | 27-Mar-2006 A.Wan 5108415 - performance fix for Incomplete |
59 | MPA/AccRev. Added following: |
60 | - type t_rec_incomplete_mpa_acc_rev |
61 | - global g_incomplete_mpa_acc_LR |
62 | - global g_incomplete_mpa_acc_TR |
63 | - p_accounting_mode to accounting |
64 | reversal. |
65 | 15-Apr-2006 A.Wan 5132302 - add Applied To Amount for Gain/Loss |
66 | 19-May-2005 V.Kumar 5229264 -Modified procedure SetTrxReversalAttrs|
67 | 28-Jul-2006 A.Wan 5357406 - add p_ledger_id to bflow prior entry |
68 | 26-jan-2007 A.Wan 5845547 - upgrade fail for not upgraded bflow |
69 | and reversal transactions. Add |
70 | upgrade party attributes. |
71 | 14-Dec-2007 V.Swapna 6648062 - Added override_acctd_amt_flag |
72 | to t_rec_lines to be used in the |
73 | BusinessFlowPriorEntries procedure |
74 +===========================================================================*/
75 --+==========================================================================+
76 --| |
77 --| |
78 --| PUBLIC structures |
79 --| |
80 --| |
81 --+==========================================================================+
82 --
83 --
84 TYPE t_array_number IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
85 TYPE t_array_integer IS TABLE OF INTEGER INDEX BY BINARY_INTEGER;
86 TYPE t_array_date IS TABLE OF DATE INDEX BY BINARY_INTEGER;
87 TYPE t_array_char1 IS TABLE OF VARCHAR2(1) INDEX BY BINARY_INTEGER;
88 TYPE t_array_char30 IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
89 TYPE t_array_char240 IS TABLE OF VARCHAR2(240) INDEX BY BINARY_INTEGER;
90 TYPE t_array_char2000 IS TABLE OF VARCHAR2(2000) INDEX BY BINARY_INTEGER;
91
92 TYPE t_rec_acct_attrs IS RECORD
93 (array_acct_attr_code t_array_char30
94 ,array_num_value t_array_number
95 ,array_char_value t_array_char2000
96 ,array_date_value t_array_date);
97 --
98 --
99 TYPE t_rec_lines IS RECORD (
100 array_ae_header_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
101 ,array_line_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
102 ,array_extract_line_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
103 ,array_accounting_class XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
104 ,array_rounding_class XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
105 ,array_doc_rounding_level XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
106 ,array_gain_or_loss_ref XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
107 ,array_event_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
108 ,array_event_type_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
109 ,array_line_defn_owner_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
110 ,array_line_defn_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
111 ,array_accounting_line_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
112 ,array_accounting_line_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V1L
113 ,array_calculate_acctd_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V1L
114 ,array_calculate_g_l_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V1L
115 ,array_gain_or_loss_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V1L
116 --
117 -- line flexfield accounts
118 --
119 ,array_accounting_coa_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
120 ,array_transaction_coa_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
121 ,array_sl_coa_mapping_name XLA_AE_JOURNAL_ENTRY_PKG.t_array_V33L
122 ,array_ccid_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
123 ,array_ccid XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
124 --
125 ,array_segment1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
126 ,array_segment2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
127 ,array_segment3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
128 ,array_segment4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
129 ,array_segment5 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
130 ,array_segment6 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
131 ,array_segment7 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
132 ,array_segment8 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
133 ,array_segment9 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
134 ,array_segment10 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
135 ,array_segment11 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
136 ,array_segment12 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
137 ,array_segment13 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
138 ,array_segment14 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
139 ,array_segment15 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
140 ,array_segment16 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
141 ,array_segment17 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
142 ,array_segment18 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
143 ,array_segment19 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
144 ,array_segment20 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
145 ,array_segment21 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
146 ,array_segment22 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
147 ,array_segment23 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
148 ,array_segment24 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
149 ,array_segment25 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
150 ,array_segment26 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
151 ,array_segment27 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
152 ,array_segment28 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
153 ,array_segment29 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
154 ,array_segment30 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
155 ,alt_array_ccid_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
156 ,alt_array_ccid XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
157 ,alt_array_segment1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
158 ,alt_array_segment2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
159 ,alt_array_segment3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
160 ,alt_array_segment4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
161 ,alt_array_segment5 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
162 ,alt_array_segment6 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
163 ,alt_array_segment7 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
164 ,alt_array_segment8 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
165 ,alt_array_segment9 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
166 ,alt_array_segment10 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
167 ,alt_array_segment11 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
168 ,alt_array_segment12 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
169 ,alt_array_segment13 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
170 ,alt_array_segment14 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
171 ,alt_array_segment15 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
172 ,alt_array_segment16 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
173 ,alt_array_segment17 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
174 ,alt_array_segment18 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
175 ,alt_array_segment19 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
176 ,alt_array_segment20 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
177 ,alt_array_segment21 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
178 ,alt_array_segment22 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
179 ,alt_array_segment23 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
180 ,alt_array_segment24 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
181 ,alt_array_segment25 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
182 ,alt_array_segment26 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
183 ,alt_array_segment27 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
184 ,alt_array_segment28 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
185 ,alt_array_segment29 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
186 ,alt_array_segment30 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
187 --
188 -- Option lines
189 --
190 ,array_gl_transfer_mode XLA_AE_JOURNAL_ENTRY_PKG.t_array_V1L
191 ,array_natural_side_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V1L
192 ,array_acct_entry_type_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V1L
193 ,array_switch_side_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V1L
194 ,array_merge_duplicate_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V1L
195 --
196 -- line amounts
197 --
198 ,array_entered_amount XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
199 ,array_ledger_amount XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
200 ,array_entered_dr XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
201 ,array_entered_cr XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
202 ,array_accounted_dr XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
203 ,array_accounted_cr XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
204 ,array_currency_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V15L
205 ,array_currency_mau XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
206 ,array_curr_conversion_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date
207 ,array_curr_conversion_rate XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
208 ,array_curr_conversion_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
209 ,array_description XLA_AE_JOURNAL_ENTRY_PKG.t_array_V4000L
210 --
211 -- line descriptions
212 --
213 ,array_party_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
214 ,array_party_site_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
215 ,array_party_type_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V1L
216 --
217 ,array_statistical_amount XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
218 ,array_ussgl_transaction XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
219 --
220 ,array_jgzz_recon_ref XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
221 -- distribution links
222 --
223 ,array_distribution_id_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
224 ,array_distribution_id_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
225 ,array_distribution_id_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
226 ,array_distribution_id_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
227 ,array_distribution_id_char_5 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
228 ,array_sys_distribution_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
229 ,array_distribution_id_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
230 ,array_distribution_id_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
231 ,array_distribution_id_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
232 ,array_distribution_id_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
233 ,array_distribution_id_num_5 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
234 --
235 -- reversal attributes
236 --
237 ,array_rev_dist_id_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
238 ,array_rev_dist_id_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
239 ,array_rev_dist_id_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
240 ,array_rev_dist_id_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
241 ,array_rev_dist_id_char_5 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
242 ,array_rev_dist_id_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
243 ,array_rev_dist_id_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
244 ,array_rev_dist_id_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
245 ,array_rev_dist_id_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
246 ,array_rev_dist_id_num_5 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
247 ,array_rev_dist_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
248 --
249 -----------------------------------------------------------------------------------------
250 -- 4262811 MPA
251 -----------------------------------------------------------------------------------------
252 ,array_header_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
253 ,array_mpa_acc_entry_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V1L
254 ,array_mpa_option XLA_AE_JOURNAL_ENTRY_PKG.t_array_V1L
255 ,array_mpa_start_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_DATE
256 ,array_mpa_end_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_DATE
257
258 -- deferred info -- REMOVED for 4262811 MPA
259 --
260 -- array_deferred_indicator XLA_AE_JOURNAL_ENTRY_PKG.t_array_V1L,
261 -- array_deferred_start_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date,
262 -- array_deferred_end_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date,
263 -- array_deferred_no_period XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num,
264 -- array_deferred_period_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V1L,
265 --
266 -- reversal info
267 --
268 ,array_acc_reversal_option XLA_AE_JOURNAL_ENTRY_PKG.t_array_V1L
269 --
270 -- tax info
271 --
272 ,array_tax_line_ref XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
273 ,array_tax_summary_line_ref XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
274 ,array_tax_rec_nrec_dist_ref XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
275 --
276 -- bulk performance
277 ,array_balance_type_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
278 ,array_ledger_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
279 --
280 ,array_anc_balance_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V1L
281 ,array_anc_id_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
282 ,array_anc_id_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
283 ,array_anc_id_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
284 ,array_anc_id_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
285 ,array_anc_id_5 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
286 ,array_anc_id_6 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
287 ,array_anc_id_7 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
288 ,array_anc_id_8 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
289 ,array_anc_id_9 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
290 ,array_anc_id_10 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
291 ,array_anc_id_11 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
292 ,array_anc_id_12 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
293 ,array_anc_id_13 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
294 ,array_anc_id_14 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
295 ,array_anc_id_15 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
296 ,array_anc_id_16 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
297 ,array_anc_id_17 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
298 ,array_anc_id_18 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
299 ,array_anc_id_19 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
300 ,array_anc_id_20 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
301 ,array_anc_id_21 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
302 ,array_anc_id_22 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
303 ,array_anc_id_23 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
304 ,array_anc_id_24 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
305 ,array_anc_id_25 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
306 ,array_anc_id_26 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
307 ,array_anc_id_27 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
308 ,array_anc_id_28 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
309 ,array_anc_id_29 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
310 ,array_anc_id_30 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
311 ,array_anc_id_31 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
312 ,array_anc_id_32 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
313 ,array_anc_id_33 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
314 ,array_anc_id_34 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
315 ,array_anc_id_35 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
316 ,array_anc_id_36 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
317 ,array_anc_id_37 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
318 ,array_anc_id_38 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
319 ,array_anc_id_39 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
320 ,array_anc_id_40 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
321 ,array_anc_id_41 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
322 ,array_anc_id_42 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
323 ,array_anc_id_43 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
324 ,array_anc_id_44 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
325 ,array_anc_id_45 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
326 ,array_anc_id_46 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
327 ,array_anc_id_47 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
328 ,array_anc_id_48 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
329 ,array_anc_id_49 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
330 ,array_anc_id_50 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
331 ,array_anc_id_51 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
332 ,array_anc_id_52 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
333 ,array_anc_id_53 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
334 ,array_anc_id_54 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
335 ,array_anc_id_55 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
336 ,array_anc_id_56 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
337 ,array_anc_id_57 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
338 ,array_anc_id_58 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
339 ,array_anc_id_59 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
340 ,array_anc_id_60 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
341 ,array_anc_id_61 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
342 ,array_anc_id_62 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
343 ,array_anc_id_63 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
344 ,array_anc_id_64 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
345 ,array_anc_id_65 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
346 ,array_anc_id_66 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
347 ,array_anc_id_67 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
348 ,array_anc_id_68 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
349 ,array_anc_id_69 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
350 ,array_anc_id_70 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
351 ,array_anc_id_71 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
352 ,array_anc_id_72 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
353 ,array_anc_id_73 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
354 ,array_anc_id_74 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
355 ,array_anc_id_75 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
356 ,array_anc_id_76 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
357 ,array_anc_id_77 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
358 ,array_anc_id_78 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
359 ,array_anc_id_79 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
360 ,array_anc_id_80 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
361 ,array_anc_id_81 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
362 ,array_anc_id_82 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
363 ,array_anc_id_83 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
364 ,array_anc_id_84 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
365 ,array_anc_id_85 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
366 ,array_anc_id_86 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
367 ,array_anc_id_87 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
368 ,array_anc_id_88 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
369 ,array_anc_id_89 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
370 ,array_anc_id_90 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
371 ,array_anc_id_91 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
372 ,array_anc_id_92 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
373 ,array_anc_id_93 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
374 ,array_anc_id_94 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
375 ,array_anc_id_95 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
376 ,array_anc_id_96 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
377 ,array_anc_id_97 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
378 ,array_anc_id_98 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
379 ,array_anc_id_99 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
380 ,array_anc_id_100 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
381
382 --
383 ,array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Int
384 ,array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Int
385 ,array_reversal_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
386 --------------------------------------
387 -- 4219869
388 -- Business Flow Applied To Attributes
389 --------------------------------------
390 ,array_business_method_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
391 ,array_business_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
392 ,array_inherit_desc_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V1L
393 ,array_bflow_application_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
394
395 ,array_bflow_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
396 ,array_bflow_source_id_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
397 ,array_bflow_source_id_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
398 ,array_bflow_source_id_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
399 ,array_bflow_source_id_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
400 ,array_bflow_source_id_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
401 ,array_bflow_source_id_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
402 ,array_bflow_source_id_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
403 ,array_bflow_source_id_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
404
405 ,array_bflow_distribution_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
406 ,array_bflow_dist_id_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
407 ,array_bflow_dist_id_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
408 ,array_bflow_dist_id_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
409 ,array_bflow_dist_id_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
410 ,array_bflow_dist_id_num_5 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
411 ,array_bflow_dist_id_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
412 ,array_bflow_dist_id_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
413 ,array_bflow_dist_id_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
414 ,array_bflow_dist_id_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
415 ,array_bflow_dist_id_char_5 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
416 ,array_override_acctd_amt_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
417 ,array_bflow_applied_to_amt XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num -- 5132302
418
419 ,array_encumbrance_type_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Int
420 ,array_gl_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date --4955764
421
422 -------------------------------------------------
423 --
424 --Upgrade Attributes
425 --
426 -------------------------------------------------
427
428 ,array_actual_upg_option XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
429 ,array_actual_upg_dr_ccid XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
430 ,array_actual_upg_cr_ccid XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
431 ,array_actual_upg_dr_ent_amt XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
432 ,array_actual_upg_cr_ent_amt XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
433 ,array_actual_upg_dr_ent_curr XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
434 ,array_actual_upg_cr_ent_curr XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
435 ,array_actual_upg_dr_ledger_amt XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
436 ,array_actual_upg_cr_ledger_amt XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
437 ,array_actual_upg_dr_acct_class XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
438 ,array_actual_upg_cr_acct_class XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
439 ,array_actual_upg_dr_xrate XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
440 ,array_actual_upg_dr_xrate_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
441 ,array_actual_upg_dr_xdate XLA_AE_JOURNAL_ENTRY_PKG.t_array_DATE
442 ,array_actual_upg_cr_xrate XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
443 ,array_actual_upg_cr_xrate_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
444 ,array_actual_upg_cr_xdate XLA_AE_JOURNAL_ENTRY_PKG.t_array_DATE
445 ,array_enc_upg_option XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
446 ,array_enc_upg_dr_ccid XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
447 ,array_enc_upg_cr_ccid XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
448 ,array_upg_dr_enc_type_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
449 ,array_upg_cr_enc_type_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
450 ,array_enc_upg_dr_ent_amt XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
451 ,array_enc_upg_cr_ent_amt XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
452 ,array_enc_upg_dr_ent_curr XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
453 ,array_enc_upg_cr_ent_curr XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
454 ,array_enc_upg_dr_ledger_amt XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
455 ,array_enc_upg_cr_ledger_amt XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
456 ,array_enc_upg_dr_acct_class XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
457 ,array_enc_upg_cr_acct_class XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
458 -- 5845547
459 ,array_upg_party_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
460 ,array_upg_party_site_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
461 ,array_upg_party_type_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V1L
462 --
463 -------------------------------------------------
464 --
465 --Allocation Attributes
466 --
467 -------------------------------------------------
468 ,array_alloct_application_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
469 ,array_alloct_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
470 ,array_alloct_source_id_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
471 ,array_alloct_source_id_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
472 ,array_alloct_source_id_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
473 ,array_alloct_source_id_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
474 ,array_alloct_source_id_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
475 ,array_alloct_source_id_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
476 ,array_alloct_source_id_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
477 ,array_alloct_source_id_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
478 ,array_alloct_distribution_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
479 ,array_alloct_dist_id_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
480 ,array_alloct_dist_id_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
481 ,array_alloct_dist_id_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
482 ,array_alloct_dist_id_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
483 ,array_alloct_dist_id_num_5 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
484 ,array_alloct_dist_id_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
485 ,array_alloct_dist_id_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
486 ,array_alloct_dist_id_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
487 ,array_alloct_dist_id_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
488 ,array_alloct_dist_id_char_5 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
489 );
490
491 -- 5108415 for incomplete MPA/AccRev reversal
492 TYPE t_rec_incomplete_mpa_acc_rev IS RECORD (
493 l_array_ae_header_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_num,
494 l_array_ae_line_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_num,
495 l_array_parent_ae_header XLA_AE_JOURNAL_ENTRY_PKG.t_array_num
496 );
497
498 --
499 --+==========================================================================+
500 --| |
501 --| |
502 --| GLobal variables |
503 --| |
504 --| |
505 --+==========================================================================+
506 --
507 g_rec_lines t_rec_lines;
508 g_null_lines t_rec_lines;
509 --
510 g_override_acctd_amt_flag VARCHAR2(1);
511 g_LineNumber NUMBER;
512 g_ExtractLine NUMBER;
513 g_ActualLineNum NUMBER;
514 g_BudgetLineNum NUMBER;
515 g_EncumbLineNum NUMBER;
516 --
517 g_temp_line_num NUMBER;
518 --
519 g_incomplete_mpa_acc_LR t_rec_incomplete_mpa_acc_rev; -- 5108415 for incomplete MPA/AccRev line reversal
520 g_incomplete_mpa_acc_TR t_rec_incomplete_mpa_acc_rev; -- 5108415 for incomplete MPA/AccRev transaction reversal
521
522 g_hist_reversal_error_exists BOOLEAN DEFAULT FALSE; --bug7135700
523
524
525 --
526 --====================================================================
527 --
528 --
529 --
530 --
531 --
532 -- STANDARD ACCOUNTING PROCESS
533 --
534 --
535 --
536 --
537 --
538 --
539 --
540 --
541 --
542 --
543 --
544 --
545 --
546 --
547 --
548 --
549 --====================================================================
550 --
551 /*======================================================================+
552 | |
553 | Public Procedure |
554 | |
555 | |
556 +======================================================================*/
557 PROCEDURE InitLines
558 ;
559 --
560 --
561 /*======================================================================+
562 | |
563 | Public Procedure |
564 | |
565 | |
566 +======================================================================*/
567 PROCEDURE SetExtractLine(p_extract_line IN NUMBER)
568 ;
569
570 --
571 /*======================================================================+
572 | |
573 | Public Procedure |
574 | |
575 | |
576 +======================================================================*/
577 PROCEDURE SetNullLine
578 ;
579
580 --
581 /*======================================================================+
582 | |
583 | Public Procedure |
584 | |
585 | |
586 +======================================================================*/
587 PROCEDURE SetNewLine
588 ;
589
590 --
591 /*======================================================================+
592 | |
593 | Public Procedure |
594 | |
595 | |
596 +======================================================================*/
597 PROCEDURE SetLineDescription( p_description IN VARCHAR2
598 ,p_ae_header_id IN NUMBER DEFAULT NULL)
599 ;
600
601 --
602 /*======================================================================+
603 | |
604 | Public Procedure |
605 | SetCcid |
606 | |
607 +======================================================================*/
608 PROCEDURE set_ccid(
609 p_code_combination_id IN NUMBER
610 , p_value_type_code IN VARCHAR2
611 , p_transaction_coa_id IN NUMBER
612 , p_accounting_coa_id IN NUMBER
613 , p_adr_code IN VARCHAR2
614 , p_adr_type_code IN VARCHAR2
615 , p_component_type IN VARCHAR2
616 , p_component_code IN VARCHAR2
617 , p_component_type_code IN VARCHAR2
618 , p_component_appl_id IN INTEGER
619 , p_amb_context_code IN VARCHAR2
620 , p_side IN VARCHAR2
621 )
622 ;
623 --
624 /*======================================================================+
625 | |
626 | Public Procedure |
627 | SetSegment |
628 | |
629 +======================================================================*/
630 PROCEDURE set_segment(
631 p_to_segment_code IN VARCHAR2
632 , p_segment_value IN VARCHAR2
633 , p_from_segment_code IN VARCHAR2
634 , p_from_combination_id IN NUMBER
635 , p_value_type_code IN VARCHAR2
636 , p_transaction_coa_id IN NUMBER
637 , p_accounting_coa_id IN NUMBER
638 , p_flexfield_segment_code IN VARCHAR2
639 , p_flex_value_set_id IN NUMBER
640 , p_adr_code IN VARCHAR2
641 , p_adr_type_code IN VARCHAR2
642 , p_component_type IN VARCHAR2
643 , p_component_code IN VARCHAR2
644 , p_component_type_code IN VARCHAR2
645 , p_component_appl_id IN INTEGER
646 , p_amb_context_code IN VARCHAR2
647 , p_entity_code IN VARCHAR2
648 , p_event_class_code IN VARCHAR2
649 , p_side IN VARCHAR2
650 )
651 ;
652
653
654 /*======================================================================+
655 | |
656 | Public Procedure |
657 | |
658 | |
659 +======================================================================*/
660 PROCEDURE SetAcctLineType(
661 p_component_type IN VARCHAR2
662 , p_event_type_code IN VARCHAR2
663 , p_line_definition_owner_code IN VARCHAR2
664 , p_line_definition_code IN VARCHAR2
665 , p_accounting_line_code IN VARCHAR2
666 , p_accounting_line_type_code IN VARCHAR2
667 , p_accounting_line_appl_id IN INTEGER
668 , p_amb_context_code IN VARCHAR2
669 , p_entity_code IN VARCHAR2
670 , p_event_class_code IN VARCHAR2
671 )
672 ;
673
674 --
675 --
676 /*======================================================================+
677 | |
678 | Public Procedure |
679 | |
680 | |
681 +======================================================================*/
682 FUNCTION SetAcctLineOption(
683 p_natural_side_code IN VARCHAR2
684 , p_gain_or_loss_flag IN VARCHAR2
685 , p_gl_transfer_mode_code IN VARCHAR2
686 , p_acct_entry_type_code IN VARCHAR2
687 , p_switch_side_flag IN VARCHAR2
688 , p_merge_duplicate_code IN VARCHAR2
689 )
690 RETURN NUMBER
691 ;
692 --
693 /*======================================================================+
694 | |
695 | Public Procedure |
696 | |
697 | |
698 +======================================================================*/
699 PROCEDURE SetAcctClass( p_accounting_class_code IN VARCHAR2
700 , p_ae_header_id IN NUMBER DEFAULT NULL
701 )
702 ;
703 --
704 /*======================================================================+
705 | |
706 | Public Function |
707 | |
708 | SetAnalyticalCriteria |
709 | |
710 +======================================================================*/
711 --
712 FUNCTION SetAnalyticalCriteria(
713 p_analytical_criterion_name IN VARCHAR2
714 , p_analytical_criterion_owner IN VARCHAR2
715 , p_analytical_criterion_code IN VARCHAR2
716 , p_amb_context_code IN VARCHAR2
717 , p_balancing_flag IN VARCHAR2
718 --
719 , p_analytical_detail_char_1 IN VARCHAR2 DEFAULT NULL
720 , p_analytical_detail_num_1 IN NUMBER DEFAULT NULL
721 , p_analytical_detail_date_1 IN DATE DEFAULT NULL
722 , p_analytical_detail_char_2 IN VARCHAR2 DEFAULT NULL
723 , p_analytical_detail_num_2 IN NUMBER DEFAULT NULL
724 , p_analytical_detail_date_2 IN DATE DEFAULT NULL
725 , p_analytical_detail_char_3 IN VARCHAR2 DEFAULT NULL
726 , p_analytical_detail_num_3 IN NUMBER DEFAULT NULL
727 , p_analytical_detail_date_3 IN DATE DEFAULT NULL
728 , p_analytical_detail_char_4 IN VARCHAR2 DEFAULT NULL
729 , p_analytical_detail_num_4 IN NUMBER DEFAULT NULL
730 , p_analytical_detail_date_4 IN DATE DEFAULT NULL
731 , p_analytical_detail_char_5 IN VARCHAR2 DEFAULT NULL
732 , p_analytical_detail_num_5 IN NUMBER DEFAULT NULL
733 , p_analytical_detail_date_5 IN DATE DEFAULT NULL
734 , p_ae_header_id IN NUMBER DEFAULT NULL
735 --
736 )
737 RETURN VARCHAR2
738 ;
739
740 --
741 --
742 /*======================================================================+
743 | |
744 | Public Procedure |
745 | |
746 | |
747 +======================================================================*/
748 FUNCTION InsertLines
749 RETURN BOOLEAN
750 ;
751 --
752 --
753 --
754 --====================================================================
755 --
756 --
757 --
758 --
759 --
760 -- REVERSAL ACCOUNTING PROCESS
761 --
762 --
763 --
764 --
765 --
766 --
767 --
768 --
769 --
770 --
771 --
772 --
773 --
774 --
775 --
776 --
777 --====================================================================
778 --
779 --
780 /*======================================================================+
781 | |
782 | PUBLIC Procedure |
783 | |
784 | |
785 +======================================================================*/
786 FUNCTION SetLineNum(
787 p_balance_type_code IN VARCHAR2
788 )
789 RETURN NUMBER
790 ;
791 --
792 /*======================================================================+
793 | |
794 | Public Procedure |
795 | |
796 | |
797 +======================================================================*/
798 PROCEDURE SetRevAccountingSource (
799 p_accounting_source IN VARCHAR2
800 , p_standard_source IN VARCHAR2
801 , p_source_code IN VARCHAR2
802 , p_source_type_code IN VARCHAR2
803 , p_source_application_id IN NUMBER
804 )
805 ;
806 --
807 --
808 /*======================================================================+
809 | |
810 | Public Procedure |
811 | |
812 | |
813 +======================================================================*/
814 PROCEDURE SetRevAccountingSource (
815 p_accounting_source IN VARCHAR2
816 , p_standard_source IN NUMBER
817 , p_source_code IN VARCHAR2
818 , p_source_type_code IN VARCHAR2
819 , p_source_application_id IN NUMBER
820 )
821 ;
822 --
823 /*======================================================================+
824 | |
825 | Public Procedure |
826 | |
827 | |
828 +======================================================================*/
829 PROCEDURE SetRevAccountingSource (
830 p_accounting_source IN VARCHAR2
831 , p_standard_source IN DATE
832 , p_source_code IN VARCHAR2
833 , p_source_type_code IN VARCHAR2
834 , p_source_application_id IN NUMBER
835 )
836 ;
837 --
838 /*======================================================================+
839 | |
840 | Public Procedure |
841 | |
842 | |
843 +======================================================================*/
844
845 --;
846 PROCEDURE AccountingReversal(
847 p_accounting_mode IN VARCHAR2
848 );
849
850 --
851 --
852 /*======================================================================+
853 | |
854 | Public Procedure |
855 | |
856 | |
857 +======================================================================*/
858 PROCEDURE RefreshLines
859 ;
860
861
862 /*======================================================================+
863 | |
864 | Public Procedure |
865 | ValidateCurrentLine |
866 | |
867 +======================================================================*/
868 PROCEDURE ValidateCurrentLine
869 ;
870
871 --
872 --bulk performance
873 --
874 /*======================================================================+
875 | |
876 | Public Procedure |
877 | |
878 | |
879 +======================================================================*/
880 procedure set_ae_header_id
881 (p_ae_header_id in number
882 ,p_header_num in NUMBER); -- 4262811
883
884 /*======================================================================+
885 | |
886 | Public Procedure |
887 | |
888 | |
889 +======================================================================*/
890 procedure SetLineAcctAttrs
891 (p_rec_acct_attrs in t_rec_acct_attrs);
892
893 /*======================================================================+
894 | |
895 | Public Procedure |
896 | |
897 | |
898 +======================================================================*/
899 PROCEDURE SetAcctReversalAttrs
900 (p_event_id IN NUMBER
901 ,p_rec_acct_attrs IN XLA_AE_LINES_PKG.t_rec_acct_attrs
902 ,p_calculate_acctd_flag IN VARCHAR2
903 ,p_calculate_g_l_flag IN VARCHAR2);
904
905 /*======================================================================+
906 | |
907 | Public Procedure |
908 | |
909 | |
910 +======================================================================*/
911 PROCEDURE SetTrxReversalAttrs
912 (p_event_id IN NUMBER
913 ,p_gl_date IN DATE
914 ,p_trx_reversal_source IN VARCHAR2);
915
916 PROCEDURE CalculateUnroundedAmounts;
917
918 PROCEDURE CalculateGainLossAmounts;
919
920 /*======================================================================+
921 | |
922 | Public Procedure- Business Flow Validaton - 4219869 |
923 | |
924 | |
925 +======================================================================*/
926 PROCEDURE Business_Flow_Validation
927 (p_business_method_code IN VARCHAR2
928 ,p_business_class_code IN VARCHAR2
929 ,p_inherit_description_flag IN VARCHAR2);
930
931 /*======================================================================+
932 | |
933 | Public Procedure- Business Flow Prior Entry - 4219869 |
934 | |
935 | |
936 +======================================================================*/
937 PROCEDURE BusinessFlowPriorEntries
938 (p_accounting_mode IN VARCHAR2
939 ,p_ledger_id IN NUMBER
940 ,p_bc_mode IN VARCHAR2);
941
942 /*======================================================================+
943 | |
944 | Public Procedure- Business Flow Same Entry - 4219869 |
945 | |
946 | |
947 +======================================================================*/
948 PROCEDURE BusinessFlowSameEntries;
949
950 /*======================================================================+
951 | |
952 | Public Procedure- Validate Business Flow Applied To Links - 4219869 |
953 | |
954 | |
955 +======================================================================*/
956 PROCEDURE ValidateBFlowLinks;
957
958 /*======================================================================+
959 | |
960 | Public Procedure- 4219869 : making this public for Business Flow |
961 | |
962 | |
963 +======================================================================*/
964 PROCEDURE SetDebitCreditAmounts;
965
966 /*======================================================================+
967 | |
968 | Public Procedure- 4262811 |
969 | |
970 | |
971 +======================================================================*/
972 PROCEDURE CopyLineInfo(
973 p_line_num NUMBER
974 );
975
976 PROCEDURE BflowUpgEntry
977 (p_business_method_code IN VARCHAR2
978 ,p_business_class_code IN VARCHAR2
979 ,p_balance_type IN VARCHAR2);
980
981 PROCEDURE CreateGainOrLossLines
982 (p_event_id IN NUMBER
983 ,p_application_id IN NUMBER
984 ,p_amb_context_code IN VARCHAR2
985 ,p_entity_code IN VARCHAR2
986 ,p_event_class_code IN VARCHAR2
987 ,p_event_type_code IN VARCHAR2
988 ,p_gain_ccid IN NUMBER
989 ,p_loss_ccid IN NUMBER
990 ,p_actual_flag IN VARCHAR2
991 ,p_enc_flag IN VARCHAR2
992 ,p_actual_g_l_ref IN VARCHAR2
993 ,p_enc_g_l_ref IN VARCHAR2
994 )
995 ;
996 END xla_ae_lines_pkg; -- end of package spec