[Home] [Help]
86: -- Function : Create a new channel
87: -- Parameters :
88: -- IN p_api_version IN NUMBER Required
89: -- p_init_msg_list IN VARCHAR2 Optional
90: -- Default = FND_API.G_FALSE
91: -- p_commit IN VARCHAR2 Optional
92: -- Default = FND_API.G_FALSE
93: -- p_validation_level IN NUMBER Optional
94: -- Default = FND_API.G_VALID_LEVEL_FULL
88: -- IN p_api_version IN NUMBER Required
89: -- p_init_msg_list IN VARCHAR2 Optional
90: -- Default = FND_API.G_FALSE
91: -- p_commit IN VARCHAR2 Optional
92: -- Default = FND_API.G_FALSE
93: -- p_validation_level IN NUMBER Optional
94: -- Default = FND_API.G_VALID_LEVEL_FULL
95: -- p_channel_record IN AMV_CHANNEL_OBJ_TYPE Required
96: -- OUT : x_return_status OUT VARCHAR2
90: -- Default = FND_API.G_FALSE
91: -- p_commit IN VARCHAR2 Optional
92: -- Default = FND_API.G_FALSE
93: -- p_validation_level IN NUMBER Optional
94: -- Default = FND_API.G_VALID_LEVEL_FULL
95: -- p_channel_record IN AMV_CHANNEL_OBJ_TYPE Required
96: -- OUT : x_return_status OUT VARCHAR2
97: -- x_msg_count OUT NUMBER
98: -- x_msg_data OUT VARCHAR2
105: -- End of comments
106: --
107: PROCEDURE Add_Channel
108: ( p_api_version IN NUMBER,
109: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
110: p_commit IN VARCHAR2 := FND_API.G_FALSE,
111: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
112: x_return_status OUT NOCOPY VARCHAR2,
113: x_msg_count OUT NOCOPY NUMBER,
106: --
107: PROCEDURE Add_Channel
108: ( p_api_version IN NUMBER,
109: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
110: p_commit IN VARCHAR2 := FND_API.G_FALSE,
111: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
112: x_return_status OUT NOCOPY VARCHAR2,
113: x_msg_count OUT NOCOPY NUMBER,
114: x_msg_data OUT NOCOPY VARCHAR2,
107: PROCEDURE Add_Channel
108: ( p_api_version IN NUMBER,
109: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
110: p_commit IN VARCHAR2 := FND_API.G_FALSE,
111: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
112: x_return_status OUT NOCOPY VARCHAR2,
113: x_msg_count OUT NOCOPY NUMBER,
114: x_msg_data OUT NOCOPY VARCHAR2,
115: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
111: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
112: x_return_status OUT NOCOPY VARCHAR2,
113: x_msg_count OUT NOCOPY NUMBER,
114: x_msg_data OUT NOCOPY VARCHAR2,
115: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
116: p_channel_record IN AMV_CHANNEL_OBJ_TYPE,
117: x_channel_id OUT NOCOPY NUMBER
118: );
119: --------------------------------------------------------------------------------
124: -- Function : Create a new content public channel
125: -- Parameters :
126: -- IN p_api_version IN NUMBER Required
127: -- p_init_msg_list IN VARCHAR2 Optional
128: -- Default = FND_API.G_FALSE
129: -- p_commit IN VARCHAR2 Optional
130: -- Default = FND_API.G_FALSE
131: -- p_validation_level IN NUMBER Optional
132: -- Default = FND_API.G_VALID_LEVEL_FULL
126: -- IN p_api_version IN NUMBER Required
127: -- p_init_msg_list IN VARCHAR2 Optional
128: -- Default = FND_API.G_FALSE
129: -- p_commit IN VARCHAR2 Optional
130: -- Default = FND_API.G_FALSE
131: -- p_validation_level IN NUMBER Optional
132: -- Default = FND_API.G_VALID_LEVEL_FULL
133: -- p_channel_record IN AMV_CHANNEL_OBJ_TYPE Required
134: -- OUT : x_return_status OUT VARCHAR2
128: -- Default = FND_API.G_FALSE
129: -- p_commit IN VARCHAR2 Optional
130: -- Default = FND_API.G_FALSE
131: -- p_validation_level IN NUMBER Optional
132: -- Default = FND_API.G_VALID_LEVEL_FULL
133: -- p_channel_record IN AMV_CHANNEL_OBJ_TYPE Required
134: -- OUT : x_return_status OUT VARCHAR2
135: -- x_msg_count OUT NUMBER
136: -- x_msg_data OUT VARCHAR2
143: -- End of comments
144: --
145: PROCEDURE Add_PublicChannel
146: ( p_api_version IN NUMBER,
147: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
148: p_commit IN VARCHAR2 := FND_API.G_FALSE,
149: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
150: x_return_status OUT NOCOPY VARCHAR2,
151: x_msg_count OUT NOCOPY NUMBER,
144: --
145: PROCEDURE Add_PublicChannel
146: ( p_api_version IN NUMBER,
147: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
148: p_commit IN VARCHAR2 := FND_API.G_FALSE,
149: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
150: x_return_status OUT NOCOPY VARCHAR2,
151: x_msg_count OUT NOCOPY NUMBER,
152: x_msg_data OUT NOCOPY VARCHAR2,
145: PROCEDURE Add_PublicChannel
146: ( p_api_version IN NUMBER,
147: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
148: p_commit IN VARCHAR2 := FND_API.G_FALSE,
149: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
150: x_return_status OUT NOCOPY VARCHAR2,
151: x_msg_count OUT NOCOPY NUMBER,
152: x_msg_data OUT NOCOPY VARCHAR2,
153: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
149: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
150: x_return_status OUT NOCOPY VARCHAR2,
151: x_msg_count OUT NOCOPY NUMBER,
152: x_msg_data OUT NOCOPY VARCHAR2,
153: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
154: p_channel_record IN AMV_CHANNEL_OBJ_TYPE,
155: x_channel_id OUT NOCOPY NUMBER
156: );
157: --------------------------------------------------------------------------------
162: -- Function : Create a new content protected channel
163: -- Parameters :
164: -- IN p_api_version IN NUMBER Required
165: -- p_init_msg_list IN VARCHAR2 Optional
166: -- Default = FND_API.G_FALSE
167: -- p_commit IN VARCHAR2 Optional
168: -- Default = FND_API.G_FALSE
169: -- p_validation_level IN NUMBER Optional
170: -- Default = FND_API.G_VALID_LEVEL_FULL
164: -- IN p_api_version IN NUMBER Required
165: -- p_init_msg_list IN VARCHAR2 Optional
166: -- Default = FND_API.G_FALSE
167: -- p_commit IN VARCHAR2 Optional
168: -- Default = FND_API.G_FALSE
169: -- p_validation_level IN NUMBER Optional
170: -- Default = FND_API.G_VALID_LEVEL_FULL
171: -- p_channel_record IN AMV_CHANNEL_OBJ_TYPE Required
172: -- OUT : x_return_status OUT VARCHAR2
166: -- Default = FND_API.G_FALSE
167: -- p_commit IN VARCHAR2 Optional
168: -- Default = FND_API.G_FALSE
169: -- p_validation_level IN NUMBER Optional
170: -- Default = FND_API.G_VALID_LEVEL_FULL
171: -- p_channel_record IN AMV_CHANNEL_OBJ_TYPE Required
172: -- OUT : x_return_status OUT VARCHAR2
173: -- x_msg_count OUT NUMBER
174: -- x_msg_data OUT VARCHAR2
181: -- End of comments
182: --
183: PROCEDURE Add_ProtectedChannel
184: ( p_api_version IN NUMBER,
185: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
186: p_commit IN VARCHAR2 := FND_API.G_FALSE,
187: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
188: x_return_status OUT NOCOPY VARCHAR2,
189: x_msg_count OUT NOCOPY NUMBER,
182: --
183: PROCEDURE Add_ProtectedChannel
184: ( p_api_version IN NUMBER,
185: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
186: p_commit IN VARCHAR2 := FND_API.G_FALSE,
187: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
188: x_return_status OUT NOCOPY VARCHAR2,
189: x_msg_count OUT NOCOPY NUMBER,
190: x_msg_data OUT NOCOPY VARCHAR2,
183: PROCEDURE Add_ProtectedChannel
184: ( p_api_version IN NUMBER,
185: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
186: p_commit IN VARCHAR2 := FND_API.G_FALSE,
187: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
188: x_return_status OUT NOCOPY VARCHAR2,
189: x_msg_count OUT NOCOPY NUMBER,
190: x_msg_data OUT NOCOPY VARCHAR2,
191: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
187: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
188: x_return_status OUT NOCOPY VARCHAR2,
189: x_msg_count OUT NOCOPY NUMBER,
190: x_msg_data OUT NOCOPY VARCHAR2,
191: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
192: p_channel_record IN AMV_CHANNEL_OBJ_TYPE,
193: x_channel_id OUT NOCOPY NUMBER
194: );
195: --------------------------------------------------------------------------------
200: -- Function : Create a new content private channel
201: -- Parameters :
202: -- IN p_api_version IN NUMBER Required
203: -- p_init_msg_list IN VARCHAR2 Optional
204: -- Default = FND_API.G_FALSE
205: -- p_commit IN VARCHAR2 Optional
206: -- Default = FND_API.G_FALSE
207: -- p_validation_level IN NUMBER Optional
208: -- Default = FND_API.G_VALID_LEVEL_FULL
202: -- IN p_api_version IN NUMBER Required
203: -- p_init_msg_list IN VARCHAR2 Optional
204: -- Default = FND_API.G_FALSE
205: -- p_commit IN VARCHAR2 Optional
206: -- Default = FND_API.G_FALSE
207: -- p_validation_level IN NUMBER Optional
208: -- Default = FND_API.G_VALID_LEVEL_FULL
209: -- p_channel_record IN AMV_CHANNEL_OBJ_TYPE Required
210: -- OUT : x_return_status OUT VARCHAR2
204: -- Default = FND_API.G_FALSE
205: -- p_commit IN VARCHAR2 Optional
206: -- Default = FND_API.G_FALSE
207: -- p_validation_level IN NUMBER Optional
208: -- Default = FND_API.G_VALID_LEVEL_FULL
209: -- p_channel_record IN AMV_CHANNEL_OBJ_TYPE Required
210: -- OUT : x_return_status OUT VARCHAR2
211: -- x_msg_count OUT NUMBER
212: -- x_msg_data OUT VARCHAR2
219: -- End of comments
220: --
221: PROCEDURE Add_PrivateChannel
222: ( p_api_version IN NUMBER,
223: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
224: p_commit IN VARCHAR2 := FND_API.G_FALSE,
225: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
226: x_return_status OUT NOCOPY VARCHAR2,
227: x_msg_count OUT NOCOPY NUMBER,
220: --
221: PROCEDURE Add_PrivateChannel
222: ( p_api_version IN NUMBER,
223: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
224: p_commit IN VARCHAR2 := FND_API.G_FALSE,
225: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
226: x_return_status OUT NOCOPY VARCHAR2,
227: x_msg_count OUT NOCOPY NUMBER,
228: x_msg_data OUT NOCOPY VARCHAR2,
221: PROCEDURE Add_PrivateChannel
222: ( p_api_version IN NUMBER,
223: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
224: p_commit IN VARCHAR2 := FND_API.G_FALSE,
225: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
226: x_return_status OUT NOCOPY VARCHAR2,
227: x_msg_count OUT NOCOPY NUMBER,
228: x_msg_data OUT NOCOPY VARCHAR2,
229: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
225: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
226: x_return_status OUT NOCOPY VARCHAR2,
227: x_msg_count OUT NOCOPY NUMBER,
228: x_msg_data OUT NOCOPY VARCHAR2,
229: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
230: p_channel_record IN AMV_CHANNEL_OBJ_TYPE,
231: x_channel_id OUT NOCOPY NUMBER
232: );
233: --------------------------------------------------------------------------------
238: -- Function : Create a new content protected channel
239: -- Parameters :
240: -- IN p_api_version IN NUMBER Required
241: -- p_init_msg_list IN VARCHAR2 Optional
242: -- Default = FND_API.G_FALSE
243: -- p_commit IN VARCHAR2 Optional
244: -- Default = FND_API.G_FALSE
245: -- p_validation_level IN NUMBER Optional
246: -- Default = FND_API.G_VALID_LEVEL_FULL
240: -- IN p_api_version IN NUMBER Required
241: -- p_init_msg_list IN VARCHAR2 Optional
242: -- Default = FND_API.G_FALSE
243: -- p_commit IN VARCHAR2 Optional
244: -- Default = FND_API.G_FALSE
245: -- p_validation_level IN NUMBER Optional
246: -- Default = FND_API.G_VALID_LEVEL_FULL
247: -- p_channel_record IN AMV_CHANNEL_OBJ_TYPE Required
248: -- OUT : x_return_status OUT VARCHAR2
242: -- Default = FND_API.G_FALSE
243: -- p_commit IN VARCHAR2 Optional
244: -- Default = FND_API.G_FALSE
245: -- p_validation_level IN NUMBER Optional
246: -- Default = FND_API.G_VALID_LEVEL_FULL
247: -- p_channel_record IN AMV_CHANNEL_OBJ_TYPE Required
248: -- OUT : x_return_status OUT VARCHAR2
249: -- x_msg_count OUT NUMBER
250: -- x_msg_data OUT VARCHAR2
257: -- End of comments
258: --
259: PROCEDURE Add_GroupChannel
260: ( p_api_version IN NUMBER,
261: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
262: p_commit IN VARCHAR2 := FND_API.G_FALSE,
263: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
264: x_return_status OUT NOCOPY VARCHAR2,
265: x_msg_count OUT NOCOPY NUMBER,
258: --
259: PROCEDURE Add_GroupChannel
260: ( p_api_version IN NUMBER,
261: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
262: p_commit IN VARCHAR2 := FND_API.G_FALSE,
263: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
264: x_return_status OUT NOCOPY VARCHAR2,
265: x_msg_count OUT NOCOPY NUMBER,
266: x_msg_data OUT NOCOPY VARCHAR2,
259: PROCEDURE Add_GroupChannel
260: ( p_api_version IN NUMBER,
261: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
262: p_commit IN VARCHAR2 := FND_API.G_FALSE,
263: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
264: x_return_status OUT NOCOPY VARCHAR2,
265: x_msg_count OUT NOCOPY NUMBER,
266: x_msg_data OUT NOCOPY VARCHAR2,
267: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
263: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
264: x_return_status OUT NOCOPY VARCHAR2,
265: x_msg_count OUT NOCOPY NUMBER,
266: x_msg_data OUT NOCOPY VARCHAR2,
267: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
268: p_group_id IN NUMBER,
269: p_channel_record IN AMV_CHANNEL_OBJ_TYPE,
270: x_channel_id OUT NOCOPY NUMBER
271: );
277: -- Function : Delete the content channel given p_channel_id/p_channel_name
278: -- Parameters :
279: -- IN p_api_version IN NUMBER Required
280: -- p_init_msg_list IN VARCHAR2 Optional
281: -- Default = FND_API.G_FALSE
282: -- p_commit IN VARCHAR2 Optional
283: -- Default = FND_API.G_FALSE
284: -- p_validation_level IN NUMBER Optional
285: -- Default = FND_API.G_VALID_LEVEL_FULL
279: -- IN p_api_version IN NUMBER Required
280: -- p_init_msg_list IN VARCHAR2 Optional
281: -- Default = FND_API.G_FALSE
282: -- p_commit IN VARCHAR2 Optional
283: -- Default = FND_API.G_FALSE
284: -- p_validation_level IN NUMBER Optional
285: -- Default = FND_API.G_VALID_LEVEL_FULL
286: -- p_channel_id IN NUMBER Optional
287: -- the channel id. Default = FND_API.G_MISS_NUM
281: -- Default = FND_API.G_FALSE
282: -- p_commit IN VARCHAR2 Optional
283: -- Default = FND_API.G_FALSE
284: -- p_validation_level IN NUMBER Optional
285: -- Default = FND_API.G_VALID_LEVEL_FULL
286: -- p_channel_id IN NUMBER Optional
287: -- the channel id. Default = FND_API.G_MISS_NUM
288: -- p_channel_name IN VARCHAR2 Optional
289: -- the channel name. Default = FND_API.G_MISS_CHAR
283: -- Default = FND_API.G_FALSE
284: -- p_validation_level IN NUMBER Optional
285: -- Default = FND_API.G_VALID_LEVEL_FULL
286: -- p_channel_id IN NUMBER Optional
287: -- the channel id. Default = FND_API.G_MISS_NUM
288: -- p_channel_name IN VARCHAR2 Optional
289: -- the channel name. Default = FND_API.G_MISS_CHAR
290: -- Either pass the channe id (preferred) or channel name
291: -- to identify the channel.
285: -- Default = FND_API.G_VALID_LEVEL_FULL
286: -- p_channel_id IN NUMBER Optional
287: -- the channel id. Default = FND_API.G_MISS_NUM
288: -- p_channel_name IN VARCHAR2 Optional
289: -- the channel name. Default = FND_API.G_MISS_CHAR
290: -- Either pass the channe id (preferred) or channel name
291: -- to identify the channel.
292: -- p_category_id IN NUMBER Optional
293: -- the category id. Default = FND_API.G_MISS_NUM
289: -- the channel name. Default = FND_API.G_MISS_CHAR
290: -- Either pass the channe id (preferred) or channel name
291: -- to identify the channel.
292: -- p_category_id IN NUMBER Optional
293: -- the category id. Default = FND_API.G_MISS_NUM
294: -- OUT : x_return_status OUT VARCHAR2
295: -- x_msg_count OUT NUMBER
296: -- x_msg_data OUT VARCHAR2
297: -- Version : Current version 1.0
302: -- End of comments
303: --
304: PROCEDURE Delete_Channel
305: ( p_api_version IN NUMBER,
306: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
307: p_commit IN VARCHAR2 := FND_API.G_FALSE,
308: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
309: x_return_status OUT NOCOPY VARCHAR2,
310: x_msg_count OUT NOCOPY NUMBER,
303: --
304: PROCEDURE Delete_Channel
305: ( p_api_version IN NUMBER,
306: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
307: p_commit IN VARCHAR2 := FND_API.G_FALSE,
308: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
309: x_return_status OUT NOCOPY VARCHAR2,
310: x_msg_count OUT NOCOPY NUMBER,
311: x_msg_data OUT NOCOPY VARCHAR2,
304: PROCEDURE Delete_Channel
305: ( p_api_version IN NUMBER,
306: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
307: p_commit IN VARCHAR2 := FND_API.G_FALSE,
308: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
309: x_return_status OUT NOCOPY VARCHAR2,
310: x_msg_count OUT NOCOPY NUMBER,
311: x_msg_data OUT NOCOPY VARCHAR2,
312: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
308: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
309: x_return_status OUT NOCOPY VARCHAR2,
310: x_msg_count OUT NOCOPY NUMBER,
311: x_msg_data OUT NOCOPY VARCHAR2,
312: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
313: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
314: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
315: p_category_id IN NUMBER := FND_API.G_MISS_NUM
316: );
309: x_return_status OUT NOCOPY VARCHAR2,
310: x_msg_count OUT NOCOPY NUMBER,
311: x_msg_data OUT NOCOPY VARCHAR2,
312: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
313: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
314: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
315: p_category_id IN NUMBER := FND_API.G_MISS_NUM
316: );
317: --------------------------------------------------------------------------------
310: x_msg_count OUT NOCOPY NUMBER,
311: x_msg_data OUT NOCOPY VARCHAR2,
312: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
313: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
314: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
315: p_category_id IN NUMBER := FND_API.G_MISS_NUM
316: );
317: --------------------------------------------------------------------------------
318: -- Start of comments
311: x_msg_data OUT NOCOPY VARCHAR2,
312: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
313: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
314: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
315: p_category_id IN NUMBER := FND_API.G_MISS_NUM
316: );
317: --------------------------------------------------------------------------------
318: -- Start of comments
319: -- API name : Update_Channel
324: -- New data are specified in other members of p_channel_record
325: -- Parameters :
326: -- IN p_api_version IN NUMBER Required
327: -- p_init_msg_list IN VARCHAR2 Optional
328: -- Default = FND_API.G_FALSE
329: -- p_commit IN VARCHAR2 Optional
330: -- Default = FND_API.G_FALSE
331: -- p_validation_level IN NUMBER Optional
332: -- Default = FND_API.G_VALID_LEVEL_FULL
326: -- IN p_api_version IN NUMBER Required
327: -- p_init_msg_list IN VARCHAR2 Optional
328: -- Default = FND_API.G_FALSE
329: -- p_commit IN VARCHAR2 Optional
330: -- Default = FND_API.G_FALSE
331: -- p_validation_level IN NUMBER Optional
332: -- Default = FND_API.G_VALID_LEVEL_FULL
333: -- p_channel_record IN AMV_CHANNEL_OBJ_TYPE Required
334: -- OUT : x_return_status OUT VARCHAR2
328: -- Default = FND_API.G_FALSE
329: -- p_commit IN VARCHAR2 Optional
330: -- Default = FND_API.G_FALSE
331: -- p_validation_level IN NUMBER Optional
332: -- Default = FND_API.G_VALID_LEVEL_FULL
333: -- p_channel_record IN AMV_CHANNEL_OBJ_TYPE Required
334: -- OUT : x_return_status OUT VARCHAR2
335: -- x_msg_count OUT NUMBER
336: -- x_msg_data OUT VARCHAR2
342: -- End of comments
343: --
344: PROCEDURE Update_Channel
345: ( p_api_version IN NUMBER,
346: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
347: p_commit IN VARCHAR2 := FND_API.G_FALSE,
348: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
349: x_return_status OUT NOCOPY VARCHAR2,
350: x_msg_count OUT NOCOPY NUMBER,
343: --
344: PROCEDURE Update_Channel
345: ( p_api_version IN NUMBER,
346: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
347: p_commit IN VARCHAR2 := FND_API.G_FALSE,
348: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
349: x_return_status OUT NOCOPY VARCHAR2,
350: x_msg_count OUT NOCOPY NUMBER,
351: x_msg_data OUT NOCOPY VARCHAR2,
344: PROCEDURE Update_Channel
345: ( p_api_version IN NUMBER,
346: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
347: p_commit IN VARCHAR2 := FND_API.G_FALSE,
348: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
349: x_return_status OUT NOCOPY VARCHAR2,
350: x_msg_count OUT NOCOPY NUMBER,
351: x_msg_data OUT NOCOPY VARCHAR2,
352: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
348: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
349: x_return_status OUT NOCOPY VARCHAR2,
350: x_msg_count OUT NOCOPY NUMBER,
351: x_msg_data OUT NOCOPY VARCHAR2,
352: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
353: p_channel_record IN AMV_CHANNEL_OBJ_TYPE
354: );
355: --------------------------------------------------------------------------------
356: -- Start of comments
361: -- channel id (preferred) or channel name.
362: -- Parameters :
363: -- IN p_api_version IN NUMBER Required
364: -- p_init_msg_list IN VARCHAR2 Optional
365: -- Default = FND_API.G_FALSE
366: -- p_validation_level IN NUMBER Optional
367: -- Default = FND_API.G_VALID_LEVEL_FULL
368: -- p_channel_id IN NUMBER Optional
369: -- the channel id. Default = FND_API.G_MISS_NUM
363: -- IN p_api_version IN NUMBER Required
364: -- p_init_msg_list IN VARCHAR2 Optional
365: -- Default = FND_API.G_FALSE
366: -- p_validation_level IN NUMBER Optional
367: -- Default = FND_API.G_VALID_LEVEL_FULL
368: -- p_channel_id IN NUMBER Optional
369: -- the channel id. Default = FND_API.G_MISS_NUM
370: -- p_channel_name IN VARCHAR2 Optional
371: -- the channel name. Default = FND_API.G_MISS_CHAR
365: -- Default = FND_API.G_FALSE
366: -- p_validation_level IN NUMBER Optional
367: -- Default = FND_API.G_VALID_LEVEL_FULL
368: -- p_channel_id IN NUMBER Optional
369: -- the channel id. Default = FND_API.G_MISS_NUM
370: -- p_channel_name IN VARCHAR2 Optional
371: -- the channel name. Default = FND_API.G_MISS_CHAR
372: -- Either pass the channe id (preferred) or channel name
373: -- to identify the channel.
367: -- Default = FND_API.G_VALID_LEVEL_FULL
368: -- p_channel_id IN NUMBER Optional
369: -- the channel id. Default = FND_API.G_MISS_NUM
370: -- p_channel_name IN VARCHAR2 Optional
371: -- the channel name. Default = FND_API.G_MISS_CHAR
372: -- Either pass the channe id (preferred) or channel name
373: -- to identify the channel.
374: -- p_category_id IN NUMBER Optional
375: -- the category id. Default = FND_API.G_MISS_NUM
371: -- the channel name. Default = FND_API.G_MISS_CHAR
372: -- Either pass the channe id (preferred) or channel name
373: -- to identify the channel.
374: -- p_category_id IN NUMBER Optional
375: -- the category id. Default = FND_API.G_MISS_NUM
376: -- OUT : x_return_status OUT VARCHAR2
377: -- x_msg_count OUT NUMBER
378: -- x_msg_data OUT VARCHAR2
379: -- x_channel_record OUT AMV_CHANNEL_OBJ_TYPE
385: -- End of comments
386: --
387: PROCEDURE Get_Channel
388: ( p_api_version IN NUMBER,
389: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
390: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
391: x_return_status OUT NOCOPY VARCHAR2,
392: x_msg_count OUT NOCOPY NUMBER,
393: x_msg_data OUT NOCOPY VARCHAR2,
386: --
387: PROCEDURE Get_Channel
388: ( p_api_version IN NUMBER,
389: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
390: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
391: x_return_status OUT NOCOPY VARCHAR2,
392: x_msg_count OUT NOCOPY NUMBER,
393: x_msg_data OUT NOCOPY VARCHAR2,
394: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
390: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
391: x_return_status OUT NOCOPY VARCHAR2,
392: x_msg_count OUT NOCOPY NUMBER,
393: x_msg_data OUT NOCOPY VARCHAR2,
394: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
395: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
396: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
397: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
398: x_channel_record OUT NOCOPY AMV_CHANNEL_OBJ_TYPE
391: x_return_status OUT NOCOPY VARCHAR2,
392: x_msg_count OUT NOCOPY NUMBER,
393: x_msg_data OUT NOCOPY VARCHAR2,
394: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
395: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
396: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
397: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
398: x_channel_record OUT NOCOPY AMV_CHANNEL_OBJ_TYPE
399: );
392: x_msg_count OUT NOCOPY NUMBER,
393: x_msg_data OUT NOCOPY VARCHAR2,
394: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
395: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
396: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
397: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
398: x_channel_record OUT NOCOPY AMV_CHANNEL_OBJ_TYPE
399: );
400: --------------------------------------------------------------------------------
393: x_msg_data OUT NOCOPY VARCHAR2,
394: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
395: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
396: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
397: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
398: x_channel_record OUT NOCOPY AMV_CHANNEL_OBJ_TYPE
399: );
400: --------------------------------------------------------------------------------
401: -- Start of comments
405: -- Function : Change content categories of the content channel.
406: -- Parameters :
407: -- IN p_api_version IN NUMBER Required
408: -- p_init_msg_list IN VARCHAR2 Optional
409: -- Default = FND_API.G_FALSE
410: -- p_commit IN VARCHAR2 Optional
411: -- Default = FND_API.G_FALSE
412: -- p_validation_level NUMBER Optional
413: -- Default = FND_API.G_VALID_LEVEL_FULL
407: -- IN p_api_version IN NUMBER Required
408: -- p_init_msg_list IN VARCHAR2 Optional
409: -- Default = FND_API.G_FALSE
410: -- p_commit IN VARCHAR2 Optional
411: -- Default = FND_API.G_FALSE
412: -- p_validation_level NUMBER Optional
413: -- Default = FND_API.G_VALID_LEVEL_FULL
414: -- p_channel_id IN NUMBER Optional
415: -- the channel id. Default = FND_API.G_MISS_NUM
409: -- Default = FND_API.G_FALSE
410: -- p_commit IN VARCHAR2 Optional
411: -- Default = FND_API.G_FALSE
412: -- p_validation_level NUMBER Optional
413: -- Default = FND_API.G_VALID_LEVEL_FULL
414: -- p_channel_id IN NUMBER Optional
415: -- the channel id. Default = FND_API.G_MISS_NUM
416: -- p_channel_name IN VARCHAR2 Optional
417: -- the channel name. Default = FND_API.G_MISS_CHAR
411: -- Default = FND_API.G_FALSE
412: -- p_validation_level NUMBER Optional
413: -- Default = FND_API.G_VALID_LEVEL_FULL
414: -- p_channel_id IN NUMBER Optional
415: -- the channel id. Default = FND_API.G_MISS_NUM
416: -- p_channel_name IN VARCHAR2 Optional
417: -- the channel name. Default = FND_API.G_MISS_CHAR
418: -- Either pass the channe id (preferred) or channel name
419: -- to identify the channel.
413: -- Default = FND_API.G_VALID_LEVEL_FULL
414: -- p_channel_id IN NUMBER Optional
415: -- the channel id. Default = FND_API.G_MISS_NUM
416: -- p_channel_name IN VARCHAR2 Optional
417: -- the channel name. Default = FND_API.G_MISS_CHAR
418: -- Either pass the channe id (preferred) or channel name
419: -- to identify the channel.
420: -- p_category_id IN NUMBER Optional
421: -- the category id. Default = FND_API.G_MISS_NUM
417: -- the channel name. Default = FND_API.G_MISS_CHAR
418: -- Either pass the channe id (preferred) or channel name
419: -- to identify the channel.
420: -- p_category_id IN NUMBER Optional
421: -- the category id. Default = FND_API.G_MISS_NUM
422: -- p_content_type_id_array IN AMV_NUMBER_VARRAY_TYPE
423: -- OUT : x_return_status OUT VARCHAR2
424: -- x_msg_count OUT NUMBER
425: -- x_msg_data OUT VARCHAR2
431: -- End of comments
432: --
433: PROCEDURE Set_ChannelContentTypes
434: ( p_api_version IN NUMBER,
435: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
436: p_commit IN VARCHAR2 := FND_API.G_FALSE,
437: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
438: x_return_status OUT NOCOPY VARCHAR2,
439: x_msg_count OUT NOCOPY NUMBER,
432: --
433: PROCEDURE Set_ChannelContentTypes
434: ( p_api_version IN NUMBER,
435: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
436: p_commit IN VARCHAR2 := FND_API.G_FALSE,
437: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
438: x_return_status OUT NOCOPY VARCHAR2,
439: x_msg_count OUT NOCOPY NUMBER,
440: x_msg_data OUT NOCOPY VARCHAR2,
433: PROCEDURE Set_ChannelContentTypes
434: ( p_api_version IN NUMBER,
435: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
436: p_commit IN VARCHAR2 := FND_API.G_FALSE,
437: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
438: x_return_status OUT NOCOPY VARCHAR2,
439: x_msg_count OUT NOCOPY NUMBER,
440: x_msg_data OUT NOCOPY VARCHAR2,
441: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
437: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
438: x_return_status OUT NOCOPY VARCHAR2,
439: x_msg_count OUT NOCOPY NUMBER,
440: x_msg_data OUT NOCOPY VARCHAR2,
441: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
442: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
443: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
444: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
445: p_content_type_id_array IN AMV_NUMBER_VARRAY_TYPE
438: x_return_status OUT NOCOPY VARCHAR2,
439: x_msg_count OUT NOCOPY NUMBER,
440: x_msg_data OUT NOCOPY VARCHAR2,
441: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
442: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
443: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
444: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
445: p_content_type_id_array IN AMV_NUMBER_VARRAY_TYPE
446: );
439: x_msg_count OUT NOCOPY NUMBER,
440: x_msg_data OUT NOCOPY VARCHAR2,
441: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
442: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
443: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
444: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
445: p_content_type_id_array IN AMV_NUMBER_VARRAY_TYPE
446: );
447: --------------------------------------------------------------------------------
440: x_msg_data OUT NOCOPY VARCHAR2,
441: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
442: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
443: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
444: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
445: p_content_type_id_array IN AMV_NUMBER_VARRAY_TYPE
446: );
447: --------------------------------------------------------------------------------
448: -- Start of comments
452: -- Function : Get content categories of the content channel.
453: -- Parameters :
454: -- IN p_api_version IN NUMBER Required
455: -- p_init_msg_list IN VARCHAR2 Optional
456: -- Default = FND_API.G_FALSE
457: -- p_validation_level NUMBER Optional
458: -- Default = FND_API.G_VALID_LEVEL_FULL
459: -- p_channel_id IN NUMBER Optional
460: -- the channel id. Default = FND_API.G_MISS_NUM
454: -- IN p_api_version IN NUMBER Required
455: -- p_init_msg_list IN VARCHAR2 Optional
456: -- Default = FND_API.G_FALSE
457: -- p_validation_level NUMBER Optional
458: -- Default = FND_API.G_VALID_LEVEL_FULL
459: -- p_channel_id IN NUMBER Optional
460: -- the channel id. Default = FND_API.G_MISS_NUM
461: -- p_channel_name IN VARCHAR2 Optional
462: -- the channel name. Default = FND_API.G_MISS_CHAR
456: -- Default = FND_API.G_FALSE
457: -- p_validation_level NUMBER Optional
458: -- Default = FND_API.G_VALID_LEVEL_FULL
459: -- p_channel_id IN NUMBER Optional
460: -- the channel id. Default = FND_API.G_MISS_NUM
461: -- p_channel_name IN VARCHAR2 Optional
462: -- the channel name. Default = FND_API.G_MISS_CHAR
463: -- Either pass the channe id (preferred) or channel name
464: -- to identify the channel.
458: -- Default = FND_API.G_VALID_LEVEL_FULL
459: -- p_channel_id IN NUMBER Optional
460: -- the channel id. Default = FND_API.G_MISS_NUM
461: -- p_channel_name IN VARCHAR2 Optional
462: -- the channel name. Default = FND_API.G_MISS_CHAR
463: -- Either pass the channe id (preferred) or channel name
464: -- to identify the channel.
465: -- p_category_id IN NUMBER Optional
466: -- the category id. Default = FND_API.G_MISS_NUM
462: -- the channel name. Default = FND_API.G_MISS_CHAR
463: -- Either pass the channe id (preferred) or channel name
464: -- to identify the channel.
465: -- p_category_id IN NUMBER Optional
466: -- the category id. Default = FND_API.G_MISS_NUM
467: -- OUT : x_return_status OUT VARCHAR2
468: -- x_msg_count OUT NUMBER
469: -- x_msg_data OUT VARCHAR2
470: -- x_content_type_id_array OUT AMV_NUMBER_VARRAY_TYPE
476: -- End of comments
477: --
478: PROCEDURE Get_ChannelContentTypes
479: ( p_api_version IN NUMBER,
480: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
481: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
482: x_return_status OUT NOCOPY VARCHAR2,
483: x_msg_count OUT NOCOPY NUMBER,
484: x_msg_data OUT NOCOPY VARCHAR2,
477: --
478: PROCEDURE Get_ChannelContentTypes
479: ( p_api_version IN NUMBER,
480: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
481: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
482: x_return_status OUT NOCOPY VARCHAR2,
483: x_msg_count OUT NOCOPY NUMBER,
484: x_msg_data OUT NOCOPY VARCHAR2,
485: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
481: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
482: x_return_status OUT NOCOPY VARCHAR2,
483: x_msg_count OUT NOCOPY NUMBER,
484: x_msg_data OUT NOCOPY VARCHAR2,
485: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
486: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
487: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
488: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
489: x_content_type_id_array OUT NOCOPY AMV_NUMBER_VARRAY_TYPE
482: x_return_status OUT NOCOPY VARCHAR2,
483: x_msg_count OUT NOCOPY NUMBER,
484: x_msg_data OUT NOCOPY VARCHAR2,
485: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
486: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
487: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
488: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
489: x_content_type_id_array OUT NOCOPY AMV_NUMBER_VARRAY_TYPE
490: );
483: x_msg_count OUT NOCOPY NUMBER,
484: x_msg_data OUT NOCOPY VARCHAR2,
485: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
486: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
487: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
488: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
489: x_content_type_id_array OUT NOCOPY AMV_NUMBER_VARRAY_TYPE
490: );
491: --------------------------------------------------------------------------------
484: x_msg_data OUT NOCOPY VARCHAR2,
485: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
486: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
487: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
488: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
489: x_content_type_id_array OUT NOCOPY AMV_NUMBER_VARRAY_TYPE
490: );
491: --------------------------------------------------------------------------------
492: -- Start of comments
496: -- Function : Change perspectives of the content channel.
497: -- Parameters :
498: -- IN p_api_version IN NUMBER Required
499: -- p_init_msg_list IN VARCHAR2 Optional
500: -- Default = FND_API.G_FALSE
501: -- p_commit IN VARCHAR2 Optional
502: -- Default = FND_API.G_FALSE
503: -- p_validation_level NUMBER Optional
504: -- Default = FND_API.G_VALID_LEVEL_FULL
498: -- IN p_api_version IN NUMBER Required
499: -- p_init_msg_list IN VARCHAR2 Optional
500: -- Default = FND_API.G_FALSE
501: -- p_commit IN VARCHAR2 Optional
502: -- Default = FND_API.G_FALSE
503: -- p_validation_level NUMBER Optional
504: -- Default = FND_API.G_VALID_LEVEL_FULL
505: -- p_channel_id IN NUMBER Optional
506: -- the channel id. Default = FND_API.G_MISS_NUM
500: -- Default = FND_API.G_FALSE
501: -- p_commit IN VARCHAR2 Optional
502: -- Default = FND_API.G_FALSE
503: -- p_validation_level NUMBER Optional
504: -- Default = FND_API.G_VALID_LEVEL_FULL
505: -- p_channel_id IN NUMBER Optional
506: -- the channel id. Default = FND_API.G_MISS_NUM
507: -- p_channel_name IN VARCHAR2 Optional
508: -- the channel name. Default = FND_API.G_MISS_CHAR
502: -- Default = FND_API.G_FALSE
503: -- p_validation_level NUMBER Optional
504: -- Default = FND_API.G_VALID_LEVEL_FULL
505: -- p_channel_id IN NUMBER Optional
506: -- the channel id. Default = FND_API.G_MISS_NUM
507: -- p_channel_name IN VARCHAR2 Optional
508: -- the channel name. Default = FND_API.G_MISS_CHAR
509: -- Either pass the channe id (preferred) or channel name
510: -- to identify the channel.
504: -- Default = FND_API.G_VALID_LEVEL_FULL
505: -- p_channel_id IN NUMBER Optional
506: -- the channel id. Default = FND_API.G_MISS_NUM
507: -- p_channel_name IN VARCHAR2 Optional
508: -- the channel name. Default = FND_API.G_MISS_CHAR
509: -- Either pass the channe id (preferred) or channel name
510: -- to identify the channel.
511: -- p_category_id IN NUMBER Optional
512: -- the category id. Default = FND_API.G_MISS_NUM
508: -- the channel name. Default = FND_API.G_MISS_CHAR
509: -- Either pass the channe id (preferred) or channel name
510: -- to identify the channel.
511: -- p_category_id IN NUMBER Optional
512: -- the category id. Default = FND_API.G_MISS_NUM
513: -- p_perspective_id_array IN AMV_NUMBER_VARRAY_TYPE
514: -- OUT : x_return_status OUT VARCHAR2
515: -- x_msg_count OUT NUMBER
516: -- x_msg_data OUT VARCHAR2
522: -- End of comments
523: --
524: PROCEDURE Set_ChannelPerspectives
525: ( p_api_version IN NUMBER,
526: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
527: p_commit IN VARCHAR2 := FND_API.G_FALSE,
528: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
529: x_return_status OUT NOCOPY VARCHAR2,
530: x_msg_count OUT NOCOPY NUMBER,
523: --
524: PROCEDURE Set_ChannelPerspectives
525: ( p_api_version IN NUMBER,
526: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
527: p_commit IN VARCHAR2 := FND_API.G_FALSE,
528: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
529: x_return_status OUT NOCOPY VARCHAR2,
530: x_msg_count OUT NOCOPY NUMBER,
531: x_msg_data OUT NOCOPY VARCHAR2,
524: PROCEDURE Set_ChannelPerspectives
525: ( p_api_version IN NUMBER,
526: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
527: p_commit IN VARCHAR2 := FND_API.G_FALSE,
528: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
529: x_return_status OUT NOCOPY VARCHAR2,
530: x_msg_count OUT NOCOPY NUMBER,
531: x_msg_data OUT NOCOPY VARCHAR2,
532: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
528: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
529: x_return_status OUT NOCOPY VARCHAR2,
530: x_msg_count OUT NOCOPY NUMBER,
531: x_msg_data OUT NOCOPY VARCHAR2,
532: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
533: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
534: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
535: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
536: p_perspective_id_array IN AMV_NUMBER_VARRAY_TYPE
529: x_return_status OUT NOCOPY VARCHAR2,
530: x_msg_count OUT NOCOPY NUMBER,
531: x_msg_data OUT NOCOPY VARCHAR2,
532: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
533: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
534: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
535: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
536: p_perspective_id_array IN AMV_NUMBER_VARRAY_TYPE
537: );
530: x_msg_count OUT NOCOPY NUMBER,
531: x_msg_data OUT NOCOPY VARCHAR2,
532: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
533: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
534: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
535: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
536: p_perspective_id_array IN AMV_NUMBER_VARRAY_TYPE
537: );
538: --------------------------------------------------------------------------------
531: x_msg_data OUT NOCOPY VARCHAR2,
532: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
533: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
534: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
535: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
536: p_perspective_id_array IN AMV_NUMBER_VARRAY_TYPE
537: );
538: --------------------------------------------------------------------------------
539: -- Start of comments
543: -- Function : Get perspectives of the content channel.
544: -- Parameters :
545: -- IN p_api_version IN NUMBER Required
546: -- p_init_msg_list IN VARCHAR2 Optional
547: -- Default = FND_API.G_FALSE
548: -- p_validation_level NUMBER Optional
549: -- Default = FND_API.G_VALID_LEVEL_FULL
550: -- p_channel_id IN NUMBER Optional
551: -- the channel id. Default = FND_API.G_MISS_NUM
545: -- IN p_api_version IN NUMBER Required
546: -- p_init_msg_list IN VARCHAR2 Optional
547: -- Default = FND_API.G_FALSE
548: -- p_validation_level NUMBER Optional
549: -- Default = FND_API.G_VALID_LEVEL_FULL
550: -- p_channel_id IN NUMBER Optional
551: -- the channel id. Default = FND_API.G_MISS_NUM
552: -- p_channel_name IN VARCHAR2 Optional
553: -- the channel name. Default = FND_API.G_MISS_CHAR
547: -- Default = FND_API.G_FALSE
548: -- p_validation_level NUMBER Optional
549: -- Default = FND_API.G_VALID_LEVEL_FULL
550: -- p_channel_id IN NUMBER Optional
551: -- the channel id. Default = FND_API.G_MISS_NUM
552: -- p_channel_name IN VARCHAR2 Optional
553: -- the channel name. Default = FND_API.G_MISS_CHAR
554: -- Either pass the channe id (preferred) or channel name
555: -- to identify the channel.
549: -- Default = FND_API.G_VALID_LEVEL_FULL
550: -- p_channel_id IN NUMBER Optional
551: -- the channel id. Default = FND_API.G_MISS_NUM
552: -- p_channel_name IN VARCHAR2 Optional
553: -- the channel name. Default = FND_API.G_MISS_CHAR
554: -- Either pass the channe id (preferred) or channel name
555: -- to identify the channel.
556: -- p_category_id IN NUMBER Optional
557: -- the category id. Default = FND_API.G_MISS_NUM
553: -- the channel name. Default = FND_API.G_MISS_CHAR
554: -- Either pass the channe id (preferred) or channel name
555: -- to identify the channel.
556: -- p_category_id IN NUMBER Optional
557: -- the category id. Default = FND_API.G_MISS_NUM
558: -- OUT : x_return_status OUT VARCHAR2
559: -- x_msg_count OUT NUMBER
560: -- x_msg_data OUT VARCHAR2
561: -- x_perspective_id_array OUT AMV_NUMBER_VARRAY_TYPE
567: -- End of comments
568: --
569: PROCEDURE Get_ChannelPerspectives
570: ( p_api_version IN NUMBER,
571: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
572: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
573: x_return_status OUT NOCOPY VARCHAR2,
574: x_msg_count OUT NOCOPY NUMBER,
575: x_msg_data OUT NOCOPY VARCHAR2,
568: --
569: PROCEDURE Get_ChannelPerspectives
570: ( p_api_version IN NUMBER,
571: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
572: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
573: x_return_status OUT NOCOPY VARCHAR2,
574: x_msg_count OUT NOCOPY NUMBER,
575: x_msg_data OUT NOCOPY VARCHAR2,
576: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
572: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
573: x_return_status OUT NOCOPY VARCHAR2,
574: x_msg_count OUT NOCOPY NUMBER,
575: x_msg_data OUT NOCOPY VARCHAR2,
576: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
577: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
578: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
579: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
580: x_perspective_id_array OUT NOCOPY AMV_NUMBER_VARRAY_TYPE
573: x_return_status OUT NOCOPY VARCHAR2,
574: x_msg_count OUT NOCOPY NUMBER,
575: x_msg_data OUT NOCOPY VARCHAR2,
576: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
577: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
578: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
579: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
580: x_perspective_id_array OUT NOCOPY AMV_NUMBER_VARRAY_TYPE
581: );
574: x_msg_count OUT NOCOPY NUMBER,
575: x_msg_data OUT NOCOPY VARCHAR2,
576: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
577: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
578: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
579: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
580: x_perspective_id_array OUT NOCOPY AMV_NUMBER_VARRAY_TYPE
581: );
582: --------------------------------------------------------------------------------
575: x_msg_data OUT NOCOPY VARCHAR2,
576: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
577: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
578: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
579: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
580: x_perspective_id_array OUT NOCOPY AMV_NUMBER_VARRAY_TYPE
581: );
582: --------------------------------------------------------------------------------
583: -- Start of comments
587: -- Function : Change user groups of the content channel.
588: -- Parameters :
589: -- IN p_api_version IN NUMBER Required
590: -- p_init_msg_list IN VARCHAR2 Optional
591: -- Default = FND_API.G_FALSE
592: -- p_validation_level NUMBER Optional
593: -- Default = FND_API.G_VALID_LEVEL_FULL
594: -- p_commit IN VARCHAR2 Optional
595: -- Default = FND_API.G_FALSE
589: -- IN p_api_version IN NUMBER Required
590: -- p_init_msg_list IN VARCHAR2 Optional
591: -- Default = FND_API.G_FALSE
592: -- p_validation_level NUMBER Optional
593: -- Default = FND_API.G_VALID_LEVEL_FULL
594: -- p_commit IN VARCHAR2 Optional
595: -- Default = FND_API.G_FALSE
596: -- p_channel_id IN NUMBER Optional
597: -- the channel id. Default = FND_API.G_MISS_NUM
591: -- Default = FND_API.G_FALSE
592: -- p_validation_level NUMBER Optional
593: -- Default = FND_API.G_VALID_LEVEL_FULL
594: -- p_commit IN VARCHAR2 Optional
595: -- Default = FND_API.G_FALSE
596: -- p_channel_id IN NUMBER Optional
597: -- the channel id. Default = FND_API.G_MISS_NUM
598: -- p_channel_name IN VARCHAR2 Optional
599: -- the channel name. Default = FND_API.G_MISS_CHAR
593: -- Default = FND_API.G_VALID_LEVEL_FULL
594: -- p_commit IN VARCHAR2 Optional
595: -- Default = FND_API.G_FALSE
596: -- p_channel_id IN NUMBER Optional
597: -- the channel id. Default = FND_API.G_MISS_NUM
598: -- p_channel_name IN VARCHAR2 Optional
599: -- the channel name. Default = FND_API.G_MISS_CHAR
600: -- Either pass the channe id (preferred) or channel name
601: -- to identify the channel.
595: -- Default = FND_API.G_FALSE
596: -- p_channel_id IN NUMBER Optional
597: -- the channel id. Default = FND_API.G_MISS_NUM
598: -- p_channel_name IN VARCHAR2 Optional
599: -- the channel name. Default = FND_API.G_MISS_CHAR
600: -- Either pass the channe id (preferred) or channel name
601: -- to identify the channel.
602: -- p_category_id IN NUMBER Optional
603: -- the category id. Default = FND_API.G_MISS_NUM
599: -- the channel name. Default = FND_API.G_MISS_CHAR
600: -- Either pass the channe id (preferred) or channel name
601: -- to identify the channel.
602: -- p_category_id IN NUMBER Optional
603: -- the category id. Default = FND_API.G_MISS_NUM
604: -- p_item_type_array IN AMV_CHAR_VARRAY_TYPE
605: -- OUT : x_return_status OUT VARCHAR2
606: -- x_msg_count OUT NUMBER
607: -- x_msg_data OUT VARCHAR2
613: -- End of comments
614: --
615: PROCEDURE Set_ChannelItemTypes
616: ( p_api_version IN NUMBER,
617: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
618: p_commit IN VARCHAR2 := FND_API.G_FALSE,
619: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
620: x_return_status OUT NOCOPY VARCHAR2,
621: x_msg_count OUT NOCOPY NUMBER,
614: --
615: PROCEDURE Set_ChannelItemTypes
616: ( p_api_version IN NUMBER,
617: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
618: p_commit IN VARCHAR2 := FND_API.G_FALSE,
619: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
620: x_return_status OUT NOCOPY VARCHAR2,
621: x_msg_count OUT NOCOPY NUMBER,
622: x_msg_data OUT NOCOPY VARCHAR2,
615: PROCEDURE Set_ChannelItemTypes
616: ( p_api_version IN NUMBER,
617: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
618: p_commit IN VARCHAR2 := FND_API.G_FALSE,
619: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
620: x_return_status OUT NOCOPY VARCHAR2,
621: x_msg_count OUT NOCOPY NUMBER,
622: x_msg_data OUT NOCOPY VARCHAR2,
623: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
619: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
620: x_return_status OUT NOCOPY VARCHAR2,
621: x_msg_count OUT NOCOPY NUMBER,
622: x_msg_data OUT NOCOPY VARCHAR2,
623: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
624: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
625: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
626: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
627: p_item_type_array IN AMV_CHAR_VARRAY_TYPE
620: x_return_status OUT NOCOPY VARCHAR2,
621: x_msg_count OUT NOCOPY NUMBER,
622: x_msg_data OUT NOCOPY VARCHAR2,
623: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
624: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
625: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
626: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
627: p_item_type_array IN AMV_CHAR_VARRAY_TYPE
628: );
621: x_msg_count OUT NOCOPY NUMBER,
622: x_msg_data OUT NOCOPY VARCHAR2,
623: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
624: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
625: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
626: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
627: p_item_type_array IN AMV_CHAR_VARRAY_TYPE
628: );
629: --------------------------------------------------------------------------------
622: x_msg_data OUT NOCOPY VARCHAR2,
623: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
624: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
625: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
626: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
627: p_item_type_array IN AMV_CHAR_VARRAY_TYPE
628: );
629: --------------------------------------------------------------------------------
630: -- Start of comments
634: -- Function : Get user groups of the content channel.
635: -- Parameters :
636: -- IN p_api_version IN NUMBER Required
637: -- p_init_msg_list IN VARCHAR2 Optional
638: -- Default = FND_API.G_FALSE
639: -- p_validation_level NUMBER Optional
640: -- Default = FND_API.G_VALID_LEVEL_FULL
641: -- p_channel_id IN NUMBER Optional
642: -- the channel id. Default = FND_API.G_MISS_NUM
636: -- IN p_api_version IN NUMBER Required
637: -- p_init_msg_list IN VARCHAR2 Optional
638: -- Default = FND_API.G_FALSE
639: -- p_validation_level NUMBER Optional
640: -- Default = FND_API.G_VALID_LEVEL_FULL
641: -- p_channel_id IN NUMBER Optional
642: -- the channel id. Default = FND_API.G_MISS_NUM
643: -- p_channel_name IN VARCHAR2 Optional
644: -- the channel name. Default = FND_API.G_MISS_CHAR
638: -- Default = FND_API.G_FALSE
639: -- p_validation_level NUMBER Optional
640: -- Default = FND_API.G_VALID_LEVEL_FULL
641: -- p_channel_id IN NUMBER Optional
642: -- the channel id. Default = FND_API.G_MISS_NUM
643: -- p_channel_name IN VARCHAR2 Optional
644: -- the channel name. Default = FND_API.G_MISS_CHAR
645: -- Either pass the channe id (preferred) or channel name
646: -- to identify the channel.
640: -- Default = FND_API.G_VALID_LEVEL_FULL
641: -- p_channel_id IN NUMBER Optional
642: -- the channel id. Default = FND_API.G_MISS_NUM
643: -- p_channel_name IN VARCHAR2 Optional
644: -- the channel name. Default = FND_API.G_MISS_CHAR
645: -- Either pass the channe id (preferred) or channel name
646: -- to identify the channel.
647: -- p_category_id IN NUMBER Optional
648: -- the category id. Default = FND_API.G_MISS_NUM
644: -- the channel name. Default = FND_API.G_MISS_CHAR
645: -- Either pass the channe id (preferred) or channel name
646: -- to identify the channel.
647: -- p_category_id IN NUMBER Optional
648: -- the category id. Default = FND_API.G_MISS_NUM
649: -- OUT : x_return_status OUT VARCHAR2
650: -- x_msg_count OUT NUMBER
651: -- x_msg_data OUT VARCHAR2
652: -- x_item_type_array OUT AMV_CHAR_VARRAY_TYPE
658: -- End of comments
659: --
660: PROCEDURE Get_ChannelItemTypes
661: ( p_api_version IN NUMBER,
662: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
663: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
664: x_return_status OUT NOCOPY VARCHAR2,
665: x_msg_count OUT NOCOPY NUMBER,
666: x_msg_data OUT NOCOPY VARCHAR2,
659: --
660: PROCEDURE Get_ChannelItemTypes
661: ( p_api_version IN NUMBER,
662: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
663: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
664: x_return_status OUT NOCOPY VARCHAR2,
665: x_msg_count OUT NOCOPY NUMBER,
666: x_msg_data OUT NOCOPY VARCHAR2,
667: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
663: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
664: x_return_status OUT NOCOPY VARCHAR2,
665: x_msg_count OUT NOCOPY NUMBER,
666: x_msg_data OUT NOCOPY VARCHAR2,
667: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
668: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
669: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
670: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
671: x_item_type_array OUT NOCOPY AMV_CHAR_VARRAY_TYPE
664: x_return_status OUT NOCOPY VARCHAR2,
665: x_msg_count OUT NOCOPY NUMBER,
666: x_msg_data OUT NOCOPY VARCHAR2,
667: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
668: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
669: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
670: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
671: x_item_type_array OUT NOCOPY AMV_CHAR_VARRAY_TYPE
672: );
665: x_msg_count OUT NOCOPY NUMBER,
666: x_msg_data OUT NOCOPY VARCHAR2,
667: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
668: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
669: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
670: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
671: x_item_type_array OUT NOCOPY AMV_CHAR_VARRAY_TYPE
672: );
673: --------------------------------------------------------------------------------
666: x_msg_data OUT NOCOPY VARCHAR2,
667: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
668: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
669: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
670: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
671: x_item_type_array OUT NOCOPY AMV_CHAR_VARRAY_TYPE
672: );
673: --------------------------------------------------------------------------------
674: -- Start of comments
678: -- Function : Change keywords 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_keywords_array IN AMV_CHAR_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_ChannelKeywords
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_ChannelKeywords
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_ChannelKeywords
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_keywords_array IN AMV_CHAR_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_keywords_array IN AMV_CHAR_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_keywords_array IN AMV_CHAR_VARRAY_TYPE
719: );
720: --------------------------------------------------------------------------------
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_keywords_array IN AMV_CHAR_VARRAY_TYPE
719: );
720: --------------------------------------------------------------------------------
721: -- Start of comments
725: -- Function : Get keywords of the content channel.
726: -- Parameters :
727: -- IN p_api_version IN NUMBER Required
728: -- p_init_msg_list IN VARCHAR2 Optional
729: -- Default = FND_API.G_FALSE
730: -- p_validation_level NUMBER Optional
731: -- Default = FND_API.G_VALID_LEVEL_FULL
732: -- p_channel_id IN NUMBER Optional
733: -- the channel id. Default = FND_API.G_MISS_NUM
727: -- IN p_api_version IN NUMBER Required
728: -- p_init_msg_list IN VARCHAR2 Optional
729: -- Default = FND_API.G_FALSE
730: -- p_validation_level NUMBER Optional
731: -- Default = FND_API.G_VALID_LEVEL_FULL
732: -- p_channel_id IN NUMBER Optional
733: -- the channel id. Default = FND_API.G_MISS_NUM
734: -- p_channel_name IN VARCHAR2 Optional
735: -- the channel name. Default = FND_API.G_MISS_CHAR
729: -- Default = FND_API.G_FALSE
730: -- p_validation_level NUMBER Optional
731: -- Default = FND_API.G_VALID_LEVEL_FULL
732: -- p_channel_id IN NUMBER Optional
733: -- the channel id. Default = FND_API.G_MISS_NUM
734: -- p_channel_name IN VARCHAR2 Optional
735: -- the channel name. Default = FND_API.G_MISS_CHAR
736: -- Either pass the channe id (preferred) or channel name
737: -- to identify the channel.
731: -- Default = FND_API.G_VALID_LEVEL_FULL
732: -- p_channel_id IN NUMBER Optional
733: -- the channel id. Default = FND_API.G_MISS_NUM
734: -- p_channel_name IN VARCHAR2 Optional
735: -- the channel name. Default = FND_API.G_MISS_CHAR
736: -- Either pass the channe id (preferred) or channel name
737: -- to identify the channel.
738: -- p_category_id IN NUMBER Optional
739: -- the category id. Default = FND_API.G_MISS_NUM
735: -- the channel name. Default = FND_API.G_MISS_CHAR
736: -- Either pass the channe id (preferred) or channel name
737: -- to identify the channel.
738: -- p_category_id IN NUMBER Optional
739: -- the category id. Default = FND_API.G_MISS_NUM
740: -- OUT : x_return_status OUT VARCHAR2
741: -- x_msg_count OUT NUMBER
742: -- x_msg_data OUT VARCHAR2
743: -- x_keywords_array OUT AMV_CHAR_VARRAY_TYPE
749: -- End of comments
750: --
751: PROCEDURE Get_ChannelKeywords
752: ( p_api_version IN NUMBER,
753: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
754: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
755: x_return_status OUT NOCOPY VARCHAR2,
756: x_msg_count OUT NOCOPY NUMBER,
757: x_msg_data OUT NOCOPY VARCHAR2,
750: --
751: PROCEDURE Get_ChannelKeywords
752: ( p_api_version IN NUMBER,
753: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
754: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
755: x_return_status OUT NOCOPY VARCHAR2,
756: x_msg_count OUT NOCOPY NUMBER,
757: x_msg_data OUT NOCOPY VARCHAR2,
758: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
754: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
755: x_return_status OUT NOCOPY VARCHAR2,
756: x_msg_count OUT NOCOPY NUMBER,
757: x_msg_data OUT NOCOPY VARCHAR2,
758: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
759: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
760: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
761: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
762: x_keywords_array OUT NOCOPY AMV_CHAR_VARRAY_TYPE
755: x_return_status OUT NOCOPY VARCHAR2,
756: x_msg_count OUT NOCOPY NUMBER,
757: x_msg_data OUT NOCOPY VARCHAR2,
758: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
759: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
760: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
761: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
762: x_keywords_array OUT NOCOPY AMV_CHAR_VARRAY_TYPE
763: );
756: x_msg_count OUT NOCOPY NUMBER,
757: x_msg_data OUT NOCOPY VARCHAR2,
758: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
759: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
760: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
761: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
762: x_keywords_array OUT NOCOPY AMV_CHAR_VARRAY_TYPE
763: );
764: --------------------------------------------------------------------------------
757: x_msg_data OUT NOCOPY VARCHAR2,
758: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
759: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
760: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
761: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
762: x_keywords_array OUT NOCOPY AMV_CHAR_VARRAY_TYPE
763: );
764: --------------------------------------------------------------------------------
765: -- Start of comments
769: -- Function : Change authors of the content channel.
770: -- Parameters :
771: -- IN p_api_version IN NUMBER Required
772: -- p_init_msg_list IN VARCHAR2 Optional
773: -- Default = FND_API.G_FALSE
774: -- p_commit IN VARCHAR2 Optional
775: -- Default = FND_API.G_FALSE
776: -- p_validation_level NUMBER Optional
777: -- Default = FND_API.G_VALID_LEVEL_FULL
771: -- IN p_api_version IN NUMBER Required
772: -- p_init_msg_list IN VARCHAR2 Optional
773: -- Default = FND_API.G_FALSE
774: -- p_commit IN VARCHAR2 Optional
775: -- Default = FND_API.G_FALSE
776: -- p_validation_level NUMBER Optional
777: -- Default = FND_API.G_VALID_LEVEL_FULL
778: -- p_channel_id IN NUMBER Optional
779: -- the channel id. Default = FND_API.G_MISS_NUM
773: -- Default = FND_API.G_FALSE
774: -- p_commit IN VARCHAR2 Optional
775: -- Default = FND_API.G_FALSE
776: -- p_validation_level NUMBER Optional
777: -- Default = FND_API.G_VALID_LEVEL_FULL
778: -- p_channel_id IN NUMBER Optional
779: -- the channel id. Default = FND_API.G_MISS_NUM
780: -- p_channel_name IN VARCHAR2 Optional
781: -- the channel name. Default = FND_API.G_MISS_CHAR
775: -- Default = FND_API.G_FALSE
776: -- p_validation_level NUMBER Optional
777: -- Default = FND_API.G_VALID_LEVEL_FULL
778: -- p_channel_id IN NUMBER Optional
779: -- the channel id. Default = FND_API.G_MISS_NUM
780: -- p_channel_name IN VARCHAR2 Optional
781: -- the channel name. Default = FND_API.G_MISS_CHAR
782: -- Either pass the channe id (preferred) or channel name
783: -- to identify the channel.
777: -- Default = FND_API.G_VALID_LEVEL_FULL
778: -- p_channel_id IN NUMBER Optional
779: -- the channel id. Default = FND_API.G_MISS_NUM
780: -- p_channel_name IN VARCHAR2 Optional
781: -- the channel name. Default = FND_API.G_MISS_CHAR
782: -- Either pass the channe id (preferred) or channel name
783: -- to identify the channel.
784: -- p_category_id IN NUMBER Optional
785: -- the category id. Default = FND_API.G_MISS_NUM
781: -- the channel name. Default = FND_API.G_MISS_CHAR
782: -- Either pass the channe id (preferred) or channel name
783: -- to identify the channel.
784: -- p_category_id IN NUMBER Optional
785: -- the category id. Default = FND_API.G_MISS_NUM
786: -- p_authors_array IN AMV_CHAR_VARRAY_TYPE
787: -- OUT : x_return_status OUT VARCHAR2
788: -- x_msg_count OUT NUMBER
789: -- x_msg_data OUT VARCHAR2
795: -- End of comments
796: --
797: PROCEDURE Set_ChannelAuthors
798: ( p_api_version IN NUMBER,
799: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
800: p_commit IN VARCHAR2 := FND_API.G_FALSE,
801: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
802: x_return_status OUT NOCOPY VARCHAR2,
803: x_msg_count OUT NOCOPY NUMBER,
796: --
797: PROCEDURE Set_ChannelAuthors
798: ( p_api_version IN NUMBER,
799: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
800: p_commit IN VARCHAR2 := FND_API.G_FALSE,
801: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
802: x_return_status OUT NOCOPY VARCHAR2,
803: x_msg_count OUT NOCOPY NUMBER,
804: x_msg_data OUT NOCOPY VARCHAR2,
797: PROCEDURE Set_ChannelAuthors
798: ( p_api_version IN NUMBER,
799: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
800: p_commit IN VARCHAR2 := FND_API.G_FALSE,
801: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
802: x_return_status OUT NOCOPY VARCHAR2,
803: x_msg_count OUT NOCOPY NUMBER,
804: x_msg_data OUT NOCOPY VARCHAR2,
805: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
801: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
802: x_return_status OUT NOCOPY VARCHAR2,
803: x_msg_count OUT NOCOPY NUMBER,
804: x_msg_data OUT NOCOPY VARCHAR2,
805: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
806: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
807: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
808: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
809: p_authors_array IN AMV_CHAR_VARRAY_TYPE
802: x_return_status OUT NOCOPY VARCHAR2,
803: x_msg_count OUT NOCOPY NUMBER,
804: x_msg_data OUT NOCOPY VARCHAR2,
805: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
806: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
807: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
808: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
809: p_authors_array IN AMV_CHAR_VARRAY_TYPE
810: );
803: x_msg_count OUT NOCOPY NUMBER,
804: x_msg_data OUT NOCOPY VARCHAR2,
805: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
806: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
807: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
808: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
809: p_authors_array IN AMV_CHAR_VARRAY_TYPE
810: );
811: --------------------------------------------------------------------------------
804: x_msg_data OUT NOCOPY VARCHAR2,
805: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
806: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
807: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
808: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
809: p_authors_array IN AMV_CHAR_VARRAY_TYPE
810: );
811: --------------------------------------------------------------------------------
812: -- Start of comments
816: -- Function : Get authors of the content channel.
817: -- Parameters :
818: -- IN p_api_version IN NUMBER Required
819: -- p_init_msg_list IN VARCHAR2 Optional
820: -- Default = FND_API.G_FALSE
821: -- p_validation_level NUMBER Optional
822: -- Default = FND_API.G_VALID_LEVEL_FULL
823: -- p_channel_id IN NUMBER Optional
824: -- the channel id. Default = FND_API.G_MISS_NUM
818: -- IN p_api_version IN NUMBER Required
819: -- p_init_msg_list IN VARCHAR2 Optional
820: -- Default = FND_API.G_FALSE
821: -- p_validation_level NUMBER Optional
822: -- Default = FND_API.G_VALID_LEVEL_FULL
823: -- p_channel_id IN NUMBER Optional
824: -- the channel id. Default = FND_API.G_MISS_NUM
825: -- p_channel_name IN VARCHAR2 Optional
826: -- the channel name. Default = FND_API.G_MISS_CHAR
820: -- Default = FND_API.G_FALSE
821: -- p_validation_level NUMBER Optional
822: -- Default = FND_API.G_VALID_LEVEL_FULL
823: -- p_channel_id IN NUMBER Optional
824: -- the channel id. Default = FND_API.G_MISS_NUM
825: -- p_channel_name IN VARCHAR2 Optional
826: -- the channel name. Default = FND_API.G_MISS_CHAR
827: -- Either pass the channe id (preferred) or channel name
828: -- to identify the channel.
822: -- Default = FND_API.G_VALID_LEVEL_FULL
823: -- p_channel_id IN NUMBER Optional
824: -- the channel id. Default = FND_API.G_MISS_NUM
825: -- p_channel_name IN VARCHAR2 Optional
826: -- the channel name. Default = FND_API.G_MISS_CHAR
827: -- Either pass the channe id (preferred) or channel name
828: -- to identify the channel.
829: -- p_category_id IN NUMBER Optional
830: -- the category id. Default = FND_API.G_MISS_NUM
826: -- the channel name. Default = FND_API.G_MISS_CHAR
827: -- Either pass the channe id (preferred) or channel name
828: -- to identify the channel.
829: -- p_category_id IN NUMBER Optional
830: -- the category id. Default = FND_API.G_MISS_NUM
831: -- OUT : x_return_status OUT VARCHAR2
832: -- x_msg_count OUT NUMBER
833: -- x_msg_data OUT VARCHAR2
834: -- x_authors_array OUT AMV_CHAR_VARRAY_TYPE
840: -- End of comments
841: --
842: PROCEDURE Get_ChannelAuthors
843: ( p_api_version IN NUMBER,
844: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
845: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
846: x_return_status OUT NOCOPY VARCHAR2,
847: x_msg_count OUT NOCOPY NUMBER,
848: x_msg_data OUT NOCOPY VARCHAR2,
841: --
842: PROCEDURE Get_ChannelAuthors
843: ( p_api_version IN NUMBER,
844: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
845: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
846: x_return_status OUT NOCOPY VARCHAR2,
847: x_msg_count OUT NOCOPY NUMBER,
848: x_msg_data OUT NOCOPY VARCHAR2,
849: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
845: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
846: x_return_status OUT NOCOPY VARCHAR2,
847: x_msg_count OUT NOCOPY NUMBER,
848: x_msg_data OUT NOCOPY VARCHAR2,
849: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
850: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
851: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
852: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
853: x_authors_array OUT NOCOPY AMV_CHAR_VARRAY_TYPE
846: x_return_status OUT NOCOPY VARCHAR2,
847: x_msg_count OUT NOCOPY NUMBER,
848: x_msg_data OUT NOCOPY VARCHAR2,
849: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
850: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
851: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
852: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
853: x_authors_array OUT NOCOPY AMV_CHAR_VARRAY_TYPE
854: );
847: x_msg_count OUT NOCOPY NUMBER,
848: x_msg_data OUT NOCOPY VARCHAR2,
849: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
850: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
851: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
852: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
853: x_authors_array OUT NOCOPY AMV_CHAR_VARRAY_TYPE
854: );
855: --------------------------------------------------------------------------------
848: x_msg_data OUT NOCOPY VARCHAR2,
849: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
850: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
851: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
852: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
853: x_authors_array OUT NOCOPY AMV_CHAR_VARRAY_TYPE
854: );
855: --------------------------------------------------------------------------------
856: -- Start of comments
861: -- channel id (preferred) or channel name.
862: -- Parameters :
863: -- IN p_api_version IN NUMBER Required
864: -- p_init_msg_list IN VARCHAR2 Optional
865: -- Default = FND_API.G_FALSE
866: -- p_validation_level NUMBER Optional
867: -- Default = FND_API.G_VALID_LEVEL_FULL
868: -- p_channel_id IN NUMBER Optional
869: -- the channel id. Default = FND_API.G_MISS_NUM
863: -- IN p_api_version IN NUMBER Required
864: -- p_init_msg_list IN VARCHAR2 Optional
865: -- Default = FND_API.G_FALSE
866: -- p_validation_level NUMBER Optional
867: -- Default = FND_API.G_VALID_LEVEL_FULL
868: -- p_channel_id IN NUMBER Optional
869: -- the channel id. Default = FND_API.G_MISS_NUM
870: -- p_channel_name IN VARCHAR2 Optional
871: -- the channel name. Default = FND_API.G_MISS_CHAR
865: -- Default = FND_API.G_FALSE
866: -- p_validation_level NUMBER Optional
867: -- Default = FND_API.G_VALID_LEVEL_FULL
868: -- p_channel_id IN NUMBER Optional
869: -- the channel id. Default = FND_API.G_MISS_NUM
870: -- p_channel_name IN VARCHAR2 Optional
871: -- the channel name. Default = FND_API.G_MISS_CHAR
872: -- Either pass the channe id (preferred) or channel name
873: -- to identify the channel.
867: -- Default = FND_API.G_VALID_LEVEL_FULL
868: -- p_channel_id IN NUMBER Optional
869: -- the channel id. Default = FND_API.G_MISS_NUM
870: -- p_channel_name IN VARCHAR2 Optional
871: -- the channel name. Default = FND_API.G_MISS_CHAR
872: -- Either pass the channe id (preferred) or channel name
873: -- to identify the channel.
874: -- p_category_id IN NUMBER Optional
875: -- the category id. Default = FND_API.G_MISS_NUM
871: -- the channel name. Default = FND_API.G_MISS_CHAR
872: -- Either pass the channe id (preferred) or channel name
873: -- to identify the channel.
874: -- p_category_id IN NUMBER Optional
875: -- the category id. Default = FND_API.G_MISS_NUM
876: -- p_subset_request_rec IN AMV_REQUEST_OBJ_TYPE
877: -- Required
878: -- OUT : x_return_status OUT VARCHAR2
879: -- x_msg_count OUT NUMBER
888: -- End of comments
889: --
890: PROCEDURE Get_ItemsPerChannel
891: ( p_api_version IN NUMBER,
892: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
893: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
894: x_return_status OUT NOCOPY VARCHAR2,
895: x_msg_count OUT NOCOPY NUMBER,
896: x_msg_data OUT NOCOPY VARCHAR2,
889: --
890: PROCEDURE Get_ItemsPerChannel
891: ( p_api_version IN NUMBER,
892: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
893: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
894: x_return_status OUT NOCOPY VARCHAR2,
895: x_msg_count OUT NOCOPY NUMBER,
896: x_msg_data OUT NOCOPY VARCHAR2,
897: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
893: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
894: x_return_status OUT NOCOPY VARCHAR2,
895: x_msg_count OUT NOCOPY NUMBER,
896: x_msg_data OUT NOCOPY VARCHAR2,
897: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
898: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
899: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
900: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
901: p_item_status IN VARCHAR2 := AMV_UTILITY_PVT.G_APPROVED,
894: x_return_status OUT NOCOPY VARCHAR2,
895: x_msg_count OUT NOCOPY NUMBER,
896: x_msg_data OUT NOCOPY VARCHAR2,
897: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
898: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
899: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
900: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
901: p_item_status IN VARCHAR2 := AMV_UTILITY_PVT.G_APPROVED,
902: p_subset_request_rec IN AMV_REQUEST_OBJ_TYPE,
895: x_msg_count OUT NOCOPY NUMBER,
896: x_msg_data OUT NOCOPY VARCHAR2,
897: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
898: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
899: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
900: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
901: p_item_status IN VARCHAR2 := AMV_UTILITY_PVT.G_APPROVED,
902: p_subset_request_rec IN AMV_REQUEST_OBJ_TYPE,
903: x_subset_return_rec OUT NOCOPY AMV_RETURN_OBJ_TYPE,
896: x_msg_data OUT NOCOPY VARCHAR2,
897: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
898: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
899: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
900: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
901: p_item_status IN VARCHAR2 := AMV_UTILITY_PVT.G_APPROVED,
902: p_subset_request_rec IN AMV_REQUEST_OBJ_TYPE,
903: x_subset_return_rec OUT NOCOPY AMV_RETURN_OBJ_TYPE,
904: x_document_id_array OUT NOCOPY AMV_NUMBER_VARRAY_TYPE
912: -- given a channel and a document.
913: -- Parameters :
914: -- IN p_api_version IN NUMBER Required
915: -- p_init_msg_list IN VARCHAR2 Optional
916: -- Default = FND_API.G_FALSE
917: -- p_commit IN VARCHAR2 Optional
918: -- Default = FND_API.G_FALSE
919: -- p_validation_level NUMBER Optional
920: -- Default = FND_API.G_VALID_LEVEL_FULL
914: -- IN p_api_version IN NUMBER Required
915: -- p_init_msg_list IN VARCHAR2 Optional
916: -- Default = FND_API.G_FALSE
917: -- p_commit 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: -- Default = FND_API.G_FALSE
917: -- p_commit 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: -- p_item_id IN NUMBER Required
930: -- p_approval_status IN NUMBER Required
931: -- OUT : x_return_status OUT VARCHAR2
932: -- x_msg_count OUT NUMBER
939: -- End of comments
940: --
941: PROCEDURE Set_ChannelApprovalStatus
942: ( p_api_version IN NUMBER,
943: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
944: p_commit IN VARCHAR2 := FND_API.G_FALSE,
945: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
946: x_return_status OUT NOCOPY VARCHAR2,
947: x_msg_count OUT NOCOPY NUMBER,
940: --
941: PROCEDURE Set_ChannelApprovalStatus
942: ( p_api_version IN NUMBER,
943: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
944: p_commit IN VARCHAR2 := FND_API.G_FALSE,
945: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
946: x_return_status OUT NOCOPY VARCHAR2,
947: x_msg_count OUT NOCOPY NUMBER,
948: x_msg_data OUT NOCOPY VARCHAR2,
941: PROCEDURE Set_ChannelApprovalStatus
942: ( p_api_version IN NUMBER,
943: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
944: p_commit IN VARCHAR2 := FND_API.G_FALSE,
945: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
946: x_return_status OUT NOCOPY VARCHAR2,
947: x_msg_count OUT NOCOPY NUMBER,
948: x_msg_data OUT NOCOPY VARCHAR2,
949: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
945: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
946: x_return_status OUT NOCOPY VARCHAR2,
947: x_msg_count OUT NOCOPY NUMBER,
948: x_msg_data OUT NOCOPY VARCHAR2,
949: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
950: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
951: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
952: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
953: p_item_id IN NUMBER,
946: x_return_status OUT NOCOPY VARCHAR2,
947: x_msg_count OUT NOCOPY NUMBER,
948: x_msg_data OUT NOCOPY VARCHAR2,
949: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
950: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
951: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
952: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
953: p_item_id IN NUMBER,
954: p_approval_status IN VARCHAR2
947: x_msg_count OUT NOCOPY NUMBER,
948: x_msg_data OUT NOCOPY VARCHAR2,
949: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
950: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
951: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
952: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
953: p_item_id IN NUMBER,
954: p_approval_status IN VARCHAR2
955: );
948: x_msg_data OUT NOCOPY VARCHAR2,
949: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
950: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
951: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
952: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
953: p_item_id IN NUMBER,
954: p_approval_status IN VARCHAR2
955: );
956: --------------------------------------------------------------------------------
961: -- Function : Get all documents matching the input criteria.
962: -- Parameters :
963: -- IN p_api_version IN NUMBER Required
964: -- p_init_msg_list IN VARCHAR2 Optional
965: -- Default = FND_API.G_FALSE
966: -- p_validation_level NUMBER Optional
967: -- Default = FND_API.G_VALID_LEVEL_FULL
968: -- p_criteria_rec IN
969: -- AMV_CHANNEL_OBJ_TYPE Required
963: -- IN p_api_version IN NUMBER Required
964: -- p_init_msg_list IN VARCHAR2 Optional
965: -- Default = FND_API.G_FALSE
966: -- p_validation_level NUMBER Optional
967: -- Default = FND_API.G_VALID_LEVEL_FULL
968: -- p_criteria_rec IN
969: -- AMV_CHANNEL_OBJ_TYPE Required
970: -- p_sort_by IN VARCHAR2 Optional
971: -- Default = FND_API.G_MISS_CHAR
967: -- Default = FND_API.G_VALID_LEVEL_FULL
968: -- p_criteria_rec IN
969: -- AMV_CHANNEL_OBJ_TYPE Required
970: -- p_sort_by IN VARCHAR2 Optional
971: -- Default = FND_API.G_MISS_CHAR
972: -- p_subset_request_rec IN AMV_REQUEST_OBJ_TYPE
973: -- Required
974: -- OUT : x_return_status OUT VARCHAR2
975: -- x_msg_count OUT NUMBER
984: -- End of comments
985: --
986: PROCEDURE Find_Channels
987: ( p_api_version IN NUMBER,
988: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
989: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
990: x_return_status OUT NOCOPY VARCHAR2,
991: x_msg_count OUT NOCOPY NUMBER,
992: x_msg_data OUT NOCOPY VARCHAR2,
985: --
986: PROCEDURE Find_Channels
987: ( p_api_version IN NUMBER,
988: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
989: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
990: x_return_status OUT NOCOPY VARCHAR2,
991: x_msg_count OUT NOCOPY NUMBER,
992: x_msg_data OUT NOCOPY VARCHAR2,
993: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
989: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
990: x_return_status OUT NOCOPY VARCHAR2,
991: x_msg_count OUT NOCOPY NUMBER,
992: x_msg_data OUT NOCOPY VARCHAR2,
993: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
994: p_criteria_rec IN AMV_CHANNEL_OBJ_TYPE,
995: p_sort_by IN VARCHAR2 := FND_API.G_MISS_CHAR,
996: p_subset_request_rec IN AMV_REQUEST_OBJ_TYPE,
997: x_subset_return_rec OUT NOCOPY AMV_RETURN_OBJ_TYPE,
991: x_msg_count OUT NOCOPY NUMBER,
992: x_msg_data OUT NOCOPY VARCHAR2,
993: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
994: p_criteria_rec IN AMV_CHANNEL_OBJ_TYPE,
995: p_sort_by IN VARCHAR2 := FND_API.G_MISS_CHAR,
996: p_subset_request_rec IN AMV_REQUEST_OBJ_TYPE,
997: x_subset_return_rec OUT NOCOPY AMV_RETURN_OBJ_TYPE,
998: x_content_chan_array OUT NOCOPY AMV_CHANNEL_VARRAY_TYPE
999: );