DBA Data[Home] [Help]

APPS.OKL_PQY_PVT_W dependencies on JTF_VARCHAR2_TABLE_2000

Line 26: , a4 JTF_VARCHAR2_TABLE_2000

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

Line 67: , a4 out nocopy JTF_VARCHAR2_TABLE_2000

63: procedure rosetta_table_copy_out_p2(t okl_pqy_pvt.pqy_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
64: , a1 out nocopy JTF_VARCHAR2_TABLE_200
65: , a2 out nocopy JTF_VARCHAR2_TABLE_100
66: , a3 out nocopy JTF_NUMBER_TABLE
67: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
68: , a5 out nocopy JTF_DATE_TABLE
69: , a6 out nocopy JTF_DATE_TABLE
70: , a7 out nocopy JTF_NUMBER_TABLE
71: , a8 out nocopy JTF_DATE_TABLE

Line 83: a4 := JTF_VARCHAR2_TABLE_2000();

79: a0 := JTF_NUMBER_TABLE();
80: a1 := JTF_VARCHAR2_TABLE_200();
81: a2 := JTF_VARCHAR2_TABLE_100();
82: a3 := JTF_NUMBER_TABLE();
83: a4 := JTF_VARCHAR2_TABLE_2000();
84: a5 := JTF_DATE_TABLE();
85: a6 := JTF_DATE_TABLE();
86: a7 := JTF_NUMBER_TABLE();
87: a8 := JTF_DATE_TABLE();

Line 96: a4 := JTF_VARCHAR2_TABLE_2000();

92: a0 := JTF_NUMBER_TABLE();
93: a1 := JTF_VARCHAR2_TABLE_200();
94: a2 := JTF_VARCHAR2_TABLE_100();
95: a3 := JTF_NUMBER_TABLE();
96: a4 := JTF_VARCHAR2_TABLE_2000();
97: a5 := JTF_DATE_TABLE();
98: a6 := JTF_DATE_TABLE();
99: a7 := JTF_NUMBER_TABLE();
100: a8 := JTF_DATE_TABLE();

Line 145: , a3 JTF_VARCHAR2_TABLE_2000

141:
142: procedure rosetta_table_copy_in_p5(t out nocopy okl_pqy_pvt.pqyv_tbl_type, a0 JTF_NUMBER_TABLE
143: , a1 JTF_NUMBER_TABLE
144: , a2 JTF_VARCHAR2_TABLE_200
145: , a3 JTF_VARCHAR2_TABLE_2000
146: , a4 JTF_VARCHAR2_TABLE_100
147: , a5 JTF_DATE_TABLE
148: , a6 JTF_DATE_TABLE
149: , a7 JTF_NUMBER_TABLE

Line 186: , a3 out nocopy JTF_VARCHAR2_TABLE_2000

182: end rosetta_table_copy_in_p5;
183: procedure rosetta_table_copy_out_p5(t okl_pqy_pvt.pqyv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
184: , a1 out nocopy JTF_NUMBER_TABLE
185: , a2 out nocopy JTF_VARCHAR2_TABLE_200
186: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
187: , a4 out nocopy JTF_VARCHAR2_TABLE_100
188: , a5 out nocopy JTF_DATE_TABLE
189: , a6 out nocopy JTF_DATE_TABLE
190: , a7 out nocopy JTF_NUMBER_TABLE

Line 202: a3 := JTF_VARCHAR2_TABLE_2000();

198: if t is null or t.count = 0 then
199: a0 := JTF_NUMBER_TABLE();
200: a1 := JTF_NUMBER_TABLE();
201: a2 := JTF_VARCHAR2_TABLE_200();
202: a3 := JTF_VARCHAR2_TABLE_2000();
203: a4 := JTF_VARCHAR2_TABLE_100();
204: a5 := JTF_DATE_TABLE();
205: a6 := JTF_DATE_TABLE();
206: a7 := JTF_NUMBER_TABLE();

Line 215: a3 := JTF_VARCHAR2_TABLE_2000();

211: else
212: a0 := JTF_NUMBER_TABLE();
213: a1 := JTF_NUMBER_TABLE();
214: a2 := JTF_VARCHAR2_TABLE_200();
215: a3 := JTF_VARCHAR2_TABLE_2000();
216: a4 := JTF_VARCHAR2_TABLE_100();
217: a5 := JTF_DATE_TABLE();
218: a6 := JTF_DATE_TABLE();
219: a7 := JTF_NUMBER_TABLE();

Line 357: , p5_a3 JTF_VARCHAR2_TABLE_2000

353: , x_msg_data out nocopy VARCHAR2
354: , p5_a0 JTF_NUMBER_TABLE
355: , p5_a1 JTF_NUMBER_TABLE
356: , p5_a2 JTF_VARCHAR2_TABLE_200
357: , p5_a3 JTF_VARCHAR2_TABLE_2000
358: , p5_a4 JTF_VARCHAR2_TABLE_100
359: , p5_a5 JTF_DATE_TABLE
360: , p5_a6 JTF_DATE_TABLE
361: , p5_a7 JTF_NUMBER_TABLE

Line 369: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000

365: , p5_a11 JTF_NUMBER_TABLE
366: , p6_a0 out nocopy JTF_NUMBER_TABLE
367: , p6_a1 out nocopy JTF_NUMBER_TABLE
368: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
369: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
370: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
371: , p6_a5 out nocopy JTF_DATE_TABLE
372: , p6_a6 out nocopy JTF_DATE_TABLE
373: , p6_a7 out nocopy JTF_NUMBER_TABLE

Line 505: , p5_a3 JTF_VARCHAR2_TABLE_2000

501: , x_msg_data out nocopy VARCHAR2
502: , p5_a0 JTF_NUMBER_TABLE
503: , p5_a1 JTF_NUMBER_TABLE
504: , p5_a2 JTF_VARCHAR2_TABLE_200
505: , p5_a3 JTF_VARCHAR2_TABLE_2000
506: , p5_a4 JTF_VARCHAR2_TABLE_100
507: , p5_a5 JTF_DATE_TABLE
508: , p5_a6 JTF_DATE_TABLE
509: , p5_a7 JTF_NUMBER_TABLE

Line 652: , p5_a3 JTF_VARCHAR2_TABLE_2000

648: , x_msg_data out nocopy VARCHAR2
649: , p5_a0 JTF_NUMBER_TABLE
650: , p5_a1 JTF_NUMBER_TABLE
651: , p5_a2 JTF_VARCHAR2_TABLE_200
652: , p5_a3 JTF_VARCHAR2_TABLE_2000
653: , p5_a4 JTF_VARCHAR2_TABLE_100
654: , p5_a5 JTF_DATE_TABLE
655: , p5_a6 JTF_DATE_TABLE
656: , p5_a7 JTF_NUMBER_TABLE

Line 664: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000

660: , p5_a11 JTF_NUMBER_TABLE
661: , p6_a0 out nocopy JTF_NUMBER_TABLE
662: , p6_a1 out nocopy JTF_NUMBER_TABLE
663: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
664: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
665: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
666: , p6_a5 out nocopy JTF_DATE_TABLE
667: , p6_a6 out nocopy JTF_DATE_TABLE
668: , p6_a7 out nocopy JTF_NUMBER_TABLE

Line 800: , p5_a3 JTF_VARCHAR2_TABLE_2000

796: , x_msg_data out nocopy VARCHAR2
797: , p5_a0 JTF_NUMBER_TABLE
798: , p5_a1 JTF_NUMBER_TABLE
799: , p5_a2 JTF_VARCHAR2_TABLE_200
800: , p5_a3 JTF_VARCHAR2_TABLE_2000
801: , p5_a4 JTF_VARCHAR2_TABLE_100
802: , p5_a5 JTF_DATE_TABLE
803: , p5_a6 JTF_DATE_TABLE
804: , p5_a7 JTF_NUMBER_TABLE

Line 919: , p5_a3 JTF_VARCHAR2_TABLE_2000

915: , x_msg_data out nocopy VARCHAR2
916: , p5_a0 JTF_NUMBER_TABLE
917: , p5_a1 JTF_NUMBER_TABLE
918: , p5_a2 JTF_VARCHAR2_TABLE_200
919: , p5_a3 JTF_VARCHAR2_TABLE_2000
920: , p5_a4 JTF_VARCHAR2_TABLE_100
921: , p5_a5 JTF_DATE_TABLE
922: , p5_a6 JTF_DATE_TABLE
923: , p5_a7 JTF_NUMBER_TABLE