APPS.OKL_SRS_PVT_W dependencies on JTF_NUMBER_TABLE

Line 22: procedure rosetta_table_copy_in_p2(t out nocopy okl_srs_pvt.srs_tbl_type, a0 JTF_NUMBER_TABLE

18: if n=b then return a; end if;
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_srs_pvt.srs_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_200
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_NUMBER_TABLE

Line 24: , a2 JTF_NUMBER_TABLE

20: end;
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_srs_pvt.srs_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_200
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_DATE_TABLE
28: , a6 JTF_NUMBER_TABLE

Line 26: , a4 JTF_NUMBER_TABLE

22: procedure rosetta_table_copy_in_p2(t out nocopy okl_srs_pvt.srs_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_200
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_DATE_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_VARCHAR2_TABLE_500

Line 28: , a6 JTF_NUMBER_TABLE

24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_DATE_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_VARCHAR2_TABLE_500
31: , a9 JTF_VARCHAR2_TABLE_500
32: , a10 JTF_VARCHAR2_TABLE_500

Line 29: , a7 JTF_NUMBER_TABLE

25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_DATE_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_VARCHAR2_TABLE_500
31: , a9 JTF_VARCHAR2_TABLE_500
32: , a10 JTF_VARCHAR2_TABLE_500
33: , a11 JTF_VARCHAR2_TABLE_500

Line 45: , a23 JTF_NUMBER_TABLE

41: , a19 JTF_VARCHAR2_TABLE_500
42: , a20 JTF_VARCHAR2_TABLE_500
43: , a21 JTF_VARCHAR2_TABLE_500
44: , a22 JTF_VARCHAR2_TABLE_500
45: , a23 JTF_NUMBER_TABLE
46: , a24 JTF_NUMBER_TABLE
47: , a25 JTF_NUMBER_TABLE
48: , a26 JTF_DATE_TABLE
49: , a27 JTF_DATE_TABLE

Line 46: , a24 JTF_NUMBER_TABLE

42: , a20 JTF_VARCHAR2_TABLE_500
43: , a21 JTF_VARCHAR2_TABLE_500
44: , a22 JTF_VARCHAR2_TABLE_500
45: , a23 JTF_NUMBER_TABLE
46: , a24 JTF_NUMBER_TABLE
47: , a25 JTF_NUMBER_TABLE
48: , a26 JTF_DATE_TABLE
49: , a27 JTF_DATE_TABLE
50: , a28 JTF_NUMBER_TABLE

Line 47: , a25 JTF_NUMBER_TABLE

43: , a21 JTF_VARCHAR2_TABLE_500
44: , a22 JTF_VARCHAR2_TABLE_500
45: , a23 JTF_NUMBER_TABLE
46: , a24 JTF_NUMBER_TABLE
47: , a25 JTF_NUMBER_TABLE
48: , a26 JTF_DATE_TABLE
49: , a27 JTF_DATE_TABLE
50: , a28 JTF_NUMBER_TABLE
51: ) as

Line 50: , a28 JTF_NUMBER_TABLE

46: , a24 JTF_NUMBER_TABLE
47: , a25 JTF_NUMBER_TABLE
48: , a26 JTF_DATE_TABLE
49: , a27 JTF_DATE_TABLE
50: , a28 JTF_NUMBER_TABLE
51: ) as
52: ddindx binary_integer; indx binary_integer;
53: begin
54: if a0 is not null and a0.count > 0 then

Line 97: procedure rosetta_table_copy_out_p2(t okl_srs_pvt.srs_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

93: end loop;
94: end if;
95: end if;
96: end rosetta_table_copy_in_p2;
97: procedure rosetta_table_copy_out_p2(t okl_srs_pvt.srs_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
98: , a1 out nocopy JTF_VARCHAR2_TABLE_200
99: , a2 out nocopy JTF_NUMBER_TABLE
100: , a3 out nocopy JTF_VARCHAR2_TABLE_100
101: , a4 out nocopy JTF_NUMBER_TABLE

Line 99: , a2 out nocopy JTF_NUMBER_TABLE

95: end if;
96: end rosetta_table_copy_in_p2;
97: procedure rosetta_table_copy_out_p2(t okl_srs_pvt.srs_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
98: , a1 out nocopy JTF_VARCHAR2_TABLE_200
99: , a2 out nocopy JTF_NUMBER_TABLE
100: , a3 out nocopy JTF_VARCHAR2_TABLE_100
101: , a4 out nocopy JTF_NUMBER_TABLE
102: , a5 out nocopy JTF_DATE_TABLE
103: , a6 out nocopy JTF_NUMBER_TABLE

Line 101: , a4 out nocopy JTF_NUMBER_TABLE

97: procedure rosetta_table_copy_out_p2(t okl_srs_pvt.srs_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
98: , a1 out nocopy JTF_VARCHAR2_TABLE_200
99: , a2 out nocopy JTF_NUMBER_TABLE
100: , a3 out nocopy JTF_VARCHAR2_TABLE_100
101: , a4 out nocopy JTF_NUMBER_TABLE
102: , a5 out nocopy JTF_DATE_TABLE
103: , a6 out nocopy JTF_NUMBER_TABLE
104: , a7 out nocopy JTF_NUMBER_TABLE
105: , a8 out nocopy JTF_VARCHAR2_TABLE_500

Line 103: , a6 out nocopy JTF_NUMBER_TABLE

99: , a2 out nocopy JTF_NUMBER_TABLE
100: , a3 out nocopy JTF_VARCHAR2_TABLE_100
101: , a4 out nocopy JTF_NUMBER_TABLE
102: , a5 out nocopy JTF_DATE_TABLE
103: , a6 out nocopy JTF_NUMBER_TABLE
104: , a7 out nocopy JTF_NUMBER_TABLE
105: , a8 out nocopy JTF_VARCHAR2_TABLE_500
106: , a9 out nocopy JTF_VARCHAR2_TABLE_500
107: , a10 out nocopy JTF_VARCHAR2_TABLE_500

Line 104: , a7 out nocopy JTF_NUMBER_TABLE

100: , a3 out nocopy JTF_VARCHAR2_TABLE_100
101: , a4 out nocopy JTF_NUMBER_TABLE
102: , a5 out nocopy JTF_DATE_TABLE
103: , a6 out nocopy JTF_NUMBER_TABLE
104: , a7 out nocopy JTF_NUMBER_TABLE
105: , a8 out nocopy JTF_VARCHAR2_TABLE_500
106: , a9 out nocopy JTF_VARCHAR2_TABLE_500
107: , a10 out nocopy JTF_VARCHAR2_TABLE_500
108: , a11 out nocopy JTF_VARCHAR2_TABLE_500

Line 120: , a23 out nocopy JTF_NUMBER_TABLE

116: , a19 out nocopy JTF_VARCHAR2_TABLE_500
117: , a20 out nocopy JTF_VARCHAR2_TABLE_500
118: , a21 out nocopy JTF_VARCHAR2_TABLE_500
119: , a22 out nocopy JTF_VARCHAR2_TABLE_500
120: , a23 out nocopy JTF_NUMBER_TABLE
121: , a24 out nocopy JTF_NUMBER_TABLE
122: , a25 out nocopy JTF_NUMBER_TABLE
123: , a26 out nocopy JTF_DATE_TABLE
124: , a27 out nocopy JTF_DATE_TABLE

Line 121: , a24 out nocopy JTF_NUMBER_TABLE

117: , a20 out nocopy JTF_VARCHAR2_TABLE_500
118: , a21 out nocopy JTF_VARCHAR2_TABLE_500
119: , a22 out nocopy JTF_VARCHAR2_TABLE_500
120: , a23 out nocopy JTF_NUMBER_TABLE
121: , a24 out nocopy JTF_NUMBER_TABLE
122: , a25 out nocopy JTF_NUMBER_TABLE
123: , a26 out nocopy JTF_DATE_TABLE
124: , a27 out nocopy JTF_DATE_TABLE
125: , a28 out nocopy JTF_NUMBER_TABLE

Line 122: , a25 out nocopy JTF_NUMBER_TABLE

118: , a21 out nocopy JTF_VARCHAR2_TABLE_500
119: , a22 out nocopy JTF_VARCHAR2_TABLE_500
120: , a23 out nocopy JTF_NUMBER_TABLE
121: , a24 out nocopy JTF_NUMBER_TABLE
122: , a25 out nocopy JTF_NUMBER_TABLE
123: , a26 out nocopy JTF_DATE_TABLE
124: , a27 out nocopy JTF_DATE_TABLE
125: , a28 out nocopy JTF_NUMBER_TABLE
126: ) as

Line 125: , a28 out nocopy JTF_NUMBER_TABLE

121: , a24 out nocopy JTF_NUMBER_TABLE
122: , a25 out nocopy JTF_NUMBER_TABLE
123: , a26 out nocopy JTF_DATE_TABLE
124: , a27 out nocopy JTF_DATE_TABLE
125: , a28 out nocopy JTF_NUMBER_TABLE
126: ) as
127: ddindx binary_integer; indx binary_integer;
128: begin
129: if t is null or t.count = 0 then

Line 130: a0 := JTF_NUMBER_TABLE();

126: ) as
127: ddindx binary_integer; indx binary_integer;
128: begin
129: if t is null or t.count = 0 then
130: a0 := JTF_NUMBER_TABLE();
131: a1 := JTF_VARCHAR2_TABLE_200();
132: a2 := JTF_NUMBER_TABLE();
133: a3 := JTF_VARCHAR2_TABLE_100();
134: a4 := JTF_NUMBER_TABLE();

Line 132: a2 := JTF_NUMBER_TABLE();

128: begin
129: if t is null or t.count = 0 then
130: a0 := JTF_NUMBER_TABLE();
131: a1 := JTF_VARCHAR2_TABLE_200();
132: a2 := JTF_NUMBER_TABLE();
133: a3 := JTF_VARCHAR2_TABLE_100();
134: a4 := JTF_NUMBER_TABLE();
135: a5 := JTF_DATE_TABLE();
136: a6 := JTF_NUMBER_TABLE();

Line 134: a4 := JTF_NUMBER_TABLE();

130: a0 := JTF_NUMBER_TABLE();
131: a1 := JTF_VARCHAR2_TABLE_200();
132: a2 := JTF_NUMBER_TABLE();
133: a3 := JTF_VARCHAR2_TABLE_100();
134: a4 := JTF_NUMBER_TABLE();
135: a5 := JTF_DATE_TABLE();
136: a6 := JTF_NUMBER_TABLE();
137: a7 := JTF_NUMBER_TABLE();
138: a8 := JTF_VARCHAR2_TABLE_500();

Line 136: a6 := JTF_NUMBER_TABLE();

132: a2 := JTF_NUMBER_TABLE();
133: a3 := JTF_VARCHAR2_TABLE_100();
134: a4 := JTF_NUMBER_TABLE();
135: a5 := JTF_DATE_TABLE();
136: a6 := JTF_NUMBER_TABLE();
137: a7 := JTF_NUMBER_TABLE();
138: a8 := JTF_VARCHAR2_TABLE_500();
139: a9 := JTF_VARCHAR2_TABLE_500();
140: a10 := JTF_VARCHAR2_TABLE_500();

Line 137: a7 := JTF_NUMBER_TABLE();

133: a3 := JTF_VARCHAR2_TABLE_100();
134: a4 := JTF_NUMBER_TABLE();
135: a5 := JTF_DATE_TABLE();
136: a6 := JTF_NUMBER_TABLE();
137: a7 := JTF_NUMBER_TABLE();
138: a8 := JTF_VARCHAR2_TABLE_500();
139: a9 := JTF_VARCHAR2_TABLE_500();
140: a10 := JTF_VARCHAR2_TABLE_500();
141: a11 := JTF_VARCHAR2_TABLE_500();

Line 153: a23 := JTF_NUMBER_TABLE();

149: a19 := JTF_VARCHAR2_TABLE_500();
150: a20 := JTF_VARCHAR2_TABLE_500();
151: a21 := JTF_VARCHAR2_TABLE_500();
152: a22 := JTF_VARCHAR2_TABLE_500();
153: a23 := JTF_NUMBER_TABLE();
154: a24 := JTF_NUMBER_TABLE();
155: a25 := JTF_NUMBER_TABLE();
156: a26 := JTF_DATE_TABLE();
157: a27 := JTF_DATE_TABLE();

Line 154: a24 := JTF_NUMBER_TABLE();

150: a20 := JTF_VARCHAR2_TABLE_500();
151: a21 := JTF_VARCHAR2_TABLE_500();
152: a22 := JTF_VARCHAR2_TABLE_500();
153: a23 := JTF_NUMBER_TABLE();
154: a24 := JTF_NUMBER_TABLE();
155: a25 := JTF_NUMBER_TABLE();
156: a26 := JTF_DATE_TABLE();
157: a27 := JTF_DATE_TABLE();
158: a28 := JTF_NUMBER_TABLE();

Line 155: a25 := JTF_NUMBER_TABLE();

151: a21 := JTF_VARCHAR2_TABLE_500();
152: a22 := JTF_VARCHAR2_TABLE_500();
153: a23 := JTF_NUMBER_TABLE();
154: a24 := JTF_NUMBER_TABLE();
155: a25 := JTF_NUMBER_TABLE();
156: a26 := JTF_DATE_TABLE();
157: a27 := JTF_DATE_TABLE();
158: a28 := JTF_NUMBER_TABLE();
159: else

Line 158: a28 := JTF_NUMBER_TABLE();

154: a24 := JTF_NUMBER_TABLE();
155: a25 := JTF_NUMBER_TABLE();
156: a26 := JTF_DATE_TABLE();
157: a27 := JTF_DATE_TABLE();
158: a28 := JTF_NUMBER_TABLE();
159: else
160: a0 := JTF_NUMBER_TABLE();
161: a1 := JTF_VARCHAR2_TABLE_200();
162: a2 := JTF_NUMBER_TABLE();

Line 160: a0 := JTF_NUMBER_TABLE();

156: a26 := JTF_DATE_TABLE();
157: a27 := JTF_DATE_TABLE();
158: a28 := JTF_NUMBER_TABLE();
159: else
160: a0 := JTF_NUMBER_TABLE();
161: a1 := JTF_VARCHAR2_TABLE_200();
162: a2 := JTF_NUMBER_TABLE();
163: a3 := JTF_VARCHAR2_TABLE_100();
164: a4 := JTF_NUMBER_TABLE();

Line 162: a2 := JTF_NUMBER_TABLE();

158: a28 := JTF_NUMBER_TABLE();
159: else
160: a0 := JTF_NUMBER_TABLE();
161: a1 := JTF_VARCHAR2_TABLE_200();
162: a2 := JTF_NUMBER_TABLE();
163: a3 := JTF_VARCHAR2_TABLE_100();
164: a4 := JTF_NUMBER_TABLE();
165: a5 := JTF_DATE_TABLE();
166: a6 := JTF_NUMBER_TABLE();

Line 164: a4 := JTF_NUMBER_TABLE();

160: a0 := JTF_NUMBER_TABLE();
161: a1 := JTF_VARCHAR2_TABLE_200();
162: a2 := JTF_NUMBER_TABLE();
163: a3 := JTF_VARCHAR2_TABLE_100();
164: a4 := JTF_NUMBER_TABLE();
165: a5 := JTF_DATE_TABLE();
166: a6 := JTF_NUMBER_TABLE();
167: a7 := JTF_NUMBER_TABLE();
168: a8 := JTF_VARCHAR2_TABLE_500();

Line 166: a6 := JTF_NUMBER_TABLE();

162: a2 := JTF_NUMBER_TABLE();
163: a3 := JTF_VARCHAR2_TABLE_100();
164: a4 := JTF_NUMBER_TABLE();
165: a5 := JTF_DATE_TABLE();
166: a6 := JTF_NUMBER_TABLE();
167: a7 := JTF_NUMBER_TABLE();
168: a8 := JTF_VARCHAR2_TABLE_500();
169: a9 := JTF_VARCHAR2_TABLE_500();
170: a10 := JTF_VARCHAR2_TABLE_500();

Line 167: a7 := JTF_NUMBER_TABLE();

163: a3 := JTF_VARCHAR2_TABLE_100();
164: a4 := JTF_NUMBER_TABLE();
165: a5 := JTF_DATE_TABLE();
166: a6 := JTF_NUMBER_TABLE();
167: a7 := JTF_NUMBER_TABLE();
168: a8 := JTF_VARCHAR2_TABLE_500();
169: a9 := JTF_VARCHAR2_TABLE_500();
170: a10 := JTF_VARCHAR2_TABLE_500();
171: a11 := JTF_VARCHAR2_TABLE_500();

Line 183: a23 := JTF_NUMBER_TABLE();

179: a19 := JTF_VARCHAR2_TABLE_500();
180: a20 := JTF_VARCHAR2_TABLE_500();
181: a21 := JTF_VARCHAR2_TABLE_500();
182: a22 := JTF_VARCHAR2_TABLE_500();
183: a23 := JTF_NUMBER_TABLE();
184: a24 := JTF_NUMBER_TABLE();
185: a25 := JTF_NUMBER_TABLE();
186: a26 := JTF_DATE_TABLE();
187: a27 := JTF_DATE_TABLE();

Line 184: a24 := JTF_NUMBER_TABLE();

180: a20 := JTF_VARCHAR2_TABLE_500();
181: a21 := JTF_VARCHAR2_TABLE_500();
182: a22 := JTF_VARCHAR2_TABLE_500();
183: a23 := JTF_NUMBER_TABLE();
184: a24 := JTF_NUMBER_TABLE();
185: a25 := JTF_NUMBER_TABLE();
186: a26 := JTF_DATE_TABLE();
187: a27 := JTF_DATE_TABLE();
188: a28 := JTF_NUMBER_TABLE();

Line 185: a25 := JTF_NUMBER_TABLE();

181: a21 := JTF_VARCHAR2_TABLE_500();
182: a22 := JTF_VARCHAR2_TABLE_500();
183: a23 := JTF_NUMBER_TABLE();
184: a24 := JTF_NUMBER_TABLE();
185: a25 := JTF_NUMBER_TABLE();
186: a26 := JTF_DATE_TABLE();
187: a27 := JTF_DATE_TABLE();
188: a28 := JTF_NUMBER_TABLE();
189: if t.count > 0 then

Line 188: a28 := JTF_NUMBER_TABLE();

184: a24 := JTF_NUMBER_TABLE();
185: a25 := JTF_NUMBER_TABLE();
186: a26 := JTF_DATE_TABLE();
187: a27 := JTF_DATE_TABLE();
188: a28 := JTF_NUMBER_TABLE();
189: if t.count > 0 then
190: a0.extend(t.count);
191: a1.extend(t.count);
192: a2.extend(t.count);

Line 261: procedure rosetta_table_copy_in_p5(t out nocopy okl_srs_pvt.srsv_tbl_type, a0 JTF_NUMBER_TABLE

257: end if;
258: end if;
259: end rosetta_table_copy_out_p2;
260:
261: procedure rosetta_table_copy_in_p5(t out nocopy okl_srs_pvt.srsv_tbl_type, a0 JTF_NUMBER_TABLE
262: , a1 JTF_VARCHAR2_TABLE_200
263: , a2 JTF_NUMBER_TABLE
264: , a3 JTF_VARCHAR2_TABLE_100
265: , a4 JTF_NUMBER_TABLE

Line 263: , a2 JTF_NUMBER_TABLE

259: end rosetta_table_copy_out_p2;
260:
261: procedure rosetta_table_copy_in_p5(t out nocopy okl_srs_pvt.srsv_tbl_type, a0 JTF_NUMBER_TABLE
262: , a1 JTF_VARCHAR2_TABLE_200
263: , a2 JTF_NUMBER_TABLE
264: , a3 JTF_VARCHAR2_TABLE_100
265: , a4 JTF_NUMBER_TABLE
266: , a5 JTF_DATE_TABLE
267: , a6 JTF_NUMBER_TABLE

Line 265: , a4 JTF_NUMBER_TABLE

261: procedure rosetta_table_copy_in_p5(t out nocopy okl_srs_pvt.srsv_tbl_type, a0 JTF_NUMBER_TABLE
262: , a1 JTF_VARCHAR2_TABLE_200
263: , a2 JTF_NUMBER_TABLE
264: , a3 JTF_VARCHAR2_TABLE_100
265: , a4 JTF_NUMBER_TABLE
266: , a5 JTF_DATE_TABLE
267: , a6 JTF_NUMBER_TABLE
268: , a7 JTF_NUMBER_TABLE
269: , a8 JTF_VARCHAR2_TABLE_500

Line 267: , a6 JTF_NUMBER_TABLE

263: , a2 JTF_NUMBER_TABLE
264: , a3 JTF_VARCHAR2_TABLE_100
265: , a4 JTF_NUMBER_TABLE
266: , a5 JTF_DATE_TABLE
267: , a6 JTF_NUMBER_TABLE
268: , a7 JTF_NUMBER_TABLE
269: , a8 JTF_VARCHAR2_TABLE_500
270: , a9 JTF_VARCHAR2_TABLE_500
271: , a10 JTF_VARCHAR2_TABLE_500

Line 268: , a7 JTF_NUMBER_TABLE

264: , a3 JTF_VARCHAR2_TABLE_100
265: , a4 JTF_NUMBER_TABLE
266: , a5 JTF_DATE_TABLE
267: , a6 JTF_NUMBER_TABLE
268: , a7 JTF_NUMBER_TABLE
269: , a8 JTF_VARCHAR2_TABLE_500
270: , a9 JTF_VARCHAR2_TABLE_500
271: , a10 JTF_VARCHAR2_TABLE_500
272: , a11 JTF_VARCHAR2_TABLE_500

Line 284: , a23 JTF_NUMBER_TABLE

280: , a19 JTF_VARCHAR2_TABLE_500
281: , a20 JTF_VARCHAR2_TABLE_500
282: , a21 JTF_VARCHAR2_TABLE_500
283: , a22 JTF_VARCHAR2_TABLE_500
284: , a23 JTF_NUMBER_TABLE
285: , a24 JTF_NUMBER_TABLE
286: , a25 JTF_NUMBER_TABLE
287: , a26 JTF_DATE_TABLE
288: , a27 JTF_DATE_TABLE

Line 285: , a24 JTF_NUMBER_TABLE

281: , a20 JTF_VARCHAR2_TABLE_500
282: , a21 JTF_VARCHAR2_TABLE_500
283: , a22 JTF_VARCHAR2_TABLE_500
284: , a23 JTF_NUMBER_TABLE
285: , a24 JTF_NUMBER_TABLE
286: , a25 JTF_NUMBER_TABLE
287: , a26 JTF_DATE_TABLE
288: , a27 JTF_DATE_TABLE
289: , a28 JTF_NUMBER_TABLE

Line 286: , a25 JTF_NUMBER_TABLE

282: , a21 JTF_VARCHAR2_TABLE_500
283: , a22 JTF_VARCHAR2_TABLE_500
284: , a23 JTF_NUMBER_TABLE
285: , a24 JTF_NUMBER_TABLE
286: , a25 JTF_NUMBER_TABLE
287: , a26 JTF_DATE_TABLE
288: , a27 JTF_DATE_TABLE
289: , a28 JTF_NUMBER_TABLE
290: ) as

Line 289: , a28 JTF_NUMBER_TABLE

285: , a24 JTF_NUMBER_TABLE
286: , a25 JTF_NUMBER_TABLE
287: , a26 JTF_DATE_TABLE
288: , a27 JTF_DATE_TABLE
289: , a28 JTF_NUMBER_TABLE
290: ) as
291: ddindx binary_integer; indx binary_integer;
292: begin
293: if a0 is not null and a0.count > 0 then

Line 336: procedure rosetta_table_copy_out_p5(t okl_srs_pvt.srsv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

332: end loop;
333: end if;
334: end if;
335: end rosetta_table_copy_in_p5;
336: procedure rosetta_table_copy_out_p5(t okl_srs_pvt.srsv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
337: , a1 out nocopy JTF_VARCHAR2_TABLE_200
338: , a2 out nocopy JTF_NUMBER_TABLE
339: , a3 out nocopy JTF_VARCHAR2_TABLE_100
340: , a4 out nocopy JTF_NUMBER_TABLE

Line 338: , a2 out nocopy JTF_NUMBER_TABLE

334: end if;
335: end rosetta_table_copy_in_p5;
336: procedure rosetta_table_copy_out_p5(t okl_srs_pvt.srsv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
337: , a1 out nocopy JTF_VARCHAR2_TABLE_200
338: , a2 out nocopy JTF_NUMBER_TABLE
339: , a3 out nocopy JTF_VARCHAR2_TABLE_100
340: , a4 out nocopy JTF_NUMBER_TABLE
341: , a5 out nocopy JTF_DATE_TABLE
342: , a6 out nocopy JTF_NUMBER_TABLE

Line 340: , a4 out nocopy JTF_NUMBER_TABLE

336: procedure rosetta_table_copy_out_p5(t okl_srs_pvt.srsv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
337: , a1 out nocopy JTF_VARCHAR2_TABLE_200
338: , a2 out nocopy JTF_NUMBER_TABLE
339: , a3 out nocopy JTF_VARCHAR2_TABLE_100
340: , a4 out nocopy JTF_NUMBER_TABLE
341: , a5 out nocopy JTF_DATE_TABLE
342: , a6 out nocopy JTF_NUMBER_TABLE
343: , a7 out nocopy JTF_NUMBER_TABLE
344: , a8 out nocopy JTF_VARCHAR2_TABLE_500

Line 342: , a6 out nocopy JTF_NUMBER_TABLE

338: , a2 out nocopy JTF_NUMBER_TABLE
339: , a3 out nocopy JTF_VARCHAR2_TABLE_100
340: , a4 out nocopy JTF_NUMBER_TABLE
341: , a5 out nocopy JTF_DATE_TABLE
342: , a6 out nocopy JTF_NUMBER_TABLE
343: , a7 out nocopy JTF_NUMBER_TABLE
344: , a8 out nocopy JTF_VARCHAR2_TABLE_500
345: , a9 out nocopy JTF_VARCHAR2_TABLE_500
346: , a10 out nocopy JTF_VARCHAR2_TABLE_500

Line 343: , a7 out nocopy JTF_NUMBER_TABLE

339: , a3 out nocopy JTF_VARCHAR2_TABLE_100
340: , a4 out nocopy JTF_NUMBER_TABLE
341: , a5 out nocopy JTF_DATE_TABLE
342: , a6 out nocopy JTF_NUMBER_TABLE
343: , a7 out nocopy JTF_NUMBER_TABLE
344: , a8 out nocopy JTF_VARCHAR2_TABLE_500
345: , a9 out nocopy JTF_VARCHAR2_TABLE_500
346: , a10 out nocopy JTF_VARCHAR2_TABLE_500
347: , a11 out nocopy JTF_VARCHAR2_TABLE_500

Line 359: , a23 out nocopy JTF_NUMBER_TABLE

355: , a19 out nocopy JTF_VARCHAR2_TABLE_500
356: , a20 out nocopy JTF_VARCHAR2_TABLE_500
357: , a21 out nocopy JTF_VARCHAR2_TABLE_500
358: , a22 out nocopy JTF_VARCHAR2_TABLE_500
359: , a23 out nocopy JTF_NUMBER_TABLE
360: , a24 out nocopy JTF_NUMBER_TABLE
361: , a25 out nocopy JTF_NUMBER_TABLE
362: , a26 out nocopy JTF_DATE_TABLE
363: , a27 out nocopy JTF_DATE_TABLE

Line 360: , a24 out nocopy JTF_NUMBER_TABLE

356: , a20 out nocopy JTF_VARCHAR2_TABLE_500
357: , a21 out nocopy JTF_VARCHAR2_TABLE_500
358: , a22 out nocopy JTF_VARCHAR2_TABLE_500
359: , a23 out nocopy JTF_NUMBER_TABLE
360: , a24 out nocopy JTF_NUMBER_TABLE
361: , a25 out nocopy JTF_NUMBER_TABLE
362: , a26 out nocopy JTF_DATE_TABLE
363: , a27 out nocopy JTF_DATE_TABLE
364: , a28 out nocopy JTF_NUMBER_TABLE

Line 361: , a25 out nocopy JTF_NUMBER_TABLE

357: , a21 out nocopy JTF_VARCHAR2_TABLE_500
358: , a22 out nocopy JTF_VARCHAR2_TABLE_500
359: , a23 out nocopy JTF_NUMBER_TABLE
360: , a24 out nocopy JTF_NUMBER_TABLE
361: , a25 out nocopy JTF_NUMBER_TABLE
362: , a26 out nocopy JTF_DATE_TABLE
363: , a27 out nocopy JTF_DATE_TABLE
364: , a28 out nocopy JTF_NUMBER_TABLE
365: ) as

Line 364: , a28 out nocopy JTF_NUMBER_TABLE

360: , a24 out nocopy JTF_NUMBER_TABLE
361: , a25 out nocopy JTF_NUMBER_TABLE
362: , a26 out nocopy JTF_DATE_TABLE
363: , a27 out nocopy JTF_DATE_TABLE
364: , a28 out nocopy JTF_NUMBER_TABLE
365: ) as
366: ddindx binary_integer; indx binary_integer;
367: begin
368: if t is null or t.count = 0 then

Line 369: a0 := JTF_NUMBER_TABLE();

365: ) as
366: ddindx binary_integer; indx binary_integer;
367: begin
368: if t is null or t.count = 0 then
369: a0 := JTF_NUMBER_TABLE();
370: a1 := JTF_VARCHAR2_TABLE_200();
371: a2 := JTF_NUMBER_TABLE();
372: a3 := JTF_VARCHAR2_TABLE_100();
373: a4 := JTF_NUMBER_TABLE();

Line 371: a2 := JTF_NUMBER_TABLE();

367: begin
368: if t is null or t.count = 0 then
369: a0 := JTF_NUMBER_TABLE();
370: a1 := JTF_VARCHAR2_TABLE_200();
371: a2 := JTF_NUMBER_TABLE();
372: a3 := JTF_VARCHAR2_TABLE_100();
373: a4 := JTF_NUMBER_TABLE();
374: a5 := JTF_DATE_TABLE();
375: a6 := JTF_NUMBER_TABLE();

Line 373: a4 := JTF_NUMBER_TABLE();

369: a0 := JTF_NUMBER_TABLE();
370: a1 := JTF_VARCHAR2_TABLE_200();
371: a2 := JTF_NUMBER_TABLE();
372: a3 := JTF_VARCHAR2_TABLE_100();
373: a4 := JTF_NUMBER_TABLE();
374: a5 := JTF_DATE_TABLE();
375: a6 := JTF_NUMBER_TABLE();
376: a7 := JTF_NUMBER_TABLE();
377: a8 := JTF_VARCHAR2_TABLE_500();

Line 375: a6 := JTF_NUMBER_TABLE();

371: a2 := JTF_NUMBER_TABLE();
372: a3 := JTF_VARCHAR2_TABLE_100();
373: a4 := JTF_NUMBER_TABLE();
374: a5 := JTF_DATE_TABLE();
375: a6 := JTF_NUMBER_TABLE();
376: a7 := JTF_NUMBER_TABLE();
377: a8 := JTF_VARCHAR2_TABLE_500();
378: a9 := JTF_VARCHAR2_TABLE_500();
379: a10 := JTF_VARCHAR2_TABLE_500();

Line 376: a7 := JTF_NUMBER_TABLE();

372: a3 := JTF_VARCHAR2_TABLE_100();
373: a4 := JTF_NUMBER_TABLE();
374: a5 := JTF_DATE_TABLE();
375: a6 := JTF_NUMBER_TABLE();
376: a7 := JTF_NUMBER_TABLE();
377: a8 := JTF_VARCHAR2_TABLE_500();
378: a9 := JTF_VARCHAR2_TABLE_500();
379: a10 := JTF_VARCHAR2_TABLE_500();
380: a11 := JTF_VARCHAR2_TABLE_500();

Line 392: a23 := JTF_NUMBER_TABLE();

388: a19 := JTF_VARCHAR2_TABLE_500();
389: a20 := JTF_VARCHAR2_TABLE_500();
390: a21 := JTF_VARCHAR2_TABLE_500();
391: a22 := JTF_VARCHAR2_TABLE_500();
392: a23 := JTF_NUMBER_TABLE();
393: a24 := JTF_NUMBER_TABLE();
394: a25 := JTF_NUMBER_TABLE();
395: a26 := JTF_DATE_TABLE();
396: a27 := JTF_DATE_TABLE();

Line 393: a24 := JTF_NUMBER_TABLE();

389: a20 := JTF_VARCHAR2_TABLE_500();
390: a21 := JTF_VARCHAR2_TABLE_500();
391: a22 := JTF_VARCHAR2_TABLE_500();
392: a23 := JTF_NUMBER_TABLE();
393: a24 := JTF_NUMBER_TABLE();
394: a25 := JTF_NUMBER_TABLE();
395: a26 := JTF_DATE_TABLE();
396: a27 := JTF_DATE_TABLE();
397: a28 := JTF_NUMBER_TABLE();

Line 394: a25 := JTF_NUMBER_TABLE();

390: a21 := JTF_VARCHAR2_TABLE_500();
391: a22 := JTF_VARCHAR2_TABLE_500();
392: a23 := JTF_NUMBER_TABLE();
393: a24 := JTF_NUMBER_TABLE();
394: a25 := JTF_NUMBER_TABLE();
395: a26 := JTF_DATE_TABLE();
396: a27 := JTF_DATE_TABLE();
397: a28 := JTF_NUMBER_TABLE();
398: else

Line 397: a28 := JTF_NUMBER_TABLE();

393: a24 := JTF_NUMBER_TABLE();
394: a25 := JTF_NUMBER_TABLE();
395: a26 := JTF_DATE_TABLE();
396: a27 := JTF_DATE_TABLE();
397: a28 := JTF_NUMBER_TABLE();
398: else
399: a0 := JTF_NUMBER_TABLE();
400: a1 := JTF_VARCHAR2_TABLE_200();
401: a2 := JTF_NUMBER_TABLE();

Line 399: a0 := JTF_NUMBER_TABLE();

395: a26 := JTF_DATE_TABLE();
396: a27 := JTF_DATE_TABLE();
397: a28 := JTF_NUMBER_TABLE();
398: else
399: a0 := JTF_NUMBER_TABLE();
400: a1 := JTF_VARCHAR2_TABLE_200();
401: a2 := JTF_NUMBER_TABLE();
402: a3 := JTF_VARCHAR2_TABLE_100();
403: a4 := JTF_NUMBER_TABLE();

Line 401: a2 := JTF_NUMBER_TABLE();

397: a28 := JTF_NUMBER_TABLE();
398: else
399: a0 := JTF_NUMBER_TABLE();
400: a1 := JTF_VARCHAR2_TABLE_200();
401: a2 := JTF_NUMBER_TABLE();
402: a3 := JTF_VARCHAR2_TABLE_100();
403: a4 := JTF_NUMBER_TABLE();
404: a5 := JTF_DATE_TABLE();
405: a6 := JTF_NUMBER_TABLE();

Line 403: a4 := JTF_NUMBER_TABLE();

399: a0 := JTF_NUMBER_TABLE();
400: a1 := JTF_VARCHAR2_TABLE_200();
401: a2 := JTF_NUMBER_TABLE();
402: a3 := JTF_VARCHAR2_TABLE_100();
403: a4 := JTF_NUMBER_TABLE();
404: a5 := JTF_DATE_TABLE();
405: a6 := JTF_NUMBER_TABLE();
406: a7 := JTF_NUMBER_TABLE();
407: a8 := JTF_VARCHAR2_TABLE_500();

Line 405: a6 := JTF_NUMBER_TABLE();

401: a2 := JTF_NUMBER_TABLE();
402: a3 := JTF_VARCHAR2_TABLE_100();
403: a4 := JTF_NUMBER_TABLE();
404: a5 := JTF_DATE_TABLE();
405: a6 := JTF_NUMBER_TABLE();
406: a7 := JTF_NUMBER_TABLE();
407: a8 := JTF_VARCHAR2_TABLE_500();
408: a9 := JTF_VARCHAR2_TABLE_500();
409: a10 := JTF_VARCHAR2_TABLE_500();

Line 406: a7 := JTF_NUMBER_TABLE();

402: a3 := JTF_VARCHAR2_TABLE_100();
403: a4 := JTF_NUMBER_TABLE();
404: a5 := JTF_DATE_TABLE();
405: a6 := JTF_NUMBER_TABLE();
406: a7 := JTF_NUMBER_TABLE();
407: a8 := JTF_VARCHAR2_TABLE_500();
408: a9 := JTF_VARCHAR2_TABLE_500();
409: a10 := JTF_VARCHAR2_TABLE_500();
410: a11 := JTF_VARCHAR2_TABLE_500();

Line 422: a23 := JTF_NUMBER_TABLE();

418: a19 := JTF_VARCHAR2_TABLE_500();
419: a20 := JTF_VARCHAR2_TABLE_500();
420: a21 := JTF_VARCHAR2_TABLE_500();
421: a22 := JTF_VARCHAR2_TABLE_500();
422: a23 := JTF_NUMBER_TABLE();
423: a24 := JTF_NUMBER_TABLE();
424: a25 := JTF_NUMBER_TABLE();
425: a26 := JTF_DATE_TABLE();
426: a27 := JTF_DATE_TABLE();

Line 423: a24 := JTF_NUMBER_TABLE();

419: a20 := JTF_VARCHAR2_TABLE_500();
420: a21 := JTF_VARCHAR2_TABLE_500();
421: a22 := JTF_VARCHAR2_TABLE_500();
422: a23 := JTF_NUMBER_TABLE();
423: a24 := JTF_NUMBER_TABLE();
424: a25 := JTF_NUMBER_TABLE();
425: a26 := JTF_DATE_TABLE();
426: a27 := JTF_DATE_TABLE();
427: a28 := JTF_NUMBER_TABLE();

Line 424: a25 := JTF_NUMBER_TABLE();

420: a21 := JTF_VARCHAR2_TABLE_500();
421: a22 := JTF_VARCHAR2_TABLE_500();
422: a23 := JTF_NUMBER_TABLE();
423: a24 := JTF_NUMBER_TABLE();
424: a25 := JTF_NUMBER_TABLE();
425: a26 := JTF_DATE_TABLE();
426: a27 := JTF_DATE_TABLE();
427: a28 := JTF_NUMBER_TABLE();
428: if t.count > 0 then

Line 427: a28 := JTF_NUMBER_TABLE();

423: a24 := JTF_NUMBER_TABLE();
424: a25 := JTF_NUMBER_TABLE();
425: a26 := JTF_DATE_TABLE();
426: a27 := JTF_DATE_TABLE();
427: a28 := JTF_NUMBER_TABLE();
428: if t.count > 0 then
429: a0.extend(t.count);
430: a1.extend(t.count);
431: a2.extend(t.count);

Line 660: , p5_a0 JTF_NUMBER_TABLE

656: , p_init_msg_list VARCHAR2
657: , x_return_status out nocopy VARCHAR2
658: , x_msg_count out nocopy NUMBER
659: , x_msg_data out nocopy VARCHAR2
660: , p5_a0 JTF_NUMBER_TABLE
661: , p5_a1 JTF_VARCHAR2_TABLE_200
662: , p5_a2 JTF_NUMBER_TABLE
663: , p5_a3 JTF_VARCHAR2_TABLE_100
664: , p5_a4 JTF_NUMBER_TABLE

Line 662: , p5_a2 JTF_NUMBER_TABLE

658: , x_msg_count out nocopy NUMBER
659: , x_msg_data out nocopy VARCHAR2
660: , p5_a0 JTF_NUMBER_TABLE
661: , p5_a1 JTF_VARCHAR2_TABLE_200
662: , p5_a2 JTF_NUMBER_TABLE
663: , p5_a3 JTF_VARCHAR2_TABLE_100
664: , p5_a4 JTF_NUMBER_TABLE
665: , p5_a5 JTF_DATE_TABLE
666: , p5_a6 JTF_NUMBER_TABLE

Line 664: , p5_a4 JTF_NUMBER_TABLE

660: , p5_a0 JTF_NUMBER_TABLE
661: , p5_a1 JTF_VARCHAR2_TABLE_200
662: , p5_a2 JTF_NUMBER_TABLE
663: , p5_a3 JTF_VARCHAR2_TABLE_100
664: , p5_a4 JTF_NUMBER_TABLE
665: , p5_a5 JTF_DATE_TABLE
666: , p5_a6 JTF_NUMBER_TABLE
667: , p5_a7 JTF_NUMBER_TABLE
668: , p5_a8 JTF_VARCHAR2_TABLE_500

Line 666: , p5_a6 JTF_NUMBER_TABLE

662: , p5_a2 JTF_NUMBER_TABLE
663: , p5_a3 JTF_VARCHAR2_TABLE_100
664: , p5_a4 JTF_NUMBER_TABLE
665: , p5_a5 JTF_DATE_TABLE
666: , p5_a6 JTF_NUMBER_TABLE
667: , p5_a7 JTF_NUMBER_TABLE
668: , p5_a8 JTF_VARCHAR2_TABLE_500
669: , p5_a9 JTF_VARCHAR2_TABLE_500
670: , p5_a10 JTF_VARCHAR2_TABLE_500

Line 667: , p5_a7 JTF_NUMBER_TABLE

663: , p5_a3 JTF_VARCHAR2_TABLE_100
664: , p5_a4 JTF_NUMBER_TABLE
665: , p5_a5 JTF_DATE_TABLE
666: , p5_a6 JTF_NUMBER_TABLE
667: , p5_a7 JTF_NUMBER_TABLE
668: , p5_a8 JTF_VARCHAR2_TABLE_500
669: , p5_a9 JTF_VARCHAR2_TABLE_500
670: , p5_a10 JTF_VARCHAR2_TABLE_500
671: , p5_a11 JTF_VARCHAR2_TABLE_500

Line 683: , p5_a23 JTF_NUMBER_TABLE

679: , p5_a19 JTF_VARCHAR2_TABLE_500
680: , p5_a20 JTF_VARCHAR2_TABLE_500
681: , p5_a21 JTF_VARCHAR2_TABLE_500
682: , p5_a22 JTF_VARCHAR2_TABLE_500
683: , p5_a23 JTF_NUMBER_TABLE
684: , p5_a24 JTF_NUMBER_TABLE
685: , p5_a25 JTF_NUMBER_TABLE
686: , p5_a26 JTF_DATE_TABLE
687: , p5_a27 JTF_DATE_TABLE

Line 684: , p5_a24 JTF_NUMBER_TABLE

680: , p5_a20 JTF_VARCHAR2_TABLE_500
681: , p5_a21 JTF_VARCHAR2_TABLE_500
682: , p5_a22 JTF_VARCHAR2_TABLE_500
683: , p5_a23 JTF_NUMBER_TABLE
684: , p5_a24 JTF_NUMBER_TABLE
685: , p5_a25 JTF_NUMBER_TABLE
686: , p5_a26 JTF_DATE_TABLE
687: , p5_a27 JTF_DATE_TABLE
688: , p5_a28 JTF_NUMBER_TABLE

Line 685: , p5_a25 JTF_NUMBER_TABLE

681: , p5_a21 JTF_VARCHAR2_TABLE_500
682: , p5_a22 JTF_VARCHAR2_TABLE_500
683: , p5_a23 JTF_NUMBER_TABLE
684: , p5_a24 JTF_NUMBER_TABLE
685: , p5_a25 JTF_NUMBER_TABLE
686: , p5_a26 JTF_DATE_TABLE
687: , p5_a27 JTF_DATE_TABLE
688: , p5_a28 JTF_NUMBER_TABLE
689: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 688: , p5_a28 JTF_NUMBER_TABLE

684: , p5_a24 JTF_NUMBER_TABLE
685: , p5_a25 JTF_NUMBER_TABLE
686: , p5_a26 JTF_DATE_TABLE
687: , p5_a27 JTF_DATE_TABLE
688: , p5_a28 JTF_NUMBER_TABLE
689: , p6_a0 out nocopy JTF_NUMBER_TABLE
690: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
691: , p6_a2 out nocopy JTF_NUMBER_TABLE
692: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

Line 689: , p6_a0 out nocopy JTF_NUMBER_TABLE

685: , p5_a25 JTF_NUMBER_TABLE
686: , p5_a26 JTF_DATE_TABLE
687: , p5_a27 JTF_DATE_TABLE
688: , p5_a28 JTF_NUMBER_TABLE
689: , p6_a0 out nocopy JTF_NUMBER_TABLE
690: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
691: , p6_a2 out nocopy JTF_NUMBER_TABLE
692: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
693: , p6_a4 out nocopy JTF_NUMBER_TABLE

Line 691: , p6_a2 out nocopy JTF_NUMBER_TABLE

687: , p5_a27 JTF_DATE_TABLE
688: , p5_a28 JTF_NUMBER_TABLE
689: , p6_a0 out nocopy JTF_NUMBER_TABLE
690: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
691: , p6_a2 out nocopy JTF_NUMBER_TABLE
692: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
693: , p6_a4 out nocopy JTF_NUMBER_TABLE
694: , p6_a5 out nocopy JTF_DATE_TABLE
695: , p6_a6 out nocopy JTF_NUMBER_TABLE

Line 693: , p6_a4 out nocopy JTF_NUMBER_TABLE

689: , p6_a0 out nocopy JTF_NUMBER_TABLE
690: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
691: , p6_a2 out nocopy JTF_NUMBER_TABLE
692: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
693: , p6_a4 out nocopy JTF_NUMBER_TABLE
694: , p6_a5 out nocopy JTF_DATE_TABLE
695: , p6_a6 out nocopy JTF_NUMBER_TABLE
696: , p6_a7 out nocopy JTF_NUMBER_TABLE
697: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500

Line 695: , p6_a6 out nocopy JTF_NUMBER_TABLE

691: , p6_a2 out nocopy JTF_NUMBER_TABLE
692: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
693: , p6_a4 out nocopy JTF_NUMBER_TABLE
694: , p6_a5 out nocopy JTF_DATE_TABLE
695: , p6_a6 out nocopy JTF_NUMBER_TABLE
696: , p6_a7 out nocopy JTF_NUMBER_TABLE
697: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500
698: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_500
699: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_500

Line 696: , p6_a7 out nocopy JTF_NUMBER_TABLE

692: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
693: , p6_a4 out nocopy JTF_NUMBER_TABLE
694: , p6_a5 out nocopy JTF_DATE_TABLE
695: , p6_a6 out nocopy JTF_NUMBER_TABLE
696: , p6_a7 out nocopy JTF_NUMBER_TABLE
697: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500
698: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_500
699: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_500
700: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500

Line 712: , p6_a23 out nocopy JTF_NUMBER_TABLE

708: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
709: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
710: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
711: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
712: , p6_a23 out nocopy JTF_NUMBER_TABLE
713: , p6_a24 out nocopy JTF_NUMBER_TABLE
714: , p6_a25 out nocopy JTF_NUMBER_TABLE
715: , p6_a26 out nocopy JTF_DATE_TABLE
716: , p6_a27 out nocopy JTF_DATE_TABLE

Line 713: , p6_a24 out nocopy JTF_NUMBER_TABLE

709: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
710: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
711: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
712: , p6_a23 out nocopy JTF_NUMBER_TABLE
713: , p6_a24 out nocopy JTF_NUMBER_TABLE
714: , p6_a25 out nocopy JTF_NUMBER_TABLE
715: , p6_a26 out nocopy JTF_DATE_TABLE
716: , p6_a27 out nocopy JTF_DATE_TABLE
717: , p6_a28 out nocopy JTF_NUMBER_TABLE

Line 714: , p6_a25 out nocopy JTF_NUMBER_TABLE

710: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
711: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
712: , p6_a23 out nocopy JTF_NUMBER_TABLE
713: , p6_a24 out nocopy JTF_NUMBER_TABLE
714: , p6_a25 out nocopy JTF_NUMBER_TABLE
715: , p6_a26 out nocopy JTF_DATE_TABLE
716: , p6_a27 out nocopy JTF_DATE_TABLE
717: , p6_a28 out nocopy JTF_NUMBER_TABLE
718: )

Line 717: , p6_a28 out nocopy JTF_NUMBER_TABLE

713: , p6_a24 out nocopy JTF_NUMBER_TABLE
714: , p6_a25 out nocopy JTF_NUMBER_TABLE
715: , p6_a26 out nocopy JTF_DATE_TABLE
716: , p6_a27 out nocopy JTF_DATE_TABLE
717: , p6_a28 out nocopy JTF_NUMBER_TABLE
718: )
719:
720: as
721: ddp_srsv_tbl okl_srs_pvt.srsv_tbl_type;

Line 910: , p5_a0 JTF_NUMBER_TABLE

906: , p_init_msg_list VARCHAR2
907: , x_return_status out nocopy VARCHAR2
908: , x_msg_count out nocopy NUMBER
909: , x_msg_data out nocopy VARCHAR2
910: , p5_a0 JTF_NUMBER_TABLE
911: , p5_a1 JTF_VARCHAR2_TABLE_200
912: , p5_a2 JTF_NUMBER_TABLE
913: , p5_a3 JTF_VARCHAR2_TABLE_100
914: , p5_a4 JTF_NUMBER_TABLE

Line 912: , p5_a2 JTF_NUMBER_TABLE

908: , x_msg_count out nocopy NUMBER
909: , x_msg_data out nocopy VARCHAR2
910: , p5_a0 JTF_NUMBER_TABLE
911: , p5_a1 JTF_VARCHAR2_TABLE_200
912: , p5_a2 JTF_NUMBER_TABLE
913: , p5_a3 JTF_VARCHAR2_TABLE_100
914: , p5_a4 JTF_NUMBER_TABLE
915: , p5_a5 JTF_DATE_TABLE
916: , p5_a6 JTF_NUMBER_TABLE

Line 914: , p5_a4 JTF_NUMBER_TABLE

910: , p5_a0 JTF_NUMBER_TABLE
911: , p5_a1 JTF_VARCHAR2_TABLE_200
912: , p5_a2 JTF_NUMBER_TABLE
913: , p5_a3 JTF_VARCHAR2_TABLE_100
914: , p5_a4 JTF_NUMBER_TABLE
915: , p5_a5 JTF_DATE_TABLE
916: , p5_a6 JTF_NUMBER_TABLE
917: , p5_a7 JTF_NUMBER_TABLE
918: , p5_a8 JTF_VARCHAR2_TABLE_500

Line 916: , p5_a6 JTF_NUMBER_TABLE

912: , p5_a2 JTF_NUMBER_TABLE
913: , p5_a3 JTF_VARCHAR2_TABLE_100
914: , p5_a4 JTF_NUMBER_TABLE
915: , p5_a5 JTF_DATE_TABLE
916: , p5_a6 JTF_NUMBER_TABLE
917: , p5_a7 JTF_NUMBER_TABLE
918: , p5_a8 JTF_VARCHAR2_TABLE_500
919: , p5_a9 JTF_VARCHAR2_TABLE_500
920: , p5_a10 JTF_VARCHAR2_TABLE_500

Line 917: , p5_a7 JTF_NUMBER_TABLE

913: , p5_a3 JTF_VARCHAR2_TABLE_100
914: , p5_a4 JTF_NUMBER_TABLE
915: , p5_a5 JTF_DATE_TABLE
916: , p5_a6 JTF_NUMBER_TABLE
917: , p5_a7 JTF_NUMBER_TABLE
918: , p5_a8 JTF_VARCHAR2_TABLE_500
919: , p5_a9 JTF_VARCHAR2_TABLE_500
920: , p5_a10 JTF_VARCHAR2_TABLE_500
921: , p5_a11 JTF_VARCHAR2_TABLE_500

Line 933: , p5_a23 JTF_NUMBER_TABLE

929: , p5_a19 JTF_VARCHAR2_TABLE_500
930: , p5_a20 JTF_VARCHAR2_TABLE_500
931: , p5_a21 JTF_VARCHAR2_TABLE_500
932: , p5_a22 JTF_VARCHAR2_TABLE_500
933: , p5_a23 JTF_NUMBER_TABLE
934: , p5_a24 JTF_NUMBER_TABLE
935: , p5_a25 JTF_NUMBER_TABLE
936: , p5_a26 JTF_DATE_TABLE
937: , p5_a27 JTF_DATE_TABLE

Line 934: , p5_a24 JTF_NUMBER_TABLE

930: , p5_a20 JTF_VARCHAR2_TABLE_500
931: , p5_a21 JTF_VARCHAR2_TABLE_500
932: , p5_a22 JTF_VARCHAR2_TABLE_500
933: , p5_a23 JTF_NUMBER_TABLE
934: , p5_a24 JTF_NUMBER_TABLE
935: , p5_a25 JTF_NUMBER_TABLE
936: , p5_a26 JTF_DATE_TABLE
937: , p5_a27 JTF_DATE_TABLE
938: , p5_a28 JTF_NUMBER_TABLE

Line 935: , p5_a25 JTF_NUMBER_TABLE

931: , p5_a21 JTF_VARCHAR2_TABLE_500
932: , p5_a22 JTF_VARCHAR2_TABLE_500
933: , p5_a23 JTF_NUMBER_TABLE
934: , p5_a24 JTF_NUMBER_TABLE
935: , p5_a25 JTF_NUMBER_TABLE
936: , p5_a26 JTF_DATE_TABLE
937: , p5_a27 JTF_DATE_TABLE
938: , p5_a28 JTF_NUMBER_TABLE
939: )

Line 938: , p5_a28 JTF_NUMBER_TABLE

934: , p5_a24 JTF_NUMBER_TABLE
935: , p5_a25 JTF_NUMBER_TABLE
936: , p5_a26 JTF_DATE_TABLE
937: , p5_a27 JTF_DATE_TABLE
938: , p5_a28 JTF_NUMBER_TABLE
939: )
940:
941: as
942: ddp_srsv_tbl okl_srs_pvt.srsv_tbl_type;

Line 1159: , p5_a0 JTF_NUMBER_TABLE

1155: , p_init_msg_list VARCHAR2
1156: , x_return_status out nocopy VARCHAR2
1157: , x_msg_count out nocopy NUMBER
1158: , x_msg_data out nocopy VARCHAR2
1159: , p5_a0 JTF_NUMBER_TABLE
1160: , p5_a1 JTF_VARCHAR2_TABLE_200
1161: , p5_a2 JTF_NUMBER_TABLE
1162: , p5_a3 JTF_VARCHAR2_TABLE_100
1163: , p5_a4 JTF_NUMBER_TABLE

Line 1161: , p5_a2 JTF_NUMBER_TABLE

1157: , x_msg_count out nocopy NUMBER
1158: , x_msg_data out nocopy VARCHAR2
1159: , p5_a0 JTF_NUMBER_TABLE
1160: , p5_a1 JTF_VARCHAR2_TABLE_200
1161: , p5_a2 JTF_NUMBER_TABLE
1162: , p5_a3 JTF_VARCHAR2_TABLE_100
1163: , p5_a4 JTF_NUMBER_TABLE
1164: , p5_a5 JTF_DATE_TABLE
1165: , p5_a6 JTF_NUMBER_TABLE

Line 1163: , p5_a4 JTF_NUMBER_TABLE

