1 PACKAGE OE_INTERNAL_REQUISITION_PVT AUTHID CURRENT_USER AS
2 /* $Header: OEXVIRQS.pls 120.0.12010000.1 2008/11/19 11:27:03 rmoharan noship $ */
3
4 TYPE Line_id_Rec_Type IS RECORD
5 ( LINE_ID OE_Order_Lines_All.LINE_ID%TYPE
6 , LINE_NUMBER OE_Order_Lines_All.LINE_NUMBER%TYPE
7 , SHIPMENT_NUMBER OE_Order_Lines_All.SHIPMENT_NUMBER%TYPE
8 , HEADER_ID OE_Order_Lines_All.HEADER_ID%TYPE
9 , ORDERED_QUANTITY OE_Order_Lines_All.ORDERED_QUANTITY%TYPE
10 , ORDERED_QUANTITY2 OE_Order_Lines_All.ORDERED_QUANTITY2%TYPE
11 , REQUEST_DATE OE_Order_Lines_All.REQUEST_DATE%TYPE );
12
13 G_ORG_ID OE_Order_Headers_All.ORG_ID%TYPE;
14 G_Update_ISO_From_Req BOOLEAN := FALSE;
15 -- Confirming IR initiated change.This global is created to mark that the change on
16 -- the order line is initiated by the requesting organization. Its value will be read
17 -- while logging delayed requests in OM system for the changes initiated by the
18 -- fulfillment organization user. In that case, no delayed request will be logged if
19 -- this global is set with value TRUE
20
21 Procedure Get_Eligible_ISO_Shipment -- Specification definition
22 ( P_internal_req_line_id IN PO_Requisition_Lines_All.Requisition_Line_id%TYPE
23 , P_internal_req_header_id IN PO_Requisition_Headers_All.Requisition_Header_id%TYPE
24 , X_line_ids_rec OUT NOCOPY Line_Id_Rec_Type
25 , X_return_status OUT NOCOPY VARCHAR2
26 );
27
28 Function Update_Allowed -- Specification definition
29 ( P_line_id IN NUMBER
30 , P_Attribute IN VARCHAR2 DEFAULT NULL
31 ) RETURN BOOLEAN;
32
33 Function Cancel_Allowed -- Specification definition
34 ( P_line_id IN NUMBER
35 ) RETURN BOOLEAN;
36
37 Function Cancel_Header_Allowed -- Specification definition
38 ( P_header_id IN NUMBER
39 ) RETURN BOOLEAN;
40
41 PROCEDURE Process_Line_Entity -- Specification definition
42 (p_line_tbl IN OE_Order_PUB.Line_Tbl_Type
43 ,P_mode IN VARCHAR2
44 ,P_Cancel IN BOOLEAN
45 ,x_return_status OUT NOCOPY VARCHAR2
46 );
47
48 Procedure Apply_Hold_for_IReq -- Specification definition
49 ( P_API_Version IN NUMBER
50 , P_internal_req_line_id IN PO_Requisition_Lines_All.Requisition_Line_id%TYPE
51 , P_internal_req_header_id IN PO_Requisition_Headers_All.Requisition_Header_id%TYPE
52 , X_msg_count OUT NOCOPY NUMBER
53 , X_msg_data OUT NOCOPY VARCHAR2
54 , X_return_status OUT NOCOPY VARCHAR2
55 );
56
57 Procedure Release_Hold_for_IReq -- Specification definition
58 ( P_API_Version IN NUMBER
59 , P_internal_req_line_id IN PO_Requisition_Lines_All.Requisition_Line_id%TYPE
60 , P_internal_req_header_id IN PO_Requisition_Headers_All.Requisition_Header_id%TYPE
61 , X_msg_count OUT NOCOPY NUMBER
62 , X_msg_data OUT NOCOPY VARCHAR2
63 , X_return_status OUT NOCOPY VARCHAR2
64 );
65
66 Procedure Is_IReq_Changable -- Specification definition
67 ( P_API_Version IN NUMBER
68 , P_internal_req_line_id IN PO_Requisition_Lines_All.Requisition_Line_id%TYPE DEFAULT NULL
69 , P_internal_req_header_id IN PO_Requisition_Headers_All.Requisition_Header_id%TYPE DEFAULT NULL
70 , X_Update_Allowed OUT NOCOPY BOOLEAN
71 , X_Cancel_Allowed OUT NOCOPY BOOLEAN
72 , X_msg_count OUT NOCOPY NUMBER
73 , X_msg_data OUT NOCOPY VARCHAR2
74 , X_return_status OUT NOCOPY VARCHAR2
75 );
76
77 Procedure Call_Process_Order_for_IReq -- Specification definition
78 ( P_API_Version IN NUMBER
79 , P_internal_req_line_id IN PO_Requisition_Lines_All.Requisition_Line_id%TYPE
80 , P_internal_req_header_id IN PO_Requisition_Headers_All.Requisition_Header_id%TYPE
81 , P_Mode IN VARCHAR2
82 , P_Cancel_ISO IN BOOLEAN DEFAULT FALSE
83 , P_Cancel_ISO_lines IN BOOLEAN DEFAULT FALSE
84 , P_New_Request_Date IN DATE DEFAULT NULL
85 , P_Delta_Ordered_Qty IN NUMBER DEFAULT 0
86 , X_msg_count OUT NOCOPY NUMBER
87 , X_msg_data OUT NOCOPY VARCHAR2
88 , X_return_status OUT NOCOPY VARCHAR2
89 );
90
91 END OE_INTERNAL_REQUISITION_PVT;