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_ACD_PVT_W dependencies on OKL_ACD_PVT

Line 1: package body okl_acd_pvt_w as

1: package body okl_acd_pvt_w as
2: /* $Header: OKLIACDB.pls 120.2 2005/12/02 12:57:10 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_acd_pvt.acd_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_acd_pvt.acd_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_DATE_TABLE
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_NUMBER_TABLE

Line 107: procedure rosetta_table_copy_out_p2(t okl_acd_pvt.acd_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

103: end loop;
104: end if;
105: end if;
106: end rosetta_table_copy_in_p2;
107: procedure rosetta_table_copy_out_p2(t okl_acd_pvt.acd_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
108: , a1 out nocopy JTF_DATE_TABLE
109: , a2 out nocopy JTF_VARCHAR2_TABLE_100
110: , a3 out nocopy JTF_NUMBER_TABLE
111: , a4 out nocopy JTF_NUMBER_TABLE

Line 296: procedure rosetta_table_copy_in_p5(t out nocopy okl_acd_pvt.acdv_tbl_type, a0 JTF_NUMBER_TABLE

292: end if;
293: end if;
294: end rosetta_table_copy_out_p2;
295:
296: procedure rosetta_table_copy_in_p5(t out nocopy okl_acd_pvt.acdv_tbl_type, a0 JTF_NUMBER_TABLE
297: , a1 JTF_NUMBER_TABLE
298: , a2 JTF_VARCHAR2_TABLE_100
299: , a3 JTF_NUMBER_TABLE
300: , a4 JTF_NUMBER_TABLE

Line 381: procedure rosetta_table_copy_out_p5(t okl_acd_pvt.acdv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

377: end loop;
378: end if;
379: end if;
380: end rosetta_table_copy_in_p5;
381: procedure rosetta_table_copy_out_p5(t okl_acd_pvt.acdv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
382: , a1 out nocopy JTF_NUMBER_TABLE
383: , a2 out nocopy JTF_VARCHAR2_TABLE_100
384: , a3 out nocopy JTF_NUMBER_TABLE
385: , a4 out nocopy JTF_NUMBER_TABLE

Line 646: ddp_acdv_rec okl_acd_pvt.acdv_rec_type;

642: , p5_a33 NUMBER := 0-1962.0724
643: )
644:
645: as
646: ddp_acdv_rec okl_acd_pvt.acdv_rec_type;
647: ddx_acdv_rec okl_acd_pvt.acdv_rec_type;
648: ddindx binary_integer; indx binary_integer;
649: begin
650:

Line 647: ddx_acdv_rec okl_acd_pvt.acdv_rec_type;

643: )
644:
645: as
646: ddp_acdv_rec okl_acd_pvt.acdv_rec_type;
647: ddx_acdv_rec okl_acd_pvt.acdv_rec_type;
648: ddindx binary_integer; indx binary_integer;
649: begin
650:
651: -- copy data to the local IN or IN-OUT args, if any

Line 694: okl_acd_pvt.insert_row(p_api_version,

690: ddp_acdv_rec.last_update_login := rosetta_g_miss_num_map(p5_a33);
691:
692:
693: -- here's the delegated call to the old PL/SQL routine
694: okl_acd_pvt.insert_row(p_api_version,
695: p_init_msg_list,
696: x_return_status,
697: x_msg_count,
698: x_msg_data,

Line 821: ddp_acdv_tbl okl_acd_pvt.acdv_tbl_type;

817: , p6_a33 out nocopy JTF_NUMBER_TABLE
818: )
819:
820: as
821: ddp_acdv_tbl okl_acd_pvt.acdv_tbl_type;
822: ddx_acdv_tbl okl_acd_pvt.acdv_tbl_type;
823: ddindx binary_integer; indx binary_integer;
824: begin
825:

Line 822: ddx_acdv_tbl okl_acd_pvt.acdv_tbl_type;

818: )
819:
820: as
821: ddp_acdv_tbl okl_acd_pvt.acdv_tbl_type;
822: ddx_acdv_tbl okl_acd_pvt.acdv_tbl_type;
823: ddindx binary_integer; indx binary_integer;
824: begin
825:
826: -- copy data to the local IN or IN-OUT args, if any

Line 832: okl_acd_pvt_w.rosetta_table_copy_in_p5(ddp_acdv_tbl, p5_a0

828:
829:
830:
831:
832: okl_acd_pvt_w.rosetta_table_copy_in_p5(ddp_acdv_tbl, p5_a0
833: , p5_a1
834: , p5_a2
835: , p5_a3
836: , p5_a4

Line 870: okl_acd_pvt.insert_row(p_api_version,

866: );
867:
868:
869: -- here's the delegated call to the old PL/SQL routine
870: okl_acd_pvt.insert_row(p_api_version,
871: p_init_msg_list,
872: x_return_status,
873: x_msg_count,
874: x_msg_data,

Line 885: okl_acd_pvt_w.rosetta_table_copy_out_p5(ddx_acdv_tbl, p6_a0

881:
882:
883:
884:
885: okl_acd_pvt_w.rosetta_table_copy_out_p5(ddx_acdv_tbl, p6_a0
886: , p6_a1
887: , p6_a2
888: , p6_a3
889: , p6_a4

Line 964: ddp_acdv_rec okl_acd_pvt.acdv_rec_type;

960: , p5_a33 NUMBER := 0-1962.0724
961: )
962:
963: as
964: ddp_acdv_rec okl_acd_pvt.acdv_rec_type;
965: ddindx binary_integer; indx binary_integer;
966: begin
967:
968: -- copy data to the local IN or IN-OUT args, if any

Line 1010: okl_acd_pvt.lock_row(p_api_version,

1006: ddp_acdv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a32);
1007: ddp_acdv_rec.last_update_login := rosetta_g_miss_num_map(p5_a33);
1008:
1009: -- here's the delegated call to the old PL/SQL routine
1010: okl_acd_pvt.lock_row(p_api_version,
1011: p_init_msg_list,
1012: x_return_status,
1013: x_msg_count,
1014: x_msg_data,

Line 1067: ddp_acdv_tbl okl_acd_pvt.acdv_tbl_type;

1063: , p5_a33 JTF_NUMBER_TABLE
1064: )
1065:
1066: as
1067: ddp_acdv_tbl okl_acd_pvt.acdv_tbl_type;
1068: ddindx binary_integer; indx binary_integer;
1069: begin
1070:
1071: -- copy data to the local IN or IN-OUT args, if any

Line 1077: okl_acd_pvt_w.rosetta_table_copy_in_p5(ddp_acdv_tbl, p5_a0

1073:
1074:
1075:
1076:
1077: okl_acd_pvt_w.rosetta_table_copy_in_p5(ddp_acdv_tbl, p5_a0
1078: , p5_a1
1079: , p5_a2
1080: , p5_a3
1081: , p5_a4

Line 1114: okl_acd_pvt.lock_row(p_api_version,

1110: , p5_a33
1111: );
1112:
1113: -- here's the delegated call to the old PL/SQL routine
1114: okl_acd_pvt.lock_row(p_api_version,
1115: p_init_msg_list,
1116: x_return_status,
1117: x_msg_count,
1118: x_msg_data,

Line 1205: ddp_acdv_rec okl_acd_pvt.acdv_rec_type;

1201: , p5_a33 NUMBER := 0-1962.0724
1202: )
1203:
1204: as
1205: ddp_acdv_rec okl_acd_pvt.acdv_rec_type;
1206: ddx_acdv_rec okl_acd_pvt.acdv_rec_type;
1207: ddindx binary_integer; indx binary_integer;
1208: begin
1209:

Line 1206: ddx_acdv_rec okl_acd_pvt.acdv_rec_type;

1202: )
1203:
1204: as
1205: ddp_acdv_rec okl_acd_pvt.acdv_rec_type;
1206: ddx_acdv_rec okl_acd_pvt.acdv_rec_type;
1207: ddindx binary_integer; indx binary_integer;
1208: begin
1209:
1210: -- copy data to the local IN or IN-OUT args, if any

Line 1253: okl_acd_pvt.update_row(p_api_version,

1249: ddp_acdv_rec.last_update_login := rosetta_g_miss_num_map(p5_a33);
1250:
1251:
1252: -- here's the delegated call to the old PL/SQL routine
1253: okl_acd_pvt.update_row(p_api_version,
1254: p_init_msg_list,
1255: x_return_status,
1256: x_msg_count,
1257: x_msg_data,

Line 1380: ddp_acdv_tbl okl_acd_pvt.acdv_tbl_type;

1376: , p6_a33 out nocopy JTF_NUMBER_TABLE
1377: )
1378:
1379: as
1380: ddp_acdv_tbl okl_acd_pvt.acdv_tbl_type;
1381: ddx_acdv_tbl okl_acd_pvt.acdv_tbl_type;
1382: ddindx binary_integer; indx binary_integer;
1383: begin
1384:

Line 1381: ddx_acdv_tbl okl_acd_pvt.acdv_tbl_type;

1377: )
1378:
1379: as
1380: ddp_acdv_tbl okl_acd_pvt.acdv_tbl_type;
1381: ddx_acdv_tbl okl_acd_pvt.acdv_tbl_type;
1382: ddindx binary_integer; indx binary_integer;
1383: begin
1384:
1385: -- copy data to the local IN or IN-OUT args, if any

Line 1391: okl_acd_pvt_w.rosetta_table_copy_in_p5(ddp_acdv_tbl, p5_a0

1387:
1388:
1389:
1390:
1391: okl_acd_pvt_w.rosetta_table_copy_in_p5(ddp_acdv_tbl, p5_a0
1392: , p5_a1
1393: , p5_a2
1394: , p5_a3
1395: , p5_a4

Line 1429: okl_acd_pvt.update_row(p_api_version,

1425: );
1426:
1427:
1428: -- here's the delegated call to the old PL/SQL routine
1429: okl_acd_pvt.update_row(p_api_version,
1430: p_init_msg_list,
1431: x_return_status,
1432: x_msg_count,
1433: x_msg_data,

Line 1444: okl_acd_pvt_w.rosetta_table_copy_out_p5(ddx_acdv_tbl, p6_a0

1440:
1441:
1442:
1443:
1444: okl_acd_pvt_w.rosetta_table_copy_out_p5(ddx_acdv_tbl, p6_a0
1445: , p6_a1
1446: , p6_a2
1447: , p6_a3
1448: , p6_a4

Line 1523: ddp_acdv_rec okl_acd_pvt.acdv_rec_type;

1519: , p5_a33 NUMBER := 0-1962.0724
1520: )
1521:
1522: as
1523: ddp_acdv_rec okl_acd_pvt.acdv_rec_type;
1524: ddindx binary_integer; indx binary_integer;
1525: begin
1526:
1527: -- copy data to the local IN or IN-OUT args, if any

Line 1569: okl_acd_pvt.delete_row(p_api_version,

1565: ddp_acdv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a32);
1566: ddp_acdv_rec.last_update_login := rosetta_g_miss_num_map(p5_a33);
1567:
1568: -- here's the delegated call to the old PL/SQL routine
1569: okl_acd_pvt.delete_row(p_api_version,
1570: p_init_msg_list,
1571: x_return_status,
1572: x_msg_count,
1573: x_msg_data,

Line 1626: ddp_acdv_tbl okl_acd_pvt.acdv_tbl_type;

1622: , p5_a33 JTF_NUMBER_TABLE
1623: )
1624:
1625: as
1626: ddp_acdv_tbl okl_acd_pvt.acdv_tbl_type;
1627: ddindx binary_integer; indx binary_integer;
1628: begin
1629:
1630: -- copy data to the local IN or IN-OUT args, if any

Line 1636: okl_acd_pvt_w.rosetta_table_copy_in_p5(ddp_acdv_tbl, p5_a0

1632:
1633:
1634:
1635:
1636: okl_acd_pvt_w.rosetta_table_copy_in_p5(ddp_acdv_tbl, p5_a0
1637: , p5_a1
1638: , p5_a2
1639: , p5_a3
1640: , p5_a4

Line 1673: okl_acd_pvt.delete_row(p_api_version,

1669: , p5_a33
1670: );
1671:
1672: -- here's the delegated call to the old PL/SQL routine
1673: okl_acd_pvt.delete_row(p_api_version,
1674: p_init_msg_list,
1675: x_return_status,
1676: x_msg_count,
1677: x_msg_data,

Line 1730: ddp_acdv_rec okl_acd_pvt.acdv_rec_type;

1726: , p5_a33 NUMBER := 0-1962.0724
1727: )
1728:
1729: as
1730: ddp_acdv_rec okl_acd_pvt.acdv_rec_type;
1731: ddindx binary_integer; indx binary_integer;
1732: begin
1733:
1734: -- copy data to the local IN or IN-OUT args, if any

Line 1776: okl_acd_pvt.validate_row(p_api_version,

1772: ddp_acdv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a32);
1773: ddp_acdv_rec.last_update_login := rosetta_g_miss_num_map(p5_a33);
1774:
1775: -- here's the delegated call to the old PL/SQL routine
1776: okl_acd_pvt.validate_row(p_api_version,
1777: p_init_msg_list,
1778: x_return_status,
1779: x_msg_count,
1780: x_msg_data,

Line 1833: ddp_acdv_tbl okl_acd_pvt.acdv_tbl_type;

1829: , p5_a33 JTF_NUMBER_TABLE
1830: )
1831:
1832: as
1833: ddp_acdv_tbl okl_acd_pvt.acdv_tbl_type;
1834: ddindx binary_integer; indx binary_integer;
1835: begin
1836:
1837: -- copy data to the local IN or IN-OUT args, if any

Line 1843: okl_acd_pvt_w.rosetta_table_copy_in_p5(ddp_acdv_tbl, p5_a0

1839:
1840:
1841:
1842:
1843: okl_acd_pvt_w.rosetta_table_copy_in_p5(ddp_acdv_tbl, p5_a0
1844: , p5_a1
1845: , p5_a2
1846: , p5_a3
1847: , p5_a4

Line 1880: okl_acd_pvt.validate_row(p_api_version,

1876: , p5_a33
1877: );
1878:
1879: -- here's the delegated call to the old PL/SQL routine
1880: okl_acd_pvt.validate_row(p_api_version,
1881: p_init_msg_list,
1882: x_return_status,
1883: x_msg_count,
1884: x_msg_data,

Line 1895: end okl_acd_pvt_w;

1891:
1892:
1893: end;
1894:
1895: end okl_acd_pvt_w;