APPS.IGS_UC_LOAD_HERCULES_DATA dependencies on IGS_UC_UOFABRV_INTS

Line 3849: igs_uc_uofabrv_ints with record status N

3845: /******************************************************************
3846: Created By : smaddali
3847: Date Created By : 11-Jun-03
3848: Purpose : loads each record in the hercules view uvofferabbrev into the interface table
3849: igs_uc_uofabrv_ints with record status N
3850: Known limitations,enhancements,remarks:
3851: Change History
3852: Who When What
3853: ***************************************************************** */

Line 3898: UPDATE igs_uc_uofabrv_ints SET record_status = 'O'

3894: --Validate varchar to number conversion
3895: IF is_valid(c_uvoffabrv_rec.abbrevid,'UVOFFERABBREV','ABBREVID','NUMBER') THEN
3896:
3897: -- Obsolete matching records in interface table with status N
3898: UPDATE igs_uc_uofabrv_ints SET record_status = 'O'
3899: WHERE record_status = 'N' AND abbrevid = c_uvoffabrv_rec.abbrevid ;
3900:
3901: -- copy hercules record into interface table with record status N
3902: INSERT INTO igs_uc_uofabrv_ints ( abbrevid,

Line 3902: INSERT INTO igs_uc_uofabrv_ints ( abbrevid,

3898: UPDATE igs_uc_uofabrv_ints SET record_status = 'O'
3899: WHERE record_status = 'N' AND abbrevid = c_uvoffabrv_rec.abbrevid ;
3900:
3901: -- copy hercules record into interface table with record status N
3902: INSERT INTO igs_uc_uofabrv_ints ( abbrevid,
3903: updater,
3904: abbrevtext,
3905: letterformat,
3906: summarychar,