1 PACKAGE igs_fi_wav_utils_001 AS
2 /* $Header: IGSFI95S.pls 120.0 2005/09/09 20:20:45 appldev noship $ */
3
4 /******************************************************************
5 Created By : Anji Yedubati
6 Date Created By : 05-JUL-2005
7 Purpose : Waiver Utility Package for the generic routines,
8 get_eligible_waiver_amt and apply_waivers, which are
9 required for waiver processing
10 Created as part of FI234 - Tuition Waivers enh. Bug # 3392095
11
12 Known limitations,enhancements,remarks:
13
14 Change History
15
16 WHO WHEN WHAT
17 pathipat 16-Aug-2005 Enh 3392095 - Tuition Waivers Enh
18 Added procedure create_ss_waiver_transactions
19 ***************************************************************** */
20
21 PROCEDURE get_eligible_waiver_amt(
22 p_n_person_id IN igs_pe_person_base_v.person_id%TYPE,
23 p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
24 p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
25 p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
26 p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,
27 p_v_waiver_method_code IN igs_fi_waiver_pgms.waiver_method_code%TYPE,
28 p_v_waiver_mode_code IN igs_fi_waiver_pgms.waiver_mode_code%TYPE,
29 p_n_source_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,
30 x_return_status OUT NOCOPY VARCHAR2,
31 x_eligible_amount OUT NOCOPY NUMBER );
32
33 PROCEDURE apply_waivers(
34 p_n_person_id IN igs_pe_person_base_v.person_id%TYPE,
35 p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
36 p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
37 p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
38 p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,
39 p_v_adj_fee_type IN igs_fi_waiver_pgms.adjustment_fee_type%TYPE,
40 p_v_waiver_method_code IN igs_fi_waiver_pgms.waiver_method_code%TYPE,
41 p_v_waiver_mode_code IN igs_fi_waiver_pgms.waiver_mode_code%TYPE,
42 p_n_source_credit_id IN igs_fi_credits_all.credit_id%TYPE,
43 p_n_source_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,
44 p_v_currency_cd IN igs_fi_inv_int_all.currency_cd%TYPE,
45 p_d_gl_date IN igs_fi_invln_int.gl_date%TYPE,
46 x_return_status OUT NOCOPY VARCHAR2 );
47
48 PROCEDURE create_ss_waiver_transactions(
49 p_n_person_id IN igs_pe_person_base_v.person_id%TYPE,
50 p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
51 p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
52 p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
53 p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,
54 p_v_adj_fee_type IN igs_fi_waiver_pgms.adjustment_fee_type%TYPE,
55 p_n_credit_type_id IN igs_fi_waiver_pgms.credit_type_id%TYPE,
56 p_v_waiver_method_code IN igs_fi_waiver_pgms.waiver_method_code%TYPE,
57 p_v_waiver_mode_code IN igs_fi_waiver_pgms.waiver_mode_code%TYPE,
58 p_n_source_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,
59 p_n_waiver_amount IN igs_fi_credits_all.amount%TYPE,
60 p_v_currency_cd IN igs_fi_inv_int_all.currency_cd%TYPE,
61 p_d_gl_date IN igs_fi_invln_int_all.gl_date%TYPE,
62 x_return_status OUT NOCOPY VARCHAR2);
63
64 END igs_fi_wav_utils_001;