APPS.IGS_UC_LOAD_HERCULES_DATA dependencies on IGS_UC_CROFFAB_INTS

Line 1874: igs_uc_croffab_ints with record status N

1870: /******************************************************************
1871: Created By : smaddali
1872: Date Created By : 11-Jun-03
1873: Purpose : loads each record in the hercules view cvrefofferabbrev into the interface table
1874: igs_uc_croffab_ints with record status N
1875: Known limitations,enhancements,remarks:
1876: Change History
1877: Who When What
1878: ***************************************************************** */

Line 1915: UPDATE igs_uc_croffab_ints SET record_status = 'O' WHERE record_status = 'N' ;

1911: -- if there is a difference in the timestamps then load all records from hercules view
1912: IF ( l_new_max_timestamp > p_old_timestamp OR p_old_timestamp IS NULL ) THEN
1913:
1914: -- Obsolete all records in interface table with status N
1915: UPDATE igs_uc_croffab_ints SET record_status = 'O' WHERE record_status = 'N' ;
1916:
1917: -- create interface records for each record in the hercules view
1918: FOR c_cvoffabr_rec IN c_cvoffabr LOOP
1919: -- set x_sync_read to true if the loop is entered even once

Line 1923: INSERT INTO igs_uc_croffab_ints ( abbrevcode,

1919: -- set x_sync_read to true if the loop is entered even once
1920: g_sync_reqd := TRUE;
1921:
1922: -- copy hercules record into interface table with record status N
1923: INSERT INTO igs_uc_croffab_ints ( abbrevcode,
1924: abbrevtext,
1925: letterformat,
1926: summarychar,
1927: uncond,