eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.CN_RT_QUOTA_ASGN_PVT_W

Source


1 package cn_rt_quota_asgn_pvt_w as
2   /* $Header: cnwrtqas.pls 120.2 2005/09/14 04:30 rarajara ship $ */
3   procedure rosetta_table_copy_in_p1(t out nocopy cn_rt_quota_asgn_pvt.calc_formulas_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4     , a1 JTF_NUMBER_TABLE
5     );
6   procedure rosetta_table_copy_out_p1(t cn_rt_quota_asgn_pvt.calc_formulas_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
7     , a1 out nocopy JTF_NUMBER_TABLE
8     );
9 
10   procedure rosetta_table_copy_in_p3(t out nocopy cn_rt_quota_asgn_pvt.rt_quota_asgn_tbl_type, a0 JTF_VARCHAR2_TABLE_100
11     , a1 JTF_NUMBER_TABLE
12     , a2 JTF_NUMBER_TABLE
13     , a3 JTF_NUMBER_TABLE
14     , a4 JTF_DATE_TABLE
15     , a5 JTF_DATE_TABLE
16     , a6 JTF_NUMBER_TABLE
17     , a7 JTF_NUMBER_TABLE
18     , a8 JTF_VARCHAR2_TABLE_100
19     , a9 JTF_VARCHAR2_TABLE_100
20     , a10 JTF_VARCHAR2_TABLE_200
21     , a11 JTF_VARCHAR2_TABLE_200
22     , a12 JTF_VARCHAR2_TABLE_200
23     , a13 JTF_VARCHAR2_TABLE_200
24     , a14 JTF_VARCHAR2_TABLE_200
25     , a15 JTF_VARCHAR2_TABLE_200
26     , a16 JTF_VARCHAR2_TABLE_200
27     , a17 JTF_VARCHAR2_TABLE_200
28     , a18 JTF_VARCHAR2_TABLE_200
29     , a19 JTF_VARCHAR2_TABLE_200
30     , a20 JTF_VARCHAR2_TABLE_200
31     , a21 JTF_VARCHAR2_TABLE_200
32     , a22 JTF_VARCHAR2_TABLE_200
33     , a23 JTF_VARCHAR2_TABLE_200
34     , a24 JTF_VARCHAR2_TABLE_200
35     , a25 JTF_NUMBER_TABLE
36     , a26 JTF_NUMBER_TABLE
37     , a27 JTF_DATE_TABLE
38     , a28 JTF_NUMBER_TABLE
39     , a29 JTF_DATE_TABLE
40     , a30 JTF_NUMBER_TABLE
41     );
42   procedure rosetta_table_copy_out_p3(t cn_rt_quota_asgn_pvt.rt_quota_asgn_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
43     , a1 out nocopy JTF_NUMBER_TABLE
44     , a2 out nocopy JTF_NUMBER_TABLE
45     , a3 out nocopy JTF_NUMBER_TABLE
46     , a4 out nocopy JTF_DATE_TABLE
47     , a5 out nocopy JTF_DATE_TABLE
48     , a6 out nocopy JTF_NUMBER_TABLE
49     , a7 out nocopy JTF_NUMBER_TABLE
50     , a8 out nocopy JTF_VARCHAR2_TABLE_100
51     , a9 out nocopy JTF_VARCHAR2_TABLE_100
52     , a10 out nocopy JTF_VARCHAR2_TABLE_200
53     , a11 out nocopy JTF_VARCHAR2_TABLE_200
54     , a12 out nocopy JTF_VARCHAR2_TABLE_200
55     , a13 out nocopy JTF_VARCHAR2_TABLE_200
56     , a14 out nocopy JTF_VARCHAR2_TABLE_200
57     , a15 out nocopy JTF_VARCHAR2_TABLE_200
58     , a16 out nocopy JTF_VARCHAR2_TABLE_200
59     , a17 out nocopy JTF_VARCHAR2_TABLE_200
60     , a18 out nocopy JTF_VARCHAR2_TABLE_200
61     , a19 out nocopy JTF_VARCHAR2_TABLE_200
62     , a20 out nocopy JTF_VARCHAR2_TABLE_200
63     , a21 out nocopy JTF_VARCHAR2_TABLE_200
64     , a22 out nocopy JTF_VARCHAR2_TABLE_200
65     , a23 out nocopy JTF_VARCHAR2_TABLE_200
66     , a24 out nocopy JTF_VARCHAR2_TABLE_200
67     , a25 out nocopy JTF_NUMBER_TABLE
68     , a26 out nocopy JTF_NUMBER_TABLE
69     , a27 out nocopy JTF_DATE_TABLE
70     , a28 out nocopy JTF_NUMBER_TABLE
71     , a29 out nocopy JTF_DATE_TABLE
72     , a30 out nocopy JTF_NUMBER_TABLE
73     );
74 
75   procedure create_rate_table_assignment(p_api_version  NUMBER
76     , p_init_msg_list  VARCHAR2
77     , p_commit  VARCHAR2
78     , p_validation_level  NUMBER
79     , p4_a0 in out nocopy  VARCHAR2
80     , p4_a1 in out nocopy  NUMBER
81     , p4_a2 in out nocopy  NUMBER
82     , p4_a3 in out nocopy  NUMBER
83     , p4_a4 in out nocopy  DATE
84     , p4_a5 in out nocopy  DATE
85     , p4_a6 in out nocopy  NUMBER
86     , p4_a7 in out nocopy  NUMBER
87     , p4_a8 in out nocopy  VARCHAR2
88     , p4_a9 in out nocopy  VARCHAR2
89     , p4_a10 in out nocopy  VARCHAR2
90     , p4_a11 in out nocopy  VARCHAR2
91     , p4_a12 in out nocopy  VARCHAR2
92     , p4_a13 in out nocopy  VARCHAR2
93     , p4_a14 in out nocopy  VARCHAR2
94     , p4_a15 in out nocopy  VARCHAR2
95     , p4_a16 in out nocopy  VARCHAR2
96     , p4_a17 in out nocopy  VARCHAR2
97     , p4_a18 in out nocopy  VARCHAR2
98     , p4_a19 in out nocopy  VARCHAR2
99     , p4_a20 in out nocopy  VARCHAR2
100     , p4_a21 in out nocopy  VARCHAR2
101     , p4_a22 in out nocopy  VARCHAR2
102     , p4_a23 in out nocopy  VARCHAR2
103     , p4_a24 in out nocopy  VARCHAR2
104     , p4_a25 in out nocopy  NUMBER
105     , p4_a26 in out nocopy  NUMBER
106     , p4_a27 in out nocopy  DATE
107     , p4_a28 in out nocopy  NUMBER
108     , p4_a29 in out nocopy  DATE
109     , p4_a30 in out nocopy  NUMBER
110     , x_return_status out nocopy  VARCHAR2
111     , x_msg_count out nocopy  NUMBER
112     , x_msg_data out nocopy  VARCHAR2
113   );
114   procedure update_rate_table_assignment(p_api_version  NUMBER
115     , p_init_msg_list  VARCHAR2
116     , p_commit  VARCHAR2
117     , p_validation_level  NUMBER
118     , p4_a0 in out nocopy  VARCHAR2
119     , p4_a1 in out nocopy  NUMBER
120     , p4_a2 in out nocopy  NUMBER
121     , p4_a3 in out nocopy  NUMBER
122     , p4_a4 in out nocopy  DATE
123     , p4_a5 in out nocopy  DATE
124     , p4_a6 in out nocopy  NUMBER
125     , p4_a7 in out nocopy  NUMBER
126     , p4_a8 in out nocopy  VARCHAR2
127     , p4_a9 in out nocopy  VARCHAR2
128     , p4_a10 in out nocopy  VARCHAR2
129     , p4_a11 in out nocopy  VARCHAR2
130     , p4_a12 in out nocopy  VARCHAR2
131     , p4_a13 in out nocopy  VARCHAR2
132     , p4_a14 in out nocopy  VARCHAR2
133     , p4_a15 in out nocopy  VARCHAR2
134     , p4_a16 in out nocopy  VARCHAR2
135     , p4_a17 in out nocopy  VARCHAR2
136     , p4_a18 in out nocopy  VARCHAR2
137     , p4_a19 in out nocopy  VARCHAR2
138     , p4_a20 in out nocopy  VARCHAR2
139     , p4_a21 in out nocopy  VARCHAR2
140     , p4_a22 in out nocopy  VARCHAR2
141     , p4_a23 in out nocopy  VARCHAR2
142     , p4_a24 in out nocopy  VARCHAR2
143     , p4_a25 in out nocopy  NUMBER
144     , p4_a26 in out nocopy  NUMBER
145     , p4_a27 in out nocopy  DATE
146     , p4_a28 in out nocopy  NUMBER
147     , p4_a29 in out nocopy  DATE
148     , p4_a30 in out nocopy  NUMBER
149     , x_return_status out nocopy  VARCHAR2
150     , x_msg_count out nocopy  NUMBER
151     , x_msg_data out nocopy  VARCHAR2
152   );
153   procedure delete_rate_table_assignment(p_api_version  NUMBER
154     , p_init_msg_list  VARCHAR2
155     , p_commit  VARCHAR2
156     , p_validation_level  NUMBER
157     , p4_a0 in out nocopy  VARCHAR2
158     , p4_a1 in out nocopy  NUMBER
159     , p4_a2 in out nocopy  NUMBER
160     , p4_a3 in out nocopy  NUMBER
161     , p4_a4 in out nocopy  DATE
162     , p4_a5 in out nocopy  DATE
163     , p4_a6 in out nocopy  NUMBER
164     , p4_a7 in out nocopy  NUMBER
165     , p4_a8 in out nocopy  VARCHAR2
166     , p4_a9 in out nocopy  VARCHAR2
167     , p4_a10 in out nocopy  VARCHAR2
168     , p4_a11 in out nocopy  VARCHAR2
169     , p4_a12 in out nocopy  VARCHAR2
170     , p4_a13 in out nocopy  VARCHAR2
171     , p4_a14 in out nocopy  VARCHAR2
172     , p4_a15 in out nocopy  VARCHAR2
173     , p4_a16 in out nocopy  VARCHAR2
174     , p4_a17 in out nocopy  VARCHAR2
175     , p4_a18 in out nocopy  VARCHAR2
176     , p4_a19 in out nocopy  VARCHAR2
177     , p4_a20 in out nocopy  VARCHAR2
178     , p4_a21 in out nocopy  VARCHAR2
179     , p4_a22 in out nocopy  VARCHAR2
180     , p4_a23 in out nocopy  VARCHAR2
181     , p4_a24 in out nocopy  VARCHAR2
182     , p4_a25 in out nocopy  NUMBER
183     , p4_a26 in out nocopy  NUMBER
184     , p4_a27 in out nocopy  DATE
185     , p4_a28 in out nocopy  NUMBER
186     , p4_a29 in out nocopy  DATE
187     , p4_a30 in out nocopy  NUMBER
188     , x_return_status out nocopy  VARCHAR2
189     , x_msg_count out nocopy  NUMBER
190     , x_msg_data out nocopy  VARCHAR2
191   );
192   procedure get_formula_rate_tables(p_api_version  NUMBER
193     , p_init_msg_list  VARCHAR2
194     , p_commit  VARCHAR2
195     , p_validation_level  NUMBER
196     , p_type  VARCHAR2
197     , p_quota_id  NUMBER
198     , p_calc_formula_id  NUMBER
199     , p7_a0 out nocopy JTF_VARCHAR2_TABLE_100
200     , p7_a1 out nocopy JTF_NUMBER_TABLE
201     , p8_a0 out nocopy JTF_VARCHAR2_TABLE_100
202     , p8_a1 out nocopy JTF_NUMBER_TABLE
203     , p8_a2 out nocopy JTF_NUMBER_TABLE
204     , p8_a3 out nocopy JTF_NUMBER_TABLE
205     , p8_a4 out nocopy JTF_DATE_TABLE
206     , p8_a5 out nocopy JTF_DATE_TABLE
207     , p8_a6 out nocopy JTF_NUMBER_TABLE
208     , p8_a7 out nocopy JTF_NUMBER_TABLE
209     , p8_a8 out nocopy JTF_VARCHAR2_TABLE_100
210     , p8_a9 out nocopy JTF_VARCHAR2_TABLE_100
211     , p8_a10 out nocopy JTF_VARCHAR2_TABLE_200
212     , p8_a11 out nocopy JTF_VARCHAR2_TABLE_200
213     , p8_a12 out nocopy JTF_VARCHAR2_TABLE_200
214     , p8_a13 out nocopy JTF_VARCHAR2_TABLE_200
215     , p8_a14 out nocopy JTF_VARCHAR2_TABLE_200
216     , p8_a15 out nocopy JTF_VARCHAR2_TABLE_200
217     , p8_a16 out nocopy JTF_VARCHAR2_TABLE_200
218     , p8_a17 out nocopy JTF_VARCHAR2_TABLE_200
219     , p8_a18 out nocopy JTF_VARCHAR2_TABLE_200
220     , p8_a19 out nocopy JTF_VARCHAR2_TABLE_200
221     , p8_a20 out nocopy JTF_VARCHAR2_TABLE_200
222     , p8_a21 out nocopy JTF_VARCHAR2_TABLE_200
223     , p8_a22 out nocopy JTF_VARCHAR2_TABLE_200
224     , p8_a23 out nocopy JTF_VARCHAR2_TABLE_200
225     , p8_a24 out nocopy JTF_VARCHAR2_TABLE_200
226     , p8_a25 out nocopy JTF_NUMBER_TABLE
227     , p8_a26 out nocopy JTF_NUMBER_TABLE
228     , p8_a27 out nocopy JTF_DATE_TABLE
229     , p8_a28 out nocopy JTF_NUMBER_TABLE
230     , p8_a29 out nocopy JTF_DATE_TABLE
231     , p8_a30 out nocopy JTF_NUMBER_TABLE
232     , x_return_status out nocopy  VARCHAR2
233     , x_msg_count out nocopy  NUMBER
234     , x_msg_data out nocopy  VARCHAR2
235   );
236   procedure validate_rate_table_assignment(p_api_version  NUMBER
237     , p_init_msg_list  VARCHAR2
238     , p_commit  VARCHAR2
239     , p_validation_level  NUMBER
240     , p_action  VARCHAR2
241     , p5_a0 in out nocopy  VARCHAR2
242     , p5_a1 in out nocopy  NUMBER
243     , p5_a2 in out nocopy  NUMBER
244     , p5_a3 in out nocopy  NUMBER
245     , p5_a4 in out nocopy  DATE
246     , p5_a5 in out nocopy  DATE
247     , p5_a6 in out nocopy  NUMBER
248     , p5_a7 in out nocopy  NUMBER
249     , p5_a8 in out nocopy  VARCHAR2
250     , p5_a9 in out nocopy  VARCHAR2
251     , p5_a10 in out nocopy  VARCHAR2
252     , p5_a11 in out nocopy  VARCHAR2
253     , p5_a12 in out nocopy  VARCHAR2
254     , p5_a13 in out nocopy  VARCHAR2
255     , p5_a14 in out nocopy  VARCHAR2
256     , p5_a15 in out nocopy  VARCHAR2
257     , p5_a16 in out nocopy  VARCHAR2
258     , p5_a17 in out nocopy  VARCHAR2
259     , p5_a18 in out nocopy  VARCHAR2
260     , p5_a19 in out nocopy  VARCHAR2
261     , p5_a20 in out nocopy  VARCHAR2
262     , p5_a21 in out nocopy  VARCHAR2
263     , p5_a22 in out nocopy  VARCHAR2
264     , p5_a23 in out nocopy  VARCHAR2
265     , p5_a24 in out nocopy  VARCHAR2
266     , p5_a25 in out nocopy  NUMBER
267     , p5_a26 in out nocopy  NUMBER
268     , p5_a27 in out nocopy  DATE
269     , p5_a28 in out nocopy  NUMBER
270     , p5_a29 in out nocopy  DATE
271     , p5_a30 in out nocopy  NUMBER
272     , p6_a0  VARCHAR2
273     , p6_a1  NUMBER
274     , p6_a2  NUMBER
275     , p6_a3  NUMBER
276     , p6_a4  DATE
277     , p6_a5  DATE
278     , p6_a6  NUMBER
279     , p6_a7  NUMBER
280     , p6_a8  VARCHAR2
281     , p6_a9  VARCHAR2
282     , p6_a10  VARCHAR2
283     , p6_a11  VARCHAR2
284     , p6_a12  VARCHAR2
285     , p6_a13  VARCHAR2
286     , p6_a14  VARCHAR2
287     , p6_a15  VARCHAR2
288     , p6_a16  VARCHAR2
289     , p6_a17  VARCHAR2
290     , p6_a18  VARCHAR2
291     , p6_a19  VARCHAR2
292     , p6_a20  VARCHAR2
293     , p6_a21  VARCHAR2
294     , p6_a22  VARCHAR2
295     , p6_a23  VARCHAR2
296     , p6_a24  VARCHAR2
297     , p6_a25  NUMBER
298     , p6_a26  NUMBER
299     , p6_a27  DATE
300     , p6_a28  NUMBER
301     , p6_a29  DATE
302     , p6_a30  NUMBER
303     , x_return_status out nocopy  VARCHAR2
304     , x_msg_count out nocopy  NUMBER
305     , x_msg_data out nocopy  VARCHAR2
306   );
307 end cn_rt_quota_asgn_pvt_w;