The following lines contain the word 'select', 'insert', 'update' or 'delete':
-- Start 4042157 fmiao 12/03/04 added update_from_contract --
lv_update_from_contract okl_property_tax_setups.update_from_contract%TYPE;
-- End 4042157 fmiao 12/03/04 added update_from_contract --
l_api_name CONSTANT VARCHAR2(30) := 'CREATE_EST_PROP_TAX_RULES';
-- Start 4042157 fmiao 12/03/04 added update_from_contract --
CURSOR get_est_prop_tax_info(p_chr_id okc_k_headers_b.id%TYPE) IS
SELECT enable_asset_default, property_tax_applicable,
bill_property_tax,update_from_contract
FROM okl_property_tax_setups
WHERE org_id = (SELECT authoring_org_id
FROM okc_k_headers_b
WHERE id = p_chr_id);
-- End 4042157 fmiao 12/03/04 added update_from_contract --
BEGIN
x_return_status := OKL_API.G_RET_STS_SUCCESS;
lv_update_from_contract;
-- Start 4042157 fmiao 12/03/04 added update_from_contract --
l_rulv_rec.rule_information_category := 'LAASTK';
IF (lv_update_from_contract = 'YES') THEN
l_rulv_rec.rule_information1 := 'Y';
-- Start 4042157 fmiao 12/03/04 added update_from_contract --
END IF;
SELECT property_tax_applicable,
bill_property_tax
FROM okl_property_tax_setups
WHERE org_id = (SELECT authoring_org_id
FROM okc_k_headers_b
WHERE id = p_chr_id);
SELECT rul.rule_information1, rul.rule_information2, rul.rule_information3
FROM OKC_RULES_V rul,
OKC_RULE_GROUPS_V rgp
WHERE rul.rgp_id = rgp.id
AND rgp.dnz_chr_id = p_chr_id
AND rgp.cle_id is NULL
AND rgp.rgd_code = 'LAHDTX'
AND rul.rule_information_category = 'LAPRTX';
SELECT cle.id
FROM OKC_K_LINES_V cle,
OKC_LINE_STYLES_V lse
WHERE cle.lse_id = lse.id
AND lse.lty_code = 'FREE_FORM1'
AND lse.lse_type = 'TLS'
AND cle.dnz_chr_id = p_chr_id;
SELECT rul.rule_information1
FROM OKC_RULES_V rul,
OKC_RULE_GROUPS_V rgp
WHERE rul.rgp_id = rgp.id
AND rgp.dnz_chr_id = p_chr_id
AND rgp.cle_id = p_cle_id
AND rgp.rgd_code = 'LAASTX'
AND rul.rule_information_category = 'LAASTK';
SELECT rul.id
FROM OKC_RULES_V rul,
OKC_RULE_GROUPS_V rgp
WHERE rul.rgp_id = rgp.id
AND rgp.dnz_chr_id = p_chr_id
AND rgp.cle_id = p_cle_id
AND rgp.rgd_code = 'LAASTX'
AND rul.rule_information_category = 'LAPRTX';
OKL_RULE_PUB.update_rule(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_rulv_rec => l_rulv_rec,
x_rulv_rec => lx_rulv_rec);