9: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
10: return d;
11: end;
12:
13: procedure rosetta_table_copy_in_p4(t out nocopy oks_entitlements_pub.apl_tbl_type, a0 JTF_NUMBER_TABLE
14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_NUMBER_TABLE
16: , a3 JTF_NUMBER_TABLE
17: , a4 JTF_NUMBER_TABLE
10: return d;
11: end;
12:
13: procedure rosetta_table_copy_in_p4(t out nocopy oks_entitlements_pub.apl_tbl_type, a0 JTF_NUMBER_TABLE
14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_NUMBER_TABLE
16: , a3 JTF_NUMBER_TABLE
17: , a4 JTF_NUMBER_TABLE
18: , a5 JTF_NUMBER_TABLE
11: end;
12:
13: procedure rosetta_table_copy_in_p4(t out nocopy oks_entitlements_pub.apl_tbl_type, a0 JTF_NUMBER_TABLE
14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_NUMBER_TABLE
16: , a3 JTF_NUMBER_TABLE
17: , a4 JTF_NUMBER_TABLE
18: , a5 JTF_NUMBER_TABLE
19: , a6 JTF_NUMBER_TABLE
12:
13: procedure rosetta_table_copy_in_p4(t out nocopy oks_entitlements_pub.apl_tbl_type, a0 JTF_NUMBER_TABLE
14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_NUMBER_TABLE
16: , a3 JTF_NUMBER_TABLE
17: , a4 JTF_NUMBER_TABLE
18: , a5 JTF_NUMBER_TABLE
19: , a6 JTF_NUMBER_TABLE
20: ) as
13: procedure rosetta_table_copy_in_p4(t out nocopy oks_entitlements_pub.apl_tbl_type, a0 JTF_NUMBER_TABLE
14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_NUMBER_TABLE
16: , a3 JTF_NUMBER_TABLE
17: , a4 JTF_NUMBER_TABLE
18: , a5 JTF_NUMBER_TABLE
19: , a6 JTF_NUMBER_TABLE
20: ) as
21: ddindx binary_integer; indx binary_integer;
14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_NUMBER_TABLE
16: , a3 JTF_NUMBER_TABLE
17: , a4 JTF_NUMBER_TABLE
18: , a5 JTF_NUMBER_TABLE
19: , a6 JTF_NUMBER_TABLE
20: ) as
21: ddindx binary_integer; indx binary_integer;
22: begin
15: , a2 JTF_NUMBER_TABLE
16: , a3 JTF_NUMBER_TABLE
17: , a4 JTF_NUMBER_TABLE
18: , a5 JTF_NUMBER_TABLE
19: , a6 JTF_NUMBER_TABLE
20: ) as
21: ddindx binary_integer; indx binary_integer;
22: begin
23: if a0 is not null and a0.count > 0 then
40: end loop;
41: end if;
42: end if;
43: end rosetta_table_copy_in_p4;
44: procedure rosetta_table_copy_out_p4(t oks_entitlements_pub.apl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
45: , a1 out nocopy JTF_NUMBER_TABLE
46: , a2 out nocopy JTF_NUMBER_TABLE
47: , a3 out nocopy JTF_NUMBER_TABLE
48: , a4 out nocopy JTF_NUMBER_TABLE
41: end if;
42: end if;
43: end rosetta_table_copy_in_p4;
44: procedure rosetta_table_copy_out_p4(t oks_entitlements_pub.apl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
45: , a1 out nocopy JTF_NUMBER_TABLE
46: , a2 out nocopy JTF_NUMBER_TABLE
47: , a3 out nocopy JTF_NUMBER_TABLE
48: , a4 out nocopy JTF_NUMBER_TABLE
49: , a5 out nocopy JTF_NUMBER_TABLE
42: end if;
43: end rosetta_table_copy_in_p4;
44: procedure rosetta_table_copy_out_p4(t oks_entitlements_pub.apl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
45: , a1 out nocopy JTF_NUMBER_TABLE
46: , a2 out nocopy JTF_NUMBER_TABLE
47: , a3 out nocopy JTF_NUMBER_TABLE
48: , a4 out nocopy JTF_NUMBER_TABLE
49: , a5 out nocopy JTF_NUMBER_TABLE
50: , a6 out nocopy JTF_NUMBER_TABLE
43: end rosetta_table_copy_in_p4;
44: procedure rosetta_table_copy_out_p4(t oks_entitlements_pub.apl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
45: , a1 out nocopy JTF_NUMBER_TABLE
46: , a2 out nocopy JTF_NUMBER_TABLE
47: , a3 out nocopy JTF_NUMBER_TABLE
48: , a4 out nocopy JTF_NUMBER_TABLE
49: , a5 out nocopy JTF_NUMBER_TABLE
50: , a6 out nocopy JTF_NUMBER_TABLE
51: ) as
44: procedure rosetta_table_copy_out_p4(t oks_entitlements_pub.apl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
45: , a1 out nocopy JTF_NUMBER_TABLE
46: , a2 out nocopy JTF_NUMBER_TABLE
47: , a3 out nocopy JTF_NUMBER_TABLE
48: , a4 out nocopy JTF_NUMBER_TABLE
49: , a5 out nocopy JTF_NUMBER_TABLE
50: , a6 out nocopy JTF_NUMBER_TABLE
51: ) as
52: ddindx binary_integer; indx binary_integer;
45: , a1 out nocopy JTF_NUMBER_TABLE
46: , a2 out nocopy JTF_NUMBER_TABLE
47: , a3 out nocopy JTF_NUMBER_TABLE
48: , a4 out nocopy JTF_NUMBER_TABLE
49: , a5 out nocopy JTF_NUMBER_TABLE
50: , a6 out nocopy JTF_NUMBER_TABLE
51: ) as
52: ddindx binary_integer; indx binary_integer;
53: begin
46: , a2 out nocopy JTF_NUMBER_TABLE
47: , a3 out nocopy JTF_NUMBER_TABLE
48: , a4 out nocopy JTF_NUMBER_TABLE
49: , a5 out nocopy JTF_NUMBER_TABLE
50: , a6 out nocopy JTF_NUMBER_TABLE
51: ) as
52: ddindx binary_integer; indx binary_integer;
53: begin
54: if t is null or t.count = 0 then
51: ) as
52: ddindx binary_integer; indx binary_integer;
53: begin
54: if t is null or t.count = 0 then
55: a0 := JTF_NUMBER_TABLE();
56: a1 := JTF_NUMBER_TABLE();
57: a2 := JTF_NUMBER_TABLE();
58: a3 := JTF_NUMBER_TABLE();
59: a4 := JTF_NUMBER_TABLE();
52: ddindx binary_integer; indx binary_integer;
53: begin
54: if t is null or t.count = 0 then
55: a0 := JTF_NUMBER_TABLE();
56: a1 := JTF_NUMBER_TABLE();
57: a2 := JTF_NUMBER_TABLE();
58: a3 := JTF_NUMBER_TABLE();
59: a4 := JTF_NUMBER_TABLE();
60: a5 := JTF_NUMBER_TABLE();
53: begin
54: if t is null or t.count = 0 then
55: a0 := JTF_NUMBER_TABLE();
56: a1 := JTF_NUMBER_TABLE();
57: a2 := JTF_NUMBER_TABLE();
58: a3 := JTF_NUMBER_TABLE();
59: a4 := JTF_NUMBER_TABLE();
60: a5 := JTF_NUMBER_TABLE();
61: a6 := JTF_NUMBER_TABLE();
54: if t is null or t.count = 0 then
55: a0 := JTF_NUMBER_TABLE();
56: a1 := JTF_NUMBER_TABLE();
57: a2 := JTF_NUMBER_TABLE();
58: a3 := JTF_NUMBER_TABLE();
59: a4 := JTF_NUMBER_TABLE();
60: a5 := JTF_NUMBER_TABLE();
61: a6 := JTF_NUMBER_TABLE();
62: else
55: a0 := JTF_NUMBER_TABLE();
56: a1 := JTF_NUMBER_TABLE();
57: a2 := JTF_NUMBER_TABLE();
58: a3 := JTF_NUMBER_TABLE();
59: a4 := JTF_NUMBER_TABLE();
60: a5 := JTF_NUMBER_TABLE();
61: a6 := JTF_NUMBER_TABLE();
62: else
63: a0 := JTF_NUMBER_TABLE();
56: a1 := JTF_NUMBER_TABLE();
57: a2 := JTF_NUMBER_TABLE();
58: a3 := JTF_NUMBER_TABLE();
59: a4 := JTF_NUMBER_TABLE();
60: a5 := JTF_NUMBER_TABLE();
61: a6 := JTF_NUMBER_TABLE();
62: else
63: a0 := JTF_NUMBER_TABLE();
64: a1 := JTF_NUMBER_TABLE();
57: a2 := JTF_NUMBER_TABLE();
58: a3 := JTF_NUMBER_TABLE();
59: a4 := JTF_NUMBER_TABLE();
60: a5 := JTF_NUMBER_TABLE();
61: a6 := JTF_NUMBER_TABLE();
62: else
63: a0 := JTF_NUMBER_TABLE();
64: a1 := JTF_NUMBER_TABLE();
65: a2 := JTF_NUMBER_TABLE();
59: a4 := JTF_NUMBER_TABLE();
60: a5 := JTF_NUMBER_TABLE();
61: a6 := JTF_NUMBER_TABLE();
62: else
63: a0 := JTF_NUMBER_TABLE();
64: a1 := JTF_NUMBER_TABLE();
65: a2 := JTF_NUMBER_TABLE();
66: a3 := JTF_NUMBER_TABLE();
67: a4 := JTF_NUMBER_TABLE();
60: a5 := JTF_NUMBER_TABLE();
61: a6 := JTF_NUMBER_TABLE();
62: else
63: a0 := JTF_NUMBER_TABLE();
64: a1 := JTF_NUMBER_TABLE();
65: a2 := JTF_NUMBER_TABLE();
66: a3 := JTF_NUMBER_TABLE();
67: a4 := JTF_NUMBER_TABLE();
68: a5 := JTF_NUMBER_TABLE();
61: a6 := JTF_NUMBER_TABLE();
62: else
63: a0 := JTF_NUMBER_TABLE();
64: a1 := JTF_NUMBER_TABLE();
65: a2 := JTF_NUMBER_TABLE();
66: a3 := JTF_NUMBER_TABLE();
67: a4 := JTF_NUMBER_TABLE();
68: a5 := JTF_NUMBER_TABLE();
69: a6 := JTF_NUMBER_TABLE();
62: else
63: a0 := JTF_NUMBER_TABLE();
64: a1 := JTF_NUMBER_TABLE();
65: a2 := JTF_NUMBER_TABLE();
66: a3 := JTF_NUMBER_TABLE();
67: a4 := JTF_NUMBER_TABLE();
68: a5 := JTF_NUMBER_TABLE();
69: a6 := JTF_NUMBER_TABLE();
70: if t.count > 0 then
63: a0 := JTF_NUMBER_TABLE();
64: a1 := JTF_NUMBER_TABLE();
65: a2 := JTF_NUMBER_TABLE();
66: a3 := JTF_NUMBER_TABLE();
67: a4 := JTF_NUMBER_TABLE();
68: a5 := JTF_NUMBER_TABLE();
69: a6 := JTF_NUMBER_TABLE();
70: if t.count > 0 then
71: a0.extend(t.count);
64: a1 := JTF_NUMBER_TABLE();
65: a2 := JTF_NUMBER_TABLE();
66: a3 := JTF_NUMBER_TABLE();
67: a4 := JTF_NUMBER_TABLE();
68: a5 := JTF_NUMBER_TABLE();
69: a6 := JTF_NUMBER_TABLE();
70: if t.count > 0 then
71: a0.extend(t.count);
72: a1.extend(t.count);
65: a2 := JTF_NUMBER_TABLE();
66: a3 := JTF_NUMBER_TABLE();
67: a4 := JTF_NUMBER_TABLE();
68: a5 := JTF_NUMBER_TABLE();
69: a6 := JTF_NUMBER_TABLE();
70: if t.count > 0 then
71: a0.extend(t.count);
72: a1.extend(t.count);
73: a2.extend(t.count);
94: end if;
95: end if;
96: end rosetta_table_copy_out_p4;
97:
98: procedure rosetta_table_copy_in_p16(t out nocopy oks_entitlements_pub.hdr_tbl_type, a0 JTF_NUMBER_TABLE
99: , a1 JTF_NUMBER_TABLE
100: , a2 JTF_VARCHAR2_TABLE_200
101: , a3 JTF_VARCHAR2_TABLE_200
102: , a4 JTF_VARCHAR2_TABLE_600
95: end if;
96: end rosetta_table_copy_out_p4;
97:
98: procedure rosetta_table_copy_in_p16(t out nocopy oks_entitlements_pub.hdr_tbl_type, a0 JTF_NUMBER_TABLE
99: , a1 JTF_NUMBER_TABLE
100: , a2 JTF_VARCHAR2_TABLE_200
101: , a3 JTF_VARCHAR2_TABLE_200
102: , a4 JTF_VARCHAR2_TABLE_600
103: , a5 JTF_NUMBER_TABLE
99: , a1 JTF_NUMBER_TABLE
100: , a2 JTF_VARCHAR2_TABLE_200
101: , a3 JTF_VARCHAR2_TABLE_200
102: , a4 JTF_VARCHAR2_TABLE_600
103: , a5 JTF_NUMBER_TABLE
104: , a6 JTF_VARCHAR2_TABLE_100
105: , a7 JTF_VARCHAR2_TABLE_100
106: , a8 JTF_NUMBER_TABLE
107: , a9 JTF_VARCHAR2_TABLE_100
102: , a4 JTF_VARCHAR2_TABLE_600
103: , a5 JTF_NUMBER_TABLE
104: , a6 JTF_VARCHAR2_TABLE_100
105: , a7 JTF_VARCHAR2_TABLE_100
106: , a8 JTF_NUMBER_TABLE
107: , a9 JTF_VARCHAR2_TABLE_100
108: , a10 JTF_VARCHAR2_TABLE_200
109: , a11 JTF_NUMBER_TABLE
110: , a12 JTF_VARCHAR2_TABLE_100
105: , a7 JTF_VARCHAR2_TABLE_100
106: , a8 JTF_NUMBER_TABLE
107: , a9 JTF_VARCHAR2_TABLE_100
108: , a10 JTF_VARCHAR2_TABLE_200
109: , a11 JTF_NUMBER_TABLE
110: , a12 JTF_VARCHAR2_TABLE_100
111: , a13 JTF_DATE_TABLE
112: , a14 JTF_DATE_TABLE
113: , a15 JTF_NUMBER_TABLE
109: , a11 JTF_NUMBER_TABLE
110: , a12 JTF_VARCHAR2_TABLE_100
111: , a13 JTF_DATE_TABLE
112: , a14 JTF_DATE_TABLE
113: , a15 JTF_NUMBER_TABLE
114: , a16 JTF_NUMBER_TABLE
115: , a17 JTF_NUMBER_TABLE
116: , a18 JTF_NUMBER_TABLE
117: , a19 JTF_NUMBER_TABLE
110: , a12 JTF_VARCHAR2_TABLE_100
111: , a13 JTF_DATE_TABLE
112: , a14 JTF_DATE_TABLE
113: , a15 JTF_NUMBER_TABLE
114: , a16 JTF_NUMBER_TABLE
115: , a17 JTF_NUMBER_TABLE
116: , a18 JTF_NUMBER_TABLE
117: , a19 JTF_NUMBER_TABLE
118: , a20 JTF_VARCHAR2_TABLE_100
111: , a13 JTF_DATE_TABLE
112: , a14 JTF_DATE_TABLE
113: , a15 JTF_NUMBER_TABLE
114: , a16 JTF_NUMBER_TABLE
115: , a17 JTF_NUMBER_TABLE
116: , a18 JTF_NUMBER_TABLE
117: , a19 JTF_NUMBER_TABLE
118: , a20 JTF_VARCHAR2_TABLE_100
119: , a21 JTF_NUMBER_TABLE
112: , a14 JTF_DATE_TABLE
113: , a15 JTF_NUMBER_TABLE
114: , a16 JTF_NUMBER_TABLE
115: , a17 JTF_NUMBER_TABLE
116: , a18 JTF_NUMBER_TABLE
117: , a19 JTF_NUMBER_TABLE
118: , a20 JTF_VARCHAR2_TABLE_100
119: , a21 JTF_NUMBER_TABLE
120: , a22 JTF_NUMBER_TABLE
113: , a15 JTF_NUMBER_TABLE
114: , a16 JTF_NUMBER_TABLE
115: , a17 JTF_NUMBER_TABLE
116: , a18 JTF_NUMBER_TABLE
117: , a19 JTF_NUMBER_TABLE
118: , a20 JTF_VARCHAR2_TABLE_100
119: , a21 JTF_NUMBER_TABLE
120: , a22 JTF_NUMBER_TABLE
121: , a23 JTF_NUMBER_TABLE
115: , a17 JTF_NUMBER_TABLE
116: , a18 JTF_NUMBER_TABLE
117: , a19 JTF_NUMBER_TABLE
118: , a20 JTF_VARCHAR2_TABLE_100
119: , a21 JTF_NUMBER_TABLE
120: , a22 JTF_NUMBER_TABLE
121: , a23 JTF_NUMBER_TABLE
122: , a24 JTF_VARCHAR2_TABLE_200
123: , a25 JTF_NUMBER_TABLE
116: , a18 JTF_NUMBER_TABLE
117: , a19 JTF_NUMBER_TABLE
118: , a20 JTF_VARCHAR2_TABLE_100
119: , a21 JTF_NUMBER_TABLE
120: , a22 JTF_NUMBER_TABLE
121: , a23 JTF_NUMBER_TABLE
122: , a24 JTF_VARCHAR2_TABLE_200
123: , a25 JTF_NUMBER_TABLE
124: , a26 JTF_VARCHAR2_TABLE_100
117: , a19 JTF_NUMBER_TABLE
118: , a20 JTF_VARCHAR2_TABLE_100
119: , a21 JTF_NUMBER_TABLE
120: , a22 JTF_NUMBER_TABLE
121: , a23 JTF_NUMBER_TABLE
122: , a24 JTF_VARCHAR2_TABLE_200
123: , a25 JTF_NUMBER_TABLE
124: , a26 JTF_VARCHAR2_TABLE_100
125: , a27 JTF_VARCHAR2_TABLE_100
119: , a21 JTF_NUMBER_TABLE
120: , a22 JTF_NUMBER_TABLE
121: , a23 JTF_NUMBER_TABLE
122: , a24 JTF_VARCHAR2_TABLE_200
123: , a25 JTF_NUMBER_TABLE
124: , a26 JTF_VARCHAR2_TABLE_100
125: , a27 JTF_VARCHAR2_TABLE_100
126: , a28 JTF_NUMBER_TABLE
127: , a29 JTF_DATE_TABLE
122: , a24 JTF_VARCHAR2_TABLE_200
123: , a25 JTF_NUMBER_TABLE
124: , a26 JTF_VARCHAR2_TABLE_100
125: , a27 JTF_VARCHAR2_TABLE_100
126: , a28 JTF_NUMBER_TABLE
127: , a29 JTF_DATE_TABLE
128: , a30 JTF_DATE_TABLE
129: , a31 JTF_NUMBER_TABLE
130: , a32 JTF_NUMBER_TABLE
125: , a27 JTF_VARCHAR2_TABLE_100
126: , a28 JTF_NUMBER_TABLE
127: , a29 JTF_DATE_TABLE
128: , a30 JTF_DATE_TABLE
129: , a31 JTF_NUMBER_TABLE
130: , a32 JTF_NUMBER_TABLE
131: , a33 JTF_CLOB_TABLE
132: , a34 JTF_CLOB_TABLE
133: , a35 JTF_VARCHAR2_TABLE_500
126: , a28 JTF_NUMBER_TABLE
127: , a29 JTF_DATE_TABLE
128: , a30 JTF_DATE_TABLE
129: , a31 JTF_NUMBER_TABLE
130: , a32 JTF_NUMBER_TABLE
131: , a33 JTF_CLOB_TABLE
132: , a34 JTF_CLOB_TABLE
133: , a35 JTF_VARCHAR2_TABLE_500
134: , a36 JTF_VARCHAR2_TABLE_500
187: end loop;
188: end if;
189: end if;
190: end rosetta_table_copy_in_p16;
191: procedure rosetta_table_copy_out_p16(t oks_entitlements_pub.hdr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
192: , a1 out nocopy JTF_NUMBER_TABLE
193: , a2 out nocopy JTF_VARCHAR2_TABLE_200
194: , a3 out nocopy JTF_VARCHAR2_TABLE_200
195: , a4 out nocopy JTF_VARCHAR2_TABLE_600
188: end if;
189: end if;
190: end rosetta_table_copy_in_p16;
191: procedure rosetta_table_copy_out_p16(t oks_entitlements_pub.hdr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
192: , a1 out nocopy JTF_NUMBER_TABLE
193: , a2 out nocopy JTF_VARCHAR2_TABLE_200
194: , a3 out nocopy JTF_VARCHAR2_TABLE_200
195: , a4 out nocopy JTF_VARCHAR2_TABLE_600
196: , a5 out nocopy JTF_NUMBER_TABLE
192: , a1 out nocopy JTF_NUMBER_TABLE
193: , a2 out nocopy JTF_VARCHAR2_TABLE_200
194: , a3 out nocopy JTF_VARCHAR2_TABLE_200
195: , a4 out nocopy JTF_VARCHAR2_TABLE_600
196: , a5 out nocopy JTF_NUMBER_TABLE
197: , a6 out nocopy JTF_VARCHAR2_TABLE_100
198: , a7 out nocopy JTF_VARCHAR2_TABLE_100
199: , a8 out nocopy JTF_NUMBER_TABLE
200: , a9 out nocopy JTF_VARCHAR2_TABLE_100
195: , a4 out nocopy JTF_VARCHAR2_TABLE_600
196: , a5 out nocopy JTF_NUMBER_TABLE
197: , a6 out nocopy JTF_VARCHAR2_TABLE_100
198: , a7 out nocopy JTF_VARCHAR2_TABLE_100
199: , a8 out nocopy JTF_NUMBER_TABLE
200: , a9 out nocopy JTF_VARCHAR2_TABLE_100
201: , a10 out nocopy JTF_VARCHAR2_TABLE_200
202: , a11 out nocopy JTF_NUMBER_TABLE
203: , a12 out nocopy JTF_VARCHAR2_TABLE_100
198: , a7 out nocopy JTF_VARCHAR2_TABLE_100
199: , a8 out nocopy JTF_NUMBER_TABLE
200: , a9 out nocopy JTF_VARCHAR2_TABLE_100
201: , a10 out nocopy JTF_VARCHAR2_TABLE_200
202: , a11 out nocopy JTF_NUMBER_TABLE
203: , a12 out nocopy JTF_VARCHAR2_TABLE_100
204: , a13 out nocopy JTF_DATE_TABLE
205: , a14 out nocopy JTF_DATE_TABLE
206: , a15 out nocopy JTF_NUMBER_TABLE
202: , a11 out nocopy JTF_NUMBER_TABLE
203: , a12 out nocopy JTF_VARCHAR2_TABLE_100
204: , a13 out nocopy JTF_DATE_TABLE
205: , a14 out nocopy JTF_DATE_TABLE
206: , a15 out nocopy JTF_NUMBER_TABLE
207: , a16 out nocopy JTF_NUMBER_TABLE
208: , a17 out nocopy JTF_NUMBER_TABLE
209: , a18 out nocopy JTF_NUMBER_TABLE
210: , a19 out nocopy JTF_NUMBER_TABLE
203: , a12 out nocopy JTF_VARCHAR2_TABLE_100
204: , a13 out nocopy JTF_DATE_TABLE
205: , a14 out nocopy JTF_DATE_TABLE
206: , a15 out nocopy JTF_NUMBER_TABLE
207: , a16 out nocopy JTF_NUMBER_TABLE
208: , a17 out nocopy JTF_NUMBER_TABLE
209: , a18 out nocopy JTF_NUMBER_TABLE
210: , a19 out nocopy JTF_NUMBER_TABLE
211: , a20 out nocopy JTF_VARCHAR2_TABLE_100
204: , a13 out nocopy JTF_DATE_TABLE
205: , a14 out nocopy JTF_DATE_TABLE
206: , a15 out nocopy JTF_NUMBER_TABLE
207: , a16 out nocopy JTF_NUMBER_TABLE
208: , a17 out nocopy JTF_NUMBER_TABLE
209: , a18 out nocopy JTF_NUMBER_TABLE
210: , a19 out nocopy JTF_NUMBER_TABLE
211: , a20 out nocopy JTF_VARCHAR2_TABLE_100
212: , a21 out nocopy JTF_NUMBER_TABLE
205: , a14 out nocopy JTF_DATE_TABLE
206: , a15 out nocopy JTF_NUMBER_TABLE
207: , a16 out nocopy JTF_NUMBER_TABLE
208: , a17 out nocopy JTF_NUMBER_TABLE
209: , a18 out nocopy JTF_NUMBER_TABLE
210: , a19 out nocopy JTF_NUMBER_TABLE
211: , a20 out nocopy JTF_VARCHAR2_TABLE_100
212: , a21 out nocopy JTF_NUMBER_TABLE
213: , a22 out nocopy JTF_NUMBER_TABLE
206: , a15 out nocopy JTF_NUMBER_TABLE
207: , a16 out nocopy JTF_NUMBER_TABLE
208: , a17 out nocopy JTF_NUMBER_TABLE
209: , a18 out nocopy JTF_NUMBER_TABLE
210: , a19 out nocopy JTF_NUMBER_TABLE
211: , a20 out nocopy JTF_VARCHAR2_TABLE_100
212: , a21 out nocopy JTF_NUMBER_TABLE
213: , a22 out nocopy JTF_NUMBER_TABLE
214: , a23 out nocopy JTF_NUMBER_TABLE
208: , a17 out nocopy JTF_NUMBER_TABLE
209: , a18 out nocopy JTF_NUMBER_TABLE
210: , a19 out nocopy JTF_NUMBER_TABLE
211: , a20 out nocopy JTF_VARCHAR2_TABLE_100
212: , a21 out nocopy JTF_NUMBER_TABLE
213: , a22 out nocopy JTF_NUMBER_TABLE
214: , a23 out nocopy JTF_NUMBER_TABLE
215: , a24 out nocopy JTF_VARCHAR2_TABLE_200
216: , a25 out nocopy JTF_NUMBER_TABLE
209: , a18 out nocopy JTF_NUMBER_TABLE
210: , a19 out nocopy JTF_NUMBER_TABLE
211: , a20 out nocopy JTF_VARCHAR2_TABLE_100
212: , a21 out nocopy JTF_NUMBER_TABLE
213: , a22 out nocopy JTF_NUMBER_TABLE
214: , a23 out nocopy JTF_NUMBER_TABLE
215: , a24 out nocopy JTF_VARCHAR2_TABLE_200
216: , a25 out nocopy JTF_NUMBER_TABLE
217: , a26 out nocopy JTF_VARCHAR2_TABLE_100
210: , a19 out nocopy JTF_NUMBER_TABLE
211: , a20 out nocopy JTF_VARCHAR2_TABLE_100
212: , a21 out nocopy JTF_NUMBER_TABLE
213: , a22 out nocopy JTF_NUMBER_TABLE
214: , a23 out nocopy JTF_NUMBER_TABLE
215: , a24 out nocopy JTF_VARCHAR2_TABLE_200
216: , a25 out nocopy JTF_NUMBER_TABLE
217: , a26 out nocopy JTF_VARCHAR2_TABLE_100
218: , a27 out nocopy JTF_VARCHAR2_TABLE_100
212: , a21 out nocopy JTF_NUMBER_TABLE
213: , a22 out nocopy JTF_NUMBER_TABLE
214: , a23 out nocopy JTF_NUMBER_TABLE
215: , a24 out nocopy JTF_VARCHAR2_TABLE_200
216: , a25 out nocopy JTF_NUMBER_TABLE
217: , a26 out nocopy JTF_VARCHAR2_TABLE_100
218: , a27 out nocopy JTF_VARCHAR2_TABLE_100
219: , a28 out nocopy JTF_NUMBER_TABLE
220: , a29 out nocopy JTF_DATE_TABLE
215: , a24 out nocopy JTF_VARCHAR2_TABLE_200
216: , a25 out nocopy JTF_NUMBER_TABLE
217: , a26 out nocopy JTF_VARCHAR2_TABLE_100
218: , a27 out nocopy JTF_VARCHAR2_TABLE_100
219: , a28 out nocopy JTF_NUMBER_TABLE
220: , a29 out nocopy JTF_DATE_TABLE
221: , a30 out nocopy JTF_DATE_TABLE
222: , a31 out nocopy JTF_NUMBER_TABLE
223: , a32 out nocopy JTF_NUMBER_TABLE
218: , a27 out nocopy JTF_VARCHAR2_TABLE_100
219: , a28 out nocopy JTF_NUMBER_TABLE
220: , a29 out nocopy JTF_DATE_TABLE
221: , a30 out nocopy JTF_DATE_TABLE
222: , a31 out nocopy JTF_NUMBER_TABLE
223: , a32 out nocopy JTF_NUMBER_TABLE
224: , a33 out nocopy JTF_CLOB_TABLE
225: , a34 out nocopy JTF_CLOB_TABLE
226: , a35 out nocopy JTF_VARCHAR2_TABLE_500
219: , a28 out nocopy JTF_NUMBER_TABLE
220: , a29 out nocopy JTF_DATE_TABLE
221: , a30 out nocopy JTF_DATE_TABLE
222: , a31 out nocopy JTF_NUMBER_TABLE
223: , a32 out nocopy JTF_NUMBER_TABLE
224: , a33 out nocopy JTF_CLOB_TABLE
225: , a34 out nocopy JTF_CLOB_TABLE
226: , a35 out nocopy JTF_VARCHAR2_TABLE_500
227: , a36 out nocopy JTF_VARCHAR2_TABLE_500
229: ) as
230: ddindx binary_integer; indx binary_integer;
231: begin
232: if t is null or t.count = 0 then
233: a0 := JTF_NUMBER_TABLE();
234: a1 := JTF_NUMBER_TABLE();
235: a2 := JTF_VARCHAR2_TABLE_200();
236: a3 := JTF_VARCHAR2_TABLE_200();
237: a4 := JTF_VARCHAR2_TABLE_600();
230: ddindx binary_integer; indx binary_integer;
231: begin
232: if t is null or t.count = 0 then
233: a0 := JTF_NUMBER_TABLE();
234: a1 := JTF_NUMBER_TABLE();
235: a2 := JTF_VARCHAR2_TABLE_200();
236: a3 := JTF_VARCHAR2_TABLE_200();
237: a4 := JTF_VARCHAR2_TABLE_600();
238: a5 := JTF_NUMBER_TABLE();
234: a1 := JTF_NUMBER_TABLE();
235: a2 := JTF_VARCHAR2_TABLE_200();
236: a3 := JTF_VARCHAR2_TABLE_200();
237: a4 := JTF_VARCHAR2_TABLE_600();
238: a5 := JTF_NUMBER_TABLE();
239: a6 := JTF_VARCHAR2_TABLE_100();
240: a7 := JTF_VARCHAR2_TABLE_100();
241: a8 := JTF_NUMBER_TABLE();
242: a9 := JTF_VARCHAR2_TABLE_100();
237: a4 := JTF_VARCHAR2_TABLE_600();
238: a5 := JTF_NUMBER_TABLE();
239: a6 := JTF_VARCHAR2_TABLE_100();
240: a7 := JTF_VARCHAR2_TABLE_100();
241: a8 := JTF_NUMBER_TABLE();
242: a9 := JTF_VARCHAR2_TABLE_100();
243: a10 := JTF_VARCHAR2_TABLE_200();
244: a11 := JTF_NUMBER_TABLE();
245: a12 := JTF_VARCHAR2_TABLE_100();
240: a7 := JTF_VARCHAR2_TABLE_100();
241: a8 := JTF_NUMBER_TABLE();
242: a9 := JTF_VARCHAR2_TABLE_100();
243: a10 := JTF_VARCHAR2_TABLE_200();
244: a11 := JTF_NUMBER_TABLE();
245: a12 := JTF_VARCHAR2_TABLE_100();
246: a13 := JTF_DATE_TABLE();
247: a14 := JTF_DATE_TABLE();
248: a15 := JTF_NUMBER_TABLE();
244: a11 := JTF_NUMBER_TABLE();
245: a12 := JTF_VARCHAR2_TABLE_100();
246: a13 := JTF_DATE_TABLE();
247: a14 := JTF_DATE_TABLE();
248: a15 := JTF_NUMBER_TABLE();
249: a16 := JTF_NUMBER_TABLE();
250: a17 := JTF_NUMBER_TABLE();
251: a18 := JTF_NUMBER_TABLE();
252: a19 := JTF_NUMBER_TABLE();
245: a12 := JTF_VARCHAR2_TABLE_100();
246: a13 := JTF_DATE_TABLE();
247: a14 := JTF_DATE_TABLE();
248: a15 := JTF_NUMBER_TABLE();
249: a16 := JTF_NUMBER_TABLE();
250: a17 := JTF_NUMBER_TABLE();
251: a18 := JTF_NUMBER_TABLE();
252: a19 := JTF_NUMBER_TABLE();
253: a20 := JTF_VARCHAR2_TABLE_100();
246: a13 := JTF_DATE_TABLE();
247: a14 := JTF_DATE_TABLE();
248: a15 := JTF_NUMBER_TABLE();
249: a16 := JTF_NUMBER_TABLE();
250: a17 := JTF_NUMBER_TABLE();
251: a18 := JTF_NUMBER_TABLE();
252: a19 := JTF_NUMBER_TABLE();
253: a20 := JTF_VARCHAR2_TABLE_100();
254: a21 := JTF_NUMBER_TABLE();
247: a14 := JTF_DATE_TABLE();
248: a15 := JTF_NUMBER_TABLE();
249: a16 := JTF_NUMBER_TABLE();
250: a17 := JTF_NUMBER_TABLE();
251: a18 := JTF_NUMBER_TABLE();
252: a19 := JTF_NUMBER_TABLE();
253: a20 := JTF_VARCHAR2_TABLE_100();
254: a21 := JTF_NUMBER_TABLE();
255: a22 := JTF_NUMBER_TABLE();
248: a15 := JTF_NUMBER_TABLE();
249: a16 := JTF_NUMBER_TABLE();
250: a17 := JTF_NUMBER_TABLE();
251: a18 := JTF_NUMBER_TABLE();
252: a19 := JTF_NUMBER_TABLE();
253: a20 := JTF_VARCHAR2_TABLE_100();
254: a21 := JTF_NUMBER_TABLE();
255: a22 := JTF_NUMBER_TABLE();
256: a23 := JTF_NUMBER_TABLE();
250: a17 := JTF_NUMBER_TABLE();
251: a18 := JTF_NUMBER_TABLE();
252: a19 := JTF_NUMBER_TABLE();
253: a20 := JTF_VARCHAR2_TABLE_100();
254: a21 := JTF_NUMBER_TABLE();
255: a22 := JTF_NUMBER_TABLE();
256: a23 := JTF_NUMBER_TABLE();
257: a24 := JTF_VARCHAR2_TABLE_200();
258: a25 := JTF_NUMBER_TABLE();
251: a18 := JTF_NUMBER_TABLE();
252: a19 := JTF_NUMBER_TABLE();
253: a20 := JTF_VARCHAR2_TABLE_100();
254: a21 := JTF_NUMBER_TABLE();
255: a22 := JTF_NUMBER_TABLE();
256: a23 := JTF_NUMBER_TABLE();
257: a24 := JTF_VARCHAR2_TABLE_200();
258: a25 := JTF_NUMBER_TABLE();
259: a26 := JTF_VARCHAR2_TABLE_100();
252: a19 := JTF_NUMBER_TABLE();
253: a20 := JTF_VARCHAR2_TABLE_100();
254: a21 := JTF_NUMBER_TABLE();
255: a22 := JTF_NUMBER_TABLE();
256: a23 := JTF_NUMBER_TABLE();
257: a24 := JTF_VARCHAR2_TABLE_200();
258: a25 := JTF_NUMBER_TABLE();
259: a26 := JTF_VARCHAR2_TABLE_100();
260: a27 := JTF_VARCHAR2_TABLE_100();
254: a21 := JTF_NUMBER_TABLE();
255: a22 := JTF_NUMBER_TABLE();
256: a23 := JTF_NUMBER_TABLE();
257: a24 := JTF_VARCHAR2_TABLE_200();
258: a25 := JTF_NUMBER_TABLE();
259: a26 := JTF_VARCHAR2_TABLE_100();
260: a27 := JTF_VARCHAR2_TABLE_100();
261: a28 := JTF_NUMBER_TABLE();
262: a29 := JTF_DATE_TABLE();
257: a24 := JTF_VARCHAR2_TABLE_200();
258: a25 := JTF_NUMBER_TABLE();
259: a26 := JTF_VARCHAR2_TABLE_100();
260: a27 := JTF_VARCHAR2_TABLE_100();
261: a28 := JTF_NUMBER_TABLE();
262: a29 := JTF_DATE_TABLE();
263: a30 := JTF_DATE_TABLE();
264: a31 := JTF_NUMBER_TABLE();
265: a32 := JTF_NUMBER_TABLE();
260: a27 := JTF_VARCHAR2_TABLE_100();
261: a28 := JTF_NUMBER_TABLE();
262: a29 := JTF_DATE_TABLE();
263: a30 := JTF_DATE_TABLE();
264: a31 := JTF_NUMBER_TABLE();
265: a32 := JTF_NUMBER_TABLE();
266: a33 := JTF_CLOB_TABLE();
267: a34 := JTF_CLOB_TABLE();
268: a35 := JTF_VARCHAR2_TABLE_500();
261: a28 := JTF_NUMBER_TABLE();
262: a29 := JTF_DATE_TABLE();
263: a30 := JTF_DATE_TABLE();
264: a31 := JTF_NUMBER_TABLE();
265: a32 := JTF_NUMBER_TABLE();
266: a33 := JTF_CLOB_TABLE();
267: a34 := JTF_CLOB_TABLE();
268: a35 := JTF_VARCHAR2_TABLE_500();
269: a36 := JTF_VARCHAR2_TABLE_500();
268: a35 := JTF_VARCHAR2_TABLE_500();
269: a36 := JTF_VARCHAR2_TABLE_500();
270: a37 := JTF_VARCHAR2_TABLE_500();
271: else
272: a0 := JTF_NUMBER_TABLE();
273: a1 := JTF_NUMBER_TABLE();
274: a2 := JTF_VARCHAR2_TABLE_200();
275: a3 := JTF_VARCHAR2_TABLE_200();
276: a4 := JTF_VARCHAR2_TABLE_600();
269: a36 := JTF_VARCHAR2_TABLE_500();
270: a37 := JTF_VARCHAR2_TABLE_500();
271: else
272: a0 := JTF_NUMBER_TABLE();
273: a1 := JTF_NUMBER_TABLE();
274: a2 := JTF_VARCHAR2_TABLE_200();
275: a3 := JTF_VARCHAR2_TABLE_200();
276: a4 := JTF_VARCHAR2_TABLE_600();
277: a5 := JTF_NUMBER_TABLE();
273: a1 := JTF_NUMBER_TABLE();
274: a2 := JTF_VARCHAR2_TABLE_200();
275: a3 := JTF_VARCHAR2_TABLE_200();
276: a4 := JTF_VARCHAR2_TABLE_600();
277: a5 := JTF_NUMBER_TABLE();
278: a6 := JTF_VARCHAR2_TABLE_100();
279: a7 := JTF_VARCHAR2_TABLE_100();
280: a8 := JTF_NUMBER_TABLE();
281: a9 := JTF_VARCHAR2_TABLE_100();
276: a4 := JTF_VARCHAR2_TABLE_600();
277: a5 := JTF_NUMBER_TABLE();
278: a6 := JTF_VARCHAR2_TABLE_100();
279: a7 := JTF_VARCHAR2_TABLE_100();
280: a8 := JTF_NUMBER_TABLE();
281: a9 := JTF_VARCHAR2_TABLE_100();
282: a10 := JTF_VARCHAR2_TABLE_200();
283: a11 := JTF_NUMBER_TABLE();
284: a12 := JTF_VARCHAR2_TABLE_100();
279: a7 := JTF_VARCHAR2_TABLE_100();
280: a8 := JTF_NUMBER_TABLE();
281: a9 := JTF_VARCHAR2_TABLE_100();
282: a10 := JTF_VARCHAR2_TABLE_200();
283: a11 := JTF_NUMBER_TABLE();
284: a12 := JTF_VARCHAR2_TABLE_100();
285: a13 := JTF_DATE_TABLE();
286: a14 := JTF_DATE_TABLE();
287: a15 := JTF_NUMBER_TABLE();
283: a11 := JTF_NUMBER_TABLE();
284: a12 := JTF_VARCHAR2_TABLE_100();
285: a13 := JTF_DATE_TABLE();
286: a14 := JTF_DATE_TABLE();
287: a15 := JTF_NUMBER_TABLE();
288: a16 := JTF_NUMBER_TABLE();
289: a17 := JTF_NUMBER_TABLE();
290: a18 := JTF_NUMBER_TABLE();
291: a19 := JTF_NUMBER_TABLE();
284: a12 := JTF_VARCHAR2_TABLE_100();
285: a13 := JTF_DATE_TABLE();
286: a14 := JTF_DATE_TABLE();
287: a15 := JTF_NUMBER_TABLE();
288: a16 := JTF_NUMBER_TABLE();
289: a17 := JTF_NUMBER_TABLE();
290: a18 := JTF_NUMBER_TABLE();
291: a19 := JTF_NUMBER_TABLE();
292: a20 := JTF_VARCHAR2_TABLE_100();
285: a13 := JTF_DATE_TABLE();
286: a14 := JTF_DATE_TABLE();
287: a15 := JTF_NUMBER_TABLE();
288: a16 := JTF_NUMBER_TABLE();
289: a17 := JTF_NUMBER_TABLE();
290: a18 := JTF_NUMBER_TABLE();
291: a19 := JTF_NUMBER_TABLE();
292: a20 := JTF_VARCHAR2_TABLE_100();
293: a21 := JTF_NUMBER_TABLE();
286: a14 := JTF_DATE_TABLE();
287: a15 := JTF_NUMBER_TABLE();
288: a16 := JTF_NUMBER_TABLE();
289: a17 := JTF_NUMBER_TABLE();
290: a18 := JTF_NUMBER_TABLE();
291: a19 := JTF_NUMBER_TABLE();
292: a20 := JTF_VARCHAR2_TABLE_100();
293: a21 := JTF_NUMBER_TABLE();
294: a22 := JTF_NUMBER_TABLE();
287: a15 := JTF_NUMBER_TABLE();
288: a16 := JTF_NUMBER_TABLE();
289: a17 := JTF_NUMBER_TABLE();
290: a18 := JTF_NUMBER_TABLE();
291: a19 := JTF_NUMBER_TABLE();
292: a20 := JTF_VARCHAR2_TABLE_100();
293: a21 := JTF_NUMBER_TABLE();
294: a22 := JTF_NUMBER_TABLE();
295: a23 := JTF_NUMBER_TABLE();
289: a17 := JTF_NUMBER_TABLE();
290: a18 := JTF_NUMBER_TABLE();
291: a19 := JTF_NUMBER_TABLE();
292: a20 := JTF_VARCHAR2_TABLE_100();
293: a21 := JTF_NUMBER_TABLE();
294: a22 := JTF_NUMBER_TABLE();
295: a23 := JTF_NUMBER_TABLE();
296: a24 := JTF_VARCHAR2_TABLE_200();
297: a25 := JTF_NUMBER_TABLE();
290: a18 := JTF_NUMBER_TABLE();
291: a19 := JTF_NUMBER_TABLE();
292: a20 := JTF_VARCHAR2_TABLE_100();
293: a21 := JTF_NUMBER_TABLE();
294: a22 := JTF_NUMBER_TABLE();
295: a23 := JTF_NUMBER_TABLE();
296: a24 := JTF_VARCHAR2_TABLE_200();
297: a25 := JTF_NUMBER_TABLE();
298: a26 := JTF_VARCHAR2_TABLE_100();
291: a19 := JTF_NUMBER_TABLE();
292: a20 := JTF_VARCHAR2_TABLE_100();
293: a21 := JTF_NUMBER_TABLE();
294: a22 := JTF_NUMBER_TABLE();
295: a23 := JTF_NUMBER_TABLE();
296: a24 := JTF_VARCHAR2_TABLE_200();
297: a25 := JTF_NUMBER_TABLE();
298: a26 := JTF_VARCHAR2_TABLE_100();
299: a27 := JTF_VARCHAR2_TABLE_100();
293: a21 := JTF_NUMBER_TABLE();
294: a22 := JTF_NUMBER_TABLE();
295: a23 := JTF_NUMBER_TABLE();
296: a24 := JTF_VARCHAR2_TABLE_200();
297: a25 := JTF_NUMBER_TABLE();
298: a26 := JTF_VARCHAR2_TABLE_100();
299: a27 := JTF_VARCHAR2_TABLE_100();
300: a28 := JTF_NUMBER_TABLE();
301: a29 := JTF_DATE_TABLE();
296: a24 := JTF_VARCHAR2_TABLE_200();
297: a25 := JTF_NUMBER_TABLE();
298: a26 := JTF_VARCHAR2_TABLE_100();
299: a27 := JTF_VARCHAR2_TABLE_100();
300: a28 := JTF_NUMBER_TABLE();
301: a29 := JTF_DATE_TABLE();
302: a30 := JTF_DATE_TABLE();
303: a31 := JTF_NUMBER_TABLE();
304: a32 := JTF_NUMBER_TABLE();
299: a27 := JTF_VARCHAR2_TABLE_100();
300: a28 := JTF_NUMBER_TABLE();
301: a29 := JTF_DATE_TABLE();
302: a30 := JTF_DATE_TABLE();
303: a31 := JTF_NUMBER_TABLE();
304: a32 := JTF_NUMBER_TABLE();
305: a33 := JTF_CLOB_TABLE();
306: a34 := JTF_CLOB_TABLE();
307: a35 := JTF_VARCHAR2_TABLE_500();
300: a28 := JTF_NUMBER_TABLE();
301: a29 := JTF_DATE_TABLE();
302: a30 := JTF_DATE_TABLE();
303: a31 := JTF_NUMBER_TABLE();
304: a32 := JTF_NUMBER_TABLE();
305: a33 := JTF_CLOB_TABLE();
306: a34 := JTF_CLOB_TABLE();
307: a35 := JTF_VARCHAR2_TABLE_500();
308: a36 := JTF_VARCHAR2_TABLE_500();
396: end if;
397: end if;
398: end rosetta_table_copy_out_p16;
399:
400: procedure rosetta_table_copy_in_p19(t out nocopy oks_entitlements_pub.line_tbl_type, a0 JTF_NUMBER_TABLE
401: , a1 JTF_NUMBER_TABLE
402: , a2 JTF_NUMBER_TABLE
403: , a3 JTF_VARCHAR2_TABLE_100
404: , a4 JTF_NUMBER_TABLE
397: end if;
398: end rosetta_table_copy_out_p16;
399:
400: procedure rosetta_table_copy_in_p19(t out nocopy oks_entitlements_pub.line_tbl_type, a0 JTF_NUMBER_TABLE
401: , a1 JTF_NUMBER_TABLE
402: , a2 JTF_NUMBER_TABLE
403: , a3 JTF_VARCHAR2_TABLE_100
404: , a4 JTF_NUMBER_TABLE
405: , a5 JTF_VARCHAR2_TABLE_100
398: end rosetta_table_copy_out_p16;
399:
400: procedure rosetta_table_copy_in_p19(t out nocopy oks_entitlements_pub.line_tbl_type, a0 JTF_NUMBER_TABLE
401: , a1 JTF_NUMBER_TABLE
402: , a2 JTF_NUMBER_TABLE
403: , a3 JTF_VARCHAR2_TABLE_100
404: , a4 JTF_NUMBER_TABLE
405: , a5 JTF_VARCHAR2_TABLE_100
406: , a6 JTF_DATE_TABLE
400: procedure rosetta_table_copy_in_p19(t out nocopy oks_entitlements_pub.line_tbl_type, a0 JTF_NUMBER_TABLE
401: , a1 JTF_NUMBER_TABLE
402: , a2 JTF_NUMBER_TABLE
403: , a3 JTF_VARCHAR2_TABLE_100
404: , a4 JTF_NUMBER_TABLE
405: , a5 JTF_VARCHAR2_TABLE_100
406: , a6 JTF_DATE_TABLE
407: , a7 JTF_DATE_TABLE
408: , a8 JTF_VARCHAR2_TABLE_200
405: , a5 JTF_VARCHAR2_TABLE_100
406: , a6 JTF_DATE_TABLE
407: , a7 JTF_DATE_TABLE
408: , a8 JTF_VARCHAR2_TABLE_200
409: , a9 JTF_NUMBER_TABLE
410: , a10 JTF_NUMBER_TABLE
411: , a11 JTF_NUMBER_TABLE
412: , a12 JTF_NUMBER_TABLE
413: , a13 JTF_NUMBER_TABLE
406: , a6 JTF_DATE_TABLE
407: , a7 JTF_DATE_TABLE
408: , a8 JTF_VARCHAR2_TABLE_200
409: , a9 JTF_NUMBER_TABLE
410: , a10 JTF_NUMBER_TABLE
411: , a11 JTF_NUMBER_TABLE
412: , a12 JTF_NUMBER_TABLE
413: , a13 JTF_NUMBER_TABLE
414: , a14 JTF_NUMBER_TABLE
407: , a7 JTF_DATE_TABLE
408: , a8 JTF_VARCHAR2_TABLE_200
409: , a9 JTF_NUMBER_TABLE
410: , a10 JTF_NUMBER_TABLE
411: , a11 JTF_NUMBER_TABLE
412: , a12 JTF_NUMBER_TABLE
413: , a13 JTF_NUMBER_TABLE
414: , a14 JTF_NUMBER_TABLE
415: , a15 JTF_NUMBER_TABLE
408: , a8 JTF_VARCHAR2_TABLE_200
409: , a9 JTF_NUMBER_TABLE
410: , a10 JTF_NUMBER_TABLE
411: , a11 JTF_NUMBER_TABLE
412: , a12 JTF_NUMBER_TABLE
413: , a13 JTF_NUMBER_TABLE
414: , a14 JTF_NUMBER_TABLE
415: , a15 JTF_NUMBER_TABLE
416: , a16 JTF_VARCHAR2_TABLE_100
409: , a9 JTF_NUMBER_TABLE
410: , a10 JTF_NUMBER_TABLE
411: , a11 JTF_NUMBER_TABLE
412: , a12 JTF_NUMBER_TABLE
413: , a13 JTF_NUMBER_TABLE
414: , a14 JTF_NUMBER_TABLE
415: , a15 JTF_NUMBER_TABLE
416: , a16 JTF_VARCHAR2_TABLE_100
417: , a17 JTF_VARCHAR2_TABLE_100
410: , a10 JTF_NUMBER_TABLE
411: , a11 JTF_NUMBER_TABLE
412: , a12 JTF_NUMBER_TABLE
413: , a13 JTF_NUMBER_TABLE
414: , a14 JTF_NUMBER_TABLE
415: , a15 JTF_NUMBER_TABLE
416: , a16 JTF_VARCHAR2_TABLE_100
417: , a17 JTF_VARCHAR2_TABLE_100
418: , a18 JTF_NUMBER_TABLE
411: , a11 JTF_NUMBER_TABLE
412: , a12 JTF_NUMBER_TABLE
413: , a13 JTF_NUMBER_TABLE
414: , a14 JTF_NUMBER_TABLE
415: , a15 JTF_NUMBER_TABLE
416: , a16 JTF_VARCHAR2_TABLE_100
417: , a17 JTF_VARCHAR2_TABLE_100
418: , a18 JTF_NUMBER_TABLE
419: , a19 JTF_DATE_TABLE
414: , a14 JTF_NUMBER_TABLE
415: , a15 JTF_NUMBER_TABLE
416: , a16 JTF_VARCHAR2_TABLE_100
417: , a17 JTF_VARCHAR2_TABLE_100
418: , a18 JTF_NUMBER_TABLE
419: , a19 JTF_DATE_TABLE
420: , a20 JTF_DATE_TABLE
421: , a21 JTF_DATE_TABLE
422: ) as
457: end loop;
458: end if;
459: end if;
460: end rosetta_table_copy_in_p19;
461: procedure rosetta_table_copy_out_p19(t oks_entitlements_pub.line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
462: , a1 out nocopy JTF_NUMBER_TABLE
463: , a2 out nocopy JTF_NUMBER_TABLE
464: , a3 out nocopy JTF_VARCHAR2_TABLE_100
465: , a4 out nocopy JTF_NUMBER_TABLE
458: end if;
459: end if;
460: end rosetta_table_copy_in_p19;
461: procedure rosetta_table_copy_out_p19(t oks_entitlements_pub.line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
462: , a1 out nocopy JTF_NUMBER_TABLE
463: , a2 out nocopy JTF_NUMBER_TABLE
464: , a3 out nocopy JTF_VARCHAR2_TABLE_100
465: , a4 out nocopy JTF_NUMBER_TABLE
466: , a5 out nocopy JTF_VARCHAR2_TABLE_100
459: end if;
460: end rosetta_table_copy_in_p19;
461: procedure rosetta_table_copy_out_p19(t oks_entitlements_pub.line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
462: , a1 out nocopy JTF_NUMBER_TABLE
463: , a2 out nocopy JTF_NUMBER_TABLE
464: , a3 out nocopy JTF_VARCHAR2_TABLE_100
465: , a4 out nocopy JTF_NUMBER_TABLE
466: , a5 out nocopy JTF_VARCHAR2_TABLE_100
467: , a6 out nocopy JTF_DATE_TABLE
461: procedure rosetta_table_copy_out_p19(t oks_entitlements_pub.line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
462: , a1 out nocopy JTF_NUMBER_TABLE
463: , a2 out nocopy JTF_NUMBER_TABLE
464: , a3 out nocopy JTF_VARCHAR2_TABLE_100
465: , a4 out nocopy JTF_NUMBER_TABLE
466: , a5 out nocopy JTF_VARCHAR2_TABLE_100
467: , a6 out nocopy JTF_DATE_TABLE
468: , a7 out nocopy JTF_DATE_TABLE
469: , a8 out nocopy JTF_VARCHAR2_TABLE_200
466: , a5 out nocopy JTF_VARCHAR2_TABLE_100
467: , a6 out nocopy JTF_DATE_TABLE
468: , a7 out nocopy JTF_DATE_TABLE
469: , a8 out nocopy JTF_VARCHAR2_TABLE_200
470: , a9 out nocopy JTF_NUMBER_TABLE
471: , a10 out nocopy JTF_NUMBER_TABLE
472: , a11 out nocopy JTF_NUMBER_TABLE
473: , a12 out nocopy JTF_NUMBER_TABLE
474: , a13 out nocopy JTF_NUMBER_TABLE
467: , a6 out nocopy JTF_DATE_TABLE
468: , a7 out nocopy JTF_DATE_TABLE
469: , a8 out nocopy JTF_VARCHAR2_TABLE_200
470: , a9 out nocopy JTF_NUMBER_TABLE
471: , a10 out nocopy JTF_NUMBER_TABLE
472: , a11 out nocopy JTF_NUMBER_TABLE
473: , a12 out nocopy JTF_NUMBER_TABLE
474: , a13 out nocopy JTF_NUMBER_TABLE
475: , a14 out nocopy JTF_NUMBER_TABLE
468: , a7 out nocopy JTF_DATE_TABLE
469: , a8 out nocopy JTF_VARCHAR2_TABLE_200
470: , a9 out nocopy JTF_NUMBER_TABLE
471: , a10 out nocopy JTF_NUMBER_TABLE
472: , a11 out nocopy JTF_NUMBER_TABLE
473: , a12 out nocopy JTF_NUMBER_TABLE
474: , a13 out nocopy JTF_NUMBER_TABLE
475: , a14 out nocopy JTF_NUMBER_TABLE
476: , a15 out nocopy JTF_NUMBER_TABLE
469: , a8 out nocopy JTF_VARCHAR2_TABLE_200
470: , a9 out nocopy JTF_NUMBER_TABLE
471: , a10 out nocopy JTF_NUMBER_TABLE
472: , a11 out nocopy JTF_NUMBER_TABLE
473: , a12 out nocopy JTF_NUMBER_TABLE
474: , a13 out nocopy JTF_NUMBER_TABLE
475: , a14 out nocopy JTF_NUMBER_TABLE
476: , a15 out nocopy JTF_NUMBER_TABLE
477: , a16 out nocopy JTF_VARCHAR2_TABLE_100
470: , a9 out nocopy JTF_NUMBER_TABLE
471: , a10 out nocopy JTF_NUMBER_TABLE
472: , a11 out nocopy JTF_NUMBER_TABLE
473: , a12 out nocopy JTF_NUMBER_TABLE
474: , a13 out nocopy JTF_NUMBER_TABLE
475: , a14 out nocopy JTF_NUMBER_TABLE
476: , a15 out nocopy JTF_NUMBER_TABLE
477: , a16 out nocopy JTF_VARCHAR2_TABLE_100
478: , a17 out nocopy JTF_VARCHAR2_TABLE_100
471: , a10 out nocopy JTF_NUMBER_TABLE
472: , a11 out nocopy JTF_NUMBER_TABLE
473: , a12 out nocopy JTF_NUMBER_TABLE
474: , a13 out nocopy JTF_NUMBER_TABLE
475: , a14 out nocopy JTF_NUMBER_TABLE
476: , a15 out nocopy JTF_NUMBER_TABLE
477: , a16 out nocopy JTF_VARCHAR2_TABLE_100
478: , a17 out nocopy JTF_VARCHAR2_TABLE_100
479: , a18 out nocopy JTF_NUMBER_TABLE
472: , a11 out nocopy JTF_NUMBER_TABLE
473: , a12 out nocopy JTF_NUMBER_TABLE
474: , a13 out nocopy JTF_NUMBER_TABLE
475: , a14 out nocopy JTF_NUMBER_TABLE
476: , a15 out nocopy JTF_NUMBER_TABLE
477: , a16 out nocopy JTF_VARCHAR2_TABLE_100
478: , a17 out nocopy JTF_VARCHAR2_TABLE_100
479: , a18 out nocopy JTF_NUMBER_TABLE
480: , a19 out nocopy JTF_DATE_TABLE
475: , a14 out nocopy JTF_NUMBER_TABLE
476: , a15 out nocopy JTF_NUMBER_TABLE
477: , a16 out nocopy JTF_VARCHAR2_TABLE_100
478: , a17 out nocopy JTF_VARCHAR2_TABLE_100
479: , a18 out nocopy JTF_NUMBER_TABLE
480: , a19 out nocopy JTF_DATE_TABLE
481: , a20 out nocopy JTF_DATE_TABLE
482: , a21 out nocopy JTF_DATE_TABLE
483: ) as
483: ) as
484: ddindx binary_integer; indx binary_integer;
485: begin
486: if t is null or t.count = 0 then
487: a0 := JTF_NUMBER_TABLE();
488: a1 := JTF_NUMBER_TABLE();
489: a2 := JTF_NUMBER_TABLE();
490: a3 := JTF_VARCHAR2_TABLE_100();
491: a4 := JTF_NUMBER_TABLE();
484: ddindx binary_integer; indx binary_integer;
485: begin
486: if t is null or t.count = 0 then
487: a0 := JTF_NUMBER_TABLE();
488: a1 := JTF_NUMBER_TABLE();
489: a2 := JTF_NUMBER_TABLE();
490: a3 := JTF_VARCHAR2_TABLE_100();
491: a4 := JTF_NUMBER_TABLE();
492: a5 := JTF_VARCHAR2_TABLE_100();
485: begin
486: if t is null or t.count = 0 then
487: a0 := JTF_NUMBER_TABLE();
488: a1 := JTF_NUMBER_TABLE();
489: a2 := JTF_NUMBER_TABLE();
490: a3 := JTF_VARCHAR2_TABLE_100();
491: a4 := JTF_NUMBER_TABLE();
492: a5 := JTF_VARCHAR2_TABLE_100();
493: a6 := JTF_DATE_TABLE();
487: a0 := JTF_NUMBER_TABLE();
488: a1 := JTF_NUMBER_TABLE();
489: a2 := JTF_NUMBER_TABLE();
490: a3 := JTF_VARCHAR2_TABLE_100();
491: a4 := JTF_NUMBER_TABLE();
492: a5 := JTF_VARCHAR2_TABLE_100();
493: a6 := JTF_DATE_TABLE();
494: a7 := JTF_DATE_TABLE();
495: a8 := JTF_VARCHAR2_TABLE_200();
492: a5 := JTF_VARCHAR2_TABLE_100();
493: a6 := JTF_DATE_TABLE();
494: a7 := JTF_DATE_TABLE();
495: a8 := JTF_VARCHAR2_TABLE_200();
496: a9 := JTF_NUMBER_TABLE();
497: a10 := JTF_NUMBER_TABLE();
498: a11 := JTF_NUMBER_TABLE();
499: a12 := JTF_NUMBER_TABLE();
500: a13 := JTF_NUMBER_TABLE();
493: a6 := JTF_DATE_TABLE();
494: a7 := JTF_DATE_TABLE();
495: a8 := JTF_VARCHAR2_TABLE_200();
496: a9 := JTF_NUMBER_TABLE();
497: a10 := JTF_NUMBER_TABLE();
498: a11 := JTF_NUMBER_TABLE();
499: a12 := JTF_NUMBER_TABLE();
500: a13 := JTF_NUMBER_TABLE();
501: a14 := JTF_NUMBER_TABLE();
494: a7 := JTF_DATE_TABLE();
495: a8 := JTF_VARCHAR2_TABLE_200();
496: a9 := JTF_NUMBER_TABLE();
497: a10 := JTF_NUMBER_TABLE();
498: a11 := JTF_NUMBER_TABLE();
499: a12 := JTF_NUMBER_TABLE();
500: a13 := JTF_NUMBER_TABLE();
501: a14 := JTF_NUMBER_TABLE();
502: a15 := JTF_NUMBER_TABLE();
495: a8 := JTF_VARCHAR2_TABLE_200();
496: a9 := JTF_NUMBER_TABLE();
497: a10 := JTF_NUMBER_TABLE();
498: a11 := JTF_NUMBER_TABLE();
499: a12 := JTF_NUMBER_TABLE();
500: a13 := JTF_NUMBER_TABLE();
501: a14 := JTF_NUMBER_TABLE();
502: a15 := JTF_NUMBER_TABLE();
503: a16 := JTF_VARCHAR2_TABLE_100();
496: a9 := JTF_NUMBER_TABLE();
497: a10 := JTF_NUMBER_TABLE();
498: a11 := JTF_NUMBER_TABLE();
499: a12 := JTF_NUMBER_TABLE();
500: a13 := JTF_NUMBER_TABLE();
501: a14 := JTF_NUMBER_TABLE();
502: a15 := JTF_NUMBER_TABLE();
503: a16 := JTF_VARCHAR2_TABLE_100();
504: a17 := JTF_VARCHAR2_TABLE_100();
497: a10 := JTF_NUMBER_TABLE();
498: a11 := JTF_NUMBER_TABLE();
499: a12 := JTF_NUMBER_TABLE();
500: a13 := JTF_NUMBER_TABLE();
501: a14 := JTF_NUMBER_TABLE();
502: a15 := JTF_NUMBER_TABLE();
503: a16 := JTF_VARCHAR2_TABLE_100();
504: a17 := JTF_VARCHAR2_TABLE_100();
505: a18 := JTF_NUMBER_TABLE();
498: a11 := JTF_NUMBER_TABLE();
499: a12 := JTF_NUMBER_TABLE();
500: a13 := JTF_NUMBER_TABLE();
501: a14 := JTF_NUMBER_TABLE();
502: a15 := JTF_NUMBER_TABLE();
503: a16 := JTF_VARCHAR2_TABLE_100();
504: a17 := JTF_VARCHAR2_TABLE_100();
505: a18 := JTF_NUMBER_TABLE();
506: a19 := JTF_DATE_TABLE();
501: a14 := JTF_NUMBER_TABLE();
502: a15 := JTF_NUMBER_TABLE();
503: a16 := JTF_VARCHAR2_TABLE_100();
504: a17 := JTF_VARCHAR2_TABLE_100();
505: a18 := JTF_NUMBER_TABLE();
506: a19 := JTF_DATE_TABLE();
507: a20 := JTF_DATE_TABLE();
508: a21 := JTF_DATE_TABLE();
509: else
506: a19 := JTF_DATE_TABLE();
507: a20 := JTF_DATE_TABLE();
508: a21 := JTF_DATE_TABLE();
509: else
510: a0 := JTF_NUMBER_TABLE();
511: a1 := JTF_NUMBER_TABLE();
512: a2 := JTF_NUMBER_TABLE();
513: a3 := JTF_VARCHAR2_TABLE_100();
514: a4 := JTF_NUMBER_TABLE();
507: a20 := JTF_DATE_TABLE();
508: a21 := JTF_DATE_TABLE();
509: else
510: a0 := JTF_NUMBER_TABLE();
511: a1 := JTF_NUMBER_TABLE();
512: a2 := JTF_NUMBER_TABLE();
513: a3 := JTF_VARCHAR2_TABLE_100();
514: a4 := JTF_NUMBER_TABLE();
515: a5 := JTF_VARCHAR2_TABLE_100();
508: a21 := JTF_DATE_TABLE();
509: else
510: a0 := JTF_NUMBER_TABLE();
511: a1 := JTF_NUMBER_TABLE();
512: a2 := JTF_NUMBER_TABLE();
513: a3 := JTF_VARCHAR2_TABLE_100();
514: a4 := JTF_NUMBER_TABLE();
515: a5 := JTF_VARCHAR2_TABLE_100();
516: a6 := JTF_DATE_TABLE();
510: a0 := JTF_NUMBER_TABLE();
511: a1 := JTF_NUMBER_TABLE();
512: a2 := JTF_NUMBER_TABLE();
513: a3 := JTF_VARCHAR2_TABLE_100();
514: a4 := JTF_NUMBER_TABLE();
515: a5 := JTF_VARCHAR2_TABLE_100();
516: a6 := JTF_DATE_TABLE();
517: a7 := JTF_DATE_TABLE();
518: a8 := JTF_VARCHAR2_TABLE_200();
515: a5 := JTF_VARCHAR2_TABLE_100();
516: a6 := JTF_DATE_TABLE();
517: a7 := JTF_DATE_TABLE();
518: a8 := JTF_VARCHAR2_TABLE_200();
519: a9 := JTF_NUMBER_TABLE();
520: a10 := JTF_NUMBER_TABLE();
521: a11 := JTF_NUMBER_TABLE();
522: a12 := JTF_NUMBER_TABLE();
523: a13 := JTF_NUMBER_TABLE();
516: a6 := JTF_DATE_TABLE();
517: a7 := JTF_DATE_TABLE();
518: a8 := JTF_VARCHAR2_TABLE_200();
519: a9 := JTF_NUMBER_TABLE();
520: a10 := JTF_NUMBER_TABLE();
521: a11 := JTF_NUMBER_TABLE();
522: a12 := JTF_NUMBER_TABLE();
523: a13 := JTF_NUMBER_TABLE();
524: a14 := JTF_NUMBER_TABLE();
517: a7 := JTF_DATE_TABLE();
518: a8 := JTF_VARCHAR2_TABLE_200();
519: a9 := JTF_NUMBER_TABLE();
520: a10 := JTF_NUMBER_TABLE();
521: a11 := JTF_NUMBER_TABLE();
522: a12 := JTF_NUMBER_TABLE();
523: a13 := JTF_NUMBER_TABLE();
524: a14 := JTF_NUMBER_TABLE();
525: a15 := JTF_NUMBER_TABLE();
518: a8 := JTF_VARCHAR2_TABLE_200();
519: a9 := JTF_NUMBER_TABLE();
520: a10 := JTF_NUMBER_TABLE();
521: a11 := JTF_NUMBER_TABLE();
522: a12 := JTF_NUMBER_TABLE();
523: a13 := JTF_NUMBER_TABLE();
524: a14 := JTF_NUMBER_TABLE();
525: a15 := JTF_NUMBER_TABLE();
526: a16 := JTF_VARCHAR2_TABLE_100();
519: a9 := JTF_NUMBER_TABLE();
520: a10 := JTF_NUMBER_TABLE();
521: a11 := JTF_NUMBER_TABLE();
522: a12 := JTF_NUMBER_TABLE();
523: a13 := JTF_NUMBER_TABLE();
524: a14 := JTF_NUMBER_TABLE();
525: a15 := JTF_NUMBER_TABLE();
526: a16 := JTF_VARCHAR2_TABLE_100();
527: a17 := JTF_VARCHAR2_TABLE_100();
520: a10 := JTF_NUMBER_TABLE();
521: a11 := JTF_NUMBER_TABLE();
522: a12 := JTF_NUMBER_TABLE();
523: a13 := JTF_NUMBER_TABLE();
524: a14 := JTF_NUMBER_TABLE();
525: a15 := JTF_NUMBER_TABLE();
526: a16 := JTF_VARCHAR2_TABLE_100();
527: a17 := JTF_VARCHAR2_TABLE_100();
528: a18 := JTF_NUMBER_TABLE();
521: a11 := JTF_NUMBER_TABLE();
522: a12 := JTF_NUMBER_TABLE();
523: a13 := JTF_NUMBER_TABLE();
524: a14 := JTF_NUMBER_TABLE();
525: a15 := JTF_NUMBER_TABLE();
526: a16 := JTF_VARCHAR2_TABLE_100();
527: a17 := JTF_VARCHAR2_TABLE_100();
528: a18 := JTF_NUMBER_TABLE();
529: a19 := JTF_DATE_TABLE();
524: a14 := JTF_NUMBER_TABLE();
525: a15 := JTF_NUMBER_TABLE();
526: a16 := JTF_VARCHAR2_TABLE_100();
527: a17 := JTF_VARCHAR2_TABLE_100();
528: a18 := JTF_NUMBER_TABLE();
529: a19 := JTF_DATE_TABLE();
530: a20 := JTF_DATE_TABLE();
531: a21 := JTF_DATE_TABLE();
532: if t.count > 0 then
587: end if;
588: end rosetta_table_copy_out_p19;
589:
590: procedure rosetta_table_copy_in_p22(t out nocopy oks_entitlements_pub.clvl_tbl_type, a0 JTF_VARCHAR2_TABLE_100
591: , a1 JTF_NUMBER_TABLE
592: , a2 JTF_NUMBER_TABLE
593: , a3 JTF_NUMBER_TABLE
594: , a4 JTF_VARCHAR2_TABLE_200
595: , a5 JTF_NUMBER_TABLE
588: end rosetta_table_copy_out_p19;
589:
590: procedure rosetta_table_copy_in_p22(t out nocopy oks_entitlements_pub.clvl_tbl_type, a0 JTF_VARCHAR2_TABLE_100
591: , a1 JTF_NUMBER_TABLE
592: , a2 JTF_NUMBER_TABLE
593: , a3 JTF_NUMBER_TABLE
594: , a4 JTF_VARCHAR2_TABLE_200
595: , a5 JTF_NUMBER_TABLE
596: , a6 JTF_VARCHAR2_TABLE_300
589:
590: procedure rosetta_table_copy_in_p22(t out nocopy oks_entitlements_pub.clvl_tbl_type, a0 JTF_VARCHAR2_TABLE_100
591: , a1 JTF_NUMBER_TABLE
592: , a2 JTF_NUMBER_TABLE
593: , a3 JTF_NUMBER_TABLE
594: , a4 JTF_VARCHAR2_TABLE_200
595: , a5 JTF_NUMBER_TABLE
596: , a6 JTF_VARCHAR2_TABLE_300
597: , a7 JTF_NUMBER_TABLE
591: , a1 JTF_NUMBER_TABLE
592: , a2 JTF_NUMBER_TABLE
593: , a3 JTF_NUMBER_TABLE
594: , a4 JTF_VARCHAR2_TABLE_200
595: , a5 JTF_NUMBER_TABLE
596: , a6 JTF_VARCHAR2_TABLE_300
597: , a7 JTF_NUMBER_TABLE
598: , a8 JTF_VARCHAR2_TABLE_300
599: , a9 JTF_NUMBER_TABLE
593: , a3 JTF_NUMBER_TABLE
594: , a4 JTF_VARCHAR2_TABLE_200
595: , a5 JTF_NUMBER_TABLE
596: , a6 JTF_VARCHAR2_TABLE_300
597: , a7 JTF_NUMBER_TABLE
598: , a8 JTF_VARCHAR2_TABLE_300
599: , a9 JTF_NUMBER_TABLE
600: , a10 JTF_VARCHAR2_TABLE_300
601: , a11 JTF_NUMBER_TABLE
595: , a5 JTF_NUMBER_TABLE
596: , a6 JTF_VARCHAR2_TABLE_300
597: , a7 JTF_NUMBER_TABLE
598: , a8 JTF_VARCHAR2_TABLE_300
599: , a9 JTF_NUMBER_TABLE
600: , a10 JTF_VARCHAR2_TABLE_300
601: , a11 JTF_NUMBER_TABLE
602: , a12 JTF_VARCHAR2_TABLE_300
603: , a13 JTF_NUMBER_TABLE
597: , a7 JTF_NUMBER_TABLE
598: , a8 JTF_VARCHAR2_TABLE_300
599: , a9 JTF_NUMBER_TABLE
600: , a10 JTF_VARCHAR2_TABLE_300
601: , a11 JTF_NUMBER_TABLE
602: , a12 JTF_VARCHAR2_TABLE_300
603: , a13 JTF_NUMBER_TABLE
604: , a14 JTF_VARCHAR2_TABLE_300
605: , a15 JTF_NUMBER_TABLE
599: , a9 JTF_NUMBER_TABLE
600: , a10 JTF_VARCHAR2_TABLE_300
601: , a11 JTF_NUMBER_TABLE
602: , a12 JTF_VARCHAR2_TABLE_300
603: , a13 JTF_NUMBER_TABLE
604: , a14 JTF_VARCHAR2_TABLE_300
605: , a15 JTF_NUMBER_TABLE
606: , a16 JTF_VARCHAR2_TABLE_500
607: , a17 JTF_NUMBER_TABLE
601: , a11 JTF_NUMBER_TABLE
602: , a12 JTF_VARCHAR2_TABLE_300
603: , a13 JTF_NUMBER_TABLE
604: , a14 JTF_VARCHAR2_TABLE_300
605: , a15 JTF_NUMBER_TABLE
606: , a16 JTF_VARCHAR2_TABLE_500
607: , a17 JTF_NUMBER_TABLE
608: , a18 JTF_NUMBER_TABLE
609: , a19 JTF_NUMBER_TABLE
603: , a13 JTF_NUMBER_TABLE
604: , a14 JTF_VARCHAR2_TABLE_300
605: , a15 JTF_NUMBER_TABLE
606: , a16 JTF_VARCHAR2_TABLE_500
607: , a17 JTF_NUMBER_TABLE
608: , a18 JTF_NUMBER_TABLE
609: , a19 JTF_NUMBER_TABLE
610: , a20 JTF_VARCHAR2_TABLE_200
611: , a21 JTF_VARCHAR2_TABLE_100
604: , a14 JTF_VARCHAR2_TABLE_300
605: , a15 JTF_NUMBER_TABLE
606: , a16 JTF_VARCHAR2_TABLE_500
607: , a17 JTF_NUMBER_TABLE
608: , a18 JTF_NUMBER_TABLE
609: , a19 JTF_NUMBER_TABLE
610: , a20 JTF_VARCHAR2_TABLE_200
611: , a21 JTF_VARCHAR2_TABLE_100
612: , a22 JTF_NUMBER_TABLE
605: , a15 JTF_NUMBER_TABLE
606: , a16 JTF_VARCHAR2_TABLE_500
607: , a17 JTF_NUMBER_TABLE
608: , a18 JTF_NUMBER_TABLE
609: , a19 JTF_NUMBER_TABLE
610: , a20 JTF_VARCHAR2_TABLE_200
611: , a21 JTF_VARCHAR2_TABLE_100
612: , a22 JTF_NUMBER_TABLE
613: , a23 JTF_VARCHAR2_TABLE_100
608: , a18 JTF_NUMBER_TABLE
609: , a19 JTF_NUMBER_TABLE
610: , a20 JTF_VARCHAR2_TABLE_200
611: , a21 JTF_VARCHAR2_TABLE_100
612: , a22 JTF_NUMBER_TABLE
613: , a23 JTF_VARCHAR2_TABLE_100
614: , a24 JTF_NUMBER_TABLE
615: , a25 JTF_VARCHAR2_TABLE_100
616: , a26 JTF_NUMBER_TABLE
610: , a20 JTF_VARCHAR2_TABLE_200
611: , a21 JTF_VARCHAR2_TABLE_100
612: , a22 JTF_NUMBER_TABLE
613: , a23 JTF_VARCHAR2_TABLE_100
614: , a24 JTF_NUMBER_TABLE
615: , a25 JTF_VARCHAR2_TABLE_100
616: , a26 JTF_NUMBER_TABLE
617: , a27 JTF_VARCHAR2_TABLE_100
618: , a28 JTF_NUMBER_TABLE
612: , a22 JTF_NUMBER_TABLE
613: , a23 JTF_VARCHAR2_TABLE_100
614: , a24 JTF_NUMBER_TABLE
615: , a25 JTF_VARCHAR2_TABLE_100
616: , a26 JTF_NUMBER_TABLE
617: , a27 JTF_VARCHAR2_TABLE_100
618: , a28 JTF_NUMBER_TABLE
619: , a29 JTF_VARCHAR2_TABLE_100
620: , a30 JTF_NUMBER_TABLE
614: , a24 JTF_NUMBER_TABLE
615: , a25 JTF_VARCHAR2_TABLE_100
616: , a26 JTF_NUMBER_TABLE
617: , a27 JTF_VARCHAR2_TABLE_100
618: , a28 JTF_NUMBER_TABLE
619: , a29 JTF_VARCHAR2_TABLE_100
620: , a30 JTF_NUMBER_TABLE
621: , a31 JTF_VARCHAR2_TABLE_100
622: , a32 JTF_NUMBER_TABLE
616: , a26 JTF_NUMBER_TABLE
617: , a27 JTF_VARCHAR2_TABLE_100
618: , a28 JTF_NUMBER_TABLE
619: , a29 JTF_VARCHAR2_TABLE_100
620: , a30 JTF_NUMBER_TABLE
621: , a31 JTF_VARCHAR2_TABLE_100
622: , a32 JTF_NUMBER_TABLE
623: , a33 JTF_VARCHAR2_TABLE_100
624: , a34 JTF_VARCHAR2_TABLE_100
618: , a28 JTF_NUMBER_TABLE
619: , a29 JTF_VARCHAR2_TABLE_100
620: , a30 JTF_NUMBER_TABLE
621: , a31 JTF_VARCHAR2_TABLE_100
622: , a32 JTF_NUMBER_TABLE
623: , a33 JTF_VARCHAR2_TABLE_100
624: , a34 JTF_VARCHAR2_TABLE_100
625: ) as
626: ddindx binary_integer; indx binary_integer;
674: end if;
675: end if;
676: end rosetta_table_copy_in_p22;
677: procedure rosetta_table_copy_out_p22(t oks_entitlements_pub.clvl_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
678: , a1 out nocopy JTF_NUMBER_TABLE
679: , a2 out nocopy JTF_NUMBER_TABLE
680: , a3 out nocopy JTF_NUMBER_TABLE
681: , a4 out nocopy JTF_VARCHAR2_TABLE_200
682: , a5 out nocopy JTF_NUMBER_TABLE
675: end if;
676: end rosetta_table_copy_in_p22;
677: procedure rosetta_table_copy_out_p22(t oks_entitlements_pub.clvl_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
678: , a1 out nocopy JTF_NUMBER_TABLE
679: , a2 out nocopy JTF_NUMBER_TABLE
680: , a3 out nocopy JTF_NUMBER_TABLE
681: , a4 out nocopy JTF_VARCHAR2_TABLE_200
682: , a5 out nocopy JTF_NUMBER_TABLE
683: , a6 out nocopy JTF_VARCHAR2_TABLE_300
676: end rosetta_table_copy_in_p22;
677: procedure rosetta_table_copy_out_p22(t oks_entitlements_pub.clvl_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
678: , a1 out nocopy JTF_NUMBER_TABLE
679: , a2 out nocopy JTF_NUMBER_TABLE
680: , a3 out nocopy JTF_NUMBER_TABLE
681: , a4 out nocopy JTF_VARCHAR2_TABLE_200
682: , a5 out nocopy JTF_NUMBER_TABLE
683: , a6 out nocopy JTF_VARCHAR2_TABLE_300
684: , a7 out nocopy JTF_NUMBER_TABLE
678: , a1 out nocopy JTF_NUMBER_TABLE
679: , a2 out nocopy JTF_NUMBER_TABLE
680: , a3 out nocopy JTF_NUMBER_TABLE
681: , a4 out nocopy JTF_VARCHAR2_TABLE_200
682: , a5 out nocopy JTF_NUMBER_TABLE
683: , a6 out nocopy JTF_VARCHAR2_TABLE_300
684: , a7 out nocopy JTF_NUMBER_TABLE
685: , a8 out nocopy JTF_VARCHAR2_TABLE_300
686: , a9 out nocopy JTF_NUMBER_TABLE
680: , a3 out nocopy JTF_NUMBER_TABLE
681: , a4 out nocopy JTF_VARCHAR2_TABLE_200
682: , a5 out nocopy JTF_NUMBER_TABLE
683: , a6 out nocopy JTF_VARCHAR2_TABLE_300
684: , a7 out nocopy JTF_NUMBER_TABLE
685: , a8 out nocopy JTF_VARCHAR2_TABLE_300
686: , a9 out nocopy JTF_NUMBER_TABLE
687: , a10 out nocopy JTF_VARCHAR2_TABLE_300
688: , a11 out nocopy JTF_NUMBER_TABLE
682: , a5 out nocopy JTF_NUMBER_TABLE
683: , a6 out nocopy JTF_VARCHAR2_TABLE_300
684: , a7 out nocopy JTF_NUMBER_TABLE
685: , a8 out nocopy JTF_VARCHAR2_TABLE_300
686: , a9 out nocopy JTF_NUMBER_TABLE
687: , a10 out nocopy JTF_VARCHAR2_TABLE_300
688: , a11 out nocopy JTF_NUMBER_TABLE
689: , a12 out nocopy JTF_VARCHAR2_TABLE_300
690: , a13 out nocopy JTF_NUMBER_TABLE
684: , a7 out nocopy JTF_NUMBER_TABLE
685: , a8 out nocopy JTF_VARCHAR2_TABLE_300
686: , a9 out nocopy JTF_NUMBER_TABLE
687: , a10 out nocopy JTF_VARCHAR2_TABLE_300
688: , a11 out nocopy JTF_NUMBER_TABLE
689: , a12 out nocopy JTF_VARCHAR2_TABLE_300
690: , a13 out nocopy JTF_NUMBER_TABLE
691: , a14 out nocopy JTF_VARCHAR2_TABLE_300
692: , a15 out nocopy JTF_NUMBER_TABLE
686: , a9 out nocopy JTF_NUMBER_TABLE
687: , a10 out nocopy JTF_VARCHAR2_TABLE_300
688: , a11 out nocopy JTF_NUMBER_TABLE
689: , a12 out nocopy JTF_VARCHAR2_TABLE_300
690: , a13 out nocopy JTF_NUMBER_TABLE
691: , a14 out nocopy JTF_VARCHAR2_TABLE_300
692: , a15 out nocopy JTF_NUMBER_TABLE
693: , a16 out nocopy JTF_VARCHAR2_TABLE_500
694: , a17 out nocopy JTF_NUMBER_TABLE
688: , a11 out nocopy JTF_NUMBER_TABLE
689: , a12 out nocopy JTF_VARCHAR2_TABLE_300
690: , a13 out nocopy JTF_NUMBER_TABLE
691: , a14 out nocopy JTF_VARCHAR2_TABLE_300
692: , a15 out nocopy JTF_NUMBER_TABLE
693: , a16 out nocopy JTF_VARCHAR2_TABLE_500
694: , a17 out nocopy JTF_NUMBER_TABLE
695: , a18 out nocopy JTF_NUMBER_TABLE
696: , a19 out nocopy JTF_NUMBER_TABLE
690: , a13 out nocopy JTF_NUMBER_TABLE
691: , a14 out nocopy JTF_VARCHAR2_TABLE_300
692: , a15 out nocopy JTF_NUMBER_TABLE
693: , a16 out nocopy JTF_VARCHAR2_TABLE_500
694: , a17 out nocopy JTF_NUMBER_TABLE
695: , a18 out nocopy JTF_NUMBER_TABLE
696: , a19 out nocopy JTF_NUMBER_TABLE
697: , a20 out nocopy JTF_VARCHAR2_TABLE_200
698: , a21 out nocopy JTF_VARCHAR2_TABLE_100
691: , a14 out nocopy JTF_VARCHAR2_TABLE_300
692: , a15 out nocopy JTF_NUMBER_TABLE
693: , a16 out nocopy JTF_VARCHAR2_TABLE_500
694: , a17 out nocopy JTF_NUMBER_TABLE
695: , a18 out nocopy JTF_NUMBER_TABLE
696: , a19 out nocopy JTF_NUMBER_TABLE
697: , a20 out nocopy JTF_VARCHAR2_TABLE_200
698: , a21 out nocopy JTF_VARCHAR2_TABLE_100
699: , a22 out nocopy JTF_NUMBER_TABLE
692: , a15 out nocopy JTF_NUMBER_TABLE
693: , a16 out nocopy JTF_VARCHAR2_TABLE_500
694: , a17 out nocopy JTF_NUMBER_TABLE
695: , a18 out nocopy JTF_NUMBER_TABLE
696: , a19 out nocopy JTF_NUMBER_TABLE
697: , a20 out nocopy JTF_VARCHAR2_TABLE_200
698: , a21 out nocopy JTF_VARCHAR2_TABLE_100
699: , a22 out nocopy JTF_NUMBER_TABLE
700: , a23 out nocopy JTF_VARCHAR2_TABLE_100
695: , a18 out nocopy JTF_NUMBER_TABLE
696: , a19 out nocopy JTF_NUMBER_TABLE
697: , a20 out nocopy JTF_VARCHAR2_TABLE_200
698: , a21 out nocopy JTF_VARCHAR2_TABLE_100
699: , a22 out nocopy JTF_NUMBER_TABLE
700: , a23 out nocopy JTF_VARCHAR2_TABLE_100
701: , a24 out nocopy JTF_NUMBER_TABLE
702: , a25 out nocopy JTF_VARCHAR2_TABLE_100
703: , a26 out nocopy JTF_NUMBER_TABLE
697: , a20 out nocopy JTF_VARCHAR2_TABLE_200
698: , a21 out nocopy JTF_VARCHAR2_TABLE_100
699: , a22 out nocopy JTF_NUMBER_TABLE
700: , a23 out nocopy JTF_VARCHAR2_TABLE_100
701: , a24 out nocopy JTF_NUMBER_TABLE
702: , a25 out nocopy JTF_VARCHAR2_TABLE_100
703: , a26 out nocopy JTF_NUMBER_TABLE
704: , a27 out nocopy JTF_VARCHAR2_TABLE_100
705: , a28 out nocopy JTF_NUMBER_TABLE
699: , a22 out nocopy JTF_NUMBER_TABLE
700: , a23 out nocopy JTF_VARCHAR2_TABLE_100
701: , a24 out nocopy JTF_NUMBER_TABLE
702: , a25 out nocopy JTF_VARCHAR2_TABLE_100
703: , a26 out nocopy JTF_NUMBER_TABLE
704: , a27 out nocopy JTF_VARCHAR2_TABLE_100
705: , a28 out nocopy JTF_NUMBER_TABLE
706: , a29 out nocopy JTF_VARCHAR2_TABLE_100
707: , a30 out nocopy JTF_NUMBER_TABLE
701: , a24 out nocopy JTF_NUMBER_TABLE
702: , a25 out nocopy JTF_VARCHAR2_TABLE_100
703: , a26 out nocopy JTF_NUMBER_TABLE
704: , a27 out nocopy JTF_VARCHAR2_TABLE_100
705: , a28 out nocopy JTF_NUMBER_TABLE
706: , a29 out nocopy JTF_VARCHAR2_TABLE_100
707: , a30 out nocopy JTF_NUMBER_TABLE
708: , a31 out nocopy JTF_VARCHAR2_TABLE_100
709: , a32 out nocopy JTF_NUMBER_TABLE
703: , a26 out nocopy JTF_NUMBER_TABLE
704: , a27 out nocopy JTF_VARCHAR2_TABLE_100
705: , a28 out nocopy JTF_NUMBER_TABLE
706: , a29 out nocopy JTF_VARCHAR2_TABLE_100
707: , a30 out nocopy JTF_NUMBER_TABLE
708: , a31 out nocopy JTF_VARCHAR2_TABLE_100
709: , a32 out nocopy JTF_NUMBER_TABLE
710: , a33 out nocopy JTF_VARCHAR2_TABLE_100
711: , a34 out nocopy JTF_VARCHAR2_TABLE_100
705: , a28 out nocopy JTF_NUMBER_TABLE
706: , a29 out nocopy JTF_VARCHAR2_TABLE_100
707: , a30 out nocopy JTF_NUMBER_TABLE
708: , a31 out nocopy JTF_VARCHAR2_TABLE_100
709: , a32 out nocopy JTF_NUMBER_TABLE
710: , a33 out nocopy JTF_VARCHAR2_TABLE_100
711: , a34 out nocopy JTF_VARCHAR2_TABLE_100
712: ) as
713: ddindx binary_integer; indx binary_integer;
713: ddindx binary_integer; indx binary_integer;
714: begin
715: if t is null or t.count = 0 then
716: a0 := JTF_VARCHAR2_TABLE_100();
717: a1 := JTF_NUMBER_TABLE();
718: a2 := JTF_NUMBER_TABLE();
719: a3 := JTF_NUMBER_TABLE();
720: a4 := JTF_VARCHAR2_TABLE_200();
721: a5 := JTF_NUMBER_TABLE();
714: begin
715: if t is null or t.count = 0 then
716: a0 := JTF_VARCHAR2_TABLE_100();
717: a1 := JTF_NUMBER_TABLE();
718: a2 := JTF_NUMBER_TABLE();
719: a3 := JTF_NUMBER_TABLE();
720: a4 := JTF_VARCHAR2_TABLE_200();
721: a5 := JTF_NUMBER_TABLE();
722: a6 := JTF_VARCHAR2_TABLE_300();
715: if t is null or t.count = 0 then
716: a0 := JTF_VARCHAR2_TABLE_100();
717: a1 := JTF_NUMBER_TABLE();
718: a2 := JTF_NUMBER_TABLE();
719: a3 := JTF_NUMBER_TABLE();
720: a4 := JTF_VARCHAR2_TABLE_200();
721: a5 := JTF_NUMBER_TABLE();
722: a6 := JTF_VARCHAR2_TABLE_300();
723: a7 := JTF_NUMBER_TABLE();
717: a1 := JTF_NUMBER_TABLE();
718: a2 := JTF_NUMBER_TABLE();
719: a3 := JTF_NUMBER_TABLE();
720: a4 := JTF_VARCHAR2_TABLE_200();
721: a5 := JTF_NUMBER_TABLE();
722: a6 := JTF_VARCHAR2_TABLE_300();
723: a7 := JTF_NUMBER_TABLE();
724: a8 := JTF_VARCHAR2_TABLE_300();
725: a9 := JTF_NUMBER_TABLE();
719: a3 := JTF_NUMBER_TABLE();
720: a4 := JTF_VARCHAR2_TABLE_200();
721: a5 := JTF_NUMBER_TABLE();
722: a6 := JTF_VARCHAR2_TABLE_300();
723: a7 := JTF_NUMBER_TABLE();
724: a8 := JTF_VARCHAR2_TABLE_300();
725: a9 := JTF_NUMBER_TABLE();
726: a10 := JTF_VARCHAR2_TABLE_300();
727: a11 := JTF_NUMBER_TABLE();
721: a5 := JTF_NUMBER_TABLE();
722: a6 := JTF_VARCHAR2_TABLE_300();
723: a7 := JTF_NUMBER_TABLE();
724: a8 := JTF_VARCHAR2_TABLE_300();
725: a9 := JTF_NUMBER_TABLE();
726: a10 := JTF_VARCHAR2_TABLE_300();
727: a11 := JTF_NUMBER_TABLE();
728: a12 := JTF_VARCHAR2_TABLE_300();
729: a13 := JTF_NUMBER_TABLE();
723: a7 := JTF_NUMBER_TABLE();
724: a8 := JTF_VARCHAR2_TABLE_300();
725: a9 := JTF_NUMBER_TABLE();
726: a10 := JTF_VARCHAR2_TABLE_300();
727: a11 := JTF_NUMBER_TABLE();
728: a12 := JTF_VARCHAR2_TABLE_300();
729: a13 := JTF_NUMBER_TABLE();
730: a14 := JTF_VARCHAR2_TABLE_300();
731: a15 := JTF_NUMBER_TABLE();
725: a9 := JTF_NUMBER_TABLE();
726: a10 := JTF_VARCHAR2_TABLE_300();
727: a11 := JTF_NUMBER_TABLE();
728: a12 := JTF_VARCHAR2_TABLE_300();
729: a13 := JTF_NUMBER_TABLE();
730: a14 := JTF_VARCHAR2_TABLE_300();
731: a15 := JTF_NUMBER_TABLE();
732: a16 := JTF_VARCHAR2_TABLE_500();
733: a17 := JTF_NUMBER_TABLE();
727: a11 := JTF_NUMBER_TABLE();
728: a12 := JTF_VARCHAR2_TABLE_300();
729: a13 := JTF_NUMBER_TABLE();
730: a14 := JTF_VARCHAR2_TABLE_300();
731: a15 := JTF_NUMBER_TABLE();
732: a16 := JTF_VARCHAR2_TABLE_500();
733: a17 := JTF_NUMBER_TABLE();
734: a18 := JTF_NUMBER_TABLE();
735: a19 := JTF_NUMBER_TABLE();
729: a13 := JTF_NUMBER_TABLE();
730: a14 := JTF_VARCHAR2_TABLE_300();
731: a15 := JTF_NUMBER_TABLE();
732: a16 := JTF_VARCHAR2_TABLE_500();
733: a17 := JTF_NUMBER_TABLE();
734: a18 := JTF_NUMBER_TABLE();
735: a19 := JTF_NUMBER_TABLE();
736: a20 := JTF_VARCHAR2_TABLE_200();
737: a21 := JTF_VARCHAR2_TABLE_100();
730: a14 := JTF_VARCHAR2_TABLE_300();
731: a15 := JTF_NUMBER_TABLE();
732: a16 := JTF_VARCHAR2_TABLE_500();
733: a17 := JTF_NUMBER_TABLE();
734: a18 := JTF_NUMBER_TABLE();
735: a19 := JTF_NUMBER_TABLE();
736: a20 := JTF_VARCHAR2_TABLE_200();
737: a21 := JTF_VARCHAR2_TABLE_100();
738: a22 := JTF_NUMBER_TABLE();
731: a15 := JTF_NUMBER_TABLE();
732: a16 := JTF_VARCHAR2_TABLE_500();
733: a17 := JTF_NUMBER_TABLE();
734: a18 := JTF_NUMBER_TABLE();
735: a19 := JTF_NUMBER_TABLE();
736: a20 := JTF_VARCHAR2_TABLE_200();
737: a21 := JTF_VARCHAR2_TABLE_100();
738: a22 := JTF_NUMBER_TABLE();
739: a23 := JTF_VARCHAR2_TABLE_100();
734: a18 := JTF_NUMBER_TABLE();
735: a19 := JTF_NUMBER_TABLE();
736: a20 := JTF_VARCHAR2_TABLE_200();
737: a21 := JTF_VARCHAR2_TABLE_100();
738: a22 := JTF_NUMBER_TABLE();
739: a23 := JTF_VARCHAR2_TABLE_100();
740: a24 := JTF_NUMBER_TABLE();
741: a25 := JTF_VARCHAR2_TABLE_100();
742: a26 := JTF_NUMBER_TABLE();
736: a20 := JTF_VARCHAR2_TABLE_200();
737: a21 := JTF_VARCHAR2_TABLE_100();
738: a22 := JTF_NUMBER_TABLE();
739: a23 := JTF_VARCHAR2_TABLE_100();
740: a24 := JTF_NUMBER_TABLE();
741: a25 := JTF_VARCHAR2_TABLE_100();
742: a26 := JTF_NUMBER_TABLE();
743: a27 := JTF_VARCHAR2_TABLE_100();
744: a28 := JTF_NUMBER_TABLE();
738: a22 := JTF_NUMBER_TABLE();
739: a23 := JTF_VARCHAR2_TABLE_100();
740: a24 := JTF_NUMBER_TABLE();
741: a25 := JTF_VARCHAR2_TABLE_100();
742: a26 := JTF_NUMBER_TABLE();
743: a27 := JTF_VARCHAR2_TABLE_100();
744: a28 := JTF_NUMBER_TABLE();
745: a29 := JTF_VARCHAR2_TABLE_100();
746: a30 := JTF_NUMBER_TABLE();
740: a24 := JTF_NUMBER_TABLE();
741: a25 := JTF_VARCHAR2_TABLE_100();
742: a26 := JTF_NUMBER_TABLE();
743: a27 := JTF_VARCHAR2_TABLE_100();
744: a28 := JTF_NUMBER_TABLE();
745: a29 := JTF_VARCHAR2_TABLE_100();
746: a30 := JTF_NUMBER_TABLE();
747: a31 := JTF_VARCHAR2_TABLE_100();
748: a32 := JTF_NUMBER_TABLE();
742: a26 := JTF_NUMBER_TABLE();
743: a27 := JTF_VARCHAR2_TABLE_100();
744: a28 := JTF_NUMBER_TABLE();
745: a29 := JTF_VARCHAR2_TABLE_100();
746: a30 := JTF_NUMBER_TABLE();
747: a31 := JTF_VARCHAR2_TABLE_100();
748: a32 := JTF_NUMBER_TABLE();
749: a33 := JTF_VARCHAR2_TABLE_100();
750: a34 := JTF_VARCHAR2_TABLE_100();
744: a28 := JTF_NUMBER_TABLE();
745: a29 := JTF_VARCHAR2_TABLE_100();
746: a30 := JTF_NUMBER_TABLE();
747: a31 := JTF_VARCHAR2_TABLE_100();
748: a32 := JTF_NUMBER_TABLE();
749: a33 := JTF_VARCHAR2_TABLE_100();
750: a34 := JTF_VARCHAR2_TABLE_100();
751: else
752: a0 := JTF_VARCHAR2_TABLE_100();
749: a33 := JTF_VARCHAR2_TABLE_100();
750: a34 := JTF_VARCHAR2_TABLE_100();
751: else
752: a0 := JTF_VARCHAR2_TABLE_100();
753: a1 := JTF_NUMBER_TABLE();
754: a2 := JTF_NUMBER_TABLE();
755: a3 := JTF_NUMBER_TABLE();
756: a4 := JTF_VARCHAR2_TABLE_200();
757: a5 := JTF_NUMBER_TABLE();
750: a34 := JTF_VARCHAR2_TABLE_100();
751: else
752: a0 := JTF_VARCHAR2_TABLE_100();
753: a1 := JTF_NUMBER_TABLE();
754: a2 := JTF_NUMBER_TABLE();
755: a3 := JTF_NUMBER_TABLE();
756: a4 := JTF_VARCHAR2_TABLE_200();
757: a5 := JTF_NUMBER_TABLE();
758: a6 := JTF_VARCHAR2_TABLE_300();
751: else
752: a0 := JTF_VARCHAR2_TABLE_100();
753: a1 := JTF_NUMBER_TABLE();
754: a2 := JTF_NUMBER_TABLE();
755: a3 := JTF_NUMBER_TABLE();
756: a4 := JTF_VARCHAR2_TABLE_200();
757: a5 := JTF_NUMBER_TABLE();
758: a6 := JTF_VARCHAR2_TABLE_300();
759: a7 := JTF_NUMBER_TABLE();
753: a1 := JTF_NUMBER_TABLE();
754: a2 := JTF_NUMBER_TABLE();
755: a3 := JTF_NUMBER_TABLE();
756: a4 := JTF_VARCHAR2_TABLE_200();
757: a5 := JTF_NUMBER_TABLE();
758: a6 := JTF_VARCHAR2_TABLE_300();
759: a7 := JTF_NUMBER_TABLE();
760: a8 := JTF_VARCHAR2_TABLE_300();
761: a9 := JTF_NUMBER_TABLE();
755: a3 := JTF_NUMBER_TABLE();
756: a4 := JTF_VARCHAR2_TABLE_200();
757: a5 := JTF_NUMBER_TABLE();
758: a6 := JTF_VARCHAR2_TABLE_300();
759: a7 := JTF_NUMBER_TABLE();
760: a8 := JTF_VARCHAR2_TABLE_300();
761: a9 := JTF_NUMBER_TABLE();
762: a10 := JTF_VARCHAR2_TABLE_300();
763: a11 := JTF_NUMBER_TABLE();
757: a5 := JTF_NUMBER_TABLE();
758: a6 := JTF_VARCHAR2_TABLE_300();
759: a7 := JTF_NUMBER_TABLE();
760: a8 := JTF_VARCHAR2_TABLE_300();
761: a9 := JTF_NUMBER_TABLE();
762: a10 := JTF_VARCHAR2_TABLE_300();
763: a11 := JTF_NUMBER_TABLE();
764: a12 := JTF_VARCHAR2_TABLE_300();
765: a13 := JTF_NUMBER_TABLE();
759: a7 := JTF_NUMBER_TABLE();
760: a8 := JTF_VARCHAR2_TABLE_300();
761: a9 := JTF_NUMBER_TABLE();
762: a10 := JTF_VARCHAR2_TABLE_300();
763: a11 := JTF_NUMBER_TABLE();
764: a12 := JTF_VARCHAR2_TABLE_300();
765: a13 := JTF_NUMBER_TABLE();
766: a14 := JTF_VARCHAR2_TABLE_300();
767: a15 := JTF_NUMBER_TABLE();
761: a9 := JTF_NUMBER_TABLE();
762: a10 := JTF_VARCHAR2_TABLE_300();
763: a11 := JTF_NUMBER_TABLE();
764: a12 := JTF_VARCHAR2_TABLE_300();
765: a13 := JTF_NUMBER_TABLE();
766: a14 := JTF_VARCHAR2_TABLE_300();
767: a15 := JTF_NUMBER_TABLE();
768: a16 := JTF_VARCHAR2_TABLE_500();
769: a17 := JTF_NUMBER_TABLE();
763: a11 := JTF_NUMBER_TABLE();
764: a12 := JTF_VARCHAR2_TABLE_300();
765: a13 := JTF_NUMBER_TABLE();
766: a14 := JTF_VARCHAR2_TABLE_300();
767: a15 := JTF_NUMBER_TABLE();
768: a16 := JTF_VARCHAR2_TABLE_500();
769: a17 := JTF_NUMBER_TABLE();
770: a18 := JTF_NUMBER_TABLE();
771: a19 := JTF_NUMBER_TABLE();
765: a13 := JTF_NUMBER_TABLE();
766: a14 := JTF_VARCHAR2_TABLE_300();
767: a15 := JTF_NUMBER_TABLE();
768: a16 := JTF_VARCHAR2_TABLE_500();
769: a17 := JTF_NUMBER_TABLE();
770: a18 := JTF_NUMBER_TABLE();
771: a19 := JTF_NUMBER_TABLE();
772: a20 := JTF_VARCHAR2_TABLE_200();
773: a21 := JTF_VARCHAR2_TABLE_100();
766: a14 := JTF_VARCHAR2_TABLE_300();
767: a15 := JTF_NUMBER_TABLE();
768: a16 := JTF_VARCHAR2_TABLE_500();
769: a17 := JTF_NUMBER_TABLE();
770: a18 := JTF_NUMBER_TABLE();
771: a19 := JTF_NUMBER_TABLE();
772: a20 := JTF_VARCHAR2_TABLE_200();
773: a21 := JTF_VARCHAR2_TABLE_100();
774: a22 := JTF_NUMBER_TABLE();
767: a15 := JTF_NUMBER_TABLE();
768: a16 := JTF_VARCHAR2_TABLE_500();
769: a17 := JTF_NUMBER_TABLE();
770: a18 := JTF_NUMBER_TABLE();
771: a19 := JTF_NUMBER_TABLE();
772: a20 := JTF_VARCHAR2_TABLE_200();
773: a21 := JTF_VARCHAR2_TABLE_100();
774: a22 := JTF_NUMBER_TABLE();
775: a23 := JTF_VARCHAR2_TABLE_100();
770: a18 := JTF_NUMBER_TABLE();
771: a19 := JTF_NUMBER_TABLE();
772: a20 := JTF_VARCHAR2_TABLE_200();
773: a21 := JTF_VARCHAR2_TABLE_100();
774: a22 := JTF_NUMBER_TABLE();
775: a23 := JTF_VARCHAR2_TABLE_100();
776: a24 := JTF_NUMBER_TABLE();
777: a25 := JTF_VARCHAR2_TABLE_100();
778: a26 := JTF_NUMBER_TABLE();
772: a20 := JTF_VARCHAR2_TABLE_200();
773: a21 := JTF_VARCHAR2_TABLE_100();
774: a22 := JTF_NUMBER_TABLE();
775: a23 := JTF_VARCHAR2_TABLE_100();
776: a24 := JTF_NUMBER_TABLE();
777: a25 := JTF_VARCHAR2_TABLE_100();
778: a26 := JTF_NUMBER_TABLE();
779: a27 := JTF_VARCHAR2_TABLE_100();
780: a28 := JTF_NUMBER_TABLE();
774: a22 := JTF_NUMBER_TABLE();
775: a23 := JTF_VARCHAR2_TABLE_100();
776: a24 := JTF_NUMBER_TABLE();
777: a25 := JTF_VARCHAR2_TABLE_100();
778: a26 := JTF_NUMBER_TABLE();
779: a27 := JTF_VARCHAR2_TABLE_100();
780: a28 := JTF_NUMBER_TABLE();
781: a29 := JTF_VARCHAR2_TABLE_100();
782: a30 := JTF_NUMBER_TABLE();
776: a24 := JTF_NUMBER_TABLE();
777: a25 := JTF_VARCHAR2_TABLE_100();
778: a26 := JTF_NUMBER_TABLE();
779: a27 := JTF_VARCHAR2_TABLE_100();
780: a28 := JTF_NUMBER_TABLE();
781: a29 := JTF_VARCHAR2_TABLE_100();
782: a30 := JTF_NUMBER_TABLE();
783: a31 := JTF_VARCHAR2_TABLE_100();
784: a32 := JTF_NUMBER_TABLE();
778: a26 := JTF_NUMBER_TABLE();
779: a27 := JTF_VARCHAR2_TABLE_100();
780: a28 := JTF_NUMBER_TABLE();
781: a29 := JTF_VARCHAR2_TABLE_100();
782: a30 := JTF_NUMBER_TABLE();
783: a31 := JTF_VARCHAR2_TABLE_100();
784: a32 := JTF_NUMBER_TABLE();
785: a33 := JTF_VARCHAR2_TABLE_100();
786: a34 := JTF_VARCHAR2_TABLE_100();
780: a28 := JTF_NUMBER_TABLE();
781: a29 := JTF_VARCHAR2_TABLE_100();
782: a30 := JTF_NUMBER_TABLE();
783: a31 := JTF_VARCHAR2_TABLE_100();
784: a32 := JTF_NUMBER_TABLE();
785: a33 := JTF_VARCHAR2_TABLE_100();
786: a34 := JTF_VARCHAR2_TABLE_100();
787: if t.count > 0 then
788: a0.extend(t.count);
867: end if;
868: end if;
869: end rosetta_table_copy_out_p22;
870:
871: procedure rosetta_table_copy_in_p26(t out nocopy oks_entitlements_pub.ent_cont_tbl, a0 JTF_NUMBER_TABLE
872: , a1 JTF_VARCHAR2_TABLE_200
873: , a2 JTF_VARCHAR2_TABLE_200
874: , a3 JTF_NUMBER_TABLE
875: , a4 JTF_VARCHAR2_TABLE_300
870:
871: procedure rosetta_table_copy_in_p26(t out nocopy oks_entitlements_pub.ent_cont_tbl, a0 JTF_NUMBER_TABLE
872: , a1 JTF_VARCHAR2_TABLE_200
873: , a2 JTF_VARCHAR2_TABLE_200
874: , a3 JTF_NUMBER_TABLE
875: , a4 JTF_VARCHAR2_TABLE_300
876: , a5 JTF_VARCHAR2_TABLE_300
877: , a6 JTF_NUMBER_TABLE
878: , a7 JTF_VARCHAR2_TABLE_200
873: , a2 JTF_VARCHAR2_TABLE_200
874: , a3 JTF_NUMBER_TABLE
875: , a4 JTF_VARCHAR2_TABLE_300
876: , a5 JTF_VARCHAR2_TABLE_300
877: , a6 JTF_NUMBER_TABLE
878: , a7 JTF_VARCHAR2_TABLE_200
879: , a8 JTF_VARCHAR2_TABLE_2000
880: , a9 JTF_VARCHAR2_TABLE_100
881: , a10 JTF_VARCHAR2_TABLE_100
878: , a7 JTF_VARCHAR2_TABLE_200
879: , a8 JTF_VARCHAR2_TABLE_2000
880: , a9 JTF_VARCHAR2_TABLE_100
881: , a10 JTF_VARCHAR2_TABLE_100
882: , a11 JTF_NUMBER_TABLE
883: , a12 JTF_NUMBER_TABLE
884: , a13 JTF_VARCHAR2_TABLE_200
885: , a14 JTF_VARCHAR2_TABLE_100
886: , a15 JTF_DATE_TABLE
879: , a8 JTF_VARCHAR2_TABLE_2000
880: , a9 JTF_VARCHAR2_TABLE_100
881: , a10 JTF_VARCHAR2_TABLE_100
882: , a11 JTF_NUMBER_TABLE
883: , a12 JTF_NUMBER_TABLE
884: , a13 JTF_VARCHAR2_TABLE_200
885: , a14 JTF_VARCHAR2_TABLE_100
886: , a15 JTF_DATE_TABLE
887: , a16 JTF_DATE_TABLE
884: , a13 JTF_VARCHAR2_TABLE_200
885: , a14 JTF_VARCHAR2_TABLE_100
886: , a15 JTF_DATE_TABLE
887: , a16 JTF_DATE_TABLE
888: , a17 JTF_NUMBER_TABLE
889: , a18 JTF_VARCHAR2_TABLE_100
890: , a19 JTF_VARCHAR2_TABLE_100
891: ) as
892: ddindx binary_integer; indx binary_integer;
924: end loop;
925: end if;
926: end if;
927: end rosetta_table_copy_in_p26;
928: procedure rosetta_table_copy_out_p26(t oks_entitlements_pub.ent_cont_tbl, a0 out nocopy JTF_NUMBER_TABLE
929: , a1 out nocopy JTF_VARCHAR2_TABLE_200
930: , a2 out nocopy JTF_VARCHAR2_TABLE_200
931: , a3 out nocopy JTF_NUMBER_TABLE
932: , a4 out nocopy JTF_VARCHAR2_TABLE_300
927: end rosetta_table_copy_in_p26;
928: procedure rosetta_table_copy_out_p26(t oks_entitlements_pub.ent_cont_tbl, a0 out nocopy JTF_NUMBER_TABLE
929: , a1 out nocopy JTF_VARCHAR2_TABLE_200
930: , a2 out nocopy JTF_VARCHAR2_TABLE_200
931: , a3 out nocopy JTF_NUMBER_TABLE
932: , a4 out nocopy JTF_VARCHAR2_TABLE_300
933: , a5 out nocopy JTF_VARCHAR2_TABLE_300
934: , a6 out nocopy JTF_NUMBER_TABLE
935: , a7 out nocopy JTF_VARCHAR2_TABLE_200
930: , a2 out nocopy JTF_VARCHAR2_TABLE_200
931: , a3 out nocopy JTF_NUMBER_TABLE
932: , a4 out nocopy JTF_VARCHAR2_TABLE_300
933: , a5 out nocopy JTF_VARCHAR2_TABLE_300
934: , a6 out nocopy JTF_NUMBER_TABLE
935: , a7 out nocopy JTF_VARCHAR2_TABLE_200
936: , a8 out nocopy JTF_VARCHAR2_TABLE_2000
937: , a9 out nocopy JTF_VARCHAR2_TABLE_100
938: , a10 out nocopy JTF_VARCHAR2_TABLE_100
935: , a7 out nocopy JTF_VARCHAR2_TABLE_200
936: , a8 out nocopy JTF_VARCHAR2_TABLE_2000
937: , a9 out nocopy JTF_VARCHAR2_TABLE_100
938: , a10 out nocopy JTF_VARCHAR2_TABLE_100
939: , a11 out nocopy JTF_NUMBER_TABLE
940: , a12 out nocopy JTF_NUMBER_TABLE
941: , a13 out nocopy JTF_VARCHAR2_TABLE_200
942: , a14 out nocopy JTF_VARCHAR2_TABLE_100
943: , a15 out nocopy JTF_DATE_TABLE
936: , a8 out nocopy JTF_VARCHAR2_TABLE_2000
937: , a9 out nocopy JTF_VARCHAR2_TABLE_100
938: , a10 out nocopy JTF_VARCHAR2_TABLE_100
939: , a11 out nocopy JTF_NUMBER_TABLE
940: , a12 out nocopy JTF_NUMBER_TABLE
941: , a13 out nocopy JTF_VARCHAR2_TABLE_200
942: , a14 out nocopy JTF_VARCHAR2_TABLE_100
943: , a15 out nocopy JTF_DATE_TABLE
944: , a16 out nocopy JTF_DATE_TABLE
941: , a13 out nocopy JTF_VARCHAR2_TABLE_200
942: , a14 out nocopy JTF_VARCHAR2_TABLE_100
943: , a15 out nocopy JTF_DATE_TABLE
944: , a16 out nocopy JTF_DATE_TABLE
945: , a17 out nocopy JTF_NUMBER_TABLE
946: , a18 out nocopy JTF_VARCHAR2_TABLE_100
947: , a19 out nocopy JTF_VARCHAR2_TABLE_100
948: ) as
949: ddindx binary_integer; indx binary_integer;
948: ) as
949: ddindx binary_integer; indx binary_integer;
950: begin
951: if t is null or t.count = 0 then
952: a0 := JTF_NUMBER_TABLE();
953: a1 := JTF_VARCHAR2_TABLE_200();
954: a2 := JTF_VARCHAR2_TABLE_200();
955: a3 := JTF_NUMBER_TABLE();
956: a4 := JTF_VARCHAR2_TABLE_300();
951: if t is null or t.count = 0 then
952: a0 := JTF_NUMBER_TABLE();
953: a1 := JTF_VARCHAR2_TABLE_200();
954: a2 := JTF_VARCHAR2_TABLE_200();
955: a3 := JTF_NUMBER_TABLE();
956: a4 := JTF_VARCHAR2_TABLE_300();
957: a5 := JTF_VARCHAR2_TABLE_300();
958: a6 := JTF_NUMBER_TABLE();
959: a7 := JTF_VARCHAR2_TABLE_200();
954: a2 := JTF_VARCHAR2_TABLE_200();
955: a3 := JTF_NUMBER_TABLE();
956: a4 := JTF_VARCHAR2_TABLE_300();
957: a5 := JTF_VARCHAR2_TABLE_300();
958: a6 := JTF_NUMBER_TABLE();
959: a7 := JTF_VARCHAR2_TABLE_200();
960: a8 := JTF_VARCHAR2_TABLE_2000();
961: a9 := JTF_VARCHAR2_TABLE_100();
962: a10 := JTF_VARCHAR2_TABLE_100();
959: a7 := JTF_VARCHAR2_TABLE_200();
960: a8 := JTF_VARCHAR2_TABLE_2000();
961: a9 := JTF_VARCHAR2_TABLE_100();
962: a10 := JTF_VARCHAR2_TABLE_100();
963: a11 := JTF_NUMBER_TABLE();
964: a12 := JTF_NUMBER_TABLE();
965: a13 := JTF_VARCHAR2_TABLE_200();
966: a14 := JTF_VARCHAR2_TABLE_100();
967: a15 := JTF_DATE_TABLE();
960: a8 := JTF_VARCHAR2_TABLE_2000();
961: a9 := JTF_VARCHAR2_TABLE_100();
962: a10 := JTF_VARCHAR2_TABLE_100();
963: a11 := JTF_NUMBER_TABLE();
964: a12 := JTF_NUMBER_TABLE();
965: a13 := JTF_VARCHAR2_TABLE_200();
966: a14 := JTF_VARCHAR2_TABLE_100();
967: a15 := JTF_DATE_TABLE();
968: a16 := JTF_DATE_TABLE();
965: a13 := JTF_VARCHAR2_TABLE_200();
966: a14 := JTF_VARCHAR2_TABLE_100();
967: a15 := JTF_DATE_TABLE();
968: a16 := JTF_DATE_TABLE();
969: a17 := JTF_NUMBER_TABLE();
970: a18 := JTF_VARCHAR2_TABLE_100();
971: a19 := JTF_VARCHAR2_TABLE_100();
972: else
973: a0 := JTF_NUMBER_TABLE();
969: a17 := JTF_NUMBER_TABLE();
970: a18 := JTF_VARCHAR2_TABLE_100();
971: a19 := JTF_VARCHAR2_TABLE_100();
972: else
973: a0 := JTF_NUMBER_TABLE();
974: a1 := JTF_VARCHAR2_TABLE_200();
975: a2 := JTF_VARCHAR2_TABLE_200();
976: a3 := JTF_NUMBER_TABLE();
977: a4 := JTF_VARCHAR2_TABLE_300();
972: else
973: a0 := JTF_NUMBER_TABLE();
974: a1 := JTF_VARCHAR2_TABLE_200();
975: a2 := JTF_VARCHAR2_TABLE_200();
976: a3 := JTF_NUMBER_TABLE();
977: a4 := JTF_VARCHAR2_TABLE_300();
978: a5 := JTF_VARCHAR2_TABLE_300();
979: a6 := JTF_NUMBER_TABLE();
980: a7 := JTF_VARCHAR2_TABLE_200();
975: a2 := JTF_VARCHAR2_TABLE_200();
976: a3 := JTF_NUMBER_TABLE();
977: a4 := JTF_VARCHAR2_TABLE_300();
978: a5 := JTF_VARCHAR2_TABLE_300();
979: a6 := JTF_NUMBER_TABLE();
980: a7 := JTF_VARCHAR2_TABLE_200();
981: a8 := JTF_VARCHAR2_TABLE_2000();
982: a9 := JTF_VARCHAR2_TABLE_100();
983: a10 := JTF_VARCHAR2_TABLE_100();
980: a7 := JTF_VARCHAR2_TABLE_200();
981: a8 := JTF_VARCHAR2_TABLE_2000();
982: a9 := JTF_VARCHAR2_TABLE_100();
983: a10 := JTF_VARCHAR2_TABLE_100();
984: a11 := JTF_NUMBER_TABLE();
985: a12 := JTF_NUMBER_TABLE();
986: a13 := JTF_VARCHAR2_TABLE_200();
987: a14 := JTF_VARCHAR2_TABLE_100();
988: a15 := JTF_DATE_TABLE();
981: a8 := JTF_VARCHAR2_TABLE_2000();
982: a9 := JTF_VARCHAR2_TABLE_100();
983: a10 := JTF_VARCHAR2_TABLE_100();
984: a11 := JTF_NUMBER_TABLE();
985: a12 := JTF_NUMBER_TABLE();
986: a13 := JTF_VARCHAR2_TABLE_200();
987: a14 := JTF_VARCHAR2_TABLE_100();
988: a15 := JTF_DATE_TABLE();
989: a16 := JTF_DATE_TABLE();
986: a13 := JTF_VARCHAR2_TABLE_200();
987: a14 := JTF_VARCHAR2_TABLE_100();
988: a15 := JTF_DATE_TABLE();
989: a16 := JTF_DATE_TABLE();
990: a17 := JTF_NUMBER_TABLE();
991: a18 := JTF_VARCHAR2_TABLE_100();
992: a19 := JTF_VARCHAR2_TABLE_100();
993: if t.count > 0 then
994: a0.extend(t.count);
1043: end if;
1044: end if;
1045: end rosetta_table_copy_out_p26;
1046:
1047: procedure rosetta_table_copy_in_p30(t out nocopy oks_entitlements_pub.get_contop_tbl, a0 JTF_NUMBER_TABLE
1048: , a1 JTF_VARCHAR2_TABLE_200
1049: , a2 JTF_VARCHAR2_TABLE_200
1050: , a3 JTF_VARCHAR2_TABLE_100
1051: , a4 JTF_NUMBER_TABLE
1047: procedure rosetta_table_copy_in_p30(t out nocopy oks_entitlements_pub.get_contop_tbl, a0 JTF_NUMBER_TABLE
1048: , a1 JTF_VARCHAR2_TABLE_200
1049: , a2 JTF_VARCHAR2_TABLE_200
1050: , a3 JTF_VARCHAR2_TABLE_100
1051: , a4 JTF_NUMBER_TABLE
1052: , a5 JTF_VARCHAR2_TABLE_300
1053: , a6 JTF_VARCHAR2_TABLE_300
1054: , a7 JTF_NUMBER_TABLE
1055: , a8 JTF_VARCHAR2_TABLE_200
1050: , a3 JTF_VARCHAR2_TABLE_100
1051: , a4 JTF_NUMBER_TABLE
1052: , a5 JTF_VARCHAR2_TABLE_300
1053: , a6 JTF_VARCHAR2_TABLE_300
1054: , a7 JTF_NUMBER_TABLE
1055: , a8 JTF_VARCHAR2_TABLE_200
1056: , a9 JTF_VARCHAR2_TABLE_2000
1057: , a10 JTF_VARCHAR2_TABLE_100
1058: , a11 JTF_VARCHAR2_TABLE_100
1055: , a8 JTF_VARCHAR2_TABLE_200
1056: , a9 JTF_VARCHAR2_TABLE_2000
1057: , a10 JTF_VARCHAR2_TABLE_100
1058: , a11 JTF_VARCHAR2_TABLE_100
1059: , a12 JTF_NUMBER_TABLE
1060: , a13 JTF_DATE_TABLE
1061: , a14 JTF_DATE_TABLE
1062: , a15 JTF_VARCHAR2_TABLE_100
1063: , a16 JTF_VARCHAR2_TABLE_100
1070: , a23 JTF_VARCHAR2_TABLE_500
1071: , a24 JTF_VARCHAR2_TABLE_100
1072: , a25 JTF_VARCHAR2_TABLE_500
1073: , a26 JTF_VARCHAR2_TABLE_100
1074: , a27 JTF_NUMBER_TABLE
1075: ) as
1076: ddindx binary_integer; indx binary_integer;
1077: begin
1078: if a0 is not null and a0.count > 0 then
1116: end loop;
1117: end if;
1118: end if;
1119: end rosetta_table_copy_in_p30;
1120: procedure rosetta_table_copy_out_p30(t oks_entitlements_pub.get_contop_tbl, a0 out nocopy JTF_NUMBER_TABLE
1121: , a1 out nocopy JTF_VARCHAR2_TABLE_200
1122: , a2 out nocopy JTF_VARCHAR2_TABLE_200
1123: , a3 out nocopy JTF_VARCHAR2_TABLE_100
1124: , a4 out nocopy JTF_NUMBER_TABLE
1120: procedure rosetta_table_copy_out_p30(t oks_entitlements_pub.get_contop_tbl, a0 out nocopy JTF_NUMBER_TABLE
1121: , a1 out nocopy JTF_VARCHAR2_TABLE_200
1122: , a2 out nocopy JTF_VARCHAR2_TABLE_200
1123: , a3 out nocopy JTF_VARCHAR2_TABLE_100
1124: , a4 out nocopy JTF_NUMBER_TABLE
1125: , a5 out nocopy JTF_VARCHAR2_TABLE_300
1126: , a6 out nocopy JTF_VARCHAR2_TABLE_300
1127: , a7 out nocopy JTF_NUMBER_TABLE
1128: , a8 out nocopy JTF_VARCHAR2_TABLE_200
1123: , a3 out nocopy JTF_VARCHAR2_TABLE_100
1124: , a4 out nocopy JTF_NUMBER_TABLE
1125: , a5 out nocopy JTF_VARCHAR2_TABLE_300
1126: , a6 out nocopy JTF_VARCHAR2_TABLE_300
1127: , a7 out nocopy JTF_NUMBER_TABLE
1128: , a8 out nocopy JTF_VARCHAR2_TABLE_200
1129: , a9 out nocopy JTF_VARCHAR2_TABLE_2000
1130: , a10 out nocopy JTF_VARCHAR2_TABLE_100
1131: , a11 out nocopy JTF_VARCHAR2_TABLE_100
1128: , a8 out nocopy JTF_VARCHAR2_TABLE_200
1129: , a9 out nocopy JTF_VARCHAR2_TABLE_2000
1130: , a10 out nocopy JTF_VARCHAR2_TABLE_100
1131: , a11 out nocopy JTF_VARCHAR2_TABLE_100
1132: , a12 out nocopy JTF_NUMBER_TABLE
1133: , a13 out nocopy JTF_DATE_TABLE
1134: , a14 out nocopy JTF_DATE_TABLE
1135: , a15 out nocopy JTF_VARCHAR2_TABLE_100
1136: , a16 out nocopy JTF_VARCHAR2_TABLE_100
1143: , a23 out nocopy JTF_VARCHAR2_TABLE_500
1144: , a24 out nocopy JTF_VARCHAR2_TABLE_100
1145: , a25 out nocopy JTF_VARCHAR2_TABLE_500
1146: , a26 out nocopy JTF_VARCHAR2_TABLE_100
1147: , a27 out nocopy JTF_NUMBER_TABLE
1148: ) as
1149: ddindx binary_integer; indx binary_integer;
1150: begin
1151: if t is null or t.count = 0 then
1148: ) as
1149: ddindx binary_integer; indx binary_integer;
1150: begin
1151: if t is null or t.count = 0 then
1152: a0 := JTF_NUMBER_TABLE();
1153: a1 := JTF_VARCHAR2_TABLE_200();
1154: a2 := JTF_VARCHAR2_TABLE_200();
1155: a3 := JTF_VARCHAR2_TABLE_100();
1156: a4 := JTF_NUMBER_TABLE();
1152: a0 := JTF_NUMBER_TABLE();
1153: a1 := JTF_VARCHAR2_TABLE_200();
1154: a2 := JTF_VARCHAR2_TABLE_200();
1155: a3 := JTF_VARCHAR2_TABLE_100();
1156: a4 := JTF_NUMBER_TABLE();
1157: a5 := JTF_VARCHAR2_TABLE_300();
1158: a6 := JTF_VARCHAR2_TABLE_300();
1159: a7 := JTF_NUMBER_TABLE();
1160: a8 := JTF_VARCHAR2_TABLE_200();
1155: a3 := JTF_VARCHAR2_TABLE_100();
1156: a4 := JTF_NUMBER_TABLE();
1157: a5 := JTF_VARCHAR2_TABLE_300();
1158: a6 := JTF_VARCHAR2_TABLE_300();
1159: a7 := JTF_NUMBER_TABLE();
1160: a8 := JTF_VARCHAR2_TABLE_200();
1161: a9 := JTF_VARCHAR2_TABLE_2000();
1162: a10 := JTF_VARCHAR2_TABLE_100();
1163: a11 := JTF_VARCHAR2_TABLE_100();
1160: a8 := JTF_VARCHAR2_TABLE_200();
1161: a9 := JTF_VARCHAR2_TABLE_2000();
1162: a10 := JTF_VARCHAR2_TABLE_100();
1163: a11 := JTF_VARCHAR2_TABLE_100();
1164: a12 := JTF_NUMBER_TABLE();
1165: a13 := JTF_DATE_TABLE();
1166: a14 := JTF_DATE_TABLE();
1167: a15 := JTF_VARCHAR2_TABLE_100();
1168: a16 := JTF_VARCHAR2_TABLE_100();
1175: a23 := JTF_VARCHAR2_TABLE_500();
1176: a24 := JTF_VARCHAR2_TABLE_100();
1177: a25 := JTF_VARCHAR2_TABLE_500();
1178: a26 := JTF_VARCHAR2_TABLE_100();
1179: a27 := JTF_NUMBER_TABLE();
1180: else
1181: a0 := JTF_NUMBER_TABLE();
1182: a1 := JTF_VARCHAR2_TABLE_200();
1183: a2 := JTF_VARCHAR2_TABLE_200();
1177: a25 := JTF_VARCHAR2_TABLE_500();
1178: a26 := JTF_VARCHAR2_TABLE_100();
1179: a27 := JTF_NUMBER_TABLE();
1180: else
1181: a0 := JTF_NUMBER_TABLE();
1182: a1 := JTF_VARCHAR2_TABLE_200();
1183: a2 := JTF_VARCHAR2_TABLE_200();
1184: a3 := JTF_VARCHAR2_TABLE_100();
1185: a4 := JTF_NUMBER_TABLE();
1181: a0 := JTF_NUMBER_TABLE();
1182: a1 := JTF_VARCHAR2_TABLE_200();
1183: a2 := JTF_VARCHAR2_TABLE_200();
1184: a3 := JTF_VARCHAR2_TABLE_100();
1185: a4 := JTF_NUMBER_TABLE();
1186: a5 := JTF_VARCHAR2_TABLE_300();
1187: a6 := JTF_VARCHAR2_TABLE_300();
1188: a7 := JTF_NUMBER_TABLE();
1189: a8 := JTF_VARCHAR2_TABLE_200();
1184: a3 := JTF_VARCHAR2_TABLE_100();
1185: a4 := JTF_NUMBER_TABLE();
1186: a5 := JTF_VARCHAR2_TABLE_300();
1187: a6 := JTF_VARCHAR2_TABLE_300();
1188: a7 := JTF_NUMBER_TABLE();
1189: a8 := JTF_VARCHAR2_TABLE_200();
1190: a9 := JTF_VARCHAR2_TABLE_2000();
1191: a10 := JTF_VARCHAR2_TABLE_100();
1192: a11 := JTF_VARCHAR2_TABLE_100();
1189: a8 := JTF_VARCHAR2_TABLE_200();
1190: a9 := JTF_VARCHAR2_TABLE_2000();
1191: a10 := JTF_VARCHAR2_TABLE_100();
1192: a11 := JTF_VARCHAR2_TABLE_100();
1193: a12 := JTF_NUMBER_TABLE();
1194: a13 := JTF_DATE_TABLE();
1195: a14 := JTF_DATE_TABLE();
1196: a15 := JTF_VARCHAR2_TABLE_100();
1197: a16 := JTF_VARCHAR2_TABLE_100();
1204: a23 := JTF_VARCHAR2_TABLE_500();
1205: a24 := JTF_VARCHAR2_TABLE_100();
1206: a25 := JTF_VARCHAR2_TABLE_500();
1207: a26 := JTF_VARCHAR2_TABLE_100();
1208: a27 := JTF_NUMBER_TABLE();
1209: if t.count > 0 then
1210: a0.extend(t.count);
1211: a1.extend(t.count);
1212: a2.extend(t.count);
1275: end if;
1276: end if;
1277: end rosetta_table_copy_out_p30;
1278:
1279: procedure rosetta_table_copy_in_p34(t out nocopy oks_entitlements_pub.output_tbl_ib, a0 JTF_NUMBER_TABLE
1280: , a1 JTF_VARCHAR2_TABLE_200
1281: , a2 JTF_VARCHAR2_TABLE_200
1282: , a3 JTF_VARCHAR2_TABLE_100
1283: , a4 JTF_NUMBER_TABLE
1279: procedure rosetta_table_copy_in_p34(t out nocopy oks_entitlements_pub.output_tbl_ib, a0 JTF_NUMBER_TABLE
1280: , a1 JTF_VARCHAR2_TABLE_200
1281: , a2 JTF_VARCHAR2_TABLE_200
1282: , a3 JTF_VARCHAR2_TABLE_100
1283: , a4 JTF_NUMBER_TABLE
1284: , a5 JTF_VARCHAR2_TABLE_300
1285: , a6 JTF_VARCHAR2_TABLE_300
1286: , a7 JTF_NUMBER_TABLE
1287: , a8 JTF_VARCHAR2_TABLE_200
1282: , a3 JTF_VARCHAR2_TABLE_100
1283: , a4 JTF_NUMBER_TABLE
1284: , a5 JTF_VARCHAR2_TABLE_300
1285: , a6 JTF_VARCHAR2_TABLE_300
1286: , a7 JTF_NUMBER_TABLE
1287: , a8 JTF_VARCHAR2_TABLE_200
1288: , a9 JTF_VARCHAR2_TABLE_2000
1289: , a10 JTF_VARCHAR2_TABLE_100
1290: , a11 JTF_NUMBER_TABLE
1286: , a7 JTF_NUMBER_TABLE
1287: , a8 JTF_VARCHAR2_TABLE_200
1288: , a9 JTF_VARCHAR2_TABLE_2000
1289: , a10 JTF_VARCHAR2_TABLE_100
1290: , a11 JTF_NUMBER_TABLE
1291: , a12 JTF_DATE_TABLE
1292: , a13 JTF_DATE_TABLE
1293: , a14 JTF_VARCHAR2_TABLE_100
1294: , a15 JTF_VARCHAR2_TABLE_100
1296: , a17 JTF_DATE_TABLE
1297: , a18 JTF_VARCHAR2_TABLE_100
1298: , a19 JTF_VARCHAR2_TABLE_2000
1299: , a20 JTF_DATE_TABLE
1300: , a21 JTF_NUMBER_TABLE
1301: ) as
1302: ddindx binary_integer; indx binary_integer;
1303: begin
1304: if a0 is not null and a0.count > 0 then
1336: end loop;
1337: end if;
1338: end if;
1339: end rosetta_table_copy_in_p34;
1340: procedure rosetta_table_copy_out_p34(t oks_entitlements_pub.output_tbl_ib, a0 out nocopy JTF_NUMBER_TABLE
1341: , a1 out nocopy JTF_VARCHAR2_TABLE_200
1342: , a2 out nocopy JTF_VARCHAR2_TABLE_200
1343: , a3 out nocopy JTF_VARCHAR2_TABLE_100
1344: , a4 out nocopy JTF_NUMBER_TABLE
1340: procedure rosetta_table_copy_out_p34(t oks_entitlements_pub.output_tbl_ib, a0 out nocopy JTF_NUMBER_TABLE
1341: , a1 out nocopy JTF_VARCHAR2_TABLE_200
1342: , a2 out nocopy JTF_VARCHAR2_TABLE_200
1343: , a3 out nocopy JTF_VARCHAR2_TABLE_100
1344: , a4 out nocopy JTF_NUMBER_TABLE
1345: , a5 out nocopy JTF_VARCHAR2_TABLE_300
1346: , a6 out nocopy JTF_VARCHAR2_TABLE_300
1347: , a7 out nocopy JTF_NUMBER_TABLE
1348: , a8 out nocopy JTF_VARCHAR2_TABLE_200
1343: , a3 out nocopy JTF_VARCHAR2_TABLE_100
1344: , a4 out nocopy JTF_NUMBER_TABLE
1345: , a5 out nocopy JTF_VARCHAR2_TABLE_300
1346: , a6 out nocopy JTF_VARCHAR2_TABLE_300
1347: , a7 out nocopy JTF_NUMBER_TABLE
1348: , a8 out nocopy JTF_VARCHAR2_TABLE_200
1349: , a9 out nocopy JTF_VARCHAR2_TABLE_2000
1350: , a10 out nocopy JTF_VARCHAR2_TABLE_100
1351: , a11 out nocopy JTF_NUMBER_TABLE
1347: , a7 out nocopy JTF_NUMBER_TABLE
1348: , a8 out nocopy JTF_VARCHAR2_TABLE_200
1349: , a9 out nocopy JTF_VARCHAR2_TABLE_2000
1350: , a10 out nocopy JTF_VARCHAR2_TABLE_100
1351: , a11 out nocopy JTF_NUMBER_TABLE
1352: , a12 out nocopy JTF_DATE_TABLE
1353: , a13 out nocopy JTF_DATE_TABLE
1354: , a14 out nocopy JTF_VARCHAR2_TABLE_100
1355: , a15 out nocopy JTF_VARCHAR2_TABLE_100
1357: , a17 out nocopy JTF_DATE_TABLE
1358: , a18 out nocopy JTF_VARCHAR2_TABLE_100
1359: , a19 out nocopy JTF_VARCHAR2_TABLE_2000
1360: , a20 out nocopy JTF_DATE_TABLE
1361: , a21 out nocopy JTF_NUMBER_TABLE
1362: ) as
1363: ddindx binary_integer; indx binary_integer;
1364: begin
1365: if t is null or t.count = 0 then
1362: ) as
1363: ddindx binary_integer; indx binary_integer;
1364: begin
1365: if t is null or t.count = 0 then
1366: a0 := JTF_NUMBER_TABLE();
1367: a1 := JTF_VARCHAR2_TABLE_200();
1368: a2 := JTF_VARCHAR2_TABLE_200();
1369: a3 := JTF_VARCHAR2_TABLE_100();
1370: a4 := JTF_NUMBER_TABLE();
1366: a0 := JTF_NUMBER_TABLE();
1367: a1 := JTF_VARCHAR2_TABLE_200();
1368: a2 := JTF_VARCHAR2_TABLE_200();
1369: a3 := JTF_VARCHAR2_TABLE_100();
1370: a4 := JTF_NUMBER_TABLE();
1371: a5 := JTF_VARCHAR2_TABLE_300();
1372: a6 := JTF_VARCHAR2_TABLE_300();
1373: a7 := JTF_NUMBER_TABLE();
1374: a8 := JTF_VARCHAR2_TABLE_200();
1369: a3 := JTF_VARCHAR2_TABLE_100();
1370: a4 := JTF_NUMBER_TABLE();
1371: a5 := JTF_VARCHAR2_TABLE_300();
1372: a6 := JTF_VARCHAR2_TABLE_300();
1373: a7 := JTF_NUMBER_TABLE();
1374: a8 := JTF_VARCHAR2_TABLE_200();
1375: a9 := JTF_VARCHAR2_TABLE_2000();
1376: a10 := JTF_VARCHAR2_TABLE_100();
1377: a11 := JTF_NUMBER_TABLE();
1373: a7 := JTF_NUMBER_TABLE();
1374: a8 := JTF_VARCHAR2_TABLE_200();
1375: a9 := JTF_VARCHAR2_TABLE_2000();
1376: a10 := JTF_VARCHAR2_TABLE_100();
1377: a11 := JTF_NUMBER_TABLE();
1378: a12 := JTF_DATE_TABLE();
1379: a13 := JTF_DATE_TABLE();
1380: a14 := JTF_VARCHAR2_TABLE_100();
1381: a15 := JTF_VARCHAR2_TABLE_100();
1383: a17 := JTF_DATE_TABLE();
1384: a18 := JTF_VARCHAR2_TABLE_100();
1385: a19 := JTF_VARCHAR2_TABLE_2000();
1386: a20 := JTF_DATE_TABLE();
1387: a21 := JTF_NUMBER_TABLE();
1388: else
1389: a0 := JTF_NUMBER_TABLE();
1390: a1 := JTF_VARCHAR2_TABLE_200();
1391: a2 := JTF_VARCHAR2_TABLE_200();
1385: a19 := JTF_VARCHAR2_TABLE_2000();
1386: a20 := JTF_DATE_TABLE();
1387: a21 := JTF_NUMBER_TABLE();
1388: else
1389: a0 := JTF_NUMBER_TABLE();
1390: a1 := JTF_VARCHAR2_TABLE_200();
1391: a2 := JTF_VARCHAR2_TABLE_200();
1392: a3 := JTF_VARCHAR2_TABLE_100();
1393: a4 := JTF_NUMBER_TABLE();
1389: a0 := JTF_NUMBER_TABLE();
1390: a1 := JTF_VARCHAR2_TABLE_200();
1391: a2 := JTF_VARCHAR2_TABLE_200();
1392: a3 := JTF_VARCHAR2_TABLE_100();
1393: a4 := JTF_NUMBER_TABLE();
1394: a5 := JTF_VARCHAR2_TABLE_300();
1395: a6 := JTF_VARCHAR2_TABLE_300();
1396: a7 := JTF_NUMBER_TABLE();
1397: a8 := JTF_VARCHAR2_TABLE_200();
1392: a3 := JTF_VARCHAR2_TABLE_100();
1393: a4 := JTF_NUMBER_TABLE();
1394: a5 := JTF_VARCHAR2_TABLE_300();
1395: a6 := JTF_VARCHAR2_TABLE_300();
1396: a7 := JTF_NUMBER_TABLE();
1397: a8 := JTF_VARCHAR2_TABLE_200();
1398: a9 := JTF_VARCHAR2_TABLE_2000();
1399: a10 := JTF_VARCHAR2_TABLE_100();
1400: a11 := JTF_NUMBER_TABLE();
1396: a7 := JTF_NUMBER_TABLE();
1397: a8 := JTF_VARCHAR2_TABLE_200();
1398: a9 := JTF_VARCHAR2_TABLE_2000();
1399: a10 := JTF_VARCHAR2_TABLE_100();
1400: a11 := JTF_NUMBER_TABLE();
1401: a12 := JTF_DATE_TABLE();
1402: a13 := JTF_DATE_TABLE();
1403: a14 := JTF_VARCHAR2_TABLE_100();
1404: a15 := JTF_VARCHAR2_TABLE_100();
1406: a17 := JTF_DATE_TABLE();
1407: a18 := JTF_VARCHAR2_TABLE_100();
1408: a19 := JTF_VARCHAR2_TABLE_2000();
1409: a20 := JTF_DATE_TABLE();
1410: a21 := JTF_NUMBER_TABLE();
1411: if t.count > 0 then
1412: a0.extend(t.count);
1413: a1.extend(t.count);
1414: a2.extend(t.count);
1465: end if;
1466: end if;
1467: end rosetta_table_copy_out_p34;
1468:
1469: procedure rosetta_table_copy_in_p38(t out nocopy oks_entitlements_pub.output_tbl_entfrm, a0 JTF_NUMBER_TABLE
1470: , a1 JTF_VARCHAR2_TABLE_200
1471: , a2 JTF_VARCHAR2_TABLE_200
1472: , a3 JTF_VARCHAR2_TABLE_300
1473: , a4 JTF_VARCHAR2_TABLE_600
1500: end loop;
1501: end if;
1502: end if;
1503: end rosetta_table_copy_in_p38;
1504: procedure rosetta_table_copy_out_p38(t oks_entitlements_pub.output_tbl_entfrm, a0 out nocopy JTF_NUMBER_TABLE
1505: , a1 out nocopy JTF_VARCHAR2_TABLE_200
1506: , a2 out nocopy JTF_VARCHAR2_TABLE_200
1507: , a3 out nocopy JTF_VARCHAR2_TABLE_300
1508: , a4 out nocopy JTF_VARCHAR2_TABLE_600
1513: ) as
1514: ddindx binary_integer; indx binary_integer;
1515: begin
1516: if t is null or t.count = 0 then
1517: a0 := JTF_NUMBER_TABLE();
1518: a1 := JTF_VARCHAR2_TABLE_200();
1519: a2 := JTF_VARCHAR2_TABLE_200();
1520: a3 := JTF_VARCHAR2_TABLE_300();
1521: a4 := JTF_VARCHAR2_TABLE_600();
1523: a6 := JTF_DATE_TABLE();
1524: a7 := JTF_DATE_TABLE();
1525: a8 := JTF_DATE_TABLE();
1526: else
1527: a0 := JTF_NUMBER_TABLE();
1528: a1 := JTF_VARCHAR2_TABLE_200();
1529: a2 := JTF_VARCHAR2_TABLE_200();
1530: a3 := JTF_VARCHAR2_TABLE_300();
1531: a4 := JTF_VARCHAR2_TABLE_600();
1565: end if;
1566: end rosetta_table_copy_out_p38;
1567:
1568: procedure rosetta_table_copy_in_p41(t out nocopy oks_entitlements_pub.covlevel_tbl_type, a0 JTF_VARCHAR2_TABLE_100
1569: , a1 JTF_NUMBER_TABLE
1570: , a2 JTF_NUMBER_TABLE
1571: , a3 JTF_VARCHAR2_TABLE_100
1572: ) as
1573: ddindx binary_integer; indx binary_integer;
1566: end rosetta_table_copy_out_p38;
1567:
1568: procedure rosetta_table_copy_in_p41(t out nocopy oks_entitlements_pub.covlevel_tbl_type, a0 JTF_VARCHAR2_TABLE_100
1569: , a1 JTF_NUMBER_TABLE
1570: , a2 JTF_NUMBER_TABLE
1571: , a3 JTF_VARCHAR2_TABLE_100
1572: ) as
1573: ddindx binary_integer; indx binary_integer;
1574: begin
1590: end if;
1591: end if;
1592: end rosetta_table_copy_in_p41;
1593: procedure rosetta_table_copy_out_p41(t oks_entitlements_pub.covlevel_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
1594: , a1 out nocopy JTF_NUMBER_TABLE
1595: , a2 out nocopy JTF_NUMBER_TABLE
1596: , a3 out nocopy JTF_VARCHAR2_TABLE_100
1597: ) as
1598: ddindx binary_integer; indx binary_integer;
1591: end if;
1592: end rosetta_table_copy_in_p41;
1593: procedure rosetta_table_copy_out_p41(t oks_entitlements_pub.covlevel_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
1594: , a1 out nocopy JTF_NUMBER_TABLE
1595: , a2 out nocopy JTF_NUMBER_TABLE
1596: , a3 out nocopy JTF_VARCHAR2_TABLE_100
1597: ) as
1598: ddindx binary_integer; indx binary_integer;
1599: begin
1598: ddindx binary_integer; indx binary_integer;
1599: begin
1600: if t is null or t.count = 0 then
1601: a0 := JTF_VARCHAR2_TABLE_100();
1602: a1 := JTF_NUMBER_TABLE();
1603: a2 := JTF_NUMBER_TABLE();
1604: a3 := JTF_VARCHAR2_TABLE_100();
1605: else
1606: a0 := JTF_VARCHAR2_TABLE_100();
1599: begin
1600: if t is null or t.count = 0 then
1601: a0 := JTF_VARCHAR2_TABLE_100();
1602: a1 := JTF_NUMBER_TABLE();
1603: a2 := JTF_NUMBER_TABLE();
1604: a3 := JTF_VARCHAR2_TABLE_100();
1605: else
1606: a0 := JTF_VARCHAR2_TABLE_100();
1607: a1 := JTF_NUMBER_TABLE();
1603: a2 := JTF_NUMBER_TABLE();
1604: a3 := JTF_VARCHAR2_TABLE_100();
1605: else
1606: a0 := JTF_VARCHAR2_TABLE_100();
1607: a1 := JTF_NUMBER_TABLE();
1608: a2 := JTF_NUMBER_TABLE();
1609: a3 := JTF_VARCHAR2_TABLE_100();
1610: if t.count > 0 then
1611: a0.extend(t.count);
1604: a3 := JTF_VARCHAR2_TABLE_100();
1605: else
1606: a0 := JTF_VARCHAR2_TABLE_100();
1607: a1 := JTF_NUMBER_TABLE();
1608: a2 := JTF_NUMBER_TABLE();
1609: a3 := JTF_VARCHAR2_TABLE_100();
1610: if t.count > 0 then
1611: a0.extend(t.count);
1612: a1.extend(t.count);
1628: end if;
1629: end if;
1630: end rosetta_table_copy_out_p41;
1631:
1632: procedure rosetta_table_copy_in_p44(t out nocopy oks_entitlements_pub.covlvl_id_tbl, a0 JTF_NUMBER_TABLE
1633: , a1 JTF_VARCHAR2_TABLE_100
1634: ) as
1635: ddindx binary_integer; indx binary_integer;
1636: begin
1649: end loop;
1650: end if;
1651: end if;
1652: end rosetta_table_copy_in_p44;
1653: procedure rosetta_table_copy_out_p44(t oks_entitlements_pub.covlvl_id_tbl, a0 out nocopy JTF_NUMBER_TABLE
1654: , a1 out nocopy JTF_VARCHAR2_TABLE_100
1655: ) as
1656: ddindx binary_integer; indx binary_integer;
1657: begin
1655: ) as
1656: ddindx binary_integer; indx binary_integer;
1657: begin
1658: if t is null or t.count = 0 then
1659: a0 := JTF_NUMBER_TABLE();
1660: a1 := JTF_VARCHAR2_TABLE_100();
1661: else
1662: a0 := JTF_NUMBER_TABLE();
1663: a1 := JTF_VARCHAR2_TABLE_100();
1658: if t is null or t.count = 0 then
1659: a0 := JTF_NUMBER_TABLE();
1660: a1 := JTF_VARCHAR2_TABLE_100();
1661: else
1662: a0 := JTF_NUMBER_TABLE();
1663: a1 := JTF_VARCHAR2_TABLE_100();
1664: if t.count > 0 then
1665: a0.extend(t.count);
1666: a1.extend(t.count);
1687: , a5 JTF_VARCHAR2_TABLE_2000
1688: , a6 JTF_DATE_TABLE
1689: , a7 JTF_DATE_TABLE
1690: , a8 JTF_DATE_TABLE
1691: , a9 JTF_NUMBER_TABLE
1692: , a10 JTF_VARCHAR2_TABLE_100
1693: , a11 JTF_VARCHAR2_TABLE_100
1694: , a12 JTF_VARCHAR2_TABLE_100
1695: ) as
1730: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
1731: , a6 out nocopy JTF_DATE_TABLE
1732: , a7 out nocopy JTF_DATE_TABLE
1733: , a8 out nocopy JTF_DATE_TABLE
1734: , a9 out nocopy JTF_NUMBER_TABLE
1735: , a10 out nocopy JTF_VARCHAR2_TABLE_100
1736: , a11 out nocopy JTF_VARCHAR2_TABLE_100
1737: , a12 out nocopy JTF_VARCHAR2_TABLE_100
1738: ) as
1747: a5 := JTF_VARCHAR2_TABLE_2000();
1748: a6 := JTF_DATE_TABLE();
1749: a7 := JTF_DATE_TABLE();
1750: a8 := JTF_DATE_TABLE();
1751: a9 := JTF_NUMBER_TABLE();
1752: a10 := JTF_VARCHAR2_TABLE_100();
1753: a11 := JTF_VARCHAR2_TABLE_100();
1754: a12 := JTF_VARCHAR2_TABLE_100();
1755: else
1761: a5 := JTF_VARCHAR2_TABLE_2000();
1762: a6 := JTF_DATE_TABLE();
1763: a7 := JTF_DATE_TABLE();
1764: a8 := JTF_DATE_TABLE();
1765: a9 := JTF_NUMBER_TABLE();
1766: a10 := JTF_VARCHAR2_TABLE_100();
1767: a11 := JTF_VARCHAR2_TABLE_100();
1768: a12 := JTF_VARCHAR2_TABLE_100();
1769: if t.count > 0 then
1805: end if;
1806: end if;
1807: end rosetta_table_copy_out_p47;
1808:
1809: procedure rosetta_table_copy_in_p60(t out nocopy oks_entitlements_pub.ent_contact_tbl, a0 JTF_NUMBER_TABLE
1810: , a1 JTF_NUMBER_TABLE
1811: , a2 JTF_NUMBER_TABLE
1812: , a3 JTF_VARCHAR2_TABLE_100
1813: , a4 JTF_NUMBER_TABLE
1806: end if;
1807: end rosetta_table_copy_out_p47;
1808:
1809: procedure rosetta_table_copy_in_p60(t out nocopy oks_entitlements_pub.ent_contact_tbl, a0 JTF_NUMBER_TABLE
1810: , a1 JTF_NUMBER_TABLE
1811: , a2 JTF_NUMBER_TABLE
1812: , a3 JTF_VARCHAR2_TABLE_100
1813: , a4 JTF_NUMBER_TABLE
1814: , a5 JTF_VARCHAR2_TABLE_100
1807: end rosetta_table_copy_out_p47;
1808:
1809: procedure rosetta_table_copy_in_p60(t out nocopy oks_entitlements_pub.ent_contact_tbl, a0 JTF_NUMBER_TABLE
1810: , a1 JTF_NUMBER_TABLE
1811: , a2 JTF_NUMBER_TABLE
1812: , a3 JTF_VARCHAR2_TABLE_100
1813: , a4 JTF_NUMBER_TABLE
1814: , a5 JTF_VARCHAR2_TABLE_100
1815: , a6 JTF_VARCHAR2_TABLE_100
1809: procedure rosetta_table_copy_in_p60(t out nocopy oks_entitlements_pub.ent_contact_tbl, a0 JTF_NUMBER_TABLE
1810: , a1 JTF_NUMBER_TABLE
1811: , a2 JTF_NUMBER_TABLE
1812: , a3 JTF_VARCHAR2_TABLE_100
1813: , a4 JTF_NUMBER_TABLE
1814: , a5 JTF_VARCHAR2_TABLE_100
1815: , a6 JTF_VARCHAR2_TABLE_100
1816: ) as
1817: ddindx binary_integer; indx binary_integer;
1836: end loop;
1837: end if;
1838: end if;
1839: end rosetta_table_copy_in_p60;
1840: procedure rosetta_table_copy_out_p60(t oks_entitlements_pub.ent_contact_tbl, a0 out nocopy JTF_NUMBER_TABLE
1841: , a1 out nocopy JTF_NUMBER_TABLE
1842: , a2 out nocopy JTF_NUMBER_TABLE
1843: , a3 out nocopy JTF_VARCHAR2_TABLE_100
1844: , a4 out nocopy JTF_NUMBER_TABLE
1837: end if;
1838: end if;
1839: end rosetta_table_copy_in_p60;
1840: procedure rosetta_table_copy_out_p60(t oks_entitlements_pub.ent_contact_tbl, a0 out nocopy JTF_NUMBER_TABLE
1841: , a1 out nocopy JTF_NUMBER_TABLE
1842: , a2 out nocopy JTF_NUMBER_TABLE
1843: , a3 out nocopy JTF_VARCHAR2_TABLE_100
1844: , a4 out nocopy JTF_NUMBER_TABLE
1845: , a5 out nocopy JTF_VARCHAR2_TABLE_100
1838: end if;
1839: end rosetta_table_copy_in_p60;
1840: procedure rosetta_table_copy_out_p60(t oks_entitlements_pub.ent_contact_tbl, a0 out nocopy JTF_NUMBER_TABLE
1841: , a1 out nocopy JTF_NUMBER_TABLE
1842: , a2 out nocopy JTF_NUMBER_TABLE
1843: , a3 out nocopy JTF_VARCHAR2_TABLE_100
1844: , a4 out nocopy JTF_NUMBER_TABLE
1845: , a5 out nocopy JTF_VARCHAR2_TABLE_100
1846: , a6 out nocopy JTF_VARCHAR2_TABLE_100
1840: procedure rosetta_table_copy_out_p60(t oks_entitlements_pub.ent_contact_tbl, a0 out nocopy JTF_NUMBER_TABLE
1841: , a1 out nocopy JTF_NUMBER_TABLE
1842: , a2 out nocopy JTF_NUMBER_TABLE
1843: , a3 out nocopy JTF_VARCHAR2_TABLE_100
1844: , a4 out nocopy JTF_NUMBER_TABLE
1845: , a5 out nocopy JTF_VARCHAR2_TABLE_100
1846: , a6 out nocopy JTF_VARCHAR2_TABLE_100
1847: ) as
1848: ddindx binary_integer; indx binary_integer;
1847: ) as
1848: ddindx binary_integer; indx binary_integer;
1849: begin
1850: if t is null or t.count = 0 then
1851: a0 := JTF_NUMBER_TABLE();
1852: a1 := JTF_NUMBER_TABLE();
1853: a2 := JTF_NUMBER_TABLE();
1854: a3 := JTF_VARCHAR2_TABLE_100();
1855: a4 := JTF_NUMBER_TABLE();
1848: ddindx binary_integer; indx binary_integer;
1849: begin
1850: if t is null or t.count = 0 then
1851: a0 := JTF_NUMBER_TABLE();
1852: a1 := JTF_NUMBER_TABLE();
1853: a2 := JTF_NUMBER_TABLE();
1854: a3 := JTF_VARCHAR2_TABLE_100();
1855: a4 := JTF_NUMBER_TABLE();
1856: a5 := JTF_VARCHAR2_TABLE_100();
1849: begin
1850: if t is null or t.count = 0 then
1851: a0 := JTF_NUMBER_TABLE();
1852: a1 := JTF_NUMBER_TABLE();
1853: a2 := JTF_NUMBER_TABLE();
1854: a3 := JTF_VARCHAR2_TABLE_100();
1855: a4 := JTF_NUMBER_TABLE();
1856: a5 := JTF_VARCHAR2_TABLE_100();
1857: a6 := JTF_VARCHAR2_TABLE_100();
1851: a0 := JTF_NUMBER_TABLE();
1852: a1 := JTF_NUMBER_TABLE();
1853: a2 := JTF_NUMBER_TABLE();
1854: a3 := JTF_VARCHAR2_TABLE_100();
1855: a4 := JTF_NUMBER_TABLE();
1856: a5 := JTF_VARCHAR2_TABLE_100();
1857: a6 := JTF_VARCHAR2_TABLE_100();
1858: else
1859: a0 := JTF_NUMBER_TABLE();
1855: a4 := JTF_NUMBER_TABLE();
1856: a5 := JTF_VARCHAR2_TABLE_100();
1857: a6 := JTF_VARCHAR2_TABLE_100();
1858: else
1859: a0 := JTF_NUMBER_TABLE();
1860: a1 := JTF_NUMBER_TABLE();
1861: a2 := JTF_NUMBER_TABLE();
1862: a3 := JTF_VARCHAR2_TABLE_100();
1863: a4 := JTF_NUMBER_TABLE();
1856: a5 := JTF_VARCHAR2_TABLE_100();
1857: a6 := JTF_VARCHAR2_TABLE_100();
1858: else
1859: a0 := JTF_NUMBER_TABLE();
1860: a1 := JTF_NUMBER_TABLE();
1861: a2 := JTF_NUMBER_TABLE();
1862: a3 := JTF_VARCHAR2_TABLE_100();
1863: a4 := JTF_NUMBER_TABLE();
1864: a5 := JTF_VARCHAR2_TABLE_100();
1857: a6 := JTF_VARCHAR2_TABLE_100();
1858: else
1859: a0 := JTF_NUMBER_TABLE();
1860: a1 := JTF_NUMBER_TABLE();
1861: a2 := JTF_NUMBER_TABLE();
1862: a3 := JTF_VARCHAR2_TABLE_100();
1863: a4 := JTF_NUMBER_TABLE();
1864: a5 := JTF_VARCHAR2_TABLE_100();
1865: a6 := JTF_VARCHAR2_TABLE_100();
1859: a0 := JTF_NUMBER_TABLE();
1860: a1 := JTF_NUMBER_TABLE();
1861: a2 := JTF_NUMBER_TABLE();
1862: a3 := JTF_VARCHAR2_TABLE_100();
1863: a4 := JTF_NUMBER_TABLE();
1864: a5 := JTF_VARCHAR2_TABLE_100();
1865: a6 := JTF_VARCHAR2_TABLE_100();
1866: if t.count > 0 then
1867: a0.extend(t.count);
1890: end if;
1891: end if;
1892: end rosetta_table_copy_out_p60;
1893:
1894: procedure rosetta_table_copy_in_p63(t out nocopy oks_entitlements_pub.prfeng_tbl_type, a0 JTF_NUMBER_TABLE
1895: , a1 JTF_NUMBER_TABLE
1896: , a2 JTF_VARCHAR2_TABLE_100
1897: , a3 JTF_VARCHAR2_TABLE_100
1898: , a4 JTF_VARCHAR2_TABLE_100
1891: end if;
1892: end rosetta_table_copy_out_p60;
1893:
1894: procedure rosetta_table_copy_in_p63(t out nocopy oks_entitlements_pub.prfeng_tbl_type, a0 JTF_NUMBER_TABLE
1895: , a1 JTF_NUMBER_TABLE
1896: , a2 JTF_VARCHAR2_TABLE_100
1897: , a3 JTF_VARCHAR2_TABLE_100
1898: , a4 JTF_VARCHAR2_TABLE_100
1899: ) as
1917: end loop;
1918: end if;
1919: end if;
1920: end rosetta_table_copy_in_p63;
1921: procedure rosetta_table_copy_out_p63(t oks_entitlements_pub.prfeng_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
1922: , a1 out nocopy JTF_NUMBER_TABLE
1923: , a2 out nocopy JTF_VARCHAR2_TABLE_100
1924: , a3 out nocopy JTF_VARCHAR2_TABLE_100
1925: , a4 out nocopy JTF_VARCHAR2_TABLE_100
1918: end if;
1919: end if;
1920: end rosetta_table_copy_in_p63;
1921: procedure rosetta_table_copy_out_p63(t oks_entitlements_pub.prfeng_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
1922: , a1 out nocopy JTF_NUMBER_TABLE
1923: , a2 out nocopy JTF_VARCHAR2_TABLE_100
1924: , a3 out nocopy JTF_VARCHAR2_TABLE_100
1925: , a4 out nocopy JTF_VARCHAR2_TABLE_100
1926: ) as
1926: ) as
1927: ddindx binary_integer; indx binary_integer;
1928: begin
1929: if t is null or t.count = 0 then
1930: a0 := JTF_NUMBER_TABLE();
1931: a1 := JTF_NUMBER_TABLE();
1932: a2 := JTF_VARCHAR2_TABLE_100();
1933: a3 := JTF_VARCHAR2_TABLE_100();
1934: a4 := JTF_VARCHAR2_TABLE_100();
1927: ddindx binary_integer; indx binary_integer;
1928: begin
1929: if t is null or t.count = 0 then
1930: a0 := JTF_NUMBER_TABLE();
1931: a1 := JTF_NUMBER_TABLE();
1932: a2 := JTF_VARCHAR2_TABLE_100();
1933: a3 := JTF_VARCHAR2_TABLE_100();
1934: a4 := JTF_VARCHAR2_TABLE_100();
1935: else
1932: a2 := JTF_VARCHAR2_TABLE_100();
1933: a3 := JTF_VARCHAR2_TABLE_100();
1934: a4 := JTF_VARCHAR2_TABLE_100();
1935: else
1936: a0 := JTF_NUMBER_TABLE();
1937: a1 := JTF_NUMBER_TABLE();
1938: a2 := JTF_VARCHAR2_TABLE_100();
1939: a3 := JTF_VARCHAR2_TABLE_100();
1940: a4 := JTF_VARCHAR2_TABLE_100();
1933: a3 := JTF_VARCHAR2_TABLE_100();
1934: a4 := JTF_VARCHAR2_TABLE_100();
1935: else
1936: a0 := JTF_NUMBER_TABLE();
1937: a1 := JTF_NUMBER_TABLE();
1938: a2 := JTF_VARCHAR2_TABLE_100();
1939: a3 := JTF_VARCHAR2_TABLE_100();
1940: a4 := JTF_VARCHAR2_TABLE_100();
1941: if t.count > 0 then
1961: end if;
1962: end if;
1963: end rosetta_table_copy_out_p63;
1964:
1965: procedure rosetta_table_copy_in_p70(t out nocopy oks_entitlements_pub.output_tbl_bp, a0 JTF_NUMBER_TABLE
1966: , a1 JTF_NUMBER_TABLE
1967: , a2 JTF_DATE_TABLE
1968: , a3 JTF_DATE_TABLE
1969: ) as
1962: end if;
1963: end rosetta_table_copy_out_p63;
1964:
1965: procedure rosetta_table_copy_in_p70(t out nocopy oks_entitlements_pub.output_tbl_bp, a0 JTF_NUMBER_TABLE
1966: , a1 JTF_NUMBER_TABLE
1967: , a2 JTF_DATE_TABLE
1968: , a3 JTF_DATE_TABLE
1969: ) as
1970: ddindx binary_integer; indx binary_integer;
1986: end loop;
1987: end if;
1988: end if;
1989: end rosetta_table_copy_in_p70;
1990: procedure rosetta_table_copy_out_p70(t oks_entitlements_pub.output_tbl_bp, a0 out nocopy JTF_NUMBER_TABLE
1991: , a1 out nocopy JTF_NUMBER_TABLE
1992: , a2 out nocopy JTF_DATE_TABLE
1993: , a3 out nocopy JTF_DATE_TABLE
1994: ) as
1987: end if;
1988: end if;
1989: end rosetta_table_copy_in_p70;
1990: procedure rosetta_table_copy_out_p70(t oks_entitlements_pub.output_tbl_bp, a0 out nocopy JTF_NUMBER_TABLE
1991: , a1 out nocopy JTF_NUMBER_TABLE
1992: , a2 out nocopy JTF_DATE_TABLE
1993: , a3 out nocopy JTF_DATE_TABLE
1994: ) as
1995: ddindx binary_integer; indx binary_integer;
1994: ) as
1995: ddindx binary_integer; indx binary_integer;
1996: begin
1997: if t is null or t.count = 0 then
1998: a0 := JTF_NUMBER_TABLE();
1999: a1 := JTF_NUMBER_TABLE();
2000: a2 := JTF_DATE_TABLE();
2001: a3 := JTF_DATE_TABLE();
2002: else
1995: ddindx binary_integer; indx binary_integer;
1996: begin
1997: if t is null or t.count = 0 then
1998: a0 := JTF_NUMBER_TABLE();
1999: a1 := JTF_NUMBER_TABLE();
2000: a2 := JTF_DATE_TABLE();
2001: a3 := JTF_DATE_TABLE();
2002: else
2003: a0 := JTF_NUMBER_TABLE();
1999: a1 := JTF_NUMBER_TABLE();
2000: a2 := JTF_DATE_TABLE();
2001: a3 := JTF_DATE_TABLE();
2002: else
2003: a0 := JTF_NUMBER_TABLE();
2004: a1 := JTF_NUMBER_TABLE();
2005: a2 := JTF_DATE_TABLE();
2006: a3 := JTF_DATE_TABLE();
2007: if t.count > 0 then
2000: a2 := JTF_DATE_TABLE();
2001: a3 := JTF_DATE_TABLE();
2002: else
2003: a0 := JTF_NUMBER_TABLE();
2004: a1 := JTF_NUMBER_TABLE();
2005: a2 := JTF_DATE_TABLE();
2006: a3 := JTF_DATE_TABLE();
2007: if t.count > 0 then
2008: a0.extend(t.count);
2025: end if;
2026: end if;
2027: end rosetta_table_copy_out_p70;
2028:
2029: procedure rosetta_table_copy_in_p73(t out nocopy oks_entitlements_pub.output_tbl_bt, a0 JTF_NUMBER_TABLE
2030: , a1 JTF_NUMBER_TABLE
2031: , a2 JTF_NUMBER_TABLE
2032: , a3 JTF_NUMBER_TABLE
2033: ) as
2026: end if;
2027: end rosetta_table_copy_out_p70;
2028:
2029: procedure rosetta_table_copy_in_p73(t out nocopy oks_entitlements_pub.output_tbl_bt, a0 JTF_NUMBER_TABLE
2030: , a1 JTF_NUMBER_TABLE
2031: , a2 JTF_NUMBER_TABLE
2032: , a3 JTF_NUMBER_TABLE
2033: ) as
2034: ddindx binary_integer; indx binary_integer;
2027: end rosetta_table_copy_out_p70;
2028:
2029: procedure rosetta_table_copy_in_p73(t out nocopy oks_entitlements_pub.output_tbl_bt, a0 JTF_NUMBER_TABLE
2030: , a1 JTF_NUMBER_TABLE
2031: , a2 JTF_NUMBER_TABLE
2032: , a3 JTF_NUMBER_TABLE
2033: ) as
2034: ddindx binary_integer; indx binary_integer;
2035: begin
2028:
2029: procedure rosetta_table_copy_in_p73(t out nocopy oks_entitlements_pub.output_tbl_bt, a0 JTF_NUMBER_TABLE
2030: , a1 JTF_NUMBER_TABLE
2031: , a2 JTF_NUMBER_TABLE
2032: , a3 JTF_NUMBER_TABLE
2033: ) as
2034: ddindx binary_integer; indx binary_integer;
2035: begin
2036: if a0 is not null and a0.count > 0 then
2050: end loop;
2051: end if;
2052: end if;
2053: end rosetta_table_copy_in_p73;
2054: procedure rosetta_table_copy_out_p73(t oks_entitlements_pub.output_tbl_bt, a0 out nocopy JTF_NUMBER_TABLE
2055: , a1 out nocopy JTF_NUMBER_TABLE
2056: , a2 out nocopy JTF_NUMBER_TABLE
2057: , a3 out nocopy JTF_NUMBER_TABLE
2058: ) as
2051: end if;
2052: end if;
2053: end rosetta_table_copy_in_p73;
2054: procedure rosetta_table_copy_out_p73(t oks_entitlements_pub.output_tbl_bt, a0 out nocopy JTF_NUMBER_TABLE
2055: , a1 out nocopy JTF_NUMBER_TABLE
2056: , a2 out nocopy JTF_NUMBER_TABLE
2057: , a3 out nocopy JTF_NUMBER_TABLE
2058: ) as
2059: ddindx binary_integer; indx binary_integer;
2052: end if;
2053: end rosetta_table_copy_in_p73;
2054: procedure rosetta_table_copy_out_p73(t oks_entitlements_pub.output_tbl_bt, a0 out nocopy JTF_NUMBER_TABLE
2055: , a1 out nocopy JTF_NUMBER_TABLE
2056: , a2 out nocopy JTF_NUMBER_TABLE
2057: , a3 out nocopy JTF_NUMBER_TABLE
2058: ) as
2059: ddindx binary_integer; indx binary_integer;
2060: begin
2053: end rosetta_table_copy_in_p73;
2054: procedure rosetta_table_copy_out_p73(t oks_entitlements_pub.output_tbl_bt, a0 out nocopy JTF_NUMBER_TABLE
2055: , a1 out nocopy JTF_NUMBER_TABLE
2056: , a2 out nocopy JTF_NUMBER_TABLE
2057: , a3 out nocopy JTF_NUMBER_TABLE
2058: ) as
2059: ddindx binary_integer; indx binary_integer;
2060: begin
2061: if t is null or t.count = 0 then
2058: ) as
2059: ddindx binary_integer; indx binary_integer;
2060: begin
2061: if t is null or t.count = 0 then
2062: a0 := JTF_NUMBER_TABLE();
2063: a1 := JTF_NUMBER_TABLE();
2064: a2 := JTF_NUMBER_TABLE();
2065: a3 := JTF_NUMBER_TABLE();
2066: else
2059: ddindx binary_integer; indx binary_integer;
2060: begin
2061: if t is null or t.count = 0 then
2062: a0 := JTF_NUMBER_TABLE();
2063: a1 := JTF_NUMBER_TABLE();
2064: a2 := JTF_NUMBER_TABLE();
2065: a3 := JTF_NUMBER_TABLE();
2066: else
2067: a0 := JTF_NUMBER_TABLE();
2060: begin
2061: if t is null or t.count = 0 then
2062: a0 := JTF_NUMBER_TABLE();
2063: a1 := JTF_NUMBER_TABLE();
2064: a2 := JTF_NUMBER_TABLE();
2065: a3 := JTF_NUMBER_TABLE();
2066: else
2067: a0 := JTF_NUMBER_TABLE();
2068: a1 := JTF_NUMBER_TABLE();
2061: if t is null or t.count = 0 then
2062: a0 := JTF_NUMBER_TABLE();
2063: a1 := JTF_NUMBER_TABLE();
2064: a2 := JTF_NUMBER_TABLE();
2065: a3 := JTF_NUMBER_TABLE();
2066: else
2067: a0 := JTF_NUMBER_TABLE();
2068: a1 := JTF_NUMBER_TABLE();
2069: a2 := JTF_NUMBER_TABLE();
2063: a1 := JTF_NUMBER_TABLE();
2064: a2 := JTF_NUMBER_TABLE();
2065: a3 := JTF_NUMBER_TABLE();
2066: else
2067: a0 := JTF_NUMBER_TABLE();
2068: a1 := JTF_NUMBER_TABLE();
2069: a2 := JTF_NUMBER_TABLE();
2070: a3 := JTF_NUMBER_TABLE();
2071: if t.count > 0 then
2064: a2 := JTF_NUMBER_TABLE();
2065: a3 := JTF_NUMBER_TABLE();
2066: else
2067: a0 := JTF_NUMBER_TABLE();
2068: a1 := JTF_NUMBER_TABLE();
2069: a2 := JTF_NUMBER_TABLE();
2070: a3 := JTF_NUMBER_TABLE();
2071: if t.count > 0 then
2072: a0.extend(t.count);
2065: a3 := JTF_NUMBER_TABLE();
2066: else
2067: a0 := JTF_NUMBER_TABLE();
2068: a1 := JTF_NUMBER_TABLE();
2069: a2 := JTF_NUMBER_TABLE();
2070: a3 := JTF_NUMBER_TABLE();
2071: if t.count > 0 then
2072: a0.extend(t.count);
2073: a1.extend(t.count);
2066: else
2067: a0 := JTF_NUMBER_TABLE();
2068: a1 := JTF_NUMBER_TABLE();
2069: a2 := JTF_NUMBER_TABLE();
2070: a3 := JTF_NUMBER_TABLE();
2071: if t.count > 0 then
2072: a0.extend(t.count);
2073: a1.extend(t.count);
2074: a2.extend(t.count);
2089: end if;
2090: end if;
2091: end rosetta_table_copy_out_p73;
2092:
2093: procedure rosetta_table_copy_in_p75(t out nocopy oks_entitlements_pub.output_tbl_br, a0 JTF_NUMBER_TABLE
2094: , a1 JTF_NUMBER_TABLE
2095: , a2 JTF_NUMBER_TABLE
2096: , a3 JTF_VARCHAR2_TABLE_100
2097: , a4 JTF_NUMBER_TABLE
2090: end if;
2091: end rosetta_table_copy_out_p73;
2092:
2093: procedure rosetta_table_copy_in_p75(t out nocopy oks_entitlements_pub.output_tbl_br, a0 JTF_NUMBER_TABLE
2094: , a1 JTF_NUMBER_TABLE
2095: , a2 JTF_NUMBER_TABLE
2096: , a3 JTF_VARCHAR2_TABLE_100
2097: , a4 JTF_NUMBER_TABLE
2098: , a5 JTF_VARCHAR2_TABLE_100
2091: end rosetta_table_copy_out_p73;
2092:
2093: procedure rosetta_table_copy_in_p75(t out nocopy oks_entitlements_pub.output_tbl_br, a0 JTF_NUMBER_TABLE
2094: , a1 JTF_NUMBER_TABLE
2095: , a2 JTF_NUMBER_TABLE
2096: , a3 JTF_VARCHAR2_TABLE_100
2097: , a4 JTF_NUMBER_TABLE
2098: , a5 JTF_VARCHAR2_TABLE_100
2099: , a6 JTF_NUMBER_TABLE
2093: procedure rosetta_table_copy_in_p75(t out nocopy oks_entitlements_pub.output_tbl_br, a0 JTF_NUMBER_TABLE
2094: , a1 JTF_NUMBER_TABLE
2095: , a2 JTF_NUMBER_TABLE
2096: , a3 JTF_VARCHAR2_TABLE_100
2097: , a4 JTF_NUMBER_TABLE
2098: , a5 JTF_VARCHAR2_TABLE_100
2099: , a6 JTF_NUMBER_TABLE
2100: , a7 JTF_NUMBER_TABLE
2101: , a8 JTF_NUMBER_TABLE
2095: , a2 JTF_NUMBER_TABLE
2096: , a3 JTF_VARCHAR2_TABLE_100
2097: , a4 JTF_NUMBER_TABLE
2098: , a5 JTF_VARCHAR2_TABLE_100
2099: , a6 JTF_NUMBER_TABLE
2100: , a7 JTF_NUMBER_TABLE
2101: , a8 JTF_NUMBER_TABLE
2102: , a9 JTF_NUMBER_TABLE
2103: , a10 JTF_NUMBER_TABLE
2096: , a3 JTF_VARCHAR2_TABLE_100
2097: , a4 JTF_NUMBER_TABLE
2098: , a5 JTF_VARCHAR2_TABLE_100
2099: , a6 JTF_NUMBER_TABLE
2100: , a7 JTF_NUMBER_TABLE
2101: , a8 JTF_NUMBER_TABLE
2102: , a9 JTF_NUMBER_TABLE
2103: , a10 JTF_NUMBER_TABLE
2104: , a11 JTF_VARCHAR2_TABLE_100
2097: , a4 JTF_NUMBER_TABLE
2098: , a5 JTF_VARCHAR2_TABLE_100
2099: , a6 JTF_NUMBER_TABLE
2100: , a7 JTF_NUMBER_TABLE
2101: , a8 JTF_NUMBER_TABLE
2102: , a9 JTF_NUMBER_TABLE
2103: , a10 JTF_NUMBER_TABLE
2104: , a11 JTF_VARCHAR2_TABLE_100
2105: , a12 JTF_VARCHAR2_TABLE_100
2098: , a5 JTF_VARCHAR2_TABLE_100
2099: , a6 JTF_NUMBER_TABLE
2100: , a7 JTF_NUMBER_TABLE
2101: , a8 JTF_NUMBER_TABLE
2102: , a9 JTF_NUMBER_TABLE
2103: , a10 JTF_NUMBER_TABLE
2104: , a11 JTF_VARCHAR2_TABLE_100
2105: , a12 JTF_VARCHAR2_TABLE_100
2106: , a13 JTF_VARCHAR2_TABLE_100
2099: , a6 JTF_NUMBER_TABLE
2100: , a7 JTF_NUMBER_TABLE
2101: , a8 JTF_NUMBER_TABLE
2102: , a9 JTF_NUMBER_TABLE
2103: , a10 JTF_NUMBER_TABLE
2104: , a11 JTF_VARCHAR2_TABLE_100
2105: , a12 JTF_VARCHAR2_TABLE_100
2106: , a13 JTF_VARCHAR2_TABLE_100
2107: , a14 JTF_VARCHAR2_TABLE_100
2107: , a14 JTF_VARCHAR2_TABLE_100
2108: , a15 JTF_VARCHAR2_TABLE_100
2109: , a16 JTF_VARCHAR2_TABLE_100
2110: , a17 JTF_VARCHAR2_TABLE_100
2111: , a18 JTF_NUMBER_TABLE
2112: , a19 JTF_NUMBER_TABLE
2113: , a20 JTF_VARCHAR2_TABLE_100
2114: ) as
2115: ddindx binary_integer; indx binary_integer;
2108: , a15 JTF_VARCHAR2_TABLE_100
2109: , a16 JTF_VARCHAR2_TABLE_100
2110: , a17 JTF_VARCHAR2_TABLE_100
2111: , a18 JTF_NUMBER_TABLE
2112: , a19 JTF_NUMBER_TABLE
2113: , a20 JTF_VARCHAR2_TABLE_100
2114: ) as
2115: ddindx binary_integer; indx binary_integer;
2116: begin
2148: end loop;
2149: end if;
2150: end if;
2151: end rosetta_table_copy_in_p75;
2152: procedure rosetta_table_copy_out_p75(t oks_entitlements_pub.output_tbl_br, a0 out nocopy JTF_NUMBER_TABLE
2153: , a1 out nocopy JTF_NUMBER_TABLE
2154: , a2 out nocopy JTF_NUMBER_TABLE
2155: , a3 out nocopy JTF_VARCHAR2_TABLE_100
2156: , a4 out nocopy JTF_NUMBER_TABLE
2149: end if;
2150: end if;
2151: end rosetta_table_copy_in_p75;
2152: procedure rosetta_table_copy_out_p75(t oks_entitlements_pub.output_tbl_br, a0 out nocopy JTF_NUMBER_TABLE
2153: , a1 out nocopy JTF_NUMBER_TABLE
2154: , a2 out nocopy JTF_NUMBER_TABLE
2155: , a3 out nocopy JTF_VARCHAR2_TABLE_100
2156: , a4 out nocopy JTF_NUMBER_TABLE
2157: , a5 out nocopy JTF_VARCHAR2_TABLE_100
2150: end if;
2151: end rosetta_table_copy_in_p75;
2152: procedure rosetta_table_copy_out_p75(t oks_entitlements_pub.output_tbl_br, a0 out nocopy JTF_NUMBER_TABLE
2153: , a1 out nocopy JTF_NUMBER_TABLE
2154: , a2 out nocopy JTF_NUMBER_TABLE
2155: , a3 out nocopy JTF_VARCHAR2_TABLE_100
2156: , a4 out nocopy JTF_NUMBER_TABLE
2157: , a5 out nocopy JTF_VARCHAR2_TABLE_100
2158: , a6 out nocopy JTF_NUMBER_TABLE
2152: procedure rosetta_table_copy_out_p75(t oks_entitlements_pub.output_tbl_br, a0 out nocopy JTF_NUMBER_TABLE
2153: , a1 out nocopy JTF_NUMBER_TABLE
2154: , a2 out nocopy JTF_NUMBER_TABLE
2155: , a3 out nocopy JTF_VARCHAR2_TABLE_100
2156: , a4 out nocopy JTF_NUMBER_TABLE
2157: , a5 out nocopy JTF_VARCHAR2_TABLE_100
2158: , a6 out nocopy JTF_NUMBER_TABLE
2159: , a7 out nocopy JTF_NUMBER_TABLE
2160: , a8 out nocopy JTF_NUMBER_TABLE
2154: , a2 out nocopy JTF_NUMBER_TABLE
2155: , a3 out nocopy JTF_VARCHAR2_TABLE_100
2156: , a4 out nocopy JTF_NUMBER_TABLE
2157: , a5 out nocopy JTF_VARCHAR2_TABLE_100
2158: , a6 out nocopy JTF_NUMBER_TABLE
2159: , a7 out nocopy JTF_NUMBER_TABLE
2160: , a8 out nocopy JTF_NUMBER_TABLE
2161: , a9 out nocopy JTF_NUMBER_TABLE
2162: , a10 out nocopy JTF_NUMBER_TABLE
2155: , a3 out nocopy JTF_VARCHAR2_TABLE_100
2156: , a4 out nocopy JTF_NUMBER_TABLE
2157: , a5 out nocopy JTF_VARCHAR2_TABLE_100
2158: , a6 out nocopy JTF_NUMBER_TABLE
2159: , a7 out nocopy JTF_NUMBER_TABLE
2160: , a8 out nocopy JTF_NUMBER_TABLE
2161: , a9 out nocopy JTF_NUMBER_TABLE
2162: , a10 out nocopy JTF_NUMBER_TABLE
2163: , a11 out nocopy JTF_VARCHAR2_TABLE_100
2156: , a4 out nocopy JTF_NUMBER_TABLE
2157: , a5 out nocopy JTF_VARCHAR2_TABLE_100
2158: , a6 out nocopy JTF_NUMBER_TABLE
2159: , a7 out nocopy JTF_NUMBER_TABLE
2160: , a8 out nocopy JTF_NUMBER_TABLE
2161: , a9 out nocopy JTF_NUMBER_TABLE
2162: , a10 out nocopy JTF_NUMBER_TABLE
2163: , a11 out nocopy JTF_VARCHAR2_TABLE_100
2164: , a12 out nocopy JTF_VARCHAR2_TABLE_100
2157: , a5 out nocopy JTF_VARCHAR2_TABLE_100
2158: , a6 out nocopy JTF_NUMBER_TABLE
2159: , a7 out nocopy JTF_NUMBER_TABLE
2160: , a8 out nocopy JTF_NUMBER_TABLE
2161: , a9 out nocopy JTF_NUMBER_TABLE
2162: , a10 out nocopy JTF_NUMBER_TABLE
2163: , a11 out nocopy JTF_VARCHAR2_TABLE_100
2164: , a12 out nocopy JTF_VARCHAR2_TABLE_100
2165: , a13 out nocopy JTF_VARCHAR2_TABLE_100
2158: , a6 out nocopy JTF_NUMBER_TABLE
2159: , a7 out nocopy JTF_NUMBER_TABLE
2160: , a8 out nocopy JTF_NUMBER_TABLE
2161: , a9 out nocopy JTF_NUMBER_TABLE
2162: , a10 out nocopy JTF_NUMBER_TABLE
2163: , a11 out nocopy JTF_VARCHAR2_TABLE_100
2164: , a12 out nocopy JTF_VARCHAR2_TABLE_100
2165: , a13 out nocopy JTF_VARCHAR2_TABLE_100
2166: , a14 out nocopy JTF_VARCHAR2_TABLE_100
2166: , a14 out nocopy JTF_VARCHAR2_TABLE_100
2167: , a15 out nocopy JTF_VARCHAR2_TABLE_100
2168: , a16 out nocopy JTF_VARCHAR2_TABLE_100
2169: , a17 out nocopy JTF_VARCHAR2_TABLE_100
2170: , a18 out nocopy JTF_NUMBER_TABLE
2171: , a19 out nocopy JTF_NUMBER_TABLE
2172: , a20 out nocopy JTF_VARCHAR2_TABLE_100
2173: ) as
2174: ddindx binary_integer; indx binary_integer;
2167: , a15 out nocopy JTF_VARCHAR2_TABLE_100
2168: , a16 out nocopy JTF_VARCHAR2_TABLE_100
2169: , a17 out nocopy JTF_VARCHAR2_TABLE_100
2170: , a18 out nocopy JTF_NUMBER_TABLE
2171: , a19 out nocopy JTF_NUMBER_TABLE
2172: , a20 out nocopy JTF_VARCHAR2_TABLE_100
2173: ) as
2174: ddindx binary_integer; indx binary_integer;
2175: begin
2173: ) as
2174: ddindx binary_integer; indx binary_integer;
2175: begin
2176: if t is null or t.count = 0 then
2177: a0 := JTF_NUMBER_TABLE();
2178: a1 := JTF_NUMBER_TABLE();
2179: a2 := JTF_NUMBER_TABLE();
2180: a3 := JTF_VARCHAR2_TABLE_100();
2181: a4 := JTF_NUMBER_TABLE();
2174: ddindx binary_integer; indx binary_integer;
2175: begin
2176: if t is null or t.count = 0 then
2177: a0 := JTF_NUMBER_TABLE();
2178: a1 := JTF_NUMBER_TABLE();
2179: a2 := JTF_NUMBER_TABLE();
2180: a3 := JTF_VARCHAR2_TABLE_100();
2181: a4 := JTF_NUMBER_TABLE();
2182: a5 := JTF_VARCHAR2_TABLE_100();
2175: begin
2176: if t is null or t.count = 0 then
2177: a0 := JTF_NUMBER_TABLE();
2178: a1 := JTF_NUMBER_TABLE();
2179: a2 := JTF_NUMBER_TABLE();
2180: a3 := JTF_VARCHAR2_TABLE_100();
2181: a4 := JTF_NUMBER_TABLE();
2182: a5 := JTF_VARCHAR2_TABLE_100();
2183: a6 := JTF_NUMBER_TABLE();
2177: a0 := JTF_NUMBER_TABLE();
2178: a1 := JTF_NUMBER_TABLE();
2179: a2 := JTF_NUMBER_TABLE();
2180: a3 := JTF_VARCHAR2_TABLE_100();
2181: a4 := JTF_NUMBER_TABLE();
2182: a5 := JTF_VARCHAR2_TABLE_100();
2183: a6 := JTF_NUMBER_TABLE();
2184: a7 := JTF_NUMBER_TABLE();
2185: a8 := JTF_NUMBER_TABLE();
2179: a2 := JTF_NUMBER_TABLE();
2180: a3 := JTF_VARCHAR2_TABLE_100();
2181: a4 := JTF_NUMBER_TABLE();
2182: a5 := JTF_VARCHAR2_TABLE_100();
2183: a6 := JTF_NUMBER_TABLE();
2184: a7 := JTF_NUMBER_TABLE();
2185: a8 := JTF_NUMBER_TABLE();
2186: a9 := JTF_NUMBER_TABLE();
2187: a10 := JTF_NUMBER_TABLE();
2180: a3 := JTF_VARCHAR2_TABLE_100();
2181: a4 := JTF_NUMBER_TABLE();
2182: a5 := JTF_VARCHAR2_TABLE_100();
2183: a6 := JTF_NUMBER_TABLE();
2184: a7 := JTF_NUMBER_TABLE();
2185: a8 := JTF_NUMBER_TABLE();
2186: a9 := JTF_NUMBER_TABLE();
2187: a10 := JTF_NUMBER_TABLE();
2188: a11 := JTF_VARCHAR2_TABLE_100();
2181: a4 := JTF_NUMBER_TABLE();
2182: a5 := JTF_VARCHAR2_TABLE_100();
2183: a6 := JTF_NUMBER_TABLE();
2184: a7 := JTF_NUMBER_TABLE();
2185: a8 := JTF_NUMBER_TABLE();
2186: a9 := JTF_NUMBER_TABLE();
2187: a10 := JTF_NUMBER_TABLE();
2188: a11 := JTF_VARCHAR2_TABLE_100();
2189: a12 := JTF_VARCHAR2_TABLE_100();
2182: a5 := JTF_VARCHAR2_TABLE_100();
2183: a6 := JTF_NUMBER_TABLE();
2184: a7 := JTF_NUMBER_TABLE();
2185: a8 := JTF_NUMBER_TABLE();
2186: a9 := JTF_NUMBER_TABLE();
2187: a10 := JTF_NUMBER_TABLE();
2188: a11 := JTF_VARCHAR2_TABLE_100();
2189: a12 := JTF_VARCHAR2_TABLE_100();
2190: a13 := JTF_VARCHAR2_TABLE_100();
2183: a6 := JTF_NUMBER_TABLE();
2184: a7 := JTF_NUMBER_TABLE();
2185: a8 := JTF_NUMBER_TABLE();
2186: a9 := JTF_NUMBER_TABLE();
2187: a10 := JTF_NUMBER_TABLE();
2188: a11 := JTF_VARCHAR2_TABLE_100();
2189: a12 := JTF_VARCHAR2_TABLE_100();
2190: a13 := JTF_VARCHAR2_TABLE_100();
2191: a14 := JTF_VARCHAR2_TABLE_100();
2191: a14 := JTF_VARCHAR2_TABLE_100();
2192: a15 := JTF_VARCHAR2_TABLE_100();
2193: a16 := JTF_VARCHAR2_TABLE_100();
2194: a17 := JTF_VARCHAR2_TABLE_100();
2195: a18 := JTF_NUMBER_TABLE();
2196: a19 := JTF_NUMBER_TABLE();
2197: a20 := JTF_VARCHAR2_TABLE_100();
2198: else
2199: a0 := JTF_NUMBER_TABLE();
2192: a15 := JTF_VARCHAR2_TABLE_100();
2193: a16 := JTF_VARCHAR2_TABLE_100();
2194: a17 := JTF_VARCHAR2_TABLE_100();
2195: a18 := JTF_NUMBER_TABLE();
2196: a19 := JTF_NUMBER_TABLE();
2197: a20 := JTF_VARCHAR2_TABLE_100();
2198: else
2199: a0 := JTF_NUMBER_TABLE();
2200: a1 := JTF_NUMBER_TABLE();
2195: a18 := JTF_NUMBER_TABLE();
2196: a19 := JTF_NUMBER_TABLE();
2197: a20 := JTF_VARCHAR2_TABLE_100();
2198: else
2199: a0 := JTF_NUMBER_TABLE();
2200: a1 := JTF_NUMBER_TABLE();
2201: a2 := JTF_NUMBER_TABLE();
2202: a3 := JTF_VARCHAR2_TABLE_100();
2203: a4 := JTF_NUMBER_TABLE();
2196: a19 := JTF_NUMBER_TABLE();
2197: a20 := JTF_VARCHAR2_TABLE_100();
2198: else
2199: a0 := JTF_NUMBER_TABLE();
2200: a1 := JTF_NUMBER_TABLE();
2201: a2 := JTF_NUMBER_TABLE();
2202: a3 := JTF_VARCHAR2_TABLE_100();
2203: a4 := JTF_NUMBER_TABLE();
2204: a5 := JTF_VARCHAR2_TABLE_100();
2197: a20 := JTF_VARCHAR2_TABLE_100();
2198: else
2199: a0 := JTF_NUMBER_TABLE();
2200: a1 := JTF_NUMBER_TABLE();
2201: a2 := JTF_NUMBER_TABLE();
2202: a3 := JTF_VARCHAR2_TABLE_100();
2203: a4 := JTF_NUMBER_TABLE();
2204: a5 := JTF_VARCHAR2_TABLE_100();
2205: a6 := JTF_NUMBER_TABLE();
2199: a0 := JTF_NUMBER_TABLE();
2200: a1 := JTF_NUMBER_TABLE();
2201: a2 := JTF_NUMBER_TABLE();
2202: a3 := JTF_VARCHAR2_TABLE_100();
2203: a4 := JTF_NUMBER_TABLE();
2204: a5 := JTF_VARCHAR2_TABLE_100();
2205: a6 := JTF_NUMBER_TABLE();
2206: a7 := JTF_NUMBER_TABLE();
2207: a8 := JTF_NUMBER_TABLE();
2201: a2 := JTF_NUMBER_TABLE();
2202: a3 := JTF_VARCHAR2_TABLE_100();
2203: a4 := JTF_NUMBER_TABLE();
2204: a5 := JTF_VARCHAR2_TABLE_100();
2205: a6 := JTF_NUMBER_TABLE();
2206: a7 := JTF_NUMBER_TABLE();
2207: a8 := JTF_NUMBER_TABLE();
2208: a9 := JTF_NUMBER_TABLE();
2209: a10 := JTF_NUMBER_TABLE();
2202: a3 := JTF_VARCHAR2_TABLE_100();
2203: a4 := JTF_NUMBER_TABLE();
2204: a5 := JTF_VARCHAR2_TABLE_100();
2205: a6 := JTF_NUMBER_TABLE();
2206: a7 := JTF_NUMBER_TABLE();
2207: a8 := JTF_NUMBER_TABLE();
2208: a9 := JTF_NUMBER_TABLE();
2209: a10 := JTF_NUMBER_TABLE();
2210: a11 := JTF_VARCHAR2_TABLE_100();
2203: a4 := JTF_NUMBER_TABLE();
2204: a5 := JTF_VARCHAR2_TABLE_100();
2205: a6 := JTF_NUMBER_TABLE();
2206: a7 := JTF_NUMBER_TABLE();
2207: a8 := JTF_NUMBER_TABLE();
2208: a9 := JTF_NUMBER_TABLE();
2209: a10 := JTF_NUMBER_TABLE();
2210: a11 := JTF_VARCHAR2_TABLE_100();
2211: a12 := JTF_VARCHAR2_TABLE_100();
2204: a5 := JTF_VARCHAR2_TABLE_100();
2205: a6 := JTF_NUMBER_TABLE();
2206: a7 := JTF_NUMBER_TABLE();
2207: a8 := JTF_NUMBER_TABLE();
2208: a9 := JTF_NUMBER_TABLE();
2209: a10 := JTF_NUMBER_TABLE();
2210: a11 := JTF_VARCHAR2_TABLE_100();
2211: a12 := JTF_VARCHAR2_TABLE_100();
2212: a13 := JTF_VARCHAR2_TABLE_100();
2205: a6 := JTF_NUMBER_TABLE();
2206: a7 := JTF_NUMBER_TABLE();
2207: a8 := JTF_NUMBER_TABLE();
2208: a9 := JTF_NUMBER_TABLE();
2209: a10 := JTF_NUMBER_TABLE();
2210: a11 := JTF_VARCHAR2_TABLE_100();
2211: a12 := JTF_VARCHAR2_TABLE_100();
2212: a13 := JTF_VARCHAR2_TABLE_100();
2213: a14 := JTF_VARCHAR2_TABLE_100();
2213: a14 := JTF_VARCHAR2_TABLE_100();
2214: a15 := JTF_VARCHAR2_TABLE_100();
2215: a16 := JTF_VARCHAR2_TABLE_100();
2216: a17 := JTF_VARCHAR2_TABLE_100();
2217: a18 := JTF_NUMBER_TABLE();
2218: a19 := JTF_NUMBER_TABLE();
2219: a20 := JTF_VARCHAR2_TABLE_100();
2220: if t.count > 0 then
2221: a0.extend(t.count);
2214: a15 := JTF_VARCHAR2_TABLE_100();
2215: a16 := JTF_VARCHAR2_TABLE_100();
2216: a17 := JTF_VARCHAR2_TABLE_100();
2217: a18 := JTF_NUMBER_TABLE();
2218: a19 := JTF_NUMBER_TABLE();
2219: a20 := JTF_VARCHAR2_TABLE_100();
2220: if t.count > 0 then
2221: a0.extend(t.count);
2222: a1.extend(t.count);
2272: end if;
2273: end if;
2274: end rosetta_table_copy_out_p75;
2275:
2276: procedure rosetta_table_copy_in_p79(t out nocopy oks_entitlements_pub.srchline_inpcontlinerec_tbl, a0 JTF_NUMBER_TABLE
2277: , a1 JTF_VARCHAR2_TABLE_100
2278: , a2 JTF_VARCHAR2_TABLE_100
2279: , a3 JTF_DATE_TABLE
2280: , a4 JTF_DATE_TABLE
2279: , a3 JTF_DATE_TABLE
2280: , a4 JTF_DATE_TABLE
2281: , a5 JTF_DATE_TABLE
2282: , a6 JTF_DATE_TABLE
2283: , a7 JTF_NUMBER_TABLE
2284: , a8 JTF_NUMBER_TABLE
2285: , a9 JTF_VARCHAR2_TABLE_100
2286: ) as
2287: ddindx binary_integer; indx binary_integer;
2280: , a4 JTF_DATE_TABLE
2281: , a5 JTF_DATE_TABLE
2282: , a6 JTF_DATE_TABLE
2283: , a7 JTF_NUMBER_TABLE
2284: , a8 JTF_NUMBER_TABLE
2285: , a9 JTF_VARCHAR2_TABLE_100
2286: ) as
2287: ddindx binary_integer; indx binary_integer;
2288: begin
2309: end loop;
2310: end if;
2311: end if;
2312: end rosetta_table_copy_in_p79;
2313: procedure rosetta_table_copy_out_p79(t oks_entitlements_pub.srchline_inpcontlinerec_tbl, a0 out nocopy JTF_NUMBER_TABLE
2314: , a1 out nocopy JTF_VARCHAR2_TABLE_100
2315: , a2 out nocopy JTF_VARCHAR2_TABLE_100
2316: , a3 out nocopy JTF_DATE_TABLE
2317: , a4 out nocopy JTF_DATE_TABLE
2316: , a3 out nocopy JTF_DATE_TABLE
2317: , a4 out nocopy JTF_DATE_TABLE
2318: , a5 out nocopy JTF_DATE_TABLE
2319: , a6 out nocopy JTF_DATE_TABLE
2320: , a7 out nocopy JTF_NUMBER_TABLE
2321: , a8 out nocopy JTF_NUMBER_TABLE
2322: , a9 out nocopy JTF_VARCHAR2_TABLE_100
2323: ) as
2324: ddindx binary_integer; indx binary_integer;
2317: , a4 out nocopy JTF_DATE_TABLE
2318: , a5 out nocopy JTF_DATE_TABLE
2319: , a6 out nocopy JTF_DATE_TABLE
2320: , a7 out nocopy JTF_NUMBER_TABLE
2321: , a8 out nocopy JTF_NUMBER_TABLE
2322: , a9 out nocopy JTF_VARCHAR2_TABLE_100
2323: ) as
2324: ddindx binary_integer; indx binary_integer;
2325: begin
2323: ) as
2324: ddindx binary_integer; indx binary_integer;
2325: begin
2326: if t is null or t.count = 0 then
2327: a0 := JTF_NUMBER_TABLE();
2328: a1 := JTF_VARCHAR2_TABLE_100();
2329: a2 := JTF_VARCHAR2_TABLE_100();
2330: a3 := JTF_DATE_TABLE();
2331: a4 := JTF_DATE_TABLE();
2330: a3 := JTF_DATE_TABLE();
2331: a4 := JTF_DATE_TABLE();
2332: a5 := JTF_DATE_TABLE();
2333: a6 := JTF_DATE_TABLE();
2334: a7 := JTF_NUMBER_TABLE();
2335: a8 := JTF_NUMBER_TABLE();
2336: a9 := JTF_VARCHAR2_TABLE_100();
2337: else
2338: a0 := JTF_NUMBER_TABLE();
2331: a4 := JTF_DATE_TABLE();
2332: a5 := JTF_DATE_TABLE();
2333: a6 := JTF_DATE_TABLE();
2334: a7 := JTF_NUMBER_TABLE();
2335: a8 := JTF_NUMBER_TABLE();
2336: a9 := JTF_VARCHAR2_TABLE_100();
2337: else
2338: a0 := JTF_NUMBER_TABLE();
2339: a1 := JTF_VARCHAR2_TABLE_100();
2334: a7 := JTF_NUMBER_TABLE();
2335: a8 := JTF_NUMBER_TABLE();
2336: a9 := JTF_VARCHAR2_TABLE_100();
2337: else
2338: a0 := JTF_NUMBER_TABLE();
2339: a1 := JTF_VARCHAR2_TABLE_100();
2340: a2 := JTF_VARCHAR2_TABLE_100();
2341: a3 := JTF_DATE_TABLE();
2342: a4 := JTF_DATE_TABLE();
2341: a3 := JTF_DATE_TABLE();
2342: a4 := JTF_DATE_TABLE();
2343: a5 := JTF_DATE_TABLE();
2344: a6 := JTF_DATE_TABLE();
2345: a7 := JTF_NUMBER_TABLE();
2346: a8 := JTF_NUMBER_TABLE();
2347: a9 := JTF_VARCHAR2_TABLE_100();
2348: if t.count > 0 then
2349: a0.extend(t.count);
2342: a4 := JTF_DATE_TABLE();
2343: a5 := JTF_DATE_TABLE();
2344: a6 := JTF_DATE_TABLE();
2345: a7 := JTF_NUMBER_TABLE();
2346: a8 := JTF_NUMBER_TABLE();
2347: a9 := JTF_VARCHAR2_TABLE_100();
2348: if t.count > 0 then
2349: a0.extend(t.count);
2350: a1.extend(t.count);
2378: end if;
2379: end if;
2380: end rosetta_table_copy_out_p79;
2381:
2382: procedure rosetta_table_copy_in_p81(t out nocopy oks_entitlements_pub.srchline_covlvl_id_tbl, a0 JTF_NUMBER_TABLE
2383: , a1 JTF_NUMBER_TABLE
2384: , a2 JTF_VARCHAR2_TABLE_100
2385: ) as
2386: ddindx binary_integer; indx binary_integer;
2379: end if;
2380: end rosetta_table_copy_out_p79;
2381:
2382: procedure rosetta_table_copy_in_p81(t out nocopy oks_entitlements_pub.srchline_covlvl_id_tbl, a0 JTF_NUMBER_TABLE
2383: , a1 JTF_NUMBER_TABLE
2384: , a2 JTF_VARCHAR2_TABLE_100
2385: ) as
2386: ddindx binary_integer; indx binary_integer;
2387: begin
2401: end loop;
2402: end if;
2403: end if;
2404: end rosetta_table_copy_in_p81;
2405: procedure rosetta_table_copy_out_p81(t oks_entitlements_pub.srchline_covlvl_id_tbl, a0 out nocopy JTF_NUMBER_TABLE
2406: , a1 out nocopy JTF_NUMBER_TABLE
2407: , a2 out nocopy JTF_VARCHAR2_TABLE_100
2408: ) as
2409: ddindx binary_integer; indx binary_integer;
2402: end if;
2403: end if;
2404: end rosetta_table_copy_in_p81;
2405: procedure rosetta_table_copy_out_p81(t oks_entitlements_pub.srchline_covlvl_id_tbl, a0 out nocopy JTF_NUMBER_TABLE
2406: , a1 out nocopy JTF_NUMBER_TABLE
2407: , a2 out nocopy JTF_VARCHAR2_TABLE_100
2408: ) as
2409: ddindx binary_integer; indx binary_integer;
2410: begin
2408: ) as
2409: ddindx binary_integer; indx binary_integer;
2410: begin
2411: if t is null or t.count = 0 then
2412: a0 := JTF_NUMBER_TABLE();
2413: a1 := JTF_NUMBER_TABLE();
2414: a2 := JTF_VARCHAR2_TABLE_100();
2415: else
2416: a0 := JTF_NUMBER_TABLE();
2409: ddindx binary_integer; indx binary_integer;
2410: begin
2411: if t is null or t.count = 0 then
2412: a0 := JTF_NUMBER_TABLE();
2413: a1 := JTF_NUMBER_TABLE();
2414: a2 := JTF_VARCHAR2_TABLE_100();
2415: else
2416: a0 := JTF_NUMBER_TABLE();
2417: a1 := JTF_NUMBER_TABLE();
2412: a0 := JTF_NUMBER_TABLE();
2413: a1 := JTF_NUMBER_TABLE();
2414: a2 := JTF_VARCHAR2_TABLE_100();
2415: else
2416: a0 := JTF_NUMBER_TABLE();
2417: a1 := JTF_NUMBER_TABLE();
2418: a2 := JTF_VARCHAR2_TABLE_100();
2419: if t.count > 0 then
2420: a0.extend(t.count);
2413: a1 := JTF_NUMBER_TABLE();
2414: a2 := JTF_VARCHAR2_TABLE_100();
2415: else
2416: a0 := JTF_NUMBER_TABLE();
2417: a1 := JTF_NUMBER_TABLE();
2418: a2 := JTF_VARCHAR2_TABLE_100();
2419: if t.count > 0 then
2420: a0.extend(t.count);
2421: a1.extend(t.count);
2445: , a6 JTF_DATE_TABLE
2446: , a7 JTF_DATE_TABLE
2447: , a8 JTF_VARCHAR2_TABLE_100
2448: , a9 JTF_VARCHAR2_TABLE_200
2449: , a10 JTF_NUMBER_TABLE
2450: , a11 JTF_NUMBER_TABLE
2451: , a12 JTF_NUMBER_TABLE
2452: , a13 JTF_NUMBER_TABLE
2453: , a14 JTF_NUMBER_TABLE
2446: , a7 JTF_DATE_TABLE
2447: , a8 JTF_VARCHAR2_TABLE_100
2448: , a9 JTF_VARCHAR2_TABLE_200
2449: , a10 JTF_NUMBER_TABLE
2450: , a11 JTF_NUMBER_TABLE
2451: , a12 JTF_NUMBER_TABLE
2452: , a13 JTF_NUMBER_TABLE
2453: , a14 JTF_NUMBER_TABLE
2454: , a15 JTF_VARCHAR2_TABLE_100
2447: , a8 JTF_VARCHAR2_TABLE_100
2448: , a9 JTF_VARCHAR2_TABLE_200
2449: , a10 JTF_NUMBER_TABLE
2450: , a11 JTF_NUMBER_TABLE
2451: , a12 JTF_NUMBER_TABLE
2452: , a13 JTF_NUMBER_TABLE
2453: , a14 JTF_NUMBER_TABLE
2454: , a15 JTF_VARCHAR2_TABLE_100
2455: , a16 JTF_NUMBER_TABLE
2448: , a9 JTF_VARCHAR2_TABLE_200
2449: , a10 JTF_NUMBER_TABLE
2450: , a11 JTF_NUMBER_TABLE
2451: , a12 JTF_NUMBER_TABLE
2452: , a13 JTF_NUMBER_TABLE
2453: , a14 JTF_NUMBER_TABLE
2454: , a15 JTF_VARCHAR2_TABLE_100
2455: , a16 JTF_NUMBER_TABLE
2456: , a17 JTF_VARCHAR2_TABLE_300
2449: , a10 JTF_NUMBER_TABLE
2450: , a11 JTF_NUMBER_TABLE
2451: , a12 JTF_NUMBER_TABLE
2452: , a13 JTF_NUMBER_TABLE
2453: , a14 JTF_NUMBER_TABLE
2454: , a15 JTF_VARCHAR2_TABLE_100
2455: , a16 JTF_NUMBER_TABLE
2456: , a17 JTF_VARCHAR2_TABLE_300
2457: ) as
2451: , a12 JTF_NUMBER_TABLE
2452: , a13 JTF_NUMBER_TABLE
2453: , a14 JTF_NUMBER_TABLE
2454: , a15 JTF_VARCHAR2_TABLE_100
2455: , a16 JTF_NUMBER_TABLE
2456: , a17 JTF_VARCHAR2_TABLE_300
2457: ) as
2458: ddindx binary_integer; indx binary_integer;
2459: begin
2498: , a6 out nocopy JTF_DATE_TABLE
2499: , a7 out nocopy JTF_DATE_TABLE
2500: , a8 out nocopy JTF_VARCHAR2_TABLE_100
2501: , a9 out nocopy JTF_VARCHAR2_TABLE_200
2502: , a10 out nocopy JTF_NUMBER_TABLE
2503: , a11 out nocopy JTF_NUMBER_TABLE
2504: , a12 out nocopy JTF_NUMBER_TABLE
2505: , a13 out nocopy JTF_NUMBER_TABLE
2506: , a14 out nocopy JTF_NUMBER_TABLE
2499: , a7 out nocopy JTF_DATE_TABLE
2500: , a8 out nocopy JTF_VARCHAR2_TABLE_100
2501: , a9 out nocopy JTF_VARCHAR2_TABLE_200
2502: , a10 out nocopy JTF_NUMBER_TABLE
2503: , a11 out nocopy JTF_NUMBER_TABLE
2504: , a12 out nocopy JTF_NUMBER_TABLE
2505: , a13 out nocopy JTF_NUMBER_TABLE
2506: , a14 out nocopy JTF_NUMBER_TABLE
2507: , a15 out nocopy JTF_VARCHAR2_TABLE_100
2500: , a8 out nocopy JTF_VARCHAR2_TABLE_100
2501: , a9 out nocopy JTF_VARCHAR2_TABLE_200
2502: , a10 out nocopy JTF_NUMBER_TABLE
2503: , a11 out nocopy JTF_NUMBER_TABLE
2504: , a12 out nocopy JTF_NUMBER_TABLE
2505: , a13 out nocopy JTF_NUMBER_TABLE
2506: , a14 out nocopy JTF_NUMBER_TABLE
2507: , a15 out nocopy JTF_VARCHAR2_TABLE_100
2508: , a16 out nocopy JTF_NUMBER_TABLE
2501: , a9 out nocopy JTF_VARCHAR2_TABLE_200
2502: , a10 out nocopy JTF_NUMBER_TABLE
2503: , a11 out nocopy JTF_NUMBER_TABLE
2504: , a12 out nocopy JTF_NUMBER_TABLE
2505: , a13 out nocopy JTF_NUMBER_TABLE
2506: , a14 out nocopy JTF_NUMBER_TABLE
2507: , a15 out nocopy JTF_VARCHAR2_TABLE_100
2508: , a16 out nocopy JTF_NUMBER_TABLE
2509: , a17 out nocopy JTF_VARCHAR2_TABLE_300
2502: , a10 out nocopy JTF_NUMBER_TABLE
2503: , a11 out nocopy JTF_NUMBER_TABLE
2504: , a12 out nocopy JTF_NUMBER_TABLE
2505: , a13 out nocopy JTF_NUMBER_TABLE
2506: , a14 out nocopy JTF_NUMBER_TABLE
2507: , a15 out nocopy JTF_VARCHAR2_TABLE_100
2508: , a16 out nocopy JTF_NUMBER_TABLE
2509: , a17 out nocopy JTF_VARCHAR2_TABLE_300
2510: ) as
2504: , a12 out nocopy JTF_NUMBER_TABLE
2505: , a13 out nocopy JTF_NUMBER_TABLE
2506: , a14 out nocopy JTF_NUMBER_TABLE
2507: , a15 out nocopy JTF_VARCHAR2_TABLE_100
2508: , a16 out nocopy JTF_NUMBER_TABLE
2509: , a17 out nocopy JTF_VARCHAR2_TABLE_300
2510: ) as
2511: ddindx binary_integer; indx binary_integer;
2512: begin
2520: a6 := JTF_DATE_TABLE();
2521: a7 := JTF_DATE_TABLE();
2522: a8 := JTF_VARCHAR2_TABLE_100();
2523: a9 := JTF_VARCHAR2_TABLE_200();
2524: a10 := JTF_NUMBER_TABLE();
2525: a11 := JTF_NUMBER_TABLE();
2526: a12 := JTF_NUMBER_TABLE();
2527: a13 := JTF_NUMBER_TABLE();
2528: a14 := JTF_NUMBER_TABLE();
2521: a7 := JTF_DATE_TABLE();
2522: a8 := JTF_VARCHAR2_TABLE_100();
2523: a9 := JTF_VARCHAR2_TABLE_200();
2524: a10 := JTF_NUMBER_TABLE();
2525: a11 := JTF_NUMBER_TABLE();
2526: a12 := JTF_NUMBER_TABLE();
2527: a13 := JTF_NUMBER_TABLE();
2528: a14 := JTF_NUMBER_TABLE();
2529: a15 := JTF_VARCHAR2_TABLE_100();
2522: a8 := JTF_VARCHAR2_TABLE_100();
2523: a9 := JTF_VARCHAR2_TABLE_200();
2524: a10 := JTF_NUMBER_TABLE();
2525: a11 := JTF_NUMBER_TABLE();
2526: a12 := JTF_NUMBER_TABLE();
2527: a13 := JTF_NUMBER_TABLE();
2528: a14 := JTF_NUMBER_TABLE();
2529: a15 := JTF_VARCHAR2_TABLE_100();
2530: a16 := JTF_NUMBER_TABLE();
2523: a9 := JTF_VARCHAR2_TABLE_200();
2524: a10 := JTF_NUMBER_TABLE();
2525: a11 := JTF_NUMBER_TABLE();
2526: a12 := JTF_NUMBER_TABLE();
2527: a13 := JTF_NUMBER_TABLE();
2528: a14 := JTF_NUMBER_TABLE();
2529: a15 := JTF_VARCHAR2_TABLE_100();
2530: a16 := JTF_NUMBER_TABLE();
2531: a17 := JTF_VARCHAR2_TABLE_300();
2524: a10 := JTF_NUMBER_TABLE();
2525: a11 := JTF_NUMBER_TABLE();
2526: a12 := JTF_NUMBER_TABLE();
2527: a13 := JTF_NUMBER_TABLE();
2528: a14 := JTF_NUMBER_TABLE();
2529: a15 := JTF_VARCHAR2_TABLE_100();
2530: a16 := JTF_NUMBER_TABLE();
2531: a17 := JTF_VARCHAR2_TABLE_300();
2532: else
2526: a12 := JTF_NUMBER_TABLE();
2527: a13 := JTF_NUMBER_TABLE();
2528: a14 := JTF_NUMBER_TABLE();
2529: a15 := JTF_VARCHAR2_TABLE_100();
2530: a16 := JTF_NUMBER_TABLE();
2531: a17 := JTF_VARCHAR2_TABLE_300();
2532: else
2533: a0 := JTF_VARCHAR2_TABLE_200();
2534: a1 := JTF_VARCHAR2_TABLE_200();
2539: a6 := JTF_DATE_TABLE();
2540: a7 := JTF_DATE_TABLE();
2541: a8 := JTF_VARCHAR2_TABLE_100();
2542: a9 := JTF_VARCHAR2_TABLE_200();
2543: a10 := JTF_NUMBER_TABLE();
2544: a11 := JTF_NUMBER_TABLE();
2545: a12 := JTF_NUMBER_TABLE();
2546: a13 := JTF_NUMBER_TABLE();
2547: a14 := JTF_NUMBER_TABLE();
2540: a7 := JTF_DATE_TABLE();
2541: a8 := JTF_VARCHAR2_TABLE_100();
2542: a9 := JTF_VARCHAR2_TABLE_200();
2543: a10 := JTF_NUMBER_TABLE();
2544: a11 := JTF_NUMBER_TABLE();
2545: a12 := JTF_NUMBER_TABLE();
2546: a13 := JTF_NUMBER_TABLE();
2547: a14 := JTF_NUMBER_TABLE();
2548: a15 := JTF_VARCHAR2_TABLE_100();
2541: a8 := JTF_VARCHAR2_TABLE_100();
2542: a9 := JTF_VARCHAR2_TABLE_200();
2543: a10 := JTF_NUMBER_TABLE();
2544: a11 := JTF_NUMBER_TABLE();
2545: a12 := JTF_NUMBER_TABLE();
2546: a13 := JTF_NUMBER_TABLE();
2547: a14 := JTF_NUMBER_TABLE();
2548: a15 := JTF_VARCHAR2_TABLE_100();
2549: a16 := JTF_NUMBER_TABLE();
2542: a9 := JTF_VARCHAR2_TABLE_200();
2543: a10 := JTF_NUMBER_TABLE();
2544: a11 := JTF_NUMBER_TABLE();
2545: a12 := JTF_NUMBER_TABLE();
2546: a13 := JTF_NUMBER_TABLE();
2547: a14 := JTF_NUMBER_TABLE();
2548: a15 := JTF_VARCHAR2_TABLE_100();
2549: a16 := JTF_NUMBER_TABLE();
2550: a17 := JTF_VARCHAR2_TABLE_300();
2543: a10 := JTF_NUMBER_TABLE();
2544: a11 := JTF_NUMBER_TABLE();
2545: a12 := JTF_NUMBER_TABLE();
2546: a13 := JTF_NUMBER_TABLE();
2547: a14 := JTF_NUMBER_TABLE();
2548: a15 := JTF_VARCHAR2_TABLE_100();
2549: a16 := JTF_NUMBER_TABLE();
2550: a17 := JTF_VARCHAR2_TABLE_300();
2551: if t.count > 0 then
2545: a12 := JTF_NUMBER_TABLE();
2546: a13 := JTF_NUMBER_TABLE();
2547: a14 := JTF_NUMBER_TABLE();
2548: a15 := JTF_VARCHAR2_TABLE_100();
2549: a16 := JTF_NUMBER_TABLE();
2550: a17 := JTF_VARCHAR2_TABLE_300();
2551: if t.count > 0 then
2552: a0.extend(t.count);
2553: a1.extend(t.count);
2607: , p2_a4 NUMBER
2608: , x_return_status out nocopy VARCHAR2
2609: , x_msg_count out nocopy NUMBER
2610: , x_msg_data out nocopy VARCHAR2
2611: , p6_a0 out nocopy JTF_NUMBER_TABLE
2612: , p6_a1 out nocopy JTF_NUMBER_TABLE
2613: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
2614: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
2615: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_600
2608: , x_return_status out nocopy VARCHAR2
2609: , x_msg_count out nocopy NUMBER
2610: , x_msg_data out nocopy VARCHAR2
2611: , p6_a0 out nocopy JTF_NUMBER_TABLE
2612: , p6_a1 out nocopy JTF_NUMBER_TABLE
2613: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
2614: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
2615: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_600
2616: , p6_a5 out nocopy JTF_NUMBER_TABLE
2612: , p6_a1 out nocopy JTF_NUMBER_TABLE
2613: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
2614: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
2615: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_600
2616: , p6_a5 out nocopy JTF_NUMBER_TABLE
2617: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
2618: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
2619: , p6_a8 out nocopy JTF_NUMBER_TABLE
2620: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
2615: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_600
2616: , p6_a5 out nocopy JTF_NUMBER_TABLE
2617: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
2618: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
2619: , p6_a8 out nocopy JTF_NUMBER_TABLE
2620: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
2621: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_200
2622: , p6_a11 out nocopy JTF_NUMBER_TABLE
2623: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
2618: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
2619: , p6_a8 out nocopy JTF_NUMBER_TABLE
2620: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
2621: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_200
2622: , p6_a11 out nocopy JTF_NUMBER_TABLE
2623: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
2624: , p6_a13 out nocopy JTF_DATE_TABLE
2625: , p6_a14 out nocopy JTF_DATE_TABLE
2626: , p6_a15 out nocopy JTF_NUMBER_TABLE
2622: , p6_a11 out nocopy JTF_NUMBER_TABLE
2623: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
2624: , p6_a13 out nocopy JTF_DATE_TABLE
2625: , p6_a14 out nocopy JTF_DATE_TABLE
2626: , p6_a15 out nocopy JTF_NUMBER_TABLE
2627: , p6_a16 out nocopy JTF_NUMBER_TABLE
2628: , p6_a17 out nocopy JTF_NUMBER_TABLE
2629: , p6_a18 out nocopy JTF_NUMBER_TABLE
2630: , p6_a19 out nocopy JTF_NUMBER_TABLE
2623: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
2624: , p6_a13 out nocopy JTF_DATE_TABLE
2625: , p6_a14 out nocopy JTF_DATE_TABLE
2626: , p6_a15 out nocopy JTF_NUMBER_TABLE
2627: , p6_a16 out nocopy JTF_NUMBER_TABLE
2628: , p6_a17 out nocopy JTF_NUMBER_TABLE
2629: , p6_a18 out nocopy JTF_NUMBER_TABLE
2630: , p6_a19 out nocopy JTF_NUMBER_TABLE
2631: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
2624: , p6_a13 out nocopy JTF_DATE_TABLE
2625: , p6_a14 out nocopy JTF_DATE_TABLE
2626: , p6_a15 out nocopy JTF_NUMBER_TABLE
2627: , p6_a16 out nocopy JTF_NUMBER_TABLE
2628: , p6_a17 out nocopy JTF_NUMBER_TABLE
2629: , p6_a18 out nocopy JTF_NUMBER_TABLE
2630: , p6_a19 out nocopy JTF_NUMBER_TABLE
2631: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
2632: , p6_a21 out nocopy JTF_NUMBER_TABLE
2625: , p6_a14 out nocopy JTF_DATE_TABLE
2626: , p6_a15 out nocopy JTF_NUMBER_TABLE
2627: , p6_a16 out nocopy JTF_NUMBER_TABLE
2628: , p6_a17 out nocopy JTF_NUMBER_TABLE
2629: , p6_a18 out nocopy JTF_NUMBER_TABLE
2630: , p6_a19 out nocopy JTF_NUMBER_TABLE
2631: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
2632: , p6_a21 out nocopy JTF_NUMBER_TABLE
2633: , p6_a22 out nocopy JTF_NUMBER_TABLE
2626: , p6_a15 out nocopy JTF_NUMBER_TABLE
2627: , p6_a16 out nocopy JTF_NUMBER_TABLE
2628: , p6_a17 out nocopy JTF_NUMBER_TABLE
2629: , p6_a18 out nocopy JTF_NUMBER_TABLE
2630: , p6_a19 out nocopy JTF_NUMBER_TABLE
2631: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
2632: , p6_a21 out nocopy JTF_NUMBER_TABLE
2633: , p6_a22 out nocopy JTF_NUMBER_TABLE
2634: , p6_a23 out nocopy JTF_NUMBER_TABLE
2628: , p6_a17 out nocopy JTF_NUMBER_TABLE
2629: , p6_a18 out nocopy JTF_NUMBER_TABLE
2630: , p6_a19 out nocopy JTF_NUMBER_TABLE
2631: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
2632: , p6_a21 out nocopy JTF_NUMBER_TABLE
2633: , p6_a22 out nocopy JTF_NUMBER_TABLE
2634: , p6_a23 out nocopy JTF_NUMBER_TABLE
2635: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_200
2636: , p6_a25 out nocopy JTF_NUMBER_TABLE
2629: , p6_a18 out nocopy JTF_NUMBER_TABLE
2630: , p6_a19 out nocopy JTF_NUMBER_TABLE
2631: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
2632: , p6_a21 out nocopy JTF_NUMBER_TABLE
2633: , p6_a22 out nocopy JTF_NUMBER_TABLE
2634: , p6_a23 out nocopy JTF_NUMBER_TABLE
2635: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_200
2636: , p6_a25 out nocopy JTF_NUMBER_TABLE
2637: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_100
2630: , p6_a19 out nocopy JTF_NUMBER_TABLE
2631: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
2632: , p6_a21 out nocopy JTF_NUMBER_TABLE
2633: , p6_a22 out nocopy JTF_NUMBER_TABLE
2634: , p6_a23 out nocopy JTF_NUMBER_TABLE
2635: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_200
2636: , p6_a25 out nocopy JTF_NUMBER_TABLE
2637: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_100
2638: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_100
2632: , p6_a21 out nocopy JTF_NUMBER_TABLE
2633: , p6_a22 out nocopy JTF_NUMBER_TABLE
2634: , p6_a23 out nocopy JTF_NUMBER_TABLE
2635: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_200
2636: , p6_a25 out nocopy JTF_NUMBER_TABLE
2637: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_100
2638: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_100
2639: , p6_a28 out nocopy JTF_NUMBER_TABLE
2640: , p6_a29 out nocopy JTF_DATE_TABLE
2635: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_200
2636: , p6_a25 out nocopy JTF_NUMBER_TABLE
2637: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_100
2638: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_100
2639: , p6_a28 out nocopy JTF_NUMBER_TABLE
2640: , p6_a29 out nocopy JTF_DATE_TABLE
2641: , p6_a30 out nocopy JTF_DATE_TABLE
2642: , p6_a31 out nocopy JTF_NUMBER_TABLE
2643: , p6_a32 out nocopy JTF_NUMBER_TABLE
2638: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_100
2639: , p6_a28 out nocopy JTF_NUMBER_TABLE
2640: , p6_a29 out nocopy JTF_DATE_TABLE
2641: , p6_a30 out nocopy JTF_DATE_TABLE
2642: , p6_a31 out nocopy JTF_NUMBER_TABLE
2643: , p6_a32 out nocopy JTF_NUMBER_TABLE
2644: , p6_a33 out nocopy JTF_CLOB_TABLE
2645: , p6_a34 out nocopy JTF_CLOB_TABLE
2646: , p6_a35 out nocopy JTF_VARCHAR2_TABLE_500
2639: , p6_a28 out nocopy JTF_NUMBER_TABLE
2640: , p6_a29 out nocopy JTF_DATE_TABLE
2641: , p6_a30 out nocopy JTF_DATE_TABLE
2642: , p6_a31 out nocopy JTF_NUMBER_TABLE
2643: , p6_a32 out nocopy JTF_NUMBER_TABLE
2644: , p6_a33 out nocopy JTF_CLOB_TABLE
2645: , p6_a34 out nocopy JTF_CLOB_TABLE
2646: , p6_a35 out nocopy JTF_VARCHAR2_TABLE_500
2647: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_500
2729: , p_contract_line_id NUMBER
2730: , x_return_status out nocopy VARCHAR2
2731: , x_msg_count out nocopy NUMBER
2732: , x_msg_data out nocopy VARCHAR2
2733: , p6_a0 out nocopy JTF_NUMBER_TABLE
2734: , p6_a1 out nocopy JTF_NUMBER_TABLE
2735: , p6_a2 out nocopy JTF_NUMBER_TABLE
2736: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
2737: , p6_a4 out nocopy JTF_NUMBER_TABLE
2730: , x_return_status out nocopy VARCHAR2
2731: , x_msg_count out nocopy NUMBER
2732: , x_msg_data out nocopy VARCHAR2
2733: , p6_a0 out nocopy JTF_NUMBER_TABLE
2734: , p6_a1 out nocopy JTF_NUMBER_TABLE
2735: , p6_a2 out nocopy JTF_NUMBER_TABLE
2736: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
2737: , p6_a4 out nocopy JTF_NUMBER_TABLE
2738: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
2731: , x_msg_count out nocopy NUMBER
2732: , x_msg_data out nocopy VARCHAR2
2733: , p6_a0 out nocopy JTF_NUMBER_TABLE
2734: , p6_a1 out nocopy JTF_NUMBER_TABLE
2735: , p6_a2 out nocopy JTF_NUMBER_TABLE
2736: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
2737: , p6_a4 out nocopy JTF_NUMBER_TABLE
2738: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
2739: , p6_a6 out nocopy JTF_DATE_TABLE
2733: , p6_a0 out nocopy JTF_NUMBER_TABLE
2734: , p6_a1 out nocopy JTF_NUMBER_TABLE
2735: , p6_a2 out nocopy JTF_NUMBER_TABLE
2736: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
2737: , p6_a4 out nocopy JTF_NUMBER_TABLE
2738: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
2739: , p6_a6 out nocopy JTF_DATE_TABLE
2740: , p6_a7 out nocopy JTF_DATE_TABLE
2741: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_200
2738: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
2739: , p6_a6 out nocopy JTF_DATE_TABLE
2740: , p6_a7 out nocopy JTF_DATE_TABLE
2741: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_200
2742: , p6_a9 out nocopy JTF_NUMBER_TABLE
2743: , p6_a10 out nocopy JTF_NUMBER_TABLE
2744: , p6_a11 out nocopy JTF_NUMBER_TABLE
2745: , p6_a12 out nocopy JTF_NUMBER_TABLE
2746: , p6_a13 out nocopy JTF_NUMBER_TABLE
2739: , p6_a6 out nocopy JTF_DATE_TABLE
2740: , p6_a7 out nocopy JTF_DATE_TABLE
2741: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_200
2742: , p6_a9 out nocopy JTF_NUMBER_TABLE
2743: , p6_a10 out nocopy JTF_NUMBER_TABLE
2744: , p6_a11 out nocopy JTF_NUMBER_TABLE
2745: , p6_a12 out nocopy JTF_NUMBER_TABLE
2746: , p6_a13 out nocopy JTF_NUMBER_TABLE
2747: , p6_a14 out nocopy JTF_NUMBER_TABLE
2740: , p6_a7 out nocopy JTF_DATE_TABLE
2741: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_200
2742: , p6_a9 out nocopy JTF_NUMBER_TABLE
2743: , p6_a10 out nocopy JTF_NUMBER_TABLE
2744: , p6_a11 out nocopy JTF_NUMBER_TABLE
2745: , p6_a12 out nocopy JTF_NUMBER_TABLE
2746: , p6_a13 out nocopy JTF_NUMBER_TABLE
2747: , p6_a14 out nocopy JTF_NUMBER_TABLE
2748: , p6_a15 out nocopy JTF_NUMBER_TABLE
2741: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_200
2742: , p6_a9 out nocopy JTF_NUMBER_TABLE
2743: , p6_a10 out nocopy JTF_NUMBER_TABLE
2744: , p6_a11 out nocopy JTF_NUMBER_TABLE
2745: , p6_a12 out nocopy JTF_NUMBER_TABLE
2746: , p6_a13 out nocopy JTF_NUMBER_TABLE
2747: , p6_a14 out nocopy JTF_NUMBER_TABLE
2748: , p6_a15 out nocopy JTF_NUMBER_TABLE
2749: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
2742: , p6_a9 out nocopy JTF_NUMBER_TABLE
2743: , p6_a10 out nocopy JTF_NUMBER_TABLE
2744: , p6_a11 out nocopy JTF_NUMBER_TABLE
2745: , p6_a12 out nocopy JTF_NUMBER_TABLE
2746: , p6_a13 out nocopy JTF_NUMBER_TABLE
2747: , p6_a14 out nocopy JTF_NUMBER_TABLE
2748: , p6_a15 out nocopy JTF_NUMBER_TABLE
2749: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
2750: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
2743: , p6_a10 out nocopy JTF_NUMBER_TABLE
2744: , p6_a11 out nocopy JTF_NUMBER_TABLE
2745: , p6_a12 out nocopy JTF_NUMBER_TABLE
2746: , p6_a13 out nocopy JTF_NUMBER_TABLE
2747: , p6_a14 out nocopy JTF_NUMBER_TABLE
2748: , p6_a15 out nocopy JTF_NUMBER_TABLE
2749: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
2750: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
2751: , p6_a18 out nocopy JTF_NUMBER_TABLE
2744: , p6_a11 out nocopy JTF_NUMBER_TABLE
2745: , p6_a12 out nocopy JTF_NUMBER_TABLE
2746: , p6_a13 out nocopy JTF_NUMBER_TABLE
2747: , p6_a14 out nocopy JTF_NUMBER_TABLE
2748: , p6_a15 out nocopy JTF_NUMBER_TABLE
2749: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
2750: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
2751: , p6_a18 out nocopy JTF_NUMBER_TABLE
2752: , p6_a19 out nocopy JTF_DATE_TABLE
2747: , p6_a14 out nocopy JTF_NUMBER_TABLE
2748: , p6_a15 out nocopy JTF_NUMBER_TABLE
2749: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
2750: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
2751: , p6_a18 out nocopy JTF_NUMBER_TABLE
2752: , p6_a19 out nocopy JTF_DATE_TABLE
2753: , p6_a20 out nocopy JTF_DATE_TABLE
2754: , p6_a21 out nocopy JTF_DATE_TABLE
2755: )
2814: , x_return_status out nocopy VARCHAR2
2815: , x_msg_count out nocopy NUMBER
2816: , x_msg_data out nocopy VARCHAR2
2817: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
2818: , p6_a1 out nocopy JTF_NUMBER_TABLE
2819: , p6_a2 out nocopy JTF_NUMBER_TABLE
2820: , p6_a3 out nocopy JTF_NUMBER_TABLE
2821: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
2822: , p6_a5 out nocopy JTF_NUMBER_TABLE
2815: , x_msg_count out nocopy NUMBER
2816: , x_msg_data out nocopy VARCHAR2
2817: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
2818: , p6_a1 out nocopy JTF_NUMBER_TABLE
2819: , p6_a2 out nocopy JTF_NUMBER_TABLE
2820: , p6_a3 out nocopy JTF_NUMBER_TABLE
2821: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
2822: , p6_a5 out nocopy JTF_NUMBER_TABLE
2823: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300
2816: , x_msg_data out nocopy VARCHAR2
2817: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
2818: , p6_a1 out nocopy JTF_NUMBER_TABLE
2819: , p6_a2 out nocopy JTF_NUMBER_TABLE
2820: , p6_a3 out nocopy JTF_NUMBER_TABLE
2821: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
2822: , p6_a5 out nocopy JTF_NUMBER_TABLE
2823: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300
2824: , p6_a7 out nocopy JTF_NUMBER_TABLE
2818: , p6_a1 out nocopy JTF_NUMBER_TABLE
2819: , p6_a2 out nocopy JTF_NUMBER_TABLE
2820: , p6_a3 out nocopy JTF_NUMBER_TABLE
2821: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
2822: , p6_a5 out nocopy JTF_NUMBER_TABLE
2823: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300
2824: , p6_a7 out nocopy JTF_NUMBER_TABLE
2825: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_300
2826: , p6_a9 out nocopy JTF_NUMBER_TABLE
2820: , p6_a3 out nocopy JTF_NUMBER_TABLE
2821: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
2822: , p6_a5 out nocopy JTF_NUMBER_TABLE
2823: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300
2824: , p6_a7 out nocopy JTF_NUMBER_TABLE
2825: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_300
2826: , p6_a9 out nocopy JTF_NUMBER_TABLE
2827: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_300
2828: , p6_a11 out nocopy JTF_NUMBER_TABLE
2822: , p6_a5 out nocopy JTF_NUMBER_TABLE
2823: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300
2824: , p6_a7 out nocopy JTF_NUMBER_TABLE
2825: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_300
2826: , p6_a9 out nocopy JTF_NUMBER_TABLE
2827: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_300
2828: , p6_a11 out nocopy JTF_NUMBER_TABLE
2829: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_300
2830: , p6_a13 out nocopy JTF_NUMBER_TABLE
2824: , p6_a7 out nocopy JTF_NUMBER_TABLE
2825: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_300
2826: , p6_a9 out nocopy JTF_NUMBER_TABLE
2827: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_300
2828: , p6_a11 out nocopy JTF_NUMBER_TABLE
2829: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_300
2830: , p6_a13 out nocopy JTF_NUMBER_TABLE
2831: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_300
2832: , p6_a15 out nocopy JTF_NUMBER_TABLE
2826: , p6_a9 out nocopy JTF_NUMBER_TABLE
2827: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_300
2828: , p6_a11 out nocopy JTF_NUMBER_TABLE
2829: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_300
2830: , p6_a13 out nocopy JTF_NUMBER_TABLE
2831: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_300
2832: , p6_a15 out nocopy JTF_NUMBER_TABLE
2833: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
2834: , p6_a17 out nocopy JTF_NUMBER_TABLE
2828: , p6_a11 out nocopy JTF_NUMBER_TABLE
2829: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_300
2830: , p6_a13 out nocopy JTF_NUMBER_TABLE
2831: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_300
2832: , p6_a15 out nocopy JTF_NUMBER_TABLE
2833: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
2834: , p6_a17 out nocopy JTF_NUMBER_TABLE
2835: , p6_a18 out nocopy JTF_NUMBER_TABLE
2836: , p6_a19 out nocopy JTF_NUMBER_TABLE
2830: , p6_a13 out nocopy JTF_NUMBER_TABLE
2831: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_300
2832: , p6_a15 out nocopy JTF_NUMBER_TABLE
2833: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
2834: , p6_a17 out nocopy JTF_NUMBER_TABLE
2835: , p6_a18 out nocopy JTF_NUMBER_TABLE
2836: , p6_a19 out nocopy JTF_NUMBER_TABLE
2837: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_200
2838: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
2831: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_300
2832: , p6_a15 out nocopy JTF_NUMBER_TABLE
2833: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
2834: , p6_a17 out nocopy JTF_NUMBER_TABLE
2835: , p6_a18 out nocopy JTF_NUMBER_TABLE
2836: , p6_a19 out nocopy JTF_NUMBER_TABLE
2837: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_200
2838: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
2839: , p6_a22 out nocopy JTF_NUMBER_TABLE
2832: , p6_a15 out nocopy JTF_NUMBER_TABLE
2833: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
2834: , p6_a17 out nocopy JTF_NUMBER_TABLE
2835: , p6_a18 out nocopy JTF_NUMBER_TABLE
2836: , p6_a19 out nocopy JTF_NUMBER_TABLE
2837: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_200
2838: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
2839: , p6_a22 out nocopy JTF_NUMBER_TABLE
2840: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_100
2835: , p6_a18 out nocopy JTF_NUMBER_TABLE
2836: , p6_a19 out nocopy JTF_NUMBER_TABLE
2837: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_200
2838: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
2839: , p6_a22 out nocopy JTF_NUMBER_TABLE
2840: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_100
2841: , p6_a24 out nocopy JTF_NUMBER_TABLE
2842: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
2843: , p6_a26 out nocopy JTF_NUMBER_TABLE
2837: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_200
2838: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
2839: , p6_a22 out nocopy JTF_NUMBER_TABLE
2840: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_100
2841: , p6_a24 out nocopy JTF_NUMBER_TABLE
2842: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
2843: , p6_a26 out nocopy JTF_NUMBER_TABLE
2844: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_100
2845: , p6_a28 out nocopy JTF_NUMBER_TABLE
2839: , p6_a22 out nocopy JTF_NUMBER_TABLE
2840: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_100
2841: , p6_a24 out nocopy JTF_NUMBER_TABLE
2842: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
2843: , p6_a26 out nocopy JTF_NUMBER_TABLE
2844: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_100
2845: , p6_a28 out nocopy JTF_NUMBER_TABLE
2846: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_100
2847: , p6_a30 out nocopy JTF_NUMBER_TABLE
2841: , p6_a24 out nocopy JTF_NUMBER_TABLE
2842: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
2843: , p6_a26 out nocopy JTF_NUMBER_TABLE
2844: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_100
2845: , p6_a28 out nocopy JTF_NUMBER_TABLE
2846: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_100
2847: , p6_a30 out nocopy JTF_NUMBER_TABLE
2848: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_100
2849: , p6_a32 out nocopy JTF_NUMBER_TABLE
2843: , p6_a26 out nocopy JTF_NUMBER_TABLE
2844: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_100
2845: , p6_a28 out nocopy JTF_NUMBER_TABLE
2846: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_100
2847: , p6_a30 out nocopy JTF_NUMBER_TABLE
2848: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_100
2849: , p6_a32 out nocopy JTF_NUMBER_TABLE
2850: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_100
2851: , p6_a34 out nocopy JTF_VARCHAR2_TABLE_100
2845: , p6_a28 out nocopy JTF_NUMBER_TABLE
2846: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_100
2847: , p6_a30 out nocopy JTF_NUMBER_TABLE
2848: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_100
2849: , p6_a32 out nocopy JTF_NUMBER_TABLE
2850: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_100
2851: , p6_a34 out nocopy JTF_VARCHAR2_TABLE_100
2852: )
2853:
2933: , p2_a10 VARCHAR2
2934: , x_return_status out nocopy VARCHAR2
2935: , x_msg_count out nocopy NUMBER
2936: , x_msg_data out nocopy VARCHAR2
2937: , p6_a0 out nocopy JTF_NUMBER_TABLE
2938: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
2939: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
2940: , p6_a3 out nocopy JTF_NUMBER_TABLE
2941: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_300
2936: , x_msg_data out nocopy VARCHAR2
2937: , p6_a0 out nocopy JTF_NUMBER_TABLE
2938: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
2939: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
2940: , p6_a3 out nocopy JTF_NUMBER_TABLE
2941: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_300
2942: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_300
2943: , p6_a6 out nocopy JTF_NUMBER_TABLE
2944: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_200
2939: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
2940: , p6_a3 out nocopy JTF_NUMBER_TABLE
2941: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_300
2942: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_300
2943: , p6_a6 out nocopy JTF_NUMBER_TABLE
2944: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_200
2945: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_2000
2946: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
2947: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
2944: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_200
2945: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_2000
2946: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
2947: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
2948: , p6_a11 out nocopy JTF_NUMBER_TABLE
2949: , p6_a12 out nocopy JTF_NUMBER_TABLE
2950: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_200
2951: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
2952: , p6_a15 out nocopy JTF_DATE_TABLE
2945: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_2000
2946: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
2947: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
2948: , p6_a11 out nocopy JTF_NUMBER_TABLE
2949: , p6_a12 out nocopy JTF_NUMBER_TABLE
2950: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_200
2951: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
2952: , p6_a15 out nocopy JTF_DATE_TABLE
2953: , p6_a16 out nocopy JTF_DATE_TABLE
2950: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_200
2951: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
2952: , p6_a15 out nocopy JTF_DATE_TABLE
2953: , p6_a16 out nocopy JTF_DATE_TABLE
2954: , p6_a17 out nocopy JTF_NUMBER_TABLE
2955: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
2956: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
2957: )
2958:
3042: , p2_a17 VARCHAR2
3043: , x_return_status out nocopy VARCHAR2
3044: , x_msg_count out nocopy NUMBER
3045: , x_msg_data out nocopy VARCHAR2
3046: , p6_a0 out nocopy JTF_NUMBER_TABLE
3047: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
3048: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
3049: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
3050: , p6_a4 out nocopy JTF_NUMBER_TABLE
3046: , p6_a0 out nocopy JTF_NUMBER_TABLE
3047: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
3048: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
3049: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
3050: , p6_a4 out nocopy JTF_NUMBER_TABLE
3051: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_300
3052: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300
3053: , p6_a7 out nocopy JTF_NUMBER_TABLE
3054: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_200
3049: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
3050: , p6_a4 out nocopy JTF_NUMBER_TABLE
3051: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_300
3052: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300
3053: , p6_a7 out nocopy JTF_NUMBER_TABLE
3054: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_200
3055: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_2000
3056: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
3057: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
3054: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_200
3055: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_2000
3056: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
3057: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
3058: , p6_a12 out nocopy JTF_NUMBER_TABLE
3059: , p6_a13 out nocopy JTF_DATE_TABLE
3060: , p6_a14 out nocopy JTF_DATE_TABLE
3061: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
3062: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
3069: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
3070: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_100
3071: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
3072: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_100
3073: , p6_a27 out nocopy JTF_NUMBER_TABLE
3074: )
3075:
3076: as
3077: ddp_inp_rec oks_entitlements_pub.get_contin_rec;
3171: , p2_a14 VARCHAR2
3172: , x_return_status out nocopy VARCHAR2
3173: , x_msg_count out nocopy NUMBER
3174: , x_msg_data out nocopy VARCHAR2
3175: , p6_a0 out nocopy JTF_NUMBER_TABLE
3176: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
3177: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
3178: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
3179: , p6_a4 out nocopy JTF_NUMBER_TABLE
3175: , p6_a0 out nocopy JTF_NUMBER_TABLE
3176: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
3177: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
3178: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
3179: , p6_a4 out nocopy JTF_NUMBER_TABLE
3180: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_300
3181: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300
3182: , p6_a7 out nocopy JTF_NUMBER_TABLE
3183: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_200
3178: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
3179: , p6_a4 out nocopy JTF_NUMBER_TABLE
3180: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_300
3181: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300
3182: , p6_a7 out nocopy JTF_NUMBER_TABLE
3183: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_200
3184: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_2000
3185: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
3186: , p6_a11 out nocopy JTF_NUMBER_TABLE
3182: , p6_a7 out nocopy JTF_NUMBER_TABLE
3183: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_200
3184: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_2000
3185: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
3186: , p6_a11 out nocopy JTF_NUMBER_TABLE
3187: , p6_a12 out nocopy JTF_DATE_TABLE
3188: , p6_a13 out nocopy JTF_DATE_TABLE
3189: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
3190: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
3192: , p6_a17 out nocopy JTF_DATE_TABLE
3193: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
3194: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_2000
3195: , p6_a20 out nocopy JTF_DATE_TABLE
3196: , p6_a21 out nocopy JTF_NUMBER_TABLE
3197: )
3198:
3199: as
3200: ddp_inp_rec oks_entitlements_pub.input_rec_ib;
3282: , p2_a11 VARCHAR2
3283: , x_return_status out nocopy VARCHAR2
3284: , x_msg_count out nocopy NUMBER
3285: , x_msg_data out nocopy VARCHAR2
3286: , p6_a0 out nocopy JTF_NUMBER_TABLE
3287: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
3288: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
3289: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_300
3290: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_600
3353: , p_contract_line_id NUMBER
3354: , p_busiproc_id NUMBER
3355: , p_request_date date
3356: , p5_a0 JTF_VARCHAR2_TABLE_100
3357: , p5_a1 JTF_NUMBER_TABLE
3358: , p5_a2 JTF_NUMBER_TABLE
3359: , p5_a3 JTF_VARCHAR2_TABLE_100
3360: , p_verify_combination VARCHAR2
3361: , x_return_status out nocopy VARCHAR2
3354: , p_busiproc_id NUMBER
3355: , p_request_date date
3356: , p5_a0 JTF_VARCHAR2_TABLE_100
3357: , p5_a1 JTF_NUMBER_TABLE
3358: , p5_a2 JTF_NUMBER_TABLE
3359: , p5_a3 JTF_VARCHAR2_TABLE_100
3360: , p_verify_combination VARCHAR2
3361: , x_return_status out nocopy VARCHAR2
3362: , x_msg_count out nocopy NUMBER
3361: , x_return_status out nocopy VARCHAR2
3362: , x_msg_count out nocopy NUMBER
3363: , x_msg_data out nocopy VARCHAR2
3364: , p10_a0 out nocopy JTF_VARCHAR2_TABLE_100
3365: , p10_a1 out nocopy JTF_NUMBER_TABLE
3366: , p10_a2 out nocopy JTF_NUMBER_TABLE
3367: , p10_a3 out nocopy JTF_VARCHAR2_TABLE_100
3368: , x_combination_valid out nocopy VARCHAR2
3369: )
3362: , x_msg_count out nocopy NUMBER
3363: , x_msg_data out nocopy VARCHAR2
3364: , p10_a0 out nocopy JTF_VARCHAR2_TABLE_100
3365: , p10_a1 out nocopy JTF_NUMBER_TABLE
3366: , p10_a2 out nocopy JTF_NUMBER_TABLE
3367: , p10_a3 out nocopy JTF_VARCHAR2_TABLE_100
3368: , x_combination_valid out nocopy VARCHAR2
3369: )
3370:
3440: , p2_a8 DATE
3441: , p2_a9 NUMBER
3442: , p2_a10 DATE
3443: , p2_a11 VARCHAR2
3444: , p3_a0 JTF_NUMBER_TABLE
3445: , p3_a1 JTF_VARCHAR2_TABLE_100
3446: , x_return_status out nocopy VARCHAR2
3447: , x_msg_count out nocopy NUMBER
3448: , x_msg_data out nocopy VARCHAR2
3454: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_2000
3455: , p7_a6 out nocopy JTF_DATE_TABLE
3456: , p7_a7 out nocopy JTF_DATE_TABLE
3457: , p7_a8 out nocopy JTF_DATE_TABLE
3458: , p7_a9 out nocopy JTF_NUMBER_TABLE
3459: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100
3460: , p7_a11 out nocopy JTF_VARCHAR2_TABLE_100
3461: , p7_a12 out nocopy JTF_VARCHAR2_TABLE_100
3462: )
3835: , p_contract_line_id NUMBER
3836: , x_return_status out nocopy VARCHAR2
3837: , x_msg_count out nocopy NUMBER
3838: , x_msg_data out nocopy VARCHAR2
3839: , p7_a0 out nocopy JTF_NUMBER_TABLE
3840: , p7_a1 out nocopy JTF_NUMBER_TABLE
3841: , p7_a2 out nocopy JTF_NUMBER_TABLE
3842: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
3843: , p7_a4 out nocopy JTF_NUMBER_TABLE
3836: , x_return_status out nocopy VARCHAR2
3837: , x_msg_count out nocopy NUMBER
3838: , x_msg_data out nocopy VARCHAR2
3839: , p7_a0 out nocopy JTF_NUMBER_TABLE
3840: , p7_a1 out nocopy JTF_NUMBER_TABLE
3841: , p7_a2 out nocopy JTF_NUMBER_TABLE
3842: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
3843: , p7_a4 out nocopy JTF_NUMBER_TABLE
3844: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
3837: , x_msg_count out nocopy NUMBER
3838: , x_msg_data out nocopy VARCHAR2
3839: , p7_a0 out nocopy JTF_NUMBER_TABLE
3840: , p7_a1 out nocopy JTF_NUMBER_TABLE
3841: , p7_a2 out nocopy JTF_NUMBER_TABLE
3842: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
3843: , p7_a4 out nocopy JTF_NUMBER_TABLE
3844: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
3845: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100
3839: , p7_a0 out nocopy JTF_NUMBER_TABLE
3840: , p7_a1 out nocopy JTF_NUMBER_TABLE
3841: , p7_a2 out nocopy JTF_NUMBER_TABLE
3842: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
3843: , p7_a4 out nocopy JTF_NUMBER_TABLE
3844: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
3845: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100
3846: )
3847:
3894: , p_request_date date
3895: , x_return_status out nocopy VARCHAR2
3896: , x_msg_count out nocopy NUMBER
3897: , x_msg_data out nocopy VARCHAR2
3898: , p8_a0 out nocopy JTF_NUMBER_TABLE
3899: , p8_a1 out nocopy JTF_NUMBER_TABLE
3900: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100
3901: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_100
3902: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_100
3895: , x_return_status out nocopy VARCHAR2
3896: , x_msg_count out nocopy NUMBER
3897: , x_msg_data out nocopy VARCHAR2
3898: , p8_a0 out nocopy JTF_NUMBER_TABLE
3899: , p8_a1 out nocopy JTF_NUMBER_TABLE
3900: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100
3901: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_100
3902: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_100
3903: )
4106: , p2_a4 VARCHAR2
4107: , x_return_status out nocopy VARCHAR2
4108: , x_msg_count out nocopy NUMBER
4109: , x_msg_data out nocopy VARCHAR2
4110: , p6_a0 out nocopy JTF_NUMBER_TABLE
4111: , p6_a1 out nocopy JTF_NUMBER_TABLE
4112: , p6_a2 out nocopy JTF_DATE_TABLE
4113: , p6_a3 out nocopy JTF_DATE_TABLE
4114: )
4107: , x_return_status out nocopy VARCHAR2
4108: , x_msg_count out nocopy NUMBER
4109: , x_msg_data out nocopy VARCHAR2
4110: , p6_a0 out nocopy JTF_NUMBER_TABLE
4111: , p6_a1 out nocopy JTF_NUMBER_TABLE
4112: , p6_a2 out nocopy JTF_DATE_TABLE
4113: , p6_a3 out nocopy JTF_DATE_TABLE
4114: )
4115:
4161: , p_return_bill_rates_yn VARCHAR2
4162: , x_return_status out nocopy VARCHAR2
4163: , x_msg_count out nocopy NUMBER
4164: , x_msg_data out nocopy VARCHAR2
4165: , p7_a0 out nocopy JTF_NUMBER_TABLE
4166: , p7_a1 out nocopy JTF_NUMBER_TABLE
4167: , p7_a2 out nocopy JTF_NUMBER_TABLE
4168: , p7_a3 out nocopy JTF_NUMBER_TABLE
4169: , p8_a0 out nocopy JTF_NUMBER_TABLE
4162: , x_return_status out nocopy VARCHAR2
4163: , x_msg_count out nocopy NUMBER
4164: , x_msg_data out nocopy VARCHAR2
4165: , p7_a0 out nocopy JTF_NUMBER_TABLE
4166: , p7_a1 out nocopy JTF_NUMBER_TABLE
4167: , p7_a2 out nocopy JTF_NUMBER_TABLE
4168: , p7_a3 out nocopy JTF_NUMBER_TABLE
4169: , p8_a0 out nocopy JTF_NUMBER_TABLE
4170: , p8_a1 out nocopy JTF_NUMBER_TABLE
4163: , x_msg_count out nocopy NUMBER
4164: , x_msg_data out nocopy VARCHAR2
4165: , p7_a0 out nocopy JTF_NUMBER_TABLE
4166: , p7_a1 out nocopy JTF_NUMBER_TABLE
4167: , p7_a2 out nocopy JTF_NUMBER_TABLE
4168: , p7_a3 out nocopy JTF_NUMBER_TABLE
4169: , p8_a0 out nocopy JTF_NUMBER_TABLE
4170: , p8_a1 out nocopy JTF_NUMBER_TABLE
4171: , p8_a2 out nocopy JTF_NUMBER_TABLE
4164: , x_msg_data out nocopy VARCHAR2
4165: , p7_a0 out nocopy JTF_NUMBER_TABLE
4166: , p7_a1 out nocopy JTF_NUMBER_TABLE
4167: , p7_a2 out nocopy JTF_NUMBER_TABLE
4168: , p7_a3 out nocopy JTF_NUMBER_TABLE
4169: , p8_a0 out nocopy JTF_NUMBER_TABLE
4170: , p8_a1 out nocopy JTF_NUMBER_TABLE
4171: , p8_a2 out nocopy JTF_NUMBER_TABLE
4172: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_100
4165: , p7_a0 out nocopy JTF_NUMBER_TABLE
4166: , p7_a1 out nocopy JTF_NUMBER_TABLE
4167: , p7_a2 out nocopy JTF_NUMBER_TABLE
4168: , p7_a3 out nocopy JTF_NUMBER_TABLE
4169: , p8_a0 out nocopy JTF_NUMBER_TABLE
4170: , p8_a1 out nocopy JTF_NUMBER_TABLE
4171: , p8_a2 out nocopy JTF_NUMBER_TABLE
4172: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_100
4173: , p8_a4 out nocopy JTF_NUMBER_TABLE
4166: , p7_a1 out nocopy JTF_NUMBER_TABLE
4167: , p7_a2 out nocopy JTF_NUMBER_TABLE
4168: , p7_a3 out nocopy JTF_NUMBER_TABLE
4169: , p8_a0 out nocopy JTF_NUMBER_TABLE
4170: , p8_a1 out nocopy JTF_NUMBER_TABLE
4171: , p8_a2 out nocopy JTF_NUMBER_TABLE
4172: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_100
4173: , p8_a4 out nocopy JTF_NUMBER_TABLE
4174: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
4167: , p7_a2 out nocopy JTF_NUMBER_TABLE
4168: , p7_a3 out nocopy JTF_NUMBER_TABLE
4169: , p8_a0 out nocopy JTF_NUMBER_TABLE
4170: , p8_a1 out nocopy JTF_NUMBER_TABLE
4171: , p8_a2 out nocopy JTF_NUMBER_TABLE
4172: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_100
4173: , p8_a4 out nocopy JTF_NUMBER_TABLE
4174: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
4175: , p8_a6 out nocopy JTF_NUMBER_TABLE
4169: , p8_a0 out nocopy JTF_NUMBER_TABLE
4170: , p8_a1 out nocopy JTF_NUMBER_TABLE
4171: , p8_a2 out nocopy JTF_NUMBER_TABLE
4172: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_100
4173: , p8_a4 out nocopy JTF_NUMBER_TABLE
4174: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
4175: , p8_a6 out nocopy JTF_NUMBER_TABLE
4176: , p8_a7 out nocopy JTF_NUMBER_TABLE
4177: , p8_a8 out nocopy JTF_NUMBER_TABLE
4171: , p8_a2 out nocopy JTF_NUMBER_TABLE
4172: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_100
4173: , p8_a4 out nocopy JTF_NUMBER_TABLE
4174: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
4175: , p8_a6 out nocopy JTF_NUMBER_TABLE
4176: , p8_a7 out nocopy JTF_NUMBER_TABLE
4177: , p8_a8 out nocopy JTF_NUMBER_TABLE
4178: , p8_a9 out nocopy JTF_NUMBER_TABLE
4179: , p8_a10 out nocopy JTF_NUMBER_TABLE
4172: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_100
4173: , p8_a4 out nocopy JTF_NUMBER_TABLE
4174: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
4175: , p8_a6 out nocopy JTF_NUMBER_TABLE
4176: , p8_a7 out nocopy JTF_NUMBER_TABLE
4177: , p8_a8 out nocopy JTF_NUMBER_TABLE
4178: , p8_a9 out nocopy JTF_NUMBER_TABLE
4179: , p8_a10 out nocopy JTF_NUMBER_TABLE
4180: , p8_a11 out nocopy JTF_VARCHAR2_TABLE_100
4173: , p8_a4 out nocopy JTF_NUMBER_TABLE
4174: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
4175: , p8_a6 out nocopy JTF_NUMBER_TABLE
4176: , p8_a7 out nocopy JTF_NUMBER_TABLE
4177: , p8_a8 out nocopy JTF_NUMBER_TABLE
4178: , p8_a9 out nocopy JTF_NUMBER_TABLE
4179: , p8_a10 out nocopy JTF_NUMBER_TABLE
4180: , p8_a11 out nocopy JTF_VARCHAR2_TABLE_100
4181: , p8_a12 out nocopy JTF_VARCHAR2_TABLE_100
4174: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
4175: , p8_a6 out nocopy JTF_NUMBER_TABLE
4176: , p8_a7 out nocopy JTF_NUMBER_TABLE
4177: , p8_a8 out nocopy JTF_NUMBER_TABLE
4178: , p8_a9 out nocopy JTF_NUMBER_TABLE
4179: , p8_a10 out nocopy JTF_NUMBER_TABLE
4180: , p8_a11 out nocopy JTF_VARCHAR2_TABLE_100
4181: , p8_a12 out nocopy JTF_VARCHAR2_TABLE_100
4182: , p8_a13 out nocopy JTF_VARCHAR2_TABLE_100
4175: , p8_a6 out nocopy JTF_NUMBER_TABLE
4176: , p8_a7 out nocopy JTF_NUMBER_TABLE
4177: , p8_a8 out nocopy JTF_NUMBER_TABLE
4178: , p8_a9 out nocopy JTF_NUMBER_TABLE
4179: , p8_a10 out nocopy JTF_NUMBER_TABLE
4180: , p8_a11 out nocopy JTF_VARCHAR2_TABLE_100
4181: , p8_a12 out nocopy JTF_VARCHAR2_TABLE_100
4182: , p8_a13 out nocopy JTF_VARCHAR2_TABLE_100
4183: , p8_a14 out nocopy JTF_VARCHAR2_TABLE_100
4183: , p8_a14 out nocopy JTF_VARCHAR2_TABLE_100
4184: , p8_a15 out nocopy JTF_VARCHAR2_TABLE_100
4185: , p8_a16 out nocopy JTF_VARCHAR2_TABLE_100
4186: , p8_a17 out nocopy JTF_VARCHAR2_TABLE_100
4187: , p8_a18 out nocopy JTF_NUMBER_TABLE
4188: , p8_a19 out nocopy JTF_NUMBER_TABLE
4189: , p8_a20 out nocopy JTF_VARCHAR2_TABLE_100
4190: )
4191:
4184: , p8_a15 out nocopy JTF_VARCHAR2_TABLE_100
4185: , p8_a16 out nocopy JTF_VARCHAR2_TABLE_100
4186: , p8_a17 out nocopy JTF_VARCHAR2_TABLE_100
4187: , p8_a18 out nocopy JTF_NUMBER_TABLE
4188: , p8_a19 out nocopy JTF_NUMBER_TABLE
4189: , p8_a20 out nocopy JTF_VARCHAR2_TABLE_100
4190: )
4191:
4192: as
4281: , p3_a6 DATE
4282: , p3_a7 NUMBER
4283: , p3_a8 NUMBER
4284: , p3_a9 VARCHAR2
4285: , p4_a0 JTF_NUMBER_TABLE
4286: , p4_a1 JTF_NUMBER_TABLE
4287: , p4_a2 JTF_VARCHAR2_TABLE_100
4288: , x_return_status out nocopy VARCHAR2
4289: , x_msg_count out nocopy NUMBER
4282: , p3_a7 NUMBER
4283: , p3_a8 NUMBER
4284: , p3_a9 VARCHAR2
4285: , p4_a0 JTF_NUMBER_TABLE
4286: , p4_a1 JTF_NUMBER_TABLE
4287: , p4_a2 JTF_VARCHAR2_TABLE_100
4288: , x_return_status out nocopy VARCHAR2
4289: , x_msg_count out nocopy NUMBER
4290: , x_msg_data out nocopy VARCHAR2
4297: , p8_a6 out nocopy JTF_DATE_TABLE
4298: , p8_a7 out nocopy JTF_DATE_TABLE
4299: , p8_a8 out nocopy JTF_VARCHAR2_TABLE_100
4300: , p8_a9 out nocopy JTF_VARCHAR2_TABLE_200
4301: , p8_a10 out nocopy JTF_NUMBER_TABLE
4302: , p8_a11 out nocopy JTF_NUMBER_TABLE
4303: , p8_a12 out nocopy JTF_NUMBER_TABLE
4304: , p8_a13 out nocopy JTF_NUMBER_TABLE
4305: , p8_a14 out nocopy JTF_NUMBER_TABLE
4298: , p8_a7 out nocopy JTF_DATE_TABLE
4299: , p8_a8 out nocopy JTF_VARCHAR2_TABLE_100
4300: , p8_a9 out nocopy JTF_VARCHAR2_TABLE_200
4301: , p8_a10 out nocopy JTF_NUMBER_TABLE
4302: , p8_a11 out nocopy JTF_NUMBER_TABLE
4303: , p8_a12 out nocopy JTF_NUMBER_TABLE
4304: , p8_a13 out nocopy JTF_NUMBER_TABLE
4305: , p8_a14 out nocopy JTF_NUMBER_TABLE
4306: , p8_a15 out nocopy JTF_VARCHAR2_TABLE_100
4299: , p8_a8 out nocopy JTF_VARCHAR2_TABLE_100
4300: , p8_a9 out nocopy JTF_VARCHAR2_TABLE_200
4301: , p8_a10 out nocopy JTF_NUMBER_TABLE
4302: , p8_a11 out nocopy JTF_NUMBER_TABLE
4303: , p8_a12 out nocopy JTF_NUMBER_TABLE
4304: , p8_a13 out nocopy JTF_NUMBER_TABLE
4305: , p8_a14 out nocopy JTF_NUMBER_TABLE
4306: , p8_a15 out nocopy JTF_VARCHAR2_TABLE_100
4307: , p8_a16 out nocopy JTF_NUMBER_TABLE
4300: , p8_a9 out nocopy JTF_VARCHAR2_TABLE_200
4301: , p8_a10 out nocopy JTF_NUMBER_TABLE
4302: , p8_a11 out nocopy JTF_NUMBER_TABLE
4303: , p8_a12 out nocopy JTF_NUMBER_TABLE
4304: , p8_a13 out nocopy JTF_NUMBER_TABLE
4305: , p8_a14 out nocopy JTF_NUMBER_TABLE
4306: , p8_a15 out nocopy JTF_VARCHAR2_TABLE_100
4307: , p8_a16 out nocopy JTF_NUMBER_TABLE
4308: , p8_a17 out nocopy JTF_VARCHAR2_TABLE_300
4301: , p8_a10 out nocopy JTF_NUMBER_TABLE
4302: , p8_a11 out nocopy JTF_NUMBER_TABLE
4303: , p8_a12 out nocopy JTF_NUMBER_TABLE
4304: , p8_a13 out nocopy JTF_NUMBER_TABLE
4305: , p8_a14 out nocopy JTF_NUMBER_TABLE
4306: , p8_a15 out nocopy JTF_VARCHAR2_TABLE_100
4307: , p8_a16 out nocopy JTF_NUMBER_TABLE
4308: , p8_a17 out nocopy JTF_VARCHAR2_TABLE_300
4309: )
4303: , p8_a12 out nocopy JTF_NUMBER_TABLE
4304: , p8_a13 out nocopy JTF_NUMBER_TABLE
4305: , p8_a14 out nocopy JTF_NUMBER_TABLE
4306: , p8_a15 out nocopy JTF_VARCHAR2_TABLE_100
4307: , p8_a16 out nocopy JTF_NUMBER_TABLE
4308: , p8_a17 out nocopy JTF_VARCHAR2_TABLE_300
4309: )
4310:
4311: as