824: l_msg_count NUMBER;
825: l_msg_data VARCHAR2(2000);
826: l_msg_index NUMBER;
827: l_dummy VARCHAR2(1);
828: l_header_rec Aso_Quote_Pub.Qte_Header_Rec_Type;
829: l_line_tbl Aso_Quote_Pub.Qte_Line_Tbl_Type;
830: l_Line_dtl_tbl Aso_Quote_Pub.Qte_Line_Dtl_Tbl_Type;
831: l_hd_shipment_rec Aso_Quote_Pub.Shipment_rec_Type;
832: l_hd_shipment_tbl Aso_Quote_Pub.Shipment_tbl_Type;
825: l_msg_data VARCHAR2(2000);
826: l_msg_index NUMBER;
827: l_dummy VARCHAR2(1);
828: l_header_rec Aso_Quote_Pub.Qte_Header_Rec_Type;
829: l_line_tbl Aso_Quote_Pub.Qte_Line_Tbl_Type;
830: l_Line_dtl_tbl Aso_Quote_Pub.Qte_Line_Dtl_Tbl_Type;
831: l_hd_shipment_rec Aso_Quote_Pub.Shipment_rec_Type;
832: l_hd_shipment_tbl Aso_Quote_Pub.Shipment_tbl_Type;
833: l_ln_shipment_tbl Aso_Quote_Pub.Shipment_Tbl_Type;
826: l_msg_index NUMBER;
827: l_dummy VARCHAR2(1);
828: l_header_rec Aso_Quote_Pub.Qte_Header_Rec_Type;
829: l_line_tbl Aso_Quote_Pub.Qte_Line_Tbl_Type;
830: l_Line_dtl_tbl Aso_Quote_Pub.Qte_Line_Dtl_Tbl_Type;
831: l_hd_shipment_rec Aso_Quote_Pub.Shipment_rec_Type;
832: l_hd_shipment_tbl Aso_Quote_Pub.Shipment_tbl_Type;
833: l_ln_shipment_tbl Aso_Quote_Pub.Shipment_Tbl_Type;
834: l_hd_payment_tbl Aso_Quote_Pub.Payment_Tbl_Type; -- added by cnemalik
827: l_dummy VARCHAR2(1);
828: l_header_rec Aso_Quote_Pub.Qte_Header_Rec_Type;
829: l_line_tbl Aso_Quote_Pub.Qte_Line_Tbl_Type;
830: l_Line_dtl_tbl Aso_Quote_Pub.Qte_Line_Dtl_Tbl_Type;
831: l_hd_shipment_rec Aso_Quote_Pub.Shipment_rec_Type;
832: l_hd_shipment_tbl Aso_Quote_Pub.Shipment_tbl_Type;
833: l_ln_shipment_tbl Aso_Quote_Pub.Shipment_Tbl_Type;
834: l_hd_payment_tbl Aso_Quote_Pub.Payment_Tbl_Type; -- added by cnemalik
835: l_line_price_adj_tbl Aso_Quote_Pub.Price_Adj_Tbl_Type;
828: l_header_rec Aso_Quote_Pub.Qte_Header_Rec_Type;
829: l_line_tbl Aso_Quote_Pub.Qte_Line_Tbl_Type;
830: l_Line_dtl_tbl Aso_Quote_Pub.Qte_Line_Dtl_Tbl_Type;
831: l_hd_shipment_rec Aso_Quote_Pub.Shipment_rec_Type;
832: l_hd_shipment_tbl Aso_Quote_Pub.Shipment_tbl_Type;
833: l_ln_shipment_tbl Aso_Quote_Pub.Shipment_Tbl_Type;
834: l_hd_payment_tbl Aso_Quote_Pub.Payment_Tbl_Type; -- added by cnemalik
835: l_line_price_adj_tbl Aso_Quote_Pub.Price_Adj_Tbl_Type;
836: x_order_header_rec Aso_Order_Int.Order_Header_rec_type;
829: l_line_tbl Aso_Quote_Pub.Qte_Line_Tbl_Type;
830: l_Line_dtl_tbl Aso_Quote_Pub.Qte_Line_Dtl_Tbl_Type;
831: l_hd_shipment_rec Aso_Quote_Pub.Shipment_rec_Type;
832: l_hd_shipment_tbl Aso_Quote_Pub.Shipment_tbl_Type;
833: l_ln_shipment_tbl Aso_Quote_Pub.Shipment_Tbl_Type;
834: l_hd_payment_tbl Aso_Quote_Pub.Payment_Tbl_Type; -- added by cnemalik
835: l_line_price_adj_tbl Aso_Quote_Pub.Price_Adj_Tbl_Type;
836: x_order_header_rec Aso_Order_Int.Order_Header_rec_type;
837: x_order_line_tbl Aso_Order_Int.Order_Line_tbl_type;
830: l_Line_dtl_tbl Aso_Quote_Pub.Qte_Line_Dtl_Tbl_Type;
831: l_hd_shipment_rec Aso_Quote_Pub.Shipment_rec_Type;
832: l_hd_shipment_tbl Aso_Quote_Pub.Shipment_tbl_Type;
833: l_ln_shipment_tbl Aso_Quote_Pub.Shipment_Tbl_Type;
834: l_hd_payment_tbl Aso_Quote_Pub.Payment_Tbl_Type; -- added by cnemalik
835: l_line_price_adj_tbl Aso_Quote_Pub.Price_Adj_Tbl_Type;
836: x_order_header_rec Aso_Order_Int.Order_Header_rec_type;
837: x_order_line_tbl Aso_Order_Int.Order_Line_tbl_type;
838: x_order_header_id NUMBER;
831: l_hd_shipment_rec Aso_Quote_Pub.Shipment_rec_Type;
832: l_hd_shipment_tbl Aso_Quote_Pub.Shipment_tbl_Type;
833: l_ln_shipment_tbl Aso_Quote_Pub.Shipment_Tbl_Type;
834: l_hd_payment_tbl Aso_Quote_Pub.Payment_Tbl_Type; -- added by cnemalik
835: l_line_price_adj_tbl Aso_Quote_Pub.Price_Adj_Tbl_Type;
836: x_order_header_rec Aso_Order_Int.Order_Header_rec_type;
837: x_order_line_tbl Aso_Order_Int.Order_Line_tbl_type;
838: x_order_header_id NUMBER;
839: l_control_rec Aso_Order_Int.control_rec_type;
1253: l_ret_code BOOLEAN;
1254: p_batch_prefix VARCHAR2(10) := 'DR';
1255: x_order_header_id NUMBER;
1256:
1257: l_header_rec Aso_Quote_Pub.Qte_Header_Rec_Type;
1258: l_line_tbl Aso_Quote_Pub.Qte_Line_Tbl_Type;
1259: l_Line_dtl_tbl Aso_Quote_Pub.Qte_Line_Dtl_Tbl_Type;
1260: l_hd_shipment_rec Aso_Quote_Pub.Shipment_rec_Type;
1261: l_hd_shipment_tbl Aso_Quote_Pub.Shipment_tbl_Type;
1254: p_batch_prefix VARCHAR2(10) := 'DR';
1255: x_order_header_id NUMBER;
1256:
1257: l_header_rec Aso_Quote_Pub.Qte_Header_Rec_Type;
1258: l_line_tbl Aso_Quote_Pub.Qte_Line_Tbl_Type;
1259: l_Line_dtl_tbl Aso_Quote_Pub.Qte_Line_Dtl_Tbl_Type;
1260: l_hd_shipment_rec Aso_Quote_Pub.Shipment_rec_Type;
1261: l_hd_shipment_tbl Aso_Quote_Pub.Shipment_tbl_Type;
1262: l_ln_shipment_tbl Aso_Quote_Pub.Shipment_Tbl_Type;
1255: x_order_header_id NUMBER;
1256:
1257: l_header_rec Aso_Quote_Pub.Qte_Header_Rec_Type;
1258: l_line_tbl Aso_Quote_Pub.Qte_Line_Tbl_Type;
1259: l_Line_dtl_tbl Aso_Quote_Pub.Qte_Line_Dtl_Tbl_Type;
1260: l_hd_shipment_rec Aso_Quote_Pub.Shipment_rec_Type;
1261: l_hd_shipment_tbl Aso_Quote_Pub.Shipment_tbl_Type;
1262: l_ln_shipment_tbl Aso_Quote_Pub.Shipment_Tbl_Type;
1263: l_hd_payment_tbl Aso_Quote_Pub.Payment_Tbl_Type;
1256:
1257: l_header_rec Aso_Quote_Pub.Qte_Header_Rec_Type;
1258: l_line_tbl Aso_Quote_Pub.Qte_Line_Tbl_Type;
1259: l_Line_dtl_tbl Aso_Quote_Pub.Qte_Line_Dtl_Tbl_Type;
1260: l_hd_shipment_rec Aso_Quote_Pub.Shipment_rec_Type;
1261: l_hd_shipment_tbl Aso_Quote_Pub.Shipment_tbl_Type;
1262: l_ln_shipment_tbl Aso_Quote_Pub.Shipment_Tbl_Type;
1263: l_hd_payment_tbl Aso_Quote_Pub.Payment_Tbl_Type;
1264: l_line_price_adj_tbl Aso_Quote_Pub.Price_Adj_Tbl_Type;
1257: l_header_rec Aso_Quote_Pub.Qte_Header_Rec_Type;
1258: l_line_tbl Aso_Quote_Pub.Qte_Line_Tbl_Type;
1259: l_Line_dtl_tbl Aso_Quote_Pub.Qte_Line_Dtl_Tbl_Type;
1260: l_hd_shipment_rec Aso_Quote_Pub.Shipment_rec_Type;
1261: l_hd_shipment_tbl Aso_Quote_Pub.Shipment_tbl_Type;
1262: l_ln_shipment_tbl Aso_Quote_Pub.Shipment_Tbl_Type;
1263: l_hd_payment_tbl Aso_Quote_Pub.Payment_Tbl_Type;
1264: l_line_price_adj_tbl Aso_Quote_Pub.Price_Adj_Tbl_Type;
1265: x_order_header_rec Aso_Order_Int.Order_Header_rec_type;
1258: l_line_tbl Aso_Quote_Pub.Qte_Line_Tbl_Type;
1259: l_Line_dtl_tbl Aso_Quote_Pub.Qte_Line_Dtl_Tbl_Type;
1260: l_hd_shipment_rec Aso_Quote_Pub.Shipment_rec_Type;
1261: l_hd_shipment_tbl Aso_Quote_Pub.Shipment_tbl_Type;
1262: l_ln_shipment_tbl Aso_Quote_Pub.Shipment_Tbl_Type;
1263: l_hd_payment_tbl Aso_Quote_Pub.Payment_Tbl_Type;
1264: l_line_price_adj_tbl Aso_Quote_Pub.Price_Adj_Tbl_Type;
1265: x_order_header_rec Aso_Order_Int.Order_Header_rec_type;
1266: x_order_line_tbl Aso_Order_Int.Order_Line_tbl_type;
1259: l_Line_dtl_tbl Aso_Quote_Pub.Qte_Line_Dtl_Tbl_Type;
1260: l_hd_shipment_rec Aso_Quote_Pub.Shipment_rec_Type;
1261: l_hd_shipment_tbl Aso_Quote_Pub.Shipment_tbl_Type;
1262: l_ln_shipment_tbl Aso_Quote_Pub.Shipment_Tbl_Type;
1263: l_hd_payment_tbl Aso_Quote_Pub.Payment_Tbl_Type;
1264: l_line_price_adj_tbl Aso_Quote_Pub.Price_Adj_Tbl_Type;
1265: x_order_header_rec Aso_Order_Int.Order_Header_rec_type;
1266: x_order_line_tbl Aso_Order_Int.Order_Line_tbl_type;
1267: l_control_rec Aso_Order_Int.control_rec_type;
1260: l_hd_shipment_rec Aso_Quote_Pub.Shipment_rec_Type;
1261: l_hd_shipment_tbl Aso_Quote_Pub.Shipment_tbl_Type;
1262: l_ln_shipment_tbl Aso_Quote_Pub.Shipment_Tbl_Type;
1263: l_hd_payment_tbl Aso_Quote_Pub.Payment_Tbl_Type;
1264: l_line_price_adj_tbl Aso_Quote_Pub.Price_Adj_Tbl_Type;
1265: x_order_header_rec Aso_Order_Int.Order_Header_rec_type;
1266: x_order_line_tbl Aso_Order_Int.Order_Line_tbl_type;
1267: l_control_rec Aso_Order_Int.control_rec_type;
1268: