58: CURSOR c_get_chr_csr(cp_cpl_id okc_k_party_roles_b.id%TYPE)IS
59: SELECT dnz_chr_id
60: FROM okc_k_party_roles_b
61: WHERE id = cp_cpl_id;
62: lv_dnz_chr_id okc_k_headers_b.id%TYPE;
63:
64: BEGIN
65: x_return_status := l_return_status;
66: -- Call start_activity to create savepoint, check compatibility
515: CURSOR c_get_chr_csr(cp_cpl_id okc_k_party_roles_b.id%TYPE)IS
516: SELECT dnz_chr_id
517: FROM okc_k_party_roles_b
518: WHERE id = cp_cpl_id;
519: lv_dnz_chr_id okc_k_headers_b.id%TYPE;
520:
521: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_PARTY_PYMNT_DTLS';
522: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
523: BEGIN