DBA Data[Home] [Help]

APPS.OKL_AVL_PVT_W dependencies on JTF_VARCHAR2_TABLE_200

Line 23: , a1 JTF_VARCHAR2_TABLE_200

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

Line 38: , a16 JTF_VARCHAR2_TABLE_2000

34: , a12 JTF_DATE_TABLE
35: , a13 JTF_NUMBER_TABLE
36: , a14 JTF_VARCHAR2_TABLE_100
37: , a15 JTF_VARCHAR2_TABLE_100
38: , a16 JTF_VARCHAR2_TABLE_2000
39: , a17 JTF_VARCHAR2_TABLE_100
40: , a18 JTF_DATE_TABLE
41: , a19 JTF_VARCHAR2_TABLE_100
42: , a20 JTF_NUMBER_TABLE

Line 126: , a1 out nocopy JTF_VARCHAR2_TABLE_200

122: end if;
123: end if;
124: end rosetta_table_copy_in_p2;
125: procedure rosetta_table_copy_out_p2(t okl_avl_pvt.avl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
126: , a1 out nocopy JTF_VARCHAR2_TABLE_200
127: , a2 out nocopy JTF_NUMBER_TABLE
128: , a3 out nocopy JTF_NUMBER_TABLE
129: , a4 out nocopy JTF_NUMBER_TABLE
130: , a5 out nocopy JTF_NUMBER_TABLE

Line 141: , a16 out nocopy JTF_VARCHAR2_TABLE_2000

137: , a12 out nocopy JTF_DATE_TABLE
138: , a13 out nocopy JTF_NUMBER_TABLE
139: , a14 out nocopy JTF_VARCHAR2_TABLE_100
140: , a15 out nocopy JTF_VARCHAR2_TABLE_100
141: , a16 out nocopy JTF_VARCHAR2_TABLE_2000
142: , a17 out nocopy JTF_VARCHAR2_TABLE_100
143: , a18 out nocopy JTF_DATE_TABLE
144: , a19 out nocopy JTF_VARCHAR2_TABLE_100
145: , a20 out nocopy JTF_NUMBER_TABLE

Line 173: a1 := JTF_VARCHAR2_TABLE_200();

169: ddindx binary_integer; indx binary_integer;
170: begin
171: if t is null or t.count = 0 then
172: a0 := JTF_NUMBER_TABLE();
173: a1 := JTF_VARCHAR2_TABLE_200();
174: a2 := JTF_NUMBER_TABLE();
175: a3 := JTF_NUMBER_TABLE();
176: a4 := JTF_NUMBER_TABLE();
177: a5 := JTF_NUMBER_TABLE();

Line 188: a16 := JTF_VARCHAR2_TABLE_2000();

184: a12 := JTF_DATE_TABLE();
185: a13 := JTF_NUMBER_TABLE();
186: a14 := JTF_VARCHAR2_TABLE_100();
187: a15 := JTF_VARCHAR2_TABLE_100();
188: a16 := JTF_VARCHAR2_TABLE_2000();
189: a17 := JTF_VARCHAR2_TABLE_100();
190: a18 := JTF_DATE_TABLE();
191: a19 := JTF_VARCHAR2_TABLE_100();
192: a20 := JTF_NUMBER_TABLE();

Line 217: a1 := JTF_VARCHAR2_TABLE_200();

213: a41 := JTF_NUMBER_TABLE();
214: a42 := JTF_VARCHAR2_TABLE_100();
215: else
216: a0 := JTF_NUMBER_TABLE();
217: a1 := JTF_VARCHAR2_TABLE_200();
218: a2 := JTF_NUMBER_TABLE();
219: a3 := JTF_NUMBER_TABLE();
220: a4 := JTF_NUMBER_TABLE();
221: a5 := JTF_NUMBER_TABLE();

Line 232: a16 := JTF_VARCHAR2_TABLE_2000();

228: a12 := JTF_DATE_TABLE();
229: a13 := JTF_NUMBER_TABLE();
230: a14 := JTF_VARCHAR2_TABLE_100();
231: a15 := JTF_VARCHAR2_TABLE_100();
232: a16 := JTF_VARCHAR2_TABLE_2000();
233: a17 := JTF_VARCHAR2_TABLE_100();
234: a18 := JTF_DATE_TABLE();
235: a19 := JTF_VARCHAR2_TABLE_100();
236: a20 := JTF_NUMBER_TABLE();

Line 372: , a13 JTF_VARCHAR2_TABLE_200

368: , a9 JTF_VARCHAR2_TABLE_100
369: , a10 JTF_VARCHAR2_TABLE_100
370: , a11 JTF_VARCHAR2_TABLE_100
371: , a12 JTF_VARCHAR2_TABLE_100
372: , a13 JTF_VARCHAR2_TABLE_200
373: , a14 JTF_VARCHAR2_TABLE_2000
374: , a15 JTF_VARCHAR2_TABLE_100
375: , a16 JTF_VARCHAR2_TABLE_100
376: , a17 JTF_DATE_TABLE

Line 373: , a14 JTF_VARCHAR2_TABLE_2000

369: , a10 JTF_VARCHAR2_TABLE_100
370: , a11 JTF_VARCHAR2_TABLE_100
371: , a12 JTF_VARCHAR2_TABLE_100
372: , a13 JTF_VARCHAR2_TABLE_200
373: , a14 JTF_VARCHAR2_TABLE_2000
374: , a15 JTF_VARCHAR2_TABLE_100
375: , a16 JTF_VARCHAR2_TABLE_100
376: , a17 JTF_DATE_TABLE
377: , a18 JTF_DATE_TABLE

Line 475: , a13 out nocopy JTF_VARCHAR2_TABLE_200

471: , a9 out nocopy JTF_VARCHAR2_TABLE_100
472: , a10 out nocopy JTF_VARCHAR2_TABLE_100
473: , a11 out nocopy JTF_VARCHAR2_TABLE_100
474: , a12 out nocopy JTF_VARCHAR2_TABLE_100
475: , a13 out nocopy JTF_VARCHAR2_TABLE_200
476: , a14 out nocopy JTF_VARCHAR2_TABLE_2000
477: , a15 out nocopy JTF_VARCHAR2_TABLE_100
478: , a16 out nocopy JTF_VARCHAR2_TABLE_100
479: , a17 out nocopy JTF_DATE_TABLE

Line 476: , a14 out nocopy JTF_VARCHAR2_TABLE_2000

472: , a10 out nocopy JTF_VARCHAR2_TABLE_100
473: , a11 out nocopy JTF_VARCHAR2_TABLE_100
474: , a12 out nocopy JTF_VARCHAR2_TABLE_100
475: , a13 out nocopy JTF_VARCHAR2_TABLE_200
476: , a14 out nocopy JTF_VARCHAR2_TABLE_2000
477: , a15 out nocopy JTF_VARCHAR2_TABLE_100
478: , a16 out nocopy JTF_VARCHAR2_TABLE_100
479: , a17 out nocopy JTF_DATE_TABLE
480: , a18 out nocopy JTF_DATE_TABLE

Line 522: a13 := JTF_VARCHAR2_TABLE_200();

518: a9 := JTF_VARCHAR2_TABLE_100();
519: a10 := JTF_VARCHAR2_TABLE_100();
520: a11 := JTF_VARCHAR2_TABLE_100();
521: a12 := JTF_VARCHAR2_TABLE_100();
522: a13 := JTF_VARCHAR2_TABLE_200();
523: a14 := JTF_VARCHAR2_TABLE_2000();
524: a15 := JTF_VARCHAR2_TABLE_100();
525: a16 := JTF_VARCHAR2_TABLE_100();
526: a17 := JTF_DATE_TABLE();

Line 523: a14 := JTF_VARCHAR2_TABLE_2000();

519: a10 := JTF_VARCHAR2_TABLE_100();
520: a11 := JTF_VARCHAR2_TABLE_100();
521: a12 := JTF_VARCHAR2_TABLE_100();
522: a13 := JTF_VARCHAR2_TABLE_200();
523: a14 := JTF_VARCHAR2_TABLE_2000();
524: a15 := JTF_VARCHAR2_TABLE_100();
525: a16 := JTF_VARCHAR2_TABLE_100();
526: a17 := JTF_DATE_TABLE();
527: a18 := JTF_DATE_TABLE();

Line 566: a13 := JTF_VARCHAR2_TABLE_200();

562: a9 := JTF_VARCHAR2_TABLE_100();
563: a10 := JTF_VARCHAR2_TABLE_100();
564: a11 := JTF_VARCHAR2_TABLE_100();
565: a12 := JTF_VARCHAR2_TABLE_100();
566: a13 := JTF_VARCHAR2_TABLE_200();
567: a14 := JTF_VARCHAR2_TABLE_2000();
568: a15 := JTF_VARCHAR2_TABLE_100();
569: a16 := JTF_VARCHAR2_TABLE_100();
570: a17 := JTF_DATE_TABLE();

Line 567: a14 := JTF_VARCHAR2_TABLE_2000();

563: a10 := JTF_VARCHAR2_TABLE_100();
564: a11 := JTF_VARCHAR2_TABLE_100();
565: a12 := JTF_VARCHAR2_TABLE_100();
566: a13 := JTF_VARCHAR2_TABLE_200();
567: a14 := JTF_VARCHAR2_TABLE_2000();
568: a15 := JTF_VARCHAR2_TABLE_100();
569: a16 := JTF_VARCHAR2_TABLE_100();
570: a17 := JTF_DATE_TABLE();
571: a18 := JTF_DATE_TABLE();

Line 925: , p5_a13 JTF_VARCHAR2_TABLE_200

921: , p5_a9 JTF_VARCHAR2_TABLE_100
922: , p5_a10 JTF_VARCHAR2_TABLE_100
923: , p5_a11 JTF_VARCHAR2_TABLE_100
924: , p5_a12 JTF_VARCHAR2_TABLE_100
925: , p5_a13 JTF_VARCHAR2_TABLE_200
926: , p5_a14 JTF_VARCHAR2_TABLE_2000
927: , p5_a15 JTF_VARCHAR2_TABLE_100
928: , p5_a16 JTF_VARCHAR2_TABLE_100
929: , p5_a17 JTF_DATE_TABLE

Line 926: , p5_a14 JTF_VARCHAR2_TABLE_2000

922: , p5_a10 JTF_VARCHAR2_TABLE_100
923: , p5_a11 JTF_VARCHAR2_TABLE_100
924: , p5_a12 JTF_VARCHAR2_TABLE_100
925: , p5_a13 JTF_VARCHAR2_TABLE_200
926: , p5_a14 JTF_VARCHAR2_TABLE_2000
927: , p5_a15 JTF_VARCHAR2_TABLE_100
928: , p5_a16 JTF_VARCHAR2_TABLE_100
929: , p5_a17 JTF_DATE_TABLE
930: , p5_a18 JTF_DATE_TABLE

Line 968: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_200

964: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
965: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
966: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
967: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
968: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_200
969: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_2000
970: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
971: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
972: , p6_a17 out nocopy JTF_DATE_TABLE

Line 969: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_2000

965: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
966: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
967: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
968: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_200
969: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_2000
970: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
971: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
972: , p6_a17 out nocopy JTF_DATE_TABLE
973: , p6_a18 out nocopy JTF_DATE_TABLE

Line 1259: , p5_a13 JTF_VARCHAR2_TABLE_200

1255: , p5_a9 JTF_VARCHAR2_TABLE_100
1256: , p5_a10 JTF_VARCHAR2_TABLE_100
1257: , p5_a11 JTF_VARCHAR2_TABLE_100
1258: , p5_a12 JTF_VARCHAR2_TABLE_100
1259: , p5_a13 JTF_VARCHAR2_TABLE_200
1260: , p5_a14 JTF_VARCHAR2_TABLE_2000
1261: , p5_a15 JTF_VARCHAR2_TABLE_100
1262: , p5_a16 JTF_VARCHAR2_TABLE_100
1263: , p5_a17 JTF_DATE_TABLE

Line 1260: , p5_a14 JTF_VARCHAR2_TABLE_2000

1256: , p5_a10 JTF_VARCHAR2_TABLE_100
1257: , p5_a11 JTF_VARCHAR2_TABLE_100
1258: , p5_a12 JTF_VARCHAR2_TABLE_100
1259: , p5_a13 JTF_VARCHAR2_TABLE_200
1260: , p5_a14 JTF_VARCHAR2_TABLE_2000
1261: , p5_a15 JTF_VARCHAR2_TABLE_100
1262: , p5_a16 JTF_VARCHAR2_TABLE_100
1263: , p5_a17 JTF_DATE_TABLE
1264: , p5_a18 JTF_DATE_TABLE

Line 1592: , p5_a13 JTF_VARCHAR2_TABLE_200

1588: , p5_a9 JTF_VARCHAR2_TABLE_100
1589: , p5_a10 JTF_VARCHAR2_TABLE_100
1590: , p5_a11 JTF_VARCHAR2_TABLE_100
1591: , p5_a12 JTF_VARCHAR2_TABLE_100
1592: , p5_a13 JTF_VARCHAR2_TABLE_200
1593: , p5_a14 JTF_VARCHAR2_TABLE_2000
1594: , p5_a15 JTF_VARCHAR2_TABLE_100
1595: , p5_a16 JTF_VARCHAR2_TABLE_100
1596: , p5_a17 JTF_DATE_TABLE

Line 1593: , p5_a14 JTF_VARCHAR2_TABLE_2000

1589: , p5_a10 JTF_VARCHAR2_TABLE_100
1590: , p5_a11 JTF_VARCHAR2_TABLE_100
1591: , p5_a12 JTF_VARCHAR2_TABLE_100
1592: , p5_a13 JTF_VARCHAR2_TABLE_200
1593: , p5_a14 JTF_VARCHAR2_TABLE_2000
1594: , p5_a15 JTF_VARCHAR2_TABLE_100
1595: , p5_a16 JTF_VARCHAR2_TABLE_100
1596: , p5_a17 JTF_DATE_TABLE
1597: , p5_a18 JTF_DATE_TABLE

Line 1635: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_200

1631: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
1632: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
1633: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
1634: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
1635: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_200
1636: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_2000
1637: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
1638: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
1639: , p6_a17 out nocopy JTF_DATE_TABLE

Line 1636: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_2000

1632: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
1633: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
1634: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
1635: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_200
1636: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_2000
1637: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
1638: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
1639: , p6_a17 out nocopy JTF_DATE_TABLE
1640: , p6_a18 out nocopy JTF_DATE_TABLE

Line 1926: , p5_a13 JTF_VARCHAR2_TABLE_200

1922: , p5_a9 JTF_VARCHAR2_TABLE_100
1923: , p5_a10 JTF_VARCHAR2_TABLE_100
1924: , p5_a11 JTF_VARCHAR2_TABLE_100
1925: , p5_a12 JTF_VARCHAR2_TABLE_100
1926: , p5_a13 JTF_VARCHAR2_TABLE_200
1927: , p5_a14 JTF_VARCHAR2_TABLE_2000
1928: , p5_a15 JTF_VARCHAR2_TABLE_100
1929: , p5_a16 JTF_VARCHAR2_TABLE_100
1930: , p5_a17 JTF_DATE_TABLE

Line 1927: , p5_a14 JTF_VARCHAR2_TABLE_2000

1923: , p5_a10 JTF_VARCHAR2_TABLE_100
1924: , p5_a11 JTF_VARCHAR2_TABLE_100
1925: , p5_a12 JTF_VARCHAR2_TABLE_100
1926: , p5_a13 JTF_VARCHAR2_TABLE_200
1927: , p5_a14 JTF_VARCHAR2_TABLE_2000
1928: , p5_a15 JTF_VARCHAR2_TABLE_100
1929: , p5_a16 JTF_VARCHAR2_TABLE_100
1930: , p5_a17 JTF_DATE_TABLE
1931: , p5_a18 JTF_DATE_TABLE

Line 2169: , p5_a13 JTF_VARCHAR2_TABLE_200

2165: , p5_a9 JTF_VARCHAR2_TABLE_100
2166: , p5_a10 JTF_VARCHAR2_TABLE_100
2167: , p5_a11 JTF_VARCHAR2_TABLE_100
2168: , p5_a12 JTF_VARCHAR2_TABLE_100
2169: , p5_a13 JTF_VARCHAR2_TABLE_200
2170: , p5_a14 JTF_VARCHAR2_TABLE_2000
2171: , p5_a15 JTF_VARCHAR2_TABLE_100
2172: , p5_a16 JTF_VARCHAR2_TABLE_100
2173: , p5_a17 JTF_DATE_TABLE

Line 2170: , p5_a14 JTF_VARCHAR2_TABLE_2000

2166: , p5_a10 JTF_VARCHAR2_TABLE_100
2167: , p5_a11 JTF_VARCHAR2_TABLE_100
2168: , p5_a12 JTF_VARCHAR2_TABLE_100
2169: , p5_a13 JTF_VARCHAR2_TABLE_200
2170: , p5_a14 JTF_VARCHAR2_TABLE_2000
2171: , p5_a15 JTF_VARCHAR2_TABLE_100
2172: , p5_a16 JTF_VARCHAR2_TABLE_100
2173: , p5_a17 JTF_DATE_TABLE
2174: , p5_a18 JTF_DATE_TABLE