[Home] [Help]
PACKAGE: APPS.ZX_TRL_DETAIL_OVERRIDE_PKG
Source
1 PACKAGE ZX_TRL_DETAIL_OVERRIDE_PKG AS
2 /* $Header: zxriovrdetlnpkgs.pls 120.36 2006/03/06 12:59:11 hvsingh ship $ */
3
4 PROCEDURE Insert_Row
5 (X_Rowid IN OUT NOCOPY VARCHAR2,
6 p_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_event_type_code VARCHAR2,
12 p_trx_id NUMBER,
13 p_trx_line_id NUMBER,
14 p_trx_level_type VARCHAR2,
15 p_trx_line_number NUMBER,
16 p_doc_event_status VARCHAR2,
17 p_tax_event_class_code VARCHAR2,
18 p_tax_event_type_code VARCHAR2,
19 p_tax_line_number NUMBER,
20 p_content_owner_id NUMBER,
21 p_tax_regime_id NUMBER,
22 p_tax_regime_code VARCHAR2,
23 p_tax_id NUMBER,
24 p_tax VARCHAR2,
25 p_tax_status_id NUMBER,
26 p_tax_status_code VARCHAR2,
27 p_tax_rate_id NUMBER,
28 p_tax_rate_code VARCHAR2,
29 p_tax_rate NUMBER,
30 p_tax_rate_type VARCHAR2,
31 p_tax_apportionment_line_num NUMBER,--reduced in size tax_apportionment_line_number
32 p_trx_id_level2 NUMBER,
33 p_trx_id_level3 NUMBER,
34 p_trx_id_level4 NUMBER,
35 p_trx_id_level5 NUMBER,
36 p_trx_id_level6 NUMBER,
37 p_trx_user_key_level1 VARCHAR2,
38 p_trx_user_key_level2 VARCHAR2,
39 p_trx_user_key_level3 VARCHAR2,
40 p_trx_user_key_level4 VARCHAR2,
41 p_trx_user_key_level5 VARCHAR2,
42 p_trx_user_key_level6 VARCHAR2,
43 p_mrc_tax_line_flag VARCHAR2,
44 p_mrc_link_to_tax_line_id NUMBER,
45 p_ledger_id NUMBER,
46 p_establishment_id NUMBER,
47 p_legal_entity_id NUMBER,
48 p_hq_estb_reg_number VARCHAR2,
49 p_hq_estb_party_tax_prof_id NUMBER,
50 p_currency_conversion_date DATE,
51 p_currency_conversion_type VARCHAR2,
52 p_currency_conversion_rate NUMBER,
53 p_tax_curr_conversion_date DATE,--reduced in size tax_currency_conversion_date
54 p_tax_curr_conversion_type VARCHAR2,--reduced in size p_tax_currency_conversion_type
55 p_tax_curr_conversion_rate NUMBER,--reduced in size p_tax_currency_conversion_rate
56 p_trx_currency_code VARCHAR2,
57 p_reporting_currency_code VARCHAR2,
58 p_minimum_accountable_unit NUMBER,
59 p_precision NUMBER,
60 p_trx_number VARCHAR2,
61 p_trx_date DATE,
62 p_unit_price NUMBER,
63 p_line_amt NUMBER,
64 p_trx_line_quantity NUMBER,
65 p_tax_base_modifier_rate NUMBER,
66 p_ref_doc_application_id NUMBER,
67 p_ref_doc_entity_code VARCHAR2,
68 p_ref_doc_event_class_code VARCHAR2,
69 p_ref_doc_trx_id NUMBER,
70 p_ref_doc_trx_level_type VARCHAR2,
71 p_ref_doc_line_id NUMBER,
72 p_ref_doc_line_quantity NUMBER,
73 p_other_doc_line_amt NUMBER,
74 p_other_doc_line_tax_amt NUMBER,
75 p_other_doc_line_taxable_amt NUMBER,
76 p_unrounded_taxable_amt NUMBER,
77 p_unrounded_tax_amt NUMBER,
78 p_related_doc_application_id NUMBER,
79 p_related_doc_entity_code VARCHAR2,
80 p_related_doc_evt_class_code VARCHAR2,--reduced in size p_related_doc_event_class_code
81 p_related_doc_trx_id NUMBER,
82 p_related_doc_trx_level_type VARCHAR2,
83 p_related_doc_number VARCHAR2,
84 p_related_doc_date DATE,
85 p_applied_from_appl_id NUMBER,--reduced in size p_applied_from_application_id
86 p_applied_from_evt_clss_code VARCHAR2,--reduced in size p_applied_from_event_class_code
87 p_applied_from_entity_code VARCHAR2,
88 p_applied_from_trx_id NUMBER,
89 p_applied_from_trx_level_type VARCHAR2,
90 p_applied_from_line_id NUMBER,
91 p_applied_from_trx_number VARCHAR2,
92 p_adjusted_doc_appln_id NUMBER,--reduced in size p_adjusted_doc_application_id
93 p_adjusted_doc_entity_code VARCHAR2,
94 p_adjusted_doc_evt_clss_code VARCHAR2,--reduced in size p_adjusted_doc_event_class_code
95 p_adjusted_doc_trx_id NUMBER,
96 p_adjusted_doc_trx_level_type VARCHAR2,
97 p_adjusted_doc_line_id NUMBER,
98 p_adjusted_doc_number VARCHAR2,
99 p_adjusted_doc_date DATE,
100 p_applied_to_application_id NUMBER,
101 p_applied_to_evt_class_code VARCHAR2,--reduced in size p_applied_to_event_class_code
102 p_applied_to_entity_code VARCHAR2,
103 p_applied_to_trx_id NUMBER,
104 p_applied_to_trx_level_type VARCHAR2,
105 p_applied_to_line_id NUMBER,
106 p_summary_tax_line_id NUMBER,
107 p_offset_link_to_tax_line_id NUMBER,
108 p_offset_flag VARCHAR2,
109 p_process_for_recovery_flag VARCHAR2,
110 p_tax_jurisdiction_id NUMBER,
111 p_tax_jurisdiction_code VARCHAR2,
112 p_place_of_supply NUMBER,
113 p_place_of_supply_type_code VARCHAR2,
114 p_place_of_supply_result_id NUMBER,
115 p_tax_date_rule_id NUMBER,
116 p_tax_date DATE,
117 p_tax_determine_date DATE,
118 p_tax_point_date DATE,
119 p_trx_line_date DATE,
120 p_tax_type_code VARCHAR2,
121 p_tax_code VARCHAR2,
122 p_tax_registration_id NUMBER,
123 p_tax_registration_number VARCHAR2,
124 p_registration_party_type VARCHAR2,
125 p_rounding_level_code VARCHAR2,
126 p_rounding_rule_code VARCHAR2,
127 p_rndg_lvl_party_tax_prof_id NUMBER,--reduced in size p_rounding_lvl_party_tax_prof_id
128 p_rounding_lvl_party_type VARCHAR2,
129 p_compounding_tax_flag VARCHAR2,
130 p_orig_tax_status_id NUMBER,
131 p_orig_tax_status_code VARCHAR2,
132 p_orig_tax_rate_id NUMBER,
133 p_orig_tax_rate_code VARCHAR2,
134 p_orig_tax_rate NUMBER,
135 p_orig_tax_jurisdiction_id NUMBER,
136 p_orig_tax_jurisdiction_code VARCHAR2,
137 p_orig_tax_amt_included_flag VARCHAR2,
138 p_orig_self_assessed_flag VARCHAR2,
139 p_tax_currency_code VARCHAR2,
140 p_tax_amt NUMBER,
141 p_tax_amt_tax_curr NUMBER,
142 p_tax_amt_funcl_curr NUMBER,
143 p_taxable_amt NUMBER,
144 p_taxable_amt_tax_curr NUMBER,
145 p_taxable_amt_funcl_curr NUMBER,
146 p_orig_taxable_amt NUMBER,
147 p_orig_taxable_amt_tax_curr NUMBER,
148 p_cal_tax_amt NUMBER,
149 p_cal_tax_amt_tax_curr NUMBER,
150 p_cal_tax_amt_funcl_curr NUMBER,
151 p_orig_tax_amt NUMBER,
152 p_orig_tax_amt_tax_curr NUMBER,
153 p_rec_tax_amt NUMBER,
154 p_rec_tax_amt_tax_curr NUMBER,
155 p_rec_tax_amt_funcl_curr NUMBER,
156 p_nrec_tax_amt NUMBER,
157 p_nrec_tax_amt_tax_curr NUMBER,
158 p_nrec_tax_amt_funcl_curr NUMBER,
159 p_tax_exemption_id NUMBER,
160 p_tax_rate_before_exemption NUMBER,
161 p_tax_rate_name_before_exempt VARCHAR2,
162 p_exempt_rate_modifier NUMBER,
163 p_exempt_certificate_number VARCHAR2,
164 p_exempt_reason VARCHAR2,
165 p_exempt_reason_code VARCHAR2,
166 p_tax_exception_id NUMBER,
167 p_tax_rate_before_exception NUMBER,
168 p_tax_rate_name_before_except VARCHAR2,
169 p_exception_rate NUMBER,
170 p_tax_apportionment_flag VARCHAR2,
171 p_historical_flag VARCHAR2,
172 p_taxable_basis_formula VARCHAR2,
173 p_tax_calculation_formula VARCHAR2,
174 p_cancel_flag VARCHAR2,
175 p_purge_flag VARCHAR2,
176 p_delete_flag VARCHAR2,
177 p_tax_amt_included_flag VARCHAR2,
178 p_self_assessed_flag VARCHAR2,
179 p_overridden_flag VARCHAR2,
180 p_manually_entered_flag VARCHAR2,
181 p_reporting_only_flag VARCHAR2,
182 p_freeze_until_overriddn_flg VARCHAR2,--reduced in size p_Freeze_Until_Overridden_Flag
183 p_copied_from_other_doc_flag VARCHAR2,
184 p_recalc_required_flag VARCHAR2,
185 p_settlement_flag VARCHAR2,
186 p_item_dist_changed_flag VARCHAR2,
187 p_assoc_children_frozen_flg VARCHAR2,--reduced in size p_Associated_Child_Frozen_Flag
188 p_tax_only_line_flag VARCHAR2,
189 p_compounding_dep_tax_flag VARCHAR2,
190 p_compounding_tax_miss_flag VARCHAR2,
191 p_sync_with_prvdr_flag VARCHAR2,
192 p_last_manual_entry VARCHAR2,
193 p_tax_provider_id NUMBER,
194 p_record_type_code VARCHAR2,
195 p_reporting_period_id NUMBER,
196 p_legal_justification_text1 VARCHAR2,
197 p_legal_justification_text2 VARCHAR2,
198 p_legal_justification_text3 VARCHAR2,
199 p_legal_message_appl_2 NUMBER,
200 p_legal_message_status NUMBER,
201 p_legal_message_rate NUMBER,
202 p_legal_message_basis NUMBER,
203 p_legal_message_calc NUMBER,
204 p_legal_message_threshold NUMBER,
205 p_legal_message_pos NUMBER,
206 p_legal_message_trn NUMBER,
207 p_legal_message_exmpt NUMBER,
208 p_legal_message_excpt NUMBER,
209 p_tax_regime_template_id NUMBER,
210 p_tax_applicability_result_id NUMBER,--reduced in size p_tax_applicability_result_id
211 p_direct_rate_result_id NUMBER,
212 p_status_result_id NUMBER,
213 p_rate_result_id NUMBER,
214 p_basis_result_id NUMBER,
215 p_thresh_result_id NUMBER,
216 p_calc_result_id NUMBER,
217 p_tax_reg_num_det_result_id NUMBER,
218 p_eval_exmpt_result_id NUMBER,
219 p_eval_excpt_result_id NUMBER,
220 p_enforced_from_nat_acct_flg VARCHAR2,--reduced in size p_Enforce_From_Natural_Acct_Flag
221 p_tax_hold_code NUMBER,
222 p_tax_hold_released_code NUMBER,
223 p_prd_total_tax_amt NUMBER,
224 p_prd_total_tax_amt_tax_curr NUMBER,
225 p_prd_total_tax_amt_funcl_curr NUMBER,
226 p_trx_line_index VARCHAR2,
227 p_offset_tax_rate_code VARCHAR2,
228 p_proration_code VARCHAR2,
229 p_other_doc_source VARCHAR2,
230 p_internal_org_location_id NUMBER,
231 p_line_assessable_value NUMBER,
232 p_ctrl_total_line_tx_amt NUMBER,
233 p_applied_to_trx_number VARCHAR2,
234 p_attribute_category VARCHAR2,
235 p_attribute1 VARCHAR2,
236 p_attribute2 VARCHAR2,
237 p_attribute3 VARCHAR2,
238 p_attribute4 VARCHAR2,
239 p_attribute5 VARCHAR2,
240 p_attribute6 VARCHAR2,
241 p_attribute7 VARCHAR2,
242 p_attribute8 VARCHAR2,
243 p_attribute9 VARCHAR2,
244 p_attribute10 VARCHAR2,
245 p_attribute11 VARCHAR2,
246 p_attribute12 VARCHAR2,
247 p_attribute13 VARCHAR2,
248 p_attribute14 VARCHAR2,
249 p_attribute15 VARCHAR2,
250 p_global_attribute_category VARCHAR2,
251 p_global_attribute1 VARCHAR2,
252 p_global_attribute2 VARCHAR2,
253 p_global_attribute3 VARCHAR2,
254 p_global_attribute4 VARCHAR2,
255 p_global_attribute5 VARCHAR2,
256 p_global_attribute6 VARCHAR2,
257 p_global_attribute7 VARCHAR2,
258 p_global_attribute8 VARCHAR2,
259 p_global_attribute9 VARCHAR2,
260 p_global_attribute10 VARCHAR2,
261 p_global_attribute11 VARCHAR2,
262 p_global_attribute12 VARCHAR2,
263 p_global_attribute13 VARCHAR2,
264 p_global_attribute14 VARCHAR2,
265 p_global_attribute15 VARCHAR2,
266 p_numeric1 NUMBER,
267 p_numeric2 NUMBER,
268 p_numeric3 NUMBER,
269 p_numeric4 NUMBER,
270 p_numeric5 NUMBER,
274 p_numeric9 NUMBER,
271 p_numeric6 NUMBER,
272 p_numeric7 NUMBER,
273 p_numeric8 NUMBER,
275 p_numeric10 NUMBER,
276 p_char1 VARCHAR2,
277 p_char2 VARCHAR2,
278 p_char3 VARCHAR2,
279 p_char4 VARCHAR2,
280 p_char5 VARCHAR2,
281 p_char6 VARCHAR2,
282 p_char7 VARCHAR2,
283 p_char8 VARCHAR2,
284 p_char9 VARCHAR2,
285 p_char10 VARCHAR2,
286 p_date1 DATE,
287 p_date2 DATE,
288 p_date3 DATE,
289 p_date4 DATE,
290 p_date5 DATE,
291 p_date6 DATE,
292 p_date7 DATE,
293 p_date8 DATE,
294 p_date9 DATE,
295 p_date10 DATE,
296 p_interface_entity_code VARCHAR2,
297 p_interface_tax_line_id NUMBER,
298 p_taxing_juris_geography_id NUMBER,
299 p_adjusted_doc_tax_line_id NUMBER,
300 p_object_version_number NUMBER,
301 p_created_by NUMBER,
302 p_creation_date DATE,
303 p_last_updated_by NUMBER,
304 p_last_update_date DATE,
305 p_last_update_login NUMBER);
306
307 PROCEDURE Lock_Row
308 (X_Rowid IN OUT NOCOPY VARCHAR2,
309 p_tax_line_id NUMBER,
310 p_internal_organization_id NUMBER,
311 p_application_id NUMBER,
312 p_entity_code VARCHAR2,
313 p_event_class_code VARCHAR2,
314 p_event_type_code VARCHAR2,
315 p_trx_id NUMBER,
316 p_trx_line_id NUMBER,
317 p_trx_level_type VARCHAR2,
318 p_trx_line_number NUMBER,
319 p_doc_event_status VARCHAR2,
320 p_tax_event_class_code VARCHAR2,
321 p_tax_event_type_code VARCHAR2,
322 p_tax_line_number NUMBER,
323 p_content_owner_id NUMBER,
324 p_tax_regime_id NUMBER,
325 p_tax_regime_code VARCHAR2,
326 p_tax_id NUMBER,
327 p_tax VARCHAR2,
328 p_tax_status_id NUMBER,
329 p_tax_status_code VARCHAR2,
330 p_tax_rate_id NUMBER,
331 p_tax_rate_code VARCHAR2,
332 p_tax_rate NUMBER,
333 p_tax_rate_type VARCHAR2,
334 p_tax_apportionment_line_num NUMBER,--reduced in size tax_apportionment_line_number
335 p_trx_id_level2 NUMBER,
336 p_trx_id_level3 NUMBER,
337 p_trx_id_level4 NUMBER,
338 p_trx_id_level5 NUMBER,
339 p_trx_id_level6 NUMBER,
340 p_trx_user_key_level1 VARCHAR2,
341 p_trx_user_key_level2 VARCHAR2,
342 p_trx_user_key_level3 VARCHAR2,
343 p_trx_user_key_level4 VARCHAR2,
344 p_trx_user_key_level5 VARCHAR2,
345 p_trx_user_key_level6 VARCHAR2,
346 p_mrc_tax_line_flag VARCHAR2,
347 p_mrc_link_to_tax_line_id NUMBER,
348 p_ledger_id NUMBER,
349 p_establishment_id NUMBER,
350 p_legal_entity_id NUMBER,
351 p_hq_estb_reg_number VARCHAR2,
352 p_hq_estb_party_tax_prof_id NUMBER,
356 p_tax_curr_conversion_date DATE,--reduced in size tax_currency_conversion_date
353 p_currency_conversion_date DATE,
354 p_currency_conversion_type VARCHAR2,
355 p_currency_conversion_rate NUMBER,
357 p_tax_curr_conversion_type VARCHAR2,--reduced in size p_tax_currency_conversion_type
358 p_tax_curr_conversion_rate NUMBER,--reduced in size p_tax_currency_conversion_rate
359 p_trx_currency_code VARCHAR2,
360 p_reporting_currency_code VARCHAR2,
361 p_minimum_accountable_unit NUMBER,
362 p_precision NUMBER,
363 p_trx_number VARCHAR2,
364 p_trx_date DATE,
365 p_unit_price NUMBER,
366 p_line_amt NUMBER,
367 p_trx_line_quantity NUMBER,
368 p_tax_base_modifier_rate NUMBER,
369 p_ref_doc_application_id NUMBER,
370 p_ref_doc_entity_code VARCHAR2,
371 p_ref_doc_event_class_code VARCHAR2,
372 p_ref_doc_trx_id NUMBER,
373 p_ref_doc_trx_level_type VARCHAR2,
374 p_ref_doc_line_id NUMBER,
375 p_ref_doc_line_quantity NUMBER,
376 p_other_doc_line_amt NUMBER,
377 p_other_doc_line_tax_amt NUMBER,
378 p_other_doc_line_taxable_amt NUMBER,
379 p_unrounded_taxable_amt NUMBER,
380 p_unrounded_tax_amt NUMBER,
381 p_related_doc_application_id NUMBER,
382 p_related_doc_entity_code VARCHAR2,
383 p_related_doc_evt_class_code VARCHAR2,--reduced in size p_related_doc_event_class_code
384 p_related_doc_trx_id NUMBER,
385 p_related_doc_trx_level_type VARCHAR2,
386 p_related_doc_number VARCHAR2,
387 p_related_doc_date DATE,
388 p_applied_from_appl_id NUMBER,--reduced in size p_applied_from_application_id
389 p_applied_from_evt_clss_code VARCHAR2,--reduced in size p_applied_from_event_class_code
390 p_applied_from_entity_code VARCHAR2,
391 p_applied_from_trx_id NUMBER,
392 p_applied_from_trx_level_type VARCHAR2,
393 p_applied_from_line_id NUMBER,
394 p_applied_from_trx_number VARCHAR2,
395 p_adjusted_doc_appln_id NUMBER,--reduced in size p_adjusted_doc_application_id
396 p_adjusted_doc_entity_code VARCHAR2,
397 p_adjusted_doc_evt_clss_code VARCHAR2,--reduced in size p_adjusted_doc_event_class_code
398 p_adjusted_doc_trx_id NUMBER,
399 p_adjusted_doc_trx_level_type VARCHAR2,
400 p_adjusted_doc_line_id NUMBER,
401 p_adjusted_doc_number VARCHAR2,
402 p_adjusted_doc_date DATE,
403 p_applied_to_application_id NUMBER,
404 p_applied_to_evt_class_code VARCHAR2,--reduced in size p_applied_to_event_class_code
405 p_applied_to_entity_code VARCHAR2,
406 p_applied_to_trx_id NUMBER,
407 p_applied_to_trx_level_type VARCHAR2,
408 p_applied_to_line_id NUMBER,
409 p_summary_tax_line_id NUMBER,
410 p_offset_link_to_tax_line_id NUMBER,
411 p_offset_flag VARCHAR2,
412 p_process_for_recovery_flag VARCHAR2,
413 p_tax_jurisdiction_id NUMBER,
414 p_tax_jurisdiction_code VARCHAR2,
415 p_place_of_supply NUMBER,
416 p_place_of_supply_type_code VARCHAR2,
417 p_place_of_supply_result_id NUMBER,
418 p_tax_date_rule_id NUMBER,
419 p_tax_date DATE,
420 p_tax_determine_date DATE,
421 p_tax_point_date DATE,
422 p_trx_line_date DATE,
423 p_tax_type_code VARCHAR2,
424 p_tax_code VARCHAR2,
425 p_tax_registration_id NUMBER,
426 p_tax_registration_number VARCHAR2,
427 p_registration_party_type VARCHAR2,
428 p_rounding_level_code VARCHAR2,
429 p_rounding_rule_code VARCHAR2,
430 p_rndg_lvl_party_tax_prof_id NUMBER,--reduced in size p_rounding_lvl_party_tax_prof_id
431 p_rounding_lvl_party_type VARCHAR2,
432 p_compounding_tax_flag VARCHAR2,
433 p_orig_tax_status_id NUMBER,
434 p_orig_tax_status_code VARCHAR2,
435 p_orig_tax_rate_id NUMBER,
436 p_orig_tax_rate_code VARCHAR2,
437 p_orig_tax_rate NUMBER,
438 p_orig_tax_jurisdiction_id NUMBER,
439 p_orig_tax_jurisdiction_code VARCHAR2,
440 p_orig_tax_amt_included_flag VARCHAR2,
441 p_orig_self_assessed_flag VARCHAR2,
442 p_tax_currency_code VARCHAR2,
446 p_taxable_amt NUMBER,
443 p_tax_amt NUMBER,
444 p_tax_amt_tax_curr NUMBER,
445 p_tax_amt_funcl_curr NUMBER,
447 p_taxable_amt_tax_curr NUMBER,
448 p_taxable_amt_funcl_curr NUMBER,
449 p_orig_taxable_amt NUMBER,
450 p_orig_taxable_amt_tax_curr NUMBER,
451 p_cal_tax_amt NUMBER,
452 p_cal_tax_amt_tax_curr NUMBER,
453 p_cal_tax_amt_funcl_curr NUMBER,
454 p_orig_tax_amt NUMBER,
455 p_orig_tax_amt_tax_curr NUMBER,
456 p_rec_tax_amt NUMBER,
457 p_rec_tax_amt_tax_curr NUMBER,
458 p_rec_tax_amt_funcl_curr NUMBER,
459 p_nrec_tax_amt NUMBER,
460 p_nrec_tax_amt_tax_curr NUMBER,
461 p_nrec_tax_amt_funcl_curr NUMBER,
462 p_tax_exemption_id NUMBER,
463 p_tax_rate_before_exemption NUMBER,
464 p_tax_rate_name_before_exempt VARCHAR2,
465 p_exempt_rate_modifier NUMBER,
466 p_exempt_certificate_number VARCHAR2,
467 p_exempt_reason VARCHAR2,
468 p_exempt_reason_code VARCHAR2,
469 p_tax_exception_id NUMBER,
470 p_tax_rate_before_exception NUMBER,
471 p_tax_rate_name_before_except VARCHAR2,
472 p_exception_rate NUMBER,
473 p_tax_apportionment_flag VARCHAR2,
474 p_historical_flag VARCHAR2,
475 p_taxable_basis_formula VARCHAR2,
476 p_tax_calculation_formula VARCHAR2,
477 p_cancel_flag VARCHAR2,
478 p_purge_flag VARCHAR2,
479 p_delete_flag VARCHAR2,
480 p_tax_amt_included_flag VARCHAR2,
481 p_self_assessed_flag VARCHAR2,
482 p_overridden_flag VARCHAR2,
483 p_manually_entered_flag VARCHAR2,
484 p_reporting_only_flag VARCHAR2,
485 p_freeze_until_overriddn_flg VARCHAR2,--reduced in size p_Freeze_Until_Overridden_Flag
486 p_copied_from_other_doc_flag VARCHAR2,
487 p_recalc_required_flag VARCHAR2,
488 p_settlement_flag VARCHAR2,
489 p_item_dist_changed_flag VARCHAR2,
490 p_assoc_children_frozen_flg VARCHAR2,--reduced in size p_Associated_Child_Frozen_Flag
491 p_tax_only_line_flag VARCHAR2,
492 p_compounding_dep_tax_flag VARCHAR2,
493 p_compounding_tax_miss_flag VARCHAR2,
494 p_sync_with_prvdr_flag VARCHAR2,
495 p_last_manual_entry VARCHAR2,
496 p_tax_provider_id NUMBER,
497 p_record_type_code VARCHAR2,
498 p_reporting_period_id NUMBER,
499 p_legal_justification_text1 VARCHAR2,
500 p_legal_justification_text2 VARCHAR2,
501 p_legal_justification_text3 VARCHAR2,
502 p_legal_message_appl_2 NUMBER,
503 p_legal_message_status NUMBER,
504 p_legal_message_rate NUMBER,
505 p_legal_message_basis NUMBER,
506 p_legal_message_calc NUMBER,
507 p_legal_message_threshold NUMBER,
508 p_legal_message_pos NUMBER,
509 p_legal_message_trn NUMBER,
510 p_legal_message_exmpt NUMBER,
511 p_legal_message_excpt NUMBER,
512 p_tax_regime_template_id NUMBER,
513 p_tax_applicability_result_id NUMBER,--reduced in size p_tax_applicability_result_id
514 p_direct_rate_result_id NUMBER,
515 p_status_result_id NUMBER,
516 p_rate_result_id NUMBER,
517 p_basis_result_id NUMBER,
518 p_thresh_result_id NUMBER,
519 p_calc_result_id NUMBER,
520 p_tax_reg_num_det_result_id NUMBER,
521 p_eval_exmpt_result_id NUMBER,
522 p_eval_excpt_result_id NUMBER,
523 p_enforced_from_nat_acct_flg VARCHAR2,--reduced in size p_Enforce_From_Natural_Acct_Flag
524 p_tax_hold_code NUMBER,
525 p_tax_hold_released_code NUMBER,
526 p_prd_total_tax_amt NUMBER,
527 p_prd_total_tax_amt_tax_curr NUMBER,
528 p_prd_total_tax_amt_funcl_curr NUMBER,
529 p_trx_line_index VARCHAR2,
530 p_offset_tax_rate_code VARCHAR2,
531 p_proration_code VARCHAR2,
532 p_other_doc_source VARCHAR2,
533 p_internal_org_location_id NUMBER,
534 p_line_assessable_value NUMBER,
535 p_ctrl_total_line_tx_amt NUMBER,
536 p_applied_to_trx_number VARCHAR2,
540 p_attribute3 VARCHAR2,
537 p_attribute_category VARCHAR2,
538 p_attribute1 VARCHAR2,
539 p_attribute2 VARCHAR2,
541 p_attribute4 VARCHAR2,
542 p_attribute5 VARCHAR2,
543 p_attribute6 VARCHAR2,
544 p_attribute7 VARCHAR2,
545 p_attribute8 VARCHAR2,
546 p_attribute9 VARCHAR2,
547 p_attribute10 VARCHAR2,
548 p_attribute11 VARCHAR2,
549 p_attribute12 VARCHAR2,
550 p_attribute13 VARCHAR2,
551 p_attribute14 VARCHAR2,
552 p_attribute15 VARCHAR2,
553 p_global_attribute_category VARCHAR2,
554 p_global_attribute1 VARCHAR2,
555 p_global_attribute2 VARCHAR2,
556 p_global_attribute3 VARCHAR2,
557 p_global_attribute4 VARCHAR2,
558 p_global_attribute5 VARCHAR2,
559 p_global_attribute6 VARCHAR2,
560 p_global_attribute7 VARCHAR2,
561 p_global_attribute8 VARCHAR2,
562 p_global_attribute9 VARCHAR2,
563 p_global_attribute10 VARCHAR2,
564 p_global_attribute11 VARCHAR2,
565 p_global_attribute12 VARCHAR2,
566 p_global_attribute13 VARCHAR2,
567 p_global_attribute14 VARCHAR2,
568 p_global_attribute15 VARCHAR2,
569 p_numeric1 NUMBER,
570 p_numeric2 NUMBER,
571 p_numeric3 NUMBER,
572 p_numeric4 NUMBER,
573 p_numeric5 NUMBER,
574 p_numeric6 NUMBER,
575 p_numeric7 NUMBER,
576 p_numeric8 NUMBER,
577 p_numeric9 NUMBER,
578 p_numeric10 NUMBER,
579 p_char1 VARCHAR2,
580 p_char2 VARCHAR2,
581 p_char3 VARCHAR2,
582 p_char4 VARCHAR2,
583 p_char5 VARCHAR2,
584 p_char6 VARCHAR2,
585 p_char7 VARCHAR2,
586 p_char8 VARCHAR2,
587 p_char9 VARCHAR2,
588 p_char10 VARCHAR2,
589 p_date1 DATE,
590 p_date2 DATE,
591 p_date3 DATE,
592 p_date4 DATE,
593 p_date5 DATE,
594 p_date6 DATE,
595 p_date7 DATE,
596 p_date8 DATE,
597 p_date9 DATE,
598 p_date10 DATE,
599 p_interface_entity_code VARCHAR2,
600 p_interface_tax_line_id NUMBER,
601 p_taxing_juris_geography_id NUMBER,
602 p_adjusted_doc_tax_line_id NUMBER,
603 p_object_version_number NUMBER,
604 p_created_by NUMBER,
605 p_creation_date DATE,
606 p_last_updated_by NUMBER,
607 p_last_update_date DATE,
608 p_last_update_login NUMBER);
609
610 PROCEDURE Update_Row
611 (--X_Rowid IN OUT NOCOPY VARCHAR2,
612 p_tax_line_id NUMBER,
613 p_internal_organization_id NUMBER,
614 p_application_id NUMBER,
615 p_entity_code VARCHAR2,
616 p_event_class_code VARCHAR2,
617 p_event_type_code VARCHAR2,
618 p_trx_id NUMBER,
619 p_trx_line_id NUMBER,
620 p_trx_level_type VARCHAR2,
621 p_trx_line_number NUMBER,
622 p_doc_event_status VARCHAR2,
623 p_tax_event_class_code VARCHAR2,
624 p_tax_event_type_code VARCHAR2,
625 p_tax_line_number NUMBER,
626 p_content_owner_id NUMBER,
627 p_tax_regime_id NUMBER,
628 p_tax_regime_code VARCHAR2,
629 p_tax_id NUMBER,
630 p_tax VARCHAR2,
631 p_tax_status_id NUMBER,
632 p_tax_status_code VARCHAR2,
633 p_tax_rate_id NUMBER,
634 p_tax_rate_code VARCHAR2,
638 p_trx_id_level2 NUMBER,
635 p_tax_rate NUMBER,
636 p_tax_rate_type VARCHAR2,
637 p_tax_apportionment_line_num NUMBER,--reduced in size tax_apportionment_line_number
639 p_trx_id_level3 NUMBER,
640 p_trx_id_level4 NUMBER,
641 p_trx_id_level5 NUMBER,
642 p_trx_id_level6 NUMBER,
643 p_trx_user_key_level1 VARCHAR2,
644 p_trx_user_key_level2 VARCHAR2,
645 p_trx_user_key_level3 VARCHAR2,
646 p_trx_user_key_level4 VARCHAR2,
647 p_trx_user_key_level5 VARCHAR2,
648 p_trx_user_key_level6 VARCHAR2,
649 p_mrc_tax_line_flag VARCHAR2,
650 p_mrc_link_to_tax_line_id NUMBER,
651 p_ledger_id NUMBER,
652 p_establishment_id NUMBER,
653 p_legal_entity_id NUMBER,
654 p_hq_estb_reg_number VARCHAR2,
655 p_hq_estb_party_tax_prof_id NUMBER,
656 p_currency_conversion_date DATE,
657 p_currency_conversion_type VARCHAR2,
658 p_currency_conversion_rate NUMBER,
659 p_tax_curr_conversion_date DATE,--reduced in size tax_currency_conversion_date
660 p_tax_curr_conversion_type VARCHAR2,--reduced in size p_tax_currency_conversion_type
661 p_tax_curr_conversion_rate NUMBER,--reduced in size p_tax_currency_conversion_rate
662 p_trx_currency_code VARCHAR2,
663 p_reporting_currency_code VARCHAR2,
664 p_minimum_accountable_unit NUMBER,
665 p_precision NUMBER,
666 p_trx_number VARCHAR2,
667 p_trx_date DATE,
668 p_unit_price NUMBER,
669 p_line_amt NUMBER,
670 p_trx_line_quantity NUMBER,
671 p_tax_base_modifier_rate NUMBER,
672 p_ref_doc_application_id NUMBER,
673 p_ref_doc_entity_code VARCHAR2,
674 p_ref_doc_event_class_code VARCHAR2,
675 p_ref_doc_trx_id NUMBER,
676 p_ref_doc_trx_level_type VARCHAR2,
677 p_ref_doc_line_id NUMBER,
678 p_ref_doc_line_quantity NUMBER,
679 p_other_doc_line_amt NUMBER,
680 p_other_doc_line_tax_amt NUMBER,
681 p_other_doc_line_taxable_amt NUMBER,
682 p_unrounded_taxable_amt NUMBER,
683 p_unrounded_tax_amt NUMBER,
684 p_related_doc_application_id NUMBER,
685 p_related_doc_entity_code VARCHAR2,
686 p_related_doc_evt_class_code VARCHAR2,--reduced in size p_related_doc_event_class_code
687 p_related_doc_trx_id NUMBER,
688 p_related_doc_trx_level_type VARCHAR2,
689 p_related_doc_number VARCHAR2,
690 p_related_doc_date DATE,
691 p_applied_from_appl_id NUMBER,--reduced in size p_applied_from_application_id
692 p_applied_from_evt_clss_code VARCHAR2,--reduced in size p_applied_from_event_class_code
693 p_applied_from_entity_code VARCHAR2,
694 p_applied_from_trx_id NUMBER,
695 p_applied_from_trx_level_type VARCHAR2,
696 p_applied_from_line_id NUMBER,
697 p_applied_from_trx_number VARCHAR2,
698 p_adjusted_doc_appln_id NUMBER,--reduced in size p_adjusted_doc_application_id
699 p_adjusted_doc_entity_code VARCHAR2,
700 p_adjusted_doc_evt_clss_code VARCHAR2,--reduced in size p_adjusted_doc_event_class_code
701 p_adjusted_doc_trx_id NUMBER,
702 p_adjusted_doc_trx_level_type VARCHAR2,
703 p_adjusted_doc_line_id NUMBER,
704 p_adjusted_doc_number VARCHAR2,
705 p_adjusted_doc_date DATE,
706 p_applied_to_application_id NUMBER,
707 p_applied_to_evt_class_code VARCHAR2,--reduced in size p_applied_to_event_class_code
708 p_applied_to_entity_code VARCHAR2,
709 p_applied_to_trx_id NUMBER,
710 p_applied_to_trx_level_type VARCHAR2,
711 p_applied_to_line_id NUMBER,
712 p_summary_tax_line_id NUMBER,
713 p_offset_link_to_tax_line_id NUMBER,
714 p_offset_flag VARCHAR2,
715 p_process_for_recovery_flag VARCHAR2,
716 p_tax_jurisdiction_id NUMBER,
717 p_tax_jurisdiction_code VARCHAR2,
718 p_place_of_supply NUMBER,
719 p_place_of_supply_type_code VARCHAR2,
720 p_place_of_supply_result_id NUMBER,
721 p_tax_date_rule_id NUMBER,
722 p_tax_date DATE,
723 p_tax_determine_date DATE,
727 p_tax_code VARCHAR2,
724 p_tax_point_date DATE,
725 p_trx_line_date DATE,
726 p_tax_type_code VARCHAR2,
728 p_tax_registration_id NUMBER,
729 p_tax_registration_number VARCHAR2,
730 p_registration_party_type VARCHAR2,
731 p_rounding_level_code VARCHAR2,
732 p_rounding_rule_code VARCHAR2,
733 p_rndg_lvl_party_tax_prof_id NUMBER,--reduced in size p_rounding_lvl_party_tax_prof_id
734 p_rounding_lvl_party_type VARCHAR2,
735 p_compounding_tax_flag VARCHAR2,
736 p_orig_tax_status_id NUMBER,
737 p_orig_tax_status_code VARCHAR2,
738 p_orig_tax_rate_id NUMBER,
739 p_orig_tax_rate_code VARCHAR2,
740 p_orig_tax_rate NUMBER,
741 p_orig_tax_jurisdiction_id NUMBER,
742 p_orig_tax_jurisdiction_code VARCHAR2,
743 p_orig_tax_amt_included_flag VARCHAR2,
744 p_orig_self_assessed_flag VARCHAR2,
745 p_tax_currency_code VARCHAR2,
746 p_tax_amt NUMBER,
747 p_tax_amt_tax_curr NUMBER,
748 p_tax_amt_funcl_curr NUMBER,
749 p_taxable_amt NUMBER,
750 p_taxable_amt_tax_curr NUMBER,
751 p_taxable_amt_funcl_curr NUMBER,
752 p_orig_taxable_amt NUMBER,
753 p_orig_taxable_amt_tax_curr NUMBER,
754 p_cal_tax_amt NUMBER,
755 p_cal_tax_amt_tax_curr NUMBER,
756 p_cal_tax_amt_funcl_curr NUMBER,
757 p_orig_tax_amt NUMBER,
758 p_orig_tax_amt_tax_curr NUMBER,
759 p_rec_tax_amt NUMBER,
760 p_rec_tax_amt_tax_curr NUMBER,
761 p_rec_tax_amt_funcl_curr NUMBER,
762 p_nrec_tax_amt NUMBER,
763 p_nrec_tax_amt_tax_curr NUMBER,
764 p_nrec_tax_amt_funcl_curr NUMBER,
765 p_tax_exemption_id NUMBER,
766 p_tax_rate_before_exemption NUMBER,
767 p_tax_rate_name_before_exempt VARCHAR2,
768 p_exempt_rate_modifier NUMBER,
769 p_exempt_certificate_number VARCHAR2,
770 p_exempt_reason VARCHAR2,
771 p_exempt_reason_code VARCHAR2,
772 p_tax_exception_id NUMBER,
773 p_tax_rate_before_exception NUMBER,
774 p_tax_rate_name_before_except VARCHAR2,
775 p_exception_rate NUMBER,
776 p_tax_apportionment_flag VARCHAR2,
777 p_historical_flag VARCHAR2,
778 p_taxable_basis_formula VARCHAR2,
779 p_tax_calculation_formula VARCHAR2,
780 p_cancel_flag VARCHAR2,
781 p_purge_flag VARCHAR2,
782 p_delete_flag VARCHAR2,
783 p_tax_amt_included_flag VARCHAR2,
784 p_self_assessed_flag VARCHAR2,
785 p_overridden_flag VARCHAR2,
786 p_manually_entered_flag VARCHAR2,
787 p_reporting_only_flag VARCHAR2,
788 p_freeze_until_overriddn_flg VARCHAR2,--reduced in size p_Freeze_Until_Overridden_Flag
789 p_copied_from_other_doc_flag VARCHAR2,
790 p_recalc_required_flag VARCHAR2,
791 p_settlement_flag VARCHAR2,
792 p_item_dist_changed_flag VARCHAR2,
793 p_assoc_children_frozen_flg VARCHAR2,--reduced in size p_Associated_Child_Frozen_Flag
794 p_tax_only_line_flag VARCHAR2,
795 p_compounding_dep_tax_flag VARCHAR2,
796 p_compounding_tax_miss_flag VARCHAR2,
797 p_sync_with_prvdr_flag VARCHAR2,
798 p_last_manual_entry VARCHAR2,
799 p_tax_provider_id NUMBER,
800 p_record_type_code VARCHAR2,
801 p_reporting_period_id NUMBER,
802 p_legal_justification_text1 VARCHAR2,
803 p_legal_justification_text2 VARCHAR2,
804 p_legal_justification_text3 VARCHAR2,
805 p_legal_message_appl_2 NUMBER,
806 p_legal_message_status NUMBER,
807 p_legal_message_rate NUMBER,
808 p_legal_message_basis NUMBER,
809 p_legal_message_calc NUMBER,
810 p_legal_message_threshold NUMBER,
811 p_legal_message_pos NUMBER,
812 p_legal_message_trn NUMBER,
813 p_legal_message_exmpt NUMBER,
814 p_legal_message_excpt NUMBER,
815 p_tax_regime_template_id NUMBER,
816 p_tax_applicability_result_id NUMBER,--reduced in size p_tax_applicability_result_id
817 p_direct_rate_result_id NUMBER,
821 p_thresh_result_id NUMBER,
818 p_status_result_id NUMBER,
819 p_rate_result_id NUMBER,
820 p_basis_result_id NUMBER,
822 p_calc_result_id NUMBER,
823 p_tax_reg_num_det_result_id NUMBER,
824 p_eval_exmpt_result_id NUMBER,
825 p_eval_excpt_result_id NUMBER,
826 p_enforced_from_nat_acct_flg VARCHAR2,--reduced in size p_Enforce_From_Natural_Acct_Flag
827 p_tax_hold_code NUMBER,
828 p_tax_hold_released_code NUMBER,
829 p_prd_total_tax_amt NUMBER,
830 p_prd_total_tax_amt_tax_curr NUMBER,
831 p_prd_total_tax_amt_funcl_curr NUMBER,
832 p_trx_line_index VARCHAR2,
833 p_offset_tax_rate_code VARCHAR2,
834 p_proration_code VARCHAR2,
835 p_other_doc_source VARCHAR2,
836 p_internal_org_location_id NUMBER,
837 p_line_assessable_value NUMBER,
838 p_ctrl_total_line_tx_amt NUMBER,
839 p_applied_to_trx_number VARCHAR2,
840 p_attribute_category VARCHAR2,
841 p_attribute1 VARCHAR2,
842 p_attribute2 VARCHAR2,
843 p_attribute3 VARCHAR2,
844 p_attribute4 VARCHAR2,
845 p_attribute5 VARCHAR2,
846 p_attribute6 VARCHAR2,
847 p_attribute7 VARCHAR2,
848 p_attribute8 VARCHAR2,
849 p_attribute9 VARCHAR2,
850 p_attribute10 VARCHAR2,
851 p_attribute11 VARCHAR2,
852 p_attribute12 VARCHAR2,
853 p_attribute13 VARCHAR2,
854 p_attribute14 VARCHAR2,
855 p_attribute15 VARCHAR2,
856 p_global_attribute_category VARCHAR2,
857 p_global_attribute1 VARCHAR2,
858 p_global_attribute2 VARCHAR2,
859 p_global_attribute3 VARCHAR2,
860 p_global_attribute4 VARCHAR2,
861 p_global_attribute5 VARCHAR2,
862 p_global_attribute6 VARCHAR2,
863 p_global_attribute7 VARCHAR2,
864 p_global_attribute8 VARCHAR2,
865 p_global_attribute9 VARCHAR2,
866 p_global_attribute10 VARCHAR2,
867 p_global_attribute11 VARCHAR2,
868 p_global_attribute12 VARCHAR2,
869 p_global_attribute13 VARCHAR2,
870 p_global_attribute14 VARCHAR2,
871 p_global_attribute15 VARCHAR2,
872 p_numeric1 NUMBER,
873 p_numeric2 NUMBER,
874 p_numeric3 NUMBER,
875 p_numeric4 NUMBER,
876 p_numeric5 NUMBER,
877 p_numeric6 NUMBER,
878 p_numeric7 NUMBER,
879 p_numeric8 NUMBER,
880 p_numeric9 NUMBER,
881 p_numeric10 NUMBER,
882 p_char1 VARCHAR2,
883 p_char2 VARCHAR2,
884 p_char3 VARCHAR2,
885 p_char4 VARCHAR2,
886 p_char5 VARCHAR2,
887 p_char6 VARCHAR2,
888 p_char7 VARCHAR2,
889 p_char8 VARCHAR2,
890 p_char9 VARCHAR2,
891 p_char10 VARCHAR2,
892 p_date1 DATE,
893 p_date2 DATE,
894 p_date3 DATE,
895 p_date4 DATE,
896 p_date5 DATE,
897 p_date6 DATE,
898 p_date7 DATE,
899 p_date8 DATE,
900 p_date9 DATE,
901 p_date10 DATE,
902 p_interface_entity_code VARCHAR2,
903 p_interface_tax_line_id NUMBER,
904 p_taxing_juris_geography_id NUMBER,
905 p_adjusted_doc_tax_line_id NUMBER,
906 p_object_version_number NUMBER,
907 --p_created_by NUMBER,
908 --p_creation_date DATE,
909 p_last_updated_by NUMBER,
910 p_last_update_date DATE,
911 p_last_update_login NUMBER);
912
913 PROCEDURE Delete_Row
914 (X_Rowid IN OUT NOCOPY VARCHAR2,
915 p_tax_line_id NUMBER,
919 p_event_class_code VARCHAR2,
916 p_internal_organization_id NUMBER,
917 p_application_id NUMBER,
918 p_entity_code VARCHAR2,
920 p_event_type_code VARCHAR2,
921 p_trx_id NUMBER,
922 p_trx_line_id NUMBER,
923 p_trx_level_type VARCHAR2,
924 p_trx_line_number NUMBER,
925 p_doc_event_status VARCHAR2,
926 p_tax_event_class_code VARCHAR2,
927 p_tax_event_type_code VARCHAR2,
928 p_tax_line_number NUMBER,
929 p_content_owner_id NUMBER,
930 p_tax_regime_id NUMBER,
931 p_tax_regime_code VARCHAR2,
932 p_tax_id NUMBER,
933 p_tax VARCHAR2,
934 p_tax_status_id NUMBER,
935 p_tax_status_code VARCHAR2,
936 p_tax_rate_id NUMBER,
937 p_tax_rate_code VARCHAR2,
938 p_tax_rate NUMBER,
939 p_tax_rate_type VARCHAR2,
940 p_tax_apportionment_line_num NUMBER,--reduced in size tax_apportionment_line_number
941 p_trx_id_level2 NUMBER,
942 p_trx_id_level3 NUMBER,
943 p_trx_id_level4 NUMBER,
944 p_trx_id_level5 NUMBER,
945 p_trx_id_level6 NUMBER,
946 p_trx_user_key_level1 VARCHAR2,
947 p_trx_user_key_level2 VARCHAR2,
948 p_trx_user_key_level3 VARCHAR2,
949 p_trx_user_key_level4 VARCHAR2,
950 p_trx_user_key_level5 VARCHAR2,
951 p_trx_user_key_level6 VARCHAR2,
952 p_mrc_tax_line_flag VARCHAR2,
953 p_mrc_link_to_tax_line_id NUMBER,
954 p_ledger_id NUMBER,
955 p_establishment_id NUMBER,
956 p_legal_entity_id NUMBER,
957 p_hq_estb_reg_number VARCHAR2,
958 p_hq_estb_party_tax_prof_id NUMBER,
959 p_currency_conversion_date DATE,
960 p_currency_conversion_type VARCHAR2,
961 p_currency_conversion_rate NUMBER,
962 p_tax_curr_conversion_date DATE,--reduced in size tax_currency_conversion_date
963 p_tax_curr_conversion_type VARCHAR2,--reduced in size p_tax_currency_conversion_type
964 p_tax_curr_conversion_rate NUMBER,--reduced in size p_tax_currency_conversion_rate
965 p_trx_currency_code VARCHAR2,
966 p_reporting_currency_code VARCHAR2,
967 p_minimum_accountable_unit NUMBER,
968 p_precision NUMBER,
969 p_trx_number VARCHAR2,
970 p_trx_date DATE,
971 p_unit_price NUMBER,
972 p_line_amt NUMBER,
973 p_trx_line_quantity NUMBER,
974 p_tax_base_modifier_rate NUMBER,
975 p_ref_doc_application_id NUMBER,
976 p_ref_doc_entity_code VARCHAR2,
977 p_ref_doc_event_class_code VARCHAR2,
978 p_ref_doc_trx_id NUMBER,
979 p_ref_doc_trx_level_type VARCHAR2,
980 p_ref_doc_line_id NUMBER,
981 p_ref_doc_line_quantity NUMBER,
982 p_other_doc_line_amt NUMBER,
983 p_other_doc_line_tax_amt NUMBER,
984 p_other_doc_line_taxable_amt NUMBER,
985 p_unrounded_taxable_amt NUMBER,
986 p_unrounded_tax_amt NUMBER,
987 p_related_doc_application_id NUMBER,
988 p_related_doc_entity_code VARCHAR2,
989 p_related_doc_evt_class_code VARCHAR2,--reduced in size p_related_doc_event_class_code
990 p_related_doc_trx_id NUMBER,
991 p_related_doc_trx_level_type VARCHAR2,
992 p_related_doc_number VARCHAR2,
993 p_related_doc_date DATE,
994 p_applied_from_appl_id NUMBER,--reduced in size p_applied_from_application_id
995 p_applied_from_evt_clss_code VARCHAR2,--reduced in size p_applied_from_event_class_code
996 p_applied_from_entity_code VARCHAR2,
997 p_applied_from_trx_id NUMBER,
998 p_applied_from_trx_level_type VARCHAR2,
999 p_applied_from_line_id NUMBER,
1000 p_applied_from_trx_number VARCHAR2,
1001 p_adjusted_doc_appln_id NUMBER,--reduced in size p_adjusted_doc_application_id
1002 p_adjusted_doc_entity_code VARCHAR2,
1003 p_adjusted_doc_evt_clss_code VARCHAR2,--reduced in size p_adjusted_doc_event_class_code
1004 p_adjusted_doc_trx_id NUMBER,
1005 p_adjusted_doc_trx_level_type VARCHAR2,
1006 p_adjusted_doc_line_id NUMBER,
1010 p_applied_to_evt_class_code VARCHAR2,--reduced in size p_applied_to_event_class_code
1007 p_adjusted_doc_number VARCHAR2,
1008 p_adjusted_doc_date DATE,
1009 p_applied_to_application_id NUMBER,
1011 p_applied_to_entity_code VARCHAR2,
1012 p_applied_to_trx_id NUMBER,
1013 p_applied_to_trx_level_type VARCHAR2,
1014 p_applied_to_line_id NUMBER,
1015 p_summary_tax_line_id NUMBER,
1016 p_offset_link_to_tax_line_id NUMBER,
1017 p_offset_flag VARCHAR2,
1018 p_process_for_recovery_flag VARCHAR2,
1019 p_tax_jurisdiction_id NUMBER,
1020 p_tax_jurisdiction_code VARCHAR2,
1021 p_place_of_supply NUMBER,
1022 p_place_of_supply_type_code VARCHAR2,
1023 p_place_of_supply_result_id NUMBER,
1024 p_tax_date_rule_id NUMBER,
1025 p_tax_date DATE,
1026 p_tax_determine_date DATE,
1027 p_tax_point_date DATE,
1028 p_trx_line_date DATE,
1029 p_tax_type_code VARCHAR2,
1030 p_tax_code VARCHAR2,
1031 p_tax_registration_id NUMBER,
1032 p_tax_registration_number VARCHAR2,
1033 p_registration_party_type VARCHAR2,
1034 p_rounding_level_code VARCHAR2,
1035 p_rounding_rule_code VARCHAR2,
1036 p_rndg_lvl_party_tax_prof_id NUMBER,--reduced in size p_rounding_lvl_party_tax_prof_id
1037 p_rounding_lvl_party_type VARCHAR2,
1038 p_compounding_tax_flag VARCHAR2,
1039 p_orig_tax_status_id NUMBER,
1040 p_orig_tax_status_code VARCHAR2,
1041 p_orig_tax_rate_id NUMBER,
1042 p_orig_tax_rate_code VARCHAR2,
1043 p_orig_tax_rate NUMBER,
1044 p_orig_tax_jurisdiction_id NUMBER,
1045 p_orig_tax_jurisdiction_code VARCHAR2,
1046 p_orig_tax_amt_included_flag VARCHAR2,
1047 p_orig_self_assessed_flag VARCHAR2,
1048 p_tax_currency_code VARCHAR2,
1049 p_tax_amt NUMBER,
1050 p_tax_amt_tax_curr NUMBER,
1051 p_tax_amt_funcl_curr NUMBER,
1052 p_taxable_amt NUMBER,
1053 p_taxable_amt_tax_curr NUMBER,
1054 p_taxable_amt_funcl_curr NUMBER,
1055 p_orig_taxable_amt NUMBER,
1056 p_orig_taxable_amt_tax_curr NUMBER,
1057 p_cal_tax_amt NUMBER,
1058 p_cal_tax_amt_tax_curr NUMBER,
1059 p_cal_tax_amt_funcl_curr NUMBER,
1060 p_orig_tax_amt NUMBER,
1061 p_orig_tax_amt_tax_curr NUMBER,
1062 p_rec_tax_amt NUMBER,
1063 p_rec_tax_amt_tax_curr NUMBER,
1064 p_rec_tax_amt_funcl_curr NUMBER,
1065 p_nrec_tax_amt NUMBER,
1066 p_nrec_tax_amt_tax_curr NUMBER,
1067 p_nrec_tax_amt_funcl_curr NUMBER,
1068 p_tax_exemption_id NUMBER,
1069 p_tax_rate_before_exemption NUMBER,
1070 p_tax_rate_name_before_exempt VARCHAR2,
1071 p_exempt_rate_modifier NUMBER,
1072 p_exempt_certificate_number VARCHAR2,
1073 p_exempt_reason VARCHAR2,
1074 p_exempt_reason_code VARCHAR2,
1075 p_tax_exception_id NUMBER,
1076 p_tax_rate_before_exception NUMBER,
1077 p_tax_rate_name_before_except VARCHAR2,
1078 p_exception_rate NUMBER,
1079 p_tax_apportionment_flag VARCHAR2,
1080 p_historical_flag VARCHAR2,
1081 p_taxable_basis_formula VARCHAR2,
1082 p_tax_calculation_formula VARCHAR2,
1083 p_cancel_flag VARCHAR2,
1084 p_purge_flag VARCHAR2,
1085 p_delete_flag VARCHAR2,
1086 p_tax_amt_included_flag VARCHAR2,
1087 p_self_assessed_flag VARCHAR2,
1088 p_overridden_flag VARCHAR2,
1089 p_manually_entered_flag VARCHAR2,
1090 p_reporting_only_flag VARCHAR2,
1091 p_freeze_until_overriddn_flg VARCHAR2,--reduced in size p_Freeze_Until_Overridden_Flag
1092 p_copied_from_other_doc_flag VARCHAR2,
1093 p_recalc_required_flag VARCHAR2,
1094 p_settlement_flag VARCHAR2,
1095 p_item_dist_changed_flag VARCHAR2,
1096 p_assoc_children_frozen_flg VARCHAR2,--reduced in size p_Associated_Child_Frozen_Flag
1097 p_tax_only_line_flag VARCHAR2,
1098 p_compounding_dep_tax_flag VARCHAR2,
1099 p_compounding_tax_miss_flag VARCHAR2,
1100 p_sync_with_prvdr_flag VARCHAR2,
1104 p_reporting_period_id NUMBER,
1101 p_last_manual_entry VARCHAR2,
1102 p_tax_provider_id NUMBER,
1103 p_record_type_code VARCHAR2,
1105 p_legal_justification_text1 VARCHAR2,
1106 p_legal_justification_text2 VARCHAR2,
1107 p_legal_justification_text3 VARCHAR2,
1108 p_legal_message_appl_2 NUMBER,
1109 p_legal_message_status NUMBER,
1110 p_legal_message_rate NUMBER,
1111 p_legal_message_basis NUMBER,
1112 p_legal_message_calc NUMBER,
1113 p_legal_message_threshold NUMBER,
1114 p_legal_message_pos NUMBER,
1115 p_legal_message_trn NUMBER,
1116 p_legal_message_exmpt NUMBER,
1117 p_legal_message_excpt NUMBER,
1118 p_tax_regime_template_id NUMBER,
1119 p_tax_applicability_result_id NUMBER,--reduced in size p_tax_applicability_result_id
1120 p_direct_rate_result_id NUMBER,
1121 p_status_result_id NUMBER,
1122 p_rate_result_id NUMBER,
1123 p_basis_result_id NUMBER,
1124 p_thresh_result_id NUMBER,
1125 p_calc_result_id NUMBER,
1126 p_tax_reg_num_det_result_id NUMBER,
1127 p_eval_exmpt_result_id NUMBER,
1128 p_eval_excpt_result_id NUMBER,
1129 p_enforced_from_nat_acct_flg VARCHAR2,--reduced in size p_Enforce_From_Natural_Acct_Flag
1130 p_tax_hold_code NUMBER,
1131 p_tax_hold_released_code NUMBER,
1132 p_prd_total_tax_amt NUMBER,
1133 p_prd_total_tax_amt_tax_curr NUMBER,
1134 p_prd_total_tax_amt_funcl_curr NUMBER,
1135 p_trx_line_index VARCHAR2,
1136 p_offset_tax_rate_code VARCHAR2,
1137 p_proration_code VARCHAR2,
1138 p_other_doc_source VARCHAR2,
1139 p_internal_org_location_id NUMBER,
1140 p_line_assessable_value NUMBER,
1141 p_ctrl_total_line_tx_amt NUMBER,
1142 p_applied_to_trx_number VARCHAR2,
1143 p_attribute_category VARCHAR2,
1144 p_attribute1 VARCHAR2,
1145 p_attribute2 VARCHAR2,
1146 p_attribute3 VARCHAR2,
1147 p_attribute4 VARCHAR2,
1148 p_attribute5 VARCHAR2,
1149 p_attribute6 VARCHAR2,
1150 p_attribute7 VARCHAR2,
1151 p_attribute8 VARCHAR2,
1152 p_attribute9 VARCHAR2,
1153 p_attribute10 VARCHAR2,
1154 p_attribute11 VARCHAR2,
1155 p_attribute12 VARCHAR2,
1156 p_attribute13 VARCHAR2,
1157 p_attribute14 VARCHAR2,
1158 p_attribute15 VARCHAR2,
1159 p_global_attribute_category VARCHAR2,
1160 p_global_attribute1 VARCHAR2,
1161 p_global_attribute2 VARCHAR2,
1162 p_global_attribute3 VARCHAR2,
1163 p_global_attribute4 VARCHAR2,
1164 p_global_attribute5 VARCHAR2,
1165 p_global_attribute6 VARCHAR2,
1166 p_global_attribute7 VARCHAR2,
1167 p_global_attribute8 VARCHAR2,
1168 p_global_attribute9 VARCHAR2,
1169 p_global_attribute10 VARCHAR2,
1170 p_global_attribute11 VARCHAR2,
1171 p_global_attribute12 VARCHAR2,
1172 p_global_attribute13 VARCHAR2,
1173 p_global_attribute14 VARCHAR2,
1174 p_global_attribute15 VARCHAR2,
1175 p_numeric1 NUMBER,
1176 p_numeric2 NUMBER,
1177 p_numeric3 NUMBER,
1178 p_numeric4 NUMBER,
1179 p_numeric5 NUMBER,
1180 p_numeric6 NUMBER,
1181 p_numeric7 NUMBER,
1182 p_numeric8 NUMBER,
1183 p_numeric9 NUMBER,
1184 p_numeric10 NUMBER,
1185 p_char1 VARCHAR2,
1186 p_char2 VARCHAR2,
1187 p_char3 VARCHAR2,
1188 p_char4 VARCHAR2,
1189 p_char5 VARCHAR2,
1190 p_char6 VARCHAR2,
1191 p_char7 VARCHAR2,
1192 p_char8 VARCHAR2,
1193 p_char9 VARCHAR2,
1194 p_char10 VARCHAR2,
1195 p_date1 DATE,
1196 p_date2 DATE,
1197 p_date3 DATE,
1198 p_date4 DATE,
1199 p_date5 DATE,
1200 p_date6 DATE,
1201 p_date7 DATE,
1202 p_date8 DATE,
1203 p_date9 DATE,
1204 p_date10 DATE,
1205 p_interface_entity_code VARCHAR2,
1206 p_interface_tax_line_id NUMBER,
1207 p_taxing_juris_geography_id NUMBER,
1208 p_adjusted_doc_tax_line_id NUMBER,
1209 p_object_version_number NUMBER,
1210 p_created_by NUMBER,
1211 p_creation_date DATE,
1212 p_last_updated_by NUMBER,
1213 p_last_update_date DATE,
1214 p_last_update_login NUMBER);
1215
1216 PROCEDURE Override_Row
1217 (p_application_id NUMBER,
1218 p_entity_code VARCHAR2,
1219 p_event_class_code VARCHAR2,
1220 p_trx_id NUMBER,
1221 p_trx_line_id NUMBER,
1222 p_trx_level_type VARCHAR2,
1223 p_event_id NUMBER);
1224
1225 PROCEDURE lock_dtl_tax_lines_for_doc
1226 (p_application_id IN NUMBER,
1227 p_entity_code IN VARCHAR2,
1228 p_event_class_code IN VARCHAR2,
1229 p_trx_id IN NUMBER,
1230 x_return_status OUT NOCOPY VARCHAR2,
1231 x_error_buffer OUT NOCOPY VARCHAR2);
1232
1233
1234 END ZX_TRL_DETAIL_OVERRIDE_PKG;