DBA Data[Home] [Help]

APPS.OKL_BTC_PVT dependencies on OKL_K_HEADERS_FULL_V

Line 757: CURSOR okl_fnd_curr_csr (p_code IN okl_k_headers_full_v.currency_code%type) IS

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:

Line 800: l_functional_currency okl_k_headers_full_v.currency_code%type := okl_accounting_util.get_func_curr_code;

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;

Line 801: l_currency_conv_type okl_k_headers_full_v.currency_conversion_type%type := p_btcv_rec.currency_conversion_type;

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;

Line 802: l_currency_conv_rate okl_k_headers_full_v.currency_conversion_rate%type := p_btcv_rec.currency_conversion_rate;

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

Line 803: l_functional_conversion_rate okl_k_headers_full_v.currency_conversion_rate%type := p_btcv_rec.currency_conversion_rate;

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:

Line 804: l_currency_conv_date okl_k_headers_full_v.currency_conversion_date%type := p_btcv_rec.currency_conversion_date;

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;

Line 805: l_batch_currency okl_k_headers_full_v.currency_code%type := p_btcv_rec.batch_currency;

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: