[Home] [Help]
257: p_khr_id IN NUMBER,
258: p_rulv_rec IN OKC_RULE_PUB.rulv_rec_type,
259: p_rgd_code IN OKL_OPT_RULES.rgr_rgd_code%TYPE,
260: p_rdf_code IN OKL_OPT_RULES.rgr_rdf_code%TYPE,
261: p_copy_or_enter_flag IN OKL_OPV_RULES.copy_or_enter_flag%TYPE) IS
262:
263: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
264: l_api_name CONSTANT VARCHAR2(30) := 'CHK_AND_CPY_RUL_HDR';
265: l_api_version CONSTANT NUMBER := 1.0;
444: p_rulv_rec IN OKC_RULE_PUB.rulv_rec_type,
445: p_rgd_code IN OKL_OPT_RULES.rgr_rgd_code%TYPE,
446: p_rdf_code IN OKL_OPT_RULES.rgr_rdf_code%TYPE,
447: p_lse_id IN OKL_OPT_RULES.lrg_lse_id%TYPE,
448: p_copy_or_enter_flag IN OKL_OPV_RULES.copy_or_enter_flag%TYPE) IS
449:
450: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
451: l_api_name CONSTANT VARCHAR2(30) := 'CHK_AND_CPY_RUL_LINE';
452: l_api_version CONSTANT NUMBER := 1.0;
689: l_slctd_opt_rec l_slctd_opt_csr%ROWTYPE;
690:
691: --cursor to get product option values
692: CURSOR l_pdt_opt_vals_csr (p_pov_id IN NUMBER) is
693: SELECT pov.OVE_ID, --required fk to okl_opt_values (okl_opv_rules_v.ove_id)
694: pov.ID,
695: pov.PON_ID,
696: pon.opt_id --product option id fk okl_pdt_opts
697: FROM OKL_PDT_OPT_VALS pov,
708:
709:
710: --cursor to fetch option value rules
711: CURSOR l_opv_ruls_csr (p_ove_id IN NUMBER) is
712: SELECT ovd.OVE_ID, -- fk to okl_opt_values (okl_opv_rules_v.ove_id)
713: ovd.ID,
714: ovd.ORL_ID, --required fk to okl_opt_ruls
715: ovd.CONTEXT_INTENT, --should be same as khr intent
716: ovd.COPY_OR_ENTER_FLAG, --if it 'CPY' copy to k and do not allow modfn, else sllow mdfn
717: ovd.CONTEXT_INV_ORG, --should be same as khr inv org
718: ovd.CONTEXT_ORG, --should be same as contract org_id
719: ovd.CONTEXT_ASSET_BOOK, --what chk on this??
720: ovd.INDIVIDUAL_INSTRUCTIONS
721: FROM OKL_OPV_RULES ovd,
722: OKL_OPT_VALUES ove
723: WHERE ovd.ove_id = ove.id
724: AND nvl(ove.FROM_DATE,sysdate) <= sysdate
725: AND nvl(ove.TO_DATE,sysdate+1) > sysdate
729:
730: --cursor to get rule id from option value rule templates (okl_ovd_rul_tmls)
731: CURSOR l_ovd_rul_tmls_csr (p_ovd_id IN NUMBER) is
732: SELECT RUL_ID, --required fk to okc_rules_v.id
733: OVD_ID --fk to okl_opv_rules.id
734: FROM OKL_OVD_RUL_TMLS
735: WHERE OVD_ID = p_ovd_id; --(p_ovd_id will be id fetched in the last cursor)
736:
737: l_ovd_rul_tmls_rec l_ovd_rul_tmls_csr%ROWTYPE;