[Home] [Help]
PACKAGE: APPS.CN_MULTI_RATE_SCHEDULES_PVT_W
Source
1 package cn_multi_rate_schedules_pvt_w as
2 /* $Header: cnwrschs.pls 120.4 2006/01/18 16:13 jxsingh ship $ */
3 procedure rosetta_table_copy_in_p5(t out nocopy cn_multi_rate_schedules_pvt.rate_table_tbl_type, a0 JTF_NUMBER_TABLE
4 , a1 JTF_VARCHAR2_TABLE_100
5 , a2 JTF_VARCHAR2_TABLE_100
6 , a3 JTF_NUMBER_TABLE
7 , a4 JTF_NUMBER_TABLE
8 );
9 procedure rosetta_table_copy_out_p5(t cn_multi_rate_schedules_pvt.rate_table_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
10 , a1 out nocopy JTF_VARCHAR2_TABLE_100
11 , a2 out nocopy JTF_VARCHAR2_TABLE_100
12 , a3 out nocopy JTF_NUMBER_TABLE
13 , a4 out nocopy JTF_NUMBER_TABLE
14 );
15
16 procedure rosetta_table_copy_in_p6(t out nocopy cn_multi_rate_schedules_pvt.dims_tbl_type, a0 JTF_NUMBER_TABLE
17 , a1 JTF_NUMBER_TABLE
18 , a2 JTF_NUMBER_TABLE
19 , a3 JTF_NUMBER_TABLE
20 , a4 JTF_VARCHAR2_TABLE_100
21 , a5 JTF_NUMBER_TABLE
22 , a6 JTF_VARCHAR2_TABLE_100
23 , a7 JTF_NUMBER_TABLE
24 );
25 procedure rosetta_table_copy_out_p6(t cn_multi_rate_schedules_pvt.dims_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
26 , a1 out nocopy JTF_NUMBER_TABLE
27 , a2 out nocopy JTF_NUMBER_TABLE
28 , a3 out nocopy JTF_NUMBER_TABLE
29 , a4 out nocopy JTF_VARCHAR2_TABLE_100
30 , a5 out nocopy JTF_NUMBER_TABLE
31 , a6 out nocopy JTF_VARCHAR2_TABLE_100
32 , a7 out nocopy JTF_NUMBER_TABLE
33 );
34
35 procedure rosetta_table_copy_in_p7(t out nocopy cn_multi_rate_schedules_pvt.parents_tbl_type, a0 JTF_VARCHAR2_TABLE_100);
36 procedure rosetta_table_copy_out_p7(t cn_multi_rate_schedules_pvt.parents_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100);
37
38 procedure rosetta_table_copy_in_p8(t out nocopy cn_multi_rate_schedules_pvt.num_tbl_type, a0 JTF_NUMBER_TABLE);
39 procedure rosetta_table_copy_out_p8(t cn_multi_rate_schedules_pvt.num_tbl_type, a0 out nocopy JTF_NUMBER_TABLE);
40
41 procedure rosetta_table_copy_in_p9(t out nocopy cn_multi_rate_schedules_pvt.plan_elt_tbl_type, a0 JTF_NUMBER_TABLE
42 , a1 JTF_VARCHAR2_TABLE_100
43 , a2 JTF_VARCHAR2_TABLE_100
44 , a3 JTF_NUMBER_TABLE
45 , a4 JTF_VARCHAR2_TABLE_100
46 , a5 JTF_DATE_TABLE
47 , a6 JTF_DATE_TABLE
48 );
49 procedure rosetta_table_copy_out_p9(t cn_multi_rate_schedules_pvt.plan_elt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
50 , a1 out nocopy JTF_VARCHAR2_TABLE_100
51 , a2 out nocopy JTF_VARCHAR2_TABLE_100
52 , a3 out nocopy JTF_NUMBER_TABLE
53 , a4 out nocopy JTF_VARCHAR2_TABLE_100
54 , a5 out nocopy JTF_DATE_TABLE
55 , a6 out nocopy JTF_DATE_TABLE
56 );
57
58 procedure rosetta_table_copy_in_p10(t out nocopy cn_multi_rate_schedules_pvt.formula_tbl_type, a0 JTF_NUMBER_TABLE
59 , a1 JTF_VARCHAR2_TABLE_100
60 , a2 JTF_VARCHAR2_TABLE_100
61 , a3 JTF_DATE_TABLE
62 , a4 JTF_DATE_TABLE
63 );
64 procedure rosetta_table_copy_out_p10(t cn_multi_rate_schedules_pvt.formula_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
65 , a1 out nocopy JTF_VARCHAR2_TABLE_100
66 , a2 out nocopy JTF_VARCHAR2_TABLE_100
67 , a3 out nocopy JTF_DATE_TABLE
68 , a4 out nocopy JTF_DATE_TABLE
69 );
70
71 procedure rosetta_table_copy_in_p11(t out nocopy cn_multi_rate_schedules_pvt.comm_tbl_type, a0 JTF_NUMBER_TABLE
72 , a1 JTF_NUMBER_TABLE
73 , a2 JTF_NUMBER_TABLE
74 , a3 JTF_NUMBER_TABLE
75 );
76 procedure rosetta_table_copy_out_p11(t cn_multi_rate_schedules_pvt.comm_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
77 , a1 out nocopy JTF_NUMBER_TABLE
78 , a2 out nocopy JTF_NUMBER_TABLE
79 , a3 out nocopy JTF_NUMBER_TABLE
80 );
81
82 procedure create_schedule(p_api_version NUMBER
83 , p_init_msg_list VARCHAR2
84 , p_commit VARCHAR2
85 , p_validation_level NUMBER
86 , p_name VARCHAR2
87 , p_commission_unit_code VARCHAR2
88 , p_number_dim NUMBER
89 , p7_a0 JTF_NUMBER_TABLE
90 , p7_a1 JTF_NUMBER_TABLE
91 , p7_a2 JTF_NUMBER_TABLE
92 , p7_a3 JTF_NUMBER_TABLE
93 , p7_a4 JTF_VARCHAR2_TABLE_100
94 , p7_a5 JTF_NUMBER_TABLE
95 , p7_a6 JTF_VARCHAR2_TABLE_100
96 , p7_a7 JTF_NUMBER_TABLE
97 , p_org_id NUMBER
98 , x_rate_schedule_id in out nocopy NUMBER
99 , x_return_status out nocopy VARCHAR2
100 , x_msg_count out nocopy NUMBER
101 , x_msg_data out nocopy VARCHAR2
102 );
103 procedure update_schedule(p_api_version NUMBER
104 , p_init_msg_list VARCHAR2
105 , p_commit VARCHAR2
106 , p_validation_level NUMBER
107 , p_rate_schedule_id NUMBER
108 , p_name VARCHAR2
109 , p_commission_unit_code VARCHAR2
110 , p_number_dim NUMBER
111 , p_org_id NUMBER
112 , p_object_version_number in out nocopy NUMBER
113 , p10_a0 JTF_NUMBER_TABLE
114 , p10_a1 JTF_NUMBER_TABLE
115 , p10_a2 JTF_NUMBER_TABLE
116 , p10_a3 JTF_NUMBER_TABLE
117 , p10_a4 JTF_VARCHAR2_TABLE_100
118 , p10_a5 JTF_NUMBER_TABLE
119 , p10_a6 JTF_VARCHAR2_TABLE_100
120 , p10_a7 JTF_NUMBER_TABLE
121 , x_return_status out nocopy VARCHAR2
122 , x_msg_count out nocopy NUMBER
123 , x_msg_data out nocopy VARCHAR2
124 );
125 procedure get_rate_tier_info(p_rate_schedule_id NUMBER
126 , p_rate_dim_tier_id_tbl JTF_NUMBER_TABLE
127 , x_rate_tier_id out nocopy NUMBER
128 , x_rate_sequence out nocopy NUMBER
129 , x_commission_amount out nocopy NUMBER
130 , x_object_version_number out nocopy NUMBER
131 );
132 procedure update_comm_rate(p_rate_schedule_id NUMBER
133 , p1_a0 JTF_NUMBER_TABLE
134 , p1_a1 JTF_NUMBER_TABLE
135 , p1_a2 JTF_NUMBER_TABLE
136 , p1_a3 JTF_NUMBER_TABLE
137 , p_org_id NUMBER
138 );
139 end cn_multi_rate_schedules_pvt_w;