DBA Data[Home] [Help]

PACKAGE: APPS.OE_PROCESS_REQUISITION_PVT

Source


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;