DBA Data[Home] [Help]

APPS.CS_SR_DELETE_UTIL dependencies on CUG_INCIDNT_ATTR_VALS_TL

Line 2857: , 'Deleting data from table CUG_INCIDNT_ATTR_VALS_TL'

2853: fnd_log.string
2854: (
2855: fnd_log.level_statement
2856: , L_LOG_MODULE || 'cug_attr_tl_del_start'
2857: , 'Deleting data from table CUG_INCIDNT_ATTR_VALS_TL'
2858: );
2859: END IF ;
2860:
2861: -- The following statement deletes all the translatable CIC attributes that

Line 2864: DELETE /*+ index(t) */ cug_incidnt_attr_vals_tl t

2860:
2861: -- The following statement deletes all the translatable CIC attributes that
2862: -- are linked to the SRs in the global temp table with purge_status NULL
2863:
2864: DELETE /*+ index(t) */ cug_incidnt_attr_vals_tl t
2865: WHERE incidnt_attr_val_id IN
2866: (
2867: SELECT /*+ no_unnest no_semijoin leading(j) use_concat cardinality(10) */
2868: c.incidnt_attr_val_id

Line 2887: , 'After deleting data from table CUG_INCIDNT_ATTR_VALS_TL '

2883: fnd_log.string
2884: (
2885: fnd_log.level_statement
2886: , L_LOG_MODULE || 'cug_attr_tl_del_end'
2887: , 'After deleting data from table CUG_INCIDNT_ATTR_VALS_TL '
2888: || l_row_count || ' rows'
2889: );
2890: END IF ;
2891: