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_CSCHCNT_INTS

Line 2778: igs_uc_cschcnt_ints with record status N

2774: /******************************************************************
2775: Created By : smaddali
2776: Date Created By : 11-Jun-03
2777: Purpose : loads each record in the hercules view cvschoolcontact into the interface table
2778: igs_uc_cschcnt_ints with record status N
2779: Known limitations,enhancements,remarks:
2780: Change History
2781: Who When What
2782: ***************************************************************** */

Line 2837: UPDATE igs_uc_cschcnt_ints SET record_status = 'O'

2833: IF is_valid(c_cvschcnt_rec.school,'CVSCHOOLCONTACT','School','NUMBER') AND
2834: is_valid(c_cvschcnt_rec.contactcode,'CVSCHOOLCONTACT','ContactCode','NUMBER') THEN
2835:
2836: -- Obsolete matching records in interface table with status N
2837: UPDATE igs_uc_cschcnt_ints SET record_status = 'O'
2838: WHERE record_status = 'N' AND school = c_cvschcnt_rec.school
2839: AND sitecode = NVL(c_cvschcnt_rec.sitecode,'A') AND contactcode = c_cvschcnt_rec.contactcode ;
2840:
2841: -- copy hercules record into interface table with record status N

Line 2842: INSERT INTO igs_uc_cschcnt_ints ( school,

2838: WHERE record_status = 'N' AND school = c_cvschcnt_rec.school
2839: AND sitecode = NVL(c_cvschcnt_rec.sitecode,'A') AND contactcode = c_cvschcnt_rec.contactcode ;
2840:
2841: -- copy hercules record into interface table with record status N
2842: INSERT INTO igs_uc_cschcnt_ints ( school,
2843: sitecode,
2844: contactcode,
2845: contactpost,
2846: contactname,