eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_UC_PROC_COM_INST_DATA dependencies on IGS_UC_UCRSE_INTS

Line 1867: FROM igs_uc_ucrse_ints usci

1863: -- Get new interface records
1864: CURSOR int_uvcrse_cur IS
1865: SELECT usci.rowid,
1866: usci.*
1867: FROM igs_uc_ucrse_ints usci
1868: WHERE usci.record_status = 'N';
1869:
1870: -- check whether corresponding record already exists.
1871: -- Currently since only FTUG is supported over Hercules and no course data for other systems come from UCAS,

Line 2009: UPDATE igs_uc_ucrse_ints

2005: -- update the interface table rec - record_status if successfully processed or Error Code if any error encountered
2006: -- while processing the record.
2007: IF g_error_code IS NOT NULL THEN
2008:
2009: UPDATE igs_uc_ucrse_ints
2010: SET error_code = g_error_code
2011: WHERE rowid = new_uvcrse_rec.rowid;
2012:
2013: -- log error message/meaning.

Line 2021: UPDATE igs_uc_ucrse_ints

2017: g_error_rec_cnt := g_error_rec_cnt + 1;
2018:
2019: ELSE
2020:
2021: UPDATE igs_uc_ucrse_ints
2022: SET record_status = 'D',
2023: error_code = NULL
2024: WHERE rowid = new_uvcrse_rec.rowid;
2025: