1 PACKAGE CSP_PACKLIST_LINES_PVT AUTHID CURRENT_USER AS
2 /* $Header: cspvtals.pls 115.6 2003/05/02 16:34:50 hhaugeru ship $ */
3 -- Start of Comments
4 -- Package name : CSP_PACKLIST_LINES_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:PLL_Rec_Type
16 -- -------------------------------------------------------
17 -- Parameters:
18 -- PACKLIST_LINE_ID
19 -- CREATED_BY
20 -- CREATION_DATE
21 -- LAST_UPDATED_BY
22 -- LAST_UPDATE_DATE
23 -- LAST_UPDATE_LOGIN
24 -- ORGANIZATION_ID
25 -- PACKLIST_LINE_NUMBER
26 -- PACKLIST_HEADER_ID
27 -- BOX_ID
28 -- PICKLIST_LINE_ID
29 -- PACKLIST_LINE_STATUS
30 -- INVENTORY_ITEM_ID
31 -- QUANTITY_PACKED
32 -- QUANTITY_SHIPPED
33 -- QUANTITY_RECEIVED
34 -- ATTRIBUTE_CATEGORY
35 -- ATTRIBUTE1
36 -- ATTRIBUTE2
37 -- ATTRIBUTE3
38 -- ATTRIBUTE4
39 -- ATTRIBUTE5
40 -- ATTRIBUTE6
41 -- ATTRIBUTE7
42 -- ATTRIBUTE8
43 -- ATTRIBUTE9
44 -- ATTRIBUTE10
45 -- ATTRIBUTE11
46 -- ATTRIBUTE12
47 -- ATTRIBUTE13
48 -- ATTRIBUTE14
49 -- ATTRIBUTE15
50 -- UOM_CODE
51 -- LINE_ID
52 --
53 -- Required:
54 -- Defaults:
55 -- Note: This is automatic generated record definition, it includes all columns
56 -- defined in the table, developer must manually add or delete some of the attributes.
57 --
58 -- End of Comments
59
60 TYPE PLL_Rec_Type IS RECORD
61 (
62 PACKLIST_LINE_ID NUMBER := FND_API.G_MISS_NUM,
63 CREATED_BY NUMBER := FND_API.G_MISS_NUM,
64 CREATION_DATE DATE := FND_API.G_MISS_DATE,
65 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
66 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
67 LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
68 ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
69 PACKLIST_LINE_NUMBER NUMBER := FND_API.G_MISS_NUM,
70 PACKLIST_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
71 BOX_ID NUMBER := FND_API.G_MISS_NUM,
72 PICKLIST_LINE_ID NUMBER := FND_API.G_MISS_NUM,
73 PACKLIST_LINE_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
74 INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
75 QUANTITY_PACKED NUMBER := FND_API.G_MISS_NUM,
76 QUANTITY_SHIPPED NUMBER := FND_API.G_MISS_NUM,
77 QUANTITY_RECEIVED NUMBER := FND_API.G_MISS_NUM,
78 ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
79 ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80 ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81 ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82 ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83 ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84 ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85 ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86 ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87 ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88 ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89 ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90 ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91 ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92 ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93 ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94 UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
95 LINE_ID NUMBER := FND_API.G_MISS_NUM
96 );
97
98 G_MISS_PLL_REC PLL_Rec_Type;
99 TYPE PLL_Tbl_Type IS TABLE OF PLL_Rec_Type
100 INDEX BY BINARY_INTEGER;
101 G_MISS_PLL_TBL PLL_Tbl_Type;
102
103 -- *******************************************************
104 -- Start of Comments
105 -- *******************************************************
106 -- API Name: Create_packlist_lines
107 -- Type : Private
108 -- Pre-Req :
109 -- Parameters:
110 -- IN
111 -- p_api_version_number IN NUMBER Required
112 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
113 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
114 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
115 -- P_PLL_Rec IN PLL_Rec_Type Required
116 --
117 -- OUT:
118 -- x_return_status OUT NOCOPY VARCHAR2
119 -- x_msg_count OUT NOCOPY NUMBER
120 -- x_msg_data OUT NOCOPY VARCHAR2
121 -- Version : Current version 2.0
122 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
123 -- and basic operation, developer must manually add parameters and business logic as necessary.
124 --
125 -- End of Comments
126 --
127 PROCEDURE Create_packlist_lines(
128 P_Api_Version_Number IN NUMBER,
129 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
130 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
131 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
132 P_PLL_Rec IN PLL_Rec_Type := G_MISS_PLL_REC,
133 --Hint: Add detail tables as parameter lists if it's master-detail relationship.
134 X_PACKLIST_LINE_ID OUT NOCOPY NUMBER,
135 X_Return_Status OUT NOCOPY VARCHAR2,
136 X_Msg_Count OUT NOCOPY NUMBER,
137 X_Msg_Data OUT NOCOPY VARCHAR2
138 );
139
140 -- *******************************************************
141 -- Start of Comments
142 -- *******************************************************
143 -- API Name: Update_packlist_lines
144 -- Type : Private
145 -- Pre-Req :
146 -- Parameters:
147 -- IN
148 -- p_api_version_number IN NUMBER Required
149 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
150 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
151 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
152 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
153 -- P_PLL_Rec IN PLL_Rec_Type Required
154 --
155 -- OUT:
156 -- x_return_status OUT NOCOPY VARCHAR2
157 -- x_msg_count OUT NOCOPY NUMBER
158 -- x_msg_data OUT NOCOPY VARCHAR2
159 -- Version : Current version 2.0
160 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
161 -- and basic operation, developer must manually add parameters and business logic as necessary.
162 --
163 -- End of Comments
164 --
165 -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
166 PROCEDURE Update_packlist_lines(
167 P_Api_Version_Number IN NUMBER,
168 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
169 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
170 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
171 P_Identity_Salesforce_Id IN NUMBER := NULL,
172 P_PLL_Rec IN PLL_Rec_Type,
173 X_Return_Status OUT NOCOPY VARCHAR2,
174 X_Msg_Count OUT NOCOPY NUMBER,
175 X_Msg_Data OUT NOCOPY VARCHAR2
176 );
177
178 -- *******************************************************
179 -- Start of Comments
180 -- *******************************************************
181 -- API Name: Delete_packlist_lines
182 -- Type : Private
183 -- Pre-Req :
184 -- Parameters:
185 -- IN
186 -- p_api_version_number IN NUMBER Required
187 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
188 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
189 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
190 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
191 -- P_PLL_Rec IN PLL_Rec_Type Required
192 --
193 -- OUT:
194 -- x_return_status OUT NOCOPY VARCHAR2
195 -- x_msg_count OUT NOCOPY NUMBER
196 -- x_msg_data OUT NOCOPY VARCHAR2
197 -- Version : Current version 2.0
198 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
199 -- and basic operation, developer must manually add parameters and business logic as necessary.
200 --
201 -- End of Comments
202 --
203 -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
204 -- The Master delete procedure may not be needed depends on different business requirements.
205 PROCEDURE Delete_packlist_lines(
206 P_Api_Version_Number IN NUMBER,
207 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
208 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
209 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
210 P_identity_salesforce_id IN NUMBER := NULL,
211 P_PLL_Rec IN PLL_Rec_Type,
212 X_Return_Status OUT NOCOPY VARCHAR2,
213 X_Msg_Count OUT NOCOPY NUMBER,
214 X_Msg_Data OUT NOCOPY VARCHAR2
215 );
216
217
218 -- Start of Comments
219 --
220 -- Item level validation procedures
221 --
222 -- p_validation_mode is a constant defined in package
223 -- For create: G_CREATE, for update: G_UPDATE
224 -- Note: 1. This is automated generated item level validation procedure.
225 -- The actual validation detail is needed to be added.
226 --
227 -- End of Comments
228
229 PROCEDURE Validate_PACKLIST_LINE_ID (
230 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
231 P_Validation_mode IN VARCHAR2,
232 P_PACKLIST_LINE_ID IN NUMBER,
233 -- 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.
234 X_Return_Status OUT NOCOPY VARCHAR2,
235 X_Msg_Count OUT NOCOPY NUMBER,
236 X_Msg_Data OUT NOCOPY VARCHAR2
237 );
238
239 -- Start of Comments
240 --
241 -- Item level validation procedures
242 --
243 -- p_validation_mode is a constant defined in package
244 -- For create: G_CREATE, for update: G_UPDATE
245 -- Note: 1. This is automated generated item level validation procedure.
246 -- The actual validation detail is needed to be added.
247 --
248 -- End of Comments
249
250 PROCEDURE Validate_ORGANIZATION_ID (
251 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
252 P_Validation_mode IN VARCHAR2,
253 P_ORGANIZATION_ID IN NUMBER,
254 -- 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.
255 X_Return_Status OUT NOCOPY VARCHAR2,
256 X_Msg_Count OUT NOCOPY NUMBER,
257 X_Msg_Data OUT NOCOPY VARCHAR2
258 );
259
260 -- Start of Comments
261 --
262 -- Item level validation procedures
263 --
264 -- p_validation_mode is a constant defined in package
265 -- For create: G_CREATE, for update: G_UPDATE
266 -- Note: 1. This is automated generated item level validation procedure.
267 -- The actual validation detail is needed to be added.
268 --
269 -- End of Comments
270
271 PROCEDURE Validate_PACKLIST_LINE_NUMBER (
272 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
273 P_Validation_mode IN VARCHAR2,
274 P_PACKLIST_LINE_NUMBER IN NUMBER,
275 -- 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.
276 X_Return_Status OUT NOCOPY VARCHAR2,
277 X_Msg_Count OUT NOCOPY NUMBER,
278 X_Msg_Data OUT NOCOPY VARCHAR2
279 );
280
281 -- Start of Comments
282 --
283 -- Item level validation procedures
284 --
285 -- p_validation_mode is a constant defined in package
286 -- For create: G_CREATE, for update: G_UPDATE
287 -- Note: 1. This is automated generated item level validation procedure.
288 -- The actual validation detail is needed to be added.
289 --
290 -- End of Comments
291
292 PROCEDURE Validate_PACKLIST_HEADER_ID (
293 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
294 P_Validation_mode IN VARCHAR2,
295 P_PACKLIST_HEADER_ID IN NUMBER,
296 -- 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.
297 X_Return_Status OUT NOCOPY VARCHAR2,
298 X_Msg_Count OUT NOCOPY NUMBER,
299 X_Msg_Data OUT NOCOPY VARCHAR2
300 );
301
302 -- Start of Comments
303 --
304 -- Item level validation procedures
305 --
306 -- p_validation_mode is a constant defined in package
307 -- For create: G_CREATE, for update: G_UPDATE
308 -- Note: 1. This is automated generated item level validation procedure.
309 -- The actual validation detail is needed to be added.
310 --
311 -- End of Comments
312
313 PROCEDURE Validate_BOX_ID (
314 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
315 P_Validation_mode IN VARCHAR2,
316 P_BOX_ID IN NUMBER,
317 -- 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.
318 X_Return_Status OUT NOCOPY VARCHAR2,
319 X_Msg_Count OUT NOCOPY NUMBER,
320 X_Msg_Data OUT NOCOPY VARCHAR2
321 );
322
323 -- Start of Comments
324 --
325 -- Item level validation procedures
326 --
327 -- p_validation_mode is a constant defined in package
328 -- For create: G_CREATE, for update: G_UPDATE
329 -- Note: 1. This is automated generated item level validation procedure.
330 -- The actual validation detail is needed to be added.
331 --
332 -- End of Comments
333
334 PROCEDURE Validate_PICKLIST_LINE_ID (
335 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
336 P_Validation_mode IN VARCHAR2,
337 P_PICKLIST_LINE_ID IN NUMBER,
338 -- 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.
339 X_Return_Status OUT NOCOPY VARCHAR2,
340 X_Msg_Count OUT NOCOPY NUMBER,
341 X_Msg_Data OUT NOCOPY VARCHAR2
342 );
343
344 -- Start of Comments
345 --
346 -- Item level validation procedures
347 --
348 -- p_validation_mode is a constant defined in package
349 -- For create: G_CREATE, for update: G_UPDATE
350 -- Note: 1. This is automated generated item level validation procedure.
354
351 -- The actual validation detail is needed to be added.
352 --
353 -- End of Comments
355 PROCEDURE Validate_PACKLIST_LINE_STATUS (
356 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
357 P_Validation_mode IN VARCHAR2,
358 P_PACKLIST_LINE_STATUS IN VARCHAR2,
359 -- 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.
360 X_Return_Status OUT NOCOPY VARCHAR2,
361 X_Msg_Count OUT NOCOPY NUMBER,
362 X_Msg_Data OUT NOCOPY VARCHAR2
363 );
364
365 -- Start of Comments
366 --
367 -- Item level validation procedures
368 --
369 -- p_validation_mode is a constant defined in package
370 -- For create: G_CREATE, for update: G_UPDATE
371 -- Note: 1. This is automated generated item level validation procedure.
372 -- The actual validation detail is needed to be added.
373 --
374 -- End of Comments
375
376 PROCEDURE Validate_INVENTORY_ITEM_ID (
377 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
378 P_Validation_mode IN VARCHAR2,
379 P_INVENTORY_ITEM_ID IN NUMBER,
380 -- 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.
381 X_Return_Status OUT NOCOPY VARCHAR2,
382 X_Msg_Count OUT NOCOPY NUMBER,
383 X_Msg_Data OUT NOCOPY VARCHAR2
384 );
385
386 -- Start of Comments
387 --
388 -- Item level validation procedures
389 --
390 -- p_validation_mode is a constant defined in package
391 -- For create: G_CREATE, for update: G_UPDATE
392 -- Note: 1. This is automated generated item level validation procedure.
393 -- The actual validation detail is needed to be added.
394 --
395 -- End of Comments
396
397 PROCEDURE Validate_QUANTITY_PACKED (
398 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
399 P_Validation_mode IN VARCHAR2,
400 P_QUANTITY_PACKED IN NUMBER,
401 -- 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.
402 X_Return_Status OUT NOCOPY VARCHAR2,
403 X_Msg_Count OUT NOCOPY NUMBER,
404 X_Msg_Data OUT NOCOPY VARCHAR2
405 );
406
407 -- Start of Comments
408 --
409 -- Item level validation procedures
410 --
411 -- p_validation_mode is a constant defined in package
412 -- For create: G_CREATE, for update: G_UPDATE
413 -- Note: 1. This is automated generated item level validation procedure.
414 -- The actual validation detail is needed to be added.
415 --
416 -- End of Comments
417
418 PROCEDURE Validate_QUANTITY_SHIPPED (
419 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
420 P_Validation_mode IN VARCHAR2,
421 P_QUANTITY_SHIPPED IN NUMBER,
422 -- 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.
423 X_Return_Status OUT NOCOPY VARCHAR2,
424 X_Msg_Count OUT NOCOPY NUMBER,
425 X_Msg_Data OUT NOCOPY VARCHAR2
426 );
427
428 -- Start of Comments
429 --
430 -- Item level validation procedures
431 --
432 -- p_validation_mode is a constant defined in package
433 -- For create: G_CREATE, for update: G_UPDATE
434 -- Note: 1. This is automated generated item level validation procedure.
435 -- The actual validation detail is needed to be added.
436 --
437 -- End of Comments
438
439 PROCEDURE Validate_QUANTITY_RECEIVED (
440 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
441 P_Validation_mode IN VARCHAR2,
442 P_QUANTITY_RECEIVED IN NUMBER,
443 -- 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.
444 X_Return_Status OUT NOCOPY VARCHAR2,
445 X_Msg_Count OUT NOCOPY NUMBER,
446 X_Msg_Data OUT NOCOPY VARCHAR2
447 );
448
449 -- Start of Comments
450 --
451 -- Item level validation procedures
452 --
453 -- p_validation_mode is a constant defined in package
454 -- For create: G_CREATE, for update: G_UPDATE
455 -- Note: 1. This is automated generated item level validation procedure.
456 -- The actual validation detail is needed to be added.
457 --
458 -- End of Comments
459
460 PROCEDURE Validate_UOM_CODE (
461 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
462 P_Validation_mode IN VARCHAR2,
463 P_UOM_CODE IN VARCHAR2,
464 -- 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.
465 X_Return_Status OUT NOCOPY VARCHAR2,
466 X_Msg_Count OUT NOCOPY NUMBER,
467 X_Msg_Data OUT NOCOPY VARCHAR2
468 );
469
470 -- Start of Comments
471 --
472 -- Item level validation procedures
476 -- Note: 1. This is automated generated item level validation procedure.
473 --
474 -- p_validation_mode is a constant defined in package
475 -- For create: G_CREATE, for update: G_UPDATE
477 -- The actual validation detail is needed to be added.
478 --
479 -- End of Comments
480
481 PROCEDURE Validate_LINE_ID (
482 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
483 P_Validation_mode IN VARCHAR2,
484 P_LINE_ID IN NUMBER,
485 -- 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.
486 X_Return_Status OUT NOCOPY VARCHAR2,
487 X_Msg_Count OUT NOCOPY NUMBER,
488 X_Msg_Data OUT NOCOPY VARCHAR2
489 );
490
491 -- Start of Comments
492 --
493 -- Record level validation procedures
494 --
495 -- p_validation_mode is a constant defined in package
496 -- For create: G_CREATE, for update: G_UPDATE
497 -- Note: 1. This is automated generated item level validation procedure.
498 -- The actual validation detail is needed to be added.
499 -- 2. Developer can manually added inter-field level validation.
500 -- End of Comments
501
502 PROCEDURE Validate_PLL_rec(
503 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
504 P_Validation_mode IN VARCHAR2,
505 P_PLL_Rec IN PLL_Rec_Type,
506 X_Return_Status OUT NOCOPY VARCHAR2,
507 X_Msg_Count OUT NOCOPY NUMBER,
508 X_Msg_Data OUT NOCOPY VARCHAR2
509 );
510
511 -- Start of Comments
512 --
513 -- validation procedures
514 --
515 -- p_validation_mode is a constant defined in package
516 -- For create: G_CREATE, for update: G_UPDATE
517 -- Note: 1. This is automated generated item level validation procedure.
518 -- The actual validation detail is needed to be added.
519 -- 2. We can also validate table instead of record. There will be an option for user to choose.
520 -- End of Comments
521
522 PROCEDURE Validate_packlist_lines(
523 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
524 P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
525 P_Validation_mode IN VARCHAR2,
526 P_PLL_Rec IN PLL_Rec_Type,
527 X_Return_Status OUT NOCOPY VARCHAR2,
528 X_Msg_Count OUT NOCOPY NUMBER,
529 X_Msg_Data OUT NOCOPY VARCHAR2
530 );
531 End CSP_PACKLIST_LINES_PVT;