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.CSP_PARTS_ORDER dependencies on OE_ORDER_PUB

Line 442: l_oe_line_tbl OE_Order_PUB.line_tbl_type;

438: l_msg_count NUMBER;
439: l_msg_data VARCHAR2(2000);
440:
441: -- Record and table types for oe process_order
442: l_oe_line_tbl OE_Order_PUB.line_tbl_type;
443: lx_oe_line_tbl OE_Order_PUB.line_tbl_type;
444: l_oe_line_old_tbl OE_Order_PUB.line_tbl_type;
445: l_oe_header_rec oe_order_pub.header_rec_type := OE_ORDER_PUB.G_MISS_HEADER_REC;
446: lx_oe_header_rec oe_order_pub.header_rec_type := OE_ORDER_PUB.G_MISS_HEADER_REC;

Line 443: lx_oe_line_tbl OE_Order_PUB.line_tbl_type;

439: l_msg_data VARCHAR2(2000);
440:
441: -- Record and table types for oe process_order
442: l_oe_line_tbl OE_Order_PUB.line_tbl_type;
443: lx_oe_line_tbl OE_Order_PUB.line_tbl_type;
444: l_oe_line_old_tbl OE_Order_PUB.line_tbl_type;
445: l_oe_header_rec oe_order_pub.header_rec_type := OE_ORDER_PUB.G_MISS_HEADER_REC;
446: lx_oe_header_rec oe_order_pub.header_rec_type := OE_ORDER_PUB.G_MISS_HEADER_REC;
447: l_oe_Header_Val_rec oe_order_pub.header_val_rec_type;

Line 444: l_oe_line_old_tbl OE_Order_PUB.line_tbl_type;

440:
441: -- Record and table types for oe process_order
442: l_oe_line_tbl OE_Order_PUB.line_tbl_type;
443: lx_oe_line_tbl OE_Order_PUB.line_tbl_type;
444: l_oe_line_old_tbl OE_Order_PUB.line_tbl_type;
445: l_oe_header_rec oe_order_pub.header_rec_type := OE_ORDER_PUB.G_MISS_HEADER_REC;
446: lx_oe_header_rec oe_order_pub.header_rec_type := OE_ORDER_PUB.G_MISS_HEADER_REC;
447: l_oe_Header_Val_rec oe_order_pub.header_val_rec_type;
448: l_oe_header_adj_tbl oe_order_pub.header_adj_tbl_type;

Line 445: l_oe_header_rec oe_order_pub.header_rec_type := OE_ORDER_PUB.G_MISS_HEADER_REC;

441: -- Record and table types for oe process_order
442: l_oe_line_tbl OE_Order_PUB.line_tbl_type;
443: lx_oe_line_tbl OE_Order_PUB.line_tbl_type;
444: l_oe_line_old_tbl OE_Order_PUB.line_tbl_type;
445: l_oe_header_rec oe_order_pub.header_rec_type := OE_ORDER_PUB.G_MISS_HEADER_REC;
446: lx_oe_header_rec oe_order_pub.header_rec_type := OE_ORDER_PUB.G_MISS_HEADER_REC;
447: l_oe_Header_Val_rec oe_order_pub.header_val_rec_type;
448: l_oe_header_adj_tbl oe_order_pub.header_adj_tbl_type;
449: l_oe_header_adj_val_tbl oe_order_pub.header_adj_val_tbl_type;

Line 446: lx_oe_header_rec oe_order_pub.header_rec_type := OE_ORDER_PUB.G_MISS_HEADER_REC;

442: l_oe_line_tbl OE_Order_PUB.line_tbl_type;
443: lx_oe_line_tbl OE_Order_PUB.line_tbl_type;
444: l_oe_line_old_tbl OE_Order_PUB.line_tbl_type;
445: l_oe_header_rec oe_order_pub.header_rec_type := OE_ORDER_PUB.G_MISS_HEADER_REC;
446: lx_oe_header_rec oe_order_pub.header_rec_type := OE_ORDER_PUB.G_MISS_HEADER_REC;
447: l_oe_Header_Val_rec oe_order_pub.header_val_rec_type;
448: l_oe_header_adj_tbl oe_order_pub.header_adj_tbl_type;
449: l_oe_header_adj_val_tbl oe_order_pub.header_adj_val_tbl_type;
450: l_oe_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;

Line 447: l_oe_Header_Val_rec oe_order_pub.header_val_rec_type;

443: lx_oe_line_tbl OE_Order_PUB.line_tbl_type;
444: l_oe_line_old_tbl OE_Order_PUB.line_tbl_type;
445: l_oe_header_rec oe_order_pub.header_rec_type := OE_ORDER_PUB.G_MISS_HEADER_REC;
446: lx_oe_header_rec oe_order_pub.header_rec_type := OE_ORDER_PUB.G_MISS_HEADER_REC;
447: l_oe_Header_Val_rec oe_order_pub.header_val_rec_type;
448: l_oe_header_adj_tbl oe_order_pub.header_adj_tbl_type;
449: l_oe_header_adj_val_tbl oe_order_pub.header_adj_val_tbl_type;
450: l_oe_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
451: l_oe_Header_Adj_Att_Tbl oe_order_pub.header_adj_att_tbl_type;

Line 448: l_oe_header_adj_tbl oe_order_pub.header_adj_tbl_type;

444: l_oe_line_old_tbl OE_Order_PUB.line_tbl_type;
445: l_oe_header_rec oe_order_pub.header_rec_type := OE_ORDER_PUB.G_MISS_HEADER_REC;
446: lx_oe_header_rec oe_order_pub.header_rec_type := OE_ORDER_PUB.G_MISS_HEADER_REC;
447: l_oe_Header_Val_rec oe_order_pub.header_val_rec_type;
448: l_oe_header_adj_tbl oe_order_pub.header_adj_tbl_type;
449: l_oe_header_adj_val_tbl oe_order_pub.header_adj_val_tbl_type;
450: l_oe_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
451: l_oe_Header_Adj_Att_Tbl oe_order_pub.header_adj_att_tbl_type;
452: l_oe_Header_Adj_Assoc_Tbl oe_order_pub.header_adj_assoc_tbl_type;

Line 449: l_oe_header_adj_val_tbl oe_order_pub.header_adj_val_tbl_type;

445: l_oe_header_rec oe_order_pub.header_rec_type := OE_ORDER_PUB.G_MISS_HEADER_REC;
446: lx_oe_header_rec oe_order_pub.header_rec_type := OE_ORDER_PUB.G_MISS_HEADER_REC;
447: l_oe_Header_Val_rec oe_order_pub.header_val_rec_type;
448: l_oe_header_adj_tbl oe_order_pub.header_adj_tbl_type;
449: l_oe_header_adj_val_tbl oe_order_pub.header_adj_val_tbl_type;
450: l_oe_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
451: l_oe_Header_Adj_Att_Tbl oe_order_pub.header_adj_att_tbl_type;
452: l_oe_Header_Adj_Assoc_Tbl oe_order_pub.header_adj_assoc_tbl_type;
453: l_oe_header_scr_tbl OE_ORDER_PUB.header_scredit_tbl_type;

Line 450: l_oe_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;

