[Home] [Help]
PACKAGE: APPS.IGF_SL_AWARD
Source
1 PACKAGE igf_sl_award AS
2 /* $Header: IGFSL13S.pls 120.0 2005/06/01 15:39:23 appldev noship $ */
3
4 /*************************************************************
5 Created By : venagara
6 Date Created On : 2000/12/12
7 Purpose :
8 Know limitations, enhancements or remarks
9 Change History
10 Who When What
11 -----------------------------------------------------------------------------------
12 -- mnade 8-Feb-2005 Bug 4127250 chk_disb_date call changed to pass the dates being set
13 -- for checking if that is covering all the disbursements.
14 ----------------------------------------------------------------------------------------
15 -- bkkumar 05-04-04 FACR116 - Added p_alt_rel_code as paramter and added
16 -- new function get_alt_rel_code()
17 -- bkkumar 07-oct-2003 Bug 3104228 removed the select_org procedure.
18 -- bkkumar Sep 30,2003 FA 122 Loan Enhancents
19 -- Added new function get_cl_auto_late_ind,
20 -- pick_setup and changed get_loan_fee1,get_loan_fee2,
21 get_cl_hold_rel_ind, recalc_fees
22 -----------------------------------------------------------------------------------
23
24 (reverse chronological order - newest change first)
25 ***************************************************************/
26
27 g_base_id igf_aw_award_all.base_id%TYPE;
28 g_rel_code igf_sl_cl_setup.relationship_cd%TYPE;
29 g_person_id igf_sl_cl_pref_lenders.person_id%TYPE;
30 g_party_id igf_sl_cl_setup.party_id%TYPE;
31
32 PROCEDURE get_loan_amts(p_ci_cal_type IN igs_ca_inst_all.cal_type%TYPE,
33 p_ci_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
34 p_fed_fund_code IN igf_aw_fund_cat_all.fed_fund_code%TYPE,
35 p_gross_amt IN igf_aw_awd_disb_all.disb_gross_amt%TYPE,
36 p_rebate_amt OUT NOCOPY igf_aw_awd_disb_all.int_rebate_amt%TYPE,
37 p_loan_fee_amt OUT NOCOPY igf_aw_awd_disb_all.fee_1%TYPE,
38 p_net_amt OUT NOCOPY igf_aw_awd_disb_all.disb_net_amt%TYPE);
39 -----------------------------------------------------------------------------------
40 --
41 -- sjadhav, Jan 23,2002
42 -- This procedure calculates loan fee amount, interest rebate amount
43 -- combined fee int rebate anount and disb net amonut for Direct Loans
44 --
45 -----------------------------------------------------------------------------------
46 PROCEDURE pick_setup(
47 p_base_id IN igf_aw_award_all.base_id%TYPE,
48 p_cal_type IN igs_ca_inst_all.cal_type%TYPE,
49 p_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
50 p_rel_code OUT NOCOPY igf_sl_cl_setup.relationship_cd%TYPE,
51 p_person_id OUT NOCOPY igf_sl_cl_pref_lenders.person_id%TYPE,
52 p_party_id OUT NOCOPY igf_sl_cl_setup.party_id%TYPE,
53 p_alt_rel_code IN igf_aw_fund_cat_all.alt_rel_code%TYPE DEFAULT NULL
54 );
55
56 FUNCTION get_loan_fee1(p_fed_fund_code igf_aw_fund_cat.fed_fund_code%TYPE,
57 p_ci_cal_type igs_ca_inst.cal_type%TYPE,
58 p_ci_seq_num igs_ca_inst.sequence_number%TYPE,
59 p_base_id igf_aw_award_all.base_id%TYPE DEFAULT NULL,
60 p_rel_code VARCHAR2 DEFAULT NULL,
61 p_alt_rel_code igf_aw_fund_cat_all.alt_rel_code%TYPE DEFAULT NULL)
62 RETURN NUMBER;
63
64 FUNCTION get_loan_fee2(p_fed_fund_code igf_aw_fund_cat.fed_fund_code%TYPE,
65 p_ci_cal_type igs_ca_inst.cal_type%TYPE,
66 p_ci_seq_num igs_ca_inst.sequence_number%TYPE,
67 p_base_id igf_aw_award_all.base_id%TYPE DEFAULT NULL,
68 p_rel_code VARCHAR2 DEFAULT NULL,
69 p_alt_rel_code igf_aw_fund_cat_all.alt_rel_code%TYPE DEFAULT NULL)
70 RETURN NUMBER;
71
72 FUNCTION get_cl_hold_rel_ind(p_fed_fund_code igf_aw_fund_cat.fed_fund_code%TYPE,
73 p_ci_cal_type igs_ca_inst.cal_type%TYPE,
74 p_ci_seq_num igs_ca_inst.sequence_number%TYPE,
75 p_base_id igf_aw_award_all.base_id%TYPE DEFAULT NULL,
76 p_alt_rel_code igf_aw_fund_cat_all.alt_rel_code%TYPE DEFAULT NULL)
77 RETURN VARCHAR2;
78 FUNCTION get_cl_auto_late_ind(p_fed_fund_code igf_aw_fund_cat.fed_fund_code%TYPE,
79 p_ci_cal_type igs_ca_inst.cal_type%TYPE,
80 p_ci_seq_num igs_ca_inst.sequence_number%TYPE,
81 p_base_id igf_aw_award_all.base_id%TYPE DEFAULT NULL,
82 p_alt_rel_code igf_aw_fund_cat_all.alt_rel_code%TYPE DEFAULT NULL)
83 RETURN VARCHAR2;
84
85
86 FUNCTION chk_disb_date(p_award_id igf_sl_loans.award_id%TYPE,
87 p_loan_per_begin_date igf_sl_loans_all.loan_per_begin_date%TYPE DEFAULT NULL,
88 p_loan_per_end_date igf_sl_loans_all.loan_per_end_date%TYPE DEFAULT NULL)
89 RETURN VARCHAR2;
90
91 FUNCTION chk_loan_upd_lock(p_award_id igf_sl_loans.award_id%TYPE)
92 RETURN VARCHAR2;
93 FUNCTION get_alt_rel_code(p_fund_code igf_aw_fund_cat_all.fund_code%TYPE)
94 RETURN VARCHAR2;
95
96 PROCEDURE recalc_fees(
97 p_base_id IN igf_aw_award_all.base_id%TYPE,
98 p_cal_type IN igs_ca_inst_all.cal_type%TYPE,
99 p_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
100 p_rel_code IN igf_sl_cl_setup.relationship_cd%TYPE,
101 p_award_id IN igf_sl_loans.award_id%TYPE
102 );
103
104
105 FUNCTION chk_chg_enable (p_n_award_id igf_aw_award_all.award_id%TYPE)
106 RETURN BOOLEAN;
107
108 FUNCTION chk_add_new_disb (p_n_award_id igf_aw_award_all.award_id%TYPE)
109 RETURN BOOLEAN;
110
111 FUNCTION chk_loan_increase (p_n_award_id igf_aw_award_all.award_id%TYPE)
112 RETURN BOOLEAN;
113
114 FUNCTION get_loan_cl_version (p_n_award_id igf_aw_award_all.award_id%TYPE)
115 RETURN igf_sl_cl_setup_all.cl_version%TYPE;
116
117 FUNCTION chk_fund_st_chg ( p_n_award_id IN igf_aw_award_all.award_id%TYPE,
118 p_n_disb_num IN igf_aw_awd_disb_all.disb_num%TYPE
119 )
120 RETURN BOOLEAN;
121
122 END igf_sl_award;