APPS.IGS_FI_VAL_CFT dependencies on IGS_FI_FEE_TYPE

Line 22: -- Validate IGS_PS_FEE_TRG.IGS_FI_FEE_TYPE.s_fee_trigger_cat = IGS_PS_COURSE or COMPOSITE

18: p_message_name OUT NOCOPY VARCHAR2 )
19: RETURN BOOLEAN AS
20: gv_other_detail VARCHAR2(255);
21: BEGIN -- finp_val_cft_ins
22: -- Validate IGS_PS_FEE_TRG.IGS_FI_FEE_TYPE.s_fee_trigger_cat = IGS_PS_COURSE or COMPOSITE
23: -- otherwise IGS_PS_COURSE fee triggers cannot be defined.
24: DECLARE
25: CURSOR c_ft(
26: cp_fee_type IGS_FI_FEE_TYPE.fee_type%TYPE) IS

Line 26: cp_fee_type IGS_FI_FEE_TYPE.fee_type%TYPE) IS

22: -- Validate IGS_PS_FEE_TRG.IGS_FI_FEE_TYPE.s_fee_trigger_cat = IGS_PS_COURSE or COMPOSITE
23: -- otherwise IGS_PS_COURSE fee triggers cannot be defined.
24: DECLARE
25: CURSOR c_ft(
26: cp_fee_type IGS_FI_FEE_TYPE.fee_type%TYPE) IS
27: SELECT s_fee_trigger_cat
28: FROM IGS_FI_FEE_TYPE
29: WHERE fee_type= cp_fee_type;
30: v_ft_rec c_ft%ROWTYPE;

Line 28: FROM IGS_FI_FEE_TYPE

24: DECLARE
25: CURSOR c_ft(
26: cp_fee_type IGS_FI_FEE_TYPE.fee_type%TYPE) IS
27: SELECT s_fee_trigger_cat
28: FROM IGS_FI_FEE_TYPE
29: WHERE fee_type= cp_fee_type;
30: v_ft_rec c_ft%ROWTYPE;
31: cst_course CONSTANT VARCHAR2(10) := 'COURSE';
32: cst_composite CONSTANT VARCHAR2(10) := 'COMPOSITE';

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

36: -- Check parameters
37: IF p_fee_type IS NULL THEN
38: RETURN TRUE;
39: END IF;
40: -- Get the system fee trigger category of the IGS_FI_FEE_TYPE.
41: OPEN c_ft (p_fee_type);
42: FETCH c_ft INTO v_ft_rec;
43: IF c_ft%NOTFOUND THEN
44: CLOSE c_ft;

Line 241: p_fee_type IN IGS_FI_FEE_TYPE_ALL.fee_type%TYPE ,

237: FUNCTION finp_val_cft_ftg(
238: p_fee_cat IN IGS_FI_FEE_CAT_ALL.fee_cat%TYPE ,
239: p_fee_cal_type IN IGS_CA_TYPE.cal_type%TYPE ,
240: p_fee_ci_sequence_num IN NUMBER ,
241: p_fee_type IN IGS_FI_FEE_TYPE_ALL.fee_type%TYPE ,
242: p_course_cd IN IGS_PS_COURSE.course_cd%TYPE,
243: p_fee_trigger_group_num IN NUMBER ,
244: p_message_name OUT NOCOPY VARCHAR2 )
245: RETURN BOOLEAN AS

Line 252: cp_fee_type IGS_FI_FEE_TYPE.fee_type%TYPE)IS

248: -- Validate IGS_PS_FEE_TRG can belong to a IGS_FI_FEE_TRG_GRP
249: DECLARE
250: v_dummy VARCHAR2(1);
251: CURSOR c_ft(
252: cp_fee_type IGS_FI_FEE_TYPE.fee_type%TYPE)IS
253: SELECT s_fee_trigger_cat
254: FROM IGS_FI_FEE_TYPE
255: WHERE fee_type= cp_fee_type;
256: v_ft_rec c_ft%ROWTYPE;

Line 254: FROM IGS_FI_FEE_TYPE

250: v_dummy VARCHAR2(1);
251: CURSOR c_ft(
252: cp_fee_type IGS_FI_FEE_TYPE.fee_type%TYPE)IS
253: SELECT s_fee_trigger_cat
254: FROM IGS_FI_FEE_TYPE
255: WHERE fee_type= cp_fee_type;
256: v_ft_rec c_ft%ROWTYPE;
257: cst_composite CONSTANT VARCHAR2(10) := 'COMPOSITE';
258: CURSOR c_cft( cp_fee_cat IGS_PS_FEE_TRG.fee_cat%TYPE,

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

280: p_course_cd IS NULL OR
281: p_fee_trigger_group_num IS NULL) THEN
282: RETURN TRUE;
283: END IF;
284: -- Get the system fee trigger category of the IGS_FI_FEE_TYPE.
285: OPEN c_ft (p_fee_type);
286: FETCH c_ft INTO v_ft_rec;
287: IF c_ft%NOTFOUND THEN
288: CLOSE c_ft;