DBA Data[Home] [Help]

APPS.OKL_RELEASE_PVT dependencies on OKL_K_HEADERS

Line 2265: okl_k_headers khr

2261: chr.orig_system_source_code,
2262: --Bug# 4631549
2263: chr.currency_code
2264: FROM okc_k_headers_b chr,
2265: okl_k_headers khr
2266: WHERE chr.id = p_chr_id
2267: AND chr.id = khr.id;
2268:
2269: chr_rec chr_csr%ROWTYPE;

Line 3167: okl_k_headers khr

3163: sts_code,
3164: --Bug# 5005869
3165: chr.currency_code
3166: FROM okc_k_headers_b chr,
3167: okl_k_headers khr
3168: WHERE chr.id = p_chr_id
3169: AND chr.id = khr.id;
3170:
3171: chr_rec chr_csr%ROWTYPE;

Line 6244: l_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;

6240: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
6241:
6242: l_nbv NUMBER;
6243: l_converted_amount NUMBER;
6244: l_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;
6245: l_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;
6246: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;
6247: l_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;
6248:

Line 6245: l_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;

6241:
6242: l_nbv NUMBER;
6243: l_converted_amount NUMBER;
6244: l_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;
6245: l_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;
6246: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;
6247: l_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;
6248:
6249: BEGIN

Line 6246: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;

6242: l_nbv NUMBER;
6243: l_converted_amount NUMBER;
6244: l_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;
6245: l_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;
6246: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;
6247: l_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;
6248:
6249: BEGIN
6250: --call start activity to set savepoint

Line 6247: l_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;

6243: l_converted_amount NUMBER;
6244: l_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;
6245: l_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;
6246: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;
6247: l_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;
6248:
6249: BEGIN
6250: --call start activity to set savepoint
6251: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),

Line 6399: from okl_k_headers khr,

6395: --cursor to fetch deal type and taxowner
6396: Cursor l_book_class_csr (p_chr_id IN NUMBER) is
6397: select khr.deal_type deal_type,
6398: rulb.rule_information1 tax_owner
6399: from okl_k_headers khr,
6400: okc_rules_b rulb
6401: where rulb.dnz_chr_id = p_chr_id
6402: and rulb.rule_information_category = 'LATOWN'
6403: and khr.id = p_chr_id;

Line 6410: l_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;

6406: l_additional_parameters okl_execute_formula_pub.ctxt_val_tbl_type;
6407: l_expected_cost NUMBER;
6408:
6409: l_converted_amount NUMBER;
6410: l_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;
6411: l_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;
6412: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;
6413: l_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;
6414:

Line 6411: l_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;

6407: l_expected_cost NUMBER;
6408:
6409: l_converted_amount NUMBER;
6410: l_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;
6411: l_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;
6412: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;
6413: l_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;
6414:
6415: BEGIN

Line 6412: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;

6408:
6409: l_converted_amount NUMBER;
6410: l_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;
6411: l_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;
6412: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;
6413: l_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;
6414:
6415: BEGIN
6416: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

Line 6413: l_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;

6409: l_converted_amount NUMBER;
6410: l_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;
6411: l_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;
6412: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;
6413: l_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;
6414:
6415: BEGIN
6416: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
6417: -- Call start_activity to create savepoint, check compatibility