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_LOAD_HERCULES_DATA dependencies on IGS_UC_IFRMQUL_INTS

Line 11254: igs_uc_ifrmqul_ints with record status N

11250: /******************************************************************
11251: Created By : smaddali
11252: Date Created By : 11-Jun-03
11253: Purpose : loads each record in the hercules view ivformquals into the interface table
11254: igs_uc_ifrmqul_ints with record status N
11255: Known limitations,enhancements,remarks:
11256: Change History
11257: Who When What
11258: ***************************************************************** */

Line 11284: l_appno igs_uc_ifrmqul_ints.appno%TYPE;

11280: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
11281: l_new_max_timestamp igs_uc_ivformquals_2004_v.timestamp%TYPE ;
11282: l_count NUMBER ;
11283:
11284: l_appno igs_uc_ifrmqul_ints.appno%TYPE;
11285: l_checkdigit NUMBER;
11286:
11287: BEGIN
11288: -- set syncronization required to false

Line 11309: UPDATE igs_uc_ifrmqul_ints SET record_status = 'O'

11305: -- Determine actual appno
11306: get_appno(c_ivformqual_rec.appno, NULL, l_appno, l_checkdigit);
11307:
11308: -- Obsolete matching records in interface table with status N
11309: UPDATE igs_uc_ifrmqul_ints SET record_status = 'O'
11310: WHERE record_status = 'N' AND appno = l_appno
11311: AND qualid = c_ivformqual_rec.qualid ;
11312:
11313: -- copy hercules record into interface table with record status N

Line 11314: INSERT INTO igs_uc_ifrmqul_ints ( appno,

11310: WHERE record_status = 'N' AND appno = l_appno
11311: AND qualid = c_ivformqual_rec.qualid ;
11312:
11313: -- copy hercules record into interface table with record status N
11314: INSERT INTO igs_uc_ifrmqul_ints ( appno,
11315: qualid,
11316: qualtype,
11317: awardbody,
11318: title,

Line 11375: igs_uc_ifrmqul_ints with record status N

11371: /******************************************************************
11372: Created By : jbaber
11373: Date Created By : 15-Sep-05
11374: Purpose : loads each record in the hercules view ivformquals into the interface table
11375: igs_uc_ifrmqul_ints with record status N
11376: Known limitations,enhancements,remarks:
11377: Change History
11378: Who When What
11379: jbaber 11-Jul-06 Truncate qualtype to 30 chars for UCAS 2007 Support

Line 11407: l_qualdate igs_uc_ifrmqul_ints.qualdate%TYPE;

11403: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
11404: l_new_max_timestamp igs_uc_ivformquals_2006_v.timestamp%TYPE ;
11405: l_count NUMBER ;
11406:
11407: l_qualdate igs_uc_ifrmqul_ints.qualdate%TYPE;
11408: l_appno igs_uc_ifrmqul_ints.appno%TYPE;
11409: l_checkdigit NUMBER;
11410:
11411: BEGIN

Line 11408: l_appno igs_uc_ifrmqul_ints.appno%TYPE;

11404: l_new_max_timestamp igs_uc_ivformquals_2006_v.timestamp%TYPE ;
11405: l_count NUMBER ;
11406:
11407: l_qualdate igs_uc_ifrmqul_ints.qualdate%TYPE;
11408: l_appno igs_uc_ifrmqul_ints.appno%TYPE;
11409: l_checkdigit NUMBER;
11410:
11411: BEGIN
11412: -- set syncronization required to false

Line 11433: UPDATE igs_uc_ifrmqul_ints SET record_status = 'O'

11429: -- Determine actual appno
11430: get_appno(c_ivformqual_rec.appno, NULL, l_appno, l_checkdigit);
11431:
11432: -- Obsolete matching records in interface table with status N
11433: UPDATE igs_uc_ifrmqul_ints SET record_status = 'O'
11434: WHERE record_status = 'N' AND appno = l_appno
11435: AND qualid = c_ivformqual_rec.qualid ;
11436:
11437: -- Construct qualdate from qualdatemonth and qualdateyear

Line 11446: INSERT INTO igs_uc_ifrmqul_ints ( appno,

11442: l_qualdate := NULL;
11443: END IF;
11444:
11445: -- copy hercules record into interface table with record status N
11446: INSERT INTO igs_uc_ifrmqul_ints ( appno,
11447: qualid,
11448: qualtype,
11449: awardbody,
11450: title,