DBA Data[Home] [Help]

APPS.IGS_FI_GEN_008 dependencies on IGS_FI_FEE_AS_ITEMS

Line 236: p_v_location_cd IN igs_fi_fee_as_items.location_cd%TYPE,

232:
233:
234:
235: PROCEDURE chk_chg_adj( p_n_person_id IN hz_parties.party_id%TYPE,
236: p_v_location_cd IN igs_fi_fee_as_items.location_cd%TYPE,
237: p_v_course_cd IN igs_ps_ver.course_cd%TYPE,
238: p_v_fee_cal_type IN igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
239: p_v_fee_cat IN igs_fi_fee_as_items.fee_cat%TYPE,
240: p_n_fee_ci_sequence_number IN igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,

Line 239: p_v_fee_cat IN igs_fi_fee_as_items.fee_cat%TYPE,

235: PROCEDURE chk_chg_adj( p_n_person_id IN hz_parties.party_id%TYPE,
236: p_v_location_cd IN igs_fi_fee_as_items.location_cd%TYPE,
237: p_v_course_cd IN igs_ps_ver.course_cd%TYPE,
238: p_v_fee_cal_type IN igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
239: p_v_fee_cat IN igs_fi_fee_as_items.fee_cat%TYPE,
240: p_n_fee_ci_sequence_number IN igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,
241: p_v_fee_type IN igs_fi_fee_type.fee_type%TYPE,
242: p_n_uoo_id IN igs_ps_unit_ofr_opt.uoo_id%TYPE,
243: p_v_transaction_type IN igs_fi_inv_int_all.transaction_type%TYPE,

Line 268: cp_location_cd igs_fi_fee_as_items.location_cd%TYPE,

264:
265: --cursor to check whether a particular charge has been reversed or declined
266: CURSOR cur_chk_rev_decl_no_inv_id(
267: cp_person_id hz_parties.party_id%TYPE,
268: cp_location_cd igs_fi_fee_as_items.location_cd%TYPE,
269: cp_course_cd igs_ps_ver.course_cd%TYPE,
270: cp_fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
271: cp_fee_cat igs_fi_fee_as_items.fee_cat%TYPE,
272: cp_fee_ci_sequence_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,

Line 271: cp_fee_cat igs_fi_fee_as_items.fee_cat%TYPE,

267: cp_person_id hz_parties.party_id%TYPE,
268: cp_location_cd igs_fi_fee_as_items.location_cd%TYPE,
269: cp_course_cd igs_ps_ver.course_cd%TYPE,
270: cp_fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
271: cp_fee_cat igs_fi_fee_as_items.fee_cat%TYPE,
272: cp_fee_ci_sequence_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,
273: cp_fee_type igs_fi_fee_type.fee_type%TYPE,
274: cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,
275: cp_transaction_type igs_fi_inv_int_all.transaction_type%TYPE) IS