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