Sample code Oe_order_pub.process_order
set serveroutput on DECLARE l_num_api_version NUMBER := 1; l_num_loop_count NUMBER := 0; l_chr_return_status VARCHAR2 (2000); l_num_msg_count NUMBER; l_chr_msg_data VARCHAR2 (4000); l_num_req_id NUMBER; l_num_rep_req_id NUMBER; -- IN Variables -- l_rec_header oe_order_pub.header_rec_type; l_tbl_line oe_order_pub.line_tbl_type; l_tbl_action_request oe_order_pub.request_tbl_type; l_tbl_line_adj oe_order_pub.line_adj_tbl_type; l_request_rec oe_order_pub.request_rec_type; -- OUT Variables -- l_out_rec_header oe_order_pub.header_rec_type; l_out_rec_header_val oe_order_pub.header_val_rec_type; l_out_tbl_header_adj oe_order_pub.header_adj_tbl_type; l_out_tbl_header_adj_val oe_order_pub.header_adj_val_tbl_type; l_out_t
