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_INA_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:
10: j INTEGER := NVL(px_error_tbl.LAST, 0) + 1;
11: last_msg_idx INTEGER := FND_MSG_PUB.COUNT_MSG;

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:
10: j INTEGER := NVL(px_error_tbl.LAST, 0) + 1;
11: last_msg_idx INTEGER := FND_MSG_PUB.COUNT_MSG;
12: l_msg_idx INTEGER := FND_MSG_PUB.G_NEXT;

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

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

Line 42: p_error_tbl IN OKL_API.ERROR_TBL_TYPE

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

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

1113: x_return_status OUT NOCOPY VARCHAR2,
1114: x_msg_count OUT NOCOPY NUMBER,
1115: x_msg_data OUT NOCOPY VARCHAR2,
1116: p_inav_tbl IN inav_tbl_type,
1117: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS
1118:
1119: l_api_version CONSTANT NUMBER := 1;
1120: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_validate_row';
1121: i NUMBER := 0;

Line 1129: l_error_rec OKL_API.ERROR_REC_TYPE;

1125: IF (p_inav_tbl.COUNT > 0) THEN
1126: i := p_inav_tbl.FIRST;
1127: LOOP
1128: DECLARE
1129: l_error_rec OKL_API.ERROR_REC_TYPE;
1130: BEGIN
1131: l_error_rec.api_name := l_api_name;
1132: l_error_rec.api_package := G_PKG_NAME;
1133: l_error_rec.idx := i;

Line 1217: l_error_tbl OKL_API.ERROR_TBL_TYPE;

1213:
1214: l_api_version CONSTANT NUMBER := 1;
1215: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_validate_row';
1216: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1217: l_error_tbl OKL_API.ERROR_TBL_TYPE;
1218: BEGIN
1219: OKC_API.init_msg_list(p_init_msg_list);
1220: -- Make sure PL/SQL table has records in it before passing
1221: IF (p_inav_tbl.COUNT > 0) THEN

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

1587: x_msg_count OUT NOCOPY NUMBER,
1588: x_msg_data OUT NOCOPY VARCHAR2,
1589: p_inav_tbl IN inav_tbl_type,
1590: x_inav_tbl OUT NOCOPY inav_tbl_type,
1591: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS
1592:
1593: l_api_version CONSTANT NUMBER := 1;
1594: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_insert_row';
1595: i NUMBER := 0;

Line 1603: l_error_rec OKL_API.ERROR_REC_TYPE;

1599: IF (p_inav_tbl.COUNT > 0) THEN
1600: i := p_inav_tbl.FIRST;
1601: LOOP
1602: DECLARE
1603: l_error_rec OKL_API.ERROR_REC_TYPE;
1604: BEGIN
1605: l_error_rec.api_name := l_api_name;
1606: l_error_rec.api_package := G_PKG_NAME;
1607: l_error_rec.idx := i;

Line 1693: l_error_tbl OKL_API.ERROR_TBL_TYPE;

1689:
1690: l_api_version CONSTANT NUMBER := 1;
1691: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
1692: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1693: l_error_tbl OKL_API.ERROR_TBL_TYPE;
1694: BEGIN
1695: OKC_API.init_msg_list(p_init_msg_list);
1696: -- Make sure PL/SQL table has records in it before passing
1697: IF (p_inav_tbl.COUNT > 0) THEN

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

1939: x_return_status OUT NOCOPY VARCHAR2,
1940: x_msg_count OUT NOCOPY NUMBER,
1941: x_msg_data OUT NOCOPY VARCHAR2,
1942: p_inav_tbl IN inav_tbl_type,
1943: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS
1944:
1945: l_api_version CONSTANT NUMBER := 1;
1946: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_lock_row';
1947: i NUMBER := 0;

Line 1955: l_error_rec OKL_API.ERROR_REC_TYPE;

1951: IF (p_inav_tbl.COUNT > 0) THEN
1952: i := p_inav_tbl.FIRST;
1953: LOOP
1954: DECLARE
1955: l_error_rec OKL_API.ERROR_REC_TYPE;
1956: BEGIN
1957: l_error_rec.api_name := l_api_name;
1958: l_error_rec.api_package := G_PKG_NAME;
1959: l_error_rec.idx := i;

Line 2042: l_error_tbl OKL_API.ERROR_TBL_TYPE;

2038:
2039: l_api_version CONSTANT NUMBER := 1;
2040: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_lock_row';
2041: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2042: l_error_tbl OKL_API.ERROR_TBL_TYPE;
2043: BEGIN
2044: OKC_API.init_msg_list(p_init_msg_list);
2045: -- Make sure PL/SQL table has recrods in it before passing
2046: IF (p_inav_tbl.COUNT > 0) THEN

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

2694: x_msg_count OUT NOCOPY NUMBER,
2695: x_msg_data OUT NOCOPY VARCHAR2,
2696: p_inav_tbl IN inav_tbl_type,
2697: x_inav_tbl OUT NOCOPY inav_tbl_type,
2698: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS
2699:
2700: l_api_version CONSTANT NUMBER := 1;
2701: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_update_row';
2702: i NUMBER := 0;

Line 2710: l_error_rec OKL_API.ERROR_REC_TYPE;

2706: IF (p_inav_tbl.COUNT > 0) THEN
2707: i := p_inav_tbl.FIRST;
2708: LOOP
2709: DECLARE
2710: l_error_rec OKL_API.ERROR_REC_TYPE;
2711: BEGIN
2712: l_error_rec.api_name := l_api_name;
2713: l_error_rec.api_package := G_PKG_NAME;
2714: l_error_rec.idx := i;

Line 2800: l_error_tbl OKL_API.ERROR_TBL_TYPE;

2796:
2797: l_api_version CONSTANT NUMBER := 1;
2798: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
2799: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2800: l_error_tbl OKL_API.ERROR_TBL_TYPE;
2801: BEGIN
2802: OKC_API.init_msg_list(p_init_msg_list);
2803: -- Make sure PL/SQL table has records in it before passing
2804: IF (p_inav_tbl.COUNT > 0) THEN

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

3003: x_return_status OUT NOCOPY VARCHAR2,
3004: x_msg_count OUT NOCOPY NUMBER,
3005: x_msg_data OUT NOCOPY VARCHAR2,
3006: p_inav_tbl IN inav_tbl_type,
3007: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS
3008:
3009: l_api_version CONSTANT NUMBER := 1;
3010: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_delete_row';
3011: i NUMBER := 0;

Line 3019: l_error_rec OKL_API.ERROR_REC_TYPE;

3015: IF (p_inav_tbl.COUNT > 0) THEN
3016: i := p_inav_tbl.FIRST;
3017: LOOP
3018: DECLARE
3019: l_error_rec OKL_API.ERROR_REC_TYPE;
3020: BEGIN
3021: l_error_rec.api_name := l_api_name;
3022: l_error_rec.api_package := G_PKG_NAME;
3023: l_error_rec.idx := i;

Line 3107: l_error_tbl OKL_API.ERROR_TBL_TYPE;

3103:
3104: l_api_version CONSTANT NUMBER := 1;
3105: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
3106: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3107: l_error_tbl OKL_API.ERROR_TBL_TYPE;
3108: BEGIN
3109: OKC_API.init_msg_list(p_init_msg_list);
3110: -- Make sure PL/SQL table has records in it before passing
3111: IF (p_inav_tbl.COUNT > 0) THEN