APPS.IGS_UC_LOAD_HERCULES_DATA dependencies on IGS_UC_ISTARZ2_INTS

Line 9934: igs_uc_istarz2_ints with record status N

9930: /******************************************************************
9931: Created By : smaddali
9932: Date Created By : 11-Jun-03
9933: Purpose : loads each record in the hercules view ivstarz2 into the interface table
9934: igs_uc_istarz2_ints with record status N
9935: Known limitations,enhancements,remarks:
9936: Change History
9937: Who When What
9938: ***************************************************************** */

Line 9982: UPDATE igs_uc_istarz2_ints SET record_status = 'O'

9978: -- set x_sync_read to true if the loop is entered even once
9979: g_sync_reqd := TRUE;
9980:
9981: -- Obsolete matching records in interface table with status N
9982: UPDATE igs_uc_istarz2_ints SET record_status = 'O'
9983: WHERE record_status = 'N' AND appno = c_ivstarz2_rec.appno
9984: AND inst = c_ivstarz2_rec.inst AND course = c_ivstarz2_rec.course
9985: AND campus = c_ivstarz2_rec.campus;
9986:

Line 9988: INSERT INTO igs_uc_istarz2_ints ( appno,

9984: AND inst = c_ivstarz2_rec.inst AND course = c_ivstarz2_rec.course
9985: AND campus = c_ivstarz2_rec.campus;
9986:
9987: -- copy hercules record into interface table with record status N
9988: INSERT INTO igs_uc_istarz2_ints ( appno,
9989: roundno,
9990: inst,
9991: course,
9992: campus,