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_POX_PVT_W dependencies on OKL_POX_PVT

Line 1: package body okl_pox_pvt_w as

1: package body okl_pox_pvt_w as
2: /* $Header: OKLIPOXB.pls 120.4 2006/11/20 06:48:39 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_pox_pvt.poxv_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_pox_pvt.poxv_tbl_type, a0 JTF_NUMBER_TABLE
26: , a1 JTF_NUMBER_TABLE
27: , a2 JTF_NUMBER_TABLE
28: , a3 JTF_NUMBER_TABLE
29: , a4 JTF_DATE_TABLE

Line 120: procedure rosetta_table_copy_out_p2(t okl_pox_pvt.poxv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

116: end loop;
117: end if;
118: end if;
119: end rosetta_table_copy_in_p2;
120: procedure rosetta_table_copy_out_p2(t okl_pox_pvt.poxv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
121: , a1 out nocopy JTF_NUMBER_TABLE
122: , a2 out nocopy JTF_NUMBER_TABLE
123: , a3 out nocopy JTF_NUMBER_TABLE
124: , a4 out nocopy JTF_DATE_TABLE

Line 334: procedure rosetta_table_copy_in_p5(t out nocopy okl_pox_pvt.pox_tbl_type, a0 JTF_NUMBER_TABLE

330: end if;
331: end if;
332: end rosetta_table_copy_out_p2;
333:
334: procedure rosetta_table_copy_in_p5(t out nocopy okl_pox_pvt.pox_tbl_type, a0 JTF_NUMBER_TABLE
335: , a1 JTF_NUMBER_TABLE
336: , a2 JTF_NUMBER_TABLE
337: , a3 JTF_NUMBER_TABLE
338: , a4 JTF_DATE_TABLE

Line 429: procedure rosetta_table_copy_out_p5(t okl_pox_pvt.pox_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

425: end loop;
426: end if;
427: end if;
428: end rosetta_table_copy_in_p5;
429: procedure rosetta_table_copy_out_p5(t okl_pox_pvt.pox_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
430: , a1 out nocopy JTF_NUMBER_TABLE
431: , a2 out nocopy JTF_NUMBER_TABLE
432: , a3 out nocopy JTF_NUMBER_TABLE
433: , a4 out nocopy JTF_DATE_TABLE

Line 729: ddp_poxv_rec okl_pox_pvt.poxv_rec_type;

725: , p5_a38 NUMBER := 0-1962.0724
726: )
727:
728: as
729: ddp_poxv_rec okl_pox_pvt.poxv_rec_type;
730: ddx_poxv_rec okl_pox_pvt.poxv_rec_type;
731: ddindx binary_integer; indx binary_integer;
732: begin
733:

Line 730: ddx_poxv_rec okl_pox_pvt.poxv_rec_type;

726: )
727:
728: as
729: ddp_poxv_rec okl_pox_pvt.poxv_rec_type;
730: ddx_poxv_rec okl_pox_pvt.poxv_rec_type;
731: ddindx binary_integer; indx binary_integer;
732: begin
733:
734: -- copy data to the local IN or IN-OUT args, if any

Line 782: okl_pox_pvt.insert_row(p_api_version,

778: ddp_poxv_rec.legal_entity_id := rosetta_g_miss_num_map(p5_a38);
779:
780:
781: -- here's the delegated call to the old PL/SQL routine
782: okl_pox_pvt.insert_row(p_api_version,
783: p_init_msg_list,
784: x_return_status,
785: x_msg_count,
786: x_msg_data,

Line 924: ddp_poxv_tbl okl_pox_pvt.poxv_tbl_type;

920: , p6_a38 out nocopy JTF_NUMBER_TABLE
921: )
922:
923: as
924: ddp_poxv_tbl okl_pox_pvt.poxv_tbl_type;
925: ddx_poxv_tbl okl_pox_pvt.poxv_tbl_type;
926: ddindx binary_integer; indx binary_integer;
927: begin
928:

Line 925: ddx_poxv_tbl okl_pox_pvt.poxv_tbl_type;

921: )
922:
923: as
924: ddp_poxv_tbl okl_pox_pvt.poxv_tbl_type;
925: ddx_poxv_tbl okl_pox_pvt.poxv_tbl_type;
926: ddindx binary_integer; indx binary_integer;
927: begin
928:
929: -- copy data to the local IN or IN-OUT args, if any

Line 935: okl_pox_pvt_w.rosetta_table_copy_in_p2(ddp_poxv_tbl, p5_a0

931:
932:
933:
934:
935: okl_pox_pvt_w.rosetta_table_copy_in_p2(ddp_poxv_tbl, p5_a0
936: , p5_a1
937: , p5_a2
938: , p5_a3
939: , p5_a4

Line 978: okl_pox_pvt.insert_row(p_api_version,

974: );
975:
976:
977: -- here's the delegated call to the old PL/SQL routine
978: okl_pox_pvt.insert_row(p_api_version,
979: p_init_msg_list,
980: x_return_status,
981: x_msg_count,
982: x_msg_data,

Line 993: okl_pox_pvt_w.rosetta_table_copy_out_p2(ddx_poxv_tbl, p6_a0

989:
990:
991:
992:
993: okl_pox_pvt_w.rosetta_table_copy_out_p2(ddx_poxv_tbl, p6_a0
994: , p6_a1
995: , p6_a2
996: , p6_a3
997: , p6_a4

Line 1082: ddp_poxv_rec okl_pox_pvt.poxv_rec_type;

1078: , p5_a38 NUMBER := 0-1962.0724
1079: )
1080:
1081: as
1082: ddp_poxv_rec okl_pox_pvt.poxv_rec_type;
1083: ddindx binary_integer; indx binary_integer;
1084: begin
1085:
1086: -- copy data to the local IN or IN-OUT args, if any

Line 1133: okl_pox_pvt.lock_row(p_api_version,

1129: ddp_poxv_rec.last_update_login := rosetta_g_miss_num_map(p5_a37);
1130: ddp_poxv_rec.legal_entity_id := rosetta_g_miss_num_map(p5_a38);
1131:
1132: -- here's the delegated call to the old PL/SQL routine
1133: okl_pox_pvt.lock_row(p_api_version,
1134: p_init_msg_list,
1135: x_return_status,
1136: x_msg_count,
1137: x_msg_data,

Line 1195: ddp_poxv_tbl okl_pox_pvt.poxv_tbl_type;

1191: , p5_a38 JTF_NUMBER_TABLE
1192: )
1193:
1194: as
1195: ddp_poxv_tbl okl_pox_pvt.poxv_tbl_type;
1196: ddindx binary_integer; indx binary_integer;
1197: begin
1198:
1199: -- copy data to the local IN or IN-OUT args, if any

Line 1205: okl_pox_pvt_w.rosetta_table_copy_in_p2(ddp_poxv_tbl, p5_a0

1201:
1202:
1203:
1204:
1205: okl_pox_pvt_w.rosetta_table_copy_in_p2(ddp_poxv_tbl, p5_a0
1206: , p5_a1
1207: , p5_a2
1208: , p5_a3
1209: , p5_a4

Line 1247: okl_pox_pvt.lock_row(p_api_version,

1243: , p5_a38
1244: );
1245:
1246: -- here's the delegated call to the old PL/SQL routine
1247: okl_pox_pvt.lock_row(p_api_version,
1248: p_init_msg_list,
1249: x_return_status,
1250: x_msg_count,
1251: x_msg_data,

Line 1348: ddp_poxv_rec okl_pox_pvt.poxv_rec_type;

1344: , p5_a38 NUMBER := 0-1962.0724
1345: )
1346:
1347: as
1348: ddp_poxv_rec okl_pox_pvt.poxv_rec_type;
1349: ddx_poxv_rec okl_pox_pvt.poxv_rec_type;
1350: ddindx binary_integer; indx binary_integer;
1351: begin
1352:

Line 1349: ddx_poxv_rec okl_pox_pvt.poxv_rec_type;

1345: )
1346:
1347: as
1348: ddp_poxv_rec okl_pox_pvt.poxv_rec_type;
1349: ddx_poxv_rec okl_pox_pvt.poxv_rec_type;
1350: ddindx binary_integer; indx binary_integer;
1351: begin
1352:
1353: -- copy data to the local IN or IN-OUT args, if any

Line 1401: okl_pox_pvt.update_row(p_api_version,

1397: ddp_poxv_rec.legal_entity_id := rosetta_g_miss_num_map(p5_a38);
1398:
1399:
1400: -- here's the delegated call to the old PL/SQL routine
1401: okl_pox_pvt.update_row(p_api_version,
1402: p_init_msg_list,
1403: x_return_status,
1404: x_msg_count,
1405: x_msg_data,

Line 1543: ddp_poxv_tbl okl_pox_pvt.poxv_tbl_type;

1539: , p6_a38 out nocopy JTF_NUMBER_TABLE
1540: )
1541:
1542: as
1543: ddp_poxv_tbl okl_pox_pvt.poxv_tbl_type;
1544: ddx_poxv_tbl okl_pox_pvt.poxv_tbl_type;
1545: ddindx binary_integer; indx binary_integer;
1546: begin
1547:

Line 1544: ddx_poxv_tbl okl_pox_pvt.poxv_tbl_type;

1540: )
1541:
1542: as
1543: ddp_poxv_tbl okl_pox_pvt.poxv_tbl_type;
1544: ddx_poxv_tbl okl_pox_pvt.poxv_tbl_type;
1545: ddindx binary_integer; indx binary_integer;
1546: begin
1547:
1548: -- copy data to the local IN or IN-OUT args, if any

Line 1554: okl_pox_pvt_w.rosetta_table_copy_in_p2(ddp_poxv_tbl, p5_a0

1550:
1551:
1552:
1553:
1554: okl_pox_pvt_w.rosetta_table_copy_in_p2(ddp_poxv_tbl, p5_a0
1555: , p5_a1
1556: , p5_a2
1557: , p5_a3
1558: , p5_a4

Line 1597: okl_pox_pvt.update_row(p_api_version,

1593: );
1594:
1595:
1596: -- here's the delegated call to the old PL/SQL routine
1597: okl_pox_pvt.update_row(p_api_version,
1598: p_init_msg_list,
1599: x_return_status,
1600: x_msg_count,
1601: x_msg_data,

Line 1612: okl_pox_pvt_w.rosetta_table_copy_out_p2(ddx_poxv_tbl, p6_a0

1608:
1609:
1610:
1611:
1612: okl_pox_pvt_w.rosetta_table_copy_out_p2(ddx_poxv_tbl, p6_a0
1613: , p6_a1
1614: , p6_a2
1615: , p6_a3
1616: , p6_a4

Line 1701: ddp_poxv_rec okl_pox_pvt.poxv_rec_type;

1697: , p5_a38 NUMBER := 0-1962.0724
1698: )
1699:
1700: as
1701: ddp_poxv_rec okl_pox_pvt.poxv_rec_type;
1702: ddindx binary_integer; indx binary_integer;
1703: begin
1704:
1705: -- copy data to the local IN or IN-OUT args, if any

Line 1752: okl_pox_pvt.delete_row(p_api_version,

1748: ddp_poxv_rec.last_update_login := rosetta_g_miss_num_map(p5_a37);
1749: ddp_poxv_rec.legal_entity_id := rosetta_g_miss_num_map(p5_a38);
1750:
1751: -- here's the delegated call to the old PL/SQL routine
1752: okl_pox_pvt.delete_row(p_api_version,
1753: p_init_msg_list,
1754: x_return_status,
1755: x_msg_count,
1756: x_msg_data,

Line 1814: ddp_poxv_tbl okl_pox_pvt.poxv_tbl_type;

1810: , p5_a38 JTF_NUMBER_TABLE
1811: )
1812:
1813: as
1814: ddp_poxv_tbl okl_pox_pvt.poxv_tbl_type;
1815: ddindx binary_integer; indx binary_integer;
1816: begin
1817:
1818: -- copy data to the local IN or IN-OUT args, if any

Line 1824: okl_pox_pvt_w.rosetta_table_copy_in_p2(ddp_poxv_tbl, p5_a0

1820:
1821:
1822:
1823:
1824: okl_pox_pvt_w.rosetta_table_copy_in_p2(ddp_poxv_tbl, p5_a0
1825: , p5_a1
1826: , p5_a2
1827: , p5_a3
1828: , p5_a4

Line 1866: okl_pox_pvt.delete_row(p_api_version,

1862: , p5_a38
1863: );
1864:
1865: -- here's the delegated call to the old PL/SQL routine
1866: okl_pox_pvt.delete_row(p_api_version,
1867: p_init_msg_list,
1868: x_return_status,
1869: x_msg_count,
1870: x_msg_data,

Line 1928: ddp_poxv_rec okl_pox_pvt.poxv_rec_type;

1924: , p5_a38 NUMBER := 0-1962.0724
1925: )
1926:
1927: as
1928: ddp_poxv_rec okl_pox_pvt.poxv_rec_type;
1929: ddindx binary_integer; indx binary_integer;
1930: begin
1931:
1932: -- copy data to the local IN or IN-OUT args, if any

Line 1979: okl_pox_pvt.validate_row(p_api_version,

1975: ddp_poxv_rec.last_update_login := rosetta_g_miss_num_map(p5_a37);
1976: ddp_poxv_rec.legal_entity_id := rosetta_g_miss_num_map(p5_a38);
1977:
1978: -- here's the delegated call to the old PL/SQL routine
1979: okl_pox_pvt.validate_row(p_api_version,
1980: p_init_msg_list,
1981: x_return_status,
1982: x_msg_count,
1983: x_msg_data,

Line 2041: ddp_poxv_tbl okl_pox_pvt.poxv_tbl_type;

2037: , p5_a38 JTF_NUMBER_TABLE
2038: )
2039:
2040: as
2041: ddp_poxv_tbl okl_pox_pvt.poxv_tbl_type;
2042: ddindx binary_integer; indx binary_integer;
2043: begin
2044:
2045: -- copy data to the local IN or IN-OUT args, if any

Line 2051: okl_pox_pvt_w.rosetta_table_copy_in_p2(ddp_poxv_tbl, p5_a0

2047:
2048:
2049:
2050:
2051: okl_pox_pvt_w.rosetta_table_copy_in_p2(ddp_poxv_tbl, p5_a0
2052: , p5_a1
2053: , p5_a2
2054: , p5_a3
2055: , p5_a4

Line 2093: okl_pox_pvt.validate_row(p_api_version,

2089: , p5_a38
2090: );
2091:
2092: -- here's the delegated call to the old PL/SQL routine
2093: okl_pox_pvt.validate_row(p_api_version,
2094: p_init_msg_list,
2095: x_return_status,
2096: x_msg_count,
2097: x_msg_data,

Line 2108: end okl_pox_pvt_w;

2104:
2105:
2106: end;
2107:
2108: end okl_pox_pvt_w;