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_WAV_UTILS_002 dependencies on IGS_FI_INV_INT

Line 44: p_n_waiver_amt IN igs_fi_inv_int_all.invoice_amount%TYPE,

40: p_n_fee_ci_seq_number IN igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,
41: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
42: p_v_adj_fee_type IN igs_fi_fee_type.fee_type%TYPE,
43: p_v_currency_cd IN igs_fi_control.currency_cd%TYPE,
44: p_n_waiver_amt IN igs_fi_inv_int_all.invoice_amount%TYPE,
45: p_d_gl_date IN igs_fi_invln_int.gl_date%TYPE,
46: p_n_invoice_id OUT NOCOPY igs_fi_inv_int.invoice_id%TYPE,
47: x_return_status OUT NOCOPY VARCHAR2) AS
48: /******************************************************************

Line 46: p_n_invoice_id OUT NOCOPY igs_fi_inv_int.invoice_id%TYPE,

42: p_v_adj_fee_type IN igs_fi_fee_type.fee_type%TYPE,
43: p_v_currency_cd IN igs_fi_control.currency_cd%TYPE,
44: p_n_waiver_amt IN igs_fi_inv_int_all.invoice_amount%TYPE,
45: p_d_gl_date IN igs_fi_invln_int.gl_date%TYPE,
46: p_n_invoice_id OUT NOCOPY igs_fi_inv_int.invoice_id%TYPE,
47: x_return_status OUT NOCOPY VARCHAR2) AS
48: /******************************************************************
49: Created By : Umesh Udayaprakash
50: Date Created By : 7/4/2005

Line 455: igs_fi_inv_int_all inv

451: appl.application_id,
452: appl.credit_id,
453: appl.invoice_id
454: FROM igs_fi_applications appl,
455: igs_fi_inv_int_all inv
456: WHERE appl.credit_id = cp_n_source_credit_id
457: AND appl.invoice_id = inv.invoice_id
458: AND appl.application_type = 'APP'
459: AND inv.transaction_type <> 'WAIVER_ADJ'

Line 499: l_n_inv_amt_due igs_fi_inv_int_all.invoice_amount_due%TYPE;

495: l_n_cr_gl_ccid igs_fi_cr_activities.cr_gl_ccid%TYPE;
496: l_v_dr_account_cd igs_fi_cr_activities.dr_account_cd%TYPE;
497: l_v_cr_account_cd igs_fi_cr_activities.cr_account_cd%TYPE;
498: l_n_unapp_amount igs_fi_credits_all.unapplied_amount%TYPE;
499: l_n_inv_amt_due igs_fi_inv_int_all.invoice_amount_due%TYPE;
500: l_v_err_msg fnd_new_messages.message_name%TYPE;
501: l_b_status BOOLEAN;
502: l_n_wav_adj_amount NUMBER;
503: l_n_unapplied_amount NUMBER;

Line 508: l_n_invoice_id igs_fi_inv_int.invoice_id%TYPE;

504: e_expected_error EXCEPTION;
505:
506: l_v_currency_cd igs_fi_control_all.currency_cd%TYPE;
507: l_v_curr_desc fnd_currencies_tl.name%TYPE;
508: l_n_invoice_id igs_fi_inv_int.invoice_id%TYPE;
509:
510: l_v_closing_status VARCHAR2(1);
511:
512: BEGIN

Line 783: igs_fi_inv_int_all inv

779: appl.application_id,
780: appl.credit_id,
781: appl.invoice_id
782: FROM igs_fi_applications appl,
783: igs_fi_inv_int_all inv
784: WHERE appl.credit_id = cp_n_source_credit_id
785: AND appl.invoice_id = inv.invoice_id
786: AND appl.application_type = 'APP'
787: AND inv.transaction_type <> 'WAIVER_ADJ'

Line 1263: CURSOR cur_chg(cp_n_person_id igs_fi_inv_int.person_id%TYPE,

1259: --Change History:
1260: --Who When What
1261: ------------------------------------------------------------------
1262: -- Cursor for checking for Error Transactions
1263: CURSOR cur_chg(cp_n_person_id igs_fi_inv_int.person_id%TYPE,
1264: cp_v_fee_type igs_fi_inv_int.fee_type%TYPE,
1265: cp_v_fee_cal_type igs_fi_inv_int.fee_cal_type%TYPE,
1266: cp_n_fee_ci_seq igs_fi_inv_int.fee_ci_sequence_number%TYPE) IS
1267: SELECT 'x'

Line 1264: cp_v_fee_type igs_fi_inv_int.fee_type%TYPE,

1260: --Who When What
1261: ------------------------------------------------------------------
1262: -- Cursor for checking for Error Transactions
1263: CURSOR cur_chg(cp_n_person_id igs_fi_inv_int.person_id%TYPE,
1264: cp_v_fee_type igs_fi_inv_int.fee_type%TYPE,
1265: cp_v_fee_cal_type igs_fi_inv_int.fee_cal_type%TYPE,
1266: cp_n_fee_ci_seq igs_fi_inv_int.fee_ci_sequence_number%TYPE) IS
1267: SELECT 'x'
1268: FROM igs_fi_inv_int inv,

Line 1265: cp_v_fee_cal_type igs_fi_inv_int.fee_cal_type%TYPE,

1261: ------------------------------------------------------------------
1262: -- Cursor for checking for Error Transactions
1263: CURSOR cur_chg(cp_n_person_id igs_fi_inv_int.person_id%TYPE,
1264: cp_v_fee_type igs_fi_inv_int.fee_type%TYPE,
1265: cp_v_fee_cal_type igs_fi_inv_int.fee_cal_type%TYPE,
1266: cp_n_fee_ci_seq igs_fi_inv_int.fee_ci_sequence_number%TYPE) IS
1267: SELECT 'x'
1268: FROM igs_fi_inv_int inv,
1269: igs_fi_invln_int invln

Line 1266: cp_n_fee_ci_seq igs_fi_inv_int.fee_ci_sequence_number%TYPE) IS

1262: -- Cursor for checking for Error Transactions
1263: CURSOR cur_chg(cp_n_person_id igs_fi_inv_int.person_id%TYPE,
1264: cp_v_fee_type igs_fi_inv_int.fee_type%TYPE,
1265: cp_v_fee_cal_type igs_fi_inv_int.fee_cal_type%TYPE,
1266: cp_n_fee_ci_seq igs_fi_inv_int.fee_ci_sequence_number%TYPE) IS
1267: SELECT 'x'
1268: FROM igs_fi_inv_int inv,
1269: igs_fi_invln_int invln
1270: WHERE inv.person_id = cp_n_person_id

Line 1268: FROM igs_fi_inv_int inv,

1264: cp_v_fee_type igs_fi_inv_int.fee_type%TYPE,
1265: cp_v_fee_cal_type igs_fi_inv_int.fee_cal_type%TYPE,
1266: cp_n_fee_ci_seq igs_fi_inv_int.fee_ci_sequence_number%TYPE) IS
1267: SELECT 'x'
1268: FROM igs_fi_inv_int inv,
1269: igs_fi_invln_int invln
1270: WHERE inv.person_id = cp_n_person_id
1271: AND inv.fee_type = cp_v_fee_type
1272: AND inv.fee_cal_type = cp_v_fee_cal_type