DECLARE
l_api_version_number CONSTANT NUMBER := 1.0;
l_api_name CONSTANT VARCHAR2(30) := 'cux_create_order';
l_control_rec oe_globals.control_rec_type;
l_return_status VARCHAR2(1);
l_msg_count NUMBER;
l_line_con NUMBER := 0;
x_msg_data VARCHAR2(1000);
l_source_id NUMBER := 0;
l_header_rec oe_order_pub.header_rec_type := oe_order_pub.g_miss_header_rec;
o_header_rec oe_order_pub.header_rec_type;
l_header_val_rec oe_order_pub.header_val_rec_type;
l_header_adj_tbl oe_order_pub.header_adj_tbl_type;
l_header_adj_val_tbl oe_order_pub.header_adj_val_tbl_type;
l_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
l_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
l_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
l_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
l_header_scredit_val_tbl oe_order_pub.header_scredit_val_tbl_type;
l_line_tbl oe_order_pub.line_tbl_type := oe_order_pub.g_miss_line_tbl;
o_line_tbl oe_order_pub.line_tbl_type;
l_line_adj_tbl oe_order_pub.line_adj_tbl_type;
l_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
l_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
l_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
l_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
l_lot_serial_tbl oe_order_pub.lot_serial_tbl_type;
l_line_val_tbl oe_order_pub.line_val_tbl_type;
l_line_adj_val_tbl oe_order_pub.line_adj_val_tbl_type;
l_line_scredit_val_tbl oe_order_pub.line_scredit_val_tbl_type;
l_lot_serial_val_tbl oe_order_pub.lot_serial_val_tbl_type;
l_action_qeq_tbl oe_order_pub.request_tbl_type;
x_action_qeq_tbl oe_order_pub.request_tbl_type;
l_api_version_number CONSTANT NUMBER := 1.0;
l_api_name CONSTANT VARCHAR2(30) := 'cux_create_order';
l_control_rec oe_globals.control_rec_type;
l_return_status VARCHAR2(1);
l_msg_count NUMBER;
l_line_con NUMBER := 0;
x_msg_data VARCHAR2(1000);
l_source_id NUMBER := 0;
l_header_rec oe_order_pub.header_rec_type := oe_order_pub.g_miss_header_rec;
o_header_rec oe_order_pub.header_rec_type;
l_header_val_rec oe_order_pub.header_val_rec_type;
l_header_adj_tbl oe_order_pub.header_adj_tbl_type;
l_header_adj_val_tbl oe_order_pub.header_adj_val_tbl_type;
l_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
l_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
l_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
l_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
l_header_scredit_val_tbl oe_order_pub.header_scredit_val_tbl_type;
l_line_tbl oe_order_pub.line_tbl_type := oe_order_pub.g_miss_line_tbl;
o_line_tbl oe_order_pub.line_tbl_type;
l_line_adj_tbl oe_order_pub.line_adj_tbl_type;
l_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
l_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
l_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
l_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
l_lot_serial_tbl oe_order_pub.lot_serial_tbl_type;
l_line_val_tbl oe_order_pub.line_val_tbl_type;
l_line_adj_val_tbl oe_order_pub.line_adj_val_tbl_type;
l_line_scredit_val_tbl oe_order_pub.line_scredit_val_tbl_type;
l_lot_serial_val_tbl oe_order_pub.lot_serial_val_tbl_type;
l_action_qeq_tbl oe_order_pub.request_tbl_type;
x_action_qeq_tbl oe_order_pub.request_tbl_type;