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.

[Home] [Help]

APPS.BIV_CORE_PKG dependencies on BIV_TMP_HS2

Line 1688: elsif (l_code = 'BIV_TMP_HS2') then

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;
1691: elsif (l_code = 'BIV_TMP_SR_ARRVL') then
1692: execute immediate 'delete from BIV_TMP_SR_ARRVL where

Line 1689: execute immediate 'delete from BIV_TMP_HS2 where

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

Line 1701: execute immediate 'delete from BIV_TMP_HS2 where

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
1702: session_id = :l_session_id or creation_date < sysdate -1 ' using l_session_id;
1703: execute immediate 'delete from BIV_TMP_SR_ARRVL where
1704: session_id = :l_session_id or creation_date < sysdate -1 ' using l_session_id;
1705: end if;

Line 1760: execute immediate 'delete from BIV_TMP_HS2 where

1756: 'BIV_HS_SR_ACTIVITY',
1757: 'BIV_HS_EACALATION_VIEW',
1758: 'BIV_SERVICE_REQUEST',
1759: 'BIV_RT_SR_AGE_REPORT')) then
1760: execute immediate 'delete from BIV_TMP_HS2 where
1761: session_id = :l_session_id ' using l_session_id;
1762: elsif (p_region IN ('BIV_TMP_SR_ARRVL',
1763: 'BIV_HS_SR_ARRIVAL_TM',
1764: 'BIV_HS_SR_ARRIVAL_PRD')) then

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