APPS.IGS_UC_LOAD_HERCULES_DATA dependencies on IGS_UC_UCNTACT_INTS

Line 2917: igs_uc_ucntact_ints with record status N

2913: /******************************************************************
2914: Created By : smaddali
2915: Date Created By : 11-Jun-03
2916: Purpose : loads each record in the hercules view uvcontact into the interface table
2917: igs_uc_ucntact_ints with record status N
2918: Known limitations,enhancements,remarks:
2919: Change History
2920: Who When What
2921: ***************************************************************** */

Line 2968: UPDATE igs_uc_ucntact_ints SET record_status = 'O'

2964: -- set x_sync_read to true if the loop is entered even once
2965: g_sync_reqd := TRUE;
2966:
2967: -- Obsolete matching records in interface table with status N
2968: UPDATE igs_uc_ucntact_ints SET record_status = 'O'
2969: WHERE record_status = 'N' AND contactcode = c_uvcnt_rec.contactcode ;
2970:
2971: -- copy hercules record into interface table with record status N
2972: INSERT INTO igs_uc_ucntact_ints ( contactcode,

Line 2972: INSERT INTO igs_uc_ucntact_ints ( contactcode,

2968: UPDATE igs_uc_ucntact_ints SET record_status = 'O'
2969: WHERE record_status = 'N' AND contactcode = c_uvcnt_rec.contactcode ;
2970:
2971: -- copy hercules record into interface table with record status N
2972: INSERT INTO igs_uc_ucntact_ints ( contactcode,
2973: updater,
2974: name,
2975: post,
2976: address1,