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 dependencies on OKL_API

Line 7: px_error_rec IN OUT NOCOPY OKL_API.ERROR_REC_TYPE,

3: ---------------------------------------------------------------------------
4: -- PROCEDURE load_error_tbl
5: ---------------------------------------------------------------------------
6: PROCEDURE load_error_tbl (
7: px_error_rec IN OUT NOCOPY OKL_API.ERROR_REC_TYPE,
8: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS
9: j INTEGER := NVL(px_error_tbl.LAST, 0) + 1;
10: last_msg_idx INTEGER := FND_MSG_PUB.COUNT_MSG;
11: l_msg_idx INTEGER := FND_MSG_PUB.G_NEXT;

Line 8: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

4: -- PROCEDURE load_error_tbl
5: ---------------------------------------------------------------------------
6: PROCEDURE load_error_tbl (
7: px_error_rec IN OUT NOCOPY OKL_API.ERROR_REC_TYPE,
8: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS
9: j INTEGER := NVL(px_error_tbl.LAST, 0) + 1;
10: last_msg_idx INTEGER := FND_MSG_PUB.COUNT_MSG;
11: l_msg_idx INTEGER := FND_MSG_PUB.G_NEXT;
12: BEGIN

Line 39: -- in a OKL_API.ERROR_TBL_TYPE, and returns it.

35: ---------------------------------------------------------------------------
36: -- FUNCTION find_highest_exception
37: ---------------------------------------------------------------------------
38: -- Finds the highest exception (G_RET_STS_UNEXP_ERROR)
39: -- in a OKL_API.ERROR_TBL_TYPE, and returns it.
40: FUNCTION find_highest_exception(
41: p_error_tbl IN OKL_API.ERROR_TBL_TYPE
42: ) RETURN VARCHAR2 IS
43: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 41: p_error_tbl IN OKL_API.ERROR_TBL_TYPE

37: ---------------------------------------------------------------------------
38: -- Finds the highest exception (G_RET_STS_UNEXP_ERROR)
39: -- in a OKL_API.ERROR_TBL_TYPE, and returns it.
40: FUNCTION find_highest_exception(
41: p_error_tbl IN OKL_API.ERROR_TBL_TYPE
42: ) RETURN VARCHAR2 IS
43: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
44: i INTEGER := 1;
45: BEGIN

Line 1528: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

1524: x_return_status OUT NOCOPY VARCHAR2,
1525: x_msg_count OUT NOCOPY NUMBER,
1526: x_msg_data OUT NOCOPY VARCHAR2,
1527: p_clmv_tbl IN clmv_tbl_type,
1528: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS
1529: l_api_version CONSTANT NUMBER := 1;
1530: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_validate_row';
1531: i NUMBER := 0;
1532: BEGIN

Line 1539: l_error_rec OKL_API.ERROR_REC_TYPE;

1535: IF (p_clmv_tbl.COUNT > 0) THEN
1536: i := p_clmv_tbl.FIRST;
1537: LOOP
1538: DECLARE
1539: l_error_rec OKL_API.ERROR_REC_TYPE;
1540: BEGIN
1541: l_error_rec.api_name := l_api_name;
1542: l_error_rec.api_package := G_PKG_NAME;
1543: l_error_rec.idx := i;

Line 1625: l_error_tbl OKL_API.ERROR_TBL_TYPE;

1621: p_clmv_tbl IN clmv_tbl_type) IS
1622: l_api_version CONSTANT NUMBER := 1;
1623: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_validate_row';
1624: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1625: l_error_tbl OKL_API.ERROR_TBL_TYPE;
1626: BEGIN
1627: OKC_API.init_msg_list(p_init_msg_list);
1628: -- Make sure PL/SQL table has records in it before passing
1629: IF (p_clmv_tbl.COUNT > 0) THEN

Line 2284: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

2280: x_msg_count OUT NOCOPY NUMBER,
2281: x_msg_data OUT NOCOPY VARCHAR2,
2282: p_clmv_tbl IN clmv_tbl_type,
2283: x_clmv_tbl OUT NOCOPY clmv_tbl_type,
2284: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS
2285: l_api_version CONSTANT NUMBER := 1;
2286: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_insert_row';
2287: i NUMBER := 0;
2288: BEGIN

Line 2295: l_error_rec OKL_API.ERROR_REC_TYPE;

2291: IF (p_clmv_tbl.COUNT > 0) THEN
2292: i := p_clmv_tbl.FIRST;
2293: LOOP
2294: DECLARE
2295: l_error_rec OKL_API.ERROR_REC_TYPE;
2296: BEGIN
2297: l_error_rec.api_name := l_api_name;
2298: l_error_rec.api_package := G_PKG_NAME;
2299: l_error_rec.idx := i;

Line 2383: l_error_tbl OKL_API.ERROR_TBL_TYPE;

2379: x_clmv_tbl OUT NOCOPY clmv_tbl_type) IS
2380: l_api_version CONSTANT NUMBER := 1;
2381: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
2382: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2383: l_error_tbl OKL_API.ERROR_TBL_TYPE;
2384: BEGIN
2385: OKC_API.init_msg_list(p_init_msg_list);
2386: -- Make sure PL/SQL table has records in it before passing
2387: IF (p_clmv_tbl.COUNT > 0) THEN

Line 2725: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

2721: x_return_status OUT NOCOPY VARCHAR2,
2722: x_msg_count OUT NOCOPY NUMBER,
2723: x_msg_data OUT NOCOPY VARCHAR2,
2724: p_clmv_tbl IN clmv_tbl_type,
2725: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS
2726: l_api_version CONSTANT NUMBER := 1;
2727: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_lock_row';
2728: i NUMBER := 0;
2729: BEGIN

Line 2736: l_error_rec OKL_API.ERROR_REC_TYPE;

2732: IF (p_clmv_tbl.COUNT > 0) THEN
2733: i := p_clmv_tbl.FIRST;
2734: LOOP
2735: DECLARE
2736: l_error_rec OKL_API.ERROR_REC_TYPE;
2737: BEGIN
2738: l_error_rec.api_name := l_api_name;
2739: l_error_rec.api_package := G_PKG_NAME;
2740: l_error_rec.idx := i;

Line 2822: l_error_tbl OKL_API.ERROR_TBL_TYPE;

2818: p_clmv_tbl IN clmv_tbl_type) IS
2819: l_api_version CONSTANT NUMBER := 1;
2820: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_lock_row';
2821: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2822: l_error_tbl OKL_API.ERROR_TBL_TYPE;
2823: BEGIN
2824: OKC_API.init_msg_list(p_init_msg_list);
2825: -- Make sure PL/SQL table has recrods in it before passing
2826: IF (p_clmv_tbl.COUNT > 0) THEN

Line 3704: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

3700: x_msg_count OUT NOCOPY NUMBER,
3701: x_msg_data OUT NOCOPY VARCHAR2,
3702: p_clmv_tbl IN clmv_tbl_type,
3703: x_clmv_tbl OUT NOCOPY clmv_tbl_type,
3704: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS
3705: l_api_version CONSTANT NUMBER := 1;
3706: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_update_row';
3707: i NUMBER := 0;
3708: BEGIN

Line 3715: l_error_rec OKL_API.ERROR_REC_TYPE;

3711: IF (p_clmv_tbl.COUNT > 0) THEN
3712: i := p_clmv_tbl.FIRST;
3713: LOOP
3714: DECLARE
3715: l_error_rec OKL_API.ERROR_REC_TYPE;
3716: BEGIN
3717: l_error_rec.api_name := l_api_name;
3718: l_error_rec.api_package := G_PKG_NAME;
3719: l_error_rec.idx := i;

Line 3803: l_error_tbl OKL_API.ERROR_TBL_TYPE;

3799: x_clmv_tbl OUT NOCOPY clmv_tbl_type) IS
3800: l_api_version CONSTANT NUMBER := 1;
3801: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
3802: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3803: l_error_tbl OKL_API.ERROR_TBL_TYPE;
3804: BEGIN
3805: OKC_API.init_msg_list(p_init_msg_list);
3806: -- Make sure PL/SQL table has records in it before passing
3807: IF (p_clmv_tbl.COUNT > 0) THEN

Line 4079: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

4075: x_return_status OUT NOCOPY VARCHAR2,
4076: x_msg_count OUT NOCOPY NUMBER,
4077: x_msg_data OUT NOCOPY VARCHAR2,
4078: p_clmv_tbl IN clmv_tbl_type,
4079: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS
4080: l_api_version CONSTANT NUMBER := 1;
4081: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_delete_row';
4082: i NUMBER := 0;
4083: BEGIN

Line 4090: l_error_rec OKL_API.ERROR_REC_TYPE;

4086: IF (p_clmv_tbl.COUNT > 0) THEN
4087: i := p_clmv_tbl.FIRST;
4088: LOOP
4089: DECLARE
4090: l_error_rec OKL_API.ERROR_REC_TYPE;
4091: BEGIN
4092: l_error_rec.api_name := l_api_name;
4093: l_error_rec.api_package := G_PKG_NAME;
4094: l_error_rec.idx := i;

Line 4176: l_error_tbl OKL_API.ERROR_TBL_TYPE;

4172: p_clmv_tbl IN clmv_tbl_type) IS
4173: l_api_version CONSTANT NUMBER := 1;
4174: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
4175: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4176: l_error_tbl OKL_API.ERROR_TBL_TYPE;
4177: BEGIN
4178: OKC_API.init_msg_list(p_init_msg_list);
4179: -- Make sure PL/SQL table has records in it before passing
4180: IF (p_clmv_tbl.COUNT > 0) THEN