[Home] [Help]
PACKAGE: APPS.AMS_CAMP_SCHEDULE_PUB
Source
1 PACKAGE AMS_Camp_Schedule_PUB AS
2 /* $Header: amspschs.pls 120.4 2006/05/31 11:54:02 srivikri ship $ */
3 /*#
4 * This package provides methods to create or update a marketing campaign schedule.
5 *
6 * Note: The campaign schedule record type is used as an input parameter in campaign schedule
7 * creation and update methods.
8 *
9 * TYPE schedule_rec_type is RECORD (
10 * schedule_id NUMBER := FND_API.G_MISS_NUM,
11 * last_update_date DATE := FND_API.G_MISS_DATE,
12 * last_updated_by NUMBER := FND_API.G_MISS_NUM,
13 * creation_date DATE := FND_API.G_MISS_DATE,
14 * created_by NUMBER := FND_API.G_MISS_NUM,
15 * last_update_login NUMBER := FND_API.G_MISS_NUM,
16 * object_version_number NUMBER := FND_API.G_MISS_NUM,
17 * campaign_id NUMBER := FND_API.G_MISS_NUM,
18 * user_status_id NUMBER := FND_API.G_MISS_NUM,
19 * status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
20 * status_date DATE := FND_API.G_MISS_DATE,
21 * source_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
22 * use_parent_code_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
23 * start_date_time DATE := FND_API.G_MISS_DATE,
24 * end_date_time DATE := FND_API.G_MISS_DATE,
25 * timezone_id NUMBER := FND_API.G_MISS_NUM,
26 * activity_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
27 * activity_id NUMBER := FND_API.G_MISS_NUM,
28 * arc_marketing_medium_from VARCHAR2(30) := FND_API.G_MISS_CHAR,
29 * marketing_medium_id NUMBER := FND_API.G_MISS_NUM,
30 * custom_setup_id NUMBER := FND_API.G_MISS_NUM,
31 * triggerable_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
32 * trigger_id NUMBER := FND_API.G_MISS_NUM,
33 * notify_user_id NUMBER := FND_API.G_MISS_NUM,
34 * approver_user_id NUMBER := FND_API.G_MISS_NUM,
35 * owner_user_id NUMBER := FND_API.G_MISS_NUM,
36 * active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
37 * cover_letter_id NUMBER := FND_API.G_MISS_NUM,
38 * reply_to_mail VARCHAR2(120) := FND_API.G_MISS_CHAR,
39 * mail_sender_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
40 * mail_subject VARCHAR2(240) := FND_API.G_MISS_CHAR,
41 * from_fax_no VARCHAR2(25) := FND_API.G_MISS_CHAR,
42 * accounts_closed_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
43 * org_id NUMBER := FND_API.G_MISS_NUM,
44 * objective_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
45 * country_id NUMBER := FND_API.G_MISS_NUM,
46 * campaign_calendar VARCHAR2(20) := FND_API.G_MISS_CHAR,
47 * start_period_name VARCHAR2(15) := FND_API.G_MISS_CHAR,
48 * end_period_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
49 * priority VARCHAR2(30) := FND_API.G_MISS_CHAR,
50 * workflow_item_key VARCHAR2(240) := FND_API.G_MISS_CHAR,
51 * transaction_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
52 * functional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
53 * budget_amount_tc NUMBER := FND_API.G_MISS_NUM,
54 * budget_amount_fc NUMBER := FND_API.G_MISS_NUM,
55 * language_code VARCHAR2(4) := FND_API.G_MISS_CHAR,
56 * task_id NUMBER := FND_API.G_MISS_NUM,
57 * related_event_from VARCHAR2(30) := FND_API.G_MISS_CHAR,
58 * related_event_id NUMBER := FND_API.G_MISS_NUM,
59 * attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
60 * attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
61 * attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
62 * attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
63 * attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
64 * attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
65 * attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
66 * attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
67 * attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
68 * attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69 * attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70 * attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71 * attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72 * attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73 * attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74 * attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75 * activity_attribute_category VARCHAR2(240) := FND_API.G_MISS_CHAR,
76 * activity_attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77 * activity_attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78 * activity_attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79 * activity_attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80 * activity_attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81 * activity_attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82 * activity_attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83 * activity_attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84 * activity_attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85 * activity_attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86 * activity_attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87 * activity_attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88 * activity_attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89 * activity_attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90 * activity_attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91 * schedule_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
92 * description VARCHAR2(4000):= FND_API.G_MISS_CHAR,
93 * related_source_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
94 * related_source_object VARCHAR2(30) := FND_API.G_MISS_CHAR,
95 * related_source_id NUMBER := FND_API.G_MISS_NUM,
96 * query_id NUMBER := FND_API.G_MISS_NUM,
97 * include_content_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
98 * content_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
99 * test_email_address VARCHAR2(250):= FND_API.G_MISS_CHAR,
100 * greeting_text VARCHAR2(4000):= FND_API.G_MISS_CHAR,
101 * footer_text VARCHAR2(4000):= FND_API.G_MISS_CHAR,
102 * trig_repeat_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
103 * tgrp_exclude_prev_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
104 * orig_csch_id NUMBER := FND_API.G_MISS_NUM,
105 * cover_letter_version NUMBER := FND_API.G_MISS_NUM,
106 * usage VARCHAR2(30) := FND_API.G_MISS_CHAR,
107 * purpose VARCHAR2(30) := FND_API.G_MISS_CHAR,
108 * last_activation_date DATE := FND_API.G_MISS_DATE,
109 * sales_methodology_id NUMBER := FND_API.G_MISS_NUM,
110 * printer_address VARCHAR2(255) := FND_API.G_MISS_CHAR,
111 * notify_on_activation_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
112 * delivery_mode VARCHAR2(30) := FND_API.G_MISS_CHAR
113 * )
114 *
115 * @rep:scope public
116 * @rep:product AMS
117 * @rep:lifecycle active
118 * @rep:displayname Oracle Marketing Campaign Schedules Public API
119 * @rep:compatibility S
120 * @rep:category BUSINESS_ENTITY AMS_CAMPAIGN
121 */
122
123 -- ===============================================================
124 -- Start of Comments
125 -- Package name
126 -- AMS_Camp_Schedule_PUB
127 -- Purpose
128 --
129 -- History
130 -- ptendulk Created
131 -- 18-May-2001 soagrawa Modified schedule_rec_type according to
132 -- the latest amsvschs.pls
133 -- 22-May-2001 soagrawa Added parameter p_validation_level to
134 -- the create, update, delete and validate apis
135 -- 19-jul-2001 ptendulk Added columns for eBlast
136 -- 24-sep-2001 soagrawa Removed security group id from everywhere
137 -- 02-dec-2002 dbiswas NOCOPY and debug-level changes for performance
138 -- 27-jun-2003 anchaudh Added 4 new fields(columns) in the schedule_rec_type
139 -- 25-aug-2003 dbiswas Added 1 new field(sales_methodology_id) in the schedule_rec_type
140 -- 29-May-2006 srivikri added column delivery_mode
141 -- NOTE
142 --
143 -- End of Comments
144 -- ===============================================================
145
146 -- Default number of records fetch per call
147 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
148 --===================================================================
149 -- Start of Comments
150 -- -------------------------------------------------------
151 -- Record name
152 -- schedule_rec_type
153 -- -------------------------------------------------------
154 -- Parameters:
155 -- row_id
156 -- schedule_id
157 -- last_update_date
158 -- last_updated_by
159 -- creation_date
160 -- created_by
161 -- last_update_login
162 -- object_version_number
163 -- campaign_id
164 -- user_status_id
165 -- status_code
166 -- status_date
167 -- source_code
168 -- use_parent_code_flag
169 -- start_date_time
170 -- end_date_time
171 -- timezone_id
172 -- activity_type_code
173 -- activity_id
174 -- arc_marketing_medium_from
175 -- marketing_medium_id
176 -- custom_setup_id
177 -- triggerable_flag
178 -- trigger_id
179 -- notify_user_id
180 -- approver_user_id
181 -- owner_user_id
182 -- active_flag
183 -- cover_letter_id
184 -- reply_to_mail
185 -- mail_sender_name
186 -- mail_subject
187 -- from_fax_no
188 -- accounts_closed_flag
189 -- org_id
190 -- objective_code
191 -- country_id
192 -- start_period_name
193 -- end_period_name
194 -- priority
195 -- workflow_item_key
196 -- attribute_category
197 -- attribute1
198 -- attribute2
199 -- attribute3
200 -- attribute4
201 -- attribute5
202 -- attribute6
203 -- attribute7
204 -- attribute8
205 -- attribute9
206 -- attribute10
207 -- attribute11
208 -- attribute12
209 -- attribute13
210 -- attribute14
211 -- attribute15
212 -- activity_attribute_category
213 -- activity_attribute1
214 -- activity_attribute2
215 -- activity_attribute3
216 -- activity_attribute4
217 -- activity_attribute5
218 -- activity_attribute6
219 -- activity_attribute7
220 -- activity_attribute8
221 -- activity_attribute9
222 -- activity_attribute10
223 -- activity_attribute11
224 -- activity_attribute12
225 -- activity_attribute13
226 -- activity_attribute14
227 -- activity_attribute15
228 -- security_group_id
229 -- schedule_name
230 -- description
231 -- trig_repeat_flag
232 -- tgrp_exclude_prev_flag
233 -- orig_csch_id
234 -- cover_letter_version
235 -- usage
236 -- purpose
237 -- last_activation_date
238 -- sales_methodology_id
239 -- notify_on_activation_flag
240 -- delivery_mode
241 -- Required
242 --
243 -- Defaults
244 --
245 -- Note: This is automatic generated record definition, it includes all columns
246 -- defined in the table, developer must manually add or delete some of the attributes.
247 --
248 -- End of Comments
249
250 --===================================================================
251 TYPE schedule_rec_type IS RECORD
252 (
253 schedule_id NUMBER := FND_API.G_MISS_NUM,
254 last_update_date DATE := FND_API.G_MISS_DATE,
255 last_updated_by NUMBER := FND_API.G_MISS_NUM,
256 creation_date DATE := FND_API.G_MISS_DATE,
257 created_by NUMBER := FND_API.G_MISS_NUM,
258 last_update_login NUMBER := FND_API.G_MISS_NUM,
259 object_version_number NUMBER := FND_API.G_MISS_NUM,
260 campaign_id NUMBER := FND_API.G_MISS_NUM,
261 user_status_id NUMBER := FND_API.G_MISS_NUM,
262 status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
263 status_date DATE := FND_API.G_MISS_DATE,
264 source_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
265 use_parent_code_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
266 start_date_time DATE := FND_API.G_MISS_DATE,
267 end_date_time DATE := FND_API.G_MISS_DATE,
268 timezone_id NUMBER := FND_API.G_MISS_NUM,
269 activity_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
270 activity_id NUMBER := FND_API.G_MISS_NUM,
271 arc_marketing_medium_from VARCHAR2(30) := FND_API.G_MISS_CHAR,
272 marketing_medium_id NUMBER := FND_API.G_MISS_NUM,
273 custom_setup_id NUMBER := FND_API.G_MISS_NUM,
274 triggerable_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
275 trigger_id NUMBER := FND_API.G_MISS_NUM,
276 notify_user_id NUMBER := FND_API.G_MISS_NUM,
277 approver_user_id NUMBER := FND_API.G_MISS_NUM,
278 owner_user_id NUMBER := FND_API.G_MISS_NUM,
279 active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
280 cover_letter_id NUMBER := FND_API.G_MISS_NUM,
281 reply_to_mail VARCHAR2(120) := FND_API.G_MISS_CHAR,
282 mail_sender_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
283 mail_subject VARCHAR2(240) := FND_API.G_MISS_CHAR,
284 from_fax_no VARCHAR2(25) := FND_API.G_MISS_CHAR,
285 accounts_closed_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
286 org_id NUMBER := FND_API.G_MISS_NUM,
287 objective_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
288 country_id NUMBER := FND_API.G_MISS_NUM,
289 campaign_calendar VARCHAR2(20) := FND_API.G_MISS_CHAR,
290 start_period_name VARCHAR2(15) := FND_API.G_MISS_CHAR,
291 end_period_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
292 priority VARCHAR2(30) := FND_API.G_MISS_CHAR,
293 workflow_item_key VARCHAR2(240) := FND_API.G_MISS_CHAR,
294 transaction_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
295 functional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
296 budget_amount_tc NUMBER := FND_API.G_MISS_NUM,
297 budget_amount_fc NUMBER := FND_API.G_MISS_NUM,
301 related_event_id NUMBER := FND_API.G_MISS_NUM,
298 language_code VARCHAR2(4) := FND_API.G_MISS_CHAR,
299 task_id NUMBER := FND_API.G_MISS_NUM,
300 related_event_from VARCHAR2(30) := FND_API.G_MISS_CHAR,
302 attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
303 attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
304 attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
305 attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
306 attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
307 attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
308 attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
309 attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
310 attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
311 attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
312 attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
313 attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
314 attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
315 attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
316 attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
317 attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
318 activity_attribute_category VARCHAR2(240) := FND_API.G_MISS_CHAR,
319 activity_attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
320 activity_attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
321 activity_attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
322 activity_attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
323 activity_attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
324 activity_attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
325 activity_attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
326 activity_attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
327 activity_attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
328 activity_attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
329 activity_attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
330 activity_attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
331 activity_attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
332 activity_attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
333 activity_attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
334 -- removed by soagrawa on 24-sep-2001
335 -- security_group_id NUMBER := FND_API.G_MISS_NUM,
336 schedule_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
337 description VARCHAR2(4000):= FND_API.G_MISS_CHAR,
338 related_source_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
339 related_source_object VARCHAR2(30) := FND_API.G_MISS_CHAR,
340 related_source_id NUMBER := FND_API.G_MISS_NUM,
341 query_id NUMBER := FND_API.G_MISS_NUM,
342 include_content_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
343 content_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
344 test_email_address VARCHAR2(250):= FND_API.G_MISS_CHAR,
345 greeting_text VARCHAR2(4000):= FND_API.G_MISS_CHAR,
346 footer_text VARCHAR2(4000):= FND_API.G_MISS_CHAR,
347 --following are added by anchaudh on 27-jun-2003
348 trig_repeat_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
349 tgrp_exclude_prev_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
350 orig_csch_id NUMBER := FND_API.G_MISS_NUM,
351 cover_letter_version NUMBER := FND_API.G_MISS_NUM,
352 --following are added by dbiswas on 12-aug-2003
353 usage VARCHAR2(30) := FND_API.G_MISS_CHAR,
354 purpose VARCHAR2(30) := FND_API.G_MISS_CHAR,
355 last_activation_date DATE := FND_API.G_MISS_DATE,
356 sales_methodology_id NUMBER := FND_API.G_MISS_NUM,
357 printer_address VARCHAR2(255) := FND_API.G_MISS_CHAR,
358 notify_on_activation_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
359 sender_display_name VARCHAR2(240) := FND_API.G_MISS_CHAR,--anchaudh
360 asn_group_id VARCHAR2(240) := FND_API.G_MISS_CHAR,--anchaudh for leads bug
361 delivery_mode VARCHAR2(30) := FND_API.G_MISS_CHAR
362 );
363
364 g_miss_schedule_rec schedule_rec_type;
365 TYPE schedule_tbl_type IS TABLE OF schedule_rec_type INDEX BY BINARY_INTEGER;
366 g_miss_schedule_tbl schedule_tbl_type;
367
368 TYPE schedule_sort_rec_type IS RECORD
369 (
370 -- Please define your own sort by record here.
371 schedule_id NUMBER := NULL
372 );
373
374
375
376 -- ==============================================================================
377 -- Start of Comments
378 -- ==============================================================================
379 -- API Name
380 -- Create_Camp_Schedule
384 --
381 -- Type
382 -- Public
383 -- Pre-Req
385 -- Parameters
386 --
387 -- IN
388 -- p_api_version_number IN NUMBER Required
389 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
390 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
391 -- p_schedule_rec IN schedule_rec_type Required
392 --
393 -- OUT
394 -- x_return_status OUT VARCHAR2
395 -- x_msg_count OUT NUMBER
396 -- x_msg_data OUT VARCHAR2
397 -- Version : Current version 1.0
398 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
399 -- and basic operation, developer must manually add parameters and business logic as necessary.
400 --
401 -- End of Comments
402 -- ==============================================================================
403 --
404
405 /*#
406 * This procedure creates a marketing campaign schedule. The details of the campaign schedule
407 * will be passed in the p_schedule_rec record type. Check the x_return_status output to
408 * see if creation was successful. If successful, a unique identifier for the schedule object
409 * will be passed back to the x_schedule_id output parameter.
410 *
411 * @param p_api_version_number This must match the version number of the API. An unexepcted error is returned if the calling program version number is incompatible with the current API version number.
412 * @param p_init_msg_list Flag to indicate if the message stack should be initialized.
413 * @param p_commit Flag to indicate if changes should be comitted on success.
414 * @param p_validation_level Level of validation required. None: No validation will be performed. Full: Item and record level validation will be performed.
415 * @param p_schedule_rec Record of type AMS_Camp_Schedule_PUB.schedule_rec_type that takes in the details for the Campaign Schedule.
416 * @param x_return_status Indicates the return status of the API. The values are one of the following:
417 * FND_API.G_RET_STS_SUCCESS: Indicates the API call was successful;
418 * FND_API.G_RET_STS_ERROR: Indicates there was a validation error or a missing data error;
419 * FND_API.G_RET_STS_UNEXP_ERROR: Indicates the calling program encountered an unxpected or unhandled error.
420 * @param x_msg_count Count of error messages in the message list.
421 * @param x_msg_data Error messages returned by the API. If more than one message is returned, this parameter is null and messages must be extracted from the message stack.
422 * @param x_schedule_id Unique identifier for the newly created Campaign Schedule.
423 * @rep:scope public
427 PROCEDURE Create_Camp_Schedule(
424 * @rep:lifecycle active
425 * @rep:displayname Create Marketing Campaign Schedule
426 */
428 p_api_version_number IN NUMBER,
429 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
430 p_commit IN VARCHAR2 := FND_API.G_FALSE,
431 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
432 x_return_status OUT NOCOPY VARCHAR2,
433 x_msg_count OUT NOCOPY NUMBER,
434 x_msg_data OUT NOCOPY VARCHAR2,
435
436 p_schedule_rec IN schedule_rec_type := g_miss_schedule_rec,
437 x_schedule_id OUT NOCOPY NUMBER
438 );
439
440
441
442 -- ==============================================================================
443 -- Start of Comments
444 -- ==============================================================================
445 -- API Name
446 -- Update_Camp_Schedule
447 -- Type
448 -- Public
449 -- Pre-Req
450 --
451 -- Parameters
452 --
453 -- IN
454 -- p_api_version_number IN NUMBER Required
455 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
456 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
457 -- p_schedule_rec IN schedule_rec_type Required
458 --
459 -- OUT
460 -- x_return_status OUT VARCHAR2
461 -- x_msg_count OUT NUMBER
462 -- x_msg_data OUT VARCHAR2
463 -- Version : Current version 1.0
464 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
465 -- and basic operation, developer must manually add parameters and business logic as necessary.
466 --
467 -- End of Comments
468 -- ==============================================================================
469 --
470
471 /*#
472 * This procedure updates a marketing campaign schedule. The details of the campaign schedule
473 * will be passed in the p_schedule_rec record type. Check the x_return_status output to
474 * see if the update was successful. If successful, the updated schedule object's new object
475 * version number will be passed back in x_object_version_number output parameter.
476 *
477 * @param p_api_version_number This must match the version number of the API. An unexepcted error is returned if the calling program version number is incompatible with the current API version number.
478 * @param p_init_msg_list Flag to indicate if the message stack should be initialized.
479 * @param p_commit Flag to indicate if changes should be comitted on success.
480 * @param p_validation_level Level of validation required. None: No validation will be performed. Full: Item and record level validation will be performed.
481 * @param p_schedule_rec Record of type AMS_Camp_Schedule_PUB.schedule_rec_type that takes in the details for the Campaign Schedule.
482 * @param x_return_status Indicates the return status of the API. The values are one of the following:
483 * FND_API.G_RET_STS_SUCCESS: Indicates the API call was successful
484 * FND_API.G_RET_STS_ERROR: Indicates there was a validation error or a missing data error
485 * FND_API.G_RET_STS_UNEXP_ERROR: Indicates the calling program encountered an unxpected or unhandled error.
486 * @param x_msg_count Count of error messages in the message list.
487 * @param x_msg_data Error messages returned by the API. If more than one message is returned, this parameter is null and messages must be extracted from the message stack.
488 * @param x_object_version_number Object version number of the updated campaign schedule
489 * @rep:scope public
490 * @rep:lifecycle active
491 * @rep:displayname Update Marketing Campaign Schedule
492 */
493
494 PROCEDURE Update_Camp_Schedule(
495 p_api_version_number IN NUMBER,
496 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
497 p_commit IN VARCHAR2 := FND_API.G_FALSE,
498 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
499 x_return_status OUT NOCOPY VARCHAR2,
500 x_msg_count OUT NOCOPY NUMBER,
501 x_msg_data OUT NOCOPY VARCHAR2,
502
503 p_schedule_rec IN schedule_rec_type,
504 x_object_version_number OUT NOCOPY NUMBER
505 );
506
507
508
509 -- ==============================================================================
510 -- Start of Comments
511 -- ==============================================================================
512 -- API Name
513 -- Delete_Camp_Schedule
514 -- Type
515 -- Public
516 -- Pre-Req
517 --
518 -- Parameters
519 --
520 -- IN
521 -- p_api_version_number IN NUMBER Required
522 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
523 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
524 -- p_SCHEDULE_ID IN NUMBER
525 -- p_object_version_number IN NUMBER Optional Default = NULL
526 --
527 -- OUT
528 -- x_return_status OUT VARCHAR2
529 -- x_msg_count OUT NUMBER
530 -- x_msg_data OUT VARCHAR2
531 -- Version : Current version 1.0
532 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
533 -- and basic operation, developer must manually add parameters and business logic as necessary.
534 --
535 -- End of Comments
536 -- ==============================================================================
537 --
538
539 PROCEDURE Delete_Camp_Schedule(
543 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
540 p_api_version_number IN NUMBER,
541 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
542 p_commit IN VARCHAR2 := FND_API.G_FALSE,
544 x_return_status OUT NOCOPY VARCHAR2,
545 x_msg_count OUT NOCOPY NUMBER,
546 x_msg_data OUT NOCOPY VARCHAR2,
547 p_schedule_id IN NUMBER,
548 p_object_version_number IN NUMBER
549 );
550
551 -- ==============================================================================
552 -- Start of Comments
553 -- ==============================================================================
554 -- API Name
555 -- Lock_Camp_Schedule
556 -- Type
557 -- Public
558 -- Pre-Req
559 --
560 -- Parameters
561 --
562 -- IN
563 -- p_api_version_number IN NUMBER Required
564 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
565 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
566 -- p_schedule_rec IN schedule_rec_type Required
567 --
568 -- OUT
569 -- x_return_status OUT VARCHAR2
570 -- x_msg_count OUT NUMBER
571 -- x_msg_data OUT VARCHAR2
572 -- Version : Current version 1.0
573 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
574 -- and basic operation, developer must manually add parameters and business logic as necessary.
575 --
576 -- End of Comments
577 -- ==============================================================================
578 --
579
580 PROCEDURE Lock_Camp_Schedule(
581 p_api_version_number IN NUMBER,
582 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
583 x_return_status OUT NOCOPY VARCHAR2,
584 x_msg_count OUT NOCOPY NUMBER,
585 x_msg_data OUT NOCOPY VARCHAR2,
586
587 p_schedule_id IN NUMBER,
588 p_object_version IN NUMBER
589 );
590
591 ---------------------------------------------------------------------
592 -- PROCEDURE
593 -- Validate_Camp_Schedule
594 --
595 -- PURPOSE
596 -- Validate a schedule record.
597 --
598 -- PARAMETERS
599 -- p_schedule_rec: the campaign record to be validated
600 --
601 -- NOTES
602 -- 1. p_schedule_rec should be the complete schedule record. There
603 -- should not be any FND_API.g_miss_char/num/date in it.
604 ----------------------------------------------------------------------
605 PROCEDURE Validate_Camp_Schedule(
606 p_api_version IN NUMBER,
607 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
608 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
609 x_return_status OUT NOCOPY VARCHAR2,
610 x_msg_count OUT NOCOPY NUMBER,
611 x_msg_data OUT NOCOPY VARCHAR2,
612 p_validation_mode IN VARCHAR2,
613 p_schedule_rec IN schedule_rec_type
614 );
615
616 ---------------------------------------------------------------------
617 -- PROCEDURE
618 -- Copy_Camp_Schedule
619 --
620 -- PURPOSE
621 -- copy a schedule record and its attributes
622 --
623 -- HISTORY
624 -- 18-SEP-2001 soagrawa Added, refer to bug# 2000042
625 ----------------------------------------------------------------------
626
627 PROCEDURE Copy_Camp_Schedule(
628 p_api_version IN NUMBER,
629 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
630 p_commit IN VARCHAR2 := FND_API.G_FALSE,
631 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
632
633 x_return_status OUT NOCOPY VARCHAR2,
634 x_msg_count OUT NOCOPY NUMBER,
635 x_msg_data OUT NOCOPY VARCHAR2,
636
637 p_source_object_id IN NUMBER,
638 p_attributes_table IN ams_cpyutility_pvt.copy_attributes_table_type,
639 p_copy_columns_table IN ams_cpyutility_pvt.copy_columns_table_type,
640
641 x_new_object_id OUT NOCOPY NUMBER,
642 x_custom_setup_id OUT NOCOPY NUMBER
643 );
644
645
646
647
648 END AMS_Camp_Schedule_PUB;