DBA Data[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;