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_AMH_PVT_W dependencies on OKL_AMH_PVT

Line 1: package body okl_amh_pvt_w as

1: package body okl_amh_pvt_w as
2: /* $Header: OKLIAMHB.pls 115.3 2004/06/01 23:47:40 gkadarka 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_amh_pvt.amhv_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_amh_pvt.amhv_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100

Line 65: procedure rosetta_table_copy_out_p2(t okl_amh_pvt.amhv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

61: end loop;
62: end if;
63: end if;
64: end rosetta_table_copy_in_p2;
65: procedure rosetta_table_copy_out_p2(t okl_amh_pvt.amhv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
66: , a1 out nocopy JTF_NUMBER_TABLE
67: , a2 out nocopy JTF_NUMBER_TABLE
68: , a3 out nocopy JTF_NUMBER_TABLE
69: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 149: procedure rosetta_table_copy_in_p5(t out nocopy okl_amh_pvt.amh_tbl_type, a0 JTF_NUMBER_TABLE

145: end if;
146: end if;
147: end rosetta_table_copy_out_p2;
148:
149: procedure rosetta_table_copy_in_p5(t out nocopy okl_amh_pvt.amh_tbl_type, a0 JTF_NUMBER_TABLE
150: , a1 JTF_NUMBER_TABLE
151: , a2 JTF_NUMBER_TABLE
152: , a3 JTF_NUMBER_TABLE
153: , a4 JTF_VARCHAR2_TABLE_100

Line 192: procedure rosetta_table_copy_out_p5(t okl_amh_pvt.amh_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

188: end loop;
189: end if;
190: end if;
191: end rosetta_table_copy_in_p5;
192: procedure rosetta_table_copy_out_p5(t okl_amh_pvt.amh_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
193: , a1 out nocopy JTF_NUMBER_TABLE
194: , a2 out nocopy JTF_NUMBER_TABLE
195: , a3 out nocopy JTF_NUMBER_TABLE
196: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 310: ddp_amhv_rec okl_amh_pvt.amhv_rec_type;

306: , p5_a12 NUMBER := 0-1962.0724
307: )
308:
309: as
310: ddp_amhv_rec okl_amh_pvt.amhv_rec_type;
311: ddx_amhv_rec okl_amh_pvt.amhv_rec_type;
312: ddindx binary_integer; indx binary_integer;
313: begin
314:

Line 311: ddx_amhv_rec okl_amh_pvt.amhv_rec_type;

307: )
308:
309: as
310: ddp_amhv_rec okl_amh_pvt.amhv_rec_type;
311: ddx_amhv_rec okl_amh_pvt.amhv_rec_type;
312: ddindx binary_integer; indx binary_integer;
313: begin
314:
315: -- copy data to the local IN or IN-OUT args, if any

Line 337: okl_amh_pvt.insert_row(p_api_version,

333: ddp_amhv_rec.last_update_login := rosetta_g_miss_num_map(p5_a12);
334:
335:
336: -- here's the delegated call to the old PL/SQL routine
337: okl_amh_pvt.insert_row(p_api_version,
338: p_init_msg_list,
339: x_return_status,
340: x_msg_count,
341: x_msg_data,

Line 401: ddp_amhv_tbl okl_amh_pvt.amhv_tbl_type;

397: , p6_a12 out nocopy JTF_NUMBER_TABLE
398: )
399:
400: as
401: ddp_amhv_tbl okl_amh_pvt.amhv_tbl_type;
402: ddx_amhv_tbl okl_amh_pvt.amhv_tbl_type;
403: ddindx binary_integer; indx binary_integer;
404: begin
405:

Line 402: ddx_amhv_tbl okl_amh_pvt.amhv_tbl_type;

398: )
399:
400: as
401: ddp_amhv_tbl okl_amh_pvt.amhv_tbl_type;
402: ddx_amhv_tbl okl_amh_pvt.amhv_tbl_type;
403: ddindx binary_integer; indx binary_integer;
404: begin
405:
406: -- copy data to the local IN or IN-OUT args, if any

Line 412: okl_amh_pvt_w.rosetta_table_copy_in_p2(ddp_amhv_tbl, p5_a0

408:
409:
410:
411:
412: okl_amh_pvt_w.rosetta_table_copy_in_p2(ddp_amhv_tbl, p5_a0
413: , p5_a1
414: , p5_a2
415: , p5_a3
416: , p5_a4

Line 429: okl_amh_pvt.insert_row(p_api_version,

425: );
426:
427:
428: -- here's the delegated call to the old PL/SQL routine
429: okl_amh_pvt.insert_row(p_api_version,
430: p_init_msg_list,
431: x_return_status,
432: x_msg_count,
433: x_msg_data,

Line 444: okl_amh_pvt_w.rosetta_table_copy_out_p2(ddx_amhv_tbl, p6_a0

440:
441:
442:
443:
444: okl_amh_pvt_w.rosetta_table_copy_out_p2(ddx_amhv_tbl, p6_a0
445: , p6_a1
446: , p6_a2
447: , p6_a3
448: , p6_a4

Line 481: ddp_amhv_rec okl_amh_pvt.amhv_rec_type;

477: , p5_a12 NUMBER := 0-1962.0724
478: )
479:
480: as
481: ddp_amhv_rec okl_amh_pvt.amhv_rec_type;
482: ddindx binary_integer; indx binary_integer;
483: begin
484:
485: -- copy data to the local IN or IN-OUT args, if any

Line 506: okl_amh_pvt.lock_row(p_api_version,

502: ddp_amhv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a11);
503: ddp_amhv_rec.last_update_login := rosetta_g_miss_num_map(p5_a12);
504:
505: -- here's the delegated call to the old PL/SQL routine
506: okl_amh_pvt.lock_row(p_api_version,
507: p_init_msg_list,
508: x_return_status,
509: x_msg_count,
510: x_msg_data,

Line 542: ddp_amhv_tbl okl_amh_pvt.amhv_tbl_type;

538: , p5_a12 JTF_NUMBER_TABLE
539: )
540:
541: as
542: ddp_amhv_tbl okl_amh_pvt.amhv_tbl_type;
543: ddindx binary_integer; indx binary_integer;
544: begin
545:
546: -- copy data to the local IN or IN-OUT args, if any

Line 552: okl_amh_pvt_w.rosetta_table_copy_in_p2(ddp_amhv_tbl, p5_a0

548:
549:
550:
551:
552: okl_amh_pvt_w.rosetta_table_copy_in_p2(ddp_amhv_tbl, p5_a0
553: , p5_a1
554: , p5_a2
555: , p5_a3
556: , p5_a4

Line 568: okl_amh_pvt.lock_row(p_api_version,

564: , p5_a12
565: );
566:
567: -- here's the delegated call to the old PL/SQL routine
568: okl_amh_pvt.lock_row(p_api_version,
569: p_init_msg_list,
570: x_return_status,
571: x_msg_count,
572: x_msg_data,

Line 617: ddp_amhv_rec okl_amh_pvt.amhv_rec_type;

613: , p5_a12 NUMBER := 0-1962.0724
614: )
615:
616: as
617: ddp_amhv_rec okl_amh_pvt.amhv_rec_type;
618: ddx_amhv_rec okl_amh_pvt.amhv_rec_type;
619: ddindx binary_integer; indx binary_integer;
620: begin
621:

Line 618: ddx_amhv_rec okl_amh_pvt.amhv_rec_type;

614: )
615:
616: as
617: ddp_amhv_rec okl_amh_pvt.amhv_rec_type;
618: ddx_amhv_rec okl_amh_pvt.amhv_rec_type;
619: ddindx binary_integer; indx binary_integer;
620: begin
621:
622: -- copy data to the local IN or IN-OUT args, if any

Line 644: okl_amh_pvt.update_row(p_api_version,

640: ddp_amhv_rec.last_update_login := rosetta_g_miss_num_map(p5_a12);
641:
642:
643: -- here's the delegated call to the old PL/SQL routine
644: okl_amh_pvt.update_row(p_api_version,
645: p_init_msg_list,
646: x_return_status,
647: x_msg_count,
648: x_msg_data,

Line 708: ddp_amhv_tbl okl_amh_pvt.amhv_tbl_type;

704: , p6_a12 out nocopy JTF_NUMBER_TABLE
705: )
706:
707: as
708: ddp_amhv_tbl okl_amh_pvt.amhv_tbl_type;
709: ddx_amhv_tbl okl_amh_pvt.amhv_tbl_type;
710: ddindx binary_integer; indx binary_integer;
711: begin
712:

Line 709: ddx_amhv_tbl okl_amh_pvt.amhv_tbl_type;

705: )
706:
707: as
708: ddp_amhv_tbl okl_amh_pvt.amhv_tbl_type;
709: ddx_amhv_tbl okl_amh_pvt.amhv_tbl_type;
710: ddindx binary_integer; indx binary_integer;
711: begin
712:
713: -- copy data to the local IN or IN-OUT args, if any

Line 719: okl_amh_pvt_w.rosetta_table_copy_in_p2(ddp_amhv_tbl, p5_a0

715:
716:
717:
718:
719: okl_amh_pvt_w.rosetta_table_copy_in_p2(ddp_amhv_tbl, p5_a0
720: , p5_a1
721: , p5_a2
722: , p5_a3
723: , p5_a4

Line 736: okl_amh_pvt.update_row(p_api_version,

732: );
733:
734:
735: -- here's the delegated call to the old PL/SQL routine
736: okl_amh_pvt.update_row(p_api_version,
737: p_init_msg_list,
738: x_return_status,
739: x_msg_count,
740: x_msg_data,

Line 751: okl_amh_pvt_w.rosetta_table_copy_out_p2(ddx_amhv_tbl, p6_a0

747:
748:
749:
750:
751: okl_amh_pvt_w.rosetta_table_copy_out_p2(ddx_amhv_tbl, p6_a0
752: , p6_a1
753: , p6_a2
754: , p6_a3
755: , p6_a4

Line 788: ddp_amhv_rec okl_amh_pvt.amhv_rec_type;

784: , p5_a12 NUMBER := 0-1962.0724
785: )
786:
787: as
788: ddp_amhv_rec okl_amh_pvt.amhv_rec_type;
789: ddindx binary_integer; indx binary_integer;
790: begin
791:
792: -- copy data to the local IN or IN-OUT args, if any

Line 813: okl_amh_pvt.delete_row(p_api_version,

809: ddp_amhv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a11);
810: ddp_amhv_rec.last_update_login := rosetta_g_miss_num_map(p5_a12);
811:
812: -- here's the delegated call to the old PL/SQL routine
813: okl_amh_pvt.delete_row(p_api_version,
814: p_init_msg_list,
815: x_return_status,
816: x_msg_count,
817: x_msg_data,

Line 849: ddp_amhv_tbl okl_amh_pvt.amhv_tbl_type;

845: , p5_a12 JTF_NUMBER_TABLE
846: )
847:
848: as
849: ddp_amhv_tbl okl_amh_pvt.amhv_tbl_type;
850: ddindx binary_integer; indx binary_integer;
851: begin
852:
853: -- copy data to the local IN or IN-OUT args, if any

Line 859: okl_amh_pvt_w.rosetta_table_copy_in_p2(ddp_amhv_tbl, p5_a0

855:
856:
857:
858:
859: okl_amh_pvt_w.rosetta_table_copy_in_p2(ddp_amhv_tbl, p5_a0
860: , p5_a1
861: , p5_a2
862: , p5_a3
863: , p5_a4

Line 875: okl_amh_pvt.delete_row(p_api_version,

871: , p5_a12
872: );
873:
874: -- here's the delegated call to the old PL/SQL routine
875: okl_amh_pvt.delete_row(p_api_version,
876: p_init_msg_list,
877: x_return_status,
878: x_msg_count,
879: x_msg_data,

Line 911: ddp_amhv_rec okl_amh_pvt.amhv_rec_type;

907: , p5_a12 NUMBER := 0-1962.0724
908: )
909:
910: as
911: ddp_amhv_rec okl_amh_pvt.amhv_rec_type;
912: ddindx binary_integer; indx binary_integer;
913: begin
914:
915: -- copy data to the local IN or IN-OUT args, if any

Line 936: okl_amh_pvt.validate_row(p_api_version,

932: ddp_amhv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a11);
933: ddp_amhv_rec.last_update_login := rosetta_g_miss_num_map(p5_a12);
934:
935: -- here's the delegated call to the old PL/SQL routine
936: okl_amh_pvt.validate_row(p_api_version,
937: p_init_msg_list,
938: x_return_status,
939: x_msg_count,
940: x_msg_data,

Line 972: ddp_amhv_tbl okl_amh_pvt.amhv_tbl_type;

968: , p5_a12 JTF_NUMBER_TABLE
969: )
970:
971: as
972: ddp_amhv_tbl okl_amh_pvt.amhv_tbl_type;
973: ddindx binary_integer; indx binary_integer;
974: begin
975:
976: -- copy data to the local IN or IN-OUT args, if any

Line 982: okl_amh_pvt_w.rosetta_table_copy_in_p2(ddp_amhv_tbl, p5_a0

978:
979:
980:
981:
982: okl_amh_pvt_w.rosetta_table_copy_in_p2(ddp_amhv_tbl, p5_a0
983: , p5_a1
984: , p5_a2
985: , p5_a3
986: , p5_a4

Line 998: okl_amh_pvt.validate_row(p_api_version,

994: , p5_a12
995: );
996:
997: -- here's the delegated call to the old PL/SQL routine
998: okl_amh_pvt.validate_row(p_api_version,
999: p_init_msg_list,
1000: x_return_status,
1001: x_msg_count,
1002: x_msg_data,

Line 1013: end okl_amh_pvt_w;

1009:
1010:
1011: end;
1012:
1013: end okl_amh_pvt_w;