APPS.IGS_FI_VAL_FTG dependencies on IGS_FI_FEE_TYPE

Line 11: -- Validate IGS_FI_FEE_TRG_GRP IGS_FI_FEE_TYPE.s_fee_trigger_cat = COMPOSITE

7: p_message_name OUT NOCOPY VARCHAR2)
8: RETURN BOOLEAN AS
9: gv_other_detail VARCHAR2(255);
10: BEGIN -- finp_val_ftg_ins
11: -- Validate IGS_FI_FEE_TRG_GRP IGS_FI_FEE_TYPE.s_fee_trigger_cat = COMPOSITE
12: -- otherwise fee trigger groups cannot be defined.
13: DECLARE
14: CURSOR c_ft(
15: cp_fee_type IGS_FI_FEE_TYPE.fee_type%TYPE) IS

Line 15: cp_fee_type IGS_FI_FEE_TYPE.fee_type%TYPE) IS

11: -- Validate IGS_FI_FEE_TRG_GRP IGS_FI_FEE_TYPE.s_fee_trigger_cat = COMPOSITE
12: -- otherwise fee trigger groups cannot be defined.
13: DECLARE
14: CURSOR c_ft(
15: cp_fee_type IGS_FI_FEE_TYPE.fee_type%TYPE) IS
16: SELECT s_fee_trigger_cat
17: FROM IGS_FI_FEE_TYPE
18: WHERE FEE_TYPE = cp_fee_type;
19: v_ft_rec c_ft%ROWTYPE;

Line 17: FROM IGS_FI_FEE_TYPE

13: DECLARE
14: CURSOR c_ft(
15: cp_fee_type IGS_FI_FEE_TYPE.fee_type%TYPE) IS
16: SELECT s_fee_trigger_cat
17: FROM IGS_FI_FEE_TYPE
18: WHERE FEE_TYPE = cp_fee_type;
19: v_ft_rec c_ft%ROWTYPE;
20: cst_composite CONSTANT VARCHAR2(10) := 'COMPOSITE';
21: BEGIN

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

24: -- Check parameters
25: IF p_fee_type IS NULL THEN
26: RETURN TRUE;
27: END IF;
28: -- Get the system fee trigger category of the IGS_FI_FEE_TYPE.
29: OPEN c_ft (p_fee_type);
30: FETCH c_ft INTO v_ft_rec;
31: IF c_ft%NOTFOUND THEN
32: CLOSE c_ft;