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_CMDS

Line 31: SELECT FND_TS_MIG_CMDS_S.nextval

27: p_parent_lineno IN NUMBER DEFAULT NULL,
28: x_lineno OUT NOCOPY NUMBER)
29: IS
30: CURSOR lineno_csr IS
31: SELECT FND_TS_MIG_CMDS_S.nextval
32: FROM SYS.dual;
33: l_lineno NUMBER;
34:
35: CURSOR cmd_csr IS

Line 41: FROM fnd_ts_mig_cmds

37: new_tablespace,
38: object_type,
39: subobject_type,
40: migration_status
41: FROM fnd_ts_mig_cmds
42: WHERE owner = p_owner
43: AND object_type = p_object_type
44: AND object_name = p_object_name
45: AND index_parallel = NVL(p_index_parallel, 'NOPARALLEL')

Line 61: UPDATE fnd_ts_mig_cmds

57: if p_object_type NOT IN ('ENABLE_TRIGGER', 'ENABLE_CONSTRAINT', 'DISABLE_TRIGGER', 'DISABLE_CONSTRAINT', 'STOP_QUEUE', 'START_QUEUE', 'ENABLE_POLICY', 'DISABLE_POLICY', 'POSTMIG')
58: then
59: if cmd_rec.migration_status IN ('GENERATED', 'ERROR')
60: then
61: UPDATE fnd_ts_mig_cmds
62: SET migration_cmd = p_mig_cmd,
63: new_tablespace = p_new_tablespace,
64: old_tablespace = p_old_tablespace,
65: total_blocks = p_tot_blocks,

Line 75: UPDATE fnd_ts_mig_cmds

71: WHERE lineno = cmd_rec.lineno;
72: l_generated := TRUE;
73: end if;
74: else
75: UPDATE fnd_ts_mig_cmds
76: SET migration_cmd = p_mig_cmd,
77: last_update_date = sysdate
78: WHERE lineno = cmd_rec.lineno;
79: l_generated := TRUE;

