eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CS_SR_DELETE_UTIL dependencies on CS_INCIDENTS_EXT

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:

Line 2989: , 'Deleting data from table CS_INCIDENTS_EXT_TL'

2985: fnd_log.string
2986: (
2987: fnd_log.level_statement
2988: , L_LOG_MODULE || 'sr_ext_attr_del_start'
2989: , 'Deleting data from table CS_INCIDENTS_EXT_TL'
2990: );
2991: END IF ;
2992:
2993: -- The following statement deletes all the translatable extended attributes

Line 2997: DELETE /+ index(e) / cs_incidents_ext_tl e

2993: -- The following statement deletes all the translatable extended attributes
2994: -- that are linked to the SRs present in the global temp table with purge
2995: -- status NULL
2996:
2997: DELETE /*+ index(e) */ cs_incidents_ext_tl e
2998: WHERE incident_id IN
2999: (
3000: SELECT /*+ no_unnest no_semijoin cardinality(10) */
3001: object_id

Line 3018: , 'After deleting data from table CS_INCIDENTS_EXT_TL '

3014: fnd_log.string
3015: (
3016: fnd_log.level_statement
3017: , L_LOG_MODULE || 'sr_ext_attr_del_end'
3018: , 'After deleting data from table CS_INCIDENTS_EXT_TL '
3019: || l_row_count || ' rows'
3020: );
3021: END IF ;
3022:

Line 3031: , 'Deleting data from table CS_INCIDENTS_EXT'

3027: fnd_log.string
3028: (
3029: fnd_log.level_statement
3030: , L_LOG_MODULE || 'sr_ext_attr_del_start'
3031: , 'Deleting data from table CS_INCIDENTS_EXT'
3032: );
3033: END IF ;
3034:
3035: -- The following statement deletes all the translatable extended attributes

Line 3039: DELETE /+ index(e) / cs_incidents_ext e

3035: -- The following statement deletes all the translatable extended attributes
3036: -- that are linked to the SRs present in the global temp table with purge
3037: -- status NULL
3038:
3039: DELETE /*+ index(e) */ cs_incidents_ext e
3040: WHERE incident_id IN
3041: (
3042: SELECT /*+ no_unnest no_semijoin cardinality(10) */
3043: object_id

Line 3060: , 'After deleting data from table CS_INCIDENTS_EXT '

3056: fnd_log.string
3057: (
3058: fnd_log.level_statement
3059: , L_LOG_MODULE || 'sr_ext_attr_del_end'
3060: , 'After deleting data from table CS_INCIDENTS_EXT '
3061: || l_row_count || ' rows'
3062: );
3063: END IF ;
3064: