APPS.IGS_FI_VAL_CTFT dependencies on IGS_FI_FEE_TYPE

Line 16: -- Validate IGS_PS_TYPE_FEE_TRG.IGS_FI_FEE_TYPE.

12: p_message_name OUT NOCOPY VARCHAR2 )
13: RETURN BOOLEAN AS
14: gv_other_detail VARCHAR2(255);
15: BEGIN -- finp_val_ctft_ins
16: -- Validate IGS_PS_TYPE_FEE_TRG.IGS_FI_FEE_TYPE.
17: -- If IGS_FI_FEE_TYPE.s_fee_trigger_cat <> 'COURSE'
18: -- then IGS_PS_COURSE type fee triggers cannot be defined.
19: DECLARE
20: CURSOR c_ft(

Line 17: -- If IGS_FI_FEE_TYPE.s_fee_trigger_cat <> 'COURSE'

13: RETURN BOOLEAN AS
14: gv_other_detail VARCHAR2(255);
15: BEGIN -- finp_val_ctft_ins
16: -- Validate IGS_PS_TYPE_FEE_TRG.IGS_FI_FEE_TYPE.
17: -- If IGS_FI_FEE_TYPE.s_fee_trigger_cat <> 'COURSE'
18: -- then IGS_PS_COURSE type fee triggers cannot be defined.
19: DECLARE
20: CURSOR c_ft(
21: cp_fee_type IGS_FI_FEE_TYPE.fee_type %TYPE) IS

Line 21: cp_fee_type IGS_FI_FEE_TYPE.fee_type %TYPE) IS

17: -- If IGS_FI_FEE_TYPE.s_fee_trigger_cat <> 'COURSE'
18: -- then IGS_PS_COURSE type fee triggers cannot be defined.
19: DECLARE
20: CURSOR c_ft(
21: cp_fee_type IGS_FI_FEE_TYPE.fee_type %TYPE) IS
22: SELECT s_fee_trigger_cat
23: FROM IGS_FI_FEE_TYPE
24: WHERE fee_type = cp_fee_type;
25: v_ft_rec c_ft%ROWTYPE;

Line 23: FROM IGS_FI_FEE_TYPE

19: DECLARE
20: CURSOR c_ft(
21: cp_fee_type IGS_FI_FEE_TYPE.fee_type %TYPE) IS
22: SELECT s_fee_trigger_cat
23: FROM IGS_FI_FEE_TYPE
24: WHERE fee_type = cp_fee_type;
25: v_ft_rec c_ft%ROWTYPE;
26: cst_course CONSTANT VARCHAR2(10) := 'COURSE';
27: BEGIN

Line 34: -- Get the system fee trigger category of the IGS_FI_FEE_TYPE.

30: -- Check parameters
31: IF p_fee_type IS NULL THEN
32: RETURN TRUE;
33: END IF;
34: -- Get the system fee trigger category of the IGS_FI_FEE_TYPE.
35: OPEN c_ft (p_fee_type);
36: FETCH c_ft INTO v_ft_rec;
37: IF c_ft%NOTFOUND THEN
38: CLOSE c_ft;