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_MRB_PVT_W dependencies on OKL_MRB_PVT

Line 1: package body okl_mrb_pvt_w as

1: package body okl_mrb_pvt_w as
2: /* $Header: OKLEMRBB.pls 120.1 2005/07/11 14:18:39 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_mrb_pvt.mrbv_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_mrb_pvt.mrbv_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_600
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_VARCHAR2_TABLE_100

Line 103: procedure rosetta_table_copy_out_p2(t okl_mrb_pvt.mrbv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

99: end loop;
100: end if;
101: end if;
102: end rosetta_table_copy_in_p2;
103: procedure rosetta_table_copy_out_p2(t okl_mrb_pvt.mrbv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
104: , a1 out nocopy JTF_VARCHAR2_TABLE_600
105: , a2 out nocopy JTF_NUMBER_TABLE
106: , a3 out nocopy JTF_VARCHAR2_TABLE_100
107: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 282: procedure rosetta_table_copy_in_p5(t out nocopy okl_mrb_pvt.mrb_tbl_type, a0 JTF_NUMBER_TABLE

278: end if;
279: end if;
280: end rosetta_table_copy_out_p2;
281:
282: procedure rosetta_table_copy_in_p5(t out nocopy okl_mrb_pvt.mrb_tbl_type, a0 JTF_NUMBER_TABLE
283: , a1 JTF_VARCHAR2_TABLE_600
284: , a2 JTF_NUMBER_TABLE
285: , a3 JTF_VARCHAR2_TABLE_100
286: , a4 JTF_VARCHAR2_TABLE_100

Line 363: procedure rosetta_table_copy_out_p5(t okl_mrb_pvt.mrb_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

359: end loop;
360: end if;
361: end if;
362: end rosetta_table_copy_in_p5;
363: procedure rosetta_table_copy_out_p5(t okl_mrb_pvt.mrb_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
364: , a1 out nocopy JTF_VARCHAR2_TABLE_600
365: , a2 out nocopy JTF_NUMBER_TABLE
366: , a3 out nocopy JTF_VARCHAR2_TABLE_100
367: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 614: ddp_mrbv_rec okl_mrb_pvt.mrbv_rec_type;

610: , p5_a31 NUMBER := 0-1962.0724
611: )
612:
613: as
614: ddp_mrbv_rec okl_mrb_pvt.mrbv_rec_type;
615: ddx_mrbv_rec okl_mrb_pvt.mrbv_rec_type;
616: ddindx binary_integer; indx binary_integer;
617: begin
618:

Line 615: ddx_mrbv_rec okl_mrb_pvt.mrbv_rec_type;

611: )
612:
613: as
614: ddp_mrbv_rec okl_mrb_pvt.mrbv_rec_type;
615: ddx_mrbv_rec okl_mrb_pvt.mrbv_rec_type;
616: ddindx binary_integer; indx binary_integer;
617: begin
618:
619: -- copy data to the local IN or IN-OUT args, if any

Line 660: okl_mrb_pvt.insert_row(p_api_version,

656: ddp_mrbv_rec.last_update_login := rosetta_g_miss_num_map(p5_a31);
657:
658:
659: -- here's the delegated call to the old PL/SQL routine
660: okl_mrb_pvt.insert_row(p_api_version,
661: p_init_msg_list,
662: x_return_status,
663: x_msg_count,
664: x_msg_data,

Line 781: ddp_mrbv_tbl okl_mrb_pvt.mrbv_tbl_type;

777: , p6_a31 out nocopy JTF_NUMBER_TABLE
778: )
779:
780: as
781: ddp_mrbv_tbl okl_mrb_pvt.mrbv_tbl_type;
782: ddx_mrbv_tbl okl_mrb_pvt.mrbv_tbl_type;
783: ddindx binary_integer; indx binary_integer;
784: begin
785:

Line 782: ddx_mrbv_tbl okl_mrb_pvt.mrbv_tbl_type;

778: )
779:
780: as
781: ddp_mrbv_tbl okl_mrb_pvt.mrbv_tbl_type;
782: ddx_mrbv_tbl okl_mrb_pvt.mrbv_tbl_type;
783: ddindx binary_integer; indx binary_integer;
784: begin
785:
786: -- copy data to the local IN or IN-OUT args, if any

Line 792: okl_mrb_pvt_w.rosetta_table_copy_in_p2(ddp_mrbv_tbl, p5_a0

788:
789:
790:
791:
792: okl_mrb_pvt_w.rosetta_table_copy_in_p2(ddp_mrbv_tbl, p5_a0
793: , p5_a1
794: , p5_a2
795: , p5_a3
796: , p5_a4

Line 828: okl_mrb_pvt.insert_row(p_api_version,

824: );
825:
826:
827: -- here's the delegated call to the old PL/SQL routine
828: okl_mrb_pvt.insert_row(p_api_version,
829: p_init_msg_list,
830: x_return_status,
831: x_msg_count,
832: x_msg_data,

Line 843: okl_mrb_pvt_w.rosetta_table_copy_out_p2(ddx_mrbv_tbl, p6_a0

839:
840:
841:
842:
843: okl_mrb_pvt_w.rosetta_table_copy_out_p2(ddx_mrbv_tbl, p6_a0
844: , p6_a1
845: , p6_a2
846: , p6_a3
847: , p6_a4

Line 918: ddp_mrbv_rec okl_mrb_pvt.mrbv_rec_type;

914: , p5_a31 NUMBER := 0-1962.0724
915: )
916:
917: as
918: ddp_mrbv_rec okl_mrb_pvt.mrbv_rec_type;
919: ddindx binary_integer; indx binary_integer;
920: begin
921:
922: -- copy data to the local IN or IN-OUT args, if any

Line 962: okl_mrb_pvt.lock_row(p_api_version,

958: ddp_mrbv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a30);
959: ddp_mrbv_rec.last_update_login := rosetta_g_miss_num_map(p5_a31);
960:
961: -- here's the delegated call to the old PL/SQL routine
962: okl_mrb_pvt.lock_row(p_api_version,
963: p_init_msg_list,
964: x_return_status,
965: x_msg_count,
966: x_msg_data,

Line 1017: ddp_mrbv_tbl okl_mrb_pvt.mrbv_tbl_type;

1013: , p5_a31 JTF_NUMBER_TABLE
1014: )
1015:
1016: as
1017: ddp_mrbv_tbl okl_mrb_pvt.mrbv_tbl_type;
1018: ddindx binary_integer; indx binary_integer;
1019: begin
1020:
1021: -- copy data to the local IN or IN-OUT args, if any

Line 1027: okl_mrb_pvt_w.rosetta_table_copy_in_p2(ddp_mrbv_tbl, p5_a0

1023:
1024:
1025:
1026:
1027: okl_mrb_pvt_w.rosetta_table_copy_in_p2(ddp_mrbv_tbl, p5_a0
1028: , p5_a1
1029: , p5_a2
1030: , p5_a3
1031: , p5_a4

Line 1062: okl_mrb_pvt.lock_row(p_api_version,

1058: , p5_a31
1059: );
1060:
1061: -- here's the delegated call to the old PL/SQL routine
1062: okl_mrb_pvt.lock_row(p_api_version,
1063: p_init_msg_list,
1064: x_return_status,
1065: x_msg_count,
1066: x_msg_data,

Line 1149: ddp_mrbv_rec okl_mrb_pvt.mrbv_rec_type;

1145: , p5_a31 NUMBER := 0-1962.0724
1146: )
1147:
1148: as
1149: ddp_mrbv_rec okl_mrb_pvt.mrbv_rec_type;
1150: ddx_mrbv_rec okl_mrb_pvt.mrbv_rec_type;
1151: ddindx binary_integer; indx binary_integer;
1152: begin
1153:

Line 1150: ddx_mrbv_rec okl_mrb_pvt.mrbv_rec_type;

1146: )
1147:
1148: as
1149: ddp_mrbv_rec okl_mrb_pvt.mrbv_rec_type;
1150: ddx_mrbv_rec okl_mrb_pvt.mrbv_rec_type;
1151: ddindx binary_integer; indx binary_integer;
1152: begin
1153:
1154: -- copy data to the local IN or IN-OUT args, if any

Line 1195: okl_mrb_pvt.update_row(p_api_version,

1191: ddp_mrbv_rec.last_update_login := rosetta_g_miss_num_map(p5_a31);
1192:
1193:
1194: -- here's the delegated call to the old PL/SQL routine
1195: okl_mrb_pvt.update_row(p_api_version,
1196: p_init_msg_list,
1197: x_return_status,
1198: x_msg_count,
1199: x_msg_data,

Line 1316: ddp_mrbv_tbl okl_mrb_pvt.mrbv_tbl_type;

1312: , p6_a31 out nocopy JTF_NUMBER_TABLE
1313: )
1314:
1315: as
1316: ddp_mrbv_tbl okl_mrb_pvt.mrbv_tbl_type;
1317: ddx_mrbv_tbl okl_mrb_pvt.mrbv_tbl_type;
1318: ddindx binary_integer; indx binary_integer;
1319: begin
1320:

Line 1317: ddx_mrbv_tbl okl_mrb_pvt.mrbv_tbl_type;

1313: )
1314:
1315: as
1316: ddp_mrbv_tbl okl_mrb_pvt.mrbv_tbl_type;
1317: ddx_mrbv_tbl okl_mrb_pvt.mrbv_tbl_type;
1318: ddindx binary_integer; indx binary_integer;
1319: begin
1320:
1321: -- copy data to the local IN or IN-OUT args, if any

Line 1327: okl_mrb_pvt_w.rosetta_table_copy_in_p2(ddp_mrbv_tbl, p5_a0

1323:
1324:
1325:
1326:
1327: okl_mrb_pvt_w.rosetta_table_copy_in_p2(ddp_mrbv_tbl, p5_a0
1328: , p5_a1
1329: , p5_a2
1330: , p5_a3
1331: , p5_a4

Line 1363: okl_mrb_pvt.update_row(p_api_version,

1359: );
1360:
1361:
1362: -- here's the delegated call to the old PL/SQL routine
1363: okl_mrb_pvt.update_row(p_api_version,
1364: p_init_msg_list,
1365: x_return_status,
1366: x_msg_count,
1367: x_msg_data,

Line 1378: okl_mrb_pvt_w.rosetta_table_copy_out_p2(ddx_mrbv_tbl, p6_a0

1374:
1375:
1376:
1377:
1378: okl_mrb_pvt_w.rosetta_table_copy_out_p2(ddx_mrbv_tbl, p6_a0
1379: , p6_a1
1380: , p6_a2
1381: , p6_a3
1382: , p6_a4

Line 1453: ddp_mrbv_rec okl_mrb_pvt.mrbv_rec_type;

1449: , p5_a31 NUMBER := 0-1962.0724
1450: )
1451:
1452: as
1453: ddp_mrbv_rec okl_mrb_pvt.mrbv_rec_type;
1454: ddindx binary_integer; indx binary_integer;
1455: begin
1456:
1457: -- copy data to the local IN or IN-OUT args, if any

Line 1497: okl_mrb_pvt.delete_row(p_api_version,

1493: ddp_mrbv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a30);
1494: ddp_mrbv_rec.last_update_login := rosetta_g_miss_num_map(p5_a31);
1495:
1496: -- here's the delegated call to the old PL/SQL routine
1497: okl_mrb_pvt.delete_row(p_api_version,
1498: p_init_msg_list,
1499: x_return_status,
1500: x_msg_count,
1501: x_msg_data,

Line 1552: ddp_mrbv_tbl okl_mrb_pvt.mrbv_tbl_type;

1548: , p5_a31 JTF_NUMBER_TABLE
1549: )
1550:
1551: as
1552: ddp_mrbv_tbl okl_mrb_pvt.mrbv_tbl_type;
1553: ddindx binary_integer; indx binary_integer;
1554: begin
1555:
1556: -- copy data to the local IN or IN-OUT args, if any

Line 1562: okl_mrb_pvt_w.rosetta_table_copy_in_p2(ddp_mrbv_tbl, p5_a0

1558:
1559:
1560:
1561:
1562: okl_mrb_pvt_w.rosetta_table_copy_in_p2(ddp_mrbv_tbl, p5_a0
1563: , p5_a1
1564: , p5_a2
1565: , p5_a3
1566: , p5_a4

Line 1597: okl_mrb_pvt.delete_row(p_api_version,

1593: , p5_a31
1594: );
1595:
1596: -- here's the delegated call to the old PL/SQL routine
1597: okl_mrb_pvt.delete_row(p_api_version,
1598: p_init_msg_list,
1599: x_return_status,
1600: x_msg_count,
1601: x_msg_data,

Line 1652: ddp_mrbv_rec okl_mrb_pvt.mrbv_rec_type;

1648: , p5_a31 NUMBER := 0-1962.0724
1649: )
1650:
1651: as
1652: ddp_mrbv_rec okl_mrb_pvt.mrbv_rec_type;
1653: ddindx binary_integer; indx binary_integer;
1654: begin
1655:
1656: -- copy data to the local IN or IN-OUT args, if any

Line 1696: okl_mrb_pvt.validate_row(p_api_version,

1692: ddp_mrbv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a30);
1693: ddp_mrbv_rec.last_update_login := rosetta_g_miss_num_map(p5_a31);
1694:
1695: -- here's the delegated call to the old PL/SQL routine
1696: okl_mrb_pvt.validate_row(p_api_version,
1697: p_init_msg_list,
1698: x_return_status,
1699: x_msg_count,
1700: x_msg_data,

Line 1751: ddp_mrbv_tbl okl_mrb_pvt.mrbv_tbl_type;

1747: , p5_a31 JTF_NUMBER_TABLE
1748: )
1749:
1750: as
1751: ddp_mrbv_tbl okl_mrb_pvt.mrbv_tbl_type;
1752: ddindx binary_integer; indx binary_integer;
1753: begin
1754:
1755: -- copy data to the local IN or IN-OUT args, if any

Line 1761: okl_mrb_pvt_w.rosetta_table_copy_in_p2(ddp_mrbv_tbl, p5_a0

1757:
1758:
1759:
1760:
1761: okl_mrb_pvt_w.rosetta_table_copy_in_p2(ddp_mrbv_tbl, p5_a0
1762: , p5_a1
1763: , p5_a2
1764: , p5_a3
1765: , p5_a4

Line 1796: okl_mrb_pvt.validate_row(p_api_version,

1792: , p5_a31
1793: );
1794:
1795: -- here's the delegated call to the old PL/SQL routine
1796: okl_mrb_pvt.validate_row(p_api_version,
1797: p_init_msg_list,
1798: x_return_status,
1799: x_msg_count,
1800: x_msg_data,

Line 1811: end okl_mrb_pvt_w;

1807:
1808:
1809: end;
1810:
1811: end okl_mrb_pvt_w;