eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_GTP_PVT_W dependencies on OKL_GTP_PVT

Line 1: package body okl_gtp_pvt_w as

1: package body okl_gtp_pvt_w as
2: /* $Header: OKLIGTPB.pls 120.1 2005/10/30 04:00:46 appldev noship $ */
3: rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
4: rosetta_g_miss_date date := to_date('01/01/-4712', 'MM/DD/SYYYY');
5:

Line 22: procedure rosetta_table_copy_in_p2(t out nocopy okl_gtp_pvt.gtp_tbl_type, a0 JTF_NUMBER_TABLE

18: if n=b then return a; end if;
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_gtp_pvt.gtp_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_200
25: , a3 JTF_VARCHAR2_TABLE_2000
26: , a4 JTF_VARCHAR2_TABLE_100

Line 69: procedure rosetta_table_copy_out_p2(t okl_gtp_pvt.gtp_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

65: end loop;
66: end if;
67: end if;
68: end rosetta_table_copy_in_p2;
69: procedure rosetta_table_copy_out_p2(t okl_gtp_pvt.gtp_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
70: , a1 out nocopy JTF_NUMBER_TABLE
71: , a2 out nocopy JTF_VARCHAR2_TABLE_200
72: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
73: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 163: procedure rosetta_table_copy_in_p5(t out nocopy okl_gtp_pvt.gtpv_tbl_type, a0 JTF_NUMBER_TABLE

159: end if;
160: end if;
161: end rosetta_table_copy_out_p2;
162:
163: procedure rosetta_table_copy_in_p5(t out nocopy okl_gtp_pvt.gtpv_tbl_type, a0 JTF_NUMBER_TABLE
164: , a1 JTF_NUMBER_TABLE
165: , a2 JTF_VARCHAR2_TABLE_200
166: , a3 JTF_VARCHAR2_TABLE_2000
167: , a4 JTF_VARCHAR2_TABLE_100

Line 210: procedure rosetta_table_copy_out_p5(t okl_gtp_pvt.gtpv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

206: end loop;
207: end if;
208: end if;
209: end rosetta_table_copy_in_p5;
210: procedure rosetta_table_copy_out_p5(t okl_gtp_pvt.gtpv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
211: , a1 out nocopy JTF_NUMBER_TABLE
212: , a2 out nocopy JTF_VARCHAR2_TABLE_200
213: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
214: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 342: ddp_gtpv_rec okl_gtp_pvt.gtpv_rec_type;

338: , p5_a14 NUMBER := 0-1962.0724
339: )
340:
341: as
342: ddp_gtpv_rec okl_gtp_pvt.gtpv_rec_type;
343: ddx_gtpv_rec okl_gtp_pvt.gtpv_rec_type;
344: ddindx binary_integer; indx binary_integer;
345: begin
346:

Line 343: ddx_gtpv_rec okl_gtp_pvt.gtpv_rec_type;

339: )
340:
341: as
342: ddp_gtpv_rec okl_gtp_pvt.gtpv_rec_type;
343: ddx_gtpv_rec okl_gtp_pvt.gtpv_rec_type;
344: ddindx binary_integer; indx binary_integer;
345: begin
346:
347: -- copy data to the local IN or IN-OUT args, if any

Line 371: okl_gtp_pvt.insert_row(p_api_version,

367: ddp_gtpv_rec.gtt_id := rosetta_g_miss_num_map(p5_a14);
368:
369:
370: -- here's the delegated call to the old PL/SQL routine
371: okl_gtp_pvt.insert_row(p_api_version,
372: p_init_msg_list,
373: x_return_status,
374: x_msg_count,
375: x_msg_data,

Line 441: ddp_gtpv_tbl okl_gtp_pvt.gtpv_tbl_type;

437: , p6_a14 out nocopy JTF_NUMBER_TABLE
438: )
439:
440: as
441: ddp_gtpv_tbl okl_gtp_pvt.gtpv_tbl_type;
442: ddx_gtpv_tbl okl_gtp_pvt.gtpv_tbl_type;
443: ddindx binary_integer; indx binary_integer;
444: begin
445:

Line 442: ddx_gtpv_tbl okl_gtp_pvt.gtpv_tbl_type;

438: )
439:
440: as
441: ddp_gtpv_tbl okl_gtp_pvt.gtpv_tbl_type;
442: ddx_gtpv_tbl okl_gtp_pvt.gtpv_tbl_type;
443: ddindx binary_integer; indx binary_integer;
444: begin
445:
446: -- copy data to the local IN or IN-OUT args, if any

Line 452: okl_gtp_pvt_w.rosetta_table_copy_in_p5(ddp_gtpv_tbl, p5_a0

448:
449:
450:
451:
452: okl_gtp_pvt_w.rosetta_table_copy_in_p5(ddp_gtpv_tbl, p5_a0
453: , p5_a1
454: , p5_a2
455: , p5_a3
456: , p5_a4

Line 471: okl_gtp_pvt.insert_row(p_api_version,

467: );
468:
469:
470: -- here's the delegated call to the old PL/SQL routine
471: okl_gtp_pvt.insert_row(p_api_version,
472: p_init_msg_list,
473: x_return_status,
474: x_msg_count,
475: x_msg_data,

Line 486: okl_gtp_pvt_w.rosetta_table_copy_out_p5(ddx_gtpv_tbl, p6_a0

482:
483:
484:
485:
486: okl_gtp_pvt_w.rosetta_table_copy_out_p5(ddx_gtpv_tbl, p6_a0
487: , p6_a1
488: , p6_a2
489: , p6_a3
490: , p6_a4

Line 542: ddp_gtpv_rec okl_gtp_pvt.gtpv_rec_type;

538: , p5_a14 NUMBER := 0-1962.0724
539: )
540:
541: as
542: ddp_gtpv_rec okl_gtp_pvt.gtpv_rec_type;
543: ddx_gtpv_rec okl_gtp_pvt.gtpv_rec_type;
544: ddindx binary_integer; indx binary_integer;
545: begin
546:

Line 543: ddx_gtpv_rec okl_gtp_pvt.gtpv_rec_type;

539: )
540:
541: as
542: ddp_gtpv_rec okl_gtp_pvt.gtpv_rec_type;
543: ddx_gtpv_rec okl_gtp_pvt.gtpv_rec_type;
544: ddindx binary_integer; indx binary_integer;
545: begin
546:
547: -- copy data to the local IN or IN-OUT args, if any

Line 571: okl_gtp_pvt.update_row(p_api_version,

567: ddp_gtpv_rec.gtt_id := rosetta_g_miss_num_map(p5_a14);
568:
569:
570: -- here's the delegated call to the old PL/SQL routine
571: okl_gtp_pvt.update_row(p_api_version,
572: p_init_msg_list,
573: x_return_status,
574: x_msg_count,
575: x_msg_data,

Line 641: ddp_gtpv_tbl okl_gtp_pvt.gtpv_tbl_type;

637: , p6_a14 out nocopy JTF_NUMBER_TABLE
638: )
639:
640: as
641: ddp_gtpv_tbl okl_gtp_pvt.gtpv_tbl_type;
642: ddx_gtpv_tbl okl_gtp_pvt.gtpv_tbl_type;
643: ddindx binary_integer; indx binary_integer;
644: begin
645:

Line 642: ddx_gtpv_tbl okl_gtp_pvt.gtpv_tbl_type;

638: )
639:
640: as
641: ddp_gtpv_tbl okl_gtp_pvt.gtpv_tbl_type;
642: ddx_gtpv_tbl okl_gtp_pvt.gtpv_tbl_type;
643: ddindx binary_integer; indx binary_integer;
644: begin
645:
646: -- copy data to the local IN or IN-OUT args, if any

Line 652: okl_gtp_pvt_w.rosetta_table_copy_in_p5(ddp_gtpv_tbl, p5_a0

648:
649:
650:
651:
652: okl_gtp_pvt_w.rosetta_table_copy_in_p5(ddp_gtpv_tbl, p5_a0
653: , p5_a1
654: , p5_a2
655: , p5_a3
656: , p5_a4

Line 671: okl_gtp_pvt.update_row(p_api_version,

667: );
668:
669:
670: -- here's the delegated call to the old PL/SQL routine
671: okl_gtp_pvt.update_row(p_api_version,
672: p_init_msg_list,
673: x_return_status,
674: x_msg_count,
675: x_msg_data,

Line 686: okl_gtp_pvt_w.rosetta_table_copy_out_p5(ddx_gtpv_tbl, p6_a0

682:
683:
684:
685:
686: okl_gtp_pvt_w.rosetta_table_copy_out_p5(ddx_gtpv_tbl, p6_a0
687: , p6_a1
688: , p6_a2
689: , p6_a3
690: , p6_a4

Line 727: ddp_gtpv_rec okl_gtp_pvt.gtpv_rec_type;

723: , p5_a14 NUMBER := 0-1962.0724
724: )
725:
726: as
727: ddp_gtpv_rec okl_gtp_pvt.gtpv_rec_type;
728: ddindx binary_integer; indx binary_integer;
729: begin
730:
731: -- copy data to the local IN or IN-OUT args, if any

Line 754: okl_gtp_pvt.delete_row(p_api_version,

750: ddp_gtpv_rec.last_update_login := rosetta_g_miss_num_map(p5_a13);
751: ddp_gtpv_rec.gtt_id := rosetta_g_miss_num_map(p5_a14);
752:
753: -- here's the delegated call to the old PL/SQL routine
754: okl_gtp_pvt.delete_row(p_api_version,
755: p_init_msg_list,
756: x_return_status,
757: x_msg_count,
758: x_msg_data,

Line 792: ddp_gtpv_tbl okl_gtp_pvt.gtpv_tbl_type;

788: , p5_a14 JTF_NUMBER_TABLE
789: )
790:
791: as
792: ddp_gtpv_tbl okl_gtp_pvt.gtpv_tbl_type;
793: ddindx binary_integer; indx binary_integer;
794: begin
795:
796: -- copy data to the local IN or IN-OUT args, if any

Line 802: okl_gtp_pvt_w.rosetta_table_copy_in_p5(ddp_gtpv_tbl, p5_a0

798:
799:
800:
801:
802: okl_gtp_pvt_w.rosetta_table_copy_in_p5(ddp_gtpv_tbl, p5_a0
803: , p5_a1
804: , p5_a2
805: , p5_a3
806: , p5_a4

Line 820: okl_gtp_pvt.delete_row(p_api_version,

816: , p5_a14
817: );
818:
819: -- here's the delegated call to the old PL/SQL routine
820: okl_gtp_pvt.delete_row(p_api_version,
821: p_init_msg_list,
822: x_return_status,
823: x_msg_count,
824: x_msg_data,

Line 835: end okl_gtp_pvt_w;

831:
832:
833: end;
834:
835: end okl_gtp_pvt_w;