1 PACKAGE igf_aw_gen_003 AS
2 /* $Header: IGFAW12S.pls 120.1 2005/07/01 06:55:41 appldev ship $ */
3
4 PROCEDURE create_auto_disb( p_fund_id IN igf_aw_award.fund_id%TYPE,
5 p_award_id IN igf_aw_award.award_id%TYPE,
6 p_offered_amt IN igf_aw_award.offered_amt%TYPE,
7 p_award_status IN igf_aw_award.award_status%TYPE,
8 p_adplans_id IN igf_aw_awd_dist_plans.adplans_id%TYPE,
9 p_method_code IN igf_aw_awd_dist_plans.dist_plan_method_code%TYPE,
10 p_awd_prd_code IN igf_aw_awd_prd_term.award_prd_cd%TYPE
11 );
12
13 PROCEDURE round_off_disbursements(
14 p_fund_id IN igf_aw_award_t_all.fund_id%TYPE,
15 p_award_id IN igf_aw_award_t_all.award_id%TYPE,
16 p_offered_amt IN igf_aw_award_t_all.offered_amt%TYPE,
17 p_award_status IN igf_aw_award_all.award_status%TYPE,
18 p_dist_plan_code IN igf_aw_awd_dist_plans.dist_plan_method_code%TYPE,
19 p_disb_count IN NUMBER
20 );
21
22 PROCEDURE update_accept_amount (
23 p_award_id IN igf_aw_award.award_id%TYPE
24 );
25 -- adhawan, May 12th 2002
26 --This procedure ensures that whenever the Award Status is changed to Accepted from Offered
27 --and the Accepted amount is null or Zero then updation of the accepted amounts should take
28 -- place with the offered amounts to the Disbursement table.
29 --Bug ID : 2332588
30
31 PROCEDURE update_awd_cancell_to_offer(p_award_id IN igf_aw_award.award_id%TYPE,
32 p_award_stat IN VARCHAR2,
33 p_fed_fund_code IN VARCHAR2,
34 p_base_id IN NUMBER,
35 p_message OUT NOCOPY VARCHAR2
36 );
37
38 -- adhawan, May 26th 2002
39 --This procedure ensures that whenever the Award Status is changed to Accepted OR Offered
40 --from Cancelled or Declined the Transaction type , eligibility status , elig date,
41 --and Award amount should get updated
42 --Bug ID : 2375571
43
44
45 PROCEDURE remove_awd_rules_override(
46 p_award_id IN igf_aw_award.award_id%TYPE
47 );
48
49 PROCEDURE create_over_awd_holds(
50 p_award_id IN igf_aw_award.award_id%TYPE
51 );
52 --To update the Financial Aid base Record with The cost of Attendance
53 --Fixed Coa , Pell Coa , Coa for Federal , Coa for Institutional
54 PROCEDURE updating_coa_in_fa_base
55 (p_base_id igf_ap_fa_base_rec.base_id%TYPE);
56
57
58
59 --
60 -- This function returns validation failure message if any
61 -- The out NOCOPY parameter is indicator if the award is an overAward or not
62 --
63
64 FUNCTION check_amounts ( p_calling_form IN OUT NOCOPY VARCHAR2,
65 p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
66 p_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,
67 p_fund_code IN igf_aw_fund_mast_all.fund_code%TYPE,
68 p_fed_fund_code IN igf_aw_fund_cat_all.fed_fund_code%TYPE,
69 p_person_number IN igf_aw_award_v.person_number%TYPE,
70 p_award_id IN igf_aw_award_all.award_id%TYPE,
71 p_act_isir IN VARCHAR2,
72 p_ld_seq_number IN NUMBER,
73 p_awd_prd_code IN igf_aw_awd_prd_term.award_prd_cd%TYPE DEFAULT NULL,
74 p_chk_holds OUT NOCOPY VARCHAR2)
75 RETURN VARCHAR2;
76
77
78 --
79 -- This function returns validation failure message if any
80 -- The out NOCOPY parameter is indicator if the award is an overAward or not
81 --
82
83 FUNCTION check_disbdts ( p_award_id IN igf_aw_award_all.award_id%TYPE,
84 p_ld_seq_number IN NUMBER)
85 RETURN VARCHAR2;
86
87 --
88 -- Procedure to update show_on_bill flag based on the fund manager value
89 --
90 PROCEDURE update_bill_flag ( p_fund_id IN igf_aw_award_all.fund_id%TYPE,
91 p_new_val IN igf_aw_fund_mast_all.show_on_bill%TYPE);
92
93 FUNCTION delete_awd_disb ( p_award_id IN igf_aw_award_all.award_id%TYPE,
94 p_ld_seq_num IN igf_aw_awd_disb_all.ld_sequence_number%TYPE DEFAULT NULL,
95 p_disb_num IN igf_aw_awd_disb_all.disb_num%TYPE DEFAULT NULL)
96 RETURN VARCHAR2;
97
98
99 FUNCTION get_total_disb ( p_award_id IN igf_aw_award_all.award_id%TYPE,
100 p_ld_seq_num IN igf_aw_awd_disb_all.ld_sequence_number%TYPE DEFAULT NULL)
101 RETURN NUMBER;
102
103 PROCEDURE awd_group_freeze(p_award_grp IN VARCHAR2,
104 p_base_id IN NUMBER,
105 p_out OUT NOCOPY VARCHAR2 );
106
107 PROCEDURE get_common_perct(
108 p_adplans_id IN igf_aw_awd_dist_plans.adplans_id%TYPE,
109 p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
110 p_perct OUT NOCOPY NUMBER,
111 p_awd_prd_code IN igf_aw_awd_prd_term.award_prd_cd%TYPE DEFAULT NULL
112 );
113
114 PROCEDURE check_common_terms(
115 p_adplans_id IN igf_aw_awd_dist_plans.adplans_id%TYPE,
116 p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
117 p_result OUT NOCOPY NUMBER,
118 p_awd_prd_code IN igf_aw_awd_prd_term.award_prd_cd%TYPE DEFAULT NULL
119 );
120
121
122 -- sjadhav 1-Dec-2003 FA 131 Build
123 PROCEDURE create_pell_disb( p_award_id IN NUMBER,
124 p_pell_tab IN igf_gr_pell_calc.pell_tab);
125
126 -- sjadhav 1-Dec-2003 FA 131 Build
127 PROCEDURE update_award_app_trans( p_award_id IN NUMBER,
128 p_base_id IN NUMBER);
129
130 FUNCTION check_coa(
131 p_base_id IN NUMBER,
132 p_awd_prd_code IN igf_aw_awd_prd_term.award_prd_cd%TYPE DEFAULT NULL
133 ) RETURN BOOLEAN;
134
135 FUNCTION get_plan_disb_count(p_adplans_id IN igf_aw_awd_dist_plans.adplans_id%TYPE,
136 p_awd_prd_code IN igf_aw_awd_prd_term.award_prd_cd%TYPE DEFAULT NULL
137 ) RETURN NUMBER;
138
139 END igf_aw_gen_003;