DBA Data[Home] [Help]

APPS.OKL_ILT_PVT_W dependencies on JTF_NUMBER_TABLE

Line 22: procedure rosetta_table_copy_in_p2(t out nocopy okl_ilt_pvt.ilt_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_ilt_pvt.ilt_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100

Line 23: , a1 JTF_NUMBER_TABLE

19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_ilt_pvt.ilt_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_VARCHAR2_TABLE_500

Line 24: , a2 JTF_NUMBER_TABLE

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

Line 25: , a3 JTF_NUMBER_TABLE

21:
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_ilt_pvt.ilt_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_VARCHAR2_TABLE_500
28: , a6 JTF_VARCHAR2_TABLE_500
29: , a7 JTF_VARCHAR2_TABLE_500

Line 42: , a20 JTF_NUMBER_TABLE

38: , a16 JTF_VARCHAR2_TABLE_500
39: , a17 JTF_VARCHAR2_TABLE_500
40: , a18 JTF_VARCHAR2_TABLE_500
41: , a19 JTF_VARCHAR2_TABLE_500
42: , a20 JTF_NUMBER_TABLE
43: , a21 JTF_DATE_TABLE
44: , a22 JTF_NUMBER_TABLE
45: , a23 JTF_DATE_TABLE
46: , a24 JTF_NUMBER_TABLE

Line 44: , a22 JTF_NUMBER_TABLE

40: , a18 JTF_VARCHAR2_TABLE_500
41: , a19 JTF_VARCHAR2_TABLE_500
42: , a20 JTF_NUMBER_TABLE
43: , a21 JTF_DATE_TABLE
44: , a22 JTF_NUMBER_TABLE
45: , a23 JTF_DATE_TABLE
46: , a24 JTF_NUMBER_TABLE
47: ) as
48: ddindx binary_integer; indx binary_integer;

Line 46: , a24 JTF_NUMBER_TABLE

42: , a20 JTF_NUMBER_TABLE
43: , a21 JTF_DATE_TABLE
44: , a22 JTF_NUMBER_TABLE
45: , a23 JTF_DATE_TABLE
46: , a24 JTF_NUMBER_TABLE
47: ) as
48: ddindx binary_integer; indx binary_integer;
49: begin
50: if a0 is not null and a0.count > 0 then

