[Home] [Help]
PACKAGE BODY: APPS.OKL_SIF_LINES_PUB_W
Source
1 package body okl_sif_lines_pub_w as
2 /* $Header: OKLUSILB.pls 120.2 2005/10/11 06:40:27 rgooty noship $ */
3 rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
4 rosetta_g_miss_date date := to_date('01/01/-4712', 'MM/DD/SYYYY');
5
6 -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
7 function rosetta_g_miss_date_in_map(d date) return date as
8 begin
9 if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
10 return d;
11 end;
12
13 function rosetta_g_miss_num_map(n number) return number as
14 a number := fnd_api.g_miss_num;
15 b number := 0-1962.0724;
16 begin
17 if n=a then return b; end if;
18 if n=b then return a; end if;
19 return n;
20 end;
21
22 procedure insert_sif_lines(p_api_version NUMBER
23 , p_init_msg_list VARCHAR2
24 , x_return_status out nocopy VARCHAR2
25 , x_msg_count out nocopy NUMBER
26 , x_msg_data out nocopy VARCHAR2
27 , p6_a0 out nocopy NUMBER
28 , p6_a1 out nocopy NUMBER
29 , p6_a2 out nocopy NUMBER
30 , p6_a3 out nocopy VARCHAR2
31 , p6_a4 out nocopy DATE
32 , p6_a5 out nocopy NUMBER
33 , p6_a6 out nocopy NUMBER
34 , p6_a7 out nocopy VARCHAR2
35 , p6_a8 out nocopy NUMBER
36 , p6_a9 out nocopy VARCHAR2
37 , p6_a10 out nocopy VARCHAR2
38 , p6_a11 out nocopy NUMBER
39 , p6_a12 out nocopy NUMBER
40 , p6_a13 out nocopy NUMBER
41 , p6_a14 out nocopy VARCHAR2
42 , p6_a15 out nocopy VARCHAR2
43 , p6_a16 out nocopy NUMBER
44 , p6_a17 out nocopy NUMBER
45 , p6_a18 out nocopy DATE
46 , p6_a19 out nocopy NUMBER
47 , p6_a20 out nocopy VARCHAR2
48 , p6_a21 out nocopy NUMBER
49 , p6_a22 out nocopy NUMBER
50 , p6_a23 out nocopy NUMBER
51 , p6_a24 out nocopy DATE
52 , p6_a25 out nocopy NUMBER
53 , p6_a26 out nocopy NUMBER
54 , p6_a27 out nocopy DATE
55 , p6_a28 out nocopy DATE
56 , p6_a29 out nocopy DATE
57 , p6_a30 out nocopy VARCHAR2
58 , p6_a31 out nocopy VARCHAR2
59 , p6_a32 out nocopy VARCHAR2
60 , p6_a33 out nocopy VARCHAR2
61 , p6_a34 out nocopy NUMBER
62 , p6_a35 out nocopy VARCHAR2
63 , p6_a36 out nocopy VARCHAR2
64 , p6_a37 out nocopy VARCHAR2
65 , p6_a38 out nocopy VARCHAR2
66 , p6_a39 out nocopy VARCHAR2
67 , p6_a40 out nocopy VARCHAR2
68 , p6_a41 out nocopy VARCHAR2
69 , p6_a42 out nocopy VARCHAR2
70 , p6_a43 out nocopy VARCHAR2
71 , p6_a44 out nocopy VARCHAR2
72 , p6_a45 out nocopy VARCHAR2
73 , p6_a46 out nocopy VARCHAR2
74 , p6_a47 out nocopy VARCHAR2
75 , p6_a48 out nocopy DATE
76 , p6_a49 out nocopy DATE
77 , p6_a50 out nocopy NUMBER
78 , p6_a51 out nocopy NUMBER
79 , p6_a52 out nocopy NUMBER
80 , p6_a53 out nocopy VARCHAR2
81 , p6_a54 out nocopy NUMBER
82 , p6_a55 out nocopy NUMBER
83 , p6_a56 out nocopy DATE
84 , p6_a57 out nocopy DATE
85 , p6_a58 out nocopy NUMBER
86 , p6_a59 out nocopy VARCHAR2
87 , p6_a60 out nocopy NUMBER
88 , p6_a61 out nocopy VARCHAR2
89 , p5_a0 NUMBER := 0-1962.0724
90 , p5_a1 NUMBER := 0-1962.0724
91 , p5_a2 NUMBER := 0-1962.0724
92 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
93 , p5_a4 DATE := fnd_api.g_miss_date
94 , p5_a5 NUMBER := 0-1962.0724
95 , p5_a6 NUMBER := 0-1962.0724
96 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
97 , p5_a8 NUMBER := 0-1962.0724
98 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
99 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
100 , p5_a11 NUMBER := 0-1962.0724
101 , p5_a12 NUMBER := 0-1962.0724
102 , p5_a13 NUMBER := 0-1962.0724
103 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
104 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
105 , p5_a16 NUMBER := 0-1962.0724
106 , p5_a17 NUMBER := 0-1962.0724
107 , p5_a18 DATE := fnd_api.g_miss_date
108 , p5_a19 NUMBER := 0-1962.0724
109 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
110 , p5_a21 NUMBER := 0-1962.0724
111 , p5_a22 NUMBER := 0-1962.0724
112 , p5_a23 NUMBER := 0-1962.0724
113 , p5_a24 DATE := fnd_api.g_miss_date
114 , p5_a25 NUMBER := 0-1962.0724
115 , p5_a26 NUMBER := 0-1962.0724
116 , p5_a27 DATE := fnd_api.g_miss_date
117 , p5_a28 DATE := fnd_api.g_miss_date
118 , p5_a29 DATE := fnd_api.g_miss_date
119 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
120 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
121 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
122 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
123 , p5_a34 NUMBER := 0-1962.0724
124 , p5_a35 VARCHAR2 := fnd_api.g_miss_char
125 , p5_a36 VARCHAR2 := fnd_api.g_miss_char
126 , p5_a37 VARCHAR2 := fnd_api.g_miss_char
127 , p5_a38 VARCHAR2 := fnd_api.g_miss_char
128 , p5_a39 VARCHAR2 := fnd_api.g_miss_char
129 , p5_a40 VARCHAR2 := fnd_api.g_miss_char
130 , p5_a41 VARCHAR2 := fnd_api.g_miss_char
131 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
132 , p5_a43 VARCHAR2 := fnd_api.g_miss_char
133 , p5_a44 VARCHAR2 := fnd_api.g_miss_char
134 , p5_a45 VARCHAR2 := fnd_api.g_miss_char
135 , p5_a46 VARCHAR2 := fnd_api.g_miss_char
136 , p5_a47 VARCHAR2 := fnd_api.g_miss_char
137 , p5_a48 DATE := fnd_api.g_miss_date
138 , p5_a49 DATE := fnd_api.g_miss_date
139 , p5_a50 NUMBER := 0-1962.0724
140 , p5_a51 NUMBER := 0-1962.0724
141 , p5_a52 NUMBER := 0-1962.0724
142 , p5_a53 VARCHAR2 := fnd_api.g_miss_char
143 , p5_a54 NUMBER := 0-1962.0724
144 , p5_a55 NUMBER := 0-1962.0724
145 , p5_a56 DATE := fnd_api.g_miss_date
146 , p5_a57 DATE := fnd_api.g_miss_date
147 , p5_a58 NUMBER := 0-1962.0724
148 , p5_a59 VARCHAR2 := fnd_api.g_miss_char
149 , p5_a60 NUMBER := 0-1962.0724
150 , p5_a61 VARCHAR2 := fnd_api.g_miss_char
151 )
152
153 as
154 ddp_silv_rec okl_sif_lines_pub.silv_rec_type;
155 ddx_silv_rec okl_sif_lines_pub.silv_rec_type;
156 ddindx binary_integer; indx binary_integer;
157 begin
158
159 -- copy data to the local IN or IN-OUT args, if any
160
161
162
163
164
165 ddp_silv_rec.id := rosetta_g_miss_num_map(p5_a0);
166 ddp_silv_rec.state_depre_dmnshing_value_rt := rosetta_g_miss_num_map(p5_a1);
167 ddp_silv_rec.book_depre_dmnshing_value_rt := rosetta_g_miss_num_map(p5_a2);
168 ddp_silv_rec.residual_guarantee_method := p5_a3;
169 ddp_silv_rec.residual_date := rosetta_g_miss_date_in_map(p5_a4);
170 ddp_silv_rec.fed_depre_term := rosetta_g_miss_num_map(p5_a5);
171 ddp_silv_rec.fed_depre_dmnshing_value_rate := rosetta_g_miss_num_map(p5_a6);
172 ddp_silv_rec.fed_depre_adr_conve := p5_a7;
173 ddp_silv_rec.state_depre_basis_percent := rosetta_g_miss_num_map(p5_a8);
174 ddp_silv_rec.state_depre_method := p5_a9;
175 ddp_silv_rec.purchase_option := p5_a10;
176 ddp_silv_rec.purchase_option_amount := rosetta_g_miss_num_map(p5_a11);
177 ddp_silv_rec.asset_cost := rosetta_g_miss_num_map(p5_a12);
178 ddp_silv_rec.state_depre_term := rosetta_g_miss_num_map(p5_a13);
179 ddp_silv_rec.state_depre_adr_convent := p5_a14;
180 ddp_silv_rec.fed_depre_method := p5_a15;
181 ddp_silv_rec.residual_amount := rosetta_g_miss_num_map(p5_a16);
182 ddp_silv_rec.fed_depre_salvage := rosetta_g_miss_num_map(p5_a17);
183 ddp_silv_rec.date_fed_depre := rosetta_g_miss_date_in_map(p5_a18);
184 ddp_silv_rec.book_salvage := rosetta_g_miss_num_map(p5_a19);
185 ddp_silv_rec.book_adr_convention := p5_a20;
186 ddp_silv_rec.state_depre_salvage := rosetta_g_miss_num_map(p5_a21);
187 ddp_silv_rec.fed_depre_basis_percent := rosetta_g_miss_num_map(p5_a22);
188 ddp_silv_rec.book_basis_percent := rosetta_g_miss_num_map(p5_a23);
189 ddp_silv_rec.date_delivery := rosetta_g_miss_date_in_map(p5_a24);
190 ddp_silv_rec.book_term := rosetta_g_miss_num_map(p5_a25);
191 ddp_silv_rec.residual_guarantee_amount := rosetta_g_miss_num_map(p5_a26);
192 ddp_silv_rec.date_funding := rosetta_g_miss_date_in_map(p5_a27);
193 ddp_silv_rec.date_book := rosetta_g_miss_date_in_map(p5_a28);
194 ddp_silv_rec.date_state_depre := rosetta_g_miss_date_in_map(p5_a29);
195 ddp_silv_rec.book_method := p5_a30;
196 ddp_silv_rec.stream_interface_attribute08 := p5_a31;
197 ddp_silv_rec.stream_interface_attribute03 := p5_a32;
198 ddp_silv_rec.stream_interface_attribute01 := p5_a33;
199 ddp_silv_rec.index_number := rosetta_g_miss_num_map(p5_a34);
200 ddp_silv_rec.stream_interface_attribute05 := p5_a35;
201 ddp_silv_rec.description := p5_a36;
202 ddp_silv_rec.stream_interface_attribute10 := p5_a37;
203 ddp_silv_rec.stream_interface_attribute06 := p5_a38;
204 ddp_silv_rec.stream_interface_attribute09 := p5_a39;
205 ddp_silv_rec.stream_interface_attribute07 := p5_a40;
206 ddp_silv_rec.stream_interface_attribute14 := p5_a41;
207 ddp_silv_rec.stream_interface_attribute12 := p5_a42;
208 ddp_silv_rec.stream_interface_attribute15 := p5_a43;
209 ddp_silv_rec.stream_interface_attribute02 := p5_a44;
210 ddp_silv_rec.stream_interface_attribute11 := p5_a45;
211 ddp_silv_rec.stream_interface_attribute04 := p5_a46;
212 ddp_silv_rec.stream_interface_attribute13 := p5_a47;
213 ddp_silv_rec.date_start := rosetta_g_miss_date_in_map(p5_a48);
214 ddp_silv_rec.date_lending := rosetta_g_miss_date_in_map(p5_a49);
215 ddp_silv_rec.sif_id := rosetta_g_miss_num_map(p5_a50);
216 ddp_silv_rec.object_version_number := rosetta_g_miss_num_map(p5_a51);
217 ddp_silv_rec.kle_id := rosetta_g_miss_num_map(p5_a52);
218 ddp_silv_rec.sil_type := p5_a53;
219 ddp_silv_rec.created_by := rosetta_g_miss_num_map(p5_a54);
220 ddp_silv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a55);
221 ddp_silv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a56);
222 ddp_silv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a57);
223 ddp_silv_rec.last_update_login := rosetta_g_miss_num_map(p5_a58);
224 ddp_silv_rec.residual_guarantee_type := p5_a59;
225 ddp_silv_rec.down_payment_amount := rosetta_g_miss_num_map(p5_a60);
226 ddp_silv_rec.capitalize_down_payment_yn := p5_a61;
227
228
229 -- here's the delegated call to the old PL/SQL routine
230 okl_sif_lines_pub.insert_sif_lines(p_api_version,
231 p_init_msg_list,
232 x_return_status,
233 x_msg_count,
234 x_msg_data,
235 ddp_silv_rec,
236 ddx_silv_rec);
237
238 -- copy data back from the local variables to OUT or IN-OUT args, if any
239
240
241
242
243
244
245 p6_a0 := rosetta_g_miss_num_map(ddx_silv_rec.id);
246 p6_a1 := rosetta_g_miss_num_map(ddx_silv_rec.state_depre_dmnshing_value_rt);
247 p6_a2 := rosetta_g_miss_num_map(ddx_silv_rec.book_depre_dmnshing_value_rt);
248 p6_a3 := ddx_silv_rec.residual_guarantee_method;
249 p6_a4 := ddx_silv_rec.residual_date;
250 p6_a5 := rosetta_g_miss_num_map(ddx_silv_rec.fed_depre_term);
251 p6_a6 := rosetta_g_miss_num_map(ddx_silv_rec.fed_depre_dmnshing_value_rate);
252 p6_a7 := ddx_silv_rec.fed_depre_adr_conve;
253 p6_a8 := rosetta_g_miss_num_map(ddx_silv_rec.state_depre_basis_percent);
254 p6_a9 := ddx_silv_rec.state_depre_method;
255 p6_a10 := ddx_silv_rec.purchase_option;
256 p6_a11 := rosetta_g_miss_num_map(ddx_silv_rec.purchase_option_amount);
257 p6_a12 := rosetta_g_miss_num_map(ddx_silv_rec.asset_cost);
258 p6_a13 := rosetta_g_miss_num_map(ddx_silv_rec.state_depre_term);
259 p6_a14 := ddx_silv_rec.state_depre_adr_convent;
260 p6_a15 := ddx_silv_rec.fed_depre_method;
261 p6_a16 := rosetta_g_miss_num_map(ddx_silv_rec.residual_amount);
262 p6_a17 := rosetta_g_miss_num_map(ddx_silv_rec.fed_depre_salvage);
263 p6_a18 := ddx_silv_rec.date_fed_depre;
264 p6_a19 := rosetta_g_miss_num_map(ddx_silv_rec.book_salvage);
265 p6_a20 := ddx_silv_rec.book_adr_convention;
266 p6_a21 := rosetta_g_miss_num_map(ddx_silv_rec.state_depre_salvage);
267 p6_a22 := rosetta_g_miss_num_map(ddx_silv_rec.fed_depre_basis_percent);
268 p6_a23 := rosetta_g_miss_num_map(ddx_silv_rec.book_basis_percent);
269 p6_a24 := ddx_silv_rec.date_delivery;
270 p6_a25 := rosetta_g_miss_num_map(ddx_silv_rec.book_term);
271 p6_a26 := rosetta_g_miss_num_map(ddx_silv_rec.residual_guarantee_amount);
272 p6_a27 := ddx_silv_rec.date_funding;
273 p6_a28 := ddx_silv_rec.date_book;
274 p6_a29 := ddx_silv_rec.date_state_depre;
275 p6_a30 := ddx_silv_rec.book_method;
276 p6_a31 := ddx_silv_rec.stream_interface_attribute08;
277 p6_a32 := ddx_silv_rec.stream_interface_attribute03;
278 p6_a33 := ddx_silv_rec.stream_interface_attribute01;
279 p6_a34 := rosetta_g_miss_num_map(ddx_silv_rec.index_number);
280 p6_a35 := ddx_silv_rec.stream_interface_attribute05;
281 p6_a36 := ddx_silv_rec.description;
282 p6_a37 := ddx_silv_rec.stream_interface_attribute10;
283 p6_a38 := ddx_silv_rec.stream_interface_attribute06;
284 p6_a39 := ddx_silv_rec.stream_interface_attribute09;
285 p6_a40 := ddx_silv_rec.stream_interface_attribute07;
286 p6_a41 := ddx_silv_rec.stream_interface_attribute14;
287 p6_a42 := ddx_silv_rec.stream_interface_attribute12;
288 p6_a43 := ddx_silv_rec.stream_interface_attribute15;
289 p6_a44 := ddx_silv_rec.stream_interface_attribute02;
290 p6_a45 := ddx_silv_rec.stream_interface_attribute11;
291 p6_a46 := ddx_silv_rec.stream_interface_attribute04;
292 p6_a47 := ddx_silv_rec.stream_interface_attribute13;
293 p6_a48 := ddx_silv_rec.date_start;
294 p6_a49 := ddx_silv_rec.date_lending;
295 p6_a50 := rosetta_g_miss_num_map(ddx_silv_rec.sif_id);
296 p6_a51 := rosetta_g_miss_num_map(ddx_silv_rec.object_version_number);
297 p6_a52 := rosetta_g_miss_num_map(ddx_silv_rec.kle_id);
298 p6_a53 := ddx_silv_rec.sil_type;
299 p6_a54 := rosetta_g_miss_num_map(ddx_silv_rec.created_by);
300 p6_a55 := rosetta_g_miss_num_map(ddx_silv_rec.last_updated_by);
301 p6_a56 := ddx_silv_rec.creation_date;
302 p6_a57 := ddx_silv_rec.last_update_date;
303 p6_a58 := rosetta_g_miss_num_map(ddx_silv_rec.last_update_login);
304 p6_a59 := ddx_silv_rec.residual_guarantee_type;
305 p6_a60 := rosetta_g_miss_num_map(ddx_silv_rec.down_payment_amount);
306 p6_a61 := ddx_silv_rec.capitalize_down_payment_yn;
307 end;
308
309 procedure insert_sif_lines(p_api_version NUMBER
310 , p_init_msg_list VARCHAR2
311 , x_return_status out nocopy VARCHAR2
312 , x_msg_count out nocopy NUMBER
313 , x_msg_data out nocopy VARCHAR2
314 , p5_a0 JTF_NUMBER_TABLE
315 , p5_a1 JTF_NUMBER_TABLE
316 , p5_a2 JTF_NUMBER_TABLE
317 , p5_a3 JTF_VARCHAR2_TABLE_100
318 , p5_a4 JTF_DATE_TABLE
319 , p5_a5 JTF_NUMBER_TABLE
320 , p5_a6 JTF_NUMBER_TABLE
321 , p5_a7 JTF_VARCHAR2_TABLE_100
322 , p5_a8 JTF_NUMBER_TABLE
323 , p5_a9 JTF_VARCHAR2_TABLE_100
324 , p5_a10 JTF_VARCHAR2_TABLE_100
325 , p5_a11 JTF_NUMBER_TABLE
326 , p5_a12 JTF_NUMBER_TABLE
327 , p5_a13 JTF_NUMBER_TABLE
328 , p5_a14 JTF_VARCHAR2_TABLE_100
329 , p5_a15 JTF_VARCHAR2_TABLE_100
330 , p5_a16 JTF_NUMBER_TABLE
331 , p5_a17 JTF_NUMBER_TABLE
332 , p5_a18 JTF_DATE_TABLE
333 , p5_a19 JTF_NUMBER_TABLE
334 , p5_a20 JTF_VARCHAR2_TABLE_100
335 , p5_a21 JTF_NUMBER_TABLE
336 , p5_a22 JTF_NUMBER_TABLE
337 , p5_a23 JTF_NUMBER_TABLE
338 , p5_a24 JTF_DATE_TABLE
339 , p5_a25 JTF_NUMBER_TABLE
340 , p5_a26 JTF_NUMBER_TABLE
341 , p5_a27 JTF_DATE_TABLE
342 , p5_a28 JTF_DATE_TABLE
343 , p5_a29 JTF_DATE_TABLE
344 , p5_a30 JTF_VARCHAR2_TABLE_100
345 , p5_a31 JTF_VARCHAR2_TABLE_500
346 , p5_a32 JTF_VARCHAR2_TABLE_500
347 , p5_a33 JTF_VARCHAR2_TABLE_500
348 , p5_a34 JTF_NUMBER_TABLE
349 , p5_a35 JTF_VARCHAR2_TABLE_500
350 , p5_a36 JTF_VARCHAR2_TABLE_2000
351 , p5_a37 JTF_VARCHAR2_TABLE_500
352 , p5_a38 JTF_VARCHAR2_TABLE_500
353 , p5_a39 JTF_VARCHAR2_TABLE_500
354 , p5_a40 JTF_VARCHAR2_TABLE_500
355 , p5_a41 JTF_VARCHAR2_TABLE_500
356 , p5_a42 JTF_VARCHAR2_TABLE_500
357 , p5_a43 JTF_VARCHAR2_TABLE_500
358 , p5_a44 JTF_VARCHAR2_TABLE_500
359 , p5_a45 JTF_VARCHAR2_TABLE_500
360 , p5_a46 JTF_VARCHAR2_TABLE_500
361 , p5_a47 JTF_VARCHAR2_TABLE_500
362 , p5_a48 JTF_DATE_TABLE
363 , p5_a49 JTF_DATE_TABLE
364 , p5_a50 JTF_NUMBER_TABLE
365 , p5_a51 JTF_NUMBER_TABLE
366 , p5_a52 JTF_NUMBER_TABLE
367 , p5_a53 JTF_VARCHAR2_TABLE_100
368 , p5_a54 JTF_NUMBER_TABLE
369 , p5_a55 JTF_NUMBER_TABLE
370 , p5_a56 JTF_DATE_TABLE
371 , p5_a57 JTF_DATE_TABLE
372 , p5_a58 JTF_NUMBER_TABLE
373 , p5_a59 JTF_VARCHAR2_TABLE_200
374 , p5_a60 JTF_NUMBER_TABLE
375 , p5_a61 JTF_VARCHAR2_TABLE_100
376 , p6_a0 out nocopy JTF_NUMBER_TABLE
377 , p6_a1 out nocopy JTF_NUMBER_TABLE
378 , p6_a2 out nocopy JTF_NUMBER_TABLE
379 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
380 , p6_a4 out nocopy JTF_DATE_TABLE
381 , p6_a5 out nocopy JTF_NUMBER_TABLE
382 , p6_a6 out nocopy JTF_NUMBER_TABLE
383 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
384 , p6_a8 out nocopy JTF_NUMBER_TABLE
385 , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
386 , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
387 , p6_a11 out nocopy JTF_NUMBER_TABLE
388 , p6_a12 out nocopy JTF_NUMBER_TABLE
389 , p6_a13 out nocopy JTF_NUMBER_TABLE
390 , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
391 , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
392 , p6_a16 out nocopy JTF_NUMBER_TABLE
393 , p6_a17 out nocopy JTF_NUMBER_TABLE
394 , p6_a18 out nocopy JTF_DATE_TABLE
395 , p6_a19 out nocopy JTF_NUMBER_TABLE
396 , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
397 , p6_a21 out nocopy JTF_NUMBER_TABLE
398 , p6_a22 out nocopy JTF_NUMBER_TABLE
399 , p6_a23 out nocopy JTF_NUMBER_TABLE
400 , p6_a24 out nocopy JTF_DATE_TABLE
401 , p6_a25 out nocopy JTF_NUMBER_TABLE
402 , p6_a26 out nocopy JTF_NUMBER_TABLE
403 , p6_a27 out nocopy JTF_DATE_TABLE
404 , p6_a28 out nocopy JTF_DATE_TABLE
405 , p6_a29 out nocopy JTF_DATE_TABLE
406 , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
407 , p6_a31 out nocopy JTF_VARCHAR2_TABLE_500
408 , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
409 , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
410 , p6_a34 out nocopy JTF_NUMBER_TABLE
411 , p6_a35 out nocopy JTF_VARCHAR2_TABLE_500
412 , p6_a36 out nocopy JTF_VARCHAR2_TABLE_2000
413 , p6_a37 out nocopy JTF_VARCHAR2_TABLE_500
414 , p6_a38 out nocopy JTF_VARCHAR2_TABLE_500
415 , p6_a39 out nocopy JTF_VARCHAR2_TABLE_500
416 , p6_a40 out nocopy JTF_VARCHAR2_TABLE_500
417 , p6_a41 out nocopy JTF_VARCHAR2_TABLE_500
418 , p6_a42 out nocopy JTF_VARCHAR2_TABLE_500
419 , p6_a43 out nocopy JTF_VARCHAR2_TABLE_500
420 , p6_a44 out nocopy JTF_VARCHAR2_TABLE_500
421 , p6_a45 out nocopy JTF_VARCHAR2_TABLE_500
422 , p6_a46 out nocopy JTF_VARCHAR2_TABLE_500
423 , p6_a47 out nocopy JTF_VARCHAR2_TABLE_500
424 , p6_a48 out nocopy JTF_DATE_TABLE
425 , p6_a49 out nocopy JTF_DATE_TABLE
426 , p6_a50 out nocopy JTF_NUMBER_TABLE
427 , p6_a51 out nocopy JTF_NUMBER_TABLE
428 , p6_a52 out nocopy JTF_NUMBER_TABLE
429 , p6_a53 out nocopy JTF_VARCHAR2_TABLE_100
430 , p6_a54 out nocopy JTF_NUMBER_TABLE
431 , p6_a55 out nocopy JTF_NUMBER_TABLE
432 , p6_a56 out nocopy JTF_DATE_TABLE
433 , p6_a57 out nocopy JTF_DATE_TABLE
434 , p6_a58 out nocopy JTF_NUMBER_TABLE
435 , p6_a59 out nocopy JTF_VARCHAR2_TABLE_200
436 , p6_a60 out nocopy JTF_NUMBER_TABLE
437 , p6_a61 out nocopy JTF_VARCHAR2_TABLE_100
438 )
439
440 as
441 ddp_silv_tbl okl_sif_lines_pub.silv_tbl_type;
442 ddx_silv_tbl okl_sif_lines_pub.silv_tbl_type;
443 ddindx binary_integer; indx binary_integer;
444 begin
445
446 -- copy data to the local IN or IN-OUT args, if any
447
448
449
450
451
452 okl_sil_pvt_w.rosetta_table_copy_in_p5(ddp_silv_tbl, p5_a0
453 , p5_a1
454 , p5_a2
455 , p5_a3
456 , p5_a4
457 , p5_a5
458 , p5_a6
459 , p5_a7
460 , p5_a8
461 , p5_a9
462 , p5_a10
463 , p5_a11
464 , p5_a12
465 , p5_a13
466 , p5_a14
467 , p5_a15
468 , p5_a16
469 , p5_a17
470 , p5_a18
471 , p5_a19
472 , p5_a20
473 , p5_a21
474 , p5_a22
475 , p5_a23
476 , p5_a24
477 , p5_a25
478 , p5_a26
479 , p5_a27
480 , p5_a28
481 , p5_a29
482 , p5_a30
483 , p5_a31
484 , p5_a32
485 , p5_a33
486 , p5_a34
487 , p5_a35
488 , p5_a36
489 , p5_a37
490 , p5_a38
491 , p5_a39
492 , p5_a40
493 , p5_a41
494 , p5_a42
495 , p5_a43
496 , p5_a44
497 , p5_a45
498 , p5_a46
499 , p5_a47
500 , p5_a48
501 , p5_a49
502 , p5_a50
503 , p5_a51
504 , p5_a52
505 , p5_a53
506 , p5_a54
507 , p5_a55
508 , p5_a56
509 , p5_a57
510 , p5_a58
511 , p5_a59
512 , p5_a60
513 , p5_a61
514 );
515
516
517 -- here's the delegated call to the old PL/SQL routine
518 okl_sif_lines_pub.insert_sif_lines(p_api_version,
519 p_init_msg_list,
520 x_return_status,
521 x_msg_count,
522 x_msg_data,
523 ddp_silv_tbl,
524 ddx_silv_tbl);
525
526 -- copy data back from the local variables to OUT or IN-OUT args, if any
527
528
529
530
531
532
533 okl_sil_pvt_w.rosetta_table_copy_out_p5(ddx_silv_tbl, p6_a0
534 , p6_a1
535 , p6_a2
536 , p6_a3
537 , p6_a4
538 , p6_a5
539 , p6_a6
540 , p6_a7
541 , p6_a8
542 , p6_a9
543 , p6_a10
544 , p6_a11
545 , p6_a12
546 , p6_a13
547 , p6_a14
548 , p6_a15
549 , p6_a16
550 , p6_a17
551 , p6_a18
552 , p6_a19
553 , p6_a20
554 , p6_a21
555 , p6_a22
556 , p6_a23
557 , p6_a24
558 , p6_a25
559 , p6_a26
560 , p6_a27
561 , p6_a28
562 , p6_a29
563 , p6_a30
564 , p6_a31
565 , p6_a32
566 , p6_a33
567 , p6_a34
568 , p6_a35
569 , p6_a36
570 , p6_a37
571 , p6_a38
572 , p6_a39
573 , p6_a40
574 , p6_a41
575 , p6_a42
576 , p6_a43
577 , p6_a44
578 , p6_a45
579 , p6_a46
580 , p6_a47
581 , p6_a48
582 , p6_a49
583 , p6_a50
584 , p6_a51
585 , p6_a52
586 , p6_a53
587 , p6_a54
588 , p6_a55
589 , p6_a56
590 , p6_a57
591 , p6_a58
592 , p6_a59
593 , p6_a60
594 , p6_a61
595 );
596 end;
597
598 procedure lock_sif_lines(p_api_version NUMBER
599 , p_init_msg_list VARCHAR2
600 , x_return_status out nocopy VARCHAR2
601 , x_msg_count out nocopy NUMBER
602 , x_msg_data out nocopy VARCHAR2
603 , p5_a0 NUMBER := 0-1962.0724
604 , p5_a1 NUMBER := 0-1962.0724
605 , p5_a2 NUMBER := 0-1962.0724
606 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
607 , p5_a4 DATE := fnd_api.g_miss_date
608 , p5_a5 NUMBER := 0-1962.0724
609 , p5_a6 NUMBER := 0-1962.0724
610 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
611 , p5_a8 NUMBER := 0-1962.0724
612 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
613 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
614 , p5_a11 NUMBER := 0-1962.0724
615 , p5_a12 NUMBER := 0-1962.0724
616 , p5_a13 NUMBER := 0-1962.0724
617 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
618 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
619 , p5_a16 NUMBER := 0-1962.0724
620 , p5_a17 NUMBER := 0-1962.0724
621 , p5_a18 DATE := fnd_api.g_miss_date
622 , p5_a19 NUMBER := 0-1962.0724
623 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
624 , p5_a21 NUMBER := 0-1962.0724
625 , p5_a22 NUMBER := 0-1962.0724
626 , p5_a23 NUMBER := 0-1962.0724
627 , p5_a24 DATE := fnd_api.g_miss_date
628 , p5_a25 NUMBER := 0-1962.0724
629 , p5_a26 NUMBER := 0-1962.0724
630 , p5_a27 DATE := fnd_api.g_miss_date
631 , p5_a28 DATE := fnd_api.g_miss_date
632 , p5_a29 DATE := fnd_api.g_miss_date
633 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
634 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
635 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
636 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
637 , p5_a34 NUMBER := 0-1962.0724
638 , p5_a35 VARCHAR2 := fnd_api.g_miss_char
639 , p5_a36 VARCHAR2 := fnd_api.g_miss_char
640 , p5_a37 VARCHAR2 := fnd_api.g_miss_char
641 , p5_a38 VARCHAR2 := fnd_api.g_miss_char
642 , p5_a39 VARCHAR2 := fnd_api.g_miss_char
643 , p5_a40 VARCHAR2 := fnd_api.g_miss_char
644 , p5_a41 VARCHAR2 := fnd_api.g_miss_char
645 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
646 , p5_a43 VARCHAR2 := fnd_api.g_miss_char
647 , p5_a44 VARCHAR2 := fnd_api.g_miss_char
648 , p5_a45 VARCHAR2 := fnd_api.g_miss_char
649 , p5_a46 VARCHAR2 := fnd_api.g_miss_char
650 , p5_a47 VARCHAR2 := fnd_api.g_miss_char
651 , p5_a48 DATE := fnd_api.g_miss_date
652 , p5_a49 DATE := fnd_api.g_miss_date
653 , p5_a50 NUMBER := 0-1962.0724
654 , p5_a51 NUMBER := 0-1962.0724
655 , p5_a52 NUMBER := 0-1962.0724
656 , p5_a53 VARCHAR2 := fnd_api.g_miss_char
657 , p5_a54 NUMBER := 0-1962.0724
658 , p5_a55 NUMBER := 0-1962.0724
659 , p5_a56 DATE := fnd_api.g_miss_date
660 , p5_a57 DATE := fnd_api.g_miss_date
661 , p5_a58 NUMBER := 0-1962.0724
662 , p5_a59 VARCHAR2 := fnd_api.g_miss_char
663 , p5_a60 NUMBER := 0-1962.0724
664 , p5_a61 VARCHAR2 := fnd_api.g_miss_char
665 )
666
667 as
668 ddp_silv_rec okl_sif_lines_pub.silv_rec_type;
669 ddindx binary_integer; indx binary_integer;
670 begin
671
672 -- copy data to the local IN or IN-OUT args, if any
673
674
675
676
677
678 ddp_silv_rec.id := rosetta_g_miss_num_map(p5_a0);
679 ddp_silv_rec.state_depre_dmnshing_value_rt := rosetta_g_miss_num_map(p5_a1);
680 ddp_silv_rec.book_depre_dmnshing_value_rt := rosetta_g_miss_num_map(p5_a2);
681 ddp_silv_rec.residual_guarantee_method := p5_a3;
682 ddp_silv_rec.residual_date := rosetta_g_miss_date_in_map(p5_a4);
683 ddp_silv_rec.fed_depre_term := rosetta_g_miss_num_map(p5_a5);
684 ddp_silv_rec.fed_depre_dmnshing_value_rate := rosetta_g_miss_num_map(p5_a6);
685 ddp_silv_rec.fed_depre_adr_conve := p5_a7;
686 ddp_silv_rec.state_depre_basis_percent := rosetta_g_miss_num_map(p5_a8);
687 ddp_silv_rec.state_depre_method := p5_a9;
688 ddp_silv_rec.purchase_option := p5_a10;
689 ddp_silv_rec.purchase_option_amount := rosetta_g_miss_num_map(p5_a11);
690 ddp_silv_rec.asset_cost := rosetta_g_miss_num_map(p5_a12);
691 ddp_silv_rec.state_depre_term := rosetta_g_miss_num_map(p5_a13);
692 ddp_silv_rec.state_depre_adr_convent := p5_a14;
693 ddp_silv_rec.fed_depre_method := p5_a15;
694 ddp_silv_rec.residual_amount := rosetta_g_miss_num_map(p5_a16);
695 ddp_silv_rec.fed_depre_salvage := rosetta_g_miss_num_map(p5_a17);
696 ddp_silv_rec.date_fed_depre := rosetta_g_miss_date_in_map(p5_a18);
697 ddp_silv_rec.book_salvage := rosetta_g_miss_num_map(p5_a19);
698 ddp_silv_rec.book_adr_convention := p5_a20;
699 ddp_silv_rec.state_depre_salvage := rosetta_g_miss_num_map(p5_a21);
700 ddp_silv_rec.fed_depre_basis_percent := rosetta_g_miss_num_map(p5_a22);
701 ddp_silv_rec.book_basis_percent := rosetta_g_miss_num_map(p5_a23);
702 ddp_silv_rec.date_delivery := rosetta_g_miss_date_in_map(p5_a24);
703 ddp_silv_rec.book_term := rosetta_g_miss_num_map(p5_a25);
704 ddp_silv_rec.residual_guarantee_amount := rosetta_g_miss_num_map(p5_a26);
705 ddp_silv_rec.date_funding := rosetta_g_miss_date_in_map(p5_a27);
706 ddp_silv_rec.date_book := rosetta_g_miss_date_in_map(p5_a28);
707 ddp_silv_rec.date_state_depre := rosetta_g_miss_date_in_map(p5_a29);
708 ddp_silv_rec.book_method := p5_a30;
709 ddp_silv_rec.stream_interface_attribute08 := p5_a31;
710 ddp_silv_rec.stream_interface_attribute03 := p5_a32;
711 ddp_silv_rec.stream_interface_attribute01 := p5_a33;
712 ddp_silv_rec.index_number := rosetta_g_miss_num_map(p5_a34);
713 ddp_silv_rec.stream_interface_attribute05 := p5_a35;
714 ddp_silv_rec.description := p5_a36;
715 ddp_silv_rec.stream_interface_attribute10 := p5_a37;
716 ddp_silv_rec.stream_interface_attribute06 := p5_a38;
717 ddp_silv_rec.stream_interface_attribute09 := p5_a39;
718 ddp_silv_rec.stream_interface_attribute07 := p5_a40;
719 ddp_silv_rec.stream_interface_attribute14 := p5_a41;
720 ddp_silv_rec.stream_interface_attribute12 := p5_a42;
721 ddp_silv_rec.stream_interface_attribute15 := p5_a43;
722 ddp_silv_rec.stream_interface_attribute02 := p5_a44;
723 ddp_silv_rec.stream_interface_attribute11 := p5_a45;
724 ddp_silv_rec.stream_interface_attribute04 := p5_a46;
725 ddp_silv_rec.stream_interface_attribute13 := p5_a47;
726 ddp_silv_rec.date_start := rosetta_g_miss_date_in_map(p5_a48);
727 ddp_silv_rec.date_lending := rosetta_g_miss_date_in_map(p5_a49);
728 ddp_silv_rec.sif_id := rosetta_g_miss_num_map(p5_a50);
729 ddp_silv_rec.object_version_number := rosetta_g_miss_num_map(p5_a51);
730 ddp_silv_rec.kle_id := rosetta_g_miss_num_map(p5_a52);
731 ddp_silv_rec.sil_type := p5_a53;
732 ddp_silv_rec.created_by := rosetta_g_miss_num_map(p5_a54);
733 ddp_silv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a55);
734 ddp_silv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a56);
735 ddp_silv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a57);
736 ddp_silv_rec.last_update_login := rosetta_g_miss_num_map(p5_a58);
737 ddp_silv_rec.residual_guarantee_type := p5_a59;
738 ddp_silv_rec.down_payment_amount := rosetta_g_miss_num_map(p5_a60);
739 ddp_silv_rec.capitalize_down_payment_yn := p5_a61;
740
741 -- here's the delegated call to the old PL/SQL routine
742 okl_sif_lines_pub.lock_sif_lines(p_api_version,
743 p_init_msg_list,
744 x_return_status,
745 x_msg_count,
746 x_msg_data,
747 ddp_silv_rec);
748
749 -- copy data back from the local variables to OUT or IN-OUT args, if any
750
751
752
753
754
755 end;
756
757 procedure lock_sif_lines(p_api_version NUMBER
758 , p_init_msg_list VARCHAR2
759 , x_return_status out nocopy VARCHAR2
760 , x_msg_count out nocopy NUMBER
761 , x_msg_data out nocopy VARCHAR2
762 , p5_a0 JTF_NUMBER_TABLE
763 , p5_a1 JTF_NUMBER_TABLE
764 , p5_a2 JTF_NUMBER_TABLE
765 , p5_a3 JTF_VARCHAR2_TABLE_100
766 , p5_a4 JTF_DATE_TABLE
767 , p5_a5 JTF_NUMBER_TABLE
768 , p5_a6 JTF_NUMBER_TABLE
769 , p5_a7 JTF_VARCHAR2_TABLE_100
770 , p5_a8 JTF_NUMBER_TABLE
771 , p5_a9 JTF_VARCHAR2_TABLE_100
772 , p5_a10 JTF_VARCHAR2_TABLE_100
773 , p5_a11 JTF_NUMBER_TABLE
774 , p5_a12 JTF_NUMBER_TABLE
775 , p5_a13 JTF_NUMBER_TABLE
776 , p5_a14 JTF_VARCHAR2_TABLE_100
777 , p5_a15 JTF_VARCHAR2_TABLE_100
778 , p5_a16 JTF_NUMBER_TABLE
779 , p5_a17 JTF_NUMBER_TABLE
780 , p5_a18 JTF_DATE_TABLE
781 , p5_a19 JTF_NUMBER_TABLE
782 , p5_a20 JTF_VARCHAR2_TABLE_100
783 , p5_a21 JTF_NUMBER_TABLE
784 , p5_a22 JTF_NUMBER_TABLE
785 , p5_a23 JTF_NUMBER_TABLE
786 , p5_a24 JTF_DATE_TABLE
787 , p5_a25 JTF_NUMBER_TABLE
788 , p5_a26 JTF_NUMBER_TABLE
789 , p5_a27 JTF_DATE_TABLE
790 , p5_a28 JTF_DATE_TABLE
791 , p5_a29 JTF_DATE_TABLE
792 , p5_a30 JTF_VARCHAR2_TABLE_100
793 , p5_a31 JTF_VARCHAR2_TABLE_500
794 , p5_a32 JTF_VARCHAR2_TABLE_500
795 , p5_a33 JTF_VARCHAR2_TABLE_500
796 , p5_a34 JTF_NUMBER_TABLE
797 , p5_a35 JTF_VARCHAR2_TABLE_500
798 , p5_a36 JTF_VARCHAR2_TABLE_2000
799 , p5_a37 JTF_VARCHAR2_TABLE_500
800 , p5_a38 JTF_VARCHAR2_TABLE_500
801 , p5_a39 JTF_VARCHAR2_TABLE_500
802 , p5_a40 JTF_VARCHAR2_TABLE_500
803 , p5_a41 JTF_VARCHAR2_TABLE_500
804 , p5_a42 JTF_VARCHAR2_TABLE_500
805 , p5_a43 JTF_VARCHAR2_TABLE_500
806 , p5_a44 JTF_VARCHAR2_TABLE_500
807 , p5_a45 JTF_VARCHAR2_TABLE_500
808 , p5_a46 JTF_VARCHAR2_TABLE_500
809 , p5_a47 JTF_VARCHAR2_TABLE_500
810 , p5_a48 JTF_DATE_TABLE
811 , p5_a49 JTF_DATE_TABLE
812 , p5_a50 JTF_NUMBER_TABLE
813 , p5_a51 JTF_NUMBER_TABLE
814 , p5_a52 JTF_NUMBER_TABLE
815 , p5_a53 JTF_VARCHAR2_TABLE_100
816 , p5_a54 JTF_NUMBER_TABLE
817 , p5_a55 JTF_NUMBER_TABLE
818 , p5_a56 JTF_DATE_TABLE
819 , p5_a57 JTF_DATE_TABLE
820 , p5_a58 JTF_NUMBER_TABLE
821 , p5_a59 JTF_VARCHAR2_TABLE_200
822 , p5_a60 JTF_NUMBER_TABLE
823 , p5_a61 JTF_VARCHAR2_TABLE_100
824 )
825
826 as
827 ddp_silv_tbl okl_sif_lines_pub.silv_tbl_type;
828 ddindx binary_integer; indx binary_integer;
829 begin
830
831 -- copy data to the local IN or IN-OUT args, if any
832
833
834
835
836
837 okl_sil_pvt_w.rosetta_table_copy_in_p5(ddp_silv_tbl, p5_a0
838 , p5_a1
839 , p5_a2
840 , p5_a3
841 , p5_a4
842 , p5_a5
843 , p5_a6
844 , p5_a7
845 , p5_a8
846 , p5_a9
847 , p5_a10
848 , p5_a11
849 , p5_a12
850 , p5_a13
851 , p5_a14
852 , p5_a15
853 , p5_a16
854 , p5_a17
855 , p5_a18
856 , p5_a19
857 , p5_a20
858 , p5_a21
859 , p5_a22
860 , p5_a23
861 , p5_a24
862 , p5_a25
863 , p5_a26
864 , p5_a27
865 , p5_a28
866 , p5_a29
867 , p5_a30
868 , p5_a31
869 , p5_a32
870 , p5_a33
871 , p5_a34
872 , p5_a35
873 , p5_a36
874 , p5_a37
875 , p5_a38
876 , p5_a39
877 , p5_a40
878 , p5_a41
879 , p5_a42
880 , p5_a43
881 , p5_a44
882 , p5_a45
883 , p5_a46
884 , p5_a47
885 , p5_a48
886 , p5_a49
887 , p5_a50
888 , p5_a51
889 , p5_a52
890 , p5_a53
891 , p5_a54
892 , p5_a55
893 , p5_a56
894 , p5_a57
895 , p5_a58
896 , p5_a59
897 , p5_a60
898 , p5_a61
899 );
900
901 -- here's the delegated call to the old PL/SQL routine
902 okl_sif_lines_pub.lock_sif_lines(p_api_version,
903 p_init_msg_list,
904 x_return_status,
905 x_msg_count,
906 x_msg_data,
907 ddp_silv_tbl);
908
909 -- copy data back from the local variables to OUT or IN-OUT args, if any
910
911
912
913
914
915 end;
916
917 procedure update_sif_lines(p_api_version NUMBER
918 , p_init_msg_list VARCHAR2
919 , x_return_status out nocopy VARCHAR2
920 , x_msg_count out nocopy NUMBER
921 , x_msg_data out nocopy VARCHAR2
922 , p6_a0 out nocopy NUMBER
923 , p6_a1 out nocopy NUMBER
924 , p6_a2 out nocopy NUMBER
925 , p6_a3 out nocopy VARCHAR2
926 , p6_a4 out nocopy DATE
927 , p6_a5 out nocopy NUMBER
928 , p6_a6 out nocopy NUMBER
929 , p6_a7 out nocopy VARCHAR2
930 , p6_a8 out nocopy NUMBER
931 , p6_a9 out nocopy VARCHAR2
932 , p6_a10 out nocopy VARCHAR2
933 , p6_a11 out nocopy NUMBER
934 , p6_a12 out nocopy NUMBER
935 , p6_a13 out nocopy NUMBER
936 , p6_a14 out nocopy VARCHAR2
937 , p6_a15 out nocopy VARCHAR2
938 , p6_a16 out nocopy NUMBER
939 , p6_a17 out nocopy NUMBER
940 , p6_a18 out nocopy DATE
941 , p6_a19 out nocopy NUMBER
942 , p6_a20 out nocopy VARCHAR2
943 , p6_a21 out nocopy NUMBER
944 , p6_a22 out nocopy NUMBER
945 , p6_a23 out nocopy NUMBER
946 , p6_a24 out nocopy DATE
947 , p6_a25 out nocopy NUMBER
948 , p6_a26 out nocopy NUMBER
949 , p6_a27 out nocopy DATE
950 , p6_a28 out nocopy DATE
951 , p6_a29 out nocopy DATE
952 , p6_a30 out nocopy VARCHAR2
953 , p6_a31 out nocopy VARCHAR2
954 , p6_a32 out nocopy VARCHAR2
955 , p6_a33 out nocopy VARCHAR2
956 , p6_a34 out nocopy NUMBER
957 , p6_a35 out nocopy VARCHAR2
958 , p6_a36 out nocopy VARCHAR2
959 , p6_a37 out nocopy VARCHAR2
960 , p6_a38 out nocopy VARCHAR2
961 , p6_a39 out nocopy VARCHAR2
962 , p6_a40 out nocopy VARCHAR2
963 , p6_a41 out nocopy VARCHAR2
964 , p6_a42 out nocopy VARCHAR2
965 , p6_a43 out nocopy VARCHAR2
966 , p6_a44 out nocopy VARCHAR2
967 , p6_a45 out nocopy VARCHAR2
968 , p6_a46 out nocopy VARCHAR2
969 , p6_a47 out nocopy VARCHAR2
970 , p6_a48 out nocopy DATE
971 , p6_a49 out nocopy DATE
972 , p6_a50 out nocopy NUMBER
973 , p6_a51 out nocopy NUMBER
974 , p6_a52 out nocopy NUMBER
975 , p6_a53 out nocopy VARCHAR2
976 , p6_a54 out nocopy NUMBER
977 , p6_a55 out nocopy NUMBER
978 , p6_a56 out nocopy DATE
979 , p6_a57 out nocopy DATE
980 , p6_a58 out nocopy NUMBER
981 , p6_a59 out nocopy VARCHAR2
982 , p6_a60 out nocopy NUMBER
983 , p6_a61 out nocopy VARCHAR2
984 , p5_a0 NUMBER := 0-1962.0724
985 , p5_a1 NUMBER := 0-1962.0724
986 , p5_a2 NUMBER := 0-1962.0724
987 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
988 , p5_a4 DATE := fnd_api.g_miss_date
989 , p5_a5 NUMBER := 0-1962.0724
990 , p5_a6 NUMBER := 0-1962.0724
991 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
992 , p5_a8 NUMBER := 0-1962.0724
993 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
994 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
995 , p5_a11 NUMBER := 0-1962.0724
996 , p5_a12 NUMBER := 0-1962.0724
997 , p5_a13 NUMBER := 0-1962.0724
998 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
999 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1000 , p5_a16 NUMBER := 0-1962.0724
1001 , p5_a17 NUMBER := 0-1962.0724
1002 , p5_a18 DATE := fnd_api.g_miss_date
1003 , p5_a19 NUMBER := 0-1962.0724
1004 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1005 , p5_a21 NUMBER := 0-1962.0724
1006 , p5_a22 NUMBER := 0-1962.0724
1007 , p5_a23 NUMBER := 0-1962.0724
1008 , p5_a24 DATE := fnd_api.g_miss_date
1009 , p5_a25 NUMBER := 0-1962.0724
1010 , p5_a26 NUMBER := 0-1962.0724
1011 , p5_a27 DATE := fnd_api.g_miss_date
1012 , p5_a28 DATE := fnd_api.g_miss_date
1013 , p5_a29 DATE := fnd_api.g_miss_date
1014 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1015 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1016 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1017 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1018 , p5_a34 NUMBER := 0-1962.0724
1019 , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1020 , p5_a36 VARCHAR2 := fnd_api.g_miss_char
1021 , p5_a37 VARCHAR2 := fnd_api.g_miss_char
1022 , p5_a38 VARCHAR2 := fnd_api.g_miss_char
1023 , p5_a39 VARCHAR2 := fnd_api.g_miss_char
1024 , p5_a40 VARCHAR2 := fnd_api.g_miss_char
1025 , p5_a41 VARCHAR2 := fnd_api.g_miss_char
1026 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
1027 , p5_a43 VARCHAR2 := fnd_api.g_miss_char
1028 , p5_a44 VARCHAR2 := fnd_api.g_miss_char
1029 , p5_a45 VARCHAR2 := fnd_api.g_miss_char
1030 , p5_a46 VARCHAR2 := fnd_api.g_miss_char
1031 , p5_a47 VARCHAR2 := fnd_api.g_miss_char
1032 , p5_a48 DATE := fnd_api.g_miss_date
1033 , p5_a49 DATE := fnd_api.g_miss_date
1034 , p5_a50 NUMBER := 0-1962.0724
1035 , p5_a51 NUMBER := 0-1962.0724
1036 , p5_a52 NUMBER := 0-1962.0724
1037 , p5_a53 VARCHAR2 := fnd_api.g_miss_char
1038 , p5_a54 NUMBER := 0-1962.0724
1039 , p5_a55 NUMBER := 0-1962.0724
1040 , p5_a56 DATE := fnd_api.g_miss_date
1041 , p5_a57 DATE := fnd_api.g_miss_date
1042 , p5_a58 NUMBER := 0-1962.0724
1043 , p5_a59 VARCHAR2 := fnd_api.g_miss_char
1044 , p5_a60 NUMBER := 0-1962.0724
1045 , p5_a61 VARCHAR2 := fnd_api.g_miss_char
1046 )
1047
1048 as
1049 ddp_silv_rec okl_sif_lines_pub.silv_rec_type;
1050 ddx_silv_rec okl_sif_lines_pub.silv_rec_type;
1051 ddindx binary_integer; indx binary_integer;
1052 begin
1053
1054 -- copy data to the local IN or IN-OUT args, if any
1055
1056
1057
1058
1059
1060 ddp_silv_rec.id := rosetta_g_miss_num_map(p5_a0);
1061 ddp_silv_rec.state_depre_dmnshing_value_rt := rosetta_g_miss_num_map(p5_a1);
1062 ddp_silv_rec.book_depre_dmnshing_value_rt := rosetta_g_miss_num_map(p5_a2);
1063 ddp_silv_rec.residual_guarantee_method := p5_a3;
1064 ddp_silv_rec.residual_date := rosetta_g_miss_date_in_map(p5_a4);
1065 ddp_silv_rec.fed_depre_term := rosetta_g_miss_num_map(p5_a5);
1066 ddp_silv_rec.fed_depre_dmnshing_value_rate := rosetta_g_miss_num_map(p5_a6);
1067 ddp_silv_rec.fed_depre_adr_conve := p5_a7;
1068 ddp_silv_rec.state_depre_basis_percent := rosetta_g_miss_num_map(p5_a8);
1069 ddp_silv_rec.state_depre_method := p5_a9;
1070 ddp_silv_rec.purchase_option := p5_a10;
1071 ddp_silv_rec.purchase_option_amount := rosetta_g_miss_num_map(p5_a11);
1072 ddp_silv_rec.asset_cost := rosetta_g_miss_num_map(p5_a12);
1073 ddp_silv_rec.state_depre_term := rosetta_g_miss_num_map(p5_a13);
1074 ddp_silv_rec.state_depre_adr_convent := p5_a14;
1075 ddp_silv_rec.fed_depre_method := p5_a15;
1076 ddp_silv_rec.residual_amount := rosetta_g_miss_num_map(p5_a16);
1077 ddp_silv_rec.fed_depre_salvage := rosetta_g_miss_num_map(p5_a17);
1078 ddp_silv_rec.date_fed_depre := rosetta_g_miss_date_in_map(p5_a18);
1079 ddp_silv_rec.book_salvage := rosetta_g_miss_num_map(p5_a19);
1080 ddp_silv_rec.book_adr_convention := p5_a20;
1081 ddp_silv_rec.state_depre_salvage := rosetta_g_miss_num_map(p5_a21);
1082 ddp_silv_rec.fed_depre_basis_percent := rosetta_g_miss_num_map(p5_a22);
1083 ddp_silv_rec.book_basis_percent := rosetta_g_miss_num_map(p5_a23);
1084 ddp_silv_rec.date_delivery := rosetta_g_miss_date_in_map(p5_a24);
1085 ddp_silv_rec.book_term := rosetta_g_miss_num_map(p5_a25);
1086 ddp_silv_rec.residual_guarantee_amount := rosetta_g_miss_num_map(p5_a26);
1087 ddp_silv_rec.date_funding := rosetta_g_miss_date_in_map(p5_a27);
1088 ddp_silv_rec.date_book := rosetta_g_miss_date_in_map(p5_a28);
1089 ddp_silv_rec.date_state_depre := rosetta_g_miss_date_in_map(p5_a29);
1090 ddp_silv_rec.book_method := p5_a30;
1091 ddp_silv_rec.stream_interface_attribute08 := p5_a31;
1092 ddp_silv_rec.stream_interface_attribute03 := p5_a32;
1093 ddp_silv_rec.stream_interface_attribute01 := p5_a33;
1094 ddp_silv_rec.index_number := rosetta_g_miss_num_map(p5_a34);
1095 ddp_silv_rec.stream_interface_attribute05 := p5_a35;
1096 ddp_silv_rec.description := p5_a36;
1097 ddp_silv_rec.stream_interface_attribute10 := p5_a37;
1098 ddp_silv_rec.stream_interface_attribute06 := p5_a38;
1099 ddp_silv_rec.stream_interface_attribute09 := p5_a39;
1100 ddp_silv_rec.stream_interface_attribute07 := p5_a40;
1101 ddp_silv_rec.stream_interface_attribute14 := p5_a41;
1102 ddp_silv_rec.stream_interface_attribute12 := p5_a42;
1103 ddp_silv_rec.stream_interface_attribute15 := p5_a43;
1104 ddp_silv_rec.stream_interface_attribute02 := p5_a44;
1105 ddp_silv_rec.stream_interface_attribute11 := p5_a45;
1106 ddp_silv_rec.stream_interface_attribute04 := p5_a46;
1107 ddp_silv_rec.stream_interface_attribute13 := p5_a47;
1108 ddp_silv_rec.date_start := rosetta_g_miss_date_in_map(p5_a48);
1109 ddp_silv_rec.date_lending := rosetta_g_miss_date_in_map(p5_a49);
1110 ddp_silv_rec.sif_id := rosetta_g_miss_num_map(p5_a50);
1111 ddp_silv_rec.object_version_number := rosetta_g_miss_num_map(p5_a51);
1112 ddp_silv_rec.kle_id := rosetta_g_miss_num_map(p5_a52);
1113 ddp_silv_rec.sil_type := p5_a53;
1114 ddp_silv_rec.created_by := rosetta_g_miss_num_map(p5_a54);
1115 ddp_silv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a55);
1116 ddp_silv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a56);
1117 ddp_silv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a57);
1118 ddp_silv_rec.last_update_login := rosetta_g_miss_num_map(p5_a58);
1119 ddp_silv_rec.residual_guarantee_type := p5_a59;
1120 ddp_silv_rec.down_payment_amount := rosetta_g_miss_num_map(p5_a60);
1121 ddp_silv_rec.capitalize_down_payment_yn := p5_a61;
1122
1123
1124 -- here's the delegated call to the old PL/SQL routine
1125 okl_sif_lines_pub.update_sif_lines(p_api_version,
1126 p_init_msg_list,
1127 x_return_status,
1128 x_msg_count,
1129 x_msg_data,
1130 ddp_silv_rec,
1131 ddx_silv_rec);
1132
1133 -- copy data back from the local variables to OUT or IN-OUT args, if any
1134
1135
1136
1137
1138
1139
1140 p6_a0 := rosetta_g_miss_num_map(ddx_silv_rec.id);
1141 p6_a1 := rosetta_g_miss_num_map(ddx_silv_rec.state_depre_dmnshing_value_rt);
1142 p6_a2 := rosetta_g_miss_num_map(ddx_silv_rec.book_depre_dmnshing_value_rt);
1143 p6_a3 := ddx_silv_rec.residual_guarantee_method;
1144 p6_a4 := ddx_silv_rec.residual_date;
1145 p6_a5 := rosetta_g_miss_num_map(ddx_silv_rec.fed_depre_term);
1146 p6_a6 := rosetta_g_miss_num_map(ddx_silv_rec.fed_depre_dmnshing_value_rate);
1147 p6_a7 := ddx_silv_rec.fed_depre_adr_conve;
1148 p6_a8 := rosetta_g_miss_num_map(ddx_silv_rec.state_depre_basis_percent);
1149 p6_a9 := ddx_silv_rec.state_depre_method;
1150 p6_a10 := ddx_silv_rec.purchase_option;
1151 p6_a11 := rosetta_g_miss_num_map(ddx_silv_rec.purchase_option_amount);
1152 p6_a12 := rosetta_g_miss_num_map(ddx_silv_rec.asset_cost);
1153 p6_a13 := rosetta_g_miss_num_map(ddx_silv_rec.state_depre_term);
1154 p6_a14 := ddx_silv_rec.state_depre_adr_convent;
1155 p6_a15 := ddx_silv_rec.fed_depre_method;
1156 p6_a16 := rosetta_g_miss_num_map(ddx_silv_rec.residual_amount);
1157 p6_a17 := rosetta_g_miss_num_map(ddx_silv_rec.fed_depre_salvage);
1158 p6_a18 := ddx_silv_rec.date_fed_depre;
1159 p6_a19 := rosetta_g_miss_num_map(ddx_silv_rec.book_salvage);
1160 p6_a20 := ddx_silv_rec.book_adr_convention;
1161 p6_a21 := rosetta_g_miss_num_map(ddx_silv_rec.state_depre_salvage);
1162 p6_a22 := rosetta_g_miss_num_map(ddx_silv_rec.fed_depre_basis_percent);
1163 p6_a23 := rosetta_g_miss_num_map(ddx_silv_rec.book_basis_percent);
1164 p6_a24 := ddx_silv_rec.date_delivery;
1165 p6_a25 := rosetta_g_miss_num_map(ddx_silv_rec.book_term);
1166 p6_a26 := rosetta_g_miss_num_map(ddx_silv_rec.residual_guarantee_amount);
1167 p6_a27 := ddx_silv_rec.date_funding;
1168 p6_a28 := ddx_silv_rec.date_book;
1169 p6_a29 := ddx_silv_rec.date_state_depre;
1170 p6_a30 := ddx_silv_rec.book_method;
1171 p6_a31 := ddx_silv_rec.stream_interface_attribute08;
1172 p6_a32 := ddx_silv_rec.stream_interface_attribute03;
1173 p6_a33 := ddx_silv_rec.stream_interface_attribute01;
1174 p6_a34 := rosetta_g_miss_num_map(ddx_silv_rec.index_number);
1175 p6_a35 := ddx_silv_rec.stream_interface_attribute05;
1176 p6_a36 := ddx_silv_rec.description;
1177 p6_a37 := ddx_silv_rec.stream_interface_attribute10;
1178 p6_a38 := ddx_silv_rec.stream_interface_attribute06;
1179 p6_a39 := ddx_silv_rec.stream_interface_attribute09;
1180 p6_a40 := ddx_silv_rec.stream_interface_attribute07;
1181 p6_a41 := ddx_silv_rec.stream_interface_attribute14;
1182 p6_a42 := ddx_silv_rec.stream_interface_attribute12;
1183 p6_a43 := ddx_silv_rec.stream_interface_attribute15;
1184 p6_a44 := ddx_silv_rec.stream_interface_attribute02;
1185 p6_a45 := ddx_silv_rec.stream_interface_attribute11;
1186 p6_a46 := ddx_silv_rec.stream_interface_attribute04;
1187 p6_a47 := ddx_silv_rec.stream_interface_attribute13;
1188 p6_a48 := ddx_silv_rec.date_start;
1189 p6_a49 := ddx_silv_rec.date_lending;
1190 p6_a50 := rosetta_g_miss_num_map(ddx_silv_rec.sif_id);
1191 p6_a51 := rosetta_g_miss_num_map(ddx_silv_rec.object_version_number);
1192 p6_a52 := rosetta_g_miss_num_map(ddx_silv_rec.kle_id);
1193 p6_a53 := ddx_silv_rec.sil_type;
1194 p6_a54 := rosetta_g_miss_num_map(ddx_silv_rec.created_by);
1195 p6_a55 := rosetta_g_miss_num_map(ddx_silv_rec.last_updated_by);
1196 p6_a56 := ddx_silv_rec.creation_date;
1197 p6_a57 := ddx_silv_rec.last_update_date;
1198 p6_a58 := rosetta_g_miss_num_map(ddx_silv_rec.last_update_login);
1199 p6_a59 := ddx_silv_rec.residual_guarantee_type;
1200 p6_a60 := rosetta_g_miss_num_map(ddx_silv_rec.down_payment_amount);
1201 p6_a61 := ddx_silv_rec.capitalize_down_payment_yn;
1202 end;
1203
1204 procedure update_sif_lines(p_api_version NUMBER
1205 , p_init_msg_list VARCHAR2
1206 , x_return_status out nocopy VARCHAR2
1207 , x_msg_count out nocopy NUMBER
1208 , x_msg_data out nocopy VARCHAR2
1209 , p5_a0 JTF_NUMBER_TABLE
1210 , p5_a1 JTF_NUMBER_TABLE
1211 , p5_a2 JTF_NUMBER_TABLE
1212 , p5_a3 JTF_VARCHAR2_TABLE_100
1213 , p5_a4 JTF_DATE_TABLE
1214 , p5_a5 JTF_NUMBER_TABLE
1215 , p5_a6 JTF_NUMBER_TABLE
1216 , p5_a7 JTF_VARCHAR2_TABLE_100
1217 , p5_a8 JTF_NUMBER_TABLE
1218 , p5_a9 JTF_VARCHAR2_TABLE_100
1219 , p5_a10 JTF_VARCHAR2_TABLE_100
1220 , p5_a11 JTF_NUMBER_TABLE
1221 , p5_a12 JTF_NUMBER_TABLE
1222 , p5_a13 JTF_NUMBER_TABLE
1223 , p5_a14 JTF_VARCHAR2_TABLE_100
1224 , p5_a15 JTF_VARCHAR2_TABLE_100
1225 , p5_a16 JTF_NUMBER_TABLE
1226 , p5_a17 JTF_NUMBER_TABLE
1227 , p5_a18 JTF_DATE_TABLE
1228 , p5_a19 JTF_NUMBER_TABLE
1229 , p5_a20 JTF_VARCHAR2_TABLE_100
1230 , p5_a21 JTF_NUMBER_TABLE
1231 , p5_a22 JTF_NUMBER_TABLE
1232 , p5_a23 JTF_NUMBER_TABLE
1233 , p5_a24 JTF_DATE_TABLE
1234 , p5_a25 JTF_NUMBER_TABLE
1235 , p5_a26 JTF_NUMBER_TABLE
1236 , p5_a27 JTF_DATE_TABLE
1237 , p5_a28 JTF_DATE_TABLE
1238 , p5_a29 JTF_DATE_TABLE
1239 , p5_a30 JTF_VARCHAR2_TABLE_100
1240 , p5_a31 JTF_VARCHAR2_TABLE_500
1241 , p5_a32 JTF_VARCHAR2_TABLE_500
1242 , p5_a33 JTF_VARCHAR2_TABLE_500
1243 , p5_a34 JTF_NUMBER_TABLE
1244 , p5_a35 JTF_VARCHAR2_TABLE_500
1245 , p5_a36 JTF_VARCHAR2_TABLE_2000
1246 , p5_a37 JTF_VARCHAR2_TABLE_500
1247 , p5_a38 JTF_VARCHAR2_TABLE_500
1248 , p5_a39 JTF_VARCHAR2_TABLE_500
1249 , p5_a40 JTF_VARCHAR2_TABLE_500
1250 , p5_a41 JTF_VARCHAR2_TABLE_500
1251 , p5_a42 JTF_VARCHAR2_TABLE_500
1252 , p5_a43 JTF_VARCHAR2_TABLE_500
1253 , p5_a44 JTF_VARCHAR2_TABLE_500
1254 , p5_a45 JTF_VARCHAR2_TABLE_500
1255 , p5_a46 JTF_VARCHAR2_TABLE_500
1256 , p5_a47 JTF_VARCHAR2_TABLE_500
1257 , p5_a48 JTF_DATE_TABLE
1258 , p5_a49 JTF_DATE_TABLE
1259 , p5_a50 JTF_NUMBER_TABLE
1260 , p5_a51 JTF_NUMBER_TABLE
1261 , p5_a52 JTF_NUMBER_TABLE
1262 , p5_a53 JTF_VARCHAR2_TABLE_100
1263 , p5_a54 JTF_NUMBER_TABLE
1264 , p5_a55 JTF_NUMBER_TABLE
1265 , p5_a56 JTF_DATE_TABLE
1266 , p5_a57 JTF_DATE_TABLE
1267 , p5_a58 JTF_NUMBER_TABLE
1268 , p5_a59 JTF_VARCHAR2_TABLE_200
1269 , p5_a60 JTF_NUMBER_TABLE
1270 , p5_a61 JTF_VARCHAR2_TABLE_100
1271 , p6_a0 out nocopy JTF_NUMBER_TABLE
1272 , p6_a1 out nocopy JTF_NUMBER_TABLE
1273 , p6_a2 out nocopy JTF_NUMBER_TABLE
1274 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1275 , p6_a4 out nocopy JTF_DATE_TABLE
1276 , p6_a5 out nocopy JTF_NUMBER_TABLE
1277 , p6_a6 out nocopy JTF_NUMBER_TABLE
1278 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
1279 , p6_a8 out nocopy JTF_NUMBER_TABLE
1280 , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
1281 , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
1282 , p6_a11 out nocopy JTF_NUMBER_TABLE
1283 , p6_a12 out nocopy JTF_NUMBER_TABLE
1284 , p6_a13 out nocopy JTF_NUMBER_TABLE
1285 , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
1286 , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
1287 , p6_a16 out nocopy JTF_NUMBER_TABLE
1288 , p6_a17 out nocopy JTF_NUMBER_TABLE
1289 , p6_a18 out nocopy JTF_DATE_TABLE
1290 , p6_a19 out nocopy JTF_NUMBER_TABLE
1291 , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
1292 , p6_a21 out nocopy JTF_NUMBER_TABLE
1293 , p6_a22 out nocopy JTF_NUMBER_TABLE
1294 , p6_a23 out nocopy JTF_NUMBER_TABLE
1295 , p6_a24 out nocopy JTF_DATE_TABLE
1296 , p6_a25 out nocopy JTF_NUMBER_TABLE
1297 , p6_a26 out nocopy JTF_NUMBER_TABLE
1298 , p6_a27 out nocopy JTF_DATE_TABLE
1299 , p6_a28 out nocopy JTF_DATE_TABLE
1300 , p6_a29 out nocopy JTF_DATE_TABLE
1301 , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
1302 , p6_a31 out nocopy JTF_VARCHAR2_TABLE_500
1303 , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
1304 , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
1305 , p6_a34 out nocopy JTF_NUMBER_TABLE
1306 , p6_a35 out nocopy JTF_VARCHAR2_TABLE_500
1307 , p6_a36 out nocopy JTF_VARCHAR2_TABLE_2000
1308 , p6_a37 out nocopy JTF_VARCHAR2_TABLE_500
1309 , p6_a38 out nocopy JTF_VARCHAR2_TABLE_500
1310 , p6_a39 out nocopy JTF_VARCHAR2_TABLE_500
1311 , p6_a40 out nocopy JTF_VARCHAR2_TABLE_500
1312 , p6_a41 out nocopy JTF_VARCHAR2_TABLE_500
1313 , p6_a42 out nocopy JTF_VARCHAR2_TABLE_500
1314 , p6_a43 out nocopy JTF_VARCHAR2_TABLE_500
1315 , p6_a44 out nocopy JTF_VARCHAR2_TABLE_500
1316 , p6_a45 out nocopy JTF_VARCHAR2_TABLE_500
1317 , p6_a46 out nocopy JTF_VARCHAR2_TABLE_500
1318 , p6_a47 out nocopy JTF_VARCHAR2_TABLE_500
1319 , p6_a48 out nocopy JTF_DATE_TABLE
1320 , p6_a49 out nocopy JTF_DATE_TABLE
1321 , p6_a50 out nocopy JTF_NUMBER_TABLE
1322 , p6_a51 out nocopy JTF_NUMBER_TABLE
1323 , p6_a52 out nocopy JTF_NUMBER_TABLE
1324 , p6_a53 out nocopy JTF_VARCHAR2_TABLE_100
1325 , p6_a54 out nocopy JTF_NUMBER_TABLE
1326 , p6_a55 out nocopy JTF_NUMBER_TABLE
1327 , p6_a56 out nocopy JTF_DATE_TABLE
1328 , p6_a57 out nocopy JTF_DATE_TABLE
1329 , p6_a58 out nocopy JTF_NUMBER_TABLE
1330 , p6_a59 out nocopy JTF_VARCHAR2_TABLE_200
1331 , p6_a60 out nocopy JTF_NUMBER_TABLE
1332 , p6_a61 out nocopy JTF_VARCHAR2_TABLE_100
1333 )
1334
1335 as
1336 ddp_silv_tbl okl_sif_lines_pub.silv_tbl_type;
1337 ddx_silv_tbl okl_sif_lines_pub.silv_tbl_type;
1338 ddindx binary_integer; indx binary_integer;
1339 begin
1340
1341 -- copy data to the local IN or IN-OUT args, if any
1342
1343
1344
1345
1346
1347 okl_sil_pvt_w.rosetta_table_copy_in_p5(ddp_silv_tbl, p5_a0
1348 , p5_a1
1349 , p5_a2
1350 , p5_a3
1351 , p5_a4
1352 , p5_a5
1353 , p5_a6
1354 , p5_a7
1355 , p5_a8
1356 , p5_a9
1357 , p5_a10
1358 , p5_a11
1359 , p5_a12
1360 , p5_a13
1361 , p5_a14
1362 , p5_a15
1363 , p5_a16
1364 , p5_a17
1365 , p5_a18
1366 , p5_a19
1367 , p5_a20
1368 , p5_a21
1369 , p5_a22
1370 , p5_a23
1371 , p5_a24
1372 , p5_a25
1373 , p5_a26
1374 , p5_a27
1375 , p5_a28
1376 , p5_a29
1377 , p5_a30
1378 , p5_a31
1379 , p5_a32
1380 , p5_a33
1381 , p5_a34
1382 , p5_a35
1383 , p5_a36
1384 , p5_a37
1385 , p5_a38
1386 , p5_a39
1387 , p5_a40
1388 , p5_a41
1389 , p5_a42
1390 , p5_a43
1391 , p5_a44
1392 , p5_a45
1393 , p5_a46
1394 , p5_a47
1395 , p5_a48
1396 , p5_a49
1397 , p5_a50
1398 , p5_a51
1399 , p5_a52
1400 , p5_a53
1401 , p5_a54
1402 , p5_a55
1403 , p5_a56
1404 , p5_a57
1405 , p5_a58
1406 , p5_a59
1407 , p5_a60
1408 , p5_a61
1409 );
1410
1411
1412 -- here's the delegated call to the old PL/SQL routine
1413 okl_sif_lines_pub.update_sif_lines(p_api_version,
1414 p_init_msg_list,
1415 x_return_status,
1416 x_msg_count,
1417 x_msg_data,
1418 ddp_silv_tbl,
1419 ddx_silv_tbl);
1420
1421 -- copy data back from the local variables to OUT or IN-OUT args, if any
1422
1423
1424
1425
1426
1427
1428 okl_sil_pvt_w.rosetta_table_copy_out_p5(ddx_silv_tbl, p6_a0
1429 , p6_a1
1430 , p6_a2
1431 , p6_a3
1432 , p6_a4
1433 , p6_a5
1434 , p6_a6
1435 , p6_a7
1436 , p6_a8
1437 , p6_a9
1438 , p6_a10
1439 , p6_a11
1440 , p6_a12
1441 , p6_a13
1442 , p6_a14
1443 , p6_a15
1444 , p6_a16
1445 , p6_a17
1446 , p6_a18
1447 , p6_a19
1448 , p6_a20
1449 , p6_a21
1450 , p6_a22
1451 , p6_a23
1452 , p6_a24
1453 , p6_a25
1454 , p6_a26
1455 , p6_a27
1456 , p6_a28
1457 , p6_a29
1458 , p6_a30
1459 , p6_a31
1460 , p6_a32
1461 , p6_a33
1462 , p6_a34
1463 , p6_a35
1464 , p6_a36
1465 , p6_a37
1466 , p6_a38
1467 , p6_a39
1468 , p6_a40
1469 , p6_a41
1470 , p6_a42
1471 , p6_a43
1472 , p6_a44
1473 , p6_a45
1474 , p6_a46
1475 , p6_a47
1476 , p6_a48
1477 , p6_a49
1478 , p6_a50
1479 , p6_a51
1480 , p6_a52
1481 , p6_a53
1482 , p6_a54
1483 , p6_a55
1484 , p6_a56
1485 , p6_a57
1486 , p6_a58
1487 , p6_a59
1488 , p6_a60
1489 , p6_a61
1490 );
1491 end;
1492
1493 procedure delete_sif_lines(p_api_version NUMBER
1494 , p_init_msg_list VARCHAR2
1495 , x_return_status out nocopy VARCHAR2
1496 , x_msg_count out nocopy NUMBER
1497 , x_msg_data out nocopy VARCHAR2
1498 , p6_a0 out nocopy NUMBER
1499 , p6_a1 out nocopy NUMBER
1500 , p6_a2 out nocopy NUMBER
1501 , p6_a3 out nocopy VARCHAR2
1502 , p6_a4 out nocopy DATE
1503 , p6_a5 out nocopy NUMBER
1504 , p6_a6 out nocopy NUMBER
1505 , p6_a7 out nocopy VARCHAR2
1506 , p6_a8 out nocopy NUMBER
1507 , p6_a9 out nocopy VARCHAR2
1508 , p6_a10 out nocopy VARCHAR2
1509 , p6_a11 out nocopy NUMBER
1510 , p6_a12 out nocopy NUMBER
1511 , p6_a13 out nocopy NUMBER
1512 , p6_a14 out nocopy VARCHAR2
1513 , p6_a15 out nocopy VARCHAR2
1514 , p6_a16 out nocopy NUMBER
1515 , p6_a17 out nocopy NUMBER
1516 , p6_a18 out nocopy DATE
1517 , p6_a19 out nocopy NUMBER
1518 , p6_a20 out nocopy VARCHAR2
1519 , p6_a21 out nocopy NUMBER
1520 , p6_a22 out nocopy NUMBER
1521 , p6_a23 out nocopy NUMBER
1522 , p6_a24 out nocopy DATE
1523 , p6_a25 out nocopy NUMBER
1524 , p6_a26 out nocopy NUMBER
1525 , p6_a27 out nocopy DATE
1526 , p6_a28 out nocopy DATE
1527 , p6_a29 out nocopy DATE
1528 , p6_a30 out nocopy VARCHAR2
1529 , p6_a31 out nocopy VARCHAR2
1530 , p6_a32 out nocopy VARCHAR2
1531 , p6_a33 out nocopy VARCHAR2
1532 , p6_a34 out nocopy NUMBER
1533 , p6_a35 out nocopy VARCHAR2
1534 , p6_a36 out nocopy VARCHAR2
1535 , p6_a37 out nocopy VARCHAR2
1536 , p6_a38 out nocopy VARCHAR2
1537 , p6_a39 out nocopy VARCHAR2
1538 , p6_a40 out nocopy VARCHAR2
1539 , p6_a41 out nocopy VARCHAR2
1540 , p6_a42 out nocopy VARCHAR2
1541 , p6_a43 out nocopy VARCHAR2
1542 , p6_a44 out nocopy VARCHAR2
1543 , p6_a45 out nocopy VARCHAR2
1544 , p6_a46 out nocopy VARCHAR2
1545 , p6_a47 out nocopy VARCHAR2
1546 , p6_a48 out nocopy DATE
1547 , p6_a49 out nocopy DATE
1548 , p6_a50 out nocopy NUMBER
1549 , p6_a51 out nocopy NUMBER
1550 , p6_a52 out nocopy NUMBER
1551 , p6_a53 out nocopy VARCHAR2
1552 , p6_a54 out nocopy NUMBER
1553 , p6_a55 out nocopy NUMBER
1554 , p6_a56 out nocopy DATE
1555 , p6_a57 out nocopy DATE
1556 , p6_a58 out nocopy NUMBER
1557 , p6_a59 out nocopy VARCHAR2
1558 , p6_a60 out nocopy NUMBER
1559 , p6_a61 out nocopy VARCHAR2
1560 , p5_a0 NUMBER := 0-1962.0724
1561 , p5_a1 NUMBER := 0-1962.0724
1562 , p5_a2 NUMBER := 0-1962.0724
1563 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1564 , p5_a4 DATE := fnd_api.g_miss_date
1565 , p5_a5 NUMBER := 0-1962.0724
1566 , p5_a6 NUMBER := 0-1962.0724
1567 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1568 , p5_a8 NUMBER := 0-1962.0724
1569 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1570 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1571 , p5_a11 NUMBER := 0-1962.0724
1572 , p5_a12 NUMBER := 0-1962.0724
1573 , p5_a13 NUMBER := 0-1962.0724
1574 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1575 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1576 , p5_a16 NUMBER := 0-1962.0724
1577 , p5_a17 NUMBER := 0-1962.0724
1578 , p5_a18 DATE := fnd_api.g_miss_date
1579 , p5_a19 NUMBER := 0-1962.0724
1580 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1581 , p5_a21 NUMBER := 0-1962.0724
1582 , p5_a22 NUMBER := 0-1962.0724
1583 , p5_a23 NUMBER := 0-1962.0724
1584 , p5_a24 DATE := fnd_api.g_miss_date
1585 , p5_a25 NUMBER := 0-1962.0724
1586 , p5_a26 NUMBER := 0-1962.0724
1587 , p5_a27 DATE := fnd_api.g_miss_date
1588 , p5_a28 DATE := fnd_api.g_miss_date
1589 , p5_a29 DATE := fnd_api.g_miss_date
1590 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1591 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1592 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1593 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1594 , p5_a34 NUMBER := 0-1962.0724
1595 , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1596 , p5_a36 VARCHAR2 := fnd_api.g_miss_char
1597 , p5_a37 VARCHAR2 := fnd_api.g_miss_char
1598 , p5_a38 VARCHAR2 := fnd_api.g_miss_char
1599 , p5_a39 VARCHAR2 := fnd_api.g_miss_char
1600 , p5_a40 VARCHAR2 := fnd_api.g_miss_char
1601 , p5_a41 VARCHAR2 := fnd_api.g_miss_char
1602 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
1603 , p5_a43 VARCHAR2 := fnd_api.g_miss_char
1604 , p5_a44 VARCHAR2 := fnd_api.g_miss_char
1605 , p5_a45 VARCHAR2 := fnd_api.g_miss_char
1606 , p5_a46 VARCHAR2 := fnd_api.g_miss_char
1607 , p5_a47 VARCHAR2 := fnd_api.g_miss_char
1608 , p5_a48 DATE := fnd_api.g_miss_date
1609 , p5_a49 DATE := fnd_api.g_miss_date
1610 , p5_a50 NUMBER := 0-1962.0724
1611 , p5_a51 NUMBER := 0-1962.0724
1612 , p5_a52 NUMBER := 0-1962.0724
1613 , p5_a53 VARCHAR2 := fnd_api.g_miss_char
1614 , p5_a54 NUMBER := 0-1962.0724
1615 , p5_a55 NUMBER := 0-1962.0724
1616 , p5_a56 DATE := fnd_api.g_miss_date
1617 , p5_a57 DATE := fnd_api.g_miss_date
1618 , p5_a58 NUMBER := 0-1962.0724
1619 , p5_a59 VARCHAR2 := fnd_api.g_miss_char
1620 , p5_a60 NUMBER := 0-1962.0724
1621 , p5_a61 VARCHAR2 := fnd_api.g_miss_char
1622 )
1623
1624 as
1625 ddp_silv_rec okl_sif_lines_pub.silv_rec_type;
1626 ddx_silv_rec okl_sif_lines_pub.silv_rec_type;
1627 ddindx binary_integer; indx binary_integer;
1628 begin
1629
1630 -- copy data to the local IN or IN-OUT args, if any
1631
1632
1633
1634
1635
1636 ddp_silv_rec.id := rosetta_g_miss_num_map(p5_a0);
1637 ddp_silv_rec.state_depre_dmnshing_value_rt := rosetta_g_miss_num_map(p5_a1);
1638 ddp_silv_rec.book_depre_dmnshing_value_rt := rosetta_g_miss_num_map(p5_a2);
1639 ddp_silv_rec.residual_guarantee_method := p5_a3;
1640 ddp_silv_rec.residual_date := rosetta_g_miss_date_in_map(p5_a4);
1641 ddp_silv_rec.fed_depre_term := rosetta_g_miss_num_map(p5_a5);
1642 ddp_silv_rec.fed_depre_dmnshing_value_rate := rosetta_g_miss_num_map(p5_a6);
1643 ddp_silv_rec.fed_depre_adr_conve := p5_a7;
1644 ddp_silv_rec.state_depre_basis_percent := rosetta_g_miss_num_map(p5_a8);
1645 ddp_silv_rec.state_depre_method := p5_a9;
1646 ddp_silv_rec.purchase_option := p5_a10;
1647 ddp_silv_rec.purchase_option_amount := rosetta_g_miss_num_map(p5_a11);
1648 ddp_silv_rec.asset_cost := rosetta_g_miss_num_map(p5_a12);
1649 ddp_silv_rec.state_depre_term := rosetta_g_miss_num_map(p5_a13);
1650 ddp_silv_rec.state_depre_adr_convent := p5_a14;
1651 ddp_silv_rec.fed_depre_method := p5_a15;
1652 ddp_silv_rec.residual_amount := rosetta_g_miss_num_map(p5_a16);
1653 ddp_silv_rec.fed_depre_salvage := rosetta_g_miss_num_map(p5_a17);
1654 ddp_silv_rec.date_fed_depre := rosetta_g_miss_date_in_map(p5_a18);
1655 ddp_silv_rec.book_salvage := rosetta_g_miss_num_map(p5_a19);
1656 ddp_silv_rec.book_adr_convention := p5_a20;
1657 ddp_silv_rec.state_depre_salvage := rosetta_g_miss_num_map(p5_a21);
1658 ddp_silv_rec.fed_depre_basis_percent := rosetta_g_miss_num_map(p5_a22);
1659 ddp_silv_rec.book_basis_percent := rosetta_g_miss_num_map(p5_a23);
1660 ddp_silv_rec.date_delivery := rosetta_g_miss_date_in_map(p5_a24);
1661 ddp_silv_rec.book_term := rosetta_g_miss_num_map(p5_a25);
1662 ddp_silv_rec.residual_guarantee_amount := rosetta_g_miss_num_map(p5_a26);
1663 ddp_silv_rec.date_funding := rosetta_g_miss_date_in_map(p5_a27);
1664 ddp_silv_rec.date_book := rosetta_g_miss_date_in_map(p5_a28);
1665 ddp_silv_rec.date_state_depre := rosetta_g_miss_date_in_map(p5_a29);
1666 ddp_silv_rec.book_method := p5_a30;
1667 ddp_silv_rec.stream_interface_attribute08 := p5_a31;
1668 ddp_silv_rec.stream_interface_attribute03 := p5_a32;
1669 ddp_silv_rec.stream_interface_attribute01 := p5_a33;
1670 ddp_silv_rec.index_number := rosetta_g_miss_num_map(p5_a34);
1671 ddp_silv_rec.stream_interface_attribute05 := p5_a35;
1672 ddp_silv_rec.description := p5_a36;
1673 ddp_silv_rec.stream_interface_attribute10 := p5_a37;
1674 ddp_silv_rec.stream_interface_attribute06 := p5_a38;
1675 ddp_silv_rec.stream_interface_attribute09 := p5_a39;
1676 ddp_silv_rec.stream_interface_attribute07 := p5_a40;
1677 ddp_silv_rec.stream_interface_attribute14 := p5_a41;
1678 ddp_silv_rec.stream_interface_attribute12 := p5_a42;
1679 ddp_silv_rec.stream_interface_attribute15 := p5_a43;
1680 ddp_silv_rec.stream_interface_attribute02 := p5_a44;
1681 ddp_silv_rec.stream_interface_attribute11 := p5_a45;
1682 ddp_silv_rec.stream_interface_attribute04 := p5_a46;
1683 ddp_silv_rec.stream_interface_attribute13 := p5_a47;
1684 ddp_silv_rec.date_start := rosetta_g_miss_date_in_map(p5_a48);
1685 ddp_silv_rec.date_lending := rosetta_g_miss_date_in_map(p5_a49);
1686 ddp_silv_rec.sif_id := rosetta_g_miss_num_map(p5_a50);
1687 ddp_silv_rec.object_version_number := rosetta_g_miss_num_map(p5_a51);
1688 ddp_silv_rec.kle_id := rosetta_g_miss_num_map(p5_a52);
1689 ddp_silv_rec.sil_type := p5_a53;
1690 ddp_silv_rec.created_by := rosetta_g_miss_num_map(p5_a54);
1691 ddp_silv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a55);
1692 ddp_silv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a56);
1693 ddp_silv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a57);
1694 ddp_silv_rec.last_update_login := rosetta_g_miss_num_map(p5_a58);
1695 ddp_silv_rec.residual_guarantee_type := p5_a59;
1696 ddp_silv_rec.down_payment_amount := rosetta_g_miss_num_map(p5_a60);
1697 ddp_silv_rec.capitalize_down_payment_yn := p5_a61;
1698
1699
1700 -- here's the delegated call to the old PL/SQL routine
1701 okl_sif_lines_pub.delete_sif_lines(p_api_version,
1702 p_init_msg_list,
1703 x_return_status,
1704 x_msg_count,
1705 x_msg_data,
1706 ddp_silv_rec,
1707 ddx_silv_rec);
1708
1709 -- copy data back from the local variables to OUT or IN-OUT args, if any
1710
1711
1712
1713
1714
1715
1716 p6_a0 := rosetta_g_miss_num_map(ddx_silv_rec.id);
1717 p6_a1 := rosetta_g_miss_num_map(ddx_silv_rec.state_depre_dmnshing_value_rt);
1718 p6_a2 := rosetta_g_miss_num_map(ddx_silv_rec.book_depre_dmnshing_value_rt);
1719 p6_a3 := ddx_silv_rec.residual_guarantee_method;
1720 p6_a4 := ddx_silv_rec.residual_date;
1721 p6_a5 := rosetta_g_miss_num_map(ddx_silv_rec.fed_depre_term);
1722 p6_a6 := rosetta_g_miss_num_map(ddx_silv_rec.fed_depre_dmnshing_value_rate);
1723 p6_a7 := ddx_silv_rec.fed_depre_adr_conve;
1724 p6_a8 := rosetta_g_miss_num_map(ddx_silv_rec.state_depre_basis_percent);
1725 p6_a9 := ddx_silv_rec.state_depre_method;
1726 p6_a10 := ddx_silv_rec.purchase_option;
1727 p6_a11 := rosetta_g_miss_num_map(ddx_silv_rec.purchase_option_amount);
1728 p6_a12 := rosetta_g_miss_num_map(ddx_silv_rec.asset_cost);
1729 p6_a13 := rosetta_g_miss_num_map(ddx_silv_rec.state_depre_term);
1730 p6_a14 := ddx_silv_rec.state_depre_adr_convent;
1731 p6_a15 := ddx_silv_rec.fed_depre_method;
1732 p6_a16 := rosetta_g_miss_num_map(ddx_silv_rec.residual_amount);
1733 p6_a17 := rosetta_g_miss_num_map(ddx_silv_rec.fed_depre_salvage);
1734 p6_a18 := ddx_silv_rec.date_fed_depre;
1735 p6_a19 := rosetta_g_miss_num_map(ddx_silv_rec.book_salvage);
1736 p6_a20 := ddx_silv_rec.book_adr_convention;
1737 p6_a21 := rosetta_g_miss_num_map(ddx_silv_rec.state_depre_salvage);
1738 p6_a22 := rosetta_g_miss_num_map(ddx_silv_rec.fed_depre_basis_percent);
1739 p6_a23 := rosetta_g_miss_num_map(ddx_silv_rec.book_basis_percent);
1740 p6_a24 := ddx_silv_rec.date_delivery;
1741 p6_a25 := rosetta_g_miss_num_map(ddx_silv_rec.book_term);
1742 p6_a26 := rosetta_g_miss_num_map(ddx_silv_rec.residual_guarantee_amount);
1743 p6_a27 := ddx_silv_rec.date_funding;
1744 p6_a28 := ddx_silv_rec.date_book;
1745 p6_a29 := ddx_silv_rec.date_state_depre;
1746 p6_a30 := ddx_silv_rec.book_method;
1747 p6_a31 := ddx_silv_rec.stream_interface_attribute08;
1748 p6_a32 := ddx_silv_rec.stream_interface_attribute03;
1749 p6_a33 := ddx_silv_rec.stream_interface_attribute01;
1750 p6_a34 := rosetta_g_miss_num_map(ddx_silv_rec.index_number);
1751 p6_a35 := ddx_silv_rec.stream_interface_attribute05;
1752 p6_a36 := ddx_silv_rec.description;
1753 p6_a37 := ddx_silv_rec.stream_interface_attribute10;
1754 p6_a38 := ddx_silv_rec.stream_interface_attribute06;
1755 p6_a39 := ddx_silv_rec.stream_interface_attribute09;
1756 p6_a40 := ddx_silv_rec.stream_interface_attribute07;
1757 p6_a41 := ddx_silv_rec.stream_interface_attribute14;
1758 p6_a42 := ddx_silv_rec.stream_interface_attribute12;
1759 p6_a43 := ddx_silv_rec.stream_interface_attribute15;
1760 p6_a44 := ddx_silv_rec.stream_interface_attribute02;
1761 p6_a45 := ddx_silv_rec.stream_interface_attribute11;
1762 p6_a46 := ddx_silv_rec.stream_interface_attribute04;
1763 p6_a47 := ddx_silv_rec.stream_interface_attribute13;
1764 p6_a48 := ddx_silv_rec.date_start;
1765 p6_a49 := ddx_silv_rec.date_lending;
1766 p6_a50 := rosetta_g_miss_num_map(ddx_silv_rec.sif_id);
1767 p6_a51 := rosetta_g_miss_num_map(ddx_silv_rec.object_version_number);
1768 p6_a52 := rosetta_g_miss_num_map(ddx_silv_rec.kle_id);
1769 p6_a53 := ddx_silv_rec.sil_type;
1770 p6_a54 := rosetta_g_miss_num_map(ddx_silv_rec.created_by);
1771 p6_a55 := rosetta_g_miss_num_map(ddx_silv_rec.last_updated_by);
1772 p6_a56 := ddx_silv_rec.creation_date;
1773 p6_a57 := ddx_silv_rec.last_update_date;
1774 p6_a58 := rosetta_g_miss_num_map(ddx_silv_rec.last_update_login);
1775 p6_a59 := ddx_silv_rec.residual_guarantee_type;
1776 p6_a60 := rosetta_g_miss_num_map(ddx_silv_rec.down_payment_amount);
1777 p6_a61 := ddx_silv_rec.capitalize_down_payment_yn;
1778 end;
1779
1780 procedure delete_sif_lines(p_api_version NUMBER
1781 , p_init_msg_list VARCHAR2
1782 , x_return_status out nocopy VARCHAR2
1783 , x_msg_count out nocopy NUMBER
1784 , x_msg_data out nocopy VARCHAR2
1785 , p5_a0 JTF_NUMBER_TABLE
1786 , p5_a1 JTF_NUMBER_TABLE
1787 , p5_a2 JTF_NUMBER_TABLE
1788 , p5_a3 JTF_VARCHAR2_TABLE_100
1789 , p5_a4 JTF_DATE_TABLE
1790 , p5_a5 JTF_NUMBER_TABLE
1791 , p5_a6 JTF_NUMBER_TABLE
1792 , p5_a7 JTF_VARCHAR2_TABLE_100
1793 , p5_a8 JTF_NUMBER_TABLE
1794 , p5_a9 JTF_VARCHAR2_TABLE_100
1795 , p5_a10 JTF_VARCHAR2_TABLE_100
1796 , p5_a11 JTF_NUMBER_TABLE
1797 , p5_a12 JTF_NUMBER_TABLE
1798 , p5_a13 JTF_NUMBER_TABLE
1799 , p5_a14 JTF_VARCHAR2_TABLE_100
1800 , p5_a15 JTF_VARCHAR2_TABLE_100
1801 , p5_a16 JTF_NUMBER_TABLE
1802 , p5_a17 JTF_NUMBER_TABLE
1803 , p5_a18 JTF_DATE_TABLE
1804 , p5_a19 JTF_NUMBER_TABLE
1805 , p5_a20 JTF_VARCHAR2_TABLE_100
1806 , p5_a21 JTF_NUMBER_TABLE
1807 , p5_a22 JTF_NUMBER_TABLE
1808 , p5_a23 JTF_NUMBER_TABLE
1809 , p5_a24 JTF_DATE_TABLE
1810 , p5_a25 JTF_NUMBER_TABLE
1811 , p5_a26 JTF_NUMBER_TABLE
1812 , p5_a27 JTF_DATE_TABLE
1813 , p5_a28 JTF_DATE_TABLE
1814 , p5_a29 JTF_DATE_TABLE
1815 , p5_a30 JTF_VARCHAR2_TABLE_100
1816 , p5_a31 JTF_VARCHAR2_TABLE_500
1817 , p5_a32 JTF_VARCHAR2_TABLE_500
1818 , p5_a33 JTF_VARCHAR2_TABLE_500
1819 , p5_a34 JTF_NUMBER_TABLE
1820 , p5_a35 JTF_VARCHAR2_TABLE_500
1821 , p5_a36 JTF_VARCHAR2_TABLE_2000
1822 , p5_a37 JTF_VARCHAR2_TABLE_500
1823 , p5_a38 JTF_VARCHAR2_TABLE_500
1824 , p5_a39 JTF_VARCHAR2_TABLE_500
1825 , p5_a40 JTF_VARCHAR2_TABLE_500
1826 , p5_a41 JTF_VARCHAR2_TABLE_500
1827 , p5_a42 JTF_VARCHAR2_TABLE_500
1828 , p5_a43 JTF_VARCHAR2_TABLE_500
1829 , p5_a44 JTF_VARCHAR2_TABLE_500
1830 , p5_a45 JTF_VARCHAR2_TABLE_500
1831 , p5_a46 JTF_VARCHAR2_TABLE_500
1832 , p5_a47 JTF_VARCHAR2_TABLE_500
1833 , p5_a48 JTF_DATE_TABLE
1834 , p5_a49 JTF_DATE_TABLE
1835 , p5_a50 JTF_NUMBER_TABLE
1836 , p5_a51 JTF_NUMBER_TABLE
1837 , p5_a52 JTF_NUMBER_TABLE
1838 , p5_a53 JTF_VARCHAR2_TABLE_100
1839 , p5_a54 JTF_NUMBER_TABLE
1840 , p5_a55 JTF_NUMBER_TABLE
1841 , p5_a56 JTF_DATE_TABLE
1842 , p5_a57 JTF_DATE_TABLE
1843 , p5_a58 JTF_NUMBER_TABLE
1844 , p5_a59 JTF_VARCHAR2_TABLE_200
1845 , p5_a60 JTF_NUMBER_TABLE
1846 , p5_a61 JTF_VARCHAR2_TABLE_100
1847 , p6_a0 out nocopy JTF_NUMBER_TABLE
1848 , p6_a1 out nocopy JTF_NUMBER_TABLE
1849 , p6_a2 out nocopy JTF_NUMBER_TABLE
1850 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1851 , p6_a4 out nocopy JTF_DATE_TABLE
1852 , p6_a5 out nocopy JTF_NUMBER_TABLE
1853 , p6_a6 out nocopy JTF_NUMBER_TABLE
1854 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
1855 , p6_a8 out nocopy JTF_NUMBER_TABLE
1856 , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
1857 , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
1858 , p6_a11 out nocopy JTF_NUMBER_TABLE
1859 , p6_a12 out nocopy JTF_NUMBER_TABLE
1860 , p6_a13 out nocopy JTF_NUMBER_TABLE
1861 , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
1862 , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
1863 , p6_a16 out nocopy JTF_NUMBER_TABLE
1864 , p6_a17 out nocopy JTF_NUMBER_TABLE
1865 , p6_a18 out nocopy JTF_DATE_TABLE
1866 , p6_a19 out nocopy JTF_NUMBER_TABLE
1867 , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
1868 , p6_a21 out nocopy JTF_NUMBER_TABLE
1869 , p6_a22 out nocopy JTF_NUMBER_TABLE
1870 , p6_a23 out nocopy JTF_NUMBER_TABLE
1871 , p6_a24 out nocopy JTF_DATE_TABLE
1872 , p6_a25 out nocopy JTF_NUMBER_TABLE
1873 , p6_a26 out nocopy JTF_NUMBER_TABLE
1874 , p6_a27 out nocopy JTF_DATE_TABLE
1875 , p6_a28 out nocopy JTF_DATE_TABLE
1876 , p6_a29 out nocopy JTF_DATE_TABLE
1877 , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
1878 , p6_a31 out nocopy JTF_VARCHAR2_TABLE_500
1879 , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
1880 , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
1881 , p6_a34 out nocopy JTF_NUMBER_TABLE
1882 , p6_a35 out nocopy JTF_VARCHAR2_TABLE_500
1883 , p6_a36 out nocopy JTF_VARCHAR2_TABLE_2000
1884 , p6_a37 out nocopy JTF_VARCHAR2_TABLE_500
1885 , p6_a38 out nocopy JTF_VARCHAR2_TABLE_500
1886 , p6_a39 out nocopy JTF_VARCHAR2_TABLE_500
1887 , p6_a40 out nocopy JTF_VARCHAR2_TABLE_500
1888 , p6_a41 out nocopy JTF_VARCHAR2_TABLE_500
1889 , p6_a42 out nocopy JTF_VARCHAR2_TABLE_500
1890 , p6_a43 out nocopy JTF_VARCHAR2_TABLE_500
1891 , p6_a44 out nocopy JTF_VARCHAR2_TABLE_500
1892 , p6_a45 out nocopy JTF_VARCHAR2_TABLE_500
1893 , p6_a46 out nocopy JTF_VARCHAR2_TABLE_500
1894 , p6_a47 out nocopy JTF_VARCHAR2_TABLE_500
1895 , p6_a48 out nocopy JTF_DATE_TABLE
1896 , p6_a49 out nocopy JTF_DATE_TABLE
1897 , p6_a50 out nocopy JTF_NUMBER_TABLE
1898 , p6_a51 out nocopy JTF_NUMBER_TABLE
1899 , p6_a52 out nocopy JTF_NUMBER_TABLE
1900 , p6_a53 out nocopy JTF_VARCHAR2_TABLE_100
1901 , p6_a54 out nocopy JTF_NUMBER_TABLE
1902 , p6_a55 out nocopy JTF_NUMBER_TABLE
1903 , p6_a56 out nocopy JTF_DATE_TABLE
1904 , p6_a57 out nocopy JTF_DATE_TABLE
1905 , p6_a58 out nocopy JTF_NUMBER_TABLE
1906 , p6_a59 out nocopy JTF_VARCHAR2_TABLE_200
1907 , p6_a60 out nocopy JTF_NUMBER_TABLE
1908 , p6_a61 out nocopy JTF_VARCHAR2_TABLE_100
1909 )
1910
1911 as
1912 ddp_silv_tbl okl_sif_lines_pub.silv_tbl_type;
1913 ddx_silv_tbl okl_sif_lines_pub.silv_tbl_type;
1914 ddindx binary_integer; indx binary_integer;
1915 begin
1916
1917 -- copy data to the local IN or IN-OUT args, if any
1918
1919
1920
1921
1922
1923 okl_sil_pvt_w.rosetta_table_copy_in_p5(ddp_silv_tbl, p5_a0
1924 , p5_a1
1925 , p5_a2
1926 , p5_a3
1927 , p5_a4
1928 , p5_a5
1929 , p5_a6
1930 , p5_a7
1931 , p5_a8
1932 , p5_a9
1933 , p5_a10
1934 , p5_a11
1935 , p5_a12
1936 , p5_a13
1937 , p5_a14
1938 , p5_a15
1939 , p5_a16
1940 , p5_a17
1941 , p5_a18
1942 , p5_a19
1943 , p5_a20
1944 , p5_a21
1945 , p5_a22
1946 , p5_a23
1947 , p5_a24
1948 , p5_a25
1949 , p5_a26
1950 , p5_a27
1951 , p5_a28
1952 , p5_a29
1953 , p5_a30
1954 , p5_a31
1955 , p5_a32
1956 , p5_a33
1957 , p5_a34
1958 , p5_a35
1959 , p5_a36
1960 , p5_a37
1961 , p5_a38
1962 , p5_a39
1963 , p5_a40
1964 , p5_a41
1965 , p5_a42
1966 , p5_a43
1967 , p5_a44
1968 , p5_a45
1969 , p5_a46
1970 , p5_a47
1971 , p5_a48
1972 , p5_a49
1973 , p5_a50
1974 , p5_a51
1975 , p5_a52
1976 , p5_a53
1977 , p5_a54
1978 , p5_a55
1979 , p5_a56
1980 , p5_a57
1981 , p5_a58
1982 , p5_a59
1983 , p5_a60
1984 , p5_a61
1985 );
1986
1987
1988 -- here's the delegated call to the old PL/SQL routine
1989 okl_sif_lines_pub.delete_sif_lines(p_api_version,
1990 p_init_msg_list,
1991 x_return_status,
1992 x_msg_count,
1993 x_msg_data,
1994 ddp_silv_tbl,
1995 ddx_silv_tbl);
1996
1997 -- copy data back from the local variables to OUT or IN-OUT args, if any
1998
1999
2000
2001
2002
2003
2004 okl_sil_pvt_w.rosetta_table_copy_out_p5(ddx_silv_tbl, p6_a0
2005 , p6_a1
2006 , p6_a2
2007 , p6_a3
2008 , p6_a4
2009 , p6_a5
2010 , p6_a6
2011 , p6_a7
2012 , p6_a8
2013 , p6_a9
2014 , p6_a10
2015 , p6_a11
2016 , p6_a12
2017 , p6_a13
2018 , p6_a14
2019 , p6_a15
2020 , p6_a16
2021 , p6_a17
2022 , p6_a18
2023 , p6_a19
2024 , p6_a20
2025 , p6_a21
2026 , p6_a22
2027 , p6_a23
2028 , p6_a24
2029 , p6_a25
2030 , p6_a26
2031 , p6_a27
2032 , p6_a28
2033 , p6_a29
2034 , p6_a30
2035 , p6_a31
2036 , p6_a32
2037 , p6_a33
2038 , p6_a34
2039 , p6_a35
2040 , p6_a36
2041 , p6_a37
2042 , p6_a38
2043 , p6_a39
2044 , p6_a40
2045 , p6_a41
2046 , p6_a42
2047 , p6_a43
2048 , p6_a44
2049 , p6_a45
2050 , p6_a46
2051 , p6_a47
2052 , p6_a48
2053 , p6_a49
2054 , p6_a50
2055 , p6_a51
2056 , p6_a52
2057 , p6_a53
2058 , p6_a54
2059 , p6_a55
2060 , p6_a56
2061 , p6_a57
2062 , p6_a58
2063 , p6_a59
2064 , p6_a60
2065 , p6_a61
2066 );
2067 end;
2068
2069 procedure validate_sif_lines(p_api_version NUMBER
2070 , p_init_msg_list VARCHAR2
2071 , x_return_status out nocopy VARCHAR2
2072 , x_msg_count out nocopy NUMBER
2073 , x_msg_data out nocopy VARCHAR2
2074 , p6_a0 out nocopy NUMBER
2075 , p6_a1 out nocopy NUMBER
2076 , p6_a2 out nocopy NUMBER
2077 , p6_a3 out nocopy VARCHAR2
2078 , p6_a4 out nocopy DATE
2079 , p6_a5 out nocopy NUMBER
2080 , p6_a6 out nocopy NUMBER
2081 , p6_a7 out nocopy VARCHAR2
2082 , p6_a8 out nocopy NUMBER
2083 , p6_a9 out nocopy VARCHAR2
2084 , p6_a10 out nocopy VARCHAR2
2085 , p6_a11 out nocopy NUMBER
2086 , p6_a12 out nocopy NUMBER
2087 , p6_a13 out nocopy NUMBER
2088 , p6_a14 out nocopy VARCHAR2
2089 , p6_a15 out nocopy VARCHAR2
2090 , p6_a16 out nocopy NUMBER
2091 , p6_a17 out nocopy NUMBER
2092 , p6_a18 out nocopy DATE
2093 , p6_a19 out nocopy NUMBER
2094 , p6_a20 out nocopy VARCHAR2
2095 , p6_a21 out nocopy NUMBER
2096 , p6_a22 out nocopy NUMBER
2097 , p6_a23 out nocopy NUMBER
2098 , p6_a24 out nocopy DATE
2099 , p6_a25 out nocopy NUMBER
2100 , p6_a26 out nocopy NUMBER
2101 , p6_a27 out nocopy DATE
2102 , p6_a28 out nocopy DATE
2103 , p6_a29 out nocopy DATE
2104 , p6_a30 out nocopy VARCHAR2
2105 , p6_a31 out nocopy VARCHAR2
2106 , p6_a32 out nocopy VARCHAR2
2107 , p6_a33 out nocopy VARCHAR2
2108 , p6_a34 out nocopy NUMBER
2109 , p6_a35 out nocopy VARCHAR2
2110 , p6_a36 out nocopy VARCHAR2
2111 , p6_a37 out nocopy VARCHAR2
2112 , p6_a38 out nocopy VARCHAR2
2113 , p6_a39 out nocopy VARCHAR2
2114 , p6_a40 out nocopy VARCHAR2
2115 , p6_a41 out nocopy VARCHAR2
2116 , p6_a42 out nocopy VARCHAR2
2117 , p6_a43 out nocopy VARCHAR2
2118 , p6_a44 out nocopy VARCHAR2
2119 , p6_a45 out nocopy VARCHAR2
2120 , p6_a46 out nocopy VARCHAR2
2121 , p6_a47 out nocopy VARCHAR2
2122 , p6_a48 out nocopy DATE
2123 , p6_a49 out nocopy DATE
2124 , p6_a50 out nocopy NUMBER
2125 , p6_a51 out nocopy NUMBER
2126 , p6_a52 out nocopy NUMBER
2127 , p6_a53 out nocopy VARCHAR2
2128 , p6_a54 out nocopy NUMBER
2129 , p6_a55 out nocopy NUMBER
2130 , p6_a56 out nocopy DATE
2131 , p6_a57 out nocopy DATE
2132 , p6_a58 out nocopy NUMBER
2133 , p6_a59 out nocopy VARCHAR2
2134 , p6_a60 out nocopy NUMBER
2135 , p6_a61 out nocopy VARCHAR2
2136 , p5_a0 NUMBER := 0-1962.0724
2137 , p5_a1 NUMBER := 0-1962.0724
2138 , p5_a2 NUMBER := 0-1962.0724
2139 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
2140 , p5_a4 DATE := fnd_api.g_miss_date
2141 , p5_a5 NUMBER := 0-1962.0724
2142 , p5_a6 NUMBER := 0-1962.0724
2143 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
2144 , p5_a8 NUMBER := 0-1962.0724
2145 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
2146 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
2147 , p5_a11 NUMBER := 0-1962.0724
2148 , p5_a12 NUMBER := 0-1962.0724
2149 , p5_a13 NUMBER := 0-1962.0724
2150 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
2151 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
2152 , p5_a16 NUMBER := 0-1962.0724
2153 , p5_a17 NUMBER := 0-1962.0724
2154 , p5_a18 DATE := fnd_api.g_miss_date
2155 , p5_a19 NUMBER := 0-1962.0724
2156 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
2157 , p5_a21 NUMBER := 0-1962.0724
2158 , p5_a22 NUMBER := 0-1962.0724
2159 , p5_a23 NUMBER := 0-1962.0724
2160 , p5_a24 DATE := fnd_api.g_miss_date
2161 , p5_a25 NUMBER := 0-1962.0724
2162 , p5_a26 NUMBER := 0-1962.0724
2163 , p5_a27 DATE := fnd_api.g_miss_date
2164 , p5_a28 DATE := fnd_api.g_miss_date
2165 , p5_a29 DATE := fnd_api.g_miss_date
2166 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
2167 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
2168 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
2169 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
2170 , p5_a34 NUMBER := 0-1962.0724
2171 , p5_a35 VARCHAR2 := fnd_api.g_miss_char
2172 , p5_a36 VARCHAR2 := fnd_api.g_miss_char
2173 , p5_a37 VARCHAR2 := fnd_api.g_miss_char
2174 , p5_a38 VARCHAR2 := fnd_api.g_miss_char
2175 , p5_a39 VARCHAR2 := fnd_api.g_miss_char
2176 , p5_a40 VARCHAR2 := fnd_api.g_miss_char
2177 , p5_a41 VARCHAR2 := fnd_api.g_miss_char
2178 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
2179 , p5_a43 VARCHAR2 := fnd_api.g_miss_char
2180 , p5_a44 VARCHAR2 := fnd_api.g_miss_char
2181 , p5_a45 VARCHAR2 := fnd_api.g_miss_char
2182 , p5_a46 VARCHAR2 := fnd_api.g_miss_char
2183 , p5_a47 VARCHAR2 := fnd_api.g_miss_char
2184 , p5_a48 DATE := fnd_api.g_miss_date
2185 , p5_a49 DATE := fnd_api.g_miss_date
2186 , p5_a50 NUMBER := 0-1962.0724
2187 , p5_a51 NUMBER := 0-1962.0724
2188 , p5_a52 NUMBER := 0-1962.0724
2189 , p5_a53 VARCHAR2 := fnd_api.g_miss_char
2190 , p5_a54 NUMBER := 0-1962.0724
2191 , p5_a55 NUMBER := 0-1962.0724
2192 , p5_a56 DATE := fnd_api.g_miss_date
2193 , p5_a57 DATE := fnd_api.g_miss_date
2194 , p5_a58 NUMBER := 0-1962.0724
2195 , p5_a59 VARCHAR2 := fnd_api.g_miss_char
2196 , p5_a60 NUMBER := 0-1962.0724
2197 , p5_a61 VARCHAR2 := fnd_api.g_miss_char
2198 )
2199
2200 as
2201 ddp_silv_rec okl_sif_lines_pub.silv_rec_type;
2202 ddx_silv_rec okl_sif_lines_pub.silv_rec_type;
2203 ddindx binary_integer; indx binary_integer;
2204 begin
2205
2206 -- copy data to the local IN or IN-OUT args, if any
2207
2208
2209
2210
2211
2212 ddp_silv_rec.id := rosetta_g_miss_num_map(p5_a0);
2213 ddp_silv_rec.state_depre_dmnshing_value_rt := rosetta_g_miss_num_map(p5_a1);
2214 ddp_silv_rec.book_depre_dmnshing_value_rt := rosetta_g_miss_num_map(p5_a2);
2215 ddp_silv_rec.residual_guarantee_method := p5_a3;
2216 ddp_silv_rec.residual_date := rosetta_g_miss_date_in_map(p5_a4);
2217 ddp_silv_rec.fed_depre_term := rosetta_g_miss_num_map(p5_a5);
2218 ddp_silv_rec.fed_depre_dmnshing_value_rate := rosetta_g_miss_num_map(p5_a6);
2219 ddp_silv_rec.fed_depre_adr_conve := p5_a7;
2220 ddp_silv_rec.state_depre_basis_percent := rosetta_g_miss_num_map(p5_a8);
2221 ddp_silv_rec.state_depre_method := p5_a9;
2222 ddp_silv_rec.purchase_option := p5_a10;
2223 ddp_silv_rec.purchase_option_amount := rosetta_g_miss_num_map(p5_a11);
2224 ddp_silv_rec.asset_cost := rosetta_g_miss_num_map(p5_a12);
2225 ddp_silv_rec.state_depre_term := rosetta_g_miss_num_map(p5_a13);
2226 ddp_silv_rec.state_depre_adr_convent := p5_a14;
2227 ddp_silv_rec.fed_depre_method := p5_a15;
2228 ddp_silv_rec.residual_amount := rosetta_g_miss_num_map(p5_a16);
2229 ddp_silv_rec.fed_depre_salvage := rosetta_g_miss_num_map(p5_a17);
2230 ddp_silv_rec.date_fed_depre := rosetta_g_miss_date_in_map(p5_a18);
2231 ddp_silv_rec.book_salvage := rosetta_g_miss_num_map(p5_a19);
2232 ddp_silv_rec.book_adr_convention := p5_a20;
2233 ddp_silv_rec.state_depre_salvage := rosetta_g_miss_num_map(p5_a21);
2234 ddp_silv_rec.fed_depre_basis_percent := rosetta_g_miss_num_map(p5_a22);
2235 ddp_silv_rec.book_basis_percent := rosetta_g_miss_num_map(p5_a23);
2236 ddp_silv_rec.date_delivery := rosetta_g_miss_date_in_map(p5_a24);
2237 ddp_silv_rec.book_term := rosetta_g_miss_num_map(p5_a25);
2238 ddp_silv_rec.residual_guarantee_amount := rosetta_g_miss_num_map(p5_a26);
2239 ddp_silv_rec.date_funding := rosetta_g_miss_date_in_map(p5_a27);
2240 ddp_silv_rec.date_book := rosetta_g_miss_date_in_map(p5_a28);
2241 ddp_silv_rec.date_state_depre := rosetta_g_miss_date_in_map(p5_a29);
2242 ddp_silv_rec.book_method := p5_a30;
2243 ddp_silv_rec.stream_interface_attribute08 := p5_a31;
2244 ddp_silv_rec.stream_interface_attribute03 := p5_a32;
2245 ddp_silv_rec.stream_interface_attribute01 := p5_a33;
2246 ddp_silv_rec.index_number := rosetta_g_miss_num_map(p5_a34);
2247 ddp_silv_rec.stream_interface_attribute05 := p5_a35;
2248 ddp_silv_rec.description := p5_a36;
2249 ddp_silv_rec.stream_interface_attribute10 := p5_a37;
2250 ddp_silv_rec.stream_interface_attribute06 := p5_a38;
2251 ddp_silv_rec.stream_interface_attribute09 := p5_a39;
2252 ddp_silv_rec.stream_interface_attribute07 := p5_a40;
2253 ddp_silv_rec.stream_interface_attribute14 := p5_a41;
2254 ddp_silv_rec.stream_interface_attribute12 := p5_a42;
2255 ddp_silv_rec.stream_interface_attribute15 := p5_a43;
2256 ddp_silv_rec.stream_interface_attribute02 := p5_a44;
2257 ddp_silv_rec.stream_interface_attribute11 := p5_a45;
2258 ddp_silv_rec.stream_interface_attribute04 := p5_a46;
2259 ddp_silv_rec.stream_interface_attribute13 := p5_a47;
2260 ddp_silv_rec.date_start := rosetta_g_miss_date_in_map(p5_a48);
2261 ddp_silv_rec.date_lending := rosetta_g_miss_date_in_map(p5_a49);
2262 ddp_silv_rec.sif_id := rosetta_g_miss_num_map(p5_a50);
2263 ddp_silv_rec.object_version_number := rosetta_g_miss_num_map(p5_a51);
2264 ddp_silv_rec.kle_id := rosetta_g_miss_num_map(p5_a52);
2265 ddp_silv_rec.sil_type := p5_a53;
2266 ddp_silv_rec.created_by := rosetta_g_miss_num_map(p5_a54);
2267 ddp_silv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a55);
2268 ddp_silv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a56);
2269 ddp_silv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a57);
2270 ddp_silv_rec.last_update_login := rosetta_g_miss_num_map(p5_a58);
2271 ddp_silv_rec.residual_guarantee_type := p5_a59;
2272 ddp_silv_rec.down_payment_amount := rosetta_g_miss_num_map(p5_a60);
2273 ddp_silv_rec.capitalize_down_payment_yn := p5_a61;
2274
2275
2276 -- here's the delegated call to the old PL/SQL routine
2277 okl_sif_lines_pub.validate_sif_lines(p_api_version,
2278 p_init_msg_list,
2279 x_return_status,
2280 x_msg_count,
2281 x_msg_data,
2282 ddp_silv_rec,
2283 ddx_silv_rec);
2284
2285 -- copy data back from the local variables to OUT or IN-OUT args, if any
2286
2287
2288
2289
2290
2291
2292 p6_a0 := rosetta_g_miss_num_map(ddx_silv_rec.id);
2293 p6_a1 := rosetta_g_miss_num_map(ddx_silv_rec.state_depre_dmnshing_value_rt);
2294 p6_a2 := rosetta_g_miss_num_map(ddx_silv_rec.book_depre_dmnshing_value_rt);
2295 p6_a3 := ddx_silv_rec.residual_guarantee_method;
2296 p6_a4 := ddx_silv_rec.residual_date;
2297 p6_a5 := rosetta_g_miss_num_map(ddx_silv_rec.fed_depre_term);
2298 p6_a6 := rosetta_g_miss_num_map(ddx_silv_rec.fed_depre_dmnshing_value_rate);
2299 p6_a7 := ddx_silv_rec.fed_depre_adr_conve;
2300 p6_a8 := rosetta_g_miss_num_map(ddx_silv_rec.state_depre_basis_percent);
2301 p6_a9 := ddx_silv_rec.state_depre_method;
2302 p6_a10 := ddx_silv_rec.purchase_option;
2303 p6_a11 := rosetta_g_miss_num_map(ddx_silv_rec.purchase_option_amount);
2304 p6_a12 := rosetta_g_miss_num_map(ddx_silv_rec.asset_cost);
2305 p6_a13 := rosetta_g_miss_num_map(ddx_silv_rec.state_depre_term);
2306 p6_a14 := ddx_silv_rec.state_depre_adr_convent;
2307 p6_a15 := ddx_silv_rec.fed_depre_method;
2308 p6_a16 := rosetta_g_miss_num_map(ddx_silv_rec.residual_amount);
2309 p6_a17 := rosetta_g_miss_num_map(ddx_silv_rec.fed_depre_salvage);
2310 p6_a18 := ddx_silv_rec.date_fed_depre;
2311 p6_a19 := rosetta_g_miss_num_map(ddx_silv_rec.book_salvage);
2312 p6_a20 := ddx_silv_rec.book_adr_convention;
2313 p6_a21 := rosetta_g_miss_num_map(ddx_silv_rec.state_depre_salvage);
2314 p6_a22 := rosetta_g_miss_num_map(ddx_silv_rec.fed_depre_basis_percent);
2315 p6_a23 := rosetta_g_miss_num_map(ddx_silv_rec.book_basis_percent);
2316 p6_a24 := ddx_silv_rec.date_delivery;
2317 p6_a25 := rosetta_g_miss_num_map(ddx_silv_rec.book_term);
2318 p6_a26 := rosetta_g_miss_num_map(ddx_silv_rec.residual_guarantee_amount);
2319 p6_a27 := ddx_silv_rec.date_funding;
2320 p6_a28 := ddx_silv_rec.date_book;
2321 p6_a29 := ddx_silv_rec.date_state_depre;
2322 p6_a30 := ddx_silv_rec.book_method;
2323 p6_a31 := ddx_silv_rec.stream_interface_attribute08;
2324 p6_a32 := ddx_silv_rec.stream_interface_attribute03;
2325 p6_a33 := ddx_silv_rec.stream_interface_attribute01;
2326 p6_a34 := rosetta_g_miss_num_map(ddx_silv_rec.index_number);
2327 p6_a35 := ddx_silv_rec.stream_interface_attribute05;
2328 p6_a36 := ddx_silv_rec.description;
2329 p6_a37 := ddx_silv_rec.stream_interface_attribute10;
2330 p6_a38 := ddx_silv_rec.stream_interface_attribute06;
2331 p6_a39 := ddx_silv_rec.stream_interface_attribute09;
2332 p6_a40 := ddx_silv_rec.stream_interface_attribute07;
2333 p6_a41 := ddx_silv_rec.stream_interface_attribute14;
2334 p6_a42 := ddx_silv_rec.stream_interface_attribute12;
2335 p6_a43 := ddx_silv_rec.stream_interface_attribute15;
2336 p6_a44 := ddx_silv_rec.stream_interface_attribute02;
2337 p6_a45 := ddx_silv_rec.stream_interface_attribute11;
2338 p6_a46 := ddx_silv_rec.stream_interface_attribute04;
2339 p6_a47 := ddx_silv_rec.stream_interface_attribute13;
2340 p6_a48 := ddx_silv_rec.date_start;
2341 p6_a49 := ddx_silv_rec.date_lending;
2342 p6_a50 := rosetta_g_miss_num_map(ddx_silv_rec.sif_id);
2343 p6_a51 := rosetta_g_miss_num_map(ddx_silv_rec.object_version_number);
2344 p6_a52 := rosetta_g_miss_num_map(ddx_silv_rec.kle_id);
2345 p6_a53 := ddx_silv_rec.sil_type;
2346 p6_a54 := rosetta_g_miss_num_map(ddx_silv_rec.created_by);
2347 p6_a55 := rosetta_g_miss_num_map(ddx_silv_rec.last_updated_by);
2348 p6_a56 := ddx_silv_rec.creation_date;
2349 p6_a57 := ddx_silv_rec.last_update_date;
2350 p6_a58 := rosetta_g_miss_num_map(ddx_silv_rec.last_update_login);
2351 p6_a59 := ddx_silv_rec.residual_guarantee_type;
2352 p6_a60 := rosetta_g_miss_num_map(ddx_silv_rec.down_payment_amount);
2353 p6_a61 := ddx_silv_rec.capitalize_down_payment_yn;
2354 end;
2355
2356 procedure validate_sif_lines(p_api_version NUMBER
2357 , p_init_msg_list VARCHAR2
2358 , x_return_status out nocopy VARCHAR2
2359 , x_msg_count out nocopy NUMBER
2360 , x_msg_data out nocopy VARCHAR2
2361 , p5_a0 JTF_NUMBER_TABLE
2362 , p5_a1 JTF_NUMBER_TABLE
2363 , p5_a2 JTF_NUMBER_TABLE
2364 , p5_a3 JTF_VARCHAR2_TABLE_100
2365 , p5_a4 JTF_DATE_TABLE
2366 , p5_a5 JTF_NUMBER_TABLE
2367 , p5_a6 JTF_NUMBER_TABLE
2368 , p5_a7 JTF_VARCHAR2_TABLE_100
2369 , p5_a8 JTF_NUMBER_TABLE
2370 , p5_a9 JTF_VARCHAR2_TABLE_100
2371 , p5_a10 JTF_VARCHAR2_TABLE_100
2372 , p5_a11 JTF_NUMBER_TABLE
2373 , p5_a12 JTF_NUMBER_TABLE
2374 , p5_a13 JTF_NUMBER_TABLE
2375 , p5_a14 JTF_VARCHAR2_TABLE_100
2376 , p5_a15 JTF_VARCHAR2_TABLE_100
2377 , p5_a16 JTF_NUMBER_TABLE
2378 , p5_a17 JTF_NUMBER_TABLE
2379 , p5_a18 JTF_DATE_TABLE
2380 , p5_a19 JTF_NUMBER_TABLE
2381 , p5_a20 JTF_VARCHAR2_TABLE_100
2382 , p5_a21 JTF_NUMBER_TABLE
2383 , p5_a22 JTF_NUMBER_TABLE
2384 , p5_a23 JTF_NUMBER_TABLE
2385 , p5_a24 JTF_DATE_TABLE
2386 , p5_a25 JTF_NUMBER_TABLE
2387 , p5_a26 JTF_NUMBER_TABLE
2388 , p5_a27 JTF_DATE_TABLE
2389 , p5_a28 JTF_DATE_TABLE
2390 , p5_a29 JTF_DATE_TABLE
2391 , p5_a30 JTF_VARCHAR2_TABLE_100
2392 , p5_a31 JTF_VARCHAR2_TABLE_500
2393 , p5_a32 JTF_VARCHAR2_TABLE_500
2394 , p5_a33 JTF_VARCHAR2_TABLE_500
2395 , p5_a34 JTF_NUMBER_TABLE
2396 , p5_a35 JTF_VARCHAR2_TABLE_500
2397 , p5_a36 JTF_VARCHAR2_TABLE_2000
2398 , p5_a37 JTF_VARCHAR2_TABLE_500
2399 , p5_a38 JTF_VARCHAR2_TABLE_500
2400 , p5_a39 JTF_VARCHAR2_TABLE_500
2401 , p5_a40 JTF_VARCHAR2_TABLE_500
2402 , p5_a41 JTF_VARCHAR2_TABLE_500
2403 , p5_a42 JTF_VARCHAR2_TABLE_500
2404 , p5_a43 JTF_VARCHAR2_TABLE_500
2405 , p5_a44 JTF_VARCHAR2_TABLE_500
2406 , p5_a45 JTF_VARCHAR2_TABLE_500
2407 , p5_a46 JTF_VARCHAR2_TABLE_500
2408 , p5_a47 JTF_VARCHAR2_TABLE_500
2409 , p5_a48 JTF_DATE_TABLE
2410 , p5_a49 JTF_DATE_TABLE
2411 , p5_a50 JTF_NUMBER_TABLE
2412 , p5_a51 JTF_NUMBER_TABLE
2413 , p5_a52 JTF_NUMBER_TABLE
2414 , p5_a53 JTF_VARCHAR2_TABLE_100
2415 , p5_a54 JTF_NUMBER_TABLE
2416 , p5_a55 JTF_NUMBER_TABLE
2417 , p5_a56 JTF_DATE_TABLE
2418 , p5_a57 JTF_DATE_TABLE
2419 , p5_a58 JTF_NUMBER_TABLE
2420 , p5_a59 JTF_VARCHAR2_TABLE_200
2421 , p5_a60 JTF_NUMBER_TABLE
2422 , p5_a61 JTF_VARCHAR2_TABLE_100
2423 , p6_a0 out nocopy JTF_NUMBER_TABLE
2424 , p6_a1 out nocopy JTF_NUMBER_TABLE
2425 , p6_a2 out nocopy JTF_NUMBER_TABLE
2426 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
2427 , p6_a4 out nocopy JTF_DATE_TABLE
2428 , p6_a5 out nocopy JTF_NUMBER_TABLE
2429 , p6_a6 out nocopy JTF_NUMBER_TABLE
2430 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
2431 , p6_a8 out nocopy JTF_NUMBER_TABLE
2432 , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
2433 , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
2434 , p6_a11 out nocopy JTF_NUMBER_TABLE
2435 , p6_a12 out nocopy JTF_NUMBER_TABLE
2436 , p6_a13 out nocopy JTF_NUMBER_TABLE
2437 , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
2438 , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
2439 , p6_a16 out nocopy JTF_NUMBER_TABLE
2440 , p6_a17 out nocopy JTF_NUMBER_TABLE
2441 , p6_a18 out nocopy JTF_DATE_TABLE
2442 , p6_a19 out nocopy JTF_NUMBER_TABLE
2443 , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
2444 , p6_a21 out nocopy JTF_NUMBER_TABLE
2445 , p6_a22 out nocopy JTF_NUMBER_TABLE
2446 , p6_a23 out nocopy JTF_NUMBER_TABLE
2447 , p6_a24 out nocopy JTF_DATE_TABLE
2448 , p6_a25 out nocopy JTF_NUMBER_TABLE
2449 , p6_a26 out nocopy JTF_NUMBER_TABLE
2450 , p6_a27 out nocopy JTF_DATE_TABLE
2451 , p6_a28 out nocopy JTF_DATE_TABLE
2452 , p6_a29 out nocopy JTF_DATE_TABLE
2453 , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
2454 , p6_a31 out nocopy JTF_VARCHAR2_TABLE_500
2455 , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
2456 , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
2457 , p6_a34 out nocopy JTF_NUMBER_TABLE
2458 , p6_a35 out nocopy JTF_VARCHAR2_TABLE_500
2459 , p6_a36 out nocopy JTF_VARCHAR2_TABLE_2000
2460 , p6_a37 out nocopy JTF_VARCHAR2_TABLE_500
2461 , p6_a38 out nocopy JTF_VARCHAR2_TABLE_500
2462 , p6_a39 out nocopy JTF_VARCHAR2_TABLE_500
2463 , p6_a40 out nocopy JTF_VARCHAR2_TABLE_500
2464 , p6_a41 out nocopy JTF_VARCHAR2_TABLE_500
2465 , p6_a42 out nocopy JTF_VARCHAR2_TABLE_500
2466 , p6_a43 out nocopy JTF_VARCHAR2_TABLE_500
2467 , p6_a44 out nocopy JTF_VARCHAR2_TABLE_500
2468 , p6_a45 out nocopy JTF_VARCHAR2_TABLE_500
2469 , p6_a46 out nocopy JTF_VARCHAR2_TABLE_500
2470 , p6_a47 out nocopy JTF_VARCHAR2_TABLE_500
2471 , p6_a48 out nocopy JTF_DATE_TABLE
2472 , p6_a49 out nocopy JTF_DATE_TABLE
2473 , p6_a50 out nocopy JTF_NUMBER_TABLE
2474 , p6_a51 out nocopy JTF_NUMBER_TABLE
2475 , p6_a52 out nocopy JTF_NUMBER_TABLE
2476 , p6_a53 out nocopy JTF_VARCHAR2_TABLE_100
2477 , p6_a54 out nocopy JTF_NUMBER_TABLE
2478 , p6_a55 out nocopy JTF_NUMBER_TABLE
2479 , p6_a56 out nocopy JTF_DATE_TABLE
2480 , p6_a57 out nocopy JTF_DATE_TABLE
2481 , p6_a58 out nocopy JTF_NUMBER_TABLE
2482 , p6_a59 out nocopy JTF_VARCHAR2_TABLE_200
2483 , p6_a60 out nocopy JTF_NUMBER_TABLE
2484 , p6_a61 out nocopy JTF_VARCHAR2_TABLE_100
2485 )
2486
2487 as
2488 ddp_silv_tbl okl_sif_lines_pub.silv_tbl_type;
2489 ddx_silv_tbl okl_sif_lines_pub.silv_tbl_type;
2490 ddindx binary_integer; indx binary_integer;
2491 begin
2492
2493 -- copy data to the local IN or IN-OUT args, if any
2494
2495
2496
2497
2498
2499 okl_sil_pvt_w.rosetta_table_copy_in_p5(ddp_silv_tbl, p5_a0
2500 , p5_a1
2501 , p5_a2
2502 , p5_a3
2503 , p5_a4
2504 , p5_a5
2505 , p5_a6
2506 , p5_a7
2507 , p5_a8
2508 , p5_a9
2509 , p5_a10
2510 , p5_a11
2511 , p5_a12
2512 , p5_a13
2513 , p5_a14
2514 , p5_a15
2515 , p5_a16
2516 , p5_a17
2517 , p5_a18
2518 , p5_a19
2519 , p5_a20
2520 , p5_a21
2521 , p5_a22
2522 , p5_a23
2523 , p5_a24
2524 , p5_a25
2525 , p5_a26
2526 , p5_a27
2527 , p5_a28
2528 , p5_a29
2529 , p5_a30
2530 , p5_a31
2531 , p5_a32
2532 , p5_a33
2533 , p5_a34
2534 , p5_a35
2535 , p5_a36
2536 , p5_a37
2537 , p5_a38
2538 , p5_a39
2539 , p5_a40
2540 , p5_a41
2541 , p5_a42
2542 , p5_a43
2543 , p5_a44
2544 , p5_a45
2545 , p5_a46
2546 , p5_a47
2547 , p5_a48
2548 , p5_a49
2549 , p5_a50
2550 , p5_a51
2551 , p5_a52
2552 , p5_a53
2553 , p5_a54
2554 , p5_a55
2555 , p5_a56
2556 , p5_a57
2557 , p5_a58
2558 , p5_a59
2559 , p5_a60
2560 , p5_a61
2561 );
2562
2563
2564 -- here's the delegated call to the old PL/SQL routine
2565 okl_sif_lines_pub.validate_sif_lines(p_api_version,
2566 p_init_msg_list,
2567 x_return_status,
2568 x_msg_count,
2569 x_msg_data,
2570 ddp_silv_tbl,
2571 ddx_silv_tbl);
2572
2573 -- copy data back from the local variables to OUT or IN-OUT args, if any
2574
2575
2576
2577
2578
2579
2580 okl_sil_pvt_w.rosetta_table_copy_out_p5(ddx_silv_tbl, p6_a0
2581 , p6_a1
2582 , p6_a2
2583 , p6_a3
2584 , p6_a4
2585 , p6_a5
2586 , p6_a6
2587 , p6_a7
2588 , p6_a8
2589 , p6_a9
2590 , p6_a10
2591 , p6_a11
2592 , p6_a12
2593 , p6_a13
2594 , p6_a14
2595 , p6_a15
2596 , p6_a16
2597 , p6_a17
2598 , p6_a18
2599 , p6_a19
2600 , p6_a20
2601 , p6_a21
2602 , p6_a22
2603 , p6_a23
2604 , p6_a24
2605 , p6_a25
2606 , p6_a26
2607 , p6_a27
2608 , p6_a28
2609 , p6_a29
2610 , p6_a30
2611 , p6_a31
2612 , p6_a32
2613 , p6_a33
2614 , p6_a34
2615 , p6_a35
2616 , p6_a36
2617 , p6_a37
2618 , p6_a38
2619 , p6_a39
2620 , p6_a40
2621 , p6_a41
2622 , p6_a42
2623 , p6_a43
2624 , p6_a44
2625 , p6_a45
2626 , p6_a46
2627 , p6_a47
2628 , p6_a48
2629 , p6_a49
2630 , p6_a50
2631 , p6_a51
2632 , p6_a52
2633 , p6_a53
2634 , p6_a54
2635 , p6_a55
2636 , p6_a56
2637 , p6_a57
2638 , p6_a58
2639 , p6_a59
2640 , p6_a60
2641 , p6_a61
2642 );
2643 end;
2644
2645 end okl_sif_lines_pub_w;