DBA Data[Home] [Help]

APPS.IGS_FI_GEN_002 dependencies on IGS_FI_FEE_TYPE_ALL

Line 188: p_fee_type IN IGS_FI_FEE_TYPE_ALL.FEE_TYPE%TYPE ,

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 ,

Line 269: p_fee_type IN IGS_FI_FEE_TYPE_ALL.FEE_TYPE%TYPE ,

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

Line 270: p_new_s_fee_type IN IGS_FI_FEE_TYPE_ALL.s_fee_type%TYPE ,

266: p_old_nonzero_billable_cp_flag IN IGS_FI_F_TYP_CA_INST_ALL.nonzero_billable_cp_flag%TYPE DEFAULT NULL);
267: --
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 ,

Line 271: p_old_s_fee_type IN IGS_FI_FEE_TYPE_ALL.s_fee_type%TYPE ,

267: --
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 ,

Line 272: p_new_s_fee_trigger_cat IN IGS_FI_FEE_TYPE_ALL.s_fee_trigger_cat%TYPE ,

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 ,

Line 273: p_old_s_fee_trigger_cat IN IGS_FI_FEE_TYPE_ALL.s_fee_trigger_cat%TYPE ,

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 ,

Line 274: p_new_description IN IGS_FI_FEE_TYPE_ALL.description%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 ,

Line 275: p_old_description IN IGS_FI_FEE_TYPE_ALL.description%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 ,

Line 276: p_new_optional_payment_ind IN IGS_FI_FEE_TYPE_ALL.optional_payment_ind%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

Line 277: p_old_optional_payment_ind IN IGS_FI_FEE_TYPE_ALL.optional_payment_ind%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

Line 278: p_new_closed_ind IN IGS_FI_FEE_TYPE_ALL.closed_ind%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,

Line 279: p_old_closed_ind IN IGS_FI_FEE_TYPE_ALL.closed_ind%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,

Line 280: p_new_fee_class IN IGS_FI_FEE_TYPE_ALL.fee_class%TYPE, --for Bug 2175865 by vvutukur

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 ,

Line 281: p_old_fee_class IN IGS_FI_FEE_TYPE_ALL.fee_class%TYPE, --for Bug 2175865 by vvutukur

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 ,

Line 282: p_new_designated_payment_flag IN igs_fi_fee_type_all.designated_payment_flag%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 ,

Line 283: p_old_designated_payment_flag IN igs_fi_fee_type_all.designated_payment_flag%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 ,

Line 284: p_new_last_updated_by IN IGS_FI_FEE_TYPE_ALL.last_updated_by%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 ,

Line 285: p_old_last_updated_by IN IGS_FI_FEE_TYPE_ALL.last_updated_by%TYPE ,

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 );

Line 286: p_new_last_update_date IN IGS_FI_FEE_TYPE_ALL.last_update_date%TYPE ,

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:

Line 287: p_old_last_update_date IN IGS_FI_FEE_TYPE_ALL.last_update_date%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: --

Line 288: p_new_comments IN IGS_FI_FEE_TYPE_ALL.comments%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(

Line 289: p_old_comments IN IGS_FI_FEE_TYPE_ALL.comments%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 ,