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

Line 143: igs_fi_inv_int_all inv

139: cp_n_fee_ci_seq igs_fi_credits_all.fee_ci_sequence_number%TYPE,
140: cp_v_waiver_name igs_fi_credits_all.waiver_name%TYPE) IS
141: SELECT SUM(appl.amount_applied) amt_appl
142: FROM igs_fi_applications appl,
143: igs_fi_inv_int_all inv
144: WHERE appl.credit_id = cp_n_credit_id
145: AND appl.invoice_id = inv.invoice_id
146: AND inv.fee_cal_type = cp_v_fee_cal_type
147: AND inv.fee_ci_sequence_number = cp_n_fee_ci_seq

Line 184: PROCEDURE call_fee_calc(p_n_person_id igs_fi_inv_int_all.person_id%TYPE,

180: );
181: RETURN l_n_old_wav_amt;
182: END get_calc_old_waiver_amt;
183:
184: PROCEDURE call_fee_calc(p_n_person_id igs_fi_inv_int_all.person_id%TYPE,
185: p_v_fee_type igs_fi_inv_int_all.fee_type%TYPE,
186: p_v_fee_cal_type igs_fi_inv_int_all.fee_cal_type%TYPE,
187: p_n_fee_ci_seq igs_fi_inv_int_all.fee_ci_sequence_number%TYPE,
188: p_d_gl_date DATE,

Line 185: p_v_fee_type igs_fi_inv_int_all.fee_type%TYPE,

181: RETURN l_n_old_wav_amt;
182: END get_calc_old_waiver_amt;
183:
184: PROCEDURE call_fee_calc(p_n_person_id igs_fi_inv_int_all.person_id%TYPE,
185: p_v_fee_type igs_fi_inv_int_all.fee_type%TYPE,
186: p_v_fee_cal_type igs_fi_inv_int_all.fee_cal_type%TYPE,
187: p_n_fee_ci_seq igs_fi_inv_int_all.fee_ci_sequence_number%TYPE,
188: p_d_gl_date DATE,
189: p_v_real_time_flag VARCHAR2,

Line 186: p_v_fee_cal_type igs_fi_inv_int_all.fee_cal_type%TYPE,

182: END get_calc_old_waiver_amt;
183:
184: PROCEDURE call_fee_calc(p_n_person_id igs_fi_inv_int_all.person_id%TYPE,
185: p_v_fee_type igs_fi_inv_int_all.fee_type%TYPE,
186: p_v_fee_cal_type igs_fi_inv_int_all.fee_cal_type%TYPE,
187: p_n_fee_ci_seq igs_fi_inv_int_all.fee_ci_sequence_number%TYPE,
188: p_d_gl_date DATE,
189: p_v_real_time_flag VARCHAR2,
190: p_v_process_mode VARCHAR2,

Line 187: p_n_fee_ci_seq igs_fi_inv_int_all.fee_ci_sequence_number%TYPE,

183:
184: PROCEDURE call_fee_calc(p_n_person_id igs_fi_inv_int_all.person_id%TYPE,
185: p_v_fee_type igs_fi_inv_int_all.fee_type%TYPE,
186: p_v_fee_cal_type igs_fi_inv_int_all.fee_cal_type%TYPE,
187: p_n_fee_ci_seq igs_fi_inv_int_all.fee_ci_sequence_number%TYPE,
188: p_d_gl_date DATE,
189: p_v_real_time_flag VARCHAR2,
190: p_v_process_mode VARCHAR2,
191: p_v_career VARCHAR2,

Line 259: FUNCTION get_wav_amt(p_n_person_id igs_fi_inv_int_all.person_id%TYPE,

255: x_ret_status := 'E';
256: RAISE;
257: END call_fee_calc;
258:
259: FUNCTION get_wav_amt(p_n_person_id igs_fi_inv_int_all.person_id%TYPE,
260: p_v_fee_type igs_fi_inv_int_all.fee_type%TYPE,
261: p_v_fee_cal_type igs_fi_inv_int_all.fee_cal_type%TYPE,
262: p_n_fee_ci_seq igs_fi_inv_int_all.fee_ci_sequence_number%TYPE,
263: p_v_waiver_name igs_fi_inv_int_all.waiver_name%TYPE) RETURN NUMBER AS

Line 260: p_v_fee_type igs_fi_inv_int_all.fee_type%TYPE,

256: RAISE;
257: END call_fee_calc;
258:
259: FUNCTION get_wav_amt(p_n_person_id igs_fi_inv_int_all.person_id%TYPE,
260: p_v_fee_type igs_fi_inv_int_all.fee_type%TYPE,
261: p_v_fee_cal_type igs_fi_inv_int_all.fee_cal_type%TYPE,
262: p_n_fee_ci_seq igs_fi_inv_int_all.fee_ci_sequence_number%TYPE,
263: p_v_waiver_name igs_fi_inv_int_all.waiver_name%TYPE) RETURN NUMBER AS
264: /******************************************************************

Line 261: p_v_fee_cal_type igs_fi_inv_int_all.fee_cal_type%TYPE,

257: END call_fee_calc;
258:
259: FUNCTION get_wav_amt(p_n_person_id igs_fi_inv_int_all.person_id%TYPE,
260: p_v_fee_type igs_fi_inv_int_all.fee_type%TYPE,
261: p_v_fee_cal_type igs_fi_inv_int_all.fee_cal_type%TYPE,
262: p_n_fee_ci_seq igs_fi_inv_int_all.fee_ci_sequence_number%TYPE,
263: p_v_waiver_name igs_fi_inv_int_all.waiver_name%TYPE) RETURN NUMBER AS
264: /******************************************************************
265: Created By : Amit Gairola

Line 262: p_n_fee_ci_seq igs_fi_inv_int_all.fee_ci_sequence_number%TYPE,

258:
259: FUNCTION get_wav_amt(p_n_person_id igs_fi_inv_int_all.person_id%TYPE,
260: p_v_fee_type igs_fi_inv_int_all.fee_type%TYPE,
261: p_v_fee_cal_type igs_fi_inv_int_all.fee_cal_type%TYPE,
262: p_n_fee_ci_seq igs_fi_inv_int_all.fee_ci_sequence_number%TYPE,
263: p_v_waiver_name igs_fi_inv_int_all.waiver_name%TYPE) RETURN NUMBER AS
264: /******************************************************************
265: Created By : Amit Gairola
266: Date Created By : 10-Aug-2005

Line 263: p_v_waiver_name igs_fi_inv_int_all.waiver_name%TYPE) RETURN NUMBER AS

259: FUNCTION get_wav_amt(p_n_person_id igs_fi_inv_int_all.person_id%TYPE,
260: p_v_fee_type igs_fi_inv_int_all.fee_type%TYPE,
261: p_v_fee_cal_type igs_fi_inv_int_all.fee_cal_type%TYPE,
262: p_n_fee_ci_seq igs_fi_inv_int_all.fee_ci_sequence_number%TYPE,
263: p_v_waiver_name igs_fi_inv_int_all.waiver_name%TYPE) RETURN NUMBER AS
264: /******************************************************************
265: Created By : Amit Gairola
266: Date Created By : 10-Aug-2005
267: Purpose : Procedure for Waiver Amount

Line 276: CURSOR cur_inv(cp_n_person_id igs_fi_inv_int_all.person_id%TYPE,

272: smadathi 08-Nov-2005 Bug 4634950. Modified the cursor cur_prewav
273: to include filter criteria
274: ***************************************************************** */
275:
276: CURSOR cur_inv(cp_n_person_id igs_fi_inv_int_all.person_id%TYPE,
277: cp_v_fee_type igs_fi_inv_int_all.fee_type%TYPE,
278: cp_v_fee_cal_type igs_fi_inv_int_all.fee_cal_type%TYPE,
279: cp_n_fee_ci_seq igs_fi_inv_int_all.fee_ci_sequence_number%TYPE) IS
280: SELECT inv.invoice_amount,

Line 277: cp_v_fee_type igs_fi_inv_int_all.fee_type%TYPE,

273: to include filter criteria
274: ***************************************************************** */
275:
276: CURSOR cur_inv(cp_n_person_id igs_fi_inv_int_all.person_id%TYPE,
277: cp_v_fee_type igs_fi_inv_int_all.fee_type%TYPE,
278: cp_v_fee_cal_type igs_fi_inv_int_all.fee_cal_type%TYPE,
279: cp_n_fee_ci_seq igs_fi_inv_int_all.fee_ci_sequence_number%TYPE) IS
280: SELECT inv.invoice_amount,
281: inv.invoice_id

Line 278: cp_v_fee_cal_type igs_fi_inv_int_all.fee_cal_type%TYPE,

274: ***************************************************************** */
275:
276: CURSOR cur_inv(cp_n_person_id igs_fi_inv_int_all.person_id%TYPE,
277: cp_v_fee_type igs_fi_inv_int_all.fee_type%TYPE,
278: cp_v_fee_cal_type igs_fi_inv_int_all.fee_cal_type%TYPE,
279: cp_n_fee_ci_seq igs_fi_inv_int_all.fee_ci_sequence_number%TYPE) IS
280: SELECT inv.invoice_amount,
281: inv.invoice_id
282: FROM igs_fi_inv_int_all inv

Line 279: cp_n_fee_ci_seq igs_fi_inv_int_all.fee_ci_sequence_number%TYPE) IS

275:
276: CURSOR cur_inv(cp_n_person_id igs_fi_inv_int_all.person_id%TYPE,
277: cp_v_fee_type igs_fi_inv_int_all.fee_type%TYPE,
278: cp_v_fee_cal_type igs_fi_inv_int_all.fee_cal_type%TYPE,
279: cp_n_fee_ci_seq igs_fi_inv_int_all.fee_ci_sequence_number%TYPE) IS
280: SELECT inv.invoice_amount,
281: inv.invoice_id
282: FROM igs_fi_inv_int_all inv
283: WHERE inv.person_id = cp_n_person_id

Line 282: FROM igs_fi_inv_int_all inv

278: cp_v_fee_cal_type igs_fi_inv_int_all.fee_cal_type%TYPE,
279: cp_n_fee_ci_seq igs_fi_inv_int_all.fee_ci_sequence_number%TYPE) IS
280: SELECT inv.invoice_amount,
281: inv.invoice_id
282: FROM igs_fi_inv_int_all inv
283: WHERE inv.person_id = cp_n_person_id
284: AND inv.fee_type = cp_v_fee_type
285: AND inv.fee_cal_type = cp_v_fee_cal_type
286: AND inv.fee_ci_sequence_number = cp_n_fee_ci_seq

Line 290: CURSOR cur_chgadj(cp_n_invoice_id igs_fi_inv_int_all.invoice_id%TYPE) IS

286: AND inv.fee_ci_sequence_number = cp_n_fee_ci_seq
287: AND inv.transaction_type <> 'RETENTION'
288: ORDER BY inv.invoice_id;
289:
290: CURSOR cur_chgadj(cp_n_invoice_id igs_fi_inv_int_all.invoice_id%TYPE) IS
291: SELECT SUM(appl.amount_applied) amt_appl
292: FROM igs_fi_applications appl,
293: igs_fi_credits_all crd,
294: igs_fi_cr_types crt

Line 300: CURSOR cur_prewav(cp_v_fee_cal_type igs_fi_inv_int_all.fee_cal_type%TYPE,

296: AND appl.credit_id = crd.credit_id
297: AND crd.credit_type_id = crt.credit_type_id
298: AND crt.credit_class = 'CHGADJ';
299:
300: CURSOR cur_prewav(cp_v_fee_cal_type igs_fi_inv_int_all.fee_cal_type%TYPE,
301: cp_n_fee_ci_seq igs_fi_inv_int_all.fee_ci_sequence_number%TYPE,
302: cp_v_waiver_name igs_fi_wav_pr_preqs.sub_waiver_name%TYPE) IS
303: SELECT fwpp.sup_waiver_name
304: FROM igs_fi_wav_pr_preqs fwpp

Line 301: cp_n_fee_ci_seq igs_fi_inv_int_all.fee_ci_sequence_number%TYPE,

297: AND crd.credit_type_id = crt.credit_type_id
298: AND crt.credit_class = 'CHGADJ';
299:
300: CURSOR cur_prewav(cp_v_fee_cal_type igs_fi_inv_int_all.fee_cal_type%TYPE,
301: cp_n_fee_ci_seq igs_fi_inv_int_all.fee_ci_sequence_number%TYPE,
302: cp_v_waiver_name igs_fi_wav_pr_preqs.sub_waiver_name%TYPE) IS
303: SELECT fwpp.sup_waiver_name
304: FROM igs_fi_wav_pr_preqs fwpp
305: WHERE fwpp.fee_cal_type = cp_v_fee_cal_type

Line 309: CURSOR cur_prewav_appl(cp_n_invoice_id igs_fi_inv_int_all.invoice_id%TYPE,

305: WHERE fwpp.fee_cal_type = cp_v_fee_cal_type
306: AND fwpp.fee_ci_sequence_number = cp_n_fee_ci_seq
307: AND fwpp.sub_waiver_name = cp_v_waiver_name;
308:
309: CURSOR cur_prewav_appl(cp_n_invoice_id igs_fi_inv_int_all.invoice_id%TYPE,
310: cp_v_waiver_name igs_fi_inv_int_all.waiver_name%TYPE,
311: cp_v_fee_cal_type igs_fi_inv_int_all.fee_cal_type%TYPE,
312: cp_n_fee_ci_seq igs_fi_inv_int_all.fee_ci_sequence_number%TYPE) IS
313: SELECT appl.amount_applied,

Line 310: cp_v_waiver_name igs_fi_inv_int_all.waiver_name%TYPE,

306: AND fwpp.fee_ci_sequence_number = cp_n_fee_ci_seq
307: AND fwpp.sub_waiver_name = cp_v_waiver_name;
308:
309: CURSOR cur_prewav_appl(cp_n_invoice_id igs_fi_inv_int_all.invoice_id%TYPE,
310: cp_v_waiver_name igs_fi_inv_int_all.waiver_name%TYPE,
311: cp_v_fee_cal_type igs_fi_inv_int_all.fee_cal_type%TYPE,
312: cp_n_fee_ci_seq igs_fi_inv_int_all.fee_ci_sequence_number%TYPE) IS
313: SELECT appl.amount_applied,
314: appl.application_id,

Line 311: cp_v_fee_cal_type igs_fi_inv_int_all.fee_cal_type%TYPE,

307: AND fwpp.sub_waiver_name = cp_v_waiver_name;
308:
309: CURSOR cur_prewav_appl(cp_n_invoice_id igs_fi_inv_int_all.invoice_id%TYPE,
310: cp_v_waiver_name igs_fi_inv_int_all.waiver_name%TYPE,
311: cp_v_fee_cal_type igs_fi_inv_int_all.fee_cal_type%TYPE,
312: cp_n_fee_ci_seq igs_fi_inv_int_all.fee_ci_sequence_number%TYPE) IS
313: SELECT appl.amount_applied,
314: appl.application_id,
315: appl.credit_id

Line 312: cp_n_fee_ci_seq igs_fi_inv_int_all.fee_ci_sequence_number%TYPE) IS

308:
309: CURSOR cur_prewav_appl(cp_n_invoice_id igs_fi_inv_int_all.invoice_id%TYPE,
310: cp_v_waiver_name igs_fi_inv_int_all.waiver_name%TYPE,
311: cp_v_fee_cal_type igs_fi_inv_int_all.fee_cal_type%TYPE,
312: cp_n_fee_ci_seq igs_fi_inv_int_all.fee_ci_sequence_number%TYPE) IS
313: SELECT appl.amount_applied,
314: appl.application_id,
315: appl.credit_id
316: FROM igs_fi_applications appl,

Line 335: igs_fi_inv_int_all inv

331: cp_n_fee_ci_seq igs_fi_credits_all.fee_ci_sequence_number%TYPE,
332: cp_n_invoice_id igs_fi_inv_int.invoice_id%TYPE) IS
333: SELECT igs_fi_gen_007.get_sum_appl_amnt(application_id) amt_appl
334: FROM igs_fi_applications appl,
335: igs_fi_inv_int_all inv
336: WHERE appl.invoice_id = inv.invoice_id
337: AND appl.credit_id = cp_n_credit_id
338: AND inv.fee_cal_type = cp_v_fee_cal_type
339: AND inv.fee_ci_sequence_number = cp_n_fee_ci_seq

Line 630: l_n_invoice_id igs_fi_inv_int_all.invoice_id%TYPE;

626: l_n_comp_wav_amnt igs_fi_credits_all.amount%TYPE;
627: l_n_eligible_amnt igs_fi_credits_all.amount%TYPE;
628: l_n_diff_wav_amnt igs_fi_credits_all.amount%TYPE;
629: l_n_credit_id igs_fi_credits_all.credit_id%TYPE;
630: l_n_invoice_id igs_fi_inv_int_all.invoice_id%TYPE;
631:
632: l_v_finaid_wvr_flag igs_fi_control.waiver_notify_finaid_flag%TYPE;
633: l_n_tot_wav_amnt igs_fi_credits_all.amount%TYPE;
634: l_v_assgn_stat_code igs_fi_wav_std_pgms.assignment_status_code%TYPE;

Line 1021: cp_v_fee_cal_type igs_fi_inv_int_all.fee_cal_type%TYPE,

1017:
1018: ***************************************************************** */
1019:
1020: CURSOR cur_wav_pgms(cp_v_fee_type igs_fi_fee_type.fee_type%TYPE,
1021: cp_v_fee_cal_type igs_fi_inv_int_all.fee_cal_type%TYPE,
1022: cp_n_fee_ci_seq igs_fi_inv_int_all.fee_ci_sequence_number%TYPE) IS
1023: SELECT fwp.fee_cal_type,
1024: fwp.fee_ci_sequence_number,
1025: fwp.waiver_name,

Line 1022: cp_n_fee_ci_seq igs_fi_inv_int_all.fee_ci_sequence_number%TYPE) IS

1018: ***************************************************************** */
1019:
1020: CURSOR cur_wav_pgms(cp_v_fee_type igs_fi_fee_type.fee_type%TYPE,
1021: cp_v_fee_cal_type igs_fi_inv_int_all.fee_cal_type%TYPE,
1022: cp_n_fee_ci_seq igs_fi_inv_int_all.fee_ci_sequence_number%TYPE) IS
1023: SELECT fwp.fee_cal_type,
1024: fwp.fee_ci_sequence_number,
1025: fwp.waiver_name,
1026: fwp.waiver_method_code,