[Home] [Help]
86: IS
87: SELECT fed_fund_code
88: FROM igf_aw_award awd,
89: igf_aw_fund_mast fundmast,
90: igf_aw_fund_cat fundcat
91: WHERE awd.award_id = cp_award_id
92: AND awd.fund_id = fundmast.fund_id
93: AND fundmast.fund_code = fundcat.fund_code;
94:
91: WHERE awd.award_id = cp_award_id
92: AND awd.fund_id = fundmast.fund_id
93: AND fundmast.fund_code = fundcat.fund_code;
94:
95: FUNCTION get_cl_hold_rel_ind(p_fed_fund_code igf_aw_fund_cat.fed_fund_code%TYPE,
96: p_ci_cal_type igs_ca_inst.cal_type%TYPE,
97: p_ci_seq_num igs_ca_inst.sequence_number%TYPE,
98: p_base_id igf_aw_award_all.base_id%TYPE,
99: p_alt_rel_code igf_aw_fund_cat_all.alt_rel_code%TYPE)
95: FUNCTION get_cl_hold_rel_ind(p_fed_fund_code igf_aw_fund_cat.fed_fund_code%TYPE,
96: p_ci_cal_type igs_ca_inst.cal_type%TYPE,
97: p_ci_seq_num igs_ca_inst.sequence_number%TYPE,
98: p_base_id igf_aw_award_all.base_id%TYPE,
99: p_alt_rel_code igf_aw_fund_cat_all.alt_rel_code%TYPE)
100: RETURN VARCHAR2
101: AS
102: /*************************************************************
103: Created By : venagara
163:
164: END get_cl_hold_rel_ind;
165:
166: -- Created as part of FA 122 Loans Enhancements
167: FUNCTION get_cl_auto_late_ind(p_fed_fund_code igf_aw_fund_cat.fed_fund_code%TYPE,
168: p_ci_cal_type igs_ca_inst.cal_type%TYPE,
169: p_ci_seq_num igs_ca_inst.sequence_number%TYPE,
170: p_base_id igf_aw_award_all.base_id%TYPE,
171: p_alt_rel_code igf_aw_fund_cat_all.alt_rel_code%TYPE)
167: FUNCTION get_cl_auto_late_ind(p_fed_fund_code igf_aw_fund_cat.fed_fund_code%TYPE,
168: p_ci_cal_type igs_ca_inst.cal_type%TYPE,
169: p_ci_seq_num igs_ca_inst.sequence_number%TYPE,
170: p_base_id igf_aw_award_all.base_id%TYPE,
171: p_alt_rel_code igf_aw_fund_cat_all.alt_rel_code%TYPE)
172: RETURN VARCHAR2
173: AS
174: /*************************************************************
175: Created By : bkkumar
240: app_exception.raise_exception;
241:
242: END get_cl_auto_late_ind;
243:
244: FUNCTION get_loan_fee1(p_fed_fund_code igf_aw_fund_cat.fed_fund_code%TYPE,
245: p_ci_cal_type igs_ca_inst.cal_type%TYPE,
246: p_ci_seq_num igs_ca_inst.sequence_number%TYPE,
247: p_base_id igf_aw_award_all.base_id%TYPE,
248: p_rel_code VARCHAR2,
245: p_ci_cal_type igs_ca_inst.cal_type%TYPE,
246: p_ci_seq_num igs_ca_inst.sequence_number%TYPE,
247: p_base_id igf_aw_award_all.base_id%TYPE,
248: p_rel_code VARCHAR2,
249: p_alt_rel_code igf_aw_fund_cat_all.alt_rel_code%TYPE)
250: RETURN NUMBER
251: AS
252: /*************************************************************
253: Created By : venagara
375: END get_loan_fee1;
376:
377:
378:
379: FUNCTION get_loan_fee2(p_fed_fund_code igf_aw_fund_cat.fed_fund_code%TYPE,
380: p_ci_cal_type igs_ca_inst.cal_type%TYPE,
381: p_ci_seq_num igs_ca_inst.sequence_number%TYPE,
382: p_base_id igf_aw_award_all.base_id%TYPE,
383: p_rel_code VARCHAR2,
380: p_ci_cal_type igs_ca_inst.cal_type%TYPE,
381: p_ci_seq_num igs_ca_inst.sequence_number%TYPE,
382: p_base_id igf_aw_award_all.base_id%TYPE,
383: p_rel_code VARCHAR2,
384: p_alt_rel_code igf_aw_fund_cat_all.alt_rel_code%TYPE)
385: RETURN NUMBER
386: AS
387: /*************************************************************
388: Created By : venagara
534:
535: END chk_disb_date;
536:
537: -- FACR116 This function returns the alt_rel_code for the passed fund_Code.
538: FUNCTION get_alt_rel_code(p_fund_code igf_aw_fund_cat_all.fund_code%TYPE)
539: RETURN VARCHAR2
540: AS
541: l_alt_rel_code igf_aw_fund_cat_all.alt_rel_code%TYPE;
542:
537: -- FACR116 This function returns the alt_rel_code for the passed fund_Code.
538: FUNCTION get_alt_rel_code(p_fund_code igf_aw_fund_cat_all.fund_code%TYPE)
539: RETURN VARCHAR2
540: AS
541: l_alt_rel_code igf_aw_fund_cat_all.alt_rel_code%TYPE;
542:
543: CURSOR c_rel_code (cp_fund_code igf_aw_fund_cat_all.fund_code%TYPE)
544: IS
545: SELECT alt_rel_code
539: RETURN VARCHAR2
540: AS
541: l_alt_rel_code igf_aw_fund_cat_all.alt_rel_code%TYPE;
542:
543: CURSOR c_rel_code (cp_fund_code igf_aw_fund_cat_all.fund_code%TYPE)
544: IS
545: SELECT alt_rel_code
546: FROM igf_aw_fund_cat_all
547: WHERE fund_code = cp_fund_code;
542:
543: CURSOR c_rel_code (cp_fund_code igf_aw_fund_cat_all.fund_code%TYPE)
544: IS
545: SELECT alt_rel_code
546: FROM igf_aw_fund_cat_all
547: WHERE fund_code = cp_fund_code;
548:
549: BEGIN
550:
660: END chk_loan_upd_lock;
661:
662: PROCEDURE get_loan_amts(p_ci_cal_type IN igs_ca_inst_all.cal_type%TYPE,
663: p_ci_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
664: p_fed_fund_code IN igf_aw_fund_cat_all.fed_fund_code%TYPE,
665: p_gross_amt IN igf_aw_awd_disb_all.disb_gross_amt%TYPE,
666: p_rebate_amt OUT NOCOPY igf_aw_awd_disb_all.int_rebate_amt%TYPE,
667: p_loan_fee_amt OUT NOCOPY igf_aw_awd_disb_all.fee_1%TYPE,
668: p_net_amt OUT NOCOPY igf_aw_awd_disb_all.disb_net_amt%TYPE)
774: fcat.alt_rel_code alt_rel_code
775: from
776: igf_aw_award_all awd,
777: igf_aw_fund_mast_all fmast,
778: igf_aw_fund_cat_all fcat
779: where
780: awd.fund_id = fmast.fund_id
781: and fmast.fund_code = fcat.fund_code
782: and awd.award_id = cp_award_id ;
786: l_get_fed_fund_code c_get_fed_fund_code%ROWTYPE;
787: l_fee1 igf_aw_awd_disb.fee_1%TYPE;
788: l_fee2 igf_aw_awd_disb.fee_2%TYPE;
789: l_net_amt igf_aw_awd_disb.disb_net_amt%TYPE;
790: l_alt_rel_code igf_aw_fund_cat_all.alt_rel_code%TYPE;
791: BEGIN
792:
793: l_rel_code := NULL;
794: l_party_id := NULL;
923: p_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
924: p_rel_code OUT NOCOPY igf_sl_cl_setup.relationship_cd%TYPE,
925: p_person_id OUT NOCOPY igf_sl_cl_pref_lenders.person_id%TYPE,
926: p_party_id OUT NOCOPY igf_sl_cl_setup.party_id%TYPE, -- this is used in FA 126
927: p_alt_rel_code IN igf_aw_fund_cat_all.alt_rel_code%TYPE )
928: IS
929: /*************************************************************
930: Created By : bkkumar
931: Date Created On : 05-Sep-2003