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_OIA_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) AS
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) AS

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) AS
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 AS
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 AS
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) AS

1113: x_return_status OUT NOCOPY VARCHAR2,
1114: x_msg_count OUT NOCOPY NUMBER,
1115: x_msg_data OUT NOCOPY VARCHAR2,
1116: p_oiav_tbl IN oiav_tbl_type,
1117: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) AS
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_oiav_tbl.COUNT > 0) THEN
1126: i := p_oiav_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_oiav_tbl.COUNT > 0) THEN

Line 1525: IF (x_oiav_rec.request_id IS NULL OR x_oiav_rec.request_id = Okl_Api.G_MISS_NUM) THEN

1521: x_oiav_rec := p_oiav_rec;
1522: x_oiav_rec.OBJECT_VERSION_NUMBER := 1;
1523:
1524: -- Begin Post-Generation Change
1525: IF (x_oiav_rec.request_id IS NULL OR x_oiav_rec.request_id = Okl_Api.G_MISS_NUM) THEN
1526: SELECT
1527: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1528: DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1529: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),

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

1647: x_msg_count OUT NOCOPY NUMBER,
1648: x_msg_data OUT NOCOPY VARCHAR2,
1649: p_oiav_tbl IN oiav_tbl_type,
1650: x_oiav_tbl OUT NOCOPY oiav_tbl_type,
1651: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) AS
1652:
1653: l_api_version CONSTANT NUMBER := 1;
1654: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_insert_row';
1655: i NUMBER := 0;

Line 1663: l_error_rec OKL_API.ERROR_REC_TYPE;

1659: IF (p_oiav_tbl.COUNT > 0) THEN
1660: i := p_oiav_tbl.FIRST;
1661: LOOP
1662: DECLARE
1663: l_error_rec OKL_API.ERROR_REC_TYPE;
1664: BEGIN
1665: l_error_rec.api_name := l_api_name;
1666: l_error_rec.api_package := G_PKG_NAME;
1667: l_error_rec.idx := i;

Line 1753: l_error_tbl OKL_API.ERROR_TBL_TYPE;

1749:
1750: l_api_version CONSTANT NUMBER := 1;
1751: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
1752: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1753: l_error_tbl OKL_API.ERROR_TBL_TYPE;
1754: BEGIN
1755: OKC_API.init_msg_list(p_init_msg_list);
1756: -- Make sure PL/SQL table has records in it before passing
1757: IF (p_oiav_tbl.COUNT > 0) THEN

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

1999: x_return_status OUT NOCOPY VARCHAR2,
2000: x_msg_count OUT NOCOPY NUMBER,
2001: x_msg_data OUT NOCOPY VARCHAR2,
2002: p_oiav_tbl IN oiav_tbl_type,
2003: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) AS
2004:
2005: l_api_version CONSTANT NUMBER := 1;
2006: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_lock_row';
2007: i NUMBER := 0;

Line 2015: l_error_rec OKL_API.ERROR_REC_TYPE;

2011: IF (p_oiav_tbl.COUNT > 0) THEN
2012: i := p_oiav_tbl.FIRST;
2013: LOOP
2014: DECLARE
2015: l_error_rec OKL_API.ERROR_REC_TYPE;
2016: BEGIN
2017: l_error_rec.api_name := l_api_name;
2018: l_error_rec.api_package := G_PKG_NAME;
2019: l_error_rec.idx := i;

Line 2102: l_error_tbl OKL_API.ERROR_TBL_TYPE;

2098:
2099: l_api_version CONSTANT NUMBER := 1;
2100: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_lock_row';
2101: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2102: l_error_tbl OKL_API.ERROR_TBL_TYPE;
2103: BEGIN
2104: OKC_API.init_msg_list(p_init_msg_list);
2105: -- Make sure PL/SQL table has recrods in it before passing
2106: IF (p_oiav_tbl.COUNT > 0) THEN

Line 2885: IF (x_oiav_rec.request_id IS NULL OR x_oiav_rec.request_id = Okl_Api.G_MISS_NUM) THEN

2881: BEGIN
2882: x_oiav_rec := p_oiav_rec;
2883:
2884: -- Begin Post-Generation Change
2885: IF (x_oiav_rec.request_id IS NULL OR x_oiav_rec.request_id = Okl_Api.G_MISS_NUM) THEN
2886: SELECT NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID), x_oiav_rec.request_id),
2887: NVL(DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID), x_oiav_rec.program_application_id),
2888: NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID), x_oiav_rec.program_id),
2889: DECODE(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE), NULL,x_oiav_rec.program_update_date,SYSDATE)

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

3025: x_msg_count OUT NOCOPY NUMBER,
3026: x_msg_data OUT NOCOPY VARCHAR2,
3027: p_oiav_tbl IN oiav_tbl_type,
3028: x_oiav_tbl OUT NOCOPY oiav_tbl_type,
3029: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) AS
3030:
3031: l_api_version CONSTANT NUMBER := 1;
3032: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_update_row';
3033: i NUMBER := 0;

Line 3041: l_error_rec OKL_API.ERROR_REC_TYPE;

3037: IF (p_oiav_tbl.COUNT > 0) THEN
3038: i := p_oiav_tbl.FIRST;
3039: LOOP
3040: DECLARE
3041: l_error_rec OKL_API.ERROR_REC_TYPE;
3042: BEGIN
3043: l_error_rec.api_name := l_api_name;
3044: l_error_rec.api_package := G_PKG_NAME;
3045: l_error_rec.idx := i;

Line 3131: l_error_tbl OKL_API.ERROR_TBL_TYPE;

3127:
3128: l_api_version CONSTANT NUMBER := 1;
3129: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
3130: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3131: l_error_tbl OKL_API.ERROR_TBL_TYPE;
3132: BEGIN
3133: OKC_API.init_msg_list(p_init_msg_list);
3134: -- Make sure PL/SQL table has records in it before passing
3135: IF (p_oiav_tbl.COUNT > 0) THEN

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

3334: x_return_status OUT NOCOPY VARCHAR2,
3335: x_msg_count OUT NOCOPY NUMBER,
3336: x_msg_data OUT NOCOPY VARCHAR2,
3337: p_oiav_tbl IN oiav_tbl_type,
3338: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) AS
3339:
3340: l_api_version CONSTANT NUMBER := 1;
3341: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_delete_row';
3342: i NUMBER := 0;

Line 3350: l_error_rec OKL_API.ERROR_REC_TYPE;

3346: IF (p_oiav_tbl.COUNT > 0) THEN
3347: i := p_oiav_tbl.FIRST;
3348: LOOP
3349: DECLARE
3350: l_error_rec OKL_API.ERROR_REC_TYPE;
3351: BEGIN
3352: l_error_rec.api_name := l_api_name;
3353: l_error_rec.api_package := G_PKG_NAME;
3354: l_error_rec.idx := i;

Line 3438: l_error_tbl OKL_API.ERROR_TBL_TYPE;

3434:
3435: l_api_version CONSTANT NUMBER := 1;
3436: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
3437: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3438: l_error_tbl OKL_API.ERROR_TBL_TYPE;
3439: BEGIN
3440: OKC_API.init_msg_list(p_init_msg_list);
3441: -- Make sure PL/SQL table has records in it before passing
3442: IF (p_oiav_tbl.COUNT > 0) THEN