[Home] [Help]
PACKAGE BODY: APPS.OKL_STRM_TYPE_PUB_W
Source
1 package body okl_strm_type_pub_w as
2 /* $Header: OKLUSTYB.pls 120.3 2008/01/29 17:23:14 gkadarka ship $ */
3 rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
4 rosetta_g_miss_date date := to_date('01/01/-4712', 'MM/DD/SYYYY');
5
6 -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
7 function rosetta_g_miss_date_in_map(d date) return date as
8 begin
9 if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
10 return d;
11 end;
12
13 function rosetta_g_miss_num_map(n number) return number as
14 a number := fnd_api.g_miss_num;
15 b number := 0-1962.0724;
16 begin
17 if n=a then return b; end if;
18 if n=b then return a; end if;
19 return n;
20 end;
21
22 procedure insert_strm_type(p_api_version NUMBER
23 , p_init_msg_list VARCHAR2
24 , x_return_status out nocopy VARCHAR2
25 , x_msg_count out nocopy NUMBER
26 , x_msg_data out nocopy VARCHAR2
27 , p6_a0 out nocopy NUMBER
28 , p6_a1 out nocopy VARCHAR2
29 , p6_a2 out nocopy VARCHAR2
30 , p6_a3 out nocopy NUMBER
31 , p6_a4 out nocopy VARCHAR2
32 , p6_a5 out nocopy VARCHAR2
33 , p6_a6 out nocopy VARCHAR2
34 , p6_a7 out nocopy VARCHAR2
35 , p6_a8 out nocopy DATE
36 , p6_a9 out nocopy DATE
37 , p6_a10 out nocopy VARCHAR2
38 , p6_a11 out nocopy VARCHAR2
39 , p6_a12 out nocopy VARCHAR2
40 , p6_a13 out nocopy VARCHAR2
41 , p6_a14 out nocopy VARCHAR2
42 , p6_a15 out nocopy VARCHAR2
43 , p6_a16 out nocopy VARCHAR2
44 , p6_a17 out nocopy VARCHAR2
45 , p6_a18 out nocopy VARCHAR2
46 , p6_a19 out nocopy VARCHAR2
47 , p6_a20 out nocopy VARCHAR2
48 , p6_a21 out nocopy VARCHAR2
49 , p6_a22 out nocopy VARCHAR2
50 , p6_a23 out nocopy VARCHAR2
51 , p6_a24 out nocopy VARCHAR2
52 , p6_a25 out nocopy VARCHAR2
53 , p6_a26 out nocopy VARCHAR2
54 , p6_a27 out nocopy VARCHAR2
55 , p6_a28 out nocopy VARCHAR2
56 , p6_a29 out nocopy VARCHAR2
57 , p6_a30 out nocopy VARCHAR2
58 , p6_a31 out nocopy VARCHAR2
59 , p6_a32 out nocopy VARCHAR2
60 , p6_a33 out nocopy VARCHAR2
61 , p6_a34 out nocopy VARCHAR2
62 , p6_a35 out nocopy VARCHAR2
63 , p6_a36 out nocopy NUMBER
64 , p6_a37 out nocopy DATE
65 , p6_a38 out nocopy NUMBER
66 , p6_a39 out nocopy DATE
67 , p6_a40 out nocopy NUMBER
68 , p6_a41 out nocopy VARCHAR2
69 , p6_a42 out nocopy VARCHAR2
70 , p6_a43 out nocopy VARCHAR2
71 , p6_a44 out nocopy NUMBER
72 , p5_a0 NUMBER := 0-1962.0724
73 , p5_a1 VARCHAR2 := fnd_api.g_miss_char
74 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
75 , p5_a3 NUMBER := 0-1962.0724
76 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
77 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
78 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
79 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
80 , p5_a8 DATE := fnd_api.g_miss_date
81 , p5_a9 DATE := fnd_api.g_miss_date
82 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
83 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
84 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
85 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
86 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
87 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
88 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
89 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
90 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
91 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
92 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
93 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
94 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
95 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
96 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
97 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
98 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
99 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
100 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
101 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
102 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
103 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
104 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
105 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
106 , p5_a34 VARCHAR2 := fnd_api.g_miss_char
107 , p5_a35 VARCHAR2 := fnd_api.g_miss_char
108 , p5_a36 NUMBER := 0-1962.0724
109 , p5_a37 DATE := fnd_api.g_miss_date
110 , p5_a38 NUMBER := 0-1962.0724
111 , p5_a39 DATE := fnd_api.g_miss_date
112 , p5_a40 NUMBER := 0-1962.0724
113 , p5_a41 VARCHAR2 := fnd_api.g_miss_char
114 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
115 , p5_a43 VARCHAR2 := fnd_api.g_miss_char
116 , p5_a44 NUMBER := 0-1962.0724
117 )
118
119 as
120 ddp_styv_rec okl_strm_type_pub.styv_rec_type;
121 ddx_styv_rec okl_strm_type_pub.styv_rec_type;
122 ddindx binary_integer; indx binary_integer;
123 begin
124
125 -- copy data to the local IN or IN-OUT args, if any
126
127
128
129
130
131 ddp_styv_rec.id := rosetta_g_miss_num_map(p5_a0);
132 ddp_styv_rec.name := p5_a1;
133 ddp_styv_rec.version := p5_a2;
134 ddp_styv_rec.object_version_number := rosetta_g_miss_num_map(p5_a3);
135 ddp_styv_rec.code := p5_a4;
136 ddp_styv_rec.sfwt_flag := p5_a5;
137 ddp_styv_rec.stream_type_scope := p5_a6;
138 ddp_styv_rec.description := p5_a7;
139 ddp_styv_rec.start_date := rosetta_g_miss_date_in_map(p5_a8);
140 ddp_styv_rec.end_date := rosetta_g_miss_date_in_map(p5_a9);
141 ddp_styv_rec.billable_yn := p5_a10;
142 ddp_styv_rec.taxable_default_yn := p5_a11;
143 ddp_styv_rec.customization_level := p5_a12;
144 ddp_styv_rec.stream_type_class := p5_a13;
145 ddp_styv_rec.stream_type_subclass := p5_a14;
146 ddp_styv_rec.accrual_yn := p5_a15;
147 ddp_styv_rec.capitalize_yn := p5_a16;
148 ddp_styv_rec.periodic_yn := p5_a17;
149 ddp_styv_rec.fundable_yn := p5_a18;
150 ddp_styv_rec.allocation_factor := p5_a19;
151 ddp_styv_rec.attribute_category := p5_a20;
152 ddp_styv_rec.attribute1 := p5_a21;
153 ddp_styv_rec.attribute2 := p5_a22;
154 ddp_styv_rec.attribute3 := p5_a23;
155 ddp_styv_rec.attribute4 := p5_a24;
156 ddp_styv_rec.attribute5 := p5_a25;
157 ddp_styv_rec.attribute6 := p5_a26;
158 ddp_styv_rec.attribute7 := p5_a27;
159 ddp_styv_rec.attribute8 := p5_a28;
160 ddp_styv_rec.attribute9 := p5_a29;
161 ddp_styv_rec.attribute10 := p5_a30;
162 ddp_styv_rec.attribute11 := p5_a31;
163 ddp_styv_rec.attribute12 := p5_a32;
164 ddp_styv_rec.attribute13 := p5_a33;
165 ddp_styv_rec.attribute14 := p5_a34;
166 ddp_styv_rec.attribute15 := p5_a35;
167 ddp_styv_rec.created_by := rosetta_g_miss_num_map(p5_a36);
168 ddp_styv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a37);
169 ddp_styv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a38);
170 ddp_styv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a39);
171 ddp_styv_rec.last_update_login := rosetta_g_miss_num_map(p5_a40);
172 ddp_styv_rec.stream_type_purpose := p5_a41;
173 ddp_styv_rec.contingency := p5_a42;
174 ddp_styv_rec.short_description := p5_a43;
175 ddp_styv_rec.contingency_id := rosetta_g_miss_num_map(p5_a44);
176
177
178 -- here's the delegated call to the old PL/SQL routine
179 okl_strm_type_pub.insert_strm_type(p_api_version,
180 p_init_msg_list,
181 x_return_status,
182 x_msg_count,
183 x_msg_data,
184 ddp_styv_rec,
185 ddx_styv_rec);
186
187 -- copy data back from the local variables to OUT or IN-OUT args, if any
188
189
190
191
192
193
194 p6_a0 := rosetta_g_miss_num_map(ddx_styv_rec.id);
195 p6_a1 := ddx_styv_rec.name;
196 p6_a2 := ddx_styv_rec.version;
197 p6_a3 := rosetta_g_miss_num_map(ddx_styv_rec.object_version_number);
198 p6_a4 := ddx_styv_rec.code;
199 p6_a5 := ddx_styv_rec.sfwt_flag;
200 p6_a6 := ddx_styv_rec.stream_type_scope;
201 p6_a7 := ddx_styv_rec.description;
202 p6_a8 := ddx_styv_rec.start_date;
203 p6_a9 := ddx_styv_rec.end_date;
204 p6_a10 := ddx_styv_rec.billable_yn;
205 p6_a11 := ddx_styv_rec.taxable_default_yn;
206 p6_a12 := ddx_styv_rec.customization_level;
207 p6_a13 := ddx_styv_rec.stream_type_class;
208 p6_a14 := ddx_styv_rec.stream_type_subclass;
209 p6_a15 := ddx_styv_rec.accrual_yn;
210 p6_a16 := ddx_styv_rec.capitalize_yn;
211 p6_a17 := ddx_styv_rec.periodic_yn;
212 p6_a18 := ddx_styv_rec.fundable_yn;
213 p6_a19 := ddx_styv_rec.allocation_factor;
214 p6_a20 := ddx_styv_rec.attribute_category;
215 p6_a21 := ddx_styv_rec.attribute1;
216 p6_a22 := ddx_styv_rec.attribute2;
217 p6_a23 := ddx_styv_rec.attribute3;
218 p6_a24 := ddx_styv_rec.attribute4;
219 p6_a25 := ddx_styv_rec.attribute5;
220 p6_a26 := ddx_styv_rec.attribute6;
221 p6_a27 := ddx_styv_rec.attribute7;
222 p6_a28 := ddx_styv_rec.attribute8;
223 p6_a29 := ddx_styv_rec.attribute9;
224 p6_a30 := ddx_styv_rec.attribute10;
225 p6_a31 := ddx_styv_rec.attribute11;
226 p6_a32 := ddx_styv_rec.attribute12;
227 p6_a33 := ddx_styv_rec.attribute13;
228 p6_a34 := ddx_styv_rec.attribute14;
229 p6_a35 := ddx_styv_rec.attribute15;
230 p6_a36 := rosetta_g_miss_num_map(ddx_styv_rec.created_by);
231 p6_a37 := ddx_styv_rec.creation_date;
232 p6_a38 := rosetta_g_miss_num_map(ddx_styv_rec.last_updated_by);
233 p6_a39 := ddx_styv_rec.last_update_date;
234 p6_a40 := rosetta_g_miss_num_map(ddx_styv_rec.last_update_login);
235 p6_a41 := ddx_styv_rec.stream_type_purpose;
236 p6_a42 := ddx_styv_rec.contingency;
237 p6_a43 := ddx_styv_rec.short_description;
238 p6_a44 := rosetta_g_miss_num_map(ddx_styv_rec.contingency_id);
239 end;
240
241 procedure insert_strm_type(p_api_version NUMBER
242 , p_init_msg_list VARCHAR2
243 , x_return_status out nocopy VARCHAR2
244 , x_msg_count out nocopy NUMBER
245 , x_msg_data out nocopy VARCHAR2
246 , p5_a0 JTF_NUMBER_TABLE
247 , p5_a1 JTF_VARCHAR2_TABLE_200
248 , p5_a2 JTF_VARCHAR2_TABLE_100
249 , p5_a3 JTF_NUMBER_TABLE
250 , p5_a4 JTF_VARCHAR2_TABLE_200
251 , p5_a5 JTF_VARCHAR2_TABLE_100
252 , p5_a6 JTF_VARCHAR2_TABLE_100
253 , p5_a7 JTF_VARCHAR2_TABLE_2000
254 , p5_a8 JTF_DATE_TABLE
255 , p5_a9 JTF_DATE_TABLE
256 , p5_a10 JTF_VARCHAR2_TABLE_100
257 , p5_a11 JTF_VARCHAR2_TABLE_100
258 , p5_a12 JTF_VARCHAR2_TABLE_100
259 , p5_a13 JTF_VARCHAR2_TABLE_100
260 , p5_a14 JTF_VARCHAR2_TABLE_100
261 , p5_a15 JTF_VARCHAR2_TABLE_100
262 , p5_a16 JTF_VARCHAR2_TABLE_100
263 , p5_a17 JTF_VARCHAR2_TABLE_100
264 , p5_a18 JTF_VARCHAR2_TABLE_100
265 , p5_a19 JTF_VARCHAR2_TABLE_100
266 , p5_a20 JTF_VARCHAR2_TABLE_100
267 , p5_a21 JTF_VARCHAR2_TABLE_500
268 , p5_a22 JTF_VARCHAR2_TABLE_500
269 , p5_a23 JTF_VARCHAR2_TABLE_500
270 , p5_a24 JTF_VARCHAR2_TABLE_500
271 , p5_a25 JTF_VARCHAR2_TABLE_500
272 , p5_a26 JTF_VARCHAR2_TABLE_500
273 , p5_a27 JTF_VARCHAR2_TABLE_500
274 , p5_a28 JTF_VARCHAR2_TABLE_500
275 , p5_a29 JTF_VARCHAR2_TABLE_500
276 , p5_a30 JTF_VARCHAR2_TABLE_500
277 , p5_a31 JTF_VARCHAR2_TABLE_500
278 , p5_a32 JTF_VARCHAR2_TABLE_500
279 , p5_a33 JTF_VARCHAR2_TABLE_500
280 , p5_a34 JTF_VARCHAR2_TABLE_500
281 , p5_a35 JTF_VARCHAR2_TABLE_500
282 , p5_a36 JTF_NUMBER_TABLE
283 , p5_a37 JTF_DATE_TABLE
284 , p5_a38 JTF_NUMBER_TABLE
285 , p5_a39 JTF_DATE_TABLE
286 , p5_a40 JTF_NUMBER_TABLE
287 , p5_a41 JTF_VARCHAR2_TABLE_100
288 , p5_a42 JTF_VARCHAR2_TABLE_100
289 , p5_a43 JTF_VARCHAR2_TABLE_600
290 , p5_a44 JTF_NUMBER_TABLE
291 , p6_a0 out nocopy JTF_NUMBER_TABLE
292 , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
293 , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
294 , p6_a3 out nocopy JTF_NUMBER_TABLE
295 , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
296 , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
297 , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
298 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_2000
299 , p6_a8 out nocopy JTF_DATE_TABLE
300 , p6_a9 out nocopy JTF_DATE_TABLE
301 , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
302 , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
303 , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
304 , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
305 , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
306 , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
307 , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
308 , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
309 , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
310 , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
311 , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
312 , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
313 , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
314 , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
315 , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
316 , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
317 , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
318 , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
319 , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
320 , p6_a29 out nocopy JTF_VARCHAR2_TABLE_500
321 , p6_a30 out nocopy JTF_VARCHAR2_TABLE_500
322 , p6_a31 out nocopy JTF_VARCHAR2_TABLE_500
323 , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
324 , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
325 , p6_a34 out nocopy JTF_VARCHAR2_TABLE_500
326 , p6_a35 out nocopy JTF_VARCHAR2_TABLE_500
327 , p6_a36 out nocopy JTF_NUMBER_TABLE
328 , p6_a37 out nocopy JTF_DATE_TABLE
329 , p6_a38 out nocopy JTF_NUMBER_TABLE
330 , p6_a39 out nocopy JTF_DATE_TABLE
331 , p6_a40 out nocopy JTF_NUMBER_TABLE
332 , p6_a41 out nocopy JTF_VARCHAR2_TABLE_100
333 , p6_a42 out nocopy JTF_VARCHAR2_TABLE_100
334 , p6_a43 out nocopy JTF_VARCHAR2_TABLE_600
335 , p6_a44 out nocopy JTF_NUMBER_TABLE
336 )
337
338 as
339 ddp_styv_tbl okl_strm_type_pub.styv_tbl_type;
340 ddx_styv_tbl okl_strm_type_pub.styv_tbl_type;
341 ddindx binary_integer; indx binary_integer;
342 begin
343
344 -- copy data to the local IN or IN-OUT args, if any
345
346
347
348
349
350 okl_sty_pvt_w.rosetta_table_copy_in_p8(ddp_styv_tbl, p5_a0
351 , p5_a1
352 , p5_a2
353 , p5_a3
354 , p5_a4
355 , p5_a5
356 , p5_a6
357 , p5_a7
358 , p5_a8
359 , p5_a9
360 , p5_a10
361 , p5_a11
362 , p5_a12
363 , p5_a13
364 , p5_a14
365 , p5_a15
366 , p5_a16
367 , p5_a17
368 , p5_a18
369 , p5_a19
370 , p5_a20
371 , p5_a21
372 , p5_a22
373 , p5_a23
374 , p5_a24
375 , p5_a25
376 , p5_a26
377 , p5_a27
378 , p5_a28
379 , p5_a29
380 , p5_a30
381 , p5_a31
382 , p5_a32
383 , p5_a33
384 , p5_a34
385 , p5_a35
386 , p5_a36
387 , p5_a37
388 , p5_a38
389 , p5_a39
390 , p5_a40
391 , p5_a41
392 , p5_a42
393 , p5_a43
394 , p5_a44
395 );
396
397
398 -- here's the delegated call to the old PL/SQL routine
399 okl_strm_type_pub.insert_strm_type(p_api_version,
400 p_init_msg_list,
401 x_return_status,
402 x_msg_count,
403 x_msg_data,
404 ddp_styv_tbl,
405 ddx_styv_tbl);
406
407 -- copy data back from the local variables to OUT or IN-OUT args, if any
408
409
410
411
412
413
414 okl_sty_pvt_w.rosetta_table_copy_out_p8(ddx_styv_tbl, p6_a0
415 , p6_a1
416 , p6_a2
417 , p6_a3
418 , p6_a4
419 , p6_a5
420 , p6_a6
421 , p6_a7
422 , p6_a8
423 , p6_a9
424 , p6_a10
425 , p6_a11
426 , p6_a12
427 , p6_a13
428 , p6_a14
429 , p6_a15
430 , p6_a16
431 , p6_a17
432 , p6_a18
433 , p6_a19
434 , p6_a20
435 , p6_a21
436 , p6_a22
437 , p6_a23
438 , p6_a24
439 , p6_a25
440 , p6_a26
441 , p6_a27
442 , p6_a28
443 , p6_a29
444 , p6_a30
445 , p6_a31
446 , p6_a32
447 , p6_a33
448 , p6_a34
449 , p6_a35
450 , p6_a36
451 , p6_a37
452 , p6_a38
453 , p6_a39
454 , p6_a40
455 , p6_a41
456 , p6_a42
457 , p6_a43
458 , p6_a44
459 );
460 end;
461
462 procedure lock_strm_type(p_api_version NUMBER
463 , p_init_msg_list VARCHAR2
464 , x_return_status out nocopy VARCHAR2
465 , x_msg_count out nocopy NUMBER
466 , x_msg_data out nocopy VARCHAR2
467 , p5_a0 NUMBER := 0-1962.0724
468 , p5_a1 VARCHAR2 := fnd_api.g_miss_char
469 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
470 , p5_a3 NUMBER := 0-1962.0724
471 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
472 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
473 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
474 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
475 , p5_a8 DATE := fnd_api.g_miss_date
476 , p5_a9 DATE := fnd_api.g_miss_date
477 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
478 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
479 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
480 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
481 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
482 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
483 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
484 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
485 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
486 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
487 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
488 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
489 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
490 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
491 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
492 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
493 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
494 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
495 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
496 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
497 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
498 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
499 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
500 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
501 , p5_a34 VARCHAR2 := fnd_api.g_miss_char
502 , p5_a35 VARCHAR2 := fnd_api.g_miss_char
503 , p5_a36 NUMBER := 0-1962.0724
504 , p5_a37 DATE := fnd_api.g_miss_date
505 , p5_a38 NUMBER := 0-1962.0724
506 , p5_a39 DATE := fnd_api.g_miss_date
507 , p5_a40 NUMBER := 0-1962.0724
508 , p5_a41 VARCHAR2 := fnd_api.g_miss_char
509 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
510 , p5_a43 VARCHAR2 := fnd_api.g_miss_char
511 , p5_a44 NUMBER := 0-1962.0724
512 )
513
514 as
515 ddp_styv_rec okl_strm_type_pub.styv_rec_type;
516 ddindx binary_integer; indx binary_integer;
517 begin
518
519 -- copy data to the local IN or IN-OUT args, if any
520
521
522
523
524
525 ddp_styv_rec.id := rosetta_g_miss_num_map(p5_a0);
526 ddp_styv_rec.name := p5_a1;
527 ddp_styv_rec.version := p5_a2;
528 ddp_styv_rec.object_version_number := rosetta_g_miss_num_map(p5_a3);
529 ddp_styv_rec.code := p5_a4;
530 ddp_styv_rec.sfwt_flag := p5_a5;
531 ddp_styv_rec.stream_type_scope := p5_a6;
532 ddp_styv_rec.description := p5_a7;
533 ddp_styv_rec.start_date := rosetta_g_miss_date_in_map(p5_a8);
534 ddp_styv_rec.end_date := rosetta_g_miss_date_in_map(p5_a9);
535 ddp_styv_rec.billable_yn := p5_a10;
536 ddp_styv_rec.taxable_default_yn := p5_a11;
537 ddp_styv_rec.customization_level := p5_a12;
538 ddp_styv_rec.stream_type_class := p5_a13;
539 ddp_styv_rec.stream_type_subclass := p5_a14;
540 ddp_styv_rec.accrual_yn := p5_a15;
541 ddp_styv_rec.capitalize_yn := p5_a16;
542 ddp_styv_rec.periodic_yn := p5_a17;
543 ddp_styv_rec.fundable_yn := p5_a18;
544 ddp_styv_rec.allocation_factor := p5_a19;
545 ddp_styv_rec.attribute_category := p5_a20;
546 ddp_styv_rec.attribute1 := p5_a21;
547 ddp_styv_rec.attribute2 := p5_a22;
548 ddp_styv_rec.attribute3 := p5_a23;
549 ddp_styv_rec.attribute4 := p5_a24;
550 ddp_styv_rec.attribute5 := p5_a25;
551 ddp_styv_rec.attribute6 := p5_a26;
552 ddp_styv_rec.attribute7 := p5_a27;
553 ddp_styv_rec.attribute8 := p5_a28;
554 ddp_styv_rec.attribute9 := p5_a29;
555 ddp_styv_rec.attribute10 := p5_a30;
556 ddp_styv_rec.attribute11 := p5_a31;
557 ddp_styv_rec.attribute12 := p5_a32;
558 ddp_styv_rec.attribute13 := p5_a33;
559 ddp_styv_rec.attribute14 := p5_a34;
560 ddp_styv_rec.attribute15 := p5_a35;
561 ddp_styv_rec.created_by := rosetta_g_miss_num_map(p5_a36);
562 ddp_styv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a37);
563 ddp_styv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a38);
564 ddp_styv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a39);
565 ddp_styv_rec.last_update_login := rosetta_g_miss_num_map(p5_a40);
566 ddp_styv_rec.stream_type_purpose := p5_a41;
567 ddp_styv_rec.contingency := p5_a42;
568 ddp_styv_rec.short_description := p5_a43;
569 ddp_styv_rec.contingency_id := rosetta_g_miss_num_map(p5_a44);
570
571 -- here's the delegated call to the old PL/SQL routine
572 okl_strm_type_pub.lock_strm_type(p_api_version,
573 p_init_msg_list,
574 x_return_status,
575 x_msg_count,
576 x_msg_data,
577 ddp_styv_rec);
578
579 -- copy data back from the local variables to OUT or IN-OUT args, if any
580
581
582
583
584
585 end;
586
587 procedure lock_strm_type(p_api_version NUMBER
588 , p_init_msg_list VARCHAR2
589 , x_return_status out nocopy VARCHAR2
590 , x_msg_count out nocopy NUMBER
591 , x_msg_data out nocopy VARCHAR2
592 , p5_a0 JTF_NUMBER_TABLE
593 , p5_a1 JTF_VARCHAR2_TABLE_200
594 , p5_a2 JTF_VARCHAR2_TABLE_100
595 , p5_a3 JTF_NUMBER_TABLE
596 , p5_a4 JTF_VARCHAR2_TABLE_200
597 , p5_a5 JTF_VARCHAR2_TABLE_100
598 , p5_a6 JTF_VARCHAR2_TABLE_100
599 , p5_a7 JTF_VARCHAR2_TABLE_2000
600 , p5_a8 JTF_DATE_TABLE
601 , p5_a9 JTF_DATE_TABLE
602 , p5_a10 JTF_VARCHAR2_TABLE_100
603 , p5_a11 JTF_VARCHAR2_TABLE_100
604 , p5_a12 JTF_VARCHAR2_TABLE_100
605 , p5_a13 JTF_VARCHAR2_TABLE_100
606 , p5_a14 JTF_VARCHAR2_TABLE_100
607 , p5_a15 JTF_VARCHAR2_TABLE_100
608 , p5_a16 JTF_VARCHAR2_TABLE_100
609 , p5_a17 JTF_VARCHAR2_TABLE_100
610 , p5_a18 JTF_VARCHAR2_TABLE_100
611 , p5_a19 JTF_VARCHAR2_TABLE_100
612 , p5_a20 JTF_VARCHAR2_TABLE_100
613 , p5_a21 JTF_VARCHAR2_TABLE_500
614 , p5_a22 JTF_VARCHAR2_TABLE_500
615 , p5_a23 JTF_VARCHAR2_TABLE_500
616 , p5_a24 JTF_VARCHAR2_TABLE_500
617 , p5_a25 JTF_VARCHAR2_TABLE_500
618 , p5_a26 JTF_VARCHAR2_TABLE_500
619 , p5_a27 JTF_VARCHAR2_TABLE_500
620 , p5_a28 JTF_VARCHAR2_TABLE_500
621 , p5_a29 JTF_VARCHAR2_TABLE_500
622 , p5_a30 JTF_VARCHAR2_TABLE_500
623 , p5_a31 JTF_VARCHAR2_TABLE_500
624 , p5_a32 JTF_VARCHAR2_TABLE_500
625 , p5_a33 JTF_VARCHAR2_TABLE_500
626 , p5_a34 JTF_VARCHAR2_TABLE_500
627 , p5_a35 JTF_VARCHAR2_TABLE_500
628 , p5_a36 JTF_NUMBER_TABLE
629 , p5_a37 JTF_DATE_TABLE
630 , p5_a38 JTF_NUMBER_TABLE
631 , p5_a39 JTF_DATE_TABLE
632 , p5_a40 JTF_NUMBER_TABLE
633 , p5_a41 JTF_VARCHAR2_TABLE_100
634 , p5_a42 JTF_VARCHAR2_TABLE_100
635 , p5_a43 JTF_VARCHAR2_TABLE_600
636 , p5_a44 JTF_NUMBER_TABLE
637 )
638
639 as
640 ddp_styv_tbl okl_strm_type_pub.styv_tbl_type;
641 ddindx binary_integer; indx binary_integer;
642 begin
643
644 -- copy data to the local IN or IN-OUT args, if any
645
646
647
648
649
650 okl_sty_pvt_w.rosetta_table_copy_in_p8(ddp_styv_tbl, p5_a0
651 , p5_a1
652 , p5_a2
653 , p5_a3
654 , p5_a4
655 , p5_a5
656 , p5_a6
657 , p5_a7
658 , p5_a8
659 , p5_a9
660 , p5_a10
661 , p5_a11
662 , p5_a12
663 , p5_a13
664 , p5_a14
665 , p5_a15
666 , p5_a16
667 , p5_a17
668 , p5_a18
669 , p5_a19
670 , p5_a20
671 , p5_a21
672 , p5_a22
673 , p5_a23
674 , p5_a24
675 , p5_a25
676 , p5_a26
677 , p5_a27
678 , p5_a28
679 , p5_a29
680 , p5_a30
681 , p5_a31
682 , p5_a32
683 , p5_a33
684 , p5_a34
685 , p5_a35
686 , p5_a36
687 , p5_a37
688 , p5_a38
689 , p5_a39
690 , p5_a40
691 , p5_a41
692 , p5_a42
693 , p5_a43
694 , p5_a44
695 );
696
697 -- here's the delegated call to the old PL/SQL routine
698 okl_strm_type_pub.lock_strm_type(p_api_version,
699 p_init_msg_list,
700 x_return_status,
701 x_msg_count,
702 x_msg_data,
703 ddp_styv_tbl);
704
705 -- copy data back from the local variables to OUT or IN-OUT args, if any
706
707
708
709
710
711 end;
712
713 procedure update_strm_type(p_api_version NUMBER
714 , p_init_msg_list VARCHAR2
715 , x_return_status out nocopy VARCHAR2
716 , x_msg_count out nocopy NUMBER
717 , x_msg_data out nocopy VARCHAR2
718 , p6_a0 out nocopy NUMBER
719 , p6_a1 out nocopy VARCHAR2
720 , p6_a2 out nocopy VARCHAR2
721 , p6_a3 out nocopy NUMBER
722 , p6_a4 out nocopy VARCHAR2
723 , p6_a5 out nocopy VARCHAR2
724 , p6_a6 out nocopy VARCHAR2
725 , p6_a7 out nocopy VARCHAR2
726 , p6_a8 out nocopy DATE
727 , p6_a9 out nocopy DATE
728 , p6_a10 out nocopy VARCHAR2
729 , p6_a11 out nocopy VARCHAR2
730 , p6_a12 out nocopy VARCHAR2
731 , p6_a13 out nocopy VARCHAR2
732 , p6_a14 out nocopy VARCHAR2
733 , p6_a15 out nocopy VARCHAR2
734 , p6_a16 out nocopy VARCHAR2
735 , p6_a17 out nocopy VARCHAR2
736 , p6_a18 out nocopy VARCHAR2
737 , p6_a19 out nocopy VARCHAR2
738 , p6_a20 out nocopy VARCHAR2
739 , p6_a21 out nocopy VARCHAR2
740 , p6_a22 out nocopy VARCHAR2
741 , p6_a23 out nocopy VARCHAR2
742 , p6_a24 out nocopy VARCHAR2
743 , p6_a25 out nocopy VARCHAR2
744 , p6_a26 out nocopy VARCHAR2
745 , p6_a27 out nocopy VARCHAR2
746 , p6_a28 out nocopy VARCHAR2
747 , p6_a29 out nocopy VARCHAR2
748 , p6_a30 out nocopy VARCHAR2
749 , p6_a31 out nocopy VARCHAR2
750 , p6_a32 out nocopy VARCHAR2
751 , p6_a33 out nocopy VARCHAR2
752 , p6_a34 out nocopy VARCHAR2
753 , p6_a35 out nocopy VARCHAR2
754 , p6_a36 out nocopy NUMBER
755 , p6_a37 out nocopy DATE
756 , p6_a38 out nocopy NUMBER
757 , p6_a39 out nocopy DATE
758 , p6_a40 out nocopy NUMBER
759 , p6_a41 out nocopy VARCHAR2
760 , p6_a42 out nocopy VARCHAR2
761 , p6_a43 out nocopy VARCHAR2
762 , p6_a44 out nocopy NUMBER
763 , p5_a0 NUMBER := 0-1962.0724
764 , p5_a1 VARCHAR2 := fnd_api.g_miss_char
765 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
766 , p5_a3 NUMBER := 0-1962.0724
767 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
768 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
769 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
770 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
771 , p5_a8 DATE := fnd_api.g_miss_date
772 , p5_a9 DATE := fnd_api.g_miss_date
773 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
774 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
775 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
776 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
777 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
778 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
779 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
780 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
781 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
782 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
783 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
784 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
785 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
786 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
787 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
788 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
789 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
790 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
791 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
792 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
793 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
794 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
795 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
796 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
797 , p5_a34 VARCHAR2 := fnd_api.g_miss_char
798 , p5_a35 VARCHAR2 := fnd_api.g_miss_char
799 , p5_a36 NUMBER := 0-1962.0724
800 , p5_a37 DATE := fnd_api.g_miss_date
801 , p5_a38 NUMBER := 0-1962.0724
802 , p5_a39 DATE := fnd_api.g_miss_date
803 , p5_a40 NUMBER := 0-1962.0724
804 , p5_a41 VARCHAR2 := fnd_api.g_miss_char
805 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
806 , p5_a43 VARCHAR2 := fnd_api.g_miss_char
807 , p5_a44 NUMBER := 0-1962.0724
808 )
809
810 as
811 ddp_styv_rec okl_strm_type_pub.styv_rec_type;
812 ddx_styv_rec okl_strm_type_pub.styv_rec_type;
813 ddindx binary_integer; indx binary_integer;
814 begin
815
816 -- copy data to the local IN or IN-OUT args, if any
817
818
819
820
821
822 ddp_styv_rec.id := rosetta_g_miss_num_map(p5_a0);
823 ddp_styv_rec.name := p5_a1;
824 ddp_styv_rec.version := p5_a2;
825 ddp_styv_rec.object_version_number := rosetta_g_miss_num_map(p5_a3);
826 ddp_styv_rec.code := p5_a4;
827 ddp_styv_rec.sfwt_flag := p5_a5;
828 ddp_styv_rec.stream_type_scope := p5_a6;
829 ddp_styv_rec.description := p5_a7;
830 ddp_styv_rec.start_date := rosetta_g_miss_date_in_map(p5_a8);
831 ddp_styv_rec.end_date := rosetta_g_miss_date_in_map(p5_a9);
832 ddp_styv_rec.billable_yn := p5_a10;
833 ddp_styv_rec.taxable_default_yn := p5_a11;
834 ddp_styv_rec.customization_level := p5_a12;
835 ddp_styv_rec.stream_type_class := p5_a13;
836 ddp_styv_rec.stream_type_subclass := p5_a14;
837 ddp_styv_rec.accrual_yn := p5_a15;
838 ddp_styv_rec.capitalize_yn := p5_a16;
839 ddp_styv_rec.periodic_yn := p5_a17;
840 ddp_styv_rec.fundable_yn := p5_a18;
841 ddp_styv_rec.allocation_factor := p5_a19;
842 ddp_styv_rec.attribute_category := p5_a20;
843 ddp_styv_rec.attribute1 := p5_a21;
844 ddp_styv_rec.attribute2 := p5_a22;
845 ddp_styv_rec.attribute3 := p5_a23;
846 ddp_styv_rec.attribute4 := p5_a24;
847 ddp_styv_rec.attribute5 := p5_a25;
848 ddp_styv_rec.attribute6 := p5_a26;
849 ddp_styv_rec.attribute7 := p5_a27;
850 ddp_styv_rec.attribute8 := p5_a28;
851 ddp_styv_rec.attribute9 := p5_a29;
852 ddp_styv_rec.attribute10 := p5_a30;
853 ddp_styv_rec.attribute11 := p5_a31;
854 ddp_styv_rec.attribute12 := p5_a32;
855 ddp_styv_rec.attribute13 := p5_a33;
856 ddp_styv_rec.attribute14 := p5_a34;
857 ddp_styv_rec.attribute15 := p5_a35;
858 ddp_styv_rec.created_by := rosetta_g_miss_num_map(p5_a36);
859 ddp_styv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a37);
860 ddp_styv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a38);
861 ddp_styv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a39);
862 ddp_styv_rec.last_update_login := rosetta_g_miss_num_map(p5_a40);
863 ddp_styv_rec.stream_type_purpose := p5_a41;
864 ddp_styv_rec.contingency := p5_a42;
865 ddp_styv_rec.short_description := p5_a43;
866 ddp_styv_rec.contingency_id := rosetta_g_miss_num_map(p5_a44);
867
868
869 -- here's the delegated call to the old PL/SQL routine
870 okl_strm_type_pub.update_strm_type(p_api_version,
871 p_init_msg_list,
872 x_return_status,
873 x_msg_count,
874 x_msg_data,
875 ddp_styv_rec,
876 ddx_styv_rec);
877
878 -- copy data back from the local variables to OUT or IN-OUT args, if any
879
880
881
882
883
884
885 p6_a0 := rosetta_g_miss_num_map(ddx_styv_rec.id);
886 p6_a1 := ddx_styv_rec.name;
887 p6_a2 := ddx_styv_rec.version;
888 p6_a3 := rosetta_g_miss_num_map(ddx_styv_rec.object_version_number);
889 p6_a4 := ddx_styv_rec.code;
890 p6_a5 := ddx_styv_rec.sfwt_flag;
891 p6_a6 := ddx_styv_rec.stream_type_scope;
892 p6_a7 := ddx_styv_rec.description;
893 p6_a8 := ddx_styv_rec.start_date;
894 p6_a9 := ddx_styv_rec.end_date;
895 p6_a10 := ddx_styv_rec.billable_yn;
896 p6_a11 := ddx_styv_rec.taxable_default_yn;
897 p6_a12 := ddx_styv_rec.customization_level;
898 p6_a13 := ddx_styv_rec.stream_type_class;
899 p6_a14 := ddx_styv_rec.stream_type_subclass;
900 p6_a15 := ddx_styv_rec.accrual_yn;
901 p6_a16 := ddx_styv_rec.capitalize_yn;
902 p6_a17 := ddx_styv_rec.periodic_yn;
903 p6_a18 := ddx_styv_rec.fundable_yn;
904 p6_a19 := ddx_styv_rec.allocation_factor;
905 p6_a20 := ddx_styv_rec.attribute_category;
906 p6_a21 := ddx_styv_rec.attribute1;
907 p6_a22 := ddx_styv_rec.attribute2;
908 p6_a23 := ddx_styv_rec.attribute3;
909 p6_a24 := ddx_styv_rec.attribute4;
910 p6_a25 := ddx_styv_rec.attribute5;
911 p6_a26 := ddx_styv_rec.attribute6;
912 p6_a27 := ddx_styv_rec.attribute7;
913 p6_a28 := ddx_styv_rec.attribute8;
914 p6_a29 := ddx_styv_rec.attribute9;
915 p6_a30 := ddx_styv_rec.attribute10;
916 p6_a31 := ddx_styv_rec.attribute11;
917 p6_a32 := ddx_styv_rec.attribute12;
918 p6_a33 := ddx_styv_rec.attribute13;
919 p6_a34 := ddx_styv_rec.attribute14;
920 p6_a35 := ddx_styv_rec.attribute15;
921 p6_a36 := rosetta_g_miss_num_map(ddx_styv_rec.created_by);
922 p6_a37 := ddx_styv_rec.creation_date;
923 p6_a38 := rosetta_g_miss_num_map(ddx_styv_rec.last_updated_by);
924 p6_a39 := ddx_styv_rec.last_update_date;
925 p6_a40 := rosetta_g_miss_num_map(ddx_styv_rec.last_update_login);
926 p6_a41 := ddx_styv_rec.stream_type_purpose;
927 p6_a42 := ddx_styv_rec.contingency;
928 p6_a43 := ddx_styv_rec.short_description;
929 p6_a44 := rosetta_g_miss_num_map(ddx_styv_rec.contingency_id);
930 end;
931
932 procedure update_strm_type(p_api_version NUMBER
933 , p_init_msg_list VARCHAR2
934 , x_return_status out nocopy VARCHAR2
935 , x_msg_count out nocopy NUMBER
936 , x_msg_data out nocopy VARCHAR2
937 , p5_a0 JTF_NUMBER_TABLE
938 , p5_a1 JTF_VARCHAR2_TABLE_200
939 , p5_a2 JTF_VARCHAR2_TABLE_100
940 , p5_a3 JTF_NUMBER_TABLE
941 , p5_a4 JTF_VARCHAR2_TABLE_200
942 , p5_a5 JTF_VARCHAR2_TABLE_100
943 , p5_a6 JTF_VARCHAR2_TABLE_100
944 , p5_a7 JTF_VARCHAR2_TABLE_2000
945 , p5_a8 JTF_DATE_TABLE
946 , p5_a9 JTF_DATE_TABLE
947 , p5_a10 JTF_VARCHAR2_TABLE_100
948 , p5_a11 JTF_VARCHAR2_TABLE_100
949 , p5_a12 JTF_VARCHAR2_TABLE_100
950 , p5_a13 JTF_VARCHAR2_TABLE_100
951 , p5_a14 JTF_VARCHAR2_TABLE_100
952 , p5_a15 JTF_VARCHAR2_TABLE_100
953 , p5_a16 JTF_VARCHAR2_TABLE_100
954 , p5_a17 JTF_VARCHAR2_TABLE_100
955 , p5_a18 JTF_VARCHAR2_TABLE_100
956 , p5_a19 JTF_VARCHAR2_TABLE_100
957 , p5_a20 JTF_VARCHAR2_TABLE_100
958 , p5_a21 JTF_VARCHAR2_TABLE_500
959 , p5_a22 JTF_VARCHAR2_TABLE_500
960 , p5_a23 JTF_VARCHAR2_TABLE_500
961 , p5_a24 JTF_VARCHAR2_TABLE_500
962 , p5_a25 JTF_VARCHAR2_TABLE_500
963 , p5_a26 JTF_VARCHAR2_TABLE_500
964 , p5_a27 JTF_VARCHAR2_TABLE_500
965 , p5_a28 JTF_VARCHAR2_TABLE_500
966 , p5_a29 JTF_VARCHAR2_TABLE_500
967 , p5_a30 JTF_VARCHAR2_TABLE_500
968 , p5_a31 JTF_VARCHAR2_TABLE_500
969 , p5_a32 JTF_VARCHAR2_TABLE_500
970 , p5_a33 JTF_VARCHAR2_TABLE_500
971 , p5_a34 JTF_VARCHAR2_TABLE_500
972 , p5_a35 JTF_VARCHAR2_TABLE_500
973 , p5_a36 JTF_NUMBER_TABLE
974 , p5_a37 JTF_DATE_TABLE
975 , p5_a38 JTF_NUMBER_TABLE
976 , p5_a39 JTF_DATE_TABLE
977 , p5_a40 JTF_NUMBER_TABLE
978 , p5_a41 JTF_VARCHAR2_TABLE_100
979 , p5_a42 JTF_VARCHAR2_TABLE_100
980 , p5_a43 JTF_VARCHAR2_TABLE_600
981 , p5_a44 JTF_NUMBER_TABLE
982 , p6_a0 out nocopy JTF_NUMBER_TABLE
983 , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
984 , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
985 , p6_a3 out nocopy JTF_NUMBER_TABLE
986 , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
987 , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
988 , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
989 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_2000
990 , p6_a8 out nocopy JTF_DATE_TABLE
991 , p6_a9 out nocopy JTF_DATE_TABLE
992 , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
993 , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
994 , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
995 , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
996 , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
997 , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
998 , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
999 , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
1000 , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
1001 , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
1002 , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
1003 , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
1004 , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
1005 , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
1006 , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
1007 , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
1008 , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
1009 , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
1010 , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
1011 , p6_a29 out nocopy JTF_VARCHAR2_TABLE_500
1012 , p6_a30 out nocopy JTF_VARCHAR2_TABLE_500
1013 , p6_a31 out nocopy JTF_VARCHAR2_TABLE_500
1014 , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
1015 , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
1016 , p6_a34 out nocopy JTF_VARCHAR2_TABLE_500
1017 , p6_a35 out nocopy JTF_VARCHAR2_TABLE_500
1018 , p6_a36 out nocopy JTF_NUMBER_TABLE
1019 , p6_a37 out nocopy JTF_DATE_TABLE
1020 , p6_a38 out nocopy JTF_NUMBER_TABLE
1021 , p6_a39 out nocopy JTF_DATE_TABLE
1022 , p6_a40 out nocopy JTF_NUMBER_TABLE
1023 , p6_a41 out nocopy JTF_VARCHAR2_TABLE_100
1024 , p6_a42 out nocopy JTF_VARCHAR2_TABLE_100
1025 , p6_a43 out nocopy JTF_VARCHAR2_TABLE_600
1026 , p6_a44 out nocopy JTF_NUMBER_TABLE
1027 )
1028
1029 as
1030 ddp_styv_tbl okl_strm_type_pub.styv_tbl_type;
1031 ddx_styv_tbl okl_strm_type_pub.styv_tbl_type;
1032 ddindx binary_integer; indx binary_integer;
1033 begin
1034
1035 -- copy data to the local IN or IN-OUT args, if any
1036
1037
1038
1039
1040
1041 okl_sty_pvt_w.rosetta_table_copy_in_p8(ddp_styv_tbl, p5_a0
1042 , p5_a1
1043 , p5_a2
1044 , p5_a3
1045 , p5_a4
1046 , p5_a5
1047 , p5_a6
1048 , p5_a7
1049 , p5_a8
1050 , p5_a9
1051 , p5_a10
1052 , p5_a11
1053 , p5_a12
1054 , p5_a13
1055 , p5_a14
1056 , p5_a15
1057 , p5_a16
1058 , p5_a17
1059 , p5_a18
1060 , p5_a19
1061 , p5_a20
1062 , p5_a21
1063 , p5_a22
1064 , p5_a23
1065 , p5_a24
1066 , p5_a25
1067 , p5_a26
1068 , p5_a27
1069 , p5_a28
1070 , p5_a29
1071 , p5_a30
1072 , p5_a31
1073 , p5_a32
1074 , p5_a33
1075 , p5_a34
1076 , p5_a35
1077 , p5_a36
1078 , p5_a37
1079 , p5_a38
1080 , p5_a39
1081 , p5_a40
1082 , p5_a41
1083 , p5_a42
1084 , p5_a43
1085 , p5_a44
1086 );
1087
1088
1089 -- here's the delegated call to the old PL/SQL routine
1090 okl_strm_type_pub.update_strm_type(p_api_version,
1091 p_init_msg_list,
1092 x_return_status,
1093 x_msg_count,
1094 x_msg_data,
1095 ddp_styv_tbl,
1096 ddx_styv_tbl);
1097
1098 -- copy data back from the local variables to OUT or IN-OUT args, if any
1099
1100
1101
1102
1103
1104
1105 okl_sty_pvt_w.rosetta_table_copy_out_p8(ddx_styv_tbl, p6_a0
1106 , p6_a1
1107 , p6_a2
1108 , p6_a3
1109 , p6_a4
1110 , p6_a5
1111 , p6_a6
1112 , p6_a7
1113 , p6_a8
1114 , p6_a9
1115 , p6_a10
1116 , p6_a11
1117 , p6_a12
1118 , p6_a13
1119 , p6_a14
1120 , p6_a15
1121 , p6_a16
1122 , p6_a17
1123 , p6_a18
1124 , p6_a19
1125 , p6_a20
1126 , p6_a21
1127 , p6_a22
1128 , p6_a23
1129 , p6_a24
1130 , p6_a25
1131 , p6_a26
1132 , p6_a27
1133 , p6_a28
1134 , p6_a29
1135 , p6_a30
1136 , p6_a31
1137 , p6_a32
1138 , p6_a33
1139 , p6_a34
1140 , p6_a35
1141 , p6_a36
1142 , p6_a37
1143 , p6_a38
1144 , p6_a39
1145 , p6_a40
1146 , p6_a41
1147 , p6_a42
1148 , p6_a43
1149 , p6_a44
1150 );
1151 end;
1152
1153 procedure delete_strm_type(p_api_version NUMBER
1154 , p_init_msg_list VARCHAR2
1155 , x_return_status out nocopy VARCHAR2
1156 , x_msg_count out nocopy NUMBER
1157 , x_msg_data out nocopy VARCHAR2
1158 , p5_a0 NUMBER := 0-1962.0724
1159 , p5_a1 VARCHAR2 := fnd_api.g_miss_char
1160 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1161 , p5_a3 NUMBER := 0-1962.0724
1162 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1163 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1164 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1165 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1166 , p5_a8 DATE := fnd_api.g_miss_date
1167 , p5_a9 DATE := fnd_api.g_miss_date
1168 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1169 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1170 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1171 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1172 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1173 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1174 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1175 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1176 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1177 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1178 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1179 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1180 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1181 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1182 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1183 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1184 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1185 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1186 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1187 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1188 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1189 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1190 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1191 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1192 , p5_a34 VARCHAR2 := fnd_api.g_miss_char
1193 , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1194 , p5_a36 NUMBER := 0-1962.0724
1195 , p5_a37 DATE := fnd_api.g_miss_date
1196 , p5_a38 NUMBER := 0-1962.0724
1197 , p5_a39 DATE := fnd_api.g_miss_date
1198 , p5_a40 NUMBER := 0-1962.0724
1199 , p5_a41 VARCHAR2 := fnd_api.g_miss_char
1200 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
1201 , p5_a43 VARCHAR2 := fnd_api.g_miss_char
1202 , p5_a44 NUMBER := 0-1962.0724
1203 )
1204
1205 as
1206 ddp_styv_rec okl_strm_type_pub.styv_rec_type;
1207 ddindx binary_integer; indx binary_integer;
1208 begin
1209
1210 -- copy data to the local IN or IN-OUT args, if any
1211
1212
1213
1214
1215
1216 ddp_styv_rec.id := rosetta_g_miss_num_map(p5_a0);
1217 ddp_styv_rec.name := p5_a1;
1218 ddp_styv_rec.version := p5_a2;
1219 ddp_styv_rec.object_version_number := rosetta_g_miss_num_map(p5_a3);
1220 ddp_styv_rec.code := p5_a4;
1221 ddp_styv_rec.sfwt_flag := p5_a5;
1222 ddp_styv_rec.stream_type_scope := p5_a6;
1223 ddp_styv_rec.description := p5_a7;
1224 ddp_styv_rec.start_date := rosetta_g_miss_date_in_map(p5_a8);
1225 ddp_styv_rec.end_date := rosetta_g_miss_date_in_map(p5_a9);
1226 ddp_styv_rec.billable_yn := p5_a10;
1227 ddp_styv_rec.taxable_default_yn := p5_a11;
1228 ddp_styv_rec.customization_level := p5_a12;
1229 ddp_styv_rec.stream_type_class := p5_a13;
1230 ddp_styv_rec.stream_type_subclass := p5_a14;
1231 ddp_styv_rec.accrual_yn := p5_a15;
1232 ddp_styv_rec.capitalize_yn := p5_a16;
1233 ddp_styv_rec.periodic_yn := p5_a17;
1234 ddp_styv_rec.fundable_yn := p5_a18;
1235 ddp_styv_rec.allocation_factor := p5_a19;
1236 ddp_styv_rec.attribute_category := p5_a20;
1237 ddp_styv_rec.attribute1 := p5_a21;
1238 ddp_styv_rec.attribute2 := p5_a22;
1239 ddp_styv_rec.attribute3 := p5_a23;
1240 ddp_styv_rec.attribute4 := p5_a24;
1241 ddp_styv_rec.attribute5 := p5_a25;
1242 ddp_styv_rec.attribute6 := p5_a26;
1243 ddp_styv_rec.attribute7 := p5_a27;
1244 ddp_styv_rec.attribute8 := p5_a28;
1245 ddp_styv_rec.attribute9 := p5_a29;
1246 ddp_styv_rec.attribute10 := p5_a30;
1247 ddp_styv_rec.attribute11 := p5_a31;
1248 ddp_styv_rec.attribute12 := p5_a32;
1249 ddp_styv_rec.attribute13 := p5_a33;
1250 ddp_styv_rec.attribute14 := p5_a34;
1251 ddp_styv_rec.attribute15 := p5_a35;
1252 ddp_styv_rec.created_by := rosetta_g_miss_num_map(p5_a36);
1253 ddp_styv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a37);
1254 ddp_styv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a38);
1255 ddp_styv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a39);
1256 ddp_styv_rec.last_update_login := rosetta_g_miss_num_map(p5_a40);
1257 ddp_styv_rec.stream_type_purpose := p5_a41;
1258 ddp_styv_rec.contingency := p5_a42;
1259 ddp_styv_rec.short_description := p5_a43;
1260 ddp_styv_rec.contingency_id := rosetta_g_miss_num_map(p5_a44);
1261
1262 -- here's the delegated call to the old PL/SQL routine
1263 okl_strm_type_pub.delete_strm_type(p_api_version,
1264 p_init_msg_list,
1265 x_return_status,
1266 x_msg_count,
1267 x_msg_data,
1268 ddp_styv_rec);
1269
1270 -- copy data back from the local variables to OUT or IN-OUT args, if any
1271
1272
1273
1274
1275
1276 end;
1277
1278 procedure delete_strm_type(p_api_version NUMBER
1279 , p_init_msg_list VARCHAR2
1280 , x_return_status out nocopy VARCHAR2
1281 , x_msg_count out nocopy NUMBER
1282 , x_msg_data out nocopy VARCHAR2
1283 , p5_a0 JTF_NUMBER_TABLE
1284 , p5_a1 JTF_VARCHAR2_TABLE_200
1285 , p5_a2 JTF_VARCHAR2_TABLE_100
1286 , p5_a3 JTF_NUMBER_TABLE
1287 , p5_a4 JTF_VARCHAR2_TABLE_200
1288 , p5_a5 JTF_VARCHAR2_TABLE_100
1289 , p5_a6 JTF_VARCHAR2_TABLE_100
1290 , p5_a7 JTF_VARCHAR2_TABLE_2000
1291 , p5_a8 JTF_DATE_TABLE
1292 , p5_a9 JTF_DATE_TABLE
1293 , p5_a10 JTF_VARCHAR2_TABLE_100
1294 , p5_a11 JTF_VARCHAR2_TABLE_100
1295 , p5_a12 JTF_VARCHAR2_TABLE_100
1296 , p5_a13 JTF_VARCHAR2_TABLE_100
1297 , p5_a14 JTF_VARCHAR2_TABLE_100
1298 , p5_a15 JTF_VARCHAR2_TABLE_100
1299 , p5_a16 JTF_VARCHAR2_TABLE_100
1300 , p5_a17 JTF_VARCHAR2_TABLE_100
1301 , p5_a18 JTF_VARCHAR2_TABLE_100
1302 , p5_a19 JTF_VARCHAR2_TABLE_100
1303 , p5_a20 JTF_VARCHAR2_TABLE_100
1304 , p5_a21 JTF_VARCHAR2_TABLE_500
1305 , p5_a22 JTF_VARCHAR2_TABLE_500
1306 , p5_a23 JTF_VARCHAR2_TABLE_500
1307 , p5_a24 JTF_VARCHAR2_TABLE_500
1308 , p5_a25 JTF_VARCHAR2_TABLE_500
1309 , p5_a26 JTF_VARCHAR2_TABLE_500
1310 , p5_a27 JTF_VARCHAR2_TABLE_500
1311 , p5_a28 JTF_VARCHAR2_TABLE_500
1312 , p5_a29 JTF_VARCHAR2_TABLE_500
1313 , p5_a30 JTF_VARCHAR2_TABLE_500
1314 , p5_a31 JTF_VARCHAR2_TABLE_500
1315 , p5_a32 JTF_VARCHAR2_TABLE_500
1316 , p5_a33 JTF_VARCHAR2_TABLE_500
1317 , p5_a34 JTF_VARCHAR2_TABLE_500
1318 , p5_a35 JTF_VARCHAR2_TABLE_500
1319 , p5_a36 JTF_NUMBER_TABLE
1320 , p5_a37 JTF_DATE_TABLE
1321 , p5_a38 JTF_NUMBER_TABLE
1322 , p5_a39 JTF_DATE_TABLE
1323 , p5_a40 JTF_NUMBER_TABLE
1324 , p5_a41 JTF_VARCHAR2_TABLE_100
1325 , p5_a42 JTF_VARCHAR2_TABLE_100
1326 , p5_a43 JTF_VARCHAR2_TABLE_600
1327 , p5_a44 JTF_NUMBER_TABLE
1328 )
1329
1330 as
1331 ddp_styv_tbl okl_strm_type_pub.styv_tbl_type;
1332 ddindx binary_integer; indx binary_integer;
1333 begin
1334
1335 -- copy data to the local IN or IN-OUT args, if any
1336
1337
1338
1339
1340
1341 okl_sty_pvt_w.rosetta_table_copy_in_p8(ddp_styv_tbl, p5_a0
1342 , p5_a1
1343 , p5_a2
1344 , p5_a3
1345 , p5_a4
1346 , p5_a5
1347 , p5_a6
1348 , p5_a7
1349 , p5_a8
1350 , p5_a9
1351 , p5_a10
1352 , p5_a11
1353 , p5_a12
1354 , p5_a13
1355 , p5_a14
1356 , p5_a15
1357 , p5_a16
1358 , p5_a17
1359 , p5_a18
1360 , p5_a19
1361 , p5_a20
1362 , p5_a21
1363 , p5_a22
1364 , p5_a23
1365 , p5_a24
1366 , p5_a25
1367 , p5_a26
1368 , p5_a27
1369 , p5_a28
1370 , p5_a29
1371 , p5_a30
1372 , p5_a31
1373 , p5_a32
1374 , p5_a33
1375 , p5_a34
1376 , p5_a35
1377 , p5_a36
1378 , p5_a37
1379 , p5_a38
1380 , p5_a39
1381 , p5_a40
1382 , p5_a41
1383 , p5_a42
1384 , p5_a43
1385 , p5_a44
1386 );
1387
1388 -- here's the delegated call to the old PL/SQL routine
1389 okl_strm_type_pub.delete_strm_type(p_api_version,
1390 p_init_msg_list,
1391 x_return_status,
1392 x_msg_count,
1393 x_msg_data,
1394 ddp_styv_tbl);
1395
1396 -- copy data back from the local variables to OUT or IN-OUT args, if any
1397
1398
1399
1400
1401
1402 end;
1403
1404 procedure validate_strm_type(p_api_version NUMBER
1405 , p_init_msg_list VARCHAR2
1406 , x_return_status out nocopy VARCHAR2
1407 , x_msg_count out nocopy NUMBER
1408 , x_msg_data out nocopy VARCHAR2
1409 , p5_a0 NUMBER := 0-1962.0724
1410 , p5_a1 VARCHAR2 := fnd_api.g_miss_char
1411 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1412 , p5_a3 NUMBER := 0-1962.0724
1413 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1414 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1415 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1416 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1417 , p5_a8 DATE := fnd_api.g_miss_date
1418 , p5_a9 DATE := fnd_api.g_miss_date
1419 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1420 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1421 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1422 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1423 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1424 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1425 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1426 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1427 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1428 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1429 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1430 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1431 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1432 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1433 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1434 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1435 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1436 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1437 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1438 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1439 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1440 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1441 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1442 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1443 , p5_a34 VARCHAR2 := fnd_api.g_miss_char
1444 , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1445 , p5_a36 NUMBER := 0-1962.0724
1446 , p5_a37 DATE := fnd_api.g_miss_date
1447 , p5_a38 NUMBER := 0-1962.0724
1448 , p5_a39 DATE := fnd_api.g_miss_date
1449 , p5_a40 NUMBER := 0-1962.0724
1450 , p5_a41 VARCHAR2 := fnd_api.g_miss_char
1451 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
1452 , p5_a43 VARCHAR2 := fnd_api.g_miss_char
1453 , p5_a44 NUMBER := 0-1962.0724
1454 )
1455
1456 as
1457 ddp_styv_rec okl_strm_type_pub.styv_rec_type;
1458 ddindx binary_integer; indx binary_integer;
1459 begin
1460
1461 -- copy data to the local IN or IN-OUT args, if any
1462
1463
1464
1465
1466
1467 ddp_styv_rec.id := rosetta_g_miss_num_map(p5_a0);
1468 ddp_styv_rec.name := p5_a1;
1469 ddp_styv_rec.version := p5_a2;
1470 ddp_styv_rec.object_version_number := rosetta_g_miss_num_map(p5_a3);
1471 ddp_styv_rec.code := p5_a4;
1472 ddp_styv_rec.sfwt_flag := p5_a5;
1473 ddp_styv_rec.stream_type_scope := p5_a6;
1474 ddp_styv_rec.description := p5_a7;
1475 ddp_styv_rec.start_date := rosetta_g_miss_date_in_map(p5_a8);
1476 ddp_styv_rec.end_date := rosetta_g_miss_date_in_map(p5_a9);
1477 ddp_styv_rec.billable_yn := p5_a10;
1478 ddp_styv_rec.taxable_default_yn := p5_a11;
1479 ddp_styv_rec.customization_level := p5_a12;
1480 ddp_styv_rec.stream_type_class := p5_a13;
1481 ddp_styv_rec.stream_type_subclass := p5_a14;
1482 ddp_styv_rec.accrual_yn := p5_a15;
1483 ddp_styv_rec.capitalize_yn := p5_a16;
1484 ddp_styv_rec.periodic_yn := p5_a17;
1485 ddp_styv_rec.fundable_yn := p5_a18;
1486 ddp_styv_rec.allocation_factor := p5_a19;
1487 ddp_styv_rec.attribute_category := p5_a20;
1488 ddp_styv_rec.attribute1 := p5_a21;
1489 ddp_styv_rec.attribute2 := p5_a22;
1490 ddp_styv_rec.attribute3 := p5_a23;
1491 ddp_styv_rec.attribute4 := p5_a24;
1492 ddp_styv_rec.attribute5 := p5_a25;
1493 ddp_styv_rec.attribute6 := p5_a26;
1494 ddp_styv_rec.attribute7 := p5_a27;
1495 ddp_styv_rec.attribute8 := p5_a28;
1496 ddp_styv_rec.attribute9 := p5_a29;
1497 ddp_styv_rec.attribute10 := p5_a30;
1498 ddp_styv_rec.attribute11 := p5_a31;
1499 ddp_styv_rec.attribute12 := p5_a32;
1500 ddp_styv_rec.attribute13 := p5_a33;
1501 ddp_styv_rec.attribute14 := p5_a34;
1502 ddp_styv_rec.attribute15 := p5_a35;
1503 ddp_styv_rec.created_by := rosetta_g_miss_num_map(p5_a36);
1504 ddp_styv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a37);
1505 ddp_styv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a38);
1506 ddp_styv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a39);
1507 ddp_styv_rec.last_update_login := rosetta_g_miss_num_map(p5_a40);
1508 ddp_styv_rec.stream_type_purpose := p5_a41;
1509 ddp_styv_rec.contingency := p5_a42;
1510 ddp_styv_rec.short_description := p5_a43;
1511 ddp_styv_rec.contingency_id := rosetta_g_miss_num_map(p5_a44);
1512
1513 -- here's the delegated call to the old PL/SQL routine
1514 okl_strm_type_pub.validate_strm_type(p_api_version,
1515 p_init_msg_list,
1516 x_return_status,
1517 x_msg_count,
1518 x_msg_data,
1519 ddp_styv_rec);
1520
1521 -- copy data back from the local variables to OUT or IN-OUT args, if any
1522
1523
1524
1525
1526
1527 end;
1528
1529 procedure validate_strm_type(p_api_version NUMBER
1530 , p_init_msg_list VARCHAR2
1531 , x_return_status out nocopy VARCHAR2
1532 , x_msg_count out nocopy NUMBER
1533 , x_msg_data out nocopy VARCHAR2
1534 , p5_a0 JTF_NUMBER_TABLE
1535 , p5_a1 JTF_VARCHAR2_TABLE_200
1536 , p5_a2 JTF_VARCHAR2_TABLE_100
1537 , p5_a3 JTF_NUMBER_TABLE
1538 , p5_a4 JTF_VARCHAR2_TABLE_200
1539 , p5_a5 JTF_VARCHAR2_TABLE_100
1540 , p5_a6 JTF_VARCHAR2_TABLE_100
1541 , p5_a7 JTF_VARCHAR2_TABLE_2000
1542 , p5_a8 JTF_DATE_TABLE
1543 , p5_a9 JTF_DATE_TABLE
1544 , p5_a10 JTF_VARCHAR2_TABLE_100
1545 , p5_a11 JTF_VARCHAR2_TABLE_100
1546 , p5_a12 JTF_VARCHAR2_TABLE_100
1547 , p5_a13 JTF_VARCHAR2_TABLE_100
1548 , p5_a14 JTF_VARCHAR2_TABLE_100
1549 , p5_a15 JTF_VARCHAR2_TABLE_100
1550 , p5_a16 JTF_VARCHAR2_TABLE_100
1551 , p5_a17 JTF_VARCHAR2_TABLE_100
1552 , p5_a18 JTF_VARCHAR2_TABLE_100
1553 , p5_a19 JTF_VARCHAR2_TABLE_100
1554 , p5_a20 JTF_VARCHAR2_TABLE_100
1555 , p5_a21 JTF_VARCHAR2_TABLE_500
1556 , p5_a22 JTF_VARCHAR2_TABLE_500
1557 , p5_a23 JTF_VARCHAR2_TABLE_500
1558 , p5_a24 JTF_VARCHAR2_TABLE_500
1559 , p5_a25 JTF_VARCHAR2_TABLE_500
1560 , p5_a26 JTF_VARCHAR2_TABLE_500
1561 , p5_a27 JTF_VARCHAR2_TABLE_500
1562 , p5_a28 JTF_VARCHAR2_TABLE_500
1563 , p5_a29 JTF_VARCHAR2_TABLE_500
1564 , p5_a30 JTF_VARCHAR2_TABLE_500
1565 , p5_a31 JTF_VARCHAR2_TABLE_500
1566 , p5_a32 JTF_VARCHAR2_TABLE_500
1567 , p5_a33 JTF_VARCHAR2_TABLE_500
1568 , p5_a34 JTF_VARCHAR2_TABLE_500
1569 , p5_a35 JTF_VARCHAR2_TABLE_500
1570 , p5_a36 JTF_NUMBER_TABLE
1571 , p5_a37 JTF_DATE_TABLE
1572 , p5_a38 JTF_NUMBER_TABLE
1573 , p5_a39 JTF_DATE_TABLE
1574 , p5_a40 JTF_NUMBER_TABLE
1575 , p5_a41 JTF_VARCHAR2_TABLE_100
1576 , p5_a42 JTF_VARCHAR2_TABLE_100
1577 , p5_a43 JTF_VARCHAR2_TABLE_600
1578 , p5_a44 JTF_NUMBER_TABLE
1579 )
1580
1581 as
1582 ddp_styv_tbl okl_strm_type_pub.styv_tbl_type;
1583 ddindx binary_integer; indx binary_integer;
1584 begin
1585
1586 -- copy data to the local IN or IN-OUT args, if any
1587
1588
1589
1590
1591
1592 okl_sty_pvt_w.rosetta_table_copy_in_p8(ddp_styv_tbl, p5_a0
1593 , p5_a1
1594 , p5_a2
1595 , p5_a3
1596 , p5_a4
1597 , p5_a5
1598 , p5_a6
1599 , p5_a7
1600 , p5_a8
1601 , p5_a9
1602 , p5_a10
1603 , p5_a11
1604 , p5_a12
1605 , p5_a13
1606 , p5_a14
1607 , p5_a15
1608 , p5_a16
1609 , p5_a17
1610 , p5_a18
1611 , p5_a19
1612 , p5_a20
1613 , p5_a21
1614 , p5_a22
1615 , p5_a23
1616 , p5_a24
1617 , p5_a25
1618 , p5_a26
1619 , p5_a27
1620 , p5_a28
1621 , p5_a29
1622 , p5_a30
1623 , p5_a31
1624 , p5_a32
1625 , p5_a33
1626 , p5_a34
1627 , p5_a35
1628 , p5_a36
1629 , p5_a37
1630 , p5_a38
1631 , p5_a39
1632 , p5_a40
1633 , p5_a41
1634 , p5_a42
1635 , p5_a43
1636 , p5_a44
1637 );
1638
1639 -- here's the delegated call to the old PL/SQL routine
1640 okl_strm_type_pub.validate_strm_type(p_api_version,
1641 p_init_msg_list,
1642 x_return_status,
1643 x_msg_count,
1644 x_msg_data,
1645 ddp_styv_tbl);
1646
1647 -- copy data back from the local variables to OUT or IN-OUT args, if any
1648
1649
1650
1651
1652
1653 end;
1654
1655 end okl_strm_type_pub_w;