APPS.IGS_FI_VAL_FAS dependencies on IGS_FI_FEE_TYPE

Line 307: p_fee_type IN IGS_FI_FEE_TYPE_ALL.fee_type%TYPE ,

303: END finp_val_fas_cntrct;
304: --
305: -- Validate that appropriate optional fields are entered for IGS_FI_FEE_AS.
306: FUNCTION finp_val_fas_create(
307: p_fee_type IN IGS_FI_FEE_TYPE_ALL.fee_type%TYPE ,
308: p_fee_cat IN IGS_FI_FEE_CAT_ALL.fee_cat%TYPE ,
309: p_course_cd IN IGS_PS_COURSE.course_cd%TYPE ,
310: p_message_name OUT NOCOPY VARCHAR2 )
311: RETURN BOOLEAN AS

Line 314: --This module validates IGS_FI_FEE_AS.IGS_FI_FEE_TYPE with the fee category and

310: p_message_name OUT NOCOPY VARCHAR2 )
311: RETURN BOOLEAN AS
312: gv_other_detail VARCHAR2(255);
313: BEGIN --finp_val_fas_create
314: --This module validates IGS_FI_FEE_AS.IGS_FI_FEE_TYPE with the fee category and
315: -- IGS_PS_COURSE code.
316: --If IGS_FI_FEE_TYPE.s_fee_trigger_cat = 'INSTITUTN',then fee category and
317: --course_cd cannot be specified in the IGS_FI_FEE_AS record. Otherwise they
318: --must be specified

Line 316: --If IGS_FI_FEE_TYPE.s_fee_trigger_cat = 'INSTITUTN',then fee category and

312: gv_other_detail VARCHAR2(255);
313: BEGIN --finp_val_fas_create
314: --This module validates IGS_FI_FEE_AS.IGS_FI_FEE_TYPE with the fee category and
315: -- IGS_PS_COURSE code.
316: --If IGS_FI_FEE_TYPE.s_fee_trigger_cat = 'INSTITUTN',then fee category and
317: --course_cd cannot be specified in the IGS_FI_FEE_AS record. Otherwise they
318: --must be specified
319: DECLARE
320: v_fee_trigger_cat IGS_FI_FEE_TYPE.s_fee_trigger_cat%TYPE;

Line 320: v_fee_trigger_cat IGS_FI_FEE_TYPE.s_fee_trigger_cat%TYPE;

316: --If IGS_FI_FEE_TYPE.s_fee_trigger_cat = 'INSTITUTN',then fee category and
317: --course_cd cannot be specified in the IGS_FI_FEE_AS record. Otherwise they
318: --must be specified
319: DECLARE
320: v_fee_trigger_cat IGS_FI_FEE_TYPE.s_fee_trigger_cat%TYPE;
321: CURSOR c_ft IS
322: SELECT ft.s_fee_trigger_cat
323: FROM IGS_FI_FEE_TYPE ft
324: WHERE fee_type = p_fee_type;

Line 323: FROM IGS_FI_FEE_TYPE ft

319: DECLARE
320: v_fee_trigger_cat IGS_FI_FEE_TYPE.s_fee_trigger_cat%TYPE;
321: CURSOR c_ft IS
322: SELECT ft.s_fee_trigger_cat
323: FROM IGS_FI_FEE_TYPE ft
324: WHERE fee_type = p_fee_type;
325:
326: CURSOR c_fee_calc_mthd IS
327: SELECT fee_calc_mthd_code