3180: l_deliver_to_location_id1 number;
3181: l_intmed_ship_to_location_id number;
3182: l_intmed_ship_to_location_id1 number;
3183: l_location_status varchar2(30);
3184: l_line_rec OE_ORDER_PUB.line_rec_type;
3185: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
3186: l_control_rec OE_GLOBALS.control_rec_type;
3187: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
3188: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
3181: l_intmed_ship_to_location_id number;
3182: l_intmed_ship_to_location_id1 number;
3183: l_location_status varchar2(30);
3184: l_line_rec OE_ORDER_PUB.line_rec_type;
3185: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
3186: l_control_rec OE_GLOBALS.control_rec_type;
3187: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
3188: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
3189: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
3183: l_location_status varchar2(30);
3184: l_line_rec OE_ORDER_PUB.line_rec_type;
3185: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
3186: l_control_rec OE_GLOBALS.control_rec_type;
3187: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
3188: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
3189: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
3190: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3191: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3184: l_line_rec OE_ORDER_PUB.line_rec_type;
3185: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
3186: l_control_rec OE_GLOBALS.control_rec_type;
3187: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
3188: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
3189: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
3190: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3191: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3192: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3185: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
3186: l_control_rec OE_GLOBALS.control_rec_type;
3187: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
3188: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
3189: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
3190: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3191: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3192: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3193: l_action_request_out_tbl OE_Order_PUB.request_Tbl_type;
3186: l_control_rec OE_GLOBALS.control_rec_type;
3187: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
3188: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
3189: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
3190: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3191: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3192: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3193: l_action_request_out_tbl OE_Order_PUB.request_Tbl_type;
3194: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3187: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
3188: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
3189: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
3190: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3191: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3192: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3193: l_action_request_out_tbl OE_Order_PUB.request_Tbl_type;
3194: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3195: l_header_val_rec OE_Order_PUB.header_val_rec_type;
3188: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
3189: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
3190: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3191: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3192: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3193: l_action_request_out_tbl OE_Order_PUB.request_Tbl_type;
3194: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3195: l_header_val_rec OE_Order_PUB.header_val_rec_type;
3196: l_header_adj_val_tbl OE_Order_PUB.header_adj_val_tbl_type;
3189: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
3190: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3191: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3192: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3193: l_action_request_out_tbl OE_Order_PUB.request_Tbl_type;
3194: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3195: l_header_val_rec OE_Order_PUB.header_val_rec_type;
3196: l_header_adj_val_tbl OE_Order_PUB.header_adj_val_tbl_type;
3197: l_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_val_Tbl_Type;
3190: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3191: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3192: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3193: l_action_request_out_tbl OE_Order_PUB.request_Tbl_type;
3194: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3195: l_header_val_rec OE_Order_PUB.header_val_rec_type;
3196: l_header_adj_val_tbl OE_Order_PUB.header_adj_val_tbl_type;
3197: l_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_val_Tbl_Type;
3198: l_line_val_tbl OE_ORDER_PUB.Line_val_Tbl_Type;
3191: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3192: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3193: l_action_request_out_tbl OE_Order_PUB.request_Tbl_type;
3194: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3195: l_header_val_rec OE_Order_PUB.header_val_rec_type;
3196: l_header_adj_val_tbl OE_Order_PUB.header_adj_val_tbl_type;
3197: l_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_val_Tbl_Type;
3198: l_line_val_tbl OE_ORDER_PUB.Line_val_Tbl_Type;
3199: l_line_adj_val_tbl oe_order_pub.line_Adj_val_Tbl_Type;
3192: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3193: l_action_request_out_tbl OE_Order_PUB.request_Tbl_type;
3194: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3195: l_header_val_rec OE_Order_PUB.header_val_rec_type;
3196: l_header_adj_val_tbl OE_Order_PUB.header_adj_val_tbl_type;
3197: l_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_val_Tbl_Type;
3198: l_line_val_tbl OE_ORDER_PUB.Line_val_Tbl_Type;
3199: l_line_adj_val_tbl oe_order_pub.line_Adj_val_Tbl_Type;
3200: l_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_val_Tbl_Type;
3193: l_action_request_out_tbl OE_Order_PUB.request_Tbl_type;
3194: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3195: l_header_val_rec OE_Order_PUB.header_val_rec_type;
3196: l_header_adj_val_tbl OE_Order_PUB.header_adj_val_tbl_type;
3197: l_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_val_Tbl_Type;
3198: l_line_val_tbl OE_ORDER_PUB.Line_val_Tbl_Type;
3199: l_line_adj_val_tbl oe_order_pub.line_Adj_val_Tbl_Type;
3200: l_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_val_Tbl_Type;
3201: l_header_Scredit_val_tbl OE_Order_PUB.header_Scredit_val_Tbl_Type;
3194: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3195: l_header_val_rec OE_Order_PUB.header_val_rec_type;
3196: l_header_adj_val_tbl OE_Order_PUB.header_adj_val_tbl_type;
3197: l_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_val_Tbl_Type;
3198: l_line_val_tbl OE_ORDER_PUB.Line_val_Tbl_Type;
3199: l_line_adj_val_tbl oe_order_pub.line_Adj_val_Tbl_Type;
3200: l_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_val_Tbl_Type;
3201: l_header_Scredit_val_tbl OE_Order_PUB.header_Scredit_val_Tbl_Type;
3202: l_line_index NUMBER := 0;
3195: l_header_val_rec OE_Order_PUB.header_val_rec_type;
3196: l_header_adj_val_tbl OE_Order_PUB.header_adj_val_tbl_type;
3197: l_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_val_Tbl_Type;
3198: l_line_val_tbl OE_ORDER_PUB.Line_val_Tbl_Type;
3199: l_line_adj_val_tbl oe_order_pub.line_Adj_val_Tbl_Type;
3200: l_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_val_Tbl_Type;
3201: l_header_Scredit_val_tbl OE_Order_PUB.header_Scredit_val_Tbl_Type;
3202: l_line_index NUMBER := 0;
3203: l_summary varchar2(3000);
3196: l_header_adj_val_tbl OE_Order_PUB.header_adj_val_tbl_type;
3197: l_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_val_Tbl_Type;
3198: l_line_val_tbl OE_ORDER_PUB.Line_val_Tbl_Type;
3199: l_line_adj_val_tbl oe_order_pub.line_Adj_val_Tbl_Type;
3200: l_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_val_Tbl_Type;
3201: l_header_Scredit_val_tbl OE_Order_PUB.header_Scredit_val_Tbl_Type;
3202: l_line_index NUMBER := 0;
3203: l_summary varchar2(3000);
3204: l_details varchar2(3000);
3197: l_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_val_Tbl_Type;
3198: l_line_val_tbl OE_ORDER_PUB.Line_val_Tbl_Type;
3199: l_line_adj_val_tbl oe_order_pub.line_Adj_val_Tbl_Type;
3200: l_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_val_Tbl_Type;
3201: l_header_Scredit_val_tbl OE_Order_PUB.header_Scredit_val_Tbl_Type;
3202: l_line_index NUMBER := 0;
3203: l_summary varchar2(3000);
3204: l_details varchar2(3000);
3205: l_get_msg_count number;
3453: l_delivery_assignments_info WSH_DELIVERY_DETAILS_PKG.Delivery_assignments_rec_TYPE;
3454: dummy_rowid VARCHAR2(30);
3455: dummy_delivery_detail_id number;
3456: dummy_slid number;
3457: l_header_price_att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
3458: l_header_adj_assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
3459: l_header_adj_att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
3460: l_line_price_att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
3461: l_line_adj_assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
3454: dummy_rowid VARCHAR2(30);
3455: dummy_delivery_detail_id number;
3456: dummy_slid number;
3457: l_header_price_att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
3458: l_header_adj_assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
3459: l_header_adj_att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
3460: l_line_price_att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
3461: l_line_adj_assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
3462: l_line_adj_att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
3455: dummy_delivery_detail_id number;
3456: dummy_slid number;
3457: l_header_price_att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
3458: l_header_adj_assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
3459: l_header_adj_att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
3460: l_line_price_att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
3461: l_line_adj_assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
3462: l_line_adj_att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
3463:
3456: dummy_slid number;
3457: l_header_price_att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
3458: l_header_adj_assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
3459: l_header_adj_att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
3460: l_line_price_att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
3461: l_line_adj_assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
3462: l_line_adj_att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
3463:
3464: l_wf_source_header_id NUMBER;
3457: l_header_price_att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
3458: l_header_adj_assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
3459: l_header_adj_att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
3460: l_line_price_att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
3461: l_line_adj_assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
3462: l_line_adj_att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
3463:
3464: l_wf_source_header_id NUMBER;
3465: l_wf_source_code VARCHAR2(30);
3458: l_header_adj_assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
3459: l_header_adj_att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
3460: l_line_price_att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
3461: l_line_adj_assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
3462: l_line_adj_att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
3463:
3464: l_wf_source_header_id NUMBER;
3465: l_wf_source_code VARCHAR2(30);
3466: l_wf_order_number NUMBER;