[Home] [Help]
PACKAGE BODY: APPS.AMV_CHANNEL_GRP
Source
1 PACKAGE BODY amv_channel_grp AS
2 /* $Header: amvgchab.pls 120.1 2005/06/21 17:49:54 appldev ship $ */
3 --
4 -- NAME
5 -- AMV_CHANNEL_GRP
6 -- PURPOSE
7 --
8 -- HISTORY
9 -- 01/29/2000 SLKRISHN CREATED
10 --
11 --
12 G_PKG_NAME CONSTANT VARCHAR2(30) := 'AMV_CHANNEL_GRP';
13 G_FILE_NAME CONSTANT VARCHAR2(12) := 'amvgchab.pls';
14 -- This package contains the following procedures
15 --
16 --------------------------------------------------------------------------------
17 --------------------------------------------------------------------------------
18 -- Start of comments
19 -- API name : Add_PublicChannel
20 -- Type : Private
21 -- Pre-reqs : None
22 -- Function : Create a new content public channel
23 -- Parameters :
24 -- IN p_api_version IN NUMBER Required
25 -- p_init_msg_list IN VARCHAR2 Optional
26 -- Default = FND_API.G_FALSE
27 -- p_commit IN VARCHAR2 Optional
28 -- Default = FND_API.G_FALSE
29 -- p_validation_level IN NUMBER Optional
30 -- Default = FND_API.G_VALID_LEVEL_FULL
31 -- p_channel_record IN AMV_CHANNEL_OBJ_TYPE Required
32 -- OUT : x_return_status OUT VARCHAR2
33 -- x_msg_count OUT NUMBER
34 -- x_msg_data OUT VARCHAR2
35 -- x_channel_id OUT NUMBER
36 -- Version : Current version 1.0
37 -- Previous version 1.0
38 -- Initial version 1.0
39 -- Notes :
40 --
41 -- End of comments
42 --
43 PROCEDURE Add_PublicChannel
44 ( p_api_version IN NUMBER,
45 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
46 p_commit IN VARCHAR2 := FND_API.G_FALSE,
47 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
48 x_return_status OUT NOCOPY VARCHAR2,
49 x_msg_count OUT NOCOPY NUMBER,
50 x_msg_data OUT NOCOPY VARCHAR2,
51 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
52 p_channel_record IN AMV_CHANNEL_PVT.AMV_CHANNEL_OBJ_TYPE,
53 x_channel_id OUT NOCOPY NUMBER
54 )
55 IS
56 l_api_name varchar2(30) := 'Add_PublicChannel';
57 BEGIN
58
59 AMV_CHANNEL_PVT.Add_PublicChannel
60 (p_api_version => p_api_version,
61 p_init_msg_list => p_init_msg_list,
62 p_commit => p_commit,
63 p_validation_level => p_validation_level,
64 x_return_status => x_return_status,
65 x_msg_count => x_msg_count,
66 x_msg_data => x_msg_data,
67 p_check_login_user => p_check_login_user,
68 p_channel_record => p_channel_record,
69 x_channel_id => x_channel_id
70 );
71
72 EXCEPTION
73 WHEN OTHERS THEN
74 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
75 IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
76 THEN
77 FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
78 END IF;
79 -- Standard call to get message count and if count=1, get the message
80 FND_MSG_PUB.Count_And_Get (
81 p_encoded => FND_API.G_FALSE,
82 p_count => x_msg_count,
83 p_data => x_msg_data
84 );
85 END Add_PublicChannel;
86 --------------------------------------------------------------------------------
87 -- Start of comments
88 -- API name : Add_ProtectedChannel
89 -- Type : Private
90 -- Pre-reqs : None
91 -- Function : Create a new content protected channel
92 -- Parameters :
93 -- IN p_api_version IN NUMBER Required
94 -- p_init_msg_list IN VARCHAR2 Optional
95 -- Default = FND_API.G_FALSE
96 -- p_commit IN VARCHAR2 Optional
97 -- Default = FND_API.G_FALSE
98 -- p_validation_level IN NUMBER Optional
99 -- Default = FND_API.G_VALID_LEVEL_FULL
100 -- p_channel_record IN AMV_CHANNEL_OBJ_TYPE Required
101 -- OUT : x_return_status OUT VARCHAR2
102 -- x_msg_count OUT NUMBER
103 -- x_msg_data OUT VARCHAR2
104 -- x_channel_id OUT NUMBER
105 -- Version : Current version 1.0
106 -- Previous version 1.0
107 -- Initial version 1.0
108 -- Notes :
109 --
110 -- End of comments
111 --
112 PROCEDURE Add_ProtectedChannel
113 ( p_api_version IN NUMBER,
114 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
115 p_commit IN VARCHAR2 := FND_API.G_FALSE,
116 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
117 x_return_status OUT NOCOPY VARCHAR2,
118 x_msg_count OUT NOCOPY NUMBER,
119 x_msg_data OUT NOCOPY VARCHAR2,
120 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
121 p_channel_record IN AMV_CHANNEL_PVT.AMV_CHANNEL_OBJ_TYPE,
122 x_channel_id OUT NOCOPY NUMBER
123 )
124 IS
125 l_api_name varchar2(30) := 'Add_ProtectedChannel';
126 BEGIN
127
128 AMV_CHANNEL_PVT.Add_ProtectedChannel
129 (p_api_version => p_api_version,
130 p_init_msg_list => p_init_msg_list,
131 p_commit => p_commit,
132 p_validation_level => p_validation_level,
133 x_return_status => x_return_status,
134 x_msg_count => x_msg_count,
135 x_msg_data => x_msg_data,
136 p_check_login_user => p_check_login_user,
137 p_channel_record => p_channel_record,
138 x_channel_id => x_channel_id
139 );
140
141 EXCEPTION
142 WHEN OTHERS THEN
143 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
144 IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
145 THEN
146 FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
147 END IF;
148 -- Standard call to get message count and if count=1, get the message
149 FND_MSG_PUB.Count_And_Get (
150 p_encoded => FND_API.G_FALSE,
151 p_count => x_msg_count,
152 p_data => x_msg_data
153 );
154 END Add_ProtectedChannel;
155 --------------------------------------------------------------------------------
156 -- Start of comments
157 -- API name : Add_PrivateChannel
158 -- Type : Private
159 -- Pre-reqs : None
160 -- Function : Create a new content private channel
161 -- Parameters :
162 -- IN p_api_version IN NUMBER Required
163 -- p_init_msg_list IN VARCHAR2 Optional
164 -- Default = FND_API.G_FALSE
165 -- p_commit IN VARCHAR2 Optional
166 -- Default = FND_API.G_FALSE
167 -- p_validation_level IN NUMBER Optional
168 -- Default = FND_API.G_VALID_LEVEL_FULL
169 -- p_channel_record IN AMV_CHANNEL_OBJ_TYPE Required
170 -- OUT : x_return_status OUT VARCHAR2
171 -- x_msg_count OUT NUMBER
172 -- x_msg_data OUT VARCHAR2
173 -- x_channel_id OUT NUMBER
174 -- Version : Current version 1.0
175 -- Previous version 1.0
176 -- Initial version 1.0
177 -- Notes :
178 --
179 -- End of comments
180 --
181 PROCEDURE Add_PrivateChannel
182 ( p_api_version IN NUMBER,
183 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
184 p_commit IN VARCHAR2 := FND_API.G_FALSE,
185 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
186 x_return_status OUT NOCOPY VARCHAR2,
187 x_msg_count OUT NOCOPY NUMBER,
188 x_msg_data OUT NOCOPY VARCHAR2,
189 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
190 p_channel_record IN AMV_CHANNEL_PVT.AMV_CHANNEL_OBJ_TYPE,
191 x_channel_id OUT NOCOPY NUMBER
192 )
193 IS
194 l_api_name varchar2(30) := 'Add_PrivateChannel';
195 BEGIN
196
197 AMV_CHANNEL_PVT.Add_PrivateChannel
198 (p_api_version => p_api_version,
199 p_init_msg_list => p_init_msg_list,
200 p_commit => p_commit,
201 p_validation_level => p_validation_level,
202 x_return_status => x_return_status,
203 x_msg_count => x_msg_count,
204 x_msg_data => x_msg_data,
205 p_check_login_user => p_check_login_user,
206 p_channel_record => p_channel_record,
207 x_channel_id => x_channel_id
208 );
209
210 EXCEPTION
211 WHEN OTHERS THEN
212 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
213 IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
214 THEN
215 FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
216 END IF;
217 -- Standard call to get message count and if count=1, get the message
218 FND_MSG_PUB.Count_And_Get (
219 p_encoded => FND_API.G_FALSE,
220 p_count => x_msg_count,
221 p_data => x_msg_data
222 );
223 END Add_PrivateChannel;
224 --------------------------------------------------------------------------------
225 -- Start of comments
226 -- API name : Add_GroupChannel
227 -- Type : Private
228 -- Pre-reqs : None
229 -- Function : Create a new content protected channel
230 -- Parameters :
231 -- IN p_api_version IN NUMBER Required
232 -- p_init_msg_list IN VARCHAR2 Optional
233 -- Default = FND_API.G_FALSE
234 -- p_commit IN VARCHAR2 Optional
235 -- Default = FND_API.G_FALSE
236 -- p_validation_level IN NUMBER Optional
237 -- Default = FND_API.G_VALID_LEVEL_FULL
238 -- p_channel_record IN AMV_CHANNEL_OBJ_TYPE Required
239 -- OUT : x_return_status OUT VARCHAR2
240 -- x_msg_count OUT NUMBER
241 -- x_msg_data OUT VARCHAR2
242 -- x_channel_id OUT NUMBER
243 -- Version : Current version 1.0
244 -- Previous version 1.0
245 -- Initial version 1.0
246 -- Notes :
247 --
248 -- End of comments
249 --
250 PROCEDURE Add_GroupChannel
251 ( p_api_version IN NUMBER,
252 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
253 p_commit IN VARCHAR2 := FND_API.G_FALSE,
254 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
255 x_return_status OUT NOCOPY VARCHAR2,
256 x_msg_count OUT NOCOPY NUMBER,
257 x_msg_data OUT NOCOPY VARCHAR2,
258 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
259 p_group_id IN NUMBER,
260 p_channel_record IN AMV_CHANNEL_PVT.AMV_CHANNEL_OBJ_TYPE,
261 x_channel_id OUT NOCOPY NUMBER
262 )
263 IS
264 l_api_name varchar2(30) := 'Add_GroupChannel';
265 BEGIN
266
267 AMV_CHANNEL_PVT.Add_GroupChannel
268 (p_api_version => p_api_version,
269 p_init_msg_list => p_init_msg_list,
270 p_commit => p_commit,
271 p_validation_level => p_validation_level,
272 x_return_status => x_return_status,
273 x_msg_count => x_msg_count,
274 x_msg_data => x_msg_data,
275 p_check_login_user => p_check_login_user,
276 p_group_id => p_group_id,
277 p_channel_record => p_channel_record,
278 x_channel_id => x_channel_id
279 );
280
281 EXCEPTION
282 WHEN OTHERS THEN
283 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
284 IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
285 THEN
286 FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
287 END IF;
288 -- Standard call to get message count and if count=1, get the message
289 FND_MSG_PUB.Count_And_Get (
290 p_encoded => FND_API.G_FALSE,
291 p_count => x_msg_count,
292 p_data => x_msg_data
293 );
294 END Add_GroupChannel;
295 --------------------------------------------------------------------------------
296 -- Start of comments
297 -- API name : Delete_Channel
298 -- Type : Private
299 -- Pre-reqs : None
300 -- Function : Delete the content channel given p_channel_id/p_channel_name
301 -- Parameters :
302 -- IN p_api_version IN NUMBER Required
303 -- p_init_msg_list IN VARCHAR2 Optional
304 -- Default = FND_API.G_FALSE
305 -- p_commit IN VARCHAR2 Optional
306 -- Default = FND_API.G_FALSE
307 -- p_validation_level IN NUMBER Optional
308 -- Default = FND_API.G_VALID_LEVEL_FULL
309 -- p_channel_id IN NUMBER Optional
310 -- the channel id. Default = FND_API.G_MISS_NUM
311 -- p_channel_name IN VARCHAR2 Optional
312 -- the channel name. Default = FND_API.G_MISS_CHAR
313 -- Either pass the channe id (preferred) or channel name
314 -- to identify the channel.
315 -- p_category_id IN NUMBER Optional
316 -- the category id. Default = FND_API.G_MISS_NUM
317 -- OUT : x_return_status OUT VARCHAR2
318 -- x_msg_count OUT NUMBER
319 -- x_msg_data OUT VARCHAR2
320 -- Version : Current version 1.0
321 -- Previous version 1.0
322 -- Initial version 1.0
323 -- Notes :
324 --
325 -- End of comments
326 --
327 PROCEDURE Delete_Channel
328 ( p_api_version 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 x_return_status OUT NOCOPY VARCHAR2,
333 x_msg_count OUT NOCOPY NUMBER,
334 x_msg_data OUT NOCOPY VARCHAR2,
335 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
336 p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
337 p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
338 p_category_id IN NUMBER := FND_API.G_MISS_NUM
339 )
340 IS
341 l_api_name varchar2(30) := 'Delete_Channel';
342 BEGIN
343
344 AMV_CHANNEL_PVT.Delete_Channel
345 (p_api_version => p_api_version,
346 p_init_msg_list => p_init_msg_list,
347 p_commit => p_commit,
348 p_validation_level => p_validation_level,
349 x_return_status => x_return_status,
350 x_msg_count => x_msg_count,
351 x_msg_data => x_msg_data,
352 p_check_login_user => p_check_login_user,
353 p_channel_id => p_channel_id,
354 p_channel_name => p_channel_name,
355 p_category_id => p_category_id
356 );
357
358 EXCEPTION
359 WHEN OTHERS THEN
360 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
361 IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
362 THEN
363 FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
364 END IF;
365 -- Standard call to get message count and if count=1, get the message
366 FND_MSG_PUB.Count_And_Get (
367 p_encoded => FND_API.G_FALSE,
368 p_count => x_msg_count,
369 p_data => x_msg_data
370 );
371 END Delete_Channel;
375 -- Type : Private
372 --------------------------------------------------------------------------------
373 -- Start of comments
374 -- API name : Update_Channel
376 -- Pre-reqs : None
377 -- Function : Change the channel given by
378 -- (channel) id or name in p_channel_record
379 -- New data are specified in other members of p_channel_record
380 -- Parameters :
381 -- IN p_api_version IN NUMBER Required
382 -- p_init_msg_list IN VARCHAR2 Optional
383 -- Default = FND_API.G_FALSE
384 -- p_commit IN VARCHAR2 Optional
385 -- Default = FND_API.G_FALSE
386 -- p_validation_level IN NUMBER Optional
387 -- Default = FND_API.G_VALID_LEVEL_FULL
388 -- p_channel_record IN AMV_CHANNEL_OBJ_TYPE Required
389 -- OUT : x_return_status OUT VARCHAR2
390 -- x_msg_count OUT NUMBER
391 -- x_msg_data OUT VARCHAR2
392 -- Version : Current version 1.0
393 -- Previous version 1.0
394 -- Initial version 1.0
395 -- Notes :
396 --
397 -- End of comments
398 --
399 PROCEDURE Update_Channel
400 ( p_api_version IN NUMBER,
401 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
402 p_commit IN VARCHAR2 := FND_API.G_FALSE,
403 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
404 x_return_status OUT NOCOPY VARCHAR2,
405 x_msg_count OUT NOCOPY NUMBER,
406 x_msg_data OUT NOCOPY VARCHAR2,
407 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
408 p_channel_record IN AMV_CHANNEL_PVT.AMV_CHANNEL_OBJ_TYPE
409 )
410 IS
411 l_api_name varchar2(30) := 'Update_Channel';
412 BEGIN
413
414 AMV_CHANNEL_PVT.Update_Channel
415 (p_api_version => p_api_version,
416 p_init_msg_list => p_init_msg_list,
417 p_commit => p_commit,
418 p_validation_level => p_validation_level,
419 x_return_status => x_return_status,
420 x_msg_count => x_msg_count,
421 x_msg_data => x_msg_data,
422 p_check_login_user => p_check_login_user,
423 p_channel_record => p_channel_record
424 );
425
426 EXCEPTION
427 WHEN OTHERS THEN
428 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
429 IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
430 THEN
431 FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
432 END IF;
433 -- Standard call to get message count and if count=1, get the message
434 FND_MSG_PUB.Count_And_Get (
435 p_encoded => FND_API.G_FALSE,
436 p_count => x_msg_count,
437 p_data => x_msg_data
438 );
439 END Update_Channel;
440 --------------------------------------------------------------------------------
441 -- Start of comments
442 -- API name : Get_Channel
443 -- Type : Private
444 -- Pre-reqs : None
445 -- Function : Get the channel attributes of channel given by
446 -- channel id (preferred) or channel name.
447 -- Parameters :
448 -- IN p_api_version IN NUMBER Required
449 -- p_init_msg_list IN VARCHAR2 Optional
450 -- Default = FND_API.G_FALSE
451 -- p_validation_level IN NUMBER Optional
452 -- Default = FND_API.G_VALID_LEVEL_FULL
453 -- p_channel_id IN NUMBER Optional
454 -- the channel id. Default = FND_API.G_MISS_NUM
455 -- p_channel_name IN VARCHAR2 Optional
456 -- the channel name. Default = FND_API.G_MISS_CHAR
457 -- Either pass the channe id (preferred) or channel name
458 -- to identify the channel.
459 -- p_category_id IN NUMBER Optional
460 -- the category id. Default = FND_API.G_MISS_NUM
461 -- OUT : x_return_status OUT VARCHAR2
462 -- x_msg_count OUT NUMBER
463 -- x_msg_data OUT VARCHAR2
464 -- x_channel_record OUT AMV_CHANNEL_OBJ_TYPE
465 -- Version : Current version 1.0
466 -- Previous version 1.0
467 -- Initial version 1.0
468 -- Notes :
469 --
470 -- End of comments
471 --
472 PROCEDURE Get_Channel
473 ( p_api_version IN NUMBER,
474 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
475 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
476 x_return_status OUT NOCOPY VARCHAR2,
477 x_msg_count OUT NOCOPY NUMBER,
478 x_msg_data OUT NOCOPY VARCHAR2,
479 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
480 p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
481 p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
482 p_category_id IN NUMBER := FND_API.G_MISS_NUM,
483 x_channel_record OUT NOCOPY AMV_CHANNEL_PVT.AMV_CHANNEL_OBJ_TYPE
484 )
485 IS
489 AMV_CHANNEL_PVT.Get_Channel
486 l_api_name varchar2(30) := 'Get_Channel';
487 BEGIN
488
490 (p_api_version => p_api_version,
491 p_init_msg_list => p_init_msg_list,
492 p_validation_level => p_validation_level,
493 x_return_status => x_return_status,
494 x_msg_count => x_msg_count,
495 x_msg_data => x_msg_data,
496 p_check_login_user => p_check_login_user,
497 p_channel_id => p_channel_id,
498 p_channel_name => p_channel_name,
499 p_category_id => p_category_id,
500 x_channel_record => x_channel_record
501 );
502
503 EXCEPTION
504 WHEN OTHERS THEN
505 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
506 IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
507 THEN
508 FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
509 END IF;
510 -- Standard call to get message count and if count=1, get the message
511 FND_MSG_PUB.Count_And_Get (
512 p_encoded => FND_API.G_FALSE,
513 p_count => x_msg_count,
514 p_data => x_msg_data
515 );
516 END Get_Channel;
517 --------------------------------------------------------------------------------
518 -- Start of comments
519 -- API name : Set_ChannelContentTypes
520 -- Type : Private
521 -- Pre-reqs : None
522 -- Function : Change content categories of the content channel.
523 -- Parameters :
524 -- IN p_api_version IN NUMBER Required
525 -- p_init_msg_list IN VARCHAR2 Optional
526 -- Default = FND_API.G_FALSE
527 -- p_commit IN VARCHAR2 Optional
528 -- Default = FND_API.G_FALSE
529 -- p_validation_level NUMBER Optional
530 -- Default = FND_API.G_VALID_LEVEL_FULL
531 -- p_channel_id IN NUMBER Optional
532 -- the channel id. Default = FND_API.G_MISS_NUM
533 -- p_channel_name IN VARCHAR2 Optional
534 -- the channel name. Default = FND_API.G_MISS_CHAR
535 -- Either pass the channe id (preferred) or channel name
536 -- to identify the channel.
537 -- p_category_id IN NUMBER Optional
538 -- the category id. Default = FND_API.G_MISS_NUM
539 -- p_content_type_id_array IN AMV_NUMBER_VARRAY_TYPE
540 -- OUT : x_return_status OUT VARCHAR2
541 -- x_msg_count OUT NUMBER
542 -- x_msg_data OUT VARCHAR2
543 -- Version : Current version 1.0
544 -- Previous version 1.0
545 -- Initial version 1.0
546 -- Notes :
547 --
548 -- End of comments
549 --
550 PROCEDURE Set_ChannelContentTypes
551 ( p_api_version IN NUMBER,
552 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
553 p_commit IN VARCHAR2 := FND_API.G_FALSE,
554 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
555 x_return_status OUT NOCOPY VARCHAR2,
556 x_msg_count OUT NOCOPY NUMBER,
557 x_msg_data OUT NOCOPY VARCHAR2,
558 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
559 p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
560 p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
561 p_category_id IN NUMBER := FND_API.G_MISS_NUM,
562 p_content_type_id_array IN AMV_CHANNEL_PVT.AMV_NUMBER_VARRAY_TYPE
563 )
564 IS
565 l_api_name varchar2(30) := 'Set_ChannelContentTypes';
566 BEGIN
567
568 AMV_CHANNEL_PVT.Set_ChannelContentTypes
569 (p_api_version => p_api_version,
570 p_init_msg_list => p_init_msg_list,
571 p_commit => p_commit,
572 p_validation_level => p_validation_level,
573 x_return_status => x_return_status,
574 x_msg_count => x_msg_count,
575 x_msg_data => x_msg_data,
576 p_check_login_user => p_check_login_user,
577 p_channel_id => p_channel_id,
578 p_channel_name => p_channel_name,
579 p_category_id => p_category_id,
580 p_content_type_id_array => p_content_type_id_array
581 );
582
583 EXCEPTION
584 WHEN OTHERS THEN
585 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
586 IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
587 THEN
588 FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
589 END IF;
590 -- Standard call to get message count and if count=1, get the message
591 FND_MSG_PUB.Count_And_Get (
592 p_encoded => FND_API.G_FALSE,
593 p_count => x_msg_count,
594 p_data => x_msg_data
595 );
596 END Set_ChannelContentTypes;
597 --------------------------------------------------------------------------------
598 -- Start of comments
599 -- API name : Get_ChannelContentTypes
600 -- Type : Private
601 -- Pre-reqs : None
602 -- Function : Get content categories of the content channel.
603 -- Parameters :
604 -- IN p_api_version IN NUMBER Required
608 -- Default = FND_API.G_VALID_LEVEL_FULL
605 -- p_init_msg_list IN VARCHAR2 Optional
606 -- Default = FND_API.G_FALSE
607 -- p_validation_level NUMBER Optional
609 -- p_channel_id IN NUMBER Optional
610 -- the channel id. Default = FND_API.G_MISS_NUM
611 -- p_channel_name IN VARCHAR2 Optional
612 -- the channel name. Default = FND_API.G_MISS_CHAR
613 -- Either pass the channe id (preferred) or channel name
614 -- to identify the channel.
615 -- p_category_id IN NUMBER Optional
616 -- the category id. Default = FND_API.G_MISS_NUM
617 -- OUT : x_return_status OUT VARCHAR2
618 -- x_msg_count OUT NUMBER
619 -- x_msg_data OUT VARCHAR2
620 -- x_content_type_id_array OUT AMV_NUMBER_VARRAY_TYPE
621 -- Version : Current version 1.0
622 -- Previous version 1.0
623 -- Initial version 1.0
624 -- Notes :
625 --
626 -- End of comments
627 --
628 PROCEDURE Get_ChannelContentTypes
629 ( p_api_version IN NUMBER,
630 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
631 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
632 x_return_status OUT NOCOPY VARCHAR2,
633 x_msg_count OUT NOCOPY NUMBER,
634 x_msg_data OUT NOCOPY VARCHAR2,
635 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
636 p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
637 p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
638 p_category_id IN NUMBER := FND_API.G_MISS_NUM,
639 x_content_type_id_array OUT NOCOPY AMV_CHANNEL_PVT.AMV_NUMBER_VARRAY_TYPE
640 )
641 IS
642 l_api_name varchar2(30) := 'Get_ChannelContentTypes';
643 BEGIN
644
645 AMV_CHANNEL_PVT.Get_ChannelContentTypes
646 (p_api_version => p_api_version,
647 p_init_msg_list => p_init_msg_list,
648 p_validation_level => p_validation_level,
649 x_return_status => x_return_status,
650 x_msg_count => x_msg_count,
651 x_msg_data => x_msg_data,
652 p_check_login_user => p_check_login_user,
653 p_channel_id => p_channel_id,
654 p_channel_name => p_channel_name,
655 p_category_id => p_category_id,
656 x_content_type_id_array => x_content_type_id_array
657 );
658
659 EXCEPTION
660 WHEN OTHERS THEN
661 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
662 IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
663 THEN
664 FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
665 END IF;
666 -- Standard call to get message count and if count=1, get the message
667 FND_MSG_PUB.Count_And_Get (
668 p_encoded => FND_API.G_FALSE,
669 p_count => x_msg_count,
670 p_data => x_msg_data
671 );
672 END Get_ChannelContentTypes;
673 --------------------------------------------------------------------------------
674 -- Start of comments
675 -- API name : Set_ChannelPerspectives
676 -- Type : Private
677 -- Pre-reqs : None
678 -- Function : Change perspectives of the content channel.
679 -- Parameters :
680 -- IN p_api_version IN NUMBER Required
681 -- p_init_msg_list IN VARCHAR2 Optional
682 -- Default = FND_API.G_FALSE
683 -- p_commit IN VARCHAR2 Optional
684 -- Default = FND_API.G_FALSE
685 -- p_validation_level NUMBER Optional
686 -- Default = FND_API.G_VALID_LEVEL_FULL
687 -- p_channel_id IN NUMBER Optional
688 -- the channel id. Default = FND_API.G_MISS_NUM
689 -- p_channel_name IN VARCHAR2 Optional
690 -- the channel name. Default = FND_API.G_MISS_CHAR
691 -- Either pass the channe id (preferred) or channel name
692 -- to identify the channel.
693 -- p_category_id IN NUMBER Optional
694 -- the category id. Default = FND_API.G_MISS_NUM
695 -- p_perspective_id_array IN AMV_NUMBER_VARRAY_TYPE
696 -- OUT : x_return_status OUT VARCHAR2
697 -- x_msg_count OUT NUMBER
698 -- x_msg_data OUT VARCHAR2
699 -- Version : Current version 1.0
700 -- Previous version 1.0
701 -- Initial version 1.0
702 -- Notes :
703 --
704 -- End of comments
705 --
706 PROCEDURE Set_ChannelPerspectives
707 ( p_api_version IN NUMBER,
708 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
709 p_commit IN VARCHAR2 := FND_API.G_FALSE,
710 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
711 x_return_status OUT NOCOPY VARCHAR2,
715 p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
712 x_msg_count OUT NOCOPY NUMBER,
713 x_msg_data OUT NOCOPY VARCHAR2,
714 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
716 p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
717 p_category_id IN NUMBER := FND_API.G_MISS_NUM,
718 p_perspective_id_array IN AMV_CHANNEL_PVT.AMV_NUMBER_VARRAY_TYPE
719 )
720 IS
721 l_api_name varchar2(30) := 'Set_ChannelPerspectives';
722 BEGIN
723
724 AMV_CHANNEL_PVT.Set_ChannelPerspectives
725 (p_api_version => p_api_version,
726 p_init_msg_list => p_init_msg_list,
727 p_commit => p_commit,
728 p_validation_level => p_validation_level,
729 x_return_status => x_return_status,
730 x_msg_count => x_msg_count,
731 x_msg_data => x_msg_data,
732 p_check_login_user => p_check_login_user,
733 p_channel_id => p_channel_id,
734 p_channel_name => p_channel_name,
735 p_category_id => p_category_id,
736 p_perspective_id_array => p_perspective_id_array
737 );
738
739 EXCEPTION
740 WHEN OTHERS THEN
741 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
742 IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
743 THEN
744 FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
745 END IF;
746 -- Standard call to get message count and if count=1, get the message
747 FND_MSG_PUB.Count_And_Get (
748 p_encoded => FND_API.G_FALSE,
749 p_count => x_msg_count,
750 p_data => x_msg_data
751 );
752 END Set_ChannelPerspectives;
753 --------------------------------------------------------------------------------
754 -- Start of comments
755 -- API name : Get_ChannelPerspectives
756 -- Type : Private
757 -- Pre-reqs : None
758 -- Function : Get perspectives of the content channel.
759 -- Parameters :
760 -- IN p_api_version IN NUMBER Required
761 -- p_init_msg_list IN VARCHAR2 Optional
762 -- Default = FND_API.G_FALSE
763 -- p_validation_level NUMBER Optional
764 -- Default = FND_API.G_VALID_LEVEL_FULL
765 -- p_channel_id IN NUMBER Optional
766 -- the channel id. Default = FND_API.G_MISS_NUM
767 -- p_channel_name IN VARCHAR2 Optional
768 -- the channel name. Default = FND_API.G_MISS_CHAR
769 -- Either pass the channe id (preferred) or channel name
770 -- to identify the channel.
771 -- p_category_id IN NUMBER Optional
772 -- the category id. Default = FND_API.G_MISS_NUM
773 -- OUT : x_return_status OUT VARCHAR2
774 -- x_msg_count OUT NUMBER
775 -- x_msg_data OUT VARCHAR2
776 -- x_perspective_id_array OUT AMV_NUMBER_VARRAY_TYPE
777 -- Version : Current version 1.0
778 -- Previous version 1.0
779 -- Initial version 1.0
780 -- Notes :
781 --
782 -- End of comments
783 --
784 PROCEDURE Get_ChannelPerspectives
785 ( p_api_version IN NUMBER,
786 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
787 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
788 x_return_status OUT NOCOPY VARCHAR2,
789 x_msg_count OUT NOCOPY NUMBER,
790 x_msg_data OUT NOCOPY VARCHAR2,
791 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
792 p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
793 p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
794 p_category_id IN NUMBER := FND_API.G_MISS_NUM,
795 x_perspective_id_array OUT NOCOPY AMV_CHANNEL_PVT.AMV_NUMBER_VARRAY_TYPE
796 )
797 IS
798 l_api_name varchar2(30) := 'Get_ChannelPerspectives';
799 BEGIN
800
801 AMV_CHANNEL_PVT.Get_ChannelPerspectives
802 (p_api_version => p_api_version,
803 p_init_msg_list => p_init_msg_list,
804 p_validation_level => p_validation_level,
805 x_return_status => x_return_status,
806 x_msg_count => x_msg_count,
807 x_msg_data => x_msg_data,
808 p_check_login_user => p_check_login_user,
809 p_channel_id => p_channel_id,
810 p_channel_name => p_channel_name,
811 p_category_id => p_category_id,
812 x_perspective_id_array => x_perspective_id_array
813 );
814
815 EXCEPTION
816 WHEN OTHERS THEN
817 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
818 IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
819 THEN
820 FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
821 END IF;
822 -- Standard call to get message count and if count=1, get the message
823 FND_MSG_PUB.Count_And_Get (
824 p_encoded => FND_API.G_FALSE,
825 p_count => x_msg_count,
826 p_data => x_msg_data
827 );
828 END Get_ChannelPerspectives;
829 --------------------------------------------------------------------------------
830 -- Start of comments
834 -- Function : Change user groups of the content channel.
831 -- API name : Set_ChannelItemTypes
832 -- Type : Private
833 -- Pre-reqs : None
835 -- Parameters :
836 -- IN p_api_version IN NUMBER Required
837 -- p_init_msg_list IN VARCHAR2 Optional
838 -- Default = FND_API.G_FALSE
839 -- p_validation_level NUMBER Optional
840 -- Default = FND_API.G_VALID_LEVEL_FULL
841 -- p_commit IN VARCHAR2 Optional
842 -- Default = FND_API.G_FALSE
843 -- p_channel_id IN NUMBER Optional
844 -- the channel id. Default = FND_API.G_MISS_NUM
845 -- p_channel_name IN VARCHAR2 Optional
846 -- the channel name. Default = FND_API.G_MISS_CHAR
847 -- Either pass the channe id (preferred) or channel name
848 -- to identify the channel.
849 -- p_category_id IN NUMBER Optional
850 -- the category id. Default = FND_API.G_MISS_NUM
851 -- p_item_type_array IN AMV_CHAR_VARRAY_TYPE
852 -- OUT : x_return_status OUT VARCHAR2
853 -- x_msg_count OUT NUMBER
854 -- x_msg_data OUT VARCHAR2
855 -- Version : Current version 1.0
856 -- Previous version 1.0
857 -- Initial version 1.0
858 -- Notes :
859 --
860 -- End of comments
861 --
862 PROCEDURE Set_ChannelItemTypes
863 ( p_api_version IN NUMBER,
864 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
865 p_commit IN VARCHAR2 := FND_API.G_FALSE,
866 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
867 x_return_status OUT NOCOPY VARCHAR2,
868 x_msg_count OUT NOCOPY NUMBER,
869 x_msg_data OUT NOCOPY VARCHAR2,
870 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
871 p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
872 p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
873 p_category_id IN NUMBER := FND_API.G_MISS_NUM,
874 p_item_type_array IN AMV_CHANNEL_PVT.AMV_CHAR_VARRAY_TYPE
875 )
876 IS
877 l_api_name varchar2(30) := 'Set_ChannelItemTypes';
878 BEGIN
879
880 AMV_CHANNEL_PVT.Set_ChannelItemTypes
881 (p_api_version => p_api_version,
882 p_init_msg_list => p_init_msg_list,
883 p_commit => p_commit,
884 p_validation_level => p_validation_level,
885 x_return_status => x_return_status,
886 x_msg_count => x_msg_count,
887 x_msg_data => x_msg_data,
888 p_check_login_user => p_check_login_user,
889 p_channel_id => p_channel_id,
890 p_channel_name => p_channel_name,
891 p_category_id => p_category_id,
892 p_item_type_array => p_item_type_array
893 );
894
895 EXCEPTION
896 WHEN OTHERS THEN
897 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
898 IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
899 THEN
900 FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
901 END IF;
902 -- Standard call to get message count and if count=1, get the message
903 FND_MSG_PUB.Count_And_Get (
904 p_encoded => FND_API.G_FALSE,
905 p_count => x_msg_count,
906 p_data => x_msg_data
907 );
908 END Set_ChannelItemTypes;
909 --------------------------------------------------------------------------------
910 -- Start of comments
911 -- API name : Get_ChannelItemTypes
912 -- Type : Private
913 -- Pre-reqs : None
914 -- Function : Get user groups of the content channel.
915 -- Parameters :
916 -- IN p_api_version IN NUMBER Required
917 -- p_init_msg_list IN VARCHAR2 Optional
918 -- Default = FND_API.G_FALSE
919 -- p_validation_level NUMBER Optional
920 -- Default = FND_API.G_VALID_LEVEL_FULL
921 -- p_channel_id IN NUMBER Optional
922 -- the channel id. Default = FND_API.G_MISS_NUM
923 -- p_channel_name IN VARCHAR2 Optional
924 -- the channel name. Default = FND_API.G_MISS_CHAR
925 -- Either pass the channe id (preferred) or channel name
926 -- to identify the channel.
927 -- p_category_id IN NUMBER Optional
928 -- the category id. Default = FND_API.G_MISS_NUM
929 -- OUT : x_return_status OUT VARCHAR2
930 -- x_msg_count OUT NUMBER
931 -- x_msg_data OUT VARCHAR2
932 -- x_item_type_array OUT AMV_CHAR_VARRAY_TYPE
933 -- Version : Current version 1.0
934 -- Previous version 1.0
935 -- Initial version 1.0
936 -- Notes :
937 --
938 -- End of comments
939 --
943 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
940 PROCEDURE Get_ChannelItemTypes
941 ( p_api_version IN NUMBER,
942 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
944 x_return_status OUT NOCOPY VARCHAR2,
945 x_msg_count OUT NOCOPY NUMBER,
946 x_msg_data OUT NOCOPY VARCHAR2,
947 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
948 p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
949 p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
950 p_category_id IN NUMBER := FND_API.G_MISS_NUM,
951 x_item_type_array OUT NOCOPY AMV_CHANNEL_PVT.AMV_CHAR_VARRAY_TYPE
952 )
953 IS
954 l_api_name varchar2(30) := 'Get_ChannelItemTypes';
955 BEGIN
956
957 AMV_CHANNEL_PVT.Get_ChannelItemTypes
958 (p_api_version => p_api_version,
959 p_init_msg_list => p_init_msg_list,
960 p_validation_level => p_validation_level,
961 x_return_status => x_return_status,
962 x_msg_count => x_msg_count,
963 x_msg_data => x_msg_data,
964 p_check_login_user => p_check_login_user,
965 p_channel_id => p_channel_id,
966 p_channel_name => p_channel_name,
967 p_category_id => p_category_id,
968 x_item_type_array => x_item_type_array
969 );
970
971 EXCEPTION
972 WHEN OTHERS THEN
973 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
974 IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
975 THEN
976 FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
977 END IF;
978 -- Standard call to get message count and if count=1, get the message
979 FND_MSG_PUB.Count_And_Get (
980 p_encoded => FND_API.G_FALSE,
981 p_count => x_msg_count,
982 p_data => x_msg_data
983 );
984 END Get_ChannelItemTypes;
985 --------------------------------------------------------------------------------
986 -- Start of comments
987 -- API name : Set_ChannelKeywords
988 -- Type : Private
989 -- Pre-reqs : None
990 -- Function : Change keywords of the content channel.
991 -- Parameters :
992 -- IN p_api_version IN NUMBER Required
993 -- p_init_msg_list IN VARCHAR2 Optional
994 -- Default = FND_API.G_FALSE
995 -- p_commit IN VARCHAR2 Optional
996 -- Default = FND_API.G_FALSE
997 -- p_validation_level NUMBER Optional
998 -- Default = FND_API.G_VALID_LEVEL_FULL
999 -- p_channel_id IN NUMBER Optional
1000 -- the channel id. Default = FND_API.G_MISS_NUM
1001 -- p_channel_name IN VARCHAR2 Optional
1002 -- the channel name. Default = FND_API.G_MISS_CHAR
1003 -- Either pass the channe id (preferred) or channel name
1004 -- to identify the channel.
1005 -- p_category_id IN NUMBER Optional
1006 -- the category id. Default = FND_API.G_MISS_NUM
1007 -- p_keywords_array IN AMV_CHAR_VARRAY_TYPE
1008 -- OUT : x_return_status OUT VARCHAR2
1009 -- x_msg_count OUT NUMBER
1010 -- x_msg_data OUT VARCHAR2
1011 -- Version : Current version 1.0
1012 -- Previous version 1.0
1013 -- Initial version 1.0
1014 -- Notes :
1015 --
1016 -- End of comments
1017 --
1018 PROCEDURE Set_ChannelKeywords
1019 ( p_api_version IN NUMBER,
1020 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1021 p_commit IN VARCHAR2 := FND_API.G_FALSE,
1022 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1023 x_return_status OUT NOCOPY VARCHAR2,
1024 x_msg_count OUT NOCOPY NUMBER,
1025 x_msg_data OUT NOCOPY VARCHAR2,
1026 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1027 p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
1028 p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1029 p_category_id IN NUMBER := FND_API.G_MISS_NUM,
1030 p_keywords_array IN AMV_CHANNEL_PVT.AMV_CHAR_VARRAY_TYPE
1031 )
1032 IS
1033 l_api_name varchar2(30) := 'Set_ChannelKeywords';
1034 BEGIN
1035
1036 AMV_CHANNEL_PVT.Set_ChannelKeywords
1037 (p_api_version => p_api_version,
1038 p_init_msg_list => p_init_msg_list,
1039 p_commit => p_commit,
1040 p_validation_level => p_validation_level,
1041 x_return_status => x_return_status,
1042 x_msg_count => x_msg_count,
1043 x_msg_data => x_msg_data,
1044 p_check_login_user => p_check_login_user,
1045 p_channel_id => p_channel_id,
1046 p_channel_name => p_channel_name,
1047 p_category_id => p_category_id,
1048 p_keywords_array => p_keywords_array
1049 );
1050
1051 EXCEPTION
1052 WHEN OTHERS THEN
1053 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1054 IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1055 THEN
1059 FND_MSG_PUB.Count_And_Get (
1056 FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1057 END IF;
1058 -- Standard call to get message count and if count=1, get the message
1060 p_encoded => FND_API.G_FALSE,
1061 p_count => x_msg_count,
1062 p_data => x_msg_data
1063 );
1064 END Set_ChannelKeywords;
1065 --------------------------------------------------------------------------------
1066 -- Start of comments
1067 -- API name : Get_ChannelKeywords
1068 -- Type : Private
1069 -- Pre-reqs : None
1070 -- Function : Get keywords of the content channel.
1071 -- Parameters :
1072 -- IN p_api_version IN NUMBER Required
1073 -- p_init_msg_list IN VARCHAR2 Optional
1074 -- Default = FND_API.G_FALSE
1075 -- p_validation_level NUMBER Optional
1076 -- Default = FND_API.G_VALID_LEVEL_FULL
1077 -- p_channel_id IN NUMBER Optional
1078 -- the channel id. Default = FND_API.G_MISS_NUM
1079 -- p_channel_name IN VARCHAR2 Optional
1080 -- the channel name. Default = FND_API.G_MISS_CHAR
1081 -- Either pass the channe id (preferred) or channel name
1082 -- to identify the channel.
1083 -- p_category_id IN NUMBER Optional
1084 -- the category id. Default = FND_API.G_MISS_NUM
1085 -- OUT : x_return_status OUT VARCHAR2
1086 -- x_msg_count OUT NUMBER
1087 -- x_msg_data OUT VARCHAR2
1088 -- x_keywords_array OUT AMV_CHAR_VARRAY_TYPE
1089 -- Version : Current version 1.0
1090 -- Previous version 1.0
1091 -- Initial version 1.0
1092 -- Notes :
1093 --
1094 -- End of comments
1095 --
1096 PROCEDURE Get_ChannelKeywords
1097 ( p_api_version IN NUMBER,
1098 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1099 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1100 x_return_status OUT NOCOPY VARCHAR2,
1101 x_msg_count OUT NOCOPY NUMBER,
1102 x_msg_data OUT NOCOPY VARCHAR2,
1103 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1104 p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
1105 p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1106 p_category_id IN NUMBER := FND_API.G_MISS_NUM,
1107 x_keywords_array OUT NOCOPY AMV_CHANNEL_PVT.AMV_CHAR_VARRAY_TYPE
1108 )
1109 IS
1110 l_api_name varchar2(30) := 'Get_ChannelKeywords';
1111 BEGIN
1112
1113 AMV_CHANNEL_PVT.Get_ChannelKeywords
1114 (p_api_version => p_api_version,
1115 p_init_msg_list => p_init_msg_list,
1116 p_validation_level => p_validation_level,
1117 x_return_status => x_return_status,
1118 x_msg_count => x_msg_count,
1119 x_msg_data => x_msg_data,
1120 p_check_login_user => p_check_login_user,
1121 p_channel_id => p_channel_id,
1122 p_channel_name => p_channel_name,
1123 p_category_id => p_category_id,
1124 x_keywords_array => x_keywords_array
1125 );
1126
1127 EXCEPTION
1128 WHEN OTHERS THEN
1129 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1130 IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1131 THEN
1132 FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1133 END IF;
1134 -- Standard call to get message count and if count=1, get the message
1135 FND_MSG_PUB.Count_And_Get (
1136 p_encoded => FND_API.G_FALSE,
1137 p_count => x_msg_count,
1138 p_data => x_msg_data
1139 );
1140 END Get_ChannelKeywords;
1141 --------------------------------------------------------------------------------
1142 -- Start of comments
1143 -- API name : Set_ChannelAuthors
1144 -- Type : Private
1145 -- Pre-reqs : None
1146 -- Function : Change authors of the content channel.
1147 -- Parameters :
1148 -- IN p_api_version IN NUMBER Required
1149 -- p_init_msg_list IN VARCHAR2 Optional
1150 -- Default = FND_API.G_FALSE
1151 -- p_commit IN VARCHAR2 Optional
1152 -- Default = FND_API.G_FALSE
1153 -- p_validation_level NUMBER Optional
1154 -- Default = FND_API.G_VALID_LEVEL_FULL
1155 -- p_channel_id IN NUMBER Optional
1156 -- the channel id. Default = FND_API.G_MISS_NUM
1157 -- p_channel_name IN VARCHAR2 Optional
1158 -- the channel name. Default = FND_API.G_MISS_CHAR
1159 -- Either pass the channe id (preferred) or channel name
1160 -- to identify the channel.
1161 -- p_category_id IN NUMBER Optional
1162 -- the category id. Default = FND_API.G_MISS_NUM
1163 -- p_authors_array IN AMV_CHAR_VARRAY_TYPE
1164 -- OUT : x_return_status OUT VARCHAR2
1168 -- Previous version 1.0
1165 -- x_msg_count OUT NUMBER
1166 -- x_msg_data OUT VARCHAR2
1167 -- Version : Current version 1.0
1169 -- Initial version 1.0
1170 -- Notes :
1171 --
1172 -- End of comments
1173 --
1174 PROCEDURE Set_ChannelAuthors
1175 ( p_api_version IN NUMBER,
1176 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1177 p_commit IN VARCHAR2 := FND_API.G_FALSE,
1178 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1179 x_return_status OUT NOCOPY VARCHAR2,
1180 x_msg_count OUT NOCOPY NUMBER,
1181 x_msg_data OUT NOCOPY VARCHAR2,
1182 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1183 p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
1184 p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1185 p_category_id IN NUMBER := FND_API.G_MISS_NUM,
1186 p_authors_array IN AMV_CHANNEL_PVT.AMV_CHAR_VARRAY_TYPE
1187 )
1188 IS
1189 l_api_name varchar2(30) := 'Set_ChannelAuthors';
1190 BEGIN
1191
1192 AMV_CHANNEL_PVT.Set_ChannelAuthors
1193 (p_api_version => p_api_version,
1194 p_init_msg_list => p_init_msg_list,
1195 p_commit => p_commit,
1196 p_validation_level => p_validation_level,
1197 x_return_status => x_return_status,
1198 x_msg_count => x_msg_count,
1199 x_msg_data => x_msg_data,
1200 p_check_login_user => p_check_login_user,
1201 p_channel_id => p_channel_id,
1202 p_channel_name => p_channel_name,
1203 p_category_id => p_category_id,
1204 p_authors_array => p_authors_array
1205 );
1206
1207 EXCEPTION
1208 WHEN OTHERS THEN
1209 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1210 IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1211 THEN
1212 FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1213 END IF;
1214 -- Standard call to get message count and if count=1, get the message
1215 FND_MSG_PUB.Count_And_Get (
1216 p_encoded => FND_API.G_FALSE,
1217 p_count => x_msg_count,
1218 p_data => x_msg_data
1219 );
1220 END Set_ChannelAuthors;
1221 --------------------------------------------------------------------------------
1222 -- Start of comments
1223 -- API name : Get_ChannelAuthors
1224 -- Type : Private
1225 -- Pre-reqs : None
1226 -- Function : Get authors of the content channel.
1227 -- Parameters :
1228 -- IN p_api_version IN NUMBER Required
1229 -- p_init_msg_list IN VARCHAR2 Optional
1230 -- Default = FND_API.G_FALSE
1231 -- p_validation_level NUMBER Optional
1232 -- Default = FND_API.G_VALID_LEVEL_FULL
1233 -- p_channel_id IN NUMBER Optional
1234 -- the channel id. Default = FND_API.G_MISS_NUM
1235 -- p_channel_name IN VARCHAR2 Optional
1236 -- the channel name. Default = FND_API.G_MISS_CHAR
1237 -- Either pass the channe id (preferred) or channel name
1238 -- to identify the channel.
1239 -- p_category_id IN NUMBER Optional
1240 -- the category id. Default = FND_API.G_MISS_NUM
1241 -- OUT : x_return_status OUT VARCHAR2
1242 -- x_msg_count OUT NUMBER
1243 -- x_msg_data OUT VARCHAR2
1244 -- x_authors_array OUT AMV_CHAR_VARRAY_TYPE
1245 -- Version : Current version 1.0
1246 -- Previous version 1.0
1247 -- Initial version 1.0
1248 -- Notes :
1249 --
1250 -- End of comments
1251 --
1252 PROCEDURE Get_ChannelAuthors
1253 ( p_api_version IN NUMBER,
1254 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1255 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1256 x_return_status OUT NOCOPY VARCHAR2,
1257 x_msg_count OUT NOCOPY NUMBER,
1258 x_msg_data OUT NOCOPY VARCHAR2,
1259 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1260 p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
1261 p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1262 p_category_id IN NUMBER := FND_API.G_MISS_NUM,
1263 x_authors_array OUT NOCOPY AMV_CHANNEL_PVT.AMV_CHAR_VARRAY_TYPE
1264 )
1265 IS
1266 l_api_name varchar2(30) := 'Get_ChannelAuthors';
1267 BEGIN
1268
1269 AMV_CHANNEL_PVT.Get_ChannelAuthors
1270 (p_api_version => p_api_version,
1271 p_init_msg_list => p_init_msg_list,
1272 p_validation_level => p_validation_level,
1273 x_return_status => x_return_status,
1274 x_msg_count => x_msg_count,
1275 x_msg_data => x_msg_data,
1276 p_check_login_user => p_check_login_user,
1277 p_channel_id => p_channel_id,
1278 p_channel_name => p_channel_name,
1279 p_category_id => p_category_id,
1280 x_authors_array => x_authors_array
1281 );
1282
1283 EXCEPTION
1284 WHEN OTHERS THEN
1288 FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1285 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1286 IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1287 THEN
1289 END IF;
1290 -- Standard call to get message count and if count=1, get the message
1291 FND_MSG_PUB.Count_And_Get (
1292 p_encoded => FND_API.G_FALSE,
1293 p_count => x_msg_count,
1294 p_data => x_msg_data
1295 );
1296 END Get_ChannelAuthors;
1297 --------------------------------------------------------------------------------
1298 -- Start of comments
1299 -- API name : Get_ItemsPerChannel
1300 -- Type : Private
1301 -- Pre-reqs : None
1302 -- Function : Get all documents matching the content channel given by
1303 -- channel id (preferred) or channel name.
1304 -- Parameters :
1305 -- IN p_api_version IN NUMBER Required
1306 -- p_init_msg_list IN VARCHAR2 Optional
1307 -- Default = FND_API.G_FALSE
1308 -- p_validation_level NUMBER Optional
1309 -- Default = FND_API.G_VALID_LEVEL_FULL
1310 -- p_channel_id IN NUMBER Optional
1311 -- the channel id. Default = FND_API.G_MISS_NUM
1312 -- p_channel_name IN VARCHAR2 Optional
1313 -- the channel name. Default = FND_API.G_MISS_CHAR
1314 -- Either pass the channe id (preferred) or channel name
1315 -- to identify the channel.
1316 -- p_category_id IN NUMBER Optional
1317 -- the category id. Default = FND_API.G_MISS_NUM
1318 -- p_subset_request_rec IN AMV_REQUEST_OBJ_TYPE
1319 -- Required
1320 -- OUT : x_return_status OUT VARCHAR2
1321 -- x_msg_count OUT NUMBER
1322 -- x_msg_data OUT VARCHAR2
1323 -- x_subset_return_rec OUT AMV_RETURN_OBJ_TYPE
1324 -- x_document_id_array OUT AMV_NUMBER_VARRAY_TYPE
1325 -- Version : Current version 1.0
1326 -- Previous version 1.0
1327 -- Initial version 1.0
1328 -- Notes :
1329 --
1330 -- End of comments
1331 --
1332 PROCEDURE Get_ItemsPerChannel
1333 ( p_api_version IN NUMBER,
1334 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1335 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1336 x_return_status OUT NOCOPY VARCHAR2,
1337 x_msg_count OUT NOCOPY NUMBER,
1338 x_msg_data OUT NOCOPY VARCHAR2,
1339 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1340 p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
1341 p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1342 p_category_id IN NUMBER := FND_API.G_MISS_NUM,
1343 p_subset_request_rec IN AMV_CHANNEL_PVT.AMV_REQUEST_OBJ_TYPE,
1344 x_subset_return_rec OUT NOCOPY AMV_CHANNEL_PVT.AMV_RETURN_OBJ_TYPE,
1345 x_document_id_array OUT NOCOPY AMV_CHANNEL_PVT.AMV_NUMBER_VARRAY_TYPE
1346 )
1347 IS
1348 l_api_name varchar2(30) := 'Get_ItemsPerChannel';
1349 BEGIN
1350
1351 AMV_CHANNEL_PVT.Get_ItemsPerChannel
1352 (p_api_version => p_api_version,
1353 p_init_msg_list => p_init_msg_list,
1354 p_validation_level => p_validation_level,
1355 x_return_status => x_return_status,
1356 x_msg_count => x_msg_count,
1357 x_msg_data => x_msg_data,
1358 p_check_login_user => p_check_login_user,
1359 p_channel_id => p_channel_id,
1360 p_channel_name => p_channel_name,
1361 p_category_id => p_category_id,
1362 p_subset_request_rec=> p_subset_request_rec,
1363 x_subset_return_rec => x_subset_return_rec,
1364 x_document_id_array => x_document_id_array
1365 );
1366
1367 EXCEPTION
1368 WHEN OTHERS THEN
1369 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1370 IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1371 THEN
1372 FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1373 END IF;
1374 -- Standard call to get message count and if count=1, get the message
1375 FND_MSG_PUB.Count_And_Get (
1376 p_encoded => FND_API.G_FALSE,
1377 p_count => x_msg_count,
1378 p_data => x_msg_data
1379 );
1380 END Get_ItemsPerChannel;
1381 --------------------------------------------------------------------------------
1382 --------------------------------------------------------------------------------
1383 -- Start of comments
1384 -- API name : Find_Channels
1385 -- Type : Private
1386 -- Pre-reqs : None
1387 -- Function : Get all documents matching the input criteria.
1388 -- Parameters :
1389 -- IN p_api_version IN NUMBER Required
1390 -- p_init_msg_list IN VARCHAR2 Optional
1391 -- Default = FND_API.G_FALSE
1392 -- p_validation_level NUMBER Optional
1393 -- Default = FND_API.G_VALID_LEVEL_FULL
1394 -- p_criteria_rec IN
1395 -- AMV_CHANNEL_OBJ_TYPE Required
1396 -- p_sort_by IN VARCHAR2 Optional
1397 -- Default = FND_API.G_MISS_CHAR
1398 -- p_subset_request_rec IN AMV_REQUEST_OBJ_TYPE
1399 -- Required
1400 -- OUT : x_return_status OUT VARCHAR2
1401 -- x_msg_count OUT NUMBER
1402 -- x_msg_data OUT VARCHAR2
1403 -- x_subset_return_rec OUT AMV_RETURN_OBJ_TYPE
1404 -- x_content_chan_array OUT AMV_CHANNEL_VARRAY_TYPE
1405 -- Version : Current version 1.0
1406 -- Previous version 1.0
1407 -- Initial version 1.0
1408 -- Notes :
1409 --
1410 -- End of comments
1411 --
1412 PROCEDURE Find_Channels
1413 ( p_api_version IN NUMBER,
1414 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1415 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1416 x_return_status OUT NOCOPY VARCHAR2,
1417 x_msg_count OUT NOCOPY NUMBER,
1418 x_msg_data OUT NOCOPY VARCHAR2,
1419 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1420 p_criteria_rec IN AMV_CHANNEL_PVT.AMV_CHANNEL_OBJ_TYPE,
1421 p_sort_by IN VARCHAR2 := FND_API.G_MISS_CHAR,
1422 p_subset_request_rec IN AMV_CHANNEL_PVT.AMV_REQUEST_OBJ_TYPE,
1423 x_subset_return_rec OUT NOCOPY AMV_CHANNEL_PVT.AMV_RETURN_OBJ_TYPE,
1424 x_content_chan_array OUT NOCOPY AMV_CHANNEL_PVT.AMV_CHANNEL_VARRAY_TYPE
1425 )
1426 IS
1427 l_api_name varchar2(30) := 'Find_Channels';
1428 BEGIN
1429
1430 AMV_CHANNEL_PVT.Find_Channels
1431 (p_api_version => p_api_version,
1432 p_init_msg_list => p_init_msg_list,
1433 p_validation_level => p_validation_level,
1434 x_return_status => x_return_status,
1435 x_msg_count => x_msg_count,
1436 x_msg_data => x_msg_data,
1437 p_check_login_user => p_check_login_user,
1438 p_criteria_rec => p_criteria_rec,
1439 p_sort_by => p_sort_by,
1440 p_subset_request_rec=> p_subset_request_rec,
1441 x_subset_return_rec => x_subset_return_rec,
1442 x_content_chan_array=> x_content_chan_array
1443 );
1444
1445 EXCEPTION
1446 WHEN OTHERS THEN
1447 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1448 IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1449 THEN
1450 FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1451 END IF;
1452 -- Standard call to get message count and if count=1, get the message
1453 FND_MSG_PUB.Count_And_Get (
1454 p_encoded => FND_API.G_FALSE,
1455 p_count => x_msg_count,
1456 p_data => x_msg_data
1457 );
1458 END Find_Channels;
1459 --------------------------------------------------------------------------------
1460 END amv_channel_grp;