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_OIP_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: 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) 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: 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 AS
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 AS
43: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
44: i INTEGER := 1;
45: BEGIN

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

1047: x_return_status OUT NOCOPY VARCHAR2,
1048: x_msg_count OUT NOCOPY NUMBER,
1049: x_msg_data OUT NOCOPY VARCHAR2,
1050: p_oipv_tbl IN oipv_tbl_type,
1051: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) AS
1052: l_api_version CONSTANT NUMBER := 1;
1053: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_validate_row';
1054: i NUMBER := 0;
1055: BEGIN

Line 1062: l_error_rec OKL_API.ERROR_REC_TYPE;

1058: IF (p_oipv_tbl.COUNT > 0) THEN
1059: i := p_oipv_tbl.FIRST;
1060: LOOP
1061: DECLARE
1062: l_error_rec OKL_API.ERROR_REC_TYPE;
1063: BEGIN
1064: l_error_rec.api_name := l_api_name;
1065: l_error_rec.api_package := G_PKG_NAME;
1066: l_error_rec.idx := i;

Line 1148: l_error_tbl OKL_API.ERROR_TBL_TYPE;

1144: p_oipv_tbl IN oipv_tbl_type) AS
1145: l_api_version CONSTANT NUMBER := 1;
1146: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_validate_row';
1147: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1148: l_error_tbl OKL_API.ERROR_TBL_TYPE;
1149: BEGIN
1150: OKC_API.init_msg_list(p_init_msg_list);
1151: -- Make sure PL/SQL table has records in it before passing
1152: IF (p_oipv_tbl.COUNT > 0) THEN

Line 1443: IF (x_oipv_rec.request_id IS NULL OR x_oipv_rec.request_id = Okl_Api.G_MISS_NUM) THEN

1439: x_oipv_rec := p_oipv_rec;
1440: x_oipv_rec.OBJECT_VERSION_NUMBER := 1;
1441:
1442: -- Begin Post-Generation Change
1443: IF (x_oipv_rec.request_id IS NULL OR x_oipv_rec.request_id = Okl_Api.G_MISS_NUM) THEN
1444: SELECT
1445: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1446: DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1447: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),

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

1565: x_msg_count OUT NOCOPY NUMBER,
1566: x_msg_data OUT NOCOPY VARCHAR2,
1567: p_oipv_tbl IN oipv_tbl_type,
1568: x_oipv_tbl OUT NOCOPY oipv_tbl_type,
1569: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) AS
1570: l_api_version CONSTANT NUMBER := 1;
1571: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_insert_row';
1572: i NUMBER := 0;
1573: BEGIN

Line 1580: l_error_rec OKL_API.ERROR_REC_TYPE;

1576: IF (p_oipv_tbl.COUNT > 0) THEN
1577: i := p_oipv_tbl.FIRST;
1578: LOOP
1579: DECLARE
1580: l_error_rec OKL_API.ERROR_REC_TYPE;
1581: BEGIN
1582: l_error_rec.api_name := l_api_name;
1583: l_error_rec.api_package := G_PKG_NAME;
1584: l_error_rec.idx := i;

Line 1668: l_error_tbl OKL_API.ERROR_TBL_TYPE;

1664: x_oipv_tbl OUT NOCOPY oipv_tbl_type) AS
1665: l_api_version CONSTANT NUMBER := 1;
1666: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
1667: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1668: l_error_tbl OKL_API.ERROR_TBL_TYPE;
1669: BEGIN
1670: OKC_API.init_msg_list(p_init_msg_list);
1671: -- Make sure PL/SQL table has records in it before passing
1672: IF (p_oipv_tbl.COUNT > 0) THEN

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

1909: x_return_status OUT NOCOPY VARCHAR2,
1910: x_msg_count OUT NOCOPY NUMBER,
1911: x_msg_data OUT NOCOPY VARCHAR2,
1912: p_oipv_tbl IN oipv_tbl_type,
1913: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) AS
1914: l_api_version CONSTANT NUMBER := 1;
1915: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_lock_row';
1916: i NUMBER := 0;
1917: BEGIN

Line 1924: l_error_rec OKL_API.ERROR_REC_TYPE;

1920: IF (p_oipv_tbl.COUNT > 0) THEN
1921: i := p_oipv_tbl.FIRST;
1922: LOOP
1923: DECLARE
1924: l_error_rec OKL_API.ERROR_REC_TYPE;
1925: BEGIN
1926: l_error_rec.api_name := l_api_name;
1927: l_error_rec.api_package := G_PKG_NAME;
1928: l_error_rec.idx := i;

Line 2010: l_error_tbl OKL_API.ERROR_TBL_TYPE;

2006: p_oipv_tbl IN oipv_tbl_type) AS
2007: l_api_version CONSTANT NUMBER := 1;
2008: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_lock_row';
2009: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2010: l_error_tbl OKL_API.ERROR_TBL_TYPE;
2011: BEGIN
2012: OKC_API.init_msg_list(p_init_msg_list);
2013: -- Make sure PL/SQL table has recrods in it before passing
2014: IF (p_oipv_tbl.COUNT > 0) THEN

Line 2745: IF (x_oipv_rec.request_id IS NULL OR x_oipv_rec.request_id = Okl_Api.G_MISS_NUM) THEN

2741: BEGIN
2742: x_oipv_rec := p_oipv_rec;
2743:
2744: -- Begin Post-Generation Change
2745: IF (x_oipv_rec.request_id IS NULL OR x_oipv_rec.request_id = Okl_Api.G_MISS_NUM) THEN
2746: SELECT NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID), x_oipv_rec.request_id),
2747: NVL(DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID), x_oipv_rec.program_application_id),
2748: NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID), x_oipv_rec.program_id),
2749: DECODE(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE), NULL,x_oipv_rec.program_update_date,SYSDATE)

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

2883: x_msg_count OUT NOCOPY NUMBER,
2884: x_msg_data OUT NOCOPY VARCHAR2,
2885: p_oipv_tbl IN oipv_tbl_type,
2886: x_oipv_tbl OUT NOCOPY oipv_tbl_type,
2887: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) AS
2888: l_api_version CONSTANT NUMBER := 1;
2889: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_update_row';
2890: i NUMBER := 0;
2891: BEGIN

Line 2898: l_error_rec OKL_API.ERROR_REC_TYPE;

2894: IF (p_oipv_tbl.COUNT > 0) THEN
2895: i := p_oipv_tbl.FIRST;
2896: LOOP
2897: DECLARE
2898: l_error_rec OKL_API.ERROR_REC_TYPE;
2899: BEGIN
2900: l_error_rec.api_name := l_api_name;
2901: l_error_rec.api_package := G_PKG_NAME;
2902: l_error_rec.idx := i;

Line 2986: l_error_tbl OKL_API.ERROR_TBL_TYPE;

2982: x_oipv_tbl OUT NOCOPY oipv_tbl_type) AS
2983: l_api_version CONSTANT NUMBER := 1;
2984: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
2985: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2986: l_error_tbl OKL_API.ERROR_TBL_TYPE;
2987: BEGIN
2988: OKC_API.init_msg_list(p_init_msg_list);
2989: -- Make sure PL/SQL table has records in it before passing
2990: IF (p_oipv_tbl.COUNT > 0) THEN

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

3184: x_return_status OUT NOCOPY VARCHAR2,
3185: x_msg_count OUT NOCOPY NUMBER,
3186: x_msg_data OUT NOCOPY VARCHAR2,
3187: p_oipv_tbl IN oipv_tbl_type,
3188: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) AS
3189: l_api_version CONSTANT NUMBER := 1;
3190: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_delete_row';
3191: i NUMBER := 0;
3192: BEGIN

Line 3199: l_error_rec OKL_API.ERROR_REC_TYPE;

3195: IF (p_oipv_tbl.COUNT > 0) THEN
3196: i := p_oipv_tbl.FIRST;
3197: LOOP
3198: DECLARE
3199: l_error_rec OKL_API.ERROR_REC_TYPE;
3200: BEGIN
3201: l_error_rec.api_name := l_api_name;
3202: l_error_rec.api_package := G_PKG_NAME;
3203: l_error_rec.idx := i;

Line 3285: l_error_tbl OKL_API.ERROR_TBL_TYPE;

3281: p_oipv_tbl IN oipv_tbl_type) AS
3282: l_api_version CONSTANT NUMBER := 1;
3283: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
3284: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3285: l_error_tbl OKL_API.ERROR_TBL_TYPE;
3286: BEGIN
3287: OKC_API.init_msg_list(p_init_msg_list);
3288: -- Make sure PL/SQL table has records in it before passing
3289: IF (p_oipv_tbl.COUNT > 0) THEN