PACKAGE: APPS.IGF_AW_PACKNG_SUBFNS

Source

1 PACKAGE igf_aw_packng_subfns AS
2 /* $Header: IGFAW09S.pls 120.2 2006/08/04 07:38:32 veramach ship $ */
3 
4 -- who          when             what
5 -- museshad     15-Jun-2005      Build# FA157 - Bug# 4382371.
6 --                               Added the parameters - l_awd_period,  l_called_from
7 --                               to check_loan_limits() and get_class_stnd() procedures.
8 -- veramach      11-Oct-2004     Obsoleted get_coa_months,stud_elig_chk
9 -- bkkumar       14-Jan-04       Bug# 3360702 In the get_class_stnd
10 --                               Added one new award_id parameter and changed the fund_id parameter to adplans_id
11 -- veramach      11-NOV-2003     FA 125 Multiple distribution methods
12 --                               1.Changed function signature of get_class_stnd,check_loan_limits to take adplans_id instead of fund_id
13 -- bkkumar      31-oct-2003      Bug# 3229935 Changed the declaration of the
14 --                               fed_fund_code,fund_code,award_amount,award_date
15 
16 
17 TYPE std_loan_rec IS RECORD(fed_fund_code    igf_aw_fund_cat_all.fed_fund_code%TYPE,
18                             fund_code        igf_aw_fund_cat_all.fund_code%TYPE,
19                             award_amount     igf_aw_award_all.offered_amt%TYPE,
20                             award_date       igf_aw_award_all.award_date%TYPE);
21 
22 TYPE std_loan_tab IS TABLE OF std_loan_rec;
23 
24 PROCEDURE check_loan_limits( l_base_id        IN NUMBER,
25                              fund_type        IN VARCHAR2,
26                              l_award_id       IN NUMBER,
27                              l_adplans_id        IN NUMBER,
28                              l_aid            IN OUT NOCOPY NUMBER,
29                              l_std_loan_tab   IN std_loan_tab DEFAULT NULL,
30                              p_msg_name       OUT NOCOPY VARCHAR2,
31                              l_awd_period     IN igf_aw_awd_prd_term.award_prd_cd%TYPE DEFAULT NULL,
32                              l_called_from    IN VARCHAR2 DEFAULT 'NON-PACKAGING',
33                              p_chk_aggr_limit IN VARCHAR2 DEFAULT 'Y'
34                              ) ;
35 
36 PROCEDURE get_fed_efc( l_base_id IN          NUMBER,
37                        l_awd_prd_code IN     igf_aw_awd_prd_term.award_prd_cd%TYPE,
38                        l_efc_f OUT NOCOPY    NUMBER,
39                        l_pell_efc OUT NOCOPY NUMBER,
40                        l_efc_ay       OUT NOCOPY  NUMBER
41                        ) ;
42 
43 FUNCTION get_class_stnd(
44                         p_base_id     IN  igf_ap_fa_base_rec.base_id%TYPE,
45                         p_person_id   IN  igf_ap_fa_base_rec.person_id%TYPE,
46                         p_adplans_id  IN  NUMBER,
47                         p_award_id    IN  igf_aw_award_all.award_id%TYPE,
48                         p_course_type OUT NOCOPY igs_ps_ver_all.course_type%TYPE,
49                         p_awd_period     IN igf_aw_awd_prd_term.award_prd_cd%TYPE DEFAULT NULL,
50                         p_called_from    IN VARCHAR2 DEFAULT 'NON-PACKAGING'
51                        ) RETURN CHAR;
52 
53 FUNCTION is_over_award_occured(
54                                p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
55                                p_mthd_type    VARCHAR2 DEFAULT NULL,
56                                p_awd_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE DEFAULT NULL
57                               ) RETURN BOOLEAN;
58 
59 END igf_aw_packng_subfns;