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 108: l_line_rec OE_ORDER_PUB.line_rec_type;

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

Line 832: p_line_rec IN OE_ORDER_PUB.line_rec_type,

828: ----------------------------------------------------------------------- */
829:
830: Procedure Decrement_Inventory(
831: p_detail_id IN NUMBER,
832: p_line_rec IN OE_ORDER_PUB.line_rec_type,
833: p_transaction_id IN NUMBER,
834: p_transaction_detail_qty IN NUMBER,
835: p_trans_qty2 IN NUMBER, -- INVCONV
836: p_inventory_item_id IN NUMBER,

Line 1884: p_line_rec IN OE_ORDER_PUB.line_rec_type,

1880: -----------------------------------------------------------------------*/
1881:
1882: /*Procedure Decrement_Inventory_for_OPM(
1883: p_detail_id IN NUMBER,
1884: p_line_rec IN OE_ORDER_PUB.line_rec_type,
1885: p_transaction_id IN NUMBER,
1886: p_trans_qty IN NUMBER,
1887: p_trans_qty2 IN NUMBER,
1888: p_inventory_item_id IN NUMBER,

Line 2176: ,p_line_rec IN OE_ORDER_PUB.Line_Rec_Type

2172: ,p_qty2_to_be_reserved IN NUMBER DEFAULT NULL --INVVCONV
2173: ,p_revision IN VARCHAR2
2174: ,p_locator_id IN NUMBER
2175: ,p_lot IN VARCHAR2
2176: ,p_line_rec IN OE_ORDER_PUB.Line_Rec_Type
2177: ,x_qty_reserved OUT NOCOPY NUMBER
2178: ,x_qty2_reserved OUT NOCOPY NUMBER -- INVCONV
2179: ,x_rsv_id OUT NOCOPY NUMBER
2180: ,x_return_status OUT NOCOPY VARCHAR2

Line 2418: ,p_line_rec IN OE_ORDER_PUB.Line_rec_Type

2414: (p_short_quantity IN NUMBER
2415: ,p_transaction_date IN DATE
2416: ,p_add_to_shipped IN NUMBER
2417: ,p_add_to_shipped2 IN NUMBER
2418: ,p_line_rec IN OE_ORDER_PUB.Line_rec_Type
2419: ,x_return_status OUT NOCOPY VARCHAR2
2420: ,x_msg_count OUT NOCOPY NUMBER
2421: ,x_msg_data OUT NOCOPY VARCHAR2
2422: )

Line 2597: ,p_line_rec IN OE_ORDER_PUB.Line_rec_Type

2593: ,p_short_quantity IN NUMBER
2594: ,p_transaction_date IN DATE
2595: ,p_add_to_shipped IN NUMBER
2596: ,p_add_to_shipped2 IN NUMBER
2597: ,p_line_rec IN OE_ORDER_PUB.Line_rec_Type
2598: ,x_return_status OUT NOCOPY VARCHAR2
2599: )
2600: IS
2601: -- Process Order arguments

Line 2606: l_line_tbl OE_ORDER_PUB.line_tbl_type;

2602: l_msg_count NUMBER;
2603: l_msg_data VARCHAR2(20000);
2604:
2605: l_control_rec OE_GLOBALS.control_rec_type;
2606: l_line_tbl OE_ORDER_PUB.line_tbl_type;
2607: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
2608: l_header_rec OE_Order_PUB.Header_Rec_Type;
2609: l_new_line_rec OE_Order_PUB.Line_Rec_Type;
2610: l_new_line_tbl OE_Order_PUB.Line_Tbl_Type;

Line 2607: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;

2603: l_msg_data VARCHAR2(20000);
2604:
2605: l_control_rec OE_GLOBALS.control_rec_type;
2606: l_line_tbl OE_ORDER_PUB.line_tbl_type;
2607: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
2608: l_header_rec OE_Order_PUB.Header_Rec_Type;
2609: l_new_line_rec OE_Order_PUB.Line_Rec_Type;
2610: l_new_line_tbl OE_Order_PUB.Line_Tbl_Type;
2611: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

Line 2608: l_header_rec OE_Order_PUB.Header_Rec_Type;

2604:
2605: l_control_rec OE_GLOBALS.control_rec_type;
2606: l_line_tbl OE_ORDER_PUB.line_tbl_type;
2607: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
2608: l_header_rec OE_Order_PUB.Header_Rec_Type;
2609: l_new_line_rec OE_Order_PUB.Line_Rec_Type;
2610: l_new_line_tbl OE_Order_PUB.Line_Tbl_Type;
2611: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2612: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

Line 2609: l_new_line_rec OE_Order_PUB.Line_Rec_Type;

2605: l_control_rec OE_GLOBALS.control_rec_type;
2606: l_line_tbl OE_ORDER_PUB.line_tbl_type;
2607: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
2608: l_header_rec OE_Order_PUB.Header_Rec_Type;
2609: l_new_line_rec OE_Order_PUB.Line_Rec_Type;
2610: l_new_line_tbl OE_Order_PUB.Line_Tbl_Type;
2611: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2612: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2613: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

Line 2610: l_new_line_tbl OE_Order_PUB.Line_Tbl_Type;

2606: l_line_tbl OE_ORDER_PUB.line_tbl_type;
2607: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
2608: l_header_rec OE_Order_PUB.Header_Rec_Type;
2609: l_new_line_rec OE_Order_PUB.Line_Rec_Type;
2610: l_new_line_tbl OE_Order_PUB.Line_Tbl_Type;
2611: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2612: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2613: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2614: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

Line 2611: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

2607: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
2608: l_header_rec OE_Order_PUB.Header_Rec_Type;
2609: l_new_line_rec OE_Order_PUB.Line_Rec_Type;
2610: l_new_line_tbl OE_Order_PUB.Line_Tbl_Type;
2611: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2612: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2613: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2614: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2615: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

Line 2612: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

2608: l_header_rec OE_Order_PUB.Header_Rec_Type;
2609: l_new_line_rec OE_Order_PUB.Line_Rec_Type;
2610: l_new_line_tbl OE_Order_PUB.Line_Tbl_Type;
2611: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2612: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2613: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2614: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2615: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2616: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;

Line 2613: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

2609: l_new_line_rec OE_Order_PUB.Line_Rec_Type;
2610: l_new_line_tbl OE_Order_PUB.Line_Tbl_Type;
2611: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2612: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2613: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2614: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2615: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2616: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
2617: l_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;

Line 2614: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

2610: l_new_line_tbl OE_Order_PUB.Line_Tbl_Type;
2611: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2612: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2613: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2614: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2615: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2616: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
2617: l_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
2618: l_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;

Line 2615: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

2611: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2612: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2613: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2614: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2615: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2616: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
2617: l_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
2618: l_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
2619: l_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;

Line 2616: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;

2612: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2613: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2614: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2615: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2616: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
2617: l_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
2618: l_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
2619: l_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
2620: l_Line_Price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;

Line 2617: l_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;

2613: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2614: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2615: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2616: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
2617: l_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
2618: l_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
2619: l_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
2620: l_Line_Price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
2621: l_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;

Line 2618: l_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;

2614: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2615: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2616: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
2617: l_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
2618: l_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
2619: l_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
2620: l_Line_Price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
2621: l_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
2622: l_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;

Line 2619: l_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;

2615: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2616: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
2617: l_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
2618: l_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
2619: l_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
2620: l_Line_Price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
2621: l_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
2622: l_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
2623:

Line 2620: l_Line_Price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;

2616: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
2617: l_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
2618: l_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
2619: l_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
2620: l_Line_Price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
2621: l_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
2622: l_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
2623:
2624: l_req_qty_tbl OE_Ship_Confirmation_Pub.Req_Quantity_Tbl_Type;

Line 2621: l_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;

2617: l_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
2618: l_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
2619: l_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
2620: l_Line_Price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
2621: l_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
2622: l_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
2623:
2624: l_req_qty_tbl OE_Ship_Confirmation_Pub.Req_Quantity_Tbl_Type;
2625:

Line 2622: l_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;

2618: l_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
2619: l_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
2620: l_Line_Price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
2621: l_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
2622: l_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
2623:
2624: l_req_qty_tbl OE_Ship_Confirmation_Pub.Req_Quantity_Tbl_Type;
2625:
2626: l_new_line_id NUMBER;

Line 2630: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;

2626: l_new_line_id NUMBER;
2627: l_return_status VARCHAR2(1);
2628: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2629: --serla begin
2630: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2631: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2632: --serla end
2633: -- tso
2634: l_top_container_model Varchar2(1);

Line 2631: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;

2627: l_return_status VARCHAR2(1);
2628: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2629: --serla begin
2630: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2631: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2632: --serla end
2633: -- tso
2634: l_top_container_model Varchar2(1);
2635: l_part_of_container Varchar2(1);