1 PACKAGE CSD_GROUP_SERIAL_NUMBER_PVT AUTHID CURRENT_USER as
2 /* $Header: csdvsrns.pls 115.5 2002/11/14 01:49:49 swai noship $ */
3 --
4 -- Package name : CSD_GROUP_SERIAL_NUMBER_PVT
5 -- Purpose : This package contains the private APIs for creating,
6 -- updating, deleting serial numbers. Access is
7 -- restricted to Oracle Depot Rapair Internal Development.
8 -- History :
9 -- Version Date Name Description
10 -- 115.0 05/07/01 askumar Created.
11
12
13 --
14 -- -------------------------------------------------------
15 -- Record name :
16 -- This record type will be used for creating and updating the
17 -- Repair Orders.
18 -- -------------------------------------------------------
19
20 TYPE SERIAL_NUMBER_Rec_Type IS RECORD
21 ( MRO_SERIAL_NUMBER_ID NUMBER,
22 REPAIR_GROUP_ID NUMBER,
23 IB_FLAG VARCHAR2(1),
24 INVENTORY_ITEM_ID NUMBER,
25 SERIAL_NUMBER VARCHAR2(30),
26 VALIDATE_LEVEL VARCHAR2(2),
27 VALID_FLAG VARCHAR2(1),
28 CONTEXT VARCHAR2(30),
29 ATTRIBUTE1 VARCHAR2(150),
30 ATTRIBUTE2 VARCHAR2(150),
31 ATTRIBUTE3 VARCHAR2(150),
32 ATTRIBUTE4 VARCHAR2(150),
33 ATTRIBUTE5 VARCHAR2(150),
34 ATTRIBUTE6 VARCHAR2(150),
35 ATTRIBUTE7 VARCHAR2(150),
36 ATTRIBUTE8 VARCHAR2(150),
37 ATTRIBUTE9 VARCHAR2(150),
38 ATTRIBUTE10 VARCHAR2(150),
39 ATTRIBUTE11 VARCHAR2(150),
40 ATTRIBUTE12 VARCHAR2(150),
41 ATTRIBUTE13 VARCHAR2(150),
42 ATTRIBUTE14 VARCHAR2(150),
43 ATTRIBUTE15 VARCHAR2(150),
44 OBJECT_VERSION_NUMBER NUMBER,
45 CUSTOMER_PRODUCT_ID NUMBER,
46 REFERENCE_NUMBER VARCHAR2(30));
47
48
49 --
50 -- *******************************************************
51 -- API Name: Create_Serial_Number
52 -- Type : Private
53 -- Pre-Req : None
54 -- Parameters:
55 -- IN
56 -- p_api_version_number IN NUMBER Required
57 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
58 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
59 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
60
61 -- x_MRO_Serial_Number_Rec IN OUT NOCOPY CSD_GROUP_SERIAL_NUMBER_PVT.SERIAL_NUMBER_Rec_Type
62 -- x_return_status OUT NOCOPY VARCHAR2
63 -- x_msg_count OUT NOCOPY NUMBER
64 -- x_msg_data OUT NOCOPY VARCHAR2
65 --
66 -- Version : Current version 1.0
67 -- Initial Version 1.0
68 --
69 -- Notes: This API will create a Serial Numbers entered via the Serial
70 -- Number Capture Screen. They will be validated against IB or
71 -- Service Inventory if the user opted for them.
72 --
73 PROCEDURE Create_Serial_Number(
74 P_Api_Version_Number IN NUMBER,
75 P_Init_Msg_List IN VARCHAR2,
76 P_Commit IN VARCHAR2,
77 p_validation_level IN NUMBER,
78 x_MRO_Serial_Number_rec IN OUT NOCOPY CSD_GROUP_SERIAL_NUMBER_PVT.SERIAL_NUMBER_Rec_Type,
79 X_Return_Status OUT NOCOPY VARCHAR2,
80 X_Msg_Count OUT NOCOPY NUMBER,
81 X_Msg_Data OUT NOCOPY VARCHAR2
82 );
83 --
84 -- *******************************************************
85 -- API Name: Update_Serial_Number
86 -- Type : Private
87 -- Pre-Req : None
88 -- Parameters:
89 -- IN
90 -- p_api_version_number IN NUMBER Required
91 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
92 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
93 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
94
95 -- x_MRO_Serial_Number_Rec IN OUT NOCOPY CSD_GROUP_SERIAL_NUMBER_PVT.SERIAL_NUMBER_Rec_Type
96 -- x_return_status OUT NOCOPY VARCHAR2
97 -- x_msg_count OUT NOCOPY NUMBER
98 -- x_msg_data OUT NOCOPY VARCHAR2
99 --
100 -- Version : Current version 1.0
101 -- Initial Version 1.0
102 --
103 -- Notes: This API will update a Serial Numbers entered via the Serial
104 -- Number Capture Screen. They will be validated against IB or
105 -- Service Inventory if the user opted for them.
106 --
107 PROCEDURE Update_Serial_Number(
108 P_Api_Version_Number IN NUMBER,
109 P_Init_Msg_List IN VARCHAR2,
110 P_Commit IN VARCHAR2,
111 p_validation_level IN NUMBER,
112 x_MRO_Serial_Number_rec IN OUT NOCOPY CSD_GROUP_SERIAL_NUMBER_PVT.SERIAL_NUMBER_Rec_Type,
113 X_Return_Status OUT NOCOPY VARCHAR2,
114 X_Msg_Count OUT NOCOPY NUMBER,
115 X_Msg_Data OUT NOCOPY VARCHAR2
116 );
117
118 -- *******************************************************
119 -- API Name: Delete_Serial_Number
120 -- Type : Private
121 -- Pre-Req :
122 -- Parameters:
123 -- IN
124 -- p_api_version_number IN NUMBER Required
125 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
126 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
127 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
128 -- p_MRO_Serial_Number_ID IN NUMBER Required
129 -- x_return_status OUT NOCOPY VARCHAR2
130 -- x_msg_count OUT NOCOPY NUMBER
131 -- x_msg_data OUT NOCOPY VARCHAR2
132 --
133 -- Version : Current Version 1.0
134 -- Initial Version 1.0
135 --
136 -- Notes: This API will delete a Serial Numbers entered via the Serial
137 -- Number Capture Screen.
138 --
139 PROCEDURE Delete_Serial_Number(
140 P_Api_Version_Number IN NUMBER,
141 P_Init_Msg_List IN VARCHAR2,
142 P_Commit IN VARCHAR2,
143 p_validation_level IN NUMBER,
144 p_MRO_Serial_Number_ID IN NUMBER,
145 X_Return_Status OUT NOCOPY VARCHAR2,
146 X_Msg_Count OUT NOCOPY NUMBER,
147 X_Msg_Data OUT NOCOPY VARCHAR2
148 );
149
150
151 -- *******************************************************
152 -- API Name: Lock_Serial_Number
153 -- Type : Private
154 -- Pre-Req :
155 -- Parameters:
156 -- IN
157 -- p_api_version_number IN NUMBER Required
158 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
159 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
160 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
161 -- x_MRO_Serial_Number_Rec IN OUT NOCOPY CSD_GROUP_SERIAL_NUMBER_PVT.SERIAL_NUMBER_Rec_Type
162 -- x_return_status OUT NOCOPY VARCHAR2
163 -- x_msg_count OUT NOCOPY NUMBER
164 -- x_msg_data OUT NOCOPY VARCHAR2
165 --
166 -- Version : Current Version 1.0
167 -- Initial Version 1.0
168 --
169 -- Notes: This API will Lock a Serial Numbers entered via the Serial
170 -- Number Capture Screen.
171 --
172 PROCEDURE Lock_Serial_Number(
173 P_Api_Version_Number IN NUMBER,
174 P_Init_Msg_List IN VARCHAR2,
175 P_Commit IN VARCHAR2,
176 p_validation_level IN NUMBER,
177 x_MRO_Serial_Number_rec IN CSD_GROUP_SERIAL_NUMBER_PVT.SERIAL_NUMBER_Rec_Type,
178 X_Return_Status OUT NOCOPY VARCHAR2,
179 X_Msg_Count OUT NOCOPY NUMBER,
180 X_Msg_Data OUT NOCOPY VARCHAR2
181 );
182
183
184 /*------------------------------------------------------------*/
185 /* This function verifies that the item is a valid inventory */
186 /* item and is marked as 'Trackable' */
187 /*------------------------------------------------------------*/
188 FUNCTION Is_ib_trackable
189 (
190 p_inv_item_id IN NUMBER,
191 p_stack_err_msg IN BOOLEAN
192 )
193 RETURN BOOLEAN;
194
195 /*------------------------------------------------------------*/
196 /* This function verifies that the item is a serialized */
197 /* item or not */
198 /*------------------------------------------------------------*/
199
200 FUNCTION Is_serialized
201 (
202 p_inv_item_id IN NUMBER,
203 p_item_number IN VARCHAR2,
204 p_stack_err_msg IN BOOLEAN
205 )
206 RETURN BOOLEAN;
207
208
209 /*------------------------------------------------------------*/
210 -- Procedure: Validate_Serial_Number (for 11.5.7.1 development)
211 -- Purpose: Validate serial numbers entered via the
212 -- serial number capture screen
213 /*------------------------------------------------------------*/
214 PROCEDURE Validate_Serial_Number
215 (
216 p_ib_flag IN VARCHAR2,
217 p_inv_item_id IN NUMBER,
218 p_serial_number IN VARCHAR2,
219 x_return_value OUT NOCOPY VARCHAR2
220 );
221
222
223 /*------------------------------------------------------------*/
224 -- Procedure: Is_Duplicate_Serial_Num (11.5.7.1 development)
225 -- Purpose: Checks if serial numbers entered are duplicates
226 /*------------------------------------------------------------*/
227
228 PROCEDURE Is_Duplicate_Serial_Num
229 (p_Api_Version_Number IN NUMBER,
230 P_Init_Msg_List IN VARCHAR2,
231 P_Commit IN VARCHAR2,
232 p_validation_level IN NUMBER,
233 p_repair_group_id IN NUMBER,
234 p_serial_number IN VARCHAR2,
235 x_return_value OUT NOCOPY BOOLEAN,
236 X_Return_Status OUT NOCOPY VARCHAR2,
237 X_Msg_Count OUT NOCOPY NUMBER,
238 X_Msg_Data OUT NOCOPY VARCHAR2
239 );
240
241 End CSD_GROUP_SERIAL_NUMBER_PVT;