APPS.IGF_AW_CANCEL_AWD dependencies on IGF_AW_AWARD_ALL

Line 165: p_fund_id IN igf_aw_award_all.fund_id%TYPE,

161:
162: PROCEDURE cancel_award_fabase (
163: p_ci_cal_type IN igs_ca_inst_all.cal_type%TYPE,
164: p_ci_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
165: p_fund_id IN igf_aw_award_all.fund_id%TYPE,
166: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
167: p_run_mode IN igf_lookups_view.lookup_code%TYPE
168: )
169: IS

Line 226: CURSOR cur_awd_disb(p_award_id igf_aw_award_all.award_id%TYPE)

222:
223: lc_awd c_awd%ROWTYPE;
224:
225: -- Cursor which fetches all the disbursements for an Award
226: CURSOR cur_awd_disb(p_award_id igf_aw_award_all.award_id%TYPE)
227: IS
228: SELECT row_id,disb_num
229: FROM igf_aw_awd_disb
230: WHERE

Line 430: p_fund_id IN igf_aw_award_all.fund_id%TYPE,

426: PROCEDURE cancel_award(
427: ERRBUF OUT NOCOPY VARCHAR2,
428: RETCODE OUT NOCOPY NUMBER,
429: p_award_year IN VARCHAR2,
430: p_fund_id IN igf_aw_award_all.fund_id%TYPE,
431: p_run_mode IN igf_lookups_view.lookup_code%TYPE,
432: p_base_id IN igf_ap_fa_con_v.base_id%TYPE,
433: p_org_id IN igf_aw_award_all.org_id%TYPE,
434: p_pig IN igs_pe_all_persid_group_v.group_id%TYPE

Line 433: p_org_id IN igf_aw_award_all.org_id%TYPE,

429: p_award_year IN VARCHAR2,
430: p_fund_id IN igf_aw_award_all.fund_id%TYPE,
431: p_run_mode IN igf_lookups_view.lookup_code%TYPE,
432: p_base_id IN igf_ap_fa_con_v.base_id%TYPE,
433: p_org_id IN igf_aw_award_all.org_id%TYPE,
434: p_pig IN igs_pe_all_persid_group_v.group_id%TYPE
435: ) AS
436: /*
437: || Created By : prchandr