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_RT1

Line 1679: elsif (l_code = 'BIV_TMP_RT1') then

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;
1682: elsif (l_code = 'BIV_TMP_RT2') then
1683: execute immediate 'delete from BIV_TMP_RT2 where

Line 1680: execute immediate 'delete from BIV_TMP_RT1 where

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;
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;

Line 1697: execute immediate 'delete from BIV_TMP_RT1 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
1700: session_id = :l_session_id or creation_date < sysdate -1 ' using l_session_id;
1701: execute immediate 'delete from BIV_TMP_HS2 where

Line 1740: execute immediate 'delete from BIV_TMP_RT1 where

1736: 'BIV_RT_SR_SUM_MONITOR',
1737: 'BIV_RT_SR_SEV',
1738: 'BIV_RT_ESC_SR',
1739: 'BIV_RT_CUS_BLOG_DD')) then
1740: execute immediate 'delete from BIV_TMP_RT1 where
1741: session_id = :l_session_id ' using l_session_id;
1742: elsif (p_region IN ('BIV_RT_AGENT_REPORT',
1743: 'BIV_RT_MANAGER_REPORT',
1744: 'BIV_RT_BACKLOG_BY_STATUS',

Line 1768: delete from biv_tmp_rt1 where session_id = l_session_id;

1764: 'BIV_HS_SR_ARRIVAL_PRD')) then
1765: execute immediate 'delete from BIV_TMP_SR_ARRVL where
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;