753: l_dummy VARCHAR2(1) := '?';
754: l_row_not_found BOOLEAN := FALSE;
755:
756: -- Cursor For OKL_CURRENCIES;
757: CURSOR okl_fnd_curr_csr (p_code IN okl_k_headers_full_v.currency_code%type) IS
758: SELECT '1'
759: FROM FND_CURRENCIES_VL
760: WHERE FND_CURRENCIES_VL.currency_code = p_code;
761:
796: -- End of comments
797:
798: PROCEDURE validate_curr_conv (p_btcv_rec IN btcv_rec_type,
799: x_return_status OUT NOCOPY VARCHAR2) IS
800: l_functional_currency okl_k_headers_full_v.currency_code%type := okl_accounting_util.get_func_curr_code;
801: l_currency_conv_type okl_k_headers_full_v.currency_conversion_type%type := p_btcv_rec.currency_conversion_type;
802: l_currency_conv_rate okl_k_headers_full_v.currency_conversion_rate%type := p_btcv_rec.currency_conversion_rate;
803: l_functional_conversion_rate okl_k_headers_full_v.currency_conversion_rate%type := p_btcv_rec.currency_conversion_rate;
804: l_currency_conv_date okl_k_headers_full_v.currency_conversion_date%type := p_btcv_rec.currency_conversion_date;
797:
798: PROCEDURE validate_curr_conv (p_btcv_rec IN btcv_rec_type,
799: x_return_status OUT NOCOPY VARCHAR2) IS
800: l_functional_currency okl_k_headers_full_v.currency_code%type := okl_accounting_util.get_func_curr_code;
801: l_currency_conv_type okl_k_headers_full_v.currency_conversion_type%type := p_btcv_rec.currency_conversion_type;
802: l_currency_conv_rate okl_k_headers_full_v.currency_conversion_rate%type := p_btcv_rec.currency_conversion_rate;
803: l_functional_conversion_rate okl_k_headers_full_v.currency_conversion_rate%type := p_btcv_rec.currency_conversion_rate;
804: l_currency_conv_date okl_k_headers_full_v.currency_conversion_date%type := p_btcv_rec.currency_conversion_date;
805: l_batch_currency okl_k_headers_full_v.currency_code%type := p_btcv_rec.batch_currency;
798: PROCEDURE validate_curr_conv (p_btcv_rec IN btcv_rec_type,
799: x_return_status OUT NOCOPY VARCHAR2) IS
800: l_functional_currency okl_k_headers_full_v.currency_code%type := okl_accounting_util.get_func_curr_code;
801: l_currency_conv_type okl_k_headers_full_v.currency_conversion_type%type := p_btcv_rec.currency_conversion_type;
802: l_currency_conv_rate okl_k_headers_full_v.currency_conversion_rate%type := p_btcv_rec.currency_conversion_rate;
803: l_functional_conversion_rate okl_k_headers_full_v.currency_conversion_rate%type := p_btcv_rec.currency_conversion_rate;
804: l_currency_conv_date okl_k_headers_full_v.currency_conversion_date%type := p_btcv_rec.currency_conversion_date;
805: l_batch_currency okl_k_headers_full_v.currency_code%type := p_btcv_rec.batch_currency;
806: BEGIN
799: x_return_status OUT NOCOPY VARCHAR2) IS
800: l_functional_currency okl_k_headers_full_v.currency_code%type := okl_accounting_util.get_func_curr_code;
801: l_currency_conv_type okl_k_headers_full_v.currency_conversion_type%type := p_btcv_rec.currency_conversion_type;
802: l_currency_conv_rate okl_k_headers_full_v.currency_conversion_rate%type := p_btcv_rec.currency_conversion_rate;
803: l_functional_conversion_rate okl_k_headers_full_v.currency_conversion_rate%type := p_btcv_rec.currency_conversion_rate;
804: l_currency_conv_date okl_k_headers_full_v.currency_conversion_date%type := p_btcv_rec.currency_conversion_date;
805: l_batch_currency okl_k_headers_full_v.currency_code%type := p_btcv_rec.batch_currency;
806: BEGIN
807:
800: l_functional_currency okl_k_headers_full_v.currency_code%type := okl_accounting_util.get_func_curr_code;
801: l_currency_conv_type okl_k_headers_full_v.currency_conversion_type%type := p_btcv_rec.currency_conversion_type;
802: l_currency_conv_rate okl_k_headers_full_v.currency_conversion_rate%type := p_btcv_rec.currency_conversion_rate;
803: l_functional_conversion_rate okl_k_headers_full_v.currency_conversion_rate%type := p_btcv_rec.currency_conversion_rate;
804: l_currency_conv_date okl_k_headers_full_v.currency_conversion_date%type := p_btcv_rec.currency_conversion_date;
805: l_batch_currency okl_k_headers_full_v.currency_code%type := p_btcv_rec.batch_currency;
806: BEGIN
807:
808: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
801: l_currency_conv_type okl_k_headers_full_v.currency_conversion_type%type := p_btcv_rec.currency_conversion_type;
802: l_currency_conv_rate okl_k_headers_full_v.currency_conversion_rate%type := p_btcv_rec.currency_conversion_rate;
803: l_functional_conversion_rate okl_k_headers_full_v.currency_conversion_rate%type := p_btcv_rec.currency_conversion_rate;
804: l_currency_conv_date okl_k_headers_full_v.currency_conversion_date%type := p_btcv_rec.currency_conversion_date;
805: l_batch_currency okl_k_headers_full_v.currency_code%type := p_btcv_rec.batch_currency;
806: BEGIN
807:
808: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
809: