DBA Data[Home] [Help]

APPS.OKL_AM_LEASE_TRMNT_PVT dependencies on OKL_TRX_TYPES_V

Line 9331: CURSOR try_id_csr(p_try_name OKL_TRX_TYPES_V.NAME%TYPE) IS

9327: l_fa_location_id OKL_SYSTEM_PARAMS_ALL.FA_LOCATION_ID%TYPE;
9328: l_asset_key_id OKL_SYSTEM_PARAMS_ALL.ASSET_KEY_ID%TYPE;
9329: l_depreciate_yn OKL_SYSTEM_PARAMS_ALL.DEPRECIATE_YN%TYPE;
9330:
9331: CURSOR try_id_csr(p_try_name OKL_TRX_TYPES_V.NAME%TYPE) IS
9332: SELECT id
9333: FROM OKL_TRX_TYPES_tl
9334: WHERE upper(name) = upper(p_try_name)
9335: AND language = 'US';

Line 9509: p_token1_value => 'OKL_TRX_TYPES_V.ID');

9505: If try_id_csr%NOTFOUND then
9506: OKL_API.set_message(p_app_name => G_APP_NAME,
9507: p_msg_name => G_NO_MATCHING_RECORD,
9508: p_token1 => G_COL_NAME_TOKEN,
9509: p_token1_value => 'OKL_TRX_TYPES_V.ID');
9510: RAISE OKL_API.G_EXCEPTION_ERROR;
9511: End If;
9512: Close try_id_csr;
9513: