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_PFC_PVT_W dependencies on OKL_PFC_PVT

Line 1: package body okl_pfc_pvt_w as

1: package body okl_pfc_pvt_w as
2: /* $Header: OKLIPFCB.pls 115.1 2002/12/19 23:25:40 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_pfc_pvt.pfcv_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_pfc_pvt.pfcv_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_300
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_NUMBER_TABLE

Line 103: procedure rosetta_table_copy_out_p2(t okl_pfc_pvt.pfcv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

99: end loop;
100: end if;
101: end if;
102: end rosetta_table_copy_in_p2;
103: procedure rosetta_table_copy_out_p2(t okl_pfc_pvt.pfcv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
104: , a1 out nocopy JTF_NUMBER_TABLE
105: , a2 out nocopy JTF_VARCHAR2_TABLE_300
106: , a3 out nocopy JTF_VARCHAR2_TABLE_100
107: , a4 out nocopy JTF_NUMBER_TABLE

Line 282: procedure rosetta_table_copy_in_p5(t out nocopy okl_pfc_pvt.pfc_tbl_type, a0 JTF_NUMBER_TABLE

278: end if;
279: end if;
280: end rosetta_table_copy_out_p2;
281:
282: procedure rosetta_table_copy_in_p5(t out nocopy okl_pfc_pvt.pfc_tbl_type, a0 JTF_NUMBER_TABLE
283: , a1 JTF_VARCHAR2_TABLE_100
284: , a2 JTF_NUMBER_TABLE
285: , a3 JTF_NUMBER_TABLE
286: , a4 JTF_NUMBER_TABLE

Line 357: procedure rosetta_table_copy_out_p5(t okl_pfc_pvt.pfc_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

353: end loop;
354: end if;
355: end if;
356: end rosetta_table_copy_in_p5;
357: procedure rosetta_table_copy_out_p5(t okl_pfc_pvt.pfc_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
358: , a1 out nocopy JTF_VARCHAR2_TABLE_100
359: , a2 out nocopy JTF_NUMBER_TABLE
360: , a3 out nocopy JTF_NUMBER_TABLE
361: , a4 out nocopy JTF_NUMBER_TABLE

Line 521: procedure rosetta_table_copy_in_p8(t out nocopy okl_pfc_pvt.okl_prtfl_cntrcts_tl_tbl_type, a0 JTF_NUMBER_TABLE

517: end if;
518: end if;
519: end rosetta_table_copy_out_p5;
520:
521: procedure rosetta_table_copy_in_p8(t out nocopy okl_pfc_pvt.okl_prtfl_cntrcts_tl_tbl_type, a0 JTF_NUMBER_TABLE
522: , a1 JTF_VARCHAR2_TABLE_300
523: , a2 JTF_VARCHAR2_TABLE_300
524: , a3 JTF_VARCHAR2_TABLE_300
525: , a4 JTF_VARCHAR2_TABLE_200

Line 560: procedure rosetta_table_copy_out_p8(t okl_pfc_pvt.okl_prtfl_cntrcts_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

556: end loop;
557: end if;
558: end if;
559: end rosetta_table_copy_in_p8;
560: procedure rosetta_table_copy_out_p8(t okl_pfc_pvt.okl_prtfl_cntrcts_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
561: , a1 out nocopy JTF_VARCHAR2_TABLE_300
562: , a2 out nocopy JTF_VARCHAR2_TABLE_300
563: , a3 out nocopy JTF_VARCHAR2_TABLE_300
564: , a4 out nocopy JTF_VARCHAR2_TABLE_200

Line 706: ddp_pfcv_rec okl_pfc_pvt.pfcv_rec_type;

702: , p5_a31 NUMBER := 0-1962.0724
703: )
704:
705: as
706: ddp_pfcv_rec okl_pfc_pvt.pfcv_rec_type;
707: ddx_pfcv_rec okl_pfc_pvt.pfcv_rec_type;
708: ddindx binary_integer; indx binary_integer;
709: begin
710:

Line 707: ddx_pfcv_rec okl_pfc_pvt.pfcv_rec_type;

703: )
704:
705: as
706: ddp_pfcv_rec okl_pfc_pvt.pfcv_rec_type;
707: ddx_pfcv_rec okl_pfc_pvt.pfcv_rec_type;
708: ddindx binary_integer; indx binary_integer;
709: begin
710:
711: -- copy data to the local IN or IN-OUT args, if any

Line 752: okl_pfc_pvt.insert_row(p_api_version,

748: ddp_pfcv_rec.last_update_login := rosetta_g_miss_num_map(p5_a31);
749:
750:
751: -- here's the delegated call to the old PL/SQL routine
752: okl_pfc_pvt.insert_row(p_api_version,
753: p_init_msg_list,
754: x_return_status,
755: x_msg_count,
756: x_msg_data,

Line 873: ddp_pfcv_tbl okl_pfc_pvt.pfcv_tbl_type;

869: , p6_a31 out nocopy JTF_NUMBER_TABLE
870: )
871:
872: as
873: ddp_pfcv_tbl okl_pfc_pvt.pfcv_tbl_type;
874: ddx_pfcv_tbl okl_pfc_pvt.pfcv_tbl_type;
875: ddindx binary_integer; indx binary_integer;
876: begin
877:

Line 874: ddx_pfcv_tbl okl_pfc_pvt.pfcv_tbl_type;

870: )
871:
872: as
873: ddp_pfcv_tbl okl_pfc_pvt.pfcv_tbl_type;
874: ddx_pfcv_tbl okl_pfc_pvt.pfcv_tbl_type;
875: ddindx binary_integer; indx binary_integer;
876: begin
877:
878: -- copy data to the local IN or IN-OUT args, if any

Line 884: okl_pfc_pvt_w.rosetta_table_copy_in_p2(ddp_pfcv_tbl, p5_a0

880:
881:
882:
883:
884: okl_pfc_pvt_w.rosetta_table_copy_in_p2(ddp_pfcv_tbl, p5_a0
885: , p5_a1
886: , p5_a2
887: , p5_a3
888: , p5_a4

Line 920: okl_pfc_pvt.insert_row(p_api_version,

916: );
917:
918:
919: -- here's the delegated call to the old PL/SQL routine
920: okl_pfc_pvt.insert_row(p_api_version,
921: p_init_msg_list,
922: x_return_status,
923: x_msg_count,
924: x_msg_data,

Line 935: okl_pfc_pvt_w.rosetta_table_copy_out_p2(ddx_pfcv_tbl, p6_a0

931:
932:
933:
934:
935: okl_pfc_pvt_w.rosetta_table_copy_out_p2(ddx_pfcv_tbl, p6_a0
936: , p6_a1
937: , p6_a2
938: , p6_a3
939: , p6_a4

Line 1010: ddp_pfcv_rec okl_pfc_pvt.pfcv_rec_type;

1006: , p5_a31 NUMBER := 0-1962.0724
1007: )
1008:
1009: as
1010: ddp_pfcv_rec okl_pfc_pvt.pfcv_rec_type;
1011: ddindx binary_integer; indx binary_integer;
1012: begin
1013:
1014: -- copy data to the local IN or IN-OUT args, if any

Line 1054: okl_pfc_pvt.lock_row(p_api_version,

1050: ddp_pfcv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a30);
1051: ddp_pfcv_rec.last_update_login := rosetta_g_miss_num_map(p5_a31);
1052:
1053: -- here's the delegated call to the old PL/SQL routine
1054: okl_pfc_pvt.lock_row(p_api_version,
1055: p_init_msg_list,
1056: x_return_status,
1057: x_msg_count,
1058: x_msg_data,

Line 1109: ddp_pfcv_tbl okl_pfc_pvt.pfcv_tbl_type;

1105: , p5_a31 JTF_NUMBER_TABLE
1106: )
1107:
1108: as
1109: ddp_pfcv_tbl okl_pfc_pvt.pfcv_tbl_type;
1110: ddindx binary_integer; indx binary_integer;
1111: begin
1112:
1113: -- copy data to the local IN or IN-OUT args, if any

Line 1119: okl_pfc_pvt_w.rosetta_table_copy_in_p2(ddp_pfcv_tbl, p5_a0

1115:
1116:
1117:
1118:
1119: okl_pfc_pvt_w.rosetta_table_copy_in_p2(ddp_pfcv_tbl, p5_a0
1120: , p5_a1
1121: , p5_a2
1122: , p5_a3
1123: , p5_a4

Line 1154: okl_pfc_pvt.lock_row(p_api_version,

1150: , p5_a31
1151: );
1152:
1153: -- here's the delegated call to the old PL/SQL routine
1154: okl_pfc_pvt.lock_row(p_api_version,
1155: p_init_msg_list,
1156: x_return_status,
1157: x_msg_count,
1158: x_msg_data,

Line 1241: ddp_pfcv_rec okl_pfc_pvt.pfcv_rec_type;

1237: , p5_a31 NUMBER := 0-1962.0724
1238: )
1239:
1240: as
1241: ddp_pfcv_rec okl_pfc_pvt.pfcv_rec_type;
1242: ddx_pfcv_rec okl_pfc_pvt.pfcv_rec_type;
1243: ddindx binary_integer; indx binary_integer;
1244: begin
1245:

Line 1242: ddx_pfcv_rec okl_pfc_pvt.pfcv_rec_type;

1238: )
1239:
1240: as
1241: ddp_pfcv_rec okl_pfc_pvt.pfcv_rec_type;
1242: ddx_pfcv_rec okl_pfc_pvt.pfcv_rec_type;
1243: ddindx binary_integer; indx binary_integer;
1244: begin
1245:
1246: -- copy data to the local IN or IN-OUT args, if any

Line 1287: okl_pfc_pvt.update_row(p_api_version,

1283: ddp_pfcv_rec.last_update_login := rosetta_g_miss_num_map(p5_a31);
1284:
1285:
1286: -- here's the delegated call to the old PL/SQL routine
1287: okl_pfc_pvt.update_row(p_api_version,
1288: p_init_msg_list,
1289: x_return_status,
1290: x_msg_count,
1291: x_msg_data,

Line 1408: ddp_pfcv_tbl okl_pfc_pvt.pfcv_tbl_type;

1404: , p6_a31 out nocopy JTF_NUMBER_TABLE
1405: )
1406:
1407: as
1408: ddp_pfcv_tbl okl_pfc_pvt.pfcv_tbl_type;
1409: ddx_pfcv_tbl okl_pfc_pvt.pfcv_tbl_type;
1410: ddindx binary_integer; indx binary_integer;
1411: begin
1412:

Line 1409: ddx_pfcv_tbl okl_pfc_pvt.pfcv_tbl_type;

1405: )
1406:
1407: as
1408: ddp_pfcv_tbl okl_pfc_pvt.pfcv_tbl_type;
1409: ddx_pfcv_tbl okl_pfc_pvt.pfcv_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_pfc_pvt_w.rosetta_table_copy_in_p2(ddp_pfcv_tbl, p5_a0

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

Line 1455: okl_pfc_pvt.update_row(p_api_version,

1451: );
1452:
1453:
1454: -- here's the delegated call to the old PL/SQL routine
1455: okl_pfc_pvt.update_row(p_api_version,
1456: p_init_msg_list,
1457: x_return_status,
1458: x_msg_count,
1459: x_msg_data,

Line 1470: okl_pfc_pvt_w.rosetta_table_copy_out_p2(ddx_pfcv_tbl, p6_a0

1466:
1467:
1468:
1469:
1470: okl_pfc_pvt_w.rosetta_table_copy_out_p2(ddx_pfcv_tbl, p6_a0
1471: , p6_a1
1472: , p6_a2
1473: , p6_a3
1474: , p6_a4

Line 1545: ddp_pfcv_rec okl_pfc_pvt.pfcv_rec_type;

1541: , p5_a31 NUMBER := 0-1962.0724
1542: )
1543:
1544: as
1545: ddp_pfcv_rec okl_pfc_pvt.pfcv_rec_type;
1546: ddindx binary_integer; indx binary_integer;
1547: begin
1548:
1549: -- copy data to the local IN or IN-OUT args, if any

Line 1589: okl_pfc_pvt.delete_row(p_api_version,

1585: ddp_pfcv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a30);
1586: ddp_pfcv_rec.last_update_login := rosetta_g_miss_num_map(p5_a31);
1587:
1588: -- here's the delegated call to the old PL/SQL routine
1589: okl_pfc_pvt.delete_row(p_api_version,
1590: p_init_msg_list,
1591: x_return_status,
1592: x_msg_count,
1593: x_msg_data,

Line 1644: ddp_pfcv_tbl okl_pfc_pvt.pfcv_tbl_type;

1640: , p5_a31 JTF_NUMBER_TABLE
1641: )
1642:
1643: as
1644: ddp_pfcv_tbl okl_pfc_pvt.pfcv_tbl_type;
1645: ddindx binary_integer; indx binary_integer;
1646: begin
1647:
1648: -- copy data to the local IN or IN-OUT args, if any

Line 1654: okl_pfc_pvt_w.rosetta_table_copy_in_p2(ddp_pfcv_tbl, p5_a0

1650:
1651:
1652:
1653:
1654: okl_pfc_pvt_w.rosetta_table_copy_in_p2(ddp_pfcv_tbl, p5_a0
1655: , p5_a1
1656: , p5_a2
1657: , p5_a3
1658: , p5_a4

Line 1689: okl_pfc_pvt.delete_row(p_api_version,

1685: , p5_a31
1686: );
1687:
1688: -- here's the delegated call to the old PL/SQL routine
1689: okl_pfc_pvt.delete_row(p_api_version,
1690: p_init_msg_list,
1691: x_return_status,
1692: x_msg_count,
1693: x_msg_data,

Line 1744: ddp_pfcv_rec okl_pfc_pvt.pfcv_rec_type;

1740: , p5_a31 NUMBER := 0-1962.0724
1741: )
1742:
1743: as
1744: ddp_pfcv_rec okl_pfc_pvt.pfcv_rec_type;
1745: ddindx binary_integer; indx binary_integer;
1746: begin
1747:
1748: -- copy data to the local IN or IN-OUT args, if any

Line 1788: okl_pfc_pvt.validate_row(p_api_version,

1784: ddp_pfcv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a30);
1785: ddp_pfcv_rec.last_update_login := rosetta_g_miss_num_map(p5_a31);
1786:
1787: -- here's the delegated call to the old PL/SQL routine
1788: okl_pfc_pvt.validate_row(p_api_version,
1789: p_init_msg_list,
1790: x_return_status,
1791: x_msg_count,
1792: x_msg_data,

Line 1843: ddp_pfcv_tbl okl_pfc_pvt.pfcv_tbl_type;

1839: , p5_a31 JTF_NUMBER_TABLE
1840: )
1841:
1842: as
1843: ddp_pfcv_tbl okl_pfc_pvt.pfcv_tbl_type;
1844: ddindx binary_integer; indx binary_integer;
1845: begin
1846:
1847: -- copy data to the local IN or IN-OUT args, if any

Line 1853: okl_pfc_pvt_w.rosetta_table_copy_in_p2(ddp_pfcv_tbl, p5_a0

1849:
1850:
1851:
1852:
1853: okl_pfc_pvt_w.rosetta_table_copy_in_p2(ddp_pfcv_tbl, p5_a0
1854: , p5_a1
1855: , p5_a2
1856: , p5_a3
1857: , p5_a4

Line 1888: okl_pfc_pvt.validate_row(p_api_version,

1884: , p5_a31
1885: );
1886:
1887: -- here's the delegated call to the old PL/SQL routine
1888: okl_pfc_pvt.validate_row(p_api_version,
1889: p_init_msg_list,
1890: x_return_status,
1891: x_msg_count,
1892: x_msg_data,

Line 1903: end okl_pfc_pvt_w;

1899:
1900:
1901: end;
1902:
1903: end okl_pfc_pvt_w;