1 PACKAGE IGF_GR_PELL AS
2 /* $Header: IGFGR01S.pls 120.0 2005/06/01 14:13:42 appldev noship $ */
3
4 --
5 -- History :
6 -- who when what
7 ------------------------------------------------------------------------
8 -- bkkumar 23-july-04 Bug 3773300 Added the function get_enrollment_date
9 -- ugummall 09-DEC-2003. Bug 3252832. FA 131 - COD Updates.
10 -- Removed the procedure pell_calc.
11 -- sjalasut 7 Nov 03 Changed the variable name l_rep_pell_id to
12 -- l_attend_pell_id as part of FA126 Build.
13 -- rasahoo 27-Aug-2003 Changed the signature of procedure RFMS_LOAD.
14 -- Removed the parameter P_GET_RECENT_INFO
15 -- as part of obsoletion of FA base record history
16 -- Bug 2613546,2606001
17 -- sjadhav
18 -- FA 105 108 Build
19 -- added l_pell_mat spec variable
20 --
21 --
22 -- Bug : 2216956
23 -- sjadhav , Removed Run Type param
24 --
25 -- Bug ID : 1818617
26 -- sjadhav 24-jul-2001 added parameter p_get_recent_info
27 --
28 -- Bug Id : 1867738
29 -- avenkatr 06-SEP-2001 Added the proceudre "Generate_Origination_Id" to take care of
30 -- cases when the student does not have the ISIR record or when either
31 -- of SSN, Start dt of Award Year or Reporting Pell Id is NULL
32 -- when generating the Origination Id
33 ------------------------------------------------------------------------
34 --
35
36 -- Creation of RFMS records id done in this procedure
37
38 -- Parameters
39 -- l_run_type --> S ( run for single student ) / Y ( run for a year )
40 -- l_award_year --> concatinated cal_type + sequence_number
41 -- l_base_id --> Student base ID
42
43
44 PROCEDURE Rfms_load( errbuf OUT NOCOPY VARCHAR,
45 retcode OUT NOCOPY NUMBER,
46 l_award_year IN VARCHAR2,
47 l_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
48 p_org_id IN NUMBER );
49
50
51 PROCEDURE Generate_Origination_Id( l_base_id IN NUMBER,
52 l_attend_pell_id IN VARCHAR2,
53 l_origination_id OUT NOCOPY VARCHAR2,
54 l_error OUT NOCOPY VARCHAR2);
55
56 FUNCTION get_enrollment_date(p_award_id igf_aw_award_all.award_id%TYPE)
57 RETURN DATE;
58 -- The calculation of Pell amount is done in this package
59 --
60 -- Pre-requisites
61 -- The following tables have to be populated before calling this process
62 -- igf_fa_base_rec
63 -- igf_aw_fund_mast
64 -- igf_gr_pell_setup
65 --
66 -- The pell calculation routine can only be called from the Packaging package
67 --
68
69
70 --
71 -- Bug 2460904
72 -- Re Calculate Pell Shcedule Ammount when this routine is
73 -- called from Origination form
74 --
75 -- Added parameters
76 -- 1. l_enrl_stat
77 -- 2. l_pell_coa
78 --
79
80 --
81 -- Bug 2613546,2606001
82 -- Added l_pell_mat parameter. This will denote
83 -- if regular or alternate pell matrix is used to
84 -- calculate pell award
85 --
86 --
87
88 END IGF_GR_PELL;