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.

[Home] [Help]

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 1751: FROM OKL_TXL_ASSETS_B B --fixed bug 3321017 by kmotepal

1747: BEGIN
1748: DELETE FROM OKL_TXL_ASSETS_TL T
1749: WHERE NOT EXISTS (
1750: SELECT NULL
1751: FROM OKL_TXL_ASSETS_B B --fixed bug 3321017 by kmotepal
1752: WHERE B.ID = T.ID
1753: );
1754:
1755: UPDATE OKL_TXL_ASSETS_TL T SET (

Line 1810: -- FUNCTION get_rec for: OKL_TXL_ASSETS_B

1806:
1807: END add_language;
1808:
1809: ---------------------------------------------------------------------------
1810: -- FUNCTION get_rec for: OKL_TXL_ASSETS_B
1811: ---------------------------------------------------------------------------
1812: FUNCTION get_rec (
1813: p_tal_rec IN tal_rec_type,
1814: x_no_data_found OUT NOCOPY BOOLEAN

Line 1904: FROM Okl_Txl_Assets_B

1900: RESIDUAL_SHR_PARTY_ID,
1901: RESIDUAL_SHR_AMOUNT,
1902: RETIREMENT_ID
1903: -- VRS Project - END
1904: FROM Okl_Txl_Assets_B
1905: WHERE okl_txl_assets_b.id = p_id;
1906: l_okl_txl_asset_b_pk okl_txl_asset_b_pk_csr%ROWTYPE;
1907: l_tal_rec tal_rec_type;
1908: BEGIN

Line 1905: WHERE okl_txl_assets_b.id = p_id;

1901: RESIDUAL_SHR_AMOUNT,
1902: RETIREMENT_ID
1903: -- VRS Project - END
1904: FROM Okl_Txl_Assets_B
1905: WHERE okl_txl_assets_b.id = p_id;
1906: l_okl_txl_asset_b_pk okl_txl_asset_b_pk_csr%ROWTYPE;
1907: l_tal_rec tal_rec_type;
1908: BEGIN
1909: x_no_data_found := TRUE;

Line 3161: -- insert_row for:OKL_TXL_ASSETS_B --

3157: ---------------------------------------------------------------------------
3158: -- PROCEDURE insert_row
3159: ---------------------------------------------------------------------------
3160: -------------------------------------
3161: -- insert_row for:OKL_TXL_ASSETS_B --
3162: -------------------------------------
3163: PROCEDURE insert_row(
3164: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3165: x_return_status OUT NOCOPY VARCHAR2,

Line 3177: -- Set_Attributes for:OKL_TXL_ASSETS_B --

3173: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3174: l_tal_rec tal_rec_type := p_tal_rec;
3175: l_def_tal_rec tal_rec_type;
3176: -----------------------------------------
3177: -- Set_Attributes for:OKL_TXL_ASSETS_B --
3178: -----------------------------------------
3179: FUNCTION Set_Attributes (
3180: p_tal_rec IN tal_rec_type,
3181: x_tal_rec OUT NOCOPY tal_rec_type

Line 3208: INSERT INTO OKL_TXL_ASSETS_B(

3204: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3205: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3206: RAISE OKC_API.G_EXCEPTION_ERROR;
3207: END IF;
3208: INSERT INTO OKL_TXL_ASSETS_B(
3209: id,
3210: object_version_number,
3211: tas_id,
3212: ilo_id,

Line 3819: -- lock_row for:OKL_TXL_ASSETS_B --

3815: ---------------------------------------------------------------------------
3816: -- PROCEDURE lock_row
3817: ---------------------------------------------------------------------------
3818: -----------------------------------
3819: -- lock_row for:OKL_TXL_ASSETS_B --
3820: -----------------------------------
3821: PROCEDURE lock_row(
3822: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3823: x_return_status OUT NOCOPY VARCHAR2,

Line 3832: FROM OKL_TXL_ASSETS_B

3828: E_Resource_Busy EXCEPTION;
3829: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
3830: CURSOR lock_csr (p_tal_rec IN tal_rec_type) IS
3831: SELECT OBJECT_VERSION_NUMBER
3832: FROM OKL_TXL_ASSETS_B
3833: WHERE ID = p_tal_rec.id
3834: AND OBJECT_VERSION_NUMBER = p_tal_rec.object_version_number
3835: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
3836:

Line 3839: FROM OKL_TXL_ASSETS_B

3835: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
3836:
3837: CURSOR lchk_csr (p_tal_rec IN tal_rec_type) IS
3838: SELECT OBJECT_VERSION_NUMBER
3839: FROM OKL_TXL_ASSETS_B
3840: WHERE ID = p_tal_rec.id;
3841: l_api_version CONSTANT NUMBER := 1;
3842: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
3843: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 3844: l_object_version_number OKL_TXL_ASSETS_B.OBJECT_VERSION_NUMBER%TYPE;

3840: WHERE ID = p_tal_rec.id;
3841: l_api_version CONSTANT NUMBER := 1;
3842: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
3843: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3844: l_object_version_number OKL_TXL_ASSETS_B.OBJECT_VERSION_NUMBER%TYPE;
3845: lc_object_version_number OKL_TXL_ASSETS_B.OBJECT_VERSION_NUMBER%TYPE;
3846: l_row_notfound BOOLEAN := FALSE;
3847: lc_row_notfound BOOLEAN := FALSE;
3848: BEGIN

Line 3845: lc_object_version_number OKL_TXL_ASSETS_B.OBJECT_VERSION_NUMBER%TYPE;

3841: l_api_version CONSTANT NUMBER := 1;
3842: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
3843: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3844: l_object_version_number OKL_TXL_ASSETS_B.OBJECT_VERSION_NUMBER%TYPE;
3845: lc_object_version_number OKL_TXL_ASSETS_B.OBJECT_VERSION_NUMBER%TYPE;
3846: l_row_notfound BOOLEAN := FALSE;
3847: lc_row_notfound BOOLEAN := FALSE;
3848: BEGIN
3849: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 4172: -- update_row for:OKL_TXL_ASSETS_B --

4168: ---------------------------------------------------------------------------
4169: -- PROCEDURE update_row
4170: ---------------------------------------------------------------------------
4171: -------------------------------------
4172: -- update_row for:OKL_TXL_ASSETS_B --
4173: -------------------------------------
4174: PROCEDURE update_row(
4175: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
4176: x_return_status OUT NOCOPY VARCHAR2,

Line 4534: -- Set_Attributes for:OKL_TXL_ASSETS_B --

4530:
4531: RETURN(l_return_status);
4532: END populate_new_record;
4533: -----------------------------------------
4534: -- Set_Attributes for:OKL_TXL_ASSETS_B --
4535: -----------------------------------------
4536: FUNCTION Set_Attributes (
4537: p_tal_rec IN tal_rec_type,
4538: x_tal_rec OUT NOCOPY tal_rec_type

Line 4571: UPDATE OKL_TXL_ASSETS_B

4567: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4568: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4569: RAISE OKC_API.G_EXCEPTION_ERROR;
4570: END IF;
4571: UPDATE OKL_TXL_ASSETS_B
4572: SET TAS_ID = l_def_tal_rec.tas_id,
4573: OBJECT_VERSION_NUMBER = l_def_tal_rec.object_version_number,
4574: ILO_ID = l_def_tal_rec.ilo_id,
4575: ILO_ID_OLD = l_def_tal_rec.ilo_id_old,

Line 5499: -- delete_row for:OKL_TXL_ASSETS_B --

5495: ---------------------------------------------------------------------------
5496: -- PROCEDURE delete_row
5497: ---------------------------------------------------------------------------
5498: -------------------------------------
5499: -- delete_row for:OKL_TXL_ASSETS_B --
5500: -------------------------------------
5501: PROCEDURE delete_row(
5502: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
5503: x_return_status OUT NOCOPY VARCHAR2,

Line 5523: DELETE FROM OKL_TXL_ASSETS_B

5519: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5520: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5521: RAISE OKC_API.G_EXCEPTION_ERROR;
5522: END IF;
5523: DELETE FROM OKL_TXL_ASSETS_B
5524: WHERE ID = l_tal_rec.id;
5525:
5526: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
5527: EXCEPTION