DBA Data[Home] [Help]

APPS.OKL_VCR_PVT_W dependencies on OKL_VCR_PVT

Line 1: package body okl_vcr_pvt_w as

1: package body okl_vcr_pvt_w as
2: /* $Header: OKLIVCRB.pls 120.0 2005/08/03 07:56:15 sjalasut noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_vcr_pvt.vcrv_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_vcr_pvt.vcrv_tbl_type, a0 JTF_NUMBER_TABLE

1: package body okl_vcr_pvt_w as
2: /* $Header: OKLIVCRB.pls 120.0 2005/08/03 07:56:15 sjalasut noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_vcr_pvt.vcrv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100

Line 94: procedure rosetta_table_copy_out_p2(t okl_vcr_pvt.vcrv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

90: end loop;
91: end if;
92: end if;
93: end rosetta_table_copy_in_p2;
94: procedure rosetta_table_copy_out_p2(t okl_vcr_pvt.vcrv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
95: , a1 out nocopy JTF_NUMBER_TABLE
96: , a2 out nocopy JTF_NUMBER_TABLE
97: , a3 out nocopy JTF_NUMBER_TABLE
98: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 298: procedure rosetta_table_copy_in_p5(t out nocopy okl_vcr_pvt.vcr_tbl_type, a0 JTF_NUMBER_TABLE

294: end if;
295: end if;
296: end rosetta_table_copy_out_p2;
297:
298: procedure rosetta_table_copy_in_p5(t out nocopy okl_vcr_pvt.vcr_tbl_type, a0 JTF_NUMBER_TABLE
299: , a1 JTF_NUMBER_TABLE
300: , a2 JTF_NUMBER_TABLE
301: , a3 JTF_NUMBER_TABLE
302: , a4 JTF_VARCHAR2_TABLE_100

Line 389: procedure rosetta_table_copy_out_p5(t okl_vcr_pvt.vcr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

385: end loop;
386: end if;
387: end if;
388: end rosetta_table_copy_in_p5;
389: procedure rosetta_table_copy_out_p5(t okl_vcr_pvt.vcr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
390: , a1 out nocopy JTF_NUMBER_TABLE
391: , a2 out nocopy JTF_NUMBER_TABLE
392: , a3 out nocopy JTF_NUMBER_TABLE
393: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 675: ddp_vcrv_rec okl_vcr_pvt.vcrv_rec_type;

671: , p6_a36 out nocopy NUMBER
672: )
673:
674: as
675: ddp_vcrv_rec okl_vcr_pvt.vcrv_rec_type;
676: ddx_vcrv_rec okl_vcr_pvt.vcrv_rec_type;
677: ddindx binary_integer; indx binary_integer;
678: begin
679:

Line 676: ddx_vcrv_rec okl_vcr_pvt.vcrv_rec_type;

672: )
673:
674: as
675: ddp_vcrv_rec okl_vcr_pvt.vcrv_rec_type;
676: ddx_vcrv_rec okl_vcr_pvt.vcrv_rec_type;
677: ddindx binary_integer; indx binary_integer;
678: begin
679:
680: -- copy data to the local IN or IN-OUT args, if any

Line 726: okl_vcr_pvt.insert_row(p_api_version,

722: ddp_vcrv_rec.last_update_login := p5_a36;
723:
724:
725: -- here's the delegated call to the old PL/SQL routine
726: okl_vcr_pvt.insert_row(p_api_version,
727: p_init_msg_list,
728: x_return_status,
729: x_msg_count,
730: x_msg_data,

Line 869: ddp_vcrv_tbl okl_vcr_pvt.vcrv_tbl_type;

865: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
866: )
867:
868: as
869: ddp_vcrv_tbl okl_vcr_pvt.vcrv_tbl_type;
870: ddx_vcrv_tbl okl_vcr_pvt.vcrv_tbl_type;
871: ddpx_error_tbl okl_api.error_tbl_type;
872: ddindx binary_integer; indx binary_integer;
873: begin

Line 870: ddx_vcrv_tbl okl_vcr_pvt.vcrv_tbl_type;

866: )
867:
868: as
869: ddp_vcrv_tbl okl_vcr_pvt.vcrv_tbl_type;
870: ddx_vcrv_tbl okl_vcr_pvt.vcrv_tbl_type;
871: ddpx_error_tbl okl_api.error_tbl_type;
872: ddindx binary_integer; indx binary_integer;
873: begin
874:

Line 881: okl_vcr_pvt_w.rosetta_table_copy_in_p2(ddp_vcrv_tbl, p5_a0

877:
878:
879:
880:
881: okl_vcr_pvt_w.rosetta_table_copy_in_p2(ddp_vcrv_tbl, p5_a0
882: , p5_a1
883: , p5_a2
884: , p5_a3
885: , p5_a4

Line 931: okl_vcr_pvt.insert_row(p_api_version,

927: , p7_a6
928: );
929:
930: -- here's the delegated call to the old PL/SQL routine
931: okl_vcr_pvt.insert_row(p_api_version,
932: p_init_msg_list,
933: x_return_status,
934: x_msg_count,
935: x_msg_data,

Line 947: okl_vcr_pvt_w.rosetta_table_copy_out_p2(ddx_vcrv_tbl, p6_a0

943:
944:
945:
946:
947: okl_vcr_pvt_w.rosetta_table_copy_out_p2(ddx_vcrv_tbl, p6_a0
948: , p6_a1
949: , p6_a2
950: , p6_a3
951: , p6_a4

Line 1078: ddp_vcrv_tbl okl_vcr_pvt.vcrv_tbl_type;

1074: , p6_a36 out nocopy JTF_NUMBER_TABLE
1075: )
1076:
1077: as
1078: ddp_vcrv_tbl okl_vcr_pvt.vcrv_tbl_type;
1079: ddx_vcrv_tbl okl_vcr_pvt.vcrv_tbl_type;
1080: ddindx binary_integer; indx binary_integer;
1081: begin
1082:

Line 1079: ddx_vcrv_tbl okl_vcr_pvt.vcrv_tbl_type;

1075: )
1076:
1077: as
1078: ddp_vcrv_tbl okl_vcr_pvt.vcrv_tbl_type;
1079: ddx_vcrv_tbl okl_vcr_pvt.vcrv_tbl_type;
1080: ddindx binary_integer; indx binary_integer;
1081: begin
1082:
1083: -- copy data to the local IN or IN-OUT args, if any

Line 1089: okl_vcr_pvt_w.rosetta_table_copy_in_p2(ddp_vcrv_tbl, p5_a0

1085:
1086:
1087:
1088:
1089: okl_vcr_pvt_w.rosetta_table_copy_in_p2(ddp_vcrv_tbl, p5_a0
1090: , p5_a1
1091: , p5_a2
1092: , p5_a3
1093: , p5_a4

Line 1130: okl_vcr_pvt.insert_row(p_api_version,

1126: );
1127:
1128:
1129: -- here's the delegated call to the old PL/SQL routine
1130: okl_vcr_pvt.insert_row(p_api_version,
1131: p_init_msg_list,
1132: x_return_status,
1133: x_msg_count,
1134: x_msg_data,

Line 1145: okl_vcr_pvt_w.rosetta_table_copy_out_p2(ddx_vcrv_tbl, p6_a0

1141:
1142:
1143:
1144:
1145: okl_vcr_pvt_w.rosetta_table_copy_out_p2(ddx_vcrv_tbl, p6_a0
1146: , p6_a1
1147: , p6_a2
1148: , p6_a3
1149: , p6_a4

Line 1230: ddp_vcrv_rec okl_vcr_pvt.vcrv_rec_type;

1226: , p5_a36 NUMBER
1227: )
1228:
1229: as
1230: ddp_vcrv_rec okl_vcr_pvt.vcrv_rec_type;
1231: ddindx binary_integer; indx binary_integer;
1232: begin
1233:
1234: -- copy data to the local IN or IN-OUT args, if any

Line 1279: okl_vcr_pvt.lock_row(p_api_version,

1275: ddp_vcrv_rec.last_update_date := p5_a35;
1276: ddp_vcrv_rec.last_update_login := p5_a36;
1277:
1278: -- here's the delegated call to the old PL/SQL routine
1279: okl_vcr_pvt.lock_row(p_api_version,
1280: p_init_msg_list,
1281: x_return_status,
1282: x_msg_count,
1283: x_msg_data,

Line 1346: ddp_vcrv_tbl okl_vcr_pvt.vcrv_tbl_type;

1342: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
1343: )
1344:
1345: as
1346: ddp_vcrv_tbl okl_vcr_pvt.vcrv_tbl_type;
1347: ddpx_error_tbl okl_api.error_tbl_type;
1348: ddindx binary_integer; indx binary_integer;
1349: begin
1350:

Line 1357: okl_vcr_pvt_w.rosetta_table_copy_in_p2(ddp_vcrv_tbl, p5_a0

1353:
1354:
1355:
1356:
1357: okl_vcr_pvt_w.rosetta_table_copy_in_p2(ddp_vcrv_tbl, p5_a0
1358: , p5_a1
1359: , p5_a2
1360: , p5_a3
1361: , p5_a4

Line 1406: okl_vcr_pvt.lock_row(p_api_version,

1402: , p6_a6
1403: );
1404:
1405: -- here's the delegated call to the old PL/SQL routine
1406: okl_vcr_pvt.lock_row(p_api_version,
1407: p_init_msg_list,
1408: x_return_status,
1409: x_msg_count,
1410: x_msg_data,

Line 1476: ddp_vcrv_tbl okl_vcr_pvt.vcrv_tbl_type;

1472: , p5_a36 JTF_NUMBER_TABLE
1473: )
1474:
1475: as
1476: ddp_vcrv_tbl okl_vcr_pvt.vcrv_tbl_type;
1477: ddindx binary_integer; indx binary_integer;
1478: begin
1479:
1480: -- copy data to the local IN or IN-OUT args, if any

Line 1486: okl_vcr_pvt_w.rosetta_table_copy_in_p2(ddp_vcrv_tbl, p5_a0

1482:
1483:
1484:
1485:
1486: okl_vcr_pvt_w.rosetta_table_copy_in_p2(ddp_vcrv_tbl, p5_a0
1487: , p5_a1
1488: , p5_a2
1489: , p5_a3
1490: , p5_a4

Line 1526: okl_vcr_pvt.lock_row(p_api_version,

1522: , p5_a36
1523: );
1524:
1525: -- here's the delegated call to the old PL/SQL routine
1526: okl_vcr_pvt.lock_row(p_api_version,
1527: p_init_msg_list,
1528: x_return_status,
1529: x_msg_count,
1530: x_msg_data,

Line 1623: ddp_vcrv_rec okl_vcr_pvt.vcrv_rec_type;

1619: , p6_a36 out nocopy NUMBER
1620: )
1621:
1622: as
1623: ddp_vcrv_rec okl_vcr_pvt.vcrv_rec_type;
1624: ddx_vcrv_rec okl_vcr_pvt.vcrv_rec_type;
1625: ddindx binary_integer; indx binary_integer;
1626: begin
1627:

Line 1624: ddx_vcrv_rec okl_vcr_pvt.vcrv_rec_type;

1620: )
1621:
1622: as
1623: ddp_vcrv_rec okl_vcr_pvt.vcrv_rec_type;
1624: ddx_vcrv_rec okl_vcr_pvt.vcrv_rec_type;
1625: ddindx binary_integer; indx binary_integer;
1626: begin
1627:
1628: -- copy data to the local IN or IN-OUT args, if any

Line 1674: okl_vcr_pvt.update_row(p_api_version,

1670: ddp_vcrv_rec.last_update_login := p5_a36;
1671:
1672:
1673: -- here's the delegated call to the old PL/SQL routine
1674: okl_vcr_pvt.update_row(p_api_version,
1675: p_init_msg_list,
1676: x_return_status,
1677: x_msg_count,
1678: x_msg_data,

Line 1817: ddp_vcrv_tbl okl_vcr_pvt.vcrv_tbl_type;

1813: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
1814: )
1815:
1816: as
1817: ddp_vcrv_tbl okl_vcr_pvt.vcrv_tbl_type;
1818: ddx_vcrv_tbl okl_vcr_pvt.vcrv_tbl_type;
1819: ddpx_error_tbl okl_api.error_tbl_type;
1820: ddindx binary_integer; indx binary_integer;
1821: begin

Line 1818: ddx_vcrv_tbl okl_vcr_pvt.vcrv_tbl_type;

1814: )
1815:
1816: as
1817: ddp_vcrv_tbl okl_vcr_pvt.vcrv_tbl_type;
1818: ddx_vcrv_tbl okl_vcr_pvt.vcrv_tbl_type;
1819: ddpx_error_tbl okl_api.error_tbl_type;
1820: ddindx binary_integer; indx binary_integer;
1821: begin
1822:

Line 1829: okl_vcr_pvt_w.rosetta_table_copy_in_p2(ddp_vcrv_tbl, p5_a0

1825:
1826:
1827:
1828:
1829: okl_vcr_pvt_w.rosetta_table_copy_in_p2(ddp_vcrv_tbl, p5_a0
1830: , p5_a1
1831: , p5_a2
1832: , p5_a3
1833: , p5_a4

Line 1879: okl_vcr_pvt.update_row(p_api_version,

1875: , p7_a6
1876: );
1877:
1878: -- here's the delegated call to the old PL/SQL routine
1879: okl_vcr_pvt.update_row(p_api_version,
1880: p_init_msg_list,
1881: x_return_status,
1882: x_msg_count,
1883: x_msg_data,

Line 1895: okl_vcr_pvt_w.rosetta_table_copy_out_p2(ddx_vcrv_tbl, p6_a0

1891:
1892:
1893:
1894:
1895: okl_vcr_pvt_w.rosetta_table_copy_out_p2(ddx_vcrv_tbl, p6_a0
1896: , p6_a1
1897: , p6_a2
1898: , p6_a3
1899: , p6_a4

Line 2026: ddp_vcrv_tbl okl_vcr_pvt.vcrv_tbl_type;

2022: , p6_a36 out nocopy JTF_NUMBER_TABLE
2023: )
2024:
2025: as
2026: ddp_vcrv_tbl okl_vcr_pvt.vcrv_tbl_type;
2027: ddx_vcrv_tbl okl_vcr_pvt.vcrv_tbl_type;
2028: ddindx binary_integer; indx binary_integer;
2029: begin
2030:

Line 2027: ddx_vcrv_tbl okl_vcr_pvt.vcrv_tbl_type;

2023: )
2024:
2025: as
2026: ddp_vcrv_tbl okl_vcr_pvt.vcrv_tbl_type;
2027: ddx_vcrv_tbl okl_vcr_pvt.vcrv_tbl_type;
2028: ddindx binary_integer; indx binary_integer;
2029: begin
2030:
2031: -- copy data to the local IN or IN-OUT args, if any

Line 2037: okl_vcr_pvt_w.rosetta_table_copy_in_p2(ddp_vcrv_tbl, p5_a0

2033:
2034:
2035:
2036:
2037: okl_vcr_pvt_w.rosetta_table_copy_in_p2(ddp_vcrv_tbl, p5_a0
2038: , p5_a1
2039: , p5_a2
2040: , p5_a3
2041: , p5_a4

Line 2078: okl_vcr_pvt.update_row(p_api_version,

2074: );
2075:
2076:
2077: -- here's the delegated call to the old PL/SQL routine
2078: okl_vcr_pvt.update_row(p_api_version,
2079: p_init_msg_list,
2080: x_return_status,
2081: x_msg_count,
2082: x_msg_data,

Line 2093: okl_vcr_pvt_w.rosetta_table_copy_out_p2(ddx_vcrv_tbl, p6_a0

2089:
2090:
2091:
2092:
2093: okl_vcr_pvt_w.rosetta_table_copy_out_p2(ddx_vcrv_tbl, p6_a0
2094: , p6_a1
2095: , p6_a2
2096: , p6_a3
2097: , p6_a4

Line 2178: ddp_vcrv_rec okl_vcr_pvt.vcrv_rec_type;

2174: , p5_a36 NUMBER
2175: )
2176:
2177: as
2178: ddp_vcrv_rec okl_vcr_pvt.vcrv_rec_type;
2179: ddindx binary_integer; indx binary_integer;
2180: begin
2181:
2182: -- copy data to the local IN or IN-OUT args, if any

Line 2227: okl_vcr_pvt.delete_row(p_api_version,

2223: ddp_vcrv_rec.last_update_date := p5_a35;
2224: ddp_vcrv_rec.last_update_login := p5_a36;
2225:
2226: -- here's the delegated call to the old PL/SQL routine
2227: okl_vcr_pvt.delete_row(p_api_version,
2228: p_init_msg_list,
2229: x_return_status,
2230: x_msg_count,
2231: x_msg_data,

Line 2294: ddp_vcrv_tbl okl_vcr_pvt.vcrv_tbl_type;

2290: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
2291: )
2292:
2293: as
2294: ddp_vcrv_tbl okl_vcr_pvt.vcrv_tbl_type;
2295: ddpx_error_tbl okl_api.error_tbl_type;
2296: ddindx binary_integer; indx binary_integer;
2297: begin
2298:

Line 2305: okl_vcr_pvt_w.rosetta_table_copy_in_p2(ddp_vcrv_tbl, p5_a0

2301:
2302:
2303:
2304:
2305: okl_vcr_pvt_w.rosetta_table_copy_in_p2(ddp_vcrv_tbl, p5_a0
2306: , p5_a1
2307: , p5_a2
2308: , p5_a3
2309: , p5_a4

Line 2354: okl_vcr_pvt.delete_row(p_api_version,

2350: , p6_a6
2351: );
2352:
2353: -- here's the delegated call to the old PL/SQL routine
2354: okl_vcr_pvt.delete_row(p_api_version,
2355: p_init_msg_list,
2356: x_return_status,
2357: x_msg_count,
2358: x_msg_data,

Line 2424: ddp_vcrv_tbl okl_vcr_pvt.vcrv_tbl_type;

2420: , p5_a36 JTF_NUMBER_TABLE
2421: )
2422:
2423: as
2424: ddp_vcrv_tbl okl_vcr_pvt.vcrv_tbl_type;
2425: ddindx binary_integer; indx binary_integer;
2426: begin
2427:
2428: -- copy data to the local IN or IN-OUT args, if any

Line 2434: okl_vcr_pvt_w.rosetta_table_copy_in_p2(ddp_vcrv_tbl, p5_a0

2430:
2431:
2432:
2433:
2434: okl_vcr_pvt_w.rosetta_table_copy_in_p2(ddp_vcrv_tbl, p5_a0
2435: , p5_a1
2436: , p5_a2
2437: , p5_a3
2438: , p5_a4

Line 2474: okl_vcr_pvt.delete_row(p_api_version,

2470: , p5_a36
2471: );
2472:
2473: -- here's the delegated call to the old PL/SQL routine
2474: okl_vcr_pvt.delete_row(p_api_version,
2475: p_init_msg_list,
2476: x_return_status,
2477: x_msg_count,
2478: x_msg_data,

Line 2534: ddp_vcrv_rec okl_vcr_pvt.vcrv_rec_type;

2530: , p5_a36 NUMBER
2531: )
2532:
2533: as
2534: ddp_vcrv_rec okl_vcr_pvt.vcrv_rec_type;
2535: ddindx binary_integer; indx binary_integer;
2536: begin
2537:
2538: -- copy data to the local IN or IN-OUT args, if any

Line 2583: okl_vcr_pvt.validate_row(p_api_version,

2579: ddp_vcrv_rec.last_update_date := p5_a35;
2580: ddp_vcrv_rec.last_update_login := p5_a36;
2581:
2582: -- here's the delegated call to the old PL/SQL routine
2583: okl_vcr_pvt.validate_row(p_api_version,
2584: p_init_msg_list,
2585: x_return_status,
2586: x_msg_count,
2587: x_msg_data,

Line 2650: ddp_vcrv_tbl okl_vcr_pvt.vcrv_tbl_type;

2646: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
2647: )
2648:
2649: as
2650: ddp_vcrv_tbl okl_vcr_pvt.vcrv_tbl_type;
2651: ddpx_error_tbl okl_api.error_tbl_type;
2652: ddindx binary_integer; indx binary_integer;
2653: begin
2654:

Line 2661: okl_vcr_pvt_w.rosetta_table_copy_in_p2(ddp_vcrv_tbl, p5_a0

2657:
2658:
2659:
2660:
2661: okl_vcr_pvt_w.rosetta_table_copy_in_p2(ddp_vcrv_tbl, p5_a0
2662: , p5_a1
2663: , p5_a2
2664: , p5_a3
2665: , p5_a4

Line 2710: okl_vcr_pvt.validate_row(p_api_version,

2706: , p6_a6
2707: );
2708:
2709: -- here's the delegated call to the old PL/SQL routine
2710: okl_vcr_pvt.validate_row(p_api_version,
2711: p_init_msg_list,
2712: x_return_status,
2713: x_msg_count,
2714: x_msg_data,

Line 2780: ddp_vcrv_tbl okl_vcr_pvt.vcrv_tbl_type;

2776: , p5_a36 JTF_NUMBER_TABLE
2777: )
2778:
2779: as
2780: ddp_vcrv_tbl okl_vcr_pvt.vcrv_tbl_type;
2781: ddindx binary_integer; indx binary_integer;
2782: begin
2783:
2784: -- copy data to the local IN or IN-OUT args, if any

Line 2790: okl_vcr_pvt_w.rosetta_table_copy_in_p2(ddp_vcrv_tbl, p5_a0

2786:
2787:
2788:
2789:
2790: okl_vcr_pvt_w.rosetta_table_copy_in_p2(ddp_vcrv_tbl, p5_a0
2791: , p5_a1
2792: , p5_a2
2793: , p5_a3
2794: , p5_a4

Line 2830: okl_vcr_pvt.validate_row(p_api_version,

2826: , p5_a36
2827: );
2828:
2829: -- here's the delegated call to the old PL/SQL routine
2830: okl_vcr_pvt.validate_row(p_api_version,
2831: p_init_msg_list,
2832: x_return_status,
2833: x_msg_count,
2834: x_msg_data,

Line 2845: end okl_vcr_pvt_w;

2841:
2842:
2843: end;
2844:
2845: end okl_vcr_pvt_w;