[Home] [Help]
PACKAGE BODY: APPS.ZX_TRL_DETAIL_OVERRIDE_PKG
Source
1 PACKAGE BODY ZX_TRL_DETAIL_OVERRIDE_PKG AS
2 /* $Header: zxriovrdetlnpkgb.pls 120.85.12020000.3 2012/08/17 13:24:41 ssohal noship $ */
3
4 g_current_runtime_level NUMBER;
5 g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
6 g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
7 g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
8 g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
9
10 DATE_DUMMY CONSTANT DATE := TO_DATE('01-01-1951', 'DD-MM-YYYY');
11
12 PROCEDURE Insert_Row
13 (X_Rowid IN OUT NOCOPY VARCHAR2,
14 p_tax_line_id NUMBER,
15 p_internal_organization_id NUMBER,
16 p_application_id NUMBER,
17 p_entity_code VARCHAR2,
18 p_event_class_code VARCHAR2,
19 p_event_type_code VARCHAR2,
20 p_trx_id NUMBER,
21 p_trx_line_id NUMBER,
22 p_trx_level_type VARCHAR2,
23 p_trx_line_number NUMBER,
24 p_doc_event_status VARCHAR2,
25 p_tax_event_class_code VARCHAR2,
26 p_tax_event_type_code VARCHAR2,
27 p_tax_line_number NUMBER,
28 p_content_owner_id NUMBER,
29 p_tax_regime_id NUMBER,
30 p_tax_regime_code VARCHAR2,
31 p_tax_id NUMBER,
32 p_tax VARCHAR2,
33 p_tax_status_id NUMBER,
34 p_tax_status_code VARCHAR2,
35 p_tax_rate_id NUMBER,
36 p_tax_rate_code VARCHAR2,
37 p_tax_rate NUMBER,
38 p_tax_rate_type VARCHAR2,
39 p_tax_apportionment_line_num NUMBER,--reduced in size tax_apportionment_line_number
40 p_trx_id_level2 NUMBER,
41 p_trx_id_level3 NUMBER,
42 p_trx_id_level4 NUMBER,
43 p_trx_id_level5 NUMBER,
44 p_trx_id_level6 NUMBER,
45 p_trx_user_key_level1 VARCHAR2,
46 p_trx_user_key_level2 VARCHAR2,
47 p_trx_user_key_level3 VARCHAR2,
48 p_trx_user_key_level4 VARCHAR2,
49 p_trx_user_key_level5 VARCHAR2,
50 p_trx_user_key_level6 VARCHAR2,
51 p_mrc_tax_line_flag VARCHAR2,
52 p_mrc_link_to_tax_line_id NUMBER,
53 p_ledger_id NUMBER,
54 p_establishment_id NUMBER,
55 p_legal_entity_id NUMBER,
56 p_hq_estb_reg_number VARCHAR2,
57 p_hq_estb_party_tax_prof_id NUMBER,
58 p_currency_conversion_date DATE,
59 p_currency_conversion_type VARCHAR2,
60 p_currency_conversion_rate NUMBER,
61 p_tax_curr_conversion_date DATE,--reduced in size tax_currency_conversion_date
62 p_tax_curr_conversion_type VARCHAR2,--reduced in size p_tax_currency_conversion_type
63 p_tax_curr_conversion_rate NUMBER,--reduced in size p_tax_currency_conversion_rate
64 p_trx_currency_code VARCHAR2,
65 p_reporting_currency_code VARCHAR2,
66 p_minimum_accountable_unit NUMBER,
67 p_precision NUMBER,
68 p_trx_number VARCHAR2,
69 p_trx_date DATE,
70 p_unit_price NUMBER,
71 p_line_amt NUMBER,
72 p_trx_line_quantity NUMBER,
73 p_tax_base_modifier_rate NUMBER,
74 p_ref_doc_application_id NUMBER,
75 p_ref_doc_entity_code VARCHAR2,
76 p_ref_doc_event_class_code VARCHAR2,
77 p_ref_doc_trx_id NUMBER,
78 p_ref_doc_trx_level_type VARCHAR2,
79 p_ref_doc_line_id NUMBER,
80 p_ref_doc_line_quantity NUMBER,
81 p_other_doc_line_amt NUMBER,
82 p_other_doc_line_tax_amt NUMBER,
83 p_other_doc_line_taxable_amt NUMBER,
84 p_unrounded_taxable_amt NUMBER,
85 p_unrounded_tax_amt NUMBER,
86 p_related_doc_application_id NUMBER,
87 p_related_doc_entity_code VARCHAR2,
88 p_related_doc_evt_class_code VARCHAR2,--reduced in size p_related_doc_event_class_code
89 p_related_doc_trx_id NUMBER,
90 p_related_doc_trx_level_type VARCHAR2,
91 p_related_doc_number VARCHAR2,
92 p_related_doc_date DATE,
93 p_applied_from_appl_id NUMBER,--reduced in size p_applied_from_application_id
94 p_applied_from_evt_clss_code VARCHAR2,--reduced in size p_applied_from_event_class_code
95 p_applied_from_entity_code VARCHAR2,
96 p_applied_from_trx_id NUMBER,
97 p_applied_from_trx_level_type VARCHAR2,
98 p_applied_from_line_id NUMBER,
99 p_applied_from_trx_number VARCHAR2,
100 p_adjusted_doc_appln_id NUMBER,--reduced in size p_adjusted_doc_application_id
101 p_adjusted_doc_entity_code VARCHAR2,
102 p_adjusted_doc_evt_clss_code VARCHAR2,--reduced in size p_adjusted_doc_event_class_code
103 p_adjusted_doc_trx_id NUMBER,
104 p_adjusted_doc_trx_level_type VARCHAR2,
105 p_adjusted_doc_line_id NUMBER,
106 p_adjusted_doc_number VARCHAR2,
107 p_adjusted_doc_date DATE,
108 p_applied_to_application_id NUMBER,
109 p_applied_to_evt_class_code VARCHAR2,--reduced in size p_applied_to_event_class_code
110 p_applied_to_entity_code VARCHAR2,
111 p_applied_to_trx_id NUMBER,
112 p_applied_to_trx_level_type VARCHAR2,
113 p_applied_to_line_id NUMBER,
114 p_summary_tax_line_id NUMBER,
115 p_offset_link_to_tax_line_id NUMBER,
116 p_offset_flag VARCHAR2,
117 p_process_for_recovery_flag VARCHAR2,
118 p_tax_jurisdiction_id NUMBER,
119 p_tax_jurisdiction_code VARCHAR2,
120 p_place_of_supply NUMBER,
121 p_place_of_supply_type_code VARCHAR2,
122 p_place_of_supply_result_id NUMBER,
123 p_tax_date_rule_id NUMBER,
124 p_tax_date DATE,
125 p_tax_determine_date DATE,
126 p_tax_point_date DATE,
127 p_trx_line_date DATE,
128 p_tax_type_code VARCHAR2,
129 p_tax_code VARCHAR2,
130 p_tax_registration_id NUMBER,
131 p_tax_registration_number VARCHAR2,
132 p_registration_party_type VARCHAR2,
133 p_rounding_level_code VARCHAR2,
134 p_rounding_rule_code VARCHAR2,
135 p_rndg_lvl_party_tax_prof_id NUMBER,--reduced in size p_rounding_lvl_party_tax_prof_id
136 p_rounding_lvl_party_type VARCHAR2,
137 p_compounding_tax_flag VARCHAR2,
138 p_orig_tax_status_id NUMBER,
139 p_orig_tax_status_code VARCHAR2,
140 p_orig_tax_rate_id NUMBER,
141 p_orig_tax_rate_code VARCHAR2,
142 p_orig_tax_rate NUMBER,
143 p_orig_tax_jurisdiction_id NUMBER,
144 p_orig_tax_jurisdiction_code VARCHAR2,
145 p_orig_tax_amt_included_flag VARCHAR2,
146 p_orig_self_assessed_flag VARCHAR2,
147 p_tax_currency_code VARCHAR2,
148 p_tax_amt NUMBER,
149 p_tax_amt_tax_curr NUMBER,
150 p_tax_amt_funcl_curr NUMBER,
151 p_taxable_amt NUMBER,
152 p_taxable_amt_tax_curr NUMBER,
153 p_taxable_amt_funcl_curr NUMBER,
154 p_orig_taxable_amt NUMBER,
155 p_orig_taxable_amt_tax_curr NUMBER,
156 p_cal_tax_amt NUMBER,
157 p_cal_tax_amt_tax_curr NUMBER,
158 p_cal_tax_amt_funcl_curr NUMBER,
159 p_orig_tax_amt NUMBER,
160 p_orig_tax_amt_tax_curr NUMBER,
161 p_rec_tax_amt NUMBER,
162 p_rec_tax_amt_tax_curr NUMBER,
163 p_rec_tax_amt_funcl_curr NUMBER,
164 p_nrec_tax_amt NUMBER,
165 p_nrec_tax_amt_tax_curr NUMBER,
166 p_nrec_tax_amt_funcl_curr NUMBER,
167 p_tax_exemption_id NUMBER,
168 p_tax_rate_before_exemption NUMBER,
169 p_tax_rate_name_before_exempt VARCHAR2,
170 p_exempt_rate_modifier NUMBER,
171 p_exempt_certificate_number VARCHAR2,
172 p_exempt_reason VARCHAR2,
173 p_exempt_reason_code VARCHAR2,
174 p_tax_exception_id NUMBER,
175 p_tax_rate_before_exception NUMBER,
176 p_tax_rate_name_before_except VARCHAR2,
177 p_exception_rate NUMBER,
178 p_tax_apportionment_flag VARCHAR2,
179 p_historical_flag VARCHAR2,
180 p_taxable_basis_formula VARCHAR2,
181 p_tax_calculation_formula VARCHAR2,
182 p_cancel_flag VARCHAR2,
183 p_purge_flag VARCHAR2,
184 p_delete_flag VARCHAR2,
185 p_tax_amt_included_flag VARCHAR2,
186 p_self_assessed_flag VARCHAR2,
187 p_overridden_flag VARCHAR2,
188 p_manually_entered_flag VARCHAR2,
189 p_reporting_only_flag VARCHAR2,
190 p_freeze_until_overriddn_flg VARCHAR2,--reduced in size p_Freeze_Until_Overridden_Flag
191 p_copied_from_other_doc_flag VARCHAR2,
192 p_recalc_required_flag VARCHAR2,
193 p_settlement_flag VARCHAR2,
194 p_item_dist_changed_flag VARCHAR2,
195 p_assoc_children_frozen_flg VARCHAR2,--reduced in size p_Associated_Child_Frozen_Flag
196 p_tax_only_line_flag VARCHAR2,
197 p_compounding_dep_tax_flag VARCHAR2,
198 p_compounding_tax_miss_flag VARCHAR2,
199 p_sync_with_prvdr_flag VARCHAR2,
200 p_last_manual_entry VARCHAR2,
201 p_tax_provider_id NUMBER,
202 p_record_type_code VARCHAR2,
203 p_reporting_period_id NUMBER,
204 p_legal_justification_text1 VARCHAR2,
205 p_legal_justification_text2 VARCHAR2,
206 p_legal_justification_text3 VARCHAR2,
207 p_legal_message_appl_2 NUMBER,
208 p_legal_message_status NUMBER,
209 p_legal_message_rate NUMBER,
210 p_legal_message_basis NUMBER,
211 p_legal_message_calc NUMBER,
212 p_legal_message_threshold NUMBER,
213 p_legal_message_pos NUMBER,
214 p_legal_message_trn NUMBER,
215 p_legal_message_exmpt NUMBER,
216 p_legal_message_excpt NUMBER,
217 p_tax_regime_template_id NUMBER,
218 p_tax_applicability_result_id NUMBER,--reduced in size p_tax_applicability_result_id
219 p_direct_rate_result_id NUMBER,
220 p_status_result_id NUMBER,
221 p_rate_result_id NUMBER,
222 p_basis_result_id NUMBER,
223 p_thresh_result_id NUMBER,
224 p_calc_result_id NUMBER,
225 p_tax_reg_num_det_result_id NUMBER,
226 p_eval_exmpt_result_id NUMBER,
227 p_eval_excpt_result_id NUMBER,
228 p_enforced_from_nat_acct_flg VARCHAR2,--reduced in size p_Enforce_From_Natural_Acct_Flag
229 p_tax_hold_code NUMBER,
230 p_tax_hold_released_code NUMBER,
231 p_prd_total_tax_amt NUMBER,
232 p_prd_total_tax_amt_tax_curr NUMBER,
233 p_prd_total_tax_amt_funcl_curr NUMBER,
234 p_trx_line_index VARCHAR2,
235 p_offset_tax_rate_code VARCHAR2,
236 p_proration_code VARCHAR2,
237 p_other_doc_source VARCHAR2,
238 p_internal_org_location_id NUMBER,
239 p_line_assessable_value NUMBER,
240 p_ctrl_total_line_tx_amt NUMBER,
241 p_applied_to_trx_number VARCHAR2,
242 p_attribute_category VARCHAR2,
243 p_attribute1 VARCHAR2,
244 p_attribute2 VARCHAR2,
245 p_attribute3 VARCHAR2,
246 p_attribute4 VARCHAR2,
247 p_attribute5 VARCHAR2,
248 p_attribute6 VARCHAR2,
249 p_attribute7 VARCHAR2,
250 p_attribute8 VARCHAR2,
251 p_attribute9 VARCHAR2,
252 p_attribute10 VARCHAR2,
253 p_attribute11 VARCHAR2,
254 p_attribute12 VARCHAR2,
255 p_attribute13 VARCHAR2,
256 p_attribute14 VARCHAR2,
257 p_attribute15 VARCHAR2,
258 p_global_attribute_category VARCHAR2,
259 p_global_attribute1 VARCHAR2,
260 p_global_attribute2 VARCHAR2,
261 p_global_attribute3 VARCHAR2,
262 p_global_attribute4 VARCHAR2,
263 p_global_attribute5 VARCHAR2,
264 p_global_attribute6 VARCHAR2,
265 p_global_attribute7 VARCHAR2,
266 p_global_attribute8 VARCHAR2,
267 p_global_attribute9 VARCHAR2,
268 p_global_attribute10 VARCHAR2,
269 p_global_attribute11 VARCHAR2,
270 p_global_attribute12 VARCHAR2,
271 p_global_attribute13 VARCHAR2,
272 p_global_attribute14 VARCHAR2,
273 p_global_attribute15 VARCHAR2,
274 p_numeric1 NUMBER,
275 p_numeric2 NUMBER,
276 p_numeric3 NUMBER,
277 p_numeric4 NUMBER,
278 p_numeric5 NUMBER,
279 p_numeric6 NUMBER,
280 p_numeric7 NUMBER,
281 p_numeric8 NUMBER,
282 p_numeric9 NUMBER,
283 p_numeric10 NUMBER,
284 p_char1 VARCHAR2,
285 p_char2 VARCHAR2,
286 p_char3 VARCHAR2,
287 p_char4 VARCHAR2,
288 p_char5 VARCHAR2,
289 p_char6 VARCHAR2,
290 p_char7 VARCHAR2,
291 p_char8 VARCHAR2,
292 p_char9 VARCHAR2,
293 p_char10 VARCHAR2,
294 p_date1 DATE,
295 p_date2 DATE,
296 p_date3 DATE,
297 p_date4 DATE,
298 p_date5 DATE,
299 p_date6 DATE,
300 p_date7 DATE,
301 p_date8 DATE,
302 p_date9 DATE,
303 p_date10 DATE,
304 P_interface_entity_code VARCHAR2,
305 P_interface_tax_line_id NUMBER,
306 P_taxing_juris_geography_id NUMBER,
307 P_adjusted_doc_tax_line_id NUMBER,
308 P_object_version_number NUMBER,
309 p_created_by NUMBER,
310 p_creation_date DATE,
311 p_last_updated_by NUMBER,
312 p_last_update_date DATE,
313 p_last_update_login NUMBER) IS
314
315 l_return_status VARCHAR2(1000);
316 l_msg_count NUMBER;
317 l_msg_data VARCHAR2(1000);
318 l_tax_line_id NUMBER;
319 l_tax_reporting_flag ZX_EVNT_CLS_MAPPINGS.tax_reporting_flag%TYPE;
320 l_report_status_tracking ZX_LINES.legal_reporting_status%TYPE;
321 l_offset_tax_rate_code VARCHAR2(100);
322 l_offset_flag VARCHAR2(10);
323 l_offset_tax_flag VARCHAR2(100);
324 l_tax_rate_type VARCHAR2(100); --Bug 13724999
325
326 CURSOR C IS
327 SELECT rowid
328 FROM ZX_LINES
329 WHERE TAX_LINE_ID = p_tax_line_id;
330
331 BEGIN
332 g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
333
334 IF (g_level_procedure >= g_current_runtime_level ) THEN
335 FND_LOG.STRING(g_level_procedure,
336 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Insert_Row.BEGIN',
337 'ZX_TRL_DETAIL_OVERRIDE_PKG: Insert_Row (+)');
338 END IF;
339
340 IF (g_level_procedure >= g_current_runtime_level ) THEN
341 FND_LOG.STRING(g_level_procedure,
342 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Insert_Row',
343 'Inserting into ZX_LINES (+)');
344 FND_LOG.STRING(g_level_procedure,
345 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Insert_Row',
346 'Input Parameters : Tax_Line_Number='||TO_CHAR(p_tax_line_number)||
347 ', Application_Id='||TO_CHAR(p_application_id)||
348 ', Entity_Code='||p_entity_code||
349 ', Event_Class_Code='||p_event_class_code||
350 ', Trx_Id=' ||TO_CHAR(p_trx_id)||
351 ', Tax_Id=' ||p_tax_id||
352 ', Unrounded_Tax_Amt=' ||p_unrounded_tax_amt||
353 ', Tax_Amt=' ||p_tax_amt||
354 ', Taxable_Amt=' ||p_taxable_amt);
355 END IF;
356
357 BEGIN
358 SELECT tax_reporting_flag
359 INTO l_tax_reporting_flag
360 FROM zx_evnt_cls_mappings
361 WHERE entity_code = p_entity_code
362 AND event_class_code = p_event_class_code
363 AND application_id = p_application_id;
364 EXCEPTION WHEN NO_DATA_FOUND THEN
365 IF (g_level_procedure >= g_current_runtime_level ) THEN
366 FND_LOG.STRING(g_level_procedure,
367 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Insert_Row',
368 'No data found while querying up zx_event_cls_mappings Please check seed data');
369 END IF;
370 END;
371
372
373 IF p_application_id = 200 THEN
374 BEGIN
375 SELECT offset_tax_flag INTO l_offset_tax_flag
376 FROM zx_taxes_b
377 WHERE tax_id = p_tax_id
378 AND p_tax_determine_date BETWEEN effective_from AND
379 nvl(effective_to,p_tax_determine_date);
380
381 IF nvl(l_offset_tax_flag,'N') <> 'Y' THEN
382 SELECT offset_tax_rate_code, 'N'
383 INTO l_offset_tax_rate_code, l_offset_flag
384 FROM zx_rates_b
385 WHERE tax_rate_id = p_tax_rate_id
386 AND p_tax_determine_date BETWEEN effective_from AND
387 nvl(effective_to,p_tax_determine_date);
388 ELSE
389 l_offset_flag := 'Y';
390 END IF;
391 EXCEPTION
392 WHEN OTHERS THEN NULL;
393 END;
394
395 --Bug 13724999
396 SELECT rate_type_code INTO l_tax_rate_type
397 FROM zx_rates_b
398 WHERE tax_rate_id = p_tax_rate_id;
399 --Bug 13724999
400 END IF;
401
402 IF l_tax_reporting_flag = 'Y'
403 THEN
404 BEGIN
405 SELECT legal_reporting_status_def_val
406 INTO l_report_status_tracking
407 FROM zx_taxes_b
408 WHERE tax_id = p_tax_id;
409 EXCEPTION WHEN NO_DATA_FOUND THEN
410 IF (g_level_procedure >= g_current_runtime_level ) THEN
411 FND_LOG.STRING(g_level_procedure,
412 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Insert_Row',
413 'No data found while querying up taxes using the tax id Possibly an invalid tax id is passed');
414 END IF;
415 END;
416 END IF;
417
418
419 INSERT INTO ZX_LINES (TAX_LINE_ID,
420 INTERNAL_ORGANIZATION_ID,
421 APPLICATION_ID,
422 ENTITY_CODE,
423 EVENT_CLASS_CODE,
424 EVENT_TYPE_CODE,
425 TRX_ID,
426 TRX_LINE_ID,
427 TRX_LEVEL_TYPE,
428 TRX_LINE_NUMBER,
429 DOC_EVENT_STATUS,
430 TAX_EVENT_CLASS_CODE,
431 TAX_EVENT_TYPE_CODE,
432 TAX_LINE_NUMBER,
433 CONTENT_OWNER_ID,
434 TAX_REGIME_ID,
435 TAX_REGIME_CODE,
436 TAX_ID,
437 TAX,
438 TAX_STATUS_ID,
439 TAX_STATUS_CODE,
440 TAX_RATE_ID,
441 TAX_RATE_CODE,
442 TAX_RATE,
443 TAX_RATE_TYPE,
444 TAX_APPORTIONMENT_LINE_NUMBER,
445 TRX_ID_LEVEL2,
446 TRX_ID_LEVEL3,
447 TRX_ID_LEVEL4,
448 TRX_ID_LEVEL5,
449 TRX_ID_LEVEL6,
450 TRX_USER_KEY_LEVEL1,
451 TRX_USER_KEY_LEVEL2,
452 TRX_USER_KEY_LEVEL3,
453 TRX_USER_KEY_LEVEL4,
454 TRX_USER_KEY_LEVEL5,
455 TRX_USER_KEY_LEVEL6,
456 MRC_TAX_LINE_FLAG,
457 MRC_LINK_TO_TAX_LINE_ID,
458 LEDGER_ID,
459 ESTABLISHMENT_ID,
460 LEGAL_ENTITY_ID,
461 HQ_ESTB_REG_NUMBER,
462 HQ_ESTB_PARTY_TAX_PROF_ID,
463 CURRENCY_CONVERSION_DATE,
464 CURRENCY_CONVERSION_TYPE,
465 CURRENCY_CONVERSION_RATE,
466 TAX_CURRENCY_CONVERSION_DATE,
467 TAX_CURRENCY_CONVERSION_TYPE,
468 TAX_CURRENCY_CONVERSION_RATE,
469 TRX_CURRENCY_CODE,
470 REPORTING_CURRENCY_CODE,
471 MINIMUM_ACCOUNTABLE_UNIT,
472 PRECISION,
473 TRX_NUMBER,
474 TRX_DATE,
475 UNIT_PRICE,
476 LINE_AMT,
477 TRX_LINE_QUANTITY,
478 TAX_BASE_MODIFIER_RATE,
479 REF_DOC_APPLICATION_ID,
480 REF_DOC_ENTITY_CODE,
481 REF_DOC_EVENT_CLASS_CODE,
482 REF_DOC_TRX_ID,
483 REF_DOC_TRX_LEVEL_TYPE,
484 REF_DOC_LINE_ID,
485 REF_DOC_LINE_QUANTITY,
486 OTHER_DOC_LINE_AMT,
487 OTHER_DOC_LINE_TAX_AMT,
488 OTHER_DOC_LINE_TAXABLE_AMT,
489 UNROUNDED_TAXABLE_AMT,
490 UNROUNDED_TAX_AMT,
491 RELATED_DOC_APPLICATION_ID,
492 RELATED_DOC_ENTITY_CODE,
493 RELATED_DOC_EVENT_CLASS_CODE,
494 RELATED_DOC_TRX_ID,
495 RELATED_DOC_TRX_LEVEL_TYPE,
496 RELATED_DOC_NUMBER,
497 RELATED_DOC_DATE,
498 APPLIED_FROM_APPLICATION_ID,
499 APPLIED_FROM_EVENT_CLASS_CODE,
500 APPLIED_FROM_ENTITY_CODE,
501 APPLIED_FROM_TRX_ID,
502 APPLIED_FROM_TRX_LEVEL_TYPE,
503 APPLIED_FROM_LINE_ID,
504 APPLIED_FROM_TRX_NUMBER,
505 ADJUSTED_DOC_APPLICATION_ID,
506 ADJUSTED_DOC_ENTITY_CODE,
507 ADJUSTED_DOC_EVENT_CLASS_CODE,
508 ADJUSTED_DOC_TRX_ID,
509 ADJUSTED_DOC_TRX_LEVEL_TYPE,
510 ADJUSTED_DOC_LINE_ID,
511 ADJUSTED_DOC_NUMBER,
512 ADJUSTED_DOC_DATE,
513 APPLIED_TO_APPLICATION_ID,
514 APPLIED_TO_EVENT_CLASS_CODE,
515 APPLIED_TO_ENTITY_CODE,
516 APPLIED_TO_TRX_ID,
517 APPLIED_TO_TRX_LEVEL_TYPE,
518 APPLIED_TO_LINE_ID,
519 SUMMARY_TAX_LINE_ID,
520 OFFSET_LINK_TO_TAX_LINE_ID,
521 OFFSET_FLAG,
522 PROCESS_FOR_RECOVERY_FLAG,
523 TAX_JURISDICTION_ID,
524 TAX_JURISDICTION_CODE,
525 PLACE_OF_SUPPLY,
526 PLACE_OF_SUPPLY_TYPE_CODE,
527 PLACE_OF_SUPPLY_RESULT_ID,
528 TAX_DATE_RULE_ID,
529 TAX_DATE,
530 TAX_DETERMINE_DATE,
531 TAX_POINT_DATE,
532 TRX_LINE_DATE,
533 TAX_TYPE_CODE,
534 TAX_CODE,
535 TAX_REGISTRATION_ID,
536 TAX_REGISTRATION_NUMBER,
537 REGISTRATION_PARTY_TYPE,
538 ROUNDING_LEVEL_CODE,
539 ROUNDING_RULE_CODE,
540 ROUNDING_LVL_PARTY_TAX_PROF_ID,
541 ROUNDING_LVL_PARTY_TYPE,
542 COMPOUNDING_TAX_FLAG,
543 ORIG_TAX_STATUS_ID,
544 ORIG_TAX_STATUS_CODE,
545 ORIG_TAX_RATE_ID,
546 ORIG_TAX_RATE_CODE,
547 ORIG_TAX_RATE,
548 ORIG_TAX_JURISDICTION_ID,
549 ORIG_TAX_JURISDICTION_CODE,
550 ORIG_TAX_AMT_INCLUDED_FLAG,
551 ORIG_SELF_ASSESSED_FLAG,
552 TAX_CURRENCY_CODE,
553 TAX_AMT,
554 TAX_AMT_TAX_CURR,
555 TAX_AMT_FUNCL_CURR,
556 TAXABLE_AMT,
557 TAXABLE_AMT_TAX_CURR,
558 TAXABLE_AMT_FUNCL_CURR,
559 ORIG_TAXABLE_AMT,
560 ORIG_TAXABLE_AMT_TAX_CURR,
561 CAL_TAX_AMT,
562 CAL_TAX_AMT_TAX_CURR,
563 CAL_TAX_AMT_FUNCL_CURR,
564 ORIG_TAX_AMT,
565 ORIG_TAX_AMT_TAX_CURR,
566 REC_TAX_AMT,
567 REC_TAX_AMT_TAX_CURR,
568 REC_TAX_AMT_FUNCL_CURR,
569 NREC_TAX_AMT,
570 NREC_TAX_AMT_TAX_CURR,
571 NREC_TAX_AMT_FUNCL_CURR,
572 TAX_EXEMPTION_ID,
573 TAX_RATE_BEFORE_EXEMPTION,
574 TAX_RATE_NAME_BEFORE_EXEMPTION,
575 EXEMPT_RATE_MODIFIER,
576 EXEMPT_CERTIFICATE_NUMBER,
577 EXEMPT_REASON,
578 EXEMPT_REASON_CODE,
579 TAX_EXCEPTION_ID,
580 TAX_RATE_BEFORE_EXCEPTION,
581 TAX_RATE_NAME_BEFORE_EXCEPTION,
582 EXCEPTION_RATE,
583 TAX_APPORTIONMENT_FLAG,
584 HISTORICAL_FLAG,
585 TAXABLE_BASIS_FORMULA,
586 TAX_CALCULATION_FORMULA,
587 CANCEL_FLAG,
588 PURGE_FLAG,
589 DELETE_FLAG,
590 TAX_AMT_INCLUDED_FLAG,
591 SELF_ASSESSED_FLAG,
592 OVERRIDDEN_FLAG,
593 MANUALLY_ENTERED_FLAG,
594 REPORTING_ONLY_FLAG,
595 FREEZE_UNTIL_OVERRIDDEN_FLAG,
596 COPIED_FROM_OTHER_DOC_FLAG,
597 RECALC_REQUIRED_FLAG,
598 SETTLEMENT_FLAG,
599 ITEM_DIST_CHANGED_FLAG,
600 ASSOCIATED_CHILD_FROZEN_FLAG,
601 TAX_ONLY_LINE_FLAG,
602 COMPOUNDING_DEP_TAX_FLAG,
603 COMPOUNDING_TAX_MISS_FLAG,
604 SYNC_WITH_PRVDR_FLAG,
605 LAST_MANUAL_ENTRY,
606 TAX_PROVIDER_ID,
607 RECORD_TYPE_CODE,
608 REPORTING_PERIOD_ID,
609 LEGAL_JUSTIFICATION_TEXT1,
610 LEGAL_JUSTIFICATION_TEXT2,
611 LEGAL_JUSTIFICATION_TEXT3,
612 LEGAL_MESSAGE_APPL_2,
613 LEGAL_MESSAGE_STATUS,
614 LEGAL_MESSAGE_RATE,
615 LEGAL_MESSAGE_BASIS,
616 LEGAL_MESSAGE_CALC,
617 LEGAL_MESSAGE_THRESHOLD,
618 LEGAL_MESSAGE_POS,
619 LEGAL_MESSAGE_TRN,
620 LEGAL_MESSAGE_EXMPT,
621 LEGAL_MESSAGE_EXCPT,
622 TAX_REGIME_TEMPLATE_ID,
623 TAX_APPLICABILITY_RESULT_ID,
624 DIRECT_RATE_RESULT_ID,
625 STATUS_RESULT_ID,
626 RATE_RESULT_ID,
627 BASIS_RESULT_ID,
628 THRESH_RESULT_ID,
629 CALC_RESULT_ID,
630 TAX_REG_NUM_DET_RESULT_ID,
631 EVAL_EXMPT_RESULT_ID,
632 EVAL_EXCPT_RESULT_ID,
633 ENFORCE_FROM_NATURAL_ACCT_FLAG,
634 TAX_HOLD_CODE,
635 TAX_HOLD_RELEASED_CODE,
636 PRD_TOTAL_TAX_AMT,
637 PRD_TOTAL_TAX_AMT_TAX_CURR,
638 PRD_TOTAL_TAX_AMT_FUNCL_CURR,
639 TRX_LINE_INDEX,
640 OFFSET_TAX_RATE_CODE,
641 PRORATION_CODE,
642 OTHER_DOC_SOURCE,
643 INTERNAL_ORG_LOCATION_ID,
644 LINE_ASSESSABLE_VALUE,
645 CTRL_TOTAL_LINE_TX_AMT,
646 APPLIED_TO_TRX_NUMBER,
647 MULTIPLE_JURISDICTIONS_FLAG,
648 ATTRIBUTE_CATEGORY,
649 ATTRIBUTE1,
650 ATTRIBUTE2,
651 ATTRIBUTE3,
652 ATTRIBUTE4,
653 ATTRIBUTE5,
654 ATTRIBUTE6,
655 ATTRIBUTE7,
656 ATTRIBUTE8,
657 ATTRIBUTE9,
658 ATTRIBUTE10,
659 ATTRIBUTE11,
660 ATTRIBUTE12,
661 ATTRIBUTE13,
662 ATTRIBUTE14,
663 ATTRIBUTE15,
664 GLOBAL_ATTRIBUTE_CATEGORY,
665 GLOBAL_ATTRIBUTE1,
666 GLOBAL_ATTRIBUTE2,
667 GLOBAL_ATTRIBUTE3,
668 GLOBAL_ATTRIBUTE4,
669 GLOBAL_ATTRIBUTE5,
670 GLOBAL_ATTRIBUTE6,
671 GLOBAL_ATTRIBUTE7,
672 GLOBAL_ATTRIBUTE8,
673 GLOBAL_ATTRIBUTE9,
674 GLOBAL_ATTRIBUTE10,
675 GLOBAL_ATTRIBUTE11,
676 GLOBAL_ATTRIBUTE12,
677 GLOBAL_ATTRIBUTE13,
678 GLOBAL_ATTRIBUTE14,
679 GLOBAL_ATTRIBUTE15,
680 NUMERIC1,
681 NUMERIC2,
682 NUMERIC3,
683 NUMERIC4,
684 NUMERIC5,
685 NUMERIC6,
686 NUMERIC7,
687 NUMERIC8,
688 NUMERIC9,
689 NUMERIC10,
690 CHAR1,
691 CHAR2,
692 CHAR3,
693 CHAR4,
694 CHAR5,
695 CHAR6,
696 CHAR7,
697 CHAR8,
698 CHAR9,
699 CHAR10,
700 DATE1,
701 DATE2,
702 DATE3,
703 DATE4,
704 DATE5,
705 DATE6,
706 DATE7,
707 DATE8,
708 DATE9,
709 DATE10,
710 INTERFACE_ENTITY_CODE,
711 INTERFACE_TAX_LINE_ID,
712 TAXING_JURIS_GEOGRAPHY_ID,
713 ADJUSTED_DOC_TAX_LINE_ID,
714 LEGAL_REPORTING_STATUS,
715 OBJECT_VERSION_NUMBER,
716 CREATED_BY,
717 CREATION_DATE,
718 LAST_UPDATED_BY,
719 LAST_UPDATE_DATE,
720 LAST_UPDATE_LOGIN)
721 VALUES (p_tax_line_id,
722 p_internal_organization_id,
723 p_application_id,
724 p_entity_code,
725 p_event_class_code,
726 p_event_type_code,
727 p_trx_id,
728 p_trx_line_id,
729 p_trx_level_type,
730 p_trx_line_number,
731 p_doc_event_status,
732 p_tax_event_class_code,
733 p_tax_event_type_code,
734 p_tax_line_number,
735 p_content_owner_id,
736 p_tax_regime_id,
737 p_tax_regime_code,
738 p_tax_id,
739 p_tax,
740 p_tax_status_id,
741 p_tax_status_code,
742 p_tax_rate_id,
743 p_tax_rate_code,
744 p_tax_rate,
745 l_tax_rate_type,
746 NVL(p_tax_apportionment_line_num,1),
747 p_trx_id_level2,
748 p_trx_id_level3,
749 p_trx_id_level4,
750 p_trx_id_level5,
751 p_trx_id_level6,
752 p_trx_user_key_level1,
753 p_trx_user_key_level2,
754 p_trx_user_key_level3,
755 p_trx_user_key_level4,
756 p_trx_user_key_level5,
757 p_trx_user_key_level6,
758 NVL(p_mrc_tax_line_flag, 'N'),
759 p_mrc_link_to_tax_line_id,
760 p_ledger_id,
761 p_establishment_id,
762 p_legal_entity_id,
763 p_hq_estb_reg_number,
764 p_hq_estb_party_tax_prof_id,
765 p_currency_conversion_date,
766 p_currency_conversion_type,
767 p_currency_conversion_rate,
768 p_tax_curr_conversion_date,
769 p_tax_curr_conversion_type,
770 p_tax_curr_conversion_rate,
771 p_trx_currency_code,
772 p_reporting_currency_code,
773 p_minimum_accountable_unit,
774 p_precision,
775 p_trx_number,
776 p_trx_date,
777 p_unit_price,
778 p_line_amt,
779 p_trx_line_quantity,
780 p_tax_base_modifier_rate,
781 p_ref_doc_application_id,
782 p_ref_doc_entity_code,
783 p_ref_doc_event_class_code,
784 p_ref_doc_trx_id,
785 p_ref_doc_trx_level_type,
786 p_ref_doc_line_id,
787 p_ref_doc_line_quantity,
788 p_other_doc_line_amt,
789 p_other_doc_line_tax_amt,
790 p_other_doc_line_taxable_amt,
791 p_unrounded_taxable_amt,
792 p_unrounded_tax_amt,
793 p_related_doc_application_id,
794 p_related_doc_entity_code,
795 p_related_doc_evt_class_code,
796 p_related_doc_trx_id,
797 p_related_doc_trx_level_type,
798 p_related_doc_number,
799 p_related_doc_date,
800 p_applied_from_appl_id,
801 p_applied_from_evt_clss_code,
802 p_applied_from_entity_code,
803 p_applied_from_trx_id,
804 p_applied_from_trx_level_type,
805 p_applied_from_line_id,
806 p_applied_from_trx_number,
807 p_adjusted_doc_appln_id,
808 p_adjusted_doc_entity_code,
809 p_adjusted_doc_evt_clss_code,
810 p_adjusted_doc_trx_id,
811 p_adjusted_doc_trx_level_type,
812 p_adjusted_doc_line_id,
813 p_adjusted_doc_number,
814 p_adjusted_doc_date,
815 p_applied_to_application_id,
816 p_applied_to_evt_class_code,
817 p_applied_to_entity_code,
818 p_applied_to_trx_id,
819 p_applied_to_trx_level_type,
820 p_applied_to_line_id,
821 p_summary_tax_line_id,
822 p_offset_link_to_tax_line_id,
823 nvl(l_offset_flag,'N'), --p_offset_flag
824 'Y', --p_process_for_recovery_flag,
825 p_tax_jurisdiction_id,
826 p_tax_jurisdiction_code,
827 p_place_of_supply,
828 p_place_of_supply_type_code,
829 p_place_of_supply_result_id,
830 p_tax_date_rule_id,
831 p_tax_date,
832 p_tax_determine_date,
833 p_tax_point_date,
834 p_trx_line_date,
835 p_tax_type_code,
836 p_tax_code,
837 p_tax_registration_id,
838 p_tax_registration_number,
839 p_registration_party_type,
840 p_rounding_level_code,
841 p_rounding_rule_code,
842 p_rndg_lvl_party_tax_prof_id,
843 p_rounding_lvl_party_type,
844 DECODE(p_overridden_flag, 'C', NVL(p_compounding_tax_flag,'N'), 'N'), --p_compounding_tax_flag
845 p_orig_tax_status_id,
846 p_orig_tax_status_code,
847 p_orig_tax_rate_id,
848 p_orig_tax_rate_code,
849 p_orig_tax_rate,
850 p_orig_tax_jurisdiction_id,
851 p_orig_tax_jurisdiction_code,
852 DECODE(p_overridden_flag, 'C', p_orig_tax_amt_included_flag, NULL), --p_orig_tax_amt_included_flag,
853 DECODE(p_overridden_flag, 'C', p_orig_self_assessed_flag, NULL), --p_orig_self_assessed_flag,
854 p_tax_currency_code,
855 p_tax_amt,
856 p_tax_amt_tax_curr,
857 p_tax_amt_funcl_curr,
858 p_taxable_amt,
859 p_taxable_amt_tax_curr,
860 p_taxable_amt_funcl_curr,
861 p_orig_taxable_amt,
862 p_orig_taxable_amt_tax_curr,
863 p_cal_tax_amt,
864 p_cal_tax_amt_tax_curr,
865 p_cal_tax_amt_funcl_curr,
866 decode(p_manually_entered_flag,'Y',decode(p_tax_amt_included_flag,'Y',p_line_amt*p_tax_rate/(100 + p_tax_rate),p_line_amt*p_tax_rate/100),p_orig_tax_amt),
867 p_orig_tax_amt_tax_curr,
868 p_rec_tax_amt,
869 p_rec_tax_amt_tax_curr,
870 p_rec_tax_amt_funcl_curr,
871 p_nrec_tax_amt,
872 p_nrec_tax_amt_tax_curr,
873 p_nrec_tax_amt_funcl_curr,
874 p_tax_exemption_id,
875 p_tax_rate_before_exemption,
876 p_tax_rate_before_exception, --check the param
877 p_exempt_rate_modifier,
878 p_exempt_certificate_number,
879 p_exempt_reason,
880 p_exempt_reason_code,
881 p_tax_exception_id,
882 p_tax_rate_before_exception,
883 p_tax_rate_name_before_except,
884 p_exception_rate,
885 DECODE(p_overridden_flag, 'C', NVL(p_tax_apportionment_flag,'N'), 'N'), --p_tax_apportionment_flag,
886 DECODE(p_overridden_flag, 'C', NVL(p_historical_flag,'N'), 'N'), --p_historical_flag
887 p_taxable_basis_formula,
888 p_tax_calculation_formula,
889 DECODE(p_overridden_flag, 'C', NVL(p_cancel_flag, 'N'), 'N'), --p_cancel_flag
890 DECODE(p_overridden_flag, 'C', NVL(p_purge_flag,'N'), 'N'), --p_purge_flag
891 DECODE(p_overridden_flag, 'C', NVL(p_delete_flag,'N'), 'N'), --p_delete_flag
892 p_tax_amt_included_flag,
893 p_self_assessed_flag,
894 DECODE(p_overridden_flag, 'C', 'Y', 'N'), --p_overridden_flag
895 DECODE(p_overridden_flag, 'C', NVL(p_manually_entered_flag,'N'), 'Y'), --p_manually_entered_flag,
896 DECODE(p_overridden_flag, 'C', NVL(p_reporting_only_flag,'N'), 'N'), --p_reporting_only_flag
897 DECODE(p_overridden_flag, 'C', NVL(p_freeze_until_overriddn_flg,'N'), 'N'),--p_freeze_until_overriddn_flg
898 DECODE(p_overridden_flag, 'C', NVL(p_copied_from_other_doc_flag,'N'), 'N'),--p_copied_from_other_doc_flag
899 'Y', --p_recalc_required_flag,
900 DECODE(p_overridden_flag, 'C', NVL(p_settlement_flag,'N'), 'N'), --p_settlement_flag
901 DECODE(p_overridden_flag, 'C', NVL(p_item_dist_changed_flag,'N'),'N'), --p_item_dist_changed_flag
902 'N', --p_assoc_children_frozen_flg
903 p_tax_only_line_flag,
904 DECODE(p_overridden_flag, 'C', NVL(p_compounding_tax_miss_flag, 'N'),'N'), --p_compounding_tax_miss_flag,
905 DECODE(p_overridden_flag, 'C', NVL(p_compounding_dep_tax_flag,'N'), 'N'), --p_compounding_dep_tax_flag
906 decode(p_tax_provider_id, NULL, 'N', 'Y'), --p_sync_with_prvdr_flag,
907 DECODE(p_overridden_flag, 'C', p_last_manual_entry, 'TAX_AMOUNT'), --p_last_manual_entry,
908 --p_tax_provider_id,
909 NULL,
910 'ETAX_CREATED',
911 p_reporting_period_id,
912 p_legal_justification_text1,
913 p_legal_justification_text2,
914 p_legal_justification_text3,
915 p_legal_message_appl_2,
916 p_legal_message_status,
917 p_legal_message_rate,
918 p_legal_message_basis,
919 p_legal_message_calc,
920 p_legal_message_threshold,
921 p_legal_message_pos,
922 p_legal_message_trn,
923 p_legal_message_exmpt,
924 p_legal_message_excpt,
925 p_tax_regime_template_id,
926 p_tax_applicability_result_id,
927 p_direct_rate_result_id,
928 p_status_result_id,
929 p_rate_result_id,
930 p_basis_result_id,
931 p_thresh_result_id,
932 p_calc_result_id,
933 p_tax_reg_num_det_result_id,
934 p_eval_exmpt_result_id,
935 p_eval_excpt_result_id,
936 DECODE(p_overridden_flag, 'C', p_enforced_from_nat_acct_flg, 'N'), --p_enforced_from_nat_acct_flg
937 p_tax_hold_code,
938 p_tax_hold_released_code,
939 p_prd_total_tax_amt,
940 p_prd_total_tax_amt_tax_curr,
941 p_prd_total_tax_amt_funcl_curr,
942 p_trx_line_index,
943 l_offset_tax_rate_code,
944 p_proration_code,
945 p_other_doc_source,
946 p_internal_org_location_id,
947 p_line_assessable_value,
948 p_ctrl_total_line_tx_amt,
949 p_applied_to_trx_number,
950 'N', --p_multiple_jurisdictions_flag
951 p_attribute_category,
952 p_attribute1,
953 p_attribute2,
954 p_attribute3,
955 p_attribute4,
956 p_attribute5,
957 p_attribute6,
958 p_attribute7,
959 p_attribute8,
960 p_attribute9,
961 p_attribute10,
962 p_attribute11,
963 p_attribute12,
964 p_attribute13,
965 p_attribute14,
966 p_attribute15,
967 p_global_attribute_category,
968 p_global_attribute1,
969 p_global_attribute2,
970 p_global_attribute3,
971 p_global_attribute4,
972 p_global_attribute5,
973 p_global_attribute6,
974 p_global_attribute7,
975 p_global_attribute8,
976 p_global_attribute9,
977 p_global_attribute10,
978 p_global_attribute11,
979 p_global_attribute12,
980 p_global_attribute13,
981 p_global_attribute14,
982 p_global_attribute15,
983 p_numeric1,
984 p_numeric2,
985 p_numeric3,
986 p_numeric4,
987 p_numeric5,
988 p_numeric6,
989 p_numeric7,
990 p_numeric8,
991 p_numeric9,
992 p_numeric10,
993 p_char1,
994 p_char2,
995 p_char3,
996 p_char4,
997 p_char5,
998 p_char6,
999 p_char7,
1000 p_char8,
1001 p_char9,
1002 p_char10,
1003 p_date1,
1004 p_date2,
1005 p_date3,
1006 p_date4,
1007 p_date5,
1008 p_date6,
1009 p_date7,
1010 p_date8,
1011 p_date9,
1012 p_date10,
1013 p_interface_entity_code,
1014 p_interface_tax_line_id,
1015 p_taxing_juris_geography_id,
1016 p_adjusted_doc_tax_line_id,
1017 l_report_status_tracking,
1018 1, --p_object_version_number,
1019 fnd_global.user_id,
1020 sysdate,
1021 fnd_global.user_id,
1022 sysdate,
1023 fnd_global.login_id);
1024
1025 OPEN C;
1026 FETCH C INTO x_rowid;
1027
1028 IF (C%NOTFOUND) THEN
1029 CLOSE C;
1030 RAISE NO_DATA_FOUND;
1031 END IF;
1032
1033 CLOSE C;
1034
1035 IF (g_level_procedure >= g_current_runtime_level ) THEN
1036 FND_LOG.STRING(g_level_procedure,
1037 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Insert_Row',
1038 'Inserting into ZX_LINES (-)');
1039 END IF;
1040
1041 IF (g_level_procedure >= g_current_runtime_level ) THEN
1042 FND_LOG.STRING(g_level_procedure,
1043 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Insert_Row',
1044 'Set Recalc_Required_Flag');
1045 END IF;
1046
1047 --Set recalculate_required_flag = 'Y' for all the tax lines for the same
1048 --trx line with compounding_tax_miss_flag = 'Y'.
1049 UPDATE ZX_LINES
1050 SET RECALC_REQUIRED_FLAG = p_recalc_required_flag
1051 WHERE APPLICATION_ID = p_application_id
1052 AND ENTITY_CODE = p_entity_code
1053 AND EVENT_CLASS_CODE = p_event_class_code
1054 AND TRX_ID = p_trx_id
1055 AND TRX_LINE_ID = p_trx_line_id
1056 AND TRX_LEVEL_TYPE = p_trx_level_type
1057 AND COMPOUNDING_TAX_MISS_FLAG = 'Y';
1058
1059 IF (g_level_procedure >= g_current_runtime_level ) THEN
1060 FND_LOG.STRING(g_level_procedure,
1061 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Insert_Row.END',
1062 'ZX_TRL_DETAIL_OVERRIDE_PKG: Insert_Row (-)');
1063 END IF;
1064
1065 END Insert_Row;
1066
1067 PROCEDURE Lock_Row
1068 (X_Rowid IN OUT NOCOPY VARCHAR2,
1069 p_tax_line_id NUMBER,
1070 p_internal_organization_id NUMBER,
1071 p_application_id NUMBER,
1072 p_entity_code VARCHAR2,
1073 p_event_class_code VARCHAR2,
1074 p_event_type_code VARCHAR2,
1075 p_trx_id NUMBER,
1076 p_trx_line_id NUMBER,
1077 p_trx_level_type VARCHAR2,
1078 p_trx_line_number NUMBER,
1079 p_doc_event_status VARCHAR2,
1080 p_tax_event_class_code VARCHAR2,
1081 p_tax_event_type_code VARCHAR2,
1082 p_tax_line_number NUMBER,
1083 p_content_owner_id NUMBER,
1084 p_tax_regime_id NUMBER,
1085 p_tax_regime_code VARCHAR2,
1086 p_tax_id NUMBER,
1087 p_tax VARCHAR2,
1088 p_tax_status_id NUMBER,
1089 p_tax_status_code VARCHAR2,
1090 p_tax_rate_id NUMBER,
1091 p_tax_rate_code VARCHAR2,
1092 p_tax_rate NUMBER,
1093 p_tax_rate_type VARCHAR2,
1094 p_tax_apportionment_line_num NUMBER,--reduced in size tax_apportionment_line_number
1095 p_trx_id_level2 NUMBER,
1096 p_trx_id_level3 NUMBER,
1097 p_trx_id_level4 NUMBER,
1098 p_trx_id_level5 NUMBER,
1099 p_trx_id_level6 NUMBER,
1100 p_trx_user_key_level1 VARCHAR2,
1101 p_trx_user_key_level2 VARCHAR2,
1102 p_trx_user_key_level3 VARCHAR2,
1103 p_trx_user_key_level4 VARCHAR2,
1104 p_trx_user_key_level5 VARCHAR2,
1105 p_trx_user_key_level6 VARCHAR2,
1106 p_mrc_tax_line_flag VARCHAR2,
1107 p_mrc_link_to_tax_line_id NUMBER,
1108 p_ledger_id NUMBER,
1109 p_establishment_id NUMBER,
1110 p_legal_entity_id NUMBER,
1111 p_hq_estb_reg_number VARCHAR2,
1112 p_hq_estb_party_tax_prof_id NUMBER,
1113 p_currency_conversion_date DATE,
1114 p_currency_conversion_type VARCHAR2,
1115 p_currency_conversion_rate NUMBER,
1116 p_tax_curr_conversion_date DATE,--reduced in size tax_currency_conversion_date
1117 p_tax_curr_conversion_type VARCHAR2,--reduced in size p_tax_currency_conversion_type
1118 p_tax_curr_conversion_rate NUMBER,--reduced in size p_tax_currency_conversion_rate
1119 p_trx_currency_code VARCHAR2,
1120 p_reporting_currency_code VARCHAR2,
1121 p_minimum_accountable_unit NUMBER,
1122 p_precision NUMBER,
1123 p_trx_number VARCHAR2,
1124 p_trx_date DATE,
1125 p_unit_price NUMBER,
1126 p_line_amt NUMBER,
1127 p_trx_line_quantity NUMBER,
1128 p_tax_base_modifier_rate NUMBER,
1129 p_ref_doc_application_id NUMBER,
1130 p_ref_doc_entity_code VARCHAR2,
1131 p_ref_doc_event_class_code VARCHAR2,
1132 p_ref_doc_trx_id NUMBER,
1133 p_ref_doc_trx_level_type VARCHAR2,
1134 p_ref_doc_line_id NUMBER,
1135 p_ref_doc_line_quantity NUMBER,
1136 p_other_doc_line_amt NUMBER,
1137 p_other_doc_line_tax_amt NUMBER,
1138 p_other_doc_line_taxable_amt NUMBER,
1139 p_unrounded_taxable_amt NUMBER,
1140 p_unrounded_tax_amt NUMBER,
1141 p_related_doc_application_id NUMBER,
1142 p_related_doc_entity_code VARCHAR2,
1143 p_related_doc_evt_class_code VARCHAR2,--reduced in size p_related_doc_event_class_code
1144 p_related_doc_trx_id NUMBER,
1145 p_related_doc_trx_level_type VARCHAR2,
1146 p_related_doc_number VARCHAR2,
1147 p_related_doc_date DATE,
1148 p_applied_from_appl_id NUMBER,--reduced in size p_applied_from_application_id
1149 p_applied_from_evt_clss_code VARCHAR2,--reduced in size p_applied_from_event_class_code
1150 p_applied_from_entity_code VARCHAR2,
1151 p_applied_from_trx_id NUMBER,
1152 p_applied_from_trx_level_type VARCHAR2,
1153 p_applied_from_line_id NUMBER,
1154 p_applied_from_trx_number VARCHAR2,
1155 p_adjusted_doc_appln_id NUMBER,--reduced in size p_adjusted_doc_application_id
1156 p_adjusted_doc_entity_code VARCHAR2,
1157 p_adjusted_doc_evt_clss_code VARCHAR2,--reduced in size p_adjusted_doc_event_class_code
1158 p_adjusted_doc_trx_id NUMBER,
1159 p_adjusted_doc_trx_level_type VARCHAR2,
1160 p_adjusted_doc_line_id NUMBER,
1161 p_adjusted_doc_number VARCHAR2,
1162 p_adjusted_doc_date DATE,
1163 p_applied_to_application_id NUMBER,
1164 p_applied_to_evt_class_code VARCHAR2,--reduced in size p_applied_to_event_class_code
1165 p_applied_to_entity_code VARCHAR2,
1166 p_applied_to_trx_id NUMBER,
1167 p_applied_to_trx_level_type VARCHAR2,
1168 p_applied_to_line_id NUMBER,
1169 p_summary_tax_line_id NUMBER,
1170 p_offset_link_to_tax_line_id NUMBER,
1171 p_offset_flag VARCHAR2,
1172 p_process_for_recovery_flag VARCHAR2,
1173 p_tax_jurisdiction_id NUMBER,
1174 p_tax_jurisdiction_code VARCHAR2,
1175 p_place_of_supply NUMBER,
1176 p_place_of_supply_type_code VARCHAR2,
1177 p_place_of_supply_result_id NUMBER,
1178 p_tax_date_rule_id NUMBER,
1179 p_tax_date DATE,
1180 p_tax_determine_date DATE,
1181 p_tax_point_date DATE,
1182 p_trx_line_date DATE,
1183 p_tax_type_code VARCHAR2,
1184 p_tax_code VARCHAR2,
1185 p_tax_registration_id NUMBER,
1186 p_tax_registration_number VARCHAR2,
1187 p_registration_party_type VARCHAR2,
1188 p_rounding_level_code VARCHAR2,
1189 p_rounding_rule_code VARCHAR2,
1190 p_rndg_lvl_party_tax_prof_id NUMBER,--reduced in size p_rounding_lvl_party_tax_prof_id
1191 p_rounding_lvl_party_type VARCHAR2,
1192 p_compounding_tax_flag VARCHAR2,
1193 p_orig_tax_status_id NUMBER,
1194 p_orig_tax_status_code VARCHAR2,
1195 p_orig_tax_rate_id NUMBER,
1196 p_orig_tax_rate_code VARCHAR2,
1197 p_orig_tax_rate NUMBER,
1198 p_orig_tax_jurisdiction_id NUMBER,
1199 p_orig_tax_jurisdiction_code VARCHAR2,
1200 p_orig_tax_amt_included_flag VARCHAR2,
1201 p_orig_self_assessed_flag VARCHAR2,
1202 p_tax_currency_code VARCHAR2,
1203 p_tax_amt NUMBER,
1204 p_tax_amt_tax_curr NUMBER,
1205 p_tax_amt_funcl_curr NUMBER,
1206 p_taxable_amt NUMBER,
1207 p_taxable_amt_tax_curr NUMBER,
1208 p_taxable_amt_funcl_curr NUMBER,
1209 p_orig_taxable_amt NUMBER,
1210 p_orig_taxable_amt_tax_curr NUMBER,
1211 p_cal_tax_amt NUMBER,
1212 p_cal_tax_amt_tax_curr NUMBER,
1213 p_cal_tax_amt_funcl_curr NUMBER,
1214 p_orig_tax_amt NUMBER,
1215 p_orig_tax_amt_tax_curr NUMBER,
1216 p_rec_tax_amt NUMBER,
1217 p_rec_tax_amt_tax_curr NUMBER,
1218 p_rec_tax_amt_funcl_curr NUMBER,
1219 p_nrec_tax_amt NUMBER,
1220 p_nrec_tax_amt_tax_curr NUMBER,
1221 p_nrec_tax_amt_funcl_curr NUMBER,
1222 p_tax_exemption_id NUMBER,
1223 p_tax_rate_before_exemption NUMBER,
1224 p_tax_rate_name_before_exempt VARCHAR2,
1225 p_exempt_rate_modifier NUMBER,
1226 p_exempt_certificate_number VARCHAR2,
1227 p_exempt_reason VARCHAR2,
1228 p_exempt_reason_code VARCHAR2,
1229 p_tax_exception_id NUMBER,
1230 p_tax_rate_before_exception NUMBER,
1231 p_tax_rate_name_before_except VARCHAR2,
1232 p_exception_rate NUMBER,
1233 p_tax_apportionment_flag VARCHAR2,
1234 p_historical_flag VARCHAR2,
1235 p_taxable_basis_formula VARCHAR2,
1236 p_tax_calculation_formula VARCHAR2,
1237 p_cancel_flag VARCHAR2,
1238 p_purge_flag VARCHAR2,
1239 p_delete_flag VARCHAR2,
1240 p_tax_amt_included_flag VARCHAR2,
1241 p_self_assessed_flag VARCHAR2,
1242 p_overridden_flag VARCHAR2,
1243 p_manually_entered_flag VARCHAR2,
1244 p_reporting_only_flag VARCHAR2,
1245 p_freeze_until_overriddn_flg VARCHAR2,--reduced in size p_Freeze_Until_Overridden_Flag
1246 p_copied_from_other_doc_flag VARCHAR2,
1247 p_recalc_required_flag VARCHAR2,
1248 p_settlement_flag VARCHAR2,
1249 p_item_dist_changed_flag VARCHAR2,
1250 p_assoc_children_frozen_flg VARCHAR2,--reduced in size p_Associated_Child_Frozen_Flag
1251 p_tax_only_line_flag VARCHAR2,
1252 p_compounding_dep_tax_flag VARCHAR2,
1253 p_compounding_tax_miss_flag VARCHAR2,
1254 p_sync_with_prvdr_flag VARCHAR2,
1255 p_last_manual_entry VARCHAR2,
1256 p_tax_provider_id NUMBER,
1257 p_record_type_code VARCHAR2,
1258 p_reporting_period_id NUMBER,
1259 p_legal_justification_text1 VARCHAR2,
1260 p_legal_justification_text2 VARCHAR2,
1261 p_legal_justification_text3 VARCHAR2,
1262 p_legal_message_appl_2 NUMBER,
1263 p_legal_message_status NUMBER,
1264 p_legal_message_rate NUMBER,
1265 p_legal_message_basis NUMBER,
1266 p_legal_message_calc NUMBER,
1267 p_legal_message_threshold NUMBER,
1268 p_legal_message_pos NUMBER,
1269 p_legal_message_trn NUMBER,
1270 p_legal_message_exmpt NUMBER,
1271 p_legal_message_excpt NUMBER,
1272 p_tax_regime_template_id NUMBER,
1273 p_tax_applicability_result_id NUMBER,--reduced in size p_tax_applicability_result_id
1274 p_direct_rate_result_id NUMBER,
1275 p_status_result_id NUMBER,
1276 p_rate_result_id NUMBER,
1277 p_basis_result_id NUMBER,
1278 p_thresh_result_id NUMBER,
1279 p_calc_result_id NUMBER,
1280 p_tax_reg_num_det_result_id NUMBER,
1281 p_eval_exmpt_result_id NUMBER,
1282 p_eval_excpt_result_id NUMBER,
1283 p_enforced_from_nat_acct_flg VARCHAR2,--reduced in size p_Enforce_From_Natural_Acct_Flag
1284 p_tax_hold_code NUMBER,
1285 p_tax_hold_released_code NUMBER,
1286 p_prd_total_tax_amt NUMBER,
1287 p_prd_total_tax_amt_tax_curr NUMBER,
1288 p_prd_total_tax_amt_funcl_curr NUMBER,
1289 p_trx_line_index VARCHAR2,
1290 p_offset_tax_rate_code VARCHAR2,
1291 p_proration_code VARCHAR2,
1292 p_other_doc_source VARCHAR2,
1293 p_internal_org_location_id NUMBER,
1294 p_line_assessable_value NUMBER,
1295 p_ctrl_total_line_tx_amt NUMBER,
1296 p_applied_to_trx_number VARCHAR2,
1297 p_attribute_category VARCHAR2,
1298 p_attribute1 VARCHAR2,
1299 p_attribute2 VARCHAR2,
1300 p_attribute3 VARCHAR2,
1301 p_attribute4 VARCHAR2,
1302 p_attribute5 VARCHAR2,
1303 p_attribute6 VARCHAR2,
1304 p_attribute7 VARCHAR2,
1305 p_attribute8 VARCHAR2,
1306 p_attribute9 VARCHAR2,
1307 p_attribute10 VARCHAR2,
1308 p_attribute11 VARCHAR2,
1309 p_attribute12 VARCHAR2,
1310 p_attribute13 VARCHAR2,
1311 p_attribute14 VARCHAR2,
1312 p_attribute15 VARCHAR2,
1313 p_global_attribute_category VARCHAR2,
1314 p_global_attribute1 VARCHAR2,
1315 p_global_attribute2 VARCHAR2,
1316 p_global_attribute3 VARCHAR2,
1317 p_global_attribute4 VARCHAR2,
1318 p_global_attribute5 VARCHAR2,
1319 p_global_attribute6 VARCHAR2,
1320 p_global_attribute7 VARCHAR2,
1321 p_global_attribute8 VARCHAR2,
1322 p_global_attribute9 VARCHAR2,
1323 p_global_attribute10 VARCHAR2,
1324 p_global_attribute11 VARCHAR2,
1325 p_global_attribute12 VARCHAR2,
1326 p_global_attribute13 VARCHAR2,
1327 p_global_attribute14 VARCHAR2,
1328 p_global_attribute15 VARCHAR2,
1329 p_numeric1 NUMBER,
1330 p_numeric2 NUMBER,
1331 p_numeric3 NUMBER,
1332 p_numeric4 NUMBER,
1333 p_numeric5 NUMBER,
1334 p_numeric6 NUMBER,
1335 p_numeric7 NUMBER,
1336 p_numeric8 NUMBER,
1337 p_numeric9 NUMBER,
1338 p_numeric10 NUMBER,
1339 p_char1 VARCHAR2,
1340 p_char2 VARCHAR2,
1341 p_char3 VARCHAR2,
1342 p_char4 VARCHAR2,
1343 p_char5 VARCHAR2,
1344 p_char6 VARCHAR2,
1345 p_char7 VARCHAR2,
1346 p_char8 VARCHAR2,
1347 p_char9 VARCHAR2,
1348 p_char10 VARCHAR2,
1349 p_date1 DATE,
1350 p_date2 DATE,
1351 p_date3 DATE,
1352 p_date4 DATE,
1353 p_date5 DATE,
1354 p_date6 DATE,
1355 p_date7 DATE,
1356 p_date8 DATE,
1357 p_date9 DATE,
1358 p_date10 DATE,
1359 p_interface_entity_code VARCHAR2,
1360 p_interface_tax_line_id NUMBER,
1361 p_taxing_juris_geography_id NUMBER,
1362 p_adjusted_doc_tax_line_id NUMBER,
1363 p_object_version_number NUMBER,
1364 p_created_by NUMBER,
1365 p_creation_date DATE,
1366 p_last_updated_by NUMBER,
1367 p_last_update_date DATE,
1368 p_last_update_login NUMBER) IS
1369
1370 CURSOR lines_csr IS
1371 SELECT TAX_LINE_ID,
1372 INTERNAL_ORGANIZATION_ID,
1373 APPLICATION_ID,
1374 ENTITY_CODE,
1375 EVENT_CLASS_CODE,
1376 EVENT_TYPE_CODE,
1377 TRX_ID,
1378 TRX_LINE_ID,
1379 TRX_LEVEL_TYPE,
1380 TRX_LINE_NUMBER,
1381 DOC_EVENT_STATUS,
1382 TAX_EVENT_CLASS_CODE,
1383 TAX_EVENT_TYPE_CODE,
1384 TAX_LINE_NUMBER,
1385 CONTENT_OWNER_ID,
1386 TAX_REGIME_ID,
1387 TAX_REGIME_CODE,
1388 TAX_ID,
1389 TAX,
1390 TAX_STATUS_ID,
1391 TAX_STATUS_CODE,
1392 TAX_RATE_ID,
1393 TAX_RATE_CODE,
1394 TAX_RATE,
1395 TAX_RATE_TYPE,
1396 TAX_APPORTIONMENT_LINE_NUMBER,
1397 TRX_ID_LEVEL2,
1398 TRX_ID_LEVEL3,
1399 TRX_ID_LEVEL4,
1400 TRX_ID_LEVEL5,
1401 TRX_ID_LEVEL6,
1402 TRX_USER_KEY_LEVEL1,
1403 TRX_USER_KEY_LEVEL2,
1404 TRX_USER_KEY_LEVEL3,
1405 TRX_USER_KEY_LEVEL4,
1406 TRX_USER_KEY_LEVEL5,
1407 TRX_USER_KEY_LEVEL6,
1408 MRC_TAX_LINE_FLAG,
1409 MRC_LINK_TO_TAX_LINE_ID,
1410 LEDGER_ID,
1411 ESTABLISHMENT_ID,
1412 LEGAL_ENTITY_ID,
1413 HQ_ESTB_REG_NUMBER,
1414 HQ_ESTB_PARTY_TAX_PROF_ID,
1415 CURRENCY_CONVERSION_DATE,
1416 CURRENCY_CONVERSION_TYPE,
1417 CURRENCY_CONVERSION_RATE,
1418 TAX_CURRENCY_CONVERSION_DATE,
1419 TAX_CURRENCY_CONVERSION_TYPE,
1420 TAX_CURRENCY_CONVERSION_RATE,
1421 TRX_CURRENCY_CODE,
1422 MINIMUM_ACCOUNTABLE_UNIT,
1423 PRECISION,
1424 TRX_NUMBER,
1425 TRX_DATE,
1426 UNIT_PRICE,
1427 LINE_AMT,
1428 TRX_LINE_QUANTITY,
1429 TAX_BASE_MODIFIER_RATE,
1430 REF_DOC_APPLICATION_ID,
1431 REF_DOC_ENTITY_CODE,
1432 REF_DOC_EVENT_CLASS_CODE,
1433 REF_DOC_TRX_ID,
1434 REF_DOC_TRX_LEVEL_TYPE,
1435 REF_DOC_LINE_ID,
1436 REF_DOC_LINE_QUANTITY,
1437 OTHER_DOC_LINE_AMT,
1438 OTHER_DOC_LINE_TAX_AMT,
1439 OTHER_DOC_LINE_TAXABLE_AMT,
1440 UNROUNDED_TAXABLE_AMT,
1441 UNROUNDED_TAX_AMT,
1442 RELATED_DOC_APPLICATION_ID,
1443 RELATED_DOC_ENTITY_CODE,
1444 RELATED_DOC_EVENT_CLASS_CODE,
1445 RELATED_DOC_TRX_ID,
1446 RELATED_DOC_TRX_LEVEL_TYPE,
1447 RELATED_DOC_NUMBER,
1448 RELATED_DOC_DATE,
1449 APPLIED_FROM_APPLICATION_ID,
1450 APPLIED_FROM_EVENT_CLASS_CODE,
1451 APPLIED_FROM_ENTITY_CODE,
1452 APPLIED_FROM_TRX_ID,
1453 APPLIED_FROM_TRX_LEVEL_TYPE,
1454 APPLIED_FROM_LINE_ID,
1455 APPLIED_FROM_TRX_NUMBER,
1456 ADJUSTED_DOC_APPLICATION_ID,
1457 ADJUSTED_DOC_ENTITY_CODE,
1458 ADJUSTED_DOC_EVENT_CLASS_CODE,
1459 ADJUSTED_DOC_TRX_ID,
1460 ADJUSTED_DOC_TRX_LEVEL_TYPE,
1461 ADJUSTED_DOC_LINE_ID,
1462 ADJUSTED_DOC_NUMBER,
1463 ADJUSTED_DOC_DATE,
1464 APPLIED_TO_APPLICATION_ID,
1465 APPLIED_TO_EVENT_CLASS_CODE,
1466 APPLIED_TO_ENTITY_CODE,
1467 APPLIED_TO_TRX_ID,
1468 APPLIED_TO_TRX_LEVEL_TYPE,
1469 APPLIED_TO_LINE_ID,
1470 SUMMARY_TAX_LINE_ID,
1471 OFFSET_LINK_TO_TAX_LINE_ID,
1472 OFFSET_FLAG,
1473 PROCESS_FOR_RECOVERY_FLAG,
1474 TAX_JURISDICTION_ID,
1475 TAX_JURISDICTION_CODE,
1476 PLACE_OF_SUPPLY,
1477 PLACE_OF_SUPPLY_TYPE_CODE,
1478 PLACE_OF_SUPPLY_RESULT_ID,
1479 TAX_DATE_RULE_ID,
1480 TAX_DATE,
1481 TAX_DETERMINE_DATE,
1482 TAX_POINT_DATE,
1483 TRX_LINE_DATE,
1484 TAX_TYPE_CODE,
1485 TAX_CODE,
1486 TAX_REGISTRATION_ID,
1487 TAX_REGISTRATION_NUMBER,
1488 REGISTRATION_PARTY_TYPE,
1489 ROUNDING_LEVEL_CODE,
1490 ROUNDING_RULE_CODE,
1491 ROUNDING_LVL_PARTY_TAX_PROF_ID,
1492 ROUNDING_LVL_PARTY_TYPE,
1493 COMPOUNDING_TAX_FLAG,
1494 ORIG_TAX_STATUS_ID,
1495 ORIG_TAX_STATUS_CODE,
1496 ORIG_TAX_RATE_ID,
1497 ORIG_TAX_RATE_CODE,
1498 ORIG_TAX_RATE,
1499 ORIG_TAX_JURISDICTION_ID,
1500 ORIG_TAX_JURISDICTION_CODE,
1501 ORIG_TAX_AMT_INCLUDED_FLAG,
1502 ORIG_SELF_ASSESSED_FLAG,
1503 TAX_CURRENCY_CODE,
1504 TAX_AMT,
1505 TAX_AMT_TAX_CURR,
1506 TAX_AMT_FUNCL_CURR,
1507 TAXABLE_AMT,
1508 TAXABLE_AMT_TAX_CURR,
1509 TAXABLE_AMT_FUNCL_CURR,
1510 ORIG_TAXABLE_AMT,
1511 ORIG_TAXABLE_AMT_TAX_CURR,
1512 CAL_TAX_AMT,
1513 CAL_TAX_AMT_TAX_CURR,
1514 CAL_TAX_AMT_FUNCL_CURR,
1515 ORIG_TAX_AMT,
1516 ORIG_TAX_AMT_TAX_CURR,
1517 REC_TAX_AMT,
1518 REC_TAX_AMT_TAX_CURR,
1519 REC_TAX_AMT_FUNCL_CURR,
1520 NREC_TAX_AMT,
1521 NREC_TAX_AMT_TAX_CURR,
1522 NREC_TAX_AMT_FUNCL_CURR,
1523 TAX_EXEMPTION_ID,
1524 TAX_RATE_BEFORE_EXEMPTION,
1525 TAX_RATE_NAME_BEFORE_EXEMPTION,
1526 EXEMPT_RATE_MODIFIER,
1527 EXEMPT_CERTIFICATE_NUMBER,
1528 EXEMPT_REASON,
1529 EXEMPT_REASON_CODE,
1530 TAX_EXCEPTION_ID,
1531 TAX_RATE_BEFORE_EXCEPTION,
1532 TAX_RATE_NAME_BEFORE_EXCEPTION,
1533 EXCEPTION_RATE,
1534 TAX_APPORTIONMENT_FLAG,
1535 HISTORICAL_FLAG,
1536 TAXABLE_BASIS_FORMULA,
1537 TAX_CALCULATION_FORMULA,
1538 CANCEL_FLAG,
1539 PURGE_FLAG,
1540 DELETE_FLAG,
1541 TAX_AMT_INCLUDED_FLAG,
1542 SELF_ASSESSED_FLAG,
1543 OVERRIDDEN_FLAG,
1544 MANUALLY_ENTERED_FLAG,
1545 REPORTING_ONLY_FLAG,
1546 FREEZE_UNTIL_OVERRIDDEN_FLAG,
1547 COPIED_FROM_OTHER_DOC_FLAG,
1548 RECALC_REQUIRED_FLAG,
1549 SETTLEMENT_FLAG,
1550 ITEM_DIST_CHANGED_FLAG,
1551 ASSOCIATED_CHILD_FROZEN_FLAG,
1552 TAX_ONLY_LINE_FLAG,
1553 COMPOUNDING_DEP_TAX_FLAG,
1554 COMPOUNDING_TAX_MISS_FLAG,
1555 SYNC_WITH_PRVDR_FLAG,
1556 LAST_MANUAL_ENTRY,
1557 TAX_PROVIDER_ID,
1558 RECORD_TYPE_CODE,
1559 REPORTING_PERIOD_ID,
1560 LEGAL_JUSTIFICATION_TEXT1,
1561 LEGAL_JUSTIFICATION_TEXT2,
1562 LEGAL_JUSTIFICATION_TEXT3,
1563 LEGAL_MESSAGE_APPL_2,
1564 LEGAL_MESSAGE_STATUS,
1565 LEGAL_MESSAGE_RATE,
1566 LEGAL_MESSAGE_BASIS,
1567 LEGAL_MESSAGE_CALC,
1568 LEGAL_MESSAGE_THRESHOLD,
1569 LEGAL_MESSAGE_POS,
1570 LEGAL_MESSAGE_TRN,
1571 LEGAL_MESSAGE_EXMPT,
1572 LEGAL_MESSAGE_EXCPT,
1573 TAX_REGIME_TEMPLATE_ID,
1574 TAX_APPLICABILITY_RESULT_ID,
1575 DIRECT_RATE_RESULT_ID,
1576 STATUS_RESULT_ID,
1577 RATE_RESULT_ID,
1578 BASIS_RESULT_ID,
1579 THRESH_RESULT_ID,
1580 CALC_RESULT_ID,
1581 TAX_REG_NUM_DET_RESULT_ID,
1582 EVAL_EXMPT_RESULT_ID,
1583 EVAL_EXCPT_RESULT_ID,
1584 ENFORCE_FROM_NATURAL_ACCT_FLAG,
1585 TAX_HOLD_CODE,
1586 TAX_HOLD_RELEASED_CODE,
1587 PRD_TOTAL_TAX_AMT,
1588 PRD_TOTAL_TAX_AMT_TAX_CURR,
1589 PRD_TOTAL_TAX_AMT_FUNCL_CURR,
1590 TRX_LINE_INDEX,
1591 OFFSET_TAX_RATE_CODE,
1592 PRORATION_CODE,
1593 OTHER_DOC_SOURCE,
1594 INTERNAL_ORG_LOCATION_ID,
1595 LINE_ASSESSABLE_VALUE,
1596 CTRL_TOTAL_LINE_TX_AMT,
1597 APPLIED_TO_TRX_NUMBER,
1598 ATTRIBUTE_CATEGORY,
1599 ATTRIBUTE1,
1600 ATTRIBUTE2,
1601 ATTRIBUTE3,
1602 ATTRIBUTE4,
1603 ATTRIBUTE5,
1604 ATTRIBUTE6,
1605 ATTRIBUTE7,
1606 ATTRIBUTE8,
1607 ATTRIBUTE9,
1608 ATTRIBUTE10,
1609 ATTRIBUTE11,
1610 ATTRIBUTE12,
1611 ATTRIBUTE13,
1612 ATTRIBUTE14,
1613 ATTRIBUTE15,
1614 GLOBAL_ATTRIBUTE_CATEGORY,
1615 GLOBAL_ATTRIBUTE1,
1616 GLOBAL_ATTRIBUTE2,
1617 GLOBAL_ATTRIBUTE3,
1618 GLOBAL_ATTRIBUTE4,
1619 GLOBAL_ATTRIBUTE5,
1620 GLOBAL_ATTRIBUTE6,
1621 GLOBAL_ATTRIBUTE7,
1622 GLOBAL_ATTRIBUTE8,
1623 GLOBAL_ATTRIBUTE9,
1624 GLOBAL_ATTRIBUTE10,
1625 GLOBAL_ATTRIBUTE11,
1626 GLOBAL_ATTRIBUTE12,
1627 GLOBAL_ATTRIBUTE13,
1628 GLOBAL_ATTRIBUTE14,
1629 GLOBAL_ATTRIBUTE15,
1630 NUMERIC1,
1631 NUMERIC2,
1632 NUMERIC3,
1633 NUMERIC4,
1634 NUMERIC5,
1635 NUMERIC6,
1636 NUMERIC7,
1637 NUMERIC8,
1638 NUMERIC9,
1639 NUMERIC10,
1640 CHAR1,
1641 CHAR2,
1642 CHAR3,
1643 CHAR4,
1644 CHAR5,
1645 CHAR6,
1646 CHAR7,
1647 CHAR8,
1648 CHAR9,
1649 CHAR10,
1650 DATE1,
1651 DATE2,
1652 DATE3,
1653 DATE4,
1654 DATE5,
1655 DATE6,
1656 DATE7,
1657 DATE8,
1658 DATE9,
1659 DATE10,
1660 INTERFACE_ENTITY_CODE,
1661 INTERFACE_TAX_LINE_ID,
1662 TAXING_JURIS_GEOGRAPHY_ID,
1663 ADJUSTED_DOC_TAX_LINE_ID,
1664 OBJECT_VERSION_NUMBER,
1665 CREATED_BY,
1666 CREATION_DATE,
1667 LAST_UPDATED_BY,
1668 LAST_UPDATE_DATE,
1669 LAST_UPDATE_LOGIN
1670 FROM ZX_LINES
1671 WHERE TAX_LINE_ID = p_tax_line_id;
1672
1673 Recinfo lines_csr%ROWTYPE;
1674
1675 l_transaction_rec ZX_API_PUB.transaction_rec_type;
1676 l_return_status VARCHAR2(1000);
1677
1678 BEGIN
1679
1680 g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1681
1682 IF (g_level_procedure >= g_current_runtime_level ) THEN
1683 FND_LOG.STRING(g_level_procedure,
1684 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Lock_Row.BEGIN',
1685 'ZX_TRL_DETAIL_OVERRIDE_PKG: Lock_Row (+)');
1686 END IF;
1687
1688 OPEN lines_csr;
1689 FETCH lines_csr INTO Recinfo;
1690
1691 IF (lines_csr%NOTFOUND) THEN
1692 CLOSE lines_csr;
1693 FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
1694 APP_EXCEPTION.Raise_Exception;
1695 END IF;
1696 CLOSE lines_csr;
1697
1698 IF ((Recinfo.TAX_LINE_ID = p_tax_line_id) AND
1699 (Recinfo.INTERNAL_ORGANIZATION_ID = p_internal_organization_id) AND
1700 (Recinfo.APPLICATION_ID = p_application_id) AND
1701 (Recinfo.ENTITY_CODE = p_entity_code) AND
1702 (Recinfo.EVENT_CLASS_CODE = p_event_class_code) AND
1703 ((Recinfo.EVENT_TYPE_CODE = p_event_type_code) OR
1704 ((Recinfo.EVENT_TYPE_CODE IS NULL) AND
1705 (p_event_type_code IS NULL))) AND
1706 (Recinfo.TRX_ID = p_trx_id) AND
1707 (Recinfo.TRX_LINE_ID = p_trx_line_id) AND
1708 (Recinfo.TRX_LEVEL_TYPE = p_trx_level_type) AND
1709 ((Recinfo.TRX_LINE_NUMBER = p_TRX_LINE_NUMBER) OR
1710 ((Recinfo.TRX_LINE_NUMBER IS NULL) AND
1711 (p_TRX_LINE_NUMBER IS NULL))) AND
1712 ((Recinfo.DOC_EVENT_STATUS = p_doc_event_status) OR
1713 ((Recinfo.DOC_EVENT_STATUS IS NULL) AND
1714 (p_doc_event_status IS NULL))) AND
1715 ((Recinfo.TAX_EVENT_CLASS_CODE = p_TAX_EVENT_CLASS_CODE) OR
1716 ((Recinfo.TAX_EVENT_CLASS_CODE IS NULL) AND
1717 (p_TAX_EVENT_CLASS_CODE IS NULL))) AND
1718 ((Recinfo.TAX_EVENT_TYPE_CODE = p_TAX_EVENT_TYPE_CODE) OR
1719 ((Recinfo.TAX_EVENT_TYPE_CODE IS NULL) AND
1720 (p_TAX_EVENT_TYPE_CODE IS NULL))) AND
1721 (Recinfo.TAX_LINE_NUMBER = p_tax_line_number) AND
1722 ((Recinfo.CONTENT_OWNER_ID = p_CONTENT_OWNER_ID) OR
1723 ((Recinfo.CONTENT_OWNER_ID IS NULL) AND
1724 (p_CONTENT_OWNER_ID IS NULL))) AND
1725 ((Recinfo.TAX_REGIME_ID = p_tax_regime_id) OR
1726 ((Recinfo.TAX_REGIME_ID IS NULL) AND
1727 (p_tax_regime_id IS NULL))) AND
1728 ((Recinfo.TAX_REGIME_CODE = p_tax_regime_code) OR
1729 ((Recinfo.TAX_REGIME_CODE IS NULL) AND
1730 (p_tax_regime_code IS NULL))) AND
1731 ((Recinfo.TAX_ID = p_tax_id ) OR
1732 ((Recinfo.TAX_ID IS NULL) AND
1733 (p_tax_id IS NULL))) AND
1734 ((Recinfo.TAX = p_tax ) OR
1735 ((Recinfo.TAX IS NULL) AND
1736 (p_tax IS NULL))) AND
1737 ((Recinfo.TAX_STATUS_ID = p_tax_status_id) OR
1738 ((Recinfo.TAX_STATUS_ID IS NULL) AND
1739 (p_tax_status_id IS NULL))) AND
1740 ((Recinfo.TAX_STATUS_CODE = p_tax_status_code) OR
1741 ((Recinfo.TAX_STATUS_CODE IS NULL) AND
1742 (p_tax_status_code IS NULL))) AND
1743 ((Recinfo.TAX_RATE_ID = p_tax_rate_id ) OR
1744 ((Recinfo.TAX_RATE_ID IS NULL) AND
1745 (p_tax_rate_id IS NULL))) AND
1746 ((Recinfo.TAX_RATE_CODE = p_tax_rate_code) OR
1747 ((Recinfo.TAX_RATE_CODE IS NULL) AND
1748 (p_tax_rate_code IS NULL))) AND
1749 ((Recinfo.TAX_RATE = p_tax_rate) OR
1750 ((Recinfo.TAX_RATE IS NULL) AND
1751 (p_tax_rate IS NULL))) AND
1752 ((Recinfo.TAX_RATE_TYPE = p_tax_rate_type) OR
1753 ((Recinfo.TAX_RATE_TYPE IS NULL) AND
1754 (p_tax_rate_type IS NULL))) AND
1755 ((Recinfo.TAX_APPORTIONMENT_LINE_NUMBER = p_TAX_APPORTIONMENT_LINE_NUM) OR
1756 ((Recinfo.TAX_APPORTIONMENT_LINE_NUMBER IS NULL) AND
1757 (p_TAX_APPORTIONMENT_LINE_NUM IS NULL))) AND
1758 ((Recinfo.TRX_ID_LEVEL2 = p_TRX_ID_LEVEL2) OR
1759 ((Recinfo.TRX_ID_LEVEL2 IS NULL) AND
1760 (p_TRX_ID_LEVEL2 IS NULL))) AND
1761 ((Recinfo.TRX_ID_LEVEL3 = p_TRX_ID_LEVEL3) OR
1762 ((Recinfo.TRX_ID_LEVEL3 IS NULL) AND
1763 (p_TRX_ID_LEVEL3 IS NULL))) AND
1764 ((Recinfo.TRX_ID_LEVEL4 = p_TRX_ID_LEVEL4) OR
1765 ((Recinfo.TRX_ID_LEVEL4 IS NULL) AND
1766 (p_TRX_ID_LEVEL4 IS NULL))) AND
1767 ((Recinfo.TRX_ID_LEVEL5 = p_TRX_ID_LEVEL5) OR
1768 ((Recinfo.TRX_ID_LEVEL5 IS NULL) AND
1769 (p_TRX_ID_LEVEL5 IS NULL))) AND
1770 ((Recinfo.TRX_ID_LEVEL6 = p_TRX_ID_LEVEL6) OR
1771 ((Recinfo.TRX_ID_LEVEL6 IS NULL) AND
1772 (p_TRX_ID_LEVEL6 IS NULL))) AND
1773 ((Recinfo.TRX_USER_KEY_LEVEL1 = p_TRX_USER_KEY_LEVEL1) OR
1774 ((Recinfo.TRX_USER_KEY_LEVEL1 IS NULL) AND
1775 (p_TRX_USER_KEY_LEVEL1 IS NULL))) AND
1776 ((Recinfo.TRX_USER_KEY_LEVEL2 = p_TRX_USER_KEY_LEVEL2) OR
1777 ((Recinfo.TRX_USER_KEY_LEVEL2 IS NULL) AND
1778 (p_TRX_USER_KEY_LEVEL2 IS NULL))) AND
1779 ((Recinfo.TRX_USER_KEY_LEVEL3 = p_TRX_USER_KEY_LEVEL3) OR
1780 ((Recinfo.TRX_USER_KEY_LEVEL3 IS NULL) AND
1781 (p_TRX_USER_KEY_LEVEL3 IS NULL))) AND
1782 ((Recinfo.TRX_USER_KEY_LEVEL4 = p_TRX_USER_KEY_LEVEL4) OR
1783 ((Recinfo.TRX_USER_KEY_LEVEL4 IS NULL) AND
1784 (p_TRX_USER_KEY_LEVEL4 IS NULL))) AND
1785 ((Recinfo.TRX_USER_KEY_LEVEL5 = p_TRX_USER_KEY_LEVEL5) OR
1786 ((Recinfo.TRX_USER_KEY_LEVEL5 IS NULL) AND
1787 (p_TRX_USER_KEY_LEVEL5 IS NULL))) AND
1788 ((Recinfo.TRX_USER_KEY_LEVEL6 = p_TRX_USER_KEY_LEVEL6) OR
1789 ((Recinfo.TRX_USER_KEY_LEVEL6 IS NULL) AND
1790 (p_TRX_USER_KEY_LEVEL6 IS NULL))) AND
1791 ((Recinfo.MRC_TAX_LINE_FLAG = p_MRC_TAX_LINE_FLAG) OR
1792 ((Recinfo.MRC_TAX_LINE_FLAG IS NULL) AND
1793 (p_MRC_TAX_LINE_FLAG IS NULL))) AND
1794 ((Recinfo.MRC_LINK_TO_TAX_LINE_ID = p_MRC_LINK_TO_TAX_LINE_ID) OR
1795 ((Recinfo.MRC_LINK_TO_TAX_LINE_ID IS NULL) AND
1796 (p_MRC_LINK_TO_TAX_LINE_ID IS NULL))) AND
1797 ((Recinfo.LEDGER_ID = p_LEDGER_ID) OR
1798 ((Recinfo.LEDGER_ID IS NULL) AND
1799 (p_LEDGER_ID IS NULL))) AND
1800 ((Recinfo.ESTABLISHMENT_ID = p_ESTABLISHMENT_ID) OR
1801 ((Recinfo.ESTABLISHMENT_ID IS NULL) AND
1802 (p_ESTABLISHMENT_ID IS NULL))) AND
1803 ((Recinfo.LEGAL_ENTITY_ID = p_LEGAL_ENTITY_ID) OR
1804 ((Recinfo.LEGAL_ENTITY_ID IS NULL) AND
1805 (p_LEGAL_ENTITY_ID IS NULL))) AND
1806 ((Recinfo.HQ_ESTB_REG_NUMBER = p_HQ_ESTB_REG_NUMBER) OR
1807 ((Recinfo.HQ_ESTB_REG_NUMBER IS NULL) AND
1808 (p_HQ_ESTB_REG_NUMBER IS NULL))) AND
1809 ((Recinfo.HQ_ESTB_PARTY_TAX_PROF_ID = p_HQ_ESTB_PARTY_TAX_PROF_ID) OR
1810 ((Recinfo.HQ_ESTB_PARTY_TAX_PROF_ID IS NULL) AND
1811 (p_HQ_ESTB_PARTY_TAX_PROF_ID IS NULL))) AND
1812 ((Recinfo.CURRENCY_CONVERSION_DATE = p_CURRENCY_CONVERSION_DATE) OR
1813 ((Recinfo.CURRENCY_CONVERSION_DATE IS NULL) AND
1814 (p_CURRENCY_CONVERSION_DATE IS NULL))) AND
1815 ((Recinfo.CURRENCY_CONVERSION_TYPE = p_CURRENCY_CONVERSION_TYPE) OR
1816 ((Recinfo.CURRENCY_CONVERSION_TYPE IS NULL) AND
1817 (p_CURRENCY_CONVERSION_TYPE IS NULL))) AND
1818 ((Recinfo.CURRENCY_CONVERSION_RATE = p_CURRENCY_CONVERSION_RATE) OR
1819 ((Recinfo.CURRENCY_CONVERSION_RATE IS NULL) AND
1820 (p_CURRENCY_CONVERSION_RATE IS NULL))) AND
1821 ((Recinfo.TAX_CURRENCY_CONVERSION_DATE = p_TAX_CURR_CONVERSION_DATE) OR
1822 ((Recinfo.TAX_CURRENCY_CONVERSION_DATE IS NULL) AND
1823 (p_TAX_CURR_CONVERSION_DATE IS NULL))) AND
1824 ((Recinfo.TAX_CURRENCY_CONVERSION_TYPE = p_TAX_CURR_CONVERSION_TYPE) OR
1825 ((Recinfo.TAX_CURRENCY_CONVERSION_TYPE IS NULL) AND
1826 (p_TAX_CURR_CONVERSION_TYPE IS NULL))) AND
1827 ((Recinfo.TAX_CURRENCY_CONVERSION_RATE = p_TAX_CURR_CONVERSION_RATE) OR
1828 ((Recinfo.TAX_CURRENCY_CONVERSION_RATE IS NULL) AND
1829 (p_TAX_CURR_CONVERSION_RATE IS NULL))) AND
1830 ((Recinfo.TRX_CURRENCY_CODE = p_TRX_CURRENCY_CODE) OR
1831 ((Recinfo.TRX_CURRENCY_CODE IS NULL) AND
1832 (p_TRX_CURRENCY_CODE IS NULL))) AND
1833 ((Recinfo.MINIMUM_ACCOUNTABLE_UNIT = p_MINIMUM_ACCOUNTABLE_UNIT) OR
1834 ((Recinfo.MINIMUM_ACCOUNTABLE_UNIT IS NULL) AND
1835 (p_MINIMUM_ACCOUNTABLE_UNIT IS NULL))) AND
1836 ((Recinfo.PRECISION = p_PRECISION) OR
1837 ((Recinfo.PRECISION IS NULL) AND
1838 (p_PRECISION IS NULL))) AND
1839 ((Recinfo.TRX_NUMBER = p_trx_number) OR
1840 ((Recinfo.TRX_NUMBER IS NULL) AND
1841 (p_trx_number IS NULL))) AND
1842 ((Recinfo.TRX_DATE = p_TRX_DATE) OR
1843 ((Recinfo.TRX_DATE IS NULL) AND
1844 (p_TRX_DATE IS NULL))) AND
1845 ((Recinfo.UNIT_PRICE = p_UNIT_PRICE) OR
1846 ((Recinfo.UNIT_PRICE IS NULL) AND
1847 (p_UNIT_PRICE IS NULL))) AND
1848 ((Recinfo.LINE_AMT = p_LINE_AMT) OR
1849 ((Recinfo.LINE_AMT IS NULL) AND
1850 (p_LINE_AMT IS NULL))) AND
1851 ((Recinfo.TRX_LINE_QUANTITY = p_TRX_LINE_QUANTITY) OR
1852 ((Recinfo.TRX_LINE_QUANTITY IS NULL) AND
1853 (p_TRX_LINE_QUANTITY IS NULL))) AND
1854 ((Recinfo.TAX_BASE_MODIFIER_RATE = p_TAX_BASE_MODIFIER_RATE) OR
1855 ((Recinfo.TAX_BASE_MODIFIER_RATE IS NULL) AND
1856 (p_TAX_BASE_MODIFIER_RATE IS NULL))) AND
1857 ((Recinfo.REF_DOC_APPLICATION_ID = p_REF_DOC_APPLICATION_ID) OR
1858 ((Recinfo.REF_DOC_APPLICATION_ID IS NULL) AND
1859 (p_REF_DOC_APPLICATION_ID IS NULL))) AND
1860 ((Recinfo.REF_DOC_ENTITY_CODE = p_REF_DOC_ENTITY_CODE) OR
1861 ((Recinfo.REF_DOC_ENTITY_CODE IS NULL) AND
1862 (p_REF_DOC_ENTITY_CODE IS NULL))) AND
1863 ((Recinfo.REF_DOC_EVENT_CLASS_CODE = p_REF_DOC_EVENT_CLASS_CODE) OR
1864 ((Recinfo.REF_DOC_EVENT_CLASS_CODE IS NULL) AND
1865 (p_REF_DOC_EVENT_CLASS_CODE IS NULL))) AND
1866 ((Recinfo.REF_DOC_TRX_ID = p_REF_DOC_TRX_ID) OR
1867 ((Recinfo.REF_DOC_TRX_ID IS NULL) AND
1868 (p_REF_DOC_TRX_ID IS NULL))) AND
1869 ((Recinfo.REF_DOC_TRX_LEVEL_TYPE = p_REF_DOC_TRX_LEVEL_TYPE) OR
1870 ((Recinfo.REF_DOC_TRX_LEVEL_TYPE IS NULL) AND
1871 (p_REF_DOC_TRX_LEVEL_TYPE IS NULL))) AND
1872 ((Recinfo.REF_DOC_LINE_ID = p_REF_DOC_LINE_ID) OR
1873 ((Recinfo.REF_DOC_LINE_ID IS NULL) AND
1874 (p_REF_DOC_LINE_ID IS NULL))) AND
1875 ((Recinfo.REF_DOC_LINE_QUANTITY = p_REF_DOC_LINE_QUANTITY) OR
1876 ((Recinfo.REF_DOC_LINE_QUANTITY IS NULL) AND
1877 (p_REF_DOC_LINE_QUANTITY IS NULL))) AND
1878 ((Recinfo.OTHER_DOC_LINE_AMT = p_OTHER_DOC_LINE_AMT) OR
1879 ((Recinfo.OTHER_DOC_LINE_AMT IS NULL) AND
1880 (p_OTHER_DOC_LINE_AMT IS NULL))) AND
1881 ((Recinfo.OTHER_DOC_LINE_TAX_AMT = p_OTHER_DOC_LINE_TAX_AMT) OR
1882 ((Recinfo.OTHER_DOC_LINE_TAX_AMT IS NULL) AND
1883 (p_OTHER_DOC_LINE_TAX_AMT IS NULL))) AND
1884 ((Recinfo.OTHER_DOC_LINE_TAXABLE_AMT = p_OTHER_DOC_LINE_TAXABLE_AMT) OR
1885 ((Recinfo.OTHER_DOC_LINE_TAXABLE_AMT IS NULL) AND
1886 (p_OTHER_DOC_LINE_TAXABLE_AMT IS NULL))) AND
1887 ((Recinfo.UNROUNDED_TAXABLE_AMT = p_UNROUNDED_TAXABLE_AMT) OR
1888 ((Recinfo.UNROUNDED_TAXABLE_AMT IS NULL) AND
1889 (p_UNROUNDED_TAXABLE_AMT IS NULL))) AND
1890 ((Recinfo.UNROUNDED_TAX_AMT = p_unrounded_tax_amt) OR
1891 ((Recinfo.UNROUNDED_TAX_AMT IS NULL) AND
1892 (p_unrounded_tax_amt IS NULL))) AND
1893 ((Recinfo.RELATED_DOC_APPLICATION_ID = p_RELATED_DOC_APPLICATION_ID) OR
1894 ((Recinfo.RELATED_DOC_APPLICATION_ID IS NULL) AND
1895 (p_RELATED_DOC_APPLICATION_ID IS NULL))) AND
1896 ((Recinfo.RELATED_DOC_ENTITY_CODE = p_RELATED_DOC_ENTITY_CODE) OR
1897 ((Recinfo.RELATED_DOC_ENTITY_CODE IS NULL) AND
1898 (p_RELATED_DOC_ENTITY_CODE IS NULL))) AND
1899 ((Recinfo.RELATED_DOC_EVENT_CLASS_CODE = p_RELATED_DOC_EVT_CLASS_CODE) OR
1900 ((Recinfo.RELATED_DOC_EVENT_CLASS_CODE IS NULL) AND
1901 (p_RELATED_DOC_EVT_CLASS_CODE IS NULL))) AND
1902 ((Recinfo.RELATED_DOC_TRX_ID = p_RELATED_DOC_TRX_ID) OR
1903 ((Recinfo.RELATED_DOC_TRX_ID IS NULL) AND
1904 (p_RELATED_DOC_TRX_ID IS NULL))) AND
1905 ((Recinfo.RELATED_DOC_TRX_LEVEL_TYPE = p_RELATED_DOC_TRX_LEVEL_TYPE) OR
1906 ((Recinfo.RELATED_DOC_TRX_LEVEL_TYPE IS NULL) AND
1907 (p_RELATED_DOC_TRX_LEVEL_TYPE IS NULL))) AND
1908 ((Recinfo.RELATED_DOC_NUMBER = p_RELATED_DOC_NUMBER) OR
1909 ((Recinfo.RELATED_DOC_NUMBER IS NULL) AND
1910 (p_RELATED_DOC_NUMBER IS NULL))) AND
1911 ((Recinfo.RELATED_DOC_DATE = p_RELATED_DOC_DATE) OR
1912 ((Recinfo.RELATED_DOC_DATE IS NULL) AND
1913 (p_RELATED_DOC_DATE IS NULL))) AND
1914 ((Recinfo.APPLIED_FROM_APPLICATION_ID = p_APPLIED_FROM_APPL_ID) OR
1915 ((Recinfo.APPLIED_FROM_APPLICATION_ID IS NULL) AND
1916 (p_APPLIED_FROM_APPL_ID IS NULL))) AND
1917 ((Recinfo.APPLIED_FROM_EVENT_CLASS_CODE = p_APPLIED_FROM_EVT_CLSS_CODE) OR
1918 ((Recinfo.APPLIED_FROM_EVENT_CLASS_CODE IS NULL) AND
1919 (p_APPLIED_FROM_EVT_CLSS_CODE IS NULL))) AND
1920 ((Recinfo.APPLIED_FROM_ENTITY_CODE = p_APPLIED_FROM_ENTITY_CODE) OR
1921 ((Recinfo.APPLIED_FROM_ENTITY_CODE IS NULL) AND
1922 (p_APPLIED_FROM_ENTITY_CODE IS NULL))) AND
1923 ((Recinfo.APPLIED_FROM_TRX_ID = p_APPLIED_FROM_TRX_ID) OR
1924 ((Recinfo.APPLIED_FROM_TRX_ID IS NULL) AND
1925 (p_APPLIED_FROM_TRX_ID IS NULL))) AND
1926 ((Recinfo.APPLIED_FROM_TRX_LEVEL_TYPE = p_APPLIED_FROM_TRX_LEVEL_TYPE) OR
1927 ((Recinfo.APPLIED_FROM_TRX_LEVEL_TYPE IS NULL) AND
1928 (p_APPLIED_FROM_TRX_LEVEL_TYPE IS NULL))) AND
1929 ((Recinfo.APPLIED_FROM_LINE_ID = p_APPLIED_FROM_LINE_ID) OR
1930 ((Recinfo.APPLIED_FROM_LINE_ID IS NULL) AND
1931 (p_APPLIED_FROM_LINE_ID IS NULL))) AND
1932 ((Recinfo.APPLIED_FROM_TRX_NUMBER = p_APPLIED_FROM_TRX_NUMBER) OR
1933 ((Recinfo.APPLIED_FROM_TRX_NUMBER IS NULL) AND
1934 (p_APPLIED_FROM_TRX_NUMBER IS NULL))) AND
1935 ((Recinfo.ADJUSTED_DOC_APPLICATION_ID = P_ADJUSTED_DOC_APPLN_ID) OR
1936 ((Recinfo.ADJUSTED_DOC_APPLICATION_ID IS NULL) AND
1937 (P_ADJUSTED_DOC_APPLN_ID IS NULL))) AND
1938 ((Recinfo.ADJUSTED_DOC_ENTITY_CODE = p_ADJUSTED_DOC_ENTITY_CODE) OR
1939 ((Recinfo.ADJUSTED_DOC_ENTITY_CODE IS NULL) AND
1940 (p_ADJUSTED_DOC_ENTITY_CODE IS NULL))) AND
1941 ((Recinfo.ADJUSTED_DOC_EVENT_CLASS_CODE = P_ADJUSTED_DOC_EVT_CLSS_CODE) OR
1942 ((Recinfo.ADJUSTED_DOC_EVENT_CLASS_CODE IS NULL) AND
1943 (P_ADJUSTED_DOC_EVT_CLSS_CODE IS NULL))) AND
1944 ((Recinfo.ADJUSTED_DOC_TRX_ID = p_ADJUSTED_DOC_TRX_ID) OR
1945 ((Recinfo.ADJUSTED_DOC_TRX_ID IS NULL) AND
1946 (p_ADJUSTED_DOC_TRX_ID IS NULL))) AND
1947 ((Recinfo.ADJUSTED_DOC_TRX_LEVEL_TYPE = p_ADJUSTED_DOC_TRX_LEVEL_TYPE) OR
1948 ((Recinfo.ADJUSTED_DOC_TRX_LEVEL_TYPE IS NULL) AND
1949 (p_ADJUSTED_DOC_TRX_LEVEL_TYPE IS NULL))) AND
1950 ((Recinfo.ADJUSTED_DOC_LINE_ID = p_ADJUSTED_DOC_LINE_ID) OR
1951 ((Recinfo.ADJUSTED_DOC_LINE_ID IS NULL) AND
1952 (p_ADJUSTED_DOC_LINE_ID IS NULL))) AND
1953 ((Recinfo.ADJUSTED_DOC_NUMBER = p_ADJUSTED_DOC_NUMBER) OR
1954 ((Recinfo.ADJUSTED_DOC_NUMBER IS NULL) AND
1955 (p_ADJUSTED_DOC_NUMBER IS NULL))) AND
1956 ((Recinfo.ADJUSTED_DOC_DATE = p_ADJUSTED_DOC_DATE) OR
1957 ((Recinfo.ADJUSTED_DOC_DATE IS NULL) AND
1958 (p_ADJUSTED_DOC_DATE IS NULL))) AND
1959 ((Recinfo.APPLIED_TO_APPLICATION_ID = p_APPLIED_TO_APPLICATION_ID) OR
1960 ((Recinfo.APPLIED_TO_APPLICATION_ID IS NULL) AND
1961 (p_APPLIED_TO_APPLICATION_ID IS NULL))) AND
1962 ((Recinfo.APPLIED_TO_EVENT_CLASS_CODE = P_APPLIED_TO_EVT_CLASS_CODE) OR
1963 ((Recinfo.APPLIED_TO_EVENT_CLASS_CODE IS NULL) AND
1964 (P_APPLIED_TO_EVT_CLASS_CODE IS NULL))) AND
1965 ((Recinfo.APPLIED_TO_ENTITY_CODE = p_APPLIED_TO_ENTITY_CODE) OR
1966 ((Recinfo.APPLIED_TO_ENTITY_CODE IS NULL) AND
1967 (p_APPLIED_TO_ENTITY_CODE IS NULL))) AND
1968 ((Recinfo.APPLIED_TO_TRX_ID = p_APPLIED_TO_TRX_ID) OR
1969 ((Recinfo.APPLIED_TO_TRX_ID IS NULL) AND
1970 (p_APPLIED_TO_TRX_ID IS NULL))) AND
1971 ((Recinfo.APPLIED_TO_TRX_LEVEL_TYPE = p_APPLIED_TO_TRX_LEVEL_TYPE) OR
1972 ((Recinfo.APPLIED_TO_TRX_LEVEL_TYPE IS NULL) AND
1973 (p_APPLIED_TO_TRX_LEVEL_TYPE IS NULL))) AND
1974 ((Recinfo.APPLIED_TO_LINE_ID = p_applied_to_line_id) OR
1975 ((Recinfo.APPLIED_TO_LINE_ID IS NULL) AND
1976 (p_applied_to_line_id IS NULL))) AND
1977 ((Recinfo.SUMMARY_TAX_LINE_ID = p_SUMMARY_TAX_LINE_ID) OR
1978 ((Recinfo.SUMMARY_TAX_LINE_ID IS NULL) AND
1979 (p_SUMMARY_TAX_LINE_ID IS NULL))) AND
1980 ((Recinfo.OFFSET_LINK_TO_TAX_LINE_ID = p_OFFSET_LINK_TO_TAX_LINE_ID) OR
1981 ((Recinfo.OFFSET_LINK_TO_TAX_LINE_ID IS NULL) AND
1982 (p_OFFSET_LINK_TO_TAX_LINE_ID IS NULL))) AND
1983 (nvl(Recinfo.OFFSET_FLAG,'N') = NVL(p_offset_flag, 'N')) AND
1984 (nvl(Recinfo.PROCESS_FOR_RECOVERY_FLAG,'N') = NVL(p_process_for_recovery_flag, 'N')) AND
1985 ((Recinfo.TAX_JURISDICTION_ID = p_tax_jurisdiction_id) OR
1986 ((Recinfo.TAX_JURISDICTION_ID IS NULL) AND
1987 (p_tax_jurisdiction_id IS NULL))) AND
1988 ((Recinfo.TAX_JURISDICTION_CODE = p_tax_jurisdiction_code) OR
1989 ((Recinfo.TAX_JURISDICTION_CODE IS NULL) AND
1990 (p_tax_jurisdiction_code IS NULL))) AND
1991 ((Recinfo.PLACE_OF_SUPPLY = p_PLACE_OF_SUPPLY) OR
1992 ((Recinfo.PLACE_OF_SUPPLY IS NULL) AND
1993 (p_PLACE_OF_SUPPLY IS NULL))) AND
1994 ((Recinfo.PLACE_OF_SUPPLY_TYPE_CODE = p_Place_Of_Supply_Type_Code) OR
1995 ((Recinfo.PLACE_OF_SUPPLY_TYPE_CODE IS NULL) AND
1996 (p_place_of_supply_type_code IS NULL))) AND
1997 ((Recinfo.PLACE_OF_SUPPLY_RESULT_ID = p_PLACE_OF_SUPPLY_RESULT_ID) OR
1998 ((Recinfo.PLACE_OF_SUPPLY_RESULT_ID IS NULL) AND
1999 (p_place_of_supply_result_id IS NULL))) AND
2000 ((Recinfo.TAX_DATE_RULE_ID = p_TAX_DATE_RULE_ID) OR
2001 ((Recinfo.TAX_DATE_RULE_ID IS NULL) AND
2002 (p_TAX_DATE_RULE_ID IS NULL))) AND
2003 ((Recinfo.TAX_DATE = p_TAX_DATE) OR
2004 ((Recinfo.TAX_DATE IS NULL) AND
2005 (p_TAX_DATE IS NULL))) AND
2006 ((Recinfo.TAX_DETERMINE_DATE = p_tax_determine_date) OR
2007 ((Recinfo.TAX_DETERMINE_DATE IS NULL) AND
2008 (p_tax_determine_date IS NULL))) AND
2009 ((Recinfo.TAX_POINT_DATE = p_TAX_POINT_DATE) OR
2010 ((Recinfo.TAX_POINT_DATE IS NULL) AND
2011 (p_TAX_POINT_DATE IS NULL))) AND
2012 ((Recinfo.TRX_LINE_DATE = p_TRX_LINE_DATE) OR
2013 ((Recinfo.TRX_LINE_DATE IS NULL) AND
2014 (p_TRX_LINE_DATE IS NULL))) AND
2015 ((Recinfo.TAX_TYPE_CODE = p_TAX_TYPE_CODE) OR
2016 ((Recinfo.TAX_TYPE_CODE IS NULL) AND
2017 (p_TAX_TYPE_CODE IS NULL))) AND
2018 ((Recinfo.TAX_CODE = p_TAX_CODE) OR
2019 ((Recinfo.TAX_CODE IS NULL) AND
2020 (p_TAX_CODE IS NULL))) AND
2021 ((Recinfo.TAX_REGISTRATION_ID = p_tax_registration_id) OR
2022 ((Recinfo.TAX_REGISTRATION_ID IS NULL) AND
2023 (p_tax_registration_id IS NULL))) AND
2024 ((Recinfo.TAX_REGISTRATION_NUMBER = p_tax_registration_number) OR
2025 ((Recinfo.TAX_REGISTRATION_NUMBER IS NULL) AND
2026 (p_tax_registration_number IS NULL))) AND
2027 ((Recinfo.REGISTRATION_PARTY_TYPE = p_REGISTRATION_PARTY_TYPE) OR
2028 ((Recinfo.REGISTRATION_PARTY_TYPE IS NULL) AND
2029 (p_REGISTRATION_PARTY_TYPE IS NULL))) AND
2030 ((Recinfo.ROUNDING_LEVEL_CODE = p_Rounding_Level_Code) OR
2031 ((Recinfo.ROUNDING_LEVEL_CODE IS NULL) AND
2032 (p_Rounding_Level_Code IS NULL))) AND
2033 ((Recinfo.ROUNDING_RULE_CODE = p_Rounding_Rule_Code) OR
2034 ((Recinfo.ROUNDING_RULE_CODE IS NULL) AND
2035 (p_Rounding_Rule_Code IS NULL))) AND
2036 ((Recinfo.ROUNDING_LVL_PARTY_TAX_PROF_ID = P_RNDG_LVL_PARTY_TAX_PROF_ID) OR
2037 ((Recinfo.ROUNDING_LVL_PARTY_TAX_PROF_ID IS NULL) AND
2038 (P_RNDG_LVL_PARTY_TAX_PROF_ID IS NULL))) AND
2039 ((Recinfo.ROUNDING_LVL_PARTY_TYPE = p_ROUNDING_LVL_PARTY_TYPE) OR
2040 ((Recinfo.ROUNDING_LVL_PARTY_TYPE IS NULL) AND
2041 (p_ROUNDING_LVL_PARTY_TYPE IS NULL))) AND
2042 (nvl(Recinfo.COMPOUNDING_TAX_FLAG,'N') = NVL(p_Compounding_Tax_Flag, 'N')) AND
2043 ((Recinfo.ORIG_TAX_STATUS_ID = p_orig_tax_status_id) OR
2044 ((Recinfo.ORIG_TAX_STATUS_ID IS NULL) AND
2045 (p_orig_tax_status_id IS NULL))) AND
2046 ((Recinfo.ORIG_TAX_STATUS_CODE = p_orig_tax_status_code) OR
2047 ((Recinfo.ORIG_TAX_STATUS_CODE IS NULL) AND
2048 (p_orig_tax_status_code IS NULL))) AND
2049 ((Recinfo.ORIG_TAX_RATE_ID = p_orig_tax_rate_id) OR
2050 ((Recinfo.ORIG_TAX_RATE_ID IS NULL) AND
2051 (p_orig_tax_rate_id IS NULL))) AND
2052 ((Recinfo.ORIG_TAX_RATE_CODE = p_orig_tax_rate_code) OR
2053 ((Recinfo.ORIG_TAX_RATE_CODE IS NULL) AND
2054 (p_orig_tax_rate_code IS NULL))) AND
2055 ((Recinfo.ORIG_TAX_RATE = p_orig_tax_rate) OR
2056 ((Recinfo.ORIG_TAX_RATE IS NULL) AND
2057 (p_orig_tax_rate IS NULL))) AND
2058 ((Recinfo.ORIG_TAX_JURISDICTION_ID = p_orig_tax_jurisdiction_id) OR
2059 ((Recinfo.ORIG_TAX_JURISDICTION_ID IS NULL) AND
2060 (p_orig_tax_jurisdiction_id IS NULL))) AND
2061 ((Recinfo.ORIG_TAX_JURISDICTION_CODE = p_orig_tax_jurisdiction_code) OR
2062 ((Recinfo.ORIG_TAX_JURISDICTION_CODE IS NULL) AND
2063 (p_orig_tax_jurisdiction_code IS NULL))) AND
2064 ((Recinfo.ORIG_TAX_AMT_INCLUDED_FLAG = p_orig_tax_amt_included_flag) OR
2065 ((Recinfo.ORIG_TAX_AMT_INCLUDED_FLAG IS NULL) AND
2066 (p_orig_tax_amt_included_flag IS NULL))) AND
2067 ((Recinfo.ORIG_SELF_ASSESSED_FLAG = p_orig_self_assessed_flag) OR
2068 ((Recinfo.ORIG_SELF_ASSESSED_FLAG IS NULL) AND
2069 (p_orig_self_assessed_flag IS NULL))) AND
2070 ((Recinfo.TAX_CURRENCY_CODE = p_TAX_CURRENCY_CODE) OR
2071 ((Recinfo.TAX_CURRENCY_CODE IS NULL) AND
2072 (p_TAX_CURRENCY_CODE IS NULL))) AND
2073 ((Recinfo.TAX_AMT = p_tax_amt) OR
2074 ((Recinfo.TAX_AMT IS NULL) AND
2075 (p_tax_amt IS NULL))) AND
2076 ((Recinfo.TAX_AMT_TAX_CURR = p_TAX_AMT_TAX_CURR) OR
2077 ((Recinfo.TAX_AMT_TAX_CURR IS NULL) AND
2078 (p_TAX_AMT_TAX_CURR IS NULL))) AND
2079 ((Recinfo.TAX_AMT_FUNCL_CURR = p_TAX_AMT_FUNCL_CURR) OR
2080 ((Recinfo.TAX_AMT_FUNCL_CURR IS NULL) AND
2081 (p_TAX_AMT_FUNCL_CURR IS NULL))) AND -- 99
2082 ((Recinfo.TAXABLE_AMT = p_taxable_amt) OR
2083 ((Recinfo.TAXABLE_AMT IS NULL) AND
2084 (p_taxable_amt IS NULL))) AND
2085 ((Recinfo.TAXABLE_AMT_TAX_CURR = p_TAXABLE_AMT_TAX_CURR) OR
2086 ((Recinfo.TAXABLE_AMT_TAX_CURR IS NULL) AND
2087 (p_TAXABLE_AMT_TAX_CURR IS NULL))) AND
2088 ((Recinfo.TAXABLE_AMT_FUNCL_CURR = p_TAXABLE_AMT_FUNCL_CURR) OR
2089 ((Recinfo.TAXABLE_AMT_FUNCL_CURR IS NULL) AND
2090 (p_TAXABLE_AMT_FUNCL_CURR IS NULL))) AND
2091 ((Recinfo.ORIG_TAXABLE_AMT = p_orig_taxable_amt) OR
2092 ((Recinfo.ORIG_TAXABLE_AMT IS NULL) AND
2093 (p_orig_taxable_amt IS NULL))) AND
2094 ((Recinfo.ORIG_TAXABLE_AMT_TAX_CURR = p_ORIG_TAXABLE_AMT_TAX_CURR) OR
2095 ((Recinfo.ORIG_TAXABLE_AMT_TAX_CURR IS NULL) AND
2096 (p_ORIG_TAXABLE_AMT_TAX_CURR IS NULL))) AND
2097 ((Recinfo.CAL_TAX_AMT = p_CAL_TAX_AMT) OR
2098 ((Recinfo.CAL_TAX_AMT IS NULL) AND
2099 (p_CAL_TAX_AMT IS NULL))) AND
2100 ((Recinfo.CAL_TAX_AMT_TAX_CURR = p_CAL_TAX_AMT_TAX_CURR) OR
2101 ((Recinfo.CAL_TAX_AMT_TAX_CURR IS NULL) AND
2102 (p_CAL_TAX_AMT_TAX_CURR IS NULL))) AND
2103 ((Recinfo.CAL_TAX_AMT_FUNCL_CURR = p_CAL_TAX_AMT_FUNCL_CURR) OR
2104 ((Recinfo.CAL_TAX_AMT_FUNCL_CURR IS NULL) AND
2105 (p_CAL_TAX_AMT_FUNCL_CURR IS NULL))) AND
2106 ((Recinfo.ORIG_TAX_AMT = p_ORIG_TAX_AMT) OR
2107 ((Recinfo.ORIG_TAX_AMT IS NULL) AND
2108 (p_ORIG_TAX_AMT IS NULL))) AND
2109 ((Recinfo.ORIG_TAX_AMT_TAX_CURR = p_ORIG_TAX_AMT_TAX_CURR) OR
2110 ((Recinfo.ORIG_TAX_AMT_TAX_CURR IS NULL) AND
2111 (p_ORIG_TAX_AMT_TAX_CURR IS NULL))) AND
2112 ((Recinfo.REC_TAX_AMT = p_rec_tax_amt) OR
2113 ((Recinfo.REC_TAX_AMT IS NULL) AND
2114 (p_rec_tax_amt IS NULL))) AND
2115 ((Recinfo.REC_TAX_AMT_TAX_CURR = p_REC_TAX_AMT_TAX_CURR) OR
2116 ((Recinfo.REC_TAX_AMT_TAX_CURR IS NULL) AND
2117 (p_REC_TAX_AMT_TAX_CURR IS NULL))) AND
2118 ((Recinfo.REC_TAX_AMT_FUNCL_CURR = p_REC_TAX_AMT_FUNCL_CURR) OR
2119 ((Recinfo.REC_TAX_AMT_FUNCL_CURR IS NULL) AND
2120 (p_REC_TAX_AMT_FUNCL_CURR IS NULL))) AND
2121 ((Recinfo.NREC_TAX_AMT = p_nrec_tax_amt) OR
2122 ((Recinfo.NREC_TAX_AMT IS NULL) AND
2123 (p_nrec_tax_amt IS NULL))) AND
2124 ((Recinfo.NREC_TAX_AMT_TAX_CURR = p_NREC_TAX_AMT_TAX_CURR) OR
2125 ((Recinfo.NREC_TAX_AMT_TAX_CURR IS NULL) AND
2126 (p_NREC_TAX_AMT_TAX_CURR IS NULL))) AND
2127 ((Recinfo.NREC_TAX_AMT_FUNCL_CURR = p_NREC_TAX_AMT_FUNCL_CURR) OR
2128 ((Recinfo.NREC_TAX_AMT_FUNCL_CURR IS NULL) AND
2129 (p_NREC_TAX_AMT_FUNCL_CURR IS NULL))) AND --99
2130 ((Recinfo.TAX_EXEMPTION_ID = p_tax_exemption_id) OR
2131 ((Recinfo.TAX_EXEMPTION_ID IS NULL) AND
2132 (p_tax_exemption_id IS NULL))) AND
2133 ((Recinfo.TAX_RATE_BEFORE_EXEMPTION = p_tax_rate_before_exemption ) OR
2134 ((Recinfo.TAX_RATE_BEFORE_EXEMPTION IS NULL) AND
2135 (p_tax_rate_before_exemption IS NULL))) AND
2136 ((Recinfo.TAX_RATE_NAME_BEFORE_EXEMPTION = p_tax_rate_name_before_exempt) OR
2137 ((Recinfo.TAX_RATE_NAME_BEFORE_EXEMPTION IS NULL) AND
2138 (p_tax_rate_name_before_exempt IS NULL))) AND
2139 ((Recinfo.EXEMPT_RATE_MODIFIER = p_exempt_rate_modifier) OR
2140 ((Recinfo.EXEMPT_RATE_MODIFIER IS NULL) AND
2141 (p_exempt_rate_modifier IS NULL))) AND
2142 ((Recinfo.EXEMPT_CERTIFICATE_NUMBER = p_exempt_certificate_number) OR
2143 ((Recinfo.EXEMPT_CERTIFICATE_NUMBER IS NULL) AND
2144 (p_exempt_certificate_number IS NULL))) AND
2145 ((Recinfo.EXEMPT_REASON = p_exempt_reason) OR
2146 ((Recinfo.EXEMPT_REASON IS NULL) AND
2147 (p_exempt_reason IS NULL))) AND
2148 ((Recinfo.EXEMPT_REASON_CODE = p_exempt_reason_code) OR
2149 ((Recinfo.EXEMPT_REASON_CODE IS NULL) AND
2150 (p_exempt_reason_code IS NULL))) AND
2151 ((Recinfo.TAX_EXCEPTION_ID = p_tax_exception_id) OR
2152 ((Recinfo.TAX_EXCEPTION_ID IS NULL) AND
2153 (p_tax_exception_id IS NULL))) AND
2154 ((Recinfo.TAX_RATE_BEFORE_EXCEPTION = p_tax_rate_before_exception) OR
2155 ((Recinfo.TAX_RATE_BEFORE_EXCEPTION IS NULL) AND
2156 (p_tax_rate_before_exception IS NULL))) AND
2157 ((Recinfo.TAX_RATE_NAME_BEFORE_EXCEPTION = p_tax_rate_name_before_except) OR
2158 ((Recinfo.TAX_RATE_NAME_BEFORE_EXCEPTION IS NULL) AND
2159 (p_tax_rate_name_before_except IS NULL))) AND
2160 ((Recinfo.EXCEPTION_RATE = p_exception_rate) OR
2161 ((Recinfo.EXCEPTION_RATE IS NULL) AND
2162 (p_exception_rate IS NULL))) AND
2163 ((Recinfo.TAX_APPORTIONMENT_FLAG = p_tax_apportionment_flag) OR
2164 ((Recinfo.TAX_APPORTIONMENT_FLAG IS NULL) AND
2165 (p_tax_apportionment_flag IS NULL))) AND
2166 (nvl(Recinfo.HISTORICAL_FLAG,'N') = NVL(p_historical_flag, 'N')) AND
2167 ((Recinfo.TAXABLE_BASIS_FORMULA = p_taxable_basis_formula) OR
2168 ((Recinfo.TAXABLE_BASIS_FORMULA IS NULL) AND
2169 (p_taxable_basis_formula IS NULL))) AND
2170 ((Recinfo.TAX_CALCULATION_FORMULA = p_tax_calculation_formula) OR
2171 ((Recinfo.TAX_CALCULATION_FORMULA IS NULL) AND
2172 (p_tax_calculation_formula IS NULL))) AND
2173 (nvl(Recinfo.CANCEL_FLAG,'N') = NVL(p_cancel_flag, 'N')) AND
2174 (nvl(Recinfo.PURGE_FLAG,'N') = NVL(p_Purge_Flag, 'N')) AND
2175 (nvl(Recinfo.DELETE_FLAG,'N') = NVL(p_delete_flag, 'N')) AND
2176 (nvl(Recinfo.TAX_AMT_INCLUDED_FLAG,'N') = NVL(p_tax_amt_included_flag, 'N')) AND
2177 (nvl(Recinfo.SELF_ASSESSED_FLAG,'N') = NVL(p_self_assessed_flag, 'N')) AND
2178 (nvl(Recinfo.OVERRIDDEN_FLAG,'N') = NVL(p_overridden_flag, 'N')) AND
2179 (nvl(Recinfo.MANUALLY_ENTERED_FLAG,'N') = NVL(p_manually_entered_flag, 'N')) AND
2180 (nvl(Recinfo.REPORTING_ONLY_FLAG,'N') = NVL(p_reporting_only_flag, 'N')) AND
2181 (nvl(Recinfo.FREEZE_UNTIL_OVERRIDDEN_FLAG,'N') = NVL(p_freeze_until_overriddn_flg, 'N')) AND
2182 (nvl(Recinfo.COPIED_FROM_OTHER_DOC_FLAG,'N') = NVL(p_copied_from_other_doc_flag, 'N')) AND
2183 (nvl(Recinfo.RECALC_REQUIRED_FLAG,'N') = NVL(p_recalc_required_flag, 'N')) AND
2184 ((Recinfo.SETTLEMENT_FLAG = p_settlement_flag) OR
2185 ((Recinfo.SETTLEMENT_FLAG IS NULL) AND
2186 (p_settlement_flag IS NULL))) AND --99
2187 (nvl(Recinfo.ITEM_DIST_CHANGED_FLAG,'N') = NVL(p_item_dist_changed_flag, 'N')) AND
2188 (nvl(Recinfo.ASSOCIATED_CHILD_FROZEN_FLAG,'N') = NVL(p_assoc_children_frozen_flg, 'N')) AND
2189 (nvl(Recinfo.TAX_ONLY_LINE_FLAG,'N') = NVL(p_tax_only_line_flag, 'N')) AND
2190 (nvl(Recinfo.COMPOUNDING_DEP_TAX_FLAG,'N') = NVL(p_compounding_dep_tax_flag, 'N')) AND
2191 (nvl(Recinfo.COMPOUNDING_TAX_MISS_FLAG,'N') = NVL(p_compounding_tax_miss_flag, 'N')) AND
2192 ((Recinfo.SYNC_WITH_PRVDR_FLAG = p_sync_with_prvdr_flag) OR
2193 ((Recinfo.SYNC_WITH_PRVDR_FLAG IS NULL) AND
2194 (p_sync_with_prvdr_flag IS NULL))) AND --99
2195 ((Recinfo.LAST_MANUAL_ENTRY = p_last_manual_entry) OR
2196 ((Recinfo.LAST_MANUAL_ENTRY IS NULL) AND
2197 (p_last_manual_entry IS NULL))) AND
2198 ((Recinfo.TAX_PROVIDER_ID = p_tax_provider_id) OR
2199 ((Recinfo.TAX_PROVIDER_ID IS NULL) AND
2200 (p_tax_provider_id IS NULL))) AND --99
2201 ((Recinfo.record_type_code = p_record_type_code) OR
2202 ((Recinfo.record_type_code IS NULL) AND
2203 (p_record_type_code IS NULL))) AND
2204 ((Recinfo.REPORTING_PERIOD_ID = p_REPORTING_PERIOD_ID) OR
2205 ((Recinfo.REPORTING_PERIOD_ID IS NULL) AND
2206 (p_REPORTING_PERIOD_ID IS NULL))) AND
2207 ((Recinfo.LEGAL_JUSTIFICATION_TEXT1 = p_LEGAL_JUSTIFICATION_TEXT1) OR
2208 ((Recinfo.LEGAL_JUSTIFICATION_TEXT1 IS NULL) AND
2209 (p_LEGAL_JUSTIFICATION_TEXT1 IS NULL))) AND
2210 ((Recinfo.LEGAL_JUSTIFICATION_TEXT2 = p_LEGAL_JUSTIFICATION_TEXT2) OR
2211 ((Recinfo.LEGAL_JUSTIFICATION_TEXT2 IS NULL) AND
2212 (p_LEGAL_JUSTIFICATION_TEXT2 IS NULL))) AND
2213 ((Recinfo.LEGAL_JUSTIFICATION_TEXT3 = p_LEGAL_JUSTIFICATION_TEXT3) OR
2214 ((Recinfo.LEGAL_JUSTIFICATION_TEXT3 IS NULL) AND
2215 (p_LEGAL_JUSTIFICATION_TEXT3 IS NULL))) AND
2216 ((Recinfo.LEGAL_MESSAGE_APPL_2 = p_LEGAL_MESSAGE_APPL_2) OR
2217 ((Recinfo.LEGAL_MESSAGE_APPL_2 IS NULL) AND
2218 (p_LEGAL_MESSAGE_APPL_2 IS NULL))) AND
2219 ((Recinfo.LEGAL_MESSAGE_STATUS = p_legal_message_status) OR
2220 ((Recinfo.LEGAL_MESSAGE_STATUS IS NULL) AND
2221 (p_legal_message_status IS NULL))) AND
2222 ((Recinfo.LEGAL_MESSAGE_RATE = p_legal_message_rate) OR
2223 ((Recinfo.LEGAL_MESSAGE_RATE IS NULL) AND
2224 (p_legal_message_rate IS NULL))) AND
2225 ((Recinfo.LEGAL_MESSAGE_BASIS = p_legal_message_basis) OR
2226 ((Recinfo.LEGAL_MESSAGE_BASIS IS NULL) AND
2227 (p_legal_message_basis IS NULL))) AND
2228 ((Recinfo.LEGAL_MESSAGE_CALC = p_LEGAL_MESSAGE_CALC) OR
2229 ((Recinfo.LEGAL_MESSAGE_CALC IS NULL) AND
2230 (p_LEGAL_MESSAGE_CALC IS NULL))) AND
2231 ((Recinfo.LEGAL_MESSAGE_THRESHOLD = p_LEGAL_MESSAGE_THRESHOLD) OR
2232 ((Recinfo.LEGAL_MESSAGE_THRESHOLD IS NULL) AND
2233 (p_LEGAL_MESSAGE_THRESHOLD IS NULL))) AND
2234 ((Recinfo.LEGAL_MESSAGE_POS = p_LEGAL_MESSAGE_POS) OR
2235 ((Recinfo.LEGAL_MESSAGE_POS IS NULL) AND
2236 (p_LEGAL_MESSAGE_POS IS NULL))) AND
2237 ((Recinfo.LEGAL_MESSAGE_TRN = p_LEGAL_MESSAGE_TRN) OR
2238 ((Recinfo.LEGAL_MESSAGE_TRN IS NULL) AND
2239 (p_LEGAL_MESSAGE_TRN IS NULL))) AND
2240 ((Recinfo.LEGAL_MESSAGE_EXMPT = p_LEGAL_MESSAGE_EXMPT) OR
2241 ((Recinfo.LEGAL_MESSAGE_EXMPT IS NULL) AND
2242 (p_LEGAL_MESSAGE_EXMPT IS NULL))) AND
2243 ((Recinfo.LEGAL_MESSAGE_EXCPT = p_LEGAL_MESSAGE_EXCPT) OR
2244 ((Recinfo.LEGAL_MESSAGE_EXCPT IS NULL) AND
2245 (p_LEGAL_MESSAGE_EXCPT IS NULL))) AND
2246 ((Recinfo.TAX_REGIME_TEMPLATE_ID = p_TAX_REGIME_TEMPLATE_ID) OR
2247 ((Recinfo.TAX_REGIME_TEMPLATE_ID IS NULL) AND
2248 (p_TAX_REGIME_TEMPLATE_ID IS NULL))) AND
2249 ((Recinfo.TAX_APPLICABILITY_RESULT_ID = P_TAX_APPLICABILITY_RESULT_ID) OR
2250 ((Recinfo.TAX_APPLICABILITY_RESULT_ID IS NULL) AND
2251 (P_TAX_APPLICABILITY_RESULT_ID IS NULL))) AND
2252 ((Recinfo.DIRECT_RATE_RESULT_ID = p_DIRECT_RATE_RESULT_ID) OR
2253 ((Recinfo.DIRECT_RATE_RESULT_ID IS NULL) AND
2254 (p_DIRECT_RATE_RESULT_ID IS NULL))) AND
2255 ((Recinfo.STATUS_RESULT_ID = p_STATUS_RESULT_ID) OR
2256 ((Recinfo.STATUS_RESULT_ID IS NULL) AND
2257 (p_STATUS_RESULT_ID IS NULL))) AND
2258 ((Recinfo.RATE_RESULT_ID = p_RATE_RESULT_ID) OR
2259 ((Recinfo.RATE_RESULT_ID IS NULL) AND
2260 (p_RATE_RESULT_ID IS NULL))) AND
2261 ((Recinfo.BASIS_RESULT_ID = p_BASIS_RESULT_ID) OR
2262 ((Recinfo.BASIS_RESULT_ID IS NULL) AND
2263 (p_BASIS_RESULT_ID IS NULL))) AND
2264 ((Recinfo.THRESH_RESULT_ID = p_THRESH_RESULT_ID) OR
2265 ((Recinfo.THRESH_RESULT_ID IS NULL) AND
2266 (p_THRESH_RESULT_ID IS NULL))) AND
2267 ((Recinfo.CALC_RESULT_ID = p_CALC_RESULT_ID) OR
2268 ((Recinfo.CALC_RESULT_ID IS NULL) AND
2269 (p_CALC_RESULT_ID IS NULL))) AND
2270 ((Recinfo.TAX_REG_NUM_DET_RESULT_ID = p_TAX_REG_NUM_DET_RESULT_ID) OR
2271 ((Recinfo.TAX_REG_NUM_DET_RESULT_ID IS NULL) AND
2272 (p_TAX_REG_NUM_DET_RESULT_ID IS NULL))) AND
2273 ((Recinfo.EVAL_EXMPT_RESULT_ID = p_EVAL_EXMPT_RESULT_ID) OR
2274 ((Recinfo.EVAL_EXMPT_RESULT_ID IS NULL) AND
2275 (p_EVAL_EXMPT_RESULT_ID IS NULL))) AND
2276 ((Recinfo.EVAL_EXCPT_RESULT_ID = p_EVAL_EXCPT_RESULT_ID) OR
2277 ((Recinfo.EVAL_EXCPT_RESULT_ID IS NULL) AND
2278 (p_EVAL_EXCPT_RESULT_ID IS NULL))) AND
2279 (nvl(Recinfo.Enforce_From_Natural_Acct_Flag,'N') = NVL(p_enforced_from_nat_acct_flg, 'N')) AND
2280 ((Recinfo.TAX_HOLD_CODE = p_TAX_HOLD_CODE) OR
2281 ((Recinfo.TAX_HOLD_CODE IS NULL) AND
2282 (p_tax_hold_code IS NULL))) AND
2283 ((Recinfo.TAX_HOLD_RELEASED_CODE = p_tax_hold_released_code) OR
2284 ((Recinfo.TAX_HOLD_RELEASED_CODE IS NULL) AND
2285 (p_tax_hold_released_code IS NULL))) AND
2286 ((Recinfo.PRD_TOTAL_TAX_AMT = p_prd_total_tax_amt) OR
2287 ((Recinfo.PRD_TOTAL_TAX_AMT IS NULL) AND
2288 (p_prd_total_tax_amt IS NULL))) AND
2289 ((Recinfo.PRD_TOTAL_TAX_AMT_TAX_CURR = p_prd_total_tax_amt_tax_curr) OR
2290 ((Recinfo.PRD_TOTAL_TAX_AMT_TAX_CURR IS NULL) AND
2291 (p_prd_total_tax_amt_tax_curr IS NULL))) AND
2292 ((Recinfo.PRD_TOTAL_TAX_AMT_FUNCL_CURR = p_prd_total_tax_amt_funcl_curr) OR
2293 ((Recinfo.PRD_TOTAL_TAX_AMT_FUNCL_CURR IS NULL) AND
2294 (p_prd_total_tax_amt_funcl_curr IS NULL))) AND
2295 ((Recinfo.TRX_LINE_INDEX = p_TRX_LINE_INDEX) OR
2296 ((Recinfo.TRX_LINE_INDEX IS NULL) AND
2297 (p_TRX_LINE_INDEX IS NULL))) AND
2298 ((Recinfo.OFFSET_TAX_RATE_CODE = p_OFFSET_TAX_RATE_CODE) OR
2299 ((Recinfo.OFFSET_TAX_RATE_CODE IS NULL) AND
2300 (p_OFFSET_TAX_RATE_CODE IS NULL))) AND
2301 ((Recinfo.PRORATION_CODE = p_PRORATION_CODE) OR
2302 ((Recinfo.PRORATION_CODE IS NULL) AND
2303 (p_PRORATION_CODE IS NULL))) AND
2304 ((Recinfo.OTHER_DOC_SOURCE = p_OTHER_DOC_SOURCE) OR
2305 ((Recinfo.OTHER_DOC_SOURCE IS NULL) AND
2306 (p_OTHER_DOC_SOURCE IS NULL))) AND
2307 ((Recinfo.INTERNAL_ORG_LOCATION_ID = p_INTERNAL_ORG_LOCATION_ID) OR
2308 ((Recinfo.INTERNAL_ORG_LOCATION_ID IS NULL) AND
2309 (p_INTERNAL_ORG_LOCATION_ID IS NULL))) AND
2310 ((Recinfo.LINE_ASSESSABLE_VALUE = p_LINE_ASSESSABLE_VALUE) OR
2311 ((Recinfo.LINE_ASSESSABLE_VALUE IS NULL) AND
2312 (p_LINE_ASSESSABLE_VALUE IS NULL))) AND
2313 ((Recinfo.CTRL_TOTAL_LINE_TX_AMT = p_ctrl_total_line_tx_amt) OR
2314 ((Recinfo.CTRL_TOTAL_LINE_TX_AMT IS NULL) AND
2315 (p_ctrl_total_line_tx_amt IS NULL))) AND
2316 ((Recinfo.APPLIED_TO_TRX_NUMBER = p_applied_to_trx_number) OR
2317 ((Recinfo.APPLIED_TO_TRX_NUMBER IS NULL) AND
2318 (p_applied_to_trx_number IS NULL))) AND
2319 ((Recinfo.ATTRIBUTE_CATEGORY = p_attribute_category) OR
2320 ((Recinfo.ATTRIBUTE_CATEGORY IS NULL) AND
2321 (p_attribute_category IS NULL))) AND
2322 ((Recinfo.ATTRIBUTE1 = p_attribute1) OR
2323 ((Recinfo.ATTRIBUTE1 IS NULL) AND
2324 (p_attribute1 IS NULL))) AND
2325 ((Recinfo.ATTRIBUTE2 = p_attribute2) OR
2326 ((Recinfo.ATTRIBUTE2 IS NULL) AND
2327 (p_attribute2 IS NULL))) AND
2328 ((Recinfo.ATTRIBUTE3 = p_attribute3) OR
2329 ((Recinfo.ATTRIBUTE3 IS NULL) AND
2330 (p_attribute3 IS NULL))) AND
2331 ((Recinfo.ATTRIBUTE4 = p_attribute4) OR
2332 ((Recinfo.ATTRIBUTE4 IS NULL) AND
2333 (p_attribute4 IS NULL))) AND
2334 ((Recinfo.ATTRIBUTE5 = p_attribute5) OR
2335 ((Recinfo.ATTRIBUTE5 IS NULL) AND
2336 (p_attribute5 IS NULL))) AND
2337 ((Recinfo.ATTRIBUTE6 = p_attribute6) OR
2338 ((Recinfo.ATTRIBUTE6 IS NULL) AND
2339 (p_attribute6 IS NULL))) AND
2340 ((Recinfo.ATTRIBUTE7 = p_attribute7) OR
2341 ((Recinfo.ATTRIBUTE7 IS NULL) AND
2342 (p_attribute7 IS NULL))) AND
2343 ((Recinfo.ATTRIBUTE8 = p_attribute8) OR
2344 ((Recinfo.ATTRIBUTE8 IS NULL) AND
2345 (p_attribute8 IS NULL))) AND
2346 ((Recinfo.ATTRIBUTE9 = p_attribute9) OR
2347 ((Recinfo.ATTRIBUTE9 IS NULL) AND
2348 (p_attribute9 IS NULL))) AND
2349 ((Recinfo.ATTRIBUTE10 = p_attribute10) OR
2350 ((Recinfo.ATTRIBUTE10 IS NULL) AND
2351 (p_attribute10 IS NULL))) AND
2352 ((Recinfo.ATTRIBUTE11 = p_attribute11) OR
2353 ((Recinfo.ATTRIBUTE11 IS NULL) AND
2354 (p_attribute11 IS NULL))) AND
2355 ((Recinfo.ATTRIBUTE12 = p_attribute12) OR
2356 ((Recinfo.ATTRIBUTE12 IS NULL) AND
2357 (p_attribute12 IS NULL))) AND
2358 ((Recinfo.ATTRIBUTE13 = p_attribute13) OR
2359 ((Recinfo.ATTRIBUTE13 IS NULL) AND
2360 (p_attribute13 IS NULL))) AND
2361 ((Recinfo.ATTRIBUTE14 = p_attribute14) OR
2362 ((Recinfo.ATTRIBUTE14 IS NULL) AND
2363 (p_attribute14 IS NULL))) AND
2364 ((Recinfo.ATTRIBUTE15 = p_attribute15) OR
2365 ((Recinfo.ATTRIBUTE15 IS NULL) AND
2366 (p_attribute15 IS NULL))) AND
2367 ((Recinfo.GLOBAL_ATTRIBUTE_CATEGORY = p_GLOBAL_ATTRIBUTE_category) OR
2368 ((Recinfo.GLOBAL_ATTRIBUTE_CATEGORY IS NULL) AND
2369 (p_GLOBAL_ATTRIBUTE_category IS NULL))) AND
2370 ((Recinfo.GLOBAL_ATTRIBUTE1 = p_GLOBAL_ATTRIBUTE1) OR
2371 ((Recinfo.GLOBAL_ATTRIBUTE1 IS NULL) AND
2372 (p_GLOBAL_ATTRIBUTE1 IS NULL))) AND
2373 ((Recinfo.GLOBAL_ATTRIBUTE2 = p_GLOBAL_ATTRIBUTE2) OR
2374 ((Recinfo.GLOBAL_ATTRIBUTE2 IS NULL) AND
2375 (p_GLOBAL_ATTRIBUTE2 IS NULL))) AND
2376 ((Recinfo.GLOBAL_ATTRIBUTE3 = p_GLOBAL_ATTRIBUTE3) OR
2377 ((Recinfo.GLOBAL_ATTRIBUTE3 IS NULL) AND
2378 (p_GLOBAL_ATTRIBUTE3 IS NULL))) AND
2379 ((Recinfo.GLOBAL_ATTRIBUTE4 = p_GLOBAL_ATTRIBUTE4) OR
2380 ((Recinfo.GLOBAL_ATTRIBUTE4 IS NULL) AND
2381 (p_GLOBAL_ATTRIBUTE4 IS NULL))) AND
2382 ((Recinfo.GLOBAL_ATTRIBUTE5 = p_GLOBAL_ATTRIBUTE5) OR
2383 ((Recinfo.GLOBAL_ATTRIBUTE5 IS NULL) AND
2384 (p_GLOBAL_ATTRIBUTE5 IS NULL))) AND
2385 ((Recinfo.GLOBAL_ATTRIBUTE6 = p_GLOBAL_ATTRIBUTE6) OR
2386 ((Recinfo.GLOBAL_ATTRIBUTE6 IS NULL) AND
2387 (p_GLOBAL_ATTRIBUTE6 IS NULL))) AND
2388 ((Recinfo.GLOBAL_ATTRIBUTE7 = p_GLOBAL_ATTRIBUTE7) OR
2389 ((Recinfo.GLOBAL_ATTRIBUTE7 IS NULL) AND
2390 (p_GLOBAL_ATTRIBUTE7 IS NULL))) AND
2391 ((Recinfo.GLOBAL_ATTRIBUTE8 = p_GLOBAL_ATTRIBUTE8) OR
2392 ((Recinfo.GLOBAL_ATTRIBUTE8 IS NULL) AND
2393 (p_GLOBAL_ATTRIBUTE8 IS NULL))) AND
2394 ((Recinfo.GLOBAL_ATTRIBUTE9 = p_GLOBAL_ATTRIBUTE9) OR
2395 ((Recinfo.GLOBAL_ATTRIBUTE9 IS NULL) AND
2396 (p_GLOBAL_ATTRIBUTE9 IS NULL))) AND
2397 ((Recinfo.GLOBAL_ATTRIBUTE10 = p_GLOBAL_ATTRIBUTE10) OR
2398 ((Recinfo.GLOBAL_ATTRIBUTE10 IS NULL) AND
2399 (p_GLOBAL_ATTRIBUTE10 IS NULL))) AND
2400 ((Recinfo.GLOBAL_ATTRIBUTE11 = p_GLOBAL_ATTRIBUTE11) OR
2401 ((Recinfo.GLOBAL_ATTRIBUTE11 IS NULL) AND
2402 (p_GLOBAL_ATTRIBUTE11 IS NULL))) AND
2403 ((Recinfo.GLOBAL_ATTRIBUTE12 = p_GLOBAL_ATTRIBUTE12) OR
2404 ((Recinfo.GLOBAL_ATTRIBUTE12 IS NULL) AND
2405 (p_GLOBAL_ATTRIBUTE12 IS NULL))) AND
2406 ((Recinfo.GLOBAL_ATTRIBUTE13 = p_GLOBAL_ATTRIBUTE13) OR
2407 ((Recinfo.GLOBAL_ATTRIBUTE13 IS NULL) AND
2408 (p_GLOBAL_ATTRIBUTE13 IS NULL))) AND
2409 ((Recinfo.GLOBAL_ATTRIBUTE14 = p_GLOBAL_ATTRIBUTE14) OR
2410 ((Recinfo.GLOBAL_ATTRIBUTE14 IS NULL) AND
2411 (p_GLOBAL_ATTRIBUTE14 IS NULL))) AND
2412 ((Recinfo.GLOBAL_ATTRIBUTE15 = p_GLOBAL_ATTRIBUTE15) OR
2413 ((Recinfo.GLOBAL_ATTRIBUTE15 IS NULL) AND
2414 (p_GLOBAL_ATTRIBUTE15 IS NULL))) AND
2415 ((Recinfo.NUMERIC1 = p_NUMERIC1) OR
2416 ((Recinfo.NUMERIC1 IS NULL) AND
2417 (p_NUMERIC1 IS NULL))) AND
2418 ((Recinfo.NUMERIC2 = p_NUMERIC2) OR
2419 ((Recinfo.NUMERIC2 IS NULL) AND
2420 (p_NUMERIC2 IS NULL))) AND
2421 ((Recinfo.NUMERIC3 = p_NUMERIC3) OR
2422 ((Recinfo.NUMERIC3 IS NULL) AND
2423 (p_NUMERIC3 IS NULL))) AND
2424 ((Recinfo.NUMERIC4 = p_NUMERIC4) OR
2425 ((Recinfo.NUMERIC4 IS NULL) AND
2426 (p_NUMERIC4 IS NULL))) AND
2427 ((Recinfo.NUMERIC5 = p_NUMERIC5) OR
2428 ((Recinfo.NUMERIC5 IS NULL) AND
2429 (p_NUMERIC5 IS NULL))) AND
2430 ((Recinfo.NUMERIC6 = p_NUMERIC6) OR
2431 ((Recinfo.NUMERIC6 IS NULL) AND
2432 (p_NUMERIC6 IS NULL))) AND
2433 ((Recinfo.NUMERIC7 = p_NUMERIC7) OR
2434 ((Recinfo.NUMERIC7 IS NULL) AND
2435 (p_NUMERIC7 IS NULL))) AND
2436 ((Recinfo.NUMERIC8 = p_NUMERIC8) OR
2437 ((Recinfo.NUMERIC8 IS NULL) AND
2438 (p_NUMERIC8 IS NULL))) AND
2439 ((Recinfo.NUMERIC9 = p_NUMERIC9) OR
2440 ((Recinfo.NUMERIC9 IS NULL) AND
2441 (p_NUMERIC9 IS NULL))) AND
2442 ((Recinfo.NUMERIC10 = p_NUMERIC10) OR
2443 ((Recinfo.NUMERIC10 IS NULL) AND
2444 (p_NUMERIC10 IS NULL))) AND
2445 ((Recinfo.CHAR1 = p_CHAR1) OR
2446 ((Recinfo.CHAR1 IS NULL) AND
2447 (p_CHAR1 IS NULL))) AND
2448 ((Recinfo.CHAR2 = p_CHAR2) OR
2449 ((Recinfo.CHAR2 IS NULL) AND
2450 (p_CHAR2 IS NULL))) AND
2451 ((Recinfo.CHAR3 = p_CHAR3) OR
2452 ((Recinfo.CHAR3 IS NULL) AND
2453 (p_CHAR3 IS NULL))) AND
2454 ((Recinfo.CHAR4 = p_CHAR4) OR
2455 ((Recinfo.CHAR4 IS NULL) AND
2456 (p_CHAR4 IS NULL))) AND
2457 ((Recinfo.CHAR5 = p_CHAR5) OR
2458 ((Recinfo.CHAR5 IS NULL) AND
2459 (p_CHAR5 IS NULL))) AND
2460 ((Recinfo.CHAR6 = p_CHAR6) OR
2461 ((Recinfo.CHAR6 IS NULL) AND
2462 (p_CHAR6 IS NULL))) AND
2463 ((Recinfo.CHAR7 = p_CHAR7) OR
2464 ((Recinfo.CHAR7 IS NULL) AND
2465 (p_CHAR7 IS NULL))) AND
2466 ((Recinfo.CHAR8 = p_CHAR8) OR
2467 ((Recinfo.CHAR8 IS NULL) AND
2468 (p_CHAR8 IS NULL))) AND
2469 ((Recinfo.CHAR9 = p_CHAR9) OR
2470 ((Recinfo.CHAR9 IS NULL) AND
2471 (p_CHAR9 IS NULL))) AND
2472 ((Recinfo.CHAR10 = p_CHAR10) OR
2473 ((Recinfo.CHAR10 IS NULL) AND
2474 (p_CHAR10 IS NULL))) AND
2475 ((Recinfo.DATE1 = p_DATE1) OR
2476 ((Recinfo.DATE1 IS NULL) AND
2477 (p_DATE1 IS NULL))) AND
2478 ((Recinfo.DATE2 = p_DATE2) OR
2479 ((Recinfo.DATE2 IS NULL) AND
2480 (p_DATE2 IS NULL))) AND
2481 ((Recinfo.DATE3 = p_DATE3) OR
2482 ((Recinfo.DATE3 IS NULL) AND
2483 (p_DATE3 IS NULL))) AND
2484 ((Recinfo.DATE4 = p_DATE4) OR
2485 ((Recinfo.DATE4 IS NULL) AND
2486 (p_DATE4 IS NULL))) AND
2487 ((Recinfo.DATE5 = p_DATE5) OR
2488 ((Recinfo.DATE5 IS NULL) AND
2489 (p_DATE5 IS NULL))) AND
2490 ((Recinfo.DATE6 = p_DATE6) OR
2491 ((Recinfo.DATE6 IS NULL) AND
2492 (p_DATE6 IS NULL))) AND
2493 ((Recinfo.DATE7 = p_DATE7) OR
2494 ((Recinfo.DATE7 IS NULL) AND
2495 (p_DATE7 IS NULL))) AND
2496 ((Recinfo.DATE8 = p_DATE8) OR
2497 ((Recinfo.DATE8 IS NULL) AND
2498 (p_DATE8 IS NULL))) AND
2499 ((Recinfo.DATE9 = p_DATE9) OR
2500 ((Recinfo.DATE9 IS NULL) AND
2501 (p_DATE9 IS NULL))) AND
2502 ((Recinfo.DATE10 = p_DATE10) OR
2503 ((Recinfo.DATE10 IS NULL) AND
2504 (p_DATE10 IS NULL))) AND
2505
2506 ((Recinfo.INTERFACE_ENTITY_CODE = p_interface_entity_code ) OR
2507 ((Recinfo.INTERFACE_ENTITY_CODE IS NULL) AND
2508 (p_interface_entity_code IS NULL))) AND
2509 ((Recinfo.INTERFACE_TAX_LINE_ID = p_interface_tax_line_id) OR
2510 ((Recinfo.INTERFACE_TAX_LINE_ID IS NULL) AND
2511 (p_interface_tax_line_id IS NULL))) AND
2512 ((Recinfo.TAXING_JURIS_GEOGRAPHY_ID = p_taxing_juris_geography_id) OR
2513 ((Recinfo.TAXING_JURIS_GEOGRAPHY_ID IS NULL) AND
2514 (p_taxing_juris_geography_id IS NULL))) AND
2515 ((Recinfo.ADJUSTED_DOC_TAX_LINE_ID = p_adjusted_doc_tax_line_id) OR
2516 ((Recinfo.ADJUSTED_DOC_TAX_LINE_ID IS NULL) AND
2517 (p_adjusted_doc_tax_line_id IS NULL))) AND
2518 (Recinfo.OBJECT_VERSION_NUMBER = p_object_version_number) AND
2519 (Recinfo.CREATED_BY = p_CREATED_BY) AND
2520 (Recinfo.CREATION_DATE = p_CREATION_DATE) AND
2521 (Recinfo.LAST_UPDATED_BY = p_last_updated_by) AND
2522 (Recinfo.LAST_UPDATE_DATE = p_last_update_date) AND
2523 ((Recinfo.LAST_UPDATE_LOGIN = p_last_update_login) OR
2524 ((Recinfo.LAST_UPDATE_LOGIN IS NULL) AND
2525 (p_last_update_login IS NULL))) ) THEN
2526
2527 l_transaction_rec.APPLICATION_ID := Recinfo.APPLICATION_ID;
2528 l_transaction_rec.ENTITY_CODE := Recinfo.ENTITY_CODE;
2529 l_transaction_rec.EVENT_CLASS_CODE := Recinfo.EVENT_CLASS_CODE;
2530 l_transaction_rec.EVENT_TYPE_CODE := Recinfo.EVENT_TYPE_CODE;
2531 l_transaction_rec.TRX_ID := Recinfo.TRX_ID;
2532 l_transaction_rec.INTERNAL_ORGANIZATION_ID := Recinfo.INTERNAL_ORGANIZATION_ID;
2533 --l_transaction_rec.TAX_EVENT_CLASS_CODE := Recinfo.TAX_EVENT_CLASS_CODE ;
2534 --l_transaction_rec.TAX_EVENT_TYPE_CODE := Recinfo.TAX_EVENT_TYPE_CODE;
2535 --l_transaction_rec.DOC_EVENT_STATUS := Recinfo.DOC_EVENT_STATUS ;
2536
2537 ZX_LINES_DET_FACTORS_PKG.lock_line_det_factors (
2538 l_transaction_rec,
2539 l_return_status );
2540 RETURN;
2541 ELSE
2542 FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
2543 APP_EXCEPTION.Raise_Exception;
2544 END IF;
2545
2546 IF (g_level_procedure >= g_current_runtime_level ) THEN
2547 FND_LOG.STRING(g_level_procedure,
2548 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Lock_Row.END',
2549 'ZX_TRL_DETAIL_OVERRIDE_PKG: Lock_Row (-)');
2550 END IF;
2551
2552 END Lock_Row;
2553
2554 PROCEDURE Update_Row
2555 (--X_Rowid IN OUT NOCOPY VARCHAR2,
2556 p_tax_line_id NUMBER,
2557 p_internal_organization_id NUMBER,
2558 p_application_id NUMBER,
2559 p_entity_code VARCHAR2,
2560 p_event_class_code VARCHAR2,
2561 p_event_type_code VARCHAR2,
2562 p_trx_id NUMBER,
2563 p_trx_line_id NUMBER,
2564 p_trx_level_type VARCHAR2,
2565 p_trx_line_number NUMBER,
2566 p_doc_event_status VARCHAR2,
2567 p_tax_event_class_code VARCHAR2,
2568 p_tax_event_type_code VARCHAR2,
2569 p_tax_line_number NUMBER,
2570 p_content_owner_id NUMBER,
2571 p_tax_regime_id NUMBER,
2572 p_tax_regime_code VARCHAR2,
2573 p_tax_id NUMBER,
2574 p_tax VARCHAR2,
2575 p_tax_status_id NUMBER,
2576 p_tax_status_code VARCHAR2,
2577 p_tax_rate_id NUMBER,
2578 p_tax_rate_code VARCHAR2,
2579 p_tax_rate NUMBER,
2580 p_tax_rate_type VARCHAR2,
2581 p_tax_apportionment_line_num NUMBER,--reduced in size tax_apportionment_line_number
2582 p_trx_id_level2 NUMBER,
2583 p_trx_id_level3 NUMBER,
2584 p_trx_id_level4 NUMBER,
2585 p_trx_id_level5 NUMBER,
2586 p_trx_id_level6 NUMBER,
2587 p_trx_user_key_level1 VARCHAR2,
2588 p_trx_user_key_level2 VARCHAR2,
2589 p_trx_user_key_level3 VARCHAR2,
2590 p_trx_user_key_level4 VARCHAR2,
2591 p_trx_user_key_level5 VARCHAR2,
2592 p_trx_user_key_level6 VARCHAR2,
2593 p_mrc_tax_line_flag VARCHAR2,
2594 p_mrc_link_to_tax_line_id NUMBER,
2595 p_ledger_id NUMBER,
2596 p_establishment_id NUMBER,
2597 p_legal_entity_id NUMBER,
2598 p_hq_estb_reg_number VARCHAR2,
2599 p_hq_estb_party_tax_prof_id NUMBER,
2600 p_currency_conversion_date DATE,
2601 p_currency_conversion_type VARCHAR2,
2602 p_currency_conversion_rate NUMBER,
2603 p_tax_curr_conversion_date DATE,--reduced in size tax_currency_conversion_date
2604 p_tax_curr_conversion_type VARCHAR2,--reduced in size p_tax_currency_conversion_type
2605 p_tax_curr_conversion_rate NUMBER,--reduced in size p_tax_currency_conversion_rate
2606 p_trx_currency_code VARCHAR2,
2607 p_reporting_currency_code VARCHAR2,
2608 p_minimum_accountable_unit NUMBER,
2609 p_precision NUMBER,
2610 p_trx_number VARCHAR2,
2611 p_trx_date DATE,
2612 p_unit_price NUMBER,
2613 p_line_amt NUMBER,
2614 p_trx_line_quantity NUMBER,
2615 p_tax_base_modifier_rate NUMBER,
2616 p_ref_doc_application_id NUMBER,
2617 p_ref_doc_entity_code VARCHAR2,
2618 p_ref_doc_event_class_code VARCHAR2,
2619 p_ref_doc_trx_id NUMBER,
2620 p_ref_doc_trx_level_type VARCHAR2,
2621 p_ref_doc_line_id NUMBER,
2622 p_ref_doc_line_quantity NUMBER,
2623 p_other_doc_line_amt NUMBER,
2624 p_other_doc_line_tax_amt NUMBER,
2625 p_other_doc_line_taxable_amt NUMBER,
2626 p_unrounded_taxable_amt NUMBER,
2627 p_unrounded_tax_amt NUMBER,
2628 p_related_doc_application_id NUMBER,
2629 p_related_doc_entity_code VARCHAR2,
2630 p_related_doc_evt_class_code VARCHAR2,--reduced in size p_related_doc_event_class_code
2631 p_related_doc_trx_id NUMBER,
2632 p_related_doc_trx_level_type VARCHAR2,
2633 p_related_doc_number VARCHAR2,
2634 p_related_doc_date DATE,
2635 p_applied_from_appl_id NUMBER,--reduced in size p_applied_from_application_id
2636 p_applied_from_evt_clss_code VARCHAR2,--reduced in size p_applied_from_event_class_code
2637 p_applied_from_entity_code VARCHAR2,
2638 p_applied_from_trx_id NUMBER,
2639 p_applied_from_trx_level_type VARCHAR2,
2640 p_applied_from_line_id NUMBER,
2641 p_applied_from_trx_number VARCHAR2,
2642 p_adjusted_doc_appln_id NUMBER,--reduced in size p_adjusted_doc_application_id
2643 p_adjusted_doc_entity_code VARCHAR2,
2644 p_adjusted_doc_evt_clss_code VARCHAR2,--reduced in size p_adjusted_doc_event_class_code
2645 p_adjusted_doc_trx_id NUMBER,
2646 p_adjusted_doc_trx_level_type VARCHAR2,
2647 p_adjusted_doc_line_id NUMBER,
2648 p_adjusted_doc_number VARCHAR2,
2649 p_adjusted_doc_date DATE,
2650 p_applied_to_application_id NUMBER,
2651 p_applied_to_evt_class_code VARCHAR2,--reduced in size p_applied_to_event_class_code
2652 p_applied_to_entity_code VARCHAR2,
2653 p_applied_to_trx_id NUMBER,
2654 p_applied_to_trx_level_type VARCHAR2,
2655 p_applied_to_line_id NUMBER,
2656 p_summary_tax_line_id NUMBER,
2657 p_offset_link_to_tax_line_id NUMBER,
2658 p_offset_flag VARCHAR2,
2659 p_process_for_recovery_flag VARCHAR2,
2660 p_tax_jurisdiction_id NUMBER,
2661 p_tax_jurisdiction_code VARCHAR2,
2662 p_place_of_supply NUMBER,
2663 p_place_of_supply_type_code VARCHAR2,
2664 p_place_of_supply_result_id NUMBER,
2665 p_tax_date_rule_id NUMBER,
2666 p_tax_date DATE,
2667 p_tax_determine_date DATE,
2668 p_tax_point_date DATE,
2669 p_trx_line_date DATE,
2670 p_tax_type_code VARCHAR2,
2671 p_tax_code VARCHAR2,
2672 p_tax_registration_id NUMBER,
2673 p_tax_registration_number VARCHAR2,
2674 p_registration_party_type VARCHAR2,
2675 p_rounding_level_code VARCHAR2,
2676 p_rounding_rule_code VARCHAR2,
2677 p_rndg_lvl_party_tax_prof_id NUMBER,--reduced in size p_rounding_lvl_party_tax_prof_id
2678 p_rounding_lvl_party_type VARCHAR2,
2679 p_compounding_tax_flag VARCHAR2,
2680 p_orig_tax_status_id NUMBER,
2681 p_orig_tax_status_code VARCHAR2,
2682 p_orig_tax_rate_id NUMBER,
2683 p_orig_tax_rate_code VARCHAR2,
2684 p_orig_tax_rate NUMBER,
2685 p_orig_tax_jurisdiction_id NUMBER,
2686 p_orig_tax_jurisdiction_code VARCHAR2,
2687 p_orig_tax_amt_included_flag VARCHAR2,
2688 p_orig_self_assessed_flag VARCHAR2,
2689 p_tax_currency_code VARCHAR2,
2690 p_tax_amt NUMBER,
2691 p_tax_amt_tax_curr NUMBER,
2692 p_tax_amt_funcl_curr NUMBER,
2693 p_taxable_amt NUMBER,
2694 p_taxable_amt_tax_curr NUMBER,
2695 p_taxable_amt_funcl_curr NUMBER,
2696 p_orig_taxable_amt NUMBER,
2697 p_orig_taxable_amt_tax_curr NUMBER,
2698 p_cal_tax_amt NUMBER,
2699 p_cal_tax_amt_tax_curr NUMBER,
2700 p_cal_tax_amt_funcl_curr NUMBER,
2701 p_orig_tax_amt NUMBER,
2702 p_orig_tax_amt_tax_curr NUMBER,
2703 p_rec_tax_amt NUMBER,
2704 p_rec_tax_amt_tax_curr NUMBER,
2705 p_rec_tax_amt_funcl_curr NUMBER,
2706 p_nrec_tax_amt NUMBER,
2707 p_nrec_tax_amt_tax_curr NUMBER,
2708 p_nrec_tax_amt_funcl_curr NUMBER,
2709 p_tax_exemption_id NUMBER,
2710 p_tax_rate_before_exemption NUMBER,
2711 p_tax_rate_name_before_exempt VARCHAR2,
2712 p_exempt_rate_modifier NUMBER,
2713 p_exempt_certificate_number VARCHAR2,
2714 p_exempt_reason VARCHAR2,
2715 p_exempt_reason_code VARCHAR2,
2716 p_tax_exception_id NUMBER,
2717 p_tax_rate_before_exception NUMBER,
2718 p_tax_rate_name_before_except VARCHAR2,
2719 p_exception_rate NUMBER,
2720 p_tax_apportionment_flag VARCHAR2,
2721 p_historical_flag VARCHAR2,
2722 p_taxable_basis_formula VARCHAR2,
2723 p_tax_calculation_formula VARCHAR2,
2724 p_cancel_flag VARCHAR2,
2725 p_purge_flag VARCHAR2,
2726 p_delete_flag VARCHAR2,
2727 p_tax_amt_included_flag VARCHAR2,
2728 p_self_assessed_flag VARCHAR2,
2729 p_overridden_flag VARCHAR2,
2730 p_manually_entered_flag VARCHAR2,
2731 p_reporting_only_flag VARCHAR2,
2732 p_freeze_until_overriddn_flg VARCHAR2,--reduced in size p_Freeze_Until_Overridden_Flag
2733 p_copied_from_other_doc_flag VARCHAR2,
2734 p_recalc_required_flag VARCHAR2,
2735 p_settlement_flag VARCHAR2,
2736 p_item_dist_changed_flag VARCHAR2,
2737 p_assoc_children_frozen_flg VARCHAR2,--reduced in size p_Associated_Child_Frozen_Flag
2738 p_tax_only_line_flag VARCHAR2,
2739 p_compounding_dep_tax_flag VARCHAR2,
2740 p_compounding_tax_miss_flag VARCHAR2,
2741 p_sync_with_prvdr_flag VARCHAR2,
2742 p_last_manual_entry VARCHAR2,
2743 p_tax_provider_id NUMBER,
2744 p_record_type_code VARCHAR2,
2745 p_reporting_period_id NUMBER,
2746 p_legal_justification_text1 VARCHAR2,
2747 p_legal_justification_text2 VARCHAR2,
2748 p_legal_justification_text3 VARCHAR2,
2749 p_legal_message_appl_2 NUMBER,
2750 p_legal_message_status NUMBER,
2751 p_legal_message_rate NUMBER,
2752 p_legal_message_basis NUMBER,
2753 p_legal_message_calc NUMBER,
2754 p_legal_message_threshold NUMBER,
2755 p_legal_message_pos NUMBER,
2756 p_legal_message_trn NUMBER,
2757 p_legal_message_exmpt NUMBER,
2758 p_legal_message_excpt NUMBER,
2759 p_tax_regime_template_id NUMBER,
2760 p_tax_applicability_result_id NUMBER,--reduced in size p_tax_applicability_result_id
2761 p_direct_rate_result_id NUMBER,
2762 p_status_result_id NUMBER,
2763 p_rate_result_id NUMBER,
2764 p_basis_result_id NUMBER,
2765 p_thresh_result_id NUMBER,
2766 p_calc_result_id NUMBER,
2767 p_tax_reg_num_det_result_id NUMBER,
2768 p_eval_exmpt_result_id NUMBER,
2769 p_eval_excpt_result_id NUMBER,
2770 p_enforced_from_nat_acct_flg VARCHAR2,--reduced in size p_Enforce_From_Natural_Acct_Flag
2771 p_tax_hold_code NUMBER,
2772 p_tax_hold_released_code NUMBER,
2773 p_prd_total_tax_amt NUMBER,
2774 p_prd_total_tax_amt_tax_curr NUMBER,
2775 p_prd_total_tax_amt_funcl_curr NUMBER,
2776 p_trx_line_index VARCHAR2,
2777 p_offset_tax_rate_code VARCHAR2,
2778 p_proration_code VARCHAR2,
2779 p_other_doc_source VARCHAR2,
2780 p_internal_org_location_id NUMBER,
2781 p_line_assessable_value NUMBER,
2782 p_ctrl_total_line_tx_amt NUMBER,
2783 p_applied_to_trx_number VARCHAR2,
2784 p_attribute_category VARCHAR2,
2785 p_attribute1 VARCHAR2,
2786 p_attribute2 VARCHAR2,
2787 p_attribute3 VARCHAR2,
2788 p_attribute4 VARCHAR2,
2789 p_attribute5 VARCHAR2,
2790 p_attribute6 VARCHAR2,
2791 p_attribute7 VARCHAR2,
2792 p_attribute8 VARCHAR2,
2793 p_attribute9 VARCHAR2,
2794 p_attribute10 VARCHAR2,
2795 p_attribute11 VARCHAR2,
2796 p_attribute12 VARCHAR2,
2797 p_attribute13 VARCHAR2,
2798 p_attribute14 VARCHAR2,
2799 p_attribute15 VARCHAR2,
2800 p_global_attribute_category VARCHAR2,
2801 p_global_attribute1 VARCHAR2,
2802 p_global_attribute2 VARCHAR2,
2803 p_global_attribute3 VARCHAR2,
2804 p_global_attribute4 VARCHAR2,
2805 p_global_attribute5 VARCHAR2,
2806 p_global_attribute6 VARCHAR2,
2807 p_global_attribute7 VARCHAR2,
2808 p_global_attribute8 VARCHAR2,
2809 p_global_attribute9 VARCHAR2,
2810 p_global_attribute10 VARCHAR2,
2811 p_global_attribute11 VARCHAR2,
2812 p_global_attribute12 VARCHAR2,
2813 p_global_attribute13 VARCHAR2,
2814 p_global_attribute14 VARCHAR2,
2815 p_global_attribute15 VARCHAR2,
2816 p_numeric1 NUMBER,
2817 p_numeric2 NUMBER,
2818 p_numeric3 NUMBER,
2819 p_numeric4 NUMBER,
2820 p_numeric5 NUMBER,
2821 p_numeric6 NUMBER,
2822 p_numeric7 NUMBER,
2823 p_numeric8 NUMBER,
2824 p_numeric9 NUMBER,
2825 p_numeric10 NUMBER,
2826 p_char1 VARCHAR2,
2827 p_char2 VARCHAR2,
2828 p_char3 VARCHAR2,
2829 p_char4 VARCHAR2,
2830 p_char5 VARCHAR2,
2831 p_char6 VARCHAR2,
2832 p_char7 VARCHAR2,
2833 p_char8 VARCHAR2,
2834 p_char9 VARCHAR2,
2835 p_char10 VARCHAR2,
2836 p_date1 DATE,
2837 p_date2 DATE,
2838 p_date3 DATE,
2839 p_date4 DATE,
2840 p_date5 DATE,
2841 p_date6 DATE,
2842 p_date7 DATE,
2843 p_date8 DATE,
2844 p_date9 DATE,
2845 p_date10 DATE,
2846 p_interface_entity_code VARCHAR2,
2847 p_interface_tax_line_id NUMBER,
2848 p_taxing_juris_geography_id NUMBER,
2849 p_adjusted_doc_tax_line_id NUMBER,
2850 p_object_version_number NUMBER,
2851 --p_created_by NUMBER,
2852 --p_creation_date DATE,
2853 p_last_updated_by NUMBER,
2854 p_last_update_date DATE,
2855 p_last_update_login NUMBER) IS
2856
2857 Cursor c_line (p_appln_id NUMBER,
2858 p_entity_cd VARCHAR2,
2859 p_event_cls_cd VARCHAR2,
2860 p_transaction_id NUMBER,
2861 p_trx_ln_id NUMBER,
2862 p_trx_lev_type VARCHAR2,
2863 p_tax_ln_id NUMBER)
2864 IS SELECT
2865 tax_status_code,
2866 tax_rate_id,
2867 tax_rate_code,
2868 tax_rate,
2869 tax_jurisdiction_code,
2870 ledger_id,
2871 legal_entity_id,
2872 establishment_id,
2873 TRUNC(currency_conversion_date) currency_conversion_date,
2874 currency_conversion_type,
2875 currency_conversion_rate,
2876 taxable_basis_formula,
2877 tax_calculation_formula,
2878 tax_amt_included_flag,
2879 compounding_tax_flag,
2880 self_assessed_flag,
2881 reporting_only_flag,
2882 copied_from_other_doc_flag,
2883 record_type_code,
2884 tax_provider_id,
2885 historical_flag,
2886 delete_flag,
2887 overridden_flag,
2888 manually_entered_flag,
2889 tax_exemption_id,
2890 tax_rate_before_exemption,
2891 tax_rate_name_before_exemption,
2892 exempt_rate_modifier,
2893 exempt_certificate_number,
2894 exempt_reason,
2895 exempt_reason_code,
2896 tax_rate_before_exception,
2897 tax_rate_name_before_exception,
2898 tax_exception_id,
2899 exception_rate,
2900 mrc_tax_line_flag,
2901 tax_only_line_flag,
2902 tax_apportionment_line_number,
2903 tax_amt
2904 FROM zx_lines
2905 WHERE application_id = p_appln_id
2906 AND entity_code = p_entity_cd
2907 AND event_class_code = p_event_cls_cd
2908 AND trx_id = p_transaction_id
2909 AND trx_line_id = p_trx_ln_id
2910 AND trx_level_type = p_trx_lev_type
2911 AND tax_line_id = p_tax_ln_id;
2912
2913 CURSOR existing_summary_tax_line(l_tax_rate NUMBER) IS
2914 SELECT summary_tax_line_id
2915 FROM zx_lines_summary
2916 WHERE application_id = p_application_id
2917 AND entity_code = p_entity_code
2918 AND event_class_code = p_event_class_code
2919 AND trx_id = p_trx_id
2920 AND tax_status_code = p_tax_status_code
2921 AND tax_rate_id = p_tax_rate_id
2922 AND tax_rate_code = p_tax_rate_code
2923 AND tax_rate = l_tax_rate
2924 AND NVL(tax_jurisdiction_code, 'x') = NVL(p_tax_jurisdiction_code, 'x')
2925 AND NVL(ledger_id, -999) = NVL(p_ledger_id, -999)
2926 AND NVL(legal_entity_id, -999) = NVL(p_legal_entity_id, -999)
2927 AND NVL(establishment_id, -999) = NVL(p_establishment_id, -999)
2928 AND NVL(TRUNC(currency_conversion_date), DATE_DUMMY) = NVL(TRUNC(p_currency_conversion_date), DATE_DUMMY)
2929 AND NVL(currency_conversion_type, 'x') = NVL(p_currency_conversion_type, 'x')
2930 AND NVL(currency_conversion_rate, 1) = NVL(p_currency_conversion_rate,1)
2931 AND NVL(taxable_basis_formula, 'x') = NVL(p_taxable_basis_formula, 'x')
2932 AND NVL(tax_calculation_formula, 'x') = NVL(p_tax_calculation_formula,'x')
2933 AND NVL(tax_amt_included_flag,'N') = NVL(p_tax_amt_included_flag,'N')
2934 AND NVL(compounding_tax_flag,'N') = NVL(p_compounding_tax_flag,'N')
2935 AND NVL(self_assessed_flag,'N') = NVL(p_self_assessed_flag,'N')
2936 AND NVL(reporting_only_flag,'N') = NVL(p_reporting_only_flag,'N')
2937 -- AND NVL(copied_from_other_doc_flag,'N') = NVL(p_copied_from_other_doc_flag,'N')
2938 AND NVL(record_type_code, 'x') = NVL(p_record_type_code, 'x')
2939 AND NVL(tax_provider_id, -999) = NVL(p_tax_provider_id, -999)
2940 AND NVL(historical_flag,'N') = NVL(p_historical_flag,'N')
2941 AND NVL(delete_flag,'N') = NVL(p_delete_flag,'N')
2942 -- AND NVL(overridden_flag,'N') = NVL(p_overridden_flag,'N')
2943 AND NVL(manually_entered_flag,'N') = NVL(p_manually_entered_flag,'N')
2944 AND NVL(tax_exemption_id, -999) = NVL(p_tax_exemption_id, -999)
2945 -- AND NVL(tax_rate_before_exemption, -999) = NVL(p_tax_rate_before_exemption, -999)
2946 -- AND NVL(tax_rate_name_before_exemption, 'x') = NVL(p_tax_rate_name_before_exempt, 'x')
2947 -- AND NVL(exempt_rate_modifier, -999) = NVL(p_exempt_rate_modifier, -999)
2948 AND NVL(exempt_certificate_number, 'x') = NVL(p_exempt_certificate_number, 'x')
2949 --AND NVL(exempt_reason, 'x') = NVL(p_exempt_reason, 'x')
2950 AND NVL(exempt_reason_code, 'x') = NVL(p_exempt_reason_code, 'x')
2951 -- AND NVL(tax_rate_before_exception, -999) = NVL(p_tax_rate_before_exception, -999)
2952 -- AND NVL(tax_rate_name_before_exception, 'x') = NVL(p_tax_rate_name_before_except, 'x')
2953 AND NVL(tax_exception_id, -999) = NVL(p_tax_exception_id, -999)
2954 -- AND NVL(exception_rate, -999) = NVL(p_exception_rate, -999)
2955 AND NVL(mrc_tax_line_flag,'N') = NVL(p_mrc_tax_line_flag,'N')
2956 AND NVL(tax_only_line_flag,'N') = NVL(p_tax_only_line_flag,'N');
2957
2958 l_tax_status_code VARCHAR2(30);
2959 l_tax_rate NUMBER;
2960 l_tax_amt NUMBER;
2961 l_orig_tax_status_code VARCHAR2(30);
2962 l_orig_tax_rate NUMBER;
2963 l_orig_tax_amt NUMBER;
2964 l_orig_tax_jurisdiction_id NUMBER;
2965 l_orig_tax_jurisdiction_code NUMBER;
2966 l_self_assessed_flag NUMBER;
2967 l_orig_self_assessed_flag NUMBER;
2968 l_tax_amt_included_flag NUMBER;
2969 l_orig_tax_amt_included_flag NUMBER;
2970 l_return_status VARCHAR2(1000);
2971 l_msg_count NUMBER;
2972 l_msg_data VARCHAR2(1000);
2973 l_new_tax_amt_included_flag VARCHAR2(1);
2974 l_compounding_tax_flag VARCHAR2(1);
2975 l_overridden_flag VARCHAR2(1);
2976 l_process_for_recovery_flag VARCHAR2(1);
2977 l_ctrl_ef_ov_cal_line_flag VARCHAR2(1);
2978 l_tax_apportionment_line_num NUMBER;
2979 l_tax_line_id NUMBER;
2980 l_offset_tax_line_id NUMBER;
2981 l_offset_trx_line_id NUMBER;
2982 l_tax_line_number NUMBER;
2983 l_row_id VARCHAR2(100);
2984 l_same_line Boolean;
2985 l_existing_summary_tax_line_id NUMBER;
2986 l_detail_tax_amt NUMBER;
2987 l_allow_adhoc_tax_rate_flag VARCHAR2(100);
2988 l_adj_for_adhoc_amt_code VARCHAR2(100);
2989 l_tax_amt_incl_changed varchar2(1);
2990
2991
2992
2993 BEGIN
2994
2995 l_same_line := TRUE;
2996 l_tax_amt_incl_changed := NVL(p_tax_amt_included_flag,'N');
2997 g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2998
2999 IF (g_level_procedure >= g_current_runtime_level ) THEN
3000 FND_LOG.STRING(g_level_procedure,
3001 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Update_Row.BEGIN',
3002 'ZX_TRL_DETAIL_OVERRIDE_PKG: Update_Row (+)');
3003 FND_LOG.STRING(g_level_procedure,
3004 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Update_Row',
3005 'Input Parameters : Application_Id='||TO_CHAR(p_application_id)||
3006 ', Entity_Code='||p_entity_code||
3007 ', Event_Class_Code='||p_event_class_code||
3008 ', Trx_Id='||TO_CHAR(p_trx_id)||
3009 ', Trx_Line_Id='||TO_CHAR(p_trx_line_id)||
3010 ', Trx_Level_Type='||p_trx_level_type||
3011 ', Tax_Line_Id='||TO_CHAR(p_tax_line_id)||
3012 ', Tax_Amt_Incl_Changed='||l_tax_amt_incl_changed||
3013 ', Compounding_Tax_Flag='||p_compounding_tax_flag||
3014 ', Tax_Amt_Included_Flag='||p_tax_amt_included_flag||
3015 ', Recalc_Required_Flag='||p_recalc_required_flag||
3016 ', Process_For_Recovery_Flag='||p_process_for_recovery_flag||
3017 ', Assoc_Child_Frozen_Flag='||p_assoc_children_frozen_flg||
3018 ', Tax_Only_Line_Flag='||p_tax_only_line_flag||
3019 ', Legal_justification_text1='||p_legal_justification_text1||
3020 ', Legal_justification_text2='||p_legal_justification_text2||
3021 ', Legal_justification_text3='||p_legal_justification_text3);
3022 END IF;
3023
3024 l_tax_rate := p_tax_rate;
3025
3026 BEGIN
3027 SELECT tax_amt
3028 INTO l_detail_tax_amt
3029 FROM zx_lines
3030 WHERE tax_line_id = p_tax_line_id;
3031 EXCEPTION
3032 WHEN OTHERS THEN
3033 NULL;
3034 END;
3035
3036 IF p_last_manual_entry = 'TAX_AMOUNT' AND
3037 p_tax_amt <> l_detail_tax_amt AND
3038 NVL(p_cancel_flag, 'N') <> 'Y' AND
3039 NVL(p_manually_entered_flag,'N') <> 'Y' -- Added condition to fix Bug#10040554
3040 THEN
3041 BEGIN
3042 SELECT allow_adhoc_tax_rate_flag, adj_for_adhoc_amt_code
3043 INTO l_allow_adhoc_tax_rate_flag, l_adj_for_adhoc_amt_code
3044 FROM zx_rates_b
3045 WHERE tax_rate_id = p_tax_rate_id;
3046 EXCEPTION
3047 WHEN OTHERS THEN
3048 NULL;
3049 END;
3050
3051 IF NVL(l_allow_adhoc_tax_rate_flag,'N') = 'Y' AND
3052 l_adj_for_adhoc_amt_code = 'TAX_RATE'
3053 THEN
3054 IF p_taxable_amt <> 0 THEN
3055 l_tax_rate := round(p_tax_amt/p_taxable_amt*100, 6); -- Bug 8217841
3056 END IF;
3057 END IF;
3058
3059 END IF;
3060
3061 -- new changes
3062 FOR rec IN existing_summary_tax_line(l_tax_rate) LOOP
3063 IF rec.summary_tax_line_id = p_summary_tax_line_id THEN
3064 l_existing_summary_tax_line_id := NULL;
3065 EXIT;
3066 ELSE
3067 l_existing_summary_tax_line_id := rec.summary_tax_line_id;
3068 END IF;
3069 END LOOP;
3070
3071 -- new changes
3072 l_new_tax_amt_included_flag := NVL(p_tax_amt_included_flag, 'N');
3073 l_compounding_tax_flag := NVL(p_compounding_tax_flag, 'N');
3074 l_overridden_flag := p_overridden_flag;
3075 l_process_for_recovery_flag := NVL(p_process_for_recovery_flag, 'N');
3076
3077 IF nvl(p_tax_only_line_flag,'N') = 'N' THEN
3078 IF nvl(p_assoc_children_frozen_flg,'N') = 'Y' THEN
3079 FOR rec IN c_line (p_application_id,
3080 p_entity_code,
3081 p_event_class_code,
3082 p_trx_id,
3083 p_trx_line_id,
3084 p_trx_level_type,
3085 p_tax_line_id)
3086 LOOP
3087 IF NVL(rec.tax_amt_included_flag,'N') <> NVL(p_tax_amt_included_flag,'N') THEN
3088 l_tax_amt_incl_changed := 'Y';
3089 END IF;
3090
3091 IF ( rec.tax_status_code <> p_tax_status_code
3092 OR rec.tax_rate_id <> p_tax_rate_id
3093 OR rec.tax_rate_code <> p_tax_rate_code
3094 OR rec.tax_rate <> l_tax_rate
3095 OR NVL(rec.tax_jurisdiction_code, 'x') <> NVL(p_tax_jurisdiction_code, 'x')
3096 OR NVL(rec.ledger_id, -999) <> NVL(p_ledger_id, -999)
3097 OR NVL(rec.legal_entity_id, -999) <> NVL(p_legal_entity_id, -999)
3098 OR NVL(rec.establishment_id, -999) <> NVL(p_establishment_id, -999)
3099 OR NVL(TRUNC(rec.currency_conversion_date),DATE_DUMMY) <> NVL(TRUNC(p_currency_conversion_date), DATE_DUMMY)
3100 OR NVL(rec.currency_conversion_type, 'x') <> NVL(p_currency_conversion_type,'x')
3101 OR NVL(rec.currency_conversion_rate, 1) <> NVL(p_currency_conversion_rate, 1)
3102 OR NVL(rec.taxable_basis_formula,'x') <> NVL(p_taxable_basis_formula, 'x')
3103 OR NVL(rec.tax_calculation_formula, 'x') <> NVL(p_tax_calculation_formula, 'x')
3104 OR NVL(rec.tax_amt_included_flag,'N') <> NVL(p_tax_amt_included_flag,'N')
3105 OR NVL(rec.compounding_tax_flag,'N') <> NVL(p_compounding_tax_flag,'N')
3106 OR NVL(rec.self_assessed_flag,'N') <> NVL(p_self_assessed_flag,'N')
3107 OR NVL(rec.reporting_only_flag,'N') <> NVL(p_reporting_only_flag,'N')
3108 -- OR NVL(rec.copied_from_other_doc_flag,'N') <> NVL(p_copied_from_other_doc_flag,'N')
3109 OR NVL(rec.record_type_code,'x') <> NVL(p_record_type_code, 'x')
3110 OR NVL(rec.tax_provider_id, -999) <> NVL(p_tax_provider_id, -999)
3111 OR NVL(rec.historical_flag,'N') <> NVL(p_historical_flag,'N')
3112 OR NVL(rec.delete_flag,'N') <> NVL(p_delete_flag,'N')
3113 -- OR NVL(rec.overridden_flag,'N') <> NVL(p_overridden_flag,'N')
3114 OR NVL(rec.manually_entered_flag,'N') <> NVL(p_manually_entered_flag,'N')
3115 OR NVL(rec.tax_exemption_id, -999) <> NVL(p_tax_exemption_id, -999)
3116 -- OR NVL(rec.tax_rate_before_exemption, -999) <> NVL(p_tax_rate_before_exemption, -999)
3117 -- OR NVL(rec.tax_rate_name_before_exemption, 'x') <> NVL(p_tax_rate_name_before_exempt, 'x')
3118 -- OR NVL(rec.exempt_rate_modifier, -999) <> NVL(p_exempt_rate_modifier, -999)
3119 OR NVL(rec.exempt_certificate_number,'x') <> NVL(p_exempt_certificate_number, 'x')
3120 -- OR NVL(rec.exempt_reason, 'x') <> NVL(p_exempt_reason, 'x')
3121 OR NVL(rec.exempt_reason_code,'x') <> NVL(p_exempt_reason_code, 'x')
3122 -- OR NVL(rec.tax_rate_before_exception, -999) <> NVL(p_tax_rate_before_exception, -999)
3123 -- OR NVL(rec.tax_rate_name_before_exception, 'x') <> NVL(p_tax_rate_name_before_except, 'x')
3124 OR NVL(rec.tax_exception_id, -999) <> NVL(p_tax_exception_id, -999)
3125 -- OR NVL(rec.exception_rate, -999) <> NVL(p_exception_rate, -999)
3126 OR NVL(rec.mrc_tax_line_flag,'N') <> NVL(p_mrc_tax_line_flag,'N')
3127 OR NVL(rec.tax_only_line_flag,'N') <> NVL(p_tax_only_line_flag,'N')
3128 -- OR (NVL(l_detail_tax_amt,-999999999) <> NVL(p_tax_amt,-999999999)
3129 -- AND NVL(l_overridden_flag,'N')='N')
3130 )
3131 THEN
3132
3133 IF (g_level_procedure >= g_current_runtime_level ) THEN
3134 FND_LOG.STRING(g_level_procedure,
3135 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Update_Row',
3136 'Inside summary tax line criteria changed');
3137 END IF;
3138
3139 SELECT zx_lines_s.nextval into l_tax_line_id
3140 FROM dual;
3141
3142 SELECT MAX(ABS(tax_apportionment_line_number)) + 1
3143 INTO l_tax_apportionment_line_num
3144 FROM zx_lines
3145 WHERE application_id = p_application_id
3146 AND entity_code = p_entity_code
3147 AND event_class_code = p_event_class_code
3148 AND trx_id = p_trx_id
3149 AND trx_line_id = p_trx_line_id;
3150
3151 SELECT NVL(MAX(tax_line_number),0) + 1
3152 INTO l_tax_line_number
3153 FROM zx_lines
3154 WHERE application_id = p_application_id
3155 AND entity_code = p_entity_code
3156 AND event_class_code = p_event_class_code
3157 AND trx_id = p_trx_id
3158 AND trx_line_id = p_trx_line_id
3159 AND trx_level_type = p_trx_level_type;
3160
3161 UPDATE ZX_LINES
3162 SET cancel_flag = 'Y',
3163 tax_amt = 0,
3164 tax_apportionment_line_number = -1*l_tax_apportionment_line_num,
3165 unrounded_tax_amt = 0,
3166 tax_amt_tax_curr = 0,
3167 tax_amt_funcl_curr = 0,
3168 process_for_recovery_flag = 'Y',
3169 legal_reporting_status = decode(legal_reporting_status, '111111111111111','000000000000000',legal_reporting_status),
3170 tax_hold_code = NULL,
3171 tax_hold_released_code = NULL
3172 WHERE tax_line_id = p_tax_line_id;
3173
3174 BEGIN
3175 select tax_line_id into l_offset_tax_line_id
3176 FROM zx_lines
3177 where application_id = p_application_id
3178 and entity_code = p_entity_code
3179 and event_class_code = p_event_class_code
3180 and offset_link_to_tax_line_id = p_tax_line_id
3181 and trx_id = p_trx_id --Bug 8920640
3182 and trx_level_type = p_trx_level_type;
3183
3184
3185 SELECT trx_line_id into l_offset_trx_line_id
3186 FROM zx_lines
3187 WHERE tax_line_id = l_offset_tax_line_id;
3188
3189 SELECT MAX(ABS(tax_apportionment_line_number)) + 1
3190 INTO l_tax_apportionment_line_num
3191 FROM zx_lines
3192 WHERE application_id = p_application_id
3193 AND entity_code = p_entity_code
3194 AND event_class_code = p_event_class_code
3195 AND trx_id = p_trx_id
3196 AND trx_line_id = l_offset_trx_line_id;
3197
3198 UPDATE ZX_LINES
3199 SET cancel_flag = 'Y',
3200 tax_amt = 0,
3201 tax_apportionment_line_number = -1*l_tax_apportionment_line_num,
3202 unrounded_tax_amt = 0,
3203 tax_amt_tax_curr = 0,
3204 tax_amt_funcl_curr = 0,
3205 process_for_recovery_flag = 'Y',
3206 legal_reporting_status = decode(legal_reporting_status, '111111111111111','000000000000000',legal_reporting_status),
3207 tax_hold_code = NULL,
3208 tax_hold_released_code = NULL
3209 WHERE tax_line_id = l_offset_tax_line_id;
3210
3211 EXCEPTION
3212 WHEN others then
3213 NULL;
3214 END;
3215
3216 l_same_line := FALSE;
3217
3218 Insert_Row
3219 (l_row_id ,
3220 l_tax_line_id ,
3221 p_internal_organization_id ,
3222 p_application_id ,
3223 p_entity_code ,
3224 p_event_class_code ,
3225 p_event_type_code ,
3226 p_trx_id ,
3227 p_trx_line_id ,
3228 p_trx_level_type ,
3229 p_trx_line_number ,
3230 p_doc_event_status ,
3231 p_tax_event_class_code ,
3232 p_tax_event_type_code ,
3233 l_tax_line_number ,
3234 p_content_owner_id ,
3235 p_tax_regime_id ,
3236 p_tax_regime_code ,
3237 p_tax_id ,
3238 p_tax ,
3239 p_tax_status_id ,
3240 p_tax_status_code ,
3241 p_tax_rate_id ,
3242 p_tax_rate_code ,
3243 p_tax_rate ,
3244 p_tax_rate_type ,
3245 rec.tax_apportionment_line_number ,--reduced in size tax_apportionment_line_number
3246 p_trx_id_level2 ,
3247 p_trx_id_level3 ,
3248 p_trx_id_level4 ,
3249 p_trx_id_level5 ,
3250 p_trx_id_level6 ,
3251 p_trx_user_key_level1 ,
3252 p_trx_user_key_level2 ,
3253 p_trx_user_key_level3 ,
3254 p_trx_user_key_level4 ,
3255 p_trx_user_key_level5 ,
3256 p_trx_user_key_level6 ,
3257 p_mrc_tax_line_flag ,
3258 p_mrc_link_to_tax_line_id ,
3259 p_ledger_id ,
3260 p_establishment_id ,
3261 p_legal_entity_id ,
3262 p_hq_estb_reg_number ,
3263 p_hq_estb_party_tax_prof_id ,
3264 p_currency_conversion_date ,
3265 p_currency_conversion_type ,
3266 p_currency_conversion_rate ,
3267 p_tax_curr_conversion_date ,--reduced in size tax_currency_conversion_date
3268 p_tax_curr_conversion_type ,--reduced in size p_tax_currency_conversion_type
3269 p_tax_curr_conversion_rate ,--reduced in size p_tax_currency_conversion_rate
3270 p_trx_currency_code ,
3271 p_reporting_currency_code ,
3272 p_minimum_accountable_unit ,
3273 p_precision ,
3274 p_trx_number ,
3275 p_trx_date ,
3276 p_unit_price ,
3277 p_line_amt ,
3278 p_trx_line_quantity ,
3279 p_tax_base_modifier_rate ,
3280 p_ref_doc_application_id ,
3281 p_ref_doc_entity_code ,
3282 p_ref_doc_event_class_code ,
3283 p_ref_doc_trx_id ,
3284 p_ref_doc_trx_level_type ,
3285 p_ref_doc_line_id ,
3286 p_ref_doc_line_quantity ,
3287 p_other_doc_line_amt ,
3288 p_other_doc_line_tax_amt ,
3289 p_other_doc_line_taxable_amt ,
3290 p_unrounded_taxable_amt ,
3291 p_unrounded_tax_amt ,
3292 p_related_doc_application_id ,
3293 p_related_doc_entity_code ,
3294 p_related_doc_evt_class_code ,--reduced in size p_related_doc_event_class_code
3295 p_related_doc_trx_id ,
3296 p_related_doc_trx_level_type ,
3297 p_related_doc_number ,
3298 p_related_doc_date ,
3299 p_applied_from_appl_id ,--reduced in size p_applied_from_application_id
3300 p_applied_from_evt_clss_code ,--reduced in size p_applied_from_event_class_code
3301 p_applied_from_entity_code ,
3302 p_applied_from_trx_id ,
3303 p_applied_from_trx_level_type ,
3304 p_applied_from_line_id ,
3305 p_applied_from_trx_number ,
3306 p_adjusted_doc_appln_id ,--reduced in size p_adjusted_doc_application_id
3307 p_adjusted_doc_entity_code ,
3308 p_adjusted_doc_evt_clss_code ,--reduced in size p_adjusted_doc_event_class_code
3309 p_adjusted_doc_trx_id ,
3310 p_adjusted_doc_trx_level_type ,
3311 p_adjusted_doc_line_id ,
3312 p_adjusted_doc_number ,
3313 p_adjusted_doc_date ,
3314 p_applied_to_application_id ,
3315 p_applied_to_evt_class_code ,--reduced in size p_applied_to_event_class_code
3316 p_applied_to_entity_code ,
3317 p_applied_to_trx_id ,
3318 p_applied_to_trx_level_type ,
3319 p_applied_to_line_id ,
3320 l_existing_summary_tax_line_id ,
3321 p_offset_link_to_tax_line_id ,
3322 p_offset_flag ,
3323 p_process_for_recovery_flag ,
3324 p_tax_jurisdiction_id ,
3325 p_tax_jurisdiction_code ,
3326 p_place_of_supply ,
3327 p_place_of_supply_type_code ,
3328 p_place_of_supply_result_id ,
3329 p_tax_date_rule_id ,
3330 p_tax_date ,
3331 p_tax_determine_date ,
3332 p_tax_point_date ,
3333 p_trx_line_date ,
3334 p_tax_type_code ,
3335 p_tax_code ,
3336 p_tax_registration_id ,
3337 p_tax_registration_number ,
3338 p_registration_party_type ,
3339 p_rounding_level_code ,
3340 p_rounding_rule_code ,
3341 p_rndg_lvl_party_tax_prof_id ,--reduced in size p_rounding_lvl_party_tax_prof_id
3342 p_rounding_lvl_party_type ,
3343 p_compounding_tax_flag ,
3344 p_orig_tax_status_id ,
3345 p_orig_tax_status_code ,
3346 p_orig_tax_rate_id ,
3347 p_orig_tax_rate_code ,
3348 p_orig_tax_rate ,
3349 p_orig_tax_jurisdiction_id ,
3350 p_orig_tax_jurisdiction_code ,
3351 p_orig_tax_amt_included_flag ,
3352 p_orig_self_assessed_flag ,
3353 p_tax_currency_code ,
3354 p_tax_amt ,
3355 p_tax_amt_tax_curr ,
3356 p_tax_amt_funcl_curr ,
3357 p_taxable_amt ,
3358 p_taxable_amt_tax_curr ,
3359 p_taxable_amt_funcl_curr ,
3360 p_orig_taxable_amt ,
3361 p_orig_taxable_amt_tax_curr ,
3362 p_cal_tax_amt ,
3363 p_cal_tax_amt_tax_curr ,
3364 p_cal_tax_amt_funcl_curr ,
3365 p_orig_tax_amt ,
3366 p_orig_tax_amt_tax_curr ,
3367 p_rec_tax_amt ,
3368 p_rec_tax_amt_tax_curr ,
3369 p_rec_tax_amt_funcl_curr ,
3370 p_nrec_tax_amt ,
3371 p_nrec_tax_amt_tax_curr ,
3372 p_nrec_tax_amt_funcl_curr ,
3373 p_tax_exemption_id ,
3374 p_tax_rate_before_exemption ,
3375 p_tax_rate_name_before_exempt ,
3376 p_exempt_rate_modifier ,
3377 p_exempt_certificate_number ,
3378 p_exempt_reason ,
3379 p_exempt_reason_code ,
3380 p_tax_exception_id ,
3381 p_tax_rate_before_exception ,
3382 p_tax_rate_name_before_except ,
3383 p_exception_rate ,
3384 p_tax_apportionment_flag ,
3385 p_historical_flag ,
3386 p_taxable_basis_formula ,
3387 p_tax_calculation_formula ,
3388 p_cancel_flag ,
3389 p_purge_flag ,
3390 p_delete_flag ,
3391 p_tax_amt_included_flag ,
3392 p_self_assessed_flag ,
3393 'C' ,--p_overridden_flag,
3394 p_manually_entered_flag ,
3395 p_reporting_only_flag ,
3396 p_freeze_until_overriddn_flg ,--reduced in size p_Freeze_Until_Overridden_Flag
3397 p_copied_from_other_doc_flag ,
3398 p_recalc_required_flag ,
3399 p_settlement_flag ,
3400 p_item_dist_changed_flag ,
3401 NULL ,--reduced in size p_Associated_Child_Frozen_Flag
3402 p_tax_only_line_flag ,
3403 p_compounding_dep_tax_flag ,
3404 p_compounding_tax_miss_flag ,
3405 p_sync_with_prvdr_flag ,
3406 p_last_manual_entry ,
3407 p_tax_provider_id ,
3408 p_record_type_code ,
3409 p_reporting_period_id ,
3410 p_legal_justification_text1 ,
3411 p_legal_justification_text2 ,
3412 p_legal_justification_text3 ,
3413 p_legal_message_appl_2 ,
3414 p_legal_message_status ,
3415 p_legal_message_rate ,
3416 p_legal_message_basis ,
3417 p_legal_message_calc ,
3418 p_legal_message_threshold ,
3419 p_legal_message_pos ,
3420 p_legal_message_trn ,
3421 p_legal_message_exmpt ,
3422 p_legal_message_excpt ,
3423 p_tax_regime_template_id ,
3424 p_tax_applicability_result_id ,--reduced in size p_tax_applicability_result_id
3425 p_direct_rate_result_id ,
3426 p_status_result_id ,
3427 p_rate_result_id ,
3428 p_basis_result_id ,
3429 p_thresh_result_id ,
3430 p_calc_result_id ,
3431 p_tax_reg_num_det_result_id ,
3432 p_eval_exmpt_result_id ,
3433 p_eval_excpt_result_id ,
3434 p_enforced_from_nat_acct_flg ,--reduced in size p_Enforce_From_Natural_Acct_Flag
3435 NULL ,--p_tax_hold_code
3436 NULL ,--p_tax_hold_released_code
3437 p_prd_total_tax_amt ,
3438 p_prd_total_tax_amt_tax_curr ,
3439 p_prd_total_tax_amt_funcl_curr ,
3440 p_trx_line_index ,
3441 p_offset_tax_rate_code ,
3442 p_proration_code ,
3443 p_other_doc_source ,
3444 p_internal_org_location_id ,
3445 p_line_assessable_value ,
3446 p_ctrl_total_line_tx_amt ,
3447 p_applied_to_trx_number ,
3448 NULL , -- Bug 7117340 -- DFF ER -- p_attribute_category
3449 NULL , -- Bug 7117340 -- DFF ER -- p_attribute1
3450 NULL , -- Bug 7117340 -- DFF ER -- p_attribute2
3451 NULL , -- Bug 7117340 -- DFF ER -- p_attribute3
3452 NULL , -- Bug 7117340 -- DFF ER -- p_attribute4
3453 NULL , -- Bug 7117340 -- DFF ER -- p_attribute5
3454 NULL , -- Bug 7117340 -- DFF ER -- p_attribute6
3455 NULL , -- Bug 7117340 -- DFF ER -- p_attribute7
3456 NULL , -- Bug 7117340 -- DFF ER -- p_attribute8
3457 NULL , -- Bug 7117340 -- DFF ER -- p_attribute9
3458 NULL , -- Bug 7117340 -- DFF ER -- p_attribute10
3459 NULL , -- Bug 7117340 -- DFF ER -- p_attribute11
3460 NULL , -- Bug 7117340 -- DFF ER -- p_attribute12
3461 NULL , -- Bug 7117340 -- DFF ER -- p_attribute13
3462 NULL , -- Bug 7117340 -- DFF ER -- p_attribute14
3463 NULL , -- Bug 7117340 -- DFF ER -- p_attribute15
3464 p_global_attribute_category ,
3465 p_global_attribute1 ,
3466 p_global_attribute2 ,
3467 p_global_attribute3 ,
3468 p_global_attribute4 ,
3469 p_global_attribute5 ,
3470 p_global_attribute6 ,
3471 p_global_attribute7 ,
3472 p_global_attribute8 ,
3473 p_global_attribute9 ,
3474 p_global_attribute10 ,
3475 p_global_attribute11 ,
3476 p_global_attribute12 ,
3477 p_global_attribute13 ,
3478 p_global_attribute14 ,
3479 p_global_attribute15 ,
3480 p_numeric1 ,
3481 p_numeric2 ,
3482 p_numeric3 ,
3483 p_numeric4 ,
3484 p_numeric5 ,
3485 p_numeric6 ,
3486 p_numeric7 ,
3487 p_numeric8 ,
3488 p_numeric9 ,
3489 p_numeric10 ,
3490 p_char1 ,
3491 p_char2 ,
3492 p_char3 ,
3493 p_char4 ,
3494 p_char5 ,
3495 p_char6 ,
3496 p_char7 ,
3497 p_char8 ,
3498 p_char9 ,
3499 p_char10 ,
3500 p_date1 ,
3501 p_date2 ,
3502 p_date3 ,
3503 p_date4 ,
3504 p_date5 ,
3505 p_date6 ,
3506 p_date7 ,
3507 p_date8 ,
3508 p_date9 ,
3509 p_date10 ,
3510 P_interface_entity_code ,
3511 P_interface_tax_line_id ,
3512 P_taxing_juris_geography_id ,
3513 P_adjusted_doc_tax_line_id ,
3514 P_object_version_number ,
3515 p_last_updated_by ,
3516 p_last_update_date ,
3517 p_last_updated_by ,
3518 p_last_update_date ,
3519 p_last_update_login );
3520
3521 END IF; --summary critera changed
3522 END LOOP; --c_line
3523 END IF; --asoociated_child_frozen_flag = 'Y'
3524 END IF; --tax_only_line_flag = 'N'
3525
3526
3527 IF p_freeze_until_overriddn_flg = 'Y' AND
3528 p_overridden_flag = 'Y' AND
3529 p_copied_from_other_doc_flag = 'Y' AND
3530 p_tax_amt = 0 AND
3531 p_taxable_amt = 0 AND
3532 p_other_doc_source = 'REFERENCE' THEN
3533 IF (g_level_procedure >= g_current_runtime_level ) THEN
3534 FND_LOG.STRING(g_level_procedure,
3535 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Update_Row',
3536 'Tax Lines are created for variance purposes, no updates will be allowed');
3537 END IF;
3538 -- Tax Lines are created for variance purposes, no updates will be allowed.
3539 ELSE
3540 IF l_same_line THEN
3541 SELECT CASE WHEN p_tax_amt_included_flag <> tax_amt_included_flag
3542 THEN 'Y'
3543 ELSE 'N' END
3544 INTO l_tax_amt_incl_changed
3545 FROM ZX_LINES
3546 WHERE TAX_LINE_ID = p_tax_line_id;
3547
3548 UPDATE ZX_LINES
3549 SET TAX_REGIME_ID = p_tax_regime_id,
3550 TAX_REGIME_CODE = p_tax_regime_code,
3551 TAX_ID = p_tax_id,
3552 TAX = p_tax,
3553 TAX_STATUS_ID = p_tax_status_id,
3554 TAX_STATUS_CODE = p_tax_status_code,
3555 TAX_RATE_ID = p_tax_rate_id,
3556 TAX_RATE_CODE = p_tax_rate_code,
3557 TAX_RATE = p_tax_rate,
3558 TAX_RATE_TYPE = p_tax_rate_type, -- Added as a fix of Bug#5980153
3559 TAX_AMT = decode(p_cancel_flag, 'Y', 0, p_tax_amt),
3560 UNROUNDED_TAX_AMT = DECODE(p_cancel_flag,'Y',0,p_unrounded_tax_amt),
3561 ORIG_TAX_STATUS_ID = nvl(ORIG_TAX_STATUS_ID, p_orig_TAX_STATUS_ID),
3562 ORIG_TAX_STATUS_CODE = nvl(ORIG_TAX_STATUS_CODE, p_orig_TAX_STATUS_CODE),
3563 --ORIG_TAX_STATUS_ID = p_orig_tax_status_id,
3564 --ORIG_TAX_STATUS_CODE = p_orig_tax_status_code,
3565 ORIG_TAX_RATE_ID = nvl(ORIG_TAX_RATE_ID, p_orig_TAX_RATE_ID),
3566 ORIG_TAX_RATE_CODE = nvl(ORIG_TAX_RATE_CODE, p_orig_TAX_RATE_CODE),
3567 ORIG_TAX_RATE = nvl(ORIG_TAX_RATE, p_orig_TAX_RATE),
3568 --ORIG_TAX_RATE_ID = p_orig_tax_rate_id,
3569 --ORIG_TAX_RATE_CODE = p_orig_tax_rate_code,
3570 --ORIG_TAX_RATE = p_orig_tax_rate,
3571 ORIG_TAX_AMT = nvl(ORIG_TAX_AMT, p_orig_TAX_AMT),
3572 --ORIG_TAX_AMT = p_orig_tax_amt,
3573 ORIG_TAXABLE_AMT = nvl(ORIG_TAXABLE_AMT, p_orig_TAXABLE_AMT),
3574 -- bug 5636132
3575 ORIG_TAX_AMT_TAX_CURR = nvl(ORIG_TAX_AMT_TAX_CURR, TAX_AMT_TAX_CURR),
3576 ORIG_TAXABLE_AMT_TAX_CURR = nvl(ORIG_TAXABLE_AMT_TAX_CURR, TAXABLE_AMT_TAX_CURR),
3577 /*Bug 8329584*/
3578 TAX_JURISDICTION_CODE = p_TAX_JURISDICTION_CODE,
3579 /*Bug 8329584*/
3580 ORIG_TAX_JURISDICTION_ID = nvl(ORIG_TAX_JURISDICTION_ID, p_orig_TAX_JURISDICTION_ID),
3581 ORIG_TAX_JURISDICTION_CODE = nvl(ORIG_TAX_JURISDICTION_CODE, p_orig_TAX_JURISDICTION_CODE),
3582 --ORIG_TAX_JURISDICTION_ID = p_orig_tax_jurisdiction_id,
3583 --ORIG_TAX_JURISDICTION_CODE = p_orig_tax_jurisdiction_code,
3584 ORIG_TAX_AMT_INCLUDED_FLAG = decode(ORIG_TAX_AMT_INCLUDED_FLAG,NULL,decode(p_tax_amt_included_flag,TAX_AMT_INCLUDED_FLAG,ORIG_TAX_AMT_INCLUDED_FLAG,TAX_AMT_INCLUDED_FLAG),ORIG_TAX_AMT_INCLUDED_FLAG),
3585 ORIG_SELF_ASSESSED_FLAG = decode(ORIG_SELF_ASSESSED_FLAG,NULL,decode(p_self_assessed_flag,SELF_ASSESSED_FLAG,ORIG_SELF_ASSESSED_FLAG,SELF_ASSESSED_FLAG),ORIG_SELF_ASSESSED_FLAG),
3586 SELF_ASSESSED_FLAG = p_self_assessed_flag,
3587 TAX_AMT_INCLUDED_FLAG = l_new_tax_amt_included_flag,
3588 LAST_MANUAL_ENTRY = p_last_manual_entry,
3589 COMPOUNDING_TAX_FLAG = l_compounding_tax_flag,
3590 OVERRIDDEN_FLAG = 'Y',
3591 RECALC_REQUIRED_FLAG = decode(p_cancel_flag, 'N', 'Y', 'N'),
3592 PROCESS_FOR_RECOVERY_FLAG = decode(p_reporting_only_flag , 'N', 'Y', l_process_for_recovery_flag),
3593 FREEZE_UNTIL_OVERRIDDEN_FLAG = decode(p_copied_from_other_doc_flag, 'Y', 'N', p_freeze_until_overriddn_flg),
3594 CANCEL_FLAG = p_cancel_flag,
3595 LEGAL_REPORTING_STATUS = DECODE(p_cancel_flag, 'Y',
3596 DECODE(LEGAL_REPORTING_STATUS, '111111111111111',
3597 '000000000000000',
3598 LEGAL_REPORTING_STATUS),
3599 LEGAL_REPORTING_STATUS),
3600 SYNC_WITH_PRVDR_FLAG = decode(p_tax_provider_id, NULL, 'N', p_sync_with_prvdr_flag),
3601 TAX_HOLD_CODE = decode(p_cancel_flag, 'Y', NULL, p_tax_hold_code),
3602 TAX_HOLD_RELEASED_CODE = decode(p_cancel_flag, 'Y', NULL, p_tax_hold_released_code),
3603 OBJECT_VERSION_NUMBER = NVL(p_object_version_number, OBJECT_VERSION_NUMBER + 1),
3604 LAST_UPDATED_BY = fnd_global.user_id,
3605 LAST_UPDATE_DATE = sysdate,
3606 LAST_UPDATE_LOGIN = fnd_global.login_id,
3607 SUMMARY_TAX_LINE_ID = NVL(l_existing_summary_tax_line_id,SUMMARY_TAX_LINE_ID),
3608 --EU VAT changes
3609 LEGAL_MESSAGE_STATUS = p_legal_message_status,
3610 LEGAL_MESSAGE_RATE = p_legal_message_rate,
3611 LEGAL_MESSAGE_CALC = p_legal_message_calc,
3612 LEGAL_MESSAGE_BASIS = p_legal_message_basis,
3613 LEGAL_MESSAGE_POS = p_legal_message_pos,
3614 STATUS_RESULT_ID = p_status_result_id,
3615 RATE_RESULT_ID = p_rate_result_id,
3616 DIRECT_RATE_RESULT_ID = p_direct_rate_result_id,
3617 CALC_RESULT_ID = p_calc_result_id,
3618 BASIS_RESULT_ID = p_basis_result_id,
3619 PLACE_OF_SUPPLY_RESULT_ID = p_place_of_supply_result_id,
3620 LEGAL_JUSTIFICATION_TEXT1 = p_legal_justification_text1,
3621 LEGAL_JUSTIFICATION_TEXT2 = p_legal_justification_text2,
3622 LEGAL_JUSTIFICATION_TEXT3 = p_legal_justification_text3
3623 WHERE TAX_LINE_ID = p_tax_line_id;
3624
3625 END IF; --IF l_same_line THEN
3626 END IF; --IF p_freeze_until_overriddn_flg = 'Y'
3627
3628 IF (g_level_procedure >= g_current_runtime_level ) THEN
3629 FND_LOG.STRING(g_level_procedure,
3630 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Update_Row',
3631 'Update recalc_required_flag in zx_lines');
3632 END IF;
3633
3634 BEGIN
3635 SELECT CTRL_EFF_OVRD_CALC_LINES_FLAG
3636 INTO l_ctrl_ef_ov_cal_line_flag
3637 FROM ZX_EVNT_CLS_OPTIONS
3638 WHERE EVENT_CLASS_CODE = p_event_class_code
3639 AND APPLICATION_ID = p_application_id
3640 AND ENTITY_CODE = p_entity_code
3641 AND ENABLED_FLAG = 'Y'
3642 AND FIRST_PTY_ORG_ID = p_content_owner_id
3643 AND p_tax_date >= effective_from
3644 AND (p_tax_date <= effective_to OR EFFECTIVE_TO IS NULL);
3645 EXCEPTION
3646 WHEN NO_DATA_FOUND THEN
3647 SELECT CTRL_EFF_OVRD_CALC_LINES_FLAG
3648 INTO l_ctrl_ef_ov_cal_line_flag
3649 FROM ZX_EVNT_CLS_MAPPINGS
3650 WHERE EVENT_CLASS_CODE = p_event_class_code
3651 AND APPLICATION_ID = p_application_id
3652 AND ENTITY_CODE = p_entity_code;
3653
3654 END;
3655
3656 -- manual entered tax line:
3657 IF p_manually_entered_flag = 'N' THEN
3658 -- this is system generated tax line :
3659 IF l_tax_amt_incl_changed = 'Y' THEN
3660 IF l_ctrl_ef_ov_cal_line_flag = 'Y' THEN
3661 UPDATE ZX_LINES
3662 SET RECALC_REQUIRED_FLAG = 'Y'
3663 WHERE APPLICATION_ID = p_application_id
3664 AND ENTITY_CODE = p_entity_code
3665 AND EVENT_CLASS_CODE = p_event_class_code
3666 AND TRX_ID = p_trx_id
3667 AND TRX_LINE_ID = p_trx_line_id -- add this line
3668 AND TRX_LEVEL_TYPE = p_trx_level_type
3669 AND MANUALLY_ENTERED_FLAG = 'N'
3670 AND CANCEL_FLAG = 'N';
3671 END IF;
3672
3673 ELSE
3674 -- tax_amt_included_flag = 'N'
3675 IF p_compounding_tax_flag = 'Y' THEN
3676 UPDATE ZX_LINES
3677 SET RECALC_REQUIRED_FLAG = 'Y'
3678 WHERE APPLICATION_ID = p_application_id
3679 AND ENTITY_CODE = p_entity_code
3680 AND EVENT_CLASS_CODE = p_event_class_code
3681 AND TRX_LINE_ID = p_trx_line_id -- add this line
3682 AND TRX_LEVEL_TYPE = p_trx_level_type
3683 AND TRX_ID = p_trx_id
3684 AND COMPOUNDING_DEP_TAX_FLAG = 'Y'
3685 AND CANCEL_FLAG = 'N';
3686 END IF;
3687 END IF;
3688 END IF;
3689
3690 IF (g_level_procedure >= g_current_runtime_level ) THEN
3691 FND_LOG.STRING(g_level_procedure,
3692 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Update_Row.END',
3693 'ZX_TRL_DETAIL_OVERRIDE_PKG: Update_Row (-)');
3694 END IF;
3695
3696 END Update_Row;
3697
3698 PROCEDURE Delete_Row
3699 (X_Rowid IN OUT NOCOPY VARCHAR2,
3700 p_tax_line_id NUMBER,
3701 p_internal_organization_id NUMBER,
3702 p_application_id NUMBER,
3703 p_entity_code VARCHAR2,
3704 p_event_class_code VARCHAR2,
3705 p_event_type_code VARCHAR2,
3706 p_trx_id NUMBER,
3707 p_trx_line_id NUMBER,
3708 p_trx_level_type VARCHAR2,
3709 p_trx_line_number NUMBER,
3710 p_doc_event_status VARCHAR2,
3711 p_tax_event_class_code VARCHAR2,
3712 p_tax_event_type_code VARCHAR2,
3713 p_tax_line_number NUMBER,
3714 p_content_owner_id NUMBER,
3715 p_tax_regime_id NUMBER,
3716 p_tax_regime_code VARCHAR2,
3717 p_tax_id NUMBER,
3718 p_tax VARCHAR2,
3719 p_tax_status_id NUMBER,
3720 p_tax_status_code VARCHAR2,
3721 p_tax_rate_id NUMBER,
3722 p_tax_rate_code VARCHAR2,
3723 p_tax_rate NUMBER,
3724 p_tax_rate_type VARCHAR2,
3725 p_tax_apportionment_line_num NUMBER,--reduced in size tax_apportionment_line_number
3726 p_trx_id_level2 NUMBER,
3727 p_trx_id_level3 NUMBER,
3728 p_trx_id_level4 NUMBER,
3729 p_trx_id_level5 NUMBER,
3730 p_trx_id_level6 NUMBER,
3731 p_trx_user_key_level1 VARCHAR2,
3732 p_trx_user_key_level2 VARCHAR2,
3733 p_trx_user_key_level3 VARCHAR2,
3734 p_trx_user_key_level4 VARCHAR2,
3735 p_trx_user_key_level5 VARCHAR2,
3736 p_trx_user_key_level6 VARCHAR2,
3737 p_mrc_tax_line_flag VARCHAR2,
3738 p_mrc_link_to_tax_line_id NUMBER,
3739 p_ledger_id NUMBER,
3740 p_establishment_id NUMBER,
3741 p_legal_entity_id NUMBER,
3742 p_hq_estb_reg_number VARCHAR2,
3743 p_hq_estb_party_tax_prof_id NUMBER,
3744 p_currency_conversion_date DATE,
3745 p_currency_conversion_type VARCHAR2,
3746 p_currency_conversion_rate NUMBER,
3747 p_tax_curr_conversion_date DATE,--reduced in size tax_currency_conversion_date
3748 p_tax_curr_conversion_type VARCHAR2,--reduced in size p_tax_currency_conversion_type
3749 p_tax_curr_conversion_rate NUMBER,--reduced in size p_tax_currency_conversion_rate
3750 p_trx_currency_code VARCHAR2,
3751 p_reporting_currency_code VARCHAR2,
3752 p_minimum_accountable_unit NUMBER,
3753 p_precision NUMBER,
3754 p_trx_number VARCHAR2,
3755 p_trx_date DATE,
3756 p_unit_price NUMBER,
3757 p_line_amt NUMBER,
3758 p_trx_line_quantity NUMBER,
3759 p_tax_base_modifier_rate NUMBER,
3760 p_ref_doc_application_id NUMBER,
3761 p_ref_doc_entity_code VARCHAR2,
3762 p_ref_doc_event_class_code VARCHAR2,
3763 p_ref_doc_trx_id NUMBER,
3764 p_ref_doc_trx_level_type VARCHAR2,
3765 p_ref_doc_line_id NUMBER,
3766 p_ref_doc_line_quantity NUMBER,
3767 p_other_doc_line_amt NUMBER,
3768 p_other_doc_line_tax_amt NUMBER,
3769 p_other_doc_line_taxable_amt NUMBER,
3770 p_unrounded_taxable_amt NUMBER,
3771 p_unrounded_tax_amt NUMBER,
3772 p_related_doc_application_id NUMBER,
3773 p_related_doc_entity_code VARCHAR2,
3774 p_related_doc_evt_class_code VARCHAR2,--reduced in size p_related_doc_event_class_code
3775 p_related_doc_trx_id NUMBER,
3776 p_related_doc_trx_level_type VARCHAR2,
3777 p_related_doc_number VARCHAR2,
3778 p_related_doc_date DATE,
3779 p_applied_from_appl_id NUMBER,--reduced in size p_applied_from_application_id
3780 p_applied_from_evt_clss_code VARCHAR2,--reduced in size p_applied_from_event_class_code
3781 p_applied_from_entity_code VARCHAR2,
3782 p_applied_from_trx_id NUMBER,
3783 p_applied_from_trx_level_type VARCHAR2,
3784 p_applied_from_line_id NUMBER,
3785 p_applied_from_trx_number VARCHAR2,
3786 p_adjusted_doc_appln_id NUMBER,--reduced in size p_adjusted_doc_application_id
3787 p_adjusted_doc_entity_code VARCHAR2,
3788 p_adjusted_doc_evt_clss_code VARCHAR2,--reduced in size p_adjusted_doc_event_class_code
3789 p_adjusted_doc_trx_id NUMBER,
3790 p_adjusted_doc_trx_level_type VARCHAR2,
3791 p_adjusted_doc_line_id NUMBER,
3792 p_adjusted_doc_number VARCHAR2,
3793 p_adjusted_doc_date DATE,
3794 p_applied_to_application_id NUMBER,
3795 p_applied_to_evt_class_code VARCHAR2,--reduced in size p_applied_to_event_class_code
3796 p_applied_to_entity_code VARCHAR2,
3797 p_applied_to_trx_id NUMBER,
3798 p_applied_to_trx_level_type VARCHAR2,
3799 p_applied_to_line_id NUMBER,
3800 p_summary_tax_line_id NUMBER,
3801 p_offset_link_to_tax_line_id NUMBER,
3802 p_offset_flag VARCHAR2,
3803 p_process_for_recovery_flag VARCHAR2,
3804 p_tax_jurisdiction_id NUMBER,
3805 p_tax_jurisdiction_code VARCHAR2,
3806 p_place_of_supply NUMBER,
3807 p_place_of_supply_type_code VARCHAR2,
3808 p_place_of_supply_result_id NUMBER,
3809 p_tax_date_rule_id NUMBER,
3810 p_tax_date DATE,
3811 p_tax_determine_date DATE,
3812 p_tax_point_date DATE,
3813 p_trx_line_date DATE,
3814 p_tax_type_code VARCHAR2,
3815 p_tax_code VARCHAR2,
3816 p_tax_registration_id NUMBER,
3817 p_tax_registration_number VARCHAR2,
3818 p_registration_party_type VARCHAR2,
3819 p_rounding_level_code VARCHAR2,
3820 p_rounding_rule_code VARCHAR2,
3821 p_rndg_lvl_party_tax_prof_id NUMBER,--reduced in size p_rounding_lvl_party_tax_prof_id
3822 p_rounding_lvl_party_type VARCHAR2,
3823 p_compounding_tax_flag VARCHAR2,
3824 p_orig_tax_status_id NUMBER,
3825 p_orig_tax_status_code VARCHAR2,
3826 p_orig_tax_rate_id NUMBER,
3827 p_orig_tax_rate_code VARCHAR2,
3828 p_orig_tax_rate NUMBER,
3829 p_orig_tax_jurisdiction_id NUMBER,
3830 p_orig_tax_jurisdiction_code VARCHAR2,
3831 p_orig_tax_amt_included_flag VARCHAR2,
3832 p_orig_self_assessed_flag VARCHAR2,
3833 p_tax_currency_code VARCHAR2,
3834 p_tax_amt NUMBER,
3835 p_tax_amt_tax_curr NUMBER,
3836 p_tax_amt_funcl_curr NUMBER,
3837 p_taxable_amt NUMBER,
3838 p_taxable_amt_tax_curr NUMBER,
3839 p_taxable_amt_funcl_curr NUMBER,
3840 p_orig_taxable_amt NUMBER,
3841 p_orig_taxable_amt_tax_curr NUMBER,
3842 p_cal_tax_amt NUMBER,
3843 p_cal_tax_amt_tax_curr NUMBER,
3844 p_cal_tax_amt_funcl_curr NUMBER,
3845 p_orig_tax_amt NUMBER,
3846 p_orig_tax_amt_tax_curr NUMBER,
3847 p_rec_tax_amt NUMBER,
3848 p_rec_tax_amt_tax_curr NUMBER,
3849 p_rec_tax_amt_funcl_curr NUMBER,
3850 p_nrec_tax_amt NUMBER,
3851 p_nrec_tax_amt_tax_curr NUMBER,
3852 p_nrec_tax_amt_funcl_curr NUMBER,
3853 p_tax_exemption_id NUMBER,
3854 p_tax_rate_before_exemption NUMBER,
3855 p_tax_rate_name_before_exempt VARCHAR2,
3856 p_exempt_rate_modifier NUMBER,
3857 p_exempt_certificate_number VARCHAR2,
3858 p_exempt_reason VARCHAR2,
3859 p_exempt_reason_code VARCHAR2,
3860 p_tax_exception_id NUMBER,
3861 p_tax_rate_before_exception NUMBER,
3862 p_tax_rate_name_before_except VARCHAR2,
3863 p_exception_rate NUMBER,
3864 p_tax_apportionment_flag VARCHAR2,
3865 p_historical_flag VARCHAR2,
3866 p_taxable_basis_formula VARCHAR2,
3867 p_tax_calculation_formula VARCHAR2,
3868 p_cancel_flag VARCHAR2,
3869 p_purge_flag VARCHAR2,
3870 p_delete_flag VARCHAR2,
3871 p_tax_amt_included_flag VARCHAR2,
3872 p_self_assessed_flag VARCHAR2,
3873 p_overridden_flag VARCHAR2,
3874 p_manually_entered_flag VARCHAR2,
3875 p_reporting_only_flag VARCHAR2,
3876 p_freeze_until_overriddn_flg VARCHAR2,--reduced in size p_Freeze_Until_Overridden_Flag
3877 p_copied_from_other_doc_flag VARCHAR2,
3878 p_recalc_required_flag VARCHAR2,
3879 p_settlement_flag VARCHAR2,
3880 p_item_dist_changed_flag VARCHAR2,
3881 p_assoc_children_frozen_flg VARCHAR2,--reduced in size p_Associated_Child_Frozen_Flag
3882 p_tax_only_line_flag VARCHAR2,
3883 p_compounding_dep_tax_flag VARCHAR2,
3884 p_compounding_tax_miss_flag VARCHAR2,
3885 p_sync_with_prvdr_flag VARCHAR2,
3886 p_last_manual_entry VARCHAR2,
3887 p_tax_provider_id NUMBER,
3888 p_record_type_code VARCHAR2,
3889 p_reporting_period_id NUMBER,
3890 p_legal_justification_text1 VARCHAR2,
3891 p_legal_justification_text2 VARCHAR2,
3892 p_legal_justification_text3 VARCHAR2,
3893 p_legal_message_appl_2 NUMBER,
3894 p_legal_message_status NUMBER,
3895 p_legal_message_rate NUMBER,
3896 p_legal_message_basis NUMBER,
3897 p_legal_message_calc NUMBER,
3898 p_legal_message_threshold NUMBER,
3899 p_legal_message_pos NUMBER,
3900 p_legal_message_trn NUMBER,
3901 p_legal_message_exmpt NUMBER,
3902 p_legal_message_excpt NUMBER,
3903 p_tax_regime_template_id NUMBER,
3904 p_tax_applicability_result_id NUMBER,--reduced in size p_tax_applicability_result_id
3905 p_direct_rate_result_id NUMBER,
3906 p_status_result_id NUMBER,
3907 p_rate_result_id NUMBER,
3908 p_basis_result_id NUMBER,
3909 p_thresh_result_id NUMBER,
3910 p_calc_result_id NUMBER,
3911 p_tax_reg_num_det_result_id NUMBER,
3912 p_eval_exmpt_result_id NUMBER,
3913 p_eval_excpt_result_id NUMBER,
3914 p_enforced_from_nat_acct_flg VARCHAR2,--reduced in size p_Enforce_From_Natural_Acct_Flag
3915 p_tax_hold_code NUMBER,
3916 p_tax_hold_released_code NUMBER,
3917 p_prd_total_tax_amt NUMBER,
3918 p_prd_total_tax_amt_tax_curr NUMBER,
3919 p_prd_total_tax_amt_funcl_curr NUMBER,
3920 p_trx_line_index VARCHAR2,
3921 p_offset_tax_rate_code VARCHAR2,
3922 p_proration_code VARCHAR2,
3923 p_other_doc_source VARCHAR2,
3924 p_internal_org_location_id NUMBER,
3925 p_line_assessable_value NUMBER,
3926 p_ctrl_total_line_tx_amt NUMBER,
3927 p_applied_to_trx_number VARCHAR2,
3928 p_attribute_category VARCHAR2,
3929 p_attribute1 VARCHAR2,
3930 p_attribute2 VARCHAR2,
3931 p_attribute3 VARCHAR2,
3932 p_attribute4 VARCHAR2,
3933 p_attribute5 VARCHAR2,
3934 p_attribute6 VARCHAR2,
3935 p_attribute7 VARCHAR2,
3936 p_attribute8 VARCHAR2,
3937 p_attribute9 VARCHAR2,
3938 p_attribute10 VARCHAR2,
3939 p_attribute11 VARCHAR2,
3940 p_attribute12 VARCHAR2,
3941 p_attribute13 VARCHAR2,
3942 p_attribute14 VARCHAR2,
3943 p_attribute15 VARCHAR2,
3944 p_global_attribute_category VARCHAR2,
3945 p_global_attribute1 VARCHAR2,
3946 p_global_attribute2 VARCHAR2,
3947 p_global_attribute3 VARCHAR2,
3948 p_global_attribute4 VARCHAR2,
3949 p_global_attribute5 VARCHAR2,
3950 p_global_attribute6 VARCHAR2,
3951 p_global_attribute7 VARCHAR2,
3952 p_global_attribute8 VARCHAR2,
3953 p_global_attribute9 VARCHAR2,
3954 p_global_attribute10 VARCHAR2,
3955 p_global_attribute11 VARCHAR2,
3956 p_global_attribute12 VARCHAR2,
3957 p_global_attribute13 VARCHAR2,
3958 p_global_attribute14 VARCHAR2,
3959 p_global_attribute15 VARCHAR2,
3960 p_numeric1 NUMBER,
3961 p_numeric2 NUMBER,
3962 p_numeric3 NUMBER,
3963 p_numeric4 NUMBER,
3964 p_numeric5 NUMBER,
3965 p_numeric6 NUMBER,
3966 p_numeric7 NUMBER,
3967 p_numeric8 NUMBER,
3968 p_numeric9 NUMBER,
3969 p_numeric10 NUMBER,
3970 p_char1 VARCHAR2,
3971 p_char2 VARCHAR2,
3972 p_char3 VARCHAR2,
3973 p_char4 VARCHAR2,
3974 p_char5 VARCHAR2,
3975 p_char6 VARCHAR2,
3976 p_char7 VARCHAR2,
3977 p_char8 VARCHAR2,
3978 p_char9 VARCHAR2,
3979 p_char10 VARCHAR2,
3980 p_date1 DATE,
3981 p_date2 DATE,
3982 p_date3 DATE,
3983 p_date4 DATE,
3984 p_date5 DATE,
3985 p_date6 DATE,
3986 p_date7 DATE,
3987 p_date8 DATE,
3988 p_date9 DATE,
3989 p_date10 DATE,
3990 p_interface_entity_code VARCHAR2,
3991 p_interface_tax_line_id NUMBER,
3992 p_taxing_juris_geography_id NUMBER,
3993 p_adjusted_doc_tax_line_id NUMBER,
3994 p_object_version_number NUMBER,
3995 p_created_by NUMBER,
3996 p_creation_date DATE,
3997 p_last_updated_by NUMBER,
3998 p_last_update_date DATE,
3999 p_last_update_login NUMBER) IS
4000
4001 l_return_status VARCHAR2(1000);
4002 l_msg_count NUMBER;
4003 l_msg_data VARCHAR2(1000);
4004
4005 BEGIN
4006
4007 g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
4008
4009 IF (g_level_procedure >= g_current_runtime_level ) THEN
4010 FND_LOG.STRING(g_level_procedure,
4011 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Delete_Row.BEGIN',
4012 'ZX_TRL_DETAIL_OVERRIDE_PKG: Delete_Row (+)');
4013 END IF;
4014
4015 IF (g_level_procedure >= g_current_runtime_level ) THEN
4016 FND_LOG.STRING(g_level_procedure,
4017 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Delete_Row',
4018 'Update zx_lines for delete and cancel flag (+)');
4019 END IF;
4020
4021 UPDATE ZX_LINES
4022 SET DELETE_FLAG = 'Y',
4023 SYNC_WITH_PRVDR_FLAG = DECODE(p_tax_provider_id,
4024 NULL, 'N', 'Y'),
4025 OBJECT_VERSION_NUMBER = NVL(p_object_version_number, OBJECT_VERSION_NUMBER + 1)
4026 WHERE TAX_LINE_ID = p_tax_line_id;
4027
4028 IF (g_level_procedure >= g_current_runtime_level ) THEN
4029 FND_LOG.STRING(g_level_procedure,
4030 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Delete_Row',
4031 'Update zx_lines for delete and cancel flag (-)');
4032 END IF;
4033
4034 IF (g_level_procedure >= g_current_runtime_level ) THEN
4035 FND_LOG.STRING(g_level_procedure,
4036 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Delete_Row.END',
4037 'ZX_TRL_DETAIL_OVERRIDE_PKG: Delete_Row (-)');
4038 END IF;
4039 END Delete_Row;
4040
4041 PROCEDURE Override_Row
4042 (p_application_id NUMBER,
4043 p_entity_code VARCHAR2,
4044 p_event_class_code VARCHAR2,
4045 p_trx_id NUMBER,
4046 p_trx_line_id NUMBER,
4047 p_trx_level_type VARCHAR2,
4048 p_event_id NUMBER) IS
4049
4050 l_transaction_rec ZX_API_PUB.transaction_rec_type;
4051 l_return_status VARCHAR2(80);
4052
4053 BEGIN
4054
4055 g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
4056
4057 IF (g_level_procedure >= g_current_runtime_level ) THEN
4058 FND_LOG.STRING(g_level_procedure,
4059 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Override_Row.BEGIN',
4060 'ZX_TRL_DETAIL_OVERRIDE_PKG: Override_Row(+)');
4061 END IF;
4062
4063 --
4064 -- obtain lock before update ZX_LINES_DET_FACTORS
4065 --
4066 l_transaction_rec.application_id := p_application_id;
4067 l_transaction_rec.entity_code := p_entity_code;
4068 l_transaction_rec.event_class_code := p_event_class_code;
4069 l_transaction_rec.trx_id := p_trx_id;
4070
4071 ZX_LINES_DET_FACTORS_PKG.lock_line_det_factors(
4072 l_transaction_rec,
4073 l_return_status );
4074
4075 IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
4076 UPDATE ZX_LINES_DET_FACTORS
4077 SET EVENT_ID = p_event_id
4078 WHERE APPLICATION_ID = p_application_id
4079 AND ENTITY_CODE = p_entity_code
4080 AND EVENT_CLASS_CODE = p_event_class_code
4081 AND TRX_ID = p_trx_id
4082 AND TRX_LEVEL_TYPE = p_trx_level_type
4083 AND TRX_LINE_ID = p_trx_line_id;
4084 END IF;
4085
4086 IF (g_level_procedure >= g_current_runtime_level ) THEN
4087 FND_LOG.STRING(g_level_procedure,
4088 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Override_Row.END',
4089 'ZX_TRL_DETAIL_OVERRIDE_PKG: Override_Row (-)');
4090 END IF;
4091
4092 END Override_Row;
4093
4094 PROCEDURE lock_dtl_tax_lines_for_doc
4095 (p_application_id IN NUMBER,
4096 p_entity_code IN VARCHAR2,
4097 p_event_class_code IN VARCHAR2,
4098 p_trx_id IN NUMBER,
4099 x_return_status OUT NOCOPY VARCHAR2,
4100 x_error_buffer OUT NOCOPY VARCHAR2) IS
4101
4102 l_return_status VARCHAR2(1000);
4103
4104 /*Cursor to Lock the tax lines for the entire document*/
4105 CURSOR lock_dtl_tax_lines_for_doc_csr(c_application_id NUMBER,
4106 c_event_class_code VARCHAR2,
4107 c_entity_code VARCHAR2,
4108 c_trx_id NUMBER) IS
4109 SELECT *
4110 FROM ZX_LINES
4111 WHERE application_id = c_application_id
4112 AND entity_code = c_entity_code
4113 AND event_class_code = c_event_class_code
4114 AND trx_id = c_trx_id
4115 FOR UPDATE NOWAIT;
4116
4117 BEGIN
4118 x_return_status := FND_API.G_RET_STS_SUCCESS;
4119
4120 g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
4121
4122 IF (g_level_procedure >= g_current_runtime_level ) THEN
4123 FND_LOG.STRING(g_level_procedure,
4124 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.lock_dtl_tax_lines_for_doc.BEGIN',
4125 'ZX_TRL_DETAIL_OVERRIDE_PKG: lock_dtl_tax_lines_for_doc (+)');
4126 END IF;
4127
4128 OPEN lock_dtl_tax_lines_for_doc_csr(p_application_id,
4129 p_event_class_code,
4130 p_entity_code,
4131 p_trx_id);
4132 CLOSE lock_dtl_tax_lines_for_doc_csr;
4133
4134 IF (g_level_procedure >= g_current_runtime_level ) THEN
4135 FND_LOG.STRING(g_level_procedure,
4136 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.lock_dtl_tax_lines_for_doc.END',
4137 'ZX_TRL_DETAIL_OVERRIDE_PKG: lock_dtl_tax_lines_for_doc (-)');
4138 END IF;
4139 EXCEPTION
4140 WHEN OTHERS THEN
4141 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4142 x_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
4143
4144 FND_MESSAGE.SET_NAME('ZX','ZX_UNEXPECTED_ERROR');
4145 FND_MSG_PUB.Add;
4146
4147 IF (g_level_procedure >= g_current_runtime_level ) THEN
4148 FND_LOG.STRING(g_level_procedure,
4149 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.lock_dtl_tax_lines_for_doc',
4150 'Exception:' ||x_error_buffer);
4151 END IF;
4152 END lock_dtl_tax_lines_for_doc;
4153
4154
4155 END ZX_TRL_DETAIL_OVERRIDE_PKG;