1159: , p5_a0 JTF_NUMBER_TABLE
1160: , p5_a1 JTF_VARCHAR2_TABLE_200
1161: , p5_a2 JTF_NUMBER_TABLE
1162: , p5_a3 JTF_VARCHAR2_TABLE_100
1163: , p5_a4 JTF_NUMBER_TABLE
1164: , p5_a5 JTF_DATE_TABLE
1165: , p5_a6 JTF_NUMBER_TABLE
1166: , p5_a7 JTF_NUMBER_TABLE
1167: , p5_a8 JTF_VARCHAR2_TABLE_500

Line 1165: , p5_a6 JTF_NUMBER_TABLE

1161: , p5_a2 JTF_NUMBER_TABLE
1162: , p5_a3 JTF_VARCHAR2_TABLE_100
1163: , p5_a4 JTF_NUMBER_TABLE
1164: , p5_a5 JTF_DATE_TABLE
1165: , p5_a6 JTF_NUMBER_TABLE
1166: , p5_a7 JTF_NUMBER_TABLE
1167: , p5_a8 JTF_VARCHAR2_TABLE_500
1168: , p5_a9 JTF_VARCHAR2_TABLE_500
1169: , p5_a10 JTF_VARCHAR2_TABLE_500

Line 1166: , p5_a7 JTF_NUMBER_TABLE

1162: , p5_a3 JTF_VARCHAR2_TABLE_100
1163: , p5_a4 JTF_NUMBER_TABLE
1164: , p5_a5 JTF_DATE_TABLE
1165: , p5_a6 JTF_NUMBER_TABLE
1166: , p5_a7 JTF_NUMBER_TABLE
1167: , p5_a8 JTF_VARCHAR2_TABLE_500
1168: , p5_a9 JTF_VARCHAR2_TABLE_500
1169: , p5_a10 JTF_VARCHAR2_TABLE_500
1170: , p5_a11 JTF_VARCHAR2_TABLE_500

Line 1182: , p5_a23 JTF_NUMBER_TABLE

1178: , p5_a19 JTF_VARCHAR2_TABLE_500
1179: , p5_a20 JTF_VARCHAR2_TABLE_500
1180: , p5_a21 JTF_VARCHAR2_TABLE_500
1181: , p5_a22 JTF_VARCHAR2_TABLE_500
1182: , p5_a23 JTF_NUMBER_TABLE
1183: , p5_a24 JTF_NUMBER_TABLE
1184: , p5_a25 JTF_NUMBER_TABLE
1185: , p5_a26 JTF_DATE_TABLE
1186: , p5_a27 JTF_DATE_TABLE

Line 1183: , p5_a24 JTF_NUMBER_TABLE

1179: , p5_a20 JTF_VARCHAR2_TABLE_500
1180: , p5_a21 JTF_VARCHAR2_TABLE_500
1181: , p5_a22 JTF_VARCHAR2_TABLE_500
1182: , p5_a23 JTF_NUMBER_TABLE
1183: , p5_a24 JTF_NUMBER_TABLE
1184: , p5_a25 JTF_NUMBER_TABLE
1185: , p5_a26 JTF_DATE_TABLE
1186: , p5_a27 JTF_DATE_TABLE
1187: , p5_a28 JTF_NUMBER_TABLE

Line 1184: , p5_a25 JTF_NUMBER_TABLE

1180: , p5_a21 JTF_VARCHAR2_TABLE_500
1181: , p5_a22 JTF_VARCHAR2_TABLE_500
1182: , p5_a23 JTF_NUMBER_TABLE
1183: , p5_a24 JTF_NUMBER_TABLE
1184: , p5_a25 JTF_NUMBER_TABLE
1185: , p5_a26 JTF_DATE_TABLE
1186: , p5_a27 JTF_DATE_TABLE
1187: , p5_a28 JTF_NUMBER_TABLE
1188: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 1187: , p5_a28 JTF_NUMBER_TABLE

1183: , p5_a24 JTF_NUMBER_TABLE
1184: , p5_a25 JTF_NUMBER_TABLE
1185: , p5_a26 JTF_DATE_TABLE
1186: , p5_a27 JTF_DATE_TABLE
1187: , p5_a28 JTF_NUMBER_TABLE
1188: , p6_a0 out nocopy JTF_NUMBER_TABLE
1189: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
1190: , p6_a2 out nocopy JTF_NUMBER_TABLE
1191: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

Line 1188: , p6_a0 out nocopy JTF_NUMBER_TABLE

1184: , p5_a25 JTF_NUMBER_TABLE
1185: , p5_a26 JTF_DATE_TABLE
1186: , p5_a27 JTF_DATE_TABLE
1187: , p5_a28 JTF_NUMBER_TABLE
1188: , p6_a0 out nocopy JTF_NUMBER_TABLE
1189: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
1190: , p6_a2 out nocopy JTF_NUMBER_TABLE
1191: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1192: , p6_a4 out nocopy JTF_NUMBER_TABLE

Line 1190: , p6_a2 out nocopy JTF_NUMBER_TABLE

1186: , p5_a27 JTF_DATE_TABLE
1187: , p5_a28 JTF_NUMBER_TABLE
1188: , p6_a0 out nocopy JTF_NUMBER_TABLE
1189: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
1190: , p6_a2 out nocopy JTF_NUMBER_TABLE
1191: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1192: , p6_a4 out nocopy JTF_NUMBER_TABLE
1193: , p6_a5 out nocopy JTF_DATE_TABLE
1194: , p6_a6 out nocopy JTF_NUMBER_TABLE

