APPS.IGS_UC_LOAD_HERCULES_DATA dependencies on IGS_UC_UCRSVOP_INTS

Line 3518: igs_uc_ucrsvop_ints with record status N

3514: /******************************************************************
3515: Created By : smaddali
3516: Date Created By : 11-Jun-03
3517: Purpose : loads each record in the hercules view uvcoursevacoptions into the interface table
3518: igs_uc_ucrsvop_ints with record status N
3519: Known limitations,enhancements,remarks:
3520: Change History
3521: Who When What
3522: ***************************************************************** */

Line 3566: UPDATE igs_uc_ucrsvop_ints SET record_status = 'O'

3562: -- set x_sync_read to true if the loop is entered even once
3563: g_sync_reqd := TRUE;
3564:
3565: -- Obsolete matching records in interface table with status N
3566: UPDATE igs_uc_ucrsvop_ints SET record_status = 'O'
3567: WHERE record_status = 'N' AND course = c_uvcrsevacop_rec.course
3568: AND campus = c_uvcrsevacop_rec.campus AND optioncode = c_uvcrsevacop_rec.optioncode ;
3569:
3570: -- copy hercules record into interface table with record status N

Line 3571: INSERT INTO igs_uc_ucrsvop_ints ( course,

3567: WHERE record_status = 'N' AND course = c_uvcrsevacop_rec.course
3568: AND campus = c_uvcrsevacop_rec.campus AND optioncode = c_uvcrsevacop_rec.optioncode ;
3569:
3570: -- copy hercules record into interface table with record status N
3571: INSERT INTO igs_uc_ucrsvop_ints ( course,
3572: campus,
3573: optioncode,
3574: updater,
3575: clupdated,