[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT creq.change_type_code
,creq.status_code
,change_request_number
,creq.chr_id orig_agr_chr_id
,chr.scs_code agreement_category
FROM okl_vp_change_requests creq
,okc_k_headers_b chr
WHERE creq.id = cp_change_request_id
AND creq.chr_id = chr.id;
SELECT id
FROM okl_k_headers
WHERE crs_id = cp_change_request_id;
okl_contract_status_pub.update_contract_status(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_khr_status => G_ABANDONED_STS_CODE
,p_chr_id => lv_creq_chr_id
);
'okl_contract_status_pub.update_contract_status G_ABANDONED_STS_CODE returned with status '||x_return_status
);
okl_vp_change_request_pvt.update_change_request_header(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_vcrv_rec => lv_vcrv_rec
,x_vcrv_rec => x_vcrv_rec
);
'okl_vp_change_request_pvt.update_change_request_header returned with status '||x_return_status
);
SELECT chr.short_description
,chr.comments
,chr.description
,chr.end_date
,chr.start_date
,chr.qcl_id
,chr.contract_number
,chr.scs_code
,chr.template_yn
,gov.chr_id_referred
,khr.attribute_category
,khr.attribute1
,khr.attribute2
,khr.attribute3
,khr.attribute4
,khr.attribute5
,khr.attribute6
,khr.attribute7
,khr.attribute8
,khr.attribute9
,khr.attribute10
,khr.attribute11
,khr.attribute12
,khr.attribute13
,khr.attribute14
,khr.attribute15
FROM okc_k_headers_v chr
,okc_governances gov
,okl_k_headers khr
WHERE chr.id = cp_chr_id
AND chr.id = khr.id
AND gov.dnz_chr_id(+) = chr.id;
okl_vendor_program_pvt.update_program(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_hdr_rec => l_agr_hdr_rec
,p_program_id => p_orig_chr_id
,p_parent_agreement_id => cv_hdr_attribs_new.chr_id_referred
);
'okl_vendor_program_pvt.update_program returned with status '||x_return_status||' x_msg_data '||x_msg_data
);
SELECT cpl.id,
cpl.object1_id1,
cpl.object1_id2,
cpl.jtot_object1_code,
cpl.rle_code
FROM okc_k_party_roles_b cpl
WHERE cpl.chr_id = cp_creq_chr_id
AND cpl.jtot_object1_code = 'OKX_PARTY'
AND NOT EXISTS (
SELECT 'Y'
FROM okc_k_party_roles_b orig
WHERE orig.object1_id1 = cpl.object1_id1
AND orig.object1_id2 = cpl.object1_id2
AND orig.jtot_object1_code = cpl.jtot_object1_code
AND orig.rle_code = cpl.rle_code
AND orig.chr_id = cp_orig_chr_id
AND orig.jtot_object1_code = 'OKX_PARTY'
);
SELECT id
,chr_id
,rle_code
,dnz_chr_id
,object1_id1
,object1_id2
,jtot_object1_code
,cognomen party_known_as
,alias
,created_by
,creation_date
,last_updated_by
,last_update_date
,last_update_login
FROM okc_k_party_roles_v
WHERE dnz_chr_id = cp_chr_id
AND jtot_object1_code = 'OKX_PARTY'; -- this indicates non primary parties
SELECT cpl.id
,cpl.chr_id
,cpl.rle_code
,cpl.dnz_chr_id
,cpl.object1_id1
,cpl.object1_id2
,cpl.jtot_object1_code
,cpl.cognomen party_known_as
,cpl.alias
/*
,kpl.attribute_category
,kpl.attribute1
,kpl.attribute2
,kpl.attribute3
,kpl.attribute4
,kpl.attribute5
,kpl.attribute6
,kpl.attribute7
,kpl.attribute8
,kpl.attribute9
,kpl.attribute10
,kpl.attribute11
,kpl.attribute12
,kpl.attribute13
,kpl.attribute14
,kpl.attribute15
*/
FROM okc_k_party_roles_v cpl
/* ,okl_k_party_roles_v kpl */
WHERE cpl.dnz_chr_id = cp_chr_id
AND cpl.object1_id1 = cp_party_id
AND cpl.jtot_object1_code = 'OKX_PARTY'; -- this indicates non primary parties
SELECT id
FROM okc_contacts
WHERE cpl_id = cp_cpl_id;
lv_cplv_rec.last_updated_by := parties_rec.last_updated_by;
lv_cplv_rec.last_update_date := parties_rec.last_update_date;
lv_cplv_rec.last_update_login := parties_rec.last_update_login;
okl_contract_party_pub.update_k_party_role(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_cplv_rec => lv_cplv_rec
,x_cplv_rec => x_cplv_rec
);
'okl_contract_party_pub.update_k_party_role returned with status '||x_return_status
);
okl_contract_party_pub.delete_contact(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_ctcv_tbl => lv_ctcv_tbl
);
'okl_contract_party_pub.delete_contact returned with status '||x_return_status||' contact_tbl_idx '||contact_tbl_idx
);
okl_contract_party_pub.delete_k_party_role(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_cplv_rec => lv_cplv_rec
);
'okl_contract_party_pub.delete_k_party_role returned with status '||x_return_status
);
SELECT role.object1_id1 role_party_id
,role.object1_id2 role_object1_id2
,role.rle_code
,role.jtot_object1_code role_object
,role.dnz_chr_id
,contact.object1_id1 contact_party_id
,contact.object1_id2 contact_object1_id2
,contact.cro_code
,contact.jtot_object1_code contact_object
,contact.id
FROM okc_k_party_roles_b role
,okc_contacts contact
WHERE role.id = contact.cpl_id
AND role.dnz_chr_id = contact.dnz_chr_id
AND role.dnz_chr_id = cp_chr_id_1
AND NOT EXISTS(SELECT 'X'
FROM okc_k_party_roles_b role_new
,okc_contacts contact_new
WHERE role_new.id = contact_new.cpl_id
AND role_new.chr_id = contact_new.dnz_chr_id
AND role_new.object1_id1 = role.object1_id1
AND role_new.object1_id2 = role.object1_id2
AND role_new.jtot_object1_code = role.jtot_object1_code
AND role_new.rle_code = role.rle_code
AND contact_new.object1_id1 = contact.object1_id1
AND contact_new.object1_id2 = contact.object1_id2
AND contact_new.cro_code = contact.cro_code
AND contact_new.jtot_object1_code = contact.jtot_object1_code
AND role_new.chr_id = cp_chr_id_2
);
SELECT id
FROM okc_k_party_roles_b
WHERE dnz_chr_id = cp_dnz_chr_id
AND rle_code = cp_rle_code
AND object1_id1 = cp_object1_id1
AND object1_id2 = cp_object1_id2
AND jtot_object1_code = cp_jtot_object1_code;
* Change Request Agreement are to be deleted. All the Contacts present on the Change Request Agreement and not on the
* Original Agreement are to be added to the Original Contact for that role. Since the Party Roles have already been
* merged in the previous step, there would not be a case where a party on the change request is not found on the original
* agreement.
*
* Technically the same cursor is being used to find the diff between the Contacts by interchanging the values of the
* agreement ids
*/
contact_tbl_idx := 0;
okl_contract_party_pub.delete_contact(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_ctcv_tbl => lv_ctcv_tbl
);
'okl_contract_party_pub.delete_contact returned with status '||x_return_status
);
SELECT change_req.id
,change_req.chr_id
,change_req.sav_sae_id
,change_req.sav_sav_release
,change_req.sbt_code
,change_req.name
,change_req.cat_type
,change_req.text
FROM okc_k_articles_v change_req
where change_req.dnz_chr_id = cp_chr_id -- updated the code
and change_req.chr_id=change_req.dnz_chr_id ; -- for performance issue bug#5484903
* on the original agreement are deleted and the articles from the change request are recorded against the original
* agreement
*/
FOR orig_articles_rec IN c_get_articles_csr(p_orig_chr_id) LOOP
lv_catv_rec := NULL;
okl_vp_k_article_pub.delete_k_article(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_catv_rec => lv_catv_rec
);
'okl_vp_k_article_pub.delete_k_article returned with status '||x_return_status
);
okl_okc_migration_a_pvt.insert_row(
p_api_version => l_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_catv_rec => lv_catv_rec,
x_catv_rec => x_catv_rec);
'okl_okc_migration_a_pvt.insert_row returned with status '||x_return_status
);
SELECT rrd.id
FROM okc_k_headers_b chr
,okc_subclass_roles sre
,okc_role_sources rse
,okc_subclass_rg_defs srd
,okc_rg_role_defs rrd
WHERE chr.id = cp_chr_id
AND sre.scs_code = chr.scs_code
AND sre.rle_code = rse.rle_code
AND rse.rle_code = 'OKL_VENDOR'
AND rse.buy_or_sell = chr.buy_or_sell
AND srd.scs_code = chr.scs_code
AND srd.rgd_code = 'LAVENB'
AND rrd.srd_id = srd.id
AND rrd.sre_id = sre.id;
SELECT id
,object1_id1
FROM okc_k_party_roles_b
WHERE dnz_chr_id = cp_chr_id
AND rle_code = 'OKL_VENDOR'
AND jtot_object1_code = 'OKX_VENDOR';
SELECT chrb.id chr_id,
rgpb.id rgp_id,
cplv.id cpl_id,
rulb.id cust_rule_id,
rulb.object1_id1 cust_id,
hzp.party_name cust_name,
cplv.cust_acct_id cust_acct_id,
hzc.account_number cust_account_number,
hzc.account_name cust_account_name,
cplv.bill_to_site_use_id bill_to_site_use_id,
hzcsu.location bill_to_site_use_name,
cplv.cognomen cognomen,
cplv.alias alias,
chrb.authoring_org_id authoring_org_id
FROM okc_k_headers_b chrb,
okc_k_party_roles_v cplv,
hz_cust_accounts hzc,
hz_cust_site_uses_all hzcsu,
okc_rg_party_roles rgrp,
okc_rule_groups_b rgpb,
hz_parties hzp,
okc_rules_b rulb
WHERE cplv.dnz_chr_id = chrb.id
and cplv.chr_id = chrb.id
and hzc.cust_account_id(+) = cplv.cust_acct_id
and hzcsu.site_use_id(+) = cplv.bill_to_site_use_id
and rgpb.rgd_code(+) = 'LAVENB'
and rgrp.rgp_id = rgpb.id(+)
and rgrp.cpl_id(+) = cplv.id
and rulb.rule_information_category(+) = 'LAVENC'
and rulb.rgp_id(+) = rgpb.id
and hzp.party_id(+) = rulb.object1_id1
and chrb.id = cp_chr_id
and cplv.id = cp_cpl_id;
SELECT chr.id chr_id
,rgp_lavenb.id lavenb_rgp_id
,rul_lainpr.id lainpr_rul_id
,rul_lainpr.rule_information1 rul_lainpr_ri1
-- ,to_date(rul_lainpr.rule_information2,'YYYY/MM/DD HH24:MI:SS') rul_lainpr_ri2
,rul_lainpr.rule_information2 rul_lainpr_ri2
,rul_lainvd.id lainvd_rul_id
,rul_lainvd.rule_information1 rul_lainvd_ri1
,rul_lainvd.rule_information4 rul_lainvd_ri4
,rul_labacc.id labacc_rul_id
,rul_labacc.object1_id1 rul_labacc_o1id1
,rul_labacc.object1_id2 rul_labacc_o1id2
,rul_lapmth.id lapmth_rul_id
,rul_lapmth.object1_id1 rul_lapmth_o1id1
,rul_lapmth.object1_id2 rul_lapmth_o1id2
FROM okc_k_headers_b chr
,okl_k_headers khr
,okc_rule_groups_b rgp_lavenb
,okc_rules_b rul_lainpr
,okc_rules_b rul_lainvd
,okc_rules_b rul_labacc
,okc_rules_b rul_lapmth
WHERE chr.id = khr.id
AND rgp_lavenb.dnz_chr_id(+) = chr.id
AND rgp_lavenb.rgd_code(+) = 'LAVENB'
AND rgp_lavenb.id = rul_lainpr.rgp_id(+)
AND rul_lainpr.rule_information_category(+) = 'LAINPR'
AND rgp_lavenb.id = rul_lainvd.rgp_id(+)
AND rul_lainvd.rule_information_category(+) = 'LAINVD'
AND rgp_lavenb.id = rul_labacc.rgp_id(+)
AND rul_labacc.rule_information_category(+) = 'LABACC'
AND rgp_lavenb.id = rul_lapmth.rgp_id(+)
AND rul_lapmth.rule_information_category(+) = 'LAPMTH'
AND chr.id = cp_chr_id;
lv_cplv_rec.last_updated_by := fnd_global.user_id;
lv_cplv_rec.last_update_date := trunc(sysdate);
lv_cplv_rec.last_update_login := fnd_global.login_id;
okl_contract_party_pub.update_k_party_role(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_cplv_rec => lv_cplv_rec
,x_cplv_rec => x_cplv_rec
);
'okl_contract_party_pub.update_k_party_role returned with status '||x_return_status
);
lv_rgr_tbl(idx).last_updated_by := fnd_global.user_id;
lv_rgr_tbl(idx).last_update_date := trunc(sysdate);
lv_rgr_tbl(idx).last_update_login := fnd_global.login_id;
lv_rgr_tbl.DELETE;
SELECT crs_id
,start_date
,end_date
,description
,assoc_object_type_code
,assoc_object_id
,assoc_object_version
FROM okl_vp_associations
WHERE crs_id = cp_change_request_id
AND chr_id = cp_chr_id
AND assoc_object_id = cp_assoc_object_id
AND assoc_object_type_code = cp_assoc_object_code
AND nvl(assoc_object_version,1) = nvl(cp_assoc_object_version,1);
SELECT chr_id
,start_date
,end_date
,description
,assoc_object_type_code
,assoc_object_id
,assoc_object_version
,id
FROM okl_vp_associations
WHERE crs_id IS NULL
AND chr_id = cp_chr_id;
SELECT creq.chr_id
,creq.crs_id
,creq.start_date
,creq.end_date
,creq.description
,creq.assoc_object_type_code
,creq.assoc_object_id
,creq.assoc_object_version
FROM okl_vp_associations creq
WHERE crs_id = cp_change_request_id
AND NOT EXISTS (
SELECT 'X'
FROM okl_vp_associations orig
WHERE orig.chr_id = cp_chr_id
AND orig.crs_id IS NULL
AND orig.start_date = creq.start_date
AND NVL(orig.end_date, TRUNC(SYSDATE)) = NVL(creq.end_date,TRUNC(SYSDATE))
AND NVL(orig.description, 'X') = NVL(creq.description, 'X')
AND orig.assoc_object_type_code = creq.assoc_object_type_code
AND orig.assoc_object_id = creq.assoc_object_id
AND NVL(orig.assoc_object_version,1) = NVL(creq.assoc_object_version,1)
);
okl_vp_associations_pvt.update_vp_associations(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_vasv_rec => lv_vasv_rec
,x_vasv_rec => x_vasv_rec
);
'okl_vp_associations_pvt.update_vp_associations returned with status '||x_return_status
);
okl_vp_associations_pvt.delete_vp_associations(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_vasv_rec => lv_vasv_rec
);
'okl_vp_associations_pvt.delete_vp_associations returned with status '||x_return_status
);
SELECT crs_id
,start_date
,end_date
,description
,assoc_object_type_code
,assoc_object_id
,assoc_object_version
FROM okl_vp_associations
WHERE chr_id = cp_chr_id
AND assoc_object_id = cp_assoc_object_id
AND assoc_object_type_code = cp_assoc_object_code
AND nvl(assoc_object_version,1) = nvl(cp_assoc_object_version,1);
SELECT chr_id
,start_date
,end_date
,description
,assoc_object_type_code
,assoc_object_id
,assoc_object_version
,id
FROM okl_vp_associations
WHERE crs_id IS NULL
AND chr_id = cp_chr_id;
SELECT creq.chr_id
,creq.crs_id
,creq.start_date
,creq.end_date
,creq.description
,creq.assoc_object_type_code
,creq.assoc_object_id
,creq.assoc_object_version
FROM okl_vp_associations creq
WHERE chr_id = cp_chr_id_creq
AND NOT EXISTS (
SELECT 'X'
FROM okl_vp_associations orig
WHERE orig.chr_id = cp_chr_id_orig
AND orig.crs_id IS NULL
AND orig.start_date = creq.start_date
AND NVL(orig.end_date, TRUNC(SYSDATE)) = NVL(creq.end_date,TRUNC(SYSDATE))
AND NVL(orig.description, 'X') = NVL(creq.description, 'X')
AND orig.assoc_object_type_code = creq.assoc_object_type_code
AND orig.assoc_object_id = creq.assoc_object_id
AND NVL(orig.assoc_object_version,1) = NVL(creq.assoc_object_version,1)
);
okl_vp_associations_pvt.update_vp_associations(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_vasv_rec => lv_vasv_rec
,x_vasv_rec => x_vasv_rec
);
'okl_vp_associations_pvt.update_vp_associations returned with status '||x_return_status
);
okl_vp_associations_pvt.delete_vp_associations(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_vasv_rec => lv_vasv_rec
);
'okl_vp_associations_pvt.delete_vp_associations returned with status '||x_return_status
);
SELECT start_date
,end_date
FROM okc_k_headers_b
WHERE id = cp_chr_id;
okl_ecc_values_pvt.delete_eligibility_criteria(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_source_id => p_orig_chr_id
,p_source_type => G_VENDOR_PROGRAM_CODE
);
'okl_ecc_values_pvt.delete_eligibility_criteria returned with status '||x_return_status
);
SELECT orig.id
,orig.dnz_chr_id
,orig.rgd_code
FROM okc_rule_groups_v orig
WHERE chr_id = cp_orig_chr_id
AND cle_id IS NULL
AND dnz_chr_id = cp_orig_chr_id
AND NOT EXISTS (
SELECT 'X'
FROM okc_rule_groups_v creq
WHERE creq.chr_id = cp_creq_chr_id
AND creq.rgd_code = orig.rgd_code
AND creq.dnz_chr_id = cp_creq_chr_id
AND creq.cle_id IS NULL);
SELECT creq.id
,creq.dnz_chr_id
,creq.rgd_code
FROM okc_rule_groups_v creq
WHERE chr_id = cp_creq_chr_id
AND cle_id IS NULL
AND dnz_chr_id = cp_creq_chr_id
AND EXISTS (
SELECT 'X'
FROM okc_rule_groups_v orig
WHERE orig.chr_id = cp_orig_chr_id
AND orig.rgd_code = creq.rgd_code
AND orig.dnz_chr_id = cp_orig_chr_id
AND orig.cle_id IS NULL);
SELECT rul.id
,rul.rgp_id
,rul.object_version_number
FROM okc_rules_b rul
,okc_rule_groups_b rgp
WHERE rgp.id = rul.rgp_id
AND rgp.chr_id = rul.dnz_chr_id
AND rul.rule_information_category = cp_rul_info_cat
AND rgp.chr_id = cp_chr_id
AND rgp.rgd_code = cp_rgd_code;
SELECT creq.id
,creq.dnz_chr_id
,creq.rgd_code
,creq.rgp_type
FROM okc_rule_groups_v creq
WHERE chr_id = cp_creq_chr_id
AND cle_id IS NULL
AND dnz_chr_id = cp_creq_chr_id
AND NOT EXISTS (
SELECT 'X'
FROM okc_rule_groups_v orig
WHERE orig.chr_id = cp_orig_chr_id
AND orig.rgd_code = creq.rgd_code
AND orig.dnz_chr_id = cp_orig_chr_id
AND orig.cle_id IS NULL);
SELECT id
FROM okc_rule_groups_b
WHERE dnz_chr_id = cp_chr_id
AND rgd_code = 'VGLRS';
SELECT cpl.id
FROM okc_k_party_roles_b cpl
,okc_k_party_roles_b cpl1
WHERE cpl.chr_id = cp_orig_chr_id
AND cpl.rle_code = cpl1.rle_code
AND cpl1.chr_id = cp_creq_chr_id
AND cpl.object1_id1 = cpl1.object1_id1
AND cpl.object1_id2 = cpl1.object1_id2
AND cpl.jtot_object1_code = cpl1.jtot_object1_code
AND cpl1.id = cp_cpl_id;
okl_vp_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_tbl => lv_rgpv_del_tbl
);
okl_vp_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_tbl => lv_rgpv_del_tbl
);
SELECT pay.pay_site_id
,pay.payment_term_id
,pay.payment_method_code
,pay.pay_group_code
,pay.vendor_id
,pay.id
,role.rle_code
,role.object1_id1
,role.object1_id2
,role.jtot_object1_code
,role.id cpl_id
FROM okl_party_payment_dtls pay
,okc_k_party_roles_b role
WHERE pay.cpl_id = role.id
AND role.cle_id IS NULL
AND role.dnz_chr_id = cp_chr_id;
SELECT role.id
,payment.id payment_id
FROM okc_k_party_roles_b role
,okl_party_payment_dtls payment
WHERE role.dnz_chr_id = p_orig_chr_id
AND role.chr_id IS NOT NULL
AND role.chr_id = cp_chr_id
AND role.rle_code = cp_rle_code
AND role.object1_id1 = cp_object1_id1
AND role.object1_id2 = cp_object1_id2
AND role.jtot_object1_code = cp_jtot_code
AND role.id = payment.cpl_id;
SELECT role.id
FROM okc_k_party_roles_b role
WHERE role.dnz_chr_id = cp_chr_id
AND role.chr_id IS NOT NULL
AND role.chr_id = p_orig_chr_id
AND role.rle_code = cp_rle_code
AND role.object1_id1 = cp_object1_id1
AND role.object1_id2 = cp_object1_id2
AND role.jtot_object1_code = cp_jtot_code;
OKL_VP_PARTY_PAYMENT_PVT.update_party_pymnt_dtls(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_srfvv_rec => lv_srfvv_rec
,x_srfvv_rec => x_srfvv_rec
);
okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT, l_module, 'okl_subsidy_rfnd_dtls_pvt.update_refund_dtls '|| x_return_status);