888: RETURN TRUE;
889: END;
890: END unit_class_closed;
891: --
892: -- Validate if IGS_FI_GOV_HEC_PA_OP.govt_hecs_payment_opt is closed.
893: FUNCTION finp_val_ghpo_closed(
894: p_govt_hecs_payment_option IN VARCHAR2 ,
895: p_message_name OUT NOCOPY VARCHAR2 )
896: RETURN BOOLEAN AS
895: p_message_name OUT NOCOPY VARCHAR2 )
896: RETURN BOOLEAN AS
897: gv_other_detail VARCHAR2(255);
898: BEGIN -- finp_val_ghpo_closed
899: -- Validate if IGS_FI_GOV_HEC_PA_OP.govt_hecs_payment_option is closed.
900: DECLARE
901: CURSOR c_ghpo(
902: cp_govt_hecs_payment_option
903: IGS_FI_GOV_HEC_PA_OP.govt_hecs_payment_option%TYPE) IS
899: -- Validate if IGS_FI_GOV_HEC_PA_OP.govt_hecs_payment_option is closed.
900: DECLARE
901: CURSOR c_ghpo(
902: cp_govt_hecs_payment_option
903: IGS_FI_GOV_HEC_PA_OP.govt_hecs_payment_option%TYPE) IS
904: SELECT closed_ind
905: FROM IGS_FI_GOV_HEC_PA_OP
906: WHERE govt_hecs_payment_option = cp_govt_hecs_payment_option;
907: v_ghpo_rec c_ghpo%ROWTYPE;
901: CURSOR c_ghpo(
902: cp_govt_hecs_payment_option
903: IGS_FI_GOV_HEC_PA_OP.govt_hecs_payment_option%TYPE) IS
904: SELECT closed_ind
905: FROM IGS_FI_GOV_HEC_PA_OP
906: WHERE govt_hecs_payment_option = cp_govt_hecs_payment_option;
907: v_ghpo_rec c_ghpo%ROWTYPE;
908: cst_yes CONSTANT CHAR := 'Y';
909: BEGIN