[Home] [Help]
PACKAGE BODY: APPS.ZX_TRL_SUMMARY_OVERRIDE_PKG
Source
1 PACKAGE BODY ZX_TRL_SUMMARY_OVERRIDE_PKG AS
2 /* $Header: zxriovrsumlnpkgb.pls 120.53.12010000.13 2009/02/03 13:21:21 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_summary_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_trx_id NUMBER,
20 p_summary_tax_line_number NUMBER,
21 p_trx_number VARCHAR2,
22 p_applied_from_application_id NUMBER,
23 p_applied_from_evt_class_code VARCHAR2,--reduced size p_applied_from_event_class_code
24 p_applied_from_entity_code VARCHAR2,
25 p_applied_from_trx_id NUMBER,
26 p_applied_from_trx_level_type VARCHAR2,
27 p_applied_from_line_id NUMBER,
28 p_adjusted_doc_application_id NUMBER,
29 p_adjusted_doc_entity_code VARCHAR2,
30 p_adjusted_doc_evt_class_code VARCHAR2,--reduced size p_adjusted_doc_event_class_code
31 p_adjusted_doc_trx_id NUMBER,
32 p_adjusted_doc_trx_level_type VARCHAR2,
33 p_applied_to_application_id NUMBER,
34 p_applied_to_event_class_code VARCHAR2,
35 p_applied_to_entity_code VARCHAR2,
36 p_applied_to_trx_id NUMBER,
37 p_applied_to_trx_level_type VARCHAR2,
38 p_applied_to_line_id NUMBER,
39 p_tax_exemption_id NUMBER,
40 p_tax_rate_before_exemption NUMBER,
41 p_tax_rate_name_before_exempt VARCHAR2, --reduced size p_tax_rate_name_before_exemption
42 p_exempt_rate_modifier NUMBER,
43 p_exempt_certificate_number VARCHAR2,
44 p_exempt_reason VARCHAR2,
45 p_exempt_reason_code VARCHAR2,
46 p_tax_rate_before_exception NUMBER,
47 p_tax_rate_name_before_except VARCHAR2, --reduced size p_tax_rate_name_before_exception
48 p_tax_exception_id NUMBER,
49 p_exception_rate NUMBER,
50 p_content_owner_id NUMBER,
51 p_tax_regime_code VARCHAR2,
52 p_tax VARCHAR2,
53 p_tax_status_code VARCHAR2,
54 p_tax_rate_id NUMBER,
55 p_tax_rate_code VARCHAR2,
56 p_tax_rate NUMBER,
57 p_tax_amt NUMBER,
58 p_tax_amt_tax_curr NUMBER,
59 p_tax_amt_funcl_curr NUMBER,
60 p_tax_jurisdiction_code VARCHAR2,
61 p_total_rec_tax_amt NUMBER,
62 p_total_rec_tax_amt_func_curr NUMBER,--reduced size p_total_rec_tax_amt_funcl_curr
63 p_total_rec_tax_amt_tax_curr NUMBER,
64 p_total_nrec_tax_amt NUMBER,
65 p_total_nrec_tax_amt_func_curr NUMBER,--reduced size p_total_nrec_tax_amt_funcl_curr
66 p_total_nrec_tax_amt_tax_curr NUMBER,
67 p_ledger_id NUMBER,
68 p_legal_entity_id NUMBER,
69 p_establishment_id NUMBER,
70 p_currency_conversion_date DATE,
71 p_currency_conversion_type VARCHAR2,
72 p_currency_conversion_rate NUMBER,
73 p_summarization_template_id NUMBER,
74 p_taxable_basis_formula VARCHAR2,
75 p_tax_calculation_formula VARCHAR2,
76 p_historical_flag VARCHAR2,
77 p_cancel_flag VARCHAR2,
78 p_delete_flag VARCHAR2,
79 p_tax_amt_included_flag VARCHAR2,
80 p_compounding_tax_flag VARCHAR2,
81 p_self_assessed_flag VARCHAR2,
82 p_overridden_flag VARCHAR2,
83 p_reporting_only_flag VARCHAR2,
84 p_assoc_child_frozen_flag VARCHAR2,--reduced size p_Associated_Child_Frozen_Flag
85 p_copied_from_other_doc_flag VARCHAR2,
86 p_manually_entered_flag VARCHAR2,
87 p_mrc_tax_line_flag VARCHAR2,
88 p_last_manual_entry VARCHAR2,
89 p_record_type_code VARCHAR2,
90 p_tax_provider_id NUMBER,
91 p_tax_only_line_flag VARCHAR2,
92 p_adjust_tax_amt_flag VARCHAR2,
93 p_attribute_category VARCHAR2,
94 p_attribute1 VARCHAR2,
95 p_attribute2 VARCHAR2,
96 p_attribute3 VARCHAR2,
97 p_attribute4 VARCHAR2,
98 p_attribute5 VARCHAR2,
99 p_attribute6 VARCHAR2,
100 p_attribute7 VARCHAR2,
101 p_attribute8 VARCHAR2,
102 p_attribute9 VARCHAR2,
103 p_attribute10 VARCHAR2,
104 p_attribute11 VARCHAR2,
105 p_attribute12 VARCHAR2,
106 p_attribute13 VARCHAR2,
107 p_attribute14 VARCHAR2,
108 p_attribute15 VARCHAR2,
109 p_global_attribute_category VARCHAR2,
110 p_global_attribute1 VARCHAR2,
111 p_global_attribute2 VARCHAR2,
112 p_global_attribute3 VARCHAR2,
113 p_global_attribute4 VARCHAR2,
114 p_global_attribute5 VARCHAR2,
115 p_global_attribute6 VARCHAR2,
116 p_global_attribute7 VARCHAR2,
117 p_global_attribute8 VARCHAR2,
118 p_global_attribute9 VARCHAR2,
119 p_global_attribute10 VARCHAR2,
120 p_global_attribute11 VARCHAR2,
121 p_global_attribute12 VARCHAR2,
122 p_global_attribute13 VARCHAR2,
123 p_global_attribute14 VARCHAR2,
124 p_global_attribute15 VARCHAR2,
125 p_global_attribute16 VARCHAR2,
126 p_global_attribute17 VARCHAR2,
127 p_global_attribute18 VARCHAR2,
128 p_global_attribute19 VARCHAR2,
129 p_global_attribute20 VARCHAR2,
130 p_object_version_number NUMBER,
131 p_created_by NUMBER,
132 p_creation_date DATE,
133 p_last_updated_by NUMBER,
134 p_last_update_date DATE,
135 p_last_update_login NUMBER) IS
136
137 CURSOR C IS
138 SELECT rowid
139 FROM ZX_LINES_SUMMARY
140 WHERE SUMMARY_TAX_LINE_ID = p_summary_tax_line_id;
141
142 BEGIN
143 g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
144
145 IF (g_level_procedure >= g_current_runtime_level ) THEN
146 FND_LOG.STRING(g_level_procedure,
147 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Insert_Row.BEGIN',
148 'ZX_TRL_SUMMARY_OVERRIDE_PKG: Insert_Row (+)');
149 END IF;
150
151 IF (g_level_procedure >= g_current_runtime_level ) THEN
152 FND_LOG.STRING(g_level_procedure,
153 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Insert_Row',
154 'Insert into zx_lines_summary (+)');
155 END IF;
156
157 INSERT INTO ZX_LINES_SUMMARY (SUMMARY_TAX_LINE_ID,
158 INTERNAL_ORGANIZATION_ID,
159 APPLICATION_ID,
160 ENTITY_CODE,
161 EVENT_CLASS_CODE,
162 TRX_ID,
163 TRX_NUMBER,
164 SUMMARY_TAX_LINE_NUMBER,
165 APPLIED_FROM_APPLICATION_ID,
166 APPLIED_FROM_EVENT_CLASS_CODE,
167 APPLIED_FROM_ENTITY_CODE,
168 APPLIED_FROM_TRX_ID,
169 APPLIED_FROM_TRX_LEVEL_TYPE,
170 APPLIED_FROM_LINE_ID,
171 ADJUSTED_DOC_APPLICATION_ID,
172 ADJUSTED_DOC_ENTITY_CODE,
173 ADJUSTED_DOC_EVENT_CLASS_CODE,
174 ADJUSTED_DOC_TRX_ID,
175 ADJUSTED_DOC_TRX_LEVEL_TYPE,
176 APPLIED_TO_APPLICATION_ID,
177 APPLIED_TO_EVENT_CLASS_CODE,
178 APPLIED_TO_ENTITY_CODE,
179 APPLIED_TO_TRX_ID,
180 APPLIED_TO_TRX_LEVEL_TYPE,
181 APPLIED_TO_LINE_ID,
182 TAX_EXEMPTION_ID,
183 TAX_RATE_BEFORE_EXEMPTION,
184 TAX_RATE_NAME_BEFORE_EXEMPTION,
185 EXEMPT_RATE_MODIFIER,
186 EXEMPT_CERTIFICATE_NUMBER,
187 EXEMPT_REASON,
188 EXEMPT_REASON_CODE,
189 TAX_RATE_BEFORE_EXCEPTION,
190 TAX_RATE_NAME_BEFORE_EXCEPTION,
191 TAX_EXCEPTION_ID,
192 EXCEPTION_RATE,
193 CONTENT_OWNER_ID,
194 TAX_REGIME_CODE,
195 TAX,
196 TAX_STATUS_CODE,
197 TAX_RATE_ID,
198 TAX_RATE_CODE,
199 TAX_RATE,
200 TAX_JURISDICTION_CODE,
201 TAX_AMT,
202 TAX_AMT_TAX_CURR,
203 TAX_AMT_FUNCL_CURR,
204 TOTAL_REC_TAX_AMT,
205 TOTAL_REC_TAX_AMT_FUNCL_CURR,
206 TOTAL_REC_TAX_AMT_TAX_CURR,
207 TOTAL_NREC_TAX_AMT,
208 TOTAL_NREC_TAX_AMT_FUNCL_CURR,
209 TOTAL_NREC_TAX_AMT_TAX_CURR,
210 LEDGER_ID,
211 LEGAL_ENTITY_ID,
212 ESTABLISHMENT_ID,
213 CURRENCY_CONVERSION_DATE,
214 CURRENCY_CONVERSION_TYPE,
215 CURRENCY_CONVERSION_RATE,
216 SUMMARIZATION_TEMPLATE_ID,
217 TAXABLE_BASIS_FORMULA,
218 TAX_CALCULATION_FORMULA,
219 HISTORICAL_FLAG,
220 CANCEL_FLAG,
221 DELETE_FLAG,
222 RECORD_TYPE_CODE,
223 TAX_AMT_INCLUDED_FLAG,
224 SELF_ASSESSED_FLAG,
225 OVERRIDDEN_FLAG,
226 COMPOUNDING_TAX_FLAG,
227 TAX_PROVIDER_ID,
228 MANUALLY_ENTERED_FLAG,
229 TAX_ONLY_LINE_FLAG,
230 ADJUST_TAX_AMT_FLAG,
231 MRC_TAX_LINE_FLAG,
232 REPORTING_ONLY_FLAG,
233 ASSOCIATED_CHILD_FROZEN_FLAG,
234 COPIED_FROM_OTHER_DOC_FLAG,
235 LAST_MANUAL_ENTRY,
236 ATTRIBUTE_CATEGORY,
237 ATTRIBUTE1,
238 ATTRIBUTE2,
239 ATTRIBUTE3,
240 ATTRIBUTE4,
241 ATTRIBUTE5,
242 ATTRIBUTE6,
243 ATTRIBUTE7,
244 ATTRIBUTE8,
245 ATTRIBUTE9,
246 ATTRIBUTE10,
247 ATTRIBUTE11,
248 ATTRIBUTE12,
249 ATTRIBUTE13,
250 ATTRIBUTE14,
251 ATTRIBUTE15,
252 GLOBAL_ATTRIBUTE_CATEGORY,
253 GLOBAL_ATTRIBUTE1,
254 GLOBAL_ATTRIBUTE2,
255 GLOBAL_ATTRIBUTE3,
256 GLOBAL_ATTRIBUTE4,
257 GLOBAL_ATTRIBUTE5,
258 GLOBAL_ATTRIBUTE6,
259 GLOBAL_ATTRIBUTE7,
260 GLOBAL_ATTRIBUTE8,
261 GLOBAL_ATTRIBUTE9,
262 GLOBAL_ATTRIBUTE10,
263 GLOBAL_ATTRIBUTE11,
264 GLOBAL_ATTRIBUTE12,
265 GLOBAL_ATTRIBUTE13,
266 GLOBAL_ATTRIBUTE14,
267 GLOBAL_ATTRIBUTE15,
268 OBJECT_VERSION_NUMBER,
269 CREATED_BY,
270 CREATION_DATE,
271 LAST_UPDATED_BY,
272 LAST_UPDATE_DATE,
273 LAST_UPDATE_LOGIN)
274 VALUES (p_summary_tax_line_id,
275 p_internal_organization_id,
276 p_application_id,
277 p_entity_code,
278 p_event_class_code,
279 p_trx_id,
280 p_trx_number,
281 p_summary_tax_line_number,
282 p_applied_from_application_id,
283 p_applied_from_evt_class_code,
284 p_applied_from_entity_code,
285 p_applied_from_trx_id,
286 p_applied_from_trx_level_type,
287 p_applied_from_line_id,
288 p_adjusted_doc_application_id,
289 p_adjusted_doc_entity_code,
290 p_adjusted_doc_evt_class_code,
291 p_adjusted_doc_trx_id,
292 p_adjusted_doc_trx_level_type,
293 p_applied_to_application_id,
294 p_applied_to_event_class_code,
295 p_applied_to_entity_code,
296 p_applied_to_trx_id,
297 p_applied_to_trx_level_type,
298 p_applied_to_line_id,
299 p_tax_exemption_id,
300 p_tax_rate_before_exemption,
301 p_tax_rate_name_before_exempt,
302 p_exempt_rate_modifier,
303 p_exempt_certificate_number,
304 p_exempt_reason,
305 p_exempt_reason_code,
306 p_tax_rate_before_exception,
307 p_tax_rate_name_before_except,
308 p_tax_exception_id,
309 p_exception_rate,
310 p_content_owner_id,
311 p_tax_regime_code,
312 p_tax,
313 p_tax_status_code,
314 p_tax_rate_id,
315 p_tax_rate_code,
316 p_tax_rate,
317 p_tax_jurisdiction_code,
318 p_tax_amt,
319 p_tax_amt_tax_curr,
320 p_tax_amt_funcl_curr,
321 p_total_rec_tax_amt,
322 p_total_rec_tax_amt_func_curr,
323 p_total_rec_tax_amt_tax_curr,
324 p_total_nrec_tax_amt,
325 p_total_nrec_tax_amt_func_curr,
326 p_total_nrec_tax_amt_tax_curr,
327 p_ledger_id,
328 p_legal_entity_id,
329 p_establishment_id,
330 p_currency_conversion_date,
331 p_currency_conversion_type,
332 p_currency_conversion_rate,
333 p_summarization_template_id,
334 p_taxable_basis_formula,
335 p_tax_calculation_formula,
336 'N', -- historical_flag
337 p_cancel_flag,
338 p_delete_flag,
339 p_record_type_code,
340 p_tax_amt_included_flag,
341 p_self_assessed_flag,
342 p_overridden_flag,
343 p_compounding_tax_flag,
344 p_tax_provider_id,
345 p_manually_entered_flag,
346 p_tax_only_line_flag,
347 'Y', --p_adjust_tax_amt_flag,
348 'N', -- mrc_tax_line_flag
349 'N', -- reporting_only_flag
350 'N', -- associated_child_frozen_flag
351 'N', -- copied_from_other_doc_flag
352 decode(p_cancel_flag,'N',p_last_manual_entry,'TAX_AMOUNT'), --setting last_manual_entry flag on the basis of cancel_flag.
353 p_attribute_category,
354 p_attribute1,
355 p_attribute2,
356 p_attribute3,
357 p_attribute4,
358 p_attribute5,
359 p_attribute6,
360 p_attribute7,
361 p_attribute8,
362 p_attribute9,
363 p_attribute10,
364 p_attribute11,
365 p_attribute12,
366 p_attribute13,
367 p_attribute14,
368 p_attribute15,
369 p_global_attribute_category,
370 p_global_attribute1,
371 p_global_attribute2,
372 p_global_attribute3,
373 p_global_attribute4,
374 p_global_attribute5,
375 p_global_attribute6,
376 p_global_attribute7,
377 p_global_attribute8,
378 p_global_attribute9,
379 p_global_attribute10,
380 p_global_attribute11,
381 p_global_attribute12,
382 p_global_attribute13,
383 p_global_attribute14,
384 p_global_attribute15,
385 1, --p_object_version_number,
386 fnd_global.user_id,
387 sysdate,
388 fnd_global.user_id,
389 sysdate,
390 fnd_global.login_id);
391
392 OPEN C;
393 FETCH C INTO x_rowid;
394
395 IF (C%NOTFOUND) THEN
396 CLOSE C;
397 RAISE NO_DATA_FOUND;
398 END IF;
399
400 CLOSE C;
401
402 IF (g_level_procedure >= g_current_runtime_level ) THEN
403 FND_LOG.STRING(g_level_procedure,
404 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Insert_Row',
405 'Insert into zx_lines_summary (-)');
406
407 FND_LOG.STRING(g_level_procedure,
408 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Insert_Row.END',
409 'ZX_TRL_SUMMARY_OVERRIDE_PKG: Insert_Row (-)');
410 END IF;
411
412 END Insert_Row;
413
414 PROCEDURE Lock_Row
415 (x_rowid IN OUT NOCOPY VARCHAR2,
416 p_summary_tax_line_id NUMBER,
417 p_internal_organization_id NUMBER,
418 p_application_id NUMBER,
419 p_entity_code VARCHAR2,
420 p_event_class_code VARCHAR2,
421 p_trx_id NUMBER,
422 p_summary_tax_line_number NUMBER,
423 p_trx_number VARCHAR2,
424 p_applied_from_application_id NUMBER,
425 p_applied_from_evt_class_code VARCHAR2,--reduced size p_applied_from_event_class_code
426 p_applied_from_entity_code VARCHAR2,
427 p_applied_from_trx_id NUMBER,
428 p_applied_from_trx_level_type VARCHAR2,
429 p_applied_from_line_id NUMBER,
430 p_adjusted_doc_application_id NUMBER,
431 p_adjusted_doc_entity_code VARCHAR2,
432 p_adjusted_doc_evt_class_code VARCHAR2,--reduced size p_adjusted_doc_event_class_code
433 p_adjusted_doc_trx_id NUMBER,
434 p_adjusted_doc_trx_level_type VARCHAR2,
435 p_applied_to_application_id NUMBER,
436 p_applied_to_event_class_code VARCHAR2,
437 p_applied_to_entity_code VARCHAR2,
438 p_applied_to_trx_id NUMBER,
439 p_applied_to_trx_level_type VARCHAR2,
440 p_applied_to_line_id NUMBER,
441 p_tax_exemption_id NUMBER,
442 p_tax_rate_before_exemption NUMBER,
443 p_tax_rate_name_before_exempt VARCHAR2, --reduced size p_tax_rate_name_before_exemption
444 p_exempt_rate_modifier NUMBER,
445 p_exempt_certificate_number VARCHAR2,
446 p_exempt_reason VARCHAR2,
447 p_exempt_reason_code VARCHAR2,
448 p_tax_rate_before_exception NUMBER,
449 p_tax_rate_name_before_except VARCHAR2, --reduced size p_tax_rate_name_before_exception
450 p_tax_exception_id NUMBER,
451 p_exception_rate NUMBER,
452 p_content_owner_id NUMBER,
453 p_tax_regime_code VARCHAR2,
454 p_tax VARCHAR2,
455 p_tax_status_code VARCHAR2,
456 p_tax_rate_id NUMBER,
457 p_tax_rate_code VARCHAR2,
458 p_tax_rate NUMBER,
459 p_tax_amt NUMBER,
460 p_tax_amt_tax_curr NUMBER,
461 p_tax_amt_funcl_curr NUMBER,
462 p_tax_jurisdiction_code VARCHAR2,
463 p_total_rec_tax_amt NUMBER,
464 p_total_rec_tax_amt_func_curr NUMBER,--reduced size p_total_rec_tax_amt_funcl_curr
465 p_total_rec_tax_amt_tax_curr NUMBER,
466 p_total_nrec_tax_amt NUMBER,
467 p_total_nrec_tax_amt_func_curr NUMBER,--reduced size p_total_nrec_tax_amt_funcl_curr
468 p_total_nrec_tax_amt_tax_curr NUMBER,
469 p_ledger_id NUMBER,
470 p_legal_entity_id NUMBER,
471 p_establishment_id NUMBER,
472 p_currency_conversion_date DATE,
473 p_currency_conversion_type VARCHAR2,
474 p_currency_conversion_rate NUMBER,
475 p_summarization_template_id NUMBER,
476 p_taxable_basis_formula VARCHAR2,
477 p_tax_calculation_formula VARCHAR2,
478 p_historical_flag VARCHAR2,
479 p_cancel_flag VARCHAR2,
480 p_delete_flag VARCHAR2,
481 p_tax_amt_included_flag VARCHAR2,
482 p_compounding_tax_flag VARCHAR2,
483 p_self_assessed_flag VARCHAR2,
484 p_overridden_flag VARCHAR2,
485 p_reporting_only_flag VARCHAR2,
486 p_assoc_child_frozen_flag VARCHAR2,--reduced size p_Associated_Child_Frozen_Flag
487 p_copied_from_other_doc_flag VARCHAR2,
488 p_manually_entered_flag VARCHAR2,
489 p_mrc_tax_line_flag VARCHAR2,
490 p_last_manual_entry VARCHAR2,
491 p_record_type_code VARCHAR2,
492 p_tax_provider_id NUMBER,
493 p_tax_only_line_flag VARCHAR2,
494 p_adjust_tax_amt_flag VARCHAR2,
495 p_attribute_category VARCHAR2,
496 p_attribute1 VARCHAR2,
497 p_attribute2 VARCHAR2,
498 p_attribute3 VARCHAR2,
499 p_attribute4 VARCHAR2,
500 p_attribute5 VARCHAR2,
501 p_attribute6 VARCHAR2,
502 p_attribute7 VARCHAR2,
503 p_attribute8 VARCHAR2,
504 p_attribute9 VARCHAR2,
505 p_attribute10 VARCHAR2,
506 p_attribute11 VARCHAR2,
507 p_attribute12 VARCHAR2,
508 p_attribute13 VARCHAR2,
509 p_attribute14 VARCHAR2,
510 p_attribute15 VARCHAR2,
511 p_global_attribute_category VARCHAR2,
512 p_global_attribute1 VARCHAR2,
513 p_global_attribute2 VARCHAR2,
514 p_global_attribute3 VARCHAR2,
515 p_global_attribute4 VARCHAR2,
516 p_global_attribute5 VARCHAR2,
517 p_global_attribute6 VARCHAR2,
518 p_global_attribute7 VARCHAR2,
519 p_global_attribute8 VARCHAR2,
520 p_global_attribute9 VARCHAR2,
521 p_global_attribute10 VARCHAR2,
522 p_global_attribute11 VARCHAR2,
523 p_global_attribute12 VARCHAR2,
524 p_global_attribute13 VARCHAR2,
525 p_global_attribute14 VARCHAR2,
526 p_global_attribute15 VARCHAR2,
527 p_global_attribute16 VARCHAR2,
528 p_global_attribute17 VARCHAR2,
529 p_global_attribute18 VARCHAR2,
530 p_global_attribute19 VARCHAR2,
531 p_global_attribute20 VARCHAR2,
532 p_object_version_number NUMBER,
533 p_created_by NUMBER,
534 p_creation_date DATE,
535 p_last_updated_by NUMBER,
536 p_last_update_date DATE,
537 p_last_update_login NUMBER) IS
538
539 CURSOR summary_lines_csr IS
540 SELECT SUMMARY_TAX_LINE_ID,
541 INTERNAL_ORGANIZATION_ID,
542 APPLICATION_ID,
543 ENTITY_CODE,
544 EVENT_CLASS_CODE,
545 TRX_ID,
546 SUMMARY_TAX_LINE_NUMBER,
547 TRX_NUMBER,
548 APPLIED_FROM_APPLICATION_ID,
549 APPLIED_FROM_EVENT_CLASS_CODE,
550 APPLIED_FROM_ENTITY_CODE,
551 APPLIED_FROM_TRX_ID,
552 APPLIED_FROM_TRX_LEVEL_TYPE,
553 APPLIED_FROM_LINE_ID,
554 ADJUSTED_DOC_APPLICATION_ID,
555 ADJUSTED_DOC_ENTITY_CODE,
556 ADJUSTED_DOC_EVENT_CLASS_CODE,
557 ADJUSTED_DOC_TRX_ID,
558 ADJUSTED_DOC_TRX_LEVEL_TYPE,
559 APPLIED_TO_APPLICATION_ID,
560 APPLIED_TO_EVENT_CLASS_CODE,
561 APPLIED_TO_ENTITY_CODE,
562 APPLIED_TO_TRX_ID,
563 APPLIED_TO_TRX_LEVEL_TYPE,
564 APPLIED_TO_LINE_ID,
565 TAX_EXEMPTION_ID,
566 TAX_RATE_BEFORE_EXEMPTION,
567 TAX_RATE_NAME_BEFORE_EXEMPTION,
568 EXEMPT_RATE_MODIFIER,
569 EXEMPT_CERTIFICATE_NUMBER,
570 EXEMPT_REASON,
571 EXEMPT_REASON_CODE ,
572 TAX_RATE_BEFORE_EXCEPTION,
573 TAX_RATE_NAME_BEFORE_EXCEPTION,
574 TAX_EXCEPTION_ID,
575 EXCEPTION_RATE,
576 CONTENT_OWNER_ID,
577 TAX_REGIME_CODE,
578 TAX,
579 TAX_STATUS_CODE,
580 TAX_RATE_ID,
581 TAX_RATE_CODE,
582 TAX_RATE,
583 TAX_AMT,
584 TAX_AMT_TAX_CURR,
585 TAX_AMT_FUNCL_CURR,
586 TAX_JURISDICTION_CODE,
587 TOTAL_REC_TAX_AMT,
588 TOTAL_REC_TAX_AMT_FUNCL_CURR,
589 TOTAL_REC_TAX_AMT_TAX_CURR,
590 TOTAL_NREC_TAX_AMT,
591 TOTAL_NREC_TAX_AMT_FUNCL_CURR,
592 TOTAL_NREC_TAX_AMT_TAX_CURR,
593 LEDGER_ID,
594 LEGAL_ENTITY_ID,
595 ESTABLISHMENT_ID,
596 CURRENCY_CONVERSION_DATE,
597 CURRENCY_CONVERSION_TYPE,
598 CURRENCY_CONVERSION_RATE,
599 SUMMARIZATION_TEMPLATE_ID,
600 TAXABLE_BASIS_FORMULA,
601 TAX_CALCULATION_FORMULA,
602 HISTORICAL_FLAG,
603 CANCEL_FLAG,
604 DELETE_FLAG,
605 TAX_AMT_INCLUDED_FLAG,
606 COMPOUNDING_TAX_FLAG,
607 SELF_ASSESSED_FLAG,
608 OVERRIDDEN_FLAG,
609 REPORTING_ONLY_FLAG,
610 ASSOCIATED_CHILD_FROZEN_FLAG,
611 COPIED_FROM_OTHER_DOC_FLAG,
612 MANUALLY_ENTERED_FLAG,
613 MRC_TAX_LINE_FLAG,
614 LAST_MANUAL_ENTRY,
615 RECORD_TYPE_CODE,
616 TAX_PROVIDER_ID,
617 TAX_ONLY_LINE_FLAG,
618 ADJUST_TAX_AMT_FLAG,
619 ATTRIBUTE_CATEGORY,
620 ATTRIBUTE1,
621 ATTRIBUTE2,
622 ATTRIBUTE3,
623 ATTRIBUTE4,
624 ATTRIBUTE5,
625 ATTRIBUTE6,
626 ATTRIBUTE7,
627 ATTRIBUTE8,
628 ATTRIBUTE9,
629 ATTRIBUTE10,
630 ATTRIBUTE11,
631 ATTRIBUTE12,
632 ATTRIBUTE13,
633 ATTRIBUTE14,
634 ATTRIBUTE15,
635 GLOBAL_ATTRIBUTE_CATEGORY,
636 GLOBAL_ATTRIBUTE1,
637 GLOBAL_ATTRIBUTE2,
638 GLOBAL_ATTRIBUTE3,
639 GLOBAL_ATTRIBUTE4,
640 GLOBAL_ATTRIBUTE5,
641 GLOBAL_ATTRIBUTE6,
642 GLOBAL_ATTRIBUTE7,
643 GLOBAL_ATTRIBUTE8,
644 GLOBAL_ATTRIBUTE9,
645 GLOBAL_ATTRIBUTE10,
646 GLOBAL_ATTRIBUTE11,
647 GLOBAL_ATTRIBUTE12,
648 GLOBAL_ATTRIBUTE13,
649 GLOBAL_ATTRIBUTE14,
650 GLOBAL_ATTRIBUTE15,
651 GLOBAL_ATTRIBUTE16,
652 GLOBAL_ATTRIBUTE17,
653 GLOBAL_ATTRIBUTE18,
654 GLOBAL_ATTRIBUTE19,
655 GLOBAL_ATTRIBUTE20,
656 OBJECT_VERSION_NUMBER,
657 CREATED_BY,
658 CREATION_DATE,
659 LAST_UPDATED_BY,
660 LAST_UPDATE_DATE,
661 LAST_UPDATE_LOGIN
662 FROM ZX_LINES_SUMMARY
663 WHERE ROWID = X_Rowid;
664
665 Recinfo summary_lines_csr%ROWTYPE;
666 l_transaction_rec ZX_API_PUB.transaction_rec_type;
667 l_return_status VARCHAR2(1000);
668 BEGIN
669 g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
670
671 IF (g_level_procedure >= g_current_runtime_level ) THEN
672 FND_LOG.STRING(g_level_procedure,
673 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Lock_Row.BEGIN',
674 'ZX_TRL_SUMMARY_OVERRIDE_PKG: Lock_Row (+)');
675 END IF;
676
677 OPEN summary_lines_csr;
678 FETCH summary_lines_csr INTO Recinfo;
679
680 IF (summary_lines_csr%NOTFOUND) THEN
681 CLOSE summary_lines_csr;
682 FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
683 APP_EXCEPTION.Raise_Exception;
684 END IF;
685
686 CLOSE summary_lines_csr;
687
688 IF ((Recinfo.SUMMARY_TAX_LINE_ID = p_summary_tax_line_id) AND
689 (Recinfo.INTERNAL_ORGANIZATION_ID = p_internal_organization_id) AND
690 (Recinfo.APPLICATION_ID = p_application_id) AND
691 (Recinfo.ENTITY_CODE = p_entity_code) AND
692 (Recinfo.EVENT_CLASS_CODE = p_event_class_code) AND
693 (Recinfo.TRX_ID = p_trx_id) AND
694 (Recinfo.SUMMARY_TAX_LINE_NUMBER = p_summary_tax_line_number) AND
695 ((Recinfo.TRX_NUMBER = p_TRX_NUMBER) OR
696 ((Recinfo.TRX_NUMBER IS NULL) AND
697 (p_TRX_NUMBER IS NULL))) AND
698 ((Recinfo.APPLIED_FROM_APPLICATION_ID = p_APPLIED_FROM_APPLICATION_ID) OR
699 ((Recinfo.APPLIED_FROM_APPLICATION_ID IS NULL) AND
700 (p_APPLIED_FROM_APPLICATION_ID IS NULL))) AND
701 ((Recinfo.APPLIED_FROM_EVENT_CLASS_CODE = p_APPLIED_FROM_EVT_CLASS_CODE) OR
702 ((Recinfo.APPLIED_FROM_EVENT_CLASS_CODE IS NULL) AND
703 (p_APPLIED_FROM_EVT_CLASS_CODE IS NULL))) AND
704 ((Recinfo.APPLIED_FROM_ENTITY_CODE = p_APPLIED_FROM_ENTITY_CODE) OR
705 ((Recinfo.APPLIED_FROM_ENTITY_CODE IS NULL) AND
706 (p_APPLIED_FROM_ENTITY_CODE IS NULL))) AND
707 ((Recinfo.APPLIED_FROM_TRX_ID = p_APPLIED_FROM_TRX_ID) OR
708 ((Recinfo.APPLIED_FROM_TRX_ID IS NULL) AND
709 (p_APPLIED_FROM_TRX_ID IS NULL))) AND
710 ((Recinfo.APPLIED_FROM_TRX_LEVEL_TYPE = p_applied_from_trx_level_type) OR
711 ((Recinfo.APPLIED_FROM_TRX_LEVEL_TYPE IS NULL) AND
712 (p_applied_from_trx_level_type IS NULL))) AND
713 ((Recinfo.APPLIED_FROM_LINE_ID = p_APPLIED_FROM_LINE_ID) OR
714 ((Recinfo.APPLIED_FROM_LINE_ID IS NULL) AND
715 (p_APPLIED_FROM_LINE_ID IS NULL))) AND
716 ((Recinfo.ADJUSTED_DOC_APPLICATION_ID = p_ADJUSTED_DOC_APPLICATION_ID) OR
717 ((Recinfo.ADJUSTED_DOC_APPLICATION_ID IS NULL) AND
718 (p_ADJUSTED_DOC_APPLICATION_ID IS NULL))) AND
719 ((Recinfo.ADJUSTED_DOC_ENTITY_CODE = p_ADJUSTED_DOC_ENTITY_CODE) OR
720 ((Recinfo.ADJUSTED_DOC_ENTITY_CODE IS NULL) AND
721 (p_ADJUSTED_DOC_ENTITY_CODE IS NULL))) AND
722 ((Recinfo.ADJUSTED_DOC_EVENT_CLASS_CODE = p_ADJUSTED_DOC_EVT_CLASS_CODE) OR
723 ((Recinfo.ADJUSTED_DOC_EVENT_CLASS_CODE IS NULL) AND
724 (p_ADJUSTED_DOC_EVT_CLASS_CODE IS NULL))) AND
725 ((Recinfo.ADJUSTED_DOC_TRX_ID = p_ADJUSTED_DOC_TRX_ID) OR
726 ((Recinfo.ADJUSTED_DOC_TRX_ID IS NULL) AND
727 (p_ADJUSTED_DOC_TRX_ID IS NULL))) AND
728 ((Recinfo.ADJUSTED_DOC_TRX_LEVEL_TYPE = p_adjusted_doc_trx_level_type) OR
729 ((Recinfo.ADJUSTED_DOC_TRX_LEVEL_TYPE IS NULL) AND
730 (p_adjusted_doc_trx_level_type IS NULL))) AND
731 ((Recinfo.APPLIED_TO_APPLICATION_ID = p_APPLIED_TO_APPLICATION_ID) OR
732 ((Recinfo.APPLIED_TO_APPLICATION_ID IS NULL) AND
733 (p_APPLIED_TO_APPLICATION_ID IS NULL))) AND
734 ((Recinfo.APPLIED_TO_EVENT_CLASS_CODE = p_APPLIED_TO_EVENT_CLASS_CODE) OR
735 ((Recinfo.APPLIED_TO_EVENT_CLASS_CODE IS NULL) AND
736 (p_APPLIED_TO_EVENT_CLASS_CODE IS NULL))) AND
737 ((Recinfo.APPLIED_TO_ENTITY_CODE = p_APPLIED_TO_ENTITY_CODE) OR
738 ((Recinfo.APPLIED_TO_ENTITY_CODE IS NULL) AND
739 (p_APPLIED_TO_ENTITY_CODE IS NULL))) AND
740 ((Recinfo.APPLIED_TO_TRX_ID = p_APPLIED_TO_TRX_ID) OR
741 ((Recinfo.APPLIED_TO_TRX_ID IS NULL) AND
742 (p_APPLIED_TO_TRX_ID IS NULL))) AND
743 ((Recinfo.APPLIED_TO_TRX_LEVEL_TYPE = p_APPLIED_TO_TRX_LEVEL_TYPE) OR
744 ((Recinfo.APPLIED_TO_TRX_LEVEL_TYPE IS NULL) AND
745 (p_APPLIED_TO_TRX_LEVEL_TYPE IS NULL))) AND
746 ((Recinfo.APPLIED_TO_LINE_ID = p_APPLIED_TO_LINE_ID) OR
747 ((Recinfo.APPLIED_TO_LINE_ID IS NULL) AND
748 (p_APPLIED_TO_LINE_ID IS NULL))) AND
749 ((Recinfo.TAX_EXEMPTION_ID = p_TAX_EXEMPTION_ID) OR
750 ((Recinfo.TAX_EXEMPTION_ID IS NULL) AND
751 (p_TAX_EXEMPTION_ID IS NULL))) AND
752 ((Recinfo.TAX_RATE_BEFORE_EXEMPTION = p_TAX_RATE_BEFORE_EXEMPTION) OR
753 ((Recinfo.TAX_RATE_BEFORE_EXEMPTION IS NULL) AND
754 (p_TAX_RATE_BEFORE_EXEMPTION IS NULL))) AND
755 ((Recinfo.TAX_RATE_NAME_BEFORE_EXEMPTION = p_tax_rate_name_before_exempt) OR
756 ((Recinfo.TAX_RATE_NAME_BEFORE_EXEMPTION IS NULL) AND
757 (p_tax_rate_name_before_exempt IS NULL))) AND
758 ((Recinfo.EXEMPT_RATE_MODIFIER = p_EXEMPT_RATE_MODIFIER) OR
759 ((Recinfo.EXEMPT_RATE_MODIFIER IS NULL) AND
760 (p_EXEMPT_RATE_MODIFIER IS NULL))) AND
761 ((Recinfo.EXEMPT_CERTIFICATE_NUMBER = p_EXEMPT_CERTIFICATE_NUMBER) OR
762 ((Recinfo.EXEMPT_CERTIFICATE_NUMBER IS NULL) AND
763 (p_EXEMPT_CERTIFICATE_NUMBER IS NULL))) AND
764 ((Recinfo.EXEMPT_REASON = p_EXEMPT_REASON) OR
765 ((Recinfo.EXEMPT_REASON IS NULL) AND
766 (p_EXEMPT_REASON IS NULL))) AND
767 ((Recinfo.EXEMPT_REASON_CODE = p_EXEMPT_REASON_CODE) OR
768 ((Recinfo.EXEMPT_REASON_CODE IS NULL) AND
769 (p_EXEMPT_REASON_CODE IS NULL))) AND
770 ((Recinfo.TAX_RATE_BEFORE_EXCEPTION = p_TAX_RATE_BEFORE_EXCEPTION) OR
771 ((Recinfo.TAX_RATE_BEFORE_EXCEPTION IS NULL) AND
772 (p_TAX_RATE_BEFORE_EXCEPTION IS NULL))) AND
773 ((Recinfo.TAX_RATE_NAME_BEFORE_EXCEPTION = p_tax_rate_name_before_except) OR
774 ((Recinfo.TAX_RATE_NAME_BEFORE_EXCEPTION IS NULL) AND
775 (p_tax_rate_name_before_except IS NULL))) AND
776 ((Recinfo.TAX_EXCEPTION_ID = p_TAX_EXCEPTION_ID) OR
777 ((Recinfo.TAX_EXCEPTION_ID IS NULL) AND
778 (p_TAX_EXCEPTION_ID IS NULL))) AND
779 ((Recinfo.EXCEPTION_RATE = p_EXCEPTION_RATE) OR
780 ((Recinfo.EXCEPTION_RATE IS NULL) AND
781 (p_EXCEPTION_RATE IS NULL))) AND
782 ((Recinfo.CONTENT_OWNER_ID = p_CONTENT_OWNER_ID) OR
783 ((Recinfo.CONTENT_OWNER_ID IS NULL) AND
784 (p_CONTENT_OWNER_ID IS NULL))) AND
785 ((Recinfo.TAX_REGIME_CODE = p_tax_regime_code) OR
786 ((Recinfo.TAX_REGIME_CODE IS NULL) AND
787 (p_tax_regime_code IS NULL))) AND
788 ((Recinfo.TAX = p_tax ) OR
789 ((Recinfo.TAX IS NULL) AND
790 (p_tax IS NULL))) AND
791 ((Recinfo.TAX_STATUS_CODE = p_tax_status_code) OR
792 ((Recinfo.TAX_STATUS_CODE IS NULL) AND
793 (p_tax_status_code IS NULL))) AND
794 ((Recinfo.TAX_RATE_ID = p_tax_rate_id ) OR
795 ((Recinfo.TAX_RATE_ID IS NULL) AND
796 (p_tax_rate_id IS NULL))) AND
797 ((Recinfo.TAX_RATE_CODE = p_tax_rate_code) OR
798 ((Recinfo.TAX_RATE_CODE IS NULL) AND
799 (p_tax_rate_code IS NULL))) AND
800 ((Recinfo.TAX_RATE = p_tax_rate) OR
801 ((Recinfo.TAX_RATE IS NULL) AND
802 (p_tax_rate IS NULL))) AND
803 ((Recinfo.TAX_AMT = p_tax_amt) OR
804 ((Recinfo.TAX_AMT IS NULL) AND
805 (p_tax_amt IS NULL))) AND
806 ((Recinfo.TAX_AMT_TAX_CURR = p_TAX_AMT_TAX_CURR) OR
807 ((Recinfo.TAX_AMT_TAX_CURR IS NULL) AND
808 (p_TAX_AMT_TAX_CURR IS NULL))) AND
809 ((Recinfo.TAX_AMT_FUNCL_CURR = p_TAX_AMT_FUNCL_CURR) OR
810 ((Recinfo.TAX_AMT_FUNCL_CURR IS NULL) AND
811 (p_TAX_AMT_FUNCL_CURR IS NULL))) AND
812 ((Recinfo.TAX_JURISDICTION_CODE = p_tax_jurisdiction_code) OR
813 ((Recinfo.TAX_JURISDICTION_CODE IS NULL) AND
814 (p_tax_jurisdiction_code IS NULL))) AND
815 ((Recinfo.TOTAL_REC_TAX_AMT = p_total_rec_tax_amt) OR
816 ((Recinfo.TOTAL_REC_TAX_AMT IS NULL) AND
817 (p_total_rec_tax_amt IS NULL))) AND
818 ((Recinfo.TOTAL_REC_TAX_AMT_FUNCL_CURR = p_TOTAL_REC_TAX_AMT_FUNC_CURR) OR
819 ((Recinfo.TOTAL_REC_TAX_AMT_FUNCL_CURR IS NULL) AND
820 (p_TOTAL_REC_TAX_AMT_FUNC_CURR IS NULL))) AND
821 ((Recinfo.TOTAL_REC_TAX_AMT_TAX_CURR = p_TOTAL_REC_TAX_AMT_TAX_CURR) OR
822 ((Recinfo.TOTAL_REC_TAX_AMT_TAX_CURR IS NULL) AND
823 (p_TOTAL_REC_TAX_AMT_TAX_CURR IS NULL))) AND
824 ((Recinfo.TOTAL_NREC_TAX_AMT = p_total_nrec_tax_amt) OR
825 ((Recinfo.TOTAL_NREC_TAX_AMT IS NULL) AND
826 (p_total_nrec_tax_amt IS NULL))) AND
827 ((Recinfo.TOTAL_NREC_TAX_AMT_FUNCL_CURR = p_TOTAL_NREC_TAX_AMT_FUNC_CURR) OR
828 ((Recinfo.TOTAL_NREC_TAX_AMT_FUNCL_CURR IS NULL) AND
829 (p_TOTAL_NREC_TAX_AMT_FUNC_CURR IS NULL))) AND
830 ((Recinfo.TOTAL_NREC_TAX_AMT_TAX_CURR = p_TOTAL_NREC_TAX_AMT_TAX_CURR) OR
831 ((Recinfo.TOTAL_NREC_TAX_AMT_TAX_CURR IS NULL) AND
832 (p_TOTAL_NREC_TAX_AMT_TAX_CURR IS NULL))) AND
833 ((Recinfo.LEDGER_ID = p_LEDGER_ID) OR
834 ((Recinfo.LEDGER_ID IS NULL) AND
835 (p_LEDGER_ID IS NULL))) AND
836 ((Recinfo.LEGAL_ENTITY_ID = p_LEGAL_ENTITY_ID) OR
837 ((Recinfo.LEGAL_ENTITY_ID IS NULL) AND
838 (p_LEGAL_ENTITY_ID IS NULL))) AND
839 ((Recinfo.ESTABLISHMENT_ID = p_ESTABLISHMENT_ID) OR
840 ((Recinfo.ESTABLISHMENT_ID IS NULL) AND
841 (p_ESTABLISHMENT_ID IS NULL))) AND
842 ((Recinfo.CURRENCY_CONVERSION_DATE = p_CURRENCY_CONVERSION_DATE) OR
843 ((Recinfo.CURRENCY_CONVERSION_DATE IS NULL) AND
844 (p_CURRENCY_CONVERSION_DATE IS NULL))) AND
845 ((Recinfo.CURRENCY_CONVERSION_TYPE = p_CURRENCY_CONVERSION_TYPE) OR
846 ((Recinfo.CURRENCY_CONVERSION_TYPE IS NULL) AND
847 (p_CURRENCY_CONVERSION_TYPE IS NULL))) AND
848 ((Recinfo.CURRENCY_CONVERSION_RATE = p_CURRENCY_CONVERSION_RATE) OR
849 ((Recinfo.CURRENCY_CONVERSION_RATE IS NULL) AND
850 (p_CURRENCY_CONVERSION_RATE IS NULL))) AND
851 ((Recinfo.SUMMARIZATION_TEMPLATE_ID = p_SUMMARIZATION_TEMPLATE_ID) OR
852 ((Recinfo.SUMMARIZATION_TEMPLATE_ID IS NULL) AND
853 (p_SUMMARIZATION_TEMPLATE_ID IS NULL))) AND
854 ((Recinfo.TAXABLE_BASIS_FORMULA = p_TAXABLE_BASIS_FORMULA) OR
855 ((Recinfo.TAXABLE_BASIS_FORMULA IS NULL) AND
856 (p_TAXABLE_BASIS_FORMULA IS NULL))) AND
857 ((Recinfo.TAX_CALCULATION_FORMULA = p_TAX_CALCULATION_FORMULA) OR
858 ((Recinfo.TAX_CALCULATION_FORMULA IS NULL) AND
859 (p_TAX_CALCULATION_FORMULA IS NULL))) AND
860 (Recinfo.HISTORICAL_FLAG = NVL(p_Historical_Flag, 'N')) AND
861 (Recinfo.CANCEL_FLAG = NVL(p_Cancel_Flag, 'N')) AND
862 (Recinfo.DELETE_FLAG = NVL(p_Delete_Flag, 'N')) AND
863 (Recinfo.TAX_AMT_INCLUDED_FLAG = NVL(p_Tax_Amt_Included_Flag, 'N')) AND
864 (Recinfo.COMPOUNDING_TAX_FLAG = NVL(p_Compounding_Tax_Flag, 'N')) AND
865 (Recinfo.SELF_ASSESSED_FLAG = NVL(p_Self_Assessed_Flag, 'N')) AND
866 (Recinfo.OVERRIDDEN_FLAG = NVL(p_Overridden_Flag, 'N')) AND
867 (Recinfo.REPORTING_ONLY_FLAG = NVL(p_Reporting_Only_Flag, 'N')) AND
868 (Recinfo.ASSOCIATED_CHILD_FROZEN_FLAG = NVL(p_assoc_child_frozen_flag, 'N')) AND
869 (Recinfo.COPIED_FROM_OTHER_DOC_FLAG = NVL(p_Copied_From_Other_Doc_Flag, 'N')) AND
870 (Recinfo.MANUALLY_ENTERED_FLAG = NVL(p_Manually_Entered_Flag, 'N')) AND
871 ((Recinfo.MRC_TAX_LINE_FLAG = p_MRC_TAX_LINE_FLAG) OR
872 ((Recinfo.MRC_TAX_LINE_FLAG IS NULL) AND
873 (p_MRC_TAX_LINE_FLAG IS NULL))) AND
874 ((Recinfo.LAST_MANUAL_ENTRY = p_last_manual_entry) OR
875 ((Recinfo.LAST_MANUAL_ENTRY IS NULL) AND
876 (p_last_manual_entry IS NULL))) AND
877 ((Recinfo.Record_Type_Code = p_Record_Type_Code) OR
878 ((Recinfo.Record_Type_Code IS NULL) AND
879 (p_Record_Type_Code IS NULL))) AND
880 ((Recinfo.TAX_PROVIDER_ID = p_tax_provider_id) OR
881 ((Recinfo.TAX_PROVIDER_ID IS NULL) AND
882 (p_tax_provider_id IS NULL))) AND
883 (NVL(Recinfo.Tax_Only_Line_Flag, 'N') = NVL(p_Tax_Only_Line_Flag, 'N')) AND
884 (NVL(Recinfo.adjust_tax_amt_flag, 'N') = NVL(p_adjust_tax_amt_flag, 'N')) AND
885 ((Recinfo.ATTRIBUTE_CATEGORY = p_attribute_category) OR
886 ((Recinfo.ATTRIBUTE_CATEGORY IS NULL) AND
887 (p_attribute_category IS NULL))) AND
888 ((Recinfo.ATTRIBUTE1 = p_attribute1) OR
889 ((Recinfo.ATTRIBUTE1 IS NULL) AND
890 (p_attribute1 IS NULL))) AND
891 ((Recinfo.ATTRIBUTE2 = p_attribute2) OR
892 ((Recinfo.ATTRIBUTE2 IS NULL) AND
893 (p_attribute2 IS NULL))) AND
894 ((Recinfo.ATTRIBUTE3 = p_attribute3) OR
895 ((Recinfo.ATTRIBUTE3 IS NULL) AND
896 (p_attribute3 IS NULL))) AND
897 ((Recinfo.ATTRIBUTE4 = p_attribute4) OR
898 ((Recinfo.ATTRIBUTE4 IS NULL) AND
899 (p_attribute4 IS NULL))) AND
900 ((Recinfo.ATTRIBUTE5 = p_attribute5) OR
901 ((Recinfo.ATTRIBUTE5 IS NULL) AND
902 (p_attribute5 IS NULL))) AND
903 ((Recinfo.ATTRIBUTE6 = p_attribute6) OR
904 ((Recinfo.ATTRIBUTE6 IS NULL) AND
905 (p_attribute6 IS NULL))) AND
906 ((Recinfo.ATTRIBUTE7 = p_attribute7) OR
907 ((Recinfo.ATTRIBUTE7 IS NULL) AND
908 (p_attribute7 IS NULL))) AND
909 ((Recinfo.ATTRIBUTE8 = p_attribute8) OR
910 ((Recinfo.ATTRIBUTE8 IS NULL) AND
911 (p_attribute8 IS NULL))) AND
912 ((Recinfo.ATTRIBUTE9 = p_attribute9) OR
913 ((Recinfo.ATTRIBUTE9 IS NULL) AND
914 (p_attribute9 IS NULL))) AND
915 ((Recinfo.ATTRIBUTE10 = p_attribute10) OR
916 ((Recinfo.ATTRIBUTE10 IS NULL) AND
917 (p_attribute10 IS NULL))) AND
918 ((Recinfo.ATTRIBUTE11 = p_attribute11) OR
919 ((Recinfo.ATTRIBUTE11 IS NULL) AND
920 (p_attribute11 IS NULL))) AND
921 ((Recinfo.ATTRIBUTE12 = p_attribute12) OR
922 ((Recinfo.ATTRIBUTE12 IS NULL) AND
923 (p_attribute12 IS NULL))) AND
924 ((Recinfo.ATTRIBUTE13 = p_attribute13) OR
925 ((Recinfo.ATTRIBUTE13 IS NULL) AND
926 (p_attribute13 IS NULL))) AND
927 ((Recinfo.ATTRIBUTE14 = p_attribute14) OR
928 ((Recinfo.ATTRIBUTE14 IS NULL) AND
929 (p_attribute14 IS NULL))) AND
930 ((Recinfo.ATTRIBUTE15 = p_attribute15) OR
931 ((Recinfo.ATTRIBUTE15 IS NULL) AND
932 (p_attribute15 IS NULL))) AND
933 ((Recinfo.GLOBAL_ATTRIBUTE_CATEGORY = p_global_attribute_category) OR
934 ((Recinfo.GLOBAL_ATTRIBUTE_CATEGORY IS NULL) AND
935 (p_global_attribute_category IS NULL))) AND
936 ((Recinfo.GLOBAL_ATTRIBUTE1 = p_global_attribute1) OR
937 ((Recinfo.GLOBAL_ATTRIBUTE1 IS NULL) AND
938 (p_global_attribute1 IS NULL))) AND
939 ((Recinfo.GLOBAL_ATTRIBUTE2 = p_global_attribute2) OR
940 ((Recinfo.GLOBAL_ATTRIBUTE2 IS NULL) AND
941 (p_global_attribute2 IS NULL))) AND
942 ((Recinfo.GLOBAL_ATTRIBUTE3 = p_global_attribute3) OR
943 ((Recinfo.GLOBAL_ATTRIBUTE3 IS NULL) AND
944 (p_global_attribute3 IS NULL))) AND
945 ((Recinfo.GLOBAL_ATTRIBUTE4 = p_global_attribute4) OR
946 ((Recinfo.GLOBAL_ATTRIBUTE4 IS NULL) AND
947 (p_global_attribute4 IS NULL))) AND
948 ((Recinfo.GLOBAL_ATTRIBUTE5 = p_global_attribute5) OR
949 ((Recinfo.GLOBAL_ATTRIBUTE5 IS NULL) AND
950 (p_global_attribute5 IS NULL))) AND
951 ((Recinfo.GLOBAL_ATTRIBUTE6 = p_global_attribute6) OR
952 ((Recinfo.GLOBAL_ATTRIBUTE6 IS NULL) AND
953 (p_global_attribute6 IS NULL))) AND
954 ((Recinfo.GLOBAL_ATTRIBUTE7 = p_global_attribute7) OR
955 ((Recinfo.GLOBAL_ATTRIBUTE7 IS NULL) AND
956 (p_global_attribute7 IS NULL))) AND
957 ((Recinfo.GLOBAL_ATTRIBUTE8 = p_global_attribute8) OR
958 ((Recinfo.GLOBAL_ATTRIBUTE8 IS NULL) AND
959 (p_global_attribute8 IS NULL))) AND
960 ((Recinfo.GLOBAL_ATTRIBUTE9 = p_global_attribute9) OR
961 ((Recinfo.GLOBAL_ATTRIBUTE9 IS NULL) AND
962 (p_global_attribute9 IS NULL))) AND
963 ((Recinfo.GLOBAL_ATTRIBUTE10 = p_global_attribute10) OR
964 ((Recinfo.GLOBAL_ATTRIBUTE10 IS NULL) AND
965 (p_global_attribute10 IS NULL))) AND
966 ((Recinfo.GLOBAL_ATTRIBUTE11 = p_global_attribute11) OR
967 ((Recinfo.GLOBAL_ATTRIBUTE11 IS NULL) AND
968 (p_global_attribute11 IS NULL))) AND
969 ((Recinfo.GLOBAL_ATTRIBUTE12 = p_global_attribute12) OR
970 ((Recinfo.GLOBAL_ATTRIBUTE12 IS NULL) AND
971 (p_global_attribute12 IS NULL))) AND
972 ((Recinfo.GLOBAL_ATTRIBUTE13 = p_global_attribute13) OR
973 ((Recinfo.GLOBAL_ATTRIBUTE13 IS NULL) AND
974 (p_global_attribute13 IS NULL))) AND
975 ((Recinfo.GLOBAL_ATTRIBUTE14 = p_global_attribute14) OR
976 ((Recinfo.GLOBAL_ATTRIBUTE14 IS NULL) AND
977 (p_global_attribute14 IS NULL))) AND
978 ((Recinfo.GLOBAL_ATTRIBUTE15 = p_global_attribute15) OR
979 ((Recinfo.GLOBAL_ATTRIBUTE15 IS NULL) AND
980 (p_global_attribute15 IS NULL))) AND
981 ((Recinfo.GLOBAL_ATTRIBUTE16 = p_global_attribute16) OR
982 ((Recinfo.GLOBAL_ATTRIBUTE16 IS NULL) AND
983 (p_global_attribute16 IS NULL))) AND
984 ((Recinfo.GLOBAL_ATTRIBUTE17 = p_global_attribute17) OR
985 ((Recinfo.GLOBAL_ATTRIBUTE17 IS NULL) AND
986 (p_global_attribute17 IS NULL))) AND
987 ((Recinfo.GLOBAL_ATTRIBUTE18 = p_global_attribute18) OR
988 ((Recinfo.GLOBAL_ATTRIBUTE18 IS NULL) AND
989 (p_global_attribute18 IS NULL))) AND
990 ((Recinfo.GLOBAL_ATTRIBUTE19 = p_global_attribute19) OR
991 ((Recinfo.GLOBAL_ATTRIBUTE19 IS NULL) AND
992 (p_global_attribute19 IS NULL))) AND
993 ((Recinfo.GLOBAL_ATTRIBUTE20 = p_global_attribute20) OR
994 ((Recinfo.GLOBAL_ATTRIBUTE20 IS NULL) AND
995 (p_global_attribute20 IS NULL))) AND
996 (Recinfo.OBJECT_VERSION_NUMBER = p_OBJECT_VERSION_NUMBER) AND
997 (Recinfo.CREATED_BY = p_CREATED_BY) AND
998 (Recinfo.CREATION_DATE = p_CREATION_DATE) AND
999 (Recinfo.LAST_UPDATED_BY = p_LAST_UPDATED_BY) AND
1000 (Recinfo.LAST_UPDATE_DATE = p_LAST_UPDATE_DATE) AND
1001 ((Recinfo.LAST_UPDATE_LOGIN = p_LAST_UPDATE_LOGIN) OR
1002 ((Recinfo.LAST_UPDATE_LOGIN IS NULL) AND
1003 (p_LAST_UPDATE_LOGIN IS NULL))) ) THEN
1004 l_transaction_rec.APPLICATION_ID := Recinfo.APPLICATION_ID;
1005 l_transaction_rec.ENTITY_CODE := Recinfo.ENTITY_CODE;
1006 l_transaction_rec.EVENT_CLASS_CODE := Recinfo.EVENT_CLASS_CODE;
1007 l_transaction_rec.TRX_ID := Recinfo.TRX_ID;
1008 l_transaction_rec.INTERNAL_ORGANIZATION_ID := Recinfo.INTERNAL_ORGANIZATION_ID;
1009
1010 ZX_LINES_DET_FACTORS_PKG.lock_line_det_factors (
1011 l_transaction_rec,
1012 l_return_status );
1013
1014 RETURN;
1015 ELSE
1016 FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
1017 APP_EXCEPTION.Raise_Exception;
1018 END IF;
1019
1020 IF (g_level_procedure >= g_current_runtime_level ) THEN
1021 FND_LOG.STRING(g_level_procedure,
1022 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Lock_Row.END',
1023 'ZX_TRL_SUMMARY_OVERRIDE_PKG: Lock_Row (-)');
1024 END IF;
1025
1026 END Lock_Row;
1027
1028 PROCEDURE oa_lock_row
1029 ( p_application_id NUMBER,
1030 p_entity_code VARCHAR2,
1031 p_event_class_code VARCHAR2,
1032 p_trx_id NUMBER,
1033 p_internal_organization_id NUMBER) IS
1034 l_transaction_rec ZX_API_PUB.transaction_rec_type;
1035 l_return_status VARCHAR2(100);
1036 BEGIN
1037
1038 l_transaction_rec.APPLICATION_ID := p_APPLICATION_ID;
1039 l_transaction_rec.ENTITY_CODE := p_ENTITY_CODE;
1040 l_transaction_rec.EVENT_CLASS_CODE := p_EVENT_CLASS_CODE;
1041 l_transaction_rec.TRX_ID := p_TRX_ID;
1042 l_transaction_rec.INTERNAL_ORGANIZATION_ID := p_INTERNAL_ORGANIZATION_ID;
1043
1044 ZX_LINES_DET_FACTORS_PKG.lock_line_det_factors (
1045 l_transaction_rec,
1046 l_return_status );
1047
1048 END;
1049
1050
1051 PROCEDURE Update_Row
1052 (--x_rowid IN OUT NOCOPY VARCHAR2,
1053 p_summary_tax_line_id NUMBER,
1054 p_internal_organization_id NUMBER,
1055 p_application_id NUMBER,
1056 p_entity_code VARCHAR2,
1057 p_event_class_code VARCHAR2,
1058 p_trx_id NUMBER,
1059 p_summary_tax_line_number NUMBER,
1060 p_trx_number VARCHAR2,
1061 p_applied_from_application_id NUMBER,
1062 p_applied_from_evt_class_code VARCHAR2,--reduced size p_applied_from_event_class_code
1063 p_applied_from_entity_code VARCHAR2,
1064 p_applied_from_trx_id NUMBER,
1065 p_applied_from_trx_level_type VARCHAR2,
1066 p_applied_from_line_id NUMBER,
1067 p_adjusted_doc_application_id NUMBER,
1068 p_adjusted_doc_entity_code VARCHAR2,
1069 p_adjusted_doc_evt_class_code VARCHAR2,--reduced size p_adjusted_doc_event_class_code
1070 p_adjusted_doc_trx_id NUMBER,
1071 p_adjusted_doc_trx_level_type VARCHAR2,
1072 p_applied_to_application_id NUMBER,
1073 p_applied_to_event_class_code VARCHAR2,
1074 p_applied_to_entity_code VARCHAR2,
1075 p_applied_to_trx_id NUMBER,
1076 p_applied_to_trx_level_type VARCHAR2,
1077 p_applied_to_line_id NUMBER,
1078 p_tax_exemption_id NUMBER,
1079 p_tax_rate_before_exemption NUMBER,
1080 p_tax_rate_name_before_exempt VARCHAR2, --reduced size p_tax_rate_name_before_exemption
1081 p_exempt_rate_modifier NUMBER,
1082 p_exempt_certificate_number VARCHAR2,
1083 p_exempt_reason VARCHAR2,
1084 p_exempt_reason_code VARCHAR2,
1085 p_tax_rate_before_exception NUMBER,
1086 p_tax_rate_name_before_except VARCHAR2, --reduced size p_tax_rate_name_before_exception
1087 p_tax_exception_id NUMBER,
1088 p_exception_rate NUMBER,
1089 p_content_owner_id NUMBER,
1090 p_tax_regime_code VARCHAR2,
1091 p_tax VARCHAR2,
1092 p_tax_status_id NUMBER,
1093 p_tax_status_code VARCHAR2,
1094 p_tax_rate_id NUMBER,
1095 p_tax_rate_code VARCHAR2,
1096 p_tax_rate NUMBER,
1097 p_tax_amt NUMBER,
1098 p_tax_amt_tax_curr NUMBER,
1099 p_tax_amt_funcl_curr NUMBER,
1100 p_tax_jurisdiction_code VARCHAR2,
1101 p_total_rec_tax_amt NUMBER,
1102 p_total_rec_tax_amt_func_curr NUMBER,--reduced size p_total_rec_tax_amt_funcl_curr
1103 p_total_rec_tax_amt_tax_curr NUMBER,
1104 p_total_nrec_tax_amt NUMBER,
1105 p_total_nrec_tax_amt_func_curr NUMBER,--reduced size p_total_nrec_tax_amt_funcl_curr
1106 p_total_nrec_tax_amt_tax_curr NUMBER,
1107 p_ledger_id NUMBER,
1108 p_legal_entity_id NUMBER,
1109 p_establishment_id NUMBER,
1110 p_currency_conversion_date DATE,
1111 p_currency_conversion_type VARCHAR2,
1112 p_currency_conversion_rate NUMBER,
1113 p_summarization_template_id NUMBER,
1114 p_taxable_basis_formula VARCHAR2,
1115 p_tax_calculation_formula VARCHAR2,
1116 p_historical_flag VARCHAR2,
1117 p_cancel_flag VARCHAR2,
1118 p_delete_flag VARCHAR2,
1119 p_tax_amt_included_flag VARCHAR2,
1120 p_compounding_tax_flag VARCHAR2,
1121 p_self_assessed_flag VARCHAR2,
1122 p_overridden_flag VARCHAR2,
1123 p_reporting_only_flag VARCHAR2,
1124 p_assoc_child_frozen_flag VARCHAR2,--reduced size p_Associated_Child_Frozen_Flag
1125 p_copied_from_other_doc_flag VARCHAR2,
1126 p_manually_entered_flag VARCHAR2,
1127 p_mrc_tax_line_flag VARCHAR2,
1128 p_last_manual_entry VARCHAR2,
1129 p_record_type_code VARCHAR2,
1130 p_tax_provider_id NUMBER,
1131 p_tax_only_line_flag VARCHAR2,
1132 p_adjust_tax_amt_flag VARCHAR2,
1133 --p_ctrl_ef_ov_cal_line_flag VARCHAR2,
1134 p_attribute_category VARCHAR2,
1135 p_attribute1 VARCHAR2,
1136 p_attribute2 VARCHAR2,
1137 p_attribute3 VARCHAR2,
1138 p_attribute4 VARCHAR2,
1139 p_attribute5 VARCHAR2,
1140 p_attribute6 VARCHAR2,
1141 p_attribute7 VARCHAR2,
1142 p_attribute8 VARCHAR2,
1143 p_attribute9 VARCHAR2,
1144 p_attribute10 VARCHAR2,
1145 p_attribute11 VARCHAR2,
1146 p_attribute12 VARCHAR2,
1147 p_attribute13 VARCHAR2,
1148 p_attribute14 VARCHAR2,
1149 p_attribute15 VARCHAR2,
1150 p_global_attribute_category VARCHAR2,
1151 p_global_attribute1 VARCHAR2,
1152 p_global_attribute2 VARCHAR2,
1153 p_global_attribute3 VARCHAR2,
1154 p_global_attribute4 VARCHAR2,
1155 p_global_attribute5 VARCHAR2,
1156 p_global_attribute6 VARCHAR2,
1157 p_global_attribute7 VARCHAR2,
1158 p_global_attribute8 VARCHAR2,
1159 p_global_attribute9 VARCHAR2,
1160 p_global_attribute10 VARCHAR2,
1161 p_global_attribute11 VARCHAR2,
1162 p_global_attribute12 VARCHAR2,
1163 p_global_attribute13 VARCHAR2,
1164 p_global_attribute14 VARCHAR2,
1165 p_global_attribute15 VARCHAR2,
1166 p_global_attribute16 VARCHAR2,
1167 p_global_attribute17 VARCHAR2,
1168 p_global_attribute18 VARCHAR2,
1169 p_global_attribute19 VARCHAR2,
1170 p_global_attribute20 VARCHAR2,
1171 p_object_version_number NUMBER,
1172 --p_created_by NUMBER,
1173 --p_creation_date DATE,
1174 p_last_updated_by NUMBER,
1175 p_last_update_date DATE,
1176 p_last_update_login NUMBER) IS
1177
1178 Cursor c_det ( p_application_id NUMBER,
1179 p_entity_code VARCHAR2,
1180 p_event_class_code VARCHAR2,
1181 p_trx_id NUMBER)
1182 is select trx_line_id, summary_tax_line_id from zx_lines
1183 where application_id = p_application_id
1184 and entity_code = p_entity_code
1185 and event_class_code = p_event_class_code
1186 and trx_id = p_trx_id;
1187
1188 Cursor c_line (p_application_id NUMBER,
1189 p_entity_code VARCHAR2,
1190 p_event_class_code VARCHAR2,
1191 p_trx_id NUMBER,
1192 p_tax_line_id NUMBER)
1193 IS SELECT
1194 tax_status_code,
1195 tax_rate_id,
1196 tax_rate_code,
1197 tax_rate,
1198 tax_jurisdiction_code,
1199 ledger_id,
1200 legal_entity_id,
1201 establishment_id,
1202 TRUNC(currency_conversion_date) currency_conversion_date,
1203 currency_conversion_type,
1204 currency_conversion_rate,
1205 taxable_basis_formula,
1206 tax_calculation_formula,
1207 tax_amt_included_flag,
1208 compounding_tax_flag,
1209 self_assessed_flag,
1210 reporting_only_flag,
1211 copied_from_other_doc_flag,
1212 record_type_code,
1213 tax_provider_id,
1214 historical_flag,
1215 delete_flag,
1216 overridden_flag,
1217 manually_entered_flag,
1218 tax_exemption_id,
1219 tax_rate_before_exemption,
1220 tax_rate_name_before_exemption,
1221 exempt_rate_modifier,
1222 exempt_certificate_number,
1223 exempt_reason,
1224 exempt_reason_code,
1225 tax_rate_before_exception,
1226 tax_rate_name_before_exception,
1227 tax_exception_id,
1228 exception_rate,
1229 mrc_tax_line_flag,
1230 tax_only_line_flag
1231 FROM zx_lines
1232 WHERE application_id = p_application_id
1233 AND entity_code = p_entity_code
1234 AND event_class_code = p_event_class_code
1235 AND trx_id = p_trx_id
1236 AND tax_line_id = p_tax_line_id;
1237
1238 Cursor c2(p_application_id NUMBER,
1239 p_entity_code VARCHAR2,
1240 p_event_class_code VARCHAR2,
1241 p_trx_id NUMBER,
1242 p_summary_tax_line_id NUMBER) IS
1243 SELECT
1244 tax_line_id,
1245 internal_organization_id ,
1246 application_id ,
1247 entity_code ,
1248 event_class_code ,
1249 event_type_code ,
1250 trx_id ,
1251 trx_line_id ,
1252 trx_level_type ,
1253 trx_line_number ,
1254 doc_event_status ,
1255 tax_event_class_code ,
1256 tax_event_type_code ,
1257 tax_line_number ,
1258 content_owner_id ,
1259 tax_regime_id ,
1260 tax_regime_code ,
1261 tax_id ,
1262 tax ,
1263 tax_status_id ,
1264 tax_status_code ,
1265 tax_rate_id ,
1266 tax_rate_code ,
1267 tax_rate ,
1268 tax_rate_type ,
1269 tax_apportionment_line_number ,--reduced in size tax_apportionment_line_number
1270 trx_id_level2 ,
1271 trx_id_level3 ,
1272 trx_id_level4 ,
1273 trx_id_level5 ,
1274 trx_id_level6 ,
1275 trx_user_key_level1 ,
1276 trx_user_key_level2 ,
1277 trx_user_key_level3 ,
1278 trx_user_key_level4 ,
1279 trx_user_key_level5 ,
1280 trx_user_key_level6 ,
1281 mrc_tax_line_flag ,
1282 mrc_link_to_tax_line_id ,
1283 ledger_id ,
1284 establishment_id ,
1285 legal_entity_id ,
1286 hq_estb_reg_number ,
1287 hq_estb_party_tax_prof_id ,
1288 currency_conversion_date ,
1289 currency_conversion_type ,
1290 currency_conversion_rate ,
1291 tax_currency_conversion_date ,--reduced in size tax_currency_conversion_date
1292 tax_currency_conversion_type ,--reduced in sizetax_currency_conversion_type
1293 tax_currency_conversion_rate ,--reduced in sizetax_currency_conversion_rate
1294 trx_currency_code ,
1295 reporting_currency_code ,
1296 minimum_accountable_unit ,
1297 precision ,
1298 trx_number ,
1299 trx_date ,
1300 unit_price ,
1301 line_amt ,
1302 trx_line_quantity ,
1303 tax_base_modifier_rate ,
1304 ref_doc_application_id ,
1305 ref_doc_entity_code ,
1306 ref_doc_event_class_code ,
1307 ref_doc_trx_id ,
1308 ref_doc_trx_level_type ,
1309 ref_doc_line_id ,
1310 ref_doc_line_quantity ,
1311 other_doc_line_amt ,
1312 other_doc_line_tax_amt ,
1313 other_doc_line_taxable_amt ,
1314 unrounded_taxable_amt ,
1315 unrounded_tax_amt ,
1316 related_doc_application_id ,
1317 related_doc_entity_code ,
1318 related_doc_event_class_code ,--reduced in sizerelated_doc_event_class_code
1319 related_doc_trx_id ,
1320 related_doc_trx_level_type ,
1321 related_doc_number ,
1322 related_doc_date ,
1323 applied_from_application_id ,--reduced in sizeapplied_from_application_id
1324 applied_from_event_class_code ,--reduced in sizeapplied_from_event_class_code
1325 applied_from_entity_code ,
1326 applied_from_trx_id ,
1327 applied_from_trx_level_type ,
1328 applied_from_line_id ,
1329 applied_from_trx_number ,
1330 adjusted_doc_application_id , -- reduced in size adjusted_doc_application_id
1331 adjusted_doc_entity_code ,
1332 adjusted_doc_event_class_code , -- reduced in size adjusted_doc_event_class_code
1333 adjusted_doc_trx_id ,
1334 adjusted_doc_trx_level_type ,
1335 adjusted_doc_line_id ,
1336 adjusted_doc_number ,
1337 adjusted_doc_date ,
1338 applied_to_application_id ,
1339 applied_to_event_class_code ,--reduced in sizeapplied_to_event_class_code
1340 applied_to_entity_code ,
1341 applied_to_trx_id ,
1342 applied_to_trx_level_type ,
1343 applied_to_line_id ,
1344 summary_tax_line_id ,
1345 offset_link_to_tax_line_id ,
1346 offset_flag ,
1347 process_for_recovery_flag ,
1348 tax_jurisdiction_id ,
1349 tax_jurisdiction_code ,
1350 place_of_supply ,
1351 place_of_supply_type_code ,
1352 place_of_supply_result_id ,
1353 tax_date_rule_id ,
1354 tax_date ,
1355 tax_determine_date ,
1356 tax_point_date ,
1357 trx_line_date ,
1358 tax_type_code ,
1359 tax_code ,
1360 tax_registration_id ,
1361 tax_registration_number ,
1362 registration_party_type ,
1363 rounding_level_code ,
1364 rounding_rule_code ,
1365 rounding_lvl_party_tax_prof_id , -- reduced in size rounding_lvl_party_tax_prof_id
1366 rounding_lvl_party_type ,
1367 compounding_tax_flag ,
1368 orig_tax_status_id ,
1369 orig_tax_status_code ,
1370 orig_tax_rate_id ,
1371 orig_tax_rate_code ,
1372 orig_tax_rate ,
1373 orig_tax_jurisdiction_id ,
1374 orig_tax_jurisdiction_code ,
1375 orig_tax_amt_included_flag ,
1376 orig_self_assessed_flag ,
1377 tax_currency_code ,
1378 tax_amt ,
1379 tax_amt_tax_curr ,
1380 tax_amt_funcl_curr ,
1381 taxable_amt ,
1382 taxable_amt_tax_curr ,
1383 taxable_amt_funcl_curr ,
1384 orig_taxable_amt ,
1385 orig_taxable_amt_tax_curr ,
1386 cal_tax_amt ,
1387 cal_tax_amt_tax_curr ,
1388 cal_tax_amt_funcl_curr ,
1389 orig_tax_amt ,
1390 orig_tax_amt_tax_curr ,
1391 rec_tax_amt ,
1392 rec_tax_amt_tax_curr ,
1393 rec_tax_amt_funcl_curr ,
1394 nrec_tax_amt ,
1395 nrec_tax_amt_tax_curr ,
1396 nrec_tax_amt_funcl_curr ,
1397 tax_exemption_id ,
1398 tax_rate_before_exemption ,
1399 tax_rate_name_before_exemption ,
1400 exempt_rate_modifier ,
1401 exempt_certificate_number ,
1402 exempt_reason ,
1403 exempt_reason_code ,
1404 tax_exception_id ,
1405 tax_rate_before_exception ,
1406 tax_rate_name_before_exception ,
1407 exception_rate ,
1408 tax_apportionment_flag ,
1409 historical_flag ,
1410 taxable_basis_formula ,
1411 tax_calculation_formula ,
1412 cancel_flag ,
1413 purge_flag ,
1414 delete_flag ,
1415 tax_amt_included_flag ,
1416 self_assessed_flag ,
1417 overridden_flag ,
1418 manually_entered_flag ,
1419 reporting_only_flag ,
1420 freeze_until_overridden_flag , -- reduced in size Freeze_Until_Overridden_Flag
1421 copied_from_other_doc_flag ,
1422 recalc_required_flag ,
1423 settlement_flag ,
1424 item_dist_changed_flag ,
1425 associated_child_frozen_flag , -- reduced in size Associated_Child_Frozen_Flag
1426 tax_only_line_flag ,
1427 compounding_dep_tax_flag ,
1428 compounding_tax_miss_flag ,
1429 sync_with_prvdr_flag ,
1430 last_manual_entry ,
1431 tax_provider_id ,
1432 record_type_code ,
1433 reporting_period_id ,
1434 legal_justification_text1 ,
1435 legal_justification_text2 ,
1436 legal_justification_text3 ,
1437 legal_message_appl_2 ,
1438 legal_message_status ,
1439 legal_message_rate ,
1440 legal_message_basis ,
1441 legal_message_calc ,
1442 legal_message_threshold ,
1443 legal_message_pos ,
1444 legal_message_trn ,
1445 legal_message_exmpt ,
1446 legal_message_excpt ,
1447 tax_regime_template_id ,
1448 tax_applicability_result_id ,--reduced in sizetax_applicability_result_id
1449 direct_rate_result_id ,
1450 status_result_id ,
1451 rate_result_id ,
1452 basis_result_id ,
1453 thresh_result_id ,
1454 calc_result_id ,
1455 tax_reg_num_det_result_id ,
1456 eval_exmpt_result_id ,
1457 eval_excpt_result_id ,
1458 enforce_from_natural_acct_flag ,--reduced in sizeEnforce_From_Natural_Acct_Flag
1459 tax_hold_code ,
1460 tax_hold_released_code ,
1461 prd_total_tax_amt ,
1462 prd_total_tax_amt_tax_curr ,
1463 prd_total_tax_amt_funcl_curr ,
1464 trx_line_index ,
1465 offset_tax_rate_code ,
1466 proration_code ,
1467 other_doc_source ,
1468 internal_org_location_id ,
1469 line_assessable_value ,
1470 ctrl_total_line_tx_amt ,
1471 applied_to_trx_number ,
1472 attribute_category ,
1473 attribute1 ,
1474 attribute2 ,
1475 attribute3 ,
1476 attribute4 ,
1477 attribute5 ,
1478 attribute6 ,
1479 attribute7 ,
1480 attribute8 ,
1481 attribute9 ,
1482 attribute10 ,
1483 attribute11 ,
1484 attribute12 ,
1485 attribute13 ,
1486 attribute14 ,
1487 attribute15 ,
1488 global_attribute_category ,
1489 global_attribute1 ,
1490 global_attribute2 ,
1491 global_attribute3 ,
1492 global_attribute4 ,
1493 global_attribute5 ,
1494 global_attribute6 ,
1495 global_attribute7 ,
1496 global_attribute8 ,
1497 global_attribute9 ,
1498 global_attribute10 ,
1499 global_attribute11 ,
1500 global_attribute12 ,
1501 global_attribute13 ,
1502 global_attribute14 ,
1503 global_attribute15 ,
1504 numeric1 ,
1505 numeric2 ,
1506 numeric3 ,
1507 numeric4 ,
1508 numeric5 ,
1509 numeric6 ,
1510 numeric7 ,
1511 numeric8 ,
1512 numeric9 ,
1513 numeric10 ,
1514 char1 ,
1515 char2 ,
1516 char3 ,
1517 char4 ,
1518 char5 ,
1519 char6 ,
1520 char7 ,
1521 char8 ,
1522 char9 ,
1523 char10 ,
1524 date1 ,
1525 date2 ,
1526 date3 ,
1527 date4 ,
1528 date5 ,
1529 date6 ,
1530 date7 ,
1531 date8 ,
1532 date9 ,
1533 date10 ,
1534 interface_entity_code ,
1535 interface_tax_line_id ,
1536 taxing_juris_geography_id ,
1537 adjusted_doc_tax_line_id ,
1538 object_version_number ,
1539 last_updated_by ,
1540 last_update_date ,
1541 last_update_login
1542 FROM zx_lines
1543 WHERE application_id = p_application_id
1544 AND entity_code = p_entity_code
1545 AND event_class_code = p_event_class_code
1546 AND trx_id = p_trx_id
1547 AND summary_tax_line_id = p_summary_tax_line_id
1548 AND nvl(cancel_flag,'N') <> 'Y'
1549 ORDER by associated_child_frozen_flag DESC NULLS LAST;
1550
1551 CURSOR existing_summary_tax_line(l_tax_rate NUMBER) IS
1552 SELECT summary_tax_line_id
1553 FROM zx_lines_summary
1554 WHERE application_id = p_application_id
1555 AND entity_code = p_entity_code
1556 AND event_class_code = p_event_class_code
1557 AND trx_id = p_trx_id
1558 AND tax_status_code = p_tax_status_code
1559 AND tax_rate_id = p_tax_rate_id
1560 AND tax_rate_code = p_tax_rate_code
1561 AND tax_rate = l_tax_rate
1562 AND NVL(tax_jurisdiction_code, 'x') = NVL(p_tax_jurisdiction_code, 'x')
1563 AND NVL(ledger_id, -999) = NVL(p_ledger_id, -999)
1564 AND NVL(legal_entity_id, -999) = NVL(p_legal_entity_id, -999)
1565 AND NVL(establishment_id, -999) = NVL(p_establishment_id, -999)
1566 AND NVL(TRUNC(currency_conversion_date), DATE_DUMMY) = NVL(TRUNC(p_currency_conversion_date), DATE_DUMMY)
1567 AND NVL(currency_conversion_type, 'x') = NVL(p_currency_conversion_type, 'x')
1568 AND NVL(currency_conversion_rate, 1) = NVL(p_currency_conversion_rate, 1)
1569 AND NVL(taxable_basis_formula, 'x') = NVL(p_taxable_basis_formula, 'x')
1570 AND NVL(tax_calculation_formula, 'x') = NVL(p_tax_calculation_formula, 'x')
1571 AND NVL(tax_amt_included_flag,'N') = NVL(p_tax_amt_included_flag,'N')
1572 AND NVL(compounding_tax_flag,'N') = NVL(p_compounding_tax_flag,'N')
1573 AND NVL(self_assessed_flag,'N') = NVL(p_self_assessed_flag,'N')
1574 AND NVL(reporting_only_flag,'N') = NVL(p_reporting_only_flag,'N')
1575 -- AND NVL(copied_from_other_doc_flag,'N') = NVL(p_copied_from_other_doc_flag,'N')
1576 AND NVL(record_type_code, 'x') = NVL(p_record_type_code, 'x')
1577 AND NVL(tax_provider_id, -999) = NVL(p_tax_provider_id, -999)
1578 AND NVL(historical_flag,'N') = NVL(p_historical_flag,'N')
1579 AND NVL(delete_flag,'N') = NVL(p_delete_flag,'N')
1580 -- AND NVL(overridden_flag,'N') = NVL(p_overridden_flag,'N')
1581 AND NVL(manually_entered_flag,'N') = NVL(p_manually_entered_flag,'N')
1582 AND NVL(tax_exemption_id, -999) = NVL(p_tax_exemption_id, -999)
1583 -- AND NVL(tax_rate_before_exemption, -999) = NVL(p_tax_rate_before_exemption, -999)
1584 -- AND NVL(tax_rate_name_before_exemption, 'x') = NVL(p_tax_rate_name_before_exempt, 'x')
1585 -- AND NVL(exempt_rate_modifier, -999) = NVL(p_exempt_rate_modifier, -999)
1586 AND NVL(exempt_certificate_number, 'x') = NVL(p_exempt_certificate_number, 'x')
1587 -- AND NVL(exempt_reason, 'x') = NVL(p_exempt_reason, 'x')
1588 AND NVL(exempt_reason_code, 'x') = NVL(p_exempt_reason_code, 'x')
1589 -- AND NVL(tax_rate_before_exception, -999) = NVL(p_tax_rate_before_exception, -999)
1590 -- AND NVL(tax_rate_name_before_exception, 'x') = NVL(p_tax_rate_name_before_except, 'x')
1591 AND NVL(tax_exception_id, -999) = NVL(p_tax_exception_id, -999)
1592 -- AND NVL(exception_rate, -999) = NVL(p_exception_rate, -999)
1593 AND NVL(mrc_tax_line_flag,'N') = NVL(p_mrc_tax_line_flag,'N')
1594 AND NVL(tax_only_line_flag,'N') = NVL(p_tax_only_line_flag,'N');
1595
1596 recinfo c2%ROWTYPE;
1597 l_total_detail_tax_amt NUMBER;
1598 l_total_detail_taxable_amt NUMBER;
1599 l_num_det_lines NUMBER;
1600 l_summary_tax_line_id NUMBER;
1601 l_ctrl_ef_ov_cal_line_flag VARCHAR2(1);
1602 Invalid_unrounded_amt Exception;
1603 l_tax_line_id NUMBER;
1604 l_offset_tax_line_id NUMBER;
1605 l_offset_trx_line_id NUMBER;
1606 l_row_id VARCHAR2(100);
1607 l_tax_apportionment_line_num NUMBER;
1608 l_tax_line_number NUMBER;
1609 l_value VARCHAR2(10) := 'N';
1610
1611 l_summary_tax_amt NUMBER;
1612 l_overridden_flag VARCHAR2(1);
1613
1614 l_existing_summary_tax_line_id NUMBER;
1615 l_tax_rate NUMBER;
1616 l_had_frozen_dists BOOLEAN;
1617 l_num_canceled_detail_lines NUMBER;
1618 l_allow_adhoc_tax_rate_flag VARCHAR2(1);
1619 l_adj_for_adhoc_amt_code VARCHAR2(30);
1620
1621 l_orig_self_assessed_flag VARCHAR2(1);
1622 l_orig_tax_amt_included_flag VARCHAR2(1);
1623
1624 BEGIN
1625
1626 g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1627
1628 IF (g_level_procedure >= g_current_runtime_level ) THEN
1629 FND_LOG.STRING(g_level_procedure,
1630 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row.BEGIN',
1631 'ZX_TRL_SUMMARY_OVERRIDE_PKG: Update_Row (+)'||p_self_assessed_flag);
1632 END IF;
1633
1634 IF (g_level_statement >= g_current_runtime_level) THEN
1635 FND_LOG.STRING(g_level_statement,
1636 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row.BEGIN',
1637 'Self assessed flag '||p_self_assessed_flag);
1638 END IF;
1639
1640 BEGIN
1641 SELECT tax_amt, overridden_flag INTO l_summary_tax_amt, l_overridden_flag
1642 FROM zx_lines_summary
1643 WHERE summary_tax_line_id = p_summary_tax_line_id;
1644 EXCEPTION
1645 WHEN OTHERS THEN
1646 NULL;
1647 END;
1648
1649 BEGIN
1650 SELECT sum(unrounded_tax_amt), SUM(unrounded_taxable_amt), COUNT(*)
1651 INTO l_total_detail_tax_amt, l_total_detail_taxable_amt, l_num_det_lines
1652 FROM zx_lines
1653 WHERE summary_tax_line_id = p_summary_tax_line_id
1654 AND application_id = p_application_id
1655 AND entity_code = p_entity_code
1656 AND event_class_code = p_event_class_code
1657 AND trx_id = p_trx_id
1658 AND NVL(cancel_flag, 'N') <> 'Y';
1659 EXCEPTION
1660 WHEN NO_DATA_FOUND THEN
1661 IF (g_level_statement >= g_current_runtime_level) THEN
1662 FND_LOG.STRING(g_level_statement,
1663 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row.BEGIN',
1664 'No Lines to Update ');
1665 FND_LOG.STRING(g_level_statement,
1666 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row.END',
1667 'ZX_TRL_SUMMARY_OVERRIDE_PKG: Update_Row (-)');
1668 END IF;
1669 RETURN;
1670 WHEN OTHERS THEN
1671 NULL;
1672 END;
1673
1674 l_tax_rate := p_tax_rate;
1675 l_summary_tax_line_id := p_summary_tax_line_id;
1676 l_had_frozen_dists := FALSE;
1677 l_num_canceled_detail_lines := 0;
1678
1679 IF p_last_manual_entry = 'TAX_AMOUNT' AND p_tax_amt <> l_summary_tax_amt AND
1680 NVL(p_cancel_flag, 'N') <> 'Y'
1681 THEN
1682
1683 BEGIN
1684 SELECT allow_adhoc_tax_rate_flag, adj_for_adhoc_amt_code
1685 INTO l_allow_adhoc_tax_rate_flag, l_adj_for_adhoc_amt_code
1686 FROM zx_rates_b
1687 WHERE tax_rate_id = p_tax_rate_id;
1688 EXCEPTION
1689 WHEN OTHERS THEN
1690 NULL;
1691 END;
1692
1693 IF NVL(l_allow_adhoc_tax_rate_flag,'N') = 'Y' AND
1694 l_adj_for_adhoc_amt_code = 'TAX_RATE'
1695 THEN
1696 IF l_total_detail_taxable_amt <> 0 THEN
1697 l_tax_rate := round(p_tax_amt/l_total_detail_taxable_amt*100, 6); -- Bug 8217841
1698 END IF;
1699 END IF;
1700 END IF; -- p_last_manual_entry = 'TAX_AMOUNT' AND
1701
1702 -- new changes
1703 FOR rec IN existing_summary_tax_line(l_tax_rate) LOOP
1704 IF rec.summary_tax_line_id = p_summary_tax_line_id THEN
1705 l_existing_summary_tax_line_id := NULL;
1706 EXIT;
1707 ELSE
1708 l_existing_summary_tax_line_id := rec.summary_tax_line_id;
1709 END IF;
1710 END LOOP;
1711 -- new changes end
1712
1713 BEGIN
1714 SELECT CTRL_EFF_OVRD_CALC_LINES_FLAG
1715 INTO l_ctrl_ef_ov_cal_line_flag
1716 FROM ZX_EVNT_CLS_OPTIONS
1717 WHERE EVENT_CLASS_CODE = p_event_class_code
1718 AND APPLICATION_ID = p_application_id
1719 AND ENTITY_CODE = p_entity_code
1720 AND ENABLED_FLAG = 'Y'
1721 AND FIRST_PTY_ORG_ID = p_internal_organization_id
1722 AND EFFECTIVE_FROM <= sysdate
1723 AND (EFFECTIVE_TO >= sysdate OR
1724 EFFECTIVE_TO IS NULL);
1725 EXCEPTION
1726 WHEN NO_DATA_FOUND THEN
1727 SELECT CTRL_EFF_OVRD_CALC_LINES_FLAG
1728 INTO l_ctrl_ef_ov_cal_line_flag
1729 FROM ZX_EVNT_CLS_MAPPINGS
1730 WHERE EVENT_CLASS_CODE = p_event_class_code
1731 AND APPLICATION_ID = p_application_id
1732 AND ENTITY_CODE = p_entity_code;
1733
1734 END;
1735
1736 IF (g_level_procedure >= g_current_runtime_level ) THEN
1737 FND_LOG.STRING(g_level_procedure,
1738 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row',
1739 'Update zx_lines_summary (+)');
1740 END IF;
1741
1742 FOR rec IN c2(p_application_id,
1743 p_entity_code,
1744 p_event_class_code,
1745 p_trx_id,
1746 p_summary_tax_line_id)
1747 LOOP
1748
1749 IF (g_level_statement >= g_current_runtime_level) THEN
1750 FND_LOG.STRING(g_level_statement,
1751 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row.BEGIN',
1752 'tax only line flag ='||rec.tax_only_line_flag);
1753 FND_LOG.STRING(g_level_statement,
1754 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row.BEGIN',
1755 'tax only line flag ='||rec.associated_child_frozen_flag);
1756 END IF;
1757
1758 IF NVL(rec.tax_only_line_flag, 'N') = 'N' THEN
1759 IF( rec.tax_status_code <> p_tax_status_code
1760 OR rec.tax_rate_id <> p_tax_rate_id
1761 OR rec.tax_rate_code <> p_tax_rate_code
1762 OR rec.tax_rate <> l_tax_rate
1763 OR NVL(rec.tax_jurisdiction_code, 'x') <> NVL(p_tax_jurisdiction_code, 'x')
1764 OR NVL(rec.ledger_id, -999) <> NVL(p_ledger_id, -999)
1765 OR NVL(rec.legal_entity_id, -999) <> NVL(p_legal_entity_id, -999)
1766 OR NVL(rec.establishment_id, -999) <> NVL(p_establishment_id, -999)
1767 OR NVL(TRUNC(rec.currency_conversion_date),DATE_DUMMY) <> NVL(TRUNC(p_currency_conversion_date), DATE_DUMMY)
1768 OR NVL(rec.currency_conversion_type, 'x') <> NVL(p_currency_conversion_type,'x')
1769 OR NVL(rec.currency_conversion_rate, 1) <> NVL(p_currency_conversion_rate, 1)
1770 OR NVL(rec.taxable_basis_formula,'x') <> NVL(p_taxable_basis_formula, 'x')
1771 OR NVL(rec.tax_calculation_formula, 'x') <> NVL(p_tax_calculation_formula, 'x')
1772 OR NVL(rec.tax_amt_included_flag,'N') <> NVL(p_tax_amt_included_flag,'N')
1773 OR NVL(rec.compounding_tax_flag,'N') <> NVL(p_compounding_tax_flag,'N')
1774 OR NVL(rec.self_assessed_flag,'N') <> NVL(p_self_assessed_flag,'N')
1775 OR NVL(rec.reporting_only_flag,'N') <> NVL(p_reporting_only_flag,'N')
1776 -- OR NVL(rec.copied_from_other_doc_flag,'N') <> NVL(p_copied_from_other_doc_flag,'N')
1777 OR NVL(rec.record_type_code,'x') <> NVL(p_record_type_code, 'x')
1778 OR NVL(rec.tax_provider_id, -999) <> NVL(p_tax_provider_id, -999)
1779 OR NVL(rec.historical_flag,'N') <> NVL(p_historical_flag,'N')
1780 OR NVL(rec.delete_flag,'N') <> NVL(p_delete_flag,'N')
1781 -- OR NVL(rec.overridden_flag,'N') <> NVL(p_overridden_flag,'N')
1782 OR NVL(rec.manually_entered_flag,'N') <> NVL(p_manually_entered_flag,'N')
1783 OR NVL(rec.tax_exemption_id, -999) <> NVL(p_tax_exemption_id, -999)
1784 -- OR NVL(rec.tax_rate_before_exemption, -999) <> NVL(p_tax_rate_before_exemption, -999)
1785 -- OR NVL(rec.tax_rate_name_before_exemption, 'x') <> NVL(p_tax_rate_name_before_exempt, 'x')
1786 -- OR NVL(rec.exempt_rate_modifier, -999) <> NVL(p_exempt_rate_modifier, -999)
1787 OR NVL(rec.exempt_certificate_number,'x') <> NVL(p_exempt_certificate_number, 'x')
1788 -- OR NVL(rec.exempt_reason, 'x') <> NVL(p_exempt_reason, 'x')
1789 OR NVL(rec.exempt_reason_code,'x') <> NVL(p_exempt_reason_code, 'x')
1790 -- OR NVL(rec.tax_rate_before_exception, -999) <> NVL(p_tax_rate_before_exception, -999)
1791 -- OR NVL(rec.tax_rate_name_before_exception, 'x') <> NVL(p_tax_rate_name_before_except, 'x')
1792 OR NVL(rec.tax_exception_id, -999) <> NVL(p_tax_exception_id, -999)
1793 -- OR NVL(rec.exception_rate, -999) <> NVL(p_exception_rate, -999)
1794 OR NVL(rec.mrc_tax_line_flag,'N') <> NVL(p_mrc_tax_line_flag,'N')
1795 OR NVL(rec.tax_only_line_flag,'N') <> NVL(p_tax_only_line_flag,'N')
1796 -- OR (NVL(l_summary_tax_amt,-999999999) <> NVL(p_tax_amt,-999999999)
1797 -- AND NVL(l_overridden_flag,'N')='N')
1798 )
1799 THEN
1800
1801 IF NVL(rec.associated_child_frozen_flag,'N') = 'Y' THEN
1802
1803 SELECT zx_lines_s.NEXTVAL INTO l_tax_line_id FROM DUAL;
1804
1805 -- new changes
1806 IF l_summary_tax_line_id = p_summary_tax_line_id THEN
1807 SELECT zx_lines_summary_s.NEXTVAL INTO l_summary_tax_line_id FROM DUAL;
1808 END IF;
1809 -- new changes
1810
1811 SELECT max(abs(tax_apportionment_line_number))+1
1812 INTO l_tax_apportionment_line_num
1813 FROM zx_lines
1814 WHERE application_id = p_application_id
1815 AND entity_code = p_entity_code
1816 AND event_class_code = p_event_class_code
1817 AND trx_id = p_trx_id
1818 AND trx_line_id = rec.trx_line_id;
1819
1820 SELECT nvl(max(tax_line_number),0)+1
1821 INTO l_tax_line_number
1822 FROM zx_lines
1823 WHERE application_id = p_application_id
1824 AND entity_code = p_entity_code
1825 AND event_class_code = p_event_class_code
1826 AND trx_id = p_trx_id
1827 AND trx_line_id = rec.trx_line_id
1828 AND trx_level_type = rec.trx_level_type;
1829
1830 UPDATE ZX_LINES
1831 SET cancel_flag = 'Y',
1832 tax_apportionment_line_number = -1*l_tax_apportionment_line_num,
1833 tax_amt = 0,
1834 tax_amt_tax_curr = 0,
1835 tax_amt_funcl_curr = 0,
1836 unrounded_tax_amt = 0
1837 WHERE tax_line_id = rec.tax_line_id;
1838
1839 IF (g_level_statement >= g_current_runtime_level) THEN
1840 FND_LOG.STRING(g_level_statement,
1841 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row.BEGIN',
1842 'Tax line id updated'||to_char(rec.tax_line_id));
1843 END IF;
1844
1845 BEGIN
1846 select tax_line_id into l_offset_tax_line_id
1847 FROM zx_lines
1848 where application_id = p_application_id
1849 and entity_code = p_entity_code
1850 and event_class_code = p_event_class_code
1851 and offset_link_to_tax_line_id = rec.tax_line_id;
1852
1853 SELECT trx_line_id into l_offset_trx_line_id
1854 FROM zx_lines
1855 WHERE tax_line_id = l_offset_tax_line_id;
1856
1857 SELECT MAX(ABS(tax_apportionment_line_number)) + 1
1858 INTO l_tax_apportionment_line_num
1859 FROM zx_lines
1860 WHERE application_id = p_application_id
1861 AND entity_code = p_entity_code
1862 AND event_class_code = p_event_class_code
1863 AND trx_id = p_trx_id
1864 AND trx_line_id = l_offset_trx_line_id;
1865
1866 UPDATE ZX_LINES
1867 SET cancel_flag = 'Y',
1868 tax_amt = 0,
1869 tax_apportionment_line_number = -1*l_tax_apportionment_line_num,
1870 unrounded_tax_amt = 0,
1871 tax_amt_tax_curr = 0,
1872 tax_amt_funcl_curr = 0,
1873 process_for_recovery_flag = 'Y'
1874 WHERE tax_line_id = l_offset_tax_line_id;
1875
1876 EXCEPTION
1877 WHEN OTHERS THEN
1878 NULL;
1879 END;
1880
1881 IF (g_level_statement >= g_current_runtime_level) THEN
1882 FND_LOG.STRING(g_level_statement,
1883 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row.BEGIN',
1884 'Tax line id updated'||to_char(l_offset_tax_line_id));
1885 END IF;
1886
1887 IF (g_level_procedure >= g_current_runtime_level ) THEN
1888 FND_LOG.STRING(g_level_procedure,
1889 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row',
1890 'tax apportionment line number '||l_tax_apportionment_line_num);
1891 END IF;
1892
1893 l_had_frozen_dists := TRUE;
1894 IF rec.orig_self_assessed_flag IS NULL THEN
1895 IF p_self_assessed_flag = rec.self_assessed_flag THEN
1896 l_orig_self_assessed_flag := NULL;
1897 ELSE
1898 l_orig_self_assessed_flag := nvl(rec.self_assessed_flag,'N');
1899 END IF;
1900 ELSE
1901 l_orig_self_assessed_flag := rec.orig_self_assessed_flag;
1902 END IF;
1903
1904 IF rec.orig_tax_amt_included_flag IS NULL THEN
1905 IF p_tax_amt_included_flag = rec.tax_amt_included_flag THEN
1906 l_orig_tax_amt_included_flag := NULL;
1907 ELSE
1908 l_orig_tax_amt_included_flag := nvl(rec.tax_amt_included_flag,'N');
1909 END IF;
1910 ELSE
1911 l_orig_tax_amt_included_flag := rec.orig_tax_amt_included_flag;
1912 END IF;
1913
1914 zx_trl_detail_override_pkg.Insert_Row
1915 (l_row_id ,
1916 l_tax_line_id ,
1917 p_internal_organization_id ,
1918 rec.application_id ,
1919 rec.entity_code ,
1920 rec.event_class_code ,
1921 rec.event_type_code ,
1922 rec.trx_id ,
1923 rec.trx_line_id ,
1924 rec.trx_level_type ,
1925 rec.trx_line_number ,
1926 rec.doc_event_status ,
1927 rec.tax_event_class_code ,
1928 rec.tax_event_type_code ,
1929 l_tax_line_number ,
1930 rec.content_owner_id ,
1931 rec.tax_regime_id ,
1932 rec.tax_regime_code ,
1933 rec.tax_id ,
1934 rec.tax ,
1935 p_tax_status_id ,
1936 p_tax_status_code ,
1937 p_tax_rate_id ,
1938 p_tax_rate_code ,
1939 l_tax_rate , --tax_rate
1940 rec.tax_rate_type ,
1941 rec.tax_apportionment_line_number , --reduced in size tax_apportionment_line_number
1942 rec.trx_id_level2 ,
1943 rec.trx_id_level3 ,
1944 rec.trx_id_level4 ,
1945 rec.trx_id_level5 ,
1946 rec.trx_id_level6 ,
1947 rec.trx_user_key_level1 ,
1948 rec.trx_user_key_level2 ,
1949 rec.trx_user_key_level3 ,
1950 rec.trx_user_key_level4 ,
1951 rec.trx_user_key_level5 ,
1952 rec.trx_user_key_level6 ,
1953 rec.mrc_tax_line_flag ,
1954 rec.mrc_link_to_tax_line_id ,
1955 rec.ledger_id ,
1956 rec.establishment_id ,
1957 rec.legal_entity_id ,
1958 rec.hq_estb_reg_number ,
1959 rec.hq_estb_party_tax_prof_id ,
1960 rec.currency_conversion_date ,
1961 rec.currency_conversion_type ,
1962 rec.currency_conversion_rate ,
1963 rec.tax_currency_conversion_date , --reduced in size tax_currency_conversion_date
1964 rec.tax_currency_conversion_type , --reduced in size rec.tax_currency_conversion_type
1965 rec.tax_currency_conversion_rate , --reduced in size rec.tax_currency_conversion_rate
1966 rec.trx_currency_code ,
1967 rec.reporting_currency_code ,
1968 rec.minimum_accountable_unit ,
1969 rec.precision ,
1970 p_trx_number ,
1971 rec.trx_date ,
1972 rec.unit_price ,
1973 rec.line_amt ,
1974 rec.trx_line_quantity ,
1975 rec.tax_base_modifier_rate ,
1976 rec.ref_doc_application_id ,
1977 rec.ref_doc_entity_code ,
1978 rec.ref_doc_event_class_code ,
1979 rec.ref_doc_trx_id ,
1980 rec.ref_doc_trx_level_type ,
1981 rec.ref_doc_line_id ,
1982 rec.ref_doc_line_quantity ,
1983 rec.other_doc_line_amt ,
1984 rec.other_doc_line_tax_amt ,
1985 rec.other_doc_line_taxable_amt ,
1986 rec.unrounded_taxable_amt ,
1987 rec.unrounded_tax_amt ,
1988 rec.related_doc_application_id ,
1989 rec.related_doc_entity_code ,
1990 rec.related_doc_event_class_code , --reduced in size rec.related_doc_event_class_code
1991 rec.related_doc_trx_id ,
1992 rec.related_doc_trx_level_type ,
1993 rec.related_doc_number ,
1994 rec.related_doc_date ,
1995 p_applied_from_application_id , --reduced in size rec.applied_from_application_id
1996 rec.applied_from_event_class_code , --reduced in size rec.applied_from_event_class_code
1997 p_applied_from_entity_code ,
1998 rec.applied_from_trx_id ,
1999 rec.applied_from_trx_level_type ,
2000 rec.applied_from_line_id ,
2001 rec.applied_from_trx_number ,
2002 rec.adjusted_doc_application_id , --reduced in size rec.adjusted_doc_application_id
2003 rec.adjusted_doc_entity_code ,
2004 rec.adjusted_doc_event_class_code , --reduced in size rec.adjusted_doc_event_class_code
2005 rec.adjusted_doc_trx_id ,
2006 rec.adjusted_doc_trx_level_type ,
2007 rec.adjusted_doc_line_id ,
2008 rec.adjusted_doc_number ,
2009 rec.adjusted_doc_date ,
2010 rec.applied_to_application_id ,
2011 rec.applied_to_event_class_code , --reduced in size rec.applied_to_event_class_code
2012 rec.applied_to_entity_code ,
2013 rec.applied_to_trx_id ,
2014 rec.applied_to_trx_level_type ,
2015 rec.applied_to_line_id ,
2016 l_summary_tax_line_id , --summary_tax_line_id
2017 rec.offset_link_to_tax_line_id ,
2018 rec.offset_flag ,
2019 rec.process_for_recovery_flag ,
2020 rec.tax_jurisdiction_id ,
2021 p_tax_jurisdiction_code ,
2022 rec.place_of_supply ,
2023 rec.place_of_supply_type_code ,
2024 rec.place_of_supply_result_id ,
2025 rec.tax_date_rule_id ,
2026 rec.tax_date ,
2027 rec.tax_determine_date ,
2028 rec.tax_point_date ,
2029 rec.trx_line_date ,
2030 rec.tax_type_code ,
2031 rec.tax_code ,
2032 rec.tax_registration_id ,
2033 rec.tax_registration_number ,
2034 rec.registration_party_type ,
2035 rec.rounding_level_code ,
2036 rec.rounding_rule_code ,
2037 rec.rounding_lvl_party_tax_prof_id , --reduced in size rec.rounding_lvl_party_tax_prof_id
2038 rec.rounding_lvl_party_type ,
2039 rec.compounding_tax_flag ,
2040 rec.orig_tax_status_id ,
2041 rec.orig_tax_status_code ,
2042 rec.orig_tax_rate_id ,
2043 rec.orig_tax_rate_code ,
2044 rec.orig_tax_rate ,
2045 rec.orig_tax_jurisdiction_id ,
2046 rec.orig_tax_jurisdiction_code ,
2047 l_orig_tax_amt_included_flag ,
2048 l_orig_self_assessed_flag ,
2049 rec.tax_currency_code ,
2050 rec.tax_amt ,
2051 rec.tax_amt_tax_curr ,
2052 rec.tax_amt_funcl_curr ,
2053 rec.taxable_amt ,
2054 rec.taxable_amt_tax_curr ,
2055 rec.taxable_amt_funcl_curr ,
2056 rec.orig_taxable_amt ,
2057 rec.orig_taxable_amt_tax_curr ,
2058 rec.cal_tax_amt ,
2059 rec.cal_tax_amt_tax_curr ,
2060 rec.cal_tax_amt_funcl_curr ,
2061 rec.orig_tax_amt ,
2062 rec.orig_tax_amt_tax_curr ,
2063 rec.rec_tax_amt ,
2064 rec.rec_tax_amt_tax_curr ,
2065 rec.rec_tax_amt_funcl_curr ,
2066 rec.nrec_tax_amt ,
2067 rec.nrec_tax_amt_tax_curr ,
2068 rec.nrec_tax_amt_funcl_curr ,
2069 rec.tax_exemption_id ,
2070 rec.tax_rate_before_exemption ,
2071 rec.tax_rate_name_before_exemption ,
2072 rec.exempt_rate_modifier ,
2073 rec.exempt_certificate_number ,
2074 rec.exempt_reason ,
2075 rec.exempt_reason_code ,
2076 rec.tax_exception_id ,
2077 rec.tax_rate_before_exception ,
2078 rec.tax_rate_name_before_exception ,
2079 rec.exception_rate ,
2080 rec.tax_apportionment_flag ,
2081 rec.historical_flag ,
2082 p_taxable_basis_formula ,
2083 p_tax_calculation_formula ,
2084 nvl(rec.cancel_flag,'N') ,
2085 rec.purge_flag ,
2086 rec.delete_flag ,
2087 p_tax_amt_included_flag ,
2088 p_self_assessed_flag ,
2089 'C' ,
2090 p_manually_entered_flag ,
2091 p_reporting_only_flag ,
2092 rec.freeze_until_overridden_flag , --reduced in size rec.Freeze_Until_Overridden_Flag
2093 rec.copied_from_other_doc_flag ,
2094 rec.recalc_required_flag ,
2095 rec.settlement_flag ,
2096 rec.item_dist_changed_flag ,
2097 NULL , --reduced in size rec.Associated_Child_Frozen_Flag
2098 rec.tax_only_line_flag ,
2099 rec.compounding_tax_flag ,
2100 rec.compounding_tax_miss_flag ,
2101 rec.sync_with_prvdr_flag ,
2102 rec.last_manual_entry ,
2103 rec.tax_provider_id ,
2104 p_record_type_code ,
2105 rec.reporting_period_id ,
2106 rec.legal_justification_text1 ,
2107 rec.legal_justification_text2 ,
2108 rec.legal_justification_text3 ,
2109 rec.legal_message_appl_2 ,
2110 rec.legal_message_status ,
2111 rec.legal_message_rate ,
2112 rec.legal_message_basis ,
2113 rec.legal_message_calc ,
2114 rec.legal_message_threshold ,
2115 rec.legal_message_pos ,
2116 rec.legal_message_trn ,
2117 rec.legal_message_exmpt ,
2118 rec.legal_message_excpt ,
2119 rec.tax_regime_template_id ,
2120 rec.tax_applicability_result_id , --reduced in size rec.tax_applicability_result_id
2121 rec.direct_rate_result_id ,
2122 rec.status_result_id ,
2123 rec.rate_result_id ,
2124 rec.basis_result_id ,
2125 rec.thresh_result_id ,
2126 rec.calc_result_id ,
2127 rec.tax_reg_num_det_result_id ,
2128 rec.eval_exmpt_result_id ,
2129 rec.eval_excpt_result_id ,
2130 rec.enforce_from_natural_acct_flag , --reduced in size rec.Enforce_From_Natural_Acct_Flag
2131 rec.tax_hold_code ,
2132 rec.tax_hold_released_code ,
2133 rec.prd_total_tax_amt ,
2134 rec.prd_total_tax_amt_tax_curr ,
2135 rec.prd_total_tax_amt_funcl_curr ,
2136 rec.trx_line_index ,
2137 rec.offset_tax_rate_code ,
2138 rec.proration_code ,
2139 rec.other_doc_source ,
2140 rec.internal_org_location_id ,
2141 rec.line_assessable_value ,
2142 rec.ctrl_total_line_tx_amt ,
2143 rec.applied_to_trx_number ,
2144 rec.attribute_category ,
2145 rec.attribute1 ,
2146 rec.attribute2 ,
2147 rec.attribute3 ,
2148 rec.attribute4 ,
2149 rec.attribute5 ,
2150 rec.attribute6 ,
2151 rec.attribute7 ,
2152 rec.attribute8 ,
2153 rec.attribute9 ,
2154 rec.attribute10 ,
2155 rec.attribute11 ,
2156 rec.attribute12 ,
2157 rec.attribute13 ,
2158 rec.attribute14 ,
2159 rec.attribute15 ,
2160 rec.global_attribute_category ,
2161 rec.global_attribute1 ,
2162 rec.global_attribute2 ,
2163 rec.global_attribute3 ,
2164 rec.global_attribute4 ,
2165 rec.global_attribute5 ,
2166 rec.global_attribute6 ,
2167 rec.global_attribute7 ,
2168 rec.global_attribute8 ,
2169 rec.global_attribute9 ,
2170 rec.global_attribute10 ,
2171 rec.global_attribute11 ,
2172 rec.global_attribute12 ,
2173 rec.global_attribute13 ,
2174 rec.global_attribute14 ,
2175 rec.global_attribute15 ,
2176 rec.numeric1 ,
2177 rec.numeric2 ,
2178 rec.numeric3 ,
2179 rec.numeric4 ,
2180 rec.numeric5 ,
2181 rec.numeric6 ,
2182 rec.numeric7 ,
2183 rec.numeric8 ,
2184 rec.numeric9 ,
2185 rec.numeric10 ,
2186 rec.char1 ,
2187 rec.char2 ,
2188 rec.char3 ,
2189 rec.char4 ,
2190 rec.char5 ,
2191 rec.char6 ,
2192 rec.char7 ,
2193 rec.char8 ,
2194 rec.char9 ,
2195 rec.char10 ,
2196 rec.date1 ,
2197 rec.date2 ,
2198 rec.date3 ,
2199 rec.date4 ,
2200 rec.date5 ,
2201 rec.date6 ,
2202 rec.date7 ,
2203 rec.date8 ,
2204 rec.date9 ,
2205 rec.date10 ,
2206 rec.interface_entity_code ,
2207 rec.interface_tax_line_id ,
2208 rec.taxing_juris_geography_id ,
2209 rec.adjusted_doc_tax_line_id ,
2210 rec.object_version_number ,
2211 rec.last_updated_by ,
2212 rec.last_update_date ,
2213 rec.last_updated_by ,
2214 rec.last_update_date ,
2215 rec.last_update_login);
2216
2217 ELSE -- associated_child_frozen_flag = 'N'
2218
2219 -- new changes
2220 IF l_existing_summary_tax_line_id is NULL AND NOT(l_had_frozen_dists)
2221 THEN
2222
2223 SELECT count(*) INTO l_num_canceled_detail_lines
2224 FROM zx_lines
2225 WHERE application_id = p_application_id
2226 AND entity_code = p_entity_code
2227 AND event_class_code = p_event_class_code
2228 AND trx_id = p_trx_id
2229 AND summary_tax_line_id = p_summary_tax_line_id
2230 AND nvl(cancel_flag,'N')= 'Y';
2231 END IF;
2232
2233 IF l_num_canceled_detail_lines > 0
2234 -- OR l_existing_summary_tax_line_id is NOT NULL
2235 THEN
2236 l_had_frozen_dists := TRUE;
2237 IF l_summary_tax_line_id = p_summary_tax_line_id THEN
2238 SELECT zx_lines_summary_s.NEXTVAL INTO l_summary_tax_line_id FROM DUAL;
2239 END IF;
2240 END IF;
2241
2242 -- update detail tax line with the new summary tax line id
2243 --
2244 IF l_summary_tax_line_id <> p_summary_tax_line_id THEN
2245 BEGIN
2246 UPDATE ZX_LINES
2247 SET summary_tax_line_id = l_summary_tax_line_id
2248 WHERE tax_line_id = rec.tax_line_id;
2249 EXCEPTION
2250 WHEN OTHERS THEN
2251 NULL;
2252 END;
2253 END IF;
2254 -- new changes end
2255
2256 END IF; -- associated_child_frozen_flag
2257 END IF; -- grouping columns
2258 END IF; -- tax_only_line_flag
2259 END LOOP;
2260
2261 IF l_existing_summary_tax_line_id is NULL THEN
2262 UPDATE ZX_LINES_SUMMARY
2263 SET TAX_STATUS_CODE = p_tax_status_code,
2264 TAX_RATE_ID = p_tax_rate_Id,
2265 SUMMARY_TAX_LINE_ID = nvl(l_summary_tax_line_id,p_summary_tax_line_id) ,
2266 TAX_RATE_CODE = p_tax_rate_code,
2267 TAX_RATE = l_tax_rate,
2268 TAX_AMT = p_tax_amt,
2269 OVERRIDDEN_FLAG = p_overridden_flag,
2270 LAST_MANUAL_ENTRY = decode (nvl(p_cancel_flag,'N'), 'N', p_last_manual_entry, 'TAX_AMOUNT'),
2271 ADJUST_TAX_AMT_FLAG = decode (nvl(p_cancel_flag,'N'), 'N', 'Y', ADJUST_TAX_AMT_FLAG),
2272 CANCEL_FLAG = NVL(p_cancel_flag,'N'),
2273 TAX_AMT_INCLUDED_FLAG = p_tax_amt_included_flag,
2274 SELF_ASSESSED_FLAG = p_self_assessed_flag,
2275 TAX_ONLY_LINE_FLAG = p_tax_only_line_flag,
2276 OBJECT_VERSION_NUMBER = NVL(p_object_version_number, OBJECT_VERSION_NUMBER + 1),
2277 LAST_UPDATED_BY = fnd_global.user_id,
2278 LAST_UPDATE_DATE = sysdate,
2279 LAST_UPDATE_LOGIN = fnd_global.login_id
2280 WHERE summary_tax_line_id = p_summary_tax_line_id;
2281 END IF;
2282
2283 IF (g_level_procedure >= g_current_runtime_level ) THEN
2284 FND_LOG.STRING(g_level_procedure,
2285 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row',
2286 'cancel flag is '||p_cancel_flag);
2287 END IF;
2288
2289 IF (g_level_procedure >= g_current_runtime_level ) THEN
2290 FND_LOG.STRING(g_level_procedure,
2291 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row',
2292 'tot detail tax amt'||to_char(l_total_detail_tax_amt));
2293 END IF;
2294 IF (g_level_procedure >= g_current_runtime_level ) THEN
2295 FND_LOG.STRING(g_level_procedure,
2296 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row',
2297 'tot detail taxable amt'||to_char(l_total_detail_taxable_amt));
2298 END IF;
2299
2300 IF (g_level_procedure >= g_current_runtime_level ) THEN
2301 FND_LOG.STRING(g_level_procedure,
2302 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row',
2303 'before cancel flag = N');
2304 END IF;
2305
2306 IF nvl(p_cancel_flag,'N') = 'N' THEN
2307 IF nvl(l_num_det_lines,0) = 1 THEN
2308 IF (g_level_statement >= g_current_runtime_level) THEN
2309 FND_LOG.STRING(g_level_statement,
2310 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row.BEGIN',
2311 'no of det lines 1');
2312 END IF;
2313 UPDATE ZX_LINES
2314 SET UNROUNDED_TAX_AMT = p_tax_amt
2315 WHERE APPLICATION_ID = p_application_id
2316 AND ENTITY_CODE = p_entity_code
2317 AND EVENT_CLASS_CODE = p_event_class_code
2318 AND TRX_ID = p_trx_id
2319 AND SUMMARY_TAX_LINE_ID = l_summary_tax_line_id
2320 AND nvl(cancel_flag,'N') <> 'Y';
2321 ELSE
2322 IF nvl(l_total_detail_tax_amt,0) <> 0 THEN
2323 IF (g_level_statement >= g_current_runtime_level) THEN
2324 FND_LOG.STRING(g_level_statement,
2325 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row.BEGIN',
2326 'tot det tax amt <> 0');
2327 END IF;
2328 UPDATE ZX_LINES
2329 SET UNROUNDED_TAX_AMT = decode(nvl(p_cancel_flag,'N'), 'N', ((unrounded_tax_amt * p_tax_amt)/l_total_detail_tax_amt), 0)
2330 WHERE APPLICATION_ID = p_application_id
2331 AND ENTITY_CODE = p_entity_code
2332 AND EVENT_CLASS_CODE = p_event_class_code
2333 AND TRX_ID = p_trx_id
2334 AND SUMMARY_TAX_LINE_ID = l_summary_tax_line_id
2335 AND nvl(cancel_flag,'N') <> 'Y';
2336 ELSIF nvl(l_total_detail_taxable_amt,0) <> 0 THEN
2337 IF (g_level_statement >= g_current_runtime_level) THEN
2338 FND_LOG.STRING(g_level_statement,
2339 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row.BEGIN',
2340 'tot det taxable amt <> 0');
2341 END IF;
2342 UPDATE ZX_LINES
2343 SET UNROUNDED_TAX_AMT = decode(nvl(p_cancel_flag,'N'), 'N', ((unrounded_taxable_amt * p_tax_amt)/l_total_detail_taxable_amt), 0)
2344 WHERE APPLICATION_ID = p_application_id
2345 AND ENTITY_CODE = p_entity_code
2346 AND EVENT_CLASS_CODE = p_event_class_code
2347 AND TRX_ID = p_trx_id
2348 AND SUMMARY_TAX_LINE_ID = l_summary_tax_line_id
2349 AND nvl(cancel_flag,'N') <> 'Y';
2350 ELSE
2351 IF (g_level_statement >= g_current_runtime_level) THEN
2352 FND_LOG.STRING(g_level_statement,
2353 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row.BEGIN',
2354 'exception');
2355 END IF;
2356 IF p_tax_amt <> 0 THEN
2357 --RAISE Invalid_unrounded_amt;
2358 -- Bug 7227477
2359 IF (g_level_statement >= g_current_runtime_level) THEN
2360 FND_LOG.STRING(g_level_statement,
2361 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row.BEGIN',
2362 'exception -- Tax amount is Not Zero');
2363 END IF;
2364
2365 FND_MESSAGE.Set_Name ('ZX','ZX_TAX_AMT_UPDATE_NOT_ALLOWED');
2366 FND_MSG_PUB.ADD;
2367
2368 END IF;
2369 END IF;
2370 END IF;
2371 END IF; -- cancel_flag ='N'
2372
2373 IF (g_level_procedure >= g_current_runtime_level ) THEN
2374 FND_LOG.STRING(g_level_procedure,
2375 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row',
2376 'before manually entered flag = N');
2377 END IF;
2378 --Recalculation flag for records in zx_lines
2379 -- manual entered tax line:
2380 IF nvl(p_manually_entered_flag,'N') = 'N' THEN
2381 -- this is system generated tax line :
2382 IF nvl(p_tax_amt_included_flag,'N') = 'Y' THEN
2383 IF l_ctrl_ef_ov_cal_line_flag = 'Y' THEN
2384 UPDATE ZX_LINES
2385 SET RECALC_REQUIRED_FLAG = 'Y'
2386 WHERE APPLICATION_ID = p_application_id
2387 AND ENTITY_CODE = p_entity_code
2388 AND EVENT_CLASS_CODE = p_event_class_code
2389 AND TRX_ID = p_trx_id
2390 AND SUMMARY_TAX_LINE_ID = l_summary_tax_line_id
2391 AND nvl(MANUALLY_ENTERED_FLAG,'N') = 'N'
2392 AND nvl(CANCEL_FLAG,'N') = 'N';
2393 END IF;
2394
2395 ELSE
2396 -- tax_amt_included_flag = 'N'
2397 IF nvl(p_compounding_tax_flag,'N') = 'Y' THEN
2398 UPDATE ZX_LINES
2399 SET RECALC_REQUIRED_FLAG = 'Y'
2400 WHERE APPLICATION_ID = p_application_id
2401 AND ENTITY_CODE = p_entity_code
2402 AND EVENT_CLASS_CODE = p_event_class_code
2403 AND TRX_ID = p_trx_id
2404 AND SUMMARY_TAX_LINE_ID = l_summary_tax_line_id
2405 AND nvl(COMPOUNDING_DEP_TAX_FLAG,'N') = 'Y'
2406 AND nvl(CANCEL_FLAG,'N') = 'N';
2407 END IF;
2408 END IF;
2409 END IF;
2410
2411 UPDATE ZX_LINES
2412 SET ORIG_TAX_STATUS_ID = nvl(ORIG_TAX_STATUS_ID, TAX_STATUS_ID),
2413 ORIG_TAX_STATUS_CODE = nvl(ORIG_TAX_STATUS_CODE, TAX_STATUS_CODE),
2414 ORIG_TAX_RATE_ID = nvl(ORIG_TAX_RATE_ID, TAX_RATE_ID),
2415 ORIG_TAX_RATE_CODE = nvl(ORIG_TAX_RATE_CODE, TAX_RATE_CODE),
2416 ORIG_TAX_RATE = nvl(ORIG_TAX_RATE, TAX_RATE),
2417 ORIG_TAXABLE_AMT = nvl(ORIG_TAXABLE_AMT, TAXABLE_AMT),
2418 ORIG_TAXABLE_AMT_TAX_CURR = nvl(ORIG_TAXABLE_AMT_TAX_CURR, TAXABLE_AMT_TAX_CURR),
2419 ORIG_TAX_AMT = nvl(ORIG_TAX_AMT, TAX_AMT),
2420 ORIG_TAX_AMT_TAX_CURR = nvl(ORIG_TAX_AMT_TAX_CURR, TAX_AMT_TAX_CURR),
2421 SYNC_WITH_PRVDR_FLAG = decode(p_tax_provider_id, NULL, 'N', 'Y'),
2422 TAX_STATUS_ID = p_tax_status_id,
2423 TAX_STATUS_CODE = p_tax_status_code,
2424 TAX_RATE_ID = p_tax_rate_id,
2425 TAX_RATE_CODE = p_tax_rate_code,
2426 TAX_RATE = l_tax_rate,
2427 --TAX_AMT = decode(nvl(p_cancel_flag,'N'), 'N', NULL, 0),
2428 TAX_AMT = decode(nvl(p_cancel_flag,'N'), 'N', NULL, 0),
2429 RECALC_REQUIRED_FLAG = decode(nvl(p_cancel_flag,'N'), 'N', 'Y', 'N'),
2430 OVERRIDDEN_FLAG = decode(nvl(p_cancel_flag,'N'), 'N', p_overridden_flag, 'Y'),
2431 SELF_ASSESSED_FLAG = p_self_assessed_flag,
2432 ORIG_SELF_ASSESSED_FLAG = decode(ORIG_SELF_ASSESSED_FLAG,NULL,decode(p_self_assessed_flag,SELF_ASSESSED_FLAG,ORIG_SELF_ASSESSED_FLAG,SELF_ASSESSED_FLAG),ORIG_SELF_ASSESSED_FLAG),
2433 ORIG_TAX_AMT_INCLUDED_FLAG = decode(ORIG_TAX_AMT_INCLUDED_FLAG,NULL,decode(p_tax_amt_included_flag,TAX_AMT_INCLUDED_FLAG,ORIG_TAX_AMT_INCLUDED_FLAG,TAX_AMT_INCLUDED_FLAG),ORIG_TAX_AMT_INCLUDED_FLAG),
2434 LAST_MANUAL_ENTRY = decode(nvl(p_cancel_flag,'N'), 'N', p_last_manual_entry, 'TAX_AMOUNT'),
2435 CANCEL_FLAG = nvl(p_cancel_flag,'N'),
2436 OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
2437 UNROUNDED_TAX_AMT = decode(nvl(p_cancel_flag,'N'),'Y',0,UNROUNDED_TAX_AMT),
2438 PROCESS_FOR_RECOVERY_FLAG = decode(p_reporting_only_flag, 'N', 'Y', 'N'),
2439 SUMMARY_TAX_LINE_ID = nvl(l_existing_summary_tax_line_id,l_summary_tax_line_id) -- new changes
2440 WHERE APPLICATION_ID = p_application_id
2441 AND ENTITY_CODE = p_entity_code
2442 AND EVENT_CLASS_CODE = p_event_class_code
2443 AND TRX_ID = p_trx_id
2444 AND SUMMARY_TAX_LINE_ID = l_summary_tax_line_id
2445 AND nvl(cancel_flag,'N') <> 'Y';
2446
2447 IF (g_level_procedure >= g_current_runtime_level ) THEN
2448 FND_LOG.STRING(g_level_procedure,
2449 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row',
2450 'Update zx_lines_summary (-)');
2451 END IF;
2452
2453 IF (g_level_procedure >= g_current_runtime_level ) THEN
2454 FND_LOG.STRING(g_level_procedure,
2455 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row.END',
2456 'ZX_TRL_SUMMARY_OVERRIDE_PKG: Update_Row (-)');
2457 END IF;
2458 END Update_Row;
2459
2460 PROCEDURE Delete_Row
2461 (x_rowid IN OUT NOCOPY VARCHAR2,
2462 p_summary_tax_line_id NUMBER,
2463 p_internal_organization_id NUMBER,
2464 p_application_id NUMBER,
2465 p_entity_code VARCHAR2,
2466 p_event_class_code VARCHAR2,
2467 p_trx_id NUMBER,
2468 p_summary_tax_line_number NUMBER,
2469 p_trx_number VARCHAR2,
2470 p_applied_from_application_id NUMBER,
2471 p_applied_from_evt_class_code VARCHAR2,--reduced size p_applied_from_event_class_code
2472 p_applied_from_entity_code VARCHAR2,
2473 p_applied_from_trx_id NUMBER,
2474 p_applied_from_trx_level_type VARCHAR2,
2475 p_applied_from_line_id NUMBER,
2476 p_adjusted_doc_application_id NUMBER,
2477 p_adjusted_doc_entity_code VARCHAR2,
2478 p_adjusted_doc_evt_class_code VARCHAR2,--reduced size p_adjusted_doc_event_class_code
2479 p_adjusted_doc_trx_id NUMBER,
2480 p_adjusted_doc_trx_level_type VARCHAR2,
2481 p_applied_to_application_id NUMBER,
2482 p_applied_to_event_class_code VARCHAR2,
2483 p_applied_to_entity_code VARCHAR2,
2484 p_applied_to_trx_id NUMBER,
2485 p_applied_to_trx_level_type VARCHAR2,
2486 p_applied_to_line_id NUMBER,
2487 p_tax_exemption_id NUMBER,
2488 p_tax_rate_before_exemption NUMBER,
2489 p_tax_rate_name_before_exempt VARCHAR2, --reduced size p_tax_rate_name_before_exemption
2490 p_exempt_rate_modifier NUMBER,
2491 p_exempt_certificate_number VARCHAR2,
2492 p_exempt_reason VARCHAR2,
2493 p_exempt_reason_code VARCHAR2,
2494 p_tax_rate_before_exception NUMBER,
2495 p_tax_rate_name_before_except VARCHAR2, --reduced size p_tax_rate_name_before_exception
2496 p_tax_exception_id NUMBER,
2497 p_exception_rate NUMBER,
2498 p_content_owner_id NUMBER,
2499 p_tax_regime_code VARCHAR2,
2500 p_tax VARCHAR2,
2501 p_tax_status_code VARCHAR2,
2502 p_tax_rate_id NUMBER,
2503 p_tax_rate_code VARCHAR2,
2504 p_tax_rate NUMBER,
2505 p_tax_amt NUMBER,
2506 p_tax_amt_tax_curr NUMBER,
2507 p_tax_amt_funcl_curr NUMBER,
2508 p_tax_jurisdiction_code VARCHAR2,
2509 p_total_rec_tax_amt NUMBER,
2510 p_total_rec_tax_amt_func_curr NUMBER,--reduced size p_total_rec_tax_amt_funcl_curr
2511 p_total_rec_tax_amt_tax_curr NUMBER,
2512 p_total_nrec_tax_amt NUMBER,
2513 p_total_nrec_tax_amt_func_curr NUMBER,--reduced size p_total_nrec_tax_amt_funcl_curr
2514 p_total_nrec_tax_amt_tax_curr NUMBER,
2515 p_ledger_id NUMBER,
2516 p_legal_entity_id NUMBER,
2517 p_establishment_id NUMBER,
2518 p_currency_conversion_date DATE,
2519 p_currency_conversion_type VARCHAR2,
2520 p_currency_conversion_rate NUMBER,
2521 p_summarization_template_id NUMBER,
2522 p_taxable_basis_formula VARCHAR2,
2523 p_tax_calculation_formula VARCHAR2,
2524 p_historical_flag VARCHAR2,
2525 p_cancel_flag VARCHAR2,
2526 p_delete_flag VARCHAR2,
2527 p_tax_amt_included_flag VARCHAR2,
2528 p_compounding_tax_flag VARCHAR2,
2529 p_self_assessed_flag VARCHAR2,
2530 p_overridden_flag VARCHAR2,
2531 p_reporting_only_flag VARCHAR2,
2532 p_assoc_child_frozen_flag VARCHAR2,--reduced size p_Associated_Child_Frozen_Flag
2533 p_copied_from_other_doc_flag VARCHAR2,
2534 p_manually_entered_flag VARCHAR2,
2535 p_mrc_tax_line_flag VARCHAR2,
2536 p_last_manual_entry VARCHAR2,
2537 p_record_type_code VARCHAR2,
2538 p_tax_provider_id NUMBER,
2539 p_tax_only_line_flag VARCHAR2,
2540 p_adjust_tax_amt_flag VARCHAR2,
2541 p_attribute_category VARCHAR2,
2542 p_attribute1 VARCHAR2,
2543 p_attribute2 VARCHAR2,
2544 p_attribute3 VARCHAR2,
2545 p_attribute4 VARCHAR2,
2546 p_attribute5 VARCHAR2,
2547 p_attribute6 VARCHAR2,
2548 p_attribute7 VARCHAR2,
2549 p_attribute8 VARCHAR2,
2550 p_attribute9 VARCHAR2,
2551 p_attribute10 VARCHAR2,
2552 p_attribute11 VARCHAR2,
2553 p_attribute12 VARCHAR2,
2554 p_attribute13 VARCHAR2,
2555 p_attribute14 VARCHAR2,
2556 p_attribute15 VARCHAR2,
2557 p_global_attribute_category VARCHAR2,
2558 p_global_attribute1 VARCHAR2,
2559 p_global_attribute2 VARCHAR2,
2560 p_global_attribute3 VARCHAR2,
2561 p_global_attribute4 VARCHAR2,
2562 p_global_attribute5 VARCHAR2,
2563 p_global_attribute6 VARCHAR2,
2564 p_global_attribute7 VARCHAR2,
2565 p_global_attribute8 VARCHAR2,
2566 p_global_attribute9 VARCHAR2,
2567 p_global_attribute10 VARCHAR2,
2568 p_global_attribute11 VARCHAR2,
2569 p_global_attribute12 VARCHAR2,
2570 p_global_attribute13 VARCHAR2,
2571 p_global_attribute14 VARCHAR2,
2572 p_global_attribute15 VARCHAR2,
2573 p_global_attribute16 VARCHAR2,
2574 p_global_attribute17 VARCHAR2,
2575 p_global_attribute18 VARCHAR2,
2576 p_global_attribute19 VARCHAR2,
2577 p_global_attribute20 VARCHAR2,
2578 p_object_version_number NUMBER,
2579 p_created_by NUMBER,
2580 p_creation_date DATE,
2581 p_last_updated_by NUMBER,
2582 p_last_update_date DATE,
2583 p_last_update_login NUMBER) IS
2584
2585 BEGIN
2586 g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2587
2588 IF (g_level_procedure >= g_current_runtime_level ) THEN
2589 FND_LOG.STRING(g_level_procedure,
2590 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Delete_Row.BEGIN',
2591 'ZX_TRL_SUMMARY_OVERRIDE_PKG: Delete_Row (+)');
2592 END IF;
2593
2594 IF (g_level_procedure >= g_current_runtime_level ) THEN
2595 FND_LOG.STRING(g_level_procedure,
2596 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Delete_Row',
2597 'Update zx_lines_summary for DELETE (+)');
2598 END IF;
2599
2600 UPDATE ZX_LINES_SUMMARY
2601 SET DELETE_FLAG = 'Y',
2602 OBJECT_VERSION_NUMBER = NVL(p_object_version_number, OBJECT_VERSION_NUMBER + 1)
2603 WHERE SUMMARY_TAX_LINE_ID = p_summary_tax_line_id;
2604
2605 UPDATE ZX_LINES
2606 SET DELETE_FLAG = 'Y',
2607 SYNC_WITH_PRVDR_FLAG = DECODE(p_tax_provider_id,
2608 NULL, 'N', 'Y'),
2609 OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
2610 WHERE APPLICATION_ID = p_application_id
2611 AND ENTITY_CODE = p_entity_code
2612 AND EVENT_CLASS_CODE = p_event_class_code
2613 AND TRX_ID = p_trx_id
2614 AND SUMMARY_TAX_LINE_ID = p_summary_tax_line_id;
2615
2616 IF ( SQL%NOTFOUND ) THEN
2617 RAISE NO_DATA_FOUND;
2618 END IF;
2619
2620 IF (g_level_procedure >= g_current_runtime_level ) THEN
2621 FND_LOG.STRING(g_level_procedure,
2622 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Delete_Row',
2623 'Update zx_lines_summary for DELETE (-)');
2624 FND_LOG.STRING(g_level_procedure,
2625 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Delete_Row.END',
2626 'ZX_TRL_SUMMARY_OVERRIDE_PKG.Delete_Row (-)');
2627 END IF;
2628
2629 END Delete_Row;
2630
2631 PROCEDURE Override_Row
2632 (p_application_id NUMBER,
2633 p_entity_code VARCHAR2,
2634 p_event_class_code VARCHAR2,
2635 p_trx_id NUMBER,
2636 p_event_id NUMBER,
2637 p_summary_tax_line_id NUMBER) IS
2638
2639 BEGIN
2640 g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2641
2642 IF (g_level_procedure >= g_current_runtime_level ) THEN
2643 FND_LOG.STRING(g_level_procedure,
2644 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Override_Row.BEGIN',
2645 'ZX_TRL_SUMMARY_OVERRIDE_PKG: Override_Row (+)');
2646
2647 END IF;
2648
2649 IF (g_level_procedure >= g_current_runtime_level ) THEN
2650 FND_LOG.STRING(g_level_procedure,
2651 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Override_Row',
2652 'Update zx_lines_det_factors (+)');
2653 END IF;
2654
2655 UPDATE ZX_LINES_DET_FACTORS
2656 SET EVENT_ID = p_event_id
2657 WHERE APPLICATION_ID = p_application_id
2658 AND ENTITY_CODE = p_entity_code
2659 AND EVENT_CLASS_CODE = p_event_class_code
2660 AND TRX_ID = p_trx_id
2661 AND (TRX_LINE_ID, TRX_LEVEL_TYPE)
2662 IN (SELECT TRX_LINE_ID, TRX_LEVEL_TYPE
2663 FROM ZX_LINES
2664 WHERE APPLICATION_ID = p_application_id
2665 AND ENTITY_CODE = p_entity_code
2666 AND EVENT_CLASS_CODE = p_event_class_code
2667 AND TRX_ID = p_trx_id
2668 AND SUMMARY_TAX_LINE_ID = p_summary_tax_line_id);
2669
2670 IF (g_level_procedure >= g_current_runtime_level ) THEN
2671 FND_LOG.STRING(g_level_procedure,
2672 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Override_Row',
2673 'Update zx_lines_det_factors (-)');
2674 END IF;
2675
2676 IF (g_level_procedure >= g_current_runtime_level ) THEN
2677 FND_LOG.STRING(g_level_procedure,
2678 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Override_Row.END',
2679 'ZX_TRL_SUMMARY_OVERRIDE_PKG: Override_Row (-)');
2680 END IF;
2681
2682 --commit;
2683 END Override_Row;
2684
2685 PROCEDURE Check_Unique
2686 (p_internal_organization_id NUMBER,
2687 p_application_id NUMBER,
2688 p_entity_code VARCHAR2,
2689 p_event_class_code VARCHAR2,
2690 p_trx_id NUMBER,
2691 p_tax_regime_code VARCHAR2,
2692 p_tax VARCHAR2,
2693 p_tax_status_code VARCHAR2,
2694 p_tax_rate_code VARCHAR2) IS
2695
2696 l_key_check NUMBER;
2697 debug_info VARCHAR2(100);
2698
2699 BEGIN
2700
2701 g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2702
2703 IF (g_level_procedure >= g_current_runtime_level ) THEN
2704 FND_LOG.STRING(g_level_procedure,
2705 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Check_Unique',
2706 'Validation for logical primary key (+)');
2707 END IF;
2708
2709 BEGIN
2710
2711 --User would be prevented from entering a manual tax line with the same
2712 --tax if such a tax line already exists for the transaction line
2713 --Validation for logical primary key
2714 SELECT count(*)
2715 INTO l_key_check
2716 FROM ZX_LINES_SUMMARY LS
2717 WHERE APPLICATION_ID = p_application_id
2718 AND ENTITY_CODE = p_entity_code
2719 AND EVENT_CLASS_CODE = p_event_class_code
2720 AND INTERNAL_ORGANIZATION_ID = p_internal_organization_id
2721 AND TRX_ID = p_trx_id
2722 AND TAX_REGIME_CODE = p_tax_regime_code
2723 AND TAX = p_tax
2724 AND TAX_STATUS_CODE = p_tax_status_code
2725 AND TAX_RATE_CODE = p_tax_rate_code;
2726
2727 IF l_key_check >= 1 THEN
2728 FND_MESSAGE.SET_TOKEN('Error:', 'CANNOT CREATE RECORD' );
2729 FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
2730 APP_EXCEPTION.RAISE_EXCEPTION;
2731 END IF;
2732
2733 END;
2734
2735 IF (g_level_procedure >= g_current_runtime_level ) THEN
2736 FND_LOG.STRING(g_level_procedure,
2737 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Check_Unique',
2738 'Validation for logical primary key (-)');
2739 END IF;
2740
2741 END Check_Unique;
2742
2743 PROCEDURE lock_summ_tax_lines_for_doc
2744 (p_application_id IN NUMBER,
2745 p_entity_code IN VARCHAR2,
2746 p_event_class_code IN VARCHAR2,
2747 p_trx_id IN NUMBER,
2748 x_return_status OUT NOCOPY VARCHAR2,
2749 x_error_buffer OUT NOCOPY VARCHAR2) IS
2750
2751 l_return_status VARCHAR2(1000);
2752
2753 /*Cursor to Lock the tax lines for the entire document*/
2754 CURSOR lock_sum_tax_lines_for_doc_csr(c_application_id NUMBER,
2755 c_event_class_code VARCHAR2,
2756 c_entity_code VARCHAR2,
2757 c_trx_id NUMBER) IS
2758 SELECT *
2759 FROM ZX_LINES_SUMMARY
2760 WHERE application_id = c_application_id
2761 AND entity_code = c_entity_code
2762 AND event_class_code = c_event_class_code
2763 AND trx_id = c_trx_id
2764 FOR UPDATE NOWAIT;
2765
2766 BEGIN
2767 x_return_status := FND_API.G_RET_STS_SUCCESS;
2768
2769 g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2770
2771 IF (g_level_procedure >= g_current_runtime_level ) THEN
2772 FND_LOG.STRING(g_level_procedure,
2773 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.lock_summ_tax_lines_for_doc.BEGIN',
2774 'ZX_TRL_SUMMARY_OVERRIDE_PKG: lock_summ_tax_lines_for_doc (+)');
2775 END IF;
2776
2777 OPEN lock_sum_tax_lines_for_doc_csr(p_application_id,
2778 p_event_class_code,
2779 p_entity_code,
2780 p_trx_id);
2781 CLOSE lock_sum_tax_lines_for_doc_csr;
2782
2783 IF (g_level_procedure >= g_current_runtime_level ) THEN
2784 FND_LOG.STRING(g_level_procedure,
2785 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.lock_summ_tax_lines_for_doc.END',
2786 'ZX_TRL_SUMMARY_OVERRIDE_PKG: lock_summ_tax_lines_for_doc (-)');
2787 END IF;
2788 EXCEPTION
2789 WHEN OTHERS THEN
2790 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2791 x_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
2792
2793 FND_MESSAGE.SET_NAME('ZX','ZX_UNEXPECTED_ERROR');
2794 FND_MSG_PUB.Add;
2795
2796 IF (g_level_procedure >= g_current_runtime_level ) THEN
2797 FND_LOG.STRING(g_level_procedure,
2798 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.lock_summ_tax_lines_for_doc',
2799 'Exception:' ||x_error_buffer);
2800 END IF;
2801 END lock_summ_tax_lines_for_doc;
2802
2803
2804
2805 END ZX_TRL_SUMMARY_OVERRIDE_PKG;