APPS.IGS_FI_VAL_FT dependencies on IGS_FI_FEE_AS

Line 120: -- no related IGS_FI_FEE_AS records.

116:
117: BEGIN -- finp_val_ft_trig
118: -- Validate changes to the IGS_FI_FEE_TYPE.s_fee_trigger_cat.
119: -- If changing from INSTITUTN to anything else ensure there are
120: -- no related IGS_FI_FEE_AS records.
121: -- If changing to INSTITUTN from anything else ensure there are no
122: -- related IGS_FI_FEE_AS records
123: -- and that there are no related IGS_PS_COURSE, IGS_PS_UNIT or IGS_PS_UNIT set triggers.
124: -- If changing to IGS_PS_COURSE ensure there are only IGS_PS_COURSE triggers.

Line 122: -- related IGS_FI_FEE_AS records

118: -- Validate changes to the IGS_FI_FEE_TYPE.s_fee_trigger_cat.
119: -- If changing from INSTITUTN to anything else ensure there are
120: -- no related IGS_FI_FEE_AS records.
121: -- If changing to INSTITUTN from anything else ensure there are no
122: -- related IGS_FI_FEE_AS records
123: -- and that there are no related IGS_PS_COURSE, IGS_PS_UNIT or IGS_PS_UNIT set triggers.
124: -- If changing to IGS_PS_COURSE ensure there are only IGS_PS_COURSE triggers.
125: -- If changing to IGS_PS_UNIT ensure there are only IGS_PS_UNIT triggers.
126: -- If changing to UNITSET ensure there are only IGS_PS_UNIT set triggers.

Line 135: p_fee_type IGS_FI_FEE_AS.fee_type%TYPE)

131: cst_course CONSTANT VARCHAR2(10) := 'COURSE';
132: cst_composite CONSTANT VARCHAR2(10) := 'COMPOSITE';
133: v_dummy VARCHAR2(1);
134: FUNCTION finpl_get_fee_ass(
135: p_fee_type IGS_FI_FEE_AS.fee_type%TYPE)
136: RETURN BOOLEAN AS
137: BEGIN
138: DECLARE
139: v_dummy VARCHAR2(1);

Line 141: cp_fee_type IGS_FI_FEE_AS.fee_type%TYPE) IS

137: BEGIN
138: DECLARE
139: v_dummy VARCHAR2(1);
140: CURSOR c_fee_ass (
141: cp_fee_type IGS_FI_FEE_AS.fee_type%TYPE) IS
142: SELECT 'x'
143: FROM IGS_FI_FEE_AS fa
144: WHERE fa.fee_type = cp_fee_type;
145: BEGIN

Line 143: FROM IGS_FI_FEE_AS fa

139: v_dummy VARCHAR2(1);
140: CURSOR c_fee_ass (
141: cp_fee_type IGS_FI_FEE_AS.fee_type%TYPE) IS
142: SELECT 'x'
143: FROM IGS_FI_FEE_AS fa
144: WHERE fa.fee_type = cp_fee_type;
145: BEGIN
146: -- Check for Fee Assessment records in the IGS_FI_FEE_AS table. If any are found
147: -- the function should return TRUE otherwise return FALSE.

Line 146: -- Check for Fee Assessment records in the IGS_FI_FEE_AS table. If any are found

142: SELECT 'x'
143: FROM IGS_FI_FEE_AS fa
144: WHERE fa.fee_type = cp_fee_type;
145: BEGIN
146: -- Check for Fee Assessment records in the IGS_FI_FEE_AS table. If any are found
147: -- the function should return TRUE otherwise return FALSE.
148: OPEN c_fee_ass(
149: p_fee_type);
150: FETCH c_fee_ass INTO v_dummy;

Line 467: -- IGS_FI_FEE_AS_RATE

463: -- IGS_FI_FEE_PAY_SCHD
464: -- IGS_FI_FEE_RET_SCHD
465: -- IGS_FI_FEE_ENCMB - Removed reference from this package-
466: -- IGS_FI_CHG_MTH_APP
467: -- IGS_FI_FEE_AS_RATE
468: -- IGS_FI_ELM_RANGE
469: DECLARE
470: v_dummy VARCHAR2(1);
471: CURSOR c_fee_cat_fee_liability (cp_fee_type IGS_FI_FEE_TYPE.fee_type%TYPE) IS

Line 491: FROM IGS_FI_FEE_AS_RATE

487: -- tbl obsoleted as a prt of bug - 2187247 (rnirwani)
488:
489: CURSOR c_fee_ass_rate (cp_fee_type IGS_FI_FEE_TYPE.fee_type%TYPE) IS
490: SELECT 'x'
491: FROM IGS_FI_FEE_AS_RATE
492: WHERE FEE_TYPE = cp_fee_type AND
493: s_relation_type = 'FCFL' AND
494: logical_delete_dt IS NULL;
495: CURSOR c_elements_range (cp_fee_type IGS_FI_FEE_TYPE.fee_type%TYPE) IS