Line 1192: , p6_a4 out nocopy JTF_NUMBER_TABLE

1188: , p6_a0 out nocopy JTF_NUMBER_TABLE
1189: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
1190: , p6_a2 out nocopy JTF_NUMBER_TABLE
1191: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1192: , p6_a4 out nocopy JTF_NUMBER_TABLE
1193: , p6_a5 out nocopy JTF_DATE_TABLE
1194: , p6_a6 out nocopy JTF_NUMBER_TABLE
1195: , p6_a7 out nocopy JTF_NUMBER_TABLE
1196: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500

Line 1194: , p6_a6 out nocopy JTF_NUMBER_TABLE

1190: , p6_a2 out nocopy JTF_NUMBER_TABLE
1191: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1192: , p6_a4 out nocopy JTF_NUMBER_TABLE
1193: , p6_a5 out nocopy JTF_DATE_TABLE
1194: , p6_a6 out nocopy JTF_NUMBER_TABLE
1195: , p6_a7 out nocopy JTF_NUMBER_TABLE
1196: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500
1197: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_500
1198: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_500

Line 1195: , p6_a7 out nocopy JTF_NUMBER_TABLE

1191: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1192: , p6_a4 out nocopy JTF_NUMBER_TABLE
1193: , p6_a5 out nocopy JTF_DATE_TABLE
1194: , p6_a6 out nocopy JTF_NUMBER_TABLE
1195: , p6_a7 out nocopy JTF_NUMBER_TABLE
1196: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500
1197: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_500
1198: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_500
1199: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500

Line 1211: , p6_a23 out nocopy JTF_NUMBER_TABLE

1207: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
1208: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
1209: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
1210: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
1211: , p6_a23 out nocopy JTF_NUMBER_TABLE
1212: , p6_a24 out nocopy JTF_NUMBER_TABLE
1213: , p6_a25 out nocopy JTF_NUMBER_TABLE
1214: , p6_a26 out nocopy JTF_DATE_TABLE
1215: , p6_a27 out nocopy JTF_DATE_TABLE

Line 1212: , p6_a24 out nocopy JTF_NUMBER_TABLE

1208: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
1209: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
1210: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
1211: , p6_a23 out nocopy JTF_NUMBER_TABLE
1212: , p6_a24 out nocopy JTF_NUMBER_TABLE
1213: , p6_a25 out nocopy JTF_NUMBER_TABLE
1214: , p6_a26 out nocopy JTF_DATE_TABLE
1215: , p6_a27 out nocopy JTF_DATE_TABLE
1216: , p6_a28 out nocopy JTF_NUMBER_TABLE

Line 1213: , p6_a25 out nocopy JTF_NUMBER_TABLE

1209: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
1210: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
1211: , p6_a23 out nocopy JTF_NUMBER_TABLE
1212: , p6_a24 out nocopy JTF_NUMBER_TABLE
1213: , p6_a25 out nocopy JTF_NUMBER_TABLE
1214: , p6_a26 out nocopy JTF_DATE_TABLE
1215: , p6_a27 out nocopy JTF_DATE_TABLE
1216: , p6_a28 out nocopy JTF_NUMBER_TABLE
1217: )

Line 1216: , p6_a28 out nocopy JTF_NUMBER_TABLE

1212: , p6_a24 out nocopy JTF_NUMBER_TABLE
1213: , p6_a25 out nocopy JTF_NUMBER_TABLE
1214: , p6_a26 out nocopy JTF_DATE_TABLE
1215: , p6_a27 out nocopy JTF_DATE_TABLE
1216: , p6_a28 out nocopy JTF_NUMBER_TABLE
1217: )
1218:
1219: as
1220: ddp_srsv_tbl okl_srs_pvt.srsv_tbl_type;

Line 1409: , p5_a0 JTF_NUMBER_TABLE

1405: , p_init_msg_list VARCHAR2
1406: , x_return_status out nocopy VARCHAR2
1407: , x_msg_count out nocopy NUMBER
1408: , x_msg_data out nocopy VARCHAR2
1409: , p5_a0 JTF_NUMBER_TABLE
1410: , p5_a1 JTF_VARCHAR2_TABLE_200
1411: , p5_a2 JTF_NUMBER_TABLE
1412: , p5_a3 JTF_VARCHAR2_TABLE_100
1413: , p5_a4 JTF_NUMBER_TABLE

Line 1411: , p5_a2 JTF_NUMBER_TABLE

1407: , x_msg_count out nocopy NUMBER
1408: , x_msg_data out nocopy VARCHAR2
1409: , p5_a0 JTF_NUMBER_TABLE
1410: , p5_a1 JTF_VARCHAR2_TABLE_200
1411: , p5_a2 JTF_NUMBER_TABLE
1412: , p5_a3 JTF_VARCHAR2_TABLE_100
1413: , p5_a4 JTF_NUMBER_TABLE
1414: , p5_a5 JTF_DATE_TABLE
1415: , p5_a6 JTF_NUMBER_TABLE

Line 1413: , p5_a4 JTF_NUMBER_TABLE

1409: , p5_a0 JTF_NUMBER_TABLE
1410: , p5_a1 JTF_VARCHAR2_TABLE_200
1411: , p5_a2 JTF_NUMBER_TABLE
1412: , p5_a3 JTF_VARCHAR2_TABLE_100
1413: , p5_a4 JTF_NUMBER_TABLE
1414: , p5_a5 JTF_DATE_TABLE
1415: , p5_a6 JTF_NUMBER_TABLE
1416: , p5_a7 JTF_NUMBER_TABLE
1417: , p5_a8 JTF_VARCHAR2_TABLE_500

Line 1415: , p5_a6 JTF_NUMBER_TABLE

1411: , p5_a2 JTF_NUMBER_TABLE
1412: , p5_a3 JTF_VARCHAR2_TABLE_100
1413: , p5_a4 JTF_NUMBER_TABLE
1414: , p5_a5 JTF_DATE_TABLE
1415: , p5_a6 JTF_NUMBER_TABLE
1416: , p5_a7 JTF_NUMBER_TABLE
1417: , p5_a8 JTF_VARCHAR2_TABLE_500
1418: , p5_a9 JTF_VARCHAR2_TABLE_500
1419: , p5_a10 JTF_VARCHAR2_TABLE_500

Line 1416: , p5_a7 JTF_NUMBER_TABLE

1412: , p5_a3 JTF_VARCHAR2_TABLE_100
1413: , p5_a4 JTF_NUMBER_TABLE
1414: , p5_a5 JTF_DATE_TABLE
1415: , p5_a6 JTF_NUMBER_TABLE
1416: , p5_a7 JTF_NUMBER_TABLE
1417: , p5_a8 JTF_VARCHAR2_TABLE_500
1418: , p5_a9 JTF_VARCHAR2_TABLE_500
1419: , p5_a10 JTF_VARCHAR2_TABLE_500
1420: , p5_a11 JTF_VARCHAR2_TABLE_500

Line 1432: , p5_a23 JTF_NUMBER_TABLE

1428: , p5_a19 JTF_VARCHAR2_TABLE_500
1429: , p5_a20 JTF_VARCHAR2_TABLE_500
1430: , p5_a21 JTF_VARCHAR2_TABLE_500
1431: , p5_a22 JTF_VARCHAR2_TABLE_500
1432: , p5_a23 JTF_NUMBER_TABLE
1433: , p5_a24 JTF_NUMBER_TABLE
1434: , p5_a25 JTF_NUMBER_TABLE
1435: , p5_a26 JTF_DATE_TABLE
1436: , p5_a27 JTF_DATE_TABLE

Line 1433: , p5_a24 JTF_NUMBER_TABLE

1429: , p5_a20 JTF_VARCHAR2_TABLE_500
1430: , p5_a21 JTF_VARCHAR2_TABLE_500
1431: , p5_a22 JTF_VARCHAR2_TABLE_500
1432: , p5_a23 JTF_NUMBER_TABLE
1433: , p5_a24 JTF_NUMBER_TABLE
1434: , p5_a25 JTF_NUMBER_TABLE
1435: , p5_a26 JTF_DATE_TABLE
1436: , p5_a27 JTF_DATE_TABLE
1437: , p5_a28 JTF_NUMBER_TABLE

Line 1434: , p5_a25 JTF_NUMBER_TABLE

1430: , p5_a21 JTF_VARCHAR2_TABLE_500
1431: , p5_a22 JTF_VARCHAR2_TABLE_500
1432: , p5_a23 JTF_NUMBER_TABLE
1433: , p5_a24 JTF_NUMBER_TABLE
1434: , p5_a25 JTF_NUMBER_TABLE
1435: , p5_a26 JTF_DATE_TABLE
1436: , p5_a27 JTF_DATE_TABLE
1437: , p5_a28 JTF_NUMBER_TABLE
1438: )

Line 1437: , p5_a28 JTF_NUMBER_TABLE

1433: , p5_a24 JTF_NUMBER_TABLE
1434: , p5_a25 JTF_NUMBER_TABLE
1435: , p5_a26 JTF_DATE_TABLE
1436: , p5_a27 JTF_DATE_TABLE
1437: , p5_a28 JTF_NUMBER_TABLE
1438: )
1439:
1440: as
1441: ddp_srsv_tbl okl_srs_pvt.srsv_tbl_type;

Line 1596: , p5_a0 JTF_NUMBER_TABLE

1592: , p_init_msg_list VARCHAR2
1593: , x_return_status out nocopy VARCHAR2
1594: , x_msg_count out nocopy NUMBER
1595: , x_msg_data out nocopy VARCHAR2
1596: , p5_a0 JTF_NUMBER_TABLE
1597: , p5_a1 JTF_VARCHAR2_TABLE_200
1598: , p5_a2 JTF_NUMBER_TABLE
1599: , p5_a3 JTF_VARCHAR2_TABLE_100
1600: , p5_a4 JTF_NUMBER_TABLE

Line 1598: , p5_a2 JTF_NUMBER_TABLE

