APPS.CZ_MIGRATE dependencies on DUAL

Line 108: EXECUTE IMMEDIATE 'SELECT SYSDATE FROM DUAL@' || p_link_name;

104: FUNCTION verify_database_link(p_link_name IN VARCHAR2)
105: RETURN INTEGER IS
106: BEGIN
107:
108: EXECUTE IMMEDIATE 'SELECT SYSDATE FROM DUAL@' || p_link_name;
109: RETURN NO_ERROR;
110:
111: EXCEPTION
112: WHEN OTHERS THEN

Line 135: SELECT cz_xfr_run_infos_s.NEXTVAL INTO x_run_id FROM DUAL;

131: NoIntegrityCheck := FALSE;
132:
133: BEGIN
134: IF(x_run_id IS NULL OR x_run_id = 0)THEN
135: SELECT cz_xfr_run_infos_s.NEXTVAL INTO x_run_id FROM DUAL;
136: END IF;
137: thisRunId := x_run_id;
138: EXCEPTION
139: WHEN OTHERS THEN

Line 254: SELECT 'MIGRATE', 'SourceServer', 4, p_local_name FROM DUAL WHERE NOT EXISTS

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:
258: UPDATE cz_db_settings SET value = p_local_name

Line 262: SELECT 'MIGRATE', 'MigrationStatus', 4, 'INSTALLED' FROM DUAL WHERE NOT EXISTS

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:
266: UPDATE cz_db_settings SET value = 'INSTALLED'

Line 322: SELECT cz_xfr_run_infos_s.NEXTVAL INTO x_run_id FROM DUAL;

318: NoIntegrityCheck := TRUE;
319:
320: BEGIN
321: IF(x_run_id IS NULL OR x_run_id = 0)THEN
322: SELECT cz_xfr_run_infos_s.NEXTVAL INTO x_run_id FROM DUAL;
323: END IF;
324: thisRunId := x_run_id;
325: EXCEPTION
326: WHEN OTHERS THEN

Line 1409: EXECUTE IMMEDIATE 'SELECT ' || CONFIGURATOR_SCHEMA || '.' || sequenceName || '.NEXTVAL FROM DUAL' INTO nextValue;

1405: return NO_ERROR;
1406: END IF;
1407:
1408: BEGIN
1409: EXECUTE IMMEDIATE 'SELECT ' || CONFIGURATOR_SCHEMA || '.' || sequenceName || '.NEXTVAL FROM DUAL' INTO nextValue;
1410:
1411: IF(SIGN(p_increment) * (nextValue - nMaximum) < 0)THEN
1412:
1413: EXECUTE IMMEDIATE 'ALTER SEQUENCE ' || CONFIGURATOR_SCHEMA || '.' || sequenceName || ' INCREMENT BY ' || (p_increment * CEIL(ABS((nextValue - nMaximum) / p_increment)));

Line 1414: EXECUTE IMMEDIATE 'SELECT ' || CONFIGURATOR_SCHEMA || '.' || sequenceName || '.NEXTVAL FROM DUAL' INTO nextValue;

1410:
1411: IF(SIGN(p_increment) * (nextValue - nMaximum) < 0)THEN
1412:
1413: EXECUTE IMMEDIATE 'ALTER SEQUENCE ' || CONFIGURATOR_SCHEMA || '.' || sequenceName || ' INCREMENT BY ' || (p_increment * CEIL(ABS((nextValue - nMaximum) / p_increment)));
1414: EXECUTE IMMEDIATE 'SELECT ' || CONFIGURATOR_SCHEMA || '.' || sequenceName || '.NEXTVAL FROM DUAL' INTO nextValue;
1415: EXECUTE IMMEDIATE 'ALTER SEQUENCE ' || CONFIGURATOR_SCHEMA || '.' || sequenceName || ' INCREMENT BY ' || p_increment;
1416: END IF;
1417: EXCEPTION
1418: WHEN OTHERS THEN