DBA Data[Home] [Help]

APPS.OKL_POOL_PVT_W dependencies on JTF_VARCHAR2_TABLE_200

Line 29: , a4 JTF_VARCHAR2_TABLE_200

25: procedure rosetta_table_copy_in_p46(t out nocopy okl_pool_pvt.polsrch_tbl_type, a0 JTF_NUMBER_TABLE
26: , a1 JTF_VARCHAR2_TABLE_400
27: , a2 JTF_VARCHAR2_TABLE_100
28: , a3 JTF_NUMBER_TABLE
29: , a4 JTF_VARCHAR2_TABLE_200
30: , a5 JTF_NUMBER_TABLE
31: , a6 JTF_NUMBER_TABLE
32: , a7 JTF_VARCHAR2_TABLE_100
33: , a8 JTF_NUMBER_TABLE

Line 53: , a28 JTF_VARCHAR2_TABLE_200

49: , a24 JTF_NUMBER_TABLE
50: , a25 JTF_NUMBER_TABLE
51: , a26 JTF_NUMBER_TABLE
52: , a27 JTF_NUMBER_TABLE
53: , a28 JTF_VARCHAR2_TABLE_200
54: , a29 JTF_VARCHAR2_TABLE_200
55: , a30 JTF_VARCHAR2_TABLE_100
56: , a31 JTF_VARCHAR2_TABLE_100
57: , a32 JTF_DATE_TABLE

Line 54: , a29 JTF_VARCHAR2_TABLE_200

50: , a25 JTF_NUMBER_TABLE
51: , a26 JTF_NUMBER_TABLE
52: , a27 JTF_NUMBER_TABLE
53: , a28 JTF_VARCHAR2_TABLE_200
54: , a29 JTF_VARCHAR2_TABLE_200
55: , a30 JTF_VARCHAR2_TABLE_100
56: , a31 JTF_VARCHAR2_TABLE_100
57: , a32 JTF_DATE_TABLE
58: , a33 JTF_DATE_TABLE

Line 126: , a4 out nocopy JTF_VARCHAR2_TABLE_200

122: procedure rosetta_table_copy_out_p46(t okl_pool_pvt.polsrch_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
123: , a1 out nocopy JTF_VARCHAR2_TABLE_400
124: , a2 out nocopy JTF_VARCHAR2_TABLE_100
125: , a3 out nocopy JTF_NUMBER_TABLE
126: , a4 out nocopy JTF_VARCHAR2_TABLE_200
127: , a5 out nocopy JTF_NUMBER_TABLE
128: , a6 out nocopy JTF_NUMBER_TABLE
129: , a7 out nocopy JTF_VARCHAR2_TABLE_100
130: , a8 out nocopy JTF_NUMBER_TABLE

Line 150: , a28 out nocopy JTF_VARCHAR2_TABLE_200

146: , a24 out nocopy JTF_NUMBER_TABLE
147: , a25 out nocopy JTF_NUMBER_TABLE
148: , a26 out nocopy JTF_NUMBER_TABLE
149: , a27 out nocopy JTF_NUMBER_TABLE
150: , a28 out nocopy JTF_VARCHAR2_TABLE_200
151: , a29 out nocopy JTF_VARCHAR2_TABLE_200
152: , a30 out nocopy JTF_VARCHAR2_TABLE_100
153: , a31 out nocopy JTF_VARCHAR2_TABLE_100
154: , a32 out nocopy JTF_DATE_TABLE

Line 151: , a29 out nocopy JTF_VARCHAR2_TABLE_200

147: , a25 out nocopy JTF_NUMBER_TABLE
148: , a26 out nocopy JTF_NUMBER_TABLE
149: , a27 out nocopy JTF_NUMBER_TABLE
150: , a28 out nocopy JTF_VARCHAR2_TABLE_200
151: , a29 out nocopy JTF_VARCHAR2_TABLE_200
152: , a30 out nocopy JTF_VARCHAR2_TABLE_100
153: , a31 out nocopy JTF_VARCHAR2_TABLE_100
154: , a32 out nocopy JTF_DATE_TABLE
155: , a33 out nocopy JTF_DATE_TABLE

Line 170: a4 := JTF_VARCHAR2_TABLE_200();

166: a0 := JTF_NUMBER_TABLE();
167: a1 := JTF_VARCHAR2_TABLE_400();
168: a2 := JTF_VARCHAR2_TABLE_100();
169: a3 := JTF_NUMBER_TABLE();
170: a4 := JTF_VARCHAR2_TABLE_200();
171: a5 := JTF_NUMBER_TABLE();
172: a6 := JTF_NUMBER_TABLE();
173: a7 := JTF_VARCHAR2_TABLE_100();
174: a8 := JTF_NUMBER_TABLE();

Line 194: a28 := JTF_VARCHAR2_TABLE_200();

190: a24 := JTF_NUMBER_TABLE();
191: a25 := JTF_NUMBER_TABLE();
192: a26 := JTF_NUMBER_TABLE();
193: a27 := JTF_NUMBER_TABLE();
194: a28 := JTF_VARCHAR2_TABLE_200();
195: a29 := JTF_VARCHAR2_TABLE_200();
196: a30 := JTF_VARCHAR2_TABLE_100();
197: a31 := JTF_VARCHAR2_TABLE_100();
198: a32 := JTF_DATE_TABLE();

Line 195: a29 := JTF_VARCHAR2_TABLE_200();

191: a25 := JTF_NUMBER_TABLE();
192: a26 := JTF_NUMBER_TABLE();
193: a27 := JTF_NUMBER_TABLE();
194: a28 := JTF_VARCHAR2_TABLE_200();
195: a29 := JTF_VARCHAR2_TABLE_200();
196: a30 := JTF_VARCHAR2_TABLE_100();
197: a31 := JTF_VARCHAR2_TABLE_100();
198: a32 := JTF_DATE_TABLE();
199: a33 := JTF_DATE_TABLE();

Line 211: a4 := JTF_VARCHAR2_TABLE_200();

207: a0 := JTF_NUMBER_TABLE();
208: a1 := JTF_VARCHAR2_TABLE_400();
209: a2 := JTF_VARCHAR2_TABLE_100();
210: a3 := JTF_NUMBER_TABLE();
211: a4 := JTF_VARCHAR2_TABLE_200();
212: a5 := JTF_NUMBER_TABLE();
213: a6 := JTF_NUMBER_TABLE();
214: a7 := JTF_VARCHAR2_TABLE_100();
215: a8 := JTF_NUMBER_TABLE();

Line 235: a28 := JTF_VARCHAR2_TABLE_200();

231: a24 := JTF_NUMBER_TABLE();
232: a25 := JTF_NUMBER_TABLE();
233: a26 := JTF_NUMBER_TABLE();
234: a27 := JTF_NUMBER_TABLE();
235: a28 := JTF_VARCHAR2_TABLE_200();
236: a29 := JTF_VARCHAR2_TABLE_200();
237: a30 := JTF_VARCHAR2_TABLE_100();
238: a31 := JTF_VARCHAR2_TABLE_100();
239: a32 := JTF_DATE_TABLE();

Line 236: a29 := JTF_VARCHAR2_TABLE_200();

232: a25 := JTF_NUMBER_TABLE();
233: a26 := JTF_NUMBER_TABLE();
234: a27 := JTF_NUMBER_TABLE();
235: a28 := JTF_VARCHAR2_TABLE_200();
236: a29 := JTF_VARCHAR2_TABLE_200();
237: a30 := JTF_VARCHAR2_TABLE_100();
238: a31 := JTF_VARCHAR2_TABLE_100();
239: a32 := JTF_DATE_TABLE();
240: a33 := JTF_DATE_TABLE();

Line 342: , a1 JTF_VARCHAR2_TABLE_200

338: end if;
339: end rosetta_table_copy_out_p46;
340:
341: procedure rosetta_table_copy_in_p48(t out nocopy okl_pool_pvt.poc_uv_tbl_type, a0 JTF_NUMBER_TABLE
342: , a1 JTF_VARCHAR2_TABLE_200
343: , a2 JTF_VARCHAR2_TABLE_200
344: , a3 JTF_VARCHAR2_TABLE_400
345: , a4 JTF_VARCHAR2_TABLE_200
346: , a5 JTF_NUMBER_TABLE

Line 343: , a2 JTF_VARCHAR2_TABLE_200

339: end rosetta_table_copy_out_p46;
340:
341: procedure rosetta_table_copy_in_p48(t out nocopy okl_pool_pvt.poc_uv_tbl_type, a0 JTF_NUMBER_TABLE
342: , a1 JTF_VARCHAR2_TABLE_200
343: , a2 JTF_VARCHAR2_TABLE_200
344: , a3 JTF_VARCHAR2_TABLE_400
345: , a4 JTF_VARCHAR2_TABLE_200
346: , a5 JTF_NUMBER_TABLE
347: , a6 JTF_VARCHAR2_TABLE_100

Line 345: , a4 JTF_VARCHAR2_TABLE_200

341: procedure rosetta_table_copy_in_p48(t out nocopy okl_pool_pvt.poc_uv_tbl_type, a0 JTF_NUMBER_TABLE
342: , a1 JTF_VARCHAR2_TABLE_200
343: , a2 JTF_VARCHAR2_TABLE_200
344: , a3 JTF_VARCHAR2_TABLE_400
345: , a4 JTF_VARCHAR2_TABLE_200
346: , a5 JTF_NUMBER_TABLE
347: , a6 JTF_VARCHAR2_TABLE_100
348: , a7 JTF_VARCHAR2_TABLE_100
349: , a8 JTF_VARCHAR2_TABLE_100

Line 377: , a1 out nocopy JTF_VARCHAR2_TABLE_200

373: end if;
374: end if;
375: end rosetta_table_copy_in_p48;
376: procedure rosetta_table_copy_out_p48(t okl_pool_pvt.poc_uv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
377: , a1 out nocopy JTF_VARCHAR2_TABLE_200
378: , a2 out nocopy JTF_VARCHAR2_TABLE_200
379: , a3 out nocopy JTF_VARCHAR2_TABLE_400
380: , a4 out nocopy JTF_VARCHAR2_TABLE_200
381: , a5 out nocopy JTF_NUMBER_TABLE

Line 378: , a2 out nocopy JTF_VARCHAR2_TABLE_200

374: end if;
375: end rosetta_table_copy_in_p48;
376: procedure rosetta_table_copy_out_p48(t okl_pool_pvt.poc_uv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
377: , a1 out nocopy JTF_VARCHAR2_TABLE_200
378: , a2 out nocopy JTF_VARCHAR2_TABLE_200
379: , a3 out nocopy JTF_VARCHAR2_TABLE_400
380: , a4 out nocopy JTF_VARCHAR2_TABLE_200
381: , a5 out nocopy JTF_NUMBER_TABLE
382: , a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 380: , a4 out nocopy JTF_VARCHAR2_TABLE_200

376: procedure rosetta_table_copy_out_p48(t okl_pool_pvt.poc_uv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
377: , a1 out nocopy JTF_VARCHAR2_TABLE_200
378: , a2 out nocopy JTF_VARCHAR2_TABLE_200
379: , a3 out nocopy JTF_VARCHAR2_TABLE_400
380: , a4 out nocopy JTF_VARCHAR2_TABLE_200
381: , a5 out nocopy JTF_NUMBER_TABLE
382: , a6 out nocopy JTF_VARCHAR2_TABLE_100
383: , a7 out nocopy JTF_VARCHAR2_TABLE_100
384: , a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 390: a1 := JTF_VARCHAR2_TABLE_200();

386: ddindx binary_integer; indx binary_integer;
387: begin
388: if t is null or t.count = 0 then
389: a0 := JTF_NUMBER_TABLE();
390: a1 := JTF_VARCHAR2_TABLE_200();
391: a2 := JTF_VARCHAR2_TABLE_200();
392: a3 := JTF_VARCHAR2_TABLE_400();
393: a4 := JTF_VARCHAR2_TABLE_200();
394: a5 := JTF_NUMBER_TABLE();

Line 391: a2 := JTF_VARCHAR2_TABLE_200();

387: begin
388: if t is null or t.count = 0 then
389: a0 := JTF_NUMBER_TABLE();
390: a1 := JTF_VARCHAR2_TABLE_200();
391: a2 := JTF_VARCHAR2_TABLE_200();
392: a3 := JTF_VARCHAR2_TABLE_400();
393: a4 := JTF_VARCHAR2_TABLE_200();
394: a5 := JTF_NUMBER_TABLE();
395: a6 := JTF_VARCHAR2_TABLE_100();

Line 393: a4 := JTF_VARCHAR2_TABLE_200();

389: a0 := JTF_NUMBER_TABLE();
390: a1 := JTF_VARCHAR2_TABLE_200();
391: a2 := JTF_VARCHAR2_TABLE_200();
392: a3 := JTF_VARCHAR2_TABLE_400();
393: a4 := JTF_VARCHAR2_TABLE_200();
394: a5 := JTF_NUMBER_TABLE();
395: a6 := JTF_VARCHAR2_TABLE_100();
396: a7 := JTF_VARCHAR2_TABLE_100();
397: a8 := JTF_VARCHAR2_TABLE_100();

Line 400: a1 := JTF_VARCHAR2_TABLE_200();

396: a7 := JTF_VARCHAR2_TABLE_100();
397: a8 := JTF_VARCHAR2_TABLE_100();
398: else
399: a0 := JTF_NUMBER_TABLE();
400: a1 := JTF_VARCHAR2_TABLE_200();
401: a2 := JTF_VARCHAR2_TABLE_200();
402: a3 := JTF_VARCHAR2_TABLE_400();
403: a4 := JTF_VARCHAR2_TABLE_200();
404: a5 := JTF_NUMBER_TABLE();

Line 401: a2 := JTF_VARCHAR2_TABLE_200();

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

Line 403: a4 := JTF_VARCHAR2_TABLE_200();

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

Line 1204: , p5_a7 JTF_VARCHAR2_TABLE_200

1200: , p5_a3 JTF_NUMBER_TABLE
1201: , p5_a4 JTF_NUMBER_TABLE
1202: , p5_a5 JTF_NUMBER_TABLE
1203: , p5_a6 JTF_NUMBER_TABLE
1204: , p5_a7 JTF_VARCHAR2_TABLE_200
1205: , p5_a8 JTF_NUMBER_TABLE
1206: , p5_a9 JTF_DATE_TABLE
1207: , p5_a10 JTF_DATE_TABLE
1208: , p5_a11 JTF_NUMBER_TABLE

Line 1244: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_200

1240: , p6_a3 out nocopy JTF_NUMBER_TABLE
1241: , p6_a4 out nocopy JTF_NUMBER_TABLE
1242: , p6_a5 out nocopy JTF_NUMBER_TABLE
1243: , p6_a6 out nocopy JTF_NUMBER_TABLE
1244: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_200
1245: , p6_a8 out nocopy JTF_NUMBER_TABLE
1246: , p6_a9 out nocopy JTF_DATE_TABLE
1247: , p6_a10 out nocopy JTF_DATE_TABLE
1248: , p6_a11 out nocopy JTF_NUMBER_TABLE

Line 1604: , p5_a7 JTF_VARCHAR2_TABLE_200

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

Line 1644: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_200

1640: , p6_a3 out nocopy JTF_NUMBER_TABLE
1641: , p6_a4 out nocopy JTF_NUMBER_TABLE
1642: , p6_a5 out nocopy JTF_NUMBER_TABLE
1643: , p6_a6 out nocopy JTF_NUMBER_TABLE
1644: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_200
1645: , p6_a8 out nocopy JTF_NUMBER_TABLE
1646: , p6_a9 out nocopy JTF_DATE_TABLE
1647: , p6_a10 out nocopy JTF_DATE_TABLE
1648: , p6_a11 out nocopy JTF_NUMBER_TABLE

Line 1920: , p5_a7 JTF_VARCHAR2_TABLE_200

1916: , p5_a3 JTF_NUMBER_TABLE
1917: , p5_a4 JTF_NUMBER_TABLE
1918: , p5_a5 JTF_NUMBER_TABLE
1919: , p5_a6 JTF_NUMBER_TABLE
1920: , p5_a7 JTF_VARCHAR2_TABLE_200
1921: , p5_a8 JTF_NUMBER_TABLE
1922: , p5_a9 JTF_DATE_TABLE
1923: , p5_a10 JTF_DATE_TABLE
1924: , p5_a11 JTF_NUMBER_TABLE

Line 2738: , p33_a1 out nocopy JTF_VARCHAR2_TABLE_200

2734: , p_streams_from_date date
2735: , p_streams_to_date date
2736: , p_action_code VARCHAR2
2737: , p33_a0 out nocopy JTF_NUMBER_TABLE
2738: , p33_a1 out nocopy JTF_VARCHAR2_TABLE_200
2739: , p33_a2 out nocopy JTF_VARCHAR2_TABLE_200
2740: , p33_a3 out nocopy JTF_VARCHAR2_TABLE_400
2741: , p33_a4 out nocopy JTF_VARCHAR2_TABLE_200
2742: , p33_a5 out nocopy JTF_NUMBER_TABLE

Line 2739: , p33_a2 out nocopy JTF_VARCHAR2_TABLE_200

2735: , p_streams_to_date date
2736: , p_action_code VARCHAR2
2737: , p33_a0 out nocopy JTF_NUMBER_TABLE
2738: , p33_a1 out nocopy JTF_VARCHAR2_TABLE_200
2739: , p33_a2 out nocopy JTF_VARCHAR2_TABLE_200
2740: , p33_a3 out nocopy JTF_VARCHAR2_TABLE_400
2741: , p33_a4 out nocopy JTF_VARCHAR2_TABLE_200
2742: , p33_a5 out nocopy JTF_NUMBER_TABLE
2743: , p33_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 2741: , p33_a4 out nocopy JTF_VARCHAR2_TABLE_200

2737: , p33_a0 out nocopy JTF_NUMBER_TABLE
2738: , p33_a1 out nocopy JTF_VARCHAR2_TABLE_200
2739: , p33_a2 out nocopy JTF_VARCHAR2_TABLE_200
2740: , p33_a3 out nocopy JTF_VARCHAR2_TABLE_400
2741: , p33_a4 out nocopy JTF_VARCHAR2_TABLE_200
2742: , p33_a5 out nocopy JTF_NUMBER_TABLE
2743: , p33_a6 out nocopy JTF_VARCHAR2_TABLE_100
2744: , p33_a7 out nocopy JTF_VARCHAR2_TABLE_100
2745: , p33_a8 out nocopy JTF_VARCHAR2_TABLE_100