1652: l_lessor_payee VARCHAR2(1);
1653: l_chrid NUMBER;
1654: l_siteid NUMBER;
1655: l_requestor_userid NUMBER;
1656: l_policy_rec okl_insurance_policies_pub.ipyv_rec_type;
1657: lx_return_status VARCHAR2(1);
1658: lx_msg_count NUMBER;
1659: lx_msg_data VARCHAR2(100);
1660: lx_policy_rec okl_insurance_policies_pub.ipyv_rec_type;
1656: l_policy_rec okl_insurance_policies_pub.ipyv_rec_type;
1657: lx_return_status VARCHAR2(1);
1658: lx_msg_count NUMBER;
1659: lx_msg_data VARCHAR2(100);
1660: lx_policy_rec okl_insurance_policies_pub.ipyv_rec_type;
1661: api_exception exception;
1662: l_respString VARCHAR2(15);
1663: l_respId NUMBER;
1664: l_resp_key VARCHAR2(30);
2682: l_ipyv_rec.cancellation_comment := p_cancelcomment;
2683: l_ipyv_rec.cancellation_date := p_canceldate;
2684:
2685: if (l_iss_code='PENDING' OR l_iss_code='ACCEPTED') THEN
2686: OKL_INSURANCE_POLICIES_PUB.delete_policy(
2687: p_api_version,
2688: p_init_msg_list => l_init_msg_list,
2689: x_return_status => l_return_status,
2690: x_msg_count => l_msg_count,
2691: x_msg_data => l_msg_data,
2692: p_ipyv_rec => l_ipyv_rec,
2693: x_ipyv_rec => lx_ipyv_rec);
2694: ELSE
2695: OKL_INSURANCE_POLICIES_PUB.cancel_policy(
2696: p_api_version,
2697: p_init_msg_list => l_init_msg_list,
2698: x_return_status => l_return_status,
2699: x_msg_count => l_msg_count,