1 PACKAGE CSD_REPAIR_HISTORY_PVT AUTHID CURRENT_USER as
2 /* $Header: csdvdrhs.pls 120.0.12010000.2 2009/09/02 03:31:41 takwong ship $ */
3 -- Start of Comments
4 -- Package name : CSD_REPAIR_HISTORY_PVT
5 -- Purpose :
6 -- History :
7 -- 02/05/02 travi Added Object Version Number Column
8 -- NOTE :
9 -- End of Comments
10
11 -- Default number of records fetch per call
12 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
13 -- *******************************************************
14 -- Start of Comments
15 -- -------------------------------------------------------
16 -- Record name:REPH_Rec_Type
17 -- -------------------------------------------------------
18 -- Parameters:
19 -- REPAIR_HISTORY_ID
20 -- OBJECT_VERSION_NUMBER
21 -- REQUEST_ID
22 -- PROGRAM_ID
23 -- PROGRAM_APPLICATION_ID
24 -- PROGRAM_UPDATE_DATE
25 -- CREATED_BY
26 -- CREATION_DATE
27 -- LAST_UPDATED_BY
28 -- LAST_UPDATE_DATE
29 -- REPAIR_LINE_ID
30 -- EVENT_CODE
31 -- EVENT_DATE
32 -- QUANTITY
33 -- PARAMN1
34 -- PARAMN2
35 -- PARAMN3
36 -- PARAMN4
37 -- PARAMN5
38 -- PARAMN6
39 -- PARAMN7
40 -- PARAMN8
41 -- PARAMN9
42 -- PARAMN10
43 -- PARAMC1
44 -- PARAMC2
45 -- PARAMC3
46 -- PARAMC4
47 -- PARAMC5
48 -- PARAMC6
49 -- PARAMC7
50 -- PARAMC8
51 -- PARAMC9
52 -- PARAMC10
53 -- PARAMD1
54 -- PARAMD2
55 -- PARAMD3
56 -- PARAMD4
57 -- PARAMD5
58 -- PARAMD6
59 -- PARAMD7
60 -- PARAMD8
61 -- PARAMD9
62 -- PARAMD10
63 -- ATTRIBUTE_CATEGORY
64 -- ATTRIBUTE1
65 -- ATTRIBUTE2
66 -- ATTRIBUTE3
67 -- ATTRIBUTE4
68 -- ATTRIBUTE5
69 -- ATTRIBUTE6
70 -- ATTRIBUTE7
71 -- ATTRIBUTE8
72 -- ATTRIBUTE9
73 -- ATTRIBUTE10
74 -- ATTRIBUTE11
75 -- ATTRIBUTE12
76 -- ATTRIBUTE13
77 -- ATTRIBUTE14
78 -- ATTRIBUTE15
79 -- LAST_UPDATE_LOGIN
80 --
81 -- Required:
82 -- Defaults:
83 -- Note: This is automatic generated record definition, it includes all columns
84 -- defined in the table, developer must manually add or delete some of the attributes.
85 --
86 -- End of Comments
87
88
89
90
91 TYPE REPH_sort_rec_type IS RECORD
92 (
93 -- Please define your own sort by record here.
94 REQUEST_ID NUMBER := NULL
95 );
96 TYPE REPH_Rec_Type IS RECORD
97 (
98 REPAIR_HISTORY_ID NUMBER := FND_API.G_MISS_NUM,
99 OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
100 REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
101 PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
102 PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
103 PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
104 CREATED_BY NUMBER := FND_API.G_MISS_NUM,
105 CREATION_DATE DATE := FND_API.G_MISS_DATE,
106 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
107 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
108 REPAIR_LINE_ID NUMBER := FND_API.G_MISS_NUM,
109 EVENT_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
110 EVENT_MEANING VARCHAR2(30) := FND_API.G_MISS_CHAR,
111 EVENT_DATE DATE := FND_API.G_MISS_DATE,
112 QUANTITY NUMBER := FND_API.G_MISS_NUM,
113 PARAMN1 NUMBER := FND_API.G_MISS_NUM,
114 PARAMN2 NUMBER := FND_API.G_MISS_NUM,
115 PARAMN3 NUMBER := FND_API.G_MISS_NUM,
116 PARAMN4 NUMBER := FND_API.G_MISS_NUM,
117 PARAMN5 NUMBER := FND_API.G_MISS_NUM,
118 PARAMN6 NUMBER := FND_API.G_MISS_NUM,
119 PARAMN7 NUMBER := FND_API.G_MISS_NUM,
120 PARAMN8 NUMBER := FND_API.G_MISS_NUM,
121 PARAMN9 NUMBER := FND_API.G_MISS_NUM,
122 PARAMN10 NUMBER := FND_API.G_MISS_NUM,
123 PARAMC1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
124 PARAMC2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
125 PARAMC3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
126 PARAMC4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
127 PARAMC5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
128 PARAMC6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
129 PARAMC7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
130 PARAMC8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
131 PARAMC9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
132 PARAMC10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
133 PARAMD1 DATE := FND_API.G_MISS_DATE,
134 PARAMD2 DATE := FND_API.G_MISS_DATE,
135 PARAMD3 DATE := FND_API.G_MISS_DATE,
136 PARAMD4 DATE := FND_API.G_MISS_DATE,
137 PARAMD5 DATE := FND_API.G_MISS_DATE,
138 PARAMD6 DATE := FND_API.G_MISS_DATE,
139 PARAMD7 DATE := FND_API.G_MISS_DATE,
140 PARAMD8 DATE := FND_API.G_MISS_DATE,
141 PARAMD9 DATE := FND_API.G_MISS_DATE,
142 PARAMD10 DATE := FND_API.G_MISS_DATE,
143 ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
144 ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
145 ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
146 ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
147 ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
148 ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
149 ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
150 ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
151 ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
152 ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
153 ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
154 ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
155 ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
156 ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
157 ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
158 ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
159 LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
160 );
161
162 G_MISS_REPH_REC REPH_Rec_Type;
163 TYPE REPH_Tbl_Type IS TABLE OF REPH_Rec_Type
164 INDEX BY BINARY_INTEGER;
165 G_MISS_REPH_TBL REPH_Tbl_Type;
166
167 -- *******************************************************
168 -- Start of Comments
169 -- *******************************************************
170 -- API Name: Create_repair_history
171 -- Type : Private
172 -- Pre-Req :
173 -- Parameters:
174 -- IN
175 -- p_api_version_number IN NUMBER Required
176 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
177 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
178 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
179 -- P_REPH_Rec IN REPH_Rec_Type Required
180 --
181 -- OUT:
182 -- x_return_status OUT NOCOPY VARCHAR2
183 -- x_msg_count OUT NOCOPY NUMBER
184 -- x_msg_data OUT NOCOPY VARCHAR2
185 -- Version : Current version 2.0
186 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
187 -- and basic operation, developer must manually add parameters and business logic as necessary.
188 --
189 -- End of Comments
190 --
191 PROCEDURE Create_repair_history(
192 P_Api_Version_Number IN NUMBER,
193 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
194 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
195 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
196 P_REPH_Rec IN REPH_Rec_Type := G_MISS_REPH_REC,
197 --Hint: Add detail tables as parameter lists if it's master-detail relationship.
198 X_REPAIR_HISTORY_ID OUT NOCOPY NUMBER,
199 X_Return_Status OUT NOCOPY VARCHAR2,
200 X_Msg_Count OUT NOCOPY NUMBER,
201 X_Msg_Data OUT NOCOPY VARCHAR2
202 );
203
204 -- *******************************************************
205 -- Start of Comments
206 -- *******************************************************
207 -- API Name: Update_repair_history
208 -- Type : Private
209 -- Pre-Req :
210 -- Parameters:
211 -- IN
212 -- p_api_version_number IN NUMBER Required
213 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
214 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
215 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
216 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
217 -- P_REPH_Rec IN REPH_Rec_Type Required
218 --
219 -- OUT:
220 -- x_return_status OUT NOCOPY VARCHAR2
221 -- x_msg_count OUT NOCOPY NUMBER
222 -- x_msg_data OUT NOCOPY VARCHAR2
223 -- Version : Current version 2.0
224 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
225 -- and basic operation, developer must manually add parameters and business logic as necessary.
226 --
227 -- End of Comments
228 --
229 -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
230 PROCEDURE Update_repair_history(
231 P_Api_Version_Number IN NUMBER,
232 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
233 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
234 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
235 P_REPH_Rec IN REPH_Rec_Type,
236 X_Return_Status OUT NOCOPY VARCHAR2,
237 X_Msg_Count OUT NOCOPY NUMBER,
238 X_Msg_Data OUT NOCOPY VARCHAR2
239 );
240
241 -- *******************************************************
242 -- Start of Comments
243 -- *******************************************************
244 -- API Name: Delete_repair_history
245 -- Type : Private
246 -- Pre-Req :
247 -- Parameters:
248 -- IN
249 -- p_api_version_number IN NUMBER Required
250 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
251 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
252 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
253 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
254 -- P_REPH_Rec IN REPH_Rec_Type Required
255 --
256 -- OUT:
257 -- x_return_status OUT NOCOPY VARCHAR2
258 -- x_msg_count OUT NOCOPY NUMBER
259 -- x_msg_data OUT NOCOPY VARCHAR2
260 -- Version : Current version 2.0
261 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
262 -- and basic operation, developer must manually add parameters and business logic as necessary.
263 --
264 -- End of Comments
265 --
266 -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
267 -- The Master delete procedure may not be needed depends on different business requirements.
268 PROCEDURE Delete_repair_history(
269 P_Api_Version_Number IN NUMBER,
270 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
271 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
272 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
273 P_REPH_Rec IN REPH_Rec_Type,
274 X_Return_Status OUT NOCOPY VARCHAR2,
275 X_Msg_Count OUT NOCOPY NUMBER,
276 X_Msg_Data OUT NOCOPY VARCHAR2
277 );
278
279 -- *******************************************************
280 -- Start of Comments
281 -- *******************************************************
282 -- API Name: Get_repair_history
283 -- Type : Private
284 -- Pre-Req :
285 -- Parameters:
286 -- IN
287 -- p_api_version_number IN NUMBER Required
288 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
289 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
290 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
291 -- P_REPH_Rec IN REPH_Rec_Type Required
292 -- Hint: Add List of bind variables here
293 -- p_rec_requested IN NUMBER Optional Default = 30
294 -- p_start_rec_ptr IN NUMBER Optional Default = 1
295 --
296 -- Return Total Records Count Flag. This flag controls whether the total record count
297 -- and total record amount is returned.
298 --
299 -- p_return_tot_count IN VARCHAR2 Optional Default = FND_API.G_FALSE
300 -- Hint: User defined record type
301 -- p_order_by_tbl IN JTF_PLSQL_API.UTIL_ORDER_BY_TBL_TYPE;
302 --
303 -- OUT:
304 -- x_return_status OUT NOCOPY VARCHAR2
305 -- x_msg_count OUT NOCOPY NUMBER
306 -- x_msg_data OUT NOCOPY VARCHAR2
307 -- X_REPH_Tbl OUT NOCOPY REPH_Rec_Type
308 -- x_returned_rec_count OUT NOCOPY NUMBER
309 -- x_next_rec_ptr OUT NOCOPY NUMBER
310 -- x_tot_rec_count OUT NOCOPY NUMBER
311 -- other optional OUT parameters
312 -- x_tot_rec_amount OUT NOCOPY NUMBER
313 -- Version : Current version 2.0
314 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
315 -- and basic operation, developer must manually add parameters and business logic as necessary.
319 PROCEDURE Get_repair_history(
316 --
317 -- End of Comments
318 --
320 P_Api_Version_Number IN NUMBER,
321 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
322 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
323 P_identity_salesforce_id IN NUMBER := NULL,
324 P_REPH_Rec IN REPH_Rec_Type,
325 -- Hint: Add list of bind variables here
326 p_rec_requested IN NUMBER := G_DEFAULT_NUM_REC_FETCH,
327 p_start_rec_prt IN NUMBER := 1,
328 p_return_tot_count IN NUMBER := FND_API.G_FALSE,
329 -- Hint: user defined record type
330 p_order_by_rec IN REPH_sort_rec_type,
331 x_return_status OUT NOCOPY VARCHAR2,
332 x_msg_count OUT NOCOPY NUMBER,
333 x_msg_data OUT NOCOPY VARCHAR2,
334 X_REPH_Tbl OUT NOCOPY REPH_Tbl_Type,
335 x_returned_rec_count OUT NOCOPY NUMBER,
336 x_next_rec_ptr OUT NOCOPY NUMBER,
337 x_tot_rec_count OUT NOCOPY NUMBER
338 -- other optional parameters
339 -- x_tot_rec_amount OUT NOCOPY NUMBER
340 );
341
342
343 -- Start of Comments
344 --
345 -- Item level validation procedures
346 --
347 -- p_validation_mode is a constant defined in package
348 -- For create: G_CREATE, for update: G_UPDATE
349 -- Note: 1. This is automated generated item level validation procedure.
350 -- The actual validation detail is needed to be added.
351 --
352 -- End of Comments
353
354 PROCEDURE Validate_REPAIR_HISTORY_ID (
355 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
356 P_Validation_mode IN VARCHAR2,
357 P_REPAIR_HISTORY_ID IN NUMBER,
358 -- 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.
359 X_Return_Status OUT NOCOPY VARCHAR2,
360 X_Msg_Count OUT NOCOPY NUMBER,
361 X_Msg_Data OUT NOCOPY VARCHAR2
362 );
363
364 -- Start of Comments
365 --
366 -- Item level validation procedures
367 --
368 -- p_validation_mode is a constant defined in package
369 -- For create: G_CREATE, for update: G_UPDATE
370 -- Note: 1. This is automated generated item level validation procedure.
371 -- The actual validation detail is needed to be added.
372 --
373 -- End of Comments
374
375 PROCEDURE Validate_REQUEST_ID (
376 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
377 P_Validation_mode IN VARCHAR2,
378 P_REQUEST_ID IN NUMBER,
379 -- 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.
380 X_Return_Status OUT NOCOPY VARCHAR2,
381 X_Msg_Count OUT NOCOPY NUMBER,
382 X_Msg_Data OUT NOCOPY VARCHAR2
383 );
384
385 -- Start of Comments
386 --
387 -- Item level validation procedures
388 --
389 -- p_validation_mode is a constant defined in package
390 -- For create: G_CREATE, for update: G_UPDATE
391 -- Note: 1. This is automated generated item level validation procedure.
392 -- The actual validation detail is needed to be added.
393 --
394 -- End of Comments
395
396 PROCEDURE Validate_REPAIR_LINE_ID (
397 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
398 P_Validation_mode IN VARCHAR2,
399 P_REPAIR_LINE_ID IN NUMBER,
400 -- 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.
401 X_Return_Status OUT NOCOPY VARCHAR2,
402 X_Msg_Count OUT NOCOPY NUMBER,
403 X_Msg_Data OUT NOCOPY VARCHAR2
404 );
405
406 -- Start of Comments
407 --
408 -- Item level validation procedures
409 --
410 -- p_validation_mode is a constant defined in package
411 -- For create: G_CREATE, for update: G_UPDATE
412 -- Note: 1. This is automated generated item level validation procedure.
413 -- The actual validation detail is needed to be added.
414 --
415 -- End of Comments
416
417 PROCEDURE Validate_EVENT_CODE (
418 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
419 P_Validation_mode IN VARCHAR2,
420 P_EVENT_CODE IN VARCHAR2,
421 -- 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.
422 X_Return_Status OUT NOCOPY VARCHAR2,
423 X_Msg_Count OUT NOCOPY NUMBER,
424 X_Msg_Data OUT NOCOPY VARCHAR2
425 );
426
427
428
429
430 PROCEDURE Validate_event_meaning (
431 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
432 P_Validation_mode IN VARCHAR2,
433 P_EVENT_meaning IN VARCHAR2,
434 -- 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.
438 );
435 X_Return_Status OUT NOCOPY VARCHAR2,
436 X_Msg_Count OUT NOCOPY NUMBER,
437 X_Msg_Data OUT NOCOPY VARCHAR2
439 -- Start of Comments
440 --
441 -- Item level validation procedures
442 --
443 -- p_validation_mode is a constant defined in package
444 -- For create: G_CREATE, for update: G_UPDATE
445 -- Note: 1. This is automated generated item level validation procedure.
446 -- The actual validation detail is needed to be added.
447 --
448 -- End of Comments
449
450 PROCEDURE Validate_EVENT_DATE (
451 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
452 P_Validation_mode IN VARCHAR2,
453 P_EVENT_DATE IN DATE,
454 -- 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.
455 X_Return_Status OUT NOCOPY VARCHAR2,
456 X_Msg_Count OUT NOCOPY NUMBER,
457 X_Msg_Data OUT NOCOPY VARCHAR2
458 );
459
460 -- Start of Comments
461 --
462 -- Item level validation procedures
463 --
464 -- p_validation_mode is a constant defined in package
465 -- For create: G_CREATE, for update: G_UPDATE
466 -- Note: 1. This is automated generated item level validation procedure.
467 -- The actual validation detail is needed to be added.
468 --
469 -- End of Comments
470
471 PROCEDURE Validate_QUANTITY (
472 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
473 P_Validation_mode IN VARCHAR2,
474 P_QUANTITY IN NUMBER,
475 -- 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.
476 X_Return_Status OUT NOCOPY VARCHAR2,
477 X_Msg_Count OUT NOCOPY NUMBER,
478 X_Msg_Data OUT NOCOPY VARCHAR2
479 );
480
481 -- Start of Comments
482 --
483 -- Item level validation procedures
484 --
485 -- p_validation_mode is a constant defined in package
486 -- For create: G_CREATE, for update: G_UPDATE
487 -- Note: 1. This is automated generated item level validation procedure.
488 -- The actual validation detail is needed to be added.
489 --
490 -- End of Comments
491
492 PROCEDURE Validate_PARAMN1 (
493 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
494 P_Validation_mode IN VARCHAR2,
495 P_PARAMN1 IN NUMBER,
496 -- 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.
497 X_Return_Status OUT NOCOPY VARCHAR2,
498 X_Msg_Count OUT NOCOPY NUMBER,
499 X_Msg_Data OUT NOCOPY VARCHAR2
500 );
501
502 -- Start of Comments
503 --
504 -- Item level validation procedures
505 --
506 -- p_validation_mode is a constant defined in package
507 -- For create: G_CREATE, for update: G_UPDATE
508 -- Note: 1. This is automated generated item level validation procedure.
509 -- The actual validation detail is needed to be added.
510 --
511 -- End of Comments
512
513 PROCEDURE Validate_PARAMN2 (
514 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
515 P_Validation_mode IN VARCHAR2,
516 P_PARAMN2 IN NUMBER,
517 -- 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.
518 X_Return_Status OUT NOCOPY VARCHAR2,
519 X_Msg_Count OUT NOCOPY NUMBER,
520 X_Msg_Data OUT NOCOPY VARCHAR2
521 );
522
523 -- Start of Comments
524 --
525 -- Item level validation procedures
526 --
527 -- p_validation_mode is a constant defined in package
528 -- For create: G_CREATE, for update: G_UPDATE
529 -- Note: 1. This is automated generated item level validation procedure.
530 -- The actual validation detail is needed to be added.
531 --
532 -- End of Comments
533
534 PROCEDURE Validate_PARAMN3 (
535 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
536 P_Validation_mode IN VARCHAR2,
537 P_PARAMN3 IN NUMBER,
538 -- 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.
539 X_Return_Status OUT NOCOPY VARCHAR2,
540 X_Msg_Count OUT NOCOPY NUMBER,
541 X_Msg_Data OUT NOCOPY VARCHAR2
542 );
543
544 -- Start of Comments
545 --
546 -- Item level validation procedures
547 --
548 -- p_validation_mode is a constant defined in package
549 -- For create: G_CREATE, for update: G_UPDATE
550 -- Note: 1. This is automated generated item level validation procedure.
551 -- The actual validation detail is needed to be added.
552 --
553 -- End of Comments
554
555 PROCEDURE Validate_PARAMN4 (
556 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
557 P_Validation_mode IN VARCHAR2,
558 P_PARAMN4 IN NUMBER,
562 X_Msg_Data OUT NOCOPY VARCHAR2
559 -- 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.
560 X_Return_Status OUT NOCOPY VARCHAR2,
561 X_Msg_Count OUT NOCOPY NUMBER,
563 );
564
565 -- Start of Comments
566 --
567 -- Item level validation procedures
568 --
569 -- p_validation_mode is a constant defined in package
570 -- For create: G_CREATE, for update: G_UPDATE
571 -- Note: 1. This is automated generated item level validation procedure.
572 -- The actual validation detail is needed to be added.
573 --
574 -- End of Comments
575
576 PROCEDURE Validate_PARAMN5 (
577 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
578 P_Validation_mode IN VARCHAR2,
579 P_PARAMN5 IN NUMBER,
580 -- 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.
581 X_Return_Status OUT NOCOPY VARCHAR2,
582 X_Msg_Count OUT NOCOPY NUMBER,
583 X_Msg_Data OUT NOCOPY VARCHAR2
584 );
585
586 -- Start of Comments
587 --
588 -- Item level validation procedures
589 --
590 -- p_validation_mode is a constant defined in package
591 -- For create: G_CREATE, for update: G_UPDATE
592 -- Note: 1. This is automated generated item level validation procedure.
593 -- The actual validation detail is needed to be added.
594 --
595 -- End of Comments
596
597 PROCEDURE Validate_PARAMN6 (
598 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
599 P_Validation_mode IN VARCHAR2,
600 P_PARAMN6 IN NUMBER,
601 -- 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.
602 X_Return_Status OUT NOCOPY VARCHAR2,
603 X_Msg_Count OUT NOCOPY NUMBER,
604 X_Msg_Data OUT NOCOPY VARCHAR2
605 );
606
607 -- Start of Comments
608 --
609 -- Item level validation procedures
610 --
611 -- p_validation_mode is a constant defined in package
612 -- For create: G_CREATE, for update: G_UPDATE
613 -- Note: 1. This is automated generated item level validation procedure.
614 -- The actual validation detail is needed to be added.
615 --
616 -- End of Comments
617
618 PROCEDURE Validate_PARAMN7 (
619 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
620 P_Validation_mode IN VARCHAR2,
621 P_PARAMN7 IN NUMBER,
622 -- 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.
623 X_Return_Status OUT NOCOPY VARCHAR2,
624 X_Msg_Count OUT NOCOPY NUMBER,
625 X_Msg_Data OUT NOCOPY VARCHAR2
626 );
627
628 -- Start of Comments
629 --
630 -- Item level validation procedures
631 --
632 -- p_validation_mode is a constant defined in package
633 -- For create: G_CREATE, for update: G_UPDATE
634 -- Note: 1. This is automated generated item level validation procedure.
635 -- The actual validation detail is needed to be added.
636 --
637 -- End of Comments
638
639 PROCEDURE Validate_PARAMN8 (
640 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
641 P_Validation_mode IN VARCHAR2,
642 P_PARAMN8 IN NUMBER,
643 -- 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.
644 X_Return_Status OUT NOCOPY VARCHAR2,
645 X_Msg_Count OUT NOCOPY NUMBER,
646 X_Msg_Data OUT NOCOPY VARCHAR2
647 );
648
649 -- Start of Comments
650 --
651 -- Item level validation procedures
652 --
653 -- p_validation_mode is a constant defined in package
654 -- For create: G_CREATE, for update: G_UPDATE
655 -- Note: 1. This is automated generated item level validation procedure.
656 -- The actual validation detail is needed to be added.
657 --
658 -- End of Comments
659
660 PROCEDURE Validate_PARAMN9 (
661 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
662 P_Validation_mode IN VARCHAR2,
663 P_PARAMN9 IN NUMBER,
664 -- 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.
665 X_Return_Status OUT NOCOPY VARCHAR2,
666 X_Msg_Count OUT NOCOPY NUMBER,
667 X_Msg_Data OUT NOCOPY VARCHAR2
668 );
669
670 -- Start of Comments
671 --
672 -- Item level validation procedures
673 --
674 -- p_validation_mode is a constant defined in package
675 -- For create: G_CREATE, for update: G_UPDATE
676 -- Note: 1. This is automated generated item level validation procedure.
677 -- The actual validation detail is needed to be added.
678 --
679 -- End of Comments
680
681 PROCEDURE Validate_PARAMN10 (
685 -- 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.
682 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
683 P_Validation_mode IN VARCHAR2,
684 P_PARAMN10 IN NUMBER,
686 X_Return_Status OUT NOCOPY VARCHAR2,
687 X_Msg_Count OUT NOCOPY NUMBER,
688 X_Msg_Data OUT NOCOPY VARCHAR2
689 );
690
691 -- Start of Comments
692 --
693 -- Item level validation procedures
694 --
695 -- p_validation_mode is a constant defined in package
696 -- For create: G_CREATE, for update: G_UPDATE
697 -- Note: 1. This is automated generated item level validation procedure.
698 -- The actual validation detail is needed to be added.
699 --
700 -- End of Comments
701
702 PROCEDURE Validate_PARAMC1 (
703 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
704 P_Validation_mode IN VARCHAR2,
705 P_PARAMC1 IN VARCHAR2,
706 -- 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.
707 X_Return_Status OUT NOCOPY VARCHAR2,
708 X_Msg_Count OUT NOCOPY NUMBER,
709 X_Msg_Data OUT NOCOPY VARCHAR2
710 );
711
712 -- Start of Comments
713 --
714 -- Item level validation procedures
715 --
716 -- p_validation_mode is a constant defined in package
717 -- For create: G_CREATE, for update: G_UPDATE
718 -- Note: 1. This is automated generated item level validation procedure.
719 -- The actual validation detail is needed to be added.
720 --
721 -- End of Comments
722
723 PROCEDURE Validate_PARAMC2 (
724 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
725 P_Validation_mode IN VARCHAR2,
726 P_PARAMC2 IN VARCHAR2,
727 -- 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.
728 X_Return_Status OUT NOCOPY VARCHAR2,
729 X_Msg_Count OUT NOCOPY NUMBER,
730 X_Msg_Data OUT NOCOPY VARCHAR2
731 );
732
733 -- Start of Comments
734 --
735 -- Item level validation procedures
736 --
737 -- p_validation_mode is a constant defined in package
738 -- For create: G_CREATE, for update: G_UPDATE
739 -- Note: 1. This is automated generated item level validation procedure.
740 -- The actual validation detail is needed to be added.
741 --
742 -- End of Comments
743
744 PROCEDURE Validate_PARAMC3 (
745 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
746 P_Validation_mode IN VARCHAR2,
747 P_PARAMC3 IN VARCHAR2,
748 -- 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.
749 X_Return_Status OUT NOCOPY VARCHAR2,
750 X_Msg_Count OUT NOCOPY NUMBER,
751 X_Msg_Data OUT NOCOPY VARCHAR2
752 );
753
754 -- Start of Comments
755 --
756 -- Item level validation procedures
757 --
758 -- p_validation_mode is a constant defined in package
759 -- For create: G_CREATE, for update: G_UPDATE
760 -- Note: 1. This is automated generated item level validation procedure.
761 -- The actual validation detail is needed to be added.
762 --
763 -- End of Comments
764
765 PROCEDURE Validate_PARAMC4 (
766 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
767 P_Validation_mode IN VARCHAR2,
768 P_PARAMC4 IN VARCHAR2,
769 -- 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.
770 X_Return_Status OUT NOCOPY VARCHAR2,
771 X_Msg_Count OUT NOCOPY NUMBER,
772 X_Msg_Data OUT NOCOPY VARCHAR2
773 );
774
775 -- Start of Comments
776 --
777 -- Item level validation procedures
778 --
779 -- p_validation_mode is a constant defined in package
780 -- For create: G_CREATE, for update: G_UPDATE
781 -- Note: 1. This is automated generated item level validation procedure.
782 -- The actual validation detail is needed to be added.
783 --
784 -- End of Comments
785
786 PROCEDURE Validate_PARAMC5 (
787 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
788 P_Validation_mode IN VARCHAR2,
789 P_PARAMC5 IN VARCHAR2,
790 -- 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.
791 X_Return_Status OUT NOCOPY VARCHAR2,
792 X_Msg_Count OUT NOCOPY NUMBER,
793 X_Msg_Data OUT NOCOPY VARCHAR2
794 );
795
796 -- Start of Comments
797 --
798 -- Item level validation procedures
799 --
800 -- p_validation_mode is a constant defined in package
801 -- For create: G_CREATE, for update: G_UPDATE
802 -- Note: 1. This is automated generated item level validation procedure.
806
803 -- The actual validation detail is needed to be added.
804 --
805 -- End of Comments
807 PROCEDURE Validate_PARAMC6 (
808 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
809 P_Validation_mode IN VARCHAR2,
810 P_PARAMC6 IN VARCHAR2,
811 -- 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.
812 X_Return_Status OUT NOCOPY VARCHAR2,
813 X_Msg_Count OUT NOCOPY NUMBER,
814 X_Msg_Data OUT NOCOPY VARCHAR2
815 );
816
817 -- Start of Comments
818 --
819 -- Item level validation procedures
820 --
821 -- p_validation_mode is a constant defined in package
822 -- For create: G_CREATE, for update: G_UPDATE
823 -- Note: 1. This is automated generated item level validation procedure.
824 -- The actual validation detail is needed to be added.
825 --
826 -- End of Comments
827
828 PROCEDURE Validate_PARAMC7 (
829 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
830 P_Validation_mode IN VARCHAR2,
831 P_PARAMC7 IN VARCHAR2,
832 -- 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.
833 X_Return_Status OUT NOCOPY VARCHAR2,
834 X_Msg_Count OUT NOCOPY NUMBER,
835 X_Msg_Data OUT NOCOPY VARCHAR2
836 );
837
838 -- Start of Comments
839 --
840 -- Item level validation procedures
841 --
842 -- p_validation_mode is a constant defined in package
843 -- For create: G_CREATE, for update: G_UPDATE
844 -- Note: 1. This is automated generated item level validation procedure.
845 -- The actual validation detail is needed to be added.
846 --
847 -- End of Comments
848
849 PROCEDURE Validate_PARAMC8 (
850 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
851 P_Validation_mode IN VARCHAR2,
852 P_PARAMC8 IN VARCHAR2,
853 -- 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.
854 X_Return_Status OUT NOCOPY VARCHAR2,
855 X_Msg_Count OUT NOCOPY NUMBER,
856 X_Msg_Data OUT NOCOPY VARCHAR2
857 );
858
859 -- Start of Comments
860 --
861 -- Item level validation procedures
862 --
863 -- p_validation_mode is a constant defined in package
864 -- For create: G_CREATE, for update: G_UPDATE
865 -- Note: 1. This is automated generated item level validation procedure.
866 -- The actual validation detail is needed to be added.
867 --
868 -- End of Comments
869
870 PROCEDURE Validate_PARAMC9 (
871 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
872 P_Validation_mode IN VARCHAR2,
873 P_PARAMC9 IN VARCHAR2,
874 -- 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.
875 X_Return_Status OUT NOCOPY VARCHAR2,
876 X_Msg_Count OUT NOCOPY NUMBER,
877 X_Msg_Data OUT NOCOPY VARCHAR2
878 );
879
880 -- Start of Comments
881 --
882 -- Item level validation procedures
883 --
884 -- p_validation_mode is a constant defined in package
885 -- For create: G_CREATE, for update: G_UPDATE
886 -- Note: 1. This is automated generated item level validation procedure.
887 -- The actual validation detail is needed to be added.
888 --
889 -- End of Comments
890
891 PROCEDURE Validate_PARAMC10 (
892 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
893 P_Validation_mode IN VARCHAR2,
894 P_PARAMC10 IN VARCHAR2,
895 -- 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.
896 X_Return_Status OUT NOCOPY VARCHAR2,
897 X_Msg_Count OUT NOCOPY NUMBER,
898 X_Msg_Data OUT NOCOPY VARCHAR2
899 );
900
901 -- Start of Comments
902 --
903 -- Item level validation procedures
904 --
905 -- p_validation_mode is a constant defined in package
906 -- For create: G_CREATE, for update: G_UPDATE
907 -- Note: 1. This is automated generated item level validation procedure.
908 -- The actual validation detail is needed to be added.
909 --
910 -- End of Comments
911
912 PROCEDURE Validate_PARAMD1 (
913 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
914 P_Validation_mode IN VARCHAR2,
915 P_PARAMD1 IN DATE,
916 -- 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.
917 X_Return_Status OUT NOCOPY VARCHAR2,
918 X_Msg_Count OUT NOCOPY NUMBER,
919 X_Msg_Data OUT NOCOPY VARCHAR2
920 );
921
922 -- Start of Comments
923 --
924 -- Item level validation procedures
925 --
926 -- p_validation_mode is a constant defined in package
930 --
927 -- For create: G_CREATE, for update: G_UPDATE
928 -- Note: 1. This is automated generated item level validation procedure.
929 -- The actual validation detail is needed to be added.
931 -- End of Comments
932
933 PROCEDURE Validate_PARAMD2 (
934 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
935 P_Validation_mode IN VARCHAR2,
936 P_PARAMD2 IN DATE,
937 -- 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.
938 X_Return_Status OUT NOCOPY VARCHAR2,
939 X_Msg_Count OUT NOCOPY NUMBER,
940 X_Msg_Data OUT NOCOPY VARCHAR2
941 );
942
943 -- Start of Comments
944 --
945 -- Item level validation procedures
946 --
947 -- p_validation_mode is a constant defined in package
948 -- For create: G_CREATE, for update: G_UPDATE
949 -- Note: 1. This is automated generated item level validation procedure.
950 -- The actual validation detail is needed to be added.
951 --
952 -- End of Comments
953
954 PROCEDURE Validate_PARAMD3 (
955 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
956 P_Validation_mode IN VARCHAR2,
957 P_PARAMD3 IN DATE,
958 -- 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.
959 X_Return_Status OUT NOCOPY VARCHAR2,
960 X_Msg_Count OUT NOCOPY NUMBER,
961 X_Msg_Data OUT NOCOPY VARCHAR2
962 );
963
964 -- Start of Comments
965 --
966 -- Item level validation procedures
967 --
968 -- p_validation_mode is a constant defined in package
969 -- For create: G_CREATE, for update: G_UPDATE
970 -- Note: 1. This is automated generated item level validation procedure.
971 -- The actual validation detail is needed to be added.
972 --
973 -- End of Comments
974
975 PROCEDURE Validate_PARAMD4 (
976 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
977 P_Validation_mode IN VARCHAR2,
978 P_PARAMD4 IN DATE,
979 -- 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.
980 X_Return_Status OUT NOCOPY VARCHAR2,
981 X_Msg_Count OUT NOCOPY NUMBER,
982 X_Msg_Data OUT NOCOPY VARCHAR2
983 );
984
985 -- Start of Comments
986 --
987 -- Item level validation procedures
988 --
989 -- p_validation_mode is a constant defined in package
990 -- For create: G_CREATE, for update: G_UPDATE
991 -- Note: 1. This is automated generated item level validation procedure.
992 -- The actual validation detail is needed to be added.
993 --
994 -- End of Comments
995
996 PROCEDURE Validate_PARAMD5 (
997 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
998 P_Validation_mode IN VARCHAR2,
999 P_PARAMD5 IN DATE,
1000 -- 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.
1001 X_Return_Status OUT NOCOPY VARCHAR2,
1002 X_Msg_Count OUT NOCOPY NUMBER,
1003 X_Msg_Data OUT NOCOPY VARCHAR2
1004 );
1005
1006 -- Start of Comments
1007 --
1008 -- Item level validation procedures
1009 --
1010 -- p_validation_mode is a constant defined in package
1011 -- For create: G_CREATE, for update: G_UPDATE
1012 -- Note: 1. This is automated generated item level validation procedure.
1013 -- The actual validation detail is needed to be added.
1014 --
1015 -- End of Comments
1016
1017 PROCEDURE Validate_PARAMD6 (
1018 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1019 P_Validation_mode IN VARCHAR2,
1020 P_PARAMD6 IN DATE,
1021 -- 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.
1022 X_Return_Status OUT NOCOPY VARCHAR2,
1023 X_Msg_Count OUT NOCOPY NUMBER,
1024 X_Msg_Data OUT NOCOPY VARCHAR2
1025 );
1026
1027 -- Start of Comments
1028 --
1029 -- Item level validation procedures
1030 --
1031 -- p_validation_mode is a constant defined in package
1032 -- For create: G_CREATE, for update: G_UPDATE
1033 -- Note: 1. This is automated generated item level validation procedure.
1034 -- The actual validation detail is needed to be added.
1035 --
1036 -- End of Comments
1037
1038 PROCEDURE Validate_PARAMD7 (
1039 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1040 P_Validation_mode IN VARCHAR2,
1041 P_PARAMD7 IN DATE,
1042 -- 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.
1043 X_Return_Status OUT NOCOPY VARCHAR2,
1044 X_Msg_Count OUT NOCOPY NUMBER,
1045 X_Msg_Data OUT NOCOPY VARCHAR2
1046 );
1047
1048 -- Start of Comments
1049 --
1050 -- Item level validation procedures
1054 -- Note: 1. This is automated generated item level validation procedure.
1051 --
1052 -- p_validation_mode is a constant defined in package
1053 -- For create: G_CREATE, for update: G_UPDATE
1055 -- The actual validation detail is needed to be added.
1056 --
1057 -- End of Comments
1058
1059 PROCEDURE Validate_PARAMD8 (
1060 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1061 P_Validation_mode IN VARCHAR2,
1062 P_PARAMD8 IN DATE,
1063 -- 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.
1064 X_Return_Status OUT NOCOPY VARCHAR2,
1065 X_Msg_Count OUT NOCOPY NUMBER,
1066 X_Msg_Data OUT NOCOPY VARCHAR2
1067 );
1068
1069 -- Start of Comments
1070 --
1071 -- Item level validation procedures
1072 --
1073 -- p_validation_mode is a constant defined in package
1074 -- For create: G_CREATE, for update: G_UPDATE
1075 -- Note: 1. This is automated generated item level validation procedure.
1076 -- The actual validation detail is needed to be added.
1077 --
1078 -- End of Comments
1079
1080 PROCEDURE Validate_PARAMD9 (
1081 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1082 P_Validation_mode IN VARCHAR2,
1083 P_PARAMD9 IN DATE,
1084 -- 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.
1085 X_Return_Status OUT NOCOPY VARCHAR2,
1086 X_Msg_Count OUT NOCOPY NUMBER,
1087 X_Msg_Data OUT NOCOPY VARCHAR2
1088 );
1089
1090 -- Start of Comments
1091 --
1092 -- Item level validation procedures
1093 --
1094 -- p_validation_mode is a constant defined in package
1095 -- For create: G_CREATE, for update: G_UPDATE
1096 -- Note: 1. This is automated generated item level validation procedure.
1097 -- The actual validation detail is needed to be added.
1098 --
1099 -- End of Comments
1100
1101 PROCEDURE Validate_PARAMD10 (
1102 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1103 P_Validation_mode IN VARCHAR2,
1104 P_PARAMD10 IN DATE,
1105 -- 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.
1106 X_Return_Status OUT NOCOPY VARCHAR2,
1107 X_Msg_Count OUT NOCOPY NUMBER,
1108 X_Msg_Data OUT NOCOPY VARCHAR2
1109 );
1110
1111 -- Start of Comments
1112 --
1113 -- Record level validation procedures
1114 --
1115 -- p_validation_mode is a constant defined in package
1116 -- For create: G_CREATE, for update: G_UPDATE
1117 -- Note: 1. This is automated generated item level validation procedure.
1118 -- The actual validation detail is needed to be added.
1119 -- 2. Developer can manually added inter-field level validation.
1120 -- End of Comments
1121
1122 -- travi OBJECT_VERSION_NUMBER validation
1123 PROCEDURE Validate_OBJECT_VERSION_NUMBER (
1124 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1125 P_Validation_mode IN VARCHAR2,
1126 P_OBJECT_VERSION_NUMBER IN NUMBER,
1127 P_REPAIR_HISTORY_ID IN NUMBER,
1128 X_Return_Status OUT NOCOPY VARCHAR2,
1129 X_Msg_Count OUT NOCOPY NUMBER,
1130 X_Msg_Data OUT NOCOPY VARCHAR2
1131 );
1132
1133 PROCEDURE Validate_REPH_rec(
1134 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1135 P_Validation_mode IN VARCHAR2,
1136 P_REPH_Rec IN REPH_Rec_Type,
1137 X_Return_Status OUT NOCOPY VARCHAR2,
1138 X_Msg_Count OUT NOCOPY NUMBER,
1139 X_Msg_Data OUT NOCOPY VARCHAR2
1140 );
1141
1142 -- Start of Comments
1143 --
1144 -- validation procedures
1145 --
1146 -- p_validation_mode is a constant defined in package
1147 -- For create: G_CREATE, for update: G_UPDATE
1148 -- Note: 1. This is automated generated item level validation procedure.
1149 -- The actual validation detail is needed to be added.
1150 -- 2. We can also validate table instead of record. There will be an option for user to choose.
1151 -- End of Comments
1152
1153 PROCEDURE Validate_repair_history(
1154 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1155 P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1156 P_Validation_mode IN VARCHAR2,
1157 P_REPH_Rec IN REPH_Rec_Type,
1158 X_Return_Status OUT NOCOPY VARCHAR2,
1159 X_Msg_Count OUT NOCOPY NUMBER,
1160 X_Msg_Data OUT NOCOPY VARCHAR2
1161 );
1162
1163 /*
1164 This function will start with a basic sql query that will get the details of
1165 a repair history row, and then construct the appropriate text using fnd_messages,
1166 the repair history event code, and the parameters stored in the repair history table.
1167 */
1168 FUNCTION GET_HISTORY_DETAIL(p_repair_history_id IN NUMBER)
1169 RETURN VARCHAR2;
1170
1171
1172
1173 End CSD_REPAIR_HISTORY_PVT;
1174