APPS.IGS_EN_VAL_SCA dependencies on IGS_FI_FEE_CAT

Line 2688: -- Validate if IGS_FI_FEE_CAT.fee_cat is closed.

2684: -- record with the specified Fee Category.
2685: -- was invoked from IGS_EN_STDNT_PS_ATT_PKG.
2686:
2687: --
2688: -- Validate if IGS_FI_FEE_CAT.fee_cat is closed.
2689: FUNCTION finp_val_fc_closed(
2690: p_fee_cat IN VARCHAR2 ,
2691: p_message_name OUT NOCOPY VARCHAR2)
2692: RETURN BOOLEAN AS

Line 2694: --Validate if IGS_FI_FEE_CAT.fee_cat is closed

2690: p_fee_cat IN VARCHAR2 ,
2691: p_message_name OUT NOCOPY VARCHAR2)
2692: RETURN BOOLEAN AS
2693: BEGIN --FINP_VAL_FC_CLOSED
2694: --Validate if IGS_FI_FEE_CAT.fee_cat is closed
2695: DECLARE
2696: v_closed_ind IGS_FI_FEE_CAT.closed_ind%type;
2697: CURSOR c_fc IS
2698: SELECT fc.closed_ind

Line 2696: v_closed_ind IGS_FI_FEE_CAT.closed_ind%type;

2692: RETURN BOOLEAN AS
2693: BEGIN --FINP_VAL_FC_CLOSED
2694: --Validate if IGS_FI_FEE_CAT.fee_cat is closed
2695: DECLARE
2696: v_closed_ind IGS_FI_FEE_CAT.closed_ind%type;
2697: CURSOR c_fc IS
2698: SELECT fc.closed_ind
2699: FROM IGS_FI_FEE_CAT fc
2700: WHERE fc.fee_cat = p_fee_cat;

Line 2699: FROM IGS_FI_FEE_CAT fc

2695: DECLARE
2696: v_closed_ind IGS_FI_FEE_CAT.closed_ind%type;
2697: CURSOR c_fc IS
2698: SELECT fc.closed_ind
2699: FROM IGS_FI_FEE_CAT fc
2700: WHERE fc.fee_cat = p_fee_cat;
2701: BEGIN
2702: --- Set the default message number
2703: p_message_name := null;