1 PACKAGE igs_fi_wav_utils_002 AS
2 /* $Header: IGSFI97S.pls 120.2 2005/10/31 10:27:48 appldev noship $ */
3 /************************************************************************
4 Created By : Umesh Udayaprakash
5 Date Created By : 7/4/2005
6 Purpose : Generic util Pacakge for Waiver Functionality
7 Created as part of FI234 - Tuition Waivers enh. Bug # 3392095
8 Known limitations,enhancements,remarks:
9 Change History
10 Who When What
11 smadathi 28-Oct-2005 Bug 4704177: Enhancement for Tuition Waiver
12 CCR. Added function to check for the Error Account = 'Y'
13
14 *************************************************************************/
15
16 PROCEDURE call_charges_api( p_n_person_id IN hz_parties.party_id%TYPE,
17 p_v_fee_cal_type IN igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
18 p_n_fee_ci_seq_number IN igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,
19 p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
20 p_v_adj_fee_type IN igs_fi_fee_type.fee_type%TYPE,
21 p_v_currency_cd IN igs_fi_control.currency_cd%TYPE,
22 p_n_waiver_amt IN igs_fi_inv_int_all.invoice_amount%TYPE,
23 p_d_gl_date IN igs_fi_invln_int.gl_date%TYPE,
24 p_n_invoice_id OUT NOCOPY igs_fi_inv_int.invoice_id%TYPE,
25 x_return_status OUT NOCOPY VARCHAR2);
26
27 PROCEDURE call_credits_api(p_n_person_id IN hz_parties.party_id%TYPE,
28 p_v_fee_cal_type IN igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
29 p_n_fee_ci_seq_number IN igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,
30 p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
31 p_n_credit_type_id IN igs_fi_credits.credit_id%TYPE,
32 p_v_currency_cd IN igs_fi_control.currency_cd%TYPE,
33 p_n_waiver_amt IN NUMBER,
34 p_d_gl_date IN igs_fi_invln_int.gl_date%TYPE,
35 p_n_credit_id OUT NOCOPY NUMBER,
36 x_return_status OUT NOCOPY VARCHAR2);
37
38 PROCEDURE reverse_waiver(p_n_source_credit_id IN igs_fi_applications.credit_id%TYPE,
39 p_v_reversal_reason IN igs_lookup_values.lookup_code%TYPE,
40 p_v_reversal_comments IN igs_fi_credits_all.reversal_comments%TYPE,
41 p_d_reversal_gl_date IN DATE,
42 p_v_return_status OUT NOCOPY VARCHAR2,
43 p_v_message_name OUT NOCOPY VARCHAR2);
44
45
46 FUNCTION get_waiver_reversal_amount(p_n_source_credit_id IN igs_fi_applications.credit_id%TYPE) RETURN NUMBER;
47
48 FUNCTION check_stdnt_wav_assignment(p_n_person_id IN hz_parties.party_id%TYPE,
49 p_v_fee_type IN igs_fi_f_typ_ca_inst.fee_type%TYPE,
50 p_v_fee_cal_type IN igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
51 p_n_fee_ci_seq_number IN igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE) RETURN BOOLEAN;
52
53 PROCEDURE roll_over_wav_assign(p_rollover_rowid IN VARCHAR2,
54 p_v_stud_rollover_flag IN VARCHAR2,
55 p_n_dest_fee_ci_seq_number IN igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,
56 p_v_rollover_status OUT NOCOPY VARCHAR2);
57
58 PROCEDURE update_wav_assign_status( p_v_fee_cal_type IN VARCHAR2,
59 p_n_fee_ci_seq_number IN NUMBER,
60 p_v_waiver_name IN VARCHAR2,
61 p_v_new_status IN VARCHAR2,
62 x_return_status OUT NOCOPY VARCHAR2);
63
64 FUNCTION check_chg_error_account ( p_n_person_id IN hz_parties.party_id%TYPE,
65 p_v_fee_type IN igs_fi_fee_type_all.fee_type%TYPE,
66 p_v_fee_cal_type IN igs_ca_inst_all.cal_type%TYPE,
67 p_n_fee_ci_seq_number IN igs_ca_inst_all.sequence_number%TYPE
68 ) RETURN NUMBER;
69
70
71
72 END igs_fi_wav_utils_002;