2020/07/30

[API] Re-calculate TAX

--This API works same as ‘Actions->Calculate Tax’ from Sales Order Form (OEXOEORD)
DECLARE
 vHeaderId oe_order_headers_all.header_id%TYPE := 000;
 xReturnStatus varcahr2(1); 
BEGIN 
   om_tax_util.calculate_tax(p_header_id => vHeaderId , x_return_status => xReturnStatus);
   IF (xReturnStatus = fnd_api.g_ret_sts_success) THEN 
      COMMIT;
   ELSE
      dbms_output.put_line('Failed in Re-Calculating TAX');
      ROLLBACK;
   END IF;
END;

沒有留言: