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

Source


1 package lns_fee_engine_w as
2   /* $Header: LNS_FEE_ENGINJ_S.pls 120.3 2005/08/02 14:37 raverma noship $ */
3   procedure rosetta_table_copy_in_p1(t out nocopy lns_fee_engine.fee_basis_tbl, a0 JTF_VARCHAR2_TABLE_100
4     , a1 JTF_NUMBER_TABLE
5     );
6   procedure rosetta_table_copy_out_p1(t lns_fee_engine.fee_basis_tbl, 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 lns_fee_engine.fee_structure_tbl, a0 JTF_NUMBER_TABLE
11     , a1 JTF_VARCHAR2_TABLE_100
12     , a2 JTF_VARCHAR2_TABLE_300
13     , a3 JTF_VARCHAR2_TABLE_100
14     , a4 JTF_VARCHAR2_TABLE_100
15     , a5 JTF_NUMBER_TABLE
16     , a6 JTF_VARCHAR2_TABLE_100
17     , a7 JTF_DATE_TABLE
18     , a8 JTF_DATE_TABLE
19     , a9 JTF_NUMBER_TABLE
20     , a10 JTF_VARCHAR2_TABLE_100
21     , a11 JTF_VARCHAR2_TABLE_100
22     , a12 JTF_NUMBER_TABLE
23     , a13 JTF_NUMBER_TABLE
24     , a14 JTF_VARCHAR2_TABLE_100
25     , a15 JTF_VARCHAR2_TABLE_100
26     , a16 JTF_VARCHAR2_TABLE_100
27     , a17 JTF_NUMBER_TABLE
28     , a18 JTF_VARCHAR2_TABLE_100
29     , a19 JTF_VARCHAR2_TABLE_100
30     , a20 JTF_NUMBER_TABLE
31     , a21 JTF_NUMBER_TABLE
32     , a22 JTF_DATE_TABLE
33     );
34   procedure rosetta_table_copy_out_p3(t lns_fee_engine.fee_structure_tbl, a0 out nocopy JTF_NUMBER_TABLE
35     , a1 out nocopy JTF_VARCHAR2_TABLE_100
36     , a2 out nocopy JTF_VARCHAR2_TABLE_300
37     , a3 out nocopy JTF_VARCHAR2_TABLE_100
38     , a4 out nocopy JTF_VARCHAR2_TABLE_100
39     , a5 out nocopy JTF_NUMBER_TABLE
40     , a6 out nocopy JTF_VARCHAR2_TABLE_100
41     , a7 out nocopy JTF_DATE_TABLE
42     , a8 out nocopy JTF_DATE_TABLE
43     , a9 out nocopy JTF_NUMBER_TABLE
44     , a10 out nocopy JTF_VARCHAR2_TABLE_100
45     , a11 out nocopy JTF_VARCHAR2_TABLE_100
46     , a12 out nocopy JTF_NUMBER_TABLE
47     , a13 out nocopy JTF_NUMBER_TABLE
48     , a14 out nocopy JTF_VARCHAR2_TABLE_100
49     , a15 out nocopy JTF_VARCHAR2_TABLE_100
50     , a16 out nocopy JTF_VARCHAR2_TABLE_100
51     , a17 out nocopy JTF_NUMBER_TABLE
52     , a18 out nocopy JTF_VARCHAR2_TABLE_100
53     , a19 out nocopy JTF_VARCHAR2_TABLE_100
54     , a20 out nocopy JTF_NUMBER_TABLE
55     , a21 out nocopy JTF_NUMBER_TABLE
56     , a22 out nocopy JTF_DATE_TABLE
57     );
58 
59   procedure rosetta_table_copy_in_p5(t out nocopy lns_fee_engine.fee_calc_tbl, a0 JTF_NUMBER_TABLE
60     , a1 JTF_VARCHAR2_TABLE_100
61     , a2 JTF_VARCHAR2_TABLE_100
62     , a3 JTF_VARCHAR2_TABLE_100
63     , a4 JTF_NUMBER_TABLE
64     , a5 JTF_NUMBER_TABLE
65     , a6 JTF_VARCHAR2_TABLE_300
66     , a7 JTF_NUMBER_TABLE
67     , a8 JTF_VARCHAR2_TABLE_100
68     , a9 JTF_VARCHAR2_TABLE_100
69     , a10 JTF_VARCHAR2_TABLE_100
70     , a11 JTF_NUMBER_TABLE
71     , a12 JTF_VARCHAR2_TABLE_100
72     , a13 JTF_VARCHAR2_TABLE_100
73     , a14 JTF_NUMBER_TABLE
74     );
75   procedure rosetta_table_copy_out_p5(t lns_fee_engine.fee_calc_tbl, a0 out nocopy JTF_NUMBER_TABLE
76     , a1 out nocopy JTF_VARCHAR2_TABLE_100
77     , a2 out nocopy JTF_VARCHAR2_TABLE_100
78     , a3 out nocopy JTF_VARCHAR2_TABLE_100
79     , a4 out nocopy JTF_NUMBER_TABLE
80     , a5 out nocopy JTF_NUMBER_TABLE
81     , a6 out nocopy JTF_VARCHAR2_TABLE_300
82     , a7 out nocopy JTF_NUMBER_TABLE
83     , a8 out nocopy JTF_VARCHAR2_TABLE_100
84     , a9 out nocopy JTF_VARCHAR2_TABLE_100
85     , a10 out nocopy JTF_VARCHAR2_TABLE_100
86     , a11 out nocopy JTF_NUMBER_TABLE
87     , a12 out nocopy JTF_VARCHAR2_TABLE_100
88     , a13 out nocopy JTF_VARCHAR2_TABLE_100
89     , a14 out nocopy JTF_NUMBER_TABLE
90     );
91 
92   procedure calculatefees(p_loan_id  NUMBER
93     , p1_a0 JTF_VARCHAR2_TABLE_100
94     , p1_a1 JTF_NUMBER_TABLE
95     , p_installment  NUMBER
96     , p3_a0 JTF_NUMBER_TABLE
97     , p3_a1 JTF_VARCHAR2_TABLE_100
98     , p3_a2 JTF_VARCHAR2_TABLE_300
99     , p3_a3 JTF_VARCHAR2_TABLE_100
100     , p3_a4 JTF_VARCHAR2_TABLE_100
101     , p3_a5 JTF_NUMBER_TABLE
102     , p3_a6 JTF_VARCHAR2_TABLE_100
103     , p3_a7 JTF_DATE_TABLE
104     , p3_a8 JTF_DATE_TABLE
105     , p3_a9 JTF_NUMBER_TABLE
106     , p3_a10 JTF_VARCHAR2_TABLE_100
107     , p3_a11 JTF_VARCHAR2_TABLE_100
108     , p3_a12 JTF_NUMBER_TABLE
109     , p3_a13 JTF_NUMBER_TABLE
110     , p3_a14 JTF_VARCHAR2_TABLE_100
111     , p3_a15 JTF_VARCHAR2_TABLE_100
112     , p3_a16 JTF_VARCHAR2_TABLE_100
113     , p3_a17 JTF_NUMBER_TABLE
114     , p3_a18 JTF_VARCHAR2_TABLE_100
115     , p3_a19 JTF_VARCHAR2_TABLE_100
116     , p3_a20 JTF_NUMBER_TABLE
117     , p3_a21 JTF_NUMBER_TABLE
118     , p3_a22 JTF_DATE_TABLE
119     , p4_a0 out nocopy JTF_NUMBER_TABLE
120     , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
121     , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
122     , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
123     , p4_a4 out nocopy JTF_NUMBER_TABLE
124     , p4_a5 out nocopy JTF_NUMBER_TABLE
125     , p4_a6 out nocopy JTF_VARCHAR2_TABLE_300
126     , p4_a7 out nocopy JTF_NUMBER_TABLE
127     , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
128     , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
129     , p4_a10 out nocopy JTF_VARCHAR2_TABLE_100
130     , p4_a11 out nocopy JTF_NUMBER_TABLE
131     , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
132     , p4_a13 out nocopy JTF_VARCHAR2_TABLE_100
133     , p4_a14 out nocopy JTF_NUMBER_TABLE
134     , x_return_status out nocopy  VARCHAR2
135     , x_msg_count out nocopy  NUMBER
136     , x_msg_data out nocopy  VARCHAR2
137   );
138   procedure writefeeschedule(p_init_msg_list  VARCHAR2
139     , p_commit  VARCHAR2
140     , p_loan_id  NUMBER
141     , p3_a0 in out nocopy JTF_NUMBER_TABLE
142     , p3_a1 in out nocopy JTF_VARCHAR2_TABLE_100
143     , p3_a2 in out nocopy JTF_VARCHAR2_TABLE_100
144     , p3_a3 in out nocopy JTF_VARCHAR2_TABLE_100
145     , p3_a4 in out nocopy JTF_NUMBER_TABLE
146     , p3_a5 in out nocopy JTF_NUMBER_TABLE
147     , p3_a6 in out nocopy JTF_VARCHAR2_TABLE_300
148     , p3_a7 in out nocopy JTF_NUMBER_TABLE
149     , p3_a8 in out nocopy JTF_VARCHAR2_TABLE_100
150     , p3_a9 in out nocopy JTF_VARCHAR2_TABLE_100
151     , p3_a10 in out nocopy JTF_VARCHAR2_TABLE_100
152     , p3_a11 in out nocopy JTF_NUMBER_TABLE
153     , p3_a12 in out nocopy JTF_VARCHAR2_TABLE_100
154     , p3_a13 in out nocopy JTF_VARCHAR2_TABLE_100
155     , p3_a14 in out nocopy JTF_NUMBER_TABLE
156     , x_return_status out nocopy  VARCHAR2
157     , x_msg_count out nocopy  NUMBER
158     , x_msg_data out nocopy  VARCHAR2
159   );
160   procedure updatefeeschedule(p_init_msg_list  VARCHAR2
161     , p_commit  VARCHAR2
162     , p_loan_id  NUMBER
163     , p3_a0 JTF_NUMBER_TABLE
164     , p3_a1 JTF_VARCHAR2_TABLE_100
165     , p3_a2 JTF_VARCHAR2_TABLE_100
166     , p3_a3 JTF_VARCHAR2_TABLE_100
167     , p3_a4 JTF_NUMBER_TABLE
168     , p3_a5 JTF_NUMBER_TABLE
169     , p3_a6 JTF_VARCHAR2_TABLE_300
170     , p3_a7 JTF_NUMBER_TABLE
171     , p3_a8 JTF_VARCHAR2_TABLE_100
172     , p3_a9 JTF_VARCHAR2_TABLE_100
173     , p3_a10 JTF_VARCHAR2_TABLE_100
174     , p3_a11 JTF_NUMBER_TABLE
175     , p3_a12 JTF_VARCHAR2_TABLE_100
176     , p3_a13 JTF_VARCHAR2_TABLE_100
177     , p3_a14 JTF_NUMBER_TABLE
178     , x_return_status out nocopy  VARCHAR2
179     , x_msg_count out nocopy  NUMBER
180     , x_msg_data out nocopy  VARCHAR2
181   );
182   procedure getfeeschedule(p_init_msg_list  VARCHAR2
183     , p_loan_id  NUMBER
184     , p_installment_number  NUMBER
185     , p_disb_header_id  NUMBER
186     , p4_a0 out nocopy JTF_NUMBER_TABLE
187     , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
188     , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
189     , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
190     , p4_a4 out nocopy JTF_NUMBER_TABLE
191     , p4_a5 out nocopy JTF_NUMBER_TABLE
192     , p4_a6 out nocopy JTF_VARCHAR2_TABLE_300
193     , p4_a7 out nocopy JTF_NUMBER_TABLE
194     , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
195     , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
196     , p4_a10 out nocopy JTF_VARCHAR2_TABLE_100
197     , p4_a11 out nocopy JTF_NUMBER_TABLE
198     , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
199     , p4_a13 out nocopy JTF_VARCHAR2_TABLE_100
200     , p4_a14 out nocopy JTF_NUMBER_TABLE
201     , x_return_status out nocopy  VARCHAR2
202     , x_msg_count out nocopy  NUMBER
203     , x_msg_data out nocopy  VARCHAR2
204   );
205   procedure getfeedetails(p_init_msg_list  VARCHAR2
206     , p_loan_id  NUMBER
207     , p_installment  NUMBER
208     , p3_a0 JTF_VARCHAR2_TABLE_100
209     , p3_a1 JTF_NUMBER_TABLE
210     , p_based_on_terms  VARCHAR2
211     , p_phase  VARCHAR2
212     , p6_a0 out nocopy JTF_NUMBER_TABLE
213     , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
214     , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
215     , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
216     , p6_a4 out nocopy JTF_NUMBER_TABLE
217     , p6_a5 out nocopy JTF_NUMBER_TABLE
218     , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300
219     , p6_a7 out nocopy JTF_NUMBER_TABLE
220     , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
221     , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
222     , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
223     , p6_a11 out nocopy JTF_NUMBER_TABLE
224     , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
225     , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
226     , p6_a14 out nocopy JTF_NUMBER_TABLE
227     , x_return_status out nocopy  VARCHAR2
228     , x_msg_count out nocopy  NUMBER
229     , x_msg_data out nocopy  VARCHAR2
230   );
231   procedure processfees(p_init_msg_list  VARCHAR2
232     , p_commit  VARCHAR2
233     , p_loan_id  NUMBER
234     , p_installment_number  NUMBER
235     , p4_a0 JTF_VARCHAR2_TABLE_100
236     , p4_a1 JTF_NUMBER_TABLE
237     , p5_a0 JTF_NUMBER_TABLE
238     , p5_a1 JTF_VARCHAR2_TABLE_100
239     , p5_a2 JTF_VARCHAR2_TABLE_300
240     , p5_a3 JTF_VARCHAR2_TABLE_100
241     , p5_a4 JTF_VARCHAR2_TABLE_100
242     , p5_a5 JTF_NUMBER_TABLE
243     , p5_a6 JTF_VARCHAR2_TABLE_100
244     , p5_a7 JTF_DATE_TABLE
245     , p5_a8 JTF_DATE_TABLE
246     , p5_a9 JTF_NUMBER_TABLE
247     , p5_a10 JTF_VARCHAR2_TABLE_100
248     , p5_a11 JTF_VARCHAR2_TABLE_100
249     , p5_a12 JTF_NUMBER_TABLE
250     , p5_a13 JTF_NUMBER_TABLE
251     , p5_a14 JTF_VARCHAR2_TABLE_100
252     , p5_a15 JTF_VARCHAR2_TABLE_100
253     , p5_a16 JTF_VARCHAR2_TABLE_100
254     , p5_a17 JTF_NUMBER_TABLE
255     , p5_a18 JTF_VARCHAR2_TABLE_100
256     , p5_a19 JTF_VARCHAR2_TABLE_100
257     , p5_a20 JTF_NUMBER_TABLE
258     , p5_a21 JTF_NUMBER_TABLE
259     , p5_a22 JTF_DATE_TABLE
260     , p6_a0 out nocopy JTF_NUMBER_TABLE
261     , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
262     , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
263     , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
264     , p6_a4 out nocopy JTF_NUMBER_TABLE
265     , p6_a5 out nocopy JTF_NUMBER_TABLE
266     , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300
267     , p6_a7 out nocopy JTF_NUMBER_TABLE
268     , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
269     , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
270     , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
271     , p6_a11 out nocopy JTF_NUMBER_TABLE
272     , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
273     , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
274     , p6_a14 out nocopy JTF_NUMBER_TABLE
275     , x_return_status out nocopy  VARCHAR2
276     , x_msg_count out nocopy  NUMBER
277     , x_msg_data out nocopy  VARCHAR2
278   );
279 end lns_fee_engine_w;