1 PACKAGE CSC_CUST_PLANS_PUB AUTHID CURRENT_USER as
2 /* $Header: cscpctps.pls 120.0 2005/05/30 15:48:11 appldev noship $ */
3 -- Start of Comments
4 -- Package name : CSC_CUST_PLANS_PUB
5 -- Purpose : Public package contains defnitions of procedure, and
6 -- functions to insert, update and delete records in
7 -- CSC_CUST_PLANS table.
8 -- History :
9 -- MM-DD-YYYY NAME MODIFICATIONS
10 -- 10-28-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 -- 04-10-2000 dejoseph Removed reference to cust_account_org in lieu of TCA's
18 -- decision to drop column org_id from hz_cust_accounts.
19 -- 26-11-2002 bhroy G_MISS_XXX defaults of API parameters removed, added WHENEVER OSERROR EXIT FAILURE ROLLBACK
20
21 -- NOTE :
22 -- End of Comments
23
24 -- Default number of records fetch per call
25 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
26
27 TYPE CSC_CUST_PLANS_Rec_Type IS RECORD
28 (
29 ROW_ID ROWID,
33 CUST_ACCOUNT_ID NUMBER,
30 PLAN_ID NUMBER,
31 CUST_PLAN_ID NUMBER,
32 PARTY_ID NUMBER,
34 PLAN_NAME VARCHAR2(90),
35 GROUP_NAME VARCHAR2(80),
36 PARTY_NUMBER VARCHAR2(30),
37 PARTY_NAME VARCHAR2(255),
38 PARTY_TYPE VARCHAR2(30),
39 ACCOUNT_NUMBER VARCHAR2(30),
40 ACCOUNT_NAME VARCHAR2(240),
41 START_DATE_ACTIVE DATE,
42 END_DATE_ACTIVE DATE,
43 CUSTOMIZED_PLAN VARCHAR2(3),
44 USE_FOR_CUST_ACCOUNT VARCHAR2(3),
45 PLAN_STATUS_CODE VARCHAR2(30),
46 PLAN_STATUS_MEANING VARCHAR2(80),
47 MANUAL_FLAG VARCHAR2(3),
48 REQUEST_ID NUMBER,
49 PROGRAM_APPLICATION_ID NUMBER,
50 PROGRAM_ID NUMBER,
51 PROGRAM_UPDATE_DATE DATE,
52 CREATION_DATE DATE,
53 LAST_UPDATE_DATE DATE,
54 CREATED_BY NUMBER,
55 LAST_UPDATED_BY NUMBER,
56 USER_NAME VARCHAR2(100),
57 LAST_UPDATE_LOGIN NUMBER,
58 ATTRIBUTE1 VARCHAR2(450),
59 ATTRIBUTE2 VARCHAR2(450),
60 ATTRIBUTE3 VARCHAR2(450),
61 ATTRIBUTE4 VARCHAR2(450),
62 ATTRIBUTE5 VARCHAR2(450),
63 ATTRIBUTE6 VARCHAR2(450),
64 ATTRIBUTE7 VARCHAR2(450),
65 ATTRIBUTE8 VARCHAR2(450),
66 ATTRIBUTE9 VARCHAR2(450),
67 ATTRIBUTE10 VARCHAR2(450),
68 ATTRIBUTE11 VARCHAR2(450),
69 ATTRIBUTE12 VARCHAR2(450),
70 ATTRIBUTE13 VARCHAR2(450),
71 ATTRIBUTE14 VARCHAR2(450),
72 ATTRIBUTE15 VARCHAR2(450),
73 ATTRIBUTE_CATEGORY VARCHAR2(90),
74 OBJECT_VERSION_NUMBER NUMBER
75 );
76
77 G_MISS_CSC_CUST_PLANS_REC CSC_CUST_PLANS_Rec_Type;
78
79 TYPE CSC_CUST_PLANS_Tbl_Type IS TABLE OF CSC_CUST_PLANS_Rec_Type
80 INDEX BY BINARY_INTEGER;
81 G_MISS_CSC_CUST_PLANS_TBL CSC_CUST_PLANS_Tbl_Type;
82
83 TYPE CSC_PARTY_ID_REC_TYPE IS RECORD (
84 PARTY_ID NUMBER,
85 CUST_ACCOUNT_ID NUMBER);
86
87 TYPE CSC_PARTY_ID_TBL_TYPE IS TABLE OF CSC_PARTY_ID_REC_TYPE
88 INDEX BY BINARY_INTEGER;
89 G_MISS_PARTY_ID_TBL CSC_PARTY_ID_TBL_TYPE;
90
91
92 -- *******************************************************
93 -- Start of Comments
94 -- *******************************************************
95 -- API Name: Create_cust_plans
96 -- Type : Public
97 -- Pre-Req :
98 -- Parameters:
99 -- IN
100 -- p_api_version_number IN NUMBER Required
101 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
102 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
103 -- P_CSC_CUST_PLANS_Rec IN CSC_CUST_PLANS_Rec_Type Required
104 --
105 -- OUT NOCOPY:
106 -- X_CUST_PLAN_ID OUT NOCOPY NUMBER
107 -- X_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER
108 -- x_return_status OUT NOCOPY VARCHAR2
109 -- x_msg_count OUT NOCOPY NUMBER
110 -- x_msg_data OUT NOCOPY VARCHAR2
111 -- Version : Current version 1.0
112 --
113 -- End of Comments
114 --
115 PROCEDURE Create_cust_plans(
116 P_Api_Version_Number IN NUMBER,
117 P_Init_Msg_List IN VARCHAR2 := NULL,
118 P_Commit IN VARCHAR2 := NULL,
119 P_CSC_CUST_PLANS_Rec IN CSC_CUST_PLANS_Rec_Type := NULL,
120 X_CUST_PLAN_ID OUT NOCOPY NUMBER,
121 X_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER,
122 X_Return_Status OUT NOCOPY VARCHAR2,
123 X_Msg_Count OUT NOCOPY NUMBER,
124 X_Msg_Data OUT NOCOPY VARCHAR2
125 );
126
127 -- *******************************************************
128 -- Start of Comments
129 -- *******************************************************
130 -- API Name: Create_cust_plans (Overloaded procedure to take in a detailed list
131 -- of parameters instead of a record type parameter)
132 -- Type : Public
133 -- Pre-Req :
134 -- Parameters:
135 -- IN
136 -- p_api_version_number IN NUMBER Required
137 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
138 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
139 -- P_ROW_ID IN ROWID := FND_API.G_MISS_CHAR,
140 -- P_PLAN_ID IN NUMBER := FND_API.G_MISS_NUM,
141 -- P_CUST_PLAN_ID IN NUMBER := FND_API.G_MISS_NUM,
142 -- P_PARTY_ID IN NUMBER := FND_API.G_MISS_NUM,
146 -- P_GROUP_NAME IN VARCHAR2(80) := FND_API.G_MISS_CHAR,
143 -- P_CUST_ACCOUNT_ID IN NUMBER := FND_API.G_MISS_NUM,
144 -- P_CUST_ACCOUNT_ORG IN NUMBER := FND_API.G_MISS_NUM,
145 -- P_PLAN_NAME IN VARCHAR2(90) := FND_API.G_MISS_CHAR,
147 -- P_PARTY_NUMBER IN VARCHAR2(30) := FND_API.G_MISS_CHAR,
148 -- P_PARTY_NAME IN VARCHAR2(255) := FND_API.G_MISS_CHAR,
149 -- P_PARTY_TYPE IN VARCHAR2(30) := FND_API.G_MISS_CHAR,
150 -- P_ACCOUNT_NUMBER IN VARCHAR2(30) := FND_API.G_MISS_CHAR,
151 -- P_ACCOUNT_NAME IN VARCHAR2(240) := FND_API.G_MISS_CHAR,
152 -- P_PRIORITY IN NUMBER := FND_API.G_MISS_NUM,
153 -- P_START_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE,
154 -- P_END_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE,
155 -- P_CUSTOMIZED_PLAN IN VARCHAR2(3) := FND_API.G_MISS_CHAR,
156 -- P_USE_FOR_CUST_ACCOUNT IN VARCHAR2(3) := FND_API.G_MISS_CHAR,
157 -- P_PLAN_STATUS_CODE IN VARCHAR2(30) := FND_API.G_MISS_CHAR,
158 -- P_PLAN_STATUS_MEANING IN VARCHAR2(80) := FND_API.G_MISS_CHAR,
159 -- P_MANUAL_FLAG IN VARCHAR2(3) := FND_API.G_MISS_CHAR,
160 -- P_REQUEST_ID IN NUMBER := FND_API.G_MISS_NUM,
161 -- P_PROGRAM_APPLICATION_ID IN NUMBER := FND_API.G_MISS_NUM,
162 -- P_PROGRAM_ID IN NUMBER := FND_API.G_MISS_NUM,
163 -- P_PROGRAM_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
164 -- P_CREATION_DATE IN DATE := FND_API.G_MISS_DATE,
165 -- P_LAST_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
166 -- P_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM,
167 -- P_LAST_UPDATED_BY IN NUMBER := FND_API.G_MISS_NUM,
168 -- P_USER_NAME IN VARCHAR2(100) := FND_API.G_MISS_CHAR,
169 -- P_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM,
170 -- P_ATTRIBUTE1 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
171 -- P_ATTRIBUTE2 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
172 -- P_ATTRIBUTE3 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
173 -- P_ATTRIBUTE4 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
174 -- P_ATTRIBUTE5 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
175 -- P_ATTRIBUTE6 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
176 -- P_ATTRIBUTE7 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
177 -- P_ATTRIBUTE8 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
178 -- P_ATTRIBUTE9 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
179 -- P_ATTRIBUTE10 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
180 -- P_ATTRIBUTE11 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
181 -- P_ATTRIBUTE12 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
182 -- P_ATTRIBUTE13 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
183 -- P_ATTRIBUTE14 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
184 -- P_ATTRIBUTE15 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
185 -- P_ATTRIBUTE_CATEGORY IN VARCHAR2(90) := FND_API.G_MISS_CHAR,
186 -- P_OBJECT_VERSION_NUMBER IN NUMBER := FND_API.G_MISS_NUM
187 --
188 -- OUT NOCOPY:
189 -- X_CUST_PLAN_ID OUT NOCOPY NUMBER,
190 -- X_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER
191 -- x_return_status OUT NOCOPY VARCHAR2
192 -- x_msg_count OUT NOCOPY NUMBER
193 -- x_msg_data OUT NOCOPY VARCHAR2
194 -- Version : Current version 1.0
195 --
196 -- End of Comments
197 --
198
199 PROCEDURE Create_cust_plans(
200 P_Api_Version_Number IN NUMBER,
201 P_Init_Msg_List IN VARCHAR2 := NULL,
202 P_Commit IN VARCHAR2 := NULL,
203 P_ROW_ID IN ROWID := NULL,
204 P_PLAN_ID IN NUMBER,
205 P_CUST_PLAN_ID IN NUMBER,
206 P_PARTY_ID IN NUMBER,
207 P_CUST_ACCOUNT_ID IN NUMBER := NULL,
208 P_PLAN_NAME IN VARCHAR2 := NULL,
209 P_GROUP_NAME IN VARCHAR2 := NULL,
210 P_PARTY_NUMBER IN VARCHAR2 := NULL,
211 P_PARTY_NAME IN VARCHAR2 := NULL,
212 P_PARTY_TYPE IN VARCHAR2 := NULL,
213 P_ACCOUNT_NUMBER IN VARCHAR2 := NULL,
214 P_ACCOUNT_NAME IN VARCHAR2 := NULL,
215 P_START_DATE_ACTIVE IN DATE := NULL,
216 P_END_DATE_ACTIVE IN DATE := NULL,
217 P_CUSTOMIZED_PLAN IN VARCHAR2 := NULL,
218 P_USE_FOR_CUST_ACCOUNT IN VARCHAR2 := NULL,
219 P_PLAN_STATUS_CODE IN VARCHAR2 := NULL,
220 P_PLAN_STATUS_MEANING IN VARCHAR2 := NULL,
221 P_MANUAL_FLAG IN VARCHAR2 := NULL,
222 P_REQUEST_ID IN NUMBER := NULL,
223 P_PROGRAM_APPLICATION_ID IN NUMBER := NULL,
224 P_PROGRAM_ID IN NUMBER := NULL,
225 P_PROGRAM_UPDATE_DATE IN DATE := NULL,
226 P_CREATION_DATE IN DATE := NULL,
227 P_LAST_UPDATE_DATE IN DATE := NULL,
228 P_CREATED_BY IN NUMBER := NULL,
229 P_LAST_UPDATED_BY IN NUMBER := NULL,
230 P_USER_NAME IN VARCHAR2 := NULL,
231 P_LAST_UPDATE_LOGIN IN NUMBER := NULL,
232 P_ATTRIBUTE1 IN VARCHAR2 := NULL,
236 P_ATTRIBUTE5 IN VARCHAR2 := NULL,
233 P_ATTRIBUTE2 IN VARCHAR2 := NULL,
234 P_ATTRIBUTE3 IN VARCHAR2 := NULL,
235 P_ATTRIBUTE4 IN VARCHAR2 := NULL,
237 P_ATTRIBUTE6 IN VARCHAR2 := NULL,
238 P_ATTRIBUTE7 IN VARCHAR2 := NULL,
239 P_ATTRIBUTE8 IN VARCHAR2 := NULL,
240 P_ATTRIBUTE9 IN VARCHAR2 := NULL,
241 P_ATTRIBUTE10 IN VARCHAR2 := NULL,
242 P_ATTRIBUTE11 IN VARCHAR2 := NULL,
243 P_ATTRIBUTE12 IN VARCHAR2 := NULL,
244 P_ATTRIBUTE13 IN VARCHAR2 := NULL,
245 P_ATTRIBUTE14 IN VARCHAR2 := NULL,
246 P_ATTRIBUTE15 IN VARCHAR2 := NULL,
247 P_ATTRIBUTE_CATEGORY IN VARCHAR2 := NULL,
248 P_OBJECT_VERSION_NUMBER IN NUMBER := NULL,
249 X_CUST_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 -- *******************************************************
257 -- Start of Comments
258 -- *******************************************************
259 -- API Name: Update_cust_plans
260 -- Type : Public
261 -- Pre-Req :
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_CSC_CUST_PLANS_Rec IN CSC_CUST_PLANS_Rec_Type Required
268 --
269 -- OUT NOCOPY:
270 -- X_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER
271 -- x_return_status OUT NOCOPY VARCHAR2
272 -- x_msg_count OUT NOCOPY NUMBER
273 -- x_msg_data OUT NOCOPY VARCHAR2
274 -- Version : Current version 1.0
275 --
276 -- End of Comments
277 --
278 PROCEDURE Update_cust_plans(
279 P_Api_Version_Number IN NUMBER,
280 P_Init_Msg_List IN VARCHAR2 := NULL,
281 P_Commit IN VARCHAR2 := NULL,
282 P_CSC_CUST_PLANS_Rec IN CSC_CUST_PLANS_Rec_Type,
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 );
288
289 -- *******************************************************
290 -- Start of Comments
291 -- *******************************************************
292 -- API Name: Update_cust_plans (Overloaded procedure to take in a detailed list
293 -- of parameters instead of a record type parameter)
294 -- Type : Public
295 -- Pre-Req :
296 -- Parameters:
297 -- IN
298 -- p_api_version_number IN NUMBER Required
299 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
300 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
301 -- P_ROW_ID IN ROWID := FND_API.G_MISS_CHAR,
302 -- P_PLAN_ID IN NUMBER := FND_API.G_MISS_NUM,
303 -- P_CUST_PLAN_ID IN NUMBER := FND_API.G_MISS_NUM,
304 -- P_PARTY_ID IN NUMBER := FND_API.G_MISS_NUM,
305 -- P_CUST_ACCOUNT_ID IN NUMBER := FND_API.G_MISS_NUM,
306 -- P_CUST_ACCOUNT_ORG IN NUMBER := FND_API.G_MISS_NUM,
307 -- P_PLAN_NAME IN VARCHAR2(90) := FND_API.G_MISS_CHAR,
308 -- P_GROUP_NAME IN VARCHAR2(80) := FND_API.G_MISS_CHAR,
309 -- P_PARTY_NUMBER IN VARCHAR2(30) := FND_API.G_MISS_CHAR,
310 -- P_PARTY_NAME IN VARCHAR2(255) := FND_API.G_MISS_CHAR,
311 -- P_PARTY_TYPE IN VARCHAR2(30) := FND_API.G_MISS_CHAR,
312 -- P_ACCOUNT_NUMBER IN VARCHAR2(30) := FND_API.G_MISS_CHAR,
313 -- P_ACCOUNT_NAME IN VARCHAR2(240) := FND_API.G_MISS_CHAR,
314 -- P_PRIORITY IN NUMBER := FND_API.G_MISS_NUM,
315 -- P_START_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE,
316 -- P_END_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE,
317 -- P_CUSTOMIZED_PLAN IN VARCHAR2(3) := FND_API.G_MISS_CHAR,
318 -- P_USE_FOR_CUST_ACCOUNT IN VARCHAR2(3) := FND_API.G_MISS_CHAR,
319 -- P_PLAN_STATUS_CODE IN VARCHAR2(30) := FND_API.G_MISS_CHAR,
320 -- P_PLAN_STATUS_MEANING IN VARCHAR2(80) := FND_API.G_MISS_CHAR,
321 -- P_MANUAL_FLAG IN VARCHAR2(3) := FND_API.G_MISS_CHAR,
322 -- P_REQUEST_ID IN NUMBER := FND_API.G_MISS_NUM,
323 -- P_PROGRAM_APPLICATION_ID IN NUMBER := FND_API.G_MISS_NUM,
324 -- P_PROGRAM_ID IN NUMBER := FND_API.G_MISS_NUM,
325 -- P_PROGRAM_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
326 -- P_CREATION_DATE IN DATE := FND_API.G_MISS_DATE,
327 -- P_LAST_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
328 -- P_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM,
329 -- P_LAST_UPDATED_BY IN NUMBER := FND_API.G_MISS_NUM,
330 -- P_USER_NAME IN VARCHAR2(100) := FND_API.G_MISS_CHAR,
331 -- P_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM,
332 -- P_ATTRIBUTE1 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
333 -- P_ATTRIBUTE2 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
337 -- P_ATTRIBUTE6 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
334 -- P_ATTRIBUTE3 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
335 -- P_ATTRIBUTE4 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
336 -- P_ATTRIBUTE5 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
338 -- P_ATTRIBUTE7 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
339 -- P_ATTRIBUTE8 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
340 -- P_ATTRIBUTE9 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
341 -- P_ATTRIBUTE10 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
342 -- P_ATTRIBUTE11 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
343 -- P_ATTRIBUTE12 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
344 -- P_ATTRIBUTE13 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
345 -- P_ATTRIBUTE14 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
346 -- P_ATTRIBUTE15 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
347 -- P_ATTRIBUTE_CATEGORY IN VARCHAR2(90) := FND_API.G_MISS_CHAR,
348 -- P_OBJECT_VERSION_NUMBER IN NUMBER := FND_API.G_MISS_NUM
349 --
350 -- OUT NOCOPY:
351 -- X_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER
352 -- x_return_status OUT NOCOPY VARCHAR2
353 -- x_msg_count OUT NOCOPY NUMBER
354 -- x_msg_data OUT NOCOPY VARCHAR2
355 -- Version : Current version 1.0
356 --
357 -- End of Comments
358 --
359 PROCEDURE Update_cust_plans(
360 P_Api_Version_Number IN NUMBER,
361 P_Init_Msg_List IN VARCHAR2 := NULL,
362 P_Commit IN VARCHAR2 := NULL,
363 P_ROW_ID IN ROWID := NULL,
364 P_PLAN_ID IN NUMBER,
365 P_CUST_PLAN_ID IN NUMBER,
366 P_PARTY_ID IN NUMBER,
367 P_CUST_ACCOUNT_ID IN NUMBER := NULL,
368 P_PLAN_NAME IN VARCHAR2 := NULL,
369 P_GROUP_NAME IN VARCHAR2 := NULL,
370 P_PARTY_NUMBER IN VARCHAR2 := NULL,
371 P_PARTY_NAME IN VARCHAR2 := NULL,
372 P_PARTY_TYPE IN VARCHAR2 := NULL,
373 P_ACCOUNT_NUMBER IN VARCHAR2 := NULL,
374 P_ACCOUNT_NAME IN VARCHAR2 := NULL,
375 P_START_DATE_ACTIVE IN DATE := NULL,
376 P_END_DATE_ACTIVE IN DATE := NULL,
377 P_CUSTOMIZED_PLAN IN VARCHAR2 := NULL,
378 P_USE_FOR_CUST_ACCOUNT IN VARCHAR2 := NULL,
379 P_PLAN_STATUS_CODE IN VARCHAR2 := NULL,
380 P_PLAN_STATUS_MEANING IN VARCHAR2 := NULL,
381 P_MANUAL_FLAG IN VARCHAR2 := NULL,
382 P_REQUEST_ID IN NUMBER := NULL,
383 P_PROGRAM_APPLICATION_ID IN NUMBER := NULL,
384 P_PROGRAM_ID IN NUMBER := NULL,
385 P_PROGRAM_UPDATE_DATE IN DATE := NULL,
386 P_CREATION_DATE IN DATE := NULL,
387 P_LAST_UPDATE_DATE IN DATE := NULL,
388 P_CREATED_BY IN NUMBER := NULL,
389 P_LAST_UPDATED_BY IN NUMBER := NULL,
390 P_USER_NAME IN VARCHAR2 := NULL,
391 P_LAST_UPDATE_LOGIN IN NUMBER := NULL,
392 P_ATTRIBUTE1 IN VARCHAR2 := NULL,
393 P_ATTRIBUTE2 IN VARCHAR2 := NULL,
394 P_ATTRIBUTE3 IN VARCHAR2 := NULL,
395 P_ATTRIBUTE4 IN VARCHAR2 := NULL,
396 P_ATTRIBUTE5 IN VARCHAR2 := NULL,
397 P_ATTRIBUTE6 IN VARCHAR2 := NULL,
398 P_ATTRIBUTE7 IN VARCHAR2 := NULL,
399 P_ATTRIBUTE8 IN VARCHAR2 := NULL,
400 P_ATTRIBUTE9 IN VARCHAR2 := NULL,
401 P_ATTRIBUTE10 IN VARCHAR2 := NULL,
402 P_ATTRIBUTE11 IN VARCHAR2 := NULL,
403 P_ATTRIBUTE12 IN VARCHAR2 := NULL,
404 P_ATTRIBUTE13 IN VARCHAR2 := NULL,
405 P_ATTRIBUTE14 IN VARCHAR2 := NULL,
406 P_ATTRIBUTE15 IN VARCHAR2 := NULL,
407 P_ATTRIBUTE_CATEGORY IN VARCHAR2 := NULL,
408 P_OBJECT_VERSION_NUMBER IN NUMBER := NULL,
409 X_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER,
410 X_Return_Status OUT NOCOPY VARCHAR2,
411 X_Msg_Count OUT NOCOPY NUMBER,
412 X_Msg_Data OUT NOCOPY VARCHAR2
413 );
414
415 -- *******************************************************
416 -- Start of Comments
417 -- *******************************************************
418 -- API Name: ENABLE_PLAN
419 -- Type : Public
420 -- Pre-Req : PLAN_STATUS_CODE column in CSC_CUST_PLANS to be updated to 'ENABLED'.
421 -- Function: Calls the update procedure to update the given record in
422 -- CSC_CUST_PLANS.
423 -- Parameters:
424 -- IN
425 -- p_api_version_number IN NUMBER Required
426 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
427 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
428 -- p_plan_id IN NUMBER Required
429 -- p_party_id_tbl IN CSC_PARTY_ID_TBL_TYPE
430 -- Optional Default = G_MISS_PARTY_ID_TBL
431 -- p_plan_status_code IN NUMBER Optional Default =
432 -- CSC_CORE_UTILS_PVT.ENABLE_PLAN
433 -- OUT NOCOPY:
434 -- x_object_version_number OUT NOCOPY NUMBER
435 -- x_return_status OUT NOCOPY VARCHAR2
436 -- x_msg_count OUT NOCOPY NUMBER
437 -- x_msg_data OUT NOCOPY VARCHAR2
438 -- Version : Current version 1.0
439 --
440 -- End of Comments
441 --
442 PROCEDURE ENABLE_PLAN (
443 P_Api_Version_Number IN NUMBER,
444 P_Init_Msg_List IN VARCHAR2 := NULL,
445 P_Commit IN VARCHAR2 := NULL,
446 P_plan_id IN NUMBER,
447 p_party_id_tbl IN CSC_PARTY_ID_TBL_TYPE,
448 p_plan_status_code IN VARCHAR2 := CSC_CORE_UTILS_PVT.ENABLE_PLAN,
449 X_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER,
450 X_Return_Status OUT NOCOPY VARCHAR2,
451 X_Msg_Count OUT NOCOPY NUMBER,
452 X_Msg_Data OUT NOCOPY VARCHAR2 );
453
454 -- *******************************************************
455 -- Start of Comments
456 -- *******************************************************
457 -- API Name: DISABLE_PLAN
458 -- Type : Public
459 -- Pre-Req : PLAN_STATUS_CODE column in CSC_CUST_PLANS to be updated to 'DISABLED'.
460 -- Function: Calls the update procedure to update the given record in
461 -- CSC_CUST_PLANS.
462 -- Parameters:
463 -- IN
464 -- p_api_version_number IN NUMBER Required
465 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
466 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
467 -- p_plan_id IN NUMBER Required
468 -- p_party_id_tbl IN CSC_PARTY_ID_TBL_TYPE
469 -- Optional Default = G_MISS_PARTY_ID_TBL
470 -- p_plan_status_code IN NUMBER Optional Default =
471 -- CSC_CORE_UTILS_PVT.ENABLE_PLAN
472 -- OUT NOCOPY:
473 -- x_object_version_number OUT NOCOPY NUMBER
474 -- x_return_status OUT NOCOPY VARCHAR2
475 -- x_msg_count OUT NOCOPY NUMBER
476 -- x_msg_data OUT NOCOPY VARCHAR2
477 -- Version : Current version 1.0
478 --
479 -- End of Comments
480 --
481 PROCEDURE DISABLE_PLAN (
482 P_Api_Version_Number IN NUMBER,
483 P_Init_Msg_List IN VARCHAR2 := NULL,
484 P_Commit IN VARCHAR2 := NULL,
485 P_plan_id IN NUMBER,
486 p_party_id_tbl IN CSC_PARTY_ID_TBL_TYPE,
487 p_plan_status_code IN VARCHAR2 := CSC_CORE_UTILS_PVT.DISABLE_PLAN,
488 X_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER,
489 X_Return_Status OUT NOCOPY VARCHAR2,
490 X_Msg_Count OUT NOCOPY NUMBER,
491 X_Msg_Data OUT NOCOPY VARCHAR2 );
492
493 -- *******************************************************
494 -- Start of Comments
495 -- *******************************************************
496 -- API Name: Delete_cust_plans
497 -- Type : Public
498 -- Pre-Req :
499 -- Parameters:
500 -- IN
501 -- p_api_version_number IN NUMBER Required
502 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
503 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
504 -- P_CUST_PLAN_ID IN NUMBER Required
505 --
506 -- OUT NOCOPY:
507 -- x_return_status OUT NOCOPY VARCHAR2
508 -- x_msg_count OUT NOCOPY NUMBER
509 -- x_msg_data OUT NOCOPY VARCHAR2
510 -- Version : Current version 1.0
511 --
512 -- End of Comments
513 --
514 PROCEDURE Delete_cust_plans(
515 P_Api_Version_Number IN NUMBER,
516 P_Init_Msg_List IN VARCHAR2 := NULL,
517 P_Commit IN VARCHAR2 := NULL,
518 P_CUST_PLAN_ID IN NUMBER,
519 X_Return_Status OUT NOCOPY VARCHAR2,
520 X_Msg_Count OUT NOCOPY NUMBER,
521 X_Msg_Data OUT NOCOPY VARCHAR2
522 );
523
524 End CSC_CUST_PLANS_PUB;