PACKAGE: APPS.OE_PROCESS_REQUISITION_PVT

Source

1 PACKAGE OE_PROCESS_REQUISITION_PVT AUTHID CURRENT_USER AS
2 /* $Header: OEXVPIRS.pls 120.1.12020000.2 2012/09/14 08:06:17 rahujain ship $ */
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_Quantity2_Change       IN  NUMBER DEFAULT NULL --Bug 14211120
19 ,  P_New_Schedule_Ship_Date IN  DATE DEFAULT NULL
20 ,  P_Cancel_Order           IN  BOOLEAN
21 ,  P_Cancel_Line            IN  BOOLEAN
22 ,  X_msg_count              OUT NOCOPY NUMBER
23 ,  X_msg_data               OUT NOCOPY VARCHAR2
24 ,  X_return_status	    OUT NOCOPY VARCHAR2
25 );
26 
27 Procedure Prepare_Notification -- Specification
28 ( p_header_id     IN NUMBER
29 , p_Line_Id_tbl   IN Line_id_tbl DEFAULT NULL
30 , p_performer     IN VARCHAR2
31 , p_cancel_order  IN BOOLEAN
32 , p_notify_for    IN VARCHAR2
33 , p_req_header_id IN NUMBER
34 , p_req_line_id   IN NUMBER DEFAULT NULL
35 , x_return_status OUT NOCOPY VARCHAR2
36 );
37 
38 END OE_PROCESS_REQUISITION_PVT;