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

Line 14: p_line_rec IN OE_ORDER_PUB.line_rec_type,

10:
11:
12: PROCEDURE Decrement_Inventory(
13: p_detail_id IN NUMBER,
14: p_line_rec IN OE_ORDER_PUB.line_rec_type,
15: p_transaction_id IN NUMBER,
16: p_transaction_detail_qty IN NUMBER,
17: p_trans_qty2 IN NUMBER, -- INVCONV
18: p_inventory_item_id IN NUMBER,

Line 36: p_line_rec IN OE_ORDER_PUB.line_rec_type,

32:
33:
34: /* Procedure Decrement_Inventory_for_OPM( remove for INVCONV
35: p_detail_id IN NUMBER,
36: p_line_rec IN OE_ORDER_PUB.line_rec_type,
37: p_transaction_id IN NUMBER,
38: p_trans_qty IN NUMBER,
39: p_trans_qty2 IN NUMBER,
40: p_inventory_item_id IN NUMBER,

Line 61: ,p_line_rec IN OE_ORDER_PUB.Line_rec_Type

57: ,p_short_quantity IN NUMBER
58: ,p_transaction_date IN DATE
59: ,p_add_to_shipped IN NUMBER
60: ,p_add_to_shipped2 IN NUMBER
61: ,p_line_rec IN OE_ORDER_PUB.Line_rec_Type
62: ,x_return_status OUT NOCOPY VARCHAR2
63: );
64:
65: PROCEDURE Create_reservation

Line 71: ,p_line_rec IN OE_ORDER_PUB.Line_Rec_Type

67: ,p_qty2_to_be_reserved IN NUMBER default null -- INVCONV
68: ,p_revision IN VARCHAR2
69: ,p_locator_id IN NUMBER
70: ,p_lot IN VARCHAR2
71: ,p_line_rec IN OE_ORDER_PUB.Line_Rec_Type
72: ,x_qty_reserved OUT NOCOPY NUMBER
73: ,x_qty2_reserved OUT NOCOPY NUMBER
74: ,x_rsv_id OUT NOCOPY NUMBER
75: ,x_return_status OUT NOCOPY VARCHAR2

Line 109: l_line_rec OE_ORDER_PUB.line_rec_type;

105:
106: RETURN BOOLEAN
107: IS
108: l_line_id NUMBER;
109: l_line_rec OE_ORDER_PUB.line_rec_type;
110: l_transaction_id NUMBER := p_rcv_transaction_id;
111: l_application_short_name VARCHAR2(3);
112: l_pr_complete NUMBER; /* Purchase Release complete */
113: l_ordered_quantity NUMBER := 0;

Line 857: p_line_rec IN OE_ORDER_PUB.line_rec_type,

853: ----------------------------------------------------------------------- */
854:
855: Procedure Decrement_Inventory(
856: p_detail_id IN NUMBER,
857: p_line_rec IN OE_ORDER_PUB.line_rec_type,
858: p_transaction_id IN NUMBER,
859: p_transaction_detail_qty IN NUMBER,
860: p_trans_qty2 IN NUMBER, -- INVCONV
861: p_inventory_item_id IN NUMBER,

Line 1909: p_line_rec IN OE_ORDER_PUB.line_rec_type,

1905: -----------------------------------------------------------------------*/
1906:
1907: /*Procedure Decrement_Inventory_for_OPM(
1908: p_detail_id IN NUMBER,
1909: p_line_rec IN OE_ORDER_PUB.line_rec_type,
1910: p_transaction_id IN NUMBER,
1911: p_trans_qty IN NUMBER,
1912: p_trans_qty2 IN NUMBER,
1913: p_inventory_item_id IN NUMBER,

Line 2201: ,p_line_rec IN OE_ORDER_PUB.Line_Rec_Type

2197: ,p_qty2_to_be_reserved IN NUMBER DEFAULT NULL --INVVCONV
2198: ,p_revision IN VARCHAR2
2199: ,p_locator_id IN NUMBER
2200: ,p_lot IN VARCHAR2
2201: ,p_line_rec IN OE_ORDER_PUB.Line_Rec_Type
2202: ,x_qty_reserved OUT NOCOPY NUMBER
2203: ,x_qty2_reserved OUT NOCOPY NUMBER -- INVCONV
2204: ,x_rsv_id OUT NOCOPY NUMBER
2205: ,x_return_status OUT NOCOPY VARCHAR2

Line 2458: ,p_line_rec IN OE_ORDER_PUB.Line_rec_Type

2454: (p_short_quantity IN NUMBER
2455: ,p_transaction_date IN DATE
2456: ,p_add_to_shipped IN NUMBER
2457: ,p_add_to_shipped2 IN NUMBER
2458: ,p_line_rec IN OE_ORDER_PUB.Line_rec_Type
2459: ,x_return_status OUT NOCOPY VARCHAR2
2460: ,x_msg_count OUT NOCOPY NUMBER
2461: ,x_msg_data OUT NOCOPY VARCHAR2
2462: )

Line 2637: ,p_line_rec IN OE_ORDER_PUB.Line_rec_Type

2633: ,p_short_quantity IN NUMBER
2634: ,p_transaction_date IN DATE
2635: ,p_add_to_shipped IN NUMBER
2636: ,p_add_to_shipped2 IN NUMBER
2637: ,p_line_rec IN OE_ORDER_PUB.Line_rec_Type
2638: ,x_return_status OUT NOCOPY VARCHAR2
2639: )
2640: IS
2641: -- Process Order arguments

Line 2646: l_line_tbl OE_ORDER_PUB.line_tbl_type;

2642: l_msg_count NUMBER;
2643: l_msg_data VARCHAR2(20000);
2644:
2645: l_control_rec OE_GLOBALS.control_rec_type;
2646: l_line_tbl OE_ORDER_PUB.line_tbl_type;
2647: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
2648: l_header_rec OE_Order_PUB.Header_Rec_Type;
2649: l_new_line_rec OE_Order_PUB.Line_Rec_Type;
2650: l_new_line_tbl OE_Order_PUB.Line_Tbl_Type;

Line 2647: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;

2643: l_msg_data VARCHAR2(20000);
2644:
2645: l_control_rec OE_GLOBALS.control_rec_type;
2646: l_line_tbl OE_ORDER_PUB.line_tbl_type;
2647: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
2648: l_header_rec OE_Order_PUB.Header_Rec_Type;
2649: l_new_line_rec OE_Order_PUB.Line_Rec_Type;
2650: l_new_line_tbl OE_Order_PUB.Line_Tbl_Type;
2651: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

Line 2648: l_header_rec OE_Order_PUB.Header_Rec_Type;

2644:
2645: l_control_rec OE_GLOBALS.control_rec_type;
2646: l_line_tbl OE_ORDER_PUB.line_tbl_type;
2647: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
2648: l_header_rec OE_Order_PUB.Header_Rec_Type;
2649: l_new_line_rec OE_Order_PUB.Line_Rec_Type;
2650: l_new_line_tbl OE_Order_PUB.Line_Tbl_Type;
2651: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2652: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

Line 2649: l_new_line_rec OE_Order_PUB.Line_Rec_Type;

2645: l_control_rec OE_GLOBALS.control_rec_type;
2646: l_line_tbl OE_ORDER_PUB.line_tbl_type;
2647: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
2648: l_header_rec OE_Order_PUB.Header_Rec_Type;
2649: l_new_line_rec OE_Order_PUB.Line_Rec_Type;
2650: l_new_line_tbl OE_Order_PUB.Line_Tbl_Type;
2651: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2652: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2653: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

Line 2650: l_new_line_tbl OE_Order_PUB.Line_Tbl_Type;

2646: l_line_tbl OE_ORDER_PUB.line_tbl_type;
2647: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
2648: l_header_rec OE_Order_PUB.Header_Rec_Type;
2649: l_new_line_rec OE_Order_PUB.Line_Rec_Type;
2650: l_new_line_tbl OE_Order_PUB.Line_Tbl_Type;
2651: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2652: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2653: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2654: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

Line 2651: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

2647: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
2648: l_header_rec OE_Order_PUB.Header_Rec_Type;
2649: l_new_line_rec OE_Order_PUB.Line_Rec_Type;
2650: l_new_line_tbl OE_Order_PUB.Line_Tbl_Type;
2651: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2652: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2653: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2654: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2655: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

Line 2652: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

2648: l_header_rec OE_Order_PUB.Header_Rec_Type;
2649: l_new_line_rec OE_Order_PUB.Line_Rec_Type;
2650: l_new_line_tbl OE_Order_PUB.Line_Tbl_Type;
2651: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2652: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2653: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2654: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2655: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2656: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;

Line 2653: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

2649: l_new_line_rec OE_Order_PUB.Line_Rec_Type;
2650: l_new_line_tbl OE_Order_PUB.Line_Tbl_Type;
2651: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2652: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2653: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2654: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2655: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2656: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
2657: l_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;

Line 2654: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

2650: l_new_line_tbl OE_Order_PUB.Line_Tbl_Type;
2651: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2652: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2653: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2654: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2655: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2656: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
2657: l_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
2658: l_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;

Line 2655: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

2651: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2652: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2653: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2654: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2655: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2656: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
2657: l_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
2658: l_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
2659: l_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;

Line 2656: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;

2652: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2653: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2654: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2655: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2656: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
2657: l_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
2658: l_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
2659: l_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
2660: l_Line_Price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;

Line 2657: l_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;

2653: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2654: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2655: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2656: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
2657: l_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
2658: l_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
2659: l_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
2660: l_Line_Price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
2661: l_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;

Line 2658: l_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;

2654: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2655: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2656: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
2657: l_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
2658: l_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
2659: l_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
2660: l_Line_Price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
2661: l_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
2662: l_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;

Line 2659: l_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;

2655: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2656: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
2657: l_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
2658: l_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
2659: l_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
2660: l_Line_Price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
2661: l_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
2662: l_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
2663:

Line 2660: l_Line_Price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;

2656: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
2657: l_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
2658: l_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
2659: l_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
2660: l_Line_Price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
2661: l_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
2662: l_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
2663:
2664: l_req_qty_tbl OE_Ship_Confirmation_Pub.Req_Quantity_Tbl_Type;

Line 2661: l_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;

2657: l_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
2658: l_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
2659: l_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
2660: l_Line_Price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
2661: l_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
2662: l_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
2663:
2664: l_req_qty_tbl OE_Ship_Confirmation_Pub.Req_Quantity_Tbl_Type;
2665:

Line 2662: l_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;

2658: l_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
2659: l_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
2660: l_Line_Price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
2661: l_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
2662: l_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
2663:
2664: l_req_qty_tbl OE_Ship_Confirmation_Pub.Req_Quantity_Tbl_Type;
2665:
2666: l_new_line_id NUMBER;

Line 2670: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;

2666: l_new_line_id NUMBER;
2667: l_return_status VARCHAR2(1);
2668: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2669: --serla begin
2670: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2671: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2672: --serla end
2673: -- tso
2674: l_top_container_model Varchar2(1);

Line 2671: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;

2667: l_return_status VARCHAR2(1);
2668: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2669: --serla begin
2670: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2671: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2672: --serla end
2673: -- tso
2674: l_top_container_model Varchar2(1);
2675: l_part_of_container Varchar2(1);