APPS.IGF_AW_CANCEL_AWD dependencies on IGF_AP_FA_BASE_REC

Line 14: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,

10: || (reverse chronological order - newest change first)
11: */
12:
13: FUNCTION chk_awd_exp_date (
14: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
15: p_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,
16: p_ci_cal_type IN igs_ca_inst_all.cal_type%TYPE,
17: p_ci_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
18: p_run_mode IN igf_lookups_view.lookup_code%TYPE

Line 119: p_base_id OUT NOCOPY igf_ap_fa_base_rec_all.base_id%TYPE,

115: PROCEDURE get_base_id_per_num (
116: p_person_id IN hz_parties.party_id%TYPE,
117: p_ci_cal_type IN igs_ca_inst_all.cal_type%TYPE,
118: p_ci_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
119: p_base_id OUT NOCOPY igf_ap_fa_base_rec_all.base_id%TYPE,
120: p_per_num OUT NOCOPY igs_pe_person_base_v.person_number%TYPE
121: )
122: IS
123: /*

Line 134: CURSOR cur_get_pers_num (cp_person_id igf_ap_fa_base_rec_all.person_id%TYPE)

130: ||
131: || (reverse chronological order - newest change first)
132: */
133:
134: CURSOR cur_get_pers_num (cp_person_id igf_ap_fa_base_rec_all.person_id%TYPE)
135: IS
136: SELECT person_number
137: FROM igs_pe_person_base_v
138: WHERE person_id = cp_person_id;

Line 142: cp_person_id igf_ap_fa_base_rec_all.person_id%TYPE)

138: WHERE person_id = cp_person_id;
139:
140: CURSOR cur_get_base (cp_cal_type igs_ca_inst_all.cal_type%TYPE,
141: cp_sequence_number igs_ca_inst_all.sequence_number%TYPE,
142: cp_person_id igf_ap_fa_base_rec_all.person_id%TYPE)
143: IS
144: SELECT base_id
145: FROM igf_ap_fa_base_rec_all
146: WHERE person_id = cp_person_id AND

Line 145: FROM igf_ap_fa_base_rec_all

141: cp_sequence_number igs_ca_inst_all.sequence_number%TYPE,
142: cp_person_id igf_ap_fa_base_rec_all.person_id%TYPE)
143: IS
144: SELECT base_id
145: FROM igf_ap_fa_base_rec_all
146: WHERE person_id = cp_person_id AND
147: ci_cal_type = cp_cal_type AND
148: ci_sequence_number = cp_sequence_number;
149: BEGIN

Line 166: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,

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
170: /*

Line 195: igf_ap_fa_base_rec fbase,

191: fcat.fed_fund_code
192: FROM
193: igf_aw_award awd,
194: igf_aw_fund_mast fmast,
195: igf_ap_fa_base_rec fbase,
196: igf_ap_person_v fapv,
197: igf_aw_fund_cat fcat
198: WHERE
199: fbase.ci_cal_type = cp_ci_cal_type

Line 498: l_base_id igf_ap_fa_base_rec_all.base_id%TYPE;

494:
495: l_ci_cal_type igf_aw_award_v.ci_cal_type%TYPE;
496: l_ci_sequence_number igf_aw_award_v.ci_sequence_number%TYPE;
497: l_year VARCHAR2(80) DEFAULT igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG','AWARD_YEAR');
498: l_base_id igf_ap_fa_base_rec_all.base_id%TYPE;
499: l_party_id hz_parties.party_id%TYPE;
500: l_per_exists BOOLEAN := FALSE;
501: l_list VARCHAR2(32767);
502: l_status VARCHAR2(1);