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.EDW_COLLECTION_UTIL dependencies on DBA_TABLES

Line 1710: FROM dba_tables

1706:
1707: CURSOR c_check_tbl (p_tbl_name IN VARCHAR2)
1708: IS
1709: SELECT 1
1710: FROM dba_tables
1711: WHERE table_name = p_tbl_name AND owner = g_bis_schema;
1712: BEGIN
1713: put_debug_msg ('********** Start Procedure : clean_up');
1714:

Line 1922: OPEN cv FOR 'select initial_extent from dba_tablespaces where tablespace_name= :t'

1918: END IF;
1919:
1920: IF l_edw_extent = 0
1921: THEN
1922: OPEN cv FOR 'select initial_extent from dba_tablespaces where tablespace_name= :t'
1923: USING g_op_tablespace;
1924: FETCH cv INTO l_edw_extent;
1925: CLOSE cv;
1926: END IF;

Line 2017: OPEN cv FOR 'select initial_extent, next_extent, partitioned from dba_tables where table_name= :t and owner =:o'

2013: 'Starting Data Transportation Process using Temporary Tables '
2014: );
2015: put_timestamp;
2016: --partitioned column added for bug 4300166
2017: OPEN cv FOR 'select initial_extent, next_extent, partitioned from dba_tables where table_name= :t and owner =:o'
2018: USING l_stgtbl_name, l_stg_owner;
2019: FETCH cv INTO l_stg_initial_extent, l_stg_next_extent,l_partitioned_table;
2020: CLOSE cv;
2021:

Line 2023: ----case 1 partitioned table, both intial and next extent are null in dba tables

2019: FETCH cv INTO l_stg_initial_extent, l_stg_next_extent,l_partitioned_table;
2020: CLOSE cv;
2021:
2022: --code added for bug fix 4300166
2023: ----case 1 partitioned table, both intial and next extent are null in dba tables
2024: IF((l_stg_initial_extent is null and l_stg_next_extent is null)
2025: and l_partitioned_table = 'YES') THEN
2026: l_stg_initial_extent := l_edw_extent;
2027: l_stg_next_extent := l_edw_extent;

Line 2029: ---case 2 locally managed tablespaces, next extent can be null in dba_tables

2025: and l_partitioned_table = 'YES') THEN
2026: l_stg_initial_extent := l_edw_extent;
2027: l_stg_next_extent := l_edw_extent;
2028: ELSE IF(l_stg_initial_extent is not null and l_stg_next_extent is null) THEN
2029: ---case 2 locally managed tablespaces, next extent can be null in dba_tables
2030: l_stg_next_extent := l_stg_initial_extent;
2031: END IF;
2032: END IF;
2033: