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_IDI_PVT_W dependencies on OKL_IDI_PVT

Line 1: package body okl_idi_pvt_w as

1: package body okl_idi_pvt_w as
2: /* $Header: OKLIIDIB.pls 120.1 2005/07/13 09:26:25 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_idi_pvt.idi_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_idi_pvt.idi_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_200
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_NUMBER_TABLE

Line 109: procedure rosetta_table_copy_out_p2(t okl_idi_pvt.idi_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

105: end loop;
106: end if;
107: end if;
108: end rosetta_table_copy_in_p2;
109: procedure rosetta_table_copy_out_p2(t okl_idi_pvt.idi_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
110: , a1 out nocopy JTF_NUMBER_TABLE
111: , a2 out nocopy JTF_VARCHAR2_TABLE_200
112: , a3 out nocopy JTF_NUMBER_TABLE
113: , a4 out nocopy JTF_NUMBER_TABLE

Line 303: procedure rosetta_table_copy_in_p5(t out nocopy okl_idi_pvt.idiv_tbl_type, a0 JTF_NUMBER_TABLE

299: end if;
300: end if;
301: end rosetta_table_copy_out_p2;
302:
303: procedure rosetta_table_copy_in_p5(t out nocopy okl_idi_pvt.idiv_tbl_type, a0 JTF_NUMBER_TABLE
304: , a1 JTF_NUMBER_TABLE
305: , a2 JTF_VARCHAR2_TABLE_200
306: , a3 JTF_NUMBER_TABLE
307: , a4 JTF_NUMBER_TABLE

Line 390: procedure rosetta_table_copy_out_p5(t okl_idi_pvt.idiv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

386: end loop;
387: end if;
388: end if;
389: end rosetta_table_copy_in_p5;
390: procedure rosetta_table_copy_out_p5(t okl_idi_pvt.idiv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
391: , a1 out nocopy JTF_NUMBER_TABLE
392: , a2 out nocopy JTF_VARCHAR2_TABLE_200
393: , a3 out nocopy JTF_NUMBER_TABLE
394: , a4 out nocopy JTF_NUMBER_TABLE

Line 662: ddp_idiv_rec okl_idi_pvt.idiv_rec_type;

658: , p5_a34 NUMBER := 0-1962.0724
659: )
660:
661: as
662: ddp_idiv_rec okl_idi_pvt.idiv_rec_type;
663: ddx_idiv_rec okl_idi_pvt.idiv_rec_type;
664: ddindx binary_integer; indx binary_integer;
665: begin
666:

Line 663: ddx_idiv_rec okl_idi_pvt.idiv_rec_type;

659: )
660:
661: as
662: ddp_idiv_rec okl_idi_pvt.idiv_rec_type;
663: ddx_idiv_rec okl_idi_pvt.idiv_rec_type;
664: ddindx binary_integer; indx binary_integer;
665: begin
666:
667: -- copy data to the local IN or IN-OUT args, if any

Line 711: okl_idi_pvt.insert_row(p_api_version,

707: ddp_idiv_rec.last_update_login := rosetta_g_miss_num_map(p5_a34);
708:
709:
710: -- here's the delegated call to the old PL/SQL routine
711: okl_idi_pvt.insert_row(p_api_version,
712: p_init_msg_list,
713: x_return_status,
714: x_msg_count,
715: x_msg_data,

Line 841: ddp_idiv_tbl okl_idi_pvt.idiv_tbl_type;

837: , p6_a34 out nocopy JTF_NUMBER_TABLE
838: )
839:
840: as
841: ddp_idiv_tbl okl_idi_pvt.idiv_tbl_type;
842: ddx_idiv_tbl okl_idi_pvt.idiv_tbl_type;
843: ddindx binary_integer; indx binary_integer;
844: begin
845:

Line 842: ddx_idiv_tbl okl_idi_pvt.idiv_tbl_type;

838: )
839:
840: as
841: ddp_idiv_tbl okl_idi_pvt.idiv_tbl_type;
842: ddx_idiv_tbl okl_idi_pvt.idiv_tbl_type;
843: ddindx binary_integer; indx binary_integer;
844: begin
845:
846: -- copy data to the local IN or IN-OUT args, if any

Line 852: okl_idi_pvt_w.rosetta_table_copy_in_p5(ddp_idiv_tbl, p5_a0

848:
849:
850:
851:
852: okl_idi_pvt_w.rosetta_table_copy_in_p5(ddp_idiv_tbl, p5_a0
853: , p5_a1
854: , p5_a2
855: , p5_a3
856: , p5_a4

Line 891: okl_idi_pvt.insert_row(p_api_version,

887: );
888:
889:
890: -- here's the delegated call to the old PL/SQL routine
891: okl_idi_pvt.insert_row(p_api_version,
892: p_init_msg_list,
893: x_return_status,
894: x_msg_count,
895: x_msg_data,

Line 906: okl_idi_pvt_w.rosetta_table_copy_out_p5(ddx_idiv_tbl, p6_a0

902:
903:
904:
905:
906: okl_idi_pvt_w.rosetta_table_copy_out_p5(ddx_idiv_tbl, p6_a0
907: , p6_a1
908: , p6_a2
909: , p6_a3
910: , p6_a4

Line 987: ddp_idiv_rec okl_idi_pvt.idiv_rec_type;

983: , p5_a34 NUMBER := 0-1962.0724
984: )
985:
986: as
987: ddp_idiv_rec okl_idi_pvt.idiv_rec_type;
988: ddindx binary_integer; indx binary_integer;
989: begin
990:
991: -- copy data to the local IN or IN-OUT args, if any

Line 1034: okl_idi_pvt.lock_row(p_api_version,

1030: ddp_idiv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a33);
1031: ddp_idiv_rec.last_update_login := rosetta_g_miss_num_map(p5_a34);
1032:
1033: -- here's the delegated call to the old PL/SQL routine
1034: okl_idi_pvt.lock_row(p_api_version,
1035: p_init_msg_list,
1036: x_return_status,
1037: x_msg_count,
1038: x_msg_data,

Line 1092: ddp_idiv_tbl okl_idi_pvt.idiv_tbl_type;

1088: , p5_a34 JTF_NUMBER_TABLE
1089: )
1090:
1091: as
1092: ddp_idiv_tbl okl_idi_pvt.idiv_tbl_type;
1093: ddindx binary_integer; indx binary_integer;
1094: begin
1095:
1096: -- copy data to the local IN or IN-OUT args, if any

Line 1102: okl_idi_pvt_w.rosetta_table_copy_in_p5(ddp_idiv_tbl, p5_a0

1098:
1099:
1100:
1101:
1102: okl_idi_pvt_w.rosetta_table_copy_in_p5(ddp_idiv_tbl, p5_a0
1103: , p5_a1
1104: , p5_a2
1105: , p5_a3
1106: , p5_a4

Line 1140: okl_idi_pvt.lock_row(p_api_version,

1136: , p5_a34
1137: );
1138:
1139: -- here's the delegated call to the old PL/SQL routine
1140: okl_idi_pvt.lock_row(p_api_version,
1141: p_init_msg_list,
1142: x_return_status,
1143: x_msg_count,
1144: x_msg_data,

Line 1233: ddp_idiv_rec okl_idi_pvt.idiv_rec_type;

1229: , p5_a34 NUMBER := 0-1962.0724
1230: )
1231:
1232: as
1233: ddp_idiv_rec okl_idi_pvt.idiv_rec_type;
1234: ddx_idiv_rec okl_idi_pvt.idiv_rec_type;
1235: ddindx binary_integer; indx binary_integer;
1236: begin
1237:

Line 1234: ddx_idiv_rec okl_idi_pvt.idiv_rec_type;

1230: )
1231:
1232: as
1233: ddp_idiv_rec okl_idi_pvt.idiv_rec_type;
1234: ddx_idiv_rec okl_idi_pvt.idiv_rec_type;
1235: ddindx binary_integer; indx binary_integer;
1236: begin
1237:
1238: -- copy data to the local IN or IN-OUT args, if any

Line 1282: okl_idi_pvt.update_row(p_api_version,

1278: ddp_idiv_rec.last_update_login := rosetta_g_miss_num_map(p5_a34);
1279:
1280:
1281: -- here's the delegated call to the old PL/SQL routine
1282: okl_idi_pvt.update_row(p_api_version,
1283: p_init_msg_list,
1284: x_return_status,
1285: x_msg_count,
1286: x_msg_data,

Line 1412: ddp_idiv_tbl okl_idi_pvt.idiv_tbl_type;

1408: , p6_a34 out nocopy JTF_NUMBER_TABLE
1409: )
1410:
1411: as
1412: ddp_idiv_tbl okl_idi_pvt.idiv_tbl_type;
1413: ddx_idiv_tbl okl_idi_pvt.idiv_tbl_type;
1414: ddindx binary_integer; indx binary_integer;
1415: begin
1416:

Line 1413: ddx_idiv_tbl okl_idi_pvt.idiv_tbl_type;

1409: )
1410:
1411: as
1412: ddp_idiv_tbl okl_idi_pvt.idiv_tbl_type;
1413: ddx_idiv_tbl okl_idi_pvt.idiv_tbl_type;
1414: ddindx binary_integer; indx binary_integer;
1415: begin
1416:
1417: -- copy data to the local IN or IN-OUT args, if any

Line 1423: okl_idi_pvt_w.rosetta_table_copy_in_p5(ddp_idiv_tbl, p5_a0

1419:
1420:
1421:
1422:
1423: okl_idi_pvt_w.rosetta_table_copy_in_p5(ddp_idiv_tbl, p5_a0
1424: , p5_a1
1425: , p5_a2
1426: , p5_a3
1427: , p5_a4

Line 1462: okl_idi_pvt.update_row(p_api_version,

1458: );
1459:
1460:
1461: -- here's the delegated call to the old PL/SQL routine
1462: okl_idi_pvt.update_row(p_api_version,
1463: p_init_msg_list,
1464: x_return_status,
1465: x_msg_count,
1466: x_msg_data,

Line 1477: okl_idi_pvt_w.rosetta_table_copy_out_p5(ddx_idiv_tbl, p6_a0

1473:
1474:
1475:
1476:
1477: okl_idi_pvt_w.rosetta_table_copy_out_p5(ddx_idiv_tbl, p6_a0
1478: , p6_a1
1479: , p6_a2
1480: , p6_a3
1481: , p6_a4

Line 1558: ddp_idiv_rec okl_idi_pvt.idiv_rec_type;

1554: , p5_a34 NUMBER := 0-1962.0724
1555: )
1556:
1557: as
1558: ddp_idiv_rec okl_idi_pvt.idiv_rec_type;
1559: ddindx binary_integer; indx binary_integer;
1560: begin
1561:
1562: -- copy data to the local IN or IN-OUT args, if any

Line 1605: okl_idi_pvt.delete_row(p_api_version,

1601: ddp_idiv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a33);
1602: ddp_idiv_rec.last_update_login := rosetta_g_miss_num_map(p5_a34);
1603:
1604: -- here's the delegated call to the old PL/SQL routine
1605: okl_idi_pvt.delete_row(p_api_version,
1606: p_init_msg_list,
1607: x_return_status,
1608: x_msg_count,
1609: x_msg_data,

Line 1663: ddp_idiv_tbl okl_idi_pvt.idiv_tbl_type;

1659: , p5_a34 JTF_NUMBER_TABLE
1660: )
1661:
1662: as
1663: ddp_idiv_tbl okl_idi_pvt.idiv_tbl_type;
1664: ddindx binary_integer; indx binary_integer;
1665: begin
1666:
1667: -- copy data to the local IN or IN-OUT args, if any

Line 1673: okl_idi_pvt_w.rosetta_table_copy_in_p5(ddp_idiv_tbl, p5_a0

1669:
1670:
1671:
1672:
1673: okl_idi_pvt_w.rosetta_table_copy_in_p5(ddp_idiv_tbl, p5_a0
1674: , p5_a1
1675: , p5_a2
1676: , p5_a3
1677: , p5_a4

Line 1711: okl_idi_pvt.delete_row(p_api_version,

1707: , p5_a34
1708: );
1709:
1710: -- here's the delegated call to the old PL/SQL routine
1711: okl_idi_pvt.delete_row(p_api_version,
1712: p_init_msg_list,
1713: x_return_status,
1714: x_msg_count,
1715: x_msg_data,

Line 1769: ddp_idiv_rec okl_idi_pvt.idiv_rec_type;

1765: , p5_a34 NUMBER := 0-1962.0724
1766: )
1767:
1768: as
1769: ddp_idiv_rec okl_idi_pvt.idiv_rec_type;
1770: ddindx binary_integer; indx binary_integer;
1771: begin
1772:
1773: -- copy data to the local IN or IN-OUT args, if any

Line 1816: okl_idi_pvt.validate_row(p_api_version,

1812: ddp_idiv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a33);
1813: ddp_idiv_rec.last_update_login := rosetta_g_miss_num_map(p5_a34);
1814:
1815: -- here's the delegated call to the old PL/SQL routine
1816: okl_idi_pvt.validate_row(p_api_version,
1817: p_init_msg_list,
1818: x_return_status,
1819: x_msg_count,
1820: x_msg_data,

Line 1874: ddp_idiv_tbl okl_idi_pvt.idiv_tbl_type;

1870: , p5_a34 JTF_NUMBER_TABLE
1871: )
1872:
1873: as
1874: ddp_idiv_tbl okl_idi_pvt.idiv_tbl_type;
1875: ddindx binary_integer; indx binary_integer;
1876: begin
1877:
1878: -- copy data to the local IN or IN-OUT args, if any

Line 1884: okl_idi_pvt_w.rosetta_table_copy_in_p5(ddp_idiv_tbl, p5_a0

1880:
1881:
1882:
1883:
1884: okl_idi_pvt_w.rosetta_table_copy_in_p5(ddp_idiv_tbl, p5_a0
1885: , p5_a1
1886: , p5_a2
1887: , p5_a3
1888: , p5_a4

Line 1922: okl_idi_pvt.validate_row(p_api_version,

1918: , p5_a34
1919: );
1920:
1921: -- here's the delegated call to the old PL/SQL routine
1922: okl_idi_pvt.validate_row(p_api_version,
1923: p_init_msg_list,
1924: x_return_status,
1925: x_msg_count,
1926: x_msg_data,

Line 1937: end okl_idi_pvt_w;

1933:
1934:
1935: end;
1936:
1937: end okl_idi_pvt_w;