APPS.IGS_UC_LOAD_HERCULES_DATA dependencies on IGS_UC_IQUAL_INTS

Line 4870: igs_uc_iqual_ints with record status N

4866: /******************************************************************
4867: Created By : smaddali
4868: Date Created By : 11-Jun-03
4869: Purpose : loads each record in the hercules view ivqualification into the interface table
4870: igs_uc_iqual_ints with record status N
4871: Known limitations,enhancements,remarks:
4872: Change History
4873: Who When What
4874: ***************************************************************** */

Line 4903: l_appno igs_uc_iqual_ints.appno%TYPE;

4899: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
4900: l_new_max_timestamp igs_uc_ivqualification_2003_v.timestamp%TYPE ;
4901: l_count NUMBER ;
4902:
4903: l_appno igs_uc_iqual_ints.appno%TYPE;
4904: l_checkdigit NUMBER;
4905:
4906: BEGIN
4907: -- set syncronization required to false

Line 4928: UPDATE igs_uc_iqual_ints SET record_status = 'O'

4924: -- Determine actual appno
4925: get_appno(c_ivqual_rec.appno, NULL, l_appno, l_checkdigit);
4926:
4927: -- Obsolete matching records in interface table with status N
4928: UPDATE igs_uc_iqual_ints SET record_status = 'O'
4929: WHERE record_status = 'N' AND appno = l_appno;
4930:
4931: -- copy hercules record into interface table with record status N
4932: INSERT INTO igs_uc_iqual_ints ( appno,

Line 4932: INSERT INTO igs_uc_iqual_ints ( appno,

4928: UPDATE igs_uc_iqual_ints SET record_status = 'O'
4929: WHERE record_status = 'N' AND appno = l_appno;
4930:
4931: -- copy hercules record into interface table with record status N
4932: INSERT INTO igs_uc_iqual_ints ( appno,
4933: matchprevious,
4934: matchpreviousdate,
4935: matchwinter,
4936: matchsummer,