1594: , x_msg_count out nocopy NUMBER
1595: , x_msg_data out nocopy VARCHAR2
1596: , p5_a0 JTF_NUMBER_TABLE
1597: , p5_a1 JTF_VARCHAR2_TABLE_200
1598: , p5_a2 JTF_NUMBER_TABLE
1599: , p5_a3 JTF_VARCHAR2_TABLE_100
1600: , p5_a4 JTF_NUMBER_TABLE
1601: , p5_a5 JTF_DATE_TABLE
1602: , p5_a6 JTF_NUMBER_TABLE

Line 1600: , p5_a4 JTF_NUMBER_TABLE

1596: , p5_a0 JTF_NUMBER_TABLE
1597: , p5_a1 JTF_VARCHAR2_TABLE_200
1598: , p5_a2 JTF_NUMBER_TABLE
1599: , p5_a3 JTF_VARCHAR2_TABLE_100
1600: , p5_a4 JTF_NUMBER_TABLE
1601: , p5_a5 JTF_DATE_TABLE
1602: , p5_a6 JTF_NUMBER_TABLE
1603: , p5_a7 JTF_NUMBER_TABLE
1604: , p5_a8 JTF_VARCHAR2_TABLE_500

Line 1602: , p5_a6 JTF_NUMBER_TABLE

1598: , p5_a2 JTF_NUMBER_TABLE
1599: , p5_a3 JTF_VARCHAR2_TABLE_100
1600: , p5_a4 JTF_NUMBER_TABLE
1601: , p5_a5 JTF_DATE_TABLE
1602: , p5_a6 JTF_NUMBER_TABLE
1603: , p5_a7 JTF_NUMBER_TABLE
1604: , p5_a8 JTF_VARCHAR2_TABLE_500
1605: , p5_a9 JTF_VARCHAR2_TABLE_500
1606: , p5_a10 JTF_VARCHAR2_TABLE_500

Line 1603: , p5_a7 JTF_NUMBER_TABLE

1599: , p5_a3 JTF_VARCHAR2_TABLE_100
1600: , p5_a4 JTF_NUMBER_TABLE
1601: , p5_a5 JTF_DATE_TABLE
1602: , p5_a6 JTF_NUMBER_TABLE
1603: , p5_a7 JTF_NUMBER_TABLE
1604: , p5_a8 JTF_VARCHAR2_TABLE_500
1605: , p5_a9 JTF_VARCHAR2_TABLE_500
1606: , p5_a10 JTF_VARCHAR2_TABLE_500
1607: , p5_a11 JTF_VARCHAR2_TABLE_500

Line 1619: , p5_a23 JTF_NUMBER_TABLE

1615: , p5_a19 JTF_VARCHAR2_TABLE_500
1616: , p5_a20 JTF_VARCHAR2_TABLE_500
1617: , p5_a21 JTF_VARCHAR2_TABLE_500
1618: , p5_a22 JTF_VARCHAR2_TABLE_500
1619: , p5_a23 JTF_NUMBER_TABLE
1620: , p5_a24 JTF_NUMBER_TABLE
1621: , p5_a25 JTF_NUMBER_TABLE
1622: , p5_a26 JTF_DATE_TABLE
1623: , p5_a27 JTF_DATE_TABLE

Line 1620: , p5_a24 JTF_NUMBER_TABLE

1616: , p5_a20 JTF_VARCHAR2_TABLE_500
1617: , p5_a21 JTF_VARCHAR2_TABLE_500
1618: , p5_a22 JTF_VARCHAR2_TABLE_500
1619: , p5_a23 JTF_NUMBER_TABLE
1620: , p5_a24 JTF_NUMBER_TABLE
1621: , p5_a25 JTF_NUMBER_TABLE
1622: , p5_a26 JTF_DATE_TABLE
1623: , p5_a27 JTF_DATE_TABLE
1624: , p5_a28 JTF_NUMBER_TABLE

Line 1621: , p5_a25 JTF_NUMBER_TABLE

1617: , p5_a21 JTF_VARCHAR2_TABLE_500
1618: , p5_a22 JTF_VARCHAR2_TABLE_500
1619: , p5_a23 JTF_NUMBER_TABLE
1620: , p5_a24 JTF_NUMBER_TABLE
1621: , p5_a25 JTF_NUMBER_TABLE
1622: , p5_a26 JTF_DATE_TABLE
1623: , p5_a27 JTF_DATE_TABLE
1624: , p5_a28 JTF_NUMBER_TABLE
1625: )

Line 1624: , p5_a28 JTF_NUMBER_TABLE

1620: , p5_a24 JTF_NUMBER_TABLE
1621: , p5_a25 JTF_NUMBER_TABLE
1622: , p5_a26 JTF_DATE_TABLE
1623: , p5_a27 JTF_DATE_TABLE
1624: , p5_a28 JTF_NUMBER_TABLE
1625: )
1626:
1627: as
1628: ddp_srsv_tbl okl_srs_pvt.srsv_tbl_type;

Line 1685: procedure insert_row_upg(p0_a0 JTF_NUMBER_TABLE

1681:
1682:
1683: end;
1684:
1685: procedure insert_row_upg(p0_a0 JTF_NUMBER_TABLE
1686: , p0_a1 JTF_VARCHAR2_TABLE_200
1687: , p0_a2 JTF_NUMBER_TABLE
1688: , p0_a3 JTF_VARCHAR2_TABLE_100
1689: , p0_a4 JTF_NUMBER_TABLE

Line 1687: , p0_a2 JTF_NUMBER_TABLE

1683: end;
1684:
1685: procedure insert_row_upg(p0_a0 JTF_NUMBER_TABLE
1686: , p0_a1 JTF_VARCHAR2_TABLE_200
1687: , p0_a2 JTF_NUMBER_TABLE
1688: , p0_a3 JTF_VARCHAR2_TABLE_100
1689: , p0_a4 JTF_NUMBER_TABLE
1690: , p0_a5 JTF_DATE_TABLE
1691: , p0_a6 JTF_NUMBER_TABLE

Line 1689: , p0_a4 JTF_NUMBER_TABLE

1685: procedure insert_row_upg(p0_a0 JTF_NUMBER_TABLE
1686: , p0_a1 JTF_VARCHAR2_TABLE_200
1687: , p0_a2 JTF_NUMBER_TABLE
1688: , p0_a3 JTF_VARCHAR2_TABLE_100
1689: , p0_a4 JTF_NUMBER_TABLE
1690: , p0_a5 JTF_DATE_TABLE
1691: , p0_a6 JTF_NUMBER_TABLE
1692: , p0_a7 JTF_NUMBER_TABLE
1693: , p0_a8 JTF_VARCHAR2_TABLE_500

Line 1691: , p0_a6 JTF_NUMBER_TABLE

1687: , p0_a2 JTF_NUMBER_TABLE
1688: , p0_a3 JTF_VARCHAR2_TABLE_100
1689: , p0_a4 JTF_NUMBER_TABLE
1690: , p0_a5 JTF_DATE_TABLE
1691: , p0_a6 JTF_NUMBER_TABLE
1692: , p0_a7 JTF_NUMBER_TABLE
1693: , p0_a8 JTF_VARCHAR2_TABLE_500
1694: , p0_a9 JTF_VARCHAR2_TABLE_500
1695: , p0_a10 JTF_VARCHAR2_TABLE_500

Line 1692: , p0_a7 JTF_NUMBER_TABLE

1688: , p0_a3 JTF_VARCHAR2_TABLE_100
1689: , p0_a4 JTF_NUMBER_TABLE
1690: , p0_a5 JTF_DATE_TABLE
1691: , p0_a6 JTF_NUMBER_TABLE
1692: , p0_a7 JTF_NUMBER_TABLE
1693: , p0_a8 JTF_VARCHAR2_TABLE_500
1694: , p0_a9 JTF_VARCHAR2_TABLE_500
1695: , p0_a10 JTF_VARCHAR2_TABLE_500
1696: , p0_a11 JTF_VARCHAR2_TABLE_500

Line 1708: , p0_a23 JTF_NUMBER_TABLE

1704: , p0_a19 JTF_VARCHAR2_TABLE_500
1705: , p0_a20 JTF_VARCHAR2_TABLE_500
1706: , p0_a21 JTF_VARCHAR2_TABLE_500
1707: , p0_a22 JTF_VARCHAR2_TABLE_500
1708: , p0_a23 JTF_NUMBER_TABLE
1709: , p0_a24 JTF_NUMBER_TABLE
1710: , p0_a25 JTF_NUMBER_TABLE
1711: , p0_a26 JTF_DATE_TABLE
1712: , p0_a27 JTF_DATE_TABLE

Line 1709: , p0_a24 JTF_NUMBER_TABLE

1705: , p0_a20 JTF_VARCHAR2_TABLE_500
1706: , p0_a21 JTF_VARCHAR2_TABLE_500
1707: , p0_a22 JTF_VARCHAR2_TABLE_500
1708: , p0_a23 JTF_NUMBER_TABLE
1709: , p0_a24 JTF_NUMBER_TABLE
1710: , p0_a25 JTF_NUMBER_TABLE
1711: , p0_a26 JTF_DATE_TABLE
1712: , p0_a27 JTF_DATE_TABLE
1713: , p0_a28 JTF_NUMBER_TABLE

Line 1710: , p0_a25 JTF_NUMBER_TABLE

1706: , p0_a21 JTF_VARCHAR2_TABLE_500
1707: , p0_a22 JTF_VARCHAR2_TABLE_500
1708: , p0_a23 JTF_NUMBER_TABLE
1709: , p0_a24 JTF_NUMBER_TABLE
1710: , p0_a25 JTF_NUMBER_TABLE
1711: , p0_a26 JTF_DATE_TABLE
1712: , p0_a27 JTF_DATE_TABLE
1713: , p0_a28 JTF_NUMBER_TABLE
1714: )

Line 1713: , p0_a28 JTF_NUMBER_TABLE

1709: , p0_a24 JTF_NUMBER_TABLE
1710: , p0_a25 JTF_NUMBER_TABLE
1711: , p0_a26 JTF_DATE_TABLE
1712: , p0_a27 JTF_DATE_TABLE
1713: , p0_a28 JTF_NUMBER_TABLE
1714: )
1715:
1716: as
1717: ddp_srsv_tbl okl_srs_pvt.srsv_tbl_type;