[Home] [Help]
PACKAGE: APPS.AMS_CAMP_SCHEDULE_PVT
Source
1 PACKAGE AMS_Camp_Schedule_PVT AS
2 /* $Header: amsvschs.pls 120.4 2006/05/31 11:41:04 srivikri ship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- AMS_Camp_Schedule_PVT
7 -- Purpose
8 -- Business api spec for Schedule
9 -- History
10 -- 22-Jan-2001 ptendulk Created.
11 -- 04-Mar-2001 ptendulk Added Additional parameters for Budget Amount, related event task
12 -- 12-APR-2001 julou Added 3 fields to schedule_rec_type for related source code
13 -- 09-oct-2001 soagrawa Removed security-group id related code from everywhere
14 -- 02-dec-2002 dbiswas NOCOPY and debug-level changes for performance
15 -- 27-jun-2003 anchaudh Added 4 new fields(columns) in the schedule_rec_type
16 -- 12-aug-2003 dbiswas Added 3 new columns for schedule_rec_type
17 -- 25-aug-2003 dbiswas Added 1 new column sales_methodology_id
18 -- 29-May-2006 srivikri added column delivery_mode
19
20 -- NOTE
21 --
22 -- End of Comments
23 -- ===============================================================
24
25
26 -- Default number of records fetch per call
27 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
28 --===================================================================
29 -- Start of Comments
30 -- -------------------------------------------------------
31 -- Record name
32 -- schedule_rec_type
33 -- -------------------------------------------------------
34 -- Parameters:
35 -- schedule_id
36 -- last_update_date
37 -- last_updated_by
38 -- creation_date
39 -- created_by
40 -- last_update_login
41 -- object_version_number
42 -- campaign_id
43 -- user_status_id
44 -- status_code
45 -- status_date
46 -- source_code
47 -- use_parent_code_flag
48 -- start_date_time
49 -- end_date_time
50 -- timezone_id
51 -- activity_type_code
52 -- activity_id
53 -- arc_marketing_medium_from
54 -- marketing_medium_id
55 -- custom_setup_id
56 -- triggerable_flag
57 -- trigger_id
58 -- notify_user_id
59 -- approver_user_id
60 -- owner_user_id
61 -- active_flag
62 -- cover_letter_id
63 -- reply_to_mail
64 -- mail_sender_name
65 -- mail_subject
66 -- from_fax_no
67 -- accounts_closed_flag
68 -- org_id
69 -- objective_code
70 -- country_id
71 -- campaign_calendar
72 -- start_period_name
73 -- end_period_name
74 -- priority
75 -- workflow_item_key
76 -- transaction_currency_code
77 -- functional_currency_code
78 -- budget_amount_tc
79 -- budget_amount_fc
80 -- language_code
81 -- task_id
82 -- related_event_from
83 -- related_event_id
84 -- attribute_category
85 -- attribute1
86 -- attribute2
87 -- attribute3
88 -- attribute4
89 -- attribute5
90 -- attribute6
91 -- attribute7
92 -- attribute8
93 -- attribute9
94 -- attribute10
95 -- attribute11
96 -- attribute12
97 -- attribute13
98 -- attribute14
99 -- attribute15
100 -- activity_attribute_category
101 -- activity_attribute1
102 -- activity_attribute2
103 -- activity_attribute3
104 -- activity_attribute4
105 -- activity_attribute5
106 -- activity_attribute6
107 -- activity_attribute7
108 -- activity_attribute8
109 -- activity_attribute9
110 -- activity_attribute10
111 -- activity_attribute11
112 -- activity_attribute12
113 -- activity_attribute13
114 -- activity_attribute14
115 -- activity_attribute15
116 -- security_group_id
117 -- trig_repeat_flag
118 -- tgrp_exclude_prev_flag
119 -- orig_csch_id
120 -- cover_letter_version
121 -- usage
122 -- purpose
123 -- last_activation_date
124 -- sales_methodology_id
125 -- notify_on_activation_flag
126 -- delivery_mode
127 -- Required
128 --
129 -- Defaults
130 --
131 -- Note: This is automatic generated record definition, it includes all columns
132 -- defined in the table, developer must manually add or delete some of the attributes.
133 --
134 -- End of Comments
135
136 --===================================================================
137 TYPE schedule_rec_type IS RECORD
138 (
139 schedule_id NUMBER := FND_API.G_MISS_NUM,
140 last_update_date DATE := FND_API.G_MISS_DATE,
141 last_updated_by NUMBER := FND_API.G_MISS_NUM,
142 creation_date DATE := FND_API.G_MISS_DATE,
143 created_by NUMBER := FND_API.G_MISS_NUM,
144 last_update_login NUMBER := FND_API.G_MISS_NUM,
145 object_version_number NUMBER := FND_API.G_MISS_NUM,
146 campaign_id NUMBER := FND_API.G_MISS_NUM,
147 user_status_id NUMBER := FND_API.G_MISS_NUM,
148 status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
149 status_date DATE := FND_API.G_MISS_DATE,
150 source_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
151 use_parent_code_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
152 start_date_time DATE := FND_API.G_MISS_DATE,
153 end_date_time DATE := FND_API.G_MISS_DATE,
154 timezone_id NUMBER := FND_API.G_MISS_NUM,
155 activity_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
156 activity_id NUMBER := FND_API.G_MISS_NUM,
157 arc_marketing_medium_from VARCHAR2(30) := FND_API.G_MISS_CHAR,
158 marketing_medium_id NUMBER := FND_API.G_MISS_NUM,
159 custom_setup_id NUMBER := FND_API.G_MISS_NUM,
160 triggerable_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
161 trigger_id NUMBER := FND_API.G_MISS_NUM,
162 notify_user_id NUMBER := FND_API.G_MISS_NUM,
163 approver_user_id NUMBER := FND_API.G_MISS_NUM,
164 owner_user_id NUMBER := FND_API.G_MISS_NUM,
165 active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
166 cover_letter_id NUMBER := FND_API.G_MISS_NUM,
167 reply_to_mail VARCHAR2(120) := FND_API.G_MISS_CHAR,
168 mail_sender_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
169 mail_subject VARCHAR2(240) := FND_API.G_MISS_CHAR,
170 from_fax_no VARCHAR2(25) := FND_API.G_MISS_CHAR,
171 accounts_closed_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
172 org_id NUMBER := FND_API.G_MISS_NUM,
173 objective_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
174 country_id NUMBER := FND_API.G_MISS_NUM,
175 campaign_calendar VARCHAR2(20) := FND_API.G_MISS_CHAR,
176 start_period_name VARCHAR2(15) := FND_API.G_MISS_CHAR,
177 end_period_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
178 priority VARCHAR2(30) := FND_API.G_MISS_CHAR,
179 workflow_item_key VARCHAR2(240) := FND_API.G_MISS_CHAR,
180 transaction_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
181 functional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
182 budget_amount_tc NUMBER := FND_API.G_MISS_NUM,
183 budget_amount_fc NUMBER := FND_API.G_MISS_NUM,
184 language_code VARCHAR2(4) := FND_API.G_MISS_CHAR,
185 task_id NUMBER := FND_API.G_MISS_NUM,
186 related_event_from VARCHAR2(30) := FND_API.G_MISS_CHAR,
187 related_event_id NUMBER := FND_API.G_MISS_NUM,
188 attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
189 attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
190 attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
191 attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
192 attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
193 attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
194 attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
195 attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
196 attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
197 attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
198 attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
199 attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
200 attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
201 attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
202 attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
203 attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
204 activity_attribute_category VARCHAR2(240) := FND_API.G_MISS_CHAR,
205 activity_attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
206 activity_attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
207 activity_attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
208 activity_attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
209 activity_attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
210 activity_attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
211 activity_attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
212 activity_attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
213 activity_attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
214 activity_attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
215 activity_attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
216 activity_attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
217 activity_attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
218 activity_attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
219 activity_attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
220 -- security_group_id NUMBER := FND_API.G_MISS_NUM,
221 schedule_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
222 description VARCHAR2(4000):= FND_API.G_MISS_CHAR,
223 related_source_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
224 related_source_object VARCHAR2(30) := FND_API.G_MISS_CHAR,
225 related_source_id NUMBER := FND_API.G_MISS_NUM,
226 query_id NUMBER := FND_API.G_MISS_NUM,
227 include_content_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
228 content_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
229 test_email_address VARCHAR2(250) := FND_API.G_MISS_CHAR,
230 greeting_text VARCHAR2(4000):= FND_API.G_MISS_CHAR,
231 footer_text VARCHAR2(4000):= FND_API.G_MISS_CHAR,
232 -- following are added by anchaudh on 27-jun-2003
233 trig_repeat_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
234 tgrp_exclude_prev_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
235 orig_csch_id NUMBER := FND_API.G_MISS_NUM,
236 cover_letter_version NUMBER := FND_API.G_MISS_NUM,
237 -- added by dbiswas on Aug12, 2003
238 usage VARCHAR2(30) := FND_API.G_MISS_CHAR,
239 purpose VARCHAR2(30) := FND_API.G_MISS_CHAR,
240 last_activation_date DATE := FND_API.G_MISS_DATE,
241 sales_methodology_id NUMBER := FND_API.G_MISS_NUM,
242 printer_address VARCHAR2(255) := FND_API.G_MISS_CHAR,
243 notify_on_activation_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
244 sender_display_name VARCHAR2(240) := FND_API.G_MISS_CHAR,--anchaudh
245 asn_group_id VARCHAR2(240) := FND_API.G_MISS_CHAR,--anchaudh for leads bug
246 delivery_mode VARCHAR2(30) := FND_API.G_MISS_CHAR
247 );
248
249 g_miss_schedule_rec schedule_rec_type;
250 TYPE schedule_tbl_type IS TABLE OF schedule_rec_type INDEX BY BINARY_INTEGER;
251 g_miss_schedule_tbl schedule_tbl_type;
252
253 -- ==============================================================================
254 -- Start of Comments
255 -- ==============================================================================
256 -- API Name
257 -- Create_Camp_Schedule
258 -- Type
259 -- Private
260 -- Pre-Req
261 --
262 -- Parameters
263 --
264 -- IN
265 -- p_api_version_number IN NUMBER Required
266 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
267 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
268 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
269 -- p_schedule_rec IN schedule_rec_type Required
270 --
271 -- OUT
272 -- x_return_status OUT VARCHAR2
273 -- x_msg_count OUT NUMBER
274 -- x_msg_data OUT VARCHAR2
275 -- Version : Current version 1.0
276 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
277 -- and basic operation, developer must manually add parameters and business logic as necessary.
278 --
279 -- End of Comments
280 -- ==============================================================================
281 --
282
283 PROCEDURE Create_Camp_Schedule(
284 p_api_version_number IN NUMBER,
285 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
286 p_commit IN VARCHAR2 := FND_API.G_FALSE,
287 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
288
289 x_return_status OUT NOCOPY VARCHAR2,
290 x_msg_count OUT NOCOPY NUMBER,
291 x_msg_data OUT NOCOPY VARCHAR2,
292
293 p_schedule_rec IN schedule_rec_type := g_miss_schedule_rec,
294 x_schedule_id OUT NOCOPY NUMBER
295 );
296
297 -- ==============================================================================
298 -- Start of Comments
299 -- ==============================================================================
300 -- API Name
301 -- Update_Camp_Schedule
302 -- Type
303 -- Private
304 -- Pre-Req
305 --
306 -- Parameters
307 --
308 -- IN
309 -- p_api_version_number IN NUMBER Required
310 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
311 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
312 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
313 -- p_schedule_rec IN schedule_rec_type Required
314 --
315 -- OUT
316 -- x_return_status OUT VARCHAR2
317 -- x_msg_count OUT NUMBER
318 -- x_msg_data OUT VARCHAR2
319 -- Version : Current version 1.0
320 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
321 -- and basic operation, developer must manually add parameters and business logic as necessary.
322 --
323 -- End of Comments
324 -- ==============================================================================
325 --
326
327 PROCEDURE Update_Camp_Schedule(
328 p_api_version_number IN NUMBER,
329 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
330 p_commit IN VARCHAR2 := FND_API.G_FALSE,
331 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
332
336
333 x_return_status OUT NOCOPY VARCHAR2,
334 x_msg_count OUT NOCOPY NUMBER,
335 x_msg_data OUT NOCOPY VARCHAR2,
337 p_schedule_rec IN schedule_rec_type,
338 x_object_version_number OUT NOCOPY NUMBER
339 );
340
341 -- ==============================================================================
342 -- Start of Comments
343 -- ==============================================================================
344 -- API Name
345 -- Delete_Camp_Schedule
346 -- Type
347 -- Private
348 -- Pre-Req
349 --
350 -- Parameters
351 --
352 -- IN
353 -- p_api_version_number IN NUMBER Required
354 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
355 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
356 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
357 -- p_SCHEDULE_ID IN NUMBER
358 -- p_object_version_number IN NUMBER Optional Default = NULL
359 --
360 -- OUT
361 -- x_return_status OUT VARCHAR2
362 -- x_msg_count OUT NUMBER
363 -- x_msg_data OUT VARCHAR2
364 -- Version : Current version 1.0
365 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
366 -- and basic operation, developer must manually add parameters and business logic as necessary.
367 --
368 -- End of Comments
369 -- ==============================================================================
370 --
371
372 PROCEDURE Delete_Camp_Schedule(
373 p_api_version_number IN NUMBER,
374 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
375 p_commit IN VARCHAR2 := FND_API.G_FALSE,
376 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
377 x_return_status OUT NOCOPY VARCHAR2,
378 x_msg_count OUT NOCOPY NUMBER,
379 x_msg_data OUT NOCOPY VARCHAR2,
380 p_schedule_id IN NUMBER,
381 p_object_version_number IN NUMBER
382 );
383
384 -- ==============================================================================
385 -- Start of Comments
386 -- ==============================================================================
387 -- API Name
388 -- Lock_Camp_Schedule
389 -- Type
390 -- Private
391 -- Pre-Req
392 --
393 -- Parameters
394 --
395 -- IN
396 -- p_api_version_number IN NUMBER Required
397 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
398 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
399 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
400 -- p_schedule_rec IN schedule_rec_type Required
401 --
402 -- OUT
403 -- x_return_status OUT VARCHAR2
404 -- x_msg_count OUT NUMBER
405 -- x_msg_data OUT VARCHAR2
406 -- Version : Current version 1.0
407 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
408 -- and basic operation, developer must manually add parameters and business logic as necessary.
409 --
410 -- End of Comments
411 -- ==============================================================================
412 --
413
414 PROCEDURE Lock_Camp_Schedule(
415 p_api_version_number IN NUMBER,
416 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
417
418 x_return_status OUT NOCOPY VARCHAR2,
419 x_msg_count OUT NOCOPY NUMBER,
420 x_msg_data OUT NOCOPY VARCHAR2,
421
422 p_schedule_id IN NUMBER,
423 p_object_version IN NUMBER
424 );
425
426
427 -- Start of Comments
428 --
429 -- validation procedures
430 --
431 -- p_validation_mode is a constant defined in AMS_UTILITY_PVT package
432 -- For create: G_CREATE, for update: G_UPDATE
433 -- Note: 1. This is automated generated item level validation procedure.
434 -- The actual validation detail is needed to be added.
435 -- 2. We can also validate table instead of record. There will be an option for user to choose.
436 -- End of Comments
437
438 PROCEDURE Validate_camp_schedule(
439 p_api_version_number IN NUMBER,
440 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
441 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
442 p_schedule_rec IN schedule_rec_type,
443 p_validation_mode IN VARCHAR2,
444 x_return_status OUT NOCOPY VARCHAR2,
445 x_msg_count OUT NOCOPY NUMBER,
446 x_msg_data OUT NOCOPY VARCHAR2
447 );
448
449 -- Start of Comments
450 --
451 -- validation procedures
452 --
453 -- p_validation_mode is a constant defined in AMS_UTILITY_PVT package
457 -- 2. Validate the unique keys, lookups here
454 -- For create: G_CREATE, for update: G_UPDATE
455 -- Note: 1. This is automated generated item level validation procedure.
456 -- The actual validation detail is needed to be added.
458 -- End of Comments
459
460 PROCEDURE Check_schedule_Items (
461 P_schedule_rec IN schedule_rec_type,
462 p_validation_mode IN VARCHAR2,
463 x_return_status OUT NOCOPY VARCHAR2
464 );
465
466 -- Start of Comments
467 --
468 -- Record level validation procedures
469 --
470 -- p_validation_mode is a constant defined in AMS_UTILITY_PVT package
471 -- For create: G_CREATE, for update: G_UPDATE
472 -- Note: 1. This is automated generated item level validation procedure.
473 -- The actual validation detail is needed to be added.
474 -- 2. Developer can manually added inter-field level validation.
475 -- End of Comments
476
477 PROCEDURE Validate_schedule_rec(
478 p_api_version_number IN NUMBER,
479 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
480 x_return_status OUT NOCOPY VARCHAR2,
481 x_msg_count OUT NOCOPY NUMBER,
482 x_msg_data OUT NOCOPY VARCHAR2,
483 p_schedule_rec IN schedule_rec_type
484 );
485
486 --===================================================================
487 -- NAME
488 -- Check_Schedule_Inter_Entity
489 --
490 -- PURPOSE
491 -- Inter Entitiy validations for schedules.
492 --
493 -- NOTES
494 --
495 -- HISTORY
496 -- 22-Jan-2001 PTENDULK Created
497 --===================================================================
498 PROCEDURE Check_Schedule_Inter_Entity( p_schedule_rec IN schedule_rec_type,
499 p_complete_rec IN schedule_rec_type,
503 --===================================================================
500 p_validation_mode IN VARCHAR2,
501 x_return_status OUT NOCOPY VARCHAR2
502 ) ;
504 -- NAME
505 -- Init_schedule_rec
506 --
507 -- PURPOSE
508 -- Initialize schedules rec, used for testing.
509 --
510 -- NOTES
511 --
512 --
513 -- HISTORY
514 -- 22-Jan-2001 PTENDULK Created
515 --===================================================================
516 PROCEDURE Init_Schedule_Rec(x_schedule_rec OUT NOCOPY schedule_rec_type) ;
517
518 --===================================================================
519 -- NAME
520 -- Complete_schedule_Rec
521 --
522 -- PURPOSE
523 -- Private api to complete rec for Campaign schedules.
524 --
525 -- NOTES
526 --
527 -- HISTORY
528 -- 22-Jan-2001 PTENDULK Created
529 --===================================================================
530 PROCEDURE Complete_schedule_Rec (
531 P_schedule_rec IN schedule_rec_type,
532 x_complete_rec OUT NOCOPY schedule_rec_type
533 );
534
535
536 -- ==============================================================================
537 -- Start of Comments
538 -- ==============================================================================
539 -- API Name
540 -- Copy_Camp_Schedule
541 --
542 -- Description
543 -- To support the "Copy Schedule" functionality from the schedule overview
544 -- and detail pages.
545 --
546 -- History
547 -- 30-Apr-2001 soagrawa Created this procedure
548 --
549 --
550 -- ==============================================================================
551 --
552
553 PROCEDURE Copy_Camp_Schedule(
554 p_api_version IN NUMBER,
555 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
556 p_commit IN VARCHAR2 := FND_API.G_FALSE,
557 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
558
559 x_return_status OUT NOCOPY VARCHAR2,
560 x_msg_count OUT NOCOPY NUMBER,
561 x_msg_data OUT NOCOPY VARCHAR2,
562
563 p_source_object_id IN NUMBER,
564 p_attributes_table IN AMS_CpyUtility_PVT.copy_attributes_table_type,
565 p_copy_columns_table IN AMS_CpyUtility_PVT.copy_columns_table_type,
566
567 x_new_object_id OUT NOCOPY NUMBER,
568 x_custom_setup_id OUT NOCOPY NUMBER
569 );
570
571
572 END AMS_Camp_Schedule_PVT;