474: l_aes_status VARCHAR2(1);
475: l_row_notfound BOOLEAN := TRUE;
476: CURSOR okl_aesv_pk_csr (p_id IN NUMBER) IS
477: SELECT '1'
478: FROM okl_ae_tmpt_sets_v
479: WHERE okl_ae_tmpt_sets_v.id = p_id;
480:
481: BEGIN
482: -- initialize return status
475: l_row_notfound BOOLEAN := TRUE;
476: CURSOR okl_aesv_pk_csr (p_id IN NUMBER) IS
477: SELECT '1'
478: FROM okl_ae_tmpt_sets_v
479: WHERE okl_ae_tmpt_sets_v.id = p_id;
480:
481: BEGIN
482: -- initialize return status
483: x_return_status := OKC_API.G_RET_STS_SUCCESS;