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 2215: , 'Deleting data from table CS_SR_CONTACTS_EXT_AUDIT'

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

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

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

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

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

Line 2262: , 'Deleting data from table CS_SR_CONTACTS_EXT_TL'

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

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

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

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

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

Line 2304: , 'Deleting data from table CS_SR_CONTACTS_EXT'

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

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

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

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

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