APPS.IGS_UC_LOAD_HERCULES_DATA dependencies on IGS_UC_CRKYWD_INTS

Line 1707: igs_uc_crkywd_ints with record status N

1703: /******************************************************************
1704: Created By : smaddali
1705: Date Created By : 11-Jun-03
1706: Purpose : loads each record in the hercules view cvrefkeyword into the interface table
1707: igs_uc_crkywd_ints with record status N
1708: Known limitations,enhancements,remarks:
1709: Change History
1710: Who When What
1711: ***************************************************************** */

Line 1741: UPDATE igs_uc_crkywd_ints SET record_status = 'O' WHERE record_status = 'N' ;

1737: -- if there is a difference in the timestamps then load all records from hercules view
1738: IF ( l_new_max_timestamp > p_old_timestamp OR p_old_timestamp IS NULL ) THEN
1739:
1740: -- Obsolete all records in interface table with status N
1741: UPDATE igs_uc_crkywd_ints SET record_status = 'O' WHERE record_status = 'N' ;
1742:
1743: -- create interface records for each record in the hercules view
1744: FOR c_cvkyw_rec IN c_cvkyw LOOP
1745: -- set x_sync_read to true if the loop is entered even once

Line 1749: INSERT INTO igs_uc_crkywd_ints ( keyword,

1745: -- set x_sync_read to true if the loop is entered even once
1746: g_sync_reqd := TRUE;
1747:
1748: -- copy hercules record into interface table with record status N
1749: INSERT INTO igs_uc_crkywd_ints ( keyword,
1750: record_status,
1751: error_code )
1752: VALUES ( c_cvkyw_rec.keyword,
1753: 'N',