APPS.CS_SR_DELETE_UTIL dependencies on CS_SR_CONTACTS_EXT_AUDIT

Line 2213: , 'Deleting data from table CS_SR_CONTACTS_EXT_AUDIT'

2209: fnd_log.string
2210: (
2211: fnd_log.level_statement
2212: , L_LOG_MODULE || 'del_cont_ext_aud_start'
2213: , 'Deleting data from table CS_SR_CONTACTS_EXT_AUDIT'
2214: );
2215: END IF ;
2216:
2217: -- The following statement deletes the audit information captured for

Line 2221: DELETE /*+ index(a) */ cs_sr_contacts_ext_audit a

2217: -- The following statement deletes the audit information captured for
2218: -- the translatable Party role extended attributes related to SRs in the
2219: -- global temp table with purge status NULL.
2220:
2221: DELETE /*+ index(a) */ cs_sr_contacts_ext_audit a
2222: WHERE
2223: incident_id IN
2224: (
2225: SELECT /*+ unnest no_semijoin cardinality(10) */

Line 2247: , 'After deleting data from table CS_SR_CONTACTS_EXT_AUDIT '

2243: fnd_log.string
2244: (
2245: fnd_log.level_statement
2246: , L_LOG_MODULE || 'del_cont_ext_aud_end'
2247: , 'After deleting data from table CS_SR_CONTACTS_EXT_AUDIT '
2248: || l_row_count || ' rows'
2249: );
2250: END IF ;
2251: