38: DECLARE
39: CURSOR c_ft IS
40: SELECT ft.s_fee_type,
41: ft.s_fee_trigger_cat
42: FROM IGS_FI_FEE_TYPE ft
43: WHERE ft.fee_type = p_fee_type;
44: CURSOR c_sca IS
45: SELECT 'X'
46: FROM igs_en_stdnt_ps_att sca,
63: AND fcfl.fee_cat = spa.fee_cat
64: AND fcfl.fee_liability_status = fsst.fee_structure_status
65: AND fsst.s_fee_structure_status = 'ACTIVE';
66:
67: v_s_fee_type IGS_FI_FEE_TYPE.s_fee_type%TYPE;
68: v_s_fee_trigger_cat IGS_FI_FEE_TYPE.s_fee_trigger_cat%TYPE;
69: v_dummy VARCHAR2(1);
70: CST_OTHER IGS_FI_FEE_TYPE.s_fee_type%TYPE := 'OTHER';
71: CST_TUITION IGS_FI_FEE_TYPE.s_fee_type%TYPE := 'TUITION';
64: AND fcfl.fee_liability_status = fsst.fee_structure_status
65: AND fsst.s_fee_structure_status = 'ACTIVE';
66:
67: v_s_fee_type IGS_FI_FEE_TYPE.s_fee_type%TYPE;
68: v_s_fee_trigger_cat IGS_FI_FEE_TYPE.s_fee_trigger_cat%TYPE;
69: v_dummy VARCHAR2(1);
70: CST_OTHER IGS_FI_FEE_TYPE.s_fee_type%TYPE := 'OTHER';
71: CST_TUITION IGS_FI_FEE_TYPE.s_fee_type%TYPE := 'TUITION';
72: CST_TUTNFEE IGS_FI_FEE_TYPE.s_fee_type%TYPE := 'TUTNFEE';
66:
67: v_s_fee_type IGS_FI_FEE_TYPE.s_fee_type%TYPE;
68: v_s_fee_trigger_cat IGS_FI_FEE_TYPE.s_fee_trigger_cat%TYPE;
69: v_dummy VARCHAR2(1);
70: CST_OTHER IGS_FI_FEE_TYPE.s_fee_type%TYPE := 'OTHER';
71: CST_TUITION IGS_FI_FEE_TYPE.s_fee_type%TYPE := 'TUITION';
72: CST_TUTNFEE IGS_FI_FEE_TYPE.s_fee_type%TYPE := 'TUTNFEE';
73: CST_INSTITUTN IGS_FI_FEE_TYPE.s_fee_trigger_cat%TYPE := 'INSTITUTN';
74: BEGIN
67: v_s_fee_type IGS_FI_FEE_TYPE.s_fee_type%TYPE;
68: v_s_fee_trigger_cat IGS_FI_FEE_TYPE.s_fee_trigger_cat%TYPE;
69: v_dummy VARCHAR2(1);
70: CST_OTHER IGS_FI_FEE_TYPE.s_fee_type%TYPE := 'OTHER';
71: CST_TUITION IGS_FI_FEE_TYPE.s_fee_type%TYPE := 'TUITION';
72: CST_TUTNFEE IGS_FI_FEE_TYPE.s_fee_type%TYPE := 'TUTNFEE';
73: CST_INSTITUTN IGS_FI_FEE_TYPE.s_fee_trigger_cat%TYPE := 'INSTITUTN';
74: BEGIN
75: -- Validate the IGS_FI_FEE_AS_RT can only be defined for
68: v_s_fee_trigger_cat IGS_FI_FEE_TYPE.s_fee_trigger_cat%TYPE;
69: v_dummy VARCHAR2(1);
70: CST_OTHER IGS_FI_FEE_TYPE.s_fee_type%TYPE := 'OTHER';
71: CST_TUITION IGS_FI_FEE_TYPE.s_fee_type%TYPE := 'TUITION';
72: CST_TUTNFEE IGS_FI_FEE_TYPE.s_fee_type%TYPE := 'TUTNFEE';
73: CST_INSTITUTN IGS_FI_FEE_TYPE.s_fee_trigger_cat%TYPE := 'INSTITUTN';
74: BEGIN
75: -- Validate the IGS_FI_FEE_AS_RT can only be defined for
76: -- fee types with s_fee_type = 'OTHER'or 'TUTNFEE' or 'TUITION' and
69: v_dummy VARCHAR2(1);
70: CST_OTHER IGS_FI_FEE_TYPE.s_fee_type%TYPE := 'OTHER';
71: CST_TUITION IGS_FI_FEE_TYPE.s_fee_type%TYPE := 'TUITION';
72: CST_TUTNFEE IGS_FI_FEE_TYPE.s_fee_type%TYPE := 'TUTNFEE';
73: CST_INSTITUTN IGS_FI_FEE_TYPE.s_fee_trigger_cat%TYPE := 'INSTITUTN';
74: BEGIN
75: -- Validate the IGS_FI_FEE_AS_RT can only be defined for
76: -- fee types with s_fee_type = 'OTHER'or 'TUTNFEE' or 'TUITION' and
77: -- s_fee_trigger_cat not 'INSTITUTN'.
346: BEGIN
347: DECLARE
348: CURSOR c_ft IS
349: SELECT ft.closed_ind
350: FROM IGS_FI_FEE_TYPE ft
351: WHERE ft.fee_type = p_fee_type;
352: v_fee_type IGS_FI_FEE_TYPE.closed_ind%TYPE;
353: BEGIN -- finp_val_ft_closed
354: -- Validate that the fee type is not closed
348: CURSOR c_ft IS
349: SELECT ft.closed_ind
350: FROM IGS_FI_FEE_TYPE ft
351: WHERE ft.fee_type = p_fee_type;
352: v_fee_type IGS_FI_FEE_TYPE.closed_ind%TYPE;
353: BEGIN -- finp_val_ft_closed
354: -- Validate that the fee type is not closed
355: -- Set the default message number
356: p_message_name := Null;