DBA Data[Home] [Help]

APPS.IGS_UC_LOAD_HERCULES_DATA dependencies on IGS_UC_CINST_INTS

Line 838: UPDATE igs_uc_cinst_ints SET record_status = 'O'

834: -- set x_sync_read to true if the loop is entered even once
835: g_sync_reqd := TRUE;
836:
837: -- Obsolete matching records in interface table with status N
838: UPDATE igs_uc_cinst_ints SET record_status = 'O'
839: WHERE record_status = 'N' AND inst = c_cvinst_rec.inst ;
840:
841: -- copy hercules record into interface table with record status N
842: INSERT INTO igs_uc_cinst_ints ( inst,

Line 842: INSERT INTO igs_uc_cinst_ints ( inst,

838: UPDATE igs_uc_cinst_ints SET record_status = 'O'
839: WHERE record_status = 'N' AND inst = c_cvinst_rec.inst ;
840:
841: -- copy hercules record into interface table with record status N
842: INSERT INTO igs_uc_cinst_ints ( inst,
843: instcode,
844: instname,
845: ucas,
846: gttr,