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_COM_REC_INTERFACE dependencies on IGS_FI_CREDITS

Line 201: FROM igs_fi_credits crd,

197: crd.source_invoice_id,
198: cra.*,
199: cra.rowid cra_rowid,
200: crt.credit_class
201: FROM igs_fi_credits crd,
202: igs_fi_cr_activities cra,
203: igs_fi_cr_types crt
204: WHERE crd.credit_id = cra.credit_id
205: AND crd.credit_type_id = crt.credit_type_id

Line 219: FROM igs_fi_credits

215: -- Returns the party_id from Credits table corresponding to the charge denoted by
216: -- the SOURCE_INVOICE_ID column.
217: CURSOR cur_chg_stdnt_party(cp_invoice_id igs_fi_inv_int_all.invoice_id%TYPE) IS
218: SELECT party_id
219: FROM igs_fi_credits
220: WHERE source_invoice_id = cp_invoice_id;
221:
222: -- Returns the party_id from Charges Table correponding to the value in Source_invoice_id
223: -- column of the Credits Table of type Aid Adjustment

Line 224: CURSOR cur_credit_stdnt_party(cp_source_invoice_id igs_fi_credits_all.source_invoice_id%TYPE) IS

220: WHERE source_invoice_id = cp_invoice_id;
221:
222: -- Returns the party_id from Charges Table correponding to the value in Source_invoice_id
223: -- column of the Credits Table of type Aid Adjustment
224: CURSOR cur_credit_stdnt_party(cp_source_invoice_id igs_fi_credits_all.source_invoice_id%TYPE) IS
225: SELECT person_id
226: FROM igs_fi_inv_int
227: WHERE invoice_id = cp_source_invoice_id
228: AND transaction_type = g_v_aid_adj;

Line 251: l_n_chg_stdnt_party igs_fi_credits_all.party_id%TYPE;

247: e_resource_busy EXCEPTION;
248:
249: PRAGMA EXCEPTION_INIT(e_resource_busy, -54);
250:
251: l_n_chg_stdnt_party igs_fi_credits_all.party_id%TYPE;
252: l_n_credit_stdnt_party igs_fi_inv_int_all.person_id%TYPE;
253:
254: BEGIN
255: BEGIN

Line 546: END LOOP; -- End of looping across Credits in IGS_FI_CREDITS table (Step 6)

542: fnd_file.new_line(fnd_file.log);
543: ROLLBACK TO sp_credits;
544: END;
545:
546: END LOOP; -- End of looping across Credits in IGS_FI_CREDITS table (Step 6)
547:
548: -- Step 9: If there are no records, log 'No Data Found' in the log file.
549: -- This message is logged in 2 cases: (a) No data found for transferring to interface table
550: -- (b) All the data transferred successfully without any error records