DBA Data[Home] [Help]

APPS.CS_SR_DELETE_UTIL dependencies on CS_INCIDENTS_EXT_TL

Line 2985: , 'Deleting data from table CS_INCIDENTS_EXT_TL'

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

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

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

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

3010: fnd_log.string
3011: (
3012: fnd_log.level_statement
3013: , L_LOG_MODULE || 'sr_ext_attr_del_end'
3014: , 'After deleting data from table CS_INCIDENTS_EXT_TL '
3015: || l_row_count || ' rows'
3016: );
3017: END IF ;
3018: