[Home] [Help]
PACKAGE BODY: APPS.AMV_CHANNEL_GRP_W
Source
1 package body amv_channel_grp_w as
2 /* $Header: amvwchgb.pls 120.2 2005/06/30 07:51 appldev ship $ */
3 rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
4 rosetta_g_miss_date date := to_date('01/01/-4712', 'MM/DD/SYYYY');
5
6 -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
7 function rosetta_g_miss_date_in_map(d date) return date as
8 begin
9 if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
10 return d;
11 end;
12
13 function rosetta_g_miss_num_map(n number) return number as
14 a number := fnd_api.g_miss_num;
15 b number := 0-1962.0724;
16 begin
17 if n=a then return b; end if;
18 if n=b then return a; end if;
19 return n;
20 end;
21
22 procedure add_publicchannel(p_api_version NUMBER
23 , p_init_msg_list VARCHAR2
24 , p_commit VARCHAR2
25 , p_validation_level NUMBER
26 , x_return_status out nocopy VARCHAR2
27 , x_msg_count out nocopy NUMBER
28 , x_msg_data out nocopy VARCHAR2
29 , p_check_login_user VARCHAR2
30 , x_channel_id out nocopy NUMBER
31 , p8_a0 NUMBER := 0-1962.0724
32 , p8_a1 NUMBER := 0-1962.0724
33 , p8_a2 VARCHAR2 := fnd_api.g_miss_char
34 , p8_a3 VARCHAR2 := fnd_api.g_miss_char
35 , p8_a4 VARCHAR2 := fnd_api.g_miss_char
36 , p8_a5 NUMBER := 0-1962.0724
37 , p8_a6 VARCHAR2 := fnd_api.g_miss_char
38 , p8_a7 NUMBER := 0-1962.0724
39 , p8_a8 NUMBER := 0-1962.0724
40 , p8_a9 DATE := fnd_api.g_miss_date
41 , p8_a10 DATE := fnd_api.g_miss_date
42 , p8_a11 VARCHAR2 := fnd_api.g_miss_char
43 , p8_a12 VARCHAR2 := fnd_api.g_miss_char
44 , p8_a13 VARCHAR2 := fnd_api.g_miss_char
45 , p8_a14 VARCHAR2 := fnd_api.g_miss_char
46 , p8_a15 VARCHAR2 := fnd_api.g_miss_char
47 , p8_a16 VARCHAR2 := fnd_api.g_miss_char
48 , p8_a17 VARCHAR2 := fnd_api.g_miss_char
49 , p8_a18 VARCHAR2 := fnd_api.g_miss_char
50 , p8_a19 VARCHAR2 := fnd_api.g_miss_char
51 , p8_a20 VARCHAR2 := fnd_api.g_miss_char
52 , p8_a21 NUMBER := 0-1962.0724
53 , p8_a22 VARCHAR2 := fnd_api.g_miss_char
54 , p8_a23 NUMBER := 0-1962.0724
55 , p8_a24 DATE := fnd_api.g_miss_date
56 , p8_a25 VARCHAR2 := fnd_api.g_miss_char
57 , p8_a26 DATE := fnd_api.g_miss_date
58 , p8_a27 VARCHAR2 := fnd_api.g_miss_char
59 , p8_a28 VARCHAR2 := fnd_api.g_miss_char
60 , p8_a29 VARCHAR2 := fnd_api.g_miss_char
61 , p8_a30 VARCHAR2 := fnd_api.g_miss_char
62 , p8_a31 VARCHAR2 := fnd_api.g_miss_char
63 , p8_a32 VARCHAR2 := fnd_api.g_miss_char
64 , p8_a33 VARCHAR2 := fnd_api.g_miss_char
65 , p8_a34 VARCHAR2 := fnd_api.g_miss_char
66 , p8_a35 VARCHAR2 := fnd_api.g_miss_char
67 , p8_a36 VARCHAR2 := fnd_api.g_miss_char
68 , p8_a37 VARCHAR2 := fnd_api.g_miss_char
69 , p8_a38 VARCHAR2 := fnd_api.g_miss_char
70 , p8_a39 VARCHAR2 := fnd_api.g_miss_char
71 , p8_a40 VARCHAR2 := fnd_api.g_miss_char
72 , p8_a41 VARCHAR2 := fnd_api.g_miss_char
73 , p8_a42 VARCHAR2 := fnd_api.g_miss_char
74 )
75
76 as
77 ddp_channel_record amv_channel_pvt.amv_channel_obj_type;
78 ddindx binary_integer; indx binary_integer;
79 begin
80
81 -- copy data to the local IN or IN-OUT args, if any
82
83
84
85
86
87
88
89
90 ddp_channel_record.channel_id := rosetta_g_miss_num_map(p8_a0);
91 ddp_channel_record.object_version_number := rosetta_g_miss_num_map(p8_a1);
92 ddp_channel_record.channel_name := p8_a2;
93 ddp_channel_record.description := p8_a3;
94 ddp_channel_record.channel_type := p8_a4;
95 ddp_channel_record.channel_category_id := rosetta_g_miss_num_map(p8_a5);
96 ddp_channel_record.status := p8_a6;
97 ddp_channel_record.owner_user_id := rosetta_g_miss_num_map(p8_a7);
98 ddp_channel_record.default_approver_user_id := rosetta_g_miss_num_map(p8_a8);
99 ddp_channel_record.effective_start_date := rosetta_g_miss_date_in_map(p8_a9);
100 ddp_channel_record.expiration_date := rosetta_g_miss_date_in_map(p8_a10);
101 ddp_channel_record.access_level_type := p8_a11;
102 ddp_channel_record.pub_need_approval_flag := p8_a12;
103 ddp_channel_record.sub_need_approval_flag := p8_a13;
104 ddp_channel_record.match_on_all_criteria_flag := p8_a14;
105 ddp_channel_record.match_on_keyword_flag := p8_a15;
106 ddp_channel_record.match_on_author_flag := p8_a16;
107 ddp_channel_record.match_on_perspective_flag := p8_a17;
108 ddp_channel_record.match_on_item_type_flag := p8_a18;
109 ddp_channel_record.match_on_content_type_flag := p8_a19;
110 ddp_channel_record.match_on_time_flag := p8_a20;
111 ddp_channel_record.application_id := rosetta_g_miss_num_map(p8_a21);
112 ddp_channel_record.external_access_flag := p8_a22;
113 ddp_channel_record.item_match_count := rosetta_g_miss_num_map(p8_a23);
114 ddp_channel_record.last_match_time := rosetta_g_miss_date_in_map(p8_a24);
115 ddp_channel_record.notification_interval_type := p8_a25;
116 ddp_channel_record.last_notification_time := rosetta_g_miss_date_in_map(p8_a26);
117 ddp_channel_record.attribute_category := p8_a27;
118 ddp_channel_record.attribute1 := p8_a28;
119 ddp_channel_record.attribute2 := p8_a29;
120 ddp_channel_record.attribute3 := p8_a30;
121 ddp_channel_record.attribute4 := p8_a31;
122 ddp_channel_record.attribute5 := p8_a32;
123 ddp_channel_record.attribute6 := p8_a33;
124 ddp_channel_record.attribute7 := p8_a34;
125 ddp_channel_record.attribute8 := p8_a35;
126 ddp_channel_record.attribute9 := p8_a36;
127 ddp_channel_record.attribute10 := p8_a37;
128 ddp_channel_record.attribute11 := p8_a38;
129 ddp_channel_record.attribute12 := p8_a39;
130 ddp_channel_record.attribute13 := p8_a40;
131 ddp_channel_record.attribute14 := p8_a41;
132 ddp_channel_record.attribute15 := p8_a42;
133
134
135 -- here's the delegated call to the old PL/SQL routine
136 amv_channel_grp.add_publicchannel(p_api_version,
137 p_init_msg_list,
138 p_commit,
139 p_validation_level,
140 x_return_status,
141 x_msg_count,
142 x_msg_data,
143 p_check_login_user,
144 ddp_channel_record,
145 x_channel_id);
146
147 -- copy data back from the local variables to OUT or IN-OUT args, if any
148
149
150
151
152
153
154
155
156
157 end;
158
159 procedure add_protectedchannel(p_api_version NUMBER
160 , p_init_msg_list VARCHAR2
161 , p_commit VARCHAR2
162 , p_validation_level NUMBER
163 , x_return_status out nocopy VARCHAR2
164 , x_msg_count out nocopy NUMBER
165 , x_msg_data out nocopy VARCHAR2
166 , p_check_login_user VARCHAR2
167 , x_channel_id out nocopy NUMBER
168 , p8_a0 NUMBER := 0-1962.0724
169 , p8_a1 NUMBER := 0-1962.0724
170 , p8_a2 VARCHAR2 := fnd_api.g_miss_char
171 , p8_a3 VARCHAR2 := fnd_api.g_miss_char
172 , p8_a4 VARCHAR2 := fnd_api.g_miss_char
173 , p8_a5 NUMBER := 0-1962.0724
174 , p8_a6 VARCHAR2 := fnd_api.g_miss_char
175 , p8_a7 NUMBER := 0-1962.0724
176 , p8_a8 NUMBER := 0-1962.0724
177 , p8_a9 DATE := fnd_api.g_miss_date
178 , p8_a10 DATE := fnd_api.g_miss_date
179 , p8_a11 VARCHAR2 := fnd_api.g_miss_char
180 , p8_a12 VARCHAR2 := fnd_api.g_miss_char
181 , p8_a13 VARCHAR2 := fnd_api.g_miss_char
182 , p8_a14 VARCHAR2 := fnd_api.g_miss_char
183 , p8_a15 VARCHAR2 := fnd_api.g_miss_char
184 , p8_a16 VARCHAR2 := fnd_api.g_miss_char
185 , p8_a17 VARCHAR2 := fnd_api.g_miss_char
186 , p8_a18 VARCHAR2 := fnd_api.g_miss_char
187 , p8_a19 VARCHAR2 := fnd_api.g_miss_char
188 , p8_a20 VARCHAR2 := fnd_api.g_miss_char
189 , p8_a21 NUMBER := 0-1962.0724
190 , p8_a22 VARCHAR2 := fnd_api.g_miss_char
191 , p8_a23 NUMBER := 0-1962.0724
192 , p8_a24 DATE := fnd_api.g_miss_date
193 , p8_a25 VARCHAR2 := fnd_api.g_miss_char
194 , p8_a26 DATE := fnd_api.g_miss_date
195 , p8_a27 VARCHAR2 := fnd_api.g_miss_char
196 , p8_a28 VARCHAR2 := fnd_api.g_miss_char
197 , p8_a29 VARCHAR2 := fnd_api.g_miss_char
198 , p8_a30 VARCHAR2 := fnd_api.g_miss_char
199 , p8_a31 VARCHAR2 := fnd_api.g_miss_char
200 , p8_a32 VARCHAR2 := fnd_api.g_miss_char
201 , p8_a33 VARCHAR2 := fnd_api.g_miss_char
202 , p8_a34 VARCHAR2 := fnd_api.g_miss_char
203 , p8_a35 VARCHAR2 := fnd_api.g_miss_char
204 , p8_a36 VARCHAR2 := fnd_api.g_miss_char
205 , p8_a37 VARCHAR2 := fnd_api.g_miss_char
206 , p8_a38 VARCHAR2 := fnd_api.g_miss_char
207 , p8_a39 VARCHAR2 := fnd_api.g_miss_char
208 , p8_a40 VARCHAR2 := fnd_api.g_miss_char
209 , p8_a41 VARCHAR2 := fnd_api.g_miss_char
210 , p8_a42 VARCHAR2 := fnd_api.g_miss_char
211 )
212
213 as
214 ddp_channel_record amv_channel_pvt.amv_channel_obj_type;
215 ddindx binary_integer; indx binary_integer;
216 begin
217
218 -- copy data to the local IN or IN-OUT args, if any
219
220
221
222
223
224
225
226
227 ddp_channel_record.channel_id := rosetta_g_miss_num_map(p8_a0);
228 ddp_channel_record.object_version_number := rosetta_g_miss_num_map(p8_a1);
229 ddp_channel_record.channel_name := p8_a2;
230 ddp_channel_record.description := p8_a3;
231 ddp_channel_record.channel_type := p8_a4;
232 ddp_channel_record.channel_category_id := rosetta_g_miss_num_map(p8_a5);
233 ddp_channel_record.status := p8_a6;
234 ddp_channel_record.owner_user_id := rosetta_g_miss_num_map(p8_a7);
235 ddp_channel_record.default_approver_user_id := rosetta_g_miss_num_map(p8_a8);
236 ddp_channel_record.effective_start_date := rosetta_g_miss_date_in_map(p8_a9);
237 ddp_channel_record.expiration_date := rosetta_g_miss_date_in_map(p8_a10);
238 ddp_channel_record.access_level_type := p8_a11;
239 ddp_channel_record.pub_need_approval_flag := p8_a12;
240 ddp_channel_record.sub_need_approval_flag := p8_a13;
241 ddp_channel_record.match_on_all_criteria_flag := p8_a14;
242 ddp_channel_record.match_on_keyword_flag := p8_a15;
243 ddp_channel_record.match_on_author_flag := p8_a16;
244 ddp_channel_record.match_on_perspective_flag := p8_a17;
245 ddp_channel_record.match_on_item_type_flag := p8_a18;
246 ddp_channel_record.match_on_content_type_flag := p8_a19;
247 ddp_channel_record.match_on_time_flag := p8_a20;
248 ddp_channel_record.application_id := rosetta_g_miss_num_map(p8_a21);
249 ddp_channel_record.external_access_flag := p8_a22;
250 ddp_channel_record.item_match_count := rosetta_g_miss_num_map(p8_a23);
251 ddp_channel_record.last_match_time := rosetta_g_miss_date_in_map(p8_a24);
252 ddp_channel_record.notification_interval_type := p8_a25;
253 ddp_channel_record.last_notification_time := rosetta_g_miss_date_in_map(p8_a26);
254 ddp_channel_record.attribute_category := p8_a27;
255 ddp_channel_record.attribute1 := p8_a28;
256 ddp_channel_record.attribute2 := p8_a29;
257 ddp_channel_record.attribute3 := p8_a30;
258 ddp_channel_record.attribute4 := p8_a31;
259 ddp_channel_record.attribute5 := p8_a32;
260 ddp_channel_record.attribute6 := p8_a33;
261 ddp_channel_record.attribute7 := p8_a34;
262 ddp_channel_record.attribute8 := p8_a35;
263 ddp_channel_record.attribute9 := p8_a36;
264 ddp_channel_record.attribute10 := p8_a37;
265 ddp_channel_record.attribute11 := p8_a38;
266 ddp_channel_record.attribute12 := p8_a39;
267 ddp_channel_record.attribute13 := p8_a40;
268 ddp_channel_record.attribute14 := p8_a41;
269 ddp_channel_record.attribute15 := p8_a42;
270
271
272 -- here's the delegated call to the old PL/SQL routine
273 amv_channel_grp.add_protectedchannel(p_api_version,
274 p_init_msg_list,
275 p_commit,
276 p_validation_level,
277 x_return_status,
278 x_msg_count,
279 x_msg_data,
280 p_check_login_user,
281 ddp_channel_record,
282 x_channel_id);
283
284 -- copy data back from the local variables to OUT or IN-OUT args, if any
285
286
287
288
289
290
291
292
293
294 end;
295
296 procedure add_privatechannel(p_api_version NUMBER
297 , p_init_msg_list VARCHAR2
298 , p_commit VARCHAR2
299 , p_validation_level NUMBER
300 , x_return_status out nocopy VARCHAR2
301 , x_msg_count out nocopy NUMBER
302 , x_msg_data out nocopy VARCHAR2
303 , p_check_login_user VARCHAR2
304 , x_channel_id out nocopy NUMBER
305 , p8_a0 NUMBER := 0-1962.0724
306 , p8_a1 NUMBER := 0-1962.0724
307 , p8_a2 VARCHAR2 := fnd_api.g_miss_char
308 , p8_a3 VARCHAR2 := fnd_api.g_miss_char
309 , p8_a4 VARCHAR2 := fnd_api.g_miss_char
310 , p8_a5 NUMBER := 0-1962.0724
311 , p8_a6 VARCHAR2 := fnd_api.g_miss_char
312 , p8_a7 NUMBER := 0-1962.0724
313 , p8_a8 NUMBER := 0-1962.0724
314 , p8_a9 DATE := fnd_api.g_miss_date
315 , p8_a10 DATE := fnd_api.g_miss_date
316 , p8_a11 VARCHAR2 := fnd_api.g_miss_char
317 , p8_a12 VARCHAR2 := fnd_api.g_miss_char
318 , p8_a13 VARCHAR2 := fnd_api.g_miss_char
319 , p8_a14 VARCHAR2 := fnd_api.g_miss_char
320 , p8_a15 VARCHAR2 := fnd_api.g_miss_char
321 , p8_a16 VARCHAR2 := fnd_api.g_miss_char
322 , p8_a17 VARCHAR2 := fnd_api.g_miss_char
323 , p8_a18 VARCHAR2 := fnd_api.g_miss_char
324 , p8_a19 VARCHAR2 := fnd_api.g_miss_char
325 , p8_a20 VARCHAR2 := fnd_api.g_miss_char
326 , p8_a21 NUMBER := 0-1962.0724
327 , p8_a22 VARCHAR2 := fnd_api.g_miss_char
328 , p8_a23 NUMBER := 0-1962.0724
329 , p8_a24 DATE := fnd_api.g_miss_date
330 , p8_a25 VARCHAR2 := fnd_api.g_miss_char
331 , p8_a26 DATE := fnd_api.g_miss_date
332 , p8_a27 VARCHAR2 := fnd_api.g_miss_char
333 , p8_a28 VARCHAR2 := fnd_api.g_miss_char
334 , p8_a29 VARCHAR2 := fnd_api.g_miss_char
335 , p8_a30 VARCHAR2 := fnd_api.g_miss_char
336 , p8_a31 VARCHAR2 := fnd_api.g_miss_char
337 , p8_a32 VARCHAR2 := fnd_api.g_miss_char
338 , p8_a33 VARCHAR2 := fnd_api.g_miss_char
339 , p8_a34 VARCHAR2 := fnd_api.g_miss_char
340 , p8_a35 VARCHAR2 := fnd_api.g_miss_char
341 , p8_a36 VARCHAR2 := fnd_api.g_miss_char
342 , p8_a37 VARCHAR2 := fnd_api.g_miss_char
343 , p8_a38 VARCHAR2 := fnd_api.g_miss_char
344 , p8_a39 VARCHAR2 := fnd_api.g_miss_char
345 , p8_a40 VARCHAR2 := fnd_api.g_miss_char
346 , p8_a41 VARCHAR2 := fnd_api.g_miss_char
347 , p8_a42 VARCHAR2 := fnd_api.g_miss_char
348 )
349
350 as
351 ddp_channel_record amv_channel_pvt.amv_channel_obj_type;
352 ddindx binary_integer; indx binary_integer;
353 begin
354
355 -- copy data to the local IN or IN-OUT args, if any
356
357
358
359
360
361
362
363
364 ddp_channel_record.channel_id := rosetta_g_miss_num_map(p8_a0);
365 ddp_channel_record.object_version_number := rosetta_g_miss_num_map(p8_a1);
366 ddp_channel_record.channel_name := p8_a2;
367 ddp_channel_record.description := p8_a3;
368 ddp_channel_record.channel_type := p8_a4;
369 ddp_channel_record.channel_category_id := rosetta_g_miss_num_map(p8_a5);
370 ddp_channel_record.status := p8_a6;
371 ddp_channel_record.owner_user_id := rosetta_g_miss_num_map(p8_a7);
372 ddp_channel_record.default_approver_user_id := rosetta_g_miss_num_map(p8_a8);
373 ddp_channel_record.effective_start_date := rosetta_g_miss_date_in_map(p8_a9);
374 ddp_channel_record.expiration_date := rosetta_g_miss_date_in_map(p8_a10);
375 ddp_channel_record.access_level_type := p8_a11;
376 ddp_channel_record.pub_need_approval_flag := p8_a12;
377 ddp_channel_record.sub_need_approval_flag := p8_a13;
378 ddp_channel_record.match_on_all_criteria_flag := p8_a14;
379 ddp_channel_record.match_on_keyword_flag := p8_a15;
380 ddp_channel_record.match_on_author_flag := p8_a16;
381 ddp_channel_record.match_on_perspective_flag := p8_a17;
382 ddp_channel_record.match_on_item_type_flag := p8_a18;
383 ddp_channel_record.match_on_content_type_flag := p8_a19;
384 ddp_channel_record.match_on_time_flag := p8_a20;
385 ddp_channel_record.application_id := rosetta_g_miss_num_map(p8_a21);
386 ddp_channel_record.external_access_flag := p8_a22;
387 ddp_channel_record.item_match_count := rosetta_g_miss_num_map(p8_a23);
388 ddp_channel_record.last_match_time := rosetta_g_miss_date_in_map(p8_a24);
389 ddp_channel_record.notification_interval_type := p8_a25;
390 ddp_channel_record.last_notification_time := rosetta_g_miss_date_in_map(p8_a26);
391 ddp_channel_record.attribute_category := p8_a27;
392 ddp_channel_record.attribute1 := p8_a28;
393 ddp_channel_record.attribute2 := p8_a29;
394 ddp_channel_record.attribute3 := p8_a30;
395 ddp_channel_record.attribute4 := p8_a31;
396 ddp_channel_record.attribute5 := p8_a32;
397 ddp_channel_record.attribute6 := p8_a33;
398 ddp_channel_record.attribute7 := p8_a34;
399 ddp_channel_record.attribute8 := p8_a35;
400 ddp_channel_record.attribute9 := p8_a36;
401 ddp_channel_record.attribute10 := p8_a37;
402 ddp_channel_record.attribute11 := p8_a38;
403 ddp_channel_record.attribute12 := p8_a39;
404 ddp_channel_record.attribute13 := p8_a40;
405 ddp_channel_record.attribute14 := p8_a41;
406 ddp_channel_record.attribute15 := p8_a42;
407
408
409 -- here's the delegated call to the old PL/SQL routine
410 amv_channel_grp.add_privatechannel(p_api_version,
411 p_init_msg_list,
412 p_commit,
413 p_validation_level,
414 x_return_status,
415 x_msg_count,
416 x_msg_data,
417 p_check_login_user,
418 ddp_channel_record,
419 x_channel_id);
420
421 -- copy data back from the local variables to OUT or IN-OUT args, if any
422
423
424
425
426
427
428
429
430
431 end;
432
433 procedure add_groupchannel(p_api_version NUMBER
434 , p_init_msg_list VARCHAR2
435 , p_commit VARCHAR2
436 , p_validation_level NUMBER
437 , x_return_status out nocopy VARCHAR2
438 , x_msg_count out nocopy NUMBER
439 , x_msg_data out nocopy VARCHAR2
440 , p_check_login_user VARCHAR2
441 , p_group_id NUMBER
442 , x_channel_id out nocopy NUMBER
443 , p9_a0 NUMBER := 0-1962.0724
444 , p9_a1 NUMBER := 0-1962.0724
445 , p9_a2 VARCHAR2 := fnd_api.g_miss_char
446 , p9_a3 VARCHAR2 := fnd_api.g_miss_char
447 , p9_a4 VARCHAR2 := fnd_api.g_miss_char
448 , p9_a5 NUMBER := 0-1962.0724
449 , p9_a6 VARCHAR2 := fnd_api.g_miss_char
450 , p9_a7 NUMBER := 0-1962.0724
451 , p9_a8 NUMBER := 0-1962.0724
452 , p9_a9 DATE := fnd_api.g_miss_date
453 , p9_a10 DATE := fnd_api.g_miss_date
454 , p9_a11 VARCHAR2 := fnd_api.g_miss_char
455 , p9_a12 VARCHAR2 := fnd_api.g_miss_char
456 , p9_a13 VARCHAR2 := fnd_api.g_miss_char
457 , p9_a14 VARCHAR2 := fnd_api.g_miss_char
458 , p9_a15 VARCHAR2 := fnd_api.g_miss_char
459 , p9_a16 VARCHAR2 := fnd_api.g_miss_char
460 , p9_a17 VARCHAR2 := fnd_api.g_miss_char
461 , p9_a18 VARCHAR2 := fnd_api.g_miss_char
462 , p9_a19 VARCHAR2 := fnd_api.g_miss_char
463 , p9_a20 VARCHAR2 := fnd_api.g_miss_char
464 , p9_a21 NUMBER := 0-1962.0724
465 , p9_a22 VARCHAR2 := fnd_api.g_miss_char
466 , p9_a23 NUMBER := 0-1962.0724
467 , p9_a24 DATE := fnd_api.g_miss_date
468 , p9_a25 VARCHAR2 := fnd_api.g_miss_char
469 , p9_a26 DATE := fnd_api.g_miss_date
470 , p9_a27 VARCHAR2 := fnd_api.g_miss_char
471 , p9_a28 VARCHAR2 := fnd_api.g_miss_char
472 , p9_a29 VARCHAR2 := fnd_api.g_miss_char
473 , p9_a30 VARCHAR2 := fnd_api.g_miss_char
474 , p9_a31 VARCHAR2 := fnd_api.g_miss_char
475 , p9_a32 VARCHAR2 := fnd_api.g_miss_char
476 , p9_a33 VARCHAR2 := fnd_api.g_miss_char
477 , p9_a34 VARCHAR2 := fnd_api.g_miss_char
478 , p9_a35 VARCHAR2 := fnd_api.g_miss_char
479 , p9_a36 VARCHAR2 := fnd_api.g_miss_char
480 , p9_a37 VARCHAR2 := fnd_api.g_miss_char
481 , p9_a38 VARCHAR2 := fnd_api.g_miss_char
482 , p9_a39 VARCHAR2 := fnd_api.g_miss_char
483 , p9_a40 VARCHAR2 := fnd_api.g_miss_char
484 , p9_a41 VARCHAR2 := fnd_api.g_miss_char
485 , p9_a42 VARCHAR2 := fnd_api.g_miss_char
486 )
487
488 as
489 ddp_channel_record amv_channel_pvt.amv_channel_obj_type;
490 ddindx binary_integer; indx binary_integer;
491 begin
492
493 -- copy data to the local IN or IN-OUT args, if any
494
495
496
497
498
499
500
501
502
503 ddp_channel_record.channel_id := rosetta_g_miss_num_map(p9_a0);
504 ddp_channel_record.object_version_number := rosetta_g_miss_num_map(p9_a1);
505 ddp_channel_record.channel_name := p9_a2;
506 ddp_channel_record.description := p9_a3;
507 ddp_channel_record.channel_type := p9_a4;
508 ddp_channel_record.channel_category_id := rosetta_g_miss_num_map(p9_a5);
509 ddp_channel_record.status := p9_a6;
510 ddp_channel_record.owner_user_id := rosetta_g_miss_num_map(p9_a7);
511 ddp_channel_record.default_approver_user_id := rosetta_g_miss_num_map(p9_a8);
512 ddp_channel_record.effective_start_date := rosetta_g_miss_date_in_map(p9_a9);
513 ddp_channel_record.expiration_date := rosetta_g_miss_date_in_map(p9_a10);
514 ddp_channel_record.access_level_type := p9_a11;
515 ddp_channel_record.pub_need_approval_flag := p9_a12;
516 ddp_channel_record.sub_need_approval_flag := p9_a13;
517 ddp_channel_record.match_on_all_criteria_flag := p9_a14;
518 ddp_channel_record.match_on_keyword_flag := p9_a15;
519 ddp_channel_record.match_on_author_flag := p9_a16;
520 ddp_channel_record.match_on_perspective_flag := p9_a17;
521 ddp_channel_record.match_on_item_type_flag := p9_a18;
522 ddp_channel_record.match_on_content_type_flag := p9_a19;
523 ddp_channel_record.match_on_time_flag := p9_a20;
524 ddp_channel_record.application_id := rosetta_g_miss_num_map(p9_a21);
525 ddp_channel_record.external_access_flag := p9_a22;
526 ddp_channel_record.item_match_count := rosetta_g_miss_num_map(p9_a23);
527 ddp_channel_record.last_match_time := rosetta_g_miss_date_in_map(p9_a24);
528 ddp_channel_record.notification_interval_type := p9_a25;
529 ddp_channel_record.last_notification_time := rosetta_g_miss_date_in_map(p9_a26);
530 ddp_channel_record.attribute_category := p9_a27;
531 ddp_channel_record.attribute1 := p9_a28;
532 ddp_channel_record.attribute2 := p9_a29;
533 ddp_channel_record.attribute3 := p9_a30;
534 ddp_channel_record.attribute4 := p9_a31;
535 ddp_channel_record.attribute5 := p9_a32;
536 ddp_channel_record.attribute6 := p9_a33;
537 ddp_channel_record.attribute7 := p9_a34;
538 ddp_channel_record.attribute8 := p9_a35;
539 ddp_channel_record.attribute9 := p9_a36;
540 ddp_channel_record.attribute10 := p9_a37;
541 ddp_channel_record.attribute11 := p9_a38;
542 ddp_channel_record.attribute12 := p9_a39;
543 ddp_channel_record.attribute13 := p9_a40;
544 ddp_channel_record.attribute14 := p9_a41;
545 ddp_channel_record.attribute15 := p9_a42;
546
547
548 -- here's the delegated call to the old PL/SQL routine
549 amv_channel_grp.add_groupchannel(p_api_version,
550 p_init_msg_list,
551 p_commit,
552 p_validation_level,
553 x_return_status,
554 x_msg_count,
555 x_msg_data,
556 p_check_login_user,
557 p_group_id,
558 ddp_channel_record,
559 x_channel_id);
560
561 -- copy data back from the local variables to OUT or IN-OUT args, if any
562
563
564
565
566
567
568
569
570
571
572 end;
573
574 procedure update_channel(p_api_version NUMBER
575 , p_init_msg_list VARCHAR2
576 , p_commit VARCHAR2
577 , p_validation_level NUMBER
578 , x_return_status out nocopy VARCHAR2
579 , x_msg_count out nocopy NUMBER
580 , x_msg_data out nocopy VARCHAR2
581 , p_check_login_user VARCHAR2
582 , p8_a0 NUMBER := 0-1962.0724
583 , p8_a1 NUMBER := 0-1962.0724
584 , p8_a2 VARCHAR2 := fnd_api.g_miss_char
585 , p8_a3 VARCHAR2 := fnd_api.g_miss_char
586 , p8_a4 VARCHAR2 := fnd_api.g_miss_char
587 , p8_a5 NUMBER := 0-1962.0724
588 , p8_a6 VARCHAR2 := fnd_api.g_miss_char
589 , p8_a7 NUMBER := 0-1962.0724
590 , p8_a8 NUMBER := 0-1962.0724
591 , p8_a9 DATE := fnd_api.g_miss_date
592 , p8_a10 DATE := fnd_api.g_miss_date
593 , p8_a11 VARCHAR2 := fnd_api.g_miss_char
594 , p8_a12 VARCHAR2 := fnd_api.g_miss_char
595 , p8_a13 VARCHAR2 := fnd_api.g_miss_char
596 , p8_a14 VARCHAR2 := fnd_api.g_miss_char
597 , p8_a15 VARCHAR2 := fnd_api.g_miss_char
598 , p8_a16 VARCHAR2 := fnd_api.g_miss_char
599 , p8_a17 VARCHAR2 := fnd_api.g_miss_char
600 , p8_a18 VARCHAR2 := fnd_api.g_miss_char
601 , p8_a19 VARCHAR2 := fnd_api.g_miss_char
602 , p8_a20 VARCHAR2 := fnd_api.g_miss_char
603 , p8_a21 NUMBER := 0-1962.0724
604 , p8_a22 VARCHAR2 := fnd_api.g_miss_char
605 , p8_a23 NUMBER := 0-1962.0724
606 , p8_a24 DATE := fnd_api.g_miss_date
607 , p8_a25 VARCHAR2 := fnd_api.g_miss_char
608 , p8_a26 DATE := fnd_api.g_miss_date
609 , p8_a27 VARCHAR2 := fnd_api.g_miss_char
610 , p8_a28 VARCHAR2 := fnd_api.g_miss_char
611 , p8_a29 VARCHAR2 := fnd_api.g_miss_char
612 , p8_a30 VARCHAR2 := fnd_api.g_miss_char
613 , p8_a31 VARCHAR2 := fnd_api.g_miss_char
614 , p8_a32 VARCHAR2 := fnd_api.g_miss_char
615 , p8_a33 VARCHAR2 := fnd_api.g_miss_char
616 , p8_a34 VARCHAR2 := fnd_api.g_miss_char
617 , p8_a35 VARCHAR2 := fnd_api.g_miss_char
618 , p8_a36 VARCHAR2 := fnd_api.g_miss_char
619 , p8_a37 VARCHAR2 := fnd_api.g_miss_char
620 , p8_a38 VARCHAR2 := fnd_api.g_miss_char
621 , p8_a39 VARCHAR2 := fnd_api.g_miss_char
622 , p8_a40 VARCHAR2 := fnd_api.g_miss_char
623 , p8_a41 VARCHAR2 := fnd_api.g_miss_char
624 , p8_a42 VARCHAR2 := fnd_api.g_miss_char
625 )
626
627 as
628 ddp_channel_record amv_channel_pvt.amv_channel_obj_type;
629 ddindx binary_integer; indx binary_integer;
630 begin
631
632 -- copy data to the local IN or IN-OUT args, if any
633
634
635
636
637
638
639
640
641 ddp_channel_record.channel_id := rosetta_g_miss_num_map(p8_a0);
642 ddp_channel_record.object_version_number := rosetta_g_miss_num_map(p8_a1);
643 ddp_channel_record.channel_name := p8_a2;
644 ddp_channel_record.description := p8_a3;
645 ddp_channel_record.channel_type := p8_a4;
646 ddp_channel_record.channel_category_id := rosetta_g_miss_num_map(p8_a5);
647 ddp_channel_record.status := p8_a6;
648 ddp_channel_record.owner_user_id := rosetta_g_miss_num_map(p8_a7);
649 ddp_channel_record.default_approver_user_id := rosetta_g_miss_num_map(p8_a8);
650 ddp_channel_record.effective_start_date := rosetta_g_miss_date_in_map(p8_a9);
651 ddp_channel_record.expiration_date := rosetta_g_miss_date_in_map(p8_a10);
652 ddp_channel_record.access_level_type := p8_a11;
653 ddp_channel_record.pub_need_approval_flag := p8_a12;
654 ddp_channel_record.sub_need_approval_flag := p8_a13;
655 ddp_channel_record.match_on_all_criteria_flag := p8_a14;
656 ddp_channel_record.match_on_keyword_flag := p8_a15;
657 ddp_channel_record.match_on_author_flag := p8_a16;
658 ddp_channel_record.match_on_perspective_flag := p8_a17;
659 ddp_channel_record.match_on_item_type_flag := p8_a18;
660 ddp_channel_record.match_on_content_type_flag := p8_a19;
661 ddp_channel_record.match_on_time_flag := p8_a20;
662 ddp_channel_record.application_id := rosetta_g_miss_num_map(p8_a21);
663 ddp_channel_record.external_access_flag := p8_a22;
664 ddp_channel_record.item_match_count := rosetta_g_miss_num_map(p8_a23);
665 ddp_channel_record.last_match_time := rosetta_g_miss_date_in_map(p8_a24);
666 ddp_channel_record.notification_interval_type := p8_a25;
667 ddp_channel_record.last_notification_time := rosetta_g_miss_date_in_map(p8_a26);
668 ddp_channel_record.attribute_category := p8_a27;
669 ddp_channel_record.attribute1 := p8_a28;
670 ddp_channel_record.attribute2 := p8_a29;
671 ddp_channel_record.attribute3 := p8_a30;
672 ddp_channel_record.attribute4 := p8_a31;
673 ddp_channel_record.attribute5 := p8_a32;
674 ddp_channel_record.attribute6 := p8_a33;
675 ddp_channel_record.attribute7 := p8_a34;
676 ddp_channel_record.attribute8 := p8_a35;
677 ddp_channel_record.attribute9 := p8_a36;
678 ddp_channel_record.attribute10 := p8_a37;
679 ddp_channel_record.attribute11 := p8_a38;
680 ddp_channel_record.attribute12 := p8_a39;
681 ddp_channel_record.attribute13 := p8_a40;
682 ddp_channel_record.attribute14 := p8_a41;
683 ddp_channel_record.attribute15 := p8_a42;
684
685 -- here's the delegated call to the old PL/SQL routine
686 amv_channel_grp.update_channel(p_api_version,
687 p_init_msg_list,
688 p_commit,
689 p_validation_level,
690 x_return_status,
691 x_msg_count,
692 x_msg_data,
693 p_check_login_user,
694 ddp_channel_record);
695
696 -- copy data back from the local variables to OUT or IN-OUT args, if any
697
698
699
700
701
702
703
704
705 end;
706
707 procedure get_channel(p_api_version NUMBER
708 , p_init_msg_list VARCHAR2
709 , p_validation_level NUMBER
710 , x_return_status out nocopy VARCHAR2
711 , x_msg_count out nocopy NUMBER
712 , x_msg_data out nocopy VARCHAR2
713 , p_check_login_user VARCHAR2
714 , p_channel_id NUMBER
715 , p_channel_name VARCHAR2
716 , p_category_id NUMBER
717 , p10_a0 out nocopy NUMBER
718 , p10_a1 out nocopy NUMBER
719 , p10_a2 out nocopy VARCHAR2
720 , p10_a3 out nocopy VARCHAR2
721 , p10_a4 out nocopy VARCHAR2
722 , p10_a5 out nocopy NUMBER
723 , p10_a6 out nocopy VARCHAR2
724 , p10_a7 out nocopy NUMBER
725 , p10_a8 out nocopy NUMBER
726 , p10_a9 out nocopy DATE
727 , p10_a10 out nocopy DATE
728 , p10_a11 out nocopy VARCHAR2
729 , p10_a12 out nocopy VARCHAR2
730 , p10_a13 out nocopy VARCHAR2
731 , p10_a14 out nocopy VARCHAR2
732 , p10_a15 out nocopy VARCHAR2
733 , p10_a16 out nocopy VARCHAR2
734 , p10_a17 out nocopy VARCHAR2
735 , p10_a18 out nocopy VARCHAR2
736 , p10_a19 out nocopy VARCHAR2
737 , p10_a20 out nocopy VARCHAR2
738 , p10_a21 out nocopy NUMBER
739 , p10_a22 out nocopy VARCHAR2
740 , p10_a23 out nocopy NUMBER
741 , p10_a24 out nocopy DATE
742 , p10_a25 out nocopy VARCHAR2
743 , p10_a26 out nocopy DATE
744 , p10_a27 out nocopy VARCHAR2
745 , p10_a28 out nocopy VARCHAR2
746 , p10_a29 out nocopy VARCHAR2
747 , p10_a30 out nocopy VARCHAR2
748 , p10_a31 out nocopy VARCHAR2
749 , p10_a32 out nocopy VARCHAR2
750 , p10_a33 out nocopy VARCHAR2
751 , p10_a34 out nocopy VARCHAR2
752 , p10_a35 out nocopy VARCHAR2
753 , p10_a36 out nocopy VARCHAR2
754 , p10_a37 out nocopy VARCHAR2
755 , p10_a38 out nocopy VARCHAR2
756 , p10_a39 out nocopy VARCHAR2
757 , p10_a40 out nocopy VARCHAR2
758 , p10_a41 out nocopy VARCHAR2
759 , p10_a42 out nocopy VARCHAR2
760 )
761
762 as
763 ddx_channel_record amv_channel_pvt.amv_channel_obj_type;
764 ddindx binary_integer; indx binary_integer;
765 begin
766
767 -- copy data to the local IN or IN-OUT args, if any
768
769
770
771
772
773
774
775
776
777
778
779 -- here's the delegated call to the old PL/SQL routine
780 amv_channel_grp.get_channel(p_api_version,
781 p_init_msg_list,
782 p_validation_level,
783 x_return_status,
784 x_msg_count,
785 x_msg_data,
786 p_check_login_user,
787 p_channel_id,
788 p_channel_name,
789 p_category_id,
790 ddx_channel_record);
791
792 -- copy data back from the local variables to OUT or IN-OUT args, if any
793
794
795
796
797
798
799
800
801
802
803 p10_a0 := rosetta_g_miss_num_map(ddx_channel_record.channel_id);
804 p10_a1 := rosetta_g_miss_num_map(ddx_channel_record.object_version_number);
805 p10_a2 := ddx_channel_record.channel_name;
806 p10_a3 := ddx_channel_record.description;
807 p10_a4 := ddx_channel_record.channel_type;
808 p10_a5 := rosetta_g_miss_num_map(ddx_channel_record.channel_category_id);
809 p10_a6 := ddx_channel_record.status;
810 p10_a7 := rosetta_g_miss_num_map(ddx_channel_record.owner_user_id);
811 p10_a8 := rosetta_g_miss_num_map(ddx_channel_record.default_approver_user_id);
812 p10_a9 := ddx_channel_record.effective_start_date;
813 p10_a10 := ddx_channel_record.expiration_date;
814 p10_a11 := ddx_channel_record.access_level_type;
815 p10_a12 := ddx_channel_record.pub_need_approval_flag;
816 p10_a13 := ddx_channel_record.sub_need_approval_flag;
817 p10_a14 := ddx_channel_record.match_on_all_criteria_flag;
818 p10_a15 := ddx_channel_record.match_on_keyword_flag;
819 p10_a16 := ddx_channel_record.match_on_author_flag;
820 p10_a17 := ddx_channel_record.match_on_perspective_flag;
821 p10_a18 := ddx_channel_record.match_on_item_type_flag;
822 p10_a19 := ddx_channel_record.match_on_content_type_flag;
823 p10_a20 := ddx_channel_record.match_on_time_flag;
824 p10_a21 := rosetta_g_miss_num_map(ddx_channel_record.application_id);
825 p10_a22 := ddx_channel_record.external_access_flag;
826 p10_a23 := rosetta_g_miss_num_map(ddx_channel_record.item_match_count);
827 p10_a24 := ddx_channel_record.last_match_time;
828 p10_a25 := ddx_channel_record.notification_interval_type;
829 p10_a26 := ddx_channel_record.last_notification_time;
830 p10_a27 := ddx_channel_record.attribute_category;
831 p10_a28 := ddx_channel_record.attribute1;
832 p10_a29 := ddx_channel_record.attribute2;
833 p10_a30 := ddx_channel_record.attribute3;
834 p10_a31 := ddx_channel_record.attribute4;
835 p10_a32 := ddx_channel_record.attribute5;
836 p10_a33 := ddx_channel_record.attribute6;
837 p10_a34 := ddx_channel_record.attribute7;
838 p10_a35 := ddx_channel_record.attribute8;
839 p10_a36 := ddx_channel_record.attribute9;
840 p10_a37 := ddx_channel_record.attribute10;
841 p10_a38 := ddx_channel_record.attribute11;
842 p10_a39 := ddx_channel_record.attribute12;
843 p10_a40 := ddx_channel_record.attribute13;
844 p10_a41 := ddx_channel_record.attribute14;
845 p10_a42 := ddx_channel_record.attribute15;
846 end;
847
848 procedure set_channelcontenttypes(p_api_version NUMBER
849 , p_init_msg_list VARCHAR2
850 , p_commit VARCHAR2
851 , p_validation_level NUMBER
852 , x_return_status out nocopy VARCHAR2
853 , x_msg_count out nocopy NUMBER
854 , x_msg_data out nocopy VARCHAR2
855 , p_check_login_user VARCHAR2
856 , p_channel_id NUMBER
857 , p_channel_name VARCHAR2
858 , p_category_id NUMBER
859 , p_content_type_id_array JTF_NUMBER_TABLE
860 )
861
862 as
863 ddp_content_type_id_array amv_channel_pvt.amv_number_varray_type;
864 ddindx binary_integer; indx binary_integer;
865 begin
866
867 -- copy data to the local IN or IN-OUT args, if any
868
869
870
871
872
873
874
875
876
877
878
879 amv_channel_pvt_w.rosetta_table_copy_in_p1(ddp_content_type_id_array, p_content_type_id_array);
880
881 -- here's the delegated call to the old PL/SQL routine
882 amv_channel_grp.set_channelcontenttypes(p_api_version,
883 p_init_msg_list,
884 p_commit,
885 p_validation_level,
886 x_return_status,
887 x_msg_count,
888 x_msg_data,
889 p_check_login_user,
890 p_channel_id,
891 p_channel_name,
892 p_category_id,
893 ddp_content_type_id_array);
894
895 -- copy data back from the local variables to OUT or IN-OUT args, if any
896
897
898
899
900
901
902
903
904
905
906
907 end;
908
909 procedure get_channelcontenttypes(p_api_version NUMBER
910 , p_init_msg_list VARCHAR2
911 , p_validation_level NUMBER
912 , x_return_status out nocopy VARCHAR2
913 , x_msg_count out nocopy NUMBER
914 , x_msg_data out nocopy VARCHAR2
915 , p_check_login_user VARCHAR2
916 , p_channel_id NUMBER
917 , p_channel_name VARCHAR2
918 , p_category_id NUMBER
919 , x_content_type_id_array out nocopy JTF_NUMBER_TABLE
920 )
921
922 as
923 ddx_content_type_id_array amv_channel_pvt.amv_number_varray_type;
924 ddindx binary_integer; indx binary_integer;
925 begin
926
927 -- copy data to the local IN or IN-OUT args, if any
928
929
930
931
932
933
934
935
936
937
938
939 -- here's the delegated call to the old PL/SQL routine
940 amv_channel_grp.get_channelcontenttypes(p_api_version,
941 p_init_msg_list,
942 p_validation_level,
943 x_return_status,
944 x_msg_count,
945 x_msg_data,
946 p_check_login_user,
947 p_channel_id,
948 p_channel_name,
949 p_category_id,
950 ddx_content_type_id_array);
951
952 -- copy data back from the local variables to OUT or IN-OUT args, if any
953
954
955
956
957
958
959
960
961
962
963 amv_channel_pvt_w.rosetta_table_copy_out_p1(ddx_content_type_id_array, x_content_type_id_array);
964 end;
965
966 procedure set_channelperspectives(p_api_version NUMBER
967 , p_init_msg_list VARCHAR2
968 , p_commit VARCHAR2
969 , p_validation_level NUMBER
970 , x_return_status out nocopy VARCHAR2
971 , x_msg_count out nocopy NUMBER
972 , x_msg_data out nocopy VARCHAR2
973 , p_check_login_user VARCHAR2
974 , p_channel_id NUMBER
975 , p_channel_name VARCHAR2
976 , p_category_id NUMBER
977 , p_perspective_id_array JTF_NUMBER_TABLE
978 )
979
980 as
981 ddp_perspective_id_array amv_channel_pvt.amv_number_varray_type;
982 ddindx binary_integer; indx binary_integer;
983 begin
984
985 -- copy data to the local IN or IN-OUT args, if any
986
987
988
989
990
991
992
993
994
995
996
997 amv_channel_pvt_w.rosetta_table_copy_in_p1(ddp_perspective_id_array, p_perspective_id_array);
998
999 -- here's the delegated call to the old PL/SQL routine
1000 amv_channel_grp.set_channelperspectives(p_api_version,
1001 p_init_msg_list,
1002 p_commit,
1003 p_validation_level,
1004 x_return_status,
1005 x_msg_count,
1006 x_msg_data,
1007 p_check_login_user,
1008 p_channel_id,
1009 p_channel_name,
1010 p_category_id,
1011 ddp_perspective_id_array);
1012
1013 -- copy data back from the local variables to OUT or IN-OUT args, if any
1014
1015
1016
1017
1018
1019
1020
1021
1022
1023
1024
1025 end;
1026
1027 procedure get_channelperspectives(p_api_version NUMBER
1028 , p_init_msg_list VARCHAR2
1029 , p_validation_level NUMBER
1030 , x_return_status out nocopy VARCHAR2
1031 , x_msg_count out nocopy NUMBER
1032 , x_msg_data out nocopy VARCHAR2
1033 , p_check_login_user VARCHAR2
1034 , p_channel_id NUMBER
1035 , p_channel_name VARCHAR2
1036 , p_category_id NUMBER
1037 , x_perspective_id_array out nocopy JTF_NUMBER_TABLE
1038 )
1039
1040 as
1041 ddx_perspective_id_array amv_channel_pvt.amv_number_varray_type;
1042 ddindx binary_integer; indx binary_integer;
1043 begin
1044
1045 -- copy data to the local IN or IN-OUT args, if any
1046
1047
1048
1049
1050
1051
1052
1053
1054
1055
1056
1057 -- here's the delegated call to the old PL/SQL routine
1058 amv_channel_grp.get_channelperspectives(p_api_version,
1059 p_init_msg_list,
1060 p_validation_level,
1061 x_return_status,
1062 x_msg_count,
1063 x_msg_data,
1064 p_check_login_user,
1065 p_channel_id,
1066 p_channel_name,
1067 p_category_id,
1068 ddx_perspective_id_array);
1069
1070 -- copy data back from the local variables to OUT or IN-OUT args, if any
1071
1072
1073
1074
1075
1076
1077
1078
1079
1080
1081 amv_channel_pvt_w.rosetta_table_copy_out_p1(ddx_perspective_id_array, x_perspective_id_array);
1082 end;
1083
1084 procedure set_channelitemtypes(p_api_version NUMBER
1085 , p_init_msg_list VARCHAR2
1086 , p_commit VARCHAR2
1087 , p_validation_level NUMBER
1088 , x_return_status out nocopy VARCHAR2
1089 , x_msg_count out nocopy NUMBER
1090 , x_msg_data out nocopy VARCHAR2
1091 , p_check_login_user VARCHAR2
1092 , p_channel_id NUMBER
1093 , p_channel_name VARCHAR2
1094 , p_category_id NUMBER
1095 , p_item_type_array JTF_VARCHAR2_TABLE_4000
1096 )
1097
1098 as
1099 ddp_item_type_array amv_channel_pvt.amv_char_varray_type;
1100 ddindx binary_integer; indx binary_integer;
1101 begin
1102
1103 -- copy data to the local IN or IN-OUT args, if any
1104
1105
1106
1107
1108
1109
1110
1111
1112
1113
1114
1115 amv_channel_pvt_w.rosetta_table_copy_in_p0(ddp_item_type_array, p_item_type_array);
1116
1117 -- here's the delegated call to the old PL/SQL routine
1118 amv_channel_grp.set_channelitemtypes(p_api_version,
1119 p_init_msg_list,
1120 p_commit,
1121 p_validation_level,
1122 x_return_status,
1123 x_msg_count,
1124 x_msg_data,
1125 p_check_login_user,
1126 p_channel_id,
1127 p_channel_name,
1128 p_category_id,
1129 ddp_item_type_array);
1130
1131 -- copy data back from the local variables to OUT or IN-OUT args, if any
1132
1133
1134
1135
1136
1137
1138
1139
1140
1141
1142
1143 end;
1144
1145 procedure get_channelitemtypes(p_api_version NUMBER
1146 , p_init_msg_list VARCHAR2
1147 , p_validation_level NUMBER
1148 , x_return_status out nocopy VARCHAR2
1149 , x_msg_count out nocopy NUMBER
1150 , x_msg_data out nocopy VARCHAR2
1151 , p_check_login_user VARCHAR2
1152 , p_channel_id NUMBER
1153 , p_channel_name VARCHAR2
1154 , p_category_id NUMBER
1155 , x_item_type_array out nocopy JTF_VARCHAR2_TABLE_4000
1156 )
1157
1158 as
1159 ddx_item_type_array amv_channel_pvt.amv_char_varray_type;
1160 ddindx binary_integer; indx binary_integer;
1161 begin
1162
1163 -- copy data to the local IN or IN-OUT args, if any
1164
1165
1166
1167
1168
1169
1170
1171
1172
1173
1174
1175 -- here's the delegated call to the old PL/SQL routine
1176 amv_channel_grp.get_channelitemtypes(p_api_version,
1177 p_init_msg_list,
1178 p_validation_level,
1179 x_return_status,
1180 x_msg_count,
1181 x_msg_data,
1182 p_check_login_user,
1183 p_channel_id,
1184 p_channel_name,
1185 p_category_id,
1186 ddx_item_type_array);
1187
1188 -- copy data back from the local variables to OUT or IN-OUT args, if any
1189
1190
1191
1192
1193
1194
1195
1196
1197
1198
1199 amv_channel_pvt_w.rosetta_table_copy_out_p0(ddx_item_type_array, x_item_type_array);
1200 end;
1201
1202 procedure set_channelkeywords(p_api_version NUMBER
1203 , p_init_msg_list VARCHAR2
1204 , p_commit VARCHAR2
1205 , p_validation_level NUMBER
1206 , x_return_status out nocopy VARCHAR2
1207 , x_msg_count out nocopy NUMBER
1208 , x_msg_data out nocopy VARCHAR2
1209 , p_check_login_user VARCHAR2
1210 , p_channel_id NUMBER
1211 , p_channel_name VARCHAR2
1212 , p_category_id NUMBER
1213 , p_keywords_array JTF_VARCHAR2_TABLE_4000
1214 )
1215
1216 as
1217 ddp_keywords_array amv_channel_pvt.amv_char_varray_type;
1218 ddindx binary_integer; indx binary_integer;
1219 begin
1220
1221 -- copy data to the local IN or IN-OUT args, if any
1222
1223
1224
1225
1226
1227
1228
1229
1230
1231
1232
1233 amv_channel_pvt_w.rosetta_table_copy_in_p0(ddp_keywords_array, p_keywords_array);
1234
1235 -- here's the delegated call to the old PL/SQL routine
1236 amv_channel_grp.set_channelkeywords(p_api_version,
1237 p_init_msg_list,
1238 p_commit,
1239 p_validation_level,
1240 x_return_status,
1241 x_msg_count,
1242 x_msg_data,
1243 p_check_login_user,
1244 p_channel_id,
1245 p_channel_name,
1246 p_category_id,
1247 ddp_keywords_array);
1248
1249 -- copy data back from the local variables to OUT or IN-OUT args, if any
1250
1251
1252
1253
1254
1255
1256
1257
1258
1259
1260
1261 end;
1262
1263 procedure get_channelkeywords(p_api_version NUMBER
1264 , p_init_msg_list VARCHAR2
1265 , p_validation_level NUMBER
1266 , x_return_status out nocopy VARCHAR2
1267 , x_msg_count out nocopy NUMBER
1268 , x_msg_data out nocopy VARCHAR2
1269 , p_check_login_user VARCHAR2
1270 , p_channel_id NUMBER
1271 , p_channel_name VARCHAR2
1272 , p_category_id NUMBER
1273 , x_keywords_array out nocopy JTF_VARCHAR2_TABLE_4000
1274 )
1275
1276 as
1277 ddx_keywords_array amv_channel_pvt.amv_char_varray_type;
1278 ddindx binary_integer; indx binary_integer;
1279 begin
1280
1281 -- copy data to the local IN or IN-OUT args, if any
1282
1283
1284
1285
1286
1287
1288
1289
1290
1291
1292
1293 -- here's the delegated call to the old PL/SQL routine
1294 amv_channel_grp.get_channelkeywords(p_api_version,
1295 p_init_msg_list,
1296 p_validation_level,
1297 x_return_status,
1298 x_msg_count,
1299 x_msg_data,
1300 p_check_login_user,
1301 p_channel_id,
1302 p_channel_name,
1303 p_category_id,
1304 ddx_keywords_array);
1305
1306 -- copy data back from the local variables to OUT or IN-OUT args, if any
1307
1308
1309
1310
1311
1312
1313
1314
1315
1316
1317 amv_channel_pvt_w.rosetta_table_copy_out_p0(ddx_keywords_array, x_keywords_array);
1318 end;
1319
1320 procedure set_channelauthors(p_api_version NUMBER
1321 , p_init_msg_list VARCHAR2
1322 , p_commit VARCHAR2
1323 , p_validation_level NUMBER
1324 , x_return_status out nocopy VARCHAR2
1325 , x_msg_count out nocopy NUMBER
1326 , x_msg_data out nocopy VARCHAR2
1327 , p_check_login_user VARCHAR2
1328 , p_channel_id NUMBER
1329 , p_channel_name VARCHAR2
1330 , p_category_id NUMBER
1331 , p_authors_array JTF_VARCHAR2_TABLE_4000
1332 )
1333
1334 as
1335 ddp_authors_array amv_channel_pvt.amv_char_varray_type;
1336 ddindx binary_integer; indx binary_integer;
1337 begin
1338
1339 -- copy data to the local IN or IN-OUT args, if any
1340
1341
1342
1343
1344
1345
1346
1347
1348
1349
1350
1351 amv_channel_pvt_w.rosetta_table_copy_in_p0(ddp_authors_array, p_authors_array);
1352
1353 -- here's the delegated call to the old PL/SQL routine
1354 amv_channel_grp.set_channelauthors(p_api_version,
1355 p_init_msg_list,
1356 p_commit,
1357 p_validation_level,
1358 x_return_status,
1359 x_msg_count,
1360 x_msg_data,
1361 p_check_login_user,
1362 p_channel_id,
1363 p_channel_name,
1364 p_category_id,
1365 ddp_authors_array);
1366
1367 -- copy data back from the local variables to OUT or IN-OUT args, if any
1368
1369
1370
1371
1372
1373
1374
1375
1376
1377
1378
1379 end;
1380
1381 procedure get_channelauthors(p_api_version NUMBER
1382 , p_init_msg_list VARCHAR2
1383 , p_validation_level NUMBER
1384 , x_return_status out nocopy VARCHAR2
1385 , x_msg_count out nocopy NUMBER
1386 , x_msg_data out nocopy VARCHAR2
1387 , p_check_login_user VARCHAR2
1388 , p_channel_id NUMBER
1389 , p_channel_name VARCHAR2
1390 , p_category_id NUMBER
1391 , x_authors_array out nocopy JTF_VARCHAR2_TABLE_4000
1392 )
1393
1394 as
1395 ddx_authors_array amv_channel_pvt.amv_char_varray_type;
1396 ddindx binary_integer; indx binary_integer;
1397 begin
1398
1399 -- copy data to the local IN or IN-OUT args, if any
1400
1401
1402
1403
1404
1405
1406
1407
1408
1409
1410
1411 -- here's the delegated call to the old PL/SQL routine
1412 amv_channel_grp.get_channelauthors(p_api_version,
1413 p_init_msg_list,
1414 p_validation_level,
1415 x_return_status,
1416 x_msg_count,
1417 x_msg_data,
1418 p_check_login_user,
1419 p_channel_id,
1420 p_channel_name,
1421 p_category_id,
1422 ddx_authors_array);
1423
1424 -- copy data back from the local variables to OUT or IN-OUT args, if any
1425
1426
1427
1428
1429
1430
1431
1432
1433
1434
1435 amv_channel_pvt_w.rosetta_table_copy_out_p0(ddx_authors_array, x_authors_array);
1436 end;
1437
1438 procedure get_itemsperchannel(p_api_version NUMBER
1439 , p_init_msg_list VARCHAR2
1440 , p_validation_level NUMBER
1441 , x_return_status out nocopy VARCHAR2
1442 , x_msg_count out nocopy NUMBER
1443 , x_msg_data out nocopy VARCHAR2
1444 , p_check_login_user VARCHAR2
1445 , p_channel_id NUMBER
1446 , p_channel_name VARCHAR2
1447 , p_category_id NUMBER
1448 , p11_a0 out nocopy NUMBER
1449 , p11_a1 out nocopy NUMBER
1450 , p11_a2 out nocopy NUMBER
1451 , x_document_id_array out nocopy JTF_NUMBER_TABLE
1452 , p10_a0 NUMBER := 0-1962.0724
1453 , p10_a1 NUMBER := 0-1962.0724
1454 , p10_a2 VARCHAR2 := fnd_api.g_miss_char
1455 )
1456
1457 as
1458 ddp_subset_request_rec amv_channel_pvt.amv_request_obj_type;
1459 ddx_subset_return_rec amv_channel_pvt.amv_return_obj_type;
1460 ddx_document_id_array amv_channel_pvt.amv_number_varray_type;
1461 ddindx binary_integer; indx binary_integer;
1462 begin
1463
1464 -- copy data to the local IN or IN-OUT args, if any
1465
1466
1467
1468
1469
1470
1471
1472
1473
1474
1475 ddp_subset_request_rec.records_requested := rosetta_g_miss_num_map(p10_a0);
1476 ddp_subset_request_rec.start_record_position := rosetta_g_miss_num_map(p10_a1);
1477 ddp_subset_request_rec.return_total_count_flag := p10_a2;
1478
1479
1480
1481 -- here's the delegated call to the old PL/SQL routine
1482 amv_channel_grp.get_itemsperchannel(p_api_version,
1483 p_init_msg_list,
1484 p_validation_level,
1485 x_return_status,
1486 x_msg_count,
1487 x_msg_data,
1488 p_check_login_user,
1489 p_channel_id,
1490 p_channel_name,
1491 p_category_id,
1492 ddp_subset_request_rec,
1493 ddx_subset_return_rec,
1494 ddx_document_id_array);
1495
1496 -- copy data back from the local variables to OUT or IN-OUT args, if any
1497
1498
1499
1500
1501
1502
1503
1504
1505
1506
1507
1508 p11_a0 := rosetta_g_miss_num_map(ddx_subset_return_rec.returned_record_count);
1509 p11_a1 := rosetta_g_miss_num_map(ddx_subset_return_rec.next_record_position);
1510 p11_a2 := rosetta_g_miss_num_map(ddx_subset_return_rec.total_record_count);
1511
1512 amv_channel_pvt_w.rosetta_table_copy_out_p1(ddx_document_id_array, x_document_id_array);
1513 end;
1514
1515 procedure find_channels(p_api_version NUMBER
1516 , p_init_msg_list VARCHAR2
1517 , p_validation_level NUMBER
1518 , x_return_status out nocopy VARCHAR2
1519 , x_msg_count out nocopy NUMBER
1520 , x_msg_data out nocopy VARCHAR2
1521 , p_check_login_user VARCHAR2
1522 , p_sort_by VARCHAR2
1523 , p10_a0 out nocopy NUMBER
1524 , p10_a1 out nocopy NUMBER
1525 , p10_a2 out nocopy NUMBER
1526 , p11_a0 out nocopy JTF_NUMBER_TABLE
1527 , p11_a1 out nocopy JTF_NUMBER_TABLE
1528 , p11_a2 out nocopy JTF_VARCHAR2_TABLE_100
1529 , p11_a3 out nocopy JTF_VARCHAR2_TABLE_2000
1530 , p11_a4 out nocopy JTF_VARCHAR2_TABLE_100
1531 , p11_a5 out nocopy JTF_NUMBER_TABLE
1532 , p11_a6 out nocopy JTF_VARCHAR2_TABLE_100
1533 , p11_a7 out nocopy JTF_NUMBER_TABLE
1534 , p11_a8 out nocopy JTF_NUMBER_TABLE
1535 , p11_a9 out nocopy JTF_DATE_TABLE
1536 , p11_a10 out nocopy JTF_DATE_TABLE
1537 , p11_a11 out nocopy JTF_VARCHAR2_TABLE_100
1538 , p11_a12 out nocopy JTF_VARCHAR2_TABLE_100
1539 , p11_a13 out nocopy JTF_VARCHAR2_TABLE_100
1540 , p11_a14 out nocopy JTF_VARCHAR2_TABLE_100
1541 , p11_a15 out nocopy JTF_VARCHAR2_TABLE_100
1542 , p11_a16 out nocopy JTF_VARCHAR2_TABLE_100
1543 , p11_a17 out nocopy JTF_VARCHAR2_TABLE_100
1544 , p11_a18 out nocopy JTF_VARCHAR2_TABLE_100
1545 , p11_a19 out nocopy JTF_VARCHAR2_TABLE_100
1546 , p11_a20 out nocopy JTF_VARCHAR2_TABLE_100
1547 , p11_a21 out nocopy JTF_NUMBER_TABLE
1548 , p11_a22 out nocopy JTF_VARCHAR2_TABLE_100
1549 , p11_a23 out nocopy JTF_NUMBER_TABLE
1550 , p11_a24 out nocopy JTF_DATE_TABLE
1551 , p11_a25 out nocopy JTF_VARCHAR2_TABLE_100
1552 , p11_a26 out nocopy JTF_DATE_TABLE
1553 , p11_a27 out nocopy JTF_VARCHAR2_TABLE_100
1554 , p11_a28 out nocopy JTF_VARCHAR2_TABLE_200
1555 , p11_a29 out nocopy JTF_VARCHAR2_TABLE_200
1556 , p11_a30 out nocopy JTF_VARCHAR2_TABLE_200
1557 , p11_a31 out nocopy JTF_VARCHAR2_TABLE_200
1558 , p11_a32 out nocopy JTF_VARCHAR2_TABLE_200
1559 , p11_a33 out nocopy JTF_VARCHAR2_TABLE_200
1560 , p11_a34 out nocopy JTF_VARCHAR2_TABLE_200
1561 , p11_a35 out nocopy JTF_VARCHAR2_TABLE_200
1562 , p11_a36 out nocopy JTF_VARCHAR2_TABLE_200
1563 , p11_a37 out nocopy JTF_VARCHAR2_TABLE_200
1564 , p11_a38 out nocopy JTF_VARCHAR2_TABLE_200
1565 , p11_a39 out nocopy JTF_VARCHAR2_TABLE_200
1566 , p11_a40 out nocopy JTF_VARCHAR2_TABLE_200
1567 , p11_a41 out nocopy JTF_VARCHAR2_TABLE_200
1568 , p11_a42 out nocopy JTF_VARCHAR2_TABLE_200
1569 , p7_a0 NUMBER := 0-1962.0724
1570 , p7_a1 NUMBER := 0-1962.0724
1571 , p7_a2 VARCHAR2 := fnd_api.g_miss_char
1572 , p7_a3 VARCHAR2 := fnd_api.g_miss_char
1573 , p7_a4 VARCHAR2 := fnd_api.g_miss_char
1574 , p7_a5 NUMBER := 0-1962.0724
1575 , p7_a6 VARCHAR2 := fnd_api.g_miss_char
1576 , p7_a7 NUMBER := 0-1962.0724
1577 , p7_a8 NUMBER := 0-1962.0724
1578 , p7_a9 DATE := fnd_api.g_miss_date
1579 , p7_a10 DATE := fnd_api.g_miss_date
1580 , p7_a11 VARCHAR2 := fnd_api.g_miss_char
1581 , p7_a12 VARCHAR2 := fnd_api.g_miss_char
1582 , p7_a13 VARCHAR2 := fnd_api.g_miss_char
1583 , p7_a14 VARCHAR2 := fnd_api.g_miss_char
1584 , p7_a15 VARCHAR2 := fnd_api.g_miss_char
1585 , p7_a16 VARCHAR2 := fnd_api.g_miss_char
1586 , p7_a17 VARCHAR2 := fnd_api.g_miss_char
1587 , p7_a18 VARCHAR2 := fnd_api.g_miss_char
1588 , p7_a19 VARCHAR2 := fnd_api.g_miss_char
1589 , p7_a20 VARCHAR2 := fnd_api.g_miss_char
1590 , p7_a21 NUMBER := 0-1962.0724
1591 , p7_a22 VARCHAR2 := fnd_api.g_miss_char
1592 , p7_a23 NUMBER := 0-1962.0724
1593 , p7_a24 DATE := fnd_api.g_miss_date
1594 , p7_a25 VARCHAR2 := fnd_api.g_miss_char
1595 , p7_a26 DATE := fnd_api.g_miss_date
1596 , p7_a27 VARCHAR2 := fnd_api.g_miss_char
1597 , p7_a28 VARCHAR2 := fnd_api.g_miss_char
1598 , p7_a29 VARCHAR2 := fnd_api.g_miss_char
1599 , p7_a30 VARCHAR2 := fnd_api.g_miss_char
1600 , p7_a31 VARCHAR2 := fnd_api.g_miss_char
1601 , p7_a32 VARCHAR2 := fnd_api.g_miss_char
1602 , p7_a33 VARCHAR2 := fnd_api.g_miss_char
1603 , p7_a34 VARCHAR2 := fnd_api.g_miss_char
1604 , p7_a35 VARCHAR2 := fnd_api.g_miss_char
1605 , p7_a36 VARCHAR2 := fnd_api.g_miss_char
1606 , p7_a37 VARCHAR2 := fnd_api.g_miss_char
1607 , p7_a38 VARCHAR2 := fnd_api.g_miss_char
1608 , p7_a39 VARCHAR2 := fnd_api.g_miss_char
1609 , p7_a40 VARCHAR2 := fnd_api.g_miss_char
1610 , p7_a41 VARCHAR2 := fnd_api.g_miss_char
1611 , p7_a42 VARCHAR2 := fnd_api.g_miss_char
1612 , p9_a0 NUMBER := 0-1962.0724
1613 , p9_a1 NUMBER := 0-1962.0724
1614 , p9_a2 VARCHAR2 := fnd_api.g_miss_char
1615 )
1616
1617 as
1618 ddp_criteria_rec amv_channel_pvt.amv_channel_obj_type;
1619 ddp_subset_request_rec amv_channel_pvt.amv_request_obj_type;
1620 ddx_subset_return_rec amv_channel_pvt.amv_return_obj_type;
1621 ddx_content_chan_array amv_channel_pvt.amv_channel_varray_type;
1622 ddindx binary_integer; indx binary_integer;
1623 begin
1624
1625 -- copy data to the local IN or IN-OUT args, if any
1626
1627
1628
1629
1630
1631
1632
1633 ddp_criteria_rec.channel_id := rosetta_g_miss_num_map(p7_a0);
1634 ddp_criteria_rec.object_version_number := rosetta_g_miss_num_map(p7_a1);
1635 ddp_criteria_rec.channel_name := p7_a2;
1636 ddp_criteria_rec.description := p7_a3;
1637 ddp_criteria_rec.channel_type := p7_a4;
1638 ddp_criteria_rec.channel_category_id := rosetta_g_miss_num_map(p7_a5);
1639 ddp_criteria_rec.status := p7_a6;
1640 ddp_criteria_rec.owner_user_id := rosetta_g_miss_num_map(p7_a7);
1641 ddp_criteria_rec.default_approver_user_id := rosetta_g_miss_num_map(p7_a8);
1642 ddp_criteria_rec.effective_start_date := rosetta_g_miss_date_in_map(p7_a9);
1643 ddp_criteria_rec.expiration_date := rosetta_g_miss_date_in_map(p7_a10);
1644 ddp_criteria_rec.access_level_type := p7_a11;
1645 ddp_criteria_rec.pub_need_approval_flag := p7_a12;
1646 ddp_criteria_rec.sub_need_approval_flag := p7_a13;
1647 ddp_criteria_rec.match_on_all_criteria_flag := p7_a14;
1648 ddp_criteria_rec.match_on_keyword_flag := p7_a15;
1649 ddp_criteria_rec.match_on_author_flag := p7_a16;
1650 ddp_criteria_rec.match_on_perspective_flag := p7_a17;
1651 ddp_criteria_rec.match_on_item_type_flag := p7_a18;
1652 ddp_criteria_rec.match_on_content_type_flag := p7_a19;
1653 ddp_criteria_rec.match_on_time_flag := p7_a20;
1654 ddp_criteria_rec.application_id := rosetta_g_miss_num_map(p7_a21);
1655 ddp_criteria_rec.external_access_flag := p7_a22;
1656 ddp_criteria_rec.item_match_count := rosetta_g_miss_num_map(p7_a23);
1657 ddp_criteria_rec.last_match_time := rosetta_g_miss_date_in_map(p7_a24);
1658 ddp_criteria_rec.notification_interval_type := p7_a25;
1659 ddp_criteria_rec.last_notification_time := rosetta_g_miss_date_in_map(p7_a26);
1660 ddp_criteria_rec.attribute_category := p7_a27;
1661 ddp_criteria_rec.attribute1 := p7_a28;
1662 ddp_criteria_rec.attribute2 := p7_a29;
1663 ddp_criteria_rec.attribute3 := p7_a30;
1664 ddp_criteria_rec.attribute4 := p7_a31;
1665 ddp_criteria_rec.attribute5 := p7_a32;
1666 ddp_criteria_rec.attribute6 := p7_a33;
1667 ddp_criteria_rec.attribute7 := p7_a34;
1668 ddp_criteria_rec.attribute8 := p7_a35;
1669 ddp_criteria_rec.attribute9 := p7_a36;
1670 ddp_criteria_rec.attribute10 := p7_a37;
1671 ddp_criteria_rec.attribute11 := p7_a38;
1672 ddp_criteria_rec.attribute12 := p7_a39;
1673 ddp_criteria_rec.attribute13 := p7_a40;
1674 ddp_criteria_rec.attribute14 := p7_a41;
1675 ddp_criteria_rec.attribute15 := p7_a42;
1676
1677
1678 ddp_subset_request_rec.records_requested := rosetta_g_miss_num_map(p9_a0);
1679 ddp_subset_request_rec.start_record_position := rosetta_g_miss_num_map(p9_a1);
1680 ddp_subset_request_rec.return_total_count_flag := p9_a2;
1681
1682
1683
1684 -- here's the delegated call to the old PL/SQL routine
1685 amv_channel_grp.find_channels(p_api_version,
1686 p_init_msg_list,
1687 p_validation_level,
1688 x_return_status,
1689 x_msg_count,
1690 x_msg_data,
1691 p_check_login_user,
1692 ddp_criteria_rec,
1693 p_sort_by,
1694 ddp_subset_request_rec,
1695 ddx_subset_return_rec,
1696 ddx_content_chan_array);
1697
1698 -- copy data back from the local variables to OUT or IN-OUT args, if any
1699
1700
1701
1702
1703
1704
1705
1706
1707
1708
1709 p10_a0 := rosetta_g_miss_num_map(ddx_subset_return_rec.returned_record_count);
1710 p10_a1 := rosetta_g_miss_num_map(ddx_subset_return_rec.next_record_position);
1711 p10_a2 := rosetta_g_miss_num_map(ddx_subset_return_rec.total_record_count);
1712
1713 amv_channel_pvt_w.rosetta_table_copy_out_p5(ddx_content_chan_array, p11_a0
1714 , p11_a1
1715 , p11_a2
1716 , p11_a3
1717 , p11_a4
1718 , p11_a5
1719 , p11_a6
1720 , p11_a7
1721 , p11_a8
1722 , p11_a9
1723 , p11_a10
1724 , p11_a11
1725 , p11_a12
1726 , p11_a13
1727 , p11_a14
1728 , p11_a15
1729 , p11_a16
1730 , p11_a17
1731 , p11_a18
1732 , p11_a19
1733 , p11_a20
1734 , p11_a21
1735 , p11_a22
1736 , p11_a23
1737 , p11_a24
1738 , p11_a25
1739 , p11_a26
1740 , p11_a27
1741 , p11_a28
1742 , p11_a29
1743 , p11_a30
1744 , p11_a31
1745 , p11_a32
1746 , p11_a33
1747 , p11_a34
1748 , p11_a35
1749 , p11_a36
1750 , p11_a37
1751 , p11_a38
1752 , p11_a39
1753 , p11_a40
1754 , p11_a41
1755 , p11_a42
1756 );
1757 end;
1758
1759 end amv_channel_grp_w;