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