Line 89: procedure rosetta_table_copy_out_p2(t okl_ilt_pvt.ilt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

85: end loop;
86: end if;
87: end if;
88: end rosetta_table_copy_in_p2;
89: procedure rosetta_table_copy_out_p2(t okl_ilt_pvt.ilt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
90: , a1 out nocopy JTF_NUMBER_TABLE
91: , a2 out nocopy JTF_NUMBER_TABLE
92: , a3 out nocopy JTF_NUMBER_TABLE
93: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 90: , a1 out nocopy JTF_NUMBER_TABLE

86: end if;
87: end if;
88: end rosetta_table_copy_in_p2;
89: procedure rosetta_table_copy_out_p2(t okl_ilt_pvt.ilt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
90: , a1 out nocopy JTF_NUMBER_TABLE
91: , a2 out nocopy JTF_NUMBER_TABLE
92: , a3 out nocopy JTF_NUMBER_TABLE
93: , a4 out nocopy JTF_VARCHAR2_TABLE_100
94: , a5 out nocopy JTF_VARCHAR2_TABLE_500

Line 91: , a2 out nocopy JTF_NUMBER_TABLE

87: end if;
88: end rosetta_table_copy_in_p2;
89: procedure rosetta_table_copy_out_p2(t okl_ilt_pvt.ilt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
90: , a1 out nocopy JTF_NUMBER_TABLE
91: , a2 out nocopy JTF_NUMBER_TABLE
92: , a3 out nocopy JTF_NUMBER_TABLE
93: , a4 out nocopy JTF_VARCHAR2_TABLE_100
94: , a5 out nocopy JTF_VARCHAR2_TABLE_500
95: , a6 out nocopy JTF_VARCHAR2_TABLE_500

Line 92: , a3 out nocopy JTF_NUMBER_TABLE

88: end rosetta_table_copy_in_p2;
89: procedure rosetta_table_copy_out_p2(t okl_ilt_pvt.ilt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
90: , a1 out nocopy JTF_NUMBER_TABLE
91: , a2 out nocopy JTF_NUMBER_TABLE
92: , a3 out nocopy JTF_NUMBER_TABLE
93: , a4 out nocopy JTF_VARCHAR2_TABLE_100
94: , a5 out nocopy JTF_VARCHAR2_TABLE_500
95: , a6 out nocopy JTF_VARCHAR2_TABLE_500
96: , a7 out nocopy JTF_VARCHAR2_TABLE_500

Line 109: , a20 out nocopy JTF_NUMBER_TABLE

105: , a16 out nocopy JTF_VARCHAR2_TABLE_500
106: , a17 out nocopy JTF_VARCHAR2_TABLE_500
107: , a18 out nocopy JTF_VARCHAR2_TABLE_500
108: , a19 out nocopy JTF_VARCHAR2_TABLE_500
109: , a20 out nocopy JTF_NUMBER_TABLE
110: , a21 out nocopy JTF_DATE_TABLE
111: , a22 out nocopy JTF_NUMBER_TABLE
112: , a23 out nocopy JTF_DATE_TABLE
113: , a24 out nocopy JTF_NUMBER_TABLE

Line 111: , a22 out nocopy JTF_NUMBER_TABLE

107: , a18 out nocopy JTF_VARCHAR2_TABLE_500
108: , a19 out nocopy JTF_VARCHAR2_TABLE_500
109: , a20 out nocopy JTF_NUMBER_TABLE
110: , a21 out nocopy JTF_DATE_TABLE
111: , a22 out nocopy JTF_NUMBER_TABLE
112: , a23 out nocopy JTF_DATE_TABLE
113: , a24 out nocopy JTF_NUMBER_TABLE
114: ) as
115: ddindx binary_integer; indx binary_integer;

Line 113: , a24 out nocopy JTF_NUMBER_TABLE

109: , a20 out nocopy JTF_NUMBER_TABLE
110: , a21 out nocopy JTF_DATE_TABLE
111: , a22 out nocopy JTF_NUMBER_TABLE
112: , a23 out nocopy JTF_DATE_TABLE
113: , a24 out nocopy JTF_NUMBER_TABLE
114: ) as
115: ddindx binary_integer; indx binary_integer;
116: begin
117: if t is null or t.count = 0 then

Line 118: a0 := JTF_NUMBER_TABLE();

114: ) as
115: ddindx binary_integer; indx binary_integer;
116: begin
117: if t is null or t.count = 0 then
118: a0 := JTF_NUMBER_TABLE();
119: a1 := JTF_NUMBER_TABLE();
120: a2 := JTF_NUMBER_TABLE();
121: a3 := JTF_NUMBER_TABLE();
122: a4 := JTF_VARCHAR2_TABLE_100();

Line 119: a1 := JTF_NUMBER_TABLE();

115: ddindx binary_integer; indx binary_integer;
116: begin
117: if t is null or t.count = 0 then
118: a0 := JTF_NUMBER_TABLE();
119: a1 := JTF_NUMBER_TABLE();
120: a2 := JTF_NUMBER_TABLE();
121: a3 := JTF_NUMBER_TABLE();
122: a4 := JTF_VARCHAR2_TABLE_100();
123: a5 := JTF_VARCHAR2_TABLE_500();

Line 120: a2 := JTF_NUMBER_TABLE();

116: begin
117: if t is null or t.count = 0 then
118: a0 := JTF_NUMBER_TABLE();
119: a1 := JTF_NUMBER_TABLE();
120: a2 := JTF_NUMBER_TABLE();
121: a3 := JTF_NUMBER_TABLE();
122: a4 := JTF_VARCHAR2_TABLE_100();
123: a5 := JTF_VARCHAR2_TABLE_500();
124: a6 := JTF_VARCHAR2_TABLE_500();

Line 121: a3 := JTF_NUMBER_TABLE();

117: if t is null or t.count = 0 then
118: a0 := JTF_NUMBER_TABLE();
119: a1 := JTF_NUMBER_TABLE();
120: a2 := JTF_NUMBER_TABLE();
121: a3 := JTF_NUMBER_TABLE();
122: a4 := JTF_VARCHAR2_TABLE_100();
123: a5 := JTF_VARCHAR2_TABLE_500();
124: a6 := JTF_VARCHAR2_TABLE_500();
125: a7 := JTF_VARCHAR2_TABLE_500();

Line 138: a20 := JTF_NUMBER_TABLE();

134: a16 := JTF_VARCHAR2_TABLE_500();
135: a17 := JTF_VARCHAR2_TABLE_500();
136: a18 := JTF_VARCHAR2_TABLE_500();
137: a19 := JTF_VARCHAR2_TABLE_500();
138: a20 := JTF_NUMBER_TABLE();
139: a21 := JTF_DATE_TABLE();
140: a22 := JTF_NUMBER_TABLE();
141: a23 := JTF_DATE_TABLE();
142: a24 := JTF_NUMBER_TABLE();

Line 140: a22 := JTF_NUMBER_TABLE();

136: a18 := JTF_VARCHAR2_TABLE_500();
137: a19 := JTF_VARCHAR2_TABLE_500();
138: a20 := JTF_NUMBER_TABLE();
139: a21 := JTF_DATE_TABLE();
140: a22 := JTF_NUMBER_TABLE();
141: a23 := JTF_DATE_TABLE();
142: a24 := JTF_NUMBER_TABLE();
143: else
144: a0 := JTF_NUMBER_TABLE();

Line 142: a24 := JTF_NUMBER_TABLE();

138: a20 := JTF_NUMBER_TABLE();
139: a21 := JTF_DATE_TABLE();
140: a22 := JTF_NUMBER_TABLE();
141: a23 := JTF_DATE_TABLE();
142: a24 := JTF_NUMBER_TABLE();
143: else
144: a0 := JTF_NUMBER_TABLE();
145: a1 := JTF_NUMBER_TABLE();
146: a2 := JTF_NUMBER_TABLE();

Line 144: a0 := JTF_NUMBER_TABLE();

140: a22 := JTF_NUMBER_TABLE();
141: a23 := JTF_DATE_TABLE();
142: a24 := JTF_NUMBER_TABLE();
143: else
144: a0 := JTF_NUMBER_TABLE();
145: a1 := JTF_NUMBER_TABLE();
146: a2 := JTF_NUMBER_TABLE();
147: a3 := JTF_NUMBER_TABLE();
148: a4 := JTF_VARCHAR2_TABLE_100();

Line 145: a1 := JTF_NUMBER_TABLE();

141: a23 := JTF_DATE_TABLE();
142: a24 := JTF_NUMBER_TABLE();
143: else
144: a0 := JTF_NUMBER_TABLE();
145: a1 := JTF_NUMBER_TABLE();
146: a2 := JTF_NUMBER_TABLE();
147: a3 := JTF_NUMBER_TABLE();
148: a4 := JTF_VARCHAR2_TABLE_100();
149: a5 := JTF_VARCHAR2_TABLE_500();

Line 146: a2 := JTF_NUMBER_TABLE();

142: a24 := JTF_NUMBER_TABLE();
143: else
144: a0 := JTF_NUMBER_TABLE();
145: a1 := JTF_NUMBER_TABLE();
146: a2 := JTF_NUMBER_TABLE();
147: a3 := JTF_NUMBER_TABLE();
148: a4 := JTF_VARCHAR2_TABLE_100();
149: a5 := JTF_VARCHAR2_TABLE_500();
150: a6 := JTF_VARCHAR2_TABLE_500();

Line 147: a3 := JTF_NUMBER_TABLE();

143: else
144: a0 := JTF_NUMBER_TABLE();
145: a1 := JTF_NUMBER_TABLE();
146: a2 := JTF_NUMBER_TABLE();
147: a3 := JTF_NUMBER_TABLE();
148: a4 := JTF_VARCHAR2_TABLE_100();
149: a5 := JTF_VARCHAR2_TABLE_500();
150: a6 := JTF_VARCHAR2_TABLE_500();
151: a7 := JTF_VARCHAR2_TABLE_500();

Line 164: a20 := JTF_NUMBER_TABLE();

160: a16 := JTF_VARCHAR2_TABLE_500();
161: a17 := JTF_VARCHAR2_TABLE_500();
162: a18 := JTF_VARCHAR2_TABLE_500();
163: a19 := JTF_VARCHAR2_TABLE_500();
164: a20 := JTF_NUMBER_TABLE();
165: a21 := JTF_DATE_TABLE();
166: a22 := JTF_NUMBER_TABLE();
167: a23 := JTF_DATE_TABLE();
168: a24 := JTF_NUMBER_TABLE();

Line 166: a22 := JTF_NUMBER_TABLE();

162: a18 := JTF_VARCHAR2_TABLE_500();
163: a19 := JTF_VARCHAR2_TABLE_500();
164: a20 := JTF_NUMBER_TABLE();
165: a21 := JTF_DATE_TABLE();
166: a22 := JTF_NUMBER_TABLE();
167: a23 := JTF_DATE_TABLE();
168: a24 := JTF_NUMBER_TABLE();
169: if t.count > 0 then
170: a0.extend(t.count);

Line 168: a24 := JTF_NUMBER_TABLE();

164: a20 := JTF_NUMBER_TABLE();
165: a21 := JTF_DATE_TABLE();
166: a22 := JTF_NUMBER_TABLE();
167: a23 := JTF_DATE_TABLE();
168: a24 := JTF_NUMBER_TABLE();
169: if t.count > 0 then
170: a0.extend(t.count);
171: a1.extend(t.count);
172: a2.extend(t.count);

Line 233: procedure rosetta_table_copy_in_p5(t out nocopy okl_ilt_pvt.oklinvclinetypestltbltype, a0 JTF_NUMBER_TABLE

229: end if;
230: end if;
231: end rosetta_table_copy_out_p2;
232:
233: procedure rosetta_table_copy_in_p5(t out nocopy okl_ilt_pvt.oklinvclinetypestltbltype, a0 JTF_NUMBER_TABLE
234: , a1 JTF_VARCHAR2_TABLE_100
235: , a2 JTF_VARCHAR2_TABLE_100
236: , a3 JTF_VARCHAR2_TABLE_100
237: , a4 JTF_VARCHAR2_TABLE_200

Line 239: , a6 JTF_NUMBER_TABLE

235: , a2 JTF_VARCHAR2_TABLE_100
236: , a3 JTF_VARCHAR2_TABLE_100
237: , a4 JTF_VARCHAR2_TABLE_200
238: , a5 JTF_VARCHAR2_TABLE_2000
239: , a6 JTF_NUMBER_TABLE
240: , a7 JTF_DATE_TABLE
241: , a8 JTF_NUMBER_TABLE
242: , a9 JTF_DATE_TABLE
243: , a10 JTF_NUMBER_TABLE

Line 241: , a8 JTF_NUMBER_TABLE

237: , a4 JTF_VARCHAR2_TABLE_200
238: , a5 JTF_VARCHAR2_TABLE_2000
239: , a6 JTF_NUMBER_TABLE
240: , a7 JTF_DATE_TABLE
241: , a8 JTF_NUMBER_TABLE
242: , a9 JTF_DATE_TABLE
243: , a10 JTF_NUMBER_TABLE
244: ) as
245: ddindx binary_integer; indx binary_integer;

Line 243: , a10 JTF_NUMBER_TABLE

239: , a6 JTF_NUMBER_TABLE
240: , a7 JTF_DATE_TABLE
241: , a8 JTF_NUMBER_TABLE
242: , a9 JTF_DATE_TABLE
243: , a10 JTF_NUMBER_TABLE
244: ) as
245: ddindx binary_integer; indx binary_integer;
246: begin
247: if a0 is not null and a0.count > 0 then

Line 272: procedure rosetta_table_copy_out_p5(t okl_ilt_pvt.oklinvclinetypestltbltype, a0 out nocopy JTF_NUMBER_TABLE

268: end loop;
269: end if;
270: end if;
271: end rosetta_table_copy_in_p5;
272: procedure rosetta_table_copy_out_p5(t okl_ilt_pvt.oklinvclinetypestltbltype, a0 out nocopy JTF_NUMBER_TABLE
273: , a1 out nocopy JTF_VARCHAR2_TABLE_100
274: , a2 out nocopy JTF_VARCHAR2_TABLE_100
275: , a3 out nocopy JTF_VARCHAR2_TABLE_100
276: , a4 out nocopy JTF_VARCHAR2_TABLE_200

Line 278: , a6 out nocopy JTF_NUMBER_TABLE

274: , a2 out nocopy JTF_VARCHAR2_TABLE_100
275: , a3 out nocopy JTF_VARCHAR2_TABLE_100
276: , a4 out nocopy JTF_VARCHAR2_TABLE_200
277: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
278: , a6 out nocopy JTF_NUMBER_TABLE
279: , a7 out nocopy JTF_DATE_TABLE
280: , a8 out nocopy JTF_NUMBER_TABLE
281: , a9 out nocopy JTF_DATE_TABLE
282: , a10 out nocopy JTF_NUMBER_TABLE

Line 280: , a8 out nocopy JTF_NUMBER_TABLE

276: , a4 out nocopy JTF_VARCHAR2_TABLE_200
277: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
278: , a6 out nocopy JTF_NUMBER_TABLE
279: , a7 out nocopy JTF_DATE_TABLE
280: , a8 out nocopy JTF_NUMBER_TABLE
281: , a9 out nocopy JTF_DATE_TABLE
282: , a10 out nocopy JTF_NUMBER_TABLE
283: ) as
284: ddindx binary_integer; indx binary_integer;

Line 282: , a10 out nocopy JTF_NUMBER_TABLE

278: , a6 out nocopy JTF_NUMBER_TABLE
279: , a7 out nocopy JTF_DATE_TABLE
280: , a8 out nocopy JTF_NUMBER_TABLE
281: , a9 out nocopy JTF_DATE_TABLE
282: , a10 out nocopy JTF_NUMBER_TABLE
283: ) as
284: ddindx binary_integer; indx binary_integer;
285: begin
286: if t is null or t.count = 0 then

Line 287: a0 := JTF_NUMBER_TABLE();

283: ) as
284: ddindx binary_integer; indx binary_integer;
285: begin
286: if t is null or t.count = 0 then
287: a0 := JTF_NUMBER_TABLE();
288: a1 := JTF_VARCHAR2_TABLE_100();
289: a2 := JTF_VARCHAR2_TABLE_100();
290: a3 := JTF_VARCHAR2_TABLE_100();
291: a4 := JTF_VARCHAR2_TABLE_200();

Line 293: a6 := JTF_NUMBER_TABLE();

289: a2 := JTF_VARCHAR2_TABLE_100();
290: a3 := JTF_VARCHAR2_TABLE_100();
291: a4 := JTF_VARCHAR2_TABLE_200();
292: a5 := JTF_VARCHAR2_TABLE_2000();
293: a6 := JTF_NUMBER_TABLE();
294: a7 := JTF_DATE_TABLE();
295: a8 := JTF_NUMBER_TABLE();
296: a9 := JTF_DATE_TABLE();
297: a10 := JTF_NUMBER_TABLE();

Line 295: a8 := JTF_NUMBER_TABLE();

291: a4 := JTF_VARCHAR2_TABLE_200();
292: a5 := JTF_VARCHAR2_TABLE_2000();
293: a6 := JTF_NUMBER_TABLE();
294: a7 := JTF_DATE_TABLE();
295: a8 := JTF_NUMBER_TABLE();
296: a9 := JTF_DATE_TABLE();
297: a10 := JTF_NUMBER_TABLE();
298: else
299: a0 := JTF_NUMBER_TABLE();

Line 297: a10 := JTF_NUMBER_TABLE();

293: a6 := JTF_NUMBER_TABLE();
294: a7 := JTF_DATE_TABLE();
295: a8 := JTF_NUMBER_TABLE();
296: a9 := JTF_DATE_TABLE();
297: a10 := JTF_NUMBER_TABLE();
298: else
299: a0 := JTF_NUMBER_TABLE();
300: a1 := JTF_VARCHAR2_TABLE_100();
301: a2 := JTF_VARCHAR2_TABLE_100();

Line 299: a0 := JTF_NUMBER_TABLE();

295: a8 := JTF_NUMBER_TABLE();
296: a9 := JTF_DATE_TABLE();
297: a10 := JTF_NUMBER_TABLE();
298: else
299: a0 := JTF_NUMBER_TABLE();
300: a1 := JTF_VARCHAR2_TABLE_100();
301: a2 := JTF_VARCHAR2_TABLE_100();
302: a3 := JTF_VARCHAR2_TABLE_100();
303: a4 := JTF_VARCHAR2_TABLE_200();

Line 305: a6 := JTF_NUMBER_TABLE();

301: a2 := JTF_VARCHAR2_TABLE_100();
302: a3 := JTF_VARCHAR2_TABLE_100();
303: a4 := JTF_VARCHAR2_TABLE_200();
304: a5 := JTF_VARCHAR2_TABLE_2000();
305: a6 := JTF_NUMBER_TABLE();
306: a7 := JTF_DATE_TABLE();
307: a8 := JTF_NUMBER_TABLE();
308: a9 := JTF_DATE_TABLE();
309: a10 := JTF_NUMBER_TABLE();

Line 307: a8 := JTF_NUMBER_TABLE();

303: a4 := JTF_VARCHAR2_TABLE_200();
304: a5 := JTF_VARCHAR2_TABLE_2000();
305: a6 := JTF_NUMBER_TABLE();
306: a7 := JTF_DATE_TABLE();
307: a8 := JTF_NUMBER_TABLE();
308: a9 := JTF_DATE_TABLE();
309: a10 := JTF_NUMBER_TABLE();
310: if t.count > 0 then
311: a0.extend(t.count);

Line 309: a10 := JTF_NUMBER_TABLE();

305: a6 := JTF_NUMBER_TABLE();
306: a7 := JTF_DATE_TABLE();
307: a8 := JTF_NUMBER_TABLE();
308: a9 := JTF_DATE_TABLE();
309: a10 := JTF_NUMBER_TABLE();
310: if t.count > 0 then
311: a0.extend(t.count);
312: a1.extend(t.count);
313: a2.extend(t.count);

Line 346: procedure rosetta_table_copy_in_p8(t out nocopy okl_ilt_pvt.iltv_tbl_type, a0 JTF_NUMBER_TABLE

342: end if;
343: end if;
344: end rosetta_table_copy_out_p5;
345:
346: procedure rosetta_table_copy_in_p8(t out nocopy okl_ilt_pvt.iltv_tbl_type, a0 JTF_NUMBER_TABLE
347: , a1 JTF_NUMBER_TABLE
348: , a2 JTF_VARCHAR2_TABLE_100
349: , a3 JTF_NUMBER_TABLE
350: , a4 JTF_NUMBER_TABLE

Line 347: , a1 JTF_NUMBER_TABLE

343: end if;
344: end rosetta_table_copy_out_p5;
345:
346: procedure rosetta_table_copy_in_p8(t out nocopy okl_ilt_pvt.iltv_tbl_type, a0 JTF_NUMBER_TABLE
347: , a1 JTF_NUMBER_TABLE
348: , a2 JTF_VARCHAR2_TABLE_100
349: , a3 JTF_NUMBER_TABLE
350: , a4 JTF_NUMBER_TABLE
351: , a5 JTF_VARCHAR2_TABLE_200

Line 349: , a3 JTF_NUMBER_TABLE

345:
346: procedure rosetta_table_copy_in_p8(t out nocopy okl_ilt_pvt.iltv_tbl_type, a0 JTF_NUMBER_TABLE
347: , a1 JTF_NUMBER_TABLE
348: , a2 JTF_VARCHAR2_TABLE_100
349: , a3 JTF_NUMBER_TABLE
350: , a4 JTF_NUMBER_TABLE
351: , a5 JTF_VARCHAR2_TABLE_200
352: , a6 JTF_VARCHAR2_TABLE_2000
353: , a7 JTF_VARCHAR2_TABLE_100

Line 350: , a4 JTF_NUMBER_TABLE

346: procedure rosetta_table_copy_in_p8(t out nocopy okl_ilt_pvt.iltv_tbl_type, a0 JTF_NUMBER_TABLE
347: , a1 JTF_NUMBER_TABLE
348: , a2 JTF_VARCHAR2_TABLE_100
349: , a3 JTF_NUMBER_TABLE
350: , a4 JTF_NUMBER_TABLE
351: , a5 JTF_VARCHAR2_TABLE_200
352: , a6 JTF_VARCHAR2_TABLE_2000
353: , a7 JTF_VARCHAR2_TABLE_100
354: , a8 JTF_VARCHAR2_TABLE_500

Line 369: , a23 JTF_NUMBER_TABLE

365: , a19 JTF_VARCHAR2_TABLE_500
366: , a20 JTF_VARCHAR2_TABLE_500
367: , a21 JTF_VARCHAR2_TABLE_500
368: , a22 JTF_VARCHAR2_TABLE_500
369: , a23 JTF_NUMBER_TABLE
370: , a24 JTF_DATE_TABLE
371: , a25 JTF_NUMBER_TABLE
372: , a26 JTF_DATE_TABLE
373: , a27 JTF_NUMBER_TABLE

Line 371: , a25 JTF_NUMBER_TABLE

367: , a21 JTF_VARCHAR2_TABLE_500
368: , a22 JTF_VARCHAR2_TABLE_500
369: , a23 JTF_NUMBER_TABLE
370: , a24 JTF_DATE_TABLE
371: , a25 JTF_NUMBER_TABLE
372: , a26 JTF_DATE_TABLE
373: , a27 JTF_NUMBER_TABLE
374: ) as
375: ddindx binary_integer; indx binary_integer;

Line 373: , a27 JTF_NUMBER_TABLE

369: , a23 JTF_NUMBER_TABLE
370: , a24 JTF_DATE_TABLE
371: , a25 JTF_NUMBER_TABLE
372: , a26 JTF_DATE_TABLE
373: , a27 JTF_NUMBER_TABLE
374: ) as
375: ddindx binary_integer; indx binary_integer;
376: begin
377: if a0 is not null and a0.count > 0 then

Line 419: procedure rosetta_table_copy_out_p8(t okl_ilt_pvt.iltv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

415: end loop;
416: end if;
417: end if;
418: end rosetta_table_copy_in_p8;
419: procedure rosetta_table_copy_out_p8(t okl_ilt_pvt.iltv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
420: , a1 out nocopy JTF_NUMBER_TABLE
421: , a2 out nocopy JTF_VARCHAR2_TABLE_100
422: , a3 out nocopy JTF_NUMBER_TABLE
423: , a4 out nocopy JTF_NUMBER_TABLE

Line 420: , a1 out nocopy JTF_NUMBER_TABLE

416: end if;
417: end if;
418: end rosetta_table_copy_in_p8;
419: procedure rosetta_table_copy_out_p8(t okl_ilt_pvt.iltv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
420: , a1 out nocopy JTF_NUMBER_TABLE
421: , a2 out nocopy JTF_VARCHAR2_TABLE_100
422: , a3 out nocopy JTF_NUMBER_TABLE
423: , a4 out nocopy JTF_NUMBER_TABLE
424: , a5 out nocopy JTF_VARCHAR2_TABLE_200

Line 422: , a3 out nocopy JTF_NUMBER_TABLE

418: end rosetta_table_copy_in_p8;
419: procedure rosetta_table_copy_out_p8(t okl_ilt_pvt.iltv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
420: , a1 out nocopy JTF_NUMBER_TABLE
421: , a2 out nocopy JTF_VARCHAR2_TABLE_100
422: , a3 out nocopy JTF_NUMBER_TABLE
423: , a4 out nocopy JTF_NUMBER_TABLE
424: , a5 out nocopy JTF_VARCHAR2_TABLE_200
425: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
426: , a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 423: , a4 out nocopy JTF_NUMBER_TABLE

419: procedure rosetta_table_copy_out_p8(t okl_ilt_pvt.iltv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
420: , a1 out nocopy JTF_NUMBER_TABLE
421: , a2 out nocopy JTF_VARCHAR2_TABLE_100
422: , a3 out nocopy JTF_NUMBER_TABLE
423: , a4 out nocopy JTF_NUMBER_TABLE
424: , a5 out nocopy JTF_VARCHAR2_TABLE_200
425: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
426: , a7 out nocopy JTF_VARCHAR2_TABLE_100
427: , a8 out nocopy JTF_VARCHAR2_TABLE_500

Line 442: , a23 out nocopy JTF_NUMBER_TABLE

438: , a19 out nocopy JTF_VARCHAR2_TABLE_500
439: , a20 out nocopy JTF_VARCHAR2_TABLE_500
440: , a21 out nocopy JTF_VARCHAR2_TABLE_500
441: , a22 out nocopy JTF_VARCHAR2_TABLE_500
442: , a23 out nocopy JTF_NUMBER_TABLE
443: , a24 out nocopy JTF_DATE_TABLE
444: , a25 out nocopy JTF_NUMBER_TABLE
445: , a26 out nocopy JTF_DATE_TABLE
446: , a27 out nocopy JTF_NUMBER_TABLE

Line 444: , a25 out nocopy JTF_NUMBER_TABLE

440: , a21 out nocopy JTF_VARCHAR2_TABLE_500
441: , a22 out nocopy JTF_VARCHAR2_TABLE_500
442: , a23 out nocopy JTF_NUMBER_TABLE
443: , a24 out nocopy JTF_DATE_TABLE
444: , a25 out nocopy JTF_NUMBER_TABLE
445: , a26 out nocopy JTF_DATE_TABLE
446: , a27 out nocopy JTF_NUMBER_TABLE
447: ) as
448: ddindx binary_integer; indx binary_integer;

Line 446: , a27 out nocopy JTF_NUMBER_TABLE

442: , a23 out nocopy JTF_NUMBER_TABLE
443: , a24 out nocopy JTF_DATE_TABLE
444: , a25 out nocopy JTF_NUMBER_TABLE
445: , a26 out nocopy JTF_DATE_TABLE
446: , a27 out nocopy JTF_NUMBER_TABLE
447: ) as
448: ddindx binary_integer; indx binary_integer;
449: begin
450: if t is null or t.count = 0 then

Line 451: a0 := JTF_NUMBER_TABLE();

447: ) as
448: ddindx binary_integer; indx binary_integer;
449: begin
450: if t is null or t.count = 0 then
451: a0 := JTF_NUMBER_TABLE();
452: a1 := JTF_NUMBER_TABLE();
453: a2 := JTF_VARCHAR2_TABLE_100();
454: a3 := JTF_NUMBER_TABLE();
455: a4 := JTF_NUMBER_TABLE();

Line 452: a1 := JTF_NUMBER_TABLE();

448: ddindx binary_integer; indx binary_integer;
449: begin
450: if t is null or t.count = 0 then
451: a0 := JTF_NUMBER_TABLE();
452: a1 := JTF_NUMBER_TABLE();
453: a2 := JTF_VARCHAR2_TABLE_100();
454: a3 := JTF_NUMBER_TABLE();
455: a4 := JTF_NUMBER_TABLE();
456: a5 := JTF_VARCHAR2_TABLE_200();

Line 454: a3 := JTF_NUMBER_TABLE();

450: if t is null or t.count = 0 then
451: a0 := JTF_NUMBER_TABLE();
452: a1 := JTF_NUMBER_TABLE();
453: a2 := JTF_VARCHAR2_TABLE_100();
454: a3 := JTF_NUMBER_TABLE();
455: a4 := JTF_NUMBER_TABLE();
456: a5 := JTF_VARCHAR2_TABLE_200();
457: a6 := JTF_VARCHAR2_TABLE_2000();
458: a7 := JTF_VARCHAR2_TABLE_100();

Line 455: a4 := JTF_NUMBER_TABLE();

451: a0 := JTF_NUMBER_TABLE();
452: a1 := JTF_NUMBER_TABLE();
453: a2 := JTF_VARCHAR2_TABLE_100();
454: a3 := JTF_NUMBER_TABLE();
455: a4 := JTF_NUMBER_TABLE();
456: a5 := JTF_VARCHAR2_TABLE_200();
457: a6 := JTF_VARCHAR2_TABLE_2000();
458: a7 := JTF_VARCHAR2_TABLE_100();
459: a8 := JTF_VARCHAR2_TABLE_500();

Line 474: a23 := JTF_NUMBER_TABLE();

470: a19 := JTF_VARCHAR2_TABLE_500();
471: a20 := JTF_VARCHAR2_TABLE_500();
472: a21 := JTF_VARCHAR2_TABLE_500();
473: a22 := JTF_VARCHAR2_TABLE_500();
474: a23 := JTF_NUMBER_TABLE();
475: a24 := JTF_DATE_TABLE();
476: a25 := JTF_NUMBER_TABLE();
477: a26 := JTF_DATE_TABLE();
478: a27 := JTF_NUMBER_TABLE();

Line 476: a25 := JTF_NUMBER_TABLE();

472: a21 := JTF_VARCHAR2_TABLE_500();
473: a22 := JTF_VARCHAR2_TABLE_500();
474: a23 := JTF_NUMBER_TABLE();
475: a24 := JTF_DATE_TABLE();
476: a25 := JTF_NUMBER_TABLE();
477: a26 := JTF_DATE_TABLE();
478: a27 := JTF_NUMBER_TABLE();
479: else
480: a0 := JTF_NUMBER_TABLE();

Line 478: a27 := JTF_NUMBER_TABLE();

474: a23 := JTF_NUMBER_TABLE();
475: a24 := JTF_DATE_TABLE();
476: a25 := JTF_NUMBER_TABLE();
477: a26 := JTF_DATE_TABLE();
478: a27 := JTF_NUMBER_TABLE();
479: else
480: a0 := JTF_NUMBER_TABLE();
481: a1 := JTF_NUMBER_TABLE();
482: a2 := JTF_VARCHAR2_TABLE_100();

Line 480: a0 := JTF_NUMBER_TABLE();

476: a25 := JTF_NUMBER_TABLE();
477: a26 := JTF_DATE_TABLE();
478: a27 := JTF_NUMBER_TABLE();
479: else
480: a0 := JTF_NUMBER_TABLE();
481: a1 := JTF_NUMBER_TABLE();
482: a2 := JTF_VARCHAR2_TABLE_100();
483: a3 := JTF_NUMBER_TABLE();
484: a4 := JTF_NUMBER_TABLE();

Line 481: a1 := JTF_NUMBER_TABLE();

477: a26 := JTF_DATE_TABLE();
478: a27 := JTF_NUMBER_TABLE();
479: else
480: a0 := JTF_NUMBER_TABLE();
481: a1 := JTF_NUMBER_TABLE();
482: a2 := JTF_VARCHAR2_TABLE_100();
483: a3 := JTF_NUMBER_TABLE();
484: a4 := JTF_NUMBER_TABLE();
485: a5 := JTF_VARCHAR2_TABLE_200();

Line 483: a3 := JTF_NUMBER_TABLE();

479: else
480: a0 := JTF_NUMBER_TABLE();
481: a1 := JTF_NUMBER_TABLE();
482: a2 := JTF_VARCHAR2_TABLE_100();
483: a3 := JTF_NUMBER_TABLE();
484: a4 := JTF_NUMBER_TABLE();
485: a5 := JTF_VARCHAR2_TABLE_200();
486: a6 := JTF_VARCHAR2_TABLE_2000();
487: a7 := JTF_VARCHAR2_TABLE_100();

Line 484: a4 := JTF_NUMBER_TABLE();

480: a0 := JTF_NUMBER_TABLE();
481: a1 := JTF_NUMBER_TABLE();
482: a2 := JTF_VARCHAR2_TABLE_100();
483: a3 := JTF_NUMBER_TABLE();
484: a4 := JTF_NUMBER_TABLE();
485: a5 := JTF_VARCHAR2_TABLE_200();
486: a6 := JTF_VARCHAR2_TABLE_2000();
487: a7 := JTF_VARCHAR2_TABLE_100();
488: a8 := JTF_VARCHAR2_TABLE_500();

Line 503: a23 := JTF_NUMBER_TABLE();

499: a19 := JTF_VARCHAR2_TABLE_500();
500: a20 := JTF_VARCHAR2_TABLE_500();
501: a21 := JTF_VARCHAR2_TABLE_500();
502: a22 := JTF_VARCHAR2_TABLE_500();
503: a23 := JTF_NUMBER_TABLE();
504: a24 := JTF_DATE_TABLE();
505: a25 := JTF_NUMBER_TABLE();
506: a26 := JTF_DATE_TABLE();
507: a27 := JTF_NUMBER_TABLE();

Line 505: a25 := JTF_NUMBER_TABLE();

501: a21 := JTF_VARCHAR2_TABLE_500();
502: a22 := JTF_VARCHAR2_TABLE_500();
503: a23 := JTF_NUMBER_TABLE();
504: a24 := JTF_DATE_TABLE();
505: a25 := JTF_NUMBER_TABLE();
506: a26 := JTF_DATE_TABLE();
507: a27 := JTF_NUMBER_TABLE();
508: if t.count > 0 then
509: a0.extend(t.count);

Line 507: a27 := JTF_NUMBER_TABLE();

503: a23 := JTF_NUMBER_TABLE();
504: a24 := JTF_DATE_TABLE();
505: a25 := JTF_NUMBER_TABLE();
506: a26 := JTF_DATE_TABLE();
507: a27 := JTF_NUMBER_TABLE();
508: if t.count > 0 then
509: a0.extend(t.count);
510: a1.extend(t.count);
511: a2.extend(t.count);

Line 734: , p5_a0 JTF_NUMBER_TABLE

730: , p_init_msg_list VARCHAR2
731: , x_return_status out nocopy VARCHAR2
732: , x_msg_count out nocopy NUMBER
733: , x_msg_data out nocopy VARCHAR2
734: , p5_a0 JTF_NUMBER_TABLE
735: , p5_a1 JTF_NUMBER_TABLE
736: , p5_a2 JTF_VARCHAR2_TABLE_100
737: , p5_a3 JTF_NUMBER_TABLE
738: , p5_a4 JTF_NUMBER_TABLE

Line 735: , p5_a1 JTF_NUMBER_TABLE

731: , x_return_status out nocopy VARCHAR2
732: , x_msg_count out nocopy NUMBER
733: , x_msg_data out nocopy VARCHAR2
734: , p5_a0 JTF_NUMBER_TABLE
735: , p5_a1 JTF_NUMBER_TABLE
736: , p5_a2 JTF_VARCHAR2_TABLE_100
737: , p5_a3 JTF_NUMBER_TABLE
738: , p5_a4 JTF_NUMBER_TABLE
739: , p5_a5 JTF_VARCHAR2_TABLE_200

Line 737: , p5_a3 JTF_NUMBER_TABLE

733: , x_msg_data out nocopy VARCHAR2
734: , p5_a0 JTF_NUMBER_TABLE
735: , p5_a1 JTF_NUMBER_TABLE
736: , p5_a2 JTF_VARCHAR2_TABLE_100
737: , p5_a3 JTF_NUMBER_TABLE
738: , p5_a4 JTF_NUMBER_TABLE
739: , p5_a5 JTF_VARCHAR2_TABLE_200
740: , p5_a6 JTF_VARCHAR2_TABLE_2000
741: , p5_a7 JTF_VARCHAR2_TABLE_100

Line 738: , p5_a4 JTF_NUMBER_TABLE

734: , p5_a0 JTF_NUMBER_TABLE
735: , p5_a1 JTF_NUMBER_TABLE
736: , p5_a2 JTF_VARCHAR2_TABLE_100
737: , p5_a3 JTF_NUMBER_TABLE
738: , p5_a4 JTF_NUMBER_TABLE
739: , p5_a5 JTF_VARCHAR2_TABLE_200
740: , p5_a6 JTF_VARCHAR2_TABLE_2000
741: , p5_a7 JTF_VARCHAR2_TABLE_100
742: , p5_a8 JTF_VARCHAR2_TABLE_500

Line 757: , p5_a23 JTF_NUMBER_TABLE

753: , p5_a19 JTF_VARCHAR2_TABLE_500
754: , p5_a20 JTF_VARCHAR2_TABLE_500
755: , p5_a21 JTF_VARCHAR2_TABLE_500
756: , p5_a22 JTF_VARCHAR2_TABLE_500
757: , p5_a23 JTF_NUMBER_TABLE
758: , p5_a24 JTF_DATE_TABLE
759: , p5_a25 JTF_NUMBER_TABLE
760: , p5_a26 JTF_DATE_TABLE
761: , p5_a27 JTF_NUMBER_TABLE

Line 759: , p5_a25 JTF_NUMBER_TABLE

755: , p5_a21 JTF_VARCHAR2_TABLE_500
756: , p5_a22 JTF_VARCHAR2_TABLE_500
757: , p5_a23 JTF_NUMBER_TABLE
758: , p5_a24 JTF_DATE_TABLE
759: , p5_a25 JTF_NUMBER_TABLE
760: , p5_a26 JTF_DATE_TABLE
761: , p5_a27 JTF_NUMBER_TABLE
762: , p6_a0 out nocopy JTF_NUMBER_TABLE
763: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 761: , p5_a27 JTF_NUMBER_TABLE

757: , p5_a23 JTF_NUMBER_TABLE
758: , p5_a24 JTF_DATE_TABLE
759: , p5_a25 JTF_NUMBER_TABLE
760: , p5_a26 JTF_DATE_TABLE
761: , p5_a27 JTF_NUMBER_TABLE
762: , p6_a0 out nocopy JTF_NUMBER_TABLE
763: , p6_a1 out nocopy JTF_NUMBER_TABLE
764: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
765: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 762: , p6_a0 out nocopy JTF_NUMBER_TABLE

758: , p5_a24 JTF_DATE_TABLE
759: , p5_a25 JTF_NUMBER_TABLE
760: , p5_a26 JTF_DATE_TABLE
761: , p5_a27 JTF_NUMBER_TABLE
762: , p6_a0 out nocopy JTF_NUMBER_TABLE
763: , p6_a1 out nocopy JTF_NUMBER_TABLE
764: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
765: , p6_a3 out nocopy JTF_NUMBER_TABLE
766: , p6_a4 out nocopy JTF_NUMBER_TABLE

Line 763: , p6_a1 out nocopy JTF_NUMBER_TABLE

759: , p5_a25 JTF_NUMBER_TABLE
760: , p5_a26 JTF_DATE_TABLE
761: , p5_a27 JTF_NUMBER_TABLE
762: , p6_a0 out nocopy JTF_NUMBER_TABLE
763: , p6_a1 out nocopy JTF_NUMBER_TABLE
764: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
765: , p6_a3 out nocopy JTF_NUMBER_TABLE
766: , p6_a4 out nocopy JTF_NUMBER_TABLE
767: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200

Line 765: , p6_a3 out nocopy JTF_NUMBER_TABLE

761: , p5_a27 JTF_NUMBER_TABLE
762: , p6_a0 out nocopy JTF_NUMBER_TABLE
763: , p6_a1 out nocopy JTF_NUMBER_TABLE
764: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
765: , p6_a3 out nocopy JTF_NUMBER_TABLE
766: , p6_a4 out nocopy JTF_NUMBER_TABLE
767: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
768: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
769: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 766: , p6_a4 out nocopy JTF_NUMBER_TABLE

762: , p6_a0 out nocopy JTF_NUMBER_TABLE
763: , p6_a1 out nocopy JTF_NUMBER_TABLE
764: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
765: , p6_a3 out nocopy JTF_NUMBER_TABLE
766: , p6_a4 out nocopy JTF_NUMBER_TABLE
767: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
768: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
769: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
770: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500

Line 785: , p6_a23 out nocopy JTF_NUMBER_TABLE

781: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
782: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
783: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
784: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
785: , p6_a23 out nocopy JTF_NUMBER_TABLE
786: , p6_a24 out nocopy JTF_DATE_TABLE
787: , p6_a25 out nocopy JTF_NUMBER_TABLE
788: , p6_a26 out nocopy JTF_DATE_TABLE
789: , p6_a27 out nocopy JTF_NUMBER_TABLE

Line 787: , p6_a25 out nocopy JTF_NUMBER_TABLE

783: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
784: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
785: , p6_a23 out nocopy JTF_NUMBER_TABLE
786: , p6_a24 out nocopy JTF_DATE_TABLE
787: , p6_a25 out nocopy JTF_NUMBER_TABLE
788: , p6_a26 out nocopy JTF_DATE_TABLE
789: , p6_a27 out nocopy JTF_NUMBER_TABLE
790: )
791:

Line 789: , p6_a27 out nocopy JTF_NUMBER_TABLE

785: , p6_a23 out nocopy JTF_NUMBER_TABLE
786: , p6_a24 out nocopy JTF_DATE_TABLE
787: , p6_a25 out nocopy JTF_NUMBER_TABLE
788: , p6_a26 out nocopy JTF_DATE_TABLE
789: , p6_a27 out nocopy JTF_NUMBER_TABLE
790: )
791:
792: as
793: ddp_iltv_tbl okl_ilt_pvt.iltv_tbl_type;

Line 978: , p5_a0 JTF_NUMBER_TABLE

974: , p_init_msg_list VARCHAR2
975: , x_return_status out nocopy VARCHAR2
976: , x_msg_count out nocopy NUMBER
977: , x_msg_data out nocopy VARCHAR2
978: , p5_a0 JTF_NUMBER_TABLE
979: , p5_a1 JTF_NUMBER_TABLE
980: , p5_a2 JTF_VARCHAR2_TABLE_100
981: , p5_a3 JTF_NUMBER_TABLE
982: , p5_a4 JTF_NUMBER_TABLE

Line 979: , p5_a1 JTF_NUMBER_TABLE

975: , x_return_status out nocopy VARCHAR2
976: , x_msg_count out nocopy NUMBER
977: , x_msg_data out nocopy VARCHAR2
978: , p5_a0 JTF_NUMBER_TABLE
979: , p5_a1 JTF_NUMBER_TABLE
980: , p5_a2 JTF_VARCHAR2_TABLE_100
981: , p5_a3 JTF_NUMBER_TABLE
982: , p5_a4 JTF_NUMBER_TABLE
983: , p5_a5 JTF_VARCHAR2_TABLE_200

Line 981: , p5_a3 JTF_NUMBER_TABLE

977: , x_msg_data out nocopy VARCHAR2
978: , p5_a0 JTF_NUMBER_TABLE
979: , p5_a1 JTF_NUMBER_TABLE
980: , p5_a2 JTF_VARCHAR2_TABLE_100
981: , p5_a3 JTF_NUMBER_TABLE
982: , p5_a4 JTF_NUMBER_TABLE
983: , p5_a5 JTF_VARCHAR2_TABLE_200
984: , p5_a6 JTF_VARCHAR2_TABLE_2000
985: , p5_a7 JTF_VARCHAR2_TABLE_100

Line 982: , p5_a4 JTF_NUMBER_TABLE

978: , p5_a0 JTF_NUMBER_TABLE
979: , p5_a1 JTF_NUMBER_TABLE
980: , p5_a2 JTF_VARCHAR2_TABLE_100
981: , p5_a3 JTF_NUMBER_TABLE
982: , p5_a4 JTF_NUMBER_TABLE
983: , p5_a5 JTF_VARCHAR2_TABLE_200
984: , p5_a6 JTF_VARCHAR2_TABLE_2000
985: , p5_a7 JTF_VARCHAR2_TABLE_100
986: , p5_a8 JTF_VARCHAR2_TABLE_500

Line 1001: , p5_a23 JTF_NUMBER_TABLE

997: , p5_a19 JTF_VARCHAR2_TABLE_500
998: , p5_a20 JTF_VARCHAR2_TABLE_500
999: , p5_a21 JTF_VARCHAR2_TABLE_500
1000: , p5_a22 JTF_VARCHAR2_TABLE_500
1001: , p5_a23 JTF_NUMBER_TABLE
1002: , p5_a24 JTF_DATE_TABLE
1003: , p5_a25 JTF_NUMBER_TABLE
1004: , p5_a26 JTF_DATE_TABLE
1005: , p5_a27 JTF_NUMBER_TABLE

Line 1003: , p5_a25 JTF_NUMBER_TABLE

999: , p5_a21 JTF_VARCHAR2_TABLE_500
1000: , p5_a22 JTF_VARCHAR2_TABLE_500
1001: , p5_a23 JTF_NUMBER_TABLE
1002: , p5_a24 JTF_DATE_TABLE
1003: , p5_a25 JTF_NUMBER_TABLE
1004: , p5_a26 JTF_DATE_TABLE
1005: , p5_a27 JTF_NUMBER_TABLE
1006: )
1007:

Line 1005: , p5_a27 JTF_NUMBER_TABLE

1001: , p5_a23 JTF_NUMBER_TABLE
1002: , p5_a24 JTF_DATE_TABLE
1003: , p5_a25 JTF_NUMBER_TABLE
1004: , p5_a26 JTF_DATE_TABLE
1005: , p5_a27 JTF_NUMBER_TABLE
1006: )
1007:
1008: as
1009: ddp_iltv_tbl okl_ilt_pvt.iltv_tbl_type;

Line 1221: , p5_a0 JTF_NUMBER_TABLE

1217: , p_init_msg_list VARCHAR2
1218: , x_return_status out nocopy VARCHAR2
1219: , x_msg_count out nocopy NUMBER
1220: , x_msg_data out nocopy VARCHAR2
1221: , p5_a0 JTF_NUMBER_TABLE
1222: , p5_a1 JTF_NUMBER_TABLE
1223: , p5_a2 JTF_VARCHAR2_TABLE_100
1224: , p5_a3 JTF_NUMBER_TABLE
1225: , p5_a4 JTF_NUMBER_TABLE

Line 1222: , p5_a1 JTF_NUMBER_TABLE

1218: , x_return_status out nocopy VARCHAR2
1219: , x_msg_count out nocopy NUMBER
1220: , x_msg_data out nocopy VARCHAR2
1221: , p5_a0 JTF_NUMBER_TABLE
1222: , p5_a1 JTF_NUMBER_TABLE
1223: , p5_a2 JTF_VARCHAR2_TABLE_100
1224: , p5_a3 JTF_NUMBER_TABLE
1225: , p5_a4 JTF_NUMBER_TABLE
1226: , p5_a5 JTF_VARCHAR2_TABLE_200

Line 1224: , p5_a3 JTF_NUMBER_TABLE

1220: , x_msg_data out nocopy VARCHAR2
1221: , p5_a0 JTF_NUMBER_TABLE
1222: , p5_a1 JTF_NUMBER_TABLE
1223: , p5_a2 JTF_VARCHAR2_TABLE_100
1224: , p5_a3 JTF_NUMBER_TABLE
1225: , p5_a4 JTF_NUMBER_TABLE
1226: , p5_a5 JTF_VARCHAR2_TABLE_200
1227: , p5_a6 JTF_VARCHAR2_TABLE_2000
1228: , p5_a7 JTF_VARCHAR2_TABLE_100

Line 1225: , p5_a4 JTF_NUMBER_TABLE

1221: , p5_a0 JTF_NUMBER_TABLE
1222: , p5_a1 JTF_NUMBER_TABLE
1223: , p5_a2 JTF_VARCHAR2_TABLE_100
1224: , p5_a3 JTF_NUMBER_TABLE
1225: , p5_a4 JTF_NUMBER_TABLE
1226: , p5_a5 JTF_VARCHAR2_TABLE_200
1227: , p5_a6 JTF_VARCHAR2_TABLE_2000
1228: , p5_a7 JTF_VARCHAR2_TABLE_100
1229: , p5_a8 JTF_VARCHAR2_TABLE_500

Line 1244: , p5_a23 JTF_NUMBER_TABLE

1240: , p5_a19 JTF_VARCHAR2_TABLE_500
1241: , p5_a20 JTF_VARCHAR2_TABLE_500
1242: , p5_a21 JTF_VARCHAR2_TABLE_500
1243: , p5_a22 JTF_VARCHAR2_TABLE_500
1244: , p5_a23 JTF_NUMBER_TABLE
1245: , p5_a24 JTF_DATE_TABLE
1246: , p5_a25 JTF_NUMBER_TABLE
1247: , p5_a26 JTF_DATE_TABLE
1248: , p5_a27 JTF_NUMBER_TABLE

Line 1246: , p5_a25 JTF_NUMBER_TABLE

1242: , p5_a21 JTF_VARCHAR2_TABLE_500
1243: , p5_a22 JTF_VARCHAR2_TABLE_500
1244: , p5_a23 JTF_NUMBER_TABLE
1245: , p5_a24 JTF_DATE_TABLE
1246: , p5_a25 JTF_NUMBER_TABLE
1247: , p5_a26 JTF_DATE_TABLE
1248: , p5_a27 JTF_NUMBER_TABLE
1249: , p6_a0 out nocopy JTF_NUMBER_TABLE
1250: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 1248: , p5_a27 JTF_NUMBER_TABLE

1244: , p5_a23 JTF_NUMBER_TABLE
1245: , p5_a24 JTF_DATE_TABLE
1246: , p5_a25 JTF_NUMBER_TABLE
1247: , p5_a26 JTF_DATE_TABLE
1248: , p5_a27 JTF_NUMBER_TABLE
1249: , p6_a0 out nocopy JTF_NUMBER_TABLE
1250: , p6_a1 out nocopy JTF_NUMBER_TABLE
1251: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1252: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 1249: , p6_a0 out nocopy JTF_NUMBER_TABLE

1245: , p5_a24 JTF_DATE_TABLE
1246: , p5_a25 JTF_NUMBER_TABLE
1247: , p5_a26 JTF_DATE_TABLE
1248: , p5_a27 JTF_NUMBER_TABLE
1249: , p6_a0 out nocopy JTF_NUMBER_TABLE
1250: , p6_a1 out nocopy JTF_NUMBER_TABLE
1251: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1252: , p6_a3 out nocopy JTF_NUMBER_TABLE
1253: , p6_a4 out nocopy JTF_NUMBER_TABLE

Line 1250: , p6_a1 out nocopy JTF_NUMBER_TABLE

1246: , p5_a25 JTF_NUMBER_TABLE
1247: , p5_a26 JTF_DATE_TABLE
1248: , p5_a27 JTF_NUMBER_TABLE
1249: , p6_a0 out nocopy JTF_NUMBER_TABLE
1250: , p6_a1 out nocopy JTF_NUMBER_TABLE
1251: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1252: , p6_a3 out nocopy JTF_NUMBER_TABLE
1253: , p6_a4 out nocopy JTF_NUMBER_TABLE
1254: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200

Line 1252: , p6_a3 out nocopy JTF_NUMBER_TABLE

1248: , p5_a27 JTF_NUMBER_TABLE
1249: , p6_a0 out nocopy JTF_NUMBER_TABLE
1250: , p6_a1 out nocopy JTF_NUMBER_TABLE
1251: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1252: , p6_a3 out nocopy JTF_NUMBER_TABLE
1253: , p6_a4 out nocopy JTF_NUMBER_TABLE
1254: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
1255: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
1256: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 1253: , p6_a4 out nocopy JTF_NUMBER_TABLE

1249: , p6_a0 out nocopy JTF_NUMBER_TABLE
1250: , p6_a1 out nocopy JTF_NUMBER_TABLE
1251: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1252: , p6_a3 out nocopy JTF_NUMBER_TABLE
1253: , p6_a4 out nocopy JTF_NUMBER_TABLE
1254: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
1255: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
1256: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
1257: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500

Line 1272: , p6_a23 out nocopy JTF_NUMBER_TABLE

1268: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
1269: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
1270: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
1271: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
1272: , p6_a23 out nocopy JTF_NUMBER_TABLE
1273: , p6_a24 out nocopy JTF_DATE_TABLE
1274: , p6_a25 out nocopy JTF_NUMBER_TABLE
1275: , p6_a26 out nocopy JTF_DATE_TABLE
1276: , p6_a27 out nocopy JTF_NUMBER_TABLE

Line 1274: , p6_a25 out nocopy JTF_NUMBER_TABLE

1270: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
1271: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
1272: , p6_a23 out nocopy JTF_NUMBER_TABLE
1273: , p6_a24 out nocopy JTF_DATE_TABLE
1274: , p6_a25 out nocopy JTF_NUMBER_TABLE
1275: , p6_a26 out nocopy JTF_DATE_TABLE
1276: , p6_a27 out nocopy JTF_NUMBER_TABLE
1277: )
1278:

Line 1276: , p6_a27 out nocopy JTF_NUMBER_TABLE

1272: , p6_a23 out nocopy JTF_NUMBER_TABLE
1273: , p6_a24 out nocopy JTF_DATE_TABLE
1274: , p6_a25 out nocopy JTF_NUMBER_TABLE
1275: , p6_a26 out nocopy JTF_DATE_TABLE
1276: , p6_a27 out nocopy JTF_NUMBER_TABLE
1277: )
1278:
1279: as
1280: ddp_iltv_tbl okl_ilt_pvt.iltv_tbl_type;

Line 1465: , p5_a0 JTF_NUMBER_TABLE

1461: , p_init_msg_list VARCHAR2
1462: , x_return_status out nocopy VARCHAR2
1463: , x_msg_count out nocopy NUMBER
1464: , x_msg_data out nocopy VARCHAR2
1465: , p5_a0 JTF_NUMBER_TABLE
1466: , p5_a1 JTF_NUMBER_TABLE
1467: , p5_a2 JTF_VARCHAR2_TABLE_100
1468: , p5_a3 JTF_NUMBER_TABLE
1469: , p5_a4 JTF_NUMBER_TABLE

Line 1466: , p5_a1 JTF_NUMBER_TABLE

1462: , x_return_status out nocopy VARCHAR2
1463: , x_msg_count out nocopy NUMBER
1464: , x_msg_data out nocopy VARCHAR2
1465: , p5_a0 JTF_NUMBER_TABLE
1466: , p5_a1 JTF_NUMBER_TABLE
1467: , p5_a2 JTF_VARCHAR2_TABLE_100
1468: , p5_a3 JTF_NUMBER_TABLE
1469: , p5_a4 JTF_NUMBER_TABLE
1470: , p5_a5 JTF_VARCHAR2_TABLE_200

Line 1468: , p5_a3 JTF_NUMBER_TABLE

1464: , x_msg_data out nocopy VARCHAR2
1465: , p5_a0 JTF_NUMBER_TABLE
1466: , p5_a1 JTF_NUMBER_TABLE
1467: , p5_a2 JTF_VARCHAR2_TABLE_100
1468: , p5_a3 JTF_NUMBER_TABLE
1469: , p5_a4 JTF_NUMBER_TABLE
1470: , p5_a5 JTF_VARCHAR2_TABLE_200
1471: , p5_a6 JTF_VARCHAR2_TABLE_2000
1472: , p5_a7 JTF_VARCHAR2_TABLE_100

Line 1469: , p5_a4 JTF_NUMBER_TABLE

1465: , p5_a0 JTF_NUMBER_TABLE
1466: , p5_a1 JTF_NUMBER_TABLE
1467: , p5_a2 JTF_VARCHAR2_TABLE_100
1468: , p5_a3 JTF_NUMBER_TABLE
1469: , p5_a4 JTF_NUMBER_TABLE
1470: , p5_a5 JTF_VARCHAR2_TABLE_200
1471: , p5_a6 JTF_VARCHAR2_TABLE_2000
1472: , p5_a7 JTF_VARCHAR2_TABLE_100
1473: , p5_a8 JTF_VARCHAR2_TABLE_500

Line 1488: , p5_a23 JTF_NUMBER_TABLE

1484: , p5_a19 JTF_VARCHAR2_TABLE_500
1485: , p5_a20 JTF_VARCHAR2_TABLE_500
1486: , p5_a21 JTF_VARCHAR2_TABLE_500
1487: , p5_a22 JTF_VARCHAR2_TABLE_500
1488: , p5_a23 JTF_NUMBER_TABLE
1489: , p5_a24 JTF_DATE_TABLE
1490: , p5_a25 JTF_NUMBER_TABLE
1491: , p5_a26 JTF_DATE_TABLE
1492: , p5_a27 JTF_NUMBER_TABLE

Line 1490: , p5_a25 JTF_NUMBER_TABLE

1486: , p5_a21 JTF_VARCHAR2_TABLE_500
1487: , p5_a22 JTF_VARCHAR2_TABLE_500
1488: , p5_a23 JTF_NUMBER_TABLE
1489: , p5_a24 JTF_DATE_TABLE
1490: , p5_a25 JTF_NUMBER_TABLE
1491: , p5_a26 JTF_DATE_TABLE
1492: , p5_a27 JTF_NUMBER_TABLE
1493: )
1494:

Line 1492: , p5_a27 JTF_NUMBER_TABLE

1488: , p5_a23 JTF_NUMBER_TABLE
1489: , p5_a24 JTF_DATE_TABLE
1490: , p5_a25 JTF_NUMBER_TABLE
1491: , p5_a26 JTF_DATE_TABLE
1492: , p5_a27 JTF_NUMBER_TABLE
1493: )
1494:
1495: as
1496: ddp_iltv_tbl okl_ilt_pvt.iltv_tbl_type;

