5: FUNCTION CRSP_VAL_ATT_GOVT(
6: p_govt_attendance_type IN VARCHAR2 ,
7: p_message_name OUT NOCOPY VARCHAR2 )
8: RETURN BOOLEAN AS
9: v_closed_ind IGS_PS_GOVT_ATD_TYPE.closed_ind%TYPE;
10: CURSOR c_govt_attendance_type(
11: cp_govt_attendance_type IGS_PS_GOVT_ATD_TYPE.govt_attendance_type%TYPE)IS
12: SELECT closed_ind
13: FROM IGS_PS_GOVT_ATD_TYPE
7: p_message_name OUT NOCOPY VARCHAR2 )
8: RETURN BOOLEAN AS
9: v_closed_ind IGS_PS_GOVT_ATD_TYPE.closed_ind%TYPE;
10: CURSOR c_govt_attendance_type(
11: cp_govt_attendance_type IGS_PS_GOVT_ATD_TYPE.govt_attendance_type%TYPE)IS
12: SELECT closed_ind
13: FROM IGS_PS_GOVT_ATD_TYPE
14: WHERE govt_attendance_type = cp_govt_attendance_type;
15: BEGIN
9: v_closed_ind IGS_PS_GOVT_ATD_TYPE.closed_ind%TYPE;
10: CURSOR c_govt_attendance_type(
11: cp_govt_attendance_type IGS_PS_GOVT_ATD_TYPE.govt_attendance_type%TYPE)IS
12: SELECT closed_ind
13: FROM IGS_PS_GOVT_ATD_TYPE
14: WHERE govt_attendance_type = cp_govt_attendance_type;
15: BEGIN
16: p_message_name := NULL;
17: OPEN c_govt_attendance_type(