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

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

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

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

Line 41: p_error_tbl IN OKL_API.ERROR_TBL_TYPE

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

Line 942: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

938: PROCEDURE validate_legal_entity_id (p_ipyv_rec IN ipyv_rec_type, x_return_status OUT NOCOPY VARCHAR2) IS
939: l_exists NUMBER(1);
940: le_not_found_error EXCEPTION;
941: BEGIN
942: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
943: IF (p_ipyv_rec.legal_entity_id IS NOT NULL) THEN
944: l_exists := OKL_LEGAL_ENTITY_UTIL.check_le_id_exists(p_ipyv_rec.legal_entity_id);
945: IF(l_exists <> 1) THEN
946: Okc_Api.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'LEGAL_ENTITY_ID');

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

3272: x_return_status OUT NOCOPY VARCHAR2,
3273: x_msg_count OUT NOCOPY NUMBER,
3274: x_msg_data OUT NOCOPY VARCHAR2,
3275: p_ipyv_tbl IN ipyv_tbl_type,
3276: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS
3277: l_api_version CONSTANT NUMBER := 1;
3278: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_validate_row';
3279: i NUMBER := 0;
3280: BEGIN

Line 3287: l_error_rec OKL_API.ERROR_REC_TYPE;

3283: IF (p_ipyv_tbl.COUNT > 0) THEN
3284: i := p_ipyv_tbl.FIRST;
3285: LOOP
3286: DECLARE
3287: l_error_rec OKL_API.ERROR_REC_TYPE;
3288: BEGIN
3289: l_error_rec.api_name := l_api_name;
3290: l_error_rec.api_package := G_PKG_NAME;
3291: l_error_rec.idx := i;

Line 3373: l_error_tbl OKL_API.ERROR_TBL_TYPE;

3369: p_ipyv_tbl IN ipyv_tbl_type) IS
3370: l_api_version CONSTANT NUMBER := 1;
3371: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_validate_row';
3372: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3373: l_error_tbl OKL_API.ERROR_TBL_TYPE;
3374: BEGIN
3375: OKC_API.init_msg_list(p_init_msg_list);
3376: -- Make sure PL/SQL table has records in it before passing
3377: IF (p_ipyv_tbl.COUNT > 0) THEN

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

3993: x_msg_count OUT NOCOPY NUMBER,
3994: x_msg_data OUT NOCOPY VARCHAR2,
3995: p_ipyv_tbl IN ipyv_tbl_type,
3996: x_ipyv_tbl OUT NOCOPY ipyv_tbl_type,
3997: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS
3998: l_api_version CONSTANT NUMBER := 1;
3999: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_insert_row';
4000: i NUMBER := 0;
4001: BEGIN

Line 4008: l_error_rec OKL_API.ERROR_REC_TYPE;

4004: IF (p_ipyv_tbl.COUNT > 0) THEN
4005: i := p_ipyv_tbl.FIRST;
4006: LOOP
4007: DECLARE
4008: l_error_rec OKL_API.ERROR_REC_TYPE;
4009: BEGIN
4010: l_error_rec.api_name := l_api_name;
4011: l_error_rec.api_package := G_PKG_NAME;
4012: l_error_rec.idx := i;

Line 4096: l_error_tbl OKL_API.ERROR_TBL_TYPE;

4092: x_ipyv_tbl OUT NOCOPY ipyv_tbl_type) IS
4093: l_api_version CONSTANT NUMBER := 1;
4094: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
4095: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4096: l_error_tbl OKL_API.ERROR_TBL_TYPE;
4097: BEGIN
4098: OKC_API.init_msg_list(p_init_msg_list);
4099: -- Make sure PL/SQL table has records in it before passing
4100: IF (p_ipyv_tbl.COUNT > 0) THEN

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

4434: x_return_status OUT NOCOPY VARCHAR2,
4435: x_msg_count OUT NOCOPY NUMBER,
4436: x_msg_data OUT NOCOPY VARCHAR2,
4437: p_ipyv_tbl IN ipyv_tbl_type,
4438: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS
4439: l_api_version CONSTANT NUMBER := 1;
4440: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_lock_row';
4441: i NUMBER := 0;
4442: BEGIN

Line 4449: l_error_rec OKL_API.ERROR_REC_TYPE;

4445: IF (p_ipyv_tbl.COUNT > 0) THEN
4446: i := p_ipyv_tbl.FIRST;
4447: LOOP
4448: DECLARE
4449: l_error_rec OKL_API.ERROR_REC_TYPE;
4450: BEGIN
4451: l_error_rec.api_name := l_api_name;
4452: l_error_rec.api_package := G_PKG_NAME;
4453: l_error_rec.idx := i;

Line 4535: l_error_tbl OKL_API.ERROR_TBL_TYPE;

4531: p_ipyv_tbl IN ipyv_tbl_type) IS
4532: l_api_version CONSTANT NUMBER := 1;
4533: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_lock_row';
4534: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4535: l_error_tbl OKL_API.ERROR_TBL_TYPE;
4536: BEGIN
4537: OKC_API.init_msg_list(p_init_msg_list);
4538: -- Make sure PL/SQL table has recrods in it before passing
4539: IF (p_ipyv_tbl.COUNT > 0) THEN

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

5760: x_msg_count OUT NOCOPY NUMBER,
5761: x_msg_data OUT NOCOPY VARCHAR2,
5762: p_ipyv_tbl IN ipyv_tbl_type,
5763: x_ipyv_tbl OUT NOCOPY ipyv_tbl_type,
5764: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS
5765: l_api_version CONSTANT NUMBER := 1;
5766: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_update_row';
5767: i NUMBER := 0;
5768: BEGIN

Line 5775: l_error_rec OKL_API.ERROR_REC_TYPE;

5771: IF (p_ipyv_tbl.COUNT > 0) THEN
5772: i := p_ipyv_tbl.FIRST;
5773: LOOP
5774: DECLARE
5775: l_error_rec OKL_API.ERROR_REC_TYPE;
5776: BEGIN
5777: l_error_rec.api_name := l_api_name;
5778: l_error_rec.api_package := G_PKG_NAME;
5779: l_error_rec.idx := i;

Line 5863: l_error_tbl OKL_API.ERROR_TBL_TYPE;

5859: x_ipyv_tbl OUT NOCOPY ipyv_tbl_type) IS
5860: l_api_version CONSTANT NUMBER := 1;
5861: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
5862: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
5863: l_error_tbl OKL_API.ERROR_TBL_TYPE;
5864: BEGIN
5865: OKC_API.init_msg_list(p_init_msg_list);
5866: -- Make sure PL/SQL table has records in it before passing
5867: IF (p_ipyv_tbl.COUNT > 0) THEN

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

6135: x_return_status OUT NOCOPY VARCHAR2,
6136: x_msg_count OUT NOCOPY NUMBER,
6137: x_msg_data OUT NOCOPY VARCHAR2,
6138: p_ipyv_tbl IN ipyv_tbl_type,
6139: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS
6140: l_api_version CONSTANT NUMBER := 1;
6141: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_delete_row';
6142: i NUMBER := 0;
6143: BEGIN

Line 6150: l_error_rec OKL_API.ERROR_REC_TYPE;

6146: IF (p_ipyv_tbl.COUNT > 0) THEN
6147: i := p_ipyv_tbl.FIRST;
6148: LOOP
6149: DECLARE
6150: l_error_rec OKL_API.ERROR_REC_TYPE;
6151: BEGIN
6152: l_error_rec.api_name := l_api_name;
6153: l_error_rec.api_package := G_PKG_NAME;
6154: l_error_rec.idx := i;

Line 6236: l_error_tbl OKL_API.ERROR_TBL_TYPE;

6232: p_ipyv_tbl IN ipyv_tbl_type) IS
6233: l_api_version CONSTANT NUMBER := 1;
6234: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
6235: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
6236: l_error_tbl OKL_API.ERROR_TBL_TYPE;
6237: BEGIN
6238: OKC_API.init_msg_list(p_init_msg_list);
6239: -- Make sure PL/SQL table has records in it before passing
6240: IF (p_ipyv_tbl.COUNT > 0) THEN