[Home] [Help]
PACKAGE: APPS.CN_TSR_PVT_W
Source
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 );
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
18 procedure get_tsr_data(p_api_version NUMBER
19 , p_init_msg_list VARCHAR2
20 , p_commit VARCHAR2
21 , p_validation_level NUMBER
22 , x_return_status out nocopy VARCHAR2
23 , x_msg_count out nocopy NUMBER
24 , x_msg_data out nocopy VARCHAR2
25 , p_mgr_id NUMBER
26 , p_comp_group_id NUMBER
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
36 , p13_a5 out nocopy JTF_NUMBER_TABLE
37 , x_total_rows out nocopy NUMBER
38 , download VARCHAR2
39 );
40 end cn_tsr_pvt_w;