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.OKL_LEASE_QUOTE_FEE_PVT_W

Source


1 package okl_lease_quote_fee_pvt_w as
2   /* $Header: OKLEQUFS.pls 120.6 2006/03/16 10:09:34 asawanka noship $ */
3   procedure rosetta_table_copy_in_p24(t out nocopy okl_lease_quote_fee_pvt.line_relation_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_100
8     , a5 JTF_NUMBER_TABLE
9     , a6 JTF_NUMBER_TABLE
10     , a7 JTF_VARCHAR2_TABLE_300
11     , a8 JTF_VARCHAR2_TABLE_2000
12     , a9 JTF_VARCHAR2_TABLE_2000
13     , a10 JTF_VARCHAR2_TABLE_100
14     );
15   procedure rosetta_table_copy_out_p24(t okl_lease_quote_fee_pvt.line_relation_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
16     , a1 out nocopy JTF_NUMBER_TABLE
17     , a2 out nocopy JTF_VARCHAR2_TABLE_100
18     , a3 out nocopy JTF_NUMBER_TABLE
19     , a4 out nocopy JTF_VARCHAR2_TABLE_100
20     , a5 out nocopy JTF_NUMBER_TABLE
21     , a6 out nocopy JTF_NUMBER_TABLE
22     , a7 out nocopy JTF_VARCHAR2_TABLE_300
23     , a8 out nocopy JTF_VARCHAR2_TABLE_2000
24     , a9 out nocopy JTF_VARCHAR2_TABLE_2000
25     , a10 out nocopy JTF_VARCHAR2_TABLE_100
26     );
27 
28   procedure create_fee(p_api_version  NUMBER
29     , p_init_msg_list  VARCHAR2
30     , p_transaction_control  VARCHAR2
31     , p3_a0  NUMBER
32     , p3_a1  NUMBER
33     , p3_a2  VARCHAR2
34     , p3_a3  VARCHAR2
35     , p3_a4  VARCHAR2
36     , p3_a5  VARCHAR2
37     , p3_a6  VARCHAR2
38     , p3_a7  VARCHAR2
39     , p3_a8  VARCHAR2
40     , p3_a9  VARCHAR2
41     , p3_a10  VARCHAR2
42     , p3_a11  VARCHAR2
43     , p3_a12  VARCHAR2
44     , p3_a13  VARCHAR2
45     , p3_a14  VARCHAR2
46     , p3_a15  VARCHAR2
47     , p3_a16  VARCHAR2
48     , p3_a17  VARCHAR2
49     , p3_a18  VARCHAR2
50     , p3_a19  NUMBER
51     , p3_a20  NUMBER
52     , p3_a21  VARCHAR2
53     , p3_a22  VARCHAR2
54     , p3_a23  NUMBER
55     , p3_a24  NUMBER
56     , p3_a25  NUMBER
57     , p3_a26  VARCHAR2
58     , p3_a27  DATE
59     , p3_a28  DATE
60     , p3_a29  NUMBER
61     , p3_a30  NUMBER
62     , p3_a31  NUMBER
63     , p3_a32  NUMBER
64     , p3_a33  NUMBER
65     , p3_a34  VARCHAR2
66     , p3_a35  VARCHAR2
67     , p3_a36  VARCHAR2
68     , p3_a37  VARCHAR2
69     , p3_a38  NUMBER
70     , p4_a0 JTF_NUMBER_TABLE
71     , p4_a1 JTF_NUMBER_TABLE
72     , p4_a2 JTF_VARCHAR2_TABLE_100
73     , p4_a3 JTF_NUMBER_TABLE
74     , p4_a4 JTF_VARCHAR2_TABLE_100
75     , p4_a5 JTF_NUMBER_TABLE
76     , p4_a6 JTF_NUMBER_TABLE
77     , p4_a7 JTF_VARCHAR2_TABLE_300
78     , p4_a8 JTF_VARCHAR2_TABLE_2000
79     , p4_a9 JTF_VARCHAR2_TABLE_2000
80     , p4_a10 JTF_VARCHAR2_TABLE_100
81     , p5_a0  VARCHAR2
82     , p5_a1  NUMBER
83     , p5_a2  VARCHAR2
84     , p5_a3  VARCHAR2
85     , p5_a4  VARCHAR2
86     , p5_a5  VARCHAR2
87     , p5_a6  VARCHAR2
88     , p5_a7  VARCHAR2
89     , p5_a8  NUMBER
90     , p5_a9  VARCHAR2
91     , p5_a10  NUMBER
92     , p5_a11  NUMBER
93     , p5_a12  NUMBER
94     , p5_a13  NUMBER
95     , p6_a0 JTF_NUMBER_TABLE
96     , p6_a1 JTF_DATE_TABLE
97     , p6_a2 JTF_NUMBER_TABLE
98     , p6_a3 JTF_NUMBER_TABLE
99     , p6_a4 JTF_NUMBER_TABLE
100     , p6_a5 JTF_NUMBER_TABLE
101     , p6_a6 JTF_NUMBER_TABLE
102     , p6_a7 JTF_NUMBER_TABLE
103     , p6_a8 JTF_VARCHAR2_TABLE_100
104     , p6_a9 JTF_VARCHAR2_TABLE_100
105     , p7_a0  VARCHAR2
106     , p7_a1  NUMBER
107     , p7_a2  VARCHAR2
108     , p7_a3  VARCHAR2
109     , p7_a4  VARCHAR2
110     , p7_a5  VARCHAR2
111     , p7_a6  VARCHAR2
112     , p7_a7  VARCHAR2
113     , p7_a8  NUMBER
114     , p7_a9  VARCHAR2
115     , p7_a10  NUMBER
116     , p7_a11  NUMBER
117     , p7_a12  NUMBER
118     , p7_a13  NUMBER
119     , p8_a0 JTF_NUMBER_TABLE
120     , p8_a1 JTF_DATE_TABLE
121     , p8_a2 JTF_NUMBER_TABLE
122     , p8_a3 JTF_NUMBER_TABLE
123     , p8_a4 JTF_NUMBER_TABLE
124     , p8_a5 JTF_NUMBER_TABLE
125     , p8_a6 JTF_NUMBER_TABLE
126     , p8_a7 JTF_NUMBER_TABLE
127     , p8_a8 JTF_VARCHAR2_TABLE_100
128     , p8_a9 JTF_VARCHAR2_TABLE_100
129     , x_fee_id out nocopy  NUMBER
130     , x_return_status out nocopy  VARCHAR2
131     , x_msg_count out nocopy  NUMBER
132     , x_msg_data out nocopy  VARCHAR2
133   );
134   procedure update_fee(p_api_version  NUMBER
135     , p_init_msg_list  VARCHAR2
136     , p_transaction_control  VARCHAR2
137     , p3_a0  NUMBER
138     , p3_a1  NUMBER
139     , p3_a2  VARCHAR2
140     , p3_a3  VARCHAR2
141     , p3_a4  VARCHAR2
142     , p3_a5  VARCHAR2
143     , p3_a6  VARCHAR2
144     , p3_a7  VARCHAR2
145     , p3_a8  VARCHAR2
146     , p3_a9  VARCHAR2
147     , p3_a10  VARCHAR2
148     , p3_a11  VARCHAR2
149     , p3_a12  VARCHAR2
150     , p3_a13  VARCHAR2
151     , p3_a14  VARCHAR2
152     , p3_a15  VARCHAR2
153     , p3_a16  VARCHAR2
154     , p3_a17  VARCHAR2
155     , p3_a18  VARCHAR2
156     , p3_a19  NUMBER
157     , p3_a20  NUMBER
158     , p3_a21  VARCHAR2
159     , p3_a22  VARCHAR2
160     , p3_a23  NUMBER
161     , p3_a24  NUMBER
162     , p3_a25  NUMBER
163     , p3_a26  VARCHAR2
164     , p3_a27  DATE
165     , p3_a28  DATE
166     , p3_a29  NUMBER
167     , p3_a30  NUMBER
168     , p3_a31  NUMBER
169     , p3_a32  NUMBER
170     , p3_a33  NUMBER
171     , p3_a34  VARCHAR2
172     , p3_a35  VARCHAR2
173     , p3_a36  VARCHAR2
174     , p3_a37  VARCHAR2
175     , p3_a38  NUMBER
176     , p_sync_fee_header  VARCHAR2
177     , p_sync_line_relations  VARCHAR2
178     , x_return_status out nocopy  VARCHAR2
179     , x_msg_count out nocopy  NUMBER
180     , x_msg_data out nocopy  VARCHAR2
181   );
182   procedure update_fee(p_api_version  NUMBER
183     , p_init_msg_list  VARCHAR2
184     , p_transaction_control  VARCHAR2
185     , p3_a0  NUMBER
186     , p3_a1  NUMBER
187     , p3_a2  VARCHAR2
188     , p3_a3  VARCHAR2
189     , p3_a4  VARCHAR2
190     , p3_a5  VARCHAR2
191     , p3_a6  VARCHAR2
192     , p3_a7  VARCHAR2
193     , p3_a8  VARCHAR2
194     , p3_a9  VARCHAR2
195     , p3_a10  VARCHAR2
196     , p3_a11  VARCHAR2
197     , p3_a12  VARCHAR2
198     , p3_a13  VARCHAR2
199     , p3_a14  VARCHAR2
200     , p3_a15  VARCHAR2
201     , p3_a16  VARCHAR2
202     , p3_a17  VARCHAR2
203     , p3_a18  VARCHAR2
204     , p3_a19  NUMBER
205     , p3_a20  NUMBER
206     , p3_a21  VARCHAR2
207     , p3_a22  VARCHAR2
208     , p3_a23  NUMBER
209     , p3_a24  NUMBER
210     , p3_a25  NUMBER
211     , p3_a26  VARCHAR2
212     , p3_a27  DATE
213     , p3_a28  DATE
214     , p3_a29  NUMBER
215     , p3_a30  NUMBER
216     , p3_a31  NUMBER
217     , p3_a32  NUMBER
218     , p3_a33  NUMBER
219     , p3_a34  VARCHAR2
220     , p3_a35  VARCHAR2
221     , p3_a36  VARCHAR2
222     , p3_a37  VARCHAR2
223     , p3_a38  NUMBER
224     , p4_a0 JTF_NUMBER_TABLE
225     , p4_a1 JTF_NUMBER_TABLE
226     , p4_a2 JTF_VARCHAR2_TABLE_100
227     , p4_a3 JTF_NUMBER_TABLE
228     , p4_a4 JTF_VARCHAR2_TABLE_100
229     , p4_a5 JTF_NUMBER_TABLE
230     , p4_a6 JTF_NUMBER_TABLE
231     , p4_a7 JTF_VARCHAR2_TABLE_300
232     , p4_a8 JTF_VARCHAR2_TABLE_2000
233     , p4_a9 JTF_VARCHAR2_TABLE_2000
234     , p4_a10 JTF_VARCHAR2_TABLE_100
235     , p5_a0  VARCHAR2
236     , p5_a1  NUMBER
237     , p5_a2  VARCHAR2
238     , p5_a3  VARCHAR2
239     , p5_a4  VARCHAR2
240     , p5_a5  VARCHAR2
241     , p5_a6  VARCHAR2
242     , p5_a7  VARCHAR2
243     , p5_a8  NUMBER
244     , p5_a9  VARCHAR2
245     , p5_a10  NUMBER
246     , p5_a11  NUMBER
247     , p5_a12  NUMBER
248     , p5_a13  NUMBER
249     , p6_a0 JTF_NUMBER_TABLE
250     , p6_a1 JTF_DATE_TABLE
251     , p6_a2 JTF_NUMBER_TABLE
252     , p6_a3 JTF_NUMBER_TABLE
253     , p6_a4 JTF_NUMBER_TABLE
254     , p6_a5 JTF_NUMBER_TABLE
255     , p6_a6 JTF_NUMBER_TABLE
256     , p6_a7 JTF_NUMBER_TABLE
257     , p6_a8 JTF_VARCHAR2_TABLE_100
258     , p6_a9 JTF_VARCHAR2_TABLE_100
259     , p7_a0  VARCHAR2
260     , p7_a1  NUMBER
261     , p7_a2  VARCHAR2
262     , p7_a3  VARCHAR2
263     , p7_a4  VARCHAR2
264     , p7_a5  VARCHAR2
265     , p7_a6  VARCHAR2
266     , p7_a7  VARCHAR2
267     , p7_a8  NUMBER
268     , p7_a9  VARCHAR2
269     , p7_a10  NUMBER
270     , p7_a11  NUMBER
271     , p7_a12  NUMBER
272     , p7_a13  NUMBER
273     , p8_a0 JTF_NUMBER_TABLE
274     , p8_a1 JTF_DATE_TABLE
275     , p8_a2 JTF_NUMBER_TABLE
276     , p8_a3 JTF_NUMBER_TABLE
277     , p8_a4 JTF_NUMBER_TABLE
278     , p8_a5 JTF_NUMBER_TABLE
279     , p8_a6 JTF_NUMBER_TABLE
280     , p8_a7 JTF_NUMBER_TABLE
281     , p8_a8 JTF_VARCHAR2_TABLE_100
282     , p8_a9 JTF_VARCHAR2_TABLE_100
283     , x_return_status out nocopy  VARCHAR2
284     , x_msg_count out nocopy  NUMBER
285     , x_msg_data out nocopy  VARCHAR2
286   );
287   procedure duplicate_fee(p_api_version  NUMBER
288     , p_init_msg_list  VARCHAR2
289     , p_transaction_control  VARCHAR2
290     , p_source_fee_id  NUMBER
291     , p4_a0  NUMBER
292     , p4_a1  NUMBER
293     , p4_a2  VARCHAR2
294     , p4_a3  VARCHAR2
295     , p4_a4  VARCHAR2
296     , p4_a5  VARCHAR2
297     , p4_a6  VARCHAR2
298     , p4_a7  VARCHAR2
299     , p4_a8  VARCHAR2
300     , p4_a9  VARCHAR2
301     , p4_a10  VARCHAR2
302     , p4_a11  VARCHAR2
303     , p4_a12  VARCHAR2
304     , p4_a13  VARCHAR2
305     , p4_a14  VARCHAR2
306     , p4_a15  VARCHAR2
307     , p4_a16  VARCHAR2
308     , p4_a17  VARCHAR2
309     , p4_a18  VARCHAR2
310     , p4_a19  NUMBER
311     , p4_a20  NUMBER
312     , p4_a21  VARCHAR2
313     , p4_a22  VARCHAR2
314     , p4_a23  NUMBER
315     , p4_a24  NUMBER
316     , p4_a25  NUMBER
317     , p4_a26  VARCHAR2
318     , p4_a27  DATE
319     , p4_a28  DATE
320     , p4_a29  NUMBER
321     , p4_a30  NUMBER
322     , p4_a31  NUMBER
323     , p4_a32  NUMBER
324     , p4_a33  NUMBER
325     , p4_a34  VARCHAR2
326     , p4_a35  VARCHAR2
327     , p4_a36  VARCHAR2
328     , p4_a37  VARCHAR2
329     , p4_a38  NUMBER
330     , p5_a0 JTF_NUMBER_TABLE
331     , p5_a1 JTF_NUMBER_TABLE
332     , p5_a2 JTF_VARCHAR2_TABLE_100
333     , p5_a3 JTF_NUMBER_TABLE
334     , p5_a4 JTF_VARCHAR2_TABLE_100
335     , p5_a5 JTF_NUMBER_TABLE
336     , p5_a6 JTF_NUMBER_TABLE
337     , p5_a7 JTF_VARCHAR2_TABLE_300
338     , p5_a8 JTF_VARCHAR2_TABLE_2000
339     , p5_a9 JTF_VARCHAR2_TABLE_2000
340     , p5_a10 JTF_VARCHAR2_TABLE_100
341     , p6_a0  VARCHAR2
342     , p6_a1  NUMBER
343     , p6_a2  VARCHAR2
344     , p6_a3  VARCHAR2
345     , p6_a4  VARCHAR2
346     , p6_a5  VARCHAR2
347     , p6_a6  VARCHAR2
348     , p6_a7  VARCHAR2
349     , p6_a8  NUMBER
350     , p6_a9  VARCHAR2
351     , p6_a10  NUMBER
352     , p6_a11  NUMBER
353     , p6_a12  NUMBER
354     , p6_a13  NUMBER
355     , p7_a0 JTF_NUMBER_TABLE
356     , p7_a1 JTF_DATE_TABLE
357     , p7_a2 JTF_NUMBER_TABLE
358     , p7_a3 JTF_NUMBER_TABLE
359     , p7_a4 JTF_NUMBER_TABLE
360     , p7_a5 JTF_NUMBER_TABLE
361     , p7_a6 JTF_NUMBER_TABLE
362     , p7_a7 JTF_NUMBER_TABLE
363     , p7_a8 JTF_VARCHAR2_TABLE_100
364     , p7_a9 JTF_VARCHAR2_TABLE_100
365     , p8_a0  VARCHAR2
366     , p8_a1  NUMBER
367     , p8_a2  VARCHAR2
368     , p8_a3  VARCHAR2
369     , p8_a4  VARCHAR2
370     , p8_a5  VARCHAR2
371     , p8_a6  VARCHAR2
372     , p8_a7  VARCHAR2
373     , p8_a8  NUMBER
374     , p8_a9  VARCHAR2
375     , p8_a10  NUMBER
376     , p8_a11  NUMBER
377     , p8_a12  NUMBER
378     , p8_a13  NUMBER
379     , p9_a0 JTF_NUMBER_TABLE
380     , p9_a1 JTF_DATE_TABLE
381     , p9_a2 JTF_NUMBER_TABLE
382     , p9_a3 JTF_NUMBER_TABLE
383     , p9_a4 JTF_NUMBER_TABLE
384     , p9_a5 JTF_NUMBER_TABLE
385     , p9_a6 JTF_NUMBER_TABLE
386     , p9_a7 JTF_NUMBER_TABLE
387     , p9_a8 JTF_VARCHAR2_TABLE_100
388     , p9_a9 JTF_VARCHAR2_TABLE_100
389     , x_fee_id out nocopy  NUMBER
390     , x_return_status out nocopy  VARCHAR2
391     , x_msg_count out nocopy  NUMBER
392     , x_msg_data out nocopy  VARCHAR2
393   );
394 end okl_lease_quote_fee_pvt_w;