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_TAL_PVT dependencies on OKL_TXL_ASSETS_B

Line 574: CURSOR c_org_id_validate(p_org_id OKL_TXL_ASSETS_B.ORG_ID%TYPE,

570:
571: PROCEDURE validate_org_id(x_return_status OUT NOCOPY VARCHAR2,
572: p_talv_rec IN talv_rec_type) IS
573: ln_dummy number := 0;
574: CURSOR c_org_id_validate(p_org_id OKL_TXL_ASSETS_B.ORG_ID%TYPE,
575: p_kle_id OKL_TXL_ASSETS_B.KLE_ID%TYPE) is
576: SELECT 1
577: FROM DUAL
578: WHERE EXISTS (SELECT chrv.authoring_org_id

Line 575: p_kle_id OKL_TXL_ASSETS_B.KLE_ID%TYPE) is

571: PROCEDURE validate_org_id(x_return_status OUT NOCOPY VARCHAR2,
572: p_talv_rec IN talv_rec_type) IS
573: ln_dummy number := 0;
574: CURSOR c_org_id_validate(p_org_id OKL_TXL_ASSETS_B.ORG_ID%TYPE,
575: p_kle_id OKL_TXL_ASSETS_B.KLE_ID%TYPE) is
576: SELECT 1
577: FROM DUAL
578: WHERE EXISTS (SELECT chrv.authoring_org_id
579: FROM OKC_K_HEADERS_B chrv,

Line 1767: FROM OKL_TXL_ASSETS_B B --fixed bug 3321017 by kmotepal

1763: BEGIN
1764: DELETE FROM OKL_TXL_ASSETS_TL T
1765: WHERE NOT EXISTS (
1766: SELECT NULL
1767: FROM OKL_TXL_ASSETS_B B --fixed bug 3321017 by kmotepal
1768: WHERE B.ID = T.ID
1769: );
1770:
1771: UPDATE OKL_TXL_ASSETS_TL T SET (

Line 1826: -- FUNCTION get_rec for: OKL_TXL_ASSETS_B

1822:
1823: END add_language;
1824:
1825: ---------------------------------------------------------------------------
1826: -- FUNCTION get_rec for: OKL_TXL_ASSETS_B
1827: ---------------------------------------------------------------------------
1828: FUNCTION get_rec (
1829: p_tal_rec IN tal_rec_type,
1830: x_no_data_found OUT NOCOPY BOOLEAN

Line 1920: FROM Okl_Txl_Assets_B

1916: RESIDUAL_SHR_PARTY_ID,
1917: RESIDUAL_SHR_AMOUNT,
1918: RETIREMENT_ID
1919: -- VRS Project - END
1920: FROM Okl_Txl_Assets_B
1921: WHERE okl_txl_assets_b.id = p_id;
1922: l_okl_txl_asset_b_pk okl_txl_asset_b_pk_csr%ROWTYPE;
1923: l_tal_rec tal_rec_type;
1924: BEGIN

Line 1921: WHERE okl_txl_assets_b.id = p_id;

1917: RESIDUAL_SHR_AMOUNT,
1918: RETIREMENT_ID
1919: -- VRS Project - END
1920: FROM Okl_Txl_Assets_B
1921: WHERE okl_txl_assets_b.id = p_id;
1922: l_okl_txl_asset_b_pk okl_txl_asset_b_pk_csr%ROWTYPE;
1923: l_tal_rec tal_rec_type;
1924: BEGIN
1925: x_no_data_found := TRUE;

Line 3177: -- insert_row for:OKL_TXL_ASSETS_B --

3173: ---------------------------------------------------------------------------
3174: -- PROCEDURE insert_row
3175: ---------------------------------------------------------------------------
3176: -------------------------------------
3177: -- insert_row for:OKL_TXL_ASSETS_B --
3178: -------------------------------------
3179: PROCEDURE insert_row(
3180: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3181: x_return_status OUT NOCOPY VARCHAR2,

Line 3193: -- Set_Attributes for:OKL_TXL_ASSETS_B --

3189: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3190: l_tal_rec tal_rec_type := p_tal_rec;
3191: l_def_tal_rec tal_rec_type;
3192: -----------------------------------------
3193: -- Set_Attributes for:OKL_TXL_ASSETS_B --
3194: -----------------------------------------
3195: FUNCTION Set_Attributes (
3196: p_tal_rec IN tal_rec_type,
3197: x_tal_rec OUT NOCOPY tal_rec_type

Line 3224: INSERT INTO OKL_TXL_ASSETS_B(

3220: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3221: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3222: RAISE OKC_API.G_EXCEPTION_ERROR;
3223: END IF;
3224: INSERT INTO OKL_TXL_ASSETS_B(
3225: id,
3226: object_version_number,
3227: tas_id,
3228: ilo_id,

Line 3835: -- lock_row for:OKL_TXL_ASSETS_B --

3831: ---------------------------------------------------------------------------
3832: -- PROCEDURE lock_row
3833: ---------------------------------------------------------------------------
3834: -----------------------------------
3835: -- lock_row for:OKL_TXL_ASSETS_B --
3836: -----------------------------------
3837: PROCEDURE lock_row(
3838: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3839: x_return_status OUT NOCOPY VARCHAR2,

Line 3848: FROM OKL_TXL_ASSETS_B

3844: E_Resource_Busy EXCEPTION;
3845: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
3846: CURSOR lock_csr (p_tal_rec IN tal_rec_type) IS
3847: SELECT OBJECT_VERSION_NUMBER
3848: FROM OKL_TXL_ASSETS_B
3849: WHERE ID = p_tal_rec.id
3850: AND OBJECT_VERSION_NUMBER = p_tal_rec.object_version_number
3851: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
3852:

Line 3855: FROM OKL_TXL_ASSETS_B

3851: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
3852:
3853: CURSOR lchk_csr (p_tal_rec IN tal_rec_type) IS
3854: SELECT OBJECT_VERSION_NUMBER
3855: FROM OKL_TXL_ASSETS_B
3856: WHERE ID = p_tal_rec.id;
3857: l_api_version CONSTANT NUMBER := 1;
3858: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
3859: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 3860: l_object_version_number OKL_TXL_ASSETS_B.OBJECT_VERSION_NUMBER%TYPE;

3856: WHERE ID = p_tal_rec.id;
3857: l_api_version CONSTANT NUMBER := 1;
3858: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
3859: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3860: l_object_version_number OKL_TXL_ASSETS_B.OBJECT_VERSION_NUMBER%TYPE;
3861: lc_object_version_number OKL_TXL_ASSETS_B.OBJECT_VERSION_NUMBER%TYPE;
3862: l_row_notfound BOOLEAN := FALSE;
3863: lc_row_notfound BOOLEAN := FALSE;
3864: BEGIN

Line 3861: lc_object_version_number OKL_TXL_ASSETS_B.OBJECT_VERSION_NUMBER%TYPE;

3857: l_api_version CONSTANT NUMBER := 1;
3858: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
3859: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3860: l_object_version_number OKL_TXL_ASSETS_B.OBJECT_VERSION_NUMBER%TYPE;
3861: lc_object_version_number OKL_TXL_ASSETS_B.OBJECT_VERSION_NUMBER%TYPE;
3862: l_row_notfound BOOLEAN := FALSE;
3863: lc_row_notfound BOOLEAN := FALSE;
3864: BEGIN
3865: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 4188: -- update_row for:OKL_TXL_ASSETS_B --

4184: ---------------------------------------------------------------------------
4185: -- PROCEDURE update_row
4186: ---------------------------------------------------------------------------
4187: -------------------------------------
4188: -- update_row for:OKL_TXL_ASSETS_B --
4189: -------------------------------------
4190: PROCEDURE update_row(
4191: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
4192: x_return_status OUT NOCOPY VARCHAR2,

Line 4550: -- Set_Attributes for:OKL_TXL_ASSETS_B --

4546:
4547: RETURN(l_return_status);
4548: END populate_new_record;
4549: -----------------------------------------
4550: -- Set_Attributes for:OKL_TXL_ASSETS_B --
4551: -----------------------------------------
4552: FUNCTION Set_Attributes (
4553: p_tal_rec IN tal_rec_type,
4554: x_tal_rec OUT NOCOPY tal_rec_type

Line 4587: UPDATE OKL_TXL_ASSETS_B

4583: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4584: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4585: RAISE OKC_API.G_EXCEPTION_ERROR;
4586: END IF;
4587: UPDATE OKL_TXL_ASSETS_B
4588: SET TAS_ID = l_def_tal_rec.tas_id,
4589: OBJECT_VERSION_NUMBER = l_def_tal_rec.object_version_number,
4590: ILO_ID = l_def_tal_rec.ilo_id,
4591: ILO_ID_OLD = l_def_tal_rec.ilo_id_old,

Line 5515: -- delete_row for:OKL_TXL_ASSETS_B --

5511: ---------------------------------------------------------------------------
5512: -- PROCEDURE delete_row
5513: ---------------------------------------------------------------------------
5514: -------------------------------------
5515: -- delete_row for:OKL_TXL_ASSETS_B --
5516: -------------------------------------
5517: PROCEDURE delete_row(
5518: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
5519: x_return_status OUT NOCOPY VARCHAR2,

Line 5539: DELETE FROM OKL_TXL_ASSETS_B

5535: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5536: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5537: RAISE OKC_API.G_EXCEPTION_ERROR;
5538: END IF;
5539: DELETE FROM OKL_TXL_ASSETS_B
5540: WHERE ID = l_tal_rec.id;
5541:
5542: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
5543: EXCEPTION