APPS.CS_SR_DELETE_UTIL dependencies on CS_INCIDENTS_EXT_AUDIT

Line 2941: , 'Deleting data from table CS_INCIDENTS_EXT_AUDIT'

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

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

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

Line 2956: , cs_incidents_ext_audit c

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

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

2968: fnd_log.string
2969: (
2970: fnd_log.level_statement
2971: , L_LOG_MODULE || 'sr_ext_attr_aud_del_end'
2972: , 'After deleting data from table CS_INCIDENTS_EXT_AUDIT '
2973: || l_row_count || ' rows'
2974: );
2975: END IF ;
2976: