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;
/
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;
/