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 770: OE_Order_PUB.Process_Order(

766: 'OE Debug File : '|| OE_DEBUG_PUB.Set_Debug_Mode('FILE'));
767: end if;
768:
769: -- Call to Process Order
770: OE_Order_PUB.Process_Order(
771: p_org_id => l_source_operating_unit
772: , p_api_version_number => l_api_version_number
773: ,p_init_msg_list => FND_API.G_TRUE
774: ,p_return_values => FND_API.G_FALSE

Line 929: OE_Order_PUB.Process_Order(

925: 'OE Debug File : '|| OE_DEBUG_PUB.Set_Debug_Mode('FILE'));
926: end if;
927:
928: -- call to Process Order
929: OE_Order_PUB.Process_Order(
930: p_org_id => l_source_operating_unit
931: ,p_api_version_number => l_api_version_number
932: ,p_init_msg_list => FND_API.G_TRUE
933: ,p_return_values => FND_API.G_FALSE

Line 1090: l_action_request_tbl oe_order_pub.request_tbl_type;

1086: ,x_msg_count OUT NOCOPY NUMBER
1087: ,x_msg_data OUT NOCOPY VARCHAR2
1088: )
1089: IS
1090: l_action_request_tbl oe_order_pub.request_tbl_type;
1091: l_api_version_number CONSTANT NUMBER := 1.0;
1092: l_api_name CONSTANT VARCHAR2(30) := 'process_order';
1093: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1094: l_msg_count NUMBER;

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

1140:
1141: l_transferred_to_oe_flag VARCHAR2(1) := 'Y';
1142: l_msg varchar2(2000);
1143: -- Record and table types for oe process_order
1144: l_oe_header_rec oe_order_pub.header_rec_type := OE_ORDER_PUB.G_MISS_HEADER_REC;
1145: lx_oe_header_rec oe_order_pub.header_rec_type := OE_ORDER_PUB.G_MISS_HEADER_REC;
1146: l_oe_Header_Val_rec oe_order_pub.header_val_rec_type := OE_ORDER_PUB.G_MISS_HEADER_VAL_REC;
1147:
1148: l_oe_header_adj_tbl oe_order_pub.header_adj_tbl_type;

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

1141: l_transferred_to_oe_flag VARCHAR2(1) := 'Y';
1142: l_msg varchar2(2000);
1143: -- Record and table types for oe process_order
1144: l_oe_header_rec oe_order_pub.header_rec_type := OE_ORDER_PUB.G_MISS_HEADER_REC;
1145: lx_oe_header_rec oe_order_pub.header_rec_type := OE_ORDER_PUB.G_MISS_HEADER_REC;
1146: l_oe_Header_Val_rec oe_order_pub.header_val_rec_type := OE_ORDER_PUB.G_MISS_HEADER_VAL_REC;
1147:
1148: l_oe_header_adj_tbl oe_order_pub.header_adj_tbl_type;
1149: l_oe_header_adj_val_tbl oe_order_pub.header_adj_val_tbl_type;

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

1142: l_msg varchar2(2000);
1143: -- Record and table types for oe process_order
1144: l_oe_header_rec oe_order_pub.header_rec_type := OE_ORDER_PUB.G_MISS_HEADER_REC;
1145: lx_oe_header_rec oe_order_pub.header_rec_type := OE_ORDER_PUB.G_MISS_HEADER_REC;
1146: l_oe_Header_Val_rec oe_order_pub.header_val_rec_type := OE_ORDER_PUB.G_MISS_HEADER_VAL_REC;
1147:
1148: l_oe_header_adj_tbl oe_order_pub.header_adj_tbl_type;
1149: l_oe_header_adj_val_tbl oe_order_pub.header_adj_val_tbl_type;
1150: l_oe_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;

Line 1148: l_oe_header_adj_tbl oe_order_pub.header_adj_tbl_type;

1144: l_oe_header_rec oe_order_pub.header_rec_type := OE_ORDER_PUB.G_MISS_HEADER_REC;
1145: lx_oe_header_rec oe_order_pub.header_rec_type := OE_ORDER_PUB.G_MISS_HEADER_REC;
1146: l_oe_Header_Val_rec oe_order_pub.header_val_rec_type := OE_ORDER_PUB.G_MISS_HEADER_VAL_REC;
1147:
1148: l_oe_header_adj_tbl oe_order_pub.header_adj_tbl_type;
1149: l_oe_header_adj_val_tbl oe_order_pub.header_adj_val_tbl_type;
1150: l_oe_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
1151: l_oe_Header_Adj_Att_Tbl oe_order_pub.header_adj_att_tbl_type;
1152: l_oe_Header_Adj_Assoc_Tbl oe_order_pub.header_adj_assoc_tbl_type;

Line 1149: l_oe_header_adj_val_tbl oe_order_pub.header_adj_val_tbl_type;

1145: lx_oe_header_rec oe_order_pub.header_rec_type := OE_ORDER_PUB.G_MISS_HEADER_REC;
1146: l_oe_Header_Val_rec oe_order_pub.header_val_rec_type := OE_ORDER_PUB.G_MISS_HEADER_VAL_REC;
1147:
1148: l_oe_header_adj_tbl oe_order_pub.header_adj_tbl_type;
1149: l_oe_header_adj_val_tbl oe_order_pub.header_adj_val_tbl_type;
1150: l_oe_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
1151: l_oe_Header_Adj_Att_Tbl oe_order_pub.header_adj_att_tbl_type;
1152: l_oe_Header_Adj_Assoc_Tbl oe_order_pub.header_adj_assoc_tbl_type;
1153: l_oe_header_scr_tbl OE_ORDER_PUB.header_scredit_tbl_type;

Line 1150: l_oe_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;

1146: l_oe_Header_Val_rec oe_order_pub.header_val_rec_type := OE_ORDER_PUB.G_MISS_HEADER_VAL_REC;
1147:
1148: l_oe_header_adj_tbl oe_order_pub.header_adj_tbl_type;
1149: l_oe_header_adj_val_tbl oe_order_pub.header_adj_val_tbl_type;
1150: l_oe_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
1151: l_oe_Header_Adj_Att_Tbl oe_order_pub.header_adj_att_tbl_type;
1152: l_oe_Header_Adj_Assoc_Tbl oe_order_pub.header_adj_assoc_tbl_type;
1153: l_oe_header_scr_tbl OE_ORDER_PUB.header_scredit_tbl_type;
1154: l_oe_Header_Scredit_Val_Tbl OE_ORDER_PUB.header_scredit_Val_tbl_type;

Line 1151: l_oe_Header_Adj_Att_Tbl oe_order_pub.header_adj_att_tbl_type;

1147:
1148: l_oe_header_adj_tbl oe_order_pub.header_adj_tbl_type;
1149: l_oe_header_adj_val_tbl oe_order_pub.header_adj_val_tbl_type;
1150: l_oe_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
1151: l_oe_Header_Adj_Att_Tbl oe_order_pub.header_adj_att_tbl_type;
1152: l_oe_Header_Adj_Assoc_Tbl oe_order_pub.header_adj_assoc_tbl_type;
1153: l_oe_header_scr_tbl OE_ORDER_PUB.header_scredit_tbl_type;
1154: l_oe_Header_Scredit_Val_Tbl OE_ORDER_PUB.header_scredit_Val_tbl_type;
1155: l_oe_line_rec oe_order_pub.line_rec_type := OE_ORDER_PUB.G_MISS_LINE_REC;

Line 1152: l_oe_Header_Adj_Assoc_Tbl oe_order_pub.header_adj_assoc_tbl_type;

1148: l_oe_header_adj_tbl oe_order_pub.header_adj_tbl_type;
1149: l_oe_header_adj_val_tbl oe_order_pub.header_adj_val_tbl_type;
1150: l_oe_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
1151: l_oe_Header_Adj_Att_Tbl oe_order_pub.header_adj_att_tbl_type;
1152: l_oe_Header_Adj_Assoc_Tbl oe_order_pub.header_adj_assoc_tbl_type;
1153: l_oe_header_scr_tbl OE_ORDER_PUB.header_scredit_tbl_type;
1154: l_oe_Header_Scredit_Val_Tbl OE_ORDER_PUB.header_scredit_Val_tbl_type;
1155: l_oe_line_rec oe_order_pub.line_rec_type := OE_ORDER_PUB.G_MISS_LINE_REC;
1156: l_oe_line_tbl oe_order_pub.line_tbl_type := OE_ORDER_PUB.G_MISS_LINE_TBL;

Line 1153: l_oe_header_scr_tbl OE_ORDER_PUB.header_scredit_tbl_type;

1149: l_oe_header_adj_val_tbl oe_order_pub.header_adj_val_tbl_type;
1150: l_oe_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
1151: l_oe_Header_Adj_Att_Tbl oe_order_pub.header_adj_att_tbl_type;
1152: l_oe_Header_Adj_Assoc_Tbl oe_order_pub.header_adj_assoc_tbl_type;
1153: l_oe_header_scr_tbl OE_ORDER_PUB.header_scredit_tbl_type;
1154: l_oe_Header_Scredit_Val_Tbl OE_ORDER_PUB.header_scredit_Val_tbl_type;
1155: l_oe_line_rec oe_order_pub.line_rec_type := OE_ORDER_PUB.G_MISS_LINE_REC;
1156: l_oe_line_tbl oe_order_pub.line_tbl_type := OE_ORDER_PUB.G_MISS_LINE_TBL;
1157: lx_oe_line_tbl oe_order_pub.line_tbl_type := OE_ORDER_PUB.G_MISS_LINE_TBL;

Line 1154: l_oe_Header_Scredit_Val_Tbl OE_ORDER_PUB.header_scredit_Val_tbl_type;

1150: l_oe_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
1151: l_oe_Header_Adj_Att_Tbl oe_order_pub.header_adj_att_tbl_type;
1152: l_oe_Header_Adj_Assoc_Tbl oe_order_pub.header_adj_assoc_tbl_type;
1153: l_oe_header_scr_tbl OE_ORDER_PUB.header_scredit_tbl_type;
1154: l_oe_Header_Scredit_Val_Tbl OE_ORDER_PUB.header_scredit_Val_tbl_type;
1155: l_oe_line_rec oe_order_pub.line_rec_type := OE_ORDER_PUB.G_MISS_LINE_REC;
1156: l_oe_line_tbl oe_order_pub.line_tbl_type := OE_ORDER_PUB.G_MISS_LINE_TBL;
1157: lx_oe_line_tbl oe_order_pub.line_tbl_type := OE_ORDER_PUB.G_MISS_LINE_TBL;
1158: l_oe_Line_Val_Tbl oe_order_pub.line_Val_tbl_type := OE_ORDER_PUB.G_MISS_LINE_VAL_TBL;

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

1151: l_oe_Header_Adj_Att_Tbl oe_order_pub.header_adj_att_tbl_type;
1152: l_oe_Header_Adj_Assoc_Tbl oe_order_pub.header_adj_assoc_tbl_type;
1153: l_oe_header_scr_tbl OE_ORDER_PUB.header_scredit_tbl_type;
1154: l_oe_Header_Scredit_Val_Tbl OE_ORDER_PUB.header_scredit_Val_tbl_type;
1155: l_oe_line_rec oe_order_pub.line_rec_type := OE_ORDER_PUB.G_MISS_LINE_REC;
1156: l_oe_line_tbl oe_order_pub.line_tbl_type := OE_ORDER_PUB.G_MISS_LINE_TBL;
1157: lx_oe_line_tbl oe_order_pub.line_tbl_type := OE_ORDER_PUB.G_MISS_LINE_TBL;
1158: l_oe_Line_Val_Tbl oe_order_pub.line_Val_tbl_type := OE_ORDER_PUB.G_MISS_LINE_VAL_TBL;
1159: l_oe_line_adj_tbl oe_order_pub.line_adj_tbl_type := OE_ORDER_PUB.G_MISS_LINE_ADJ_TBL;

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

1152: l_oe_Header_Adj_Assoc_Tbl oe_order_pub.header_adj_assoc_tbl_type;
1153: l_oe_header_scr_tbl OE_ORDER_PUB.header_scredit_tbl_type;
1154: l_oe_Header_Scredit_Val_Tbl OE_ORDER_PUB.header_scredit_Val_tbl_type;
1155: l_oe_line_rec oe_order_pub.line_rec_type := OE_ORDER_PUB.G_MISS_LINE_REC;
1156: l_oe_line_tbl oe_order_pub.line_tbl_type := OE_ORDER_PUB.G_MISS_LINE_TBL;
1157: lx_oe_line_tbl oe_order_pub.line_tbl_type := OE_ORDER_PUB.G_MISS_LINE_TBL;
1158: l_oe_Line_Val_Tbl oe_order_pub.line_Val_tbl_type := OE_ORDER_PUB.G_MISS_LINE_VAL_TBL;
1159: l_oe_line_adj_tbl oe_order_pub.line_adj_tbl_type := OE_ORDER_PUB.G_MISS_LINE_ADJ_TBL;
1160: l_oe_Line_Adj_Val_Tbl oe_order_pub.line_adj_val_tbl_type := OE_ORDER_PUB.G_MISS_LINE_ADJ_VAL_TBL;

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

1153: l_oe_header_scr_tbl OE_ORDER_PUB.header_scredit_tbl_type;
1154: l_oe_Header_Scredit_Val_Tbl OE_ORDER_PUB.header_scredit_Val_tbl_type;
1155: l_oe_line_rec oe_order_pub.line_rec_type := OE_ORDER_PUB.G_MISS_LINE_REC;
1156: l_oe_line_tbl oe_order_pub.line_tbl_type := OE_ORDER_PUB.G_MISS_LINE_TBL;
1157: lx_oe_line_tbl oe_order_pub.line_tbl_type := OE_ORDER_PUB.G_MISS_LINE_TBL;
1158: l_oe_Line_Val_Tbl oe_order_pub.line_Val_tbl_type := OE_ORDER_PUB.G_MISS_LINE_VAL_TBL;
1159: l_oe_line_adj_tbl oe_order_pub.line_adj_tbl_type := OE_ORDER_PUB.G_MISS_LINE_ADJ_TBL;
1160: l_oe_Line_Adj_Val_Tbl oe_order_pub.line_adj_val_tbl_type := OE_ORDER_PUB.G_MISS_LINE_ADJ_VAL_TBL;
1161: l_oe_Line_Price_Att_Tbl oe_order_pub.line_price_att_tbl_type := OE_ORDER_PUB.G_MISS_LINE_PRICE_ATT_TBL;

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

1154: l_oe_Header_Scredit_Val_Tbl OE_ORDER_PUB.header_scredit_Val_tbl_type;
1155: l_oe_line_rec oe_order_pub.line_rec_type := OE_ORDER_PUB.G_MISS_LINE_REC;
1156: l_oe_line_tbl oe_order_pub.line_tbl_type := OE_ORDER_PUB.G_MISS_LINE_TBL;
1157: lx_oe_line_tbl oe_order_pub.line_tbl_type := OE_ORDER_PUB.G_MISS_LINE_TBL;
1158: l_oe_Line_Val_Tbl oe_order_pub.line_Val_tbl_type := OE_ORDER_PUB.G_MISS_LINE_VAL_TBL;
1159: l_oe_line_adj_tbl oe_order_pub.line_adj_tbl_type := OE_ORDER_PUB.G_MISS_LINE_ADJ_TBL;
1160: l_oe_Line_Adj_Val_Tbl oe_order_pub.line_adj_val_tbl_type := OE_ORDER_PUB.G_MISS_LINE_ADJ_VAL_TBL;
1161: l_oe_Line_Price_Att_Tbl oe_order_pub.line_price_att_tbl_type := OE_ORDER_PUB.G_MISS_LINE_PRICE_ATT_TBL;
1162: l_oe_Line_Adj_Att_Tbl oe_order_pub.line_adj_att_tbl_type := OE_ORDER_PUB.G_MISS_LINE_ADJ_ATT_TBL;

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

1155: l_oe_line_rec oe_order_pub.line_rec_type := OE_ORDER_PUB.G_MISS_LINE_REC;
1156: l_oe_line_tbl oe_order_pub.line_tbl_type := OE_ORDER_PUB.G_MISS_LINE_TBL;
1157: lx_oe_line_tbl oe_order_pub.line_tbl_type := OE_ORDER_PUB.G_MISS_LINE_TBL;
1158: l_oe_Line_Val_Tbl oe_order_pub.line_Val_tbl_type := OE_ORDER_PUB.G_MISS_LINE_VAL_TBL;
1159: l_oe_line_adj_tbl oe_order_pub.line_adj_tbl_type := OE_ORDER_PUB.G_MISS_LINE_ADJ_TBL;
1160: l_oe_Line_Adj_Val_Tbl oe_order_pub.line_adj_val_tbl_type := OE_ORDER_PUB.G_MISS_LINE_ADJ_VAL_TBL;
1161: l_oe_Line_Price_Att_Tbl oe_order_pub.line_price_att_tbl_type := OE_ORDER_PUB.G_MISS_LINE_PRICE_ATT_TBL;
1162: l_oe_Line_Adj_Att_Tbl oe_order_pub.line_adj_att_tbl_type := OE_ORDER_PUB.G_MISS_LINE_ADJ_ATT_TBL;
1163: l_oe_Line_Adj_Assoc_tbl oe_order_pub.Line_Adj_Assoc_Tbl_Type := OE_ORDER_PUB.G_MISS_LINE_ADJ_ASSOC_TBL;

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

1156: l_oe_line_tbl oe_order_pub.line_tbl_type := OE_ORDER_PUB.G_MISS_LINE_TBL;
1157: lx_oe_line_tbl oe_order_pub.line_tbl_type := OE_ORDER_PUB.G_MISS_LINE_TBL;
1158: l_oe_Line_Val_Tbl oe_order_pub.line_Val_tbl_type := OE_ORDER_PUB.G_MISS_LINE_VAL_TBL;
1159: l_oe_line_adj_tbl oe_order_pub.line_adj_tbl_type := OE_ORDER_PUB.G_MISS_LINE_ADJ_TBL;
1160: l_oe_Line_Adj_Val_Tbl oe_order_pub.line_adj_val_tbl_type := OE_ORDER_PUB.G_MISS_LINE_ADJ_VAL_TBL;
1161: l_oe_Line_Price_Att_Tbl oe_order_pub.line_price_att_tbl_type := OE_ORDER_PUB.G_MISS_LINE_PRICE_ATT_TBL;
1162: l_oe_Line_Adj_Att_Tbl oe_order_pub.line_adj_att_tbl_type := OE_ORDER_PUB.G_MISS_LINE_ADJ_ATT_TBL;
1163: l_oe_Line_Adj_Assoc_tbl oe_order_pub.Line_Adj_Assoc_Tbl_Type := OE_ORDER_PUB.G_MISS_LINE_ADJ_ASSOC_TBL;
1164: l_oe_line_scr_tbl oe_order_pub.line_scredit_tbl_type := OE_ORDER_PUB.G_MISS_LINE_SCREDIT_TBL;

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

1157: lx_oe_line_tbl oe_order_pub.line_tbl_type := OE_ORDER_PUB.G_MISS_LINE_TBL;
1158: l_oe_Line_Val_Tbl oe_order_pub.line_Val_tbl_type := OE_ORDER_PUB.G_MISS_LINE_VAL_TBL;
1159: l_oe_line_adj_tbl oe_order_pub.line_adj_tbl_type := OE_ORDER_PUB.G_MISS_LINE_ADJ_TBL;
1160: l_oe_Line_Adj_Val_Tbl oe_order_pub.line_adj_val_tbl_type := OE_ORDER_PUB.G_MISS_LINE_ADJ_VAL_TBL;
1161: l_oe_Line_Price_Att_Tbl oe_order_pub.line_price_att_tbl_type := OE_ORDER_PUB.G_MISS_LINE_PRICE_ATT_TBL;
1162: l_oe_Line_Adj_Att_Tbl oe_order_pub.line_adj_att_tbl_type := OE_ORDER_PUB.G_MISS_LINE_ADJ_ATT_TBL;
1163: l_oe_Line_Adj_Assoc_tbl oe_order_pub.Line_Adj_Assoc_Tbl_Type := OE_ORDER_PUB.G_MISS_LINE_ADJ_ASSOC_TBL;
1164: l_oe_line_scr_tbl oe_order_pub.line_scredit_tbl_type := OE_ORDER_PUB.G_MISS_LINE_SCREDIT_TBL;
1165: l_oe_Line_Scredit_Val_Tbl oe_order_pub.line_scredit_val_tbl_type;

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

1158: l_oe_Line_Val_Tbl oe_order_pub.line_Val_tbl_type := OE_ORDER_PUB.G_MISS_LINE_VAL_TBL;
1159: l_oe_line_adj_tbl oe_order_pub.line_adj_tbl_type := OE_ORDER_PUB.G_MISS_LINE_ADJ_TBL;
1160: l_oe_Line_Adj_Val_Tbl oe_order_pub.line_adj_val_tbl_type := OE_ORDER_PUB.G_MISS_LINE_ADJ_VAL_TBL;
1161: l_oe_Line_Price_Att_Tbl oe_order_pub.line_price_att_tbl_type := OE_ORDER_PUB.G_MISS_LINE_PRICE_ATT_TBL;
1162: l_oe_Line_Adj_Att_Tbl oe_order_pub.line_adj_att_tbl_type := OE_ORDER_PUB.G_MISS_LINE_ADJ_ATT_TBL;
1163: l_oe_Line_Adj_Assoc_tbl oe_order_pub.Line_Adj_Assoc_Tbl_Type := OE_ORDER_PUB.G_MISS_LINE_ADJ_ASSOC_TBL;
1164: l_oe_line_scr_tbl oe_order_pub.line_scredit_tbl_type := OE_ORDER_PUB.G_MISS_LINE_SCREDIT_TBL;
1165: l_oe_Line_Scredit_Val_Tbl oe_order_pub.line_scredit_val_tbl_type;
1166: l_oe_Lot_Serial_Tbl oe_order_pub.lot_serial_tbl_type;

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

1159: l_oe_line_adj_tbl oe_order_pub.line_adj_tbl_type := OE_ORDER_PUB.G_MISS_LINE_ADJ_TBL;
1160: l_oe_Line_Adj_Val_Tbl oe_order_pub.line_adj_val_tbl_type := OE_ORDER_PUB.G_MISS_LINE_ADJ_VAL_TBL;
1161: l_oe_Line_Price_Att_Tbl oe_order_pub.line_price_att_tbl_type := OE_ORDER_PUB.G_MISS_LINE_PRICE_ATT_TBL;
1162: l_oe_Line_Adj_Att_Tbl oe_order_pub.line_adj_att_tbl_type := OE_ORDER_PUB.G_MISS_LINE_ADJ_ATT_TBL;
1163: l_oe_Line_Adj_Assoc_tbl oe_order_pub.Line_Adj_Assoc_Tbl_Type := OE_ORDER_PUB.G_MISS_LINE_ADJ_ASSOC_TBL;
1164: l_oe_line_scr_tbl oe_order_pub.line_scredit_tbl_type := OE_ORDER_PUB.G_MISS_LINE_SCREDIT_TBL;
1165: l_oe_Line_Scredit_Val_Tbl oe_order_pub.line_scredit_val_tbl_type;
1166: l_oe_Lot_Serial_Tbl oe_order_pub.lot_serial_tbl_type;
1167: l_oe_Lot_Serial_Val_Tbl oe_order_pub.lot_serial_val_tbl_type;

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

1160: l_oe_Line_Adj_Val_Tbl oe_order_pub.line_adj_val_tbl_type := OE_ORDER_PUB.G_MISS_LINE_ADJ_VAL_TBL;
1161: l_oe_Line_Price_Att_Tbl oe_order_pub.line_price_att_tbl_type := OE_ORDER_PUB.G_MISS_LINE_PRICE_ATT_TBL;
1162: l_oe_Line_Adj_Att_Tbl oe_order_pub.line_adj_att_tbl_type := OE_ORDER_PUB.G_MISS_LINE_ADJ_ATT_TBL;
1163: l_oe_Line_Adj_Assoc_tbl oe_order_pub.Line_Adj_Assoc_Tbl_Type := OE_ORDER_PUB.G_MISS_LINE_ADJ_ASSOC_TBL;
1164: l_oe_line_scr_tbl oe_order_pub.line_scredit_tbl_type := OE_ORDER_PUB.G_MISS_LINE_SCREDIT_TBL;
1165: l_oe_Line_Scredit_Val_Tbl oe_order_pub.line_scredit_val_tbl_type;
1166: l_oe_Lot_Serial_Tbl oe_order_pub.lot_serial_tbl_type;
1167: l_oe_Lot_Serial_Val_Tbl oe_order_pub.lot_serial_val_tbl_type;
1168: l_oe_Request_Tbl_Type oe_order_pub.Request_tbl_type := OE_ORDER_PUB.G_MISS_REQUEST_TBL;

Line 1165: l_oe_Line_Scredit_Val_Tbl oe_order_pub.line_scredit_val_tbl_type;

1161: l_oe_Line_Price_Att_Tbl oe_order_pub.line_price_att_tbl_type := OE_ORDER_PUB.G_MISS_LINE_PRICE_ATT_TBL;
1162: l_oe_Line_Adj_Att_Tbl oe_order_pub.line_adj_att_tbl_type := OE_ORDER_PUB.G_MISS_LINE_ADJ_ATT_TBL;
1163: l_oe_Line_Adj_Assoc_tbl oe_order_pub.Line_Adj_Assoc_Tbl_Type := OE_ORDER_PUB.G_MISS_LINE_ADJ_ASSOC_TBL;
1164: l_oe_line_scr_tbl oe_order_pub.line_scredit_tbl_type := OE_ORDER_PUB.G_MISS_LINE_SCREDIT_TBL;
1165: l_oe_Line_Scredit_Val_Tbl oe_order_pub.line_scredit_val_tbl_type;
1166: l_oe_Lot_Serial_Tbl oe_order_pub.lot_serial_tbl_type;
1167: l_oe_Lot_Serial_Val_Tbl oe_order_pub.lot_serial_val_tbl_type;
1168: l_oe_Request_Tbl_Type oe_order_pub.Request_tbl_type := OE_ORDER_PUB.G_MISS_REQUEST_TBL;
1169: l_oe_control_rec OE_GLOBALS.Control_Rec_Type;

Line 1166: l_oe_Lot_Serial_Tbl oe_order_pub.lot_serial_tbl_type;

1162: l_oe_Line_Adj_Att_Tbl oe_order_pub.line_adj_att_tbl_type := OE_ORDER_PUB.G_MISS_LINE_ADJ_ATT_TBL;
1163: l_oe_Line_Adj_Assoc_tbl oe_order_pub.Line_Adj_Assoc_Tbl_Type := OE_ORDER_PUB.G_MISS_LINE_ADJ_ASSOC_TBL;
1164: l_oe_line_scr_tbl oe_order_pub.line_scredit_tbl_type := OE_ORDER_PUB.G_MISS_LINE_SCREDIT_TBL;
1165: l_oe_Line_Scredit_Val_Tbl oe_order_pub.line_scredit_val_tbl_type;
1166: l_oe_Lot_Serial_Tbl oe_order_pub.lot_serial_tbl_type;
1167: l_oe_Lot_Serial_Val_Tbl oe_order_pub.lot_serial_val_tbl_type;
1168: l_oe_Request_Tbl_Type oe_order_pub.Request_tbl_type := OE_ORDER_PUB.G_MISS_REQUEST_TBL;
1169: l_oe_control_rec OE_GLOBALS.Control_Rec_Type;
1170:

Line 1167: l_oe_Lot_Serial_Val_Tbl oe_order_pub.lot_serial_val_tbl_type;

1163: l_oe_Line_Adj_Assoc_tbl oe_order_pub.Line_Adj_Assoc_Tbl_Type := OE_ORDER_PUB.G_MISS_LINE_ADJ_ASSOC_TBL;
1164: l_oe_line_scr_tbl oe_order_pub.line_scredit_tbl_type := OE_ORDER_PUB.G_MISS_LINE_SCREDIT_TBL;
1165: l_oe_Line_Scredit_Val_Tbl oe_order_pub.line_scredit_val_tbl_type;
1166: l_oe_Lot_Serial_Tbl oe_order_pub.lot_serial_tbl_type;
1167: l_oe_Lot_Serial_Val_Tbl oe_order_pub.lot_serial_val_tbl_type;
1168: l_oe_Request_Tbl_Type oe_order_pub.Request_tbl_type := OE_ORDER_PUB.G_MISS_REQUEST_TBL;
1169: l_oe_control_rec OE_GLOBALS.Control_Rec_Type;
1170:
1171: CURSOR rowid_cur IS

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

1164: l_oe_line_scr_tbl oe_order_pub.line_scredit_tbl_type := OE_ORDER_PUB.G_MISS_LINE_SCREDIT_TBL;
1165: l_oe_Line_Scredit_Val_Tbl oe_order_pub.line_scredit_val_tbl_type;
1166: l_oe_Lot_Serial_Tbl oe_order_pub.lot_serial_tbl_type;
1167: l_oe_Lot_Serial_Val_Tbl oe_order_pub.lot_serial_val_tbl_type;
1168: l_oe_Request_Tbl_Type oe_order_pub.Request_tbl_type := OE_ORDER_PUB.G_MISS_REQUEST_TBL;
1169: l_oe_control_rec OE_GLOBALS.Control_Rec_Type;
1170:
1171: CURSOR rowid_cur IS
1172: SELECT rowid FROM PO_REQUISITION_HEADERS

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

3874:
3875: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3876: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3877: 'csp.plsql.csp_parts_order.process_order',
3878: 'Now finally calling OE_Order_PUB.Process_Order for operation = '
3879: || l_oe_header_rec.operation);
3880: end if;
3881:
3882: -- CALL TO PROCESS ORDER

