297:
298:
299: -- OM variables --
300:
301: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
302: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
303: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
304: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
305: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
298:
299: -- OM variables --
300:
301: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
302: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
303: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
304: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
305: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
306: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
299: -- OM variables --
300:
301: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
302: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
303: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
304: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
305: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
306: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
307: l_hdr_rec OE_Order_PUB.Header_Rec_Type;
300:
301: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
302: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
303: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
304: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
305: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
306: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
307: l_hdr_rec OE_Order_PUB.Header_Rec_Type;
308: l_line_rec OE_Order_PUB.Line_Rec_Type;
301: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
302: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
303: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
304: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
305: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
306: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
307: l_hdr_rec OE_Order_PUB.Header_Rec_Type;
308: l_line_rec OE_Order_PUB.Line_Rec_Type;
309: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
302: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
303: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
304: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
305: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
306: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
307: l_hdr_rec OE_Order_PUB.Header_Rec_Type;
308: l_line_rec OE_Order_PUB.Line_Rec_Type;
309: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
310: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
303: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
304: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
305: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
306: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
307: l_hdr_rec OE_Order_PUB.Header_Rec_Type;
308: l_line_rec OE_Order_PUB.Line_Rec_Type;
309: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
310: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
311: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
304: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
305: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
306: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
307: l_hdr_rec OE_Order_PUB.Header_Rec_Type;
308: l_line_rec OE_Order_PUB.Line_Rec_Type;
309: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
310: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
311: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
312: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
305: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
306: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
307: l_hdr_rec OE_Order_PUB.Header_Rec_Type;
308: l_line_rec OE_Order_PUB.Line_Rec_Type;
309: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
310: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
311: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
312: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
313: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
306: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
307: l_hdr_rec OE_Order_PUB.Header_Rec_Type;
308: l_line_rec OE_Order_PUB.Line_Rec_Type;
309: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
310: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
311: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
312: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
313: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
314: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
307: l_hdr_rec OE_Order_PUB.Header_Rec_Type;
308: l_line_rec OE_Order_PUB.Line_Rec_Type;
309: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
310: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
311: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
312: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
313: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
314: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
315: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
308: l_line_rec OE_Order_PUB.Line_Rec_Type;
309: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
310: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
311: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
312: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
313: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
314: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
315: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
316: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
309: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
310: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
311: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
312: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
313: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
314: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
315: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
316: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
317: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
310: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
311: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
312: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
313: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
314: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
315: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
316: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
317: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
318: l_action_request_tbl OE_Order_PUB.request_tbl_type;
311: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
312: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
313: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
314: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
315: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
316: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
317: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
318: l_action_request_tbl OE_Order_PUB.request_tbl_type;
319: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
312: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
313: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
314: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
315: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
316: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
317: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
318: l_action_request_tbl OE_Order_PUB.request_tbl_type;
319: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
320: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
313: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
314: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
315: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
316: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
317: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
318: l_action_request_tbl OE_Order_PUB.request_tbl_type;
319: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
320: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
321: l_hdr_payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
314: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
315: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
316: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
317: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
318: l_action_request_tbl OE_Order_PUB.request_tbl_type;
319: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
320: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
321: l_hdr_payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
322: l_line_payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
315: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
316: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
317: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
318: l_action_request_tbl OE_Order_PUB.request_tbl_type;
319: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
320: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
321: l_hdr_payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
322: l_line_payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
323: l_control_rec oe_globals.control_rec_type;
316: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
317: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
318: l_action_request_tbl OE_Order_PUB.request_tbl_type;
319: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
320: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
321: l_hdr_payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
322: l_line_payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
323: l_control_rec oe_globals.control_rec_type;
324: l_return_status Varchar2(30);
317: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
318: l_action_request_tbl OE_Order_PUB.request_tbl_type;
319: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
320: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
321: l_hdr_payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
322: l_line_payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
323: l_control_rec oe_globals.control_rec_type;
324: l_return_status Varchar2(30);
325: l_file_val Varchar2(30);
318: l_action_request_tbl OE_Order_PUB.request_tbl_type;
319: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
320: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
321: l_hdr_payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
322: l_line_payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
323: l_control_rec oe_globals.control_rec_type;
324: l_return_status Varchar2(30);
325: l_file_val Varchar2(30);
326: x_msg_count number;
415: , C_select_replenishments_REC.REPLENISHMENT_SO_LINE_ID);
416: END IF;
417:
418:
419: l_line_rec := OE_Order_PUB.G_MISS_LINE_REC;
420: l_line_rec.operation := oe_globals.G_OPR_UPDATE;
421:
422: l_line_rec.line_id :=
423: C_select_replenishments_REC.REPLENISHMENT_SO_LINE_ID;