1 PACKAGE igs_fi_gen_002 AS
2 /* $Header: IGSFI02S.pls 120.1 2005/06/05 20:26:20 appldev $ */
3 --HISTORY
4 --Who When What
5 -- svuppala 31-MAY-2005 Enh 3442712: Added Unit Program Type Level, Unit Mode, Unit Class, Unit Code,
6 -- Unit Version and Unit Level
7 --svuppala 13-Apr-2005 Bug 4297359 Added new field NONZERO_BILLABLE_CP_FLAG in IGS_FI_FEE_TYPE_CI_H_ALL
8 --pathipat 09-Sep-2003 Enh 3108052 - Add Unit Sets to Rate Table
9 -- Added 4 new params for unit_set_cd and us_version_number
10 -- in procedure finp_ins_far_hist()
11 --shtatiko 30-MAY-2003 Enh# 2831582, Added new column designated_payment_flag. As an impact modified finp_ins_ft_hist.
12 -- npalanis 23-OCT-2002 Bug : 2608360
13 -- p_new and p_old residency_status_id column is changed to p_residency_status_cd of
14 -- datatype varchar2.
15 --vvutukur 13-Sep-2002 Enh#2564643.Removed parameters p_old_subaccount_id,p_new_subaccount_id
16 -- from procedure finp_ins_ft_hist.
17 --smvk 28-Aug-2002 Procedure finp_ins_fdf_hist is obsolete as part of Build SFCR005_Cleanup_Build (Enhancement Bug # 2531390)
18 --vvutukur 28-Aug-2002 Bug#2531390.Removed the procedure finp_ins_fps_hist.
19 --jbegum 26-Aug-2002 As part of Enh Bug#2531390 the procedure finp_ins_pps_hist was removed.
20 --vvutukur 18-Jul-2002 Bug#2425767. Removed parameters p_new_deduction_amount,p_old_deduction_amount
21 -- from procedure finp_ins_frtns_hist and parameters p_new_payment_hierarchy_rank,
22 -- p_old_payment_hierarchy_rank from procedures finp_ins_fcfl_hist and
23 -- finp_ins_ftci_hist.
24 --vchappid 26-Apr-2002 Bug#2329407, removed the parameters fin_cal_type, fin_ci_sequence_number, account_cd from
25 -- the procedure finp_ins_ftci_hist
26 -- rnirwani 18-Jan-2002 Obsolete proc FINP_INS_CMA_HIST (2187247)
27 --masehgal 16-Jan-2002 ENH # 2170429
28 -- Obsoletion of SPONSOR_CD,SPONSORED_AMOUNT from finp_ins_pps_hist
29 --vvutukur 11-Jan-2002 added new columns to finp_ins_ft_hist
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 ,
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 ,
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 );
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 ,
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 ,
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 --
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)
85 --
86 PROCEDURE finp_ins_er_hist(
87 p_fee_type IN IGS_FI_ELM_RANGE.FEE_TYPE%TYPE ,
88 p_fee_cal_type IN IGS_FI_ELM_RANGE.fee_cal_type%TYPE ,
89 p_fee_ci_sequence_number IN IGS_FI_ELM_RANGE.fee_ci_sequence_number%TYPE ,
90 p_s_relation_type IN IGS_FI_ELM_RANGE.s_relation_type%TYPE ,
91 p_range_number IN IGS_FI_ELM_RANGE.range_number%TYPE ,
92 p_new_fee_cat IN IGS_FI_ELM_RANGE.FEE_CAT%TYPE ,
93 p_old_fee_cat IN IGS_FI_ELM_RANGE.FEE_CAT%TYPE ,
94 p_new_lower_range IN IGS_FI_ELM_RANGE.lower_range%TYPE ,
95 p_old_lower_range IN IGS_FI_ELM_RANGE.lower_range%TYPE ,
96 p_new_upper_range IN IGS_FI_ELM_RANGE.upper_range%TYPE ,
97 p_old_upper_range IN IGS_FI_ELM_RANGE.upper_range%TYPE ,
98 p_new_s_chg_method_type IN IGS_FI_ELM_RANGE.s_chg_method_type%TYPE ,
99 p_old_s_chg_method_type IN IGS_FI_ELM_RANGE.s_chg_method_type%TYPE ,
100 p_new_last_updated_by IN IGS_FI_ELM_RANGE.last_updated_by%TYPE ,
101 p_old_last_updated_by IN IGS_FI_ELM_RANGE.last_updated_by%TYPE ,
102 p_new_last_update_date IN IGS_FI_ELM_RANGE.last_update_date%TYPE ,
103 p_old_last_update_date IN IGS_FI_ELM_RANGE.last_update_date%TYPE );
104 --
105 PROCEDURE finp_ins_far_hist(
106 p_fee_type IN IGS_FI_FEE_AS_RATE.FEE_TYPE%TYPE ,
107 p_fee_cal_type IN IGS_FI_FEE_AS_RATE.fee_cal_type%TYPE ,
108 p_fee_ci_sequence_number IN IGS_FI_FEE_AS_RATE.fee_ci_sequence_number%TYPE ,
109 p_s_relation_type IN IGS_FI_FEE_AS_RATE.s_relation_type%TYPE ,
110 p_rate_number IN IGS_FI_FEE_AS_RATE.rate_number%TYPE ,
111 p_new_fee_cat IN IGS_FI_FEE_AS_RATE.FEE_CAT%TYPE ,
112 p_old_fee_cat IN IGS_FI_FEE_AS_RATE.FEE_CAT%TYPE ,
113 p_new_location_cd IN IGS_FI_FEE_AS_RATE.location_cd%TYPE ,
114 p_old_location_cd IN IGS_FI_FEE_AS_RATE.location_cd%TYPE ,
115 p_new_attendance_type IN IGS_FI_FEE_AS_RATE.ATTENDANCE_TYPE%TYPE ,
116 p_old_attendance_type IN IGS_FI_FEE_AS_RATE.ATTENDANCE_TYPE%TYPE ,
117 p_new_attendance_mode IN IGS_FI_FEE_AS_RATE.ATTENDANCE_MODE%TYPE ,
118 p_old_attendance_mode IN IGS_FI_FEE_AS_RATE.ATTENDANCE_MODE%TYPE ,
119 p_new_order_of_precedence IN IGS_FI_FEE_AS_RATE.order_of_precedence%TYPE ,
120 p_old_order_of_precedence IN IGS_FI_FEE_AS_RATE.order_of_precedence%TYPE ,
121 p_new_govt_hecs_payment_option IN IGS_FI_FEE_AS_RATE.GOVT_HECS_PAYMENT_OPTION%TYPE ,
122 p_old_govt_hecs_payment_option IN IGS_FI_FEE_AS_RATE.GOVT_HECS_PAYMENT_OPTION%TYPE ,
123 p_new_govt_hecs_cntrbtn_band IN IGS_FI_FEE_AS_RATE.govt_hecs_cntrbtn_band%TYPE ,
124 p_old_govt_hecs_cntrbtn_band IN IGS_FI_FEE_AS_RATE.govt_hecs_cntrbtn_band%TYPE ,
125 p_new_chg_rate IN IGS_FI_FEE_AS_RATE.chg_rate%TYPE ,
126 p_old_chg_rate IN IGS_FI_FEE_AS_RATE.chg_rate%TYPE ,
127 p_new_unit_class IN IGS_FI_FEE_AS_RATE.unit_class%TYPE ,
128 p_old_unit_class IN IGS_FI_FEE_AS_RATE.unit_class%TYPE ,
129 -- Added by Nishikant , to include the following five new fields for enhancement bug#1851586
130 p_new_residency_status_cd IN IGS_FI_FEE_AS_RATE.residency_status_cd%TYPE DEFAULT NULL,
131 p_old_residency_status_cd IN IGS_FI_FEE_AS_RATE.residency_status_cd%TYPE DEFAULT NULL,
132 p_new_course_cd IN IGS_FI_FEE_AS_RATE.course_cd%TYPE DEFAULT NULL,
133 p_old_course_cd IN IGS_FI_FEE_AS_RATE.course_cd%TYPE DEFAULT NULL,
134 p_new_version_number IN IGS_FI_FEE_AS_RATE.version_number%TYPE DEFAULT NULL,
135 p_old_version_number IN IGS_FI_FEE_AS_RATE.version_number%TYPE DEFAULT NULL,
136 p_new_org_party_id IN IGS_FI_FEE_AS_RATE.org_party_id%TYPE DEFAULT NULL,
137 p_old_org_party_id IN IGS_FI_FEE_AS_RATE.org_party_id%TYPE DEFAULT NULL,
138 p_new_class_standing IN IGS_FI_FEE_AS_RATE.class_standing%TYPE DEFAULT NULL,
139 p_old_class_standing IN IGS_FI_FEE_AS_RATE.class_standing%TYPE DEFAULT NULL,
140 p_new_last_updated_by IN IGS_FI_FEE_AS_RATE.last_updated_by%TYPE DEFAULT NULL,
141 p_old_last_updated_by IN IGS_FI_FEE_AS_RATE.last_updated_by%TYPE DEFAULT NULL,
142 p_new_last_update_date IN IGS_FI_FEE_AS_RATE.last_update_date%TYPE DEFAULT NULL,
143 p_old_last_update_date IN IGS_FI_FEE_AS_RATE.last_update_date%TYPE DEFAULT NULL,
144 p_new_unit_set_cd IN igs_fi_fee_as_rate.unit_set_cd%TYPE DEFAULT NULL,
145 p_old_unit_set_cd IN igs_fi_fee_as_rate.unit_set_cd%TYPE DEFAULT NULL,
146 p_new_us_version_number IN igs_fi_fee_as_rate.us_version_number%TYPE DEFAULT NULL,
147 p_old_us_version_number IN igs_fi_fee_as_rate.us_version_number%TYPE DEFAULT NULL,
148 p_new_unit_cd IN igs_fi_fee_as_rate.unit_cd%TYPE DEFAULT NULL,
149 p_old_unit_cd IN igs_fi_fee_as_rate.unit_cd%TYPE DEFAULT NULL,
150 p_new_unit_version_number IN igs_fi_fee_as_rate.unit_version_number%TYPE DEFAULT NULL,
151 p_old_unit_version_number IN igs_fi_fee_as_rate.unit_version_number%TYPE DEFAULT NULL,
152 p_new_unit_level IN igs_fi_fee_as_rate.unit_level%TYPE DEFAULT NULL,
153 p_old_unit_level IN igs_fi_fee_as_rate.unit_level%TYPE DEFAULT NULL,
154 p_new_unit_type_id IN igs_fi_fee_as_rate.unit_type_id%TYPE DEFAULT NULL,
155 p_old_unit_type_id IN igs_fi_fee_as_rate.unit_type_id%TYPE DEFAULT NULL,
156 p_new_unit_mode IN igs_fi_fee_as_rate.unit_mode%TYPE DEFAULT NULL,
157 p_old_unit_mode IN igs_fi_fee_as_rate.unit_mode%TYPE DEFAULT NULL
158
159 );
160 --
161 PROCEDURE finp_ins_fcci_hist(
162 p_fee_cat IN IGS_FI_F_CAT_CA_INST.FEE_CAT%TYPE ,
163 p_fee_cal_type IN IGS_FI_F_CAT_CA_INST.fee_cal_type%TYPE ,
164 p_fee_ci_sequence_number IN IGS_FI_F_CAT_CA_INST.fee_ci_sequence_number%TYPE ,
165 p_new_fee_cat_ci_status IN IGS_FI_F_CAT_CA_INST.fee_cat_ci_status%TYPE ,
166 p_old_fee_cat_ci_status IN IGS_FI_F_CAT_CA_INST.fee_cat_ci_status%TYPE ,
167 p_new_start_dt_alias IN IGS_FI_F_CAT_CA_INST.start_dt_alias%TYPE ,
168 p_old_start_dt_alias IN IGS_FI_F_CAT_CA_INST.start_dt_alias%TYPE ,
169 p_new_start_dai_sequence_num IN IGS_FI_F_CAT_CA_INST.start_dai_sequence_number%TYPE ,
170 p_old_start_dai_sequence_num IN IGS_FI_F_CAT_CA_INST.start_dai_sequence_number%TYPE ,
171 p_new_end_dt_alias IN IGS_FI_F_CAT_CA_INST.end_dt_alias%TYPE ,
172 p_old_end_dt_alias IN IGS_FI_F_CAT_CA_INST.end_dt_alias%TYPE ,
173 p_new_end_dai_sequence_num IN IGS_FI_F_CAT_CA_INST.end_dai_sequence_number%TYPE ,
174 p_old_end_dai_sequence_num IN IGS_FI_F_CAT_CA_INST.end_dai_sequence_number%TYPE ,
175 p_new_retro_dt_alias IN IGS_FI_F_CAT_CA_INST.retro_dt_alias%TYPE ,
176 p_old_retro_dt_alias IN IGS_FI_F_CAT_CA_INST.retro_dt_alias%TYPE ,
177 p_new_retro_dai_sequence_num IN IGS_FI_F_CAT_CA_INST.retro_dai_sequence_number%TYPE ,
178 p_old_retro_dai_sequence_num IN IGS_FI_F_CAT_CA_INST.retro_dai_sequence_number%TYPE ,
179 p_new_last_updated_by IN IGS_FI_F_CAT_CA_INST.last_updated_by%TYPE ,
180 p_old_last_updated_by IN IGS_FI_F_CAT_CA_INST.last_updated_by%TYPE ,
181 p_new_last_update_date IN IGS_FI_F_CAT_CA_INST.last_update_date%TYPE ,
182 p_old_last_update_date IN IGS_FI_F_CAT_CA_INST.last_update_date%TYPE );
183 --
184 PROCEDURE finp_ins_fcfl_hist(
185 p_fee_cat IN IGS_FI_FEE_CAT_ALL.FEE_CAT%TYPE ,
186 p_fee_cal_type IN IGS_CA_TYPE.CAL_TYPE%TYPE ,
187 p_fee_ci_sequence_number IN IGS_CA_INST_ALL.sequence_number%TYPE ,
188 p_fee_type IN IGS_FI_FEE_TYPE_ALL.FEE_TYPE%TYPE ,
189 p_new_fee_liability_status IN VARCHAR2 ,
190 p_old_fee_liability_status IN VARCHAR2 ,
191 p_new_start_dt_alias IN IGS_CA_DA.DT_ALIAS%TYPE ,
192 p_old_start_dt_alias IN IGS_CA_DA.DT_ALIAS%TYPE ,
193 p_new_start_dai_sequence_num IN IGS_CA_DA_INST.sequence_number%TYPE ,
194 p_old_start_dai_sequence_num IN IGS_CA_DA_INST.sequence_number%TYPE ,
195 p_new_s_chg_method_type IN FND_LOOKUP_VALUES.lookup_code%TYPE ,
196 p_old_s_chg_method_type IN FND_LOOKUP_VALUES.lookup_code%TYPE ,
197 p_new_rul_sequence_number IN IGS_RU_RULE.sequence_number%TYPE ,
198 p_old_rul_sequence_number IN IGS_RU_RULE.sequence_number%TYPE ,
199 p_new_last_updated_by IN IGS_FI_F_CAT_FEE_LBL_ALL.last_updated_by%TYPE ,
200 p_old_last_updated_by IN IGS_FI_F_CAT_FEE_LBL_ALL.last_updated_by%TYPE ,
201 p_new_last_update_date IN IGS_FI_F_CAT_FEE_LBL_ALL.last_update_date%TYPE ,
202 p_old_last_update_date IN IGS_FI_F_CAT_FEE_LBL_ALL.last_update_date%TYPE );
203 --
204 /* procedure finp_ins_fdf_hist is obsolete as part of Build SFCR005_Cleanup_Build (Enhancement Bug # 2531390) */
205 --
206 /* Obseleted the procedure finp_ins_fe_hist( as part of bug 2126091 as this is no longer used -sykrishn 29112001 */
207 --
208 --Removed procedure finp_ins_fps_hist as part of SFCR005- Clean Up Build. Bug#2531390.
209
210 --
211 PROCEDURE finp_ins_frtns_hist(
212 p_fee_cal_type IN IGS_FI_FEE_RET_SCHD.fee_cal_type%TYPE ,
213 p_fee_ci_sequence_number IN IGS_FI_FEE_RET_SCHD.fee_ci_sequence_number%TYPE ,
214 p_s_relation_type IN IGS_FI_FEE_RET_SCHD.s_relation_type%TYPE ,
215 p_sequence_number IN IGS_FI_FEE_RET_SCHD.sequence_number%TYPE ,
216 p_new_fee_type IN IGS_FI_FEE_RET_SCHD.FEE_TYPE%TYPE ,
217 p_old_fee_type IN IGS_FI_FEE_RET_SCHD.FEE_TYPE%TYPE ,
218 p_new_fee_cat IN IGS_FI_FEE_RET_SCHD.FEE_CAT%TYPE ,
219 p_old_fee_cat IN IGS_FI_FEE_RET_SCHD.FEE_CAT%TYPE ,
220 p_new_schedule_number IN IGS_FI_FEE_RET_SCHD.schedule_number%TYPE ,
221 p_old_schedule_number IN IGS_FI_FEE_RET_SCHD.schedule_number%TYPE ,
222 p_new_dt_alias IN IGS_FI_FEE_RET_SCHD.DT_ALIAS%TYPE ,
223 p_old_dt_alias IN IGS_FI_FEE_RET_SCHD.DT_ALIAS%TYPE ,
224 p_new_dai_sequence_number IN IGS_FI_FEE_RET_SCHD.dai_sequence_number%TYPE ,
225 p_old_dai_sequence_number IN IGS_FI_FEE_RET_SCHD.dai_sequence_number%TYPE ,
226 p_new_retention_percentage IN IGS_FI_FEE_RET_SCHD.retention_percentage%TYPE ,
227 p_old_retention_percentage IN IGS_FI_FEE_RET_SCHD.retention_percentage%TYPE ,
228 p_new_retention_amount IN IGS_FI_FEE_RET_SCHD.retention_amount%TYPE ,
229 p_old_retention_amount IN IGS_FI_FEE_RET_SCHD.retention_amount%TYPE ,
230 p_new_last_updated_by IN IGS_FI_FEE_RET_SCHD.last_updated_by%TYPE ,
231 p_old_last_updated_by IN IGS_FI_FEE_RET_SCHD.last_updated_by%TYPE ,
232 p_new_last_update_date IN IGS_FI_FEE_RET_SCHD.last_update_date%TYPE ,
233 p_old_last_update_date IN IGS_FI_FEE_RET_SCHD.last_update_date%TYPE );
234 --
235 PROCEDURE finp_ins_ftci_hist(
236 p_fee_type IN IGS_FI_F_TYP_CA_INST_ALL.FEE_TYPE%TYPE ,
237 p_fee_cal_type IN IGS_FI_F_TYP_CA_INST_ALL.fee_cal_type%TYPE ,
238 p_fee_ci_sequence_number IN IGS_FI_F_TYP_CA_INST_ALL.fee_ci_sequence_number%TYPE ,
239 p_new_fee_type_ci_status IN IGS_FI_F_TYP_CA_INST_ALL.fee_type_ci_status%TYPE ,
240 p_old_fee_type_ci_status IN IGS_FI_F_TYP_CA_INST_ALL.fee_type_ci_status%TYPE ,
241 p_new_start_dt_alias IN IGS_FI_F_TYP_CA_INST_ALL.start_dt_alias%TYPE ,
242 p_old_start_dt_alias IN IGS_FI_F_TYP_CA_INST_ALL.start_dt_alias%TYPE ,
243 p_new_start_dai_sequence_num IN IGS_FI_F_TYP_CA_INST_ALL.start_dai_sequence_number%TYPE ,
244 p_old_start_dai_sequence_num IN IGS_FI_F_TYP_CA_INST_ALL.start_dai_sequence_number%TYPE ,
245 p_new_end_dt_alias IN IGS_FI_F_TYP_CA_INST_ALL.end_dt_alias%TYPE ,
246 p_old_end_dt_alias IN IGS_FI_F_TYP_CA_INST_ALL.end_dt_alias%TYPE ,
247 p_new_end_dai_sequence_number IN IGS_FI_F_TYP_CA_INST_ALL.end_dai_sequence_number%TYPE ,
248 p_old_end_dai_sequence_number IN IGS_FI_F_TYP_CA_INST_ALL.end_dai_sequence_number%TYPE ,
249 p_new_retro_dt_alias IN IGS_FI_F_TYP_CA_INST_ALL.retro_dt_alias%TYPE ,
250 p_old_retro_dt_alias IN IGS_FI_F_TYP_CA_INST_ALL.retro_dt_alias%TYPE ,
251 p_new_retro_dai_sequence_num IN IGS_FI_F_TYP_CA_INST_ALL.retro_dai_sequence_number%TYPE ,
252 p_old_retro_dai_sequence_num IN IGS_FI_F_TYP_CA_INST_ALL.retro_dai_sequence_number%TYPE ,
253 p_new_s_chg_method_type IN IGS_FI_F_TYP_CA_INST_ALL.s_chg_method_type%TYPE ,
254 p_old_s_chg_method_type IN IGS_FI_F_TYP_CA_INST_ALL.s_chg_method_type%TYPE ,
255 p_new_rul_sequence_number IN IGS_FI_F_TYP_CA_INST_ALL.rul_sequence_number%TYPE ,
256 p_old_rul_sequence_number IN IGS_FI_F_TYP_CA_INST_ALL.rul_sequence_number%TYPE ,
257 p_new_last_updated_by IN IGS_FI_F_TYP_CA_INST_ALL.last_updated_by%TYPE ,
258 p_old_last_updated_by IN IGS_FI_F_TYP_CA_INST_ALL.last_updated_by%TYPE ,
259 p_new_last_update_date IN IGS_FI_F_TYP_CA_INST_ALL.last_update_date%TYPE ,
260 p_old_last_update_date IN IGS_FI_F_TYP_CA_INST_ALL.last_update_date%TYPE ,
261 -- Added by Nishikant , to include the following new field for enhancement bug#1851586
262 p_new_initial_default_amount IN IGS_FI_F_TYP_CA_INST_ALL.initial_default_amount%TYPE DEFAULT NULL,
263 p_old_initial_default_amount IN IGS_FI_F_TYP_CA_INST_ALL.initial_default_amount%TYPE DEFAULT NULL,
267 --
264 --Added by svuppala,as a part of bug:4295379 New field "nonzero_billable_cp_flag"
265 p_new_nonzero_billable_cp_flag IN IGS_FI_F_TYP_CA_INST_ALL.nonzero_billable_cp_flag%TYPE DEFAULT NULL,
266 p_old_nonzero_billable_cp_flag IN IGS_FI_F_TYP_CA_INST_ALL.nonzero_billable_cp_flag%TYPE DEFAULT NULL);
268 PROCEDURE finp_ins_ft_hist(
269 p_fee_type IN IGS_FI_FEE_TYPE_ALL.FEE_TYPE%TYPE ,
270 p_new_s_fee_type IN IGS_FI_FEE_TYPE_ALL.s_fee_type%TYPE ,
271 p_old_s_fee_type IN IGS_FI_FEE_TYPE_ALL.s_fee_type%TYPE ,
272 p_new_s_fee_trigger_cat IN IGS_FI_FEE_TYPE_ALL.s_fee_trigger_cat%TYPE ,
273 p_old_s_fee_trigger_cat IN IGS_FI_FEE_TYPE_ALL.s_fee_trigger_cat%TYPE ,
274 p_new_description IN IGS_FI_FEE_TYPE_ALL.description%TYPE ,
275 p_old_description IN IGS_FI_FEE_TYPE_ALL.description%TYPE ,
276 p_new_optional_payment_ind IN IGS_FI_FEE_TYPE_ALL.optional_payment_ind%TYPE ,
277 p_old_optional_payment_ind IN IGS_FI_FEE_TYPE_ALL.optional_payment_ind%TYPE ,
278 p_new_closed_ind IN IGS_FI_FEE_TYPE_ALL.closed_ind%TYPE ,
279 p_old_closed_ind IN IGS_FI_FEE_TYPE_ALL.closed_ind%TYPE ,
280 p_new_fee_class IN IGS_FI_FEE_TYPE_ALL.fee_class%TYPE, --for Bug 2175865 by vvutukur
281 p_old_fee_class IN IGS_FI_FEE_TYPE_ALL.fee_class%TYPE, --for Bug 2175865 by vvutukur
282 p_new_designated_payment_flag IN igs_fi_fee_type_all.designated_payment_flag%TYPE,
283 p_old_designated_payment_flag IN igs_fi_fee_type_all.designated_payment_flag%TYPE,
284 p_new_last_updated_by IN IGS_FI_FEE_TYPE_ALL.last_updated_by%TYPE ,
285 p_old_last_updated_by IN IGS_FI_FEE_TYPE_ALL.last_updated_by%TYPE ,
286 p_new_last_update_date IN IGS_FI_FEE_TYPE_ALL.last_update_date%TYPE ,
287 p_old_last_update_date IN IGS_FI_FEE_TYPE_ALL.last_update_date%TYPE ,
288 p_new_comments IN IGS_FI_FEE_TYPE_ALL.comments%TYPE ,
289 p_old_comments IN IGS_FI_FEE_TYPE_ALL.comments%TYPE );
290
291 --
292 PROCEDURE finp_ins_uft_hist(
293 p_fee_cat IN IGS_FI_UNIT_FEE_TRG.FEE_CAT%TYPE ,
294 p_fee_cal_type IN IGS_FI_UNIT_FEE_TRG.fee_cal_type%TYPE ,
295 p_fee_ci_sequence_number IN IGS_FI_UNIT_FEE_TRG.fee_ci_sequence_number%TYPE ,
296 p_fee_type IN IGS_FI_UNIT_FEE_TRG.FEE_TYPE%TYPE ,
297 p_unit_cd IN IGS_FI_UNIT_FEE_TRG.unit_cd%TYPE ,
298 p_sequence_number IN IGS_FI_UNIT_FEE_TRG.sequence_number%TYPE ,
299 p_new_version_number IN IGS_FI_UNIT_FEE_TRG.version_number%TYPE ,
300 p_old_version_number IN IGS_FI_UNIT_FEE_TRG.version_number%TYPE ,
301 p_new_cal_type IN IGS_FI_UNIT_FEE_TRG.CAL_TYPE%TYPE ,
302 p_old_cal_type IN IGS_FI_UNIT_FEE_TRG.CAL_TYPE%TYPE ,
303 p_new_ci_sequence_number IN IGS_FI_UNIT_FEE_TRG.ci_sequence_number%TYPE ,
304 p_old_ci_sequence_number IN IGS_FI_UNIT_FEE_TRG.ci_sequence_number%TYPE ,
305 p_new_location_cd IN IGS_FI_UNIT_FEE_TRG.location_cd%TYPE ,
306 p_old_location_cd IN IGS_FI_UNIT_FEE_TRG.location_cd%TYPE ,
307 p_new_unit_class IN IGS_FI_UNIT_FEE_TRG.UNIT_CLASS%TYPE ,
308 p_old_unit_class IN IGS_FI_UNIT_FEE_TRG.UNIT_CLASS%TYPE ,
309 p_new_create_dt IN IGS_FI_UNIT_FEE_TRG.create_dt%TYPE ,
310 p_old_create_dt IN IGS_FI_UNIT_FEE_TRG.create_dt%TYPE ,
311 p_new_fee_trigger_group_number IN IGS_FI_UNIT_FEE_TRG.fee_trigger_group_number%TYPE ,
312 p_old_fee_trigger_group_number IN IGS_FI_UNIT_FEE_TRG.fee_trigger_group_number%TYPE ,
313 p_new_last_updated_by IN IGS_FI_UNIT_FEE_TRG.last_updated_by%TYPE ,
314 p_old_last_updated_by IN IGS_FI_UNIT_FEE_TRG.last_updated_by%TYPE ,
315 p_new_last_update_date IN IGS_FI_UNIT_FEE_TRG.last_update_date%TYPE ,
316 p_old_last_update_date IN IGS_FI_UNIT_FEE_TRG.last_update_date%TYPE );
317 --
318 -- New function as part of Bug 2324088 - SYkrishn
319 FUNCTION finp_validate_ccid (p_ccid IN igs_fi_cr_activities.dr_gl_ccid%TYPE) RETURN BOOLEAN;
320 -- New function as part of Bug 2324088 - SYkrishn
321 END IGS_FI_GEN_002;