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_PDT_PVT_W dependencies on OKL_PDT_PVT

Line 1: package body okl_pdt_pvt_w as

1: package body okl_pdt_pvt_w as
2: /* $Header: OKLIPDTB.pls 120.3 2005/10/30 04:17:12 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_pdt_pvt.pdt_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_pdt_pvt.pdt_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_200
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100

Line 105: procedure rosetta_table_copy_out_p2(t okl_pdt_pvt.pdt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

101: end loop;
102: end if;
103: end if;
104: end rosetta_table_copy_in_p2;
105: procedure rosetta_table_copy_out_p2(t okl_pdt_pvt.pdt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
106: , a1 out nocopy JTF_VARCHAR2_TABLE_200
107: , a2 out nocopy JTF_NUMBER_TABLE
108: , a3 out nocopy JTF_NUMBER_TABLE
109: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 289: procedure rosetta_table_copy_in_p5(t out nocopy okl_pdt_pvt.pdtv_tbl_type, a0 JTF_NUMBER_TABLE

285: end if;
286: end if;
287: end rosetta_table_copy_out_p2;
288:
289: procedure rosetta_table_copy_in_p5(t out nocopy okl_pdt_pvt.pdtv_tbl_type, a0 JTF_NUMBER_TABLE
290: , a1 JTF_NUMBER_TABLE
291: , a2 JTF_NUMBER_TABLE
292: , a3 JTF_NUMBER_TABLE
293: , a4 JTF_VARCHAR2_TABLE_200

Line 372: procedure rosetta_table_copy_out_p5(t okl_pdt_pvt.pdtv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

368: end loop;
369: end if;
370: end if;
371: end rosetta_table_copy_in_p5;
372: procedure rosetta_table_copy_out_p5(t okl_pdt_pvt.pdtv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
373: , a1 out nocopy JTF_NUMBER_TABLE
374: , a2 out nocopy JTF_NUMBER_TABLE
375: , a3 out nocopy JTF_NUMBER_TABLE
376: , a4 out nocopy JTF_VARCHAR2_TABLE_200

Line 630: ddp_pdtv_rec okl_pdt_pvt.pdtv_rec_type;

626: , p5_a32 NUMBER := 0-1962.0724
627: )
628:
629: as
630: ddp_pdtv_rec okl_pdt_pvt.pdtv_rec_type;
631: ddx_pdtv_rec okl_pdt_pvt.pdtv_rec_type;
632: ddindx binary_integer; indx binary_integer;
633: begin
634:

Line 631: ddx_pdtv_rec okl_pdt_pvt.pdtv_rec_type;

627: )
628:
629: as
630: ddp_pdtv_rec okl_pdt_pvt.pdtv_rec_type;
631: ddx_pdtv_rec okl_pdt_pvt.pdtv_rec_type;
632: ddindx binary_integer; indx binary_integer;
633: begin
634:
635: -- copy data to the local IN or IN-OUT args, if any

Line 677: okl_pdt_pvt.insert_row(p_api_version,

673: ddp_pdtv_rec.last_update_login := rosetta_g_miss_num_map(p5_a32);
674:
675:
676: -- here's the delegated call to the old PL/SQL routine
677: okl_pdt_pvt.insert_row(p_api_version,
678: p_init_msg_list,
679: x_return_status,
680: x_msg_count,
681: x_msg_data,

Line 801: ddp_pdtv_tbl okl_pdt_pvt.pdtv_tbl_type;

797: , p6_a32 out nocopy JTF_NUMBER_TABLE
798: )
799:
800: as
801: ddp_pdtv_tbl okl_pdt_pvt.pdtv_tbl_type;
802: ddx_pdtv_tbl okl_pdt_pvt.pdtv_tbl_type;
803: ddindx binary_integer; indx binary_integer;
804: begin
805:

Line 802: ddx_pdtv_tbl okl_pdt_pvt.pdtv_tbl_type;

798: )
799:
800: as
801: ddp_pdtv_tbl okl_pdt_pvt.pdtv_tbl_type;
802: ddx_pdtv_tbl okl_pdt_pvt.pdtv_tbl_type;
803: ddindx binary_integer; indx binary_integer;
804: begin
805:
806: -- copy data to the local IN or IN-OUT args, if any

Line 812: okl_pdt_pvt_w.rosetta_table_copy_in_p5(ddp_pdtv_tbl, p5_a0

808:
809:
810:
811:
812: okl_pdt_pvt_w.rosetta_table_copy_in_p5(ddp_pdtv_tbl, p5_a0
813: , p5_a1
814: , p5_a2
815: , p5_a3
816: , p5_a4

Line 849: okl_pdt_pvt.insert_row(p_api_version,

845: );
846:
847:
848: -- here's the delegated call to the old PL/SQL routine
849: okl_pdt_pvt.insert_row(p_api_version,
850: p_init_msg_list,
851: x_return_status,
852: x_msg_count,
853: x_msg_data,

Line 864: okl_pdt_pvt_w.rosetta_table_copy_out_p5(ddx_pdtv_tbl, p6_a0

860:
861:
862:
863:
864: okl_pdt_pvt_w.rosetta_table_copy_out_p5(ddx_pdtv_tbl, p6_a0
865: , p6_a1
866: , p6_a2
867: , p6_a3
868: , p6_a4

Line 941: ddp_pdtv_rec okl_pdt_pvt.pdtv_rec_type;

937: , p5_a32 NUMBER := 0-1962.0724
938: )
939:
940: as
941: ddp_pdtv_rec okl_pdt_pvt.pdtv_rec_type;
942: ddindx binary_integer; indx binary_integer;
943: begin
944:
945: -- copy data to the local IN or IN-OUT args, if any

Line 986: okl_pdt_pvt.lock_row(p_api_version,

982: ddp_pdtv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a31);
983: ddp_pdtv_rec.last_update_login := rosetta_g_miss_num_map(p5_a32);
984:
985: -- here's the delegated call to the old PL/SQL routine
986: okl_pdt_pvt.lock_row(p_api_version,
987: p_init_msg_list,
988: x_return_status,
989: x_msg_count,
990: x_msg_data,

Line 1042: ddp_pdtv_tbl okl_pdt_pvt.pdtv_tbl_type;

1038: , p5_a32 JTF_NUMBER_TABLE
1039: )
1040:
1041: as
1042: ddp_pdtv_tbl okl_pdt_pvt.pdtv_tbl_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 1052: okl_pdt_pvt_w.rosetta_table_copy_in_p5(ddp_pdtv_tbl, p5_a0

1048:
1049:
1050:
1051:
1052: okl_pdt_pvt_w.rosetta_table_copy_in_p5(ddp_pdtv_tbl, p5_a0
1053: , p5_a1
1054: , p5_a2
1055: , p5_a3
1056: , p5_a4

Line 1088: okl_pdt_pvt.lock_row(p_api_version,

1084: , p5_a32
1085: );
1086:
1087: -- here's the delegated call to the old PL/SQL routine
1088: okl_pdt_pvt.lock_row(p_api_version,
1089: p_init_msg_list,
1090: x_return_status,
1091: x_msg_count,
1092: x_msg_data,

Line 1177: ddp_pdtv_rec okl_pdt_pvt.pdtv_rec_type;

1173: , p5_a32 NUMBER := 0-1962.0724
1174: )
1175:
1176: as
1177: ddp_pdtv_rec okl_pdt_pvt.pdtv_rec_type;
1178: ddx_pdtv_rec okl_pdt_pvt.pdtv_rec_type;
1179: ddindx binary_integer; indx binary_integer;
1180: begin
1181:

Line 1178: ddx_pdtv_rec okl_pdt_pvt.pdtv_rec_type;

1174: )
1175:
1176: as
1177: ddp_pdtv_rec okl_pdt_pvt.pdtv_rec_type;
1178: ddx_pdtv_rec okl_pdt_pvt.pdtv_rec_type;
1179: ddindx binary_integer; indx binary_integer;
1180: begin
1181:
1182: -- copy data to the local IN or IN-OUT args, if any

Line 1224: okl_pdt_pvt.update_row(p_api_version,

1220: ddp_pdtv_rec.last_update_login := rosetta_g_miss_num_map(p5_a32);
1221:
1222:
1223: -- here's the delegated call to the old PL/SQL routine
1224: okl_pdt_pvt.update_row(p_api_version,
1225: p_init_msg_list,
1226: x_return_status,
1227: x_msg_count,
1228: x_msg_data,

Line 1348: ddp_pdtv_tbl okl_pdt_pvt.pdtv_tbl_type;

1344: , p6_a32 out nocopy JTF_NUMBER_TABLE
1345: )
1346:
1347: as
1348: ddp_pdtv_tbl okl_pdt_pvt.pdtv_tbl_type;
1349: ddx_pdtv_tbl okl_pdt_pvt.pdtv_tbl_type;
1350: ddindx binary_integer; indx binary_integer;
1351: begin
1352:

Line 1349: ddx_pdtv_tbl okl_pdt_pvt.pdtv_tbl_type;

1345: )
1346:
1347: as
1348: ddp_pdtv_tbl okl_pdt_pvt.pdtv_tbl_type;
1349: ddx_pdtv_tbl okl_pdt_pvt.pdtv_tbl_type;
1350: ddindx binary_integer; indx binary_integer;
1351: begin
1352:
1353: -- copy data to the local IN or IN-OUT args, if any

Line 1359: okl_pdt_pvt_w.rosetta_table_copy_in_p5(ddp_pdtv_tbl, p5_a0

1355:
1356:
1357:
1358:
1359: okl_pdt_pvt_w.rosetta_table_copy_in_p5(ddp_pdtv_tbl, p5_a0
1360: , p5_a1
1361: , p5_a2
1362: , p5_a3
1363: , p5_a4

Line 1396: okl_pdt_pvt.update_row(p_api_version,

1392: );
1393:
1394:
1395: -- here's the delegated call to the old PL/SQL routine
1396: okl_pdt_pvt.update_row(p_api_version,
1397: p_init_msg_list,
1398: x_return_status,
1399: x_msg_count,
1400: x_msg_data,

Line 1411: okl_pdt_pvt_w.rosetta_table_copy_out_p5(ddx_pdtv_tbl, p6_a0

1407:
1408:
1409:
1410:
1411: okl_pdt_pvt_w.rosetta_table_copy_out_p5(ddx_pdtv_tbl, p6_a0
1412: , p6_a1
1413: , p6_a2
1414: , p6_a3
1415: , p6_a4

Line 1488: ddp_pdtv_rec okl_pdt_pvt.pdtv_rec_type;

1484: , p5_a32 NUMBER := 0-1962.0724
1485: )
1486:
1487: as
1488: ddp_pdtv_rec okl_pdt_pvt.pdtv_rec_type;
1489: ddindx binary_integer; indx binary_integer;
1490: begin
1491:
1492: -- copy data to the local IN or IN-OUT args, if any

Line 1533: okl_pdt_pvt.delete_row(p_api_version,

1529: ddp_pdtv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a31);
1530: ddp_pdtv_rec.last_update_login := rosetta_g_miss_num_map(p5_a32);
1531:
1532: -- here's the delegated call to the old PL/SQL routine
1533: okl_pdt_pvt.delete_row(p_api_version,
1534: p_init_msg_list,
1535: x_return_status,
1536: x_msg_count,
1537: x_msg_data,

Line 1589: ddp_pdtv_tbl okl_pdt_pvt.pdtv_tbl_type;

1585: , p5_a32 JTF_NUMBER_TABLE
1586: )
1587:
1588: as
1589: ddp_pdtv_tbl okl_pdt_pvt.pdtv_tbl_type;
1590: ddindx binary_integer; indx binary_integer;
1591: begin
1592:
1593: -- copy data to the local IN or IN-OUT args, if any

Line 1599: okl_pdt_pvt_w.rosetta_table_copy_in_p5(ddp_pdtv_tbl, p5_a0

1595:
1596:
1597:
1598:
1599: okl_pdt_pvt_w.rosetta_table_copy_in_p5(ddp_pdtv_tbl, p5_a0
1600: , p5_a1
1601: , p5_a2
1602: , p5_a3
1603: , p5_a4

Line 1635: okl_pdt_pvt.delete_row(p_api_version,

1631: , p5_a32
1632: );
1633:
1634: -- here's the delegated call to the old PL/SQL routine
1635: okl_pdt_pvt.delete_row(p_api_version,
1636: p_init_msg_list,
1637: x_return_status,
1638: x_msg_count,
1639: x_msg_data,

Line 1691: ddp_pdtv_rec okl_pdt_pvt.pdtv_rec_type;

1687: , p5_a32 NUMBER := 0-1962.0724
1688: )
1689:
1690: as
1691: ddp_pdtv_rec okl_pdt_pvt.pdtv_rec_type;
1692: ddindx binary_integer; indx binary_integer;
1693: begin
1694:
1695: -- copy data to the local IN or IN-OUT args, if any

Line 1736: okl_pdt_pvt.validate_row(p_api_version,

1732: ddp_pdtv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a31);
1733: ddp_pdtv_rec.last_update_login := rosetta_g_miss_num_map(p5_a32);
1734:
1735: -- here's the delegated call to the old PL/SQL routine
1736: okl_pdt_pvt.validate_row(p_api_version,
1737: p_init_msg_list,
1738: x_return_status,
1739: x_msg_count,
1740: x_msg_data,

Line 1792: ddp_pdtv_tbl okl_pdt_pvt.pdtv_tbl_type;

1788: , p5_a32 JTF_NUMBER_TABLE
1789: )
1790:
1791: as
1792: ddp_pdtv_tbl okl_pdt_pvt.pdtv_tbl_type;
1793: ddindx binary_integer; indx binary_integer;
1794: begin
1795:
1796: -- copy data to the local IN or IN-OUT args, if any

Line 1802: okl_pdt_pvt_w.rosetta_table_copy_in_p5(ddp_pdtv_tbl, p5_a0

1798:
1799:
1800:
1801:
1802: okl_pdt_pvt_w.rosetta_table_copy_in_p5(ddp_pdtv_tbl, p5_a0
1803: , p5_a1
1804: , p5_a2
1805: , p5_a3
1806: , p5_a4

Line 1838: okl_pdt_pvt.validate_row(p_api_version,

1834: , p5_a32
1835: );
1836:
1837: -- here's the delegated call to the old PL/SQL routine
1838: okl_pdt_pvt.validate_row(p_api_version,
1839: p_init_msg_list,
1840: x_return_status,
1841: x_msg_count,
1842: x_msg_data,

Line 1853: end okl_pdt_pvt_w;

1849:
1850:
1851: end;
1852:
1853: end okl_pdt_pvt_w;