APPS.IGS_FI_VAL_FTG dependencies on IGS_FI_FEE_TRG_GRP

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 47: p_fee_cat IN IGS_FI_FEE_TRG_GRP.FEE_CAT%TYPE ,

43: END finp_val_ftg_ins;
44: --
45: -- Validate logical delete of the fee trigger group
46: FUNCTION finp_val_ftg_lgl_del(
47: p_fee_cat IN IGS_FI_FEE_TRG_GRP.FEE_CAT%TYPE ,
48: p_fee_cal_type IN IGS_FI_FEE_TRG_GRP.fee_cal_type%TYPE ,
49: p_fee_ci_sequence_number IN NUMBER ,
50: p_fee_type IN IGS_FI_FEE_TRG_GRP.FEE_TYPE%TYPE ,
51: p_fee_trigger_group_num IN NUMBER ,

Line 48: p_fee_cal_type IN IGS_FI_FEE_TRG_GRP.fee_cal_type%TYPE ,

44: --
45: -- Validate logical delete of the fee trigger group
46: FUNCTION finp_val_ftg_lgl_del(
47: p_fee_cat IN IGS_FI_FEE_TRG_GRP.FEE_CAT%TYPE ,
48: p_fee_cal_type IN IGS_FI_FEE_TRG_GRP.fee_cal_type%TYPE ,
49: p_fee_ci_sequence_number IN NUMBER ,
50: p_fee_type IN IGS_FI_FEE_TRG_GRP.FEE_TYPE%TYPE ,
51: p_fee_trigger_group_num IN NUMBER ,
52: p_message_name OUT NOCOPY VARCHAR2)

Line 50: p_fee_type IN IGS_FI_FEE_TRG_GRP.FEE_TYPE%TYPE ,

46: FUNCTION finp_val_ftg_lgl_del(
47: p_fee_cat IN IGS_FI_FEE_TRG_GRP.FEE_CAT%TYPE ,
48: p_fee_cal_type IN IGS_FI_FEE_TRG_GRP.fee_cal_type%TYPE ,
49: p_fee_ci_sequence_number IN NUMBER ,
50: p_fee_type IN IGS_FI_FEE_TRG_GRP.FEE_TYPE%TYPE ,
51: p_fee_trigger_group_num IN NUMBER ,
52: p_message_name OUT NOCOPY VARCHAR2)
53: RETURN BOOLEAN AS
54: gv_other_detail VARCHAR2(255);

Line 56: -- Validate that logical deletion of a IGS_FI_FEE_TRG_GRP record does

52: p_message_name OUT NOCOPY VARCHAR2)
53: RETURN BOOLEAN AS
54: gv_other_detail VARCHAR2(255);
55: BEGIN -- finp_val_ftg_lgl_del
56: -- Validate that logical deletion of a IGS_FI_FEE_TRG_GRP record does
57: -- not orphan related IGS_PS_COURSE, IGS_PS_UNIT or IGS_PS_UNIT set fee triggers.
58: DECLARE
59: CURSOR c_cft IS
60: SELECT 'x'