1: package amv_mychannel_pvt_w as
2: /* $Header: amvwmycs.pls 120.2 2005/06/30 08:21 appldev ship $ */
3: procedure rosetta_table_copy_in_p0(t out nocopy amv_mychannel_pvt.amv_number_varray_type, a0 JTF_NUMBER_TABLE);
4: procedure rosetta_table_copy_out_p0(t amv_mychannel_pvt.amv_number_varray_type, a0 out nocopy JTF_NUMBER_TABLE);
5:
1: package amv_mychannel_pvt_w as
2: /* $Header: amvwmycs.pls 120.2 2005/06/30 08:21 appldev ship $ */
3: procedure rosetta_table_copy_in_p0(t out nocopy amv_mychannel_pvt.amv_number_varray_type, a0 JTF_NUMBER_TABLE);
4: procedure rosetta_table_copy_out_p0(t amv_mychannel_pvt.amv_number_varray_type, a0 out nocopy JTF_NUMBER_TABLE);
5:
6: procedure rosetta_table_copy_in_p4(t out nocopy amv_mychannel_pvt.amv_cat_hierarchy_varray_type, a0 JTF_NUMBER_TABLE
7: , a1 JTF_NUMBER_TABLE
1: package amv_mychannel_pvt_w as
2: /* $Header: amvwmycs.pls 120.2 2005/06/30 08:21 appldev ship $ */
3: procedure rosetta_table_copy_in_p0(t out nocopy amv_mychannel_pvt.amv_number_varray_type, a0 JTF_NUMBER_TABLE);
4: procedure rosetta_table_copy_out_p0(t amv_mychannel_pvt.amv_number_varray_type, a0 out nocopy JTF_NUMBER_TABLE);
5:
6: procedure rosetta_table_copy_in_p4(t out nocopy amv_mychannel_pvt.amv_cat_hierarchy_varray_type, a0 JTF_NUMBER_TABLE
7: , a1 JTF_NUMBER_TABLE
8: , a2 JTF_VARCHAR2_TABLE_300
2: /* $Header: amvwmycs.pls 120.2 2005/06/30 08:21 appldev ship $ */
3: procedure rosetta_table_copy_in_p0(t out nocopy amv_mychannel_pvt.amv_number_varray_type, a0 JTF_NUMBER_TABLE);
4: procedure rosetta_table_copy_out_p0(t amv_mychannel_pvt.amv_number_varray_type, a0 out nocopy JTF_NUMBER_TABLE);
5:
6: procedure rosetta_table_copy_in_p4(t out nocopy amv_mychannel_pvt.amv_cat_hierarchy_varray_type, a0 JTF_NUMBER_TABLE
7: , a1 JTF_NUMBER_TABLE
8: , a2 JTF_VARCHAR2_TABLE_300
9: );
10: procedure rosetta_table_copy_out_p4(t amv_mychannel_pvt.amv_cat_hierarchy_varray_type, a0 out nocopy JTF_NUMBER_TABLE
6: procedure rosetta_table_copy_in_p4(t out nocopy amv_mychannel_pvt.amv_cat_hierarchy_varray_type, a0 JTF_NUMBER_TABLE
7: , a1 JTF_NUMBER_TABLE
8: , a2 JTF_VARCHAR2_TABLE_300
9: );
10: procedure rosetta_table_copy_out_p4(t amv_mychannel_pvt.amv_cat_hierarchy_varray_type, a0 out nocopy JTF_NUMBER_TABLE
11: , a1 out nocopy JTF_NUMBER_TABLE
12: , a2 out nocopy JTF_VARCHAR2_TABLE_300
13: );
14:
11: , a1 out nocopy JTF_NUMBER_TABLE
12: , a2 out nocopy JTF_VARCHAR2_TABLE_300
13: );
14:
15: procedure rosetta_table_copy_in_p6(t out nocopy amv_mychannel_pvt.amv_my_channel_varray_type, a0 JTF_NUMBER_TABLE
16: , a1 JTF_VARCHAR2_TABLE_100
17: , a2 JTF_VARCHAR2_TABLE_100
18: , a3 JTF_NUMBER_TABLE
19: , a4 JTF_VARCHAR2_TABLE_100
24: , a9 JTF_VARCHAR2_TABLE_100
25: , a10 JTF_VARCHAR2_TABLE_100
26: , a11 JTF_VARCHAR2_TABLE_100
27: );
28: procedure rosetta_table_copy_out_p6(t amv_mychannel_pvt.amv_my_channel_varray_type, a0 out nocopy JTF_NUMBER_TABLE
29: , a1 out nocopy JTF_VARCHAR2_TABLE_100
30: , a2 out nocopy JTF_VARCHAR2_TABLE_100
31: , a3 out nocopy JTF_NUMBER_TABLE
32: , a4 out nocopy JTF_VARCHAR2_TABLE_100
38: , a10 out nocopy JTF_VARCHAR2_TABLE_100
39: , a11 out nocopy JTF_VARCHAR2_TABLE_100
40: );
41:
42: procedure rosetta_table_copy_in_p8(t out nocopy amv_mychannel_pvt.amv_wf_notif_varray_type, a0 JTF_NUMBER_TABLE
43: , a1 JTF_VARCHAR2_TABLE_4000
44: , a2 JTF_DATE_TABLE
45: , a3 JTF_DATE_TABLE
46: , a4 JTF_DATE_TABLE
47: , a5 JTF_VARCHAR2_TABLE_100
48: , a6 JTF_NUMBER_TABLE
49: , a7 JTF_VARCHAR2_TABLE_100
50: );
51: procedure rosetta_table_copy_out_p8(t amv_mychannel_pvt.amv_wf_notif_varray_type, a0 out nocopy JTF_NUMBER_TABLE
52: , a1 out nocopy JTF_VARCHAR2_TABLE_4000
53: , a2 out nocopy JTF_DATE_TABLE
54: , a3 out nocopy JTF_DATE_TABLE
55: , a4 out nocopy JTF_DATE_TABLE
57: , a6 out nocopy JTF_NUMBER_TABLE
58: , a7 out nocopy JTF_VARCHAR2_TABLE_100
59: );
60:
61: procedure rosetta_table_copy_in_p10(t out nocopy amv_mychannel_pvt.amv_itemdisplay_varray_type, a0 JTF_NUMBER_TABLE
62: , a1 JTF_VARCHAR2_TABLE_300
63: , a2 JTF_VARCHAR2_TABLE_2000
64: , a3 JTF_VARCHAR2_TABLE_100
65: );
62: , a1 JTF_VARCHAR2_TABLE_300
63: , a2 JTF_VARCHAR2_TABLE_2000
64: , a3 JTF_VARCHAR2_TABLE_100
65: );
66: procedure rosetta_table_copy_out_p10(t amv_mychannel_pvt.amv_itemdisplay_varray_type, a0 out nocopy JTF_NUMBER_TABLE
67: , a1 out nocopy JTF_VARCHAR2_TABLE_300
68: , a2 out nocopy JTF_VARCHAR2_TABLE_2000
69: , a3 out nocopy JTF_VARCHAR2_TABLE_100
70: );
202: , p9_a0 NUMBER := 0-1962.0724
203: , p9_a1 NUMBER := 0-1962.0724
204: , p9_a2 VARCHAR2 := fnd_api.g_miss_char
205: );
206: end amv_mychannel_pvt_w;