19:
20:
21: cursor c_get_tax_count(p_shipment_header_id number, p_shipment_line_id number) is
22: select count(1)
23: from JAI_RCV_LINE_TAXES
24: where shipment_header_id = p_shipment_header_id
25: and shipment_line_id = p_shipment_line_id;
26:
27:
854: WHERE shipment_line_id = pr_new.shipment_line_id;
855:
856: /* following added as part of VAT Impl. Changes */
857: IF pr_new.transaction_type = 'MATCH' THEN
858: UPDATE JAI_RCV_LINE_TAXES
859: SET transaction_id = pr_new.transaction_id
860: , last_update_date = sysdate
861: , last_updated_by = fnd_global.user_id
862: WHERE shipment_line_id = pr_new.shipment_line_id