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_SUB_PVT dependencies on OKL_SUBSIDIES_B

Line 426: -- FUNCTION get_rec for: OKL_SUBSIDIES_B

422: BEGIN
423: RETURN(get_rec(p_subt_rec, l_row_not_found));
424: END get_rec;
425: ---------------------------------------------------------------------------
426: -- FUNCTION get_rec for: OKL_SUBSIDIES_B
427: ---------------------------------------------------------------------------
428: FUNCTION get_rec (
429: p_subb_rec IN subb_rec_type,
430: x_no_data_found OUT NOCOPY BOOLEAN

Line 432: CURSOR okl_subsidies_b_pk_csr (p_id IN NUMBER) IS

428: FUNCTION get_rec (
429: p_subb_rec IN subb_rec_type,
430: x_no_data_found OUT NOCOPY BOOLEAN
431: ) RETURN subb_rec_type IS
432: CURSOR okl_subsidies_b_pk_csr (p_id IN NUMBER) IS
433: SELECT
434: ID,
435: OBJECT_VERSION_NUMBER,
436: ORG_ID,

Line 487: FROM Okl_Subsidies_B

483: LAST_UPDATE_LOGIN,
484: -- sjalasut added new column for subsidy pools enhancement. start
485: SUBSIDY_POOL_ID
486: -- sjalasut added new column for subsidy pools enhancement. end
487: FROM Okl_Subsidies_B
488: WHERE okl_subsidies_b.id = p_id;
489: l_okl_subsidies_b_pk okl_subsidies_b_pk_csr%ROWTYPE;
490: l_subb_rec subb_rec_type;
491: BEGIN

Line 488: WHERE okl_subsidies_b.id = p_id;

484: -- sjalasut added new column for subsidy pools enhancement. start
485: SUBSIDY_POOL_ID
486: -- sjalasut added new column for subsidy pools enhancement. end
487: FROM Okl_Subsidies_B
488: WHERE okl_subsidies_b.id = p_id;
489: l_okl_subsidies_b_pk okl_subsidies_b_pk_csr%ROWTYPE;
490: l_subb_rec subb_rec_type;
491: BEGIN
492: x_no_data_found := TRUE;

Line 489: l_okl_subsidies_b_pk okl_subsidies_b_pk_csr%ROWTYPE;

485: SUBSIDY_POOL_ID
486: -- sjalasut added new column for subsidy pools enhancement. end
487: FROM Okl_Subsidies_B
488: WHERE okl_subsidies_b.id = p_id;
489: l_okl_subsidies_b_pk okl_subsidies_b_pk_csr%ROWTYPE;
490: l_subb_rec subb_rec_type;
491: BEGIN
492: x_no_data_found := TRUE;
493: -- Get current database values

Line 494: OPEN okl_subsidies_b_pk_csr (p_subb_rec.id);

490: l_subb_rec subb_rec_type;
491: BEGIN
492: x_no_data_found := TRUE;
493: -- Get current database values
494: OPEN okl_subsidies_b_pk_csr (p_subb_rec.id);
495: FETCH okl_subsidies_b_pk_csr INTO
496: l_subb_rec.id,
497: l_subb_rec.object_version_number,
498: l_subb_rec.org_id,

Line 495: FETCH okl_subsidies_b_pk_csr INTO

491: BEGIN
492: x_no_data_found := TRUE;
493: -- Get current database values
494: OPEN okl_subsidies_b_pk_csr (p_subb_rec.id);
495: FETCH okl_subsidies_b_pk_csr INTO
496: l_subb_rec.id,
497: l_subb_rec.object_version_number,
498: l_subb_rec.org_id,
499: l_subb_rec.name,

Line 549: x_no_data_found := okl_subsidies_b_pk_csr%NOTFOUND;

545: l_subb_rec.last_update_login,
546: -- sjalasut added new column for subsidy pools enhancement. start
547: l_subb_rec.subsidy_pool_id;
548: -- sjalasut added new column for subsidy pools enhancement. end
549: x_no_data_found := okl_subsidies_b_pk_csr%NOTFOUND;
550: CLOSE okl_subsidies_b_pk_csr;
551: RETURN(l_subb_rec);
552: END get_rec;
553:

Line 550: CLOSE okl_subsidies_b_pk_csr;

546: -- sjalasut added new column for subsidy pools enhancement. start
547: l_subb_rec.subsidy_pool_id;
548: -- sjalasut added new column for subsidy pools enhancement. end
549: x_no_data_found := okl_subsidies_b_pk_csr%NOTFOUND;
550: CLOSE okl_subsidies_b_pk_csr;
551: RETURN(l_subb_rec);
552: END get_rec;
553:
554: ------------------------------------------------------------------

Line 925: from okl_subsidies_b sub

921: p_id IN NUMBER) IS
922:
923: cursor c_record_exists is
924: select 1
925: from okl_subsidies_b sub
926: where sub.id = p_id
927: -- abindal start bug# 4873705 --
928: and sub.org_id = mo_global.get_current_org_id();
929: -- abindal end bug# 4873705 --

Line 933: from okl_subsidies_b sub

929: -- abindal end bug# 4873705 --
930:
931: cursor c_unique_insert is
932: select 1
933: from okl_subsidies_b sub
934: where sub.name = p_name
935: -- abindal start bug# 4873705 --
936: and sub.org_id = mo_global.get_current_org_id();
937: -- abindal end bug# 4873705 --

Line 941: from okl_subsidies_b sub

937: -- abindal end bug# 4873705 --
938:
939: cursor c_unique_update is
940: select 1
941: from okl_subsidies_b sub
942: where sub.id <> p_id
943: and sub.name = p_name
944: -- abindal start bug# 4873705 --
945: and sub.org_id = mo_global.get_current_org_id();

Line 2855: -- insert_row for:OKL_SUBSIDIES_B --

2851: ---------------------------------------------------------------------------
2852: -- PROCEDURE insert_row
2853: ---------------------------------------------------------------------------
2854: ------------------------------------
2855: -- insert_row for:OKL_SUBSIDIES_B --
2856: ------------------------------------
2857: PROCEDURE insert_row(
2858: p_init_msg_list IN VARCHAR2,
2859: x_return_status OUT NOCOPY VARCHAR2,

Line 2871: -- Set_Attributes for:OKL_SUBSIDIES_B --

2867: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2868: l_subb_rec subb_rec_type := p_subb_rec;
2869: l_def_subb_rec subb_rec_type;
2870: ----------------------------------------
2871: -- Set_Attributes for:OKL_SUBSIDIES_B --
2872: ----------------------------------------
2873: FUNCTION Set_Attributes (
2874: p_subb_rec IN subb_rec_type,
2875: x_subb_rec OUT NOCOPY subb_rec_type

Line 2902: INSERT INTO OKL_SUBSIDIES_B(

2898: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2899: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2900: RAISE OKL_API.G_EXCEPTION_ERROR;
2901: END IF;
2902: INSERT INTO OKL_SUBSIDIES_B(
2903: id,
2904: object_version_number,
2905: org_id,
2906: name,

Line 3496: -- lock_row for:OKL_SUBSIDIES_B --

3492: ---------------------------------------------------------------------------
3493: -- PROCEDURE lock_row
3494: ---------------------------------------------------------------------------
3495: ----------------------------------
3496: -- lock_row for:OKL_SUBSIDIES_B --
3497: ----------------------------------
3498: PROCEDURE lock_row(
3499: p_init_msg_list IN VARCHAR2,
3500: x_return_status OUT NOCOPY VARCHAR2,

Line 3509: FROM OKL_SUBSIDIES_B

3505: E_Resource_Busy EXCEPTION;
3506: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
3507: CURSOR lock_csr (p_subb_rec IN subb_rec_type) IS
3508: SELECT OBJECT_VERSION_NUMBER
3509: FROM OKL_SUBSIDIES_B
3510: WHERE ID = p_subb_rec.id
3511: AND OBJECT_VERSION_NUMBER = p_subb_rec.object_version_number
3512: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
3513:

Line 3516: FROM OKL_SUBSIDIES_B

3512: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
3513:
3514: CURSOR lchk_csr (p_subb_rec IN subb_rec_type) IS
3515: SELECT OBJECT_VERSION_NUMBER
3516: FROM OKL_SUBSIDIES_B
3517: WHERE ID = p_subb_rec.id;
3518: l_api_version CONSTANT NUMBER := 1;
3519: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
3520: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 3521: l_object_version_number OKL_SUBSIDIES_B.OBJECT_VERSION_NUMBER%TYPE;

3517: WHERE ID = p_subb_rec.id;
3518: l_api_version CONSTANT NUMBER := 1;
3519: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
3520: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3521: l_object_version_number OKL_SUBSIDIES_B.OBJECT_VERSION_NUMBER%TYPE;
3522: lc_object_version_number OKL_SUBSIDIES_B.OBJECT_VERSION_NUMBER%TYPE;
3523: l_row_notfound BOOLEAN := FALSE;
3524: lc_row_notfound BOOLEAN := FALSE;
3525: BEGIN

Line 3522: lc_object_version_number OKL_SUBSIDIES_B.OBJECT_VERSION_NUMBER%TYPE;

3518: l_api_version CONSTANT NUMBER := 1;
3519: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
3520: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3521: l_object_version_number OKL_SUBSIDIES_B.OBJECT_VERSION_NUMBER%TYPE;
3522: lc_object_version_number OKL_SUBSIDIES_B.OBJECT_VERSION_NUMBER%TYPE;
3523: l_row_notfound BOOLEAN := FALSE;
3524: lc_row_notfound BOOLEAN := FALSE;
3525: BEGIN
3526: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

Line 3943: -- update_row for:OKL_SUBSIDIES_B --

3939: ---------------------------------------------------------------------------
3940: -- PROCEDURE update_row
3941: ---------------------------------------------------------------------------
3942: ------------------------------------
3943: -- update_row for:OKL_SUBSIDIES_B --
3944: ------------------------------------
3945: PROCEDURE update_row(
3946: p_init_msg_list IN VARCHAR2,
3947: x_return_status OUT NOCOPY VARCHAR2,

Line 4178: -- Set_Attributes for:OKL_SUBSIDIES_B --

4174: END IF;
4175: RETURN(l_return_status);
4176: END populate_new_record;
4177: ----------------------------------------
4178: -- Set_Attributes for:OKL_SUBSIDIES_B --
4179: ----------------------------------------
4180: FUNCTION Set_Attributes (
4181: p_subb_rec IN subb_rec_type,
4182: x_subb_rec OUT NOCOPY subb_rec_type

Line 4216: UPDATE OKL_SUBSIDIES_B

4212: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4213: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
4214: RAISE OKL_API.G_EXCEPTION_ERROR;
4215: END IF;
4216: UPDATE OKL_SUBSIDIES_B
4217: SET OBJECT_VERSION_NUMBER = l_def_subb_rec.object_version_number,
4218: ORG_ID = l_def_subb_rec.org_id,
4219: NAME = l_def_subb_rec.name,
4220: EFFECTIVE_FROM_DATE = l_def_subb_rec.effective_from_date,

Line 5050: -- delete_row for:OKL_SUBSIDIES_B --

5046: ---------------------------------------------------------------------------
5047: -- PROCEDURE delete_row
5048: ---------------------------------------------------------------------------
5049: ------------------------------------
5050: -- delete_row for:OKL_SUBSIDIES_B --
5051: ------------------------------------
5052: PROCEDURE delete_row(
5053: p_init_msg_list IN VARCHAR2,
5054: x_return_status OUT NOCOPY VARCHAR2,

Line 5075: DELETE FROM OKL_SUBSIDIES_B

5071: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
5072: RAISE OKL_API.G_EXCEPTION_ERROR;
5073: END IF;
5074:
5075: DELETE FROM OKL_SUBSIDIES_B
5076: WHERE ID = p_subb_rec.id;
5077:
5078: x_return_status := l_return_status;
5079: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);