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_PURGE_STAGING

Line 1666: || 'CS_INCIDENTS_PURGE_STAGING table'

1662: (
1663: fnd_log.level_statement
1664: , L_LOG_MODULE || 'get_data_for_staging_start'
1665: , 'Collecting information that has to be written to the '
1666: || 'CS_INCIDENTS_PURGE_STAGING table'
1667: );
1668: END IF ;
1669:
1670: -- Collect all the information from the global temp table

Line 1701: || 'CS_INCIDENTS_PURGE_STAGING table ' || l_row_count || ' rows'

1697: (
1698: fnd_log.level_statement
1699: , L_LOG_MODULE || 'get_data_for_staging_end'
1700: , 'After collecting information that has to be written to the '
1701: || 'CS_INCIDENTS_PURGE_STAGING table ' || l_row_count || ' rows'
1702: );
1703: END IF ;
1704: END IF;
1705:

Line 1834: , 'Updating purge status into table CS_INCIDENTS_PURGE_STAGING'

1830: fnd_log.string
1831: (
1832: fnd_log.level_statement
1833: , L_LOG_MODULE || 'write_staging_start'
1834: , 'Updating purge status into table CS_INCIDENTS_PURGE_STAGING'
1835: );
1836: END IF ;
1837:
1838: -- Updating the staging table to indicate the SRs that failed during purge

Line 1842: UPDATE cs_incidents_purge_staging

1838: -- Updating the staging table to indicate the SRs that failed during purge
1839: -- due to validations against child objects.
1840:
1841: FORALL j IN l_incident_id_status_tbl.FIRST..l_incident_id_status_tbl.LAST
1842: UPDATE cs_incidents_purge_staging
1843: SET
1844: purge_status = 'E'
1845: , purge_error_message = l_purge_error_message_tbl(j)
1846: WHERE

Line 1857: , 'After updating purge status into table CS_INCIDENTS_PURGE_STAGING '

1853: fnd_log.string
1854: (
1855: fnd_log.level_statement
1856: , L_LOG_MODULE || 'write_staging_end'
1857: , 'After updating purge status into table CS_INCIDENTS_PURGE_STAGING '
1858: || l_row_count || ' rows'
1859: );
1860: END IF ;
1861: ELSIF l_incident_id_status_tbl.COUNT <= 0

Line 1869: , 'While updating purge status into table CS_INCIDENTS_PURGE_STAGING '

1865: fnd_log.string
1866: (
1867: fnd_log.level_statement
1868: , L_LOG_MODULE || 'write_staging_norows'
1869: , 'While updating purge status into table CS_INCIDENTS_PURGE_STAGING '
1870: || 'l_incident_id_status_tbl had ' || l_incident_id_status_tbl.COUNT
1871: || ' rows'
1872: );
1873: END IF ;

Line 1901: UPDATE cs_incidents_purge_staging

1897: -- successfully to purge_status 'S' to be able
1898: -- to differentiate these rows from the ones
1899: -- that were not yet processed.
1900:
1901: UPDATE cs_incidents_purge_staging
1902: SET
1903: purge_status = 'S'
1904: WHERE
1905: incident_id IN