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_CLM_PVT_W dependencies on OKL_CLM_PVT

Line 1: package body okl_clm_pvt_w as

1: package body okl_clm_pvt_w as
2: /* $Header: OKLICLMB.pls 115.2 2003/05/26 07:45:50 arajagop 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_clm_pvt.clmv_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_clm_pvt.clmv_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_300
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100

Line 119: procedure rosetta_table_copy_out_p2(t okl_clm_pvt.clmv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

115: end loop;
116: end if;
117: end if;
118: end rosetta_table_copy_in_p2;
119: procedure rosetta_table_copy_out_p2(t okl_clm_pvt.clmv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
120: , a1 out nocopy JTF_NUMBER_TABLE
121: , a2 out nocopy JTF_VARCHAR2_TABLE_300
122: , a3 out nocopy JTF_NUMBER_TABLE
123: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 338: procedure rosetta_table_copy_in_p5(t out nocopy okl_clm_pvt.clm_tbl_type, a0 JTF_NUMBER_TABLE

334: end if;
335: end if;
336: end rosetta_table_copy_out_p2;
337:
338: procedure rosetta_table_copy_in_p5(t out nocopy okl_clm_pvt.clm_tbl_type, a0 JTF_NUMBER_TABLE
339: , a1 JTF_VARCHAR2_TABLE_100
340: , a2 JTF_VARCHAR2_TABLE_100
341: , a3 JTF_NUMBER_TABLE
342: , a4 JTF_VARCHAR2_TABLE_100

Line 429: procedure rosetta_table_copy_out_p5(t okl_clm_pvt.clm_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

425: end loop;
426: end if;
427: end if;
428: end rosetta_table_copy_in_p5;
429: procedure rosetta_table_copy_out_p5(t okl_clm_pvt.clm_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
430: , a1 out nocopy JTF_VARCHAR2_TABLE_100
431: , a2 out nocopy JTF_VARCHAR2_TABLE_100
432: , a3 out nocopy JTF_NUMBER_TABLE
433: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 633: procedure rosetta_table_copy_in_p8(t out nocopy okl_clm_pvt.okl_ins_claims_tl_tbl_type, a0 JTF_NUMBER_TABLE

629: end if;
630: end if;
631: end rosetta_table_copy_out_p5;
632:
633: procedure rosetta_table_copy_in_p8(t out nocopy okl_clm_pvt.okl_ins_claims_tl_tbl_type, a0 JTF_NUMBER_TABLE
634: , a1 JTF_VARCHAR2_TABLE_300
635: , a2 JTF_VARCHAR2_TABLE_2000
636: , a3 JTF_VARCHAR2_TABLE_300
637: , a4 JTF_VARCHAR2_TABLE_2000

Line 674: procedure rosetta_table_copy_out_p8(t okl_clm_pvt.okl_ins_claims_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

670: end loop;
671: end if;
672: end if;
673: end rosetta_table_copy_in_p8;
674: procedure rosetta_table_copy_out_p8(t okl_clm_pvt.okl_ins_claims_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
675: , a1 out nocopy JTF_VARCHAR2_TABLE_300
676: , a2 out nocopy JTF_VARCHAR2_TABLE_2000
677: , a3 out nocopy JTF_VARCHAR2_TABLE_300
678: , a4 out nocopy JTF_VARCHAR2_TABLE_2000

Line 841: ddp_clmv_rec okl_clm_pvt.clmv_rec_type;

837: , p5_a39 NUMBER := 0-1962.0724
838: )
839:
840: as
841: ddp_clmv_rec okl_clm_pvt.clmv_rec_type;
842: ddx_clmv_rec okl_clm_pvt.clmv_rec_type;
843: ddindx binary_integer; indx binary_integer;
844: begin
845:

Line 842: ddx_clmv_rec okl_clm_pvt.clmv_rec_type;

838: )
839:
840: as
841: ddp_clmv_rec okl_clm_pvt.clmv_rec_type;
842: ddx_clmv_rec okl_clm_pvt.clmv_rec_type;
843: ddindx binary_integer; indx binary_integer;
844: begin
845:
846: -- copy data to the local IN or IN-OUT args, if any

Line 895: okl_clm_pvt.insert_row(p_api_version,

891: ddp_clmv_rec.last_update_login := rosetta_g_miss_num_map(p5_a39);
892:
893:
894: -- here's the delegated call to the old PL/SQL routine
895: okl_clm_pvt.insert_row(p_api_version,
896: p_init_msg_list,
897: x_return_status,
898: x_msg_count,
899: x_msg_data,

Line 1040: ddp_clmv_tbl okl_clm_pvt.clmv_tbl_type;

1036: , p6_a39 out nocopy JTF_NUMBER_TABLE
1037: )
1038:
1039: as
1040: ddp_clmv_tbl okl_clm_pvt.clmv_tbl_type;
1041: ddx_clmv_tbl okl_clm_pvt.clmv_tbl_type;
1042: ddindx binary_integer; indx binary_integer;
1043: begin
1044:

Line 1041: ddx_clmv_tbl okl_clm_pvt.clmv_tbl_type;

1037: )
1038:
1039: as
1040: ddp_clmv_tbl okl_clm_pvt.clmv_tbl_type;
1041: ddx_clmv_tbl okl_clm_pvt.clmv_tbl_type;
1042: ddindx binary_integer; indx binary_integer;
1043: begin
1044:
1045: -- copy data to the local IN or IN-OUT args, if any

Line 1051: okl_clm_pvt_w.rosetta_table_copy_in_p2(ddp_clmv_tbl, p5_a0

1047:
1048:
1049:
1050:
1051: okl_clm_pvt_w.rosetta_table_copy_in_p2(ddp_clmv_tbl, p5_a0
1052: , p5_a1
1053: , p5_a2
1054: , p5_a3
1055: , p5_a4

Line 1095: okl_clm_pvt.insert_row(p_api_version,

1091: );
1092:
1093:
1094: -- here's the delegated call to the old PL/SQL routine
1095: okl_clm_pvt.insert_row(p_api_version,
1096: p_init_msg_list,
1097: x_return_status,
1098: x_msg_count,
1099: x_msg_data,

Line 1110: okl_clm_pvt_w.rosetta_table_copy_out_p2(ddx_clmv_tbl, p6_a0

1106:
1107:
1108:
1109:
1110: okl_clm_pvt_w.rosetta_table_copy_out_p2(ddx_clmv_tbl, p6_a0
1111: , p6_a1
1112: , p6_a2
1113: , p6_a3
1114: , p6_a4

Line 1201: ddp_clmv_rec okl_clm_pvt.clmv_rec_type;

1197: , p5_a39 NUMBER := 0-1962.0724
1198: )
1199:
1200: as
1201: ddp_clmv_rec okl_clm_pvt.clmv_rec_type;
1202: ddindx binary_integer; indx binary_integer;
1203: begin
1204:
1205: -- copy data to the local IN or IN-OUT args, if any

Line 1253: okl_clm_pvt.lock_row(p_api_version,

1249: ddp_clmv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a38);
1250: ddp_clmv_rec.last_update_login := rosetta_g_miss_num_map(p5_a39);
1251:
1252: -- here's the delegated call to the old PL/SQL routine
1253: okl_clm_pvt.lock_row(p_api_version,
1254: p_init_msg_list,
1255: x_return_status,
1256: x_msg_count,
1257: x_msg_data,

Line 1316: ddp_clmv_tbl okl_clm_pvt.clmv_tbl_type;

1312: , p5_a39 JTF_NUMBER_TABLE
1313: )
1314:
1315: as
1316: ddp_clmv_tbl okl_clm_pvt.clmv_tbl_type;
1317: ddindx binary_integer; indx binary_integer;
1318: begin
1319:
1320: -- copy data to the local IN or IN-OUT args, if any

Line 1326: okl_clm_pvt_w.rosetta_table_copy_in_p2(ddp_clmv_tbl, p5_a0

1322:
1323:
1324:
1325:
1326: okl_clm_pvt_w.rosetta_table_copy_in_p2(ddp_clmv_tbl, p5_a0
1327: , p5_a1
1328: , p5_a2
1329: , p5_a3
1330: , p5_a4

Line 1369: okl_clm_pvt.lock_row(p_api_version,

1365: , p5_a39
1366: );
1367:
1368: -- here's the delegated call to the old PL/SQL routine
1369: okl_clm_pvt.lock_row(p_api_version,
1370: p_init_msg_list,
1371: x_return_status,
1372: x_msg_count,
1373: x_msg_data,

Line 1472: ddp_clmv_rec okl_clm_pvt.clmv_rec_type;

1468: , p5_a39 NUMBER := 0-1962.0724
1469: )
1470:
1471: as
1472: ddp_clmv_rec okl_clm_pvt.clmv_rec_type;
1473: ddx_clmv_rec okl_clm_pvt.clmv_rec_type;
1474: ddindx binary_integer; indx binary_integer;
1475: begin
1476:

Line 1473: ddx_clmv_rec okl_clm_pvt.clmv_rec_type;

1469: )
1470:
1471: as
1472: ddp_clmv_rec okl_clm_pvt.clmv_rec_type;
1473: ddx_clmv_rec okl_clm_pvt.clmv_rec_type;
1474: ddindx binary_integer; indx binary_integer;
1475: begin
1476:
1477: -- copy data to the local IN or IN-OUT args, if any

Line 1526: okl_clm_pvt.update_row(p_api_version,

1522: ddp_clmv_rec.last_update_login := rosetta_g_miss_num_map(p5_a39);
1523:
1524:
1525: -- here's the delegated call to the old PL/SQL routine
1526: okl_clm_pvt.update_row(p_api_version,
1527: p_init_msg_list,
1528: x_return_status,
1529: x_msg_count,
1530: x_msg_data,

Line 1671: ddp_clmv_tbl okl_clm_pvt.clmv_tbl_type;

1667: , p6_a39 out nocopy JTF_NUMBER_TABLE
1668: )
1669:
1670: as
1671: ddp_clmv_tbl okl_clm_pvt.clmv_tbl_type;
1672: ddx_clmv_tbl okl_clm_pvt.clmv_tbl_type;
1673: ddindx binary_integer; indx binary_integer;
1674: begin
1675:

Line 1672: ddx_clmv_tbl okl_clm_pvt.clmv_tbl_type;

1668: )
1669:
1670: as
1671: ddp_clmv_tbl okl_clm_pvt.clmv_tbl_type;
1672: ddx_clmv_tbl okl_clm_pvt.clmv_tbl_type;
1673: ddindx binary_integer; indx binary_integer;
1674: begin
1675:
1676: -- copy data to the local IN or IN-OUT args, if any

Line 1682: okl_clm_pvt_w.rosetta_table_copy_in_p2(ddp_clmv_tbl, p5_a0

1678:
1679:
1680:
1681:
1682: okl_clm_pvt_w.rosetta_table_copy_in_p2(ddp_clmv_tbl, p5_a0
1683: , p5_a1
1684: , p5_a2
1685: , p5_a3
1686: , p5_a4

Line 1726: okl_clm_pvt.update_row(p_api_version,

1722: );
1723:
1724:
1725: -- here's the delegated call to the old PL/SQL routine
1726: okl_clm_pvt.update_row(p_api_version,
1727: p_init_msg_list,
1728: x_return_status,
1729: x_msg_count,
1730: x_msg_data,

Line 1741: okl_clm_pvt_w.rosetta_table_copy_out_p2(ddx_clmv_tbl, p6_a0

1737:
1738:
1739:
1740:
1741: okl_clm_pvt_w.rosetta_table_copy_out_p2(ddx_clmv_tbl, p6_a0
1742: , p6_a1
1743: , p6_a2
1744: , p6_a3
1745: , p6_a4

Line 1832: ddp_clmv_rec okl_clm_pvt.clmv_rec_type;

1828: , p5_a39 NUMBER := 0-1962.0724
1829: )
1830:
1831: as
1832: ddp_clmv_rec okl_clm_pvt.clmv_rec_type;
1833: ddindx binary_integer; indx binary_integer;
1834: begin
1835:
1836: -- copy data to the local IN or IN-OUT args, if any

Line 1884: okl_clm_pvt.delete_row(p_api_version,

1880: ddp_clmv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a38);
1881: ddp_clmv_rec.last_update_login := rosetta_g_miss_num_map(p5_a39);
1882:
1883: -- here's the delegated call to the old PL/SQL routine
1884: okl_clm_pvt.delete_row(p_api_version,
1885: p_init_msg_list,
1886: x_return_status,
1887: x_msg_count,
1888: x_msg_data,

Line 1947: ddp_clmv_tbl okl_clm_pvt.clmv_tbl_type;

1943: , p5_a39 JTF_NUMBER_TABLE
1944: )
1945:
1946: as
1947: ddp_clmv_tbl okl_clm_pvt.clmv_tbl_type;
1948: ddindx binary_integer; indx binary_integer;
1949: begin
1950:
1951: -- copy data to the local IN or IN-OUT args, if any

Line 1957: okl_clm_pvt_w.rosetta_table_copy_in_p2(ddp_clmv_tbl, p5_a0

1953:
1954:
1955:
1956:
1957: okl_clm_pvt_w.rosetta_table_copy_in_p2(ddp_clmv_tbl, p5_a0
1958: , p5_a1
1959: , p5_a2
1960: , p5_a3
1961: , p5_a4

Line 2000: okl_clm_pvt.delete_row(p_api_version,

1996: , p5_a39
1997: );
1998:
1999: -- here's the delegated call to the old PL/SQL routine
2000: okl_clm_pvt.delete_row(p_api_version,
2001: p_init_msg_list,
2002: x_return_status,
2003: x_msg_count,
2004: x_msg_data,

Line 2063: ddp_clmv_rec okl_clm_pvt.clmv_rec_type;

2059: , p5_a39 NUMBER := 0-1962.0724
2060: )
2061:
2062: as
2063: ddp_clmv_rec okl_clm_pvt.clmv_rec_type;
2064: ddindx binary_integer; indx binary_integer;
2065: begin
2066:
2067: -- copy data to the local IN or IN-OUT args, if any

Line 2115: okl_clm_pvt.validate_row(p_api_version,

2111: ddp_clmv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a38);
2112: ddp_clmv_rec.last_update_login := rosetta_g_miss_num_map(p5_a39);
2113:
2114: -- here's the delegated call to the old PL/SQL routine
2115: okl_clm_pvt.validate_row(p_api_version,
2116: p_init_msg_list,
2117: x_return_status,
2118: x_msg_count,
2119: x_msg_data,

Line 2178: ddp_clmv_tbl okl_clm_pvt.clmv_tbl_type;

2174: , p5_a39 JTF_NUMBER_TABLE
2175: )
2176:
2177: as
2178: ddp_clmv_tbl okl_clm_pvt.clmv_tbl_type;
2179: ddindx binary_integer; indx binary_integer;
2180: begin
2181:
2182: -- copy data to the local IN or IN-OUT args, if any

Line 2188: okl_clm_pvt_w.rosetta_table_copy_in_p2(ddp_clmv_tbl, p5_a0

2184:
2185:
2186:
2187:
2188: okl_clm_pvt_w.rosetta_table_copy_in_p2(ddp_clmv_tbl, p5_a0
2189: , p5_a1
2190: , p5_a2
2191: , p5_a3
2192: , p5_a4

Line 2231: okl_clm_pvt.validate_row(p_api_version,

2227: , p5_a39
2228: );
2229:
2230: -- here's the delegated call to the old PL/SQL routine
2231: okl_clm_pvt.validate_row(p_api_version,
2232: p_init_msg_list,
2233: x_return_status,
2234: x_msg_count,
2235: x_msg_data,

Line 2246: end okl_clm_pvt_w;

2242:
2243:
2244: end;
2245:
2246: end okl_clm_pvt_w;