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_SR_CONTACTS_EXT

Line 2213: , 'Deleting data from table CS_SR_CONTACTS_EXT_AUDIT'

2209: fnd_log.string
2210: (
2211: fnd_log.level_statement
2212: , L_LOG_MODULE || 'del_cont_ext_aud_start'
2213: , 'Deleting data from table CS_SR_CONTACTS_EXT_AUDIT'
2214: );
2215: END IF ;
2216:
2217: -- The following statement deletes the audit information captured for

Line 2221: DELETE /+ index(a) / cs_sr_contacts_ext_audit a

2217: -- The following statement deletes the audit information captured for
2218: -- the translatable Party role extended attributes related to SRs in the
2219: -- global temp table with purge status NULL.
2220:
2221: DELETE /*+ index(a) */ cs_sr_contacts_ext_audit a
2222: WHERE
2223: incident_id IN
2224: (
2225: SELECT /*+ unnest no_semijoin cardinality(10) */

Line 2247: , 'After deleting data from table CS_SR_CONTACTS_EXT_AUDIT '

2243: fnd_log.string
2244: (
2245: fnd_log.level_statement
2246: , L_LOG_MODULE || 'del_cont_ext_aud_end'
2247: , 'After deleting data from table CS_SR_CONTACTS_EXT_AUDIT '
2248: || l_row_count || ' rows'
2249: );
2250: END IF ;
2251:

Line 2260: , 'Deleting data from table CS_SR_CONTACTS_EXT_TL'

2256: fnd_log.string
2257: (
2258: fnd_log.level_statement
2259: , L_LOG_MODULE || 'del_cont_ext_start'
2260: , 'Deleting data from table CS_SR_CONTACTS_EXT_TL'
2261: );
2262: END IF ;
2263:
2264: -- This statement deletes all the translatable extended attributes attached

Line 2268: DELETE /+ index(e) / cs_sr_contacts_ext_tl e

2264: -- This statement deletes all the translatable extended attributes attached
2265: -- to contacts that are linked to an SR that is available in the global
2266: -- temp table with purge status NULL.
2267:
2268: DELETE /*+ index(e) */ cs_sr_contacts_ext_tl e
2269: WHERE incident_id IN
2270: (
2271: SELECT /*+ no_unnest no_semijoin cardinality(10) */
2272: object_id

Line 2289: , 'After deleting data from table CS_SR_CONTACTS_EXT_TL '

2285: fnd_log.string
2286: (
2287: fnd_log.level_statement
2288: , L_LOG_MODULE || 'del_cont_ext_end'
2289: , 'After deleting data from table CS_SR_CONTACTS_EXT_TL '
2290: || l_row_count || ' rows'
2291: );
2292: END IF ;
2293:

Line 2302: , 'Deleting data from table CS_SR_CONTACTS_EXT'

2298: fnd_log.string
2299: (
2300: fnd_log.level_statement
2301: , L_LOG_MODULE || 'del_cont_ext_start'
2302: , 'Deleting data from table CS_SR_CONTACTS_EXT'
2303: );
2304: END IF ;
2305:
2306: -- This statement deletes all the translatable extended attributes attached

Line 2310: DELETE /+ index(e) / cs_sr_contacts_ext e

2306: -- This statement deletes all the translatable extended attributes attached
2307: -- to contacts that are linked to an SR that is available in the global
2308: -- temp table with purge status NULL.
2309:
2310: DELETE /*+ index(e) */ cs_sr_contacts_ext e
2311: WHERE incident_id IN
2312: (
2313: SELECT /*+ no_unnest no_semijoin cardinality(10) */
2314: object_id

Line 2331: , 'After deleting data from table CS_SR_CONTACTS_EXT '

2327: fnd_log.string
2328: (
2329: fnd_log.level_statement
2330: , L_LOG_MODULE || 'del_cont_ext_end'
2331: , 'After deleting data from table CS_SR_CONTACTS_EXT '
2332: || l_row_count || ' rows'
2333: );
2334: END IF ;
2335: