2: /* $Header: OKLIEVEB.pls 120.0 2005/07/07 10:39:26 viselvar noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_eve_pvt.okl_eve_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_eve_pvt.okl_eve_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_500
23: , a20 JTF_VARCHAR2_TABLE_500
24: , a21 JTF_VARCHAR2_TABLE_500
25: , a22 JTF_VARCHAR2_TABLE_500
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_DATE_TABLE
28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_DATE_TABLE
30: , a27 JTF_NUMBER_TABLE
31: ) as
25: , a22 JTF_VARCHAR2_TABLE_500
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_DATE_TABLE
28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_DATE_TABLE
30: , a27 JTF_NUMBER_TABLE
31: ) as
32: ddindx binary_integer; indx binary_integer;
33: begin
75: end rosetta_table_copy_in_p1;
76: procedure rosetta_table_copy_out_p1(t okl_eve_pvt.okl_eve_tbl, a0 out nocopy JTF_NUMBER_TABLE
77: , a1 out nocopy JTF_NUMBER_TABLE
78: , a2 out nocopy JTF_VARCHAR2_TABLE_100
79: , a3 out nocopy JTF_DATE_TABLE
80: , a4 out nocopy JTF_DATE_TABLE
81: , a5 out nocopy JTF_VARCHAR2_TABLE_100
82: , a6 out nocopy JTF_NUMBER_TABLE
83: , a7 out nocopy JTF_VARCHAR2_TABLE_100
76: procedure rosetta_table_copy_out_p1(t okl_eve_pvt.okl_eve_tbl, a0 out nocopy JTF_NUMBER_TABLE
77: , a1 out nocopy JTF_NUMBER_TABLE
78: , a2 out nocopy JTF_VARCHAR2_TABLE_100
79: , a3 out nocopy JTF_DATE_TABLE
80: , a4 out nocopy JTF_DATE_TABLE
81: , a5 out nocopy JTF_VARCHAR2_TABLE_100
82: , a6 out nocopy JTF_NUMBER_TABLE
83: , a7 out nocopy JTF_VARCHAR2_TABLE_100
84: , a8 out nocopy JTF_VARCHAR2_TABLE_500
96: , a20 out nocopy JTF_VARCHAR2_TABLE_500
97: , a21 out nocopy JTF_VARCHAR2_TABLE_500
98: , a22 out nocopy JTF_VARCHAR2_TABLE_500
99: , a23 out nocopy JTF_NUMBER_TABLE
100: , a24 out nocopy JTF_DATE_TABLE
101: , a25 out nocopy JTF_NUMBER_TABLE
102: , a26 out nocopy JTF_DATE_TABLE
103: , a27 out nocopy JTF_NUMBER_TABLE
104: ) as
98: , a22 out nocopy JTF_VARCHAR2_TABLE_500
99: , a23 out nocopy JTF_NUMBER_TABLE
100: , a24 out nocopy JTF_DATE_TABLE
101: , a25 out nocopy JTF_NUMBER_TABLE
102: , a26 out nocopy JTF_DATE_TABLE
103: , a27 out nocopy JTF_NUMBER_TABLE
104: ) as
105: ddindx binary_integer; indx binary_integer;
106: begin
107: if t is null or t.count = 0 then
108: a0 := JTF_NUMBER_TABLE();
109: a1 := JTF_NUMBER_TABLE();
110: a2 := JTF_VARCHAR2_TABLE_100();
111: a3 := JTF_DATE_TABLE();
112: a4 := JTF_DATE_TABLE();
113: a5 := JTF_VARCHAR2_TABLE_100();
114: a6 := JTF_NUMBER_TABLE();
115: a7 := JTF_VARCHAR2_TABLE_100();
108: a0 := JTF_NUMBER_TABLE();
109: a1 := JTF_NUMBER_TABLE();
110: a2 := JTF_VARCHAR2_TABLE_100();
111: a3 := JTF_DATE_TABLE();
112: a4 := JTF_DATE_TABLE();
113: a5 := JTF_VARCHAR2_TABLE_100();
114: a6 := JTF_NUMBER_TABLE();
115: a7 := JTF_VARCHAR2_TABLE_100();
116: a8 := JTF_VARCHAR2_TABLE_500();
128: a20 := JTF_VARCHAR2_TABLE_500();
129: a21 := JTF_VARCHAR2_TABLE_500();
130: a22 := JTF_VARCHAR2_TABLE_500();
131: a23 := JTF_NUMBER_TABLE();
132: a24 := JTF_DATE_TABLE();
133: a25 := JTF_NUMBER_TABLE();
134: a26 := JTF_DATE_TABLE();
135: a27 := JTF_NUMBER_TABLE();
136: else
130: a22 := JTF_VARCHAR2_TABLE_500();
131: a23 := JTF_NUMBER_TABLE();
132: a24 := JTF_DATE_TABLE();
133: a25 := JTF_NUMBER_TABLE();
134: a26 := JTF_DATE_TABLE();
135: a27 := JTF_NUMBER_TABLE();
136: else
137: a0 := JTF_NUMBER_TABLE();
138: a1 := JTF_NUMBER_TABLE();
136: else
137: a0 := JTF_NUMBER_TABLE();
138: a1 := JTF_NUMBER_TABLE();
139: a2 := JTF_VARCHAR2_TABLE_100();
140: a3 := JTF_DATE_TABLE();
141: a4 := JTF_DATE_TABLE();
142: a5 := JTF_VARCHAR2_TABLE_100();
143: a6 := JTF_NUMBER_TABLE();
144: a7 := JTF_VARCHAR2_TABLE_100();
137: a0 := JTF_NUMBER_TABLE();
138: a1 := JTF_NUMBER_TABLE();
139: a2 := JTF_VARCHAR2_TABLE_100();
140: a3 := JTF_DATE_TABLE();
141: a4 := JTF_DATE_TABLE();
142: a5 := JTF_VARCHAR2_TABLE_100();
143: a6 := JTF_NUMBER_TABLE();
144: a7 := JTF_VARCHAR2_TABLE_100();
145: a8 := JTF_VARCHAR2_TABLE_500();
157: a20 := JTF_VARCHAR2_TABLE_500();
158: a21 := JTF_VARCHAR2_TABLE_500();
159: a22 := JTF_VARCHAR2_TABLE_500();
160: a23 := JTF_NUMBER_TABLE();
161: a24 := JTF_DATE_TABLE();
162: a25 := JTF_NUMBER_TABLE();
163: a26 := JTF_DATE_TABLE();
164: a27 := JTF_NUMBER_TABLE();
165: if t.count > 0 then
159: a22 := JTF_VARCHAR2_TABLE_500();
160: a23 := JTF_NUMBER_TABLE();
161: a24 := JTF_DATE_TABLE();
162: a25 := JTF_NUMBER_TABLE();
163: a26 := JTF_DATE_TABLE();
164: a27 := JTF_NUMBER_TABLE();
165: if t.count > 0 then
166: a0.extend(t.count);
167: a1.extend(t.count);
390: , x_msg_data out nocopy VARCHAR2
391: , p5_a0 JTF_NUMBER_TABLE
392: , p5_a1 JTF_NUMBER_TABLE
393: , p5_a2 JTF_VARCHAR2_TABLE_100
394: , p5_a3 JTF_DATE_TABLE
395: , p5_a4 JTF_DATE_TABLE
396: , p5_a5 JTF_VARCHAR2_TABLE_100
397: , p5_a6 JTF_NUMBER_TABLE
398: , p5_a7 JTF_VARCHAR2_TABLE_100
391: , p5_a0 JTF_NUMBER_TABLE
392: , p5_a1 JTF_NUMBER_TABLE
393: , p5_a2 JTF_VARCHAR2_TABLE_100
394: , p5_a3 JTF_DATE_TABLE
395: , p5_a4 JTF_DATE_TABLE
396: , p5_a5 JTF_VARCHAR2_TABLE_100
397: , p5_a6 JTF_NUMBER_TABLE
398: , p5_a7 JTF_VARCHAR2_TABLE_100
399: , p5_a8 JTF_VARCHAR2_TABLE_500
411: , p5_a20 JTF_VARCHAR2_TABLE_500
412: , p5_a21 JTF_VARCHAR2_TABLE_500
413: , p5_a22 JTF_VARCHAR2_TABLE_500
414: , p5_a23 JTF_NUMBER_TABLE
415: , p5_a24 JTF_DATE_TABLE
416: , p5_a25 JTF_NUMBER_TABLE
417: , p5_a26 JTF_DATE_TABLE
418: , p5_a27 JTF_NUMBER_TABLE
419: , p6_a0 out nocopy JTF_NUMBER_TABLE
413: , p5_a22 JTF_VARCHAR2_TABLE_500
414: , p5_a23 JTF_NUMBER_TABLE
415: , p5_a24 JTF_DATE_TABLE
416: , p5_a25 JTF_NUMBER_TABLE
417: , p5_a26 JTF_DATE_TABLE
418: , p5_a27 JTF_NUMBER_TABLE
419: , p6_a0 out nocopy JTF_NUMBER_TABLE
420: , p6_a1 out nocopy JTF_NUMBER_TABLE
421: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
418: , p5_a27 JTF_NUMBER_TABLE
419: , p6_a0 out nocopy JTF_NUMBER_TABLE
420: , p6_a1 out nocopy JTF_NUMBER_TABLE
421: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
422: , p6_a3 out nocopy JTF_DATE_TABLE
423: , p6_a4 out nocopy JTF_DATE_TABLE
424: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
425: , p6_a6 out nocopy JTF_NUMBER_TABLE
426: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
419: , p6_a0 out nocopy JTF_NUMBER_TABLE
420: , p6_a1 out nocopy JTF_NUMBER_TABLE
421: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
422: , p6_a3 out nocopy JTF_DATE_TABLE
423: , p6_a4 out nocopy JTF_DATE_TABLE
424: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
425: , p6_a6 out nocopy JTF_NUMBER_TABLE
426: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
427: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500
439: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
440: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
441: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
442: , p6_a23 out nocopy JTF_NUMBER_TABLE
443: , p6_a24 out nocopy JTF_DATE_TABLE
444: , p6_a25 out nocopy JTF_NUMBER_TABLE
445: , p6_a26 out nocopy JTF_DATE_TABLE
446: , p6_a27 out nocopy JTF_NUMBER_TABLE
447: )
441: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
442: , p6_a23 out nocopy JTF_NUMBER_TABLE
443: , p6_a24 out nocopy JTF_DATE_TABLE
444: , p6_a25 out nocopy JTF_NUMBER_TABLE
445: , p6_a26 out nocopy JTF_DATE_TABLE
446: , p6_a27 out nocopy JTF_NUMBER_TABLE
447: )
448:
449: as
694: , x_msg_data out nocopy VARCHAR2
695: , p5_a0 JTF_NUMBER_TABLE
696: , p5_a1 JTF_NUMBER_TABLE
697: , p5_a2 JTF_VARCHAR2_TABLE_100
698: , p5_a3 JTF_DATE_TABLE
699: , p5_a4 JTF_DATE_TABLE
700: , p5_a5 JTF_VARCHAR2_TABLE_100
701: , p5_a6 JTF_NUMBER_TABLE
702: , p5_a7 JTF_VARCHAR2_TABLE_100
695: , p5_a0 JTF_NUMBER_TABLE
696: , p5_a1 JTF_NUMBER_TABLE
697: , p5_a2 JTF_VARCHAR2_TABLE_100
698: , p5_a3 JTF_DATE_TABLE
699: , p5_a4 JTF_DATE_TABLE
700: , p5_a5 JTF_VARCHAR2_TABLE_100
701: , p5_a6 JTF_NUMBER_TABLE
702: , p5_a7 JTF_VARCHAR2_TABLE_100
703: , p5_a8 JTF_VARCHAR2_TABLE_500
715: , p5_a20 JTF_VARCHAR2_TABLE_500
716: , p5_a21 JTF_VARCHAR2_TABLE_500
717: , p5_a22 JTF_VARCHAR2_TABLE_500
718: , p5_a23 JTF_NUMBER_TABLE
719: , p5_a24 JTF_DATE_TABLE
720: , p5_a25 JTF_NUMBER_TABLE
721: , p5_a26 JTF_DATE_TABLE
722: , p5_a27 JTF_NUMBER_TABLE
723: , p6_a0 out nocopy JTF_NUMBER_TABLE
717: , p5_a22 JTF_VARCHAR2_TABLE_500
718: , p5_a23 JTF_NUMBER_TABLE
719: , p5_a24 JTF_DATE_TABLE
720: , p5_a25 JTF_NUMBER_TABLE
721: , p5_a26 JTF_DATE_TABLE
722: , p5_a27 JTF_NUMBER_TABLE
723: , p6_a0 out nocopy JTF_NUMBER_TABLE
724: , p6_a1 out nocopy JTF_NUMBER_TABLE
725: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
722: , p5_a27 JTF_NUMBER_TABLE
723: , p6_a0 out nocopy JTF_NUMBER_TABLE
724: , p6_a1 out nocopy JTF_NUMBER_TABLE
725: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
726: , p6_a3 out nocopy JTF_DATE_TABLE
727: , p6_a4 out nocopy JTF_DATE_TABLE
728: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
729: , p6_a6 out nocopy JTF_NUMBER_TABLE
730: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
723: , p6_a0 out nocopy JTF_NUMBER_TABLE
724: , p6_a1 out nocopy JTF_NUMBER_TABLE
725: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
726: , p6_a3 out nocopy JTF_DATE_TABLE
727: , p6_a4 out nocopy JTF_DATE_TABLE
728: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
729: , p6_a6 out nocopy JTF_NUMBER_TABLE
730: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
731: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500
743: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
744: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
745: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
746: , p6_a23 out nocopy JTF_NUMBER_TABLE
747: , p6_a24 out nocopy JTF_DATE_TABLE
748: , p6_a25 out nocopy JTF_NUMBER_TABLE
749: , p6_a26 out nocopy JTF_DATE_TABLE
750: , p6_a27 out nocopy JTF_NUMBER_TABLE
751: )
745: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
746: , p6_a23 out nocopy JTF_NUMBER_TABLE
747: , p6_a24 out nocopy JTF_DATE_TABLE
748: , p6_a25 out nocopy JTF_NUMBER_TABLE
749: , p6_a26 out nocopy JTF_DATE_TABLE
750: , p6_a27 out nocopy JTF_NUMBER_TABLE
751: )
752:
753: as
938: , x_msg_data out nocopy VARCHAR2
939: , p5_a0 JTF_NUMBER_TABLE
940: , p5_a1 JTF_NUMBER_TABLE
941: , p5_a2 JTF_VARCHAR2_TABLE_100
942: , p5_a3 JTF_DATE_TABLE
943: , p5_a4 JTF_DATE_TABLE
944: , p5_a5 JTF_VARCHAR2_TABLE_100
945: , p5_a6 JTF_NUMBER_TABLE
946: , p5_a7 JTF_VARCHAR2_TABLE_100
939: , p5_a0 JTF_NUMBER_TABLE
940: , p5_a1 JTF_NUMBER_TABLE
941: , p5_a2 JTF_VARCHAR2_TABLE_100
942: , p5_a3 JTF_DATE_TABLE
943: , p5_a4 JTF_DATE_TABLE
944: , p5_a5 JTF_VARCHAR2_TABLE_100
945: , p5_a6 JTF_NUMBER_TABLE
946: , p5_a7 JTF_VARCHAR2_TABLE_100
947: , p5_a8 JTF_VARCHAR2_TABLE_500
959: , p5_a20 JTF_VARCHAR2_TABLE_500
960: , p5_a21 JTF_VARCHAR2_TABLE_500
961: , p5_a22 JTF_VARCHAR2_TABLE_500
962: , p5_a23 JTF_NUMBER_TABLE
963: , p5_a24 JTF_DATE_TABLE
964: , p5_a25 JTF_NUMBER_TABLE
965: , p5_a26 JTF_DATE_TABLE
966: , p5_a27 JTF_NUMBER_TABLE
967: )
961: , p5_a22 JTF_VARCHAR2_TABLE_500
962: , p5_a23 JTF_NUMBER_TABLE
963: , p5_a24 JTF_DATE_TABLE
964: , p5_a25 JTF_NUMBER_TABLE
965: , p5_a26 JTF_DATE_TABLE
966: , p5_a27 JTF_NUMBER_TABLE
967: )
968:
969: as