Line 4065: OE_Order_PUB.Process_Order(

4061: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csp.plsql.csp_parts_order.process_order',
4062: 'l_line_tbl.count = '|| l_line_tbl.count);
4063: end if;
4064:
4065: OE_Order_PUB.Process_Order(
4066: p_org_id => l_source_operating_unit
4067: ,p_api_version_number => l_api_version_number
4068: ,p_init_msg_list => FND_API.G_TRUE
4069: ,p_return_values => FND_API.G_FALSE

Line 4104: OE_Order_PUB.Process_Order(

4100: ,x_msg_data => l_msg_data
4101: );
4102: ELSE
4103: --p_action_request_tbl => l_action_request_tbl
4104: OE_Order_PUB.Process_Order(
4105: p_org_id => l_source_operating_unit
4106: ,p_api_version_number => l_api_version_number
4107: ,p_init_msg_list => FND_API.G_TRUE
4108: ,p_return_values => FND_API.G_FALSE

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

4167:
4168: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4169: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4170: 'csp.plsql.csp_parts_order.process_order',
4171: 'Error in OE_Order_PUB.Process_Order API... Message = '
4172: || l_msg);
4173: end if;
4174:
4175: RAISE FND_API.G_EXC_ERROR;

Line 4744: l_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type;

4740: ,x_msg_count OUT NOCOPY NUMBER
4741: ,x_msg_data OUT NOCOPY VARCHAR2
4742: ) IS
4743: l_module_name varchar2(100) := 'csp.plsql.csp_parts_order.book_order';
4744: l_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type;
4745: l_org_id number;
4746: l_org_org_id number;
4747:
4748: l_header_rec OE_ORDER_PUB.Header_Rec_Type;

