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

APPS.OKL_SIP_PVT_W dependencies on JTF_NUMBER_TABLE

Line 22: procedure rosetta_table_copy_in_p2(t out nocopy okl_sip_pvt.sipv_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_sip_pvt.sipv_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_VARCHAR2_TABLE_100
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_sip_pvt.sipv_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_VARCHAR2_TABLE_200

Line 34: , a12 JTF_NUMBER_TABLE

30: , a8 JTF_DATE_TABLE
31: , a9 JTF_VARCHAR2_TABLE_100
32: , a10 JTF_VARCHAR2_TABLE_100
33: , a11 JTF_VARCHAR2_TABLE_100
34: , a12 JTF_NUMBER_TABLE
35: , a13 JTF_NUMBER_TABLE
36: , a14 JTF_NUMBER_TABLE
37: , a15 JTF_NUMBER_TABLE
38: , a16 JTF_DATE_TABLE

Line 35: , a13 JTF_NUMBER_TABLE

31: , a9 JTF_VARCHAR2_TABLE_100
32: , a10 JTF_VARCHAR2_TABLE_100
33: , a11 JTF_VARCHAR2_TABLE_100
34: , a12 JTF_NUMBER_TABLE
35: , a13 JTF_NUMBER_TABLE
36: , a14 JTF_NUMBER_TABLE
37: , a15 JTF_NUMBER_TABLE
38: , a16 JTF_DATE_TABLE
39: , a17 JTF_VARCHAR2_TABLE_100

Line 36: , a14 JTF_NUMBER_TABLE

32: , a10 JTF_VARCHAR2_TABLE_100
33: , a11 JTF_VARCHAR2_TABLE_100
34: , a12 JTF_NUMBER_TABLE
35: , a13 JTF_NUMBER_TABLE
36: , a14 JTF_NUMBER_TABLE
37: , a15 JTF_NUMBER_TABLE
38: , a16 JTF_DATE_TABLE
39: , a17 JTF_VARCHAR2_TABLE_100
40: , a18 JTF_VARCHAR2_TABLE_500

Line 37: , a15 JTF_NUMBER_TABLE

33: , a11 JTF_VARCHAR2_TABLE_100
34: , a12 JTF_NUMBER_TABLE
35: , a13 JTF_NUMBER_TABLE
36: , a14 JTF_NUMBER_TABLE
37: , a15 JTF_NUMBER_TABLE
38: , a16 JTF_DATE_TABLE
39: , a17 JTF_VARCHAR2_TABLE_100
40: , a18 JTF_VARCHAR2_TABLE_500
41: , a19 JTF_VARCHAR2_TABLE_500

Line 55: , a33 JTF_NUMBER_TABLE

51: , a29 JTF_VARCHAR2_TABLE_500
52: , a30 JTF_VARCHAR2_TABLE_500
53: , a31 JTF_VARCHAR2_TABLE_500
54: , a32 JTF_VARCHAR2_TABLE_500
55: , a33 JTF_NUMBER_TABLE
56: , a34 JTF_DATE_TABLE
57: , a35 JTF_NUMBER_TABLE
58: , a36 JTF_DATE_TABLE
59: , a37 JTF_NUMBER_TABLE

Line 57: , a35 JTF_NUMBER_TABLE

53: , a31 JTF_VARCHAR2_TABLE_500
54: , a32 JTF_VARCHAR2_TABLE_500
55: , a33 JTF_NUMBER_TABLE
56: , a34 JTF_DATE_TABLE
57: , a35 JTF_NUMBER_TABLE
58: , a36 JTF_DATE_TABLE
59: , a37 JTF_NUMBER_TABLE
60: ) as
61: ddindx binary_integer; indx binary_integer;

Line 59: , a37 JTF_NUMBER_TABLE

55: , a33 JTF_NUMBER_TABLE
56: , a34 JTF_DATE_TABLE
57: , a35 JTF_NUMBER_TABLE
58: , a36 JTF_DATE_TABLE
59: , a37 JTF_NUMBER_TABLE
60: ) as
61: ddindx binary_integer; indx binary_integer;
62: begin
63: if a0 is not null and a0.count > 0 then

Line 115: procedure rosetta_table_copy_out_p2(t okl_sip_pvt.sipv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

111: end loop;
112: end if;
113: end if;
114: end rosetta_table_copy_in_p2;
115: procedure rosetta_table_copy_out_p2(t okl_sip_pvt.sipv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
116: , a1 out nocopy JTF_NUMBER_TABLE
117: , a2 out nocopy JTF_VARCHAR2_TABLE_100
118: , a3 out nocopy JTF_VARCHAR2_TABLE_100
119: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 116: , a1 out nocopy JTF_NUMBER_TABLE

112: end if;
113: end if;
114: end rosetta_table_copy_in_p2;
115: procedure rosetta_table_copy_out_p2(t okl_sip_pvt.sipv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
116: , a1 out nocopy JTF_NUMBER_TABLE
117: , a2 out nocopy JTF_VARCHAR2_TABLE_100
118: , a3 out nocopy JTF_VARCHAR2_TABLE_100
119: , a4 out nocopy JTF_VARCHAR2_TABLE_100
120: , a5 out nocopy JTF_VARCHAR2_TABLE_200

Line 127: , a12 out nocopy JTF_NUMBER_TABLE

123: , a8 out nocopy JTF_DATE_TABLE
124: , a9 out nocopy JTF_VARCHAR2_TABLE_100
125: , a10 out nocopy JTF_VARCHAR2_TABLE_100
126: , a11 out nocopy JTF_VARCHAR2_TABLE_100
127: , a12 out nocopy JTF_NUMBER_TABLE
128: , a13 out nocopy JTF_NUMBER_TABLE
129: , a14 out nocopy JTF_NUMBER_TABLE
130: , a15 out nocopy JTF_NUMBER_TABLE
131: , a16 out nocopy JTF_DATE_TABLE

Line 128: , a13 out nocopy JTF_NUMBER_TABLE

124: , a9 out nocopy JTF_VARCHAR2_TABLE_100
125: , a10 out nocopy JTF_VARCHAR2_TABLE_100
126: , a11 out nocopy JTF_VARCHAR2_TABLE_100
127: , a12 out nocopy JTF_NUMBER_TABLE
128: , a13 out nocopy JTF_NUMBER_TABLE
129: , a14 out nocopy JTF_NUMBER_TABLE
130: , a15 out nocopy JTF_NUMBER_TABLE
131: , a16 out nocopy JTF_DATE_TABLE
132: , a17 out nocopy JTF_VARCHAR2_TABLE_100

Line 129: , a14 out nocopy JTF_NUMBER_TABLE

125: , a10 out nocopy JTF_VARCHAR2_TABLE_100
126: , a11 out nocopy JTF_VARCHAR2_TABLE_100
127: , a12 out nocopy JTF_NUMBER_TABLE
128: , a13 out nocopy JTF_NUMBER_TABLE
129: , a14 out nocopy JTF_NUMBER_TABLE
130: , a15 out nocopy JTF_NUMBER_TABLE
131: , a16 out nocopy JTF_DATE_TABLE
132: , a17 out nocopy JTF_VARCHAR2_TABLE_100
133: , a18 out nocopy JTF_VARCHAR2_TABLE_500

Line 130: , a15 out nocopy JTF_NUMBER_TABLE

126: , a11 out nocopy JTF_VARCHAR2_TABLE_100
127: , a12 out nocopy JTF_NUMBER_TABLE
128: , a13 out nocopy JTF_NUMBER_TABLE
129: , a14 out nocopy JTF_NUMBER_TABLE
130: , a15 out nocopy JTF_NUMBER_TABLE
131: , a16 out nocopy JTF_DATE_TABLE
132: , a17 out nocopy JTF_VARCHAR2_TABLE_100
133: , a18 out nocopy JTF_VARCHAR2_TABLE_500
134: , a19 out nocopy JTF_VARCHAR2_TABLE_500

Line 148: , a33 out nocopy JTF_NUMBER_TABLE

144: , a29 out nocopy JTF_VARCHAR2_TABLE_500
145: , a30 out nocopy JTF_VARCHAR2_TABLE_500
146: , a31 out nocopy JTF_VARCHAR2_TABLE_500
147: , a32 out nocopy JTF_VARCHAR2_TABLE_500
148: , a33 out nocopy JTF_NUMBER_TABLE
149: , a34 out nocopy JTF_DATE_TABLE
150: , a35 out nocopy JTF_NUMBER_TABLE
151: , a36 out nocopy JTF_DATE_TABLE
152: , a37 out nocopy JTF_NUMBER_TABLE

Line 150: , a35 out nocopy JTF_NUMBER_TABLE

146: , a31 out nocopy JTF_VARCHAR2_TABLE_500
147: , a32 out nocopy JTF_VARCHAR2_TABLE_500
148: , a33 out nocopy JTF_NUMBER_TABLE
149: , a34 out nocopy JTF_DATE_TABLE
150: , a35 out nocopy JTF_NUMBER_TABLE
151: , a36 out nocopy JTF_DATE_TABLE
152: , a37 out nocopy JTF_NUMBER_TABLE
153: ) as
154: ddindx binary_integer; indx binary_integer;

Line 152: , a37 out nocopy JTF_NUMBER_TABLE

148: , a33 out nocopy JTF_NUMBER_TABLE
149: , a34 out nocopy JTF_DATE_TABLE
150: , a35 out nocopy JTF_NUMBER_TABLE
151: , a36 out nocopy JTF_DATE_TABLE
152: , a37 out nocopy JTF_NUMBER_TABLE
153: ) as
154: ddindx binary_integer; indx binary_integer;
155: begin
156: if t is null or t.count = 0 then

Line 157: a0 := JTF_NUMBER_TABLE();

153: ) as
154: ddindx binary_integer; indx binary_integer;
155: begin
156: if t is null or t.count = 0 then
157: a0 := JTF_NUMBER_TABLE();
158: a1 := JTF_NUMBER_TABLE();
159: a2 := JTF_VARCHAR2_TABLE_100();
160: a3 := JTF_VARCHAR2_TABLE_100();
161: a4 := JTF_VARCHAR2_TABLE_100();

Line 158: a1 := JTF_NUMBER_TABLE();

154: ddindx binary_integer; indx binary_integer;
155: begin
156: if t is null or t.count = 0 then
157: a0 := JTF_NUMBER_TABLE();
158: a1 := JTF_NUMBER_TABLE();
159: a2 := JTF_VARCHAR2_TABLE_100();
160: a3 := JTF_VARCHAR2_TABLE_100();
161: a4 := JTF_VARCHAR2_TABLE_100();
162: a5 := JTF_VARCHAR2_TABLE_200();

Line 169: a12 := JTF_NUMBER_TABLE();

165: a8 := JTF_DATE_TABLE();
166: a9 := JTF_VARCHAR2_TABLE_100();
167: a10 := JTF_VARCHAR2_TABLE_100();
168: a11 := JTF_VARCHAR2_TABLE_100();
169: a12 := JTF_NUMBER_TABLE();
170: a13 := JTF_NUMBER_TABLE();
171: a14 := JTF_NUMBER_TABLE();
172: a15 := JTF_NUMBER_TABLE();
173: a16 := JTF_DATE_TABLE();

Line 170: a13 := JTF_NUMBER_TABLE();

166: a9 := JTF_VARCHAR2_TABLE_100();
167: a10 := JTF_VARCHAR2_TABLE_100();
168: a11 := JTF_VARCHAR2_TABLE_100();
169: a12 := JTF_NUMBER_TABLE();
170: a13 := JTF_NUMBER_TABLE();
171: a14 := JTF_NUMBER_TABLE();
172: a15 := JTF_NUMBER_TABLE();
173: a16 := JTF_DATE_TABLE();
174: a17 := JTF_VARCHAR2_TABLE_100();

Line 171: a14 := JTF_NUMBER_TABLE();

167: a10 := JTF_VARCHAR2_TABLE_100();
168: a11 := JTF_VARCHAR2_TABLE_100();
169: a12 := JTF_NUMBER_TABLE();
170: a13 := JTF_NUMBER_TABLE();
171: a14 := JTF_NUMBER_TABLE();
172: a15 := JTF_NUMBER_TABLE();
173: a16 := JTF_DATE_TABLE();
174: a17 := JTF_VARCHAR2_TABLE_100();
175: a18 := JTF_VARCHAR2_TABLE_500();

Line 172: a15 := JTF_NUMBER_TABLE();

168: a11 := JTF_VARCHAR2_TABLE_100();
169: a12 := JTF_NUMBER_TABLE();
170: a13 := JTF_NUMBER_TABLE();
171: a14 := JTF_NUMBER_TABLE();
172: a15 := JTF_NUMBER_TABLE();
173: a16 := JTF_DATE_TABLE();
174: a17 := JTF_VARCHAR2_TABLE_100();
175: a18 := JTF_VARCHAR2_TABLE_500();
176: a19 := JTF_VARCHAR2_TABLE_500();

Line 190: a33 := JTF_NUMBER_TABLE();

186: a29 := JTF_VARCHAR2_TABLE_500();
187: a30 := JTF_VARCHAR2_TABLE_500();
188: a31 := JTF_VARCHAR2_TABLE_500();
189: a32 := JTF_VARCHAR2_TABLE_500();
190: a33 := JTF_NUMBER_TABLE();
191: a34 := JTF_DATE_TABLE();
192: a35 := JTF_NUMBER_TABLE();
193: a36 := JTF_DATE_TABLE();
194: a37 := JTF_NUMBER_TABLE();

Line 192: a35 := JTF_NUMBER_TABLE();

188: a31 := JTF_VARCHAR2_TABLE_500();
189: a32 := JTF_VARCHAR2_TABLE_500();
190: a33 := JTF_NUMBER_TABLE();
191: a34 := JTF_DATE_TABLE();
192: a35 := JTF_NUMBER_TABLE();
193: a36 := JTF_DATE_TABLE();
194: a37 := JTF_NUMBER_TABLE();
195: else
196: a0 := JTF_NUMBER_TABLE();

Line 194: a37 := JTF_NUMBER_TABLE();

190: a33 := JTF_NUMBER_TABLE();
191: a34 := JTF_DATE_TABLE();
192: a35 := JTF_NUMBER_TABLE();
193: a36 := JTF_DATE_TABLE();
194: a37 := JTF_NUMBER_TABLE();
195: else
196: a0 := JTF_NUMBER_TABLE();
197: a1 := JTF_NUMBER_TABLE();
198: a2 := JTF_VARCHAR2_TABLE_100();

Line 196: a0 := JTF_NUMBER_TABLE();

192: a35 := JTF_NUMBER_TABLE();
193: a36 := JTF_DATE_TABLE();
194: a37 := JTF_NUMBER_TABLE();
195: else
196: a0 := JTF_NUMBER_TABLE();
197: a1 := JTF_NUMBER_TABLE();
198: a2 := JTF_VARCHAR2_TABLE_100();
199: a3 := JTF_VARCHAR2_TABLE_100();
200: a4 := JTF_VARCHAR2_TABLE_100();

Line 197: a1 := JTF_NUMBER_TABLE();

193: a36 := JTF_DATE_TABLE();
194: a37 := JTF_NUMBER_TABLE();
195: else
196: a0 := JTF_NUMBER_TABLE();
197: a1 := JTF_NUMBER_TABLE();
198: a2 := JTF_VARCHAR2_TABLE_100();
199: a3 := JTF_VARCHAR2_TABLE_100();
200: a4 := JTF_VARCHAR2_TABLE_100();
201: a5 := JTF_VARCHAR2_TABLE_200();

Line 208: a12 := JTF_NUMBER_TABLE();

204: a8 := JTF_DATE_TABLE();
205: a9 := JTF_VARCHAR2_TABLE_100();
206: a10 := JTF_VARCHAR2_TABLE_100();
207: a11 := JTF_VARCHAR2_TABLE_100();
208: a12 := JTF_NUMBER_TABLE();
209: a13 := JTF_NUMBER_TABLE();
210: a14 := JTF_NUMBER_TABLE();
211: a15 := JTF_NUMBER_TABLE();
212: a16 := JTF_DATE_TABLE();

Line 209: a13 := JTF_NUMBER_TABLE();

205: a9 := JTF_VARCHAR2_TABLE_100();
206: a10 := JTF_VARCHAR2_TABLE_100();
207: a11 := JTF_VARCHAR2_TABLE_100();
208: a12 := JTF_NUMBER_TABLE();
209: a13 := JTF_NUMBER_TABLE();
210: a14 := JTF_NUMBER_TABLE();
211: a15 := JTF_NUMBER_TABLE();
212: a16 := JTF_DATE_TABLE();
213: a17 := JTF_VARCHAR2_TABLE_100();

Line 210: a14 := JTF_NUMBER_TABLE();

206: a10 := JTF_VARCHAR2_TABLE_100();
207: a11 := JTF_VARCHAR2_TABLE_100();
208: a12 := JTF_NUMBER_TABLE();
209: a13 := JTF_NUMBER_TABLE();
210: a14 := JTF_NUMBER_TABLE();
211: a15 := JTF_NUMBER_TABLE();
212: a16 := JTF_DATE_TABLE();
213: a17 := JTF_VARCHAR2_TABLE_100();
214: a18 := JTF_VARCHAR2_TABLE_500();

Line 211: a15 := JTF_NUMBER_TABLE();

207: a11 := JTF_VARCHAR2_TABLE_100();
208: a12 := JTF_NUMBER_TABLE();
209: a13 := JTF_NUMBER_TABLE();
210: a14 := JTF_NUMBER_TABLE();
211: a15 := JTF_NUMBER_TABLE();
212: a16 := JTF_DATE_TABLE();
213: a17 := JTF_VARCHAR2_TABLE_100();
214: a18 := JTF_VARCHAR2_TABLE_500();
215: a19 := JTF_VARCHAR2_TABLE_500();

Line 229: a33 := JTF_NUMBER_TABLE();

225: a29 := JTF_VARCHAR2_TABLE_500();
226: a30 := JTF_VARCHAR2_TABLE_500();
227: a31 := JTF_VARCHAR2_TABLE_500();
228: a32 := JTF_VARCHAR2_TABLE_500();
229: a33 := JTF_NUMBER_TABLE();
230: a34 := JTF_DATE_TABLE();
231: a35 := JTF_NUMBER_TABLE();
232: a36 := JTF_DATE_TABLE();
233: a37 := JTF_NUMBER_TABLE();

Line 231: a35 := JTF_NUMBER_TABLE();

227: a31 := JTF_VARCHAR2_TABLE_500();
228: a32 := JTF_VARCHAR2_TABLE_500();
229: a33 := JTF_NUMBER_TABLE();
230: a34 := JTF_DATE_TABLE();
231: a35 := JTF_NUMBER_TABLE();
232: a36 := JTF_DATE_TABLE();
233: a37 := JTF_NUMBER_TABLE();
234: if t.count > 0 then
235: a0.extend(t.count);

Line 233: a37 := JTF_NUMBER_TABLE();

229: a33 := JTF_NUMBER_TABLE();
230: a34 := JTF_DATE_TABLE();
231: a35 := JTF_NUMBER_TABLE();
232: a36 := JTF_DATE_TABLE();
233: a37 := JTF_NUMBER_TABLE();
234: if t.count > 0 then
235: a0.extend(t.count);
236: a1.extend(t.count);
237: a2.extend(t.count);

Line 324: procedure rosetta_table_copy_in_p5(t out nocopy okl_sip_pvt.okl_subsidy_pools_tl_tbl_type, a0 JTF_NUMBER_TABLE

320: end if;
321: end if;
322: end rosetta_table_copy_out_p2;
323:
324: procedure rosetta_table_copy_in_p5(t out nocopy okl_sip_pvt.okl_subsidy_pools_tl_tbl_type, a0 JTF_NUMBER_TABLE
325: , a1 JTF_VARCHAR2_TABLE_200
326: , a2 JTF_VARCHAR2_TABLE_2000
327: , a3 JTF_VARCHAR2_TABLE_100
328: , a4 JTF_VARCHAR2_TABLE_100

Line 330: , a6 JTF_NUMBER_TABLE

326: , a2 JTF_VARCHAR2_TABLE_2000
327: , a3 JTF_VARCHAR2_TABLE_100
328: , a4 JTF_VARCHAR2_TABLE_100
329: , a5 JTF_VARCHAR2_TABLE_100
330: , a6 JTF_NUMBER_TABLE
331: , a7 JTF_DATE_TABLE
332: , a8 JTF_NUMBER_TABLE
333: , a9 JTF_DATE_TABLE
334: , a10 JTF_NUMBER_TABLE

Line 332: , a8 JTF_NUMBER_TABLE

328: , a4 JTF_VARCHAR2_TABLE_100
329: , a5 JTF_VARCHAR2_TABLE_100
330: , a6 JTF_NUMBER_TABLE
331: , a7 JTF_DATE_TABLE
332: , a8 JTF_NUMBER_TABLE
333: , a9 JTF_DATE_TABLE
334: , a10 JTF_NUMBER_TABLE
335: ) as
336: ddindx binary_integer; indx binary_integer;

Line 334: , a10 JTF_NUMBER_TABLE

330: , a6 JTF_NUMBER_TABLE
331: , a7 JTF_DATE_TABLE
332: , a8 JTF_NUMBER_TABLE
333: , a9 JTF_DATE_TABLE
334: , a10 JTF_NUMBER_TABLE
335: ) as
336: ddindx binary_integer; indx binary_integer;
337: begin
338: if a0 is not null and a0.count > 0 then

Line 363: procedure rosetta_table_copy_out_p5(t okl_sip_pvt.okl_subsidy_pools_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

359: end loop;
360: end if;
361: end if;
362: end rosetta_table_copy_in_p5;
363: procedure rosetta_table_copy_out_p5(t okl_sip_pvt.okl_subsidy_pools_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
364: , a1 out nocopy JTF_VARCHAR2_TABLE_200
365: , a2 out nocopy JTF_VARCHAR2_TABLE_2000
366: , a3 out nocopy JTF_VARCHAR2_TABLE_100
367: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 369: , a6 out nocopy JTF_NUMBER_TABLE

365: , a2 out nocopy JTF_VARCHAR2_TABLE_2000
366: , a3 out nocopy JTF_VARCHAR2_TABLE_100
367: , a4 out nocopy JTF_VARCHAR2_TABLE_100
368: , a5 out nocopy JTF_VARCHAR2_TABLE_100
369: , a6 out nocopy JTF_NUMBER_TABLE
370: , a7 out nocopy JTF_DATE_TABLE
371: , a8 out nocopy JTF_NUMBER_TABLE
372: , a9 out nocopy JTF_DATE_TABLE
373: , a10 out nocopy JTF_NUMBER_TABLE

Line 371: , a8 out nocopy JTF_NUMBER_TABLE

367: , a4 out nocopy JTF_VARCHAR2_TABLE_100
368: , a5 out nocopy JTF_VARCHAR2_TABLE_100
369: , a6 out nocopy JTF_NUMBER_TABLE
370: , a7 out nocopy JTF_DATE_TABLE
371: , a8 out nocopy JTF_NUMBER_TABLE
372: , a9 out nocopy JTF_DATE_TABLE
373: , a10 out nocopy JTF_NUMBER_TABLE
374: ) as
375: ddindx binary_integer; indx binary_integer;

Line 373: , a10 out nocopy JTF_NUMBER_TABLE

369: , a6 out nocopy JTF_NUMBER_TABLE
370: , a7 out nocopy JTF_DATE_TABLE
371: , a8 out nocopy JTF_NUMBER_TABLE
372: , a9 out nocopy JTF_DATE_TABLE
373: , a10 out nocopy JTF_NUMBER_TABLE
374: ) as
375: ddindx binary_integer; indx binary_integer;
376: begin
377: if t is null or t.count = 0 then

Line 378: a0 := JTF_NUMBER_TABLE();

374: ) as
375: ddindx binary_integer; indx binary_integer;
376: begin
377: if t is null or t.count = 0 then
378: a0 := JTF_NUMBER_TABLE();
379: a1 := JTF_VARCHAR2_TABLE_200();
380: a2 := JTF_VARCHAR2_TABLE_2000();
381: a3 := JTF_VARCHAR2_TABLE_100();
382: a4 := JTF_VARCHAR2_TABLE_100();

Line 384: a6 := JTF_NUMBER_TABLE();

380: a2 := JTF_VARCHAR2_TABLE_2000();
381: a3 := JTF_VARCHAR2_TABLE_100();
382: a4 := JTF_VARCHAR2_TABLE_100();
383: a5 := JTF_VARCHAR2_TABLE_100();
384: a6 := JTF_NUMBER_TABLE();
385: a7 := JTF_DATE_TABLE();
386: a8 := JTF_NUMBER_TABLE();
387: a9 := JTF_DATE_TABLE();
388: a10 := JTF_NUMBER_TABLE();

Line 386: a8 := JTF_NUMBER_TABLE();

382: a4 := JTF_VARCHAR2_TABLE_100();
383: a5 := JTF_VARCHAR2_TABLE_100();
384: a6 := JTF_NUMBER_TABLE();
385: a7 := JTF_DATE_TABLE();
386: a8 := JTF_NUMBER_TABLE();
387: a9 := JTF_DATE_TABLE();
388: a10 := JTF_NUMBER_TABLE();
389: else
390: a0 := JTF_NUMBER_TABLE();

Line 388: a10 := JTF_NUMBER_TABLE();

384: a6 := JTF_NUMBER_TABLE();
385: a7 := JTF_DATE_TABLE();
386: a8 := JTF_NUMBER_TABLE();
387: a9 := JTF_DATE_TABLE();
388: a10 := JTF_NUMBER_TABLE();
389: else
390: a0 := JTF_NUMBER_TABLE();
391: a1 := JTF_VARCHAR2_TABLE_200();
392: a2 := JTF_VARCHAR2_TABLE_2000();

Line 390: a0 := JTF_NUMBER_TABLE();

386: a8 := JTF_NUMBER_TABLE();
387: a9 := JTF_DATE_TABLE();
388: a10 := JTF_NUMBER_TABLE();
389: else
390: a0 := JTF_NUMBER_TABLE();
391: a1 := JTF_VARCHAR2_TABLE_200();
392: a2 := JTF_VARCHAR2_TABLE_2000();
393: a3 := JTF_VARCHAR2_TABLE_100();
394: a4 := JTF_VARCHAR2_TABLE_100();

Line 396: a6 := JTF_NUMBER_TABLE();

392: a2 := JTF_VARCHAR2_TABLE_2000();
393: a3 := JTF_VARCHAR2_TABLE_100();
394: a4 := JTF_VARCHAR2_TABLE_100();
395: a5 := JTF_VARCHAR2_TABLE_100();
396: a6 := JTF_NUMBER_TABLE();
397: a7 := JTF_DATE_TABLE();
398: a8 := JTF_NUMBER_TABLE();
399: a9 := JTF_DATE_TABLE();
400: a10 := JTF_NUMBER_TABLE();

Line 398: a8 := JTF_NUMBER_TABLE();

394: a4 := JTF_VARCHAR2_TABLE_100();
395: a5 := JTF_VARCHAR2_TABLE_100();
396: a6 := JTF_NUMBER_TABLE();
397: a7 := JTF_DATE_TABLE();
398: a8 := JTF_NUMBER_TABLE();
399: a9 := JTF_DATE_TABLE();
400: a10 := JTF_NUMBER_TABLE();
401: if t.count > 0 then
402: a0.extend(t.count);

Line 400: a10 := JTF_NUMBER_TABLE();

396: a6 := JTF_NUMBER_TABLE();
397: a7 := JTF_DATE_TABLE();
398: a8 := JTF_NUMBER_TABLE();
399: a9 := JTF_DATE_TABLE();
400: a10 := JTF_NUMBER_TABLE();
401: if t.count > 0 then
402: a0.extend(t.count);
403: a1.extend(t.count);
404: a2.extend(t.count);

