[Home] [Help]
3502: ln_dummy NUMBER := 0;
3503: ln1_dummy NUMBER := 0;
3504: ln2_dummy NUMBER := 0;
3505: ln3_dummy NUMBER := p_units;
3506: lv_deal_type OKL_K_HEADERS_V.DEAL_TYPE%TYPE := null;
3507: lv_scs_code OKC_K_HEADERS_V.SCS_CODE%TYPE := null;
3508: --Bug# 4419339
3509: l_orig_system_source_code okc_k_headers_b.orig_system_source_code%TYPE;
3510: CURSOR get_deal_type(p_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE)
3512: SELECT khr.deal_type,
3513: chr.scs_code,
3514: --Bug# 4419339
3515: chr.orig_system_source_code
3516: FROM OKL_K_HEADERS_V khr,
3517: OKC_K_HEADERS_B chr
3518: WHERE khr.id = p_dnz_chr_id
3519: AND chr.id = khr.id;
3520: BEGIN
12207: cursor l_chr_csr (p_chr_id in number) is
12208: SELECT chrb.start_date,
12209: khr.pdt_id
12210: FROM OKC_K_HEADERS_B chrb,
12211: OKL_K_HEADERS khr
12212: WHERE khr.id = chrb.id
12213: AND chrb.id = p_chr_id;
12214:
12215: l_chr_rec l_chr_csr%ROWTYPE;
12308: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
12309:
12310: l_nbv NUMBER;
12311: l_converted_amount NUMBER;
12312: l_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;
12313: l_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;
12314: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;
12315: l_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;
12316:
12309:
12310: l_nbv NUMBER;
12311: l_converted_amount NUMBER;
12312: l_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;
12313: l_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;
12314: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;
12315: l_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;
12316:
12317: BEGIN
12310: l_nbv NUMBER;
12311: l_converted_amount NUMBER;
12312: l_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;
12313: l_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;
12314: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;
12315: l_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;
12316:
12317: BEGIN
12318: --call start activity to set savepoint
12311: l_converted_amount NUMBER;
12312: l_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;
12313: l_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;
12314: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;
12315: l_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;
12316:
12317: BEGIN
12318: --call start activity to set savepoint
12319: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),
12638: chrb.orig_system_source_code,
12639: --Bug# 6328924
12640: khr.legal_entity_id
12641: FROM okc_k_headers_b chrb,
12642: okl_k_headers khr
12643: WHERE chrb.id = p_chr_id
12644: AND khr.id = chrb.id;
12645:
12646: l_hdr_rec l_hdr_csr%ROWTYPE;
12711: l_rep_asset_book okl_txl_assets_b.corporate_book%TYPE;
12712: l_rep_asset_book_done varchar2(1);
12713: l_rep_pdt_id number;
12714: l_tax_owner varchar2(30);
12715: l_rep_deal_type okl_k_headers.deal_type%TYPE;
12716: l_multi_gaap_yn varchar2(1);
12717: l_adjust_asset_to_zero varchar2(1);
12718: l_deal_type okl_k_headers.deal_type%TYPE;
12719:
12714: l_tax_owner varchar2(30);
12715: l_rep_deal_type okl_k_headers.deal_type%TYPE;
12716: l_multi_gaap_yn varchar2(1);
12717: l_adjust_asset_to_zero varchar2(1);
12718: l_deal_type okl_k_headers.deal_type%TYPE;
12719:
12720: l_mg_txdv_rec txdv_rec_type;
12721: lx_mg_txdv_rec txdv_rec_type;
12722: l_corp_nbv number;
15176: select khr.deal_type,
15177: khr.pdt_id,
15178: pdt.reporting_pdt_id
15179: from okl_products pdt,
15180: okl_k_headers khr
15181: where pdt.id = khr.pdt_id
15182: and khr.id = p_chr_id;
15183:
15184: l_deal_type_rec l_deal_type_csr%ROWTYPE;