Line 4748: l_header_rec OE_ORDER_PUB.Header_Rec_Type;

4744: l_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type;
4745: l_org_id number;
4746: l_org_org_id number;
4747:
4748: l_header_rec OE_ORDER_PUB.Header_Rec_Type;
4749: l_header_val_rec OE_ORDER_PUB.Header_Val_Rec_Type;
4750: l_Header_Adj_tbl OE_ORDER_PUB.Header_Adj_Tbl_Type;
4751: l_Header_Adj_val_tbl OE_ORDER_PUB.Header_Adj_Val_Tbl_Type;
4752: l_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;

Line 4749: l_header_val_rec OE_ORDER_PUB.Header_Val_Rec_Type;

4745: l_org_id number;
4746: l_org_org_id number;
4747:
4748: l_header_rec OE_ORDER_PUB.Header_Rec_Type;
4749: l_header_val_rec OE_ORDER_PUB.Header_Val_Rec_Type;
4750: l_Header_Adj_tbl OE_ORDER_PUB.Header_Adj_Tbl_Type;
4751: l_Header_Adj_val_tbl OE_ORDER_PUB.Header_Adj_Val_Tbl_Type;
4752: l_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
4753: l_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;

Line 4750: l_Header_Adj_tbl OE_ORDER_PUB.Header_Adj_Tbl_Type;

4746: l_org_org_id number;
4747:
4748: l_header_rec OE_ORDER_PUB.Header_Rec_Type;
4749: l_header_val_rec OE_ORDER_PUB.Header_Val_Rec_Type;
4750: l_Header_Adj_tbl OE_ORDER_PUB.Header_Adj_Tbl_Type;
4751: l_Header_Adj_val_tbl OE_ORDER_PUB.Header_Adj_Val_Tbl_Type;
4752: l_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
4753: l_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
4754: l_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;

Line 4751: l_Header_Adj_val_tbl OE_ORDER_PUB.Header_Adj_Val_Tbl_Type;

4747:
4748: l_header_rec OE_ORDER_PUB.Header_Rec_Type;
4749: l_header_val_rec OE_ORDER_PUB.Header_Val_Rec_Type;
4750: l_Header_Adj_tbl OE_ORDER_PUB.Header_Adj_Tbl_Type;
4751: l_Header_Adj_val_tbl OE_ORDER_PUB.Header_Adj_Val_Tbl_Type;
4752: l_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
4753: l_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
4754: l_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
4755: l_Header_Scredit_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type;

Line 4752: l_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;

4748: l_header_rec OE_ORDER_PUB.Header_Rec_Type;
4749: l_header_val_rec OE_ORDER_PUB.Header_Val_Rec_Type;
4750: l_Header_Adj_tbl OE_ORDER_PUB.Header_Adj_Tbl_Type;
4751: l_Header_Adj_val_tbl OE_ORDER_PUB.Header_Adj_Val_Tbl_Type;
4752: l_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
4753: l_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
4754: l_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
4755: l_Header_Scredit_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type;
4756: l_Header_Scredit_val_tbl OE_ORDER_PUB.Header_Scredit_Val_Tbl_Type;

