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
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
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
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,
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,
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,
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
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;
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;
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
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
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
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,
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,
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,
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
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;
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;
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
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
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
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,
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,
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,
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
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;
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;
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
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
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
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,
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,
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,
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: )
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;
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;
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
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
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
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.
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
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
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,
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,
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,
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: )
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
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';
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
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;
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;
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
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
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
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,
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,
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,
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';
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;
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;
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
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
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.
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
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
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,
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,
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
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: )
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
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
486: l_api_name varchar2(30) := 'Get_Channel';
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;
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;
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
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
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
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.
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
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
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,
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,
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,
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
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: )
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
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';
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;
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;
602: -- Function : Get content categories of the content channel.
603: -- Parameters :
604: -- IN p_api_version IN NUMBER Required
605: -- p_init_msg_list IN VARCHAR2 Optional
606: -- Default = FND_API.G_FALSE
607: -- p_validation_level NUMBER Optional
608: -- Default = FND_API.G_VALID_LEVEL_FULL
609: -- p_channel_id IN NUMBER Optional
610: -- the channel id. Default = FND_API.G_MISS_NUM
604: -- IN p_api_version IN NUMBER Required
605: -- p_init_msg_list IN VARCHAR2 Optional
606: -- Default = FND_API.G_FALSE
607: -- p_validation_level NUMBER Optional
608: -- Default = FND_API.G_VALID_LEVEL_FULL
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
606: -- Default = FND_API.G_FALSE
607: -- p_validation_level NUMBER Optional
608: -- Default = FND_API.G_VALID_LEVEL_FULL
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.
608: -- Default = FND_API.G_VALID_LEVEL_FULL
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
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
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,
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,
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
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: )
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
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';
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;
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;
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
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
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
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.
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
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
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,
712: x_msg_count OUT NOCOPY NUMBER,
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,
712: x_msg_count OUT NOCOPY NUMBER,
713: x_msg_data OUT NOCOPY VARCHAR2,
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,
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,
710: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
711: x_return_status OUT NOCOPY VARCHAR2,
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,
715: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
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
711: x_return_status OUT NOCOPY VARCHAR2,
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,
715: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
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: )
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,
715: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
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
713: x_msg_data OUT NOCOPY VARCHAR2,
714: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
715: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
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';
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;
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;
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
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
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.
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
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
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,
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,
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
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: )
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
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';
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;
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;
834: -- Function : Change user groups of the content channel.
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
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
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
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.
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
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
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,
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,
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,
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
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: )
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
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';
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;
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;
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
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
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.
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
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
938: -- End of comments
939: --
940: PROCEDURE Get_ChannelItemTypes
941: ( p_api_version IN NUMBER,
942: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
943: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
944: x_return_status OUT NOCOPY VARCHAR2,
945: x_msg_count OUT NOCOPY NUMBER,
946: x_msg_data OUT NOCOPY VARCHAR2,
939: --
940: PROCEDURE Get_ChannelItemTypes
941: ( p_api_version IN NUMBER,
942: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
943: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
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,
943: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
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
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: )
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
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';
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;
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;
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
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
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
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.
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
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
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,
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,
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,
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
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: )
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
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';
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
1056: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1057: END IF;
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
1059: FND_MSG_PUB.Count_And_Get (
1060: p_encoded => FND_API.G_FALSE,
1061: p_count => x_msg_count,
1062: p_data => x_msg_data
1063: );
1064: END Set_ChannelKeywords;
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
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
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.
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
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
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,
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,
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
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: )
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
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';
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;
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;
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
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
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
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.
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
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
1165: -- x_msg_count OUT NUMBER
1166: -- x_msg_data OUT VARCHAR2
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,
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,
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,
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
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: )
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
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';
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;
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;
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
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
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.
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
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
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,
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,
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
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: )
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
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';
1281: );
1282:
1283: EXCEPTION
1284: WHEN OTHERS THEN
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
1288: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1289: END IF;
1288: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
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;
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
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
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.
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
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
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,
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,
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,
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,
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
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: )
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;
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;
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
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
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
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,
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,
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,
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: )
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;
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;