DBA Data[Home] [Help]

APPS.OKL_QUICK_QUOTES_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

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

14: , a4 out nocopy JTF_NUMBER_TABLE
15: , a5 out nocopy JTF_DATE_TABLE
16: );
17:
18: procedure rosetta_table_copy_in_p10(t out nocopy okl_quick_quotes_pvt.fee_service_payments_tbl, a0 JTF_VARCHAR2_TABLE_100
19: , a1 JTF_NUMBER_TABLE
20: , a2 JTF_NUMBER_TABLE
21: , a3 JTF_DATE_TABLE
22: );

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

19: , a1 JTF_NUMBER_TABLE
20: , a2 JTF_NUMBER_TABLE
21: , a3 JTF_DATE_TABLE
22: );
23: procedure rosetta_table_copy_out_p10(t okl_quick_quotes_pvt.fee_service_payments_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100
24: , a1 out nocopy JTF_NUMBER_TABLE
25: , a2 out nocopy JTF_NUMBER_TABLE
26: , a3 out nocopy JTF_DATE_TABLE
27: );

Line 163: , p7_a2 JTF_VARCHAR2_TABLE_100

159: , p6_a52 out nocopy VARCHAR2
160: , p6_a53 out nocopy VARCHAR2
161: , p7_a0 JTF_NUMBER_TABLE
162: , p7_a1 JTF_NUMBER_TABLE
163: , p7_a2 JTF_VARCHAR2_TABLE_100
164: , p7_a3 JTF_VARCHAR2_TABLE_500
165: , p7_a4 JTF_VARCHAR2_TABLE_500
166: , p7_a5 JTF_VARCHAR2_TABLE_500
167: , p7_a6 JTF_VARCHAR2_TABLE_500

Line 180: , p7_a19 JTF_VARCHAR2_TABLE_100

176: , p7_a15 JTF_VARCHAR2_TABLE_500
177: , p7_a16 JTF_VARCHAR2_TABLE_500
178: , p7_a17 JTF_VARCHAR2_TABLE_500
179: , p7_a18 JTF_NUMBER_TABLE
180: , p7_a19 JTF_VARCHAR2_TABLE_100
181: , p7_a20 JTF_VARCHAR2_TABLE_100
182: , p7_a21 JTF_NUMBER_TABLE
183: , p7_a22 JTF_NUMBER_TABLE
184: , p7_a23 JTF_NUMBER_TABLE

Line 181: , p7_a20 JTF_VARCHAR2_TABLE_100

177: , p7_a16 JTF_VARCHAR2_TABLE_500
178: , p7_a17 JTF_VARCHAR2_TABLE_500
179: , p7_a18 JTF_NUMBER_TABLE
180: , p7_a19 JTF_VARCHAR2_TABLE_100
181: , p7_a20 JTF_VARCHAR2_TABLE_100
182: , p7_a21 JTF_NUMBER_TABLE
183: , p7_a22 JTF_NUMBER_TABLE
184: , p7_a23 JTF_NUMBER_TABLE
185: , p7_a24 JTF_NUMBER_TABLE

Line 194: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100

190: , p7_a29 JTF_VARCHAR2_TABLE_2000
191: , p7_a30 JTF_VARCHAR2_TABLE_2000
192: , p8_a0 out nocopy JTF_NUMBER_TABLE
193: , p8_a1 out nocopy JTF_NUMBER_TABLE
194: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100
195: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_500
196: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_500
197: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_500
198: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_500

Line 211: , p8_a19 out nocopy JTF_VARCHAR2_TABLE_100

207: , p8_a15 out nocopy JTF_VARCHAR2_TABLE_500
208: , p8_a16 out nocopy JTF_VARCHAR2_TABLE_500
209: , p8_a17 out nocopy JTF_VARCHAR2_TABLE_500
210: , p8_a18 out nocopy JTF_NUMBER_TABLE
211: , p8_a19 out nocopy JTF_VARCHAR2_TABLE_100
212: , p8_a20 out nocopy JTF_VARCHAR2_TABLE_100
213: , p8_a21 out nocopy JTF_NUMBER_TABLE
214: , p8_a22 out nocopy JTF_NUMBER_TABLE
215: , p8_a23 out nocopy JTF_NUMBER_TABLE

Line 212: , p8_a20 out nocopy JTF_VARCHAR2_TABLE_100

208: , p8_a16 out nocopy JTF_VARCHAR2_TABLE_500
209: , p8_a17 out nocopy JTF_VARCHAR2_TABLE_500
210: , p8_a18 out nocopy JTF_NUMBER_TABLE
211: , p8_a19 out nocopy JTF_VARCHAR2_TABLE_100
212: , p8_a20 out nocopy JTF_VARCHAR2_TABLE_100
213: , p8_a21 out nocopy JTF_NUMBER_TABLE
214: , p8_a22 out nocopy JTF_NUMBER_TABLE
215: , p8_a23 out nocopy JTF_NUMBER_TABLE
216: , p8_a24 out nocopy JTF_NUMBER_TABLE

Line 339: , p7_a2 JTF_VARCHAR2_TABLE_100

335: , p6_a52 out nocopy VARCHAR2
336: , p6_a53 out nocopy VARCHAR2
337: , p7_a0 JTF_NUMBER_TABLE
338: , p7_a1 JTF_NUMBER_TABLE
339: , p7_a2 JTF_VARCHAR2_TABLE_100
340: , p7_a3 JTF_VARCHAR2_TABLE_500
341: , p7_a4 JTF_VARCHAR2_TABLE_500
342: , p7_a5 JTF_VARCHAR2_TABLE_500
343: , p7_a6 JTF_VARCHAR2_TABLE_500

Line 356: , p7_a19 JTF_VARCHAR2_TABLE_100

352: , p7_a15 JTF_VARCHAR2_TABLE_500
353: , p7_a16 JTF_VARCHAR2_TABLE_500
354: , p7_a17 JTF_VARCHAR2_TABLE_500
355: , p7_a18 JTF_NUMBER_TABLE
356: , p7_a19 JTF_VARCHAR2_TABLE_100
357: , p7_a20 JTF_VARCHAR2_TABLE_100
358: , p7_a21 JTF_NUMBER_TABLE
359: , p7_a22 JTF_NUMBER_TABLE
360: , p7_a23 JTF_NUMBER_TABLE

Line 357: , p7_a20 JTF_VARCHAR2_TABLE_100

353: , p7_a16 JTF_VARCHAR2_TABLE_500
354: , p7_a17 JTF_VARCHAR2_TABLE_500
355: , p7_a18 JTF_NUMBER_TABLE
356: , p7_a19 JTF_VARCHAR2_TABLE_100
357: , p7_a20 JTF_VARCHAR2_TABLE_100
358: , p7_a21 JTF_NUMBER_TABLE
359: , p7_a22 JTF_NUMBER_TABLE
360: , p7_a23 JTF_NUMBER_TABLE
361: , p7_a24 JTF_NUMBER_TABLE

Line 370: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100

366: , p7_a29 JTF_VARCHAR2_TABLE_2000
367: , p7_a30 JTF_VARCHAR2_TABLE_2000
368: , p8_a0 out nocopy JTF_NUMBER_TABLE
369: , p8_a1 out nocopy JTF_NUMBER_TABLE
370: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100
371: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_500
372: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_500
373: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_500
374: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_500

Line 387: , p8_a19 out nocopy JTF_VARCHAR2_TABLE_100

383: , p8_a15 out nocopy JTF_VARCHAR2_TABLE_500
384: , p8_a16 out nocopy JTF_VARCHAR2_TABLE_500
385: , p8_a17 out nocopy JTF_VARCHAR2_TABLE_500
386: , p8_a18 out nocopy JTF_NUMBER_TABLE
387: , p8_a19 out nocopy JTF_VARCHAR2_TABLE_100
388: , p8_a20 out nocopy JTF_VARCHAR2_TABLE_100
389: , p8_a21 out nocopy JTF_NUMBER_TABLE
390: , p8_a22 out nocopy JTF_NUMBER_TABLE
391: , p8_a23 out nocopy JTF_NUMBER_TABLE

Line 388: , p8_a20 out nocopy JTF_VARCHAR2_TABLE_100

384: , p8_a16 out nocopy JTF_VARCHAR2_TABLE_500
385: , p8_a17 out nocopy JTF_VARCHAR2_TABLE_500
386: , p8_a18 out nocopy JTF_NUMBER_TABLE
387: , p8_a19 out nocopy JTF_VARCHAR2_TABLE_100
388: , p8_a20 out nocopy JTF_VARCHAR2_TABLE_100
389: , p8_a21 out nocopy JTF_NUMBER_TABLE
390: , p8_a22 out nocopy JTF_NUMBER_TABLE
391: , p8_a23 out nocopy JTF_NUMBER_TABLE
392: , p8_a24 out nocopy JTF_NUMBER_TABLE

Line 444: , p5_a2 JTF_VARCHAR2_TABLE_100

440: , x_msg_count out nocopy NUMBER
441: , x_msg_data out nocopy VARCHAR2
442: , p5_a0 JTF_NUMBER_TABLE
443: , p5_a1 JTF_NUMBER_TABLE
444: , p5_a2 JTF_VARCHAR2_TABLE_100
445: , p5_a3 JTF_VARCHAR2_TABLE_500
446: , p5_a4 JTF_VARCHAR2_TABLE_500
447: , p5_a5 JTF_VARCHAR2_TABLE_500
448: , p5_a6 JTF_VARCHAR2_TABLE_500

Line 461: , p5_a19 JTF_VARCHAR2_TABLE_100

457: , p5_a15 JTF_VARCHAR2_TABLE_500
458: , p5_a16 JTF_VARCHAR2_TABLE_500
459: , p5_a17 JTF_VARCHAR2_TABLE_500
460: , p5_a18 JTF_NUMBER_TABLE
461: , p5_a19 JTF_VARCHAR2_TABLE_100
462: , p5_a20 JTF_VARCHAR2_TABLE_100
463: , p5_a21 JTF_NUMBER_TABLE
464: , p5_a22 JTF_NUMBER_TABLE
465: , p5_a23 JTF_NUMBER_TABLE

Line 462: , p5_a20 JTF_VARCHAR2_TABLE_100

458: , p5_a16 JTF_VARCHAR2_TABLE_500
459: , p5_a17 JTF_VARCHAR2_TABLE_500
460: , p5_a18 JTF_NUMBER_TABLE
461: , p5_a19 JTF_VARCHAR2_TABLE_100
462: , p5_a20 JTF_VARCHAR2_TABLE_100
463: , p5_a21 JTF_NUMBER_TABLE
464: , p5_a22 JTF_NUMBER_TABLE
465: , p5_a23 JTF_NUMBER_TABLE
466: , p5_a24 JTF_NUMBER_TABLE

Line 535: , p6_a2 JTF_VARCHAR2_TABLE_100

531: , p5_a52 VARCHAR2
532: , p5_a53 VARCHAR2
533: , p6_a0 JTF_NUMBER_TABLE
534: , p6_a1 JTF_NUMBER_TABLE
535: , p6_a2 JTF_VARCHAR2_TABLE_100
536: , p6_a3 JTF_VARCHAR2_TABLE_500
537: , p6_a4 JTF_VARCHAR2_TABLE_500
538: , p6_a5 JTF_VARCHAR2_TABLE_500
539: , p6_a6 JTF_VARCHAR2_TABLE_500

Line 552: , p6_a19 JTF_VARCHAR2_TABLE_100

548: , p6_a15 JTF_VARCHAR2_TABLE_500
549: , p6_a16 JTF_VARCHAR2_TABLE_500
550: , p6_a17 JTF_VARCHAR2_TABLE_500
551: , p6_a18 JTF_NUMBER_TABLE
552: , p6_a19 JTF_VARCHAR2_TABLE_100
553: , p6_a20 JTF_VARCHAR2_TABLE_100
554: , p6_a21 JTF_NUMBER_TABLE
555: , p6_a22 JTF_NUMBER_TABLE
556: , p6_a23 JTF_NUMBER_TABLE

Line 553: , p6_a20 JTF_VARCHAR2_TABLE_100

549: , p6_a16 JTF_VARCHAR2_TABLE_500
550: , p6_a17 JTF_VARCHAR2_TABLE_500
551: , p6_a18 JTF_NUMBER_TABLE
552: , p6_a19 JTF_VARCHAR2_TABLE_100
553: , p6_a20 JTF_VARCHAR2_TABLE_100
554: , p6_a21 JTF_NUMBER_TABLE
555: , p6_a22 JTF_NUMBER_TABLE
556: , p6_a23 JTF_NUMBER_TABLE
557: , p6_a24 JTF_NUMBER_TABLE

Line 586: , p8_a8 JTF_VARCHAR2_TABLE_100

582: , p8_a4 JTF_NUMBER_TABLE
583: , p8_a5 JTF_NUMBER_TABLE
584: , p8_a6 JTF_NUMBER_TABLE
585: , p8_a7 JTF_NUMBER_TABLE
586: , p8_a8 JTF_VARCHAR2_TABLE_100
587: , p8_a9 JTF_VARCHAR2_TABLE_100
588: , p_commit VARCHAR2
589: , create_yn VARCHAR2
590: , p11_a0 out nocopy NUMBER

Line 587: , p8_a9 JTF_VARCHAR2_TABLE_100

583: , p8_a5 JTF_NUMBER_TABLE
584: , p8_a6 JTF_NUMBER_TABLE
585: , p8_a7 JTF_NUMBER_TABLE
586: , p8_a8 JTF_VARCHAR2_TABLE_100
587: , p8_a9 JTF_VARCHAR2_TABLE_100
588: , p_commit VARCHAR2
589: , create_yn VARCHAR2
590: , p11_a0 out nocopy NUMBER
591: , p11_a1 out nocopy NUMBER

Line 608: , p13_a0 out nocopy JTF_VARCHAR2_TABLE_100

604: , p12_a2 out nocopy JTF_NUMBER_TABLE
605: , p12_a3 out nocopy JTF_NUMBER_TABLE
606: , p12_a4 out nocopy JTF_NUMBER_TABLE
607: , p12_a5 out nocopy JTF_DATE_TABLE
608: , p13_a0 out nocopy JTF_VARCHAR2_TABLE_100
609: , p13_a1 out nocopy JTF_NUMBER_TABLE
610: , p13_a2 out nocopy JTF_NUMBER_TABLE
611: , p13_a3 out nocopy JTF_DATE_TABLE
612: , p14_a0 out nocopy JTF_VARCHAR2_TABLE_300

Line 676: , p16_a2 out nocopy JTF_VARCHAR2_TABLE_100

672: , p15_a52 out nocopy VARCHAR2
673: , p15_a53 out nocopy VARCHAR2
674: , p16_a0 out nocopy JTF_NUMBER_TABLE
675: , p16_a1 out nocopy JTF_NUMBER_TABLE
676: , p16_a2 out nocopy JTF_VARCHAR2_TABLE_100
677: , p16_a3 out nocopy JTF_VARCHAR2_TABLE_500
678: , p16_a4 out nocopy JTF_VARCHAR2_TABLE_500
679: , p16_a5 out nocopy JTF_VARCHAR2_TABLE_500
680: , p16_a6 out nocopy JTF_VARCHAR2_TABLE_500

Line 693: , p16_a19 out nocopy JTF_VARCHAR2_TABLE_100

689: , p16_a15 out nocopy JTF_VARCHAR2_TABLE_500
690: , p16_a16 out nocopy JTF_VARCHAR2_TABLE_500
691: , p16_a17 out nocopy JTF_VARCHAR2_TABLE_500
692: , p16_a18 out nocopy JTF_NUMBER_TABLE
693: , p16_a19 out nocopy JTF_VARCHAR2_TABLE_100
694: , p16_a20 out nocopy JTF_VARCHAR2_TABLE_100
695: , p16_a21 out nocopy JTF_NUMBER_TABLE
696: , p16_a22 out nocopy JTF_NUMBER_TABLE
697: , p16_a23 out nocopy JTF_NUMBER_TABLE

Line 694: , p16_a20 out nocopy JTF_VARCHAR2_TABLE_100

690: , p16_a16 out nocopy JTF_VARCHAR2_TABLE_500
691: , p16_a17 out nocopy JTF_VARCHAR2_TABLE_500
692: , p16_a18 out nocopy JTF_NUMBER_TABLE
693: , p16_a19 out nocopy JTF_VARCHAR2_TABLE_100
694: , p16_a20 out nocopy JTF_VARCHAR2_TABLE_100
695: , p16_a21 out nocopy JTF_NUMBER_TABLE
696: , p16_a22 out nocopy JTF_NUMBER_TABLE
697: , p16_a23 out nocopy JTF_NUMBER_TABLE
698: , p16_a24 out nocopy JTF_NUMBER_TABLE