30: -- procedure as part of Bug 2175865
31: /* Obseleted the procedure finp_ins_fe_hist( as part of bug 2126091 as this is no longer used -sykrishn 29112001 */
32: --
33: PROCEDURE finp_ins_cfar_hist (
34: p_person_id IN IGS_FI_FEE_AS_RT.person_id%TYPE ,
35: p_course_cd IN IGS_FI_FEE_AS_RT.course_cd%TYPE ,
36: p_fee_type IN IGS_FI_FEE_AS_RT.FEE_TYPE%TYPE ,
37: p_start_dt IN IGS_FI_FEE_AS_RT.start_dt%TYPE ,
38: p_new_end_dt IN IGS_FI_FEE_AS_RT.end_dt%TYPE ,
31: /* Obseleted the procedure finp_ins_fe_hist( as part of bug 2126091 as this is no longer used -sykrishn 29112001 */
32: --
33: PROCEDURE finp_ins_cfar_hist (
34: p_person_id IN IGS_FI_FEE_AS_RT.person_id%TYPE ,
35: p_course_cd IN IGS_FI_FEE_AS_RT.course_cd%TYPE ,
36: p_fee_type IN IGS_FI_FEE_AS_RT.FEE_TYPE%TYPE ,
37: p_start_dt IN IGS_FI_FEE_AS_RT.start_dt%TYPE ,
38: p_new_end_dt IN IGS_FI_FEE_AS_RT.end_dt%TYPE ,
39: p_old_end_dt IN IGS_FI_FEE_AS_RT.end_dt%TYPE ,
32: --
33: PROCEDURE finp_ins_cfar_hist (
34: p_person_id IN IGS_FI_FEE_AS_RT.person_id%TYPE ,
35: p_course_cd IN IGS_FI_FEE_AS_RT.course_cd%TYPE ,
36: p_fee_type IN IGS_FI_FEE_AS_RT.FEE_TYPE%TYPE ,
37: p_start_dt IN IGS_FI_FEE_AS_RT.start_dt%TYPE ,
38: p_new_end_dt IN IGS_FI_FEE_AS_RT.end_dt%TYPE ,
39: p_old_end_dt IN IGS_FI_FEE_AS_RT.end_dt%TYPE ,
40: p_new_location_cd IN IGS_FI_FEE_AS_RT.location_cd%TYPE ,
33: PROCEDURE finp_ins_cfar_hist (
34: p_person_id IN IGS_FI_FEE_AS_RT.person_id%TYPE ,
35: p_course_cd IN IGS_FI_FEE_AS_RT.course_cd%TYPE ,
36: p_fee_type IN IGS_FI_FEE_AS_RT.FEE_TYPE%TYPE ,
37: p_start_dt IN IGS_FI_FEE_AS_RT.start_dt%TYPE ,
38: p_new_end_dt IN IGS_FI_FEE_AS_RT.end_dt%TYPE ,
39: p_old_end_dt IN IGS_FI_FEE_AS_RT.end_dt%TYPE ,
40: p_new_location_cd IN IGS_FI_FEE_AS_RT.location_cd%TYPE ,
41: p_old_location_cd IN IGS_FI_FEE_AS_RT.location_cd%TYPE ,
34: p_person_id IN IGS_FI_FEE_AS_RT.person_id%TYPE ,
35: p_course_cd IN IGS_FI_FEE_AS_RT.course_cd%TYPE ,
36: p_fee_type IN IGS_FI_FEE_AS_RT.FEE_TYPE%TYPE ,
37: p_start_dt IN IGS_FI_FEE_AS_RT.start_dt%TYPE ,
38: p_new_end_dt IN IGS_FI_FEE_AS_RT.end_dt%TYPE ,
39: p_old_end_dt IN IGS_FI_FEE_AS_RT.end_dt%TYPE ,
40: p_new_location_cd IN IGS_FI_FEE_AS_RT.location_cd%TYPE ,
41: p_old_location_cd IN IGS_FI_FEE_AS_RT.location_cd%TYPE ,
42: p_new_attendance_type IN IGS_EN_ATD_TYPE_ALL.ATTENDANCE_TYPE%TYPE ,
35: p_course_cd IN IGS_FI_FEE_AS_RT.course_cd%TYPE ,
36: p_fee_type IN IGS_FI_FEE_AS_RT.FEE_TYPE%TYPE ,
37: p_start_dt IN IGS_FI_FEE_AS_RT.start_dt%TYPE ,
38: p_new_end_dt IN IGS_FI_FEE_AS_RT.end_dt%TYPE ,
39: p_old_end_dt IN IGS_FI_FEE_AS_RT.end_dt%TYPE ,
40: p_new_location_cd IN IGS_FI_FEE_AS_RT.location_cd%TYPE ,
41: p_old_location_cd IN IGS_FI_FEE_AS_RT.location_cd%TYPE ,
42: p_new_attendance_type IN IGS_EN_ATD_TYPE_ALL.ATTENDANCE_TYPE%TYPE ,
43: p_old_attendance_type IN IGS_EN_ATD_TYPE_ALL.ATTENDANCE_TYPE%TYPE ,
36: p_fee_type IN IGS_FI_FEE_AS_RT.FEE_TYPE%TYPE ,
37: p_start_dt IN IGS_FI_FEE_AS_RT.start_dt%TYPE ,
38: p_new_end_dt IN IGS_FI_FEE_AS_RT.end_dt%TYPE ,
39: p_old_end_dt IN IGS_FI_FEE_AS_RT.end_dt%TYPE ,
40: p_new_location_cd IN IGS_FI_FEE_AS_RT.location_cd%TYPE ,
41: p_old_location_cd IN IGS_FI_FEE_AS_RT.location_cd%TYPE ,
42: p_new_attendance_type IN IGS_EN_ATD_TYPE_ALL.ATTENDANCE_TYPE%TYPE ,
43: p_old_attendance_type IN IGS_EN_ATD_TYPE_ALL.ATTENDANCE_TYPE%TYPE ,
44: p_new_attendance_mode IN IGS_EN_ATD_MODE_ALL.ATTENDANCE_MODE%TYPE ,
37: p_start_dt IN IGS_FI_FEE_AS_RT.start_dt%TYPE ,
38: p_new_end_dt IN IGS_FI_FEE_AS_RT.end_dt%TYPE ,
39: p_old_end_dt IN IGS_FI_FEE_AS_RT.end_dt%TYPE ,
40: p_new_location_cd IN IGS_FI_FEE_AS_RT.location_cd%TYPE ,
41: p_old_location_cd IN IGS_FI_FEE_AS_RT.location_cd%TYPE ,
42: p_new_attendance_type IN IGS_EN_ATD_TYPE_ALL.ATTENDANCE_TYPE%TYPE ,
43: p_old_attendance_type IN IGS_EN_ATD_TYPE_ALL.ATTENDANCE_TYPE%TYPE ,
44: p_new_attendance_mode IN IGS_EN_ATD_MODE_ALL.ATTENDANCE_MODE%TYPE ,
45: p_old_attendance_mode IN IGS_EN_ATD_MODE_ALL.ATTENDANCE_MODE%TYPE ,
42: p_new_attendance_type IN IGS_EN_ATD_TYPE_ALL.ATTENDANCE_TYPE%TYPE ,
43: p_old_attendance_type IN IGS_EN_ATD_TYPE_ALL.ATTENDANCE_TYPE%TYPE ,
44: p_new_attendance_mode IN IGS_EN_ATD_MODE_ALL.ATTENDANCE_MODE%TYPE ,
45: p_old_attendance_mode IN IGS_EN_ATD_MODE_ALL.ATTENDANCE_MODE%TYPE ,
46: p_new_chg_rate IN IGS_FI_FEE_AS_RT.chg_rate%TYPE ,
47: p_old_chg_rate IN IGS_FI_FEE_AS_RT.chg_rate%TYPE ,
48: p_new_lower_nrml_rate_ovrd_ind IN IGS_FI_FEE_AS_RT.lower_nrml_rate_ovrd_ind%TYPE ,
49: p_old_lower_nrml_rate_ovrd_ind IN IGS_FI_FEE_AS_RT.lower_nrml_rate_ovrd_ind%TYPE ,
50: p_new_last_updated_by IN IGS_FI_FEE_AS_RT.last_updated_by%TYPE ,
43: p_old_attendance_type IN IGS_EN_ATD_TYPE_ALL.ATTENDANCE_TYPE%TYPE ,
44: p_new_attendance_mode IN IGS_EN_ATD_MODE_ALL.ATTENDANCE_MODE%TYPE ,
45: p_old_attendance_mode IN IGS_EN_ATD_MODE_ALL.ATTENDANCE_MODE%TYPE ,
46: p_new_chg_rate IN IGS_FI_FEE_AS_RT.chg_rate%TYPE ,
47: p_old_chg_rate IN IGS_FI_FEE_AS_RT.chg_rate%TYPE ,
48: p_new_lower_nrml_rate_ovrd_ind IN IGS_FI_FEE_AS_RT.lower_nrml_rate_ovrd_ind%TYPE ,
49: p_old_lower_nrml_rate_ovrd_ind IN IGS_FI_FEE_AS_RT.lower_nrml_rate_ovrd_ind%TYPE ,
50: p_new_last_updated_by IN IGS_FI_FEE_AS_RT.last_updated_by%TYPE ,
51: p_old_last_updated_by IN IGS_FI_FEE_AS_RT.last_updated_by%TYPE ,
44: p_new_attendance_mode IN IGS_EN_ATD_MODE_ALL.ATTENDANCE_MODE%TYPE ,
45: p_old_attendance_mode IN IGS_EN_ATD_MODE_ALL.ATTENDANCE_MODE%TYPE ,
46: p_new_chg_rate IN IGS_FI_FEE_AS_RT.chg_rate%TYPE ,
47: p_old_chg_rate IN IGS_FI_FEE_AS_RT.chg_rate%TYPE ,
48: p_new_lower_nrml_rate_ovrd_ind IN IGS_FI_FEE_AS_RT.lower_nrml_rate_ovrd_ind%TYPE ,
49: p_old_lower_nrml_rate_ovrd_ind IN IGS_FI_FEE_AS_RT.lower_nrml_rate_ovrd_ind%TYPE ,
50: p_new_last_updated_by IN IGS_FI_FEE_AS_RT.last_updated_by%TYPE ,
51: p_old_last_updated_by IN IGS_FI_FEE_AS_RT.last_updated_by%TYPE ,
52: p_new_last_update_date IN IGS_FI_FEE_AS_RT.last_update_date%TYPE ,
45: p_old_attendance_mode IN IGS_EN_ATD_MODE_ALL.ATTENDANCE_MODE%TYPE ,
46: p_new_chg_rate IN IGS_FI_FEE_AS_RT.chg_rate%TYPE ,
47: p_old_chg_rate IN IGS_FI_FEE_AS_RT.chg_rate%TYPE ,
48: p_new_lower_nrml_rate_ovrd_ind IN IGS_FI_FEE_AS_RT.lower_nrml_rate_ovrd_ind%TYPE ,
49: p_old_lower_nrml_rate_ovrd_ind IN IGS_FI_FEE_AS_RT.lower_nrml_rate_ovrd_ind%TYPE ,
50: p_new_last_updated_by IN IGS_FI_FEE_AS_RT.last_updated_by%TYPE ,
51: p_old_last_updated_by IN IGS_FI_FEE_AS_RT.last_updated_by%TYPE ,
52: p_new_last_update_date IN IGS_FI_FEE_AS_RT.last_update_date%TYPE ,
53: p_old_last_update_date IN IGS_FI_FEE_AS_RT.last_update_date%TYPE
46: p_new_chg_rate IN IGS_FI_FEE_AS_RT.chg_rate%TYPE ,
47: p_old_chg_rate IN IGS_FI_FEE_AS_RT.chg_rate%TYPE ,
48: p_new_lower_nrml_rate_ovrd_ind IN IGS_FI_FEE_AS_RT.lower_nrml_rate_ovrd_ind%TYPE ,
49: p_old_lower_nrml_rate_ovrd_ind IN IGS_FI_FEE_AS_RT.lower_nrml_rate_ovrd_ind%TYPE ,
50: p_new_last_updated_by IN IGS_FI_FEE_AS_RT.last_updated_by%TYPE ,
51: p_old_last_updated_by IN IGS_FI_FEE_AS_RT.last_updated_by%TYPE ,
52: p_new_last_update_date IN IGS_FI_FEE_AS_RT.last_update_date%TYPE ,
53: p_old_last_update_date IN IGS_FI_FEE_AS_RT.last_update_date%TYPE
54: );
47: p_old_chg_rate IN IGS_FI_FEE_AS_RT.chg_rate%TYPE ,
48: p_new_lower_nrml_rate_ovrd_ind IN IGS_FI_FEE_AS_RT.lower_nrml_rate_ovrd_ind%TYPE ,
49: p_old_lower_nrml_rate_ovrd_ind IN IGS_FI_FEE_AS_RT.lower_nrml_rate_ovrd_ind%TYPE ,
50: p_new_last_updated_by IN IGS_FI_FEE_AS_RT.last_updated_by%TYPE ,
51: p_old_last_updated_by IN IGS_FI_FEE_AS_RT.last_updated_by%TYPE ,
52: p_new_last_update_date IN IGS_FI_FEE_AS_RT.last_update_date%TYPE ,
53: p_old_last_update_date IN IGS_FI_FEE_AS_RT.last_update_date%TYPE
54: );
55: --
48: p_new_lower_nrml_rate_ovrd_ind IN IGS_FI_FEE_AS_RT.lower_nrml_rate_ovrd_ind%TYPE ,
49: p_old_lower_nrml_rate_ovrd_ind IN IGS_FI_FEE_AS_RT.lower_nrml_rate_ovrd_ind%TYPE ,
50: p_new_last_updated_by IN IGS_FI_FEE_AS_RT.last_updated_by%TYPE ,
51: p_old_last_updated_by IN IGS_FI_FEE_AS_RT.last_updated_by%TYPE ,
52: p_new_last_update_date IN IGS_FI_FEE_AS_RT.last_update_date%TYPE ,
53: p_old_last_update_date IN IGS_FI_FEE_AS_RT.last_update_date%TYPE
54: );
55: --
56: PROCEDURE finp_ins_cft_hist(
49: p_old_lower_nrml_rate_ovrd_ind IN IGS_FI_FEE_AS_RT.lower_nrml_rate_ovrd_ind%TYPE ,
50: p_new_last_updated_by IN IGS_FI_FEE_AS_RT.last_updated_by%TYPE ,
51: p_old_last_updated_by IN IGS_FI_FEE_AS_RT.last_updated_by%TYPE ,
52: p_new_last_update_date IN IGS_FI_FEE_AS_RT.last_update_date%TYPE ,
53: p_old_last_update_date IN IGS_FI_FEE_AS_RT.last_update_date%TYPE
54: );
55: --
56: PROCEDURE finp_ins_cft_hist(
57: p_fee_cat IN IGS_PS_FEE_TRG.FEE_CAT%TYPE ,