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.CSI_TXN_HISTORY_PURGE_PVT dependencies on CSI_II_FORWARD_SYNC_TEMP

Line 96: -- Check if there are any instances residing in CSI_II_FORWARD_SYNC_TEMP table with a lesser time stamp.

92: Debug('No History Transaction available for Purge for the Given Date...');
93: Return;
94: END IF;
95: --
96: -- Check if there are any instances residing in CSI_II_FORWARD_SYNC_TEMP table with a lesser time stamp.
97: Begin
98: select 'x'
99: into l_exists
100: from CSI_II_FORWARD_SYNC_TEMP

Line 100: from CSI_II_FORWARD_SYNC_TEMP

96: -- Check if there are any instances residing in CSI_II_FORWARD_SYNC_TEMP table with a lesser time stamp.
97: Begin
98: select 'x'
99: into l_exists
100: from CSI_II_FORWARD_SYNC_TEMP
101: where date_time_stamp <= to_date(purge_to_date, 'YYYY/MM/DD HH24:MI:SS')
102: and process_flag <> 'P'
103: and rownum < 2;
104: Debug('One or more instances reside in CSI_II_FORWARD_SYNC_TEMP table with a date_time_stamp lesser than the given Pruge Date. Cannot continue with the purge.');

Line 104: Debug('One or more instances reside in CSI_II_FORWARD_SYNC_TEMP table with a date_time_stamp lesser than the given Pruge Date. Cannot continue with the purge.');

100: from CSI_II_FORWARD_SYNC_TEMP
101: where date_time_stamp <= to_date(purge_to_date, 'YYYY/MM/DD HH24:MI:SS')
102: and process_flag <> 'P'
103: and rownum < 2;
104: Debug('One or more instances reside in CSI_II_FORWARD_SYNC_TEMP table with a date_time_stamp lesser than the given Pruge Date. Cannot continue with the purge.');
105: Return;
106: Exception
107: when no_data_found then
108: null;