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_GEN_008 dependencies on IGS_FI_INV_INT_ALL

Line 243: p_v_transaction_type IN igs_fi_inv_int_all.transaction_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,
244: p_n_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,
245: p_v_invoice_num OUT NOCOPY igs_fi_inv_int_all.invoice_number%TYPE,
246: p_b_chg_decl_rev OUT NOCOPY BOOLEAN
247: ) IS

Line 244: p_n_invoice_id IN igs_fi_inv_int_all.invoice_id%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,
244: p_n_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,
245: p_v_invoice_num OUT NOCOPY igs_fi_inv_int_all.invoice_number%TYPE,
246: p_b_chg_decl_rev OUT NOCOPY BOOLEAN
247: ) IS
248:

Line 245: p_v_invoice_num OUT NOCOPY igs_fi_inv_int_all.invoice_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,
244: p_n_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,
245: p_v_invoice_num OUT NOCOPY igs_fi_inv_int_all.invoice_number%TYPE,
246: p_b_chg_decl_rev OUT NOCOPY BOOLEAN
247: ) IS
248:
249: /***********************************************************************************************

Line 259: CURSOR cur_chk_rev_decl(cp_invoice_id igs_fi_inv_int_all.invoice_id%TYPE) IS

255: Change History
256: Who When What
257: ***********************************************************************************************/
258: --cursor to check whether the charge with given invoice id has already been reversed or declined
259: CURSOR cur_chk_rev_decl(cp_invoice_id igs_fi_inv_int_all.invoice_id%TYPE) IS
260: SELECT inv.invoice_number
261: FROM igs_fi_inv_int inv
262: WHERE inv.invoice_id=cp_invoice_id
263: AND (inv.optional_fee_flag = g_v_opt_fee_decl OR inv.waiver_flag = g_v_waiver_yes);

Line 275: cp_transaction_type igs_fi_inv_int_all.transaction_type%TYPE) IS

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
276: SELECT inv.invoice_number
277: FROM igs_fi_inv_int inv,
278: igs_fi_invln_int invln
279: WHERE inv.person_id=cp_person_id