DBA Data[Home] [Help]

APPS.AHL_FMP_PVT_W dependencies on JTF_VARCHAR2_TABLE_200

Line 363: , a1 JTF_VARCHAR2_TABLE_200

359: end if;
360: end rosetta_table_copy_out_p5;
361:
362: procedure rosetta_table_copy_in_p7(t out nocopy ahl_fmp_pvt.applicable_programs_tbl_type, a0 JTF_NUMBER_TABLE
363: , a1 JTF_VARCHAR2_TABLE_200
364: , a2 JTF_VARCHAR2_TABLE_200
365: , a3 JTF_VARCHAR2_TABLE_100
366: , a4 JTF_NUMBER_TABLE
367: , a5 JTF_VARCHAR2_TABLE_300

Line 364: , a2 JTF_VARCHAR2_TABLE_200

360: end rosetta_table_copy_out_p5;
361:
362: procedure rosetta_table_copy_in_p7(t out nocopy ahl_fmp_pvt.applicable_programs_tbl_type, a0 JTF_NUMBER_TABLE
363: , a1 JTF_VARCHAR2_TABLE_200
364: , a2 JTF_VARCHAR2_TABLE_200
365: , a3 JTF_VARCHAR2_TABLE_100
366: , a4 JTF_NUMBER_TABLE
367: , a5 JTF_VARCHAR2_TABLE_300
368: , a6 JTF_VARCHAR2_TABLE_300

Line 370: , a8 JTF_VARCHAR2_TABLE_200

366: , a4 JTF_NUMBER_TABLE
367: , a5 JTF_VARCHAR2_TABLE_300
368: , a6 JTF_VARCHAR2_TABLE_300
369: , a7 JTF_NUMBER_TABLE
370: , a8 JTF_VARCHAR2_TABLE_200
371: , a9 JTF_VARCHAR2_TABLE_2000
372: , a10 JTF_VARCHAR2_TABLE_100
373: , a11 JTF_VARCHAR2_TABLE_100
374: , a12 JTF_NUMBER_TABLE

Line 371: , a9 JTF_VARCHAR2_TABLE_2000

367: , a5 JTF_VARCHAR2_TABLE_300
368: , a6 JTF_VARCHAR2_TABLE_300
369: , a7 JTF_NUMBER_TABLE
370: , a8 JTF_VARCHAR2_TABLE_200
371: , a9 JTF_VARCHAR2_TABLE_2000
372: , a10 JTF_VARCHAR2_TABLE_100
373: , a11 JTF_VARCHAR2_TABLE_100
374: , a12 JTF_NUMBER_TABLE
375: , a13 JTF_DATE_TABLE

Line 382: , a20 JTF_VARCHAR2_TABLE_2000

378: , a16 JTF_VARCHAR2_TABLE_100
379: , a17 JTF_DATE_TABLE
380: , a18 JTF_DATE_TABLE
381: , a19 JTF_VARCHAR2_TABLE_100
382: , a20 JTF_VARCHAR2_TABLE_2000
383: , a21 JTF_DATE_TABLE
384: , a22 JTF_VARCHAR2_TABLE_100
385: , a23 JTF_VARCHAR2_TABLE_500
386: , a24 JTF_NUMBER_TABLE

Line 430: , a1 out nocopy JTF_VARCHAR2_TABLE_200

426: end if;
427: end if;
428: end rosetta_table_copy_in_p7;
429: procedure rosetta_table_copy_out_p7(t ahl_fmp_pvt.applicable_programs_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
430: , a1 out nocopy JTF_VARCHAR2_TABLE_200
431: , a2 out nocopy JTF_VARCHAR2_TABLE_200
432: , a3 out nocopy JTF_VARCHAR2_TABLE_100
433: , a4 out nocopy JTF_NUMBER_TABLE
434: , a5 out nocopy JTF_VARCHAR2_TABLE_300

Line 431: , a2 out nocopy JTF_VARCHAR2_TABLE_200

427: end if;
428: end rosetta_table_copy_in_p7;
429: procedure rosetta_table_copy_out_p7(t ahl_fmp_pvt.applicable_programs_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
430: , a1 out nocopy JTF_VARCHAR2_TABLE_200
431: , a2 out nocopy JTF_VARCHAR2_TABLE_200
432: , a3 out nocopy JTF_VARCHAR2_TABLE_100
433: , a4 out nocopy JTF_NUMBER_TABLE
434: , a5 out nocopy JTF_VARCHAR2_TABLE_300
435: , a6 out nocopy JTF_VARCHAR2_TABLE_300

Line 437: , a8 out nocopy JTF_VARCHAR2_TABLE_200

433: , a4 out nocopy JTF_NUMBER_TABLE
434: , a5 out nocopy JTF_VARCHAR2_TABLE_300
435: , a6 out nocopy JTF_VARCHAR2_TABLE_300
436: , a7 out nocopy JTF_NUMBER_TABLE
437: , a8 out nocopy JTF_VARCHAR2_TABLE_200
438: , a9 out nocopy JTF_VARCHAR2_TABLE_2000
439: , a10 out nocopy JTF_VARCHAR2_TABLE_100
440: , a11 out nocopy JTF_VARCHAR2_TABLE_100
441: , a12 out nocopy JTF_NUMBER_TABLE

Line 438: , a9 out nocopy JTF_VARCHAR2_TABLE_2000

434: , a5 out nocopy JTF_VARCHAR2_TABLE_300
435: , a6 out nocopy JTF_VARCHAR2_TABLE_300
436: , a7 out nocopy JTF_NUMBER_TABLE
437: , a8 out nocopy JTF_VARCHAR2_TABLE_200
438: , a9 out nocopy JTF_VARCHAR2_TABLE_2000
439: , a10 out nocopy JTF_VARCHAR2_TABLE_100
440: , a11 out nocopy JTF_VARCHAR2_TABLE_100
441: , a12 out nocopy JTF_NUMBER_TABLE
442: , a13 out nocopy JTF_DATE_TABLE

Line 449: , a20 out nocopy JTF_VARCHAR2_TABLE_2000

445: , a16 out nocopy JTF_VARCHAR2_TABLE_100
446: , a17 out nocopy JTF_DATE_TABLE
447: , a18 out nocopy JTF_DATE_TABLE
448: , a19 out nocopy JTF_VARCHAR2_TABLE_100
449: , a20 out nocopy JTF_VARCHAR2_TABLE_2000
450: , a21 out nocopy JTF_DATE_TABLE
451: , a22 out nocopy JTF_VARCHAR2_TABLE_100
452: , a23 out nocopy JTF_VARCHAR2_TABLE_500
453: , a24 out nocopy JTF_NUMBER_TABLE

Line 459: a1 := JTF_VARCHAR2_TABLE_200();

455: ddindx binary_integer; indx binary_integer;
456: begin
457: if t is null or t.count = 0 then
458: a0 := JTF_NUMBER_TABLE();
459: a1 := JTF_VARCHAR2_TABLE_200();
460: a2 := JTF_VARCHAR2_TABLE_200();
461: a3 := JTF_VARCHAR2_TABLE_100();
462: a4 := JTF_NUMBER_TABLE();
463: a5 := JTF_VARCHAR2_TABLE_300();

Line 460: a2 := JTF_VARCHAR2_TABLE_200();

456: begin
457: if t is null or t.count = 0 then
458: a0 := JTF_NUMBER_TABLE();
459: a1 := JTF_VARCHAR2_TABLE_200();
460: a2 := JTF_VARCHAR2_TABLE_200();
461: a3 := JTF_VARCHAR2_TABLE_100();
462: a4 := JTF_NUMBER_TABLE();
463: a5 := JTF_VARCHAR2_TABLE_300();
464: a6 := JTF_VARCHAR2_TABLE_300();

Line 466: a8 := JTF_VARCHAR2_TABLE_200();

462: a4 := JTF_NUMBER_TABLE();
463: a5 := JTF_VARCHAR2_TABLE_300();
464: a6 := JTF_VARCHAR2_TABLE_300();
465: a7 := JTF_NUMBER_TABLE();
466: a8 := JTF_VARCHAR2_TABLE_200();
467: a9 := JTF_VARCHAR2_TABLE_2000();
468: a10 := JTF_VARCHAR2_TABLE_100();
469: a11 := JTF_VARCHAR2_TABLE_100();
470: a12 := JTF_NUMBER_TABLE();

Line 467: a9 := JTF_VARCHAR2_TABLE_2000();

463: a5 := JTF_VARCHAR2_TABLE_300();
464: a6 := JTF_VARCHAR2_TABLE_300();
465: a7 := JTF_NUMBER_TABLE();
466: a8 := JTF_VARCHAR2_TABLE_200();
467: a9 := JTF_VARCHAR2_TABLE_2000();
468: a10 := JTF_VARCHAR2_TABLE_100();
469: a11 := JTF_VARCHAR2_TABLE_100();
470: a12 := JTF_NUMBER_TABLE();
471: a13 := JTF_DATE_TABLE();

Line 478: a20 := JTF_VARCHAR2_TABLE_2000();

474: a16 := JTF_VARCHAR2_TABLE_100();
475: a17 := JTF_DATE_TABLE();
476: a18 := JTF_DATE_TABLE();
477: a19 := JTF_VARCHAR2_TABLE_100();
478: a20 := JTF_VARCHAR2_TABLE_2000();
479: a21 := JTF_DATE_TABLE();
480: a22 := JTF_VARCHAR2_TABLE_100();
481: a23 := JTF_VARCHAR2_TABLE_500();
482: a24 := JTF_NUMBER_TABLE();

Line 485: a1 := JTF_VARCHAR2_TABLE_200();

481: a23 := JTF_VARCHAR2_TABLE_500();
482: a24 := JTF_NUMBER_TABLE();
483: else
484: a0 := JTF_NUMBER_TABLE();
485: a1 := JTF_VARCHAR2_TABLE_200();
486: a2 := JTF_VARCHAR2_TABLE_200();
487: a3 := JTF_VARCHAR2_TABLE_100();
488: a4 := JTF_NUMBER_TABLE();
489: a5 := JTF_VARCHAR2_TABLE_300();

Line 486: a2 := JTF_VARCHAR2_TABLE_200();

482: a24 := JTF_NUMBER_TABLE();
483: else
484: a0 := JTF_NUMBER_TABLE();
485: a1 := JTF_VARCHAR2_TABLE_200();
486: a2 := JTF_VARCHAR2_TABLE_200();
487: a3 := JTF_VARCHAR2_TABLE_100();
488: a4 := JTF_NUMBER_TABLE();
489: a5 := JTF_VARCHAR2_TABLE_300();
490: a6 := JTF_VARCHAR2_TABLE_300();

Line 492: a8 := JTF_VARCHAR2_TABLE_200();

488: a4 := JTF_NUMBER_TABLE();
489: a5 := JTF_VARCHAR2_TABLE_300();
490: a6 := JTF_VARCHAR2_TABLE_300();
491: a7 := JTF_NUMBER_TABLE();
492: a8 := JTF_VARCHAR2_TABLE_200();
493: a9 := JTF_VARCHAR2_TABLE_2000();
494: a10 := JTF_VARCHAR2_TABLE_100();
495: a11 := JTF_VARCHAR2_TABLE_100();
496: a12 := JTF_NUMBER_TABLE();

Line 493: a9 := JTF_VARCHAR2_TABLE_2000();

489: a5 := JTF_VARCHAR2_TABLE_300();
490: a6 := JTF_VARCHAR2_TABLE_300();
491: a7 := JTF_NUMBER_TABLE();
492: a8 := JTF_VARCHAR2_TABLE_200();
493: a9 := JTF_VARCHAR2_TABLE_2000();
494: a10 := JTF_VARCHAR2_TABLE_100();
495: a11 := JTF_VARCHAR2_TABLE_100();
496: a12 := JTF_NUMBER_TABLE();
497: a13 := JTF_DATE_TABLE();

Line 504: a20 := JTF_VARCHAR2_TABLE_2000();

500: a16 := JTF_VARCHAR2_TABLE_100();
501: a17 := JTF_DATE_TABLE();
502: a18 := JTF_DATE_TABLE();
503: a19 := JTF_VARCHAR2_TABLE_100();
504: a20 := JTF_VARCHAR2_TABLE_2000();
505: a21 := JTF_DATE_TABLE();
506: a22 := JTF_VARCHAR2_TABLE_100();
507: a23 := JTF_VARCHAR2_TABLE_500();
508: a24 := JTF_NUMBER_TABLE();

Line 792: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_200

788: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100
789: , p8_a8 out nocopy JTF_VARCHAR2_TABLE_100
790: , p8_a9 out nocopy JTF_VARCHAR2_TABLE_100
791: , p9_a0 out nocopy JTF_NUMBER_TABLE
792: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_200
793: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_200
794: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100
795: , p9_a4 out nocopy JTF_NUMBER_TABLE
796: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_300

Line 793: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_200

789: , p8_a8 out nocopy JTF_VARCHAR2_TABLE_100
790: , p8_a9 out nocopy JTF_VARCHAR2_TABLE_100
791: , p9_a0 out nocopy JTF_NUMBER_TABLE
792: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_200
793: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_200
794: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100
795: , p9_a4 out nocopy JTF_NUMBER_TABLE
796: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_300
797: , p9_a6 out nocopy JTF_VARCHAR2_TABLE_300

Line 799: , p9_a8 out nocopy JTF_VARCHAR2_TABLE_200

795: , p9_a4 out nocopy JTF_NUMBER_TABLE
796: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_300
797: , p9_a6 out nocopy JTF_VARCHAR2_TABLE_300
798: , p9_a7 out nocopy JTF_NUMBER_TABLE
799: , p9_a8 out nocopy JTF_VARCHAR2_TABLE_200
800: , p9_a9 out nocopy JTF_VARCHAR2_TABLE_2000
801: , p9_a10 out nocopy JTF_VARCHAR2_TABLE_100
802: , p9_a11 out nocopy JTF_VARCHAR2_TABLE_100
803: , p9_a12 out nocopy JTF_NUMBER_TABLE

Line 800: , p9_a9 out nocopy JTF_VARCHAR2_TABLE_2000

796: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_300
797: , p9_a6 out nocopy JTF_VARCHAR2_TABLE_300
798: , p9_a7 out nocopy JTF_NUMBER_TABLE
799: , p9_a8 out nocopy JTF_VARCHAR2_TABLE_200
800: , p9_a9 out nocopy JTF_VARCHAR2_TABLE_2000
801: , p9_a10 out nocopy JTF_VARCHAR2_TABLE_100
802: , p9_a11 out nocopy JTF_VARCHAR2_TABLE_100
803: , p9_a12 out nocopy JTF_NUMBER_TABLE
804: , p9_a13 out nocopy JTF_DATE_TABLE

Line 811: , p9_a20 out nocopy JTF_VARCHAR2_TABLE_2000

807: , p9_a16 out nocopy JTF_VARCHAR2_TABLE_100
808: , p9_a17 out nocopy JTF_DATE_TABLE
809: , p9_a18 out nocopy JTF_DATE_TABLE
810: , p9_a19 out nocopy JTF_VARCHAR2_TABLE_100
811: , p9_a20 out nocopy JTF_VARCHAR2_TABLE_2000
812: , p9_a21 out nocopy JTF_DATE_TABLE
813: , p9_a22 out nocopy JTF_VARCHAR2_TABLE_100
814: , p9_a23 out nocopy JTF_VARCHAR2_TABLE_500
815: , p9_a24 out nocopy JTF_NUMBER_TABLE