1 PACKAGE CSC_RELATIONSHIP_PLANS_PUB AUTHID CURRENT_USER as
2 /* $Header: cscprlps.pls 120.0 2005/05/30 15:49:10 appldev noship $ */
3 -- Start of Comments
4 -- Package name : CSC_RELATIONSHIP_PLANS_PUB
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 the dbdrv command.
20 -- 05-23-2002 dejoseph Added checkfile syntax.
21 -- 11-12-2002 bhroy NOCOPY changes made
22 -- 11-27-2002 bhroy All the default values have been removed, added WHENEVER OSERROR EXIT FAILURE ROLLBACK
23 -- End of Comments
24
25 -- Default number of records fetch per call
26 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
27
28 TYPE CSC_PLAN_HEADERS_B_REC_TYPE IS RECORD
29 (
30 ROW_ID ROWID ,
31 PLAN_ID NUMBER,
32 ORIGINAL_PLAN_ID NUMBER,
33 PLAN_GROUP_CODE VARCHAR2(30),
34 START_DATE_ACTIVE DATE,
35 END_DATE_ACTIVE DATE,
36 USE_FOR_CUST_ACCOUNT VARCHAR2(1),
37 END_USER_TYPE VARCHAR2(30),
38 CUSTOMIZED_PLAN VARCHAR2(1),
39 PROFILE_CHECK_ID NUMBER ,
40 RELATIONAL_OPERATOR VARCHAR2(30),
41 CRITERIA_VALUE_HIGH VARCHAR2(50),
42 CRITERIA_VALUE_LOW VARCHAR2(50),
43 CREATION_DATE DATE ,
44 LAST_UPDATE_DATE DATE,
45 CREATED_BY NUMBER ,
46 LAST_UPDATED_BY NUMBER,
47 LAST_UPDATE_LOGIN NUMBER,
48 ATTRIBUTE1 VARCHAR2(150) ,
49 ATTRIBUTE2 VARCHAR2(150),
50 ATTRIBUTE3 VARCHAR2(150),
51 ATTRIBUTE4 VARCHAR2(150),
52 ATTRIBUTE5 VARCHAR2(150),
53 ATTRIBUTE6 VARCHAR2(150),
54 ATTRIBUTE7 VARCHAR2(150),
55 ATTRIBUTE8 VARCHAR2(150),
56 ATTRIBUTE9 VARCHAR2(150),
57 ATTRIBUTE10 VARCHAR2(150),
58 ATTRIBUTE11 VARCHAR2(150),
59 ATTRIBUTE12 VARCHAR2(150),
60 ATTRIBUTE13 VARCHAR2(150),
61 ATTRIBUTE14 VARCHAR2(150),
62 ATTRIBUTE15 VARCHAR2(150),
63 ATTRIBUTE_CATEGORY VARCHAR2(90),
64 OBJECT_VERSION_NUMBER NUMBER
65 );
66
67 G_MISS_CSC_PLAN_HEADERS_B_REC CSC_PLAN_HEADERS_B_REC_TYPE;
68
69 -- *******************************************************
70 -- Start of Comments
71 -- *******************************************************
72 -- API Name: create_plan_header
73 -- Type : Public
74 -- Pre-Req : None
75 -- Function: Procedure to create a plan header. Insert records into CSC_PLAN_HEADERS_B
76 -- and CSC_PLAN_HEADERS_TL
77 -- Parameters:
78 -- IN
79 -- p_api_version_number IN NUMBER Required
80 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
81 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
82 -- P_CSC_PLAN_HEADERS_B_Rec IN CSC_PLAN_HEADERS_B_REC_TYPE Required
83 -- P_DESCRIPTION IN VARCHAR2 Required -- Plan description for translation
84 -- -- table
85 -- P_NAME IN VARCHAR2 Required -- Plan name for translation table.
86 -- P_PARTY_ID_TBL IN CSC_CUST_PLANS_PVT.CSC_PARTY_ID_TBL_TYPE
87 -- Optional Default =
88 -- CSC_CUST_PLANS_PVT.G_MISS_PARTY_ID_TBL
89 -- -- If a plan is being customized, then this table of party_ids
90 -- -- store the ids of the parties for which the plan is being
91 -- -- customized.
92 -- -- If a 'CUSTOMIZED ACCOUNT LEVEL' plan ie. CUSTOMIZED_PLAN='Y'
93 -- -- and 'USE_FOR_CUST_ACCOUNT='Y', is being created, then the
94 -- -- ACCOUNT_ID and ACCOUNT_ORG should be specified.
95 --
96 -- OUT NOCOPY:
97 -- x_plan_id OUT NOCOPY NUMBER
98 -- x_object_version_number OUT NOCOPY NUMBER
99 -- x_return_status OUT NOCOPY VARCHAR2
100 -- x_msg_count OUT NOCOPY NUMBER
101 -- x_msg_data OUT NOCOPY VARCHAR2
102 -- Version : Current version 1.0
103 --
104 -- End of Comments
105
106 PROCEDURE create_plan_header(
107 P_Api_Version_Number IN NUMBER,
108 P_Init_Msg_List IN VARCHAR2 := NULL,
109 P_Commit IN VARCHAR2 := NULL,
110 P_CSC_PLAN_HEADERS_B_REC IN CSC_PLAN_HEADERS_B_REC_TYPE := NULL,
111 P_DESCRIPTION IN VARCHAR2,
112 P_NAME IN VARCHAR2,
113 P_PARTY_ID_TBL IN CSC_CUST_PLANS_PVT.CSC_PARTY_ID_TBL_TYPE,
114 X_PLAN_ID OUT NOCOPY NUMBER,
115 X_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER,
116 X_Return_Status OUT NOCOPY VARCHAR2,
117 X_Msg_Count OUT NOCOPY NUMBER,
118 X_Msg_Data OUT NOCOPY VARCHAR2 );
119
120
121 -- *******************************************************
122 -- Start of Comments
123 -- *******************************************************
124 -- API Name: create_plan_header (overloaded procedure to take in individual parameters
125 -- rather than a record type)
126 -- Type : Public
127 -- Pre-Req : None
128 -- Function: Procedure to create a plan header. Insert records into CSC_PLAN_HEADERS_B
129 -- and CSC_PLAN_HEADERS_TL
130 -- Parameters:
131 -- IN
132 -- p_api_version_number IN NUMBER Required
133 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
134 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
135 -- p_ROW_ID IN ROWID := FND_API.G_MISS_CHAR
136 -- p_PLAN_ID IN NUMBER := FND_API.G_MISS_NUM
137 -- p_ORIGINAL_PLAN_ID IN NUMBER := FND_API.G_MISS_NUM
138 -- p_PLAN_GROUP_CODE IN VARCHAR2(30) := FND_API.G_MISS_CHAR
139 -- p_START_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE
140 -- p_END_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE
141 -- p_USE_FOR_CUST_ACCOUNT IN VARCHAR2(1) := FND_API.G_MISS_CHAR
142 -- p_END_USER_TYPE IN VARCHAR2(30):= FND_API.G_MISS_CHAR
143 -- p_CUSTOMIZED_PLAN IN VARCHAR2(1) := FND_API.G_MISS_CHAR
144 -- p_PROFILE_CHECK_ID IN NUMBER := FND_API.G_MISS_NUM
145 -- p_RELATIONAL_OPERATOR IN VARCHAR2(30) := FND_API.G_MISS_CHAR
146 -- p_CRITERIA_VALUE_HIGH IN VARCHAR2(50) := FND_API.G_MISS_CHAR
147 -- p_CRITERIA_VALUE_LOW IN VARCHAR2(50) := FND_API.G_MISS_CHAR
148 -- p_CREATION_DATE IN DATE := FND_API.G_MISS_DATE
149 -- p_LAST_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE
150 -- p_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM
151 -- p_LAST_UPDATED_BY IN NUMBER := FND_API.G_MISS_NUM
152 -- p_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM
153 -- p_ATTRIBUTE1 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
154 -- p_ATTRIBUTE2 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
155 -- p_ATTRIBUTE3 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
156 -- p_ATTRIBUTE4 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
157 -- p_ATTRIBUTE5 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
158 -- p_ATTRIBUTE6 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
159 -- p_ATTRIBUTE7 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
160 -- p_ATTRIBUTE8 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
161 -- p_ATTRIBUTE9 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
162 -- p_ATTRIBUTE10 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
163 -- p_ATTRIBUTE11 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
164 -- p_ATTRIBUTE12 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
165 -- p_ATTRIBUTE13 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
166 -- p_ATTRIBUTE14 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
167 -- p_ATTRIBUTE15 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
168 -- p_ATTRIBUTE_CATEGORY IN VARCHAR2(90) := FND_API.G_MISS_CHAR
169 -- p_OBJECT_VERSION_NUMBER IN NUMBER := FND_API.G_MISS_NUM
170 -- P_DESCRIPTION IN VARCHAR2 Required -- Plan description for translation
171 -- -- table
172 -- P_NAME IN VARCHAR2 Required -- Plan name for translation table.
173 -- P_PARTY_ID_TBL IN CSC_CUST_PLANS_PVT.CSC_PARTY_ID_TBL_TYPE
174 -- Optional Default =
175 -- CSC_CUST_PLANS_PVT.G_MISS_PARTY_ID_TBL
176 -- -- If a plan is being customized, then this table of party_ids
177 -- -- store the ids of the parties for which the plan is being
178 -- -- customized
179 -- -- If a 'CUSTOMIZED ACCOUNT LEVEL' plan ie. CUSTOMIZED_PLAN='Y'
180 -- -- and 'USE_FOR_CUST_ACCOUNT='Y', is being created, then the
181 -- -- ACCOUNT_ID and ACCOUNT_ORG should be specified.
182 --
183 -- OUT NOCOPY:
184 -- x_plan_id OUT NOCOPY NUMBER
185 -- x_object_version_number OUT NOCOPY NUMBER
186 -- x_return_status OUT NOCOPY VARCHAR2
187 -- x_msg_count OUT NOCOPY NUMBER
188 -- x_msg_data OUT NOCOPY VARCHAR2
189 -- Version : Current version 1.0
190 --
191 -- End of Comments
192
193 PROCEDURE create_plan_header (
194 P_Api_Version_Number IN NUMBER,
195 P_Init_Msg_List IN VARCHAR2 := NULL,
196 P_Commit IN VARCHAR2 := NULL,
197 P_ROW_ID IN ROWID := NULL,
198 P_PLAN_ID IN NUMBER := NULL,
199 P_ORIGINAL_PLAN_ID IN NUMBER := NULL,
200 P_PLAN_GROUP_CODE IN VARCHAR2 := NULL,
201 P_START_DATE_ACTIVE IN DATE := NULL,
202 P_END_DATE_ACTIVE IN DATE := NULL,
203 P_USE_FOR_CUST_ACCOUNT IN VARCHAR2 := NULL,
204 P_END_USER_TYPE IN VARCHAR2 := NULL,
205 P_CUSTOMIZED_PLAN IN VARCHAR2 := NULL,
206 P_PROFILE_CHECK_ID IN NUMBER := NULL,
207 P_RELATIONAL_OPERATOR IN VARCHAR2 := NULL,
208 P_CRITERIA_VALUE_HIGH IN VARCHAR2 := NULL,
209 P_CRITERIA_VALUE_LOW IN VARCHAR2 := NULL,
210 P_CREATION_DATE IN DATE := NULL,
211 P_LAST_UPDATE_DATE IN DATE := NULL,
212 P_CREATED_BY IN NUMBER := NULL,
213 P_LAST_UPDATED_BY IN NUMBER := NULL,
214 P_LAST_UPDATE_LOGIN IN NUMBER := NULL,
215 P_ATTRIBUTE1 IN VARCHAR2 := NULL,
216 P_ATTRIBUTE2 IN VARCHAR2 := NULL,
217 P_ATTRIBUTE3 IN VARCHAR2 := NULL,
218 P_ATTRIBUTE4 IN VARCHAR2 := NULL,
219 P_ATTRIBUTE5 IN VARCHAR2 := NULL,
220 P_ATTRIBUTE6 IN VARCHAR2 := NULL,
221 P_ATTRIBUTE7 IN VARCHAR2 := NULL,
222 P_ATTRIBUTE8 IN VARCHAR2 := NULL,
223 P_ATTRIBUTE9 IN VARCHAR2 := NULL,
224 P_ATTRIBUTE10 IN VARCHAR2 := NULL,
225 P_ATTRIBUTE11 IN VARCHAR2 := NULL,
226 P_ATTRIBUTE12 IN VARCHAR2 := NULL,
227 P_ATTRIBUTE13 IN VARCHAR2 := NULL,
228 P_ATTRIBUTE14 IN VARCHAR2 := NULL,
229 P_ATTRIBUTE15 IN VARCHAR2 := NULL,
230 P_ATTRIBUTE_CATEGORY IN VARCHAR2 := NULL,
231 P_OBJECT_VERSION_NUMBER IN NUMBER := NULL,
232 P_DESCRIPTION IN VARCHAR2,
233 P_NAME IN VARCHAR2,
234 P_PARTY_ID_TBL IN CSC_CUST_PLANS_PVT.CSC_PARTY_ID_TBL_TYPE,
235 X_PLAN_ID OUT NOCOPY NUMBER,
236 X_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER,
237 X_Return_Status OUT NOCOPY VARCHAR2,
238 X_Msg_Count OUT NOCOPY NUMBER,
239 X_Msg_Data OUT NOCOPY VARCHAR2 );
240
241
242 -- *******************************************************
243 -- Start of Comments
244 -- *******************************************************
245 -- API Name: update_plan_header
246 -- Type : Public
247 -- Pre-Req : Plan header should be defined. ie. record should exist in CSC_PLAN_HEADERS_B.
248 -- Function: Procedure to update a plan header. Updates record into CSC_PLAN_HEADERS_B and
249 -- CSC_PLAN_HEADERS_TL.
250 -- Parameters:
251 -- IN
252 -- p_api_version_number IN NUMBER Required
253 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
254 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
255 -- P_CSC_PLAN_HEADERS_B_REC IN CSC_PLAN_HEADERS_B_REC_TYPE Required
256 -- P_DESCRIPTION IN VARCHAR2 Required
257 -- P_NAME IN VARCHAR2 Required
258 -- P_PARTY_ID_TBL IN CSC_CUST_PLANS_PVT.CSC_PARTY_ID_TBL_TYPE
259 -- Optional Default =
260 -- CSC_CUST_PLANS_PVT.G_MISS_PARTY_ID_TBL
261 -- -- If a plan is being customized, then this table of party_ids
262 -- -- store the ids of the parties for which the plan is being
263 -- -- customized
264 -- -- If a 'CUSTOMIZED ACCOUNT LEVEL' plan ie. CUSTOMIZED_PLAN='Y'
265 -- -- and 'USE_FOR_CUST_ACCOUNT='Y', is being created, then the
266 -- -- ACCOUNT_ID and ACCOUNT_ORG should be specified.
267 --
268 -- OUT NOCOPY:
269 -- x_object_version_number OUT NOCOPY NUMBER
270 -- x_return_status OUT NOCOPY VARCHAR2
271 -- x_msg_count OUT NOCOPY NUMBER
272 -- x_msg_data OUT NOCOPY VARCHAR2
273 -- Version : Current version 1.0
274 --
275 -- End of Comments
276
277 PROCEDURE update_plan_header(
278 P_Api_Version_Number IN NUMBER,
279 P_Init_Msg_List IN VARCHAR2 := NULL,
280 P_Commit IN VARCHAR2 := NULL,
281 P_CSC_PLAN_HEADERS_B_REC IN CSC_PLAN_HEADERS_B_REC_TYPE := NULL,
282 P_DESCRIPTION IN VARCHAR2 := NULL,
283 P_NAME IN VARCHAR2 := NULL,
284 P_PARTY_ID_TBL IN CSC_CUST_PLANS_PVT.CSC_PARTY_ID_TBL_TYPE,
285 X_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER,
286 X_Return_Status OUT NOCOPY VARCHAR2,
287 X_Msg_Count OUT NOCOPY NUMBER,
288 X_Msg_Data OUT NOCOPY VARCHAR2
289 );
290
291 -- *******************************************************
292 -- Start of Comments
293 -- *******************************************************
294 -- API Name: update_plan_header (overloaded procedure to take in individual parameters
295 -- rather than a record type)
296 -- Type : Public
297 -- Pre-Req : Plan header should be defined. ie. record should exist in CSC_PLAN_HEADERS_B.
298 -- Function: Procedure to update a plan header. Updates record into CSC_PLAN_HEADERS_B and
299 -- CSC_PLAN_HEADERS_TL.
300 -- Parameters:
301 -- IN
302 -- p_api_version_number IN NUMBER Required
303 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
304 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
305 -- p_ROW_ID IN ROWID := FND_API.G_MISS_CHAR
306 -- p_PLAN_ID IN NUMBER := FND_API.G_MISS_NUM
307 -- p_ORIGINAL_PLAN_ID IN NUMBER := FND_API.G_MISS_NUM
308 -- p_PLAN_GROUP_CODE IN VARCHAR2(30) := FND_API.G_MISS_CHAR
309 -- p_START_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE
310 -- p_END_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE
311 -- p_USE_FOR_CUST_ACCOUNT IN VARCHAR2(1) := FND_API.G_MISS_CHAR
312 -- p_END_USER_TYPE IN VARCHAR2(30):= FND_API.G_MISS_CHAR
313 -- p_CUSTOMIZED_PLAN IN VARCHAR2(1) := FND_API.G_MISS_CHAR
314 -- p_PROFILE_CHECK_ID IN NUMBER := FND_API.G_MISS_NUM
315 -- p_RELATIONAL_OPERATOR IN VARCHAR2(30) := FND_API.G_MISS_CHAR
316 -- p_CRITERIA_VALUE_HIGH IN VARCHAR2(50) := FND_API.G_MISS_CHAR
317 -- p_CRITERIA_VALUE_LOW IN VARCHAR2(50) := FND_API.G_MISS_CHAR
318 -- p_CREATION_DATE IN DATE := FND_API.G_MISS_DATE
319 -- p_LAST_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE
320 -- p_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM
321 -- p_LAST_UPDATED_BY IN NUMBER := FND_API.G_MISS_NUM
322 -- p_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM
323 -- p_ATTRIBUTE1 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
324 -- p_ATTRIBUTE2 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
325 -- p_ATTRIBUTE3 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
326 -- p_ATTRIBUTE4 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
327 -- p_ATTRIBUTE5 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
328 -- p_ATTRIBUTE6 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
329 -- p_ATTRIBUTE7 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
330 -- p_ATTRIBUTE8 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
331 -- p_ATTRIBUTE9 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
332 -- p_ATTRIBUTE10 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
333 -- p_ATTRIBUTE11 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
334 -- p_ATTRIBUTE12 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
335 -- p_ATTRIBUTE13 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
336 -- p_ATTRIBUTE14 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
337 -- p_ATTRIBUTE15 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
338 -- p_ATTRIBUTE_CATEGORY IN VARCHAR2(90) := FND_API.G_MISS_CHAR
339 -- p_OBJECT_VERSION_NUMBER IN NUMBER := FND_API.G_MISS_NUM
340 -- P_DESCRIPTION IN VARCHAR2 Required
341 -- P_NAME IN VARCHAR2 Required
342 -- P_PARTY_ID_TBL IN CSC_CUST_PLANS_PVT.CSC_PARTY_ID_TBL_TYPE
343 -- Optional Default =
344 -- CSC_CUST_PLANS_PVT.G_MISS_PARTY_ID_TBL
345 -- -- If a plan is being customized, then this table of party_ids
346 -- -- store the ids of the parties for which the plan is being
347 -- -- customized
348 -- -- If a 'CUSTOMIZED ACCOUNT LEVEL' plan ie. CUSTOMIZED_PLAN='Y'
349 -- -- and 'USE_FOR_CUST_ACCOUNT='Y', is being created, then the
350 -- -- ACCOUNT_ID and ACCOUNT_ORG should be specified.
351 --
352 -- OUT NOCOPY:
353 -- x_object_version_number OUT NOCOPY NUMBER
354 -- x_return_status OUT NOCOPY VARCHAR2
355 -- x_msg_count OUT NOCOPY NUMBER
356 -- x_msg_data OUT NOCOPY VARCHAR2
357 -- Version : Current version 1.0
358 --
359 -- End of Comments
360
361
362 PROCEDURE update_plan_header(
363 P_Api_Version_Number IN NUMBER,
364 P_Init_Msg_List IN VARCHAR2 := NULL,
365 P_Commit IN VARCHAR2 := NULL,
366 P_ROW_ID IN ROWID := NULL,
367 P_PLAN_ID IN NUMBER := NULL,
368 P_ORIGINAL_PLAN_ID IN NUMBER := NULL,
369 P_PLAN_GROUP_CODE IN VARCHAR2 := NULL,
370 P_START_DATE_ACTIVE IN DATE := NULL,
371 P_END_DATE_ACTIVE IN DATE := NULL,
372 P_USE_FOR_CUST_ACCOUNT IN VARCHAR2 := NULL,
373 P_END_USER_TYPE IN VARCHAR2 := NULL,
374 P_CUSTOMIZED_PLAN IN VARCHAR2 := NULL,
375 P_PROFILE_CHECK_ID IN NUMBER := NULL,
376 P_RELATIONAL_OPERATOR IN VARCHAR2 := NULL,
377 P_CRITERIA_VALUE_HIGH IN VARCHAR2 := NULL,
378 P_CRITERIA_VALUE_LOW IN VARCHAR2 := NULL,
379 P_CREATION_DATE IN DATE := NULL,
380 P_LAST_UPDATE_DATE IN DATE := NULL,
381 P_CREATED_BY IN NUMBER := NULL,
382 P_LAST_UPDATED_BY IN NUMBER := NULL,
383 P_LAST_UPDATE_LOGIN IN NUMBER := NULL,
384 P_ATTRIBUTE1 IN VARCHAR2 := NULL,
385 P_ATTRIBUTE2 IN VARCHAR2 := NULL,
386 P_ATTRIBUTE3 IN VARCHAR2 := NULL,
387 P_ATTRIBUTE4 IN VARCHAR2 := NULL,
388 P_ATTRIBUTE5 IN VARCHAR2 := NULL,
389 P_ATTRIBUTE6 IN VARCHAR2 := NULL,
390 P_ATTRIBUTE7 IN VARCHAR2 := NULL,
391 P_ATTRIBUTE8 IN VARCHAR2 := NULL,
392 P_ATTRIBUTE9 IN VARCHAR2 := NULL,
393 P_ATTRIBUTE10 IN VARCHAR2 := NULL,
394 P_ATTRIBUTE11 IN VARCHAR2 := NULL,
395 P_ATTRIBUTE12 IN VARCHAR2 := NULL,
396 P_ATTRIBUTE13 IN VARCHAR2 := NULL,
397 P_ATTRIBUTE14 IN VARCHAR2 := NULL,
398 P_ATTRIBUTE15 IN VARCHAR2 := NULL,
399 P_ATTRIBUTE_CATEGORY IN VARCHAR2 := NULL,
400 P_OBJECT_VERSION_NUMBER IN NUMBER := NULL,
401 P_DESCRIPTION IN VARCHAR2 := NULL,
402 P_NAME IN VARCHAR2 := NULL,
403 P_PARTY_ID_TBL IN CSC_CUST_PLANS_PVT.CSC_PARTY_ID_TBL_TYPE,
404 X_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER,
405 X_Return_Status OUT NOCOPY VARCHAR2,
406 X_Msg_Count OUT NOCOPY NUMBER,
407 X_Msg_Data OUT NOCOPY VARCHAR2
408 );
409
410
411 -- *******************************************************
412 -- Start of Comments
413 -- *******************************************************
414 -- API Name: Disable_plan
415 -- Type : Public
416 -- Pre-Req : Plan header should be defined and enabled. ie. record should exist in
417 -- CSC_PLAN_HEADERS_B with a end_date_active > sysdate.
418 -- Function: Procedure to disable a plan. Modifies end_date_active in the CSC_PLAN_HEADERS_B
419 -- table to >= sysdate.
420 -- Parameters:
421 -- IN
422 -- p_api_version_number IN NUMBER Required
423 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
424 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
425 -- P_plan_id IN NUMBER Required
426 --
427 -- OUT NOCOPY:
428 -- x_return_status OUT NOCOPY VARCHAR2
429 -- x_msg_count OUT NOCOPY NUMBER
430 -- x_msg_data OUT NOCOPY VARCHAR2
431 -- Version : Current version 1.0
432 --
433 -- End of Comments
434
435 PROCEDURE Disable_plan(
436 P_Api_Version_Number IN NUMBER,
437 P_Init_Msg_List IN VARCHAR2 := NULL,
438 P_Commit IN VARCHAR2 := NULL,
439 P_Plan_id IN NUMBER,
440 X_Return_Status OUT NOCOPY VARCHAR2,
441 X_Msg_Count OUT NOCOPY NUMBER,
442 X_Msg_Data OUT NOCOPY VARCHAR2
443 );
444
445 End CSC_RELATIONSHIP_PLANS_PUB;