DBA Data[Home] [Help]

APPS.CS_SR_DELETE_UTIL dependencies on CS_INCIDENTS_AUDIT_TL

Line 2600: , 'Deleting data from table CS_INCIDENTS_AUDIT_TL'

2596: fnd_log.string
2597: (
2598: fnd_log.level_statement
2599: , L_LOG_MODULE || 'del_sraudit_tl_start'
2600: , 'Deleting data from table CS_INCIDENTS_AUDIT_TL'
2601: );
2602: END IF ;
2603:
2604: -- Deleting rows from the audit TL table for the

Line 2607: DELETE /*+ index(t) */ cs_incidents_audit_tl t

2603:
2604: -- Deleting rows from the audit TL table for the
2605: -- SRs in the global temp table with purge status NULL
2606:
2607: DELETE /*+ index(t) */ cs_incidents_audit_tl t
2608: WHERE incident_id IN
2609: (
2610: SELECT /*+ no_unnest no_semijoin cardinality(10) */
2611: object_id

Line 2628: , 'After deleting data from table CS_INCIDENTS_AUDIT_TL '

2624: fnd_log.string
2625: (
2626: fnd_log.level_statement
2627: , L_LOG_MODULE || 'del_sraudit_tl_end'
2628: , 'After deleting data from table CS_INCIDENTS_AUDIT_TL '
2629: || l_row_count || ' rows'
2630: );
2631: END IF ;
2632: