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_CRA_PVT_W dependencies on OKL_CRA_PVT

Line 1: package body okl_cra_pvt_w as

1: package body okl_cra_pvt_w as
2: /* $Header: OKLICRAB.pls 120.1 2005/07/08 10:33:39 dkagrawa 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_cra_pvt.crav_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_cra_pvt.crav_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_NUMBER_TABLE

Line 119: procedure rosetta_table_copy_out_p2(t okl_cra_pvt.crav_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_cra_pvt.crav_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_VARCHAR2_TABLE_100
123: , a4 out nocopy JTF_NUMBER_TABLE

Line 338: procedure rosetta_table_copy_in_p5(t out nocopy okl_cra_pvt.cra_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_cra_pvt.cra_tbl_type, a0 JTF_NUMBER_TABLE
339: , a1 JTF_NUMBER_TABLE
340: , a2 JTF_NUMBER_TABLE
341: , a3 JTF_VARCHAR2_TABLE_100
342: , a4 JTF_NUMBER_TABLE

Line 435: procedure rosetta_table_copy_out_p5(t okl_cra_pvt.cra_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_cra_pvt.cra_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_VARCHAR2_TABLE_100
439: , a4 out nocopy JTF_NUMBER_TABLE

Line 742: ddp_crav_rec okl_cra_pvt.crav_rec_type;

738: , p5_a39 NUMBER := 0-1962.0724
739: )
740:
741: as
742: ddp_crav_rec okl_cra_pvt.crav_rec_type;
743: ddx_crav_rec okl_cra_pvt.crav_rec_type;
744: ddindx binary_integer; indx binary_integer;
745: begin
746:

Line 743: ddx_crav_rec okl_cra_pvt.crav_rec_type;

739: )
740:
741: as
742: ddp_crav_rec okl_cra_pvt.crav_rec_type;
743: ddx_crav_rec okl_cra_pvt.crav_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_cra_pvt.insert_row(p_api_version,

792: ddp_crav_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_cra_pvt.insert_row(p_api_version,
797: p_init_msg_list,
798: x_return_status,
799: x_msg_count,
800: x_msg_data,

Line 941: ddp_crav_tbl okl_cra_pvt.crav_tbl_type;

937: , p6_a39 out nocopy JTF_NUMBER_TABLE
938: )
939:
940: as
941: ddp_crav_tbl okl_cra_pvt.crav_tbl_type;
942: ddx_crav_tbl okl_cra_pvt.crav_tbl_type;
943: ddindx binary_integer; indx binary_integer;
944: begin
945:

Line 942: ddx_crav_tbl okl_cra_pvt.crav_tbl_type;

938: )
939:
940: as
941: ddp_crav_tbl okl_cra_pvt.crav_tbl_type;
942: ddx_crav_tbl okl_cra_pvt.crav_tbl_type;
943: ddindx binary_integer; indx binary_integer;
944: begin
945:
946: -- copy data to the local IN or IN-OUT args, if any

Line 952: okl_cra_pvt_w.rosetta_table_copy_in_p2(ddp_crav_tbl, p5_a0

948:
949:
950:
951:
952: okl_cra_pvt_w.rosetta_table_copy_in_p2(ddp_crav_tbl, p5_a0
953: , p5_a1
954: , p5_a2
955: , p5_a3
956: , p5_a4

Line 996: okl_cra_pvt.insert_row(p_api_version,

992: );
993:
994:
995: -- here's the delegated call to the old PL/SQL routine
996: okl_cra_pvt.insert_row(p_api_version,
997: p_init_msg_list,
998: x_return_status,
999: x_msg_count,
1000: x_msg_data,

Line 1011: okl_cra_pvt_w.rosetta_table_copy_out_p2(ddx_crav_tbl, p6_a0

1007:
1008:
1009:
1010:
1011: okl_cra_pvt_w.rosetta_table_copy_out_p2(ddx_crav_tbl, p6_a0
1012: , p6_a1
1013: , p6_a2
1014: , p6_a3
1015: , p6_a4

Line 1102: ddp_crav_rec okl_cra_pvt.crav_rec_type;

1098: , p5_a39 NUMBER := 0-1962.0724
1099: )
1100:
1101: as
1102: ddp_crav_rec okl_cra_pvt.crav_rec_type;
1103: ddindx binary_integer; indx binary_integer;
1104: begin
1105:
1106: -- copy data to the local IN or IN-OUT args, if any

Line 1154: okl_cra_pvt.lock_row(p_api_version,

1150: ddp_crav_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a38);
1151: ddp_crav_rec.last_update_login := rosetta_g_miss_num_map(p5_a39);
1152:
1153: -- here's the delegated call to the old PL/SQL routine
1154: okl_cra_pvt.lock_row(p_api_version,
1155: p_init_msg_list,
1156: x_return_status,
1157: x_msg_count,
1158: x_msg_data,

Line 1217: ddp_crav_tbl okl_cra_pvt.crav_tbl_type;

1213: , p5_a39 JTF_NUMBER_TABLE
1214: )
1215:
1216: as
1217: ddp_crav_tbl okl_cra_pvt.crav_tbl_type;
1218: ddindx binary_integer; indx binary_integer;
1219: begin
1220:
1221: -- copy data to the local IN or IN-OUT args, if any

Line 1227: okl_cra_pvt_w.rosetta_table_copy_in_p2(ddp_crav_tbl, p5_a0

1223:
1224:
1225:
1226:
1227: okl_cra_pvt_w.rosetta_table_copy_in_p2(ddp_crav_tbl, p5_a0
1228: , p5_a1
1229: , p5_a2
1230: , p5_a3
1231: , p5_a4

Line 1270: okl_cra_pvt.lock_row(p_api_version,

1266: , p5_a39
1267: );
1268:
1269: -- here's the delegated call to the old PL/SQL routine
1270: okl_cra_pvt.lock_row(p_api_version,
1271: p_init_msg_list,
1272: x_return_status,
1273: x_msg_count,
1274: x_msg_data,

Line 1373: ddp_crav_rec okl_cra_pvt.crav_rec_type;

1369: , p5_a39 NUMBER := 0-1962.0724
1370: )
1371:
1372: as
1373: ddp_crav_rec okl_cra_pvt.crav_rec_type;
1374: ddx_crav_rec okl_cra_pvt.crav_rec_type;
1375: ddindx binary_integer; indx binary_integer;
1376: begin
1377:

Line 1374: ddx_crav_rec okl_cra_pvt.crav_rec_type;

1370: )
1371:
1372: as
1373: ddp_crav_rec okl_cra_pvt.crav_rec_type;
1374: ddx_crav_rec okl_cra_pvt.crav_rec_type;
1375: ddindx binary_integer; indx binary_integer;
1376: begin
1377:
1378: -- copy data to the local IN or IN-OUT args, if any

Line 1427: okl_cra_pvt.update_row(p_api_version,

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

Line 1572: ddp_crav_tbl okl_cra_pvt.crav_tbl_type;

1568: , p6_a39 out nocopy JTF_NUMBER_TABLE
1569: )
1570:
1571: as
1572: ddp_crav_tbl okl_cra_pvt.crav_tbl_type;
1573: ddx_crav_tbl okl_cra_pvt.crav_tbl_type;
1574: ddindx binary_integer; indx binary_integer;
1575: begin
1576:

Line 1573: ddx_crav_tbl okl_cra_pvt.crav_tbl_type;

1569: )
1570:
1571: as
1572: ddp_crav_tbl okl_cra_pvt.crav_tbl_type;
1573: ddx_crav_tbl okl_cra_pvt.crav_tbl_type;
1574: ddindx binary_integer; indx binary_integer;
1575: begin
1576:
1577: -- copy data to the local IN or IN-OUT args, if any

Line 1583: okl_cra_pvt_w.rosetta_table_copy_in_p2(ddp_crav_tbl, p5_a0

1579:
1580:
1581:
1582:
1583: okl_cra_pvt_w.rosetta_table_copy_in_p2(ddp_crav_tbl, p5_a0
1584: , p5_a1
1585: , p5_a2
1586: , p5_a3
1587: , p5_a4

Line 1627: okl_cra_pvt.update_row(p_api_version,

1623: );
1624:
1625:
1626: -- here's the delegated call to the old PL/SQL routine
1627: okl_cra_pvt.update_row(p_api_version,
1628: p_init_msg_list,
1629: x_return_status,
1630: x_msg_count,
1631: x_msg_data,

Line 1642: okl_cra_pvt_w.rosetta_table_copy_out_p2(ddx_crav_tbl, p6_a0

1638:
1639:
1640:
1641:
1642: okl_cra_pvt_w.rosetta_table_copy_out_p2(ddx_crav_tbl, p6_a0
1643: , p6_a1
1644: , p6_a2
1645: , p6_a3
1646: , p6_a4

Line 1733: ddp_crav_rec okl_cra_pvt.crav_rec_type;

1729: , p5_a39 NUMBER := 0-1962.0724
1730: )
1731:
1732: as
1733: ddp_crav_rec okl_cra_pvt.crav_rec_type;
1734: ddindx binary_integer; indx binary_integer;
1735: begin
1736:
1737: -- copy data to the local IN or IN-OUT args, if any

Line 1785: okl_cra_pvt.delete_row(p_api_version,

1781: ddp_crav_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a38);
1782: ddp_crav_rec.last_update_login := rosetta_g_miss_num_map(p5_a39);
1783:
1784: -- here's the delegated call to the old PL/SQL routine
1785: okl_cra_pvt.delete_row(p_api_version,
1786: p_init_msg_list,
1787: x_return_status,
1788: x_msg_count,
1789: x_msg_data,

Line 1848: ddp_crav_tbl okl_cra_pvt.crav_tbl_type;

1844: , p5_a39 JTF_NUMBER_TABLE
1845: )
1846:
1847: as
1848: ddp_crav_tbl okl_cra_pvt.crav_tbl_type;
1849: ddindx binary_integer; indx binary_integer;
1850: begin
1851:
1852: -- copy data to the local IN or IN-OUT args, if any

Line 1858: okl_cra_pvt_w.rosetta_table_copy_in_p2(ddp_crav_tbl, p5_a0

1854:
1855:
1856:
1857:
1858: okl_cra_pvt_w.rosetta_table_copy_in_p2(ddp_crav_tbl, p5_a0
1859: , p5_a1
1860: , p5_a2
1861: , p5_a3
1862: , p5_a4

Line 1901: okl_cra_pvt.delete_row(p_api_version,

1897: , p5_a39
1898: );
1899:
1900: -- here's the delegated call to the old PL/SQL routine
1901: okl_cra_pvt.delete_row(p_api_version,
1902: p_init_msg_list,
1903: x_return_status,
1904: x_msg_count,
1905: x_msg_data,

Line 1964: ddp_crav_rec okl_cra_pvt.crav_rec_type;

1960: , p5_a39 NUMBER := 0-1962.0724
1961: )
1962:
1963: as
1964: ddp_crav_rec okl_cra_pvt.crav_rec_type;
1965: ddindx binary_integer; indx binary_integer;
1966: begin
1967:
1968: -- copy data to the local IN or IN-OUT args, if any

Line 2016: okl_cra_pvt.validate_row(p_api_version,

2012: ddp_crav_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a38);
2013: ddp_crav_rec.last_update_login := rosetta_g_miss_num_map(p5_a39);
2014:
2015: -- here's the delegated call to the old PL/SQL routine
2016: okl_cra_pvt.validate_row(p_api_version,
2017: p_init_msg_list,
2018: x_return_status,
2019: x_msg_count,
2020: x_msg_data,

Line 2079: ddp_crav_tbl okl_cra_pvt.crav_tbl_type;

2075: , p5_a39 JTF_NUMBER_TABLE
2076: )
2077:
2078: as
2079: ddp_crav_tbl okl_cra_pvt.crav_tbl_type;
2080: ddindx binary_integer; indx binary_integer;
2081: begin
2082:
2083: -- copy data to the local IN or IN-OUT args, if any

Line 2089: okl_cra_pvt_w.rosetta_table_copy_in_p2(ddp_crav_tbl, p5_a0

2085:
2086:
2087:
2088:
2089: okl_cra_pvt_w.rosetta_table_copy_in_p2(ddp_crav_tbl, p5_a0
2090: , p5_a1
2091: , p5_a2
2092: , p5_a3
2093: , p5_a4

Line 2132: okl_cra_pvt.validate_row(p_api_version,

2128: , p5_a39
2129: );
2130:
2131: -- here's the delegated call to the old PL/SQL routine
2132: okl_cra_pvt.validate_row(p_api_version,
2133: p_init_msg_list,
2134: x_return_status,
2135: x_msg_count,
2136: x_msg_data,

Line 2147: end okl_cra_pvt_w;

2143:
2144:
2145: end;
2146:
2147: end okl_cra_pvt_w;