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_SIB_PVT_W dependencies on OKL_SIB_PVT

Line 1: package body okl_sib_pvt_w as

1: package body okl_sib_pvt_w as
2: /* $Header: OKLISIBB.pls 120.1 2005/10/30 04:00:56 appldev 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_sib_pvt.sibv_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_sib_pvt.sibv_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_VARCHAR2_TABLE_200
26: , a4 JTF_VARCHAR2_TABLE_100

Line 101: procedure rosetta_table_copy_out_p2(t okl_sib_pvt.sibv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

97: end loop;
98: end if;
99: end if;
100: end rosetta_table_copy_in_p2;
101: procedure rosetta_table_copy_out_p2(t okl_sib_pvt.sibv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
102: , a1 out nocopy JTF_NUMBER_TABLE
103: , a2 out nocopy JTF_VARCHAR2_TABLE_100
104: , a3 out nocopy JTF_VARCHAR2_TABLE_200
105: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 275: procedure rosetta_table_copy_in_p5(t out nocopy okl_sib_pvt.sib_tbl_type, a0 JTF_NUMBER_TABLE

271: end if;
272: end if;
273: end rosetta_table_copy_out_p2;
274:
275: procedure rosetta_table_copy_in_p5(t out nocopy okl_sib_pvt.sib_tbl_type, a0 JTF_NUMBER_TABLE
276: , a1 JTF_NUMBER_TABLE
277: , a2 JTF_VARCHAR2_TABLE_100
278: , a3 JTF_DATE_TABLE
279: , a4 JTF_VARCHAR2_TABLE_100

Line 352: procedure rosetta_table_copy_out_p5(t okl_sib_pvt.sib_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

348: end loop;
349: end if;
350: end if;
351: end rosetta_table_copy_in_p5;
352: procedure rosetta_table_copy_out_p5(t okl_sib_pvt.sib_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
353: , a1 out nocopy JTF_NUMBER_TABLE
354: , a2 out nocopy JTF_VARCHAR2_TABLE_100
355: , a3 out nocopy JTF_DATE_TABLE
356: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 521: procedure rosetta_table_copy_in_p8(t out nocopy okl_sib_pvt.oklsubsidypoolbudgetstltbltype, a0 JTF_NUMBER_TABLE

517: end if;
518: end if;
519: end rosetta_table_copy_out_p5;
520:
521: procedure rosetta_table_copy_in_p8(t out nocopy okl_sib_pvt.oklsubsidypoolbudgetstltbltype, a0 JTF_NUMBER_TABLE
522: , a1 JTF_VARCHAR2_TABLE_200
523: , a2 JTF_VARCHAR2_TABLE_100
524: , a3 JTF_VARCHAR2_TABLE_100
525: , a4 JTF_VARCHAR2_TABLE_100

Line 558: procedure rosetta_table_copy_out_p8(t okl_sib_pvt.oklsubsidypoolbudgetstltbltype, a0 out nocopy JTF_NUMBER_TABLE

554: end loop;
555: end if;
556: end if;
557: end rosetta_table_copy_in_p8;
558: procedure rosetta_table_copy_out_p8(t okl_sib_pvt.oklsubsidypoolbudgetstltbltype, a0 out nocopy JTF_NUMBER_TABLE
559: , a1 out nocopy JTF_VARCHAR2_TABLE_200
560: , a2 out nocopy JTF_VARCHAR2_TABLE_100
561: , a3 out nocopy JTF_VARCHAR2_TABLE_100
562: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 697: ddp_sibv_rec okl_sib_pvt.sibv_rec_type;

693: , p5_a30 NUMBER := 0-1962.0724
694: )
695:
696: as
697: ddp_sibv_rec okl_sib_pvt.sibv_rec_type;
698: ddx_sibv_rec okl_sib_pvt.sibv_rec_type;
699: ddindx binary_integer; indx binary_integer;
700: begin
701:

Line 698: ddx_sibv_rec okl_sib_pvt.sibv_rec_type;

694: )
695:
696: as
697: ddp_sibv_rec okl_sib_pvt.sibv_rec_type;
698: ddx_sibv_rec okl_sib_pvt.sibv_rec_type;
699: ddindx binary_integer; indx binary_integer;
700: begin
701:
702: -- copy data to the local IN or IN-OUT args, if any

Line 742: okl_sib_pvt.insert_row(p_api_version,

738: ddp_sibv_rec.last_update_login := rosetta_g_miss_num_map(p5_a30);
739:
740:
741: -- here's the delegated call to the old PL/SQL routine
742: okl_sib_pvt.insert_row(p_api_version,
743: p_init_msg_list,
744: x_return_status,
745: x_msg_count,
746: x_msg_data,

Line 860: ddp_sibv_tbl okl_sib_pvt.sibv_tbl_type;

856: , p6_a30 out nocopy JTF_NUMBER_TABLE
857: )
858:
859: as
860: ddp_sibv_tbl okl_sib_pvt.sibv_tbl_type;
861: ddx_sibv_tbl okl_sib_pvt.sibv_tbl_type;
862: ddindx binary_integer; indx binary_integer;
863: begin
864:

Line 861: ddx_sibv_tbl okl_sib_pvt.sibv_tbl_type;

857: )
858:
859: as
860: ddp_sibv_tbl okl_sib_pvt.sibv_tbl_type;
861: ddx_sibv_tbl okl_sib_pvt.sibv_tbl_type;
862: ddindx binary_integer; indx binary_integer;
863: begin
864:
865: -- copy data to the local IN or IN-OUT args, if any

Line 871: okl_sib_pvt_w.rosetta_table_copy_in_p2(ddp_sibv_tbl, p5_a0

867:
868:
869:
870:
871: okl_sib_pvt_w.rosetta_table_copy_in_p2(ddp_sibv_tbl, p5_a0
872: , p5_a1
873: , p5_a2
874: , p5_a3
875: , p5_a4

Line 906: okl_sib_pvt.insert_row(p_api_version,

902: );
903:
904:
905: -- here's the delegated call to the old PL/SQL routine
906: okl_sib_pvt.insert_row(p_api_version,
907: p_init_msg_list,
908: x_return_status,
909: x_msg_count,
910: x_msg_data,

Line 921: okl_sib_pvt_w.rosetta_table_copy_out_p2(ddx_sibv_tbl, p6_a0

917:
918:
919:
920:
921: okl_sib_pvt_w.rosetta_table_copy_out_p2(ddx_sibv_tbl, p6_a0
922: , p6_a1
923: , p6_a2
924: , p6_a3
925: , p6_a4

Line 994: ddp_sibv_rec okl_sib_pvt.sibv_rec_type;

990: , p5_a30 NUMBER := 0-1962.0724
991: )
992:
993: as
994: ddp_sibv_rec okl_sib_pvt.sibv_rec_type;
995: ddindx binary_integer; indx binary_integer;
996: begin
997:
998: -- copy data to the local IN or IN-OUT args, if any

Line 1037: okl_sib_pvt.lock_row(p_api_version,

1033: ddp_sibv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a29);
1034: ddp_sibv_rec.last_update_login := rosetta_g_miss_num_map(p5_a30);
1035:
1036: -- here's the delegated call to the old PL/SQL routine
1037: okl_sib_pvt.lock_row(p_api_version,
1038: p_init_msg_list,
1039: x_return_status,
1040: x_msg_count,
1041: x_msg_data,

Line 1091: ddp_sibv_tbl okl_sib_pvt.sibv_tbl_type;

1087: , p5_a30 JTF_NUMBER_TABLE
1088: )
1089:
1090: as
1091: ddp_sibv_tbl okl_sib_pvt.sibv_tbl_type;
1092: ddindx binary_integer; indx binary_integer;
1093: begin
1094:
1095: -- copy data to the local IN or IN-OUT args, if any

Line 1101: okl_sib_pvt_w.rosetta_table_copy_in_p2(ddp_sibv_tbl, p5_a0

1097:
1098:
1099:
1100:
1101: okl_sib_pvt_w.rosetta_table_copy_in_p2(ddp_sibv_tbl, p5_a0
1102: , p5_a1
1103: , p5_a2
1104: , p5_a3
1105: , p5_a4

Line 1135: okl_sib_pvt.lock_row(p_api_version,

1131: , p5_a30
1132: );
1133:
1134: -- here's the delegated call to the old PL/SQL routine
1135: okl_sib_pvt.lock_row(p_api_version,
1136: p_init_msg_list,
1137: x_return_status,
1138: x_msg_count,
1139: x_msg_data,

Line 1220: ddp_sibv_rec okl_sib_pvt.sibv_rec_type;

1216: , p5_a30 NUMBER := 0-1962.0724
1217: )
1218:
1219: as
1220: ddp_sibv_rec okl_sib_pvt.sibv_rec_type;
1221: ddx_sibv_rec okl_sib_pvt.sibv_rec_type;
1222: ddindx binary_integer; indx binary_integer;
1223: begin
1224:

Line 1221: ddx_sibv_rec okl_sib_pvt.sibv_rec_type;

1217: )
1218:
1219: as
1220: ddp_sibv_rec okl_sib_pvt.sibv_rec_type;
1221: ddx_sibv_rec okl_sib_pvt.sibv_rec_type;
1222: ddindx binary_integer; indx binary_integer;
1223: begin
1224:
1225: -- copy data to the local IN or IN-OUT args, if any

Line 1265: okl_sib_pvt.update_row(p_api_version,

1261: ddp_sibv_rec.last_update_login := rosetta_g_miss_num_map(p5_a30);
1262:
1263:
1264: -- here's the delegated call to the old PL/SQL routine
1265: okl_sib_pvt.update_row(p_api_version,
1266: p_init_msg_list,
1267: x_return_status,
1268: x_msg_count,
1269: x_msg_data,

Line 1383: ddp_sibv_tbl okl_sib_pvt.sibv_tbl_type;

1379: , p6_a30 out nocopy JTF_NUMBER_TABLE
1380: )
1381:
1382: as
1383: ddp_sibv_tbl okl_sib_pvt.sibv_tbl_type;
1384: ddx_sibv_tbl okl_sib_pvt.sibv_tbl_type;
1385: ddindx binary_integer; indx binary_integer;
1386: begin
1387:

Line 1384: ddx_sibv_tbl okl_sib_pvt.sibv_tbl_type;

1380: )
1381:
1382: as
1383: ddp_sibv_tbl okl_sib_pvt.sibv_tbl_type;
1384: ddx_sibv_tbl okl_sib_pvt.sibv_tbl_type;
1385: ddindx binary_integer; indx binary_integer;
1386: begin
1387:
1388: -- copy data to the local IN or IN-OUT args, if any

Line 1394: okl_sib_pvt_w.rosetta_table_copy_in_p2(ddp_sibv_tbl, p5_a0

1390:
1391:
1392:
1393:
1394: okl_sib_pvt_w.rosetta_table_copy_in_p2(ddp_sibv_tbl, p5_a0
1395: , p5_a1
1396: , p5_a2
1397: , p5_a3
1398: , p5_a4

Line 1429: okl_sib_pvt.update_row(p_api_version,

1425: );
1426:
1427:
1428: -- here's the delegated call to the old PL/SQL routine
1429: okl_sib_pvt.update_row(p_api_version,
1430: p_init_msg_list,
1431: x_return_status,
1432: x_msg_count,
1433: x_msg_data,

Line 1444: okl_sib_pvt_w.rosetta_table_copy_out_p2(ddx_sibv_tbl, p6_a0

1440:
1441:
1442:
1443:
1444: okl_sib_pvt_w.rosetta_table_copy_out_p2(ddx_sibv_tbl, p6_a0
1445: , p6_a1
1446: , p6_a2
1447: , p6_a3
1448: , p6_a4

Line 1517: ddp_sibv_rec okl_sib_pvt.sibv_rec_type;

1513: , p5_a30 NUMBER := 0-1962.0724
1514: )
1515:
1516: as
1517: ddp_sibv_rec okl_sib_pvt.sibv_rec_type;
1518: ddindx binary_integer; indx binary_integer;
1519: begin
1520:
1521: -- copy data to the local IN or IN-OUT args, if any

Line 1560: okl_sib_pvt.delete_row(p_api_version,

1556: ddp_sibv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a29);
1557: ddp_sibv_rec.last_update_login := rosetta_g_miss_num_map(p5_a30);
1558:
1559: -- here's the delegated call to the old PL/SQL routine
1560: okl_sib_pvt.delete_row(p_api_version,
1561: p_init_msg_list,
1562: x_return_status,
1563: x_msg_count,
1564: x_msg_data,

Line 1614: ddp_sibv_tbl okl_sib_pvt.sibv_tbl_type;

1610: , p5_a30 JTF_NUMBER_TABLE
1611: )
1612:
1613: as
1614: ddp_sibv_tbl okl_sib_pvt.sibv_tbl_type;
1615: ddindx binary_integer; indx binary_integer;
1616: begin
1617:
1618: -- copy data to the local IN or IN-OUT args, if any

Line 1624: okl_sib_pvt_w.rosetta_table_copy_in_p2(ddp_sibv_tbl, p5_a0

1620:
1621:
1622:
1623:
1624: okl_sib_pvt_w.rosetta_table_copy_in_p2(ddp_sibv_tbl, p5_a0
1625: , p5_a1
1626: , p5_a2
1627: , p5_a3
1628: , p5_a4

Line 1658: okl_sib_pvt.delete_row(p_api_version,

1654: , p5_a30
1655: );
1656:
1657: -- here's the delegated call to the old PL/SQL routine
1658: okl_sib_pvt.delete_row(p_api_version,
1659: p_init_msg_list,
1660: x_return_status,
1661: x_msg_count,
1662: x_msg_data,

Line 1712: ddp_sibv_rec okl_sib_pvt.sibv_rec_type;

1708: , p5_a30 NUMBER := 0-1962.0724
1709: )
1710:
1711: as
1712: ddp_sibv_rec okl_sib_pvt.sibv_rec_type;
1713: ddindx binary_integer; indx binary_integer;
1714: begin
1715:
1716: -- copy data to the local IN or IN-OUT args, if any

Line 1755: okl_sib_pvt.validate_row(p_api_version,

1751: ddp_sibv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a29);
1752: ddp_sibv_rec.last_update_login := rosetta_g_miss_num_map(p5_a30);
1753:
1754: -- here's the delegated call to the old PL/SQL routine
1755: okl_sib_pvt.validate_row(p_api_version,
1756: p_init_msg_list,
1757: x_return_status,
1758: x_msg_count,
1759: x_msg_data,

Line 1809: ddp_sibv_tbl okl_sib_pvt.sibv_tbl_type;

1805: , p5_a30 JTF_NUMBER_TABLE
1806: )
1807:
1808: as
1809: ddp_sibv_tbl okl_sib_pvt.sibv_tbl_type;
1810: ddindx binary_integer; indx binary_integer;
1811: begin
1812:
1813: -- copy data to the local IN or IN-OUT args, if any

Line 1819: okl_sib_pvt_w.rosetta_table_copy_in_p2(ddp_sibv_tbl, p5_a0

1815:
1816:
1817:
1818:
1819: okl_sib_pvt_w.rosetta_table_copy_in_p2(ddp_sibv_tbl, p5_a0
1820: , p5_a1
1821: , p5_a2
1822: , p5_a3
1823: , p5_a4

Line 1853: okl_sib_pvt.validate_row(p_api_version,

1849: , p5_a30
1850: );
1851:
1852: -- here's the delegated call to the old PL/SQL routine
1853: okl_sib_pvt.validate_row(p_api_version,
1854: p_init_msg_list,
1855: x_return_status,
1856: x_msg_count,
1857: x_msg_data,

Line 1868: end okl_sib_pvt_w;

1864:
1865:
1866: end;
1867:
1868: end okl_sib_pvt_w;