APPS.CZ_PB_SYNC_UTIL SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 17

	SELECT cz_xfr_run_infos_s.NEXTVAL
	INTO   v_run_id
	FROM DUAL;

Line: 58

		SELECT fndnam_link_name
		INTO   v_db_link_name
		FROM   cz_servers
		WHERE  cz_servers.server_local_id = p_tgt_server_id;

Line: 80

	SELECT server_local_id
	INTO   v_tgt_server_id
	FROM   cz_servers
	WHERE  UPPER(cz_servers.local_name) = UPPER(LTRIM(RTRIM(p_target_instance)));

Line: 108

		OPEN gl_ref_cursor FOR 'SELECT COUNT(*) FROM cz_db_settings'||p_db_link_name ;

Line: 153

		OPEN	db_schema_compare_cur FOR '	select count(*)
							from	cz_db_settings,
								cz_db_settings'||v_db_link||' tgt
							where	cz_db_settings.setting_id = tgt.setting_id
							and	cz_db_settings.value = tgt.value
							and	cz_db_settings.setting_id = ''MAJOR_VERSION''
							INTERSECT
							select count(*)
							from	cz_db_settings,
								cz_db_settings'||v_db_link||' tgt
							where	cz_db_settings.setting_id = tgt.setting_id
							and	cz_db_settings.value = tgt.value
							and	cz_db_settings.setting_id = ''MINOR_VERSION'' ';

Line: 204

  SELECT module INTO l_module_name
  FROM   v$session
  WHERE  module IN ('CZ_PB_SYNC', 'CZ_PB_MGR');

Line: 237

	SELECT instance_name,hostname,db_listener_port
	INTO   l_instance_name,l_hostname,l_listener_port
	FROM   cz_servers
	WHERE  UPPER(cz_servers.local_name) = 'LOCAL';

Line: 242

	OPEN gl_ref_cursor FOR 'SELECT instance_name, source_server_flag
				   	FROM   cz_servers'||p_link_name||'  t
				   	WHERE  UPPER(t.local_name) = UPPER('''||l_instance_name||''')';

Line: 262

		l_msg := 'SELECT cz_servers_s.nextval from dual'||p_link_name;

Line: 263

		OPEN seq_ref_cursor FOR 'SELECT cz_servers_s.nextval from dual'||p_link_name;

Line: 270

		l_msg := 	'INSERT INTO cz_servers'||p_link_name||'
			 (server_local_id,local_name,hostname,db_listener_port,instance_name,import_enabled,source_server_flag)
		 SELECT '||l_server_local_id||',local_name,hostname,db_listener_port,instance_name,import_enabled,''1''
		 FROM   cz_servers where UPPER(cz_servers.local_name) = ''LOCAL'' ';

Line: 276

		'INSERT INTO cz_servers'||p_link_name||
		'	 (server_local_id,local_name,hostname,db_listener_port,instance_name,import_enabled,source_server_flag) ' ||
		' SELECT '||l_server_local_id||',instance_name,hostname,db_listener_port,instance_name,import_enabled,''1'' ' ||
		' FROM   cz_servers where UPPER(cz_servers.local_name) = ''LOCAL'' ';