APPS.IGS_FI_WAV_UTILS_002 dependencies on IGS_FI_APPLICATIONS

Line 424: PROCEDURE reverse_waiver(p_n_source_credit_id IN igs_fi_applications.credit_id%TYPE,

420: p_v_string => 'Credit Id ' || p_n_credit_id );
421: END IF;
422: END call_credits_api;
423:
424: PROCEDURE reverse_waiver(p_n_source_credit_id IN igs_fi_applications.credit_id%TYPE,
425: p_v_reversal_reason IN igs_lookup_values.lookup_code%TYPE,
426: p_v_reversal_comments IN igs_fi_credits_all.reversal_comments%TYPE,
427: p_d_reversal_gl_date IN DATE,
428: p_v_return_status OUT NOCOPY VARCHAR2,

Line 454: FROM igs_fi_applications appl,

450: SELECT igs_fi_gen_007.get_sum_appl_amnt(appl.application_id) amount_applied,
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'

Line 463: FROM IGS_FI_APPLICATIONS APPL2

459: AND inv.transaction_type <> 'WAIVER_ADJ'
460: --Added for the Bug 4686711, to exclude those charges for which unapp record exists in application table.
461: AND NOT EXISTS (
462: SELECT 'X'
463: FROM IGS_FI_APPLICATIONS APPL2
464: WHERE APPL2.APPLICATION_TYPE = 'UNAPP'
465: AND APPL2.LINK_APPLICATION_ID = APPL.APPLICATION_ID
466: AND APPL2.AMOUNT_APPLIED = - APPL.AMOUNT_APPLIED)
467: ORDER BY appl.application_id;

Line 493: l_n_application_id igs_fi_applications.application_id%TYPE;

489: l_cur_credit_rec_exists cur_credit_rec_exists%ROWTYPE;
490: l_cur_appl_record cur_appl_record%ROWTYPE;
491: l_cur_waiver_prg_attr cur_waiver_prg_attr%ROWTYPE;
492:
493: l_n_application_id igs_fi_applications.application_id%TYPE;
494: l_n_dr_gl_ccid igs_fi_cr_activities.dr_gl_ccid%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;

Line 759: FUNCTION get_waiver_reversal_amount(p_n_source_credit_id IN igs_fi_applications.credit_id%TYPE) RETURN NUMBER IS

755: p_v_return_status := 'E';
756: END reverse_waiver;
757:
758:
759: FUNCTION get_waiver_reversal_amount(p_n_source_credit_id IN igs_fi_applications.credit_id%TYPE) RETURN NUMBER IS
760: /******************************************************************
761: Created By : Umesh Udayaprakash
762: Date Created By : 7/4/2005
763: Purpose : Function to return the waiver Reversal Amount.

Line 782: FROM igs_fi_applications appl,

778: SELECT igs_fi_gen_007.get_sum_appl_amnt(appl.application_id) amount_applied,
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'

Line 791: FROM IGS_FI_APPLICATIONS APPL2

787: AND inv.transaction_type <> 'WAIVER_ADJ'
788: --Added for the Bug 4686711, to exclude those charges for which unapp record exists in application table.
789: AND NOT EXISTS (
790: SELECT 'X'
791: FROM IGS_FI_APPLICATIONS APPL2
792: WHERE APPL2.APPLICATION_TYPE = 'UNAPP'
793: AND APPL2.LINK_APPLICATION_ID = APPL.APPLICATION_ID
794: AND APPL2.AMOUNT_APPLIED = - APPL.AMOUNT_APPLIED)
795: ORDER BY appl.application_id;