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.BIV_CORE_PKG dependencies on BIV_TMP_HS1

Line 1685: elsif (l_code = 'BIV_TMP_HS1') then

1681: session_id = :l_session_id or creation_date < sysdate -1 ' using l_session_id;
1682: elsif (l_code = 'BIV_TMP_RT2') then
1683: execute immediate 'delete from BIV_TMP_RT2 where
1684: session_id = :l_session_id or creation_date < sysdate -1 ' using l_session_id;
1685: elsif (l_code = 'BIV_TMP_HS1') then
1686: execute immediate 'delete from BIV_TMP_HS1 where
1687: session_id = :l_session_id or creation_date < sysdate -1 ' using l_session_id;
1688: elsif (l_code = 'BIV_TMP_HS2') then
1689: execute immediate 'delete from BIV_TMP_HS2 where

Line 1686: execute immediate 'delete from BIV_TMP_HS1 where

1682: elsif (l_code = 'BIV_TMP_RT2') then
1683: execute immediate 'delete from BIV_TMP_RT2 where
1684: session_id = :l_session_id or creation_date < sysdate -1 ' using l_session_id;
1685: elsif (l_code = 'BIV_TMP_HS1') then
1686: execute immediate 'delete from BIV_TMP_HS1 where
1687: session_id = :l_session_id or creation_date < sysdate -1 ' using l_session_id;
1688: elsif (l_code = 'BIV_TMP_HS2') then
1689: execute immediate 'delete from BIV_TMP_HS2 where
1690: session_id = :l_session_id or creation_date < sysdate -1 ' using l_session_id;

Line 1753: execute immediate 'delete from BIV_TMP_HS1 where

1749: execute immediate 'delete from BIV_TMP_RT2 where
1750: session_id = :l_session_id ' using l_session_id;
1751: elsif (p_region IN ('BIV_HS_PROB_AVOID',
1752: 'BIV_HS_PROB_AVOID_RES')) then
1753: execute immediate 'delete from BIV_TMP_HS1 where
1754: session_id = :l_session_id ' using l_session_id;
1755: elsif (p_region IN ('BIV_HS_SR_ESCALATION',
1756: 'BIV_HS_SR_ACTIVITY',
1757: 'BIV_HS_EACALATION_VIEW',

Line 1770: delete from biv_tmp_hs1 where session_id = l_session_id;

1766: session_id = :l_session_id ' using l_session_id;
1767: else
1768: delete from biv_tmp_rt1 where session_id = l_session_id;
1769: delete from biv_tmp_rt2 where session_id = l_session_id;
1770: delete from biv_tmp_hs1 where session_id = l_session_id;
1771: delete from biv_tmp_hs2 where session_id = l_session_id;
1772: delete from biv_tmp_bin where session_id = l_session_id;
1773: end if;
1774: if (g_debug = 'Y') then