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;
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;
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);
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;
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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();
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();
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();
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();
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();
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();
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();
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();
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();
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();
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();
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();
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();
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();
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;
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;
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;
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;
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: )
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
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
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
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
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
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
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