APPS.IGS_UC_LOAD_HERCULES_DATA dependencies on IGS_UC_CVSCH_INTS

Line 2602: igs_uc_cvsch_ints with record status N

2598: /******************************************************************
2599: Created By : smaddali
2600: Date Created By : 11-Jun-03
2601: Purpose : loads each record in the hercules view cvschool into the interface table
2602: igs_uc_cvsch_ints with record status N
2603: Known limitations,enhancements,remarks:
2604: Change History
2605: Who When What
2606: jbaber 15-Sep-05 Replace estabgrp value with '*' if NULL for bug 4589994

Line 2675: UPDATE igs_uc_cvsch_ints SET record_status = 'O'

2671: IF is_valid(c_cvschool_rec.school,'CVSCHOOL','School','NUMBER') AND
2672: is_valid(c_cvschool_rec.country,'CVSCHOOL','Country','NUMBER') THEN
2673:
2674: -- Obsolete matching records in interface table with status N
2675: UPDATE igs_uc_cvsch_ints SET record_status = 'O'
2676: WHERE record_status = 'N' AND school = c_cvschool_rec.school ;
2677:
2678: -- copy hercules record into interface table with record status N
2679: INSERT INTO igs_uc_cvsch_ints ( school,

Line 2679: INSERT INTO igs_uc_cvsch_ints ( school,

2675: UPDATE igs_uc_cvsch_ints SET record_status = 'O'
2676: WHERE record_status = 'N' AND school = c_cvschool_rec.school ;
2677:
2678: -- copy hercules record into interface table with record status N
2679: INSERT INTO igs_uc_cvsch_ints ( school,
2680: sitecode,
2681: schoolname,
2682: namechangedate,
2683: formername,