APPS.JAI_PO_DA_TRIGGER_PKG dependencies on JAI_PO_TAXES

Line 118: moved the code which returns the control if taxes are already present in the JAI_PO_TAXES table

114: 1. 09/11/2004 ssumaith - bug# 3949401 Version#115.1
115:
116: commented the code which returns when the new.po_release_id is null
117:
118: moved the code which returns the control if taxes are already present in the JAI_PO_TAXES table
119: for the current line_location_id to the else part of the shipment_type <> 'BLANKET'
120:
121: Added code to delete taxes from the JAI_PO_LINE_LOCATIONS and JAI_PO_TAXES
122: when the new.req_distribution_id is not null

Line 121: Added code to delete taxes from the JAI_PO_LINE_LOCATIONS and JAI_PO_TAXES

117:
118: moved the code which returns the control if taxes are already present in the JAI_PO_TAXES table
119: for the current line_location_id to the else part of the shipment_type <> 'BLANKET'
120:
121: Added code to delete taxes from the JAI_PO_LINE_LOCATIONS and JAI_PO_TAXES
122: when the new.req_distribution_id is not null
123:
124: Added cursor and code for INR check and returning code if set of books currency is a non india currency.
125:

Line 280: DELETE from JAI_PO_TAXES

276: if pr_new.po_release_id is null then
277: -- added, Harshita for Bug 4618717
278: IF nvl(v_override_flag,'N') = 'N' and NVL(lv_tax_modified_flag, 'N') = 'N' THEN
279:
280: DELETE from JAI_PO_TAXES
281: WHERE line_location_id = v_line_location_id;
282:
283: DELETE from JAI_PO_LINE_LOCATIONS
284: WHERE line_location_id = v_line_location_id;