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.FND_GEN_MIG_CMDS dependencies on FND_TS_MIG_UTIL

Line 139: WHERE tablespace_type = fnd_ts_mig_util.l_def_ind_tsp;

135: IS
136: CURSOR idx_tbs_csr IS
137: SELECT tablespace
138: FROM fnd_tablespaces
139: WHERE tablespace_type = fnd_ts_mig_util.l_def_ind_tsp;
140: l_tablespace_name VARCHAR2(30);
141: BEGIN
142: OPEN idx_tbs_csr;
143: FETCH idx_tbs_csr INTO l_tablespace_name;

Line 158: if p_tablespace_type = fnd_ts_mig_util.l_def_tab_tsp then

154: RETURN VARCHAR2
155: IS
156: l_idx_tablespace VARCHAR2(30);
157: BEGIN
158: if p_tablespace_type = fnd_ts_mig_util.l_def_tab_tsp then
159: l_idx_tablespace := p_txn_idx_tablespace;
160: else
161: l_idx_tablespace := p_tab_tablespace;
162: end if;

Line 190: l_version := fnd_ts_mig_util.get_db_version;

186: AND segment_name = p_object_name
187: AND partition_name = p_partition_name;
188: BEGIN
189: if p_object_type = 'LOB PARTITION' then
190: l_version := fnd_ts_mig_util.get_db_version;
191: end if;
192:
193: if p_object_type = 'LOB PARTITION' AND l_version < 10 then
194: -- LOB PARTITIONS are not supported in DBMS_SPACE in 9i Bug# 2169303

Line 390: l_ues := fnd_ts_mig_util.get_tablespace_ues(p_new_tablespace);

386: l_lob_str := l_lob_str||', '||col_lob_rec.column_name;
387: end if;
388: END LOOP;
389:
390: l_ues := fnd_ts_mig_util.get_tablespace_ues(p_new_tablespace);
391: if l_ues IS NOT NULL then
392: l_storage_str := 'STORAGE (INITIAL '||TO_CHAR(l_ues)||' NEXT '||TO_CHAR(l_ues)||') ';
393: end if;
394:

Line 630: l_version := fnd_ts_mig_util.get_db_version;

626: if NVL(part_rec.partitioning_type, 'X') = 'HASH' OR NVL(part_rec.subpartitioning_type, 'X') = 'HASH'
627: then
628: l_storage_str := NULL;
629: l_logging_str := NULL;
630: l_version := fnd_ts_mig_util.get_db_version;
631: if l_version >= 10 then
632: l_chunk_str := '';
633: end if;
634: -- l_chunk_str := l_chunk_str || ')'; -- added Mladena

Line 893: l_ues := fnd_ts_mig_util.get_tablespace_ues(p_tablespace_name);

889: LOOP
890: --dbms_output.put_line('index name '||ind_rec.index_name);
891: l_lineno1 := null;
892: l_lineno2 := null;
893: l_ues := fnd_ts_mig_util.get_tablespace_ues(p_tablespace_name);
894: if l_ues IS NOT NULL then
895: l_storage_str := 'STORAGE (INITIAL '||TO_CHAR(l_ues)||' NEXT '||TO_CHAR(l_ues)||') ';
896: end if;
897:

Line 1100: l_tablespace_name := fnd_ts_mig_util.get_tablespace_name(fnd_ts_mig_util.l_def_ind_tsp);

1096:
1097: elsif ind_rec.index_type = 'DOMAIN' AND ind_rec.domidx_opstatus = 'VALID' AND ind_rec.domidx_status = 'VALID'
1098: then
1099: -- All Domain indexes go to transaction indexes tablespace.
1100: l_tablespace_name := fnd_ts_mig_util.get_tablespace_name(fnd_ts_mig_util.l_def_ind_tsp);
1101: if ind_rec.ityp_owner = 'CTXSYS'
1102: then
1103:
1104: l_query := 'SELECT 1

Line 1222: fnd_ts_mig_util.l_aq_tab_tsp tablespace_type,

1218:
1219: CURSOR aq_csr IS
1220: SELECT /*+ RULE */ dqt.owner owner,
1221: dqt.queue_table queue_table,
1222: fnd_ts_mig_util.l_aq_tab_tsp tablespace_type,
1223: ft.tablespace new_tablespace,
1224: dt.tablespace_name tablespace_name,
1225: dt.iot_type iot_type,
1226: dt.partitioned partitioned,

Line 1234: AND ft.tablespace_type = fnd_ts_mig_util.l_aq_tab_tsp

1230: fnd_tablespaces ft
1231: WHERE dqt.owner = p_owner
1232: AND dqt.owner = dt.owner
1233: AND dqt.queue_table = dt.table_name
1234: AND ft.tablespace_type = fnd_ts_mig_util.l_aq_tab_tsp
1235: AND dt.table_name NOT LIKE 'BIN$%'
1236: AND NVL(dt.temporary, 'N') = 'N';
1237:
1238: qry VARCHAR2(4000);

Line 1382: fnd_ts_mig_util.l_def_mv_tsp tablespace_type,

1378: CURSOR mvlog_csr IS
1379: SELECT /*+ RULE */ distinct dsl.log_owner log_owner,
1380: dsl.master master,
1381: dsl.log_table,
1382: fnd_ts_mig_util.l_def_mv_tsp tablespace_type,
1383: ft.tablespace new_tablespace,
1384: dt.tablespace_name,
1385: dt.iot_type,
1386: dt.partitioned,

Line 1395: AND ft.tablespace_type = fnd_ts_mig_util.l_def_mv_tsp

1391: WHERE dsl.log_owner = p_owner
1392: AND dsl.master = p_table_name
1393: AND dsl.log_owner = dt.owner
1394: AND dsl.log_table = dt.table_name
1395: AND ft.tablespace_type = fnd_ts_mig_util.l_def_mv_tsp
1396: AND dt.table_name NOT LIKE 'BIN$%'
1397: AND NVL(dt.temporary, 'N') = 'N';
1398:
1399: l_tab_moved BOOLEAN := FALSE;

Line 1473: fnd_ts_mig_util.l_def_mv_tsp tablespace_type,

1469: CURSOR mv_csr IS
1470: SELECT /*+ RULE */ ds.owner,
1471: ds.name,
1472: ds.table_name,
1473: fnd_ts_mig_util.l_def_mv_tsp tablespace_type,
1474: ft.tablespace new_tablespace,
1475: dt.tablespace_name,
1476: dt.iot_type,
1477: dt.partitioned,

Line 1486: AND ft.tablespace_type = fnd_ts_mig_util.l_def_mv_tsp

1482: WHERE ds.owner = p_owner
1483: AND ds.owner = dt.owner
1484: AND ds.table_name = dt.table_name
1485: AND dt.cluster_name IS NULL
1486: AND ft.tablespace_type = fnd_ts_mig_util.l_def_mv_tsp
1487: AND dt.table_name NOT LIKE 'BIN$%'
1488: AND NVL(dt.temporary, 'N') = 'N';
1489:
1490: CURSOR part_tsp_csr(l_owner VARCHAR2, l_table_name VARCHAR2, l_tablespace_name VARCHAR2) IS

Line 1697: fnd_ts_mig_util.l_unclass_tsp tablespace_type,

1693: UNION ALL
1694: -- all unclassified tables go to TRANSACTION_TABLE tablespace
1695: SELECT dt.owner,
1696: dt.table_name,
1697: fnd_ts_mig_util.l_unclass_tsp tablespace_type,
1698: ft.tablespace new_tablespace,
1699: dt.tablespace_name,
1700: dt.iot_type,
1701: dt.partitioned,

Line 1706: AND ft.tablespace_type = fnd_ts_mig_util.l_unclass_tsp

1702: dt.logging
1703: FROM dba_tables dt,
1704: fnd_tablespaces ft
1705: WHERE dt.owner = p_owner
1706: AND ft.tablespace_type = fnd_ts_mig_util.l_unclass_tsp
1707: AND dt.cluster_name IS NULL
1708: AND dt.table_name NOT LIKE 'BIN$%'
1709: AND EXISTS ( select dtc.table_name
1710: from dba_tab_columns dtc

Line 1943: fnd_ts_mig_util.l_unclass_tsp tablespace_type,

1939: -- all unclassified tables go to TRANSACTION_TABLES tablespace
1940: -- Not IOTs, AQs, Domain Index tables, MVs, MV logs
1941: SELECT dt.owner,
1942: dt.table_name,
1943: fnd_ts_mig_util.l_unclass_tsp tablespace_type,
1944: ft.tablespace new_tablespace,
1945: dt.tablespace_name,
1946: dt.iot_type,
1947: dt.partitioned,

Line 1952: AND ft.tablespace_type = fnd_ts_mig_util.l_unclass_tsp

1948: dt.logging
1949: FROM dba_tables dt,
1950: fnd_tablespaces ft
1951: WHERE dt.owner = p_owner
1952: AND ft.tablespace_type = fnd_ts_mig_util.l_unclass_tsp
1953: AND NOT EXISTS ( SELECT object_name
1954: FROM fnd_object_tablespaces fot
1955: WHERE fot.oracle_username = p_owner
1956: AND fot.object_type = 'TABLE'

Line 1994: fnd_ts_mig_util.l_def_tab_tsp tablespace_type,

1990: -- all IOTs go to TRANSACTION_TABLES (default rule)
1991: -- Not AQs, Domain Index tables
1992: SELECT dt.owner,
1993: dt.table_name,
1994: fnd_ts_mig_util.l_def_tab_tsp tablespace_type,
1995: ft.tablespace new_tablespace,
1996: di.tablespace_name,
1997: dt.iot_type,
1998: dt.partitioned,

Line 2004: AND ft.tablespace_type = fnd_ts_mig_util.l_def_tab_tsp

2000: FROM dba_tables dt,
2001: dba_indexes di,
2002: fnd_tablespaces ft
2003: WHERE dt.owner = p_owner
2004: AND ft.tablespace_type = fnd_ts_mig_util.l_def_tab_tsp
2005: AND dt.owner = di.table_owner
2006: AND dt.table_name = di.table_name
2007: AND di.index_type = 'IOT - TOP'
2008: AND NVL(dt.temporary, 'N') = 'N'