DBA Data[Home] [Help]

APPS.OKL_AM_LEASE_TRMNT_PVT dependencies on OKL_TRX_TYPES_V

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

9128: l_fa_location_id OKL_SYSTEM_PARAMS_ALL.FA_LOCATION_ID%TYPE;
9129: l_asset_key_id OKL_SYSTEM_PARAMS_ALL.ASSET_KEY_ID%TYPE;
9130: l_depreciate_yn OKL_SYSTEM_PARAMS_ALL.DEPRECIATE_YN%TYPE;
9131:
9132: CURSOR try_id_csr(p_try_name OKL_TRX_TYPES_V.NAME%TYPE) IS
9133: SELECT id
9134: FROM OKL_TRX_TYPES_tl
9135: WHERE upper(name) = upper(p_try_name)
9136: AND language = 'US';

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

9306: If try_id_csr%NOTFOUND then
9307: OKL_API.set_message(p_app_name => G_APP_NAME,
9308: p_msg_name => G_NO_MATCHING_RECORD,
9309: p_token1 => G_COL_NAME_TOKEN,
9310: p_token1_value => 'OKL_TRX_TYPES_V.ID');
9311: RAISE OKL_API.G_EXCEPTION_ERROR;
9312: End If;
9313: Close try_id_csr;
9314: