[Home] [Help]
136: -- Code segment for Customer Account/bill to address
137: -- as mentioned in OKC Rules Migration HLD
138: CURSOR BillToAddress_csr(p_contract_id NUMBER) IS
139: SELECT bill_to_site_use_id
140: FROM okc_k_headers_b
141: WHERE id =p_contract_id;
142:
143: l_bill_to_address_id VARCHAR2(240);
144: l_api_version NUMBER;
315: RETURN VARCHAR2
316: IS
317: CURSOR currency_csr(p_contract_id NUMBER) IS
318: SELECT currency_code
319: FROM okc_k_headers_b
320: WHERE id = p_contract_id;
321:
322: l_currency VARCHAR2(240);
323: l_api_version NUMBER;
356: RETURN VARCHAR2
357: IS
358: -- A complex query to find out if a contract has syndication
359: CURSOR syndicate_flag_csr(p_contract_id NUMBER) IS
360: SELECT 'Y' FROM okc_k_headers_b chr
361: WHERE id = p_contract_id
362: AND EXISTS
363: (
364: SELECT 'x' FROM okc_k_items cim
371: AND cle.id = cim.cle_id
372: )
373: AND EXISTS
374: (
375: SELECT 'x' FROM okc_k_headers_b chr2
376: WHERE chr2.id = cim.dnz_chr_id
377: AND chr2.scs_code = 'SYNDICATION'
378: AND chr2.sts_code not in ('TERMINATED','ABANDONED')
379: )
418:
419: -- get org_id for contract
420: CURSOR get_org_id_csr (p_contract_id IN VARCHAR2) IS
421: SELECT authoring_org_id
422: FROM okc_k_headers_b
423: WHERE id = p_contract_id;
424:
425: l_api_version NUMBER;
426: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
465: SELECT count(stm.khr_id) remaining_payments
466: FROM okl_strm_elements ste
467: ,okl_streams stm
468: ,okl_strm_type_b sty
469: ,okc_k_headers_b khr
470: WHERE stm.id = ste.stm_id
471: AND ste.date_billed IS NULL
472: AND stm.active_yn = 'Y'
473: AND stm.say_code = 'CURR'
1010: -- Get total Asset Cost
1011: CURSOR asset_cost_csr IS
1012: SELECT SUM(fab.cost)
1013: FROM fa_additions_b faa,fa_books fab,okc_k_lines_b cle,
1014: okc_k_headers_b chr,okc_line_styles_b lse,
1015: okc_k_items cim
1016: WHERE faa.asset_id = fab.asset_id
1017: AND cim.object1_id2 = '#'
1018: AND cim.object1_id1 = faa.asset_id