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.CZ_MIGRATE dependencies on CZ_DB_SETTINGS

Line 125: MigrationStatus cz_db_settings.value%TYPE;

121: RETURN INTEGER IS
122:
123: xError INTEGER;
124: errorFlag PLS_INTEGER;
125: MigrationStatus cz_db_settings.value%TYPE;
126: BEGIN
127:
128: thisMessageId := MESSAGE_START_ID;
129: thisStatusCode := SETUP_STATUS_CODE;

Line 167: SELECT value INTO MigrationStatus FROM cz_db_settings

163:
164: DBMS_APPLICATION_INFO.SET_MODULE('CZMIGRATION', TO_CHAR(x_run_id));
165:
166: BEGIN
167: SELECT value INTO MigrationStatus FROM cz_db_settings
168: WHERE UPPER(section_name) = 'MIGRATE' AND UPPER(setting_id) = 'MIGRATIONSTATUS';
169: EXCEPTION
170: WHEN NO_DATA_FOUND THEN
171: --No setting is normal.

Line 253: INSERT INTO cz_db_settings (section_name, setting_id, data_type, value)

249:
250: IF(errorFlag = 1)THEN ROLLBACK; RETURN FATAL_ERROR; END IF;
251:
252: BEGIN
253: INSERT INTO cz_db_settings (section_name, setting_id, data_type, value)
254: SELECT 'MIGRATE', 'SourceServer', 4, p_local_name FROM DUAL WHERE NOT EXISTS
255: (SELECT NULL FROM cz_db_settings
256: WHERE UPPER(section_name) = 'MIGRATE' and UPPER(setting_id) = 'SOURCESERVER');
257:

