796: l_msg_count NUMBER;
797: l_msg_data VARCHAR2(2000);
798: l_msg_index NUMBER;
799: l_dummy VARCHAR2(1);
800: l_header_rec Aso_Quote_Pub.Qte_Header_Rec_Type;
801: l_line_tbl Aso_Quote_Pub.Qte_Line_Tbl_Type;
802: l_Line_dtl_tbl Aso_Quote_Pub.Qte_Line_Dtl_Tbl_Type;
803: l_hd_shipment_rec Aso_Quote_Pub.Shipment_rec_Type;
804: l_hd_shipment_tbl Aso_Quote_Pub.Shipment_tbl_Type;
797: l_msg_data VARCHAR2(2000);
798: l_msg_index NUMBER;
799: l_dummy VARCHAR2(1);
800: l_header_rec Aso_Quote_Pub.Qte_Header_Rec_Type;
801: l_line_tbl Aso_Quote_Pub.Qte_Line_Tbl_Type;
802: l_Line_dtl_tbl Aso_Quote_Pub.Qte_Line_Dtl_Tbl_Type;
803: l_hd_shipment_rec Aso_Quote_Pub.Shipment_rec_Type;
804: l_hd_shipment_tbl Aso_Quote_Pub.Shipment_tbl_Type;
805: l_ln_shipment_tbl Aso_Quote_Pub.Shipment_Tbl_Type;
798: l_msg_index NUMBER;
799: l_dummy VARCHAR2(1);
800: l_header_rec Aso_Quote_Pub.Qte_Header_Rec_Type;
801: l_line_tbl Aso_Quote_Pub.Qte_Line_Tbl_Type;
802: l_Line_dtl_tbl Aso_Quote_Pub.Qte_Line_Dtl_Tbl_Type;
803: l_hd_shipment_rec Aso_Quote_Pub.Shipment_rec_Type;
804: l_hd_shipment_tbl Aso_Quote_Pub.Shipment_tbl_Type;
805: l_ln_shipment_tbl Aso_Quote_Pub.Shipment_Tbl_Type;
806: l_hd_payment_tbl Aso_Quote_Pub.Payment_Tbl_Type; -- added by cnemalik
799: l_dummy VARCHAR2(1);
800: l_header_rec Aso_Quote_Pub.Qte_Header_Rec_Type;
801: l_line_tbl Aso_Quote_Pub.Qte_Line_Tbl_Type;
802: l_Line_dtl_tbl Aso_Quote_Pub.Qte_Line_Dtl_Tbl_Type;
803: l_hd_shipment_rec Aso_Quote_Pub.Shipment_rec_Type;
804: l_hd_shipment_tbl Aso_Quote_Pub.Shipment_tbl_Type;
805: l_ln_shipment_tbl Aso_Quote_Pub.Shipment_Tbl_Type;
806: l_hd_payment_tbl Aso_Quote_Pub.Payment_Tbl_Type; -- added by cnemalik
807: l_line_price_adj_tbl Aso_Quote_Pub.Price_Adj_Tbl_Type;
800: l_header_rec Aso_Quote_Pub.Qte_Header_Rec_Type;
801: l_line_tbl Aso_Quote_Pub.Qte_Line_Tbl_Type;
802: l_Line_dtl_tbl Aso_Quote_Pub.Qte_Line_Dtl_Tbl_Type;
803: l_hd_shipment_rec Aso_Quote_Pub.Shipment_rec_Type;
804: l_hd_shipment_tbl Aso_Quote_Pub.Shipment_tbl_Type;
805: l_ln_shipment_tbl Aso_Quote_Pub.Shipment_Tbl_Type;
806: l_hd_payment_tbl Aso_Quote_Pub.Payment_Tbl_Type; -- added by cnemalik
807: l_line_price_adj_tbl Aso_Quote_Pub.Price_Adj_Tbl_Type;
808: x_order_header_rec Aso_Order_Int.Order_Header_rec_type;
801: l_line_tbl Aso_Quote_Pub.Qte_Line_Tbl_Type;
802: l_Line_dtl_tbl Aso_Quote_Pub.Qte_Line_Dtl_Tbl_Type;
803: l_hd_shipment_rec Aso_Quote_Pub.Shipment_rec_Type;
804: l_hd_shipment_tbl Aso_Quote_Pub.Shipment_tbl_Type;
805: l_ln_shipment_tbl Aso_Quote_Pub.Shipment_Tbl_Type;
806: l_hd_payment_tbl Aso_Quote_Pub.Payment_Tbl_Type; -- added by cnemalik
807: l_line_price_adj_tbl Aso_Quote_Pub.Price_Adj_Tbl_Type;
808: x_order_header_rec Aso_Order_Int.Order_Header_rec_type;
809: x_order_line_tbl Aso_Order_Int.Order_Line_tbl_type;
802: l_Line_dtl_tbl Aso_Quote_Pub.Qte_Line_Dtl_Tbl_Type;
803: l_hd_shipment_rec Aso_Quote_Pub.Shipment_rec_Type;
804: l_hd_shipment_tbl Aso_Quote_Pub.Shipment_tbl_Type;
805: l_ln_shipment_tbl Aso_Quote_Pub.Shipment_Tbl_Type;
806: l_hd_payment_tbl Aso_Quote_Pub.Payment_Tbl_Type; -- added by cnemalik
807: l_line_price_adj_tbl Aso_Quote_Pub.Price_Adj_Tbl_Type;
808: x_order_header_rec Aso_Order_Int.Order_Header_rec_type;
809: x_order_line_tbl Aso_Order_Int.Order_Line_tbl_type;
810: x_order_header_id NUMBER;
803: l_hd_shipment_rec Aso_Quote_Pub.Shipment_rec_Type;
804: l_hd_shipment_tbl Aso_Quote_Pub.Shipment_tbl_Type;
805: l_ln_shipment_tbl Aso_Quote_Pub.Shipment_Tbl_Type;
806: l_hd_payment_tbl Aso_Quote_Pub.Payment_Tbl_Type; -- added by cnemalik
807: l_line_price_adj_tbl Aso_Quote_Pub.Price_Adj_Tbl_Type;
808: x_order_header_rec Aso_Order_Int.Order_Header_rec_type;
809: x_order_line_tbl Aso_Order_Int.Order_Line_tbl_type;
810: x_order_header_id NUMBER;
811: l_control_rec Aso_Order_Int.control_rec_type;
1225: l_ret_code BOOLEAN;
1226: p_batch_prefix VARCHAR2(10) := 'DR';
1227: x_order_header_id NUMBER;
1228:
1229: l_header_rec Aso_Quote_Pub.Qte_Header_Rec_Type;
1230: l_line_tbl Aso_Quote_Pub.Qte_Line_Tbl_Type;
1231: l_Line_dtl_tbl Aso_Quote_Pub.Qte_Line_Dtl_Tbl_Type;
1232: l_hd_shipment_rec Aso_Quote_Pub.Shipment_rec_Type;
1233: l_hd_shipment_tbl Aso_Quote_Pub.Shipment_tbl_Type;
1226: p_batch_prefix VARCHAR2(10) := 'DR';
1227: x_order_header_id NUMBER;
1228:
1229: l_header_rec Aso_Quote_Pub.Qte_Header_Rec_Type;
1230: l_line_tbl Aso_Quote_Pub.Qte_Line_Tbl_Type;
1231: l_Line_dtl_tbl Aso_Quote_Pub.Qte_Line_Dtl_Tbl_Type;
1232: l_hd_shipment_rec Aso_Quote_Pub.Shipment_rec_Type;
1233: l_hd_shipment_tbl Aso_Quote_Pub.Shipment_tbl_Type;
1234: l_ln_shipment_tbl Aso_Quote_Pub.Shipment_Tbl_Type;
1227: x_order_header_id NUMBER;
1228:
1229: l_header_rec Aso_Quote_Pub.Qte_Header_Rec_Type;
1230: l_line_tbl Aso_Quote_Pub.Qte_Line_Tbl_Type;
1231: l_Line_dtl_tbl Aso_Quote_Pub.Qte_Line_Dtl_Tbl_Type;
1232: l_hd_shipment_rec Aso_Quote_Pub.Shipment_rec_Type;
1233: l_hd_shipment_tbl Aso_Quote_Pub.Shipment_tbl_Type;
1234: l_ln_shipment_tbl Aso_Quote_Pub.Shipment_Tbl_Type;
1235: l_hd_payment_tbl Aso_Quote_Pub.Payment_Tbl_Type;
1228:
1229: l_header_rec Aso_Quote_Pub.Qte_Header_Rec_Type;
1230: l_line_tbl Aso_Quote_Pub.Qte_Line_Tbl_Type;
1231: l_Line_dtl_tbl Aso_Quote_Pub.Qte_Line_Dtl_Tbl_Type;
1232: l_hd_shipment_rec Aso_Quote_Pub.Shipment_rec_Type;
1233: l_hd_shipment_tbl Aso_Quote_Pub.Shipment_tbl_Type;
1234: l_ln_shipment_tbl Aso_Quote_Pub.Shipment_Tbl_Type;
1235: l_hd_payment_tbl Aso_Quote_Pub.Payment_Tbl_Type;
1236: l_line_price_adj_tbl Aso_Quote_Pub.Price_Adj_Tbl_Type;
1229: l_header_rec Aso_Quote_Pub.Qte_Header_Rec_Type;
1230: l_line_tbl Aso_Quote_Pub.Qte_Line_Tbl_Type;
1231: l_Line_dtl_tbl Aso_Quote_Pub.Qte_Line_Dtl_Tbl_Type;
1232: l_hd_shipment_rec Aso_Quote_Pub.Shipment_rec_Type;
1233: l_hd_shipment_tbl Aso_Quote_Pub.Shipment_tbl_Type;
1234: l_ln_shipment_tbl Aso_Quote_Pub.Shipment_Tbl_Type;
1235: l_hd_payment_tbl Aso_Quote_Pub.Payment_Tbl_Type;
1236: l_line_price_adj_tbl Aso_Quote_Pub.Price_Adj_Tbl_Type;
1237: x_order_header_rec Aso_Order_Int.Order_Header_rec_type;
1230: l_line_tbl Aso_Quote_Pub.Qte_Line_Tbl_Type;
1231: l_Line_dtl_tbl Aso_Quote_Pub.Qte_Line_Dtl_Tbl_Type;
1232: l_hd_shipment_rec Aso_Quote_Pub.Shipment_rec_Type;
1233: l_hd_shipment_tbl Aso_Quote_Pub.Shipment_tbl_Type;
1234: l_ln_shipment_tbl Aso_Quote_Pub.Shipment_Tbl_Type;
1235: l_hd_payment_tbl Aso_Quote_Pub.Payment_Tbl_Type;
1236: l_line_price_adj_tbl Aso_Quote_Pub.Price_Adj_Tbl_Type;
1237: x_order_header_rec Aso_Order_Int.Order_Header_rec_type;
1238: x_order_line_tbl Aso_Order_Int.Order_Line_tbl_type;
1231: l_Line_dtl_tbl Aso_Quote_Pub.Qte_Line_Dtl_Tbl_Type;
1232: l_hd_shipment_rec Aso_Quote_Pub.Shipment_rec_Type;
1233: l_hd_shipment_tbl Aso_Quote_Pub.Shipment_tbl_Type;
1234: l_ln_shipment_tbl Aso_Quote_Pub.Shipment_Tbl_Type;
1235: l_hd_payment_tbl Aso_Quote_Pub.Payment_Tbl_Type;
1236: l_line_price_adj_tbl Aso_Quote_Pub.Price_Adj_Tbl_Type;
1237: x_order_header_rec Aso_Order_Int.Order_Header_rec_type;
1238: x_order_line_tbl Aso_Order_Int.Order_Line_tbl_type;
1239: l_control_rec Aso_Order_Int.control_rec_type;
1232: l_hd_shipment_rec Aso_Quote_Pub.Shipment_rec_Type;
1233: l_hd_shipment_tbl Aso_Quote_Pub.Shipment_tbl_Type;
1234: l_ln_shipment_tbl Aso_Quote_Pub.Shipment_Tbl_Type;
1235: l_hd_payment_tbl Aso_Quote_Pub.Payment_Tbl_Type;
1236: l_line_price_adj_tbl Aso_Quote_Pub.Price_Adj_Tbl_Type;
1237: x_order_header_rec Aso_Order_Int.Order_Header_rec_type;
1238: x_order_line_tbl Aso_Order_Int.Order_Line_tbl_type;
1239: l_control_rec Aso_Order_Int.control_rec_type;
1240: