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_OIN_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 1532: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) AS

1528: x_return_status OUT NOCOPY VARCHAR2,
1529: x_msg_count OUT NOCOPY NUMBER,
1530: x_msg_data OUT NOCOPY VARCHAR2,
1531: p_oinv_tbl IN oinv_tbl_type,
1532: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) AS
1533:
1534: l_api_version CONSTANT NUMBER := 1;
1535: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_validate_row';
1536: i NUMBER := 0;

Line 1544: l_error_rec OKL_API.ERROR_REC_TYPE;

1540: IF (p_oinv_tbl.COUNT > 0) THEN
1541: i := p_oinv_tbl.FIRST;
1542: LOOP
1543: DECLARE
1544: l_error_rec OKL_API.ERROR_REC_TYPE;
1545: BEGIN
1546: l_error_rec.api_name := l_api_name;
1547: l_error_rec.api_package := G_PKG_NAME;
1548: l_error_rec.idx := i;

Line 1632: l_error_tbl OKL_API.ERROR_TBL_TYPE;

1628:
1629: l_api_version CONSTANT NUMBER := 1;
1630: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_validate_row';
1631: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1632: l_error_tbl OKL_API.ERROR_TBL_TYPE;
1633: BEGIN
1634: OKC_API.init_msg_list(p_init_msg_list);
1635: -- Make sure PL/SQL table has records in it before passing
1636: IF (p_oinv_tbl.COUNT > 0) THEN

Line 1980: IF (x_oinv_rec.request_id IS NULL OR x_oinv_rec.request_id = Okl_Api.G_MISS_NUM) THEN

1976: x_oinv_rec := p_oinv_rec;
1977: x_oinv_rec.OBJECT_VERSION_NUMBER := 1;
1978:
1979: -- Begin Post-Generation Change
1980: IF (x_oinv_rec.request_id IS NULL OR x_oinv_rec.request_id = Okl_Api.G_MISS_NUM) THEN
1981: SELECT
1982: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1983: DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1984: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),

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

2102: x_msg_count OUT NOCOPY NUMBER,
2103: x_msg_data OUT NOCOPY VARCHAR2,
2104: p_oinv_tbl IN oinv_tbl_type,
2105: x_oinv_tbl OUT NOCOPY oinv_tbl_type,
2106: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) AS
2107:
2108: l_api_version CONSTANT NUMBER := 1;
2109: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_insert_row';
2110: i NUMBER := 0;

Line 2118: l_error_rec OKL_API.ERROR_REC_TYPE;

2114: IF (p_oinv_tbl.COUNT > 0) THEN
2115: i := p_oinv_tbl.FIRST;
2116: LOOP
2117: DECLARE
2118: l_error_rec OKL_API.ERROR_REC_TYPE;
2119: BEGIN
2120: l_error_rec.api_name := l_api_name;
2121: l_error_rec.api_package := G_PKG_NAME;
2122: l_error_rec.idx := i;

Line 2208: l_error_tbl OKL_API.ERROR_TBL_TYPE;

2204:
2205: l_api_version CONSTANT NUMBER := 1;
2206: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
2207: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2208: l_error_tbl OKL_API.ERROR_TBL_TYPE;
2209: BEGIN
2210: OKC_API.init_msg_list(p_init_msg_list);
2211: -- Make sure PL/SQL table has records in it before passing
2212: IF (p_oinv_tbl.COUNT > 0) THEN

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

2454: x_return_status OUT NOCOPY VARCHAR2,
2455: x_msg_count OUT NOCOPY NUMBER,
2456: x_msg_data OUT NOCOPY VARCHAR2,
2457: p_oinv_tbl IN oinv_tbl_type,
2458: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) AS
2459:
2460: l_api_version CONSTANT NUMBER := 1;
2461: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_lock_row';
2462: i NUMBER := 0;

Line 2470: l_error_rec OKL_API.ERROR_REC_TYPE;

2466: IF (p_oinv_tbl.COUNT > 0) THEN
2467: i := p_oinv_tbl.FIRST;
2468: LOOP
2469: DECLARE
2470: l_error_rec OKL_API.ERROR_REC_TYPE;
2471: BEGIN
2472: l_error_rec.api_name := l_api_name;
2473: l_error_rec.api_package := G_PKG_NAME;
2474: l_error_rec.idx := i;

Line 2557: l_error_tbl OKL_API.ERROR_TBL_TYPE;

2553:
2554: l_api_version CONSTANT NUMBER := 1;
2555: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_lock_row';
2556: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2557: l_error_tbl OKL_API.ERROR_TBL_TYPE;
2558: BEGIN
2559: OKC_API.init_msg_list(p_init_msg_list);
2560: -- Make sure PL/SQL table has recrods in it before passing
2561: IF (p_oinv_tbl.COUNT > 0) THEN

Line 3520: IF (x_oinv_rec.request_id IS NULL OR x_oinv_rec.request_id = Okl_Api.G_MISS_NUM) THEN

3516: BEGIN
3517: x_oinv_rec := p_oinv_rec;
3518:
3519: -- Begin Post-Generation Change
3520: IF (x_oinv_rec.request_id IS NULL OR x_oinv_rec.request_id = Okl_Api.G_MISS_NUM) THEN
3521: SELECT NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID), x_oinv_rec.request_id),
3522: NVL(DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID), x_oinv_rec.program_application_id),
3523: NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID), x_oinv_rec.program_id),
3524: DECODE(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE), NULL,x_oinv_rec.program_update_date,SYSDATE)

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

3660: x_msg_count OUT NOCOPY NUMBER,
3661: x_msg_data OUT NOCOPY VARCHAR2,
3662: p_oinv_tbl IN oinv_tbl_type,
3663: x_oinv_tbl OUT NOCOPY oinv_tbl_type,
3664: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) AS
3665:
3666: l_api_version CONSTANT NUMBER := 1;
3667: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_update_row';
3668: i NUMBER := 0;

Line 3676: l_error_rec OKL_API.ERROR_REC_TYPE;

3672: IF (p_oinv_tbl.COUNT > 0) THEN
3673: i := p_oinv_tbl.FIRST;
3674: LOOP
3675: DECLARE
3676: l_error_rec OKL_API.ERROR_REC_TYPE;
3677: BEGIN
3678: l_error_rec.api_name := l_api_name;
3679: l_error_rec.api_package := G_PKG_NAME;
3680: l_error_rec.idx := i;

Line 3766: l_error_tbl OKL_API.ERROR_TBL_TYPE;

3762:
3763: l_api_version CONSTANT NUMBER := 1;
3764: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
3765: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3766: l_error_tbl OKL_API.ERROR_TBL_TYPE;
3767: BEGIN
3768: OKC_API.init_msg_list(p_init_msg_list);
3769: -- Make sure PL/SQL table has records in it before passing
3770: IF (p_oinv_tbl.COUNT > 0) THEN

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

3969: x_return_status OUT NOCOPY VARCHAR2,
3970: x_msg_count OUT NOCOPY NUMBER,
3971: x_msg_data OUT NOCOPY VARCHAR2,
3972: p_oinv_tbl IN oinv_tbl_type,
3973: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) AS
3974:
3975: l_api_version CONSTANT NUMBER := 1;
3976: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_delete_row';
3977: i NUMBER := 0;

Line 3985: l_error_rec OKL_API.ERROR_REC_TYPE;

3981: IF (p_oinv_tbl.COUNT > 0) THEN
3982: i := p_oinv_tbl.FIRST;
3983: LOOP
3984: DECLARE
3985: l_error_rec OKL_API.ERROR_REC_TYPE;
3986: BEGIN
3987: l_error_rec.api_name := l_api_name;
3988: l_error_rec.api_package := G_PKG_NAME;
3989: l_error_rec.idx := i;

Line 4073: l_error_tbl OKL_API.ERROR_TBL_TYPE;

4069:
4070: l_api_version CONSTANT NUMBER := 1;
4071: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
4072: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4073: l_error_tbl OKL_API.ERROR_TBL_TYPE;
4074: BEGIN
4075: OKC_API.init_msg_list(p_init_msg_list);
4076: -- Make sure PL/SQL table has records in it before passing
4077: IF (p_oinv_tbl.COUNT > 0) THEN