446: lx_oe_header_rec oe_order_pub.header_rec_type := OE_ORDER_PUB.G_MISS_HEADER_REC;
447: l_oe_Header_Val_rec oe_order_pub.header_val_rec_type;
448: l_oe_header_adj_tbl oe_order_pub.header_adj_tbl_type;
449: l_oe_header_adj_val_tbl oe_order_pub.header_adj_val_tbl_type;
450: l_oe_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
451: l_oe_Header_Adj_Att_Tbl oe_order_pub.header_adj_att_tbl_type;
452: l_oe_Header_Adj_Assoc_Tbl oe_order_pub.header_adj_assoc_tbl_type;
453: l_oe_header_scr_tbl OE_ORDER_PUB.header_scredit_tbl_type;
454: l_oe_Header_Scredit_Val_Tbl OE_ORDER_PUB.header_scredit_Val_tbl_type;

Line 451: l_oe_Header_Adj_Att_Tbl oe_order_pub.header_adj_att_tbl_type;

447: l_oe_Header_Val_rec oe_order_pub.header_val_rec_type;
448: l_oe_header_adj_tbl oe_order_pub.header_adj_tbl_type;
449: l_oe_header_adj_val_tbl oe_order_pub.header_adj_val_tbl_type;
450: l_oe_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
451: l_oe_Header_Adj_Att_Tbl oe_order_pub.header_adj_att_tbl_type;
452: l_oe_Header_Adj_Assoc_Tbl oe_order_pub.header_adj_assoc_tbl_type;
453: l_oe_header_scr_tbl OE_ORDER_PUB.header_scredit_tbl_type;
454: l_oe_Header_Scredit_Val_Tbl OE_ORDER_PUB.header_scredit_Val_tbl_type;
455: l_oe_line_rec oe_order_pub.line_rec_type;

Line 452: l_oe_Header_Adj_Assoc_Tbl oe_order_pub.header_adj_assoc_tbl_type;

448: l_oe_header_adj_tbl oe_order_pub.header_adj_tbl_type;
449: l_oe_header_adj_val_tbl oe_order_pub.header_adj_val_tbl_type;
450: l_oe_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
451: l_oe_Header_Adj_Att_Tbl oe_order_pub.header_adj_att_tbl_type;
452: l_oe_Header_Adj_Assoc_Tbl oe_order_pub.header_adj_assoc_tbl_type;
453: l_oe_header_scr_tbl OE_ORDER_PUB.header_scredit_tbl_type;
454: l_oe_Header_Scredit_Val_Tbl OE_ORDER_PUB.header_scredit_Val_tbl_type;
455: l_oe_line_rec oe_order_pub.line_rec_type;
456: l_oe_Line_Val_Tbl oe_order_pub.line_Val_tbl_type;

Line 453: l_oe_header_scr_tbl OE_ORDER_PUB.header_scredit_tbl_type;

449: l_oe_header_adj_val_tbl oe_order_pub.header_adj_val_tbl_type;
450: l_oe_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
451: l_oe_Header_Adj_Att_Tbl oe_order_pub.header_adj_att_tbl_type;
452: l_oe_Header_Adj_Assoc_Tbl oe_order_pub.header_adj_assoc_tbl_type;
453: l_oe_header_scr_tbl OE_ORDER_PUB.header_scredit_tbl_type;
454: l_oe_Header_Scredit_Val_Tbl OE_ORDER_PUB.header_scredit_Val_tbl_type;
455: l_oe_line_rec oe_order_pub.line_rec_type;
456: l_oe_Line_Val_Tbl oe_order_pub.line_Val_tbl_type;
457: l_oe_line_adj_tbl oe_order_pub.line_adj_tbl_type;

Line 454: l_oe_Header_Scredit_Val_Tbl OE_ORDER_PUB.header_scredit_Val_tbl_type;

450: l_oe_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
451: l_oe_Header_Adj_Att_Tbl oe_order_pub.header_adj_att_tbl_type;
452: l_oe_Header_Adj_Assoc_Tbl oe_order_pub.header_adj_assoc_tbl_type;
453: l_oe_header_scr_tbl OE_ORDER_PUB.header_scredit_tbl_type;
454: l_oe_Header_Scredit_Val_Tbl OE_ORDER_PUB.header_scredit_Val_tbl_type;
455: l_oe_line_rec oe_order_pub.line_rec_type;
456: l_oe_Line_Val_Tbl oe_order_pub.line_Val_tbl_type;
457: l_oe_line_adj_tbl oe_order_pub.line_adj_tbl_type;
458: l_oe_Line_Adj_Val_Tbl oe_order_pub.line_adj_val_tbl_type;

Line 455: l_oe_line_rec oe_order_pub.line_rec_type;

451: l_oe_Header_Adj_Att_Tbl oe_order_pub.header_adj_att_tbl_type;
452: l_oe_Header_Adj_Assoc_Tbl oe_order_pub.header_adj_assoc_tbl_type;
453: l_oe_header_scr_tbl OE_ORDER_PUB.header_scredit_tbl_type;
454: l_oe_Header_Scredit_Val_Tbl OE_ORDER_PUB.header_scredit_Val_tbl_type;
455: l_oe_line_rec oe_order_pub.line_rec_type;
456: l_oe_Line_Val_Tbl oe_order_pub.line_Val_tbl_type;
457: l_oe_line_adj_tbl oe_order_pub.line_adj_tbl_type;
458: l_oe_Line_Adj_Val_Tbl oe_order_pub.line_adj_val_tbl_type;
459: l_oe_Line_Price_Att_Tbl oe_order_pub.line_price_att_tbl_type;

Line 456: l_oe_Line_Val_Tbl oe_order_pub.line_Val_tbl_type;

452: l_oe_Header_Adj_Assoc_Tbl oe_order_pub.header_adj_assoc_tbl_type;
453: l_oe_header_scr_tbl OE_ORDER_PUB.header_scredit_tbl_type;
454: l_oe_Header_Scredit_Val_Tbl OE_ORDER_PUB.header_scredit_Val_tbl_type;
455: l_oe_line_rec oe_order_pub.line_rec_type;
456: l_oe_Line_Val_Tbl oe_order_pub.line_Val_tbl_type;
457: l_oe_line_adj_tbl oe_order_pub.line_adj_tbl_type;
458: l_oe_Line_Adj_Val_Tbl oe_order_pub.line_adj_val_tbl_type;
459: l_oe_Line_Price_Att_Tbl oe_order_pub.line_price_att_tbl_type;
460: l_oe_Line_Adj_Att_Tbl oe_order_pub.line_adj_att_tbl_type;

Line 457: l_oe_line_adj_tbl oe_order_pub.line_adj_tbl_type;

453: l_oe_header_scr_tbl OE_ORDER_PUB.header_scredit_tbl_type;
454: l_oe_Header_Scredit_Val_Tbl OE_ORDER_PUB.header_scredit_Val_tbl_type;
455: l_oe_line_rec oe_order_pub.line_rec_type;
456: l_oe_Line_Val_Tbl oe_order_pub.line_Val_tbl_type;
457: l_oe_line_adj_tbl oe_order_pub.line_adj_tbl_type;
458: l_oe_Line_Adj_Val_Tbl oe_order_pub.line_adj_val_tbl_type;
459: l_oe_Line_Price_Att_Tbl oe_order_pub.line_price_att_tbl_type;
460: l_oe_Line_Adj_Att_Tbl oe_order_pub.line_adj_att_tbl_type;
461: l_oe_Line_Adj_Assoc_tbl oe_order_pub.Line_Adj_Assoc_Tbl_Type;

