1 PACKAGE CSC_RELATIONSHIP_PLANS_PVT as
2 /* $Header: cscvrlps.pls 120.0 2005/05/30 15:53:06 appldev noship $ */
3 -- Start of Comments
4 -- Package name : CSC_RELATIONSHIP_PLANS_PVT
5 -- Purpose : This package contains all procedures and functions that are required
6 -- to create and modify plan headers and disable plans.
7 -- History :
8 -- MM-DD-YYYY NAME MODIFICATIONS
9 -- 10-08-1999 dejoseph Created.
10 -- 12-08-1999 dejoseph 'Arcs'ed in for first code freeze.
11 -- 12-21-1999 dejoseph 'Arcs'ed in for second code freeze.
12 -- 01-03-2000 dejoseph 'Arcs'ed in for third code freeze. (10-JAN-2000)
13 -- 01-31-2000 dejoseph 'Arcs'ed in for fourth code freeze. (07-FEB-2000)
14 -- 02-13-2000 dejoseph 'Arcs'ed on for fifth code freeze. (21-FEB-2000)
15 -- 02-28-2000 dejoseph 'Arcs'ed on for sixth code freeze. (06-MAR-2000)
16 -- 02-18-2002 dejoseph Added changes to uptake new functionality for 11.5.8.
17 -- Ct. / Agent facing application
18 -- - Added new IN parameter END_USER_TYPE
19 -- - Added a new procedure VALIDATE_END_USER_TYPE
20 -- Added the dbdrv command.
21 -- 05-23-2002 dejoseph Added checkfile syntax.
22 -- 11-13-2002 bhroy NOCOPY changes made
23 -- 11-27-2002 bhroy All the default values have been removed
24 --
25 -- End of Comments
26
27 -- Default number of records fetch per call
28 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
29
30 TYPE CSC_PLAN_HEADERS_B_REC_TYPE IS RECORD
31 (
32 ROW_ID ROWID,
33 PLAN_ID NUMBER,
34 ORIGINAL_PLAN_ID NUMBER,
35 PLAN_GROUP_CODE VARCHAR2(30),
36 START_DATE_ACTIVE DATE,
37 END_DATE_ACTIVE DATE,
38 USE_FOR_CUST_ACCOUNT VARCHAR2(1),
39 END_USER_TYPE VARCHAR2(30),
40 CUSTOMIZED_PLAN VARCHAR2(1),
41 PROFILE_CHECK_ID NUMBER,
42 RELATIONAL_OPERATOR VARCHAR2(30),
43 CRITERIA_VALUE_HIGH VARCHAR2(50),
44 CRITERIA_VALUE_LOW VARCHAR2(50),
45 CREATION_DATE DATE,
46 LAST_UPDATE_DATE DATE,
47 CREATED_BY NUMBER,
48 LAST_UPDATED_BY NUMBER,
49 LAST_UPDATE_LOGIN NUMBER,
50 ATTRIBUTE1 VARCHAR2(150),
51 ATTRIBUTE2 VARCHAR2(150),
52 ATTRIBUTE3 VARCHAR2(150),
53 ATTRIBUTE4 VARCHAR2(150),
54 ATTRIBUTE5 VARCHAR2(150),
55 ATTRIBUTE6 VARCHAR2(150),
56 ATTRIBUTE7 VARCHAR2(150),
57 ATTRIBUTE8 VARCHAR2(150),
58 ATTRIBUTE9 VARCHAR2(150),
59 ATTRIBUTE10 VARCHAR2(150),
60 ATTRIBUTE11 VARCHAR2(150),
61 ATTRIBUTE12 VARCHAR2(150),
62 ATTRIBUTE13 VARCHAR2(150),
63 ATTRIBUTE14 VARCHAR2(150),
64 ATTRIBUTE15 VARCHAR2(150),
65 ATTRIBUTE_CATEGORY VARCHAR2(90),
66 OBJECT_VERSION_NUMBER NUMBER );
67
68 G_MISS_CSC_PLAN_HEADERS_B_REC CSC_PLAN_HEADERS_B_REC_TYPE;
69
70 /*
71 TYPE CSC_PARTY_ID_REC_TYPE IS RECORD (
72 PARTY_ID NUMBER := FND_API.G_MISS_NUM,
73 CUST_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
74 CUST_ACCOUNT_ORG NUMBER := FND_API.G_MISS_NUM );
75
76 TYPE CSC_PARTY_ID_TBL_TYPE IS TABLE OF CSC_PARTY_ID_REC_TYPE
77 INDEX BY BINARY_INTEGER;
78 G_MISS_PARTY_ID_TBL CSC_PARTY_ID_TBL_TYPE;
79 */
80
81 -- *******************************************************
82 -- Start of Comments
83 -- *******************************************************
84 -- API Name: create_plan_header
85 -- Type : Private
86 -- Pre-Req : None.
87 -- Parameters:
88 -- IN
89 -- p_api_version_number IN NUMBER Required
90 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
91 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
92 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
93 -- P_CSC_PLAN_HEADERS_B_REC IN CSC_PLAN_HEADERS_B_REC_TYPE Required
94 -- P_DESCRIPTION IN VARCHAR2 Required -- Plan description for translation
95 -- -- table
96 -- P_NAME IN VARCHAR2 Required -- Plan name for translation table.
97 -- P_PARTY_ID_TBL IN CSC_CUST_PLANS_PVT.CSC_PARTY_ID_TBL_TYPE
98 -- Optional Default =
99 -- CSC_CUST_PLANS_PVT.G_MISS_PARTY_ID_TBL
100 -- -- If a plan is being customized, then this table of party_ids
101 -- -- store the ids of the parties for which the plan is being
102 -- -- customized
103 -- -- If a 'CUSTOMIZED ACCOUNT LEVEL' plan ie. CUSTOMIZED_PLAN='Y'
104 -- -- and 'USE_FOR_CUST_ACCOUNT='Y', is being created, then the
105 -- -- ACCOUNT_ID and ACCOUNT_ORG columns in the table type
106 -- -- should be specified.
107 --
108 -- OUT :
109 -- x_plan_id OUT NOCOPY NUMBER
110 -- x_object_version_number OUT NOCOPY NUMBER
111 -- x_return_status OUT NOCOPY VARCHAR2
112 -- x_msg_count OUT NOCOPY NUMBER
113 -- x_msg_data OUT NOCOPY VARCHAR2
114 -- Version : Current version 1.0
115 --
116 -- End of Comments
117 --
118 PROCEDURE create_plan_header(
119 P_Api_Version_Number IN NUMBER,
120 P_Init_Msg_List IN VARCHAR2,
121 P_Commit IN VARCHAR2,
122 p_validation_level IN NUMBER,
123 P_CSC_PLAN_HEADERS_B_REC IN CSC_PLAN_HEADERS_B_REC_TYPE,
124 P_DESCRIPTION IN VARCHAR2,
125 P_NAME IN VARCHAR2,
126 P_PARTY_ID_TBL IN CSC_CUST_PLANS_PVT.CSC_PARTY_ID_TBL_TYPE,
127 X_PLAN_ID OUT NOCOPY NUMBER,
128 X_Object_Version_Number OUT NOCOPY NUMBER,
129 X_Return_Status OUT NOCOPY VARCHAR2,
130 X_Msg_Count OUT NOCOPY NUMBER,
131 X_Msg_Data OUT NOCOPY VARCHAR2 );
132
133
134 -- *******************************************************
135 -- Start of Comments
136 -- *******************************************************
137 -- API Name: create_plan_header (overloaded procedure to take in individual parameters
138 -- rather than a record type)
139 -- Type : Private
140 -- Pre-Req : None.
141 -- Parameters:
142 -- IN
143 -- p_api_version_number IN NUMBER Required
144 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
145 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
146 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
147 -- p_ROW_ID IN ROWID := FND_API.G_MISS_CHAR
148 -- p_PLAN_ID IN NUMBER := FND_API.G_MISS_NUM
149 -- p_ORIGINAL_PLAN_ID IN NUMBER := FND_API.G_MISS_NUM
150 -- p_PLAN_GROUP_CODE IN VARCHAR2(30) := FND_API.G_MISS_CHAR
151 -- p_START_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE
152 -- p_END_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE
153 -- p_USE_FOR_CUST_ACCOUNT IN VARCHAR2(1) := FND_API.G_MISS_CHAR
154 -- p_END_USER_TYPE IN VARCHAR2(30):= CSC_CORE_UTILS_PVT.G_MISS_CHAR
155 -- p_CUSTOMIZED_PLAN IN VARCHAR2(1) := FND_API.G_MISS_CHAR
156 -- p_PROFILE_CHECK_ID IN NUMBER := FND_API.G_MISS_NUM
157 -- p_RELATIONAL_OPERATOR IN VARCHAR2(30) := FND_API.G_MISS_CHAR
158 -- p_CRITERIA_VALUE_HIGH IN VARCHAR2(50) := FND_API.G_MISS_CHAR
159 -- p_CRITERIA_VALUE_LOW IN VARCHAR2(50) := FND_API.G_MISS_CHAR
160 -- p_CREATION_DATE IN DATE := FND_API.G_MISS_DATE
161 -- p_LAST_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE
162 -- p_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM
163 -- p_LAST_UPDATED_BY IN NUMBER := FND_API.G_MISS_NUM
164 -- p_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM
165 -- p_ATTRIBUTE1 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
166 -- p_ATTRIBUTE2 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
167 -- p_ATTRIBUTE3 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
168 -- p_ATTRIBUTE4 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
169 -- p_ATTRIBUTE5 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
170 -- p_ATTRIBUTE6 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
171 -- p_ATTRIBUTE7 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
172 -- p_ATTRIBUTE8 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
173 -- p_ATTRIBUTE9 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
174 -- p_ATTRIBUTE10 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
175 -- p_ATTRIBUTE11 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
176 -- p_ATTRIBUTE12 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
177 -- p_ATTRIBUTE13 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
178 -- p_ATTRIBUTE14 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
179 -- p_ATTRIBUTE15 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
180 -- p_ATTRIBUTE_CATEGORY IN VARCHAR2(90) := FND_API.G_MISS_CHAR
181 -- p_OBJECT_VERSION_NUMBER IN NUMBER := FND_API.G_MISS_NUM
182 -- P_DESCRIPTION IN VARCHAR2 Required -- Plan description for translation
183 -- -- table
184 -- P_NAME IN VARCHAR2 Required -- Plan name for translation table.
185 -- P_PARTY_ID_TBL IN CSC_CUST_PLANS_PVT.CSC_PARTY_ID_TBL_TYPE
186 -- Optional Default =
187 -- CSC_CUST_PLANS_PVT.G_MISS_PARTY_ID_TBL
188 -- -- If a plan is being customized, then this table of party_ids
189 -- -- store the ids of the parties for which the plan is being
190 -- -- customized
191 -- -- If a 'CUSTOMIZED ACCOUNT LEVEL' plan ie. CUSTOMIZED_PLAN='Y'
192 -- -- and 'USE_FOR_CUST_ACCOUNT='Y', is being created, then the
193 -- -- ACCOUNT_ID and ACCOUNT_ORG columns in the table type should
194 -- -- be specified.
195 --
196 -- OUT NOCOPY:
197 -- x_plan_id OUT NOCOPY NUMBER
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 --
204 -- End of Comments
205 --
206 PROCEDURE create_plan_header(
207 P_Api_Version_Number IN NUMBER,
208 P_Init_Msg_List IN VARCHAR2,
209 P_Commit IN VARCHAR2,
210 p_validation_level IN NUMBER,
211 P_ROW_ID IN ROWID,
212 P_PLAN_ID IN NUMBER,
213 P_ORIGINAL_PLAN_ID IN NUMBER,
214 P_PLAN_GROUP_CODE IN VARCHAR2,
215 P_START_DATE_ACTIVE IN DATE,
216 P_END_DATE_ACTIVE IN DATE,
217 P_USE_FOR_CUST_ACCOUNT IN VARCHAR2,
218 P_END_USER_TYPE IN VARCHAR2,
219 P_CUSTOMIZED_PLAN IN VARCHAR2,
220 P_PROFILE_CHECK_ID IN NUMBER,
221 P_RELATIONAL_OPERATOR IN VARCHAR2,
222 P_CRITERIA_VALUE_HIGH IN VARCHAR2,
223 P_CRITERIA_VALUE_LOW IN VARCHAR2,
224 P_CREATION_DATE IN DATE,
225 P_LAST_UPDATE_DATE IN DATE,
226 P_CREATED_BY IN NUMBER,
227 P_LAST_UPDATED_BY IN NUMBER,
228 P_LAST_UPDATE_LOGIN IN NUMBER,
229 P_ATTRIBUTE1 IN VARCHAR2,
230 P_ATTRIBUTE2 IN VARCHAR2,
231 P_ATTRIBUTE3 IN VARCHAR2,
232 P_ATTRIBUTE4 IN VARCHAR2,
233 P_ATTRIBUTE5 IN VARCHAR2,
234 P_ATTRIBUTE6 IN VARCHAR2,
235 P_ATTRIBUTE7 IN VARCHAR2,
236 P_ATTRIBUTE8 IN VARCHAR2,
237 P_ATTRIBUTE9 IN VARCHAR2,
238 P_ATTRIBUTE10 IN VARCHAR2,
239 P_ATTRIBUTE11 IN VARCHAR2,
240 P_ATTRIBUTE12 IN VARCHAR2,
241 P_ATTRIBUTE13 IN VARCHAR2,
242 P_ATTRIBUTE14 IN VARCHAR2,
243 P_ATTRIBUTE15 IN VARCHAR2,
244 P_ATTRIBUTE_CATEGORY IN VARCHAR2,
245 P_OBJECT_VERSION_NUMBER IN NUMBER,
246 P_DESCRIPTION IN VARCHAR2,
247 P_NAME IN VARCHAR2,
248 P_PARTY_ID_TBL IN CSC_CUST_PLANS_PVT.CSC_PARTY_ID_TBL_TYPE,
249 X_PLAN_ID OUT NOCOPY NUMBER,
250 X_Object_Version_Number OUT NOCOPY NUMBER,
251 X_Return_Status OUT NOCOPY VARCHAR2,
252 X_Msg_Count OUT NOCOPY NUMBER,
253 X_Msg_Data OUT NOCOPY VARCHAR2);
254
255 -- *******************************************************
256 -- Start of Comments
257 -- *******************************************************
258 -- API Name: update_plan_header
259 -- Type : Private
260 -- Pre-Req : None
261 -- Function: Procedure to update a plan header. Updates record into CSC_PLAN_HEADERS_B
262 -- Parameters:
263 -- IN
264 -- p_api_version_number IN NUMBER Required
265 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
266 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
267 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
268 -- P_CSC_PLAN_HEADERS_B_REC IN CSC_PLAN_HEADERS_B_REC_TYPE Required
269 -- P_DESCRIPTION IN VARCHAR2 Required
270 -- P_NAME IN VARCHAR2 Required
271 -- P_PARTY_ID_TBL IN CSC_CUST_PLANS_PVT.CSC_PARTY_ID_TBL_TYPE
272 -- Optional Default =
273 -- CSC_CUST_PLANS_PVT.G_MISS_PARTY_ID_TBL
274 -- -- If a plan is being customized, then this table of party_ids
275 -- -- store the ids of the parties for which the plan is being
276 -- -- customized
277 -- -- If a 'CUSTOMIZED ACCOUNT LEVEL' plan ie. CUSTOMIZED_PLAN='Y'
278 -- -- and 'USE_FOR_CUST_ACCOUNT='Y', is being created, then the
279 -- -- ACCOUNT_ID and ACCOUNT_ORG columns in the table type should
280 -- -- be specified.
281 --
282 -- OUT NOCOPY:
283 -- x_object_version_number OUT NOCOPY NUMBER
284 -- x_return_status OUT NOCOPY VARCHAR2
285 -- x_msg_count OUT NOCOPY NUMBER
286 -- x_msg_data OUT NOCOPY VARCHAR2
287 -- Version : Current version 1.0
288 --
289 -- End of Comments
290 --
291
292 PROCEDURE update_plan_header(
293 P_Api_Version_Number IN NUMBER,
294 P_Init_Msg_List IN VARCHAR2,
295 P_Commit IN VARCHAR2,
299 P_NAME IN VARCHAR2,
296 p_validation_level IN NUMBER,
297 P_CSC_PLAN_HEADERS_B_REC IN CSC_PLAN_HEADERS_B_REC_TYPE,
298 P_DESCRIPTION IN VARCHAR2,
300 P_PARTY_ID_TBL IN CSC_CUST_PLANS_PVT.CSC_PARTY_ID_TBL_TYPE,
301 X_Object_Version_Number OUT NOCOPY NUMBER,
302 X_Return_Status OUT NOCOPY VARCHAR2,
303 X_Msg_Count OUT NOCOPY NUMBER,
304 X_Msg_Data OUT NOCOPY VARCHAR2
305 );
306
307
308 -- *******************************************************
309 -- Start of Comments
310 -- *******************************************************
311 -- API Name: update_plan_header (overloaded procedure to take in individual parameters
312 -- rather than a record type)
313 -- Type : Private
314 -- Pre-Req : None
315 -- Function: Procedure to update a plan header. Updates record into CSC_PLAN_HEADERS_B
316 -- Parameters:
317 -- IN
318 -- p_api_version_number IN NUMBER Required
319 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
320 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
321 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
322 -- p_ROW_ID IN ROWID := FND_API.G_MISS_CHAR
323 -- p_PLAN_ID IN NUMBER := FND_API.G_MISS_NUM
324 -- p_ORIGINAL_PLAN_ID IN NUMBER := FND_API.G_MISS_NUM
325 -- p_PLAN_GROUP_CODE IN VARCHAR2(30) := FND_API.G_MISS_CHAR
326 -- p_START_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE
327 -- p_END_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE
328 -- p_USE_FOR_CUST_ACCOUNT IN VARCHAR2(1) := FND_API.G_MISS_CHAR
329 -- p_END_USER_TYPE IN VARCHAR2(30):= CSC_CORE_UTILS_PVT.G_MISS_CHAR
330 -- p_CUSTOMIZED_PLAN IN VARCHAR2(1) := FND_API.G_MISS_CHAR
331 -- p_PROFILE_CHECK_ID IN NUMBER := FND_API.G_MISS_NUM
332 -- p_RELATIONAL_OPERATOR IN VARCHAR2(30) := FND_API.G_MISS_CHAR
333 -- p_CRITERIA_VALUE_HIGH IN VARCHAR2(50) := FND_API.G_MISS_CHAR
334 -- p_CRITERIA_VALUE_LOW IN VARCHAR2(50) := FND_API.G_MISS_CHAR
335 -- p_CREATION_DATE IN DATE := FND_API.G_MISS_DATE
336 -- p_LAST_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE
337 -- p_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM
338 -- p_LAST_UPDATED_BY IN NUMBER := FND_API.G_MISS_NUM
339 -- p_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM
340 -- p_ATTRIBUTE1 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
341 -- p_ATTRIBUTE2 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
342 -- p_ATTRIBUTE3 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
343 -- p_ATTRIBUTE4 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
344 -- p_ATTRIBUTE5 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
345 -- p_ATTRIBUTE6 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
346 -- p_ATTRIBUTE7 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
347 -- p_ATTRIBUTE8 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
348 -- p_ATTRIBUTE9 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
349 -- p_ATTRIBUTE10 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
350 -- p_ATTRIBUTE11 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
351 -- p_ATTRIBUTE12 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
352 -- p_ATTRIBUTE13 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
353 -- p_ATTRIBUTE14 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
354 -- p_ATTRIBUTE15 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
355 -- p_ATTRIBUTE_CATEGORY IN VARCHAR2(90) := FND_API.G_MISS_CHAR
356 -- p_OBJECT_VERSION_NUMBER IN NUMBER := FND_API.G_MISS_NUM
357 -- P_DESCRIPTION IN VARCHAR2 Required
358 -- P_NAME IN VARCHAR2 Required
359 -- P_PARTY_ID_TBL IN CSC_CUST_PLANS_PVT.CSC_PARTY_ID_TBL_TYPE
360 -- Optional Default =
361 -- CSC_CUST_PLANS_PVT.G_MISS_PARTY_ID_TBL
362 -- -- If a plan is being customized, then this table of party_ids
363 -- -- store the ids of the parties for which the plan is being
364 -- -- customized
365 -- -- If a 'CUSTOMIZED ACCOUNT LEVEL' plan ie. CUSTOMIZED_PLAN='Y'
366 -- -- and 'USE_FOR_CUST_ACCOUNT='Y', is being created, then the
367 -- -- ACCOUNT_ID and ACCOUNT_ORG columns in the table type should
368 -- -- be specified.
369 --
370 -- OUT NOCOPY:
371 -- x_object_version_number OUT NOCOPY NUMBER
372 -- x_return_status OUT NOCOPY VARCHAR2
373 -- x_msg_count OUT NOCOPY NUMBER
374 -- x_msg_data OUT NOCOPY VARCHAR2
375 -- Version : Current version 1.0
376 --
377 -- End of Comments
378 --
379
380 PROCEDURE update_plan_header(
381 P_Api_Version_Number IN NUMBER,
382 P_Init_Msg_List IN VARCHAR2,
383 P_Commit IN VARCHAR2,
387 P_ORIGINAL_PLAN_ID IN NUMBER,
384 p_validation_level IN NUMBER,
385 P_ROW_ID IN ROWID,
386 P_PLAN_ID IN NUMBER,
388 P_PLAN_GROUP_CODE IN VARCHAR2,
389 P_START_DATE_ACTIVE IN DATE,
390 P_END_DATE_ACTIVE IN DATE,
391 P_USE_FOR_CUST_ACCOUNT IN VARCHAR2,
392 P_END_USER_TYPE IN VARCHAR2,
393 P_CUSTOMIZED_PLAN IN VARCHAR2,
394 P_PROFILE_CHECK_ID IN NUMBER,
395 P_RELATIONAL_OPERATOR IN VARCHAR2,
396 P_CRITERIA_VALUE_HIGH IN VARCHAR2,
397 P_CRITERIA_VALUE_LOW IN VARCHAR2,
398 P_CREATION_DATE IN DATE,
399 P_LAST_UPDATE_DATE IN DATE,
400 P_CREATED_BY IN NUMBER,
401 P_LAST_UPDATED_BY IN NUMBER,
402 P_LAST_UPDATE_LOGIN IN NUMBER,
403 P_ATTRIBUTE1 IN VARCHAR2,
404 P_ATTRIBUTE2 IN VARCHAR2,
405 P_ATTRIBUTE3 IN VARCHAR2,
406 P_ATTRIBUTE4 IN VARCHAR2,
407 P_ATTRIBUTE5 IN VARCHAR2,
408 P_ATTRIBUTE6 IN VARCHAR2,
409 P_ATTRIBUTE7 IN VARCHAR2,
410 P_ATTRIBUTE8 IN VARCHAR2,
411 P_ATTRIBUTE9 IN VARCHAR2,
412 P_ATTRIBUTE10 IN VARCHAR2,
413 P_ATTRIBUTE11 IN VARCHAR2,
414 P_ATTRIBUTE12 IN VARCHAR2,
415 P_ATTRIBUTE13 IN VARCHAR2,
416 P_ATTRIBUTE14 IN VARCHAR2,
417 P_ATTRIBUTE15 IN VARCHAR2,
418 P_ATTRIBUTE_CATEGORY IN VARCHAR2,
419 P_OBJECT_VERSION_NUMBER IN NUMBER,
420 P_DESCRIPTION IN VARCHAR2,
421 P_NAME IN VARCHAR2,
422 P_PARTY_ID_TBL IN CSC_CUST_PLANS_PVT.CSC_PARTY_ID_TBL_TYPE,
423 X_Object_Version_Number OUT NOCOPY NUMBER,
424 X_Return_Status OUT NOCOPY VARCHAR2,
425 X_Msg_Count OUT NOCOPY NUMBER,
426 X_Msg_Data OUT NOCOPY VARCHAR2
427 );
428
429
430 -- *******************************************************
431 -- Start of Comments
432 -- *******************************************************
433 -- API Name: Disable_plan
434 -- Type : Private
435 -- Pre-Req : Existing plan that is enabled.
436 -- Function: Disables an existing enabled plan. Modifies the end_date_active in the
437 -- CSC_PLAN_HEADERS_B table to sysdate + 1.
438 -- Parameters:
439 -- IN
440 -- p_api_version_number IN NUMBER Required
441 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
442 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
443 -- p_plan_id IN NUMBER
444 --
445 -- OUT :
446 -- x_return_status OUT NOCOPY VARCHAR2
447 -- x_msg_count OUT NOCOPY NUMBER
448 -- x_msg_data OUT NOCOPY VARCHAR2
449 -- Version : Current version 1.0
450 --
451 -- End of Comments
452 --
453
454 PROCEDURE Disable_plan(
455 P_Api_Version_Number IN NUMBER,
456 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
457 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
458 p_plan_id IN NUMBER,
459 X_Return_Status OUT NOCOPY VARCHAR2,
460 X_Msg_Count OUT NOCOPY NUMBER,
461 X_Msg_Data OUT NOCOPY VARCHAR2
462 );
463
464 -- Item level validation procedures.
465 -- *******************************************************
466 -- Start of Comments
467 -- *******************************************************
468 -- API Name: validate_plan_id
469 -- Type : Private
470 -- Pre-Req : None.
471 -- Function: Performs validation on the value of plan_id
472 -- Parameters:
473 -- IN
474 -- p_validation_mode is a constant defined in CSC_CORE_UTILS_PVT package
475 -- For create: G_CREATE, for update: G_UPDATE
476 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
477 -- p_validation_mode IN VARCHAR2
478 -- p_plan_id IN NUMBER
479 --
480 -- OUT :
481 -- x_return_status OUT NOCOPY VARCHAR2
482 -- x_msg_count OUT NOCOPY NUMBER
483 -- x_msg_data OUT NOCOPY VARCHAR2
484 -- Version : Current version 1.0
485 --
486 -- End of Comments
487 --
488
489 PROCEDURE Validate_PLAN_ID (
490 P_Init_Msg_List IN VARCHAR2,
491 P_Validation_mode IN VARCHAR2,
492 P_PLAN_ID IN NUMBER,
493 X_Return_Status OUT NOCOPY VARCHAR2,
494 X_Msg_Count OUT NOCOPY NUMBER,
495 X_Msg_Data OUT NOCOPY VARCHAR2
496 );
497
498 -- *******************************************************
499 -- Start of Comments
500 -- *******************************************************
501 -- API Name: validate_name
505 -- Parameters:
502 -- Type : Private
503 -- Pre-Req : None.
504 -- Function: Performs validation on the value of plan_name
506 -- IN
507 -- p_validation_mode is a constant defined in CSC_CORE_UTILS_PVT package
508 -- For create: G_CREATE, for update: G_UPDATE
509 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
510 -- p_validation_mode IN VARCHAR2
511 -- p_plan_name IN NUMBER
512 --
513 -- OUT :
514 -- x_return_status OUT NOCOPY VARCHAR2
515 -- x_msg_count OUT NOCOPY NUMBER
516 -- x_msg_data OUT NOCOPY VARCHAR2
517 -- Version : Current version 1.0
518 --
519 -- End of Comments
520 --
521 PROCEDURE Validate_NAME (
522 P_Init_Msg_List IN VARCHAR2,
523 P_Validation_mode IN VARCHAR2,
524 P_PLAN_ID IN NUMBER,
525 P_NAME IN VARCHAR2,
526 X_Return_Status OUT NOCOPY VARCHAR2,
527 X_Msg_Count OUT NOCOPY NUMBER,
528 X_Msg_Data OUT NOCOPY VARCHAR2
529 );
530
531 -- *******************************************************
532 -- Start of Comments
533 -- *******************************************************
534 -- API Name: validate_original_plan_id
535 -- Type : Private
536 -- Pre-Req : None.
537 -- Function: Performs validation on the value of plan_id
538 -- Parameters:
539 -- IN
540 -- p_validation_mode is a constant defined in CSC_CORE_UTILS_PVT package
541 -- For create: G_CREATE, for update: G_UPDATE
542 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
543 -- p_validation_mode IN VARCHAR2
544 -- p_original_plan_id IN NUMBER
545 -- p_customized_plan IN VARCHAR2 Optional Default = 'N'
546 --
547 -- OUT :
548 -- x_return_status OUT NOCOPY VARCHAR2
549 -- x_msg_count OUT NOCOPY NUMBER
550 -- x_msg_data OUT NOCOPY VARCHAR2
551 -- Version : Current version 1.0
552 --
553 -- End of Comments
554 --
555 PROCEDURE Validate_ORIGINAL_PLAN_ID (
556 P_Init_Msg_List IN VARCHAR2,
557 P_Validation_mode IN VARCHAR2,
558 P_PLAN_ID IN NUMBER,
559 P_ORIGINAL_PLAN_ID IN NUMBER,
560 P_CUSTOMIZED_PLAN IN VARCHAR2 := 'N',
561 X_Return_Status OUT NOCOPY VARCHAR2,
562 X_Msg_Count OUT NOCOPY NUMBER,
563 X_Msg_Data OUT NOCOPY VARCHAR2
564 );
565
566 -- *******************************************************
567 -- Start of Comments
568 -- *******************************************************
569 -- API Name: validate_plan_group_code
570 -- Type : Private
571 -- Pre-Req : None.
572 -- Function: Performs validation on the value of plan_group_code
573 -- Parameters:
574 -- IN
575 -- p_validation_mode is a constant defined in CSC_CORE_UTILS_PVT package
576 -- For create: G_CREATE, for update: G_UPDATE
577 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
578 -- p_validation_mode IN VARCHAR2
579 -- p_plan_group_code IN NUMBER
580 --
581 -- OUT :
582 -- x_return_status OUT NOCOPY VARCHAR2
583 -- x_msg_count OUT NOCOPY NUMBER
584 -- x_msg_data OUT NOCOPY VARCHAR2
585 -- Version : Current version 1.0
586 --
587 -- End of Comments
588 --
589 PROCEDURE Validate_Plan_Group_Code (
590 P_Init_Msg_List IN VARCHAR2,
591 P_Validation_mode IN VARCHAR2,
592 P_PLAN_GROUP_CODE IN VARCHAR2,
593 X_Return_Status OUT NOCOPY VARCHAR2,
594 X_Msg_Count OUT NOCOPY NUMBER,
595 X_Msg_Data OUT NOCOPY VARCHAR2
596 );
597
598 -- *******************************************************
599 -- Start of Comments
600 -- *******************************************************
601 -- API Name: validate_use_for_cust_account
602 -- Type : Private
603 -- Pre-Req : None.
604 -- Function: Performs validation on the value of use_for_cust_account.
605 -- Parameters:
606 -- IN
607 -- p_validation_mode is a constant defined in CSC_CORE_UTILS_PVT package
608 -- For create: G_CREATE, for update: G_UPDATE
609 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
610 -- p_validation_mode IN VARCHAR2
611 -- p_plan_id IN NUMBER
612 -- p_use_for_cust_account IN NUMBER
613 -- p_old_use_for_cust_account IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
614 --
615 -- OUT :
616 -- x_return_status OUT NOCOPY VARCHAR2
617 -- x_msg_count OUT NOCOPY NUMBER
618 -- x_msg_data OUT NOCOPY VARCHAR2
619 -- Version : Current version 1.0
620 --
621 -- End of Comments
622 --
623 PROCEDURE Validate_USE_FOR_CUST_ACCOUNT (
624 P_Init_Msg_List IN VARCHAR2,
628 P_OLD_USE_FOR_CUST_ACCOUNT IN VARCHAR2,
625 P_Validation_mode IN VARCHAR2,
626 P_PLAN_ID IN NUMBER,
627 P_USE_FOR_CUST_ACCOUNT IN VARCHAR2,
629 X_Return_Status OUT NOCOPY VARCHAR2,
630 X_Msg_Count OUT NOCOPY NUMBER,
631 X_Msg_Data OUT NOCOPY VARCHAR2
632 );
633
634 -- *******************************************************
635 -- Start of Comments
636 -- *******************************************************
637 -- API Name: validate_end_user_type
638 -- Type : Private
639 -- Pre-Req : None.
640 -- Function: Performs validation on the value of end_user_type. This column gets its
641 -- value from a lookup. LOOKUP_TYPE = CSC_END_USER_TYPE and the valid
642 -- LOOKUP_CODES are 'CUST' and 'AGENT'. This is a NULLABLE column.
643 -- Parameters:
644 -- IN
645 -- p_validation_mode is a constant defined in CSC_CORE_UTILS_PVT package
646 -- For create: G_CREATE, for update: G_UPDATE
647 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
648 -- p_validation_mode IN VARCHAR2
649 -- p_end_user_type IN VARCHAR2
650 --
651 -- OUT :
652 -- x_return_status OUT NOCOPY VARCHAR2
653 -- x_msg_count OUT NOCOPY NUMBER
654 -- x_msg_data OUT NOCOPY VARCHAR2
655 -- Version : Current version 1.0
656 --
657 -- End of Comments
658 --
659 PROCEDURE Validate_END_USER_TYPE (
660 P_Init_Msg_List IN VARCHAR2,
661 P_Validation_mode IN VARCHAR2,
662 P_END_USER_TYPE IN VARCHAR2,
663 X_Return_Status OUT NOCOPY VARCHAR2,
664 X_Msg_Count OUT NOCOPY NUMBER,
665 X_Msg_Data OUT NOCOPY VARCHAR2
666 );
667
668 -- *******************************************************
669 -- Start of Comments
670 -- *******************************************************
671 -- API Name: validate_customized_plan
672 -- Type : Private
673 -- Pre-Req : None.
674 -- Function: Performs validation on the value of customized_plan
675 -- Parameters:
676 -- IN
677 -- p_validation_mode is a constant defined in CSC_CORE_UTILS_PVT package
678 -- For create: G_CREATE, for update: G_UPDATE
679 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
680 -- p_validation_mode IN VARCHAR2
681 -- p_customized_plan IN NUMBER
682 --
683 -- OUT :
684 -- x_return_status OUT NOCOPY VARCHAR2
685 -- x_msg_count OUT NOCOPY NUMBER
686 -- x_msg_data OUT NOCOPY VARCHAR2
687 -- Version : Current version 1.0
688 --
689 -- End of Comments
690 --
691 PROCEDURE Validate_CUSTOMIZED_PLAN (
692 P_Init_Msg_List IN VARCHAR2,
693 P_Validation_mode IN VARCHAR2,
694 P_CUSTOMIZED_PLAN IN VARCHAR2,
695 X_Return_Status OUT NOCOPY VARCHAR2,
696 X_Msg_Count OUT NOCOPY NUMBER,
697 X_Msg_Data OUT NOCOPY VARCHAR2
698 );
699
700 -- *******************************************************
701 -- Start of Comments
702 -- *******************************************************
703 -- API Name: validate_profile_check_id
704 -- Type : Private
705 -- Pre-Req : None.
706 -- Function: Performs validation on the value of profile_check_id
707 -- Parameters:
708 -- IN
709 -- p_validation_mode is a constant defined in CSC_CORE_UTILS_PVT package
710 -- For create: G_CREATE, for update: G_UPDATE
711 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
712 -- p_validation_mode IN VARCHAR2
713 -- p_plan_id IN NUMBER
714 -- p_profile_check_id IN NUMBER
715 -- p_old_profile_check_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
716 --
717 -- OUT :
718 -- x_return_status OUT NOCOPY VARCHAR2
719 -- x_msg_count OUT NOCOPY NUMBER
720 -- x_msg_data OUT NOCOPY VARCHAR2
721 -- Version : Current version 1.0
722 --
723 -- End of Comments
724 --
725 PROCEDURE Validate_PROFILE_CHECK_ID (
726 P_Init_Msg_List IN VARCHAR2,
727 P_Validation_mode IN VARCHAR2,
728 P_PLAN_ID IN NUMBER,
729 P_PROFILE_CHECK_ID IN NUMBER,
730 P_OLD_PROFILE_CHECK_ID IN NUMBER,
731 X_Return_Status OUT NOCOPY VARCHAR2,
732 X_Msg_Count OUT NOCOPY NUMBER,
733 X_Msg_Data OUT NOCOPY VARCHAR2
734 );
735
736 -- *******************************************************
737 -- Start of Comments
738 -- *******************************************************
739 -- API Name: validate_criteria_value_low
740 -- Type : Private
741 -- Pre-Req : None.
742 -- Function: Performs validation on the value of criteria_value_low
743 -- Parameters:
744 -- IN
748 -- p_validation_mode IN VARCHAR2
745 -- p_validation_mode is a constant defined in CSC_CORE_UTILS_PVT package
746 -- For create: G_CREATE, for update: G_UPDATE
747 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
749 -- p_plan_id IN NUMBER
750 -- p_criteria_value_low IN NUMBER
751 -- p_old_criteria_value_low IN NUMBER Optional Default = FND_API.G_MISS_NUM
752 --
753 -- OUT :
754 -- x_return_status OUT NOCOPY VARCHAR2
755 -- x_msg_count OUT NOCOPY NUMBER
756 -- x_msg_data OUT NOCOPY VARCHAR2
757 -- Version : Current version 1.0
758 --
759 -- End of Comments
760 --
761 PROCEDURE Validate_CRITERIA_VALUE_LOW (
762 P_Init_Msg_List IN VARCHAR2,
763 P_Validation_mode IN VARCHAR2,
764 P_PLAN_ID IN NUMBER,
765 P_CRITERIA_VALUE_LOW IN VARCHAR2,
766 P_OLD_CRITERIA_VALUE_LOW IN VARCHAR2,
767 X_Return_Status OUT NOCOPY VARCHAR2,
768 X_Msg_Count OUT NOCOPY NUMBER,
769 X_Msg_Data OUT NOCOPY VARCHAR2
770 );
771
772 -- *******************************************************
773 -- Start of Comments
774 -- *******************************************************
775 -- API Name: validate_criteria_value_high
776 -- Type : Private
777 -- Pre-Req : None.
778 -- Function: Performs validation on the value of criteria_value_high
779 -- Parameters:
780 -- IN
781 -- p_validation_mode is a constant defined in CSC_CORE_UTILS_PVT package
782 -- For create: G_CREATE, for update: G_UPDATE
783 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
784 -- p_validation_mode IN VARCHAR2
785 -- p_plan_id IN NUMBER
786 -- p_criteria_value_high IN VARCHAR2
787 -- p_old_criteria_value_high IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
788 --
789 -- OUT :
790 -- x_return_status OUT NOCOPY VARCHAR2
791 -- x_msg_count OUT NOCOPY NUMBER
792 -- x_msg_data OUT NOCOPY VARCHAR2
793 -- Version : Current version 1.0
794 --
795 -- End of Comments
796 --
797 PROCEDURE Validate_CRITERIA_VALUE_HIGH (
798 P_Init_Msg_List IN VARCHAR2,
799 P_Validation_mode IN VARCHAR2,
800 P_PLAN_ID IN NUMBER,
801 P_CRITERIA_VALUE_HIGH IN VARCHAR2,
802 P_OLD_CRITERIA_VALUE_HIGH IN VARCHAR2,
803 X_Return_Status OUT NOCOPY VARCHAR2,
804 X_Msg_Count OUT NOCOPY NUMBER,
805 X_Msg_Data OUT NOCOPY VARCHAR2
806 );
807
808 -- *******************************************************
809 -- Start of Comments
810 -- *******************************************************
811 -- API Name: validate_relational_operator
812 -- Type : Private
813 -- Pre-Req : None.
814 -- Function: Performs validation on the value of relational_operator
815 -- Parameters:
816 -- IN
817 -- p_validation_mode is a constant defined in CSC_CORE_UTILS_PVT package
818 -- For create: G_CREATE, for update: G_UPDATE
819 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
820 -- p_validation_mode IN VARCHAR2
821 -- p_plan_id IN NUMBER
822 -- p_relational_operator IN VARCHAR2
823 -- p_old_relational_operator IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
824 --
825 -- OUT :
826 -- x_return_status OUT NOCOPY VARCHAR2
827 -- x_msg_count OUT NOCOPY NUMBER
828 -- x_msg_data OUT NOCOPY VARCHAR2
829 -- Version : Current version 1.0
830 --
831 -- End of Comments
832 --
833 PROCEDURE Validate_RELATIONAL_OPERATOR (
834 P_Init_Msg_List IN VARCHAR2,
835 P_Validation_mode IN VARCHAR2,
836 P_PLAN_ID IN NUMBER,
837 P_RELATIONAL_OPERATOR IN VARCHAR2,
838 P_OLD_RELATIONAL_OPERATOR IN VARCHAR2,
839 X_Return_Status OUT NOCOPY VARCHAR2,
840 X_Msg_Count OUT NOCOPY NUMBER,
841 X_Msg_Data OUT NOCOPY VARCHAR2
842 );
843
844 -- *******************************************************
845 -- Start of Comments
846 -- *******************************************************
847 -- API Name: validate_plan_criteria
848 -- Type : Private
849 -- Pre-Req : None.
850 -- Function: Performs validation on the values used to define the plan
851 -- criteria. ie. relational_operator, criteria_value_low and
852 -- criteria_value_high.
853 -- Parameters:
854 -- IN
855 -- p_validation_mode is a constant defined in CSC_CORE_UTILS_PVT package
856 -- For create: G_CREATE, for update: G_UPDATE
857 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
858 -- p_validation_mode IN VARCHAR2
859 -- p_plan_id IN NUMBER
860 -- p_relational_operator IN VARCHAR2
861 -- p_criteria_value_low IN VARCHAR2
865 -- x_return_status OUT NOCOPY VARCHAR2
862 -- p_criteria_value_high IN VARCHAR2
863 --
864 -- OUT :
866 -- x_msg_count OUT NOCOPY NUMBER
867 -- x_msg_data OUT NOCOPY VARCHAR2
868 -- Version : Current version 1.0
869 --
870 -- End of Comments
871 --
872 PROCEDURE Validate_Plan_Criteria (
873 P_Init_Msg_List IN VARCHAR2,
874 P_Validation_mode IN VARCHAR2,
875 P_PLAN_ID IN NUMBER,
876 P_RELATIONAL_OPERATOR IN VARCHAR2,
877 P_CRITERIA_VALUE_LOW IN VARCHAR2,
878 P_CRITERIA_VALUE_HIGH IN VARCHAR2,
879 X_Return_Status OUT NOCOPY VARCHAR2,
880 X_Msg_Count OUT NOCOPY NUMBER,
881 X_Msg_Data OUT NOCOPY VARCHAR2 );
882
883 -- *******************************************************
884 -- Start of Comments
885 -- *******************************************************
886 -- API Name: validate_start_date_active
887 -- Type : Private
888 -- Pre-Req : None.
889 -- Function: Performs validation on the value of start_date_active. For updates
890 -- start_date_active should be less than the minimum of
891 -- csc_cust_plans.start_date_active.
892 -- Parameters:
893 -- IN
894 -- p_validation_mode is a constant defined in CSC_CORE_UTILS_PVT package
895 -- For create: G_CREATE, for update: G_UPDATE
896 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
897 -- p_validation_mode IN VARCHAR2
898 -- p_plan_id IN NUMBER
899 -- p_start_date_active IN DATE
900 --
901 -- OUT :
902 -- x_return_status OUT NOCOPY VARCHAR2
903 -- x_msg_count OUT NOCOPY NUMBER
904 -- x_msg_data OUT NOCOPY VARCHAR2
905 -- Version : Current version 1.0
906 --
907 -- End of Comments
908 --
909 PROCEDURE Validate_START_DATE_ACTIVE (
910 P_Init_Msg_List IN VARCHAR2,
911 P_Validation_mode IN VARCHAR2,
912 P_PLAN_ID IN NUMBER,
913 P_START_DATE_ACTIVE IN DATE,
914 X_Return_Status OUT NOCOPY VARCHAR2,
915 X_Msg_Count OUT NOCOPY NUMBER,
916 X_Msg_Data OUT NOCOPY VARCHAR2
917 );
918
919
920 -- *******************************************************
921 -- Start of Comments
922 -- *******************************************************
923 -- API Name: validate_end_date_active
924 -- Type : Private
925 -- Pre-Req : None.
926 -- Function: Performs validation on the value of end_date_active. For updates
927 -- end_date_active should be greater than the maximum of
928 -- csc_cust_plans.end_date_active.
929 -- Parameters:
930 -- IN
931 -- p_validation_mode is a constant defined in CSC_CORE_UTILS_PVT package
932 -- For create: G_CREATE, for update: G_UPDATE
933 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
934 -- p_validation_mode IN VARCHAR2
935 -- p_plan_id IN NUMBER
936 -- p_end_date_active IN DATE
937 --
938 -- OUT :
939 -- x_return_status OUT NOCOPY VARCHAR2
940 -- x_msg_count OUT NOCOPY NUMBER
941 -- x_msg_data OUT NOCOPY VARCHAR2
942 -- Version : Current version 1.0
943 --
944 -- End of Comments
945 --
946 PROCEDURE Validate_END_DATE_ACTIVE (
947 P_Init_Msg_List IN VARCHAR2,
948 P_Validation_mode IN VARCHAR2,
949 P_PLAN_ID IN NUMBER,
950 P_END_DATE_ACTIVE IN DATE,
951 X_Return_Status OUT NOCOPY VARCHAR2,
952 X_Msg_Count OUT NOCOPY NUMBER,
953 X_Msg_Data OUT NOCOPY VARCHAR2
954 );
955
956
957 -- *******************************************************
958 -- Start of Comments
959 -- *******************************************************
960 -- API Name: validate_csc_relationship_plans
961 -- Type : Private
962 -- Pre-Req : Existing plan.
963 -- Function: Performs item level validation.
964 -- Parameters:
965 -- IN
966 -- p_validation_mode is a constant defined in CSC_CORE_UTILS_PVT package
967 -- For create: G_CREATE, for update: G_UPDATE
968 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
969 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
970 -- p_validation_mode IN VARCHAR2
971 -- P_CSC_PLAN_HEADERS_B_REC IN CSC_PLAN_HEADERS_B_REC_TYPE
972 -- P_OLD_PLAN_HEADERS_B_REC IN CSC_PLAN_HEADERS_B_REC_TYPE
973 -- Optional Default = P_CSC_PLAN_HEADERS_B_REC
974 -- -- This record type is used to pass the original values of a plan
975 -- -- when performing an update, to compare old values with the new
976 -- -- updated values. Updates are not allowed on certain columns
977 -- -- under certain situations, ie. update of use_for_cust_account are
978 -- -- not allowed if there are customers accounts associated to the plan.
979 -- P_DESCRIPTION IN VARCHAR2,
980 -- P_NAME IN VARCHAR2,
981 -- P_PARTY_ID_TBL IN CSC_CUST_PLANS_PVT.CSC_PARTY_ID_TBL_TYPE
982 -- Optional Default =
983 -- CSC_CUST_PLANS_PVT.G_MISS_PARTY_ID_TBL
984 -- -- If a plan is being customized, then this table of party_ids
985 -- -- store the ids of the parties for which the plan is being
986 -- -- customized
987 -- -- If a 'CUSTOMIZED ACCOUNT LEVEL' plan ie. CUSTOMIZED_PLAN='Y'
988 -- -- and 'USE_FOR_CUST_ACCOUNT='Y', is being created, then the
989 -- -- ACCOUNT_ID and ACCOUNT_ORG columns in the table type should
990 -- -- be specified.
991 --
992 --
993 -- OUT :
994 -- x_return_status OUT NOCOPY VARCHAR2
995 -- x_msg_count OUT NOCOPY NUMBER
996 -- x_msg_data OUT NOCOPY VARCHAR2
997 -- Version : Current version 1.0
998 --
999 -- End of Comments
1000 --
1001 PROCEDURE Validate_csc_relationship_plan(
1002 P_Init_Msg_List IN VARCHAR2,
1003 P_Validation_level IN NUMBER,
1004 P_Validation_mode IN VARCHAR2,
1005 P_CSC_PLAN_HEADERS_B_REC IN CSC_PLAN_HEADERS_B_REC_TYPE,
1006 P_OLD_PLAN_HEADERS_B_REC IN CSC_PLAN_HEADERS_B_REC_TYPE := NULL,
1007 P_DESCRIPTION IN VARCHAR2,
1008 P_NAME IN VARCHAR2,
1009 X_Return_Status OUT NOCOPY VARCHAR2,
1010 X_Msg_Count OUT NOCOPY NUMBER,
1011 X_Msg_Data OUT NOCOPY VARCHAR2
1012 );
1013
1014 End CSC_RELATIONSHIP_PLANS_PVT;