[Home] [Help]
83: CURSOR cur_get_fund (p_fund_id NUMBER)
84: IS
85: SELECT fcat.fed_fund_code
86: FROM igf_aw_fund_cat fcat,
87: igf_aw_fund_mast fmast
88: WHERE fcat.fund_code = fmast.fund_code
89: AND fmast.fund_id = p_fund_id;
90:
91: get_fund_rec cur_get_fund%ROWTYPE;
751: l_disb_limit1 NUMBER := 0;
752: l_disb_limit2 NUMBER := 0;
753: l_step NUMBER := 0;
754: l_accepted_amt NUMBER(12,3) := 0;
755: l_disb_round_factor igf_aw_fund_mast.disb_rounding_code%TYPE;
756:
757: TYPE l_disb_structure IS RECORD(
758: fund_id igf_aw_fund_mast.fund_id%TYPE,
759: disb_num NUMBER,
754: l_accepted_amt NUMBER(12,3) := 0;
755: l_disb_round_factor igf_aw_fund_mast.disb_rounding_code%TYPE;
756:
757: TYPE l_disb_structure IS RECORD(
758: fund_id igf_aw_fund_mast.fund_id%TYPE,
759: disb_num NUMBER,
760: disb_amt NUMBER
761: );
762: TYPE l_disb_structure_tab IS TABLE OF l_disb_structure INDEX BY BINARY_INTEGER;
766: CURSOR cur_get_fund (p_fund_id NUMBER)
767: IS
768: SELECT fcat.fed_fund_code
769: FROM igf_aw_fund_cat fcat,
770: igf_aw_fund_mast fmast
771: WHERE fcat.fund_code = fmast.fund_code
772: AND fmast.fund_id = p_fund_id;
773:
774: get_fund_rec cur_get_fund%ROWTYPE;
1045: fund.ci_sequence_number awd_sequence_number,
1046: fund.disb_verf_da,
1047: fund.show_on_bill,
1048: fund.nslds_disb_da
1049: FROM igf_aw_fund_mast fund,
1050: igf_aw_fund_cat fcat
1051: WHERE fund_id = cp_fund_id
1052: AND fund.fund_code = fcat.fund_code;
1053: l_get_fund_dtls cur_get_fund_dtls%ROWTYPE;
3140:
3141:
3142: FUNCTION check_amounts ( p_calling_form IN OUT NOCOPY VARCHAR2,
3143: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
3144: p_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,
3145: p_fund_code IN igf_aw_fund_mast_all.fund_code%TYPE,
3146: p_fed_fund_code IN igf_aw_fund_cat_all.fed_fund_code%TYPE,
3147: p_person_number IN igf_aw_award_v.person_number%TYPE,
3148: p_award_id IN igf_aw_award_all.award_id%TYPE,
3141:
3142: FUNCTION check_amounts ( p_calling_form IN OUT NOCOPY VARCHAR2,
3143: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
3144: p_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,
3145: p_fund_code IN igf_aw_fund_mast_all.fund_code%TYPE,
3146: p_fed_fund_code IN igf_aw_fund_cat_all.fed_fund_code%TYPE,
3147: p_person_number IN igf_aw_award_v.person_number%TYPE,
3148: p_award_id IN igf_aw_award_all.award_id%TYPE,
3149: p_act_isir IN VARCHAR2,
3194: --
3195: -- Gets the max amt + max terms the student got a fund in a lifetime
3196: --
3197:
3198: CURSOR cur_max_lf_count ( cp_fund_code igf_aw_fund_mast_all.fund_code%TYPE ,
3199: cp_person_id igf_ap_fa_base_rec_all.person_id%TYPE)
3200: IS
3201: SELECT
3202: NVL(SUM(NVL(disb.disb_gross_amt,0)),0) lf_total,
3203: COUNT(DISTINCT awd.award_id) lf_count
3204: FROM
3205: igf_aw_awd_disb_all disb,
3206: igf_aw_award_all awd,
3207: igf_aw_fund_mast_all fmast,
3208: igf_ap_fa_base_rec_all fabase
3209: WHERE fmast.fund_code = cp_fund_code
3210: AND disb.award_id = awd.award_id
3211: AND awd.fund_id = fmast.fund_id
3218:
3219: --
3220: -- Cursor to Aggregate Award and Count
3221: --
3222: CURSOR cur_agg_lf_count ( cp_fund_code igf_aw_fund_mast_all.fund_code%TYPE ,
3223: cp_person_id igf_ap_fa_base_rec_all.person_id%TYPE)
3224: IS
3225: SELECT NVL(SUM(NVL(awd.offered_amt,0)),0) lf_total,
3226: COUNT(awd.award_id) lf_count
3224: IS
3225: SELECT NVL(SUM(NVL(awd.offered_amt,0)),0) lf_total,
3226: COUNT(awd.award_id) lf_count
3227: FROM igf_aw_award_all awd,
3228: igf_aw_fund_mast_all fmast,
3229: igf_ap_fa_base_rec fabase,
3230: igf_ap_batch_aw_map_all bam
3231: WHERE fmast.fund_code = cp_fund_code
3232: AND awd.fund_id = fmast.fund_id
3242: -- This cursor retrives Total Award for a Fund - This is Yearly amount
3243: --
3244:
3245: CURSOR cur_total_fund_awd (p_base_id igf_aw_award.base_id%TYPE,
3246: p_fund_id igf_aw_fund_mast_all.fund_id%TYPE)
3247: IS
3248: SELECT SUM(disb.disb_gross_amt) total_fund_amt
3249: FROM
3250: igf_aw_award awd,
3273:
3274: --
3275: -- Cursor to determine if the Fund uses federal methodology or not
3276: --
3277: CURSOR cur_chk_fdl_fund (p_fund_id igf_aw_fund_mast_all.fund_id%TYPE)
3278: IS
3279: SELECT
3280: fm.replace_fc
3281: FROM
3278: IS
3279: SELECT
3280: fm.replace_fc
3281: FROM
3282: igf_aw_fund_mast fm
3283: WHERE
3284: fm.fund_id = p_fund_id;
3285:
3286: chk_fdl_fund_rec cur_chk_fdl_fund%ROWTYPE;
3284: fm.fund_id = p_fund_id;
3285:
3286: chk_fdl_fund_rec cur_chk_fdl_fund%ROWTYPE;
3287:
3288: CURSOR cur_fund_details( p_fund_id igf_aw_fund_mast.fund_id%TYPE)
3289: IS
3290: SELECT
3291: DECODE(
3292: NVL(allow_overaward,'N'),'N',
3307: fmast.min_award_amt,
3308: fmast.max_num_disb,
3309: fmast.min_num_disb
3310: FROM
3311: igf_aw_fund_mast_all fmast
3312: WHERE
3313: fmast.fund_id = p_fund_id;
3314:
3315: fund_details_rec cur_fund_details%ROWTYPE;
3874: --
3875: -- Procedure to update show_on_bill flag based on the fund manager value
3876: --
3877: PROCEDURE update_bill_flag ( p_fund_id IN igf_aw_award_all.fund_id%TYPE,
3878: p_new_val IN igf_aw_fund_mast_all.show_on_bill%TYPE)
3879: IS
3880:
3881: --
3882: -- Cursor to get awards of the fund
3893: --
3894: -- Cursor to get Planned Disbursements for the award
3895: --
3896: CURSOR cur_get_adisb ( p_award_id IN igf_aw_award_all.award_id%TYPE,
3897: p_new_val IN igf_aw_fund_mast_all.show_on_bill%TYPE)
3898: IS
3899: SELECT *
3900: FROM
3901: igf_aw_awd_disb
4098: p_award_id NUMBER
4099: ) IS
4100: SELECT fcat.fed_fund_code
4101: FROM igf_aw_fund_cat fcat,
4102: igf_aw_fund_mast fmast,
4103: igf_aw_award_all awd
4104: WHERE fcat.fund_code = fmast.fund_code
4105: AND fmast.fund_id = awd.fund_id
4106: AND awd.award_id = p_award_id;