DBA Data[Home] [Help]

APPS.IGC_CC_YEP_PROCESS_PKG dependencies on IGC_CC_INTERFACE

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

1171: END IF;
1172:
1173: retcode := 0;
1174:
1175: -- Bug 1914745, clear any old records from the igc_cc_interface table
1176: -- DELETE FROM igc_cc_interface
1177: -- WHERE to_date(creation_date,'DD/MM/YYYY') <= to_date((sysdate - interval '2' day), 'DD/MM/YYYY');
1178:
1179: -- Bug 2872060. Above Delete command commented out, was causing compilation probs in Oracle8i.

Line 1176: -- DELETE FROM igc_cc_interface

1172:
1173: retcode := 0;
1174:
1175: -- Bug 1914745, clear any old records from the igc_cc_interface table
1176: -- DELETE FROM igc_cc_interface
1177: -- WHERE to_date(creation_date,'DD/MM/YYYY') <= to_date((sysdate - interval '2' day), 'DD/MM/YYYY');
1178:
1179: -- Bug 2872060. Above Delete command commented out, was causing compilation probs in Oracle8i.
1180: DELETE FROM igc_cc_interface

Line 1180: DELETE FROM igc_cc_interface

1176: -- DELETE FROM igc_cc_interface
1177: -- WHERE to_date(creation_date,'DD/MM/YYYY') <= to_date((sysdate - interval '2' day), 'DD/MM/YYYY');
1178:
1179: -- Bug 2872060. Above Delete command commented out, was causing compilation probs in Oracle8i.
1180: DELETE FROM igc_cc_interface
1181: WHERE to_date(creation_date,'DD/MM/YYYY') <= to_date(sysdate ,'DD/MM/YYYY') - 2;
1182:
1183: /* Begin fix for bug 1576023 */
1184: l_msg_data := NULL;