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_007 dependencies on IGS_FI_CR_TYPES

Line 202: CURSOR c_igs_fi_cr_types(cp_n_credit_id igs_fi_credits.credit_id%TYPE) IS

198: FROM igs_fi_applications
199: WHERE application_id=p_application_id
200: AND application_type='APP';
201:
202: CURSOR c_igs_fi_cr_types(cp_n_credit_id igs_fi_credits.credit_id%TYPE) IS
203: SELECT credit_class
204: FROM igs_fi_cr_types crtyp
205: WHERE EXISTS (SELECT '1'
206: FROM igs_fi_credits crd

Line 204: FROM igs_fi_cr_types crtyp

200: AND application_type='APP';
201:
202: CURSOR c_igs_fi_cr_types(cp_n_credit_id igs_fi_credits.credit_id%TYPE) IS
203: SELECT credit_class
204: FROM igs_fi_cr_types crtyp
205: WHERE EXISTS (SELECT '1'
206: FROM igs_fi_credits crd
207: WHERE crd.credit_type_id = crtyp.credit_type_id
208: AND crd.credit_id = cp_n_credit_id

Line 211: rec_c_igs_fi_cr_types c_igs_fi_cr_types%ROWTYPE;

207: WHERE crd.credit_type_id = crtyp.credit_type_id
208: AND crd.credit_id = cp_n_credit_id
209: );
210:
211: rec_c_igs_fi_cr_types c_igs_fi_cr_types%ROWTYPE;
212:
213: l_cur_chk_app cur_chk_app%ROWTYPE;
214: l_check VARCHAR2(1);
215: l_cur_credit cur_credit%ROWTYPE;

Line 256: OPEN c_igs_fi_cr_types(p_credit_id);

252: IF NOT (p_status) THEN
253: RETURN;
254: END IF;
255:
256: OPEN c_igs_fi_cr_types(p_credit_id);
257: FETCH c_igs_fi_cr_types INTO rec_c_igs_fi_cr_types;
258: CLOSE c_igs_fi_cr_types;
259: IF rec_c_igs_fi_cr_types.credit_class <> 'ONLINE PAYMENT' THEN
260: l_status := igs_fi_gen_gl.check_gl_dt_appl_not_valid ( p_d_gl_date => p_d_gl_date,

Line 257: FETCH c_igs_fi_cr_types INTO rec_c_igs_fi_cr_types;

253: RETURN;
254: END IF;
255:
256: OPEN c_igs_fi_cr_types(p_credit_id);
257: FETCH c_igs_fi_cr_types INTO rec_c_igs_fi_cr_types;
258: CLOSE c_igs_fi_cr_types;
259: IF rec_c_igs_fi_cr_types.credit_class <> 'ONLINE PAYMENT' THEN
260: l_status := igs_fi_gen_gl.check_gl_dt_appl_not_valid ( p_d_gl_date => p_d_gl_date,
261: p_n_invoice_id => p_invoice_id,

Line 258: CLOSE c_igs_fi_cr_types;

254: END IF;
255:
256: OPEN c_igs_fi_cr_types(p_credit_id);
257: FETCH c_igs_fi_cr_types INTO rec_c_igs_fi_cr_types;
258: CLOSE c_igs_fi_cr_types;
259: IF rec_c_igs_fi_cr_types.credit_class <> 'ONLINE PAYMENT' THEN
260: l_status := igs_fi_gen_gl.check_gl_dt_appl_not_valid ( p_d_gl_date => p_d_gl_date,
261: p_n_invoice_id => p_invoice_id,
262: p_n_credit_id => p_credit_id

Line 259: IF rec_c_igs_fi_cr_types.credit_class <> 'ONLINE PAYMENT' THEN

255:
256: OPEN c_igs_fi_cr_types(p_credit_id);
257: FETCH c_igs_fi_cr_types INTO rec_c_igs_fi_cr_types;
258: CLOSE c_igs_fi_cr_types;
259: IF rec_c_igs_fi_cr_types.credit_class <> 'ONLINE PAYMENT' THEN
260: l_status := igs_fi_gen_gl.check_gl_dt_appl_not_valid ( p_d_gl_date => p_d_gl_date,
261: p_n_invoice_id => p_invoice_id,
262: p_n_credit_id => p_credit_id
263: );

Line 898: FROM igs_fi_cr_types ct,

894: l_cur_inv cur_inv%ROWTYPE;
895:
896: CURSOR cur_class IS
897: SELECT ct.credit_class
898: FROM igs_fi_cr_types ct,
899: igs_fi_credits c,
900: igs_fi_cr_activities ca
901: WHERE ct.credit_type_id=c.credit_type_id
902: AND c.credit_id=ca.credit_id