Line 1648: , p5_a0 JTF_NUMBER_TABLE

1644: , p_init_msg_list VARCHAR2
1645: , x_return_status out nocopy VARCHAR2
1646: , x_msg_count out nocopy NUMBER
1647: , x_msg_data out nocopy VARCHAR2
1648: , p5_a0 JTF_NUMBER_TABLE
1649: , p5_a1 JTF_NUMBER_TABLE
1650: , p5_a2 JTF_VARCHAR2_TABLE_100
1651: , p5_a3 JTF_NUMBER_TABLE
1652: , p5_a4 JTF_NUMBER_TABLE

Line 1649: , p5_a1 JTF_NUMBER_TABLE

1645: , x_return_status out nocopy VARCHAR2
1646: , x_msg_count out nocopy NUMBER
1647: , x_msg_data out nocopy VARCHAR2
1648: , p5_a0 JTF_NUMBER_TABLE
1649: , p5_a1 JTF_NUMBER_TABLE
1650: , p5_a2 JTF_VARCHAR2_TABLE_100
1651: , p5_a3 JTF_NUMBER_TABLE
1652: , p5_a4 JTF_NUMBER_TABLE
1653: , p5_a5 JTF_VARCHAR2_TABLE_200

Line 1651: , p5_a3 JTF_NUMBER_TABLE

1647: , x_msg_data out nocopy VARCHAR2
1648: , p5_a0 JTF_NUMBER_TABLE
1649: , p5_a1 JTF_NUMBER_TABLE
1650: , p5_a2 JTF_VARCHAR2_TABLE_100
1651: , p5_a3 JTF_NUMBER_TABLE
1652: , p5_a4 JTF_NUMBER_TABLE
1653: , p5_a5 JTF_VARCHAR2_TABLE_200
1654: , p5_a6 JTF_VARCHAR2_TABLE_2000
1655: , p5_a7 JTF_VARCHAR2_TABLE_100

Line 1652: , p5_a4 JTF_NUMBER_TABLE

1648: , p5_a0 JTF_NUMBER_TABLE
1649: , p5_a1 JTF_NUMBER_TABLE
1650: , p5_a2 JTF_VARCHAR2_TABLE_100
1651: , p5_a3 JTF_NUMBER_TABLE
1652: , p5_a4 JTF_NUMBER_TABLE
1653: , p5_a5 JTF_VARCHAR2_TABLE_200
1654: , p5_a6 JTF_VARCHAR2_TABLE_2000
1655: , p5_a7 JTF_VARCHAR2_TABLE_100
1656: , p5_a8 JTF_VARCHAR2_TABLE_500

Line 1671: , p5_a23 JTF_NUMBER_TABLE

1667: , p5_a19 JTF_VARCHAR2_TABLE_500
1668: , p5_a20 JTF_VARCHAR2_TABLE_500
1669: , p5_a21 JTF_VARCHAR2_TABLE_500
1670: , p5_a22 JTF_VARCHAR2_TABLE_500
1671: , p5_a23 JTF_NUMBER_TABLE
1672: , p5_a24 JTF_DATE_TABLE
1673: , p5_a25 JTF_NUMBER_TABLE
1674: , p5_a26 JTF_DATE_TABLE
1675: , p5_a27 JTF_NUMBER_TABLE

Line 1673: , p5_a25 JTF_NUMBER_TABLE

1669: , p5_a21 JTF_VARCHAR2_TABLE_500
1670: , p5_a22 JTF_VARCHAR2_TABLE_500
1671: , p5_a23 JTF_NUMBER_TABLE
1672: , p5_a24 JTF_DATE_TABLE
1673: , p5_a25 JTF_NUMBER_TABLE
1674: , p5_a26 JTF_DATE_TABLE
1675: , p5_a27 JTF_NUMBER_TABLE
1676: )
1677:

Line 1675: , p5_a27 JTF_NUMBER_TABLE

1671: , p5_a23 JTF_NUMBER_TABLE
1672: , p5_a24 JTF_DATE_TABLE
1673: , p5_a25 JTF_NUMBER_TABLE
1674: , p5_a26 JTF_DATE_TABLE
1675: , p5_a27 JTF_NUMBER_TABLE
1676: )
1677:
1678: as
1679: ddp_iltv_tbl okl_ilt_pvt.iltv_tbl_type;