1 PACKAGE CSP_Pack_Serial_Lots_PVT AUTHID CURRENT_USER AS
2 /* $Header: cspvtsps.pls 115.6 2003/05/02 16:40:18 hhaugeru ship $ */
3 -- Start of Comments
4 -- Package name : CSP_Pack_Serial_Lots_PVT
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10 -- Default number of records fetch per call
11 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
12 -- *******************************************************
13 -- Start of Comments
14 -- -------------------------------------------------------
15 -- Record name:plsl_Rec_Type
16 -- -------------------------------------------------------
17 -- Parameters:
18 -- PACKLIST_SERIAL_LOT_ID
19 -- CREATED_BY
20 -- CREATION_DATE
21 -- LAST_UPDATED_BY
22 -- LAST_UPDATE_DATE
23 -- LAST_UPDATE_LOGIN
24 -- PACKLIST_LINE_ID
25 -- ORGANIZATION_ID
26 -- INVENTORY_ITEM_ID
27 -- QUANTITY
28 -- LOT_NUMBER
29 -- SERIAL_NUMBER
30 --
31 -- Required:
32 -- Defaults:
33 -- Note: This is automatic generated record definition, it includes all columns
34 -- defined in the table, developer must manually add or delete some of the attributes.
35 --
36 -- End of Comments
37
38 TYPE plsl_Rec_Type IS RECORD
39 (
40 PACKLIST_SERIAL_LOT_ID NUMBER := FND_API.G_MISS_NUM,
41 CREATED_BY NUMBER := FND_API.G_MISS_NUM,
42 CREATION_DATE DATE := FND_API.G_MISS_DATE,
43 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
44 LAST_UPDATE_DATE DATE:= FND_API.G_MISS_DATE,
45 LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
46 PACKLIST_LINE_ID NUMBER := FND_API.G_MISS_NUM,
47 ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
48 INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
49 QUANTITY NUMBER := FND_API.G_MISS_NUM,
50 LOT_NUMBER VARCHAR2(240) := FND_API.G_MISS_CHAR,
51 SERIAL_NUMBER VARCHAR2(240) := FND_API.G_MISS_CHAR
52 );
53
54 G_MISS_plsl_REC plsl_Rec_Type;
55 TYPE plsl_Tbl_Type IS TABLE OF plsl_Rec_Type
56 INDEX BY BINARY_INTEGER;
57 G_MISS_plsl_TBL plsl_Tbl_Type;
58
59 -- *******************************************************
60 -- Start of Comments
61 -- *******************************************************
62 -- API Name: Create_pack_serial_lots
63 -- Type : Private
64 -- Pre-Req :
65 -- Parameters:
66 -- IN
67 -- p_api_version_number IN NUMBER Required
68 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
69 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
70 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
71 -- P_plsl_Rec IN plsl_Rec_Type Required
72 --
73 -- OUT:
74 -- x_return_status OUT NOCOPY VARCHAR2
75 -- x_msg_count OUT NOCOPY NUMBER
76 -- x_msg_data OUT NOCOPY VARCHAR2
77 -- Version : Current version 2.0
78 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
79 -- and basic operation, developer must manually add parameters and business logic as necessary.
80 --
81 -- End of Comments
82 --
83 PROCEDURE Create_pack_serial_lots(
84 P_Api_Version_Number IN NUMBER,
85 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
86 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
87 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
88 P_plsl_Rec IN plsl_Rec_Type := G_MISS_plsl_REC,
89 --Hint: Add detail tables as parameter lists if it's master-detail relationship.
90 X_PACKLIST_SERIAL_LOT_ID OUT NOCOPY NUMBER,
91 X_Return_Status OUT NOCOPY VARCHAR2,
92 X_Msg_Count OUT NOCOPY NUMBER,
93 X_Msg_Data OUT NOCOPY VARCHAR2
94 );
95
96 -- *******************************************************
97 -- Start of Comments
98 -- *******************************************************
99 -- API Name: Update_pack_serial_lots
100 -- Type : Private
101 -- Pre-Req :
102 -- Parameters:
103 -- IN
104 -- p_api_version_number IN NUMBER Required
105 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
106 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
107 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
108 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
109 -- P_plsl_Rec IN plsl_Rec_Type Required
110 --
111 -- OUT:
112 -- x_return_status OUT NOCOPY VARCHAR2
113 -- x_msg_count OUT NOCOPY NUMBER
114 -- x_msg_data OUT NOCOPY VARCHAR2
115 -- Version : Current version 2.0
116 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
117 -- and basic operation, developer must manually add parameters and business logic as necessary.
118 --
119 -- End of Comments
120 --
121 -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
122 PROCEDURE Update_pack_serial_lots(
123 P_Api_Version_Number IN NUMBER,
124 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
125 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
126 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
127 P_Identity_Salesforce_Id IN NUMBER := NULL,
128 P_plsl_Rec IN plsl_Rec_Type,
129 X_Return_Status OUT NOCOPY VARCHAR2,
130 X_Msg_Count OUT NOCOPY NUMBER,
131 X_Msg_Data OUT NOCOPY VARCHAR2
132 );
133
134 -- *******************************************************
135 -- Start of Comments
136 -- *******************************************************
137 -- API Name: Delete_pack_serial_lots
138 -- Type : Private
139 -- Pre-Req :
140 -- Parameters:
141 -- IN
142 -- p_api_version_number IN NUMBER Required
143 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
144 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
145 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
146 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
147 -- P_plsl_Rec IN plsl_Rec_Type Required
148 --
149 -- OUT:
150 -- x_return_status OUT NOCOPY VARCHAR2
151 -- x_msg_count OUT NOCOPY NUMBER
152 -- x_msg_data OUT NOCOPY VARCHAR2
153 -- Version : Current version 2.0
154 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
155 -- and basic operation, developer must manually add parameters and business logic as necessary.
156 --
157 -- End of Comments
158 --
159 -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
160 -- The Master delete procedure may not be needed depends on different business requirements.
161 PROCEDURE Delete_pack_serial_lots(
162 P_Api_Version_Number IN NUMBER,
163 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
164 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
165 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
166 P_identity_salesforce_id IN NUMBER := NULL,
167 P_plsl_Rec IN plsl_Rec_Type,
168 X_Return_Status OUT NOCOPY VARCHAR2,
169 X_Msg_Count OUT NOCOPY NUMBER,
170 X_Msg_Data OUT NOCOPY VARCHAR2
171 );
172
173 -- Start of Comments
174 --
175 -- Item level validation procedures
176 --
177 -- p_validation_mode is a constant defined in package
178 -- For create: G_CREATE, for update: G_UPDATE
179 -- Note: 1. This is automated generated item level validation procedure.
180 -- The actual validation detail is needed to be added.
181 --
182 -- End of Comments
183
184 PROCEDURE Validate_PL_SERIAL_LOT_ID (
185 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
186 P_Validation_mode IN VARCHAR2,
187 P_PACKLIST_SERIAL_LOT_ID IN NUMBER,
188 -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
189 X_Return_Status OUT NOCOPY VARCHAR2,
190 X_Msg_Count OUT NOCOPY NUMBER,
191 X_Msg_Data OUT NOCOPY VARCHAR2
192 );
193
194 -- Start of Comments
195 --
196 -- Item level validation procedures
197 --
198 -- p_validation_mode is a constant defined in package
199 -- For create: G_CREATE, for update: G_UPDATE
200 -- Note: 1. This is automated generated item level validation procedure.
201 -- The actual validation detail is needed to be added.
202 --
203 -- End of Comments
204
205 PROCEDURE Validate_PACKLIST_LINE_ID (
206 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
207 P_Validation_mode IN VARCHAR2,
208 P_PACKLIST_LINE_ID IN NUMBER,
209 -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
210 X_Return_Status OUT NOCOPY VARCHAR2,
211 X_Msg_Count OUT NOCOPY NUMBER,
212 X_Msg_Data OUT NOCOPY VARCHAR2
213 );
214
215 -- Start of Comments
216 --
217 -- Item level validation procedures
218 --
219 -- p_validation_mode is a constant defined in package
220 -- For create: G_CREATE, for update: G_UPDATE
221 -- Note: 1. This is automated generated item level validation procedure.
222 -- The actual validation detail is needed to be added.
223 --
224 -- End of Comments
225
226 PROCEDURE Validate_ORGANIZATION_ID (
227 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
228 P_Validation_mode IN VARCHAR2,
229 P_ORGANIZATION_ID IN NUMBER,
230 -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
231 X_Return_Status OUT NOCOPY VARCHAR2,
232 X_Msg_Count OUT NOCOPY NUMBER,
233 X_Msg_Data OUT NOCOPY VARCHAR2
234 );
235
236 -- Start of Comments
237 --
238 -- Item level validation procedures
239 --
240 -- p_validation_mode is a constant defined in package
241 -- For create: G_CREATE, for update: G_UPDATE
242 -- Note: 1. This is automated generated item level validation procedure.
243 -- The actual validation detail is needed to be added.
244 --
245 -- End of Comments
246
247 PROCEDURE Validate_INVENTORY_ITEM_ID (
248 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
249 P_Validation_mode IN VARCHAR2,
250 P_INVENTORY_ITEM_ID IN NUMBER,
251 -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
252 X_Return_Status OUT NOCOPY VARCHAR2,
253 X_Msg_Count OUT NOCOPY NUMBER,
254 X_Msg_Data OUT NOCOPY VARCHAR2
255 );
256
257 -- Start of Comments
258 --
259 -- Item level validation procedures
260 --
261 -- p_validation_mode is a constant defined in package
262 -- For create: G_CREATE, for update: G_UPDATE
263 -- Note: 1. This is automated generated item level validation procedure.
264 -- The actual validation detail is needed to be added.
265 --
266 -- End of Comments
267
268 PROCEDURE Validate_QUANTITY (
269 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
270 P_Validation_mode IN VARCHAR2,
271 P_QUANTITY IN NUMBER,
272 -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
273 X_Return_Status OUT NOCOPY VARCHAR2,
274 X_Msg_Count OUT NOCOPY NUMBER,
275 X_Msg_Data OUT NOCOPY VARCHAR2
276 );
277
278 -- Start of Comments
279 --
280 -- Item level validation procedures
281 --
282 -- p_validation_mode is a constant defined in package
283 -- For create: G_CREATE, for update: G_UPDATE
284 -- Note: 1. This is automated generated item level validation procedure.
285 -- The actual validation detail is needed to be added.
286 --
287 -- End of Comments
288
289 PROCEDURE Validate_LOT_NUMBER (
290 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
291 P_Validation_mode IN VARCHAR2,
292 P_LOT_NUMBER IN VARCHAR2,
293 -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
294 X_Return_Status OUT NOCOPY VARCHAR2,
295 X_Msg_Count OUT NOCOPY NUMBER,
296 X_Msg_Data OUT NOCOPY VARCHAR2
297 );
298
299 -- Start of Comments
300 --
301 -- Item level validation procedures
302 --
303 -- p_validation_mode is a constant defined in package
304 -- For create: G_CREATE, for update: G_UPDATE
305 -- Note: 1. This is automated generated item level validation procedure.
306 -- The actual validation detail is needed to be added.
307 --
308 -- End of Comments
309
310 PROCEDURE Validate_SERIAL_NUMBER (
311 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
312 P_Validation_mode IN VARCHAR2,
313 P_SERIAL_NUMBER IN VARCHAR2,
314 -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
315 X_Return_Status OUT NOCOPY VARCHAR2,
316 X_Msg_Count OUT NOCOPY NUMBER,
317 X_Msg_Data OUT NOCOPY VARCHAR2
318 );
319
320 -- Start of Comments
321 --
322 -- Record level validation procedures
323 --
324 -- p_validation_mode is a constant defined in package
325 -- For create: G_CREATE, for update: G_UPDATE
326 -- Note: 1. This is automated generated item level validation procedure.
327 -- The actual validation detail is needed to be added.
328 -- 2. Developer can manually added inter-field level validation.
329 -- End of Comments
330
331 PROCEDURE Validate_plsl_rec(
332 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
333 P_Validation_mode IN VARCHAR2,
334 P_plsl_Rec IN plsl_Rec_Type,
335 X_Return_Status OUT NOCOPY VARCHAR2,
336 X_Msg_Count OUT NOCOPY NUMBER,
337 X_Msg_Data OUT NOCOPY VARCHAR2
338 );
339
340 -- Start of Comments
341 --
342 -- validation procedures
343 --
344 -- p_validation_mode is a constant defined in package
345 -- For create: G_CREATE, for update: G_UPDATE
346 -- Note: 1. This is automated generated item level validation procedure.
347 -- The actual validation detail is needed to be added.
348 -- 2. We can also validate table instead of record. There will be an option for user to choose.
349 -- End of Comments
350
351 PROCEDURE Validate_pack_serial_lots(
352 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
353 P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
354 P_Validation_mode IN VARCHAR2,
355 P_plsl_Rec IN plsl_Rec_Type,
356 X_Return_Status OUT NOCOPY VARCHAR2,
360 End CSP_Pack_Serial_Lots_PVT;
357 X_Msg_Count OUT NOCOPY NUMBER,
358 X_Msg_Data OUT NOCOPY VARCHAR2
359 );