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

Line 9: px_error_rec IN OUT NOCOPY OKL_API.ERROR_REC_TYPE,

5: ---------------------------------------------------------------------------
6: PG_DEBUG NUMBER(2) := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));
7:
8: PROCEDURE load_error_tbl (
9: px_error_rec IN OUT NOCOPY OKL_API.ERROR_REC_TYPE,
10: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) AS
11:
12: j INTEGER := NVL(px_error_tbl.LAST, 0) + 1;
13: last_msg_idx INTEGER := FND_MSG_PUB.COUNT_MSG;

Line 10: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) AS

6: PG_DEBUG NUMBER(2) := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));
7:
8: PROCEDURE load_error_tbl (
9: px_error_rec IN OUT NOCOPY OKL_API.ERROR_REC_TYPE,
10: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) AS
11:
12: j INTEGER := NVL(px_error_tbl.LAST, 0) + 1;
13: last_msg_idx INTEGER := FND_MSG_PUB.COUNT_MSG;
14: l_msg_idx INTEGER := FND_MSG_PUB.G_NEXT;

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

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

Line 44: p_error_tbl IN OKL_API.ERROR_TBL_TYPE

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

Line 1209: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) AS

1205: x_return_status OUT NOCOPY VARCHAR2,
1206: x_msg_count OUT NOCOPY NUMBER,
1207: x_msg_data OUT NOCOPY VARCHAR2,
1208: p_iehv_tbl IN iehv_tbl_type,
1209: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) AS
1210:
1211: l_api_version CONSTANT NUMBER := 1;
1212: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_validate_row';
1213: i NUMBER := 0;

Line 1221: l_error_rec OKL_API.ERROR_REC_TYPE;

1217: IF (p_iehv_tbl.COUNT > 0) THEN
1218: i := p_iehv_tbl.FIRST;
1219: LOOP
1220: DECLARE
1221: l_error_rec OKL_API.ERROR_REC_TYPE;
1222: BEGIN
1223: l_error_rec.api_name := l_api_name;
1224: l_error_rec.api_package := G_PKG_NAME;
1225: l_error_rec.idx := i;

Line 1309: l_error_tbl OKL_API.ERROR_TBL_TYPE;

1305:
1306: l_api_version CONSTANT NUMBER := 1;
1307: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_validate_row';
1308: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1309: l_error_tbl OKL_API.ERROR_TBL_TYPE;
1310: BEGIN
1311: OKC_API.init_msg_list(p_init_msg_list);
1312: -- Make sure PL/SQL table has records in it before passing
1313: IF (p_iehv_tbl.COUNT > 0) THEN

Line 1801: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) AS

1797: x_msg_count OUT NOCOPY NUMBER,
1798: x_msg_data OUT NOCOPY VARCHAR2,
1799: p_iehv_tbl IN iehv_tbl_type,
1800: x_iehv_tbl OUT NOCOPY iehv_tbl_type,
1801: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) AS
1802:
1803: l_api_version CONSTANT NUMBER := 1;
1804: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_insert_row';
1805: i NUMBER := 0;

Line 1813: l_error_rec OKL_API.ERROR_REC_TYPE;

1809: IF (p_iehv_tbl.COUNT > 0) THEN
1810: i := p_iehv_tbl.FIRST;
1811: LOOP
1812: DECLARE
1813: l_error_rec OKL_API.ERROR_REC_TYPE;
1814: BEGIN
1815: l_error_rec.api_name := l_api_name;
1816: l_error_rec.api_package := G_PKG_NAME;
1817: l_error_rec.idx := i;

Line 1903: l_error_tbl OKL_API.ERROR_TBL_TYPE;

1899:
1900: l_api_version CONSTANT NUMBER := 1;
1901: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
1902: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1903: l_error_tbl OKL_API.ERROR_TBL_TYPE;
1904: BEGIN
1905: OKC_API.init_msg_list(p_init_msg_list);
1906: -- Make sure PL/SQL table has records in it before passing
1907: IF (p_iehv_tbl.COUNT > 0) THEN

Line 2253: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) AS

2249: x_return_status OUT NOCOPY VARCHAR2,
2250: x_msg_count OUT NOCOPY NUMBER,
2251: x_msg_data OUT NOCOPY VARCHAR2,
2252: p_iehv_tbl IN iehv_tbl_type,
2253: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) AS
2254:
2255: l_api_version CONSTANT NUMBER := 1;
2256: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_lock_row';
2257: i NUMBER := 0;

Line 2265: l_error_rec OKL_API.ERROR_REC_TYPE;

2261: IF (p_iehv_tbl.COUNT > 0) THEN
2262: i := p_iehv_tbl.FIRST;
2263: LOOP
2264: DECLARE
2265: l_error_rec OKL_API.ERROR_REC_TYPE;
2266: BEGIN
2267: l_error_rec.api_name := l_api_name;
2268: l_error_rec.api_package := G_PKG_NAME;
2269: l_error_rec.idx := i;

Line 2352: l_error_tbl OKL_API.ERROR_TBL_TYPE;

2348:
2349: l_api_version CONSTANT NUMBER := 1;
2350: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_lock_row';
2351: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2352: l_error_tbl OKL_API.ERROR_TBL_TYPE;
2353: BEGIN
2354: OKC_API.init_msg_list(p_init_msg_list);
2355: -- Make sure PL/SQL table has recrods in it before passing
2356: IF (p_iehv_tbl.COUNT > 0) THEN

Line 3194: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) AS

3190: x_msg_count OUT NOCOPY NUMBER,
3191: x_msg_data OUT NOCOPY VARCHAR2,
3192: p_iehv_tbl IN iehv_tbl_type,
3193: x_iehv_tbl OUT NOCOPY iehv_tbl_type,
3194: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) AS
3195:
3196: l_api_version CONSTANT NUMBER := 1;
3197: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_update_row';
3198: i NUMBER := 0;

Line 3206: l_error_rec OKL_API.ERROR_REC_TYPE;

3202: IF (p_iehv_tbl.COUNT > 0) THEN
3203: i := p_iehv_tbl.FIRST;
3204: LOOP
3205: DECLARE
3206: l_error_rec OKL_API.ERROR_REC_TYPE;
3207: BEGIN
3208: l_error_rec.api_name := l_api_name;
3209: l_error_rec.api_package := G_PKG_NAME;
3210: l_error_rec.idx := i;

Line 3296: l_error_tbl OKL_API.ERROR_TBL_TYPE;

3292:
3293: l_api_version CONSTANT NUMBER := 1;
3294: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
3295: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3296: l_error_tbl OKL_API.ERROR_TBL_TYPE;
3297: BEGIN
3298: OKC_API.init_msg_list(p_init_msg_list);
3299: -- Make sure PL/SQL table has records in it before passing
3300: IF (p_iehv_tbl.COUNT > 0) THEN

Line 3580: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) AS

3576: x_return_status OUT NOCOPY VARCHAR2,
3577: x_msg_count OUT NOCOPY NUMBER,
3578: x_msg_data OUT NOCOPY VARCHAR2,
3579: p_iehv_tbl IN iehv_tbl_type,
3580: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) AS
3581:
3582: l_api_version CONSTANT NUMBER := 1;
3583: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_delete_row';
3584: i NUMBER := 0;

Line 3592: l_error_rec OKL_API.ERROR_REC_TYPE;

3588: IF (p_iehv_tbl.COUNT > 0) THEN
3589: i := p_iehv_tbl.FIRST;
3590: LOOP
3591: DECLARE
3592: l_error_rec OKL_API.ERROR_REC_TYPE;
3593: BEGIN
3594: l_error_rec.api_name := l_api_name;
3595: l_error_rec.api_package := G_PKG_NAME;
3596: l_error_rec.idx := i;

Line 3680: l_error_tbl OKL_API.ERROR_TBL_TYPE;

3676:
3677: l_api_version CONSTANT NUMBER := 1;
3678: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
3679: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3680: l_error_tbl OKL_API.ERROR_TBL_TYPE;
3681: BEGIN
3682: OKC_API.init_msg_list(p_init_msg_list);
3683: -- Make sure PL/SQL table has records in it before passing
3684: IF (p_iehv_tbl.COUNT > 0) THEN