1: package cn_tsr_pvt_w AUTHID CURRENT_USER as
2: /* $Header: cnwtsrs.pls 115.6 2002/11/25 22:32:42 nkodkani ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy cn_tsr_pvt.tsr_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
1: package cn_tsr_pvt_w AUTHID CURRENT_USER as
2: /* $Header: cnwtsrs.pls 115.6 2002/11/25 22:32:42 nkodkani ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy cn_tsr_pvt.tsr_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
1: package cn_tsr_pvt_w AUTHID CURRENT_USER as
2: /* $Header: cnwtsrs.pls 115.6 2002/11/25 22:32:42 nkodkani ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy cn_tsr_pvt.tsr_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: );
2: /* $Header: cnwtsrs.pls 115.6 2002/11/25 22:32:42 nkodkani ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy cn_tsr_pvt.tsr_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: );
10: procedure rosetta_table_copy_out_p1(t cn_tsr_pvt.tsr_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: );
10: procedure rosetta_table_copy_out_p1(t cn_tsr_pvt.tsr_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
11: , a1 out nocopy JTF_VARCHAR2_TABLE_100
12: , a2 out nocopy JTF_VARCHAR2_TABLE_100
13: , a3 out nocopy JTF_VARCHAR2_TABLE_100
14: , a4 out nocopy JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: );
10: procedure rosetta_table_copy_out_p1(t cn_tsr_pvt.tsr_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
11: , a1 out nocopy JTF_VARCHAR2_TABLE_100
12: , a2 out nocopy JTF_VARCHAR2_TABLE_100
13: , a3 out nocopy JTF_VARCHAR2_TABLE_100
14: , a4 out nocopy JTF_NUMBER_TABLE
15: , a5 out nocopy JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: );
10: procedure rosetta_table_copy_out_p1(t cn_tsr_pvt.tsr_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
11: , a1 out nocopy JTF_VARCHAR2_TABLE_100
12: , a2 out nocopy JTF_VARCHAR2_TABLE_100
13: , a3 out nocopy JTF_VARCHAR2_TABLE_100
14: , a4 out nocopy JTF_NUMBER_TABLE
15: , a5 out nocopy JTF_NUMBER_TABLE
16: );
9: );
10: procedure rosetta_table_copy_out_p1(t cn_tsr_pvt.tsr_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
11: , a1 out nocopy JTF_VARCHAR2_TABLE_100
12: , a2 out nocopy JTF_VARCHAR2_TABLE_100
13: , a3 out nocopy JTF_VARCHAR2_TABLE_100
14: , a4 out nocopy JTF_NUMBER_TABLE
15: , a5 out nocopy JTF_NUMBER_TABLE
16: );
17:
27: , p_org_code VARCHAR2
28: , p_period_id date
29: , p_start_row NUMBER
30: , p_rows NUMBER
31: , p13_a0 out nocopy JTF_VARCHAR2_TABLE_100
32: , p13_a1 out nocopy JTF_VARCHAR2_TABLE_100
33: , p13_a2 out nocopy JTF_VARCHAR2_TABLE_100
34: , p13_a3 out nocopy JTF_VARCHAR2_TABLE_100
35: , p13_a4 out nocopy JTF_NUMBER_TABLE
28: , p_period_id date
29: , p_start_row NUMBER
30: , p_rows NUMBER
31: , p13_a0 out nocopy JTF_VARCHAR2_TABLE_100
32: , p13_a1 out nocopy JTF_VARCHAR2_TABLE_100
33: , p13_a2 out nocopy JTF_VARCHAR2_TABLE_100
34: , p13_a3 out nocopy JTF_VARCHAR2_TABLE_100
35: , p13_a4 out nocopy JTF_NUMBER_TABLE
36: , p13_a5 out nocopy JTF_NUMBER_TABLE
29: , p_start_row NUMBER
30: , p_rows NUMBER
31: , p13_a0 out nocopy JTF_VARCHAR2_TABLE_100
32: , p13_a1 out nocopy JTF_VARCHAR2_TABLE_100
33: , p13_a2 out nocopy JTF_VARCHAR2_TABLE_100
34: , p13_a3 out nocopy JTF_VARCHAR2_TABLE_100
35: , p13_a4 out nocopy JTF_NUMBER_TABLE
36: , p13_a5 out nocopy JTF_NUMBER_TABLE
37: , x_total_rows out nocopy NUMBER
30: , p_rows NUMBER
31: , p13_a0 out nocopy JTF_VARCHAR2_TABLE_100
32: , p13_a1 out nocopy JTF_VARCHAR2_TABLE_100
33: , p13_a2 out nocopy JTF_VARCHAR2_TABLE_100
34: , p13_a3 out nocopy JTF_VARCHAR2_TABLE_100
35: , p13_a4 out nocopy JTF_NUMBER_TABLE
36: , p13_a5 out nocopy JTF_NUMBER_TABLE
37: , x_total_rows out nocopy NUMBER
38: , download VARCHAR2