209: l_return_error_exc EXCEPTION;
210: l_children_exist BOOLEAN := FALSE;
211:
212: CURSOR chk_csr (
213: p_cp_service_id IN CS_CONTRACT_COV_LEVELS.CP_SERVICE_ID%TYPE) IS
214: SELECT *
215: FROM cs_contract_cov_levels
216: WHERE cp_service_id = p_cp_service_id;
217:
211:
212: CURSOR chk_csr (
213: p_cp_service_id IN CS_CONTRACT_COV_LEVELS.CP_SERVICE_ID%TYPE) IS
214: SELECT *
215: FROM cs_contract_cov_levels
216: WHERE cp_service_id = p_cp_service_id;
217:
218: l_cov_lvls_tbl contract_cov_lvls_tbl_type;
219: ------------------------------------------
461: ) RETURN VARCHAR2 IS
462: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
463: l_return_error_exc EXCEPTION;
464: l_overlap_flag VARCHAR2(1) := 'N';
465: CURSOR chk_csr (p_cp_service_id IN CS_CONTRACT_COV_LEVELS.CP_SERVICE_ID%TYPE) IS
466: SELECT *
467: FROM cs_contract_cov_levels cccl
468: WHERE cp_service_id = p_cp_service_id
469: AND NOT EXISTS (SELECT 'x'
463: l_return_error_exc EXCEPTION;
464: l_overlap_flag VARCHAR2(1) := 'N';
465: CURSOR chk_csr (p_cp_service_id IN CS_CONTRACT_COV_LEVELS.CP_SERVICE_ID%TYPE) IS
466: SELECT *
467: FROM cs_contract_cov_levels cccl
468: WHERE cp_service_id = p_cp_service_id
469: AND NOT EXISTS (SELECT 'x'
470: FROM cs_covered_products ccp
471: WHERE ccp.coverage_level_id = cccl.coverage_level_id);