1977: -- bug 3199488, end block
1978:
1979: RETCODE := '0';
1980:
1981: -- Bug 1914745, clear any old records from the igc_cc_interface table
1982: -- DELETE FROM igc_cc_interface
1983: -- WHERE to_date(creation_date,'DD/MM/YYYY') <= to_date((sysdate - interval '2' day), 'DD/MM/YYYY');
1984:
1985: --Bug 2872060. Above delete commented out. Was causing compilation probs in Oracle8i
1978:
1979: RETCODE := '0';
1980:
1981: -- Bug 1914745, clear any old records from the igc_cc_interface table
1982: -- DELETE FROM igc_cc_interface
1983: -- WHERE to_date(creation_date,'DD/MM/YYYY') <= to_date((sysdate - interval '2' day), 'DD/MM/YYYY');
1984:
1985: --Bug 2872060. Above delete commented out. Was causing compilation probs in Oracle8i
1986: DELETE FROM igc_cc_interface
1982: -- DELETE FROM igc_cc_interface
1983: -- WHERE to_date(creation_date,'DD/MM/YYYY') <= to_date((sysdate - interval '2' day), 'DD/MM/YYYY');
1984:
1985: --Bug 2872060. Above delete commented out. Was causing compilation probs in Oracle8i
1986: DELETE FROM igc_cc_interface
1987: WHERE to_date(creation_date,'DD/MM/YYYY') <= to_date(sysdate ,'DD/MM/YYYY') - 2;
1988:
1989:
1990: /* Begin fix bug 1591845 */