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_TS_MIG_UTIL dependencies on FND_OBJECT_TABLESPACES

Line 135: FROM fnd_object_tablespaces;

131: l_cnt NUMBER;
132: BEGIN
133: SELECT COUNT(1)
134: INTO l_cnt
135: FROM fnd_object_tablespaces;
136: if l_cnt = 0 then
137: raise_application_error(-20001, 'Object classification does not exist in FND_OBJECT_TABLESPACES.');
138: end if;
139:

Line 137: raise_application_error(-20001, 'Object classification does not exist in FND_OBJECT_TABLESPACES.');

133: SELECT COUNT(1)
134: INTO l_cnt
135: FROM fnd_object_tablespaces;
136: if l_cnt = 0 then
137: raise_application_error(-20001, 'Object classification does not exist in FND_OBJECT_TABLESPACES.');
138: end if;
139:
140: SELECT COUNT(1)
141: INTO l_cnt

Line 245: UPDATE fnd_object_tablespaces fot

241: END crt_storage_pref;
242:
243: PROCEDURE upd_fot_username IS
244: BEGIN
245: UPDATE fnd_object_tablespaces fot
246: SET oracle_username = (select fou.oracle_username
247: from fnd_product_installations fpi,
248: fnd_oracle_userid fou
249: where fpi.oracle_id = fou.oracle_id

Line 273: fnd_object_tablespaces fot

269: fot.tablespace_type,
270: fot.custom_tablespace_type,
271: fot.custom_flag
272: FROM dba_tables dt,
273: fnd_object_tablespaces fot
274: WHERE dt.table_name like l_table_name||'%'
275: AND fot.oracle_username(+) = dt.owner
276: AND fot.object_name(+) = dt.table_name
277: -- AND NVL(dt.iot_type, 'X') NOT IN ('IOT', 'IOT_OVERFLOW')

Line 298: l_tablespace_type FND_OBJECT_TABLESPACES.TABLESPACE_TYPE%TYPE;

294: ORDER BY dt.owner;
295: l_owner DBA_TABLES.OWNER%TYPE;
296: l_last_owner DBA_TABLES.OWNER%TYPE;
297: l_table_name DBA_TABLES.TABLE_NAME%TYPE;
298: l_tablespace_type FND_OBJECT_TABLESPACES.TABLESPACE_TYPE%TYPE;
299: l_custom_tsp_type FND_OBJECT_TABLESPACES.TABLESPACE_TYPE%TYPE;
300: l_custom_flag FND_OBJECT_TABLESPACES.CUSTOM_FLAG%TYPE;
301: l_object_source FND_OBJECT_TABLESPACES.OBJECT_SOURCE%TYPE;
302: l_rowid ROWID;

Line 299: l_custom_tsp_type FND_OBJECT_TABLESPACES.TABLESPACE_TYPE%TYPE;

295: l_owner DBA_TABLES.OWNER%TYPE;
296: l_last_owner DBA_TABLES.OWNER%TYPE;
297: l_table_name DBA_TABLES.TABLE_NAME%TYPE;
298: l_tablespace_type FND_OBJECT_TABLESPACES.TABLESPACE_TYPE%TYPE;
299: l_custom_tsp_type FND_OBJECT_TABLESPACES.TABLESPACE_TYPE%TYPE;
300: l_custom_flag FND_OBJECT_TABLESPACES.CUSTOM_FLAG%TYPE;
301: l_object_source FND_OBJECT_TABLESPACES.OBJECT_SOURCE%TYPE;
302: l_rowid ROWID;
303:

Line 300: l_custom_flag FND_OBJECT_TABLESPACES.CUSTOM_FLAG%TYPE;

296: l_last_owner DBA_TABLES.OWNER%TYPE;
297: l_table_name DBA_TABLES.TABLE_NAME%TYPE;
298: l_tablespace_type FND_OBJECT_TABLESPACES.TABLESPACE_TYPE%TYPE;
299: l_custom_tsp_type FND_OBJECT_TABLESPACES.TABLESPACE_TYPE%TYPE;
300: l_custom_flag FND_OBJECT_TABLESPACES.CUSTOM_FLAG%TYPE;
301: l_object_source FND_OBJECT_TABLESPACES.OBJECT_SOURCE%TYPE;
302: l_rowid ROWID;
303:
304: CURSOR app_csr(l_oracle_username VARCHAR2) IS

Line 301: l_object_source FND_OBJECT_TABLESPACES.OBJECT_SOURCE%TYPE;

297: l_table_name DBA_TABLES.TABLE_NAME%TYPE;
298: l_tablespace_type FND_OBJECT_TABLESPACES.TABLESPACE_TYPE%TYPE;
299: l_custom_tsp_type FND_OBJECT_TABLESPACES.TABLESPACE_TYPE%TYPE;
300: l_custom_flag FND_OBJECT_TABLESPACES.CUSTOM_FLAG%TYPE;
301: l_object_source FND_OBJECT_TABLESPACES.OBJECT_SOURCE%TYPE;
302: l_rowid ROWID;
303:
304: CURSOR app_csr(l_oracle_username VARCHAR2) IS
305: SELECT fpi.application_id

Line 339: FND_OBJECT_TABLESPACES_PKG.INSERT_ROW

335: end if;
336: end if;
337:
338: if l_tablespace_type IS NULL then
339: FND_OBJECT_TABLESPACES_PKG.INSERT_ROW
340: (l_rowid,
341: l_app_id,
342: l_table_name,
343: 'TABLE',

Line 355: FND_OBJECT_TABLESPACES_PKG.UPDATE_ROW

351: SYSDATE,
352: g_user_id,
353: g_login_id);
354: elsif NVL(l_object_source, 'X') = 'RULES' and l_tablespace_type <> gl_rec.tablespace_type then
355: FND_OBJECT_TABLESPACES_PKG.UPDATE_ROW
356: (l_app_id,
357: l_table_name,
358: 'TABLE',
359: gl_rec.tablespace_type,

Line 387: l_tablespace_type FND_OBJECT_TABLESPACES.TABLESPACE_TYPE%TYPE;

383: rules_tab_csr rules_tab_csr_type;
384: l_owner DBA_TABLES.OWNER%TYPE;
385: l_last_owner DBA_TABLES.OWNER%TYPE;
386: l_table_name DBA_TABLES.TABLE_NAME%TYPE;
387: l_tablespace_type FND_OBJECT_TABLESPACES.TABLESPACE_TYPE%TYPE;
388: l_custom_tsp_type FND_OBJECT_TABLESPACES.TABLESPACE_TYPE%TYPE;
389: l_custom_flag FND_OBJECT_TABLESPACES.CUSTOM_FLAG%TYPE;
390: l_object_source FND_OBJECT_TABLESPACES.OBJECT_SOURCE%TYPE;
391: l_rowid ROWID;

Line 388: l_custom_tsp_type FND_OBJECT_TABLESPACES.TABLESPACE_TYPE%TYPE;

384: l_owner DBA_TABLES.OWNER%TYPE;
385: l_last_owner DBA_TABLES.OWNER%TYPE;
386: l_table_name DBA_TABLES.TABLE_NAME%TYPE;
387: l_tablespace_type FND_OBJECT_TABLESPACES.TABLESPACE_TYPE%TYPE;
388: l_custom_tsp_type FND_OBJECT_TABLESPACES.TABLESPACE_TYPE%TYPE;
389: l_custom_flag FND_OBJECT_TABLESPACES.CUSTOM_FLAG%TYPE;
390: l_object_source FND_OBJECT_TABLESPACES.OBJECT_SOURCE%TYPE;
391: l_rowid ROWID;
392: CURSOR app_csr(l_oracle_username VARCHAR2) IS

Line 389: l_custom_flag FND_OBJECT_TABLESPACES.CUSTOM_FLAG%TYPE;

385: l_last_owner DBA_TABLES.OWNER%TYPE;
386: l_table_name DBA_TABLES.TABLE_NAME%TYPE;
387: l_tablespace_type FND_OBJECT_TABLESPACES.TABLESPACE_TYPE%TYPE;
388: l_custom_tsp_type FND_OBJECT_TABLESPACES.TABLESPACE_TYPE%TYPE;
389: l_custom_flag FND_OBJECT_TABLESPACES.CUSTOM_FLAG%TYPE;
390: l_object_source FND_OBJECT_TABLESPACES.OBJECT_SOURCE%TYPE;
391: l_rowid ROWID;
392: CURSOR app_csr(l_oracle_username VARCHAR2) IS
393: SELECT fpi.application_id

Line 390: l_object_source FND_OBJECT_TABLESPACES.OBJECT_SOURCE%TYPE;

386: l_table_name DBA_TABLES.TABLE_NAME%TYPE;
387: l_tablespace_type FND_OBJECT_TABLESPACES.TABLESPACE_TYPE%TYPE;
388: l_custom_tsp_type FND_OBJECT_TABLESPACES.TABLESPACE_TYPE%TYPE;
389: l_custom_flag FND_OBJECT_TABLESPACES.CUSTOM_FLAG%TYPE;
390: l_object_source FND_OBJECT_TABLESPACES.OBJECT_SOURCE%TYPE;
391: l_rowid ROWID;
392: CURSOR app_csr(l_oracle_username VARCHAR2) IS
393: SELECT fpi.application_id
394: FROM fnd_product_installations fpi,

Line 409: FROM dba_tables dt, fnd_object_tablespaces fot

405: LOOP
406: query := 'SELECT dt.owner, dt.table_name, fot.object_source,
407: fot.tablespace_type, fot.custom_tablespace_type,
408: fot.custom_flag
409: FROM dba_tables dt, fnd_object_tablespaces fot
410: '||rules_rec.rule_query||'
411: AND fot.oracle_username(+) = dt.owner
412: AND fot.object_name(+) = dt.table_name
413: AND NVL(dt.iot_type, ''X'') NOT IN (''IOT'', ''IOT_OVERFLOW'')

Line 459: FND_OBJECT_TABLESPACES_PKG.INSERT_ROW

455: end if;
456: end if;
457:
458: if l_tablespace_type IS NULL then
459: FND_OBJECT_TABLESPACES_PKG.INSERT_ROW
460: (l_rowid,
461: l_app_id,
462: l_table_name,
463: 'TABLE',

Line 475: FND_OBJECT_TABLESPACES_PKG.UPDATE_ROW

471: SYSDATE,
472: g_user_id,
473: g_login_id);
474: elsif NVL(l_object_source, 'X') = 'RULES' and l_tablespace_type <> rules_rec.tablespace_type then
475: FND_OBJECT_TABLESPACES_PKG.UPDATE_ROW
476: (l_app_id,
477: l_table_name,
478: 'TABLE',
479: rules_rec.tablespace_type,