[Home] [Help]
PACKAGE: APPS.CN_RATE_DIMENSIONS_PVT_W
Source
1 package cn_rate_dimensions_pvt_w AUTHID CURRENT_USER as
2 /* $Header: cnwrdims.pls 120.3 2006/01/18 15:30 jxsingh ship $ */
3 procedure rosetta_table_copy_in_p1(t out nocopy cn_rate_dimensions_pvt.tiers_tbl_type, a0 JTF_NUMBER_TABLE
4 , a1 JTF_NUMBER_TABLE
5 , a2 JTF_NUMBER_TABLE
6 , a3 JTF_NUMBER_TABLE
7 , a4 JTF_NUMBER_TABLE
8 , a5 JTF_VARCHAR2_TABLE_100
9 , a6 JTF_NUMBER_TABLE
10 , a7 JTF_NUMBER_TABLE
11 , a8 JTF_VARCHAR2_TABLE_1000
12 );
13 procedure rosetta_table_copy_out_p1(t cn_rate_dimensions_pvt.tiers_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
14 , a1 out nocopy JTF_NUMBER_TABLE
15 , a2 out nocopy JTF_NUMBER_TABLE
16 , a3 out nocopy JTF_NUMBER_TABLE
17 , a4 out nocopy JTF_NUMBER_TABLE
18 , a5 out nocopy JTF_VARCHAR2_TABLE_100
19 , a6 out nocopy JTF_NUMBER_TABLE
20 , a7 out nocopy JTF_NUMBER_TABLE
21 , a8 out nocopy JTF_VARCHAR2_TABLE_1000
22 );
23
24 procedure rosetta_table_copy_in_p2(t out nocopy cn_rate_dimensions_pvt.parent_rate_tables_tbl_type, a0 JTF_VARCHAR2_TABLE_100);
25 procedure rosetta_table_copy_out_p2(t cn_rate_dimensions_pvt.parent_rate_tables_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100);
26
27 procedure create_dimension(p_api_version NUMBER
28 , p_init_msg_list VARCHAR2
29 , p_commit VARCHAR2
30 , p_validation_level NUMBER
31 , p_name VARCHAR2
32 , p_description VARCHAR2
33 , p_dim_unit_code VARCHAR2
34 , p_number_tier NUMBER
35 , p8_a0 JTF_NUMBER_TABLE
36 , p8_a1 JTF_NUMBER_TABLE
37 , p8_a2 JTF_NUMBER_TABLE
38 , p8_a3 JTF_NUMBER_TABLE
39 , p8_a4 JTF_NUMBER_TABLE
40 , p8_a5 JTF_VARCHAR2_TABLE_100
41 , p8_a6 JTF_NUMBER_TABLE
42 , p8_a7 JTF_NUMBER_TABLE
43 , p8_a8 JTF_VARCHAR2_TABLE_1000
44 , p_org_id NUMBER
45 , x_rate_dimension_id in out nocopy NUMBER
46 , x_return_status out nocopy VARCHAR2
47 , x_msg_count out nocopy NUMBER
48 , x_msg_data out nocopy VARCHAR2
49 );
50 procedure update_dimension(p_api_version NUMBER
51 , p_init_msg_list VARCHAR2
52 , p_commit VARCHAR2
53 , p_validation_level NUMBER
54 , p_rate_dimension_id NUMBER
55 , p_name VARCHAR2
56 , p_description VARCHAR2
57 , p_dim_unit_code VARCHAR2
58 , p_number_tier NUMBER
59 , p9_a0 JTF_NUMBER_TABLE
60 , p9_a1 JTF_NUMBER_TABLE
61 , p9_a2 JTF_NUMBER_TABLE
62 , p9_a3 JTF_NUMBER_TABLE
63 , p9_a4 JTF_NUMBER_TABLE
64 , p9_a5 JTF_VARCHAR2_TABLE_100
65 , p9_a6 JTF_NUMBER_TABLE
66 , p9_a7 JTF_NUMBER_TABLE
67 , p9_a8 JTF_VARCHAR2_TABLE_1000
68 , p_org_id NUMBER
69 , p_object_version_number in out nocopy NUMBER
70 , x_return_status out nocopy VARCHAR2
71 , x_msg_count out nocopy NUMBER
72 , x_msg_data out nocopy VARCHAR2
73 );
74 end cn_rate_dimensions_pvt_w;