Line 4753: l_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;

4749: l_header_val_rec OE_ORDER_PUB.Header_Val_Rec_Type;
4750: l_Header_Adj_tbl OE_ORDER_PUB.Header_Adj_Tbl_Type;
4751: l_Header_Adj_val_tbl OE_ORDER_PUB.Header_Adj_Val_Tbl_Type;
4752: l_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
4753: l_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
4754: l_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
4755: l_Header_Scredit_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type;
4756: l_Header_Scredit_val_tbl OE_ORDER_PUB.Header_Scredit_Val_Tbl_Type;
4757: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

Line 4754: l_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;

4750: l_Header_Adj_tbl OE_ORDER_PUB.Header_Adj_Tbl_Type;
4751: l_Header_Adj_val_tbl OE_ORDER_PUB.Header_Adj_Val_Tbl_Type;
4752: l_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
4753: l_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
4754: l_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
4755: l_Header_Scredit_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type;
4756: l_Header_Scredit_val_tbl OE_ORDER_PUB.Header_Scredit_Val_Tbl_Type;
4757: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
4758: l_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;

Line 4755: l_Header_Scredit_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type;

4751: l_Header_Adj_val_tbl OE_ORDER_PUB.Header_Adj_Val_Tbl_Type;
4752: l_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
4753: l_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
4754: l_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
4755: l_Header_Scredit_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type;
4756: l_Header_Scredit_val_tbl OE_ORDER_PUB.Header_Scredit_Val_Tbl_Type;
4757: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
4758: l_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;
4759: l_Line_Adj_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;

Line 4756: l_Header_Scredit_val_tbl OE_ORDER_PUB.Header_Scredit_Val_Tbl_Type;

4752: l_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
4753: l_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
4754: l_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
4755: l_Header_Scredit_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type;
4756: l_Header_Scredit_val_tbl OE_ORDER_PUB.Header_Scredit_Val_Tbl_Type;
4757: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
4758: l_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;
4759: l_Line_Adj_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
4760: l_Line_Adj_val_tbl OE_ORDER_PUB.Line_Adj_Val_Tbl_Type;

Line 4757: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

4753: l_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
4754: l_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
4755: l_Header_Scredit_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type;
4756: l_Header_Scredit_val_tbl OE_ORDER_PUB.Header_Scredit_Val_Tbl_Type;
4757: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
4758: l_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;
4759: l_Line_Adj_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
4760: l_Line_Adj_val_tbl OE_ORDER_PUB.Line_Adj_Val_Tbl_Type;
4761: l_Line_price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;

Line 4758: l_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;

4754: l_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
4755: l_Header_Scredit_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type;
4756: l_Header_Scredit_val_tbl OE_ORDER_PUB.Header_Scredit_Val_Tbl_Type;
4757: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
4758: l_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;
4759: l_Line_Adj_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
4760: l_Line_Adj_val_tbl OE_ORDER_PUB.Line_Adj_Val_Tbl_Type;
4761: l_Line_price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
4762: l_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;

Line 4759: l_Line_Adj_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;

4755: l_Header_Scredit_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type;
4756: l_Header_Scredit_val_tbl OE_ORDER_PUB.Header_Scredit_Val_Tbl_Type;
4757: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
4758: l_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;
4759: l_Line_Adj_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
4760: l_Line_Adj_val_tbl OE_ORDER_PUB.Line_Adj_Val_Tbl_Type;
4761: l_Line_price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
4762: l_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
4763: l_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;

Line 4760: l_Line_Adj_val_tbl OE_ORDER_PUB.Line_Adj_Val_Tbl_Type;

4756: l_Header_Scredit_val_tbl OE_ORDER_PUB.Header_Scredit_Val_Tbl_Type;
4757: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
4758: l_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;
4759: l_Line_Adj_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
4760: l_Line_Adj_val_tbl OE_ORDER_PUB.Line_Adj_Val_Tbl_Type;
4761: l_Line_price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
4762: l_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
4763: l_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
4764: l_Line_Scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type;

Line 4761: l_Line_price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;

4757: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
4758: l_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;
4759: l_Line_Adj_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
4760: l_Line_Adj_val_tbl OE_ORDER_PUB.Line_Adj_Val_Tbl_Type;
4761: l_Line_price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
4762: l_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
4763: l_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
4764: l_Line_Scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type;
4765: l_Line_Scredit_val_tbl OE_ORDER_PUB.Line_Scredit_Val_Tbl_Type;

Line 4762: l_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;

4758: l_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;
4759: l_Line_Adj_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
4760: l_Line_Adj_val_tbl OE_ORDER_PUB.Line_Adj_Val_Tbl_Type;
4761: l_Line_price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
4762: l_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
4763: l_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
4764: l_Line_Scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type;
4765: l_Line_Scredit_val_tbl OE_ORDER_PUB.Line_Scredit_Val_Tbl_Type;
4766: l_Lot_Serial_tbl OE_ORDER_PUB.Lot_Serial_Tbl_Type;

Line 4763: l_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;

4759: l_Line_Adj_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
4760: l_Line_Adj_val_tbl OE_ORDER_PUB.Line_Adj_Val_Tbl_Type;
4761: l_Line_price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
4762: l_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
4763: l_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
4764: l_Line_Scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type;
4765: l_Line_Scredit_val_tbl OE_ORDER_PUB.Line_Scredit_Val_Tbl_Type;
4766: l_Lot_Serial_tbl OE_ORDER_PUB.Lot_Serial_Tbl_Type;
4767: l_Lot_Serial_val_tbl OE_ORDER_PUB.Lot_Serial_Val_Tbl_Type;

Line 4764: l_Line_Scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type;

4760: l_Line_Adj_val_tbl OE_ORDER_PUB.Line_Adj_Val_Tbl_Type;
4761: l_Line_price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
4762: l_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
4763: l_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
4764: l_Line_Scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type;
4765: l_Line_Scredit_val_tbl OE_ORDER_PUB.Line_Scredit_Val_Tbl_Type;
4766: l_Lot_Serial_tbl OE_ORDER_PUB.Lot_Serial_Tbl_Type;
4767: l_Lot_Serial_val_tbl OE_ORDER_PUB.Lot_Serial_Val_Tbl_Type;
4768: lx_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type;

Line 4765: l_Line_Scredit_val_tbl OE_ORDER_PUB.Line_Scredit_Val_Tbl_Type;

4761: l_Line_price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
4762: l_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
4763: l_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
4764: l_Line_Scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type;
4765: l_Line_Scredit_val_tbl OE_ORDER_PUB.Line_Scredit_Val_Tbl_Type;
4766: l_Lot_Serial_tbl OE_ORDER_PUB.Lot_Serial_Tbl_Type;
4767: l_Lot_Serial_val_tbl OE_ORDER_PUB.Lot_Serial_Val_Tbl_Type;
4768: lx_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type;
4769:

Line 4766: l_Lot_Serial_tbl OE_ORDER_PUB.Lot_Serial_Tbl_Type;

4762: l_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
4763: l_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
4764: l_Line_Scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type;
4765: l_Line_Scredit_val_tbl OE_ORDER_PUB.Line_Scredit_Val_Tbl_Type;
4766: l_Lot_Serial_tbl OE_ORDER_PUB.Lot_Serial_Tbl_Type;
4767: l_Lot_Serial_val_tbl OE_ORDER_PUB.Lot_Serial_Val_Tbl_Type;
4768: lx_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type;
4769:
4770: begin

Line 4767: l_Lot_Serial_val_tbl OE_ORDER_PUB.Lot_Serial_Val_Tbl_Type;

4763: l_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
4764: l_Line_Scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type;
4765: l_Line_Scredit_val_tbl OE_ORDER_PUB.Line_Scredit_Val_Tbl_Type;
4766: l_Lot_Serial_tbl OE_ORDER_PUB.Lot_Serial_Tbl_Type;
4767: l_Lot_Serial_val_tbl OE_ORDER_PUB.Lot_Serial_Val_Tbl_Type;
4768: lx_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type;
4769:
4770: begin
4771:

Line 4768: lx_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type;

4764: l_Line_Scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type;
4765: l_Line_Scredit_val_tbl OE_ORDER_PUB.Line_Scredit_Val_Tbl_Type;
4766: l_Lot_Serial_tbl OE_ORDER_PUB.Lot_Serial_Tbl_Type;
4767: l_Lot_Serial_val_tbl OE_ORDER_PUB.Lot_Serial_Val_Tbl_Type;
4768: lx_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type;
4769:
4770: begin
4771:
4772: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 4809: l_action_request_tbl := OE_ORDER_PUB.G_MISS_REQUEST_TBL;

4805: end if;
4806: po_moac_utils_pvt.set_org_context(l_org_id);
4807: end if;
4808:
4809: l_action_request_tbl := OE_ORDER_PUB.G_MISS_REQUEST_TBL;
4810: l_action_request_tbl(1).request_type := oe_globals.g_book_order;
4811: l_action_request_tbl(1).entity_code := oe_globals.g_entity_header;
4812: l_action_request_tbl(1).entity_id := p_oe_header_id;
4813:

Line 4814: OE_ORDER_PUB.process_order(

4810: l_action_request_tbl(1).request_type := oe_globals.g_book_order;
4811: l_action_request_tbl(1).entity_code := oe_globals.g_entity_header;
4812: l_action_request_tbl(1).entity_id := p_oe_header_id;
4813:
4814: OE_ORDER_PUB.process_order(
4815: p_api_version_number => 1.0,
4816: p_org_id => l_org_id,
4817: p_init_msg_list => FND_API.G_TRUE,
4818: p_return_values => FND_API.G_FALSE,

Line 4858: 'After calling OE_ORDER_PUB.process_order ...');

4854: end if;
4855:
4856: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4857: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
4858: 'After calling OE_ORDER_PUB.process_order ...');
4859: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
4860: 'x_return_status = ' || x_return_status);
4861: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
4862: 'x_msg_count = ' || x_msg_count);

Line 4881: l_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type;

4877: ,x_msg_count OUT NOCOPY NUMBER
4878: ,x_msg_data OUT NOCOPY VARCHAR2
4879: ) IS
4880: l_module_name varchar2(100) := 'csp.plsql.csp_parts_order.upd_oe_line_ship_method';
4881: l_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type;
4882: l_org_id number;
4883: l_org_org_id number;
4884: l_ship_from_org_id number;
4885: l_arrival_date date;

Line 4887: l_header_rec OE_ORDER_PUB.Header_Rec_Type;

4883: l_org_org_id number;
4884: l_ship_from_org_id number;
4885: l_arrival_date date;
4886:
4887: l_header_rec OE_ORDER_PUB.Header_Rec_Type;
4888: l_header_val_rec OE_ORDER_PUB.Header_Val_Rec_Type;
4889: l_Header_Adj_tbl OE_ORDER_PUB.Header_Adj_Tbl_Type;
4890: l_Header_Adj_val_tbl OE_ORDER_PUB.Header_Adj_Val_Tbl_Type;
4891: l_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;

Line 4888: l_header_val_rec OE_ORDER_PUB.Header_Val_Rec_Type;

4884: l_ship_from_org_id number;
4885: l_arrival_date date;
4886:
4887: l_header_rec OE_ORDER_PUB.Header_Rec_Type;
4888: l_header_val_rec OE_ORDER_PUB.Header_Val_Rec_Type;
4889: l_Header_Adj_tbl OE_ORDER_PUB.Header_Adj_Tbl_Type;
4890: l_Header_Adj_val_tbl OE_ORDER_PUB.Header_Adj_Val_Tbl_Type;
4891: l_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
4892: l_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;

Line 4889: l_Header_Adj_tbl OE_ORDER_PUB.Header_Adj_Tbl_Type;

4885: l_arrival_date date;
4886:
4887: l_header_rec OE_ORDER_PUB.Header_Rec_Type;
4888: l_header_val_rec OE_ORDER_PUB.Header_Val_Rec_Type;
4889: l_Header_Adj_tbl OE_ORDER_PUB.Header_Adj_Tbl_Type;
4890: l_Header_Adj_val_tbl OE_ORDER_PUB.Header_Adj_Val_Tbl_Type;
4891: l_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
4892: l_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
4893: l_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;

Line 4890: l_Header_Adj_val_tbl OE_ORDER_PUB.Header_Adj_Val_Tbl_Type;

4886:
4887: l_header_rec OE_ORDER_PUB.Header_Rec_Type;
4888: l_header_val_rec OE_ORDER_PUB.Header_Val_Rec_Type;
4889: l_Header_Adj_tbl OE_ORDER_PUB.Header_Adj_Tbl_Type;
4890: l_Header_Adj_val_tbl OE_ORDER_PUB.Header_Adj_Val_Tbl_Type;
4891: l_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
4892: l_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
4893: l_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
4894: l_Header_Scredit_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type;

Line 4891: l_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;

4887: l_header_rec OE_ORDER_PUB.Header_Rec_Type;
4888: l_header_val_rec OE_ORDER_PUB.Header_Val_Rec_Type;
4889: l_Header_Adj_tbl OE_ORDER_PUB.Header_Adj_Tbl_Type;
4890: l_Header_Adj_val_tbl OE_ORDER_PUB.Header_Adj_Val_Tbl_Type;
4891: l_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
4892: l_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
4893: l_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
4894: l_Header_Scredit_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type;
4895: l_Header_Scredit_val_tbl OE_ORDER_PUB.Header_Scredit_Val_Tbl_Type;

Line 4892: l_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;

4888: l_header_val_rec OE_ORDER_PUB.Header_Val_Rec_Type;
4889: l_Header_Adj_tbl OE_ORDER_PUB.Header_Adj_Tbl_Type;
4890: l_Header_Adj_val_tbl OE_ORDER_PUB.Header_Adj_Val_Tbl_Type;
4891: l_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
4892: l_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
4893: l_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
4894: l_Header_Scredit_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type;
4895: l_Header_Scredit_val_tbl OE_ORDER_PUB.Header_Scredit_Val_Tbl_Type;
4896: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

Line 4893: l_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;

4889: l_Header_Adj_tbl OE_ORDER_PUB.Header_Adj_Tbl_Type;
4890: l_Header_Adj_val_tbl OE_ORDER_PUB.Header_Adj_Val_Tbl_Type;
4891: l_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
4892: l_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
4893: l_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
4894: l_Header_Scredit_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type;
4895: l_Header_Scredit_val_tbl OE_ORDER_PUB.Header_Scredit_Val_Tbl_Type;
4896: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
4897: l_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;

Line 4894: l_Header_Scredit_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type;

4890: l_Header_Adj_val_tbl OE_ORDER_PUB.Header_Adj_Val_Tbl_Type;
4891: l_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
4892: l_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
4893: l_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
4894: l_Header_Scredit_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type;
4895: l_Header_Scredit_val_tbl OE_ORDER_PUB.Header_Scredit_Val_Tbl_Type;
4896: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
4897: l_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;
4898: l_Line_Adj_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;

Line 4895: l_Header_Scredit_val_tbl OE_ORDER_PUB.Header_Scredit_Val_Tbl_Type;

4891: l_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
4892: l_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
4893: l_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
4894: l_Header_Scredit_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type;
4895: l_Header_Scredit_val_tbl OE_ORDER_PUB.Header_Scredit_Val_Tbl_Type;
4896: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
4897: l_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;
4898: l_Line_Adj_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
4899: l_Line_Adj_val_tbl OE_ORDER_PUB.Line_Adj_Val_Tbl_Type;

Line 4896: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

4892: l_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
4893: l_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
4894: l_Header_Scredit_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type;
4895: l_Header_Scredit_val_tbl OE_ORDER_PUB.Header_Scredit_Val_Tbl_Type;
4896: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
4897: l_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;
4898: l_Line_Adj_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
4899: l_Line_Adj_val_tbl OE_ORDER_PUB.Line_Adj_Val_Tbl_Type;
4900: l_Line_price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;

Line 4897: l_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;

4893: l_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
4894: l_Header_Scredit_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type;
4895: l_Header_Scredit_val_tbl OE_ORDER_PUB.Header_Scredit_Val_Tbl_Type;
4896: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
4897: l_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;
4898: l_Line_Adj_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
4899: l_Line_Adj_val_tbl OE_ORDER_PUB.Line_Adj_Val_Tbl_Type;
4900: l_Line_price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
4901: l_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;

Line 4898: l_Line_Adj_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;

4894: l_Header_Scredit_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type;
4895: l_Header_Scredit_val_tbl OE_ORDER_PUB.Header_Scredit_Val_Tbl_Type;
4896: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
4897: l_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;
4898: l_Line_Adj_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
4899: l_Line_Adj_val_tbl OE_ORDER_PUB.Line_Adj_Val_Tbl_Type;
4900: l_Line_price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
4901: l_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
4902: l_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;

Line 4899: l_Line_Adj_val_tbl OE_ORDER_PUB.Line_Adj_Val_Tbl_Type;

4895: l_Header_Scredit_val_tbl OE_ORDER_PUB.Header_Scredit_Val_Tbl_Type;
4896: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
4897: l_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;
4898: l_Line_Adj_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
4899: l_Line_Adj_val_tbl OE_ORDER_PUB.Line_Adj_Val_Tbl_Type;
4900: l_Line_price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
4901: l_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
4902: l_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
4903: l_Line_Scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type;

Line 4900: l_Line_price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;

4896: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
4897: l_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;
4898: l_Line_Adj_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
4899: l_Line_Adj_val_tbl OE_ORDER_PUB.Line_Adj_Val_Tbl_Type;
4900: l_Line_price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
4901: l_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
4902: l_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
4903: l_Line_Scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type;
4904: l_Line_Scredit_val_tbl OE_ORDER_PUB.Line_Scredit_Val_Tbl_Type;

