[Home] [Help]
PACKAGE BODY: APPS.AMV_CHANNEL_PVT_W
Source
1 package body amv_channel_pvt_w as
2 /* $Header: amvwchab.pls 120.2 2005/06/30 07:50 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 rosetta_table_copy_in_p0(t out nocopy amv_channel_pvt.amv_char_varray_type, a0 JTF_VARCHAR2_TABLE_4000) as
23 ddindx binary_integer; indx binary_integer;
24 begin
25 if a0 is null then
26 t := null;
27 elsif a0.count = 0 then
28 t := amv_channel_pvt.amv_char_varray_type();
29 else
30 if a0.count > 0 then
31 t := amv_channel_pvt.amv_char_varray_type();
32 t.extend(a0.count);
33 indx := a0.first;
34 ddindx := 1;
35 while true loop
36 t(ddindx) := a0(indx);
37 ddindx := ddindx+1;
38 if a0.last =indx
39 then exit;
40 end if;
41 indx := a0.next(indx);
42 end loop;
43 end if;
44 end if;
45 end rosetta_table_copy_in_p0;
46 procedure rosetta_table_copy_out_p0(t amv_channel_pvt.amv_char_varray_type, a0 out nocopy JTF_VARCHAR2_TABLE_4000) as
47 ddindx binary_integer; indx binary_integer;
48 begin
49 if t is null then
50 a0 := null;
51 elsif t.count = 0 then
52 a0 := JTF_VARCHAR2_TABLE_4000();
53 else
54 a0 := JTF_VARCHAR2_TABLE_4000();
55 if t.count > 0 then
56 a0.extend(t.count);
57 ddindx := t.first;
58 indx := 1;
59 while true loop
60 a0(indx) := t(ddindx);
61 indx := indx+1;
62 if t.last =ddindx
63 then exit;
64 end if;
65 ddindx := t.next(ddindx);
66 end loop;
67 end if;
68 end if;
69 end rosetta_table_copy_out_p0;
70
71 procedure rosetta_table_copy_in_p1(t out nocopy amv_channel_pvt.amv_number_varray_type, a0 JTF_NUMBER_TABLE) as
72 ddindx binary_integer; indx binary_integer;
73 begin
74 if a0 is null then
75 t := null;
76 elsif a0.count = 0 then
77 t := amv_channel_pvt.amv_number_varray_type();
78 else
79 if a0.count > 0 then
80 t := amv_channel_pvt.amv_number_varray_type();
81 t.extend(a0.count);
82 indx := a0.first;
83 ddindx := 1;
84 while true loop
85 t(ddindx) := rosetta_g_miss_num_map(a0(indx));
86 ddindx := ddindx+1;
87 if a0.last =indx
88 then exit;
89 end if;
90 indx := a0.next(indx);
91 end loop;
92 end if;
93 end if;
94 end rosetta_table_copy_in_p1;
95 procedure rosetta_table_copy_out_p1(t amv_channel_pvt.amv_number_varray_type, a0 out nocopy JTF_NUMBER_TABLE) as
96 ddindx binary_integer; indx binary_integer;
97 begin
98 if t is null then
99 a0 := null;
100 elsif t.count = 0 then
101 a0 := JTF_NUMBER_TABLE();
102 else
103 a0 := JTF_NUMBER_TABLE();
104 if t.count > 0 then
105 a0.extend(t.count);
106 ddindx := t.first;
107 indx := 1;
108 while true loop
109 a0(indx) := rosetta_g_miss_num_map(t(ddindx));
110 indx := indx+1;
111 if t.last =ddindx
112 then exit;
113 end if;
114 ddindx := t.next(ddindx);
115 end loop;
116 end if;
117 end if;
118 end rosetta_table_copy_out_p1;
119
120 procedure rosetta_table_copy_in_p5(t out nocopy amv_channel_pvt.amv_channel_varray_type, a0 JTF_NUMBER_TABLE
121 , a1 JTF_NUMBER_TABLE
122 , a2 JTF_VARCHAR2_TABLE_100
123 , a3 JTF_VARCHAR2_TABLE_2000
124 , a4 JTF_VARCHAR2_TABLE_100
125 , a5 JTF_NUMBER_TABLE
126 , a6 JTF_VARCHAR2_TABLE_100
127 , a7 JTF_NUMBER_TABLE
128 , a8 JTF_NUMBER_TABLE
129 , a9 JTF_DATE_TABLE
130 , a10 JTF_DATE_TABLE
131 , a11 JTF_VARCHAR2_TABLE_100
132 , a12 JTF_VARCHAR2_TABLE_100
133 , a13 JTF_VARCHAR2_TABLE_100
134 , a14 JTF_VARCHAR2_TABLE_100
135 , a15 JTF_VARCHAR2_TABLE_100
136 , a16 JTF_VARCHAR2_TABLE_100
137 , a17 JTF_VARCHAR2_TABLE_100
138 , a18 JTF_VARCHAR2_TABLE_100
139 , a19 JTF_VARCHAR2_TABLE_100
140 , a20 JTF_VARCHAR2_TABLE_100
141 , a21 JTF_NUMBER_TABLE
142 , a22 JTF_VARCHAR2_TABLE_100
143 , a23 JTF_NUMBER_TABLE
144 , a24 JTF_DATE_TABLE
145 , a25 JTF_VARCHAR2_TABLE_100
146 , a26 JTF_DATE_TABLE
147 , a27 JTF_VARCHAR2_TABLE_100
148 , a28 JTF_VARCHAR2_TABLE_200
149 , a29 JTF_VARCHAR2_TABLE_200
150 , a30 JTF_VARCHAR2_TABLE_200
151 , a31 JTF_VARCHAR2_TABLE_200
152 , a32 JTF_VARCHAR2_TABLE_200
153 , a33 JTF_VARCHAR2_TABLE_200
154 , a34 JTF_VARCHAR2_TABLE_200
155 , a35 JTF_VARCHAR2_TABLE_200
156 , a36 JTF_VARCHAR2_TABLE_200
157 , a37 JTF_VARCHAR2_TABLE_200
158 , a38 JTF_VARCHAR2_TABLE_200
159 , a39 JTF_VARCHAR2_TABLE_200
160 , a40 JTF_VARCHAR2_TABLE_200
161 , a41 JTF_VARCHAR2_TABLE_200
162 , a42 JTF_VARCHAR2_TABLE_200
163 ) as
164 ddindx binary_integer; indx binary_integer;
165 begin
166 if a0 is not null and a0.count=0 then
167 t := amv_channel_pvt.amv_channel_varray_type();
168 elsif a0 is not null and a0.count > 0 then
169 if a0.count > 0 then
170 t := amv_channel_pvt.amv_channel_varray_type();
171 t.extend(a0.count);
172 indx := a0.first;
173 ddindx := 1;
174 while true loop
175 t(ddindx).channel_id := rosetta_g_miss_num_map(a0(indx));
176 t(ddindx).object_version_number := rosetta_g_miss_num_map(a1(indx));
177 t(ddindx).channel_name := a2(indx);
178 t(ddindx).description := a3(indx);
179 t(ddindx).channel_type := a4(indx);
180 t(ddindx).channel_category_id := rosetta_g_miss_num_map(a5(indx));
181 t(ddindx).status := a6(indx);
182 t(ddindx).owner_user_id := rosetta_g_miss_num_map(a7(indx));
183 t(ddindx).default_approver_user_id := rosetta_g_miss_num_map(a8(indx));
184 t(ddindx).effective_start_date := rosetta_g_miss_date_in_map(a9(indx));
185 t(ddindx).expiration_date := rosetta_g_miss_date_in_map(a10(indx));
186 t(ddindx).access_level_type := a11(indx);
187 t(ddindx).pub_need_approval_flag := a12(indx);
188 t(ddindx).sub_need_approval_flag := a13(indx);
189 t(ddindx).match_on_all_criteria_flag := a14(indx);
190 t(ddindx).match_on_keyword_flag := a15(indx);
191 t(ddindx).match_on_author_flag := a16(indx);
192 t(ddindx).match_on_perspective_flag := a17(indx);
193 t(ddindx).match_on_item_type_flag := a18(indx);
194 t(ddindx).match_on_content_type_flag := a19(indx);
195 t(ddindx).match_on_time_flag := a20(indx);
196 t(ddindx).application_id := rosetta_g_miss_num_map(a21(indx));
197 t(ddindx).external_access_flag := a22(indx);
198 t(ddindx).item_match_count := rosetta_g_miss_num_map(a23(indx));
199 t(ddindx).last_match_time := rosetta_g_miss_date_in_map(a24(indx));
200 t(ddindx).notification_interval_type := a25(indx);
201 t(ddindx).last_notification_time := rosetta_g_miss_date_in_map(a26(indx));
202 t(ddindx).attribute_category := a27(indx);
203 t(ddindx).attribute1 := a28(indx);
204 t(ddindx).attribute2 := a29(indx);
205 t(ddindx).attribute3 := a30(indx);
206 t(ddindx).attribute4 := a31(indx);
207 t(ddindx).attribute5 := a32(indx);
208 t(ddindx).attribute6 := a33(indx);
209 t(ddindx).attribute7 := a34(indx);
210 t(ddindx).attribute8 := a35(indx);
211 t(ddindx).attribute9 := a36(indx);
212 t(ddindx).attribute10 := a37(indx);
213 t(ddindx).attribute11 := a38(indx);
214 t(ddindx).attribute12 := a39(indx);
215 t(ddindx).attribute13 := a40(indx);
216 t(ddindx).attribute14 := a41(indx);
217 t(ddindx).attribute15 := a42(indx);
218 ddindx := ddindx+1;
219 if a0.last =indx
220 then exit;
221 end if;
222 indx := a0.next(indx);
223 end loop;
224 end if;
225 end if;
226 end rosetta_table_copy_in_p5;
227 procedure rosetta_table_copy_out_p5(t amv_channel_pvt.amv_channel_varray_type, a0 out nocopy JTF_NUMBER_TABLE
228 , a1 out nocopy JTF_NUMBER_TABLE
229 , a2 out nocopy JTF_VARCHAR2_TABLE_100
230 , a3 out nocopy JTF_VARCHAR2_TABLE_2000
231 , a4 out nocopy JTF_VARCHAR2_TABLE_100
232 , a5 out nocopy JTF_NUMBER_TABLE
233 , a6 out nocopy JTF_VARCHAR2_TABLE_100
234 , a7 out nocopy JTF_NUMBER_TABLE
235 , a8 out nocopy JTF_NUMBER_TABLE
236 , a9 out nocopy JTF_DATE_TABLE
237 , a10 out nocopy JTF_DATE_TABLE
238 , a11 out nocopy JTF_VARCHAR2_TABLE_100
239 , a12 out nocopy JTF_VARCHAR2_TABLE_100
240 , a13 out nocopy JTF_VARCHAR2_TABLE_100
241 , a14 out nocopy JTF_VARCHAR2_TABLE_100
242 , a15 out nocopy JTF_VARCHAR2_TABLE_100
243 , a16 out nocopy JTF_VARCHAR2_TABLE_100
244 , a17 out nocopy JTF_VARCHAR2_TABLE_100
245 , a18 out nocopy JTF_VARCHAR2_TABLE_100
246 , a19 out nocopy JTF_VARCHAR2_TABLE_100
247 , a20 out nocopy JTF_VARCHAR2_TABLE_100
248 , a21 out nocopy JTF_NUMBER_TABLE
249 , a22 out nocopy JTF_VARCHAR2_TABLE_100
250 , a23 out nocopy JTF_NUMBER_TABLE
251 , a24 out nocopy JTF_DATE_TABLE
252 , a25 out nocopy JTF_VARCHAR2_TABLE_100
253 , a26 out nocopy JTF_DATE_TABLE
254 , a27 out nocopy JTF_VARCHAR2_TABLE_100
255 , a28 out nocopy JTF_VARCHAR2_TABLE_200
256 , a29 out nocopy JTF_VARCHAR2_TABLE_200
257 , a30 out nocopy JTF_VARCHAR2_TABLE_200
258 , a31 out nocopy JTF_VARCHAR2_TABLE_200
259 , a32 out nocopy JTF_VARCHAR2_TABLE_200
260 , a33 out nocopy JTF_VARCHAR2_TABLE_200
261 , a34 out nocopy JTF_VARCHAR2_TABLE_200
262 , a35 out nocopy JTF_VARCHAR2_TABLE_200
263 , a36 out nocopy JTF_VARCHAR2_TABLE_200
264 , a37 out nocopy JTF_VARCHAR2_TABLE_200
265 , a38 out nocopy JTF_VARCHAR2_TABLE_200
266 , a39 out nocopy JTF_VARCHAR2_TABLE_200
267 , a40 out nocopy JTF_VARCHAR2_TABLE_200
268 , a41 out nocopy JTF_VARCHAR2_TABLE_200
269 , a42 out nocopy JTF_VARCHAR2_TABLE_200
270 ) as
271 ddindx binary_integer; indx binary_integer;
272 begin
273 if t is null then
274 a0 := null;
275 a1 := null;
276 a2 := null;
277 a3 := null;
278 a4 := null;
279 a5 := null;
280 a6 := null;
281 a7 := null;
282 a8 := null;
283 a9 := null;
284 a10 := null;
285 a11 := null;
286 a12 := null;
287 a13 := null;
288 a14 := null;
289 a15 := null;
290 a16 := null;
291 a17 := null;
292 a18 := null;
293 a19 := null;
294 a20 := null;
295 a21 := null;
296 a22 := null;
297 a23 := null;
298 a24 := null;
299 a25 := null;
300 a26 := null;
301 a27 := null;
302 a28 := null;
303 a29 := null;
304 a30 := null;
305 a31 := null;
306 a32 := null;
307 a33 := null;
308 a34 := null;
309 a35 := null;
310 a36 := null;
311 a37 := null;
312 a38 := null;
313 a39 := null;
314 a40 := null;
315 a41 := null;
316 a42 := null;
317 elsif t.count = 0 then
318 a0 := JTF_NUMBER_TABLE();
319 a1 := JTF_NUMBER_TABLE();
320 a2 := JTF_VARCHAR2_TABLE_100();
321 a3 := JTF_VARCHAR2_TABLE_2000();
322 a4 := JTF_VARCHAR2_TABLE_100();
323 a5 := JTF_NUMBER_TABLE();
324 a6 := JTF_VARCHAR2_TABLE_100();
325 a7 := JTF_NUMBER_TABLE();
326 a8 := JTF_NUMBER_TABLE();
327 a9 := JTF_DATE_TABLE();
328 a10 := JTF_DATE_TABLE();
329 a11 := JTF_VARCHAR2_TABLE_100();
330 a12 := JTF_VARCHAR2_TABLE_100();
331 a13 := JTF_VARCHAR2_TABLE_100();
332 a14 := JTF_VARCHAR2_TABLE_100();
333 a15 := JTF_VARCHAR2_TABLE_100();
334 a16 := JTF_VARCHAR2_TABLE_100();
335 a17 := JTF_VARCHAR2_TABLE_100();
336 a18 := JTF_VARCHAR2_TABLE_100();
337 a19 := JTF_VARCHAR2_TABLE_100();
338 a20 := JTF_VARCHAR2_TABLE_100();
339 a21 := JTF_NUMBER_TABLE();
340 a22 := JTF_VARCHAR2_TABLE_100();
341 a23 := JTF_NUMBER_TABLE();
342 a24 := JTF_DATE_TABLE();
343 a25 := JTF_VARCHAR2_TABLE_100();
344 a26 := JTF_DATE_TABLE();
345 a27 := JTF_VARCHAR2_TABLE_100();
346 a28 := JTF_VARCHAR2_TABLE_200();
347 a29 := JTF_VARCHAR2_TABLE_200();
348 a30 := JTF_VARCHAR2_TABLE_200();
349 a31 := JTF_VARCHAR2_TABLE_200();
350 a32 := JTF_VARCHAR2_TABLE_200();
351 a33 := JTF_VARCHAR2_TABLE_200();
352 a34 := JTF_VARCHAR2_TABLE_200();
353 a35 := JTF_VARCHAR2_TABLE_200();
354 a36 := JTF_VARCHAR2_TABLE_200();
355 a37 := JTF_VARCHAR2_TABLE_200();
356 a38 := JTF_VARCHAR2_TABLE_200();
357 a39 := JTF_VARCHAR2_TABLE_200();
358 a40 := JTF_VARCHAR2_TABLE_200();
359 a41 := JTF_VARCHAR2_TABLE_200();
360 a42 := JTF_VARCHAR2_TABLE_200();
361 else
362 a0 := JTF_NUMBER_TABLE();
363 a1 := JTF_NUMBER_TABLE();
364 a2 := JTF_VARCHAR2_TABLE_100();
365 a3 := JTF_VARCHAR2_TABLE_2000();
366 a4 := JTF_VARCHAR2_TABLE_100();
367 a5 := JTF_NUMBER_TABLE();
368 a6 := JTF_VARCHAR2_TABLE_100();
369 a7 := JTF_NUMBER_TABLE();
370 a8 := JTF_NUMBER_TABLE();
371 a9 := JTF_DATE_TABLE();
372 a10 := JTF_DATE_TABLE();
373 a11 := JTF_VARCHAR2_TABLE_100();
374 a12 := JTF_VARCHAR2_TABLE_100();
375 a13 := JTF_VARCHAR2_TABLE_100();
376 a14 := JTF_VARCHAR2_TABLE_100();
377 a15 := JTF_VARCHAR2_TABLE_100();
378 a16 := JTF_VARCHAR2_TABLE_100();
379 a17 := JTF_VARCHAR2_TABLE_100();
380 a18 := JTF_VARCHAR2_TABLE_100();
381 a19 := JTF_VARCHAR2_TABLE_100();
382 a20 := JTF_VARCHAR2_TABLE_100();
383 a21 := JTF_NUMBER_TABLE();
384 a22 := JTF_VARCHAR2_TABLE_100();
385 a23 := JTF_NUMBER_TABLE();
386 a24 := JTF_DATE_TABLE();
387 a25 := JTF_VARCHAR2_TABLE_100();
388 a26 := JTF_DATE_TABLE();
389 a27 := JTF_VARCHAR2_TABLE_100();
390 a28 := JTF_VARCHAR2_TABLE_200();
391 a29 := JTF_VARCHAR2_TABLE_200();
392 a30 := JTF_VARCHAR2_TABLE_200();
393 a31 := JTF_VARCHAR2_TABLE_200();
394 a32 := JTF_VARCHAR2_TABLE_200();
395 a33 := JTF_VARCHAR2_TABLE_200();
396 a34 := JTF_VARCHAR2_TABLE_200();
397 a35 := JTF_VARCHAR2_TABLE_200();
398 a36 := JTF_VARCHAR2_TABLE_200();
399 a37 := JTF_VARCHAR2_TABLE_200();
400 a38 := JTF_VARCHAR2_TABLE_200();
401 a39 := JTF_VARCHAR2_TABLE_200();
402 a40 := JTF_VARCHAR2_TABLE_200();
403 a41 := JTF_VARCHAR2_TABLE_200();
404 a42 := JTF_VARCHAR2_TABLE_200();
405 if t.count > 0 then
406 a0.extend(t.count);
407 a1.extend(t.count);
408 a2.extend(t.count);
409 a3.extend(t.count);
410 a4.extend(t.count);
411 a5.extend(t.count);
412 a6.extend(t.count);
413 a7.extend(t.count);
414 a8.extend(t.count);
415 a9.extend(t.count);
416 a10.extend(t.count);
417 a11.extend(t.count);
418 a12.extend(t.count);
419 a13.extend(t.count);
420 a14.extend(t.count);
421 a15.extend(t.count);
422 a16.extend(t.count);
423 a17.extend(t.count);
424 a18.extend(t.count);
425 a19.extend(t.count);
426 a20.extend(t.count);
427 a21.extend(t.count);
428 a22.extend(t.count);
429 a23.extend(t.count);
430 a24.extend(t.count);
431 a25.extend(t.count);
432 a26.extend(t.count);
433 a27.extend(t.count);
434 a28.extend(t.count);
435 a29.extend(t.count);
436 a30.extend(t.count);
437 a31.extend(t.count);
438 a32.extend(t.count);
439 a33.extend(t.count);
440 a34.extend(t.count);
441 a35.extend(t.count);
442 a36.extend(t.count);
443 a37.extend(t.count);
444 a38.extend(t.count);
445 a39.extend(t.count);
446 a40.extend(t.count);
447 a41.extend(t.count);
448 a42.extend(t.count);
449 ddindx := t.first;
450 indx := 1;
451 while true loop
452 a0(indx) := rosetta_g_miss_num_map(t(ddindx).channel_id);
453 a1(indx) := rosetta_g_miss_num_map(t(ddindx).object_version_number);
454 a2(indx) := t(ddindx).channel_name;
455 a3(indx) := t(ddindx).description;
456 a4(indx) := t(ddindx).channel_type;
457 a5(indx) := rosetta_g_miss_num_map(t(ddindx).channel_category_id);
458 a6(indx) := t(ddindx).status;
459 a7(indx) := rosetta_g_miss_num_map(t(ddindx).owner_user_id);
460 a8(indx) := rosetta_g_miss_num_map(t(ddindx).default_approver_user_id);
461 a9(indx) := t(ddindx).effective_start_date;
462 a10(indx) := t(ddindx).expiration_date;
463 a11(indx) := t(ddindx).access_level_type;
464 a12(indx) := t(ddindx).pub_need_approval_flag;
465 a13(indx) := t(ddindx).sub_need_approval_flag;
466 a14(indx) := t(ddindx).match_on_all_criteria_flag;
467 a15(indx) := t(ddindx).match_on_keyword_flag;
468 a16(indx) := t(ddindx).match_on_author_flag;
469 a17(indx) := t(ddindx).match_on_perspective_flag;
470 a18(indx) := t(ddindx).match_on_item_type_flag;
471 a19(indx) := t(ddindx).match_on_content_type_flag;
472 a20(indx) := t(ddindx).match_on_time_flag;
473 a21(indx) := rosetta_g_miss_num_map(t(ddindx).application_id);
474 a22(indx) := t(ddindx).external_access_flag;
475 a23(indx) := rosetta_g_miss_num_map(t(ddindx).item_match_count);
476 a24(indx) := t(ddindx).last_match_time;
477 a25(indx) := t(ddindx).notification_interval_type;
478 a26(indx) := t(ddindx).last_notification_time;
479 a27(indx) := t(ddindx).attribute_category;
480 a28(indx) := t(ddindx).attribute1;
481 a29(indx) := t(ddindx).attribute2;
482 a30(indx) := t(ddindx).attribute3;
483 a31(indx) := t(ddindx).attribute4;
484 a32(indx) := t(ddindx).attribute5;
485 a33(indx) := t(ddindx).attribute6;
486 a34(indx) := t(ddindx).attribute7;
487 a35(indx) := t(ddindx).attribute8;
488 a36(indx) := t(ddindx).attribute9;
489 a37(indx) := t(ddindx).attribute10;
490 a38(indx) := t(ddindx).attribute11;
491 a39(indx) := t(ddindx).attribute12;
492 a40(indx) := t(ddindx).attribute13;
493 a41(indx) := t(ddindx).attribute14;
494 a42(indx) := t(ddindx).attribute15;
495 indx := indx+1;
496 if t.last =ddindx
497 then exit;
498 end if;
499 ddindx := t.next(ddindx);
500 end loop;
501 end if;
502 end if;
503 end rosetta_table_copy_out_p5;
504
505 procedure add_channel(p_api_version NUMBER
506 , p_init_msg_list VARCHAR2
507 , p_commit VARCHAR2
508 , p_validation_level NUMBER
509 , x_return_status out nocopy VARCHAR2
510 , x_msg_count out nocopy NUMBER
511 , x_msg_data out nocopy VARCHAR2
512 , p_check_login_user VARCHAR2
513 , x_channel_id out nocopy NUMBER
514 , p8_a0 NUMBER := 0-1962.0724
515 , p8_a1 NUMBER := 0-1962.0724
516 , p8_a2 VARCHAR2 := fnd_api.g_miss_char
517 , p8_a3 VARCHAR2 := fnd_api.g_miss_char
518 , p8_a4 VARCHAR2 := fnd_api.g_miss_char
519 , p8_a5 NUMBER := 0-1962.0724
520 , p8_a6 VARCHAR2 := fnd_api.g_miss_char
521 , p8_a7 NUMBER := 0-1962.0724
522 , p8_a8 NUMBER := 0-1962.0724
523 , p8_a9 DATE := fnd_api.g_miss_date
524 , p8_a10 DATE := fnd_api.g_miss_date
525 , p8_a11 VARCHAR2 := fnd_api.g_miss_char
526 , p8_a12 VARCHAR2 := fnd_api.g_miss_char
527 , p8_a13 VARCHAR2 := fnd_api.g_miss_char
528 , p8_a14 VARCHAR2 := fnd_api.g_miss_char
529 , p8_a15 VARCHAR2 := fnd_api.g_miss_char
530 , p8_a16 VARCHAR2 := fnd_api.g_miss_char
531 , p8_a17 VARCHAR2 := fnd_api.g_miss_char
532 , p8_a18 VARCHAR2 := fnd_api.g_miss_char
533 , p8_a19 VARCHAR2 := fnd_api.g_miss_char
534 , p8_a20 VARCHAR2 := fnd_api.g_miss_char
535 , p8_a21 NUMBER := 0-1962.0724
536 , p8_a22 VARCHAR2 := fnd_api.g_miss_char
537 , p8_a23 NUMBER := 0-1962.0724
538 , p8_a24 DATE := fnd_api.g_miss_date
539 , p8_a25 VARCHAR2 := fnd_api.g_miss_char
540 , p8_a26 DATE := fnd_api.g_miss_date
541 , p8_a27 VARCHAR2 := fnd_api.g_miss_char
542 , p8_a28 VARCHAR2 := fnd_api.g_miss_char
543 , p8_a29 VARCHAR2 := fnd_api.g_miss_char
544 , p8_a30 VARCHAR2 := fnd_api.g_miss_char
545 , p8_a31 VARCHAR2 := fnd_api.g_miss_char
546 , p8_a32 VARCHAR2 := fnd_api.g_miss_char
547 , p8_a33 VARCHAR2 := fnd_api.g_miss_char
548 , p8_a34 VARCHAR2 := fnd_api.g_miss_char
549 , p8_a35 VARCHAR2 := fnd_api.g_miss_char
550 , p8_a36 VARCHAR2 := fnd_api.g_miss_char
551 , p8_a37 VARCHAR2 := fnd_api.g_miss_char
552 , p8_a38 VARCHAR2 := fnd_api.g_miss_char
553 , p8_a39 VARCHAR2 := fnd_api.g_miss_char
554 , p8_a40 VARCHAR2 := fnd_api.g_miss_char
555 , p8_a41 VARCHAR2 := fnd_api.g_miss_char
556 , p8_a42 VARCHAR2 := fnd_api.g_miss_char
557 )
558
559 as
560 ddp_channel_record amv_channel_pvt.amv_channel_obj_type;
561 ddindx binary_integer; indx binary_integer;
562 begin
563
564 -- copy data to the local IN or IN-OUT args, if any
565
566
567
568
569
570
571
572
573 ddp_channel_record.channel_id := rosetta_g_miss_num_map(p8_a0);
574 ddp_channel_record.object_version_number := rosetta_g_miss_num_map(p8_a1);
575 ddp_channel_record.channel_name := p8_a2;
576 ddp_channel_record.description := p8_a3;
577 ddp_channel_record.channel_type := p8_a4;
578 ddp_channel_record.channel_category_id := rosetta_g_miss_num_map(p8_a5);
579 ddp_channel_record.status := p8_a6;
580 ddp_channel_record.owner_user_id := rosetta_g_miss_num_map(p8_a7);
581 ddp_channel_record.default_approver_user_id := rosetta_g_miss_num_map(p8_a8);
582 ddp_channel_record.effective_start_date := rosetta_g_miss_date_in_map(p8_a9);
583 ddp_channel_record.expiration_date := rosetta_g_miss_date_in_map(p8_a10);
584 ddp_channel_record.access_level_type := p8_a11;
585 ddp_channel_record.pub_need_approval_flag := p8_a12;
586 ddp_channel_record.sub_need_approval_flag := p8_a13;
587 ddp_channel_record.match_on_all_criteria_flag := p8_a14;
588 ddp_channel_record.match_on_keyword_flag := p8_a15;
589 ddp_channel_record.match_on_author_flag := p8_a16;
590 ddp_channel_record.match_on_perspective_flag := p8_a17;
591 ddp_channel_record.match_on_item_type_flag := p8_a18;
592 ddp_channel_record.match_on_content_type_flag := p8_a19;
593 ddp_channel_record.match_on_time_flag := p8_a20;
594 ddp_channel_record.application_id := rosetta_g_miss_num_map(p8_a21);
595 ddp_channel_record.external_access_flag := p8_a22;
596 ddp_channel_record.item_match_count := rosetta_g_miss_num_map(p8_a23);
597 ddp_channel_record.last_match_time := rosetta_g_miss_date_in_map(p8_a24);
598 ddp_channel_record.notification_interval_type := p8_a25;
599 ddp_channel_record.last_notification_time := rosetta_g_miss_date_in_map(p8_a26);
600 ddp_channel_record.attribute_category := p8_a27;
601 ddp_channel_record.attribute1 := p8_a28;
602 ddp_channel_record.attribute2 := p8_a29;
603 ddp_channel_record.attribute3 := p8_a30;
604 ddp_channel_record.attribute4 := p8_a31;
605 ddp_channel_record.attribute5 := p8_a32;
606 ddp_channel_record.attribute6 := p8_a33;
607 ddp_channel_record.attribute7 := p8_a34;
608 ddp_channel_record.attribute8 := p8_a35;
609 ddp_channel_record.attribute9 := p8_a36;
610 ddp_channel_record.attribute10 := p8_a37;
611 ddp_channel_record.attribute11 := p8_a38;
612 ddp_channel_record.attribute12 := p8_a39;
613 ddp_channel_record.attribute13 := p8_a40;
614 ddp_channel_record.attribute14 := p8_a41;
615 ddp_channel_record.attribute15 := p8_a42;
616
617
618 -- here's the delegated call to the old PL/SQL routine
619 amv_channel_pvt.add_channel(p_api_version,
620 p_init_msg_list,
621 p_commit,
622 p_validation_level,
623 x_return_status,
624 x_msg_count,
625 x_msg_data,
626 p_check_login_user,
627 ddp_channel_record,
628 x_channel_id);
629
630 -- copy data back from the local variables to OUT or IN-OUT args, if any
631
632
633
634
635
636
637
638
639
640 end;
641
642 procedure add_publicchannel(p_api_version NUMBER
643 , p_init_msg_list VARCHAR2
644 , p_commit VARCHAR2
645 , p_validation_level NUMBER
646 , x_return_status out nocopy VARCHAR2
647 , x_msg_count out nocopy NUMBER
648 , x_msg_data out nocopy VARCHAR2
649 , p_check_login_user VARCHAR2
650 , x_channel_id out nocopy NUMBER
651 , p8_a0 NUMBER := 0-1962.0724
652 , p8_a1 NUMBER := 0-1962.0724
653 , p8_a2 VARCHAR2 := fnd_api.g_miss_char
654 , p8_a3 VARCHAR2 := fnd_api.g_miss_char
655 , p8_a4 VARCHAR2 := fnd_api.g_miss_char
656 , p8_a5 NUMBER := 0-1962.0724
657 , p8_a6 VARCHAR2 := fnd_api.g_miss_char
658 , p8_a7 NUMBER := 0-1962.0724
659 , p8_a8 NUMBER := 0-1962.0724
660 , p8_a9 DATE := fnd_api.g_miss_date
661 , p8_a10 DATE := fnd_api.g_miss_date
662 , p8_a11 VARCHAR2 := fnd_api.g_miss_char
663 , p8_a12 VARCHAR2 := fnd_api.g_miss_char
664 , p8_a13 VARCHAR2 := fnd_api.g_miss_char
665 , p8_a14 VARCHAR2 := fnd_api.g_miss_char
666 , p8_a15 VARCHAR2 := fnd_api.g_miss_char
667 , p8_a16 VARCHAR2 := fnd_api.g_miss_char
668 , p8_a17 VARCHAR2 := fnd_api.g_miss_char
669 , p8_a18 VARCHAR2 := fnd_api.g_miss_char
670 , p8_a19 VARCHAR2 := fnd_api.g_miss_char
671 , p8_a20 VARCHAR2 := fnd_api.g_miss_char
672 , p8_a21 NUMBER := 0-1962.0724
673 , p8_a22 VARCHAR2 := fnd_api.g_miss_char
674 , p8_a23 NUMBER := 0-1962.0724
675 , p8_a24 DATE := fnd_api.g_miss_date
676 , p8_a25 VARCHAR2 := fnd_api.g_miss_char
677 , p8_a26 DATE := fnd_api.g_miss_date
678 , p8_a27 VARCHAR2 := fnd_api.g_miss_char
679 , p8_a28 VARCHAR2 := fnd_api.g_miss_char
680 , p8_a29 VARCHAR2 := fnd_api.g_miss_char
681 , p8_a30 VARCHAR2 := fnd_api.g_miss_char
682 , p8_a31 VARCHAR2 := fnd_api.g_miss_char
683 , p8_a32 VARCHAR2 := fnd_api.g_miss_char
684 , p8_a33 VARCHAR2 := fnd_api.g_miss_char
685 , p8_a34 VARCHAR2 := fnd_api.g_miss_char
686 , p8_a35 VARCHAR2 := fnd_api.g_miss_char
687 , p8_a36 VARCHAR2 := fnd_api.g_miss_char
688 , p8_a37 VARCHAR2 := fnd_api.g_miss_char
689 , p8_a38 VARCHAR2 := fnd_api.g_miss_char
690 , p8_a39 VARCHAR2 := fnd_api.g_miss_char
691 , p8_a40 VARCHAR2 := fnd_api.g_miss_char
692 , p8_a41 VARCHAR2 := fnd_api.g_miss_char
693 , p8_a42 VARCHAR2 := fnd_api.g_miss_char
694 )
695
696 as
697 ddp_channel_record amv_channel_pvt.amv_channel_obj_type;
698 ddindx binary_integer; indx binary_integer;
699 begin
700
701 -- copy data to the local IN or IN-OUT args, if any
702
703
704
705
706
707
708
709
710 ddp_channel_record.channel_id := rosetta_g_miss_num_map(p8_a0);
711 ddp_channel_record.object_version_number := rosetta_g_miss_num_map(p8_a1);
712 ddp_channel_record.channel_name := p8_a2;
713 ddp_channel_record.description := p8_a3;
714 ddp_channel_record.channel_type := p8_a4;
715 ddp_channel_record.channel_category_id := rosetta_g_miss_num_map(p8_a5);
716 ddp_channel_record.status := p8_a6;
717 ddp_channel_record.owner_user_id := rosetta_g_miss_num_map(p8_a7);
718 ddp_channel_record.default_approver_user_id := rosetta_g_miss_num_map(p8_a8);
719 ddp_channel_record.effective_start_date := rosetta_g_miss_date_in_map(p8_a9);
720 ddp_channel_record.expiration_date := rosetta_g_miss_date_in_map(p8_a10);
721 ddp_channel_record.access_level_type := p8_a11;
722 ddp_channel_record.pub_need_approval_flag := p8_a12;
723 ddp_channel_record.sub_need_approval_flag := p8_a13;
724 ddp_channel_record.match_on_all_criteria_flag := p8_a14;
725 ddp_channel_record.match_on_keyword_flag := p8_a15;
726 ddp_channel_record.match_on_author_flag := p8_a16;
727 ddp_channel_record.match_on_perspective_flag := p8_a17;
728 ddp_channel_record.match_on_item_type_flag := p8_a18;
729 ddp_channel_record.match_on_content_type_flag := p8_a19;
730 ddp_channel_record.match_on_time_flag := p8_a20;
731 ddp_channel_record.application_id := rosetta_g_miss_num_map(p8_a21);
732 ddp_channel_record.external_access_flag := p8_a22;
733 ddp_channel_record.item_match_count := rosetta_g_miss_num_map(p8_a23);
734 ddp_channel_record.last_match_time := rosetta_g_miss_date_in_map(p8_a24);
735 ddp_channel_record.notification_interval_type := p8_a25;
736 ddp_channel_record.last_notification_time := rosetta_g_miss_date_in_map(p8_a26);
737 ddp_channel_record.attribute_category := p8_a27;
738 ddp_channel_record.attribute1 := p8_a28;
739 ddp_channel_record.attribute2 := p8_a29;
740 ddp_channel_record.attribute3 := p8_a30;
741 ddp_channel_record.attribute4 := p8_a31;
742 ddp_channel_record.attribute5 := p8_a32;
743 ddp_channel_record.attribute6 := p8_a33;
744 ddp_channel_record.attribute7 := p8_a34;
745 ddp_channel_record.attribute8 := p8_a35;
746 ddp_channel_record.attribute9 := p8_a36;
747 ddp_channel_record.attribute10 := p8_a37;
748 ddp_channel_record.attribute11 := p8_a38;
749 ddp_channel_record.attribute12 := p8_a39;
750 ddp_channel_record.attribute13 := p8_a40;
751 ddp_channel_record.attribute14 := p8_a41;
752 ddp_channel_record.attribute15 := p8_a42;
753
754
755 -- here's the delegated call to the old PL/SQL routine
756 amv_channel_pvt.add_publicchannel(p_api_version,
757 p_init_msg_list,
758 p_commit,
759 p_validation_level,
760 x_return_status,
761 x_msg_count,
762 x_msg_data,
763 p_check_login_user,
764 ddp_channel_record,
765 x_channel_id);
766
767 -- copy data back from the local variables to OUT or IN-OUT args, if any
768
769
770
771
772
773
774
775
776
777 end;
778
779 procedure add_protectedchannel(p_api_version NUMBER
780 , p_init_msg_list VARCHAR2
781 , p_commit VARCHAR2
782 , p_validation_level NUMBER
783 , x_return_status out nocopy VARCHAR2
784 , x_msg_count out nocopy NUMBER
785 , x_msg_data out nocopy VARCHAR2
786 , p_check_login_user VARCHAR2
787 , x_channel_id out nocopy NUMBER
788 , p8_a0 NUMBER := 0-1962.0724
789 , p8_a1 NUMBER := 0-1962.0724
790 , p8_a2 VARCHAR2 := fnd_api.g_miss_char
791 , p8_a3 VARCHAR2 := fnd_api.g_miss_char
792 , p8_a4 VARCHAR2 := fnd_api.g_miss_char
793 , p8_a5 NUMBER := 0-1962.0724
794 , p8_a6 VARCHAR2 := fnd_api.g_miss_char
795 , p8_a7 NUMBER := 0-1962.0724
796 , p8_a8 NUMBER := 0-1962.0724
797 , p8_a9 DATE := fnd_api.g_miss_date
798 , p8_a10 DATE := fnd_api.g_miss_date
799 , p8_a11 VARCHAR2 := fnd_api.g_miss_char
800 , p8_a12 VARCHAR2 := fnd_api.g_miss_char
801 , p8_a13 VARCHAR2 := fnd_api.g_miss_char
802 , p8_a14 VARCHAR2 := fnd_api.g_miss_char
803 , p8_a15 VARCHAR2 := fnd_api.g_miss_char
804 , p8_a16 VARCHAR2 := fnd_api.g_miss_char
805 , p8_a17 VARCHAR2 := fnd_api.g_miss_char
806 , p8_a18 VARCHAR2 := fnd_api.g_miss_char
807 , p8_a19 VARCHAR2 := fnd_api.g_miss_char
808 , p8_a20 VARCHAR2 := fnd_api.g_miss_char
809 , p8_a21 NUMBER := 0-1962.0724
810 , p8_a22 VARCHAR2 := fnd_api.g_miss_char
811 , p8_a23 NUMBER := 0-1962.0724
812 , p8_a24 DATE := fnd_api.g_miss_date
813 , p8_a25 VARCHAR2 := fnd_api.g_miss_char
814 , p8_a26 DATE := fnd_api.g_miss_date
815 , p8_a27 VARCHAR2 := fnd_api.g_miss_char
816 , p8_a28 VARCHAR2 := fnd_api.g_miss_char
817 , p8_a29 VARCHAR2 := fnd_api.g_miss_char
818 , p8_a30 VARCHAR2 := fnd_api.g_miss_char
819 , p8_a31 VARCHAR2 := fnd_api.g_miss_char
820 , p8_a32 VARCHAR2 := fnd_api.g_miss_char
821 , p8_a33 VARCHAR2 := fnd_api.g_miss_char
822 , p8_a34 VARCHAR2 := fnd_api.g_miss_char
823 , p8_a35 VARCHAR2 := fnd_api.g_miss_char
824 , p8_a36 VARCHAR2 := fnd_api.g_miss_char
825 , p8_a37 VARCHAR2 := fnd_api.g_miss_char
826 , p8_a38 VARCHAR2 := fnd_api.g_miss_char
827 , p8_a39 VARCHAR2 := fnd_api.g_miss_char
828 , p8_a40 VARCHAR2 := fnd_api.g_miss_char
829 , p8_a41 VARCHAR2 := fnd_api.g_miss_char
830 , p8_a42 VARCHAR2 := fnd_api.g_miss_char
831 )
832
833 as
834 ddp_channel_record amv_channel_pvt.amv_channel_obj_type;
835 ddindx binary_integer; indx binary_integer;
836 begin
837
838 -- copy data to the local IN or IN-OUT args, if any
839
840
841
842
843
844
845
846
847 ddp_channel_record.channel_id := rosetta_g_miss_num_map(p8_a0);
848 ddp_channel_record.object_version_number := rosetta_g_miss_num_map(p8_a1);
849 ddp_channel_record.channel_name := p8_a2;
850 ddp_channel_record.description := p8_a3;
851 ddp_channel_record.channel_type := p8_a4;
852 ddp_channel_record.channel_category_id := rosetta_g_miss_num_map(p8_a5);
853 ddp_channel_record.status := p8_a6;
854 ddp_channel_record.owner_user_id := rosetta_g_miss_num_map(p8_a7);
855 ddp_channel_record.default_approver_user_id := rosetta_g_miss_num_map(p8_a8);
856 ddp_channel_record.effective_start_date := rosetta_g_miss_date_in_map(p8_a9);
857 ddp_channel_record.expiration_date := rosetta_g_miss_date_in_map(p8_a10);
858 ddp_channel_record.access_level_type := p8_a11;
859 ddp_channel_record.pub_need_approval_flag := p8_a12;
860 ddp_channel_record.sub_need_approval_flag := p8_a13;
861 ddp_channel_record.match_on_all_criteria_flag := p8_a14;
862 ddp_channel_record.match_on_keyword_flag := p8_a15;
863 ddp_channel_record.match_on_author_flag := p8_a16;
864 ddp_channel_record.match_on_perspective_flag := p8_a17;
865 ddp_channel_record.match_on_item_type_flag := p8_a18;
866 ddp_channel_record.match_on_content_type_flag := p8_a19;
867 ddp_channel_record.match_on_time_flag := p8_a20;
868 ddp_channel_record.application_id := rosetta_g_miss_num_map(p8_a21);
869 ddp_channel_record.external_access_flag := p8_a22;
870 ddp_channel_record.item_match_count := rosetta_g_miss_num_map(p8_a23);
871 ddp_channel_record.last_match_time := rosetta_g_miss_date_in_map(p8_a24);
872 ddp_channel_record.notification_interval_type := p8_a25;
873 ddp_channel_record.last_notification_time := rosetta_g_miss_date_in_map(p8_a26);
874 ddp_channel_record.attribute_category := p8_a27;
875 ddp_channel_record.attribute1 := p8_a28;
876 ddp_channel_record.attribute2 := p8_a29;
877 ddp_channel_record.attribute3 := p8_a30;
878 ddp_channel_record.attribute4 := p8_a31;
879 ddp_channel_record.attribute5 := p8_a32;
880 ddp_channel_record.attribute6 := p8_a33;
881 ddp_channel_record.attribute7 := p8_a34;
882 ddp_channel_record.attribute8 := p8_a35;
883 ddp_channel_record.attribute9 := p8_a36;
884 ddp_channel_record.attribute10 := p8_a37;
885 ddp_channel_record.attribute11 := p8_a38;
886 ddp_channel_record.attribute12 := p8_a39;
887 ddp_channel_record.attribute13 := p8_a40;
888 ddp_channel_record.attribute14 := p8_a41;
889 ddp_channel_record.attribute15 := p8_a42;
890
891
892 -- here's the delegated call to the old PL/SQL routine
893 amv_channel_pvt.add_protectedchannel(p_api_version,
894 p_init_msg_list,
895 p_commit,
896 p_validation_level,
897 x_return_status,
898 x_msg_count,
899 x_msg_data,
900 p_check_login_user,
901 ddp_channel_record,
902 x_channel_id);
903
904 -- copy data back from the local variables to OUT or IN-OUT args, if any
905
906
907
908
909
910
911
912
913
914 end;
915
916 procedure add_privatechannel(p_api_version NUMBER
917 , p_init_msg_list VARCHAR2
918 , p_commit VARCHAR2
919 , p_validation_level NUMBER
920 , x_return_status out nocopy VARCHAR2
921 , x_msg_count out nocopy NUMBER
922 , x_msg_data out nocopy VARCHAR2
923 , p_check_login_user VARCHAR2
924 , x_channel_id out nocopy NUMBER
925 , p8_a0 NUMBER := 0-1962.0724
926 , p8_a1 NUMBER := 0-1962.0724
927 , p8_a2 VARCHAR2 := fnd_api.g_miss_char
928 , p8_a3 VARCHAR2 := fnd_api.g_miss_char
929 , p8_a4 VARCHAR2 := fnd_api.g_miss_char
930 , p8_a5 NUMBER := 0-1962.0724
931 , p8_a6 VARCHAR2 := fnd_api.g_miss_char
932 , p8_a7 NUMBER := 0-1962.0724
933 , p8_a8 NUMBER := 0-1962.0724
934 , p8_a9 DATE := fnd_api.g_miss_date
935 , p8_a10 DATE := fnd_api.g_miss_date
936 , p8_a11 VARCHAR2 := fnd_api.g_miss_char
937 , p8_a12 VARCHAR2 := fnd_api.g_miss_char
938 , p8_a13 VARCHAR2 := fnd_api.g_miss_char
939 , p8_a14 VARCHAR2 := fnd_api.g_miss_char
940 , p8_a15 VARCHAR2 := fnd_api.g_miss_char
941 , p8_a16 VARCHAR2 := fnd_api.g_miss_char
942 , p8_a17 VARCHAR2 := fnd_api.g_miss_char
943 , p8_a18 VARCHAR2 := fnd_api.g_miss_char
944 , p8_a19 VARCHAR2 := fnd_api.g_miss_char
945 , p8_a20 VARCHAR2 := fnd_api.g_miss_char
946 , p8_a21 NUMBER := 0-1962.0724
947 , p8_a22 VARCHAR2 := fnd_api.g_miss_char
948 , p8_a23 NUMBER := 0-1962.0724
949 , p8_a24 DATE := fnd_api.g_miss_date
950 , p8_a25 VARCHAR2 := fnd_api.g_miss_char
951 , p8_a26 DATE := fnd_api.g_miss_date
952 , p8_a27 VARCHAR2 := fnd_api.g_miss_char
953 , p8_a28 VARCHAR2 := fnd_api.g_miss_char
954 , p8_a29 VARCHAR2 := fnd_api.g_miss_char
955 , p8_a30 VARCHAR2 := fnd_api.g_miss_char
956 , p8_a31 VARCHAR2 := fnd_api.g_miss_char
957 , p8_a32 VARCHAR2 := fnd_api.g_miss_char
958 , p8_a33 VARCHAR2 := fnd_api.g_miss_char
959 , p8_a34 VARCHAR2 := fnd_api.g_miss_char
960 , p8_a35 VARCHAR2 := fnd_api.g_miss_char
961 , p8_a36 VARCHAR2 := fnd_api.g_miss_char
962 , p8_a37 VARCHAR2 := fnd_api.g_miss_char
963 , p8_a38 VARCHAR2 := fnd_api.g_miss_char
964 , p8_a39 VARCHAR2 := fnd_api.g_miss_char
965 , p8_a40 VARCHAR2 := fnd_api.g_miss_char
966 , p8_a41 VARCHAR2 := fnd_api.g_miss_char
967 , p8_a42 VARCHAR2 := fnd_api.g_miss_char
968 )
969
970 as
971 ddp_channel_record amv_channel_pvt.amv_channel_obj_type;
972 ddindx binary_integer; indx binary_integer;
973 begin
974
975 -- copy data to the local IN or IN-OUT args, if any
976
977
978
979
980
981
982
983
984 ddp_channel_record.channel_id := rosetta_g_miss_num_map(p8_a0);
985 ddp_channel_record.object_version_number := rosetta_g_miss_num_map(p8_a1);
986 ddp_channel_record.channel_name := p8_a2;
987 ddp_channel_record.description := p8_a3;
988 ddp_channel_record.channel_type := p8_a4;
989 ddp_channel_record.channel_category_id := rosetta_g_miss_num_map(p8_a5);
990 ddp_channel_record.status := p8_a6;
991 ddp_channel_record.owner_user_id := rosetta_g_miss_num_map(p8_a7);
992 ddp_channel_record.default_approver_user_id := rosetta_g_miss_num_map(p8_a8);
993 ddp_channel_record.effective_start_date := rosetta_g_miss_date_in_map(p8_a9);
994 ddp_channel_record.expiration_date := rosetta_g_miss_date_in_map(p8_a10);
995 ddp_channel_record.access_level_type := p8_a11;
996 ddp_channel_record.pub_need_approval_flag := p8_a12;
997 ddp_channel_record.sub_need_approval_flag := p8_a13;
998 ddp_channel_record.match_on_all_criteria_flag := p8_a14;
999 ddp_channel_record.match_on_keyword_flag := p8_a15;
1000 ddp_channel_record.match_on_author_flag := p8_a16;
1001 ddp_channel_record.match_on_perspective_flag := p8_a17;
1002 ddp_channel_record.match_on_item_type_flag := p8_a18;
1003 ddp_channel_record.match_on_content_type_flag := p8_a19;
1004 ddp_channel_record.match_on_time_flag := p8_a20;
1005 ddp_channel_record.application_id := rosetta_g_miss_num_map(p8_a21);
1006 ddp_channel_record.external_access_flag := p8_a22;
1007 ddp_channel_record.item_match_count := rosetta_g_miss_num_map(p8_a23);
1008 ddp_channel_record.last_match_time := rosetta_g_miss_date_in_map(p8_a24);
1009 ddp_channel_record.notification_interval_type := p8_a25;
1010 ddp_channel_record.last_notification_time := rosetta_g_miss_date_in_map(p8_a26);
1011 ddp_channel_record.attribute_category := p8_a27;
1012 ddp_channel_record.attribute1 := p8_a28;
1013 ddp_channel_record.attribute2 := p8_a29;
1014 ddp_channel_record.attribute3 := p8_a30;
1015 ddp_channel_record.attribute4 := p8_a31;
1016 ddp_channel_record.attribute5 := p8_a32;
1017 ddp_channel_record.attribute6 := p8_a33;
1018 ddp_channel_record.attribute7 := p8_a34;
1019 ddp_channel_record.attribute8 := p8_a35;
1020 ddp_channel_record.attribute9 := p8_a36;
1021 ddp_channel_record.attribute10 := p8_a37;
1022 ddp_channel_record.attribute11 := p8_a38;
1023 ddp_channel_record.attribute12 := p8_a39;
1024 ddp_channel_record.attribute13 := p8_a40;
1025 ddp_channel_record.attribute14 := p8_a41;
1026 ddp_channel_record.attribute15 := p8_a42;
1027
1028
1029 -- here's the delegated call to the old PL/SQL routine
1030 amv_channel_pvt.add_privatechannel(p_api_version,
1031 p_init_msg_list,
1032 p_commit,
1033 p_validation_level,
1034 x_return_status,
1035 x_msg_count,
1036 x_msg_data,
1037 p_check_login_user,
1038 ddp_channel_record,
1039 x_channel_id);
1040
1041 -- copy data back from the local variables to OUT or IN-OUT args, if any
1042
1043
1044
1045
1046
1047
1048
1049
1050
1051 end;
1052
1053 procedure add_groupchannel(p_api_version NUMBER
1054 , p_init_msg_list VARCHAR2
1055 , p_commit VARCHAR2
1056 , p_validation_level NUMBER
1057 , x_return_status out nocopy VARCHAR2
1058 , x_msg_count out nocopy NUMBER
1059 , x_msg_data out nocopy VARCHAR2
1060 , p_check_login_user VARCHAR2
1061 , p_group_id NUMBER
1062 , x_channel_id out nocopy NUMBER
1063 , p9_a0 NUMBER := 0-1962.0724
1064 , p9_a1 NUMBER := 0-1962.0724
1065 , p9_a2 VARCHAR2 := fnd_api.g_miss_char
1066 , p9_a3 VARCHAR2 := fnd_api.g_miss_char
1067 , p9_a4 VARCHAR2 := fnd_api.g_miss_char
1068 , p9_a5 NUMBER := 0-1962.0724
1069 , p9_a6 VARCHAR2 := fnd_api.g_miss_char
1070 , p9_a7 NUMBER := 0-1962.0724
1071 , p9_a8 NUMBER := 0-1962.0724
1072 , p9_a9 DATE := fnd_api.g_miss_date
1073 , p9_a10 DATE := fnd_api.g_miss_date
1074 , p9_a11 VARCHAR2 := fnd_api.g_miss_char
1075 , p9_a12 VARCHAR2 := fnd_api.g_miss_char
1076 , p9_a13 VARCHAR2 := fnd_api.g_miss_char
1077 , p9_a14 VARCHAR2 := fnd_api.g_miss_char
1078 , p9_a15 VARCHAR2 := fnd_api.g_miss_char
1079 , p9_a16 VARCHAR2 := fnd_api.g_miss_char
1080 , p9_a17 VARCHAR2 := fnd_api.g_miss_char
1081 , p9_a18 VARCHAR2 := fnd_api.g_miss_char
1082 , p9_a19 VARCHAR2 := fnd_api.g_miss_char
1083 , p9_a20 VARCHAR2 := fnd_api.g_miss_char
1084 , p9_a21 NUMBER := 0-1962.0724
1085 , p9_a22 VARCHAR2 := fnd_api.g_miss_char
1086 , p9_a23 NUMBER := 0-1962.0724
1087 , p9_a24 DATE := fnd_api.g_miss_date
1088 , p9_a25 VARCHAR2 := fnd_api.g_miss_char
1089 , p9_a26 DATE := fnd_api.g_miss_date
1090 , p9_a27 VARCHAR2 := fnd_api.g_miss_char
1091 , p9_a28 VARCHAR2 := fnd_api.g_miss_char
1092 , p9_a29 VARCHAR2 := fnd_api.g_miss_char
1093 , p9_a30 VARCHAR2 := fnd_api.g_miss_char
1094 , p9_a31 VARCHAR2 := fnd_api.g_miss_char
1095 , p9_a32 VARCHAR2 := fnd_api.g_miss_char
1096 , p9_a33 VARCHAR2 := fnd_api.g_miss_char
1097 , p9_a34 VARCHAR2 := fnd_api.g_miss_char
1098 , p9_a35 VARCHAR2 := fnd_api.g_miss_char
1099 , p9_a36 VARCHAR2 := fnd_api.g_miss_char
1100 , p9_a37 VARCHAR2 := fnd_api.g_miss_char
1101 , p9_a38 VARCHAR2 := fnd_api.g_miss_char
1102 , p9_a39 VARCHAR2 := fnd_api.g_miss_char
1103 , p9_a40 VARCHAR2 := fnd_api.g_miss_char
1104 , p9_a41 VARCHAR2 := fnd_api.g_miss_char
1105 , p9_a42 VARCHAR2 := fnd_api.g_miss_char
1106 )
1107
1108 as
1109 ddp_channel_record amv_channel_pvt.amv_channel_obj_type;
1110 ddindx binary_integer; indx binary_integer;
1111 begin
1112
1113 -- copy data to the local IN or IN-OUT args, if any
1114
1115
1116
1117
1118
1119
1120
1121
1122
1123 ddp_channel_record.channel_id := rosetta_g_miss_num_map(p9_a0);
1124 ddp_channel_record.object_version_number := rosetta_g_miss_num_map(p9_a1);
1125 ddp_channel_record.channel_name := p9_a2;
1126 ddp_channel_record.description := p9_a3;
1127 ddp_channel_record.channel_type := p9_a4;
1128 ddp_channel_record.channel_category_id := rosetta_g_miss_num_map(p9_a5);
1129 ddp_channel_record.status := p9_a6;
1130 ddp_channel_record.owner_user_id := rosetta_g_miss_num_map(p9_a7);
1131 ddp_channel_record.default_approver_user_id := rosetta_g_miss_num_map(p9_a8);
1132 ddp_channel_record.effective_start_date := rosetta_g_miss_date_in_map(p9_a9);
1133 ddp_channel_record.expiration_date := rosetta_g_miss_date_in_map(p9_a10);
1134 ddp_channel_record.access_level_type := p9_a11;
1135 ddp_channel_record.pub_need_approval_flag := p9_a12;
1136 ddp_channel_record.sub_need_approval_flag := p9_a13;
1137 ddp_channel_record.match_on_all_criteria_flag := p9_a14;
1138 ddp_channel_record.match_on_keyword_flag := p9_a15;
1139 ddp_channel_record.match_on_author_flag := p9_a16;
1140 ddp_channel_record.match_on_perspective_flag := p9_a17;
1141 ddp_channel_record.match_on_item_type_flag := p9_a18;
1142 ddp_channel_record.match_on_content_type_flag := p9_a19;
1143 ddp_channel_record.match_on_time_flag := p9_a20;
1144 ddp_channel_record.application_id := rosetta_g_miss_num_map(p9_a21);
1145 ddp_channel_record.external_access_flag := p9_a22;
1146 ddp_channel_record.item_match_count := rosetta_g_miss_num_map(p9_a23);
1147 ddp_channel_record.last_match_time := rosetta_g_miss_date_in_map(p9_a24);
1148 ddp_channel_record.notification_interval_type := p9_a25;
1149 ddp_channel_record.last_notification_time := rosetta_g_miss_date_in_map(p9_a26);
1150 ddp_channel_record.attribute_category := p9_a27;
1151 ddp_channel_record.attribute1 := p9_a28;
1152 ddp_channel_record.attribute2 := p9_a29;
1153 ddp_channel_record.attribute3 := p9_a30;
1154 ddp_channel_record.attribute4 := p9_a31;
1155 ddp_channel_record.attribute5 := p9_a32;
1156 ddp_channel_record.attribute6 := p9_a33;
1157 ddp_channel_record.attribute7 := p9_a34;
1158 ddp_channel_record.attribute8 := p9_a35;
1159 ddp_channel_record.attribute9 := p9_a36;
1160 ddp_channel_record.attribute10 := p9_a37;
1161 ddp_channel_record.attribute11 := p9_a38;
1162 ddp_channel_record.attribute12 := p9_a39;
1163 ddp_channel_record.attribute13 := p9_a40;
1164 ddp_channel_record.attribute14 := p9_a41;
1165 ddp_channel_record.attribute15 := p9_a42;
1166
1167
1168 -- here's the delegated call to the old PL/SQL routine
1169 amv_channel_pvt.add_groupchannel(p_api_version,
1170 p_init_msg_list,
1171 p_commit,
1172 p_validation_level,
1173 x_return_status,
1174 x_msg_count,
1175 x_msg_data,
1176 p_check_login_user,
1177 p_group_id,
1178 ddp_channel_record,
1179 x_channel_id);
1180
1181 -- copy data back from the local variables to OUT or IN-OUT args, if any
1182
1183
1184
1185
1186
1187
1188
1189
1190
1191
1192 end;
1193
1194 procedure update_channel(p_api_version NUMBER
1195 , p_init_msg_list VARCHAR2
1196 , p_commit VARCHAR2
1197 , p_validation_level NUMBER
1198 , x_return_status out nocopy VARCHAR2
1199 , x_msg_count out nocopy NUMBER
1200 , x_msg_data out nocopy VARCHAR2
1201 , p_check_login_user VARCHAR2
1202 , p8_a0 NUMBER := 0-1962.0724
1203 , p8_a1 NUMBER := 0-1962.0724
1204 , p8_a2 VARCHAR2 := fnd_api.g_miss_char
1205 , p8_a3 VARCHAR2 := fnd_api.g_miss_char
1206 , p8_a4 VARCHAR2 := fnd_api.g_miss_char
1207 , p8_a5 NUMBER := 0-1962.0724
1208 , p8_a6 VARCHAR2 := fnd_api.g_miss_char
1209 , p8_a7 NUMBER := 0-1962.0724
1210 , p8_a8 NUMBER := 0-1962.0724
1211 , p8_a9 DATE := fnd_api.g_miss_date
1212 , p8_a10 DATE := fnd_api.g_miss_date
1213 , p8_a11 VARCHAR2 := fnd_api.g_miss_char
1214 , p8_a12 VARCHAR2 := fnd_api.g_miss_char
1215 , p8_a13 VARCHAR2 := fnd_api.g_miss_char
1216 , p8_a14 VARCHAR2 := fnd_api.g_miss_char
1217 , p8_a15 VARCHAR2 := fnd_api.g_miss_char
1218 , p8_a16 VARCHAR2 := fnd_api.g_miss_char
1219 , p8_a17 VARCHAR2 := fnd_api.g_miss_char
1220 , p8_a18 VARCHAR2 := fnd_api.g_miss_char
1221 , p8_a19 VARCHAR2 := fnd_api.g_miss_char
1222 , p8_a20 VARCHAR2 := fnd_api.g_miss_char
1223 , p8_a21 NUMBER := 0-1962.0724
1224 , p8_a22 VARCHAR2 := fnd_api.g_miss_char
1225 , p8_a23 NUMBER := 0-1962.0724
1226 , p8_a24 DATE := fnd_api.g_miss_date
1227 , p8_a25 VARCHAR2 := fnd_api.g_miss_char
1228 , p8_a26 DATE := fnd_api.g_miss_date
1229 , p8_a27 VARCHAR2 := fnd_api.g_miss_char
1230 , p8_a28 VARCHAR2 := fnd_api.g_miss_char
1231 , p8_a29 VARCHAR2 := fnd_api.g_miss_char
1232 , p8_a30 VARCHAR2 := fnd_api.g_miss_char
1233 , p8_a31 VARCHAR2 := fnd_api.g_miss_char
1234 , p8_a32 VARCHAR2 := fnd_api.g_miss_char
1235 , p8_a33 VARCHAR2 := fnd_api.g_miss_char
1236 , p8_a34 VARCHAR2 := fnd_api.g_miss_char
1237 , p8_a35 VARCHAR2 := fnd_api.g_miss_char
1238 , p8_a36 VARCHAR2 := fnd_api.g_miss_char
1239 , p8_a37 VARCHAR2 := fnd_api.g_miss_char
1240 , p8_a38 VARCHAR2 := fnd_api.g_miss_char
1241 , p8_a39 VARCHAR2 := fnd_api.g_miss_char
1242 , p8_a40 VARCHAR2 := fnd_api.g_miss_char
1243 , p8_a41 VARCHAR2 := fnd_api.g_miss_char
1244 , p8_a42 VARCHAR2 := fnd_api.g_miss_char
1245 )
1246
1247 as
1248 ddp_channel_record amv_channel_pvt.amv_channel_obj_type;
1249 ddindx binary_integer; indx binary_integer;
1250 begin
1251
1252 -- copy data to the local IN or IN-OUT args, if any
1253
1254
1255
1256
1257
1258
1259
1260
1261 ddp_channel_record.channel_id := rosetta_g_miss_num_map(p8_a0);
1262 ddp_channel_record.object_version_number := rosetta_g_miss_num_map(p8_a1);
1263 ddp_channel_record.channel_name := p8_a2;
1264 ddp_channel_record.description := p8_a3;
1265 ddp_channel_record.channel_type := p8_a4;
1266 ddp_channel_record.channel_category_id := rosetta_g_miss_num_map(p8_a5);
1267 ddp_channel_record.status := p8_a6;
1268 ddp_channel_record.owner_user_id := rosetta_g_miss_num_map(p8_a7);
1269 ddp_channel_record.default_approver_user_id := rosetta_g_miss_num_map(p8_a8);
1270 ddp_channel_record.effective_start_date := rosetta_g_miss_date_in_map(p8_a9);
1271 ddp_channel_record.expiration_date := rosetta_g_miss_date_in_map(p8_a10);
1272 ddp_channel_record.access_level_type := p8_a11;
1273 ddp_channel_record.pub_need_approval_flag := p8_a12;
1274 ddp_channel_record.sub_need_approval_flag := p8_a13;
1275 ddp_channel_record.match_on_all_criteria_flag := p8_a14;
1276 ddp_channel_record.match_on_keyword_flag := p8_a15;
1277 ddp_channel_record.match_on_author_flag := p8_a16;
1278 ddp_channel_record.match_on_perspective_flag := p8_a17;
1279 ddp_channel_record.match_on_item_type_flag := p8_a18;
1280 ddp_channel_record.match_on_content_type_flag := p8_a19;
1281 ddp_channel_record.match_on_time_flag := p8_a20;
1282 ddp_channel_record.application_id := rosetta_g_miss_num_map(p8_a21);
1283 ddp_channel_record.external_access_flag := p8_a22;
1284 ddp_channel_record.item_match_count := rosetta_g_miss_num_map(p8_a23);
1285 ddp_channel_record.last_match_time := rosetta_g_miss_date_in_map(p8_a24);
1286 ddp_channel_record.notification_interval_type := p8_a25;
1287 ddp_channel_record.last_notification_time := rosetta_g_miss_date_in_map(p8_a26);
1288 ddp_channel_record.attribute_category := p8_a27;
1289 ddp_channel_record.attribute1 := p8_a28;
1290 ddp_channel_record.attribute2 := p8_a29;
1291 ddp_channel_record.attribute3 := p8_a30;
1292 ddp_channel_record.attribute4 := p8_a31;
1293 ddp_channel_record.attribute5 := p8_a32;
1294 ddp_channel_record.attribute6 := p8_a33;
1295 ddp_channel_record.attribute7 := p8_a34;
1296 ddp_channel_record.attribute8 := p8_a35;
1297 ddp_channel_record.attribute9 := p8_a36;
1298 ddp_channel_record.attribute10 := p8_a37;
1299 ddp_channel_record.attribute11 := p8_a38;
1300 ddp_channel_record.attribute12 := p8_a39;
1301 ddp_channel_record.attribute13 := p8_a40;
1302 ddp_channel_record.attribute14 := p8_a41;
1303 ddp_channel_record.attribute15 := p8_a42;
1304
1305 -- here's the delegated call to the old PL/SQL routine
1306 amv_channel_pvt.update_channel(p_api_version,
1307 p_init_msg_list,
1308 p_commit,
1309 p_validation_level,
1310 x_return_status,
1311 x_msg_count,
1312 x_msg_data,
1313 p_check_login_user,
1314 ddp_channel_record);
1315
1316 -- copy data back from the local variables to OUT or IN-OUT args, if any
1317
1318
1319
1320
1321
1322
1323
1324
1325 end;
1326
1327 procedure get_channel(p_api_version NUMBER
1328 , p_init_msg_list VARCHAR2
1329 , p_validation_level NUMBER
1330 , x_return_status out nocopy VARCHAR2
1331 , x_msg_count out nocopy NUMBER
1332 , x_msg_data out nocopy VARCHAR2
1333 , p_check_login_user VARCHAR2
1334 , p_channel_id NUMBER
1335 , p_channel_name VARCHAR2
1336 , p_category_id NUMBER
1337 , p10_a0 out nocopy NUMBER
1338 , p10_a1 out nocopy NUMBER
1339 , p10_a2 out nocopy VARCHAR2
1340 , p10_a3 out nocopy VARCHAR2
1341 , p10_a4 out nocopy VARCHAR2
1342 , p10_a5 out nocopy NUMBER
1343 , p10_a6 out nocopy VARCHAR2
1344 , p10_a7 out nocopy NUMBER
1345 , p10_a8 out nocopy NUMBER
1346 , p10_a9 out nocopy DATE
1347 , p10_a10 out nocopy DATE
1348 , p10_a11 out nocopy VARCHAR2
1349 , p10_a12 out nocopy VARCHAR2
1350 , p10_a13 out nocopy VARCHAR2
1351 , p10_a14 out nocopy VARCHAR2
1352 , p10_a15 out nocopy VARCHAR2
1353 , p10_a16 out nocopy VARCHAR2
1354 , p10_a17 out nocopy VARCHAR2
1355 , p10_a18 out nocopy VARCHAR2
1356 , p10_a19 out nocopy VARCHAR2
1357 , p10_a20 out nocopy VARCHAR2
1358 , p10_a21 out nocopy NUMBER
1359 , p10_a22 out nocopy VARCHAR2
1360 , p10_a23 out nocopy NUMBER
1361 , p10_a24 out nocopy DATE
1362 , p10_a25 out nocopy VARCHAR2
1363 , p10_a26 out nocopy DATE
1364 , p10_a27 out nocopy VARCHAR2
1365 , p10_a28 out nocopy VARCHAR2
1366 , p10_a29 out nocopy VARCHAR2
1367 , p10_a30 out nocopy VARCHAR2
1368 , p10_a31 out nocopy VARCHAR2
1369 , p10_a32 out nocopy VARCHAR2
1370 , p10_a33 out nocopy VARCHAR2
1371 , p10_a34 out nocopy VARCHAR2
1372 , p10_a35 out nocopy VARCHAR2
1373 , p10_a36 out nocopy VARCHAR2
1374 , p10_a37 out nocopy VARCHAR2
1375 , p10_a38 out nocopy VARCHAR2
1376 , p10_a39 out nocopy VARCHAR2
1377 , p10_a40 out nocopy VARCHAR2
1378 , p10_a41 out nocopy VARCHAR2
1379 , p10_a42 out nocopy VARCHAR2
1380 )
1381
1382 as
1383 ddx_channel_record amv_channel_pvt.amv_channel_obj_type;
1384 ddindx binary_integer; indx binary_integer;
1385 begin
1386
1387 -- copy data to the local IN or IN-OUT args, if any
1388
1389
1390
1391
1392
1393
1394
1395
1396
1397
1398
1399 -- here's the delegated call to the old PL/SQL routine
1400 amv_channel_pvt.get_channel(p_api_version,
1401 p_init_msg_list,
1402 p_validation_level,
1403 x_return_status,
1404 x_msg_count,
1405 x_msg_data,
1406 p_check_login_user,
1407 p_channel_id,
1408 p_channel_name,
1409 p_category_id,
1410 ddx_channel_record);
1411
1412 -- copy data back from the local variables to OUT or IN-OUT args, if any
1413
1414
1415
1416
1417
1418
1419
1420
1421
1422
1423 p10_a0 := rosetta_g_miss_num_map(ddx_channel_record.channel_id);
1424 p10_a1 := rosetta_g_miss_num_map(ddx_channel_record.object_version_number);
1425 p10_a2 := ddx_channel_record.channel_name;
1426 p10_a3 := ddx_channel_record.description;
1427 p10_a4 := ddx_channel_record.channel_type;
1428 p10_a5 := rosetta_g_miss_num_map(ddx_channel_record.channel_category_id);
1429 p10_a6 := ddx_channel_record.status;
1430 p10_a7 := rosetta_g_miss_num_map(ddx_channel_record.owner_user_id);
1431 p10_a8 := rosetta_g_miss_num_map(ddx_channel_record.default_approver_user_id);
1432 p10_a9 := ddx_channel_record.effective_start_date;
1433 p10_a10 := ddx_channel_record.expiration_date;
1434 p10_a11 := ddx_channel_record.access_level_type;
1435 p10_a12 := ddx_channel_record.pub_need_approval_flag;
1436 p10_a13 := ddx_channel_record.sub_need_approval_flag;
1437 p10_a14 := ddx_channel_record.match_on_all_criteria_flag;
1438 p10_a15 := ddx_channel_record.match_on_keyword_flag;
1439 p10_a16 := ddx_channel_record.match_on_author_flag;
1440 p10_a17 := ddx_channel_record.match_on_perspective_flag;
1441 p10_a18 := ddx_channel_record.match_on_item_type_flag;
1442 p10_a19 := ddx_channel_record.match_on_content_type_flag;
1443 p10_a20 := ddx_channel_record.match_on_time_flag;
1444 p10_a21 := rosetta_g_miss_num_map(ddx_channel_record.application_id);
1445 p10_a22 := ddx_channel_record.external_access_flag;
1446 p10_a23 := rosetta_g_miss_num_map(ddx_channel_record.item_match_count);
1447 p10_a24 := ddx_channel_record.last_match_time;
1448 p10_a25 := ddx_channel_record.notification_interval_type;
1449 p10_a26 := ddx_channel_record.last_notification_time;
1450 p10_a27 := ddx_channel_record.attribute_category;
1451 p10_a28 := ddx_channel_record.attribute1;
1452 p10_a29 := ddx_channel_record.attribute2;
1453 p10_a30 := ddx_channel_record.attribute3;
1454 p10_a31 := ddx_channel_record.attribute4;
1455 p10_a32 := ddx_channel_record.attribute5;
1456 p10_a33 := ddx_channel_record.attribute6;
1457 p10_a34 := ddx_channel_record.attribute7;
1458 p10_a35 := ddx_channel_record.attribute8;
1459 p10_a36 := ddx_channel_record.attribute9;
1460 p10_a37 := ddx_channel_record.attribute10;
1461 p10_a38 := ddx_channel_record.attribute11;
1462 p10_a39 := ddx_channel_record.attribute12;
1463 p10_a40 := ddx_channel_record.attribute13;
1464 p10_a41 := ddx_channel_record.attribute14;
1465 p10_a42 := ddx_channel_record.attribute15;
1466 end;
1467
1468 procedure set_channelcontenttypes(p_api_version NUMBER
1469 , p_init_msg_list VARCHAR2
1470 , p_commit VARCHAR2
1471 , p_validation_level NUMBER
1472 , x_return_status out nocopy VARCHAR2
1473 , x_msg_count out nocopy NUMBER
1474 , x_msg_data out nocopy VARCHAR2
1475 , p_check_login_user VARCHAR2
1476 , p_channel_id NUMBER
1477 , p_channel_name VARCHAR2
1478 , p_category_id NUMBER
1479 , p_content_type_id_array JTF_NUMBER_TABLE
1480 )
1481
1482 as
1483 ddp_content_type_id_array amv_channel_pvt.amv_number_varray_type;
1484 ddindx binary_integer; indx binary_integer;
1485 begin
1486
1487 -- copy data to the local IN or IN-OUT args, if any
1488
1489
1490
1491
1492
1493
1494
1495
1496
1497
1498
1499 amv_channel_pvt_w.rosetta_table_copy_in_p1(ddp_content_type_id_array, p_content_type_id_array);
1500
1501 -- here's the delegated call to the old PL/SQL routine
1502 amv_channel_pvt.set_channelcontenttypes(p_api_version,
1503 p_init_msg_list,
1504 p_commit,
1505 p_validation_level,
1506 x_return_status,
1507 x_msg_count,
1508 x_msg_data,
1509 p_check_login_user,
1510 p_channel_id,
1511 p_channel_name,
1512 p_category_id,
1513 ddp_content_type_id_array);
1514
1515 -- copy data back from the local variables to OUT or IN-OUT args, if any
1516
1517
1518
1519
1520
1521
1522
1523
1524
1525
1526
1527 end;
1528
1529 procedure get_channelcontenttypes(p_api_version NUMBER
1530 , p_init_msg_list VARCHAR2
1531 , p_validation_level NUMBER
1532 , x_return_status out nocopy VARCHAR2
1533 , x_msg_count out nocopy NUMBER
1534 , x_msg_data out nocopy VARCHAR2
1535 , p_check_login_user VARCHAR2
1536 , p_channel_id NUMBER
1537 , p_channel_name VARCHAR2
1538 , p_category_id NUMBER
1539 , x_content_type_id_array out nocopy JTF_NUMBER_TABLE
1540 )
1541
1542 as
1543 ddx_content_type_id_array amv_channel_pvt.amv_number_varray_type;
1544 ddindx binary_integer; indx binary_integer;
1545 begin
1546
1547 -- copy data to the local IN or IN-OUT args, if any
1548
1549
1550
1551
1552
1553
1554
1555
1556
1557
1558
1559 -- here's the delegated call to the old PL/SQL routine
1560 amv_channel_pvt.get_channelcontenttypes(p_api_version,
1561 p_init_msg_list,
1562 p_validation_level,
1563 x_return_status,
1564 x_msg_count,
1565 x_msg_data,
1566 p_check_login_user,
1567 p_channel_id,
1568 p_channel_name,
1569 p_category_id,
1570 ddx_content_type_id_array);
1571
1572 -- copy data back from the local variables to OUT or IN-OUT args, if any
1573
1574
1575
1576
1577
1578
1579
1580
1581
1582
1583 amv_channel_pvt_w.rosetta_table_copy_out_p1(ddx_content_type_id_array, x_content_type_id_array);
1584 end;
1585
1586 procedure set_channelperspectives(p_api_version NUMBER
1587 , p_init_msg_list VARCHAR2
1588 , p_commit VARCHAR2
1589 , p_validation_level NUMBER
1590 , x_return_status out nocopy VARCHAR2
1591 , x_msg_count out nocopy NUMBER
1592 , x_msg_data out nocopy VARCHAR2
1593 , p_check_login_user VARCHAR2
1594 , p_channel_id NUMBER
1595 , p_channel_name VARCHAR2
1596 , p_category_id NUMBER
1597 , p_perspective_id_array JTF_NUMBER_TABLE
1598 )
1599
1600 as
1601 ddp_perspective_id_array amv_channel_pvt.amv_number_varray_type;
1602 ddindx binary_integer; indx binary_integer;
1603 begin
1604
1605 -- copy data to the local IN or IN-OUT args, if any
1606
1607
1608
1609
1610
1611
1612
1613
1614
1615
1616
1617 amv_channel_pvt_w.rosetta_table_copy_in_p1(ddp_perspective_id_array, p_perspective_id_array);
1618
1619 -- here's the delegated call to the old PL/SQL routine
1620 amv_channel_pvt.set_channelperspectives(p_api_version,
1621 p_init_msg_list,
1622 p_commit,
1623 p_validation_level,
1624 x_return_status,
1625 x_msg_count,
1626 x_msg_data,
1627 p_check_login_user,
1628 p_channel_id,
1629 p_channel_name,
1630 p_category_id,
1631 ddp_perspective_id_array);
1632
1633 -- copy data back from the local variables to OUT or IN-OUT args, if any
1634
1635
1636
1637
1638
1639
1640
1641
1642
1643
1644
1645 end;
1646
1647 procedure get_channelperspectives(p_api_version NUMBER
1648 , p_init_msg_list VARCHAR2
1649 , p_validation_level NUMBER
1650 , x_return_status out nocopy VARCHAR2
1651 , x_msg_count out nocopy NUMBER
1652 , x_msg_data out nocopy VARCHAR2
1653 , p_check_login_user VARCHAR2
1654 , p_channel_id NUMBER
1655 , p_channel_name VARCHAR2
1656 , p_category_id NUMBER
1657 , x_perspective_id_array out nocopy JTF_NUMBER_TABLE
1658 )
1659
1660 as
1661 ddx_perspective_id_array amv_channel_pvt.amv_number_varray_type;
1662 ddindx binary_integer; indx binary_integer;
1663 begin
1664
1665 -- copy data to the local IN or IN-OUT args, if any
1666
1667
1668
1669
1670
1671
1672
1673
1674
1675
1676
1677 -- here's the delegated call to the old PL/SQL routine
1678 amv_channel_pvt.get_channelperspectives(p_api_version,
1679 p_init_msg_list,
1680 p_validation_level,
1681 x_return_status,
1682 x_msg_count,
1683 x_msg_data,
1684 p_check_login_user,
1685 p_channel_id,
1686 p_channel_name,
1687 p_category_id,
1688 ddx_perspective_id_array);
1689
1690 -- copy data back from the local variables to OUT or IN-OUT args, if any
1691
1692
1693
1694
1695
1696
1697
1698
1699
1700
1701 amv_channel_pvt_w.rosetta_table_copy_out_p1(ddx_perspective_id_array, x_perspective_id_array);
1702 end;
1703
1704 procedure set_channelitemtypes(p_api_version NUMBER
1705 , p_init_msg_list VARCHAR2
1706 , p_commit VARCHAR2
1707 , p_validation_level NUMBER
1708 , x_return_status out nocopy VARCHAR2
1709 , x_msg_count out nocopy NUMBER
1710 , x_msg_data out nocopy VARCHAR2
1711 , p_check_login_user VARCHAR2
1712 , p_channel_id NUMBER
1713 , p_channel_name VARCHAR2
1714 , p_category_id NUMBER
1715 , p_item_type_array JTF_VARCHAR2_TABLE_4000
1716 )
1717
1718 as
1719 ddp_item_type_array amv_channel_pvt.amv_char_varray_type;
1720 ddindx binary_integer; indx binary_integer;
1721 begin
1722
1723 -- copy data to the local IN or IN-OUT args, if any
1724
1725
1726
1727
1728
1729
1730
1731
1732
1733
1734
1735 amv_channel_pvt_w.rosetta_table_copy_in_p0(ddp_item_type_array, p_item_type_array);
1736
1737 -- here's the delegated call to the old PL/SQL routine
1738 amv_channel_pvt.set_channelitemtypes(p_api_version,
1739 p_init_msg_list,
1740 p_commit,
1741 p_validation_level,
1742 x_return_status,
1743 x_msg_count,
1744 x_msg_data,
1745 p_check_login_user,
1746 p_channel_id,
1747 p_channel_name,
1748 p_category_id,
1749 ddp_item_type_array);
1750
1751 -- copy data back from the local variables to OUT or IN-OUT args, if any
1752
1753
1754
1755
1756
1757
1758
1759
1760
1761
1762
1763 end;
1764
1765 procedure get_channelitemtypes(p_api_version NUMBER
1766 , p_init_msg_list VARCHAR2
1767 , p_validation_level NUMBER
1768 , x_return_status out nocopy VARCHAR2
1769 , x_msg_count out nocopy NUMBER
1770 , x_msg_data out nocopy VARCHAR2
1771 , p_check_login_user VARCHAR2
1772 , p_channel_id NUMBER
1773 , p_channel_name VARCHAR2
1774 , p_category_id NUMBER
1775 , x_item_type_array out nocopy JTF_VARCHAR2_TABLE_4000
1776 )
1777
1778 as
1779 ddx_item_type_array amv_channel_pvt.amv_char_varray_type;
1780 ddindx binary_integer; indx binary_integer;
1781 begin
1782
1783 -- copy data to the local IN or IN-OUT args, if any
1784
1785
1786
1787
1788
1789
1790
1791
1792
1793
1794
1795 -- here's the delegated call to the old PL/SQL routine
1796 amv_channel_pvt.get_channelitemtypes(p_api_version,
1797 p_init_msg_list,
1798 p_validation_level,
1799 x_return_status,
1800 x_msg_count,
1801 x_msg_data,
1802 p_check_login_user,
1803 p_channel_id,
1804 p_channel_name,
1805 p_category_id,
1806 ddx_item_type_array);
1807
1808 -- copy data back from the local variables to OUT or IN-OUT args, if any
1809
1810
1811
1812
1813
1814
1815
1816
1817
1818
1819 amv_channel_pvt_w.rosetta_table_copy_out_p0(ddx_item_type_array, x_item_type_array);
1820 end;
1821
1822 procedure set_channelkeywords(p_api_version NUMBER
1823 , p_init_msg_list VARCHAR2
1824 , p_commit VARCHAR2
1825 , p_validation_level NUMBER
1826 , x_return_status out nocopy VARCHAR2
1827 , x_msg_count out nocopy NUMBER
1828 , x_msg_data out nocopy VARCHAR2
1829 , p_check_login_user VARCHAR2
1830 , p_channel_id NUMBER
1831 , p_channel_name VARCHAR2
1832 , p_category_id NUMBER
1833 , p_keywords_array JTF_VARCHAR2_TABLE_4000
1834 )
1835
1836 as
1837 ddp_keywords_array amv_channel_pvt.amv_char_varray_type;
1838 ddindx binary_integer; indx binary_integer;
1839 begin
1840
1841 -- copy data to the local IN or IN-OUT args, if any
1842
1843
1844
1845
1846
1847
1848
1849
1850
1851
1852
1853 amv_channel_pvt_w.rosetta_table_copy_in_p0(ddp_keywords_array, p_keywords_array);
1854
1855 -- here's the delegated call to the old PL/SQL routine
1856 amv_channel_pvt.set_channelkeywords(p_api_version,
1857 p_init_msg_list,
1858 p_commit,
1859 p_validation_level,
1860 x_return_status,
1861 x_msg_count,
1862 x_msg_data,
1863 p_check_login_user,
1864 p_channel_id,
1865 p_channel_name,
1866 p_category_id,
1867 ddp_keywords_array);
1868
1869 -- copy data back from the local variables to OUT or IN-OUT args, if any
1870
1871
1872
1873
1874
1875
1876
1877
1878
1879
1880
1881 end;
1882
1883 procedure get_channelkeywords(p_api_version NUMBER
1884 , p_init_msg_list VARCHAR2
1885 , p_validation_level NUMBER
1886 , x_return_status out nocopy VARCHAR2
1887 , x_msg_count out nocopy NUMBER
1888 , x_msg_data out nocopy VARCHAR2
1889 , p_check_login_user VARCHAR2
1890 , p_channel_id NUMBER
1891 , p_channel_name VARCHAR2
1892 , p_category_id NUMBER
1893 , x_keywords_array out nocopy JTF_VARCHAR2_TABLE_4000
1894 )
1895
1896 as
1897 ddx_keywords_array amv_channel_pvt.amv_char_varray_type;
1898 ddindx binary_integer; indx binary_integer;
1899 begin
1900
1901 -- copy data to the local IN or IN-OUT args, if any
1902
1903
1904
1905
1906
1907
1908
1909
1910
1911
1912
1913 -- here's the delegated call to the old PL/SQL routine
1914 amv_channel_pvt.get_channelkeywords(p_api_version,
1915 p_init_msg_list,
1916 p_validation_level,
1917 x_return_status,
1918 x_msg_count,
1919 x_msg_data,
1920 p_check_login_user,
1921 p_channel_id,
1922 p_channel_name,
1923 p_category_id,
1924 ddx_keywords_array);
1925
1926 -- copy data back from the local variables to OUT or IN-OUT args, if any
1927
1928
1929
1930
1931
1932
1933
1934
1935
1936
1937 amv_channel_pvt_w.rosetta_table_copy_out_p0(ddx_keywords_array, x_keywords_array);
1938 end;
1939
1940 procedure set_channelauthors(p_api_version NUMBER
1941 , p_init_msg_list VARCHAR2
1942 , p_commit VARCHAR2
1943 , p_validation_level NUMBER
1944 , x_return_status out nocopy VARCHAR2
1945 , x_msg_count out nocopy NUMBER
1946 , x_msg_data out nocopy VARCHAR2
1947 , p_check_login_user VARCHAR2
1948 , p_channel_id NUMBER
1949 , p_channel_name VARCHAR2
1950 , p_category_id NUMBER
1951 , p_authors_array JTF_VARCHAR2_TABLE_4000
1952 )
1953
1954 as
1955 ddp_authors_array amv_channel_pvt.amv_char_varray_type;
1956 ddindx binary_integer; indx binary_integer;
1957 begin
1958
1959 -- copy data to the local IN or IN-OUT args, if any
1960
1961
1962
1963
1964
1965
1966
1967
1968
1969
1970
1971 amv_channel_pvt_w.rosetta_table_copy_in_p0(ddp_authors_array, p_authors_array);
1972
1973 -- here's the delegated call to the old PL/SQL routine
1974 amv_channel_pvt.set_channelauthors(p_api_version,
1975 p_init_msg_list,
1976 p_commit,
1977 p_validation_level,
1978 x_return_status,
1979 x_msg_count,
1980 x_msg_data,
1981 p_check_login_user,
1982 p_channel_id,
1983 p_channel_name,
1984 p_category_id,
1985 ddp_authors_array);
1986
1987 -- copy data back from the local variables to OUT or IN-OUT args, if any
1988
1989
1990
1991
1992
1993
1994
1995
1996
1997
1998
1999 end;
2000
2001 procedure get_channelauthors(p_api_version NUMBER
2002 , p_init_msg_list VARCHAR2
2003 , p_validation_level NUMBER
2004 , x_return_status out nocopy VARCHAR2
2005 , x_msg_count out nocopy NUMBER
2006 , x_msg_data out nocopy VARCHAR2
2007 , p_check_login_user VARCHAR2
2008 , p_channel_id NUMBER
2009 , p_channel_name VARCHAR2
2010 , p_category_id NUMBER
2011 , x_authors_array out nocopy JTF_VARCHAR2_TABLE_4000
2012 )
2013
2014 as
2015 ddx_authors_array amv_channel_pvt.amv_char_varray_type;
2016 ddindx binary_integer; indx binary_integer;
2017 begin
2018
2019 -- copy data to the local IN or IN-OUT args, if any
2020
2021
2022
2023
2024
2025
2026
2027
2028
2029
2030
2031 -- here's the delegated call to the old PL/SQL routine
2032 amv_channel_pvt.get_channelauthors(p_api_version,
2033 p_init_msg_list,
2034 p_validation_level,
2035 x_return_status,
2036 x_msg_count,
2037 x_msg_data,
2038 p_check_login_user,
2039 p_channel_id,
2040 p_channel_name,
2041 p_category_id,
2042 ddx_authors_array);
2043
2044 -- copy data back from the local variables to OUT or IN-OUT args, if any
2045
2046
2047
2048
2049
2050
2051
2052
2053
2054
2055 amv_channel_pvt_w.rosetta_table_copy_out_p0(ddx_authors_array, x_authors_array);
2056 end;
2057
2058 procedure get_itemsperchannel(p_api_version NUMBER
2059 , p_init_msg_list VARCHAR2
2060 , p_validation_level NUMBER
2061 , x_return_status out nocopy VARCHAR2
2062 , x_msg_count out nocopy NUMBER
2063 , x_msg_data out nocopy VARCHAR2
2064 , p_check_login_user VARCHAR2
2065 , p_channel_id NUMBER
2066 , p_channel_name VARCHAR2
2067 , p_category_id NUMBER
2068 , p_item_status VARCHAR2
2069 , p12_a0 out nocopy NUMBER
2070 , p12_a1 out nocopy NUMBER
2071 , p12_a2 out nocopy NUMBER
2072 , x_document_id_array out nocopy JTF_NUMBER_TABLE
2073 , p11_a0 NUMBER := 0-1962.0724
2074 , p11_a1 NUMBER := 0-1962.0724
2075 , p11_a2 VARCHAR2 := fnd_api.g_miss_char
2076 )
2077
2078 as
2079 ddp_subset_request_rec amv_channel_pvt.amv_request_obj_type;
2080 ddx_subset_return_rec amv_channel_pvt.amv_return_obj_type;
2081 ddx_document_id_array amv_channel_pvt.amv_number_varray_type;
2082 ddindx binary_integer; indx binary_integer;
2083 begin
2084
2085 -- copy data to the local IN or IN-OUT args, if any
2086
2087
2088
2089
2090
2091
2092
2093
2094
2095
2096
2097 ddp_subset_request_rec.records_requested := rosetta_g_miss_num_map(p11_a0);
2098 ddp_subset_request_rec.start_record_position := rosetta_g_miss_num_map(p11_a1);
2099 ddp_subset_request_rec.return_total_count_flag := p11_a2;
2100
2101
2102
2103 -- here's the delegated call to the old PL/SQL routine
2104 amv_channel_pvt.get_itemsperchannel(p_api_version,
2105 p_init_msg_list,
2106 p_validation_level,
2107 x_return_status,
2108 x_msg_count,
2109 x_msg_data,
2110 p_check_login_user,
2111 p_channel_id,
2112 p_channel_name,
2113 p_category_id,
2114 p_item_status,
2115 ddp_subset_request_rec,
2116 ddx_subset_return_rec,
2117 ddx_document_id_array);
2118
2119 -- copy data back from the local variables to OUT or IN-OUT args, if any
2120
2121
2122
2123
2124
2125
2126
2127
2128
2129
2130
2131
2132 p12_a0 := rosetta_g_miss_num_map(ddx_subset_return_rec.returned_record_count);
2133 p12_a1 := rosetta_g_miss_num_map(ddx_subset_return_rec.next_record_position);
2134 p12_a2 := rosetta_g_miss_num_map(ddx_subset_return_rec.total_record_count);
2135
2136 amv_channel_pvt_w.rosetta_table_copy_out_p1(ddx_document_id_array, x_document_id_array);
2137 end;
2138
2139 procedure find_channels(p_api_version NUMBER
2140 , p_init_msg_list VARCHAR2
2141 , p_validation_level NUMBER
2142 , x_return_status out nocopy VARCHAR2
2143 , x_msg_count out nocopy NUMBER
2144 , x_msg_data out nocopy VARCHAR2
2145 , p_check_login_user VARCHAR2
2146 , p_sort_by VARCHAR2
2147 , p10_a0 out nocopy NUMBER
2148 , p10_a1 out nocopy NUMBER
2149 , p10_a2 out nocopy NUMBER
2150 , p11_a0 out nocopy JTF_NUMBER_TABLE
2151 , p11_a1 out nocopy JTF_NUMBER_TABLE
2152 , p11_a2 out nocopy JTF_VARCHAR2_TABLE_100
2153 , p11_a3 out nocopy JTF_VARCHAR2_TABLE_2000
2154 , p11_a4 out nocopy JTF_VARCHAR2_TABLE_100
2155 , p11_a5 out nocopy JTF_NUMBER_TABLE
2156 , p11_a6 out nocopy JTF_VARCHAR2_TABLE_100
2157 , p11_a7 out nocopy JTF_NUMBER_TABLE
2158 , p11_a8 out nocopy JTF_NUMBER_TABLE
2159 , p11_a9 out nocopy JTF_DATE_TABLE
2160 , p11_a10 out nocopy JTF_DATE_TABLE
2161 , p11_a11 out nocopy JTF_VARCHAR2_TABLE_100
2162 , p11_a12 out nocopy JTF_VARCHAR2_TABLE_100
2163 , p11_a13 out nocopy JTF_VARCHAR2_TABLE_100
2164 , p11_a14 out nocopy JTF_VARCHAR2_TABLE_100
2165 , p11_a15 out nocopy JTF_VARCHAR2_TABLE_100
2166 , p11_a16 out nocopy JTF_VARCHAR2_TABLE_100
2167 , p11_a17 out nocopy JTF_VARCHAR2_TABLE_100
2168 , p11_a18 out nocopy JTF_VARCHAR2_TABLE_100
2169 , p11_a19 out nocopy JTF_VARCHAR2_TABLE_100
2170 , p11_a20 out nocopy JTF_VARCHAR2_TABLE_100
2171 , p11_a21 out nocopy JTF_NUMBER_TABLE
2172 , p11_a22 out nocopy JTF_VARCHAR2_TABLE_100
2173 , p11_a23 out nocopy JTF_NUMBER_TABLE
2174 , p11_a24 out nocopy JTF_DATE_TABLE
2175 , p11_a25 out nocopy JTF_VARCHAR2_TABLE_100
2176 , p11_a26 out nocopy JTF_DATE_TABLE
2177 , p11_a27 out nocopy JTF_VARCHAR2_TABLE_100
2178 , p11_a28 out nocopy JTF_VARCHAR2_TABLE_200
2179 , p11_a29 out nocopy JTF_VARCHAR2_TABLE_200
2180 , p11_a30 out nocopy JTF_VARCHAR2_TABLE_200
2181 , p11_a31 out nocopy JTF_VARCHAR2_TABLE_200
2182 , p11_a32 out nocopy JTF_VARCHAR2_TABLE_200
2183 , p11_a33 out nocopy JTF_VARCHAR2_TABLE_200
2184 , p11_a34 out nocopy JTF_VARCHAR2_TABLE_200
2185 , p11_a35 out nocopy JTF_VARCHAR2_TABLE_200
2186 , p11_a36 out nocopy JTF_VARCHAR2_TABLE_200
2187 , p11_a37 out nocopy JTF_VARCHAR2_TABLE_200
2188 , p11_a38 out nocopy JTF_VARCHAR2_TABLE_200
2189 , p11_a39 out nocopy JTF_VARCHAR2_TABLE_200
2190 , p11_a40 out nocopy JTF_VARCHAR2_TABLE_200
2191 , p11_a41 out nocopy JTF_VARCHAR2_TABLE_200
2192 , p11_a42 out nocopy JTF_VARCHAR2_TABLE_200
2193 , p7_a0 NUMBER := 0-1962.0724
2194 , p7_a1 NUMBER := 0-1962.0724
2195 , p7_a2 VARCHAR2 := fnd_api.g_miss_char
2196 , p7_a3 VARCHAR2 := fnd_api.g_miss_char
2197 , p7_a4 VARCHAR2 := fnd_api.g_miss_char
2198 , p7_a5 NUMBER := 0-1962.0724
2199 , p7_a6 VARCHAR2 := fnd_api.g_miss_char
2200 , p7_a7 NUMBER := 0-1962.0724
2201 , p7_a8 NUMBER := 0-1962.0724
2202 , p7_a9 DATE := fnd_api.g_miss_date
2203 , p7_a10 DATE := fnd_api.g_miss_date
2204 , p7_a11 VARCHAR2 := fnd_api.g_miss_char
2205 , p7_a12 VARCHAR2 := fnd_api.g_miss_char
2206 , p7_a13 VARCHAR2 := fnd_api.g_miss_char
2207 , p7_a14 VARCHAR2 := fnd_api.g_miss_char
2208 , p7_a15 VARCHAR2 := fnd_api.g_miss_char
2209 , p7_a16 VARCHAR2 := fnd_api.g_miss_char
2210 , p7_a17 VARCHAR2 := fnd_api.g_miss_char
2211 , p7_a18 VARCHAR2 := fnd_api.g_miss_char
2212 , p7_a19 VARCHAR2 := fnd_api.g_miss_char
2213 , p7_a20 VARCHAR2 := fnd_api.g_miss_char
2214 , p7_a21 NUMBER := 0-1962.0724
2215 , p7_a22 VARCHAR2 := fnd_api.g_miss_char
2216 , p7_a23 NUMBER := 0-1962.0724
2217 , p7_a24 DATE := fnd_api.g_miss_date
2218 , p7_a25 VARCHAR2 := fnd_api.g_miss_char
2219 , p7_a26 DATE := fnd_api.g_miss_date
2220 , p7_a27 VARCHAR2 := fnd_api.g_miss_char
2221 , p7_a28 VARCHAR2 := fnd_api.g_miss_char
2222 , p7_a29 VARCHAR2 := fnd_api.g_miss_char
2223 , p7_a30 VARCHAR2 := fnd_api.g_miss_char
2224 , p7_a31 VARCHAR2 := fnd_api.g_miss_char
2225 , p7_a32 VARCHAR2 := fnd_api.g_miss_char
2226 , p7_a33 VARCHAR2 := fnd_api.g_miss_char
2227 , p7_a34 VARCHAR2 := fnd_api.g_miss_char
2228 , p7_a35 VARCHAR2 := fnd_api.g_miss_char
2229 , p7_a36 VARCHAR2 := fnd_api.g_miss_char
2230 , p7_a37 VARCHAR2 := fnd_api.g_miss_char
2231 , p7_a38 VARCHAR2 := fnd_api.g_miss_char
2232 , p7_a39 VARCHAR2 := fnd_api.g_miss_char
2233 , p7_a40 VARCHAR2 := fnd_api.g_miss_char
2234 , p7_a41 VARCHAR2 := fnd_api.g_miss_char
2235 , p7_a42 VARCHAR2 := fnd_api.g_miss_char
2236 , p9_a0 NUMBER := 0-1962.0724
2237 , p9_a1 NUMBER := 0-1962.0724
2238 , p9_a2 VARCHAR2 := fnd_api.g_miss_char
2239 )
2240
2241 as
2242 ddp_criteria_rec amv_channel_pvt.amv_channel_obj_type;
2243 ddp_subset_request_rec amv_channel_pvt.amv_request_obj_type;
2244 ddx_subset_return_rec amv_channel_pvt.amv_return_obj_type;
2245 ddx_content_chan_array amv_channel_pvt.amv_channel_varray_type;
2246 ddindx binary_integer; indx binary_integer;
2247 begin
2248
2249 -- copy data to the local IN or IN-OUT args, if any
2250
2251
2252
2253
2254
2255
2256
2257 ddp_criteria_rec.channel_id := rosetta_g_miss_num_map(p7_a0);
2258 ddp_criteria_rec.object_version_number := rosetta_g_miss_num_map(p7_a1);
2259 ddp_criteria_rec.channel_name := p7_a2;
2260 ddp_criteria_rec.description := p7_a3;
2261 ddp_criteria_rec.channel_type := p7_a4;
2262 ddp_criteria_rec.channel_category_id := rosetta_g_miss_num_map(p7_a5);
2263 ddp_criteria_rec.status := p7_a6;
2264 ddp_criteria_rec.owner_user_id := rosetta_g_miss_num_map(p7_a7);
2265 ddp_criteria_rec.default_approver_user_id := rosetta_g_miss_num_map(p7_a8);
2266 ddp_criteria_rec.effective_start_date := rosetta_g_miss_date_in_map(p7_a9);
2267 ddp_criteria_rec.expiration_date := rosetta_g_miss_date_in_map(p7_a10);
2268 ddp_criteria_rec.access_level_type := p7_a11;
2269 ddp_criteria_rec.pub_need_approval_flag := p7_a12;
2270 ddp_criteria_rec.sub_need_approval_flag := p7_a13;
2271 ddp_criteria_rec.match_on_all_criteria_flag := p7_a14;
2272 ddp_criteria_rec.match_on_keyword_flag := p7_a15;
2273 ddp_criteria_rec.match_on_author_flag := p7_a16;
2274 ddp_criteria_rec.match_on_perspective_flag := p7_a17;
2275 ddp_criteria_rec.match_on_item_type_flag := p7_a18;
2276 ddp_criteria_rec.match_on_content_type_flag := p7_a19;
2277 ddp_criteria_rec.match_on_time_flag := p7_a20;
2278 ddp_criteria_rec.application_id := rosetta_g_miss_num_map(p7_a21);
2279 ddp_criteria_rec.external_access_flag := p7_a22;
2280 ddp_criteria_rec.item_match_count := rosetta_g_miss_num_map(p7_a23);
2281 ddp_criteria_rec.last_match_time := rosetta_g_miss_date_in_map(p7_a24);
2282 ddp_criteria_rec.notification_interval_type := p7_a25;
2283 ddp_criteria_rec.last_notification_time := rosetta_g_miss_date_in_map(p7_a26);
2284 ddp_criteria_rec.attribute_category := p7_a27;
2285 ddp_criteria_rec.attribute1 := p7_a28;
2286 ddp_criteria_rec.attribute2 := p7_a29;
2287 ddp_criteria_rec.attribute3 := p7_a30;
2288 ddp_criteria_rec.attribute4 := p7_a31;
2289 ddp_criteria_rec.attribute5 := p7_a32;
2290 ddp_criteria_rec.attribute6 := p7_a33;
2291 ddp_criteria_rec.attribute7 := p7_a34;
2292 ddp_criteria_rec.attribute8 := p7_a35;
2293 ddp_criteria_rec.attribute9 := p7_a36;
2294 ddp_criteria_rec.attribute10 := p7_a37;
2295 ddp_criteria_rec.attribute11 := p7_a38;
2296 ddp_criteria_rec.attribute12 := p7_a39;
2297 ddp_criteria_rec.attribute13 := p7_a40;
2298 ddp_criteria_rec.attribute14 := p7_a41;
2299 ddp_criteria_rec.attribute15 := p7_a42;
2300
2301
2302 ddp_subset_request_rec.records_requested := rosetta_g_miss_num_map(p9_a0);
2303 ddp_subset_request_rec.start_record_position := rosetta_g_miss_num_map(p9_a1);
2304 ddp_subset_request_rec.return_total_count_flag := p9_a2;
2305
2306
2307
2308 -- here's the delegated call to the old PL/SQL routine
2309 amv_channel_pvt.find_channels(p_api_version,
2310 p_init_msg_list,
2311 p_validation_level,
2312 x_return_status,
2313 x_msg_count,
2314 x_msg_data,
2315 p_check_login_user,
2316 ddp_criteria_rec,
2317 p_sort_by,
2318 ddp_subset_request_rec,
2319 ddx_subset_return_rec,
2320 ddx_content_chan_array);
2321
2322 -- copy data back from the local variables to OUT or IN-OUT args, if any
2323
2324
2325
2326
2327
2328
2329
2330
2331
2332
2333 p10_a0 := rosetta_g_miss_num_map(ddx_subset_return_rec.returned_record_count);
2334 p10_a1 := rosetta_g_miss_num_map(ddx_subset_return_rec.next_record_position);
2335 p10_a2 := rosetta_g_miss_num_map(ddx_subset_return_rec.total_record_count);
2336
2337 amv_channel_pvt_w.rosetta_table_copy_out_p5(ddx_content_chan_array, p11_a0
2338 , p11_a1
2339 , p11_a2
2340 , p11_a3
2341 , p11_a4
2342 , p11_a5
2343 , p11_a6
2344 , p11_a7
2345 , p11_a8
2346 , p11_a9
2347 , p11_a10
2348 , p11_a11
2349 , p11_a12
2350 , p11_a13
2351 , p11_a14
2352 , p11_a15
2353 , p11_a16
2354 , p11_a17
2355 , p11_a18
2356 , p11_a19
2357 , p11_a20
2358 , p11_a21
2359 , p11_a22
2360 , p11_a23
2361 , p11_a24
2362 , p11_a25
2363 , p11_a26
2364 , p11_a27
2365 , p11_a28
2366 , p11_a29
2367 , p11_a30
2368 , p11_a31
2369 , p11_a32
2370 , p11_a33
2371 , p11_a34
2372 , p11_a35
2373 , p11_a36
2374 , p11_a37
2375 , p11_a38
2376 , p11_a39
2377 , p11_a40
2378 , p11_a41
2379 , p11_a42
2380 );
2381 end;
2382
2383 end amv_channel_pvt_w;