APPS.CS_SR_DELETE_UTIL dependencies on CS_SR_CONTACTS_EXT_TL

Line 2262: , 'Deleting data from table CS_SR_CONTACTS_EXT_TL'

2258: fnd_log.string
2259: (
2260: fnd_log.level_statement
2261: , L_LOG_MODULE || 'del_cont_ext_start'
2262: , 'Deleting data from table CS_SR_CONTACTS_EXT_TL'
2263: );
2264: END IF ;
2265:
2266: -- This statement deletes all the translatable extended attributes attached

Line 2270: DELETE /*+ index(e) */ cs_sr_contacts_ext_tl e

2266: -- This statement deletes all the translatable extended attributes attached
2267: -- to contacts that are linked to an SR that is available in the global
2268: -- temp table with purge status NULL.
2269:
2270: DELETE /*+ index(e) */ cs_sr_contacts_ext_tl e
2271: WHERE incident_id IN
2272: (
2273: SELECT /*+ no_unnest no_semijoin cardinality(10) */
2274: object_id

Line 2291: , 'After deleting data from table CS_SR_CONTACTS_EXT_TL '

2287: fnd_log.string
2288: (
2289: fnd_log.level_statement
2290: , L_LOG_MODULE || 'del_cont_ext_end'
2291: , 'After deleting data from table CS_SR_CONTACTS_EXT_TL '
2292: || l_row_count || ' rows'
2293: );
2294: END IF ;
2295: