APPS.OKL_QUICK_QUOTES_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 81: procedure rosetta_table_copy_in_p10(t out nocopy okl_quick_quotes_pvt.fee_service_payments_tbl, a0 JTF_VARCHAR2_TABLE_100

77: end if;
78: end if;
79: end rosetta_table_copy_out_p8;
80:
81: procedure rosetta_table_copy_in_p10(t out nocopy okl_quick_quotes_pvt.fee_service_payments_tbl, a0 JTF_VARCHAR2_TABLE_100
82: , a1 JTF_NUMBER_TABLE
83: , a2 JTF_NUMBER_TABLE
84: , a3 JTF_DATE_TABLE
85: ) as

Line 106: procedure rosetta_table_copy_out_p10(t okl_quick_quotes_pvt.fee_service_payments_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100

102: end loop;
103: end if;
104: end if;
105: end rosetta_table_copy_in_p10;
106: procedure rosetta_table_copy_out_p10(t okl_quick_quotes_pvt.fee_service_payments_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100
107: , a1 out nocopy JTF_NUMBER_TABLE
108: , a2 out nocopy JTF_NUMBER_TABLE
109: , a3 out nocopy JTF_DATE_TABLE
110: ) as

Line 114: a0 := JTF_VARCHAR2_TABLE_100();

110: ) as
111: ddindx binary_integer; indx binary_integer;
112: begin
113: if t is null or t.count = 0 then
114: a0 := JTF_VARCHAR2_TABLE_100();
115: a1 := JTF_NUMBER_TABLE();
116: a2 := JTF_NUMBER_TABLE();
117: a3 := JTF_DATE_TABLE();
118: else

Line 119: a0 := JTF_VARCHAR2_TABLE_100();

115: a1 := JTF_NUMBER_TABLE();
116: a2 := JTF_NUMBER_TABLE();
117: a3 := JTF_DATE_TABLE();
118: else
119: a0 := JTF_VARCHAR2_TABLE_100();
120: a1 := JTF_NUMBER_TABLE();
121: a2 := JTF_NUMBER_TABLE();
122: a3 := JTF_DATE_TABLE();
123: if t.count > 0 then

Line 352: , p7_a2 JTF_VARCHAR2_TABLE_100

348: , p6_a52 out nocopy VARCHAR2
349: , p6_a53 out nocopy VARCHAR2
350: , p7_a0 JTF_NUMBER_TABLE
351: , p7_a1 JTF_NUMBER_TABLE
352: , p7_a2 JTF_VARCHAR2_TABLE_100
353: , p7_a3 JTF_VARCHAR2_TABLE_500
354: , p7_a4 JTF_VARCHAR2_TABLE_500
355: , p7_a5 JTF_VARCHAR2_TABLE_500
356: , p7_a6 JTF_VARCHAR2_TABLE_500

Line 369: , p7_a19 JTF_VARCHAR2_TABLE_100

365: , p7_a15 JTF_VARCHAR2_TABLE_500
366: , p7_a16 JTF_VARCHAR2_TABLE_500
367: , p7_a17 JTF_VARCHAR2_TABLE_500
368: , p7_a18 JTF_NUMBER_TABLE
369: , p7_a19 JTF_VARCHAR2_TABLE_100
370: , p7_a20 JTF_VARCHAR2_TABLE_100
371: , p7_a21 JTF_NUMBER_TABLE
372: , p7_a22 JTF_NUMBER_TABLE
373: , p7_a23 JTF_NUMBER_TABLE

Line 370: , p7_a20 JTF_VARCHAR2_TABLE_100

366: , p7_a16 JTF_VARCHAR2_TABLE_500
367: , p7_a17 JTF_VARCHAR2_TABLE_500
368: , p7_a18 JTF_NUMBER_TABLE
369: , p7_a19 JTF_VARCHAR2_TABLE_100
370: , p7_a20 JTF_VARCHAR2_TABLE_100
371: , p7_a21 JTF_NUMBER_TABLE
372: , p7_a22 JTF_NUMBER_TABLE
373: , p7_a23 JTF_NUMBER_TABLE
374: , p7_a24 JTF_NUMBER_TABLE

Line 383: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100

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
383: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100
384: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_500
385: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_500
386: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_500
387: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_500

Line 400: , p8_a19 out nocopy JTF_VARCHAR2_TABLE_100

396: , p8_a15 out nocopy JTF_VARCHAR2_TABLE_500
397: , p8_a16 out nocopy JTF_VARCHAR2_TABLE_500
398: , p8_a17 out nocopy JTF_VARCHAR2_TABLE_500
399: , p8_a18 out nocopy JTF_NUMBER_TABLE
400: , p8_a19 out nocopy JTF_VARCHAR2_TABLE_100
401: , p8_a20 out nocopy JTF_VARCHAR2_TABLE_100
402: , p8_a21 out nocopy JTF_NUMBER_TABLE
403: , p8_a22 out nocopy JTF_NUMBER_TABLE
404: , p8_a23 out nocopy JTF_NUMBER_TABLE

Line 401: , p8_a20 out nocopy JTF_VARCHAR2_TABLE_100

397: , p8_a16 out nocopy JTF_VARCHAR2_TABLE_500
398: , p8_a17 out nocopy JTF_VARCHAR2_TABLE_500
399: , p8_a18 out nocopy JTF_NUMBER_TABLE
400: , p8_a19 out nocopy JTF_VARCHAR2_TABLE_100
401: , p8_a20 out nocopy JTF_VARCHAR2_TABLE_100
402: , p8_a21 out nocopy JTF_NUMBER_TABLE
403: , p8_a22 out nocopy JTF_NUMBER_TABLE
404: , p8_a23 out nocopy JTF_NUMBER_TABLE
405: , p8_a24 out nocopy JTF_NUMBER_TABLE

Line 741: , p7_a2 JTF_VARCHAR2_TABLE_100

737: , p6_a52 out nocopy VARCHAR2
738: , p6_a53 out nocopy VARCHAR2
739: , p7_a0 JTF_NUMBER_TABLE
740: , p7_a1 JTF_NUMBER_TABLE
741: , p7_a2 JTF_VARCHAR2_TABLE_100
742: , p7_a3 JTF_VARCHAR2_TABLE_500
743: , p7_a4 JTF_VARCHAR2_TABLE_500
744: , p7_a5 JTF_VARCHAR2_TABLE_500
745: , p7_a6 JTF_VARCHAR2_TABLE_500

Line 758: , p7_a19 JTF_VARCHAR2_TABLE_100

754: , p7_a15 JTF_VARCHAR2_TABLE_500
755: , p7_a16 JTF_VARCHAR2_TABLE_500
756: , p7_a17 JTF_VARCHAR2_TABLE_500
757: , p7_a18 JTF_NUMBER_TABLE
758: , p7_a19 JTF_VARCHAR2_TABLE_100
759: , p7_a20 JTF_VARCHAR2_TABLE_100
760: , p7_a21 JTF_NUMBER_TABLE
761: , p7_a22 JTF_NUMBER_TABLE
762: , p7_a23 JTF_NUMBER_TABLE

Line 759: , p7_a20 JTF_VARCHAR2_TABLE_100

755: , p7_a16 JTF_VARCHAR2_TABLE_500
756: , p7_a17 JTF_VARCHAR2_TABLE_500
757: , p7_a18 JTF_NUMBER_TABLE
758: , p7_a19 JTF_VARCHAR2_TABLE_100
759: , p7_a20 JTF_VARCHAR2_TABLE_100
760: , p7_a21 JTF_NUMBER_TABLE
761: , p7_a22 JTF_NUMBER_TABLE
762: , p7_a23 JTF_NUMBER_TABLE
763: , p7_a24 JTF_NUMBER_TABLE

Line 772: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100

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
772: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100
773: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_500
774: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_500
775: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_500
776: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_500

Line 789: , p8_a19 out nocopy JTF_VARCHAR2_TABLE_100

785: , p8_a15 out nocopy JTF_VARCHAR2_TABLE_500
786: , p8_a16 out nocopy JTF_VARCHAR2_TABLE_500
787: , p8_a17 out nocopy JTF_VARCHAR2_TABLE_500
788: , p8_a18 out nocopy JTF_NUMBER_TABLE
789: , p8_a19 out nocopy JTF_VARCHAR2_TABLE_100
790: , p8_a20 out nocopy JTF_VARCHAR2_TABLE_100
791: , p8_a21 out nocopy JTF_NUMBER_TABLE
792: , p8_a22 out nocopy JTF_NUMBER_TABLE
793: , p8_a23 out nocopy JTF_NUMBER_TABLE

Line 790: , p8_a20 out nocopy JTF_VARCHAR2_TABLE_100

786: , p8_a16 out nocopy JTF_VARCHAR2_TABLE_500
787: , p8_a17 out nocopy JTF_VARCHAR2_TABLE_500
788: , p8_a18 out nocopy JTF_NUMBER_TABLE
789: , p8_a19 out nocopy JTF_VARCHAR2_TABLE_100
790: , p8_a20 out nocopy JTF_VARCHAR2_TABLE_100
791: , p8_a21 out nocopy JTF_NUMBER_TABLE
792: , p8_a22 out nocopy JTF_NUMBER_TABLE
793: , p8_a23 out nocopy JTF_NUMBER_TABLE
794: , p8_a24 out nocopy JTF_NUMBER_TABLE

Line 1119: , p5_a2 JTF_VARCHAR2_TABLE_100

1115: , x_msg_count out nocopy NUMBER
1116: , x_msg_data out nocopy VARCHAR2
1117: , p5_a0 JTF_NUMBER_TABLE
1118: , p5_a1 JTF_NUMBER_TABLE
1119: , p5_a2 JTF_VARCHAR2_TABLE_100
1120: , p5_a3 JTF_VARCHAR2_TABLE_500
1121: , p5_a4 JTF_VARCHAR2_TABLE_500
1122: , p5_a5 JTF_VARCHAR2_TABLE_500
1123: , p5_a6 JTF_VARCHAR2_TABLE_500

Line 1136: , p5_a19 JTF_VARCHAR2_TABLE_100

1132: , p5_a15 JTF_VARCHAR2_TABLE_500
1133: , p5_a16 JTF_VARCHAR2_TABLE_500
1134: , p5_a17 JTF_VARCHAR2_TABLE_500
1135: , p5_a18 JTF_NUMBER_TABLE
1136: , p5_a19 JTF_VARCHAR2_TABLE_100
1137: , p5_a20 JTF_VARCHAR2_TABLE_100
1138: , p5_a21 JTF_NUMBER_TABLE
1139: , p5_a22 JTF_NUMBER_TABLE
1140: , p5_a23 JTF_NUMBER_TABLE

Line 1137: , p5_a20 JTF_VARCHAR2_TABLE_100

1133: , p5_a16 JTF_VARCHAR2_TABLE_500
1134: , p5_a17 JTF_VARCHAR2_TABLE_500
1135: , p5_a18 JTF_NUMBER_TABLE
1136: , p5_a19 JTF_VARCHAR2_TABLE_100
1137: , p5_a20 JTF_VARCHAR2_TABLE_100
1138: , p5_a21 JTF_NUMBER_TABLE
1139: , p5_a22 JTF_NUMBER_TABLE
1140: , p5_a23 JTF_NUMBER_TABLE
1141: , p5_a24 JTF_NUMBER_TABLE

Line 1271: , p6_a2 JTF_VARCHAR2_TABLE_100

1267: , p5_a52 VARCHAR2
1268: , p5_a53 VARCHAR2
1269: , p6_a0 JTF_NUMBER_TABLE
1270: , p6_a1 JTF_NUMBER_TABLE
1271: , p6_a2 JTF_VARCHAR2_TABLE_100
1272: , p6_a3 JTF_VARCHAR2_TABLE_500
1273: , p6_a4 JTF_VARCHAR2_TABLE_500
1274: , p6_a5 JTF_VARCHAR2_TABLE_500
1275: , p6_a6 JTF_VARCHAR2_TABLE_500

Line 1288: , p6_a19 JTF_VARCHAR2_TABLE_100

1284: , p6_a15 JTF_VARCHAR2_TABLE_500
1285: , p6_a16 JTF_VARCHAR2_TABLE_500
1286: , p6_a17 JTF_VARCHAR2_TABLE_500
1287: , p6_a18 JTF_NUMBER_TABLE
1288: , p6_a19 JTF_VARCHAR2_TABLE_100
1289: , p6_a20 JTF_VARCHAR2_TABLE_100
1290: , p6_a21 JTF_NUMBER_TABLE
1291: , p6_a22 JTF_NUMBER_TABLE
1292: , p6_a23 JTF_NUMBER_TABLE

Line 1289: , p6_a20 JTF_VARCHAR2_TABLE_100

1285: , p6_a16 JTF_VARCHAR2_TABLE_500
1286: , p6_a17 JTF_VARCHAR2_TABLE_500
1287: , p6_a18 JTF_NUMBER_TABLE
1288: , p6_a19 JTF_VARCHAR2_TABLE_100
1289: , p6_a20 JTF_VARCHAR2_TABLE_100
1290: , p6_a21 JTF_NUMBER_TABLE
1291: , p6_a22 JTF_NUMBER_TABLE
1292: , p6_a23 JTF_NUMBER_TABLE
1293: , p6_a24 JTF_NUMBER_TABLE

Line 1322: , p8_a8 JTF_VARCHAR2_TABLE_100

1318: , p8_a4 JTF_NUMBER_TABLE
1319: , p8_a5 JTF_NUMBER_TABLE
1320: , p8_a6 JTF_NUMBER_TABLE
1321: , p8_a7 JTF_NUMBER_TABLE
1322: , p8_a8 JTF_VARCHAR2_TABLE_100
1323: , p8_a9 JTF_VARCHAR2_TABLE_100
1324: , p_commit VARCHAR2
1325: , create_yn VARCHAR2
1326: , p11_a0 out nocopy NUMBER

Line 1323: , p8_a9 JTF_VARCHAR2_TABLE_100

1319: , p8_a5 JTF_NUMBER_TABLE
1320: , p8_a6 JTF_NUMBER_TABLE
1321: , p8_a7 JTF_NUMBER_TABLE
1322: , p8_a8 JTF_VARCHAR2_TABLE_100
1323: , p8_a9 JTF_VARCHAR2_TABLE_100
1324: , p_commit VARCHAR2
1325: , create_yn VARCHAR2
1326: , p11_a0 out nocopy NUMBER
1327: , p11_a1 out nocopy NUMBER

Line 1344: , p13_a0 out nocopy JTF_VARCHAR2_TABLE_100

1340: , p12_a2 out nocopy JTF_NUMBER_TABLE
1341: , p12_a3 out nocopy JTF_NUMBER_TABLE
1342: , p12_a4 out nocopy JTF_NUMBER_TABLE
1343: , p12_a5 out nocopy JTF_DATE_TABLE
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

Line 1412: , p16_a2 out nocopy JTF_VARCHAR2_TABLE_100

1408: , p15_a52 out nocopy VARCHAR2
1409: , p15_a53 out nocopy VARCHAR2
1410: , p16_a0 out nocopy JTF_NUMBER_TABLE
1411: , p16_a1 out nocopy JTF_NUMBER_TABLE
1412: , p16_a2 out nocopy JTF_VARCHAR2_TABLE_100
1413: , p16_a3 out nocopy JTF_VARCHAR2_TABLE_500
1414: , p16_a4 out nocopy JTF_VARCHAR2_TABLE_500
1415: , p16_a5 out nocopy JTF_VARCHAR2_TABLE_500
1416: , p16_a6 out nocopy JTF_VARCHAR2_TABLE_500

Line 1429: , p16_a19 out nocopy JTF_VARCHAR2_TABLE_100

1425: , p16_a15 out nocopy JTF_VARCHAR2_TABLE_500
1426: , p16_a16 out nocopy JTF_VARCHAR2_TABLE_500
1427: , p16_a17 out nocopy JTF_VARCHAR2_TABLE_500
1428: , p16_a18 out nocopy JTF_NUMBER_TABLE
1429: , p16_a19 out nocopy JTF_VARCHAR2_TABLE_100
1430: , p16_a20 out nocopy JTF_VARCHAR2_TABLE_100
1431: , p16_a21 out nocopy JTF_NUMBER_TABLE
1432: , p16_a22 out nocopy JTF_NUMBER_TABLE
1433: , p16_a23 out nocopy JTF_NUMBER_TABLE

Line 1430: , p16_a20 out nocopy JTF_VARCHAR2_TABLE_100

1426: , p16_a16 out nocopy JTF_VARCHAR2_TABLE_500
1427: , p16_a17 out nocopy JTF_VARCHAR2_TABLE_500
1428: , p16_a18 out nocopy JTF_NUMBER_TABLE
1429: , p16_a19 out nocopy JTF_VARCHAR2_TABLE_100
1430: , p16_a20 out nocopy JTF_VARCHAR2_TABLE_100
1431: , p16_a21 out nocopy JTF_NUMBER_TABLE
1432: , p16_a22 out nocopy JTF_NUMBER_TABLE
1433: , p16_a23 out nocopy JTF_NUMBER_TABLE
1434: , p16_a24 out nocopy JTF_NUMBER_TABLE