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 ,
58: p_fee_cal_type IN IGS_PS_FEE_TRG.fee_cal_type%TYPE ,
59: p_fee_ci_sequence_number IN IGS_PS_FEE_TRG.fee_ci_sequence_number%TYPE ,
60: p_fee_type IN IGS_PS_FEE_TRG.FEE_TYPE%TYPE ,
61: p_course_cd IN IGS_PS_FEE_TRG.course_cd%TYPE ,
54: );
55: --
56: PROCEDURE finp_ins_cft_hist(
57: p_fee_cat IN IGS_PS_FEE_TRG.FEE_CAT%TYPE ,
58: p_fee_cal_type IN IGS_PS_FEE_TRG.fee_cal_type%TYPE ,
59: p_fee_ci_sequence_number IN IGS_PS_FEE_TRG.fee_ci_sequence_number%TYPE ,
60: p_fee_type IN IGS_PS_FEE_TRG.FEE_TYPE%TYPE ,
61: p_course_cd IN IGS_PS_FEE_TRG.course_cd%TYPE ,
62: p_sequence_number IN IGS_PS_FEE_TRG.sequence_number%TYPE ,
55: --
56: PROCEDURE finp_ins_cft_hist(
57: p_fee_cat IN IGS_PS_FEE_TRG.FEE_CAT%TYPE ,
58: p_fee_cal_type IN IGS_PS_FEE_TRG.fee_cal_type%TYPE ,
59: p_fee_ci_sequence_number IN IGS_PS_FEE_TRG.fee_ci_sequence_number%TYPE ,
60: p_fee_type IN IGS_PS_FEE_TRG.FEE_TYPE%TYPE ,
61: p_course_cd IN IGS_PS_FEE_TRG.course_cd%TYPE ,
62: p_sequence_number IN IGS_PS_FEE_TRG.sequence_number%TYPE ,
63: p_new_version_number IN IGS_PS_FEE_TRG.version_number%TYPE ,
56: PROCEDURE finp_ins_cft_hist(
57: p_fee_cat IN IGS_PS_FEE_TRG.FEE_CAT%TYPE ,
58: p_fee_cal_type IN IGS_PS_FEE_TRG.fee_cal_type%TYPE ,
59: p_fee_ci_sequence_number IN IGS_PS_FEE_TRG.fee_ci_sequence_number%TYPE ,
60: p_fee_type IN IGS_PS_FEE_TRG.FEE_TYPE%TYPE ,
61: p_course_cd IN IGS_PS_FEE_TRG.course_cd%TYPE ,
62: p_sequence_number IN IGS_PS_FEE_TRG.sequence_number%TYPE ,
63: p_new_version_number IN IGS_PS_FEE_TRG.version_number%TYPE ,
64: p_old_version_number IN IGS_PS_FEE_TRG.version_number%TYPE ,
57: p_fee_cat IN IGS_PS_FEE_TRG.FEE_CAT%TYPE ,
58: p_fee_cal_type IN IGS_PS_FEE_TRG.fee_cal_type%TYPE ,
59: p_fee_ci_sequence_number IN IGS_PS_FEE_TRG.fee_ci_sequence_number%TYPE ,
60: p_fee_type IN IGS_PS_FEE_TRG.FEE_TYPE%TYPE ,
61: p_course_cd IN IGS_PS_FEE_TRG.course_cd%TYPE ,
62: p_sequence_number IN IGS_PS_FEE_TRG.sequence_number%TYPE ,
63: p_new_version_number IN IGS_PS_FEE_TRG.version_number%TYPE ,
64: p_old_version_number IN IGS_PS_FEE_TRG.version_number%TYPE ,
65: p_new_cal_type IN IGS_PS_FEE_TRG.CAL_TYPE%TYPE ,
58: p_fee_cal_type IN IGS_PS_FEE_TRG.fee_cal_type%TYPE ,
59: p_fee_ci_sequence_number IN IGS_PS_FEE_TRG.fee_ci_sequence_number%TYPE ,
60: p_fee_type IN IGS_PS_FEE_TRG.FEE_TYPE%TYPE ,
61: p_course_cd IN IGS_PS_FEE_TRG.course_cd%TYPE ,
62: p_sequence_number IN IGS_PS_FEE_TRG.sequence_number%TYPE ,
63: p_new_version_number IN IGS_PS_FEE_TRG.version_number%TYPE ,
64: p_old_version_number IN IGS_PS_FEE_TRG.version_number%TYPE ,
65: p_new_cal_type IN IGS_PS_FEE_TRG.CAL_TYPE%TYPE ,
66: p_old_cal_type IN IGS_PS_FEE_TRG.CAL_TYPE%TYPE ,
59: p_fee_ci_sequence_number IN IGS_PS_FEE_TRG.fee_ci_sequence_number%TYPE ,
60: p_fee_type IN IGS_PS_FEE_TRG.FEE_TYPE%TYPE ,
61: p_course_cd IN IGS_PS_FEE_TRG.course_cd%TYPE ,
62: p_sequence_number IN IGS_PS_FEE_TRG.sequence_number%TYPE ,
63: p_new_version_number IN IGS_PS_FEE_TRG.version_number%TYPE ,
64: p_old_version_number IN IGS_PS_FEE_TRG.version_number%TYPE ,
65: p_new_cal_type IN IGS_PS_FEE_TRG.CAL_TYPE%TYPE ,
66: p_old_cal_type IN IGS_PS_FEE_TRG.CAL_TYPE%TYPE ,
67: p_new_location_cd IN IGS_PS_FEE_TRG.location_cd%TYPE ,
60: p_fee_type IN IGS_PS_FEE_TRG.FEE_TYPE%TYPE ,
61: p_course_cd IN IGS_PS_FEE_TRG.course_cd%TYPE ,
62: p_sequence_number IN IGS_PS_FEE_TRG.sequence_number%TYPE ,
63: p_new_version_number IN IGS_PS_FEE_TRG.version_number%TYPE ,
64: p_old_version_number IN IGS_PS_FEE_TRG.version_number%TYPE ,
65: p_new_cal_type IN IGS_PS_FEE_TRG.CAL_TYPE%TYPE ,
66: p_old_cal_type IN IGS_PS_FEE_TRG.CAL_TYPE%TYPE ,
67: p_new_location_cd IN IGS_PS_FEE_TRG.location_cd%TYPE ,
68: p_old_location_cd IN IGS_PS_FEE_TRG.location_cd%TYPE ,
61: p_course_cd IN IGS_PS_FEE_TRG.course_cd%TYPE ,
62: p_sequence_number IN IGS_PS_FEE_TRG.sequence_number%TYPE ,
63: p_new_version_number IN IGS_PS_FEE_TRG.version_number%TYPE ,
64: p_old_version_number IN IGS_PS_FEE_TRG.version_number%TYPE ,
65: p_new_cal_type IN IGS_PS_FEE_TRG.CAL_TYPE%TYPE ,
66: p_old_cal_type IN IGS_PS_FEE_TRG.CAL_TYPE%TYPE ,
67: p_new_location_cd IN IGS_PS_FEE_TRG.location_cd%TYPE ,
68: p_old_location_cd IN IGS_PS_FEE_TRG.location_cd%TYPE ,
69: p_new_attendance_mode IN IGS_PS_FEE_TRG.ATTENDANCE_MODE%TYPE ,
62: p_sequence_number IN IGS_PS_FEE_TRG.sequence_number%TYPE ,
63: p_new_version_number IN IGS_PS_FEE_TRG.version_number%TYPE ,
64: p_old_version_number IN IGS_PS_FEE_TRG.version_number%TYPE ,
65: p_new_cal_type IN IGS_PS_FEE_TRG.CAL_TYPE%TYPE ,
66: p_old_cal_type IN IGS_PS_FEE_TRG.CAL_TYPE%TYPE ,
67: p_new_location_cd IN IGS_PS_FEE_TRG.location_cd%TYPE ,
68: p_old_location_cd IN IGS_PS_FEE_TRG.location_cd%TYPE ,
69: p_new_attendance_mode IN IGS_PS_FEE_TRG.ATTENDANCE_MODE%TYPE ,
70: p_old_attendance_mode IN IGS_PS_FEE_TRG.ATTENDANCE_MODE%TYPE ,
63: p_new_version_number IN IGS_PS_FEE_TRG.version_number%TYPE ,
64: p_old_version_number IN IGS_PS_FEE_TRG.version_number%TYPE ,
65: p_new_cal_type IN IGS_PS_FEE_TRG.CAL_TYPE%TYPE ,
66: p_old_cal_type IN IGS_PS_FEE_TRG.CAL_TYPE%TYPE ,
67: p_new_location_cd IN IGS_PS_FEE_TRG.location_cd%TYPE ,
68: p_old_location_cd IN IGS_PS_FEE_TRG.location_cd%TYPE ,
69: p_new_attendance_mode IN IGS_PS_FEE_TRG.ATTENDANCE_MODE%TYPE ,
70: p_old_attendance_mode IN IGS_PS_FEE_TRG.ATTENDANCE_MODE%TYPE ,
71: p_new_attendance_type IN IGS_PS_FEE_TRG.ATTENDANCE_TYPE%TYPE ,
64: p_old_version_number IN IGS_PS_FEE_TRG.version_number%TYPE ,
65: p_new_cal_type IN IGS_PS_FEE_TRG.CAL_TYPE%TYPE ,
66: p_old_cal_type IN IGS_PS_FEE_TRG.CAL_TYPE%TYPE ,
67: p_new_location_cd IN IGS_PS_FEE_TRG.location_cd%TYPE ,
68: p_old_location_cd IN IGS_PS_FEE_TRG.location_cd%TYPE ,
69: p_new_attendance_mode IN IGS_PS_FEE_TRG.ATTENDANCE_MODE%TYPE ,
70: p_old_attendance_mode IN IGS_PS_FEE_TRG.ATTENDANCE_MODE%TYPE ,
71: p_new_attendance_type IN IGS_PS_FEE_TRG.ATTENDANCE_TYPE%TYPE ,
72: p_old_attendance_type IN IGS_PS_FEE_TRG.ATTENDANCE_TYPE%TYPE ,
65: p_new_cal_type IN IGS_PS_FEE_TRG.CAL_TYPE%TYPE ,
66: p_old_cal_type IN IGS_PS_FEE_TRG.CAL_TYPE%TYPE ,
67: p_new_location_cd IN IGS_PS_FEE_TRG.location_cd%TYPE ,
68: p_old_location_cd IN IGS_PS_FEE_TRG.location_cd%TYPE ,
69: p_new_attendance_mode IN IGS_PS_FEE_TRG.ATTENDANCE_MODE%TYPE ,
70: p_old_attendance_mode IN IGS_PS_FEE_TRG.ATTENDANCE_MODE%TYPE ,
71: p_new_attendance_type IN IGS_PS_FEE_TRG.ATTENDANCE_TYPE%TYPE ,
72: p_old_attendance_type IN IGS_PS_FEE_TRG.ATTENDANCE_TYPE%TYPE ,
73: p_new_create_dt IN IGS_PS_FEE_TRG.create_dt%TYPE ,
66: p_old_cal_type IN IGS_PS_FEE_TRG.CAL_TYPE%TYPE ,
67: p_new_location_cd IN IGS_PS_FEE_TRG.location_cd%TYPE ,
68: p_old_location_cd IN IGS_PS_FEE_TRG.location_cd%TYPE ,
69: p_new_attendance_mode IN IGS_PS_FEE_TRG.ATTENDANCE_MODE%TYPE ,
70: p_old_attendance_mode IN IGS_PS_FEE_TRG.ATTENDANCE_MODE%TYPE ,
71: p_new_attendance_type IN IGS_PS_FEE_TRG.ATTENDANCE_TYPE%TYPE ,
72: p_old_attendance_type IN IGS_PS_FEE_TRG.ATTENDANCE_TYPE%TYPE ,
73: p_new_create_dt IN IGS_PS_FEE_TRG.create_dt%TYPE ,
74: p_old_create_dt IN IGS_PS_FEE_TRG.create_dt%TYPE ,
67: p_new_location_cd IN IGS_PS_FEE_TRG.location_cd%TYPE ,
68: p_old_location_cd IN IGS_PS_FEE_TRG.location_cd%TYPE ,
69: p_new_attendance_mode IN IGS_PS_FEE_TRG.ATTENDANCE_MODE%TYPE ,
70: p_old_attendance_mode IN IGS_PS_FEE_TRG.ATTENDANCE_MODE%TYPE ,
71: p_new_attendance_type IN IGS_PS_FEE_TRG.ATTENDANCE_TYPE%TYPE ,
72: p_old_attendance_type IN IGS_PS_FEE_TRG.ATTENDANCE_TYPE%TYPE ,
73: p_new_create_dt IN IGS_PS_FEE_TRG.create_dt%TYPE ,
74: p_old_create_dt IN IGS_PS_FEE_TRG.create_dt%TYPE ,
75: p_new_fee_trigger_group_number IN IGS_PS_FEE_TRG.fee_trigger_group_number%TYPE ,
68: p_old_location_cd IN IGS_PS_FEE_TRG.location_cd%TYPE ,
69: p_new_attendance_mode IN IGS_PS_FEE_TRG.ATTENDANCE_MODE%TYPE ,
70: p_old_attendance_mode IN IGS_PS_FEE_TRG.ATTENDANCE_MODE%TYPE ,
71: p_new_attendance_type IN IGS_PS_FEE_TRG.ATTENDANCE_TYPE%TYPE ,
72: p_old_attendance_type IN IGS_PS_FEE_TRG.ATTENDANCE_TYPE%TYPE ,
73: p_new_create_dt IN IGS_PS_FEE_TRG.create_dt%TYPE ,
74: p_old_create_dt IN IGS_PS_FEE_TRG.create_dt%TYPE ,
75: p_new_fee_trigger_group_number IN IGS_PS_FEE_TRG.fee_trigger_group_number%TYPE ,
76: p_old_fee_trigger_group_number IN IGS_PS_FEE_TRG.fee_trigger_group_number%TYPE ,
69: p_new_attendance_mode IN IGS_PS_FEE_TRG.ATTENDANCE_MODE%TYPE ,
70: p_old_attendance_mode IN IGS_PS_FEE_TRG.ATTENDANCE_MODE%TYPE ,
71: p_new_attendance_type IN IGS_PS_FEE_TRG.ATTENDANCE_TYPE%TYPE ,
72: p_old_attendance_type IN IGS_PS_FEE_TRG.ATTENDANCE_TYPE%TYPE ,
73: p_new_create_dt IN IGS_PS_FEE_TRG.create_dt%TYPE ,
74: p_old_create_dt IN IGS_PS_FEE_TRG.create_dt%TYPE ,
75: p_new_fee_trigger_group_number IN IGS_PS_FEE_TRG.fee_trigger_group_number%TYPE ,
76: p_old_fee_trigger_group_number IN IGS_PS_FEE_TRG.fee_trigger_group_number%TYPE ,
77: p_new_last_updated_by IN IGS_PS_FEE_TRG.last_updated_by%TYPE ,
70: p_old_attendance_mode IN IGS_PS_FEE_TRG.ATTENDANCE_MODE%TYPE ,
71: p_new_attendance_type IN IGS_PS_FEE_TRG.ATTENDANCE_TYPE%TYPE ,
72: p_old_attendance_type IN IGS_PS_FEE_TRG.ATTENDANCE_TYPE%TYPE ,
73: p_new_create_dt IN IGS_PS_FEE_TRG.create_dt%TYPE ,
74: p_old_create_dt IN IGS_PS_FEE_TRG.create_dt%TYPE ,
75: p_new_fee_trigger_group_number IN IGS_PS_FEE_TRG.fee_trigger_group_number%TYPE ,
76: p_old_fee_trigger_group_number IN IGS_PS_FEE_TRG.fee_trigger_group_number%TYPE ,
77: p_new_last_updated_by IN IGS_PS_FEE_TRG.last_updated_by%TYPE ,
78: p_old_last_updated_by IN IGS_PS_FEE_TRG.last_updated_by%TYPE ,
71: p_new_attendance_type IN IGS_PS_FEE_TRG.ATTENDANCE_TYPE%TYPE ,
72: p_old_attendance_type IN IGS_PS_FEE_TRG.ATTENDANCE_TYPE%TYPE ,
73: p_new_create_dt IN IGS_PS_FEE_TRG.create_dt%TYPE ,
74: p_old_create_dt IN IGS_PS_FEE_TRG.create_dt%TYPE ,
75: p_new_fee_trigger_group_number IN IGS_PS_FEE_TRG.fee_trigger_group_number%TYPE ,
76: p_old_fee_trigger_group_number IN IGS_PS_FEE_TRG.fee_trigger_group_number%TYPE ,
77: p_new_last_updated_by IN IGS_PS_FEE_TRG.last_updated_by%TYPE ,
78: p_old_last_updated_by IN IGS_PS_FEE_TRG.last_updated_by%TYPE ,
79: p_new_last_update_date IN IGS_PS_FEE_TRG.last_update_date%TYPE ,
72: p_old_attendance_type IN IGS_PS_FEE_TRG.ATTENDANCE_TYPE%TYPE ,
73: p_new_create_dt IN IGS_PS_FEE_TRG.create_dt%TYPE ,
74: p_old_create_dt IN IGS_PS_FEE_TRG.create_dt%TYPE ,
75: p_new_fee_trigger_group_number IN IGS_PS_FEE_TRG.fee_trigger_group_number%TYPE ,
76: p_old_fee_trigger_group_number IN IGS_PS_FEE_TRG.fee_trigger_group_number%TYPE ,
77: p_new_last_updated_by IN IGS_PS_FEE_TRG.last_updated_by%TYPE ,
78: p_old_last_updated_by IN IGS_PS_FEE_TRG.last_updated_by%TYPE ,
79: p_new_last_update_date IN IGS_PS_FEE_TRG.last_update_date%TYPE ,
80: p_old_last_update_date IN IGS_PS_FEE_TRG.last_update_date%TYPE );
73: p_new_create_dt IN IGS_PS_FEE_TRG.create_dt%TYPE ,
74: p_old_create_dt IN IGS_PS_FEE_TRG.create_dt%TYPE ,
75: p_new_fee_trigger_group_number IN IGS_PS_FEE_TRG.fee_trigger_group_number%TYPE ,
76: p_old_fee_trigger_group_number IN IGS_PS_FEE_TRG.fee_trigger_group_number%TYPE ,
77: p_new_last_updated_by IN IGS_PS_FEE_TRG.last_updated_by%TYPE ,
78: p_old_last_updated_by IN IGS_PS_FEE_TRG.last_updated_by%TYPE ,
79: p_new_last_update_date IN IGS_PS_FEE_TRG.last_update_date%TYPE ,
80: p_old_last_update_date IN IGS_PS_FEE_TRG.last_update_date%TYPE );
81: --
74: p_old_create_dt IN IGS_PS_FEE_TRG.create_dt%TYPE ,
75: p_new_fee_trigger_group_number IN IGS_PS_FEE_TRG.fee_trigger_group_number%TYPE ,
76: p_old_fee_trigger_group_number IN IGS_PS_FEE_TRG.fee_trigger_group_number%TYPE ,
77: p_new_last_updated_by IN IGS_PS_FEE_TRG.last_updated_by%TYPE ,
78: p_old_last_updated_by IN IGS_PS_FEE_TRG.last_updated_by%TYPE ,
79: p_new_last_update_date IN IGS_PS_FEE_TRG.last_update_date%TYPE ,
80: p_old_last_update_date IN IGS_PS_FEE_TRG.last_update_date%TYPE );
81: --
82: --PROCEDURE finp_ins_cma_hist has been obsolted since the table IGS_FI_CHG_MTH_APP was being obsoleted
75: p_new_fee_trigger_group_number IN IGS_PS_FEE_TRG.fee_trigger_group_number%TYPE ,
76: p_old_fee_trigger_group_number IN IGS_PS_FEE_TRG.fee_trigger_group_number%TYPE ,
77: p_new_last_updated_by IN IGS_PS_FEE_TRG.last_updated_by%TYPE ,
78: p_old_last_updated_by IN IGS_PS_FEE_TRG.last_updated_by%TYPE ,
79: p_new_last_update_date IN IGS_PS_FEE_TRG.last_update_date%TYPE ,
80: p_old_last_update_date IN IGS_PS_FEE_TRG.last_update_date%TYPE );
81: --
82: --PROCEDURE finp_ins_cma_hist has been obsolted since the table IGS_FI_CHG_MTH_APP was being obsoleted
83: -- this procedure invoked the tbh for the history rable which also is beng obsolete
76: p_old_fee_trigger_group_number IN IGS_PS_FEE_TRG.fee_trigger_group_number%TYPE ,
77: p_new_last_updated_by IN IGS_PS_FEE_TRG.last_updated_by%TYPE ,
78: p_old_last_updated_by IN IGS_PS_FEE_TRG.last_updated_by%TYPE ,
79: p_new_last_update_date IN IGS_PS_FEE_TRG.last_update_date%TYPE ,
80: p_old_last_update_date IN IGS_PS_FEE_TRG.last_update_date%TYPE );
81: --
82: --PROCEDURE finp_ins_cma_hist has been obsolted since the table IGS_FI_CHG_MTH_APP was being obsoleted
83: -- this procedure invoked the tbh for the history rable which also is beng obsolete
84: -- bug# 2187247 (rnirwani)