391: IS
392:
393: CURSOR okl_ptqv_pk_csr (p_id IN NUMBER) IS
394: SELECT '1'
395: FROM okl_ptl_qualitys_v
396: WHERE okl_ptl_qualitys_v.id = p_id;
397:
398: l_ptq_status VARCHAR2(1);
399: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
392:
393: CURSOR okl_ptqv_pk_csr (p_id IN NUMBER) IS
394: SELECT '1'
395: FROM okl_ptl_qualitys_v
396: WHERE okl_ptl_qualitys_v.id = p_id;
397:
398: l_ptq_status VARCHAR2(1);
399: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
400: l_row_notfound BOOLEAN := TRUE;