1: package cn_sales_hier_pub_w AUTHID CURRENT_USER as
2: /* $Header: cnwhiers.pls 115.6 2002/11/25 23:56:59 fting ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy cn_sales_hier_pub.hier_tbl_type, a0 JTF_VARCHAR2_TABLE_300
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
1: package cn_sales_hier_pub_w AUTHID CURRENT_USER as
2: /* $Header: cnwhiers.pls 115.6 2002/11/25 23:56:59 fting ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy cn_sales_hier_pub.hier_tbl_type, a0 JTF_VARCHAR2_TABLE_300
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_DATE_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_DATE_TABLE
8: );
9: procedure rosetta_table_copy_out_p1(t cn_sales_hier_pub.hier_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_300
10: , a1 out nocopy JTF_VARCHAR2_TABLE_100
11: , a2 out nocopy JTF_VARCHAR2_TABLE_100
12: , a3 out nocopy JTF_DATE_TABLE
13: , a4 out nocopy JTF_DATE_TABLE
12: , a3 out nocopy JTF_DATE_TABLE
13: , a4 out nocopy JTF_DATE_TABLE
14: );
15:
16: procedure rosetta_table_copy_in_p3(t out nocopy cn_sales_hier_pub.grp_tbl_type, a0 JTF_VARCHAR2_TABLE_100
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_VARCHAR2_TABLE_300
19: , a3 JTF_VARCHAR2_TABLE_100
20: );
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_VARCHAR2_TABLE_300
19: , a3 JTF_VARCHAR2_TABLE_100
20: );
21: procedure rosetta_table_copy_out_p3(t cn_sales_hier_pub.grp_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
22: , a1 out nocopy JTF_NUMBER_TABLE
23: , a2 out nocopy JTF_VARCHAR2_TABLE_300
24: , a3 out nocopy JTF_VARCHAR2_TABLE_100
25: );
55: , p18_a2 out nocopy JTF_VARCHAR2_TABLE_300
56: , p18_a3 out nocopy JTF_VARCHAR2_TABLE_100
57: , x_grp_count out nocopy NUMBER
58: );
59: end cn_sales_hier_pub_w;