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