APPS.IGS_FI_VAL_CGFT dependencies on IGS_FI_FEE_TYPE

Line 15: -- Validate IGS_PS_GRP_FEE_TRG.IGS_FI_FEE_TYPE.

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

Line 16: -- If IGS_FI_FEE_TYPE.s_fee_trigger_cat <> IGS_PS_COURSE

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

Line 20: cp_fee_type IGS_FI_FEE_TYPE.fee_type%TYPE) IS

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

Line 22: FROM IGS_FI_FEE_TYPE

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

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

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