[Home] [Help]
1: PACKAGE BODY OKL_BPD_TERMINATION_ADJ_PVT AS
2: /* $Header: OKLRBAJB.pls 120.17.12010000.5 2010/03/17 12:04:28 nikshah ship $ */
3:
4: G_MODULE VARCHAR2(255) := 'okl.stream.esg.okl_esg_transport_pvt';
5: G_DEBUG_ENABLED CONSTANT VARCHAR2(10) := OKL_DEBUG_PUB.CHECK_LOG_ENABLED;
435: AND stm.kle_id = kle.id(+)
436: AND ((khr.sts_code = 'EVERGREEN' AND sty.STREAM_TYPE_PURPOSE <> 'ACTUAL_PROPERTY_TAX')
437: OR khr.sts_code <> 'EVERGREEN') -- Bug 9306259
438: AND nvl(stm.kle_id, -99) = nvl(cp_kle_id, nvl(stm.kle_id, -99))
439: AND OKL_BPD_TERMINATION_ADJ_PVT.get_kle_status_code(stm.kle_id) IN ('ACTIVE', 'TERMINATED', 'HEADER_LEVEL')
440: ORDER BY 1, 2, 3;
441: -- akrangan bug 5655680 -- start
442: --cursor to check if financial asset appears as linked asset
443: CURSOR l_lnk_ast_csr (p_line_id OKC_K_LINES_B.ID%TYPE) IS
660: AND khs.code = khr.sts_code
661: AND khs.ste_code = 'ACTIVE'
662: AND stm.kle_id = kle.id(+)
663: AND nvl(stm.kle_id, -99) = nvl(cp_kle_id, nvl(stm.kle_id, -99))
664: AND OKL_BPD_TERMINATION_ADJ_PVT.get_kle_status_code(stm.kle_id) IN ('ACTIVE', 'TERMINATED', 'HEADER_LEVEL')
665: ORDER BY 1, 2, 3;
666: BEGIN
667: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
668: G_PKG_NAME,
867: AND khs.code = khr.sts_code
868: AND khs.ste_code = 'ACTIVE'
869: AND stm.kle_id = kle.id(+)
870: AND nvl(stm.kle_id, -99) = nvl(cp_kle_id, nvl(stm.kle_id, -99))
871: AND OKL_BPD_TERMINATION_ADJ_PVT.get_kle_status_code(stm.kle_id) IN ('ACTIVE', 'TERMINATED', 'HEADER_LEVEL')
872: AND exists (select 1 from okc_rule_groups_b rgp
873: , okc_rules_b rul
874: where rgp.dnz_chr_id = kle.dnz_chr_id
875: and rgp.cle_id = kle.id
1092: );
1093: END create_rbk_passthru_adj;
1094:
1095: ---------------------------------------------------------------------------
1096: END OKL_BPD_TERMINATION_ADJ_PVT;