[Home] [Help]
363: 12. 04-Jun-2007 brathod for BUG#5879769, 6109941 File Version # 120.2
364: Added a Call to function get_service_type to get the Service_Type_Code.
365:
366: 13. 22-Jun-2007 CSahoo for bug#6144740, File Version 120.4
367: Added the parameter pr_new.quantity to the call to jai_po_tax_pkg.Ja_In_Po_Case1 procedure
368:
369: 14. 08-Jul-2009 Bug 8586635
370: Description: When the Shipment Lines are split in iSupplier, the appropriate Taxes are not updated
371: Fix: Tax Lines are inserted into jai_po_taxes on a prorated basis
595: where line_location_id = v_line_loc_id;
596: /*Insert Taxes of the parent line in to the split line after adjusting the Tax Amount and Tax Target Amount*/
597: for r_get_po_taxes in c_get_po_taxes(v_orig_ship_id) loop
598:
599: jai_po_tax_pkg.Ja_In_Po_Insert
600: ( v_type_lookup_code, v_quot_class_code,
601: l_line_focus_id, v_line_loc_id,
602: r_get_po_taxes.tax_line_no, r_get_po_taxes.po_line_id, r_get_po_taxes.po_header_id,
603: r_get_po_taxes.precedence_1, r_get_po_taxes.precedence_2, r_get_po_taxes.precedence_3,
790: END IF;
791:
792: -- condition added by Vijay Shankar for Bug# 3184418
793: IF v_tax_modified_flag = 'Y' THEN
794: jai_po_tax_pkg.Ja_In_Po_Case1(
795: v_type_lookup_code, v_quot_class_code, v_vendor_id, v_vendor_site_id, v_curr,
796: v_org_id, v_item_id, v_uom_measure, v_line_loc_id,
797: v_po_hdr_id, v_po_line_id, y, x, v_price, v_Qty, v_cre_dt,
798: v_cre_by, v_last_upd_dt, v_last_upd_by, v_last_upd_login, 'I', success, pr_new.quantity -- pr_new.quantity added by csahoo for bug#6144740
838:
839: END IF;
840:
841: IF success <> 0 THEN
842: jai_po_tax_pkg.Ja_In_Po_Case2 (
843: v_type_lookup_code, v_quot_class_code, v_vendor_id, v_vendor_site_id, v_curr,
844: v_org_id, v_item_id, v_line_loc_id, v_po_hdr_id, v_po_line_id,
845: v_price, v_qty, v_cre_dt, v_cre_by, v_last_upd_dt,
846: v_last_upd_by, v_last_upd_login, v_uom_measure, NULL,P_VAT_ASSESS_VALUE => NULL
1185:
1186: 11. 23-Mar-2009 Bug 8224547 File version 120.6.12010000.2/120.7
1187: Issue - Not able to update PO line quantity and save - getting the PL/SQL
1188: character to number conversion error.
1189: Cause - In procedure ARU_T1, the call to jai_po_tax_pkg.Ja_In_Po_Case2 didn't
1190: have the 4 parameters (they have default value of null) introduced for
1191: bug 5096787. In the previous version, lv_retro_price_flag was passed
1192: as the last parameter, which got assigned to the parameter v_rate as
1193: per the spec. v_rate is a number variable, and this caused the error.
1191: bug 5096787. In the previous version, lv_retro_price_flag was passed
1192: as the last parameter, which got assigned to the parameter v_rate as
1193: per the spec. v_rate is a number variable, and this caused the error.
1194: Fix - Inserted 4 null values as parameters (just before lv_retro_price_flag)
1195: in the call to jai_po_tax_pkg.Ja_In_Po_Case2.
1196:
1197: 12. 10-Sep-2010 Jia for GST Bug#10043656.
1198:
1199: Future Dependencies For the release Of this Object:-
1768: ELSE
1769: v_currency_conv_rate := 1;
1770: END IF;
1771:
1772: jai_po_tax_pkg.calc_tax(
1773: p_type => 'STANDARDPO',
1774: p_header_id => v_po_hdr_id,
1775: P_line_id => v_po_line_id,
1776: p_line_location_id => v_line_loc_id,
1792: );
1793: -- End, Vijay Shankar for Bug #3184673
1794:
1795: /* commented by Vijay Shankar for Bug #3184673
1796: jai_po_tax_pkg.calculate_tax( 'STANDARDPO', v_po_hdr_id, v_po_line_id, v_line_loc_id, v_qty,
1797: v_price*v_qty, v_uom_code, P_TAX_AMOUNT, v_assessable_value,
1798: NULL, v_curr_conv_factor
1799: );
1800: */
1855: v_last_upd_by,
1856: v_last_upd_login,
1857: 'I' );
1858:
1859: jai_po_tax_pkg.Ja_In_Po_Case1( v_type_lookup_code,
1860: v_quot_class_code,
1861: v_vendor_id,
1862: v_vendor_site_id,
1863: v_curr,
1879: 'I',
1880: success );
1881:
1882: IF success <> 0 THEN
1883: jai_po_tax_pkg.Ja_In_Po_Case2 ( v_type_lookup_code,
1884: v_quot_class_code,
1885: v_vendor_id,
1886: v_vendor_site_id,
1887: v_curr,