eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PV_ORDER_MGMT_PVT dependencies on OE_ORDER_PUB

Line 228: l_header_rec OE_ORDER_PUB.Header_Rec_Type;

224: l_api_version_number CONSTANT NUMBER := 1.0;
225: l_api_name CONSTANT VARCHAR2(30) := 'process_order';
226: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
227:
228: l_header_rec OE_ORDER_PUB.Header_Rec_Type;
229: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
230:
231: --kvattiku Aug 08, 05 Added new variables to take care of the NOCOPY related changes (bug # 4445205)
232: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;

Line 229: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

225: l_api_name CONSTANT VARCHAR2(30) := 'process_order';
226: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
227:
228: l_header_rec OE_ORDER_PUB.Header_Rec_Type;
229: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
230:
231: --kvattiku Aug 08, 05 Added new variables to take care of the NOCOPY related changes (bug # 4445205)
232: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
233: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;

Line 232: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;

228: l_header_rec OE_ORDER_PUB.Header_Rec_Type;
229: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
230:
231: --kvattiku Aug 08, 05 Added new variables to take care of the NOCOPY related changes (bug # 4445205)
232: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
233: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
234:
235:
236: l_transaction_type_id NUMBER;

Line 233: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;

229: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
230:
231: --kvattiku Aug 08, 05 Added new variables to take care of the NOCOPY related changes (bug # 4445205)
232: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
233: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
234:
235:
236: l_transaction_type_id NUMBER;
237: l_bill_to_site_use_id NUMBER;

Line 251: x_header_val_rec OE_ORDER_PUB.Header_Val_Rec_Type;

247: l_msg_data varchar2(200);
248: l_return_status VARCHAR2(1);
249:
250:
251: x_header_val_rec OE_ORDER_PUB.Header_Val_Rec_Type;
252: x_Header_Adj_tbl OE_ORDER_PUB. Header_Adj_Tbl_Type;
253: x_Header_Adj_val_tbl OE_ORDER_PUB.Header_Adj_Val_Tbl_Type;
254: x_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
255: x_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;

Line 252: x_Header_Adj_tbl OE_ORDER_PUB. Header_Adj_Tbl_Type;

248: l_return_status VARCHAR2(1);
249:
250:
251: x_header_val_rec OE_ORDER_PUB.Header_Val_Rec_Type;
252: x_Header_Adj_tbl OE_ORDER_PUB. Header_Adj_Tbl_Type;
253: x_Header_Adj_val_tbl OE_ORDER_PUB.Header_Adj_Val_Tbl_Type;
254: x_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
255: x_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
256: x_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;

Line 253: x_Header_Adj_val_tbl OE_ORDER_PUB.Header_Adj_Val_Tbl_Type;

249:
250:
251: x_header_val_rec OE_ORDER_PUB.Header_Val_Rec_Type;
252: x_Header_Adj_tbl OE_ORDER_PUB. Header_Adj_Tbl_Type;
253: x_Header_Adj_val_tbl OE_ORDER_PUB.Header_Adj_Val_Tbl_Type;
254: x_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
255: x_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
256: x_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
257: x_Header_Scredit_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type;

Line 254: x_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;

250:
251: x_header_val_rec OE_ORDER_PUB.Header_Val_Rec_Type;
252: x_Header_Adj_tbl OE_ORDER_PUB. Header_Adj_Tbl_Type;
253: x_Header_Adj_val_tbl OE_ORDER_PUB.Header_Adj_Val_Tbl_Type;
254: x_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
255: x_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
256: x_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
257: x_Header_Scredit_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type;
258: x_Header_Scredit_val_tbl OE_ORDER_PUB.Header_Scredit_Val_Tbl_Type;

Line 255: x_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;

251: x_header_val_rec OE_ORDER_PUB.Header_Val_Rec_Type;
252: x_Header_Adj_tbl OE_ORDER_PUB. Header_Adj_Tbl_Type;
253: x_Header_Adj_val_tbl OE_ORDER_PUB.Header_Adj_Val_Tbl_Type;
254: x_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
255: x_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
256: x_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
257: x_Header_Scredit_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type;
258: x_Header_Scredit_val_tbl OE_ORDER_PUB.Header_Scredit_Val_Tbl_Type;
259: x_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

Line 256: x_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;

252: x_Header_Adj_tbl OE_ORDER_PUB. Header_Adj_Tbl_Type;
253: x_Header_Adj_val_tbl OE_ORDER_PUB.Header_Adj_Val_Tbl_Type;
254: x_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
255: x_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
256: x_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
257: x_Header_Scredit_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type;
258: x_Header_Scredit_val_tbl OE_ORDER_PUB.Header_Scredit_Val_Tbl_Type;
259: x_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
260: x_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;

Line 257: x_Header_Scredit_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type;

253: x_Header_Adj_val_tbl OE_ORDER_PUB.Header_Adj_Val_Tbl_Type;
254: x_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
255: x_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
256: x_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
257: x_Header_Scredit_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type;
258: x_Header_Scredit_val_tbl OE_ORDER_PUB.Header_Scredit_Val_Tbl_Type;
259: x_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
260: x_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;
261: x_Line_Adj_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;

Line 258: x_Header_Scredit_val_tbl OE_ORDER_PUB.Header_Scredit_Val_Tbl_Type;

254: x_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
255: x_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
256: x_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
257: x_Header_Scredit_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type;
258: x_Header_Scredit_val_tbl OE_ORDER_PUB.Header_Scredit_Val_Tbl_Type;
259: x_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
260: x_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;
261: x_Line_Adj_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
262: x_Line_Adj_val_tbl OE_ORDER_PUB.Line_Adj_Val_Tbl_Type;

Line 259: x_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

255: x_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
256: x_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
257: x_Header_Scredit_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type;
258: x_Header_Scredit_val_tbl OE_ORDER_PUB.Header_Scredit_Val_Tbl_Type;
259: x_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
260: x_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;
261: x_Line_Adj_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
262: x_Line_Adj_val_tbl OE_ORDER_PUB.Line_Adj_Val_Tbl_Type;
263: x_Line_price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;

Line 260: x_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;

256: x_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
257: x_Header_Scredit_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type;
258: x_Header_Scredit_val_tbl OE_ORDER_PUB.Header_Scredit_Val_Tbl_Type;
259: x_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
260: x_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;
261: x_Line_Adj_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
262: x_Line_Adj_val_tbl OE_ORDER_PUB.Line_Adj_Val_Tbl_Type;
263: x_Line_price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
264: x_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;

Line 261: x_Line_Adj_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;

257: x_Header_Scredit_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type;
258: x_Header_Scredit_val_tbl OE_ORDER_PUB.Header_Scredit_Val_Tbl_Type;
259: x_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
260: x_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;
261: x_Line_Adj_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
262: x_Line_Adj_val_tbl OE_ORDER_PUB.Line_Adj_Val_Tbl_Type;
263: x_Line_price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
264: x_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
265: x_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;

Line 262: x_Line_Adj_val_tbl OE_ORDER_PUB.Line_Adj_Val_Tbl_Type;

258: x_Header_Scredit_val_tbl OE_ORDER_PUB.Header_Scredit_Val_Tbl_Type;
259: x_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
260: x_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;
261: x_Line_Adj_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
262: x_Line_Adj_val_tbl OE_ORDER_PUB.Line_Adj_Val_Tbl_Type;
263: x_Line_price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
264: x_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
265: x_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
266: x_Line_Scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type;

Line 263: x_Line_price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;

259: x_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
260: x_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;
261: x_Line_Adj_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
262: x_Line_Adj_val_tbl OE_ORDER_PUB.Line_Adj_Val_Tbl_Type;
263: x_Line_price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
264: x_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
265: x_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
266: x_Line_Scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type;
267: x_Line_Scredit_val_tbl OE_ORDER_PUB.Line_Scredit_Val_Tbl_Type;

Line 264: x_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;

260: x_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;
261: x_Line_Adj_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
262: x_Line_Adj_val_tbl OE_ORDER_PUB.Line_Adj_Val_Tbl_Type;
263: x_Line_price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
264: x_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
265: x_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
266: x_Line_Scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type;
267: x_Line_Scredit_val_tbl OE_ORDER_PUB.Line_Scredit_Val_Tbl_Type;
268: x_Lot_Serial_tbl OE_ORDER_PUB.Lot_Serial_Tbl_Type;

Line 265: x_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;

261: x_Line_Adj_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
262: x_Line_Adj_val_tbl OE_ORDER_PUB.Line_Adj_Val_Tbl_Type;
263: x_Line_price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
264: x_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
265: x_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
266: x_Line_Scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type;
267: x_Line_Scredit_val_tbl OE_ORDER_PUB.Line_Scredit_Val_Tbl_Type;
268: x_Lot_Serial_tbl OE_ORDER_PUB.Lot_Serial_Tbl_Type;
269: x_Lot_Serial_val_tbl OE_ORDER_PUB.Lot_Serial_Val_Tbl_Type;

Line 266: x_Line_Scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type;

262: x_Line_Adj_val_tbl OE_ORDER_PUB.Line_Adj_Val_Tbl_Type;
263: x_Line_price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
264: x_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
265: x_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
266: x_Line_Scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type;
267: x_Line_Scredit_val_tbl OE_ORDER_PUB.Line_Scredit_Val_Tbl_Type;
268: x_Lot_Serial_tbl OE_ORDER_PUB.Lot_Serial_Tbl_Type;
269: x_Lot_Serial_val_tbl OE_ORDER_PUB.Lot_Serial_Val_Tbl_Type;
270: x_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type;

Line 267: x_Line_Scredit_val_tbl OE_ORDER_PUB.Line_Scredit_Val_Tbl_Type;

263: x_Line_price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
264: x_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
265: x_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
266: x_Line_Scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type;
267: x_Line_Scredit_val_tbl OE_ORDER_PUB.Line_Scredit_Val_Tbl_Type;
268: x_Lot_Serial_tbl OE_ORDER_PUB.Lot_Serial_Tbl_Type;
269: x_Lot_Serial_val_tbl OE_ORDER_PUB.Lot_Serial_Val_Tbl_Type;
270: x_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type;
271:

Line 268: x_Lot_Serial_tbl OE_ORDER_PUB.Lot_Serial_Tbl_Type;

264: x_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
265: x_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
266: x_Line_Scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type;
267: x_Line_Scredit_val_tbl OE_ORDER_PUB.Line_Scredit_Val_Tbl_Type;
268: x_Lot_Serial_tbl OE_ORDER_PUB.Lot_Serial_Tbl_Type;
269: x_Lot_Serial_val_tbl OE_ORDER_PUB.Lot_Serial_Val_Tbl_Type;
270: x_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type;
271:
272: CURSOR validate_price (cv_order_header_id JTF_NUMBER_TABLE) IS

Line 269: x_Lot_Serial_val_tbl OE_ORDER_PUB.Lot_Serial_Val_Tbl_Type;

265: x_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
266: x_Line_Scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type;
267: x_Line_Scredit_val_tbl OE_ORDER_PUB.Line_Scredit_Val_Tbl_Type;
268: x_Lot_Serial_tbl OE_ORDER_PUB.Lot_Serial_Tbl_Type;
269: x_Lot_Serial_val_tbl OE_ORDER_PUB.Lot_Serial_Val_Tbl_Type;
270: x_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type;
271:
272: CURSOR validate_price (cv_order_header_id JTF_NUMBER_TABLE) IS
273: select 1 from dual where exists

Line 270: x_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type;

266: x_Line_Scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type;
267: x_Line_Scredit_val_tbl OE_ORDER_PUB.Line_Scredit_Val_Tbl_Type;
268: x_Lot_Serial_tbl OE_ORDER_PUB.Lot_Serial_Tbl_Type;
269: x_Lot_Serial_val_tbl OE_ORDER_PUB.Lot_Serial_Val_Tbl_Type;
270: x_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type;
271:
272: CURSOR validate_price (cv_order_header_id JTF_NUMBER_TABLE) IS
273: select 1 from dual where exists
274: (select /*+ CARDINALITY(t 10) */ 1

Line 556: l_header_rec := OE_ORDER_PUB.G_MISS_HEADER_REC;

552: FOR i in p_order_tbl.FIRST..p_order_tbl.LAST LOOP
553:
554: Order_Debug_On;
555:
556: l_header_rec := OE_ORDER_PUB.G_MISS_HEADER_REC;
557: l_header_rec.freight_terms_code := NULL;
558: l_header_rec.transactional_curr_code := P_currency_code;
559: l_header_rec.sold_to_org_id := p_partner_account_id;
560: l_header_rec.INVOICE_TO_ORG_ID := l_bill_to_site_use_id;

Line 577: l_header_out_rec := OE_ORDER_PUB.G_MISS_HEADER_REC;

573: l_header_rec.orig_sys_document_ref := p_order_tbl(i).invite_header_id;
574: END IF;
575:
576:
577: l_header_out_rec := OE_ORDER_PUB.G_MISS_HEADER_REC;
578: /*l_header_out_rec.order_type_id := l_transaction_type_id;
579: l_header_out_rec.freight_terms_code := NULL;
580: l_header_out_rec.transactional_curr_code := P_currency_code;
581: l_header_out_rec.sold_to_org_id := p_partner_account_id;

Line 596: l_line_tbl(1) := OE_ORDER_PUB.G_MISS_LINE_REC;

592: l_header_rec.operation := OE_GLOBALS.G_OPR_CREATE;
593: l_header_rec.order_type_id := l_transaction_type_id;
594: l_header_rec.salesrep_id := l_salesrep_id;
595:
596: l_line_tbl(1) := OE_ORDER_PUB.G_MISS_LINE_REC;
597: l_line_tbl(1).ordered_quantity := 1;
598: l_line_tbl(1).operation := OE_GLOBALS.G_OPR_CREATE;
599: l_line_tbl(1).inventory_item_id := P_order_tbl(i).inventory_item_id;
600:

Line 605: l_line_out_tbl(1) := OE_ORDER_PUB.G_MISS_LINE_REC;

601:
602: --kvattiku: Aug 08, 05 NOCOPY bug related change
603: /*l_header_out_rec.operation := OE_GLOBALS.G_OPR_CREATE;
604:
605: l_line_out_tbl(1) := OE_ORDER_PUB.G_MISS_LINE_REC;
606: l_line_out_tbl(1).ordered_quantity := 1;
607: l_line_out_tbl(1).operation := OE_GLOBALS.G_OPR_CREATE;
608: l_line_out_tbl(1).inventory_item_id := P_order_tbl(i).inventory_item_id;*/
609:

Line 1172: l_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type;

1168:
1169: l_api_version_number CONSTANT NUMBER := 1.0;
1170: l_api_name CONSTANT VARCHAR2(30) := 'Book_order';
1171: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
1172: l_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type;
1173:
1174:
1175: x_header_rec OE_ORDER_PUB.Header_Rec_Type;
1176: x_header_val_rec OE_ORDER_PUB.Header_Val_Rec_Type;

Line 1175: x_header_rec OE_ORDER_PUB.Header_Rec_Type;

1171: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
1172: l_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type;
1173:
1174:
1175: x_header_rec OE_ORDER_PUB.Header_Rec_Type;
1176: x_header_val_rec OE_ORDER_PUB.Header_Val_Rec_Type;
1177: x_Header_Adj_tbl OE_ORDER_PUB. Header_Adj_Tbl_Type;
1178: x_Header_Adj_val_tbl OE_ORDER_PUB.Header_Adj_Val_Tbl_Type;
1179: x_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;

Line 1176: x_header_val_rec OE_ORDER_PUB.Header_Val_Rec_Type;

1172: l_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type;
1173:
1174:
1175: x_header_rec OE_ORDER_PUB.Header_Rec_Type;
1176: x_header_val_rec OE_ORDER_PUB.Header_Val_Rec_Type;
1177: x_Header_Adj_tbl OE_ORDER_PUB. Header_Adj_Tbl_Type;
1178: x_Header_Adj_val_tbl OE_ORDER_PUB.Header_Adj_Val_Tbl_Type;
1179: x_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
1180: x_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;

Line 1177: x_Header_Adj_tbl OE_ORDER_PUB. Header_Adj_Tbl_Type;

1173:
1174:
1175: x_header_rec OE_ORDER_PUB.Header_Rec_Type;
1176: x_header_val_rec OE_ORDER_PUB.Header_Val_Rec_Type;
1177: x_Header_Adj_tbl OE_ORDER_PUB. Header_Adj_Tbl_Type;
1178: x_Header_Adj_val_tbl OE_ORDER_PUB.Header_Adj_Val_Tbl_Type;
1179: x_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
1180: x_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
1181: x_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;

Line 1178: x_Header_Adj_val_tbl OE_ORDER_PUB.Header_Adj_Val_Tbl_Type;

1174:
1175: x_header_rec OE_ORDER_PUB.Header_Rec_Type;
1176: x_header_val_rec OE_ORDER_PUB.Header_Val_Rec_Type;
1177: x_Header_Adj_tbl OE_ORDER_PUB. Header_Adj_Tbl_Type;
1178: x_Header_Adj_val_tbl OE_ORDER_PUB.Header_Adj_Val_Tbl_Type;
1179: x_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
1180: x_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
1181: x_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
1182: x_Header_Scredit_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type;

Line 1179: x_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;

1175: x_header_rec OE_ORDER_PUB.Header_Rec_Type;
1176: x_header_val_rec OE_ORDER_PUB.Header_Val_Rec_Type;
1177: x_Header_Adj_tbl OE_ORDER_PUB. Header_Adj_Tbl_Type;
1178: x_Header_Adj_val_tbl OE_ORDER_PUB.Header_Adj_Val_Tbl_Type;
1179: x_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
1180: x_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
1181: x_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
1182: x_Header_Scredit_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type;
1183: x_Header_Scredit_val_tbl OE_ORDER_PUB.Header_Scredit_Val_Tbl_Type;

Line 1180: x_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;

1176: x_header_val_rec OE_ORDER_PUB.Header_Val_Rec_Type;
1177: x_Header_Adj_tbl OE_ORDER_PUB. Header_Adj_Tbl_Type;
1178: x_Header_Adj_val_tbl OE_ORDER_PUB.Header_Adj_Val_Tbl_Type;
1179: x_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
1180: x_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
1181: x_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
1182: x_Header_Scredit_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type;
1183: x_Header_Scredit_val_tbl OE_ORDER_PUB.Header_Scredit_Val_Tbl_Type;
1184: x_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

Line 1181: x_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;

1177: x_Header_Adj_tbl OE_ORDER_PUB. Header_Adj_Tbl_Type;
1178: x_Header_Adj_val_tbl OE_ORDER_PUB.Header_Adj_Val_Tbl_Type;
1179: x_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
1180: x_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
1181: x_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
1182: x_Header_Scredit_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type;
1183: x_Header_Scredit_val_tbl OE_ORDER_PUB.Header_Scredit_Val_Tbl_Type;
1184: x_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
1185: x_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;

Line 1182: x_Header_Scredit_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type;

1178: x_Header_Adj_val_tbl OE_ORDER_PUB.Header_Adj_Val_Tbl_Type;
1179: x_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
1180: x_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
1181: x_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
1182: x_Header_Scredit_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type;
1183: x_Header_Scredit_val_tbl OE_ORDER_PUB.Header_Scredit_Val_Tbl_Type;
1184: x_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
1185: x_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;
1186: x_Line_Adj_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;

Line 1183: x_Header_Scredit_val_tbl OE_ORDER_PUB.Header_Scredit_Val_Tbl_Type;

1179: x_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
1180: x_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
1181: x_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
1182: x_Header_Scredit_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type;
1183: x_Header_Scredit_val_tbl OE_ORDER_PUB.Header_Scredit_Val_Tbl_Type;
1184: x_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
1185: x_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;
1186: x_Line_Adj_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
1187: x_Line_Adj_val_tbl OE_ORDER_PUB.Line_Adj_Val_Tbl_Type;

Line 1184: x_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

1180: x_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
1181: x_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
1182: x_Header_Scredit_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type;
1183: x_Header_Scredit_val_tbl OE_ORDER_PUB.Header_Scredit_Val_Tbl_Type;
1184: x_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
1185: x_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;
1186: x_Line_Adj_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
1187: x_Line_Adj_val_tbl OE_ORDER_PUB.Line_Adj_Val_Tbl_Type;
1188: x_Line_price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;

Line 1185: x_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;

1181: x_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
1182: x_Header_Scredit_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type;
1183: x_Header_Scredit_val_tbl OE_ORDER_PUB.Header_Scredit_Val_Tbl_Type;
1184: x_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
1185: x_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;
1186: x_Line_Adj_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
1187: x_Line_Adj_val_tbl OE_ORDER_PUB.Line_Adj_Val_Tbl_Type;
1188: x_Line_price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
1189: x_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;

Line 1186: x_Line_Adj_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;

1182: x_Header_Scredit_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type;
1183: x_Header_Scredit_val_tbl OE_ORDER_PUB.Header_Scredit_Val_Tbl_Type;
1184: x_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
1185: x_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;
1186: x_Line_Adj_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
1187: x_Line_Adj_val_tbl OE_ORDER_PUB.Line_Adj_Val_Tbl_Type;
1188: x_Line_price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
1189: x_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
1190: x_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;

Line 1187: x_Line_Adj_val_tbl OE_ORDER_PUB.Line_Adj_Val_Tbl_Type;

1183: x_Header_Scredit_val_tbl OE_ORDER_PUB.Header_Scredit_Val_Tbl_Type;
1184: x_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
1185: x_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;
1186: x_Line_Adj_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
1187: x_Line_Adj_val_tbl OE_ORDER_PUB.Line_Adj_Val_Tbl_Type;
1188: x_Line_price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
1189: x_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
1190: x_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
1191: x_Line_Scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type;

Line 1188: x_Line_price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;

1184: x_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
1185: x_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;
1186: x_Line_Adj_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
1187: x_Line_Adj_val_tbl OE_ORDER_PUB.Line_Adj_Val_Tbl_Type;
1188: x_Line_price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
1189: x_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
1190: x_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
1191: x_Line_Scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type;
1192: x_Line_Scredit_val_tbl OE_ORDER_PUB.Line_Scredit_Val_Tbl_Type;

Line 1189: x_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;

1185: x_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;
1186: x_Line_Adj_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
1187: x_Line_Adj_val_tbl OE_ORDER_PUB.Line_Adj_Val_Tbl_Type;
1188: x_Line_price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
1189: x_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
1190: x_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
1191: x_Line_Scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type;
1192: x_Line_Scredit_val_tbl OE_ORDER_PUB.Line_Scredit_Val_Tbl_Type;
1193: x_Lot_Serial_tbl OE_ORDER_PUB.Lot_Serial_Tbl_Type;

Line 1190: x_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;

1186: x_Line_Adj_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
1187: x_Line_Adj_val_tbl OE_ORDER_PUB.Line_Adj_Val_Tbl_Type;
1188: x_Line_price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
1189: x_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
1190: x_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
1191: x_Line_Scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type;
1192: x_Line_Scredit_val_tbl OE_ORDER_PUB.Line_Scredit_Val_Tbl_Type;
1193: x_Lot_Serial_tbl OE_ORDER_PUB.Lot_Serial_Tbl_Type;
1194: x_Lot_Serial_val_tbl OE_ORDER_PUB.Lot_Serial_Val_Tbl_Type;

Line 1191: x_Line_Scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type;

1187: x_Line_Adj_val_tbl OE_ORDER_PUB.Line_Adj_Val_Tbl_Type;
1188: x_Line_price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
1189: x_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
1190: x_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
1191: x_Line_Scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type;
1192: x_Line_Scredit_val_tbl OE_ORDER_PUB.Line_Scredit_Val_Tbl_Type;
1193: x_Lot_Serial_tbl OE_ORDER_PUB.Lot_Serial_Tbl_Type;
1194: x_Lot_Serial_val_tbl OE_ORDER_PUB.Lot_Serial_Val_Tbl_Type;
1195: x_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type;

Line 1192: x_Line_Scredit_val_tbl OE_ORDER_PUB.Line_Scredit_Val_Tbl_Type;

1188: x_Line_price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
1189: x_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
1190: x_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
1191: x_Line_Scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type;
1192: x_Line_Scredit_val_tbl OE_ORDER_PUB.Line_Scredit_Val_Tbl_Type;
1193: x_Lot_Serial_tbl OE_ORDER_PUB.Lot_Serial_Tbl_Type;
1194: x_Lot_Serial_val_tbl OE_ORDER_PUB.Lot_Serial_Val_Tbl_Type;
1195: x_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type;
1196:

Line 1193: x_Lot_Serial_tbl OE_ORDER_PUB.Lot_Serial_Tbl_Type;

1189: x_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
1190: x_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
1191: x_Line_Scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type;
1192: x_Line_Scredit_val_tbl OE_ORDER_PUB.Line_Scredit_Val_Tbl_Type;
1193: x_Lot_Serial_tbl OE_ORDER_PUB.Lot_Serial_Tbl_Type;
1194: x_Lot_Serial_val_tbl OE_ORDER_PUB.Lot_Serial_Val_Tbl_Type;
1195: x_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type;
1196:
1197:

Line 1194: x_Lot_Serial_val_tbl OE_ORDER_PUB.Lot_Serial_Val_Tbl_Type;

1190: x_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
1191: x_Line_Scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type;
1192: x_Line_Scredit_val_tbl OE_ORDER_PUB.Line_Scredit_Val_Tbl_Type;
1193: x_Lot_Serial_tbl OE_ORDER_PUB.Lot_Serial_Tbl_Type;
1194: x_Lot_Serial_val_tbl OE_ORDER_PUB.Lot_Serial_Val_Tbl_Type;
1195: x_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type;
1196:
1197:
1198: BEGIN

Line 1195: x_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type;

1191: x_Line_Scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type;
1192: x_Line_Scredit_val_tbl OE_ORDER_PUB.Line_Scredit_Val_Tbl_Type;
1193: x_Lot_Serial_tbl OE_ORDER_PUB.Lot_Serial_Tbl_Type;
1194: x_Lot_Serial_val_tbl OE_ORDER_PUB.Lot_Serial_Val_Tbl_Type;
1195: x_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type;
1196:
1197:
1198: BEGIN
1199:

Line 1249: l_action_request_tbl(1) := oe_order_pub.G_MISS_REQUEST_REC;

1245: Order_Debug_On;
1246:
1247: set_mo_policy_context (p_order_header_id);
1248:
1249: l_action_request_tbl(1) := oe_order_pub.G_MISS_REQUEST_REC;
1250: l_action_request_tbl(1).Entity_code := OE_GLOBALS.G_ENTITY_HEADER;
1251: l_action_request_tbl(1).Entity_id := p_order_header_id;
1252: l_action_request_tbl(1).request_type := OE_GLOBALS.G_BOOK_ORDER;
1253:

Line 1373: l_header_rec OE_ORDER_PUB.Header_Rec_Type;

1369: IS
1370: l_api_version_number CONSTANT NUMBER := 1.0;
1371: l_api_name CONSTANT VARCHAR2(30) := 'Cancel_order';
1372: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
1373: l_header_rec OE_ORDER_PUB.Header_Rec_Type;
1374: --kvattiku: Aug 08, 05 NOCOPY bug related change
1375: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
1376: l_change_reason VARCHAR2(30);
1377:

Line 1375: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;

1371: l_api_name CONSTANT VARCHAR2(30) := 'Cancel_order';
1372: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
1373: l_header_rec OE_ORDER_PUB.Header_Rec_Type;
1374: --kvattiku: Aug 08, 05 NOCOPY bug related change
1375: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
1376: l_change_reason VARCHAR2(30);
1377:
1378: x_header_val_rec OE_ORDER_PUB.Header_Val_Rec_Type;
1379: x_Header_Adj_tbl OE_ORDER_PUB. Header_Adj_Tbl_Type;

Line 1378: x_header_val_rec OE_ORDER_PUB.Header_Val_Rec_Type;

1374: --kvattiku: Aug 08, 05 NOCOPY bug related change
1375: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
1376: l_change_reason VARCHAR2(30);
1377:
1378: x_header_val_rec OE_ORDER_PUB.Header_Val_Rec_Type;
1379: x_Header_Adj_tbl OE_ORDER_PUB. Header_Adj_Tbl_Type;
1380: x_Header_Adj_val_tbl OE_ORDER_PUB.Header_Adj_Val_Tbl_Type;
1381: x_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
1382: x_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;

Line 1379: x_Header_Adj_tbl OE_ORDER_PUB. Header_Adj_Tbl_Type;

1375: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
1376: l_change_reason VARCHAR2(30);
1377:
1378: x_header_val_rec OE_ORDER_PUB.Header_Val_Rec_Type;
1379: x_Header_Adj_tbl OE_ORDER_PUB. Header_Adj_Tbl_Type;
1380: x_Header_Adj_val_tbl OE_ORDER_PUB.Header_Adj_Val_Tbl_Type;
1381: x_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
1382: x_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
1383: x_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;

Line 1380: x_Header_Adj_val_tbl OE_ORDER_PUB.Header_Adj_Val_Tbl_Type;

1376: l_change_reason VARCHAR2(30);
1377:
1378: x_header_val_rec OE_ORDER_PUB.Header_Val_Rec_Type;
1379: x_Header_Adj_tbl OE_ORDER_PUB. Header_Adj_Tbl_Type;
1380: x_Header_Adj_val_tbl OE_ORDER_PUB.Header_Adj_Val_Tbl_Type;
1381: x_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
1382: x_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
1383: x_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
1384: x_Header_Scredit_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type;

Line 1381: x_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;

1377:
1378: x_header_val_rec OE_ORDER_PUB.Header_Val_Rec_Type;
1379: x_Header_Adj_tbl OE_ORDER_PUB. Header_Adj_Tbl_Type;
1380: x_Header_Adj_val_tbl OE_ORDER_PUB.Header_Adj_Val_Tbl_Type;
1381: x_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
1382: x_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
1383: x_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
1384: x_Header_Scredit_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type;
1385: x_Header_Scredit_val_tbl OE_ORDER_PUB.Header_Scredit_Val_Tbl_Type;

Line 1382: x_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;

1378: x_header_val_rec OE_ORDER_PUB.Header_Val_Rec_Type;
1379: x_Header_Adj_tbl OE_ORDER_PUB. Header_Adj_Tbl_Type;
1380: x_Header_Adj_val_tbl OE_ORDER_PUB.Header_Adj_Val_Tbl_Type;
1381: x_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
1382: x_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
1383: x_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
1384: x_Header_Scredit_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type;
1385: x_Header_Scredit_val_tbl OE_ORDER_PUB.Header_Scredit_Val_Tbl_Type;
1386: x_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

Line 1383: x_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;

1379: x_Header_Adj_tbl OE_ORDER_PUB. Header_Adj_Tbl_Type;
1380: x_Header_Adj_val_tbl OE_ORDER_PUB.Header_Adj_Val_Tbl_Type;
1381: x_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
1382: x_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
1383: x_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
1384: x_Header_Scredit_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type;
1385: x_Header_Scredit_val_tbl OE_ORDER_PUB.Header_Scredit_Val_Tbl_Type;
1386: x_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
1387: x_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;

Line 1384: x_Header_Scredit_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type;

1380: x_Header_Adj_val_tbl OE_ORDER_PUB.Header_Adj_Val_Tbl_Type;
1381: x_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
1382: x_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
1383: x_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
1384: x_Header_Scredit_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type;
1385: x_Header_Scredit_val_tbl OE_ORDER_PUB.Header_Scredit_Val_Tbl_Type;
1386: x_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
1387: x_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;
1388: x_Line_Adj_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;

Line 1385: x_Header_Scredit_val_tbl OE_ORDER_PUB.Header_Scredit_Val_Tbl_Type;

1381: x_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
1382: x_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
1383: x_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
1384: x_Header_Scredit_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type;
1385: x_Header_Scredit_val_tbl OE_ORDER_PUB.Header_Scredit_Val_Tbl_Type;
1386: x_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
1387: x_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;
1388: x_Line_Adj_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
1389: x_Line_Adj_val_tbl OE_ORDER_PUB.Line_Adj_Val_Tbl_Type;

Line 1386: x_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

1382: x_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
1383: x_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
1384: x_Header_Scredit_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type;
1385: x_Header_Scredit_val_tbl OE_ORDER_PUB.Header_Scredit_Val_Tbl_Type;
1386: x_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
1387: x_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;
1388: x_Line_Adj_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
1389: x_Line_Adj_val_tbl OE_ORDER_PUB.Line_Adj_Val_Tbl_Type;
1390: x_Line_price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;

Line 1387: x_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;

1383: x_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
1384: x_Header_Scredit_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type;
1385: x_Header_Scredit_val_tbl OE_ORDER_PUB.Header_Scredit_Val_Tbl_Type;
1386: x_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
1387: x_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;
1388: x_Line_Adj_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
1389: x_Line_Adj_val_tbl OE_ORDER_PUB.Line_Adj_Val_Tbl_Type;
1390: x_Line_price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
1391: x_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;

Line 1388: x_Line_Adj_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;

1384: x_Header_Scredit_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type;
1385: x_Header_Scredit_val_tbl OE_ORDER_PUB.Header_Scredit_Val_Tbl_Type;
1386: x_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
1387: x_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;
1388: x_Line_Adj_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
1389: x_Line_Adj_val_tbl OE_ORDER_PUB.Line_Adj_Val_Tbl_Type;
1390: x_Line_price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
1391: x_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
1392: x_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;

Line 1389: x_Line_Adj_val_tbl OE_ORDER_PUB.Line_Adj_Val_Tbl_Type;

1385: x_Header_Scredit_val_tbl OE_ORDER_PUB.Header_Scredit_Val_Tbl_Type;
1386: x_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
1387: x_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;
1388: x_Line_Adj_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
1389: x_Line_Adj_val_tbl OE_ORDER_PUB.Line_Adj_Val_Tbl_Type;
1390: x_Line_price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
1391: x_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
1392: x_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
1393: x_Line_Scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type;

Line 1390: x_Line_price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;

1386: x_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
1387: x_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;
1388: x_Line_Adj_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
1389: x_Line_Adj_val_tbl OE_ORDER_PUB.Line_Adj_Val_Tbl_Type;
1390: x_Line_price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
1391: x_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
1392: x_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
1393: x_Line_Scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type;
1394: x_Line_Scredit_val_tbl OE_ORDER_PUB.Line_Scredit_Val_Tbl_Type;

Line 1391: x_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;

1387: x_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;
1388: x_Line_Adj_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
1389: x_Line_Adj_val_tbl OE_ORDER_PUB.Line_Adj_Val_Tbl_Type;
1390: x_Line_price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
1391: x_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
1392: x_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
1393: x_Line_Scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type;
1394: x_Line_Scredit_val_tbl OE_ORDER_PUB.Line_Scredit_Val_Tbl_Type;
1395: x_Lot_Serial_tbl OE_ORDER_PUB.Lot_Serial_Tbl_Type;

Line 1392: x_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;

1388: x_Line_Adj_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
1389: x_Line_Adj_val_tbl OE_ORDER_PUB.Line_Adj_Val_Tbl_Type;
1390: x_Line_price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
1391: x_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
1392: x_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
1393: x_Line_Scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type;
1394: x_Line_Scredit_val_tbl OE_ORDER_PUB.Line_Scredit_Val_Tbl_Type;
1395: x_Lot_Serial_tbl OE_ORDER_PUB.Lot_Serial_Tbl_Type;
1396: x_Lot_Serial_val_tbl OE_ORDER_PUB.Lot_Serial_Val_Tbl_Type;

Line 1393: x_Line_Scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type;

1389: x_Line_Adj_val_tbl OE_ORDER_PUB.Line_Adj_Val_Tbl_Type;
1390: x_Line_price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
1391: x_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
1392: x_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
1393: x_Line_Scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type;
1394: x_Line_Scredit_val_tbl OE_ORDER_PUB.Line_Scredit_Val_Tbl_Type;
1395: x_Lot_Serial_tbl OE_ORDER_PUB.Lot_Serial_Tbl_Type;
1396: x_Lot_Serial_val_tbl OE_ORDER_PUB.Lot_Serial_Val_Tbl_Type;
1397: x_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type;

Line 1394: x_Line_Scredit_val_tbl OE_ORDER_PUB.Line_Scredit_Val_Tbl_Type;

1390: x_Line_price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
1391: x_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
1392: x_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
1393: x_Line_Scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type;
1394: x_Line_Scredit_val_tbl OE_ORDER_PUB.Line_Scredit_Val_Tbl_Type;
1395: x_Lot_Serial_tbl OE_ORDER_PUB.Lot_Serial_Tbl_Type;
1396: x_Lot_Serial_val_tbl OE_ORDER_PUB.Lot_Serial_Val_Tbl_Type;
1397: x_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type;
1398:

Line 1395: x_Lot_Serial_tbl OE_ORDER_PUB.Lot_Serial_Tbl_Type;

1391: x_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
1392: x_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
1393: x_Line_Scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type;
1394: x_Line_Scredit_val_tbl OE_ORDER_PUB.Line_Scredit_Val_Tbl_Type;
1395: x_Lot_Serial_tbl OE_ORDER_PUB.Lot_Serial_Tbl_Type;
1396: x_Lot_Serial_val_tbl OE_ORDER_PUB.Lot_Serial_Val_Tbl_Type;
1397: x_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type;
1398:
1399:

Line 1396: x_Lot_Serial_val_tbl OE_ORDER_PUB.Lot_Serial_Val_Tbl_Type;

1392: x_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
1393: x_Line_Scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type;
1394: x_Line_Scredit_val_tbl OE_ORDER_PUB.Line_Scredit_Val_Tbl_Type;
1395: x_Lot_Serial_tbl OE_ORDER_PUB.Lot_Serial_Tbl_Type;
1396: x_Lot_Serial_val_tbl OE_ORDER_PUB.Lot_Serial_Val_Tbl_Type;
1397: x_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type;
1398:
1399:
1400:

Line 1397: x_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type;

1393: x_Line_Scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type;
1394: x_Line_Scredit_val_tbl OE_ORDER_PUB.Line_Scredit_Val_Tbl_Type;
1395: x_Lot_Serial_tbl OE_ORDER_PUB.Lot_Serial_Tbl_Type;
1396: x_Lot_Serial_val_tbl OE_ORDER_PUB.Lot_Serial_Val_Tbl_Type;
1397: x_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type;
1398:
1399:
1400:
1401: BEGIN

Line 1461: l_header_rec := OE_ORDER_PUB.G_MISS_HEADER_REC;

1457: Order_Debug_On;
1458:
1459: set_mo_policy_context (p_order_header_id);
1460:
1461: l_header_rec := OE_ORDER_PUB.G_MISS_HEADER_REC;
1462: l_header_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
1463: l_header_rec.header_id := p_order_header_id;
1464: l_header_rec.cancelled_flag := 'Y';
1465: l_header_rec.change_reason := l_change_reason;

Line 1468: /*l_header_out_rec := OE_ORDER_PUB.G_MISS_HEADER_REC;

1464: l_header_rec.cancelled_flag := 'Y';
1465: l_header_rec.change_reason := l_change_reason;
1466:
1467: --kvattiku: Aug 08, 05 NOCOPY bug related change
1468: /*l_header_out_rec := OE_ORDER_PUB.G_MISS_HEADER_REC;
1469: l_header_out_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
1470: l_header_out_rec.header_id := p_order_header_id;
1471: l_header_out_rec.cancelled_flag := 'Y';
1472: l_header_out_rec.change_reason := l_change_reason;*/

Line 2567: l_header_payment_tbl OE_ORDER_PUB.Header_Payment_Tbl_Type;

2563: l_payment_amount number;
2564: l_pmnt_mode_mean varchar2(80);
2565:
2566: /*Moving process_order to here instead of set_payment_info*/
2567: l_header_payment_tbl OE_ORDER_PUB.Header_Payment_Tbl_Type;
2568: l_header_payment_out_tbl OE_ORDER_PUB.Header_Payment_Tbl_Type;
2569: l_header_rec OE_ORDER_PUB.Header_Rec_Type;
2570: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
2571: x_header_val_rec OE_ORDER_PUB.Header_Val_Rec_Type;

Line 2568: l_header_payment_out_tbl OE_ORDER_PUB.Header_Payment_Tbl_Type;

2564: l_pmnt_mode_mean varchar2(80);
2565:
2566: /*Moving process_order to here instead of set_payment_info*/
2567: l_header_payment_tbl OE_ORDER_PUB.Header_Payment_Tbl_Type;
2568: l_header_payment_out_tbl OE_ORDER_PUB.Header_Payment_Tbl_Type;
2569: l_header_rec OE_ORDER_PUB.Header_Rec_Type;
2570: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
2571: x_header_val_rec OE_ORDER_PUB.Header_Val_Rec_Type;
2572: x_header_payment_val_tbl OE_ORDER_PUB.Header_Payment_Val_Tbl_Type;

Line 2569: l_header_rec OE_ORDER_PUB.Header_Rec_Type;

2565:
2566: /*Moving process_order to here instead of set_payment_info*/
2567: l_header_payment_tbl OE_ORDER_PUB.Header_Payment_Tbl_Type;
2568: l_header_payment_out_tbl OE_ORDER_PUB.Header_Payment_Tbl_Type;
2569: l_header_rec OE_ORDER_PUB.Header_Rec_Type;
2570: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
2571: x_header_val_rec OE_ORDER_PUB.Header_Val_Rec_Type;
2572: x_header_payment_val_tbl OE_ORDER_PUB.Header_Payment_Val_Tbl_Type;
2573: x_Header_Adj_tbl OE_ORDER_PUB.Header_Adj_Tbl_Type;

Line 2570: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;

2566: /*Moving process_order to here instead of set_payment_info*/
2567: l_header_payment_tbl OE_ORDER_PUB.Header_Payment_Tbl_Type;
2568: l_header_payment_out_tbl OE_ORDER_PUB.Header_Payment_Tbl_Type;
2569: l_header_rec OE_ORDER_PUB.Header_Rec_Type;
2570: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
2571: x_header_val_rec OE_ORDER_PUB.Header_Val_Rec_Type;
2572: x_header_payment_val_tbl OE_ORDER_PUB.Header_Payment_Val_Tbl_Type;
2573: x_Header_Adj_tbl OE_ORDER_PUB.Header_Adj_Tbl_Type;
2574: x_Header_Adj_val_tbl OE_ORDER_PUB.Header_Adj_Val_Tbl_Type;

Line 2571: x_header_val_rec OE_ORDER_PUB.Header_Val_Rec_Type;

2567: l_header_payment_tbl OE_ORDER_PUB.Header_Payment_Tbl_Type;
2568: l_header_payment_out_tbl OE_ORDER_PUB.Header_Payment_Tbl_Type;
2569: l_header_rec OE_ORDER_PUB.Header_Rec_Type;
2570: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
2571: x_header_val_rec OE_ORDER_PUB.Header_Val_Rec_Type;
2572: x_header_payment_val_tbl OE_ORDER_PUB.Header_Payment_Val_Tbl_Type;
2573: x_Header_Adj_tbl OE_ORDER_PUB.Header_Adj_Tbl_Type;
2574: x_Header_Adj_val_tbl OE_ORDER_PUB.Header_Adj_Val_Tbl_Type;
2575: x_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;

Line 2572: x_header_payment_val_tbl OE_ORDER_PUB.Header_Payment_Val_Tbl_Type;

2568: l_header_payment_out_tbl OE_ORDER_PUB.Header_Payment_Tbl_Type;
2569: l_header_rec OE_ORDER_PUB.Header_Rec_Type;
2570: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
2571: x_header_val_rec OE_ORDER_PUB.Header_Val_Rec_Type;
2572: x_header_payment_val_tbl OE_ORDER_PUB.Header_Payment_Val_Tbl_Type;
2573: x_Header_Adj_tbl OE_ORDER_PUB.Header_Adj_Tbl_Type;
2574: x_Header_Adj_val_tbl OE_ORDER_PUB.Header_Adj_Val_Tbl_Type;
2575: x_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
2576: x_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;

Line 2573: x_Header_Adj_tbl OE_ORDER_PUB.Header_Adj_Tbl_Type;

2569: l_header_rec OE_ORDER_PUB.Header_Rec_Type;
2570: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
2571: x_header_val_rec OE_ORDER_PUB.Header_Val_Rec_Type;
2572: x_header_payment_val_tbl OE_ORDER_PUB.Header_Payment_Val_Tbl_Type;
2573: x_Header_Adj_tbl OE_ORDER_PUB.Header_Adj_Tbl_Type;
2574: x_Header_Adj_val_tbl OE_ORDER_PUB.Header_Adj_Val_Tbl_Type;
2575: x_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
2576: x_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
2577: x_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;

Line 2574: x_Header_Adj_val_tbl OE_ORDER_PUB.Header_Adj_Val_Tbl_Type;

2570: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
2571: x_header_val_rec OE_ORDER_PUB.Header_Val_Rec_Type;
2572: x_header_payment_val_tbl OE_ORDER_PUB.Header_Payment_Val_Tbl_Type;
2573: x_Header_Adj_tbl OE_ORDER_PUB.Header_Adj_Tbl_Type;
2574: x_Header_Adj_val_tbl OE_ORDER_PUB.Header_Adj_Val_Tbl_Type;
2575: x_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
2576: x_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
2577: x_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
2578: x_Header_Scredit_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type;

Line 2575: x_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;

2571: x_header_val_rec OE_ORDER_PUB.Header_Val_Rec_Type;
2572: x_header_payment_val_tbl OE_ORDER_PUB.Header_Payment_Val_Tbl_Type;
2573: x_Header_Adj_tbl OE_ORDER_PUB.Header_Adj_Tbl_Type;
2574: x_Header_Adj_val_tbl OE_ORDER_PUB.Header_Adj_Val_Tbl_Type;
2575: x_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
2576: x_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
2577: x_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
2578: x_Header_Scredit_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type;
2579: x_Header_Scredit_val_tbl OE_ORDER_PUB.Header_Scredit_Val_Tbl_Type;

Line 2576: x_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;

2572: x_header_payment_val_tbl OE_ORDER_PUB.Header_Payment_Val_Tbl_Type;
2573: x_Header_Adj_tbl OE_ORDER_PUB.Header_Adj_Tbl_Type;
2574: x_Header_Adj_val_tbl OE_ORDER_PUB.Header_Adj_Val_Tbl_Type;
2575: x_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
2576: x_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
2577: x_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
2578: x_Header_Scredit_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type;
2579: x_Header_Scredit_val_tbl OE_ORDER_PUB.Header_Scredit_Val_Tbl_Type;
2580: x_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

Line 2577: x_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;

2573: x_Header_Adj_tbl OE_ORDER_PUB.Header_Adj_Tbl_Type;
2574: x_Header_Adj_val_tbl OE_ORDER_PUB.Header_Adj_Val_Tbl_Type;
2575: x_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
2576: x_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
2577: x_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
2578: x_Header_Scredit_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type;
2579: x_Header_Scredit_val_tbl OE_ORDER_PUB.Header_Scredit_Val_Tbl_Type;
2580: x_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2581: x_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;

Line 2578: x_Header_Scredit_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type;

2574: x_Header_Adj_val_tbl OE_ORDER_PUB.Header_Adj_Val_Tbl_Type;
2575: x_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
2576: x_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
2577: x_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
2578: x_Header_Scredit_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type;
2579: x_Header_Scredit_val_tbl OE_ORDER_PUB.Header_Scredit_Val_Tbl_Type;
2580: x_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2581: x_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;
2582: x_Line_Adj_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;

Line 2579: x_Header_Scredit_val_tbl OE_ORDER_PUB.Header_Scredit_Val_Tbl_Type;

2575: x_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
2576: x_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
2577: x_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
2578: x_Header_Scredit_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type;
2579: x_Header_Scredit_val_tbl OE_ORDER_PUB.Header_Scredit_Val_Tbl_Type;
2580: x_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2581: x_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;
2582: x_Line_Adj_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
2583: x_Line_Adj_val_tbl OE_ORDER_PUB.Line_Adj_Val_Tbl_Type;

Line 2580: x_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

2576: x_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
2577: x_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
2578: x_Header_Scredit_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type;
2579: x_Header_Scredit_val_tbl OE_ORDER_PUB.Header_Scredit_Val_Tbl_Type;
2580: x_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2581: x_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;
2582: x_Line_Adj_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
2583: x_Line_Adj_val_tbl OE_ORDER_PUB.Line_Adj_Val_Tbl_Type;
2584: x_Line_price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;

Line 2581: x_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;

2577: x_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
2578: x_Header_Scredit_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type;
2579: x_Header_Scredit_val_tbl OE_ORDER_PUB.Header_Scredit_Val_Tbl_Type;
2580: x_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2581: x_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;
2582: x_Line_Adj_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
2583: x_Line_Adj_val_tbl OE_ORDER_PUB.Line_Adj_Val_Tbl_Type;
2584: x_Line_price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
2585: x_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;

Line 2582: x_Line_Adj_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;

2578: x_Header_Scredit_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type;
2579: x_Header_Scredit_val_tbl OE_ORDER_PUB.Header_Scredit_Val_Tbl_Type;
2580: x_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2581: x_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;
2582: x_Line_Adj_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
2583: x_Line_Adj_val_tbl OE_ORDER_PUB.Line_Adj_Val_Tbl_Type;
2584: x_Line_price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
2585: x_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
2586: x_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;

Line 2583: x_Line_Adj_val_tbl OE_ORDER_PUB.Line_Adj_Val_Tbl_Type;

2579: x_Header_Scredit_val_tbl OE_ORDER_PUB.Header_Scredit_Val_Tbl_Type;
2580: x_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2581: x_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;
2582: x_Line_Adj_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
2583: x_Line_Adj_val_tbl OE_ORDER_PUB.Line_Adj_Val_Tbl_Type;
2584: x_Line_price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
2585: x_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
2586: x_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
2587: x_Line_Payment_tbl OE_ORDER_PUB.Line_Payment_Tbl_Type;

Line 2584: x_Line_price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;

2580: x_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2581: x_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;
2582: x_Line_Adj_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
2583: x_Line_Adj_val_tbl OE_ORDER_PUB.Line_Adj_Val_Tbl_Type;
2584: x_Line_price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
2585: x_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
2586: x_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
2587: x_Line_Payment_tbl OE_ORDER_PUB.Line_Payment_Tbl_Type;
2588: x_Line_Payment_val_tbl OE_ORDER_PUB.Line_Payment_Val_Tbl_Type;

Line 2585: x_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;

2581: x_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;
2582: x_Line_Adj_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
2583: x_Line_Adj_val_tbl OE_ORDER_PUB.Line_Adj_Val_Tbl_Type;
2584: x_Line_price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
2585: x_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
2586: x_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
2587: x_Line_Payment_tbl OE_ORDER_PUB.Line_Payment_Tbl_Type;
2588: x_Line_Payment_val_tbl OE_ORDER_PUB.Line_Payment_Val_Tbl_Type;
2589: x_Line_Scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type;

Line 2586: x_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;

2582: x_Line_Adj_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
2583: x_Line_Adj_val_tbl OE_ORDER_PUB.Line_Adj_Val_Tbl_Type;
2584: x_Line_price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
2585: x_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
2586: x_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
2587: x_Line_Payment_tbl OE_ORDER_PUB.Line_Payment_Tbl_Type;
2588: x_Line_Payment_val_tbl OE_ORDER_PUB.Line_Payment_Val_Tbl_Type;
2589: x_Line_Scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type;
2590: x_Line_Scredit_val_tbl OE_ORDER_PUB.Line_Scredit_Val_Tbl_Type;

Line 2587: x_Line_Payment_tbl OE_ORDER_PUB.Line_Payment_Tbl_Type;

2583: x_Line_Adj_val_tbl OE_ORDER_PUB.Line_Adj_Val_Tbl_Type;
2584: x_Line_price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
2585: x_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
2586: x_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
2587: x_Line_Payment_tbl OE_ORDER_PUB.Line_Payment_Tbl_Type;
2588: x_Line_Payment_val_tbl OE_ORDER_PUB.Line_Payment_Val_Tbl_Type;
2589: x_Line_Scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type;
2590: x_Line_Scredit_val_tbl OE_ORDER_PUB.Line_Scredit_Val_Tbl_Type;
2591: x_Lot_Serial_tbl OE_ORDER_PUB.Lot_Serial_Tbl_Type;

Line 2588: x_Line_Payment_val_tbl OE_ORDER_PUB.Line_Payment_Val_Tbl_Type;

2584: x_Line_price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
2585: x_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
2586: x_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
2587: x_Line_Payment_tbl OE_ORDER_PUB.Line_Payment_Tbl_Type;
2588: x_Line_Payment_val_tbl OE_ORDER_PUB.Line_Payment_Val_Tbl_Type;
2589: x_Line_Scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type;
2590: x_Line_Scredit_val_tbl OE_ORDER_PUB.Line_Scredit_Val_Tbl_Type;
2591: x_Lot_Serial_tbl OE_ORDER_PUB.Lot_Serial_Tbl_Type;
2592: x_Lot_Serial_val_tbl OE_ORDER_PUB.Lot_Serial_Val_Tbl_Type;

Line 2589: x_Line_Scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type;

2585: x_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
2586: x_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
2587: x_Line_Payment_tbl OE_ORDER_PUB.Line_Payment_Tbl_Type;
2588: x_Line_Payment_val_tbl OE_ORDER_PUB.Line_Payment_Val_Tbl_Type;
2589: x_Line_Scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type;
2590: x_Line_Scredit_val_tbl OE_ORDER_PUB.Line_Scredit_Val_Tbl_Type;
2591: x_Lot_Serial_tbl OE_ORDER_PUB.Lot_Serial_Tbl_Type;
2592: x_Lot_Serial_val_tbl OE_ORDER_PUB.Lot_Serial_Val_Tbl_Type;
2593: x_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type;

Line 2590: x_Line_Scredit_val_tbl OE_ORDER_PUB.Line_Scredit_Val_Tbl_Type;

2586: x_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
2587: x_Line_Payment_tbl OE_ORDER_PUB.Line_Payment_Tbl_Type;
2588: x_Line_Payment_val_tbl OE_ORDER_PUB.Line_Payment_Val_Tbl_Type;
2589: x_Line_Scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type;
2590: x_Line_Scredit_val_tbl OE_ORDER_PUB.Line_Scredit_Val_Tbl_Type;
2591: x_Lot_Serial_tbl OE_ORDER_PUB.Lot_Serial_Tbl_Type;
2592: x_Lot_Serial_val_tbl OE_ORDER_PUB.Lot_Serial_Val_Tbl_Type;
2593: x_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type;
2594:

Line 2591: x_Lot_Serial_tbl OE_ORDER_PUB.Lot_Serial_Tbl_Type;

2587: x_Line_Payment_tbl OE_ORDER_PUB.Line_Payment_Tbl_Type;
2588: x_Line_Payment_val_tbl OE_ORDER_PUB.Line_Payment_Val_Tbl_Type;
2589: x_Line_Scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type;
2590: x_Line_Scredit_val_tbl OE_ORDER_PUB.Line_Scredit_Val_Tbl_Type;
2591: x_Lot_Serial_tbl OE_ORDER_PUB.Lot_Serial_Tbl_Type;
2592: x_Lot_Serial_val_tbl OE_ORDER_PUB.Lot_Serial_Val_Tbl_Type;
2593: x_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type;
2594:
2595:

Line 2592: x_Lot_Serial_val_tbl OE_ORDER_PUB.Lot_Serial_Val_Tbl_Type;

2588: x_Line_Payment_val_tbl OE_ORDER_PUB.Line_Payment_Val_Tbl_Type;
2589: x_Line_Scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type;
2590: x_Line_Scredit_val_tbl OE_ORDER_PUB.Line_Scredit_Val_Tbl_Type;
2591: x_Lot_Serial_tbl OE_ORDER_PUB.Lot_Serial_Tbl_Type;
2592: x_Lot_Serial_val_tbl OE_ORDER_PUB.Lot_Serial_Val_Tbl_Type;
2593: x_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type;
2594:
2595:
2596: /* R12 Change

Line 2593: x_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type;

2589: x_Line_Scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type;
2590: x_Line_Scredit_val_tbl OE_ORDER_PUB.Line_Scredit_Val_Tbl_Type;
2591: x_Lot_Serial_tbl OE_ORDER_PUB.Lot_Serial_Tbl_Type;
2592: x_Lot_Serial_val_tbl OE_ORDER_PUB.Lot_Serial_Val_Tbl_Type;
2593: x_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type;
2594:
2595:
2596: /* R12 Change
2597: * cursor c_get_order_id will return the transaction extension id

Line 2763: l_header_payment_tbl := OE_ORDER_PUB.G_MISS_HEADER_PAYMENT_TBL;

2759:
2760:
2761:
2762: -- dgottlie:If we reach here, all the enrollment requests have been authorized and we can update OM with the orders.
2763: l_header_payment_tbl := OE_ORDER_PUB.G_MISS_HEADER_PAYMENT_TBL;
2764: l_header_payment_out_tbl := OE_ORDER_PUB.G_MISS_HEADER_PAYMENT_TBL;
2765: l_header_rec := OE_ORDER_PUB.G_MISS_HEADER_REC;
2766: l_header_out_rec := OE_ORDER_PUB.G_MISS_HEADER_REC;
2767:

Line 2764: l_header_payment_out_tbl := OE_ORDER_PUB.G_MISS_HEADER_PAYMENT_TBL;

2760:
2761:
2762: -- dgottlie:If we reach here, all the enrollment requests have been authorized and we can update OM with the orders.
2763: l_header_payment_tbl := OE_ORDER_PUB.G_MISS_HEADER_PAYMENT_TBL;
2764: l_header_payment_out_tbl := OE_ORDER_PUB.G_MISS_HEADER_PAYMENT_TBL;
2765: l_header_rec := OE_ORDER_PUB.G_MISS_HEADER_REC;
2766: l_header_out_rec := OE_ORDER_PUB.G_MISS_HEADER_REC;
2767:
2768:

Line 2765: l_header_rec := OE_ORDER_PUB.G_MISS_HEADER_REC;

2761:
2762: -- dgottlie:If we reach here, all the enrollment requests have been authorized and we can update OM with the orders.
2763: l_header_payment_tbl := OE_ORDER_PUB.G_MISS_HEADER_PAYMENT_TBL;
2764: l_header_payment_out_tbl := OE_ORDER_PUB.G_MISS_HEADER_PAYMENT_TBL;
2765: l_header_rec := OE_ORDER_PUB.G_MISS_HEADER_REC;
2766: l_header_out_rec := OE_ORDER_PUB.G_MISS_HEADER_REC;
2767:
2768:
2769: FOR i IN lx_enrl_info.FIRST..lx_enrl_info.LAST LOOP

Line 2766: l_header_out_rec := OE_ORDER_PUB.G_MISS_HEADER_REC;

2762: -- dgottlie:If we reach here, all the enrollment requests have been authorized and we can update OM with the orders.
2763: l_header_payment_tbl := OE_ORDER_PUB.G_MISS_HEADER_PAYMENT_TBL;
2764: l_header_payment_out_tbl := OE_ORDER_PUB.G_MISS_HEADER_PAYMENT_TBL;
2765: l_header_rec := OE_ORDER_PUB.G_MISS_HEADER_REC;
2766: l_header_out_rec := OE_ORDER_PUB.G_MISS_HEADER_REC;
2767:
2768:
2769: FOR i IN lx_enrl_info.FIRST..lx_enrl_info.LAST LOOP
2770:

Line 3059: l_header_payment_tbl OE_ORDER_PUB.Header_Payment_Tbl_Type;

3055: l_is_authorized VARCHAR2(1);
3056: l_invite_header_rec Pv_Pg_Invite_headers_PVT.invite_headers_rec_type;
3057:
3058: /*Moving process_order to here instead of set_payment_info*/
3059: l_header_payment_tbl OE_ORDER_PUB.Header_Payment_Tbl_Type;
3060: l_header_payment_out_tbl OE_ORDER_PUB.Header_Payment_Tbl_Type;
3061: l_header_rec OE_ORDER_PUB.Header_Rec_Type;
3062: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
3063: x_header_val_rec OE_ORDER_PUB.Header_Val_Rec_Type;

Line 3060: l_header_payment_out_tbl OE_ORDER_PUB.Header_Payment_Tbl_Type;

3056: l_invite_header_rec Pv_Pg_Invite_headers_PVT.invite_headers_rec_type;
3057:
3058: /*Moving process_order to here instead of set_payment_info*/
3059: l_header_payment_tbl OE_ORDER_PUB.Header_Payment_Tbl_Type;
3060: l_header_payment_out_tbl OE_ORDER_PUB.Header_Payment_Tbl_Type;
3061: l_header_rec OE_ORDER_PUB.Header_Rec_Type;
3062: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
3063: x_header_val_rec OE_ORDER_PUB.Header_Val_Rec_Type;
3064: x_header_payment_val_tbl OE_ORDER_PUB.Header_Payment_Val_Tbl_Type;

Line 3061: l_header_rec OE_ORDER_PUB.Header_Rec_Type;

3057:
3058: /*Moving process_order to here instead of set_payment_info*/
3059: l_header_payment_tbl OE_ORDER_PUB.Header_Payment_Tbl_Type;
3060: l_header_payment_out_tbl OE_ORDER_PUB.Header_Payment_Tbl_Type;
3061: l_header_rec OE_ORDER_PUB.Header_Rec_Type;
3062: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
3063: x_header_val_rec OE_ORDER_PUB.Header_Val_Rec_Type;
3064: x_header_payment_val_tbl OE_ORDER_PUB.Header_Payment_Val_Tbl_Type;
3065: x_Header_Adj_tbl OE_ORDER_PUB.Header_Adj_Tbl_Type;

Line 3062: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;

3058: /*Moving process_order to here instead of set_payment_info*/
3059: l_header_payment_tbl OE_ORDER_PUB.Header_Payment_Tbl_Type;
3060: l_header_payment_out_tbl OE_ORDER_PUB.Header_Payment_Tbl_Type;
3061: l_header_rec OE_ORDER_PUB.Header_Rec_Type;
3062: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
3063: x_header_val_rec OE_ORDER_PUB.Header_Val_Rec_Type;
3064: x_header_payment_val_tbl OE_ORDER_PUB.Header_Payment_Val_Tbl_Type;
3065: x_Header_Adj_tbl OE_ORDER_PUB.Header_Adj_Tbl_Type;
3066: x_Header_Adj_val_tbl OE_ORDER_PUB.Header_Adj_Val_Tbl_Type;

Line 3063: x_header_val_rec OE_ORDER_PUB.Header_Val_Rec_Type;

3059: l_header_payment_tbl OE_ORDER_PUB.Header_Payment_Tbl_Type;
3060: l_header_payment_out_tbl OE_ORDER_PUB.Header_Payment_Tbl_Type;
3061: l_header_rec OE_ORDER_PUB.Header_Rec_Type;
3062: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
3063: x_header_val_rec OE_ORDER_PUB.Header_Val_Rec_Type;
3064: x_header_payment_val_tbl OE_ORDER_PUB.Header_Payment_Val_Tbl_Type;
3065: x_Header_Adj_tbl OE_ORDER_PUB.Header_Adj_Tbl_Type;
3066: x_Header_Adj_val_tbl OE_ORDER_PUB.Header_Adj_Val_Tbl_Type;
3067: x_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;

Line 3064: x_header_payment_val_tbl OE_ORDER_PUB.Header_Payment_Val_Tbl_Type;

3060: l_header_payment_out_tbl OE_ORDER_PUB.Header_Payment_Tbl_Type;
3061: l_header_rec OE_ORDER_PUB.Header_Rec_Type;
3062: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
3063: x_header_val_rec OE_ORDER_PUB.Header_Val_Rec_Type;
3064: x_header_payment_val_tbl OE_ORDER_PUB.Header_Payment_Val_Tbl_Type;
3065: x_Header_Adj_tbl OE_ORDER_PUB.Header_Adj_Tbl_Type;
3066: x_Header_Adj_val_tbl OE_ORDER_PUB.Header_Adj_Val_Tbl_Type;
3067: x_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
3068: x_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;

Line 3065: x_Header_Adj_tbl OE_ORDER_PUB.Header_Adj_Tbl_Type;

3061: l_header_rec OE_ORDER_PUB.Header_Rec_Type;
3062: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
3063: x_header_val_rec OE_ORDER_PUB.Header_Val_Rec_Type;
3064: x_header_payment_val_tbl OE_ORDER_PUB.Header_Payment_Val_Tbl_Type;
3065: x_Header_Adj_tbl OE_ORDER_PUB.Header_Adj_Tbl_Type;
3066: x_Header_Adj_val_tbl OE_ORDER_PUB.Header_Adj_Val_Tbl_Type;
3067: x_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
3068: x_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
3069: x_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;

Line 3066: x_Header_Adj_val_tbl OE_ORDER_PUB.Header_Adj_Val_Tbl_Type;

3062: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
3063: x_header_val_rec OE_ORDER_PUB.Header_Val_Rec_Type;
3064: x_header_payment_val_tbl OE_ORDER_PUB.Header_Payment_Val_Tbl_Type;
3065: x_Header_Adj_tbl OE_ORDER_PUB.Header_Adj_Tbl_Type;
3066: x_Header_Adj_val_tbl OE_ORDER_PUB.Header_Adj_Val_Tbl_Type;
3067: x_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
3068: x_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
3069: x_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
3070: x_Header_Scredit_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type;

Line 3067: x_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;

3063: x_header_val_rec OE_ORDER_PUB.Header_Val_Rec_Type;
3064: x_header_payment_val_tbl OE_ORDER_PUB.Header_Payment_Val_Tbl_Type;
3065: x_Header_Adj_tbl OE_ORDER_PUB.Header_Adj_Tbl_Type;
3066: x_Header_Adj_val_tbl OE_ORDER_PUB.Header_Adj_Val_Tbl_Type;
3067: x_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
3068: x_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
3069: x_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
3070: x_Header_Scredit_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type;
3071: x_Header_Scredit_val_tbl OE_ORDER_PUB.Header_Scredit_Val_Tbl_Type;

Line 3068: x_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;

3064: x_header_payment_val_tbl OE_ORDER_PUB.Header_Payment_Val_Tbl_Type;
3065: x_Header_Adj_tbl OE_ORDER_PUB.Header_Adj_Tbl_Type;
3066: x_Header_Adj_val_tbl OE_ORDER_PUB.Header_Adj_Val_Tbl_Type;
3067: x_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
3068: x_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
3069: x_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
3070: x_Header_Scredit_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type;
3071: x_Header_Scredit_val_tbl OE_ORDER_PUB.Header_Scredit_Val_Tbl_Type;
3072: x_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

Line 3069: x_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;

3065: x_Header_Adj_tbl OE_ORDER_PUB.Header_Adj_Tbl_Type;
3066: x_Header_Adj_val_tbl OE_ORDER_PUB.Header_Adj_Val_Tbl_Type;
3067: x_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
3068: x_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
3069: x_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
3070: x_Header_Scredit_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type;
3071: x_Header_Scredit_val_tbl OE_ORDER_PUB.Header_Scredit_Val_Tbl_Type;
3072: x_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
3073: x_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;

Line 3070: x_Header_Scredit_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type;

3066: x_Header_Adj_val_tbl OE_ORDER_PUB.Header_Adj_Val_Tbl_Type;
3067: x_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
3068: x_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
3069: x_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
3070: x_Header_Scredit_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type;
3071: x_Header_Scredit_val_tbl OE_ORDER_PUB.Header_Scredit_Val_Tbl_Type;
3072: x_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
3073: x_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;
3074: x_Line_Adj_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;

Line 3071: x_Header_Scredit_val_tbl OE_ORDER_PUB.Header_Scredit_Val_Tbl_Type;

3067: x_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
3068: x_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
3069: x_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
3070: x_Header_Scredit_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type;
3071: x_Header_Scredit_val_tbl OE_ORDER_PUB.Header_Scredit_Val_Tbl_Type;
3072: x_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
3073: x_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;
3074: x_Line_Adj_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
3075: x_Line_Adj_val_tbl OE_ORDER_PUB.Line_Adj_Val_Tbl_Type;

Line 3072: x_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

3068: x_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
3069: x_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
3070: x_Header_Scredit_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type;
3071: x_Header_Scredit_val_tbl OE_ORDER_PUB.Header_Scredit_Val_Tbl_Type;
3072: x_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
3073: x_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;
3074: x_Line_Adj_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
3075: x_Line_Adj_val_tbl OE_ORDER_PUB.Line_Adj_Val_Tbl_Type;
3076: x_Line_price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;

Line 3073: x_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;

3069: x_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
3070: x_Header_Scredit_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type;
3071: x_Header_Scredit_val_tbl OE_ORDER_PUB.Header_Scredit_Val_Tbl_Type;
3072: x_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
3073: x_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;
3074: x_Line_Adj_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
3075: x_Line_Adj_val_tbl OE_ORDER_PUB.Line_Adj_Val_Tbl_Type;
3076: x_Line_price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
3077: x_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;

Line 3074: x_Line_Adj_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;

3070: x_Header_Scredit_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type;
3071: x_Header_Scredit_val_tbl OE_ORDER_PUB.Header_Scredit_Val_Tbl_Type;
3072: x_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
3073: x_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;
3074: x_Line_Adj_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
3075: x_Line_Adj_val_tbl OE_ORDER_PUB.Line_Adj_Val_Tbl_Type;
3076: x_Line_price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
3077: x_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
3078: x_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;

Line 3075: x_Line_Adj_val_tbl OE_ORDER_PUB.Line_Adj_Val_Tbl_Type;

3071: x_Header_Scredit_val_tbl OE_ORDER_PUB.Header_Scredit_Val_Tbl_Type;
3072: x_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
3073: x_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;
3074: x_Line_Adj_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
3075: x_Line_Adj_val_tbl OE_ORDER_PUB.Line_Adj_Val_Tbl_Type;
3076: x_Line_price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
3077: x_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
3078: x_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
3079: x_Line_Payment_tbl OE_ORDER_PUB.Line_Payment_Tbl_Type;

Line 3076: x_Line_price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;

3072: x_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
3073: x_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;
3074: x_Line_Adj_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
3075: x_Line_Adj_val_tbl OE_ORDER_PUB.Line_Adj_Val_Tbl_Type;
3076: x_Line_price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
3077: x_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
3078: x_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
3079: x_Line_Payment_tbl OE_ORDER_PUB.Line_Payment_Tbl_Type;
3080: x_Line_Payment_val_tbl OE_ORDER_PUB.Line_Payment_Val_Tbl_Type;

Line 3077: x_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;

3073: x_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;
3074: x_Line_Adj_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
3075: x_Line_Adj_val_tbl OE_ORDER_PUB.Line_Adj_Val_Tbl_Type;
3076: x_Line_price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
3077: x_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
3078: x_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
3079: x_Line_Payment_tbl OE_ORDER_PUB.Line_Payment_Tbl_Type;
3080: x_Line_Payment_val_tbl OE_ORDER_PUB.Line_Payment_Val_Tbl_Type;
3081: x_Line_Scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type;

Line 3078: x_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;

3074: x_Line_Adj_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
3075: x_Line_Adj_val_tbl OE_ORDER_PUB.Line_Adj_Val_Tbl_Type;
3076: x_Line_price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
3077: x_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
3078: x_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
3079: x_Line_Payment_tbl OE_ORDER_PUB.Line_Payment_Tbl_Type;
3080: x_Line_Payment_val_tbl OE_ORDER_PUB.Line_Payment_Val_Tbl_Type;
3081: x_Line_Scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type;
3082: x_Line_Scredit_val_tbl OE_ORDER_PUB.Line_Scredit_Val_Tbl_Type;

Line 3079: x_Line_Payment_tbl OE_ORDER_PUB.Line_Payment_Tbl_Type;

3075: x_Line_Adj_val_tbl OE_ORDER_PUB.Line_Adj_Val_Tbl_Type;
3076: x_Line_price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
3077: x_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
3078: x_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
3079: x_Line_Payment_tbl OE_ORDER_PUB.Line_Payment_Tbl_Type;
3080: x_Line_Payment_val_tbl OE_ORDER_PUB.Line_Payment_Val_Tbl_Type;
3081: x_Line_Scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type;
3082: x_Line_Scredit_val_tbl OE_ORDER_PUB.Line_Scredit_Val_Tbl_Type;
3083: x_Lot_Serial_tbl OE_ORDER_PUB.Lot_Serial_Tbl_Type;

Line 3080: x_Line_Payment_val_tbl OE_ORDER_PUB.Line_Payment_Val_Tbl_Type;

3076: x_Line_price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
3077: x_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
3078: x_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
3079: x_Line_Payment_tbl OE_ORDER_PUB.Line_Payment_Tbl_Type;
3080: x_Line_Payment_val_tbl OE_ORDER_PUB.Line_Payment_Val_Tbl_Type;
3081: x_Line_Scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type;
3082: x_Line_Scredit_val_tbl OE_ORDER_PUB.Line_Scredit_Val_Tbl_Type;
3083: x_Lot_Serial_tbl OE_ORDER_PUB.Lot_Serial_Tbl_Type;
3084: x_Lot_Serial_val_tbl OE_ORDER_PUB.Lot_Serial_Val_Tbl_Type;

Line 3081: x_Line_Scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type;

3077: x_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
3078: x_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
3079: x_Line_Payment_tbl OE_ORDER_PUB.Line_Payment_Tbl_Type;
3080: x_Line_Payment_val_tbl OE_ORDER_PUB.Line_Payment_Val_Tbl_Type;
3081: x_Line_Scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type;
3082: x_Line_Scredit_val_tbl OE_ORDER_PUB.Line_Scredit_Val_Tbl_Type;
3083: x_Lot_Serial_tbl OE_ORDER_PUB.Lot_Serial_Tbl_Type;
3084: x_Lot_Serial_val_tbl OE_ORDER_PUB.Lot_Serial_Val_Tbl_Type;
3085: x_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type;

Line 3082: x_Line_Scredit_val_tbl OE_ORDER_PUB.Line_Scredit_Val_Tbl_Type;

3078: x_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
3079: x_Line_Payment_tbl OE_ORDER_PUB.Line_Payment_Tbl_Type;
3080: x_Line_Payment_val_tbl OE_ORDER_PUB.Line_Payment_Val_Tbl_Type;
3081: x_Line_Scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type;
3082: x_Line_Scredit_val_tbl OE_ORDER_PUB.Line_Scredit_Val_Tbl_Type;
3083: x_Lot_Serial_tbl OE_ORDER_PUB.Lot_Serial_Tbl_Type;
3084: x_Lot_Serial_val_tbl OE_ORDER_PUB.Lot_Serial_Val_Tbl_Type;
3085: x_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type;
3086:

Line 3083: x_Lot_Serial_tbl OE_ORDER_PUB.Lot_Serial_Tbl_Type;

3079: x_Line_Payment_tbl OE_ORDER_PUB.Line_Payment_Tbl_Type;
3080: x_Line_Payment_val_tbl OE_ORDER_PUB.Line_Payment_Val_Tbl_Type;
3081: x_Line_Scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type;
3082: x_Line_Scredit_val_tbl OE_ORDER_PUB.Line_Scredit_Val_Tbl_Type;
3083: x_Lot_Serial_tbl OE_ORDER_PUB.Lot_Serial_Tbl_Type;
3084: x_Lot_Serial_val_tbl OE_ORDER_PUB.Lot_Serial_Val_Tbl_Type;
3085: x_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type;
3086:
3087: /* R12 Change

Line 3084: x_Lot_Serial_val_tbl OE_ORDER_PUB.Lot_Serial_Val_Tbl_Type;

3080: x_Line_Payment_val_tbl OE_ORDER_PUB.Line_Payment_Val_Tbl_Type;
3081: x_Line_Scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type;
3082: x_Line_Scredit_val_tbl OE_ORDER_PUB.Line_Scredit_Val_Tbl_Type;
3083: x_Lot_Serial_tbl OE_ORDER_PUB.Lot_Serial_Tbl_Type;
3084: x_Lot_Serial_val_tbl OE_ORDER_PUB.Lot_Serial_Val_Tbl_Type;
3085: x_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type;
3086:
3087: /* R12 Change
3088: * cursor c_get_order_id will return the transaction extension id

Line 3085: x_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type;

3081: x_Line_Scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type;
3082: x_Line_Scredit_val_tbl OE_ORDER_PUB.Line_Scredit_Val_Tbl_Type;
3083: x_Lot_Serial_tbl OE_ORDER_PUB.Lot_Serial_Tbl_Type;
3084: x_Lot_Serial_val_tbl OE_ORDER_PUB.Lot_Serial_Val_Tbl_Type;
3085: x_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type;
3086:
3087: /* R12 Change
3088: * cursor c_get_order_id will return the transaction extension id
3089: */

Line 3207: l_header_payment_tbl := OE_ORDER_PUB.G_MISS_HEADER_PAYMENT_TBL;

3203:
3204: END LOOP;
3205:
3206: -- dgottlie:If we reach here, all the enrollment requests have been authorized and we can update OM with the orders.
3207: l_header_payment_tbl := OE_ORDER_PUB.G_MISS_HEADER_PAYMENT_TBL;
3208: l_header_payment_out_tbl := OE_ORDER_PUB.G_MISS_HEADER_PAYMENT_TBL;
3209: l_header_rec := OE_ORDER_PUB.G_MISS_HEADER_REC;
3210: l_header_out_rec := OE_ORDER_PUB.G_MISS_HEADER_REC;
3211: FOR i IN lx_enrl_info.FIRST..lx_enrl_info.LAST LOOP

Line 3208: l_header_payment_out_tbl := OE_ORDER_PUB.G_MISS_HEADER_PAYMENT_TBL;

3204: END LOOP;
3205:
3206: -- dgottlie:If we reach here, all the enrollment requests have been authorized and we can update OM with the orders.
3207: l_header_payment_tbl := OE_ORDER_PUB.G_MISS_HEADER_PAYMENT_TBL;
3208: l_header_payment_out_tbl := OE_ORDER_PUB.G_MISS_HEADER_PAYMENT_TBL;
3209: l_header_rec := OE_ORDER_PUB.G_MISS_HEADER_REC;
3210: l_header_out_rec := OE_ORDER_PUB.G_MISS_HEADER_REC;
3211: FOR i IN lx_enrl_info.FIRST..lx_enrl_info.LAST LOOP
3212: l_header_rec.operation := OE_GLOBALS.g_OPR_UPDATE;

Line 3209: l_header_rec := OE_ORDER_PUB.G_MISS_HEADER_REC;

3205:
3206: -- dgottlie:If we reach here, all the enrollment requests have been authorized and we can update OM with the orders.
3207: l_header_payment_tbl := OE_ORDER_PUB.G_MISS_HEADER_PAYMENT_TBL;
3208: l_header_payment_out_tbl := OE_ORDER_PUB.G_MISS_HEADER_PAYMENT_TBL;
3209: l_header_rec := OE_ORDER_PUB.G_MISS_HEADER_REC;
3210: l_header_out_rec := OE_ORDER_PUB.G_MISS_HEADER_REC;
3211: FOR i IN lx_enrl_info.FIRST..lx_enrl_info.LAST LOOP
3212: l_header_rec.operation := OE_GLOBALS.g_OPR_UPDATE;
3213: l_header_rec.header_id := lx_enrl_info(i).order_header_id;

Line 3210: l_header_out_rec := OE_ORDER_PUB.G_MISS_HEADER_REC;

3206: -- dgottlie:If we reach here, all the enrollment requests have been authorized and we can update OM with the orders.
3207: l_header_payment_tbl := OE_ORDER_PUB.G_MISS_HEADER_PAYMENT_TBL;
3208: l_header_payment_out_tbl := OE_ORDER_PUB.G_MISS_HEADER_PAYMENT_TBL;
3209: l_header_rec := OE_ORDER_PUB.G_MISS_HEADER_REC;
3210: l_header_out_rec := OE_ORDER_PUB.G_MISS_HEADER_REC;
3211: FOR i IN lx_enrl_info.FIRST..lx_enrl_info.LAST LOOP
3212: l_header_rec.operation := OE_GLOBALS.g_OPR_UPDATE;
3213: l_header_rec.header_id := lx_enrl_info(i).order_header_id;
3214: l_header_rec.change_reason := 'SYSTEM';