APPS.IGF_SP_ROLLOVER dependencies on IGF_AP_FA_BASE_REC

Line 995: CURSOR c_igf_ap_fa_base_rec(cp_person_id igs_pe_person.person_id%TYPE,

991:
992: l_c_igf_sp_stdnt_rel c_igf_sp_stdnt_rel%ROWTYPE;
993:
994:
995: CURSOR c_igf_ap_fa_base_rec(cp_person_id igs_pe_person.person_id%TYPE,
996: cp_cal_type igs_ca_inst.cal_type%TYPE,
997: cp_seq_num igs_ca_inst.sequence_number%TYPE
998: ) IS
999: SELECT base_id

Line 1000: FROM igf_ap_fa_base_rec

996: cp_cal_type igs_ca_inst.cal_type%TYPE,
997: cp_seq_num igs_ca_inst.sequence_number%TYPE
998: ) IS
999: SELECT base_id
1000: FROM igf_ap_fa_base_rec
1001: WHERE person_id = cp_person_id
1002: AND ci_cal_type = cp_cal_type
1003: AND ci_sequence_number = cp_seq_num;
1004:

Line 1005: l_c_igf_ap_fa_base_rec c_igf_ap_fa_base_rec%ROWTYPE;

1001: WHERE person_id = cp_person_id
1002: AND ci_cal_type = cp_cal_type
1003: AND ci_sequence_number = cp_seq_num;
1004:
1005: l_c_igf_ap_fa_base_rec c_igf_ap_fa_base_rec%ROWTYPE;
1006:
1007: CURSOR c_igf_sp_std_fc(cp_spnsr_stdnt_id igf_sp_stdnt_rel.spnsr_stdnt_id%TYPE) IS
1008: SELECT *
1009: FROM igf_sp_std_fc_v

Line 1040: l_base_id igf_ap_fa_base_rec.base_id%TYPE;

1036: l_fee_cls_id igf_sp_fc_all.fee_cls_id%TYPE;
1037: l_fee_cls_prg_id igf_sp_prg_all.fee_cls_prg_id%TYPE;
1038: l_fee_cls_unit_id igf_sp_unit_all.fee_cls_unit_id%TYPE;
1039: l_message VARCHAR2(2000) := NULL;
1040: l_base_id igf_ap_fa_base_rec.base_id%TYPE;
1041: l_ans BOOLEAN := TRUE;
1042: -- cursor variable for c_igf_aw_cal_rel
1043: l_c_igf_aw_cal_rel c_igf_aw_cal_rel%ROWTYPE;
1044: -- cursor variable for c_igf_aw_fund_mast

Line 1116: OPEN c_igf_ap_fa_base_rec(cp_person_id => l_c_igf_sp_stdnt_rel.person_id,

1112: -- declare a save point
1113: SAVEPOINT sp_spnsr_student;
1114:
1115: -- checks if record exists in fa base record table for the student and award year
1116: OPEN c_igf_ap_fa_base_rec(cp_person_id => l_c_igf_sp_stdnt_rel.person_id,
1117: cp_cal_type => p_sc_cal_type,
1118: cp_seq_num => p_sc_seq_num);
1119: FETCH c_igf_ap_fa_base_rec INTO l_c_igf_ap_fa_base_rec;
1120:

Line 1119: FETCH c_igf_ap_fa_base_rec INTO l_c_igf_ap_fa_base_rec;

1115: -- checks if record exists in fa base record table for the student and award year
1116: OPEN c_igf_ap_fa_base_rec(cp_person_id => l_c_igf_sp_stdnt_rel.person_id,
1117: cp_cal_type => p_sc_cal_type,
1118: cp_seq_num => p_sc_seq_num);
1119: FETCH c_igf_ap_fa_base_rec INTO l_c_igf_ap_fa_base_rec;
1120:
1121: -- error out if no fa base record exists for the student award year
1122: IF c_igf_ap_fa_base_rec%NOTFOUND THEN
1123: CLOSE c_igf_ap_fa_base_rec;

Line 1122: IF c_igf_ap_fa_base_rec%NOTFOUND THEN

1118: cp_seq_num => p_sc_seq_num);
1119: FETCH c_igf_ap_fa_base_rec INTO l_c_igf_ap_fa_base_rec;
1120:
1121: -- error out if no fa base record exists for the student award year
1122: IF c_igf_ap_fa_base_rec%NOTFOUND THEN
1123: CLOSE c_igf_ap_fa_base_rec;
1124:
1125: -- rolls back to the save point
1126: ROLLBACK TO sp_spnsr_student;

Line 1123: CLOSE c_igf_ap_fa_base_rec;

1119: FETCH c_igf_ap_fa_base_rec INTO l_c_igf_ap_fa_base_rec;
1120:
1121: -- error out if no fa base record exists for the student award year
1122: IF c_igf_ap_fa_base_rec%NOTFOUND THEN
1123: CLOSE c_igf_ap_fa_base_rec;
1124:
1125: -- rolls back to the save point
1126: ROLLBACK TO sp_spnsr_student;
1127: fnd_message.set_name('IGF','IGF_SP_NO_FA_BASE_REC');

Line 1138: l_base_id := l_c_igf_ap_fa_base_rec.base_id ;

1134: -- skips the current student
1135: RAISE l_stud_exception;
1136: END IF;
1137:
1138: l_base_id := l_c_igf_ap_fa_base_rec.base_id ;
1139: CLOSE c_igf_ap_fa_base_rec;
1140: -- Check if succeeding terms are present for the current term passed as
1141: -- parameter to the process
1142: OPEN c_igf_aw_cal_rel(cp_cal_type => l_c_igf_sp_stdnt_rel.ld_cal_type,

Line 1139: CLOSE c_igf_ap_fa_base_rec;

1135: RAISE l_stud_exception;
1136: END IF;
1137:
1138: l_base_id := l_c_igf_ap_fa_base_rec.base_id ;
1139: CLOSE c_igf_ap_fa_base_rec;
1140: -- Check if succeeding terms are present for the current term passed as
1141: -- parameter to the process
1142: OPEN c_igf_aw_cal_rel(cp_cal_type => l_c_igf_sp_stdnt_rel.ld_cal_type,
1143: cp_seq_num => l_c_igf_sp_stdnt_rel.ld_sequence_number);