40: FUNCTION crsp_val_cty_group(
41: p_course_type_group_cd IN VARCHAR2 ,
42: p_message_name OUT NOCOPY VARCHAR2 )
43: RETURN BOOLEAN AS
44: v_closed_ind IGS_PS_TYPE_GRP.closed_ind%TYPE;
45: CURSOR c_course_type_group IS
46: SELECT closed_ind
47: FROM IGS_PS_TYPE_GRP
48: WHERE course_type_group_cd = p_course_type_group_cd;
43: RETURN BOOLEAN AS
44: v_closed_ind IGS_PS_TYPE_GRP.closed_ind%TYPE;
45: CURSOR c_course_type_group IS
46: SELECT closed_ind
47: FROM IGS_PS_TYPE_GRP
48: WHERE course_type_group_cd = p_course_type_group_cd;
49: BEGIN
50: OPEN c_course_type_group;
51: FETCH c_course_type_group INTO v_closed_ind;