1 PACKAGE AHL_OSP_RCV_PVT AS
2 /* $Header: AHLVORCS.pls 120.1 2008/02/12 09:16:35 sathapli noship $ */
3
4 ---------------------------------------------------------------------
5 -- Define Record Types for record structures needed by the APIs --
6 ---------------------------------------------------------------------
7
8 -- Record of attributes needed to do a receipt against an RMA.
9 -- Also included attributes needed for Part Number/Serial Number change and for doing an Exchange.
10 TYPE RMA_Receipt_Rec_Type IS RECORD (
11 RETURN_LINE_ID NUMBER,
12 RECEIVING_ORG_ID NUMBER,
13 RECEIVING_SUBINVENTORY VARCHAR2(10),
14 RECEIVING_LOCATOR_ID NUMBER,
15 RECEIPT_QUANTITY NUMBER,
16 RECEIPT_UOM_CODE VARCHAR2(3),
17 RECEIPT_DATE DATE,
18 -- Following NEW% attributes are for use only if Part Number/Serial Number change is to be done.
19 NEW_ITEM_ID NUMBER,
20 NEW_SERIAL_NUMBER VARCHAR2(30),
21 NEW_SERIAL_TAG_CODE VARCHAR2(30),
22 NEW_LOT_NUMBER VARCHAR2(80),
23 NEW_ITEM_REV_NUMBER VARCHAR2(3),
24 -- Following EXCHANGE% attributes are for use only if Exchange is to be done.
25 EXCHANGE_ITEM_ID NUMBER,
26 EXCHANGE_SERIAL_NUMBER VARCHAR2(30),
27 EXCHANGE_LOT_NUMBER VARCHAR2(80)
28 );
29
30
31 ---------------------------------------------------------------------
32 -- Define the APIs for the package --
33 ---------------------------------------------------------------------
34
35 -- Start of Comments --
36 -- Function name : Can_Receive_Against_OSP
37 -- Type : Public
38 -- Functionality : Function to determine if an OSP Order is 'ready for receipt'.
39 -- It returns FND_API.G_TRUE if a receipt can be done. Otherwise, it returns FND_API.G_FALSE.
40 -- Pre-reqs :
41 --
42 -- Parameters:
43 --
44 -- p_osp_order_id IN NUMBER OSP Order Id
45 --
46 -- Version:
47 --
48 -- Initial Version 1.0
49 --
50 -- End of Comments --
51
52 FUNCTION Can_Receive_Against_OSP (
53 p_osp_order_id IN NUMBER
54 )
55 RETURN VARCHAR2;
56
57
58 -- Start of Comments --
59 -- Function name : Can_Receive_Against_PO
60 -- Type : Public
61 -- Functionality : Function to determine if a receipt against PO can be done given an RMA line.
62 -- It returns FND_API.G_TRUE if a receipt can be done. Otherwise, it returns FND_API.G_FALSE.
63 -- Pre-reqs :
64 --
65 -- Parameters:
66 --
67 -- p_return_line_id IN NUMBER RMA Line Id
68 --
69 -- Version:
70 --
71 -- Initial Version 1.0
72 --
73 -- End of Comments --
74
75 FUNCTION Can_Receive_Against_PO (
76 p_return_line_id IN NUMBER
77 )
78 RETURN VARCHAR2;
79
80
81 -- Start of Comments --
82 -- Function name : Can_Receive_Against_RMA
83 -- Type : Public
84 -- Functionality : Function to determine if a receipt can be done against a given RMA line.
85 -- It returns FND_API.G_TRUE if a receipt can be done. Otherwise, it returns FND_API.G_FALSE.
86 -- Pre-reqs :
87 --
88 -- Parameters:
89 --
90 -- p_return_line_id IN NUMBER RMA Line Id
91 --
92 -- Version:
93 --
94 -- Initial Version 1.0
95 --
96 -- End of Comments --
97
98 FUNCTION Can_Receive_Against_RMA (
99 p_return_line_id IN NUMBER
100 )
101 RETURN VARCHAR2;
102
103
104 -- Start of Comments --
105 -- Procedure name : Receive_Against_PO
106 -- Type : Public
107 -- Functionality : Procedure to receive against PO lines given an RMA line.
108 -- Pre-reqs :
109 --
110 -- Parameters:
111 --
112 -- Standard IN Parameters:
113 -- p_api_version IN NUMBER Required
114 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
115 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
116 -- p_validation_level IN NUMBER Required
117 -- p_module_type IN VARCHAR2 Default NULL
118 --
119 -- Standard OUT Parameters:
120 -- x_return_status OUT VARCHAR2 Required
121 -- x_msg_count OUT NUMBER Required
122 -- x_msg_data OUT VARCHAR2 Required
123 --
124 -- Receive_Against_PO Parameters:
125 -- p_return_line_id IN NUMBER RMA Line Id
126 -- x_request_id OUT NUMBER Request id of the call request of the concurrent program, i.e. 'RVCTP'.
127 --
128 -- Version:
129 --
130 -- Initial Version 1.0
131 --
132 -- End of Comments --
133
134 PROCEDURE Receive_Against_PO (
135 p_api_version IN NUMBER,
136 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
137 p_commit IN VARCHAR2 := FND_API.G_FALSE,
138 p_validation_level IN NUMBER,
139 p_module_type IN VARCHAR2 := NULL,
140 x_return_status OUT NOCOPY VARCHAR2,
141 x_msg_count OUT NOCOPY NUMBER,
142 x_msg_data OUT NOCOPY VARCHAR2,
143 p_return_line_id IN NUMBER,
144 x_request_id OUT NOCOPY NUMBER
145 );
146
147
148 -- Start of Comments --
149 -- Procedure name : Receive_Against_RMA
150 -- Type : Public
151 -- Functionality : Procedure to receive against a given RMA line.
152 -- Also does any Part Number/Serial Number change or an Exchange prior to doing the receipt.
153 -- Pre-reqs :
154 --
155 -- Parameters:
156 --
157 -- Standard IN Parameters:
158 -- p_api_version IN NUMBER Required
159 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
160 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
161 -- p_validation_level IN NUMBER Required
162 -- p_module_type IN VARCHAR2 Default NULL
163 --
164 -- Standard OUT Parameters:
165 -- x_return_status OUT VARCHAR2 Required
166 -- x_msg_count OUT NUMBER Required
167 -- x_msg_data OUT VARCHAR2 Required
168 --
169 -- Receive_Against_PO Parameters:
170 -- p_rma_receipt_rec IN RMA_Receipt_Rec_Type RMA receipt record
171 -- x_request_id OUT NUMBER Request id of the call request of the concurrent program, i.e. 'RVCTP'.
172 -- x_return_line_id OUT NUMBER New RMA Line id against which the receipt has been done.
173 --
174 -- Version:
175 --
176 -- Initial Version 1.0
177 --
178 -- End of Comments --
179
180 PROCEDURE Receive_Against_RMA (
181 p_api_version IN NUMBER,
182 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
183 p_commit IN VARCHAR2 := FND_API.G_FALSE,
184 p_validation_level IN NUMBER,
185 p_module_type IN VARCHAR2 := NULL,
186 x_return_status OUT NOCOPY VARCHAR2,
187 x_msg_count OUT NOCOPY NUMBER,
188 x_msg_data OUT NOCOPY VARCHAR2,
189 p_rma_receipt_rec IN RMA_Receipt_Rec_Type,
190 x_request_id OUT NOCOPY NUMBER,
191 x_return_line_id OUT NOCOPY NUMBER
192 );
193
194 END AHL_OSP_RCV_PVT;