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_DSF_PVT_W dependencies on OKL_DSF_PVT

Line 1: package body okl_dsf_pvt_w as

1: package body okl_dsf_pvt_w as
2: /* $Header: OKLIDSFB.pls 120.1 2005/07/08 10:35:41 dkagrawa 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_dsf_pvt.dsf_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_dsf_pvt.dsf_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_200
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_VARCHAR2_TABLE_800

Line 99: procedure rosetta_table_copy_out_p2(t okl_dsf_pvt.dsf_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

95: end loop;
96: end if;
97: end if;
98: end rosetta_table_copy_in_p2;
99: procedure rosetta_table_copy_out_p2(t okl_dsf_pvt.dsf_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
100: , a1 out nocopy JTF_NUMBER_TABLE
101: , a2 out nocopy JTF_VARCHAR2_TABLE_200
102: , a3 out nocopy JTF_VARCHAR2_TABLE_100
103: , a4 out nocopy JTF_VARCHAR2_TABLE_800

Line 268: procedure rosetta_table_copy_in_p5(t out nocopy okl_dsf_pvt.okldatasrcfnctnstltbltype, a0 JTF_NUMBER_TABLE

264: end if;
265: end if;
266: end rosetta_table_copy_out_p2;
267:
268: procedure rosetta_table_copy_in_p5(t out nocopy okl_dsf_pvt.okldatasrcfnctnstltbltype, a0 JTF_NUMBER_TABLE
269: , a1 JTF_VARCHAR2_TABLE_100
270: , a2 JTF_VARCHAR2_TABLE_100
271: , a3 JTF_VARCHAR2_TABLE_100
272: , a4 JTF_VARCHAR2_TABLE_2000

Line 305: procedure rosetta_table_copy_out_p5(t okl_dsf_pvt.okldatasrcfnctnstltbltype, a0 out nocopy JTF_NUMBER_TABLE

301: end loop;
302: end if;
303: end if;
304: end rosetta_table_copy_in_p5;
305: procedure rosetta_table_copy_out_p5(t okl_dsf_pvt.okldatasrcfnctnstltbltype, a0 out nocopy JTF_NUMBER_TABLE
306: , a1 out nocopy JTF_VARCHAR2_TABLE_100
307: , a2 out nocopy JTF_VARCHAR2_TABLE_100
308: , a3 out nocopy JTF_VARCHAR2_TABLE_100
309: , a4 out nocopy JTF_VARCHAR2_TABLE_2000

Line 374: procedure rosetta_table_copy_in_p8(t out nocopy okl_dsf_pvt.dsfv_tbl_type, a0 JTF_NUMBER_TABLE

370: end if;
371: end if;
372: end rosetta_table_copy_out_p5;
373:
374: procedure rosetta_table_copy_in_p8(t out nocopy okl_dsf_pvt.dsfv_tbl_type, a0 JTF_NUMBER_TABLE
375: , a1 JTF_NUMBER_TABLE
376: , a2 JTF_VARCHAR2_TABLE_100
377: , a3 JTF_VARCHAR2_TABLE_100
378: , a4 JTF_VARCHAR2_TABLE_200

Line 455: procedure rosetta_table_copy_out_p8(t okl_dsf_pvt.dsfv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

451: end loop;
452: end if;
453: end if;
454: end rosetta_table_copy_in_p8;
455: procedure rosetta_table_copy_out_p8(t okl_dsf_pvt.dsfv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
456: , a1 out nocopy JTF_NUMBER_TABLE
457: , a2 out nocopy JTF_VARCHAR2_TABLE_100
458: , a3 out nocopy JTF_VARCHAR2_TABLE_100
459: , a4 out nocopy JTF_VARCHAR2_TABLE_200

Line 706: ddp_dsfv_rec okl_dsf_pvt.dsfv_rec_type;

702: , p5_a31 NUMBER := 0-1962.0724
703: )
704:
705: as
706: ddp_dsfv_rec okl_dsf_pvt.dsfv_rec_type;
707: ddx_dsfv_rec okl_dsf_pvt.dsfv_rec_type;
708: ddindx binary_integer; indx binary_integer;
709: begin
710:

Line 707: ddx_dsfv_rec okl_dsf_pvt.dsfv_rec_type;

703: )
704:
705: as
706: ddp_dsfv_rec okl_dsf_pvt.dsfv_rec_type;
707: ddx_dsfv_rec okl_dsf_pvt.dsfv_rec_type;
708: ddindx binary_integer; indx binary_integer;
709: begin
710:
711: -- copy data to the local IN or IN-OUT args, if any

Line 752: okl_dsf_pvt.insert_row(p_api_version,

748: ddp_dsfv_rec.last_update_login := rosetta_g_miss_num_map(p5_a31);
749:
750:
751: -- here's the delegated call to the old PL/SQL routine
752: okl_dsf_pvt.insert_row(p_api_version,
753: p_init_msg_list,
754: x_return_status,
755: x_msg_count,
756: x_msg_data,

Line 873: ddp_dsfv_tbl okl_dsf_pvt.dsfv_tbl_type;

869: , p6_a31 out nocopy JTF_NUMBER_TABLE
870: )
871:
872: as
873: ddp_dsfv_tbl okl_dsf_pvt.dsfv_tbl_type;
874: ddx_dsfv_tbl okl_dsf_pvt.dsfv_tbl_type;
875: ddindx binary_integer; indx binary_integer;
876: begin
877:

Line 874: ddx_dsfv_tbl okl_dsf_pvt.dsfv_tbl_type;

870: )
871:
872: as
873: ddp_dsfv_tbl okl_dsf_pvt.dsfv_tbl_type;
874: ddx_dsfv_tbl okl_dsf_pvt.dsfv_tbl_type;
875: ddindx binary_integer; indx binary_integer;
876: begin
877:
878: -- copy data to the local IN or IN-OUT args, if any

Line 884: okl_dsf_pvt_w.rosetta_table_copy_in_p8(ddp_dsfv_tbl, p5_a0

880:
881:
882:
883:
884: okl_dsf_pvt_w.rosetta_table_copy_in_p8(ddp_dsfv_tbl, p5_a0
885: , p5_a1
886: , p5_a2
887: , p5_a3
888: , p5_a4

Line 920: okl_dsf_pvt.insert_row(p_api_version,

916: );
917:
918:
919: -- here's the delegated call to the old PL/SQL routine
920: okl_dsf_pvt.insert_row(p_api_version,
921: p_init_msg_list,
922: x_return_status,
923: x_msg_count,
924: x_msg_data,

Line 935: okl_dsf_pvt_w.rosetta_table_copy_out_p8(ddx_dsfv_tbl, p6_a0

931:
932:
933:
934:
935: okl_dsf_pvt_w.rosetta_table_copy_out_p8(ddx_dsfv_tbl, p6_a0
936: , p6_a1
937: , p6_a2
938: , p6_a3
939: , p6_a4

Line 1010: ddp_dsfv_rec okl_dsf_pvt.dsfv_rec_type;

1006: , p5_a31 NUMBER := 0-1962.0724
1007: )
1008:
1009: as
1010: ddp_dsfv_rec okl_dsf_pvt.dsfv_rec_type;
1011: ddindx binary_integer; indx binary_integer;
1012: begin
1013:
1014: -- copy data to the local IN or IN-OUT args, if any

Line 1054: okl_dsf_pvt.lock_row(p_api_version,

1050: ddp_dsfv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a30);
1051: ddp_dsfv_rec.last_update_login := rosetta_g_miss_num_map(p5_a31);
1052:
1053: -- here's the delegated call to the old PL/SQL routine
1054: okl_dsf_pvt.lock_row(p_api_version,
1055: p_init_msg_list,
1056: x_return_status,
1057: x_msg_count,
1058: x_msg_data,

Line 1109: ddp_dsfv_tbl okl_dsf_pvt.dsfv_tbl_type;

1105: , p5_a31 JTF_NUMBER_TABLE
1106: )
1107:
1108: as
1109: ddp_dsfv_tbl okl_dsf_pvt.dsfv_tbl_type;
1110: ddindx binary_integer; indx binary_integer;
1111: begin
1112:
1113: -- copy data to the local IN or IN-OUT args, if any

Line 1119: okl_dsf_pvt_w.rosetta_table_copy_in_p8(ddp_dsfv_tbl, p5_a0

1115:
1116:
1117:
1118:
1119: okl_dsf_pvt_w.rosetta_table_copy_in_p8(ddp_dsfv_tbl, p5_a0
1120: , p5_a1
1121: , p5_a2
1122: , p5_a3
1123: , p5_a4

Line 1154: okl_dsf_pvt.lock_row(p_api_version,

1150: , p5_a31
1151: );
1152:
1153: -- here's the delegated call to the old PL/SQL routine
1154: okl_dsf_pvt.lock_row(p_api_version,
1155: p_init_msg_list,
1156: x_return_status,
1157: x_msg_count,
1158: x_msg_data,

Line 1241: ddp_dsfv_rec okl_dsf_pvt.dsfv_rec_type;

1237: , p5_a31 NUMBER := 0-1962.0724
1238: )
1239:
1240: as
1241: ddp_dsfv_rec okl_dsf_pvt.dsfv_rec_type;
1242: ddx_dsfv_rec okl_dsf_pvt.dsfv_rec_type;
1243: ddindx binary_integer; indx binary_integer;
1244: begin
1245:

Line 1242: ddx_dsfv_rec okl_dsf_pvt.dsfv_rec_type;

1238: )
1239:
1240: as
1241: ddp_dsfv_rec okl_dsf_pvt.dsfv_rec_type;
1242: ddx_dsfv_rec okl_dsf_pvt.dsfv_rec_type;
1243: ddindx binary_integer; indx binary_integer;
1244: begin
1245:
1246: -- copy data to the local IN or IN-OUT args, if any

Line 1287: okl_dsf_pvt.update_row(p_api_version,

1283: ddp_dsfv_rec.last_update_login := rosetta_g_miss_num_map(p5_a31);
1284:
1285:
1286: -- here's the delegated call to the old PL/SQL routine
1287: okl_dsf_pvt.update_row(p_api_version,
1288: p_init_msg_list,
1289: x_return_status,
1290: x_msg_count,
1291: x_msg_data,

Line 1408: ddp_dsfv_tbl okl_dsf_pvt.dsfv_tbl_type;

1404: , p6_a31 out nocopy JTF_NUMBER_TABLE
1405: )
1406:
1407: as
1408: ddp_dsfv_tbl okl_dsf_pvt.dsfv_tbl_type;
1409: ddx_dsfv_tbl okl_dsf_pvt.dsfv_tbl_type;
1410: ddindx binary_integer; indx binary_integer;
1411: begin
1412:

Line 1409: ddx_dsfv_tbl okl_dsf_pvt.dsfv_tbl_type;

1405: )
1406:
1407: as
1408: ddp_dsfv_tbl okl_dsf_pvt.dsfv_tbl_type;
1409: ddx_dsfv_tbl okl_dsf_pvt.dsfv_tbl_type;
1410: ddindx binary_integer; indx binary_integer;
1411: begin
1412:
1413: -- copy data to the local IN or IN-OUT args, if any

Line 1419: okl_dsf_pvt_w.rosetta_table_copy_in_p8(ddp_dsfv_tbl, p5_a0

1415:
1416:
1417:
1418:
1419: okl_dsf_pvt_w.rosetta_table_copy_in_p8(ddp_dsfv_tbl, p5_a0
1420: , p5_a1
1421: , p5_a2
1422: , p5_a3
1423: , p5_a4

Line 1455: okl_dsf_pvt.update_row(p_api_version,

1451: );
1452:
1453:
1454: -- here's the delegated call to the old PL/SQL routine
1455: okl_dsf_pvt.update_row(p_api_version,
1456: p_init_msg_list,
1457: x_return_status,
1458: x_msg_count,
1459: x_msg_data,

Line 1470: okl_dsf_pvt_w.rosetta_table_copy_out_p8(ddx_dsfv_tbl, p6_a0

1466:
1467:
1468:
1469:
1470: okl_dsf_pvt_w.rosetta_table_copy_out_p8(ddx_dsfv_tbl, p6_a0
1471: , p6_a1
1472: , p6_a2
1473: , p6_a3
1474: , p6_a4

Line 1545: ddp_dsfv_rec okl_dsf_pvt.dsfv_rec_type;

1541: , p5_a31 NUMBER := 0-1962.0724
1542: )
1543:
1544: as
1545: ddp_dsfv_rec okl_dsf_pvt.dsfv_rec_type;
1546: ddindx binary_integer; indx binary_integer;
1547: begin
1548:
1549: -- copy data to the local IN or IN-OUT args, if any

Line 1589: okl_dsf_pvt.delete_row(p_api_version,

1585: ddp_dsfv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a30);
1586: ddp_dsfv_rec.last_update_login := rosetta_g_miss_num_map(p5_a31);
1587:
1588: -- here's the delegated call to the old PL/SQL routine
1589: okl_dsf_pvt.delete_row(p_api_version,
1590: p_init_msg_list,
1591: x_return_status,
1592: x_msg_count,
1593: x_msg_data,

Line 1644: ddp_dsfv_tbl okl_dsf_pvt.dsfv_tbl_type;

1640: , p5_a31 JTF_NUMBER_TABLE
1641: )
1642:
1643: as
1644: ddp_dsfv_tbl okl_dsf_pvt.dsfv_tbl_type;
1645: ddindx binary_integer; indx binary_integer;
1646: begin
1647:
1648: -- copy data to the local IN or IN-OUT args, if any

Line 1654: okl_dsf_pvt_w.rosetta_table_copy_in_p8(ddp_dsfv_tbl, p5_a0

1650:
1651:
1652:
1653:
1654: okl_dsf_pvt_w.rosetta_table_copy_in_p8(ddp_dsfv_tbl, p5_a0
1655: , p5_a1
1656: , p5_a2
1657: , p5_a3
1658: , p5_a4

Line 1689: okl_dsf_pvt.delete_row(p_api_version,

1685: , p5_a31
1686: );
1687:
1688: -- here's the delegated call to the old PL/SQL routine
1689: okl_dsf_pvt.delete_row(p_api_version,
1690: p_init_msg_list,
1691: x_return_status,
1692: x_msg_count,
1693: x_msg_data,

Line 1744: ddp_dsfv_rec okl_dsf_pvt.dsfv_rec_type;

1740: , p5_a31 NUMBER := 0-1962.0724
1741: )
1742:
1743: as
1744: ddp_dsfv_rec okl_dsf_pvt.dsfv_rec_type;
1745: ddindx binary_integer; indx binary_integer;
1746: begin
1747:
1748: -- copy data to the local IN or IN-OUT args, if any

Line 1788: okl_dsf_pvt.validate_row(p_api_version,

1784: ddp_dsfv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a30);
1785: ddp_dsfv_rec.last_update_login := rosetta_g_miss_num_map(p5_a31);
1786:
1787: -- here's the delegated call to the old PL/SQL routine
1788: okl_dsf_pvt.validate_row(p_api_version,
1789: p_init_msg_list,
1790: x_return_status,
1791: x_msg_count,
1792: x_msg_data,

Line 1843: ddp_dsfv_tbl okl_dsf_pvt.dsfv_tbl_type;

1839: , p5_a31 JTF_NUMBER_TABLE
1840: )
1841:
1842: as
1843: ddp_dsfv_tbl okl_dsf_pvt.dsfv_tbl_type;
1844: ddindx binary_integer; indx binary_integer;
1845: begin
1846:
1847: -- copy data to the local IN or IN-OUT args, if any

Line 1853: okl_dsf_pvt_w.rosetta_table_copy_in_p8(ddp_dsfv_tbl, p5_a0

1849:
1850:
1851:
1852:
1853: okl_dsf_pvt_w.rosetta_table_copy_in_p8(ddp_dsfv_tbl, p5_a0
1854: , p5_a1
1855: , p5_a2
1856: , p5_a3
1857: , p5_a4

Line 1888: okl_dsf_pvt.validate_row(p_api_version,

1884: , p5_a31
1885: );
1886:
1887: -- here's the delegated call to the old PL/SQL routine
1888: okl_dsf_pvt.validate_row(p_api_version,
1889: p_init_msg_list,
1890: x_return_status,
1891: x_msg_count,
1892: x_msg_data,

Line 1903: end okl_dsf_pvt_w;

1899:
1900:
1901: end;
1902:
1903: end okl_dsf_pvt_w;