[Home] [Help]
306:
307: -- sosharma bug 10100863
308: CURSOR get_contract_curr(p_chr_id NUMBER)
309: IS
310: select currency_code from okc_k_headers_b where
311: id = p_chr_id;
312:
313: l_curr_code VARCHAR2(10);
314:
1060: -- Cursor to get the end date of contract
1061: -- RMUNJULU 06-MAR-03 Performance Fix Replaced K_HDR_FULL
1062: CURSOR get_k_end_date_csr ( p_khr_id IN NUMBER) IS
1063: SELECT end_date, sts_code --sechawla 18-dec-07 6690811 : added sts_code
1064: FROM OKC_K_HEADERS_b --sechawla 18-dec-07 6690811 : changed OKC_K_HEADERS_V to OKC_K_HEADERS_b
1065: WHERE id = p_khr_id;
1066:
1067: --sechawla 18-dec-07 6690811
1068: l_k_sts_code VARCHAR2(30);
2435:
2436: -- 20-JAN-06 SECHAWLA 4970009 : added
2437: CURSOR l_okcheaders_b(cp_khr_id IN NUMBER) IS
2438: SELECT end_date
2439: FROM okc_k_headers_b
2440: WHERE id = cp_khr_id;
2441:
2442: l_end_date DATE;
2443: -- asawanka added for debug feature start
2849: SELECT id,
2850: object_version_number,
2851: sts_code,
2852: authoring_org_id --CDUBEY authoring_org_id added for MOAC
2853: FROM OKC_K_HEADERS_B
2854: WHERE id = p_term_rec.p_contract_id;
2855:
2856: -- Cursor to get all lines for the contract
2857: -- Cannot use the klev_tbl as these are financial lines only
2859: CURSOR k_lines_csr (p_khr_id IN NUMBER) IS
2860: SELECT KLE.id kle_id,
2861: KLE.line_number line_number
2862: FROM OKC_K_LINES_B KLE,
2863: OKC_K_HEADERS_B KHR
2864: WHERE KLE.dnz_chr_id = p_khr_id
2865: AND KLE.sts_code = KHR.sts_code
2866: AND KLE.dnz_chr_id = KHR.id;
2867:
4209:
4210: -- Cursor to get the end date of contract -- Can get from main API
4211: CURSOR k_end_date_csr ( p_chr_id IN NUMBER) IS
4212: SELECT end_date
4213: FROM OKC_K_HEADERS_B
4214: WHERE id = p_chr_id;
4215:
4216: l_k_end_date DATE;
4217: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
4487:
4488: --Fix for Bug#14255615
4489: CURSOR rev_rec_method_csr(p_chr_id IN NUMBER) IS
4490: SELECT ppm.revenue_recognition_method
4491: FROM okc_k_headers_b chr,
4492: okl_k_headers khr,
4493: okl_product_parameters_v ppm
4494: WHERE chr.id = p_chr_id
4495: AND chr.id = khr.id
6327: ,chr.org_id --akrangan added for sla ae uptake cr
6328: ,khr.multi_gaap_yn --MGAAP 7263041
6329: ,pdt.reporting_pdt_id --MGAAP 7263041
6330: FROM okl_k_headers_v khr,
6331: okc_k_headers_b chr, -- rmunjulu Bug 4162862
6332: okl_products pdt
6333: WHERE khr.id = p_khr_id AND khr.id = chr.id -- rmunjulu Bug 4162862
6334: AND khr.pdt_id = pdt.ID; -- MGAAP 7263041
6335:
6479:
6480: -- rmunjulu 4141991 Cursor to get the product of the contract
6481: CURSOR get_k_sts_csr(p_khr_id IN NUMBER) IS
6482: SELECT chr.sts_code
6483: FROM okc_k_headers_b chr
6484: WHERE chr.id = p_khr_id;
6485:
6486: -- rmunjulu 4141991
6487: l_k_sts VARCHAR2(300);
6501: -- rmunjulu 4424713
6502: l_deal_type VARCHAR2(150);
6503:
6504: -- rmunjulu 4622198
6505: l_scs_code okc_k_headers_b.scs_code%TYPE;
6506: l_fact_synd_code fnd_lookups.lookup_code%TYPE;
6507: l_inv_acct_code okc_rules_b.rule_information1%TYPE;
6508:
6509: --rmunjulu 4769094
8008: END process_accounting_entries;
8009:
8010: PROCEDURE Create_Repo_asset_2(
8011: p_init_msg_list IN VARCHAR2,
8012: p_khr_id IN OKC_K_HEADERS_B.ID%TYPE,
8013: p_kle_id IN OKL_K_LINES.ID%TYPE,
8014: p_corporate_book IN OKL_SYSTEM_PARAMS_ALL.CORPORATE_BOOK%TYPE,
8015: p_tax_book_1 IN OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_1%TYPE,
8016: p_tax_book_2 IN OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_2%TYPE,
8494: --RKUTTIYA Added for bug 6674370
8495: --Call to SLA Populate Sources
8496: PROCEDURE Populate_Sources(p_api_version IN NUMBER,
8497: p_init_msg_list IN VARCHAR2,
8498: p_khr_id IN OKC_K_HEADERS_B.ID%TYPE,
8499: p_kle_id IN OKL_K_LINES.ID%TYPE,
8500: p_corporate_book IN OKL_SYSTEM_PARAMS_ALL.CORPORATE_BOOK%TYPE,
8501: p_tas_id IN OKL_TRX_ASSETS.ID%TYPE,
8502: p_tal_id IN NUMBER,
8604:
8605:
8606: PROCEDURE Create_Repo_asset(
8607: p_init_msg_list IN VARCHAR2,
8608: p_khr_id IN OKC_K_HEADERS_B.ID%TYPE,
8609: p_kle_id IN OKL_K_LINES.ID%TYPE,
8610: p_corporate_book IN OKL_SYSTEM_PARAMS_ALL.CORPORATE_BOOK%TYPE,
8611: p_tax_book_1 IN OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_1%TYPE,
8612: p_tax_book_2 IN OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_2%TYPE,
9276: l_proceeds_of_sale NUMBER;
9277:
9278: --SECHAWLA Bug # 2726739 : new declarations
9279: l_func_curr_code GL_LEDGERS_PUBLIC_V.CURRENCY_CODE%TYPE;
9280: l_contract_curr_code okc_k_headers_b.currency_code%TYPE;
9281: -- RMUNJULU 06-MAR-03 Performance Fix Replaced K_HDR_FULL
9282: lx_contract_currency okc_k_headers_v.currency_code%TYPE;
9283: lx_currency_conversion_type okl_k_headers_v.currency_conversion_type%TYPE;
9284: lx_currency_conversion_rate okl_k_headers_v.currency_conversion_rate%TYPE;
9298: KHR.DEAL_TYPE,
9299: CHR.AUTHORING_ORG_ID
9300: FROM OKL_TRX_QUOTES_V OTQV,
9301: OKL_K_HEADERS KHR,
9302: OKC_K_HEADERS_B CHR
9303: WHERE OTQV.ID = p_quote_id
9304: AND OTQV.KHR_ID = KHR.ID
9305: AND KHR.ID = CHR.ID;
9306:
9305: AND KHR.ID = CHR.ID;
9306:
9307: l_repo_yn OKL_TRX_QUOTES_V.REPO_QUOTE_INDICATOR_YN%TYPE := 'N';
9308: l_deal_type OKL_K_HEADERS.DEAL_TYPE%TYPE;
9309: l_org_id OKC_K_HEADERS_B.AUTHORING_ORG_ID%TYPE;
9310:
9311: CURSOR c_get_loan_repo_params(p_org_id NUMBER) IS
9312: --SELECT CORPORATE_BOOK,
9313: SELECT ASST_ADD_BOOK_TYPE_CODE CORPORATE_BOOK,