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.7 2009/05/08 10:50:16 rpillay 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 160: procedure rosetta_table_copy_out_p2(t okl_sao_pvt.sao_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

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

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

470: end if;
471: end if;
472: end rosetta_table_copy_out_p2;
473:
474: procedure rosetta_table_copy_in_p5(t out nocopy okl_sao_pvt.saov_tbl_type, a0 JTF_NUMBER_TABLE
475: , a1 JTF_NUMBER_TABLE
476: , a2 JTF_NUMBER_TABLE
477: , a3 JTF_NUMBER_TABLE
478: , a4 JTF_VARCHAR2_TABLE_100

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

605: end loop;
606: end if;
607: end if;
608: end rosetta_table_copy_in_p5;
609: procedure rosetta_table_copy_out_p5(t okl_sao_pvt.saov_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
610: , a1 out nocopy JTF_NUMBER_TABLE
611: , a2 out nocopy JTF_NUMBER_TABLE
612: , a3 out nocopy JTF_NUMBER_TABLE
613: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 1049: ddp_saov_rec okl_sao_pvt.saov_rec_type;

1045: , p5_a58 VARCHAR2 := fnd_api.g_miss_char
1046: )
1047:
1048: as
1049: ddp_saov_rec okl_sao_pvt.saov_rec_type;
1050: ddx_saov_rec okl_sao_pvt.saov_rec_type;
1051: ddindx binary_integer; indx binary_integer;
1052: begin
1053:

Line 1050: ddx_saov_rec okl_sao_pvt.saov_rec_type;

1046: )
1047:
1048: as
1049: ddp_saov_rec okl_sao_pvt.saov_rec_type;
1050: ddx_saov_rec okl_sao_pvt.saov_rec_type;
1051: ddindx binary_integer; indx binary_integer;
1052: begin
1053:
1054: -- copy data to the local IN or IN-OUT args, if any

Line 1122: okl_sao_pvt.insert_row(p_api_version,

1118: ddp_saov_rec.amort_inc_adj_rev_dt_yn := p5_a58;
1119:
1120:
1121: -- here's the delegated call to the old PL/SQL routine
1122: okl_sao_pvt.insert_row(p_api_version,
1123: p_init_msg_list,
1124: x_return_status,
1125: x_msg_count,
1126: x_msg_data,

Line 1324: ddp_saov_tbl okl_sao_pvt.saov_tbl_type;

1320: , p6_a58 out nocopy JTF_VARCHAR2_TABLE_100
1321: )
1322:
1323: as
1324: ddp_saov_tbl okl_sao_pvt.saov_tbl_type;
1325: ddx_saov_tbl okl_sao_pvt.saov_tbl_type;
1326: ddindx binary_integer; indx binary_integer;
1327: begin
1328:

Line 1325: ddx_saov_tbl okl_sao_pvt.saov_tbl_type;

1321: )
1322:
1323: as
1324: ddp_saov_tbl okl_sao_pvt.saov_tbl_type;
1325: ddx_saov_tbl okl_sao_pvt.saov_tbl_type;
1326: ddindx binary_integer; indx binary_integer;
1327: begin
1328:
1329: -- copy data to the local IN or IN-OUT args, if any

Line 1335: okl_sao_pvt_w.rosetta_table_copy_in_p5(ddp_saov_tbl, p5_a0

1331:
1332:
1333:
1334:
1335: okl_sao_pvt_w.rosetta_table_copy_in_p5(ddp_saov_tbl, p5_a0
1336: , p5_a1
1337: , p5_a2
1338: , p5_a3
1339: , p5_a4

Line 1398: okl_sao_pvt.insert_row(p_api_version,

1394: );
1395:
1396:
1397: -- here's the delegated call to the old PL/SQL routine
1398: okl_sao_pvt.insert_row(p_api_version,
1399: p_init_msg_list,
1400: x_return_status,
1401: x_msg_count,
1402: x_msg_data,

Line 1413: okl_sao_pvt_w.rosetta_table_copy_out_p5(ddx_saov_tbl, p6_a0

1409:
1410:
1411:
1412:
1413: okl_sao_pvt_w.rosetta_table_copy_out_p5(ddx_saov_tbl, p6_a0
1414: , p6_a1
1415: , p6_a2
1416: , p6_a3
1417: , p6_a4

Line 1542: ddp_saov_rec okl_sao_pvt.saov_rec_type;

1538: , p5_a58 VARCHAR2 := fnd_api.g_miss_char
1539: )
1540:
1541: as
1542: ddp_saov_rec okl_sao_pvt.saov_rec_type;
1543: ddindx binary_integer; indx binary_integer;
1544: begin
1545:
1546: -- copy data to the local IN or IN-OUT args, if any

Line 1613: okl_sao_pvt.lock_row(p_api_version,

1609: ddp_saov_rec.secondary_rep_method := p5_a57;
1610: ddp_saov_rec.amort_inc_adj_rev_dt_yn := p5_a58;
1611:
1612: -- here's the delegated call to the old PL/SQL routine
1613: okl_sao_pvt.lock_row(p_api_version,
1614: p_init_msg_list,
1615: x_return_status,
1616: x_msg_count,
1617: x_msg_data,

Line 1695: ddp_saov_tbl okl_sao_pvt.saov_tbl_type;

1691: , p5_a58 JTF_VARCHAR2_TABLE_100
1692: )
1693:
1694: as
1695: ddp_saov_tbl okl_sao_pvt.saov_tbl_type;
1696: ddindx binary_integer; indx binary_integer;
1697: begin
1698:
1699: -- copy data to the local IN or IN-OUT args, if any

Line 1705: okl_sao_pvt_w.rosetta_table_copy_in_p5(ddp_saov_tbl, p5_a0

1701:
1702:
1703:
1704:
1705: okl_sao_pvt_w.rosetta_table_copy_in_p5(ddp_saov_tbl, p5_a0
1706: , p5_a1
1707: , p5_a2
1708: , p5_a3
1709: , p5_a4

Line 1767: okl_sao_pvt.lock_row(p_api_version,

1763: , p5_a58
1764: );
1765:
1766: -- here's the delegated call to the old PL/SQL routine
1767: okl_sao_pvt.lock_row(p_api_version,
1768: p_init_msg_list,
1769: x_return_status,
1770: x_msg_count,
1771: x_msg_data,

Line 1908: ddp_saov_rec okl_sao_pvt.saov_rec_type;

1904: , p5_a58 VARCHAR2 := fnd_api.g_miss_char
1905: )
1906:
1907: as
1908: ddp_saov_rec okl_sao_pvt.saov_rec_type;
1909: ddx_saov_rec okl_sao_pvt.saov_rec_type;
1910: ddindx binary_integer; indx binary_integer;
1911: begin
1912:

Line 1909: ddx_saov_rec okl_sao_pvt.saov_rec_type;

1905: )
1906:
1907: as
1908: ddp_saov_rec okl_sao_pvt.saov_rec_type;
1909: ddx_saov_rec okl_sao_pvt.saov_rec_type;
1910: ddindx binary_integer; indx binary_integer;
1911: begin
1912:
1913: -- copy data to the local IN or IN-OUT args, if any

Line 1981: okl_sao_pvt.update_row(p_api_version,

1977: ddp_saov_rec.amort_inc_adj_rev_dt_yn := p5_a58;
1978:
1979:
1980: -- here's the delegated call to the old PL/SQL routine
1981: okl_sao_pvt.update_row(p_api_version,
1982: p_init_msg_list,
1983: x_return_status,
1984: x_msg_count,
1985: x_msg_data,

Line 2183: ddp_saov_tbl okl_sao_pvt.saov_tbl_type;

2179: , p6_a58 out nocopy JTF_VARCHAR2_TABLE_100
2180: )
2181:
2182: as
2183: ddp_saov_tbl okl_sao_pvt.saov_tbl_type;
2184: ddx_saov_tbl okl_sao_pvt.saov_tbl_type;
2185: ddindx binary_integer; indx binary_integer;
2186: begin
2187:

Line 2184: ddx_saov_tbl okl_sao_pvt.saov_tbl_type;

2180: )
2181:
2182: as
2183: ddp_saov_tbl okl_sao_pvt.saov_tbl_type;
2184: ddx_saov_tbl okl_sao_pvt.saov_tbl_type;
2185: ddindx binary_integer; indx binary_integer;
2186: begin
2187:
2188: -- copy data to the local IN or IN-OUT args, if any

Line 2194: okl_sao_pvt_w.rosetta_table_copy_in_p5(ddp_saov_tbl, p5_a0

2190:
2191:
2192:
2193:
2194: okl_sao_pvt_w.rosetta_table_copy_in_p5(ddp_saov_tbl, p5_a0
2195: , p5_a1
2196: , p5_a2
2197: , p5_a3
2198: , p5_a4

Line 2257: okl_sao_pvt.update_row(p_api_version,

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

Line 2272: okl_sao_pvt_w.rosetta_table_copy_out_p5(ddx_saov_tbl, p6_a0

2268:
2269:
2270:
2271:
2272: okl_sao_pvt_w.rosetta_table_copy_out_p5(ddx_saov_tbl, p6_a0
2273: , p6_a1
2274: , p6_a2
2275: , p6_a3
2276: , p6_a4

Line 2401: ddp_saov_rec okl_sao_pvt.saov_rec_type;

2397: , p5_a58 VARCHAR2 := fnd_api.g_miss_char
2398: )
2399:
2400: as
2401: ddp_saov_rec okl_sao_pvt.saov_rec_type;
2402: ddindx binary_integer; indx binary_integer;
2403: begin
2404:
2405: -- copy data to the local IN or IN-OUT args, if any

Line 2472: okl_sao_pvt.delete_row(p_api_version,

2468: ddp_saov_rec.secondary_rep_method := p5_a57;
2469: ddp_saov_rec.amort_inc_adj_rev_dt_yn := p5_a58;
2470:
2471: -- here's the delegated call to the old PL/SQL routine
2472: okl_sao_pvt.delete_row(p_api_version,
2473: p_init_msg_list,
2474: x_return_status,
2475: x_msg_count,
2476: x_msg_data,

Line 2554: ddp_saov_tbl okl_sao_pvt.saov_tbl_type;

2550: , p5_a58 JTF_VARCHAR2_TABLE_100
2551: )
2552:
2553: as
2554: ddp_saov_tbl okl_sao_pvt.saov_tbl_type;
2555: ddindx binary_integer; indx binary_integer;
2556: begin
2557:
2558: -- copy data to the local IN or IN-OUT args, if any

Line 2564: okl_sao_pvt_w.rosetta_table_copy_in_p5(ddp_saov_tbl, p5_a0

2560:
2561:
2562:
2563:
2564: okl_sao_pvt_w.rosetta_table_copy_in_p5(ddp_saov_tbl, p5_a0
2565: , p5_a1
2566: , p5_a2
2567: , p5_a3
2568: , p5_a4

Line 2626: okl_sao_pvt.delete_row(p_api_version,

2622: , p5_a58
2623: );
2624:
2625: -- here's the delegated call to the old PL/SQL routine
2626: okl_sao_pvt.delete_row(p_api_version,
2627: p_init_msg_list,
2628: x_return_status,
2629: x_msg_count,
2630: x_msg_data,

Line 2708: ddp_saov_rec okl_sao_pvt.saov_rec_type;

2704: , p5_a58 VARCHAR2 := fnd_api.g_miss_char
2705: )
2706:
2707: as
2708: ddp_saov_rec okl_sao_pvt.saov_rec_type;
2709: ddindx binary_integer; indx binary_integer;
2710: begin
2711:
2712: -- copy data to the local IN or IN-OUT args, if any

Line 2779: okl_sao_pvt.validate_row(p_api_version,

2775: ddp_saov_rec.secondary_rep_method := p5_a57;
2776: ddp_saov_rec.amort_inc_adj_rev_dt_yn := p5_a58;
2777:
2778: -- here's the delegated call to the old PL/SQL routine
2779: okl_sao_pvt.validate_row(p_api_version,
2780: p_init_msg_list,
2781: x_return_status,
2782: x_msg_count,
2783: x_msg_data,

Line 2861: ddp_saov_tbl okl_sao_pvt.saov_tbl_type;

2857: , p5_a58 JTF_VARCHAR2_TABLE_100
2858: )
2859:
2860: as
2861: ddp_saov_tbl okl_sao_pvt.saov_tbl_type;
2862: ddindx binary_integer; indx binary_integer;
2863: begin
2864:
2865: -- copy data to the local IN or IN-OUT args, if any

Line 2871: okl_sao_pvt_w.rosetta_table_copy_in_p5(ddp_saov_tbl, p5_a0

2867:
2868:
2869:
2870:
2871: okl_sao_pvt_w.rosetta_table_copy_in_p5(ddp_saov_tbl, p5_a0
2872: , p5_a1
2873: , p5_a2
2874: , p5_a3
2875: , p5_a4

Line 2933: okl_sao_pvt.validate_row(p_api_version,

2929: , p5_a58
2930: );
2931:
2932: -- here's the delegated call to the old PL/SQL routine
2933: okl_sao_pvt.validate_row(p_api_version,
2934: p_init_msg_list,
2935: x_return_status,
2936: x_msg_count,
2937: x_msg_data,

Line 2948: end okl_sao_pvt_w;

2944:
2945:
2946: end;
2947:
2948: end okl_sao_pvt_w;