1 PACKAGE CSC_PLAN_LINES_PVT as
2 /* $Header: cscvplns.pls 120.0 2005/05/30 15:44:36 appldev noship $ */
3 -- Start of Comments
4 -- Package name : CSC_PLAN_LINES_PVT
5 -- Purpose : Private package to perform inserts, updates and delete operations
6 -- on CSC_PLAN_LINES table. It contains procedures to perform item
7 -- level validations if validation level is set to 100 (FULL).
8 -- History :
9 -- MM-DD-YYYY NAME MODIFICATIONS
10 -- 10-21-1999 dejoseph Created.
11 -- 12-08-1999 dejoseph 'Arcs'ed in for first code freeze.
12 -- 12-21-1999 dejoseph 'Arcs'ed in for second code freeze.
13 -- 01-03-2000 dejoseph 'Arcs'ed in for third code freeze. (10-JAN-2000)
14 -- 01-31-2000 dejoseph 'Arcs'ed in for fourth code freeze. (07-FEB-2000)
15 -- 02-13-2000 dejoseph 'Arcs'ed on for fifth code freeze. (21-FEB-2000)
16 -- 02-28-2000 dejoseph 'Arcs'ed on for sixth code freeze. (06-MAR-2000)
17 -- 11-11-2002 bhroy NOCOPY changes made
18 -- 11-25-2002 bhroy FND_API defaults removed, added WHENEVER OSERROR EXIT FAILURE ROLLBACK;
19
20 -- NOTE :
21 -- End of Comments
22
23 -- Default number of records fetch per call
24 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
25
26 TYPE CSC_PLAN_LINES_Rec_Type IS RECORD
27 (
28 LINE_ID NUMBER,
29 PLAN_ID NUMBER,
30 CONDITION_ID NUMBER,
31 CREATION_DATE DATE,
32 LAST_UPDATE_DATE DATE,
33 CREATED_BY NUMBER,
34 LAST_UPDATED_BY NUMBER,
35 LAST_UPDATE_LOGIN NUMBER,
36 ATTRIBUTE1 VARCHAR2(450),
37 ATTRIBUTE2 VARCHAR2(450),
38 ATTRIBUTE3 VARCHAR2(450),
39 ATTRIBUTE4 VARCHAR2(450),
40 ATTRIBUTE5 VARCHAR2(450),
41 ATTRIBUTE6 VARCHAR2(450),
42 ATTRIBUTE7 VARCHAR2(450),
43 ATTRIBUTE8 VARCHAR2(450),
44 ATTRIBUTE9 VARCHAR2(450),
45 ATTRIBUTE10 VARCHAR2(450),
46 ATTRIBUTE11 VARCHAR2(450),
47 ATTRIBUTE12 VARCHAR2(450),
48 ATTRIBUTE13 VARCHAR2(450),
49 ATTRIBUTE14 VARCHAR2(450),
50 ATTRIBUTE15 VARCHAR2(450),
51 ATTRIBUTE_CATEGORY VARCHAR2(90),
52 OBJECT_VERSION_NUMBER NUMBER
53 );
54
55 G_MISS_CSC_PLAN_LINES_REC CSC_PLAN_LINES_Rec_Type;
56 TYPE CSC_PLAN_LINES_Tbl_Type IS TABLE OF CSC_PLAN_LINES_Rec_Type
57 INDEX BY BINARY_INTEGER;
58 G_MISS_CSC_PLAN_LINES_TBL CSC_PLAN_LINES_Tbl_Type;
59
60 -- *******************************************************
61 -- Start of Comments
62 -- *******************************************************
63 -- API Name: Create_plan_lines
64 -- Type : Private
65 -- Pre-Req : None.
66 -- Parameters:
67 -- IN
68 -- p_api_version_number IN NUMBER Required
69 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
70 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
71 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
72 -- P_CSC_PLAN_LINES_Rec IN CSC_PLAN_LINES_Rec_Type Required
73 --
74 -- OUT NOCOPY:
75 -- x_line_id OUT NOCOPY NUMBER
76 -- x_object_version_number OUT NOCOPY NUMBER
77 -- x_return_status OUT NOCOPY VARCHAR2
78 -- x_msg_count OUT NOCOPY NUMBER
79 -- x_msg_data OUT NOCOPY VARCHAR2
80 -- Version : Current version 1.0
81 --
82 -- End of Comments
83 --
84 PROCEDURE Create_plan_lines(
85 P_Api_Version_Number IN NUMBER,
86 P_Init_Msg_List IN VARCHAR2,
87 P_Commit IN VARCHAR2,
88 p_validation_level IN NUMBER ,
89 P_CSC_PLAN_LINES_Rec IN CSC_PLAN_LINES_Rec_Type,
90 X_LINE_ID OUT NOCOPY NUMBER,
91 X_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER,
92 X_Return_Status OUT NOCOPY VARCHAR2,
93 X_Msg_Count OUT NOCOPY NUMBER,
94 X_Msg_Data OUT NOCOPY VARCHAR2
95 );
96
97 -- *******************************************************
98 -- Start of Comments
99 -- *******************************************************
100 -- API Name: Create_plan_lines (procedure overloaded to accept a detailed parameter
101 -- list )
102 -- Type : Public
103 -- Pre-Req : None.
104 -- Function: Inserts records into csc_plan_lines for a given plan_id.
105 -- Parameters:
106 -- IN
107 -- p_api_version_number IN NUMBER Required
108 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
109 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
110 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
111 -- P_LINE_ID IN NUMBER Optional Default = FND_API.G_MISS_NUM
112 -- P_PLAN_ID IN NUMBER Required
113 -- P_CONDITION_ID IN NUMBER Required
114 -- P_CREATION_DATE IN DATE Required
115 -- P_LAST_UPDATE_DATE IN DATE Required
116 -- P_CREATED_BY IN NUMBER Required
117 -- P_LAST_UPDATED_BY IN NUMBER Required
118 -- P_LAST_UPDATE_LOGIN IN NUMBER Required
119 -- P_ATTRIBUTE1 IN VARCHAR2(450) Optional Default := FND_API.G_MISS_CHAR,
120 -- P_ATTRIBUTE2 IN VARCHAR2(450) Optional Default := FND_API.G_MISS_CHAR,
121 -- P_ATTRIBUTE3 IN VARCHAR2(450) Optional Default := FND_API.G_MISS_CHAR,
122 -- P_ATTRIBUTE4 IN VARCHAR2(450) Optional Default := FND_API.G_MISS_CHAR,
123 -- P_ATTRIBUTE5 IN VARCHAR2(450) Optional Default := FND_API.G_MISS_CHAR,
124 -- P_ATTRIBUTE6 IN VARCHAR2(450) Optional Default := FND_API.G_MISS_CHAR,
125 -- P_ATTRIBUTE7 IN VARCHAR2(450) Optional Default := FND_API.G_MISS_CHAR,
126 -- P_ATTRIBUTE8 IN VARCHAR2(450) Optional Default := FND_API.G_MISS_CHAR,
127 -- P_ATTRIBUTE9 IN VARCHAR2(450) Optional Default := FND_API.G_MISS_CHAR,
128 -- P_ATTRIBUTE10 IN VARCHAR2(450) Optional Default := FND_API.G_MISS_CHAR,
129 -- P_ATTRIBUTE11 IN VARCHAR2(450) Optional Default := FND_API.G_MISS_CHAR,
130 -- P_ATTRIBUTE12 IN VARCHAR2(450) Optional Default := FND_API.G_MISS_CHAR,
131 -- P_ATTRIBUTE13 IN VARCHAR2(450) Optional Default := FND_API.G_MISS_CHAR,
132 -- P_ATTRIBUTE14 IN VARCHAR2(450) Optional Default := FND_API.G_MISS_CHAR,
133 -- P_ATTRIBUTE15 IN VARCHAR2(450) Optional Default := FND_API.G_MISS_CHAR,
134 -- P_ATTRIBUTE_CATEGORY IN VARCHAR2(90) Optional Default := FND_API.G_MISS_CHAR,
135 -- P_OBJECT_VERSION_NUMBER IN NUMBER Required
136 --
137 -- OUT NOCOPY:
138 -- x_plan_id OUT NOCOPY NUMBER
139 -- x_object_version_number OUT NOCOPY NUMBER
140 -- x_return_status OUT NOCOPY VARCHAR2
141 -- x_msg_count OUT NOCOPY NUMBER
142 -- x_msg_data OUT NOCOPY VARCHAR2
143 -- Version : Current version 1.0
144 -- End of Comments
145 --
146 PROCEDURE Create_plan_lines(
147 P_Api_Version_Number IN NUMBER,
148 P_Init_Msg_List IN VARCHAR2,
149 P_Commit IN VARCHAR2,
150 P_Validation_Level IN NUMBER ,
151 P_LINE_ID IN NUMBER,
152 P_PLAN_ID IN NUMBER,
153 P_CONDITION_ID IN NUMBER,
154 P_CREATION_DATE IN DATE ,
155 P_LAST_UPDATE_DATE IN DATE,
156 P_CREATED_BY IN NUMBER,
157 P_LAST_UPDATED_BY IN NUMBER,
158 P_LAST_UPDATE_LOGIN IN NUMBER,
159 P_ATTRIBUTE1 IN VARCHAR2,
160 P_ATTRIBUTE2 IN VARCHAR2,
161 P_ATTRIBUTE3 IN VARCHAR2,
162 P_ATTRIBUTE4 IN VARCHAR2,
163 P_ATTRIBUTE5 IN VARCHAR2,
164 P_ATTRIBUTE6 IN VARCHAR2,
165 P_ATTRIBUTE7 IN VARCHAR2,
166 P_ATTRIBUTE8 IN VARCHAR2,
167 P_ATTRIBUTE9 IN VARCHAR2,
168 P_ATTRIBUTE10 IN VARCHAR2,
169 P_ATTRIBUTE11 IN VARCHAR2,
170 P_ATTRIBUTE12 IN VARCHAR2,
171 P_ATTRIBUTE13 IN VARCHAR2,
172 P_ATTRIBUTE14 IN VARCHAR2,
173 P_ATTRIBUTE15 IN VARCHAR2,
174 P_ATTRIBUTE_CATEGORY IN VARCHAR2,
175 P_OBJECT_VERSION_NUMBER IN NUMBER,
176 X_LINE_ID OUT NOCOPY NUMBER,
177 X_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER,
178 X_Return_Status OUT NOCOPY VARCHAR2,
179 X_Msg_Count OUT NOCOPY NUMBER,
180 X_Msg_Data OUT NOCOPY VARCHAR2
181 );
182
183 -- *******************************************************
184 -- Start of Comments
185 -- *******************************************************
186 -- API Name: Update_plan_lines
187 -- Type : Private
188 -- Pre-Req :
189 -- Parameters:
190 -- IN
191 -- p_api_version_number IN NUMBER Required
192 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
193 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
194 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
195 -- P_CSC_PLAN_LINES_Rec IN CSC_PLAN_LINES_Rec_Type Required
196 --
197 -- OUT NOCOPY:
198 -- x_object_version_number 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 -- Version : Current version 1.0
203 -- Note: This automatic generated procedure definition, it includes standard IN/OUT NOCOPY parameters
204 -- and basic operation, developer must manually add parameters and business logic as necessary.
205 --
206 -- End of Comments
207 --
208 PROCEDURE Update_plan_lines(
209 P_Api_Version_Number IN NUMBER,
210 P_Init_Msg_List IN VARCHAR2,
211 P_Commit IN VARCHAR2,
212 p_validation_level IN NUMBER,
213 P_CSC_PLAN_LINES_Rec IN CSC_PLAN_LINES_Rec_Type,
214 X_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER,
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 -- Start of Comments
222 -- *******************************************************
223 -- API Name: Update_plan_lines (procedure overloaded to accept a detailed parameter
224 -- list )
225 -- Type : Public
226 -- Pre-Req :
227 -- Parameters:
228 -- IN
229 -- p_api_version_number IN NUMBER Required
230 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
231 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
232 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
233 -- P_LINE_ID IN NUMBER Optional Default = FND_API.G_MISS_NUM
234 -- P_PLAN_ID IN NUMBER Required
235 -- P_CONDITION_ID IN NUMBER Required
236 -- P_CREATION_DATE IN DATE Required
237 -- P_LAST_UPDATE_DATE IN DATE Required
238 -- P_CREATED_BY IN NUMBER Required
239 -- P_LAST_UPDATED_BY IN NUMBER Required
240 -- P_LAST_UPDATE_LOGIN IN NUMBER Required
241 -- P_ATTRIBUTE1 IN VARCHAR2(450) Optional Default := FND_API.G_MISS_CHAR,
242 -- P_ATTRIBUTE2 IN VARCHAR2(450) Optional Default := FND_API.G_MISS_CHAR,
243 -- P_ATTRIBUTE3 IN VARCHAR2(450) Optional Default := FND_API.G_MISS_CHAR,
244 -- P_ATTRIBUTE4 IN VARCHAR2(450) Optional Default := FND_API.G_MISS_CHAR,
245 -- P_ATTRIBUTE5 IN VARCHAR2(450) Optional Default := FND_API.G_MISS_CHAR,
246 -- P_ATTRIBUTE6 IN VARCHAR2(450) Optional Default := FND_API.G_MISS_CHAR,
247 -- P_ATTRIBUTE7 IN VARCHAR2(450) Optional Default := FND_API.G_MISS_CHAR,
248 -- P_ATTRIBUTE8 IN VARCHAR2(450) Optional Default := FND_API.G_MISS_CHAR,
249 -- P_ATTRIBUTE9 IN VARCHAR2(450) Optional Default := FND_API.G_MISS_CHAR,
250 -- P_ATTRIBUTE10 IN VARCHAR2(450) Optional Default := FND_API.G_MISS_CHAR,
251 -- P_ATTRIBUTE11 IN VARCHAR2(450) Optional Default := FND_API.G_MISS_CHAR,
252 -- P_ATTRIBUTE12 IN VARCHAR2(450) Optional Default := FND_API.G_MISS_CHAR,
253 -- P_ATTRIBUTE13 IN VARCHAR2(450) Optional Default := FND_API.G_MISS_CHAR,
254 -- P_ATTRIBUTE14 IN VARCHAR2(450) Optional Default := FND_API.G_MISS_CHAR,
255 -- P_ATTRIBUTE15 IN VARCHAR2(450) Optional Default := FND_API.G_MISS_CHAR,
256 -- P_ATTRIBUTE_CATEGORY IN VARCHAR2(90) Optional Default := FND_API.G_MISS_CHAR,
257 --
258 -- OUT NOCOPY:
259 -- x_object_version_number OUT NOCOPY NUMBER
260 -- x_return_status OUT NOCOPY VARCHAR2
261 -- x_msg_count OUT NOCOPY NUMBER
262 -- x_msg_data OUT NOCOPY VARCHAR2
263 -- Version : Current version 1.0
264 --
265 -- End of Comments
266 --
267 PROCEDURE Update_plan_lines(
268 P_Api_Version_Number IN NUMBER,
269 P_Init_Msg_List IN VARCHAR2,
270 P_Commit IN VARCHAR2,
271 P_Validation_Level IN NUMBER,
272 P_LINE_ID IN NUMBER,
273 P_PLAN_ID IN NUMBER,
274 P_CONDITION_ID IN NUMBER,
275 P_CREATION_DATE IN DATE,
276 P_LAST_UPDATE_DATE IN DATE,
277 P_CREATED_BY IN NUMBER,
278 P_LAST_UPDATED_BY IN NUMBER,
279 P_LAST_UPDATE_LOGIN IN NUMBER,
280 P_ATTRIBUTE1 IN VARCHAR2,
281 P_ATTRIBUTE2 IN VARCHAR2,
282 P_ATTRIBUTE3 IN VARCHAR2,
283 P_ATTRIBUTE4 IN VARCHAR2,
284 P_ATTRIBUTE5 IN VARCHAR2,
285 P_ATTRIBUTE6 IN VARCHAR2,
286 P_ATTRIBUTE7 IN VARCHAR2,
287 P_ATTRIBUTE8 IN VARCHAR2,
288 P_ATTRIBUTE9 IN VARCHAR2,
289 P_ATTRIBUTE10 IN VARCHAR2,
290 P_ATTRIBUTE11 IN VARCHAR2,
291 P_ATTRIBUTE12 IN VARCHAR2,
292 P_ATTRIBUTE13 IN VARCHAR2,
293 P_ATTRIBUTE14 IN VARCHAR2,
294 P_ATTRIBUTE15 IN VARCHAR2,
295 P_ATTRIBUTE_CATEGORY IN VARCHAR2,
296 P_OBJECT_VERSION_NUMBER IN NUMBER,
297 X_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER,
298 X_Return_Status OUT NOCOPY VARCHAR2,
299 X_Msg_Count OUT NOCOPY NUMBER,
300 X_Msg_Data OUT NOCOPY VARCHAR2
301 );
302
303
304 -- *******************************************************
305 -- Start of Comments
306 -- *******************************************************
307 -- API Name: Delete_plan_lines
308 -- Type : Private
309 -- Pre-Req :
310 -- Parameters:
311 -- IN
312 -- p_api_version_number IN NUMBER Required
316 -- P_LINE_ID IN NUMBER Optional Default = FND_API.G_MISS_NUM
313 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
314 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
315 -- P_PLAN_ID IN NUMBER Optional Default = FND_API.G_MISS_NUM
317 --
318 -- OUT NOCOPY:
319 -- x_return_status OUT NOCOPY VARCHAR2
320 -- x_msg_count OUT NOCOPY NUMBER
321 -- x_msg_data OUT NOCOPY VARCHAR2
322 -- Version : Current version 1.0
323 --
324 -- End of Comments
325 --
326 PROCEDURE Delete_plan_lines(
327 P_Api_Version_Number IN NUMBER,
328 P_Init_Msg_List IN VARCHAR2,
329 P_Commit IN VARCHAR2,
330 P_PLAN_ID IN NUMBER,
331 P_LINE_ID IN NUMBER,
332 X_Return_Status OUT NOCOPY VARCHAR2,
333 X_Msg_Count OUT NOCOPY NUMBER,
334 X_Msg_Data OUT NOCOPY VARCHAR2 );
335
336 -- ITEM LEVEL VALIDATION PROCEDURES
337
338 -- *******************************************************
339 -- Start of Comments
340 -- *******************************************************
341 -- API Name: Validate_line_id
342 -- Type : Private
343 -- Pre-Req :
344 -- Parameters:
345 -- IN
346 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
347 -- p_validation_mode IN VARCHAR2 Required
348 -- p_validation_mode is a constant defined in CSC_CORE_UTILS_PVT.
349 -- For create: G_CREATE, for update: G_UPDATE
350 -- P_line_id IN NUMBER Required
351 --
352 -- OUT NOCOPY:
353 -- x_return_status OUT NOCOPY VARCHAR2
354 -- x_msg_count OUT NOCOPY NUMBER
355 -- x_msg_data OUT NOCOPY VARCHAR2
356 -- Version : Current version 1.0
357 -- End of Comments
358 --
359 PROCEDURE Validate_LINE_ID (
360 P_Init_Msg_List IN VARCHAR2,
361 P_Validation_mode IN VARCHAR2,
362 P_LINE_ID IN NUMBER,
363 X_Return_Status OUT NOCOPY VARCHAR2,
364 X_Msg_Count OUT NOCOPY NUMBER,
365 X_Msg_Data OUT NOCOPY VARCHAR2
366 );
367
368 -- *******************************************************
369 -- Start of Comments
370 -- *******************************************************
371 -- API Name: Validate_plan_id
372 -- Type : Private
373 -- Pre-Req :
374 -- Parameters:
375 -- IN
376 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
377 -- p_validation_mode IN VARCHAR2 Required
378 -- p_validation_mode is a constant defined in CSC_CORE_UTILS_PVT.
379 -- For create: G_CREATE, for update: G_UPDATE
380 -- P_plan_id IN NUMBER Required
381 --
382 -- OUT NOCOPY:
383 -- x_return_status OUT NOCOPY VARCHAR2
384 -- x_msg_count OUT NOCOPY NUMBER
385 -- x_msg_data OUT NOCOPY VARCHAR2
386 -- Version : Current version 1.0
387 -- End of Comments
388 --
389 PROCEDURE Validate_PLAN_ID (
390 P_Init_Msg_List IN VARCHAR2,
391 P_Validation_mode IN VARCHAR2,
392 P_PLAN_ID IN NUMBER,
393 X_Return_Status OUT NOCOPY VARCHAR2,
394 X_Msg_Count OUT NOCOPY NUMBER,
395 X_Msg_Data OUT NOCOPY VARCHAR2
396 );
397
398 -- *******************************************************
399 -- Start of Comments
400 -- *******************************************************
401 -- API Name: Validate_condition_id
402 -- Type : Private
403 -- Pre-Req :
404 -- Parameters:
405 -- IN
406 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
407 -- p_validation_mode IN VARCHAR2 Required
408 -- p_validation_mode is a constant defined in CSC_CORE_UTILS_PVT.
409 -- For create: G_CREATE, for update: G_UPDATE
410 -- P_condition_id IN NUMBER Required
411 --
412 -- OUT NOCOPY:
413 -- x_return_status OUT NOCOPY VARCHAR2
414 -- x_msg_count OUT NOCOPY NUMBER
415 -- x_msg_data OUT NOCOPY VARCHAR2
416 -- Version : Current version 1.0
417 -- End of Comments
418 --
419
420 PROCEDURE Validate_CONDITION_ID (
421 P_Init_Msg_List IN VARCHAR2,
422 P_Validation_mode IN VARCHAR2,
423 P_PLAN_ID IN NUMBER,
424 P_CONDITION_ID IN NUMBER,
425 X_Return_Status OUT NOCOPY VARCHAR2,
426 X_Msg_Count OUT NOCOPY NUMBER,
427 X_Msg_Data OUT NOCOPY VARCHAR2
428 );
429
430 -- *******************************************************
431 -- Start of Comments
435 -- Pre-Req :
432 -- *******************************************************
433 -- API Name: Validate_object_version_number
434 -- Type : Private
436 -- Parameters:
437 -- IN
438 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
439 -- p_validation_mode IN VARCHAR2 Required
440 -- p_validation_mode is a constant defined in CSC_CORE_UTILS_PVT.
441 -- For create: G_CREATE, for update: G_UPDATE
442 -- P_object_version_number IN NUMBER Required
443 --
444 -- OUT NOCOPY:
445 -- x_return_status OUT NOCOPY VARCHAR2
446 -- x_msg_count OUT NOCOPY NUMBER
447 -- x_msg_data OUT NOCOPY VARCHAR2
448 -- Version : Current version 1.0
449 -- End of Comments
450 --
451
452 PROCEDURE Validate_OBJECT_VERSION_NUMBER (
453 P_Init_Msg_List IN VARCHAR2,
454 P_Validation_mode IN VARCHAR2,
455 P_OBJECT_VERSION_NUMBER IN NUMBER,
456 X_Return_Status OUT NOCOPY VARCHAR2,
457 X_Msg_Count OUT NOCOPY NUMBER,
458 X_Msg_Data OUT NOCOPY VARCHAR2
459 );
460
461 -- *******************************************************
462 -- Start of Comments
463 -- *******************************************************
464 -- API Name: Validate_CSC_PLAN_LINES
465 -- Type : Private
466 -- Pre-Req :
467 -- Parameters:
468 -- IN
469 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
470 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
471 -- p_validation_mode IN VARCHAR2 Required
472 -- p_validation_mode is a constant defined in CSC_CORE_UTILS_PVT.
473 -- For create: G_CREATE, for update: G_UPDATE
474 -- P_object_version_number IN NUMBER Required
475 --
476 -- OUT NOCOPY:
477 -- x_return_status OUT NOCOPY VARCHAR2
478 -- x_msg_count OUT NOCOPY NUMBER
479 -- x_msg_data OUT NOCOPY VARCHAR2
480 -- Version : Current version 1.0
481 -- End of Comments
482 --
483
484 PROCEDURE Validate_CSC_PLAN_LINES(
485 P_Init_Msg_List IN VARCHAR2,
486 P_Validation_level IN NUMBER,
487 P_Validation_mode IN VARCHAR2,
488 P_CSC_PLAN_LINES_Rec IN CSC_PLAN_LINES_Rec_Type,
489 X_Return_Status OUT NOCOPY VARCHAR2,
490 X_Msg_Count OUT NOCOPY NUMBER,
491 X_Msg_Data OUT NOCOPY VARCHAR2
492 );
493
494 End CSC_PLAN_LINES_PVT;