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 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:

Line 2985: , 'Deleting data from table CS_INCIDENTS_EXT_TL'

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

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

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

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

3010: fnd_log.string
3011: (
3012: fnd_log.level_statement
3013: , L_LOG_MODULE || 'sr_ext_attr_del_end'
3014: , 'After deleting data from table CS_INCIDENTS_EXT_TL '
3015: || l_row_count || ' rows'
3016: );
3017: END IF ;
3018:

Line 3027: , 'Deleting data from table CS_INCIDENTS_EXT'

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

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

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

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

3052: fnd_log.string
3053: (
3054: fnd_log.level_statement
3055: , L_LOG_MODULE || 'sr_ext_attr_del_end'
3056: , 'After deleting data from table CS_INCIDENTS_EXT '
3057: || l_row_count || ' rows'
3058: );
3059: END IF ;
3060: