DBA Data[Home] [Help]

APPS.JMF_SHIKYU_RECONCILIAITON_PVT dependencies on OE_ORDER_PUB

Line 301: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

297:
298:
299: -- OM variables --
300:
301: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
302: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
303: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
304: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
305: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

Line 302: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

298:
299: -- OM variables --
300:
301: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
302: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
303: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
304: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
305: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
306: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

Line 303: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

299: -- OM variables --
300:
301: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
302: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
303: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
304: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
305: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
306: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
307: l_hdr_rec OE_Order_PUB.Header_Rec_Type;

Line 304: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

300:
301: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
302: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
303: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
304: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
305: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
306: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
307: l_hdr_rec OE_Order_PUB.Header_Rec_Type;
308: l_line_rec OE_Order_PUB.Line_Rec_Type;

Line 305: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

301: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
302: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
303: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
304: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
305: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
306: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
307: l_hdr_rec OE_Order_PUB.Header_Rec_Type;
308: l_line_rec OE_Order_PUB.Line_Rec_Type;
309: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;

Line 306: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

302: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
303: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
304: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
305: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
306: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
307: l_hdr_rec OE_Order_PUB.Header_Rec_Type;
308: l_line_rec OE_Order_PUB.Line_Rec_Type;
309: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
310: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

Line 307: l_hdr_rec OE_Order_PUB.Header_Rec_Type;

303: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
304: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
305: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
306: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
307: l_hdr_rec OE_Order_PUB.Header_Rec_Type;
308: l_line_rec OE_Order_PUB.Line_Rec_Type;
309: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
310: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
311: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

Line 308: l_line_rec OE_Order_PUB.Line_Rec_Type;

304: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
305: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
306: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
307: l_hdr_rec OE_Order_PUB.Header_Rec_Type;
308: l_line_rec OE_Order_PUB.Line_Rec_Type;
309: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
310: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
311: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
312: l_x_header_rec OE_Order_PUB.Header_Rec_Type;

Line 309: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;

305: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
306: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
307: l_hdr_rec OE_Order_PUB.Header_Rec_Type;
308: l_line_rec OE_Order_PUB.Line_Rec_Type;
309: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
310: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
311: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
312: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
313: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

Line 310: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

306: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
307: l_hdr_rec OE_Order_PUB.Header_Rec_Type;
308: l_line_rec OE_Order_PUB.Line_Rec_Type;
309: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
310: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
311: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
312: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
313: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
314: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

Line 311: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

307: l_hdr_rec OE_Order_PUB.Header_Rec_Type;
308: l_line_rec OE_Order_PUB.Line_Rec_Type;
309: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
310: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
311: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
312: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
313: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
314: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
315: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;

Line 312: l_x_header_rec OE_Order_PUB.Header_Rec_Type;

308: l_line_rec OE_Order_PUB.Line_Rec_Type;
309: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
310: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
311: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
312: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
313: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
314: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
315: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
316: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

Line 313: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

309: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
310: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
311: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
312: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
313: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
314: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
315: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
316: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
317: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

Line 314: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

310: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
311: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
312: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
313: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
314: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
315: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
316: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
317: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
318: l_action_request_tbl OE_Order_PUB.request_tbl_type;

Line 315: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;

311: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
312: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
313: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
314: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
315: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
316: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
317: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
318: l_action_request_tbl OE_Order_PUB.request_tbl_type;
319: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;

Line 316: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

312: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
313: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
314: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
315: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
316: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
317: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
318: l_action_request_tbl OE_Order_PUB.request_tbl_type;
319: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
320: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;

Line 317: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

313: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
314: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
315: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
316: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
317: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
318: l_action_request_tbl OE_Order_PUB.request_tbl_type;
319: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
320: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
321: l_hdr_payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;

Line 318: l_action_request_tbl OE_Order_PUB.request_tbl_type;

314: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
315: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
316: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
317: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
318: l_action_request_tbl OE_Order_PUB.request_tbl_type;
319: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
320: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
321: l_hdr_payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
322: l_line_payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;

Line 319: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;

315: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
316: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
317: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
318: l_action_request_tbl OE_Order_PUB.request_tbl_type;
319: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
320: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
321: l_hdr_payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
322: l_line_payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
323: l_control_rec oe_globals.control_rec_type;

Line 320: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;

316: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
317: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
318: l_action_request_tbl OE_Order_PUB.request_tbl_type;
319: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
320: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
321: l_hdr_payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
322: l_line_payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
323: l_control_rec oe_globals.control_rec_type;
324: l_return_status Varchar2(30);

Line 321: l_hdr_payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;

317: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
318: l_action_request_tbl OE_Order_PUB.request_tbl_type;
319: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
320: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
321: l_hdr_payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
322: l_line_payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
323: l_control_rec oe_globals.control_rec_type;
324: l_return_status Varchar2(30);
325: l_file_val Varchar2(30);

Line 322: l_line_payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;

318: l_action_request_tbl OE_Order_PUB.request_tbl_type;
319: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
320: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
321: l_hdr_payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
322: l_line_payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
323: l_control_rec oe_globals.control_rec_type;
324: l_return_status Varchar2(30);
325: l_file_val Varchar2(30);
326: x_msg_count number;

Line 419: l_line_rec := OE_Order_PUB.G_MISS_LINE_REC;

415: , C_select_replenishments_REC.REPLENISHMENT_SO_LINE_ID);
416: END IF;
417:
418:
419: l_line_rec := OE_Order_PUB.G_MISS_LINE_REC;
420: l_line_rec.operation := oe_globals.G_OPR_UPDATE;
421:
422: l_line_rec.line_id :=
423: C_select_replenishments_REC.REPLENISHMENT_SO_LINE_ID;