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_ASD_PVT_W dependencies on OKL_ASD_PVT

Line 1: package body okl_asd_pvt_w as

1: package body okl_asd_pvt_w as
2: /* $Header: OKLIASDB.pls 115.6 2002/12/20 19:22:04 avsingh 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_asd_pvt.asd_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_asd_pvt.asd_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_asd_pvt.asd_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_asd_pvt.asd_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_asd_pvt.okl_txd_assets_tl_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_asd_pvt.okl_txd_assets_tl_tbl_type, a0 JTF_NUMBER_TABLE
339: , a1 JTF_VARCHAR2_TABLE_100
340: , a2 JTF_VARCHAR2_TABLE_100
341: , a3 JTF_VARCHAR2_TABLE_100
342: , a4 JTF_VARCHAR2_TABLE_2000

Line 375: procedure rosetta_table_copy_out_p5(t okl_asd_pvt.okl_txd_assets_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

371: end loop;
372: end if;
373: end if;
374: end rosetta_table_copy_in_p5;
375: procedure rosetta_table_copy_out_p5(t okl_asd_pvt.okl_txd_assets_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
376: , a1 out nocopy JTF_VARCHAR2_TABLE_100
377: , a2 out nocopy JTF_VARCHAR2_TABLE_100
378: , a3 out nocopy JTF_VARCHAR2_TABLE_100
379: , a4 out nocopy JTF_VARCHAR2_TABLE_2000

Line 444: procedure rosetta_table_copy_in_p8(t out nocopy okl_asd_pvt.asdv_tbl_type, a0 JTF_NUMBER_TABLE

440: end if;
441: end if;
442: end rosetta_table_copy_out_p5;
443:
444: procedure rosetta_table_copy_in_p8(t out nocopy okl_asd_pvt.asdv_tbl_type, a0 JTF_NUMBER_TABLE
445: , a1 JTF_NUMBER_TABLE
446: , a2 JTF_VARCHAR2_TABLE_100
447: , a3 JTF_NUMBER_TABLE
448: , a4 JTF_NUMBER_TABLE

Line 545: procedure rosetta_table_copy_out_p8(t okl_asd_pvt.asdv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

541: end loop;
542: end if;
543: end if;
544: end rosetta_table_copy_in_p8;
545: procedure rosetta_table_copy_out_p8(t okl_asd_pvt.asdv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
546: , a1 out nocopy JTF_NUMBER_TABLE
547: , a2 out nocopy JTF_VARCHAR2_TABLE_100
548: , a3 out nocopy JTF_NUMBER_TABLE
549: , a4 out nocopy JTF_NUMBER_TABLE

Line 866: ddp_asdv_rec okl_asd_pvt.asdv_rec_type;

862: , p5_a41 DATE := fnd_api.g_miss_date
863: )
864:
865: as
866: ddp_asdv_rec okl_asd_pvt.asdv_rec_type;
867: ddx_asdv_rec okl_asd_pvt.asdv_rec_type;
868: ddindx binary_integer; indx binary_integer;
869: begin
870:

Line 867: ddx_asdv_rec okl_asd_pvt.asdv_rec_type;

863: )
864:
865: as
866: ddp_asdv_rec okl_asd_pvt.asdv_rec_type;
867: ddx_asdv_rec okl_asd_pvt.asdv_rec_type;
868: ddindx binary_integer; indx binary_integer;
869: begin
870:
871: -- copy data to the local IN or IN-OUT args, if any

Line 922: okl_asd_pvt.insert_row(p_api_version,

918: ddp_asdv_rec.currency_conversion_date := rosetta_g_miss_date_in_map(p5_a41);
919:
920:
921: -- here's the delegated call to the old PL/SQL routine
922: okl_asd_pvt.insert_row(p_api_version,
923: p_init_msg_list,
924: x_return_status,
925: x_msg_count,
926: x_msg_data,

Line 1073: ddp_asdv_tbl okl_asd_pvt.asdv_tbl_type;

1069: , p6_a41 out nocopy JTF_DATE_TABLE
1070: )
1071:
1072: as
1073: ddp_asdv_tbl okl_asd_pvt.asdv_tbl_type;
1074: ddx_asdv_tbl okl_asd_pvt.asdv_tbl_type;
1075: ddindx binary_integer; indx binary_integer;
1076: begin
1077:

Line 1074: ddx_asdv_tbl okl_asd_pvt.asdv_tbl_type;

1070: )
1071:
1072: as
1073: ddp_asdv_tbl okl_asd_pvt.asdv_tbl_type;
1074: ddx_asdv_tbl okl_asd_pvt.asdv_tbl_type;
1075: ddindx binary_integer; indx binary_integer;
1076: begin
1077:
1078: -- copy data to the local IN or IN-OUT args, if any

Line 1084: okl_asd_pvt_w.rosetta_table_copy_in_p8(ddp_asdv_tbl, p5_a0

1080:
1081:
1082:
1083:
1084: okl_asd_pvt_w.rosetta_table_copy_in_p8(ddp_asdv_tbl, p5_a0
1085: , p5_a1
1086: , p5_a2
1087: , p5_a3
1088: , p5_a4

Line 1130: okl_asd_pvt.insert_row(p_api_version,

1126: );
1127:
1128:
1129: -- here's the delegated call to the old PL/SQL routine
1130: okl_asd_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_asd_pvt_w.rosetta_table_copy_out_p8(ddx_asdv_tbl, p6_a0

1141:
1142:
1143:
1144:
1145: okl_asd_pvt_w.rosetta_table_copy_out_p8(ddx_asdv_tbl, p6_a0
1146: , p6_a1
1147: , p6_a2
1148: , p6_a3
1149: , p6_a4

Line 1240: ddp_asdv_rec okl_asd_pvt.asdv_rec_type;

1236: , p5_a41 DATE := fnd_api.g_miss_date
1237: )
1238:
1239: as
1240: ddp_asdv_rec okl_asd_pvt.asdv_rec_type;
1241: ddindx binary_integer; indx binary_integer;
1242: begin
1243:
1244: -- copy data to the local IN or IN-OUT args, if any

Line 1294: okl_asd_pvt.lock_row(p_api_version,

1290: ddp_asdv_rec.currency_conversion_rate := rosetta_g_miss_num_map(p5_a40);
1291: ddp_asdv_rec.currency_conversion_date := rosetta_g_miss_date_in_map(p5_a41);
1292:
1293: -- here's the delegated call to the old PL/SQL routine
1294: okl_asd_pvt.lock_row(p_api_version,
1295: p_init_msg_list,
1296: x_return_status,
1297: x_msg_count,
1298: x_msg_data,

Line 1359: ddp_asdv_tbl okl_asd_pvt.asdv_tbl_type;

1355: , p5_a41 JTF_DATE_TABLE
1356: )
1357:
1358: as
1359: ddp_asdv_tbl okl_asd_pvt.asdv_tbl_type;
1360: ddindx binary_integer; indx binary_integer;
1361: begin
1362:
1363: -- copy data to the local IN or IN-OUT args, if any

Line 1369: okl_asd_pvt_w.rosetta_table_copy_in_p8(ddp_asdv_tbl, p5_a0

1365:
1366:
1367:
1368:
1369: okl_asd_pvt_w.rosetta_table_copy_in_p8(ddp_asdv_tbl, p5_a0
1370: , p5_a1
1371: , p5_a2
1372: , p5_a3
1373: , p5_a4

Line 1414: okl_asd_pvt.lock_row(p_api_version,

1410: , p5_a41
1411: );
1412:
1413: -- here's the delegated call to the old PL/SQL routine
1414: okl_asd_pvt.lock_row(p_api_version,
1415: p_init_msg_list,
1416: x_return_status,
1417: x_msg_count,
1418: x_msg_data,

Line 1521: ddp_asdv_rec okl_asd_pvt.asdv_rec_type;

1517: , p5_a41 DATE := fnd_api.g_miss_date
1518: )
1519:
1520: as
1521: ddp_asdv_rec okl_asd_pvt.asdv_rec_type;
1522: ddx_asdv_rec okl_asd_pvt.asdv_rec_type;
1523: ddindx binary_integer; indx binary_integer;
1524: begin
1525:

Line 1522: ddx_asdv_rec okl_asd_pvt.asdv_rec_type;

1518: )
1519:
1520: as
1521: ddp_asdv_rec okl_asd_pvt.asdv_rec_type;
1522: ddx_asdv_rec okl_asd_pvt.asdv_rec_type;
1523: ddindx binary_integer; indx binary_integer;
1524: begin
1525:
1526: -- copy data to the local IN or IN-OUT args, if any

Line 1577: okl_asd_pvt.update_row(p_api_version,

1573: ddp_asdv_rec.currency_conversion_date := rosetta_g_miss_date_in_map(p5_a41);
1574:
1575:
1576: -- here's the delegated call to the old PL/SQL routine
1577: okl_asd_pvt.update_row(p_api_version,
1578: p_init_msg_list,
1579: x_return_status,
1580: x_msg_count,
1581: x_msg_data,

Line 1728: ddp_asdv_tbl okl_asd_pvt.asdv_tbl_type;

1724: , p6_a41 out nocopy JTF_DATE_TABLE
1725: )
1726:
1727: as
1728: ddp_asdv_tbl okl_asd_pvt.asdv_tbl_type;
1729: ddx_asdv_tbl okl_asd_pvt.asdv_tbl_type;
1730: ddindx binary_integer; indx binary_integer;
1731: begin
1732:

Line 1729: ddx_asdv_tbl okl_asd_pvt.asdv_tbl_type;

1725: )
1726:
1727: as
1728: ddp_asdv_tbl okl_asd_pvt.asdv_tbl_type;
1729: ddx_asdv_tbl okl_asd_pvt.asdv_tbl_type;
1730: ddindx binary_integer; indx binary_integer;
1731: begin
1732:
1733: -- copy data to the local IN or IN-OUT args, if any

Line 1739: okl_asd_pvt_w.rosetta_table_copy_in_p8(ddp_asdv_tbl, p5_a0

1735:
1736:
1737:
1738:
1739: okl_asd_pvt_w.rosetta_table_copy_in_p8(ddp_asdv_tbl, p5_a0
1740: , p5_a1
1741: , p5_a2
1742: , p5_a3
1743: , p5_a4

Line 1785: okl_asd_pvt.update_row(p_api_version,

1781: );
1782:
1783:
1784: -- here's the delegated call to the old PL/SQL routine
1785: okl_asd_pvt.update_row(p_api_version,
1786: p_init_msg_list,
1787: x_return_status,
1788: x_msg_count,
1789: x_msg_data,

Line 1800: okl_asd_pvt_w.rosetta_table_copy_out_p8(ddx_asdv_tbl, p6_a0

1796:
1797:
1798:
1799:
1800: okl_asd_pvt_w.rosetta_table_copy_out_p8(ddx_asdv_tbl, p6_a0
1801: , p6_a1
1802: , p6_a2
1803: , p6_a3
1804: , p6_a4

Line 1895: ddp_asdv_rec okl_asd_pvt.asdv_rec_type;

1891: , p5_a41 DATE := fnd_api.g_miss_date
1892: )
1893:
1894: as
1895: ddp_asdv_rec okl_asd_pvt.asdv_rec_type;
1896: ddindx binary_integer; indx binary_integer;
1897: begin
1898:
1899: -- copy data to the local IN or IN-OUT args, if any

Line 1949: okl_asd_pvt.delete_row(p_api_version,

1945: ddp_asdv_rec.currency_conversion_rate := rosetta_g_miss_num_map(p5_a40);
1946: ddp_asdv_rec.currency_conversion_date := rosetta_g_miss_date_in_map(p5_a41);
1947:
1948: -- here's the delegated call to the old PL/SQL routine
1949: okl_asd_pvt.delete_row(p_api_version,
1950: p_init_msg_list,
1951: x_return_status,
1952: x_msg_count,
1953: x_msg_data,

Line 2014: ddp_asdv_tbl okl_asd_pvt.asdv_tbl_type;

2010: , p5_a41 JTF_DATE_TABLE
2011: )
2012:
2013: as
2014: ddp_asdv_tbl okl_asd_pvt.asdv_tbl_type;
2015: ddindx binary_integer; indx binary_integer;
2016: begin
2017:
2018: -- copy data to the local IN or IN-OUT args, if any

Line 2024: okl_asd_pvt_w.rosetta_table_copy_in_p8(ddp_asdv_tbl, p5_a0

2020:
2021:
2022:
2023:
2024: okl_asd_pvt_w.rosetta_table_copy_in_p8(ddp_asdv_tbl, p5_a0
2025: , p5_a1
2026: , p5_a2
2027: , p5_a3
2028: , p5_a4

Line 2069: okl_asd_pvt.delete_row(p_api_version,

2065: , p5_a41
2066: );
2067:
2068: -- here's the delegated call to the old PL/SQL routine
2069: okl_asd_pvt.delete_row(p_api_version,
2070: p_init_msg_list,
2071: x_return_status,
2072: x_msg_count,
2073: x_msg_data,

Line 2134: ddp_asdv_rec okl_asd_pvt.asdv_rec_type;

2130: , p5_a41 DATE := fnd_api.g_miss_date
2131: )
2132:
2133: as
2134: ddp_asdv_rec okl_asd_pvt.asdv_rec_type;
2135: ddindx binary_integer; indx binary_integer;
2136: begin
2137:
2138: -- copy data to the local IN or IN-OUT args, if any

Line 2188: okl_asd_pvt.validate_row(p_api_version,

2184: ddp_asdv_rec.currency_conversion_rate := rosetta_g_miss_num_map(p5_a40);
2185: ddp_asdv_rec.currency_conversion_date := rosetta_g_miss_date_in_map(p5_a41);
2186:
2187: -- here's the delegated call to the old PL/SQL routine
2188: okl_asd_pvt.validate_row(p_api_version,
2189: p_init_msg_list,
2190: x_return_status,
2191: x_msg_count,
2192: x_msg_data,

Line 2253: ddp_asdv_tbl okl_asd_pvt.asdv_tbl_type;

2249: , p5_a41 JTF_DATE_TABLE
2250: )
2251:
2252: as
2253: ddp_asdv_tbl okl_asd_pvt.asdv_tbl_type;
2254: ddindx binary_integer; indx binary_integer;
2255: begin
2256:
2257: -- copy data to the local IN or IN-OUT args, if any

Line 2263: okl_asd_pvt_w.rosetta_table_copy_in_p8(ddp_asdv_tbl, p5_a0

2259:
2260:
2261:
2262:
2263: okl_asd_pvt_w.rosetta_table_copy_in_p8(ddp_asdv_tbl, p5_a0
2264: , p5_a1
2265: , p5_a2
2266: , p5_a3
2267: , p5_a4

Line 2308: okl_asd_pvt.validate_row(p_api_version,

2304: , p5_a41
2305: );
2306:
2307: -- here's the delegated call to the old PL/SQL routine
2308: okl_asd_pvt.validate_row(p_api_version,
2309: p_init_msg_list,
2310: x_return_status,
2311: x_msg_count,
2312: x_msg_data,

Line 2323: end okl_asd_pvt_w;

2319:
2320:
2321: end;
2322:
2323: end okl_asd_pvt_w;