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 1836: , 'Updating purge status into table CS_INCIDENTS_PURGE_STAGING'

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

Line 1844: UPDATE cs_incidents_purge_staging

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

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

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

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

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

Line 1903: UPDATE cs_incidents_purge_staging

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