1 PACKAGE amv_channel_grp AUTHID CURRENT_USER AS
2 /* $Header: amvgchas.pls 120.1 2005/06/22 16:14:08 appldev ship $ */
3 --
4 -- NAME
5 -- AMV_CHANNEL_GRP
6 -- PURPOSE
7 --
8 -- HISTORY
9 -- 01/29/2000 SLKRISHN CREATED
10 --
11 --
12 -- This package contains the following procedures
13 --
14 --------------------------------------------------------------------------------
15 --------------------------------------------------------------------------------
16 -- Start of comments
17 -- API name : Add_PublicChannel
18 -- Type : Private
19 -- Pre-reqs : None
20 -- Function : Create a new content public channel
21 -- Parameters :
22 -- IN p_api_version IN NUMBER Required
23 -- p_init_msg_list IN VARCHAR2 Optional
24 -- Default = FND_API.G_FALSE
25 -- p_commit IN VARCHAR2 Optional
26 -- Default = FND_API.G_FALSE
27 -- p_validation_level IN NUMBER Optional
28 -- Default = FND_API.G_VALID_LEVEL_FULL
29 -- p_channel_record IN AMV_CHANNEL_OBJ_TYPE Required
30 -- OUT : x_return_status OUT VARCHAR2
31 -- x_msg_count OUT NUMBER
32 -- x_msg_data OUT VARCHAR2
33 -- x_channel_id OUT NUMBER
34 -- Version : Current version 1.0
35 -- Previous version 1.0
36 -- Initial version 1.0
37 -- Notes :
38 --
39 -- End of comments
40 --
41 PROCEDURE Add_PublicChannel
42 ( p_api_version IN NUMBER,
43 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
44 p_commit IN VARCHAR2 := FND_API.G_FALSE,
45 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
46 x_return_status OUT NOCOPY VARCHAR2,
47 x_msg_count OUT NOCOPY NUMBER,
48 x_msg_data OUT NOCOPY VARCHAR2,
49 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
50 p_channel_record IN AMV_CHANNEL_PVT.AMV_CHANNEL_OBJ_TYPE,
51 x_channel_id OUT NOCOPY NUMBER
52 );
53 --------------------------------------------------------------------------------
54 -- Start of comments
55 -- API name : Add_ProtectedChannel
56 -- Type : Private
57 -- Pre-reqs : None
58 -- Function : Create a new content protected channel
59 -- Parameters :
60 -- IN p_api_version IN NUMBER Required
61 -- p_init_msg_list IN VARCHAR2 Optional
62 -- Default = FND_API.G_FALSE
63 -- p_commit IN VARCHAR2 Optional
64 -- Default = FND_API.G_FALSE
65 -- p_validation_level IN NUMBER Optional
66 -- Default = FND_API.G_VALID_LEVEL_FULL
67 -- p_channel_record IN AMV_CHANNEL_OBJ_TYPE Required
68 -- OUT : x_return_status OUT VARCHAR2
69 -- x_msg_count OUT NUMBER
70 -- x_msg_data OUT VARCHAR2
71 -- x_channel_id OUT NUMBER
72 -- Version : Current version 1.0
73 -- Previous version 1.0
74 -- Initial version 1.0
75 -- Notes :
76 --
77 -- End of comments
78 --
79 PROCEDURE Add_ProtectedChannel
80 ( p_api_version IN NUMBER,
81 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
82 p_commit IN VARCHAR2 := FND_API.G_FALSE,
83 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
84 x_return_status OUT NOCOPY VARCHAR2,
85 x_msg_count OUT NOCOPY NUMBER,
86 x_msg_data OUT NOCOPY VARCHAR2,
87 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
88 p_channel_record IN AMV_CHANNEL_PVT.AMV_CHANNEL_OBJ_TYPE,
89 x_channel_id OUT NOCOPY NUMBER
90 );
91 --------------------------------------------------------------------------------
92 -- Start of comments
93 -- API name : Add_PrivateChannel
94 -- Type : Private
95 -- Pre-reqs : None
96 -- Function : Create a new content private channel
97 -- Parameters :
98 -- IN p_api_version IN NUMBER Required
99 -- p_init_msg_list IN VARCHAR2 Optional
100 -- Default = FND_API.G_FALSE
101 -- p_commit IN VARCHAR2 Optional
102 -- Default = FND_API.G_FALSE
103 -- p_validation_level IN NUMBER Optional
104 -- Default = FND_API.G_VALID_LEVEL_FULL
105 -- p_channel_record IN AMV_CHANNEL_OBJ_TYPE Required
106 -- OUT : x_return_status OUT VARCHAR2
107 -- x_msg_count OUT NUMBER
108 -- x_msg_data OUT VARCHAR2
109 -- x_channel_id OUT NUMBER
110 -- Version : Current version 1.0
111 -- Previous version 1.0
112 -- Initial version 1.0
113 -- Notes :
114 --
115 -- End of comments
116 --
117 PROCEDURE Add_PrivateChannel
118 ( p_api_version IN NUMBER,
119 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
120 p_commit IN VARCHAR2 := FND_API.G_FALSE,
121 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
122 x_return_status OUT NOCOPY VARCHAR2,
123 x_msg_count OUT NOCOPY NUMBER,
124 x_msg_data OUT NOCOPY VARCHAR2,
125 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
126 p_channel_record IN AMV_CHANNEL_PVT.AMV_CHANNEL_OBJ_TYPE,
127 x_channel_id OUT NOCOPY NUMBER
128 );
129 --------------------------------------------------------------------------------
130 -- Start of comments
131 -- API name : Add_GroupChannel
132 -- Type : Private
133 -- Pre-reqs : None
134 -- Function : Create a new content protected channel
135 -- Parameters :
136 -- IN p_api_version IN NUMBER Required
137 -- p_init_msg_list IN VARCHAR2 Optional
138 -- Default = FND_API.G_FALSE
139 -- p_commit IN VARCHAR2 Optional
140 -- Default = FND_API.G_FALSE
141 -- p_validation_level IN NUMBER Optional
142 -- Default = FND_API.G_VALID_LEVEL_FULL
143 -- p_channel_record IN AMV_CHANNEL_OBJ_TYPE Required
144 -- OUT : x_return_status OUT VARCHAR2
145 -- x_msg_count OUT NUMBER
146 -- x_msg_data OUT VARCHAR2
147 -- x_channel_id OUT NUMBER
148 -- Version : Current version 1.0
149 -- Previous version 1.0
150 -- Initial version 1.0
151 -- Notes :
152 --
153 -- End of comments
154 --
155 PROCEDURE Add_GroupChannel
156 ( p_api_version IN NUMBER,
157 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
158 p_commit IN VARCHAR2 := FND_API.G_FALSE,
159 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
160 x_return_status OUT NOCOPY VARCHAR2,
161 x_msg_count OUT NOCOPY NUMBER,
162 x_msg_data OUT NOCOPY VARCHAR2,
163 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
164 p_group_id IN NUMBER,
165 p_channel_record IN AMV_CHANNEL_PVT.AMV_CHANNEL_OBJ_TYPE,
166 x_channel_id OUT NOCOPY NUMBER
167 );
168 --------------------------------------------------------------------------------
169 -- Start of comments
170 -- API name : Delete_Channel
171 -- Type : Private
172 -- Pre-reqs : None
173 -- Function : Delete the content channel given p_channel_id/p_channel_name
174 -- Parameters :
175 -- IN p_api_version IN NUMBER Required
176 -- p_init_msg_list IN VARCHAR2 Optional
177 -- Default = FND_API.G_FALSE
178 -- p_commit IN VARCHAR2 Optional
179 -- Default = FND_API.G_FALSE
180 -- p_validation_level IN NUMBER Optional
181 -- Default = FND_API.G_VALID_LEVEL_FULL
182 -- p_channel_id IN NUMBER Optional
183 -- the channel id. Default = FND_API.G_MISS_NUM
184 -- p_channel_name IN VARCHAR2 Optional
185 -- the channel name. Default = FND_API.G_MISS_CHAR
186 -- Either pass the channe id (preferred) or channel name
187 -- to identify the channel.
188 -- p_category_id IN NUMBER Optional
189 -- the category id. Default = FND_API.G_MISS_NUM
190 -- OUT : x_return_status OUT VARCHAR2
191 -- x_msg_count OUT NUMBER
192 -- x_msg_data OUT VARCHAR2
193 -- Version : Current version 1.0
194 -- Previous version 1.0
195 -- Initial version 1.0
196 -- Notes :
197 --
198 -- End of comments
199 --
200 PROCEDURE Delete_Channel
201 ( p_api_version IN NUMBER,
202 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
203 p_commit IN VARCHAR2 := FND_API.G_FALSE,
204 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
205 x_return_status OUT NOCOPY VARCHAR2,
206 x_msg_count OUT NOCOPY NUMBER,
207 x_msg_data OUT NOCOPY VARCHAR2,
208 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
209 p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
210 p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
211 p_category_id IN NUMBER := FND_API.G_MISS_NUM
212 );
213 --------------------------------------------------------------------------------
214 -- Start of comments
215 -- API name : Update_Channel
216 -- Type : Private
217 -- Pre-reqs : None
218 -- Function : Change the channel given by
219 -- (channel) id or name in p_channel_record
220 -- New data are specified in other members of p_channel_record
221 -- Parameters :
222 -- IN p_api_version IN NUMBER Required
223 -- p_init_msg_list IN VARCHAR2 Optional
224 -- Default = FND_API.G_FALSE
225 -- p_commit IN VARCHAR2 Optional
226 -- Default = FND_API.G_FALSE
227 -- p_validation_level IN NUMBER Optional
228 -- Default = FND_API.G_VALID_LEVEL_FULL
229 -- p_channel_record IN AMV_CHANNEL_OBJ_TYPE Required
230 -- OUT : x_return_status OUT VARCHAR2
231 -- x_msg_count OUT NUMBER
232 -- x_msg_data OUT VARCHAR2
233 -- Version : Current version 1.0
234 -- Previous version 1.0
235 -- Initial version 1.0
236 -- Notes :
237 --
238 -- End of comments
239 --
240 PROCEDURE Update_Channel
241 ( p_api_version IN NUMBER,
242 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
243 p_commit IN VARCHAR2 := FND_API.G_FALSE,
244 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
245 x_return_status OUT NOCOPY VARCHAR2,
246 x_msg_count OUT NOCOPY NUMBER,
247 x_msg_data OUT NOCOPY VARCHAR2,
248 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
249 p_channel_record IN AMV_CHANNEL_PVT.AMV_CHANNEL_OBJ_TYPE
250 );
251 --------------------------------------------------------------------------------
252 -- Start of comments
253 -- API name : Get_Channel
254 -- Type : Private
255 -- Pre-reqs : None
256 -- Function : Get the channel attributes of channel given by
257 -- channel id (preferred) or channel name.
258 -- Parameters :
259 -- IN p_api_version IN NUMBER Required
260 -- p_init_msg_list IN VARCHAR2 Optional
261 -- Default = FND_API.G_FALSE
262 -- p_validation_level IN NUMBER Optional
263 -- Default = FND_API.G_VALID_LEVEL_FULL
264 -- p_channel_id IN NUMBER Optional
265 -- the channel id. Default = FND_API.G_MISS_NUM
266 -- p_channel_name IN VARCHAR2 Optional
267 -- the channel name. Default = FND_API.G_MISS_CHAR
268 -- Either pass the channe id (preferred) or channel name
269 -- to identify the channel.
270 -- p_category_id IN NUMBER Optional
271 -- the category id. Default = FND_API.G_MISS_NUM
272 -- OUT : x_return_status OUT VARCHAR2
273 -- x_msg_count OUT NUMBER
274 -- x_msg_data OUT VARCHAR2
275 -- x_channel_record OUT AMV_CHANNEL_OBJ_TYPE
276 -- Version : Current version 1.0
277 -- Previous version 1.0
278 -- Initial version 1.0
279 -- Notes :
280 --
281 -- End of comments
282 --
283 PROCEDURE Get_Channel
284 ( p_api_version IN NUMBER,
285 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
286 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
287 x_return_status OUT NOCOPY VARCHAR2,
288 x_msg_count OUT NOCOPY NUMBER,
289 x_msg_data OUT NOCOPY VARCHAR2,
293 p_category_id IN NUMBER := FND_API.G_MISS_NUM,
290 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
291 p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
292 p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
294 x_channel_record OUT NOCOPY AMV_CHANNEL_PVT.AMV_CHANNEL_OBJ_TYPE
295 );
296 --------------------------------------------------------------------------------
297 -- Start of comments
298 -- API name : Set_ChannelContentTypes
299 -- Type : Private
300 -- Pre-reqs : None
301 -- Function : Change content categories of the content channel.
302 -- Parameters :
303 -- IN p_api_version IN NUMBER Required
304 -- p_init_msg_list IN VARCHAR2 Optional
305 -- Default = FND_API.G_FALSE
306 -- p_commit IN VARCHAR2 Optional
307 -- Default = FND_API.G_FALSE
308 -- p_validation_level NUMBER Optional
309 -- Default = FND_API.G_VALID_LEVEL_FULL
310 -- p_channel_id IN NUMBER Optional
311 -- the channel id. Default = FND_API.G_MISS_NUM
312 -- p_channel_name IN VARCHAR2 Optional
313 -- the channel name. Default = FND_API.G_MISS_CHAR
314 -- Either pass the channe id (preferred) or channel name
315 -- to identify the channel.
316 -- p_category_id IN NUMBER Optional
317 -- the category id. Default = FND_API.G_MISS_NUM
318 -- p_content_type_id_array IN AMV_NUMBER_VARRAY_TYPE
319 -- OUT : x_return_status OUT VARCHAR2
320 -- x_msg_count OUT NUMBER
321 -- x_msg_data OUT VARCHAR2
322 -- Version : Current version 1.0
323 -- Previous version 1.0
324 -- Initial version 1.0
325 -- Notes :
326 --
327 -- End of comments
328 --
329 PROCEDURE Set_ChannelContentTypes
330 ( p_api_version IN NUMBER,
331 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
332 p_commit IN VARCHAR2 := FND_API.G_FALSE,
333 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
334 x_return_status OUT NOCOPY VARCHAR2,
335 x_msg_count OUT NOCOPY NUMBER,
336 x_msg_data OUT NOCOPY VARCHAR2,
337 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
338 p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
339 p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
340 p_category_id IN NUMBER := FND_API.G_MISS_NUM,
341 p_content_type_id_array IN AMV_CHANNEL_PVT.AMV_NUMBER_VARRAY_TYPE
342 );
346 -- Type : Private
343 --------------------------------------------------------------------------------
344 -- Start of comments
345 -- API name : Get_ChannelContentTypes
347 -- Pre-reqs : None
348 -- Function : Get content categories of the content channel.
349 -- Parameters :
350 -- IN p_api_version IN NUMBER Required
351 -- p_init_msg_list IN VARCHAR2 Optional
352 -- Default = FND_API.G_FALSE
353 -- p_validation_level NUMBER Optional
354 -- Default = FND_API.G_VALID_LEVEL_FULL
355 -- p_channel_id IN NUMBER Optional
356 -- the channel id. Default = FND_API.G_MISS_NUM
357 -- p_channel_name IN VARCHAR2 Optional
358 -- the channel name. Default = FND_API.G_MISS_CHAR
359 -- Either pass the channe id (preferred) or channel name
360 -- to identify the channel.
361 -- p_category_id IN NUMBER Optional
362 -- the category id. Default = FND_API.G_MISS_NUM
363 -- OUT : x_return_status OUT VARCHAR2
364 -- x_msg_count OUT NUMBER
365 -- x_msg_data OUT VARCHAR2
366 -- x_content_type_id_array OUT AMV_NUMBER_VARRAY_TYPE
367 -- Version : Current version 1.0
368 -- Previous version 1.0
369 -- Initial version 1.0
370 -- Notes :
371 --
372 -- End of comments
373 --
374 PROCEDURE Get_ChannelContentTypes
375 ( p_api_version IN NUMBER,
376 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
377 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
378 x_return_status OUT NOCOPY VARCHAR2,
379 x_msg_count OUT NOCOPY NUMBER,
380 x_msg_data OUT NOCOPY VARCHAR2,
381 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
382 p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
383 p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
384 p_category_id IN NUMBER := FND_API.G_MISS_NUM,
385 x_content_type_id_array OUT NOCOPY AMV_CHANNEL_PVT.AMV_NUMBER_VARRAY_TYPE
386 );
387 --------------------------------------------------------------------------------
388 -- Start of comments
389 -- API name : Set_ChannelPerspectives
390 -- Type : Private
391 -- Pre-reqs : None
392 -- Function : Change perspectives of the content channel.
393 -- Parameters :
394 -- IN p_api_version IN NUMBER Required
395 -- p_init_msg_list IN VARCHAR2 Optional
396 -- Default = FND_API.G_FALSE
397 -- p_commit IN VARCHAR2 Optional
398 -- Default = FND_API.G_FALSE
399 -- p_validation_level NUMBER Optional
400 -- Default = FND_API.G_VALID_LEVEL_FULL
401 -- p_channel_id IN NUMBER Optional
402 -- the channel id. Default = FND_API.G_MISS_NUM
403 -- p_channel_name IN VARCHAR2 Optional
404 -- the channel name. Default = FND_API.G_MISS_CHAR
405 -- Either pass the channe id (preferred) or channel name
406 -- to identify the channel.
407 -- p_category_id IN NUMBER Optional
408 -- the category id. Default = FND_API.G_MISS_NUM
409 -- p_perspective_id_array IN AMV_NUMBER_VARRAY_TYPE
410 -- OUT : x_return_status OUT VARCHAR2
411 -- x_msg_count OUT NUMBER
412 -- x_msg_data OUT VARCHAR2
413 -- Version : Current version 1.0
414 -- Previous version 1.0
415 -- Initial version 1.0
416 -- Notes :
417 --
418 -- End of comments
419 --
420 PROCEDURE Set_ChannelPerspectives
421 ( p_api_version IN NUMBER,
422 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
423 p_commit IN VARCHAR2 := FND_API.G_FALSE,
424 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
425 x_return_status OUT NOCOPY VARCHAR2,
426 x_msg_count OUT NOCOPY NUMBER,
427 x_msg_data OUT NOCOPY VARCHAR2,
428 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
429 p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
430 p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
431 p_category_id IN NUMBER := FND_API.G_MISS_NUM,
432 p_perspective_id_array IN AMV_CHANNEL_PVT.AMV_NUMBER_VARRAY_TYPE
433 );
434 --------------------------------------------------------------------------------
435 -- Start of comments
436 -- API name : Get_ChannelPerspectives
437 -- Type : Private
438 -- Pre-reqs : None
439 -- Function : Get perspectives of the content channel.
440 -- Parameters :
441 -- IN p_api_version IN NUMBER Required
442 -- p_init_msg_list IN VARCHAR2 Optional
446 -- p_channel_id IN NUMBER Optional
443 -- Default = FND_API.G_FALSE
444 -- p_validation_level NUMBER Optional
445 -- Default = FND_API.G_VALID_LEVEL_FULL
447 -- the channel id. Default = FND_API.G_MISS_NUM
448 -- p_channel_name IN VARCHAR2 Optional
449 -- the channel name. Default = FND_API.G_MISS_CHAR
450 -- Either pass the channe id (preferred) or channel name
451 -- to identify the channel.
452 -- p_category_id IN NUMBER Optional
453 -- the category id. Default = FND_API.G_MISS_NUM
454 -- OUT : x_return_status OUT VARCHAR2
455 -- x_msg_count OUT NUMBER
456 -- x_msg_data OUT VARCHAR2
457 -- x_perspective_id_array OUT AMV_NUMBER_VARRAY_TYPE
458 -- Version : Current version 1.0
459 -- Previous version 1.0
460 -- Initial version 1.0
461 -- Notes :
462 --
463 -- End of comments
464 --
465 PROCEDURE Get_ChannelPerspectives
466 ( p_api_version IN NUMBER,
467 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
468 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
469 x_return_status OUT NOCOPY VARCHAR2,
470 x_msg_count OUT NOCOPY NUMBER,
471 x_msg_data OUT NOCOPY VARCHAR2,
472 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
473 p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
474 p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
475 p_category_id IN NUMBER := FND_API.G_MISS_NUM,
476 x_perspective_id_array OUT NOCOPY AMV_CHANNEL_PVT.AMV_NUMBER_VARRAY_TYPE
477 );
478 --------------------------------------------------------------------------------
479 -- Start of comments
480 -- API name : Set_ChannelItemTypes
481 -- Type : Private
482 -- Pre-reqs : None
483 -- Function : Change user groups of the content channel.
484 -- Parameters :
485 -- IN p_api_version IN NUMBER Required
486 -- p_init_msg_list IN VARCHAR2 Optional
487 -- Default = FND_API.G_FALSE
488 -- p_validation_level NUMBER Optional
489 -- Default = FND_API.G_VALID_LEVEL_FULL
490 -- p_commit IN VARCHAR2 Optional
491 -- Default = FND_API.G_FALSE
492 -- p_channel_id IN NUMBER Optional
493 -- the channel id. Default = FND_API.G_MISS_NUM
494 -- p_channel_name IN VARCHAR2 Optional
495 -- the channel name. Default = FND_API.G_MISS_CHAR
496 -- Either pass the channe id (preferred) or channel name
497 -- to identify the channel.
498 -- p_category_id IN NUMBER Optional
499 -- the category id. Default = FND_API.G_MISS_NUM
500 -- p_item_type_array IN AMV_CHAR_VARRAY_TYPE
501 -- OUT : x_return_status OUT VARCHAR2
502 -- x_msg_count OUT NUMBER
503 -- x_msg_data OUT VARCHAR2
504 -- Version : Current version 1.0
505 -- Previous version 1.0
506 -- Initial version 1.0
507 -- Notes :
508 --
509 -- End of comments
510 --
511 PROCEDURE Set_ChannelItemTypes
512 ( p_api_version IN NUMBER,
513 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
514 p_commit IN VARCHAR2 := FND_API.G_FALSE,
515 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
516 x_return_status OUT NOCOPY VARCHAR2,
517 x_msg_count OUT NOCOPY NUMBER,
518 x_msg_data OUT NOCOPY VARCHAR2,
519 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
520 p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
521 p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
522 p_category_id IN NUMBER := FND_API.G_MISS_NUM,
523 p_item_type_array IN AMV_CHANNEL_PVT.AMV_CHAR_VARRAY_TYPE
524 );
525 --------------------------------------------------------------------------------
526 -- Start of comments
527 -- API name : Get_ChannelItemTypes
528 -- Type : Private
529 -- Pre-reqs : None
530 -- Function : Get user groups of the content channel.
531 -- Parameters :
532 -- IN p_api_version IN NUMBER Required
533 -- p_init_msg_list IN VARCHAR2 Optional
534 -- Default = FND_API.G_FALSE
535 -- p_validation_level NUMBER Optional
536 -- Default = FND_API.G_VALID_LEVEL_FULL
537 -- p_channel_id IN NUMBER Optional
538 -- the channel id. Default = FND_API.G_MISS_NUM
539 -- p_channel_name IN VARCHAR2 Optional
540 -- the channel name. Default = FND_API.G_MISS_CHAR
541 -- Either pass the channe id (preferred) or channel name
545 -- OUT : x_return_status OUT VARCHAR2
542 -- to identify the channel.
543 -- p_category_id IN NUMBER Optional
544 -- the category id. Default = FND_API.G_MISS_NUM
546 -- x_msg_count OUT NUMBER
547 -- x_msg_data OUT VARCHAR2
548 -- x_item_type_array OUT AMV_CHAR_VARRAY_TYPE
549 -- Version : Current version 1.0
550 -- Previous version 1.0
551 -- Initial version 1.0
552 -- Notes :
553 --
554 -- End of comments
555 --
556 PROCEDURE Get_ChannelItemTypes
557 ( p_api_version IN NUMBER,
558 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
559 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
560 x_return_status OUT NOCOPY VARCHAR2,
561 x_msg_count OUT NOCOPY NUMBER,
562 x_msg_data OUT NOCOPY VARCHAR2,
563 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
564 p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
565 p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
566 p_category_id IN NUMBER := FND_API.G_MISS_NUM,
567 x_item_type_array OUT NOCOPY AMV_CHANNEL_PVT.AMV_CHAR_VARRAY_TYPE
568 );
569 --------------------------------------------------------------------------------
570 -- Start of comments
571 -- API name : Set_ChannelKeywords
572 -- Type : Private
573 -- Pre-reqs : None
574 -- Function : Change keywords of the content channel.
575 -- Parameters :
576 -- IN p_api_version IN NUMBER Required
577 -- p_init_msg_list IN VARCHAR2 Optional
578 -- Default = FND_API.G_FALSE
579 -- p_commit IN VARCHAR2 Optional
580 -- Default = FND_API.G_FALSE
581 -- p_validation_level NUMBER Optional
582 -- Default = FND_API.G_VALID_LEVEL_FULL
583 -- p_channel_id IN NUMBER Optional
584 -- the channel id. Default = FND_API.G_MISS_NUM
585 -- p_channel_name IN VARCHAR2 Optional
586 -- the channel name. Default = FND_API.G_MISS_CHAR
587 -- Either pass the channe id (preferred) or channel name
588 -- to identify the channel.
589 -- p_category_id IN NUMBER Optional
590 -- the category id. Default = FND_API.G_MISS_NUM
591 -- p_keywords_array IN AMV_CHAR_VARRAY_TYPE
592 -- OUT : x_return_status OUT VARCHAR2
593 -- x_msg_count OUT NUMBER
594 -- x_msg_data OUT VARCHAR2
595 -- Version : Current version 1.0
596 -- Previous version 1.0
597 -- Initial version 1.0
598 -- Notes :
599 --
600 -- End of comments
601 --
602 PROCEDURE Set_ChannelKeywords
603 ( p_api_version IN NUMBER,
604 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
605 p_commit IN VARCHAR2 := FND_API.G_FALSE,
606 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
607 x_return_status OUT NOCOPY VARCHAR2,
608 x_msg_count OUT NOCOPY NUMBER,
609 x_msg_data OUT NOCOPY VARCHAR2,
610 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
611 p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
612 p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
613 p_category_id IN NUMBER := FND_API.G_MISS_NUM,
614 p_keywords_array IN AMV_CHANNEL_PVT.AMV_CHAR_VARRAY_TYPE
615 );
616 --------------------------------------------------------------------------------
617 -- Start of comments
618 -- API name : Get_ChannelKeywords
619 -- Type : Private
620 -- Pre-reqs : None
621 -- Function : Get keywords of the content channel.
622 -- Parameters :
623 -- IN p_api_version IN NUMBER Required
624 -- p_init_msg_list IN VARCHAR2 Optional
625 -- Default = FND_API.G_FALSE
626 -- p_validation_level NUMBER Optional
627 -- Default = FND_API.G_VALID_LEVEL_FULL
628 -- p_channel_id IN NUMBER Optional
629 -- the channel id. Default = FND_API.G_MISS_NUM
630 -- p_channel_name IN VARCHAR2 Optional
631 -- the channel name. Default = FND_API.G_MISS_CHAR
632 -- Either pass the channe id (preferred) or channel name
633 -- to identify the channel.
634 -- p_category_id IN NUMBER Optional
635 -- the category id. Default = FND_API.G_MISS_NUM
636 -- OUT : x_return_status OUT VARCHAR2
637 -- x_msg_count OUT NUMBER
638 -- x_msg_data OUT VARCHAR2
639 -- x_keywords_array OUT AMV_CHAR_VARRAY_TYPE
640 -- Version : Current version 1.0
641 -- Previous version 1.0
645 -- End of comments
642 -- Initial version 1.0
643 -- Notes :
644 --
646 --
647 PROCEDURE Get_ChannelKeywords
648 ( p_api_version IN NUMBER,
649 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
650 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
651 x_return_status OUT NOCOPY VARCHAR2,
652 x_msg_count OUT NOCOPY NUMBER,
653 x_msg_data OUT NOCOPY VARCHAR2,
654 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
655 p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
656 p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
657 p_category_id IN NUMBER := FND_API.G_MISS_NUM,
658 x_keywords_array OUT NOCOPY AMV_CHANNEL_PVT.AMV_CHAR_VARRAY_TYPE
659 );
660 --------------------------------------------------------------------------------
661 -- Start of comments
662 -- API name : Set_ChannelAuthors
663 -- Type : Private
664 -- Pre-reqs : None
665 -- Function : Change authors of the content channel.
666 -- Parameters :
667 -- IN p_api_version IN NUMBER Required
668 -- p_init_msg_list IN VARCHAR2 Optional
669 -- Default = FND_API.G_FALSE
670 -- p_commit IN VARCHAR2 Optional
671 -- Default = FND_API.G_FALSE
672 -- p_validation_level NUMBER Optional
673 -- Default = FND_API.G_VALID_LEVEL_FULL
674 -- p_channel_id IN NUMBER Optional
675 -- the channel id. Default = FND_API.G_MISS_NUM
676 -- p_channel_name IN VARCHAR2 Optional
677 -- the channel name. Default = FND_API.G_MISS_CHAR
678 -- Either pass the channe id (preferred) or channel name
679 -- to identify the channel.
680 -- p_category_id IN NUMBER Optional
681 -- the category id. Default = FND_API.G_MISS_NUM
682 -- p_authors_array IN AMV_CHAR_VARRAY_TYPE
683 -- OUT : x_return_status OUT VARCHAR2
684 -- x_msg_count OUT NUMBER
685 -- x_msg_data OUT VARCHAR2
686 -- Version : Current version 1.0
687 -- Previous version 1.0
688 -- Initial version 1.0
689 -- Notes :
690 --
691 -- End of comments
692 --
693 PROCEDURE Set_ChannelAuthors
694 ( p_api_version IN NUMBER,
695 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
696 p_commit IN VARCHAR2 := FND_API.G_FALSE,
697 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
698 x_return_status OUT NOCOPY VARCHAR2,
699 x_msg_count OUT NOCOPY NUMBER,
700 x_msg_data OUT NOCOPY VARCHAR2,
701 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
702 p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
703 p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
704 p_category_id IN NUMBER := FND_API.G_MISS_NUM,
705 p_authors_array IN AMV_CHANNEL_PVT.AMV_CHAR_VARRAY_TYPE
706 );
707 --------------------------------------------------------------------------------
708 -- Start of comments
709 -- API name : Get_ChannelAuthors
710 -- Type : Private
711 -- Pre-reqs : None
712 -- Function : Get authors of the content channel.
713 -- Parameters :
714 -- IN p_api_version IN NUMBER Required
715 -- p_init_msg_list IN VARCHAR2 Optional
716 -- Default = FND_API.G_FALSE
717 -- p_validation_level NUMBER Optional
718 -- Default = FND_API.G_VALID_LEVEL_FULL
719 -- p_channel_id IN NUMBER Optional
720 -- the channel id. Default = FND_API.G_MISS_NUM
721 -- p_channel_name IN VARCHAR2 Optional
722 -- the channel name. Default = FND_API.G_MISS_CHAR
723 -- Either pass the channe id (preferred) or channel name
724 -- to identify the channel.
725 -- p_category_id IN NUMBER Optional
726 -- the category id. Default = FND_API.G_MISS_NUM
727 -- OUT : x_return_status OUT VARCHAR2
728 -- x_msg_count OUT NUMBER
729 -- x_msg_data OUT VARCHAR2
730 -- x_authors_array OUT AMV_CHAR_VARRAY_TYPE
731 -- Version : Current version 1.0
732 -- Previous version 1.0
733 -- Initial version 1.0
734 -- Notes :
735 --
736 -- End of comments
737 --
738 PROCEDURE Get_ChannelAuthors
739 ( p_api_version IN NUMBER,
740 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
741 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
742 x_return_status OUT NOCOPY VARCHAR2,
743 x_msg_count OUT NOCOPY NUMBER,
744 x_msg_data OUT NOCOPY VARCHAR2,
745 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
746 p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
750 );
747 p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
748 p_category_id IN NUMBER := FND_API.G_MISS_NUM,
749 x_authors_array OUT NOCOPY AMV_CHANNEL_PVT.AMV_CHAR_VARRAY_TYPE
751 --------------------------------------------------------------------------------
752 -- Start of comments
753 -- API name : Get_ItemsPerChannel
754 -- Type : Private
755 -- Pre-reqs : None
756 -- Function : Get all documents matching the content channel given by
757 -- channel id (preferred) or channel name.
758 -- Parameters :
759 -- IN p_api_version IN NUMBER Required
760 -- p_init_msg_list IN VARCHAR2 Optional
761 -- Default = FND_API.G_FALSE
762 -- p_validation_level NUMBER Optional
763 -- Default = FND_API.G_VALID_LEVEL_FULL
764 -- p_channel_id IN NUMBER Optional
765 -- the channel id. Default = FND_API.G_MISS_NUM
766 -- p_channel_name IN VARCHAR2 Optional
767 -- the channel name. Default = FND_API.G_MISS_CHAR
768 -- Either pass the channe id (preferred) or channel name
769 -- to identify the channel.
770 -- p_category_id IN NUMBER Optional
771 -- the category id. Default = FND_API.G_MISS_NUM
772 -- p_subset_request_rec IN AMV_REQUEST_OBJ_TYPE
773 -- Required
774 -- OUT : x_return_status OUT VARCHAR2
775 -- x_msg_count OUT NUMBER
776 -- x_msg_data OUT VARCHAR2
777 -- x_subset_return_rec OUT AMV_RETURN_OBJ_TYPE
778 -- x_document_id_array OUT AMV_NUMBER_VARRAY_TYPE
779 -- Version : Current version 1.0
780 -- Previous version 1.0
781 -- Initial version 1.0
782 -- Notes :
783 --
784 -- End of comments
785 --
786 PROCEDURE Get_ItemsPerChannel
787 ( p_api_version IN NUMBER,
788 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
789 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
790 x_return_status OUT NOCOPY VARCHAR2,
791 x_msg_count OUT NOCOPY NUMBER,
792 x_msg_data OUT NOCOPY VARCHAR2,
793 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
794 p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
795 p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
796 p_category_id IN NUMBER := FND_API.G_MISS_NUM,
797 p_subset_request_rec IN AMV_CHANNEL_PVT.AMV_REQUEST_OBJ_TYPE,
798 x_subset_return_rec OUT NOCOPY AMV_CHANNEL_PVT.AMV_RETURN_OBJ_TYPE,
799 x_document_id_array OUT NOCOPY AMV_CHANNEL_PVT.AMV_NUMBER_VARRAY_TYPE
800 );
801 --------------------------------------------------------------------------------
802 --------------------------------------------------------------------------------
803 -- Start of comments
804 -- API name : Find_Channels
805 -- Type : Private
806 -- Pre-reqs : None
807 -- Function : Get all documents matching the input criteria.
808 -- Parameters :
809 -- IN p_api_version IN NUMBER Required
810 -- p_init_msg_list IN VARCHAR2 Optional
811 -- Default = FND_API.G_FALSE
812 -- p_validation_level NUMBER Optional
813 -- Default = FND_API.G_VALID_LEVEL_FULL
814 -- p_criteria_rec IN
815 -- AMV_CHANNEL_OBJ_TYPE Required
816 -- p_sort_by IN VARCHAR2 Optional
817 -- Default = FND_API.G_MISS_CHAR
818 -- p_subset_request_rec IN AMV_REQUEST_OBJ_TYPE
819 -- Required
820 -- OUT : x_return_status OUT VARCHAR2
821 -- x_msg_count OUT NUMBER
822 -- x_msg_data OUT VARCHAR2
823 -- x_subset_return_rec OUT AMV_RETURN_OBJ_TYPE
824 -- x_content_chan_array OUT AMV_CHANNEL_VARRAY_TYPE
825 -- Version : Current version 1.0
826 -- Previous version 1.0
827 -- Initial version 1.0
828 -- Notes :
829 --
830 -- End of comments
831 --
832 PROCEDURE Find_Channels
833 ( p_api_version IN NUMBER,
834 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
835 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
836 x_return_status OUT NOCOPY VARCHAR2,
837 x_msg_count OUT NOCOPY NUMBER,
838 x_msg_data OUT NOCOPY VARCHAR2,
839 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
840 p_criteria_rec IN AMV_CHANNEL_PVT.AMV_CHANNEL_OBJ_TYPE,
841 p_sort_by IN VARCHAR2 := FND_API.G_MISS_CHAR,
842 p_subset_request_rec IN AMV_CHANNEL_PVT.AMV_REQUEST_OBJ_TYPE,
843 x_subset_return_rec OUT NOCOPY AMV_CHANNEL_PVT.AMV_RETURN_OBJ_TYPE,
844 x_content_chan_array OUT NOCOPY AMV_CHANNEL_PVT.AMV_CHANNEL_VARRAY_TYPE
845 );
846 --------------------------------------------------------------------------------
847 END amv_channel_grp;