Line 458: l_oe_Line_Adj_Val_Tbl oe_order_pub.line_adj_val_tbl_type;

454: l_oe_Header_Scredit_Val_Tbl OE_ORDER_PUB.header_scredit_Val_tbl_type;
455: l_oe_line_rec oe_order_pub.line_rec_type;
456: l_oe_Line_Val_Tbl oe_order_pub.line_Val_tbl_type;
457: l_oe_line_adj_tbl oe_order_pub.line_adj_tbl_type;
458: l_oe_Line_Adj_Val_Tbl oe_order_pub.line_adj_val_tbl_type;
459: l_oe_Line_Price_Att_Tbl oe_order_pub.line_price_att_tbl_type;
460: l_oe_Line_Adj_Att_Tbl oe_order_pub.line_adj_att_tbl_type;
461: l_oe_Line_Adj_Assoc_tbl oe_order_pub.Line_Adj_Assoc_Tbl_Type;
462: l_oe_line_scr_tbl oe_order_pub.line_scredit_tbl_type;

Line 459: l_oe_Line_Price_Att_Tbl oe_order_pub.line_price_att_tbl_type;

455: l_oe_line_rec oe_order_pub.line_rec_type;
456: l_oe_Line_Val_Tbl oe_order_pub.line_Val_tbl_type;
457: l_oe_line_adj_tbl oe_order_pub.line_adj_tbl_type;
458: l_oe_Line_Adj_Val_Tbl oe_order_pub.line_adj_val_tbl_type;
459: l_oe_Line_Price_Att_Tbl oe_order_pub.line_price_att_tbl_type;
460: l_oe_Line_Adj_Att_Tbl oe_order_pub.line_adj_att_tbl_type;
461: l_oe_Line_Adj_Assoc_tbl oe_order_pub.Line_Adj_Assoc_Tbl_Type;
462: l_oe_line_scr_tbl oe_order_pub.line_scredit_tbl_type;
463: l_oe_Line_Scredit_Val_Tbl oe_order_pub.line_scredit_val_tbl_type;

Line 460: l_oe_Line_Adj_Att_Tbl oe_order_pub.line_adj_att_tbl_type;

456: l_oe_Line_Val_Tbl oe_order_pub.line_Val_tbl_type;
457: l_oe_line_adj_tbl oe_order_pub.line_adj_tbl_type;
458: l_oe_Line_Adj_Val_Tbl oe_order_pub.line_adj_val_tbl_type;
459: l_oe_Line_Price_Att_Tbl oe_order_pub.line_price_att_tbl_type;
460: l_oe_Line_Adj_Att_Tbl oe_order_pub.line_adj_att_tbl_type;
461: l_oe_Line_Adj_Assoc_tbl oe_order_pub.Line_Adj_Assoc_Tbl_Type;
462: l_oe_line_scr_tbl oe_order_pub.line_scredit_tbl_type;
463: l_oe_Line_Scredit_Val_Tbl oe_order_pub.line_scredit_val_tbl_type;
464: l_oe_Lot_Serial_Tbl oe_order_pub.lot_serial_tbl_type;

Line 461: l_oe_Line_Adj_Assoc_tbl oe_order_pub.Line_Adj_Assoc_Tbl_Type;

457: l_oe_line_adj_tbl oe_order_pub.line_adj_tbl_type;
458: l_oe_Line_Adj_Val_Tbl oe_order_pub.line_adj_val_tbl_type;
459: l_oe_Line_Price_Att_Tbl oe_order_pub.line_price_att_tbl_type;
460: l_oe_Line_Adj_Att_Tbl oe_order_pub.line_adj_att_tbl_type;
461: l_oe_Line_Adj_Assoc_tbl oe_order_pub.Line_Adj_Assoc_Tbl_Type;
462: l_oe_line_scr_tbl oe_order_pub.line_scredit_tbl_type;
463: l_oe_Line_Scredit_Val_Tbl oe_order_pub.line_scredit_val_tbl_type;
464: l_oe_Lot_Serial_Tbl oe_order_pub.lot_serial_tbl_type;
465: l_oe_Lot_Serial_Val_Tbl oe_order_pub.lot_serial_val_tbl_type;

Line 462: l_oe_line_scr_tbl oe_order_pub.line_scredit_tbl_type;

458: l_oe_Line_Adj_Val_Tbl oe_order_pub.line_adj_val_tbl_type;
459: l_oe_Line_Price_Att_Tbl oe_order_pub.line_price_att_tbl_type;
460: l_oe_Line_Adj_Att_Tbl oe_order_pub.line_adj_att_tbl_type;
461: l_oe_Line_Adj_Assoc_tbl oe_order_pub.Line_Adj_Assoc_Tbl_Type;
462: l_oe_line_scr_tbl oe_order_pub.line_scredit_tbl_type;
463: l_oe_Line_Scredit_Val_Tbl oe_order_pub.line_scredit_val_tbl_type;
464: l_oe_Lot_Serial_Tbl oe_order_pub.lot_serial_tbl_type;
465: l_oe_Lot_Serial_Val_Tbl oe_order_pub.lot_serial_val_tbl_type;
466: l_oe_Request_Tbl_Type oe_order_pub.Request_tbl_type;

Line 463: l_oe_Line_Scredit_Val_Tbl oe_order_pub.line_scredit_val_tbl_type;

459: l_oe_Line_Price_Att_Tbl oe_order_pub.line_price_att_tbl_type;
460: l_oe_Line_Adj_Att_Tbl oe_order_pub.line_adj_att_tbl_type;
461: l_oe_Line_Adj_Assoc_tbl oe_order_pub.Line_Adj_Assoc_Tbl_Type;
462: l_oe_line_scr_tbl oe_order_pub.line_scredit_tbl_type;
463: l_oe_Line_Scredit_Val_Tbl oe_order_pub.line_scredit_val_tbl_type;
464: l_oe_Lot_Serial_Tbl oe_order_pub.lot_serial_tbl_type;
465: l_oe_Lot_Serial_Val_Tbl oe_order_pub.lot_serial_val_tbl_type;
466: l_oe_Request_Tbl_Type oe_order_pub.Request_tbl_type;
467: l_oe_control_rec OE_GLOBALS.Control_Rec_Type;

Line 464: l_oe_Lot_Serial_Tbl oe_order_pub.lot_serial_tbl_type;

460: l_oe_Line_Adj_Att_Tbl oe_order_pub.line_adj_att_tbl_type;
461: l_oe_Line_Adj_Assoc_tbl oe_order_pub.Line_Adj_Assoc_Tbl_Type;
462: l_oe_line_scr_tbl oe_order_pub.line_scredit_tbl_type;
463: l_oe_Line_Scredit_Val_Tbl oe_order_pub.line_scredit_val_tbl_type;
464: l_oe_Lot_Serial_Tbl oe_order_pub.lot_serial_tbl_type;
465: l_oe_Lot_Serial_Val_Tbl oe_order_pub.lot_serial_val_tbl_type;
466: l_oe_Request_Tbl_Type oe_order_pub.Request_tbl_type;
467: l_oe_control_rec OE_GLOBALS.Control_Rec_Type;
468:

