4: PROCEDURE create_auto_disb( p_fund_id IN igf_aw_award.fund_id%TYPE,
5: p_award_id IN igf_aw_award.award_id%TYPE,
6: p_offered_amt IN igf_aw_award.offered_amt%TYPE,
7: p_award_status IN igf_aw_award.award_status%TYPE,
8: p_adplans_id IN igf_aw_awd_dist_plans.adplans_id%TYPE,
9: p_method_code IN igf_aw_awd_dist_plans.dist_plan_method_code%TYPE,
10: p_awd_prd_code IN igf_aw_awd_prd_term.award_prd_cd%TYPE
11: );
12:
5: p_award_id IN igf_aw_award.award_id%TYPE,
6: p_offered_amt IN igf_aw_award.offered_amt%TYPE,
7: p_award_status IN igf_aw_award.award_status%TYPE,
8: p_adplans_id IN igf_aw_awd_dist_plans.adplans_id%TYPE,
9: p_method_code IN igf_aw_awd_dist_plans.dist_plan_method_code%TYPE,
10: p_awd_prd_code IN igf_aw_awd_prd_term.award_prd_cd%TYPE
11: );
12:
13: PROCEDURE round_off_disbursements(
14: p_fund_id IN igf_aw_award_t_all.fund_id%TYPE,
15: p_award_id IN igf_aw_award_t_all.award_id%TYPE,
16: p_offered_amt IN igf_aw_award_t_all.offered_amt%TYPE,
17: p_award_status IN igf_aw_award_all.award_status%TYPE,
18: p_dist_plan_code IN igf_aw_awd_dist_plans.dist_plan_method_code%TYPE,
19: p_disb_count IN NUMBER
20: );
21:
22: PROCEDURE update_accept_amount (
104: p_base_id IN NUMBER,
105: p_out OUT NOCOPY VARCHAR2 );
106:
107: PROCEDURE get_common_perct(
108: p_adplans_id IN igf_aw_awd_dist_plans.adplans_id%TYPE,
109: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
110: p_perct OUT NOCOPY NUMBER,
111: p_awd_prd_code IN igf_aw_awd_prd_term.award_prd_cd%TYPE DEFAULT NULL
112: );
111: p_awd_prd_code IN igf_aw_awd_prd_term.award_prd_cd%TYPE DEFAULT NULL
112: );
113:
114: PROCEDURE check_common_terms(
115: p_adplans_id IN igf_aw_awd_dist_plans.adplans_id%TYPE,
116: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
117: p_result OUT NOCOPY NUMBER,
118: p_awd_prd_code IN igf_aw_awd_prd_term.award_prd_cd%TYPE DEFAULT NULL
119: );
131: p_base_id IN NUMBER,
132: p_awd_prd_code IN igf_aw_awd_prd_term.award_prd_cd%TYPE DEFAULT NULL
133: ) RETURN BOOLEAN;
134:
135: FUNCTION get_plan_disb_count(p_adplans_id IN igf_aw_awd_dist_plans.adplans_id%TYPE,
136: p_awd_prd_code IN igf_aw_awd_prd_term.award_prd_cd%TYPE DEFAULT NULL
137: ) RETURN NUMBER;
138:
139: END igf_aw_gen_003;