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_CAT_PVT_W dependencies on OKL_CAT_PVT

Line 1: package body okl_cat_pvt_w as

1: package body okl_cat_pvt_w as
2: /* $Header: OKLECATB.pls 120.2 2005/10/30 03:19:19 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_cat_pvt.cat_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_cat_pvt.cat_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_200
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_VARCHAR2_TABLE_2000
26: , a4 JTF_DATE_TABLE

Line 113: procedure rosetta_table_copy_out_p2(t okl_cat_pvt.cat_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

109: end loop;
110: end if;
111: end if;
112: end rosetta_table_copy_in_p2;
113: procedure rosetta_table_copy_out_p2(t okl_cat_pvt.cat_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
114: , a1 out nocopy JTF_VARCHAR2_TABLE_200
115: , a2 out nocopy JTF_NUMBER_TABLE
116: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
117: , a4 out nocopy JTF_DATE_TABLE

Line 317: procedure rosetta_table_copy_in_p5(t out nocopy okl_cat_pvt.catv_tbl_type, a0 JTF_NUMBER_TABLE

313: end if;
314: end if;
315: end rosetta_table_copy_out_p2;
316:
317: procedure rosetta_table_copy_in_p5(t out nocopy okl_cat_pvt.catv_tbl_type, a0 JTF_NUMBER_TABLE
318: , a1 JTF_NUMBER_TABLE
319: , a2 JTF_VARCHAR2_TABLE_200
320: , a3 JTF_VARCHAR2_TABLE_2000
321: , a4 JTF_DATE_TABLE

Line 408: procedure rosetta_table_copy_out_p5(t okl_cat_pvt.catv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

404: end loop;
405: end if;
406: end if;
407: end rosetta_table_copy_in_p5;
408: procedure rosetta_table_copy_out_p5(t okl_cat_pvt.catv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
409: , a1 out nocopy JTF_NUMBER_TABLE
410: , a2 out nocopy JTF_VARCHAR2_TABLE_200
411: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
412: , a4 out nocopy JTF_DATE_TABLE

Line 694: ddp_catv_rec okl_cat_pvt.catv_rec_type;

690: , p5_a36 NUMBER := 0-1962.0724
691: )
692:
693: as
694: ddp_catv_rec okl_cat_pvt.catv_rec_type;
695: ddx_catv_rec okl_cat_pvt.catv_rec_type;
696: ddindx binary_integer; indx binary_integer;
697: begin
698:

Line 695: ddx_catv_rec okl_cat_pvt.catv_rec_type;

691: )
692:
693: as
694: ddp_catv_rec okl_cat_pvt.catv_rec_type;
695: ddx_catv_rec okl_cat_pvt.catv_rec_type;
696: ddindx binary_integer; indx binary_integer;
697: begin
698:
699: -- copy data to the local IN or IN-OUT args, if any

Line 745: okl_cat_pvt.insert_row(p_api_version,

741: ddp_catv_rec.num_days_hold_adv_pay := rosetta_g_miss_num_map(p5_a36);
742:
743:
744: -- here's the delegated call to the old PL/SQL routine
745: okl_cat_pvt.insert_row(p_api_version,
746: p_init_msg_list,
747: x_return_status,
748: x_msg_count,
749: x_msg_data,

Line 881: ddp_catv_tbl okl_cat_pvt.catv_tbl_type;

877: , p6_a36 out nocopy JTF_NUMBER_TABLE
878: )
879:
880: as
881: ddp_catv_tbl okl_cat_pvt.catv_tbl_type;
882: ddx_catv_tbl okl_cat_pvt.catv_tbl_type;
883: ddindx binary_integer; indx binary_integer;
884: begin
885:

Line 882: ddx_catv_tbl okl_cat_pvt.catv_tbl_type;

878: )
879:
880: as
881: ddp_catv_tbl okl_cat_pvt.catv_tbl_type;
882: ddx_catv_tbl okl_cat_pvt.catv_tbl_type;
883: ddindx binary_integer; indx binary_integer;
884: begin
885:
886: -- copy data to the local IN or IN-OUT args, if any

Line 892: okl_cat_pvt_w.rosetta_table_copy_in_p5(ddp_catv_tbl, p5_a0

888:
889:
890:
891:
892: okl_cat_pvt_w.rosetta_table_copy_in_p5(ddp_catv_tbl, p5_a0
893: , p5_a1
894: , p5_a2
895: , p5_a3
896: , p5_a4

Line 933: okl_cat_pvt.insert_row(p_api_version,

929: );
930:
931:
932: -- here's the delegated call to the old PL/SQL routine
933: okl_cat_pvt.insert_row(p_api_version,
934: p_init_msg_list,
935: x_return_status,
936: x_msg_count,
937: x_msg_data,

Line 948: okl_cat_pvt_w.rosetta_table_copy_out_p5(ddx_catv_tbl, p6_a0

944:
945:
946:
947:
948: okl_cat_pvt_w.rosetta_table_copy_out_p5(ddx_catv_tbl, p6_a0
949: , p6_a1
950: , p6_a2
951: , p6_a3
952: , p6_a4

Line 1033: ddp_catv_rec okl_cat_pvt.catv_rec_type;

1029: , p5_a36 NUMBER := 0-1962.0724
1030: )
1031:
1032: as
1033: ddp_catv_rec okl_cat_pvt.catv_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 1082: okl_cat_pvt.lock_row(p_api_version,

1078: ddp_catv_rec.cau_id := rosetta_g_miss_num_map(p5_a35);
1079: ddp_catv_rec.num_days_hold_adv_pay := rosetta_g_miss_num_map(p5_a36);
1080:
1081: -- here's the delegated call to the old PL/SQL routine
1082: okl_cat_pvt.lock_row(p_api_version,
1083: p_init_msg_list,
1084: x_return_status,
1085: x_msg_count,
1086: x_msg_data,

Line 1142: ddp_catv_tbl okl_cat_pvt.catv_tbl_type;

1138: , p5_a36 JTF_NUMBER_TABLE
1139: )
1140:
1141: as
1142: ddp_catv_tbl okl_cat_pvt.catv_tbl_type;
1143: ddindx binary_integer; indx binary_integer;
1144: begin
1145:
1146: -- copy data to the local IN or IN-OUT args, if any

Line 1152: okl_cat_pvt_w.rosetta_table_copy_in_p5(ddp_catv_tbl, p5_a0

1148:
1149:
1150:
1151:
1152: okl_cat_pvt_w.rosetta_table_copy_in_p5(ddp_catv_tbl, p5_a0
1153: , p5_a1
1154: , p5_a2
1155: , p5_a3
1156: , p5_a4

Line 1192: okl_cat_pvt.lock_row(p_api_version,

1188: , p5_a36
1189: );
1190:
1191: -- here's the delegated call to the old PL/SQL routine
1192: okl_cat_pvt.lock_row(p_api_version,
1193: p_init_msg_list,
1194: x_return_status,
1195: x_msg_count,
1196: x_msg_data,

Line 1289: ddp_catv_rec okl_cat_pvt.catv_rec_type;

1285: , p5_a36 NUMBER := 0-1962.0724
1286: )
1287:
1288: as
1289: ddp_catv_rec okl_cat_pvt.catv_rec_type;
1290: ddx_catv_rec okl_cat_pvt.catv_rec_type;
1291: ddindx binary_integer; indx binary_integer;
1292: begin
1293:

Line 1290: ddx_catv_rec okl_cat_pvt.catv_rec_type;

1286: )
1287:
1288: as
1289: ddp_catv_rec okl_cat_pvt.catv_rec_type;
1290: ddx_catv_rec okl_cat_pvt.catv_rec_type;
1291: ddindx binary_integer; indx binary_integer;
1292: begin
1293:
1294: -- copy data to the local IN or IN-OUT args, if any

Line 1340: okl_cat_pvt.update_row(p_api_version,

1336: ddp_catv_rec.num_days_hold_adv_pay := rosetta_g_miss_num_map(p5_a36);
1337:
1338:
1339: -- here's the delegated call to the old PL/SQL routine
1340: okl_cat_pvt.update_row(p_api_version,
1341: p_init_msg_list,
1342: x_return_status,
1343: x_msg_count,
1344: x_msg_data,

Line 1476: ddp_catv_tbl okl_cat_pvt.catv_tbl_type;

1472: , p6_a36 out nocopy JTF_NUMBER_TABLE
1473: )
1474:
1475: as
1476: ddp_catv_tbl okl_cat_pvt.catv_tbl_type;
1477: ddx_catv_tbl okl_cat_pvt.catv_tbl_type;
1478: ddindx binary_integer; indx binary_integer;
1479: begin
1480:

Line 1477: ddx_catv_tbl okl_cat_pvt.catv_tbl_type;

1473: )
1474:
1475: as
1476: ddp_catv_tbl okl_cat_pvt.catv_tbl_type;
1477: ddx_catv_tbl okl_cat_pvt.catv_tbl_type;
1478: ddindx binary_integer; indx binary_integer;
1479: begin
1480:
1481: -- copy data to the local IN or IN-OUT args, if any

Line 1487: okl_cat_pvt_w.rosetta_table_copy_in_p5(ddp_catv_tbl, p5_a0

1483:
1484:
1485:
1486:
1487: okl_cat_pvt_w.rosetta_table_copy_in_p5(ddp_catv_tbl, p5_a0
1488: , p5_a1
1489: , p5_a2
1490: , p5_a3
1491: , p5_a4

Line 1528: okl_cat_pvt.update_row(p_api_version,

1524: );
1525:
1526:
1527: -- here's the delegated call to the old PL/SQL routine
1528: okl_cat_pvt.update_row(p_api_version,
1529: p_init_msg_list,
1530: x_return_status,
1531: x_msg_count,
1532: x_msg_data,

Line 1543: okl_cat_pvt_w.rosetta_table_copy_out_p5(ddx_catv_tbl, p6_a0

1539:
1540:
1541:
1542:
1543: okl_cat_pvt_w.rosetta_table_copy_out_p5(ddx_catv_tbl, p6_a0
1544: , p6_a1
1545: , p6_a2
1546: , p6_a3
1547: , p6_a4

Line 1628: ddp_catv_rec okl_cat_pvt.catv_rec_type;

1624: , p5_a36 NUMBER := 0-1962.0724
1625: )
1626:
1627: as
1628: ddp_catv_rec okl_cat_pvt.catv_rec_type;
1629: ddindx binary_integer; indx binary_integer;
1630: begin
1631:
1632: -- copy data to the local IN or IN-OUT args, if any

Line 1677: okl_cat_pvt.delete_row(p_api_version,

1673: ddp_catv_rec.cau_id := rosetta_g_miss_num_map(p5_a35);
1674: ddp_catv_rec.num_days_hold_adv_pay := rosetta_g_miss_num_map(p5_a36);
1675:
1676: -- here's the delegated call to the old PL/SQL routine
1677: okl_cat_pvt.delete_row(p_api_version,
1678: p_init_msg_list,
1679: x_return_status,
1680: x_msg_count,
1681: x_msg_data,

Line 1737: ddp_catv_tbl okl_cat_pvt.catv_tbl_type;

1733: , p5_a36 JTF_NUMBER_TABLE
1734: )
1735:
1736: as
1737: ddp_catv_tbl okl_cat_pvt.catv_tbl_type;
1738: ddindx binary_integer; indx binary_integer;
1739: begin
1740:
1741: -- copy data to the local IN or IN-OUT args, if any

Line 1747: okl_cat_pvt_w.rosetta_table_copy_in_p5(ddp_catv_tbl, p5_a0

1743:
1744:
1745:
1746:
1747: okl_cat_pvt_w.rosetta_table_copy_in_p5(ddp_catv_tbl, p5_a0
1748: , p5_a1
1749: , p5_a2
1750: , p5_a3
1751: , p5_a4

Line 1787: okl_cat_pvt.delete_row(p_api_version,

1783: , p5_a36
1784: );
1785:
1786: -- here's the delegated call to the old PL/SQL routine
1787: okl_cat_pvt.delete_row(p_api_version,
1788: p_init_msg_list,
1789: x_return_status,
1790: x_msg_count,
1791: x_msg_data,

Line 1847: ddp_catv_rec okl_cat_pvt.catv_rec_type;

1843: , p5_a36 NUMBER := 0-1962.0724
1844: )
1845:
1846: as
1847: ddp_catv_rec okl_cat_pvt.catv_rec_type;
1848: ddindx binary_integer; indx binary_integer;
1849: begin
1850:
1851: -- copy data to the local IN or IN-OUT args, if any

Line 1896: okl_cat_pvt.validate_row(p_api_version,

1892: ddp_catv_rec.cau_id := rosetta_g_miss_num_map(p5_a35);
1893: ddp_catv_rec.num_days_hold_adv_pay := rosetta_g_miss_num_map(p5_a36);
1894:
1895: -- here's the delegated call to the old PL/SQL routine
1896: okl_cat_pvt.validate_row(p_api_version,
1897: p_init_msg_list,
1898: x_return_status,
1899: x_msg_count,
1900: x_msg_data,

Line 1956: ddp_catv_tbl okl_cat_pvt.catv_tbl_type;

1952: , p5_a36 JTF_NUMBER_TABLE
1953: )
1954:
1955: as
1956: ddp_catv_tbl okl_cat_pvt.catv_tbl_type;
1957: ddindx binary_integer; indx binary_integer;
1958: begin
1959:
1960: -- copy data to the local IN or IN-OUT args, if any

Line 1966: okl_cat_pvt_w.rosetta_table_copy_in_p5(ddp_catv_tbl, p5_a0

1962:
1963:
1964:
1965:
1966: okl_cat_pvt_w.rosetta_table_copy_in_p5(ddp_catv_tbl, p5_a0
1967: , p5_a1
1968: , p5_a2
1969: , p5_a3
1970: , p5_a4

Line 2006: okl_cat_pvt.validate_row(p_api_version,

2002: , p5_a36
2003: );
2004:
2005: -- here's the delegated call to the old PL/SQL routine
2006: okl_cat_pvt.validate_row(p_api_version,
2007: p_init_msg_list,
2008: x_return_status,
2009: x_msg_count,
2010: x_msg_data,

Line 2021: end okl_cat_pvt_w;

2017:
2018:
2019: end;
2020:
2021: end okl_cat_pvt_w;