DBA Data[Home] [Help]

APPS.IGS_FI_GEN_002 dependencies on IGS_FI_FEE_RET_SCHD

Line 212: p_fee_cal_type IN IGS_FI_FEE_RET_SCHD.fee_cal_type%TYPE ,

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 ,

Line 213: p_fee_ci_sequence_number IN IGS_FI_FEE_RET_SCHD.fee_ci_sequence_number%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 ,

Line 214: p_s_relation_type IN IGS_FI_FEE_RET_SCHD.s_relation_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 ,

Line 215: p_sequence_number IN IGS_FI_FEE_RET_SCHD.sequence_number%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 ,

Line 216: p_new_fee_type IN IGS_FI_FEE_RET_SCHD.FEE_TYPE%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 ,

Line 217: p_old_fee_type IN IGS_FI_FEE_RET_SCHD.FEE_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 ,

Line 218: p_new_fee_cat IN IGS_FI_FEE_RET_SCHD.FEE_CAT%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 ,

Line 219: p_old_fee_cat IN IGS_FI_FEE_RET_SCHD.FEE_CAT%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 ,

Line 220: p_new_schedule_number IN IGS_FI_FEE_RET_SCHD.schedule_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 ,

Line 221: p_old_schedule_number IN IGS_FI_FEE_RET_SCHD.schedule_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 ,

Line 222: p_new_dt_alias IN IGS_FI_FEE_RET_SCHD.DT_ALIAS%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 ,

Line 223: p_old_dt_alias IN IGS_FI_FEE_RET_SCHD.DT_ALIAS%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 ,

Line 224: p_new_dai_sequence_number IN IGS_FI_FEE_RET_SCHD.dai_sequence_number%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 ,

Line 225: p_old_dai_sequence_number IN IGS_FI_FEE_RET_SCHD.dai_sequence_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 ,

Line 226: p_new_retention_percentage IN IGS_FI_FEE_RET_SCHD.retention_percentage%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 ,

Line 227: p_old_retention_percentage IN IGS_FI_FEE_RET_SCHD.retention_percentage%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 ,

Line 228: p_new_retention_amount IN IGS_FI_FEE_RET_SCHD.retention_amount%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 ,

Line 229: p_old_retention_amount IN IGS_FI_FEE_RET_SCHD.retention_amount%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 );

Line 230: p_new_last_updated_by IN IGS_FI_FEE_RET_SCHD.last_updated_by%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: --

Line 231: p_old_last_updated_by IN IGS_FI_FEE_RET_SCHD.last_updated_by%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(

Line 232: p_new_last_update_date IN IGS_FI_FEE_RET_SCHD.last_update_date%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 ,

Line 233: p_old_last_update_date IN IGS_FI_FEE_RET_SCHD.last_update_date%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 ,