Line 255: (SELECT NULL FROM cz_db_settings

251:
252: BEGIN
253: INSERT INTO cz_db_settings (section_name, setting_id, data_type, value)
254: SELECT 'MIGRATE', 'SourceServer', 4, p_local_name FROM DUAL WHERE NOT EXISTS
255: (SELECT NULL FROM cz_db_settings
256: WHERE UPPER(section_name) = 'MIGRATE' and UPPER(setting_id) = 'SOURCESERVER');
257:
258: UPDATE cz_db_settings SET value = p_local_name
259: WHERE UPPER(section_name) = 'MIGRATE' AND UPPER(setting_id) = 'SOURCESERVER';

Line 258: UPDATE cz_db_settings SET value = p_local_name

254: SELECT 'MIGRATE', 'SourceServer', 4, p_local_name FROM DUAL WHERE NOT EXISTS
255: (SELECT NULL FROM cz_db_settings
256: WHERE UPPER(section_name) = 'MIGRATE' and UPPER(setting_id) = 'SOURCESERVER');
257:
258: UPDATE cz_db_settings SET value = p_local_name
259: WHERE UPPER(section_name) = 'MIGRATE' AND UPPER(setting_id) = 'SOURCESERVER';
260:
261: INSERT INTO cz_db_settings (section_name, setting_id, data_type, value)
262: SELECT 'MIGRATE', 'MigrationStatus', 4, 'INSTALLED' FROM DUAL WHERE NOT EXISTS

Line 261: INSERT INTO cz_db_settings (section_name, setting_id, data_type, value)

257:
258: UPDATE cz_db_settings SET value = p_local_name
259: WHERE UPPER(section_name) = 'MIGRATE' AND UPPER(setting_id) = 'SOURCESERVER';
260:
261: INSERT INTO cz_db_settings (section_name, setting_id, data_type, value)
262: SELECT 'MIGRATE', 'MigrationStatus', 4, 'INSTALLED' FROM DUAL WHERE NOT EXISTS
263: (SELECT NULL FROM cz_db_settings
264: WHERE UPPER(section_name) = 'MIGRATE' and UPPER(setting_id) = 'MIGRATIONSTATUS');
265:

Line 263: (SELECT NULL FROM cz_db_settings

259: WHERE UPPER(section_name) = 'MIGRATE' AND UPPER(setting_id) = 'SOURCESERVER';
260:
261: INSERT INTO cz_db_settings (section_name, setting_id, data_type, value)
262: SELECT 'MIGRATE', 'MigrationStatus', 4, 'INSTALLED' FROM DUAL WHERE NOT EXISTS
263: (SELECT NULL FROM cz_db_settings
264: WHERE UPPER(section_name) = 'MIGRATE' and UPPER(setting_id) = 'MIGRATIONSTATUS');
265:
266: UPDATE cz_db_settings SET value = 'INSTALLED'
267: WHERE UPPER(section_name) = 'MIGRATE' AND UPPER(setting_id) = 'MIGRATIONSTATUS';

Line 266: UPDATE cz_db_settings SET value = 'INSTALLED'

262: SELECT 'MIGRATE', 'MigrationStatus', 4, 'INSTALLED' FROM DUAL WHERE NOT EXISTS
263: (SELECT NULL FROM cz_db_settings
264: WHERE UPPER(section_name) = 'MIGRATE' and UPPER(setting_id) = 'MIGRATIONSTATUS');
265:
266: UPDATE cz_db_settings SET value = 'INSTALLED'
267: WHERE UPPER(section_name) = 'MIGRATE' AND UPPER(setting_id) = 'MIGRATIONSTATUS';
268:
269: COMMIT;
270:

Line 308: MigrationStatus cz_db_settings.value%TYPE;

304: xMsgCount INTEGER;
305: xReturnStatus VARCHAR2(255);
306: xMsgData VARCHAR2(32000);
307:
308: MigrationStatus cz_db_settings.value%TYPE;
309: sourceMaxId cz_servers.server_local_id%TYPE;
310: targetMaxId cz_servers.server_local_id%TYPE;
311: srcPbSessionCnt NUMBER := 0;
312: l_src_sessn_cur REF_CURSOR;

Line 354: SELECT value INTO MigrationStatus FROM cz_db_settings

350:
351: DBMS_APPLICATION_INFO.SET_MODULE('CZMIGRATION', TO_CHAR(x_run_id));
352:
353: BEGIN
354: SELECT value INTO MigrationStatus FROM cz_db_settings
355: WHERE UPPER(section_name) = 'MIGRATE' AND UPPER(setting_id) = 'MIGRATIONSTATUS';
356: EXCEPTION
357: WHEN NO_DATA_FOUND THEN
358: --'Unable to read the migration status, no record exists. Please make sure the migration setup

Line 369: SELECT value INTO serverLocalName FROM cz_db_settings

365: RETURN FATAL_ERROR;
366: END;
367:
368: BEGIN
369: SELECT value INTO serverLocalName FROM cz_db_settings
370: WHERE UPPER(section_name) = 'MIGRATE' and UPPER(setting_id) = 'SOURCESERVER';
371: EXCEPTION
372: WHEN NO_DATA_FOUND THEN
373: --'Unable to read the source server name, no record exists. Please make sure the migration setup

Line 413: update cz_db_settings set value = 'STARTED'

409: RETURN FATAL_ERROR;
410: END;
411:
412: begin
413: update cz_db_settings set value = 'STARTED'
414: where UPPER(section_name) = 'MIGRATE' and UPPER(setting_id) = 'MIGRATIONSTATUS';
415: exception
416: when others then
417: --'Unable to update the migration status because of %ERRORTEXT.'

Line 576: update cz_db_settings set value='COMPLETED'

572: EXECUTE IMMEDIATE
573: 'begin DBMS_APPLICATION_INFO.SET_MODULE@'||dbLinkName||'(:1, :2); end;' USING '','' ;
574:
575: begin
576: update cz_db_settings set value='COMPLETED'
577: where section_name='MIGRATE' and setting_id='MigrationStatus';
578: exception
579: when others then
580: --'Migration was unable to update the migration status because of %ERRORTEXT.'

Line 607: tMajorVersion cz_db_settings.value%TYPE;

603: end;
604: ------------------------------------------------------------------------------------------------------------
605: FUNCTION compare_versions RETURN INTEGER IS
606:
607: tMajorVersion cz_db_settings.value%TYPE;
608: tMinorVersion cz_db_settings.value%TYPE;
609: sMajorVersion cz_db_settings.value%TYPE;
610: sMinorVersion cz_db_settings.value%TYPE;
611:

Line 608: tMinorVersion cz_db_settings.value%TYPE;

604: ------------------------------------------------------------------------------------------------------------
605: FUNCTION compare_versions RETURN INTEGER IS
606:
607: tMajorVersion cz_db_settings.value%TYPE;
608: tMinorVersion cz_db_settings.value%TYPE;
609: sMajorVersion cz_db_settings.value%TYPE;
610: sMinorVersion cz_db_settings.value%TYPE;
611:
612: BEGIN

Line 609: sMajorVersion cz_db_settings.value%TYPE;

605: FUNCTION compare_versions RETURN INTEGER IS
606:
607: tMajorVersion cz_db_settings.value%TYPE;
608: tMinorVersion cz_db_settings.value%TYPE;
609: sMajorVersion cz_db_settings.value%TYPE;
610: sMinorVersion cz_db_settings.value%TYPE;
611:
612: BEGIN
613:

Line 610: sMinorVersion cz_db_settings.value%TYPE;

606:
607: tMajorVersion cz_db_settings.value%TYPE;
608: tMinorVersion cz_db_settings.value%TYPE;
609: sMajorVersion cz_db_settings.value%TYPE;
610: sMinorVersion cz_db_settings.value%TYPE;
611:
612: BEGIN
613:
614: BEGIN

Line 616: SELECT UPPER(value) INTO tMajorVersion FROM cz_db_settings

612: BEGIN
613:
614: BEGIN
615:
616: SELECT UPPER(value) INTO tMajorVersion FROM cz_db_settings
617: WHERE UPPER(section_name) = 'SCHEMA'
618: AND UPPER(setting_id) = 'MAJOR_VERSION';
619:
620: SELECT UPPER(value) INTO tMinorVersion FROM cz_db_settings

Line 620: SELECT UPPER(value) INTO tMinorVersion FROM cz_db_settings

616: SELECT UPPER(value) INTO tMajorVersion FROM cz_db_settings
617: WHERE UPPER(section_name) = 'SCHEMA'
618: AND UPPER(setting_id) = 'MAJOR_VERSION';
619:
620: SELECT UPPER(value) INTO tMinorVersion FROM cz_db_settings
621: WHERE UPPER(section_name) = 'SCHEMA'
622: AND UPPER(setting_id) = 'MINOR_VERSION';
623:
624: EXCEPTION

Line 633: EXECUTE IMMEDIATE 'SELECT UPPER(value) FROM cz_db_settings@' || dbLinkName ||

629: END;
630:
631: BEGIN
632:
633: EXECUTE IMMEDIATE 'SELECT UPPER(value) FROM cz_db_settings@' || dbLinkName ||
634: ' WHERE UPPER(section_name) = ''SCHEMA''' ||
635: ' AND UPPER(setting_id) = ''MAJOR_VERSION''' INTO sMajorVersion;
636:
637:

Line 638: EXECUTE IMMEDIATE 'SELECT UPPER(value) FROM cz_db_settings@' || dbLinkName ||

634: ' WHERE UPPER(section_name) = ''SCHEMA''' ||
635: ' AND UPPER(setting_id) = ''MAJOR_VERSION''' INTO sMajorVersion;
636:
637:
638: EXECUTE IMMEDIATE 'SELECT UPPER(value) FROM cz_db_settings@' || dbLinkName ||
639: ' WHERE UPPER(section_name) = ''SCHEMA''' ||
640: ' AND UPPER(setting_id) = ''MINOR_VERSION''' INTO sMinorVersion;
641:
642: EXCEPTION

Line 1487: INTO migrateConfigData FROM cz_db_settings

1483: BEGIN
1484: SELECT DECODE(UPPER(value), '1', 1, 'ON', 1, 'Y', 1, 'YES', 1,'TRUE', 1, 'ENABLE', 1,
1485: '0', 0, 'OFF', 0, 'N', 0, 'NO', 0,'FALSE', 0, 'DISABLE', 0,
1486: 0) --the default value.
1487: INTO migrateConfigData FROM cz_db_settings
1488: WHERE UPPER(section_name) = 'MIGRATE' and UPPER(setting_id) = 'MIGRATECONFIGDATA';
1489: EXCEPTION
1490: WHEN OTHERS THEN
1491: migrateConfigData := 0; --the default behaviour.

Line 1527: AND UPPER(dst_table) IN ('CZ_DB_SETTINGS', 'CZ_XFR_FIELDS');

1523: --CZ_XFR_FIELDS moved to the 'SLOWREFRESH' group, bug #3620255 (original #3283062).
1524:
1525: UPDATE cz_xfr_tables SET xfr_group = 'SLOWREFRESH'
1526: WHERE UPPER(xfr_group) = 'OVERRIDE'
1527: AND UPPER(dst_table) IN ('CZ_DB_SETTINGS', 'CZ_XFR_FIELDS');
1528:
1529: UPDATE cz_xfr_tables SET xfr_group = 'MIGRATE'
1530: WHERE UPPER(xfr_group) = 'OVERRIDE'
1531: AND UPPER(dst_table) = 'CZ_SERVERS';