1 PACKAGE OE_PROCESS_REQUISITION_PVT AS
2 /* $Header: OEXVPIRS.pls 120.0.12010000.2 2008/11/24 05:53:36 vbkapoor noship $ */
3
4 TYPE Line_id_tbl is TABLE OF NUMBER;
5
6 PROCEDURE SET_ORG_CONTEXT -- Specification details
7 ( p_org_id IN NUMBER
8 );
9
10 Procedure Update_Internal_Requisition -- Specification definition
11 ( P_Header_id IN NUMBER
12 , P_Line_id IN NUMBER
13 , P_Line_ids IN VARCHAR2
14 , p_num_records IN NUMBER
15 , P_Req_Header_id IN NUMBER
16 , P_Req_Line_id IN NUMBER DEFAULT NULL
17 , P_Quantity_Change IN NUMBER DEFAULT NULL
18 , P_New_Schedule_Ship_Date IN DATE DEFAULT NULL
19 , P_Cancel_Order IN BOOLEAN
20 , P_Cancel_Line IN BOOLEAN
21 , X_msg_count OUT NOCOPY NUMBER
22 , X_msg_data OUT NOCOPY VARCHAR2
23 , X_return_status OUT NOCOPY VARCHAR2
24 );
25
26 Procedure Prepare_Notification -- Specification
27 ( p_header_id IN NUMBER
28 , p_Line_Id_tbl IN Line_id_tbl DEFAULT NULL
29 , p_performer IN VARCHAR2
30 , p_cancel_order IN BOOLEAN
31 , p_notify_for IN VARCHAR2
32 , p_req_header_id IN NUMBER
33 , p_req_line_id IN NUMBER DEFAULT NULL
34 , x_return_status OUT NOCOPY VARCHAR2
35 );
36
37 END OE_PROCESS_REQUISITION_PVT;