[Home] [Help]
260: -- END IF;
261:
262:
263:
264: UPDATE JAI_PO_TAXES
265: SET Currency = v_curr,
266: Last_Update_Date = v_last_upd_dt,
267: Last_Updated_By = v_last_upd_by,
268: Last_Update_Login = v_last_upd_login
388:
389:
390: CURSOR Chk_Vendor( lineid IN NUMBER, linelocid IN NUMBER ) IS
391: SELECT Vendor_Id
392: FROM JAI_PO_TAXES
393: WHERE Po_Line_Id = lineid
394: AND Line_Location_Id = linelocid;
395:
396: CURSOR Chk_Vendor1( lineid IN NUMBER ) IS
394: AND Line_Location_Id = linelocid;
395:
396: CURSOR Chk_Vendor1( lineid IN NUMBER ) IS
397: SELECT Vendor_Id
398: FROM JAI_PO_TAXES
399: WHERE Po_Line_Id = lineid
400: AND Line_Location_Id IS NULL;
401:
402: --This code is added to check value of Tax Override Flag for the Supplier,Supplier_site_id
439: Dependency Due to this Bug:-
440: The current trigger becomes dependent on the function jai_cmn_utils_pkg.check_jai_exists version 115.0. introduced through the bug 4033992
441:
442: 4. 23/Jan/2005 brathod for bug#4030192 Version#115.2
443: Issue:- Trigger is not updating the vendor_id field in JAI_PO_TAXES
444: when a PO having no vendor is updated with the new vendor.
445:
446: Fix :- Modified condition that checks wether pr_old.vendor_id is equal to vendor_id in
447: JAI_PO_TAXES. The condition was evaluating to false because
443: Issue:- Trigger is not updating the vendor_id field in JAI_PO_TAXES
444: when a PO having no vendor is updated with the new vendor.
445:
446: Fix :- Modified condition that checks wether pr_old.vendor_id is equal to vendor_id in
447: JAI_PO_TAXES. The condition was evaluating to false because
448: comparision like "Null = Null".
449:
450: 5. 17-Mar-2005 hjujjuru - bug #4245062 File version 115.3
451: The Assessable Value is calculated for the transaction. For this, a call is
578: /** Added by Sriram **/
579:
580: IF nvl(v_override_flag,'N') = 'Y' THEN
581:
582: DELETE FROM JAI_PO_TAXES
583: WHERE po_header_id = v_po_hdr_id;
584:
585: jai_po_tax_pkg.copy_reqn_taxes
586: (
708: --ended, Harshita for bug #4245062
709:
710: IF v_tax_flag = 'N' THEN
711:
712: DELETE FROM JAI_PO_TAXES
713: WHERE Po_Line_Id = Rec.Po_Line_Id
714: AND NVL( Line_Location_Id, -999 ) = NVL( Rec1.Line_Location_Id, -999 );
715:
716:
835:
836: -- Modified by Bhavik for BUG#4030192
837: IF NVL(pr_old.Vendor_Id,0) = NVL( v_old_vendor_id, NVL(pr_old.Vendor_Id,0) ) THEN
838:
839: UPDATE JAI_PO_TAXES
840: SET Vendor_Id = v_vendor_id
841: WHERE Po_Line_Id = Rec.Po_Line_Id
842: AND Line_Location_Id = Rec1.Line_Location_Id;
843: