[Home] [Help]
1: PACKAGE BODY OKL_BPD_TERMINATION_ADJ_PVT AS
2: /* $Header: OKLRBAJB.pls 120.17 2007/04/03 23:16:53 rmunjulu noship $ */
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;
433: AND khs.code = khr.sts_code
434: AND khs.ste_code = 'ACTIVE'
435: AND stm.kle_id = kle.id(+)
436: AND nvl(stm.kle_id, -99) = nvl(cp_kle_id, nvl(stm.kle_id, -99))
437: AND OKL_BPD_TERMINATION_ADJ_PVT.get_kle_status_code(stm.kle_id) IN ('ACTIVE', 'TERMINATED', 'HEADER_LEVEL')
438: ORDER BY 1, 2, 3;
439: -- akrangan bug 5655680 -- start
440: --cursor to check if financial asset appears as linked asset
441: CURSOR l_lnk_ast_csr (p_line_id OKC_K_LINES_B.ID%TYPE) IS
584: AND khs.code = khr.sts_code
585: AND khs.ste_code = 'ACTIVE'
586: AND stm.kle_id = kle.id(+)
587: AND nvl(stm.kle_id, -99) = nvl(cp_kle_id, nvl(stm.kle_id, -99))
588: AND OKL_BPD_TERMINATION_ADJ_PVT.get_kle_status_code(stm.kle_id) IN ('ACTIVE', 'TERMINATED', 'HEADER_LEVEL')
589: ORDER BY 1, 2, 3;
590: BEGIN
591: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
592: G_PKG_NAME,
791: AND khs.code = khr.sts_code
792: AND khs.ste_code = 'ACTIVE'
793: AND stm.kle_id = kle.id(+)
794: AND nvl(stm.kle_id, -99) = nvl(cp_kle_id, nvl(stm.kle_id, -99))
795: AND OKL_BPD_TERMINATION_ADJ_PVT.get_kle_status_code(stm.kle_id) IN ('ACTIVE', 'TERMINATED', 'HEADER_LEVEL')
796: AND exists (select 1 from okc_rule_groups_b rgp
797: , okc_rules_b rul
798: where rgp.dnz_chr_id = kle.dnz_chr_id
799: and rgp.cle_id = kle.id
1016: );
1017: END create_rbk_passthru_adj;
1018:
1019: ---------------------------------------------------------------------------
1020: END OKL_BPD_TERMINATION_ADJ_PVT;