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_DRA_PVT_W dependencies on OKL_DRA_PVT

Line 1: package body okl_dra_pvt_w as

1: package body okl_dra_pvt_w as
2: /* $Header: OKLIDRAB.pls 120.0 2007/04/27 09:17:30 gkhuntet 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: 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_dra_pvt.drav_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_dra_pvt.drav_tbl_type, a0 JTF_NUMBER_TABLE
26: , a1 JTF_NUMBER_TABLE
27: , a2 JTF_VARCHAR2_TABLE_100
28: , a3 JTF_VARCHAR2_TABLE_200
29: , a4 JTF_NUMBER_TABLE

Line 118: procedure rosetta_table_copy_out_p2(t okl_dra_pvt.drav_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

114: end loop;
115: end if;
116: end if;
117: end rosetta_table_copy_in_p2;
118: procedure rosetta_table_copy_out_p2(t okl_dra_pvt.drav_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
119: , a1 out nocopy JTF_NUMBER_TABLE
120: , a2 out nocopy JTF_VARCHAR2_TABLE_100
121: , a3 out nocopy JTF_VARCHAR2_TABLE_200
122: , a4 out nocopy JTF_NUMBER_TABLE

Line 327: procedure rosetta_table_copy_in_p5(t out nocopy okl_dra_pvt.okl_disb_rules_tl_tbl_type, a0 JTF_NUMBER_TABLE

323: end if;
324: end if;
325: end rosetta_table_copy_out_p2;
326:
327: procedure rosetta_table_copy_in_p5(t out nocopy okl_dra_pvt.okl_disb_rules_tl_tbl_type, a0 JTF_NUMBER_TABLE
328: , a1 JTF_VARCHAR2_TABLE_100
329: , a2 JTF_VARCHAR2_TABLE_100
330: , a3 JTF_VARCHAR2_TABLE_100
331: , a4 JTF_VARCHAR2_TABLE_2000

Line 364: procedure rosetta_table_copy_out_p5(t okl_dra_pvt.okl_disb_rules_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

360: end loop;
361: end if;
362: end if;
363: end rosetta_table_copy_in_p5;
364: procedure rosetta_table_copy_out_p5(t okl_dra_pvt.okl_disb_rules_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
365: , a1 out nocopy JTF_VARCHAR2_TABLE_100
366: , a2 out nocopy JTF_VARCHAR2_TABLE_100
367: , a3 out nocopy JTF_VARCHAR2_TABLE_100
368: , a4 out nocopy JTF_VARCHAR2_TABLE_2000

Line 433: procedure rosetta_table_copy_in_p8(t out nocopy okl_dra_pvt.dra_tbl_type, a0 JTF_NUMBER_TABLE

429: end if;
430: end if;
431: end rosetta_table_copy_out_p5;
432:
433: procedure rosetta_table_copy_in_p8(t out nocopy okl_dra_pvt.dra_tbl_type, a0 JTF_NUMBER_TABLE
434: , a1 JTF_NUMBER_TABLE
435: , a2 JTF_VARCHAR2_TABLE_200
436: , a3 JTF_NUMBER_TABLE
437: , a4 JTF_DATE_TABLE

Line 522: procedure rosetta_table_copy_out_p8(t okl_dra_pvt.dra_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

518: end loop;
519: end if;
520: end if;
521: end rosetta_table_copy_in_p8;
522: procedure rosetta_table_copy_out_p8(t okl_dra_pvt.dra_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
523: , a1 out nocopy JTF_NUMBER_TABLE
524: , a2 out nocopy JTF_VARCHAR2_TABLE_200
525: , a3 out nocopy JTF_NUMBER_TABLE
526: , a4 out nocopy JTF_DATE_TABLE

Line 805: ddp_drav_rec okl_dra_pvt.drav_rec_type;

801: , p5_a37 NUMBER := 0-1962.0724
802: )
803:
804: as
805: ddp_drav_rec okl_dra_pvt.drav_rec_type;
806: ddx_drav_rec okl_dra_pvt.drav_rec_type;
807: ddindx binary_integer; indx binary_integer;
808: begin
809:

Line 806: ddx_drav_rec okl_dra_pvt.drav_rec_type;

802: )
803:
804: as
805: ddp_drav_rec okl_dra_pvt.drav_rec_type;
806: ddx_drav_rec okl_dra_pvt.drav_rec_type;
807: ddindx binary_integer; indx binary_integer;
808: begin
809:
810: -- copy data to the local IN or IN-OUT args, if any

Line 857: okl_dra_pvt.insert_row(p_api_version,

853: ddp_drav_rec.last_update_login := rosetta_g_miss_num_map(p5_a37);
854:
855:
856: -- here's the delegated call to the old PL/SQL routine
857: okl_dra_pvt.insert_row(p_api_version,
858: p_init_msg_list,
859: x_return_status,
860: x_msg_count,
861: x_msg_data,

Line 996: ddp_drav_tbl okl_dra_pvt.drav_tbl_type;

992: , p6_a37 out nocopy JTF_NUMBER_TABLE
993: )
994:
995: as
996: ddp_drav_tbl okl_dra_pvt.drav_tbl_type;
997: ddx_drav_tbl okl_dra_pvt.drav_tbl_type;
998: ddindx binary_integer; indx binary_integer;
999: begin
1000:

Line 997: ddx_drav_tbl okl_dra_pvt.drav_tbl_type;

993: )
994:
995: as
996: ddp_drav_tbl okl_dra_pvt.drav_tbl_type;
997: ddx_drav_tbl okl_dra_pvt.drav_tbl_type;
998: ddindx binary_integer; indx binary_integer;
999: begin
1000:
1001: -- copy data to the local IN or IN-OUT args, if any

Line 1007: okl_dra_pvt_w.rosetta_table_copy_in_p2(ddp_drav_tbl, p5_a0

1003:
1004:
1005:
1006:
1007: okl_dra_pvt_w.rosetta_table_copy_in_p2(ddp_drav_tbl, p5_a0
1008: , p5_a1
1009: , p5_a2
1010: , p5_a3
1011: , p5_a4

Line 1049: okl_dra_pvt.insert_row(p_api_version,

1045: );
1046:
1047:
1048: -- here's the delegated call to the old PL/SQL routine
1049: okl_dra_pvt.insert_row(p_api_version,
1050: p_init_msg_list,
1051: x_return_status,
1052: x_msg_count,
1053: x_msg_data,

Line 1064: okl_dra_pvt_w.rosetta_table_copy_out_p2(ddx_drav_tbl, p6_a0

1060:
1061:
1062:
1063:
1064: okl_dra_pvt_w.rosetta_table_copy_out_p2(ddx_drav_tbl, p6_a0
1065: , p6_a1
1066: , p6_a2
1067: , p6_a3
1068: , p6_a4

Line 1151: ddp_drav_rec okl_dra_pvt.drav_rec_type;

1147: , p5_a37 NUMBER := 0-1962.0724
1148: )
1149:
1150: as
1151: ddp_drav_rec okl_dra_pvt.drav_rec_type;
1152: ddindx binary_integer; indx binary_integer;
1153: begin
1154:
1155: -- copy data to the local IN or IN-OUT args, if any

Line 1201: okl_dra_pvt.lock_row(p_api_version,

1197: ddp_drav_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a36);
1198: ddp_drav_rec.last_update_login := rosetta_g_miss_num_map(p5_a37);
1199:
1200: -- here's the delegated call to the old PL/SQL routine
1201: okl_dra_pvt.lock_row(p_api_version,
1202: p_init_msg_list,
1203: x_return_status,
1204: x_msg_count,
1205: x_msg_data,

Line 1262: ddp_drav_tbl okl_dra_pvt.drav_tbl_type;

1258: , p5_a37 JTF_NUMBER_TABLE
1259: )
1260:
1261: as
1262: ddp_drav_tbl okl_dra_pvt.drav_tbl_type;
1263: ddindx binary_integer; indx binary_integer;
1264: begin
1265:
1266: -- copy data to the local IN or IN-OUT args, if any

Line 1272: okl_dra_pvt_w.rosetta_table_copy_in_p2(ddp_drav_tbl, p5_a0

1268:
1269:
1270:
1271:
1272: okl_dra_pvt_w.rosetta_table_copy_in_p2(ddp_drav_tbl, p5_a0
1273: , p5_a1
1274: , p5_a2
1275: , p5_a3
1276: , p5_a4

Line 1313: okl_dra_pvt.lock_row(p_api_version,

1309: , p5_a37
1310: );
1311:
1312: -- here's the delegated call to the old PL/SQL routine
1313: okl_dra_pvt.lock_row(p_api_version,
1314: p_init_msg_list,
1315: x_return_status,
1316: x_msg_count,
1317: x_msg_data,

Line 1412: ddp_drav_rec okl_dra_pvt.drav_rec_type;

1408: , p5_a37 NUMBER := 0-1962.0724
1409: )
1410:
1411: as
1412: ddp_drav_rec okl_dra_pvt.drav_rec_type;
1413: ddx_drav_rec okl_dra_pvt.drav_rec_type;
1414: ddindx binary_integer; indx binary_integer;
1415: begin
1416:

Line 1413: ddx_drav_rec okl_dra_pvt.drav_rec_type;

1409: )
1410:
1411: as
1412: ddp_drav_rec okl_dra_pvt.drav_rec_type;
1413: ddx_drav_rec okl_dra_pvt.drav_rec_type;
1414: ddindx binary_integer; indx binary_integer;
1415: begin
1416:
1417: -- copy data to the local IN or IN-OUT args, if any

Line 1464: okl_dra_pvt.update_row(p_api_version,

1460: ddp_drav_rec.last_update_login := rosetta_g_miss_num_map(p5_a37);
1461:
1462:
1463: -- here's the delegated call to the old PL/SQL routine
1464: okl_dra_pvt.update_row(p_api_version,
1465: p_init_msg_list,
1466: x_return_status,
1467: x_msg_count,
1468: x_msg_data,

Line 1603: ddp_drav_tbl okl_dra_pvt.drav_tbl_type;

1599: , p6_a37 out nocopy JTF_NUMBER_TABLE
1600: )
1601:
1602: as
1603: ddp_drav_tbl okl_dra_pvt.drav_tbl_type;
1604: ddx_drav_tbl okl_dra_pvt.drav_tbl_type;
1605: ddindx binary_integer; indx binary_integer;
1606: begin
1607:

Line 1604: ddx_drav_tbl okl_dra_pvt.drav_tbl_type;

1600: )
1601:
1602: as
1603: ddp_drav_tbl okl_dra_pvt.drav_tbl_type;
1604: ddx_drav_tbl okl_dra_pvt.drav_tbl_type;
1605: ddindx binary_integer; indx binary_integer;
1606: begin
1607:
1608: -- copy data to the local IN or IN-OUT args, if any

Line 1614: okl_dra_pvt_w.rosetta_table_copy_in_p2(ddp_drav_tbl, p5_a0

1610:
1611:
1612:
1613:
1614: okl_dra_pvt_w.rosetta_table_copy_in_p2(ddp_drav_tbl, p5_a0
1615: , p5_a1
1616: , p5_a2
1617: , p5_a3
1618: , p5_a4

Line 1656: okl_dra_pvt.update_row(p_api_version,

1652: );
1653:
1654:
1655: -- here's the delegated call to the old PL/SQL routine
1656: okl_dra_pvt.update_row(p_api_version,
1657: p_init_msg_list,
1658: x_return_status,
1659: x_msg_count,
1660: x_msg_data,

Line 1671: okl_dra_pvt_w.rosetta_table_copy_out_p2(ddx_drav_tbl, p6_a0

1667:
1668:
1669:
1670:
1671: okl_dra_pvt_w.rosetta_table_copy_out_p2(ddx_drav_tbl, p6_a0
1672: , p6_a1
1673: , p6_a2
1674: , p6_a3
1675: , p6_a4

Line 1758: ddp_drav_rec okl_dra_pvt.drav_rec_type;

1754: , p5_a37 NUMBER := 0-1962.0724
1755: )
1756:
1757: as
1758: ddp_drav_rec okl_dra_pvt.drav_rec_type;
1759: ddindx binary_integer; indx binary_integer;
1760: begin
1761:
1762: -- copy data to the local IN or IN-OUT args, if any

Line 1808: okl_dra_pvt.delete_row(p_api_version,

1804: ddp_drav_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a36);
1805: ddp_drav_rec.last_update_login := rosetta_g_miss_num_map(p5_a37);
1806:
1807: -- here's the delegated call to the old PL/SQL routine
1808: okl_dra_pvt.delete_row(p_api_version,
1809: p_init_msg_list,
1810: x_return_status,
1811: x_msg_count,
1812: x_msg_data,

Line 1869: ddp_drav_tbl okl_dra_pvt.drav_tbl_type;

1865: , p5_a37 JTF_NUMBER_TABLE
1866: )
1867:
1868: as
1869: ddp_drav_tbl okl_dra_pvt.drav_tbl_type;
1870: ddindx binary_integer; indx binary_integer;
1871: begin
1872:
1873: -- copy data to the local IN or IN-OUT args, if any

Line 1879: okl_dra_pvt_w.rosetta_table_copy_in_p2(ddp_drav_tbl, p5_a0

1875:
1876:
1877:
1878:
1879: okl_dra_pvt_w.rosetta_table_copy_in_p2(ddp_drav_tbl, p5_a0
1880: , p5_a1
1881: , p5_a2
1882: , p5_a3
1883: , p5_a4

Line 1920: okl_dra_pvt.delete_row(p_api_version,

1916: , p5_a37
1917: );
1918:
1919: -- here's the delegated call to the old PL/SQL routine
1920: okl_dra_pvt.delete_row(p_api_version,
1921: p_init_msg_list,
1922: x_return_status,
1923: x_msg_count,
1924: x_msg_data,

Line 1981: ddp_drav_rec okl_dra_pvt.drav_rec_type;

1977: , p5_a37 NUMBER := 0-1962.0724
1978: )
1979:
1980: as
1981: ddp_drav_rec okl_dra_pvt.drav_rec_type;
1982: ddindx binary_integer; indx binary_integer;
1983: begin
1984:
1985: -- copy data to the local IN or IN-OUT args, if any

Line 2031: okl_dra_pvt.validate_row(p_api_version,

2027: ddp_drav_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a36);
2028: ddp_drav_rec.last_update_login := rosetta_g_miss_num_map(p5_a37);
2029:
2030: -- here's the delegated call to the old PL/SQL routine
2031: okl_dra_pvt.validate_row(p_api_version,
2032: p_init_msg_list,
2033: x_return_status,
2034: x_msg_count,
2035: x_msg_data,

Line 2092: ddp_drav_tbl okl_dra_pvt.drav_tbl_type;

2088: , p5_a37 JTF_NUMBER_TABLE
2089: )
2090:
2091: as
2092: ddp_drav_tbl okl_dra_pvt.drav_tbl_type;
2093: ddindx binary_integer; indx binary_integer;
2094: begin
2095:
2096: -- copy data to the local IN or IN-OUT args, if any

Line 2102: okl_dra_pvt_w.rosetta_table_copy_in_p2(ddp_drav_tbl, p5_a0

2098:
2099:
2100:
2101:
2102: okl_dra_pvt_w.rosetta_table_copy_in_p2(ddp_drav_tbl, p5_a0
2103: , p5_a1
2104: , p5_a2
2105: , p5_a3
2106: , p5_a4

Line 2143: okl_dra_pvt.validate_row(p_api_version,

2139: , p5_a37
2140: );
2141:
2142: -- here's the delegated call to the old PL/SQL routine
2143: okl_dra_pvt.validate_row(p_api_version,
2144: p_init_msg_list,
2145: x_return_status,
2146: x_msg_count,
2147: x_msg_data,

Line 2158: end okl_dra_pvt_w;

2154:
2155:
2156: end;
2157:
2158: end okl_dra_pvt_w;