[Home] [Help]
20: -- Function : Create a new content public channel
21: -- Parameters :
22: -- IN p_api_version IN NUMBER Required
23: -- p_init_msg_list IN VARCHAR2 Optional
24: -- Default = FND_API.G_FALSE
25: -- p_commit IN VARCHAR2 Optional
26: -- Default = FND_API.G_FALSE
27: -- p_validation_level IN NUMBER Optional
28: -- Default = FND_API.G_VALID_LEVEL_FULL
22: -- IN p_api_version IN NUMBER Required
23: -- p_init_msg_list IN VARCHAR2 Optional
24: -- Default = FND_API.G_FALSE
25: -- p_commit IN VARCHAR2 Optional
26: -- Default = FND_API.G_FALSE
27: -- p_validation_level IN NUMBER Optional
28: -- Default = FND_API.G_VALID_LEVEL_FULL
29: -- p_channel_record IN AMV_CHANNEL_OBJ_TYPE Required
30: -- OUT : x_return_status OUT VARCHAR2
24: -- Default = FND_API.G_FALSE
25: -- p_commit IN VARCHAR2 Optional
26: -- Default = FND_API.G_FALSE
27: -- p_validation_level IN NUMBER Optional
28: -- Default = FND_API.G_VALID_LEVEL_FULL
29: -- p_channel_record IN AMV_CHANNEL_OBJ_TYPE Required
30: -- OUT : x_return_status OUT VARCHAR2
31: -- x_msg_count OUT NUMBER
32: -- x_msg_data OUT VARCHAR2
39: -- End of comments
40: --
41: PROCEDURE Add_PublicChannel
42: ( p_api_version IN NUMBER,
43: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
44: p_commit IN VARCHAR2 := FND_API.G_FALSE,
45: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
46: x_return_status OUT NOCOPY VARCHAR2,
47: x_msg_count OUT NOCOPY NUMBER,
40: --
41: PROCEDURE Add_PublicChannel
42: ( p_api_version IN NUMBER,
43: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
44: p_commit IN VARCHAR2 := FND_API.G_FALSE,
45: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
46: x_return_status OUT NOCOPY VARCHAR2,
47: x_msg_count OUT NOCOPY NUMBER,
48: x_msg_data OUT NOCOPY VARCHAR2,
41: PROCEDURE Add_PublicChannel
42: ( p_api_version IN NUMBER,
43: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
44: p_commit IN VARCHAR2 := FND_API.G_FALSE,
45: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
46: x_return_status OUT NOCOPY VARCHAR2,
47: x_msg_count OUT NOCOPY NUMBER,
48: x_msg_data OUT NOCOPY VARCHAR2,
49: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
45: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
46: x_return_status OUT NOCOPY VARCHAR2,
47: x_msg_count OUT NOCOPY NUMBER,
48: x_msg_data OUT NOCOPY VARCHAR2,
49: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
50: p_channel_record IN AMV_CHANNEL_PVT.AMV_CHANNEL_OBJ_TYPE,
51: x_channel_id OUT NOCOPY NUMBER
52: );
53: --------------------------------------------------------------------------------
58: -- Function : Create a new content protected channel
59: -- Parameters :
60: -- IN p_api_version IN NUMBER Required
61: -- p_init_msg_list IN VARCHAR2 Optional
62: -- Default = FND_API.G_FALSE
63: -- p_commit IN VARCHAR2 Optional
64: -- Default = FND_API.G_FALSE
65: -- p_validation_level IN NUMBER Optional
66: -- Default = FND_API.G_VALID_LEVEL_FULL
60: -- IN p_api_version IN NUMBER Required
61: -- p_init_msg_list IN VARCHAR2 Optional
62: -- Default = FND_API.G_FALSE
63: -- p_commit IN VARCHAR2 Optional
64: -- Default = FND_API.G_FALSE
65: -- p_validation_level IN NUMBER Optional
66: -- Default = FND_API.G_VALID_LEVEL_FULL
67: -- p_channel_record IN AMV_CHANNEL_OBJ_TYPE Required
68: -- OUT : x_return_status OUT VARCHAR2
62: -- Default = FND_API.G_FALSE
63: -- p_commit IN VARCHAR2 Optional
64: -- Default = FND_API.G_FALSE
65: -- p_validation_level IN NUMBER Optional
66: -- Default = FND_API.G_VALID_LEVEL_FULL
67: -- p_channel_record IN AMV_CHANNEL_OBJ_TYPE Required
68: -- OUT : x_return_status OUT VARCHAR2
69: -- x_msg_count OUT NUMBER
70: -- x_msg_data OUT VARCHAR2
77: -- End of comments
78: --
79: PROCEDURE Add_ProtectedChannel
80: ( p_api_version IN NUMBER,
81: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
82: p_commit IN VARCHAR2 := FND_API.G_FALSE,
83: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
84: x_return_status OUT NOCOPY VARCHAR2,
85: x_msg_count OUT NOCOPY NUMBER,
78: --
79: PROCEDURE Add_ProtectedChannel
80: ( p_api_version IN NUMBER,
81: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
82: p_commit IN VARCHAR2 := FND_API.G_FALSE,
83: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
84: x_return_status OUT NOCOPY VARCHAR2,
85: x_msg_count OUT NOCOPY NUMBER,
86: x_msg_data OUT NOCOPY VARCHAR2,
79: PROCEDURE Add_ProtectedChannel
80: ( p_api_version IN NUMBER,
81: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
82: p_commit IN VARCHAR2 := FND_API.G_FALSE,
83: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
84: x_return_status OUT NOCOPY VARCHAR2,
85: x_msg_count OUT NOCOPY NUMBER,
86: x_msg_data OUT NOCOPY VARCHAR2,
87: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
83: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
84: x_return_status OUT NOCOPY VARCHAR2,
85: x_msg_count OUT NOCOPY NUMBER,
86: x_msg_data OUT NOCOPY VARCHAR2,
87: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
88: p_channel_record IN AMV_CHANNEL_PVT.AMV_CHANNEL_OBJ_TYPE,
89: x_channel_id OUT NOCOPY NUMBER
90: );
91: --------------------------------------------------------------------------------
96: -- Function : Create a new content private channel
97: -- Parameters :
98: -- IN p_api_version IN NUMBER Required
99: -- p_init_msg_list IN VARCHAR2 Optional
100: -- Default = FND_API.G_FALSE
101: -- p_commit IN VARCHAR2 Optional
102: -- Default = FND_API.G_FALSE
103: -- p_validation_level IN NUMBER Optional
104: -- Default = FND_API.G_VALID_LEVEL_FULL
98: -- IN p_api_version IN NUMBER Required
99: -- p_init_msg_list IN VARCHAR2 Optional
100: -- Default = FND_API.G_FALSE
101: -- p_commit IN VARCHAR2 Optional
102: -- Default = FND_API.G_FALSE
103: -- p_validation_level IN NUMBER Optional
104: -- Default = FND_API.G_VALID_LEVEL_FULL
105: -- p_channel_record IN AMV_CHANNEL_OBJ_TYPE Required
106: -- OUT : x_return_status OUT VARCHAR2
100: -- Default = FND_API.G_FALSE
101: -- p_commit IN VARCHAR2 Optional
102: -- Default = FND_API.G_FALSE
103: -- p_validation_level IN NUMBER Optional
104: -- Default = FND_API.G_VALID_LEVEL_FULL
105: -- p_channel_record IN AMV_CHANNEL_OBJ_TYPE Required
106: -- OUT : x_return_status OUT VARCHAR2
107: -- x_msg_count OUT NUMBER
108: -- x_msg_data OUT VARCHAR2
115: -- End of comments
116: --
117: PROCEDURE Add_PrivateChannel
118: ( p_api_version IN NUMBER,
119: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
120: p_commit IN VARCHAR2 := FND_API.G_FALSE,
121: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
122: x_return_status OUT NOCOPY VARCHAR2,
123: x_msg_count OUT NOCOPY NUMBER,
116: --
117: PROCEDURE Add_PrivateChannel
118: ( p_api_version IN NUMBER,
119: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
120: p_commit IN VARCHAR2 := FND_API.G_FALSE,
121: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
122: x_return_status OUT NOCOPY VARCHAR2,
123: x_msg_count OUT NOCOPY NUMBER,
124: x_msg_data OUT NOCOPY VARCHAR2,
117: PROCEDURE Add_PrivateChannel
118: ( p_api_version IN NUMBER,
119: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
120: p_commit IN VARCHAR2 := FND_API.G_FALSE,
121: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
122: x_return_status OUT NOCOPY VARCHAR2,
123: x_msg_count OUT NOCOPY NUMBER,
124: x_msg_data OUT NOCOPY VARCHAR2,
125: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
121: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
122: x_return_status OUT NOCOPY VARCHAR2,
123: x_msg_count OUT NOCOPY NUMBER,
124: x_msg_data OUT NOCOPY VARCHAR2,
125: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
126: p_channel_record IN AMV_CHANNEL_PVT.AMV_CHANNEL_OBJ_TYPE,
127: x_channel_id OUT NOCOPY NUMBER
128: );
129: --------------------------------------------------------------------------------
134: -- Function : Create a new content protected channel
135: -- Parameters :
136: -- IN p_api_version IN NUMBER Required
137: -- p_init_msg_list IN VARCHAR2 Optional
138: -- Default = FND_API.G_FALSE
139: -- p_commit IN VARCHAR2 Optional
140: -- Default = FND_API.G_FALSE
141: -- p_validation_level IN NUMBER Optional
142: -- Default = FND_API.G_VALID_LEVEL_FULL
136: -- IN p_api_version IN NUMBER Required
137: -- p_init_msg_list IN VARCHAR2 Optional
138: -- Default = FND_API.G_FALSE
139: -- p_commit IN VARCHAR2 Optional
140: -- Default = FND_API.G_FALSE
141: -- p_validation_level IN NUMBER Optional
142: -- Default = FND_API.G_VALID_LEVEL_FULL
143: -- p_channel_record IN AMV_CHANNEL_OBJ_TYPE Required
144: -- OUT : x_return_status OUT VARCHAR2
138: -- Default = FND_API.G_FALSE
139: -- p_commit IN VARCHAR2 Optional
140: -- Default = FND_API.G_FALSE
141: -- p_validation_level IN NUMBER Optional
142: -- Default = FND_API.G_VALID_LEVEL_FULL
143: -- p_channel_record IN AMV_CHANNEL_OBJ_TYPE Required
144: -- OUT : x_return_status OUT VARCHAR2
145: -- x_msg_count OUT NUMBER
146: -- x_msg_data OUT VARCHAR2
153: -- End of comments
154: --
155: PROCEDURE Add_GroupChannel
156: ( p_api_version IN NUMBER,
157: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
158: p_commit IN VARCHAR2 := FND_API.G_FALSE,
159: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
160: x_return_status OUT NOCOPY VARCHAR2,
161: x_msg_count OUT NOCOPY NUMBER,
154: --
155: PROCEDURE Add_GroupChannel
156: ( p_api_version IN NUMBER,
157: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
158: p_commit IN VARCHAR2 := FND_API.G_FALSE,
159: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
160: x_return_status OUT NOCOPY VARCHAR2,
161: x_msg_count OUT NOCOPY NUMBER,
162: x_msg_data OUT NOCOPY VARCHAR2,
155: PROCEDURE Add_GroupChannel
156: ( p_api_version IN NUMBER,
157: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
158: p_commit IN VARCHAR2 := FND_API.G_FALSE,
159: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
160: x_return_status OUT NOCOPY VARCHAR2,
161: x_msg_count OUT NOCOPY NUMBER,
162: x_msg_data OUT NOCOPY VARCHAR2,
163: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
159: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
160: x_return_status OUT NOCOPY VARCHAR2,
161: x_msg_count OUT NOCOPY NUMBER,
162: x_msg_data OUT NOCOPY VARCHAR2,
163: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
164: p_group_id IN NUMBER,
165: p_channel_record IN AMV_CHANNEL_PVT.AMV_CHANNEL_OBJ_TYPE,
166: x_channel_id OUT NOCOPY NUMBER
167: );
173: -- Function : Delete the content channel given p_channel_id/p_channel_name
174: -- Parameters :
175: -- IN p_api_version IN NUMBER Required
176: -- p_init_msg_list IN VARCHAR2 Optional
177: -- Default = FND_API.G_FALSE
178: -- p_commit IN VARCHAR2 Optional
179: -- Default = FND_API.G_FALSE
180: -- p_validation_level IN NUMBER Optional
181: -- Default = FND_API.G_VALID_LEVEL_FULL
175: -- IN p_api_version IN NUMBER Required
176: -- p_init_msg_list IN VARCHAR2 Optional
177: -- Default = FND_API.G_FALSE
178: -- p_commit IN VARCHAR2 Optional
179: -- Default = FND_API.G_FALSE
180: -- p_validation_level IN NUMBER Optional
181: -- Default = FND_API.G_VALID_LEVEL_FULL
182: -- p_channel_id IN NUMBER Optional
183: -- the channel id. Default = FND_API.G_MISS_NUM
177: -- Default = FND_API.G_FALSE
178: -- p_commit IN VARCHAR2 Optional
179: -- Default = FND_API.G_FALSE
180: -- p_validation_level IN NUMBER Optional
181: -- Default = FND_API.G_VALID_LEVEL_FULL
182: -- p_channel_id IN NUMBER Optional
183: -- the channel id. Default = FND_API.G_MISS_NUM
184: -- p_channel_name IN VARCHAR2 Optional
185: -- the channel name. Default = FND_API.G_MISS_CHAR
179: -- Default = FND_API.G_FALSE
180: -- p_validation_level IN NUMBER Optional
181: -- Default = FND_API.G_VALID_LEVEL_FULL
182: -- p_channel_id IN NUMBER Optional
183: -- the channel id. Default = FND_API.G_MISS_NUM
184: -- p_channel_name IN VARCHAR2 Optional
185: -- the channel name. Default = FND_API.G_MISS_CHAR
186: -- Either pass the channe id (preferred) or channel name
187: -- to identify the channel.
181: -- Default = FND_API.G_VALID_LEVEL_FULL
182: -- p_channel_id IN NUMBER Optional
183: -- the channel id. Default = FND_API.G_MISS_NUM
184: -- p_channel_name IN VARCHAR2 Optional
185: -- the channel name. Default = FND_API.G_MISS_CHAR
186: -- Either pass the channe id (preferred) or channel name
187: -- to identify the channel.
188: -- p_category_id IN NUMBER Optional
189: -- the category id. Default = FND_API.G_MISS_NUM
185: -- the channel name. Default = FND_API.G_MISS_CHAR
186: -- Either pass the channe id (preferred) or channel name
187: -- to identify the channel.
188: -- p_category_id IN NUMBER Optional
189: -- the category id. Default = FND_API.G_MISS_NUM
190: -- OUT : x_return_status OUT VARCHAR2
191: -- x_msg_count OUT NUMBER
192: -- x_msg_data OUT VARCHAR2
193: -- Version : Current version 1.0
198: -- End of comments
199: --
200: PROCEDURE Delete_Channel
201: ( p_api_version IN NUMBER,
202: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
203: p_commit IN VARCHAR2 := FND_API.G_FALSE,
204: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
205: x_return_status OUT NOCOPY VARCHAR2,
206: x_msg_count OUT NOCOPY NUMBER,
199: --
200: PROCEDURE Delete_Channel
201: ( p_api_version IN NUMBER,
202: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
203: p_commit IN VARCHAR2 := FND_API.G_FALSE,
204: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
205: x_return_status OUT NOCOPY VARCHAR2,
206: x_msg_count OUT NOCOPY NUMBER,
207: x_msg_data OUT NOCOPY VARCHAR2,
200: PROCEDURE Delete_Channel
201: ( p_api_version IN NUMBER,
202: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
203: p_commit IN VARCHAR2 := FND_API.G_FALSE,
204: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
205: x_return_status OUT NOCOPY VARCHAR2,
206: x_msg_count OUT NOCOPY NUMBER,
207: x_msg_data OUT NOCOPY VARCHAR2,
208: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
204: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
205: x_return_status OUT NOCOPY VARCHAR2,
206: x_msg_count OUT NOCOPY NUMBER,
207: x_msg_data OUT NOCOPY VARCHAR2,
208: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
209: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
210: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
211: p_category_id IN NUMBER := FND_API.G_MISS_NUM
212: );
205: x_return_status OUT NOCOPY VARCHAR2,
206: x_msg_count OUT NOCOPY NUMBER,
207: x_msg_data OUT NOCOPY VARCHAR2,
208: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
209: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
210: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
211: p_category_id IN NUMBER := FND_API.G_MISS_NUM
212: );
213: --------------------------------------------------------------------------------
206: x_msg_count OUT NOCOPY NUMBER,
207: x_msg_data OUT NOCOPY VARCHAR2,
208: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
209: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
210: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
211: p_category_id IN NUMBER := FND_API.G_MISS_NUM
212: );
213: --------------------------------------------------------------------------------
214: -- Start of comments
207: x_msg_data OUT NOCOPY VARCHAR2,
208: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
209: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
210: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
211: p_category_id IN NUMBER := FND_API.G_MISS_NUM
212: );
213: --------------------------------------------------------------------------------
214: -- Start of comments
215: -- API name : Update_Channel
220: -- New data are specified in other members of p_channel_record
221: -- Parameters :
222: -- IN p_api_version IN NUMBER Required
223: -- p_init_msg_list IN VARCHAR2 Optional
224: -- Default = FND_API.G_FALSE
225: -- p_commit IN VARCHAR2 Optional
226: -- Default = FND_API.G_FALSE
227: -- p_validation_level IN NUMBER Optional
228: -- Default = FND_API.G_VALID_LEVEL_FULL
222: -- IN p_api_version IN NUMBER Required
223: -- p_init_msg_list IN VARCHAR2 Optional
224: -- Default = FND_API.G_FALSE
225: -- p_commit IN VARCHAR2 Optional
226: -- Default = FND_API.G_FALSE
227: -- p_validation_level IN NUMBER Optional
228: -- Default = FND_API.G_VALID_LEVEL_FULL
229: -- p_channel_record IN AMV_CHANNEL_OBJ_TYPE Required
230: -- OUT : x_return_status OUT VARCHAR2
224: -- Default = FND_API.G_FALSE
225: -- p_commit IN VARCHAR2 Optional
226: -- Default = FND_API.G_FALSE
227: -- p_validation_level IN NUMBER Optional
228: -- Default = FND_API.G_VALID_LEVEL_FULL
229: -- p_channel_record IN AMV_CHANNEL_OBJ_TYPE Required
230: -- OUT : x_return_status OUT VARCHAR2
231: -- x_msg_count OUT NUMBER
232: -- x_msg_data OUT VARCHAR2
238: -- End of comments
239: --
240: PROCEDURE Update_Channel
241: ( p_api_version IN NUMBER,
242: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
243: p_commit IN VARCHAR2 := FND_API.G_FALSE,
244: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
245: x_return_status OUT NOCOPY VARCHAR2,
246: x_msg_count OUT NOCOPY NUMBER,
239: --
240: PROCEDURE Update_Channel
241: ( p_api_version IN NUMBER,
242: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
243: p_commit IN VARCHAR2 := FND_API.G_FALSE,
244: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
245: x_return_status OUT NOCOPY VARCHAR2,
246: x_msg_count OUT NOCOPY NUMBER,
247: x_msg_data OUT NOCOPY VARCHAR2,
240: PROCEDURE Update_Channel
241: ( p_api_version IN NUMBER,
242: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
243: p_commit IN VARCHAR2 := FND_API.G_FALSE,
244: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
245: x_return_status OUT NOCOPY VARCHAR2,
246: x_msg_count OUT NOCOPY NUMBER,
247: x_msg_data OUT NOCOPY VARCHAR2,
248: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
244: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
245: x_return_status OUT NOCOPY VARCHAR2,
246: x_msg_count OUT NOCOPY NUMBER,
247: x_msg_data OUT NOCOPY VARCHAR2,
248: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
249: p_channel_record IN AMV_CHANNEL_PVT.AMV_CHANNEL_OBJ_TYPE
250: );
251: --------------------------------------------------------------------------------
252: -- Start of comments
257: -- channel id (preferred) or channel name.
258: -- Parameters :
259: -- IN p_api_version IN NUMBER Required
260: -- p_init_msg_list IN VARCHAR2 Optional
261: -- Default = FND_API.G_FALSE
262: -- p_validation_level IN NUMBER Optional
263: -- Default = FND_API.G_VALID_LEVEL_FULL
264: -- p_channel_id IN NUMBER Optional
265: -- the channel id. Default = FND_API.G_MISS_NUM
259: -- IN p_api_version IN NUMBER Required
260: -- p_init_msg_list IN VARCHAR2 Optional
261: -- Default = FND_API.G_FALSE
262: -- p_validation_level IN NUMBER Optional
263: -- Default = FND_API.G_VALID_LEVEL_FULL
264: -- p_channel_id IN NUMBER Optional
265: -- the channel id. Default = FND_API.G_MISS_NUM
266: -- p_channel_name IN VARCHAR2 Optional
267: -- the channel name. Default = FND_API.G_MISS_CHAR
261: -- Default = FND_API.G_FALSE
262: -- p_validation_level IN NUMBER Optional
263: -- Default = FND_API.G_VALID_LEVEL_FULL
264: -- p_channel_id IN NUMBER Optional
265: -- the channel id. Default = FND_API.G_MISS_NUM
266: -- p_channel_name IN VARCHAR2 Optional
267: -- the channel name. Default = FND_API.G_MISS_CHAR
268: -- Either pass the channe id (preferred) or channel name
269: -- to identify the channel.
263: -- Default = FND_API.G_VALID_LEVEL_FULL
264: -- p_channel_id IN NUMBER Optional
265: -- the channel id. Default = FND_API.G_MISS_NUM
266: -- p_channel_name IN VARCHAR2 Optional
267: -- the channel name. Default = FND_API.G_MISS_CHAR
268: -- Either pass the channe id (preferred) or channel name
269: -- to identify the channel.
270: -- p_category_id IN NUMBER Optional
271: -- the category id. Default = FND_API.G_MISS_NUM
267: -- the channel name. Default = FND_API.G_MISS_CHAR
268: -- Either pass the channe id (preferred) or channel name
269: -- to identify the channel.
270: -- p_category_id IN NUMBER Optional
271: -- the category id. Default = FND_API.G_MISS_NUM
272: -- OUT : x_return_status OUT VARCHAR2
273: -- x_msg_count OUT NUMBER
274: -- x_msg_data OUT VARCHAR2
275: -- x_channel_record OUT AMV_CHANNEL_OBJ_TYPE
281: -- End of comments
282: --
283: PROCEDURE Get_Channel
284: ( p_api_version IN NUMBER,
285: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
286: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
287: x_return_status OUT NOCOPY VARCHAR2,
288: x_msg_count OUT NOCOPY NUMBER,
289: x_msg_data OUT NOCOPY VARCHAR2,
282: --
283: PROCEDURE Get_Channel
284: ( p_api_version IN NUMBER,
285: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
286: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
287: x_return_status OUT NOCOPY VARCHAR2,
288: x_msg_count OUT NOCOPY NUMBER,
289: x_msg_data OUT NOCOPY VARCHAR2,
290: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
286: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
287: x_return_status OUT NOCOPY VARCHAR2,
288: x_msg_count OUT NOCOPY NUMBER,
289: x_msg_data OUT NOCOPY VARCHAR2,
290: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
291: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
292: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
293: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
294: x_channel_record OUT NOCOPY AMV_CHANNEL_PVT.AMV_CHANNEL_OBJ_TYPE
287: x_return_status OUT NOCOPY VARCHAR2,
288: x_msg_count OUT NOCOPY NUMBER,
289: x_msg_data OUT NOCOPY VARCHAR2,
290: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
291: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
292: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
293: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
294: x_channel_record OUT NOCOPY AMV_CHANNEL_PVT.AMV_CHANNEL_OBJ_TYPE
295: );
288: x_msg_count OUT NOCOPY NUMBER,
289: x_msg_data OUT NOCOPY VARCHAR2,
290: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
291: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
292: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
293: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
294: x_channel_record OUT NOCOPY AMV_CHANNEL_PVT.AMV_CHANNEL_OBJ_TYPE
295: );
296: --------------------------------------------------------------------------------
289: x_msg_data OUT NOCOPY VARCHAR2,
290: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
291: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
292: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
293: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
294: x_channel_record OUT NOCOPY AMV_CHANNEL_PVT.AMV_CHANNEL_OBJ_TYPE
295: );
296: --------------------------------------------------------------------------------
297: -- Start of comments
301: -- Function : Change content categories of the content channel.
302: -- Parameters :
303: -- IN p_api_version IN NUMBER Required
304: -- p_init_msg_list IN VARCHAR2 Optional
305: -- Default = FND_API.G_FALSE
306: -- p_commit IN VARCHAR2 Optional
307: -- Default = FND_API.G_FALSE
308: -- p_validation_level NUMBER Optional
309: -- Default = FND_API.G_VALID_LEVEL_FULL
303: -- IN p_api_version IN NUMBER Required
304: -- p_init_msg_list IN VARCHAR2 Optional
305: -- Default = FND_API.G_FALSE
306: -- p_commit IN VARCHAR2 Optional
307: -- Default = FND_API.G_FALSE
308: -- p_validation_level NUMBER Optional
309: -- Default = FND_API.G_VALID_LEVEL_FULL
310: -- p_channel_id IN NUMBER Optional
311: -- the channel id. Default = FND_API.G_MISS_NUM
305: -- Default = FND_API.G_FALSE
306: -- p_commit IN VARCHAR2 Optional
307: -- Default = FND_API.G_FALSE
308: -- p_validation_level NUMBER Optional
309: -- Default = FND_API.G_VALID_LEVEL_FULL
310: -- p_channel_id IN NUMBER Optional
311: -- the channel id. Default = FND_API.G_MISS_NUM
312: -- p_channel_name IN VARCHAR2 Optional
313: -- the channel name. Default = FND_API.G_MISS_CHAR
307: -- Default = FND_API.G_FALSE
308: -- p_validation_level NUMBER Optional
309: -- Default = FND_API.G_VALID_LEVEL_FULL
310: -- p_channel_id IN NUMBER Optional
311: -- the channel id. Default = FND_API.G_MISS_NUM
312: -- p_channel_name IN VARCHAR2 Optional
313: -- the channel name. Default = FND_API.G_MISS_CHAR
314: -- Either pass the channe id (preferred) or channel name
315: -- to identify the channel.
309: -- Default = FND_API.G_VALID_LEVEL_FULL
310: -- p_channel_id IN NUMBER Optional
311: -- the channel id. Default = FND_API.G_MISS_NUM
312: -- p_channel_name IN VARCHAR2 Optional
313: -- the channel name. Default = FND_API.G_MISS_CHAR
314: -- Either pass the channe id (preferred) or channel name
315: -- to identify the channel.
316: -- p_category_id IN NUMBER Optional
317: -- the category id. Default = FND_API.G_MISS_NUM
313: -- the channel name. Default = FND_API.G_MISS_CHAR
314: -- Either pass the channe id (preferred) or channel name
315: -- to identify the channel.
316: -- p_category_id IN NUMBER Optional
317: -- the category id. Default = FND_API.G_MISS_NUM
318: -- p_content_type_id_array IN AMV_NUMBER_VARRAY_TYPE
319: -- OUT : x_return_status OUT VARCHAR2
320: -- x_msg_count OUT NUMBER
321: -- x_msg_data OUT VARCHAR2
327: -- End of comments
328: --
329: PROCEDURE Set_ChannelContentTypes
330: ( p_api_version IN NUMBER,
331: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
332: p_commit IN VARCHAR2 := FND_API.G_FALSE,
333: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
334: x_return_status OUT NOCOPY VARCHAR2,
335: x_msg_count OUT NOCOPY NUMBER,
328: --
329: PROCEDURE Set_ChannelContentTypes
330: ( p_api_version IN NUMBER,
331: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
332: p_commit IN VARCHAR2 := FND_API.G_FALSE,
333: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
334: x_return_status OUT NOCOPY VARCHAR2,
335: x_msg_count OUT NOCOPY NUMBER,
336: x_msg_data OUT NOCOPY VARCHAR2,
329: PROCEDURE Set_ChannelContentTypes
330: ( p_api_version IN NUMBER,
331: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
332: p_commit IN VARCHAR2 := FND_API.G_FALSE,
333: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
334: x_return_status OUT NOCOPY VARCHAR2,
335: x_msg_count OUT NOCOPY NUMBER,
336: x_msg_data OUT NOCOPY VARCHAR2,
337: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
333: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
334: x_return_status OUT NOCOPY VARCHAR2,
335: x_msg_count OUT NOCOPY NUMBER,
336: x_msg_data OUT NOCOPY VARCHAR2,
337: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
338: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
339: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
340: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
341: p_content_type_id_array IN AMV_CHANNEL_PVT.AMV_NUMBER_VARRAY_TYPE
334: x_return_status OUT NOCOPY VARCHAR2,
335: x_msg_count OUT NOCOPY NUMBER,
336: x_msg_data OUT NOCOPY VARCHAR2,
337: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
338: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
339: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
340: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
341: p_content_type_id_array IN AMV_CHANNEL_PVT.AMV_NUMBER_VARRAY_TYPE
342: );
335: x_msg_count OUT NOCOPY NUMBER,
336: x_msg_data OUT NOCOPY VARCHAR2,
337: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
338: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
339: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
340: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
341: p_content_type_id_array IN AMV_CHANNEL_PVT.AMV_NUMBER_VARRAY_TYPE
342: );
343: --------------------------------------------------------------------------------
336: x_msg_data OUT NOCOPY VARCHAR2,
337: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
338: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
339: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
340: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
341: p_content_type_id_array IN AMV_CHANNEL_PVT.AMV_NUMBER_VARRAY_TYPE
342: );
343: --------------------------------------------------------------------------------
344: -- Start of comments
348: -- Function : Get content categories of the content channel.
349: -- Parameters :
350: -- IN p_api_version IN NUMBER Required
351: -- p_init_msg_list IN VARCHAR2 Optional
352: -- Default = FND_API.G_FALSE
353: -- p_validation_level NUMBER Optional
354: -- Default = FND_API.G_VALID_LEVEL_FULL
355: -- p_channel_id IN NUMBER Optional
356: -- the channel id. Default = FND_API.G_MISS_NUM
350: -- IN p_api_version IN NUMBER Required
351: -- p_init_msg_list IN VARCHAR2 Optional
352: -- Default = FND_API.G_FALSE
353: -- p_validation_level NUMBER Optional
354: -- Default = FND_API.G_VALID_LEVEL_FULL
355: -- p_channel_id IN NUMBER Optional
356: -- the channel id. Default = FND_API.G_MISS_NUM
357: -- p_channel_name IN VARCHAR2 Optional
358: -- the channel name. Default = FND_API.G_MISS_CHAR
352: -- Default = FND_API.G_FALSE
353: -- p_validation_level NUMBER Optional
354: -- Default = FND_API.G_VALID_LEVEL_FULL
355: -- p_channel_id IN NUMBER Optional
356: -- the channel id. Default = FND_API.G_MISS_NUM
357: -- p_channel_name IN VARCHAR2 Optional
358: -- the channel name. Default = FND_API.G_MISS_CHAR
359: -- Either pass the channe id (preferred) or channel name
360: -- to identify the channel.
354: -- Default = FND_API.G_VALID_LEVEL_FULL
355: -- p_channel_id IN NUMBER Optional
356: -- the channel id. Default = FND_API.G_MISS_NUM
357: -- p_channel_name IN VARCHAR2 Optional
358: -- the channel name. Default = FND_API.G_MISS_CHAR
359: -- Either pass the channe id (preferred) or channel name
360: -- to identify the channel.
361: -- p_category_id IN NUMBER Optional
362: -- the category id. Default = FND_API.G_MISS_NUM
358: -- the channel name. Default = FND_API.G_MISS_CHAR
359: -- Either pass the channe id (preferred) or channel name
360: -- to identify the channel.
361: -- p_category_id IN NUMBER Optional
362: -- the category id. Default = FND_API.G_MISS_NUM
363: -- OUT : x_return_status OUT VARCHAR2
364: -- x_msg_count OUT NUMBER
365: -- x_msg_data OUT VARCHAR2
366: -- x_content_type_id_array OUT AMV_NUMBER_VARRAY_TYPE
372: -- End of comments
373: --
374: PROCEDURE Get_ChannelContentTypes
375: ( p_api_version IN NUMBER,
376: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
377: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
378: x_return_status OUT NOCOPY VARCHAR2,
379: x_msg_count OUT NOCOPY NUMBER,
380: x_msg_data OUT NOCOPY VARCHAR2,
373: --
374: PROCEDURE Get_ChannelContentTypes
375: ( p_api_version IN NUMBER,
376: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
377: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
378: x_return_status OUT NOCOPY VARCHAR2,
379: x_msg_count OUT NOCOPY NUMBER,
380: x_msg_data OUT NOCOPY VARCHAR2,
381: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
377: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
378: x_return_status OUT NOCOPY VARCHAR2,
379: x_msg_count OUT NOCOPY NUMBER,
380: x_msg_data OUT NOCOPY VARCHAR2,
381: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
382: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
383: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
384: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
385: x_content_type_id_array OUT NOCOPY AMV_CHANNEL_PVT.AMV_NUMBER_VARRAY_TYPE
378: x_return_status OUT NOCOPY VARCHAR2,
379: x_msg_count OUT NOCOPY NUMBER,
380: x_msg_data OUT NOCOPY VARCHAR2,
381: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
382: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
383: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
384: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
385: x_content_type_id_array OUT NOCOPY AMV_CHANNEL_PVT.AMV_NUMBER_VARRAY_TYPE
386: );
379: x_msg_count OUT NOCOPY NUMBER,
380: x_msg_data OUT NOCOPY VARCHAR2,
381: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
382: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
383: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
384: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
385: x_content_type_id_array OUT NOCOPY AMV_CHANNEL_PVT.AMV_NUMBER_VARRAY_TYPE
386: );
387: --------------------------------------------------------------------------------
380: x_msg_data OUT NOCOPY VARCHAR2,
381: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
382: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
383: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
384: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
385: x_content_type_id_array OUT NOCOPY AMV_CHANNEL_PVT.AMV_NUMBER_VARRAY_TYPE
386: );
387: --------------------------------------------------------------------------------
388: -- Start of comments
392: -- Function : Change perspectives of the content channel.
393: -- Parameters :
394: -- IN p_api_version IN NUMBER Required
395: -- p_init_msg_list IN VARCHAR2 Optional
396: -- Default = FND_API.G_FALSE
397: -- p_commit IN VARCHAR2 Optional
398: -- Default = FND_API.G_FALSE
399: -- p_validation_level NUMBER Optional
400: -- Default = FND_API.G_VALID_LEVEL_FULL
394: -- IN p_api_version IN NUMBER Required
395: -- p_init_msg_list IN VARCHAR2 Optional
396: -- Default = FND_API.G_FALSE
397: -- p_commit IN VARCHAR2 Optional
398: -- Default = FND_API.G_FALSE
399: -- p_validation_level NUMBER Optional
400: -- Default = FND_API.G_VALID_LEVEL_FULL
401: -- p_channel_id IN NUMBER Optional
402: -- the channel id. Default = FND_API.G_MISS_NUM
396: -- Default = FND_API.G_FALSE
397: -- p_commit IN VARCHAR2 Optional
398: -- Default = FND_API.G_FALSE
399: -- p_validation_level NUMBER Optional
400: -- Default = FND_API.G_VALID_LEVEL_FULL
401: -- p_channel_id IN NUMBER Optional
402: -- the channel id. Default = FND_API.G_MISS_NUM
403: -- p_channel_name IN VARCHAR2 Optional
404: -- the channel name. Default = FND_API.G_MISS_CHAR
398: -- Default = FND_API.G_FALSE
399: -- p_validation_level NUMBER Optional
400: -- Default = FND_API.G_VALID_LEVEL_FULL
401: -- p_channel_id IN NUMBER Optional
402: -- the channel id. Default = FND_API.G_MISS_NUM
403: -- p_channel_name IN VARCHAR2 Optional
404: -- the channel name. Default = FND_API.G_MISS_CHAR
405: -- Either pass the channe id (preferred) or channel name
406: -- to identify the channel.
400: -- Default = FND_API.G_VALID_LEVEL_FULL
401: -- p_channel_id IN NUMBER Optional
402: -- the channel id. Default = FND_API.G_MISS_NUM
403: -- p_channel_name IN VARCHAR2 Optional
404: -- the channel name. Default = FND_API.G_MISS_CHAR
405: -- Either pass the channe id (preferred) or channel name
406: -- to identify the channel.
407: -- p_category_id IN NUMBER Optional
408: -- the category id. Default = FND_API.G_MISS_NUM
404: -- the channel name. Default = FND_API.G_MISS_CHAR
405: -- Either pass the channe id (preferred) or channel name
406: -- to identify the channel.
407: -- p_category_id IN NUMBER Optional
408: -- the category id. Default = FND_API.G_MISS_NUM
409: -- p_perspective_id_array IN AMV_NUMBER_VARRAY_TYPE
410: -- OUT : x_return_status OUT VARCHAR2
411: -- x_msg_count OUT NUMBER
412: -- x_msg_data OUT VARCHAR2
418: -- End of comments
419: --
420: PROCEDURE Set_ChannelPerspectives
421: ( p_api_version IN NUMBER,
422: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
423: p_commit IN VARCHAR2 := FND_API.G_FALSE,
424: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
425: x_return_status OUT NOCOPY VARCHAR2,
426: x_msg_count OUT NOCOPY NUMBER,
419: --
420: PROCEDURE Set_ChannelPerspectives
421: ( p_api_version IN NUMBER,
422: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
423: p_commit IN VARCHAR2 := FND_API.G_FALSE,
424: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
425: x_return_status OUT NOCOPY VARCHAR2,
426: x_msg_count OUT NOCOPY NUMBER,
427: x_msg_data OUT NOCOPY VARCHAR2,
420: PROCEDURE Set_ChannelPerspectives
421: ( p_api_version IN NUMBER,
422: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
423: p_commit IN VARCHAR2 := FND_API.G_FALSE,
424: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
425: x_return_status OUT NOCOPY VARCHAR2,
426: x_msg_count OUT NOCOPY NUMBER,
427: x_msg_data OUT NOCOPY VARCHAR2,
428: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
424: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
425: x_return_status OUT NOCOPY VARCHAR2,
426: x_msg_count OUT NOCOPY NUMBER,
427: x_msg_data OUT NOCOPY VARCHAR2,
428: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
429: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
430: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
431: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
432: p_perspective_id_array IN AMV_CHANNEL_PVT.AMV_NUMBER_VARRAY_TYPE
425: x_return_status OUT NOCOPY VARCHAR2,
426: x_msg_count OUT NOCOPY NUMBER,
427: x_msg_data OUT NOCOPY VARCHAR2,
428: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
429: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
430: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
431: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
432: p_perspective_id_array IN AMV_CHANNEL_PVT.AMV_NUMBER_VARRAY_TYPE
433: );
426: x_msg_count OUT NOCOPY NUMBER,
427: x_msg_data OUT NOCOPY VARCHAR2,
428: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
429: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
430: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
431: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
432: p_perspective_id_array IN AMV_CHANNEL_PVT.AMV_NUMBER_VARRAY_TYPE
433: );
434: --------------------------------------------------------------------------------
427: x_msg_data OUT NOCOPY VARCHAR2,
428: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
429: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
430: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
431: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
432: p_perspective_id_array IN AMV_CHANNEL_PVT.AMV_NUMBER_VARRAY_TYPE
433: );
434: --------------------------------------------------------------------------------
435: -- Start of comments
439: -- Function : Get perspectives of the content channel.
440: -- Parameters :
441: -- IN p_api_version IN NUMBER Required
442: -- p_init_msg_list IN VARCHAR2 Optional
443: -- Default = FND_API.G_FALSE
444: -- p_validation_level NUMBER Optional
445: -- Default = FND_API.G_VALID_LEVEL_FULL
446: -- p_channel_id IN NUMBER Optional
447: -- the channel id. Default = FND_API.G_MISS_NUM
441: -- IN p_api_version IN NUMBER Required
442: -- p_init_msg_list IN VARCHAR2 Optional
443: -- Default = FND_API.G_FALSE
444: -- p_validation_level NUMBER Optional
445: -- Default = FND_API.G_VALID_LEVEL_FULL
446: -- p_channel_id IN NUMBER Optional
447: -- the channel id. Default = FND_API.G_MISS_NUM
448: -- p_channel_name IN VARCHAR2 Optional
449: -- the channel name. Default = FND_API.G_MISS_CHAR
443: -- Default = FND_API.G_FALSE
444: -- p_validation_level NUMBER Optional
445: -- Default = FND_API.G_VALID_LEVEL_FULL
446: -- p_channel_id IN NUMBER Optional
447: -- the channel id. Default = FND_API.G_MISS_NUM
448: -- p_channel_name IN VARCHAR2 Optional
449: -- the channel name. Default = FND_API.G_MISS_CHAR
450: -- Either pass the channe id (preferred) or channel name
451: -- to identify the channel.
445: -- Default = FND_API.G_VALID_LEVEL_FULL
446: -- p_channel_id IN NUMBER Optional
447: -- the channel id. Default = FND_API.G_MISS_NUM
448: -- p_channel_name IN VARCHAR2 Optional
449: -- the channel name. Default = FND_API.G_MISS_CHAR
450: -- Either pass the channe id (preferred) or channel name
451: -- to identify the channel.
452: -- p_category_id IN NUMBER Optional
453: -- the category id. Default = FND_API.G_MISS_NUM
449: -- the channel name. Default = FND_API.G_MISS_CHAR
450: -- Either pass the channe id (preferred) or channel name
451: -- to identify the channel.
452: -- p_category_id IN NUMBER Optional
453: -- the category id. Default = FND_API.G_MISS_NUM
454: -- OUT : x_return_status OUT VARCHAR2
455: -- x_msg_count OUT NUMBER
456: -- x_msg_data OUT VARCHAR2
457: -- x_perspective_id_array OUT AMV_NUMBER_VARRAY_TYPE
463: -- End of comments
464: --
465: PROCEDURE Get_ChannelPerspectives
466: ( p_api_version IN NUMBER,
467: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
468: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
469: x_return_status OUT NOCOPY VARCHAR2,
470: x_msg_count OUT NOCOPY NUMBER,
471: x_msg_data OUT NOCOPY VARCHAR2,
464: --
465: PROCEDURE Get_ChannelPerspectives
466: ( p_api_version IN NUMBER,
467: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
468: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
469: x_return_status OUT NOCOPY VARCHAR2,
470: x_msg_count OUT NOCOPY NUMBER,
471: x_msg_data OUT NOCOPY VARCHAR2,
472: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
468: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
469: x_return_status OUT NOCOPY VARCHAR2,
470: x_msg_count OUT NOCOPY NUMBER,
471: x_msg_data OUT NOCOPY VARCHAR2,
472: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
473: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
474: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
475: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
476: x_perspective_id_array OUT NOCOPY AMV_CHANNEL_PVT.AMV_NUMBER_VARRAY_TYPE
469: x_return_status OUT NOCOPY VARCHAR2,
470: x_msg_count OUT NOCOPY NUMBER,
471: x_msg_data OUT NOCOPY VARCHAR2,
472: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
473: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
474: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
475: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
476: x_perspective_id_array OUT NOCOPY AMV_CHANNEL_PVT.AMV_NUMBER_VARRAY_TYPE
477: );
470: x_msg_count OUT NOCOPY NUMBER,
471: x_msg_data OUT NOCOPY VARCHAR2,
472: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
473: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
474: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
475: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
476: x_perspective_id_array OUT NOCOPY AMV_CHANNEL_PVT.AMV_NUMBER_VARRAY_TYPE
477: );
478: --------------------------------------------------------------------------------
471: x_msg_data OUT NOCOPY VARCHAR2,
472: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
473: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
474: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
475: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
476: x_perspective_id_array OUT NOCOPY AMV_CHANNEL_PVT.AMV_NUMBER_VARRAY_TYPE
477: );
478: --------------------------------------------------------------------------------
479: -- Start of comments
483: -- Function : Change user groups of the content channel.
484: -- Parameters :
485: -- IN p_api_version IN NUMBER Required
486: -- p_init_msg_list IN VARCHAR2 Optional
487: -- Default = FND_API.G_FALSE
488: -- p_validation_level NUMBER Optional
489: -- Default = FND_API.G_VALID_LEVEL_FULL
490: -- p_commit IN VARCHAR2 Optional
491: -- Default = FND_API.G_FALSE
485: -- IN p_api_version IN NUMBER Required
486: -- p_init_msg_list IN VARCHAR2 Optional
487: -- Default = FND_API.G_FALSE
488: -- p_validation_level NUMBER Optional
489: -- Default = FND_API.G_VALID_LEVEL_FULL
490: -- p_commit IN VARCHAR2 Optional
491: -- Default = FND_API.G_FALSE
492: -- p_channel_id IN NUMBER Optional
493: -- the channel id. Default = FND_API.G_MISS_NUM
487: -- Default = FND_API.G_FALSE
488: -- p_validation_level NUMBER Optional
489: -- Default = FND_API.G_VALID_LEVEL_FULL
490: -- p_commit IN VARCHAR2 Optional
491: -- Default = FND_API.G_FALSE
492: -- p_channel_id IN NUMBER Optional
493: -- the channel id. Default = FND_API.G_MISS_NUM
494: -- p_channel_name IN VARCHAR2 Optional
495: -- the channel name. Default = FND_API.G_MISS_CHAR
489: -- Default = FND_API.G_VALID_LEVEL_FULL
490: -- p_commit IN VARCHAR2 Optional
491: -- Default = FND_API.G_FALSE
492: -- p_channel_id IN NUMBER Optional
493: -- the channel id. Default = FND_API.G_MISS_NUM
494: -- p_channel_name IN VARCHAR2 Optional
495: -- the channel name. Default = FND_API.G_MISS_CHAR
496: -- Either pass the channe id (preferred) or channel name
497: -- to identify the channel.
491: -- Default = FND_API.G_FALSE
492: -- p_channel_id IN NUMBER Optional
493: -- the channel id. Default = FND_API.G_MISS_NUM
494: -- p_channel_name IN VARCHAR2 Optional
495: -- the channel name. Default = FND_API.G_MISS_CHAR
496: -- Either pass the channe id (preferred) or channel name
497: -- to identify the channel.
498: -- p_category_id IN NUMBER Optional
499: -- the category id. Default = FND_API.G_MISS_NUM
495: -- the channel name. Default = FND_API.G_MISS_CHAR
496: -- Either pass the channe id (preferred) or channel name
497: -- to identify the channel.
498: -- p_category_id IN NUMBER Optional
499: -- the category id. Default = FND_API.G_MISS_NUM
500: -- p_item_type_array IN AMV_CHAR_VARRAY_TYPE
501: -- OUT : x_return_status OUT VARCHAR2
502: -- x_msg_count OUT NUMBER
503: -- x_msg_data OUT VARCHAR2
509: -- End of comments
510: --
511: PROCEDURE Set_ChannelItemTypes
512: ( p_api_version IN NUMBER,
513: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
514: p_commit IN VARCHAR2 := FND_API.G_FALSE,
515: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
516: x_return_status OUT NOCOPY VARCHAR2,
517: x_msg_count OUT NOCOPY NUMBER,
510: --
511: PROCEDURE Set_ChannelItemTypes
512: ( p_api_version IN NUMBER,
513: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
514: p_commit IN VARCHAR2 := FND_API.G_FALSE,
515: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
516: x_return_status OUT NOCOPY VARCHAR2,
517: x_msg_count OUT NOCOPY NUMBER,
518: x_msg_data OUT NOCOPY VARCHAR2,
511: PROCEDURE Set_ChannelItemTypes
512: ( p_api_version IN NUMBER,
513: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
514: p_commit IN VARCHAR2 := FND_API.G_FALSE,
515: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
516: x_return_status OUT NOCOPY VARCHAR2,
517: x_msg_count OUT NOCOPY NUMBER,
518: x_msg_data OUT NOCOPY VARCHAR2,
519: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
515: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
516: x_return_status OUT NOCOPY VARCHAR2,
517: x_msg_count OUT NOCOPY NUMBER,
518: x_msg_data OUT NOCOPY VARCHAR2,
519: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
520: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
521: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
522: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
523: p_item_type_array IN AMV_CHANNEL_PVT.AMV_CHAR_VARRAY_TYPE
516: x_return_status OUT NOCOPY VARCHAR2,
517: x_msg_count OUT NOCOPY NUMBER,
518: x_msg_data OUT NOCOPY VARCHAR2,
519: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
520: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
521: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
522: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
523: p_item_type_array IN AMV_CHANNEL_PVT.AMV_CHAR_VARRAY_TYPE
524: );
517: x_msg_count OUT NOCOPY NUMBER,
518: x_msg_data OUT NOCOPY VARCHAR2,
519: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
520: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
521: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
522: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
523: p_item_type_array IN AMV_CHANNEL_PVT.AMV_CHAR_VARRAY_TYPE
524: );
525: --------------------------------------------------------------------------------
518: x_msg_data OUT NOCOPY VARCHAR2,
519: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
520: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
521: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
522: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
523: p_item_type_array IN AMV_CHANNEL_PVT.AMV_CHAR_VARRAY_TYPE
524: );
525: --------------------------------------------------------------------------------
526: -- Start of comments
530: -- Function : Get user groups of the content channel.
531: -- Parameters :
532: -- IN p_api_version IN NUMBER Required
533: -- p_init_msg_list IN VARCHAR2 Optional
534: -- Default = FND_API.G_FALSE
535: -- p_validation_level NUMBER Optional
536: -- Default = FND_API.G_VALID_LEVEL_FULL
537: -- p_channel_id IN NUMBER Optional
538: -- the channel id. Default = FND_API.G_MISS_NUM
532: -- IN p_api_version IN NUMBER Required
533: -- p_init_msg_list IN VARCHAR2 Optional
534: -- Default = FND_API.G_FALSE
535: -- p_validation_level NUMBER Optional
536: -- Default = FND_API.G_VALID_LEVEL_FULL
537: -- p_channel_id IN NUMBER Optional
538: -- the channel id. Default = FND_API.G_MISS_NUM
539: -- p_channel_name IN VARCHAR2 Optional
540: -- the channel name. Default = FND_API.G_MISS_CHAR
534: -- Default = FND_API.G_FALSE
535: -- p_validation_level NUMBER Optional
536: -- Default = FND_API.G_VALID_LEVEL_FULL
537: -- p_channel_id IN NUMBER Optional
538: -- the channel id. Default = FND_API.G_MISS_NUM
539: -- p_channel_name IN VARCHAR2 Optional
540: -- the channel name. Default = FND_API.G_MISS_CHAR
541: -- Either pass the channe id (preferred) or channel name
542: -- to identify the channel.
536: -- Default = FND_API.G_VALID_LEVEL_FULL
537: -- p_channel_id IN NUMBER Optional
538: -- the channel id. Default = FND_API.G_MISS_NUM
539: -- p_channel_name IN VARCHAR2 Optional
540: -- the channel name. Default = FND_API.G_MISS_CHAR
541: -- Either pass the channe id (preferred) or channel name
542: -- to identify the channel.
543: -- p_category_id IN NUMBER Optional
544: -- the category id. Default = FND_API.G_MISS_NUM
540: -- the channel name. Default = FND_API.G_MISS_CHAR
541: -- Either pass the channe id (preferred) or channel name
542: -- to identify the channel.
543: -- p_category_id IN NUMBER Optional
544: -- the category id. Default = FND_API.G_MISS_NUM
545: -- OUT : x_return_status OUT VARCHAR2
546: -- x_msg_count OUT NUMBER
547: -- x_msg_data OUT VARCHAR2
548: -- x_item_type_array OUT AMV_CHAR_VARRAY_TYPE
554: -- End of comments
555: --
556: PROCEDURE Get_ChannelItemTypes
557: ( p_api_version IN NUMBER,
558: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
559: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
560: x_return_status OUT NOCOPY VARCHAR2,
561: x_msg_count OUT NOCOPY NUMBER,
562: x_msg_data OUT NOCOPY VARCHAR2,
555: --
556: PROCEDURE Get_ChannelItemTypes
557: ( p_api_version IN NUMBER,
558: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
559: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
560: x_return_status OUT NOCOPY VARCHAR2,
561: x_msg_count OUT NOCOPY NUMBER,
562: x_msg_data OUT NOCOPY VARCHAR2,
563: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
559: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
560: x_return_status OUT NOCOPY VARCHAR2,
561: x_msg_count OUT NOCOPY NUMBER,
562: x_msg_data OUT NOCOPY VARCHAR2,
563: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
564: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
565: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
566: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
567: x_item_type_array OUT NOCOPY AMV_CHANNEL_PVT.AMV_CHAR_VARRAY_TYPE
560: x_return_status OUT NOCOPY VARCHAR2,
561: x_msg_count OUT NOCOPY NUMBER,
562: x_msg_data OUT NOCOPY VARCHAR2,
563: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
564: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
565: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
566: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
567: x_item_type_array OUT NOCOPY AMV_CHANNEL_PVT.AMV_CHAR_VARRAY_TYPE
568: );
561: x_msg_count OUT NOCOPY NUMBER,
562: x_msg_data OUT NOCOPY VARCHAR2,
563: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
564: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
565: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
566: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
567: x_item_type_array OUT NOCOPY AMV_CHANNEL_PVT.AMV_CHAR_VARRAY_TYPE
568: );
569: --------------------------------------------------------------------------------
562: x_msg_data OUT NOCOPY VARCHAR2,
563: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
564: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
565: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
566: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
567: x_item_type_array OUT NOCOPY AMV_CHANNEL_PVT.AMV_CHAR_VARRAY_TYPE
568: );
569: --------------------------------------------------------------------------------
570: -- Start of comments
574: -- Function : Change keywords of the content channel.
575: -- Parameters :
576: -- IN p_api_version IN NUMBER Required
577: -- p_init_msg_list IN VARCHAR2 Optional
578: -- Default = FND_API.G_FALSE
579: -- p_commit IN VARCHAR2 Optional
580: -- Default = FND_API.G_FALSE
581: -- p_validation_level NUMBER Optional
582: -- Default = FND_API.G_VALID_LEVEL_FULL
576: -- IN p_api_version IN NUMBER Required
577: -- p_init_msg_list IN VARCHAR2 Optional
578: -- Default = FND_API.G_FALSE
579: -- p_commit IN VARCHAR2 Optional
580: -- Default = FND_API.G_FALSE
581: -- p_validation_level NUMBER Optional
582: -- Default = FND_API.G_VALID_LEVEL_FULL
583: -- p_channel_id IN NUMBER Optional
584: -- the channel id. Default = FND_API.G_MISS_NUM
578: -- Default = FND_API.G_FALSE
579: -- p_commit IN VARCHAR2 Optional
580: -- Default = FND_API.G_FALSE
581: -- p_validation_level NUMBER Optional
582: -- Default = FND_API.G_VALID_LEVEL_FULL
583: -- p_channel_id IN NUMBER Optional
584: -- the channel id. Default = FND_API.G_MISS_NUM
585: -- p_channel_name IN VARCHAR2 Optional
586: -- the channel name. Default = FND_API.G_MISS_CHAR
580: -- Default = FND_API.G_FALSE
581: -- p_validation_level NUMBER Optional
582: -- Default = FND_API.G_VALID_LEVEL_FULL
583: -- p_channel_id IN NUMBER Optional
584: -- the channel id. Default = FND_API.G_MISS_NUM
585: -- p_channel_name IN VARCHAR2 Optional
586: -- the channel name. Default = FND_API.G_MISS_CHAR
587: -- Either pass the channe id (preferred) or channel name
588: -- to identify the channel.
582: -- Default = FND_API.G_VALID_LEVEL_FULL
583: -- p_channel_id IN NUMBER Optional
584: -- the channel id. Default = FND_API.G_MISS_NUM
585: -- p_channel_name IN VARCHAR2 Optional
586: -- the channel name. Default = FND_API.G_MISS_CHAR
587: -- Either pass the channe id (preferred) or channel name
588: -- to identify the channel.
589: -- p_category_id IN NUMBER Optional
590: -- the category id. Default = FND_API.G_MISS_NUM
586: -- the channel name. Default = FND_API.G_MISS_CHAR
587: -- Either pass the channe id (preferred) or channel name
588: -- to identify the channel.
589: -- p_category_id IN NUMBER Optional
590: -- the category id. Default = FND_API.G_MISS_NUM
591: -- p_keywords_array IN AMV_CHAR_VARRAY_TYPE
592: -- OUT : x_return_status OUT VARCHAR2
593: -- x_msg_count OUT NUMBER
594: -- x_msg_data OUT VARCHAR2
600: -- End of comments
601: --
602: PROCEDURE Set_ChannelKeywords
603: ( p_api_version IN NUMBER,
604: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
605: p_commit IN VARCHAR2 := FND_API.G_FALSE,
606: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
607: x_return_status OUT NOCOPY VARCHAR2,
608: x_msg_count OUT NOCOPY NUMBER,
601: --
602: PROCEDURE Set_ChannelKeywords
603: ( p_api_version IN NUMBER,
604: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
605: p_commit IN VARCHAR2 := FND_API.G_FALSE,
606: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
607: x_return_status OUT NOCOPY VARCHAR2,
608: x_msg_count OUT NOCOPY NUMBER,
609: x_msg_data OUT NOCOPY VARCHAR2,
602: PROCEDURE Set_ChannelKeywords
603: ( p_api_version IN NUMBER,
604: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
605: p_commit IN VARCHAR2 := FND_API.G_FALSE,
606: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
607: x_return_status OUT NOCOPY VARCHAR2,
608: x_msg_count OUT NOCOPY NUMBER,
609: x_msg_data OUT NOCOPY VARCHAR2,
610: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
606: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
607: x_return_status OUT NOCOPY VARCHAR2,
608: x_msg_count OUT NOCOPY NUMBER,
609: x_msg_data OUT NOCOPY VARCHAR2,
610: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
611: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
612: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
613: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
614: p_keywords_array IN AMV_CHANNEL_PVT.AMV_CHAR_VARRAY_TYPE
607: x_return_status OUT NOCOPY VARCHAR2,
608: x_msg_count OUT NOCOPY NUMBER,
609: x_msg_data OUT NOCOPY VARCHAR2,
610: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
611: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
612: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
613: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
614: p_keywords_array IN AMV_CHANNEL_PVT.AMV_CHAR_VARRAY_TYPE
615: );
608: x_msg_count OUT NOCOPY NUMBER,
609: x_msg_data OUT NOCOPY VARCHAR2,
610: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
611: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
612: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
613: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
614: p_keywords_array IN AMV_CHANNEL_PVT.AMV_CHAR_VARRAY_TYPE
615: );
616: --------------------------------------------------------------------------------
609: x_msg_data OUT NOCOPY VARCHAR2,
610: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
611: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
612: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
613: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
614: p_keywords_array IN AMV_CHANNEL_PVT.AMV_CHAR_VARRAY_TYPE
615: );
616: --------------------------------------------------------------------------------
617: -- Start of comments
621: -- Function : Get keywords of the content channel.
622: -- Parameters :
623: -- IN p_api_version IN NUMBER Required
624: -- p_init_msg_list IN VARCHAR2 Optional
625: -- Default = FND_API.G_FALSE
626: -- p_validation_level NUMBER Optional
627: -- Default = FND_API.G_VALID_LEVEL_FULL
628: -- p_channel_id IN NUMBER Optional
629: -- the channel id. Default = FND_API.G_MISS_NUM
623: -- IN p_api_version IN NUMBER Required
624: -- p_init_msg_list IN VARCHAR2 Optional
625: -- Default = FND_API.G_FALSE
626: -- p_validation_level NUMBER Optional
627: -- Default = FND_API.G_VALID_LEVEL_FULL
628: -- p_channel_id IN NUMBER Optional
629: -- the channel id. Default = FND_API.G_MISS_NUM
630: -- p_channel_name IN VARCHAR2 Optional
631: -- the channel name. Default = FND_API.G_MISS_CHAR
625: -- Default = FND_API.G_FALSE
626: -- p_validation_level NUMBER Optional
627: -- Default = FND_API.G_VALID_LEVEL_FULL
628: -- p_channel_id IN NUMBER Optional
629: -- the channel id. Default = FND_API.G_MISS_NUM
630: -- p_channel_name IN VARCHAR2 Optional
631: -- the channel name. Default = FND_API.G_MISS_CHAR
632: -- Either pass the channe id (preferred) or channel name
633: -- to identify the channel.
627: -- Default = FND_API.G_VALID_LEVEL_FULL
628: -- p_channel_id IN NUMBER Optional
629: -- the channel id. Default = FND_API.G_MISS_NUM
630: -- p_channel_name IN VARCHAR2 Optional
631: -- the channel name. Default = FND_API.G_MISS_CHAR
632: -- Either pass the channe id (preferred) or channel name
633: -- to identify the channel.
634: -- p_category_id IN NUMBER Optional
635: -- the category id. Default = FND_API.G_MISS_NUM
631: -- the channel name. Default = FND_API.G_MISS_CHAR
632: -- Either pass the channe id (preferred) or channel name
633: -- to identify the channel.
634: -- p_category_id IN NUMBER Optional
635: -- the category id. Default = FND_API.G_MISS_NUM
636: -- OUT : x_return_status OUT VARCHAR2
637: -- x_msg_count OUT NUMBER
638: -- x_msg_data OUT VARCHAR2
639: -- x_keywords_array OUT AMV_CHAR_VARRAY_TYPE
645: -- End of comments
646: --
647: PROCEDURE Get_ChannelKeywords
648: ( p_api_version IN NUMBER,
649: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
650: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
651: x_return_status OUT NOCOPY VARCHAR2,
652: x_msg_count OUT NOCOPY NUMBER,
653: x_msg_data OUT NOCOPY VARCHAR2,
646: --
647: PROCEDURE Get_ChannelKeywords
648: ( p_api_version IN NUMBER,
649: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
650: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
651: x_return_status OUT NOCOPY VARCHAR2,
652: x_msg_count OUT NOCOPY NUMBER,
653: x_msg_data OUT NOCOPY VARCHAR2,
654: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
650: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
651: x_return_status OUT NOCOPY VARCHAR2,
652: x_msg_count OUT NOCOPY NUMBER,
653: x_msg_data OUT NOCOPY VARCHAR2,
654: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
655: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
656: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
657: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
658: x_keywords_array OUT NOCOPY AMV_CHANNEL_PVT.AMV_CHAR_VARRAY_TYPE
651: x_return_status OUT NOCOPY VARCHAR2,
652: x_msg_count OUT NOCOPY NUMBER,
653: x_msg_data OUT NOCOPY VARCHAR2,
654: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
655: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
656: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
657: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
658: x_keywords_array OUT NOCOPY AMV_CHANNEL_PVT.AMV_CHAR_VARRAY_TYPE
659: );
652: x_msg_count OUT NOCOPY NUMBER,
653: x_msg_data OUT NOCOPY VARCHAR2,
654: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
655: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
656: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
657: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
658: x_keywords_array OUT NOCOPY AMV_CHANNEL_PVT.AMV_CHAR_VARRAY_TYPE
659: );
660: --------------------------------------------------------------------------------
653: x_msg_data OUT NOCOPY VARCHAR2,
654: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
655: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
656: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
657: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
658: x_keywords_array OUT NOCOPY AMV_CHANNEL_PVT.AMV_CHAR_VARRAY_TYPE
659: );
660: --------------------------------------------------------------------------------
661: -- Start of comments
665: -- Function : Change authors of the content channel.
666: -- Parameters :
667: -- IN p_api_version IN NUMBER Required
668: -- p_init_msg_list IN VARCHAR2 Optional
669: -- Default = FND_API.G_FALSE
670: -- p_commit IN VARCHAR2 Optional
671: -- Default = FND_API.G_FALSE
672: -- p_validation_level NUMBER Optional
673: -- Default = FND_API.G_VALID_LEVEL_FULL
667: -- IN p_api_version IN NUMBER Required
668: -- p_init_msg_list IN VARCHAR2 Optional
669: -- Default = FND_API.G_FALSE
670: -- p_commit IN VARCHAR2 Optional
671: -- Default = FND_API.G_FALSE
672: -- p_validation_level NUMBER Optional
673: -- Default = FND_API.G_VALID_LEVEL_FULL
674: -- p_channel_id IN NUMBER Optional
675: -- the channel id. Default = FND_API.G_MISS_NUM
669: -- Default = FND_API.G_FALSE
670: -- p_commit IN VARCHAR2 Optional
671: -- Default = FND_API.G_FALSE
672: -- p_validation_level NUMBER Optional
673: -- Default = FND_API.G_VALID_LEVEL_FULL
674: -- p_channel_id IN NUMBER Optional
675: -- the channel id. Default = FND_API.G_MISS_NUM
676: -- p_channel_name IN VARCHAR2 Optional
677: -- the channel name. Default = FND_API.G_MISS_CHAR
671: -- Default = FND_API.G_FALSE
672: -- p_validation_level NUMBER Optional
673: -- Default = FND_API.G_VALID_LEVEL_FULL
674: -- p_channel_id IN NUMBER Optional
675: -- the channel id. Default = FND_API.G_MISS_NUM
676: -- p_channel_name IN VARCHAR2 Optional
677: -- the channel name. Default = FND_API.G_MISS_CHAR
678: -- Either pass the channe id (preferred) or channel name
679: -- to identify the channel.
673: -- Default = FND_API.G_VALID_LEVEL_FULL
674: -- p_channel_id IN NUMBER Optional
675: -- the channel id. Default = FND_API.G_MISS_NUM
676: -- p_channel_name IN VARCHAR2 Optional
677: -- the channel name. Default = FND_API.G_MISS_CHAR
678: -- Either pass the channe id (preferred) or channel name
679: -- to identify the channel.
680: -- p_category_id IN NUMBER Optional
681: -- the category id. Default = FND_API.G_MISS_NUM
677: -- the channel name. Default = FND_API.G_MISS_CHAR
678: -- Either pass the channe id (preferred) or channel name
679: -- to identify the channel.
680: -- p_category_id IN NUMBER Optional
681: -- the category id. Default = FND_API.G_MISS_NUM
682: -- p_authors_array IN AMV_CHAR_VARRAY_TYPE
683: -- OUT : x_return_status OUT VARCHAR2
684: -- x_msg_count OUT NUMBER
685: -- x_msg_data OUT VARCHAR2
691: -- End of comments
692: --
693: PROCEDURE Set_ChannelAuthors
694: ( p_api_version IN NUMBER,
695: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
696: p_commit IN VARCHAR2 := FND_API.G_FALSE,
697: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
698: x_return_status OUT NOCOPY VARCHAR2,
699: x_msg_count OUT NOCOPY NUMBER,
692: --
693: PROCEDURE Set_ChannelAuthors
694: ( p_api_version IN NUMBER,
695: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
696: p_commit IN VARCHAR2 := FND_API.G_FALSE,
697: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
698: x_return_status OUT NOCOPY VARCHAR2,
699: x_msg_count OUT NOCOPY NUMBER,
700: x_msg_data OUT NOCOPY VARCHAR2,
693: PROCEDURE Set_ChannelAuthors
694: ( p_api_version IN NUMBER,
695: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
696: p_commit IN VARCHAR2 := FND_API.G_FALSE,
697: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
698: x_return_status OUT NOCOPY VARCHAR2,
699: x_msg_count OUT NOCOPY NUMBER,
700: x_msg_data OUT NOCOPY VARCHAR2,
701: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
697: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
698: x_return_status OUT NOCOPY VARCHAR2,
699: x_msg_count OUT NOCOPY NUMBER,
700: x_msg_data OUT NOCOPY VARCHAR2,
701: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
702: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
703: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
704: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
705: p_authors_array IN AMV_CHANNEL_PVT.AMV_CHAR_VARRAY_TYPE
698: x_return_status OUT NOCOPY VARCHAR2,
699: x_msg_count OUT NOCOPY NUMBER,
700: x_msg_data OUT NOCOPY VARCHAR2,
701: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
702: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
703: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
704: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
705: p_authors_array IN AMV_CHANNEL_PVT.AMV_CHAR_VARRAY_TYPE
706: );
699: x_msg_count OUT NOCOPY NUMBER,
700: x_msg_data OUT NOCOPY VARCHAR2,
701: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
702: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
703: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
704: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
705: p_authors_array IN AMV_CHANNEL_PVT.AMV_CHAR_VARRAY_TYPE
706: );
707: --------------------------------------------------------------------------------
700: x_msg_data OUT NOCOPY VARCHAR2,
701: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
702: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
703: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
704: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
705: p_authors_array IN AMV_CHANNEL_PVT.AMV_CHAR_VARRAY_TYPE
706: );
707: --------------------------------------------------------------------------------
708: -- Start of comments
712: -- Function : Get authors of the content channel.
713: -- Parameters :
714: -- IN p_api_version IN NUMBER Required
715: -- p_init_msg_list IN VARCHAR2 Optional
716: -- Default = FND_API.G_FALSE
717: -- p_validation_level NUMBER Optional
718: -- Default = FND_API.G_VALID_LEVEL_FULL
719: -- p_channel_id IN NUMBER Optional
720: -- the channel id. Default = FND_API.G_MISS_NUM
714: -- IN p_api_version IN NUMBER Required
715: -- p_init_msg_list IN VARCHAR2 Optional
716: -- Default = FND_API.G_FALSE
717: -- p_validation_level NUMBER Optional
718: -- Default = FND_API.G_VALID_LEVEL_FULL
719: -- p_channel_id IN NUMBER Optional
720: -- the channel id. Default = FND_API.G_MISS_NUM
721: -- p_channel_name IN VARCHAR2 Optional
722: -- the channel name. Default = FND_API.G_MISS_CHAR
716: -- Default = FND_API.G_FALSE
717: -- p_validation_level NUMBER Optional
718: -- Default = FND_API.G_VALID_LEVEL_FULL
719: -- p_channel_id IN NUMBER Optional
720: -- the channel id. Default = FND_API.G_MISS_NUM
721: -- p_channel_name IN VARCHAR2 Optional
722: -- the channel name. Default = FND_API.G_MISS_CHAR
723: -- Either pass the channe id (preferred) or channel name
724: -- to identify the channel.
718: -- Default = FND_API.G_VALID_LEVEL_FULL
719: -- p_channel_id IN NUMBER Optional
720: -- the channel id. Default = FND_API.G_MISS_NUM
721: -- p_channel_name IN VARCHAR2 Optional
722: -- the channel name. Default = FND_API.G_MISS_CHAR
723: -- Either pass the channe id (preferred) or channel name
724: -- to identify the channel.
725: -- p_category_id IN NUMBER Optional
726: -- the category id. Default = FND_API.G_MISS_NUM
722: -- the channel name. Default = FND_API.G_MISS_CHAR
723: -- Either pass the channe id (preferred) or channel name
724: -- to identify the channel.
725: -- p_category_id IN NUMBER Optional
726: -- the category id. Default = FND_API.G_MISS_NUM
727: -- OUT : x_return_status OUT VARCHAR2
728: -- x_msg_count OUT NUMBER
729: -- x_msg_data OUT VARCHAR2
730: -- x_authors_array OUT AMV_CHAR_VARRAY_TYPE
736: -- End of comments
737: --
738: PROCEDURE Get_ChannelAuthors
739: ( p_api_version IN NUMBER,
740: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
741: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
742: x_return_status OUT NOCOPY VARCHAR2,
743: x_msg_count OUT NOCOPY NUMBER,
744: x_msg_data OUT NOCOPY VARCHAR2,
737: --
738: PROCEDURE Get_ChannelAuthors
739: ( p_api_version IN NUMBER,
740: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
741: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
742: x_return_status OUT NOCOPY VARCHAR2,
743: x_msg_count OUT NOCOPY NUMBER,
744: x_msg_data OUT NOCOPY VARCHAR2,
745: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
741: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
742: x_return_status OUT NOCOPY VARCHAR2,
743: x_msg_count OUT NOCOPY NUMBER,
744: x_msg_data OUT NOCOPY VARCHAR2,
745: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
746: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
747: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
748: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
749: x_authors_array OUT NOCOPY AMV_CHANNEL_PVT.AMV_CHAR_VARRAY_TYPE
742: x_return_status OUT NOCOPY VARCHAR2,
743: x_msg_count OUT NOCOPY NUMBER,
744: x_msg_data OUT NOCOPY VARCHAR2,
745: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
746: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
747: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
748: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
749: x_authors_array OUT NOCOPY AMV_CHANNEL_PVT.AMV_CHAR_VARRAY_TYPE
750: );
743: x_msg_count OUT NOCOPY NUMBER,
744: x_msg_data OUT NOCOPY VARCHAR2,
745: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
746: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
747: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
748: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
749: x_authors_array OUT NOCOPY AMV_CHANNEL_PVT.AMV_CHAR_VARRAY_TYPE
750: );
751: --------------------------------------------------------------------------------
744: x_msg_data OUT NOCOPY VARCHAR2,
745: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
746: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
747: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
748: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
749: x_authors_array OUT NOCOPY AMV_CHANNEL_PVT.AMV_CHAR_VARRAY_TYPE
750: );
751: --------------------------------------------------------------------------------
752: -- Start of comments
757: -- channel id (preferred) or channel name.
758: -- Parameters :
759: -- IN p_api_version IN NUMBER Required
760: -- p_init_msg_list IN VARCHAR2 Optional
761: -- Default = FND_API.G_FALSE
762: -- p_validation_level NUMBER Optional
763: -- Default = FND_API.G_VALID_LEVEL_FULL
764: -- p_channel_id IN NUMBER Optional
765: -- the channel id. Default = FND_API.G_MISS_NUM
759: -- IN p_api_version IN NUMBER Required
760: -- p_init_msg_list IN VARCHAR2 Optional
761: -- Default = FND_API.G_FALSE
762: -- p_validation_level NUMBER Optional
763: -- Default = FND_API.G_VALID_LEVEL_FULL
764: -- p_channel_id IN NUMBER Optional
765: -- the channel id. Default = FND_API.G_MISS_NUM
766: -- p_channel_name IN VARCHAR2 Optional
767: -- the channel name. Default = FND_API.G_MISS_CHAR
761: -- Default = FND_API.G_FALSE
762: -- p_validation_level NUMBER Optional
763: -- Default = FND_API.G_VALID_LEVEL_FULL
764: -- p_channel_id IN NUMBER Optional
765: -- the channel id. Default = FND_API.G_MISS_NUM
766: -- p_channel_name IN VARCHAR2 Optional
767: -- the channel name. Default = FND_API.G_MISS_CHAR
768: -- Either pass the channe id (preferred) or channel name
769: -- to identify the channel.
763: -- Default = FND_API.G_VALID_LEVEL_FULL
764: -- p_channel_id IN NUMBER Optional
765: -- the channel id. Default = FND_API.G_MISS_NUM
766: -- p_channel_name IN VARCHAR2 Optional
767: -- the channel name. Default = FND_API.G_MISS_CHAR
768: -- Either pass the channe id (preferred) or channel name
769: -- to identify the channel.
770: -- p_category_id IN NUMBER Optional
771: -- the category id. Default = FND_API.G_MISS_NUM
767: -- the channel name. Default = FND_API.G_MISS_CHAR
768: -- Either pass the channe id (preferred) or channel name
769: -- to identify the channel.
770: -- p_category_id IN NUMBER Optional
771: -- the category id. Default = FND_API.G_MISS_NUM
772: -- p_subset_request_rec IN AMV_REQUEST_OBJ_TYPE
773: -- Required
774: -- OUT : x_return_status OUT VARCHAR2
775: -- x_msg_count OUT NUMBER
784: -- End of comments
785: --
786: PROCEDURE Get_ItemsPerChannel
787: ( p_api_version IN NUMBER,
788: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
789: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
790: x_return_status OUT NOCOPY VARCHAR2,
791: x_msg_count OUT NOCOPY NUMBER,
792: x_msg_data OUT NOCOPY VARCHAR2,
785: --
786: PROCEDURE Get_ItemsPerChannel
787: ( p_api_version IN NUMBER,
788: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
789: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
790: x_return_status OUT NOCOPY VARCHAR2,
791: x_msg_count OUT NOCOPY NUMBER,
792: x_msg_data OUT NOCOPY VARCHAR2,
793: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
789: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
790: x_return_status OUT NOCOPY VARCHAR2,
791: x_msg_count OUT NOCOPY NUMBER,
792: x_msg_data OUT NOCOPY VARCHAR2,
793: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
794: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
795: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
796: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
797: p_subset_request_rec IN AMV_CHANNEL_PVT.AMV_REQUEST_OBJ_TYPE,
790: x_return_status OUT NOCOPY VARCHAR2,
791: x_msg_count OUT NOCOPY NUMBER,
792: x_msg_data OUT NOCOPY VARCHAR2,
793: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
794: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
795: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
796: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
797: p_subset_request_rec IN AMV_CHANNEL_PVT.AMV_REQUEST_OBJ_TYPE,
798: x_subset_return_rec OUT NOCOPY AMV_CHANNEL_PVT.AMV_RETURN_OBJ_TYPE,
791: x_msg_count OUT NOCOPY NUMBER,
792: x_msg_data OUT NOCOPY VARCHAR2,
793: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
794: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
795: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
796: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
797: p_subset_request_rec IN AMV_CHANNEL_PVT.AMV_REQUEST_OBJ_TYPE,
798: x_subset_return_rec OUT NOCOPY AMV_CHANNEL_PVT.AMV_RETURN_OBJ_TYPE,
799: x_document_id_array OUT NOCOPY AMV_CHANNEL_PVT.AMV_NUMBER_VARRAY_TYPE
792: x_msg_data OUT NOCOPY VARCHAR2,
793: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
794: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
795: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
796: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
797: p_subset_request_rec IN AMV_CHANNEL_PVT.AMV_REQUEST_OBJ_TYPE,
798: x_subset_return_rec OUT NOCOPY AMV_CHANNEL_PVT.AMV_RETURN_OBJ_TYPE,
799: x_document_id_array OUT NOCOPY AMV_CHANNEL_PVT.AMV_NUMBER_VARRAY_TYPE
800: );
807: -- Function : Get all documents matching the input criteria.
808: -- Parameters :
809: -- IN p_api_version IN NUMBER Required
810: -- p_init_msg_list IN VARCHAR2 Optional
811: -- Default = FND_API.G_FALSE
812: -- p_validation_level NUMBER Optional
813: -- Default = FND_API.G_VALID_LEVEL_FULL
814: -- p_criteria_rec IN
815: -- AMV_CHANNEL_OBJ_TYPE Required
809: -- IN p_api_version IN NUMBER Required
810: -- p_init_msg_list IN VARCHAR2 Optional
811: -- Default = FND_API.G_FALSE
812: -- p_validation_level NUMBER Optional
813: -- Default = FND_API.G_VALID_LEVEL_FULL
814: -- p_criteria_rec IN
815: -- AMV_CHANNEL_OBJ_TYPE Required
816: -- p_sort_by IN VARCHAR2 Optional
817: -- Default = FND_API.G_MISS_CHAR
813: -- Default = FND_API.G_VALID_LEVEL_FULL
814: -- p_criteria_rec IN
815: -- AMV_CHANNEL_OBJ_TYPE Required
816: -- p_sort_by IN VARCHAR2 Optional
817: -- Default = FND_API.G_MISS_CHAR
818: -- p_subset_request_rec IN AMV_REQUEST_OBJ_TYPE
819: -- Required
820: -- OUT : x_return_status OUT VARCHAR2
821: -- x_msg_count OUT NUMBER
830: -- End of comments
831: --
832: PROCEDURE Find_Channels
833: ( p_api_version IN NUMBER,
834: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
835: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
836: x_return_status OUT NOCOPY VARCHAR2,
837: x_msg_count OUT NOCOPY NUMBER,
838: x_msg_data OUT NOCOPY VARCHAR2,
831: --
832: PROCEDURE Find_Channels
833: ( p_api_version IN NUMBER,
834: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
835: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
836: x_return_status OUT NOCOPY VARCHAR2,
837: x_msg_count OUT NOCOPY NUMBER,
838: x_msg_data OUT NOCOPY VARCHAR2,
839: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
835: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
836: x_return_status OUT NOCOPY VARCHAR2,
837: x_msg_count OUT NOCOPY NUMBER,
838: x_msg_data OUT NOCOPY VARCHAR2,
839: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
840: p_criteria_rec IN AMV_CHANNEL_PVT.AMV_CHANNEL_OBJ_TYPE,
841: p_sort_by IN VARCHAR2 := FND_API.G_MISS_CHAR,
842: p_subset_request_rec IN AMV_CHANNEL_PVT.AMV_REQUEST_OBJ_TYPE,
843: x_subset_return_rec OUT NOCOPY AMV_CHANNEL_PVT.AMV_RETURN_OBJ_TYPE,
837: x_msg_count OUT NOCOPY NUMBER,
838: x_msg_data OUT NOCOPY VARCHAR2,
839: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
840: p_criteria_rec IN AMV_CHANNEL_PVT.AMV_CHANNEL_OBJ_TYPE,
841: p_sort_by IN VARCHAR2 := FND_API.G_MISS_CHAR,
842: p_subset_request_rec IN AMV_CHANNEL_PVT.AMV_REQUEST_OBJ_TYPE,
843: x_subset_return_rec OUT NOCOPY AMV_CHANNEL_PVT.AMV_RETURN_OBJ_TYPE,
844: x_content_chan_array OUT NOCOPY AMV_CHANNEL_PVT.AMV_CHANNEL_VARRAY_TYPE
845: );