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

Line 77: FROM igs_fi_credits a,

73:
74: CURSOR cur_min_date
75: IS
76: SELECT MIN(effective_date) min_date
77: FROM igs_fi_credits a,
78: igs_fi_cr_types b
79: WHERE a.credit_type_id = b.credit_type_id
80: AND b.credit_class NOT IN ('ENRDEPOSIT','OTHDEPOSIT');
81:

Line 113: FROM igs_fi_credits a,

109:
110: CURSOR cur_max_date
111: IS
112: SELECT MAX(effective_date) max_date
113: FROM igs_fi_credits a,
114: igs_fi_cr_types b
115: WHERE a.credit_type_id = b.credit_type_id
116: AND b.credit_class NOT IN ('ENRDEPOSIT','OTHDEPOSIT');
117:

Line 130: p_credit_id IN igs_fi_credits.credit_id%TYPE,

126: END eff_max_date;
127:
128: PROCEDURE apply_and_log_messages (
129: p_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,
130: p_credit_id IN igs_fi_credits.credit_id%TYPE,
131: p_fee_type IN igs_fi_inv_int_all.fee_type%TYPE,
132: p_fee_cal_type IN igs_fi_inv_int_all.fee_cal_type%TYPE,
133: p_unapplied_amount IN OUT NOCOPY igs_fi_credits.unapplied_amount%TYPE,
134: p_orig_invoice_amount_due IN igs_fi_inv_int_all.invoice_amount_due%TYPE,

Line 133: p_unapplied_amount IN OUT NOCOPY igs_fi_credits.unapplied_amount%TYPE,

129: p_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,
130: p_credit_id IN igs_fi_credits.credit_id%TYPE,
131: p_fee_type IN igs_fi_inv_int_all.fee_type%TYPE,
132: p_fee_cal_type IN igs_fi_inv_int_all.fee_cal_type%TYPE,
133: p_unapplied_amount IN OUT NOCOPY igs_fi_credits.unapplied_amount%TYPE,
134: p_orig_invoice_amount_due IN igs_fi_inv_int_all.invoice_amount_due%TYPE,
135: p_invoice_amount_due IN OUT NOCOPY igs_fi_inv_int_all.invoice_amount_due%TYPE,
136: p_amount_applied IN igs_fi_applications.amount_applied%TYPE,
137: p_appl_hierarchy_id IN igs_fi_applications.appl_hierarchy_id%TYPE,

Line 152: c_igs_fi_invln_int and c_igs_fi_credits to obtain the charge and credit

148: Change History
149: Who When What
150: akandreg 17-May-2006 Bug 5134636: Removed commit for each application record
151: smadathi 20-NOV-2002 Enh. Bug 2584986. Added new parameter GL Date to procedure. Added cursors
152: c_igs_fi_invln_int and c_igs_fi_credits to obtain the charge and credit
153: GL Dates.
154: vvutukur 26-apr-2002 fnd_file.put_line is changed to lower case and fnd_file.new_line is used
155: instead of writing null string by fnd_file.put_line.bug#2326163.
156: vvutukur 22-apr-2002 Removed the code showing log horizontally. Modified to show numbers and

Line 171: CURSOR c_igs_fi_credits(cp_n_credit_id igs_fi_credits.credit_id%TYPE) IS

167: SELECT gl_date
168: FROM igs_fi_invln_int
169: WHERE invoice_id = cp_n_invoice_id;
170:
171: CURSOR c_igs_fi_credits(cp_n_credit_id igs_fi_credits.credit_id%TYPE) IS
172: SELECT gl_date
173: FROM igs_fi_credits
174: WHERE credit_id = cp_n_credit_id;
175:

Line 173: FROM igs_fi_credits

169: WHERE invoice_id = cp_n_invoice_id;
170:
171: CURSOR c_igs_fi_credits(cp_n_credit_id igs_fi_credits.credit_id%TYPE) IS
172: SELECT gl_date
173: FROM igs_fi_credits
174: WHERE credit_id = cp_n_credit_id;
175:
176: rec_c_igs_fi_invln_int c_igs_fi_invln_int%ROWTYPE;
177: rec_c_igs_fi_credits c_igs_fi_credits%ROWTYPE;

Line 177: rec_c_igs_fi_credits c_igs_fi_credits%ROWTYPE;

173: FROM igs_fi_credits
174: WHERE credit_id = cp_n_credit_id;
175:
176: rec_c_igs_fi_invln_int c_igs_fi_invln_int%ROWTYPE;
177: rec_c_igs_fi_credits c_igs_fi_credits%ROWTYPE;
178:
179: l_invoice_number igs_fi_inv_int.invoice_number%TYPE;
180: l_dr_ccid_str VARCHAR2(230);
181: l_cr_ccid_str VARCHAR2(230);

Line 192: l_dummy_unapplied_amount igs_fi_credits.unapplied_amount%TYPE;

188: l_v_cr_account_cd igs_fi_applications.cr_account_cd%TYPE;
189: l_n_cr_gl_ccid igs_fi_applications.cr_gl_code_ccid%TYPE;
190: l_n_dr_gl_ccid igs_fi_applications.dr_gl_code_ccid%TYPE;
191: l_b_status BOOLEAN := FALSE ;
192: l_dummy_unapplied_amount igs_fi_credits.unapplied_amount%TYPE;
193: l_dummy_invoice_amount_due igs_fi_inv_int_all.invoice_amount_due%TYPE;
194:
195: BEGIN
196:

Line 234: OPEN c_igs_fi_credits(p_credit_id);

230: OPEN c_igs_fi_invln_int(p_invoice_id);
231: FETCH c_igs_fi_invln_int INTO rec_c_igs_fi_invln_int;
232: CLOSE c_igs_fi_invln_int;
233:
234: OPEN c_igs_fi_credits(p_credit_id);
235: FETCH c_igs_fi_credits INTO rec_c_igs_fi_credits;
236: CLOSE c_igs_fi_credits;
237:
238: fnd_message.set_name('IGS',l_v_app_error_message);

Line 235: FETCH c_igs_fi_credits INTO rec_c_igs_fi_credits;

231: FETCH c_igs_fi_invln_int INTO rec_c_igs_fi_invln_int;
232: CLOSE c_igs_fi_invln_int;
233:
234: OPEN c_igs_fi_credits(p_credit_id);
235: FETCH c_igs_fi_credits INTO rec_c_igs_fi_credits;
236: CLOSE c_igs_fi_credits;
237:
238: fnd_message.set_name('IGS',l_v_app_error_message);
239: fnd_message.set_token('GL_DATE',p_d_gl_date);

Line 236: CLOSE c_igs_fi_credits;

232: CLOSE c_igs_fi_invln_int;
233:
234: OPEN c_igs_fi_credits(p_credit_id);
235: FETCH c_igs_fi_credits INTO rec_c_igs_fi_credits;
236: CLOSE c_igs_fi_credits;
237:
238: fnd_message.set_name('IGS',l_v_app_error_message);
239: fnd_message.set_token('GL_DATE',p_d_gl_date);
240: fnd_message.set_token('CHG_GL_DATE',rec_c_igs_fi_invln_int.gl_date);

Line 241: fnd_message.set_token('CRD_GL_DATE',rec_c_igs_fi_credits.gl_date);

237:
238: fnd_message.set_name('IGS',l_v_app_error_message);
239: fnd_message.set_token('GL_DATE',p_d_gl_date);
240: fnd_message.set_token('CHG_GL_DATE',rec_c_igs_fi_invln_int.gl_date);
241: fnd_message.set_token('CRD_GL_DATE',rec_c_igs_fi_credits.gl_date);
242: fnd_file.put_line(fnd_file.log,fnd_message.Get);
243: END IF;
244:
245: P_counter := NVL(P_counter,0) + 1;

Line 351: p_credit_number igs_fi_credits_all.credit_number%TYPE,

347: retcode OUT NOCOPY NUMBER,
348: p_org_id NUMBER,
349: p_person_id igs_fi_inv_int_all.person_id%TYPE,
350: p_person_id_grp igs_pe_prsid_grp_mem_all.group_id%TYPE,
351: p_credit_number igs_fi_credits_all.credit_number%TYPE,
352: p_credit_type_id igs_fi_credits_all.credit_type_id%TYPE,
353: p_credit_date_low VARCHAR2,
354: p_credit_date_high VARCHAR2,
355: p_d_gl_date VARCHAR2

Line 352: p_credit_type_id igs_fi_credits_all.credit_type_id%TYPE,

348: p_org_id NUMBER,
349: p_person_id igs_fi_inv_int_all.person_id%TYPE,
350: p_person_id_grp igs_pe_prsid_grp_mem_all.group_id%TYPE,
351: p_credit_number igs_fi_credits_all.credit_number%TYPE,
352: p_credit_type_id igs_fi_credits_all.credit_type_id%TYPE,
353: p_credit_date_low VARCHAR2,
354: p_credit_date_high VARCHAR2,
355: p_d_gl_date VARCHAR2
356: ) IS

