2868: l_deliver_to_location_id1 number;
2869: l_intmed_ship_to_location_id number;
2870: l_intmed_ship_to_location_id1 number;
2871: l_location_status varchar2(30);
2872: l_line_rec OE_ORDER_PUB.line_rec_type;
2873: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2874: l_control_rec OE_GLOBALS.control_rec_type;
2875: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
2876: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
2869: l_intmed_ship_to_location_id number;
2870: l_intmed_ship_to_location_id1 number;
2871: l_location_status varchar2(30);
2872: l_line_rec OE_ORDER_PUB.line_rec_type;
2873: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2874: l_control_rec OE_GLOBALS.control_rec_type;
2875: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
2876: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
2877: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
2871: l_location_status varchar2(30);
2872: l_line_rec OE_ORDER_PUB.line_rec_type;
2873: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2874: l_control_rec OE_GLOBALS.control_rec_type;
2875: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
2876: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
2877: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
2878: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2879: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2872: l_line_rec OE_ORDER_PUB.line_rec_type;
2873: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2874: l_control_rec OE_GLOBALS.control_rec_type;
2875: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
2876: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
2877: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
2878: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2879: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2880: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2873: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2874: l_control_rec OE_GLOBALS.control_rec_type;
2875: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
2876: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
2877: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
2878: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2879: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2880: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2881: l_action_request_out_tbl OE_Order_PUB.request_Tbl_type;
2874: l_control_rec OE_GLOBALS.control_rec_type;
2875: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
2876: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
2877: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
2878: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2879: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2880: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2881: l_action_request_out_tbl OE_Order_PUB.request_Tbl_type;
2882: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2875: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
2876: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
2877: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
2878: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2879: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2880: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2881: l_action_request_out_tbl OE_Order_PUB.request_Tbl_type;
2882: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2883: l_header_val_rec OE_Order_PUB.header_val_rec_type;
2876: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
2877: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
2878: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2879: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2880: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2881: l_action_request_out_tbl OE_Order_PUB.request_Tbl_type;
2882: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2883: l_header_val_rec OE_Order_PUB.header_val_rec_type;
2884: l_header_adj_val_tbl OE_Order_PUB.header_adj_val_tbl_type;
2877: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
2878: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2879: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2880: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2881: l_action_request_out_tbl OE_Order_PUB.request_Tbl_type;
2882: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2883: l_header_val_rec OE_Order_PUB.header_val_rec_type;
2884: l_header_adj_val_tbl OE_Order_PUB.header_adj_val_tbl_type;
2885: l_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_val_Tbl_Type;
2878: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2879: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2880: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2881: l_action_request_out_tbl OE_Order_PUB.request_Tbl_type;
2882: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2883: l_header_val_rec OE_Order_PUB.header_val_rec_type;
2884: l_header_adj_val_tbl OE_Order_PUB.header_adj_val_tbl_type;
2885: l_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_val_Tbl_Type;
2886: l_line_val_tbl OE_ORDER_PUB.Line_val_Tbl_Type;
2879: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2880: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2881: l_action_request_out_tbl OE_Order_PUB.request_Tbl_type;
2882: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2883: l_header_val_rec OE_Order_PUB.header_val_rec_type;
2884: l_header_adj_val_tbl OE_Order_PUB.header_adj_val_tbl_type;
2885: l_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_val_Tbl_Type;
2886: l_line_val_tbl OE_ORDER_PUB.Line_val_Tbl_Type;
2887: l_line_adj_val_tbl oe_order_pub.line_Adj_val_Tbl_Type;
2880: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2881: l_action_request_out_tbl OE_Order_PUB.request_Tbl_type;
2882: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2883: l_header_val_rec OE_Order_PUB.header_val_rec_type;
2884: l_header_adj_val_tbl OE_Order_PUB.header_adj_val_tbl_type;
2885: l_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_val_Tbl_Type;
2886: l_line_val_tbl OE_ORDER_PUB.Line_val_Tbl_Type;
2887: l_line_adj_val_tbl oe_order_pub.line_Adj_val_Tbl_Type;
2888: l_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_val_Tbl_Type;
2881: l_action_request_out_tbl OE_Order_PUB.request_Tbl_type;
2882: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2883: l_header_val_rec OE_Order_PUB.header_val_rec_type;
2884: l_header_adj_val_tbl OE_Order_PUB.header_adj_val_tbl_type;
2885: l_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_val_Tbl_Type;
2886: l_line_val_tbl OE_ORDER_PUB.Line_val_Tbl_Type;
2887: l_line_adj_val_tbl oe_order_pub.line_Adj_val_Tbl_Type;
2888: l_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_val_Tbl_Type;
2889: l_header_Scredit_val_tbl OE_Order_PUB.header_Scredit_val_Tbl_Type;
2882: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2883: l_header_val_rec OE_Order_PUB.header_val_rec_type;
2884: l_header_adj_val_tbl OE_Order_PUB.header_adj_val_tbl_type;
2885: l_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_val_Tbl_Type;
2886: l_line_val_tbl OE_ORDER_PUB.Line_val_Tbl_Type;
2887: l_line_adj_val_tbl oe_order_pub.line_Adj_val_Tbl_Type;
2888: l_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_val_Tbl_Type;
2889: l_header_Scredit_val_tbl OE_Order_PUB.header_Scredit_val_Tbl_Type;
2890: l_line_index NUMBER := 0;
2883: l_header_val_rec OE_Order_PUB.header_val_rec_type;
2884: l_header_adj_val_tbl OE_Order_PUB.header_adj_val_tbl_type;
2885: l_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_val_Tbl_Type;
2886: l_line_val_tbl OE_ORDER_PUB.Line_val_Tbl_Type;
2887: l_line_adj_val_tbl oe_order_pub.line_Adj_val_Tbl_Type;
2888: l_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_val_Tbl_Type;
2889: l_header_Scredit_val_tbl OE_Order_PUB.header_Scredit_val_Tbl_Type;
2890: l_line_index NUMBER := 0;
2891: l_summary varchar2(3000);
2884: l_header_adj_val_tbl OE_Order_PUB.header_adj_val_tbl_type;
2885: l_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_val_Tbl_Type;
2886: l_line_val_tbl OE_ORDER_PUB.Line_val_Tbl_Type;
2887: l_line_adj_val_tbl oe_order_pub.line_Adj_val_Tbl_Type;
2888: l_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_val_Tbl_Type;
2889: l_header_Scredit_val_tbl OE_Order_PUB.header_Scredit_val_Tbl_Type;
2890: l_line_index NUMBER := 0;
2891: l_summary varchar2(3000);
2892: l_details varchar2(3000);
2885: l_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_val_Tbl_Type;
2886: l_line_val_tbl OE_ORDER_PUB.Line_val_Tbl_Type;
2887: l_line_adj_val_tbl oe_order_pub.line_Adj_val_Tbl_Type;
2888: l_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_val_Tbl_Type;
2889: l_header_Scredit_val_tbl OE_Order_PUB.header_Scredit_val_Tbl_Type;
2890: l_line_index NUMBER := 0;
2891: l_summary varchar2(3000);
2892: l_details varchar2(3000);
2893: l_get_msg_count number;
3141: l_delivery_assignments_info WSH_DELIVERY_DETAILS_PKG.Delivery_assignments_rec_TYPE;
3142: dummy_rowid VARCHAR2(30);
3143: dummy_delivery_detail_id number;
3144: dummy_slid number;
3145: l_header_price_att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
3146: l_header_adj_assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
3147: l_header_adj_att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
3148: l_line_price_att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
3149: l_line_adj_assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
3142: dummy_rowid VARCHAR2(30);
3143: dummy_delivery_detail_id number;
3144: dummy_slid number;
3145: l_header_price_att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
3146: l_header_adj_assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
3147: l_header_adj_att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
3148: l_line_price_att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
3149: l_line_adj_assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
3150: l_line_adj_att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
3143: dummy_delivery_detail_id number;
3144: dummy_slid number;
3145: l_header_price_att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
3146: l_header_adj_assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
3147: l_header_adj_att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
3148: l_line_price_att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
3149: l_line_adj_assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
3150: l_line_adj_att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
3151:
3144: dummy_slid number;
3145: l_header_price_att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
3146: l_header_adj_assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
3147: l_header_adj_att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
3148: l_line_price_att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
3149: l_line_adj_assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
3150: l_line_adj_att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
3151:
3152: l_wf_source_header_id NUMBER;
3145: l_header_price_att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
3146: l_header_adj_assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
3147: l_header_adj_att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
3148: l_line_price_att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
3149: l_line_adj_assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
3150: l_line_adj_att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
3151:
3152: l_wf_source_header_id NUMBER;
3153: l_wf_source_code VARCHAR2(30);
3146: l_header_adj_assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
3147: l_header_adj_att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
3148: l_line_price_att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
3149: l_line_adj_assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
3150: l_line_adj_att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
3151:
3152: l_wf_source_header_id NUMBER;
3153: l_wf_source_code VARCHAR2(30);
3154: l_wf_order_number NUMBER;