[Home] [Help]
345: p_v_fee_cal_type IN igs_fi_fee_as_all.fee_cal_type%TYPE,
346: p_n_fee_ci_sequence_number IN igs_fi_fee_as_all.fee_ci_sequence_number%TYPE) RETURN BOOLEAN;
347:
348: FUNCTION finpl_get_derived_am_at (p_person_id IN hz_parties.party_id%TYPE,
349: p_course_cd IN igs_ps_course.course_cd%TYPE,
350: p_effective_dt IN DATE,
351: p_fee_cal_type IN igs_fi_f_cat_fee_lbl_all.fee_cal_type%TYPE,
352: p_fee_ci_sequence_number IN igs_fi_f_cat_fee_lbl_all.fee_ci_sequence_number%TYPE,
353: p_fee_type IN igs_fi_f_cat_fee_lbl_all.fee_type%TYPE,
1068:
1069: -----------------------------------------------------------------------------------
1070: FUNCTION finpl_get_derived_am_at (
1071: p_person_id hz_parties.party_id%TYPE,
1072: p_course_cd IGS_PS_COURSE.course_cd%TYPE,
1073: p_effective_dt DATE,
1074: p_fee_cal_type igs_fi_f_cat_fee_lbl_all.fee_cal_type%TYPE,
1075: p_fee_ci_sequence_number igs_fi_f_cat_fee_lbl_all.fee_ci_sequence_number%TYPE,
1076: p_fee_type igs_fi_f_cat_fee_lbl_all.fee_type%TYPE,
1729: *************************************************************/
1730:
1731: BEGIN -- finpl_ins_match_chg_rate
1732: -- 2.3.1 Match Charge Rate
1733: -- Attempt to match assessment rate attributes with student IGS_PS_COURSE attempt.
1734: -- The order of precedence ensures the first
1735: -- match found is the desired charge rate.
1736: DECLARE
1737: v_rate_govt_att_mode igs_en_atd_mode_all.govt_attendance_mode%TYPE;
1906:
1907: -------------------------------------------------------------------------------
1908: FUNCTION finpl_get_derived_values (
1909: p_person_id hz_parties.party_id%TYPE,
1910: p_course_cd IGS_PS_COURSE.course_cd%TYPE,
1911: p_effective_dt DATE,
1912: p_fee_cal_type igs_fi_f_cat_fee_lbl_all.fee_cal_type%TYPE,
1913: p_fee_ci_sequence_number igs_fi_f_cat_fee_lbl_all.fee_ci_sequence_number%TYPE,
1914: p_fee_type igs_fi_f_cat_fee_lbl_all.fee_type%TYPE,
6750: l_b_sca_liable_fcfl BOOLEAN;
6751: l_v_prg_liabale VARCHAR2(10);
6752:
6753: -- cursor to find student IGS_PS_UNIT attempts across multiple
6754: -- student IGS_PS_COURSE attempts
6755: -- this cursor has been modified to incorporate the changes for early/prioe assessment
6756: -- fee clac DLD (Bug# 1851586)
6757: -- the records are fetched in the basis of the prior fee calendar instance
6758: