APPS.IGS_UC_LOAD_HERCULES_DATA dependencies on IGS_UC_ISTARC_INTS

Line 5995: igs_uc_istarc_ints with record status N

5991: /******************************************************************
5992: Created By : smaddali
5993: Date Created By : 11-Jun-03
5994: Purpose : loads each record in the hercules view ivstarc into the interface table
5995: igs_uc_istarc_ints with record status N
5996: Known limitations,enhancements,remarks:
5997: Change History
5998: Who When What
5999: jbaber 15-Sep-05 Replace inst, course and campus values with '*' if NULL

Line 6050: l_appno igs_uc_istarc_ints.appno%TYPE;

6046: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
6047: l_new_max_timestamp igs_uc_ivstarc_2003_v.timestamp%TYPE ;
6048: l_count NUMBER ;
6049:
6050: l_appno igs_uc_istarc_ints.appno%TYPE;
6051: l_checkdigit NUMBER;
6052:
6053: BEGIN
6054: -- set syncronization required to false

Line 6075: UPDATE igs_uc_istarc_ints SET record_status = 'O'

6071: -- Determine actual appno
6072: get_appno(c_ivstarc_rec.appno, NULL, l_appno, l_checkdigit);
6073:
6074: -- Obsolete matching records in interface table with status N
6075: UPDATE igs_uc_istarc_ints SET record_status = 'O'
6076: WHERE record_status = 'N' AND appno = l_appno
6077: AND choiceno = c_ivstarc_rec.choiceno AND ucas_cycle = g_cyc_info_rec.configured_cycle ;
6078:
6079:

Line 6081: INSERT INTO igs_uc_istarc_ints ( appno,

6077: AND choiceno = c_ivstarc_rec.choiceno AND ucas_cycle = g_cyc_info_rec.configured_cycle ;
6078:
6079:
6080: -- copy hercules record into interface table with record status N
6081: INSERT INTO igs_uc_istarc_ints ( appno,
6082: choiceno,
6083: lastchange,
6084: inst,
6085: course,

Line 6187: igs_uc_istarc_ints with record status N

6183: /******************************************************************
6184: Created By : jbaber
6185: Date Created By : 12-Aug-03
6186: Purpose : loads each record in the hercules view ivnstarc into the interface table
6187: igs_uc_istarc_ints with record status N
6188: Known limitations,enhancements,remarks:
6189: Change History
6190: Who When What
6191: jbaber 29-Sep-05 Replace inst, course and campus values with '*' if NULL

Line 6233: l_appno igs_uc_istarc_ints.appno%TYPE;

6229: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
6230: l_new_max_timestamp igs_uc_ivnstarc_2006_v.timestamp%TYPE ;
6231: l_count NUMBER ;
6232:
6233: l_appno igs_uc_istarc_ints.appno%TYPE;
6234: l_checkdigit NUMBER;
6235:
6236: BEGIN
6237: -- set syncronization required to false

Line 6258: UPDATE igs_uc_istarc_ints SET record_status = 'O'

6254: -- Determine actual appno
6255: get_appno(c_ivnstarc_rec.appno, NULL, l_appno, l_checkdigit);
6256:
6257: -- Obsolete matching records in interface table with status N
6258: UPDATE igs_uc_istarc_ints SET record_status = 'O'
6259: WHERE record_status = 'N' AND appno = l_appno
6260: AND choiceno = c_ivnstarc_rec.choiceno AND ucas_cycle = g_cyc_info_rec.configured_cycle ;
6261:
6262:

Line 6264: INSERT INTO igs_uc_istarc_ints ( appno,

6260: AND choiceno = c_ivnstarc_rec.choiceno AND ucas_cycle = g_cyc_info_rec.configured_cycle ;
6261:
6262:
6263: -- copy hercules record into interface table with record status N
6264: INSERT INTO igs_uc_istarc_ints ( appno,
6265: choiceno,
6266: lastchange,
6267: inst,
6268: course,

Line 6399: l_appno igs_uc_istarc_ints.appno%TYPE;

6395: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
6396: l_new_max_timestamp igs_uc_ivgstarg_2006_v.timestamp%TYPE ;
6397: l_count NUMBER ;
6398:
6399: l_appno igs_uc_istarc_ints.appno%TYPE;
6400: l_checkdigit NUMBER;
6401:
6402: BEGIN
6403: -- set syncronization required to false