[Home] [Help]
376: sl.txn_unit_price sl_txn_unit_price,
377: sl.ship_line_id
378: FROM
379: inl_ship_lines sl,
380: zx_lines zl
381: WHERE sl.ship_header_id = p_ship_header_id
382: AND sl.ship_line_src_type_code = 'PO'
383: AND sl.ship_line_source_id = zl.trx_line_id
384: AND zl.application_id = 201
393: WHERE assoc.from_parent_table_name = 'INL_TAX_LINES'
394: AND assoc.from_parent_table_id = tl.tax_line_id
395: AND assoc.to_parent_table_name = 'INL_SHIP_LINES'
396: AND tl.ship_header_id = p_ship_header_id
397: AND tl.source_parent_table_name = 'ZX_LINES'
398: ) tl_assoc
399: WHERE tl_assoc.source_parent_table_id(+) = sl_zx.tax_line_id
400: AND tl_assoc.to_parent_table_id(+) = sl_zx.ship_line_id
401: ;
429:
430: IF ( NVL(zlines_tbl.COUNT,0) > 0) THEN
431: -- loop in all taxes of current shipment
432: FOR i IN zlines_tbl.FIRST..zlines_tbl.LAST LOOP
433: -- when eBTax recalculates the taxes the tax_line_id in zx_lines remains the same
434:
435: p_tax_ln_tbl(i).tax_code := zlines_tbl(i).tax;
436: p_tax_ln_tbl(i).ship_header_id := p_ship_header_id;
437: p_tax_ln_tbl(i).source_parent_table_name := 'ZX_LINES';
433: -- when eBTax recalculates the taxes the tax_line_id in zx_lines remains the same
434:
435: p_tax_ln_tbl(i).tax_code := zlines_tbl(i).tax;
436: p_tax_ln_tbl(i).ship_header_id := p_ship_header_id;
437: p_tax_ln_tbl(i).source_parent_table_name := 'ZX_LINES';
438: p_tax_ln_tbl(i).source_parent_table_id := zlines_tbl(i).tax_line_id;
439: p_tax_ln_tbl(i).to_parent_table_name := 'INL_SHIP_LINES';
440: p_tax_ln_tbl(i).to_parent_table_id := zlines_tbl(i).ship_line_id;
441: p_tax_ln_tbl(i).currency_code := zlines_tbl(i).tax_currency_code;
1356: --
1357: -- Type : Private
1358: --
1359: -- Function : It populate zx_transaction_lines_gt. The records of this table will be processed for
1360: -- zx_api_pub.calculate_tax procedure to generate taxes (zx_lines)
1361: --
1362: -- Pre-reqs : None
1363: --
1364: -- Parameters :
1746: --
1747: -- Function : It makes adjusts (Insert, Delete or Both) in tax_line table.
1748: -- For a given Ship_Header_Id DEL will remove all rows from this shipment of the
1749: -- INL_tax_lines and from INL_associations
1750: -- INS will insert in INL_tax_lines all lines from zx_lines
1751: -- If the zx_line has recover amount two lines will be generated in INL_tax_lines.
1752: --
1753: -- Pre-reqs : None
1754: --
1798: ,DECODE(lv.source, 'SHIP_LINE' ,'INL_SHIP_LINES'
1799: , 'CHARGE' ,'INL_CHARGE_LINES') source
1800: ,oh.ship_TYPE_ID
1801: ,inl_tax_lines_s.NEXTVAL tax_line_id_s
1802: FROM zx_lines zl
1803: ,inl_ebtax_lines_v lv
1804: ,inl_ship_headers oh
1805: WHERE zl.application_id = 9004
1806: AND zl.trx_id = P_ship_Header_Id
1864: ,curTax.tax_line_number
1865: ,curTax.tax_code
1866: ,curTax.trx_id
1867: ,0
1868: ,'ZX_LINES'
1869: ,curTax.tax_line_id
1870: ,curTax.tax_amt
1871: ,curTax.nrec_tax_amt
1872: ,curTax.tax_currency_code
2170: -----------------------------------------------------------------
2171: BEGIN
2172: SELECT 'Y'
2173: INTO l_tax_already_calculated
2174: FROM zx_lines_det_factors
2175: WHERE trx_id = l_ship_header_rec.ship_header_id
2176: AND application_id = 9004
2177: AND entity_code = G_ENTITY_CODE
2178: AND event_class_code = l_event_class_code
2245: p_in_param_value4 => FND_API.G_VALID_LEVEL_FULL
2246: );
2247: --- It will run the calculate_tax procedure from eBTax
2248: --- This procedure will calculate the tax from the current transaction
2249: --- and populate zx_lines
2250:
2251: /*
2252: FROM ZX_TRANSACTION_LINES_GT
2253: WHERE TRX_ID = l_ship_header_rec.ship_header_id
2288: p_module_name => g_module_name,
2289: p_procedure_name => l_api_name,
2290: p_debug_info => l_debug_info);
2291: -----------------------------------------------------------------
2292: -- It will answer the updates done in zx_lines in INL_tax_lines
2293: Adjust_Tax_Lines(p_ship_header_id, l_return_status);
2294: -- If any errors happen abort API.
2295: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2296: RAISE FND_API.G_EXC_ERROR;
2476: x_prod_fisc_class_code,
2477: x_prod_category,
2478: x_intended_use,
2479: x_product_type
2480: FROM zx_lines_det_factors zx,
2481: po_line_locations pll
2482: WHERE zx.application_id = 201
2483: AND zx.event_class_code = 'PO_PA'
2484: AND zx.entity_code = 'PURCHASE_ORDER'