176: j number := 1;
177:
178: /* Variables for Process Order */
179: l_api_version_number CONSTANT NUMBER := 1.0;
180: lv_action_rec OE_Order_PUB.Request_Rec_Type;
181: lv_action_req_tbl OE_Order_PUB.Request_Tbl_Type;
182: l_oe_header_rec oe_order_pub.header_rec_type := OE_ORDER_PUB.G_MISS_HEADER_REC;
183: l_oe_line_tbl oe_order_pub.line_tbl_type := OE_ORDER_PUB.G_MISS_LINE_TBL;
184: l_oe_line_rec oe_order_pub.line_rec_type := OE_ORDER_PUB.G_MISS_LINE_REC;
177:
178: /* Variables for Process Order */
179: l_api_version_number CONSTANT NUMBER := 1.0;
180: lv_action_rec OE_Order_PUB.Request_Rec_Type;
181: lv_action_req_tbl OE_Order_PUB.Request_Tbl_Type;
182: l_oe_header_rec oe_order_pub.header_rec_type := OE_ORDER_PUB.G_MISS_HEADER_REC;
183: l_oe_line_tbl oe_order_pub.line_tbl_type := OE_ORDER_PUB.G_MISS_LINE_TBL;
184: l_oe_line_rec oe_order_pub.line_rec_type := OE_ORDER_PUB.G_MISS_LINE_REC;
185:
178: /* Variables for Process Order */
179: l_api_version_number CONSTANT NUMBER := 1.0;
180: lv_action_rec OE_Order_PUB.Request_Rec_Type;
181: lv_action_req_tbl OE_Order_PUB.Request_Tbl_Type;
182: l_oe_header_rec oe_order_pub.header_rec_type := OE_ORDER_PUB.G_MISS_HEADER_REC;
183: l_oe_line_tbl oe_order_pub.line_tbl_type := OE_ORDER_PUB.G_MISS_LINE_TBL;
184: l_oe_line_rec oe_order_pub.line_rec_type := OE_ORDER_PUB.G_MISS_LINE_REC;
185:
186: -- OUT variables
179: l_api_version_number CONSTANT NUMBER := 1.0;
180: lv_action_rec OE_Order_PUB.Request_Rec_Type;
181: lv_action_req_tbl OE_Order_PUB.Request_Tbl_Type;
182: l_oe_header_rec oe_order_pub.header_rec_type := OE_ORDER_PUB.G_MISS_HEADER_REC;
183: l_oe_line_tbl oe_order_pub.line_tbl_type := OE_ORDER_PUB.G_MISS_LINE_TBL;
184: l_oe_line_rec oe_order_pub.line_rec_type := OE_ORDER_PUB.G_MISS_LINE_REC;
185:
186: -- OUT variables
187: l_header_rec OE_Order_PUB.Header_Rec_Type;
180: lv_action_rec OE_Order_PUB.Request_Rec_Type;
181: lv_action_req_tbl OE_Order_PUB.Request_Tbl_Type;
182: l_oe_header_rec oe_order_pub.header_rec_type := OE_ORDER_PUB.G_MISS_HEADER_REC;
183: l_oe_line_tbl oe_order_pub.line_tbl_type := OE_ORDER_PUB.G_MISS_LINE_TBL;
184: l_oe_line_rec oe_order_pub.line_rec_type := OE_ORDER_PUB.G_MISS_LINE_REC;
185:
186: -- OUT variables
187: l_header_rec OE_Order_PUB.Header_Rec_Type;
188: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
183: l_oe_line_tbl oe_order_pub.line_tbl_type := OE_ORDER_PUB.G_MISS_LINE_TBL;
184: l_oe_line_rec oe_order_pub.line_rec_type := OE_ORDER_PUB.G_MISS_LINE_REC;
185:
186: -- OUT variables
187: l_header_rec OE_Order_PUB.Header_Rec_Type;
188: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
189: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
190: l_Header_Adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
191: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
184: l_oe_line_rec oe_order_pub.line_rec_type := OE_ORDER_PUB.G_MISS_LINE_REC;
185:
186: -- OUT variables
187: l_header_rec OE_Order_PUB.Header_Rec_Type;
188: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
189: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
190: l_Header_Adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
191: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
192: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
185:
186: -- OUT variables
187: l_header_rec OE_Order_PUB.Header_Rec_Type;
188: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
189: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
190: l_Header_Adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
191: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
192: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
193: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
186: -- OUT variables
187: l_header_rec OE_Order_PUB.Header_Rec_Type;
188: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
189: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
190: l_Header_Adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
191: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
192: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
193: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
194: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
187: l_header_rec OE_Order_PUB.Header_Rec_Type;
188: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
189: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
190: l_Header_Adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
191: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
192: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
193: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
194: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
195: l_Header_Scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
188: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
189: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
190: l_Header_Adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
191: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
192: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
193: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
194: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
195: l_Header_Scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
196: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
189: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
190: l_Header_Adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
191: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
192: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
193: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
194: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
195: l_Header_Scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
196: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
197: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
190: l_Header_Adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
191: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
192: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
193: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
194: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
195: l_Header_Scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
196: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
197: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
198: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
191: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
192: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
193: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
194: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
195: l_Header_Scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
196: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
197: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
198: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
199: l_Line_Adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
192: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
193: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
194: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
195: l_Header_Scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
196: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
197: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
198: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
199: l_Line_Adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
200: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
193: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
194: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
195: l_Header_Scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
196: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
197: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
198: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
199: l_Line_Adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
200: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
201: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
194: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
195: l_Header_Scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
196: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
197: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
198: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
199: l_Line_Adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
200: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
201: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
202: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
195: l_Header_Scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
196: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
197: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
198: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
199: l_Line_Adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
200: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
201: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
202: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
203: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
196: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
197: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
198: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
199: l_Line_Adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
200: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
201: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
202: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
203: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
204: l_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
197: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
198: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
199: l_Line_Adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
200: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
201: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
202: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
203: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
204: l_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
205: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
198: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
199: l_Line_Adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
200: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
201: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
202: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
203: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
204: l_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
205: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
206: l_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
199: l_Line_Adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
200: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
201: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
202: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
203: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
204: l_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
205: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
206: l_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
207: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
200: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
201: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
202: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
203: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
204: l_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
205: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
206: l_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
207: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
208:
201: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
202: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
203: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
204: l_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
205: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
206: l_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
207: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
208:
209:
202: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
203: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
204: l_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
205: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
206: l_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
207: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
208:
209:
210: l_order_number number := 0;
203: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
204: l_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
205: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
206: l_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
207: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
208:
209:
210: l_order_number number := 0;
211: l_header_id number;
421:
422: /********* Process Order ********************************/
423: -- SETTING UP THE HEADER RECORD
424:
425: l_oe_header_rec := OE_ORDER_PUB.G_MISS_HEADER_REC;
426: l_oe_line_rec := OE_ORDER_PUB.G_MISS_LINE_REC;
427:
428: /* For Creating ISO */
429: log_message('DRP_REQ_LOAD :'||DRP_REQ_LOAD);
422: /********* Process Order ********************************/
423: -- SETTING UP THE HEADER RECORD
424:
425: l_oe_header_rec := OE_ORDER_PUB.G_MISS_HEADER_REC;
426: l_oe_line_rec := OE_ORDER_PUB.G_MISS_LINE_REC;
427:
428: /* For Creating ISO */
429: log_message('DRP_REQ_LOAD :'||DRP_REQ_LOAD);
430: log_message('l_org_trans_rel_cur.load_type :'||l_org_trans_rel_cur.load_type);
520:
521: l_oe_header_rec.transactional_curr_code := l_currency_code;
522:
523: --Add Process_order
524: OE_Order_PUB.Process_Order(
525: -- IN variables
526: p_api_version_number => 1.0,
527: p_header_rec => l_oe_header_rec,
528: p_line_tbl => l_oe_line_tbl,