DBA Data[Home] [Help]

APPS.OKL_RELEASE_PVT dependencies on OKL_K_HEADERS

Line 2289: okl_k_headers khr

2285: chr.orig_system_source_code,
2286: --Bug# 4631549
2287: chr.currency_code
2288: FROM okc_k_headers_b chr,
2289: okl_k_headers khr
2290: WHERE chr.id = p_chr_id
2291: AND chr.id = khr.id;
2292:
2293: chr_rec chr_csr%ROWTYPE;

Line 3221: okl_k_headers khr

3217: sts_code,
3218: --Bug# 5005869
3219: chr.currency_code
3220: FROM okc_k_headers_b chr,
3221: okl_k_headers khr
3222: WHERE chr.id = p_chr_id
3223: AND chr.id = khr.id;
3224:
3225: chr_rec chr_csr%ROWTYPE;

Line 6553: l_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;

6549: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
6550:
6551: l_nbv NUMBER;
6552: l_converted_amount NUMBER;
6553: l_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;
6554: l_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;
6555: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;
6556: l_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;
6557:

Line 6554: l_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;

6550:
6551: l_nbv NUMBER;
6552: l_converted_amount NUMBER;
6553: l_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;
6554: l_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;
6555: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;
6556: l_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;
6557:
6558: BEGIN

Line 6555: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;

6551: l_nbv NUMBER;
6552: l_converted_amount NUMBER;
6553: l_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;
6554: l_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;
6555: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;
6556: l_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;
6557:
6558: BEGIN
6559: --call start activity to set savepoint

Line 6556: l_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;

6552: l_converted_amount NUMBER;
6553: l_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;
6554: l_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;
6555: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;
6556: l_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;
6557:
6558: BEGIN
6559: --call start activity to set savepoint
6560: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),

Line 6708: from okl_k_headers khr,

6704: --cursor to fetch deal type and taxowner
6705: Cursor l_book_class_csr (p_chr_id IN NUMBER) is
6706: select khr.deal_type deal_type,
6707: rulb.rule_information1 tax_owner
6708: from okl_k_headers khr,
6709: okc_rules_b rulb
6710: where rulb.dnz_chr_id = p_chr_id
6711: and rulb.rule_information_category = 'LATOWN'
6712: and khr.id = p_chr_id;

Line 6719: l_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;

6715: l_additional_parameters okl_execute_formula_pub.ctxt_val_tbl_type;
6716: l_expected_cost NUMBER;
6717:
6718: l_converted_amount NUMBER;
6719: l_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;
6720: l_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;
6721: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;
6722: l_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;
6723:

Line 6720: l_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;

6716: l_expected_cost NUMBER;
6717:
6718: l_converted_amount NUMBER;
6719: l_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;
6720: l_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;
6721: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;
6722: l_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;
6723:
6724: BEGIN

Line 6721: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;

6717:
6718: l_converted_amount NUMBER;
6719: l_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;
6720: l_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;
6721: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;
6722: l_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;
6723:
6724: BEGIN
6725: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

Line 6722: l_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;

6718: l_converted_amount NUMBER;
6719: l_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;
6720: l_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;
6721: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;
6722: l_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;
6723:
6724: BEGIN
6725: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
6726: -- Call start_activity to create savepoint, check compatibility