APPS.IGS_UC_LOAD_HERCULES_DATA dependencies on IGS_UC_COUNTRY_INTS

Line 4259: igs_uc_country_ints with record status N

4255: /******************************************************************
4256: Created By : jbaber
4257: Date Created By : 11-Jul-06
4258: Purpose : loads each record in the hercules view cvrefcountry into the interface table
4259: igs_uc_country_ints with record status N
4260: Known limitations,enhancements,remarks:
4261: Change History
4262: Who When What
4263: ***************************************************************** */

Line 4295: UPDATE igs_uc_country_ints SET record_status = 'O' WHERE record_status = 'N' ;

4291: -- if there is a difference in the timestamps then load all records from hercules view
4292: IF ( l_new_max_timestamp > p_old_timestamp OR p_old_timestamp IS NULL ) THEN
4293:
4294: -- Obsolete all records in interface table with status N
4295: UPDATE igs_uc_country_ints SET record_status = 'O' WHERE record_status = 'N' ;
4296:
4297: -- create interface records for each record in the hercules view
4298: FOR c_cvrefcountry_rec IN c_cvrefcountry LOOP
4299: -- set x_sync_read to true if the loop is entered even once

Line 4303: INSERT INTO igs_uc_country_ints ( countrycode,

4299: -- set x_sync_read to true if the loop is entered even once
4300: g_sync_reqd := TRUE;
4301:
4302: -- copy hercules record into interface table with record status N
4303: INSERT INTO igs_uc_country_ints ( countrycode,
4304: description,
4305: type,
4306: record_status,
4307: error_code )