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_IRK_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 1095: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

1091: x_return_status OUT NOCOPY VARCHAR2,
1092: x_msg_count OUT NOCOPY NUMBER,
1093: x_msg_data OUT NOCOPY VARCHAR2,
1094: p_irkv_tbl IN irkv_tbl_type,
1095: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS
1096:
1097: l_api_version CONSTANT NUMBER := 1;
1098: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_validate_row';
1099: i NUMBER := 0;

Line 1107: l_error_rec OKL_API.ERROR_REC_TYPE;

1103: IF (p_irkv_tbl.COUNT > 0) THEN
1104: i := p_irkv_tbl.FIRST;
1105: LOOP
1106: DECLARE
1107: l_error_rec OKL_API.ERROR_REC_TYPE;
1108: BEGIN
1109: l_error_rec.api_name := l_api_name;
1110: l_error_rec.api_package := G_PKG_NAME;
1111: l_error_rec.idx := i;

Line 1195: l_error_tbl OKL_API.ERROR_TBL_TYPE;

1191:
1192: l_api_version CONSTANT NUMBER := 1;
1193: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_validate_row';
1194: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1195: l_error_tbl OKL_API.ERROR_TBL_TYPE;
1196: BEGIN
1197: OKC_API.init_msg_list(p_init_msg_list);
1198: -- Make sure PL/SQL table has records in it before passing
1199: IF (p_irkv_tbl.COUNT > 0) THEN

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

1540: x_msg_count OUT NOCOPY NUMBER,
1541: x_msg_data OUT NOCOPY VARCHAR2,
1542: p_irkv_tbl IN irkv_tbl_type,
1543: x_irkv_tbl OUT NOCOPY irkv_tbl_type,
1544: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS
1545:
1546: l_api_version CONSTANT NUMBER := 1;
1547: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_insert_row';
1548: i NUMBER := 0;

Line 1556: l_error_rec OKL_API.ERROR_REC_TYPE;

1552: IF (p_irkv_tbl.COUNT > 0) THEN
1553: i := p_irkv_tbl.FIRST;
1554: LOOP
1555: DECLARE
1556: l_error_rec OKL_API.ERROR_REC_TYPE;
1557: BEGIN
1558: l_error_rec.api_name := l_api_name;
1559: l_error_rec.api_package := G_PKG_NAME;
1560: l_error_rec.idx := i;

Line 1646: l_error_tbl OKL_API.ERROR_TBL_TYPE;

1642:
1643: l_api_version CONSTANT NUMBER := 1;
1644: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
1645: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1646: l_error_tbl OKL_API.ERROR_TBL_TYPE;
1647: BEGIN
1648: OKC_API.init_msg_list(p_init_msg_list);
1649: -- Make sure PL/SQL table has records in it before passing
1650: IF (p_irkv_tbl.COUNT > 0) THEN

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

1892: x_return_status OUT NOCOPY VARCHAR2,
1893: x_msg_count OUT NOCOPY NUMBER,
1894: x_msg_data OUT NOCOPY VARCHAR2,
1895: p_irkv_tbl IN irkv_tbl_type,
1896: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS
1897:
1898: l_api_version CONSTANT NUMBER := 1;
1899: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_lock_row';
1900: i NUMBER := 0;

Line 1908: l_error_rec OKL_API.ERROR_REC_TYPE;

1904: IF (p_irkv_tbl.COUNT > 0) THEN
1905: i := p_irkv_tbl.FIRST;
1906: LOOP
1907: DECLARE
1908: l_error_rec OKL_API.ERROR_REC_TYPE;
1909: BEGIN
1910: l_error_rec.api_name := l_api_name;
1911: l_error_rec.api_package := G_PKG_NAME;
1912: l_error_rec.idx := i;

Line 1995: l_error_tbl OKL_API.ERROR_TBL_TYPE;

1991:
1992: l_api_version CONSTANT NUMBER := 1;
1993: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_lock_row';
1994: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1995: l_error_tbl OKL_API.ERROR_TBL_TYPE;
1996: BEGIN
1997: OKC_API.init_msg_list(p_init_msg_list);
1998: -- Make sure PL/SQL table has recrods in it before passing
1999: IF (p_irkv_tbl.COUNT > 0) THEN

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

2596: x_msg_count OUT NOCOPY NUMBER,
2597: x_msg_data OUT NOCOPY VARCHAR2,
2598: p_irkv_tbl IN irkv_tbl_type,
2599: x_irkv_tbl OUT NOCOPY irkv_tbl_type,
2600: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS
2601:
2602: l_api_version CONSTANT NUMBER := 1;
2603: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_update_row';
2604: i NUMBER := 0;

Line 2612: l_error_rec OKL_API.ERROR_REC_TYPE;

2608: IF (p_irkv_tbl.COUNT > 0) THEN
2609: i := p_irkv_tbl.FIRST;
2610: LOOP
2611: DECLARE
2612: l_error_rec OKL_API.ERROR_REC_TYPE;
2613: BEGIN
2614: l_error_rec.api_name := l_api_name;
2615: l_error_rec.api_package := G_PKG_NAME;
2616: l_error_rec.idx := i;

Line 2702: l_error_tbl OKL_API.ERROR_TBL_TYPE;

2698:
2699: l_api_version CONSTANT NUMBER := 1;
2700: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
2701: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2702: l_error_tbl OKL_API.ERROR_TBL_TYPE;
2703: BEGIN
2704: OKC_API.init_msg_list(p_init_msg_list);
2705: -- Make sure PL/SQL table has records in it before passing
2706: IF (p_irkv_tbl.COUNT > 0) THEN

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

2905: x_return_status OUT NOCOPY VARCHAR2,
2906: x_msg_count OUT NOCOPY NUMBER,
2907: x_msg_data OUT NOCOPY VARCHAR2,
2908: p_irkv_tbl IN irkv_tbl_type,
2909: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS
2910:
2911: l_api_version CONSTANT NUMBER := 1;
2912: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_delete_row';
2913: i NUMBER := 0;

Line 2921: l_error_rec OKL_API.ERROR_REC_TYPE;

2917: IF (p_irkv_tbl.COUNT > 0) THEN
2918: i := p_irkv_tbl.FIRST;
2919: LOOP
2920: DECLARE
2921: l_error_rec OKL_API.ERROR_REC_TYPE;
2922: BEGIN
2923: l_error_rec.api_name := l_api_name;
2924: l_error_rec.api_package := G_PKG_NAME;
2925: l_error_rec.idx := i;

Line 3009: l_error_tbl OKL_API.ERROR_TBL_TYPE;

3005:
3006: l_api_version CONSTANT NUMBER := 1;
3007: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
3008: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3009: l_error_tbl OKL_API.ERROR_TBL_TYPE;
3010: BEGIN
3011: OKC_API.init_msg_list(p_init_msg_list);
3012: -- Make sure PL/SQL table has records in it before passing
3013: IF (p_irkv_tbl.COUNT > 0) THEN