Line 437: procedure rosetta_table_copy_in_p8(t out nocopy okl_sip_pvt.sip_tbl_type, a0 JTF_NUMBER_TABLE

433: end if;
434: end if;
435: end rosetta_table_copy_out_p5;
436:
437: procedure rosetta_table_copy_in_p8(t out nocopy okl_sip_pvt.sip_tbl_type, a0 JTF_NUMBER_TABLE
438: , a1 JTF_NUMBER_TABLE
439: , a2 JTF_VARCHAR2_TABLE_100
440: , a3 JTF_VARCHAR2_TABLE_100
441: , a4 JTF_DATE_TABLE

Line 438: , a1 JTF_NUMBER_TABLE

434: end if;
435: end rosetta_table_copy_out_p5;
436:
437: procedure rosetta_table_copy_in_p8(t out nocopy okl_sip_pvt.sip_tbl_type, a0 JTF_NUMBER_TABLE
438: , a1 JTF_NUMBER_TABLE
439: , a2 JTF_VARCHAR2_TABLE_100
440: , a3 JTF_VARCHAR2_TABLE_100
441: , a4 JTF_DATE_TABLE
442: , a5 JTF_DATE_TABLE

Line 446: , a9 JTF_NUMBER_TABLE

442: , a5 JTF_DATE_TABLE
443: , a6 JTF_VARCHAR2_TABLE_100
444: , a7 JTF_VARCHAR2_TABLE_100
445: , a8 JTF_VARCHAR2_TABLE_100
446: , a9 JTF_NUMBER_TABLE
447: , a10 JTF_NUMBER_TABLE
448: , a11 JTF_NUMBER_TABLE
449: , a12 JTF_NUMBER_TABLE
450: , a13 JTF_DATE_TABLE

Line 447: , a10 JTF_NUMBER_TABLE

443: , a6 JTF_VARCHAR2_TABLE_100
444: , a7 JTF_VARCHAR2_TABLE_100
445: , a8 JTF_VARCHAR2_TABLE_100
446: , a9 JTF_NUMBER_TABLE
447: , a10 JTF_NUMBER_TABLE
448: , a11 JTF_NUMBER_TABLE
449: , a12 JTF_NUMBER_TABLE
450: , a13 JTF_DATE_TABLE
451: , a14 JTF_VARCHAR2_TABLE_100

Line 448: , a11 JTF_NUMBER_TABLE

444: , a7 JTF_VARCHAR2_TABLE_100
445: , a8 JTF_VARCHAR2_TABLE_100
446: , a9 JTF_NUMBER_TABLE
447: , a10 JTF_NUMBER_TABLE
448: , a11 JTF_NUMBER_TABLE
449: , a12 JTF_NUMBER_TABLE
450: , a13 JTF_DATE_TABLE
451: , a14 JTF_VARCHAR2_TABLE_100
452: , a15 JTF_VARCHAR2_TABLE_500

Line 449: , a12 JTF_NUMBER_TABLE

445: , a8 JTF_VARCHAR2_TABLE_100
446: , a9 JTF_NUMBER_TABLE
447: , a10 JTF_NUMBER_TABLE
448: , a11 JTF_NUMBER_TABLE
449: , a12 JTF_NUMBER_TABLE
450: , a13 JTF_DATE_TABLE
451: , a14 JTF_VARCHAR2_TABLE_100
452: , a15 JTF_VARCHAR2_TABLE_500
453: , a16 JTF_VARCHAR2_TABLE_500

Line 467: , a30 JTF_NUMBER_TABLE

463: , a26 JTF_VARCHAR2_TABLE_500
464: , a27 JTF_VARCHAR2_TABLE_500
465: , a28 JTF_VARCHAR2_TABLE_500
466: , a29 JTF_VARCHAR2_TABLE_500
467: , a30 JTF_NUMBER_TABLE
468: , a31 JTF_DATE_TABLE
469: , a32 JTF_NUMBER_TABLE
470: , a33 JTF_DATE_TABLE
471: , a34 JTF_NUMBER_TABLE

Line 469: , a32 JTF_NUMBER_TABLE

465: , a28 JTF_VARCHAR2_TABLE_500
466: , a29 JTF_VARCHAR2_TABLE_500
467: , a30 JTF_NUMBER_TABLE
468: , a31 JTF_DATE_TABLE
469: , a32 JTF_NUMBER_TABLE
470: , a33 JTF_DATE_TABLE
471: , a34 JTF_NUMBER_TABLE
472: ) as
473: ddindx binary_integer; indx binary_integer;

Line 471: , a34 JTF_NUMBER_TABLE

467: , a30 JTF_NUMBER_TABLE
468: , a31 JTF_DATE_TABLE
469: , a32 JTF_NUMBER_TABLE
470: , a33 JTF_DATE_TABLE
471: , a34 JTF_NUMBER_TABLE
472: ) as
473: ddindx binary_integer; indx binary_integer;
474: begin
475: if a0 is not null and a0.count > 0 then

Line 524: procedure rosetta_table_copy_out_p8(t okl_sip_pvt.sip_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

520: end loop;
521: end if;
522: end if;
523: end rosetta_table_copy_in_p8;
524: procedure rosetta_table_copy_out_p8(t okl_sip_pvt.sip_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
525: , a1 out nocopy JTF_NUMBER_TABLE
526: , a2 out nocopy JTF_VARCHAR2_TABLE_100
527: , a3 out nocopy JTF_VARCHAR2_TABLE_100
528: , a4 out nocopy JTF_DATE_TABLE

Line 525: , a1 out nocopy JTF_NUMBER_TABLE

521: end if;
522: end if;
523: end rosetta_table_copy_in_p8;
524: procedure rosetta_table_copy_out_p8(t okl_sip_pvt.sip_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
525: , a1 out nocopy JTF_NUMBER_TABLE
526: , a2 out nocopy JTF_VARCHAR2_TABLE_100
527: , a3 out nocopy JTF_VARCHAR2_TABLE_100
528: , a4 out nocopy JTF_DATE_TABLE
529: , a5 out nocopy JTF_DATE_TABLE

Line 533: , a9 out nocopy JTF_NUMBER_TABLE

529: , a5 out nocopy JTF_DATE_TABLE
530: , a6 out nocopy JTF_VARCHAR2_TABLE_100
531: , a7 out nocopy JTF_VARCHAR2_TABLE_100
532: , a8 out nocopy JTF_VARCHAR2_TABLE_100
533: , a9 out nocopy JTF_NUMBER_TABLE
534: , a10 out nocopy JTF_NUMBER_TABLE
535: , a11 out nocopy JTF_NUMBER_TABLE
536: , a12 out nocopy JTF_NUMBER_TABLE
537: , a13 out nocopy JTF_DATE_TABLE

Line 534: , a10 out nocopy JTF_NUMBER_TABLE

530: , a6 out nocopy JTF_VARCHAR2_TABLE_100
531: , a7 out nocopy JTF_VARCHAR2_TABLE_100
532: , a8 out nocopy JTF_VARCHAR2_TABLE_100
533: , a9 out nocopy JTF_NUMBER_TABLE
534: , a10 out nocopy JTF_NUMBER_TABLE
535: , a11 out nocopy JTF_NUMBER_TABLE
536: , a12 out nocopy JTF_NUMBER_TABLE
537: , a13 out nocopy JTF_DATE_TABLE
538: , a14 out nocopy JTF_VARCHAR2_TABLE_100

Line 535: , a11 out nocopy JTF_NUMBER_TABLE

531: , a7 out nocopy JTF_VARCHAR2_TABLE_100
532: , a8 out nocopy JTF_VARCHAR2_TABLE_100
533: , a9 out nocopy JTF_NUMBER_TABLE
534: , a10 out nocopy JTF_NUMBER_TABLE
535: , a11 out nocopy JTF_NUMBER_TABLE
536: , a12 out nocopy JTF_NUMBER_TABLE
537: , a13 out nocopy JTF_DATE_TABLE
538: , a14 out nocopy JTF_VARCHAR2_TABLE_100
539: , a15 out nocopy JTF_VARCHAR2_TABLE_500

Line 536: , a12 out nocopy JTF_NUMBER_TABLE

532: , a8 out nocopy JTF_VARCHAR2_TABLE_100
533: , a9 out nocopy JTF_NUMBER_TABLE
534: , a10 out nocopy JTF_NUMBER_TABLE
535: , a11 out nocopy JTF_NUMBER_TABLE
536: , a12 out nocopy JTF_NUMBER_TABLE
537: , a13 out nocopy JTF_DATE_TABLE
538: , a14 out nocopy JTF_VARCHAR2_TABLE_100
539: , a15 out nocopy JTF_VARCHAR2_TABLE_500
540: , a16 out nocopy JTF_VARCHAR2_TABLE_500

Line 554: , a30 out nocopy JTF_NUMBER_TABLE

550: , a26 out nocopy JTF_VARCHAR2_TABLE_500
551: , a27 out nocopy JTF_VARCHAR2_TABLE_500
552: , a28 out nocopy JTF_VARCHAR2_TABLE_500
553: , a29 out nocopy JTF_VARCHAR2_TABLE_500
554: , a30 out nocopy JTF_NUMBER_TABLE
555: , a31 out nocopy JTF_DATE_TABLE
556: , a32 out nocopy JTF_NUMBER_TABLE
557: , a33 out nocopy JTF_DATE_TABLE
558: , a34 out nocopy JTF_NUMBER_TABLE

Line 556: , a32 out nocopy JTF_NUMBER_TABLE

552: , a28 out nocopy JTF_VARCHAR2_TABLE_500
553: , a29 out nocopy JTF_VARCHAR2_TABLE_500
554: , a30 out nocopy JTF_NUMBER_TABLE
555: , a31 out nocopy JTF_DATE_TABLE
556: , a32 out nocopy JTF_NUMBER_TABLE
557: , a33 out nocopy JTF_DATE_TABLE
558: , a34 out nocopy JTF_NUMBER_TABLE
559: ) as
560: ddindx binary_integer; indx binary_integer;

Line 558: , a34 out nocopy JTF_NUMBER_TABLE

554: , a30 out nocopy JTF_NUMBER_TABLE
555: , a31 out nocopy JTF_DATE_TABLE
556: , a32 out nocopy JTF_NUMBER_TABLE
557: , a33 out nocopy JTF_DATE_TABLE
558: , a34 out nocopy JTF_NUMBER_TABLE
559: ) as
560: ddindx binary_integer; indx binary_integer;
561: begin
562: if t is null or t.count = 0 then

Line 563: a0 := JTF_NUMBER_TABLE();

559: ) as
560: ddindx binary_integer; indx binary_integer;
561: begin
562: if t is null or t.count = 0 then
563: a0 := JTF_NUMBER_TABLE();
564: a1 := JTF_NUMBER_TABLE();
565: a2 := JTF_VARCHAR2_TABLE_100();
566: a3 := JTF_VARCHAR2_TABLE_100();
567: a4 := JTF_DATE_TABLE();

Line 564: a1 := JTF_NUMBER_TABLE();

560: ddindx binary_integer; indx binary_integer;
561: begin
562: if t is null or t.count = 0 then
563: a0 := JTF_NUMBER_TABLE();
564: a1 := JTF_NUMBER_TABLE();
565: a2 := JTF_VARCHAR2_TABLE_100();
566: a3 := JTF_VARCHAR2_TABLE_100();
567: a4 := JTF_DATE_TABLE();
568: a5 := JTF_DATE_TABLE();

Line 572: a9 := JTF_NUMBER_TABLE();

568: a5 := JTF_DATE_TABLE();
569: a6 := JTF_VARCHAR2_TABLE_100();
570: a7 := JTF_VARCHAR2_TABLE_100();
571: a8 := JTF_VARCHAR2_TABLE_100();
572: a9 := JTF_NUMBER_TABLE();
573: a10 := JTF_NUMBER_TABLE();
574: a11 := JTF_NUMBER_TABLE();
575: a12 := JTF_NUMBER_TABLE();
576: a13 := JTF_DATE_TABLE();

Line 573: a10 := JTF_NUMBER_TABLE();

569: a6 := JTF_VARCHAR2_TABLE_100();
570: a7 := JTF_VARCHAR2_TABLE_100();
571: a8 := JTF_VARCHAR2_TABLE_100();
572: a9 := JTF_NUMBER_TABLE();
573: a10 := JTF_NUMBER_TABLE();
574: a11 := JTF_NUMBER_TABLE();
575: a12 := JTF_NUMBER_TABLE();
576: a13 := JTF_DATE_TABLE();
577: a14 := JTF_VARCHAR2_TABLE_100();

Line 574: a11 := JTF_NUMBER_TABLE();

570: a7 := JTF_VARCHAR2_TABLE_100();
571: a8 := JTF_VARCHAR2_TABLE_100();
572: a9 := JTF_NUMBER_TABLE();
573: a10 := JTF_NUMBER_TABLE();
574: a11 := JTF_NUMBER_TABLE();
575: a12 := JTF_NUMBER_TABLE();
576: a13 := JTF_DATE_TABLE();
577: a14 := JTF_VARCHAR2_TABLE_100();
578: a15 := JTF_VARCHAR2_TABLE_500();

Line 575: a12 := JTF_NUMBER_TABLE();

571: a8 := JTF_VARCHAR2_TABLE_100();
572: a9 := JTF_NUMBER_TABLE();
573: a10 := JTF_NUMBER_TABLE();
574: a11 := JTF_NUMBER_TABLE();
575: a12 := JTF_NUMBER_TABLE();
576: a13 := JTF_DATE_TABLE();
577: a14 := JTF_VARCHAR2_TABLE_100();
578: a15 := JTF_VARCHAR2_TABLE_500();
579: a16 := JTF_VARCHAR2_TABLE_500();

Line 593: a30 := JTF_NUMBER_TABLE();

589: a26 := JTF_VARCHAR2_TABLE_500();
590: a27 := JTF_VARCHAR2_TABLE_500();
591: a28 := JTF_VARCHAR2_TABLE_500();
592: a29 := JTF_VARCHAR2_TABLE_500();
593: a30 := JTF_NUMBER_TABLE();
594: a31 := JTF_DATE_TABLE();
595: a32 := JTF_NUMBER_TABLE();
596: a33 := JTF_DATE_TABLE();
597: a34 := JTF_NUMBER_TABLE();

Line 595: a32 := JTF_NUMBER_TABLE();

591: a28 := JTF_VARCHAR2_TABLE_500();
592: a29 := JTF_VARCHAR2_TABLE_500();
593: a30 := JTF_NUMBER_TABLE();
594: a31 := JTF_DATE_TABLE();
595: a32 := JTF_NUMBER_TABLE();
596: a33 := JTF_DATE_TABLE();
597: a34 := JTF_NUMBER_TABLE();
598: else
599: a0 := JTF_NUMBER_TABLE();

Line 597: a34 := JTF_NUMBER_TABLE();

593: a30 := JTF_NUMBER_TABLE();
594: a31 := JTF_DATE_TABLE();
595: a32 := JTF_NUMBER_TABLE();
596: a33 := JTF_DATE_TABLE();
597: a34 := JTF_NUMBER_TABLE();
598: else
599: a0 := JTF_NUMBER_TABLE();
600: a1 := JTF_NUMBER_TABLE();
601: a2 := JTF_VARCHAR2_TABLE_100();

Line 599: a0 := JTF_NUMBER_TABLE();

595: a32 := JTF_NUMBER_TABLE();
596: a33 := JTF_DATE_TABLE();
597: a34 := JTF_NUMBER_TABLE();
598: else
599: a0 := JTF_NUMBER_TABLE();
600: a1 := JTF_NUMBER_TABLE();
601: a2 := JTF_VARCHAR2_TABLE_100();
602: a3 := JTF_VARCHAR2_TABLE_100();
603: a4 := JTF_DATE_TABLE();

Line 600: a1 := JTF_NUMBER_TABLE();

596: a33 := JTF_DATE_TABLE();
597: a34 := JTF_NUMBER_TABLE();
598: else
599: a0 := JTF_NUMBER_TABLE();
600: a1 := JTF_NUMBER_TABLE();
601: a2 := JTF_VARCHAR2_TABLE_100();
602: a3 := JTF_VARCHAR2_TABLE_100();
603: a4 := JTF_DATE_TABLE();
604: a5 := JTF_DATE_TABLE();

Line 608: a9 := JTF_NUMBER_TABLE();

604: a5 := JTF_DATE_TABLE();
605: a6 := JTF_VARCHAR2_TABLE_100();
606: a7 := JTF_VARCHAR2_TABLE_100();
607: a8 := JTF_VARCHAR2_TABLE_100();
608: a9 := JTF_NUMBER_TABLE();
609: a10 := JTF_NUMBER_TABLE();
610: a11 := JTF_NUMBER_TABLE();
611: a12 := JTF_NUMBER_TABLE();
612: a13 := JTF_DATE_TABLE();

Line 609: a10 := JTF_NUMBER_TABLE();

605: a6 := JTF_VARCHAR2_TABLE_100();
606: a7 := JTF_VARCHAR2_TABLE_100();
607: a8 := JTF_VARCHAR2_TABLE_100();
608: a9 := JTF_NUMBER_TABLE();
609: a10 := JTF_NUMBER_TABLE();
610: a11 := JTF_NUMBER_TABLE();
611: a12 := JTF_NUMBER_TABLE();
612: a13 := JTF_DATE_TABLE();
613: a14 := JTF_VARCHAR2_TABLE_100();

Line 610: a11 := JTF_NUMBER_TABLE();

606: a7 := JTF_VARCHAR2_TABLE_100();
607: a8 := JTF_VARCHAR2_TABLE_100();
608: a9 := JTF_NUMBER_TABLE();
609: a10 := JTF_NUMBER_TABLE();
610: a11 := JTF_NUMBER_TABLE();
611: a12 := JTF_NUMBER_TABLE();
612: a13 := JTF_DATE_TABLE();
613: a14 := JTF_VARCHAR2_TABLE_100();
614: a15 := JTF_VARCHAR2_TABLE_500();

Line 611: a12 := JTF_NUMBER_TABLE();

607: a8 := JTF_VARCHAR2_TABLE_100();
608: a9 := JTF_NUMBER_TABLE();
609: a10 := JTF_NUMBER_TABLE();
610: a11 := JTF_NUMBER_TABLE();
611: a12 := JTF_NUMBER_TABLE();
612: a13 := JTF_DATE_TABLE();
613: a14 := JTF_VARCHAR2_TABLE_100();
614: a15 := JTF_VARCHAR2_TABLE_500();
615: a16 := JTF_VARCHAR2_TABLE_500();

Line 629: a30 := JTF_NUMBER_TABLE();

625: a26 := JTF_VARCHAR2_TABLE_500();
626: a27 := JTF_VARCHAR2_TABLE_500();
627: a28 := JTF_VARCHAR2_TABLE_500();
628: a29 := JTF_VARCHAR2_TABLE_500();
629: a30 := JTF_NUMBER_TABLE();
630: a31 := JTF_DATE_TABLE();
631: a32 := JTF_NUMBER_TABLE();
632: a33 := JTF_DATE_TABLE();
633: a34 := JTF_NUMBER_TABLE();

Line 631: a32 := JTF_NUMBER_TABLE();

627: a28 := JTF_VARCHAR2_TABLE_500();
628: a29 := JTF_VARCHAR2_TABLE_500();
629: a30 := JTF_NUMBER_TABLE();
630: a31 := JTF_DATE_TABLE();
631: a32 := JTF_NUMBER_TABLE();
632: a33 := JTF_DATE_TABLE();
633: a34 := JTF_NUMBER_TABLE();
634: if t.count > 0 then
635: a0.extend(t.count);

Line 633: a34 := JTF_NUMBER_TABLE();

629: a30 := JTF_NUMBER_TABLE();
630: a31 := JTF_DATE_TABLE();
631: a32 := JTF_NUMBER_TABLE();
632: a33 := JTF_DATE_TABLE();
633: a34 := JTF_NUMBER_TABLE();
634: if t.count > 0 then
635: a0.extend(t.count);
636: a1.extend(t.count);
637: a2.extend(t.count);

Line 914: , p5_a0 JTF_NUMBER_TABLE

910: , p_init_msg_list VARCHAR2
911: , x_return_status out nocopy VARCHAR2
912: , x_msg_count out nocopy NUMBER
913: , x_msg_data out nocopy VARCHAR2
914: , p5_a0 JTF_NUMBER_TABLE
915: , p5_a1 JTF_NUMBER_TABLE
916: , p5_a2 JTF_VARCHAR2_TABLE_100
917: , p5_a3 JTF_VARCHAR2_TABLE_100
918: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 915: , p5_a1 JTF_NUMBER_TABLE

911: , x_return_status out nocopy VARCHAR2
912: , x_msg_count out nocopy NUMBER
913: , x_msg_data out nocopy VARCHAR2
914: , p5_a0 JTF_NUMBER_TABLE
915: , p5_a1 JTF_NUMBER_TABLE
916: , p5_a2 JTF_VARCHAR2_TABLE_100
917: , p5_a3 JTF_VARCHAR2_TABLE_100
918: , p5_a4 JTF_VARCHAR2_TABLE_100
919: , p5_a5 JTF_VARCHAR2_TABLE_200

Line 926: , p5_a12 JTF_NUMBER_TABLE

922: , p5_a8 JTF_DATE_TABLE
923: , p5_a9 JTF_VARCHAR2_TABLE_100
924: , p5_a10 JTF_VARCHAR2_TABLE_100
925: , p5_a11 JTF_VARCHAR2_TABLE_100
926: , p5_a12 JTF_NUMBER_TABLE
927: , p5_a13 JTF_NUMBER_TABLE
928: , p5_a14 JTF_NUMBER_TABLE
929: , p5_a15 JTF_NUMBER_TABLE
930: , p5_a16 JTF_DATE_TABLE

Line 927: , p5_a13 JTF_NUMBER_TABLE

923: , p5_a9 JTF_VARCHAR2_TABLE_100
924: , p5_a10 JTF_VARCHAR2_TABLE_100
925: , p5_a11 JTF_VARCHAR2_TABLE_100
926: , p5_a12 JTF_NUMBER_TABLE
927: , p5_a13 JTF_NUMBER_TABLE
928: , p5_a14 JTF_NUMBER_TABLE
929: , p5_a15 JTF_NUMBER_TABLE
930: , p5_a16 JTF_DATE_TABLE
931: , p5_a17 JTF_VARCHAR2_TABLE_100

Line 928: , p5_a14 JTF_NUMBER_TABLE

924: , p5_a10 JTF_VARCHAR2_TABLE_100
925: , p5_a11 JTF_VARCHAR2_TABLE_100
926: , p5_a12 JTF_NUMBER_TABLE
927: , p5_a13 JTF_NUMBER_TABLE
928: , p5_a14 JTF_NUMBER_TABLE
929: , p5_a15 JTF_NUMBER_TABLE
930: , p5_a16 JTF_DATE_TABLE
931: , p5_a17 JTF_VARCHAR2_TABLE_100
932: , p5_a18 JTF_VARCHAR2_TABLE_500

Line 929: , p5_a15 JTF_NUMBER_TABLE

925: , p5_a11 JTF_VARCHAR2_TABLE_100
926: , p5_a12 JTF_NUMBER_TABLE
927: , p5_a13 JTF_NUMBER_TABLE
928: , p5_a14 JTF_NUMBER_TABLE
929: , p5_a15 JTF_NUMBER_TABLE
930: , p5_a16 JTF_DATE_TABLE
931: , p5_a17 JTF_VARCHAR2_TABLE_100
932: , p5_a18 JTF_VARCHAR2_TABLE_500
933: , p5_a19 JTF_VARCHAR2_TABLE_500

Line 947: , p5_a33 JTF_NUMBER_TABLE

943: , p5_a29 JTF_VARCHAR2_TABLE_500
944: , p5_a30 JTF_VARCHAR2_TABLE_500
945: , p5_a31 JTF_VARCHAR2_TABLE_500
946: , p5_a32 JTF_VARCHAR2_TABLE_500
947: , p5_a33 JTF_NUMBER_TABLE
948: , p5_a34 JTF_DATE_TABLE
949: , p5_a35 JTF_NUMBER_TABLE
950: , p5_a36 JTF_DATE_TABLE
951: , p5_a37 JTF_NUMBER_TABLE

Line 949: , p5_a35 JTF_NUMBER_TABLE

945: , p5_a31 JTF_VARCHAR2_TABLE_500
946: , p5_a32 JTF_VARCHAR2_TABLE_500
947: , p5_a33 JTF_NUMBER_TABLE
948: , p5_a34 JTF_DATE_TABLE
949: , p5_a35 JTF_NUMBER_TABLE
950: , p5_a36 JTF_DATE_TABLE
951: , p5_a37 JTF_NUMBER_TABLE
952: , p6_a0 out nocopy JTF_NUMBER_TABLE
953: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 951: , p5_a37 JTF_NUMBER_TABLE

947: , p5_a33 JTF_NUMBER_TABLE
948: , p5_a34 JTF_DATE_TABLE
949: , p5_a35 JTF_NUMBER_TABLE
950: , p5_a36 JTF_DATE_TABLE
951: , p5_a37 JTF_NUMBER_TABLE
952: , p6_a0 out nocopy JTF_NUMBER_TABLE
953: , p6_a1 out nocopy JTF_NUMBER_TABLE
954: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
955: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

Line 952: , p6_a0 out nocopy JTF_NUMBER_TABLE

948: , p5_a34 JTF_DATE_TABLE
949: , p5_a35 JTF_NUMBER_TABLE
950: , p5_a36 JTF_DATE_TABLE
951: , p5_a37 JTF_NUMBER_TABLE
952: , p6_a0 out nocopy JTF_NUMBER_TABLE
953: , p6_a1 out nocopy JTF_NUMBER_TABLE
954: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
955: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
956: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 953: , p6_a1 out nocopy JTF_NUMBER_TABLE

949: , p5_a35 JTF_NUMBER_TABLE
950: , p5_a36 JTF_DATE_TABLE
951: , p5_a37 JTF_NUMBER_TABLE
952: , p6_a0 out nocopy JTF_NUMBER_TABLE
953: , p6_a1 out nocopy JTF_NUMBER_TABLE
954: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
955: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
956: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
957: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200

Line 964: , p6_a12 out nocopy JTF_NUMBER_TABLE

960: , p6_a8 out nocopy JTF_DATE_TABLE
961: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
962: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
963: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
964: , p6_a12 out nocopy JTF_NUMBER_TABLE
965: , p6_a13 out nocopy JTF_NUMBER_TABLE
966: , p6_a14 out nocopy JTF_NUMBER_TABLE
967: , p6_a15 out nocopy JTF_NUMBER_TABLE
968: , p6_a16 out nocopy JTF_DATE_TABLE

Line 965: , p6_a13 out nocopy JTF_NUMBER_TABLE

961: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
962: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
963: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
964: , p6_a12 out nocopy JTF_NUMBER_TABLE
965: , p6_a13 out nocopy JTF_NUMBER_TABLE
966: , p6_a14 out nocopy JTF_NUMBER_TABLE
967: , p6_a15 out nocopy JTF_NUMBER_TABLE
968: , p6_a16 out nocopy JTF_DATE_TABLE
969: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100

Line 966: , p6_a14 out nocopy JTF_NUMBER_TABLE

962: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
963: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
964: , p6_a12 out nocopy JTF_NUMBER_TABLE
965: , p6_a13 out nocopy JTF_NUMBER_TABLE
966: , p6_a14 out nocopy JTF_NUMBER_TABLE
967: , p6_a15 out nocopy JTF_NUMBER_TABLE
968: , p6_a16 out nocopy JTF_DATE_TABLE
969: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
970: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500

Line 967: , p6_a15 out nocopy JTF_NUMBER_TABLE

963: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
964: , p6_a12 out nocopy JTF_NUMBER_TABLE
965: , p6_a13 out nocopy JTF_NUMBER_TABLE
966: , p6_a14 out nocopy JTF_NUMBER_TABLE
967: , p6_a15 out nocopy JTF_NUMBER_TABLE
968: , p6_a16 out nocopy JTF_DATE_TABLE
969: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
970: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
971: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500

Line 985: , p6_a33 out nocopy JTF_NUMBER_TABLE

981: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_500
982: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_500
983: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_500
984: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
985: , p6_a33 out nocopy JTF_NUMBER_TABLE
986: , p6_a34 out nocopy JTF_DATE_TABLE
987: , p6_a35 out nocopy JTF_NUMBER_TABLE
988: , p6_a36 out nocopy JTF_DATE_TABLE
989: , p6_a37 out nocopy JTF_NUMBER_TABLE

Line 987: , p6_a35 out nocopy JTF_NUMBER_TABLE

983: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_500
984: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
985: , p6_a33 out nocopy JTF_NUMBER_TABLE
986: , p6_a34 out nocopy JTF_DATE_TABLE
987: , p6_a35 out nocopy JTF_NUMBER_TABLE
988: , p6_a36 out nocopy JTF_DATE_TABLE
989: , p6_a37 out nocopy JTF_NUMBER_TABLE
990: )
991:

