[Home] [Help]
3543: ln_dummy NUMBER := 0;
3544: ln1_dummy NUMBER := 0;
3545: ln2_dummy NUMBER := 0;
3546: ln3_dummy NUMBER := p_units;
3547: lv_deal_type OKL_K_HEADERS_V.DEAL_TYPE%TYPE := null;
3548: lv_scs_code OKC_K_HEADERS_V.SCS_CODE%TYPE := null;
3549: --Bug# 4419339
3550: l_orig_system_source_code okc_k_headers_b.orig_system_source_code%TYPE;
3551: CURSOR get_deal_type(p_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE)
3553: SELECT khr.deal_type,
3554: chr.scs_code,
3555: --Bug# 4419339
3556: chr.orig_system_source_code
3557: FROM OKL_K_HEADERS_V khr,
3558: OKC_K_HEADERS_B chr
3559: WHERE khr.id = p_dnz_chr_id
3560: AND chr.id = khr.id;
3561: BEGIN
12292: cursor l_chr_csr (p_chr_id in number) is
12293: SELECT chrb.start_date,
12294: khr.pdt_id
12295: FROM OKC_K_HEADERS_B chrb,
12296: OKL_K_HEADERS khr
12297: WHERE khr.id = chrb.id
12298: AND chrb.id = p_chr_id;
12299:
12300: l_chr_rec l_chr_csr%ROWTYPE;
12393: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
12394:
12395: l_nbv NUMBER;
12396: l_converted_amount NUMBER;
12397: l_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;
12398: l_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;
12399: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;
12400: l_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;
12401:
12394:
12395: l_nbv NUMBER;
12396: l_converted_amount NUMBER;
12397: l_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;
12398: l_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;
12399: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;
12400: l_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;
12401:
12402: BEGIN
12395: l_nbv NUMBER;
12396: l_converted_amount NUMBER;
12397: l_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;
12398: l_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;
12399: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;
12400: l_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;
12401:
12402: BEGIN
12403: --call start activity to set savepoint
12396: l_converted_amount NUMBER;
12397: l_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;
12398: l_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;
12399: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;
12400: l_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;
12401:
12402: BEGIN
12403: --call start activity to set savepoint
12404: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),
12724: chrb.orig_system_source_code,
12725: --Bug# 6328924
12726: khr.legal_entity_id
12727: FROM okc_k_headers_b chrb,
12728: okl_k_headers khr
12729: WHERE chrb.id = p_chr_id
12730: AND khr.id = chrb.id;
12731:
12732: l_hdr_rec l_hdr_csr%ROWTYPE;
12797: l_rep_asset_book okl_txl_assets_b.corporate_book%TYPE;
12798: l_rep_asset_book_done varchar2(1);
12799: l_rep_pdt_id number;
12800: l_tax_owner varchar2(30);
12801: l_rep_deal_type okl_k_headers.deal_type%TYPE;
12802: l_multi_gaap_yn varchar2(1);
12803: l_adjust_asset_to_zero varchar2(1);
12804: l_deal_type okl_k_headers.deal_type%TYPE;
12805:
12800: l_tax_owner varchar2(30);
12801: l_rep_deal_type okl_k_headers.deal_type%TYPE;
12802: l_multi_gaap_yn varchar2(1);
12803: l_adjust_asset_to_zero varchar2(1);
12804: l_deal_type okl_k_headers.deal_type%TYPE;
12805:
12806: l_mg_txdv_rec txdv_rec_type;
12807: lx_mg_txdv_rec txdv_rec_type;
12808: l_corp_nbv number;
15307: select khr.deal_type,
15308: khr.pdt_id,
15309: pdt.reporting_pdt_id
15310: from okl_products pdt,
15311: okl_k_headers khr
15312: where pdt.id = khr.pdt_id
15313: and khr.id = p_chr_id;
15314:
15315: l_deal_type_rec l_deal_type_csr%ROWTYPE;