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_ORL_PVT_W dependencies on OKL_ORL_PVT

Line 1: package body okl_orl_pvt_w as

1: package body okl_orl_pvt_w as
2: /* $Header: OKLIORLB.pls 115.4 2002/12/24 04:06:11 sgorantl 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_orl_pvt.orl_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_orl_pvt.orl_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_NUMBER_TABLE

Line 67: procedure rosetta_table_copy_out_p2(t okl_orl_pvt.orl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

63: end loop;
64: end if;
65: end if;
66: end rosetta_table_copy_in_p2;
67: procedure rosetta_table_copy_out_p2(t okl_orl_pvt.orl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
68: , a1 out nocopy JTF_NUMBER_TABLE
69: , a2 out nocopy JTF_VARCHAR2_TABLE_100
70: , a3 out nocopy JTF_VARCHAR2_TABLE_100
71: , a4 out nocopy JTF_NUMBER_TABLE

Line 156: procedure rosetta_table_copy_in_p5(t out nocopy okl_orl_pvt.orlv_tbl_type, a0 JTF_NUMBER_TABLE

152: end if;
153: end if;
154: end rosetta_table_copy_out_p2;
155:
156: procedure rosetta_table_copy_in_p5(t out nocopy okl_orl_pvt.orlv_tbl_type, a0 JTF_NUMBER_TABLE
157: , a1 JTF_NUMBER_TABLE
158: , a2 JTF_NUMBER_TABLE
159: , a3 JTF_NUMBER_TABLE
160: , a4 JTF_VARCHAR2_TABLE_100

Line 201: procedure rosetta_table_copy_out_p5(t okl_orl_pvt.orlv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

197: end loop;
198: end if;
199: end if;
200: end rosetta_table_copy_in_p5;
201: procedure rosetta_table_copy_out_p5(t okl_orl_pvt.orlv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
202: , a1 out nocopy JTF_NUMBER_TABLE
203: , a2 out nocopy JTF_NUMBER_TABLE
204: , a3 out nocopy JTF_NUMBER_TABLE
205: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 326: ddp_orlv_rec okl_orl_pvt.orlv_rec_type;

322: , p5_a13 NUMBER := 0-1962.0724
323: )
324:
325: as
326: ddp_orlv_rec okl_orl_pvt.orlv_rec_type;
327: ddx_orlv_rec okl_orl_pvt.orlv_rec_type;
328: ddindx binary_integer; indx binary_integer;
329: begin
330:

Line 327: ddx_orlv_rec okl_orl_pvt.orlv_rec_type;

323: )
324:
325: as
326: ddp_orlv_rec okl_orl_pvt.orlv_rec_type;
327: ddx_orlv_rec okl_orl_pvt.orlv_rec_type;
328: ddindx binary_integer; indx binary_integer;
329: begin
330:
331: -- copy data to the local IN or IN-OUT args, if any

Line 354: okl_orl_pvt.insert_row(p_api_version,

350: ddp_orlv_rec.last_update_login := rosetta_g_miss_num_map(p5_a13);
351:
352:
353: -- here's the delegated call to the old PL/SQL routine
354: okl_orl_pvt.insert_row(p_api_version,
355: p_init_msg_list,
356: x_return_status,
357: x_msg_count,
358: x_msg_data,

Line 421: ddp_orlv_tbl okl_orl_pvt.orlv_tbl_type;

417: , p6_a13 out nocopy JTF_NUMBER_TABLE
418: )
419:
420: as
421: ddp_orlv_tbl okl_orl_pvt.orlv_tbl_type;
422: ddx_orlv_tbl okl_orl_pvt.orlv_tbl_type;
423: ddindx binary_integer; indx binary_integer;
424: begin
425:

Line 422: ddx_orlv_tbl okl_orl_pvt.orlv_tbl_type;

418: )
419:
420: as
421: ddp_orlv_tbl okl_orl_pvt.orlv_tbl_type;
422: ddx_orlv_tbl okl_orl_pvt.orlv_tbl_type;
423: ddindx binary_integer; indx binary_integer;
424: begin
425:
426: -- copy data to the local IN or IN-OUT args, if any

Line 432: okl_orl_pvt_w.rosetta_table_copy_in_p5(ddp_orlv_tbl, p5_a0

428:
429:
430:
431:
432: okl_orl_pvt_w.rosetta_table_copy_in_p5(ddp_orlv_tbl, p5_a0
433: , p5_a1
434: , p5_a2
435: , p5_a3
436: , p5_a4

Line 450: okl_orl_pvt.insert_row(p_api_version,

446: );
447:
448:
449: -- here's the delegated call to the old PL/SQL routine
450: okl_orl_pvt.insert_row(p_api_version,
451: p_init_msg_list,
452: x_return_status,
453: x_msg_count,
454: x_msg_data,

Line 465: okl_orl_pvt_w.rosetta_table_copy_out_p5(ddx_orlv_tbl, p6_a0

461:
462:
463:
464:
465: okl_orl_pvt_w.rosetta_table_copy_out_p5(ddx_orlv_tbl, p6_a0
466: , p6_a1
467: , p6_a2
468: , p6_a3
469: , p6_a4

Line 504: ddp_orlv_rec okl_orl_pvt.orlv_rec_type;

500: , p5_a13 NUMBER := 0-1962.0724
501: )
502:
503: as
504: ddp_orlv_rec okl_orl_pvt.orlv_rec_type;
505: ddindx binary_integer; indx binary_integer;
506: begin
507:
508: -- copy data to the local IN or IN-OUT args, if any

Line 530: okl_orl_pvt.lock_row(p_api_version,

526: ddp_orlv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a12);
527: ddp_orlv_rec.last_update_login := rosetta_g_miss_num_map(p5_a13);
528:
529: -- here's the delegated call to the old PL/SQL routine
530: okl_orl_pvt.lock_row(p_api_version,
531: p_init_msg_list,
532: x_return_status,
533: x_msg_count,
534: x_msg_data,

Line 567: ddp_orlv_tbl okl_orl_pvt.orlv_tbl_type;

563: , p5_a13 JTF_NUMBER_TABLE
564: )
565:
566: as
567: ddp_orlv_tbl okl_orl_pvt.orlv_tbl_type;
568: ddindx binary_integer; indx binary_integer;
569: begin
570:
571: -- copy data to the local IN or IN-OUT args, if any

Line 577: okl_orl_pvt_w.rosetta_table_copy_in_p5(ddp_orlv_tbl, p5_a0

573:
574:
575:
576:
577: okl_orl_pvt_w.rosetta_table_copy_in_p5(ddp_orlv_tbl, p5_a0
578: , p5_a1
579: , p5_a2
580: , p5_a3
581: , p5_a4

Line 594: okl_orl_pvt.lock_row(p_api_version,

590: , p5_a13
591: );
592:
593: -- here's the delegated call to the old PL/SQL routine
594: okl_orl_pvt.lock_row(p_api_version,
595: p_init_msg_list,
596: x_return_status,
597: x_msg_count,
598: x_msg_data,

Line 645: ddp_orlv_rec okl_orl_pvt.orlv_rec_type;

641: , p5_a13 NUMBER := 0-1962.0724
642: )
643:
644: as
645: ddp_orlv_rec okl_orl_pvt.orlv_rec_type;
646: ddx_orlv_rec okl_orl_pvt.orlv_rec_type;
647: ddindx binary_integer; indx binary_integer;
648: begin
649:

Line 646: ddx_orlv_rec okl_orl_pvt.orlv_rec_type;

642: )
643:
644: as
645: ddp_orlv_rec okl_orl_pvt.orlv_rec_type;
646: ddx_orlv_rec okl_orl_pvt.orlv_rec_type;
647: ddindx binary_integer; indx binary_integer;
648: begin
649:
650: -- copy data to the local IN or IN-OUT args, if any

Line 673: okl_orl_pvt.update_row(p_api_version,

669: ddp_orlv_rec.last_update_login := rosetta_g_miss_num_map(p5_a13);
670:
671:
672: -- here's the delegated call to the old PL/SQL routine
673: okl_orl_pvt.update_row(p_api_version,
674: p_init_msg_list,
675: x_return_status,
676: x_msg_count,
677: x_msg_data,

Line 740: ddp_orlv_tbl okl_orl_pvt.orlv_tbl_type;

736: , p6_a13 out nocopy JTF_NUMBER_TABLE
737: )
738:
739: as
740: ddp_orlv_tbl okl_orl_pvt.orlv_tbl_type;
741: ddx_orlv_tbl okl_orl_pvt.orlv_tbl_type;
742: ddindx binary_integer; indx binary_integer;
743: begin
744:

Line 741: ddx_orlv_tbl okl_orl_pvt.orlv_tbl_type;

737: )
738:
739: as
740: ddp_orlv_tbl okl_orl_pvt.orlv_tbl_type;
741: ddx_orlv_tbl okl_orl_pvt.orlv_tbl_type;
742: ddindx binary_integer; indx binary_integer;
743: begin
744:
745: -- copy data to the local IN or IN-OUT args, if any

Line 751: okl_orl_pvt_w.rosetta_table_copy_in_p5(ddp_orlv_tbl, p5_a0

747:
748:
749:
750:
751: okl_orl_pvt_w.rosetta_table_copy_in_p5(ddp_orlv_tbl, p5_a0
752: , p5_a1
753: , p5_a2
754: , p5_a3
755: , p5_a4

Line 769: okl_orl_pvt.update_row(p_api_version,

765: );
766:
767:
768: -- here's the delegated call to the old PL/SQL routine
769: okl_orl_pvt.update_row(p_api_version,
770: p_init_msg_list,
771: x_return_status,
772: x_msg_count,
773: x_msg_data,

Line 784: okl_orl_pvt_w.rosetta_table_copy_out_p5(ddx_orlv_tbl, p6_a0

780:
781:
782:
783:
784: okl_orl_pvt_w.rosetta_table_copy_out_p5(ddx_orlv_tbl, p6_a0
785: , p6_a1
786: , p6_a2
787: , p6_a3
788: , p6_a4

Line 823: ddp_orlv_rec okl_orl_pvt.orlv_rec_type;

819: , p5_a13 NUMBER := 0-1962.0724
820: )
821:
822: as
823: ddp_orlv_rec okl_orl_pvt.orlv_rec_type;
824: ddindx binary_integer; indx binary_integer;
825: begin
826:
827: -- copy data to the local IN or IN-OUT args, if any

Line 849: okl_orl_pvt.delete_row(p_api_version,

845: ddp_orlv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a12);
846: ddp_orlv_rec.last_update_login := rosetta_g_miss_num_map(p5_a13);
847:
848: -- here's the delegated call to the old PL/SQL routine
849: okl_orl_pvt.delete_row(p_api_version,
850: p_init_msg_list,
851: x_return_status,
852: x_msg_count,
853: x_msg_data,

Line 886: ddp_orlv_tbl okl_orl_pvt.orlv_tbl_type;

882: , p5_a13 JTF_NUMBER_TABLE
883: )
884:
885: as
886: ddp_orlv_tbl okl_orl_pvt.orlv_tbl_type;
887: ddindx binary_integer; indx binary_integer;
888: begin
889:
890: -- copy data to the local IN or IN-OUT args, if any

Line 896: okl_orl_pvt_w.rosetta_table_copy_in_p5(ddp_orlv_tbl, p5_a0

892:
893:
894:
895:
896: okl_orl_pvt_w.rosetta_table_copy_in_p5(ddp_orlv_tbl, p5_a0
897: , p5_a1
898: , p5_a2
899: , p5_a3
900: , p5_a4

Line 913: okl_orl_pvt.delete_row(p_api_version,

909: , p5_a13
910: );
911:
912: -- here's the delegated call to the old PL/SQL routine
913: okl_orl_pvt.delete_row(p_api_version,
914: p_init_msg_list,
915: x_return_status,
916: x_msg_count,
917: x_msg_data,

Line 950: ddp_orlv_rec okl_orl_pvt.orlv_rec_type;

946: , p5_a13 NUMBER := 0-1962.0724
947: )
948:
949: as
950: ddp_orlv_rec okl_orl_pvt.orlv_rec_type;
951: ddindx binary_integer; indx binary_integer;
952: begin
953:
954: -- copy data to the local IN or IN-OUT args, if any

Line 976: okl_orl_pvt.validate_row(p_api_version,

972: ddp_orlv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a12);
973: ddp_orlv_rec.last_update_login := rosetta_g_miss_num_map(p5_a13);
974:
975: -- here's the delegated call to the old PL/SQL routine
976: okl_orl_pvt.validate_row(p_api_version,
977: p_init_msg_list,
978: x_return_status,
979: x_msg_count,
980: x_msg_data,

Line 1013: ddp_orlv_tbl okl_orl_pvt.orlv_tbl_type;

1009: , p5_a13 JTF_NUMBER_TABLE
1010: )
1011:
1012: as
1013: ddp_orlv_tbl okl_orl_pvt.orlv_tbl_type;
1014: ddindx binary_integer; indx binary_integer;
1015: begin
1016:
1017: -- copy data to the local IN or IN-OUT args, if any

Line 1023: okl_orl_pvt_w.rosetta_table_copy_in_p5(ddp_orlv_tbl, p5_a0

1019:
1020:
1021:
1022:
1023: okl_orl_pvt_w.rosetta_table_copy_in_p5(ddp_orlv_tbl, p5_a0
1024: , p5_a1
1025: , p5_a2
1026: , p5_a3
1027: , p5_a4

Line 1040: okl_orl_pvt.validate_row(p_api_version,

1036: , p5_a13
1037: );
1038:
1039: -- here's the delegated call to the old PL/SQL routine
1040: okl_orl_pvt.validate_row(p_api_version,
1041: p_init_msg_list,
1042: x_return_status,
1043: x_msg_count,
1044: x_msg_data,

Line 1055: end okl_orl_pvt_w;

1051:
1052:
1053: end;
1054:
1055: end okl_orl_pvt_w;