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