[Home] [Help]
50: p_comments IN igs_fi_fee_as_all.comments%type,
51: p_org_id NUMBER );
52: --
53: FUNCTION finp_ins_cfar(
54: p_person_id IGS_FI_FEE_AS_RT.person_id%TYPE ,
55: p_course_cd IGS_FI_FEE_AS_RT.course_cd%TYPE ,
56: p_fee_type IGS_FI_FEE_AS_RT.FEE_TYPE%TYPE ,
57: p_start_dt IGS_FI_FEE_AS_RT.start_dt%TYPE ,
58: p_end_dt IGS_FI_FEE_AS_RT.end_dt%TYPE ,
51: p_org_id NUMBER );
52: --
53: FUNCTION finp_ins_cfar(
54: p_person_id IGS_FI_FEE_AS_RT.person_id%TYPE ,
55: p_course_cd IGS_FI_FEE_AS_RT.course_cd%TYPE ,
56: p_fee_type IGS_FI_FEE_AS_RT.FEE_TYPE%TYPE ,
57: p_start_dt IGS_FI_FEE_AS_RT.start_dt%TYPE ,
58: p_end_dt IGS_FI_FEE_AS_RT.end_dt%TYPE ,
59: p_location_cd IGS_FI_FEE_AS_RT.location_cd%TYPE ,
52: --
53: FUNCTION finp_ins_cfar(
54: p_person_id IGS_FI_FEE_AS_RT.person_id%TYPE ,
55: p_course_cd IGS_FI_FEE_AS_RT.course_cd%TYPE ,
56: p_fee_type IGS_FI_FEE_AS_RT.FEE_TYPE%TYPE ,
57: p_start_dt IGS_FI_FEE_AS_RT.start_dt%TYPE ,
58: p_end_dt IGS_FI_FEE_AS_RT.end_dt%TYPE ,
59: p_location_cd IGS_FI_FEE_AS_RT.location_cd%TYPE ,
60: p_attendance_type IGS_FI_FEE_AS_RT.ATTENDANCE_TYPE%TYPE ,
53: FUNCTION finp_ins_cfar(
54: p_person_id IGS_FI_FEE_AS_RT.person_id%TYPE ,
55: p_course_cd IGS_FI_FEE_AS_RT.course_cd%TYPE ,
56: p_fee_type IGS_FI_FEE_AS_RT.FEE_TYPE%TYPE ,
57: p_start_dt IGS_FI_FEE_AS_RT.start_dt%TYPE ,
58: p_end_dt IGS_FI_FEE_AS_RT.end_dt%TYPE ,
59: p_location_cd IGS_FI_FEE_AS_RT.location_cd%TYPE ,
60: p_attendance_type IGS_FI_FEE_AS_RT.ATTENDANCE_TYPE%TYPE ,
61: p_attendance_mode IGS_FI_FEE_AS_RT.ATTENDANCE_MODE%TYPE ,
54: p_person_id IGS_FI_FEE_AS_RT.person_id%TYPE ,
55: p_course_cd IGS_FI_FEE_AS_RT.course_cd%TYPE ,
56: p_fee_type IGS_FI_FEE_AS_RT.FEE_TYPE%TYPE ,
57: p_start_dt IGS_FI_FEE_AS_RT.start_dt%TYPE ,
58: p_end_dt IGS_FI_FEE_AS_RT.end_dt%TYPE ,
59: p_location_cd IGS_FI_FEE_AS_RT.location_cd%TYPE ,
60: p_attendance_type IGS_FI_FEE_AS_RT.ATTENDANCE_TYPE%TYPE ,
61: p_attendance_mode IGS_FI_FEE_AS_RT.ATTENDANCE_MODE%TYPE ,
62: p_chg_rate IGS_FI_FEE_AS_RT.chg_rate%TYPE ,
55: p_course_cd IGS_FI_FEE_AS_RT.course_cd%TYPE ,
56: p_fee_type IGS_FI_FEE_AS_RT.FEE_TYPE%TYPE ,
57: p_start_dt IGS_FI_FEE_AS_RT.start_dt%TYPE ,
58: p_end_dt IGS_FI_FEE_AS_RT.end_dt%TYPE ,
59: p_location_cd IGS_FI_FEE_AS_RT.location_cd%TYPE ,
60: p_attendance_type IGS_FI_FEE_AS_RT.ATTENDANCE_TYPE%TYPE ,
61: p_attendance_mode IGS_FI_FEE_AS_RT.ATTENDANCE_MODE%TYPE ,
62: p_chg_rate IGS_FI_FEE_AS_RT.chg_rate%TYPE ,
63: p_lower_nrml_rate_ovrd_ind IGS_FI_FEE_AS_RT.lower_nrml_rate_ovrd_ind%TYPE ,
56: p_fee_type IGS_FI_FEE_AS_RT.FEE_TYPE%TYPE ,
57: p_start_dt IGS_FI_FEE_AS_RT.start_dt%TYPE ,
58: p_end_dt IGS_FI_FEE_AS_RT.end_dt%TYPE ,
59: p_location_cd IGS_FI_FEE_AS_RT.location_cd%TYPE ,
60: p_attendance_type IGS_FI_FEE_AS_RT.ATTENDANCE_TYPE%TYPE ,
61: p_attendance_mode IGS_FI_FEE_AS_RT.ATTENDANCE_MODE%TYPE ,
62: p_chg_rate IGS_FI_FEE_AS_RT.chg_rate%TYPE ,
63: p_lower_nrml_rate_ovrd_ind IGS_FI_FEE_AS_RT.lower_nrml_rate_ovrd_ind%TYPE ,
64: p_message_name OUT NOCOPY VARCHAR2 )
57: p_start_dt IGS_FI_FEE_AS_RT.start_dt%TYPE ,
58: p_end_dt IGS_FI_FEE_AS_RT.end_dt%TYPE ,
59: p_location_cd IGS_FI_FEE_AS_RT.location_cd%TYPE ,
60: p_attendance_type IGS_FI_FEE_AS_RT.ATTENDANCE_TYPE%TYPE ,
61: p_attendance_mode IGS_FI_FEE_AS_RT.ATTENDANCE_MODE%TYPE ,
62: p_chg_rate IGS_FI_FEE_AS_RT.chg_rate%TYPE ,
63: p_lower_nrml_rate_ovrd_ind IGS_FI_FEE_AS_RT.lower_nrml_rate_ovrd_ind%TYPE ,
64: p_message_name OUT NOCOPY VARCHAR2 )
65: RETURN BOOLEAN ;
58: p_end_dt IGS_FI_FEE_AS_RT.end_dt%TYPE ,
59: p_location_cd IGS_FI_FEE_AS_RT.location_cd%TYPE ,
60: p_attendance_type IGS_FI_FEE_AS_RT.ATTENDANCE_TYPE%TYPE ,
61: p_attendance_mode IGS_FI_FEE_AS_RT.ATTENDANCE_MODE%TYPE ,
62: p_chg_rate IGS_FI_FEE_AS_RT.chg_rate%TYPE ,
63: p_lower_nrml_rate_ovrd_ind IGS_FI_FEE_AS_RT.lower_nrml_rate_ovrd_ind%TYPE ,
64: p_message_name OUT NOCOPY VARCHAR2 )
65: RETURN BOOLEAN ;
66: --
59: p_location_cd IGS_FI_FEE_AS_RT.location_cd%TYPE ,
60: p_attendance_type IGS_FI_FEE_AS_RT.ATTENDANCE_TYPE%TYPE ,
61: p_attendance_mode IGS_FI_FEE_AS_RT.ATTENDANCE_MODE%TYPE ,
62: p_chg_rate IGS_FI_FEE_AS_RT.chg_rate%TYPE ,
63: p_lower_nrml_rate_ovrd_ind IGS_FI_FEE_AS_RT.lower_nrml_rate_ovrd_ind%TYPE ,
64: p_message_name OUT NOCOPY VARCHAR2 )
65: RETURN BOOLEAN ;
66: --
67: FUNCTION finp_del_fsert(