APPS.IGS_FI_VAL_FAS dependencies on IGS_PS_COURSE

Line 115: -- Get student IGS_PS_COURSE attempt detail

111: OPEN c_strty;
112: FETCH c_strty INTO v_system_generated_ind;
113: CLOSE c_strty;
114: IF (v_system_generated_ind = 'N') THEN
115: -- Get student IGS_PS_COURSE attempt detail
116: IF TRUNC(p_effective_dt) >= TRUNC(SYSDATE) THEN
117: --derive the load calendar from the fee calendar data to be used in
118: IF NOT igs_fi_gen_001.finp_get_lfci_reln ( p_cal_type => p_fee_cal_type,
119: p_ci_sequence_number => p_fee_ci_sequence_number,

Line 147: -- Test student IGS_PS_COURSE attempt is fee assessible

143: RETURN FALSE;
144: END IF;
145: CLOSE c_scaehv;
146: END IF;
147: -- Test student IGS_PS_COURSE attempt is fee assessible
148: IF v_fee_ass_ind = 'N' THEN
149: IF v_course_attempt_status <> 'UNCONFIRM' THEN
150: p_message_name := 'IGS_FI_STUD_PRGATTEM_STATUS_Y' ;
151: RETURN FALSE;

Line 309: p_course_cd IN IGS_PS_COURSE.course_cd%TYPE ,

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
312: gv_other_detail VARCHAR2(255);
313: BEGIN --finp_val_fas_create

Line 315: -- IGS_PS_COURSE code.

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
319: DECLARE