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_ILT_PVT_W dependencies on OKL_ILT_PVT

Line 1: package body okl_ilt_pvt_w as

1: package body okl_ilt_pvt_w as
2: /* $Header: OKLIILTB.pls 120.1 2005/07/13 09:27:51 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_ilt_pvt.ilt_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_ilt_pvt.ilt_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 89: procedure rosetta_table_copy_out_p2(t okl_ilt_pvt.ilt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

85: end loop;
86: end if;
87: end if;
88: end rosetta_table_copy_in_p2;
89: procedure rosetta_table_copy_out_p2(t okl_ilt_pvt.ilt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
90: , a1 out nocopy JTF_NUMBER_TABLE
91: , a2 out nocopy JTF_NUMBER_TABLE
92: , a3 out nocopy JTF_NUMBER_TABLE
93: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 233: procedure rosetta_table_copy_in_p5(t out nocopy okl_ilt_pvt.oklinvclinetypestltbltype, a0 JTF_NUMBER_TABLE

229: end if;
230: end if;
231: end rosetta_table_copy_out_p2;
232:
233: procedure rosetta_table_copy_in_p5(t out nocopy okl_ilt_pvt.oklinvclinetypestltbltype, a0 JTF_NUMBER_TABLE
234: , a1 JTF_VARCHAR2_TABLE_100
235: , a2 JTF_VARCHAR2_TABLE_100
236: , a3 JTF_VARCHAR2_TABLE_100
237: , a4 JTF_VARCHAR2_TABLE_200

Line 272: procedure rosetta_table_copy_out_p5(t okl_ilt_pvt.oklinvclinetypestltbltype, a0 out nocopy JTF_NUMBER_TABLE

268: end loop;
269: end if;
270: end if;
271: end rosetta_table_copy_in_p5;
272: procedure rosetta_table_copy_out_p5(t okl_ilt_pvt.oklinvclinetypestltbltype, a0 out nocopy JTF_NUMBER_TABLE
273: , a1 out nocopy JTF_VARCHAR2_TABLE_100
274: , a2 out nocopy JTF_VARCHAR2_TABLE_100
275: , a3 out nocopy JTF_VARCHAR2_TABLE_100
276: , a4 out nocopy JTF_VARCHAR2_TABLE_200

Line 346: procedure rosetta_table_copy_in_p8(t out nocopy okl_ilt_pvt.iltv_tbl_type, a0 JTF_NUMBER_TABLE

342: end if;
343: end if;
344: end rosetta_table_copy_out_p5;
345:
346: procedure rosetta_table_copy_in_p8(t out nocopy okl_ilt_pvt.iltv_tbl_type, a0 JTF_NUMBER_TABLE
347: , a1 JTF_NUMBER_TABLE
348: , a2 JTF_VARCHAR2_TABLE_100
349: , a3 JTF_NUMBER_TABLE
350: , a4 JTF_NUMBER_TABLE

Line 419: procedure rosetta_table_copy_out_p8(t okl_ilt_pvt.iltv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

415: end loop;
416: end if;
417: end if;
418: end rosetta_table_copy_in_p8;
419: procedure rosetta_table_copy_out_p8(t okl_ilt_pvt.iltv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
420: , a1 out nocopy JTF_NUMBER_TABLE
421: , a2 out nocopy JTF_VARCHAR2_TABLE_100
422: , a3 out nocopy JTF_NUMBER_TABLE
423: , a4 out nocopy JTF_NUMBER_TABLE

Line 642: ddp_iltv_rec okl_ilt_pvt.iltv_rec_type;

638: , p5_a27 NUMBER := 0-1962.0724
639: )
640:
641: as
642: ddp_iltv_rec okl_ilt_pvt.iltv_rec_type;
643: ddx_iltv_rec okl_ilt_pvt.iltv_rec_type;
644: ddindx binary_integer; indx binary_integer;
645: begin
646:

Line 643: ddx_iltv_rec okl_ilt_pvt.iltv_rec_type;

639: )
640:
641: as
642: ddp_iltv_rec okl_ilt_pvt.iltv_rec_type;
643: ddx_iltv_rec okl_ilt_pvt.iltv_rec_type;
644: ddindx binary_integer; indx binary_integer;
645: begin
646:
647: -- copy data to the local IN or IN-OUT args, if any

Line 684: okl_ilt_pvt.insert_row(p_api_version,

680: ddp_iltv_rec.last_update_login := rosetta_g_miss_num_map(p5_a27);
681:
682:
683: -- here's the delegated call to the old PL/SQL routine
684: okl_ilt_pvt.insert_row(p_api_version,
685: p_init_msg_list,
686: x_return_status,
687: x_msg_count,
688: x_msg_data,

Line 793: ddp_iltv_tbl okl_ilt_pvt.iltv_tbl_type;

789: , p6_a27 out nocopy JTF_NUMBER_TABLE
790: )
791:
792: as
793: ddp_iltv_tbl okl_ilt_pvt.iltv_tbl_type;
794: ddx_iltv_tbl okl_ilt_pvt.iltv_tbl_type;
795: ddindx binary_integer; indx binary_integer;
796: begin
797:

Line 794: ddx_iltv_tbl okl_ilt_pvt.iltv_tbl_type;

790: )
791:
792: as
793: ddp_iltv_tbl okl_ilt_pvt.iltv_tbl_type;
794: ddx_iltv_tbl okl_ilt_pvt.iltv_tbl_type;
795: ddindx binary_integer; indx binary_integer;
796: begin
797:
798: -- copy data to the local IN or IN-OUT args, if any

Line 804: okl_ilt_pvt_w.rosetta_table_copy_in_p8(ddp_iltv_tbl, p5_a0

800:
801:
802:
803:
804: okl_ilt_pvt_w.rosetta_table_copy_in_p8(ddp_iltv_tbl, p5_a0
805: , p5_a1
806: , p5_a2
807: , p5_a3
808: , p5_a4

Line 836: okl_ilt_pvt.insert_row(p_api_version,

832: );
833:
834:
835: -- here's the delegated call to the old PL/SQL routine
836: okl_ilt_pvt.insert_row(p_api_version,
837: p_init_msg_list,
838: x_return_status,
839: x_msg_count,
840: x_msg_data,

Line 851: okl_ilt_pvt_w.rosetta_table_copy_out_p8(ddx_iltv_tbl, p6_a0

847:
848:
849:
850:
851: okl_ilt_pvt_w.rosetta_table_copy_out_p8(ddx_iltv_tbl, p6_a0
852: , p6_a1
853: , p6_a2
854: , p6_a3
855: , p6_a4

Line 918: ddp_iltv_rec okl_ilt_pvt.iltv_rec_type;

914: , p5_a27 NUMBER := 0-1962.0724
915: )
916:
917: as
918: ddp_iltv_rec okl_ilt_pvt.iltv_rec_type;
919: ddindx binary_integer; indx binary_integer;
920: begin
921:
922: -- copy data to the local IN or IN-OUT args, if any

Line 958: okl_ilt_pvt.lock_row(p_api_version,

954: ddp_iltv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a26);
955: ddp_iltv_rec.last_update_login := rosetta_g_miss_num_map(p5_a27);
956:
957: -- here's the delegated call to the old PL/SQL routine
958: okl_ilt_pvt.lock_row(p_api_version,
959: p_init_msg_list,
960: x_return_status,
961: x_msg_count,
962: x_msg_data,

Line 1009: ddp_iltv_tbl okl_ilt_pvt.iltv_tbl_type;

1005: , p5_a27 JTF_NUMBER_TABLE
1006: )
1007:
1008: as
1009: ddp_iltv_tbl okl_ilt_pvt.iltv_tbl_type;
1010: ddindx binary_integer; indx binary_integer;
1011: begin
1012:
1013: -- copy data to the local IN or IN-OUT args, if any

Line 1019: okl_ilt_pvt_w.rosetta_table_copy_in_p8(ddp_iltv_tbl, p5_a0

1015:
1016:
1017:
1018:
1019: okl_ilt_pvt_w.rosetta_table_copy_in_p8(ddp_iltv_tbl, p5_a0
1020: , p5_a1
1021: , p5_a2
1022: , p5_a3
1023: , p5_a4

Line 1050: okl_ilt_pvt.lock_row(p_api_version,

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

Line 1129: ddp_iltv_rec okl_ilt_pvt.iltv_rec_type;

1125: , p5_a27 NUMBER := 0-1962.0724
1126: )
1127:
1128: as
1129: ddp_iltv_rec okl_ilt_pvt.iltv_rec_type;
1130: ddx_iltv_rec okl_ilt_pvt.iltv_rec_type;
1131: ddindx binary_integer; indx binary_integer;
1132: begin
1133:

Line 1130: ddx_iltv_rec okl_ilt_pvt.iltv_rec_type;

1126: )
1127:
1128: as
1129: ddp_iltv_rec okl_ilt_pvt.iltv_rec_type;
1130: ddx_iltv_rec okl_ilt_pvt.iltv_rec_type;
1131: ddindx binary_integer; indx binary_integer;
1132: begin
1133:
1134: -- copy data to the local IN or IN-OUT args, if any

Line 1171: okl_ilt_pvt.update_row(p_api_version,

1167: ddp_iltv_rec.last_update_login := rosetta_g_miss_num_map(p5_a27);
1168:
1169:
1170: -- here's the delegated call to the old PL/SQL routine
1171: okl_ilt_pvt.update_row(p_api_version,
1172: p_init_msg_list,
1173: x_return_status,
1174: x_msg_count,
1175: x_msg_data,

Line 1280: ddp_iltv_tbl okl_ilt_pvt.iltv_tbl_type;

1276: , p6_a27 out nocopy JTF_NUMBER_TABLE
1277: )
1278:
1279: as
1280: ddp_iltv_tbl okl_ilt_pvt.iltv_tbl_type;
1281: ddx_iltv_tbl okl_ilt_pvt.iltv_tbl_type;
1282: ddindx binary_integer; indx binary_integer;
1283: begin
1284:

Line 1281: ddx_iltv_tbl okl_ilt_pvt.iltv_tbl_type;

1277: )
1278:
1279: as
1280: ddp_iltv_tbl okl_ilt_pvt.iltv_tbl_type;
1281: ddx_iltv_tbl okl_ilt_pvt.iltv_tbl_type;
1282: ddindx binary_integer; indx binary_integer;
1283: begin
1284:
1285: -- copy data to the local IN or IN-OUT args, if any

Line 1291: okl_ilt_pvt_w.rosetta_table_copy_in_p8(ddp_iltv_tbl, p5_a0

1287:
1288:
1289:
1290:
1291: okl_ilt_pvt_w.rosetta_table_copy_in_p8(ddp_iltv_tbl, p5_a0
1292: , p5_a1
1293: , p5_a2
1294: , p5_a3
1295: , p5_a4

Line 1323: okl_ilt_pvt.update_row(p_api_version,

1319: );
1320:
1321:
1322: -- here's the delegated call to the old PL/SQL routine
1323: okl_ilt_pvt.update_row(p_api_version,
1324: p_init_msg_list,
1325: x_return_status,
1326: x_msg_count,
1327: x_msg_data,

Line 1338: okl_ilt_pvt_w.rosetta_table_copy_out_p8(ddx_iltv_tbl, p6_a0

1334:
1335:
1336:
1337:
1338: okl_ilt_pvt_w.rosetta_table_copy_out_p8(ddx_iltv_tbl, p6_a0
1339: , p6_a1
1340: , p6_a2
1341: , p6_a3
1342: , p6_a4

Line 1405: ddp_iltv_rec okl_ilt_pvt.iltv_rec_type;

1401: , p5_a27 NUMBER := 0-1962.0724
1402: )
1403:
1404: as
1405: ddp_iltv_rec okl_ilt_pvt.iltv_rec_type;
1406: ddindx binary_integer; indx binary_integer;
1407: begin
1408:
1409: -- copy data to the local IN or IN-OUT args, if any

Line 1445: okl_ilt_pvt.delete_row(p_api_version,

1441: ddp_iltv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a26);
1442: ddp_iltv_rec.last_update_login := rosetta_g_miss_num_map(p5_a27);
1443:
1444: -- here's the delegated call to the old PL/SQL routine
1445: okl_ilt_pvt.delete_row(p_api_version,
1446: p_init_msg_list,
1447: x_return_status,
1448: x_msg_count,
1449: x_msg_data,

Line 1496: ddp_iltv_tbl okl_ilt_pvt.iltv_tbl_type;

1492: , p5_a27 JTF_NUMBER_TABLE
1493: )
1494:
1495: as
1496: ddp_iltv_tbl okl_ilt_pvt.iltv_tbl_type;
1497: ddindx binary_integer; indx binary_integer;
1498: begin
1499:
1500: -- copy data to the local IN or IN-OUT args, if any

Line 1506: okl_ilt_pvt_w.rosetta_table_copy_in_p8(ddp_iltv_tbl, p5_a0

1502:
1503:
1504:
1505:
1506: okl_ilt_pvt_w.rosetta_table_copy_in_p8(ddp_iltv_tbl, p5_a0
1507: , p5_a1
1508: , p5_a2
1509: , p5_a3
1510: , p5_a4

Line 1537: okl_ilt_pvt.delete_row(p_api_version,

1533: , p5_a27
1534: );
1535:
1536: -- here's the delegated call to the old PL/SQL routine
1537: okl_ilt_pvt.delete_row(p_api_version,
1538: p_init_msg_list,
1539: x_return_status,
1540: x_msg_count,
1541: x_msg_data,

Line 1588: ddp_iltv_rec okl_ilt_pvt.iltv_rec_type;

1584: , p5_a27 NUMBER := 0-1962.0724
1585: )
1586:
1587: as
1588: ddp_iltv_rec okl_ilt_pvt.iltv_rec_type;
1589: ddindx binary_integer; indx binary_integer;
1590: begin
1591:
1592: -- copy data to the local IN or IN-OUT args, if any

Line 1628: okl_ilt_pvt.validate_row(p_api_version,

1624: ddp_iltv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a26);
1625: ddp_iltv_rec.last_update_login := rosetta_g_miss_num_map(p5_a27);
1626:
1627: -- here's the delegated call to the old PL/SQL routine
1628: okl_ilt_pvt.validate_row(p_api_version,
1629: p_init_msg_list,
1630: x_return_status,
1631: x_msg_count,
1632: x_msg_data,

Line 1679: ddp_iltv_tbl okl_ilt_pvt.iltv_tbl_type;

1675: , p5_a27 JTF_NUMBER_TABLE
1676: )
1677:
1678: as
1679: ddp_iltv_tbl okl_ilt_pvt.iltv_tbl_type;
1680: ddindx binary_integer; indx binary_integer;
1681: begin
1682:
1683: -- copy data to the local IN or IN-OUT args, if any

Line 1689: okl_ilt_pvt_w.rosetta_table_copy_in_p8(ddp_iltv_tbl, p5_a0

1685:
1686:
1687:
1688:
1689: okl_ilt_pvt_w.rosetta_table_copy_in_p8(ddp_iltv_tbl, p5_a0
1690: , p5_a1
1691: , p5_a2
1692: , p5_a3
1693: , p5_a4

Line 1720: okl_ilt_pvt.validate_row(p_api_version,

1716: , p5_a27
1717: );
1718:
1719: -- here's the delegated call to the old PL/SQL routine
1720: okl_ilt_pvt.validate_row(p_api_version,
1721: p_init_msg_list,
1722: x_return_status,
1723: x_msg_count,
1724: x_msg_data,

Line 1735: end okl_ilt_pvt_w;

1731:
1732:
1733: end;
1734:
1735: end okl_ilt_pvt_w;