[Home] [Help]
263: -- END IF;
264:
265:
266:
267: UPDATE JAI_PO_TAXES
268: SET Currency = v_curr,
269: Last_Update_Date = v_last_upd_dt,
270: Last_Updated_By = v_last_upd_by,
271: Last_Update_Login = v_last_upd_login
394:
395:
396: CURSOR Chk_Vendor( lineid IN NUMBER, linelocid IN NUMBER ) IS
397: SELECT Vendor_Id
398: FROM JAI_PO_TAXES
399: WHERE Po_Line_Id = lineid
400: AND Line_Location_Id = linelocid;
401:
402: CURSOR Chk_Vendor1( lineid IN NUMBER ) IS
400: AND Line_Location_Id = linelocid;
401:
402: CURSOR Chk_Vendor1( lineid IN NUMBER ) IS
403: SELECT Vendor_Id
404: FROM JAI_PO_TAXES
405: WHERE Po_Line_Id = lineid
406: AND Line_Location_Id IS NULL;
407:
408: --This code is added to check value of Tax Override Flag for the Supplier,Supplier_site_id
445: Dependency Due to this Bug:-
446: The current trigger becomes dependent on the function jai_cmn_utils_pkg.check_jai_exists version 115.0. introduced through the bug 4033992
447:
448: 4. 23/Jan/2005 brathod for bug#4030192 Version#115.2
449: Issue:- Trigger is not updating the vendor_id field in JAI_PO_TAXES
450: when a PO having no vendor is updated with the new vendor.
451:
452: Fix :- Modified condition that checks wether pr_old.vendor_id is equal to vendor_id in
453: JAI_PO_TAXES. The condition was evaluating to false because
449: Issue:- Trigger is not updating the vendor_id field in JAI_PO_TAXES
450: when a PO having no vendor is updated with the new vendor.
451:
452: Fix :- Modified condition that checks wether pr_old.vendor_id is equal to vendor_id in
453: JAI_PO_TAXES. The condition was evaluating to false because
454: comparision like "Null = Null".
455:
456: 5. 17-Mar-2005 hjujjuru - bug #4245062 File version 115.3
457: The Assessable Value is calculated for the transaction. For this, a call is
596: /** Added by Sriram **/
597:
598: IF nvl(v_override_flag,'N') = 'Y' THEN
599:
600: DELETE FROM JAI_PO_TAXES
601: WHERE po_header_id = v_po_hdr_id;
602:
603: jai_po_tax_pkg.copy_reqn_taxes
604: (
757: -- Added by Jia for GST Bug#10091373 on 2010/09/10, end
758:
759: IF v_tax_flag = 'N' THEN
760:
761: DELETE FROM JAI_PO_TAXES
762: WHERE Po_Line_Id = Rec.Po_Line_Id
763: AND NVL( Line_Location_Id, -999 ) = NVL( Rec1.Line_Location_Id, -999 );
764:
765:
890:
891: -- Modified by Bhavik for BUG#4030192
892: IF NVL(pr_old.Vendor_Id,0) = NVL( v_old_vendor_id, NVL(pr_old.Vendor_Id,0) ) THEN
893:
894: UPDATE JAI_PO_TAXES
895: SET Vendor_Id = v_vendor_id
896: WHERE Vendor_id = nvl(pr_old.vendor_id,0) /*Added by nprashar for bug 8349329*/
897: AND Po_Line_Id = Rec.Po_Line_Id
898: AND nvl(Line_Location_Id,-999) = nvl(Rec1.Line_Location_Id,-999); /*Added by nprashar for bug 8349329*/