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_IEN_PVT_W dependencies on OKL_IEN_PVT

Line 1: package body okl_ien_pvt_w as

1: package body okl_ien_pvt_w as
2: /* $Header: OKLIIENB.pls 120.1 2005/07/13 09:27:08 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_ien_pvt.ien_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_ien_pvt.ien_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_DATE_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_NUMBER_TABLE

Line 95: procedure rosetta_table_copy_out_p2(t okl_ien_pvt.ien_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

91: end loop;
92: end if;
93: end if;
94: end rosetta_table_copy_in_p2;
95: procedure rosetta_table_copy_out_p2(t okl_ien_pvt.ien_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
96: , a1 out nocopy JTF_VARCHAR2_TABLE_100
97: , a2 out nocopy JTF_DATE_TABLE
98: , a3 out nocopy JTF_NUMBER_TABLE
99: , a4 out nocopy JTF_NUMBER_TABLE

Line 254: procedure rosetta_table_copy_in_p5(t out nocopy okl_ien_pvt.okl_ins_exclusions_tl_tbl_type, a0 JTF_NUMBER_TABLE

250: end if;
251: end if;
252: end rosetta_table_copy_out_p2;
253:
254: procedure rosetta_table_copy_in_p5(t out nocopy okl_ien_pvt.okl_ins_exclusions_tl_tbl_type, a0 JTF_NUMBER_TABLE
255: , a1 JTF_VARCHAR2_TABLE_100
256: , a2 JTF_VARCHAR2_TABLE_100
257: , a3 JTF_VARCHAR2_TABLE_100
258: , a4 JTF_VARCHAR2_TABLE_2000

Line 291: procedure rosetta_table_copy_out_p5(t okl_ien_pvt.okl_ins_exclusions_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

287: end loop;
288: end if;
289: end if;
290: end rosetta_table_copy_in_p5;
291: procedure rosetta_table_copy_out_p5(t okl_ien_pvt.okl_ins_exclusions_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
292: , a1 out nocopy JTF_VARCHAR2_TABLE_100
293: , a2 out nocopy JTF_VARCHAR2_TABLE_100
294: , a3 out nocopy JTF_VARCHAR2_TABLE_100
295: , a4 out nocopy JTF_VARCHAR2_TABLE_2000

Line 360: procedure rosetta_table_copy_in_p8(t out nocopy okl_ien_pvt.ienv_tbl_type, a0 JTF_NUMBER_TABLE

356: end if;
357: end if;
358: end rosetta_table_copy_out_p5;
359:
360: procedure rosetta_table_copy_in_p8(t out nocopy okl_ien_pvt.ienv_tbl_type, a0 JTF_NUMBER_TABLE
361: , a1 JTF_NUMBER_TABLE
362: , a2 JTF_VARCHAR2_TABLE_100
363: , a3 JTF_VARCHAR2_TABLE_100
364: , a4 JTF_NUMBER_TABLE

Line 437: procedure rosetta_table_copy_out_p8(t okl_ien_pvt.ienv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

433: end loop;
434: end if;
435: end if;
436: end rosetta_table_copy_in_p8;
437: procedure rosetta_table_copy_out_p8(t okl_ien_pvt.ienv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
438: , a1 out nocopy JTF_NUMBER_TABLE
439: , a2 out nocopy JTF_VARCHAR2_TABLE_100
440: , a3 out nocopy JTF_VARCHAR2_TABLE_100
441: , a4 out nocopy JTF_NUMBER_TABLE

Line 674: ddp_ienv_rec okl_ien_pvt.ienv_rec_type;

670: , p5_a29 NUMBER := 0-1962.0724
671: )
672:
673: as
674: ddp_ienv_rec okl_ien_pvt.ienv_rec_type;
675: ddx_ienv_rec okl_ien_pvt.ienv_rec_type;
676: ddindx binary_integer; indx binary_integer;
677: begin
678:

Line 675: ddx_ienv_rec okl_ien_pvt.ienv_rec_type;

671: )
672:
673: as
674: ddp_ienv_rec okl_ien_pvt.ienv_rec_type;
675: ddx_ienv_rec okl_ien_pvt.ienv_rec_type;
676: ddindx binary_integer; indx binary_integer;
677: begin
678:
679: -- copy data to the local IN or IN-OUT args, if any

Line 718: okl_ien_pvt.insert_row(p_api_version,

714: ddp_ienv_rec.last_update_login := rosetta_g_miss_num_map(p5_a29);
715:
716:
717: -- here's the delegated call to the old PL/SQL routine
718: okl_ien_pvt.insert_row(p_api_version,
719: p_init_msg_list,
720: x_return_status,
721: x_msg_count,
722: x_msg_data,

Line 833: ddp_ienv_tbl okl_ien_pvt.ienv_tbl_type;

829: , p6_a29 out nocopy JTF_NUMBER_TABLE
830: )
831:
832: as
833: ddp_ienv_tbl okl_ien_pvt.ienv_tbl_type;
834: ddx_ienv_tbl okl_ien_pvt.ienv_tbl_type;
835: ddindx binary_integer; indx binary_integer;
836: begin
837:

Line 834: ddx_ienv_tbl okl_ien_pvt.ienv_tbl_type;

830: )
831:
832: as
833: ddp_ienv_tbl okl_ien_pvt.ienv_tbl_type;
834: ddx_ienv_tbl okl_ien_pvt.ienv_tbl_type;
835: ddindx binary_integer; indx binary_integer;
836: begin
837:
838: -- copy data to the local IN or IN-OUT args, if any

Line 844: okl_ien_pvt_w.rosetta_table_copy_in_p8(ddp_ienv_tbl, p5_a0

840:
841:
842:
843:
844: okl_ien_pvt_w.rosetta_table_copy_in_p8(ddp_ienv_tbl, p5_a0
845: , p5_a1
846: , p5_a2
847: , p5_a3
848: , p5_a4

Line 878: okl_ien_pvt.insert_row(p_api_version,

874: );
875:
876:
877: -- here's the delegated call to the old PL/SQL routine
878: okl_ien_pvt.insert_row(p_api_version,
879: p_init_msg_list,
880: x_return_status,
881: x_msg_count,
882: x_msg_data,

Line 893: okl_ien_pvt_w.rosetta_table_copy_out_p8(ddx_ienv_tbl, p6_a0

889:
890:
891:
892:
893: okl_ien_pvt_w.rosetta_table_copy_out_p8(ddx_ienv_tbl, p6_a0
894: , p6_a1
895: , p6_a2
896: , p6_a3
897: , p6_a4

Line 964: ddp_ienv_rec okl_ien_pvt.ienv_rec_type;

960: , p5_a29 NUMBER := 0-1962.0724
961: )
962:
963: as
964: ddp_ienv_rec okl_ien_pvt.ienv_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 1006: okl_ien_pvt.lock_row(p_api_version,

1002: ddp_ienv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a28);
1003: ddp_ienv_rec.last_update_login := rosetta_g_miss_num_map(p5_a29);
1004:
1005: -- here's the delegated call to the old PL/SQL routine
1006: okl_ien_pvt.lock_row(p_api_version,
1007: p_init_msg_list,
1008: x_return_status,
1009: x_msg_count,
1010: x_msg_data,

Line 1059: ddp_ienv_tbl okl_ien_pvt.ienv_tbl_type;

1055: , p5_a29 JTF_NUMBER_TABLE
1056: )
1057:
1058: as
1059: ddp_ienv_tbl okl_ien_pvt.ienv_tbl_type;
1060: ddindx binary_integer; indx binary_integer;
1061: begin
1062:
1063: -- copy data to the local IN or IN-OUT args, if any

Line 1069: okl_ien_pvt_w.rosetta_table_copy_in_p8(ddp_ienv_tbl, p5_a0

1065:
1066:
1067:
1068:
1069: okl_ien_pvt_w.rosetta_table_copy_in_p8(ddp_ienv_tbl, p5_a0
1070: , p5_a1
1071: , p5_a2
1072: , p5_a3
1073: , p5_a4

Line 1102: okl_ien_pvt.lock_row(p_api_version,

1098: , p5_a29
1099: );
1100:
1101: -- here's the delegated call to the old PL/SQL routine
1102: okl_ien_pvt.lock_row(p_api_version,
1103: p_init_msg_list,
1104: x_return_status,
1105: x_msg_count,
1106: x_msg_data,

Line 1185: ddp_ienv_rec okl_ien_pvt.ienv_rec_type;

1181: , p5_a29 NUMBER := 0-1962.0724
1182: )
1183:
1184: as
1185: ddp_ienv_rec okl_ien_pvt.ienv_rec_type;
1186: ddx_ienv_rec okl_ien_pvt.ienv_rec_type;
1187: ddindx binary_integer; indx binary_integer;
1188: begin
1189:

Line 1186: ddx_ienv_rec okl_ien_pvt.ienv_rec_type;

1182: )
1183:
1184: as
1185: ddp_ienv_rec okl_ien_pvt.ienv_rec_type;
1186: ddx_ienv_rec okl_ien_pvt.ienv_rec_type;
1187: ddindx binary_integer; indx binary_integer;
1188: begin
1189:
1190: -- copy data to the local IN or IN-OUT args, if any

Line 1229: okl_ien_pvt.update_row(p_api_version,

1225: ddp_ienv_rec.last_update_login := rosetta_g_miss_num_map(p5_a29);
1226:
1227:
1228: -- here's the delegated call to the old PL/SQL routine
1229: okl_ien_pvt.update_row(p_api_version,
1230: p_init_msg_list,
1231: x_return_status,
1232: x_msg_count,
1233: x_msg_data,

Line 1344: ddp_ienv_tbl okl_ien_pvt.ienv_tbl_type;

1340: , p6_a29 out nocopy JTF_NUMBER_TABLE
1341: )
1342:
1343: as
1344: ddp_ienv_tbl okl_ien_pvt.ienv_tbl_type;
1345: ddx_ienv_tbl okl_ien_pvt.ienv_tbl_type;
1346: ddindx binary_integer; indx binary_integer;
1347: begin
1348:

Line 1345: ddx_ienv_tbl okl_ien_pvt.ienv_tbl_type;

1341: )
1342:
1343: as
1344: ddp_ienv_tbl okl_ien_pvt.ienv_tbl_type;
1345: ddx_ienv_tbl okl_ien_pvt.ienv_tbl_type;
1346: ddindx binary_integer; indx binary_integer;
1347: begin
1348:
1349: -- copy data to the local IN or IN-OUT args, if any

Line 1355: okl_ien_pvt_w.rosetta_table_copy_in_p8(ddp_ienv_tbl, p5_a0

1351:
1352:
1353:
1354:
1355: okl_ien_pvt_w.rosetta_table_copy_in_p8(ddp_ienv_tbl, p5_a0
1356: , p5_a1
1357: , p5_a2
1358: , p5_a3
1359: , p5_a4

Line 1389: okl_ien_pvt.update_row(p_api_version,

1385: );
1386:
1387:
1388: -- here's the delegated call to the old PL/SQL routine
1389: okl_ien_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_ien_pvt_w.rosetta_table_copy_out_p8(ddx_ienv_tbl, p6_a0

1400:
1401:
1402:
1403:
1404: okl_ien_pvt_w.rosetta_table_copy_out_p8(ddx_ienv_tbl, p6_a0
1405: , p6_a1
1406: , p6_a2
1407: , p6_a3
1408: , p6_a4

Line 1475: ddp_ienv_rec okl_ien_pvt.ienv_rec_type;

1471: , p5_a29 NUMBER := 0-1962.0724
1472: )
1473:
1474: as
1475: ddp_ienv_rec okl_ien_pvt.ienv_rec_type;
1476: ddindx binary_integer; indx binary_integer;
1477: begin
1478:
1479: -- copy data to the local IN or IN-OUT args, if any

Line 1517: okl_ien_pvt.delete_row(p_api_version,

1513: ddp_ienv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a28);
1514: ddp_ienv_rec.last_update_login := rosetta_g_miss_num_map(p5_a29);
1515:
1516: -- here's the delegated call to the old PL/SQL routine
1517: okl_ien_pvt.delete_row(p_api_version,
1518: p_init_msg_list,
1519: x_return_status,
1520: x_msg_count,
1521: x_msg_data,

Line 1570: ddp_ienv_tbl okl_ien_pvt.ienv_tbl_type;

1566: , p5_a29 JTF_NUMBER_TABLE
1567: )
1568:
1569: as
1570: ddp_ienv_tbl okl_ien_pvt.ienv_tbl_type;
1571: ddindx binary_integer; indx binary_integer;
1572: begin
1573:
1574: -- copy data to the local IN or IN-OUT args, if any

Line 1580: okl_ien_pvt_w.rosetta_table_copy_in_p8(ddp_ienv_tbl, p5_a0

1576:
1577:
1578:
1579:
1580: okl_ien_pvt_w.rosetta_table_copy_in_p8(ddp_ienv_tbl, p5_a0
1581: , p5_a1
1582: , p5_a2
1583: , p5_a3
1584: , p5_a4

Line 1613: okl_ien_pvt.delete_row(p_api_version,

1609: , p5_a29
1610: );
1611:
1612: -- here's the delegated call to the old PL/SQL routine
1613: okl_ien_pvt.delete_row(p_api_version,
1614: p_init_msg_list,
1615: x_return_status,
1616: x_msg_count,
1617: x_msg_data,

Line 1666: ddp_ienv_rec okl_ien_pvt.ienv_rec_type;

1662: , p5_a29 NUMBER := 0-1962.0724
1663: )
1664:
1665: as
1666: ddp_ienv_rec okl_ien_pvt.ienv_rec_type;
1667: ddindx binary_integer; indx binary_integer;
1668: begin
1669:
1670: -- copy data to the local IN or IN-OUT args, if any

Line 1708: okl_ien_pvt.validate_row(p_api_version,

1704: ddp_ienv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a28);
1705: ddp_ienv_rec.last_update_login := rosetta_g_miss_num_map(p5_a29);
1706:
1707: -- here's the delegated call to the old PL/SQL routine
1708: okl_ien_pvt.validate_row(p_api_version,
1709: p_init_msg_list,
1710: x_return_status,
1711: x_msg_count,
1712: x_msg_data,

Line 1761: ddp_ienv_tbl okl_ien_pvt.ienv_tbl_type;

1757: , p5_a29 JTF_NUMBER_TABLE
1758: )
1759:
1760: as
1761: ddp_ienv_tbl okl_ien_pvt.ienv_tbl_type;
1762: ddindx binary_integer; indx binary_integer;
1763: begin
1764:
1765: -- copy data to the local IN or IN-OUT args, if any

Line 1771: okl_ien_pvt_w.rosetta_table_copy_in_p8(ddp_ienv_tbl, p5_a0

1767:
1768:
1769:
1770:
1771: okl_ien_pvt_w.rosetta_table_copy_in_p8(ddp_ienv_tbl, p5_a0
1772: , p5_a1
1773: , p5_a2
1774: , p5_a3
1775: , p5_a4

Line 1804: okl_ien_pvt.validate_row(p_api_version,

1800: , p5_a29
1801: );
1802:
1803: -- here's the delegated call to the old PL/SQL routine
1804: okl_ien_pvt.validate_row(p_api_version,
1805: p_init_msg_list,
1806: x_return_status,
1807: x_msg_count,
1808: x_msg_data,

Line 1819: end okl_ien_pvt_w;

1815:
1816:
1817: end;
1818:
1819: end okl_ien_pvt_w;