1 PACKAGE igf_ap_efc_calc AUTHID CURRENT_USER AS
2 /* $Header: IGFAP25S.pls 115.10 2003/08/05 10:13:28 rasahoo noship $ */
3 /*
4 || Created By : pkpatel
5 || Created On : 10-DEC-2001
6 || Purpose : Bug No - 2142666 EFC DLD.
7 || This Package contains procedures for the Concurrent Program EFC Calculation
8 || Known limitations, enhancements or remarks :
9 || Change History :
10 || Who When What
11 || masehgal,sgaddama,gmuralid,cdcruz 08-03-2003 BUG# 2833795 - EFC Mismatch Base BUG
12 || masehgal 15-feb-2003 # 2758804 FACR105 EFC Build - Package Revamped
13 || cdcruz 18-Oct-2003 Bug# 2613546 FUNCTION get_efc_no_of_months has been modified
14 || P_flag parameter has been dropped
15 ||
16 */
17
18 EXCEPTION_IN_REJECTS EXCEPTION ;
19 EXCEPTION_IN_SETUP EXCEPTION ;
20
21 g_efc_a_9 igf_ap_isir_matched_all.paid_efc%TYPE ;
22 g_efc_a_10 igf_ap_isir_matched_all.paid_efc%TYPE ;
23 g_efc_a_11 igf_ap_isir_matched_all.paid_efc%TYPE ;
24 g_efc_a_12 igf_ap_isir_matched_all.paid_efc%TYPE ;
25
26 g_s_efc_a_9 igf_ap_isir_matched_all.paid_efc%TYPE ;
27 g_s_efc_a_10 igf_ap_isir_matched_all.paid_efc%TYPE ;
28 g_s_efc_a_11 igf_ap_isir_matched_all.paid_efc%TYPE ;
29 g_s_efc_a_12 igf_ap_isir_matched_all.paid_efc%TYPE ;
30
31 isir_rec igf_ap_isir_matched%ROWTYPE ;
32 p_sys_award_year VARCHAR2(30) ;
33
34
35 FUNCTION get_efc_no_of_months (p_last_end_dt IN DATE, -- end date of the Last Teaching/Load calendar
36 p_base_id IN igf_ap_fa_base_rec.base_id%TYPE) -- Students Base Id
37 RETURN NUMBER;
38 /*
39 || Created By : [email protected]
40 || Created On : 11-DEC-2001
41 || Purpose : Bug No - 2142666 EFC DLD.
42 || This procedure finds the exact number of months not repeating the overlapped terms
43 || and neglecting the gap between terms.
44 || Known limitations, enhancements or remarks :
45 || Change History :
46 || Who When What
47 || (reverse chronological order - newest change first)
48 */
49
50
51 PROCEDURE calculate_efc (p_isir_rec IN OUT NOCOPY igf_ap_isir_matched%ROWTYPE ,
52 p_ignore_warnings IN VARCHAR2 ,
53 p_sys_batch_yr IN VARCHAR2 ,
54 p_return_status OUT NOCOPY VARCHAR2 ) ;
55 /*
56 || Created By : masehgal
57 || Created On : 11-Feb-2003
58 || Purpose : Main EFC Engine
59 || Known limitations, enhancements or remarks :
60 || Change History :
61 || Who When What
62 || (reverse chronological order - newest change first)
63 */
64
65
66 END igf_ap_efc_calc;