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_CRT_PVT_W dependencies on OKL_CRT_PVT

Line 1: package body okl_crt_pvt_w as

1: package body okl_crt_pvt_w as
2: /* $Header: OKLICRTB.pls 115.2 2003/10/07 17:58:41 pdevaraj 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_crt_pvt.crtv_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_crt_pvt.crtv_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_200
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_DATE_TABLE
26: , a4 JTF_NUMBER_TABLE

Line 115: procedure rosetta_table_copy_out_p2(t okl_crt_pvt.crtv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

111: end loop;
112: end if;
113: end if;
114: end rosetta_table_copy_in_p2;
115: procedure rosetta_table_copy_out_p2(t okl_crt_pvt.crtv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
116: , a1 out nocopy JTF_VARCHAR2_TABLE_200
117: , a2 out nocopy JTF_VARCHAR2_TABLE_100
118: , a3 out nocopy JTF_DATE_TABLE
119: , a4 out nocopy JTF_NUMBER_TABLE

Line 324: procedure rosetta_table_copy_in_p5(t out nocopy okl_crt_pvt.crt_tbl_type, a0 JTF_NUMBER_TABLE

320: end if;
321: end if;
322: end rosetta_table_copy_out_p2;
323:
324: procedure rosetta_table_copy_in_p5(t out nocopy okl_crt_pvt.crt_tbl_type, a0 JTF_NUMBER_TABLE
325: , a1 JTF_VARCHAR2_TABLE_200
326: , a2 JTF_VARCHAR2_TABLE_100
327: , a3 JTF_DATE_TABLE
328: , a4 JTF_NUMBER_TABLE

Line 417: procedure rosetta_table_copy_out_p5(t okl_crt_pvt.crt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

413: end loop;
414: end if;
415: end if;
416: end rosetta_table_copy_in_p5;
417: procedure rosetta_table_copy_out_p5(t okl_crt_pvt.crt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
418: , a1 out nocopy JTF_VARCHAR2_TABLE_200
419: , a2 out nocopy JTF_VARCHAR2_TABLE_100
420: , a3 out nocopy JTF_DATE_TABLE
421: , a4 out nocopy JTF_NUMBER_TABLE

Line 710: ddp_crtv_rec okl_crt_pvt.crtv_rec_type;

706: , p5_a37 NUMBER := 0-1962.0724
707: )
708:
709: as
710: ddp_crtv_rec okl_crt_pvt.crtv_rec_type;
711: ddx_crtv_rec okl_crt_pvt.crtv_rec_type;
712: ddindx binary_integer; indx binary_integer;
713: begin
714:

Line 711: ddx_crtv_rec okl_crt_pvt.crtv_rec_type;

707: )
708:
709: as
710: ddp_crtv_rec okl_crt_pvt.crtv_rec_type;
711: ddx_crtv_rec okl_crt_pvt.crtv_rec_type;
712: ddindx binary_integer; indx binary_integer;
713: begin
714:
715: -- copy data to the local IN or IN-OUT args, if any

Line 762: okl_crt_pvt.insert_row(p_api_version,

758: ddp_crtv_rec.last_update_login := rosetta_g_miss_num_map(p5_a37);
759:
760:
761: -- here's the delegated call to the old PL/SQL routine
762: okl_crt_pvt.insert_row(p_api_version,
763: p_init_msg_list,
764: x_return_status,
765: x_msg_count,
766: x_msg_data,

Line 901: ddp_crtv_tbl okl_crt_pvt.crtv_tbl_type;

897: , p6_a37 out nocopy JTF_NUMBER_TABLE
898: )
899:
900: as
901: ddp_crtv_tbl okl_crt_pvt.crtv_tbl_type;
902: ddx_crtv_tbl okl_crt_pvt.crtv_tbl_type;
903: ddindx binary_integer; indx binary_integer;
904: begin
905:

Line 902: ddx_crtv_tbl okl_crt_pvt.crtv_tbl_type;

898: )
899:
900: as
901: ddp_crtv_tbl okl_crt_pvt.crtv_tbl_type;
902: ddx_crtv_tbl okl_crt_pvt.crtv_tbl_type;
903: ddindx binary_integer; indx binary_integer;
904: begin
905:
906: -- copy data to the local IN or IN-OUT args, if any

Line 912: okl_crt_pvt_w.rosetta_table_copy_in_p2(ddp_crtv_tbl, p5_a0

908:
909:
910:
911:
912: okl_crt_pvt_w.rosetta_table_copy_in_p2(ddp_crtv_tbl, p5_a0
913: , p5_a1
914: , p5_a2
915: , p5_a3
916: , p5_a4

Line 954: okl_crt_pvt.insert_row(p_api_version,

950: );
951:
952:
953: -- here's the delegated call to the old PL/SQL routine
954: okl_crt_pvt.insert_row(p_api_version,
955: p_init_msg_list,
956: x_return_status,
957: x_msg_count,
958: x_msg_data,

Line 969: okl_crt_pvt_w.rosetta_table_copy_out_p2(ddx_crtv_tbl, p6_a0

965:
966:
967:
968:
969: okl_crt_pvt_w.rosetta_table_copy_out_p2(ddx_crtv_tbl, p6_a0
970: , p6_a1
971: , p6_a2
972: , p6_a3
973: , p6_a4

Line 1056: ddp_crtv_rec okl_crt_pvt.crtv_rec_type;

1052: , p5_a37 NUMBER := 0-1962.0724
1053: )
1054:
1055: as
1056: ddp_crtv_rec okl_crt_pvt.crtv_rec_type;
1057: ddindx binary_integer; indx binary_integer;
1058: begin
1059:
1060: -- copy data to the local IN or IN-OUT args, if any

Line 1106: okl_crt_pvt.lock_row(p_api_version,

1102: ddp_crtv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a36);
1103: ddp_crtv_rec.last_update_login := rosetta_g_miss_num_map(p5_a37);
1104:
1105: -- here's the delegated call to the old PL/SQL routine
1106: okl_crt_pvt.lock_row(p_api_version,
1107: p_init_msg_list,
1108: x_return_status,
1109: x_msg_count,
1110: x_msg_data,

Line 1167: ddp_crtv_tbl okl_crt_pvt.crtv_tbl_type;

1163: , p5_a37 JTF_NUMBER_TABLE
1164: )
1165:
1166: as
1167: ddp_crtv_tbl okl_crt_pvt.crtv_tbl_type;
1168: ddindx binary_integer; indx binary_integer;
1169: begin
1170:
1171: -- copy data to the local IN or IN-OUT args, if any

Line 1177: okl_crt_pvt_w.rosetta_table_copy_in_p2(ddp_crtv_tbl, p5_a0

1173:
1174:
1175:
1176:
1177: okl_crt_pvt_w.rosetta_table_copy_in_p2(ddp_crtv_tbl, p5_a0
1178: , p5_a1
1179: , p5_a2
1180: , p5_a3
1181: , p5_a4

Line 1218: okl_crt_pvt.lock_row(p_api_version,

1214: , p5_a37
1215: );
1216:
1217: -- here's the delegated call to the old PL/SQL routine
1218: okl_crt_pvt.lock_row(p_api_version,
1219: p_init_msg_list,
1220: x_return_status,
1221: x_msg_count,
1222: x_msg_data,

Line 1317: ddp_crtv_rec okl_crt_pvt.crtv_rec_type;

1313: , p5_a37 NUMBER := 0-1962.0724
1314: )
1315:
1316: as
1317: ddp_crtv_rec okl_crt_pvt.crtv_rec_type;
1318: ddx_crtv_rec okl_crt_pvt.crtv_rec_type;
1319: ddindx binary_integer; indx binary_integer;
1320: begin
1321:

Line 1318: ddx_crtv_rec okl_crt_pvt.crtv_rec_type;

1314: )
1315:
1316: as
1317: ddp_crtv_rec okl_crt_pvt.crtv_rec_type;
1318: ddx_crtv_rec okl_crt_pvt.crtv_rec_type;
1319: ddindx binary_integer; indx binary_integer;
1320: begin
1321:
1322: -- copy data to the local IN or IN-OUT args, if any

Line 1369: okl_crt_pvt.update_row(p_api_version,

1365: ddp_crtv_rec.last_update_login := rosetta_g_miss_num_map(p5_a37);
1366:
1367:
1368: -- here's the delegated call to the old PL/SQL routine
1369: okl_crt_pvt.update_row(p_api_version,
1370: p_init_msg_list,
1371: x_return_status,
1372: x_msg_count,
1373: x_msg_data,

Line 1508: ddp_crtv_tbl okl_crt_pvt.crtv_tbl_type;

1504: , p6_a37 out nocopy JTF_NUMBER_TABLE
1505: )
1506:
1507: as
1508: ddp_crtv_tbl okl_crt_pvt.crtv_tbl_type;
1509: ddx_crtv_tbl okl_crt_pvt.crtv_tbl_type;
1510: ddindx binary_integer; indx binary_integer;
1511: begin
1512:

Line 1509: ddx_crtv_tbl okl_crt_pvt.crtv_tbl_type;

1505: )
1506:
1507: as
1508: ddp_crtv_tbl okl_crt_pvt.crtv_tbl_type;
1509: ddx_crtv_tbl okl_crt_pvt.crtv_tbl_type;
1510: ddindx binary_integer; indx binary_integer;
1511: begin
1512:
1513: -- copy data to the local IN or IN-OUT args, if any

Line 1519: okl_crt_pvt_w.rosetta_table_copy_in_p2(ddp_crtv_tbl, p5_a0

1515:
1516:
1517:
1518:
1519: okl_crt_pvt_w.rosetta_table_copy_in_p2(ddp_crtv_tbl, p5_a0
1520: , p5_a1
1521: , p5_a2
1522: , p5_a3
1523: , p5_a4

Line 1561: okl_crt_pvt.update_row(p_api_version,

1557: );
1558:
1559:
1560: -- here's the delegated call to the old PL/SQL routine
1561: okl_crt_pvt.update_row(p_api_version,
1562: p_init_msg_list,
1563: x_return_status,
1564: x_msg_count,
1565: x_msg_data,

Line 1576: okl_crt_pvt_w.rosetta_table_copy_out_p2(ddx_crtv_tbl, p6_a0

1572:
1573:
1574:
1575:
1576: okl_crt_pvt_w.rosetta_table_copy_out_p2(ddx_crtv_tbl, p6_a0
1577: , p6_a1
1578: , p6_a2
1579: , p6_a3
1580: , p6_a4

Line 1663: ddp_crtv_rec okl_crt_pvt.crtv_rec_type;

1659: , p5_a37 NUMBER := 0-1962.0724
1660: )
1661:
1662: as
1663: ddp_crtv_rec okl_crt_pvt.crtv_rec_type;
1664: ddindx binary_integer; indx binary_integer;
1665: begin
1666:
1667: -- copy data to the local IN or IN-OUT args, if any

Line 1713: okl_crt_pvt.delete_row(p_api_version,

1709: ddp_crtv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a36);
1710: ddp_crtv_rec.last_update_login := rosetta_g_miss_num_map(p5_a37);
1711:
1712: -- here's the delegated call to the old PL/SQL routine
1713: okl_crt_pvt.delete_row(p_api_version,
1714: p_init_msg_list,
1715: x_return_status,
1716: x_msg_count,
1717: x_msg_data,

Line 1774: ddp_crtv_tbl okl_crt_pvt.crtv_tbl_type;

1770: , p5_a37 JTF_NUMBER_TABLE
1771: )
1772:
1773: as
1774: ddp_crtv_tbl okl_crt_pvt.crtv_tbl_type;
1775: ddindx binary_integer; indx binary_integer;
1776: begin
1777:
1778: -- copy data to the local IN or IN-OUT args, if any

Line 1784: okl_crt_pvt_w.rosetta_table_copy_in_p2(ddp_crtv_tbl, p5_a0

1780:
1781:
1782:
1783:
1784: okl_crt_pvt_w.rosetta_table_copy_in_p2(ddp_crtv_tbl, p5_a0
1785: , p5_a1
1786: , p5_a2
1787: , p5_a3
1788: , p5_a4

Line 1825: okl_crt_pvt.delete_row(p_api_version,

1821: , p5_a37
1822: );
1823:
1824: -- here's the delegated call to the old PL/SQL routine
1825: okl_crt_pvt.delete_row(p_api_version,
1826: p_init_msg_list,
1827: x_return_status,
1828: x_msg_count,
1829: x_msg_data,

Line 1886: ddp_crtv_rec okl_crt_pvt.crtv_rec_type;

1882: , p5_a37 NUMBER := 0-1962.0724
1883: )
1884:
1885: as
1886: ddp_crtv_rec okl_crt_pvt.crtv_rec_type;
1887: ddindx binary_integer; indx binary_integer;
1888: begin
1889:
1890: -- copy data to the local IN or IN-OUT args, if any

Line 1936: okl_crt_pvt.validate_row(p_api_version,

1932: ddp_crtv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a36);
1933: ddp_crtv_rec.last_update_login := rosetta_g_miss_num_map(p5_a37);
1934:
1935: -- here's the delegated call to the old PL/SQL routine
1936: okl_crt_pvt.validate_row(p_api_version,
1937: p_init_msg_list,
1938: x_return_status,
1939: x_msg_count,
1940: x_msg_data,

Line 1997: ddp_crtv_tbl okl_crt_pvt.crtv_tbl_type;

1993: , p5_a37 JTF_NUMBER_TABLE
1994: )
1995:
1996: as
1997: ddp_crtv_tbl okl_crt_pvt.crtv_tbl_type;
1998: ddindx binary_integer; indx binary_integer;
1999: begin
2000:
2001: -- copy data to the local IN or IN-OUT args, if any

Line 2007: okl_crt_pvt_w.rosetta_table_copy_in_p2(ddp_crtv_tbl, p5_a0

2003:
2004:
2005:
2006:
2007: okl_crt_pvt_w.rosetta_table_copy_in_p2(ddp_crtv_tbl, p5_a0
2008: , p5_a1
2009: , p5_a2
2010: , p5_a3
2011: , p5_a4

Line 2048: okl_crt_pvt.validate_row(p_api_version,

2044: , p5_a37
2045: );
2046:
2047: -- here's the delegated call to the old PL/SQL routine
2048: okl_crt_pvt.validate_row(p_api_version,
2049: p_init_msg_list,
2050: x_return_status,
2051: x_msg_count,
2052: x_msg_data,

Line 2063: end okl_crt_pvt_w;

2059:
2060:
2061: end;
2062:
2063: end okl_crt_pvt_w;