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_ATL_PVT_W dependencies on OKL_ATL_PVT

Line 1: package body okl_atl_pvt_w as

1: package body okl_atl_pvt_w as
2: /* $Header: OKLIATLB.pls 115.6 2003/03/26 19:47:49 hkpatel 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_atl_pvt.atl_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_atl_pvt.atl_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 103: procedure rosetta_table_copy_out_p2(t okl_atl_pvt.atl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

99: end loop;
100: end if;
101: end if;
102: end rosetta_table_copy_in_p2;
103: procedure rosetta_table_copy_out_p2(t okl_atl_pvt.atl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
104: , a1 out nocopy JTF_NUMBER_TABLE
105: , a2 out nocopy JTF_NUMBER_TABLE
106: , a3 out nocopy JTF_NUMBER_TABLE
107: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 282: procedure rosetta_table_copy_in_p5(t out nocopy okl_atl_pvt.atlv_tbl_type, a0 JTF_NUMBER_TABLE

278: end if;
279: end if;
280: end rosetta_table_copy_out_p2;
281:
282: procedure rosetta_table_copy_in_p5(t out nocopy okl_atl_pvt.atlv_tbl_type, a0 JTF_NUMBER_TABLE
283: , a1 JTF_NUMBER_TABLE
284: , a2 JTF_NUMBER_TABLE
285: , a3 JTF_VARCHAR2_TABLE_100
286: , a4 JTF_NUMBER_TABLE

Line 365: procedure rosetta_table_copy_out_p5(t okl_atl_pvt.atlv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

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

Line 623: ddp_atlv_rec okl_atl_pvt.atlv_rec_type;

619: , p5_a32 NUMBER := 0-1962.0724
620: )
621:
622: as
623: ddp_atlv_rec okl_atl_pvt.atlv_rec_type;
624: ddx_atlv_rec okl_atl_pvt.atlv_rec_type;
625: ddindx binary_integer; indx binary_integer;
626: begin
627:

Line 624: ddx_atlv_rec okl_atl_pvt.atlv_rec_type;

620: )
621:
622: as
623: ddp_atlv_rec okl_atl_pvt.atlv_rec_type;
624: ddx_atlv_rec okl_atl_pvt.atlv_rec_type;
625: ddindx binary_integer; indx binary_integer;
626: begin
627:
628: -- copy data to the local IN or IN-OUT args, if any

Line 670: okl_atl_pvt.insert_row(p_api_version,

666: ddp_atlv_rec.last_update_login := rosetta_g_miss_num_map(p5_a32);
667:
668:
669: -- here's the delegated call to the old PL/SQL routine
670: okl_atl_pvt.insert_row(p_api_version,
671: p_init_msg_list,
672: x_return_status,
673: x_msg_count,
674: x_msg_data,

Line 794: ddp_atlv_tbl okl_atl_pvt.atlv_tbl_type;

790: , p6_a32 out nocopy JTF_NUMBER_TABLE
791: )
792:
793: as
794: ddp_atlv_tbl okl_atl_pvt.atlv_tbl_type;
795: ddx_atlv_tbl okl_atl_pvt.atlv_tbl_type;
796: ddindx binary_integer; indx binary_integer;
797: begin
798:

Line 795: ddx_atlv_tbl okl_atl_pvt.atlv_tbl_type;

791: )
792:
793: as
794: ddp_atlv_tbl okl_atl_pvt.atlv_tbl_type;
795: ddx_atlv_tbl okl_atl_pvt.atlv_tbl_type;
796: ddindx binary_integer; indx binary_integer;
797: begin
798:
799: -- copy data to the local IN or IN-OUT args, if any

Line 805: okl_atl_pvt_w.rosetta_table_copy_in_p5(ddp_atlv_tbl, p5_a0

801:
802:
803:
804:
805: okl_atl_pvt_w.rosetta_table_copy_in_p5(ddp_atlv_tbl, p5_a0
806: , p5_a1
807: , p5_a2
808: , p5_a3
809: , p5_a4

Line 842: okl_atl_pvt.insert_row(p_api_version,

838: );
839:
840:
841: -- here's the delegated call to the old PL/SQL routine
842: okl_atl_pvt.insert_row(p_api_version,
843: p_init_msg_list,
844: x_return_status,
845: x_msg_count,
846: x_msg_data,

Line 857: okl_atl_pvt_w.rosetta_table_copy_out_p5(ddx_atlv_tbl, p6_a0

853:
854:
855:
856:
857: okl_atl_pvt_w.rosetta_table_copy_out_p5(ddx_atlv_tbl, p6_a0
858: , p6_a1
859: , p6_a2
860: , p6_a3
861: , p6_a4

Line 934: ddp_atlv_rec okl_atl_pvt.atlv_rec_type;

930: , p5_a32 NUMBER := 0-1962.0724
931: )
932:
933: as
934: ddp_atlv_rec okl_atl_pvt.atlv_rec_type;
935: ddindx binary_integer; indx binary_integer;
936: begin
937:
938: -- copy data to the local IN or IN-OUT args, if any

Line 979: okl_atl_pvt.lock_row(p_api_version,

975: ddp_atlv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a31);
976: ddp_atlv_rec.last_update_login := rosetta_g_miss_num_map(p5_a32);
977:
978: -- here's the delegated call to the old PL/SQL routine
979: okl_atl_pvt.lock_row(p_api_version,
980: p_init_msg_list,
981: x_return_status,
982: x_msg_count,
983: x_msg_data,

Line 1035: ddp_atlv_tbl okl_atl_pvt.atlv_tbl_type;

1031: , p5_a32 JTF_NUMBER_TABLE
1032: )
1033:
1034: as
1035: ddp_atlv_tbl okl_atl_pvt.atlv_tbl_type;
1036: ddindx binary_integer; indx binary_integer;
1037: begin
1038:
1039: -- copy data to the local IN or IN-OUT args, if any

Line 1045: okl_atl_pvt_w.rosetta_table_copy_in_p5(ddp_atlv_tbl, p5_a0

1041:
1042:
1043:
1044:
1045: okl_atl_pvt_w.rosetta_table_copy_in_p5(ddp_atlv_tbl, p5_a0
1046: , p5_a1
1047: , p5_a2
1048: , p5_a3
1049: , p5_a4

Line 1081: okl_atl_pvt.lock_row(p_api_version,

1077: , p5_a32
1078: );
1079:
1080: -- here's the delegated call to the old PL/SQL routine
1081: okl_atl_pvt.lock_row(p_api_version,
1082: p_init_msg_list,
1083: x_return_status,
1084: x_msg_count,
1085: x_msg_data,

Line 1170: ddp_atlv_rec okl_atl_pvt.atlv_rec_type;

1166: , p5_a32 NUMBER := 0-1962.0724
1167: )
1168:
1169: as
1170: ddp_atlv_rec okl_atl_pvt.atlv_rec_type;
1171: ddx_atlv_rec okl_atl_pvt.atlv_rec_type;
1172: ddindx binary_integer; indx binary_integer;
1173: begin
1174:

Line 1171: ddx_atlv_rec okl_atl_pvt.atlv_rec_type;

1167: )
1168:
1169: as
1170: ddp_atlv_rec okl_atl_pvt.atlv_rec_type;
1171: ddx_atlv_rec okl_atl_pvt.atlv_rec_type;
1172: ddindx binary_integer; indx binary_integer;
1173: begin
1174:
1175: -- copy data to the local IN or IN-OUT args, if any

Line 1217: okl_atl_pvt.update_row(p_api_version,

1213: ddp_atlv_rec.last_update_login := rosetta_g_miss_num_map(p5_a32);
1214:
1215:
1216: -- here's the delegated call to the old PL/SQL routine
1217: okl_atl_pvt.update_row(p_api_version,
1218: p_init_msg_list,
1219: x_return_status,
1220: x_msg_count,
1221: x_msg_data,

Line 1341: ddp_atlv_tbl okl_atl_pvt.atlv_tbl_type;

1337: , p6_a32 out nocopy JTF_NUMBER_TABLE
1338: )
1339:
1340: as
1341: ddp_atlv_tbl okl_atl_pvt.atlv_tbl_type;
1342: ddx_atlv_tbl okl_atl_pvt.atlv_tbl_type;
1343: ddindx binary_integer; indx binary_integer;
1344: begin
1345:

Line 1342: ddx_atlv_tbl okl_atl_pvt.atlv_tbl_type;

1338: )
1339:
1340: as
1341: ddp_atlv_tbl okl_atl_pvt.atlv_tbl_type;
1342: ddx_atlv_tbl okl_atl_pvt.atlv_tbl_type;
1343: ddindx binary_integer; indx binary_integer;
1344: begin
1345:
1346: -- copy data to the local IN or IN-OUT args, if any

Line 1352: okl_atl_pvt_w.rosetta_table_copy_in_p5(ddp_atlv_tbl, p5_a0

1348:
1349:
1350:
1351:
1352: okl_atl_pvt_w.rosetta_table_copy_in_p5(ddp_atlv_tbl, p5_a0
1353: , p5_a1
1354: , p5_a2
1355: , p5_a3
1356: , p5_a4

Line 1389: okl_atl_pvt.update_row(p_api_version,

1385: );
1386:
1387:
1388: -- here's the delegated call to the old PL/SQL routine
1389: okl_atl_pvt.update_row(p_api_version,
1390: p_init_msg_list,
1391: x_return_status,
1392: x_msg_count,
1393: x_msg_data,

Line 1404: okl_atl_pvt_w.rosetta_table_copy_out_p5(ddx_atlv_tbl, p6_a0

1400:
1401:
1402:
1403:
1404: okl_atl_pvt_w.rosetta_table_copy_out_p5(ddx_atlv_tbl, p6_a0
1405: , p6_a1
1406: , p6_a2
1407: , p6_a3
1408: , p6_a4

Line 1481: ddp_atlv_rec okl_atl_pvt.atlv_rec_type;

1477: , p5_a32 NUMBER := 0-1962.0724
1478: )
1479:
1480: as
1481: ddp_atlv_rec okl_atl_pvt.atlv_rec_type;
1482: ddindx binary_integer; indx binary_integer;
1483: begin
1484:
1485: -- copy data to the local IN or IN-OUT args, if any

Line 1526: okl_atl_pvt.delete_row(p_api_version,

1522: ddp_atlv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a31);
1523: ddp_atlv_rec.last_update_login := rosetta_g_miss_num_map(p5_a32);
1524:
1525: -- here's the delegated call to the old PL/SQL routine
1526: okl_atl_pvt.delete_row(p_api_version,
1527: p_init_msg_list,
1528: x_return_status,
1529: x_msg_count,
1530: x_msg_data,

Line 1582: ddp_atlv_tbl okl_atl_pvt.atlv_tbl_type;

1578: , p5_a32 JTF_NUMBER_TABLE
1579: )
1580:
1581: as
1582: ddp_atlv_tbl okl_atl_pvt.atlv_tbl_type;
1583: ddindx binary_integer; indx binary_integer;
1584: begin
1585:
1586: -- copy data to the local IN or IN-OUT args, if any

Line 1592: okl_atl_pvt_w.rosetta_table_copy_in_p5(ddp_atlv_tbl, p5_a0

1588:
1589:
1590:
1591:
1592: okl_atl_pvt_w.rosetta_table_copy_in_p5(ddp_atlv_tbl, p5_a0
1593: , p5_a1
1594: , p5_a2
1595: , p5_a3
1596: , p5_a4

Line 1628: okl_atl_pvt.delete_row(p_api_version,

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

Line 1684: ddp_atlv_rec okl_atl_pvt.atlv_rec_type;

1680: , p5_a32 NUMBER := 0-1962.0724
1681: )
1682:
1683: as
1684: ddp_atlv_rec okl_atl_pvt.atlv_rec_type;
1685: ddindx binary_integer; indx binary_integer;
1686: begin
1687:
1688: -- copy data to the local IN or IN-OUT args, if any

Line 1729: okl_atl_pvt.validate_row(p_api_version,

1725: ddp_atlv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a31);
1726: ddp_atlv_rec.last_update_login := rosetta_g_miss_num_map(p5_a32);
1727:
1728: -- here's the delegated call to the old PL/SQL routine
1729: okl_atl_pvt.validate_row(p_api_version,
1730: p_init_msg_list,
1731: x_return_status,
1732: x_msg_count,
1733: x_msg_data,

Line 1785: ddp_atlv_tbl okl_atl_pvt.atlv_tbl_type;

1781: , p5_a32 JTF_NUMBER_TABLE
1782: )
1783:
1784: as
1785: ddp_atlv_tbl okl_atl_pvt.atlv_tbl_type;
1786: ddindx binary_integer; indx binary_integer;
1787: begin
1788:
1789: -- copy data to the local IN or IN-OUT args, if any

Line 1795: okl_atl_pvt_w.rosetta_table_copy_in_p5(ddp_atlv_tbl, p5_a0

1791:
1792:
1793:
1794:
1795: okl_atl_pvt_w.rosetta_table_copy_in_p5(ddp_atlv_tbl, p5_a0
1796: , p5_a1
1797: , p5_a2
1798: , p5_a3
1799: , p5_a4

Line 1831: okl_atl_pvt.validate_row(p_api_version,

1827: , p5_a32
1828: );
1829:
1830: -- here's the delegated call to the old PL/SQL routine
1831: okl_atl_pvt.validate_row(p_api_version,
1832: p_init_msg_list,
1833: x_return_status,
1834: x_msg_count,
1835: x_msg_data,

Line 1846: end okl_atl_pvt_w;

1842:
1843:
1844: end;
1845:
1846: end okl_atl_pvt_w;