APPS.IGS_UC_LOAD_HERCULES_DATA dependencies on IGS_UC_ISTARG_INTS

Line 6352: igs_uc_istarg_ints with record status N

6348: /******************************************************************
6349: Created By : jbaber
6350: Date Created By : 12-Aug-03
6351: Purpose : loads each record in the hercules view ivgstarg into the interface table
6352: igs_uc_istarg_ints with record status N
6353: Known limitations,enhancements,remarks:
6354: Change History
6355: Who When What
6356: jbaber 29-Sep-05 Replace inst, course and campus values with '*' if NULL

Line 6424: UPDATE igs_uc_istarg_ints SET record_status = 'O'

6420: -- Determine actual appno
6421: get_appno(c_ivgstarg_rec.appno, NULL, l_appno, l_checkdigit);
6422:
6423: -- Obsolete matching records in interface table with status N
6424: UPDATE igs_uc_istarg_ints SET record_status = 'O'
6425: WHERE record_status = 'N' AND appno = l_appno
6426: AND roundno = c_ivgstarg_rec.roundno AND ucas_cycle = g_cyc_info_rec.configured_cycle ;
6427:
6428:

Line 6431: INSERT INTO igs_uc_istarg_ints ( appno,

6427:
6428:
6429:
6430: -- copy hercules record into interface table with record status N
6431: INSERT INTO igs_uc_istarg_ints ( appno,
6432: roundno,
6433: lastchange,
6434: inst,
6435: course,