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_SID_PVT_W dependencies on OKL_SID_PVT

Line 1: package body okl_sid_pvt_w as

1: package body okl_sid_pvt_w as
2: /* $Header: OKLISIDB.pls 120.1 2005/07/14 11:59:52 asawanka 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_sid_pvt.sidv_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_sid_pvt.sidv_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100

Line 101: procedure rosetta_table_copy_out_p2(t okl_sid_pvt.sidv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

97: end loop;
98: end if;
99: end if;
100: end rosetta_table_copy_in_p2;
101: procedure rosetta_table_copy_out_p2(t okl_sid_pvt.sidv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
102: , a1 out nocopy JTF_NUMBER_TABLE
103: , a2 out nocopy JTF_NUMBER_TABLE
104: , a3 out nocopy JTF_NUMBER_TABLE
105: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 275: procedure rosetta_table_copy_in_p5(t out nocopy okl_sid_pvt.sid_tbl_type, a0 JTF_NUMBER_TABLE

271: end if;
272: end if;
273: end rosetta_table_copy_out_p2;
274:
275: procedure rosetta_table_copy_in_p5(t out nocopy okl_sid_pvt.sid_tbl_type, a0 JTF_NUMBER_TABLE
276: , a1 JTF_NUMBER_TABLE
277: , a2 JTF_NUMBER_TABLE
278: , a3 JTF_NUMBER_TABLE
279: , a4 JTF_VARCHAR2_TABLE_100

Line 354: procedure rosetta_table_copy_out_p5(t okl_sid_pvt.sid_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

350: end loop;
351: end if;
352: end if;
353: end rosetta_table_copy_in_p5;
354: procedure rosetta_table_copy_out_p5(t okl_sid_pvt.sid_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
355: , a1 out nocopy JTF_NUMBER_TABLE
356: , a2 out nocopy JTF_NUMBER_TABLE
357: , a3 out nocopy JTF_NUMBER_TABLE
358: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 528: procedure rosetta_table_copy_in_p8(t out nocopy okl_sid_pvt.okl_sidh_tbl_type, a0 JTF_NUMBER_TABLE

524: end if;
525: end if;
526: end rosetta_table_copy_out_p5;
527:
528: procedure rosetta_table_copy_in_p8(t out nocopy okl_sid_pvt.okl_sidh_tbl_type, a0 JTF_NUMBER_TABLE
529: , a1 JTF_NUMBER_TABLE
530: , a2 JTF_NUMBER_TABLE
531: , a3 JTF_NUMBER_TABLE
532: , a4 JTF_NUMBER_TABLE

Line 609: procedure rosetta_table_copy_out_p8(t okl_sid_pvt.okl_sidh_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

605: end loop;
606: end if;
607: end if;
608: end rosetta_table_copy_in_p8;
609: procedure rosetta_table_copy_out_p8(t okl_sid_pvt.okl_sidh_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_NUMBER_TABLE

Line 858: ddp_sidv_rec okl_sid_pvt.sidv_rec_type;

854: , p5_a30 NUMBER := 0-1962.0724
855: )
856:
857: as
858: ddp_sidv_rec okl_sid_pvt.sidv_rec_type;
859: ddx_sidv_rec okl_sid_pvt.sidv_rec_type;
860: ddindx binary_integer; indx binary_integer;
861: begin
862:

Line 859: ddx_sidv_rec okl_sid_pvt.sidv_rec_type;

855: )
856:
857: as
858: ddp_sidv_rec okl_sid_pvt.sidv_rec_type;
859: ddx_sidv_rec okl_sid_pvt.sidv_rec_type;
860: ddindx binary_integer; indx binary_integer;
861: begin
862:
863: -- copy data to the local IN or IN-OUT args, if any

Line 903: okl_sid_pvt.insert_row(p_api_version,

899: ddp_sidv_rec.last_update_login := rosetta_g_miss_num_map(p5_a30);
900:
901:
902: -- here's the delegated call to the old PL/SQL routine
903: okl_sid_pvt.insert_row(p_api_version,
904: p_init_msg_list,
905: x_return_status,
906: x_msg_count,
907: x_msg_data,

Line 1021: ddp_sidv_tbl okl_sid_pvt.sidv_tbl_type;

1017: , p6_a30 out nocopy JTF_NUMBER_TABLE
1018: )
1019:
1020: as
1021: ddp_sidv_tbl okl_sid_pvt.sidv_tbl_type;
1022: ddx_sidv_tbl okl_sid_pvt.sidv_tbl_type;
1023: ddindx binary_integer; indx binary_integer;
1024: begin
1025:

Line 1022: ddx_sidv_tbl okl_sid_pvt.sidv_tbl_type;

1018: )
1019:
1020: as
1021: ddp_sidv_tbl okl_sid_pvt.sidv_tbl_type;
1022: ddx_sidv_tbl okl_sid_pvt.sidv_tbl_type;
1023: ddindx binary_integer; indx binary_integer;
1024: begin
1025:
1026: -- copy data to the local IN or IN-OUT args, if any

Line 1032: okl_sid_pvt_w.rosetta_table_copy_in_p2(ddp_sidv_tbl, p5_a0

1028:
1029:
1030:
1031:
1032: okl_sid_pvt_w.rosetta_table_copy_in_p2(ddp_sidv_tbl, p5_a0
1033: , p5_a1
1034: , p5_a2
1035: , p5_a3
1036: , p5_a4

Line 1067: okl_sid_pvt.insert_row(p_api_version,

1063: );
1064:
1065:
1066: -- here's the delegated call to the old PL/SQL routine
1067: okl_sid_pvt.insert_row(p_api_version,
1068: p_init_msg_list,
1069: x_return_status,
1070: x_msg_count,
1071: x_msg_data,

Line 1082: okl_sid_pvt_w.rosetta_table_copy_out_p2(ddx_sidv_tbl, p6_a0

1078:
1079:
1080:
1081:
1082: okl_sid_pvt_w.rosetta_table_copy_out_p2(ddx_sidv_tbl, p6_a0
1083: , p6_a1
1084: , p6_a2
1085: , p6_a3
1086: , p6_a4

Line 1155: ddp_sidv_rec okl_sid_pvt.sidv_rec_type;

1151: , p5_a30 NUMBER := 0-1962.0724
1152: )
1153:
1154: as
1155: ddp_sidv_rec okl_sid_pvt.sidv_rec_type;
1156: ddindx binary_integer; indx binary_integer;
1157: begin
1158:
1159: -- copy data to the local IN or IN-OUT args, if any

Line 1198: okl_sid_pvt.lock_row(p_api_version,

1194: ddp_sidv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a29);
1195: ddp_sidv_rec.last_update_login := rosetta_g_miss_num_map(p5_a30);
1196:
1197: -- here's the delegated call to the old PL/SQL routine
1198: okl_sid_pvt.lock_row(p_api_version,
1199: p_init_msg_list,
1200: x_return_status,
1201: x_msg_count,
1202: x_msg_data,

Line 1252: ddp_sidv_tbl okl_sid_pvt.sidv_tbl_type;

1248: , p5_a30 JTF_NUMBER_TABLE
1249: )
1250:
1251: as
1252: ddp_sidv_tbl okl_sid_pvt.sidv_tbl_type;
1253: ddindx binary_integer; indx binary_integer;
1254: begin
1255:
1256: -- copy data to the local IN or IN-OUT args, if any

Line 1262: okl_sid_pvt_w.rosetta_table_copy_in_p2(ddp_sidv_tbl, p5_a0

1258:
1259:
1260:
1261:
1262: okl_sid_pvt_w.rosetta_table_copy_in_p2(ddp_sidv_tbl, p5_a0
1263: , p5_a1
1264: , p5_a2
1265: , p5_a3
1266: , p5_a4

Line 1296: okl_sid_pvt.lock_row(p_api_version,

1292: , p5_a30
1293: );
1294:
1295: -- here's the delegated call to the old PL/SQL routine
1296: okl_sid_pvt.lock_row(p_api_version,
1297: p_init_msg_list,
1298: x_return_status,
1299: x_msg_count,
1300: x_msg_data,

Line 1381: ddp_sidv_rec okl_sid_pvt.sidv_rec_type;

1377: , p5_a30 NUMBER := 0-1962.0724
1378: )
1379:
1380: as
1381: ddp_sidv_rec okl_sid_pvt.sidv_rec_type;
1382: ddx_sidv_rec okl_sid_pvt.sidv_rec_type;
1383: ddindx binary_integer; indx binary_integer;
1384: begin
1385:

Line 1382: ddx_sidv_rec okl_sid_pvt.sidv_rec_type;

1378: )
1379:
1380: as
1381: ddp_sidv_rec okl_sid_pvt.sidv_rec_type;
1382: ddx_sidv_rec okl_sid_pvt.sidv_rec_type;
1383: ddindx binary_integer; indx binary_integer;
1384: begin
1385:
1386: -- copy data to the local IN or IN-OUT args, if any

Line 1426: okl_sid_pvt.update_row(p_api_version,

1422: ddp_sidv_rec.last_update_login := rosetta_g_miss_num_map(p5_a30);
1423:
1424:
1425: -- here's the delegated call to the old PL/SQL routine
1426: okl_sid_pvt.update_row(p_api_version,
1427: p_init_msg_list,
1428: x_return_status,
1429: x_msg_count,
1430: x_msg_data,

Line 1544: ddp_sidv_tbl okl_sid_pvt.sidv_tbl_type;

1540: , p6_a30 out nocopy JTF_NUMBER_TABLE
1541: )
1542:
1543: as
1544: ddp_sidv_tbl okl_sid_pvt.sidv_tbl_type;
1545: ddx_sidv_tbl okl_sid_pvt.sidv_tbl_type;
1546: ddindx binary_integer; indx binary_integer;
1547: begin
1548:

Line 1545: ddx_sidv_tbl okl_sid_pvt.sidv_tbl_type;

1541: )
1542:
1543: as
1544: ddp_sidv_tbl okl_sid_pvt.sidv_tbl_type;
1545: ddx_sidv_tbl okl_sid_pvt.sidv_tbl_type;
1546: ddindx binary_integer; indx binary_integer;
1547: begin
1548:
1549: -- copy data to the local IN or IN-OUT args, if any

Line 1555: okl_sid_pvt_w.rosetta_table_copy_in_p2(ddp_sidv_tbl, p5_a0

1551:
1552:
1553:
1554:
1555: okl_sid_pvt_w.rosetta_table_copy_in_p2(ddp_sidv_tbl, p5_a0
1556: , p5_a1
1557: , p5_a2
1558: , p5_a3
1559: , p5_a4

Line 1590: okl_sid_pvt.update_row(p_api_version,

1586: );
1587:
1588:
1589: -- here's the delegated call to the old PL/SQL routine
1590: okl_sid_pvt.update_row(p_api_version,
1591: p_init_msg_list,
1592: x_return_status,
1593: x_msg_count,
1594: x_msg_data,

Line 1605: okl_sid_pvt_w.rosetta_table_copy_out_p2(ddx_sidv_tbl, p6_a0

1601:
1602:
1603:
1604:
1605: okl_sid_pvt_w.rosetta_table_copy_out_p2(ddx_sidv_tbl, p6_a0
1606: , p6_a1
1607: , p6_a2
1608: , p6_a3
1609: , p6_a4

Line 1678: ddp_sidv_rec okl_sid_pvt.sidv_rec_type;

1674: , p5_a30 NUMBER := 0-1962.0724
1675: )
1676:
1677: as
1678: ddp_sidv_rec okl_sid_pvt.sidv_rec_type;
1679: ddindx binary_integer; indx binary_integer;
1680: begin
1681:
1682: -- copy data to the local IN or IN-OUT args, if any

Line 1721: okl_sid_pvt.delete_row(p_api_version,

1717: ddp_sidv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a29);
1718: ddp_sidv_rec.last_update_login := rosetta_g_miss_num_map(p5_a30);
1719:
1720: -- here's the delegated call to the old PL/SQL routine
1721: okl_sid_pvt.delete_row(p_api_version,
1722: p_init_msg_list,
1723: x_return_status,
1724: x_msg_count,
1725: x_msg_data,

Line 1775: ddp_sidv_tbl okl_sid_pvt.sidv_tbl_type;

1771: , p5_a30 JTF_NUMBER_TABLE
1772: )
1773:
1774: as
1775: ddp_sidv_tbl okl_sid_pvt.sidv_tbl_type;
1776: ddindx binary_integer; indx binary_integer;
1777: begin
1778:
1779: -- copy data to the local IN or IN-OUT args, if any

Line 1785: okl_sid_pvt_w.rosetta_table_copy_in_p2(ddp_sidv_tbl, p5_a0

1781:
1782:
1783:
1784:
1785: okl_sid_pvt_w.rosetta_table_copy_in_p2(ddp_sidv_tbl, p5_a0
1786: , p5_a1
1787: , p5_a2
1788: , p5_a3
1789: , p5_a4

Line 1819: okl_sid_pvt.delete_row(p_api_version,

1815: , p5_a30
1816: );
1817:
1818: -- here's the delegated call to the old PL/SQL routine
1819: okl_sid_pvt.delete_row(p_api_version,
1820: p_init_msg_list,
1821: x_return_status,
1822: x_msg_count,
1823: x_msg_data,

Line 1873: ddp_sidv_rec okl_sid_pvt.sidv_rec_type;

1869: , p5_a30 NUMBER := 0-1962.0724
1870: )
1871:
1872: as
1873: ddp_sidv_rec okl_sid_pvt.sidv_rec_type;
1874: ddindx binary_integer; indx binary_integer;
1875: begin
1876:
1877: -- copy data to the local IN or IN-OUT args, if any

Line 1916: okl_sid_pvt.validate_row(p_api_version,

1912: ddp_sidv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a29);
1913: ddp_sidv_rec.last_update_login := rosetta_g_miss_num_map(p5_a30);
1914:
1915: -- here's the delegated call to the old PL/SQL routine
1916: okl_sid_pvt.validate_row(p_api_version,
1917: p_init_msg_list,
1918: x_return_status,
1919: x_msg_count,
1920: x_msg_data,

Line 1970: ddp_sidv_tbl okl_sid_pvt.sidv_tbl_type;

1966: , p5_a30 JTF_NUMBER_TABLE
1967: )
1968:
1969: as
1970: ddp_sidv_tbl okl_sid_pvt.sidv_tbl_type;
1971: ddindx binary_integer; indx binary_integer;
1972: begin
1973:
1974: -- copy data to the local IN or IN-OUT args, if any

Line 1980: okl_sid_pvt_w.rosetta_table_copy_in_p2(ddp_sidv_tbl, p5_a0

1976:
1977:
1978:
1979:
1980: okl_sid_pvt_w.rosetta_table_copy_in_p2(ddp_sidv_tbl, p5_a0
1981: , p5_a1
1982: , p5_a2
1983: , p5_a3
1984: , p5_a4

Line 2014: okl_sid_pvt.validate_row(p_api_version,

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

Line 2029: end okl_sid_pvt_w;

2025:
2026:
2027: end;
2028:
2029: end okl_sid_pvt_w;