[Home] [Help]
PACKAGE BODY: APPS.ZX_TRL_ALLOCATIONS_PKG
Source
1 PACKAGE BODY ZX_TRL_ALLOCATIONS_PKG AS
2 /* $Header: zxriallocatnpkgb.pls 120.23.12010000.3 2008/12/11 23:28:33 appradha 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 PROCEDURE Insert_Row
11 (X_Rowid IN OUT NOCOPY VARCHAR2,
12 p_summary_tax_line_id NUMBER,
13 p_internal_organization_id NUMBER,
14 p_application_id NUMBER,
15 p_entity_code VARCHAR2,
16 p_event_class_code VARCHAR2,
17 p_event_type_code VARCHAR2,
18 p_trx_line_number NUMBER,--
19 p_trx_id NUMBER,
20 p_trx_number VARCHAR2,--
21 p_trx_line_id NUMBER,--
22 p_trx_level_type VARCHAR2,
23 p_line_amt NUMBER,--
24 p_trx_line_date DATE,--
25 p_tax_regime_code VARCHAR2,
26 p_tax VARCHAR2,
27 p_tax_jurisdiction_code VARCHAR2,
28 p_tax_status_code VARCHAR2,
29 p_tax_rate_id NUMBER,
30 p_tax_rate_code VARCHAR2,
31 p_tax_rate NUMBER,
32 p_tax_amt NUMBER,
33 p_enabled_record VARCHAR2,
34 p_manually_entered_flag VARCHAR2,
35 p_content_owner_id NUMBER,
36 p_record_type_code VARCHAR2,
37 p_last_manual_entry VARCHAR2,
38 p_trx_line_amt NUMBER,
39 p_tax_amt_included_flag VARCHAR2,
40 p_self_assessed_flag VARCHAR2,
41 p_tax_only_line_flag VARCHAR2,
42 p_created_by NUMBER,
43 p_creation_date DATE,
44 p_last_updated_by NUMBER,
45 p_last_update_date DATE,
46 p_last_update_login NUMBER) IS
47
48 l_tax_line_id NUMBER;
49 l_tax_line_number NUMBER;
50 l_minimum_accountable_unit NUMBER;
51 l_precision NUMBER;
52 l_trx_currency_code VARCHAR2(20);
53
54 BEGIN
55
56 g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
57
58 IF (g_level_procedure >= g_current_runtime_level ) THEN
59 FND_LOG.STRING(g_level_procedure,
60 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_Row.BEGIN',
61 'Insert_Row (+)');
62 END IF;
63
64 IF (g_level_procedure >= g_current_runtime_level ) THEN
65 FND_LOG.STRING(g_level_procedure,
66 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_Row',
67 'Insert into zx_lines for allocation of lines. (+)');
68 END IF;
69
70 IF (g_level_procedure >= g_current_runtime_level ) THEN
71 FND_LOG.STRING(g_level_procedure,
72 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_Row',
73 'Is Record enabled: '|| p_enabled_record);
74
75 FND_LOG.STRING(g_level_procedure,
76 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_Row',
77 'Summary Tax Line Id: '|| to_char(p_summary_tax_line_id));
78
79 FND_LOG.STRING(g_level_procedure,
80 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_Row',
81 'Trx Id: '|| to_char(p_trx_id));
82 END IF;
83
84 IF p_enabled_record ='Y' THEN
85 SELECT NVL(max(TAX_LINE_NUMBER),0)+1
86 INTO l_tax_line_number
87 FROM ZX_LINES
88 WHERE APPLICATION_ID = p_application_id
89 AND EVENT_CLASS_CODE = p_event_class_code
90 AND ENTITY_CODE = p_entity_code
91 AND TRX_ID = p_trx_id
92 AND TRX_LINE_ID = p_trx_line_id
93 AND TRX_LEVEL_TYPE = p_trx_level_type;
94
95 SELECT zx_lines_s.nextval
96 INTO l_tax_line_id
97 FROM dual;
98
99 SELECT distinct precision,minimum_accountable_unit,trx_currency_code
100 INTO l_precision, l_minimum_accountable_unit, l_trx_currency_code
101 FROM zx_lines_det_factors zxd, zx_lines_summary zxs
102 WHERE zxd.trx_id = zxs.trx_id
103 AND zxs.summary_tax_line_id = p_summary_tax_line_id;
104
105
106 ZX_TRL_DETAIL_OVERRIDE_PKG.Insert_row
107 (x_rowid => X_Rowid,
108 p_tax_line_id => l_tax_line_id,
109 p_internal_organization_id => p_internal_organization_id,
110 p_application_id => p_application_id,
111 p_entity_code => p_entity_code,
112 p_event_class_code => p_event_class_code,
113 p_event_type_code => NULL,
114 p_trx_id => p_trx_id,
115 p_trx_line_id => p_trx_line_id,
116 p_trx_level_type => p_trx_level_type,
117 p_trx_line_number => p_trx_line_number,
118 p_doc_event_status => NULL,
119 p_tax_event_class_code => NULL,
120 p_tax_event_type_code => NULL,
121 p_tax_line_number => l_tax_line_number,
122 p_content_owner_id => p_content_owner_id,
123 p_tax_regime_id => NULL,
124 p_tax_regime_code => p_tax_regime_code,
125 p_tax_id => NULL,
126 p_tax => p_tax,
127 p_tax_status_id => NULL,
128 p_tax_status_code => p_tax_status_code,
129 p_tax_rate_id => p_tax_rate_id,
130 p_tax_rate_code => p_tax_rate_code,
131 p_tax_rate => p_tax_rate,
132 p_tax_rate_type => NULL,
133 p_tax_apportionment_line_num => NULL,
134 p_trx_id_level2 => NULL,
135 p_trx_id_level3 => NULL,
136 p_trx_id_level4 => NULL,
137 p_trx_id_level5 => NULL,
138 p_trx_id_level6 => NULL,
139 p_trx_user_key_level1 => NULL,
140 p_trx_user_key_level2 => NULL,
141 p_trx_user_key_level3 => NULL,
142 p_trx_user_key_level4 => NULL,
143 p_trx_user_key_level5 => NULL,
144 p_trx_user_key_level6 => NULL,
145 p_mrc_tax_line_flag => 'N',
146 p_mrc_link_to_tax_line_id => NULL,
147 p_ledger_id => NULL,
148 p_establishment_id => NULL,
149 p_legal_entity_id => NULL,
150 --p_legal_entity_tax_reg_number => NULL,
151 p_hq_estb_reg_number => NULL,
152 p_hq_estb_party_tax_prof_id => NULL,
153 p_currency_conversion_date => NULL,
154 p_currency_conversion_type => NULL,
155 p_currency_conversion_rate => NULL,
156 p_tax_curr_conversion_date => NULL,
157 p_tax_curr_conversion_type => NULL,
158 p_tax_curr_conversion_rate => NULL,
159 p_trx_currency_code => l_trx_currency_code,
160 p_reporting_currency_code => NULL,
161 p_minimum_accountable_unit => l_minimum_accountable_unit,
162 p_precision => l_precision,
163 p_trx_number => p_trx_number,
164 p_trx_date => NULL,
165 p_unit_price => NULL,
166 p_line_amt => p_trx_line_amt,
167 p_trx_line_quantity => NULL,
168 p_tax_base_modifier_rate => NULL,
169 p_ref_doc_application_id => NULL,
170 p_ref_doc_entity_code => NULL,
171 p_ref_doc_event_class_code => NULL,
172 p_ref_doc_trx_id => NULL,
173 p_ref_doc_trx_level_type => NULL,
174 p_ref_doc_line_id => NULL,
175 p_ref_doc_line_quantity => NULL,
176 p_other_doc_line_amt => NULL,
177 p_other_doc_line_tax_amt => NULL,
178 p_other_doc_line_taxable_amt => NULL,
179 p_unrounded_taxable_amt => p_trx_line_amt,
180 p_unrounded_tax_amt => p_tax_amt,
181 p_related_doc_application_id => NULL,
182 p_related_doc_entity_code => NULL,
183 p_related_doc_evt_class_code => NULL,
184 p_related_doc_trx_id => NULL,
185 p_related_doc_trx_level_type => NULL,
186 p_related_doc_number => NULL,
187 p_related_doc_date => NULL,
188 p_applied_from_appl_id => NULL,
189 p_applied_from_evt_clss_code => NULL,
190 p_applied_from_entity_code => NULL,
191 p_applied_from_trx_id => NULL,
192 p_applied_from_trx_level_type => NULL,
193 p_applied_from_line_id => NULL,
194 p_applied_from_trx_number => NULL,
195 p_adjusted_doc_appln_id => NULL,
196 p_adjusted_doc_entity_code => NULL,
197 p_adjusted_doc_evt_clss_code => NULL,
198 p_adjusted_doc_trx_id => NULL,
199 p_adjusted_doc_trx_level_type => NULL,
200 p_adjusted_doc_line_id => NULL,
201 p_adjusted_doc_number => NULL,
202 p_adjusted_doc_date => NULL,
203 p_applied_to_application_id => NULL,
204 p_applied_to_evt_class_code => NULL,
205 p_applied_to_entity_code => NULL,
206 p_applied_to_trx_id => NULL,
207 p_applied_to_trx_level_type => NULL,
208 p_applied_to_line_id => NULL,
209 p_summary_tax_line_id => p_summary_tax_line_id,
210 p_offset_link_to_tax_line_id => NULL,
211 p_offset_flag => 'N',
212 p_process_for_recovery_flag => 'N',
213 p_tax_jurisdiction_id => NULL,
214 p_tax_jurisdiction_code => p_tax_jurisdiction_code,
215 p_place_of_supply => NULL,
216 p_place_of_supply_type_code => NULL,
217 p_place_of_supply_result_id => NULL,
218 p_tax_date_rule_id => NULL,
219 p_tax_date => NULL,
220 p_tax_determine_date => sysdate,
221 p_tax_point_date => NULL,
222 p_trx_line_date => p_trx_line_date,
223 p_tax_type_code => NULL,
224 p_tax_code => NULL,
225 p_tax_registration_id => NULL,
226 p_tax_registration_number => NULL,
227 p_registration_party_type => NULL,
228 p_rounding_level_code => 'HEADER',
229 p_rounding_rule_code => NULL,
230 p_rndg_lvl_party_tax_prof_id => NULL,
231 p_rounding_lvl_party_type => NULL,
232 p_compounding_tax_flag => 'N',
233 p_orig_tax_status_id => NULL,
234 p_orig_tax_status_code => NULL,
235 p_orig_tax_rate_id => NULL,
236 p_orig_tax_rate_code => NULL,
237 p_orig_tax_rate => NULL,
238 p_orig_tax_jurisdiction_id => NULL,
239 p_orig_tax_jurisdiction_code => NULL,
240 p_orig_tax_amt_included_flag => 'N',
241 p_orig_self_assessed_flag => 'N',
242 p_tax_currency_code => NULL,
243 p_tax_amt => p_tax_amt,
244 p_tax_amt_tax_curr => NULL,
245 p_tax_amt_funcl_curr => NULL,
246 p_taxable_amt => NULL,
247 p_taxable_amt_tax_curr => NULL,
248 p_taxable_amt_funcl_curr => NULL,
249 p_orig_taxable_amt => NULL,
250 p_orig_taxable_amt_tax_curr => NULL,
251 p_cal_tax_amt => NULL,
252 p_cal_tax_amt_tax_curr => NULL,
253 p_cal_tax_amt_funcl_curr => NULL,
254 p_orig_tax_amt => NULL,
255 p_orig_tax_amt_tax_curr => NULL,
256 p_rec_tax_amt => NULL,
257 p_rec_tax_amt_tax_curr => NULL,
258 p_rec_tax_amt_funcl_curr => NULL,
259 p_nrec_tax_amt => NULL,
260 p_nrec_tax_amt_tax_curr => NULL,
261 p_nrec_tax_amt_funcl_curr => NULL,
262 p_tax_exemption_id => NULL,
263 p_tax_rate_before_exemption => NULL,
264 p_tax_rate_name_before_exempt => NULL,
265 p_exempt_rate_modifier => NULL,
266 p_exempt_certificate_number => NULL,
267 p_exempt_reason => NULL,
268 p_exempt_reason_code => NULL,
269 p_tax_exception_id => NULL,
270 p_tax_rate_before_exception => NULL,
271 p_tax_rate_name_before_except => NULL,
272 p_exception_rate => NULL,
273 p_tax_apportionment_flag => 'N',
274 p_historical_flag => 'N',
275 p_taxable_basis_formula => NULL,
276 p_tax_calculation_formula => NULL,
277 p_cancel_flag => 'N',
278 p_purge_flag => 'N',
279 p_delete_flag => 'N',
280 p_tax_amt_included_flag => p_tax_amt_included_flag,
281 p_self_assessed_flag => p_self_assessed_flag,
282 p_overridden_flag => 'N',
283 p_manually_entered_flag => p_manually_entered_flag,
284 p_reporting_only_flag => 'N',
285 p_freeze_until_overriddn_flg => 'N',
286 p_copied_from_other_doc_flag => 'N',
290 p_assoc_children_frozen_flg => 'N',
287 p_recalc_required_flag => 'Y',
288 p_settlement_flag => 'N',
289 p_item_dist_changed_flag => 'N',
291 p_tax_only_line_flag => p_tax_only_line_flag,
292 p_compounding_dep_tax_flag => 'N',
293 p_compounding_tax_miss_flag => 'N',
294 p_sync_with_prvdr_flag => 'N',
295 p_last_manual_entry => p_last_manual_entry,
296 p_tax_provider_id => NULL,
297 p_record_type_code => p_record_type_code,
298 p_reporting_period_id => NULL,
299 p_legal_justification_text1 => NULL,
300 p_legal_justification_text2 => NULL,
301 p_legal_justification_text3 => NULL,
302 p_legal_message_appl_2 => NULL,
303 p_legal_message_status => NULL,
304 p_legal_message_rate => NULL,
305 p_legal_message_basis => NULL,
306 p_legal_message_calc => NULL,
307 p_legal_message_threshold => NULL,
308 p_legal_message_pos => NULL,
309 p_legal_message_trn => NULL,
310 p_legal_message_exmpt => NULL,
311 p_legal_message_excpt => NULL,
312 p_tax_regime_template_id => NULL,
313 p_tax_applicability_result_id => NULL,
314 p_direct_rate_result_id => NULL,
315 p_status_result_id => NULL,
316 p_rate_result_id => NULL,
317 p_basis_result_id => NULL,
318 p_thresh_result_id => NULL,
319 p_calc_result_id => NULL,
320 p_tax_reg_num_det_result_id => NULL,
321 p_eval_exmpt_result_id => NULL,
322 p_eval_excpt_result_id => NULL,
323 p_enforced_from_nat_acct_flg => 'N',
324 p_tax_hold_code => NULL,
325 p_tax_hold_released_code => NULL,
326 p_prd_total_tax_amt => NULL,
327 p_prd_total_tax_amt_tax_curr => NULL,
328 p_prd_total_tax_amt_funcl_curr => NULL,
329 p_trx_line_index => NULL,
330 p_offset_tax_rate_code => NULL,
331 p_proration_code => NULL,
332 p_other_doc_source => NULL,
333 p_internal_org_location_id => NULL,
334 p_line_assessable_value => NULL,
335 p_ctrl_total_line_tx_amt => NULL,
336 p_applied_to_trx_number => NULL,
337 p_attribute_category => NULL,
338 p_attribute1 => NULL,
339 p_attribute2 => NULL,
340 p_attribute3 => NULL,
341 p_attribute4 => NULL,
342 p_attribute5 => NULL,
343 p_attribute6 => NULL,
344 p_attribute7 => NULL,
345 p_attribute8 => NULL,
346 p_attribute9 => NULL,
347 p_attribute10 => NULL,
348 p_attribute11 => NULL,
349 p_attribute12 => NULL,
350 p_attribute13 => NULL,
351 p_attribute14 => NULL,
352 p_attribute15 => NULL,
353 p_global_attribute_category => NULL,
354 p_global_attribute1 => NULL,
355 p_global_attribute2 => NULL,
356 p_global_attribute3 => NULL,
357 p_global_attribute4 => NULL,
358 p_global_attribute5 => NULL,
359 p_global_attribute6 => NULL,
360 p_global_attribute7 => NULL,
361 p_global_attribute8 => NULL,
362 p_global_attribute9 => NULL,
363 p_global_attribute10 => NULL,
364 p_global_attribute11 => NULL,
365 p_global_attribute12 => NULL,
366 p_global_attribute13 => NULL,
367 p_global_attribute14 => NULL,
368 p_global_attribute15 => NULL,
369 p_numeric1 => NULL,
370 p_numeric2 => NULL,
371 p_numeric3 => NULL,
372 p_numeric4 => NULL,
373 p_numeric5 => NULL,
374 p_numeric6 => NULL,
375 p_numeric7 => NULL,
376 p_numeric8 => NULL,
377 p_numeric9 => NULL,
378 p_numeric10 => NULL,
379 p_char1 => NULL,
380 p_char2 => NULL,
381 p_char3 => NULL,
382 p_char4 => NULL,
383 p_char5 => NULL,
384 p_char6 => NULL,
385 p_char7 => NULL,
386 p_char8 => NULL,
387 p_char9 => NULL,
388 p_char10 => NULL,
389 p_date1 => NULL,
390 p_date2 => NULL,
394 p_date6 => NULL,
391 p_date3 => NULL,
392 p_date4 => NULL,
393 p_date5 => NULL,
395 p_date7 => NULL,
396 p_date8 => NULL,
397 p_date9 => NULL,
398 p_date10 => NULL,
399 p_interface_entity_code => NULL,
400 p_interface_tax_line_id => NULL,
401 p_taxing_juris_geography_id => NULL,
402 p_adjusted_doc_tax_line_id => NULL,
403 p_object_version_number => 1,
404 p_created_by => fnd_global.user_id,
405 p_creation_date => sysdate,
406 p_last_updated_by => fnd_global.user_id,
407 p_last_update_date => sysdate,
408 p_last_update_login => fnd_global.login_id);
409
410 END IF;
411
412 IF (g_level_procedure >= g_current_runtime_level ) THEN
413 FND_LOG.STRING(g_level_procedure,
414 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_Row',
415 'Insert into zx_lines for allocation of lines. (-)');
416 END IF;
417
418 IF (g_level_procedure >= g_current_runtime_level ) THEN
419 FND_LOG.STRING(g_level_procedure,
420 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_Row.END',
421 'Insert_Row (-)');
422 END IF;
423 EXCEPTION
424 WHEN NO_DATA_FOUND THEN
425 NULL;
426
427 END Insert_Row;
428
429 PROCEDURE Update_tax_amt
430 (p_summary_tax_line_id NUMBER,
431 p_application_id NUMBER,
432 p_entity_code VARCHAR2,
433 p_event_class_code VARCHAR2,
434 p_trx_id NUMBER) IS
435
436 l_total_tax_amt NUMBER;
437 l_detail_tax_amt NUMBER;
438 --l_tax_line_id NUMBER;
439 l_summary_tax_amt NUMBER;
440 l_total_trx_line_amt NUMBER;
441 l_unrounded_tax_amt NUMBER;
442
443 BEGIN
444
445 g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
446
447 IF (g_level_procedure >= g_current_runtime_level ) THEN
448 FND_LOG.STRING(g_level_procedure,
449 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Update_tax_amt.BEGIN',
450 'Update_tax_amt (+)');
451 END IF;
452
453 l_total_tax_amt :=0;
454 l_detail_tax_amt :=0;
455 l_summary_tax_amt :=0;
456 l_total_trx_line_amt :=0;
457 l_unrounded_tax_amt :=0;
458
459
460 IF (g_level_procedure >= g_current_runtime_level ) THEN
461 FND_LOG.STRING(g_level_procedure,
462 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Update_tax_amt',
463 'Update tax_amount in zx_lines for allocation of lines. (+)');
464 END IF;
465
466 SELECT TAX_AMT
467 INTO l_summary_tax_amt
468 FROM ZX_LINES_SUMMARY
469 WHERE SUMMARY_TAX_LINE_ID = p_summary_tax_line_id;
470
471 IF (g_level_statement >= g_current_runtime_level ) THEN
472 FND_LOG.STRING(g_level_statement,
473 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Update_tax_amt',
474 'Summary tax amount '||to_char(l_summary_tax_amt));
475 END IF;
476 SELECT SUM(LINE_AMT)
477 INTO l_total_trx_line_amt
478 FROM ZX_LINES
479 WHERE SUMMARY_TAX_LINE_ID = p_summary_tax_line_id
480 AND APPLICATION_ID = p_application_id
481 AND ENTITY_CODE = p_entity_code
482 AND EVENT_CLASS_CODE = p_event_class_code
483 AND TRX_ID = p_trx_id;
484
485 IF (g_level_statement >= g_current_runtime_level ) THEN
486 FND_LOG.STRING(g_level_statement,
487 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Update_tax_amt',
488 'total trx line amount '||to_char(l_total_trx_line_amt));
489 END IF;
490
491 SELECT SUM(unrounded_tax_amt)
492 INTO l_unrounded_tax_amt
493 FROM ZX_LINES
494 WHERE SUMMARY_TAX_LINE_ID = p_summary_tax_line_id
495 AND APPLICATION_ID = p_application_id
496 AND ENTITY_CODE = p_entity_code
497 AND EVENT_CLASS_CODE = p_event_class_code
498 AND TRX_ID = p_trx_id;
499
500 IF (g_level_statement >= g_current_runtime_level ) THEN
501 FND_LOG.STRING(g_level_statement,
502 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Update_tax_amt',
503 'total trxline amt'||to_char(l_total_trx_line_amt)||' unrounded amt '||to_char(l_unrounded_tax_amt)||'summary tax amount '||to_char(l_summary_tax_amt));
504 END IF;
505 IF l_total_trx_line_amt <> 0 THEN
506 UPDATE ZX_LINES
507 SET
508 unrounded_tax_amt = ((unrounded_tax_amt * l_summary_tax_amt) / l_total_trx_line_amt)
509 WHERE SUMMARY_TAX_LINE_ID = p_summary_tax_line_id
510 AND APPLICATION_ID = p_application_id
511 AND ENTITY_CODE = p_entity_code
512 AND EVENT_CLASS_CODE = p_event_class_code
513 AND TRX_ID = p_trx_id;
514 END IF;
515
516
517 IF (g_level_procedure >= g_current_runtime_level ) THEN
518 FND_LOG.STRING(g_level_procedure,
522
519 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Update_tax_amt',
520 'Update tax_amount in zx_lines for allocation of lines. (-)');
521 END IF;
523 IF (g_level_procedure >= g_current_runtime_level ) THEN
524 FND_LOG.STRING(g_level_procedure,
525 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Update_tax_amt.END',
526 'Update_tax_amt (-)');
527 END IF;
528 END Update_tax_amt;
529
530 PROCEDURE Populate_Allocation
531 (p_statement VARCHAR2,
532 p_trx_record OUT NOCOPY trx_record_tbl_type) IS
533
534 i NUMBER;
535
536 TYPE EmpCurTyp IS REF CURSOR;
537 ALLOC EmpCurTyp;
538
539 BEGIN
540
541 g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
542
543 i := 0;
544
545 IF (g_level_procedure >= g_current_runtime_level ) THEN
546 FND_LOG.STRING(g_level_procedure,
547 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Populate_Allocation.BEGIN',
548 'Populate_Allocation (+)');
549 END IF;
550
551 OPEN ALLOC FOR p_statement;
552 LOOP
553 i := i + 1;
554 FETCH ALLOC INTO p_trx_record.p_trx_id(i),
555 p_trx_record.p_trx_line_id(i),
556 p_trx_record.p_trx_level_type(i),
557 p_trx_record.p_trx_number(i),
558 p_trx_record.p_trx_line_number(i),
559 p_trx_record.p_trx_line_description(i),
560 p_trx_record.p_line_amt(i),
561 p_trx_record.p_trx_line_date(i);
562
563 EXIT WHEN ALLOC%NOTFOUND;
564 END LOOP;
565
566 CLOSE ALLOC;
567
568 IF (g_level_procedure >= g_current_runtime_level ) THEN
569 FND_LOG.STRING(g_level_procedure,
570 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Populate_Allocation.END',
571 'Populate_Allocation (-)');
572 END IF;
573
574 EXCEPTION
575 WHEN NO_DATA_FOUND THEN
576 NULL;
577
578 END Populate_Allocation;
579
580 PROCEDURE Insert_All_Allocation
581 (X_Rowid IN OUT NOCOPY VARCHAR2,
582 p_summary_tax_line_id NUMBER,
583 p_internal_organization_id NUMBER,
584 p_application_id NUMBER,
585 p_entity_code VARCHAR2,
586 p_event_class_code VARCHAR2,
587 p_tax_regime_code VARCHAR2,
588 p_tax VARCHAR2,
589 p_tax_jurisdiction_code VARCHAR2,
590 p_tax_status_code VARCHAR2,
591 p_tax_rate_id NUMBER,
592 p_tax_rate_code VARCHAR2,
593 p_tax_rate NUMBER,
594 p_tax_amt NUMBER,
595 p_enabled_record VARCHAR2,
596 p_summ_tax_only VARCHAR2,
597 p_statement VARCHAR2,
598 p_manually_entered_flag VARCHAR2,
599 p_content_owner_id NUMBER,
600 p_record_type_code VARCHAR2,
601 p_last_manual_entry VARCHAR2,
602 p_tax_amt_included_flag VARCHAR2,
603 p_self_assessed_flag VARCHAR2,
604 p_tax_only_line_flag VARCHAR2,
605 p_created_by NUMBER,
606 p_creation_date DATE,
607 p_last_updated_by NUMBER,
608 p_last_update_date DATE,
609 p_last_update_login NUMBER,
610 p_allocate_flag IN VARCHAR2 DEFAULT 'N'
611 ) IS
612
613 l_tax_line_id NUMBER;
614 l_trx_line_id NUMBER;
615 l_tax_line_number NUMBER;
616 l_tax_id NUMBER;
617 v_trx_number zx_lines.trx_number%TYPE;
618 v_trx_id zx_lines.trx_id%TYPE;
619 v_trx_line_id zx_lines.trx_line_id%TYPE;
620 v_trx_level_type zx_lines.trx_level_type%TYPE;
621 v_trx_line_date zx_lines.trx_line_date%TYPE;
622 v_trx_line_number zx_lines.trx_line_number%TYPE;
623 v_trx_line_description zx_transaction_lines.trx_line_description%TYPE;
624 v_line_amt zx_lines.line_amt%TYPE := 0;
625 l_taxable_amt NUMBER;
626 l_event_id NUMBER;
627 l_regime_id NUMBER;
628 l_status_id NUMBER;
629 l_tax_determine_date DATE;
630 l_trx_date DATE;
631 l_related_doc_date DATE;
632 l_adjusted_doc_date DATE;
633
634 TYPE EmpCurTyp IS REF CURSOR;
635 ALLOC EmpCurTyp;
636 l_key VARCHAR2(100);
637 l_insert BOOLEAN ;
638
639 BEGIN
640
641 g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
642
643 IF (g_level_procedure >= g_current_runtime_level ) THEN
644 FND_LOG.STRING(g_level_procedure,
645 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation.BEGIN',
646 'Insert_All_Allocation (+)');
647 END IF;
648
649 l_insert := TRUE;
650
654 FETCH ALLOC INTO v_trx_id,
651 OPEN ALLOC FOR p_statement;
652 LOOP
653
655 v_trx_line_id,
656 v_trx_level_type,
657 v_trx_number,
658 v_trx_line_number,
659 v_trx_line_description,
660 v_line_amt,
661 v_trx_line_date;
662
663 EXIT WHEN ALLOC%NOTFOUND;
664
665 v_trx_level_type := NVL(v_trx_level_type, 'LINE');
666
667
668 IF p_allocate_flag = 'Y' THEN
669 l_key := to_char(p_summary_tax_line_id)||to_char(v_trx_id)||to_char(v_trx_line_id);
670 IF (g_level_statement >= g_current_runtime_level ) THEN
671 FND_LOG.STRING(g_level_statement,
672 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation',
673 'key : ' || l_key) ;
674 END IF;
675 IF g_trx_allocate_tbl.exists(l_key) THEN
676 IF (g_level_statement >= g_current_runtime_level ) THEN
677 FND_LOG.STRING(g_level_statement,
678 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation',
679 'allocate true : ') ;
680 END IF;
681 l_insert := TRUE;
682 ELSE
683 l_insert := FALSE;
684 END IF;
685 END IF;
686
687 IF l_insert THEN
688
689 SELECT NVL(MAX(TAX_LINE_NUMBER),0) + 1
690 INTO l_tax_line_number
691 FROM ZX_LINES
692 WHERE APPLICATION_ID = p_application_id
693 AND EVENT_CLASS_CODE = p_event_class_code
694 AND ENTITY_CODE = p_entity_code
695 AND TRX_ID = v_trx_id
696 AND TRX_LINE_ID = v_trx_line_id
697 AND TRX_LEVEL_TYPE = v_trx_level_type;
698
699 IF (g_level_procedure >= g_current_runtime_level ) THEN
700 FND_LOG.STRING(g_level_procedure,
701 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation',
702 'line amt : ' || to_char(v_line_amt)) ;
703 END IF;
704 select tax_id
705 INTO l_tax_id
706 FROM ZX_SCO_TAXES
707 WHERE TAX_REGIME_CODE = p_tax_regime_code
708 AND TAX=p_tax;
709
710 IF (g_level_procedure >= g_current_runtime_level ) THEN
711 FND_LOG.STRING(g_level_procedure,
712 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation',
713 'tax id : ' || to_char(l_tax_id)) ;
714 END IF;
715
716 select tax_regime_id
717 INTO l_regime_id
718 FROM zx_regimes_b
719 WHERE TAX_REGIME_CODE = p_tax_regime_code;
720
721 select tax_status_id INTO l_status_id
722 FROM zx_sco_status
723 WHERE tax_regime_code = p_tax_regime_code and tax = p_tax and
724 tax_status_code = p_tax_status_code ;
725
726 IF (g_level_procedure >= g_current_runtime_level ) THEN
727 FND_LOG.STRING(g_level_procedure,
728 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation',
729 'status id : ' || to_char(l_status_id)) ;
730 END IF;
731
732 SELECT zx_lines_s.nextval
733 INTO l_tax_line_id
734 FROM dual;
735
736 IF (g_level_procedure >= g_current_runtime_level ) THEN
737 FND_LOG.STRING(g_level_procedure,
738 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation',
739 'line amt : ' || to_char(v_line_amt)) ;
740 END IF;
741
742 BEGIN
743 SELECT distinct nvl(related_doc_date,nvl(provnl_tax_determination_date
744 ,nvl(adjusted_doc_date,trx_date))) , trx_date, related_doc_date ,adjusted_doc_date into l_tax_determine_date, l_trx_date ,l_related_doc_date, l_adjusted_doc_date
745 FROM zx_lines_det_factors where trx_id = v_trx_id;
746 EXCEPTION
747 WHEN others THEN NULL;
748 END ;
749
750 ZX_TRL_DETAIL_OVERRIDE_PKG.Insert_row
751 (x_rowid => X_Rowid,
752 p_tax_line_id => l_tax_line_id,
753 p_internal_organization_id => p_internal_organization_id,
754 p_application_id => p_application_id,
755 p_entity_code => p_entity_code,
756 p_event_class_code => p_event_class_code,
757 p_event_type_code => NULL,
758 p_trx_id => v_trx_id,
759 p_trx_line_id => v_trx_line_id,
760 p_trx_level_type => v_trx_level_type,
761 p_trx_line_number => v_trx_line_number,
762 p_doc_event_status => NULL,
763 p_tax_event_class_code => NULL,
764 p_tax_event_type_code => NULL,
765 p_tax_line_number => l_tax_line_number,
766 p_content_owner_id => p_content_owner_id,
767 p_tax_regime_id => l_regime_id,
768 p_tax_regime_code => p_tax_regime_code,
769 p_tax_id => l_tax_id,
770 p_tax => p_tax,
771 p_tax_status_id => l_status_id,
772 p_tax_status_code => p_tax_status_code,
776 p_tax_rate_type => NULL,
773 p_tax_rate_id => p_tax_rate_id,
774 p_tax_rate_code => p_tax_rate_code,
775 p_tax_rate => p_tax_rate,
777 p_tax_apportionment_line_num => NULL,
778 p_trx_id_level2 => NULL,
779 p_trx_id_level3 => NULL,
780 p_trx_id_level4 => NULL,
781 p_trx_id_level5 => NULL,
782 p_trx_id_level6 => NULL,
783 p_trx_user_key_level1 => NULL,
784 p_trx_user_key_level2 => NULL,
785 p_trx_user_key_level3 => NULL,
786 p_trx_user_key_level4 => NULL,
787 p_trx_user_key_level5 => NULL,
788 p_trx_user_key_level6 => NULL,
789 p_mrc_tax_line_flag => 'N',
790 p_mrc_link_to_tax_line_id => NULL,
791 p_ledger_id => NULL,
792 p_establishment_id => NULL,
793 p_legal_entity_id => NULL,
794 -- p_legal_entity_tax_reg_number => NULL,
795 p_hq_estb_reg_number => NULL,
796 p_hq_estb_party_tax_prof_id => NULL,
797 p_currency_conversion_date => NULL,
798 p_currency_conversion_type => NULL,
799 p_currency_conversion_rate => NULL,
800 p_tax_curr_conversion_date => NULL,
801 p_tax_curr_conversion_type => NULL,
802 p_tax_curr_conversion_rate => NULL,
803 p_trx_currency_code => NULL,
804 p_reporting_currency_code => NULL,
805 p_minimum_accountable_unit => NULL,
806 p_precision => NULL,
807 p_trx_number => v_trx_number,
808 p_trx_date => l_trx_date,
809 p_unit_price => NULL,
810 p_line_amt => v_line_amt,
811 p_trx_line_quantity => NULL,
812 p_tax_base_modifier_rate => NULL,
813 p_ref_doc_application_id => NULL,
814 p_ref_doc_entity_code => NULL,
815 p_ref_doc_event_class_code => NULL,
816 p_ref_doc_trx_id => NULL,
817 p_ref_doc_trx_level_type => NULL,
818 p_ref_doc_line_id => NULL,
819 p_ref_doc_line_quantity => NULL,
820 p_other_doc_line_amt => NULL,
821 p_other_doc_line_tax_amt => NULL,
822 p_other_doc_line_taxable_amt => NULL,
823 p_unrounded_taxable_amt => v_line_amt,
824 p_unrounded_tax_amt => v_line_amt,
825 p_related_doc_application_id => NULL,
826 p_related_doc_entity_code => NULL,
827 p_related_doc_evt_class_code => NULL,
828 p_related_doc_trx_id => NULL,
829 p_related_doc_trx_level_type => NULL,
830 p_related_doc_number => NULL,
831 p_related_doc_date => l_related_doc_date,
832 p_applied_from_appl_id => NULL,
833 p_applied_from_evt_clss_code => NULL,
834 p_applied_from_entity_code => NULL,
835 p_applied_from_trx_id => NULL,
836 p_applied_from_trx_level_type => NULL,
837 p_applied_from_line_id => NULL,
838 p_applied_from_trx_number => NULL,
839 p_adjusted_doc_appln_id => NULL,
840 p_adjusted_doc_entity_code => NULL,
841 p_adjusted_doc_evt_clss_code => NULL,
842 p_adjusted_doc_trx_id => NULL,
843 p_adjusted_doc_trx_level_type => NULL,
844 p_adjusted_doc_line_id => NULL,
845 p_adjusted_doc_number => NULL,
846 p_adjusted_doc_date => l_adjusted_doc_date,
847 p_applied_to_application_id => NULL,
848 p_applied_to_evt_class_code => NULL,
849 p_applied_to_entity_code => NULL,
850 p_applied_to_trx_id => NULL,
851 p_applied_to_trx_level_type => NULL,
852 p_applied_to_line_id => NULL,
853 p_summary_tax_line_id => p_summary_tax_line_id,
854 p_offset_link_to_tax_line_id => NULL,
855 p_offset_flag => 'N',
856 p_process_for_recovery_flag => 'N',
857 p_tax_jurisdiction_id => NULL,
858 p_tax_jurisdiction_code => p_tax_jurisdiction_code,
859 p_place_of_supply => NULL,
860 p_place_of_supply_type_code => NULL,
861 p_place_of_supply_result_id => NULL,
862 p_tax_date_rule_id => NULL,
863 p_tax_date => l_tax_determine_date,
864 p_tax_determine_date => l_tax_determine_date,
865 p_tax_point_date => l_tax_determine_date,
866 p_trx_line_date => v_trx_line_date,
867 p_tax_type_code => NULL,
868 p_tax_code => NULL,
869 p_tax_registration_id => NULL,
870 p_tax_registration_number => NULL,
871 p_registration_party_type => NULL,
875 p_rounding_lvl_party_type => NULL,
872 p_rounding_level_code => 'HEADER',
873 p_rounding_rule_code => NULL,
874 p_rndg_lvl_party_tax_prof_id => NULL,
876 p_compounding_tax_flag => 'N',
877 p_orig_tax_status_id => NULL,
878 p_orig_tax_status_code => NULL,
879 p_orig_tax_rate_id => NULL,
880 p_orig_tax_rate_code => NULL,
881 p_orig_tax_rate => NULL,
882 p_orig_tax_jurisdiction_id => NULL,
883 p_orig_tax_jurisdiction_code => NULL,
884 p_orig_tax_amt_included_flag => 'N',
885 p_orig_self_assessed_flag => 'N',
886 p_tax_currency_code => NULL,
887 p_tax_amt => p_tax_amt,
888 p_tax_amt_tax_curr => NULL,
889 p_tax_amt_funcl_curr => NULL,
890 p_taxable_amt => NULL,
891 p_taxable_amt_tax_curr => NULL,
892 p_taxable_amt_funcl_curr => NULL,
893 p_orig_taxable_amt => NULL,
894 p_orig_taxable_amt_tax_curr => NULL,
895 p_cal_tax_amt => NULL,
896 p_cal_tax_amt_tax_curr => NULL,
897 p_cal_tax_amt_funcl_curr => NULL,
898 p_orig_tax_amt => NULL,
899 p_orig_tax_amt_tax_curr => NULL,
900 p_rec_tax_amt => NULL,
901 p_rec_tax_amt_tax_curr => NULL,
902 p_rec_tax_amt_funcl_curr => NULL,
903 p_nrec_tax_amt => NULL,
904 p_nrec_tax_amt_tax_curr => NULL,
905 p_nrec_tax_amt_funcl_curr => NULL,
906 p_tax_exemption_id => NULL,
907 p_tax_rate_before_exemption => NULL,
908 p_tax_rate_name_before_exempt => NULL,
909 p_exempt_rate_modifier => NULL,
910 p_exempt_certificate_number => NULL,
911 p_exempt_reason => NULL,
912 p_exempt_reason_code => NULL,
913 p_tax_exception_id => NULL,
914 p_tax_rate_before_exception => NULL,
915 p_tax_rate_name_before_except => NULL,
916 p_exception_rate => NULL,
917 p_tax_apportionment_flag => 'N',
918 p_historical_flag => 'N',
919 p_taxable_basis_formula => NULL,
920 p_tax_calculation_formula => NULL,
921 p_cancel_flag => 'N',
922 p_purge_flag => 'N',
923 p_delete_flag => 'N',
924 p_tax_amt_included_flag => p_tax_amt_included_flag,
925 p_self_assessed_flag => p_self_assessed_flag,
926 p_overridden_flag => 'N',
927 p_manually_entered_flag => p_manually_entered_flag,
928 p_reporting_only_flag => 'N',
929 p_freeze_until_overriddn_flg => 'N',
930 p_copied_from_other_doc_flag => 'N',
931 p_recalc_required_flag => 'Y',
932 p_settlement_flag => 'N',
933 p_item_dist_changed_flag => 'N',
934 p_assoc_children_frozen_flg => 'N',
935 p_tax_only_line_flag => p_tax_only_line_flag,
936 p_compounding_dep_tax_flag => 'N',
937 p_compounding_tax_miss_flag => 'N',
938 p_sync_with_prvdr_flag => 'N',
939 p_last_manual_entry => p_last_manual_entry,
940 p_tax_provider_id => NULL,
941 p_record_type_code => p_record_type_code,
942 p_reporting_period_id => NULL,
943 p_legal_justification_text1 => NULL,
944 p_legal_justification_text2 => NULL,
945 p_legal_justification_text3 => NULL,
946 p_legal_message_appl_2 => NULL,
947 p_legal_message_status => NULL,
948 p_legal_message_rate => NULL,
949 p_legal_message_basis => NULL,
950 p_legal_message_calc => NULL,
951 p_legal_message_threshold => NULL,
952 p_legal_message_pos => NULL,
953 p_legal_message_trn => NULL,
954 p_legal_message_exmpt => NULL,
955 p_legal_message_excpt => NULL,
956 p_tax_regime_template_id => NULL,
957 p_tax_applicability_result_id => NULL,
958 p_direct_rate_result_id => NULL,
959 p_status_result_id => NULL,
960 p_rate_result_id => NULL,
961 p_basis_result_id => NULL,
962 p_thresh_result_id => NULL,
963 p_calc_result_id => NULL,
964 p_tax_reg_num_det_result_id => NULL,
965 p_eval_exmpt_result_id => NULL,
966 p_eval_excpt_result_id => NULL,
967 p_enforced_from_nat_acct_flg => 'N',
968 p_tax_hold_code => NULL,
969 p_tax_hold_released_code => NULL,
970 p_prd_total_tax_amt => NULL,
971 p_prd_total_tax_amt_tax_curr => NULL,
975 p_proration_code => NULL,
972 p_prd_total_tax_amt_funcl_curr => NULL,
973 p_trx_line_index => NULL,
974 p_offset_tax_rate_code => NULL,
976 p_other_doc_source => NULL,
977 p_internal_org_location_id => NULL,
978 p_line_assessable_value => NULL,
979 p_ctrl_total_line_tx_amt => NULL,
980 p_applied_to_trx_number => NULL,
981 p_attribute_category => NULL,
982 p_attribute1 => NULL,
983 p_attribute2 => NULL,
984 p_attribute3 => NULL,
985 p_attribute4 => NULL,
986 p_attribute5 => NULL,
987 p_attribute6 => NULL,
988 p_attribute7 => NULL,
989 p_attribute8 => NULL,
990 p_attribute9 => NULL,
991 p_attribute10 => NULL,
992 p_attribute11 => NULL,
993 p_attribute12 => NULL,
994 p_attribute13 => NULL,
995 p_attribute14 => NULL,
996 p_attribute15 => NULL,
997 p_global_attribute_category => NULL,
998 p_global_attribute1 => NULL,
999 p_global_attribute2 => NULL,
1000 p_global_attribute3 => NULL,
1001 p_global_attribute4 => NULL,
1002 p_global_attribute5 => NULL,
1003 p_global_attribute6 => NULL,
1004 p_global_attribute7 => NULL,
1005 p_global_attribute8 => NULL,
1006 p_global_attribute9 => NULL,
1007 p_global_attribute10 => NULL,
1008 p_global_attribute11 => NULL,
1009 p_global_attribute12 => NULL,
1010 p_global_attribute13 => NULL,
1011 p_global_attribute14 => NULL,
1012 p_global_attribute15 => NULL,
1013 p_numeric1 => NULL,
1014 p_numeric2 => NULL,
1015 p_numeric3 => NULL,
1016 p_numeric4 => NULL,
1017 p_numeric5 => NULL,
1018 p_numeric6 => NULL,
1019 p_numeric7 => NULL,
1020 p_numeric8 => NULL,
1021 p_numeric9 => NULL,
1022 p_numeric10 => NULL,
1023 p_char1 => NULL,
1024 p_char2 => NULL,
1025 p_char3 => NULL,
1026 p_char4 => NULL,
1027 p_char5 => NULL,
1028 p_char6 => NULL,
1029 p_char7 => NULL,
1030 p_char8 => NULL,
1031 p_char9 => NULL,
1032 p_char10 => NULL,
1033 p_date1 => NULL,
1034 p_date2 => NULL,
1035 p_date3 => NULL,
1036 p_date4 => NULL,
1037 p_date5 => NULL,
1038 p_date6 => NULL,
1039 p_date7 => NULL,
1040 p_date8 => NULL,
1041 p_date9 => NULL,
1042 p_date10 => NULL,
1043 p_interface_entity_code => NULL,
1044 p_interface_tax_line_id => NULL,
1045 p_taxing_juris_geography_id => NULL,
1046 p_adjusted_doc_tax_line_id => NULL,
1047 p_object_version_number => 1,
1048 p_created_by => fnd_global.user_id,
1049 p_creation_date => sysdate,
1050 p_last_updated_by => fnd_global.user_id,
1051 p_last_update_date => sysdate,
1052 p_last_update_login => fnd_global.login_id );
1053
1054
1055 END IF;
1056
1057 END LOOP;
1058
1059 CLOSE ALLOC;
1060
1061 ZX_TRL_ALLOCATIONS_PKG.Update_Tax_Amt
1062 (p_summary_tax_line_id => p_summary_tax_line_id,
1063 p_application_id => p_application_id,
1064 p_entity_code => p_entity_code,
1065 p_event_class_code => p_event_class_code,
1066 p_trx_id => v_trx_id);
1067
1068
1069
1070 IF (g_level_procedure >= g_current_runtime_level ) THEN
1071 FND_LOG.STRING(g_level_procedure,
1072 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG. Insert_All_Allocation.END',
1073 'Insert_All_Allocation (-)');
1074 END IF;
1075
1076 EXCEPTION
1077 WHEN NO_DATA_FOUND THEN
1078 NULL;
1079
1080 END Insert_All_Allocation;
1081
1082 PROCEDURE Insert_Tax_Line
1083 (p_summary_tax_line_id NUMBER,
1087 p_event_class_code VARCHAR2,
1084 p_internal_organization_id NUMBER,
1085 p_application_id NUMBER,
1086 p_entity_code VARCHAR2,
1088 p_trx_id NUMBER,
1089 p_trx_number VARCHAR2,
1090 p_tax_regime_code VARCHAR2,
1091 p_tax VARCHAR2,
1092 p_tax_jurisdiction_code VARCHAR2,
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_line_amt NUMBER,
1099 p_trx_line_date DATE,
1100 p_summ_tax_only VARCHAR2,
1101 p_manually_entered_flag VARCHAR2,
1102 p_last_manual_entry VARCHAR2,
1103 p_tax_amt_included_flag VARCHAR2,
1104 p_self_assessed_flag VARCHAR2,
1105 p_created_by NUMBER,
1106 p_creation_date DATE,
1107 p_last_updated_by NUMBER,
1108 p_last_update_date DATE,
1109 p_last_update_login NUMBER,
1110 p_event_type_code VARCHAR,
1111 p_legal_entity_id NUMBER,
1112 p_ledger_id NUMBER,
1113 p_trx_currency_code VARCHAR,
1114 p_currency_conversion_date DATE,
1115 p_currency_conversion_rate NUMBER,
1116 p_currency_conversion_type VARCHAR2,
1117 p_content_owner_id NUMBER,
1118 p_trx_date DATE,
1119 p_minimum_accountable_unit NUMBER,
1120 p_precision NUMBER,
1121 p_trx_line_gl_date DATE ) IS
1122
1123 l_tax_line_id NUMBER;
1124 l_trx_line_id NUMBER;
1125 l_trx_line_number NUMBER;
1126 l_tax_line_number NUMBER;
1127 l_tax_jurisdiction_id NUMBER;
1128 l_tax_currency_code VARCHAR2(100);
1129 l_tax_id NUMBER;
1130 l_regime_id NUMBER;
1131 l_status_id NUMBER;
1132
1133 v_trx_line_id zx_lines.trx_line_id%TYPE;
1134 v_trx_line_number zx_lines.trx_line_number%TYPE;
1135
1136 l_tax_event_class_code zx_evnt_cls_mappings.tax_event_class_code%type;
1137 l_trx_number zx_lines_det_factors.trx_number%type;
1138 l_legal_reporting_status zx_taxes_b.legal_reporting_status_def_val%type;
1139 l_tax_reporting_flag zx_lines_det_factors.tax_reporting_flag%type;
1140
1141 l_hq_estb_pty_tax_prof_id ZX_LINES_DET_FACTORS.HQ_ESTB_PARTY_TAX_PROF_ID%TYPE;
1142 l_internal_org_loc_id ZX_LINES_DET_FACTORS.INTERNAL_ORG_LOCATION_ID%TYPE;
1143 l_event_class_mapping_id ZX_EVNT_CLS_MAPPINGS.EVENT_CLASS_MAPPING_ID%TYPE;
1144 l_tax_type_code ZX_TAXES_B.TAX_TYPE_CODE%TYPE;
1145 l_rate_type_code ZX_RATES_B.RATE_TYPE_CODE%TYPE;
1146 l_default_taxation_country ZX_LINES_DET_FACTORS.DEFAULT_TAXATION_COUNTRY%TYPE;
1147 l_rndg_ship_fr_pty_tx_prof_id ZX_LINES_DET_FACTORS.RDNG_SHIP_FROM_PTY_TX_PROF_ID%TYPE;
1148 l_rndg_bill_fr_pty_tx_prof_id ZX_LINES_DET_FACTORS.RDNG_BILL_FROM_PTY_TX_PROF_ID%TYPE;
1149 l_rndg_ship_fr_pty_tx_p_st_id ZX_LINES_DET_FACTORS.RDNG_SHIP_FROM_PTY_TX_P_ST_ID%TYPE;
1150 l_rndg_bill_fr_pty_tx_p_st_id ZX_LINES_DET_FACTORS.RDNG_BILL_FROM_PTY_TX_P_ST_ID%TYPE;
1151 l_ship_to_location_id ZX_LINES_DET_FACTORS.SHIP_TO_LOCATION_ID%TYPE;
1152 l_ship_from_location_id ZX_LINES_DET_FACTORS.SHIP_FROM_LOCATION_ID%TYPE;
1153 l_bill_to_location_id ZX_LINES_DET_FACTORS.BILL_TO_LOCATION_ID%TYPE;
1154 l_bill_from_location_id ZX_LINES_DET_FACTORS.BILL_FROM_LOCATION_ID%TYPE;
1155 l_ship_from_pty_tax_prof_id ZX_LINES_DET_FACTORS.SHIP_FROM_PARTY_TAX_PROF_ID%TYPE;
1156 l_bill_from_pty_tax_prof_id ZX_LINES_DET_FACTORS.BILL_FROM_PARTY_TAX_PROF_ID%TYPE;
1157 l_ship_from_site_tx_prof_id ZX_LINES_DET_FACTORS.SHIP_FROM_SITE_TAX_PROF_ID%TYPE;
1158 l_bill_from_site_tx_prof_id ZX_LINES_DET_FACTORS.BILL_FROM_SITE_TAX_PROF_ID%TYPE;
1159 l_ctrl_hdr_tx_appl_flag ZX_LINES_DET_FACTORS.CTRL_HDR_TX_APPL_FLAG%TYPE;
1160 l_ship_third_pty_acct_site_id ZX_LINES_DET_FACTORS.SHIP_THIRD_PTY_ACCT_SITE_ID%TYPE;
1161 l_bill_third_pty_acct_site_id ZX_LINES_DET_FACTORS.BILL_THIRD_PTY_ACCT_SITE_ID%TYPE;
1162 l_ship_third_pty_acct_id ZX_LINES_DET_FACTORS.SHIP_THIRD_PTY_ACCT_ID%TYPE;
1163 l_bill_third_pty_acct_id ZX_LINES_DET_FACTORS.BILL_THIRD_PTY_ACCT_ID%TYPE;
1164 l_trx_currency_code ZX_LINES_DET_FACTORS.TRX_CURRENCY_CODE%TYPE;
1165 l_currency_conversion_date ZX_LINES_DET_FACTORS.CURRENCY_CONVERSION_DATE%TYPE;
1166 l_currency_conversion_rate ZX_LINES_DET_FACTORS.CURRENCY_CONVERSION_RATE%TYPE;
1167 l_currency_conversion_type ZX_LINES_DET_FACTORS.CURRENCY_CONVERSION_TYPE%TYPE;
1168
1169
1170 BEGIN
1171
1172 g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1173
1174 IF (g_level_procedure >= g_current_runtime_level ) THEN
1175 FND_LOG.STRING(g_level_procedure,
1176 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_Tax_Line.BEGIN',
1177 'Insert_Tax_Line (+)');
1178 END IF;
1179
1180 l_tax_line_number :=1;
1181
1182 IF p_summ_tax_only = 'Y' THEN
1183
1184 SELECT nvl(min(trx_line_id),0),
1185 nvl(min(trx_line_number),0)
1186 INTO v_trx_line_number,
1187 v_trx_line_id
1188 FROM ZX_LINES
1189 WHERE TRX_ID = p_trx_id
1190 AND APPLICATION_ID = p_application_id
1191 AND EVENT_CLASS_CODE = p_event_class_code
1192 AND ENTITY_CODE = p_entity_code;
1193
1194 IF v_trx_line_number >= 0 THEN
1195 l_trx_line_id := -1;
1196 l_trx_line_number := -1;
1197
1198 ELSIF v_trx_line_number < 0 THEN
1199 l_trx_line_id := v_trx_line_id - 1;
1200 l_trx_line_number := v_trx_line_number - 1;
1201
1202 END IF;
1203
1204 IF (g_level_statement >= g_current_runtime_level ) THEN
1205 FND_LOG.STRING(g_level_statement,
1206 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation',
1207 'event type code ' || p_event_type_code) ;
1208 FND_LOG.STRING(g_level_statement,
1209 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation',
1210 'legal entity id' || to_char(p_legal_entity_id)) ;
1211 FND_LOG.STRING(g_level_statement,
1212 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation',
1213 'ledger id' || to_char(p_ledger_id)) ;
1214 FND_LOG.STRING(g_level_statement,
1215 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation',
1216 'trx_currency_code ' || p_trx_currency_code) ;
1217 FND_LOG.STRING(g_level_statement,
1218 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation',
1219 'content owner id ' || p_content_owner_id) ;
1220 END IF;
1221
1222 BEGIN
1223 SELECT TAX_EVENT_CLASS_CODE, TAX_REPORTING_FLAG, EVENT_CLASS_MAPPING_ID
1224 INTO l_tax_event_class_code, l_tax_reporting_flag, l_event_class_mapping_id
1225 FROM ZX_EVNT_CLS_MAPPINGS
1226 WHERE application_id = p_application_id
1227 AND entity_code = p_entity_code
1228 AND event_class_Code = p_event_class_code;
1229 EXCEPTION
1230 WHEN OTHERS THEN
1231 l_tax_event_class_code := NULL;
1232 l_tax_reporting_flag := NULL;
1233 l_event_class_mapping_id := NULL;
1234 END;
1235
1236 BEGIN
1237
1238 select tax_id, tax_currency_code, tax_type_code,
1239 DECODE(NVL(l_tax_reporting_flag,'N'),'Y',
1240 legal_reporting_status_def_val,NULL)
1241 INTO l_tax_id, l_tax_currency_code, l_tax_type_code, l_legal_reporting_status
1242 FROM ZX_SCO_TAXES
1243 WHERE TAX_REGIME_CODE = p_tax_regime_code
1244 AND TAX=p_tax;
1245
1246 EXCEPTION
1247 WHEN OTHERS THEN
1248 IF (g_level_unexpected >= g_current_runtime_level ) THEN
1249 FND_LOG.STRING(g_level_unexpected,
1250 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.insert_tax_line',
1251 sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1252 FND_LOG.STRING(g_level_unexpected,
1253 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.insert_tax_line.END',
1254 'ZX_TRL_ALLOCATIONS_PKG.insert_tax_line(-)');
1255 END IF;
1256
1257 RETURN;
1258
1259 END;
1260 IF (g_level_procedure >= g_current_runtime_level ) THEN
1261 FND_LOG.STRING(g_level_procedure,
1262 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation',
1263 'tax id : ' || to_char(l_tax_id)) ;
1264 END IF;
1265
1266 BEGIN
1267
1268 select tax_regime_id
1269 INTO l_regime_id
1270 FROM zx_regimes_b
1271 WHERE TAX_REGIME_CODE = p_tax_regime_code;
1272
1273 EXCEPTION
1274 WHEN OTHERS THEN
1275 IF (g_level_unexpected >= g_current_runtime_level ) THEN
1276 FND_LOG.STRING(g_level_unexpected,
1277 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.insert_tax_line',
1278 sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1279 FND_LOG.STRING(g_level_unexpected,
1280 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.insert_tax_line.END',
1281 'ZX_TRL_ALLOCATIONS_PKG.insert_tax_line(-)');
1282 END IF;
1283
1284 RETURN;
1285
1286 END;
1287
1288 BEGIN
1289
1290 select tax_status_id
1291 INTO l_status_id
1292 FROM zx_sco_status
1293 WHERE tax_regime_code = p_tax_regime_code
1294 AND tax = p_tax
1295 AND tax_status_code = p_tax_status_code ;
1296
1297 EXCEPTION
1298 WHEN OTHERS THEN
1299 IF (g_level_unexpected >= g_current_runtime_level ) THEN
1300 FND_LOG.STRING(g_level_unexpected,
1301 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.insert_tax_line',
1302 sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1303 FND_LOG.STRING(g_level_unexpected,
1307
1304 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.insert_tax_line.END',
1305 'ZX_TRL_ALLOCATIONS_PKG.insert_tax_line(-)');
1306 END IF;
1308 RETURN;
1309
1310 END;
1311 BEGIN
1312 SELECT tax_jurisdiction_id
1313 INTO l_tax_jurisdiction_id
1314 FROM zx_jurisdictions_b
1315 WHERE tax_regime_code = p_tax_regime_code
1316 AND tax = p_tax
1317 AND tax_jurisdiction_code = p_tax_jurisdiction_code;
1318 EXCEPTION
1319 WHEN OTHERS THEN
1320 l_tax_jurisdiction_id := NULL;
1321 END;
1322
1323 BEGIN
1324
1325 SELECT rate_type_code
1326 INTO l_rate_type_code
1327 FROM ZX_SCO_RATES
1328 WHERE tax_rate_id = p_tax_rate_id;
1329
1330 EXCEPTION
1331 WHEN OTHERS THEN
1332 IF (g_level_unexpected >= g_current_runtime_level ) THEN
1333 FND_LOG.STRING(g_level_unexpected,
1334 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.insert_tax_line',
1335 sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1336 FND_LOG.STRING(g_level_unexpected,
1337 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.insert_tax_line.END',
1338 'ZX_TRL_ALLOCATIONS_PKG.insert_tax_line(-)');
1339 END IF;
1340
1341 RETURN;
1342
1343 END;
1344
1345 SELECT zx_lines_s.nextval
1346 INTO l_tax_line_id
1347 FROM dual;
1348
1349 IF (g_level_procedure >= g_current_runtime_level ) THEN
1350 FND_LOG.STRING(g_level_procedure,
1351 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation',
1352 'status id : ' || to_char(l_status_id)) ;
1353 END IF;
1354
1355
1356 IF (g_level_procedure >= g_current_runtime_level ) THEN
1357 FND_LOG.STRING(g_level_procedure,
1358 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation.',
1359 'Trx Line Id: '||to_char(l_trx_line_id));
1360 END IF;
1361
1362 BEGIN
1363 SELECT TRX_NUMBER, NVL(P_TRX_CURRENCY_CODE, TRX_CURRENCY_CODE),
1364 NVL(P_CURRENCY_CONVERSION_DATE, CURRENCY_CONVERSION_DATE),
1365 NVL(P_CURRENCY_CONVERSION_RATE, CURRENCY_CONVERSION_RATE),
1366 NVL(P_CURRENCY_CONVERSION_TYPE, CURRENCY_CONVERSION_TYPE),
1367 HQ_ESTB_PARTY_TAX_PROF_ID, INTERNAL_ORG_LOCATION_ID,
1368 DEFAULT_TAXATION_COUNTRY, RDNG_SHIP_FROM_PTY_TX_PROF_ID,
1369 RDNG_BILL_FROM_PTY_TX_PROF_ID, RDNG_SHIP_FROM_PTY_TX_P_ST_ID,
1370 RDNG_BILL_FROM_PTY_TX_P_ST_ID, SHIP_TO_LOCATION_ID,
1371 SHIP_FROM_LOCATION_ID, BILL_TO_LOCATION_ID,
1372 BILL_FROM_LOCATION_ID, SHIP_FROM_PARTY_TAX_PROF_ID,
1373 BILL_FROM_PARTY_TAX_PROF_ID, SHIP_FROM_SITE_TAX_PROF_ID,
1374 BILL_FROM_SITE_TAX_PROF_ID, CTRL_HDR_TX_APPL_FLAG,
1375 SHIP_THIRD_PTY_ACCT_SITE_ID, BILL_THIRD_PTY_ACCT_SITE_ID,
1376 SHIP_THIRD_PTY_ACCT_ID, BILL_THIRD_PTY_ACCT_ID
1377 INTO l_trx_number,l_trx_currency_code,l_currency_conversion_date,
1378 l_currency_conversion_rate,l_currency_conversion_type,
1379 l_hq_estb_pty_tax_prof_id, l_internal_org_loc_id,
1380 l_default_taxation_country, l_rndg_ship_fr_pty_tx_prof_id,
1381 l_rndg_bill_fr_pty_tx_prof_id, l_rndg_ship_fr_pty_tx_p_st_id,
1382 l_rndg_bill_fr_pty_tx_p_st_id, l_ship_to_location_id,
1383 l_ship_from_location_id, l_bill_to_location_id,
1384 l_bill_from_location_id, l_ship_from_pty_tax_prof_id,
1385 l_bill_from_pty_tax_prof_id, l_ship_from_site_tx_prof_id,
1386 l_bill_from_site_tx_prof_id, l_ctrl_hdr_tx_appl_flag,
1387 l_ship_third_pty_acct_site_id, l_bill_third_pty_acct_site_id,
1388 l_ship_third_pty_acct_id, l_bill_third_pty_acct_id
1389 FROM ZX_LINES_DET_FACTORS
1390 WHERE APPLICATION_ID = P_APPLICATION_ID
1391 AND ENTITY_CODE = P_ENTITY_CODE
1392 AND EVENT_CLASS_CODE = P_EVENT_CLASS_CODE
1393 AND TRX_ID = P_TRX_ID
1394 AND ROWNUM = 1;
1395 EXCEPTION
1396 WHEN OTHERS THEN
1397 l_trx_number := NULL;
1398 END;
1399
1400
1401 INSERT INTO ZX_LINES (SUMMARY_TAX_LINE_ID,
1402 INTERNAL_ORGANIZATION_ID,
1403 APPLICATION_ID,
1404 ENTITY_CODE,
1405 EVENT_CLASS_CODE,
1406 --EVENT_TYPE_CODE,
1407 TRX_LINE_NUMBER,
1408 TRX_ID,
1409 TRX_NUMBER,
1410 TRX_LINE_ID,
1411 TRX_LEVEL_TYPE,
1412 TAX_LINE_ID,
1413 CONTENT_OWNER_ID,
1414 TAX_LINE_NUMBER,
1415 LINE_AMT,
1416 TRX_LINE_DATE,
1417 TRX_DATE,
1418 MINIMUM_ACCOUNTABLE_UNIT,
1419 PRECISION,
1420 TAX_REGIME_CODE,
1421 TAX_REGIME_ID,
1422 TAX,
1423 TAX_ID,
1424 TAX_JURISDICTION_CODE,
1425 TAX_STATUS_CODE,
1426 TAX_STATUS_ID,
1427 TAX_DETERMINE_DATE,
1428 TAX_RATE_ID,
1429 TAX_RATE_CODE,
1430 TAX_RATE,
1434 OFFSET_FLAG,
1431 TAX_JURISDICTION_ID,
1432 TAX_AMT,
1433 TAX_CURRENCY_CODE,
1435 PROCESS_FOR_RECOVERY_FLAG,
1436 COMPOUNDING_TAX_FLAG,
1437 ORIG_TAX_AMT_INCLUDED_FLAG,
1438 ORIG_SELF_ASSESSED_FLAG,
1439 TAX_APPORTIONMENT_FLAG,
1440 HISTORICAL_FLAG,
1441 CANCEL_FLAG,
1442 PURGE_FLAG,
1443 DELETE_FLAG,
1444 TAX_AMT_INCLUDED_FLAG,
1445 SELF_ASSESSED_FLAG,
1446 OVERRIDDEN_FLAG,
1447 MANUALLY_ENTERED_FLAG,
1448 REPORTING_ONLY_FLAG,
1449 FREEZE_UNTIL_OVERRIDDEN_FLAG,
1450 COPIED_FROM_OTHER_DOC_FLAG,
1451 RECALC_REQUIRED_FLAG,
1452 SETTLEMENT_FLAG,
1453 ITEM_DIST_CHANGED_FLAG,
1454 ASSOCIATED_CHILD_FROZEN_FLAG,
1455 TAX_ONLY_LINE_FLAG,
1456 COMPOUNDING_DEP_TAX_FLAG,
1457 ENFORCE_FROM_NATURAL_ACCT_FLAG,
1458 MRC_TAX_LINE_FLAG,
1459 LAST_MANUAL_ENTRY,
1460 UNROUNDED_TAX_AMT,
1461 UNROUNDED_TAXABLE_AMT,
1462 RECORD_TYPE_CODE,
1463 TAX_APPORTIONMENT_LINE_NUMBER,
1464 ROUNDING_LEVEL_CODE,
1465 OBJECT_VERSION_NUMBER,
1466 --bug 7300367
1467 TAX_EVENT_CLASS_CODE,
1468 TAXABLE_BASIS_FORMULA,
1469 TAX_CALCULATION_FORMULA,
1470 COMPOUNDING_TAX_MISS_FLAG,
1471 TRX_CURRENCY_CODE,
1472 CURRENCY_CONVERSION_DATE,
1473 CURRENCY_CONVERSION_RATE,
1474 CURRENCY_CONVERSION_TYPE,
1475 LEGAL_REPORTING_STATUS,
1476 --bug 7300367
1477 --bug 7369708
1478 HQ_ESTB_PARTY_TAX_PROF_ID,
1479 TAX_CURRENCY_CONVERSION_DATE,
1480 UNIT_PRICE,
1481 TRX_LINE_QUANTITY,
1482 TAX_BASE_MODIFIER_RATE,
1483 PLACE_OF_SUPPLY_TYPE_CODE,
1484 TAX_DATE,
1485 TAX_POINT_DATE,
1486 TAX_TYPE_CODE,
1487 --ROUNDING_LVL_PARTY_TAX_PROF_ID,
1488 --ROUNDING_LVL_PARTY_TYPE,
1489 INTERNAL_ORG_LOCATION_ID,
1490 LINE_ASSESSABLE_VALUE,
1491 TAX_RATE_TYPE,
1492 --bug 7369708
1493 CREATED_BY,
1494 CREATION_DATE,
1495 LAST_UPDATED_BY,
1496 LAST_UPDATE_DATE,
1497 LAST_UPDATE_LOGIN)
1498 VALUES (p_summary_tax_line_id,
1499 p_internal_organization_id,
1500 p_application_id,
1501 p_entity_code,
1502 p_event_class_code,
1503 --p_event_type_code,
1504 l_trx_line_number,
1505 p_trx_id,
1506 p_trx_number,
1507 l_trx_line_id,
1508 'LINE',--p_trx_level_type,
1509 l_tax_line_id,
1510 p_content_owner_id,
1511 l_tax_line_number,
1512 p_line_amt,
1513 p_trx_line_date,
1514 p_trx_date,
1515 p_minimum_accountable_unit,
1516 p_precision,
1517 p_tax_regime_code,
1518 l_regime_id,
1519 p_tax,
1520 l_tax_id,
1521 p_tax_jurisdiction_code,
1522 p_tax_status_code,
1523 l_status_id,
1524 p_trx_date,
1525 p_tax_rate_id,
1526 p_tax_rate_code,
1527 p_tax_rate,
1528 l_tax_jurisdiction_id,
1529 NULL, --p_tax_amt,
1530 l_tax_currency_code,
1531 'N',
1532 'Y',
1533 'N',
1534 'N',
1535 'N',
1536 'N',
1537 'N',
1538 'N',
1539 'N',
1540 'N',
1541 p_tax_amt_included_flag,
1542 p_self_assessed_flag,
1543 'N',
1544 'Y',
1545 'N',
1546 'N',
1547 'N',
1548 'Y',
1549 'N',
1550 'N',
1554 'N',
1551 'N',
1552 'Y',
1553 'N',
1555 'N',
1556 'TAX_AMOUNT',
1557 p_tax_amt,
1558 (p_tax_amt/p_tax_rate) * 100,
1559 'ETAX_CREATED',
1560 1,
1561 'HEADER',
1562 1, -- object_version_number,
1563 --bug 7300367
1564 l_tax_event_class_code,
1565 'STANDARD_TB',
1566 'STANDARD_TC',
1567 'N',
1568 l_trx_currency_code,
1569 l_CURRENCY_CONVERSION_DATE,
1570 l_CURRENCY_CONVERSION_RATE,
1571 l_CURRENCY_CONVERSION_TYPE,
1572 l_legal_reporting_status,
1573 --bug 7300367
1574 --bug 7369708
1575 l_hq_estb_pty_tax_prof_id, --HQ_ESTB_PARTY_TAX_PROF_ID
1576 l_CURRENCY_CONVERSION_DATE, --TAX_CURRENCY_CONVERSION_DATE
1577 P_LINE_AMT, --UNIT_PRICE
1578 1, --TRX_LINE_QUANTITY
1579 1, --TAX_BASE_MODIFIER_RATE
1580 'SHIP_TO',
1581 p_trx_date, --TAX_DATE
1582 p_trx_date, --TAX_POINT_DATE
1583 l_tax_type_code,
1584 --ROUNDING_LVL_PARTY_TAX_PROF_ID,
1585 --ROUNDING_LVL_PARTY_TYPE,
1586 l_internal_org_loc_id, --INTERNAL_ORG_LOCATION_ID
1587 P_LINE_AMT, --LINE_ASSESSABLE_VALUE
1588 l_rate_type_code,
1589 --bug 7369708
1590 fnd_global.user_id,
1591 sysdate,
1592 fnd_global.user_id,
1593 sysdate,
1594 fnd_global.login_id);
1595
1596 INSERT INTO ZX_LINES_DET_FACTORS( INTERNAL_ORGANIZATION_ID,
1597 APPLICATION_ID,
1598 ENTITY_CODE,
1599 EVENT_CLASS_CODE,
1600 EVENT_TYPE_CODE,
1601 LINE_LEVEL_ACTION,
1602 TRX_ID,
1603 TRX_LINE_ID,
1604 TRX_LEVEL_TYPE,
1605 TRX_DATE,
1606 TRX_LINE_GL_DATE,
1607 LEGAL_ENTITY_ID,
1608 LINE_AMT,
1609 LINE_AMT_INCLUDES_TAX_FLAG,
1610 record_type_code,
1611 object_version_number,
1612 LEDGER_ID,
1613 FIRST_PTY_ORG_ID,
1614 TRX_CURRENCY_CODE,
1615 CURRENCY_CONVERSION_DATE,
1616 CURRENCY_CONVERSION_RATE,
1617 CURRENCY_CONVERSION_TYPE,
1618 tax_processing_completed_flag,
1619 --bug 7300367
1620 TAX_EVENT_CLASS_CODE,
1621 LINE_CLASS,
1622 TRX_LINE_TYPE,
1623 TRX_NUMBER,
1624 TRX_LINE_NUMBER,
1625 ASSESSABLE_VALUE,
1626 HISTORICAL_FLAG,
1627 MINIMUM_ACCOUNTABLE_UNIT,
1628 PRECISION,
1629 TAX_REPORTING_FLAG,
1630 --bug 7300367
1631 --bug 7369708
1632 EVENT_CLASS_MAPPING_ID,
1633 DEFAULT_TAXATION_COUNTRY,
1634 --DOC_SEQ_ID,
1635 --DOC_SEQ_NAME,
1636 --DOC_SEQ_VALUE,
1637 RDNG_SHIP_FROM_PTY_TX_PROF_ID,
1638 RDNG_BILL_FROM_PTY_TX_PROF_ID,
1639 RDNG_SHIP_FROM_PTY_TX_P_ST_ID,
1640 RDNG_BILL_FROM_PTY_TX_P_ST_ID,
1641 TRX_LINE_QUANTITY,
1642 HQ_ESTB_PARTY_TAX_PROF_ID,
1643 SHIP_TO_LOCATION_ID,
1644 SHIP_FROM_LOCATION_ID,
1645 BILL_TO_LOCATION_ID,
1646 BILL_FROM_LOCATION_ID,
1647 SHIP_FROM_PARTY_TAX_PROF_ID,
1648 BILL_FROM_PARTY_TAX_PROF_ID,
1649 SHIP_FROM_SITE_TAX_PROF_ID,
1650 BILL_FROM_SITE_TAX_PROF_ID,
1651 CTRL_HDR_TX_APPL_FLAG,
1652 TRX_LINE_DATE,
1653 INTERNAL_ORG_LOCATION_ID,
1657 SHIP_THIRD_PTY_ACCT_ID,
1654 UNIT_PRICE,
1655 SHIP_THIRD_PTY_ACCT_SITE_ID,
1656 BILL_THIRD_PTY_ACCT_SITE_ID,
1658 BILL_THIRD_PTY_ACCT_ID,
1659 TRX_LINE_CURRENCY_CODE,
1660 TRX_LINE_CURRENCY_CONV_RATE,
1661 TRX_LINE_CURRENCY_CONV_DATE,
1662 TRX_LINE_PRECISION,
1663 TRX_LINE_MAU,
1664 TRX_LINE_CURRENCY_CONV_TYPE,
1665 TOTAL_INC_TAX_AMT,
1666 CREATED_BY,
1667 CREATION_DATE,
1668 LAST_UPDATED_BY,
1669 LAST_UPDATE_DATE,
1670 LAST_UPDATE_LOGIN
1671 --bug 7369708
1672 )
1673 VALUES
1674 (
1675 p_internal_organization_id,
1676 p_APPLICATION_ID,
1677 P_ENTITY_CODE,
1678 P_EVENT_CLASS_CODE,
1679 p_event_type_code,
1680 'LINE_INFO_TAX_ONLY',
1681 p_TRX_ID,
1682 l_trx_line_id,
1683 'LINE',
1684 p_TRX_line_DATE,
1685 p_trx_line_gl_date,
1686 p_LEGAL_ENTITY_ID,
1687 p_tax_amt,
1688 p_tax_amt_included_flag,
1689 'ETAX_CREATED',
1690 1,
1691 p_LEDGER_ID,
1692 p_content_owner_id,
1693 l_trx_currency_code, -- should be changed to p_trx_currence_code
1694 l_CURRENCY_CONVERSION_DATE,
1695 l_CURRENCY_CONVERSION_RATE,
1696 l_CURRENCY_CONVERSION_TYPE,
1697 'Y',
1698 --bug 7300367
1699 l_tax_event_class_code,
1700 P_EVENT_CLASS_CODE,
1701 'ITEM',
1702 l_trx_number,
1703 l_trx_line_number,
1704 p_line_amt,
1705 'N',
1706 p_minimum_accountable_unit,
1707 p_precision,
1708 l_tax_reporting_flag,
1709 --bug 7300367
1710 --bug 7369708
1711 l_event_class_mapping_id, --EVENT_CLASS_MAPPING_ID
1712 l_default_taxation_country, --DEFAULT_TAXATION_COUNTRY
1713 --DOC_SEQ_ID,
1714 --DOC_SEQ_NAME,
1715 --DOC_SEQ_VALUE,
1716 l_rndg_ship_fr_pty_tx_prof_id, --RDNG_SHIP_FROM_PTY_TX_PROF_ID
1717 l_rndg_bill_fr_pty_tx_prof_id, --RDNG_BILL_FROM_PTY_TX_PROF_ID
1718 l_rndg_ship_fr_pty_tx_p_st_id, --RDNG_SHIP_FROM_PTY_TX_P_ST_ID
1719 l_rndg_bill_fr_pty_tx_p_st_id, --RDNG_BILL_FROM_PTY_TX_P_ST_ID
1720 1, --TRX_LINE_QUANTITY
1721 l_hq_estb_pty_tax_prof_id,--HQ_ESTB_PARTY_TAX_PROF_ID
1722 l_ship_to_location_id, --SHIP_TO_LOCATION_ID
1723 l_ship_from_location_id, --SHIP_FROM_LOCATION_ID
1724 l_bill_to_location_id, --BILL_TO_LOCATION_ID
1725 l_bill_from_location_id, --BILL_FROM_LOCATION_ID
1726 l_ship_from_pty_tax_prof_id, --SHIP_FROM_PARTY_TAX_PROF_ID
1727 l_bill_from_pty_tax_prof_id, --BILL_FROM_PARTY_TAX_PROF_ID
1728 l_ship_from_site_tx_prof_id, --SHIP_FROM_SITE_TAX_PROF_ID
1729 l_bill_from_site_tx_prof_id, --BILL_FROM_SITE_TAX_PROF_ID
1730 l_ctrl_hdr_tx_appl_flag, --CTRL_HDR_TX_APPL_FLAG
1731 p_trx_line_date, --TRX_LINE_DATE
1732 l_internal_org_loc_id, --INTERNAL_ORG_LOCATION_ID
1733 p_line_amt, --UNIT_PRICE
1734 l_ship_third_pty_acct_site_id, --SHIP_THIRD_PTY_ACCT_SITE_ID
1735 l_bill_third_pty_acct_site_id, --BILL_THIRD_PTY_ACCT_SITE_ID
1736 l_ship_third_pty_acct_id, --SHIP_THIRD_PTY_ACCT_ID
1737 l_bill_third_pty_acct_id, --BILL_THIRD_PTY_ACCT_ID
1738 l_trx_currency_code, --TRX_LINE_CURRENCY_CODE
1739 l_currency_conversion_rate, --TRX_LINE_CURRENCY_CONV_RATE
1740 l_currency_conversion_date, --TRX_LINE_CURRENCY_CONV_DATE
1741 p_precision, --TRX_LINE_PRECISION
1742 p_minimum_accountable_unit, --TRX_LINE_MAU
1743 l_currency_conversion_type, --TRX_LINE_CURRENCY_CONV_TYPE
1744 0, --TOTAL_INC_TAX_AMT
1745 fnd_global.user_id, --CREATED_BY
1746 sysdate, --CREATION_DATE
1747 fnd_global.user_id, --LAST_UPDATED_BY
1748 sysdate, --LAST_UPDATE_DATE
1749 fnd_global.login_id --LAST_UPDATE_LOGIN
1750 --bug 7369708
1751
1752 );
1753
1754
1755
1756
1757 END IF;
1758
1759 IF (g_level_procedure >= g_current_runtime_level ) THEN
1760 FND_LOG.STRING(g_level_procedure,
1761 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_Tax_Line.BEGIN',
1762 'Insert_Tax_Line (-)');
1763 END IF;
1764
1765 EXCEPTION
1766 WHEN NO_DATA_FOUND THEN
1767 NULL;
1768
1769 END Insert_Tax_Line;
1770
1771 PROCEDURE Populate_alloc_tbl(p_key IN VARCHAR2) IS
1772 BEGIN
1773 IF (g_level_statement >= g_current_runtime_level ) THEN
1774 FND_LOG.STRING(g_level_statement,
1775 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation',
1776 'key : ' || p_key) ;
1777 END IF;
1778 g_trx_allocate_tbl(p_key) := 'Y';
1779 EXCEPTION
1780 WHEN others THEN
1781 NULL;
1782 END;
1783 END ZX_TRL_ALLOCATIONS_PKG;