DBA Data[Home] [Help]

APPS.CS_SR_DELETE_UTIL dependencies on CS_INCIDENTS_AUDIT_B

Line 2641: , 'Deleting data from table CS_INCIDENTS_AUDIT_B'

2637: fnd_log.string
2638: (
2639: fnd_log.level_statement
2640: , L_LOG_MODULE || 'del_sraudit_b_start'
2641: , 'Deleting data from table CS_INCIDENTS_AUDIT_B'
2642: );
2643: END IF ;
2644:
2645: -- Deleting rows from the audit table for the

Line 2648: DELETE /*+ index(b) */ cs_incidents_audit_b b

2644:
2645: -- Deleting rows from the audit table for the
2646: -- SRs in the global temp table with purge status NULL
2647:
2648: DELETE /*+ index(b) */ cs_incidents_audit_b b
2649: WHERE incident_id IN
2650: (
2651: SELECT /*+ unnest no_semijoin cardinality(10) */
2652: object_id

Line 2669: , 'After deleting data from table CS_INCIDENTS_AUDIT_B '

2665: fnd_log.string
2666: (
2667: fnd_log.level_statement
2668: , L_LOG_MODULE || 'del_sraudit_b_end'
2669: , 'After deleting data from table CS_INCIDENTS_AUDIT_B '
2670: || l_row_count || ' rows'
2671: );
2672: END IF ;
2673: