APPS.CZ_MIGRATE dependencies on ALL_TABLES

Line 221: FROM all_tables

217: ('OVERRIDE', 'SLOWREFRESH', 'MIGRATE', 'REFRESH', 'FORCESLOW', 'TRIGGERS', 'SEQUENCES');
218:
219: INSERT INTO cz_xfr_tables (order_seq, xfr_group, disabled, dst_table, pk_useexpansion)
220: SELECT ROWNUM, 'OVERRIDE', '0', table_name, DECODE(logging, 'YES', 'Y', 'NO', 'N', 'N')
221: FROM all_tables
222: WHERE owner = 'CZ';
223:
224: INSERT INTO cz_xfr_tables (order_seq, xfr_group, disabled, dst_table)
225: SELECT ROWNUM, 'TRIGGERS', '0', trigger_name

Line 476: xError := copy_all_tables(CommitSize, StopOnSkippable, AllowRefresh, ForceSlowMode, ForceProcess);

472:
473: EXECUTE IMMEDIATE 'ALTER TABLE ' || CONFIGURATOR_SCHEMA || '.' || c_tables.dst_table || ' NOLOGGING';
474: END LOOP;
475:
476: xError := copy_all_tables(CommitSize, StopOnSkippable, AllowRefresh, ForceSlowMode, ForceProcess);
477:
478: FOR c_tables IN (SELECT dst_table FROM cz_xfr_tables
479: WHERE xfr_group IN ('OVERRIDE', 'SLOWREFRESH', 'MIGRATE', 'REFRESH', 'FORCESLOW')
480: AND disabled = '0' AND pk_useexpansion = 'Y') LOOP

Line 1026: function copy_all_tables(inCommitSize in pls_integer,

1022: report(CZ_UTILS.GET_TEXT('CZ_MIGR_TABLE_ERROR', 'TABLENAME', inTableName, 'ERRORTEXT', SQLERRM), URGENCY_ERROR);
1023: return FATAL_ERROR;
1024: END copy_table_override;
1025: ------------------------------------------------------------------------------------------------------------
1026: function copy_all_tables(inCommitSize in pls_integer,
1027: inStopOnSkippable in number,
1028: inRefreshable in number,
1029: inForceSlowMode in number,
1030: inForceProcess in number)

Line 1862: TYPE tabTableName IS TABLE OF all_tables.table_name%TYPE;

1858: --adjust_specific_control procedure. Please review both procedures for any change.
1859:
1860: FUNCTION verify_target_database RETURN PLS_INTEGER IS
1861:
1862: TYPE tabTableName IS TABLE OF all_tables.table_name%TYPE;
1863:
1864: --A. Tsyaston 14-Oct-2004 BUG 3937232 - List revised.
1865: --These tables must be empty:
1866: