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_PFL_PVT_W dependencies on OKL_PFL_PVT

Line 1: package body okl_pfl_pvt_w as

1: package body okl_pfl_pvt_w as
2: /* $Header: OKLIPFLB.pls 115.1 2002/12/19 23:26:20 gkadarka 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_pfl_pvt.pflv_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_pfl_pvt.pflv_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_300
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_DATE_TABLE
26: , a4 JTF_DATE_TABLE

Line 127: procedure rosetta_table_copy_out_p2(t okl_pfl_pvt.pflv_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_pfl_pvt.pflv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
128: , a1 out nocopy JTF_VARCHAR2_TABLE_300
129: , a2 out nocopy JTF_NUMBER_TABLE
130: , a3 out nocopy JTF_DATE_TABLE
131: , a4 out nocopy JTF_DATE_TABLE

Line 366: procedure rosetta_table_copy_in_p5(t out nocopy okl_pfl_pvt.pfl_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_pfl_pvt.pfl_tbl_type, a0 JTF_NUMBER_TABLE
367: , a1 JTF_NUMBER_TABLE
368: , a2 JTF_DATE_TABLE
369: , a3 JTF_DATE_TABLE
370: , a4 JTF_DATE_TABLE

Line 467: procedure rosetta_table_copy_out_p5(t okl_pfl_pvt.pfl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

463: end loop;
464: end if;
465: end if;
466: end rosetta_table_copy_in_p5;
467: procedure rosetta_table_copy_out_p5(t okl_pfl_pvt.pfl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
468: , a1 out nocopy JTF_NUMBER_TABLE
469: , a2 out nocopy JTF_DATE_TABLE
470: , a3 out nocopy JTF_DATE_TABLE
471: , a4 out nocopy JTF_DATE_TABLE

Line 696: procedure rosetta_table_copy_in_p8(t out nocopy okl_pfl_pvt.okl_prtfl_lines_tl_tbl_type, a0 JTF_NUMBER_TABLE

692: end if;
693: end if;
694: end rosetta_table_copy_out_p5;
695:
696: procedure rosetta_table_copy_in_p8(t out nocopy okl_pfl_pvt.okl_prtfl_lines_tl_tbl_type, a0 JTF_NUMBER_TABLE
697: , a1 JTF_VARCHAR2_TABLE_300
698: , a2 JTF_VARCHAR2_TABLE_300
699: , a3 JTF_VARCHAR2_TABLE_300
700: , a4 JTF_VARCHAR2_TABLE_2000

Line 733: procedure rosetta_table_copy_out_p8(t okl_pfl_pvt.okl_prtfl_lines_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

729: end loop;
730: end if;
731: end if;
732: end rosetta_table_copy_in_p8;
733: procedure rosetta_table_copy_out_p8(t okl_pfl_pvt.okl_prtfl_lines_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
734: , a1 out nocopy JTF_VARCHAR2_TABLE_300
735: , a2 out nocopy JTF_VARCHAR2_TABLE_300
736: , a3 out nocopy JTF_VARCHAR2_TABLE_300
737: , a4 out nocopy JTF_VARCHAR2_TABLE_2000

Line 898: ddp_pflv_rec okl_pfl_pvt.pflv_rec_type;

894: , p5_a43 DATE := fnd_api.g_miss_date
895: )
896:
897: as
898: ddp_pflv_rec okl_pfl_pvt.pflv_rec_type;
899: ddx_pflv_rec okl_pfl_pvt.pflv_rec_type;
900: ddindx binary_integer; indx binary_integer;
901: begin
902:

Line 899: ddx_pflv_rec okl_pfl_pvt.pflv_rec_type;

895: )
896:
897: as
898: ddp_pflv_rec okl_pfl_pvt.pflv_rec_type;
899: ddx_pflv_rec okl_pfl_pvt.pflv_rec_type;
900: ddindx binary_integer; indx binary_integer;
901: begin
902:
903: -- copy data to the local IN or IN-OUT args, if any

Line 956: okl_pfl_pvt.insert_row(p_api_version,

952: ddp_pflv_rec.currency_conversion_date := rosetta_g_miss_date_in_map(p5_a43);
953:
954:
955: -- here's the delegated call to the old PL/SQL routine
956: okl_pfl_pvt.insert_row(p_api_version,
957: p_init_msg_list,
958: x_return_status,
959: x_msg_count,
960: x_msg_data,

Line 1113: ddp_pflv_tbl okl_pfl_pvt.pflv_tbl_type;

1109: , p6_a43 out nocopy JTF_DATE_TABLE
1110: )
1111:
1112: as
1113: ddp_pflv_tbl okl_pfl_pvt.pflv_tbl_type;
1114: ddx_pflv_tbl okl_pfl_pvt.pflv_tbl_type;
1115: ddindx binary_integer; indx binary_integer;
1116: begin
1117:

Line 1114: ddx_pflv_tbl okl_pfl_pvt.pflv_tbl_type;

1110: )
1111:
1112: as
1113: ddp_pflv_tbl okl_pfl_pvt.pflv_tbl_type;
1114: ddx_pflv_tbl okl_pfl_pvt.pflv_tbl_type;
1115: ddindx binary_integer; indx binary_integer;
1116: begin
1117:
1118: -- copy data to the local IN or IN-OUT args, if any

Line 1124: okl_pfl_pvt_w.rosetta_table_copy_in_p2(ddp_pflv_tbl, p5_a0

1120:
1121:
1122:
1123:
1124: okl_pfl_pvt_w.rosetta_table_copy_in_p2(ddp_pflv_tbl, p5_a0
1125: , p5_a1
1126: , p5_a2
1127: , p5_a3
1128: , p5_a4

Line 1172: okl_pfl_pvt.insert_row(p_api_version,

1168: );
1169:
1170:
1171: -- here's the delegated call to the old PL/SQL routine
1172: okl_pfl_pvt.insert_row(p_api_version,
1173: p_init_msg_list,
1174: x_return_status,
1175: x_msg_count,
1176: x_msg_data,

Line 1187: okl_pfl_pvt_w.rosetta_table_copy_out_p2(ddx_pflv_tbl, p6_a0

1183:
1184:
1185:
1186:
1187: okl_pfl_pvt_w.rosetta_table_copy_out_p2(ddx_pflv_tbl, p6_a0
1188: , p6_a1
1189: , p6_a2
1190: , p6_a3
1191: , p6_a4

Line 1286: ddp_pflv_rec okl_pfl_pvt.pflv_rec_type;

1282: , p5_a43 DATE := fnd_api.g_miss_date
1283: )
1284:
1285: as
1286: ddp_pflv_rec okl_pfl_pvt.pflv_rec_type;
1287: ddindx binary_integer; indx binary_integer;
1288: begin
1289:
1290: -- copy data to the local IN or IN-OUT args, if any

Line 1342: okl_pfl_pvt.lock_row(p_api_version,

1338: ddp_pflv_rec.currency_conversion_rate := rosetta_g_miss_num_map(p5_a42);
1339: ddp_pflv_rec.currency_conversion_date := rosetta_g_miss_date_in_map(p5_a43);
1340:
1341: -- here's the delegated call to the old PL/SQL routine
1342: okl_pfl_pvt.lock_row(p_api_version,
1343: p_init_msg_list,
1344: x_return_status,
1345: x_msg_count,
1346: x_msg_data,

Line 1409: ddp_pflv_tbl okl_pfl_pvt.pflv_tbl_type;

1405: , p5_a43 JTF_DATE_TABLE
1406: )
1407:
1408: as
1409: ddp_pflv_tbl okl_pfl_pvt.pflv_tbl_type;
1410: ddindx binary_integer; indx binary_integer;
1411: begin
1412:
1413: -- copy data to the local IN or IN-OUT args, if any

Line 1419: okl_pfl_pvt_w.rosetta_table_copy_in_p2(ddp_pflv_tbl, p5_a0

1415:
1416:
1417:
1418:
1419: okl_pfl_pvt_w.rosetta_table_copy_in_p2(ddp_pflv_tbl, p5_a0
1420: , p5_a1
1421: , p5_a2
1422: , p5_a3
1423: , p5_a4

Line 1466: okl_pfl_pvt.lock_row(p_api_version,

1462: , p5_a43
1463: );
1464:
1465: -- here's the delegated call to the old PL/SQL routine
1466: okl_pfl_pvt.lock_row(p_api_version,
1467: p_init_msg_list,
1468: x_return_status,
1469: x_msg_count,
1470: x_msg_data,

Line 1577: ddp_pflv_rec okl_pfl_pvt.pflv_rec_type;

1573: , p5_a43 DATE := fnd_api.g_miss_date
1574: )
1575:
1576: as
1577: ddp_pflv_rec okl_pfl_pvt.pflv_rec_type;
1578: ddx_pflv_rec okl_pfl_pvt.pflv_rec_type;
1579: ddindx binary_integer; indx binary_integer;
1580: begin
1581:

Line 1578: ddx_pflv_rec okl_pfl_pvt.pflv_rec_type;

1574: )
1575:
1576: as
1577: ddp_pflv_rec okl_pfl_pvt.pflv_rec_type;
1578: ddx_pflv_rec okl_pfl_pvt.pflv_rec_type;
1579: ddindx binary_integer; indx binary_integer;
1580: begin
1581:
1582: -- copy data to the local IN or IN-OUT args, if any

Line 1635: okl_pfl_pvt.update_row(p_api_version,

1631: ddp_pflv_rec.currency_conversion_date := rosetta_g_miss_date_in_map(p5_a43);
1632:
1633:
1634: -- here's the delegated call to the old PL/SQL routine
1635: okl_pfl_pvt.update_row(p_api_version,
1636: p_init_msg_list,
1637: x_return_status,
1638: x_msg_count,
1639: x_msg_data,

Line 1792: ddp_pflv_tbl okl_pfl_pvt.pflv_tbl_type;

1788: , p6_a43 out nocopy JTF_DATE_TABLE
1789: )
1790:
1791: as
1792: ddp_pflv_tbl okl_pfl_pvt.pflv_tbl_type;
1793: ddx_pflv_tbl okl_pfl_pvt.pflv_tbl_type;
1794: ddindx binary_integer; indx binary_integer;
1795: begin
1796:

Line 1793: ddx_pflv_tbl okl_pfl_pvt.pflv_tbl_type;

1789: )
1790:
1791: as
1792: ddp_pflv_tbl okl_pfl_pvt.pflv_tbl_type;
1793: ddx_pflv_tbl okl_pfl_pvt.pflv_tbl_type;
1794: ddindx binary_integer; indx binary_integer;
1795: begin
1796:
1797: -- copy data to the local IN or IN-OUT args, if any

Line 1803: okl_pfl_pvt_w.rosetta_table_copy_in_p2(ddp_pflv_tbl, p5_a0

1799:
1800:
1801:
1802:
1803: okl_pfl_pvt_w.rosetta_table_copy_in_p2(ddp_pflv_tbl, p5_a0
1804: , p5_a1
1805: , p5_a2
1806: , p5_a3
1807: , p5_a4

Line 1851: okl_pfl_pvt.update_row(p_api_version,

1847: );
1848:
1849:
1850: -- here's the delegated call to the old PL/SQL routine
1851: okl_pfl_pvt.update_row(p_api_version,
1852: p_init_msg_list,
1853: x_return_status,
1854: x_msg_count,
1855: x_msg_data,

Line 1866: okl_pfl_pvt_w.rosetta_table_copy_out_p2(ddx_pflv_tbl, p6_a0

1862:
1863:
1864:
1865:
1866: okl_pfl_pvt_w.rosetta_table_copy_out_p2(ddx_pflv_tbl, p6_a0
1867: , p6_a1
1868: , p6_a2
1869: , p6_a3
1870: , p6_a4

Line 1965: ddp_pflv_rec okl_pfl_pvt.pflv_rec_type;

1961: , p5_a43 DATE := fnd_api.g_miss_date
1962: )
1963:
1964: as
1965: ddp_pflv_rec okl_pfl_pvt.pflv_rec_type;
1966: ddindx binary_integer; indx binary_integer;
1967: begin
1968:
1969: -- copy data to the local IN or IN-OUT args, if any

Line 2021: okl_pfl_pvt.delete_row(p_api_version,

2017: ddp_pflv_rec.currency_conversion_rate := rosetta_g_miss_num_map(p5_a42);
2018: ddp_pflv_rec.currency_conversion_date := rosetta_g_miss_date_in_map(p5_a43);
2019:
2020: -- here's the delegated call to the old PL/SQL routine
2021: okl_pfl_pvt.delete_row(p_api_version,
2022: p_init_msg_list,
2023: x_return_status,
2024: x_msg_count,
2025: x_msg_data,

Line 2088: ddp_pflv_tbl okl_pfl_pvt.pflv_tbl_type;

2084: , p5_a43 JTF_DATE_TABLE
2085: )
2086:
2087: as
2088: ddp_pflv_tbl okl_pfl_pvt.pflv_tbl_type;
2089: ddindx binary_integer; indx binary_integer;
2090: begin
2091:
2092: -- copy data to the local IN or IN-OUT args, if any

Line 2098: okl_pfl_pvt_w.rosetta_table_copy_in_p2(ddp_pflv_tbl, p5_a0

2094:
2095:
2096:
2097:
2098: okl_pfl_pvt_w.rosetta_table_copy_in_p2(ddp_pflv_tbl, p5_a0
2099: , p5_a1
2100: , p5_a2
2101: , p5_a3
2102: , p5_a4

Line 2145: okl_pfl_pvt.delete_row(p_api_version,

2141: , p5_a43
2142: );
2143:
2144: -- here's the delegated call to the old PL/SQL routine
2145: okl_pfl_pvt.delete_row(p_api_version,
2146: p_init_msg_list,
2147: x_return_status,
2148: x_msg_count,
2149: x_msg_data,

Line 2212: ddp_pflv_rec okl_pfl_pvt.pflv_rec_type;

2208: , p5_a43 DATE := fnd_api.g_miss_date
2209: )
2210:
2211: as
2212: ddp_pflv_rec okl_pfl_pvt.pflv_rec_type;
2213: ddindx binary_integer; indx binary_integer;
2214: begin
2215:
2216: -- copy data to the local IN or IN-OUT args, if any

Line 2268: okl_pfl_pvt.validate_row(p_api_version,

2264: ddp_pflv_rec.currency_conversion_rate := rosetta_g_miss_num_map(p5_a42);
2265: ddp_pflv_rec.currency_conversion_date := rosetta_g_miss_date_in_map(p5_a43);
2266:
2267: -- here's the delegated call to the old PL/SQL routine
2268: okl_pfl_pvt.validate_row(p_api_version,
2269: p_init_msg_list,
2270: x_return_status,
2271: x_msg_count,
2272: x_msg_data,

Line 2335: ddp_pflv_tbl okl_pfl_pvt.pflv_tbl_type;

2331: , p5_a43 JTF_DATE_TABLE
2332: )
2333:
2334: as
2335: ddp_pflv_tbl okl_pfl_pvt.pflv_tbl_type;
2336: ddindx binary_integer; indx binary_integer;
2337: begin
2338:
2339: -- copy data to the local IN or IN-OUT args, if any

Line 2345: okl_pfl_pvt_w.rosetta_table_copy_in_p2(ddp_pflv_tbl, p5_a0

2341:
2342:
2343:
2344:
2345: okl_pfl_pvt_w.rosetta_table_copy_in_p2(ddp_pflv_tbl, p5_a0
2346: , p5_a1
2347: , p5_a2
2348: , p5_a3
2349: , p5_a4

Line 2392: okl_pfl_pvt.validate_row(p_api_version,

2388: , p5_a43
2389: );
2390:
2391: -- here's the delegated call to the old PL/SQL routine
2392: okl_pfl_pvt.validate_row(p_api_version,
2393: p_init_msg_list,
2394: x_return_status,
2395: x_msg_count,
2396: x_msg_data,

Line 2407: end okl_pfl_pvt_w;

2403:
2404:
2405: end;
2406:
2407: end okl_pfl_pvt_w;