Line 447: p_credit_number igs_fi_credits_all.credit_number%TYPE,

443: END mass_application;
444:
445: PROCEDURE mass_apply(p_person_id igs_fi_inv_int_all.person_id%TYPE,
446: p_person_id_grp igs_pe_prsid_grp_mem_all.group_id%TYPE,
447: p_credit_number igs_fi_credits_all.credit_number%TYPE,
448: p_credit_type_id igs_fi_credits_all.credit_type_id%TYPE,
449: p_credit_date_low VARCHAR2,
450: p_credit_date_high VARCHAR2,
451: p_d_gl_date DATE

Line 448: p_credit_type_id igs_fi_credits_all.credit_type_id%TYPE,

444:
445: PROCEDURE mass_apply(p_person_id igs_fi_inv_int_all.person_id%TYPE,
446: p_person_id_grp igs_pe_prsid_grp_mem_all.group_id%TYPE,
447: p_credit_number igs_fi_credits_all.credit_number%TYPE,
448: p_credit_type_id igs_fi_credits_all.credit_type_id%TYPE,
449: p_credit_date_low VARCHAR2,
450: p_credit_date_high VARCHAR2,
451: p_d_gl_date DATE
452: ) IS

Line 521: FROM igs_fi_credits

517: -- person grp id is passed
518: CURSOR cur_all_person_id
519: IS
520: SELECT DISTINCT party_id
521: FROM igs_fi_credits
522: WHERE unapplied_amount>0
523: ORDER BY 1;
524:
525: -- cursor for getting all the positive unapplied amount depending on the

Line 533: FROM igs_fi_credits cr,igs_fi_cr_types crt

529: cp_credit_date_low DATE,
530: cp_credit_date_high DATE)
531: IS
532: SELECT cr.rowid, cr.*,crt.credit_type_name,crt.appl_hierarchy_id
533: FROM igs_fi_credits cr,igs_fi_cr_types crt
534: WHERE
535: (cr.party_id = cp_person_id OR (cp_person_id IS NULL)) AND
536: (cr.credit_number = p_credit_number OR (p_credit_number IS NULL)) AND
537: (cr.credit_type_id = p_credit_type_id OR (p_credit_type_id IS NULL)) AND

Line 680: l_credits_amount igs_fi_credits_all.unapplied_amount%TYPE;

676: l_charges_not_fp cur_charges_not_fp%ROWTYPE;
677: l_charges_normal cur_charges_normal%ROWTYPE;
678: -- table type variables
679: l_charges_amount igs_fi_inv_int_all.invoice_amount_due%TYPE;
680: l_credits_amount igs_fi_credits_all.unapplied_amount%TYPE;
681: l_invoice_amount_due igs_fi_inv_int_all.invoice_amount_due%TYPE;
682: l_credits_unapplied_amount igs_fi_credits_all.unapplied_amount%TYPE;
683: l_applications_rowid VARCHAR2(25); -- OUT NOCOPY parameter from the applications table Insert TBH
684: l_rec_installed VARCHAR2(1); -- variable captures the value returned from the

Line 682: l_credits_unapplied_amount igs_fi_credits_all.unapplied_amount%TYPE;

678: -- table type variables
679: l_charges_amount igs_fi_inv_int_all.invoice_amount_due%TYPE;
680: l_credits_amount igs_fi_credits_all.unapplied_amount%TYPE;
681: l_invoice_amount_due igs_fi_inv_int_all.invoice_amount_due%TYPE;
682: l_credits_unapplied_amount igs_fi_credits_all.unapplied_amount%TYPE;
683: l_applications_rowid VARCHAR2(25); -- OUT NOCOPY parameter from the applications table Insert TBH
684: l_rec_installed VARCHAR2(1); -- variable captures the value returned from the
685: -- function which checks AR is installed or not
686: l_credit_date_low DATE; -- VARCHAR2 datatypes will be made DATE types