[Home] [Help]
PACKAGE: APPS.IEC_ADMIN_PVT
Source
1 PACKAGE IEC_ADMIN_PVT AS
2 /* $Header: IECADMS.pls 120.1 2005/06/16 09:10:45 appldev $ */
3
4
5
6
7
8 TYPE TG_ENTRY_CURSOR is REF CURSOR;
9
10
11
12
13
14 -- ===============================================================
15
16 -- Start of Comments
17
18 -- Package name
19
20 -- IEC_ADMIN_PVT
21
22 -- Purpose
23
24 -- To provide easy to use apis for IEC Admin.
25
26 -- History
27
28 -- 30-Apr-2001 msista Created.
29
30 -- 09-Jul-2001 gpagadal Modified.
31
32 -- 02-Jul-2001 gpagadal Fields added.
33
34 -- 03-Jul-2001 gpagadal Procedure added
35
36 -- NOTE
37
38 --
39
40 -- End of Comments
41
42 -- ===============================================================
43
44
45
46 -- ===============================================================
47
48 -- Start of Comments
49
50 -- ===============================================================
51
52 -- API Name
53
54 -- Update_Camp_Schedule
55
56 -- Type
57
58 -- Private
59
60 -- Pre-Req
61
62 --
63
64 -- Parameters
65
66 --
67
68 -- IN
69
70 --
71
72 -- p_campaign_schedule_id IN NUMBER Required
73
74 -- p_dialing_method IN VARCHAR2 Required (CTI disabled)
75
76 -- p_calendar_id IN NUMBER Required
77
78 -- p_abandon_limit IN NUMBER Required
79
80 -- p_user_id IN NUMBER Required
81
82 -- p_predictive_timeout IN NUMBER, Required
83
84 -- p_user_status_id IN NUMBER, Required
85
86
87
88 --
89
90 -- OUT
91
92 -- x_msg_data OUT VARCHAR2
93
94 -- x_return_value OUT NUMBER 1 for success, 0 otherwise.
95
96 --
97
98 -- End of Comments
99
100 -- ===============================================================
101
102 --
103
104 PROCEDURE Update_Camp_Schedule(
105
106
107
108 p_campaign_schedule_id IN NUMBER,
109
110 p_dialing_method IN VARCHAR2,
111
112 p_calendar_id IN NUMBER,
113
114 p_abandon_limit IN NUMBER,
115
116
117
118 p_predictive_timeout IN NUMBER,
119
120 p_user_status_id IN NUMBER,
121
122
123
124
125
126 p_user_id IN NUMBER,
127
128
129
130 x_msg_data OUT NOCOPY VARCHAR2,
131
132 x_return_value OUT NOCOPY NUMBER
133
134
135
136 );
137
138
139
140
141
142
143
144
145
146 -- ===============================================================
147
148 -- Start of Comments
149
150 -- ===============================================================
151
152 -- API Name
153
154 -- Update_List_DialingMethod
155
156 -- Type
157
158 -- Private
159
160 -- Pre-Req
161
162 --
163
164 -- Parameters
165
166 --
167
168 -- IN
169
170 --
171
172 -- p_campaign_schedule_id IN NUMBER Required
173
174 -- p_dialing_method IN VARCHAR2 Required (CTI disabled)
175
176 -- p_user_id IN NUMBER Required
177
178 --
179
180 -- OUT
181
182 -- x_msg_data OUT VARCHAR2
183
184 -- x_return_value OUT NUMBER 1 for success, 0 otherwise.
185
186 --
187
188 -- End of Comments
189
190 -- ===============================================================
191
192 --
193
194 PROCEDURE Update_List_DialingMethod(
195
196
197
198 p_campaign_schedule_id IN NUMBER,
199
200
201
202 p_dialing_method IN VARCHAR2,
203
204
205
206 p_user_id IN NUMBER,
207
208
209
210 x_msg_data OUT NOCOPY VARCHAR2,
211
212 x_return_value OUT NOCOPY NUMBER
213
214
215
216 );
217
218
219
220 -- ===============================================================
221
222 -- Start of Comments
223
224 -- ===============================================================
225
226 -- API Name
227
228 -- Update_List_Header
229
230 -- Type
231
232 -- Private
233
234 -- Pre-Req
235
236 --
237
238 -- Parameters
239
240 --
241
242 -- IN
243
244 --
245
246 -- p_list_header_id IN NUMBER Required
247
248 -- p_dialing_method IN VARCHAR2 Required
249
250 -- p_list_priority IN NUMBER Required
251
252 -- p_recycling_alg_id IN NUMBER Required
253
254 -- p_release_control_alg_id IN NUMBER Required
255
256 -- p_calendar_id IN NUMBER Required
257
258 -- p_release_strategy IN VARCHAR2 Required
259
260 -- p_quantum IN NUMBER Required
261
262 -- p_quota IN NUMBER Optional Default = null
263
264 -- p_quota_reset IN NUMBER Optional Default = null
265
266 -- p_user_id IN NUMBER Required
267
268 --
269
270 -- OUT
271
272 -- x_msg_data OUT VARCHAR2
273
274 -- x_return_value OUT NUMBER 1 for success, 0 otherwise.
275
276 --
277
278 -- Version : Current version 1.0
279
280 --
281
282 -- End of Comments
283
284 -- ===============================================================
285
286 --
287
288 PROCEDURE Update_List_Header(
289
290 p_list_header_id IN NUMBER,
291
292 p_dialing_method IN VARCHAR2,
293
294 p_list_priority IN NUMBER,
295
296 p_recycling_alg_id IN NUMBER,
297
298 p_release_control_alg_id IN NUMBER,
299
300 p_calendar_id IN NUMBER,
301
302 p_release_strategy IN VARCHAR2,
303
304 p_quantum IN NUMBER,
305
306 p_quota IN NUMBER := null,
307
308 p_quota_reset IN NUMBER := null,
309
310
311
312 p_user_id IN NUMBER,
313
314
315
316 x_msg_data OUT NOCOPY VARCHAR2,
317
318 x_return_value OUT NOCOPY NUMBER
319
320 );
321
322
323
324 -- ===============================================================
325
326 -- Start of Comments
327
328 -- ===============================================================
329
330 -- API Name
331
332 -- Delete_List_Subset
333
334 -- Type
335
336 -- Private
337
338 -- Pre-Req
339
340 --
341
342 -- Parameters
343
344 --
345
346 -- IN
347
348 -- p_list_subset_id IN NUMBER Required
349
350 -- p_user_id IN NUMBER Required
351
352 --
353
354 -- OUT
355
356 -- x_msg_data OUT VARCHAR2
357
358 -- x_return_value OUT NUMBER 1 for success, 0 otherwise.
359
360 --
361
362 -- Version : Current version 1.0
363
364 --
365
366 -- End of Comments
367
368 -- ===============================================================
369
370 --
371
372 PROCEDURE Delete_List_Subset(
373
374 p_list_subset_id IN NUMBER,
375
376 p_user_id IN NUMBER,
377
378 x_msg_data OUT NOCOPY VARCHAR2,
379
380 x_return_value OUT NOCOPY NUMBER
381
382 );
383
384
385
386
387
388
389
390 -- ===============================================================
391
392 -- Start of Comments
393
394 -- ===============================================================
395
396 -- API Name
397
398 -- GET_TG_ENTRY_LIST
399
400 --
401
402 -- Used by Target Group Entry List Page to show the list
403
404 -- of entries belonging to a certain target group.
405
406 -- This procedure also gathers data for the page header and footer.
407
408 --
409
410 -- Type: Private
411
412 --
413
414 -- Parameters
415
416 -- IN
417
418 -- P_LIST_HEADER_ID IN NUMBER
419
420 -- , P_SEARCH_COLUMN IN VARCHAR2
421
422 -- , P_SEARCH_OPERATOR IN VARCHAR2
423
424 -- , P_SEARCH_PARAM IN VARCHAR2
425
426 -- , P_ORDER_BY IN NUMBER
427
428 -- , P_NEXT_ROW IN NUMBER
429
430 -- , P_MAX_ROWS IN NUMBER
431
432 -- , P_ORDER IN VARCHAR2
433
434 --
435
436 -- OUT
437
438 -- X_HEADER_DATA OUT NOCOPY TG_ENTRY_CURSOR
439
440 -- , X_CONTACT_POINT_DATA OUT NOCOPY TG_ENTRY_CURSOR
441
442 -- , X_TOTAL_ENTRIES OUT NUMBER
443
444 --
445
446 -- Version : Current version 1.0
447
448 --
449
450 -- End of Comments
451
452 -- ===============================================================
453
454 PROCEDURE GET_TG_ENTRY_LIST
455
456 ( P_LIST_HEADER_ID IN NUMBER
457
458 , P_SEARCH_COLUMN IN VARCHAR2
459
460 , P_SEARCH_OPERATOR IN VARCHAR2
461
462 , P_SEARCH_PARAM IN VARCHAR2
463
464 , P_ORDER_BY IN NUMBER
465
466 , P_NEXT_ROW IN NUMBER
467
468 , P_MAX_ROWS IN NUMBER
469
470 , P_ORDER IN VARCHAR2
471
472 , X_HEADER_DATA OUT NOCOPY TG_ENTRY_CURSOR
473
474 , X_ENTRY_DATA OUT NOCOPY TG_ENTRY_CURSOR
475
476 , X_TOTAL_ENTRIES OUT NOCOPY NUMBER );
477
478
479
480 -- ===============================================================
481
482 -- Start of Comments
483
484 -- ===============================================================
485
486 -- API Name
487
488 -- GET_TG_ENTRY_DETAILS
489
490 --
491
492 -- Used by Target Group Entry Details Page to show the details
493
494 -- (including contact points) belonging to a certain entry.
495
496 -- This procedure also gathers data for the page header.
497
498 -- A list of timezones is also displayed on the page; their
499
500 -- translations are fetched here.
501
502 --
503
504 -- Type: Private
505
506 --
507
508 -- Parameters
509
510 -- IN
511
512 -- P_LIST_HEADER_ID IN NUMBER
513
514 -- , P_LIST_ENTRY_ID IN NUMBER
515
516 -- , P_LANGUAGE IN VARCHAR2
517
518 --
519
520 -- OUT
521
522 -- , X_HEADER_DATA OUT NOCOPY TG_ENTRY_CURSOR
523
524 -- , X_CONTACT_POINT_DATA OUT NOCOPY TG_ENTRY_CURSOR
525
526 -- , X_TIME_ZONE_DATA OUT NOCOPY TG_ENTRY_CURSOR
527
528 --
529
530 -- Version : Current version 1.0
531
532 --
533
534 -- End of Comments
535
536 -- ===============================================================
537
538 PROCEDURE GET_TG_ENTRY_DETAILS
539
540 ( P_LIST_HEADER_ID IN NUMBER
541
542 , P_LIST_ENTRY_ID IN NUMBER
543
544 , P_LANGUAGE IN VARCHAR2
545
546 , X_HEADER_DATA OUT NOCOPY TG_ENTRY_CURSOR
547
548 , X_CONTACT_POINT_DATA OUT NOCOPY TG_ENTRY_CURSOR
549
550 , X_TIME_ZONE_DATA OUT NOCOPY TG_ENTRY_CURSOR );
551
552
553 -- ===============================================================
554
555 -- Start of Comments
556
557 -- ===============================================================
558
559 -- API Name
560
561 -- Copy_Calendar_Day
562
563 -- Type
564
565 -- Private
566
567 -- Pre-Req
568
569 --
570
571 -- Parameters
572
573 --
574
575 -- IN
576
577 -- p_calendar_id IN NUMBER,
578 -- p_day_id IN NUMBER,
579 -- p_copyto_code IN VARCHAR2,
580 -- p_createdBy IN NUMBER,
581 -- p_creationDate IN DATE,
582 -- p_updatedBy IN NUMBER,
583 -- p_updateDate IN DATE,
584 -- p_updateLogin IN NUMBER,
585 -- p_versionNumber IN NUMBER
586
587 -- Version : Current version 1.0
588
589 --
590
591 -- End of Comments
592
593 -- ===============================================================
594
595 --
596
597 PROCEDURE Copy_Calendar_Day(
598
599 p_calendar_id IN NUMBER,
600 p_day_id IN NUMBER,
601 p_copyto_code IN VARCHAR2,
602 p_createdBy IN NUMBER,
603 p_creationDate IN DATE,
604 p_updatedBy IN NUMBER,
605 p_updateDate IN DATE,
606 p_updateLogin IN NUMBER,
607 p_versionNumber IN NUMBER
608 );
609
610
611
612
613 END IEC_Admin_PVT;
614