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.
[Home] [Help]
PACKAGE: APPS.OKL_DEAL_CHARGES_PVT_W

Source


1 package okl_deal_charges_pvt_w AUTHID CURRENT_USER as
2   /* $Header: OKLEKACS.pls 120.0.12020000.2 2012/08/07 12:51:49 racheruv ship $ */
3   procedure rosetta_table_copy_in_p13(t out nocopy okl_deal_charges_pvt.fee_tbl_type, a0 JTF_NUMBER_TABLE
4     , a1 JTF_NUMBER_TABLE
5     , a2 JTF_VARCHAR2_TABLE_100
6     , a3 JTF_NUMBER_TABLE
7     , a4 JTF_VARCHAR2_TABLE_200
8     , a5 JTF_VARCHAR2_TABLE_100
9     , a6 JTF_VARCHAR2_TABLE_200
10     , a7 JTF_NUMBER_TABLE
11     , a8 JTF_VARCHAR2_TABLE_400
12     , a9 JTF_VARCHAR2_TABLE_100
13     , a10 JTF_VARCHAR2_TABLE_200
14     , a11 JTF_DATE_TABLE
15     , a12 JTF_DATE_TABLE
16     , a13 JTF_NUMBER_TABLE
17     , a14 JTF_NUMBER_TABLE
18     , a15 JTF_NUMBER_TABLE
19     , a16 JTF_NUMBER_TABLE
20     , a17 JTF_DATE_TABLE
21     , a18 JTF_VARCHAR2_TABLE_100
22     , a19 JTF_VARCHAR2_TABLE_100
23     , a20 JTF_VARCHAR2_TABLE_500
24     , a21 JTF_VARCHAR2_TABLE_500
25     , a22 JTF_VARCHAR2_TABLE_500
26     , a23 JTF_VARCHAR2_TABLE_500
27     , a24 JTF_VARCHAR2_TABLE_500
28     , a25 JTF_VARCHAR2_TABLE_500
29     , a26 JTF_VARCHAR2_TABLE_500
30     , a27 JTF_VARCHAR2_TABLE_500
31     , a28 JTF_VARCHAR2_TABLE_500
32     , a29 JTF_VARCHAR2_TABLE_500
33     , a30 JTF_VARCHAR2_TABLE_500
34     , a31 JTF_VARCHAR2_TABLE_500
35     , a32 JTF_VARCHAR2_TABLE_500
36     , a33 JTF_VARCHAR2_TABLE_500
37     , a34 JTF_VARCHAR2_TABLE_500
38     , a35 JTF_VARCHAR2_TABLE_100
39     , a36 JTF_NUMBER_TABLE
40     , a37 JTF_NUMBER_TABLE
41     , a38 JTF_VARCHAR2_TABLE_100
42     , a39 JTF_VARCHAR2_TABLE_200
43     , a40 JTF_VARCHAR2_TABLE_100
44     , a41 JTF_VARCHAR2_TABLE_100
45     , a42 JTF_NUMBER_TABLE
46     , a43 JTF_VARCHAR2_TABLE_500
47     , a44 JTF_VARCHAR2_TABLE_500
48     , a45 JTF_NUMBER_TABLE
49     );
50   procedure rosetta_table_copy_out_p13(t okl_deal_charges_pvt.fee_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
51     , a1 out nocopy JTF_NUMBER_TABLE
52     , a2 out nocopy JTF_VARCHAR2_TABLE_100
53     , a3 out nocopy JTF_NUMBER_TABLE
54     , a4 out nocopy JTF_VARCHAR2_TABLE_200
55     , a5 out nocopy JTF_VARCHAR2_TABLE_100
56     , a6 out nocopy JTF_VARCHAR2_TABLE_200
57     , a7 out nocopy JTF_NUMBER_TABLE
58     , a8 out nocopy JTF_VARCHAR2_TABLE_400
59     , a9 out nocopy JTF_VARCHAR2_TABLE_100
60     , a10 out nocopy JTF_VARCHAR2_TABLE_200
61     , a11 out nocopy JTF_DATE_TABLE
62     , a12 out nocopy JTF_DATE_TABLE
63     , a13 out nocopy JTF_NUMBER_TABLE
64     , a14 out nocopy JTF_NUMBER_TABLE
65     , a15 out nocopy JTF_NUMBER_TABLE
66     , a16 out nocopy JTF_NUMBER_TABLE
67     , a17 out nocopy JTF_DATE_TABLE
68     , a18 out nocopy JTF_VARCHAR2_TABLE_100
69     , a19 out nocopy JTF_VARCHAR2_TABLE_100
70     , a20 out nocopy JTF_VARCHAR2_TABLE_500
71     , a21 out nocopy JTF_VARCHAR2_TABLE_500
72     , a22 out nocopy JTF_VARCHAR2_TABLE_500
73     , a23 out nocopy JTF_VARCHAR2_TABLE_500
74     , a24 out nocopy JTF_VARCHAR2_TABLE_500
75     , a25 out nocopy JTF_VARCHAR2_TABLE_500
76     , a26 out nocopy JTF_VARCHAR2_TABLE_500
77     , a27 out nocopy JTF_VARCHAR2_TABLE_500
78     , a28 out nocopy JTF_VARCHAR2_TABLE_500
79     , a29 out nocopy JTF_VARCHAR2_TABLE_500
80     , a30 out nocopy JTF_VARCHAR2_TABLE_500
81     , a31 out nocopy JTF_VARCHAR2_TABLE_500
82     , a32 out nocopy JTF_VARCHAR2_TABLE_500
83     , a33 out nocopy JTF_VARCHAR2_TABLE_500
84     , a34 out nocopy JTF_VARCHAR2_TABLE_500
85     , a35 out nocopy JTF_VARCHAR2_TABLE_100
86     , a36 out nocopy JTF_NUMBER_TABLE
87     , a37 out nocopy JTF_NUMBER_TABLE
88     , a38 out nocopy JTF_VARCHAR2_TABLE_100
89     , a39 out nocopy JTF_VARCHAR2_TABLE_200
90     , a40 out nocopy JTF_VARCHAR2_TABLE_100
91     , a41 out nocopy JTF_VARCHAR2_TABLE_100
92     , a42 out nocopy JTF_NUMBER_TABLE
93     , a43 out nocopy JTF_VARCHAR2_TABLE_500
94     , a44 out nocopy JTF_VARCHAR2_TABLE_500
95     , a45 out nocopy JTF_NUMBER_TABLE
96     );
97 
98   procedure rosetta_table_copy_in_p15(t out nocopy okl_deal_charges_pvt.cov_asset_tbl_type, a0 JTF_NUMBER_TABLE
99     , a1 JTF_NUMBER_TABLE
100     , a2 JTF_NUMBER_TABLE
101     , a3 JTF_VARCHAR2_TABLE_200
102     , a4 JTF_VARCHAR2_TABLE_2000
103     , a5 JTF_NUMBER_TABLE
104     , a6 JTF_NUMBER_TABLE
105     , a7 JTF_VARCHAR2_TABLE_100
106     , a8 JTF_VARCHAR2_TABLE_200
107     , a9 JTF_VARCHAR2_TABLE_100
108     );
109   procedure rosetta_table_copy_out_p15(t okl_deal_charges_pvt.cov_asset_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
110     , a1 out nocopy JTF_NUMBER_TABLE
111     , a2 out nocopy JTF_NUMBER_TABLE
112     , a3 out nocopy JTF_VARCHAR2_TABLE_200
113     , a4 out nocopy JTF_VARCHAR2_TABLE_2000
114     , a5 out nocopy JTF_NUMBER_TABLE
115     , a6 out nocopy JTF_NUMBER_TABLE
116     , a7 out nocopy JTF_VARCHAR2_TABLE_100
117     , a8 out nocopy JTF_VARCHAR2_TABLE_200
118     , a9 out nocopy JTF_VARCHAR2_TABLE_100
119     );
120 
121   procedure allocate_amount_charges(p_api_version  NUMBER
122     , p_init_msg_list  VARCHAR2
123     , x_return_status out nocopy  VARCHAR2
124     , x_msg_count out nocopy  NUMBER
125     , x_msg_data out nocopy  VARCHAR2
126     , p_chr_id  NUMBER
127     , p_cle_id  NUMBER
128     , p_amount  NUMBER
129     , p_mode  VARCHAR2
130     , p9_a0 out nocopy JTF_NUMBER_TABLE
131     , p9_a1 out nocopy JTF_NUMBER_TABLE
132     , p9_a2 out nocopy JTF_NUMBER_TABLE
133     , p9_a3 out nocopy JTF_VARCHAR2_TABLE_200
134     , p9_a4 out nocopy JTF_VARCHAR2_TABLE_2000
135     , p9_a5 out nocopy JTF_NUMBER_TABLE
136     , p9_a6 out nocopy JTF_NUMBER_TABLE
137     , p9_a7 out nocopy JTF_VARCHAR2_TABLE_100
138     , p9_a8 out nocopy JTF_VARCHAR2_TABLE_200
139     , p9_a9 out nocopy JTF_VARCHAR2_TABLE_100
140   );
141   procedure create_fee(p_api_version  NUMBER
142     , p_init_msg_list  VARCHAR2
143     , x_return_status out nocopy  VARCHAR2
144     , x_msg_count out nocopy  NUMBER
145     , x_msg_data out nocopy  VARCHAR2
146     , p5_a0  NUMBER
147     , p5_a1  NUMBER
148     , p5_a2  VARCHAR2
149     , p5_a3  NUMBER
150     , p5_a4  VARCHAR2
151     , p5_a5  VARCHAR2
152     , p5_a6  VARCHAR2
153     , p5_a7  NUMBER
154     , p5_a8  VARCHAR2
155     , p5_a9  VARCHAR2
156     , p5_a10  VARCHAR2
157     , p5_a11  DATE
158     , p5_a12  DATE
159     , p5_a13  NUMBER
160     , p5_a14  NUMBER
161     , p5_a15  NUMBER
162     , p5_a16  NUMBER
163     , p5_a17  DATE
164     , p5_a18  VARCHAR2
165     , p5_a19  VARCHAR2
166     , p5_a20  VARCHAR2
167     , p5_a21  VARCHAR2
168     , p5_a22  VARCHAR2
169     , p5_a23  VARCHAR2
170     , p5_a24  VARCHAR2
171     , p5_a25  VARCHAR2
172     , p5_a26  VARCHAR2
173     , p5_a27  VARCHAR2
174     , p5_a28  VARCHAR2
175     , p5_a29  VARCHAR2
176     , p5_a30  VARCHAR2
177     , p5_a31  VARCHAR2
178     , p5_a32  VARCHAR2
179     , p5_a33  VARCHAR2
180     , p5_a34  VARCHAR2
181     , p5_a35  VARCHAR2
182     , p5_a36  NUMBER
183     , p5_a37  NUMBER
184     , p5_a38  VARCHAR2
185     , p5_a39  VARCHAR2
186     , p5_a40  VARCHAR2
187     , p5_a41  VARCHAR2
188     , p5_a42  NUMBER
189     , p5_a43  VARCHAR2
190     , p5_a44  VARCHAR2
191     , p5_a45  NUMBER
192     , p6_a0 out nocopy  NUMBER
193     , p6_a1 out nocopy  NUMBER
194     , p6_a2 out nocopy  VARCHAR2
195     , p6_a3 out nocopy  NUMBER
196     , p6_a4 out nocopy  VARCHAR2
197     , p6_a5 out nocopy  VARCHAR2
198     , p6_a6 out nocopy  VARCHAR2
199     , p6_a7 out nocopy  NUMBER
200     , p6_a8 out nocopy  VARCHAR2
201     , p6_a9 out nocopy  VARCHAR2
202     , p6_a10 out nocopy  VARCHAR2
203     , p6_a11 out nocopy  DATE
204     , p6_a12 out nocopy  DATE
205     , p6_a13 out nocopy  NUMBER
206     , p6_a14 out nocopy  NUMBER
207     , p6_a15 out nocopy  NUMBER
208     , p6_a16 out nocopy  NUMBER
209     , p6_a17 out nocopy  DATE
210     , p6_a18 out nocopy  VARCHAR2
211     , p6_a19 out nocopy  VARCHAR2
212     , p6_a20 out nocopy  VARCHAR2
213     , p6_a21 out nocopy  VARCHAR2
214     , p6_a22 out nocopy  VARCHAR2
215     , p6_a23 out nocopy  VARCHAR2
216     , p6_a24 out nocopy  VARCHAR2
217     , p6_a25 out nocopy  VARCHAR2
218     , p6_a26 out nocopy  VARCHAR2
219     , p6_a27 out nocopy  VARCHAR2
220     , p6_a28 out nocopy  VARCHAR2
221     , p6_a29 out nocopy  VARCHAR2
222     , p6_a30 out nocopy  VARCHAR2
223     , p6_a31 out nocopy  VARCHAR2
224     , p6_a32 out nocopy  VARCHAR2
225     , p6_a33 out nocopy  VARCHAR2
226     , p6_a34 out nocopy  VARCHAR2
227     , p6_a35 out nocopy  VARCHAR2
228     , p6_a36 out nocopy  NUMBER
229     , p6_a37 out nocopy  NUMBER
230     , p6_a38 out nocopy  VARCHAR2
231     , p6_a39 out nocopy  VARCHAR2
232     , p6_a40 out nocopy  VARCHAR2
233     , p6_a41 out nocopy  VARCHAR2
234     , p6_a42 out nocopy  NUMBER
235     , p6_a43 out nocopy  VARCHAR2
236     , p6_a44 out nocopy  VARCHAR2
237     , p6_a45 out nocopy  NUMBER
238   );
239   procedure update_fee(p_api_version  NUMBER
240     , p_init_msg_list  VARCHAR2
241     , x_return_status out nocopy  VARCHAR2
242     , x_msg_count out nocopy  NUMBER
243     , x_msg_data out nocopy  VARCHAR2
244     , p5_a0  NUMBER
245     , p5_a1  NUMBER
246     , p5_a2  VARCHAR2
247     , p5_a3  NUMBER
248     , p5_a4  VARCHAR2
249     , p5_a5  VARCHAR2
250     , p5_a6  VARCHAR2
251     , p5_a7  NUMBER
252     , p5_a8  VARCHAR2
253     , p5_a9  VARCHAR2
254     , p5_a10  VARCHAR2
255     , p5_a11  DATE
256     , p5_a12  DATE
257     , p5_a13  NUMBER
258     , p5_a14  NUMBER
259     , p5_a15  NUMBER
260     , p5_a16  NUMBER
261     , p5_a17  DATE
262     , p5_a18  VARCHAR2
263     , p5_a19  VARCHAR2
264     , p5_a20  VARCHAR2
265     , p5_a21  VARCHAR2
266     , p5_a22  VARCHAR2
267     , p5_a23  VARCHAR2
268     , p5_a24  VARCHAR2
269     , p5_a25  VARCHAR2
270     , p5_a26  VARCHAR2
271     , p5_a27  VARCHAR2
272     , p5_a28  VARCHAR2
273     , p5_a29  VARCHAR2
274     , p5_a30  VARCHAR2
275     , p5_a31  VARCHAR2
276     , p5_a32  VARCHAR2
277     , p5_a33  VARCHAR2
278     , p5_a34  VARCHAR2
279     , p5_a35  VARCHAR2
280     , p5_a36  NUMBER
281     , p5_a37  NUMBER
282     , p5_a38  VARCHAR2
283     , p5_a39  VARCHAR2
284     , p5_a40  VARCHAR2
285     , p5_a41  VARCHAR2
286     , p5_a42  NUMBER
287     , p5_a43  VARCHAR2
288     , p5_a44  VARCHAR2
289     , p5_a45  NUMBER
290     , p6_a0 out nocopy  NUMBER
291     , p6_a1 out nocopy  NUMBER
292     , p6_a2 out nocopy  VARCHAR2
293     , p6_a3 out nocopy  NUMBER
294     , p6_a4 out nocopy  VARCHAR2
295     , p6_a5 out nocopy  VARCHAR2
296     , p6_a6 out nocopy  VARCHAR2
297     , p6_a7 out nocopy  NUMBER
298     , p6_a8 out nocopy  VARCHAR2
299     , p6_a9 out nocopy  VARCHAR2
300     , p6_a10 out nocopy  VARCHAR2
301     , p6_a11 out nocopy  DATE
302     , p6_a12 out nocopy  DATE
303     , p6_a13 out nocopy  NUMBER
304     , p6_a14 out nocopy  NUMBER
305     , p6_a15 out nocopy  NUMBER
306     , p6_a16 out nocopy  NUMBER
307     , p6_a17 out nocopy  DATE
308     , p6_a18 out nocopy  VARCHAR2
309     , p6_a19 out nocopy  VARCHAR2
310     , p6_a20 out nocopy  VARCHAR2
311     , p6_a21 out nocopy  VARCHAR2
312     , p6_a22 out nocopy  VARCHAR2
313     , p6_a23 out nocopy  VARCHAR2
314     , p6_a24 out nocopy  VARCHAR2
315     , p6_a25 out nocopy  VARCHAR2
316     , p6_a26 out nocopy  VARCHAR2
317     , p6_a27 out nocopy  VARCHAR2
318     , p6_a28 out nocopy  VARCHAR2
319     , p6_a29 out nocopy  VARCHAR2
320     , p6_a30 out nocopy  VARCHAR2
321     , p6_a31 out nocopy  VARCHAR2
322     , p6_a32 out nocopy  VARCHAR2
323     , p6_a33 out nocopy  VARCHAR2
324     , p6_a34 out nocopy  VARCHAR2
325     , p6_a35 out nocopy  VARCHAR2
326     , p6_a36 out nocopy  NUMBER
327     , p6_a37 out nocopy  NUMBER
328     , p6_a38 out nocopy  VARCHAR2
329     , p6_a39 out nocopy  VARCHAR2
330     , p6_a40 out nocopy  VARCHAR2
331     , p6_a41 out nocopy  VARCHAR2
332     , p6_a42 out nocopy  NUMBER
333     , p6_a43 out nocopy  VARCHAR2
334     , p6_a44 out nocopy  VARCHAR2
335     , p6_a45 out nocopy  NUMBER
336   );
337   end okl_deal_charges_pvt_w;