DBA Data[Home] [Help]

PACKAGE: APPS.IGS_FI_WAV_UTILS_002

Source


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;