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