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_POL_PVT_W dependencies on OKL_POL_PVT

Line 1: package body okl_pol_pvt_w as

1: package body okl_pol_pvt_w as
2: /* $Header: OKLIPOLB.pls 120.4 2006/11/20 06:46:08 abhsaxen 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: rosetta_g_mistake_date_high date := to_date('01/01/+4710', 'MM/DD/SYYYY');

Line 25: procedure rosetta_table_copy_in_p2(t out nocopy okl_pol_pvt.polv_tbl_type, a0 JTF_NUMBER_TABLE

21: if n=b then return a; end if;
22: return n;
23: end;
24:
25: procedure rosetta_table_copy_in_p2(t out nocopy okl_pol_pvt.polv_tbl_type, a0 JTF_NUMBER_TABLE
26: , a1 JTF_NUMBER_TABLE
27: , a2 JTF_NUMBER_TABLE
28: , a3 JTF_NUMBER_TABLE
29: , a4 JTF_VARCHAR2_TABLE_200

Line 130: procedure rosetta_table_copy_out_p2(t okl_pol_pvt.polv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

126: end loop;
127: end if;
128: end if;
129: end rosetta_table_copy_in_p2;
130: procedure rosetta_table_copy_out_p2(t okl_pol_pvt.polv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
131: , a1 out nocopy JTF_NUMBER_TABLE
132: , a2 out nocopy JTF_NUMBER_TABLE
133: , a3 out nocopy JTF_NUMBER_TABLE
134: , a4 out nocopy JTF_VARCHAR2_TABLE_200

Line 369: procedure rosetta_table_copy_in_p5(t out nocopy okl_pol_pvt.pol_tbl_type, a0 JTF_NUMBER_TABLE

365: end if;
366: end if;
367: end rosetta_table_copy_out_p2;
368:
369: procedure rosetta_table_copy_in_p5(t out nocopy okl_pol_pvt.pol_tbl_type, a0 JTF_NUMBER_TABLE
370: , a1 JTF_NUMBER_TABLE
371: , a2 JTF_NUMBER_TABLE
372: , a3 JTF_NUMBER_TABLE
373: , a4 JTF_VARCHAR2_TABLE_200

Line 474: procedure rosetta_table_copy_out_p5(t okl_pol_pvt.pol_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

470: end loop;
471: end if;
472: end if;
473: end rosetta_table_copy_in_p5;
474: procedure rosetta_table_copy_out_p5(t okl_pol_pvt.pol_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
475: , a1 out nocopy JTF_NUMBER_TABLE
476: , a2 out nocopy JTF_NUMBER_TABLE
477: , a3 out nocopy JTF_NUMBER_TABLE
478: , a4 out nocopy JTF_VARCHAR2_TABLE_200

Line 809: ddp_polv_rec okl_pol_pvt.polv_rec_type;

805: , p5_a43 NUMBER := 0-1962.0724
806: )
807:
808: as
809: ddp_polv_rec okl_pol_pvt.polv_rec_type;
810: ddx_polv_rec okl_pol_pvt.polv_rec_type;
811: ddindx binary_integer; indx binary_integer;
812: begin
813:

Line 810: ddx_polv_rec okl_pol_pvt.polv_rec_type;

806: )
807:
808: as
809: ddp_polv_rec okl_pol_pvt.polv_rec_type;
810: ddx_polv_rec okl_pol_pvt.polv_rec_type;
811: ddindx binary_integer; indx binary_integer;
812: begin
813:
814: -- copy data to the local IN or IN-OUT args, if any

Line 867: okl_pol_pvt.insert_row(p_api_version,

863: ddp_polv_rec.legal_entity_id := rosetta_g_miss_num_map(p5_a43);
864:
865:
866: -- here's the delegated call to the old PL/SQL routine
867: okl_pol_pvt.insert_row(p_api_version,
868: p_init_msg_list,
869: x_return_status,
870: x_msg_count,
871: x_msg_data,

Line 1024: ddp_polv_tbl okl_pol_pvt.polv_tbl_type;

1020: , p6_a43 out nocopy JTF_NUMBER_TABLE
1021: )
1022:
1023: as
1024: ddp_polv_tbl okl_pol_pvt.polv_tbl_type;
1025: ddx_polv_tbl okl_pol_pvt.polv_tbl_type;
1026: ddindx binary_integer; indx binary_integer;
1027: begin
1028:

Line 1025: ddx_polv_tbl okl_pol_pvt.polv_tbl_type;

1021: )
1022:
1023: as
1024: ddp_polv_tbl okl_pol_pvt.polv_tbl_type;
1025: ddx_polv_tbl okl_pol_pvt.polv_tbl_type;
1026: ddindx binary_integer; indx binary_integer;
1027: begin
1028:
1029: -- copy data to the local IN or IN-OUT args, if any

Line 1035: okl_pol_pvt_w.rosetta_table_copy_in_p2(ddp_polv_tbl, p5_a0

1031:
1032:
1033:
1034:
1035: okl_pol_pvt_w.rosetta_table_copy_in_p2(ddp_polv_tbl, p5_a0
1036: , p5_a1
1037: , p5_a2
1038: , p5_a3
1039: , p5_a4

Line 1083: okl_pol_pvt.insert_row(p_api_version,

1079: );
1080:
1081:
1082: -- here's the delegated call to the old PL/SQL routine
1083: okl_pol_pvt.insert_row(p_api_version,
1084: p_init_msg_list,
1085: x_return_status,
1086: x_msg_count,
1087: x_msg_data,

Line 1098: okl_pol_pvt_w.rosetta_table_copy_out_p2(ddx_polv_tbl, p6_a0

1094:
1095:
1096:
1097:
1098: okl_pol_pvt_w.rosetta_table_copy_out_p2(ddx_polv_tbl, p6_a0
1099: , p6_a1
1100: , p6_a2
1101: , p6_a3
1102: , p6_a4

Line 1197: ddp_polv_rec okl_pol_pvt.polv_rec_type;

1193: , p5_a43 NUMBER := 0-1962.0724
1194: )
1195:
1196: as
1197: ddp_polv_rec okl_pol_pvt.polv_rec_type;
1198: ddindx binary_integer; indx binary_integer;
1199: begin
1200:
1201: -- copy data to the local IN or IN-OUT args, if any

Line 1253: okl_pol_pvt.lock_row(p_api_version,

1249: ddp_polv_rec.last_update_login := rosetta_g_miss_num_map(p5_a42);
1250: ddp_polv_rec.legal_entity_id := rosetta_g_miss_num_map(p5_a43);
1251:
1252: -- here's the delegated call to the old PL/SQL routine
1253: okl_pol_pvt.lock_row(p_api_version,
1254: p_init_msg_list,
1255: x_return_status,
1256: x_msg_count,
1257: x_msg_data,

Line 1320: ddp_polv_tbl okl_pol_pvt.polv_tbl_type;

1316: , p5_a43 JTF_NUMBER_TABLE
1317: )
1318:
1319: as
1320: ddp_polv_tbl okl_pol_pvt.polv_tbl_type;
1321: ddindx binary_integer; indx binary_integer;
1322: begin
1323:
1324: -- copy data to the local IN or IN-OUT args, if any

Line 1330: okl_pol_pvt_w.rosetta_table_copy_in_p2(ddp_polv_tbl, p5_a0

1326:
1327:
1328:
1329:
1330: okl_pol_pvt_w.rosetta_table_copy_in_p2(ddp_polv_tbl, p5_a0
1331: , p5_a1
1332: , p5_a2
1333: , p5_a3
1334: , p5_a4

Line 1377: okl_pol_pvt.lock_row(p_api_version,

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

Line 1488: ddp_polv_rec okl_pol_pvt.polv_rec_type;

1484: , p5_a43 NUMBER := 0-1962.0724
1485: )
1486:
1487: as
1488: ddp_polv_rec okl_pol_pvt.polv_rec_type;
1489: ddx_polv_rec okl_pol_pvt.polv_rec_type;
1490: ddindx binary_integer; indx binary_integer;
1491: begin
1492:

Line 1489: ddx_polv_rec okl_pol_pvt.polv_rec_type;

1485: )
1486:
1487: as
1488: ddp_polv_rec okl_pol_pvt.polv_rec_type;
1489: ddx_polv_rec okl_pol_pvt.polv_rec_type;
1490: ddindx binary_integer; indx binary_integer;
1491: begin
1492:
1493: -- copy data to the local IN or IN-OUT args, if any

Line 1546: okl_pol_pvt.update_row(p_api_version,

1542: ddp_polv_rec.legal_entity_id := rosetta_g_miss_num_map(p5_a43);
1543:
1544:
1545: -- here's the delegated call to the old PL/SQL routine
1546: okl_pol_pvt.update_row(p_api_version,
1547: p_init_msg_list,
1548: x_return_status,
1549: x_msg_count,
1550: x_msg_data,

Line 1703: ddp_polv_tbl okl_pol_pvt.polv_tbl_type;

1699: , p6_a43 out nocopy JTF_NUMBER_TABLE
1700: )
1701:
1702: as
1703: ddp_polv_tbl okl_pol_pvt.polv_tbl_type;
1704: ddx_polv_tbl okl_pol_pvt.polv_tbl_type;
1705: ddindx binary_integer; indx binary_integer;
1706: begin
1707:

Line 1704: ddx_polv_tbl okl_pol_pvt.polv_tbl_type;

1700: )
1701:
1702: as
1703: ddp_polv_tbl okl_pol_pvt.polv_tbl_type;
1704: ddx_polv_tbl okl_pol_pvt.polv_tbl_type;
1705: ddindx binary_integer; indx binary_integer;
1706: begin
1707:
1708: -- copy data to the local IN or IN-OUT args, if any

Line 1714: okl_pol_pvt_w.rosetta_table_copy_in_p2(ddp_polv_tbl, p5_a0

1710:
1711:
1712:
1713:
1714: okl_pol_pvt_w.rosetta_table_copy_in_p2(ddp_polv_tbl, p5_a0
1715: , p5_a1
1716: , p5_a2
1717: , p5_a3
1718: , p5_a4

Line 1762: okl_pol_pvt.update_row(p_api_version,

1758: );
1759:
1760:
1761: -- here's the delegated call to the old PL/SQL routine
1762: okl_pol_pvt.update_row(p_api_version,
1763: p_init_msg_list,
1764: x_return_status,
1765: x_msg_count,
1766: x_msg_data,

Line 1777: okl_pol_pvt_w.rosetta_table_copy_out_p2(ddx_polv_tbl, p6_a0

1773:
1774:
1775:
1776:
1777: okl_pol_pvt_w.rosetta_table_copy_out_p2(ddx_polv_tbl, p6_a0
1778: , p6_a1
1779: , p6_a2
1780: , p6_a3
1781: , p6_a4

Line 1876: ddp_polv_rec okl_pol_pvt.polv_rec_type;

1872: , p5_a43 NUMBER := 0-1962.0724
1873: )
1874:
1875: as
1876: ddp_polv_rec okl_pol_pvt.polv_rec_type;
1877: ddindx binary_integer; indx binary_integer;
1878: begin
1879:
1880: -- copy data to the local IN or IN-OUT args, if any

Line 1932: okl_pol_pvt.delete_row(p_api_version,

1928: ddp_polv_rec.last_update_login := rosetta_g_miss_num_map(p5_a42);
1929: ddp_polv_rec.legal_entity_id := rosetta_g_miss_num_map(p5_a43);
1930:
1931: -- here's the delegated call to the old PL/SQL routine
1932: okl_pol_pvt.delete_row(p_api_version,
1933: p_init_msg_list,
1934: x_return_status,
1935: x_msg_count,
1936: x_msg_data,

Line 1999: ddp_polv_tbl okl_pol_pvt.polv_tbl_type;

1995: , p5_a43 JTF_NUMBER_TABLE
1996: )
1997:
1998: as
1999: ddp_polv_tbl okl_pol_pvt.polv_tbl_type;
2000: ddindx binary_integer; indx binary_integer;
2001: begin
2002:
2003: -- copy data to the local IN or IN-OUT args, if any

Line 2009: okl_pol_pvt_w.rosetta_table_copy_in_p2(ddp_polv_tbl, p5_a0

2005:
2006:
2007:
2008:
2009: okl_pol_pvt_w.rosetta_table_copy_in_p2(ddp_polv_tbl, p5_a0
2010: , p5_a1
2011: , p5_a2
2012: , p5_a3
2013: , p5_a4

Line 2056: okl_pol_pvt.delete_row(p_api_version,

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

Line 2123: ddp_polv_rec okl_pol_pvt.polv_rec_type;

2119: , p5_a43 NUMBER := 0-1962.0724
2120: )
2121:
2122: as
2123: ddp_polv_rec okl_pol_pvt.polv_rec_type;
2124: ddindx binary_integer; indx binary_integer;
2125: begin
2126:
2127: -- copy data to the local IN or IN-OUT args, if any

Line 2179: okl_pol_pvt.validate_row(p_api_version,

2175: ddp_polv_rec.last_update_login := rosetta_g_miss_num_map(p5_a42);
2176: ddp_polv_rec.legal_entity_id := rosetta_g_miss_num_map(p5_a43);
2177:
2178: -- here's the delegated call to the old PL/SQL routine
2179: okl_pol_pvt.validate_row(p_api_version,
2180: p_init_msg_list,
2181: x_return_status,
2182: x_msg_count,
2183: x_msg_data,

Line 2246: ddp_polv_tbl okl_pol_pvt.polv_tbl_type;

2242: , p5_a43 JTF_NUMBER_TABLE
2243: )
2244:
2245: as
2246: ddp_polv_tbl okl_pol_pvt.polv_tbl_type;
2247: ddindx binary_integer; indx binary_integer;
2248: begin
2249:
2250: -- copy data to the local IN or IN-OUT args, if any

Line 2256: okl_pol_pvt_w.rosetta_table_copy_in_p2(ddp_polv_tbl, p5_a0

2252:
2253:
2254:
2255:
2256: okl_pol_pvt_w.rosetta_table_copy_in_p2(ddp_polv_tbl, p5_a0
2257: , p5_a1
2258: , p5_a2
2259: , p5_a3
2260: , p5_a4

Line 2303: okl_pol_pvt.validate_row(p_api_version,

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

Line 2318: end okl_pol_pvt_w;

2314:
2315:
2316: end;
2317:
2318: end okl_pol_pvt_w;