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

Line 8: px_error_rec IN OUT NOCOPY OKL_API.ERROR_REC_TYPE,

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

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

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

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

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

Line 43: p_error_tbl IN OKL_API.ERROR_TBL_TYPE

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

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

1329: x_return_status OUT NOCOPY VARCHAR2,
1330: x_msg_count OUT NOCOPY NUMBER,
1331: x_msg_data OUT NOCOPY VARCHAR2,
1332: p_ptcv_tbl IN ptcv_tbl_type,
1333: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS
1334:
1335: l_api_version CONSTANT NUMBER := 1;
1336: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_validate_row';
1337: i NUMBER := 0;

Line 1345: l_error_rec OKL_API.ERROR_REC_TYPE;

1341: IF (p_ptcv_tbl.COUNT > 0) THEN
1342: i := p_ptcv_tbl.FIRST;
1343: LOOP
1344: DECLARE
1345: l_error_rec OKL_API.ERROR_REC_TYPE;
1346: BEGIN
1347: l_error_rec.api_name := l_api_name;
1348: l_error_rec.api_package := G_PKG_NAME;
1349: l_error_rec.idx := i;

Line 1433: l_error_tbl OKL_API.ERROR_TBL_TYPE;

1429:
1430: l_api_version CONSTANT NUMBER := 1;
1431: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_validate_row';
1432: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1433: l_error_tbl OKL_API.ERROR_TBL_TYPE;
1434: BEGIN
1435: OKC_API.init_msg_list(p_init_msg_list);
1436: -- Make sure PL/SQL table has records in it before passing
1437: IF (p_ptcv_tbl.COUNT > 0) THEN

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

1952: x_msg_count OUT NOCOPY NUMBER,
1953: x_msg_data OUT NOCOPY VARCHAR2,
1954: p_ptcv_tbl IN ptcv_tbl_type,
1955: x_ptcv_tbl OUT NOCOPY ptcv_tbl_type,
1956: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS
1957:
1958: l_api_version CONSTANT NUMBER := 1;
1959: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_insert_row';
1960: i NUMBER := 0;

Line 1968: l_error_rec OKL_API.ERROR_REC_TYPE;

1964: IF (p_ptcv_tbl.COUNT > 0) THEN
1965: i := p_ptcv_tbl.FIRST;
1966: LOOP
1967: DECLARE
1968: l_error_rec OKL_API.ERROR_REC_TYPE;
1969: BEGIN
1970: l_error_rec.api_name := l_api_name;
1971: l_error_rec.api_package := G_PKG_NAME;
1972: l_error_rec.idx := i;

Line 2058: l_error_tbl OKL_API.ERROR_TBL_TYPE;

2054:
2055: l_api_version CONSTANT NUMBER := 1;
2056: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
2057: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2058: l_error_tbl OKL_API.ERROR_TBL_TYPE;
2059: BEGIN
2060: OKC_API.init_msg_list(p_init_msg_list);
2061: -- Make sure PL/SQL table has records in it before passing
2062: IF (p_ptcv_tbl.COUNT > 0) THEN

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

2549: x_return_status OUT NOCOPY VARCHAR2,
2550: x_msg_count OUT NOCOPY NUMBER,
2551: x_msg_data OUT NOCOPY VARCHAR2,
2552: p_ptcv_tbl IN ptcv_tbl_type,
2553: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS
2554:
2555: l_api_version CONSTANT NUMBER := 1;
2556: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_lock_row';
2557: i NUMBER := 0;

Line 2565: l_error_rec OKL_API.ERROR_REC_TYPE;

2561: IF (p_ptcv_tbl.COUNT > 0) THEN
2562: i := p_ptcv_tbl.FIRST;
2563: LOOP
2564: DECLARE
2565: l_error_rec OKL_API.ERROR_REC_TYPE;
2566: BEGIN
2567: l_error_rec.api_name := l_api_name;
2568: l_error_rec.api_package := G_PKG_NAME;
2569: l_error_rec.idx := i;

Line 2652: l_error_tbl OKL_API.ERROR_TBL_TYPE;

2648:
2649: l_api_version CONSTANT NUMBER := 1;
2650: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_lock_row';
2651: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2652: l_error_tbl OKL_API.ERROR_TBL_TYPE;
2653: BEGIN
2654: OKC_API.init_msg_list(p_init_msg_list);
2655: -- Make sure PL/SQL table has recrods in it before passing
2656: IF (p_ptcv_tbl.COUNT > 0) THEN

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

3643: x_msg_count OUT NOCOPY NUMBER,
3644: x_msg_data OUT NOCOPY VARCHAR2,
3645: p_ptcv_tbl IN ptcv_tbl_type,
3646: x_ptcv_tbl OUT NOCOPY ptcv_tbl_type,
3647: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS
3648:
3649: l_api_version CONSTANT NUMBER := 1;
3650: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_update_row';
3651: i NUMBER := 0;

Line 3659: l_error_rec OKL_API.ERROR_REC_TYPE;

3655: IF (p_ptcv_tbl.COUNT > 0) THEN
3656: i := p_ptcv_tbl.FIRST;
3657: LOOP
3658: DECLARE
3659: l_error_rec OKL_API.ERROR_REC_TYPE;
3660: BEGIN
3661: l_error_rec.api_name := l_api_name;
3662: l_error_rec.api_package := G_PKG_NAME;
3663: l_error_rec.idx := i;

Line 3749: l_error_tbl OKL_API.ERROR_TBL_TYPE;

3745:
3746: l_api_version CONSTANT NUMBER := 1;
3747: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
3748: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3749: l_error_tbl OKL_API.ERROR_TBL_TYPE;
3750: BEGIN
3751: OKC_API.init_msg_list(p_init_msg_list);
3752: -- Make sure PL/SQL table has records in it before passing
3753: IF (p_ptcv_tbl.COUNT > 0) THEN

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

4029: x_return_status OUT NOCOPY VARCHAR2,
4030: x_msg_count OUT NOCOPY NUMBER,
4031: x_msg_data OUT NOCOPY VARCHAR2,
4032: p_ptcv_tbl IN ptcv_tbl_type,
4033: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS
4034:
4035: l_api_version CONSTANT NUMBER := 1;
4036: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_delete_row';
4037: i NUMBER := 0;

Line 4045: l_error_rec OKL_API.ERROR_REC_TYPE;

4041: IF (p_ptcv_tbl.COUNT > 0) THEN
4042: i := p_ptcv_tbl.FIRST;
4043: LOOP
4044: DECLARE
4045: l_error_rec OKL_API.ERROR_REC_TYPE;
4046: BEGIN
4047: l_error_rec.api_name := l_api_name;
4048: l_error_rec.api_package := G_PKG_NAME;
4049: l_error_rec.idx := i;

Line 4133: l_error_tbl OKL_API.ERROR_TBL_TYPE;

4129:
4130: l_api_version CONSTANT NUMBER := 1;
4131: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
4132: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4133: l_error_tbl OKL_API.ERROR_TBL_TYPE;
4134: BEGIN
4135: OKC_API.init_msg_list(p_init_msg_list);
4136: -- Make sure PL/SQL table has records in it before passing
4137: IF (p_ptcv_tbl.COUNT > 0) THEN