[Home] [Help]
315: p_fee_ci_sequence_number IN IGS_FI_F_CAT_CA_INST.fee_ci_sequence_number%TYPE ,
316: p_fee_type IN IGS_FI_F_CAT_FEE_LBL_ALL.FEE_TYPE%TYPE ,
317: p_s_fee_trigger_cat IN IGS_FI_FEE_TYPE_ALL.s_fee_trigger_cat%TYPE ,
318: p_effective_dt IN DATE ,
319: p_person_id IN IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,
320: p_course_cd IN IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
321: p_version_number IN IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
322: p_cal_type IN IGS_EN_STDNT_PS_ATT_ALL.CAL_TYPE%TYPE ,
323: p_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,
316: p_fee_type IN IGS_FI_F_CAT_FEE_LBL_ALL.FEE_TYPE%TYPE ,
317: p_s_fee_trigger_cat IN IGS_FI_FEE_TYPE_ALL.s_fee_trigger_cat%TYPE ,
318: p_effective_dt IN DATE ,
319: p_person_id IN IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,
320: p_course_cd IN IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
321: p_version_number IN IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
322: p_cal_type IN IGS_EN_STDNT_PS_ATT_ALL.CAL_TYPE%TYPE ,
323: p_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,
324: p_attendance_mode IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_MODE%TYPE ,
317: p_s_fee_trigger_cat IN IGS_FI_FEE_TYPE_ALL.s_fee_trigger_cat%TYPE ,
318: p_effective_dt IN DATE ,
319: p_person_id IN IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,
320: p_course_cd IN IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
321: p_version_number IN IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
322: p_cal_type IN IGS_EN_STDNT_PS_ATT_ALL.CAL_TYPE%TYPE ,
323: p_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,
324: p_attendance_mode IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_MODE%TYPE ,
325: p_attendance_type IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_TYPE%TYPE ,
318: p_effective_dt IN DATE ,
319: p_person_id IN IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,
320: p_course_cd IN IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
321: p_version_number IN IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
322: p_cal_type IN IGS_EN_STDNT_PS_ATT_ALL.CAL_TYPE%TYPE ,
323: p_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,
324: p_attendance_mode IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_MODE%TYPE ,
325: p_attendance_type IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_TYPE%TYPE ,
326: p_trigger_fired OUT NOCOPY VARCHAR2 )
319: p_person_id IN IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,
320: p_course_cd IN IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
321: p_version_number IN IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
322: p_cal_type IN IGS_EN_STDNT_PS_ATT_ALL.CAL_TYPE%TYPE ,
323: p_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,
324: p_attendance_mode IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_MODE%TYPE ,
325: p_attendance_type IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_TYPE%TYPE ,
326: p_trigger_fired OUT NOCOPY VARCHAR2 )
327: RETURN BOOLEAN AS
320: p_course_cd IN IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
321: p_version_number IN IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
322: p_cal_type IN IGS_EN_STDNT_PS_ATT_ALL.CAL_TYPE%TYPE ,
323: p_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,
324: p_attendance_mode IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_MODE%TYPE ,
325: p_attendance_type IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_TYPE%TYPE ,
326: p_trigger_fired OUT NOCOPY VARCHAR2 )
327: RETURN BOOLEAN AS
328: /***************************************************************************/
321: p_version_number IN IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
322: p_cal_type IN IGS_EN_STDNT_PS_ATT_ALL.CAL_TYPE%TYPE ,
323: p_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,
324: p_attendance_mode IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_MODE%TYPE ,
325: p_attendance_type IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_TYPE%TYPE ,
326: p_trigger_fired OUT NOCOPY VARCHAR2 )
327: RETURN BOOLEAN AS
328: /***************************************************************************/
329: -- Change History:
858: p_fee_ci_sequence_number IGS_FI_F_CAT_CA_INST.fee_ci_sequence_number%TYPE ,
859: p_fee_type IGS_FI_F_CAT_FEE_LBL_ALL.FEE_TYPE%TYPE ,
860: p_s_fee_trigger_cat IGS_FI_FEE_TYPE_ALL.s_fee_trigger_cat%TYPE ,
861: p_effective_dt DATE ,
862: p_person_id IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,
863: p_course_cd IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
864: p_version_number IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
865: p_cal_type IGS_EN_STDNT_PS_ATT_ALL.CAL_TYPE%TYPE ,
866: p_location_cd IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,
859: p_fee_type IGS_FI_F_CAT_FEE_LBL_ALL.FEE_TYPE%TYPE ,
860: p_s_fee_trigger_cat IGS_FI_FEE_TYPE_ALL.s_fee_trigger_cat%TYPE ,
861: p_effective_dt DATE ,
862: p_person_id IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,
863: p_course_cd IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
864: p_version_number IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
865: p_cal_type IGS_EN_STDNT_PS_ATT_ALL.CAL_TYPE%TYPE ,
866: p_location_cd IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,
867: p_attendance_mode IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_MODE%TYPE ,
860: p_s_fee_trigger_cat IGS_FI_FEE_TYPE_ALL.s_fee_trigger_cat%TYPE ,
861: p_effective_dt DATE ,
862: p_person_id IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,
863: p_course_cd IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
864: p_version_number IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
865: p_cal_type IGS_EN_STDNT_PS_ATT_ALL.CAL_TYPE%TYPE ,
866: p_location_cd IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,
867: p_attendance_mode IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_MODE%TYPE ,
868: p_attendance_type IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_TYPE%TYPE )
861: p_effective_dt DATE ,
862: p_person_id IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,
863: p_course_cd IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
864: p_version_number IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
865: p_cal_type IGS_EN_STDNT_PS_ATT_ALL.CAL_TYPE%TYPE ,
866: p_location_cd IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,
867: p_attendance_mode IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_MODE%TYPE ,
868: p_attendance_type IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_TYPE%TYPE )
869: RETURN CHAR AS
862: p_person_id IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,
863: p_course_cd IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
864: p_version_number IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
865: p_cal_type IGS_EN_STDNT_PS_ATT_ALL.CAL_TYPE%TYPE ,
866: p_location_cd IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,
867: p_attendance_mode IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_MODE%TYPE ,
868: p_attendance_type IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_TYPE%TYPE )
869: RETURN CHAR AS
870: BEGIN
863: p_course_cd IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
864: p_version_number IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
865: p_cal_type IGS_EN_STDNT_PS_ATT_ALL.CAL_TYPE%TYPE ,
866: p_location_cd IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,
867: p_attendance_mode IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_MODE%TYPE ,
868: p_attendance_type IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_TYPE%TYPE )
869: RETURN CHAR AS
870: BEGIN
871: DECLARE
864: p_version_number IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
865: p_cal_type IGS_EN_STDNT_PS_ATT_ALL.CAL_TYPE%TYPE ,
866: p_location_cd IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,
867: p_attendance_mode IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_MODE%TYPE ,
868: p_attendance_type IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_TYPE%TYPE )
869: RETURN CHAR AS
870: BEGIN
871: DECLARE
872: v_trigger_fired igs_lookups_view.lookup_code%TYPE;
896: PROCEDURE finp_set_pymnt_schdl(
897: errbuf out NOCOPY varchar2,
898: retcode out NOCOPY number,
899: P_FEE_ASSESSMENT_PERIOD IN VARCHAR2,
900: p_person_id IN IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,
901: p_fee_type IN IGS_FI_FEE_TYPE_ALL.fee_type%TYPE ,
902: p_fee_category IN IGS_EN_STDNT_PS_ATT_ALL.fee_cat%TYPE ,
903: p_grace_days IN NUMBER ,
904: p_effective_dt_c IN VARCHAR2 ,
898: retcode out NOCOPY number,
899: P_FEE_ASSESSMENT_PERIOD IN VARCHAR2,
900: p_person_id IN IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,
901: p_fee_type IN IGS_FI_FEE_TYPE_ALL.fee_type%TYPE ,
902: p_fee_category IN IGS_EN_STDNT_PS_ATT_ALL.fee_cat%TYPE ,
903: p_grace_days IN NUMBER ,
904: p_effective_dt_c IN VARCHAR2 ,
905: p_notification_dt_c IN VARCHAR2 ,
906: p_include_man_entries IN VARCHAR2 ,