168: j number := 1;
169:
170: /* Variables for Process Order */
171: l_api_version_number CONSTANT NUMBER := 1.0;
172: lv_action_rec OE_Order_PUB.Request_Rec_Type;
173: lv_action_req_tbl OE_Order_PUB.Request_Tbl_Type;
174: l_oe_header_rec oe_order_pub.header_rec_type := OE_ORDER_PUB.G_MISS_HEADER_REC;
175: l_oe_line_tbl oe_order_pub.line_tbl_type := OE_ORDER_PUB.G_MISS_LINE_TBL;
176: l_oe_line_rec oe_order_pub.line_rec_type := OE_ORDER_PUB.G_MISS_LINE_REC;
169:
170: /* Variables for Process Order */
171: l_api_version_number CONSTANT NUMBER := 1.0;
172: lv_action_rec OE_Order_PUB.Request_Rec_Type;
173: lv_action_req_tbl OE_Order_PUB.Request_Tbl_Type;
174: l_oe_header_rec oe_order_pub.header_rec_type := OE_ORDER_PUB.G_MISS_HEADER_REC;
175: l_oe_line_tbl oe_order_pub.line_tbl_type := OE_ORDER_PUB.G_MISS_LINE_TBL;
176: l_oe_line_rec oe_order_pub.line_rec_type := OE_ORDER_PUB.G_MISS_LINE_REC;
177:
170: /* Variables for Process Order */
171: l_api_version_number CONSTANT NUMBER := 1.0;
172: lv_action_rec OE_Order_PUB.Request_Rec_Type;
173: lv_action_req_tbl OE_Order_PUB.Request_Tbl_Type;
174: l_oe_header_rec oe_order_pub.header_rec_type := OE_ORDER_PUB.G_MISS_HEADER_REC;
175: l_oe_line_tbl oe_order_pub.line_tbl_type := OE_ORDER_PUB.G_MISS_LINE_TBL;
176: l_oe_line_rec oe_order_pub.line_rec_type := OE_ORDER_PUB.G_MISS_LINE_REC;
177:
178: -- OUT variables
171: l_api_version_number CONSTANT NUMBER := 1.0;
172: lv_action_rec OE_Order_PUB.Request_Rec_Type;
173: lv_action_req_tbl OE_Order_PUB.Request_Tbl_Type;
174: l_oe_header_rec oe_order_pub.header_rec_type := OE_ORDER_PUB.G_MISS_HEADER_REC;
175: l_oe_line_tbl oe_order_pub.line_tbl_type := OE_ORDER_PUB.G_MISS_LINE_TBL;
176: l_oe_line_rec oe_order_pub.line_rec_type := OE_ORDER_PUB.G_MISS_LINE_REC;
177:
178: -- OUT variables
179: l_header_rec OE_Order_PUB.Header_Rec_Type;
172: lv_action_rec OE_Order_PUB.Request_Rec_Type;
173: lv_action_req_tbl OE_Order_PUB.Request_Tbl_Type;
174: l_oe_header_rec oe_order_pub.header_rec_type := OE_ORDER_PUB.G_MISS_HEADER_REC;
175: l_oe_line_tbl oe_order_pub.line_tbl_type := OE_ORDER_PUB.G_MISS_LINE_TBL;
176: l_oe_line_rec oe_order_pub.line_rec_type := OE_ORDER_PUB.G_MISS_LINE_REC;
177:
178: -- OUT variables
179: l_header_rec OE_Order_PUB.Header_Rec_Type;
180: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
175: l_oe_line_tbl oe_order_pub.line_tbl_type := OE_ORDER_PUB.G_MISS_LINE_TBL;
176: l_oe_line_rec oe_order_pub.line_rec_type := OE_ORDER_PUB.G_MISS_LINE_REC;
177:
178: -- OUT variables
179: l_header_rec OE_Order_PUB.Header_Rec_Type;
180: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
181: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
182: l_Header_Adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
183: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
176: l_oe_line_rec oe_order_pub.line_rec_type := OE_ORDER_PUB.G_MISS_LINE_REC;
177:
178: -- OUT variables
179: l_header_rec OE_Order_PUB.Header_Rec_Type;
180: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
181: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
182: l_Header_Adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
183: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
184: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
177:
178: -- OUT variables
179: l_header_rec OE_Order_PUB.Header_Rec_Type;
180: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
181: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
182: l_Header_Adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
183: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
184: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
185: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
178: -- OUT variables
179: l_header_rec OE_Order_PUB.Header_Rec_Type;
180: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
181: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
182: l_Header_Adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
183: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
184: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
185: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
186: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
179: l_header_rec OE_Order_PUB.Header_Rec_Type;
180: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
181: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
182: l_Header_Adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
183: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
184: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
185: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
186: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
187: l_Header_Scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
180: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
181: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
182: l_Header_Adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
183: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
184: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
185: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
186: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
187: l_Header_Scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
188: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
181: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
182: l_Header_Adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
183: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
184: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
185: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
186: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
187: l_Header_Scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
188: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
189: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
182: l_Header_Adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
183: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
184: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
185: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
186: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
187: l_Header_Scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
188: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
189: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
190: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
183: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
184: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
185: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
186: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
187: l_Header_Scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
188: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
189: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
190: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
191: l_Line_Adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
184: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
185: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
186: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
187: l_Header_Scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
188: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
189: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
190: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
191: l_Line_Adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
192: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
185: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
186: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
187: l_Header_Scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
188: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
189: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
190: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
191: l_Line_Adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
192: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
193: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
186: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
187: l_Header_Scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
188: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
189: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
190: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
191: l_Line_Adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
192: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
193: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
194: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
187: l_Header_Scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
188: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
189: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
190: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
191: l_Line_Adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
192: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
193: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
194: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
195: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
188: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
189: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
190: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
191: l_Line_Adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
192: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
193: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
194: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
195: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
196: l_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
189: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
190: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
191: l_Line_Adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
192: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
193: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
194: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
195: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
196: l_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
197: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
190: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
191: l_Line_Adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
192: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
193: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
194: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
195: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
196: l_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
197: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
198: l_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
191: l_Line_Adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
192: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
193: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
194: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
195: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
196: l_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
197: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
198: l_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
199: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
192: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
193: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
194: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
195: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
196: l_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
197: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
198: l_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
199: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
200:
193: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
194: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
195: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
196: l_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
197: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
198: l_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
199: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
200:
201:
194: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
195: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
196: l_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
197: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
198: l_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
199: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
200:
201:
202: l_order_number number := 0;
195: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
196: l_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
197: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
198: l_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
199: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
200:
201:
202: l_order_number number := 0;
203: l_header_id number;
409:
410: /********* Process Order ********************************/
411: -- SETTING UP THE HEADER RECORD
412:
413: l_oe_header_rec := OE_ORDER_PUB.G_MISS_HEADER_REC;
414: l_oe_line_rec := OE_ORDER_PUB.G_MISS_LINE_REC;
415:
416: /* For Creating ISO */
417: log_message('DRP_REQ_LOAD :'||DRP_REQ_LOAD);
410: /********* Process Order ********************************/
411: -- SETTING UP THE HEADER RECORD
412:
413: l_oe_header_rec := OE_ORDER_PUB.G_MISS_HEADER_REC;
414: l_oe_line_rec := OE_ORDER_PUB.G_MISS_LINE_REC;
415:
416: /* For Creating ISO */
417: log_message('DRP_REQ_LOAD :'||DRP_REQ_LOAD);
418: log_message('l_org_trans_rel_cur.load_type :'||l_org_trans_rel_cur.load_type);
500:
501: l_oe_line_tbl(j) := l_oe_line_rec;
502: lv_action_req_Tbl(j) := lv_action_rec;
503: --Add Process_order
504: OE_Order_PUB.Process_Order(
505: -- IN variables
506: p_api_version_number => 1.0,
507: p_header_rec => l_oe_header_rec,
508: p_line_tbl => l_oe_line_tbl,