1 PACKAGE IGF_AW_GEN_002 AS
2 /* $Header: IGFAW10S.pls 120.1 2006/08/04 07:39:27 veramach noship $ */
3 /*
4 ||HISTORY
5 || Who When What
6 || veramach Oct 2004 FA 152/FA 137 - Changes to wrappers to include Award Period setup
7 || veramach 24-Aug-2004 FA 145 Obsoleted pell_efc_range
8 || veramach 08-Apr-2004 bug 3547237
9 || Obsoleted get_fed_efc. Replaced references with igf_aw_packng_subfns.get_fed_efc
10 */
11 FUNCTION get_sectionii_stdnt (
12 p_depend_stat IN igf_lookups_view.lookup_code%TYPE,
13 p_class_standing IN igf_lookups_view.lookup_code%TYPE,
14 p_ci_cal_type IN igs_ca_inst.cal_type%TYPE,
15 p_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
16 p_minvalue IN igf_aw_fi_inc_level.minvalue%TYPE,
17 p_maxvalue IN igf_aw_fi_inc_level.maxvalue%TYPE,
18 p_efc VARCHAR2) return NUMBER;
19
20 FUNCTION get_sectionvi_fund (
21 p_rec_type IN igf_aw_fisap_vi_h.rec_type%TYPE,
22 p_fund_type IN igf_aw_award_v.fed_fund_code%TYPE,
23 p_depend_stat IN igf_lookups_view.lookup_code%TYPE,
24 p_class_standing IN igf_lookups_view.lookup_code%TYPE,
25 p_ci_cal_type IN igs_ca_inst.cal_type%TYPE,
26 p_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
27 p_minvalue IN igf_aw_fi_inc_level.minvalue%TYPE,
28 p_maxvalue IN igf_aw_fi_inc_level.maxvalue%TYPE )
29 return NUMBER ;
30
31 FUNCTION get_sectionvi_stdnt (
32 p_rec_type IN igf_aw_fisap_vi_h.rec_type%TYPE,
33 p_fund_type IN igf_aw_award_v.fed_fund_code%TYPE,
34 p_depend_stat IN igf_lookups_view.lookup_code%TYPE,
35 p_class_standing IN igf_lookups_view.lookup_code%TYPE,
36 p_ci_cal_type IN igs_ca_inst.cal_type%TYPE,
37 p_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
38 p_minvalue IN igf_aw_fi_inc_level.minvalue%TYPE,
39 p_maxvalue IN igf_aw_fi_inc_level.maxvalue%TYPE
40 ) return NUMBER ;
41
42 --Enh Bug 2142666 EFC Build
43 --Procedure added for Comparing ISIR Fields in Compare Application
44
45 PROCEDURE compare_isirs(
46 p_isir_id igf_ap_isir_matched_all.isir_id%TYPE,
47 p_corr_isir_id igf_ap_isir_matched_all.isir_id%TYPE,
48 p_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
49 p_seq_num igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,
50 p_corr_status igf_ap_isir_corr.correction_status%TYPE DEFAULT NULL
51 );
52
53
54 /*
55 || Created By : [email protected]
56 || Created On : 08-JAN-2001
57 || Purpose : Bug No: 2154941 This procedure takes the base_id (Student and Award Year) as a parameter. It passes out NOCOPY the
58 || Federal and Institutional resources for that base id, and Federal and Institutional Unmet
59 || need/Overaward for that base_id.
60 || Known limitations, enhancements or remarks :
61 || Change History :
62 || Who When What
63 || (reverse chronological order - newest change first)
64 */
65 PROCEDURE get_resource_need
66 (
67 p_base_id IN igf_ap_fa_base_rec.base_id%TYPE,
68 p_resource_f OUT NOCOPY NUMBER,
69 p_resource_i OUT NOCOPY NUMBER,
70 p_unmet_need_f OUT NOCOPY NUMBER,
71 p_unmet_need_i OUT NOCOPY NUMBER,
72 p_resource_f_fc OUT NOCOPY NUMBER,
73 p_resource_i_fc OUT NOCOPY NUMBER,
74 p_awd_prd_code IN igf_aw_awd_prd_term.award_prd_cd%TYPE DEFAULT NULL,
75 p_calc_for_subz_loan IN VARCHAR2 DEFAULT 'N'
76 );
77
78 END igf_aw_gen_002;