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_SAO_PVT_W dependencies on OKL_SAO_PVT

Line 1: package body okl_sao_pvt_w as

1: package body okl_sao_pvt_w as
2: /* $Header: OKLISAOB.pls 120.5.12010000.2 2008/09/15 23:16:01 smereddy ship $ */
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_sao_pvt.sao_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_sao_pvt.sao_tbl_type, a0 JTF_NUMBER_TABLE
26: , a1 JTF_VARCHAR2_TABLE_100
27: , a2 JTF_NUMBER_TABLE
28: , a3 JTF_VARCHAR2_TABLE_100
29: , a4 JTF_NUMBER_TABLE

Line 158: procedure rosetta_table_copy_out_p2(t okl_sao_pvt.sao_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

154: end loop;
155: end if;
156: end if;
157: end rosetta_table_copy_in_p2;
158: procedure rosetta_table_copy_out_p2(t okl_sao_pvt.sao_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
159: , a1 out nocopy JTF_VARCHAR2_TABLE_100
160: , a2 out nocopy JTF_NUMBER_TABLE
161: , a3 out nocopy JTF_VARCHAR2_TABLE_100
162: , a4 out nocopy JTF_NUMBER_TABLE

Line 467: procedure rosetta_table_copy_in_p5(t out nocopy okl_sao_pvt.saov_tbl_type, a0 JTF_NUMBER_TABLE

463: end if;
464: end if;
465: end rosetta_table_copy_out_p2;
466:
467: procedure rosetta_table_copy_in_p5(t out nocopy okl_sao_pvt.saov_tbl_type, a0 JTF_NUMBER_TABLE
468: , a1 JTF_NUMBER_TABLE
469: , a2 JTF_NUMBER_TABLE
470: , a3 JTF_NUMBER_TABLE
471: , a4 JTF_VARCHAR2_TABLE_100

Line 600: procedure rosetta_table_copy_out_p5(t okl_sao_pvt.saov_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

596: end loop;
597: end if;
598: end if;
599: end rosetta_table_copy_in_p5;
600: procedure rosetta_table_copy_out_p5(t okl_sao_pvt.saov_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
601: , a1 out nocopy JTF_NUMBER_TABLE
602: , a2 out nocopy JTF_NUMBER_TABLE
603: , a3 out nocopy JTF_NUMBER_TABLE
604: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 1033: ddp_saov_rec okl_sao_pvt.saov_rec_type;

1029: , p5_a57 VARCHAR2 := fnd_api.g_miss_char
1030: )
1031:
1032: as
1033: ddp_saov_rec okl_sao_pvt.saov_rec_type;
1034: ddx_saov_rec okl_sao_pvt.saov_rec_type;
1035: ddindx binary_integer; indx binary_integer;
1036: begin
1037:

Line 1034: ddx_saov_rec okl_sao_pvt.saov_rec_type;

1030: )
1031:
1032: as
1033: ddp_saov_rec okl_sao_pvt.saov_rec_type;
1034: ddx_saov_rec okl_sao_pvt.saov_rec_type;
1035: ddindx binary_integer; indx binary_integer;
1036: begin
1037:
1038: -- copy data to the local IN or IN-OUT args, if any

Line 1105: okl_sao_pvt.insert_row(p_api_version,

1101: ddp_saov_rec.secondary_rep_method := p5_a57;
1102:
1103:
1104: -- here's the delegated call to the old PL/SQL routine
1105: okl_sao_pvt.insert_row(p_api_version,
1106: p_init_msg_list,
1107: x_return_status,
1108: x_msg_count,
1109: x_msg_data,

Line 1304: ddp_saov_tbl okl_sao_pvt.saov_tbl_type;

1300: , p6_a57 out nocopy JTF_VARCHAR2_TABLE_100
1301: )
1302:
1303: as
1304: ddp_saov_tbl okl_sao_pvt.saov_tbl_type;
1305: ddx_saov_tbl okl_sao_pvt.saov_tbl_type;
1306: ddindx binary_integer; indx binary_integer;
1307: begin
1308:

Line 1305: ddx_saov_tbl okl_sao_pvt.saov_tbl_type;

1301: )
1302:
1303: as
1304: ddp_saov_tbl okl_sao_pvt.saov_tbl_type;
1305: ddx_saov_tbl okl_sao_pvt.saov_tbl_type;
1306: ddindx binary_integer; indx binary_integer;
1307: begin
1308:
1309: -- copy data to the local IN or IN-OUT args, if any

Line 1315: okl_sao_pvt_w.rosetta_table_copy_in_p5(ddp_saov_tbl, p5_a0

1311:
1312:
1313:
1314:
1315: okl_sao_pvt_w.rosetta_table_copy_in_p5(ddp_saov_tbl, p5_a0
1316: , p5_a1
1317: , p5_a2
1318: , p5_a3
1319: , p5_a4

Line 1377: okl_sao_pvt.insert_row(p_api_version,

1373: );
1374:
1375:
1376: -- here's the delegated call to the old PL/SQL routine
1377: okl_sao_pvt.insert_row(p_api_version,
1378: p_init_msg_list,
1379: x_return_status,
1380: x_msg_count,
1381: x_msg_data,

Line 1392: okl_sao_pvt_w.rosetta_table_copy_out_p5(ddx_saov_tbl, p6_a0

1388:
1389:
1390:
1391:
1392: okl_sao_pvt_w.rosetta_table_copy_out_p5(ddx_saov_tbl, p6_a0
1393: , p6_a1
1394: , p6_a2
1395: , p6_a3
1396: , p6_a4

Line 1519: ddp_saov_rec okl_sao_pvt.saov_rec_type;

1515: , p5_a57 VARCHAR2 := fnd_api.g_miss_char
1516: )
1517:
1518: as
1519: ddp_saov_rec okl_sao_pvt.saov_rec_type;
1520: ddindx binary_integer; indx binary_integer;
1521: begin
1522:
1523: -- copy data to the local IN or IN-OUT args, if any

Line 1589: okl_sao_pvt.lock_row(p_api_version,

1585: ddp_saov_rec.pay_dist_set_id := rosetta_g_miss_num_map(p5_a56);
1586: ddp_saov_rec.secondary_rep_method := p5_a57;
1587:
1588: -- here's the delegated call to the old PL/SQL routine
1589: okl_sao_pvt.lock_row(p_api_version,
1590: p_init_msg_list,
1591: x_return_status,
1592: x_msg_count,
1593: x_msg_data,

Line 1670: ddp_saov_tbl okl_sao_pvt.saov_tbl_type;

1666: , p5_a57 JTF_VARCHAR2_TABLE_100
1667: )
1668:
1669: as
1670: ddp_saov_tbl okl_sao_pvt.saov_tbl_type;
1671: ddindx binary_integer; indx binary_integer;
1672: begin
1673:
1674: -- copy data to the local IN or IN-OUT args, if any

Line 1680: okl_sao_pvt_w.rosetta_table_copy_in_p5(ddp_saov_tbl, p5_a0

1676:
1677:
1678:
1679:
1680: okl_sao_pvt_w.rosetta_table_copy_in_p5(ddp_saov_tbl, p5_a0
1681: , p5_a1
1682: , p5_a2
1683: , p5_a3
1684: , p5_a4

Line 1741: okl_sao_pvt.lock_row(p_api_version,

1737: , p5_a57
1738: );
1739:
1740: -- here's the delegated call to the old PL/SQL routine
1741: okl_sao_pvt.lock_row(p_api_version,
1742: p_init_msg_list,
1743: x_return_status,
1744: x_msg_count,
1745: x_msg_data,

Line 1880: ddp_saov_rec okl_sao_pvt.saov_rec_type;

1876: , p5_a57 VARCHAR2 := fnd_api.g_miss_char
1877: )
1878:
1879: as
1880: ddp_saov_rec okl_sao_pvt.saov_rec_type;
1881: ddx_saov_rec okl_sao_pvt.saov_rec_type;
1882: ddindx binary_integer; indx binary_integer;
1883: begin
1884:

Line 1881: ddx_saov_rec okl_sao_pvt.saov_rec_type;

1877: )
1878:
1879: as
1880: ddp_saov_rec okl_sao_pvt.saov_rec_type;
1881: ddx_saov_rec okl_sao_pvt.saov_rec_type;
1882: ddindx binary_integer; indx binary_integer;
1883: begin
1884:
1885: -- copy data to the local IN or IN-OUT args, if any

Line 1952: okl_sao_pvt.update_row(p_api_version,

1948: ddp_saov_rec.secondary_rep_method := p5_a57;
1949:
1950:
1951: -- here's the delegated call to the old PL/SQL routine
1952: okl_sao_pvt.update_row(p_api_version,
1953: p_init_msg_list,
1954: x_return_status,
1955: x_msg_count,
1956: x_msg_data,

Line 2151: ddp_saov_tbl okl_sao_pvt.saov_tbl_type;

2147: , p6_a57 out nocopy JTF_VARCHAR2_TABLE_100
2148: )
2149:
2150: as
2151: ddp_saov_tbl okl_sao_pvt.saov_tbl_type;
2152: ddx_saov_tbl okl_sao_pvt.saov_tbl_type;
2153: ddindx binary_integer; indx binary_integer;
2154: begin
2155:

Line 2152: ddx_saov_tbl okl_sao_pvt.saov_tbl_type;

2148: )
2149:
2150: as
2151: ddp_saov_tbl okl_sao_pvt.saov_tbl_type;
2152: ddx_saov_tbl okl_sao_pvt.saov_tbl_type;
2153: ddindx binary_integer; indx binary_integer;
2154: begin
2155:
2156: -- copy data to the local IN or IN-OUT args, if any

Line 2162: okl_sao_pvt_w.rosetta_table_copy_in_p5(ddp_saov_tbl, p5_a0

2158:
2159:
2160:
2161:
2162: okl_sao_pvt_w.rosetta_table_copy_in_p5(ddp_saov_tbl, p5_a0
2163: , p5_a1
2164: , p5_a2
2165: , p5_a3
2166: , p5_a4

Line 2224: okl_sao_pvt.update_row(p_api_version,

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

Line 2239: okl_sao_pvt_w.rosetta_table_copy_out_p5(ddx_saov_tbl, p6_a0

2235:
2236:
2237:
2238:
2239: okl_sao_pvt_w.rosetta_table_copy_out_p5(ddx_saov_tbl, p6_a0
2240: , p6_a1
2241: , p6_a2
2242: , p6_a3
2243: , p6_a4

Line 2366: ddp_saov_rec okl_sao_pvt.saov_rec_type;

2362: , p5_a57 VARCHAR2 := fnd_api.g_miss_char
2363: )
2364:
2365: as
2366: ddp_saov_rec okl_sao_pvt.saov_rec_type;
2367: ddindx binary_integer; indx binary_integer;
2368: begin
2369:
2370: -- copy data to the local IN or IN-OUT args, if any

Line 2436: okl_sao_pvt.delete_row(p_api_version,

2432: ddp_saov_rec.pay_dist_set_id := rosetta_g_miss_num_map(p5_a56);
2433: ddp_saov_rec.secondary_rep_method := p5_a57;
2434:
2435: -- here's the delegated call to the old PL/SQL routine
2436: okl_sao_pvt.delete_row(p_api_version,
2437: p_init_msg_list,
2438: x_return_status,
2439: x_msg_count,
2440: x_msg_data,

Line 2517: ddp_saov_tbl okl_sao_pvt.saov_tbl_type;

2513: , p5_a57 JTF_VARCHAR2_TABLE_100
2514: )
2515:
2516: as
2517: ddp_saov_tbl okl_sao_pvt.saov_tbl_type;
2518: ddindx binary_integer; indx binary_integer;
2519: begin
2520:
2521: -- copy data to the local IN or IN-OUT args, if any

Line 2527: okl_sao_pvt_w.rosetta_table_copy_in_p5(ddp_saov_tbl, p5_a0

2523:
2524:
2525:
2526:
2527: okl_sao_pvt_w.rosetta_table_copy_in_p5(ddp_saov_tbl, p5_a0
2528: , p5_a1
2529: , p5_a2
2530: , p5_a3
2531: , p5_a4

Line 2588: okl_sao_pvt.delete_row(p_api_version,

2584: , p5_a57
2585: );
2586:
2587: -- here's the delegated call to the old PL/SQL routine
2588: okl_sao_pvt.delete_row(p_api_version,
2589: p_init_msg_list,
2590: x_return_status,
2591: x_msg_count,
2592: x_msg_data,

Line 2669: ddp_saov_rec okl_sao_pvt.saov_rec_type;

2665: , p5_a57 VARCHAR2 := fnd_api.g_miss_char
2666: )
2667:
2668: as
2669: ddp_saov_rec okl_sao_pvt.saov_rec_type;
2670: ddindx binary_integer; indx binary_integer;
2671: begin
2672:
2673: -- copy data to the local IN or IN-OUT args, if any

Line 2739: okl_sao_pvt.validate_row(p_api_version,

2735: ddp_saov_rec.pay_dist_set_id := rosetta_g_miss_num_map(p5_a56);
2736: ddp_saov_rec.secondary_rep_method := p5_a57;
2737:
2738: -- here's the delegated call to the old PL/SQL routine
2739: okl_sao_pvt.validate_row(p_api_version,
2740: p_init_msg_list,
2741: x_return_status,
2742: x_msg_count,
2743: x_msg_data,

Line 2820: ddp_saov_tbl okl_sao_pvt.saov_tbl_type;

2816: , p5_a57 JTF_VARCHAR2_TABLE_100
2817: )
2818:
2819: as
2820: ddp_saov_tbl okl_sao_pvt.saov_tbl_type;
2821: ddindx binary_integer; indx binary_integer;
2822: begin
2823:
2824: -- copy data to the local IN or IN-OUT args, if any

Line 2830: okl_sao_pvt_w.rosetta_table_copy_in_p5(ddp_saov_tbl, p5_a0

2826:
2827:
2828:
2829:
2830: okl_sao_pvt_w.rosetta_table_copy_in_p5(ddp_saov_tbl, p5_a0
2831: , p5_a1
2832: , p5_a2
2833: , p5_a3
2834: , p5_a4

Line 2891: okl_sao_pvt.validate_row(p_api_version,

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

Line 2906: end okl_sao_pvt_w;

2902:
2903:
2904: end;
2905:
2906: end okl_sao_pvt_w;