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_UPG_RETENTION dependencies on IGS_FI_CONTROL_ALL

Line 105: FROM igs_fi_control_all;

101:
102: -- Fetch Receivables Account Information from System Options Level
103: CURSOR c_sys_opt_rec_acct IS
104: SELECT rec_installed, rec_gl_ccid, rec_account_cd, accounting_method
105: FROM igs_fi_control_all;
106:
107: -- Bug 5018036, SQL ID 14794917: replaced igs_fi_f_typ_ca_inst_lkp_v by a join of igs_fi_f_typ_ca_inst and igs_ca_inst
108: CURSOR c_upd_charges IS
109: SELECT a.invoice_id,

Line 200: l_v_rec_installed igs_fi_control_all.rec_installed%TYPE;

196: FROM igs_fi_posting_int_all post
197: WHERE source_transaction_id = cp_n_source_tran_id
198: AND source_transaction_type = cp_v_source_tran_type;
199:
200: l_v_rec_installed igs_fi_control_all.rec_installed%TYPE;
201: l_v_accounting_method igs_fi_control_all.accounting_method%TYPE;
202:
203: l_v_fee_type igs_fi_inv_int_all.fee_type%TYPE;
204: l_v_fee_cal_type igs_fi_inv_int_all.fee_cal_type%TYPE;

Line 201: l_v_accounting_method igs_fi_control_all.accounting_method%TYPE;

197: WHERE source_transaction_id = cp_n_source_tran_id
198: AND source_transaction_type = cp_v_source_tran_type;
199:
200: l_v_rec_installed igs_fi_control_all.rec_installed%TYPE;
201: l_v_accounting_method igs_fi_control_all.accounting_method%TYPE;
202:
203: l_v_fee_type igs_fi_inv_int_all.fee_type%TYPE;
204: l_v_fee_cal_type igs_fi_inv_int_all.fee_cal_type%TYPE;
205: l_n_fee_ci_sequence_number igs_fi_inv_int_all.fee_ci_sequence_number%TYPE;

Line 207: l_n_rec_gl_ccid_sys igs_fi_control_all.rec_gl_ccid%TYPE;

203: l_v_fee_type igs_fi_inv_int_all.fee_type%TYPE;
204: l_v_fee_cal_type igs_fi_inv_int_all.fee_cal_type%TYPE;
205: l_n_fee_ci_sequence_number igs_fi_inv_int_all.fee_ci_sequence_number%TYPE;
206:
207: l_n_rec_gl_ccid_sys igs_fi_control_all.rec_gl_ccid%TYPE;
208: l_n_upd_rec_gl_ccid igs_fi_control_all.rec_gl_ccid%TYPE;
209: l_n_upd_rev_gl_ccid igs_fi_control_all.rec_gl_ccid%TYPE;
210: l_n_upd_dr_gl_ccid igs_fi_control_all.rec_gl_ccid%TYPE;
211: l_n_upd_cr_gl_code_ccid igs_fi_control_all.rec_gl_ccid%TYPE;

Line 208: l_n_upd_rec_gl_ccid igs_fi_control_all.rec_gl_ccid%TYPE;

204: l_v_fee_cal_type igs_fi_inv_int_all.fee_cal_type%TYPE;
205: l_n_fee_ci_sequence_number igs_fi_inv_int_all.fee_ci_sequence_number%TYPE;
206:
207: l_n_rec_gl_ccid_sys igs_fi_control_all.rec_gl_ccid%TYPE;
208: l_n_upd_rec_gl_ccid igs_fi_control_all.rec_gl_ccid%TYPE;
209: l_n_upd_rev_gl_ccid igs_fi_control_all.rec_gl_ccid%TYPE;
210: l_n_upd_dr_gl_ccid igs_fi_control_all.rec_gl_ccid%TYPE;
211: l_n_upd_cr_gl_code_ccid igs_fi_control_all.rec_gl_ccid%TYPE;
212:

Line 209: l_n_upd_rev_gl_ccid igs_fi_control_all.rec_gl_ccid%TYPE;

205: l_n_fee_ci_sequence_number igs_fi_inv_int_all.fee_ci_sequence_number%TYPE;
206:
207: l_n_rec_gl_ccid_sys igs_fi_control_all.rec_gl_ccid%TYPE;
208: l_n_upd_rec_gl_ccid igs_fi_control_all.rec_gl_ccid%TYPE;
209: l_n_upd_rev_gl_ccid igs_fi_control_all.rec_gl_ccid%TYPE;
210: l_n_upd_dr_gl_ccid igs_fi_control_all.rec_gl_ccid%TYPE;
211: l_n_upd_cr_gl_code_ccid igs_fi_control_all.rec_gl_ccid%TYPE;
212:
213: l_v_rec_account_cd_sys igs_fi_control_all.rec_account_cd%TYPE;

Line 210: l_n_upd_dr_gl_ccid igs_fi_control_all.rec_gl_ccid%TYPE;

206:
207: l_n_rec_gl_ccid_sys igs_fi_control_all.rec_gl_ccid%TYPE;
208: l_n_upd_rec_gl_ccid igs_fi_control_all.rec_gl_ccid%TYPE;
209: l_n_upd_rev_gl_ccid igs_fi_control_all.rec_gl_ccid%TYPE;
210: l_n_upd_dr_gl_ccid igs_fi_control_all.rec_gl_ccid%TYPE;
211: l_n_upd_cr_gl_code_ccid igs_fi_control_all.rec_gl_ccid%TYPE;
212:
213: l_v_rec_account_cd_sys igs_fi_control_all.rec_account_cd%TYPE;
214: l_v_upd_rec_account_cd igs_fi_control_all.rec_account_cd%TYPE;

Line 211: l_n_upd_cr_gl_code_ccid igs_fi_control_all.rec_gl_ccid%TYPE;

207: l_n_rec_gl_ccid_sys igs_fi_control_all.rec_gl_ccid%TYPE;
208: l_n_upd_rec_gl_ccid igs_fi_control_all.rec_gl_ccid%TYPE;
209: l_n_upd_rev_gl_ccid igs_fi_control_all.rec_gl_ccid%TYPE;
210: l_n_upd_dr_gl_ccid igs_fi_control_all.rec_gl_ccid%TYPE;
211: l_n_upd_cr_gl_code_ccid igs_fi_control_all.rec_gl_ccid%TYPE;
212:
213: l_v_rec_account_cd_sys igs_fi_control_all.rec_account_cd%TYPE;
214: l_v_upd_rec_account_cd igs_fi_control_all.rec_account_cd%TYPE;
215: l_v_upd_rev_account_cd igs_fi_control_all.rec_account_cd%TYPE;

Line 213: l_v_rec_account_cd_sys igs_fi_control_all.rec_account_cd%TYPE;

209: l_n_upd_rev_gl_ccid igs_fi_control_all.rec_gl_ccid%TYPE;
210: l_n_upd_dr_gl_ccid igs_fi_control_all.rec_gl_ccid%TYPE;
211: l_n_upd_cr_gl_code_ccid igs_fi_control_all.rec_gl_ccid%TYPE;
212:
213: l_v_rec_account_cd_sys igs_fi_control_all.rec_account_cd%TYPE;
214: l_v_upd_rec_account_cd igs_fi_control_all.rec_account_cd%TYPE;
215: l_v_upd_rev_account_cd igs_fi_control_all.rec_account_cd%TYPE;
216: l_v_upd_dr_account_cd igs_fi_control_all.rec_account_cd%TYPE;
217: l_v_upd_cr_account_cd igs_fi_control_all.rec_account_cd%TYPE;

Line 214: l_v_upd_rec_account_cd igs_fi_control_all.rec_account_cd%TYPE;

210: l_n_upd_dr_gl_ccid igs_fi_control_all.rec_gl_ccid%TYPE;
211: l_n_upd_cr_gl_code_ccid igs_fi_control_all.rec_gl_ccid%TYPE;
212:
213: l_v_rec_account_cd_sys igs_fi_control_all.rec_account_cd%TYPE;
214: l_v_upd_rec_account_cd igs_fi_control_all.rec_account_cd%TYPE;
215: l_v_upd_rev_account_cd igs_fi_control_all.rec_account_cd%TYPE;
216: l_v_upd_dr_account_cd igs_fi_control_all.rec_account_cd%TYPE;
217: l_v_upd_cr_account_cd igs_fi_control_all.rec_account_cd%TYPE;
218:

Line 215: l_v_upd_rev_account_cd igs_fi_control_all.rec_account_cd%TYPE;

211: l_n_upd_cr_gl_code_ccid igs_fi_control_all.rec_gl_ccid%TYPE;
212:
213: l_v_rec_account_cd_sys igs_fi_control_all.rec_account_cd%TYPE;
214: l_v_upd_rec_account_cd igs_fi_control_all.rec_account_cd%TYPE;
215: l_v_upd_rev_account_cd igs_fi_control_all.rec_account_cd%TYPE;
216: l_v_upd_dr_account_cd igs_fi_control_all.rec_account_cd%TYPE;
217: l_v_upd_cr_account_cd igs_fi_control_all.rec_account_cd%TYPE;
218:
219: l_b_sys_opt_defined BOOLEAN := FALSE;

Line 216: l_v_upd_dr_account_cd igs_fi_control_all.rec_account_cd%TYPE;

212:
213: l_v_rec_account_cd_sys igs_fi_control_all.rec_account_cd%TYPE;
214: l_v_upd_rec_account_cd igs_fi_control_all.rec_account_cd%TYPE;
215: l_v_upd_rev_account_cd igs_fi_control_all.rec_account_cd%TYPE;
216: l_v_upd_dr_account_cd igs_fi_control_all.rec_account_cd%TYPE;
217: l_v_upd_cr_account_cd igs_fi_control_all.rec_account_cd%TYPE;
218:
219: l_b_sys_opt_defined BOOLEAN := FALSE;
220: l_b_invoice_found BOOLEAN := FALSE;

Line 217: l_v_upd_cr_account_cd igs_fi_control_all.rec_account_cd%TYPE;

213: l_v_rec_account_cd_sys igs_fi_control_all.rec_account_cd%TYPE;
214: l_v_upd_rec_account_cd igs_fi_control_all.rec_account_cd%TYPE;
215: l_v_upd_rev_account_cd igs_fi_control_all.rec_account_cd%TYPE;
216: l_v_upd_dr_account_cd igs_fi_control_all.rec_account_cd%TYPE;
217: l_v_upd_cr_account_cd igs_fi_control_all.rec_account_cd%TYPE;
218:
219: l_b_sys_opt_defined BOOLEAN := FALSE;
220: l_b_invoice_found BOOLEAN := FALSE;
221: l_b_no_ftci_setup BOOLEAN := FALSE;