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_VAS_PVT_W dependencies on OKL_VAS_PVT

Line 1: package body okl_vas_pvt_w as

1: package body okl_vas_pvt_w as
2: /* $Header: OKLIVASB.pls 120.0 2005/08/04 23:15:13 manumanu noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_vas_pvt.vasv_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_vas_pvt.vasv_tbl_type, a0 JTF_NUMBER_TABLE

1: package body okl_vas_pvt_w as
2: /* $Header: OKLIVASB.pls 120.0 2005/08/04 23:15:13 manumanu noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_vas_pvt.vasv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_DATE_TABLE

Line 90: procedure rosetta_table_copy_out_p2(t okl_vas_pvt.vasv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

86: end loop;
87: end if;
88: end if;
89: end rosetta_table_copy_in_p2;
90: procedure rosetta_table_copy_out_p2(t okl_vas_pvt.vasv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
91: , a1 out nocopy JTF_NUMBER_TABLE
92: , a2 out nocopy JTF_NUMBER_TABLE
93: , a3 out nocopy JTF_NUMBER_TABLE
94: , a4 out nocopy JTF_DATE_TABLE

Line 284: procedure rosetta_table_copy_in_p5(t out nocopy okl_vas_pvt.vas_tbl_type, a0 JTF_NUMBER_TABLE

280: end if;
281: end if;
282: end rosetta_table_copy_out_p2;
283:
284: procedure rosetta_table_copy_in_p5(t out nocopy okl_vas_pvt.vas_tbl_type, a0 JTF_NUMBER_TABLE
285: , a1 JTF_NUMBER_TABLE
286: , a2 JTF_NUMBER_TABLE
287: , a3 JTF_NUMBER_TABLE
288: , a4 JTF_DATE_TABLE

Line 371: procedure rosetta_table_copy_out_p5(t okl_vas_pvt.vas_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

367: end loop;
368: end if;
369: end if;
370: end rosetta_table_copy_in_p5;
371: procedure rosetta_table_copy_out_p5(t okl_vas_pvt.vas_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
372: , a1 out nocopy JTF_NUMBER_TABLE
373: , a2 out nocopy JTF_NUMBER_TABLE
374: , a3 out nocopy JTF_NUMBER_TABLE
375: , a4 out nocopy JTF_DATE_TABLE

Line 643: ddp_vasv_rec okl_vas_pvt.vasv_rec_type;

639: , p6_a34 out nocopy NUMBER
640: )
641:
642: as
643: ddp_vasv_rec okl_vas_pvt.vasv_rec_type;
644: ddx_vasv_rec okl_vas_pvt.vasv_rec_type;
645: ddindx binary_integer; indx binary_integer;
646: begin
647:

Line 644: ddx_vasv_rec okl_vas_pvt.vasv_rec_type;

640: )
641:
642: as
643: ddp_vasv_rec okl_vas_pvt.vasv_rec_type;
644: ddx_vasv_rec okl_vas_pvt.vasv_rec_type;
645: ddindx binary_integer; indx binary_integer;
646: begin
647:
648: -- copy data to the local IN or IN-OUT args, if any

Line 692: okl_vas_pvt.insert_row(p_api_version,

688: ddp_vasv_rec.last_update_login := p5_a34;
689:
690:
691: -- here's the delegated call to the old PL/SQL routine
692: okl_vas_pvt.insert_row(p_api_version,
693: p_init_msg_list,
694: x_return_status,
695: x_msg_count,
696: x_msg_data,

Line 829: ddp_vasv_tbl okl_vas_pvt.vasv_tbl_type;

825: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
826: )
827:
828: as
829: ddp_vasv_tbl okl_vas_pvt.vasv_tbl_type;
830: ddx_vasv_tbl okl_vas_pvt.vasv_tbl_type;
831: ddpx_error_tbl okl_api.error_tbl_type;
832: ddindx binary_integer; indx binary_integer;
833: begin

Line 830: ddx_vasv_tbl okl_vas_pvt.vasv_tbl_type;

826: )
827:
828: as
829: ddp_vasv_tbl okl_vas_pvt.vasv_tbl_type;
830: ddx_vasv_tbl okl_vas_pvt.vasv_tbl_type;
831: ddpx_error_tbl okl_api.error_tbl_type;
832: ddindx binary_integer; indx binary_integer;
833: begin
834:

Line 841: okl_vas_pvt_w.rosetta_table_copy_in_p2(ddp_vasv_tbl, p5_a0

837:
838:
839:
840:
841: okl_vas_pvt_w.rosetta_table_copy_in_p2(ddp_vasv_tbl, p5_a0
842: , p5_a1
843: , p5_a2
844: , p5_a3
845: , p5_a4

Line 889: okl_vas_pvt.insert_row(p_api_version,

885: , p7_a6
886: );
887:
888: -- here's the delegated call to the old PL/SQL routine
889: okl_vas_pvt.insert_row(p_api_version,
890: p_init_msg_list,
891: x_return_status,
892: x_msg_count,
893: x_msg_data,

Line 905: okl_vas_pvt_w.rosetta_table_copy_out_p2(ddx_vasv_tbl, p6_a0

901:
902:
903:
904:
905: okl_vas_pvt_w.rosetta_table_copy_out_p2(ddx_vasv_tbl, p6_a0
906: , p6_a1
907: , p6_a2
908: , p6_a3
909: , p6_a4

Line 1030: ddp_vasv_tbl okl_vas_pvt.vasv_tbl_type;

1026: , p6_a34 out nocopy JTF_NUMBER_TABLE
1027: )
1028:
1029: as
1030: ddp_vasv_tbl okl_vas_pvt.vasv_tbl_type;
1031: ddx_vasv_tbl okl_vas_pvt.vasv_tbl_type;
1032: ddindx binary_integer; indx binary_integer;
1033: begin
1034:

Line 1031: ddx_vasv_tbl okl_vas_pvt.vasv_tbl_type;

1027: )
1028:
1029: as
1030: ddp_vasv_tbl okl_vas_pvt.vasv_tbl_type;
1031: ddx_vasv_tbl okl_vas_pvt.vasv_tbl_type;
1032: ddindx binary_integer; indx binary_integer;
1033: begin
1034:
1035: -- copy data to the local IN or IN-OUT args, if any

Line 1041: okl_vas_pvt_w.rosetta_table_copy_in_p2(ddp_vasv_tbl, p5_a0

1037:
1038:
1039:
1040:
1041: okl_vas_pvt_w.rosetta_table_copy_in_p2(ddp_vasv_tbl, p5_a0
1042: , p5_a1
1043: , p5_a2
1044: , p5_a3
1045: , p5_a4

Line 1080: okl_vas_pvt.insert_row(p_api_version,

1076: );
1077:
1078:
1079: -- here's the delegated call to the old PL/SQL routine
1080: okl_vas_pvt.insert_row(p_api_version,
1081: p_init_msg_list,
1082: x_return_status,
1083: x_msg_count,
1084: x_msg_data,

Line 1095: okl_vas_pvt_w.rosetta_table_copy_out_p2(ddx_vasv_tbl, p6_a0

1091:
1092:
1093:
1094:
1095: okl_vas_pvt_w.rosetta_table_copy_out_p2(ddx_vasv_tbl, p6_a0
1096: , p6_a1
1097: , p6_a2
1098: , p6_a3
1099: , p6_a4

Line 1176: ddp_vasv_rec okl_vas_pvt.vasv_rec_type;

1172: , p5_a34 NUMBER
1173: )
1174:
1175: as
1176: ddp_vasv_rec okl_vas_pvt.vasv_rec_type;
1177: ddindx binary_integer; indx binary_integer;
1178: begin
1179:
1180: -- copy data to the local IN or IN-OUT args, if any

Line 1223: okl_vas_pvt.lock_row(p_api_version,

1219: ddp_vasv_rec.last_update_date := p5_a33;
1220: ddp_vasv_rec.last_update_login := p5_a34;
1221:
1222: -- here's the delegated call to the old PL/SQL routine
1223: okl_vas_pvt.lock_row(p_api_version,
1224: p_init_msg_list,
1225: x_return_status,
1226: x_msg_count,
1227: x_msg_data,

Line 1288: ddp_vasv_tbl okl_vas_pvt.vasv_tbl_type;

1284: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
1285: )
1286:
1287: as
1288: ddp_vasv_tbl okl_vas_pvt.vasv_tbl_type;
1289: ddpx_error_tbl okl_api.error_tbl_type;
1290: ddindx binary_integer; indx binary_integer;
1291: begin
1292:

Line 1299: okl_vas_pvt_w.rosetta_table_copy_in_p2(ddp_vasv_tbl, p5_a0

1295:
1296:
1297:
1298:
1299: okl_vas_pvt_w.rosetta_table_copy_in_p2(ddp_vasv_tbl, p5_a0
1300: , p5_a1
1301: , p5_a2
1302: , p5_a3
1303: , p5_a4

Line 1346: okl_vas_pvt.lock_row(p_api_version,

1342: , p6_a6
1343: );
1344:
1345: -- here's the delegated call to the old PL/SQL routine
1346: okl_vas_pvt.lock_row(p_api_version,
1347: p_init_msg_list,
1348: x_return_status,
1349: x_msg_count,
1350: x_msg_data,

Line 1414: ddp_vasv_tbl okl_vas_pvt.vasv_tbl_type;

1410: , p5_a34 JTF_NUMBER_TABLE
1411: )
1412:
1413: as
1414: ddp_vasv_tbl okl_vas_pvt.vasv_tbl_type;
1415: ddindx binary_integer; indx binary_integer;
1416: begin
1417:
1418: -- copy data to the local IN or IN-OUT args, if any

Line 1424: okl_vas_pvt_w.rosetta_table_copy_in_p2(ddp_vasv_tbl, p5_a0

1420:
1421:
1422:
1423:
1424: okl_vas_pvt_w.rosetta_table_copy_in_p2(ddp_vasv_tbl, p5_a0
1425: , p5_a1
1426: , p5_a2
1427: , p5_a3
1428: , p5_a4

Line 1462: okl_vas_pvt.lock_row(p_api_version,

1458: , p5_a34
1459: );
1460:
1461: -- here's the delegated call to the old PL/SQL routine
1462: okl_vas_pvt.lock_row(p_api_version,
1463: p_init_msg_list,
1464: x_return_status,
1465: x_msg_count,
1466: x_msg_data,

Line 1555: ddp_vasv_rec okl_vas_pvt.vasv_rec_type;

1551: , p6_a34 out nocopy NUMBER
1552: )
1553:
1554: as
1555: ddp_vasv_rec okl_vas_pvt.vasv_rec_type;
1556: ddx_vasv_rec okl_vas_pvt.vasv_rec_type;
1557: ddindx binary_integer; indx binary_integer;
1558: begin
1559:

Line 1556: ddx_vasv_rec okl_vas_pvt.vasv_rec_type;

1552: )
1553:
1554: as
1555: ddp_vasv_rec okl_vas_pvt.vasv_rec_type;
1556: ddx_vasv_rec okl_vas_pvt.vasv_rec_type;
1557: ddindx binary_integer; indx binary_integer;
1558: begin
1559:
1560: -- copy data to the local IN or IN-OUT args, if any

Line 1604: okl_vas_pvt.update_row(p_api_version,

1600: ddp_vasv_rec.last_update_login := p5_a34;
1601:
1602:
1603: -- here's the delegated call to the old PL/SQL routine
1604: okl_vas_pvt.update_row(p_api_version,
1605: p_init_msg_list,
1606: x_return_status,
1607: x_msg_count,
1608: x_msg_data,

Line 1741: ddp_vasv_tbl okl_vas_pvt.vasv_tbl_type;

1737: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
1738: )
1739:
1740: as
1741: ddp_vasv_tbl okl_vas_pvt.vasv_tbl_type;
1742: ddx_vasv_tbl okl_vas_pvt.vasv_tbl_type;
1743: ddpx_error_tbl okl_api.error_tbl_type;
1744: ddindx binary_integer; indx binary_integer;
1745: begin

Line 1742: ddx_vasv_tbl okl_vas_pvt.vasv_tbl_type;

1738: )
1739:
1740: as
1741: ddp_vasv_tbl okl_vas_pvt.vasv_tbl_type;
1742: ddx_vasv_tbl okl_vas_pvt.vasv_tbl_type;
1743: ddpx_error_tbl okl_api.error_tbl_type;
1744: ddindx binary_integer; indx binary_integer;
1745: begin
1746:

Line 1753: okl_vas_pvt_w.rosetta_table_copy_in_p2(ddp_vasv_tbl, p5_a0

1749:
1750:
1751:
1752:
1753: okl_vas_pvt_w.rosetta_table_copy_in_p2(ddp_vasv_tbl, p5_a0
1754: , p5_a1
1755: , p5_a2
1756: , p5_a3
1757: , p5_a4

Line 1801: okl_vas_pvt.update_row(p_api_version,

1797: , p7_a6
1798: );
1799:
1800: -- here's the delegated call to the old PL/SQL routine
1801: okl_vas_pvt.update_row(p_api_version,
1802: p_init_msg_list,
1803: x_return_status,
1804: x_msg_count,
1805: x_msg_data,

Line 1817: okl_vas_pvt_w.rosetta_table_copy_out_p2(ddx_vasv_tbl, p6_a0

1813:
1814:
1815:
1816:
1817: okl_vas_pvt_w.rosetta_table_copy_out_p2(ddx_vasv_tbl, p6_a0
1818: , p6_a1
1819: , p6_a2
1820: , p6_a3
1821: , p6_a4

Line 1942: ddp_vasv_tbl okl_vas_pvt.vasv_tbl_type;

1938: , p6_a34 out nocopy JTF_NUMBER_TABLE
1939: )
1940:
1941: as
1942: ddp_vasv_tbl okl_vas_pvt.vasv_tbl_type;
1943: ddx_vasv_tbl okl_vas_pvt.vasv_tbl_type;
1944: ddindx binary_integer; indx binary_integer;
1945: begin
1946:

Line 1943: ddx_vasv_tbl okl_vas_pvt.vasv_tbl_type;

1939: )
1940:
1941: as
1942: ddp_vasv_tbl okl_vas_pvt.vasv_tbl_type;
1943: ddx_vasv_tbl okl_vas_pvt.vasv_tbl_type;
1944: ddindx binary_integer; indx binary_integer;
1945: begin
1946:
1947: -- copy data to the local IN or IN-OUT args, if any

Line 1953: okl_vas_pvt_w.rosetta_table_copy_in_p2(ddp_vasv_tbl, p5_a0

1949:
1950:
1951:
1952:
1953: okl_vas_pvt_w.rosetta_table_copy_in_p2(ddp_vasv_tbl, p5_a0
1954: , p5_a1
1955: , p5_a2
1956: , p5_a3
1957: , p5_a4

Line 1992: okl_vas_pvt.update_row(p_api_version,

1988: );
1989:
1990:
1991: -- here's the delegated call to the old PL/SQL routine
1992: okl_vas_pvt.update_row(p_api_version,
1993: p_init_msg_list,
1994: x_return_status,
1995: x_msg_count,
1996: x_msg_data,

Line 2007: okl_vas_pvt_w.rosetta_table_copy_out_p2(ddx_vasv_tbl, p6_a0

2003:
2004:
2005:
2006:
2007: okl_vas_pvt_w.rosetta_table_copy_out_p2(ddx_vasv_tbl, p6_a0
2008: , p6_a1
2009: , p6_a2
2010: , p6_a3
2011: , p6_a4

Line 2088: ddp_vasv_rec okl_vas_pvt.vasv_rec_type;

2084: , p5_a34 NUMBER
2085: )
2086:
2087: as
2088: ddp_vasv_rec okl_vas_pvt.vasv_rec_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 2135: okl_vas_pvt.delete_row(p_api_version,

2131: ddp_vasv_rec.last_update_date := p5_a33;
2132: ddp_vasv_rec.last_update_login := p5_a34;
2133:
2134: -- here's the delegated call to the old PL/SQL routine
2135: okl_vas_pvt.delete_row(p_api_version,
2136: p_init_msg_list,
2137: x_return_status,
2138: x_msg_count,
2139: x_msg_data,

Line 2200: ddp_vasv_tbl okl_vas_pvt.vasv_tbl_type;

2196: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
2197: )
2198:
2199: as
2200: ddp_vasv_tbl okl_vas_pvt.vasv_tbl_type;
2201: ddpx_error_tbl okl_api.error_tbl_type;
2202: ddindx binary_integer; indx binary_integer;
2203: begin
2204:

Line 2211: okl_vas_pvt_w.rosetta_table_copy_in_p2(ddp_vasv_tbl, p5_a0

2207:
2208:
2209:
2210:
2211: okl_vas_pvt_w.rosetta_table_copy_in_p2(ddp_vasv_tbl, p5_a0
2212: , p5_a1
2213: , p5_a2
2214: , p5_a3
2215: , p5_a4

Line 2258: okl_vas_pvt.delete_row(p_api_version,

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

Line 2326: ddp_vasv_tbl okl_vas_pvt.vasv_tbl_type;

2322: , p5_a34 JTF_NUMBER_TABLE
2323: )
2324:
2325: as
2326: ddp_vasv_tbl okl_vas_pvt.vasv_tbl_type;
2327: ddindx binary_integer; indx binary_integer;
2328: begin
2329:
2330: -- copy data to the local IN or IN-OUT args, if any

Line 2336: okl_vas_pvt_w.rosetta_table_copy_in_p2(ddp_vasv_tbl, p5_a0

2332:
2333:
2334:
2335:
2336: okl_vas_pvt_w.rosetta_table_copy_in_p2(ddp_vasv_tbl, p5_a0
2337: , p5_a1
2338: , p5_a2
2339: , p5_a3
2340: , p5_a4

Line 2374: okl_vas_pvt.delete_row(p_api_version,

2370: , p5_a34
2371: );
2372:
2373: -- here's the delegated call to the old PL/SQL routine
2374: okl_vas_pvt.delete_row(p_api_version,
2375: p_init_msg_list,
2376: x_return_status,
2377: x_msg_count,
2378: x_msg_data,

Line 2432: ddp_vasv_rec okl_vas_pvt.vasv_rec_type;

2428: , p5_a34 NUMBER
2429: )
2430:
2431: as
2432: ddp_vasv_rec okl_vas_pvt.vasv_rec_type;
2433: ddindx binary_integer; indx binary_integer;
2434: begin
2435:
2436: -- copy data to the local IN or IN-OUT args, if any

Line 2479: okl_vas_pvt.validate_row(p_api_version,

2475: ddp_vasv_rec.last_update_date := p5_a33;
2476: ddp_vasv_rec.last_update_login := p5_a34;
2477:
2478: -- here's the delegated call to the old PL/SQL routine
2479: okl_vas_pvt.validate_row(p_api_version,
2480: p_init_msg_list,
2481: x_return_status,
2482: x_msg_count,
2483: x_msg_data,

Line 2544: ddp_vasv_tbl okl_vas_pvt.vasv_tbl_type;

2540: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
2541: )
2542:
2543: as
2544: ddp_vasv_tbl okl_vas_pvt.vasv_tbl_type;
2545: ddpx_error_tbl okl_api.error_tbl_type;
2546: ddindx binary_integer; indx binary_integer;
2547: begin
2548:

Line 2555: okl_vas_pvt_w.rosetta_table_copy_in_p2(ddp_vasv_tbl, p5_a0

2551:
2552:
2553:
2554:
2555: okl_vas_pvt_w.rosetta_table_copy_in_p2(ddp_vasv_tbl, p5_a0
2556: , p5_a1
2557: , p5_a2
2558: , p5_a3
2559: , p5_a4

Line 2602: okl_vas_pvt.validate_row(p_api_version,

2598: , p6_a6
2599: );
2600:
2601: -- here's the delegated call to the old PL/SQL routine
2602: okl_vas_pvt.validate_row(p_api_version,
2603: p_init_msg_list,
2604: x_return_status,
2605: x_msg_count,
2606: x_msg_data,

Line 2670: ddp_vasv_tbl okl_vas_pvt.vasv_tbl_type;

2666: , p5_a34 JTF_NUMBER_TABLE
2667: )
2668:
2669: as
2670: ddp_vasv_tbl okl_vas_pvt.vasv_tbl_type;
2671: ddindx binary_integer; indx binary_integer;
2672: begin
2673:
2674: -- copy data to the local IN or IN-OUT args, if any

Line 2680: okl_vas_pvt_w.rosetta_table_copy_in_p2(ddp_vasv_tbl, p5_a0

2676:
2677:
2678:
2679:
2680: okl_vas_pvt_w.rosetta_table_copy_in_p2(ddp_vasv_tbl, p5_a0
2681: , p5_a1
2682: , p5_a2
2683: , p5_a3
2684: , p5_a4

Line 2718: okl_vas_pvt.validate_row(p_api_version,

2714: , p5_a34
2715: );
2716:
2717: -- here's the delegated call to the old PL/SQL routine
2718: okl_vas_pvt.validate_row(p_api_version,
2719: p_init_msg_list,
2720: x_return_status,
2721: x_msg_count,
2722: x_msg_data,

Line 2733: end okl_vas_pvt_w;

2729:
2730:
2731: end;
2732:
2733: end okl_vas_pvt_w;