DBA Data[Home] [Help]

APPS.CS_SR_DELETE_UTIL dependencies on CS_INCIDENTS_EXT_TL

Line 2989: , 'Deleting data from table CS_INCIDENTS_EXT_TL'

2985: fnd_log.string
2986: (
2987: fnd_log.level_statement
2988: , L_LOG_MODULE || 'sr_ext_attr_del_start'
2989: , 'Deleting data from table CS_INCIDENTS_EXT_TL'
2990: );
2991: END IF ;
2992:
2993: -- The following statement deletes all the translatable extended attributes

Line 2997: DELETE /*+ index(e) */ cs_incidents_ext_tl e

2993: -- The following statement deletes all the translatable extended attributes
2994: -- that are linked to the SRs present in the global temp table with purge
2995: -- status NULL
2996:
2997: DELETE /*+ index(e) */ cs_incidents_ext_tl e
2998: WHERE incident_id IN
2999: (
3000: SELECT /*+ no_unnest no_semijoin cardinality(10) */
3001: object_id

Line 3018: , 'After deleting data from table CS_INCIDENTS_EXT_TL '

3014: fnd_log.string
3015: (
3016: fnd_log.level_statement
3017: , L_LOG_MODULE || 'sr_ext_attr_del_end'
3018: , 'After deleting data from table CS_INCIDENTS_EXT_TL '
3019: || l_row_count || ' rows'
3020: );
3021: END IF ;
3022: