DBA Data[Home] [Help]

APPS.IGF_AW_GEN_003 dependencies on IGF_AW_AWD_DIST_PLANS

Line 8: p_adplans_id IN igf_aw_awd_dist_plans.adplans_id%TYPE,

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:

Line 9: p_method_code IN igf_aw_awd_dist_plans.dist_plan_method_code%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:
13: PROCEDURE round_off_disbursements(

Line 18: p_dist_plan_code IN igf_aw_awd_dist_plans.dist_plan_method_code%TYPE,

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 (

Line 108: p_adplans_id IN igf_aw_awd_dist_plans.adplans_id%TYPE,

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: );

Line 115: p_adplans_id IN igf_aw_awd_dist_plans.adplans_id%TYPE,

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: );

Line 135: FUNCTION get_plan_disb_count(p_adplans_id IN igf_aw_awd_dist_plans.adplans_id%TYPE,

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;