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_AVL_PVT_W dependencies on OKL_AVL_PVT

Line 1: package body okl_avl_pvt_w as

1: package body okl_avl_pvt_w as
2: /* $Header: OKLIAVLB.pls 115.6 2003/03/26 19:48:07 hkpatel 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_avl_pvt.avl_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_avl_pvt.avl_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_NUMBER_TABLE

Line 125: procedure rosetta_table_copy_out_p2(t okl_avl_pvt.avl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

121: end loop;
122: end if;
123: end if;
124: end rosetta_table_copy_in_p2;
125: procedure rosetta_table_copy_out_p2(t okl_avl_pvt.avl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
126: , a1 out nocopy JTF_VARCHAR2_TABLE_200
127: , a2 out nocopy JTF_NUMBER_TABLE
128: , a3 out nocopy JTF_NUMBER_TABLE
129: , a4 out nocopy JTF_NUMBER_TABLE

Line 359: procedure rosetta_table_copy_in_p5(t out nocopy okl_avl_pvt.avlv_tbl_type, a0 JTF_NUMBER_TABLE

355: end if;
356: end if;
357: end rosetta_table_copy_out_p2;
358:
359: procedure rosetta_table_copy_in_p5(t out nocopy okl_avl_pvt.avlv_tbl_type, a0 JTF_NUMBER_TABLE
360: , a1 JTF_NUMBER_TABLE
361: , a2 JTF_NUMBER_TABLE
362: , a3 JTF_NUMBER_TABLE
363: , a4 JTF_NUMBER_TABLE

Line 462: procedure rosetta_table_copy_out_p5(t okl_avl_pvt.avlv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

458: end loop;
459: end if;
460: end if;
461: end rosetta_table_copy_in_p5;
462: procedure rosetta_table_copy_out_p5(t okl_avl_pvt.avlv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
463: , a1 out nocopy JTF_NUMBER_TABLE
464: , a2 out nocopy JTF_NUMBER_TABLE
465: , a3 out nocopy JTF_NUMBER_TABLE
466: , a4 out nocopy JTF_NUMBER_TABLE

Line 790: ddp_avlv_rec okl_avl_pvt.avlv_rec_type;

786: , p5_a42 VARCHAR2 := fnd_api.g_miss_char
787: )
788:
789: as
790: ddp_avlv_rec okl_avl_pvt.avlv_rec_type;
791: ddx_avlv_rec okl_avl_pvt.avlv_rec_type;
792: ddindx binary_integer; indx binary_integer;
793: begin
794:

Line 791: ddx_avlv_rec okl_avl_pvt.avlv_rec_type;

787: )
788:
789: as
790: ddp_avlv_rec okl_avl_pvt.avlv_rec_type;
791: ddx_avlv_rec okl_avl_pvt.avlv_rec_type;
792: ddindx binary_integer; indx binary_integer;
793: begin
794:
795: -- copy data to the local IN or IN-OUT args, if any

Line 847: okl_avl_pvt.insert_row(p_api_version,

843: ddp_avlv_rec.inv_code := p5_a42;
844:
845:
846: -- here's the delegated call to the old PL/SQL routine
847: okl_avl_pvt.insert_row(p_api_version,
848: p_init_msg_list,
849: x_return_status,
850: x_msg_count,
851: x_msg_data,

Line 1001: ddp_avlv_tbl okl_avl_pvt.avlv_tbl_type;

997: , p6_a42 out nocopy JTF_VARCHAR2_TABLE_100
998: )
999:
1000: as
1001: ddp_avlv_tbl okl_avl_pvt.avlv_tbl_type;
1002: ddx_avlv_tbl okl_avl_pvt.avlv_tbl_type;
1003: ddindx binary_integer; indx binary_integer;
1004: begin
1005:

Line 1002: ddx_avlv_tbl okl_avl_pvt.avlv_tbl_type;

998: )
999:
1000: as
1001: ddp_avlv_tbl okl_avl_pvt.avlv_tbl_type;
1002: ddx_avlv_tbl okl_avl_pvt.avlv_tbl_type;
1003: ddindx binary_integer; indx binary_integer;
1004: begin
1005:
1006: -- copy data to the local IN or IN-OUT args, if any

Line 1012: okl_avl_pvt_w.rosetta_table_copy_in_p5(ddp_avlv_tbl, p5_a0

1008:
1009:
1010:
1011:
1012: okl_avl_pvt_w.rosetta_table_copy_in_p5(ddp_avlv_tbl, p5_a0
1013: , p5_a1
1014: , p5_a2
1015: , p5_a3
1016: , p5_a4

Line 1059: okl_avl_pvt.insert_row(p_api_version,

1055: );
1056:
1057:
1058: -- here's the delegated call to the old PL/SQL routine
1059: okl_avl_pvt.insert_row(p_api_version,
1060: p_init_msg_list,
1061: x_return_status,
1062: x_msg_count,
1063: x_msg_data,

Line 1074: okl_avl_pvt_w.rosetta_table_copy_out_p5(ddx_avlv_tbl, p6_a0

1070:
1071:
1072:
1073:
1074: okl_avl_pvt_w.rosetta_table_copy_out_p5(ddx_avlv_tbl, p6_a0
1075: , p6_a1
1076: , p6_a2
1077: , p6_a3
1078: , p6_a4

Line 1171: ddp_avlv_rec okl_avl_pvt.avlv_rec_type;

1167: , p5_a42 VARCHAR2 := fnd_api.g_miss_char
1168: )
1169:
1170: as
1171: ddp_avlv_rec okl_avl_pvt.avlv_rec_type;
1172: ddindx binary_integer; indx binary_integer;
1173: begin
1174:
1175: -- copy data to the local IN or IN-OUT args, if any

Line 1226: okl_avl_pvt.lock_row(p_api_version,

1222: ddp_avlv_rec.last_update_login := rosetta_g_miss_num_map(p5_a41);
1223: ddp_avlv_rec.inv_code := p5_a42;
1224:
1225: -- here's the delegated call to the old PL/SQL routine
1226: okl_avl_pvt.lock_row(p_api_version,
1227: p_init_msg_list,
1228: x_return_status,
1229: x_msg_count,
1230: x_msg_data,

Line 1292: ddp_avlv_tbl okl_avl_pvt.avlv_tbl_type;

1288: , p5_a42 JTF_VARCHAR2_TABLE_100
1289: )
1290:
1291: as
1292: ddp_avlv_tbl okl_avl_pvt.avlv_tbl_type;
1293: ddindx binary_integer; indx binary_integer;
1294: begin
1295:
1296: -- copy data to the local IN or IN-OUT args, if any

Line 1302: okl_avl_pvt_w.rosetta_table_copy_in_p5(ddp_avlv_tbl, p5_a0

1298:
1299:
1300:
1301:
1302: okl_avl_pvt_w.rosetta_table_copy_in_p5(ddp_avlv_tbl, p5_a0
1303: , p5_a1
1304: , p5_a2
1305: , p5_a3
1306: , p5_a4

Line 1348: okl_avl_pvt.lock_row(p_api_version,

1344: , p5_a42
1345: );
1346:
1347: -- here's the delegated call to the old PL/SQL routine
1348: okl_avl_pvt.lock_row(p_api_version,
1349: p_init_msg_list,
1350: x_return_status,
1351: x_msg_count,
1352: x_msg_data,

Line 1457: ddp_avlv_rec okl_avl_pvt.avlv_rec_type;

1453: , p5_a42 VARCHAR2 := fnd_api.g_miss_char
1454: )
1455:
1456: as
1457: ddp_avlv_rec okl_avl_pvt.avlv_rec_type;
1458: ddx_avlv_rec okl_avl_pvt.avlv_rec_type;
1459: ddindx binary_integer; indx binary_integer;
1460: begin
1461:

Line 1458: ddx_avlv_rec okl_avl_pvt.avlv_rec_type;

1454: )
1455:
1456: as
1457: ddp_avlv_rec okl_avl_pvt.avlv_rec_type;
1458: ddx_avlv_rec okl_avl_pvt.avlv_rec_type;
1459: ddindx binary_integer; indx binary_integer;
1460: begin
1461:
1462: -- copy data to the local IN or IN-OUT args, if any

Line 1514: okl_avl_pvt.update_row(p_api_version,

1510: ddp_avlv_rec.inv_code := p5_a42;
1511:
1512:
1513: -- here's the delegated call to the old PL/SQL routine
1514: okl_avl_pvt.update_row(p_api_version,
1515: p_init_msg_list,
1516: x_return_status,
1517: x_msg_count,
1518: x_msg_data,

Line 1668: ddp_avlv_tbl okl_avl_pvt.avlv_tbl_type;

1664: , p6_a42 out nocopy JTF_VARCHAR2_TABLE_100
1665: )
1666:
1667: as
1668: ddp_avlv_tbl okl_avl_pvt.avlv_tbl_type;
1669: ddx_avlv_tbl okl_avl_pvt.avlv_tbl_type;
1670: ddindx binary_integer; indx binary_integer;
1671: begin
1672:

Line 1669: ddx_avlv_tbl okl_avl_pvt.avlv_tbl_type;

1665: )
1666:
1667: as
1668: ddp_avlv_tbl okl_avl_pvt.avlv_tbl_type;
1669: ddx_avlv_tbl okl_avl_pvt.avlv_tbl_type;
1670: ddindx binary_integer; indx binary_integer;
1671: begin
1672:
1673: -- copy data to the local IN or IN-OUT args, if any

Line 1679: okl_avl_pvt_w.rosetta_table_copy_in_p5(ddp_avlv_tbl, p5_a0

1675:
1676:
1677:
1678:
1679: okl_avl_pvt_w.rosetta_table_copy_in_p5(ddp_avlv_tbl, p5_a0
1680: , p5_a1
1681: , p5_a2
1682: , p5_a3
1683: , p5_a4

Line 1726: okl_avl_pvt.update_row(p_api_version,

1722: );
1723:
1724:
1725: -- here's the delegated call to the old PL/SQL routine
1726: okl_avl_pvt.update_row(p_api_version,
1727: p_init_msg_list,
1728: x_return_status,
1729: x_msg_count,
1730: x_msg_data,

Line 1741: okl_avl_pvt_w.rosetta_table_copy_out_p5(ddx_avlv_tbl, p6_a0

1737:
1738:
1739:
1740:
1741: okl_avl_pvt_w.rosetta_table_copy_out_p5(ddx_avlv_tbl, p6_a0
1742: , p6_a1
1743: , p6_a2
1744: , p6_a3
1745: , p6_a4

Line 1838: ddp_avlv_rec okl_avl_pvt.avlv_rec_type;

1834: , p5_a42 VARCHAR2 := fnd_api.g_miss_char
1835: )
1836:
1837: as
1838: ddp_avlv_rec okl_avl_pvt.avlv_rec_type;
1839: ddindx binary_integer; indx binary_integer;
1840: begin
1841:
1842: -- copy data to the local IN or IN-OUT args, if any

Line 1893: okl_avl_pvt.delete_row(p_api_version,

1889: ddp_avlv_rec.last_update_login := rosetta_g_miss_num_map(p5_a41);
1890: ddp_avlv_rec.inv_code := p5_a42;
1891:
1892: -- here's the delegated call to the old PL/SQL routine
1893: okl_avl_pvt.delete_row(p_api_version,
1894: p_init_msg_list,
1895: x_return_status,
1896: x_msg_count,
1897: x_msg_data,

Line 1959: ddp_avlv_tbl okl_avl_pvt.avlv_tbl_type;

1955: , p5_a42 JTF_VARCHAR2_TABLE_100
1956: )
1957:
1958: as
1959: ddp_avlv_tbl okl_avl_pvt.avlv_tbl_type;
1960: ddindx binary_integer; indx binary_integer;
1961: begin
1962:
1963: -- copy data to the local IN or IN-OUT args, if any

Line 1969: okl_avl_pvt_w.rosetta_table_copy_in_p5(ddp_avlv_tbl, p5_a0

1965:
1966:
1967:
1968:
1969: okl_avl_pvt_w.rosetta_table_copy_in_p5(ddp_avlv_tbl, p5_a0
1970: , p5_a1
1971: , p5_a2
1972: , p5_a3
1973: , p5_a4

Line 2015: okl_avl_pvt.delete_row(p_api_version,

2011: , p5_a42
2012: );
2013:
2014: -- here's the delegated call to the old PL/SQL routine
2015: okl_avl_pvt.delete_row(p_api_version,
2016: p_init_msg_list,
2017: x_return_status,
2018: x_msg_count,
2019: x_msg_data,

Line 2081: ddp_avlv_rec okl_avl_pvt.avlv_rec_type;

2077: , p5_a42 VARCHAR2 := fnd_api.g_miss_char
2078: )
2079:
2080: as
2081: ddp_avlv_rec okl_avl_pvt.avlv_rec_type;
2082: ddindx binary_integer; indx binary_integer;
2083: begin
2084:
2085: -- copy data to the local IN or IN-OUT args, if any

Line 2136: okl_avl_pvt.validate_row(p_api_version,

2132: ddp_avlv_rec.last_update_login := rosetta_g_miss_num_map(p5_a41);
2133: ddp_avlv_rec.inv_code := p5_a42;
2134:
2135: -- here's the delegated call to the old PL/SQL routine
2136: okl_avl_pvt.validate_row(p_api_version,
2137: p_init_msg_list,
2138: x_return_status,
2139: x_msg_count,
2140: x_msg_data,

Line 2202: ddp_avlv_tbl okl_avl_pvt.avlv_tbl_type;

2198: , p5_a42 JTF_VARCHAR2_TABLE_100
2199: )
2200:
2201: as
2202: ddp_avlv_tbl okl_avl_pvt.avlv_tbl_type;
2203: ddindx binary_integer; indx binary_integer;
2204: begin
2205:
2206: -- copy data to the local IN or IN-OUT args, if any

Line 2212: okl_avl_pvt_w.rosetta_table_copy_in_p5(ddp_avlv_tbl, p5_a0

2208:
2209:
2210:
2211:
2212: okl_avl_pvt_w.rosetta_table_copy_in_p5(ddp_avlv_tbl, p5_a0
2213: , p5_a1
2214: , p5_a2
2215: , p5_a3
2216: , p5_a4

Line 2258: okl_avl_pvt.validate_row(p_api_version,

2254: , p5_a42
2255: );
2256:
2257: -- here's the delegated call to the old PL/SQL routine
2258: okl_avl_pvt.validate_row(p_api_version,
2259: p_init_msg_list,
2260: x_return_status,
2261: x_msg_count,
2262: x_msg_data,

Line 2273: end okl_avl_pvt_w;

2269:
2270:
2271: end;
2272:
2273: end okl_avl_pvt_w;