APPS.JAI_PO_DA_TRIGGER_PKG dependencies on JAI_PO_LINE_LOCATIONS

Line 85: FROM JAI_PO_LINE_LOCATIONS

81:
82: --added, Bgowrava for Bug#6084636
83: Cursor c_get_tax_modified_flag IS
84: SELECT tax_modified_flag
85: FROM JAI_PO_LINE_LOCATIONS
86: WHERE line_location_id = pr_new.line_location_id ;
87: lv_tax_modified_flag VARCHAR2(1) ;
88:
89: CURSOR get_vendor_info IS

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 283: DELETE from JAI_PO_LINE_LOCATIONS

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;
285:
286: END IF ;
287:

Line 296: FROM JAI_PO_LINE_LOCATIONS

292: else
293: --END, added, Bgowrava for Bug#6084636
294: SELECT count(line_location_id)
295: into v_count1
296: FROM JAI_PO_LINE_LOCATIONS
297: WHERE line_location_id=v_line_location_id;
298:
299: IF v_count1 > 0 THEN
300: RETURN;