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_FPR_PVT_W dependencies on OKL_FPR_PVT

Line 1: package body okl_fpr_pvt_w as

1: package body okl_fpr_pvt_w as
2: /* $Header: OKLIFPRB.pls 120.1 2005/07/12 07:05:38 asawanka 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_fpr_pvt.fpr_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_fpr_pvt.fpr_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_NUMBER_TABLE

Line 61: procedure rosetta_table_copy_out_p2(t okl_fpr_pvt.fpr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

57: end loop;
58: end if;
59: end if;
60: end rosetta_table_copy_in_p2;
61: procedure rosetta_table_copy_out_p2(t okl_fpr_pvt.fpr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
62: , a1 out nocopy JTF_NUMBER_TABLE
63: , a2 out nocopy JTF_NUMBER_TABLE
64: , a3 out nocopy JTF_VARCHAR2_TABLE_100
65: , a4 out nocopy JTF_NUMBER_TABLE

Line 135: procedure rosetta_table_copy_in_p5(t out nocopy okl_fpr_pvt.okl_fnctn_prmtrs_tl_tbl_type, a0 JTF_NUMBER_TABLE

131: end if;
132: end if;
133: end rosetta_table_copy_out_p2;
134:
135: procedure rosetta_table_copy_in_p5(t out nocopy okl_fpr_pvt.okl_fnctn_prmtrs_tl_tbl_type, a0 JTF_NUMBER_TABLE
136: , a1 JTF_VARCHAR2_TABLE_100
137: , a2 JTF_VARCHAR2_TABLE_100
138: , a3 JTF_VARCHAR2_TABLE_100
139: , a4 JTF_VARCHAR2_TABLE_300

Line 174: procedure rosetta_table_copy_out_p5(t okl_fpr_pvt.okl_fnctn_prmtrs_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

170: end loop;
171: end if;
172: end if;
173: end rosetta_table_copy_in_p5;
174: procedure rosetta_table_copy_out_p5(t okl_fpr_pvt.okl_fnctn_prmtrs_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
175: , a1 out nocopy JTF_VARCHAR2_TABLE_100
176: , a2 out nocopy JTF_VARCHAR2_TABLE_100
177: , a3 out nocopy JTF_VARCHAR2_TABLE_100
178: , a4 out nocopy JTF_VARCHAR2_TABLE_300

Line 248: procedure rosetta_table_copy_in_p8(t out nocopy okl_fpr_pvt.fprv_tbl_type, a0 JTF_NUMBER_TABLE

244: end if;
245: end if;
246: end rosetta_table_copy_out_p5;
247:
248: procedure rosetta_table_copy_in_p8(t out nocopy okl_fpr_pvt.fprv_tbl_type, a0 JTF_NUMBER_TABLE
249: , a1 JTF_NUMBER_TABLE
250: , a2 JTF_VARCHAR2_TABLE_100
251: , a3 JTF_NUMBER_TABLE
252: , a4 JTF_NUMBER_TABLE

Line 293: procedure rosetta_table_copy_out_p8(t okl_fpr_pvt.fprv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

289: end loop;
290: end if;
291: end if;
292: end rosetta_table_copy_in_p8;
293: procedure rosetta_table_copy_out_p8(t okl_fpr_pvt.fprv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
294: , a1 out nocopy JTF_NUMBER_TABLE
295: , a2 out nocopy JTF_VARCHAR2_TABLE_100
296: , a3 out nocopy JTF_NUMBER_TABLE
297: , a4 out nocopy JTF_NUMBER_TABLE

Line 418: ddp_fprv_rec okl_fpr_pvt.fprv_rec_type;

414: , p5_a13 NUMBER := 0-1962.0724
415: )
416:
417: as
418: ddp_fprv_rec okl_fpr_pvt.fprv_rec_type;
419: ddx_fprv_rec okl_fpr_pvt.fprv_rec_type;
420: ddindx binary_integer; indx binary_integer;
421: begin
422:

Line 419: ddx_fprv_rec okl_fpr_pvt.fprv_rec_type;

415: )
416:
417: as
418: ddp_fprv_rec okl_fpr_pvt.fprv_rec_type;
419: ddx_fprv_rec okl_fpr_pvt.fprv_rec_type;
420: ddindx binary_integer; indx binary_integer;
421: begin
422:
423: -- copy data to the local IN or IN-OUT args, if any

Line 446: okl_fpr_pvt.insert_row(p_api_version,

442: ddp_fprv_rec.last_update_login := rosetta_g_miss_num_map(p5_a13);
443:
444:
445: -- here's the delegated call to the old PL/SQL routine
446: okl_fpr_pvt.insert_row(p_api_version,
447: p_init_msg_list,
448: x_return_status,
449: x_msg_count,
450: x_msg_data,

Line 513: ddp_fprv_tbl okl_fpr_pvt.fprv_tbl_type;

509: , p6_a13 out nocopy JTF_NUMBER_TABLE
510: )
511:
512: as
513: ddp_fprv_tbl okl_fpr_pvt.fprv_tbl_type;
514: ddx_fprv_tbl okl_fpr_pvt.fprv_tbl_type;
515: ddindx binary_integer; indx binary_integer;
516: begin
517:

Line 514: ddx_fprv_tbl okl_fpr_pvt.fprv_tbl_type;

510: )
511:
512: as
513: ddp_fprv_tbl okl_fpr_pvt.fprv_tbl_type;
514: ddx_fprv_tbl okl_fpr_pvt.fprv_tbl_type;
515: ddindx binary_integer; indx binary_integer;
516: begin
517:
518: -- copy data to the local IN or IN-OUT args, if any

Line 524: okl_fpr_pvt_w.rosetta_table_copy_in_p8(ddp_fprv_tbl, p5_a0

520:
521:
522:
523:
524: okl_fpr_pvt_w.rosetta_table_copy_in_p8(ddp_fprv_tbl, p5_a0
525: , p5_a1
526: , p5_a2
527: , p5_a3
528: , p5_a4

Line 542: okl_fpr_pvt.insert_row(p_api_version,

538: );
539:
540:
541: -- here's the delegated call to the old PL/SQL routine
542: okl_fpr_pvt.insert_row(p_api_version,
543: p_init_msg_list,
544: x_return_status,
545: x_msg_count,
546: x_msg_data,

Line 557: okl_fpr_pvt_w.rosetta_table_copy_out_p8(ddx_fprv_tbl, p6_a0

553:
554:
555:
556:
557: okl_fpr_pvt_w.rosetta_table_copy_out_p8(ddx_fprv_tbl, p6_a0
558: , p6_a1
559: , p6_a2
560: , p6_a3
561: , p6_a4

Line 596: ddp_fprv_rec okl_fpr_pvt.fprv_rec_type;

592: , p5_a13 NUMBER := 0-1962.0724
593: )
594:
595: as
596: ddp_fprv_rec okl_fpr_pvt.fprv_rec_type;
597: ddindx binary_integer; indx binary_integer;
598: begin
599:
600: -- copy data to the local IN or IN-OUT args, if any

Line 622: okl_fpr_pvt.lock_row(p_api_version,

618: ddp_fprv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a12);
619: ddp_fprv_rec.last_update_login := rosetta_g_miss_num_map(p5_a13);
620:
621: -- here's the delegated call to the old PL/SQL routine
622: okl_fpr_pvt.lock_row(p_api_version,
623: p_init_msg_list,
624: x_return_status,
625: x_msg_count,
626: x_msg_data,

Line 659: ddp_fprv_tbl okl_fpr_pvt.fprv_tbl_type;

655: , p5_a13 JTF_NUMBER_TABLE
656: )
657:
658: as
659: ddp_fprv_tbl okl_fpr_pvt.fprv_tbl_type;
660: ddindx binary_integer; indx binary_integer;
661: begin
662:
663: -- copy data to the local IN or IN-OUT args, if any

Line 669: okl_fpr_pvt_w.rosetta_table_copy_in_p8(ddp_fprv_tbl, p5_a0

665:
666:
667:
668:
669: okl_fpr_pvt_w.rosetta_table_copy_in_p8(ddp_fprv_tbl, p5_a0
670: , p5_a1
671: , p5_a2
672: , p5_a3
673: , p5_a4

Line 686: okl_fpr_pvt.lock_row(p_api_version,

682: , p5_a13
683: );
684:
685: -- here's the delegated call to the old PL/SQL routine
686: okl_fpr_pvt.lock_row(p_api_version,
687: p_init_msg_list,
688: x_return_status,
689: x_msg_count,
690: x_msg_data,

Line 737: ddp_fprv_rec okl_fpr_pvt.fprv_rec_type;

733: , p5_a13 NUMBER := 0-1962.0724
734: )
735:
736: as
737: ddp_fprv_rec okl_fpr_pvt.fprv_rec_type;
738: ddx_fprv_rec okl_fpr_pvt.fprv_rec_type;
739: ddindx binary_integer; indx binary_integer;
740: begin
741:

Line 738: ddx_fprv_rec okl_fpr_pvt.fprv_rec_type;

734: )
735:
736: as
737: ddp_fprv_rec okl_fpr_pvt.fprv_rec_type;
738: ddx_fprv_rec okl_fpr_pvt.fprv_rec_type;
739: ddindx binary_integer; indx binary_integer;
740: begin
741:
742: -- copy data to the local IN or IN-OUT args, if any

Line 765: okl_fpr_pvt.update_row(p_api_version,

761: ddp_fprv_rec.last_update_login := rosetta_g_miss_num_map(p5_a13);
762:
763:
764: -- here's the delegated call to the old PL/SQL routine
765: okl_fpr_pvt.update_row(p_api_version,
766: p_init_msg_list,
767: x_return_status,
768: x_msg_count,
769: x_msg_data,

Line 832: ddp_fprv_tbl okl_fpr_pvt.fprv_tbl_type;

828: , p6_a13 out nocopy JTF_NUMBER_TABLE
829: )
830:
831: as
832: ddp_fprv_tbl okl_fpr_pvt.fprv_tbl_type;
833: ddx_fprv_tbl okl_fpr_pvt.fprv_tbl_type;
834: ddindx binary_integer; indx binary_integer;
835: begin
836:

Line 833: ddx_fprv_tbl okl_fpr_pvt.fprv_tbl_type;

829: )
830:
831: as
832: ddp_fprv_tbl okl_fpr_pvt.fprv_tbl_type;
833: ddx_fprv_tbl okl_fpr_pvt.fprv_tbl_type;
834: ddindx binary_integer; indx binary_integer;
835: begin
836:
837: -- copy data to the local IN or IN-OUT args, if any

Line 843: okl_fpr_pvt_w.rosetta_table_copy_in_p8(ddp_fprv_tbl, p5_a0

839:
840:
841:
842:
843: okl_fpr_pvt_w.rosetta_table_copy_in_p8(ddp_fprv_tbl, p5_a0
844: , p5_a1
845: , p5_a2
846: , p5_a3
847: , p5_a4

Line 861: okl_fpr_pvt.update_row(p_api_version,

857: );
858:
859:
860: -- here's the delegated call to the old PL/SQL routine
861: okl_fpr_pvt.update_row(p_api_version,
862: p_init_msg_list,
863: x_return_status,
864: x_msg_count,
865: x_msg_data,

Line 876: okl_fpr_pvt_w.rosetta_table_copy_out_p8(ddx_fprv_tbl, p6_a0

872:
873:
874:
875:
876: okl_fpr_pvt_w.rosetta_table_copy_out_p8(ddx_fprv_tbl, p6_a0
877: , p6_a1
878: , p6_a2
879: , p6_a3
880: , p6_a4

Line 915: ddp_fprv_rec okl_fpr_pvt.fprv_rec_type;

911: , p5_a13 NUMBER := 0-1962.0724
912: )
913:
914: as
915: ddp_fprv_rec okl_fpr_pvt.fprv_rec_type;
916: ddindx binary_integer; indx binary_integer;
917: begin
918:
919: -- copy data to the local IN or IN-OUT args, if any

Line 941: okl_fpr_pvt.delete_row(p_api_version,

937: ddp_fprv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a12);
938: ddp_fprv_rec.last_update_login := rosetta_g_miss_num_map(p5_a13);
939:
940: -- here's the delegated call to the old PL/SQL routine
941: okl_fpr_pvt.delete_row(p_api_version,
942: p_init_msg_list,
943: x_return_status,
944: x_msg_count,
945: x_msg_data,

Line 978: ddp_fprv_tbl okl_fpr_pvt.fprv_tbl_type;

974: , p5_a13 JTF_NUMBER_TABLE
975: )
976:
977: as
978: ddp_fprv_tbl okl_fpr_pvt.fprv_tbl_type;
979: ddindx binary_integer; indx binary_integer;
980: begin
981:
982: -- copy data to the local IN or IN-OUT args, if any

Line 988: okl_fpr_pvt_w.rosetta_table_copy_in_p8(ddp_fprv_tbl, p5_a0

984:
985:
986:
987:
988: okl_fpr_pvt_w.rosetta_table_copy_in_p8(ddp_fprv_tbl, p5_a0
989: , p5_a1
990: , p5_a2
991: , p5_a3
992: , p5_a4

Line 1005: okl_fpr_pvt.delete_row(p_api_version,

1001: , p5_a13
1002: );
1003:
1004: -- here's the delegated call to the old PL/SQL routine
1005: okl_fpr_pvt.delete_row(p_api_version,
1006: p_init_msg_list,
1007: x_return_status,
1008: x_msg_count,
1009: x_msg_data,

Line 1042: ddp_fprv_rec okl_fpr_pvt.fprv_rec_type;

1038: , p5_a13 NUMBER := 0-1962.0724
1039: )
1040:
1041: as
1042: ddp_fprv_rec okl_fpr_pvt.fprv_rec_type;
1043: ddindx binary_integer; indx binary_integer;
1044: begin
1045:
1046: -- copy data to the local IN or IN-OUT args, if any

Line 1068: okl_fpr_pvt.validate_row(p_api_version,

1064: ddp_fprv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a12);
1065: ddp_fprv_rec.last_update_login := rosetta_g_miss_num_map(p5_a13);
1066:
1067: -- here's the delegated call to the old PL/SQL routine
1068: okl_fpr_pvt.validate_row(p_api_version,
1069: p_init_msg_list,
1070: x_return_status,
1071: x_msg_count,
1072: x_msg_data,

Line 1105: ddp_fprv_tbl okl_fpr_pvt.fprv_tbl_type;

1101: , p5_a13 JTF_NUMBER_TABLE
1102: )
1103:
1104: as
1105: ddp_fprv_tbl okl_fpr_pvt.fprv_tbl_type;
1106: ddindx binary_integer; indx binary_integer;
1107: begin
1108:
1109: -- copy data to the local IN or IN-OUT args, if any

Line 1115: okl_fpr_pvt_w.rosetta_table_copy_in_p8(ddp_fprv_tbl, p5_a0

1111:
1112:
1113:
1114:
1115: okl_fpr_pvt_w.rosetta_table_copy_in_p8(ddp_fprv_tbl, p5_a0
1116: , p5_a1
1117: , p5_a2
1118: , p5_a3
1119: , p5_a4

Line 1132: okl_fpr_pvt.validate_row(p_api_version,

1128: , p5_a13
1129: );
1130:
1131: -- here's the delegated call to the old PL/SQL routine
1132: okl_fpr_pvt.validate_row(p_api_version,
1133: p_init_msg_list,
1134: x_return_status,
1135: x_msg_count,
1136: x_msg_data,

Line 1147: end okl_fpr_pvt_w;

1143:
1144:
1145: end;
1146:
1147: end okl_fpr_pvt_w;