30:
31: )
32: IS
33: l_return_status VARCHAR2(30);
34: l_line_rec OE_Order_Pub.Line_Rec_Type;
35: l_sales_order_id NUMBER;
36: l_msg_count NUMBER;
37: l_msg_data VARCHAR2(4000);
38: l_rsv_rec INV_RESERVATION_GLOBAL.mtl_reservation_rec_type;
73: l_ordered_date DATE;
74: -- Process Order arguments
75:
76: -- l_control_rec OE_GLOBALS.control_rec_type;
77: l_line_tbl OE_ORDER_PUB.line_tbl_type;
78: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
79: /*
80: l_header_rec OE_Order_PUB.Header_Rec_Type;
81: l_new_line_rec OE_Order_PUB.Line_Rec_Type := OE_Order_Pub.G_MISS_LINE_REC;
74: -- Process Order arguments
75:
76: -- l_control_rec OE_GLOBALS.control_rec_type;
77: l_line_tbl OE_ORDER_PUB.line_tbl_type;
78: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
79: /*
80: l_header_rec OE_Order_PUB.Header_Rec_Type;
81: l_new_line_rec OE_Order_PUB.Line_Rec_Type := OE_Order_Pub.G_MISS_LINE_REC;
82: l_new_line_tbl OE_Order_PUB.Line_Tbl_Type;
76: -- l_control_rec OE_GLOBALS.control_rec_type;
77: l_line_tbl OE_ORDER_PUB.line_tbl_type;
78: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
79: /*
80: l_header_rec OE_Order_PUB.Header_Rec_Type;
81: l_new_line_rec OE_Order_PUB.Line_Rec_Type := OE_Order_Pub.G_MISS_LINE_REC;
82: l_new_line_tbl OE_Order_PUB.Line_Tbl_Type;
83: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
84: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
77: l_line_tbl OE_ORDER_PUB.line_tbl_type;
78: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
79: /*
80: l_header_rec OE_Order_PUB.Header_Rec_Type;
81: l_new_line_rec OE_Order_PUB.Line_Rec_Type := OE_Order_Pub.G_MISS_LINE_REC;
82: l_new_line_tbl OE_Order_PUB.Line_Tbl_Type;
83: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
84: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
85: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
78: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
79: /*
80: l_header_rec OE_Order_PUB.Header_Rec_Type;
81: l_new_line_rec OE_Order_PUB.Line_Rec_Type := OE_Order_Pub.G_MISS_LINE_REC;
82: l_new_line_tbl OE_Order_PUB.Line_Tbl_Type;
83: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
84: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
85: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
86: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
79: /*
80: l_header_rec OE_Order_PUB.Header_Rec_Type;
81: l_new_line_rec OE_Order_PUB.Line_Rec_Type := OE_Order_Pub.G_MISS_LINE_REC;
82: l_new_line_tbl OE_Order_PUB.Line_Tbl_Type;
83: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
84: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
85: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
86: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
87: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
80: l_header_rec OE_Order_PUB.Header_Rec_Type;
81: l_new_line_rec OE_Order_PUB.Line_Rec_Type := OE_Order_Pub.G_MISS_LINE_REC;
82: l_new_line_tbl OE_Order_PUB.Line_Tbl_Type;
83: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
84: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
85: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
86: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
87: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
88: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
81: l_new_line_rec OE_Order_PUB.Line_Rec_Type := OE_Order_Pub.G_MISS_LINE_REC;
82: l_new_line_tbl OE_Order_PUB.Line_Tbl_Type;
83: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
84: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
85: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
86: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
87: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
88: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
89: l_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
82: l_new_line_tbl OE_Order_PUB.Line_Tbl_Type;
83: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
84: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
85: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
86: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
87: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
88: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
89: l_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
90: l_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
83: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
84: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
85: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
86: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
87: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
88: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
89: l_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
90: l_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
91: l_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
84: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
85: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
86: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
87: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
88: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
89: l_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
90: l_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
91: l_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
92: l_Line_Price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
85: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
86: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
87: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
88: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
89: l_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
90: l_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
91: l_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
92: l_Line_Price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
93: l_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
86: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
87: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
88: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
89: l_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
90: l_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
91: l_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
92: l_Line_Price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
93: l_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
94: l_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
87: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
88: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
89: l_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
90: l_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
91: l_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
92: l_Line_Price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
93: l_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
94: l_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
95: */
88: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
89: l_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
90: l_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
91: l_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
92: l_Line_Price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
93: l_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
94: l_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
95: */
96:
89: l_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
90: l_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
91: l_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
92: l_Line_Price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
93: l_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
94: l_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
95: */
96:
97: /* -- HW OPM BUG#:2536589 added variable to hold item_rec information
90: l_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
91: l_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
92: l_Line_Price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
93: l_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
94: l_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
95: */
96:
97: /* -- HW OPM BUG#:2536589 added variable to hold item_rec information
98: l_item_rec OE_ORDER_CACHE.item_rec_type;