83: RETURN VARCHAR2 IS
84: item_not_found_error EXCEPTION;
85: CURSOR cc_pk_csr (p_coverage_id IN NUMBER) IS
86: SELECT *
87: FROM Cs_Coverages
88: WHERE cs_coverages.coverage_id = p_coverage_id;
89: l_cc_pk cc_pk_csr%ROWTYPE;
90: CURSOR cs_contract_templates_pk_csr (p_contract_template_id IN NUMBER) IS
91: SELECT *
84: item_not_found_error EXCEPTION;
85: CURSOR cc_pk_csr (p_coverage_id IN NUMBER) IS
86: SELECT *
87: FROM Cs_Coverages
88: WHERE cs_coverages.coverage_id = p_coverage_id;
89: l_cc_pk cc_pk_csr%ROWTYPE;
90: CURSOR cs_contract_templates_pk_csr (p_contract_template_id IN NUMBER) IS
91: SELECT *
92: FROM Cs_Contract_Templates