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_BIN

Line 1676: if l_code = 'BIV_TMP_BIN' then

1672: l_code varchar2(50);
1673: begin
1674: l_code := upper(p_code);
1675: l_session_id := biv_core_pkg.get_session_id;
1676: if l_code = 'BIV_TMP_BIN' then
1677: execute immediate 'delete from BIV_TMP_BIN where
1678: session_id = :l_session_id or creation_date < sysdate -1 ' using l_session_id;
1679: elsif (l_code = 'BIV_TMP_RT1') then
1680: execute immediate 'delete from BIV_TMP_RT1 where

Line 1677: execute immediate 'delete from BIV_TMP_BIN where

1673: begin
1674: l_code := upper(p_code);
1675: l_session_id := biv_core_pkg.get_session_id;
1676: if l_code = 'BIV_TMP_BIN' then
1677: execute immediate 'delete from BIV_TMP_BIN where
1678: session_id = :l_session_id or creation_date < sysdate -1 ' using l_session_id;
1679: elsif (l_code = 'BIV_TMP_RT1') then
1680: execute immediate 'delete from BIV_TMP_RT1 where
1681: session_id = :l_session_id or creation_date < sysdate -1 ' using l_session_id;

Line 1695: execute immediate 'delete from BIV_TMP_BIN where

1691: elsif (l_code = 'BIV_TMP_SR_ARRVL') then
1692: execute immediate 'delete from BIV_TMP_SR_ARRVL where
1693: session_id = :l_session_id or creation_date < sysdate -1 ' using l_session_id;
1694: else
1695: execute immediate 'delete from BIV_TMP_BIN where
1696: session_id = :l_session_id or creation_date < sysdate -1 ' using l_session_id;
1697: execute immediate 'delete from BIV_TMP_RT1 where
1698: session_id = :l_session_id or creation_date < sysdate -1 ' using l_session_id;
1699: execute immediate 'delete from BIV_TMP_RT2 where

Line 1733: execute immediate 'delete from BIV_TMP_BIN where

1729: l_session_id := biv_core_pkg.get_session_id;
1730: if p_region IN ('BIV_BIN_SR',
1731: 'BIV_BIN_SR_ESCALATION',
1732: 'BIV_BIN_RESOURCE') then
1733: execute immediate 'delete from BIV_TMP_BIN where
1734: session_id = :l_session_id ' using l_session_id;
1735: elsif (p_region IN ('BIV_RT_CUS_BLOG',
1736: 'BIV_RT_SR_SUM_MONITOR',
1737: 'BIV_RT_SR_SEV',

Line 1772: delete from biv_tmp_bin where session_id = l_session_id;

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
1775: execute immediate 'delete from biv_debug where session_id = :l_session_id or creation_date < sysdate -1 ' using l_session_id;
1776: end if;