DBA Data[Home] [Help]

APPS.OKL_QUICK_QUOTES_PVT_W dependencies on JTF_VARCHAR2_TABLE_300

Line 145: procedure rosetta_table_copy_in_p12(t out nocopy okl_quick_quotes_pvt.item_order_estimate_tbl, a0 JTF_VARCHAR2_TABLE_300

141: end if;
142: end if;
143: end rosetta_table_copy_out_p10;
144:
145: procedure rosetta_table_copy_in_p12(t out nocopy okl_quick_quotes_pvt.item_order_estimate_tbl, a0 JTF_VARCHAR2_TABLE_300
146: , a1 JTF_VARCHAR2_TABLE_300
147: , a2 JTF_NUMBER_TABLE
148: , a3 JTF_NUMBER_TABLE
149: , a4 JTF_NUMBER_TABLE

Line 146: , a1 JTF_VARCHAR2_TABLE_300

142: end if;
143: end rosetta_table_copy_out_p10;
144:
145: procedure rosetta_table_copy_in_p12(t out nocopy okl_quick_quotes_pvt.item_order_estimate_tbl, a0 JTF_VARCHAR2_TABLE_300
146: , a1 JTF_VARCHAR2_TABLE_300
147: , a2 JTF_NUMBER_TABLE
148: , a3 JTF_NUMBER_TABLE
149: , a4 JTF_NUMBER_TABLE
150: , a5 JTF_NUMBER_TABLE

Line 178: procedure rosetta_table_copy_out_p12(t okl_quick_quotes_pvt.item_order_estimate_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_300

174: end loop;
175: end if;
176: end if;
177: end rosetta_table_copy_in_p12;
178: procedure rosetta_table_copy_out_p12(t okl_quick_quotes_pvt.item_order_estimate_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_300
179: , a1 out nocopy JTF_VARCHAR2_TABLE_300
180: , a2 out nocopy JTF_NUMBER_TABLE
181: , a3 out nocopy JTF_NUMBER_TABLE
182: , a4 out nocopy JTF_NUMBER_TABLE

Line 179: , a1 out nocopy JTF_VARCHAR2_TABLE_300

175: end if;
176: end if;
177: end rosetta_table_copy_in_p12;
178: procedure rosetta_table_copy_out_p12(t okl_quick_quotes_pvt.item_order_estimate_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_300
179: , a1 out nocopy JTF_VARCHAR2_TABLE_300
180: , a2 out nocopy JTF_NUMBER_TABLE
181: , a3 out nocopy JTF_NUMBER_TABLE
182: , a4 out nocopy JTF_NUMBER_TABLE
183: , a5 out nocopy JTF_NUMBER_TABLE

Line 190: a0 := JTF_VARCHAR2_TABLE_300();

186: ) as
187: ddindx binary_integer; indx binary_integer;
188: begin
189: if t is null or t.count = 0 then
190: a0 := JTF_VARCHAR2_TABLE_300();
191: a1 := JTF_VARCHAR2_TABLE_300();
192: a2 := JTF_NUMBER_TABLE();
193: a3 := JTF_NUMBER_TABLE();
194: a4 := JTF_NUMBER_TABLE();

Line 191: a1 := JTF_VARCHAR2_TABLE_300();

187: ddindx binary_integer; indx binary_integer;
188: begin
189: if t is null or t.count = 0 then
190: a0 := JTF_VARCHAR2_TABLE_300();
191: a1 := JTF_VARCHAR2_TABLE_300();
192: a2 := JTF_NUMBER_TABLE();
193: a3 := JTF_NUMBER_TABLE();
194: a4 := JTF_NUMBER_TABLE();
195: a5 := JTF_NUMBER_TABLE();

Line 199: a0 := JTF_VARCHAR2_TABLE_300();

195: a5 := JTF_NUMBER_TABLE();
196: a6 := JTF_NUMBER_TABLE();
197: a7 := JTF_DATE_TABLE();
198: else
199: a0 := JTF_VARCHAR2_TABLE_300();
200: a1 := JTF_VARCHAR2_TABLE_300();
201: a2 := JTF_NUMBER_TABLE();
202: a3 := JTF_NUMBER_TABLE();
203: a4 := JTF_NUMBER_TABLE();

Line 200: a1 := JTF_VARCHAR2_TABLE_300();

196: a6 := JTF_NUMBER_TABLE();
197: a7 := JTF_DATE_TABLE();
198: else
199: a0 := JTF_VARCHAR2_TABLE_300();
200: a1 := JTF_VARCHAR2_TABLE_300();
201: a2 := JTF_NUMBER_TABLE();
202: a3 := JTF_NUMBER_TABLE();
203: a4 := JTF_NUMBER_TABLE();
204: a5 := JTF_NUMBER_TABLE();

Line 378: , p7_a28 JTF_VARCHAR2_TABLE_300

374: , p7_a24 JTF_NUMBER_TABLE
375: , p7_a25 JTF_NUMBER_TABLE
376: , p7_a26 JTF_NUMBER_TABLE
377: , p7_a27 JTF_NUMBER_TABLE
378: , p7_a28 JTF_VARCHAR2_TABLE_300
379: , p7_a29 JTF_VARCHAR2_TABLE_2000
380: , p7_a30 JTF_VARCHAR2_TABLE_2000
381: , p8_a0 out nocopy JTF_NUMBER_TABLE
382: , p8_a1 out nocopy JTF_NUMBER_TABLE

Line 409: , p8_a28 out nocopy JTF_VARCHAR2_TABLE_300

405: , p8_a24 out nocopy JTF_NUMBER_TABLE
406: , p8_a25 out nocopy JTF_NUMBER_TABLE
407: , p8_a26 out nocopy JTF_NUMBER_TABLE
408: , p8_a27 out nocopy JTF_NUMBER_TABLE
409: , p8_a28 out nocopy JTF_VARCHAR2_TABLE_300
410: , p8_a29 out nocopy JTF_VARCHAR2_TABLE_2000
411: , p8_a30 out nocopy JTF_VARCHAR2_TABLE_2000
412: )
413:

Line 767: , p7_a28 JTF_VARCHAR2_TABLE_300

763: , p7_a24 JTF_NUMBER_TABLE
764: , p7_a25 JTF_NUMBER_TABLE
765: , p7_a26 JTF_NUMBER_TABLE
766: , p7_a27 JTF_NUMBER_TABLE
767: , p7_a28 JTF_VARCHAR2_TABLE_300
768: , p7_a29 JTF_VARCHAR2_TABLE_2000
769: , p7_a30 JTF_VARCHAR2_TABLE_2000
770: , p8_a0 out nocopy JTF_NUMBER_TABLE
771: , p8_a1 out nocopy JTF_NUMBER_TABLE

Line 798: , p8_a28 out nocopy JTF_VARCHAR2_TABLE_300

794: , p8_a24 out nocopy JTF_NUMBER_TABLE
795: , p8_a25 out nocopy JTF_NUMBER_TABLE
796: , p8_a26 out nocopy JTF_NUMBER_TABLE
797: , p8_a27 out nocopy JTF_NUMBER_TABLE
798: , p8_a28 out nocopy JTF_VARCHAR2_TABLE_300
799: , p8_a29 out nocopy JTF_VARCHAR2_TABLE_2000
800: , p8_a30 out nocopy JTF_VARCHAR2_TABLE_2000
801: )
802:

Line 1145: , p5_a28 JTF_VARCHAR2_TABLE_300

1141: , p5_a24 JTF_NUMBER_TABLE
1142: , p5_a25 JTF_NUMBER_TABLE
1143: , p5_a26 JTF_NUMBER_TABLE
1144: , p5_a27 JTF_NUMBER_TABLE
1145: , p5_a28 JTF_VARCHAR2_TABLE_300
1146: , p5_a29 JTF_VARCHAR2_TABLE_2000
1147: , p5_a30 JTF_VARCHAR2_TABLE_2000
1148: )
1149:

Line 1297: , p6_a28 JTF_VARCHAR2_TABLE_300

1293: , p6_a24 JTF_NUMBER_TABLE
1294: , p6_a25 JTF_NUMBER_TABLE
1295: , p6_a26 JTF_NUMBER_TABLE
1296: , p6_a27 JTF_NUMBER_TABLE
1297: , p6_a28 JTF_VARCHAR2_TABLE_300
1298: , p6_a29 JTF_VARCHAR2_TABLE_2000
1299: , p6_a30 JTF_VARCHAR2_TABLE_2000
1300: , p7_a0 VARCHAR2
1301: , p7_a1 NUMBER

Line 1348: , p14_a0 out nocopy JTF_VARCHAR2_TABLE_300

1344: , p13_a0 out nocopy JTF_VARCHAR2_TABLE_100
1345: , p13_a1 out nocopy JTF_NUMBER_TABLE
1346: , p13_a2 out nocopy JTF_NUMBER_TABLE
1347: , p13_a3 out nocopy JTF_DATE_TABLE
1348: , p14_a0 out nocopy JTF_VARCHAR2_TABLE_300
1349: , p14_a1 out nocopy JTF_VARCHAR2_TABLE_300
1350: , p14_a2 out nocopy JTF_NUMBER_TABLE
1351: , p14_a3 out nocopy JTF_NUMBER_TABLE
1352: , p14_a4 out nocopy JTF_NUMBER_TABLE

Line 1349: , p14_a1 out nocopy JTF_VARCHAR2_TABLE_300

1345: , p13_a1 out nocopy JTF_NUMBER_TABLE
1346: , p13_a2 out nocopy JTF_NUMBER_TABLE
1347: , p13_a3 out nocopy JTF_DATE_TABLE
1348: , p14_a0 out nocopy JTF_VARCHAR2_TABLE_300
1349: , p14_a1 out nocopy JTF_VARCHAR2_TABLE_300
1350: , p14_a2 out nocopy JTF_NUMBER_TABLE
1351: , p14_a3 out nocopy JTF_NUMBER_TABLE
1352: , p14_a4 out nocopy JTF_NUMBER_TABLE
1353: , p14_a5 out nocopy JTF_NUMBER_TABLE

Line 1438: , p16_a28 out nocopy JTF_VARCHAR2_TABLE_300

1434: , p16_a24 out nocopy JTF_NUMBER_TABLE
1435: , p16_a25 out nocopy JTF_NUMBER_TABLE
1436: , p16_a26 out nocopy JTF_NUMBER_TABLE
1437: , p16_a27 out nocopy JTF_NUMBER_TABLE
1438: , p16_a28 out nocopy JTF_VARCHAR2_TABLE_300
1439: , p16_a29 out nocopy JTF_VARCHAR2_TABLE_2000
1440: , p16_a30 out nocopy JTF_VARCHAR2_TABLE_2000
1441: )
1442: