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_VRR_PVT_W dependencies on OKL_VRR_PVT

Line 1: package body okl_vrr_pvt_w as

1: package body okl_vrr_pvt_w as
2: /* $Header: OKLIVRRB.pls 120.0 2005/08/03 07:54:37 sjalasut noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_vrr_pvt.vrrv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p2(t out nocopy okl_vrr_pvt.vrrv_tbl_type, a0 JTF_NUMBER_TABLE

1: package body okl_vrr_pvt_w as
2: /* $Header: OKLIVRRB.pls 120.0 2005/08/03 07:54:37 sjalasut noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_vrr_pvt.vrrv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_400

Line 82: procedure rosetta_table_copy_out_p2(t okl_vrr_pvt.vrrv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

78: end loop;
79: end if;
80: end if;
81: end rosetta_table_copy_in_p2;
82: procedure rosetta_table_copy_out_p2(t okl_vrr_pvt.vrrv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
83: , a1 out nocopy JTF_NUMBER_TABLE
84: , a2 out nocopy JTF_NUMBER_TABLE
85: , a3 out nocopy JTF_VARCHAR2_TABLE_100
86: , a4 out nocopy JTF_VARCHAR2_TABLE_400

Line 256: procedure rosetta_table_copy_in_p5(t out nocopy okl_vrr_pvt.vrr_tbl_type, a0 JTF_NUMBER_TABLE

252: end if;
253: end if;
254: end rosetta_table_copy_out_p2;
255:
256: procedure rosetta_table_copy_in_p5(t out nocopy okl_vrr_pvt.vrr_tbl_type, a0 JTF_NUMBER_TABLE
257: , a1 JTF_NUMBER_TABLE
258: , a2 JTF_NUMBER_TABLE
259: , a3 JTF_VARCHAR2_TABLE_100
260: , a4 JTF_VARCHAR2_TABLE_400

Line 335: procedure rosetta_table_copy_out_p5(t okl_vrr_pvt.vrr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

331: end loop;
332: end if;
333: end if;
334: end rosetta_table_copy_in_p5;
335: procedure rosetta_table_copy_out_p5(t okl_vrr_pvt.vrr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
336: , a1 out nocopy JTF_NUMBER_TABLE
337: , a2 out nocopy JTF_NUMBER_TABLE
338: , a3 out nocopy JTF_VARCHAR2_TABLE_100
339: , a4 out nocopy JTF_VARCHAR2_TABLE_400

Line 579: ddp_vrrv_rec okl_vrr_pvt.vrrv_rec_type;

575: , p6_a30 out nocopy NUMBER
576: )
577:
578: as
579: ddp_vrrv_rec okl_vrr_pvt.vrrv_rec_type;
580: ddx_vrrv_rec okl_vrr_pvt.vrrv_rec_type;
581: ddindx binary_integer; indx binary_integer;
582: begin
583:

Line 580: ddx_vrrv_rec okl_vrr_pvt.vrrv_rec_type;

576: )
577:
578: as
579: ddp_vrrv_rec okl_vrr_pvt.vrrv_rec_type;
580: ddx_vrrv_rec okl_vrr_pvt.vrrv_rec_type;
581: ddindx binary_integer; indx binary_integer;
582: begin
583:
584: -- copy data to the local IN or IN-OUT args, if any

Line 624: okl_vrr_pvt.insert_row(p_api_version,

620: ddp_vrrv_rec.last_update_login := p5_a30;
621:
622:
623: -- here's the delegated call to the old PL/SQL routine
624: okl_vrr_pvt.insert_row(p_api_version,
625: p_init_msg_list,
626: x_return_status,
627: x_msg_count,
628: x_msg_data,

Line 749: ddp_vrrv_tbl okl_vrr_pvt.vrrv_tbl_type;

745: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
746: )
747:
748: as
749: ddp_vrrv_tbl okl_vrr_pvt.vrrv_tbl_type;
750: ddx_vrrv_tbl okl_vrr_pvt.vrrv_tbl_type;
751: ddpx_error_tbl okl_api.error_tbl_type;
752: ddindx binary_integer; indx binary_integer;
753: begin

Line 750: ddx_vrrv_tbl okl_vrr_pvt.vrrv_tbl_type;

746: )
747:
748: as
749: ddp_vrrv_tbl okl_vrr_pvt.vrrv_tbl_type;
750: ddx_vrrv_tbl okl_vrr_pvt.vrrv_tbl_type;
751: ddpx_error_tbl okl_api.error_tbl_type;
752: ddindx binary_integer; indx binary_integer;
753: begin
754:

Line 761: okl_vrr_pvt_w.rosetta_table_copy_in_p2(ddp_vrrv_tbl, p5_a0

757:
758:
759:
760:
761: okl_vrr_pvt_w.rosetta_table_copy_in_p2(ddp_vrrv_tbl, p5_a0
762: , p5_a1
763: , p5_a2
764: , p5_a3
765: , p5_a4

Line 805: okl_vrr_pvt.insert_row(p_api_version,

801: , p7_a6
802: );
803:
804: -- here's the delegated call to the old PL/SQL routine
805: okl_vrr_pvt.insert_row(p_api_version,
806: p_init_msg_list,
807: x_return_status,
808: x_msg_count,
809: x_msg_data,

Line 821: okl_vrr_pvt_w.rosetta_table_copy_out_p2(ddx_vrrv_tbl, p6_a0

817:
818:
819:
820:
821: okl_vrr_pvt_w.rosetta_table_copy_out_p2(ddx_vrrv_tbl, p6_a0
822: , p6_a1
823: , p6_a2
824: , p6_a3
825: , p6_a4

Line 934: ddp_vrrv_tbl okl_vrr_pvt.vrrv_tbl_type;

930: , p6_a30 out nocopy JTF_NUMBER_TABLE
931: )
932:
933: as
934: ddp_vrrv_tbl okl_vrr_pvt.vrrv_tbl_type;
935: ddx_vrrv_tbl okl_vrr_pvt.vrrv_tbl_type;
936: ddindx binary_integer; indx binary_integer;
937: begin
938:

Line 935: ddx_vrrv_tbl okl_vrr_pvt.vrrv_tbl_type;

931: )
932:
933: as
934: ddp_vrrv_tbl okl_vrr_pvt.vrrv_tbl_type;
935: ddx_vrrv_tbl okl_vrr_pvt.vrrv_tbl_type;
936: ddindx binary_integer; indx binary_integer;
937: begin
938:
939: -- copy data to the local IN or IN-OUT args, if any

Line 945: okl_vrr_pvt_w.rosetta_table_copy_in_p2(ddp_vrrv_tbl, p5_a0

941:
942:
943:
944:
945: okl_vrr_pvt_w.rosetta_table_copy_in_p2(ddp_vrrv_tbl, p5_a0
946: , p5_a1
947: , p5_a2
948: , p5_a3
949: , p5_a4

Line 980: okl_vrr_pvt.insert_row(p_api_version,

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

Line 995: okl_vrr_pvt_w.rosetta_table_copy_out_p2(ddx_vrrv_tbl, p6_a0

991:
992:
993:
994:
995: okl_vrr_pvt_w.rosetta_table_copy_out_p2(ddx_vrrv_tbl, p6_a0
996: , p6_a1
997: , p6_a2
998: , p6_a3
999: , p6_a4

Line 1068: ddp_vrrv_rec okl_vrr_pvt.vrrv_rec_type;

1064: , p5_a30 NUMBER
1065: )
1066:
1067: as
1068: ddp_vrrv_rec okl_vrr_pvt.vrrv_rec_type;
1069: ddindx binary_integer; indx binary_integer;
1070: begin
1071:
1072: -- copy data to the local IN or IN-OUT args, if any

Line 1111: okl_vrr_pvt.lock_row(p_api_version,

1107: ddp_vrrv_rec.last_update_date := p5_a29;
1108: ddp_vrrv_rec.last_update_login := p5_a30;
1109:
1110: -- here's the delegated call to the old PL/SQL routine
1111: okl_vrr_pvt.lock_row(p_api_version,
1112: p_init_msg_list,
1113: x_return_status,
1114: x_msg_count,
1115: x_msg_data,

Line 1172: ddp_vrrv_tbl okl_vrr_pvt.vrrv_tbl_type;

1168: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
1169: )
1170:
1171: as
1172: ddp_vrrv_tbl okl_vrr_pvt.vrrv_tbl_type;
1173: ddpx_error_tbl okl_api.error_tbl_type;
1174: ddindx binary_integer; indx binary_integer;
1175: begin
1176:

Line 1183: okl_vrr_pvt_w.rosetta_table_copy_in_p2(ddp_vrrv_tbl, p5_a0

1179:
1180:
1181:
1182:
1183: okl_vrr_pvt_w.rosetta_table_copy_in_p2(ddp_vrrv_tbl, p5_a0
1184: , p5_a1
1185: , p5_a2
1186: , p5_a3
1187: , p5_a4

Line 1226: okl_vrr_pvt.lock_row(p_api_version,

1222: , p6_a6
1223: );
1224:
1225: -- here's the delegated call to the old PL/SQL routine
1226: okl_vrr_pvt.lock_row(p_api_version,
1227: p_init_msg_list,
1228: x_return_status,
1229: x_msg_count,
1230: x_msg_data,

Line 1290: ddp_vrrv_tbl okl_vrr_pvt.vrrv_tbl_type;

1286: , p5_a30 JTF_NUMBER_TABLE
1287: )
1288:
1289: as
1290: ddp_vrrv_tbl okl_vrr_pvt.vrrv_tbl_type;
1291: ddindx binary_integer; indx binary_integer;
1292: begin
1293:
1294: -- copy data to the local IN or IN-OUT args, if any

Line 1300: okl_vrr_pvt_w.rosetta_table_copy_in_p2(ddp_vrrv_tbl, p5_a0

1296:
1297:
1298:
1299:
1300: okl_vrr_pvt_w.rosetta_table_copy_in_p2(ddp_vrrv_tbl, p5_a0
1301: , p5_a1
1302: , p5_a2
1303: , p5_a3
1304: , p5_a4

Line 1334: okl_vrr_pvt.lock_row(p_api_version,

1330: , p5_a30
1331: );
1332:
1333: -- here's the delegated call to the old PL/SQL routine
1334: okl_vrr_pvt.lock_row(p_api_version,
1335: p_init_msg_list,
1336: x_return_status,
1337: x_msg_count,
1338: x_msg_data,

Line 1419: ddp_vrrv_rec okl_vrr_pvt.vrrv_rec_type;

1415: , p6_a30 out nocopy NUMBER
1416: )
1417:
1418: as
1419: ddp_vrrv_rec okl_vrr_pvt.vrrv_rec_type;
1420: ddx_vrrv_rec okl_vrr_pvt.vrrv_rec_type;
1421: ddindx binary_integer; indx binary_integer;
1422: begin
1423:

Line 1420: ddx_vrrv_rec okl_vrr_pvt.vrrv_rec_type;

1416: )
1417:
1418: as
1419: ddp_vrrv_rec okl_vrr_pvt.vrrv_rec_type;
1420: ddx_vrrv_rec okl_vrr_pvt.vrrv_rec_type;
1421: ddindx binary_integer; indx binary_integer;
1422: begin
1423:
1424: -- copy data to the local IN or IN-OUT args, if any

Line 1464: okl_vrr_pvt.update_row(p_api_version,

1460: ddp_vrrv_rec.last_update_login := p5_a30;
1461:
1462:
1463: -- here's the delegated call to the old PL/SQL routine
1464: okl_vrr_pvt.update_row(p_api_version,
1465: p_init_msg_list,
1466: x_return_status,
1467: x_msg_count,
1468: x_msg_data,

Line 1589: ddp_vrrv_tbl okl_vrr_pvt.vrrv_tbl_type;

1585: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
1586: )
1587:
1588: as
1589: ddp_vrrv_tbl okl_vrr_pvt.vrrv_tbl_type;
1590: ddx_vrrv_tbl okl_vrr_pvt.vrrv_tbl_type;
1591: ddpx_error_tbl okl_api.error_tbl_type;
1592: ddindx binary_integer; indx binary_integer;
1593: begin

Line 1590: ddx_vrrv_tbl okl_vrr_pvt.vrrv_tbl_type;

1586: )
1587:
1588: as
1589: ddp_vrrv_tbl okl_vrr_pvt.vrrv_tbl_type;
1590: ddx_vrrv_tbl okl_vrr_pvt.vrrv_tbl_type;
1591: ddpx_error_tbl okl_api.error_tbl_type;
1592: ddindx binary_integer; indx binary_integer;
1593: begin
1594:

Line 1601: okl_vrr_pvt_w.rosetta_table_copy_in_p2(ddp_vrrv_tbl, p5_a0

1597:
1598:
1599:
1600:
1601: okl_vrr_pvt_w.rosetta_table_copy_in_p2(ddp_vrrv_tbl, p5_a0
1602: , p5_a1
1603: , p5_a2
1604: , p5_a3
1605: , p5_a4

Line 1645: okl_vrr_pvt.update_row(p_api_version,

1641: , p7_a6
1642: );
1643:
1644: -- here's the delegated call to the old PL/SQL routine
1645: okl_vrr_pvt.update_row(p_api_version,
1646: p_init_msg_list,
1647: x_return_status,
1648: x_msg_count,
1649: x_msg_data,

Line 1661: okl_vrr_pvt_w.rosetta_table_copy_out_p2(ddx_vrrv_tbl, p6_a0

1657:
1658:
1659:
1660:
1661: okl_vrr_pvt_w.rosetta_table_copy_out_p2(ddx_vrrv_tbl, p6_a0
1662: , p6_a1
1663: , p6_a2
1664: , p6_a3
1665: , p6_a4

Line 1774: ddp_vrrv_tbl okl_vrr_pvt.vrrv_tbl_type;

1770: , p6_a30 out nocopy JTF_NUMBER_TABLE
1771: )
1772:
1773: as
1774: ddp_vrrv_tbl okl_vrr_pvt.vrrv_tbl_type;
1775: ddx_vrrv_tbl okl_vrr_pvt.vrrv_tbl_type;
1776: ddindx binary_integer; indx binary_integer;
1777: begin
1778:

Line 1775: ddx_vrrv_tbl okl_vrr_pvt.vrrv_tbl_type;

1771: )
1772:
1773: as
1774: ddp_vrrv_tbl okl_vrr_pvt.vrrv_tbl_type;
1775: ddx_vrrv_tbl okl_vrr_pvt.vrrv_tbl_type;
1776: ddindx binary_integer; indx binary_integer;
1777: begin
1778:
1779: -- copy data to the local IN or IN-OUT args, if any

Line 1785: okl_vrr_pvt_w.rosetta_table_copy_in_p2(ddp_vrrv_tbl, p5_a0

1781:
1782:
1783:
1784:
1785: okl_vrr_pvt_w.rosetta_table_copy_in_p2(ddp_vrrv_tbl, p5_a0
1786: , p5_a1
1787: , p5_a2
1788: , p5_a3
1789: , p5_a4

Line 1820: okl_vrr_pvt.update_row(p_api_version,

1816: );
1817:
1818:
1819: -- here's the delegated call to the old PL/SQL routine
1820: okl_vrr_pvt.update_row(p_api_version,
1821: p_init_msg_list,
1822: x_return_status,
1823: x_msg_count,
1824: x_msg_data,

Line 1835: okl_vrr_pvt_w.rosetta_table_copy_out_p2(ddx_vrrv_tbl, p6_a0

1831:
1832:
1833:
1834:
1835: okl_vrr_pvt_w.rosetta_table_copy_out_p2(ddx_vrrv_tbl, p6_a0
1836: , p6_a1
1837: , p6_a2
1838: , p6_a3
1839: , p6_a4

Line 1908: ddp_vrrv_rec okl_vrr_pvt.vrrv_rec_type;

1904: , p5_a30 NUMBER
1905: )
1906:
1907: as
1908: ddp_vrrv_rec okl_vrr_pvt.vrrv_rec_type;
1909: ddindx binary_integer; indx binary_integer;
1910: begin
1911:
1912: -- copy data to the local IN or IN-OUT args, if any

Line 1951: okl_vrr_pvt.delete_row(p_api_version,

1947: ddp_vrrv_rec.last_update_date := p5_a29;
1948: ddp_vrrv_rec.last_update_login := p5_a30;
1949:
1950: -- here's the delegated call to the old PL/SQL routine
1951: okl_vrr_pvt.delete_row(p_api_version,
1952: p_init_msg_list,
1953: x_return_status,
1954: x_msg_count,
1955: x_msg_data,

Line 2012: ddp_vrrv_tbl okl_vrr_pvt.vrrv_tbl_type;

2008: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
2009: )
2010:
2011: as
2012: ddp_vrrv_tbl okl_vrr_pvt.vrrv_tbl_type;
2013: ddpx_error_tbl okl_api.error_tbl_type;
2014: ddindx binary_integer; indx binary_integer;
2015: begin
2016:

Line 2023: okl_vrr_pvt_w.rosetta_table_copy_in_p2(ddp_vrrv_tbl, p5_a0

2019:
2020:
2021:
2022:
2023: okl_vrr_pvt_w.rosetta_table_copy_in_p2(ddp_vrrv_tbl, p5_a0
2024: , p5_a1
2025: , p5_a2
2026: , p5_a3
2027: , p5_a4

Line 2066: okl_vrr_pvt.delete_row(p_api_version,

2062: , p6_a6
2063: );
2064:
2065: -- here's the delegated call to the old PL/SQL routine
2066: okl_vrr_pvt.delete_row(p_api_version,
2067: p_init_msg_list,
2068: x_return_status,
2069: x_msg_count,
2070: x_msg_data,

Line 2130: ddp_vrrv_tbl okl_vrr_pvt.vrrv_tbl_type;

2126: , p5_a30 JTF_NUMBER_TABLE
2127: )
2128:
2129: as
2130: ddp_vrrv_tbl okl_vrr_pvt.vrrv_tbl_type;
2131: ddindx binary_integer; indx binary_integer;
2132: begin
2133:
2134: -- copy data to the local IN or IN-OUT args, if any

Line 2140: okl_vrr_pvt_w.rosetta_table_copy_in_p2(ddp_vrrv_tbl, p5_a0

2136:
2137:
2138:
2139:
2140: okl_vrr_pvt_w.rosetta_table_copy_in_p2(ddp_vrrv_tbl, p5_a0
2141: , p5_a1
2142: , p5_a2
2143: , p5_a3
2144: , p5_a4

Line 2174: okl_vrr_pvt.delete_row(p_api_version,

2170: , p5_a30
2171: );
2172:
2173: -- here's the delegated call to the old PL/SQL routine
2174: okl_vrr_pvt.delete_row(p_api_version,
2175: p_init_msg_list,
2176: x_return_status,
2177: x_msg_count,
2178: x_msg_data,

Line 2228: ddp_vrrv_rec okl_vrr_pvt.vrrv_rec_type;

2224: , p5_a30 NUMBER
2225: )
2226:
2227: as
2228: ddp_vrrv_rec okl_vrr_pvt.vrrv_rec_type;
2229: ddindx binary_integer; indx binary_integer;
2230: begin
2231:
2232: -- copy data to the local IN or IN-OUT args, if any

Line 2271: okl_vrr_pvt.validate_row(p_api_version,

2267: ddp_vrrv_rec.last_update_date := p5_a29;
2268: ddp_vrrv_rec.last_update_login := p5_a30;
2269:
2270: -- here's the delegated call to the old PL/SQL routine
2271: okl_vrr_pvt.validate_row(p_api_version,
2272: p_init_msg_list,
2273: x_return_status,
2274: x_msg_count,
2275: x_msg_data,

Line 2332: ddp_vrrv_tbl okl_vrr_pvt.vrrv_tbl_type;

2328: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
2329: )
2330:
2331: as
2332: ddp_vrrv_tbl okl_vrr_pvt.vrrv_tbl_type;
2333: ddpx_error_tbl okl_api.error_tbl_type;
2334: ddindx binary_integer; indx binary_integer;
2335: begin
2336:

Line 2343: okl_vrr_pvt_w.rosetta_table_copy_in_p2(ddp_vrrv_tbl, p5_a0

2339:
2340:
2341:
2342:
2343: okl_vrr_pvt_w.rosetta_table_copy_in_p2(ddp_vrrv_tbl, p5_a0
2344: , p5_a1
2345: , p5_a2
2346: , p5_a3
2347: , p5_a4

Line 2386: okl_vrr_pvt.validate_row(p_api_version,

2382: , p6_a6
2383: );
2384:
2385: -- here's the delegated call to the old PL/SQL routine
2386: okl_vrr_pvt.validate_row(p_api_version,
2387: p_init_msg_list,
2388: x_return_status,
2389: x_msg_count,
2390: x_msg_data,

Line 2450: ddp_vrrv_tbl okl_vrr_pvt.vrrv_tbl_type;

2446: , p5_a30 JTF_NUMBER_TABLE
2447: )
2448:
2449: as
2450: ddp_vrrv_tbl okl_vrr_pvt.vrrv_tbl_type;
2451: ddindx binary_integer; indx binary_integer;
2452: begin
2453:
2454: -- copy data to the local IN or IN-OUT args, if any

Line 2460: okl_vrr_pvt_w.rosetta_table_copy_in_p2(ddp_vrrv_tbl, p5_a0

2456:
2457:
2458:
2459:
2460: okl_vrr_pvt_w.rosetta_table_copy_in_p2(ddp_vrrv_tbl, p5_a0
2461: , p5_a1
2462: , p5_a2
2463: , p5_a3
2464: , p5_a4

Line 2494: okl_vrr_pvt.validate_row(p_api_version,

2490: , p5_a30
2491: );
2492:
2493: -- here's the delegated call to the old PL/SQL routine
2494: okl_vrr_pvt.validate_row(p_api_version,
2495: p_init_msg_list,
2496: x_return_status,
2497: x_msg_count,
2498: x_msg_data,

Line 2509: end okl_vrr_pvt_w;

2505:
2506:
2507: end;
2508:
2509: end okl_vrr_pvt_w;