3768: and cleb_sub.dnz_chr_id = cleb_sub.dnz_chr_id
3769: and cleb_sub.sts_code <> 'ABANDONED';
3770:
3771: l_new_cpl_id number;
3772: l_ppydv_rec okl_pyd_pvt.ppydv_rec_type;
3773: x_ppydv_rec okl_pyd_pvt.ppydv_rec_type;
3774:
3775: begin
3776:
3769: and cleb_sub.sts_code <> 'ABANDONED';
3770:
3771: l_new_cpl_id number;
3772: l_ppydv_rec okl_pyd_pvt.ppydv_rec_type;
3773: x_ppydv_rec okl_pyd_pvt.ppydv_rec_type;
3774:
3775: begin
3776:
3777: x_return_status := OKL_API.G_RET_STS_SUCCESS;
3825:
3826: -------------------------------------------------------
3827: --call API to create record
3828: -------------------------------------------------------
3829: OKL_PYD_PVT.Insert_Row
3830: (p_api_version => p_api_version,
3831: p_init_msg_list => p_init_msg_list,
3832: x_return_status => x_return_status,
3833: x_msg_count => x_msg_count,