1: package cn_calc_sql_exps_pvt_w as
2: /* $Header: cnwcexps.pls 120.6 2007/03/14 12:57:03 kjayapau ship $ */
3: procedure rosetta_table_copy_in_p0(t out nocopy cn_calc_sql_exps_pvt.parent_expression_tbl_type, a0 JTF_VARCHAR2_TABLE_100);
4: procedure rosetta_table_copy_out_p0(t cn_calc_sql_exps_pvt.parent_expression_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100);
5:
6: procedure rosetta_table_copy_in_p2(t out nocopy cn_calc_sql_exps_pvt.calc_expression_tbl_type, a0 JTF_NUMBER_TABLE
7: , a1 JTF_VARCHAR2_TABLE_100
1: package cn_calc_sql_exps_pvt_w as
2: /* $Header: cnwcexps.pls 120.6 2007/03/14 12:57:03 kjayapau ship $ */
3: procedure rosetta_table_copy_in_p0(t out nocopy cn_calc_sql_exps_pvt.parent_expression_tbl_type, a0 JTF_VARCHAR2_TABLE_100);
4: procedure rosetta_table_copy_out_p0(t cn_calc_sql_exps_pvt.parent_expression_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100);
5:
6: procedure rosetta_table_copy_in_p2(t out nocopy cn_calc_sql_exps_pvt.calc_expression_tbl_type, a0 JTF_NUMBER_TABLE
7: , a1 JTF_VARCHAR2_TABLE_100
8: , a2 JTF_VARCHAR2_TABLE_100
3: procedure rosetta_table_copy_in_p0(t out nocopy cn_calc_sql_exps_pvt.parent_expression_tbl_type, a0 JTF_VARCHAR2_TABLE_100);
4: procedure rosetta_table_copy_out_p0(t cn_calc_sql_exps_pvt.parent_expression_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100);
5:
6: procedure rosetta_table_copy_in_p2(t out nocopy cn_calc_sql_exps_pvt.calc_expression_tbl_type, a0 JTF_NUMBER_TABLE
7: , a1 JTF_VARCHAR2_TABLE_100
8: , a2 JTF_VARCHAR2_TABLE_100
9: , a3 JTF_VARCHAR2_TABLE_100
10: , a4 JTF_VARCHAR2_TABLE_100
11: );
4: procedure rosetta_table_copy_out_p0(t cn_calc_sql_exps_pvt.parent_expression_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100);
5:
6: procedure rosetta_table_copy_in_p2(t out nocopy cn_calc_sql_exps_pvt.calc_expression_tbl_type, a0 JTF_NUMBER_TABLE
7: , a1 JTF_VARCHAR2_TABLE_100
8: , a2 JTF_VARCHAR2_TABLE_100
9: , a3 JTF_VARCHAR2_TABLE_100
10: , a4 JTF_VARCHAR2_TABLE_100
11: );
12: procedure rosetta_table_copy_out_p2(t cn_calc_sql_exps_pvt.calc_expression_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
5:
6: procedure rosetta_table_copy_in_p2(t out nocopy cn_calc_sql_exps_pvt.calc_expression_tbl_type, a0 JTF_NUMBER_TABLE
7: , a1 JTF_VARCHAR2_TABLE_100
8: , a2 JTF_VARCHAR2_TABLE_100
9: , a3 JTF_VARCHAR2_TABLE_100
10: , a4 JTF_VARCHAR2_TABLE_100
11: );
12: procedure rosetta_table_copy_out_p2(t cn_calc_sql_exps_pvt.calc_expression_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
13: , a1 out nocopy JTF_VARCHAR2_TABLE_100
6: procedure rosetta_table_copy_in_p2(t out nocopy cn_calc_sql_exps_pvt.calc_expression_tbl_type, a0 JTF_NUMBER_TABLE
7: , a1 JTF_VARCHAR2_TABLE_100
8: , a2 JTF_VARCHAR2_TABLE_100
9: , a3 JTF_VARCHAR2_TABLE_100
10: , a4 JTF_VARCHAR2_TABLE_100
11: );
12: procedure rosetta_table_copy_out_p2(t cn_calc_sql_exps_pvt.calc_expression_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
13: , a1 out nocopy JTF_VARCHAR2_TABLE_100
14: , a2 out nocopy JTF_VARCHAR2_TABLE_100
9: , a3 JTF_VARCHAR2_TABLE_100
10: , a4 JTF_VARCHAR2_TABLE_100
11: );
12: procedure rosetta_table_copy_out_p2(t cn_calc_sql_exps_pvt.calc_expression_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
13: , a1 out nocopy JTF_VARCHAR2_TABLE_100
14: , a2 out nocopy JTF_VARCHAR2_TABLE_100
15: , a3 out nocopy JTF_VARCHAR2_TABLE_100
16: , a4 out nocopy JTF_VARCHAR2_TABLE_100
17: );
10: , a4 JTF_VARCHAR2_TABLE_100
11: );
12: procedure rosetta_table_copy_out_p2(t cn_calc_sql_exps_pvt.calc_expression_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
13: , a1 out nocopy JTF_VARCHAR2_TABLE_100
14: , a2 out nocopy JTF_VARCHAR2_TABLE_100
15: , a3 out nocopy JTF_VARCHAR2_TABLE_100
16: , a4 out nocopy JTF_VARCHAR2_TABLE_100
17: );
18:
11: );
12: procedure rosetta_table_copy_out_p2(t cn_calc_sql_exps_pvt.calc_expression_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
13: , a1 out nocopy JTF_VARCHAR2_TABLE_100
14: , a2 out nocopy JTF_VARCHAR2_TABLE_100
15: , a3 out nocopy JTF_VARCHAR2_TABLE_100
16: , a4 out nocopy JTF_VARCHAR2_TABLE_100
17: );
18:
19: procedure rosetta_table_copy_in_p4(t out nocopy cn_calc_sql_exps_pvt.expr_type_tbl_type, a0 JTF_VARCHAR2_TABLE_100
12: procedure rosetta_table_copy_out_p2(t cn_calc_sql_exps_pvt.calc_expression_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
13: , a1 out nocopy JTF_VARCHAR2_TABLE_100
14: , a2 out nocopy JTF_VARCHAR2_TABLE_100
15: , a3 out nocopy JTF_VARCHAR2_TABLE_100
16: , a4 out nocopy JTF_VARCHAR2_TABLE_100
17: );
18:
19: procedure rosetta_table_copy_in_p4(t out nocopy cn_calc_sql_exps_pvt.expr_type_tbl_type, a0 JTF_VARCHAR2_TABLE_100
20: , a1 JTF_VARCHAR2_TABLE_100
15: , a3 out nocopy JTF_VARCHAR2_TABLE_100
16: , a4 out nocopy JTF_VARCHAR2_TABLE_100
17: );
18:
19: procedure rosetta_table_copy_in_p4(t out nocopy cn_calc_sql_exps_pvt.expr_type_tbl_type, a0 JTF_VARCHAR2_TABLE_100
20: , a1 JTF_VARCHAR2_TABLE_100
21: , a2 JTF_VARCHAR2_TABLE_100
22: , a3 JTF_VARCHAR2_TABLE_4000
23: );
16: , a4 out nocopy JTF_VARCHAR2_TABLE_100
17: );
18:
19: procedure rosetta_table_copy_in_p4(t out nocopy cn_calc_sql_exps_pvt.expr_type_tbl_type, a0 JTF_VARCHAR2_TABLE_100
20: , a1 JTF_VARCHAR2_TABLE_100
21: , a2 JTF_VARCHAR2_TABLE_100
22: , a3 JTF_VARCHAR2_TABLE_4000
23: );
24: procedure rosetta_table_copy_out_p4(t cn_calc_sql_exps_pvt.expr_type_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
17: );
18:
19: procedure rosetta_table_copy_in_p4(t out nocopy cn_calc_sql_exps_pvt.expr_type_tbl_type, a0 JTF_VARCHAR2_TABLE_100
20: , a1 JTF_VARCHAR2_TABLE_100
21: , a2 JTF_VARCHAR2_TABLE_100
22: , a3 JTF_VARCHAR2_TABLE_4000
23: );
24: procedure rosetta_table_copy_out_p4(t cn_calc_sql_exps_pvt.expr_type_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
25: , a1 out nocopy JTF_VARCHAR2_TABLE_100
20: , a1 JTF_VARCHAR2_TABLE_100
21: , a2 JTF_VARCHAR2_TABLE_100
22: , a3 JTF_VARCHAR2_TABLE_4000
23: );
24: procedure rosetta_table_copy_out_p4(t cn_calc_sql_exps_pvt.expr_type_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
25: , a1 out nocopy JTF_VARCHAR2_TABLE_100
26: , a2 out nocopy JTF_VARCHAR2_TABLE_100
27: , a3 out nocopy JTF_VARCHAR2_TABLE_4000
28: );
21: , a2 JTF_VARCHAR2_TABLE_100
22: , a3 JTF_VARCHAR2_TABLE_4000
23: );
24: procedure rosetta_table_copy_out_p4(t cn_calc_sql_exps_pvt.expr_type_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
25: , a1 out nocopy JTF_VARCHAR2_TABLE_100
26: , a2 out nocopy JTF_VARCHAR2_TABLE_100
27: , a3 out nocopy JTF_VARCHAR2_TABLE_4000
28: );
29:
22: , a3 JTF_VARCHAR2_TABLE_4000
23: );
24: procedure rosetta_table_copy_out_p4(t cn_calc_sql_exps_pvt.expr_type_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
25: , a1 out nocopy JTF_VARCHAR2_TABLE_100
26: , a2 out nocopy JTF_VARCHAR2_TABLE_100
27: , a3 out nocopy JTF_VARCHAR2_TABLE_4000
28: );
29:
30: procedure rosetta_table_copy_in_p5(t out nocopy cn_calc_sql_exps_pvt.num_tbl_type, a0 JTF_NUMBER_TABLE);