APPS.IGS_UC_LOAD_HERCULES_DATA dependencies on IGS_UC_UCRSVAC_INTS

Line 3401: igs_uc_ucrsvac_ints with record status N

3397: /******************************************************************
3398: Created By : smaddali
3399: Date Created By : 11-Jun-03
3400: Purpose : loads each record in the hercules view uvcoursevacancies into the interface table
3401: igs_uc_ucrsvac_ints with record status N
3402: Known limitations,enhancements,remarks:
3403: Change History
3404: Who When What
3405: ***************************************************************** */

Line 3451: UPDATE igs_uc_ucrsvac_ints SET record_status = 'O'

3447: -- set x_sync_read to true if the loop is entered even once
3448: g_sync_reqd := TRUE;
3449:
3450: -- Obsolete matching records in interface table with status N
3451: UPDATE igs_uc_ucrsvac_ints SET record_status = 'O'
3452: WHERE record_status = 'N' AND course = c_uvcrsevac_rec.course
3453: AND campus = c_uvcrsevac_rec.campus ;
3454:
3455: -- copy hercules record into interface table with record status N

Line 3456: INSERT INTO igs_uc_ucrsvac_ints ( course,

3452: WHERE record_status = 'N' AND course = c_uvcrsevac_rec.course
3453: AND campus = c_uvcrsevac_rec.campus ;
3454:
3455: -- copy hercules record into interface table with record status N
3456: INSERT INTO igs_uc_ucrsvac_ints ( course,
3457: campus,
3458: updater,
3459: clupdated,
3460: cldate,