[Home] [Help]
PACKAGE: APPS.GL_JE_LINES_PKG
Source
1 PACKAGE GL_JE_LINES_PKG as
2 /* $Header: glijelns.pls 120.12 2006/01/17 20:04:58 xiwu ship $ */
3
4 --
5 -- Package
6 -- GL_JE_LINES_PKG
7 -- Purpose
8 -- To implement various data checking needed for the
9 -- gl_je_lines table
10 -- History
11 -- 01-18-94 D J Ogg Created.
12 --
13
14 --
15 -- Procedure
16 -- check_unique
17 -- Purpose
18 -- Checks to make sure that the line number
19 -- is unique within the header.
20 -- History
21 -- 01-18-93 D. J. Ogg Created
22 -- Arguments
23 -- header_id The ID of the header
24 -- line_num The line number to check
25 -- row_id The row ID
26 -- Example
27 -- gl_je_lines_pkg.check_unique(2002, 10, 'ABD02334');
28 -- Notes
29 --
30 PROCEDURE check_unique(header_id NUMBER, line_num NUMBER,
31 row_id VARCHAR2);
32
33 --
34 -- Procedure
35 -- delete_lines
36 -- Purpose
37 -- Deletes all of the lines in a given header.
38 -- History
39 -- 01-18-93 D. J. Ogg Created
40 -- Arguments
41 -- header_id The ID of the header
42 -- Example
43 -- gl_je_lines_pkg.delete_lines(1002);
44 -- Notes
45 --
46 PROCEDURE delete_lines(header_id NUMBER);
47
48 --
49 -- Procedure
50 -- update_lines
51 -- Purpose
52 -- Updates the conversion, effective date, and period information
53 -- for all lines within a given header. If you pass a currency
54 -- conversion rate of -1, this routine will not update the currency
55 -- conversion rate.
56 -- History
57 -- 02-07-94 D. J. Ogg Created
58 -- Arguments
59 -- header_id The ID of the header
60 -- x_period_name The name of the new period
61 -- x_effective_date The new effective date
62 -- conversion_denom_rate The denominator part of the conversion
63 -- rate (or -1)
64 -- conversion_numer_rate The numerator part of the conversion
65 -- rate (or -1)
66 -- entered_currency The entered currency for the line (only used
67 -- if the conversion rate is not -1)
68 -- accounted_currency The accounted currency for the line (only
69 -- used if the conversion rate is not -1)
70 -- ignore_ignore_flag If 'Y', indicates that the ignore_rate_flag
71 -- should be ignored. Otherwise, indicates that
72 -- the ignore_rate_flag should be heeded.
73 -- clear_stat If 'Y', indicates that the statistical amounts
74 -- should be cleared
75 -- user_id The ID of the user doing the update
76 -- login_id The Login ID of the user doing the update
77 -- Example
78 -- gl_je_lines_pkg.update_lines(1002, 'USD', 'JAN-91', '15-JAN-91',
79 -- 1.2, 'N', 102, 0);
80 -- Notes
81 --
82 PROCEDURE update_lines(header_id NUMBER,
83 x_period_name VARCHAR2,
84 x_effective_date DATE,
85 conversion_denom_rate NUMBER,
86 conversion_numer_rate NUMBER,
87 entered_currency VARCHAR2,
88 accounted_currency VARCHAR2,
89 ignore_ignore_flag VARCHAR2,
90 clear_stat VARCHAR2,
91 user_id NUMBER,
92 login_id NUMBER);
93
94 --
95 -- Procedure
96 -- calculate_totals
97 -- Purpose
98 -- Retotals the running totals for a header
99 -- History
100 -- 01-24-94 D. J. Ogg Created
101 -- Arguments
102 -- header_id The ID of the header
103 -- running_total_dr The running total of debits
104 -- running_total_cr The running total of credits
105 -- running_total_accounted_dr The running total of accounted debits
106 -- running_total_accounted_cr The running total of accounted credits
107 -- Example
108 -- gl_je_lines_pkg.calculate_totals(1002, run_dr, run_cr, run_accdr,
109 -- run_acccr);
110 -- Notes
111 --
112 PROCEDURE calculate_totals( header_id NUMBER,
113 running_total_dr IN OUT NOCOPY NUMBER,
114 running_total_cr IN OUT NOCOPY NUMBER,
115 running_total_accounted_dr IN OUT NOCOPY NUMBER,
116 running_total_accounted_cr IN OUT NOCOPY NUMBER
117 );
118
119 --
120 -- Procedure
121 -- header_has_stat
122 -- Purpose
123 -- Returns true if the header contains STAT amounts and
124 -- false otherwise
125 -- History
126 -- 03-15-94 D. J. Ogg Created
127 -- Arguments
128 -- header_id The ID of the header
129 -- Example
130 -- gl_je_lines_pkg.header_has_stat(1002);
131 -- Notes
132 --
133 FUNCTION header_has_stat(header_id NUMBER) RETURN BOOLEAN;
134
135 --
136 -- Procedure
137 -- header_has_tax
138 -- Purpose
139 -- Returns true if the header contains taxable lines and
140 -- false otherwise
141 -- History
142 -- 11-20-96 D. J. Ogg Created
143 -- Arguments
144 -- header_id The ID of the header
145 -- Example
146 -- gl_je_lines_pkg.header_has_tax(1002);
147 -- Notes
148 --
149 FUNCTION header_has_tax(header_id NUMBER) RETURN BOOLEAN;
150
151 --
152 -- Procedure
153 -- populate_fields
154 -- Purpose
155 -- Gets all of the data necessary post-query
156 -- History
157 -- 02-DEC-96 D. J. Ogg Created
158 -- Arguments
159 -- x_ledger_id Current ledger id
160 -- x_org_id Current org id
161 -- x_coa_id Current chart of accounts id
162 -- x_ccid Current code combination id
163 -- x_account_num Natural Account value
164 -- x_account_type Account Type
165 -- x_jgzz_recon_flag Reconciliation Flag
166 -- x_tax_enabled Indicates whether or not to retrieve
167 -- tax information
168 -- x_taxable_account Indicates whether the account is taxable
169 -- x_tax_code Tax code for the current line
170 -- x_stat_enabled Indicates whether or not to retrieve
171 -- statistical amounts
172 -- x_unit_of_measure Unit of Measure
173 -- x_tax_code_id Tax code id
174 -- x_tax_type_id Type of tax code
175 -- x_tax_code Tax code associated with id
176 -- Notes
177 --
178 PROCEDURE populate_fields(x_ledger_id NUMBER,
179 x_org_id NUMBER,
180 x_coa_id NUMBER,
181 x_ccid NUMBER,
182 x_account_num IN OUT NOCOPY VARCHAR2,
183 x_account_type IN OUT NOCOPY VARCHAR2,
184 x_jgzz_recon_flag IN OUT NOCOPY VARCHAR2,
185 x_tax_enabled VARCHAR2,
186 x_taxable_account IN OUT NOCOPY VARCHAR2,
187 x_stat_enabled VARCHAR2,
188 x_unit_of_measure IN OUT NOCOPY VARCHAR2,
189 x_tax_code_id NUMBER,
190 x_tax_type_code VARCHAR2,
191 x_tax_code IN OUT NOCOPY VARCHAR2);
192
193 --
194 -- Procedure
195 -- init_acct_dependencies
196 -- Purpose
197 -- Gets all of the tax and stat data necessary when the natural
198 -- account value is changed
199 -- History
200 -- 05-DEC-96 D. J. Ogg Created
201 -- Arguments
202 -- x_ledger_id Current ledger id
203 -- x_org_id Current org id
204 -- x_coa_id Current chart of accounts id
205 -- x_ccid Code Combination Id (or -1)
206 -- x_account_num Natural Account value
207 -- x_account_type Account type of Natural Account value
208 -- x_tax_enabled Indicates whether or not to retrieve
209 -- tax information
210 -- x_taxable_account Indicates whether the account is taxable
211 -- x_get_default_tax_info Indicates whether you should get the default
212 -- tax information
213 -- x_eff_date Effective date to use for default tax info
214 -- x_default_tax_type_code Default tax type code
215 -- x_default_tax_code Default tax code
216 -- x_default_tax_code_id Default tax code id
217 -- x_default_rounding_code Default rounding rule code
218 -- x_default_incl_tax_flag Default includes tax flag
219 -- x_stat_enabled Indicates whether or not to retrieve
220 -- statistical amounts
221 -- x_unit_of_measure Unit of Measure
222 -- x_jgzz_recon_flag Indicates whether or not to reconcile accounts
223 -- Notes
224 --
225 PROCEDURE init_acct_dependencies(
226 x_ledger_id NUMBER,
227 x_org_id NUMBER,
228 x_coa_id NUMBER,
229 x_ccid NUMBER,
230 x_account_num VARCHAR2,
231 x_account_type VARCHAR2,
232 x_tax_enabled VARCHAR2,
233 x_taxable_account IN OUT NOCOPY VARCHAR2,
234 x_get_default_tax_info VARCHAR2,
235 x_eff_date DATE,
236 x_default_tax_type_code IN OUT NOCOPY VARCHAR2,
237 x_default_tax_code IN OUT NOCOPY VARCHAR2,
238 x_default_tax_code_id IN OUT NOCOPY NUMBER,
239 x_default_rounding_code IN OUT NOCOPY VARCHAR2,
240 x_default_incl_tax_flag IN OUT NOCOPY VARCHAR2,
241 x_stat_enabled VARCHAR2,
242 x_unit_of_measure IN OUT NOCOPY VARCHAR2,
243 x_jgzz_recon_flag IN OUT NOCOPY VARCHAR2);
244
245 --
246 -- Procedure
247 -- get_tax_defaults
248 -- Purpose
249 -- Gets default values for rounding rule and includes tax
250 -- History
251 -- 05-DEC-96 D. J. Ogg Created
252 -- Arguments
253 -- x_ledger_id Current ledger id
254 -- x_org_id Current org id
255 -- x_account_value Natural Account value
256 -- x_tax_type_code Tax type code
257 -- x_default_rounding_code Default rounding rule code
258 -- x_default_incl_tax_flag Default includes tax flag
259 -- Notes
260 --
261 PROCEDURE get_tax_defaults(x_ledger_id NUMBER,
262 x_org_id NUMBER,
263 x_account_value VARCHAR2,
264 x_tax_type_code VARCHAR2,
265 x_default_rounding_code IN OUT NOCOPY VARCHAR2,
266 x_default_incl_tax_flag IN OUT NOCOPY VARCHAR2);
267
268 --
269 -- Procedure
270 -- default_tax_type
271 -- Purpose
272 -- Determines the default value for the tax type in the MJE form
273 -- History
274 -- 02-DEC-96 D. J. Ogg Created
275 -- Arguments
276 -- output_type I - Id, V - Value
277 -- x_ledger_id The current ledger
278 -- x_org_id Current org id
279 -- x_account_value The natural account value for the
280 -- current journal entry line.
281 -- x_account_type The account type for the
282 -- current journal entry line.
283 -- x_default_tax_type Default tax type
284 -- x_default_tax_type_code Default tax type code
285 -- Notes
286 --
287 FUNCTION default_tax_type(output_type IN VARCHAR2,
288 x_ledger_id IN NUMBER,
289 x_org_id IN NUMBER,
290 x_account_value IN VARCHAR2,
291 x_account_type IN VARCHAR2)
292 RETURN VARCHAR2;
293
294 --
295 -- Procedure
296 -- default_tax_code
297 -- Purpose
298 -- Determines the default value for the tax code in the MJE form
299 -- History
300 -- 02-DEC-96 D. J. Ogg Created
301 -- Arguments
302 -- output_type I - Id, V - Value
303 -- x_ledger_id The current ledger
304 -- x_org_id Current org id
305 -- x_account_value The natural account value for the
306 -- current journal entry line.
307 -- x_acct_type The selected account type
308 -- x_eff_date The effective date of the current
309 -- Notes
310 --
311 FUNCTION default_tax_code(output_type IN VARCHAR2,
312 x_ledger_id IN NUMBER,
313 x_org_id IN NUMBER,
314 x_account_value IN VARCHAR2,
315 x_acct_type IN VARCHAR2,
316 x_eff_date IN DATE
317 ) RETURN VARCHAR2;
318
319 --
320 -- Procedure
321 -- default_rounding_rule
322 -- Purpose
323 -- Determines the default value for the rounding_rule in the MJE form
324 -- History
325 -- 02-DEC-96 D. J. Ogg Created
326 -- Arguments
327 -- output_type I - Id, V - Value
328 -- x_ledger_id The current ledger
329 -- x_org_id Current org id
330 -- x_tax_type The selected tax type
331 -- Notes
332 --
333 FUNCTION default_rounding_rule(output_type IN VARCHAR2,
334 x_ledger_id IN NUMBER,
335 x_org_id IN NUMBER,
336 x_tax_type IN VARCHAR2
337 ) RETURN VARCHAR2;
338
339 --
340 -- Procedure
341 -- default_includes_tax
342 -- Purpose
343 -- Determines the default value for the amount includes tax flag
344 -- in the MJE form
345 -- History
346 -- 02-DEC-96 D. J. Ogg Created
347 -- Arguments
348 -- output_type I - Id, V - Value
349 -- x_ledger_id The current ledger
350 -- x_org_id Current org id
351 -- x_account_value The natural account value for the
352 -- current journal entry line.
353 -- x_tax_type The selected tax type
354 -- Notes
355 --
356 FUNCTION default_includes_tax(output_type IN VARCHAR2,
357 x_ledger_id IN NUMBER,
358 x_org_id IN NUMBER,
359 x_account_value IN VARCHAR2,
360 x_tax_type IN VARCHAR2
361 ) RETURN VARCHAR2;
362
363 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
364 X_Je_Header_Id IN OUT NOCOPY NUMBER,
365 X_Je_Line_Num NUMBER,
366 X_Last_Update_Date DATE,
367 X_Last_Updated_By NUMBER,
368 X_Ledger_Id NUMBER,
369 X_Code_Combination_Id NUMBER,
370 X_Period_Name VARCHAR2,
371 X_Effective_Date DATE,
372 X_Status VARCHAR2,
373 X_Creation_Date DATE,
374 X_Created_By NUMBER,
375 X_Last_Update_Login NUMBER,
376 X_Entered_Dr NUMBER,
377 X_Entered_Cr NUMBER,
378 X_Accounted_Dr NUMBER,
379 X_Accounted_Cr NUMBER,
380 X_Description VARCHAR2,
381 X_Reference_1 VARCHAR2,
382 X_Reference_2 VARCHAR2,
383 X_Reference_3 VARCHAR2,
384 X_Reference_4 VARCHAR2,
385 X_Reference_5 VARCHAR2,
386 X_Attribute1 VARCHAR2,
387 X_Attribute2 VARCHAR2,
388 X_Attribute3 VARCHAR2,
389 X_Attribute4 VARCHAR2,
390 X_Attribute5 VARCHAR2,
391 X_Attribute6 VARCHAR2,
392 X_Attribute7 VARCHAR2,
396 X_Attribute11 VARCHAR2,
393 X_Attribute8 VARCHAR2,
394 X_Attribute9 VARCHAR2,
395 X_Attribute10 VARCHAR2,
397 X_Attribute12 VARCHAR2,
398 X_Attribute13 VARCHAR2,
399 X_Attribute14 VARCHAR2,
400 X_Attribute15 VARCHAR2,
401 X_Attribute16 VARCHAR2,
402 X_Attribute17 VARCHAR2,
403 X_Attribute18 VARCHAR2,
404 X_Attribute19 VARCHAR2,
405 X_Attribute20 VARCHAR2,
406 X_Context VARCHAR2,
407 X_Context2 VARCHAR2,
408 X_Invoice_Date DATE,
409 X_Tax_Code VARCHAR2,
410 X_Invoice_Identifier VARCHAR2,
411 X_Invoice_Amount NUMBER,
412 X_No1 VARCHAR2,
413 X_Stat_Amount NUMBER,
414 X_Ignore_Rate_Flag VARCHAR2,
415 X_Context3 VARCHAR2,
416 X_Ussgl_Transaction_Code VARCHAR2,
417 X_Subledger_Doc_Sequence_Id NUMBER,
418 X_Context4 VARCHAR2,
419 X_Subledger_Doc_Sequence_Value NUMBER,
420 X_Reference_6 VARCHAR2,
421 X_Reference_7 VARCHAR2,
422 X_Reference_8 VARCHAR2,
423 X_Reference_9 VARCHAR2,
424 X_Reference_10 VARCHAR2,
425 X_Recon_On_Flag VARCHAR2,
426 X_Recon_Rowid IN OUT NOCOPY VARCHAR2,
427 X_Jgzz_Recon_Status VARCHAR2,
428 X_Jgzz_Recon_Date DATE,
429 X_Jgzz_Recon_Id NUMBER,
430 X_Jgzz_Recon_Ref VARCHAR2,
431 X_Taxable_Line_Flag VARCHAR2,
432 X_Tax_Type_Code VARCHAR2,
433 X_Tax_Code_Id NUMBER,
434 X_Tax_Rounding_Rule_Code VARCHAR2,
435 X_Amount_Includes_Tax_Flag VARCHAR2,
436 X_Tax_Document_Identifier VARCHAR2,
437 X_Tax_Document_Date DATE,
438 X_Tax_Customer_Name VARCHAR2,
439 X_Tax_Customer_Reference VARCHAR2,
440 X_Tax_Registration_Number VARCHAR2,
441 X_Tax_Line_Flag VARCHAR2,
442 X_Tax_Group_Id NUMBER,
443 X_Third_Party_Id VARCHAR2
444 );
445
446
447 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
448 X_Je_Header_Id NUMBER,
449 X_Je_Line_Num NUMBER,
450 X_Ledger_Id NUMBER,
451 X_Code_Combination_Id NUMBER,
452 X_Period_Name VARCHAR2,
453 X_Effective_Date DATE,
454 X_Status VARCHAR2,
455 X_Entered_Dr NUMBER,
456 X_Entered_Cr NUMBER,
457 X_Accounted_Dr NUMBER,
458 X_Accounted_Cr NUMBER,
459 X_Description VARCHAR2,
460 X_Reference_1 VARCHAR2,
461 X_Reference_2 VARCHAR2,
462 X_Reference_3 VARCHAR2,
463 X_Reference_4 VARCHAR2,
464 X_Reference_5 VARCHAR2,
465 X_Attribute1 VARCHAR2,
466 X_Attribute2 VARCHAR2,
467 X_Attribute3 VARCHAR2,
468 X_Attribute4 VARCHAR2,
469 X_Attribute5 VARCHAR2,
470 X_Attribute6 VARCHAR2,
471 X_Attribute7 VARCHAR2,
472 X_Attribute8 VARCHAR2,
473 X_Attribute9 VARCHAR2,
474 X_Attribute10 VARCHAR2,
475 X_Attribute11 VARCHAR2,
476 X_Attribute12 VARCHAR2,
477 X_Attribute13 VARCHAR2,
478 X_Attribute14 VARCHAR2,
479 X_Attribute15 VARCHAR2,
480 X_Attribute16 VARCHAR2,
481 X_Attribute17 VARCHAR2,
482 X_Attribute18 VARCHAR2,
483 X_Attribute19 VARCHAR2,
487 X_Invoice_Date DATE,
484 X_Attribute20 VARCHAR2,
485 X_Context VARCHAR2,
486 X_Context2 VARCHAR2,
488 X_Tax_Code VARCHAR2,
489 X_Invoice_Identifier VARCHAR2,
490 X_Invoice_Amount NUMBER,
491 X_No1 VARCHAR2,
492 X_Stat_Amount NUMBER,
493 X_Ignore_Rate_Flag VARCHAR2,
494 X_Context3 VARCHAR2,
495 X_Ussgl_Transaction_Code VARCHAR2,
496 X_Subledger_Doc_Sequence_Id NUMBER,
497 X_Context4 VARCHAR2,
498 X_Subledger_Doc_Sequence_Value NUMBER,
499 X_Reference_6 VARCHAR2,
500 X_Reference_7 VARCHAR2,
501 X_Reference_8 VARCHAR2,
502 X_Reference_9 VARCHAR2,
503 X_Reference_10 VARCHAR2,
504 X_Recon_Rowid VARCHAR2,
505 X_Jgzz_Recon_Status VARCHAR2,
506 X_Jgzz_Recon_Date DATE,
507 X_Jgzz_Recon_Id NUMBER,
508 X_Jgzz_Recon_Ref VARCHAR2,
509 X_Taxable_Line_Flag VARCHAR2,
510 X_Tax_Type_Code VARCHAR2,
511 X_Tax_Code_Id NUMBER,
512 X_Tax_Rounding_Rule_Code VARCHAR2,
513 X_Amount_Includes_Tax_Flag VARCHAR2,
514 X_Tax_Document_Identifier VARCHAR2,
515 X_Tax_Document_Date DATE,
516 X_Tax_Customer_Name VARCHAR2,
517 X_Tax_Customer_Reference VARCHAR2,
518 X_Tax_Registration_Number VARCHAR2,
519 X_Tax_Line_Flag VARCHAR2,
520 X_Tax_Group_Id NUMBER,
521 X_Third_Party_Id VARCHAR2
522 );
523
524 PROCEDURE Update_Row(X_Rowid VARCHAR2,
525 X_Je_Header_Id NUMBER,
526 X_Je_Line_Num NUMBER,
527 X_Last_Update_Date DATE,
528 X_Last_Updated_By NUMBER,
529 X_Ledger_Id NUMBER,
530 X_Code_Combination_Id NUMBER,
531 X_Period_Name VARCHAR2,
532 X_Effective_Date DATE,
533 X_Status VARCHAR2,
534 X_Last_Update_Login NUMBER,
535 X_Entered_Dr NUMBER,
536 X_Entered_Cr NUMBER,
537 X_Accounted_Dr NUMBER,
538 X_Accounted_Cr NUMBER,
539 X_Description VARCHAR2,
540 X_Reference_1 VARCHAR2,
541 X_Reference_2 VARCHAR2,
542 X_Reference_3 VARCHAR2,
543 X_Reference_4 VARCHAR2,
544 X_Reference_5 VARCHAR2,
545 X_Attribute1 VARCHAR2,
546 X_Attribute2 VARCHAR2,
547 X_Attribute3 VARCHAR2,
548 X_Attribute4 VARCHAR2,
549 X_Attribute5 VARCHAR2,
550 X_Attribute6 VARCHAR2,
551 X_Attribute7 VARCHAR2,
552 X_Attribute8 VARCHAR2,
553 X_Attribute9 VARCHAR2,
554 X_Attribute10 VARCHAR2,
555 X_Attribute11 VARCHAR2,
556 X_Attribute12 VARCHAR2,
557 X_Attribute13 VARCHAR2,
558 X_Attribute14 VARCHAR2,
559 X_Attribute15 VARCHAR2,
560 X_Attribute16 VARCHAR2,
561 X_Attribute17 VARCHAR2,
562 X_Attribute18 VARCHAR2,
563 X_Attribute19 VARCHAR2,
564 X_Attribute20 VARCHAR2,
565 X_Context VARCHAR2,
566 X_Context2 VARCHAR2,
567 X_Invoice_Date DATE,
568 X_Tax_Code VARCHAR2,
569 X_Invoice_Identifier VARCHAR2,
570 X_Invoice_Amount NUMBER,
571 X_No1 VARCHAR2,
572 X_Stat_Amount NUMBER,
573 X_Ignore_Rate_Flag VARCHAR2,
577 X_Context4 VARCHAR2,
574 X_Context3 VARCHAR2,
575 X_Ussgl_Transaction_Code VARCHAR2,
576 X_Subledger_Doc_Sequence_Id NUMBER,
578 X_Subledger_Doc_Sequence_Value NUMBER,
579 X_Reference_6 VARCHAR2,
580 X_Reference_7 VARCHAR2,
581 X_Reference_8 VARCHAR2,
582 X_Reference_9 VARCHAR2,
583 X_Reference_10 VARCHAR2,
584 X_Recon_On_Flag VARCHAR2,
585 X_Recon_Rowid IN OUT NOCOPY VARCHAR2,
586 X_Jgzz_Recon_Status VARCHAR2,
587 X_Jgzz_Recon_Date DATE,
588 X_Jgzz_Recon_Id NUMBER,
589 X_Jgzz_Recon_Ref VARCHAR2,
590 X_Taxable_Line_Flag VARCHAR2,
591 X_Tax_Type_Code VARCHAR2,
592 X_Tax_Code_Id NUMBER,
593 X_Tax_Rounding_Rule_Code VARCHAR2,
594 X_Amount_Includes_Tax_Flag VARCHAR2,
595 X_Tax_Document_Identifier VARCHAR2,
596 X_Tax_Document_Date DATE,
597 X_Tax_Customer_Name VARCHAR2,
598 X_Tax_Customer_Reference VARCHAR2,
599 X_Tax_Registration_Number VARCHAR2,
600 X_Tax_Line_Flag VARCHAR2,
601 X_Tax_Group_Id NUMBER,
602 X_Third_Party_Id VARCHAR2
603 );
604
605
606 PROCEDURE Delete_Row(X_Rowid VARCHAR2,
607 X_Recon_Rowid VARCHAR2);
608
609 END GL_JE_LINES_PKG;