[Home] [Help]
98: RETURN get_fund_rec.fed_fund_code;
99:
100: END get_fed_fund_code;
101:
102: FUNCTION isRepackaging(p_award_id IN igf_aw_award_all.award_id%TYPE)
103: RETURN BOOLEAN
104: IS
105: ------------------------------------------------------------------
106: -- Created by : museshad
114: -- Change History:
115: -------------------------------------------------------------------
116: -- Who When What
117: ------------------------------------------------------------------
118: CURSOR c_chk_repkg(cp_award_id IN igf_aw_award_all.award_id%TYPE)
119: IS
120: SELECT 'X'
121: FROM igf_aw_awd_disb_all
122: WHERE award_id = cp_award_id;
135: END IF;
136: END isRepackaging;
137:
138: PROCEDURE cancel_extra_disb (
139: p_award_id IN igf_aw_award.award_id%TYPE,
140: p_disb_num IN igf_aw_awd_disb_all.disb_num%TYPE
141: )
142: IS
143: /*
153: */
154:
155: -- Get all disbursements more than cp_disb_num in the award
156: CURSOR c_disb_cancel(
157: cp_award_id igf_aw_award_all.award_id%TYPE,
158: cp_disb_num igf_aw_awd_disb_all.disb_num%TYPE
159: )
160: IS
161: SELECT *
256: -------------------------------------------------------------------
257: --
258:
259: CURSOR cur_get_fed_fund_code(
260: cp_award_id igf_aw_award_all.award_id%TYPE
261: ) IS
262: SELECT fed_fund_code,ci_cal_type,ci_sequence_number
263: FROM igf_aw_award_v
264: WHERE award_id = cp_award_id;
259: CURSOR cur_get_fed_fund_code(
260: cp_award_id igf_aw_award_all.award_id%TYPE
261: ) IS
262: SELECT fed_fund_code,ci_cal_type,ci_sequence_number
263: FROM igf_aw_award_v
264: WHERE award_id = cp_award_id;
265: l_get_fed_fund_code cur_get_fed_fund_code%ROWTYPE;
266:
267: CURSOR c_disb(
264: WHERE award_id = cp_award_id;
265: l_get_fed_fund_code cur_get_fed_fund_code%ROWTYPE;
266:
267: CURSOR c_disb(
268: cp_award_id igf_aw_award_all.award_id%TYPE,
269: cp_disb_num igf_aw_awd_disb_all.disb_num%TYPE
270: ) IS
271: SELECT rowid row_id,
272: disb.*
705:
706: END updating_coa_in_fa_base;
707:
708: PROCEDURE round_off_disbursements(
709: p_fund_id IN igf_aw_award_t_all.fund_id%TYPE,
710: p_award_id IN igf_aw_award_t_all.award_id%TYPE,
711: p_offered_amt IN igf_aw_award_t_all.offered_amt%TYPE,
712: p_award_status IN igf_aw_award_all.award_status%TYPE,
713: p_dist_plan_code IN igf_aw_awd_dist_plans.dist_plan_method_code%TYPE,
706: END updating_coa_in_fa_base;
707:
708: PROCEDURE round_off_disbursements(
709: p_fund_id IN igf_aw_award_t_all.fund_id%TYPE,
710: p_award_id IN igf_aw_award_t_all.award_id%TYPE,
711: p_offered_amt IN igf_aw_award_t_all.offered_amt%TYPE,
712: p_award_status IN igf_aw_award_all.award_status%TYPE,
713: p_dist_plan_code IN igf_aw_awd_dist_plans.dist_plan_method_code%TYPE,
714: p_disb_count IN NUMBER
707:
708: PROCEDURE round_off_disbursements(
709: p_fund_id IN igf_aw_award_t_all.fund_id%TYPE,
710: p_award_id IN igf_aw_award_t_all.award_id%TYPE,
711: p_offered_amt IN igf_aw_award_t_all.offered_amt%TYPE,
712: p_award_status IN igf_aw_award_all.award_status%TYPE,
713: p_dist_plan_code IN igf_aw_awd_dist_plans.dist_plan_method_code%TYPE,
714: p_disb_count IN NUMBER
715: )
708: PROCEDURE round_off_disbursements(
709: p_fund_id IN igf_aw_award_t_all.fund_id%TYPE,
710: p_award_id IN igf_aw_award_t_all.award_id%TYPE,
711: p_offered_amt IN igf_aw_award_t_all.offered_amt%TYPE,
712: p_award_status IN igf_aw_award_all.award_status%TYPE,
713: p_dist_plan_code IN igf_aw_awd_dist_plans.dist_plan_method_code%TYPE,
714: p_disb_count IN NUMBER
715: )
716: IS
729: */
730:
731: -- Returns all the disbursements for an award
732: -- The ORDER BY clause ensures that the disbursements are returned in the order of their creation
733: CURSOR cur_get_all_disb (p_award_id igf_aw_award_all.award_id%TYPE)
734: IS
735: SELECT disb.rowid, disb.*
736: FROM igf_aw_awd_disb disb
737: WHERE
996: END IF; -- End of Disbursement existence check
997: END LOOP; -- End of Get all disbursements loop
998: END round_off_disbursements;
999:
1000: PROCEDURE create_auto_disb( p_fund_id IN igf_aw_award.fund_id%TYPE,
1001: p_award_id IN igf_aw_award.award_id%TYPE,
1002: p_offered_amt IN igf_aw_award.offered_amt%TYPE,
1003: p_award_status IN igf_aw_award.award_status%TYPE,
1004: p_adplans_id IN igf_aw_awd_dist_plans.adplans_id%TYPE,
997: END LOOP; -- End of Get all disbursements loop
998: END round_off_disbursements;
999:
1000: PROCEDURE create_auto_disb( p_fund_id IN igf_aw_award.fund_id%TYPE,
1001: p_award_id IN igf_aw_award.award_id%TYPE,
1002: p_offered_amt IN igf_aw_award.offered_amt%TYPE,
1003: p_award_status IN igf_aw_award.award_status%TYPE,
1004: p_adplans_id IN igf_aw_awd_dist_plans.adplans_id%TYPE,
1005: p_method_code IN igf_aw_awd_dist_plans.dist_plan_method_code%TYPE,
998: END round_off_disbursements;
999:
1000: PROCEDURE create_auto_disb( p_fund_id IN igf_aw_award.fund_id%TYPE,
1001: p_award_id IN igf_aw_award.award_id%TYPE,
1002: p_offered_amt IN igf_aw_award.offered_amt%TYPE,
1003: p_award_status IN igf_aw_award.award_status%TYPE,
1004: p_adplans_id IN igf_aw_awd_dist_plans.adplans_id%TYPE,
1005: p_method_code IN igf_aw_awd_dist_plans.dist_plan_method_code%TYPE,
1006: p_awd_prd_code IN igf_aw_awd_prd_term.award_prd_cd%TYPE
999:
1000: PROCEDURE create_auto_disb( p_fund_id IN igf_aw_award.fund_id%TYPE,
1001: p_award_id IN igf_aw_award.award_id%TYPE,
1002: p_offered_amt IN igf_aw_award.offered_amt%TYPE,
1003: p_award_status IN igf_aw_award.award_status%TYPE,
1004: p_adplans_id IN igf_aw_awd_dist_plans.adplans_id%TYPE,
1005: p_method_code IN igf_aw_awd_dist_plans.dist_plan_method_code%TYPE,
1006: p_awd_prd_code IN igf_aw_awd_prd_term.award_prd_cd%TYPE
1007: )
1035: */
1036:
1037: --cursor to get fund details
1038: CURSOR cur_get_fund_dtls(
1039: cp_fund_id igf_aw_award.fund_id%TYPE
1040: ) IS
1041: SELECT fcat.fund_code,
1042: fcat.fed_fund_code,
1043: fund.disb_exp_da,
1509: AND aprd.ld_sequence_number = terms.ld_sequence_number;
1510:
1511: -- Get a specific disbursment for an award
1512: CURSOR c_disb(
1513: cp_award_id igf_aw_award_all.award_id%TYPE,
1514: cp_disb_num igf_aw_awd_disb_all.disb_num%TYPE
1515: ) IS
1516: SELECT rowid row_id,
1517: disb.*
1520: AND disb_num = cp_disb_num;
1521:
1522: l_disb c_disb%ROWTYPE;
1523:
1524: CURSOR cur_get_base ( p_award_id igf_aw_award_all.award_id%TYPE) IS
1525: SELECT base_id
1526: FROM igf_aw_award_all
1527: WHERE award_id = p_award_id;
1528:
1522: l_disb c_disb%ROWTYPE;
1523:
1524: CURSOR cur_get_base ( p_award_id igf_aw_award_all.award_id%TYPE) IS
1525: SELECT base_id
1526: FROM igf_aw_award_all
1527: WHERE award_id = p_award_id;
1528:
1529: get_base_rec cur_get_base%ROWTYPE;
1530:
2429:
2430: END create_auto_disb;
2431:
2432:
2433: PROCEDURE remove_awd_rules_override(p_award_id IN igf_aw_award.award_id%TYPE)
2434: AS
2435: /*
2436: || Created By : brajendr
2437: || Created On :
2447:
2448: --
2449: -- Get the details of Disbursement Holds for a given award if any holds exists
2450: --
2451: CURSOR c_chk_sys_disb_holds(p_award_id igf_aw_award.award_id%TYPE)
2452: IS
2453: SELECT 'x'
2454: FROM igf_db_disb_holds dh
2455: WHERE dh.award_id = p_award_id
2459:
2460: --
2461: -- Get the details of the award for updating the override rules.
2462: --
2463: CURSOR c_get_awd_dtls(p_award_id igf_aw_award.award_id%TYPE)
2464: IS
2465: SELECT awd.*
2466: FROM igf_aw_award awd
2467: WHERE awd.award_id = p_award_id;
2462: --
2463: CURSOR c_get_awd_dtls(p_award_id igf_aw_award.award_id%TYPE)
2464: IS
2465: SELECT awd.*
2466: FROM igf_aw_award awd
2467: WHERE awd.award_id = p_award_id;
2468:
2469: lc_get_awd_dtls c_get_awd_dtls%ROWTYPE;
2470: lc_chk_sys_disb_holds c_chk_sys_disb_holds%ROWTYPE;
2481: OPEN c_get_awd_dtls( p_award_id);
2482: FETCH c_get_awd_dtls INTO lc_get_awd_dtls;
2483: CLOSE c_get_awd_dtls;
2484:
2485: igf_aw_award_pkg.update_row(
2486: x_mode => 'R',
2487: x_rowid => lc_get_awd_dtls.row_id,
2488: x_award_id => lc_get_awd_dtls.award_id,
2489: x_fund_id => lc_get_awd_dtls.fund_id,
2540: app_exception.raise_exception;
2541:
2542: END remove_awd_rules_override;
2543:
2544: FUNCTION place_ovawd_holds (p_award_id igf_aw_award.award_id%TYPE,
2545: p_disb_num igf_aw_awd_disb.disb_num%TYPE)
2546:
2547: RETURN BOOLEAN
2548: IS
2551: -- Get the details of disbursement hold for the given disbursement if present
2552: -- If this function returns TRUE, it means new overaward hold
2553: -- can be placed
2554: --
2555: CURSOR cur_chk_holds( p_award_id igf_aw_award.award_id%TYPE,
2556: p_disb_num igf_aw_awd_disb.disb_num%TYPE) IS
2557: SELECT dh.release_flag
2558: FROM igf_db_disb_holds dh
2559: WHERE dh.award_id = p_award_id
2593: END place_ovawd_holds;
2594:
2595:
2596: PROCEDURE create_over_awd_holds(
2597: p_award_id IN igf_aw_award.award_id%TYPE
2598: ) AS
2599: /*
2600: || Created By : brajendr
2601: || Created On :
2610: */
2611:
2612: -- Get the details of all planned disbursements of the given award.
2613: CURSOR c_get_planned_awd_disb(
2614: p_award_id igf_aw_award.award_id%TYPE
2615: ) IS
2616: SELECT disb.award_id, disb.disb_num
2617: FROM igf_aw_awd_disb disb
2618: WHERE disb.award_id = p_award_id
2679: app_exception.raise_exception;
2680:
2681: END create_over_awd_holds;
2682:
2683: PROCEDURE update_accept_amount (p_award_id IN igf_aw_award.award_id%TYPE )
2684: IS
2685:
2686: /*
2687: -----------------------------------------------------------------------------
2787: app_exception.raise_exception;
2788:
2789: END update_accept_amount;
2790:
2791: PROCEDURE update_awd_cancell_to_offer(p_award_id IN igf_aw_award.award_id%TYPE,
2792: p_award_stat IN VARCHAR2,
2793: p_fed_fund_code IN VARCHAR2,
2794: p_base_id IN NUMBER,
2795: p_message OUT NOCOPY VARCHAR2)
2826: disb.ld_sequence_number,
2827: disb.base_attendance_type_code,
2828: SUM(disb.disb_gross_amt) term_total
2829: FROM igf_aw_awd_disb_all disb,
2830: igf_aw_award_all awd
2831: WHERE awd.award_id = disb.award_id
2832: AND awd.award_id = p_award_id
2833: GROUP BY disb.ld_cal_type,disb.ld_sequence_number,disb.base_attendance_type_code;
2834:
3019:
3020: END update_awd_cancell_to_offer;
3021:
3022:
3023: FUNCTION check_disbdts ( p_award_id IN igf_aw_award_all.award_id%TYPE,
3024: p_ld_seq_number IN NUMBER)
3025: RETURN VARCHAR2
3026: IS
3027:
3041: -- sjadhav
3042: -- Bug 2387496
3043: -- Added new function to check dates
3044:
3045: CURSOR cur_disb_num ( p_award_id igf_aw_award_all.award_id%TYPE) IS
3046: SELECT disb_num,disb_date,trans_type
3047: FROM
3048: igf_aw_awd_disb_all
3049: WHERE
3054: disb_num;
3055:
3056: disb_num_rec cur_disb_num%ROWTYPE;
3057:
3058: CURSOR cur_disb_dat ( p_award_id igf_aw_award_all.award_id%TYPE) IS
3059: SELECT disb_num,disb_date
3060: FROM
3061: igf_aw_awd_disb
3062: WHERE
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,
3150: p_ld_seq_number IN NUMBER,
3151: p_awd_prd_code IN igf_aw_awd_prd_term.award_prd_cd%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,
3150: p_ld_seq_number IN NUMBER,
3151: p_awd_prd_code IN igf_aw_awd_prd_term.award_prd_cd%TYPE,
3152: p_chk_holds OUT NOCOPY VARCHAR2)
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
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
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
3241: --
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
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,
3251: igf_aw_awd_disb disb
3252: WHERE awd.base_id = p_base_id
3253: AND awd.fund_id = p_fund_id
3254: AND awd.award_id = disb.award_id
3258: total_fund_awd_rec cur_total_fund_awd%ROWTYPE;
3259: --
3260: -- This cursor retrives Total Amount for a Award -
3261: --
3262: CURSOR cur_total_award_amt (p_award_id igf_aw_award_all.award_id%TYPE)
3263: IS
3264: SELECT
3265: SUM(disb.disb_gross_amt) total_award_amt
3266: FROM
3317:
3318: --
3319: -- Cursor to get total disbursements for award
3320: --
3321: CURSOR cur_get_count ( p_award_id igf_aw_award_all.award_id%TYPE)
3322: IS
3323: SELECT
3324: COUNT(ld_cal_type) disb_count
3325: FROM igf_aw_awd_disb
3326: WHERE
3327: award_id = p_award_id;
3328:
3329:
3330: CURSOR cur_disb_num ( p_award_id igf_aw_award_all.award_id%TYPE) IS
3331: SELECT disb_num,disb_date,trans_type,disb_accepted_amt accepted_amt
3332: FROM
3333: igf_aw_awd_disb_all
3334: WHERE
3341: IS
3342: SELECT
3343: *
3344: FROM
3345: igf_aw_award
3346: WHERE
3347: award_id = p_award_id ;
3348:
3349: c_award_status_rec c_award_status%ROWTYPE;
3358: disb.ld_sequence_number,
3359: disb.base_attendance_type_code,
3360: SUM(disb.disb_gross_amt) term_total
3361: FROM igf_aw_awd_disb_all disb,
3362: igf_aw_award_all awd
3363: WHERE disb.trans_type <> 'C'
3364: AND awd.award_id = disb.award_id
3365: AND awd.award_id = p_award_id
3366: AND disb.ld_sequence_number = p_ld_seq_number
3581: END IF;
3582: END LOOP;
3583: --
3584: -- if the pell matrix changes for calculation
3585: -- we need to update igf_aw_award with the new value for lv_pell_mat
3586: --
3587: IF lv_pell_mat <> c_award_status_rec.alt_pell_schedule THEN
3588:
3589: c_award_status_rec.alt_pell_schedule := lv_pell_mat;
3587: IF lv_pell_mat <> c_award_status_rec.alt_pell_schedule THEN
3588:
3589: c_award_status_rec.alt_pell_schedule := lv_pell_mat;
3590:
3591: igf_aw_award_pkg.update_row(x_rowid => c_award_status_rec.row_id,
3592: x_award_id => c_award_status_rec.award_id,
3593: x_fund_id => c_award_status_rec.fund_id,
3594: x_base_id => c_award_status_rec.base_id,
3595: x_offered_amt => c_award_status_rec.offered_amt,
3873: -- Bug 2306310
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: --
3880:
3881: --
3882: -- Cursor to get awards of the fund
3883: --
3884: CURSOR cur_get_awd ( p_fund_id IN igf_aw_award_all.fund_id%TYPE )
3885: IS
3886: SELECT award_id
3887: FROM
3888: igf_aw_award
3884: CURSOR cur_get_awd ( p_fund_id IN igf_aw_award_all.fund_id%TYPE )
3885: IS
3886: SELECT award_id
3887: FROM
3888: igf_aw_award
3889: WHERE
3890: fund_id = p_fund_id;
3891:
3892:
3892:
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
3983:
3984: END update_bill_flag;
3985:
3986:
3987: FUNCTION delete_awd_disb ( p_award_id IN igf_aw_award_all.award_id%TYPE ,
3988: p_ld_seq_num IN igf_aw_awd_disb_all.ld_sequence_number%TYPE ,
3989: p_disb_num IN igf_aw_awd_disb_all.disb_num%TYPE )
3990: RETURN VARCHAR2
3991: IS
4005: --------------------------------------------------------------------------------------------
4006: --
4007: -- check if award has pell or loan record
4008: --
4009: CURSOR cur_pell_awd (p_award_id igf_aw_award_all.award_id%TYPE)
4010: IS
4011: SELECT
4012: COUNT(origination_id) awd_count
4013: FROM
4016: award_id = p_award_id;
4017:
4018: pell_awd_rec cur_pell_awd%ROWTYPE;
4019:
4020: CURSOR cur_loan_awd (p_award_id igf_aw_award_all.award_id%TYPE)
4021: IS
4022: SELECT
4023: COUNT(loan_id) awd_count
4024: FROM
4031:
4032: --
4033: -- check if award has pell or loan record
4034: --
4035: CURSOR cur_fws_awd (p_award_id igf_aw_award_all.award_id%TYPE) IS
4036: SELECT COUNT(auth_id) awd_count
4037: FROM igf_se_auth
4038: WHERE award_id = p_award_id
4039: AND flag = 'A';
4044: --
4045: -- Cursor to get disbursements
4046: --
4047:
4048: CURSOR cur_get_adisb ( p_award_id igf_aw_award_all.award_id%TYPE,
4049: p_ld_seq_num igf_aw_awd_disb_all.ld_sequence_number%TYPE,
4050: p_disb_num igf_aw_awd_disb_all.disb_num%TYPE)
4051: IS
4052: SELECT
4065: --
4066: -- Cursor to get Holds
4067: --
4068:
4069: CURSOR cur_get_holds ( p_award_id igf_aw_award_all.award_id%TYPE,
4070: p_disb_num igf_aw_awd_disb_all.disb_num%TYPE)
4071: IS
4072: SELECT
4073: row_id
4082: --
4083: -- Cursor to get Holds
4084: --
4085:
4086: CURSOR cur_get_awds ( p_award_id igf_aw_award_all.award_id%TYPE)
4087: IS
4088: SELECT
4089: row_id,base_id
4090: FROM
4087: IS
4088: SELECT
4089: row_id,base_id
4090: FROM
4091: igf_aw_award
4092: WHERE
4093: award_id = p_award_id ;
4094:
4095: get_awds_rec cur_get_awds%ROWTYPE;
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;
4107:
4108: get_fund_rec cur_fed_fund_code%ROWTYPE;
4109:
4110:
4111: CURSOR cur_chg_dtls(
4112: cp_award_id igf_aw_award_all.award_id%TYPE,
4113: cp_disb_num igf_aw_awd_disb_all.disb_num%TYPE
4114: ) IS
4115: SELECT ROWID row_id,
4116: disb_status
4224:
4225: END delete_awd_disb;
4226:
4227:
4228: FUNCTION get_total_disb ( p_award_id IN igf_aw_award_all.award_id%TYPE,
4229: p_ld_seq_num IN igf_aw_awd_disb_all.ld_sequence_number%TYPE )
4230: RETURN NUMBER
4231: IS
4232: --
4234: -- Bug 2306310
4235: -- Function to return number of disbursements
4236: --
4237:
4238: CURSOR cur_disb_nums ( p_award_id igf_aw_award_all.award_id%TYPE,
4239: p_ld_seq_num igf_aw_awd_disb_all.ld_sequence_number%TYPE)
4240: IS
4241: SELECT COUNT(disb_num) tot_num
4242: FROM
4288: SELECT
4289: 'Y'
4290: FROM
4291: igf_ap_fa_base_rec fa,
4292: igf_aw_award awd,
4293: igf_aw_awd_frml_det fdet
4294: WHERE
4295: fa.target_group = c_grp AND
4296: awd.base_id = fa.base_id AND
4305: SELECT
4306: 'Y'
4307: FROM
4308: igf_ap_fa_base_rec fa,
4309: igf_aw_award awd,
4310: igf_aw_awd_frml_det fdet
4311: WHERE
4312: fa.base_id = c_baseid AND
4313: awd.base_id = fa.base_id AND
4535:
4536: active_isir_rec cur_active_isir%ROWTYPE;
4537:
4538: CURSOR cur_award_app_num(
4539: cp_award_id igf_aw_award_all.award_id%TYPE
4540: ) IS
4541: SELECT *
4542: FROM igf_aw_award
4543: WHERE award_id = p_award_id;
4538: CURSOR cur_award_app_num(
4539: cp_award_id igf_aw_award_all.award_id%TYPE
4540: ) IS
4541: SELECT *
4542: FROM igf_aw_award
4543: WHERE award_id = p_award_id;
4544:
4545: BEGIN
4546:
4552: FOR rec IN cur_award_app_num(p_award_id)
4553: LOOP
4554: IF rec.app_trans_num_txt <> active_isir_rec.transaction_num THEN
4555: rec.app_trans_num_txt := active_isir_rec.transaction_num;
4556: igf_aw_award_pkg.update_row(
4557: x_mode => 'R',
4558: x_rowid => rec.row_id,
4559: x_award_id => rec.award_id,
4560: x_fund_id => rec.fund_id,