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_POC_PVT_W dependencies on OKL_POC_PVT

Line 1: package body okl_poc_pvt_w as

1: package body okl_poc_pvt_w as
2: /* $Header: OKLIPOCB.pls 120.3 2005/10/04 22:28:59 fmiao 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_poc_pvt.pocv_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_poc_pvt.pocv_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_NUMBER_TABLE

Line 119: procedure rosetta_table_copy_out_p2(t okl_poc_pvt.pocv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

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

Line 338: procedure rosetta_table_copy_in_p5(t out nocopy okl_poc_pvt.poc_tbl_type, a0 JTF_NUMBER_TABLE

334: end if;
335: end if;
336: end rosetta_table_copy_out_p2;
337:
338: procedure rosetta_table_copy_in_p5(t out nocopy okl_poc_pvt.poc_tbl_type, a0 JTF_NUMBER_TABLE
339: , a1 JTF_NUMBER_TABLE
340: , a2 JTF_NUMBER_TABLE
341: , a3 JTF_NUMBER_TABLE
342: , a4 JTF_NUMBER_TABLE

Line 435: procedure rosetta_table_copy_out_p5(t okl_poc_pvt.poc_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

431: end loop;
432: end if;
433: end if;
434: end rosetta_table_copy_in_p5;
435: procedure rosetta_table_copy_out_p5(t okl_poc_pvt.poc_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
436: , a1 out nocopy JTF_NUMBER_TABLE
437: , a2 out nocopy JTF_NUMBER_TABLE
438: , a3 out nocopy JTF_NUMBER_TABLE
439: , a4 out nocopy JTF_NUMBER_TABLE

Line 742: ddp_pocv_rec okl_poc_pvt.pocv_rec_type;

738: , p5_a39 NUMBER := 0-1962.0724
739: )
740:
741: as
742: ddp_pocv_rec okl_poc_pvt.pocv_rec_type;
743: ddx_pocv_rec okl_poc_pvt.pocv_rec_type;
744: ddindx binary_integer; indx binary_integer;
745: begin
746:

Line 743: ddx_pocv_rec okl_poc_pvt.pocv_rec_type;

739: )
740:
741: as
742: ddp_pocv_rec okl_poc_pvt.pocv_rec_type;
743: ddx_pocv_rec okl_poc_pvt.pocv_rec_type;
744: ddindx binary_integer; indx binary_integer;
745: begin
746:
747: -- copy data to the local IN or IN-OUT args, if any

Line 796: okl_poc_pvt.insert_row(p_api_version,

792: ddp_pocv_rec.last_update_login := rosetta_g_miss_num_map(p5_a39);
793:
794:
795: -- here's the delegated call to the old PL/SQL routine
796: okl_poc_pvt.insert_row(p_api_version,
797: p_init_msg_list,
798: x_return_status,
799: x_msg_count,
800: x_msg_data,

Line 948: ddp_pocv_tbl okl_poc_pvt.pocv_tbl_type;

944: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
945: )
946:
947: as
948: ddp_pocv_tbl okl_poc_pvt.pocv_tbl_type;
949: ddx_pocv_tbl okl_poc_pvt.pocv_tbl_type;
950: ddpx_error_tbl okl_api.error_tbl_type;
951: ddindx binary_integer; indx binary_integer;
952: begin

Line 949: ddx_pocv_tbl okl_poc_pvt.pocv_tbl_type;

945: )
946:
947: as
948: ddp_pocv_tbl okl_poc_pvt.pocv_tbl_type;
949: ddx_pocv_tbl okl_poc_pvt.pocv_tbl_type;
950: ddpx_error_tbl okl_api.error_tbl_type;
951: ddindx binary_integer; indx binary_integer;
952: begin
953:

Line 960: okl_poc_pvt_w.rosetta_table_copy_in_p2(ddp_pocv_tbl, p5_a0

956:
957:
958:
959:
960: okl_poc_pvt_w.rosetta_table_copy_in_p2(ddp_pocv_tbl, p5_a0
961: , p5_a1
962: , p5_a2
963: , p5_a3
964: , p5_a4

Line 1013: okl_poc_pvt.insert_row(p_api_version,

1009: , p7_a6
1010: );
1011:
1012: -- here's the delegated call to the old PL/SQL routine
1013: okl_poc_pvt.insert_row(p_api_version,
1014: p_init_msg_list,
1015: x_return_status,
1016: x_msg_count,
1017: x_msg_data,

Line 1029: okl_poc_pvt_w.rosetta_table_copy_out_p2(ddx_pocv_tbl, p6_a0

1025:
1026:
1027:
1028:
1029: okl_poc_pvt_w.rosetta_table_copy_out_p2(ddx_pocv_tbl, p6_a0
1030: , p6_a1
1031: , p6_a2
1032: , p6_a3
1033: , p6_a4

Line 1169: ddp_pocv_tbl okl_poc_pvt.pocv_tbl_type;

1165: , p6_a39 out nocopy JTF_NUMBER_TABLE
1166: )
1167:
1168: as
1169: ddp_pocv_tbl okl_poc_pvt.pocv_tbl_type;
1170: ddx_pocv_tbl okl_poc_pvt.pocv_tbl_type;
1171: ddindx binary_integer; indx binary_integer;
1172: begin
1173:

Line 1170: ddx_pocv_tbl okl_poc_pvt.pocv_tbl_type;

1166: )
1167:
1168: as
1169: ddp_pocv_tbl okl_poc_pvt.pocv_tbl_type;
1170: ddx_pocv_tbl okl_poc_pvt.pocv_tbl_type;
1171: ddindx binary_integer; indx binary_integer;
1172: begin
1173:
1174: -- copy data to the local IN or IN-OUT args, if any

Line 1180: okl_poc_pvt_w.rosetta_table_copy_in_p2(ddp_pocv_tbl, p5_a0

1176:
1177:
1178:
1179:
1180: okl_poc_pvt_w.rosetta_table_copy_in_p2(ddp_pocv_tbl, p5_a0
1181: , p5_a1
1182: , p5_a2
1183: , p5_a3
1184: , p5_a4

Line 1224: okl_poc_pvt.insert_row(p_api_version,

1220: );
1221:
1222:
1223: -- here's the delegated call to the old PL/SQL routine
1224: okl_poc_pvt.insert_row(p_api_version,
1225: p_init_msg_list,
1226: x_return_status,
1227: x_msg_count,
1228: x_msg_data,

Line 1239: okl_poc_pvt_w.rosetta_table_copy_out_p2(ddx_pocv_tbl, p6_a0

1235:
1236:
1237:
1238:
1239: okl_poc_pvt_w.rosetta_table_copy_out_p2(ddx_pocv_tbl, p6_a0
1240: , p6_a1
1241: , p6_a2
1242: , p6_a3
1243: , p6_a4

Line 1330: ddp_pocv_rec okl_poc_pvt.pocv_rec_type;

1326: , p5_a39 NUMBER := 0-1962.0724
1327: )
1328:
1329: as
1330: ddp_pocv_rec okl_poc_pvt.pocv_rec_type;
1331: ddindx binary_integer; indx binary_integer;
1332: begin
1333:
1334: -- copy data to the local IN or IN-OUT args, if any

Line 1382: okl_poc_pvt.lock_row(p_api_version,

1378: ddp_pocv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a38);
1379: ddp_pocv_rec.last_update_login := rosetta_g_miss_num_map(p5_a39);
1380:
1381: -- here's the delegated call to the old PL/SQL routine
1382: okl_poc_pvt.lock_row(p_api_version,
1383: p_init_msg_list,
1384: x_return_status,
1385: x_msg_count,
1386: x_msg_data,

Line 1452: ddp_pocv_tbl okl_poc_pvt.pocv_tbl_type;

1448: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
1449: )
1450:
1451: as
1452: ddp_pocv_tbl okl_poc_pvt.pocv_tbl_type;
1453: ddpx_error_tbl okl_api.error_tbl_type;
1454: ddindx binary_integer; indx binary_integer;
1455: begin
1456:

Line 1463: okl_poc_pvt_w.rosetta_table_copy_in_p2(ddp_pocv_tbl, p5_a0

1459:
1460:
1461:
1462:
1463: okl_poc_pvt_w.rosetta_table_copy_in_p2(ddp_pocv_tbl, p5_a0
1464: , p5_a1
1465: , p5_a2
1466: , p5_a3
1467: , p5_a4

Line 1515: okl_poc_pvt.lock_row(p_api_version,

1511: , p6_a6
1512: );
1513:
1514: -- here's the delegated call to the old PL/SQL routine
1515: okl_poc_pvt.lock_row(p_api_version,
1516: p_init_msg_list,
1517: x_return_status,
1518: x_msg_count,
1519: x_msg_data,

Line 1588: ddp_pocv_tbl okl_poc_pvt.pocv_tbl_type;

1584: , p5_a39 JTF_NUMBER_TABLE
1585: )
1586:
1587: as
1588: ddp_pocv_tbl okl_poc_pvt.pocv_tbl_type;
1589: ddindx binary_integer; indx binary_integer;
1590: begin
1591:
1592: -- copy data to the local IN or IN-OUT args, if any

Line 1598: okl_poc_pvt_w.rosetta_table_copy_in_p2(ddp_pocv_tbl, p5_a0

1594:
1595:
1596:
1597:
1598: okl_poc_pvt_w.rosetta_table_copy_in_p2(ddp_pocv_tbl, p5_a0
1599: , p5_a1
1600: , p5_a2
1601: , p5_a3
1602: , p5_a4

Line 1641: okl_poc_pvt.lock_row(p_api_version,

1637: , p5_a39
1638: );
1639:
1640: -- here's the delegated call to the old PL/SQL routine
1641: okl_poc_pvt.lock_row(p_api_version,
1642: p_init_msg_list,
1643: x_return_status,
1644: x_msg_count,
1645: x_msg_data,

Line 1744: ddp_pocv_rec okl_poc_pvt.pocv_rec_type;

1740: , p5_a39 NUMBER := 0-1962.0724
1741: )
1742:
1743: as
1744: ddp_pocv_rec okl_poc_pvt.pocv_rec_type;
1745: ddx_pocv_rec okl_poc_pvt.pocv_rec_type;
1746: ddindx binary_integer; indx binary_integer;
1747: begin
1748:

Line 1745: ddx_pocv_rec okl_poc_pvt.pocv_rec_type;

1741: )
1742:
1743: as
1744: ddp_pocv_rec okl_poc_pvt.pocv_rec_type;
1745: ddx_pocv_rec okl_poc_pvt.pocv_rec_type;
1746: ddindx binary_integer; indx binary_integer;
1747: begin
1748:
1749: -- copy data to the local IN or IN-OUT args, if any

Line 1798: okl_poc_pvt.update_row(p_api_version,

1794: ddp_pocv_rec.last_update_login := rosetta_g_miss_num_map(p5_a39);
1795:
1796:
1797: -- here's the delegated call to the old PL/SQL routine
1798: okl_poc_pvt.update_row(p_api_version,
1799: p_init_msg_list,
1800: x_return_status,
1801: x_msg_count,
1802: x_msg_data,

Line 1950: ddp_pocv_tbl okl_poc_pvt.pocv_tbl_type;

1946: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
1947: )
1948:
1949: as
1950: ddp_pocv_tbl okl_poc_pvt.pocv_tbl_type;
1951: ddx_pocv_tbl okl_poc_pvt.pocv_tbl_type;
1952: ddpx_error_tbl okl_api.error_tbl_type;
1953: ddindx binary_integer; indx binary_integer;
1954: begin

Line 1951: ddx_pocv_tbl okl_poc_pvt.pocv_tbl_type;

1947: )
1948:
1949: as
1950: ddp_pocv_tbl okl_poc_pvt.pocv_tbl_type;
1951: ddx_pocv_tbl okl_poc_pvt.pocv_tbl_type;
1952: ddpx_error_tbl okl_api.error_tbl_type;
1953: ddindx binary_integer; indx binary_integer;
1954: begin
1955:

Line 1962: okl_poc_pvt_w.rosetta_table_copy_in_p2(ddp_pocv_tbl, p5_a0

1958:
1959:
1960:
1961:
1962: okl_poc_pvt_w.rosetta_table_copy_in_p2(ddp_pocv_tbl, p5_a0
1963: , p5_a1
1964: , p5_a2
1965: , p5_a3
1966: , p5_a4

Line 2015: okl_poc_pvt.update_row(p_api_version,

2011: , p7_a6
2012: );
2013:
2014: -- here's the delegated call to the old PL/SQL routine
2015: okl_poc_pvt.update_row(p_api_version,
2016: p_init_msg_list,
2017: x_return_status,
2018: x_msg_count,
2019: x_msg_data,

Line 2031: okl_poc_pvt_w.rosetta_table_copy_out_p2(ddx_pocv_tbl, p6_a0

2027:
2028:
2029:
2030:
2031: okl_poc_pvt_w.rosetta_table_copy_out_p2(ddx_pocv_tbl, p6_a0
2032: , p6_a1
2033: , p6_a2
2034: , p6_a3
2035: , p6_a4

Line 2171: ddp_pocv_tbl okl_poc_pvt.pocv_tbl_type;

2167: , p6_a39 out nocopy JTF_NUMBER_TABLE
2168: )
2169:
2170: as
2171: ddp_pocv_tbl okl_poc_pvt.pocv_tbl_type;
2172: ddx_pocv_tbl okl_poc_pvt.pocv_tbl_type;
2173: ddindx binary_integer; indx binary_integer;
2174: begin
2175:

Line 2172: ddx_pocv_tbl okl_poc_pvt.pocv_tbl_type;

2168: )
2169:
2170: as
2171: ddp_pocv_tbl okl_poc_pvt.pocv_tbl_type;
2172: ddx_pocv_tbl okl_poc_pvt.pocv_tbl_type;
2173: ddindx binary_integer; indx binary_integer;
2174: begin
2175:
2176: -- copy data to the local IN or IN-OUT args, if any

Line 2182: okl_poc_pvt_w.rosetta_table_copy_in_p2(ddp_pocv_tbl, p5_a0

2178:
2179:
2180:
2181:
2182: okl_poc_pvt_w.rosetta_table_copy_in_p2(ddp_pocv_tbl, p5_a0
2183: , p5_a1
2184: , p5_a2
2185: , p5_a3
2186: , p5_a4

Line 2226: okl_poc_pvt.update_row(p_api_version,

2222: );
2223:
2224:
2225: -- here's the delegated call to the old PL/SQL routine
2226: okl_poc_pvt.update_row(p_api_version,
2227: p_init_msg_list,
2228: x_return_status,
2229: x_msg_count,
2230: x_msg_data,

Line 2241: okl_poc_pvt_w.rosetta_table_copy_out_p2(ddx_pocv_tbl, p6_a0

2237:
2238:
2239:
2240:
2241: okl_poc_pvt_w.rosetta_table_copy_out_p2(ddx_pocv_tbl, p6_a0
2242: , p6_a1
2243: , p6_a2
2244: , p6_a3
2245: , p6_a4

Line 2332: ddp_pocv_rec okl_poc_pvt.pocv_rec_type;

2328: , p5_a39 NUMBER := 0-1962.0724
2329: )
2330:
2331: as
2332: ddp_pocv_rec okl_poc_pvt.pocv_rec_type;
2333: ddindx binary_integer; indx binary_integer;
2334: begin
2335:
2336: -- copy data to the local IN or IN-OUT args, if any

Line 2384: okl_poc_pvt.delete_row(p_api_version,

2380: ddp_pocv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a38);
2381: ddp_pocv_rec.last_update_login := rosetta_g_miss_num_map(p5_a39);
2382:
2383: -- here's the delegated call to the old PL/SQL routine
2384: okl_poc_pvt.delete_row(p_api_version,
2385: p_init_msg_list,
2386: x_return_status,
2387: x_msg_count,
2388: x_msg_data,

Line 2454: ddp_pocv_tbl okl_poc_pvt.pocv_tbl_type;

2450: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
2451: )
2452:
2453: as
2454: ddp_pocv_tbl okl_poc_pvt.pocv_tbl_type;
2455: ddpx_error_tbl okl_api.error_tbl_type;
2456: ddindx binary_integer; indx binary_integer;
2457: begin
2458:

Line 2465: okl_poc_pvt_w.rosetta_table_copy_in_p2(ddp_pocv_tbl, p5_a0

2461:
2462:
2463:
2464:
2465: okl_poc_pvt_w.rosetta_table_copy_in_p2(ddp_pocv_tbl, p5_a0
2466: , p5_a1
2467: , p5_a2
2468: , p5_a3
2469: , p5_a4

Line 2517: okl_poc_pvt.delete_row(p_api_version,

2513: , p6_a6
2514: );
2515:
2516: -- here's the delegated call to the old PL/SQL routine
2517: okl_poc_pvt.delete_row(p_api_version,
2518: p_init_msg_list,
2519: x_return_status,
2520: x_msg_count,
2521: x_msg_data,

Line 2590: ddp_pocv_tbl okl_poc_pvt.pocv_tbl_type;

2586: , p5_a39 JTF_NUMBER_TABLE
2587: )
2588:
2589: as
2590: ddp_pocv_tbl okl_poc_pvt.pocv_tbl_type;
2591: ddindx binary_integer; indx binary_integer;
2592: begin
2593:
2594: -- copy data to the local IN or IN-OUT args, if any

Line 2600: okl_poc_pvt_w.rosetta_table_copy_in_p2(ddp_pocv_tbl, p5_a0

2596:
2597:
2598:
2599:
2600: okl_poc_pvt_w.rosetta_table_copy_in_p2(ddp_pocv_tbl, p5_a0
2601: , p5_a1
2602: , p5_a2
2603: , p5_a3
2604: , p5_a4

Line 2643: okl_poc_pvt.delete_row(p_api_version,

2639: , p5_a39
2640: );
2641:
2642: -- here's the delegated call to the old PL/SQL routine
2643: okl_poc_pvt.delete_row(p_api_version,
2644: p_init_msg_list,
2645: x_return_status,
2646: x_msg_count,
2647: x_msg_data,

Line 2706: ddp_pocv_rec okl_poc_pvt.pocv_rec_type;

2702: , p5_a39 NUMBER := 0-1962.0724
2703: )
2704:
2705: as
2706: ddp_pocv_rec okl_poc_pvt.pocv_rec_type;
2707: ddindx binary_integer; indx binary_integer;
2708: begin
2709:
2710: -- copy data to the local IN or IN-OUT args, if any

Line 2758: okl_poc_pvt.validate_row(p_api_version,

2754: ddp_pocv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a38);
2755: ddp_pocv_rec.last_update_login := rosetta_g_miss_num_map(p5_a39);
2756:
2757: -- here's the delegated call to the old PL/SQL routine
2758: okl_poc_pvt.validate_row(p_api_version,
2759: p_init_msg_list,
2760: x_return_status,
2761: x_msg_count,
2762: x_msg_data,

Line 2828: ddp_pocv_tbl okl_poc_pvt.pocv_tbl_type;

2824: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
2825: )
2826:
2827: as
2828: ddp_pocv_tbl okl_poc_pvt.pocv_tbl_type;
2829: ddpx_error_tbl okl_api.error_tbl_type;
2830: ddindx binary_integer; indx binary_integer;
2831: begin
2832:

Line 2839: okl_poc_pvt_w.rosetta_table_copy_in_p2(ddp_pocv_tbl, p5_a0

2835:
2836:
2837:
2838:
2839: okl_poc_pvt_w.rosetta_table_copy_in_p2(ddp_pocv_tbl, p5_a0
2840: , p5_a1
2841: , p5_a2
2842: , p5_a3
2843: , p5_a4

Line 2891: okl_poc_pvt.validate_row(p_api_version,

2887: , p6_a6
2888: );
2889:
2890: -- here's the delegated call to the old PL/SQL routine
2891: okl_poc_pvt.validate_row(p_api_version,
2892: p_init_msg_list,
2893: x_return_status,
2894: x_msg_count,
2895: x_msg_data,

Line 2964: ddp_pocv_tbl okl_poc_pvt.pocv_tbl_type;

2960: , p5_a39 JTF_NUMBER_TABLE
2961: )
2962:
2963: as
2964: ddp_pocv_tbl okl_poc_pvt.pocv_tbl_type;
2965: ddindx binary_integer; indx binary_integer;
2966: begin
2967:
2968: -- copy data to the local IN or IN-OUT args, if any

Line 2974: okl_poc_pvt_w.rosetta_table_copy_in_p2(ddp_pocv_tbl, p5_a0

2970:
2971:
2972:
2973:
2974: okl_poc_pvt_w.rosetta_table_copy_in_p2(ddp_pocv_tbl, p5_a0
2975: , p5_a1
2976: , p5_a2
2977: , p5_a3
2978: , p5_a4

Line 3017: okl_poc_pvt.validate_row(p_api_version,

3013: , p5_a39
3014: );
3015:
3016: -- here's the delegated call to the old PL/SQL routine
3017: okl_poc_pvt.validate_row(p_api_version,
3018: p_init_msg_list,
3019: x_return_status,
3020: x_msg_count,
3021: x_msg_data,

Line 3032: end okl_poc_pvt_w;

3028:
3029:
3030: end;
3031:
3032: end okl_poc_pvt_w;