APPS.IGF_AW_GEN_003 dependencies on IGF_AW_AWARD_ALL

Line 17: p_award_status IN igf_aw_award_all.award_status%TYPE,

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:

Line 70: p_award_id IN igf_aw_award_all.award_id%TYPE,

66: p_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,
67: p_fund_code IN igf_aw_fund_mast_all.fund_code%TYPE,
68: p_fed_fund_code IN igf_aw_fund_cat_all.fed_fund_code%TYPE,
69: p_person_number IN igf_aw_award_v.person_number%TYPE,
70: p_award_id IN igf_aw_award_all.award_id%TYPE,
71: p_act_isir IN VARCHAR2,
72: p_ld_seq_number IN NUMBER,
73: p_awd_prd_code IN igf_aw_awd_prd_term.award_prd_cd%TYPE DEFAULT NULL,
74: p_chk_holds OUT NOCOPY VARCHAR2)

Line 83: FUNCTION check_disbdts ( p_award_id IN igf_aw_award_all.award_id%TYPE,

79: -- This function returns validation failure message if any
80: -- The out NOCOPY parameter is indicator if the award is an overAward or not
81: --
82:
83: FUNCTION check_disbdts ( p_award_id IN igf_aw_award_all.award_id%TYPE,
84: p_ld_seq_number IN NUMBER)
85: RETURN VARCHAR2;
86:
87: --

Line 90: PROCEDURE update_bill_flag ( p_fund_id IN igf_aw_award_all.fund_id%TYPE,

86:
87: --
88: -- Procedure to update show_on_bill flag based on the fund manager value
89: --
90: PROCEDURE update_bill_flag ( p_fund_id IN igf_aw_award_all.fund_id%TYPE,
91: p_new_val IN igf_aw_fund_mast_all.show_on_bill%TYPE);
92:
93: FUNCTION delete_awd_disb ( p_award_id IN igf_aw_award_all.award_id%TYPE,
94: p_ld_seq_num IN igf_aw_awd_disb_all.ld_sequence_number%TYPE DEFAULT NULL,

Line 93: FUNCTION delete_awd_disb ( p_award_id IN igf_aw_award_all.award_id%TYPE,

89: --
90: PROCEDURE update_bill_flag ( p_fund_id IN igf_aw_award_all.fund_id%TYPE,
91: p_new_val IN igf_aw_fund_mast_all.show_on_bill%TYPE);
92:
93: FUNCTION delete_awd_disb ( p_award_id IN igf_aw_award_all.award_id%TYPE,
94: p_ld_seq_num IN igf_aw_awd_disb_all.ld_sequence_number%TYPE DEFAULT NULL,
95: p_disb_num IN igf_aw_awd_disb_all.disb_num%TYPE DEFAULT NULL)
96: RETURN VARCHAR2;
97:

Line 99: FUNCTION get_total_disb ( p_award_id IN igf_aw_award_all.award_id%TYPE,

95: p_disb_num IN igf_aw_awd_disb_all.disb_num%TYPE DEFAULT NULL)
96: RETURN VARCHAR2;
97:
98:
99: FUNCTION get_total_disb ( p_award_id IN igf_aw_award_all.award_id%TYPE,
100: p_ld_seq_num IN igf_aw_awd_disb_all.ld_sequence_number%TYPE DEFAULT NULL)
101: RETURN NUMBER;
102:
103: PROCEDURE awd_group_freeze(p_award_grp IN VARCHAR2,