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.CSM_HTML5_PKG dependencies on CSM_HTML5_SYNC_DETAILS

Line 957: INSERT INTO csm_html5_sync_details(SESSION_ID, pi_name,record_count,comp_ref)

953: IS
954: PRAGMA AUTONOMOUS_TRANSACTION;
955: BEGIN
956:
957: INSERT INTO csm_html5_sync_details(SESSION_ID, pi_name,record_count,comp_ref)
958: values(p_session_id,p_pi,p_count,p_comp_ref);
959:
960: IF(p_dummy) THEN
961: p_dummy := false;

Line 1984: delete from csm_html5_sync_details a where not exists(select 1 from csm_html5_sync_info b where a.session_id=b.session_id);

1980: FETCH c_purge_days INTO l_days;
1981: IF c_purge_days%FOUND AND l_days IS NOT NULL AND l_days>0 THEN
1982: delete from csm_html5_ajax_info where creation_date < (sysdate-l_days);
1983: delete from csm_html5_sync_info where start_date < (sysdate-l_days);
1984: delete from csm_html5_sync_details a where not exists(select 1 from csm_html5_sync_info b where a.session_id=b.session_id);
1985: delete from csm_query_instances_acc
1986: where creation_date < (sysdate-l_days)
1987: and query_id between 1 and 99
1988: and instance_id not in (select to_number(prf_value) from csm_html5_clients_info WHERE PRF_NAME='SCHEMA_REUSE' OR PRF_NAME like 'REUSABLE%' OR PRF_NAME LIKE 'USER_CREAT%')