APPS.IGS_UC_LOAD_HERCULES_DATA dependencies on IGS_UC_UCNTGRP_INTS

Line 3037: igs_uc_ucntgrp_ints with record status N

3033: /******************************************************************
3034: Created By : smaddali
3035: Date Created By : 11-Jun-03
3036: Purpose : loads each record in the hercules view uvcontgrp into the interface table
3037: igs_uc_ucntgrp_ints with record status N
3038: Known limitations,enhancements,remarks:
3039: Change History
3040: Who When What
3041: ***************************************************************** */

Line 3080: UPDATE igs_uc_ucntgrp_ints SET record_status = 'O'

3076: -- set x_sync_read to true if the loop is entered even once
3077: g_sync_reqd := TRUE;
3078:
3079: -- Obsolete matching records in interface table with status N
3080: UPDATE igs_uc_ucntgrp_ints SET record_status = 'O'
3081: WHERE record_status = 'N' AND contactcode = c_uvcntgr_rec.contactcode
3082: AND ucasgroup = c_uvcntgr_rec.ucasgroup ;
3083:
3084: -- copy hercules record into interface table with record status N

Line 3085: INSERT INTO igs_uc_ucntgrp_ints ( contactcode,

3081: WHERE record_status = 'N' AND contactcode = c_uvcntgr_rec.contactcode
3082: AND ucasgroup = c_uvcntgr_rec.ucasgroup ;
3083:
3084: -- copy hercules record into interface table with record status N
3085: INSERT INTO igs_uc_ucntgrp_ints ( contactcode,
3086: ucasgroup,
3087: updater,
3088: record_status,
3089: error_code