Line 989: , p6_a37 out nocopy JTF_NUMBER_TABLE

985: , p6_a33 out nocopy JTF_NUMBER_TABLE
986: , p6_a34 out nocopy JTF_DATE_TABLE
987: , p6_a35 out nocopy JTF_NUMBER_TABLE
988: , p6_a36 out nocopy JTF_DATE_TABLE
989: , p6_a37 out nocopy JTF_NUMBER_TABLE
990: )
991:
992: as
993: ddp_sipv_tbl okl_sip_pvt.sipv_tbl_type;

Line 1218: , p5_a0 JTF_NUMBER_TABLE

1214: , p_init_msg_list VARCHAR2
1215: , x_return_status out nocopy VARCHAR2
1216: , x_msg_count out nocopy NUMBER
1217: , x_msg_data out nocopy VARCHAR2
1218: , p5_a0 JTF_NUMBER_TABLE
1219: , p5_a1 JTF_NUMBER_TABLE
1220: , p5_a2 JTF_VARCHAR2_TABLE_100
1221: , p5_a3 JTF_VARCHAR2_TABLE_100
1222: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 1219: , p5_a1 JTF_NUMBER_TABLE

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

Line 1230: , p5_a12 JTF_NUMBER_TABLE

1226: , p5_a8 JTF_DATE_TABLE
1227: , p5_a9 JTF_VARCHAR2_TABLE_100
1228: , p5_a10 JTF_VARCHAR2_TABLE_100
1229: , p5_a11 JTF_VARCHAR2_TABLE_100
1230: , p5_a12 JTF_NUMBER_TABLE
1231: , p5_a13 JTF_NUMBER_TABLE
1232: , p5_a14 JTF_NUMBER_TABLE
1233: , p5_a15 JTF_NUMBER_TABLE
1234: , p5_a16 JTF_DATE_TABLE

Line 1231: , p5_a13 JTF_NUMBER_TABLE

1227: , p5_a9 JTF_VARCHAR2_TABLE_100
1228: , p5_a10 JTF_VARCHAR2_TABLE_100
1229: , p5_a11 JTF_VARCHAR2_TABLE_100
1230: , p5_a12 JTF_NUMBER_TABLE
1231: , p5_a13 JTF_NUMBER_TABLE
1232: , p5_a14 JTF_NUMBER_TABLE
1233: , p5_a15 JTF_NUMBER_TABLE
1234: , p5_a16 JTF_DATE_TABLE
1235: , p5_a17 JTF_VARCHAR2_TABLE_100

Line 1232: , p5_a14 JTF_NUMBER_TABLE

1228: , p5_a10 JTF_VARCHAR2_TABLE_100
1229: , p5_a11 JTF_VARCHAR2_TABLE_100
1230: , p5_a12 JTF_NUMBER_TABLE
1231: , p5_a13 JTF_NUMBER_TABLE
1232: , p5_a14 JTF_NUMBER_TABLE
1233: , p5_a15 JTF_NUMBER_TABLE
1234: , p5_a16 JTF_DATE_TABLE
1235: , p5_a17 JTF_VARCHAR2_TABLE_100
1236: , p5_a18 JTF_VARCHAR2_TABLE_500

Line 1233: , p5_a15 JTF_NUMBER_TABLE

1229: , p5_a11 JTF_VARCHAR2_TABLE_100
1230: , p5_a12 JTF_NUMBER_TABLE
1231: , p5_a13 JTF_NUMBER_TABLE
1232: , p5_a14 JTF_NUMBER_TABLE
1233: , p5_a15 JTF_NUMBER_TABLE
1234: , p5_a16 JTF_DATE_TABLE
1235: , p5_a17 JTF_VARCHAR2_TABLE_100
1236: , p5_a18 JTF_VARCHAR2_TABLE_500
1237: , p5_a19 JTF_VARCHAR2_TABLE_500

Line 1251: , p5_a33 JTF_NUMBER_TABLE

1247: , p5_a29 JTF_VARCHAR2_TABLE_500
1248: , p5_a30 JTF_VARCHAR2_TABLE_500
1249: , p5_a31 JTF_VARCHAR2_TABLE_500
1250: , p5_a32 JTF_VARCHAR2_TABLE_500
1251: , p5_a33 JTF_NUMBER_TABLE
1252: , p5_a34 JTF_DATE_TABLE
1253: , p5_a35 JTF_NUMBER_TABLE
1254: , p5_a36 JTF_DATE_TABLE
1255: , p5_a37 JTF_NUMBER_TABLE

Line 1253: , p5_a35 JTF_NUMBER_TABLE

1249: , p5_a31 JTF_VARCHAR2_TABLE_500
1250: , p5_a32 JTF_VARCHAR2_TABLE_500
1251: , p5_a33 JTF_NUMBER_TABLE
1252: , p5_a34 JTF_DATE_TABLE
1253: , p5_a35 JTF_NUMBER_TABLE
1254: , p5_a36 JTF_DATE_TABLE
1255: , p5_a37 JTF_NUMBER_TABLE
1256: )
1257:

Line 1255: , p5_a37 JTF_NUMBER_TABLE

1251: , p5_a33 JTF_NUMBER_TABLE
1252: , p5_a34 JTF_DATE_TABLE
1253: , p5_a35 JTF_NUMBER_TABLE
1254: , p5_a36 JTF_DATE_TABLE
1255: , p5_a37 JTF_NUMBER_TABLE
1256: )
1257:
1258: as
1259: ddp_sipv_tbl okl_sip_pvt.sipv_tbl_type;

Line 1521: , p5_a0 JTF_NUMBER_TABLE

1517: , p_init_msg_list VARCHAR2
1518: , x_return_status out nocopy VARCHAR2
1519: , x_msg_count out nocopy NUMBER
1520: , x_msg_data out nocopy VARCHAR2
1521: , p5_a0 JTF_NUMBER_TABLE
1522: , p5_a1 JTF_NUMBER_TABLE
1523: , p5_a2 JTF_VARCHAR2_TABLE_100
1524: , p5_a3 JTF_VARCHAR2_TABLE_100
1525: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 1522: , p5_a1 JTF_NUMBER_TABLE

1518: , x_return_status out nocopy VARCHAR2
1519: , x_msg_count out nocopy NUMBER
1520: , x_msg_data out nocopy VARCHAR2
1521: , p5_a0 JTF_NUMBER_TABLE
1522: , p5_a1 JTF_NUMBER_TABLE
1523: , p5_a2 JTF_VARCHAR2_TABLE_100
1524: , p5_a3 JTF_VARCHAR2_TABLE_100
1525: , p5_a4 JTF_VARCHAR2_TABLE_100
1526: , p5_a5 JTF_VARCHAR2_TABLE_200

Line 1533: , p5_a12 JTF_NUMBER_TABLE

1529: , p5_a8 JTF_DATE_TABLE
1530: , p5_a9 JTF_VARCHAR2_TABLE_100
1531: , p5_a10 JTF_VARCHAR2_TABLE_100
1532: , p5_a11 JTF_VARCHAR2_TABLE_100
1533: , p5_a12 JTF_NUMBER_TABLE
1534: , p5_a13 JTF_NUMBER_TABLE
1535: , p5_a14 JTF_NUMBER_TABLE
1536: , p5_a15 JTF_NUMBER_TABLE
1537: , p5_a16 JTF_DATE_TABLE

Line 1534: , p5_a13 JTF_NUMBER_TABLE

1530: , p5_a9 JTF_VARCHAR2_TABLE_100
1531: , p5_a10 JTF_VARCHAR2_TABLE_100
1532: , p5_a11 JTF_VARCHAR2_TABLE_100
1533: , p5_a12 JTF_NUMBER_TABLE
1534: , p5_a13 JTF_NUMBER_TABLE
1535: , p5_a14 JTF_NUMBER_TABLE
1536: , p5_a15 JTF_NUMBER_TABLE
1537: , p5_a16 JTF_DATE_TABLE
1538: , p5_a17 JTF_VARCHAR2_TABLE_100

Line 1535: , p5_a14 JTF_NUMBER_TABLE

1531: , p5_a10 JTF_VARCHAR2_TABLE_100
1532: , p5_a11 JTF_VARCHAR2_TABLE_100
1533: , p5_a12 JTF_NUMBER_TABLE
1534: , p5_a13 JTF_NUMBER_TABLE
1535: , p5_a14 JTF_NUMBER_TABLE
1536: , p5_a15 JTF_NUMBER_TABLE
1537: , p5_a16 JTF_DATE_TABLE
1538: , p5_a17 JTF_VARCHAR2_TABLE_100
1539: , p5_a18 JTF_VARCHAR2_TABLE_500

Line 1536: , p5_a15 JTF_NUMBER_TABLE

1532: , p5_a11 JTF_VARCHAR2_TABLE_100
1533: , p5_a12 JTF_NUMBER_TABLE
1534: , p5_a13 JTF_NUMBER_TABLE
1535: , p5_a14 JTF_NUMBER_TABLE
1536: , p5_a15 JTF_NUMBER_TABLE
1537: , p5_a16 JTF_DATE_TABLE
1538: , p5_a17 JTF_VARCHAR2_TABLE_100
1539: , p5_a18 JTF_VARCHAR2_TABLE_500
1540: , p5_a19 JTF_VARCHAR2_TABLE_500

Line 1554: , p5_a33 JTF_NUMBER_TABLE

1550: , p5_a29 JTF_VARCHAR2_TABLE_500
1551: , p5_a30 JTF_VARCHAR2_TABLE_500
1552: , p5_a31 JTF_VARCHAR2_TABLE_500
1553: , p5_a32 JTF_VARCHAR2_TABLE_500
1554: , p5_a33 JTF_NUMBER_TABLE
1555: , p5_a34 JTF_DATE_TABLE
1556: , p5_a35 JTF_NUMBER_TABLE
1557: , p5_a36 JTF_DATE_TABLE
1558: , p5_a37 JTF_NUMBER_TABLE

Line 1556: , p5_a35 JTF_NUMBER_TABLE

1552: , p5_a31 JTF_VARCHAR2_TABLE_500
1553: , p5_a32 JTF_VARCHAR2_TABLE_500
1554: , p5_a33 JTF_NUMBER_TABLE
1555: , p5_a34 JTF_DATE_TABLE
1556: , p5_a35 JTF_NUMBER_TABLE
1557: , p5_a36 JTF_DATE_TABLE
1558: , p5_a37 JTF_NUMBER_TABLE
1559: , p6_a0 out nocopy JTF_NUMBER_TABLE
1560: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 1558: , p5_a37 JTF_NUMBER_TABLE

1554: , p5_a33 JTF_NUMBER_TABLE
1555: , p5_a34 JTF_DATE_TABLE
1556: , p5_a35 JTF_NUMBER_TABLE
1557: , p5_a36 JTF_DATE_TABLE
1558: , p5_a37 JTF_NUMBER_TABLE
1559: , p6_a0 out nocopy JTF_NUMBER_TABLE
1560: , p6_a1 out nocopy JTF_NUMBER_TABLE
1561: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1562: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

Line 1559: , p6_a0 out nocopy JTF_NUMBER_TABLE

1555: , p5_a34 JTF_DATE_TABLE
1556: , p5_a35 JTF_NUMBER_TABLE
1557: , p5_a36 JTF_DATE_TABLE
1558: , p5_a37 JTF_NUMBER_TABLE
1559: , p6_a0 out nocopy JTF_NUMBER_TABLE
1560: , p6_a1 out nocopy JTF_NUMBER_TABLE
1561: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1562: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1563: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 1560: , p6_a1 out nocopy JTF_NUMBER_TABLE

1556: , p5_a35 JTF_NUMBER_TABLE
1557: , p5_a36 JTF_DATE_TABLE
1558: , p5_a37 JTF_NUMBER_TABLE
1559: , p6_a0 out nocopy JTF_NUMBER_TABLE
1560: , p6_a1 out nocopy JTF_NUMBER_TABLE
1561: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1562: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1563: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1564: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200

Line 1571: , p6_a12 out nocopy JTF_NUMBER_TABLE

1567: , p6_a8 out nocopy JTF_DATE_TABLE
1568: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
1569: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
1570: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
1571: , p6_a12 out nocopy JTF_NUMBER_TABLE
1572: , p6_a13 out nocopy JTF_NUMBER_TABLE
1573: , p6_a14 out nocopy JTF_NUMBER_TABLE
1574: , p6_a15 out nocopy JTF_NUMBER_TABLE
1575: , p6_a16 out nocopy JTF_DATE_TABLE

Line 1572: , p6_a13 out nocopy JTF_NUMBER_TABLE

1568: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
1569: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
1570: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
1571: , p6_a12 out nocopy JTF_NUMBER_TABLE
1572: , p6_a13 out nocopy JTF_NUMBER_TABLE
1573: , p6_a14 out nocopy JTF_NUMBER_TABLE
1574: , p6_a15 out nocopy JTF_NUMBER_TABLE
1575: , p6_a16 out nocopy JTF_DATE_TABLE
1576: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100

Line 1573: , p6_a14 out nocopy JTF_NUMBER_TABLE

1569: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
1570: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
1571: , p6_a12 out nocopy JTF_NUMBER_TABLE
1572: , p6_a13 out nocopy JTF_NUMBER_TABLE
1573: , p6_a14 out nocopy JTF_NUMBER_TABLE
1574: , p6_a15 out nocopy JTF_NUMBER_TABLE
1575: , p6_a16 out nocopy JTF_DATE_TABLE
1576: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
1577: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500

Line 1574: , p6_a15 out nocopy JTF_NUMBER_TABLE

1570: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
1571: , p6_a12 out nocopy JTF_NUMBER_TABLE
1572: , p6_a13 out nocopy JTF_NUMBER_TABLE
1573: , p6_a14 out nocopy JTF_NUMBER_TABLE
1574: , p6_a15 out nocopy JTF_NUMBER_TABLE
1575: , p6_a16 out nocopy JTF_DATE_TABLE
1576: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
1577: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
1578: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500

Line 1592: , p6_a33 out nocopy JTF_NUMBER_TABLE

1588: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_500
1589: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_500
1590: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_500
1591: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
1592: , p6_a33 out nocopy JTF_NUMBER_TABLE
1593: , p6_a34 out nocopy JTF_DATE_TABLE
1594: , p6_a35 out nocopy JTF_NUMBER_TABLE
1595: , p6_a36 out nocopy JTF_DATE_TABLE
1596: , p6_a37 out nocopy JTF_NUMBER_TABLE

Line 1594: , p6_a35 out nocopy JTF_NUMBER_TABLE

1590: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_500
1591: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
1592: , p6_a33 out nocopy JTF_NUMBER_TABLE
1593: , p6_a34 out nocopy JTF_DATE_TABLE
1594: , p6_a35 out nocopy JTF_NUMBER_TABLE
1595: , p6_a36 out nocopy JTF_DATE_TABLE
1596: , p6_a37 out nocopy JTF_NUMBER_TABLE
1597: )
1598:

Line 1596: , p6_a37 out nocopy JTF_NUMBER_TABLE

1592: , p6_a33 out nocopy JTF_NUMBER_TABLE
1593: , p6_a34 out nocopy JTF_DATE_TABLE
1594: , p6_a35 out nocopy JTF_NUMBER_TABLE
1595: , p6_a36 out nocopy JTF_DATE_TABLE
1596: , p6_a37 out nocopy JTF_NUMBER_TABLE
1597: )
1598:
1599: as
1600: ddp_sipv_tbl okl_sip_pvt.sipv_tbl_type;

Line 1825: , p5_a0 JTF_NUMBER_TABLE

1821: , p_init_msg_list VARCHAR2
1822: , x_return_status out nocopy VARCHAR2
1823: , x_msg_count out nocopy NUMBER
1824: , x_msg_data out nocopy VARCHAR2
1825: , p5_a0 JTF_NUMBER_TABLE
1826: , p5_a1 JTF_NUMBER_TABLE
1827: , p5_a2 JTF_VARCHAR2_TABLE_100
1828: , p5_a3 JTF_VARCHAR2_TABLE_100
1829: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 1826: , p5_a1 JTF_NUMBER_TABLE

1822: , x_return_status out nocopy VARCHAR2
1823: , x_msg_count out nocopy NUMBER
1824: , x_msg_data out nocopy VARCHAR2
1825: , p5_a0 JTF_NUMBER_TABLE
1826: , p5_a1 JTF_NUMBER_TABLE
1827: , p5_a2 JTF_VARCHAR2_TABLE_100
1828: , p5_a3 JTF_VARCHAR2_TABLE_100
1829: , p5_a4 JTF_VARCHAR2_TABLE_100
1830: , p5_a5 JTF_VARCHAR2_TABLE_200

Line 1837: , p5_a12 JTF_NUMBER_TABLE

1833: , p5_a8 JTF_DATE_TABLE
1834: , p5_a9 JTF_VARCHAR2_TABLE_100
1835: , p5_a10 JTF_VARCHAR2_TABLE_100
1836: , p5_a11 JTF_VARCHAR2_TABLE_100
1837: , p5_a12 JTF_NUMBER_TABLE
1838: , p5_a13 JTF_NUMBER_TABLE
1839: , p5_a14 JTF_NUMBER_TABLE
1840: , p5_a15 JTF_NUMBER_TABLE
1841: , p5_a16 JTF_DATE_TABLE

Line 1838: , p5_a13 JTF_NUMBER_TABLE

1834: , p5_a9 JTF_VARCHAR2_TABLE_100
1835: , p5_a10 JTF_VARCHAR2_TABLE_100
1836: , p5_a11 JTF_VARCHAR2_TABLE_100
1837: , p5_a12 JTF_NUMBER_TABLE
1838: , p5_a13 JTF_NUMBER_TABLE
1839: , p5_a14 JTF_NUMBER_TABLE
1840: , p5_a15 JTF_NUMBER_TABLE
1841: , p5_a16 JTF_DATE_TABLE
1842: , p5_a17 JTF_VARCHAR2_TABLE_100

Line 1839: , p5_a14 JTF_NUMBER_TABLE

1835: , p5_a10 JTF_VARCHAR2_TABLE_100
1836: , p5_a11 JTF_VARCHAR2_TABLE_100
1837: , p5_a12 JTF_NUMBER_TABLE
1838: , p5_a13 JTF_NUMBER_TABLE
1839: , p5_a14 JTF_NUMBER_TABLE
1840: , p5_a15 JTF_NUMBER_TABLE
1841: , p5_a16 JTF_DATE_TABLE
1842: , p5_a17 JTF_VARCHAR2_TABLE_100
1843: , p5_a18 JTF_VARCHAR2_TABLE_500

Line 1840: , p5_a15 JTF_NUMBER_TABLE

1836: , p5_a11 JTF_VARCHAR2_TABLE_100
1837: , p5_a12 JTF_NUMBER_TABLE
1838: , p5_a13 JTF_NUMBER_TABLE
1839: , p5_a14 JTF_NUMBER_TABLE
1840: , p5_a15 JTF_NUMBER_TABLE
1841: , p5_a16 JTF_DATE_TABLE
1842: , p5_a17 JTF_VARCHAR2_TABLE_100
1843: , p5_a18 JTF_VARCHAR2_TABLE_500
1844: , p5_a19 JTF_VARCHAR2_TABLE_500

Line 1858: , p5_a33 JTF_NUMBER_TABLE

1854: , p5_a29 JTF_VARCHAR2_TABLE_500
1855: , p5_a30 JTF_VARCHAR2_TABLE_500
1856: , p5_a31 JTF_VARCHAR2_TABLE_500
1857: , p5_a32 JTF_VARCHAR2_TABLE_500
1858: , p5_a33 JTF_NUMBER_TABLE
1859: , p5_a34 JTF_DATE_TABLE
1860: , p5_a35 JTF_NUMBER_TABLE
1861: , p5_a36 JTF_DATE_TABLE
1862: , p5_a37 JTF_NUMBER_TABLE

Line 1860: , p5_a35 JTF_NUMBER_TABLE

1856: , p5_a31 JTF_VARCHAR2_TABLE_500
1857: , p5_a32 JTF_VARCHAR2_TABLE_500
1858: , p5_a33 JTF_NUMBER_TABLE
1859: , p5_a34 JTF_DATE_TABLE
1860: , p5_a35 JTF_NUMBER_TABLE
1861: , p5_a36 JTF_DATE_TABLE
1862: , p5_a37 JTF_NUMBER_TABLE
1863: )
1864:

Line 1862: , p5_a37 JTF_NUMBER_TABLE

1858: , p5_a33 JTF_NUMBER_TABLE
1859: , p5_a34 JTF_DATE_TABLE
1860: , p5_a35 JTF_NUMBER_TABLE
1861: , p5_a36 JTF_DATE_TABLE
1862: , p5_a37 JTF_NUMBER_TABLE
1863: )
1864:
1865: as
1866: ddp_sipv_tbl okl_sip_pvt.sipv_tbl_type;

Line 2048: , p5_a0 JTF_NUMBER_TABLE

2044: , p_init_msg_list VARCHAR2
2045: , x_return_status out nocopy VARCHAR2
2046: , x_msg_count out nocopy NUMBER
2047: , x_msg_data out nocopy VARCHAR2
2048: , p5_a0 JTF_NUMBER_TABLE
2049: , p5_a1 JTF_NUMBER_TABLE
2050: , p5_a2 JTF_VARCHAR2_TABLE_100
2051: , p5_a3 JTF_VARCHAR2_TABLE_100
2052: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 2049: , p5_a1 JTF_NUMBER_TABLE

2045: , x_return_status out nocopy VARCHAR2
2046: , x_msg_count out nocopy NUMBER
2047: , x_msg_data out nocopy VARCHAR2
2048: , p5_a0 JTF_NUMBER_TABLE
2049: , p5_a1 JTF_NUMBER_TABLE
2050: , p5_a2 JTF_VARCHAR2_TABLE_100
2051: , p5_a3 JTF_VARCHAR2_TABLE_100
2052: , p5_a4 JTF_VARCHAR2_TABLE_100
2053: , p5_a5 JTF_VARCHAR2_TABLE_200

Line 2060: , p5_a12 JTF_NUMBER_TABLE

2056: , p5_a8 JTF_DATE_TABLE
2057: , p5_a9 JTF_VARCHAR2_TABLE_100
2058: , p5_a10 JTF_VARCHAR2_TABLE_100
2059: , p5_a11 JTF_VARCHAR2_TABLE_100
2060: , p5_a12 JTF_NUMBER_TABLE
2061: , p5_a13 JTF_NUMBER_TABLE
2062: , p5_a14 JTF_NUMBER_TABLE
2063: , p5_a15 JTF_NUMBER_TABLE
2064: , p5_a16 JTF_DATE_TABLE

Line 2061: , p5_a13 JTF_NUMBER_TABLE

2057: , p5_a9 JTF_VARCHAR2_TABLE_100
2058: , p5_a10 JTF_VARCHAR2_TABLE_100
2059: , p5_a11 JTF_VARCHAR2_TABLE_100
2060: , p5_a12 JTF_NUMBER_TABLE
2061: , p5_a13 JTF_NUMBER_TABLE
2062: , p5_a14 JTF_NUMBER_TABLE
2063: , p5_a15 JTF_NUMBER_TABLE
2064: , p5_a16 JTF_DATE_TABLE
2065: , p5_a17 JTF_VARCHAR2_TABLE_100

Line 2062: , p5_a14 JTF_NUMBER_TABLE

2058: , p5_a10 JTF_VARCHAR2_TABLE_100
2059: , p5_a11 JTF_VARCHAR2_TABLE_100
2060: , p5_a12 JTF_NUMBER_TABLE
2061: , p5_a13 JTF_NUMBER_TABLE
2062: , p5_a14 JTF_NUMBER_TABLE
2063: , p5_a15 JTF_NUMBER_TABLE
2064: , p5_a16 JTF_DATE_TABLE
2065: , p5_a17 JTF_VARCHAR2_TABLE_100
2066: , p5_a18 JTF_VARCHAR2_TABLE_500

Line 2063: , p5_a15 JTF_NUMBER_TABLE

2059: , p5_a11 JTF_VARCHAR2_TABLE_100
2060: , p5_a12 JTF_NUMBER_TABLE
2061: , p5_a13 JTF_NUMBER_TABLE
2062: , p5_a14 JTF_NUMBER_TABLE
2063: , p5_a15 JTF_NUMBER_TABLE
2064: , p5_a16 JTF_DATE_TABLE
2065: , p5_a17 JTF_VARCHAR2_TABLE_100
2066: , p5_a18 JTF_VARCHAR2_TABLE_500
2067: , p5_a19 JTF_VARCHAR2_TABLE_500

Line 2081: , p5_a33 JTF_NUMBER_TABLE

2077: , p5_a29 JTF_VARCHAR2_TABLE_500
2078: , p5_a30 JTF_VARCHAR2_TABLE_500
2079: , p5_a31 JTF_VARCHAR2_TABLE_500
2080: , p5_a32 JTF_VARCHAR2_TABLE_500
2081: , p5_a33 JTF_NUMBER_TABLE
2082: , p5_a34 JTF_DATE_TABLE
2083: , p5_a35 JTF_NUMBER_TABLE
2084: , p5_a36 JTF_DATE_TABLE
2085: , p5_a37 JTF_NUMBER_TABLE

Line 2083: , p5_a35 JTF_NUMBER_TABLE

2079: , p5_a31 JTF_VARCHAR2_TABLE_500
2080: , p5_a32 JTF_VARCHAR2_TABLE_500
2081: , p5_a33 JTF_NUMBER_TABLE
2082: , p5_a34 JTF_DATE_TABLE
2083: , p5_a35 JTF_NUMBER_TABLE
2084: , p5_a36 JTF_DATE_TABLE
2085: , p5_a37 JTF_NUMBER_TABLE
2086: )
2087:

Line 2085: , p5_a37 JTF_NUMBER_TABLE

2081: , p5_a33 JTF_NUMBER_TABLE
2082: , p5_a34 JTF_DATE_TABLE
2083: , p5_a35 JTF_NUMBER_TABLE
2084: , p5_a36 JTF_DATE_TABLE
2085: , p5_a37 JTF_NUMBER_TABLE
2086: )
2087:
2088: as
2089: ddp_sipv_tbl okl_sip_pvt.sipv_tbl_type;