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_LPO_PVT_W dependencies on OKL_LPO_PVT

Line 1: package body okl_lpo_pvt_w as

1: package body okl_lpo_pvt_w as
2: /* $Header: OKLILPOB.pls 115.5 2003/11/06 01:31:24 pjgomes 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_lpo_pvt.lpov_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_lpo_pvt.lpov_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_2000
25: , a3 JTF_VARCHAR2_TABLE_2000
26: , a4 JTF_NUMBER_TABLE

Line 133: procedure rosetta_table_copy_out_p2(t okl_lpo_pvt.lpov_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

129: end loop;
130: end if;
131: end if;
132: end rosetta_table_copy_in_p2;
133: procedure rosetta_table_copy_out_p2(t okl_lpo_pvt.lpov_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
134: , a1 out nocopy JTF_NUMBER_TABLE
135: , a2 out nocopy JTF_VARCHAR2_TABLE_2000
136: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
137: , a4 out nocopy JTF_NUMBER_TABLE

Line 387: procedure rosetta_table_copy_in_p5(t out nocopy okl_lpo_pvt.lpo_tbl_type, a0 JTF_NUMBER_TABLE

383: end if;
384: end if;
385: end rosetta_table_copy_out_p2;
386:
387: procedure rosetta_table_copy_in_p5(t out nocopy okl_lpo_pvt.lpo_tbl_type, a0 JTF_NUMBER_TABLE
388: , a1 JTF_NUMBER_TABLE
389: , a2 JTF_NUMBER_TABLE
390: , a3 JTF_NUMBER_TABLE
391: , a4 JTF_NUMBER_TABLE

Line 494: procedure rosetta_table_copy_out_p5(t okl_lpo_pvt.lpo_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

490: end loop;
491: end if;
492: end if;
493: end rosetta_table_copy_in_p5;
494: procedure rosetta_table_copy_out_p5(t okl_lpo_pvt.lpo_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
495: , a1 out nocopy JTF_NUMBER_TABLE
496: , a2 out nocopy JTF_NUMBER_TABLE
497: , a3 out nocopy JTF_NUMBER_TABLE
498: , a4 out nocopy JTF_NUMBER_TABLE

Line 738: procedure rosetta_table_copy_in_p8(t out nocopy okl_lpo_pvt.okl_late_policies_tl_tbl_type, a0 JTF_NUMBER_TABLE

734: end if;
735: end if;
736: end rosetta_table_copy_out_p5;
737:
738: procedure rosetta_table_copy_in_p8(t out nocopy okl_lpo_pvt.okl_late_policies_tl_tbl_type, a0 JTF_NUMBER_TABLE
739: , a1 JTF_VARCHAR2_TABLE_100
740: , a2 JTF_VARCHAR2_TABLE_100
741: , a3 JTF_VARCHAR2_TABLE_2000
742: , a4 JTF_VARCHAR2_TABLE_2000

Line 775: procedure rosetta_table_copy_out_p8(t okl_lpo_pvt.okl_late_policies_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

771: end loop;
772: end if;
773: end if;
774: end rosetta_table_copy_in_p8;
775: procedure rosetta_table_copy_out_p8(t okl_lpo_pvt.okl_late_policies_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
776: , a1 out nocopy JTF_VARCHAR2_TABLE_100
777: , a2 out nocopy JTF_VARCHAR2_TABLE_100
778: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
779: , a4 out nocopy JTF_VARCHAR2_TABLE_2000

Line 946: ddp_lpov_rec okl_lpo_pvt.lpov_rec_type;

942: , p5_a46 VARCHAR2 := okl_api.g_miss_char
943: )
944:
945: as
946: ddp_lpov_rec okl_lpo_pvt.lpov_rec_type;
947: ddx_lpov_rec okl_lpo_pvt.lpov_rec_type;
948: ddindx binary_integer; indx binary_integer;
949: begin
950:

Line 947: ddx_lpov_rec okl_lpo_pvt.lpov_rec_type;

943: )
944:
945: as
946: ddp_lpov_rec okl_lpo_pvt.lpov_rec_type;
947: ddx_lpov_rec okl_lpo_pvt.lpov_rec_type;
948: ddindx binary_integer; indx binary_integer;
949: begin
950:
951: -- copy data to the local IN or IN-OUT args, if any

Line 1007: okl_lpo_pvt.insert_row(p_api_version,

1003: ddp_lpov_rec.days_in_year := p5_a46;
1004:
1005:
1006: -- here's the delegated call to the old PL/SQL routine
1007: okl_lpo_pvt.insert_row(p_api_version,
1008: p_init_msg_list,
1009: x_return_status,
1010: x_msg_count,
1011: x_msg_data,

Line 1173: ddp_lpov_tbl okl_lpo_pvt.lpov_tbl_type;

1169: , p6_a46 out nocopy JTF_VARCHAR2_TABLE_100
1170: )
1171:
1172: as
1173: ddp_lpov_tbl okl_lpo_pvt.lpov_tbl_type;
1174: ddx_lpov_tbl okl_lpo_pvt.lpov_tbl_type;
1175: ddindx binary_integer; indx binary_integer;
1176: begin
1177:

Line 1174: ddx_lpov_tbl okl_lpo_pvt.lpov_tbl_type;

1170: )
1171:
1172: as
1173: ddp_lpov_tbl okl_lpo_pvt.lpov_tbl_type;
1174: ddx_lpov_tbl okl_lpo_pvt.lpov_tbl_type;
1175: ddindx binary_integer; indx binary_integer;
1176: begin
1177:
1178: -- copy data to the local IN or IN-OUT args, if any

Line 1184: okl_lpo_pvt_w.rosetta_table_copy_in_p2(ddp_lpov_tbl, p5_a0

1180:
1181:
1182:
1183:
1184: okl_lpo_pvt_w.rosetta_table_copy_in_p2(ddp_lpov_tbl, p5_a0
1185: , p5_a1
1186: , p5_a2
1187: , p5_a3
1188: , p5_a4

Line 1235: okl_lpo_pvt.insert_row(p_api_version,

1231: );
1232:
1233:
1234: -- here's the delegated call to the old PL/SQL routine
1235: okl_lpo_pvt.insert_row(p_api_version,
1236: p_init_msg_list,
1237: x_return_status,
1238: x_msg_count,
1239: x_msg_data,

Line 1250: okl_lpo_pvt_w.rosetta_table_copy_out_p2(ddx_lpov_tbl, p6_a0

1246:
1247:
1248:
1249:
1250: okl_lpo_pvt_w.rosetta_table_copy_out_p2(ddx_lpov_tbl, p6_a0
1251: , p6_a1
1252: , p6_a2
1253: , p6_a3
1254: , p6_a4

Line 1355: ddp_lpov_rec okl_lpo_pvt.lpov_rec_type;

1351: , p5_a46 VARCHAR2 := okl_api.g_miss_char
1352: )
1353:
1354: as
1355: ddp_lpov_rec okl_lpo_pvt.lpov_rec_type;
1356: ddindx binary_integer; indx binary_integer;
1357: begin
1358:
1359: -- copy data to the local IN or IN-OUT args, if any

Line 1414: okl_lpo_pvt.lock_row(p_api_version,

1410: ddp_lpov_rec.last_update_login := rosetta_g_miss_num_map(p5_a45);
1411: ddp_lpov_rec.days_in_year := p5_a46;
1412:
1413: -- here's the delegated call to the old PL/SQL routine
1414: okl_lpo_pvt.lock_row(p_api_version,
1415: p_init_msg_list,
1416: x_return_status,
1417: x_msg_count,
1418: x_msg_data,

Line 1484: ddp_lpov_tbl okl_lpo_pvt.lpov_tbl_type;

1480: , p5_a46 JTF_VARCHAR2_TABLE_100
1481: )
1482:
1483: as
1484: ddp_lpov_tbl okl_lpo_pvt.lpov_tbl_type;
1485: ddindx binary_integer; indx binary_integer;
1486: begin
1487:
1488: -- copy data to the local IN or IN-OUT args, if any

Line 1494: okl_lpo_pvt_w.rosetta_table_copy_in_p2(ddp_lpov_tbl, p5_a0

1490:
1491:
1492:
1493:
1494: okl_lpo_pvt_w.rosetta_table_copy_in_p2(ddp_lpov_tbl, p5_a0
1495: , p5_a1
1496: , p5_a2
1497: , p5_a3
1498: , p5_a4

Line 1544: okl_lpo_pvt.lock_row(p_api_version,

1540: , p5_a46
1541: );
1542:
1543: -- here's the delegated call to the old PL/SQL routine
1544: okl_lpo_pvt.lock_row(p_api_version,
1545: p_init_msg_list,
1546: x_return_status,
1547: x_msg_count,
1548: x_msg_data,

Line 1661: ddp_lpov_rec okl_lpo_pvt.lpov_rec_type;

1657: , p5_a46 VARCHAR2 := okl_api.g_miss_char
1658: )
1659:
1660: as
1661: ddp_lpov_rec okl_lpo_pvt.lpov_rec_type;
1662: ddx_lpov_rec okl_lpo_pvt.lpov_rec_type;
1663: ddindx binary_integer; indx binary_integer;
1664: begin
1665:

Line 1662: ddx_lpov_rec okl_lpo_pvt.lpov_rec_type;

1658: )
1659:
1660: as
1661: ddp_lpov_rec okl_lpo_pvt.lpov_rec_type;
1662: ddx_lpov_rec okl_lpo_pvt.lpov_rec_type;
1663: ddindx binary_integer; indx binary_integer;
1664: begin
1665:
1666: -- copy data to the local IN or IN-OUT args, if any

Line 1722: okl_lpo_pvt.update_row(p_api_version,

1718: ddp_lpov_rec.days_in_year := p5_a46;
1719:
1720:
1721: -- here's the delegated call to the old PL/SQL routine
1722: okl_lpo_pvt.update_row(p_api_version,
1723: p_init_msg_list,
1724: x_return_status,
1725: x_msg_count,
1726: x_msg_data,

Line 1888: ddp_lpov_tbl okl_lpo_pvt.lpov_tbl_type;

1884: , p6_a46 out nocopy JTF_VARCHAR2_TABLE_100
1885: )
1886:
1887: as
1888: ddp_lpov_tbl okl_lpo_pvt.lpov_tbl_type;
1889: ddx_lpov_tbl okl_lpo_pvt.lpov_tbl_type;
1890: ddindx binary_integer; indx binary_integer;
1891: begin
1892:

Line 1889: ddx_lpov_tbl okl_lpo_pvt.lpov_tbl_type;

1885: )
1886:
1887: as
1888: ddp_lpov_tbl okl_lpo_pvt.lpov_tbl_type;
1889: ddx_lpov_tbl okl_lpo_pvt.lpov_tbl_type;
1890: ddindx binary_integer; indx binary_integer;
1891: begin
1892:
1893: -- copy data to the local IN or IN-OUT args, if any

Line 1899: okl_lpo_pvt_w.rosetta_table_copy_in_p2(ddp_lpov_tbl, p5_a0

1895:
1896:
1897:
1898:
1899: okl_lpo_pvt_w.rosetta_table_copy_in_p2(ddp_lpov_tbl, p5_a0
1900: , p5_a1
1901: , p5_a2
1902: , p5_a3
1903: , p5_a4

Line 1950: okl_lpo_pvt.update_row(p_api_version,

1946: );
1947:
1948:
1949: -- here's the delegated call to the old PL/SQL routine
1950: okl_lpo_pvt.update_row(p_api_version,
1951: p_init_msg_list,
1952: x_return_status,
1953: x_msg_count,
1954: x_msg_data,

Line 1965: okl_lpo_pvt_w.rosetta_table_copy_out_p2(ddx_lpov_tbl, p6_a0

1961:
1962:
1963:
1964:
1965: okl_lpo_pvt_w.rosetta_table_copy_out_p2(ddx_lpov_tbl, p6_a0
1966: , p6_a1
1967: , p6_a2
1968: , p6_a3
1969: , p6_a4

Line 2070: ddp_lpov_rec okl_lpo_pvt.lpov_rec_type;

2066: , p5_a46 VARCHAR2 := okl_api.g_miss_char
2067: )
2068:
2069: as
2070: ddp_lpov_rec okl_lpo_pvt.lpov_rec_type;
2071: ddindx binary_integer; indx binary_integer;
2072: begin
2073:
2074: -- copy data to the local IN or IN-OUT args, if any

Line 2129: okl_lpo_pvt.delete_row(p_api_version,

2125: ddp_lpov_rec.last_update_login := rosetta_g_miss_num_map(p5_a45);
2126: ddp_lpov_rec.days_in_year := p5_a46;
2127:
2128: -- here's the delegated call to the old PL/SQL routine
2129: okl_lpo_pvt.delete_row(p_api_version,
2130: p_init_msg_list,
2131: x_return_status,
2132: x_msg_count,
2133: x_msg_data,

Line 2199: ddp_lpov_tbl okl_lpo_pvt.lpov_tbl_type;

2195: , p5_a46 JTF_VARCHAR2_TABLE_100
2196: )
2197:
2198: as
2199: ddp_lpov_tbl okl_lpo_pvt.lpov_tbl_type;
2200: ddindx binary_integer; indx binary_integer;
2201: begin
2202:
2203: -- copy data to the local IN or IN-OUT args, if any

Line 2209: okl_lpo_pvt_w.rosetta_table_copy_in_p2(ddp_lpov_tbl, p5_a0

2205:
2206:
2207:
2208:
2209: okl_lpo_pvt_w.rosetta_table_copy_in_p2(ddp_lpov_tbl, p5_a0
2210: , p5_a1
2211: , p5_a2
2212: , p5_a3
2213: , p5_a4

Line 2259: okl_lpo_pvt.delete_row(p_api_version,

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

Line 2329: ddp_lpov_rec okl_lpo_pvt.lpov_rec_type;

2325: , p5_a46 VARCHAR2 := okl_api.g_miss_char
2326: )
2327:
2328: as
2329: ddp_lpov_rec okl_lpo_pvt.lpov_rec_type;
2330: ddindx binary_integer; indx binary_integer;
2331: begin
2332:
2333: -- copy data to the local IN or IN-OUT args, if any

Line 2388: okl_lpo_pvt.validate_row(p_api_version,

2384: ddp_lpov_rec.last_update_login := rosetta_g_miss_num_map(p5_a45);
2385: ddp_lpov_rec.days_in_year := p5_a46;
2386:
2387: -- here's the delegated call to the old PL/SQL routine
2388: okl_lpo_pvt.validate_row(p_api_version,
2389: p_init_msg_list,
2390: x_return_status,
2391: x_msg_count,
2392: x_msg_data,

Line 2458: ddp_lpov_tbl okl_lpo_pvt.lpov_tbl_type;

2454: , p5_a46 JTF_VARCHAR2_TABLE_100
2455: )
2456:
2457: as
2458: ddp_lpov_tbl okl_lpo_pvt.lpov_tbl_type;
2459: ddindx binary_integer; indx binary_integer;
2460: begin
2461:
2462: -- copy data to the local IN or IN-OUT args, if any

Line 2468: okl_lpo_pvt_w.rosetta_table_copy_in_p2(ddp_lpov_tbl, p5_a0

2464:
2465:
2466:
2467:
2468: okl_lpo_pvt_w.rosetta_table_copy_in_p2(ddp_lpov_tbl, p5_a0
2469: , p5_a1
2470: , p5_a2
2471: , p5_a3
2472: , p5_a4

Line 2518: okl_lpo_pvt.validate_row(p_api_version,

2514: , p5_a46
2515: );
2516:
2517: -- here's the delegated call to the old PL/SQL routine
2518: okl_lpo_pvt.validate_row(p_api_version,
2519: p_init_msg_list,
2520: x_return_status,
2521: x_msg_count,
2522: x_msg_data,

Line 2533: end okl_lpo_pvt_w;

2529:
2530:
2531: end;
2532:
2533: end okl_lpo_pvt_w;