[Home] [Help]
672: /******************************************************************
673: Created By : smaddali
674: Date Created By : 11-Jun-03
675: Purpose : loads each record in the hercules view CVEBLSUBJECT into the interface table
676: igs_uc_ceblsbj_ints with record status N
677: Known limitations,enhancements,remarks:
678: Change History
679: Who When What
680: jbaber 15-Sep-05 Replace sitting and awardingbody values with '*' if NULL
725: -- set x_sync_read to true if the loop is entered even once
726: g_sync_reqd := TRUE;
727:
728: -- Obsolete matching records in interface table with status N
729: UPDATE igs_uc_ceblsbj_ints SET record_status = 'O'
730: WHERE record_status = 'N' AND subjectid = c_cvebl_rec.subjectid ;
731:
732: -- copy hercules record into interface table with record status N
733: INSERT INTO igs_uc_ceblsbj_ints ( subjectid,
729: UPDATE igs_uc_ceblsbj_ints SET record_status = 'O'
730: WHERE record_status = 'N' AND subjectid = c_cvebl_rec.subjectid ;
731:
732: -- copy hercules record into interface table with record status N
733: INSERT INTO igs_uc_ceblsbj_ints ( subjectid,
734: year,
735: sitting,
736: awardingbody,
737: externalref,
786: /******************************************************************
787: Created By : smaddali
788: Date Created By : 11-Jun-03
789: Purpose : loads each record in the hercules view CVINSTITUTION into the interface table
790: igs_uc_ceblsbj_ints with record status N
791: Known limitations,enhancements,remarks:
792: Change History
793: Who When What
794: jchin 7-Mar-05 Modified for bug #4103556/4124010 Defaulted SWAS column to 'N'