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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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 );
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: --
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(
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 ,
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 ,