DBA Data[Home] [Help]

APPS.IGC_CC_REVAL_FIX_PROCESS_PKG dependencies on IGC_CC_INTERFACE

Line 1895: -- Bug 1914745, clear any old records from the igc_cc_interface table

1891:
1892: l_request_id1 := fnd_global.conc_request_id;
1893: p_process_phase := 'F';
1894:
1895: -- Bug 1914745, clear any old records from the igc_cc_interface table
1896: -- DELETE FROM igc_cc_interface
1897: -- WHERE to_date(creation_date,'DD/MM/YYYY') <= to_date((sysdate - interval '2' day), 'DD/MM/YYYY');
1898:
1899: -- Bug 2872060. Above Delete commented out due to compilation probs in Oracle8i

Line 1896: -- DELETE FROM igc_cc_interface

1892: l_request_id1 := fnd_global.conc_request_id;
1893: p_process_phase := 'F';
1894:
1895: -- Bug 1914745, clear any old records from the igc_cc_interface table
1896: -- DELETE FROM igc_cc_interface
1897: -- WHERE to_date(creation_date,'DD/MM/YYYY') <= to_date((sysdate - interval '2' day), 'DD/MM/YYYY');
1898:
1899: -- Bug 2872060. Above Delete commented out due to compilation probs in Oracle8i
1900: DELETE FROM igc_cc_interface

Line 1900: DELETE FROM igc_cc_interface

1896: -- DELETE FROM igc_cc_interface
1897: -- WHERE to_date(creation_date,'DD/MM/YYYY') <= to_date((sysdate - interval '2' day), 'DD/MM/YYYY');
1898:
1899: -- Bug 2872060. Above Delete commented out due to compilation probs in Oracle8i
1900: DELETE FROM igc_cc_interface
1901: WHERE to_date(creation_date,'DD/MM/YYYY') <= to_date(sysdate ,'DD/MM/YYYY') - 2;
1902:
1903: /* Begin bug fix 1591845 */
1904: /* Added TRUNC to statement below to remove time portion of p_revalue_fix_date to fix bug 1632975.*/