APPS.IGS_UC_MV_DATA_UPLD dependencies on IGS_UC_UOFABRV_INTS

Line 2011: || replaced igs_uc_mv_uvofr_abv with igs_uc_uofabrv_ints

2007: || Known limitations, enhancements or remarks :
2008: || Change History :
2009: || Who When What
2010: || smaddali 30-jun-03 Modified for ucfd203- multiple cycles build , bug#2669208
2011: || replaced igs_uc_mv_uvofr_abv with igs_uc_uofabrv_ints
2012: || (reverse chronological order - newest change first)
2013: */
2014:
2015: BEGIN

Line 2018: UPDATE igs_uc_uofabrv_ints SET record_status = 'O'

2014:
2015: BEGIN
2016:
2017: -- Obsolete matching records in interface table with status N
2018: UPDATE igs_uc_uofabrv_ints SET record_status = 'O'
2019: WHERE record_status = 'N' AND abbrevid = TO_NUMBER(TRIM(SUBSTR(p_record_data,1,2)));
2020:
2021: -- copy the marvin record into the ucas interface tables
2022: INSERT INTO igs_uc_uofabrv_ints(

Line 2022: INSERT INTO igs_uc_uofabrv_ints(

2018: UPDATE igs_uc_uofabrv_ints SET record_status = 'O'
2019: WHERE record_status = 'N' AND abbrevid = TO_NUMBER(TRIM(SUBSTR(p_record_data,1,2)));
2020:
2021: -- copy the marvin record into the ucas interface tables
2022: INSERT INTO igs_uc_uofabrv_ints(
2023: abbrevid,
2024: updater,
2025: abbrevtext,
2026: letterformat,