Line 91: INSERT INTO fnd_ts_mig_cmds (lineno,

87: OPEN lineno_csr;
88: FETCH lineno_csr INTO l_lineno;
89: CLOSE lineno_csr;
90:
91: INSERT INTO fnd_ts_mig_cmds (lineno,
92: owner,
93: object_type,
94: subobject_type,
95: index_parallel,

Line 333: l_obj_type FND_TS_MIG_CMDS.OBJECT_TYPE%TYPE;

329: WHERE table_owner = l_owner
330: AND table_name = l_table_name
331: AND partition_name = l_part_name;
332:
333: l_obj_type FND_TS_MIG_CMDS.OBJECT_TYPE%TYPE;
334: l_obj_name FND_TS_MIG_CMDS.OBJECT_NAME%TYPE := p_obj_name;
335: l_parent_owner FND_TS_MIG_CMDS.PARENT_OBJECT_NAME%TYPE := p_parent_owner;
336: l_parent_obj_name FND_TS_MIG_CMDS.PARENT_OBJECT_NAME%TYPE := p_parent_obj_name;
337: l_string VARCHAR2(4000);

Line 334: l_obj_name FND_TS_MIG_CMDS.OBJECT_NAME%TYPE := p_obj_name;

330: AND table_name = l_table_name
331: AND partition_name = l_part_name;
332:
333: l_obj_type FND_TS_MIG_CMDS.OBJECT_TYPE%TYPE;
334: l_obj_name FND_TS_MIG_CMDS.OBJECT_NAME%TYPE := p_obj_name;
335: l_parent_owner FND_TS_MIG_CMDS.PARENT_OBJECT_NAME%TYPE := p_parent_owner;
336: l_parent_obj_name FND_TS_MIG_CMDS.PARENT_OBJECT_NAME%TYPE := p_parent_obj_name;
337: l_string VARCHAR2(4000);
338: l_lob_str VARCHAR2(4000);

Line 335: l_parent_owner FND_TS_MIG_CMDS.PARENT_OBJECT_NAME%TYPE := p_parent_owner;

331: AND partition_name = l_part_name;
332:
333: l_obj_type FND_TS_MIG_CMDS.OBJECT_TYPE%TYPE;
334: l_obj_name FND_TS_MIG_CMDS.OBJECT_NAME%TYPE := p_obj_name;
335: l_parent_owner FND_TS_MIG_CMDS.PARENT_OBJECT_NAME%TYPE := p_parent_owner;
336: l_parent_obj_name FND_TS_MIG_CMDS.PARENT_OBJECT_NAME%TYPE := p_parent_obj_name;
337: l_string VARCHAR2(4000);
338: l_lob_str VARCHAR2(4000);
339: l_store_str VARCHAR2(4000);

Line 336: l_parent_obj_name FND_TS_MIG_CMDS.PARENT_OBJECT_NAME%TYPE := p_parent_obj_name;

332:
333: l_obj_type FND_TS_MIG_CMDS.OBJECT_TYPE%TYPE;
334: l_obj_name FND_TS_MIG_CMDS.OBJECT_NAME%TYPE := p_obj_name;
335: l_parent_owner FND_TS_MIG_CMDS.PARENT_OBJECT_NAME%TYPE := p_parent_owner;
336: l_parent_obj_name FND_TS_MIG_CMDS.PARENT_OBJECT_NAME%TYPE := p_parent_obj_name;
337: l_string VARCHAR2(4000);
338: l_lob_str VARCHAR2(4000);
339: l_store_str VARCHAR2(4000);
340: l_chunk_str VARCHAR2(4000);

Line 351: l_execution_mode FND_TS_MIG_CMDS.EXECUTION_MODE%TYPE := 'P';

347: l_tot_blocks NUMBER := 0;
348: l_sum_blocks NUMBER := 0;
349: l_lineno NUMBER;
350: l_parent_lineno NUMBER := p_parent_lineno;
351: l_execution_mode FND_TS_MIG_CMDS.EXECUTION_MODE%TYPE := 'P';
352: l_def_tablespace_name DBA_PART_TABLES.DEF_TABLESPACE_NAME%TYPE;
353: l_logging VARCHAR2(30) := 'YES';
354: l_version NUMBER;
355: BEGIN

Line 754: UPDATE fnd_ts_mig_cmds

750: -- Update the MV_LOG command with sum blocks
751: -- as the MV_LOG TRUNCATE is the parent which will be enqueued initially.
752: BEGIN
753: if p_obj_type = 'TABLE' then
754: UPDATE fnd_ts_mig_cmds
755: SET total_blocks = l_sum_blocks,
756: execution_mode = l_execution_mode
757: WHERE owner = p_owner
758: AND object_type = 'MV_LOG'

Line 879: l_execution_mode FND_TS_MIG_CMDS.EXECUTION_MODE%TYPE := nvl(p_execution_mode, 'P');

875: l_tot_blocks NUMBER := 0;
876: l_lineno1 NUMBER;
877: l_lineno2 NUMBER;
878: l_lineno3 NUMBER;
879: l_execution_mode FND_TS_MIG_CMDS.EXECUTION_MODE%TYPE := nvl(p_execution_mode, 'P');
880: -- l_parent_exec_mode FND_TS_MIG_CMDS.EXECUTION_MODE%TYPE := p_execution_mode;
881: l_parent_lineno NUMBER := p_parent_lineno;
882: l_def_tablespace_name DBA_PART_INDEXES.DEF_TABLESPACE_NAME%TYPE;
883: l_tablespace_name FND_TABLESPACES.TABLESPACE%TYPE;

Line 880: -- l_parent_exec_mode FND_TS_MIG_CMDS.EXECUTION_MODE%TYPE := p_execution_mode;

876: l_lineno1 NUMBER;
877: l_lineno2 NUMBER;
878: l_lineno3 NUMBER;
879: l_execution_mode FND_TS_MIG_CMDS.EXECUTION_MODE%TYPE := nvl(p_execution_mode, 'P');
880: -- l_parent_exec_mode FND_TS_MIG_CMDS.EXECUTION_MODE%TYPE := p_execution_mode;
881: l_parent_lineno NUMBER := p_parent_lineno;
882: l_def_tablespace_name DBA_PART_INDEXES.DEF_TABLESPACE_NAME%TYPE;
883: l_tablespace_name FND_TABLESPACES.TABLESPACE%TYPE;
884: l_part NUMBER;

Line 1253: l_execution_mode FND_TS_MIG_CMDS.EXECUTION_MODE%TYPE;

1249: child_aq_rec child_aq_rec_type;
1250: l_tab_moved BOOLEAN := FALSE;
1251: l_lineno NUMBER;
1252: l_child_lineno NUMBER;
1253: l_execution_mode FND_TS_MIG_CMDS.EXECUTION_MODE%TYPE;
1254:
1255: BEGIN
1256: OPEN aq_csr;
1257: LOOP

Line 1402: l_execution_mode FND_TS_MIG_CMDS.EXECUTION_MODE%TYPE;

1398:
1399: l_tab_moved BOOLEAN := FALSE;
1400: l_string VARCHAR2(4000);
1401: l_lineno NUMBER;
1402: l_execution_mode FND_TS_MIG_CMDS.EXECUTION_MODE%TYPE;
1403:
1404: BEGIN
1405: OPEN mvlog_csr;
1406: LOOP

Line 1502: l_parent_owner FND_TS_MIG_CMDS.PARENT_OWNER%TYPE;

1498: l_tab_moved BOOLEAN := FALSE;
1499: l_string VARCHAR2(4000);
1500: l_parent_lineno NUMBER;
1501: l_lineno NUMBER;
1502: l_parent_owner FND_TS_MIG_CMDS.PARENT_OWNER%TYPE;
1503: l_parent_obj_name FND_TS_MIG_CMDS.PARENT_OBJECT_NAME%TYPE;
1504: l_execution_mode FND_TS_MIG_CMDS.EXECUTION_MODE%TYPE;
1505:
1506: BEGIN

Line 1503: l_parent_obj_name FND_TS_MIG_CMDS.PARENT_OBJECT_NAME%TYPE;

1499: l_string VARCHAR2(4000);
1500: l_parent_lineno NUMBER;
1501: l_lineno NUMBER;
1502: l_parent_owner FND_TS_MIG_CMDS.PARENT_OWNER%TYPE;
1503: l_parent_obj_name FND_TS_MIG_CMDS.PARENT_OBJECT_NAME%TYPE;
1504: l_execution_mode FND_TS_MIG_CMDS.EXECUTION_MODE%TYPE;
1505:
1506: BEGIN
1507: OPEN mv_csr;

Line 1504: l_execution_mode FND_TS_MIG_CMDS.EXECUTION_MODE%TYPE;

1500: l_parent_lineno NUMBER;
1501: l_lineno NUMBER;
1502: l_parent_owner FND_TS_MIG_CMDS.PARENT_OWNER%TYPE;
1503: l_parent_obj_name FND_TS_MIG_CMDS.PARENT_OBJECT_NAME%TYPE;
1504: l_execution_mode FND_TS_MIG_CMDS.EXECUTION_MODE%TYPE;
1505:
1506: BEGIN
1507: OPEN mv_csr;
1508: LOOP

Line 1721: SELECT fnd_ts_mig_cmds_s.nextval from dual;

1717: AND fot.object_type = 'TABLE'
1718: AND fot.object_name = dt.table_name);
1719:
1720: CURSOR c1 IS
1721: SELECT fnd_ts_mig_cmds_s.nextval from dual;
1722: l_seq NUMBER;
1723: l_stag_tab_name VARCHAR2(30);
1724:
1725: l_idx_tablespace VARCHAR2(30);

Line 1737: l_execution_mode FND_TS_MIG_CMDS.EXECUTION_MODE%TYPE;

1733: l_lineno3 NUMBER;
1734: l_lineno4 NUMBER;
1735: l_lineno5 NUMBER;
1736: l_lineno6 NUMBER;
1737: l_execution_mode FND_TS_MIG_CMDS.EXECUTION_MODE%TYPE;
1738: l_parent_owner VARCHAR2(30);
1739: l_parent_obj_name VARCHAR2(30);
1740:
1741: BEGIN

Line 2039: l_parent_owner FND_TS_MIG_CMDS.PARENT_OWNER%TYPE;

2035: l_txn_idx_tablespace VARCHAR2(30) := get_txn_idx_tablespace;
2036: l_tab_moved BOOLEAN := FALSE;
2037: l_lineno NUMBER;
2038: l_parent_lineno NUMBER;
2039: l_parent_owner FND_TS_MIG_CMDS.PARENT_OWNER%TYPE;
2040: l_parent_obj_name FND_TS_MIG_CMDS.PARENT_OBJECT_NAME%TYPE;
2041: l_execution_mode FND_TS_MIG_CMDS.EXECUTION_MODE%TYPE;
2042:
2043: BEGIN

Line 2040: l_parent_obj_name FND_TS_MIG_CMDS.PARENT_OBJECT_NAME%TYPE;

2036: l_tab_moved BOOLEAN := FALSE;
2037: l_lineno NUMBER;
2038: l_parent_lineno NUMBER;
2039: l_parent_owner FND_TS_MIG_CMDS.PARENT_OWNER%TYPE;
2040: l_parent_obj_name FND_TS_MIG_CMDS.PARENT_OBJECT_NAME%TYPE;
2041: l_execution_mode FND_TS_MIG_CMDS.EXECUTION_MODE%TYPE;
2042:
2043: BEGIN
2044:

Line 2041: l_execution_mode FND_TS_MIG_CMDS.EXECUTION_MODE%TYPE;

2037: l_lineno NUMBER;
2038: l_parent_lineno NUMBER;
2039: l_parent_owner FND_TS_MIG_CMDS.PARENT_OWNER%TYPE;
2040: l_parent_obj_name FND_TS_MIG_CMDS.PARENT_OBJECT_NAME%TYPE;
2041: l_execution_mode FND_TS_MIG_CMDS.EXECUTION_MODE%TYPE;
2042:
2043: BEGIN
2044:
2045: OPEN tab_csr;

Line 2283: SELECT FND_TS_MIG_CMDS_S.nextval

2279:
2280: PROCEDURE gen_postmig_cmd (p_schema IN VARCHAR2)
2281: IS
2282: CURSOR lineno_csr IS
2283: SELECT FND_TS_MIG_CMDS_S.nextval
2284: FROM SYS.dual;
2285: l_lineno NUMBER;
2286:
2287: CURSOR cmd_csr IS

Line 2289: FROM fnd_ts_mig_cmds

2285: l_lineno NUMBER;
2286:
2287: CURSOR cmd_csr IS
2288: SELECT lineno, subobject_type
2289: FROM fnd_ts_mig_cmds
2290: WHERE object_type = 'POSTMIG'
2291: AND object_name = 'AQ_TM_PROCESSES';
2292:
2293: CURSOR aq_tm_csr IS

Line 2315: INSERT INTO fnd_ts_mig_cmds (lineno,

2311: FETCH lineno_csr INTO l_lineno;
2312: CLOSE lineno_csr;
2313:
2314: l_string := 'ALTER SYSTEM SET AQ_TM_PROCESSES = '||l_value2;
2315: INSERT INTO fnd_ts_mig_cmds (lineno,
2316: owner,
2317: object_type,
2318: subobject_type,
2319: index_parallel,

Line 2341: UPDATE fnd_ts_mig_cmds

2337: sysdate,
2338: sysdate);
2339: elsif NVL(l_value2, 0) <> 0 AND l_value1 <> l_value2 then
2340: l_string := 'ALTER SYSTEM SET AQ_TM_PROCESSES = '||l_value2;
2341: UPDATE fnd_ts_mig_cmds
2342: SET migration_cmd = l_string,
2343: subobject_type = l_value2,
2344: generation_date = sysdate,
2345: last_update_date = sysdate