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_IMS_PVT_W dependencies on OKL_IMS_PVT

Line 1: package body okl_ims_pvt_w as

1: package body okl_ims_pvt_w as
2: /* $Header: OKLEIMSB.pls 120.2 2005/07/14 11:57:14 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_ims_pvt.ims_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_ims_pvt.ims_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_DATE_TABLE

Line 97: procedure rosetta_table_copy_out_p2(t okl_ims_pvt.ims_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

93: end loop;
94: end if;
95: end if;
96: end rosetta_table_copy_in_p2;
97: procedure rosetta_table_copy_out_p2(t okl_ims_pvt.ims_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
98: , a1 out nocopy JTF_NUMBER_TABLE
99: , a2 out nocopy JTF_NUMBER_TABLE
100: , a3 out nocopy JTF_NUMBER_TABLE
101: , a4 out nocopy JTF_DATE_TABLE

Line 261: procedure rosetta_table_copy_in_p5(t out nocopy okl_ims_pvt.okl_invoice_mssgs_tl_tbl_type, a0 JTF_NUMBER_TABLE

257: end if;
258: end if;
259: end rosetta_table_copy_out_p2;
260:
261: procedure rosetta_table_copy_in_p5(t out nocopy okl_ims_pvt.okl_invoice_mssgs_tl_tbl_type, a0 JTF_NUMBER_TABLE
262: , a1 JTF_VARCHAR2_TABLE_100
263: , a2 JTF_VARCHAR2_TABLE_100
264: , a3 JTF_VARCHAR2_TABLE_100
265: , a4 JTF_VARCHAR2_TABLE_200

Line 302: procedure rosetta_table_copy_out_p5(t okl_ims_pvt.okl_invoice_mssgs_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

298: end loop;
299: end if;
300: end if;
301: end rosetta_table_copy_in_p5;
302: procedure rosetta_table_copy_out_p5(t okl_ims_pvt.okl_invoice_mssgs_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
303: , a1 out nocopy JTF_VARCHAR2_TABLE_100
304: , a2 out nocopy JTF_VARCHAR2_TABLE_100
305: , a3 out nocopy JTF_VARCHAR2_TABLE_100
306: , a4 out nocopy JTF_VARCHAR2_TABLE_200

Line 381: procedure rosetta_table_copy_in_p8(t out nocopy okl_ims_pvt.imsv_tbl_type, a0 JTF_NUMBER_TABLE

377: end if;
378: end if;
379: end rosetta_table_copy_out_p5;
380:
381: procedure rosetta_table_copy_in_p8(t out nocopy okl_ims_pvt.imsv_tbl_type, a0 JTF_NUMBER_TABLE
382: , a1 JTF_NUMBER_TABLE
383: , a2 JTF_NUMBER_TABLE
384: , a3 JTF_VARCHAR2_TABLE_100
385: , a4 JTF_VARCHAR2_TABLE_200

Line 464: procedure rosetta_table_copy_out_p8(t okl_ims_pvt.imsv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

460: end loop;
461: end if;
462: end if;
463: end rosetta_table_copy_in_p8;
464: procedure rosetta_table_copy_out_p8(t okl_ims_pvt.imsv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
465: , a1 out nocopy JTF_NUMBER_TABLE
466: , a2 out nocopy JTF_NUMBER_TABLE
467: , a3 out nocopy JTF_VARCHAR2_TABLE_100
468: , a4 out nocopy JTF_VARCHAR2_TABLE_200

Line 722: ddp_imsv_rec okl_ims_pvt.imsv_rec_type;

718: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
719: )
720:
721: as
722: ddp_imsv_rec okl_ims_pvt.imsv_rec_type;
723: ddx_imsv_rec okl_ims_pvt.imsv_rec_type;
724: ddindx binary_integer; indx binary_integer;
725: begin
726:

Line 723: ddx_imsv_rec okl_ims_pvt.imsv_rec_type;

719: )
720:
721: as
722: ddp_imsv_rec okl_ims_pvt.imsv_rec_type;
723: ddx_imsv_rec okl_ims_pvt.imsv_rec_type;
724: ddindx binary_integer; indx binary_integer;
725: begin
726:
727: -- copy data to the local IN or IN-OUT args, if any

Line 769: okl_ims_pvt.insert_row(p_api_version,

765: ddp_imsv_rec.proc_name := p5_a32;
766:
767:
768: -- here's the delegated call to the old PL/SQL routine
769: okl_ims_pvt.insert_row(p_api_version,
770: p_init_msg_list,
771: x_return_status,
772: x_msg_count,
773: x_msg_data,

Line 893: ddp_imsv_tbl okl_ims_pvt.imsv_tbl_type;

889: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_300
890: )
891:
892: as
893: ddp_imsv_tbl okl_ims_pvt.imsv_tbl_type;
894: ddx_imsv_tbl okl_ims_pvt.imsv_tbl_type;
895: ddindx binary_integer; indx binary_integer;
896: begin
897:

Line 894: ddx_imsv_tbl okl_ims_pvt.imsv_tbl_type;

890: )
891:
892: as
893: ddp_imsv_tbl okl_ims_pvt.imsv_tbl_type;
894: ddx_imsv_tbl okl_ims_pvt.imsv_tbl_type;
895: ddindx binary_integer; indx binary_integer;
896: begin
897:
898: -- copy data to the local IN or IN-OUT args, if any

Line 904: okl_ims_pvt_w.rosetta_table_copy_in_p8(ddp_imsv_tbl, p5_a0

900:
901:
902:
903:
904: okl_ims_pvt_w.rosetta_table_copy_in_p8(ddp_imsv_tbl, p5_a0
905: , p5_a1
906: , p5_a2
907: , p5_a3
908: , p5_a4

Line 941: okl_ims_pvt.insert_row(p_api_version,

937: );
938:
939:
940: -- here's the delegated call to the old PL/SQL routine
941: okl_ims_pvt.insert_row(p_api_version,
942: p_init_msg_list,
943: x_return_status,
944: x_msg_count,
945: x_msg_data,

Line 956: okl_ims_pvt_w.rosetta_table_copy_out_p8(ddx_imsv_tbl, p6_a0

952:
953:
954:
955:
956: okl_ims_pvt_w.rosetta_table_copy_out_p8(ddx_imsv_tbl, p6_a0
957: , p6_a1
958: , p6_a2
959: , p6_a3
960: , p6_a4

Line 1033: ddp_imsv_rec okl_ims_pvt.imsv_rec_type;

1029: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1030: )
1031:
1032: as
1033: ddp_imsv_rec okl_ims_pvt.imsv_rec_type;
1034: ddindx binary_integer; indx binary_integer;
1035: begin
1036:
1037: -- copy data to the local IN or IN-OUT args, if any

Line 1078: okl_ims_pvt.lock_row(p_api_version,

1074: ddp_imsv_rec.pkg_name := p5_a31;
1075: ddp_imsv_rec.proc_name := p5_a32;
1076:
1077: -- here's the delegated call to the old PL/SQL routine
1078: okl_ims_pvt.lock_row(p_api_version,
1079: p_init_msg_list,
1080: x_return_status,
1081: x_msg_count,
1082: x_msg_data,

Line 1134: ddp_imsv_tbl okl_ims_pvt.imsv_tbl_type;

1130: , p5_a32 JTF_VARCHAR2_TABLE_300
1131: )
1132:
1133: as
1134: ddp_imsv_tbl okl_ims_pvt.imsv_tbl_type;
1135: ddindx binary_integer; indx binary_integer;
1136: begin
1137:
1138: -- copy data to the local IN or IN-OUT args, if any

Line 1144: okl_ims_pvt_w.rosetta_table_copy_in_p8(ddp_imsv_tbl, p5_a0

1140:
1141:
1142:
1143:
1144: okl_ims_pvt_w.rosetta_table_copy_in_p8(ddp_imsv_tbl, p5_a0
1145: , p5_a1
1146: , p5_a2
1147: , p5_a3
1148: , p5_a4

Line 1180: okl_ims_pvt.lock_row(p_api_version,

1176: , p5_a32
1177: );
1178:
1179: -- here's the delegated call to the old PL/SQL routine
1180: okl_ims_pvt.lock_row(p_api_version,
1181: p_init_msg_list,
1182: x_return_status,
1183: x_msg_count,
1184: x_msg_data,

Line 1269: ddp_imsv_rec okl_ims_pvt.imsv_rec_type;

1265: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1266: )
1267:
1268: as
1269: ddp_imsv_rec okl_ims_pvt.imsv_rec_type;
1270: ddx_imsv_rec okl_ims_pvt.imsv_rec_type;
1271: ddindx binary_integer; indx binary_integer;
1272: begin
1273:

Line 1270: ddx_imsv_rec okl_ims_pvt.imsv_rec_type;

1266: )
1267:
1268: as
1269: ddp_imsv_rec okl_ims_pvt.imsv_rec_type;
1270: ddx_imsv_rec okl_ims_pvt.imsv_rec_type;
1271: ddindx binary_integer; indx binary_integer;
1272: begin
1273:
1274: -- copy data to the local IN or IN-OUT args, if any

Line 1316: okl_ims_pvt.update_row(p_api_version,

1312: ddp_imsv_rec.proc_name := p5_a32;
1313:
1314:
1315: -- here's the delegated call to the old PL/SQL routine
1316: okl_ims_pvt.update_row(p_api_version,
1317: p_init_msg_list,
1318: x_return_status,
1319: x_msg_count,
1320: x_msg_data,

Line 1440: ddp_imsv_tbl okl_ims_pvt.imsv_tbl_type;

1436: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_300
1437: )
1438:
1439: as
1440: ddp_imsv_tbl okl_ims_pvt.imsv_tbl_type;
1441: ddx_imsv_tbl okl_ims_pvt.imsv_tbl_type;
1442: ddindx binary_integer; indx binary_integer;
1443: begin
1444:

Line 1441: ddx_imsv_tbl okl_ims_pvt.imsv_tbl_type;

1437: )
1438:
1439: as
1440: ddp_imsv_tbl okl_ims_pvt.imsv_tbl_type;
1441: ddx_imsv_tbl okl_ims_pvt.imsv_tbl_type;
1442: ddindx binary_integer; indx binary_integer;
1443: begin
1444:
1445: -- copy data to the local IN or IN-OUT args, if any

Line 1451: okl_ims_pvt_w.rosetta_table_copy_in_p8(ddp_imsv_tbl, p5_a0

1447:
1448:
1449:
1450:
1451: okl_ims_pvt_w.rosetta_table_copy_in_p8(ddp_imsv_tbl, p5_a0
1452: , p5_a1
1453: , p5_a2
1454: , p5_a3
1455: , p5_a4

Line 1488: okl_ims_pvt.update_row(p_api_version,

1484: );
1485:
1486:
1487: -- here's the delegated call to the old PL/SQL routine
1488: okl_ims_pvt.update_row(p_api_version,
1489: p_init_msg_list,
1490: x_return_status,
1491: x_msg_count,
1492: x_msg_data,

Line 1503: okl_ims_pvt_w.rosetta_table_copy_out_p8(ddx_imsv_tbl, p6_a0

1499:
1500:
1501:
1502:
1503: okl_ims_pvt_w.rosetta_table_copy_out_p8(ddx_imsv_tbl, p6_a0
1504: , p6_a1
1505: , p6_a2
1506: , p6_a3
1507: , p6_a4

Line 1580: ddp_imsv_rec okl_ims_pvt.imsv_rec_type;

1576: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1577: )
1578:
1579: as
1580: ddp_imsv_rec okl_ims_pvt.imsv_rec_type;
1581: ddindx binary_integer; indx binary_integer;
1582: begin
1583:
1584: -- copy data to the local IN or IN-OUT args, if any

Line 1625: okl_ims_pvt.delete_row(p_api_version,

1621: ddp_imsv_rec.pkg_name := p5_a31;
1622: ddp_imsv_rec.proc_name := p5_a32;
1623:
1624: -- here's the delegated call to the old PL/SQL routine
1625: okl_ims_pvt.delete_row(p_api_version,
1626: p_init_msg_list,
1627: x_return_status,
1628: x_msg_count,
1629: x_msg_data,

Line 1681: ddp_imsv_tbl okl_ims_pvt.imsv_tbl_type;

1677: , p5_a32 JTF_VARCHAR2_TABLE_300
1678: )
1679:
1680: as
1681: ddp_imsv_tbl okl_ims_pvt.imsv_tbl_type;
1682: ddindx binary_integer; indx binary_integer;
1683: begin
1684:
1685: -- copy data to the local IN or IN-OUT args, if any

Line 1691: okl_ims_pvt_w.rosetta_table_copy_in_p8(ddp_imsv_tbl, p5_a0

1687:
1688:
1689:
1690:
1691: okl_ims_pvt_w.rosetta_table_copy_in_p8(ddp_imsv_tbl, p5_a0
1692: , p5_a1
1693: , p5_a2
1694: , p5_a3
1695: , p5_a4

Line 1727: okl_ims_pvt.delete_row(p_api_version,

1723: , p5_a32
1724: );
1725:
1726: -- here's the delegated call to the old PL/SQL routine
1727: okl_ims_pvt.delete_row(p_api_version,
1728: p_init_msg_list,
1729: x_return_status,
1730: x_msg_count,
1731: x_msg_data,

Line 1783: ddp_imsv_rec okl_ims_pvt.imsv_rec_type;

1779: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1780: )
1781:
1782: as
1783: ddp_imsv_rec okl_ims_pvt.imsv_rec_type;
1784: ddindx binary_integer; indx binary_integer;
1785: begin
1786:
1787: -- copy data to the local IN or IN-OUT args, if any

Line 1828: okl_ims_pvt.validate_row(p_api_version,

1824: ddp_imsv_rec.pkg_name := p5_a31;
1825: ddp_imsv_rec.proc_name := p5_a32;
1826:
1827: -- here's the delegated call to the old PL/SQL routine
1828: okl_ims_pvt.validate_row(p_api_version,
1829: p_init_msg_list,
1830: x_return_status,
1831: x_msg_count,
1832: x_msg_data,

Line 1884: ddp_imsv_tbl okl_ims_pvt.imsv_tbl_type;

1880: , p5_a32 JTF_VARCHAR2_TABLE_300
1881: )
1882:
1883: as
1884: ddp_imsv_tbl okl_ims_pvt.imsv_tbl_type;
1885: ddindx binary_integer; indx binary_integer;
1886: begin
1887:
1888: -- copy data to the local IN or IN-OUT args, if any

Line 1894: okl_ims_pvt_w.rosetta_table_copy_in_p8(ddp_imsv_tbl, p5_a0

1890:
1891:
1892:
1893:
1894: okl_ims_pvt_w.rosetta_table_copy_in_p8(ddp_imsv_tbl, p5_a0
1895: , p5_a1
1896: , p5_a2
1897: , p5_a3
1898: , p5_a4

Line 1930: okl_ims_pvt.validate_row(p_api_version,

1926: , p5_a32
1927: );
1928:
1929: -- here's the delegated call to the old PL/SQL routine
1930: okl_ims_pvt.validate_row(p_api_version,
1931: p_init_msg_list,
1932: x_return_status,
1933: x_msg_count,
1934: x_msg_data,

Line 1945: end okl_ims_pvt_w;

1941:
1942:
1943: end;
1944:
1945: end okl_ims_pvt_w;