APPS.CS_SR_DELETE_UTIL dependencies on CS_SR_CONTACTS_EXT_TL

Line 2260: , 'Deleting data from table CS_SR_CONTACTS_EXT_TL'

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

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

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

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

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