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

928: x_return_status OUT NOCOPY VARCHAR2,
929: x_msg_count OUT NOCOPY NUMBER,
930: x_msg_data OUT NOCOPY VARCHAR2,
931: p_psyv_tbl IN psyv_tbl_type,
932: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS
933:
934: l_api_version CONSTANT NUMBER := 1;
935: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_validate_row';
936: i NUMBER := 0;

Line 944: l_error_rec OKL_API.ERROR_REC_TYPE;

940: IF (p_psyv_tbl.COUNT > 0) THEN
941: i := p_psyv_tbl.FIRST;
942: LOOP
943: DECLARE
944: l_error_rec OKL_API.ERROR_REC_TYPE;
945: BEGIN
946: l_error_rec.api_name := l_api_name;
947: l_error_rec.api_package := G_PKG_NAME;
948: l_error_rec.idx := i;

Line 1032: l_error_tbl OKL_API.ERROR_TBL_TYPE;

1028:
1029: l_api_version CONSTANT NUMBER := 1;
1030: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_validate_row';
1031: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1032: l_error_tbl OKL_API.ERROR_TBL_TYPE;
1033: BEGIN
1034: OKC_API.init_msg_list(p_init_msg_list);
1035: -- Make sure PL/SQL table has records in it before passing
1036: IF (p_psyv_tbl.COUNT > 0) THEN

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

1345: x_msg_count OUT NOCOPY NUMBER,
1346: x_msg_data OUT NOCOPY VARCHAR2,
1347: p_psyv_tbl IN psyv_tbl_type,
1348: x_psyv_tbl OUT NOCOPY psyv_tbl_type,
1349: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS
1350:
1351: l_api_version CONSTANT NUMBER := 1;
1352: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_insert_row';
1353: i NUMBER := 0;

Line 1361: l_error_rec OKL_API.ERROR_REC_TYPE;

1357: IF (p_psyv_tbl.COUNT > 0) THEN
1358: i := p_psyv_tbl.FIRST;
1359: LOOP
1360: DECLARE
1361: l_error_rec OKL_API.ERROR_REC_TYPE;
1362: BEGIN
1363: l_error_rec.api_name := l_api_name;
1364: l_error_rec.api_package := G_PKG_NAME;
1365: l_error_rec.idx := i;

Line 1451: l_error_tbl OKL_API.ERROR_TBL_TYPE;

1447:
1448: l_api_version CONSTANT NUMBER := 1;
1449: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
1450: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1451: l_error_tbl OKL_API.ERROR_TBL_TYPE;
1452: BEGIN
1453: OKC_API.init_msg_list(p_init_msg_list);
1454: -- Make sure PL/SQL table has records in it before passing
1455: IF (p_psyv_tbl.COUNT > 0) THEN

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

1697: x_return_status OUT NOCOPY VARCHAR2,
1698: x_msg_count OUT NOCOPY NUMBER,
1699: x_msg_data OUT NOCOPY VARCHAR2,
1700: p_psyv_tbl IN psyv_tbl_type,
1701: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS
1702:
1703: l_api_version CONSTANT NUMBER := 1;
1704: l_api_name CONSTANT VARCHAR2(30) := 'lock_row';
1705: i NUMBER := 0;

Line 1713: l_error_rec OKL_API.ERROR_REC_TYPE;

1709: IF (p_psyv_tbl.COUNT > 0) THEN
1710: i := p_psyv_tbl.FIRST;
1711: LOOP
1712: DECLARE
1713: l_error_rec OKL_API.ERROR_REC_TYPE;
1714: BEGIN
1715: l_error_rec.api_name := l_api_name;
1716: l_error_rec.api_package := G_PKG_NAME;
1717: l_error_rec.idx := i;

Line 1800: l_error_tbl OKL_API.ERROR_TBL_TYPE;

1796:
1797: l_api_version CONSTANT NUMBER := 1;
1798: l_api_name CONSTANT VARCHAR2(30) := 'lock_row';
1799: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1800: l_error_tbl OKL_API.ERROR_TBL_TYPE;
1801: BEGIN
1802: OKC_API.init_msg_list(p_init_msg_list);
1803: -- Make sure PL/SQL table has recrods in it before passing
1804: IF (p_psyv_tbl.COUNT > 0) THEN

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

2257: x_msg_count OUT NOCOPY NUMBER,
2258: x_msg_data OUT NOCOPY VARCHAR2,
2259: p_psyv_tbl IN psyv_tbl_type,
2260: x_psyv_tbl OUT NOCOPY psyv_tbl_type,
2261: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS
2262:
2263: l_api_version CONSTANT NUMBER := 1;
2264: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
2265: i NUMBER := 0;

Line 2273: l_error_rec OKL_API.ERROR_REC_TYPE;

2269: IF (p_psyv_tbl.COUNT > 0) THEN
2270: i := p_psyv_tbl.FIRST;
2271: LOOP
2272: DECLARE
2273: l_error_rec OKL_API.ERROR_REC_TYPE;
2274: BEGIN
2275: l_error_rec.api_name := l_api_name;
2276: l_error_rec.api_package := G_PKG_NAME;
2277: l_error_rec.idx := i;

Line 2363: l_error_tbl OKL_API.ERROR_TBL_TYPE;

2359:
2360: l_api_version CONSTANT NUMBER := 1;
2361: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
2362: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2363: l_error_tbl OKL_API.ERROR_TBL_TYPE;
2364: BEGIN
2365: OKC_API.init_msg_list(p_init_msg_list);
2366: -- Make sure PL/SQL table has records in it before passing
2367: IF (p_psyv_tbl.COUNT > 0) THEN

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

2566: x_return_status OUT NOCOPY VARCHAR2,
2567: x_msg_count OUT NOCOPY NUMBER,
2568: x_msg_data OUT NOCOPY VARCHAR2,
2569: p_psyv_tbl IN psyv_tbl_type,
2570: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS
2571:
2572: l_api_version CONSTANT NUMBER := 1;
2573: l_api_name CONSTANT VARCHAR2(30) := 'delete_row';
2574: i NUMBER := 0;

Line 2582: l_error_rec OKL_API.ERROR_REC_TYPE;

2578: IF (p_psyv_tbl.COUNT > 0) THEN
2579: i := p_psyv_tbl.FIRST;
2580: LOOP
2581: DECLARE
2582: l_error_rec OKL_API.ERROR_REC_TYPE;
2583: BEGIN
2584: l_error_rec.api_name := l_api_name;
2585: l_error_rec.api_package := G_PKG_NAME;
2586: l_error_rec.idx := i;

Line 2670: l_error_tbl OKL_API.ERROR_TBL_TYPE;

2666:
2667: l_api_version CONSTANT NUMBER := 1;
2668: l_api_name CONSTANT VARCHAR2(30) := 'delete_row';
2669: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2670: l_error_tbl OKL_API.ERROR_TBL_TYPE;
2671: BEGIN
2672: OKC_API.init_msg_list(p_init_msg_list);
2673: -- Make sure PL/SQL table has records in it before passing
2674: IF (p_psyv_tbl.COUNT > 0) THEN