The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT 'Y'
FROM okc_rules_v rule,
okc_rule_groups_v rg,
okc_k_lines_b cle,
okc_line_styles_b lsb
WHERE rule.dnz_chr_id = p_chr_id
AND rule_information_category IN ('LASLH','LASLL')
AND rule.object1_id1 = p_strm_id
AND rg.cle_id IS NOT NULL
AND rule.rgp_id = rg.id
-- next few lines bug fix along with property tax payment changes
AND cle.lse_id = lsb.id
AND lsb.lty_code = 'FREE_FORM1'
AND cle.id = rg.cle_id
-- added to handle abandon line
AND NOT EXISTS (
SELECT 'Y'
FROM okc_statuses_v okcsts,
okc_k_lines_b line
WHERE line.id = rg.cle_id
AND line.sts_code = okcsts.code
AND okcsts.ste_code IN ('EXPIRED','HOLD','CANCELLED','TERMINATED'));
SELECT 'Y'
FROM okc_rules_v rule,
okc_rule_groups_v rg,
okc_k_lines_b cleb, -- Top Line
okc_k_lines_b cle, -- Sub Line
okc_line_styles_b lsb
WHERE rule.dnz_chr_id = p_chr_id
AND rule_information_category IN ('LASLH','LASLL')
AND rule.object1_id1 = p_strm_id
AND cleb.id = p_cle_id -- Top Line
AND cleb.id = cle.cle_id -- Top line equals subline cle_id
AND rg.cle_id = cle.id -- Equate with sub-line
AND rule.rgp_id = rg.id
AND cle.lse_id = lsb.id
AND lsb.lty_code = 'LINK_FEE_ASSET'
-- added to handle abandon line
AND NOT EXISTS (
SELECT 'Y'
FROM okc_statuses_v okcsts,
okc_k_lines_b line
WHERE line.id = rg.cle_id
AND line.sts_code = okcsts.code
AND okcsts.ste_code IN ('EXPIRED','HOLD','CANCELLED','TERMINATED'));
SELECT SUM(NVL(okl1.capital_amount,0))
FROM okl_k_lines_full_v okl1, -- fee sub line
okl_k_lines_full_v okl2, -- fee top line
okc_k_items_v item1,
okc_k_items_v item2,
okl_strmtyp_source_v stream
WHERE item1.object1_id1 = TO_CHAR(p_fin_line_id) -- Bug 3830454
AND item1.jtot_object1_code = 'OKX_COVASST' -- Bug 3830454
AND stream.capitalize_yn = 'Y'
AND okl1.id = item1.cle_id
AND okl2.id = okl1.cle_id
AND okl2.id = item2.cle_id
AND item2.object1_id1 = stream.id1;
SELECT
rg.ID,
rg.OBJECT_VERSION_NUMBER,
rg.SFWT_FLAG,
rg.RGD_CODE,
rg.SAT_CODE,
rg.RGP_TYPE,
rg.CLE_ID,
rg.CHR_ID,
rg.DNZ_CHR_ID,
rg.PARENT_RGP_ID,
rg.COMMENTS,
rg.ATTRIBUTE_CATEGORY,
rg.ATTRIBUTE1,
rg.ATTRIBUTE2,
rg.ATTRIBUTE3,
rg.ATTRIBUTE4,
rg.ATTRIBUTE5,
rg.ATTRIBUTE6,
rg.ATTRIBUTE7,
rg.ATTRIBUTE8,
rg.ATTRIBUTE9,
rg.ATTRIBUTE10,
rg.ATTRIBUTE11,
rg.ATTRIBUTE12,
rg.ATTRIBUTE13,
rg.ATTRIBUTE14,
rg.ATTRIBUTE15,
rg.CREATED_BY,
rg.CREATION_DATE,
rg.LAST_UPDATED_BY,
rg.LAST_UPDATE_DATE,
rg.LAST_UPDATE_LOGIN
FROM Okc_Rule_Groups_V rg,
Okc_Rules_V rule
WHERE NVL(rg.chr_id,-9999) = p_chr_id
--AND NVL(rg.cle_id,-9999) = p_cle_id
--AND rg.dnz_chr_id = DECODE(p_chr_id,-9999,rg.dnz_chr_id,p_dnz_chr_id)
AND rg.dnz_chr_id = p_chr_id
AND rule.object1_id1 = p_strm_id
AND rgd_code = DECODE(p_rgd_code,NULL,rgd_code,p_rgd_code)
AND rule.rgp_id = rg.id;
l_rgpv_rec.LAST_UPDATED_BY,
l_rgpv_rec.LAST_UPDATE_DATE,
l_rgpv_rec.LAST_UPDATE_LOGIN;
SELECT
rg.ID,
rg.OBJECT_VERSION_NUMBER,
rg.SFWT_FLAG,
rg.RGD_CODE,
rg.SAT_CODE,
rg.RGP_TYPE,
rg.CLE_ID,
rg.CHR_ID,
rg.DNZ_CHR_ID,
rg.PARENT_RGP_ID,
rg.COMMENTS,
rg.ATTRIBUTE_CATEGORY,
rg.ATTRIBUTE1,
rg.ATTRIBUTE2,
rg.ATTRIBUTE3,
rg.ATTRIBUTE4,
rg.ATTRIBUTE5,
rg.ATTRIBUTE6,
rg.ATTRIBUTE7,
rg.ATTRIBUTE8,
rg.ATTRIBUTE9,
rg.ATTRIBUTE10,
rg.ATTRIBUTE11,
rg.ATTRIBUTE12,
rg.ATTRIBUTE13,
rg.ATTRIBUTE14,
rg.ATTRIBUTE15,
rg.CREATED_BY,
rg.CREATION_DATE,
rg.LAST_UPDATED_BY,
rg.LAST_UPDATE_DATE,
rg.LAST_UPDATE_LOGIN
FROM Okc_Rule_Groups_V rg,
Okc_Rules_V rule
WHERE rg.dnz_chr_id = p_chr_id
AND rg.cle_id = p_cle_id
AND rule.object1_id1 = to_char(p_strm_id)
AND rg.rgd_code = DECODE(p_rgd_code,NULL,rgd_code,p_rgd_code)
AND rule.rgp_id = rg.id;
l_rgpv_rec.LAST_UPDATED_BY,
l_rgpv_rec.LAST_UPDATE_DATE,
l_rgpv_rec.LAST_UPDATE_LOGIN;
SELECT
ID,
OBJECT_VERSION_NUMBER,
SFWT_FLAG,
OBJECT1_ID1,
OBJECT2_ID1,
OBJECT3_ID1,
OBJECT1_ID2,
OBJECT2_ID2,
OBJECT3_ID2,
JTOT_OBJECT1_CODE,
JTOT_OBJECT2_CODE,
JTOT_OBJECT3_CODE,
DNZ_CHR_ID,
RGP_ID,
PRIORITY,
STD_TEMPLATE_YN,
COMMENTS,
WARN_YN,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN,
--TEXT,
RULE_INFORMATION_CATEGORY,
RULE_INFORMATION1,
RULE_INFORMATION2,
RULE_INFORMATION3,
RULE_INFORMATION4,
RULE_INFORMATION5,
RULE_INFORMATION6,
RULE_INFORMATION7,
RULE_INFORMATION8,
RULE_INFORMATION9,
RULE_INFORMATION10,
RULE_INFORMATION11,
RULE_INFORMATION12,
RULE_INFORMATION13,
RULE_INFORMATION14,
RULE_INFORMATION15,
TEMPLATE_YN,
ans_set_jtot_object_code,
ans_set_jtot_object_id1,
ans_set_jtot_object_id2,
DISPLAY_SEQUENCE
FROM Okc_Rules_V
WHERE okc_rules_v.rgp_id = p_rgp_id
AND object1_id1 = p_strm_id
AND RULE_INFORMATION_CATEGORY = DECODE(p_rdf_code,NULL,RULE_INFORMATION_CATEGORY,p_rdf_code);
l_rulv_rec.LAST_UPDATED_BY,
l_rulv_rec.LAST_UPDATE_DATE,
l_rulv_rec.LAST_UPDATE_LOGIN,
--l_rulv_rec.TEXT,
l_rulv_rec.RULE_INFORMATION_CATEGORY,
l_rulv_rec.RULE_INFORMATION1,
l_rulv_rec.RULE_INFORMATION2,
l_rulv_rec.RULE_INFORMATION3,
l_rulv_rec.RULE_INFORMATION4,
l_rulv_rec.RULE_INFORMATION5,
l_rulv_rec.RULE_INFORMATION6,
l_rulv_rec.RULE_INFORMATION7,
l_rulv_rec.RULE_INFORMATION8,
l_rulv_rec.RULE_INFORMATION9,
l_rulv_rec.RULE_INFORMATION10,
l_rulv_rec.RULE_INFORMATION11,
l_rulv_rec.RULE_INFORMATION12,
l_rulv_rec.RULE_INFORMATION13,
l_rulv_rec.RULE_INFORMATION14,
l_rulv_rec.RULE_INFORMATION15,
l_rulv_rec.TEMPLATE_YN,
l_rulv_rec.ans_set_jtot_object_code,
l_rulv_rec.ans_set_jtot_object_id1,
l_rulv_rec.ans_set_jtot_object_id2,
l_rulv_rec.DISPLAY_SEQUENCE ;
SELECT
ID,
OBJECT_VERSION_NUMBER,
SFWT_FLAG,
OBJECT1_ID1,
OBJECT2_ID1,
OBJECT3_ID1,
OBJECT1_ID2,
OBJECT2_ID2,
OBJECT3_ID2,
JTOT_OBJECT1_CODE,
JTOT_OBJECT2_CODE,
JTOT_OBJECT3_CODE,
DNZ_CHR_ID,
RGP_ID,
PRIORITY,
STD_TEMPLATE_YN,
COMMENTS,
WARN_YN,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN,
--TEXT,
RULE_INFORMATION_CATEGORY,
RULE_INFORMATION1,
RULE_INFORMATION2,
RULE_INFORMATION3,
RULE_INFORMATION4,
RULE_INFORMATION5,
RULE_INFORMATION6,
RULE_INFORMATION7,
RULE_INFORMATION8,
RULE_INFORMATION9,
RULE_INFORMATION10,
RULE_INFORMATION11,
RULE_INFORMATION12,
RULE_INFORMATION13,
RULE_INFORMATION14,
RULE_INFORMATION15,
TEMPLATE_YN,
ans_set_jtot_object_code,
ans_set_jtot_object_id1,
ans_set_jtot_object_id2,
DISPLAY_SEQUENCE
FROM Okc_Rules_V
WHERE okc_rules_v.rgp_id = p_rgp_id
AND okc_rules_v.object2_id1 = p_slh_id
AND RULE_INFORMATION_CATEGORY = decode(p_rdf_code,null,RULE_INFORMATION_CATEGORY,p_rdf_code);
l_rulv_rec.LAST_UPDATED_BY,
l_rulv_rec.LAST_UPDATE_DATE,
l_rulv_rec.LAST_UPDATE_LOGIN,
--l_rulv_rec.TEXT,
l_rulv_rec.RULE_INFORMATION_CATEGORY,
l_rulv_rec.RULE_INFORMATION1,
l_rulv_rec.RULE_INFORMATION2,
l_rulv_rec.RULE_INFORMATION3,
l_rulv_rec.RULE_INFORMATION4,
l_rulv_rec.RULE_INFORMATION5,
l_rulv_rec.RULE_INFORMATION6,
l_rulv_rec.RULE_INFORMATION7,
l_rulv_rec.RULE_INFORMATION8,
l_rulv_rec.RULE_INFORMATION9,
l_rulv_rec.RULE_INFORMATION10,
l_rulv_rec.RULE_INFORMATION11,
l_rulv_rec.RULE_INFORMATION12,
l_rulv_rec.RULE_INFORMATION13,
l_rulv_rec.RULE_INFORMATION14,
l_rulv_rec.RULE_INFORMATION15,
l_rulv_rec.TEMPLATE_YN,
l_rulv_rec.ans_set_jtot_object_code,
l_rulv_rec.ans_set_jtot_object_id1,
l_rulv_rec.ans_set_jtot_object_id2,
l_rulv_rec.DISPLAY_SEQUENCE ;
SELECT currency_code
FROM okc_k_headers_v
WHERE id = p_chr_id;
SELECT precision
FROM fnd_currencies
WHERE currency_code = p_curr_code;
SELECT ID
FROM okc_rule_groups_v
WHERE dnz_chr_id = p_chr_id
AND cle_id = p_cle_id
AND rgd_code = 'LALEVL';
SELECT FEE_TYPE
FROM okc_k_lines_b CLEB, okl_k_lines KLE
WHERE CLEB.dnz_chr_id = p_chr_id
AND KLE.ID = p_cle_id
AND KLE.ID = CLEB.ID;
SELECT SUM(NVL(line.capital_amount,0))
FROM okl_k_lines_full_v line
WHERE line.dnz_chr_id = p_chr_id
AND EXISTS ( SELECT 'Y'
FROM okc_line_styles_v style
WHERE line.lse_id = style.id
AND style.lty_code = 'FREE_FORM1'
)
-- added to handle abandon line
AND NOT EXISTS (
SELECT 'Y'
FROM okc_statuses_v okcsts
WHERE okcsts.code = line.sts_code
AND okcsts.ste_code IN ('EXPIRED','HOLD','CANCELLED','TERMINATED'));
* Capital amt at Asset is updated
* with Capitalized Fee line amoutn change
-- Total Capital amount from FEE Top Line
*/
l_fin_amount NUMBER;
SELECT ID
FROM okc_rule_groups_v
WHERE dnz_chr_id = p_chr_id
AND cle_id = p_cle_id
AND rgd_code = 'LALEVL';
SELECT FEE_TYPE
FROM okc_k_lines_b CLEB, okl_k_lines KLE
WHERE CLEB.dnz_chr_id = p_chr_id
AND KLE.ID = p_cle_id
AND KLE.ID = CLEB.ID;
x_sll_rulv_tbl.DELETE;
l_kle_slh_cache_tbl.DELETE;
l_sll_rulv_tbl.DELETE;
SELECT okl.id, okl.capital_amount -- bug# 7661717
FROM okl_k_lines_full_v okl,
okc_line_styles_b ols,
okc_statuses_b okcsts
WHERE okl.dnz_chr_id = p_chr_id
AND okl.lse_id = ols.id
AND ols.lty_code = 'FREE_FORM1'
AND okcsts.code = okl.sts_code
AND okcsts.ste_code NOT IN ('EXPIRED','HOLD','CANCELLED','TERMINATED')
ORDER BY okl.NAME; -- Added Order by for bug# 7661717
SELECT 'Y'
FROM okc_rule_groups_v rg
WHERE NOT EXISTS (SELECT 'Y'
FROM okc_rules_v rule
WHERE rule.rgp_id = rg.id
)
AND rg.dnz_chr_id = p_chr_id
AND rg.rgd_code = 'LALEVL'
AND rg.id = p_rgp_id;
OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'SLH delete: '||x_slh_rulv_tbl_out(i).id);
okl_rule_pub.delete_rule(
p_api_version => 1.0,
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_tbl => l_slh_rulv_del_tbl
);
OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'SLL delete: '||x_sll_rulv_tbl_out(i).id);
okl_rule_pub.delete_rule(
p_api_version => 1.0,
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_tbl => l_sll_rulv_del_tbl
);
okl_rule_pub.delete_rule_group(
p_api_version => 1.0,
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_rgpv_rec => l_rgpv_del_rec
);
SELECT okl.id, okl.capital_amount
FROM okl_k_lines_full_v okl,
okc_line_styles_v ols,
okc_rule_groups_b rgp,
okc_rules_b rul
WHERE okl.dnz_chr_id = p_chr_id
AND okl.lse_id = ols.id
AND ols.lty_code = 'FREE_FORM1'
--AND rul.rule_information_category = 'LAASTK'
AND rul.rule_information_category = 'LAPRTX' -- Bug 3987623
AND rul.dnz_chr_id = p_chr_id
AND rul.rgp_id = rgp.id
AND rul.rule_information1 = 'Y'
AND NVL(rul.rule_information3,'XXX') IN ('ESTIMATED','ESTIMATED_AND_ACTUAL')
AND rgp.rgd_code = 'LAASTX'
AND rgp.dnz_chr_id = p_chr_id
AND rgp.chr_id IS NULL
AND rgp.cle_id = okl.id
-- added to handle abandon line
AND NOT EXISTS (
SELECT 'Y'
FROM okc_statuses_v okcsts
WHERE okcsts.code = okl.sts_code
AND okcsts.ste_code IN ('EXPIRED','HOLD','CANCELLED','TERMINATED'));
SELECT 'Y'
FROM okc_rule_groups_v rg
WHERE NOT EXISTS (SELECT 'Y'
FROM okc_rules_v rule
WHERE rule.rgp_id = rg.id
)
AND rg.dnz_chr_id = p_chr_id
AND rg.rgd_code = 'LALEVL'
AND rg.id = p_rgp_id;
SELECT SUM(NVL(line.oec,0)) tot_cap
FROM okl_k_lines_full_v line,
okc_line_styles_v style,
okc_statuses_v okcsts,
okc_rules_b rule,
okc_rule_groups_b rgp
WHERE line.dnz_chr_id = p_chr_id
AND line.lse_id = style.id
AND style.lty_code = 'FREE_FORM1'
AND okcsts.code = line.sts_code
AND okcsts.ste_code NOT IN ('EXPIRED','HOLD','CANCELLED','TERMINATED')
AND rule.rgp_id = rgp.id
AND rgp.dnz_chr_id = line.dnz_chr_id
AND rgp.rgd_code = 'LAASTX'
AND rule.rule_information_category = 'LAPRTX'
AND rule.rule_information1 = 'Y'
AND NVL(rule.rule_information3,'XXX') IN ('ESTIMATED','ESTIMATED_AND_ACTUAL')
AND rgp.cle_id = line.id
AND rgp.chr_id IS NULL;
OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'SLH delete: '||x_slh_rulv_tbl_out(i).id);
okl_rule_pub.delete_rule(
p_api_version => 1.0,
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_tbl => l_slh_rulv_del_tbl
);
OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'SLL delete: '||x_sll_rulv_tbl_out(i).id);
okl_rule_pub.delete_rule(
p_api_version => 1.0,
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_tbl => l_sll_rulv_del_tbl
);
okl_rule_pub.delete_rule_group(
p_api_version => 1.0,
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_rgpv_rec => l_rgpv_del_rec
);
SELECT kle.id, kle.amount
FROM okc_k_lines_b cleb,
okl_k_lines kle
WHERE cleb.dnz_chr_id = p_chr_id
AND kle.ID = cleb.ID
AND cleb.CLE_ID = p_kle_id
-- AND cleb.sts_code NOT IN ('HOLD','EXPIRED','TERMINATED','CANCELLED');
SELECT 'Y'
FROM okc_statuses_v okcsts
WHERE okcsts.code = cleb.sts_code
AND okcsts.ste_code IN ('EXPIRED','HOLD','CANCELLED','TERMINATED'));
SELECT NVL(kle.amount,0)
FROM okl_k_lines kle
WHERE kle.ID = p_kle_id;
SELECT kle.name
FROM okc_k_lines_v kle
WHERE kle.ID = p_kle_id;
SELECT 'Y'
FROM okc_rule_groups_v rg
WHERE NOT EXISTS (SELECT 'Y'
FROM okc_rules_v rule
WHERE rule.rgp_id = rg.id
)
AND rg.dnz_chr_id = p_chr_id
AND rg.rgd_code = 'LALEVL'
AND rg.id = p_rgp_id;
OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'SLH delete: '||x_slh_rulv_tbl_out(i).id);
okl_rule_pub.delete_rule(
p_api_version => 1.0,
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_tbl => l_slh_rulv_del_tbl
);
OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'SLL delete: '||x_sll_rulv_tbl_out(i).id);
okl_rule_pub.delete_rule(
p_api_version => 1.0,
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_tbl => l_sll_rulv_del_tbl
);
okl_rule_pub.delete_rule_group(
p_api_version => 1.0,
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_rgpv_rec => l_rgpv_del_rec
);
SELECT kle.id, kle.amount
FROM okc_k_lines_b cleb,
okl_k_lines kle
WHERE cleb.dnz_chr_id = p_chr_id
AND kle.ID = cleb.ID
AND cleb.CLE_ID = p_kle_id
-- AND cleb.sts_code NOT IN ('HOLD','EXPIRED','TERMINATED','CANCELLED');
SELECT 'Y'
FROM okc_statuses_v okcsts
WHERE okcsts.code = cleb.sts_code
AND okcsts.ste_code IN ('EXPIRED','HOLD','CANCELLED','TERMINATED'));
SELECT NVL(kle.amount,0)
FROM okl_k_lines kle
WHERE kle.ID = p_kle_id;
SELECT kle.name
FROM okc_k_lines_v kle
WHERE kle.ID = p_kle_id;
SELECT 'Y'
FROM okc_rule_groups_v rg
WHERE NOT EXISTS (SELECT 'Y'
FROM okc_rules_v rule
WHERE rule.rgp_id = rg.id
)
AND rg.dnz_chr_id = p_chr_id
AND rg.rgd_code = 'LALEVL'
AND rg.id = p_rgp_id;
OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'SLH delete: '||x_slh_rulv_tbl_out(i).id);
okl_rule_pub.delete_rule(
p_api_version => 1.0,
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_tbl => l_slh_rulv_del_tbl
);
OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'SLL delete: '||x_sll_rulv_tbl_out(i).id);
okl_rule_pub.delete_rule(
p_api_version => 1.0,
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_tbl => l_sll_rulv_del_tbl
);
okl_rule_pub.delete_rule_group(
p_api_version => 1.0,
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_rgpv_rec => l_rgpv_del_rec
);
PROCEDURE delete_payment(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
p_rgp_id IN OKC_RULE_GROUPS_V.ID%TYPE,
p_rule_id IN OKC_RULES_V.ID%TYPE
) IS
l_api_name VARCHAR2(35) := 'delete_payment';
l_proc_name VARCHAR2(35) := 'DELETE_PAYMENT';
SELECT id
FROM okc_rules_v
WHERE dnz_chr_id = p_chr_id
AND rgp_id = p_rgp_id
AND object2_id1 = p_rule_id
AND rule_information_category = 'LASLL';
SELECT 'Y'
FROM okc_rules_v
WHERE dnz_chr_id = p_chr_id
AND rgp_id = p_rgp_id;
SELECT 'Y'
FROM okc_rules_v
WHERE id = p_rule_id
AND dnz_chr_id = p_chr_id;
okl_rule_pub.delete_rule(
p_api_version => 1.0,
p_init_msg_list => OKC_API.G_FALSE,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_rulv_tbl => l_rulv_tbl
);
okl_rule_pub.delete_rule(
p_api_version => 1.0,
p_init_msg_list => OKC_API.G_FALSE,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_rulv_rec => l_rulv_rec
);
okl_rule_pub.delete_rule_group(
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_rgpv_rec => l_rgpv_rec
);
END delete_payment;