APPS.BIV_CORE_PKG dependencies on BIV_TMP_RT2

Line 1318: l_session_id biv_tmp_rt2.session_id % type;

1314: procedure update_base_col_desc(p_tbl_name varchar2 /*default null*/) is
1315: l_tbl varchar2(30);
1316: l_sql varchar2(500);
1317: l_err varchar2(250);
1318: l_session_id biv_tmp_rt2.session_id % type;
1319: l_null_desc fnd_lookups.meaning % type;
1320: begin
1321: l_session_id := biv_core_pkg.get_session_id;
1322: l_tbl := nvl(p_tbl_name,'jtfb_temp_report');

Line 1682: elsif (l_code = 'BIV_TMP_RT2') then

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;
1685: elsif (l_code = 'BIV_TMP_HS1') then
1686: execute immediate 'delete from BIV_TMP_HS1 where

Line 1683: execute immediate 'delete from BIV_TMP_RT2 where

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

Line 1699: execute immediate 'delete from BIV_TMP_RT2 where

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

Line 1749: execute immediate 'delete from BIV_TMP_RT2 where

1745: 'BIV_RT_TASK_ACTIVITY',
1746: 'BIV_TASK_SUMMARY',
1747: 'BIV_RELATED_TASK',
1748: 'BIV_SERVICE_REQUEST')) then
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

Line 1769: delete from biv_tmp_rt2 where session_id = l_session_id;

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;
1773: end if;