APPS.IGR_IMP_001 dependencies on IGR_IS_ACAD

Line 149: CURSOR inq_per_acad_cur(l_person_id igr_is_acad.inq_person_id%TYPE) IS

145: WHERE
146: inq_person_id = l_person_id AND
147: status IN (inserted,updated);
148:
149: CURSOR inq_per_acad_cur(l_person_id igr_is_acad.inq_person_id%TYPE) IS
150: SELECT
151: institution_cd,
152: current_inst,
153: start_date,

Line 163: igr_is_acad

159: selfrep_rank_in_class,
160: selfrep_classsize,
161: selfrep_total_cp_earned
162: FROM
163: igr_is_acad
164: WHERE
165: inq_person_id = l_person_id AND
166: status IN (inserted,updated);
167:

Line 1427: UPDATE igr_is_acad SET status = 'T' WHERE inq_person_id = inq_rec.inq_person_id;

1423: fnd_file.put_line(fnd_file.log,'Insert on IGS_AD_ACADHIS_INT failed '||SQLERRM);
1424: RAISE;
1425: END;
1426:
1427: UPDATE igr_is_acad SET status = 'T' WHERE inq_person_id = inq_rec.inq_person_id;
1428: ELSE /* l_status = 0 i.e Validation failed*/
1429: fnd_message.set_name('IGS','IGS_AD_SS_TO_INT_NULL_FAIL');
1430: fnd_message.set_token('TABLE_NAME','igs_ad_acadhis_int');
1431: fnd_message.set_token('COL_NAMES',l_tokenstr);