1 PACKAGE CSP_TASK_PART_PVT AUTHID CURRENT_USER as
2 /* $Header: cspvtaps.pls 115.3 2003/05/02 16:36:44 hhaugeru noship $ */
3 -- Start of Comments
4 -- Package name : CSP_TASK_PART_PVT
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9 -- Default number of records fetch per call
10 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
11 -- *******************************************************
12 -- Start of Comments
13 -- -------------------------------------------------------
14 -- Record name:TASK_PART_Rec_Type
15 -- -------------------------------------------------------
16 -- Parameters:
17 -- TASK_PART_ID
18 -- PRODUCT_TASK_ID
19 -- INVENTORY_ITEM_ID
20 -- MANUAL_QUANTITY
21 -- MANUAL_PERCENTAGE
22 -- QUANTITY_USED
23 -- ACTUAL_TIMES_USED
24 -- CALCULATED_QUANTITY
25 -- PART_PERCENTAGE
26 -- CREATED_BY
27 -- CREATION_DATE
28 -- LAST_UPDATED_BY
29 -- LAST_UPDATE_DATE
30 -- LAST_UPDATE_LOGIN
31 -- ATTRIBUTE_CATEGORY
32 -- ATTRIBUTE1
33 -- ATTRIBUTE2
34 -- ATTRIBUTE3
35 -- ATTRIBUTE4
36 -- ATTRIBUTE5
37 -- ATTRIBUTE6
38 -- ATTRIBUTE7
39 -- ATTRIBUTE8
40 -- ATTRIBUTE9
41 -- ATTRIBUTE10
42 -- ATTRIBUTE11
43 -- ATTRIBUTE12
44 -- ATTRIBUTE13
45 -- ATTRIBUTE14
46 -- ATTRIBUTE15
47 -- PRIMARY_UOM_CODE
48 -- REVISION
49 -- START_DATE
50 -- END_DATE
51 --
52 -- Required:
53 -- Defaults:
54 -- Note: This is automatic generated record definition, it includes all columns
55 -- defined in the table, developer must manually add or delete some of the attributes.
56 --
57 -- End of Comments
58 TYPE TASK_PART_Rec_Type IS RECORD
59 (
60 TASK_PART_ID NUMBER := FND_API.G_MISS_NUM,
61 PRODUCT_TASK_ID NUMBER := FND_API.G_MISS_NUM,
62 INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
63 MANUAL_QUANTITY NUMBER := FND_API.G_MISS_NUM,
64 MANUAL_PERCENTAGE NUMBER := FND_API.G_MISS_NUM,
65 QUANTITY_USED NUMBER := FND_API.G_MISS_NUM,
66 ACTUAL_TIMES_USED NUMBER := FND_API.G_MISS_NUM,
67 CREATED_BY NUMBER := FND_API.G_MISS_NUM,
68 CREATION_DATE DATE := FND_API.G_MISS_DATE,
69 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
70 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
71 LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
72 ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
73 ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74 ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75 ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76 ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77 ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78 ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79 ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80 ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81 ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82 ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83 ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84 ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85 ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86 ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87 ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88 PRIMARY_UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
89 REVISION VARCHAR2(30) := FND_API.G_MISS_CHAR,
90 START_DATE DATE := FND_API.G_MISS_DATE,
91 END_DATE DATE := FND_API.G_MISS_DATE,
92 ROLLUP_QUANTITY_USED NUMBER := FND_API.G_MISS_NUM,
93 ROLLUP_TIMES_USED NUMBER := FND_API.G_MISS_NUM,
94 SUBSTITUTE_ITEM NUMBER := FND_API.G_MISS_NUM
95 );
96 G_MISS_TASK_PART_REC TASK_PART_Rec_Type;
97 TYPE TASK_PART_Tbl_Type IS TABLE OF TASK_PART_Rec_Type
98 INDEX BY BINARY_INTEGER;
99 G_MISS_TASK_PART_TBL TASK_PART_Tbl_Type;
100 -- *******************************************************
101 -- Start of Comments
102 -- *******************************************************
103 -- API Name: Create_task_part
104 -- Type : Private
105 -- Pre-Req :
106 -- Parameters:
107 -- IN
108 -- p_api_version_number IN NUMBER Required
109 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
110 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
111 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
112 -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
113 -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
114 -- p_admin_group_id IN NUMBER Required
115 -- P_TASK_PART_Rec IN TASK_PART_Rec_Type Required
116 -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required
117 --
118 -- OUT:
119 -- x_return_status OUT NOCOPY VARCHAR2
120 -- x_msg_count OUT NOCOPY NUMBER
121 -- x_msg_data OUT NOCOPY VARCHAR2
122 -- Version : Current version 2.0
123 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
124 -- and basic operation, developer must manually add parameters and business logic as necessary.
125 --
126 -- End of Comments
127 --
128 PROCEDURE Create_task_part(
129 P_Api_Version_Number IN NUMBER,
130 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
131 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
132 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
133 P_TASK_PART_Rec IN TASK_PART_Rec_Type := G_MISS_TASK_PART_REC,
134 --Hint: Add detail tables as parameter lists if it's master-detail relationship.
135 X_TASK_PART_ID OUT NOCOPY NUMBER,
136 X_Return_Status OUT NOCOPY VARCHAR2,
137 X_Msg_Count OUT NOCOPY NUMBER,
138 X_Msg_Data OUT NOCOPY VARCHAR2
139 );
140 -- *******************************************************
141 -- Start of Comments
142 -- *******************************************************
143 -- API Name: Update_task_part
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_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
153 -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
154 -- p_admin_group_id IN NUMBER Required
155 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
156 -- P_TASK_PART_Rec IN TASK_PART_Rec_Type Required
157 -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required
158 --
159 -- OUT:
160 -- x_return_status OUT NOCOPY VARCHAR2
161 -- x_msg_count OUT NOCOPY NUMBER
162 -- x_msg_data OUT NOCOPY VARCHAR2
163 -- Version : Current version 2.0
164 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
165 -- and basic operation, developer must manually add parameters and business logic as necessary.
166 --
167 -- End of Comments
168 --
169 -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
170 PROCEDURE Update_task_part(
171 P_Api_Version_Number IN NUMBER,
172 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
173 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
174 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
175 P_TASK_PART_Rec IN TASK_PART_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 -- Start of Comments
182 -- *******************************************************
183 -- API Name: Delete_task_part
184 -- Type : Private
185 -- Pre-Req :
186 -- Parameters:
187 -- IN
188 -- p_api_version_number IN NUMBER Required
189 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
190 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
191 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
192 -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
193 -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
194 -- p_admin_group_id IN NUMBER Required
195 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
196 -- P_TASK_PART_Rec IN TASK_PART_Rec_Type Required
197 -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required
198 --
199 -- OUT:
200 -- x_return_status OUT NOCOPY VARCHAR2
201 -- x_msg_count OUT NOCOPY NUMBER
202 -- x_msg_data OUT NOCOPY VARCHAR2
203 -- Version : Current version 2.0
204 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
205 -- and basic operation, developer must manually add parameters and business logic as necessary.
206 --
207 -- End of Comments
208 --
209 -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
210 -- The Master delete procedure may not be needed depends on different business requirements.
211 PROCEDURE Delete_task_part(
212 P_Api_Version_Number IN NUMBER,
213 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
214 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
215 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
216 P_TASK_PART_Rec IN TASK_PART_Rec_Type,
217 X_Return_Status OUT NOCOPY VARCHAR2,
218 X_Msg_Count OUT NOCOPY NUMBER,
219 X_Msg_Data OUT NOCOPY VARCHAR2
220 );
221 -- Start of Comments
222 --
223 -- Item level validation procedures
224 --
225 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
226 -- For create: G_CREATE, for update: G_UPDATE
227 -- Note: 1. This is automated generated item level validation procedure.
228 -- The actual validation detail is needed to be added.
229 --
230 -- End of Comments
231 PROCEDURE Validate_TASK_PART_ID (
232 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
233 P_Validation_mode IN VARCHAR2,
234 P_TASK_PART_ID IN NUMBER,
235 -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
236 X_Return_Status OUT NOCOPY VARCHAR2,
237 X_Msg_Count OUT NOCOPY NUMBER,
238 X_Msg_Data OUT NOCOPY VARCHAR2
239 );
240 -- Start of Comments
241 --
242 -- Item level validation procedures
243 --
244 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
245 -- For create: G_CREATE, for update: G_UPDATE
246 -- Note: 1. This is automated generated item level validation procedure.
247 -- The actual validation detail is needed to be added.
248 --
249 -- End of Comments
250 PROCEDURE Validate_PRODUCT_TASK_ID (
251 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
252 P_Validation_mode IN VARCHAR2,
253 P_PRODUCT_TASK_ID IN NUMBER,
254 -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.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 -- Start of Comments
260 --
261 -- Item level validation procedures
262 --
263 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
264 -- For create: G_CREATE, for update: G_UPDATE
265 -- Note: 1. This is automated generated item level validation procedure.
266 -- The actual validation detail is needed to be added.
267 --
268 -- End of Comments
269 PROCEDURE Validate_INVENTORY_ITEM_ID (
270 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
271 P_Validation_mode IN VARCHAR2,
272 P_INVENTORY_ITEM_ID IN NUMBER,
273 -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
274 X_Return_Status OUT NOCOPY VARCHAR2,
275 X_Msg_Count OUT NOCOPY NUMBER,
276 X_Msg_Data OUT NOCOPY VARCHAR2
277 );
278 -- Start of Comments
279 --
280 -- Item level validation procedures
281 --
282 -- p_validation_mode is a constant defined in AS_UTILITY_PVT 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 PROCEDURE Validate_MANUAL_QUANTITY (
289 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
290 P_Validation_mode IN VARCHAR2,
291 P_MANUAL_QUANTITY IN NUMBER,
292 -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
293 X_Return_Status OUT NOCOPY VARCHAR2,
294 X_Msg_Count OUT NOCOPY NUMBER,
295 X_Msg_Data OUT NOCOPY VARCHAR2
296 );
297 -- Start of Comments
298 --
299 -- Item level validation procedures
300 --
301 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
302 -- For create: G_CREATE, for update: G_UPDATE
303 -- Note: 1. This is automated generated item level validation procedure.
304 -- The actual validation detail is needed to be added.
305 --
306 -- End of Comments
307 PROCEDURE Validate_MANUAL_PERCENTAGE (
308 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
309 P_Validation_mode IN VARCHAR2,
310 P_MANUAL_PERCENTAGE IN NUMBER,
311 -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
312 X_Return_Status OUT NOCOPY VARCHAR2,
313 X_Msg_Count OUT NOCOPY NUMBER,
314 X_Msg_Data OUT NOCOPY VARCHAR2
315 );
316 -- Start of Comments
317 --
318 -- Item level validation procedures
319 --
320 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
321 -- For create: G_CREATE, for update: G_UPDATE
322 -- Note: 1. This is automated generated item level validation procedure.
323 -- The actual validation detail is needed to be added.
324 --
325 -- End of Comments
326 PROCEDURE Validate_QUANTITY_USED (
327 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
328 P_Validation_mode IN VARCHAR2,
329 P_QUANTITY_USED IN NUMBER,
333 X_Msg_Data OUT NOCOPY VARCHAR2
330 -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.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,
334 );
335 -- Start of Comments
336 --
337 -- Item level validation procedures
338 --
339 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
340 -- For create: G_CREATE, for update: G_UPDATE
341 -- Note: 1. This is automated generated item level validation procedure.
342 -- The actual validation detail is needed to be added.
343 --
344 -- End of Comments
345 PROCEDURE Validate_ACTUAL_TIMES_USED (
346 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
347 P_Validation_mode IN VARCHAR2,
348 P_ACTUAL_TIMES_USED IN NUMBER,
349 -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
350 X_Return_Status OUT NOCOPY VARCHAR2,
351 X_Msg_Count OUT NOCOPY NUMBER,
352 X_Msg_Data OUT NOCOPY VARCHAR2
353 );
354 -- Start of Comments
355 --
356 -- Item level validation procedures
357 --
358 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
359 -- For create: G_CREATE, for update: G_UPDATE
360 -- Note: 1. This is automated generated item level validation procedure.
361 -- The actual validation detail is needed to be added.
362 --
363 -- End of Comments
364
365 PROCEDURE Validate_PRIMARY_UOM_CODE (
366 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
367 P_Validation_mode IN VARCHAR2,
368 P_PRIMARY_UOM_CODE IN VARCHAR2,
369 -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
370 X_Return_Status OUT NOCOPY VARCHAR2,
371 X_Msg_Count OUT NOCOPY NUMBER,
372 X_Msg_Data OUT NOCOPY VARCHAR2
373 );
374 -- Start of Comments
375 --
376 -- Item level validation procedures
377 --
378 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
379 -- For create: G_CREATE, for update: G_UPDATE
380 -- Note: 1. This is automated generated item level validation procedure.
381 -- The actual validation detail is needed to be added.
382 --
383 -- End of Comments
384 PROCEDURE Validate_REVISION (
385 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
386 P_Validation_mode IN VARCHAR2,
387 P_REVISION IN VARCHAR2,
388 -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
389 X_Return_Status OUT NOCOPY VARCHAR2,
390 X_Msg_Count OUT NOCOPY NUMBER,
391 X_Msg_Data OUT NOCOPY VARCHAR2
392 );
393 -- Start of Comments
394 --
395 -- Item level validation procedures
396 --
397 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
398 -- For create: G_CREATE, for update: G_UPDATE
399 -- Note: 1. This is automated generated item level validation procedure.
400 -- The actual validation detail is needed to be added.
401 --
402 -- End of Comments
403 PROCEDURE Validate_START_DATE (
404 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
405 P_Validation_mode IN VARCHAR2,
406 P_START_DATE IN DATE,
407 -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
408 X_Return_Status OUT NOCOPY VARCHAR2,
409 X_Msg_Count OUT NOCOPY NUMBER,
410 X_Msg_Data OUT NOCOPY VARCHAR2
411 );
412 -- Start of Comments
413 --
414 -- Item level validation procedures
415 --
416 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
417 -- For create: G_CREATE, for update: G_UPDATE
418 -- Note: 1. This is automated generated item level validation procedure.
419 -- The actual validation detail is needed to be added.
420 --
421 -- End of Comments
422 PROCEDURE Validate_END_DATE (
423 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
424 P_Validation_mode IN VARCHAR2,
425 P_END_DATE IN DATE,
426 -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
427 X_Return_Status OUT NOCOPY VARCHAR2,
428 X_Msg_Count OUT NOCOPY NUMBER,
429 X_Msg_Data OUT NOCOPY VARCHAR2
430 );
431
432 PROCEDURE Validate_ROLLUP_QUANTITY_USED (
433 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
434 P_Validation_mode IN VARCHAR2,
435 P_ROLLUP_QUANTITY_USED IN NUMBER,
436 -- 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.
437 X_Return_Status OUT NOCOPY VARCHAR2,
438 X_Msg_Count OUT NOCOPY NUMBER,
439 X_Msg_Data OUT NOCOPY VARCHAR2
443 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
440 );
441
442 PROCEDURE Validate_ROLLUP_TIMES_USED (
444 P_Validation_mode IN VARCHAR2,
445 P_ROLLUP_TIMES_USED IN NUMBER,
446 -- 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.
447 X_Return_Status OUT NOCOPY VARCHAR2,
448 X_Msg_Count OUT NOCOPY NUMBER,
449 X_Msg_Data OUT NOCOPY VARCHAR2
450 );
451
452 PROCEDURE Validate_SUBSTITUTE_ITEM (
453 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
454 P_Validation_mode IN VARCHAR2,
455 P_SUBSTITUTE_ITEM IN NUMBER,
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 -- Record level validation procedures
465 --
466 -- p_validation_mode is a constant defined in AS_UTILITY_PVT 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 -- 2. Developer can manually added inter-field level validation.
471 -- End of Comments
472 PROCEDURE Validate_TASK_PART_rec(
473 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
474 P_Validation_mode IN VARCHAR2,
475 P_TASK_PART_Rec IN TASK_PART_Rec_Type,
476 X_Return_Status OUT NOCOPY VARCHAR2,
477 X_Msg_Count OUT NOCOPY NUMBER,
478 X_Msg_Data OUT NOCOPY VARCHAR2
479 );
480 -- Start of Comments
481 --
482 -- validation procedures
483 --
484 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
485 -- For create: G_CREATE, for update: G_UPDATE
486 -- Note: 1. This is automated generated item level validation procedure.
487 -- The actual validation detail is needed to be added.
488 -- 2. We can also validate table instead of record. There will be an option for user to choose.
489 -- End of Comments
490 PROCEDURE Validate_task_part(
491 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
492 P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
493 P_Validation_mode IN VARCHAR2,
494 P_TASK_PART_Rec IN TASK_PART_Rec_Type,
495 X_Return_Status OUT NOCOPY VARCHAR2,
496 X_Msg_Count OUT NOCOPY NUMBER,
497 X_Msg_Data OUT NOCOPY VARCHAR2
498 );
499 End CSP_TASK_PART_PVT;