APPS.CS_SR_DELETE_UTIL dependencies on CS_SR_CONTACTS_EXT_AUDIT

Line 2215: , 'Deleting data from table CS_SR_CONTACTS_EXT_AUDIT'

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

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

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

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

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