DBA Data[Home] [Help]

PACKAGE: APPS.ZX_TRL_SUMMARY_OVERRIDE_PKG

Source


1 PACKAGE ZX_TRL_SUMMARY_OVERRIDE_PKG AS
2 /* $Header: zxriovrsumlnpkgs.pls 120.25.12010000.2 2008/11/12 12:47:13 spasala ship $ */
3 
4   PROCEDURE Insert_Row
5        (x_rowid                        IN OUT NOCOPY VARCHAR2,
6         p_summary_tax_line_id                        NUMBER,
7         p_internal_organization_id                   NUMBER,
8         p_application_id                             NUMBER,
9         p_entity_code                                VARCHAR2,
10         p_event_class_code                           VARCHAR2,
11         p_trx_id                                     NUMBER,
12         p_summary_tax_line_number                    NUMBER,
13         p_trx_number                                 VARCHAR2,
14         p_applied_from_application_id                NUMBER,
15         p_applied_from_evt_class_code                VARCHAR2,--reduced size p_applied_from_event_class_code
16         p_applied_from_entity_code                   VARCHAR2,
17         p_applied_from_trx_id                        NUMBER,
18         p_applied_from_trx_level_type                VARCHAR2,
19         p_applied_from_line_id                       NUMBER,
20         p_adjusted_doc_application_id                NUMBER,
21         p_adjusted_doc_entity_code                   VARCHAR2,
22         p_adjusted_doc_evt_class_code                VARCHAR2,--reduced size p_adjusted_doc_event_class_code
23         p_adjusted_doc_trx_id                        NUMBER,
24         p_adjusted_doc_trx_level_type                VARCHAR2,
25         p_applied_to_application_id                  NUMBER,
26         p_applied_to_event_class_code                VARCHAR2,
27         p_applied_to_entity_code                     VARCHAR2,
28         p_applied_to_trx_id                          NUMBER,
29         p_applied_to_trx_level_type                  VARCHAR2,
30         p_applied_to_line_id                         NUMBER,
31         p_tax_exemption_id                           NUMBER,
32         p_tax_rate_before_exemption                  NUMBER,
33         p_tax_rate_name_before_exempt                VARCHAR2, --reduced size p_tax_rate_name_before_exemption
34         p_exempt_rate_modifier                       NUMBER,
35         p_exempt_certificate_number                  VARCHAR2,
36         p_exempt_reason                              VARCHAR2,
37         p_exempt_reason_code                         VARCHAR2,
38         p_tax_rate_before_exception                  NUMBER,
39         p_tax_rate_name_before_except                VARCHAR2, --reduced size p_tax_rate_name_before_exception
40         p_tax_exception_id                           NUMBER,
41         p_exception_rate                             NUMBER,
42         p_content_owner_id                           NUMBER,
43         p_tax_regime_code                            VARCHAR2,
44         p_tax                                        VARCHAR2,
45         p_tax_status_code                            VARCHAR2,
46         p_tax_rate_id                                NUMBER,
47         p_tax_rate_code                              VARCHAR2,
48         p_tax_rate                                   NUMBER,
49         p_tax_amt                                    NUMBER,
50         p_tax_amt_tax_curr                           NUMBER,
51         p_tax_amt_funcl_curr                         NUMBER,
52         p_tax_jurisdiction_code                      VARCHAR2,
53         p_total_rec_tax_amt                          NUMBER,
54         p_total_rec_tax_amt_func_curr                NUMBER,--reduced size p_total_rec_tax_amt_funcl_curr
55         p_total_rec_tax_amt_tax_curr                 NUMBER,
56         p_total_nrec_tax_amt                         NUMBER,
57         p_total_nrec_tax_amt_func_curr               NUMBER,--reduced size p_total_nrec_tax_amt_funcl_curr
58         p_total_nrec_tax_amt_tax_curr                NUMBER,
59         p_ledger_id                                  NUMBER,
60         p_legal_entity_id                            NUMBER,
61         p_establishment_id                           NUMBER,
62         p_currency_conversion_date                   DATE,
63         p_currency_conversion_type                   VARCHAR2,
64         p_currency_conversion_rate                   NUMBER,
65         p_summarization_template_id                  NUMBER,
66         p_taxable_basis_formula                      VARCHAR2,
67         p_tax_calculation_formula                    VARCHAR2,
68         p_historical_flag                            VARCHAR2,
69         p_cancel_flag                                VARCHAR2,
70         p_delete_flag                                VARCHAR2,
71         p_tax_amt_included_flag                      VARCHAR2,
72         p_compounding_tax_flag                       VARCHAR2,
73         p_self_assessed_flag                         VARCHAR2,
74         p_overridden_flag                            VARCHAR2,
75         p_reporting_only_flag                        VARCHAR2,
76         p_assoc_child_frozen_flag                    VARCHAR2,--reduced size p_Associated_Child_Frozen_Flag
77         p_copied_from_other_doc_flag                 VARCHAR2,
78         p_manually_entered_flag                      VARCHAR2,
79         p_mrc_tax_line_flag                          VARCHAR2,
80         p_last_manual_entry                          VARCHAR2,
81         p_record_type_code                           VARCHAR2,
82         p_tax_provider_id                            NUMBER,
83         p_tax_only_line_flag                         VARCHAR2,
84         p_adjust_tax_amt_flag                        VARCHAR2,
85         p_attribute_category                         VARCHAR2,
86         p_attribute1                                 VARCHAR2,
87         p_attribute2                                 VARCHAR2,
88         p_attribute3                                 VARCHAR2,
89         p_attribute4                                 VARCHAR2,
90         p_attribute5                                 VARCHAR2,
91         p_attribute6                                 VARCHAR2,
92         p_attribute7                                 VARCHAR2,
93         p_attribute8                                 VARCHAR2,
94         p_attribute9                                 VARCHAR2,
95         p_attribute10                                VARCHAR2,
96         p_attribute11                                VARCHAR2,
97         p_attribute12                                VARCHAR2,
98         p_attribute13                                VARCHAR2,
99         p_attribute14                                VARCHAR2,
100         p_attribute15                                VARCHAR2,
101         p_global_attribute_category                  VARCHAR2,
102         p_global_attribute1                          VARCHAR2,
103         p_global_attribute2                          VARCHAR2,
104         p_global_attribute3                          VARCHAR2,
105         p_global_attribute4                          VARCHAR2,
106         p_global_attribute5                          VARCHAR2,
107         p_global_attribute6                          VARCHAR2,
108         p_global_attribute7                          VARCHAR2,
109         p_global_attribute8                          VARCHAR2,
110         p_global_attribute9                          VARCHAR2,
111         p_global_attribute10                         VARCHAR2,
112         p_global_attribute11                         VARCHAR2,
113         p_global_attribute12                         VARCHAR2,
114         p_global_attribute13                         VARCHAR2,
115         p_global_attribute14                         VARCHAR2,
116         p_global_attribute15                         VARCHAR2,
117         p_global_attribute16                         VARCHAR2,
118         p_global_attribute17                         VARCHAR2,
119         p_global_attribute18                         VARCHAR2,
120         p_global_attribute19                         VARCHAR2,
121         p_global_attribute20                         VARCHAR2,
122         p_object_version_number                      NUMBER,
123         p_created_by                                 NUMBER,
124         p_creation_date                              DATE,
125         p_last_updated_by                            NUMBER,
126         p_last_update_date                           DATE,
127         p_last_update_login                          NUMBER);
128 
129   PROCEDURE oa_lock_row
130       ( p_application_id NUMBER,
131       p_entity_code    VARCHAR2,
132       p_event_class_code VARCHAR2,
133       p_trx_id NUMBER,
134       p_internal_organization_id NUMBER);
135 
136   PROCEDURE Lock_Row
137        (x_rowid                        IN OUT NOCOPY VARCHAR2,
138         p_summary_tax_line_id                        NUMBER,
139         p_internal_organization_id                   NUMBER,
140         p_application_id                             NUMBER,
141         p_entity_code                                VARCHAR2,
142         p_event_class_code                           VARCHAR2,
143         p_trx_id                                     NUMBER,
144         p_summary_tax_line_number                    NUMBER,
145         p_trx_number                                 VARCHAR2,
146         p_applied_from_application_id                NUMBER,
147         p_applied_from_evt_class_code                VARCHAR2,--reduced size p_applied_from_event_class_code
148         p_applied_from_entity_code                   VARCHAR2,
149         p_applied_from_trx_id                        NUMBER,
150         p_applied_from_trx_level_type                VARCHAR2,
151         p_applied_from_line_id                       NUMBER,
152         p_adjusted_doc_application_id                NUMBER,
153         p_adjusted_doc_entity_code                   VARCHAR2,
154         p_adjusted_doc_evt_class_code                VARCHAR2,--reduced size p_adjusted_doc_event_class_code
155         p_adjusted_doc_trx_id                        NUMBER,
156         p_adjusted_doc_trx_level_type                VARCHAR2,
157         p_applied_to_application_id                  NUMBER,
158         p_applied_to_event_class_code                VARCHAR2,
159         p_applied_to_entity_code                     VARCHAR2,
160         p_applied_to_trx_id                          NUMBER,
161         p_applied_to_trx_level_type                  VARCHAR2,
162         p_applied_to_line_id                         NUMBER,
163         p_tax_exemption_id                           NUMBER,
164         p_tax_rate_before_exemption                  NUMBER,
165         p_tax_rate_name_before_exempt                VARCHAR2, --reduced size p_tax_rate_name_before_exemption
166         p_exempt_rate_modifier                       NUMBER,
167         p_exempt_certificate_number                  VARCHAR2,
168         p_exempt_reason                              VARCHAR2,
169         p_exempt_reason_code                         VARCHAR2,
170         p_tax_rate_before_exception                  NUMBER,
171         p_tax_rate_name_before_except                VARCHAR2, --reduced size p_tax_rate_name_before_exception
172         p_tax_exception_id                           NUMBER,
173         p_exception_rate                             NUMBER,
174         p_content_owner_id                           NUMBER,
175         p_tax_regime_code                            VARCHAR2,
176         p_tax                                        VARCHAR2,
177         p_tax_status_code                            VARCHAR2,
178         p_tax_rate_id                                NUMBER,
179         p_tax_rate_code                              VARCHAR2,
180         p_tax_rate                                   NUMBER,
181         p_tax_amt                                    NUMBER,
182         p_tax_amt_tax_curr                           NUMBER,
183         p_tax_amt_funcl_curr                         NUMBER,
184         p_tax_jurisdiction_code                      VARCHAR2,
185         p_total_rec_tax_amt                          NUMBER,
186         p_total_rec_tax_amt_func_curr                NUMBER,--reduced size p_total_rec_tax_amt_funcl_curr
187         p_total_rec_tax_amt_tax_curr                 NUMBER,
188         p_total_nrec_tax_amt                         NUMBER,
189         p_total_nrec_tax_amt_func_curr               NUMBER,--reduced size p_total_nrec_tax_amt_funcl_curr
190         p_total_nrec_tax_amt_tax_curr                NUMBER,
191         p_ledger_id                                  NUMBER,
192         p_legal_entity_id                            NUMBER,
193         p_establishment_id                           NUMBER,
194         p_currency_conversion_date                   DATE,
195         p_currency_conversion_type                   VARCHAR2,
196         p_currency_conversion_rate                   NUMBER,
197         p_summarization_template_id                  NUMBER,
198         p_taxable_basis_formula                      VARCHAR2,
199         p_tax_calculation_formula                    VARCHAR2,
200         p_historical_flag                            VARCHAR2,
201         p_cancel_flag                                VARCHAR2,
202         p_delete_flag                                VARCHAR2,
203         p_tax_amt_included_flag                      VARCHAR2,
204         p_compounding_tax_flag                       VARCHAR2,
205         p_self_assessed_flag                         VARCHAR2,
206         p_overridden_flag                            VARCHAR2,
207         p_reporting_only_flag                        VARCHAR2,
208         p_assoc_child_frozen_flag                    VARCHAR2,--reduced size p_Associated_Child_Frozen_Flag
209         p_copied_from_other_doc_flag                 VARCHAR2,
210         p_manually_entered_flag                      VARCHAR2,
211         p_mrc_tax_line_flag                          VARCHAR2,
212         p_last_manual_entry                          VARCHAR2,
213         p_record_type_code                           VARCHAR2,
214         p_tax_provider_id                            NUMBER,
215         p_tax_only_line_flag                         VARCHAR2,
216         p_adjust_tax_amt_flag                        VARCHAR2,
217         p_attribute_category                         VARCHAR2,
218         p_attribute1                                 VARCHAR2,
219         p_attribute2                                 VARCHAR2,
220         p_attribute3                                 VARCHAR2,
221         p_attribute4                                 VARCHAR2,
222         p_attribute5                                 VARCHAR2,
223         p_attribute6                                 VARCHAR2,
224         p_attribute7                                 VARCHAR2,
225         p_attribute8                                 VARCHAR2,
226         p_attribute9                                 VARCHAR2,
227         p_attribute10                                VARCHAR2,
228         p_attribute11                                VARCHAR2,
229         p_attribute12                                VARCHAR2,
230         p_attribute13                                VARCHAR2,
234         p_global_attribute1                          VARCHAR2,
231         p_attribute14                                VARCHAR2,
232         p_attribute15                                VARCHAR2,
233         p_global_attribute_category                  VARCHAR2,
235         p_global_attribute2                          VARCHAR2,
236         p_global_attribute3                          VARCHAR2,
237         p_global_attribute4                          VARCHAR2,
238         p_global_attribute5                          VARCHAR2,
239         p_global_attribute6                          VARCHAR2,
240         p_global_attribute7                          VARCHAR2,
241         p_global_attribute8                          VARCHAR2,
242         p_global_attribute9                          VARCHAR2,
243         p_global_attribute10                         VARCHAR2,
244         p_global_attribute11                         VARCHAR2,
245         p_global_attribute12                         VARCHAR2,
246         p_global_attribute13                         VARCHAR2,
247         p_global_attribute14                         VARCHAR2,
248         p_global_attribute15                         VARCHAR2,
249         p_global_attribute16                         VARCHAR2,
250         p_global_attribute17                         VARCHAR2,
251         p_global_attribute18                         VARCHAR2,
252         p_global_attribute19                         VARCHAR2,
253         p_global_attribute20                         VARCHAR2,
254         p_object_version_number                      NUMBER,
255         p_created_by                                 NUMBER,
256         p_creation_date                              DATE,
257         p_last_updated_by                            NUMBER,
258         p_last_update_date                           DATE,
259         p_last_update_login                          NUMBER);
260 
261   PROCEDURE Update_Row
262        (--x_rowid                        IN OUT NOCOPY VARCHAR2,
263         p_summary_tax_line_id                        NUMBER,
264         p_internal_organization_id                   NUMBER,
265         p_application_id                             NUMBER,
266         p_entity_code                                VARCHAR2,
267         p_event_class_code                           VARCHAR2,
268         p_trx_id                                     NUMBER,
269         p_summary_tax_line_number                    NUMBER,
270         p_trx_number                                 VARCHAR2,
271         p_applied_from_application_id                NUMBER,
272         p_applied_from_evt_class_code                VARCHAR2,--reduced size p_applied_from_event_class_code
273         p_applied_from_entity_code                   VARCHAR2,
274         p_applied_from_trx_id                        NUMBER,
275         p_applied_from_trx_level_type                VARCHAR2,
276         p_applied_from_line_id                       NUMBER,
277         p_adjusted_doc_application_id                NUMBER,
278         p_adjusted_doc_entity_code                   VARCHAR2,
279         p_adjusted_doc_evt_class_code                VARCHAR2,--reduced size p_adjusted_doc_event_class_code
280         p_adjusted_doc_trx_id                        NUMBER,
281         p_adjusted_doc_trx_level_type                VARCHAR2,
282         p_applied_to_application_id                  NUMBER,
283         p_applied_to_event_class_code                VARCHAR2,
284         p_applied_to_entity_code                     VARCHAR2,
285         p_applied_to_trx_id                          NUMBER,
286         p_applied_to_trx_level_type                  VARCHAR2,
287         p_applied_to_line_id                         NUMBER,
288         p_tax_exemption_id                           NUMBER,
289         p_tax_rate_before_exemption                  NUMBER,
290         p_tax_rate_name_before_exempt                VARCHAR2, --reduced size p_tax_rate_name_before_exemption
291         p_exempt_rate_modifier                       NUMBER,
292         p_exempt_certificate_number                  VARCHAR2,
293         p_exempt_reason                              VARCHAR2,
294         p_exempt_reason_code                         VARCHAR2,
295         p_tax_rate_before_exception                  NUMBER,
296         p_tax_rate_name_before_except                VARCHAR2, --reduced size p_tax_rate_name_before_exception
297         p_tax_exception_id                           NUMBER,
298         p_exception_rate                             NUMBER,
299         p_content_owner_id                           NUMBER,
300         p_tax_regime_code                            VARCHAR2,
301         p_tax                                        VARCHAR2,
302         p_tax_status_id                              NUMBER,
303         p_tax_status_code                            VARCHAR2,
304         p_tax_rate_id                                NUMBER,
305         p_tax_rate_code                              VARCHAR2,
306         p_tax_rate                                   NUMBER,
307         p_tax_amt                                    NUMBER,
308         p_tax_amt_tax_curr                           NUMBER,
309         p_tax_amt_funcl_curr                         NUMBER,
310         p_tax_jurisdiction_code                      VARCHAR2,
311         p_total_rec_tax_amt                          NUMBER,
312         p_total_rec_tax_amt_func_curr                NUMBER,--reduced size p_total_rec_tax_amt_funcl_curr
313         p_total_rec_tax_amt_tax_curr                 NUMBER,
314         p_total_nrec_tax_amt                         NUMBER,
315         p_total_nrec_tax_amt_func_curr               NUMBER,--reduced size p_total_nrec_tax_amt_funcl_curr
316         p_total_nrec_tax_amt_tax_curr                NUMBER,
317         p_ledger_id                                  NUMBER,
321         p_currency_conversion_type                   VARCHAR2,
318         p_legal_entity_id                            NUMBER,
319         p_establishment_id                           NUMBER,
320         p_currency_conversion_date                   DATE,
322         p_currency_conversion_rate                   NUMBER,
323         p_summarization_template_id                  NUMBER,
324         p_taxable_basis_formula                      VARCHAR2,
325         p_tax_calculation_formula                    VARCHAR2,
326         p_historical_flag                            VARCHAR2,
327         p_cancel_flag                                VARCHAR2,
328         p_delete_flag                                VARCHAR2,
329         p_tax_amt_included_flag                      VARCHAR2,
330         p_compounding_tax_flag                       VARCHAR2,
331         p_self_assessed_flag                         VARCHAR2,
332         p_overridden_flag                            VARCHAR2,
333         p_reporting_only_flag                        VARCHAR2,
334         p_assoc_child_frozen_flag                    VARCHAR2,--reduced size p_Associated_Child_Frozen_Flag
335         p_copied_from_other_doc_flag                 VARCHAR2,
336         p_manually_entered_flag                      VARCHAR2,
337         p_mrc_tax_line_flag                          VARCHAR2,
338         p_last_manual_entry                          VARCHAR2,
339         p_record_type_code                           VARCHAR2,
340         p_tax_provider_id                            NUMBER,
341         p_tax_only_line_flag                         VARCHAR2,
342         p_adjust_tax_amt_flag                        VARCHAR2,
343         --p_ctrl_ef_ov_cal_line_flag                   VARCHAR2,
344         p_attribute_category                         VARCHAR2,
345         p_attribute1                                 VARCHAR2,
346         p_attribute2                                 VARCHAR2,
347         p_attribute3                                 VARCHAR2,
348         p_attribute4                                 VARCHAR2,
349         p_attribute5                                 VARCHAR2,
350         p_attribute6                                 VARCHAR2,
351         p_attribute7                                 VARCHAR2,
352         p_attribute8                                 VARCHAR2,
353         p_attribute9                                 VARCHAR2,
354         p_attribute10                                VARCHAR2,
355         p_attribute11                                VARCHAR2,
356         p_attribute12                                VARCHAR2,
357         p_attribute13                                VARCHAR2,
358         p_attribute14                                VARCHAR2,
359         p_attribute15                                VARCHAR2,
360         p_global_attribute_category                  VARCHAR2,
361         p_global_attribute1                          VARCHAR2,
362         p_global_attribute2                          VARCHAR2,
363         p_global_attribute3                          VARCHAR2,
364         p_global_attribute4                          VARCHAR2,
365         p_global_attribute5                          VARCHAR2,
366         p_global_attribute6                          VARCHAR2,
367         p_global_attribute7                          VARCHAR2,
368         p_global_attribute8                          VARCHAR2,
369         p_global_attribute9                          VARCHAR2,
370         p_global_attribute10                         VARCHAR2,
371         p_global_attribute11                         VARCHAR2,
372         p_global_attribute12                         VARCHAR2,
373         p_global_attribute13                         VARCHAR2,
374         p_global_attribute14                         VARCHAR2,
375         p_global_attribute15                         VARCHAR2,
376         p_global_attribute16                         VARCHAR2,
377         p_global_attribute17                         VARCHAR2,
378         p_global_attribute18                         VARCHAR2,
379         p_global_attribute19                         VARCHAR2,
380         p_global_attribute20                         VARCHAR2,
381         p_object_version_number                      NUMBER,
382         --p_created_by                                 NUMBER,
383         --p_creation_date                              DATE,
384         p_last_updated_by                            NUMBER,
385         p_last_update_date                           DATE,
386         p_last_update_login                          NUMBER);
387 
388   PROCEDURE Delete_Row
389        (x_rowid                        IN OUT NOCOPY VARCHAR2,
390         p_summary_tax_line_id                        NUMBER,
391         p_internal_organization_id                   NUMBER,
392         p_application_id                             NUMBER,
393         p_entity_code                                VARCHAR2,
394         p_event_class_code                           VARCHAR2,
395         p_trx_id                                     NUMBER,
396         p_summary_tax_line_number                    NUMBER,
397         p_trx_number                                 VARCHAR2,
398         p_applied_from_application_id                NUMBER,
399         p_applied_from_evt_class_code                VARCHAR2,--reduced size p_applied_from_event_class_code
400         p_applied_from_entity_code                   VARCHAR2,
401         p_applied_from_trx_id                        NUMBER,
402         p_applied_from_trx_level_type                VARCHAR2,
403         p_applied_from_line_id                       NUMBER,
404         p_adjusted_doc_application_id                NUMBER,
405         p_adjusted_doc_entity_code                   VARCHAR2,
406         p_adjusted_doc_evt_class_code                VARCHAR2,--reduced size p_adjusted_doc_event_class_code
410         p_applied_to_event_class_code                VARCHAR2,
407         p_adjusted_doc_trx_id                        NUMBER,
408         p_adjusted_doc_trx_level_type                VARCHAR2,
409         p_applied_to_application_id                  NUMBER,
411         p_applied_to_entity_code                     VARCHAR2,
412         p_applied_to_trx_id                          NUMBER,
413         p_applied_to_trx_level_type                  VARCHAR2,
414         p_applied_to_line_id                         NUMBER,
415         p_tax_exemption_id                           NUMBER,
416         p_tax_rate_before_exemption                  NUMBER,
417         p_tax_rate_name_before_exempt                VARCHAR2, --reduced size p_tax_rate_name_before_exemption
418         p_exempt_rate_modifier                       NUMBER,
419         p_exempt_certificate_number                  VARCHAR2,
420         p_exempt_reason                              VARCHAR2,
421         p_exempt_reason_code                         VARCHAR2,
422         p_tax_rate_before_exception                  NUMBER,
423         p_tax_rate_name_before_except                VARCHAR2, --reduced size p_tax_rate_name_before_exception
424         p_tax_exception_id                           NUMBER,
425         p_exception_rate                             NUMBER,
426         p_content_owner_id                           NUMBER,
427         p_tax_regime_code                            VARCHAR2,
428         p_tax                                        VARCHAR2,
429         p_tax_status_code                            VARCHAR2,
430         p_tax_rate_id                                NUMBER,
431         p_tax_rate_code                              VARCHAR2,
432         p_tax_rate                                   NUMBER,
433         p_tax_amt                                    NUMBER,
434         p_tax_amt_tax_curr                           NUMBER,
435         p_tax_amt_funcl_curr                         NUMBER,
436         p_tax_jurisdiction_code                      VARCHAR2,
437         p_total_rec_tax_amt                          NUMBER,
438         p_total_rec_tax_amt_func_curr                NUMBER,--reduced size p_total_rec_tax_amt_funcl_curr
439         p_total_rec_tax_amt_tax_curr                 NUMBER,
440         p_total_nrec_tax_amt                         NUMBER,
441         p_total_nrec_tax_amt_func_curr               NUMBER,--reduced size p_total_nrec_tax_amt_funcl_curr
442         p_total_nrec_tax_amt_tax_curr                NUMBER,
443         p_ledger_id                                  NUMBER,
444         p_legal_entity_id                            NUMBER,
445         p_establishment_id                           NUMBER,
446         p_currency_conversion_date                   DATE,
447         p_currency_conversion_type                   VARCHAR2,
448         p_currency_conversion_rate                   NUMBER,
449         p_summarization_template_id                  NUMBER,
450         p_taxable_basis_formula                      VARCHAR2,
451         p_tax_calculation_formula                    VARCHAR2,
452         p_historical_flag                            VARCHAR2,
453         p_cancel_flag                                VARCHAR2,
454         p_delete_flag                                VARCHAR2,
455         p_tax_amt_included_flag                      VARCHAR2,
456         p_compounding_tax_flag                       VARCHAR2,
457         p_self_assessed_flag                         VARCHAR2,
458         p_overridden_flag                            VARCHAR2,
459         p_reporting_only_flag                        VARCHAR2,
460         p_assoc_child_frozen_flag                    VARCHAR2,--reduced size p_Associated_Child_Frozen_Flag
461         p_copied_from_other_doc_flag                 VARCHAR2,
462         p_manually_entered_flag                      VARCHAR2,
463         p_mrc_tax_line_flag                          VARCHAR2,
464         p_last_manual_entry                          VARCHAR2,
465         p_record_type_code                           VARCHAR2,
466         p_tax_provider_id                            NUMBER,
467         p_tax_only_line_flag                         VARCHAR2,
468         p_adjust_tax_amt_flag                        VARCHAR2,
469         p_attribute_category                         VARCHAR2,
470         p_attribute1                                 VARCHAR2,
471         p_attribute2                                 VARCHAR2,
472         p_attribute3                                 VARCHAR2,
473         p_attribute4                                 VARCHAR2,
474         p_attribute5                                 VARCHAR2,
475         p_attribute6                                 VARCHAR2,
476         p_attribute7                                 VARCHAR2,
477         p_attribute8                                 VARCHAR2,
478         p_attribute9                                 VARCHAR2,
479         p_attribute10                                VARCHAR2,
480         p_attribute11                                VARCHAR2,
481         p_attribute12                                VARCHAR2,
482         p_attribute13                                VARCHAR2,
483         p_attribute14                                VARCHAR2,
484         p_attribute15                                VARCHAR2,
485         p_global_attribute_category                  VARCHAR2,
486         p_global_attribute1                          VARCHAR2,
487         p_global_attribute2                          VARCHAR2,
488         p_global_attribute3                          VARCHAR2,
489         p_global_attribute4                          VARCHAR2,
490         p_global_attribute5                          VARCHAR2,
491         p_global_attribute6                          VARCHAR2,
492         p_global_attribute7                          VARCHAR2,
493         p_global_attribute8                          VARCHAR2,
494         p_global_attribute9                          VARCHAR2,
495         p_global_attribute10                         VARCHAR2,
496         p_global_attribute11                         VARCHAR2,
497         p_global_attribute12                         VARCHAR2,
498         p_global_attribute13                         VARCHAR2,
499         p_global_attribute14                         VARCHAR2,
500         p_global_attribute15                         VARCHAR2,
501         p_global_attribute16                         VARCHAR2,
502         p_global_attribute17                         VARCHAR2,
503         p_global_attribute18                         VARCHAR2,
504         p_global_attribute19                         VARCHAR2,
505         p_global_attribute20                         VARCHAR2,
506         p_object_version_number                      NUMBER,
507         p_created_by                                 NUMBER,
508         p_creation_date                              DATE,
509         p_last_updated_by                            NUMBER,
510         p_last_update_date                           DATE,
511         p_last_update_login                          NUMBER);
512 
513   PROCEDURE Override_Row
514        (p_application_id                             NUMBER,
515         p_entity_code                                VARCHAR2,
516         p_event_class_code                           VARCHAR2,
517         p_trx_id                                     NUMBER,
518         p_event_id                                   NUMBER,
519         p_summary_tax_line_id                        NUMBER);
520 
521   PROCEDURE Check_Unique
522        (p_internal_organization_id                   NUMBER,
523         p_application_id                             NUMBER,
524         p_entity_code                                VARCHAR2,
525         p_event_class_code                           VARCHAR2,
526         p_trx_id                                     NUMBER,
527         p_tax_regime_code                            VARCHAR2,
528         p_tax                                        VARCHAR2,
529         p_tax_status_code                            VARCHAR2,
530         p_tax_rate_code                              VARCHAR2);
531 
532   PROCEDURE lock_summ_tax_lines_for_doc
533   			(p_application_id			IN NUMBER,
534   			 p_entity_code        IN VARCHAR2,
535   			 p_event_class_code   IN VARCHAR2,
536   			 p_trx_id             IN NUMBER,
537 			   x_return_status      OUT NOCOPY VARCHAR2,
538 			   x_error_buffer       OUT NOCOPY VARCHAR2);
539 
540 END ZX_TRL_SUMMARY_OVERRIDE_PKG;