2: /* $Header: amvwchas.pls 120.2 2005/06/30 07:50 appldev ship $ */
3: procedure rosetta_table_copy_in_p0(t out nocopy amv_channel_pvt.amv_char_varray_type, a0 JTF_VARCHAR2_TABLE_4000);
4: procedure rosetta_table_copy_out_p0(t amv_channel_pvt.amv_char_varray_type, a0 out nocopy JTF_VARCHAR2_TABLE_4000);
5:
6: procedure rosetta_table_copy_in_p1(t out nocopy amv_channel_pvt.amv_number_varray_type, a0 JTF_NUMBER_TABLE);
7: procedure rosetta_table_copy_out_p1(t amv_channel_pvt.amv_number_varray_type, a0 out nocopy JTF_NUMBER_TABLE);
8:
9: procedure rosetta_table_copy_in_p5(t out nocopy amv_channel_pvt.amv_channel_varray_type, a0 JTF_NUMBER_TABLE
10: , a1 JTF_NUMBER_TABLE
3: procedure rosetta_table_copy_in_p0(t out nocopy amv_channel_pvt.amv_char_varray_type, a0 JTF_VARCHAR2_TABLE_4000);
4: procedure rosetta_table_copy_out_p0(t amv_channel_pvt.amv_char_varray_type, a0 out nocopy JTF_VARCHAR2_TABLE_4000);
5:
6: procedure rosetta_table_copy_in_p1(t out nocopy amv_channel_pvt.amv_number_varray_type, a0 JTF_NUMBER_TABLE);
7: procedure rosetta_table_copy_out_p1(t amv_channel_pvt.amv_number_varray_type, a0 out nocopy JTF_NUMBER_TABLE);
8:
9: procedure rosetta_table_copy_in_p5(t out nocopy amv_channel_pvt.amv_channel_varray_type, a0 JTF_NUMBER_TABLE
10: , a1 JTF_NUMBER_TABLE
11: , a2 JTF_VARCHAR2_TABLE_100
5:
6: procedure rosetta_table_copy_in_p1(t out nocopy amv_channel_pvt.amv_number_varray_type, a0 JTF_NUMBER_TABLE);
7: procedure rosetta_table_copy_out_p1(t amv_channel_pvt.amv_number_varray_type, a0 out nocopy JTF_NUMBER_TABLE);
8:
9: procedure rosetta_table_copy_in_p5(t out nocopy amv_channel_pvt.amv_channel_varray_type, a0 JTF_NUMBER_TABLE
10: , a1 JTF_NUMBER_TABLE
11: , a2 JTF_VARCHAR2_TABLE_100
12: , a3 JTF_VARCHAR2_TABLE_2000
13: , a4 JTF_VARCHAR2_TABLE_100
6: procedure rosetta_table_copy_in_p1(t out nocopy amv_channel_pvt.amv_number_varray_type, a0 JTF_NUMBER_TABLE);
7: procedure rosetta_table_copy_out_p1(t amv_channel_pvt.amv_number_varray_type, a0 out nocopy JTF_NUMBER_TABLE);
8:
9: procedure rosetta_table_copy_in_p5(t out nocopy amv_channel_pvt.amv_channel_varray_type, a0 JTF_NUMBER_TABLE
10: , a1 JTF_NUMBER_TABLE
11: , a2 JTF_VARCHAR2_TABLE_100
12: , a3 JTF_VARCHAR2_TABLE_2000
13: , a4 JTF_VARCHAR2_TABLE_100
14: , a5 JTF_NUMBER_TABLE
10: , a1 JTF_NUMBER_TABLE
11: , a2 JTF_VARCHAR2_TABLE_100
12: , a3 JTF_VARCHAR2_TABLE_2000
13: , a4 JTF_VARCHAR2_TABLE_100
14: , a5 JTF_NUMBER_TABLE
15: , a6 JTF_VARCHAR2_TABLE_100
16: , a7 JTF_NUMBER_TABLE
17: , a8 JTF_NUMBER_TABLE
18: , a9 JTF_DATE_TABLE
12: , a3 JTF_VARCHAR2_TABLE_2000
13: , a4 JTF_VARCHAR2_TABLE_100
14: , a5 JTF_NUMBER_TABLE
15: , a6 JTF_VARCHAR2_TABLE_100
16: , a7 JTF_NUMBER_TABLE
17: , a8 JTF_NUMBER_TABLE
18: , a9 JTF_DATE_TABLE
19: , a10 JTF_DATE_TABLE
20: , a11 JTF_VARCHAR2_TABLE_100
13: , a4 JTF_VARCHAR2_TABLE_100
14: , a5 JTF_NUMBER_TABLE
15: , a6 JTF_VARCHAR2_TABLE_100
16: , a7 JTF_NUMBER_TABLE
17: , a8 JTF_NUMBER_TABLE
18: , a9 JTF_DATE_TABLE
19: , a10 JTF_DATE_TABLE
20: , a11 JTF_VARCHAR2_TABLE_100
21: , a12 JTF_VARCHAR2_TABLE_100
26: , a17 JTF_VARCHAR2_TABLE_100
27: , a18 JTF_VARCHAR2_TABLE_100
28: , a19 JTF_VARCHAR2_TABLE_100
29: , a20 JTF_VARCHAR2_TABLE_100
30: , a21 JTF_NUMBER_TABLE
31: , a22 JTF_VARCHAR2_TABLE_100
32: , a23 JTF_NUMBER_TABLE
33: , a24 JTF_DATE_TABLE
34: , a25 JTF_VARCHAR2_TABLE_100
28: , a19 JTF_VARCHAR2_TABLE_100
29: , a20 JTF_VARCHAR2_TABLE_100
30: , a21 JTF_NUMBER_TABLE
31: , a22 JTF_VARCHAR2_TABLE_100
32: , a23 JTF_NUMBER_TABLE
33: , a24 JTF_DATE_TABLE
34: , a25 JTF_VARCHAR2_TABLE_100
35: , a26 JTF_DATE_TABLE
36: , a27 JTF_VARCHAR2_TABLE_100
49: , a40 JTF_VARCHAR2_TABLE_200
50: , a41 JTF_VARCHAR2_TABLE_200
51: , a42 JTF_VARCHAR2_TABLE_200
52: );
53: procedure rosetta_table_copy_out_p5(t amv_channel_pvt.amv_channel_varray_type, a0 out nocopy JTF_NUMBER_TABLE
54: , a1 out nocopy JTF_NUMBER_TABLE
55: , a2 out nocopy JTF_VARCHAR2_TABLE_100
56: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
57: , a4 out nocopy JTF_VARCHAR2_TABLE_100
50: , a41 JTF_VARCHAR2_TABLE_200
51: , a42 JTF_VARCHAR2_TABLE_200
52: );
53: procedure rosetta_table_copy_out_p5(t amv_channel_pvt.amv_channel_varray_type, a0 out nocopy JTF_NUMBER_TABLE
54: , a1 out nocopy JTF_NUMBER_TABLE
55: , a2 out nocopy JTF_VARCHAR2_TABLE_100
56: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
57: , a4 out nocopy JTF_VARCHAR2_TABLE_100
58: , a5 out nocopy JTF_NUMBER_TABLE
54: , a1 out nocopy JTF_NUMBER_TABLE
55: , a2 out nocopy JTF_VARCHAR2_TABLE_100
56: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
57: , a4 out nocopy JTF_VARCHAR2_TABLE_100
58: , a5 out nocopy JTF_NUMBER_TABLE
59: , a6 out nocopy JTF_VARCHAR2_TABLE_100
60: , a7 out nocopy JTF_NUMBER_TABLE
61: , a8 out nocopy JTF_NUMBER_TABLE
62: , a9 out nocopy JTF_DATE_TABLE
56: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
57: , a4 out nocopy JTF_VARCHAR2_TABLE_100
58: , a5 out nocopy JTF_NUMBER_TABLE
59: , a6 out nocopy JTF_VARCHAR2_TABLE_100
60: , a7 out nocopy JTF_NUMBER_TABLE
61: , a8 out nocopy JTF_NUMBER_TABLE
62: , a9 out nocopy JTF_DATE_TABLE
63: , a10 out nocopy JTF_DATE_TABLE
64: , a11 out nocopy JTF_VARCHAR2_TABLE_100
57: , a4 out nocopy JTF_VARCHAR2_TABLE_100
58: , a5 out nocopy JTF_NUMBER_TABLE
59: , a6 out nocopy JTF_VARCHAR2_TABLE_100
60: , a7 out nocopy JTF_NUMBER_TABLE
61: , a8 out nocopy JTF_NUMBER_TABLE
62: , a9 out nocopy JTF_DATE_TABLE
63: , a10 out nocopy JTF_DATE_TABLE
64: , a11 out nocopy JTF_VARCHAR2_TABLE_100
65: , a12 out nocopy JTF_VARCHAR2_TABLE_100
70: , a17 out nocopy JTF_VARCHAR2_TABLE_100
71: , a18 out nocopy JTF_VARCHAR2_TABLE_100
72: , a19 out nocopy JTF_VARCHAR2_TABLE_100
73: , a20 out nocopy JTF_VARCHAR2_TABLE_100
74: , a21 out nocopy JTF_NUMBER_TABLE
75: , a22 out nocopy JTF_VARCHAR2_TABLE_100
76: , a23 out nocopy JTF_NUMBER_TABLE
77: , a24 out nocopy JTF_DATE_TABLE
78: , a25 out nocopy JTF_VARCHAR2_TABLE_100
72: , a19 out nocopy JTF_VARCHAR2_TABLE_100
73: , a20 out nocopy JTF_VARCHAR2_TABLE_100
74: , a21 out nocopy JTF_NUMBER_TABLE
75: , a22 out nocopy JTF_VARCHAR2_TABLE_100
76: , a23 out nocopy JTF_NUMBER_TABLE
77: , a24 out nocopy JTF_DATE_TABLE
78: , a25 out nocopy JTF_VARCHAR2_TABLE_100
79: , a26 out nocopy JTF_DATE_TABLE
80: , a27 out nocopy JTF_VARCHAR2_TABLE_100
477: , p_check_login_user VARCHAR2
478: , p_channel_id NUMBER
479: , p_channel_name VARCHAR2
480: , p_category_id NUMBER
481: , p_content_type_id_array JTF_NUMBER_TABLE
482: );
483: procedure get_channelcontenttypes(p_api_version NUMBER
484: , p_init_msg_list VARCHAR2
485: , p_validation_level NUMBER
489: , p_check_login_user VARCHAR2
490: , p_channel_id NUMBER
491: , p_channel_name VARCHAR2
492: , p_category_id NUMBER
493: , x_content_type_id_array out nocopy JTF_NUMBER_TABLE
494: );
495: procedure set_channelperspectives(p_api_version NUMBER
496: , p_init_msg_list VARCHAR2
497: , p_commit VARCHAR2
502: , p_check_login_user VARCHAR2
503: , p_channel_id NUMBER
504: , p_channel_name VARCHAR2
505: , p_category_id NUMBER
506: , p_perspective_id_array JTF_NUMBER_TABLE
507: );
508: procedure get_channelperspectives(p_api_version NUMBER
509: , p_init_msg_list VARCHAR2
510: , p_validation_level NUMBER
514: , p_check_login_user VARCHAR2
515: , p_channel_id NUMBER
516: , p_channel_name VARCHAR2
517: , p_category_id NUMBER
518: , x_perspective_id_array out nocopy JTF_NUMBER_TABLE
519: );
520: procedure set_channelitemtypes(p_api_version NUMBER
521: , p_init_msg_list VARCHAR2
522: , p_commit VARCHAR2
605: , p_item_status VARCHAR2
606: , p12_a0 out nocopy NUMBER
607: , p12_a1 out nocopy NUMBER
608: , p12_a2 out nocopy NUMBER
609: , x_document_id_array out nocopy JTF_NUMBER_TABLE
610: , p11_a0 NUMBER := 0-1962.0724
611: , p11_a1 NUMBER := 0-1962.0724
612: , p11_a2 VARCHAR2 := fnd_api.g_miss_char
613: );
621: , p_sort_by VARCHAR2
622: , p10_a0 out nocopy NUMBER
623: , p10_a1 out nocopy NUMBER
624: , p10_a2 out nocopy NUMBER
625: , p11_a0 out nocopy JTF_NUMBER_TABLE
626: , p11_a1 out nocopy JTF_NUMBER_TABLE
627: , p11_a2 out nocopy JTF_VARCHAR2_TABLE_100
628: , p11_a3 out nocopy JTF_VARCHAR2_TABLE_2000
629: , p11_a4 out nocopy JTF_VARCHAR2_TABLE_100
622: , p10_a0 out nocopy NUMBER
623: , p10_a1 out nocopy NUMBER
624: , p10_a2 out nocopy NUMBER
625: , p11_a0 out nocopy JTF_NUMBER_TABLE
626: , p11_a1 out nocopy JTF_NUMBER_TABLE
627: , p11_a2 out nocopy JTF_VARCHAR2_TABLE_100
628: , p11_a3 out nocopy JTF_VARCHAR2_TABLE_2000
629: , p11_a4 out nocopy JTF_VARCHAR2_TABLE_100
630: , p11_a5 out nocopy JTF_NUMBER_TABLE
626: , p11_a1 out nocopy JTF_NUMBER_TABLE
627: , p11_a2 out nocopy JTF_VARCHAR2_TABLE_100
628: , p11_a3 out nocopy JTF_VARCHAR2_TABLE_2000
629: , p11_a4 out nocopy JTF_VARCHAR2_TABLE_100
630: , p11_a5 out nocopy JTF_NUMBER_TABLE
631: , p11_a6 out nocopy JTF_VARCHAR2_TABLE_100
632: , p11_a7 out nocopy JTF_NUMBER_TABLE
633: , p11_a8 out nocopy JTF_NUMBER_TABLE
634: , p11_a9 out nocopy JTF_DATE_TABLE
628: , p11_a3 out nocopy JTF_VARCHAR2_TABLE_2000
629: , p11_a4 out nocopy JTF_VARCHAR2_TABLE_100
630: , p11_a5 out nocopy JTF_NUMBER_TABLE
631: , p11_a6 out nocopy JTF_VARCHAR2_TABLE_100
632: , p11_a7 out nocopy JTF_NUMBER_TABLE
633: , p11_a8 out nocopy JTF_NUMBER_TABLE
634: , p11_a9 out nocopy JTF_DATE_TABLE
635: , p11_a10 out nocopy JTF_DATE_TABLE
636: , p11_a11 out nocopy JTF_VARCHAR2_TABLE_100
629: , p11_a4 out nocopy JTF_VARCHAR2_TABLE_100
630: , p11_a5 out nocopy JTF_NUMBER_TABLE
631: , p11_a6 out nocopy JTF_VARCHAR2_TABLE_100
632: , p11_a7 out nocopy JTF_NUMBER_TABLE
633: , p11_a8 out nocopy JTF_NUMBER_TABLE
634: , p11_a9 out nocopy JTF_DATE_TABLE
635: , p11_a10 out nocopy JTF_DATE_TABLE
636: , p11_a11 out nocopy JTF_VARCHAR2_TABLE_100
637: , p11_a12 out nocopy JTF_VARCHAR2_TABLE_100
642: , p11_a17 out nocopy JTF_VARCHAR2_TABLE_100
643: , p11_a18 out nocopy JTF_VARCHAR2_TABLE_100
644: , p11_a19 out nocopy JTF_VARCHAR2_TABLE_100
645: , p11_a20 out nocopy JTF_VARCHAR2_TABLE_100
646: , p11_a21 out nocopy JTF_NUMBER_TABLE
647: , p11_a22 out nocopy JTF_VARCHAR2_TABLE_100
648: , p11_a23 out nocopy JTF_NUMBER_TABLE
649: , p11_a24 out nocopy JTF_DATE_TABLE
650: , p11_a25 out nocopy JTF_VARCHAR2_TABLE_100
644: , p11_a19 out nocopy JTF_VARCHAR2_TABLE_100
645: , p11_a20 out nocopy JTF_VARCHAR2_TABLE_100
646: , p11_a21 out nocopy JTF_NUMBER_TABLE
647: , p11_a22 out nocopy JTF_VARCHAR2_TABLE_100
648: , p11_a23 out nocopy JTF_NUMBER_TABLE
649: , p11_a24 out nocopy JTF_DATE_TABLE
650: , p11_a25 out nocopy JTF_VARCHAR2_TABLE_100
651: , p11_a26 out nocopy JTF_DATE_TABLE
652: , p11_a27 out nocopy JTF_VARCHAR2_TABLE_100