Line 4901: l_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;

4897: l_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;
4898: l_Line_Adj_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
4899: l_Line_Adj_val_tbl OE_ORDER_PUB.Line_Adj_Val_Tbl_Type;
4900: l_Line_price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
4901: l_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
4902: l_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
4903: l_Line_Scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type;
4904: l_Line_Scredit_val_tbl OE_ORDER_PUB.Line_Scredit_Val_Tbl_Type;
4905: l_Lot_Serial_tbl OE_ORDER_PUB.Lot_Serial_Tbl_Type;

Line 4902: l_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;

4898: l_Line_Adj_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
4899: l_Line_Adj_val_tbl OE_ORDER_PUB.Line_Adj_Val_Tbl_Type;
4900: l_Line_price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
4901: l_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
4902: l_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
4903: l_Line_Scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type;
4904: l_Line_Scredit_val_tbl OE_ORDER_PUB.Line_Scredit_Val_Tbl_Type;
4905: l_Lot_Serial_tbl OE_ORDER_PUB.Lot_Serial_Tbl_Type;
4906: l_Lot_Serial_val_tbl OE_ORDER_PUB.Lot_Serial_Val_Tbl_Type;

Line 4903: l_Line_Scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type;

4899: l_Line_Adj_val_tbl OE_ORDER_PUB.Line_Adj_Val_Tbl_Type;
4900: l_Line_price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
4901: l_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
4902: l_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
4903: l_Line_Scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type;
4904: l_Line_Scredit_val_tbl OE_ORDER_PUB.Line_Scredit_Val_Tbl_Type;
4905: l_Lot_Serial_tbl OE_ORDER_PUB.Lot_Serial_Tbl_Type;
4906: l_Lot_Serial_val_tbl OE_ORDER_PUB.Lot_Serial_Val_Tbl_Type;
4907: lx_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type;

Line 4904: l_Line_Scredit_val_tbl OE_ORDER_PUB.Line_Scredit_Val_Tbl_Type;

4900: l_Line_price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
4901: l_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
4902: l_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
4903: l_Line_Scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type;
4904: l_Line_Scredit_val_tbl OE_ORDER_PUB.Line_Scredit_Val_Tbl_Type;
4905: l_Lot_Serial_tbl OE_ORDER_PUB.Lot_Serial_Tbl_Type;
4906: l_Lot_Serial_val_tbl OE_ORDER_PUB.Lot_Serial_Val_Tbl_Type;
4907: lx_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type;
4908:

Line 4905: l_Lot_Serial_tbl OE_ORDER_PUB.Lot_Serial_Tbl_Type;

4901: l_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
4902: l_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
4903: l_Line_Scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type;
4904: l_Line_Scredit_val_tbl OE_ORDER_PUB.Line_Scredit_Val_Tbl_Type;
4905: l_Lot_Serial_tbl OE_ORDER_PUB.Lot_Serial_Tbl_Type;
4906: l_Lot_Serial_val_tbl OE_ORDER_PUB.Lot_Serial_Val_Tbl_Type;
4907: lx_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type;
4908:
4909: l_line_tbl1 OE_ORDER_PUB.Line_Tbl_Type;

Line 4906: l_Lot_Serial_val_tbl OE_ORDER_PUB.Lot_Serial_Val_Tbl_Type;

4902: l_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
4903: l_Line_Scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type;
4904: l_Line_Scredit_val_tbl OE_ORDER_PUB.Line_Scredit_Val_Tbl_Type;
4905: l_Lot_Serial_tbl OE_ORDER_PUB.Lot_Serial_Tbl_Type;
4906: l_Lot_Serial_val_tbl OE_ORDER_PUB.Lot_Serial_Val_Tbl_Type;
4907: lx_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type;
4908:
4909: l_line_tbl1 OE_ORDER_PUB.Line_Tbl_Type;
4910:

Line 4907: lx_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type;

4903: l_Line_Scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type;
4904: l_Line_Scredit_val_tbl OE_ORDER_PUB.Line_Scredit_Val_Tbl_Type;
4905: l_Lot_Serial_tbl OE_ORDER_PUB.Lot_Serial_Tbl_Type;
4906: l_Lot_Serial_val_tbl OE_ORDER_PUB.Lot_Serial_Val_Tbl_Type;
4907: lx_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type;
4908:
4909: l_line_tbl1 OE_ORDER_PUB.Line_Tbl_Type;
4910:
4911: cursor c_get_arrival_date is

Line 4909: l_line_tbl1 OE_ORDER_PUB.Line_Tbl_Type;

4905: l_Lot_Serial_tbl OE_ORDER_PUB.Lot_Serial_Tbl_Type;
4906: l_Lot_Serial_val_tbl OE_ORDER_PUB.Lot_Serial_Val_Tbl_Type;
4907: lx_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type;
4908:
4909: l_line_tbl1 OE_ORDER_PUB.Line_Tbl_Type;
4910:
4911: cursor c_get_arrival_date is
4912: SELECT csp.arrival_date
4913: FROM CSP_SHIPPING_DETAILS_V csp,

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

4961: end if;
4962: po_moac_utils_pvt.set_org_context(l_org_id);
4963: end if;
4964:
4965: l_line_tbl(1) := OE_ORDER_PUB.G_MISS_LINE_REC;
4966: l_line_tbl(1).line_id := p_oe_line_id;
4967: l_line_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;
4968: l_line_tbl(1).shipping_method_code := p_ship_method;
4969:

Line 5010: OE_ORDER_PUB.process_order(

5006: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5007: 'l_line_tbl.count = '|| l_line_tbl.count);
5008: end if;
5009:
5010: OE_ORDER_PUB.process_order(
5011: p_api_version_number => 1.0,
5012: p_org_id => l_org_id,
5013: p_init_msg_list => FND_API.G_TRUE,
5014: p_return_values => FND_API.G_FALSE,

Line 5056: 'After calling OE_ORDER_PUB.process_order ...');

5052: end if;
5053:
5054: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5055: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5056: 'After calling OE_ORDER_PUB.process_order ...');
5057: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5058: 'x_return_status = ' || x_return_status);
5059: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5060: 'x_msg_count = ' || x_msg_count);

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

5087: l_booked_orders number;
5088: l_header_rec csp_parts_requirement.header_rec_type;
5089: l_header_can_rec csp_parts_requirement.header_rec_type;
5090: l_lines_tbl csp_parts_requirement.Line_Tbl_type;
5091: l_oe_header_rec oe_order_pub.header_rec_type := OE_ORDER_PUB.G_MISS_HEADER_REC;
5092: l_oe_line_tbl OE_Order_PUB.line_tbl_type;
5093: l_dest_org_id number;
5094: l_dest_subinv varchar2(40);
5095: l_need_by_date date;

Line 5092: l_oe_line_tbl OE_Order_PUB.line_tbl_type;

5088: l_header_rec csp_parts_requirement.header_rec_type;
5089: l_header_can_rec csp_parts_requirement.header_rec_type;
5090: l_lines_tbl csp_parts_requirement.Line_Tbl_type;
5091: l_oe_header_rec oe_order_pub.header_rec_type := OE_ORDER_PUB.G_MISS_HEADER_REC;
5092: l_oe_line_tbl OE_Order_PUB.line_tbl_type;
5093: l_dest_org_id number;
5094: l_dest_subinv varchar2(40);
5095: l_need_by_date date;
5096: l_req_line_id number;