chosen1brain的专栏

DECLARE l_api_version_number NUMBER := 1; l_return_status VARCHAR2(2000); l_msg_count NUMBER; l_msg_data VARCHAR2(2000); -- PARAMETERS l_debug_level NUMBER := 5;

DECLARE l_header_rec oe_order_pub.header_rec_type; l_line_tbl oe_order_pub.line_tbl_type; l_action_request_tbl oe_order_pub.request_tbl_type; l_header

SET SERVEROUTPUT ON;/*beginfnd_global.APPS_INITIALIZE(user_id=> 0,resp_id => 50702,resp_appl_id =>660 ); mo_global.init('M');end;*/DECLARE v_return_status VARCHAR2(1) := NULL; v

Declare l_header_rec Oe_Order_Pub.header_rec_type; l_line_tbl Oe_Order_Pub.line_tbl_type; l_line_tb2 Oe_Order_Pub.line_tbl_type; l_action_request_tbl

DECLARE v_api_version_number NUMBER := 1; v_return_status VARCHAR2(2000); v_msg_count NUMBER; v_msg_data VARCHAR2(2000); -- IN Variables -- v_header_rec oe_

DECLARE x_return_status VARCHAR2(2); x_msg_count NUMBER; x_msg_data VARCHAR2(2000); p_api_version_number NUMBER := 1.0; init_msg_list VARCHAR2(200); x_msg_d

DECLARE p_sales_order NUMBER := 1506764295; p_line_number NUMBER := 1.1; p_org_id NUMBER := 121; l_shipped_quantity NUMBER := 1; p_api_version_nu