eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_STREAMS_UTIL_W dependencies on OKL_STREAMS_UTIL

Line 1: package body okl_streams_util_w as

1: package body okl_streams_util_w as
2: /* $Header: OKLESULB.pls 120.1 2005/10/30 03:16:50 appldev 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:

Line 22: procedure rosetta_table_copy_in_p1(t out nocopy okl_streams_util.log_msg_tbl, a0 JTF_VARCHAR2_TABLE_4000) as

18: if n=b then return a; end if;
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p1(t out nocopy okl_streams_util.log_msg_tbl, a0 JTF_VARCHAR2_TABLE_4000) as
23: ddindx binary_integer; indx binary_integer;
24: begin
25: if a0 is not null and a0.count > 0 then
26: if a0.count > 0 then

Line 40: procedure rosetta_table_copy_out_p1(t okl_streams_util.log_msg_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_4000) as

36: end loop;
37: end if;
38: end if;
39: end rosetta_table_copy_in_p1;
40: procedure rosetta_table_copy_out_p1(t okl_streams_util.log_msg_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_4000) as
41: ddindx binary_integer; indx binary_integer;
42: begin
43: if t is null or t.count = 0 then
44: a0 := JTF_VARCHAR2_TABLE_4000();

Line 63: procedure rosetta_table_copy_in_p21(t out nocopy okl_streams_util.clobtabtyp, a0 JTF_CLOB_TABLE) as

59: end if;
60: end if;
61: end rosetta_table_copy_out_p1;
62:
63: procedure rosetta_table_copy_in_p21(t out nocopy okl_streams_util.clobtabtyp, a0 JTF_CLOB_TABLE) as
64: ddindx binary_integer; indx binary_integer;
65: begin
66: if a0 is not null and a0.count > 0 then
67: if a0.count > 0 then

Line 81: procedure rosetta_table_copy_out_p21(t okl_streams_util.clobtabtyp, a0 out nocopy JTF_CLOB_TABLE) as

77: end loop;
78: end if;
79: end if;
80: end rosetta_table_copy_in_p21;
81: procedure rosetta_table_copy_out_p21(t okl_streams_util.clobtabtyp, a0 out nocopy JTF_CLOB_TABLE) as
82: ddindx binary_integer; indx binary_integer;
83: begin
84: if t is null or t.count = 0 then
85: a0 := JTF_CLOB_TABLE();

Line 104: procedure rosetta_table_copy_in_p22(t out nocopy okl_streams_util.datetabtyp, a0 JTF_DATE_TABLE) as

100: end if;
101: end if;
102: end rosetta_table_copy_out_p21;
103:
104: procedure rosetta_table_copy_in_p22(t out nocopy okl_streams_util.datetabtyp, a0 JTF_DATE_TABLE) as
105: ddindx binary_integer; indx binary_integer;
106: begin
107: if a0 is not null and a0.count > 0 then
108: if a0.count > 0 then

Line 122: procedure rosetta_table_copy_out_p22(t okl_streams_util.datetabtyp, a0 out nocopy JTF_DATE_TABLE) as

118: end loop;
119: end if;
120: end if;
121: end rosetta_table_copy_in_p22;
122: procedure rosetta_table_copy_out_p22(t okl_streams_util.datetabtyp, a0 out nocopy JTF_DATE_TABLE) as
123: ddindx binary_integer; indx binary_integer;
124: begin
125: if t is null or t.count = 0 then
126: a0 := JTF_DATE_TABLE();

Line 145: procedure rosetta_table_copy_in_p23(t out nocopy okl_streams_util.numbertabtyp, a0 JTF_NUMBER_TABLE) as

141: end if;
142: end if;
143: end rosetta_table_copy_out_p22;
144:
145: procedure rosetta_table_copy_in_p23(t out nocopy okl_streams_util.numbertabtyp, a0 JTF_NUMBER_TABLE) as
146: ddindx binary_integer; indx binary_integer;
147: begin
148: if a0 is not null and a0.count > 0 then
149: if a0.count > 0 then

Line 163: procedure rosetta_table_copy_out_p23(t okl_streams_util.numbertabtyp, a0 out nocopy JTF_NUMBER_TABLE) as

159: end loop;
160: end if;
161: end if;
162: end rosetta_table_copy_in_p23;
163: procedure rosetta_table_copy_out_p23(t okl_streams_util.numbertabtyp, a0 out nocopy JTF_NUMBER_TABLE) as
164: ddindx binary_integer; indx binary_integer;
165: begin
166: if t is null or t.count = 0 then
167: a0 := JTF_NUMBER_TABLE();

Line 186: procedure rosetta_table_copy_in_p24(t out nocopy okl_streams_util.number15tabtyp, a0 JTF_NUMBER_TABLE) as

182: end if;
183: end if;
184: end rosetta_table_copy_out_p23;
185:
186: procedure rosetta_table_copy_in_p24(t out nocopy okl_streams_util.number15tabtyp, a0 JTF_NUMBER_TABLE) as
187: ddindx binary_integer; indx binary_integer;
188: begin
189: if a0 is not null and a0.count > 0 then
190: if a0.count > 0 then

Line 204: procedure rosetta_table_copy_out_p24(t okl_streams_util.number15tabtyp, a0 out nocopy JTF_NUMBER_TABLE) as

200: end loop;
201: end if;
202: end if;
203: end rosetta_table_copy_in_p24;
204: procedure rosetta_table_copy_out_p24(t okl_streams_util.number15tabtyp, a0 out nocopy JTF_NUMBER_TABLE) as
205: ddindx binary_integer; indx binary_integer;
206: begin
207: if t is null or t.count = 0 then
208: a0 := JTF_NUMBER_TABLE();

Line 227: procedure rosetta_table_copy_in_p25(t out nocopy okl_streams_util.var10tabtyp, a0 JTF_VARCHAR2_TABLE_100) as

223: end if;
224: end if;
225: end rosetta_table_copy_out_p24;
226:
227: procedure rosetta_table_copy_in_p25(t out nocopy okl_streams_util.var10tabtyp, a0 JTF_VARCHAR2_TABLE_100) as
228: ddindx binary_integer; indx binary_integer;
229: begin
230: if a0 is not null and a0.count > 0 then
231: if a0.count > 0 then

Line 245: procedure rosetta_table_copy_out_p25(t okl_streams_util.var10tabtyp, a0 out nocopy JTF_VARCHAR2_TABLE_100) as

241: end loop;
242: end if;
243: end if;
244: end rosetta_table_copy_in_p25;
245: procedure rosetta_table_copy_out_p25(t okl_streams_util.var10tabtyp, a0 out nocopy JTF_VARCHAR2_TABLE_100) as
246: ddindx binary_integer; indx binary_integer;
247: begin
248: if t is null or t.count = 0 then
249: a0 := JTF_VARCHAR2_TABLE_100();

Line 268: procedure rosetta_table_copy_in_p26(t out nocopy okl_streams_util.var12tabtyp, a0 JTF_VARCHAR2_TABLE_100) as

264: end if;
265: end if;
266: end rosetta_table_copy_out_p25;
267:
268: procedure rosetta_table_copy_in_p26(t out nocopy okl_streams_util.var12tabtyp, a0 JTF_VARCHAR2_TABLE_100) as
269: ddindx binary_integer; indx binary_integer;
270: begin
271: if a0 is not null and a0.count > 0 then
272: if a0.count > 0 then

Line 286: procedure rosetta_table_copy_out_p26(t okl_streams_util.var12tabtyp, a0 out nocopy JTF_VARCHAR2_TABLE_100) as

282: end loop;
283: end if;
284: end if;
285: end rosetta_table_copy_in_p26;
286: procedure rosetta_table_copy_out_p26(t okl_streams_util.var12tabtyp, a0 out nocopy JTF_VARCHAR2_TABLE_100) as
287: ddindx binary_integer; indx binary_integer;
288: begin
289: if t is null or t.count = 0 then
290: a0 := JTF_VARCHAR2_TABLE_100();

Line 309: procedure rosetta_table_copy_in_p27(t out nocopy okl_streams_util.var120tabtyp, a0 JTF_VARCHAR2_TABLE_200) as

305: end if;
306: end if;
307: end rosetta_table_copy_out_p26;
308:
309: procedure rosetta_table_copy_in_p27(t out nocopy okl_streams_util.var120tabtyp, a0 JTF_VARCHAR2_TABLE_200) as
310: ddindx binary_integer; indx binary_integer;
311: begin
312: if a0 is not null and a0.count > 0 then
313: if a0.count > 0 then

Line 327: procedure rosetta_table_copy_out_p27(t okl_streams_util.var120tabtyp, a0 out nocopy JTF_VARCHAR2_TABLE_200) as

323: end loop;
324: end if;
325: end if;
326: end rosetta_table_copy_in_p27;
327: procedure rosetta_table_copy_out_p27(t okl_streams_util.var120tabtyp, a0 out nocopy JTF_VARCHAR2_TABLE_200) as
328: ddindx binary_integer; indx binary_integer;
329: begin
330: if t is null or t.count = 0 then
331: a0 := JTF_VARCHAR2_TABLE_200();

Line 350: procedure rosetta_table_copy_in_p28(t out nocopy okl_streams_util.var15tabtyp, a0 JTF_VARCHAR2_TABLE_100) as

346: end if;
347: end if;
348: end rosetta_table_copy_out_p27;
349:
350: procedure rosetta_table_copy_in_p28(t out nocopy okl_streams_util.var15tabtyp, a0 JTF_VARCHAR2_TABLE_100) as
351: ddindx binary_integer; indx binary_integer;
352: begin
353: if a0 is not null and a0.count > 0 then
354: if a0.count > 0 then

Line 368: procedure rosetta_table_copy_out_p28(t okl_streams_util.var15tabtyp, a0 out nocopy JTF_VARCHAR2_TABLE_100) as

364: end loop;
365: end if;
366: end if;
367: end rosetta_table_copy_in_p28;
368: procedure rosetta_table_copy_out_p28(t okl_streams_util.var15tabtyp, a0 out nocopy JTF_VARCHAR2_TABLE_100) as
369: ddindx binary_integer; indx binary_integer;
370: begin
371: if t is null or t.count = 0 then
372: a0 := JTF_VARCHAR2_TABLE_100();

Line 391: procedure rosetta_table_copy_in_p29(t out nocopy okl_streams_util.var150tabtyp, a0 JTF_VARCHAR2_TABLE_200) as

387: end if;
388: end if;
389: end rosetta_table_copy_out_p28;
390:
391: procedure rosetta_table_copy_in_p29(t out nocopy okl_streams_util.var150tabtyp, a0 JTF_VARCHAR2_TABLE_200) as
392: ddindx binary_integer; indx binary_integer;
393: begin
394: if a0 is not null and a0.count > 0 then
395: if a0.count > 0 then

Line 409: procedure rosetta_table_copy_out_p29(t okl_streams_util.var150tabtyp, a0 out nocopy JTF_VARCHAR2_TABLE_200) as

405: end loop;
406: end if;
407: end if;
408: end rosetta_table_copy_in_p29;
409: procedure rosetta_table_copy_out_p29(t okl_streams_util.var150tabtyp, a0 out nocopy JTF_VARCHAR2_TABLE_200) as
410: ddindx binary_integer; indx binary_integer;
411: begin
412: if t is null or t.count = 0 then
413: a0 := JTF_VARCHAR2_TABLE_200();

Line 432: procedure rosetta_table_copy_in_p30(t out nocopy okl_streams_util.var1995tabtyp, a0 JTF_VARCHAR2_TABLE_2000) as

428: end if;
429: end if;
430: end rosetta_table_copy_out_p29;
431:
432: procedure rosetta_table_copy_in_p30(t out nocopy okl_streams_util.var1995tabtyp, a0 JTF_VARCHAR2_TABLE_2000) as
433: ddindx binary_integer; indx binary_integer;
434: begin
435: if a0 is not null and a0.count > 0 then
436: if a0.count > 0 then

Line 450: procedure rosetta_table_copy_out_p30(t okl_streams_util.var1995tabtyp, a0 out nocopy JTF_VARCHAR2_TABLE_2000) as

446: end loop;
447: end if;
448: end if;
449: end rosetta_table_copy_in_p30;
450: procedure rosetta_table_copy_out_p30(t okl_streams_util.var1995tabtyp, a0 out nocopy JTF_VARCHAR2_TABLE_2000) as
451: ddindx binary_integer; indx binary_integer;
452: begin
453: if t is null or t.count = 0 then
454: a0 := JTF_VARCHAR2_TABLE_2000();

Line 473: procedure rosetta_table_copy_in_p31(t out nocopy okl_streams_util.var24tabtyp, a0 JTF_VARCHAR2_TABLE_100) as

469: end if;
470: end if;
471: end rosetta_table_copy_out_p30;
472:
473: procedure rosetta_table_copy_in_p31(t out nocopy okl_streams_util.var24tabtyp, a0 JTF_VARCHAR2_TABLE_100) as
474: ddindx binary_integer; indx binary_integer;
475: begin
476: if a0 is not null and a0.count > 0 then
477: if a0.count > 0 then

Line 491: procedure rosetta_table_copy_out_p31(t okl_streams_util.var24tabtyp, a0 out nocopy JTF_VARCHAR2_TABLE_100) as

487: end loop;
488: end if;
489: end if;
490: end rosetta_table_copy_in_p31;
491: procedure rosetta_table_copy_out_p31(t okl_streams_util.var24tabtyp, a0 out nocopy JTF_VARCHAR2_TABLE_100) as
492: ddindx binary_integer; indx binary_integer;
493: begin
494: if t is null or t.count = 0 then
495: a0 := JTF_VARCHAR2_TABLE_100();

Line 514: procedure rosetta_table_copy_in_p32(t out nocopy okl_streams_util.var200tabtyp, a0 JTF_VARCHAR2_TABLE_200) as

510: end if;
511: end if;
512: end rosetta_table_copy_out_p31;
513:
514: procedure rosetta_table_copy_in_p32(t out nocopy okl_streams_util.var200tabtyp, a0 JTF_VARCHAR2_TABLE_200) as
515: ddindx binary_integer; indx binary_integer;
516: begin
517: if a0 is not null and a0.count > 0 then
518: if a0.count > 0 then

Line 532: procedure rosetta_table_copy_out_p32(t okl_streams_util.var200tabtyp, a0 out nocopy JTF_VARCHAR2_TABLE_200) as

528: end loop;
529: end if;
530: end if;
531: end rosetta_table_copy_in_p32;
532: procedure rosetta_table_copy_out_p32(t okl_streams_util.var200tabtyp, a0 out nocopy JTF_VARCHAR2_TABLE_200) as
533: ddindx binary_integer; indx binary_integer;
534: begin
535: if t is null or t.count = 0 then
536: a0 := JTF_VARCHAR2_TABLE_200();

Line 555: procedure rosetta_table_copy_in_p33(t out nocopy okl_streams_util.var240tabtyp, a0 JTF_VARCHAR2_TABLE_300) as

551: end if;
552: end if;
553: end rosetta_table_copy_out_p32;
554:
555: procedure rosetta_table_copy_in_p33(t out nocopy okl_streams_util.var240tabtyp, a0 JTF_VARCHAR2_TABLE_300) as
556: ddindx binary_integer; indx binary_integer;
557: begin
558: if a0 is not null and a0.count > 0 then
559: if a0.count > 0 then

Line 573: procedure rosetta_table_copy_out_p33(t okl_streams_util.var240tabtyp, a0 out nocopy JTF_VARCHAR2_TABLE_300) as

569: end loop;
570: end if;
571: end if;
572: end rosetta_table_copy_in_p33;
573: procedure rosetta_table_copy_out_p33(t okl_streams_util.var240tabtyp, a0 out nocopy JTF_VARCHAR2_TABLE_300) as
574: ddindx binary_integer; indx binary_integer;
575: begin
576: if t is null or t.count = 0 then
577: a0 := JTF_VARCHAR2_TABLE_300();

Line 596: procedure rosetta_table_copy_in_p34(t out nocopy okl_streams_util.var3tabtyp, a0 JTF_VARCHAR2_TABLE_100) as

592: end if;
593: end if;
594: end rosetta_table_copy_out_p33;
595:
596: procedure rosetta_table_copy_in_p34(t out nocopy okl_streams_util.var3tabtyp, a0 JTF_VARCHAR2_TABLE_100) as
597: ddindx binary_integer; indx binary_integer;
598: begin
599: if a0 is not null and a0.count > 0 then
600: if a0.count > 0 then

Line 614: procedure rosetta_table_copy_out_p34(t okl_streams_util.var3tabtyp, a0 out nocopy JTF_VARCHAR2_TABLE_100) as

610: end loop;
611: end if;
612: end if;
613: end rosetta_table_copy_in_p34;
614: procedure rosetta_table_copy_out_p34(t okl_streams_util.var3tabtyp, a0 out nocopy JTF_VARCHAR2_TABLE_100) as
615: ddindx binary_integer; indx binary_integer;
616: begin
617: if t is null or t.count = 0 then
618: a0 := JTF_VARCHAR2_TABLE_100();

Line 637: procedure rosetta_table_copy_in_p35(t out nocopy okl_streams_util.var30tabtyp, a0 JTF_VARCHAR2_TABLE_100) as

633: end if;
634: end if;
635: end rosetta_table_copy_out_p34;
636:
637: procedure rosetta_table_copy_in_p35(t out nocopy okl_streams_util.var30tabtyp, a0 JTF_VARCHAR2_TABLE_100) as
638: ddindx binary_integer; indx binary_integer;
639: begin
640: if a0 is not null and a0.count > 0 then
641: if a0.count > 0 then

Line 655: procedure rosetta_table_copy_out_p35(t okl_streams_util.var30tabtyp, a0 out nocopy JTF_VARCHAR2_TABLE_100) as

651: end loop;
652: end if;
653: end if;
654: end rosetta_table_copy_in_p35;
655: procedure rosetta_table_copy_out_p35(t okl_streams_util.var30tabtyp, a0 out nocopy JTF_VARCHAR2_TABLE_100) as
656: ddindx binary_integer; indx binary_integer;
657: begin
658: if t is null or t.count = 0 then
659: a0 := JTF_VARCHAR2_TABLE_100();

Line 678: procedure rosetta_table_copy_in_p36(t out nocopy okl_streams_util.var300tabtyp, a0 JTF_VARCHAR2_TABLE_300) as

674: end if;
675: end if;
676: end rosetta_table_copy_out_p35;
677:
678: procedure rosetta_table_copy_in_p36(t out nocopy okl_streams_util.var300tabtyp, a0 JTF_VARCHAR2_TABLE_300) as
679: ddindx binary_integer; indx binary_integer;
680: begin
681: if a0 is not null and a0.count > 0 then
682: if a0.count > 0 then

Line 696: procedure rosetta_table_copy_out_p36(t okl_streams_util.var300tabtyp, a0 out nocopy JTF_VARCHAR2_TABLE_300) as

692: end loop;
693: end if;
694: end if;
695: end rosetta_table_copy_in_p36;
696: procedure rosetta_table_copy_out_p36(t okl_streams_util.var300tabtyp, a0 out nocopy JTF_VARCHAR2_TABLE_300) as
697: ddindx binary_integer; indx binary_integer;
698: begin
699: if t is null or t.count = 0 then
700: a0 := JTF_VARCHAR2_TABLE_300();

Line 719: procedure rosetta_table_copy_in_p37(t out nocopy okl_streams_util.var40tabtyp, a0 JTF_VARCHAR2_TABLE_100) as

715: end if;
716: end if;
717: end rosetta_table_copy_out_p36;
718:
719: procedure rosetta_table_copy_in_p37(t out nocopy okl_streams_util.var40tabtyp, a0 JTF_VARCHAR2_TABLE_100) as
720: ddindx binary_integer; indx binary_integer;
721: begin
722: if a0 is not null and a0.count > 0 then
723: if a0.count > 0 then

Line 737: procedure rosetta_table_copy_out_p37(t okl_streams_util.var40tabtyp, a0 out nocopy JTF_VARCHAR2_TABLE_100) as

733: end loop;
734: end if;
735: end if;
736: end rosetta_table_copy_in_p37;
737: procedure rosetta_table_copy_out_p37(t okl_streams_util.var40tabtyp, a0 out nocopy JTF_VARCHAR2_TABLE_100) as
738: ddindx binary_integer; indx binary_integer;
739: begin
740: if t is null or t.count = 0 then
741: a0 := JTF_VARCHAR2_TABLE_100();

Line 760: procedure rosetta_table_copy_in_p38(t out nocopy okl_streams_util.var450tabtyp, a0 JTF_VARCHAR2_TABLE_500) as

756: end if;
757: end if;
758: end rosetta_table_copy_out_p37;
759:
760: procedure rosetta_table_copy_in_p38(t out nocopy okl_streams_util.var450tabtyp, a0 JTF_VARCHAR2_TABLE_500) as
761: ddindx binary_integer; indx binary_integer;
762: begin
763: if a0 is not null and a0.count > 0 then
764: if a0.count > 0 then

Line 778: procedure rosetta_table_copy_out_p38(t okl_streams_util.var450tabtyp, a0 out nocopy JTF_VARCHAR2_TABLE_500) as

774: end loop;
775: end if;
776: end if;
777: end rosetta_table_copy_in_p38;
778: procedure rosetta_table_copy_out_p38(t okl_streams_util.var450tabtyp, a0 out nocopy JTF_VARCHAR2_TABLE_500) as
779: ddindx binary_integer; indx binary_integer;
780: begin
781: if t is null or t.count = 0 then
782: a0 := JTF_VARCHAR2_TABLE_500();

Line 801: procedure rosetta_table_copy_in_p39(t out nocopy okl_streams_util.var50tabtyp, a0 JTF_VARCHAR2_TABLE_100) as

797: end if;
798: end if;
799: end rosetta_table_copy_out_p38;
800:
801: procedure rosetta_table_copy_in_p39(t out nocopy okl_streams_util.var50tabtyp, a0 JTF_VARCHAR2_TABLE_100) as
802: ddindx binary_integer; indx binary_integer;
803: begin
804: if a0 is not null and a0.count > 0 then
805: if a0.count > 0 then

Line 819: procedure rosetta_table_copy_out_p39(t okl_streams_util.var50tabtyp, a0 out nocopy JTF_VARCHAR2_TABLE_100) as

815: end loop;
816: end if;
817: end if;
818: end rosetta_table_copy_in_p39;
819: procedure rosetta_table_copy_out_p39(t okl_streams_util.var50tabtyp, a0 out nocopy JTF_VARCHAR2_TABLE_100) as
820: ddindx binary_integer; indx binary_integer;
821: begin
822: if t is null or t.count = 0 then
823: a0 := JTF_VARCHAR2_TABLE_100();

Line 842: procedure rosetta_table_copy_in_p40(t out nocopy okl_streams_util.var600tabtyp, a0 JTF_VARCHAR2_TABLE_600) as

838: end if;
839: end if;
840: end rosetta_table_copy_out_p39;
841:
842: procedure rosetta_table_copy_in_p40(t out nocopy okl_streams_util.var600tabtyp, a0 JTF_VARCHAR2_TABLE_600) as
843: ddindx binary_integer; indx binary_integer;
844: begin
845: if a0 is not null and a0.count > 0 then
846: if a0.count > 0 then

Line 860: procedure rosetta_table_copy_out_p40(t okl_streams_util.var600tabtyp, a0 out nocopy JTF_VARCHAR2_TABLE_600) as

856: end loop;
857: end if;
858: end if;
859: end rosetta_table_copy_in_p40;
860: procedure rosetta_table_copy_out_p40(t okl_streams_util.var600tabtyp, a0 out nocopy JTF_VARCHAR2_TABLE_600) as
861: ddindx binary_integer; indx binary_integer;
862: begin
863: if t is null or t.count = 0 then
864: a0 := JTF_VARCHAR2_TABLE_600();

Line 883: procedure rosetta_table_copy_in_p41(t out nocopy okl_streams_util.var75tabtyp, a0 JTF_VARCHAR2_TABLE_100) as

879: end if;
880: end if;
881: end rosetta_table_copy_out_p40;
882:
883: procedure rosetta_table_copy_in_p41(t out nocopy okl_streams_util.var75tabtyp, a0 JTF_VARCHAR2_TABLE_100) as
884: ddindx binary_integer; indx binary_integer;
885: begin
886: if a0 is not null and a0.count > 0 then
887: if a0.count > 0 then

Line 901: procedure rosetta_table_copy_out_p41(t okl_streams_util.var75tabtyp, a0 out nocopy JTF_VARCHAR2_TABLE_100) as

897: end loop;
898: end if;
899: end if;
900: end rosetta_table_copy_in_p41;
901: procedure rosetta_table_copy_out_p41(t okl_streams_util.var75tabtyp, a0 out nocopy JTF_VARCHAR2_TABLE_100) as
902: ddindx binary_integer; indx binary_integer;
903: begin
904: if t is null or t.count = 0 then
905: a0 := JTF_VARCHAR2_TABLE_100();

Line 924: procedure rosetta_table_copy_in_p42(t out nocopy okl_streams_util.var90tabtyp, a0 JTF_VARCHAR2_TABLE_100) as

920: end if;
921: end if;
922: end rosetta_table_copy_out_p41;
923:
924: procedure rosetta_table_copy_in_p42(t out nocopy okl_streams_util.var90tabtyp, a0 JTF_VARCHAR2_TABLE_100) as
925: ddindx binary_integer; indx binary_integer;
926: begin
927: if a0 is not null and a0.count > 0 then
928: if a0.count > 0 then

Line 942: procedure rosetta_table_copy_out_p42(t okl_streams_util.var90tabtyp, a0 out nocopy JTF_VARCHAR2_TABLE_100) as

938: end loop;
939: end if;
940: end if;
941: end rosetta_table_copy_in_p42;
942: procedure rosetta_table_copy_out_p42(t okl_streams_util.var90tabtyp, a0 out nocopy JTF_VARCHAR2_TABLE_100) as
943: ddindx binary_integer; indx binary_integer;
944: begin
945: if t is null or t.count = 0 then
946: a0 := JTF_VARCHAR2_TABLE_100();

Line 965: procedure rosetta_table_copy_in_p43(t out nocopy okl_streams_util.okl_strm_type_id_tbl_type, a0 JTF_NUMBER_TABLE) as

961: end if;
962: end if;
963: end rosetta_table_copy_out_p42;
964:
965: procedure rosetta_table_copy_in_p43(t out nocopy okl_streams_util.okl_strm_type_id_tbl_type, a0 JTF_NUMBER_TABLE) as
966: ddindx binary_integer; indx binary_integer;
967: begin
968: if a0 is not null and a0.count > 0 then
969: if a0.count > 0 then

Line 983: procedure rosetta_table_copy_out_p43(t okl_streams_util.okl_strm_type_id_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as

979: end loop;
980: end if;
981: end if;
982: end rosetta_table_copy_in_p43;
983: procedure rosetta_table_copy_out_p43(t okl_streams_util.okl_strm_type_id_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as
984: ddindx binary_integer; indx binary_integer;
985: begin
986: if t is null or t.count = 0 then
987: a0 := JTF_NUMBER_TABLE();

Line 1013: ddp_msgs_tbl okl_streams_util.log_msg_tbl;

1009: , x_return_status out nocopy VARCHAR2
1010: )
1011:
1012: as
1013: ddp_msgs_tbl okl_streams_util.log_msg_tbl;
1014: ddindx binary_integer; indx binary_integer;
1015: begin
1016:
1017: -- copy data to the local IN or IN-OUT args, if any

Line 1018: okl_streams_util_w.rosetta_table_copy_in_p1(ddp_msgs_tbl, p_msgs_tbl);

1014: ddindx binary_integer; indx binary_integer;
1015: begin
1016:
1017: -- copy data to the local IN or IN-OUT args, if any
1018: okl_streams_util_w.rosetta_table_copy_in_p1(ddp_msgs_tbl, p_msgs_tbl);
1019:
1020:
1021:
1022:

Line 1024: okl_streams_util.log_message(ddp_msgs_tbl,

1020:
1021:
1022:
1023: -- here's the delegated call to the old PL/SQL routine
1024: okl_streams_util.log_message(ddp_msgs_tbl,
1025: p_translate,
1026: p_file_name,
1027: x_return_status);
1028:

Line 1035: end okl_streams_util_w;

1031:
1032:
1033: end;
1034:
1035: end okl_streams_util_w;