eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_FI_PRC_SP_FEES dependencies on IGS_FI_F_TYP_CA_INST

Line 95: p_v_fee_type IN igs_fi_f_typ_ca_inst.fee_type%TYPE,

91: END log_details;
92:
93:
94: PROCEDURE call_charges_api(p_n_person_id IN hz_parties.party_id%TYPE,
95: p_v_fee_type IN igs_fi_f_typ_ca_inst.fee_type%TYPE,
96: p_v_fee_cal_type IN igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
97: p_n_fee_ci_sequence_number IN igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,
98: p_v_course_cd IN igs_ps_ver.course_cd%TYPE,
99: p_n_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,

Line 96: p_v_fee_cal_type IN igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,

92:
93:
94: PROCEDURE call_charges_api(p_n_person_id IN hz_parties.party_id%TYPE,
95: p_v_fee_type IN igs_fi_f_typ_ca_inst.fee_type%TYPE,
96: p_v_fee_cal_type IN igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
97: p_n_fee_ci_sequence_number IN igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,
98: p_v_course_cd IN igs_ps_ver.course_cd%TYPE,
99: p_n_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
100: p_n_amount IN igs_fi_invln_int.amount%TYPE,

Line 97: p_n_fee_ci_sequence_number IN igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,

93:
94: PROCEDURE call_charges_api(p_n_person_id IN hz_parties.party_id%TYPE,
95: p_v_fee_type IN igs_fi_f_typ_ca_inst.fee_type%TYPE,
96: p_v_fee_cal_type IN igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
97: p_n_fee_ci_sequence_number IN igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,
98: p_v_course_cd IN igs_ps_ver.course_cd%TYPE,
99: p_n_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
100: p_n_amount IN igs_fi_invln_int.amount%TYPE,
101: p_v_transaction_type IN igs_fi_inv_int.transaction_type%TYPE,

Line 288: fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,

284: TYPE sp_fees_rec_type IS RECORD( person_id hz_parties.party_id%TYPE,
285: course_cd igs_ps_ver.course_cd%TYPE,
286: uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,
287: fee_type igs_fi_fee_type.fee_type%TYPE,
288: fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
289: fee_ci_sequence_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,
290: old_amount igs_fi_special_fees.fee_amt%TYPE,
291: new_amount igs_fi_special_fees.fee_amt%TYPE,
292: invoice_id igs_fi_inv_int.invoice_id%TYPE);

Line 289: fee_ci_sequence_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,

285: course_cd igs_ps_ver.course_cd%TYPE,
286: uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,
287: fee_type igs_fi_fee_type.fee_type%TYPE,
288: fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
289: fee_ci_sequence_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,
290: old_amount igs_fi_special_fees.fee_amt%TYPE,
291: new_amount igs_fi_special_fees.fee_amt%TYPE,
292: invoice_id igs_fi_inv_int.invoice_id%TYPE);
293:

Line 304: cp_v_fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,

300: -- This does not include the Retention Fees
301: CURSOR cur_get_sum_sp_fees(cp_n_person_id hz_parties.party_id%TYPE,
302: cp_v_course_cd igs_ps_ver.course_cd%TYPE,
303: cp_n_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,
304: cp_v_fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
305: cp_n_fee_ci_sequence_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,
306: cp_v_transaction_type_cd igs_fi_special_fees.s_transaction_type_code%TYPE) IS
307: SELECT fee_type,
308: invoice_id,

Line 305: cp_n_fee_ci_sequence_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,

301: CURSOR cur_get_sum_sp_fees(cp_n_person_id hz_parties.party_id%TYPE,
302: cp_v_course_cd igs_ps_ver.course_cd%TYPE,
303: cp_n_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,
304: cp_v_fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
305: cp_n_fee_ci_sequence_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,
306: cp_v_transaction_type_cd igs_fi_special_fees.s_transaction_type_code%TYPE) IS
307: SELECT fee_type,
308: invoice_id,
309: SUM(fee_amt) fee_amt

Line 384: l_v_ret_level igs_fi_f_typ_ca_inst_all.retention_level_code%TYPE;

380:
381: l_v_invoice_number igs_fi_inv_int_all.invoice_number%TYPE;
382: l_b_chg_decl_rev BOOLEAN;
383:
384: l_v_ret_level igs_fi_f_typ_ca_inst_all.retention_level_code%TYPE;
385: l_v_complete_withdr_ret igs_fi_f_typ_ca_inst_all.complete_ret_flag%TYPE;
386: l_v_sua_status igs_en_su_attempt.unit_attempt_status%TYPE := NULL;
387: l_d_disc_dt igs_en_su_attempt.discontinued_dt%TYPE := NULL;
388:

Line 385: l_v_complete_withdr_ret igs_fi_f_typ_ca_inst_all.complete_ret_flag%TYPE;

381: l_v_invoice_number igs_fi_inv_int_all.invoice_number%TYPE;
382: l_b_chg_decl_rev BOOLEAN;
383:
384: l_v_ret_level igs_fi_f_typ_ca_inst_all.retention_level_code%TYPE;
385: l_v_complete_withdr_ret igs_fi_f_typ_ca_inst_all.complete_ret_flag%TYPE;
386: l_v_sua_status igs_en_su_attempt.unit_attempt_status%TYPE := NULL;
387: l_d_disc_dt igs_en_su_attempt.discontinued_dt%TYPE := NULL;
388:
389: -- Cursor to get optional payment Indicator for a given fee type