APPS.CS_SR_DELETE_UTIL dependencies on CS_INCIDENTS_EXT_AUDIT

Line 2945: , 'Deleting data from table CS_INCIDENTS_EXT_AUDIT'

2941: fnd_log.string
2942: (
2943: fnd_log.level_statement
2944: , L_LOG_MODULE || 'sr_ext_attr_aud_del_start'
2945: , 'Deleting data from table CS_INCIDENTS_EXT_AUDIT'
2946: );
2947: END IF ;
2948:
2949: -- The following statement deletes all the audit information captured for

Line 2953: DELETE /*+ index(a) */ cs_incidents_ext_audit a

2949: -- The following statement deletes all the audit information captured for
2950: -- the translatable extended attributes linked to SRs in the global temp
2951: -- table with purge_status NULL
2952:
2953: DELETE /*+ index(a) */ cs_incidents_ext_audit a
2954: WHERE audit_extension_id IN
2955: (
2956: SELECT /*+ unnest no_semijoin leading(j) use_nl(c) cardinality(10) */
2957: audit_extension_id

Line 2960: , cs_incidents_ext_audit c

2956: SELECT /*+ unnest no_semijoin leading(j) use_nl(c) cardinality(10) */
2957: audit_extension_id
2958: FROM
2959: jtf_object_purge_param_tmp j
2960: , cs_incidents_ext_audit c
2961: WHERE
2962: j.object_type = 'SR'
2963: AND p_processing_set_id = j.processing_set_id
2964: AND NVL(j.purge_status, 'S') = 'S'

Line 2976: , 'After deleting data from table CS_INCIDENTS_EXT_AUDIT '

2972: fnd_log.string
2973: (
2974: fnd_log.level_statement
2975: , L_LOG_MODULE || 'sr_ext_attr_aud_del_end'
2976: , 'After deleting data from table CS_INCIDENTS_EXT_AUDIT '
2977: || l_row_count || ' rows'
2978: );
2979: END IF ;
2980: