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_ITY_PVT_W dependencies on OKL_ITY_PVT

Line 1: package body okl_ity_pvt_w as

1: package body okl_ity_pvt_w as
2: /* $Header: OKLIITYB.pls 120.1 2005/07/13 09:28:48 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_ity_pvt.ity_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_ity_pvt.ity_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_NUMBER_TABLE

Line 91: procedure rosetta_table_copy_out_p2(t okl_ity_pvt.ity_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

87: end loop;
88: end if;
89: end if;
90: end rosetta_table_copy_in_p2;
91: procedure rosetta_table_copy_out_p2(t okl_ity_pvt.ity_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
92: , a1 out nocopy JTF_NUMBER_TABLE
93: , a2 out nocopy JTF_VARCHAR2_TABLE_100
94: , a3 out nocopy JTF_VARCHAR2_TABLE_100
95: , a4 out nocopy JTF_NUMBER_TABLE

Line 240: procedure rosetta_table_copy_in_p5(t out nocopy okl_ity_pvt.okl_invoice_types_tl_tbl_type, a0 JTF_NUMBER_TABLE

236: end if;
237: end if;
238: end rosetta_table_copy_out_p2;
239:
240: procedure rosetta_table_copy_in_p5(t out nocopy okl_ity_pvt.okl_invoice_types_tl_tbl_type, a0 JTF_NUMBER_TABLE
241: , a1 JTF_VARCHAR2_TABLE_100
242: , a2 JTF_VARCHAR2_TABLE_100
243: , a3 JTF_VARCHAR2_TABLE_100
244: , a4 JTF_VARCHAR2_TABLE_200

Line 279: procedure rosetta_table_copy_out_p5(t okl_ity_pvt.okl_invoice_types_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

275: end loop;
276: end if;
277: end if;
278: end rosetta_table_copy_in_p5;
279: procedure rosetta_table_copy_out_p5(t okl_ity_pvt.okl_invoice_types_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
280: , a1 out nocopy JTF_VARCHAR2_TABLE_100
281: , a2 out nocopy JTF_VARCHAR2_TABLE_100
282: , a3 out nocopy JTF_VARCHAR2_TABLE_100
283: , a4 out nocopy JTF_VARCHAR2_TABLE_200

Line 353: procedure rosetta_table_copy_in_p8(t out nocopy okl_ity_pvt.ityv_tbl_type, a0 JTF_NUMBER_TABLE

349: end if;
350: end if;
351: end rosetta_table_copy_out_p5;
352:
353: procedure rosetta_table_copy_in_p8(t out nocopy okl_ity_pvt.ityv_tbl_type, a0 JTF_NUMBER_TABLE
354: , a1 JTF_NUMBER_TABLE
355: , a2 JTF_VARCHAR2_TABLE_100
356: , a3 JTF_NUMBER_TABLE
357: , a4 JTF_VARCHAR2_TABLE_200

Line 428: procedure rosetta_table_copy_out_p8(t okl_ity_pvt.ityv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

424: end loop;
425: end if;
426: end if;
427: end rosetta_table_copy_in_p8;
428: procedure rosetta_table_copy_out_p8(t okl_ity_pvt.ityv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
429: , a1 out nocopy JTF_NUMBER_TABLE
430: , a2 out nocopy JTF_VARCHAR2_TABLE_100
431: , a3 out nocopy JTF_NUMBER_TABLE
432: , a4 out nocopy JTF_VARCHAR2_TABLE_200

Line 658: ddp_ityv_rec okl_ity_pvt.ityv_rec_type;

654: , p5_a28 NUMBER := 0-1962.0724
655: )
656:
657: as
658: ddp_ityv_rec okl_ity_pvt.ityv_rec_type;
659: ddx_ityv_rec okl_ity_pvt.ityv_rec_type;
660: ddindx binary_integer; indx binary_integer;
661: begin
662:

Line 659: ddx_ityv_rec okl_ity_pvt.ityv_rec_type;

655: )
656:
657: as
658: ddp_ityv_rec okl_ity_pvt.ityv_rec_type;
659: ddx_ityv_rec okl_ity_pvt.ityv_rec_type;
660: ddindx binary_integer; indx binary_integer;
661: begin
662:
663: -- copy data to the local IN or IN-OUT args, if any

Line 701: okl_ity_pvt.insert_row(p_api_version,

697: ddp_ityv_rec.last_update_login := rosetta_g_miss_num_map(p5_a28);
698:
699:
700: -- here's the delegated call to the old PL/SQL routine
701: okl_ity_pvt.insert_row(p_api_version,
702: p_init_msg_list,
703: x_return_status,
704: x_msg_count,
705: x_msg_data,

Line 813: ddp_ityv_tbl okl_ity_pvt.ityv_tbl_type;

809: , p6_a28 out nocopy JTF_NUMBER_TABLE
810: )
811:
812: as
813: ddp_ityv_tbl okl_ity_pvt.ityv_tbl_type;
814: ddx_ityv_tbl okl_ity_pvt.ityv_tbl_type;
815: ddindx binary_integer; indx binary_integer;
816: begin
817:

Line 814: ddx_ityv_tbl okl_ity_pvt.ityv_tbl_type;

810: )
811:
812: as
813: ddp_ityv_tbl okl_ity_pvt.ityv_tbl_type;
814: ddx_ityv_tbl okl_ity_pvt.ityv_tbl_type;
815: ddindx binary_integer; indx binary_integer;
816: begin
817:
818: -- copy data to the local IN or IN-OUT args, if any

Line 824: okl_ity_pvt_w.rosetta_table_copy_in_p8(ddp_ityv_tbl, p5_a0

820:
821:
822:
823:
824: okl_ity_pvt_w.rosetta_table_copy_in_p8(ddp_ityv_tbl, p5_a0
825: , p5_a1
826: , p5_a2
827: , p5_a3
828: , p5_a4

Line 857: okl_ity_pvt.insert_row(p_api_version,

853: );
854:
855:
856: -- here's the delegated call to the old PL/SQL routine
857: okl_ity_pvt.insert_row(p_api_version,
858: p_init_msg_list,
859: x_return_status,
860: x_msg_count,
861: x_msg_data,

Line 872: okl_ity_pvt_w.rosetta_table_copy_out_p8(ddx_ityv_tbl, p6_a0

868:
869:
870:
871:
872: okl_ity_pvt_w.rosetta_table_copy_out_p8(ddx_ityv_tbl, p6_a0
873: , p6_a1
874: , p6_a2
875: , p6_a3
876: , p6_a4

Line 941: ddp_ityv_rec okl_ity_pvt.ityv_rec_type;

937: , p5_a28 NUMBER := 0-1962.0724
938: )
939:
940: as
941: ddp_ityv_rec okl_ity_pvt.ityv_rec_type;
942: ddindx binary_integer; indx binary_integer;
943: begin
944:
945: -- copy data to the local IN or IN-OUT args, if any

Line 982: okl_ity_pvt.lock_row(p_api_version,

978: ddp_ityv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a27);
979: ddp_ityv_rec.last_update_login := rosetta_g_miss_num_map(p5_a28);
980:
981: -- here's the delegated call to the old PL/SQL routine
982: okl_ity_pvt.lock_row(p_api_version,
983: p_init_msg_list,
984: x_return_status,
985: x_msg_count,
986: x_msg_data,

Line 1034: ddp_ityv_tbl okl_ity_pvt.ityv_tbl_type;

1030: , p5_a28 JTF_NUMBER_TABLE
1031: )
1032:
1033: as
1034: ddp_ityv_tbl okl_ity_pvt.ityv_tbl_type;
1035: ddindx binary_integer; indx binary_integer;
1036: begin
1037:
1038: -- copy data to the local IN or IN-OUT args, if any

Line 1044: okl_ity_pvt_w.rosetta_table_copy_in_p8(ddp_ityv_tbl, p5_a0

1040:
1041:
1042:
1043:
1044: okl_ity_pvt_w.rosetta_table_copy_in_p8(ddp_ityv_tbl, p5_a0
1045: , p5_a1
1046: , p5_a2
1047: , p5_a3
1048: , p5_a4

Line 1076: okl_ity_pvt.lock_row(p_api_version,

1072: , p5_a28
1073: );
1074:
1075: -- here's the delegated call to the old PL/SQL routine
1076: okl_ity_pvt.lock_row(p_api_version,
1077: p_init_msg_list,
1078: x_return_status,
1079: x_msg_count,
1080: x_msg_data,

Line 1157: ddp_ityv_rec okl_ity_pvt.ityv_rec_type;

1153: , p5_a28 NUMBER := 0-1962.0724
1154: )
1155:
1156: as
1157: ddp_ityv_rec okl_ity_pvt.ityv_rec_type;
1158: ddx_ityv_rec okl_ity_pvt.ityv_rec_type;
1159: ddindx binary_integer; indx binary_integer;
1160: begin
1161:

Line 1158: ddx_ityv_rec okl_ity_pvt.ityv_rec_type;

1154: )
1155:
1156: as
1157: ddp_ityv_rec okl_ity_pvt.ityv_rec_type;
1158: ddx_ityv_rec okl_ity_pvt.ityv_rec_type;
1159: ddindx binary_integer; indx binary_integer;
1160: begin
1161:
1162: -- copy data to the local IN or IN-OUT args, if any

Line 1200: okl_ity_pvt.update_row(p_api_version,

1196: ddp_ityv_rec.last_update_login := rosetta_g_miss_num_map(p5_a28);
1197:
1198:
1199: -- here's the delegated call to the old PL/SQL routine
1200: okl_ity_pvt.update_row(p_api_version,
1201: p_init_msg_list,
1202: x_return_status,
1203: x_msg_count,
1204: x_msg_data,

Line 1312: ddp_ityv_tbl okl_ity_pvt.ityv_tbl_type;

1308: , p6_a28 out nocopy JTF_NUMBER_TABLE
1309: )
1310:
1311: as
1312: ddp_ityv_tbl okl_ity_pvt.ityv_tbl_type;
1313: ddx_ityv_tbl okl_ity_pvt.ityv_tbl_type;
1314: ddindx binary_integer; indx binary_integer;
1315: begin
1316:

Line 1313: ddx_ityv_tbl okl_ity_pvt.ityv_tbl_type;

1309: )
1310:
1311: as
1312: ddp_ityv_tbl okl_ity_pvt.ityv_tbl_type;
1313: ddx_ityv_tbl okl_ity_pvt.ityv_tbl_type;
1314: ddindx binary_integer; indx binary_integer;
1315: begin
1316:
1317: -- copy data to the local IN or IN-OUT args, if any

Line 1323: okl_ity_pvt_w.rosetta_table_copy_in_p8(ddp_ityv_tbl, p5_a0

1319:
1320:
1321:
1322:
1323: okl_ity_pvt_w.rosetta_table_copy_in_p8(ddp_ityv_tbl, p5_a0
1324: , p5_a1
1325: , p5_a2
1326: , p5_a3
1327: , p5_a4

Line 1356: okl_ity_pvt.update_row(p_api_version,

1352: );
1353:
1354:
1355: -- here's the delegated call to the old PL/SQL routine
1356: okl_ity_pvt.update_row(p_api_version,
1357: p_init_msg_list,
1358: x_return_status,
1359: x_msg_count,
1360: x_msg_data,

Line 1371: okl_ity_pvt_w.rosetta_table_copy_out_p8(ddx_ityv_tbl, p6_a0

1367:
1368:
1369:
1370:
1371: okl_ity_pvt_w.rosetta_table_copy_out_p8(ddx_ityv_tbl, p6_a0
1372: , p6_a1
1373: , p6_a2
1374: , p6_a3
1375: , p6_a4

Line 1440: ddp_ityv_rec okl_ity_pvt.ityv_rec_type;

1436: , p5_a28 NUMBER := 0-1962.0724
1437: )
1438:
1439: as
1440: ddp_ityv_rec okl_ity_pvt.ityv_rec_type;
1441: ddindx binary_integer; indx binary_integer;
1442: begin
1443:
1444: -- copy data to the local IN or IN-OUT args, if any

Line 1481: okl_ity_pvt.delete_row(p_api_version,

1477: ddp_ityv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a27);
1478: ddp_ityv_rec.last_update_login := rosetta_g_miss_num_map(p5_a28);
1479:
1480: -- here's the delegated call to the old PL/SQL routine
1481: okl_ity_pvt.delete_row(p_api_version,
1482: p_init_msg_list,
1483: x_return_status,
1484: x_msg_count,
1485: x_msg_data,

Line 1533: ddp_ityv_tbl okl_ity_pvt.ityv_tbl_type;

1529: , p5_a28 JTF_NUMBER_TABLE
1530: )
1531:
1532: as
1533: ddp_ityv_tbl okl_ity_pvt.ityv_tbl_type;
1534: ddindx binary_integer; indx binary_integer;
1535: begin
1536:
1537: -- copy data to the local IN or IN-OUT args, if any

Line 1543: okl_ity_pvt_w.rosetta_table_copy_in_p8(ddp_ityv_tbl, p5_a0

1539:
1540:
1541:
1542:
1543: okl_ity_pvt_w.rosetta_table_copy_in_p8(ddp_ityv_tbl, p5_a0
1544: , p5_a1
1545: , p5_a2
1546: , p5_a3
1547: , p5_a4

Line 1575: okl_ity_pvt.delete_row(p_api_version,

1571: , p5_a28
1572: );
1573:
1574: -- here's the delegated call to the old PL/SQL routine
1575: okl_ity_pvt.delete_row(p_api_version,
1576: p_init_msg_list,
1577: x_return_status,
1578: x_msg_count,
1579: x_msg_data,

Line 1627: ddp_ityv_rec okl_ity_pvt.ityv_rec_type;

1623: , p5_a28 NUMBER := 0-1962.0724
1624: )
1625:
1626: as
1627: ddp_ityv_rec okl_ity_pvt.ityv_rec_type;
1628: ddindx binary_integer; indx binary_integer;
1629: begin
1630:
1631: -- copy data to the local IN or IN-OUT args, if any

Line 1668: okl_ity_pvt.validate_row(p_api_version,

1664: ddp_ityv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a27);
1665: ddp_ityv_rec.last_update_login := rosetta_g_miss_num_map(p5_a28);
1666:
1667: -- here's the delegated call to the old PL/SQL routine
1668: okl_ity_pvt.validate_row(p_api_version,
1669: p_init_msg_list,
1670: x_return_status,
1671: x_msg_count,
1672: x_msg_data,

Line 1720: ddp_ityv_tbl okl_ity_pvt.ityv_tbl_type;

1716: , p5_a28 JTF_NUMBER_TABLE
1717: )
1718:
1719: as
1720: ddp_ityv_tbl okl_ity_pvt.ityv_tbl_type;
1721: ddindx binary_integer; indx binary_integer;
1722: begin
1723:
1724: -- copy data to the local IN or IN-OUT args, if any

Line 1730: okl_ity_pvt_w.rosetta_table_copy_in_p8(ddp_ityv_tbl, p5_a0

1726:
1727:
1728:
1729:
1730: okl_ity_pvt_w.rosetta_table_copy_in_p8(ddp_ityv_tbl, p5_a0
1731: , p5_a1
1732: , p5_a2
1733: , p5_a3
1734: , p5_a4

Line 1762: okl_ity_pvt.validate_row(p_api_version,

1758: , p5_a28
1759: );
1760:
1761: -- here's the delegated call to the old PL/SQL routine
1762: okl_ity_pvt.validate_row(p_api_version,
1763: p_init_msg_list,
1764: x_return_status,
1765: x_msg_count,
1766: x_msg_data,

Line 1777: end okl_ity_pvt_w;

1773:
1774:
1775: end;
1776:
1777: end okl_ity_pvt_w;