5: FUNCTION crsp_val_fos_govt(
6: p_govt_field_of_study IN VARCHAR2 ,
7: p_message_name OUT NOCOPY VARCHAR2 )
8: RETURN BOOLEAN AS
9: v_closed_ind IGS_RE_GV_FLD_OF_SDY.closed_ind%TYPE;
10: CURSOR c_govt_field_of_study IS
11: SELECT closed_ind
12: FROM IGS_RE_GV_FLD_OF_SDY
13: WHERE govt_field_of_study = p_govt_field_of_study;
8: RETURN BOOLEAN AS
9: v_closed_ind IGS_RE_GV_FLD_OF_SDY.closed_ind%TYPE;
10: CURSOR c_govt_field_of_study IS
11: SELECT closed_ind
12: FROM IGS_RE_GV_FLD_OF_SDY
13: WHERE govt_field_of_study = p_govt_field_of_study;
14: BEGIN
15: OPEN c_govt_field_of_study;
16: FETCH c_govt_field_of_study INTO v_closed_ind;