Line 465: l_oe_Lot_Serial_Val_Tbl oe_order_pub.lot_serial_val_tbl_type;

461: l_oe_Line_Adj_Assoc_tbl oe_order_pub.Line_Adj_Assoc_Tbl_Type;
462: l_oe_line_scr_tbl oe_order_pub.line_scredit_tbl_type;
463: l_oe_Line_Scredit_Val_Tbl oe_order_pub.line_scredit_val_tbl_type;
464: l_oe_Lot_Serial_Tbl oe_order_pub.lot_serial_tbl_type;
465: l_oe_Lot_Serial_Val_Tbl oe_order_pub.lot_serial_val_tbl_type;
466: l_oe_Request_Tbl_Type oe_order_pub.Request_tbl_type;
467: l_oe_control_rec OE_GLOBALS.Control_Rec_Type;
468:
469: l_oe_header_id NUMBER;

Line 466: l_oe_Request_Tbl_Type oe_order_pub.Request_tbl_type;

462: l_oe_line_scr_tbl oe_order_pub.line_scredit_tbl_type;
463: l_oe_Line_Scredit_Val_Tbl oe_order_pub.line_scredit_val_tbl_type;
464: l_oe_Lot_Serial_Tbl oe_order_pub.lot_serial_tbl_type;
465: l_oe_Lot_Serial_Val_Tbl oe_order_pub.lot_serial_val_tbl_type;
466: l_oe_Request_Tbl_Type oe_order_pub.Request_tbl_type;
467: l_oe_control_rec OE_GLOBALS.Control_Rec_Type;
468:
469: l_oe_header_id NUMBER;
470: j number := 0;

Line 700: OE_Order_PUB.Process_Order(

696: l_oe_control_rec.clear_api_cache := FALSE;
697: l_oe_control_rec.clear_api_requests := FALSE;
698:
699: -- Call to Process Order
700: OE_Order_PUB.Process_Order(
701: p_org_id => l_source_operating_unit
702: , p_api_version_number => l_api_version_number
703: ,p_init_msg_list => FND_API.G_TRUE
704: ,p_return_values => FND_API.G_FALSE

Line 836: OE_Order_PUB.Process_Order(

832: l_oe_line_Tbl(i).operation := null;
833: END LOOP;
834:
835: -- call to Process Order
836: OE_Order_PUB.Process_Order(
837: p_api_version_number => l_api_version_number
838: ,p_init_msg_list => FND_API.G_TRUE
839: ,p_return_values => FND_API.G_FALSE
840: ,p_action_commit => FND_API.G_FALSE

Line 968: l_action_request_tbl oe_order_pub.request_tbl_type;

964: ,x_msg_count OUT NOCOPY NUMBER
965: ,x_msg_data OUT NOCOPY VARCHAR2
966: )
967: IS
968: l_action_request_tbl oe_order_pub.request_tbl_type;
969: l_api_version_number CONSTANT NUMBER := 1.0;
970: l_api_name CONSTANT VARCHAR2(30) := 'process_order';
971: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
972: l_msg_count NUMBER;

Line 1022: l_oe_header_rec oe_order_pub.header_rec_type := OE_ORDER_PUB.G_MISS_HEADER_REC;

1018:
1019: l_transferred_to_oe_flag VARCHAR2(1) := 'Y';
1020: l_msg varchar2(2000);
1021: -- Record and table types for oe process_order
1022: l_oe_header_rec oe_order_pub.header_rec_type := OE_ORDER_PUB.G_MISS_HEADER_REC;
1023: lx_oe_header_rec oe_order_pub.header_rec_type := OE_ORDER_PUB.G_MISS_HEADER_REC;
1024: l_oe_Header_Val_rec oe_order_pub.header_val_rec_type := OE_ORDER_PUB.G_MISS_HEADER_VAL_REC;
1025:
1026: l_oe_header_adj_tbl oe_order_pub.header_adj_tbl_type;

Line 1023: lx_oe_header_rec oe_order_pub.header_rec_type := OE_ORDER_PUB.G_MISS_HEADER_REC;

1019: l_transferred_to_oe_flag VARCHAR2(1) := 'Y';
1020: l_msg varchar2(2000);
1021: -- Record and table types for oe process_order
1022: l_oe_header_rec oe_order_pub.header_rec_type := OE_ORDER_PUB.G_MISS_HEADER_REC;
1023: lx_oe_header_rec oe_order_pub.header_rec_type := OE_ORDER_PUB.G_MISS_HEADER_REC;
1024: l_oe_Header_Val_rec oe_order_pub.header_val_rec_type := OE_ORDER_PUB.G_MISS_HEADER_VAL_REC;
1025:
1026: l_oe_header_adj_tbl oe_order_pub.header_adj_tbl_type;
1027: l_oe_header_adj_val_tbl oe_order_pub.header_adj_val_tbl_type;

Line 1024: l_oe_Header_Val_rec oe_order_pub.header_val_rec_type := OE_ORDER_PUB.G_MISS_HEADER_VAL_REC;

1020: l_msg varchar2(2000);
1021: -- Record and table types for oe process_order
1022: l_oe_header_rec oe_order_pub.header_rec_type := OE_ORDER_PUB.G_MISS_HEADER_REC;
1023: lx_oe_header_rec oe_order_pub.header_rec_type := OE_ORDER_PUB.G_MISS_HEADER_REC;
1024: l_oe_Header_Val_rec oe_order_pub.header_val_rec_type := OE_ORDER_PUB.G_MISS_HEADER_VAL_REC;
1025:
1026: l_oe_header_adj_tbl oe_order_pub.header_adj_tbl_type;
1027: l_oe_header_adj_val_tbl oe_order_pub.header_adj_val_tbl_type;
1028: l_oe_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;

Line 1026: l_oe_header_adj_tbl oe_order_pub.header_adj_tbl_type;

1022: l_oe_header_rec oe_order_pub.header_rec_type := OE_ORDER_PUB.G_MISS_HEADER_REC;
1023: lx_oe_header_rec oe_order_pub.header_rec_type := OE_ORDER_PUB.G_MISS_HEADER_REC;
1024: l_oe_Header_Val_rec oe_order_pub.header_val_rec_type := OE_ORDER_PUB.G_MISS_HEADER_VAL_REC;
1025:
1026: l_oe_header_adj_tbl oe_order_pub.header_adj_tbl_type;
1027: l_oe_header_adj_val_tbl oe_order_pub.header_adj_val_tbl_type;
1028: l_oe_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
1029: l_oe_Header_Adj_Att_Tbl oe_order_pub.header_adj_att_tbl_type;
1030: l_oe_Header_Adj_Assoc_Tbl oe_order_pub.header_adj_assoc_tbl_type;

Line 1027: l_oe_header_adj_val_tbl oe_order_pub.header_adj_val_tbl_type;

1023: lx_oe_header_rec oe_order_pub.header_rec_type := OE_ORDER_PUB.G_MISS_HEADER_REC;
1024: l_oe_Header_Val_rec oe_order_pub.header_val_rec_type := OE_ORDER_PUB.G_MISS_HEADER_VAL_REC;
1025:
1026: l_oe_header_adj_tbl oe_order_pub.header_adj_tbl_type;
1027: l_oe_header_adj_val_tbl oe_order_pub.header_adj_val_tbl_type;
1028: l_oe_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
1029: l_oe_Header_Adj_Att_Tbl oe_order_pub.header_adj_att_tbl_type;
1030: l_oe_Header_Adj_Assoc_Tbl oe_order_pub.header_adj_assoc_tbl_type;
1031: l_oe_header_scr_tbl OE_ORDER_PUB.header_scredit_tbl_type;

Line 1028: l_oe_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;

1024: l_oe_Header_Val_rec oe_order_pub.header_val_rec_type := OE_ORDER_PUB.G_MISS_HEADER_VAL_REC;
1025:
1026: l_oe_header_adj_tbl oe_order_pub.header_adj_tbl_type;
1027: l_oe_header_adj_val_tbl oe_order_pub.header_adj_val_tbl_type;
1028: l_oe_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
1029: l_oe_Header_Adj_Att_Tbl oe_order_pub.header_adj_att_tbl_type;
1030: l_oe_Header_Adj_Assoc_Tbl oe_order_pub.header_adj_assoc_tbl_type;
1031: l_oe_header_scr_tbl OE_ORDER_PUB.header_scredit_tbl_type;
1032: l_oe_Header_Scredit_Val_Tbl OE_ORDER_PUB.header_scredit_Val_tbl_type;

Line 1029: l_oe_Header_Adj_Att_Tbl oe_order_pub.header_adj_att_tbl_type;

1025:
1026: l_oe_header_adj_tbl oe_order_pub.header_adj_tbl_type;
1027: l_oe_header_adj_val_tbl oe_order_pub.header_adj_val_tbl_type;
1028: l_oe_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
1029: l_oe_Header_Adj_Att_Tbl oe_order_pub.header_adj_att_tbl_type;
1030: l_oe_Header_Adj_Assoc_Tbl oe_order_pub.header_adj_assoc_tbl_type;
1031: l_oe_header_scr_tbl OE_ORDER_PUB.header_scredit_tbl_type;
1032: l_oe_Header_Scredit_Val_Tbl OE_ORDER_PUB.header_scredit_Val_tbl_type;
1033: l_oe_line_rec oe_order_pub.line_rec_type := OE_ORDER_PUB.G_MISS_LINE_REC;

Line 1030: l_oe_Header_Adj_Assoc_Tbl oe_order_pub.header_adj_assoc_tbl_type;

1026: l_oe_header_adj_tbl oe_order_pub.header_adj_tbl_type;
1027: l_oe_header_adj_val_tbl oe_order_pub.header_adj_val_tbl_type;
1028: l_oe_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
1029: l_oe_Header_Adj_Att_Tbl oe_order_pub.header_adj_att_tbl_type;
1030: l_oe_Header_Adj_Assoc_Tbl oe_order_pub.header_adj_assoc_tbl_type;
1031: l_oe_header_scr_tbl OE_ORDER_PUB.header_scredit_tbl_type;
1032: l_oe_Header_Scredit_Val_Tbl OE_ORDER_PUB.header_scredit_Val_tbl_type;
1033: l_oe_line_rec oe_order_pub.line_rec_type := OE_ORDER_PUB.G_MISS_LINE_REC;
1034: l_oe_line_tbl oe_order_pub.line_tbl_type := OE_ORDER_PUB.G_MISS_LINE_TBL;

Line 1031: l_oe_header_scr_tbl OE_ORDER_PUB.header_scredit_tbl_type;

1027: l_oe_header_adj_val_tbl oe_order_pub.header_adj_val_tbl_type;
1028: l_oe_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
1029: l_oe_Header_Adj_Att_Tbl oe_order_pub.header_adj_att_tbl_type;
1030: l_oe_Header_Adj_Assoc_Tbl oe_order_pub.header_adj_assoc_tbl_type;
1031: l_oe_header_scr_tbl OE_ORDER_PUB.header_scredit_tbl_type;
1032: l_oe_Header_Scredit_Val_Tbl OE_ORDER_PUB.header_scredit_Val_tbl_type;
1033: l_oe_line_rec oe_order_pub.line_rec_type := OE_ORDER_PUB.G_MISS_LINE_REC;
1034: l_oe_line_tbl oe_order_pub.line_tbl_type := OE_ORDER_PUB.G_MISS_LINE_TBL;
1035: lx_oe_line_tbl oe_order_pub.line_tbl_type := OE_ORDER_PUB.G_MISS_LINE_TBL;

Line 1032: l_oe_Header_Scredit_Val_Tbl OE_ORDER_PUB.header_scredit_Val_tbl_type;

1028: l_oe_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
1029: l_oe_Header_Adj_Att_Tbl oe_order_pub.header_adj_att_tbl_type;
1030: l_oe_Header_Adj_Assoc_Tbl oe_order_pub.header_adj_assoc_tbl_type;
1031: l_oe_header_scr_tbl OE_ORDER_PUB.header_scredit_tbl_type;
1032: l_oe_Header_Scredit_Val_Tbl OE_ORDER_PUB.header_scredit_Val_tbl_type;
1033: l_oe_line_rec oe_order_pub.line_rec_type := OE_ORDER_PUB.G_MISS_LINE_REC;
1034: l_oe_line_tbl oe_order_pub.line_tbl_type := OE_ORDER_PUB.G_MISS_LINE_TBL;
1035: lx_oe_line_tbl oe_order_pub.line_tbl_type := OE_ORDER_PUB.G_MISS_LINE_TBL;
1036: l_oe_Line_Val_Tbl oe_order_pub.line_Val_tbl_type := OE_ORDER_PUB.G_MISS_LINE_VAL_TBL;

Line 1033: l_oe_line_rec oe_order_pub.line_rec_type := OE_ORDER_PUB.G_MISS_LINE_REC;

1029: l_oe_Header_Adj_Att_Tbl oe_order_pub.header_adj_att_tbl_type;
1030: l_oe_Header_Adj_Assoc_Tbl oe_order_pub.header_adj_assoc_tbl_type;
1031: l_oe_header_scr_tbl OE_ORDER_PUB.header_scredit_tbl_type;
1032: l_oe_Header_Scredit_Val_Tbl OE_ORDER_PUB.header_scredit_Val_tbl_type;
1033: l_oe_line_rec oe_order_pub.line_rec_type := OE_ORDER_PUB.G_MISS_LINE_REC;
1034: l_oe_line_tbl oe_order_pub.line_tbl_type := OE_ORDER_PUB.G_MISS_LINE_TBL;
1035: lx_oe_line_tbl oe_order_pub.line_tbl_type := OE_ORDER_PUB.G_MISS_LINE_TBL;
1036: l_oe_Line_Val_Tbl oe_order_pub.line_Val_tbl_type := OE_ORDER_PUB.G_MISS_LINE_VAL_TBL;
1037: l_oe_line_adj_tbl oe_order_pub.line_adj_tbl_type := OE_ORDER_PUB.G_MISS_LINE_ADJ_TBL;

Line 1034: l_oe_line_tbl oe_order_pub.line_tbl_type := OE_ORDER_PUB.G_MISS_LINE_TBL;

1030: l_oe_Header_Adj_Assoc_Tbl oe_order_pub.header_adj_assoc_tbl_type;
1031: l_oe_header_scr_tbl OE_ORDER_PUB.header_scredit_tbl_type;
1032: l_oe_Header_Scredit_Val_Tbl OE_ORDER_PUB.header_scredit_Val_tbl_type;
1033: l_oe_line_rec oe_order_pub.line_rec_type := OE_ORDER_PUB.G_MISS_LINE_REC;
1034: l_oe_line_tbl oe_order_pub.line_tbl_type := OE_ORDER_PUB.G_MISS_LINE_TBL;
1035: lx_oe_line_tbl oe_order_pub.line_tbl_type := OE_ORDER_PUB.G_MISS_LINE_TBL;
1036: l_oe_Line_Val_Tbl oe_order_pub.line_Val_tbl_type := OE_ORDER_PUB.G_MISS_LINE_VAL_TBL;
1037: l_oe_line_adj_tbl oe_order_pub.line_adj_tbl_type := OE_ORDER_PUB.G_MISS_LINE_ADJ_TBL;
1038: l_oe_Line_Adj_Val_Tbl oe_order_pub.line_adj_val_tbl_type := OE_ORDER_PUB.G_MISS_LINE_ADJ_VAL_TBL;

Line 1035: lx_oe_line_tbl oe_order_pub.line_tbl_type := OE_ORDER_PUB.G_MISS_LINE_TBL;

1031: l_oe_header_scr_tbl OE_ORDER_PUB.header_scredit_tbl_type;
1032: l_oe_Header_Scredit_Val_Tbl OE_ORDER_PUB.header_scredit_Val_tbl_type;
1033: l_oe_line_rec oe_order_pub.line_rec_type := OE_ORDER_PUB.G_MISS_LINE_REC;
1034: l_oe_line_tbl oe_order_pub.line_tbl_type := OE_ORDER_PUB.G_MISS_LINE_TBL;
1035: lx_oe_line_tbl oe_order_pub.line_tbl_type := OE_ORDER_PUB.G_MISS_LINE_TBL;
1036: l_oe_Line_Val_Tbl oe_order_pub.line_Val_tbl_type := OE_ORDER_PUB.G_MISS_LINE_VAL_TBL;
1037: l_oe_line_adj_tbl oe_order_pub.line_adj_tbl_type := OE_ORDER_PUB.G_MISS_LINE_ADJ_TBL;
1038: l_oe_Line_Adj_Val_Tbl oe_order_pub.line_adj_val_tbl_type := OE_ORDER_PUB.G_MISS_LINE_ADJ_VAL_TBL;
1039: l_oe_Line_Price_Att_Tbl oe_order_pub.line_price_att_tbl_type := OE_ORDER_PUB.G_MISS_LINE_PRICE_ATT_TBL;

Line 1036: l_oe_Line_Val_Tbl oe_order_pub.line_Val_tbl_type := OE_ORDER_PUB.G_MISS_LINE_VAL_TBL;

1032: l_oe_Header_Scredit_Val_Tbl OE_ORDER_PUB.header_scredit_Val_tbl_type;
1033: l_oe_line_rec oe_order_pub.line_rec_type := OE_ORDER_PUB.G_MISS_LINE_REC;
1034: l_oe_line_tbl oe_order_pub.line_tbl_type := OE_ORDER_PUB.G_MISS_LINE_TBL;
1035: lx_oe_line_tbl oe_order_pub.line_tbl_type := OE_ORDER_PUB.G_MISS_LINE_TBL;
1036: l_oe_Line_Val_Tbl oe_order_pub.line_Val_tbl_type := OE_ORDER_PUB.G_MISS_LINE_VAL_TBL;
1037: l_oe_line_adj_tbl oe_order_pub.line_adj_tbl_type := OE_ORDER_PUB.G_MISS_LINE_ADJ_TBL;
1038: l_oe_Line_Adj_Val_Tbl oe_order_pub.line_adj_val_tbl_type := OE_ORDER_PUB.G_MISS_LINE_ADJ_VAL_TBL;
1039: l_oe_Line_Price_Att_Tbl oe_order_pub.line_price_att_tbl_type := OE_ORDER_PUB.G_MISS_LINE_PRICE_ATT_TBL;
1040: l_oe_Line_Adj_Att_Tbl oe_order_pub.line_adj_att_tbl_type := OE_ORDER_PUB.G_MISS_LINE_ADJ_ATT_TBL;

Line 1037: l_oe_line_adj_tbl oe_order_pub.line_adj_tbl_type := OE_ORDER_PUB.G_MISS_LINE_ADJ_TBL;

1033: l_oe_line_rec oe_order_pub.line_rec_type := OE_ORDER_PUB.G_MISS_LINE_REC;
1034: l_oe_line_tbl oe_order_pub.line_tbl_type := OE_ORDER_PUB.G_MISS_LINE_TBL;
1035: lx_oe_line_tbl oe_order_pub.line_tbl_type := OE_ORDER_PUB.G_MISS_LINE_TBL;
1036: l_oe_Line_Val_Tbl oe_order_pub.line_Val_tbl_type := OE_ORDER_PUB.G_MISS_LINE_VAL_TBL;
1037: l_oe_line_adj_tbl oe_order_pub.line_adj_tbl_type := OE_ORDER_PUB.G_MISS_LINE_ADJ_TBL;
1038: l_oe_Line_Adj_Val_Tbl oe_order_pub.line_adj_val_tbl_type := OE_ORDER_PUB.G_MISS_LINE_ADJ_VAL_TBL;
1039: l_oe_Line_Price_Att_Tbl oe_order_pub.line_price_att_tbl_type := OE_ORDER_PUB.G_MISS_LINE_PRICE_ATT_TBL;
1040: l_oe_Line_Adj_Att_Tbl oe_order_pub.line_adj_att_tbl_type := OE_ORDER_PUB.G_MISS_LINE_ADJ_ATT_TBL;
1041: l_oe_Line_Adj_Assoc_tbl oe_order_pub.Line_Adj_Assoc_Tbl_Type := OE_ORDER_PUB.G_MISS_LINE_ADJ_ASSOC_TBL;

Line 1038: l_oe_Line_Adj_Val_Tbl oe_order_pub.line_adj_val_tbl_type := OE_ORDER_PUB.G_MISS_LINE_ADJ_VAL_TBL;

1034: l_oe_line_tbl oe_order_pub.line_tbl_type := OE_ORDER_PUB.G_MISS_LINE_TBL;
1035: lx_oe_line_tbl oe_order_pub.line_tbl_type := OE_ORDER_PUB.G_MISS_LINE_TBL;
1036: l_oe_Line_Val_Tbl oe_order_pub.line_Val_tbl_type := OE_ORDER_PUB.G_MISS_LINE_VAL_TBL;
1037: l_oe_line_adj_tbl oe_order_pub.line_adj_tbl_type := OE_ORDER_PUB.G_MISS_LINE_ADJ_TBL;
1038: l_oe_Line_Adj_Val_Tbl oe_order_pub.line_adj_val_tbl_type := OE_ORDER_PUB.G_MISS_LINE_ADJ_VAL_TBL;
1039: l_oe_Line_Price_Att_Tbl oe_order_pub.line_price_att_tbl_type := OE_ORDER_PUB.G_MISS_LINE_PRICE_ATT_TBL;
1040: l_oe_Line_Adj_Att_Tbl oe_order_pub.line_adj_att_tbl_type := OE_ORDER_PUB.G_MISS_LINE_ADJ_ATT_TBL;
1041: l_oe_Line_Adj_Assoc_tbl oe_order_pub.Line_Adj_Assoc_Tbl_Type := OE_ORDER_PUB.G_MISS_LINE_ADJ_ASSOC_TBL;
1042: l_oe_line_scr_tbl oe_order_pub.line_scredit_tbl_type := OE_ORDER_PUB.G_MISS_LINE_SCREDIT_TBL;

Line 1039: l_oe_Line_Price_Att_Tbl oe_order_pub.line_price_att_tbl_type := OE_ORDER_PUB.G_MISS_LINE_PRICE_ATT_TBL;

1035: lx_oe_line_tbl oe_order_pub.line_tbl_type := OE_ORDER_PUB.G_MISS_LINE_TBL;
1036: l_oe_Line_Val_Tbl oe_order_pub.line_Val_tbl_type := OE_ORDER_PUB.G_MISS_LINE_VAL_TBL;
1037: l_oe_line_adj_tbl oe_order_pub.line_adj_tbl_type := OE_ORDER_PUB.G_MISS_LINE_ADJ_TBL;
1038: l_oe_Line_Adj_Val_Tbl oe_order_pub.line_adj_val_tbl_type := OE_ORDER_PUB.G_MISS_LINE_ADJ_VAL_TBL;
1039: l_oe_Line_Price_Att_Tbl oe_order_pub.line_price_att_tbl_type := OE_ORDER_PUB.G_MISS_LINE_PRICE_ATT_TBL;
1040: l_oe_Line_Adj_Att_Tbl oe_order_pub.line_adj_att_tbl_type := OE_ORDER_PUB.G_MISS_LINE_ADJ_ATT_TBL;
1041: l_oe_Line_Adj_Assoc_tbl oe_order_pub.Line_Adj_Assoc_Tbl_Type := OE_ORDER_PUB.G_MISS_LINE_ADJ_ASSOC_TBL;
1042: l_oe_line_scr_tbl oe_order_pub.line_scredit_tbl_type := OE_ORDER_PUB.G_MISS_LINE_SCREDIT_TBL;
1043: l_oe_Line_Scredit_Val_Tbl oe_order_pub.line_scredit_val_tbl_type;

Line 1040: l_oe_Line_Adj_Att_Tbl oe_order_pub.line_adj_att_tbl_type := OE_ORDER_PUB.G_MISS_LINE_ADJ_ATT_TBL;

1036: l_oe_Line_Val_Tbl oe_order_pub.line_Val_tbl_type := OE_ORDER_PUB.G_MISS_LINE_VAL_TBL;
1037: l_oe_line_adj_tbl oe_order_pub.line_adj_tbl_type := OE_ORDER_PUB.G_MISS_LINE_ADJ_TBL;
1038: l_oe_Line_Adj_Val_Tbl oe_order_pub.line_adj_val_tbl_type := OE_ORDER_PUB.G_MISS_LINE_ADJ_VAL_TBL;
1039: l_oe_Line_Price_Att_Tbl oe_order_pub.line_price_att_tbl_type := OE_ORDER_PUB.G_MISS_LINE_PRICE_ATT_TBL;
1040: l_oe_Line_Adj_Att_Tbl oe_order_pub.line_adj_att_tbl_type := OE_ORDER_PUB.G_MISS_LINE_ADJ_ATT_TBL;
1041: l_oe_Line_Adj_Assoc_tbl oe_order_pub.Line_Adj_Assoc_Tbl_Type := OE_ORDER_PUB.G_MISS_LINE_ADJ_ASSOC_TBL;
1042: l_oe_line_scr_tbl oe_order_pub.line_scredit_tbl_type := OE_ORDER_PUB.G_MISS_LINE_SCREDIT_TBL;
1043: l_oe_Line_Scredit_Val_Tbl oe_order_pub.line_scredit_val_tbl_type;
1044: l_oe_Lot_Serial_Tbl oe_order_pub.lot_serial_tbl_type;

Line 1041: l_oe_Line_Adj_Assoc_tbl oe_order_pub.Line_Adj_Assoc_Tbl_Type := OE_ORDER_PUB.G_MISS_LINE_ADJ_ASSOC_TBL;

1037: l_oe_line_adj_tbl oe_order_pub.line_adj_tbl_type := OE_ORDER_PUB.G_MISS_LINE_ADJ_TBL;
1038: l_oe_Line_Adj_Val_Tbl oe_order_pub.line_adj_val_tbl_type := OE_ORDER_PUB.G_MISS_LINE_ADJ_VAL_TBL;
1039: l_oe_Line_Price_Att_Tbl oe_order_pub.line_price_att_tbl_type := OE_ORDER_PUB.G_MISS_LINE_PRICE_ATT_TBL;
1040: l_oe_Line_Adj_Att_Tbl oe_order_pub.line_adj_att_tbl_type := OE_ORDER_PUB.G_MISS_LINE_ADJ_ATT_TBL;
1041: l_oe_Line_Adj_Assoc_tbl oe_order_pub.Line_Adj_Assoc_Tbl_Type := OE_ORDER_PUB.G_MISS_LINE_ADJ_ASSOC_TBL;
1042: l_oe_line_scr_tbl oe_order_pub.line_scredit_tbl_type := OE_ORDER_PUB.G_MISS_LINE_SCREDIT_TBL;
1043: l_oe_Line_Scredit_Val_Tbl oe_order_pub.line_scredit_val_tbl_type;
1044: l_oe_Lot_Serial_Tbl oe_order_pub.lot_serial_tbl_type;
1045: l_oe_Lot_Serial_Val_Tbl oe_order_pub.lot_serial_val_tbl_type;

Line 1042: l_oe_line_scr_tbl oe_order_pub.line_scredit_tbl_type := OE_ORDER_PUB.G_MISS_LINE_SCREDIT_TBL;

1038: l_oe_Line_Adj_Val_Tbl oe_order_pub.line_adj_val_tbl_type := OE_ORDER_PUB.G_MISS_LINE_ADJ_VAL_TBL;
1039: l_oe_Line_Price_Att_Tbl oe_order_pub.line_price_att_tbl_type := OE_ORDER_PUB.G_MISS_LINE_PRICE_ATT_TBL;
1040: l_oe_Line_Adj_Att_Tbl oe_order_pub.line_adj_att_tbl_type := OE_ORDER_PUB.G_MISS_LINE_ADJ_ATT_TBL;
1041: l_oe_Line_Adj_Assoc_tbl oe_order_pub.Line_Adj_Assoc_Tbl_Type := OE_ORDER_PUB.G_MISS_LINE_ADJ_ASSOC_TBL;
1042: l_oe_line_scr_tbl oe_order_pub.line_scredit_tbl_type := OE_ORDER_PUB.G_MISS_LINE_SCREDIT_TBL;
1043: l_oe_Line_Scredit_Val_Tbl oe_order_pub.line_scredit_val_tbl_type;
1044: l_oe_Lot_Serial_Tbl oe_order_pub.lot_serial_tbl_type;
1045: l_oe_Lot_Serial_Val_Tbl oe_order_pub.lot_serial_val_tbl_type;
1046: l_oe_Request_Tbl_Type oe_order_pub.Request_tbl_type := OE_ORDER_PUB.G_MISS_REQUEST_TBL;

Line 1043: l_oe_Line_Scredit_Val_Tbl oe_order_pub.line_scredit_val_tbl_type;

1039: l_oe_Line_Price_Att_Tbl oe_order_pub.line_price_att_tbl_type := OE_ORDER_PUB.G_MISS_LINE_PRICE_ATT_TBL;
1040: l_oe_Line_Adj_Att_Tbl oe_order_pub.line_adj_att_tbl_type := OE_ORDER_PUB.G_MISS_LINE_ADJ_ATT_TBL;
1041: l_oe_Line_Adj_Assoc_tbl oe_order_pub.Line_Adj_Assoc_Tbl_Type := OE_ORDER_PUB.G_MISS_LINE_ADJ_ASSOC_TBL;
1042: l_oe_line_scr_tbl oe_order_pub.line_scredit_tbl_type := OE_ORDER_PUB.G_MISS_LINE_SCREDIT_TBL;
1043: l_oe_Line_Scredit_Val_Tbl oe_order_pub.line_scredit_val_tbl_type;
1044: l_oe_Lot_Serial_Tbl oe_order_pub.lot_serial_tbl_type;
1045: l_oe_Lot_Serial_Val_Tbl oe_order_pub.lot_serial_val_tbl_type;
1046: l_oe_Request_Tbl_Type oe_order_pub.Request_tbl_type := OE_ORDER_PUB.G_MISS_REQUEST_TBL;
1047: l_oe_control_rec OE_GLOBALS.Control_Rec_Type;

Line 1044: l_oe_Lot_Serial_Tbl oe_order_pub.lot_serial_tbl_type;

1040: l_oe_Line_Adj_Att_Tbl oe_order_pub.line_adj_att_tbl_type := OE_ORDER_PUB.G_MISS_LINE_ADJ_ATT_TBL;
1041: l_oe_Line_Adj_Assoc_tbl oe_order_pub.Line_Adj_Assoc_Tbl_Type := OE_ORDER_PUB.G_MISS_LINE_ADJ_ASSOC_TBL;
1042: l_oe_line_scr_tbl oe_order_pub.line_scredit_tbl_type := OE_ORDER_PUB.G_MISS_LINE_SCREDIT_TBL;
1043: l_oe_Line_Scredit_Val_Tbl oe_order_pub.line_scredit_val_tbl_type;
1044: l_oe_Lot_Serial_Tbl oe_order_pub.lot_serial_tbl_type;
1045: l_oe_Lot_Serial_Val_Tbl oe_order_pub.lot_serial_val_tbl_type;
1046: l_oe_Request_Tbl_Type oe_order_pub.Request_tbl_type := OE_ORDER_PUB.G_MISS_REQUEST_TBL;
1047: l_oe_control_rec OE_GLOBALS.Control_Rec_Type;
1048:

Line 1045: l_oe_Lot_Serial_Val_Tbl oe_order_pub.lot_serial_val_tbl_type;

1041: l_oe_Line_Adj_Assoc_tbl oe_order_pub.Line_Adj_Assoc_Tbl_Type := OE_ORDER_PUB.G_MISS_LINE_ADJ_ASSOC_TBL;
1042: l_oe_line_scr_tbl oe_order_pub.line_scredit_tbl_type := OE_ORDER_PUB.G_MISS_LINE_SCREDIT_TBL;
1043: l_oe_Line_Scredit_Val_Tbl oe_order_pub.line_scredit_val_tbl_type;
1044: l_oe_Lot_Serial_Tbl oe_order_pub.lot_serial_tbl_type;
1045: l_oe_Lot_Serial_Val_Tbl oe_order_pub.lot_serial_val_tbl_type;
1046: l_oe_Request_Tbl_Type oe_order_pub.Request_tbl_type := OE_ORDER_PUB.G_MISS_REQUEST_TBL;
1047: l_oe_control_rec OE_GLOBALS.Control_Rec_Type;
1048:
1049: CURSOR rowid_cur IS

Line 1046: l_oe_Request_Tbl_Type oe_order_pub.Request_tbl_type := OE_ORDER_PUB.G_MISS_REQUEST_TBL;

1042: l_oe_line_scr_tbl oe_order_pub.line_scredit_tbl_type := OE_ORDER_PUB.G_MISS_LINE_SCREDIT_TBL;
1043: l_oe_Line_Scredit_Val_Tbl oe_order_pub.line_scredit_val_tbl_type;
1044: l_oe_Lot_Serial_Tbl oe_order_pub.lot_serial_tbl_type;
1045: l_oe_Lot_Serial_Val_Tbl oe_order_pub.lot_serial_val_tbl_type;
1046: l_oe_Request_Tbl_Type oe_order_pub.Request_tbl_type := OE_ORDER_PUB.G_MISS_REQUEST_TBL;
1047: l_oe_control_rec OE_GLOBALS.Control_Rec_Type;
1048:
1049: CURSOR rowid_cur IS
1050: SELECT rowid FROM PO_REQUISITION_HEADERS

Line 2603: 'Now finally calling OE_Order_PUB.Process_Order for operation = '

2599:
2600: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2601: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2602: 'csp.plsql.csp_parts_order.process_order',
2603: 'Now finally calling OE_Order_PUB.Process_Order for operation = '
2604: || l_oe_header_rec.operation);
2605: end if;
2606:
2607: -- CALL TO PROCESS ORDER

Line 2612: OE_Order_PUB.Process_Order(

2608: IF (l_oe_header_rec.operation = OE_GLOBALS.G_OPR_CREATE) THEN
2609: -- CALL TO PROCESS ORDER
2610: l_action_request_tbl(1).entity_code := OE_GLOBALS.G_ENTITY_HEADER;
2611: l_action_request_tbl(1).request_type := OE_GLOBALS.G_BOOK_ORDER;
2612: OE_Order_PUB.Process_Order(
2613: p_org_id => l_source_operating_unit
2614: ,p_api_version_number => l_api_version_number
2615: ,p_init_msg_list => FND_API.G_TRUE
2616: ,p_return_values => FND_API.G_FALSE

Line 2651: OE_Order_PUB.Process_Order(

2647: ,x_msg_data => l_msg_data
2648: );
2649: ELSE
2650: --p_action_request_tbl => l_action_request_tbl
2651: OE_Order_PUB.Process_Order(
2652: p_org_id => l_source_operating_unit
2653: ,p_api_version_number => l_api_version_number
2654: ,p_init_msg_list => FND_API.G_TRUE
2655: ,p_return_values => FND_API.G_FALSE

Line 2707: 'Error in OE_Order_PUB.Process_Order API... Message = '

2703:
2704: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2705: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2706: 'csp.plsql.csp_parts_order.process_order',
2707: 'Error in OE_Order_PUB.Process_Order API... Message = '
2708: || l_msg);
2709: end if;
2710:
2711: RAISE FND_API.G_EXC_ERROR;