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_ITI_PVT_W dependencies on OKL_ITI_PVT

Line 1: package body okl_iti_pvt_w as

1: package body okl_iti_pvt_w as
2: /* $Header: OKLIITIB.pls 115.9 2002/12/20 19:22:24 avsingh 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_iti_pvt.iti_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_iti_pvt.iti_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_NUMBER_TABLE

Line 127: procedure rosetta_table_copy_out_p2(t okl_iti_pvt.iti_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

123: end loop;
124: end if;
125: end if;
126: end rosetta_table_copy_in_p2;
127: procedure rosetta_table_copy_out_p2(t okl_iti_pvt.iti_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
128: , a1 out nocopy JTF_NUMBER_TABLE
129: , a2 out nocopy JTF_NUMBER_TABLE
130: , a3 out nocopy JTF_NUMBER_TABLE
131: , a4 out nocopy JTF_NUMBER_TABLE

Line 366: procedure rosetta_table_copy_in_p5(t out nocopy okl_iti_pvt.itiv_tbl_type, a0 JTF_NUMBER_TABLE

362: end if;
363: end if;
364: end rosetta_table_copy_out_p2;
365:
366: procedure rosetta_table_copy_in_p5(t out nocopy okl_iti_pvt.itiv_tbl_type, a0 JTF_NUMBER_TABLE
367: , a1 JTF_NUMBER_TABLE
368: , a2 JTF_NUMBER_TABLE
369: , a3 JTF_NUMBER_TABLE
370: , a4 JTF_NUMBER_TABLE

Line 471: procedure rosetta_table_copy_out_p5(t okl_iti_pvt.itiv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

467: end loop;
468: end if;
469: end if;
470: end rosetta_table_copy_in_p5;
471: procedure rosetta_table_copy_out_p5(t okl_iti_pvt.itiv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
472: , a1 out nocopy JTF_NUMBER_TABLE
473: , a2 out nocopy JTF_NUMBER_TABLE
474: , a3 out nocopy JTF_NUMBER_TABLE
475: , a4 out nocopy JTF_NUMBER_TABLE

Line 806: ddp_itiv_rec okl_iti_pvt.itiv_rec_type;

802: , p5_a43 NUMBER := 0-1962.0724
803: )
804:
805: as
806: ddp_itiv_rec okl_iti_pvt.itiv_rec_type;
807: ddx_itiv_rec okl_iti_pvt.itiv_rec_type;
808: ddindx binary_integer; indx binary_integer;
809: begin
810:

Line 807: ddx_itiv_rec okl_iti_pvt.itiv_rec_type;

803: )
804:
805: as
806: ddp_itiv_rec okl_iti_pvt.itiv_rec_type;
807: ddx_itiv_rec okl_iti_pvt.itiv_rec_type;
808: ddindx binary_integer; indx binary_integer;
809: begin
810:
811: -- copy data to the local IN or IN-OUT args, if any

Line 864: okl_iti_pvt.insert_row(p_api_version,

860: ddp_itiv_rec.asd_id := rosetta_g_miss_num_map(p5_a43);
861:
862:
863: -- here's the delegated call to the old PL/SQL routine
864: okl_iti_pvt.insert_row(p_api_version,
865: p_init_msg_list,
866: x_return_status,
867: x_msg_count,
868: x_msg_data,

Line 1021: ddp_itiv_tbl okl_iti_pvt.itiv_tbl_type;

1017: , p6_a43 out nocopy JTF_NUMBER_TABLE
1018: )
1019:
1020: as
1021: ddp_itiv_tbl okl_iti_pvt.itiv_tbl_type;
1022: ddx_itiv_tbl okl_iti_pvt.itiv_tbl_type;
1023: ddindx binary_integer; indx binary_integer;
1024: begin
1025:

Line 1022: ddx_itiv_tbl okl_iti_pvt.itiv_tbl_type;

1018: )
1019:
1020: as
1021: ddp_itiv_tbl okl_iti_pvt.itiv_tbl_type;
1022: ddx_itiv_tbl okl_iti_pvt.itiv_tbl_type;
1023: ddindx binary_integer; indx binary_integer;
1024: begin
1025:
1026: -- copy data to the local IN or IN-OUT args, if any

Line 1032: okl_iti_pvt_w.rosetta_table_copy_in_p5(ddp_itiv_tbl, p5_a0

1028:
1029:
1030:
1031:
1032: okl_iti_pvt_w.rosetta_table_copy_in_p5(ddp_itiv_tbl, p5_a0
1033: , p5_a1
1034: , p5_a2
1035: , p5_a3
1036: , p5_a4

Line 1080: okl_iti_pvt.insert_row(p_api_version,

1076: );
1077:
1078:
1079: -- here's the delegated call to the old PL/SQL routine
1080: okl_iti_pvt.insert_row(p_api_version,
1081: p_init_msg_list,
1082: x_return_status,
1083: x_msg_count,
1084: x_msg_data,

Line 1095: okl_iti_pvt_w.rosetta_table_copy_out_p5(ddx_itiv_tbl, p6_a0

1091:
1092:
1093:
1094:
1095: okl_iti_pvt_w.rosetta_table_copy_out_p5(ddx_itiv_tbl, p6_a0
1096: , p6_a1
1097: , p6_a2
1098: , p6_a3
1099: , p6_a4

Line 1194: ddp_itiv_rec okl_iti_pvt.itiv_rec_type;

1190: , p5_a43 NUMBER := 0-1962.0724
1191: )
1192:
1193: as
1194: ddp_itiv_rec okl_iti_pvt.itiv_rec_type;
1195: ddindx binary_integer; indx binary_integer;
1196: begin
1197:
1198: -- copy data to the local IN or IN-OUT args, if any

Line 1250: okl_iti_pvt.lock_row(p_api_version,

1246: ddp_itiv_rec.selected_for_split_flag := p5_a42;
1247: ddp_itiv_rec.asd_id := rosetta_g_miss_num_map(p5_a43);
1248:
1249: -- here's the delegated call to the old PL/SQL routine
1250: okl_iti_pvt.lock_row(p_api_version,
1251: p_init_msg_list,
1252: x_return_status,
1253: x_msg_count,
1254: x_msg_data,

Line 1317: ddp_itiv_tbl okl_iti_pvt.itiv_tbl_type;

1313: , p5_a43 JTF_NUMBER_TABLE
1314: )
1315:
1316: as
1317: ddp_itiv_tbl okl_iti_pvt.itiv_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_iti_pvt_w.rosetta_table_copy_in_p5(ddp_itiv_tbl, p5_a0

1323:
1324:
1325:
1326:
1327: okl_iti_pvt_w.rosetta_table_copy_in_p5(ddp_itiv_tbl, p5_a0
1328: , p5_a1
1329: , p5_a2
1330: , p5_a3
1331: , p5_a4

Line 1374: okl_iti_pvt.lock_row(p_api_version,

1370: , p5_a43
1371: );
1372:
1373: -- here's the delegated call to the old PL/SQL routine
1374: okl_iti_pvt.lock_row(p_api_version,
1375: p_init_msg_list,
1376: x_return_status,
1377: x_msg_count,
1378: x_msg_data,

Line 1485: ddp_itiv_rec okl_iti_pvt.itiv_rec_type;

1481: , p5_a43 NUMBER := 0-1962.0724
1482: )
1483:
1484: as
1485: ddp_itiv_rec okl_iti_pvt.itiv_rec_type;
1486: ddx_itiv_rec okl_iti_pvt.itiv_rec_type;
1487: ddindx binary_integer; indx binary_integer;
1488: begin
1489:

Line 1486: ddx_itiv_rec okl_iti_pvt.itiv_rec_type;

1482: )
1483:
1484: as
1485: ddp_itiv_rec okl_iti_pvt.itiv_rec_type;
1486: ddx_itiv_rec okl_iti_pvt.itiv_rec_type;
1487: ddindx binary_integer; indx binary_integer;
1488: begin
1489:
1490: -- copy data to the local IN or IN-OUT args, if any

Line 1543: okl_iti_pvt.update_row(p_api_version,

1539: ddp_itiv_rec.asd_id := rosetta_g_miss_num_map(p5_a43);
1540:
1541:
1542: -- here's the delegated call to the old PL/SQL routine
1543: okl_iti_pvt.update_row(p_api_version,
1544: p_init_msg_list,
1545: x_return_status,
1546: x_msg_count,
1547: x_msg_data,

Line 1700: ddp_itiv_tbl okl_iti_pvt.itiv_tbl_type;

1696: , p6_a43 out nocopy JTF_NUMBER_TABLE
1697: )
1698:
1699: as
1700: ddp_itiv_tbl okl_iti_pvt.itiv_tbl_type;
1701: ddx_itiv_tbl okl_iti_pvt.itiv_tbl_type;
1702: ddindx binary_integer; indx binary_integer;
1703: begin
1704:

Line 1701: ddx_itiv_tbl okl_iti_pvt.itiv_tbl_type;

1697: )
1698:
1699: as
1700: ddp_itiv_tbl okl_iti_pvt.itiv_tbl_type;
1701: ddx_itiv_tbl okl_iti_pvt.itiv_tbl_type;
1702: ddindx binary_integer; indx binary_integer;
1703: begin
1704:
1705: -- copy data to the local IN or IN-OUT args, if any

Line 1711: okl_iti_pvt_w.rosetta_table_copy_in_p5(ddp_itiv_tbl, p5_a0

1707:
1708:
1709:
1710:
1711: okl_iti_pvt_w.rosetta_table_copy_in_p5(ddp_itiv_tbl, p5_a0
1712: , p5_a1
1713: , p5_a2
1714: , p5_a3
1715: , p5_a4

Line 1759: okl_iti_pvt.update_row(p_api_version,

1755: );
1756:
1757:
1758: -- here's the delegated call to the old PL/SQL routine
1759: okl_iti_pvt.update_row(p_api_version,
1760: p_init_msg_list,
1761: x_return_status,
1762: x_msg_count,
1763: x_msg_data,

Line 1774: okl_iti_pvt_w.rosetta_table_copy_out_p5(ddx_itiv_tbl, p6_a0

1770:
1771:
1772:
1773:
1774: okl_iti_pvt_w.rosetta_table_copy_out_p5(ddx_itiv_tbl, p6_a0
1775: , p6_a1
1776: , p6_a2
1777: , p6_a3
1778: , p6_a4

Line 1873: ddp_itiv_rec okl_iti_pvt.itiv_rec_type;

1869: , p5_a43 NUMBER := 0-1962.0724
1870: )
1871:
1872: as
1873: ddp_itiv_rec okl_iti_pvt.itiv_rec_type;
1874: ddindx binary_integer; indx binary_integer;
1875: begin
1876:
1877: -- copy data to the local IN or IN-OUT args, if any

Line 1929: okl_iti_pvt.delete_row(p_api_version,

1925: ddp_itiv_rec.selected_for_split_flag := p5_a42;
1926: ddp_itiv_rec.asd_id := rosetta_g_miss_num_map(p5_a43);
1927:
1928: -- here's the delegated call to the old PL/SQL routine
1929: okl_iti_pvt.delete_row(p_api_version,
1930: p_init_msg_list,
1931: x_return_status,
1932: x_msg_count,
1933: x_msg_data,

Line 1996: ddp_itiv_tbl okl_iti_pvt.itiv_tbl_type;

1992: , p5_a43 JTF_NUMBER_TABLE
1993: )
1994:
1995: as
1996: ddp_itiv_tbl okl_iti_pvt.itiv_tbl_type;
1997: ddindx binary_integer; indx binary_integer;
1998: begin
1999:
2000: -- copy data to the local IN or IN-OUT args, if any

Line 2006: okl_iti_pvt_w.rosetta_table_copy_in_p5(ddp_itiv_tbl, p5_a0

2002:
2003:
2004:
2005:
2006: okl_iti_pvt_w.rosetta_table_copy_in_p5(ddp_itiv_tbl, p5_a0
2007: , p5_a1
2008: , p5_a2
2009: , p5_a3
2010: , p5_a4

Line 2053: okl_iti_pvt.delete_row(p_api_version,

2049: , p5_a43
2050: );
2051:
2052: -- here's the delegated call to the old PL/SQL routine
2053: okl_iti_pvt.delete_row(p_api_version,
2054: p_init_msg_list,
2055: x_return_status,
2056: x_msg_count,
2057: x_msg_data,

Line 2120: ddp_itiv_rec okl_iti_pvt.itiv_rec_type;

2116: , p5_a43 NUMBER := 0-1962.0724
2117: )
2118:
2119: as
2120: ddp_itiv_rec okl_iti_pvt.itiv_rec_type;
2121: ddindx binary_integer; indx binary_integer;
2122: begin
2123:
2124: -- copy data to the local IN or IN-OUT args, if any

Line 2176: okl_iti_pvt.validate_row(p_api_version,

2172: ddp_itiv_rec.selected_for_split_flag := p5_a42;
2173: ddp_itiv_rec.asd_id := rosetta_g_miss_num_map(p5_a43);
2174:
2175: -- here's the delegated call to the old PL/SQL routine
2176: okl_iti_pvt.validate_row(p_api_version,
2177: p_init_msg_list,
2178: x_return_status,
2179: x_msg_count,
2180: x_msg_data,

Line 2243: ddp_itiv_tbl okl_iti_pvt.itiv_tbl_type;

2239: , p5_a43 JTF_NUMBER_TABLE
2240: )
2241:
2242: as
2243: ddp_itiv_tbl okl_iti_pvt.itiv_tbl_type;
2244: ddindx binary_integer; indx binary_integer;
2245: begin
2246:
2247: -- copy data to the local IN or IN-OUT args, if any

Line 2253: okl_iti_pvt_w.rosetta_table_copy_in_p5(ddp_itiv_tbl, p5_a0

2249:
2250:
2251:
2252:
2253: okl_iti_pvt_w.rosetta_table_copy_in_p5(ddp_itiv_tbl, p5_a0
2254: , p5_a1
2255: , p5_a2
2256: , p5_a3
2257: , p5_a4

Line 2300: okl_iti_pvt.validate_row(p_api_version,

2296: , p5_a43
2297: );
2298:
2299: -- here's the delegated call to the old PL/SQL routine
2300: okl_iti_pvt.validate_row(p_api_version,
2301: p_init_msg_list,
2302: x_return_status,
2303: x_msg_count,
2304: x_msg_data,

Line 2315: end okl_iti_pvt_w;

2311:
2312:
2313: end;
2314:
2315: end okl_iti_pvt_w;