Saturday, September 6, 2014

INV API: Approve Inventory Move Order invtroap.start_to_approval

CREATE OR REPLACE PROCEDURE APPS.ets_approve_move_order (
   p_move_order_number   IN   varchar2
)
AS
   v_header_id   NUMBER;
BEGIN
   BEGIN
      SELECT hd.header_id
        INTO v_header_id
        FROM mtl_txn_request_headers hd
       WHERE hd.request_number = p_move_order_number;
   EXCEPTION
      WHEN OTHERS
      THEN
         v_header_id := NULL;
   END;
   invtroap.start_to_approval (to_header_id      => v_header_id,
                               item_type         => 'INVTROAP',
                               item_key          => to_char(v_header_id)
                              );
END;
/