2039: return boolean is
2040:
2041: CURSOR occ_cur (tfr_id number,p_occ_series varchar2) IS
2042: select occ_code
2043: from ghr_mass_transfer_criteria
2044: where MASS_TRANSFER_ID = tfr_id
2045: and occ_code = p_occ_series;
2046:
2047: CURSOR occ_cur_cnt (tfr_id number) is
2045: and occ_code = p_occ_series;
2046:
2047: CURSOR occ_cur_cnt (tfr_id number) is
2048: select count(*) COUNT
2049: from ghr_mass_transfer_criteria
2050: where MASS_TRANSFER_ID = tfr_id;
2051:
2052: l_cnt number := 0;
2053: l_occ_code varchar2(30) := null;