[Home] [Help]
PACKAGE BODY: APPS.OKL_STREAMS_PUB_W
Source
1 package body okl_streams_pub_w as
2 /* $Header: OKLUSTMB.pls 120.3 2005/09/02 12:41:22 mansrini 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 create_streams(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 JTF_NUMBER_TABLE
28 , p6_a1 JTF_NUMBER_TABLE
29 , p6_a2 JTF_NUMBER_TABLE
30 , p6_a3 JTF_NUMBER_TABLE
31 , p6_a4 JTF_VARCHAR2_TABLE_2000
32 , p6_a5 JTF_VARCHAR2_TABLE_100
33 , p6_a6 JTF_DATE_TABLE
34 , p6_a7 JTF_NUMBER_TABLE
35 , p6_a8 JTF_NUMBER_TABLE
36 , p6_a9 JTF_NUMBER_TABLE
37 , p6_a10 JTF_DATE_TABLE
38 , p6_a11 JTF_NUMBER_TABLE
39 , p6_a12 JTF_DATE_TABLE
40 , p6_a13 JTF_NUMBER_TABLE
41 , p6_a14 JTF_DATE_TABLE
42 , p6_a15 JTF_NUMBER_TABLE
43 , p6_a16 JTF_DATE_TABLE
44 , p6_a17 JTF_NUMBER_TABLE
45 , p6_a18 JTF_NUMBER_TABLE
46 , p6_a19 JTF_NUMBER_TABLE
47 , p6_a20 JTF_NUMBER_TABLE
48 , p6_a21 JTF_VARCHAR2_TABLE_100
49 , p6_a22 JTF_VARCHAR2_TABLE_100
50 , p6_a23 JTF_VARCHAR2_TABLE_100
51 , p6_a24 JTF_DATE_TABLE
52 , p7_a0 out nocopy NUMBER
53 , p7_a1 out nocopy NUMBER
54 , p7_a2 out nocopy NUMBER
55 , p7_a3 out nocopy NUMBER
56 , p7_a4 out nocopy VARCHAR2
57 , p7_a5 out nocopy VARCHAR2
58 , p7_a6 out nocopy NUMBER
59 , p7_a7 out nocopy VARCHAR2
60 , p7_a8 out nocopy NUMBER
61 , p7_a9 out nocopy NUMBER
62 , p7_a10 out nocopy DATE
63 , p7_a11 out nocopy NUMBER
64 , p7_a12 out nocopy DATE
65 , p7_a13 out nocopy DATE
66 , p7_a14 out nocopy DATE
67 , p7_a15 out nocopy DATE
68 , p7_a16 out nocopy VARCHAR2
69 , p7_a17 out nocopy NUMBER
70 , p7_a18 out nocopy NUMBER
71 , p7_a19 out nocopy NUMBER
72 , p7_a20 out nocopy DATE
73 , p7_a21 out nocopy NUMBER
74 , p7_a22 out nocopy VARCHAR2
75 , p7_a23 out nocopy NUMBER
76 , p7_a24 out nocopy NUMBER
77 , p7_a25 out nocopy VARCHAR2
78 , p7_a26 out nocopy NUMBER
79 , p7_a27 out nocopy NUMBER
80 , p8_a0 out nocopy JTF_NUMBER_TABLE
81 , p8_a1 out nocopy JTF_NUMBER_TABLE
82 , p8_a2 out nocopy JTF_NUMBER_TABLE
83 , p8_a3 out nocopy JTF_NUMBER_TABLE
84 , p8_a4 out nocopy JTF_VARCHAR2_TABLE_2000
85 , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
86 , p8_a6 out nocopy JTF_DATE_TABLE
87 , p8_a7 out nocopy JTF_NUMBER_TABLE
88 , p8_a8 out nocopy JTF_NUMBER_TABLE
89 , p8_a9 out nocopy JTF_NUMBER_TABLE
90 , p8_a10 out nocopy JTF_DATE_TABLE
91 , p8_a11 out nocopy JTF_NUMBER_TABLE
92 , p8_a12 out nocopy JTF_DATE_TABLE
93 , p8_a13 out nocopy JTF_NUMBER_TABLE
94 , p8_a14 out nocopy JTF_DATE_TABLE
95 , p8_a15 out nocopy JTF_NUMBER_TABLE
96 , p8_a16 out nocopy JTF_DATE_TABLE
97 , p8_a17 out nocopy JTF_NUMBER_TABLE
98 , p8_a18 out nocopy JTF_NUMBER_TABLE
99 , p8_a19 out nocopy JTF_NUMBER_TABLE
100 , p8_a20 out nocopy JTF_NUMBER_TABLE
101 , p8_a21 out nocopy JTF_VARCHAR2_TABLE_100
102 , p8_a22 out nocopy JTF_VARCHAR2_TABLE_100
103 , p8_a23 out nocopy JTF_VARCHAR2_TABLE_100
104 , p8_a24 out nocopy JTF_DATE_TABLE
105 , p5_a0 NUMBER := 0-1962.0724
106 , p5_a1 NUMBER := 0-1962.0724
107 , p5_a2 NUMBER := 0-1962.0724
108 , p5_a3 NUMBER := 0-1962.0724
109 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
110 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
111 , p5_a6 NUMBER := 0-1962.0724
112 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
113 , p5_a8 NUMBER := 0-1962.0724
114 , p5_a9 NUMBER := 0-1962.0724
115 , p5_a10 DATE := fnd_api.g_miss_date
116 , p5_a11 NUMBER := 0-1962.0724
117 , p5_a12 DATE := fnd_api.g_miss_date
118 , p5_a13 DATE := fnd_api.g_miss_date
119 , p5_a14 DATE := fnd_api.g_miss_date
120 , p5_a15 DATE := fnd_api.g_miss_date
121 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
122 , p5_a17 NUMBER := 0-1962.0724
123 , p5_a18 NUMBER := 0-1962.0724
124 , p5_a19 NUMBER := 0-1962.0724
125 , p5_a20 DATE := fnd_api.g_miss_date
126 , p5_a21 NUMBER := 0-1962.0724
127 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
128 , p5_a23 NUMBER := 0-1962.0724
129 , p5_a24 NUMBER := 0-1962.0724
130 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
131 , p5_a26 NUMBER := 0-1962.0724
132 , p5_a27 NUMBER := 0-1962.0724
133 )
134
135 as
136 ddp_stmv_rec okl_streams_pub.stmv_rec_type;
137 ddp_selv_tbl okl_streams_pub.selv_tbl_type;
138 ddx_stmv_rec okl_streams_pub.stmv_rec_type;
139 ddx_selv_tbl okl_streams_pub.selv_tbl_type;
140 ddindx binary_integer; indx binary_integer;
141 begin
142
143 -- copy data to the local IN or IN-OUT args, if any
144
145
146
147
148
149 ddp_stmv_rec.id := rosetta_g_miss_num_map(p5_a0);
150 ddp_stmv_rec.sty_id := rosetta_g_miss_num_map(p5_a1);
151 ddp_stmv_rec.khr_id := rosetta_g_miss_num_map(p5_a2);
152 ddp_stmv_rec.kle_id := rosetta_g_miss_num_map(p5_a3);
153 ddp_stmv_rec.sgn_code := p5_a4;
154 ddp_stmv_rec.say_code := p5_a5;
155 ddp_stmv_rec.transaction_number := rosetta_g_miss_num_map(p5_a6);
156 ddp_stmv_rec.active_yn := p5_a7;
157 ddp_stmv_rec.object_version_number := rosetta_g_miss_num_map(p5_a8);
158 ddp_stmv_rec.created_by := rosetta_g_miss_num_map(p5_a9);
159 ddp_stmv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a10);
160 ddp_stmv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a11);
161 ddp_stmv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a12);
162 ddp_stmv_rec.date_current := rosetta_g_miss_date_in_map(p5_a13);
163 ddp_stmv_rec.date_working := rosetta_g_miss_date_in_map(p5_a14);
164 ddp_stmv_rec.date_history := rosetta_g_miss_date_in_map(p5_a15);
165 ddp_stmv_rec.comments := p5_a16;
166 ddp_stmv_rec.program_id := rosetta_g_miss_num_map(p5_a17);
167 ddp_stmv_rec.request_id := rosetta_g_miss_num_map(p5_a18);
168 ddp_stmv_rec.program_application_id := rosetta_g_miss_num_map(p5_a19);
169 ddp_stmv_rec.program_update_date := rosetta_g_miss_date_in_map(p5_a20);
170 ddp_stmv_rec.last_update_login := rosetta_g_miss_num_map(p5_a21);
171 ddp_stmv_rec.purpose_code := p5_a22;
172 ddp_stmv_rec.stm_id := rosetta_g_miss_num_map(p5_a23);
173 ddp_stmv_rec.source_id := rosetta_g_miss_num_map(p5_a24);
174 ddp_stmv_rec.source_table := p5_a25;
175 ddp_stmv_rec.trx_id := rosetta_g_miss_num_map(p5_a26);
176 ddp_stmv_rec.link_hist_stream_id := rosetta_g_miss_num_map(p5_a27);
177
178 okl_sel_pvt_w.rosetta_table_copy_in_p5(ddp_selv_tbl, p6_a0
179 , p6_a1
180 , p6_a2
181 , p6_a3
182 , p6_a4
183 , p6_a5
184 , p6_a6
185 , p6_a7
186 , p6_a8
187 , p6_a9
188 , p6_a10
189 , p6_a11
190 , p6_a12
191 , p6_a13
192 , p6_a14
193 , p6_a15
194 , p6_a16
195 , p6_a17
196 , p6_a18
197 , p6_a19
198 , p6_a20
199 , p6_a21
200 , p6_a22
201 , p6_a23
202 , p6_a24
203 );
204
205
206
207 -- here's the delegated call to the old PL/SQL routine
208 okl_streams_pub.create_streams(p_api_version,
209 p_init_msg_list,
210 x_return_status,
211 x_msg_count,
212 x_msg_data,
213 ddp_stmv_rec,
214 ddp_selv_tbl,
215 ddx_stmv_rec,
216 ddx_selv_tbl);
217
218 -- copy data back from the local variables to OUT or IN-OUT args, if any
219
220
221
222
223
224
225
226 p7_a0 := rosetta_g_miss_num_map(ddx_stmv_rec.id);
227 p7_a1 := rosetta_g_miss_num_map(ddx_stmv_rec.sty_id);
228 p7_a2 := rosetta_g_miss_num_map(ddx_stmv_rec.khr_id);
229 p7_a3 := rosetta_g_miss_num_map(ddx_stmv_rec.kle_id);
230 p7_a4 := ddx_stmv_rec.sgn_code;
231 p7_a5 := ddx_stmv_rec.say_code;
232 p7_a6 := rosetta_g_miss_num_map(ddx_stmv_rec.transaction_number);
233 p7_a7 := ddx_stmv_rec.active_yn;
234 p7_a8 := rosetta_g_miss_num_map(ddx_stmv_rec.object_version_number);
235 p7_a9 := rosetta_g_miss_num_map(ddx_stmv_rec.created_by);
236 p7_a10 := ddx_stmv_rec.creation_date;
237 p7_a11 := rosetta_g_miss_num_map(ddx_stmv_rec.last_updated_by);
238 p7_a12 := ddx_stmv_rec.last_update_date;
239 p7_a13 := ddx_stmv_rec.date_current;
240 p7_a14 := ddx_stmv_rec.date_working;
241 p7_a15 := ddx_stmv_rec.date_history;
242 p7_a16 := ddx_stmv_rec.comments;
243 p7_a17 := rosetta_g_miss_num_map(ddx_stmv_rec.program_id);
244 p7_a18 := rosetta_g_miss_num_map(ddx_stmv_rec.request_id);
245 p7_a19 := rosetta_g_miss_num_map(ddx_stmv_rec.program_application_id);
246 p7_a20 := ddx_stmv_rec.program_update_date;
247 p7_a21 := rosetta_g_miss_num_map(ddx_stmv_rec.last_update_login);
248 p7_a22 := ddx_stmv_rec.purpose_code;
249 p7_a23 := rosetta_g_miss_num_map(ddx_stmv_rec.stm_id);
250 p7_a24 := rosetta_g_miss_num_map(ddx_stmv_rec.source_id);
251 p7_a25 := ddx_stmv_rec.source_table;
252 p7_a26 := rosetta_g_miss_num_map(ddx_stmv_rec.trx_id);
253 p7_a27 := rosetta_g_miss_num_map(ddx_stmv_rec.link_hist_stream_id);
254
255 okl_sel_pvt_w.rosetta_table_copy_out_p5(ddx_selv_tbl, p8_a0
256 , p8_a1
257 , p8_a2
258 , p8_a3
259 , p8_a4
260 , p8_a5
261 , p8_a6
262 , p8_a7
263 , p8_a8
264 , p8_a9
265 , p8_a10
266 , p8_a11
267 , p8_a12
268 , p8_a13
269 , p8_a14
270 , p8_a15
271 , p8_a16
272 , p8_a17
273 , p8_a18
274 , p8_a19
275 , p8_a20
276 , p8_a21
277 , p8_a22
278 , p8_a23
279 , p8_a24
280 );
281 end;
282
283 procedure create_streams(p_api_version NUMBER
284 , p_init_msg_list VARCHAR2
285 , x_return_status out nocopy VARCHAR2
286 , x_msg_count out nocopy NUMBER
287 , x_msg_data out nocopy VARCHAR2
288 , p5_a0 JTF_NUMBER_TABLE
289 , p5_a1 JTF_NUMBER_TABLE
290 , p5_a2 JTF_NUMBER_TABLE
291 , p5_a3 JTF_NUMBER_TABLE
292 , p5_a4 JTF_VARCHAR2_TABLE_100
293 , p5_a5 JTF_VARCHAR2_TABLE_100
294 , p5_a6 JTF_NUMBER_TABLE
295 , p5_a7 JTF_VARCHAR2_TABLE_100
296 , p5_a8 JTF_NUMBER_TABLE
297 , p5_a9 JTF_NUMBER_TABLE
298 , p5_a10 JTF_DATE_TABLE
299 , p5_a11 JTF_NUMBER_TABLE
300 , p5_a12 JTF_DATE_TABLE
301 , p5_a13 JTF_DATE_TABLE
302 , p5_a14 JTF_DATE_TABLE
303 , p5_a15 JTF_DATE_TABLE
304 , p5_a16 JTF_VARCHAR2_TABLE_2000
305 , p5_a17 JTF_NUMBER_TABLE
306 , p5_a18 JTF_NUMBER_TABLE
307 , p5_a19 JTF_NUMBER_TABLE
308 , p5_a20 JTF_DATE_TABLE
309 , p5_a21 JTF_NUMBER_TABLE
310 , p5_a22 JTF_VARCHAR2_TABLE_100
311 , p5_a23 JTF_NUMBER_TABLE
312 , p5_a24 JTF_NUMBER_TABLE
313 , p5_a25 JTF_VARCHAR2_TABLE_100
314 , p5_a26 JTF_NUMBER_TABLE
315 , p5_a27 JTF_NUMBER_TABLE
316 , p6_a0 JTF_NUMBER_TABLE
317 , p6_a1 JTF_NUMBER_TABLE
318 , p6_a2 JTF_NUMBER_TABLE
319 , p6_a3 JTF_NUMBER_TABLE
320 , p6_a4 JTF_VARCHAR2_TABLE_2000
321 , p6_a5 JTF_VARCHAR2_TABLE_100
322 , p6_a6 JTF_DATE_TABLE
323 , p6_a7 JTF_NUMBER_TABLE
324 , p6_a8 JTF_NUMBER_TABLE
325 , p6_a9 JTF_NUMBER_TABLE
326 , p6_a10 JTF_DATE_TABLE
327 , p6_a11 JTF_NUMBER_TABLE
328 , p6_a12 JTF_DATE_TABLE
329 , p6_a13 JTF_NUMBER_TABLE
330 , p6_a14 JTF_DATE_TABLE
331 , p6_a15 JTF_NUMBER_TABLE
332 , p6_a16 JTF_DATE_TABLE
333 , p6_a17 JTF_NUMBER_TABLE
334 , p6_a18 JTF_NUMBER_TABLE
335 , p6_a19 JTF_NUMBER_TABLE
336 , p6_a20 JTF_NUMBER_TABLE
337 , p6_a21 JTF_VARCHAR2_TABLE_100
338 , p6_a22 JTF_VARCHAR2_TABLE_100
339 , p6_a23 JTF_VARCHAR2_TABLE_100
340 , p6_a24 JTF_DATE_TABLE
341 , p7_a0 out nocopy JTF_NUMBER_TABLE
342 , p7_a1 out nocopy JTF_NUMBER_TABLE
343 , p7_a2 out nocopy JTF_NUMBER_TABLE
344 , p7_a3 out nocopy JTF_NUMBER_TABLE
345 , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
346 , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
347 , p7_a6 out nocopy JTF_NUMBER_TABLE
348 , p7_a7 out nocopy JTF_VARCHAR2_TABLE_100
349 , p7_a8 out nocopy JTF_NUMBER_TABLE
350 , p7_a9 out nocopy JTF_NUMBER_TABLE
351 , p7_a10 out nocopy JTF_DATE_TABLE
352 , p7_a11 out nocopy JTF_NUMBER_TABLE
353 , p7_a12 out nocopy JTF_DATE_TABLE
354 , p7_a13 out nocopy JTF_DATE_TABLE
355 , p7_a14 out nocopy JTF_DATE_TABLE
356 , p7_a15 out nocopy JTF_DATE_TABLE
357 , p7_a16 out nocopy JTF_VARCHAR2_TABLE_2000
358 , p7_a17 out nocopy JTF_NUMBER_TABLE
359 , p7_a18 out nocopy JTF_NUMBER_TABLE
360 , p7_a19 out nocopy JTF_NUMBER_TABLE
361 , p7_a20 out nocopy JTF_DATE_TABLE
362 , p7_a21 out nocopy JTF_NUMBER_TABLE
363 , p7_a22 out nocopy JTF_VARCHAR2_TABLE_100
364 , p7_a23 out nocopy JTF_NUMBER_TABLE
365 , p7_a24 out nocopy JTF_NUMBER_TABLE
366 , p7_a25 out nocopy JTF_VARCHAR2_TABLE_100
367 , p7_a26 out nocopy JTF_NUMBER_TABLE
368 , p7_a27 out nocopy JTF_NUMBER_TABLE
369 , p8_a0 out nocopy JTF_NUMBER_TABLE
370 , p8_a1 out nocopy JTF_NUMBER_TABLE
371 , p8_a2 out nocopy JTF_NUMBER_TABLE
372 , p8_a3 out nocopy JTF_NUMBER_TABLE
373 , p8_a4 out nocopy JTF_VARCHAR2_TABLE_2000
374 , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
375 , p8_a6 out nocopy JTF_DATE_TABLE
376 , p8_a7 out nocopy JTF_NUMBER_TABLE
377 , p8_a8 out nocopy JTF_NUMBER_TABLE
378 , p8_a9 out nocopy JTF_NUMBER_TABLE
379 , p8_a10 out nocopy JTF_DATE_TABLE
380 , p8_a11 out nocopy JTF_NUMBER_TABLE
381 , p8_a12 out nocopy JTF_DATE_TABLE
382 , p8_a13 out nocopy JTF_NUMBER_TABLE
383 , p8_a14 out nocopy JTF_DATE_TABLE
384 , p8_a15 out nocopy JTF_NUMBER_TABLE
385 , p8_a16 out nocopy JTF_DATE_TABLE
386 , p8_a17 out nocopy JTF_NUMBER_TABLE
387 , p8_a18 out nocopy JTF_NUMBER_TABLE
388 , p8_a19 out nocopy JTF_NUMBER_TABLE
389 , p8_a20 out nocopy JTF_NUMBER_TABLE
390 , p8_a21 out nocopy JTF_VARCHAR2_TABLE_100
391 , p8_a22 out nocopy JTF_VARCHAR2_TABLE_100
392 , p8_a23 out nocopy JTF_VARCHAR2_TABLE_100
393 , p8_a24 out nocopy JTF_DATE_TABLE
394 )
395
396 as
397 ddp_stmv_tbl okl_streams_pub.stmv_tbl_type;
398 ddp_selv_tbl okl_streams_pub.selv_tbl_type;
399 ddx_stmv_tbl okl_streams_pub.stmv_tbl_type;
400 ddx_selv_tbl okl_streams_pub.selv_tbl_type;
401 ddindx binary_integer; indx binary_integer;
402 begin
403
404 -- copy data to the local IN or IN-OUT args, if any
405
406
407
408
409
410 okl_stm_pvt_w.rosetta_table_copy_in_p5(ddp_stmv_tbl, p5_a0
411 , p5_a1
412 , p5_a2
413 , p5_a3
414 , p5_a4
415 , p5_a5
416 , p5_a6
417 , p5_a7
418 , p5_a8
419 , p5_a9
420 , p5_a10
421 , p5_a11
422 , p5_a12
423 , p5_a13
424 , p5_a14
425 , p5_a15
426 , p5_a16
427 , p5_a17
428 , p5_a18
429 , p5_a19
430 , p5_a20
431 , p5_a21
432 , p5_a22
433 , p5_a23
434 , p5_a24
435 , p5_a25
436 , p5_a26
437 , p5_a27
438 );
439
440 okl_sel_pvt_w.rosetta_table_copy_in_p5(ddp_selv_tbl, p6_a0
441 , p6_a1
442 , p6_a2
443 , p6_a3
444 , p6_a4
445 , p6_a5
446 , p6_a6
447 , p6_a7
448 , p6_a8
449 , p6_a9
450 , p6_a10
451 , p6_a11
452 , p6_a12
453 , p6_a13
454 , p6_a14
455 , p6_a15
456 , p6_a16
457 , p6_a17
458 , p6_a18
459 , p6_a19
460 , p6_a20
461 , p6_a21
462 , p6_a22
463 , p6_a23
464 , p6_a24
465 );
466
467
468
469 -- here's the delegated call to the old PL/SQL routine
470 okl_streams_pub.create_streams(p_api_version,
471 p_init_msg_list,
472 x_return_status,
473 x_msg_count,
474 x_msg_data,
475 ddp_stmv_tbl,
476 ddp_selv_tbl,
477 ddx_stmv_tbl,
478 ddx_selv_tbl);
479
480 -- copy data back from the local variables to OUT or IN-OUT args, if any
481
482
483
484
485
486
487
488 okl_stm_pvt_w.rosetta_table_copy_out_p5(ddx_stmv_tbl, p7_a0
489 , p7_a1
490 , p7_a2
491 , p7_a3
492 , p7_a4
493 , p7_a5
494 , p7_a6
495 , p7_a7
496 , p7_a8
497 , p7_a9
498 , p7_a10
499 , p7_a11
500 , p7_a12
501 , p7_a13
502 , p7_a14
503 , p7_a15
504 , p7_a16
505 , p7_a17
506 , p7_a18
507 , p7_a19
508 , p7_a20
509 , p7_a21
510 , p7_a22
511 , p7_a23
512 , p7_a24
513 , p7_a25
514 , p7_a26
515 , p7_a27
516 );
517
518 okl_sel_pvt_w.rosetta_table_copy_out_p5(ddx_selv_tbl, p8_a0
519 , p8_a1
520 , p8_a2
521 , p8_a3
522 , p8_a4
523 , p8_a5
524 , p8_a6
525 , p8_a7
526 , p8_a8
527 , p8_a9
528 , p8_a10
529 , p8_a11
530 , p8_a12
531 , p8_a13
532 , p8_a14
533 , p8_a15
534 , p8_a16
535 , p8_a17
536 , p8_a18
537 , p8_a19
538 , p8_a20
539 , p8_a21
540 , p8_a22
541 , p8_a23
542 , p8_a24
543 );
544 end;
545
546 procedure create_streams_perf(p_api_version NUMBER
547 , p_init_msg_list VARCHAR2
548 , x_return_status out nocopy VARCHAR2
549 , x_msg_count out nocopy NUMBER
550 , x_msg_data out nocopy VARCHAR2
551 , p5_a0 JTF_NUMBER_TABLE
552 , p5_a1 JTF_NUMBER_TABLE
553 , p5_a2 JTF_NUMBER_TABLE
554 , p5_a3 JTF_NUMBER_TABLE
555 , p5_a4 JTF_VARCHAR2_TABLE_100
556 , p5_a5 JTF_VARCHAR2_TABLE_100
557 , p5_a6 JTF_NUMBER_TABLE
558 , p5_a7 JTF_VARCHAR2_TABLE_100
559 , p5_a8 JTF_NUMBER_TABLE
560 , p5_a9 JTF_NUMBER_TABLE
561 , p5_a10 JTF_DATE_TABLE
562 , p5_a11 JTF_NUMBER_TABLE
563 , p5_a12 JTF_DATE_TABLE
564 , p5_a13 JTF_DATE_TABLE
565 , p5_a14 JTF_DATE_TABLE
566 , p5_a15 JTF_DATE_TABLE
567 , p5_a16 JTF_VARCHAR2_TABLE_2000
568 , p5_a17 JTF_NUMBER_TABLE
569 , p5_a18 JTF_NUMBER_TABLE
570 , p5_a19 JTF_NUMBER_TABLE
571 , p5_a20 JTF_DATE_TABLE
572 , p5_a21 JTF_NUMBER_TABLE
573 , p5_a22 JTF_VARCHAR2_TABLE_100
574 , p5_a23 JTF_NUMBER_TABLE
575 , p5_a24 JTF_NUMBER_TABLE
576 , p5_a25 JTF_VARCHAR2_TABLE_100
577 , p5_a26 JTF_NUMBER_TABLE
578 , p5_a27 JTF_NUMBER_TABLE
579 , p6_a0 JTF_NUMBER_TABLE
580 , p6_a1 JTF_NUMBER_TABLE
581 , p6_a2 JTF_NUMBER_TABLE
582 , p6_a3 JTF_NUMBER_TABLE
583 , p6_a4 JTF_VARCHAR2_TABLE_2000
584 , p6_a5 JTF_VARCHAR2_TABLE_100
585 , p6_a6 JTF_DATE_TABLE
586 , p6_a7 JTF_NUMBER_TABLE
587 , p6_a8 JTF_NUMBER_TABLE
588 , p6_a9 JTF_NUMBER_TABLE
589 , p6_a10 JTF_DATE_TABLE
590 , p6_a11 JTF_NUMBER_TABLE
591 , p6_a12 JTF_DATE_TABLE
592 , p6_a13 JTF_NUMBER_TABLE
593 , p6_a14 JTF_DATE_TABLE
594 , p6_a15 JTF_NUMBER_TABLE
595 , p6_a16 JTF_DATE_TABLE
596 , p6_a17 JTF_NUMBER_TABLE
597 , p6_a18 JTF_NUMBER_TABLE
598 , p6_a19 JTF_NUMBER_TABLE
599 , p6_a20 JTF_NUMBER_TABLE
600 , p6_a21 JTF_VARCHAR2_TABLE_100
601 , p6_a22 JTF_VARCHAR2_TABLE_100
602 , p6_a23 JTF_VARCHAR2_TABLE_100
603 , p6_a24 JTF_DATE_TABLE
604 , p7_a0 out nocopy JTF_NUMBER_TABLE
605 , p7_a1 out nocopy JTF_NUMBER_TABLE
606 , p7_a2 out nocopy JTF_NUMBER_TABLE
607 , p7_a3 out nocopy JTF_NUMBER_TABLE
608 , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
609 , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
610 , p7_a6 out nocopy JTF_NUMBER_TABLE
611 , p7_a7 out nocopy JTF_VARCHAR2_TABLE_100
612 , p7_a8 out nocopy JTF_NUMBER_TABLE
613 , p7_a9 out nocopy JTF_NUMBER_TABLE
614 , p7_a10 out nocopy JTF_DATE_TABLE
615 , p7_a11 out nocopy JTF_NUMBER_TABLE
616 , p7_a12 out nocopy JTF_DATE_TABLE
617 , p7_a13 out nocopy JTF_DATE_TABLE
618 , p7_a14 out nocopy JTF_DATE_TABLE
619 , p7_a15 out nocopy JTF_DATE_TABLE
620 , p7_a16 out nocopy JTF_VARCHAR2_TABLE_2000
621 , p7_a17 out nocopy JTF_NUMBER_TABLE
622 , p7_a18 out nocopy JTF_NUMBER_TABLE
623 , p7_a19 out nocopy JTF_NUMBER_TABLE
624 , p7_a20 out nocopy JTF_DATE_TABLE
625 , p7_a21 out nocopy JTF_NUMBER_TABLE
626 , p7_a22 out nocopy JTF_VARCHAR2_TABLE_100
627 , p7_a23 out nocopy JTF_NUMBER_TABLE
628 , p7_a24 out nocopy JTF_NUMBER_TABLE
629 , p7_a25 out nocopy JTF_VARCHAR2_TABLE_100
630 , p7_a26 out nocopy JTF_NUMBER_TABLE
631 , p7_a27 out nocopy JTF_NUMBER_TABLE
632 , p8_a0 out nocopy JTF_NUMBER_TABLE
633 , p8_a1 out nocopy JTF_NUMBER_TABLE
634 , p8_a2 out nocopy JTF_NUMBER_TABLE
635 , p8_a3 out nocopy JTF_NUMBER_TABLE
636 , p8_a4 out nocopy JTF_VARCHAR2_TABLE_2000
637 , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
638 , p8_a6 out nocopy JTF_DATE_TABLE
639 , p8_a7 out nocopy JTF_NUMBER_TABLE
640 , p8_a8 out nocopy JTF_NUMBER_TABLE
641 , p8_a9 out nocopy JTF_NUMBER_TABLE
642 , p8_a10 out nocopy JTF_DATE_TABLE
643 , p8_a11 out nocopy JTF_NUMBER_TABLE
644 , p8_a12 out nocopy JTF_DATE_TABLE
645 , p8_a13 out nocopy JTF_NUMBER_TABLE
646 , p8_a14 out nocopy JTF_DATE_TABLE
647 , p8_a15 out nocopy JTF_NUMBER_TABLE
648 , p8_a16 out nocopy JTF_DATE_TABLE
649 , p8_a17 out nocopy JTF_NUMBER_TABLE
650 , p8_a18 out nocopy JTF_NUMBER_TABLE
651 , p8_a19 out nocopy JTF_NUMBER_TABLE
652 , p8_a20 out nocopy JTF_NUMBER_TABLE
653 , p8_a21 out nocopy JTF_VARCHAR2_TABLE_100
654 , p8_a22 out nocopy JTF_VARCHAR2_TABLE_100
655 , p8_a23 out nocopy JTF_VARCHAR2_TABLE_100
656 , p8_a24 out nocopy JTF_DATE_TABLE
657 )
658
659 as
660 ddp_stmv_tbl okl_streams_pub.stmv_tbl_type;
661 ddp_selv_tbl okl_streams_pub.selv_tbl_type;
662 ddx_stmv_tbl okl_streams_pub.stmv_tbl_type;
663 ddx_selv_tbl okl_streams_pub.selv_tbl_type;
664 ddindx binary_integer; indx binary_integer;
665 begin
666
667 -- copy data to the local IN or IN-OUT args, if any
668
669
670
671
672
673 okl_stm_pvt_w.rosetta_table_copy_in_p5(ddp_stmv_tbl, p5_a0
674 , p5_a1
675 , p5_a2
676 , p5_a3
677 , p5_a4
678 , p5_a5
679 , p5_a6
680 , p5_a7
681 , p5_a8
682 , p5_a9
683 , p5_a10
684 , p5_a11
685 , p5_a12
686 , p5_a13
687 , p5_a14
688 , p5_a15
689 , p5_a16
690 , p5_a17
691 , p5_a18
692 , p5_a19
693 , p5_a20
694 , p5_a21
695 , p5_a22
696 , p5_a23
697 , p5_a24
698 , p5_a25
699 , p5_a26
700 , p5_a27
701 );
702
703 okl_sel_pvt_w.rosetta_table_copy_in_p5(ddp_selv_tbl, p6_a0
704 , p6_a1
705 , p6_a2
706 , p6_a3
707 , p6_a4
708 , p6_a5
709 , p6_a6
710 , p6_a7
711 , p6_a8
712 , p6_a9
713 , p6_a10
714 , p6_a11
715 , p6_a12
716 , p6_a13
717 , p6_a14
718 , p6_a15
719 , p6_a16
720 , p6_a17
721 , p6_a18
722 , p6_a19
723 , p6_a20
724 , p6_a21
725 , p6_a22
726 , p6_a23
727 , p6_a24
728 );
729
730
731
732 -- here's the delegated call to the old PL/SQL routine
733 okl_streams_pub.create_streams_perf(p_api_version,
734 p_init_msg_list,
735 x_return_status,
736 x_msg_count,
737 x_msg_data,
738 ddp_stmv_tbl,
739 ddp_selv_tbl,
740 ddx_stmv_tbl,
741 ddx_selv_tbl);
742
743 -- copy data back from the local variables to OUT or IN-OUT args, if any
744
745
746
747
748
749
750
751 okl_stm_pvt_w.rosetta_table_copy_out_p5(ddx_stmv_tbl, p7_a0
752 , p7_a1
753 , p7_a2
754 , p7_a3
755 , p7_a4
756 , p7_a5
757 , p7_a6
758 , p7_a7
759 , p7_a8
760 , p7_a9
761 , p7_a10
762 , p7_a11
763 , p7_a12
764 , p7_a13
765 , p7_a14
766 , p7_a15
767 , p7_a16
768 , p7_a17
769 , p7_a18
770 , p7_a19
771 , p7_a20
772 , p7_a21
773 , p7_a22
774 , p7_a23
775 , p7_a24
776 , p7_a25
777 , p7_a26
778 , p7_a27
779 );
780
781 okl_sel_pvt_w.rosetta_table_copy_out_p5(ddx_selv_tbl, p8_a0
782 , p8_a1
783 , p8_a2
784 , p8_a3
785 , p8_a4
786 , p8_a5
787 , p8_a6
788 , p8_a7
789 , p8_a8
790 , p8_a9
791 , p8_a10
792 , p8_a11
793 , p8_a12
794 , p8_a13
795 , p8_a14
796 , p8_a15
797 , p8_a16
798 , p8_a17
799 , p8_a18
800 , p8_a19
801 , p8_a20
802 , p8_a21
803 , p8_a22
804 , p8_a23
805 , p8_a24
806 );
807 end;
808
809 procedure update_streams(p_api_version NUMBER
810 , p_init_msg_list VARCHAR2
811 , x_return_status out nocopy VARCHAR2
812 , x_msg_count out nocopy NUMBER
813 , x_msg_data out nocopy VARCHAR2
814 , p6_a0 JTF_NUMBER_TABLE
815 , p6_a1 JTF_NUMBER_TABLE
816 , p6_a2 JTF_NUMBER_TABLE
817 , p6_a3 JTF_NUMBER_TABLE
818 , p6_a4 JTF_VARCHAR2_TABLE_2000
819 , p6_a5 JTF_VARCHAR2_TABLE_100
820 , p6_a6 JTF_DATE_TABLE
821 , p6_a7 JTF_NUMBER_TABLE
822 , p6_a8 JTF_NUMBER_TABLE
823 , p6_a9 JTF_NUMBER_TABLE
824 , p6_a10 JTF_DATE_TABLE
825 , p6_a11 JTF_NUMBER_TABLE
826 , p6_a12 JTF_DATE_TABLE
827 , p6_a13 JTF_NUMBER_TABLE
828 , p6_a14 JTF_DATE_TABLE
829 , p6_a15 JTF_NUMBER_TABLE
830 , p6_a16 JTF_DATE_TABLE
831 , p6_a17 JTF_NUMBER_TABLE
832 , p6_a18 JTF_NUMBER_TABLE
833 , p6_a19 JTF_NUMBER_TABLE
834 , p6_a20 JTF_NUMBER_TABLE
835 , p6_a21 JTF_VARCHAR2_TABLE_100
836 , p6_a22 JTF_VARCHAR2_TABLE_100
837 , p6_a23 JTF_VARCHAR2_TABLE_100
838 , p6_a24 JTF_DATE_TABLE
839 , p7_a0 out nocopy NUMBER
840 , p7_a1 out nocopy NUMBER
841 , p7_a2 out nocopy NUMBER
842 , p7_a3 out nocopy NUMBER
843 , p7_a4 out nocopy VARCHAR2
844 , p7_a5 out nocopy VARCHAR2
845 , p7_a6 out nocopy NUMBER
846 , p7_a7 out nocopy VARCHAR2
847 , p7_a8 out nocopy NUMBER
848 , p7_a9 out nocopy NUMBER
849 , p7_a10 out nocopy DATE
850 , p7_a11 out nocopy NUMBER
851 , p7_a12 out nocopy DATE
852 , p7_a13 out nocopy DATE
853 , p7_a14 out nocopy DATE
854 , p7_a15 out nocopy DATE
855 , p7_a16 out nocopy VARCHAR2
856 , p7_a17 out nocopy NUMBER
857 , p7_a18 out nocopy NUMBER
858 , p7_a19 out nocopy NUMBER
859 , p7_a20 out nocopy DATE
860 , p7_a21 out nocopy NUMBER
861 , p7_a22 out nocopy VARCHAR2
862 , p7_a23 out nocopy NUMBER
863 , p7_a24 out nocopy NUMBER
864 , p7_a25 out nocopy VARCHAR2
865 , p7_a26 out nocopy NUMBER
866 , p7_a27 out nocopy NUMBER
867 , p8_a0 out nocopy JTF_NUMBER_TABLE
868 , p8_a1 out nocopy JTF_NUMBER_TABLE
869 , p8_a2 out nocopy JTF_NUMBER_TABLE
870 , p8_a3 out nocopy JTF_NUMBER_TABLE
871 , p8_a4 out nocopy JTF_VARCHAR2_TABLE_2000
872 , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
873 , p8_a6 out nocopy JTF_DATE_TABLE
874 , p8_a7 out nocopy JTF_NUMBER_TABLE
875 , p8_a8 out nocopy JTF_NUMBER_TABLE
876 , p8_a9 out nocopy JTF_NUMBER_TABLE
877 , p8_a10 out nocopy JTF_DATE_TABLE
878 , p8_a11 out nocopy JTF_NUMBER_TABLE
879 , p8_a12 out nocopy JTF_DATE_TABLE
880 , p8_a13 out nocopy JTF_NUMBER_TABLE
881 , p8_a14 out nocopy JTF_DATE_TABLE
882 , p8_a15 out nocopy JTF_NUMBER_TABLE
883 , p8_a16 out nocopy JTF_DATE_TABLE
884 , p8_a17 out nocopy JTF_NUMBER_TABLE
885 , p8_a18 out nocopy JTF_NUMBER_TABLE
886 , p8_a19 out nocopy JTF_NUMBER_TABLE
887 , p8_a20 out nocopy JTF_NUMBER_TABLE
888 , p8_a21 out nocopy JTF_VARCHAR2_TABLE_100
889 , p8_a22 out nocopy JTF_VARCHAR2_TABLE_100
890 , p8_a23 out nocopy JTF_VARCHAR2_TABLE_100
891 , p8_a24 out nocopy JTF_DATE_TABLE
892 , p5_a0 NUMBER := 0-1962.0724
893 , p5_a1 NUMBER := 0-1962.0724
894 , p5_a2 NUMBER := 0-1962.0724
895 , p5_a3 NUMBER := 0-1962.0724
896 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
897 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
898 , p5_a6 NUMBER := 0-1962.0724
899 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
900 , p5_a8 NUMBER := 0-1962.0724
901 , p5_a9 NUMBER := 0-1962.0724
902 , p5_a10 DATE := fnd_api.g_miss_date
903 , p5_a11 NUMBER := 0-1962.0724
904 , p5_a12 DATE := fnd_api.g_miss_date
905 , p5_a13 DATE := fnd_api.g_miss_date
906 , p5_a14 DATE := fnd_api.g_miss_date
907 , p5_a15 DATE := fnd_api.g_miss_date
908 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
909 , p5_a17 NUMBER := 0-1962.0724
910 , p5_a18 NUMBER := 0-1962.0724
911 , p5_a19 NUMBER := 0-1962.0724
912 , p5_a20 DATE := fnd_api.g_miss_date
913 , p5_a21 NUMBER := 0-1962.0724
914 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
915 , p5_a23 NUMBER := 0-1962.0724
916 , p5_a24 NUMBER := 0-1962.0724
917 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
918 , p5_a26 NUMBER := 0-1962.0724
919 , p5_a27 NUMBER := 0-1962.0724
920 )
921
922 as
923 ddp_stmv_rec okl_streams_pub.stmv_rec_type;
924 ddp_selv_tbl okl_streams_pub.selv_tbl_type;
925 ddx_stmv_rec okl_streams_pub.stmv_rec_type;
926 ddx_selv_tbl okl_streams_pub.selv_tbl_type;
927 ddindx binary_integer; indx binary_integer;
928 begin
929
930 -- copy data to the local IN or IN-OUT args, if any
931
932
933
934
935
936 ddp_stmv_rec.id := rosetta_g_miss_num_map(p5_a0);
937 ddp_stmv_rec.sty_id := rosetta_g_miss_num_map(p5_a1);
938 ddp_stmv_rec.khr_id := rosetta_g_miss_num_map(p5_a2);
939 ddp_stmv_rec.kle_id := rosetta_g_miss_num_map(p5_a3);
940 ddp_stmv_rec.sgn_code := p5_a4;
941 ddp_stmv_rec.say_code := p5_a5;
942 ddp_stmv_rec.transaction_number := rosetta_g_miss_num_map(p5_a6);
943 ddp_stmv_rec.active_yn := p5_a7;
944 ddp_stmv_rec.object_version_number := rosetta_g_miss_num_map(p5_a8);
945 ddp_stmv_rec.created_by := rosetta_g_miss_num_map(p5_a9);
946 ddp_stmv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a10);
947 ddp_stmv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a11);
948 ddp_stmv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a12);
949 ddp_stmv_rec.date_current := rosetta_g_miss_date_in_map(p5_a13);
950 ddp_stmv_rec.date_working := rosetta_g_miss_date_in_map(p5_a14);
951 ddp_stmv_rec.date_history := rosetta_g_miss_date_in_map(p5_a15);
952 ddp_stmv_rec.comments := p5_a16;
953 ddp_stmv_rec.program_id := rosetta_g_miss_num_map(p5_a17);
954 ddp_stmv_rec.request_id := rosetta_g_miss_num_map(p5_a18);
955 ddp_stmv_rec.program_application_id := rosetta_g_miss_num_map(p5_a19);
956 ddp_stmv_rec.program_update_date := rosetta_g_miss_date_in_map(p5_a20);
957 ddp_stmv_rec.last_update_login := rosetta_g_miss_num_map(p5_a21);
958 ddp_stmv_rec.purpose_code := p5_a22;
959 ddp_stmv_rec.stm_id := rosetta_g_miss_num_map(p5_a23);
960 ddp_stmv_rec.source_id := rosetta_g_miss_num_map(p5_a24);
961 ddp_stmv_rec.source_table := p5_a25;
962 ddp_stmv_rec.trx_id := rosetta_g_miss_num_map(p5_a26);
963 ddp_stmv_rec.link_hist_stream_id := rosetta_g_miss_num_map(p5_a27);
964
965 okl_sel_pvt_w.rosetta_table_copy_in_p5(ddp_selv_tbl, p6_a0
966 , p6_a1
967 , p6_a2
968 , p6_a3
969 , p6_a4
970 , p6_a5
971 , p6_a6
972 , p6_a7
973 , p6_a8
974 , p6_a9
975 , p6_a10
976 , p6_a11
977 , p6_a12
978 , p6_a13
979 , p6_a14
980 , p6_a15
981 , p6_a16
982 , p6_a17
983 , p6_a18
984 , p6_a19
985 , p6_a20
986 , p6_a21
987 , p6_a22
988 , p6_a23
989 , p6_a24
990 );
991
992
993
994 -- here's the delegated call to the old PL/SQL routine
995 okl_streams_pub.update_streams(p_api_version,
996 p_init_msg_list,
997 x_return_status,
998 x_msg_count,
999 x_msg_data,
1000 ddp_stmv_rec,
1001 ddp_selv_tbl,
1002 ddx_stmv_rec,
1003 ddx_selv_tbl);
1004
1005 -- copy data back from the local variables to OUT or IN-OUT args, if any
1006
1007
1008
1009
1010
1011
1012
1013 p7_a0 := rosetta_g_miss_num_map(ddx_stmv_rec.id);
1014 p7_a1 := rosetta_g_miss_num_map(ddx_stmv_rec.sty_id);
1015 p7_a2 := rosetta_g_miss_num_map(ddx_stmv_rec.khr_id);
1016 p7_a3 := rosetta_g_miss_num_map(ddx_stmv_rec.kle_id);
1017 p7_a4 := ddx_stmv_rec.sgn_code;
1018 p7_a5 := ddx_stmv_rec.say_code;
1019 p7_a6 := rosetta_g_miss_num_map(ddx_stmv_rec.transaction_number);
1020 p7_a7 := ddx_stmv_rec.active_yn;
1021 p7_a8 := rosetta_g_miss_num_map(ddx_stmv_rec.object_version_number);
1022 p7_a9 := rosetta_g_miss_num_map(ddx_stmv_rec.created_by);
1023 p7_a10 := ddx_stmv_rec.creation_date;
1024 p7_a11 := rosetta_g_miss_num_map(ddx_stmv_rec.last_updated_by);
1025 p7_a12 := ddx_stmv_rec.last_update_date;
1026 p7_a13 := ddx_stmv_rec.date_current;
1027 p7_a14 := ddx_stmv_rec.date_working;
1028 p7_a15 := ddx_stmv_rec.date_history;
1029 p7_a16 := ddx_stmv_rec.comments;
1030 p7_a17 := rosetta_g_miss_num_map(ddx_stmv_rec.program_id);
1031 p7_a18 := rosetta_g_miss_num_map(ddx_stmv_rec.request_id);
1032 p7_a19 := rosetta_g_miss_num_map(ddx_stmv_rec.program_application_id);
1033 p7_a20 := ddx_stmv_rec.program_update_date;
1034 p7_a21 := rosetta_g_miss_num_map(ddx_stmv_rec.last_update_login);
1035 p7_a22 := ddx_stmv_rec.purpose_code;
1036 p7_a23 := rosetta_g_miss_num_map(ddx_stmv_rec.stm_id);
1037 p7_a24 := rosetta_g_miss_num_map(ddx_stmv_rec.source_id);
1038 p7_a25 := ddx_stmv_rec.source_table;
1039 p7_a26 := rosetta_g_miss_num_map(ddx_stmv_rec.trx_id);
1040 p7_a27 := rosetta_g_miss_num_map(ddx_stmv_rec.link_hist_stream_id);
1041
1042 okl_sel_pvt_w.rosetta_table_copy_out_p5(ddx_selv_tbl, p8_a0
1043 , p8_a1
1044 , p8_a2
1045 , p8_a3
1046 , p8_a4
1047 , p8_a5
1048 , p8_a6
1049 , p8_a7
1050 , p8_a8
1051 , p8_a9
1052 , p8_a10
1053 , p8_a11
1054 , p8_a12
1055 , p8_a13
1056 , p8_a14
1057 , p8_a15
1058 , p8_a16
1059 , p8_a17
1060 , p8_a18
1061 , p8_a19
1062 , p8_a20
1063 , p8_a21
1064 , p8_a22
1065 , p8_a23
1066 , p8_a24
1067 );
1068 end;
1069
1070 procedure validate_streams(p_api_version NUMBER
1071 , p_init_msg_list VARCHAR2
1072 , x_return_status out nocopy VARCHAR2
1073 , x_msg_count out nocopy NUMBER
1074 , x_msg_data out nocopy VARCHAR2
1075 , p6_a0 JTF_NUMBER_TABLE
1076 , p6_a1 JTF_NUMBER_TABLE
1077 , p6_a2 JTF_NUMBER_TABLE
1078 , p6_a3 JTF_NUMBER_TABLE
1079 , p6_a4 JTF_VARCHAR2_TABLE_2000
1080 , p6_a5 JTF_VARCHAR2_TABLE_100
1081 , p6_a6 JTF_DATE_TABLE
1082 , p6_a7 JTF_NUMBER_TABLE
1083 , p6_a8 JTF_NUMBER_TABLE
1084 , p6_a9 JTF_NUMBER_TABLE
1085 , p6_a10 JTF_DATE_TABLE
1086 , p6_a11 JTF_NUMBER_TABLE
1087 , p6_a12 JTF_DATE_TABLE
1088 , p6_a13 JTF_NUMBER_TABLE
1089 , p6_a14 JTF_DATE_TABLE
1090 , p6_a15 JTF_NUMBER_TABLE
1091 , p6_a16 JTF_DATE_TABLE
1092 , p6_a17 JTF_NUMBER_TABLE
1093 , p6_a18 JTF_NUMBER_TABLE
1094 , p6_a19 JTF_NUMBER_TABLE
1095 , p6_a20 JTF_NUMBER_TABLE
1096 , p6_a21 JTF_VARCHAR2_TABLE_100
1097 , p6_a22 JTF_VARCHAR2_TABLE_100
1098 , p6_a23 JTF_VARCHAR2_TABLE_100
1099 , p6_a24 JTF_DATE_TABLE
1100 , p5_a0 NUMBER := 0-1962.0724
1101 , p5_a1 NUMBER := 0-1962.0724
1102 , p5_a2 NUMBER := 0-1962.0724
1103 , p5_a3 NUMBER := 0-1962.0724
1104 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1105 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1106 , p5_a6 NUMBER := 0-1962.0724
1107 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1108 , p5_a8 NUMBER := 0-1962.0724
1109 , p5_a9 NUMBER := 0-1962.0724
1110 , p5_a10 DATE := fnd_api.g_miss_date
1111 , p5_a11 NUMBER := 0-1962.0724
1112 , p5_a12 DATE := fnd_api.g_miss_date
1113 , p5_a13 DATE := fnd_api.g_miss_date
1114 , p5_a14 DATE := fnd_api.g_miss_date
1115 , p5_a15 DATE := fnd_api.g_miss_date
1116 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1117 , p5_a17 NUMBER := 0-1962.0724
1118 , p5_a18 NUMBER := 0-1962.0724
1119 , p5_a19 NUMBER := 0-1962.0724
1120 , p5_a20 DATE := fnd_api.g_miss_date
1121 , p5_a21 NUMBER := 0-1962.0724
1122 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1123 , p5_a23 NUMBER := 0-1962.0724
1124 , p5_a24 NUMBER := 0-1962.0724
1125 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1126 , p5_a26 NUMBER := 0-1962.0724
1127 , p5_a27 NUMBER := 0-1962.0724
1128 )
1129
1130 as
1131 ddp_stmv_rec okl_streams_pub.stmv_rec_type;
1132 ddp_selv_tbl okl_streams_pub.selv_tbl_type;
1133 ddindx binary_integer; indx binary_integer;
1134 begin
1135
1136 -- copy data to the local IN or IN-OUT args, if any
1137
1138
1139
1140
1141
1142 ddp_stmv_rec.id := rosetta_g_miss_num_map(p5_a0);
1143 ddp_stmv_rec.sty_id := rosetta_g_miss_num_map(p5_a1);
1144 ddp_stmv_rec.khr_id := rosetta_g_miss_num_map(p5_a2);
1145 ddp_stmv_rec.kle_id := rosetta_g_miss_num_map(p5_a3);
1146 ddp_stmv_rec.sgn_code := p5_a4;
1147 ddp_stmv_rec.say_code := p5_a5;
1148 ddp_stmv_rec.transaction_number := rosetta_g_miss_num_map(p5_a6);
1149 ddp_stmv_rec.active_yn := p5_a7;
1150 ddp_stmv_rec.object_version_number := rosetta_g_miss_num_map(p5_a8);
1151 ddp_stmv_rec.created_by := rosetta_g_miss_num_map(p5_a9);
1152 ddp_stmv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a10);
1153 ddp_stmv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a11);
1154 ddp_stmv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a12);
1155 ddp_stmv_rec.date_current := rosetta_g_miss_date_in_map(p5_a13);
1156 ddp_stmv_rec.date_working := rosetta_g_miss_date_in_map(p5_a14);
1157 ddp_stmv_rec.date_history := rosetta_g_miss_date_in_map(p5_a15);
1158 ddp_stmv_rec.comments := p5_a16;
1159 ddp_stmv_rec.program_id := rosetta_g_miss_num_map(p5_a17);
1160 ddp_stmv_rec.request_id := rosetta_g_miss_num_map(p5_a18);
1161 ddp_stmv_rec.program_application_id := rosetta_g_miss_num_map(p5_a19);
1162 ddp_stmv_rec.program_update_date := rosetta_g_miss_date_in_map(p5_a20);
1163 ddp_stmv_rec.last_update_login := rosetta_g_miss_num_map(p5_a21);
1164 ddp_stmv_rec.purpose_code := p5_a22;
1165 ddp_stmv_rec.stm_id := rosetta_g_miss_num_map(p5_a23);
1166 ddp_stmv_rec.source_id := rosetta_g_miss_num_map(p5_a24);
1167 ddp_stmv_rec.source_table := p5_a25;
1168 ddp_stmv_rec.trx_id := rosetta_g_miss_num_map(p5_a26);
1169 ddp_stmv_rec.link_hist_stream_id := rosetta_g_miss_num_map(p5_a27);
1170
1171 okl_sel_pvt_w.rosetta_table_copy_in_p5(ddp_selv_tbl, p6_a0
1172 , p6_a1
1173 , p6_a2
1174 , p6_a3
1175 , p6_a4
1176 , p6_a5
1177 , p6_a6
1178 , p6_a7
1179 , p6_a8
1180 , p6_a9
1181 , p6_a10
1182 , p6_a11
1183 , p6_a12
1184 , p6_a13
1185 , p6_a14
1186 , p6_a15
1187 , p6_a16
1188 , p6_a17
1189 , p6_a18
1190 , p6_a19
1191 , p6_a20
1192 , p6_a21
1193 , p6_a22
1194 , p6_a23
1195 , p6_a24
1196 );
1197
1198 -- here's the delegated call to the old PL/SQL routine
1199 okl_streams_pub.validate_streams(p_api_version,
1200 p_init_msg_list,
1201 x_return_status,
1202 x_msg_count,
1203 x_msg_data,
1204 ddp_stmv_rec,
1205 ddp_selv_tbl);
1206
1207 -- copy data back from the local variables to OUT or IN-OUT args, if any
1208
1209
1210
1211
1212
1213
1214 end;
1215
1216 procedure create_streams(p_api_version NUMBER
1217 , p_init_msg_list VARCHAR2
1218 , x_return_status out nocopy VARCHAR2
1219 , x_msg_count out nocopy NUMBER
1220 , x_msg_data out nocopy VARCHAR2
1221 , p5_a0 JTF_NUMBER_TABLE
1222 , p5_a1 JTF_NUMBER_TABLE
1223 , p5_a2 JTF_NUMBER_TABLE
1224 , p5_a3 JTF_NUMBER_TABLE
1225 , p5_a4 JTF_VARCHAR2_TABLE_100
1226 , p5_a5 JTF_VARCHAR2_TABLE_100
1227 , p5_a6 JTF_NUMBER_TABLE
1228 , p5_a7 JTF_VARCHAR2_TABLE_100
1229 , p5_a8 JTF_NUMBER_TABLE
1230 , p5_a9 JTF_NUMBER_TABLE
1231 , p5_a10 JTF_DATE_TABLE
1232 , p5_a11 JTF_NUMBER_TABLE
1233 , p5_a12 JTF_DATE_TABLE
1234 , p5_a13 JTF_DATE_TABLE
1235 , p5_a14 JTF_DATE_TABLE
1236 , p5_a15 JTF_DATE_TABLE
1237 , p5_a16 JTF_VARCHAR2_TABLE_2000
1238 , p5_a17 JTF_NUMBER_TABLE
1239 , p5_a18 JTF_NUMBER_TABLE
1240 , p5_a19 JTF_NUMBER_TABLE
1241 , p5_a20 JTF_DATE_TABLE
1242 , p5_a21 JTF_NUMBER_TABLE
1243 , p5_a22 JTF_VARCHAR2_TABLE_100
1244 , p5_a23 JTF_NUMBER_TABLE
1245 , p5_a24 JTF_NUMBER_TABLE
1246 , p5_a25 JTF_VARCHAR2_TABLE_100
1247 , p5_a26 JTF_NUMBER_TABLE
1248 , p5_a27 JTF_NUMBER_TABLE
1249 , p6_a0 out nocopy JTF_NUMBER_TABLE
1250 , p6_a1 out nocopy JTF_NUMBER_TABLE
1251 , p6_a2 out nocopy JTF_NUMBER_TABLE
1252 , p6_a3 out nocopy JTF_NUMBER_TABLE
1253 , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1254 , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
1255 , p6_a6 out nocopy JTF_NUMBER_TABLE
1256 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
1257 , p6_a8 out nocopy JTF_NUMBER_TABLE
1258 , p6_a9 out nocopy JTF_NUMBER_TABLE
1259 , p6_a10 out nocopy JTF_DATE_TABLE
1260 , p6_a11 out nocopy JTF_NUMBER_TABLE
1261 , p6_a12 out nocopy JTF_DATE_TABLE
1262 , p6_a13 out nocopy JTF_DATE_TABLE
1263 , p6_a14 out nocopy JTF_DATE_TABLE
1264 , p6_a15 out nocopy JTF_DATE_TABLE
1265 , p6_a16 out nocopy JTF_VARCHAR2_TABLE_2000
1266 , p6_a17 out nocopy JTF_NUMBER_TABLE
1267 , p6_a18 out nocopy JTF_NUMBER_TABLE
1268 , p6_a19 out nocopy JTF_NUMBER_TABLE
1269 , p6_a20 out nocopy JTF_DATE_TABLE
1270 , p6_a21 out nocopy JTF_NUMBER_TABLE
1271 , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
1272 , p6_a23 out nocopy JTF_NUMBER_TABLE
1273 , p6_a24 out nocopy JTF_NUMBER_TABLE
1274 , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
1275 , p6_a26 out nocopy JTF_NUMBER_TABLE
1276 , p6_a27 out nocopy JTF_NUMBER_TABLE
1277 )
1278
1279 as
1280 ddp_stmv_tbl okl_streams_pub.stmv_tbl_type;
1281 ddx_stmv_tbl okl_streams_pub.stmv_tbl_type;
1282 ddindx binary_integer; indx binary_integer;
1283 begin
1284
1285 -- copy data to the local IN or IN-OUT args, if any
1286
1287
1288
1289
1290
1291 okl_stm_pvt_w.rosetta_table_copy_in_p5(ddp_stmv_tbl, p5_a0
1292 , p5_a1
1293 , p5_a2
1294 , p5_a3
1295 , p5_a4
1296 , p5_a5
1297 , p5_a6
1298 , p5_a7
1299 , p5_a8
1300 , p5_a9
1301 , p5_a10
1302 , p5_a11
1303 , p5_a12
1304 , p5_a13
1305 , p5_a14
1306 , p5_a15
1307 , p5_a16
1308 , p5_a17
1309 , p5_a18
1310 , p5_a19
1311 , p5_a20
1312 , p5_a21
1313 , p5_a22
1314 , p5_a23
1315 , p5_a24
1316 , p5_a25
1317 , p5_a26
1318 , p5_a27
1319 );
1320
1321
1322 -- here's the delegated call to the old PL/SQL routine
1323 okl_streams_pub.create_streams(p_api_version,
1324 p_init_msg_list,
1325 x_return_status,
1326 x_msg_count,
1327 x_msg_data,
1328 ddp_stmv_tbl,
1329 ddx_stmv_tbl);
1330
1331 -- copy data back from the local variables to OUT or IN-OUT args, if any
1332
1333
1334
1335
1336
1337
1338 okl_stm_pvt_w.rosetta_table_copy_out_p5(ddx_stmv_tbl, p6_a0
1339 , p6_a1
1340 , p6_a2
1341 , p6_a3
1342 , p6_a4
1343 , p6_a5
1344 , p6_a6
1345 , p6_a7
1346 , p6_a8
1347 , p6_a9
1348 , p6_a10
1349 , p6_a11
1350 , p6_a12
1351 , p6_a13
1352 , p6_a14
1353 , p6_a15
1354 , p6_a16
1355 , p6_a17
1356 , p6_a18
1357 , p6_a19
1358 , p6_a20
1359 , p6_a21
1360 , p6_a22
1361 , p6_a23
1362 , p6_a24
1363 , p6_a25
1364 , p6_a26
1365 , p6_a27
1366 );
1367 end;
1368
1369 procedure create_streams(p_api_version NUMBER
1370 , p_init_msg_list VARCHAR2
1371 , x_return_status out nocopy VARCHAR2
1372 , x_msg_count out nocopy NUMBER
1373 , x_msg_data out nocopy VARCHAR2
1374 , p6_a0 out nocopy NUMBER
1375 , p6_a1 out nocopy NUMBER
1376 , p6_a2 out nocopy NUMBER
1377 , p6_a3 out nocopy NUMBER
1378 , p6_a4 out nocopy VARCHAR2
1379 , p6_a5 out nocopy VARCHAR2
1380 , p6_a6 out nocopy NUMBER
1381 , p6_a7 out nocopy VARCHAR2
1382 , p6_a8 out nocopy NUMBER
1383 , p6_a9 out nocopy NUMBER
1384 , p6_a10 out nocopy DATE
1385 , p6_a11 out nocopy NUMBER
1386 , p6_a12 out nocopy DATE
1387 , p6_a13 out nocopy DATE
1388 , p6_a14 out nocopy DATE
1389 , p6_a15 out nocopy DATE
1390 , p6_a16 out nocopy VARCHAR2
1391 , p6_a17 out nocopy NUMBER
1392 , p6_a18 out nocopy NUMBER
1393 , p6_a19 out nocopy NUMBER
1394 , p6_a20 out nocopy DATE
1395 , p6_a21 out nocopy NUMBER
1396 , p6_a22 out nocopy VARCHAR2
1397 , p6_a23 out nocopy NUMBER
1398 , p6_a24 out nocopy NUMBER
1399 , p6_a25 out nocopy VARCHAR2
1400 , p6_a26 out nocopy NUMBER
1401 , p6_a27 out nocopy NUMBER
1402 , p5_a0 NUMBER := 0-1962.0724
1403 , p5_a1 NUMBER := 0-1962.0724
1404 , p5_a2 NUMBER := 0-1962.0724
1405 , p5_a3 NUMBER := 0-1962.0724
1406 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1407 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1408 , p5_a6 NUMBER := 0-1962.0724
1409 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1410 , p5_a8 NUMBER := 0-1962.0724
1411 , p5_a9 NUMBER := 0-1962.0724
1412 , p5_a10 DATE := fnd_api.g_miss_date
1413 , p5_a11 NUMBER := 0-1962.0724
1414 , p5_a12 DATE := fnd_api.g_miss_date
1415 , p5_a13 DATE := fnd_api.g_miss_date
1416 , p5_a14 DATE := fnd_api.g_miss_date
1417 , p5_a15 DATE := fnd_api.g_miss_date
1418 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1419 , p5_a17 NUMBER := 0-1962.0724
1420 , p5_a18 NUMBER := 0-1962.0724
1421 , p5_a19 NUMBER := 0-1962.0724
1422 , p5_a20 DATE := fnd_api.g_miss_date
1423 , p5_a21 NUMBER := 0-1962.0724
1424 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1425 , p5_a23 NUMBER := 0-1962.0724
1426 , p5_a24 NUMBER := 0-1962.0724
1427 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1428 , p5_a26 NUMBER := 0-1962.0724
1429 , p5_a27 NUMBER := 0-1962.0724
1430 )
1431
1432 as
1433 ddp_stmv_rec okl_streams_pub.stmv_rec_type;
1434 ddx_stmv_rec okl_streams_pub.stmv_rec_type;
1435 ddindx binary_integer; indx binary_integer;
1436 begin
1437
1438 -- copy data to the local IN or IN-OUT args, if any
1439
1440
1441
1442
1443
1444 ddp_stmv_rec.id := rosetta_g_miss_num_map(p5_a0);
1445 ddp_stmv_rec.sty_id := rosetta_g_miss_num_map(p5_a1);
1446 ddp_stmv_rec.khr_id := rosetta_g_miss_num_map(p5_a2);
1447 ddp_stmv_rec.kle_id := rosetta_g_miss_num_map(p5_a3);
1448 ddp_stmv_rec.sgn_code := p5_a4;
1449 ddp_stmv_rec.say_code := p5_a5;
1450 ddp_stmv_rec.transaction_number := rosetta_g_miss_num_map(p5_a6);
1451 ddp_stmv_rec.active_yn := p5_a7;
1452 ddp_stmv_rec.object_version_number := rosetta_g_miss_num_map(p5_a8);
1453 ddp_stmv_rec.created_by := rosetta_g_miss_num_map(p5_a9);
1454 ddp_stmv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a10);
1455 ddp_stmv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a11);
1456 ddp_stmv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a12);
1457 ddp_stmv_rec.date_current := rosetta_g_miss_date_in_map(p5_a13);
1458 ddp_stmv_rec.date_working := rosetta_g_miss_date_in_map(p5_a14);
1459 ddp_stmv_rec.date_history := rosetta_g_miss_date_in_map(p5_a15);
1460 ddp_stmv_rec.comments := p5_a16;
1461 ddp_stmv_rec.program_id := rosetta_g_miss_num_map(p5_a17);
1462 ddp_stmv_rec.request_id := rosetta_g_miss_num_map(p5_a18);
1463 ddp_stmv_rec.program_application_id := rosetta_g_miss_num_map(p5_a19);
1464 ddp_stmv_rec.program_update_date := rosetta_g_miss_date_in_map(p5_a20);
1465 ddp_stmv_rec.last_update_login := rosetta_g_miss_num_map(p5_a21);
1466 ddp_stmv_rec.purpose_code := p5_a22;
1467 ddp_stmv_rec.stm_id := rosetta_g_miss_num_map(p5_a23);
1468 ddp_stmv_rec.source_id := rosetta_g_miss_num_map(p5_a24);
1469 ddp_stmv_rec.source_table := p5_a25;
1470 ddp_stmv_rec.trx_id := rosetta_g_miss_num_map(p5_a26);
1471 ddp_stmv_rec.link_hist_stream_id := rosetta_g_miss_num_map(p5_a27);
1472
1473
1474 -- here's the delegated call to the old PL/SQL routine
1475 okl_streams_pub.create_streams(p_api_version,
1476 p_init_msg_list,
1477 x_return_status,
1478 x_msg_count,
1479 x_msg_data,
1480 ddp_stmv_rec,
1481 ddx_stmv_rec);
1482
1483 -- copy data back from the local variables to OUT or IN-OUT args, if any
1484
1485
1486
1487
1488
1489
1490 p6_a0 := rosetta_g_miss_num_map(ddx_stmv_rec.id);
1491 p6_a1 := rosetta_g_miss_num_map(ddx_stmv_rec.sty_id);
1492 p6_a2 := rosetta_g_miss_num_map(ddx_stmv_rec.khr_id);
1493 p6_a3 := rosetta_g_miss_num_map(ddx_stmv_rec.kle_id);
1494 p6_a4 := ddx_stmv_rec.sgn_code;
1495 p6_a5 := ddx_stmv_rec.say_code;
1496 p6_a6 := rosetta_g_miss_num_map(ddx_stmv_rec.transaction_number);
1497 p6_a7 := ddx_stmv_rec.active_yn;
1498 p6_a8 := rosetta_g_miss_num_map(ddx_stmv_rec.object_version_number);
1499 p6_a9 := rosetta_g_miss_num_map(ddx_stmv_rec.created_by);
1500 p6_a10 := ddx_stmv_rec.creation_date;
1501 p6_a11 := rosetta_g_miss_num_map(ddx_stmv_rec.last_updated_by);
1502 p6_a12 := ddx_stmv_rec.last_update_date;
1503 p6_a13 := ddx_stmv_rec.date_current;
1504 p6_a14 := ddx_stmv_rec.date_working;
1505 p6_a15 := ddx_stmv_rec.date_history;
1506 p6_a16 := ddx_stmv_rec.comments;
1507 p6_a17 := rosetta_g_miss_num_map(ddx_stmv_rec.program_id);
1508 p6_a18 := rosetta_g_miss_num_map(ddx_stmv_rec.request_id);
1509 p6_a19 := rosetta_g_miss_num_map(ddx_stmv_rec.program_application_id);
1510 p6_a20 := ddx_stmv_rec.program_update_date;
1511 p6_a21 := rosetta_g_miss_num_map(ddx_stmv_rec.last_update_login);
1512 p6_a22 := ddx_stmv_rec.purpose_code;
1513 p6_a23 := rosetta_g_miss_num_map(ddx_stmv_rec.stm_id);
1514 p6_a24 := rosetta_g_miss_num_map(ddx_stmv_rec.source_id);
1515 p6_a25 := ddx_stmv_rec.source_table;
1516 p6_a26 := rosetta_g_miss_num_map(ddx_stmv_rec.trx_id);
1517 p6_a27 := rosetta_g_miss_num_map(ddx_stmv_rec.link_hist_stream_id);
1518 end;
1519
1520 procedure lock_streams(p_api_version NUMBER
1521 , p_init_msg_list VARCHAR2
1522 , x_return_status out nocopy VARCHAR2
1523 , x_msg_count out nocopy NUMBER
1524 , x_msg_data out nocopy VARCHAR2
1525 , p5_a0 JTF_NUMBER_TABLE
1526 , p5_a1 JTF_NUMBER_TABLE
1527 , p5_a2 JTF_NUMBER_TABLE
1528 , p5_a3 JTF_NUMBER_TABLE
1529 , p5_a4 JTF_VARCHAR2_TABLE_100
1530 , p5_a5 JTF_VARCHAR2_TABLE_100
1531 , p5_a6 JTF_NUMBER_TABLE
1532 , p5_a7 JTF_VARCHAR2_TABLE_100
1533 , p5_a8 JTF_NUMBER_TABLE
1534 , p5_a9 JTF_NUMBER_TABLE
1535 , p5_a10 JTF_DATE_TABLE
1536 , p5_a11 JTF_NUMBER_TABLE
1537 , p5_a12 JTF_DATE_TABLE
1538 , p5_a13 JTF_DATE_TABLE
1539 , p5_a14 JTF_DATE_TABLE
1540 , p5_a15 JTF_DATE_TABLE
1541 , p5_a16 JTF_VARCHAR2_TABLE_2000
1542 , p5_a17 JTF_NUMBER_TABLE
1543 , p5_a18 JTF_NUMBER_TABLE
1544 , p5_a19 JTF_NUMBER_TABLE
1545 , p5_a20 JTF_DATE_TABLE
1546 , p5_a21 JTF_NUMBER_TABLE
1547 , p5_a22 JTF_VARCHAR2_TABLE_100
1548 , p5_a23 JTF_NUMBER_TABLE
1549 , p5_a24 JTF_NUMBER_TABLE
1550 , p5_a25 JTF_VARCHAR2_TABLE_100
1551 , p5_a26 JTF_NUMBER_TABLE
1552 , p5_a27 JTF_NUMBER_TABLE
1553 )
1554
1555 as
1556 ddp_stmv_tbl okl_streams_pub.stmv_tbl_type;
1557 ddindx binary_integer; indx binary_integer;
1558 begin
1559
1560 -- copy data to the local IN or IN-OUT args, if any
1561
1562
1563
1564
1565
1566 okl_stm_pvt_w.rosetta_table_copy_in_p5(ddp_stmv_tbl, p5_a0
1567 , p5_a1
1568 , p5_a2
1569 , p5_a3
1570 , p5_a4
1571 , p5_a5
1572 , p5_a6
1573 , p5_a7
1574 , p5_a8
1575 , p5_a9
1576 , p5_a10
1577 , p5_a11
1578 , p5_a12
1579 , p5_a13
1580 , p5_a14
1581 , p5_a15
1582 , p5_a16
1583 , p5_a17
1584 , p5_a18
1585 , p5_a19
1586 , p5_a20
1587 , p5_a21
1588 , p5_a22
1589 , p5_a23
1590 , p5_a24
1591 , p5_a25
1592 , p5_a26
1593 , p5_a27
1594 );
1595
1596 -- here's the delegated call to the old PL/SQL routine
1597 okl_streams_pub.lock_streams(p_api_version,
1598 p_init_msg_list,
1599 x_return_status,
1600 x_msg_count,
1601 x_msg_data,
1602 ddp_stmv_tbl);
1603
1604 -- copy data back from the local variables to OUT or IN-OUT args, if any
1605
1606
1607
1608
1609
1610 end;
1611
1612 procedure lock_streams(p_api_version NUMBER
1613 , p_init_msg_list VARCHAR2
1614 , x_return_status out nocopy VARCHAR2
1615 , x_msg_count out nocopy NUMBER
1616 , x_msg_data out nocopy VARCHAR2
1617 , p5_a0 NUMBER := 0-1962.0724
1618 , p5_a1 NUMBER := 0-1962.0724
1619 , p5_a2 NUMBER := 0-1962.0724
1620 , p5_a3 NUMBER := 0-1962.0724
1621 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1622 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1623 , p5_a6 NUMBER := 0-1962.0724
1624 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1625 , p5_a8 NUMBER := 0-1962.0724
1626 , p5_a9 NUMBER := 0-1962.0724
1627 , p5_a10 DATE := fnd_api.g_miss_date
1628 , p5_a11 NUMBER := 0-1962.0724
1629 , p5_a12 DATE := fnd_api.g_miss_date
1630 , p5_a13 DATE := fnd_api.g_miss_date
1631 , p5_a14 DATE := fnd_api.g_miss_date
1632 , p5_a15 DATE := fnd_api.g_miss_date
1633 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1634 , p5_a17 NUMBER := 0-1962.0724
1635 , p5_a18 NUMBER := 0-1962.0724
1636 , p5_a19 NUMBER := 0-1962.0724
1637 , p5_a20 DATE := fnd_api.g_miss_date
1638 , p5_a21 NUMBER := 0-1962.0724
1639 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1640 , p5_a23 NUMBER := 0-1962.0724
1641 , p5_a24 NUMBER := 0-1962.0724
1642 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1643 , p5_a26 NUMBER := 0-1962.0724
1644 , p5_a27 NUMBER := 0-1962.0724
1645 )
1646
1647 as
1648 ddp_stmv_rec okl_streams_pub.stmv_rec_type;
1649 ddindx binary_integer; indx binary_integer;
1650 begin
1651
1652 -- copy data to the local IN or IN-OUT args, if any
1653
1654
1655
1656
1657
1658 ddp_stmv_rec.id := rosetta_g_miss_num_map(p5_a0);
1659 ddp_stmv_rec.sty_id := rosetta_g_miss_num_map(p5_a1);
1660 ddp_stmv_rec.khr_id := rosetta_g_miss_num_map(p5_a2);
1661 ddp_stmv_rec.kle_id := rosetta_g_miss_num_map(p5_a3);
1662 ddp_stmv_rec.sgn_code := p5_a4;
1663 ddp_stmv_rec.say_code := p5_a5;
1664 ddp_stmv_rec.transaction_number := rosetta_g_miss_num_map(p5_a6);
1665 ddp_stmv_rec.active_yn := p5_a7;
1666 ddp_stmv_rec.object_version_number := rosetta_g_miss_num_map(p5_a8);
1667 ddp_stmv_rec.created_by := rosetta_g_miss_num_map(p5_a9);
1668 ddp_stmv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a10);
1669 ddp_stmv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a11);
1670 ddp_stmv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a12);
1671 ddp_stmv_rec.date_current := rosetta_g_miss_date_in_map(p5_a13);
1672 ddp_stmv_rec.date_working := rosetta_g_miss_date_in_map(p5_a14);
1673 ddp_stmv_rec.date_history := rosetta_g_miss_date_in_map(p5_a15);
1674 ddp_stmv_rec.comments := p5_a16;
1675 ddp_stmv_rec.program_id := rosetta_g_miss_num_map(p5_a17);
1676 ddp_stmv_rec.request_id := rosetta_g_miss_num_map(p5_a18);
1677 ddp_stmv_rec.program_application_id := rosetta_g_miss_num_map(p5_a19);
1678 ddp_stmv_rec.program_update_date := rosetta_g_miss_date_in_map(p5_a20);
1679 ddp_stmv_rec.last_update_login := rosetta_g_miss_num_map(p5_a21);
1680 ddp_stmv_rec.purpose_code := p5_a22;
1681 ddp_stmv_rec.stm_id := rosetta_g_miss_num_map(p5_a23);
1682 ddp_stmv_rec.source_id := rosetta_g_miss_num_map(p5_a24);
1683 ddp_stmv_rec.source_table := p5_a25;
1684 ddp_stmv_rec.trx_id := rosetta_g_miss_num_map(p5_a26);
1685 ddp_stmv_rec.link_hist_stream_id := rosetta_g_miss_num_map(p5_a27);
1686
1687 -- here's the delegated call to the old PL/SQL routine
1688 okl_streams_pub.lock_streams(p_api_version,
1689 p_init_msg_list,
1690 x_return_status,
1691 x_msg_count,
1692 x_msg_data,
1693 ddp_stmv_rec);
1694
1695 -- copy data back from the local variables to OUT or IN-OUT args, if any
1696
1697
1698
1699
1700
1701 end;
1702
1703 procedure update_streams(p_api_version NUMBER
1704 , p_init_msg_list VARCHAR2
1705 , x_return_status out nocopy VARCHAR2
1706 , x_msg_count out nocopy NUMBER
1707 , x_msg_data out nocopy VARCHAR2
1708 , p5_a0 JTF_NUMBER_TABLE
1709 , p5_a1 JTF_NUMBER_TABLE
1710 , p5_a2 JTF_NUMBER_TABLE
1711 , p5_a3 JTF_NUMBER_TABLE
1712 , p5_a4 JTF_VARCHAR2_TABLE_100
1713 , p5_a5 JTF_VARCHAR2_TABLE_100
1714 , p5_a6 JTF_NUMBER_TABLE
1715 , p5_a7 JTF_VARCHAR2_TABLE_100
1716 , p5_a8 JTF_NUMBER_TABLE
1717 , p5_a9 JTF_NUMBER_TABLE
1718 , p5_a10 JTF_DATE_TABLE
1719 , p5_a11 JTF_NUMBER_TABLE
1720 , p5_a12 JTF_DATE_TABLE
1721 , p5_a13 JTF_DATE_TABLE
1722 , p5_a14 JTF_DATE_TABLE
1723 , p5_a15 JTF_DATE_TABLE
1724 , p5_a16 JTF_VARCHAR2_TABLE_2000
1725 , p5_a17 JTF_NUMBER_TABLE
1726 , p5_a18 JTF_NUMBER_TABLE
1727 , p5_a19 JTF_NUMBER_TABLE
1728 , p5_a20 JTF_DATE_TABLE
1729 , p5_a21 JTF_NUMBER_TABLE
1730 , p5_a22 JTF_VARCHAR2_TABLE_100
1731 , p5_a23 JTF_NUMBER_TABLE
1732 , p5_a24 JTF_NUMBER_TABLE
1733 , p5_a25 JTF_VARCHAR2_TABLE_100
1734 , p5_a26 JTF_NUMBER_TABLE
1735 , p5_a27 JTF_NUMBER_TABLE
1736 , p6_a0 out nocopy JTF_NUMBER_TABLE
1737 , p6_a1 out nocopy JTF_NUMBER_TABLE
1738 , p6_a2 out nocopy JTF_NUMBER_TABLE
1739 , p6_a3 out nocopy JTF_NUMBER_TABLE
1740 , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1741 , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
1742 , p6_a6 out nocopy JTF_NUMBER_TABLE
1743 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
1744 , p6_a8 out nocopy JTF_NUMBER_TABLE
1745 , p6_a9 out nocopy JTF_NUMBER_TABLE
1746 , p6_a10 out nocopy JTF_DATE_TABLE
1747 , p6_a11 out nocopy JTF_NUMBER_TABLE
1748 , p6_a12 out nocopy JTF_DATE_TABLE
1749 , p6_a13 out nocopy JTF_DATE_TABLE
1750 , p6_a14 out nocopy JTF_DATE_TABLE
1751 , p6_a15 out nocopy JTF_DATE_TABLE
1752 , p6_a16 out nocopy JTF_VARCHAR2_TABLE_2000
1753 , p6_a17 out nocopy JTF_NUMBER_TABLE
1754 , p6_a18 out nocopy JTF_NUMBER_TABLE
1755 , p6_a19 out nocopy JTF_NUMBER_TABLE
1756 , p6_a20 out nocopy JTF_DATE_TABLE
1757 , p6_a21 out nocopy JTF_NUMBER_TABLE
1758 , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
1759 , p6_a23 out nocopy JTF_NUMBER_TABLE
1760 , p6_a24 out nocopy JTF_NUMBER_TABLE
1761 , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
1762 , p6_a26 out nocopy JTF_NUMBER_TABLE
1763 , p6_a27 out nocopy JTF_NUMBER_TABLE
1764 )
1765
1766 as
1767 ddp_stmv_tbl okl_streams_pub.stmv_tbl_type;
1768 ddx_stmv_tbl okl_streams_pub.stmv_tbl_type;
1769 ddindx binary_integer; indx binary_integer;
1770 begin
1771
1772 -- copy data to the local IN or IN-OUT args, if any
1773
1774
1775
1776
1777
1778 okl_stm_pvt_w.rosetta_table_copy_in_p5(ddp_stmv_tbl, p5_a0
1779 , p5_a1
1780 , p5_a2
1781 , p5_a3
1782 , p5_a4
1783 , p5_a5
1784 , p5_a6
1785 , p5_a7
1786 , p5_a8
1787 , p5_a9
1788 , p5_a10
1789 , p5_a11
1790 , p5_a12
1791 , p5_a13
1792 , p5_a14
1793 , p5_a15
1794 , p5_a16
1795 , p5_a17
1796 , p5_a18
1797 , p5_a19
1798 , p5_a20
1799 , p5_a21
1800 , p5_a22
1801 , p5_a23
1802 , p5_a24
1803 , p5_a25
1804 , p5_a26
1805 , p5_a27
1806 );
1807
1808
1809 -- here's the delegated call to the old PL/SQL routine
1810 okl_streams_pub.update_streams(p_api_version,
1811 p_init_msg_list,
1812 x_return_status,
1813 x_msg_count,
1814 x_msg_data,
1815 ddp_stmv_tbl,
1816 ddx_stmv_tbl);
1817
1818 -- copy data back from the local variables to OUT or IN-OUT args, if any
1819
1820
1821
1822
1823
1824
1825 okl_stm_pvt_w.rosetta_table_copy_out_p5(ddx_stmv_tbl, p6_a0
1826 , p6_a1
1827 , p6_a2
1828 , p6_a3
1829 , p6_a4
1830 , p6_a5
1831 , p6_a6
1832 , p6_a7
1833 , p6_a8
1834 , p6_a9
1835 , p6_a10
1836 , p6_a11
1837 , p6_a12
1838 , p6_a13
1839 , p6_a14
1840 , p6_a15
1841 , p6_a16
1842 , p6_a17
1843 , p6_a18
1844 , p6_a19
1845 , p6_a20
1846 , p6_a21
1847 , p6_a22
1848 , p6_a23
1849 , p6_a24
1850 , p6_a25
1851 , p6_a26
1852 , p6_a27
1853 );
1854 end;
1855
1856 procedure update_streams(p_api_version NUMBER
1857 , p_init_msg_list VARCHAR2
1858 , x_return_status out nocopy VARCHAR2
1859 , x_msg_count out nocopy NUMBER
1860 , x_msg_data out nocopy VARCHAR2
1861 , p6_a0 out nocopy NUMBER
1862 , p6_a1 out nocopy NUMBER
1863 , p6_a2 out nocopy NUMBER
1864 , p6_a3 out nocopy NUMBER
1865 , p6_a4 out nocopy VARCHAR2
1866 , p6_a5 out nocopy VARCHAR2
1867 , p6_a6 out nocopy NUMBER
1868 , p6_a7 out nocopy VARCHAR2
1869 , p6_a8 out nocopy NUMBER
1870 , p6_a9 out nocopy NUMBER
1871 , p6_a10 out nocopy DATE
1872 , p6_a11 out nocopy NUMBER
1873 , p6_a12 out nocopy DATE
1874 , p6_a13 out nocopy DATE
1875 , p6_a14 out nocopy DATE
1876 , p6_a15 out nocopy DATE
1877 , p6_a16 out nocopy VARCHAR2
1878 , p6_a17 out nocopy NUMBER
1879 , p6_a18 out nocopy NUMBER
1880 , p6_a19 out nocopy NUMBER
1881 , p6_a20 out nocopy DATE
1882 , p6_a21 out nocopy NUMBER
1883 , p6_a22 out nocopy VARCHAR2
1884 , p6_a23 out nocopy NUMBER
1885 , p6_a24 out nocopy NUMBER
1886 , p6_a25 out nocopy VARCHAR2
1887 , p6_a26 out nocopy NUMBER
1888 , p6_a27 out nocopy NUMBER
1889 , p5_a0 NUMBER := 0-1962.0724
1890 , p5_a1 NUMBER := 0-1962.0724
1891 , p5_a2 NUMBER := 0-1962.0724
1892 , p5_a3 NUMBER := 0-1962.0724
1893 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1894 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1895 , p5_a6 NUMBER := 0-1962.0724
1896 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1897 , p5_a8 NUMBER := 0-1962.0724
1898 , p5_a9 NUMBER := 0-1962.0724
1899 , p5_a10 DATE := fnd_api.g_miss_date
1900 , p5_a11 NUMBER := 0-1962.0724
1901 , p5_a12 DATE := fnd_api.g_miss_date
1902 , p5_a13 DATE := fnd_api.g_miss_date
1903 , p5_a14 DATE := fnd_api.g_miss_date
1904 , p5_a15 DATE := fnd_api.g_miss_date
1905 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1906 , p5_a17 NUMBER := 0-1962.0724
1907 , p5_a18 NUMBER := 0-1962.0724
1908 , p5_a19 NUMBER := 0-1962.0724
1909 , p5_a20 DATE := fnd_api.g_miss_date
1910 , p5_a21 NUMBER := 0-1962.0724
1911 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1912 , p5_a23 NUMBER := 0-1962.0724
1913 , p5_a24 NUMBER := 0-1962.0724
1914 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1915 , p5_a26 NUMBER := 0-1962.0724
1916 , p5_a27 NUMBER := 0-1962.0724
1917 )
1918
1919 as
1920 ddp_stmv_rec okl_streams_pub.stmv_rec_type;
1921 ddx_stmv_rec okl_streams_pub.stmv_rec_type;
1922 ddindx binary_integer; indx binary_integer;
1923 begin
1924
1925 -- copy data to the local IN or IN-OUT args, if any
1926
1927
1928
1929
1930
1931 ddp_stmv_rec.id := rosetta_g_miss_num_map(p5_a0);
1932 ddp_stmv_rec.sty_id := rosetta_g_miss_num_map(p5_a1);
1933 ddp_stmv_rec.khr_id := rosetta_g_miss_num_map(p5_a2);
1934 ddp_stmv_rec.kle_id := rosetta_g_miss_num_map(p5_a3);
1935 ddp_stmv_rec.sgn_code := p5_a4;
1936 ddp_stmv_rec.say_code := p5_a5;
1937 ddp_stmv_rec.transaction_number := rosetta_g_miss_num_map(p5_a6);
1938 ddp_stmv_rec.active_yn := p5_a7;
1939 ddp_stmv_rec.object_version_number := rosetta_g_miss_num_map(p5_a8);
1940 ddp_stmv_rec.created_by := rosetta_g_miss_num_map(p5_a9);
1941 ddp_stmv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a10);
1942 ddp_stmv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a11);
1943 ddp_stmv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a12);
1944 ddp_stmv_rec.date_current := rosetta_g_miss_date_in_map(p5_a13);
1945 ddp_stmv_rec.date_working := rosetta_g_miss_date_in_map(p5_a14);
1946 ddp_stmv_rec.date_history := rosetta_g_miss_date_in_map(p5_a15);
1947 ddp_stmv_rec.comments := p5_a16;
1948 ddp_stmv_rec.program_id := rosetta_g_miss_num_map(p5_a17);
1949 ddp_stmv_rec.request_id := rosetta_g_miss_num_map(p5_a18);
1950 ddp_stmv_rec.program_application_id := rosetta_g_miss_num_map(p5_a19);
1951 ddp_stmv_rec.program_update_date := rosetta_g_miss_date_in_map(p5_a20);
1952 ddp_stmv_rec.last_update_login := rosetta_g_miss_num_map(p5_a21);
1953 ddp_stmv_rec.purpose_code := p5_a22;
1954 ddp_stmv_rec.stm_id := rosetta_g_miss_num_map(p5_a23);
1955 ddp_stmv_rec.source_id := rosetta_g_miss_num_map(p5_a24);
1956 ddp_stmv_rec.source_table := p5_a25;
1957 ddp_stmv_rec.trx_id := rosetta_g_miss_num_map(p5_a26);
1958 ddp_stmv_rec.link_hist_stream_id := rosetta_g_miss_num_map(p5_a27);
1959
1960
1961 -- here's the delegated call to the old PL/SQL routine
1962 okl_streams_pub.update_streams(p_api_version,
1963 p_init_msg_list,
1964 x_return_status,
1965 x_msg_count,
1966 x_msg_data,
1967 ddp_stmv_rec,
1968 ddx_stmv_rec);
1969
1970 -- copy data back from the local variables to OUT or IN-OUT args, if any
1971
1972
1973
1974
1975
1976
1977 p6_a0 := rosetta_g_miss_num_map(ddx_stmv_rec.id);
1978 p6_a1 := rosetta_g_miss_num_map(ddx_stmv_rec.sty_id);
1979 p6_a2 := rosetta_g_miss_num_map(ddx_stmv_rec.khr_id);
1980 p6_a3 := rosetta_g_miss_num_map(ddx_stmv_rec.kle_id);
1981 p6_a4 := ddx_stmv_rec.sgn_code;
1982 p6_a5 := ddx_stmv_rec.say_code;
1983 p6_a6 := rosetta_g_miss_num_map(ddx_stmv_rec.transaction_number);
1984 p6_a7 := ddx_stmv_rec.active_yn;
1985 p6_a8 := rosetta_g_miss_num_map(ddx_stmv_rec.object_version_number);
1986 p6_a9 := rosetta_g_miss_num_map(ddx_stmv_rec.created_by);
1987 p6_a10 := ddx_stmv_rec.creation_date;
1988 p6_a11 := rosetta_g_miss_num_map(ddx_stmv_rec.last_updated_by);
1989 p6_a12 := ddx_stmv_rec.last_update_date;
1990 p6_a13 := ddx_stmv_rec.date_current;
1991 p6_a14 := ddx_stmv_rec.date_working;
1992 p6_a15 := ddx_stmv_rec.date_history;
1993 p6_a16 := ddx_stmv_rec.comments;
1994 p6_a17 := rosetta_g_miss_num_map(ddx_stmv_rec.program_id);
1995 p6_a18 := rosetta_g_miss_num_map(ddx_stmv_rec.request_id);
1996 p6_a19 := rosetta_g_miss_num_map(ddx_stmv_rec.program_application_id);
1997 p6_a20 := ddx_stmv_rec.program_update_date;
1998 p6_a21 := rosetta_g_miss_num_map(ddx_stmv_rec.last_update_login);
1999 p6_a22 := ddx_stmv_rec.purpose_code;
2000 p6_a23 := rosetta_g_miss_num_map(ddx_stmv_rec.stm_id);
2001 p6_a24 := rosetta_g_miss_num_map(ddx_stmv_rec.source_id);
2002 p6_a25 := ddx_stmv_rec.source_table;
2003 p6_a26 := rosetta_g_miss_num_map(ddx_stmv_rec.trx_id);
2004 p6_a27 := rosetta_g_miss_num_map(ddx_stmv_rec.link_hist_stream_id);
2005 end;
2006
2007 procedure delete_streams(p_api_version NUMBER
2008 , p_init_msg_list VARCHAR2
2009 , x_return_status out nocopy VARCHAR2
2010 , x_msg_count out nocopy NUMBER
2011 , x_msg_data out nocopy VARCHAR2
2012 , p5_a0 JTF_NUMBER_TABLE
2013 , p5_a1 JTF_NUMBER_TABLE
2014 , p5_a2 JTF_NUMBER_TABLE
2015 , p5_a3 JTF_NUMBER_TABLE
2016 , p5_a4 JTF_VARCHAR2_TABLE_100
2017 , p5_a5 JTF_VARCHAR2_TABLE_100
2018 , p5_a6 JTF_NUMBER_TABLE
2019 , p5_a7 JTF_VARCHAR2_TABLE_100
2020 , p5_a8 JTF_NUMBER_TABLE
2021 , p5_a9 JTF_NUMBER_TABLE
2022 , p5_a10 JTF_DATE_TABLE
2023 , p5_a11 JTF_NUMBER_TABLE
2024 , p5_a12 JTF_DATE_TABLE
2025 , p5_a13 JTF_DATE_TABLE
2026 , p5_a14 JTF_DATE_TABLE
2027 , p5_a15 JTF_DATE_TABLE
2028 , p5_a16 JTF_VARCHAR2_TABLE_2000
2029 , p5_a17 JTF_NUMBER_TABLE
2030 , p5_a18 JTF_NUMBER_TABLE
2031 , p5_a19 JTF_NUMBER_TABLE
2032 , p5_a20 JTF_DATE_TABLE
2033 , p5_a21 JTF_NUMBER_TABLE
2034 , p5_a22 JTF_VARCHAR2_TABLE_100
2035 , p5_a23 JTF_NUMBER_TABLE
2036 , p5_a24 JTF_NUMBER_TABLE
2037 , p5_a25 JTF_VARCHAR2_TABLE_100
2038 , p5_a26 JTF_NUMBER_TABLE
2039 , p5_a27 JTF_NUMBER_TABLE
2040 )
2041
2042 as
2043 ddp_stmv_tbl okl_streams_pub.stmv_tbl_type;
2044 ddindx binary_integer; indx binary_integer;
2045 begin
2046
2047 -- copy data to the local IN or IN-OUT args, if any
2048
2049
2050
2051
2052
2053 okl_stm_pvt_w.rosetta_table_copy_in_p5(ddp_stmv_tbl, p5_a0
2054 , p5_a1
2055 , p5_a2
2056 , p5_a3
2057 , p5_a4
2058 , p5_a5
2059 , p5_a6
2060 , p5_a7
2061 , p5_a8
2062 , p5_a9
2063 , p5_a10
2064 , p5_a11
2065 , p5_a12
2066 , p5_a13
2067 , p5_a14
2068 , p5_a15
2069 , p5_a16
2070 , p5_a17
2071 , p5_a18
2072 , p5_a19
2073 , p5_a20
2074 , p5_a21
2075 , p5_a22
2076 , p5_a23
2077 , p5_a24
2078 , p5_a25
2079 , p5_a26
2080 , p5_a27
2081 );
2082
2083 -- here's the delegated call to the old PL/SQL routine
2084 okl_streams_pub.delete_streams(p_api_version,
2085 p_init_msg_list,
2086 x_return_status,
2087 x_msg_count,
2088 x_msg_data,
2089 ddp_stmv_tbl);
2090
2091 -- copy data back from the local variables to OUT or IN-OUT args, if any
2092
2093
2094
2095
2096
2097 end;
2098
2099 procedure delete_streams(p_api_version NUMBER
2100 , p_init_msg_list VARCHAR2
2101 , x_return_status out nocopy VARCHAR2
2102 , x_msg_count out nocopy NUMBER
2103 , x_msg_data out nocopy VARCHAR2
2104 , p5_a0 NUMBER := 0-1962.0724
2105 , p5_a1 NUMBER := 0-1962.0724
2106 , p5_a2 NUMBER := 0-1962.0724
2107 , p5_a3 NUMBER := 0-1962.0724
2108 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
2109 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
2110 , p5_a6 NUMBER := 0-1962.0724
2111 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
2112 , p5_a8 NUMBER := 0-1962.0724
2113 , p5_a9 NUMBER := 0-1962.0724
2114 , p5_a10 DATE := fnd_api.g_miss_date
2115 , p5_a11 NUMBER := 0-1962.0724
2116 , p5_a12 DATE := fnd_api.g_miss_date
2117 , p5_a13 DATE := fnd_api.g_miss_date
2118 , p5_a14 DATE := fnd_api.g_miss_date
2119 , p5_a15 DATE := fnd_api.g_miss_date
2120 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
2121 , p5_a17 NUMBER := 0-1962.0724
2122 , p5_a18 NUMBER := 0-1962.0724
2123 , p5_a19 NUMBER := 0-1962.0724
2124 , p5_a20 DATE := fnd_api.g_miss_date
2125 , p5_a21 NUMBER := 0-1962.0724
2126 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
2127 , p5_a23 NUMBER := 0-1962.0724
2128 , p5_a24 NUMBER := 0-1962.0724
2129 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
2130 , p5_a26 NUMBER := 0-1962.0724
2131 , p5_a27 NUMBER := 0-1962.0724
2132 )
2133
2134 as
2135 ddp_stmv_rec okl_streams_pub.stmv_rec_type;
2136 ddindx binary_integer; indx binary_integer;
2137 begin
2138
2139 -- copy data to the local IN or IN-OUT args, if any
2140
2141
2142
2143
2144
2145 ddp_stmv_rec.id := rosetta_g_miss_num_map(p5_a0);
2146 ddp_stmv_rec.sty_id := rosetta_g_miss_num_map(p5_a1);
2147 ddp_stmv_rec.khr_id := rosetta_g_miss_num_map(p5_a2);
2148 ddp_stmv_rec.kle_id := rosetta_g_miss_num_map(p5_a3);
2149 ddp_stmv_rec.sgn_code := p5_a4;
2150 ddp_stmv_rec.say_code := p5_a5;
2151 ddp_stmv_rec.transaction_number := rosetta_g_miss_num_map(p5_a6);
2152 ddp_stmv_rec.active_yn := p5_a7;
2153 ddp_stmv_rec.object_version_number := rosetta_g_miss_num_map(p5_a8);
2154 ddp_stmv_rec.created_by := rosetta_g_miss_num_map(p5_a9);
2155 ddp_stmv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a10);
2156 ddp_stmv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a11);
2157 ddp_stmv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a12);
2158 ddp_stmv_rec.date_current := rosetta_g_miss_date_in_map(p5_a13);
2159 ddp_stmv_rec.date_working := rosetta_g_miss_date_in_map(p5_a14);
2160 ddp_stmv_rec.date_history := rosetta_g_miss_date_in_map(p5_a15);
2161 ddp_stmv_rec.comments := p5_a16;
2162 ddp_stmv_rec.program_id := rosetta_g_miss_num_map(p5_a17);
2163 ddp_stmv_rec.request_id := rosetta_g_miss_num_map(p5_a18);
2164 ddp_stmv_rec.program_application_id := rosetta_g_miss_num_map(p5_a19);
2165 ddp_stmv_rec.program_update_date := rosetta_g_miss_date_in_map(p5_a20);
2166 ddp_stmv_rec.last_update_login := rosetta_g_miss_num_map(p5_a21);
2167 ddp_stmv_rec.purpose_code := p5_a22;
2168 ddp_stmv_rec.stm_id := rosetta_g_miss_num_map(p5_a23);
2169 ddp_stmv_rec.source_id := rosetta_g_miss_num_map(p5_a24);
2170 ddp_stmv_rec.source_table := p5_a25;
2171 ddp_stmv_rec.trx_id := rosetta_g_miss_num_map(p5_a26);
2172 ddp_stmv_rec.link_hist_stream_id := rosetta_g_miss_num_map(p5_a27);
2173
2174 -- here's the delegated call to the old PL/SQL routine
2175 okl_streams_pub.delete_streams(p_api_version,
2176 p_init_msg_list,
2177 x_return_status,
2178 x_msg_count,
2179 x_msg_data,
2180 ddp_stmv_rec);
2181
2182 -- copy data back from the local variables to OUT or IN-OUT args, if any
2183
2184
2185
2186
2187
2188 end;
2189
2190 procedure validate_streams(p_api_version NUMBER
2191 , p_init_msg_list VARCHAR2
2192 , x_return_status out nocopy VARCHAR2
2193 , x_msg_count out nocopy NUMBER
2194 , x_msg_data out nocopy VARCHAR2
2195 , p5_a0 JTF_NUMBER_TABLE
2196 , p5_a1 JTF_NUMBER_TABLE
2197 , p5_a2 JTF_NUMBER_TABLE
2198 , p5_a3 JTF_NUMBER_TABLE
2199 , p5_a4 JTF_VARCHAR2_TABLE_100
2200 , p5_a5 JTF_VARCHAR2_TABLE_100
2201 , p5_a6 JTF_NUMBER_TABLE
2202 , p5_a7 JTF_VARCHAR2_TABLE_100
2203 , p5_a8 JTF_NUMBER_TABLE
2204 , p5_a9 JTF_NUMBER_TABLE
2205 , p5_a10 JTF_DATE_TABLE
2206 , p5_a11 JTF_NUMBER_TABLE
2207 , p5_a12 JTF_DATE_TABLE
2208 , p5_a13 JTF_DATE_TABLE
2209 , p5_a14 JTF_DATE_TABLE
2210 , p5_a15 JTF_DATE_TABLE
2211 , p5_a16 JTF_VARCHAR2_TABLE_2000
2212 , p5_a17 JTF_NUMBER_TABLE
2213 , p5_a18 JTF_NUMBER_TABLE
2214 , p5_a19 JTF_NUMBER_TABLE
2215 , p5_a20 JTF_DATE_TABLE
2216 , p5_a21 JTF_NUMBER_TABLE
2217 , p5_a22 JTF_VARCHAR2_TABLE_100
2218 , p5_a23 JTF_NUMBER_TABLE
2219 , p5_a24 JTF_NUMBER_TABLE
2220 , p5_a25 JTF_VARCHAR2_TABLE_100
2221 , p5_a26 JTF_NUMBER_TABLE
2222 , p5_a27 JTF_NUMBER_TABLE
2223 )
2224
2225 as
2226 ddp_stmv_tbl okl_streams_pub.stmv_tbl_type;
2227 ddindx binary_integer; indx binary_integer;
2228 begin
2229
2230 -- copy data to the local IN or IN-OUT args, if any
2231
2232
2233
2234
2235
2236 okl_stm_pvt_w.rosetta_table_copy_in_p5(ddp_stmv_tbl, p5_a0
2237 , p5_a1
2238 , p5_a2
2239 , p5_a3
2240 , p5_a4
2241 , p5_a5
2242 , p5_a6
2243 , p5_a7
2244 , p5_a8
2245 , p5_a9
2246 , p5_a10
2247 , p5_a11
2248 , p5_a12
2249 , p5_a13
2250 , p5_a14
2251 , p5_a15
2252 , p5_a16
2253 , p5_a17
2254 , p5_a18
2255 , p5_a19
2256 , p5_a20
2257 , p5_a21
2258 , p5_a22
2259 , p5_a23
2260 , p5_a24
2261 , p5_a25
2262 , p5_a26
2263 , p5_a27
2264 );
2265
2266 -- here's the delegated call to the old PL/SQL routine
2267 okl_streams_pub.validate_streams(p_api_version,
2268 p_init_msg_list,
2269 x_return_status,
2270 x_msg_count,
2271 x_msg_data,
2272 ddp_stmv_tbl);
2273
2274 -- copy data back from the local variables to OUT or IN-OUT args, if any
2275
2276
2277
2278
2279
2280 end;
2281
2282 procedure validate_streams(p_api_version NUMBER
2283 , p_init_msg_list VARCHAR2
2284 , x_return_status out nocopy VARCHAR2
2285 , x_msg_count out nocopy NUMBER
2286 , x_msg_data out nocopy VARCHAR2
2287 , p5_a0 NUMBER := 0-1962.0724
2288 , p5_a1 NUMBER := 0-1962.0724
2289 , p5_a2 NUMBER := 0-1962.0724
2290 , p5_a3 NUMBER := 0-1962.0724
2291 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
2292 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
2293 , p5_a6 NUMBER := 0-1962.0724
2294 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
2295 , p5_a8 NUMBER := 0-1962.0724
2296 , p5_a9 NUMBER := 0-1962.0724
2297 , p5_a10 DATE := fnd_api.g_miss_date
2298 , p5_a11 NUMBER := 0-1962.0724
2299 , p5_a12 DATE := fnd_api.g_miss_date
2300 , p5_a13 DATE := fnd_api.g_miss_date
2301 , p5_a14 DATE := fnd_api.g_miss_date
2302 , p5_a15 DATE := fnd_api.g_miss_date
2303 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
2304 , p5_a17 NUMBER := 0-1962.0724
2305 , p5_a18 NUMBER := 0-1962.0724
2306 , p5_a19 NUMBER := 0-1962.0724
2307 , p5_a20 DATE := fnd_api.g_miss_date
2308 , p5_a21 NUMBER := 0-1962.0724
2309 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
2310 , p5_a23 NUMBER := 0-1962.0724
2311 , p5_a24 NUMBER := 0-1962.0724
2312 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
2313 , p5_a26 NUMBER := 0-1962.0724
2314 , p5_a27 NUMBER := 0-1962.0724
2315 )
2316
2317 as
2318 ddp_stmv_rec okl_streams_pub.stmv_rec_type;
2319 ddindx binary_integer; indx binary_integer;
2320 begin
2321
2322 -- copy data to the local IN or IN-OUT args, if any
2323
2324
2325
2326
2327
2328 ddp_stmv_rec.id := rosetta_g_miss_num_map(p5_a0);
2329 ddp_stmv_rec.sty_id := rosetta_g_miss_num_map(p5_a1);
2330 ddp_stmv_rec.khr_id := rosetta_g_miss_num_map(p5_a2);
2331 ddp_stmv_rec.kle_id := rosetta_g_miss_num_map(p5_a3);
2332 ddp_stmv_rec.sgn_code := p5_a4;
2333 ddp_stmv_rec.say_code := p5_a5;
2334 ddp_stmv_rec.transaction_number := rosetta_g_miss_num_map(p5_a6);
2335 ddp_stmv_rec.active_yn := p5_a7;
2336 ddp_stmv_rec.object_version_number := rosetta_g_miss_num_map(p5_a8);
2337 ddp_stmv_rec.created_by := rosetta_g_miss_num_map(p5_a9);
2338 ddp_stmv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a10);
2339 ddp_stmv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a11);
2340 ddp_stmv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a12);
2341 ddp_stmv_rec.date_current := rosetta_g_miss_date_in_map(p5_a13);
2342 ddp_stmv_rec.date_working := rosetta_g_miss_date_in_map(p5_a14);
2343 ddp_stmv_rec.date_history := rosetta_g_miss_date_in_map(p5_a15);
2344 ddp_stmv_rec.comments := p5_a16;
2345 ddp_stmv_rec.program_id := rosetta_g_miss_num_map(p5_a17);
2346 ddp_stmv_rec.request_id := rosetta_g_miss_num_map(p5_a18);
2347 ddp_stmv_rec.program_application_id := rosetta_g_miss_num_map(p5_a19);
2348 ddp_stmv_rec.program_update_date := rosetta_g_miss_date_in_map(p5_a20);
2349 ddp_stmv_rec.last_update_login := rosetta_g_miss_num_map(p5_a21);
2350 ddp_stmv_rec.purpose_code := p5_a22;
2351 ddp_stmv_rec.stm_id := rosetta_g_miss_num_map(p5_a23);
2352 ddp_stmv_rec.source_id := rosetta_g_miss_num_map(p5_a24);
2353 ddp_stmv_rec.source_table := p5_a25;
2354 ddp_stmv_rec.trx_id := rosetta_g_miss_num_map(p5_a26);
2355 ddp_stmv_rec.link_hist_stream_id := rosetta_g_miss_num_map(p5_a27);
2356
2357 -- here's the delegated call to the old PL/SQL routine
2358 okl_streams_pub.validate_streams(p_api_version,
2359 p_init_msg_list,
2360 x_return_status,
2361 x_msg_count,
2362 x_msg_data,
2363 ddp_stmv_rec);
2364
2365 -- copy data back from the local variables to OUT or IN-OUT args, if any
2366
2367
2368
2369
2370
2371 end;
2372
2373 procedure create_stream_elements(p_api_version NUMBER
2374 , p_init_msg_list VARCHAR2
2375 , x_return_status out nocopy VARCHAR2
2376 , x_msg_count out nocopy NUMBER
2377 , x_msg_data out nocopy VARCHAR2
2378 , p5_a0 JTF_NUMBER_TABLE
2379 , p5_a1 JTF_NUMBER_TABLE
2380 , p5_a2 JTF_NUMBER_TABLE
2381 , p5_a3 JTF_NUMBER_TABLE
2382 , p5_a4 JTF_VARCHAR2_TABLE_2000
2383 , p5_a5 JTF_VARCHAR2_TABLE_100
2384 , p5_a6 JTF_DATE_TABLE
2385 , p5_a7 JTF_NUMBER_TABLE
2386 , p5_a8 JTF_NUMBER_TABLE
2387 , p5_a9 JTF_NUMBER_TABLE
2388 , p5_a10 JTF_DATE_TABLE
2389 , p5_a11 JTF_NUMBER_TABLE
2390 , p5_a12 JTF_DATE_TABLE
2391 , p5_a13 JTF_NUMBER_TABLE
2392 , p5_a14 JTF_DATE_TABLE
2393 , p5_a15 JTF_NUMBER_TABLE
2394 , p5_a16 JTF_DATE_TABLE
2395 , p5_a17 JTF_NUMBER_TABLE
2396 , p5_a18 JTF_NUMBER_TABLE
2397 , p5_a19 JTF_NUMBER_TABLE
2398 , p5_a20 JTF_NUMBER_TABLE
2399 , p5_a21 JTF_VARCHAR2_TABLE_100
2400 , p5_a22 JTF_VARCHAR2_TABLE_100
2401 , p5_a23 JTF_VARCHAR2_TABLE_100
2402 , p5_a24 JTF_DATE_TABLE
2403 , p6_a0 out nocopy JTF_NUMBER_TABLE
2404 , p6_a1 out nocopy JTF_NUMBER_TABLE
2405 , p6_a2 out nocopy JTF_NUMBER_TABLE
2406 , p6_a3 out nocopy JTF_NUMBER_TABLE
2407 , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
2408 , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
2409 , p6_a6 out nocopy JTF_DATE_TABLE
2410 , p6_a7 out nocopy JTF_NUMBER_TABLE
2411 , p6_a8 out nocopy JTF_NUMBER_TABLE
2412 , p6_a9 out nocopy JTF_NUMBER_TABLE
2413 , p6_a10 out nocopy JTF_DATE_TABLE
2414 , p6_a11 out nocopy JTF_NUMBER_TABLE
2415 , p6_a12 out nocopy JTF_DATE_TABLE
2416 , p6_a13 out nocopy JTF_NUMBER_TABLE
2417 , p6_a14 out nocopy JTF_DATE_TABLE
2418 , p6_a15 out nocopy JTF_NUMBER_TABLE
2419 , p6_a16 out nocopy JTF_DATE_TABLE
2420 , p6_a17 out nocopy JTF_NUMBER_TABLE
2421 , p6_a18 out nocopy JTF_NUMBER_TABLE
2422 , p6_a19 out nocopy JTF_NUMBER_TABLE
2423 , p6_a20 out nocopy JTF_NUMBER_TABLE
2424 , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
2425 , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
2426 , p6_a23 out nocopy JTF_VARCHAR2_TABLE_100
2427 , p6_a24 out nocopy JTF_DATE_TABLE
2428 )
2429
2430 as
2431 ddp_selv_tbl okl_streams_pub.selv_tbl_type;
2432 ddx_selv_tbl okl_streams_pub.selv_tbl_type;
2433 ddindx binary_integer; indx binary_integer;
2434 begin
2435
2436 -- copy data to the local IN or IN-OUT args, if any
2437
2438
2439
2440
2441
2442 okl_sel_pvt_w.rosetta_table_copy_in_p5(ddp_selv_tbl, p5_a0
2443 , p5_a1
2444 , p5_a2
2445 , p5_a3
2446 , p5_a4
2447 , p5_a5
2448 , p5_a6
2449 , p5_a7
2450 , p5_a8
2451 , p5_a9
2452 , p5_a10
2453 , p5_a11
2454 , p5_a12
2455 , p5_a13
2456 , p5_a14
2457 , p5_a15
2458 , p5_a16
2459 , p5_a17
2460 , p5_a18
2461 , p5_a19
2462 , p5_a20
2463 , p5_a21
2464 , p5_a22
2465 , p5_a23
2466 , p5_a24
2467 );
2468
2469
2470 -- here's the delegated call to the old PL/SQL routine
2471 okl_streams_pub.create_stream_elements(p_api_version,
2472 p_init_msg_list,
2473 x_return_status,
2474 x_msg_count,
2475 x_msg_data,
2476 ddp_selv_tbl,
2477 ddx_selv_tbl);
2478
2479 -- copy data back from the local variables to OUT or IN-OUT args, if any
2480
2481
2482
2483
2484
2485
2486 okl_sel_pvt_w.rosetta_table_copy_out_p5(ddx_selv_tbl, p6_a0
2487 , p6_a1
2488 , p6_a2
2489 , p6_a3
2490 , p6_a4
2491 , p6_a5
2492 , p6_a6
2493 , p6_a7
2494 , p6_a8
2495 , p6_a9
2496 , p6_a10
2497 , p6_a11
2498 , p6_a12
2499 , p6_a13
2500 , p6_a14
2501 , p6_a15
2502 , p6_a16
2503 , p6_a17
2504 , p6_a18
2505 , p6_a19
2506 , p6_a20
2507 , p6_a21
2508 , p6_a22
2509 , p6_a23
2510 , p6_a24
2511 );
2512 end;
2513
2514 procedure create_stream_elements(p_api_version NUMBER
2515 , p_init_msg_list VARCHAR2
2516 , x_return_status out nocopy VARCHAR2
2517 , x_msg_count out nocopy NUMBER
2518 , x_msg_data out nocopy VARCHAR2
2519 , p6_a0 out nocopy NUMBER
2520 , p6_a1 out nocopy NUMBER
2521 , p6_a2 out nocopy NUMBER
2522 , p6_a3 out nocopy NUMBER
2523 , p6_a4 out nocopy VARCHAR2
2524 , p6_a5 out nocopy VARCHAR2
2525 , p6_a6 out nocopy DATE
2526 , p6_a7 out nocopy NUMBER
2527 , p6_a8 out nocopy NUMBER
2528 , p6_a9 out nocopy NUMBER
2529 , p6_a10 out nocopy DATE
2530 , p6_a11 out nocopy NUMBER
2531 , p6_a12 out nocopy DATE
2532 , p6_a13 out nocopy NUMBER
2533 , p6_a14 out nocopy DATE
2534 , p6_a15 out nocopy NUMBER
2535 , p6_a16 out nocopy DATE
2536 , p6_a17 out nocopy NUMBER
2537 , p6_a18 out nocopy NUMBER
2538 , p6_a19 out nocopy NUMBER
2539 , p6_a20 out nocopy NUMBER
2540 , p6_a21 out nocopy VARCHAR2
2541 , p6_a22 out nocopy VARCHAR2
2542 , p6_a23 out nocopy VARCHAR2
2543 , p6_a24 out nocopy DATE
2544 , p5_a0 NUMBER := 0-1962.0724
2545 , p5_a1 NUMBER := 0-1962.0724
2546 , p5_a2 NUMBER := 0-1962.0724
2547 , p5_a3 NUMBER := 0-1962.0724
2548 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
2549 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
2550 , p5_a6 DATE := fnd_api.g_miss_date
2551 , p5_a7 NUMBER := 0-1962.0724
2552 , p5_a8 NUMBER := 0-1962.0724
2553 , p5_a9 NUMBER := 0-1962.0724
2554 , p5_a10 DATE := fnd_api.g_miss_date
2555 , p5_a11 NUMBER := 0-1962.0724
2556 , p5_a12 DATE := fnd_api.g_miss_date
2557 , p5_a13 NUMBER := 0-1962.0724
2558 , p5_a14 DATE := fnd_api.g_miss_date
2559 , p5_a15 NUMBER := 0-1962.0724
2560 , p5_a16 DATE := fnd_api.g_miss_date
2561 , p5_a17 NUMBER := 0-1962.0724
2562 , p5_a18 NUMBER := 0-1962.0724
2563 , p5_a19 NUMBER := 0-1962.0724
2564 , p5_a20 NUMBER := 0-1962.0724
2565 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
2566 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
2567 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
2568 , p5_a24 DATE := fnd_api.g_miss_date
2569 )
2570
2571 as
2572 ddp_selv_rec okl_streams_pub.selv_rec_type;
2573 ddx_selv_rec okl_streams_pub.selv_rec_type;
2574 ddindx binary_integer; indx binary_integer;
2575 begin
2576
2577 -- copy data to the local IN or IN-OUT args, if any
2578
2579
2580
2581
2582
2583 ddp_selv_rec.id := rosetta_g_miss_num_map(p5_a0);
2584 ddp_selv_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
2585 ddp_selv_rec.stm_id := rosetta_g_miss_num_map(p5_a2);
2586 ddp_selv_rec.amount := rosetta_g_miss_num_map(p5_a3);
2587 ddp_selv_rec.comments := p5_a4;
2588 ddp_selv_rec.accrued_yn := p5_a5;
2589 ddp_selv_rec.stream_element_date := rosetta_g_miss_date_in_map(p5_a6);
2590 ddp_selv_rec.program_id := rosetta_g_miss_num_map(p5_a7);
2591 ddp_selv_rec.request_id := rosetta_g_miss_num_map(p5_a8);
2592 ddp_selv_rec.program_application_id := rosetta_g_miss_num_map(p5_a9);
2593 ddp_selv_rec.program_update_date := rosetta_g_miss_date_in_map(p5_a10);
2594 ddp_selv_rec.se_line_number := rosetta_g_miss_num_map(p5_a11);
2595 ddp_selv_rec.date_billed := rosetta_g_miss_date_in_map(p5_a12);
2596 ddp_selv_rec.created_by := rosetta_g_miss_num_map(p5_a13);
2597 ddp_selv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a14);
2598 ddp_selv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a15);
2599 ddp_selv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a16);
2600 ddp_selv_rec.last_update_login := rosetta_g_miss_num_map(p5_a17);
2601 ddp_selv_rec.parent_index := rosetta_g_miss_num_map(p5_a18);
2602 ddp_selv_rec.sel_id := rosetta_g_miss_num_map(p5_a19);
2603 ddp_selv_rec.source_id := rosetta_g_miss_num_map(p5_a20);
2604 ddp_selv_rec.source_table := p5_a21;
2605 ddp_selv_rec.bill_adj_flag := p5_a22;
2606 ddp_selv_rec.accrual_adj_flag := p5_a23;
2607 ddp_selv_rec.date_disbursed := rosetta_g_miss_date_in_map(p5_a24);
2608
2609
2610 -- here's the delegated call to the old PL/SQL routine
2611 okl_streams_pub.create_stream_elements(p_api_version,
2612 p_init_msg_list,
2613 x_return_status,
2614 x_msg_count,
2615 x_msg_data,
2616 ddp_selv_rec,
2617 ddx_selv_rec);
2618
2619 -- copy data back from the local variables to OUT or IN-OUT args, if any
2620
2621
2622
2623
2624
2625
2626 p6_a0 := rosetta_g_miss_num_map(ddx_selv_rec.id);
2627 p6_a1 := rosetta_g_miss_num_map(ddx_selv_rec.object_version_number);
2628 p6_a2 := rosetta_g_miss_num_map(ddx_selv_rec.stm_id);
2629 p6_a3 := rosetta_g_miss_num_map(ddx_selv_rec.amount);
2630 p6_a4 := ddx_selv_rec.comments;
2631 p6_a5 := ddx_selv_rec.accrued_yn;
2632 p6_a6 := ddx_selv_rec.stream_element_date;
2633 p6_a7 := rosetta_g_miss_num_map(ddx_selv_rec.program_id);
2634 p6_a8 := rosetta_g_miss_num_map(ddx_selv_rec.request_id);
2635 p6_a9 := rosetta_g_miss_num_map(ddx_selv_rec.program_application_id);
2636 p6_a10 := ddx_selv_rec.program_update_date;
2637 p6_a11 := rosetta_g_miss_num_map(ddx_selv_rec.se_line_number);
2638 p6_a12 := ddx_selv_rec.date_billed;
2639 p6_a13 := rosetta_g_miss_num_map(ddx_selv_rec.created_by);
2640 p6_a14 := ddx_selv_rec.creation_date;
2641 p6_a15 := rosetta_g_miss_num_map(ddx_selv_rec.last_updated_by);
2642 p6_a16 := ddx_selv_rec.last_update_date;
2643 p6_a17 := rosetta_g_miss_num_map(ddx_selv_rec.last_update_login);
2644 p6_a18 := rosetta_g_miss_num_map(ddx_selv_rec.parent_index);
2645 p6_a19 := rosetta_g_miss_num_map(ddx_selv_rec.sel_id);
2646 p6_a20 := rosetta_g_miss_num_map(ddx_selv_rec.source_id);
2647 p6_a21 := ddx_selv_rec.source_table;
2648 p6_a22 := ddx_selv_rec.bill_adj_flag;
2649 p6_a23 := ddx_selv_rec.accrual_adj_flag;
2650 p6_a24 := ddx_selv_rec.date_disbursed;
2651 end;
2652
2653 procedure lock_stream_elements(p_api_version NUMBER
2654 , p_init_msg_list VARCHAR2
2655 , x_return_status out nocopy VARCHAR2
2656 , x_msg_count out nocopy NUMBER
2657 , x_msg_data out nocopy VARCHAR2
2658 , p5_a0 JTF_NUMBER_TABLE
2659 , p5_a1 JTF_NUMBER_TABLE
2660 , p5_a2 JTF_NUMBER_TABLE
2661 , p5_a3 JTF_NUMBER_TABLE
2662 , p5_a4 JTF_VARCHAR2_TABLE_2000
2663 , p5_a5 JTF_VARCHAR2_TABLE_100
2664 , p5_a6 JTF_DATE_TABLE
2665 , p5_a7 JTF_NUMBER_TABLE
2666 , p5_a8 JTF_NUMBER_TABLE
2667 , p5_a9 JTF_NUMBER_TABLE
2668 , p5_a10 JTF_DATE_TABLE
2669 , p5_a11 JTF_NUMBER_TABLE
2670 , p5_a12 JTF_DATE_TABLE
2671 , p5_a13 JTF_NUMBER_TABLE
2672 , p5_a14 JTF_DATE_TABLE
2673 , p5_a15 JTF_NUMBER_TABLE
2674 , p5_a16 JTF_DATE_TABLE
2675 , p5_a17 JTF_NUMBER_TABLE
2676 , p5_a18 JTF_NUMBER_TABLE
2677 , p5_a19 JTF_NUMBER_TABLE
2678 , p5_a20 JTF_NUMBER_TABLE
2679 , p5_a21 JTF_VARCHAR2_TABLE_100
2680 , p5_a22 JTF_VARCHAR2_TABLE_100
2681 , p5_a23 JTF_VARCHAR2_TABLE_100
2682 , p5_a24 JTF_DATE_TABLE
2683 )
2684
2685 as
2686 ddp_selv_tbl okl_streams_pub.selv_tbl_type;
2687 ddindx binary_integer; indx binary_integer;
2688 begin
2689
2690 -- copy data to the local IN or IN-OUT args, if any
2691
2692
2693
2694
2695
2696 okl_sel_pvt_w.rosetta_table_copy_in_p5(ddp_selv_tbl, p5_a0
2697 , p5_a1
2698 , p5_a2
2699 , p5_a3
2700 , p5_a4
2701 , p5_a5
2702 , p5_a6
2703 , p5_a7
2704 , p5_a8
2705 , p5_a9
2706 , p5_a10
2707 , p5_a11
2708 , p5_a12
2709 , p5_a13
2710 , p5_a14
2711 , p5_a15
2712 , p5_a16
2713 , p5_a17
2714 , p5_a18
2715 , p5_a19
2716 , p5_a20
2717 , p5_a21
2718 , p5_a22
2719 , p5_a23
2720 , p5_a24
2721 );
2722
2723 -- here's the delegated call to the old PL/SQL routine
2724 okl_streams_pub.lock_stream_elements(p_api_version,
2725 p_init_msg_list,
2726 x_return_status,
2727 x_msg_count,
2728 x_msg_data,
2729 ddp_selv_tbl);
2730
2731 -- copy data back from the local variables to OUT or IN-OUT args, if any
2732
2733
2734
2735
2736
2737 end;
2738
2739 procedure lock_stream_elements(p_api_version NUMBER
2740 , p_init_msg_list VARCHAR2
2741 , x_return_status out nocopy VARCHAR2
2742 , x_msg_count out nocopy NUMBER
2743 , x_msg_data out nocopy VARCHAR2
2744 , p5_a0 NUMBER := 0-1962.0724
2745 , p5_a1 NUMBER := 0-1962.0724
2746 , p5_a2 NUMBER := 0-1962.0724
2747 , p5_a3 NUMBER := 0-1962.0724
2748 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
2749 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
2750 , p5_a6 DATE := fnd_api.g_miss_date
2751 , p5_a7 NUMBER := 0-1962.0724
2752 , p5_a8 NUMBER := 0-1962.0724
2753 , p5_a9 NUMBER := 0-1962.0724
2754 , p5_a10 DATE := fnd_api.g_miss_date
2755 , p5_a11 NUMBER := 0-1962.0724
2756 , p5_a12 DATE := fnd_api.g_miss_date
2757 , p5_a13 NUMBER := 0-1962.0724
2758 , p5_a14 DATE := fnd_api.g_miss_date
2759 , p5_a15 NUMBER := 0-1962.0724
2760 , p5_a16 DATE := fnd_api.g_miss_date
2761 , p5_a17 NUMBER := 0-1962.0724
2762 , p5_a18 NUMBER := 0-1962.0724
2763 , p5_a19 NUMBER := 0-1962.0724
2764 , p5_a20 NUMBER := 0-1962.0724
2765 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
2766 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
2767 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
2768 , p5_a24 DATE := fnd_api.g_miss_date
2769 )
2770
2771 as
2772 ddp_selv_rec okl_streams_pub.selv_rec_type;
2773 ddindx binary_integer; indx binary_integer;
2774 begin
2775
2776 -- copy data to the local IN or IN-OUT args, if any
2777
2778
2779
2780
2781
2782 ddp_selv_rec.id := rosetta_g_miss_num_map(p5_a0);
2783 ddp_selv_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
2784 ddp_selv_rec.stm_id := rosetta_g_miss_num_map(p5_a2);
2785 ddp_selv_rec.amount := rosetta_g_miss_num_map(p5_a3);
2786 ddp_selv_rec.comments := p5_a4;
2787 ddp_selv_rec.accrued_yn := p5_a5;
2788 ddp_selv_rec.stream_element_date := rosetta_g_miss_date_in_map(p5_a6);
2789 ddp_selv_rec.program_id := rosetta_g_miss_num_map(p5_a7);
2790 ddp_selv_rec.request_id := rosetta_g_miss_num_map(p5_a8);
2791 ddp_selv_rec.program_application_id := rosetta_g_miss_num_map(p5_a9);
2792 ddp_selv_rec.program_update_date := rosetta_g_miss_date_in_map(p5_a10);
2793 ddp_selv_rec.se_line_number := rosetta_g_miss_num_map(p5_a11);
2794 ddp_selv_rec.date_billed := rosetta_g_miss_date_in_map(p5_a12);
2795 ddp_selv_rec.created_by := rosetta_g_miss_num_map(p5_a13);
2796 ddp_selv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a14);
2797 ddp_selv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a15);
2798 ddp_selv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a16);
2799 ddp_selv_rec.last_update_login := rosetta_g_miss_num_map(p5_a17);
2800 ddp_selv_rec.parent_index := rosetta_g_miss_num_map(p5_a18);
2801 ddp_selv_rec.sel_id := rosetta_g_miss_num_map(p5_a19);
2802 ddp_selv_rec.source_id := rosetta_g_miss_num_map(p5_a20);
2803 ddp_selv_rec.source_table := p5_a21;
2804 ddp_selv_rec.bill_adj_flag := p5_a22;
2805 ddp_selv_rec.accrual_adj_flag := p5_a23;
2806 ddp_selv_rec.date_disbursed := rosetta_g_miss_date_in_map(p5_a24);
2807
2808 -- here's the delegated call to the old PL/SQL routine
2809 okl_streams_pub.lock_stream_elements(p_api_version,
2810 p_init_msg_list,
2811 x_return_status,
2812 x_msg_count,
2813 x_msg_data,
2814 ddp_selv_rec);
2815
2816 -- copy data back from the local variables to OUT or IN-OUT args, if any
2817
2818
2819
2820
2821
2822 end;
2823
2824 procedure update_stream_elements(p_api_version NUMBER
2825 , p_init_msg_list VARCHAR2
2826 , x_return_status out nocopy VARCHAR2
2827 , x_msg_count out nocopy NUMBER
2828 , x_msg_data out nocopy VARCHAR2
2829 , p5_a0 JTF_NUMBER_TABLE
2830 , p5_a1 JTF_NUMBER_TABLE
2831 , p5_a2 JTF_NUMBER_TABLE
2832 , p5_a3 JTF_NUMBER_TABLE
2833 , p5_a4 JTF_VARCHAR2_TABLE_2000
2834 , p5_a5 JTF_VARCHAR2_TABLE_100
2835 , p5_a6 JTF_DATE_TABLE
2836 , p5_a7 JTF_NUMBER_TABLE
2837 , p5_a8 JTF_NUMBER_TABLE
2838 , p5_a9 JTF_NUMBER_TABLE
2839 , p5_a10 JTF_DATE_TABLE
2840 , p5_a11 JTF_NUMBER_TABLE
2841 , p5_a12 JTF_DATE_TABLE
2842 , p5_a13 JTF_NUMBER_TABLE
2843 , p5_a14 JTF_DATE_TABLE
2844 , p5_a15 JTF_NUMBER_TABLE
2845 , p5_a16 JTF_DATE_TABLE
2846 , p5_a17 JTF_NUMBER_TABLE
2847 , p5_a18 JTF_NUMBER_TABLE
2848 , p5_a19 JTF_NUMBER_TABLE
2849 , p5_a20 JTF_NUMBER_TABLE
2850 , p5_a21 JTF_VARCHAR2_TABLE_100
2851 , p5_a22 JTF_VARCHAR2_TABLE_100
2852 , p5_a23 JTF_VARCHAR2_TABLE_100
2853 , p5_a24 JTF_DATE_TABLE
2854 , p6_a0 out nocopy JTF_NUMBER_TABLE
2855 , p6_a1 out nocopy JTF_NUMBER_TABLE
2856 , p6_a2 out nocopy JTF_NUMBER_TABLE
2857 , p6_a3 out nocopy JTF_NUMBER_TABLE
2858 , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
2859 , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
2860 , p6_a6 out nocopy JTF_DATE_TABLE
2861 , p6_a7 out nocopy JTF_NUMBER_TABLE
2862 , p6_a8 out nocopy JTF_NUMBER_TABLE
2863 , p6_a9 out nocopy JTF_NUMBER_TABLE
2864 , p6_a10 out nocopy JTF_DATE_TABLE
2865 , p6_a11 out nocopy JTF_NUMBER_TABLE
2866 , p6_a12 out nocopy JTF_DATE_TABLE
2867 , p6_a13 out nocopy JTF_NUMBER_TABLE
2868 , p6_a14 out nocopy JTF_DATE_TABLE
2869 , p6_a15 out nocopy JTF_NUMBER_TABLE
2870 , p6_a16 out nocopy JTF_DATE_TABLE
2871 , p6_a17 out nocopy JTF_NUMBER_TABLE
2872 , p6_a18 out nocopy JTF_NUMBER_TABLE
2873 , p6_a19 out nocopy JTF_NUMBER_TABLE
2874 , p6_a20 out nocopy JTF_NUMBER_TABLE
2875 , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
2876 , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
2877 , p6_a23 out nocopy JTF_VARCHAR2_TABLE_100
2878 , p6_a24 out nocopy JTF_DATE_TABLE
2879 )
2880
2881 as
2882 ddp_selv_tbl okl_streams_pub.selv_tbl_type;
2883 ddx_selv_tbl okl_streams_pub.selv_tbl_type;
2884 ddindx binary_integer; indx binary_integer;
2885 begin
2886
2887 -- copy data to the local IN or IN-OUT args, if any
2888
2889
2890
2891
2892
2893 okl_sel_pvt_w.rosetta_table_copy_in_p5(ddp_selv_tbl, p5_a0
2894 , p5_a1
2895 , p5_a2
2896 , p5_a3
2897 , p5_a4
2898 , p5_a5
2899 , p5_a6
2900 , p5_a7
2901 , p5_a8
2902 , p5_a9
2903 , p5_a10
2904 , p5_a11
2905 , p5_a12
2906 , p5_a13
2907 , p5_a14
2908 , p5_a15
2909 , p5_a16
2910 , p5_a17
2911 , p5_a18
2912 , p5_a19
2913 , p5_a20
2914 , p5_a21
2915 , p5_a22
2916 , p5_a23
2917 , p5_a24
2918 );
2919
2920
2921 -- here's the delegated call to the old PL/SQL routine
2922 okl_streams_pub.update_stream_elements(p_api_version,
2923 p_init_msg_list,
2924 x_return_status,
2925 x_msg_count,
2926 x_msg_data,
2927 ddp_selv_tbl,
2928 ddx_selv_tbl);
2929
2930 -- copy data back from the local variables to OUT or IN-OUT args, if any
2931
2932
2933
2934
2935
2936
2937 okl_sel_pvt_w.rosetta_table_copy_out_p5(ddx_selv_tbl, p6_a0
2938 , p6_a1
2939 , p6_a2
2940 , p6_a3
2941 , p6_a4
2942 , p6_a5
2943 , p6_a6
2944 , p6_a7
2945 , p6_a8
2946 , p6_a9
2947 , p6_a10
2948 , p6_a11
2949 , p6_a12
2950 , p6_a13
2951 , p6_a14
2952 , p6_a15
2953 , p6_a16
2954 , p6_a17
2955 , p6_a18
2956 , p6_a19
2957 , p6_a20
2958 , p6_a21
2959 , p6_a22
2960 , p6_a23
2961 , p6_a24
2962 );
2963 end;
2964
2965 procedure update_stream_elements(p_api_version NUMBER
2966 , p_init_msg_list VARCHAR2
2967 , x_return_status out nocopy VARCHAR2
2968 , x_msg_count out nocopy NUMBER
2969 , x_msg_data out nocopy VARCHAR2
2970 , p6_a0 out nocopy NUMBER
2971 , p6_a1 out nocopy NUMBER
2972 , p6_a2 out nocopy NUMBER
2973 , p6_a3 out nocopy NUMBER
2974 , p6_a4 out nocopy VARCHAR2
2975 , p6_a5 out nocopy VARCHAR2
2976 , p6_a6 out nocopy DATE
2977 , p6_a7 out nocopy NUMBER
2978 , p6_a8 out nocopy NUMBER
2979 , p6_a9 out nocopy NUMBER
2980 , p6_a10 out nocopy DATE
2981 , p6_a11 out nocopy NUMBER
2982 , p6_a12 out nocopy DATE
2983 , p6_a13 out nocopy NUMBER
2984 , p6_a14 out nocopy DATE
2985 , p6_a15 out nocopy NUMBER
2986 , p6_a16 out nocopy DATE
2987 , p6_a17 out nocopy NUMBER
2988 , p6_a18 out nocopy NUMBER
2989 , p6_a19 out nocopy NUMBER
2990 , p6_a20 out nocopy NUMBER
2991 , p6_a21 out nocopy VARCHAR2
2992 , p6_a22 out nocopy VARCHAR2
2993 , p6_a23 out nocopy VARCHAR2
2994 , p6_a24 out nocopy DATE
2995 , p5_a0 NUMBER := 0-1962.0724
2996 , p5_a1 NUMBER := 0-1962.0724
2997 , p5_a2 NUMBER := 0-1962.0724
2998 , p5_a3 NUMBER := 0-1962.0724
2999 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
3000 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
3001 , p5_a6 DATE := fnd_api.g_miss_date
3002 , p5_a7 NUMBER := 0-1962.0724
3003 , p5_a8 NUMBER := 0-1962.0724
3004 , p5_a9 NUMBER := 0-1962.0724
3005 , p5_a10 DATE := fnd_api.g_miss_date
3006 , p5_a11 NUMBER := 0-1962.0724
3007 , p5_a12 DATE := fnd_api.g_miss_date
3008 , p5_a13 NUMBER := 0-1962.0724
3009 , p5_a14 DATE := fnd_api.g_miss_date
3010 , p5_a15 NUMBER := 0-1962.0724
3011 , p5_a16 DATE := fnd_api.g_miss_date
3012 , p5_a17 NUMBER := 0-1962.0724
3013 , p5_a18 NUMBER := 0-1962.0724
3014 , p5_a19 NUMBER := 0-1962.0724
3015 , p5_a20 NUMBER := 0-1962.0724
3016 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
3017 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
3018 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
3019 , p5_a24 DATE := fnd_api.g_miss_date
3020 )
3021
3022 as
3023 ddp_selv_rec okl_streams_pub.selv_rec_type;
3024 ddx_selv_rec okl_streams_pub.selv_rec_type;
3025 ddindx binary_integer; indx binary_integer;
3026 begin
3027
3028 -- copy data to the local IN or IN-OUT args, if any
3029
3030
3031
3032
3033
3034 ddp_selv_rec.id := rosetta_g_miss_num_map(p5_a0);
3035 ddp_selv_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
3036 ddp_selv_rec.stm_id := rosetta_g_miss_num_map(p5_a2);
3037 ddp_selv_rec.amount := rosetta_g_miss_num_map(p5_a3);
3038 ddp_selv_rec.comments := p5_a4;
3039 ddp_selv_rec.accrued_yn := p5_a5;
3040 ddp_selv_rec.stream_element_date := rosetta_g_miss_date_in_map(p5_a6);
3041 ddp_selv_rec.program_id := rosetta_g_miss_num_map(p5_a7);
3042 ddp_selv_rec.request_id := rosetta_g_miss_num_map(p5_a8);
3043 ddp_selv_rec.program_application_id := rosetta_g_miss_num_map(p5_a9);
3044 ddp_selv_rec.program_update_date := rosetta_g_miss_date_in_map(p5_a10);
3045 ddp_selv_rec.se_line_number := rosetta_g_miss_num_map(p5_a11);
3046 ddp_selv_rec.date_billed := rosetta_g_miss_date_in_map(p5_a12);
3047 ddp_selv_rec.created_by := rosetta_g_miss_num_map(p5_a13);
3048 ddp_selv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a14);
3049 ddp_selv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a15);
3050 ddp_selv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a16);
3051 ddp_selv_rec.last_update_login := rosetta_g_miss_num_map(p5_a17);
3052 ddp_selv_rec.parent_index := rosetta_g_miss_num_map(p5_a18);
3053 ddp_selv_rec.sel_id := rosetta_g_miss_num_map(p5_a19);
3054 ddp_selv_rec.source_id := rosetta_g_miss_num_map(p5_a20);
3055 ddp_selv_rec.source_table := p5_a21;
3056 ddp_selv_rec.bill_adj_flag := p5_a22;
3057 ddp_selv_rec.accrual_adj_flag := p5_a23;
3058 ddp_selv_rec.date_disbursed := rosetta_g_miss_date_in_map(p5_a24);
3059
3060
3061 -- here's the delegated call to the old PL/SQL routine
3062 okl_streams_pub.update_stream_elements(p_api_version,
3063 p_init_msg_list,
3064 x_return_status,
3065 x_msg_count,
3066 x_msg_data,
3067 ddp_selv_rec,
3068 ddx_selv_rec);
3069
3070 -- copy data back from the local variables to OUT or IN-OUT args, if any
3071
3072
3073
3074
3075
3076
3077 p6_a0 := rosetta_g_miss_num_map(ddx_selv_rec.id);
3078 p6_a1 := rosetta_g_miss_num_map(ddx_selv_rec.object_version_number);
3079 p6_a2 := rosetta_g_miss_num_map(ddx_selv_rec.stm_id);
3080 p6_a3 := rosetta_g_miss_num_map(ddx_selv_rec.amount);
3081 p6_a4 := ddx_selv_rec.comments;
3082 p6_a5 := ddx_selv_rec.accrued_yn;
3083 p6_a6 := ddx_selv_rec.stream_element_date;
3084 p6_a7 := rosetta_g_miss_num_map(ddx_selv_rec.program_id);
3085 p6_a8 := rosetta_g_miss_num_map(ddx_selv_rec.request_id);
3086 p6_a9 := rosetta_g_miss_num_map(ddx_selv_rec.program_application_id);
3087 p6_a10 := ddx_selv_rec.program_update_date;
3088 p6_a11 := rosetta_g_miss_num_map(ddx_selv_rec.se_line_number);
3089 p6_a12 := ddx_selv_rec.date_billed;
3090 p6_a13 := rosetta_g_miss_num_map(ddx_selv_rec.created_by);
3091 p6_a14 := ddx_selv_rec.creation_date;
3092 p6_a15 := rosetta_g_miss_num_map(ddx_selv_rec.last_updated_by);
3093 p6_a16 := ddx_selv_rec.last_update_date;
3094 p6_a17 := rosetta_g_miss_num_map(ddx_selv_rec.last_update_login);
3095 p6_a18 := rosetta_g_miss_num_map(ddx_selv_rec.parent_index);
3096 p6_a19 := rosetta_g_miss_num_map(ddx_selv_rec.sel_id);
3097 p6_a20 := rosetta_g_miss_num_map(ddx_selv_rec.source_id);
3098 p6_a21 := ddx_selv_rec.source_table;
3099 p6_a22 := ddx_selv_rec.bill_adj_flag;
3100 p6_a23 := ddx_selv_rec.accrual_adj_flag;
3101 p6_a24 := ddx_selv_rec.date_disbursed;
3102 end;
3103
3104 procedure delete_stream_elements(p_api_version NUMBER
3105 , p_init_msg_list VARCHAR2
3106 , x_return_status out nocopy VARCHAR2
3107 , x_msg_count out nocopy NUMBER
3108 , x_msg_data out nocopy VARCHAR2
3109 , p5_a0 JTF_NUMBER_TABLE
3110 , p5_a1 JTF_NUMBER_TABLE
3111 , p5_a2 JTF_NUMBER_TABLE
3112 , p5_a3 JTF_NUMBER_TABLE
3113 , p5_a4 JTF_VARCHAR2_TABLE_2000
3114 , p5_a5 JTF_VARCHAR2_TABLE_100
3115 , p5_a6 JTF_DATE_TABLE
3116 , p5_a7 JTF_NUMBER_TABLE
3117 , p5_a8 JTF_NUMBER_TABLE
3118 , p5_a9 JTF_NUMBER_TABLE
3119 , p5_a10 JTF_DATE_TABLE
3120 , p5_a11 JTF_NUMBER_TABLE
3121 , p5_a12 JTF_DATE_TABLE
3122 , p5_a13 JTF_NUMBER_TABLE
3123 , p5_a14 JTF_DATE_TABLE
3124 , p5_a15 JTF_NUMBER_TABLE
3125 , p5_a16 JTF_DATE_TABLE
3126 , p5_a17 JTF_NUMBER_TABLE
3127 , p5_a18 JTF_NUMBER_TABLE
3128 , p5_a19 JTF_NUMBER_TABLE
3129 , p5_a20 JTF_NUMBER_TABLE
3130 , p5_a21 JTF_VARCHAR2_TABLE_100
3131 , p5_a22 JTF_VARCHAR2_TABLE_100
3132 , p5_a23 JTF_VARCHAR2_TABLE_100
3133 , p5_a24 JTF_DATE_TABLE
3134 )
3135
3136 as
3137 ddp_selv_tbl okl_streams_pub.selv_tbl_type;
3138 ddindx binary_integer; indx binary_integer;
3139 begin
3140
3141 -- copy data to the local IN or IN-OUT args, if any
3142
3143
3144
3145
3146
3147 okl_sel_pvt_w.rosetta_table_copy_in_p5(ddp_selv_tbl, p5_a0
3148 , p5_a1
3149 , p5_a2
3150 , p5_a3
3151 , p5_a4
3152 , p5_a5
3153 , p5_a6
3154 , p5_a7
3155 , p5_a8
3156 , p5_a9
3157 , p5_a10
3158 , p5_a11
3159 , p5_a12
3160 , p5_a13
3161 , p5_a14
3162 , p5_a15
3163 , p5_a16
3164 , p5_a17
3165 , p5_a18
3166 , p5_a19
3167 , p5_a20
3168 , p5_a21
3169 , p5_a22
3170 , p5_a23
3171 , p5_a24
3172 );
3173
3174 -- here's the delegated call to the old PL/SQL routine
3175 okl_streams_pub.delete_stream_elements(p_api_version,
3176 p_init_msg_list,
3177 x_return_status,
3178 x_msg_count,
3179 x_msg_data,
3180 ddp_selv_tbl);
3181
3182 -- copy data back from the local variables to OUT or IN-OUT args, if any
3183
3184
3185
3186
3187
3188 end;
3189
3190 procedure delete_stream_elements(p_api_version NUMBER
3191 , p_init_msg_list VARCHAR2
3192 , x_return_status out nocopy VARCHAR2
3193 , x_msg_count out nocopy NUMBER
3194 , x_msg_data out nocopy VARCHAR2
3195 , p5_a0 NUMBER := 0-1962.0724
3196 , p5_a1 NUMBER := 0-1962.0724
3197 , p5_a2 NUMBER := 0-1962.0724
3198 , p5_a3 NUMBER := 0-1962.0724
3199 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
3200 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
3201 , p5_a6 DATE := fnd_api.g_miss_date
3202 , p5_a7 NUMBER := 0-1962.0724
3203 , p5_a8 NUMBER := 0-1962.0724
3204 , p5_a9 NUMBER := 0-1962.0724
3205 , p5_a10 DATE := fnd_api.g_miss_date
3206 , p5_a11 NUMBER := 0-1962.0724
3207 , p5_a12 DATE := fnd_api.g_miss_date
3208 , p5_a13 NUMBER := 0-1962.0724
3209 , p5_a14 DATE := fnd_api.g_miss_date
3210 , p5_a15 NUMBER := 0-1962.0724
3211 , p5_a16 DATE := fnd_api.g_miss_date
3212 , p5_a17 NUMBER := 0-1962.0724
3213 , p5_a18 NUMBER := 0-1962.0724
3214 , p5_a19 NUMBER := 0-1962.0724
3215 , p5_a20 NUMBER := 0-1962.0724
3216 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
3217 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
3218 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
3219 , p5_a24 DATE := fnd_api.g_miss_date
3220 )
3221
3222 as
3223 ddp_selv_rec okl_streams_pub.selv_rec_type;
3224 ddindx binary_integer; indx binary_integer;
3225 begin
3226
3227 -- copy data to the local IN or IN-OUT args, if any
3228
3229
3230
3231
3232
3233 ddp_selv_rec.id := rosetta_g_miss_num_map(p5_a0);
3234 ddp_selv_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
3235 ddp_selv_rec.stm_id := rosetta_g_miss_num_map(p5_a2);
3236 ddp_selv_rec.amount := rosetta_g_miss_num_map(p5_a3);
3237 ddp_selv_rec.comments := p5_a4;
3238 ddp_selv_rec.accrued_yn := p5_a5;
3239 ddp_selv_rec.stream_element_date := rosetta_g_miss_date_in_map(p5_a6);
3240 ddp_selv_rec.program_id := rosetta_g_miss_num_map(p5_a7);
3241 ddp_selv_rec.request_id := rosetta_g_miss_num_map(p5_a8);
3242 ddp_selv_rec.program_application_id := rosetta_g_miss_num_map(p5_a9);
3243 ddp_selv_rec.program_update_date := rosetta_g_miss_date_in_map(p5_a10);
3244 ddp_selv_rec.se_line_number := rosetta_g_miss_num_map(p5_a11);
3245 ddp_selv_rec.date_billed := rosetta_g_miss_date_in_map(p5_a12);
3246 ddp_selv_rec.created_by := rosetta_g_miss_num_map(p5_a13);
3247 ddp_selv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a14);
3248 ddp_selv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a15);
3249 ddp_selv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a16);
3250 ddp_selv_rec.last_update_login := rosetta_g_miss_num_map(p5_a17);
3251 ddp_selv_rec.parent_index := rosetta_g_miss_num_map(p5_a18);
3252 ddp_selv_rec.sel_id := rosetta_g_miss_num_map(p5_a19);
3253 ddp_selv_rec.source_id := rosetta_g_miss_num_map(p5_a20);
3254 ddp_selv_rec.source_table := p5_a21;
3255 ddp_selv_rec.bill_adj_flag := p5_a22;
3256 ddp_selv_rec.accrual_adj_flag := p5_a23;
3257 ddp_selv_rec.date_disbursed := rosetta_g_miss_date_in_map(p5_a24);
3258
3259 -- here's the delegated call to the old PL/SQL routine
3260 okl_streams_pub.delete_stream_elements(p_api_version,
3261 p_init_msg_list,
3262 x_return_status,
3263 x_msg_count,
3264 x_msg_data,
3265 ddp_selv_rec);
3266
3267 -- copy data back from the local variables to OUT or IN-OUT args, if any
3268
3269
3270
3271
3272
3273 end;
3274
3275 procedure validate_stream_elements(p_api_version NUMBER
3276 , p_init_msg_list VARCHAR2
3277 , x_return_status out nocopy VARCHAR2
3278 , x_msg_count out nocopy NUMBER
3279 , x_msg_data out nocopy VARCHAR2
3280 , p5_a0 JTF_NUMBER_TABLE
3281 , p5_a1 JTF_NUMBER_TABLE
3282 , p5_a2 JTF_NUMBER_TABLE
3283 , p5_a3 JTF_NUMBER_TABLE
3284 , p5_a4 JTF_VARCHAR2_TABLE_2000
3285 , p5_a5 JTF_VARCHAR2_TABLE_100
3286 , p5_a6 JTF_DATE_TABLE
3287 , p5_a7 JTF_NUMBER_TABLE
3288 , p5_a8 JTF_NUMBER_TABLE
3289 , p5_a9 JTF_NUMBER_TABLE
3290 , p5_a10 JTF_DATE_TABLE
3291 , p5_a11 JTF_NUMBER_TABLE
3292 , p5_a12 JTF_DATE_TABLE
3293 , p5_a13 JTF_NUMBER_TABLE
3294 , p5_a14 JTF_DATE_TABLE
3295 , p5_a15 JTF_NUMBER_TABLE
3296 , p5_a16 JTF_DATE_TABLE
3297 , p5_a17 JTF_NUMBER_TABLE
3298 , p5_a18 JTF_NUMBER_TABLE
3299 , p5_a19 JTF_NUMBER_TABLE
3300 , p5_a20 JTF_NUMBER_TABLE
3301 , p5_a21 JTF_VARCHAR2_TABLE_100
3302 , p5_a22 JTF_VARCHAR2_TABLE_100
3303 , p5_a23 JTF_VARCHAR2_TABLE_100
3304 , p5_a24 JTF_DATE_TABLE
3305 )
3306
3307 as
3308 ddp_selv_tbl okl_streams_pub.selv_tbl_type;
3309 ddindx binary_integer; indx binary_integer;
3310 begin
3311
3312 -- copy data to the local IN or IN-OUT args, if any
3313
3314
3315
3316
3317
3318 okl_sel_pvt_w.rosetta_table_copy_in_p5(ddp_selv_tbl, p5_a0
3319 , p5_a1
3320 , p5_a2
3321 , p5_a3
3322 , p5_a4
3323 , p5_a5
3324 , p5_a6
3325 , p5_a7
3326 , p5_a8
3327 , p5_a9
3328 , p5_a10
3329 , p5_a11
3330 , p5_a12
3331 , p5_a13
3332 , p5_a14
3333 , p5_a15
3334 , p5_a16
3335 , p5_a17
3336 , p5_a18
3337 , p5_a19
3338 , p5_a20
3339 , p5_a21
3340 , p5_a22
3341 , p5_a23
3342 , p5_a24
3343 );
3344
3345 -- here's the delegated call to the old PL/SQL routine
3346 okl_streams_pub.validate_stream_elements(p_api_version,
3347 p_init_msg_list,
3348 x_return_status,
3349 x_msg_count,
3350 x_msg_data,
3351 ddp_selv_tbl);
3352
3353 -- copy data back from the local variables to OUT or IN-OUT args, if any
3354
3355
3356
3357
3358
3359 end;
3360
3361 procedure validate_stream_elements(p_api_version NUMBER
3362 , p_init_msg_list VARCHAR2
3363 , x_return_status out nocopy VARCHAR2
3364 , x_msg_count out nocopy NUMBER
3365 , x_msg_data out nocopy VARCHAR2
3366 , p5_a0 NUMBER := 0-1962.0724
3367 , p5_a1 NUMBER := 0-1962.0724
3368 , p5_a2 NUMBER := 0-1962.0724
3369 , p5_a3 NUMBER := 0-1962.0724
3370 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
3371 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
3372 , p5_a6 DATE := fnd_api.g_miss_date
3373 , p5_a7 NUMBER := 0-1962.0724
3374 , p5_a8 NUMBER := 0-1962.0724
3375 , p5_a9 NUMBER := 0-1962.0724
3376 , p5_a10 DATE := fnd_api.g_miss_date
3377 , p5_a11 NUMBER := 0-1962.0724
3378 , p5_a12 DATE := fnd_api.g_miss_date
3379 , p5_a13 NUMBER := 0-1962.0724
3380 , p5_a14 DATE := fnd_api.g_miss_date
3381 , p5_a15 NUMBER := 0-1962.0724
3382 , p5_a16 DATE := fnd_api.g_miss_date
3383 , p5_a17 NUMBER := 0-1962.0724
3384 , p5_a18 NUMBER := 0-1962.0724
3385 , p5_a19 NUMBER := 0-1962.0724
3386 , p5_a20 NUMBER := 0-1962.0724
3387 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
3388 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
3389 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
3390 , p5_a24 DATE := fnd_api.g_miss_date
3391 )
3392
3393 as
3394 ddp_selv_rec okl_streams_pub.selv_rec_type;
3395 ddindx binary_integer; indx binary_integer;
3396 begin
3397
3398 -- copy data to the local IN or IN-OUT args, if any
3399
3400
3401
3402
3403
3404 ddp_selv_rec.id := rosetta_g_miss_num_map(p5_a0);
3405 ddp_selv_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
3406 ddp_selv_rec.stm_id := rosetta_g_miss_num_map(p5_a2);
3407 ddp_selv_rec.amount := rosetta_g_miss_num_map(p5_a3);
3408 ddp_selv_rec.comments := p5_a4;
3409 ddp_selv_rec.accrued_yn := p5_a5;
3410 ddp_selv_rec.stream_element_date := rosetta_g_miss_date_in_map(p5_a6);
3411 ddp_selv_rec.program_id := rosetta_g_miss_num_map(p5_a7);
3412 ddp_selv_rec.request_id := rosetta_g_miss_num_map(p5_a8);
3413 ddp_selv_rec.program_application_id := rosetta_g_miss_num_map(p5_a9);
3414 ddp_selv_rec.program_update_date := rosetta_g_miss_date_in_map(p5_a10);
3415 ddp_selv_rec.se_line_number := rosetta_g_miss_num_map(p5_a11);
3416 ddp_selv_rec.date_billed := rosetta_g_miss_date_in_map(p5_a12);
3417 ddp_selv_rec.created_by := rosetta_g_miss_num_map(p5_a13);
3418 ddp_selv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a14);
3419 ddp_selv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a15);
3420 ddp_selv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a16);
3421 ddp_selv_rec.last_update_login := rosetta_g_miss_num_map(p5_a17);
3422 ddp_selv_rec.parent_index := rosetta_g_miss_num_map(p5_a18);
3423 ddp_selv_rec.sel_id := rosetta_g_miss_num_map(p5_a19);
3424 ddp_selv_rec.source_id := rosetta_g_miss_num_map(p5_a20);
3425 ddp_selv_rec.source_table := p5_a21;
3426 ddp_selv_rec.bill_adj_flag := p5_a22;
3427 ddp_selv_rec.accrual_adj_flag := p5_a23;
3428 ddp_selv_rec.date_disbursed := rosetta_g_miss_date_in_map(p5_a24);
3429
3430 -- here's the delegated call to the old PL/SQL routine
3431 okl_streams_pub.validate_stream_elements(p_api_version,
3432 p_init_msg_list,
3433 x_return_status,
3434 x_msg_count,
3435 x_msg_data,
3436 ddp_selv_rec);
3437
3438 -- copy data back from the local variables to OUT or IN-OUT args, if any
3439
3440
3441
3442
3443
3444 end;
3445
3446 end okl_streams_pub_w;